[Release] Usefull Database Queries menu
Follow us:

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 15 of 29
  1. 11-12-2007 #1
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski

    [Release] Usefull Database Queries

    SELECT Queries are a great way to detect bugs in the database, Here we will make a list.

    Creatures

    Code:
    select * from creature_proto where maxhealth < minhealth ;
    Code:
     

    select * from creature_proto where maxlevel < minlevel; 

select * from creature_proto where maxdamage < mindamage';
    A maximum value should not be less than the minimum.

    Code:
    select * from creature_names where displayid = 0;
    List of all the mobs without model.
    Code:
    SELECT `entry` FROM `creature_proto` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_spawns`);
    List of all creatures that exist in creature_proto but not spawned in the world.
    Code:
    SELECT `entry` FROM `creature_spawns` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_proto`);
    List of all the creatures that are spawned in the world but not exist in proto table.
    Code:
    SELECT * FROM creature_waypoints WHERE NOT creatureid IN(SELECT id FROM creature_spawns);
    List of none Existing waypoints
    Items
    Code:
    select * from `items` where `BuyPrice`<`SellPrice`;
    List of items that have bigger sell price then buy price.



    Quests
    Code:
    drop table if exists tmp;


    Code:
     

    CREATE TEMPORARY TABLE tmp ENGINE=memory SELECT quest FROM creature_quest_finisher; 

INSERT INTO tmp SELECT quest FROM gameobject_quest_starter; 

    INSERT INTO tmp SELECT quest FROM gameobject_quest_finisher; 
INSERT INTO tmp SELECT quest_id FROM items; 
alter table tmp add index quest(quest); 
drop table if exists orphans; 
CREATE TABLE orphans ENGINE=myisam SELECT entry, title FROM quests WHERE NOT entry in (select * from tmp); 
ALTER TABLE orphans ADD INDEX (entry), ADD PRIMARY KEY (entry);
    List of quests without quest creature/gameobject/item starter/finisher.("Orphan quests").


    Misc
    Code:
    SELECT * FROM gameobject_spawns WHERE NOT entry IN (SELECT entry FROM gameobject_names);
    List of gameobjects that spawned but not exists.
    Code:
    SELECT * FROM gameobject_names WHERE displayId=0;
    List of gameobjects without model



    1. ReqItem - checks iff the field are both filled in. (2 codes in here to check it both ways)
    Code:
     SELECT entry FROM quests WHERE (ReqItemId1=0 AND ReqItemCount1>0) OR (ReqItemId2=0 AND ReqItemCount2>0) OR (ReqItemId3=0 AND ReqItemCount3>0) OR (ReqItemId4=0 AND ReqItemCount4>0);


    Code:
     

    SELECT entry FROM quests WHERE (ReqItemCount1=0 AND ReqItemId1>0) OR (ReqItemCount2=0 AND ReqItemId2>0) OR (ReqItemCount3=0 AND ReqItemId3>0) OR (ReqItemCount4=0 AND ReqItemId4>0);
    2 SrcItem - checks iff the field are both filled in. (2 codes in here to check it both ways)

    Code:
    SELECT entry FROM quests WHERE SrcItem=0 AND SrcItemCount>0; 

    SELECT entry FROM quests WHERE SrcItemCount=0 AND SrcItem>0;
    Update !
    a query to search for an item to see wich players have that item... for example you wanna know who has "hearthstone" then you can use this handy query:
    Code:
    SELECT `characters`.`name` as Char_name, `items`.`name`, `playeritems`.`count` FROM `characters`, `playeritems`, `items` WHERE `characters`.`guid` = `playeritems`.`ownerguid` AND `playeritems`.`entry` = `items`.`entry` AND `items`.`name` LIKE '%hearthstone%';
    change the red part to whatever you wanna search for.... you will get a list of people who have that item

    Delete all unused accounts since a date you chose... change the date and time (in red) to whatever you like
    Code:
    -- Delete all accounts which have not been online for some period of time
DELETE FROM `ACCTDATABASE`.`accounts` WHERE `lastlogin` < '2007-04-15 00:00:00';

-- You have to change CHARDATABASE or  ACCDATABASE to the names of your char/acc database!
-- Delete all characters which have no corresponding account
DELETE FROM `CHARDATABASE`.`characters` WHERE `acct` NOT IN (SELECT `acct` FROM `ACCTDATABASE`.`accounts`);
DELETE FROM `CHARDATABASE`.`playeritems` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`tutorials` WHERE `playerId` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`social` WHERE `guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`questlog` WHERE `player_guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`corpses` WHERE `guid` NOT IN (SELECT `guid` FROM `CHARDATABASE`.`characters`);
DELETE FROM `CHARDATABASE`.`mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `CHARDATABASE.`characters`);
    Ok here a query where you have to type in a character name and you will see all items he has!:
    playeritems.entry
    Code:
    SELECT characters.name as 'character', items.name1 as 'has_items', playeritems.count FROM items, characters, playeritems WHERE=items.entry AND characters.name LIKE '%Charname%';
    change the red part to the charactername you wanna check !

    [Next one is from Kard, rep him by pressing here: +Rep]
    ok this takes the level for mounts and riding skils to 6 - 13 - 19 for twink funservers and changes the price to 50 100 500 1000 gold for the trainings:
    Code:
    update items set RequiredSkillRank = '75' where entry = '5874';
