MySQL Adding Offer to Shop [Gesior ACC]

[bury]

Hello, one question. Anybody know how to re-orden the items? Changing the id is useless....

 

[Xivin]

Hello, one question. Anybody know how to re-orden the items? Changing the id is useless....

they should be in a list according to how you have them in database

 

[bury]

they should be in a list according to how you have them in database

Yeah, I added like 30 items to the database. Now I want to reorder it in database and I dont know how. If I change the id, the order is the same. The only thing I could do is remove all and start the list as I want.

Any other opcion?

 

[Xivin]

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.

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

can you explain how to add a container with this like a brocade bp with 100 mino leather, 50 honey comb etc thanks

 

[Xivin]

bump

 

[danne3131]

Yea, how to adds mounts? Ive changed shop lua and made a mount offer type..

 

[hellyea]

Worked for me dude, thanks for the short but very easy tutorial