Форумы
| :::Matrix Realm:: :: Форумы :: ЗАКРЫТЫЙ КЛУБ :: Место общения ГМ | << Предыдущая тема | Следующая тема >> | |
| 1 | ||
 
|
|
|
Модераторы: soulhunter
|
| Автор | Добавил | ||
| Havchik |
| ||
  ID пользователя #48 Зарегистрирован: 04.05.2005, 18:301: Сообщений:: 275 | -- respawn -- -- copper vein 6 min. update gameobject set respawntimer=360000 where id in (1731, 2055, 3763, 103713); -- tin vein 10 min. update gameobject set respawntimer=600000 where id in (1732, 2054, 3764, 103711); -- silver vein 15 min. update gameobject set respawntimer=900000 where id in (1733, 105569); -- gold vein 20 min. update gameobject set respawntimer=1200000 where id in (1734, 150080); -- iron deposit 25 min. update gameobject set respawntimer=1500000 where id=1735; -- mithril deposit 30 min. update gameobject set respawntimer=1800000 where id in (2040, 150079, 176645); -- truesilver deposit 35 min. update gameobject set respawntimer=2100000 where id in (2047, 150081); -- увеличено время респавн для объектов с типом 3 (т.е. открываемые) UPDATE gameobject_template JOIN gameobject ON gameobject.id=gameobject_template.entry SET gameobject.respawntimer=gameobject.respawntimer*10 0 WHERE gameobject_template.type=3 AND gameobject.respawntimer<30000; -- убираются дубликаты --Defias Digger delete from creature where guid in (1833, 1641, 1540); --Water Barret delete from gameobject where guid in (26406, 19484, 19528, 18038, 16743, 20568, 29399, 31090, 13591); Лучше быть нужным, чем свободным. | ||
