Adoptable shop new version! [UPDATED!]

[mapleblade]

is this from your new register.php?

if so youst add ,'' so ti would be:

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','','','')");

 

[SieghartZeke]

Yay!!!!! Now Work!!!
Ehm a other question, for show the total monay on the Sidebar??Like this:

Manage Character
"Your Money 450"

---

Ahh...and how change the money when you register?
"Like: You regesiter in the site and receive 1500 Coins"

 

[mapleblade]

where you did put ,'' change that to ,'1500' then, it puts 1500 coins ni then.

---

Oh and ill make an code dto msee your coins

 

[SieghartZeke]

Uhm...I Dont want touch the register code...or i make a disaster!!!

 

[mapleblade]

Okay

Find:

$sidebar = "<b><u>".$loggedinname."'s Links:</u></b><br><br>

And put this ABOVE that

$query222 = "SELECT * FROM ".$prefix."users WHERE username = '$loggedinname'";
$result222 = @mysql_query($query222);
$num222 = @mysql_numrows($result222);

//Loop out code
$i=0;
while ($i < 1) {

$coins=@mysql_result($result222,$i,"coins");

$i++;
}

Then at last you add the line that really shows it.

Somewhere you want it in the text of your sidebar put this:

You currenty have $coins Coins.<br>

---

lol, ill make it again for you

mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','','','1500')");

 

[SieghartZeke]

Awwww...I have a other error!!!
Parse error: syntax error, unexpected T_STRING in /home/a2394530/public_html/inc/functions.php on line 239

---

Oh and this error came only when i put the "You currenty have $coins Coins.<br> "
What the problem??? =_=""

---

And sorry if i bother you---But how i can put an image of the coin when you level up a pet?

 

[mapleblade]

oh change $coins to ".$coins."
if that shows errror
'.$coins.'

---

BTW for the image, just find Price: in the adopt.php and put <img src="img link"> before it.

 

[SieghartZeke]

Ok...All work....the only last problem is...when i go to create i pet, it doesnt create this!!

 

[mapleblade]

it only creates in your own shop heh?

so usershop.php?user=yourname

 

[SieghartZeke]

Ops... Wrong places....i Was talking of the "Adoptable Shop"

---

Oh Wait...
When i go to the admin.php, i make all thing for create adoptable, and when say that i have succesfull created pet, and i click "Add a new level" Say that the adoptable id doesn't exist!""

 

[mapleblade]

u have added the 'price' at the end of the adoptables table?

 

[gensuperman]

Well, this code wouldn't work for me,

I added the SQL info as per first post within my SQL Query on my site, and that added fine, and then I uploaded/overwrote the files needed as per your zipped file in the first post of this thread.

After testing, I found that any new adoptable that I create will not show up on the adopt page, it still will only show the old adoptable.

Also, existing adoptable dont show a price, although has the word price under their image.

Not sure what I'm doing wrong, but, I can't create any new adoptable now and if I try and buy one, then it says I dont have enough coins.

 

[SieghartZeke]

I Have the same problem....°_°

---

u have added the 'price' at the end of the adoptables table?

Ehm no....what code i need to create??

---

Omg....Im a Idiot...Added the table and now...WORK!!!!!!!!! XD

 

[mapleblade]

maybe saame for above, you added price table at adoptables or shop adoptables table AT THE END?

 

[gensuperman]

maybe saame for above, you added price table at adoptables or shop adoptables table AT THE END?

Its kinda difficult to understand you... are you saying to add the SQL information to the SQL Query? I have already done that and this still doesn't work. I have even updated the price and coins within that SQL Query(s) and it still didn't matter.

The issue I am having isn't about price or coins. After I upload the adoptable shop files to my server, I then try and create an adoptable within the admin area, and I add a PRICE within that adoptables creation. However, after I create it, the adoptable never shows up in the list of options for choosing to adopt. It is almost as if, the adoptable was never created to begin with.

This is a very odd bug... which I believe points back to the SQL Query's that you are having people add to their server SQL database... there must be something that is getting Null(ed) that shouldn't.

Basically, I'm going to have to re-install this script each and every time to a new SQL database until I can figure out which setting is causing this.

As for adding price to the end of something... I must be overlooking what you are suggesting, as I can't find it... Frankly, I believe that I have followed the steps precisely as you have written them.

Can anyone please assist me with this and let me know what steps they took to get this working?

 

[mapleblade]

uhm.... you sure you have uplaoded the right files?, and if so? do you have any other tables in your adoptables table that may cause an problem, like gender?

 

[redheadturkey]

Are you looking for the new adoptable in the right place -- it will not show up in the usual places, but only in the usershop itself ---- it wont show up in the regular shop, or the normal place to get a pet to adopt.

I am using it on my site, you can take a look there if you wish


Click on Customs in the top menu once you reg .......

 

[Tequila]

Locking this do to a necro post. :3