Windows !shop talkaction

[Oldschool'er]

so im trying to find !shop talkaction and i found this thread

http://otland.net/threads/znote-shop-system.190559/#post-2057925

the script in it doesnt work, so one said it was solved, can someone help me? i have the script but it says "you have no orders" when i purchased 3x on the site

 

[czarnowidz]

Check your database. Do you have any records in `znote_shop_orders` table? Maybe your website is sending shop commands somewhere else?

 

[Oldschool'er]

Check your database. Do you have any records in `znote_shop_orders` table? Maybe your website is sending shop commands somewhere else?

yeah i got znote orders in the sql, it just keeps telling me i have no orders

 

[Znote]

When player buy items on website, the website will add items to znote_shop_orders in database.
Player who use !shop talkaction will then fetch item from znote_shop_orders database table.

Make sure you use correct LUA script that fits your OT server.
https://github.com/Znote/ZnoteAAC/tree/master/LUA
Make sure script is for correct TFS version.

 

[Oldschool'er]

i get this error ;(

[11/05/2014 02:49:16] mysql_real_query(): SELECT `id`, `type`, `itemid`, `count` FROM ` znote_shop_orders ` WHERE `account_id` = 4 LIMIT 999; - MYSQL ERROR: Incorrect table name ' znote_shop_orders ' (1103)

i also added znote_shop_orders...

Edit: i used the talkaction script with the link you gave me, it didnt even work

 

[Znote]

Make sure config.php (website) connect to same database as config.lua (OT serv)

And make sure that database have znote_shop_orders.

 

[Oldschool'er]

Make sure config.php (website) connect to same database as config.lua (OT serv)

And make sure that database have znote_shop_orders.

i also added znote_shop_orders...

i just need the script! its TFS 0.3.6