| Наверх |
| ||
| Havchik |
| ||
| ID пользователя #48 Зарегистрирован: 04.05.2005, 18:301: Сообщений:: 275 | --Удаление лишней руды в пещере Эльвин Фореста (Regedan) delete from gameobject where guid in (253, 11477, 18725, 7171, 15881, 1864, 9971, 8605, 21198, 4908, 29515, 1509, 1858, 8602, 18754, 8601, 18751, 8599, 8579, 8577, 2395, 2394, 17536, 17535, 16435, 20809, 20827, 4833, 4820, 4823, 20830, 17538, 2068, 2070, 2071, 2066, 2072, 2074, 2043, 12756); Лучше быть нужным, чем свободным. | ||
| Наверх |
| ||
| Havchik |
| ||
| ID пользователя #48 Зарегистрирован: 04.05.2005, 18:301: Сообщений:: 275 | --тренеры оружейных скиллов delete from `npc_trainer` where (`entry`= '198' or `entry`= '328' or `entry`= '375' or `entry`= '376' or `entry`= '377' or `entry`= '459' or `entry`= '460' or `entry`= '461' or `entry`= '543' or `entry`= '812' or `entry`= '837' or `entry`= '895' or `entry`= '906' or `entry`= '911' or `entry`= '912' or `entry`= '913' or `entry`= '914' or `entry`= '915' or `entry`= '916' or `entry`= '917' or `entry`= '918' or `entry`= '925' or `entry`= '926' or `entry`= '927' or `entry`= '928' or `entry`= '944' or `entry`= '985' or `entry`= '986' or `entry`= '987' or `entry`= '988' or `entry`= '1218' or `entry`= '1226' or `entry`= '1228' or `entry`= '1229' or `entry`= '1231' or `entry`= '1232' or `entry`= '1234' or `entry`= '1292' or `entry`= '1355' or `entry`= '1404' or `entry`= '1411' or `entry`= '1458' or `entry`= '1680' or `entry`= '1681' or `entry`= '1699' or `entry`= '1701' or `entry`= '1901' or `entry`= '2119' or `entry`= '2122' or `entry`= '2123' or `entry`= '2124' or `entry`= '2126' or `entry`= '2127' or `entry`= '2128' or `entry`= '2129' or `entry`= '2130' or `entry`= '2131' or `entry`= '2327' or `entry`= '2485' or `entry`= '2489' or `entry`= '2492' or `entry`= '2798' or `entry`= '2801' or `entry`= '2870' or `entry`= '2878' or `entry`= '2879' or `entry`= '2880' or `entry`= '2881' or `entry`= '3001' or `entry`= '3013' or `entry`= '3026' or `entry`= '3028' or `entry`= '3030' or `entry`= '3031' or `entry`= '3032' or `entry`= '3033' or `entry`= '3034' or `entry`= '3036' or `entry`= '3038' or `entry`= '3039' or `entry`= '3040' or `entry`= '3041' or `entry`= '3042' or `entry`= '3043' or `entry`= '3044' or `entry`= '3045' or `entry`= '3046' or `entry`= '3047' or `entry`= '3048' or `entry`= '3049' or `entry`= '3059' or `entry`= '3060' or `entry`= '3061' or `entry`= '3062' or `entry`= '3063' or `entry`= '3064' or `entry`= '3065' or `entry`= '3066' or `entry`= '3087' or `entry`= '3137' or `entry`= '3153' or `entry`= '3154' or `entry`= '3155' or `entry`= '3156' or `entry`= '3157' or `entry`= '3169' or `entry`= '3170' or `entry`= '3171' or `entry`= '3172' or `entry`= '3173' or `entry`= '3179' or `entry`= '3181' or `entry`= '3306' or `entry`= '3324' or `entry`= '3325' or `entry`= '3326' or `entry`= '3327' or `entry`= '3328' or `entry`= '3332' or `entry`= '3344' or `entry`= '3352' or `entry`= '3353' or `entry`= '3354' or `entry`= '3357' or `entry`= '3373' or `entry`= '3399' or `entry`= '3401' or `entry`= '3403' or `entry`= '3404' or `entry`= '3406' or `entry`= '3407' or `entry`= '3408' or `entry`= '3545' or `entry`= '3593' or `entry`= '3594' or `entry`= '3595' or `entry`= '3596' or `entry`= '3597' or `entry`= '3598' or `entry`= '3599' or `entry`= '3600' or `entry`= '3601' or `entry`= '3602' or `entry`= '3620' or `entry`= '3622' or `entry`= '3624' or `entry`= '3688' or `entry`= '3698' or `entry`= '3706' or `entry`= '3707' or `entry`= '3963' or `entry`= '4087' or `entry`= '4089' or `entry`= '4090' or `entry`= '4091' or `entry`= '4092' or `entry`= '4138' or `entry`= '4146' or `entry`= '4156' or `entry`= '4163' or `entry`= '4165' or `entry`= '4204' or `entry`= '4205' or `entry`= '4210' or `entry`= '4211' or `entry`= '4214' or `entry`= '4215' or `entry`= '4217' or `entry`= '4218' or `entry`= '4219' or `entry`= '4254' or `entry`= '4320' or `entry`= '4552' or `entry`= '4563' or `entry`= '4564' or `entry`= '4565' or `entry`= '4566' or `entry`= '4567' or `entry`= '4568' or `entry`= '4573' or `entry`= '4582' or `entry`= '4583' or `entry`= '4584' or `entry`= '4591' or `entry`= '4593' or `entry`= '4594' or `entry`= '4595' or `entry`= '4598' or `entry`= '4606' or `entry`= '4607' or `entry`= '4608' or `entry`= '4614' or `entry`= '4881' or `entry`= '4882' or `entry`= '5113' or `entry`= '5114' or `entry`= '5115' or `entry`= '5116' or `entry`= '5117' or `entry`= '5137' or `entry`= '5141' or `entry`= '5142' or `entry`= '5143' or `entry`= '5144' or `entry`= '5145' or `entry`= '5146' or `entry`= '5147' or `entry`= '5148' or `entry`= '5149' or `entry`= '5150' or `entry`= '5159' or `entry`= '5161' or `entry`= '5165' or `entry`= '5166' or `entry`= '5167' or `entry`= '5171' or `entry`= '5172' or `entry`= '5173' or `entry`= '5392' or `entry`= '5479' or `entry`= '5480' or `entry`= '5482' or `entry`= '5484' or `entry`= '5489' or `entry`= '5491' or `entry`= '5492' or `entry`= '5493' or `entry`= '5495' or `entry`= '5496' or `entry`= '5497' or `entry`= '5498' or `entry`= '5501' or `entry`= '5502' or `entry`= '5504' or `entry`= '5505' or `entry`= '5506' or `entry`= '5513' or `entry`= '5515' or `entry`= '5516' or `entry`= '5517' or `entry`= '5520' or `entry`= '5566' or `entry`= '5612' or `entry`= '5749' or `entry`= '5750' or `entry`= '5753' or `entry`= '5759' or `entry`= '5815' or `entry`= '5880' or `entry`= '5882' or `entry`= '5883' or `entry`= '5884' or `entry`= '5885' or `entry`= '5939' or `entry`= '5943' or `entry`= '5957' or `entry`= '5958' or `entry`= '6014' or `entry`= '6018' or `entry`= '6027' or `entry`= '6094' or `entry`= '6291' or `entry`= '6292' or `entry`= '6295' or `entry`= '6297' or `entry`= '6328' or `entry`= '6373' or `entry`= '6374' or `entry`= '6376' or `entry`= '6382' or `entry`= '7087' or `entry`= '7088' or `entry`= '7089' or `entry`= '7311' or `entry`= '7312' or `entry`= '7315' or `entry`= '7870' or `entry`= '7953' or `entry`= '8140' or `entry`= '8141' or `entry`= '8142' or `entry`= '8144' or `entry`= '8146' or `entry`= '8308' or `entry`= '8665' or `entry`= '9465' or `entry`= '10086' or `entry`= '10088' or `entry`= '10089' or `entry`= '10090' or `entry`= '10370' or `entry`= '10618' or `entry`= '10930' or `entry`= '11097' or `entry`= '11397' or `entry`= '11401' or `entry`= '11406' or `entry`= '11696' or `entry`= '11701' or `entry`= '11702' or `entry`= '12030' or `entry`= '12042' or `entry`= '12776' or `entry`= '13283' or `entry`= '13417' or `entry`= '14740') and (`spell`='8738' or `spell`='1424' or `spell`='3128' or `spell`='7109'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('987','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1231','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1404','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3038','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3039','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3040','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3061','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3065','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3154','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3171','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3352','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3406','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3407','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3596','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3601','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3963','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4138','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4146','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4205','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5115','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5116','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5117','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5501','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5515','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5516','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5517','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8308','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('10930','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('927','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('928','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1232','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5147','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5148','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5149','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5491','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5492','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8140','3128','100','8'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('986','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('987','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1404','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3030','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3031','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3032','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3038','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3039','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3040','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3344','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3352','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3403','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3406','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3407','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4138','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4146','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4205','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5115','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5116','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5117','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5501','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5515','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5516','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5517','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('13417','8738','10800','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('917','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('918','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1234','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1411','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('2130','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3170','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3327','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3328','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3401','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3594','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3599','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4163','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4214','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4214','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4215','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4582','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4583','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4584','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5165','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5166','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5167','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('13283','1424','4000','10'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('918','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1234','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1411','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('2130','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3170','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3327','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3328','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3401','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3599','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4163','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4214','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4215','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4582','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4583','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4584','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5165','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5166','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5167','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('13283','3128','100','12'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('914','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('985','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('987','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1404','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1901','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3038','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3039','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3040','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3041','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3042','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3043','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3169','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3352','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3353','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3354','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3406','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3407','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3408','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3601','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3963','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4087','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4089','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4138','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4146','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4205','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4593','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4594','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4595','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5113','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5114','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5115','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5116','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5117','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5479','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5480','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5501','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5515','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5516','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5517','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('7315','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8141','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8308','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('10930','1424','4000','20'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('914','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('928','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('985','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1901','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3041','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3042','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3043','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3169','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3353','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3354','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3408','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4087','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4089','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4593','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4594','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4595','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5113','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5114','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5147','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5148','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5149','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5479','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5480','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5491','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5492','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('7315','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8140','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8141','7109','22000','40'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('913','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('914','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('985','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1229','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('1901','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('2131','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3041','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3042','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3043','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3059','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3063','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3153','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3169','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3353','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3354','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3408','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3593','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('3598','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4087','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4089','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4593','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4594','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('4595','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5113','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5114','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5479','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('5480','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('7315','3128','100','6'); insert into npc_trainer (entry,spell,spellcost,reqlevel) VALUES ('8141','3128','100','6'); Лучше быть нужным, чем свободным. | ||
| Наверх |
| ||
| admin |
| ||
  ID пользователя #2 Зарегистрирован: 04.05.2005, 10:461: Сообщений:: 377 | update item_template set buyprice=100000,requiredskill=762,requiredspell=0, requiredskillrank=1 WHERE `entry` IN (5656,1132,2411,2414,5655,5665,5668,5864,5872,5873 ,8563,8588,8591,8592,8595,8629,8631,8632,13321,133 22,13331,13332,13333,15277,15290); update item_template set buyprice=1000000,requiredskill=762,requiredspell=3 3391,requiredskillrank=1 WHERE `entry` IN (12302,12303,12330,12351,12353,12354,13086,13326,1 3327,13328,13329,13334,18766,18767,18772,18773,187 74,18776,18777,18778,1878,18786,18787,18788,18789, 18790,18791,18793,18794,18795,18796,18797,18798,18 902); update item_template set AllowableRace=1 WHERE `entry` IN (2414,5655,5656,18776,18778,18777); update item_template set AllowableRace=1 WHERE `entry` IN (5656,5655,2414,2411,12354,12353); update item_template set AllowableRace=1 WHERE `entry` IN (2414,5655,5656,12353,12354,18776,18777,18778); update item_template set AllowableRace=1 WHERE `entry` IN (5656,2414,5655,18776,18778,18777); update item_template set AllowableRace=4 WHERE `entry` IN (5864,5872,5873,13328,13329,18785,18786,18787); update item_template set AllowableRace=8 WHERE `entry` IN (8631,8632,12302,12303,13086,18766,18767,18902); update item_template set AllowableRace=8 WHERE `entry` IN (8631,8632,8629,18902,18767,18766); update item_template set AllowableRace=2 WHERE `entry` IN (1132,5665,5668,12330,12351,18796,18797,18798); update item_template set AllowableRace=16 WHERE `entry` IN (13331,13332,13333,13334,18791); update item_template set AllowableRace=128 WHERE `entry` IN (18789,18788,8588,18790,8592,8591); update item_template set AllowableRace=32 WHERE `entry` IN (15277,15290,18793,18794,18795); update item_template set AllowableRace=64 WHERE `entry` IN (8563,8595,13321,13322,13326,13327,18774,18773,187 72); DELETE FROM npc_vendor WHERE entry=4885; DELETE FROM npc_vendor WHERE entry=1460; DELETE FROM npc_vendor WHERE entry=2357; DELETE FROM npc_vendor WHERE entry=384; DELETE FROM npc_vendor WHERE entry=1261; DELETE FROM npc_vendor WHERE entry=10085; DELETE FROM npc_vendor WHERE entry=4730; DELETE FROM npc_vendor WHERE entry=3362; DELETE FROM npc_vendor WHERE entry=10057; DELETE FROM npc_vendor WHERE entry=7952; DELETE FROM npc_vendor WHERE entry=3685; DELETE FROM npc_vendor WHERE entry=7955; INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 2414, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 5655, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 5656, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 18776, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 18778, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4885, 18777, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 5656, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 5655, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 2414, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 2411, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 12354, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1460, 12353, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 2414, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 5655, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 5656, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 12353, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 12354, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 18776, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 18777, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (2357, 18778, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 5656, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 2414, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 5655, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 18776, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 18778, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (384, 18777, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 5864, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 5872, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 5873, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 13328, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 13329, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 18785, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 18786, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (1261, 18787, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 8631, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 8632, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 12302, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 12303, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 13086, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 18766, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 18767, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10085, 18902, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 8631, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 8632, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 8629, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 18902, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 18767, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (4730, 18766, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 1132, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 5665, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 5668, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 12330, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 12351, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 18796, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 18797, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3362, 18798, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10057, 13331, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10057, 13332, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10057, 13333, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10057, 13334, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (10057, 18791, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 18789, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 18788, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 8588, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 18790, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 8592, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7952, 8591, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3685, 15277, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3685, 15290, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3685, 18793, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3685, 18794, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (3685, 18795, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 8563, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 8595, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 13321, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 13322, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 13326, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 13327, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 18774, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 18773, 0, 0); INSERT INTO npc_vendor (entry, item, maxcount, incrtime) VALUES (7955, 18772, 0, 0); DELETE FROM npc_trainer WHERE entry=4732; DELETE FROM npc_trainer WHERE entry=4773; DELETE FROM npc_trainer WHERE entry=3690; DELETE FROM npc_trainer WHERE entry=7953; DELETE FROM npc_trainer WHERE entry=4752; DELETE FROM npc_trainer WHERE entry=4753; DELETE FROM npc_trainer WHERE entry=4772; DELETE FROM npc_trainer WHERE entry=7953; DELETE FROM npc_trainer WHERE entry=7954; insert into npc_trainer value (4732, 33389, 900000, 0, 0, 0, 40), (4732, 33392,9000000, 33388, 762, 0, 60), (4773, 33389, 900000, 0, 0, 0, 40), (4773, 33392,9000000, 33388, 762, 0, 60), (3690, 33389, 900000, 0, 0, 0, 40), (3690, 33392,9000000, 33388, 762, 0, 60), (4752, 33389, 900000, 0, 0, 0, 40), (4752, 33392,9000000, 33388, 762, 0, 60), (4753, 33389, 900000, 0, 0, 0, 40), (4753, 33392,9000000, 33388, 762, 0, 60), (4772, 33389, 900000, 0, 0, 0, 40), (4772, 33392,9000000, 33388, 762, 0, 60), (7953, 33389, 900000, 0, 0, 0, 40), (7953, 33392,9000000, 33388, 762, 0, 60), (7954, 33389, 900000, 0, 0, 0, 40), (7954, 33392,9000000, 33388, 762, 0, 60); [ Редактирование 24.11.2006, 20:23 ] | ||
| Наверх |
| ||
| admin |
| ||
| ID пользователя #2 Зарегистрирован: 04.05.2005, 10:461: Сообщений:: 377 | UPDATE fishing_loot_template SET ChanceOrRef=(fishing_loot_template.ChanceOrRef/ 100*250); UPDATE skinning_loot_template SET ChanceOrRef=(skinning_loot_template.ChanceOrRef/ 100*250); | ||
| Наверх |
| ||
Powered by e107 Forum System
