HubsInfo Network
Social PHP Linux Material Design Web Hosting Online Games SimCity BuildIt

Usefull querys for DB

0 Members and 1 Guest are viewing this topic.

Usefull querys for DB
« on: May 24, 2014, 05:51:41 AM »
Usefull querys for DB

SELECT * FROM creature_template WHERE entry = "500108";  //Select a creature template and change his DisplayID or create a new one.
SELECT * FROM npc_vendor WHERE entry = "500108" AND item = "45205";  //Select a NPC vendor and an item fro that vendor or create a new item.
SELECT * FROM item_template WHERE name = "greatsword of the sin'dorei";  //Select an item.

 


Linux Ubuntu Guides Linux games - Lutris.net