update items set requiredlevel = '13' where entry = '21176';

update items set flags = '64' where entry = '21218';
update items set flags = '64' where entry = '21176';
update items set flags = '64' where entry = '21321';
update items set flags = '64' where entry = '21323';
update items set flags = '64' where entry = '21324';

update items set RequiredFaction = '0' where Requiredskill = '762';
update items set RequiredFactionStanding = '0' where Requiredskill = '762';

update items set Requiredlevel = '6' where Requiredskill = '762' and RequiredSkillRank = '75';
update items set Requiredlevel = '13' where Requiredskill = '762' and RequiredSkillRank = '150';
update items set Requiredlevel = '13' where Requiredskill = '762' and RequiredSkillRank = '225';
update items set Requiredlevel = '19' where Requiredskill = '762' and RequiredSkillRank = '300';
update items set allowableclass = '-1' where Requiredskill = '762';
update items set allowablerace = '-1' where Requiredskill = '762';

update trainer_spells set spellcost = '500000' where cast_spell = '33389';
update trainer_spells set spellcost = '1000000' where  cast_spell = '33392';
update trainer_spells set spellcost = '5000000' where  cast_spell = '34092';
update trainer_spells set spellcost = '10000000' where  cast_spell = '34093';

update trainer_spells set reqlevel = '6' where  cast_spell = '33389';
update trainer_spells set reqlevel = '13' where  cast_spell = '33392';
update trainer_spells set reqlevel = '13' where  cast_spell = '34092';
update trainer_spells set reqlevel = '19' where  cast_spell = '34093';



    This removes all requirements for mounts:
    Code:
    update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =2411); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =2414); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5655); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5656); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5665); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5668); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5864); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5872); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5873); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5874); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8563); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8586); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8588); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8591); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8592); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8595); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8629); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8631); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8632); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12302); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12303); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12330); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12351); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12353); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12354); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13086); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13317); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13321); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13322); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13325); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13326); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13327); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13328); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13329); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13331); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13332); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13333); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13334); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13335); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15277); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15290); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15292); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15293); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18241); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18242); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18243); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18244); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18245); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18246); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18247); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18248); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18766); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18767); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18772); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18773); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18774); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18776); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18777); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18778); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18785); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18786); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18787); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18788); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18789); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18790); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18791); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18793); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18794); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18795); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18796); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18797); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18798); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18902); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19029); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19030); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19872); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19902); 
update items set buyprice = 4000000, sellprice = 800000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21176); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21218); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21321); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21323); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21324); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25470); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25471); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25472); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25473); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25474); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25475); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25476); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25477); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25527); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25528); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25529); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25531); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25532); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25533); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28481); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28915); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28927); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28936); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29102); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29103); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29104); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29105); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29220); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29221); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29222); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29223); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29224); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29227); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29228); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29229); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29230); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29231); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29465); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29466); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29467); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29468); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29469); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29470); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29471); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29472); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29743); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29744); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29745); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29746); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29747); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =30480); 
update items set sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =30609); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31829); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31830); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31831); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31832); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31833); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31834); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31835); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31836); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32314); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32316); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32317); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32318); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32319); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32458); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32768); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32857); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32858); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32859); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32860); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32861); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32862); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33224); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33225); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33176); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33182); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33184); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33183); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33976); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33977);
    Update 16-12-06 01.01am
    More of me:
    Query that shows all your GMs:
    Code:
    SELECT accounts.login as 'account_name', characters.name as 'char_name', accounts.gm as 'GMlevel' FROM accounts, characters WHERE accounts.acct = characters.acct AND accounts.gm IN ('az','a');
    Query to remove tokens from tiersets and add buy/sell price instead, note: you can define the buy/sellprice and you must enter the tierset name part... like: of the corruptor:
    Code:
    UPDATE items SET ItemExtendedCost = 0, buyprice = 1000000, sellprice = 500000 WHERE requiredlevel=70 AND quality=4 AND name1 LIKE '%of the Corruptor%';
    Remove all class/race requirements from all items:
    Code:
    UPDATE items SET allowableclass = '-1', allowablerace = '-1';
    Query that shows ALL mounts in your DB...
    Code:
    SELECT entry, name1 FROM items WHERE requiredskill = 762;
    Query to see ALL gold all accounts have:
    Code:
    SELECT accounts.login, SUM(characters.gold) FROM accounts, characters WHERE characters.acct = accounts.acct AND accounts.login LIKE '%%' GROUP BY accounts.login;
    if you wanna check for 1 account then put the accountname between the '%%' like this for example: '%latruwski%'

    A query to show all skills a character has:
    Code:
    SELECT name, skills, spells FROM characters WHERE name = 'namehere';

    change namehere with the charactername you wanna check!
    note you will get something like this then:
    Code:
    +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name  | skills                                                                                                                                                                                                                        | spells                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Aovas | 44;350;350;54;350;350;95;350;350;118;350;350;136;350;350;142;1;1;160;350;350;162
