This is a noob (my first) tutorial explaining how to add a shop offer to your Gesior ACC database. Most experienced players already know this, but this is how you add offer types to your shop, to trade for points. That is ALL this tutorial explains, please find another that answers how to set up
shopsystem.php ect. This is
ONLY for the
phpmyadmin part for adding new shop offers!!!
Start by entering your database:
http://localhost/phpmyadmin
If you have z_shop_offer in your database, use the SQL button, paste this information, and then click "Go". (You will want to continue this until all of your items are made,
Making sure that the `id` is ONE higher every time you submit it! Afterward, you should see a new table.
Code:
INSERT INTO `z_shop_offer` (`id`, `points`, `itemid1`, `count1`, `itemid2`, `count2`, `offer_type`, `offer_description`, `offer_name`) VALUES
(1, 5, 2517, 1, 0, 0, 'item', 'Buy a shield of honour!', 'Shield of Honour');
`id` = Unique ID of the item. These go up in intervals of 1,
each item has to be different. (ex. 1, 2, 3, 4, 5)
`points` = How many points it will cost
`itemid1` = The ID of the item
`count1` = How many of the item (ID above) do you wish to receive
`itemid2` = Set to 0, you wont use this unless you are selling backpacks of items
`count2` = Same as above
`offer_type` = The type of offer you're giving away. This one is obviously, one item, so keep it as `item`.
`offer_description` = The description on the website. What you want to advertise about the item.
`offer_name` = Name of the item on the website
Edit the tables as needed, and it should appear in your shop, as seen below:
(obviously that was made for my server specifically) :blink:
All I ask is that if I helped you, you let me know by repping. I won't beg, ONLY if you think I deserve it
Red