HubsInfo Network
Login or Register to remove ads! You're browsing our forum and website as a Guest meaning you can only see a portion of the forum in read-only mode.
PHP MySQL Linux Material Design Web Hosting Online Games SimCity BuildIt

Usefull querys for DB


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