Donation items.

[Minimii]

How can I add donation items? I've read the geisor tutorial but I don't really understand,

Is it like this?

(NULL , '2', '3955', '1', '0', '0', 'item', 'Buy Outfit Changer!', 'Change your outfit to over 50 monster outfits simply by clicking on this Voodoo-Doll!');

or like this?

id - empty (auto_increment)
points - 2
itemid1 - 3955
count1 - 1
offer_type = "item"
offer_description - Change your outfit to over 50 monster outfits simply by clicking on this Voodoo-Doll!
offer_name - Outfit Changer

And where in the database should I execute it?

 

[andurz]

How can I add donation items? I've read the geisor tutorial but I don't really understand,

Is it like this? or like this? And where in the database should I execute it?

I think you can use both
You should execute this in "z_shop_offer"

Btw use

(NULL , '2', '3955', '1', '0', '0', 'item', 'Buy Outfit Changer!', 'Change your outfit to over 50 monster outfits simply by clicking on this Voodoo-Doll!');

If you want to insert it by the SQL Icon

If you want to use the other example you need to press on insert and add the ID's and names

 

[Minimii]

I think you can use both
You should execute this in "z_shop_offer"

Btw use

(NULL , '2', '3955', '1', '0', '0', 'item', 'Buy Outfit Changer!', 'Change your outfit to over 50 monster outfits simply by clicking on this Voodoo-Doll!');

If you want to insert it by the SQL Icon

If you want to use the other example you need to press on insert and add the ID's and names

Still don't really know "what to do and how to do it" :S

EDIT: When I execute #example 1 aka the one that you recommended me to use I get this error message

 

[andurz]

Goto 127.0.0.1/phpmyadmin -> login -> press on your database name -> Check at the list and look for z_shop_offer -> click on it and look for the icon that say SQL -> Now write in this

(NULL , '2', '3955', '1', '0', '0', 'item', 'Buy Outfit Changer!', 'Change your outfit to over 50 monster outfits simply by clicking on this Voodoo-Doll!');

-> then press on Go

 

[Master-m]

go to your phpmyadmin->your DB->z_shop_offer?->press the sql button and insert it.
edit: lol to late >.>

 

[Minimii]

Getting error message when I do that.

Check my post above if you want to see it with screenshot.

 

[andurz]

Getting error message when I do that.

Check my post above if you want to see it with screenshot.

Try using the other method, insert it manuely

 

[Minimii]

Try using the other method, insert it manuely

How do I do that?

 

[Master-m]

I think the query = fail.

 

[Minimii]

I think the query = fail.

How should it look like then?=P I dont know how im supposed to do this thats why im asking x)

 

[Master-m]

Have you even looked in the thread? I just did and saw this:

INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '10', '0', '12', '0', '0', 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC'
), (NULL , '40', '5890', '50', '0', '0', 'item', 'Buy 50 Chicken Feathers!', '50x Chicken Feather'
), (NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor')

 

[Minimii]

Have you even looked in the thread? I just did and saw this:

INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES (NULL , '10', '0', '12', '0', '0', 'pacc', 'Buy 12 days of premium account for yourself or your friend!', '12 Days of PACC'
), (NULL , '40', '5890', '50', '0', '0', 'item', 'Buy 50 Chicken Feathers!', '50x Chicken Feather'
), (NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor')

Yea I have but I still don't understand what I shall replace and remove and shit.

 

[Master-m]

INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES [B](NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor')[/B]

only edit the bold line.

 

[Minimii]

INSERT INTO `z_shop_offer`(`id`,`points`,`itemid1` ,`count1` ,`itemid2` ,`count2` ,`offer_type` ,`offer_description` ,`offer_name`)
VALUES [B](NULL , '100', '2466', '1', '1987', '8', 'container', 'Buy bag with 8 Golden Armor! Become a rich mother fucker!', '8x Golden Armor')[/B]

only edit the bold line.

Thanks mate, that was the answer I was looking after. x)