FunServer SQL Queries and Useful Queries

Nesquek — Tue, 08 Jun 2010 17:40:57 GMT

Кароче я на англиском все.. с русским пробелма smile

To remove profession skill rank

Quote
update items set requiredskillrank = 0

This will only require your players to learn a profession to use or enchant items.

To remove Faction requirements
Quote

Update items set requiredfaction = 0

Maintenance Queries

To delete accounts no longer used (select your won date)
Change -wow- to the name of your database

Quote
DELETE FROM `wow`.`accounts` WHERE `lastlogin` < '2009-01-15 00:00:00';

List of all the mobs without model.

SELECT `entry` FROM `creature_proto` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_spawns`);

List of items that have bigger sell price then buy price.
Quote

Quote

select * from `items` where `BuyPrice`<`SellPrice`;

WoW OnLiNe PortaL