;350;350;172;350;350;173;350;350;183;5;5;373;5;5;374;5;5;375;5;5;413;350;350;414;
1;1;415;1;1;433;1;1;473;350;350;760;5;5;762;300;300;769;5;5; | 81,107,131,196,197,198,199,203,204,227,324,325,331,332,370,403,421,522,526,529,5
46,547,548,556,668,669,670,671,672,674,813,905,913,915,930,939,943,945,959,974,10
64,1180,1535,2008,2062,2382,2479,2484,2645,2860,2870,2894,3050,3365,3599,3738,539
4,5675,5730,6041,6196,6233,6246,6247,6363,6364,6365,6375,6377,6390,6391,6392,6477
,6478,6495,6603,7266,7267,7341,7355,8004,8005,8008,8010,8012,8017,8018,8019,8024,
8027,8030,8033,8038,8042,8044,8045,8046,8050,8052,8053,8056,8058,8071,8075,8134,8
143,8154,8155,8160,8161,8166,8170,8177,8181,8184,8190,8227,8232,8235,8249,8386,84
98,8499,8512,8737,8835,9077,9078,9116,9125,10391,10392,10395,10396,10399,10406,10
407,10408,10412,10413,10414,10427,10428,10431,10432,10437,10438,10442,10447,10448
,10456,10462,10463,10466,10467,10468,10472,10473,10478,10479,10486,10495,10496,10
497,10526,10537,10538,10585,10586,10587,10595,10600,10601,10605,10613,10614,10622
,10623,10627,11314,11315,15107,15111,15112,15207,15208,15590,16089,16108,16112,16
116,16120,16130,16161,16164,16166,16188,16189,16190,16198,16208,16209,16213,16217
,16221,16225,16229,16234,16240,16268,16274,16284,16287,16291,16293,16295,16301,16
305,16309,16314,16315,16316,16339,16341,16342,16355,16356,16362,16387,16544,16582
,17364,17489,17737,18848,20579,20608,20609,20610,20776,20777,21651,21652,22027,22
810,24398,25357,25359,25361,25391,25396,25420,25422,25423,25439,25442,25448,25449
,25454,25457,25464,25469,25472,25479,25485,25489,25500,25505,25508,25509,25525,25
528,25533,25546,25547,25552,25557,25560,25563,25567,25570,25574,25577,25585,25587
,25908,27763,28875,28878,28880,28998,29000,29065,29080,29088,29180,29191,29193,29
202,29228,29932,30668,30671,30674,30681,30706,30798,30811,30814,30819,30823,30866
,30869,30873,30886,32593,32594,33388,33391,33736,34090,34091,36591,36936,43338, |
+-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    so easy to understand: skillID skill maxskill

    Query to remove ALL requirements from ALL items except: levelrequirement and cloth/leather/mail/plate and one-handed/two-handed and mace/staff/wand/axe etc...
    Code:
    UPDATE items SET allowableclass=-1, allowablerace=-1, RequiredSkill=0, RequiredSkillRank=0, RequiredSkillSubRank=0, RequiredPlayerRank1=0, RequiredPlayerRank2=0, RequiredFaction=0, RequiredFactionStanding=0, ReqDisenchantSkill=0;



    I am collecting as much usefull queries as possible for people here....


    I want to use this topic as a general "Handy Queries" topic... all members can post their own handy queries here... i will add them to the first post



    Please submit your own SELECT queries(for future uses).


    PART 2:
    http://www.mmowned.com/forums/emulat...-part-2-a.html

    Last edited by latruwski; 03-20-2008 at 07:08 AM.
    Reply With Quote Reply With Quote
    [Release] Usefull Database Queries
  2. 11-13-2007 #2
    777devil777's Avatar
    777devil777
    777devil777 is offline
    Member
    Reputation
    66
    Join Date
    Sep 2007
    Posts
    396
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Useful SELECT queries to "Track" bugs

    Took me a lil bit to notice it's usefullness. Very nice as always. I would rep you but I need to spread it around.

    "I am a hacker, and this is my manifesto. You may stop this individual, but you can't stop us all... after all, we're all alike."
    Reply With Quote Reply With Quote
  3. 11-13-2007 #3
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski

    Re: Useful SELECT queries to "Track" bugs

    thx for the comment... if you have usefull queries yourself pls post them, i will put them in the first post with creds for you

    grtz
    Reply With Quote Reply With Quote
  4. 11-14-2007 #4
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski

    Re: Useful SELECT queries to "Track" bugs

    hmm i am sure some of you gusy have more... post them if you wanna share pls

    grtz
    Reply With Quote Reply With Quote
  5. 11-14-2007 #5
    777devil777's Avatar
    777devil777
    777devil777 is offline
    Member
    Reputation
    66
    Join Date
    Sep 2007
    Posts
    396
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Re: Useful SELECT queries to "Track" bugs

    Is there a query to select and spawned game objects with the same x y z position? Im pretty sure I was something like it earlier, would help with removing lag.

    "I am a hacker, and this is my manifesto. You may stop this individual, but you can't stop us all... after all, we're all alike."
    Reply With Quote Reply With Quote
  6. 12-14-2007 #6
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    Updated
    Reply With Quote Reply With Quote
  7. 12-14-2007 #7
    Nightstelth's Avatar
    Nightstelth
    Nightstelth is offline
    Member
    Reputation
    4
    Join Date
    Nov 2007
    Posts
    66
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nice Work +rep
    Reply With Quote Reply With Quote
  8. 12-15-2007 #8
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    Originally Posted by Nightstelth View Post
    Nice Work +rep
    thx i really should change the thread title;.. i am gonna ask a mdo ^^


    grtz
    Reply With Quote Reply With Quote
  9. 12-15-2007 #9
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    thx to Flying Piggy for changing thread name !

    grtz
    Reply With Quote Reply With Quote
  10. 12-15-2007 #10
    Tom_2001's Avatar
    Tom_2001
    Tom_2001 is offline
    Member
    Reputation
    177
    Join Date
    Oct 2007
    Posts
    609
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to Tom_2001
    This hasnt helped me but +rep 1 for Contributing!
    Reply With Quote Reply With Quote
  11. 12-15-2007 #11
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    Updated again...
    things that have been added lately:
    ->Search for an item and get a list of players who have the item
    ->Delete accs that haven't been used since <date> you can chose date
    ->Search for a character and get a list of items he has

    3 usefull things ^^

    grtz
    Reply With Quote Reply With Quote
  12. 12-15-2007 #12
    Viter's Avatar
    Viter
    Viter is offline
    Elite User
    Reputation
    410
    Join Date
    Aug 2007
    Posts
    2,153
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Latruwski this thread is nice ^^
    +rep x2


    Reply With Quote Reply With Quote
  13. 12-15-2007 #13
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    Originally Posted by Viter View Post
    Latruwski this thread is nice ^^
    +rep x2
    thx, i am gonna update with more queries as much as i can ^^

    grtz
    Reply With Quote Reply With Quote
  14. 12-15-2007 #14
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    updated with one of my querys to remove all mount requirements and with a query submitted by Kard (rep button is added to rep him)

    if other people wanna submit one, PM me !

    grtz
    Reply With Quote Reply With Quote
  15. 12-15-2007 #15
    latruwski's Avatar
    latruwski
    latruwski is offline
    Banned
    Reputation
    647
    Join Date
    Dec 2006
    Posts
    2,456
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to latruwski Send a message via Skype™ to latruwski
    updated again with a few things

    if you can think of anything... request here

    grtz
    Reply With Quote Reply With Quote
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. [Release] Usefull Database Queries [Part 2]
    By latruwski in forum World of Warcraft Emulator Servers
    Replies: 23
    Last Post: 05-16-2008, 11:14 AM
  2. [RELEASE]Snailz Databases
    By Snailz in forum World of Warcraft Emulator Servers
    Replies: 30
    Last Post: 01-30-2008, 04:44 PM
  3. [RELEASE] Venice Database Revision 121 [ +Video Included on Upcoming Event's]
    By ~SaiLyn~ in forum World of Warcraft Emulator Servers
    Replies: 21
    Last Post: 01-15-2008, 06:39 PM
  4. [Release] Starting Gear Query Generator (May be Updated)
    By wowcomputer in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 12-25-2007, 11:43 PM
  5. [Release]Blizzlike Database - Fully Functioning
    By ~SaiLyn~ in forum World of Warcraft Emulator Servers
    Replies: 17
    Last Post: 11-12-2007, 09:52 PM
All times are GMT -5. The time now is 04:17 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search