Currency for leveling up / Adoptable shop (Fixed again)

[mattalien]

Im getting the same error as well, It has to be because of the 'egg' part.

[gjac1]

i think a "kind" and "cost" row has to be added to the adoptables table......

[mattalien]

yeah, i'll try it.

EDIT: YES! I did it! you have to add a 'kind' column to the table 'adoptables'. then when you add the adoptable, you use this query:

INSERT INTO adoptables VALUES ('', 'name','level 0 image','shop','cost','kind')

then go to the shop.php file, and find this:

$query = "SELECT * FROM adoptables WHERE kind = 'egg' LIMIT 0,5";

change the 'egg' bit to what ever you put in the 'kind' bit of the query. :)

The adoptable still appears in the adoption page, but i will look and try to fix this.

NEW EDIT: Fixed that too! in the database, go to the 'adoptables' table, and in the adoptables you want in the offcial adoption place, set their kind to something like, 'adoptable'.

then, in adopt.php, find this line:

$query = "SELECT * FROM adoptables"

and change it to this:

$query = "SELECT * FROM adoptables WHERE kind = 'adoptable'";

change the 'adoptable' to whatever you set in the 'kind' area for the official adoptables.

:)

[gjac1]

Thats what i did too, and changed the "egg" to "shop" and the "full" to "shop2"

The creator of this mod must have forgotten to post the bit about adding the new rows to the adoptables table as well....

[rosepose]

Erm... How exactly do you add the column?

[Ashje]

@ rosepose:

Click here:

Then fill it in like this:

And click Save.

Thanks mattalien, everything works perfectly now. =)

[kisazeky]

Ok, with the update, there is now no need to add new columns. It adds "shop" to the "memberlevel" column and the cost to the "description" table.

Also this is a more secure buying method so people cannot get them for free.

[densaugeo]

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

[zhiichiro]

we now have the shop.. thanks

visit : fresbopet.netau.net to see

[Ashje]

Originally Posted by densaugeo

I still don't get how to add a pet to the shop :P Heh, i've looked over the files..but I'm not sure what to change or add...

Don't add or change anything. Just run the SQL Queries in Post 43.

Originally Posted by kisazeky

Ok, with the update, there is now no need to add new columns. It adds "shop" to the "memberlevel" column and the cost to the "description" table.

Also this is a more secure buying method so people cannot get them for free.

How is it safer? It is much easier to add a kind column with the old one. Anyways, thanks for the buyconfirm. =)

EDIT:
buyconfirm doesn't work, the new shop file doesn't work (it screws up the template and when you buy something, nothing appears on the page...