Naxxramas 80 Update SQL script menu
Follow us:

User Tag List

Page 1 of 3 123 LastLast
Results 1 to 15 of 35
  1. 01-30-2009 #1
    Iksf's Avatar
    Iksf
    Iksf is offline
    Active Member
    Reputation
    18
    Join Date
    May 2008
    Posts
    129
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Naxxramas 80 Update SQL script

    Hey everyone. I have spent the last 5 hours odd redoing the stats for the mobs in Naxxramas to the 25 man 80 ones. There are ofc errors, WoWHead and wowwiki almost always told me the HP but actual damage output not so much so i made lots of that up. This is made for Arcemu and will probably work on ascent too. Now includes loot updates, that took another night and im nackered

    *Note: There was a SQL with a syntax error before, that has been fixed


    Code:
    UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038574,`maxhealth`=13038576,`attacktime`=1799,`mindamage`=17001,`maxdamage`=18004 WHERE `entry`=16028;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9596000,`maxhealth`=9596000,`mana`=120000,`mindamage`=14000,`maxdamage`=14001,`respawntime`=0 WHERE `entry`=15931;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=11432000,`maxhealth`=11432000,`mana`=12000,`mindamage`=12000,`maxdamage`=12500,`respawntime`=0 WHERE `entry`=15932;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=30400000,`maxhealth`=30400000,`mindamage`=13500,`maxdamage`=15200,`respawntime`=0 WHERE `entry`=15928;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6763000,`maxhealth`=6763000,`mindamage`=9000,`maxdamage`=14000,`respawntime`=0 WHERE `entry`=15956;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=6600 WHERE `entry`=16573;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mana`=0,`mindamage`=5000,`maxdamage`=7900 WHERE `entry`=15976;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=46000,`maxhealth`=46000,`mana`=0,`mindamage`=3000,`maxdamage`=4000 WHERE `entry`=15974;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=234000,`maxhealth`=234000,`mana`=0,`maxdamage`=3000 WHERE `entry`=15975;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`maxdamage`=2200 WHERE `entry`=15977;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=586500,`maxhealth`=586500,`mindamage`=4000,`maxdamage`=7000 WHERE `entry`=15978;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=160000,`maxhealth`=160000,`maxdamage`=6900 WHERE `entry`=16453;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=3000,`maxdamage`=3500 WHERE `entry`=15980;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=2000,`maxdamage`=3000 WHERE `entry`=15981;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6760000,`maxhealth`=6760000,`mindamage`=11000,`maxdamage`=13000,`respawntime`=0 WHERE `entry`=15953;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=4400 WHERE `entry`=16505;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=40000,`maxhealth`=40000,`mindamage`=5500,`maxdamage`=6600 WHERE `entry`=16449;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=120000,`maxhealth`=120000,`mindamage`=7800,`maxdamage`=8000 WHERE `entry`=16368;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=7600000,`maxhealth`=7600000,`mindamage`=15900,`maxdamage`=16000 WHERE `entry`=15952;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=456000,`maxhealth`=456000,`mindamage`=8000,`maxdamage`=12000 WHERE `entry`=15979;;
UPDATE `creature_proto` SET `minhealth`=143000,`maxhealth`=143000,`mindamage`=11000,`maxdamage`=22000 WHERE `entry`=16017;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81 WHERE `entry`=16017;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=176000,`maxhealth`=176000,`mindamage`=9020,`maxdamage`=11015 WHERE `entry`=16018;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=252000,`maxhealth`=252000,`mindamage`=7090,`maxdamage`=1101,`walk_speed`=1.5,`run_speed`=4 WHERE `entry`=16375;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=51000,`maxhealth`=51000,`mindamage`=8000,`maxdamage`=10900,`walk_speed`=1,`run_speed`=4 WHERE `entry`=16024;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=7086,`maxdamage`=9010 WHERE `entry`=16020;;
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=188000,`maxhealth`=188000,`mindamage`=10000,`maxdamage`=12000 WHERE `entry`=16021;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=88000,`maxhealth`=88000,`mindamage`=5200,`maxdamage`=6400 WHERE `entry`=16022;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=539000,`maxhealth`=539000,`mindamage`=14000,`maxdamage`=17000 WHERE `entry`=16025;;
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=134000,`maxhealth`=134000,`mindamage`=11000,`maxdamage`=11000 WHERE `entry`=16029;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=12000,`maxdamage`=18000 WHERE `entry`=15930;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=16000,`maxdamage`=20000 WHERE `entry`=15929;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9700,`maxdamage`=11000 WHERE `entry`=16156;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=98000,`maxhealth`=98000,`mindamage`=6000,`maxdamage`=9000 WHERE `entry`=16158;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=342000,`maxhealth`=342000,`mindamage`=11000,`maxdamage`=14000 WHERE `entry`=16146;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mindamage`=15700,`maxdamage`=17600 WHERE `entry`=16145;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=8900,`maxdamage`=11000 WHERE `entry`=16167;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=50000,`maxhealth`=50000 WHERE `entry`=16157;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=404000,`maxhealth`=404000,`mindamage`=12000,`maxdamage`=14000,`armor`=38000 WHERE `entry`=16803;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=10100000,`maxhealth`=10100000,`mindamage`=50000,`maxdamage`=60000,`respawntime`=0 WHERE `entry`=16061;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=390990,`maxhealth`=390990,`mindamage`=12000,`maxdamage`=14000 WHERE `entry`=16163;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=187668,`maxhealth`=187668,`mindamage`=11000,`maxdamage`=19000 WHERE `entry`=16165;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=14000,`maxdamage`=22000 WHERE `entry`=16448;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2510000,`maxhealth`=2510000,`mana`=4500000,`mindamage`=12000,`maxdamage`=15000,`respawntime`=0 WHERE `entry`=16060;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=7000,`respawntime`=0 WHERE `entry`=16064;;
UPDATE `creature_proto` SET `entry`=30549,`minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=3300,`maxdamage`=7700,`respawntime`=0 WHERE `entry`=16062;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`respawntime`=0 WHERE `entry`=16063;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=8000 WHERE `entry`=16067;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038000,`maxhealth`=13038000,`mindamage`=12000,`maxdamage`=18000,`respawntime`=0 WHERE `entry`=15989;;
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`) VALUES (113491,81,81,21,207000,207000,0,1,0,2000,0,11000,22000,0,0,0,0,360000,5000,0,0,0,0,0,0,1,1,'',0,1450,0,0,1,4,8,0,0,0,0,0,0,0);;
UPDATE `creature_proto` SET `minhealth`=2370000,`maxhealth`=2370000 WHERE `entry`=16065;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2200000,`maxhealth`=2200000,`mindamage`=8200,`maxdamage`=12000,`respawntime`=0 WHERE `entry`=16011;;
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=10879,`maxhealth`=10879,`mindamage`=900,`maxdamage`=1200 WHERE `entry`=16057;;
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=140000,`maxhealth`=140000,`mindamage`=1100,`maxdamage`=1200 WHERE `entry`=16056;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9270000,`maxhealth`=9270000,`mindamage`=10000,`maxdamage`=11000 WHERE `entry`=15936;;
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=8440000,`maxhealth`=8440000,`mindamage`=11000,`maxdamage`=16000 WHERE `entry`=15954;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=563260,`maxhealth`=563260,`mindamage`=6600,`maxdamage`=7800 WHERE `entry`=16034;;
UPDATE `creature_proto` SET `minhealth`=195000,`maxhealth`=195000 WHERE `entry`=16034;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=5000,`maxdamage`=7000 WHERE `entry`=16036;;
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=6000,`maxdamage`=7000 WHERE `entry`=16037;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=877400,`maxhealth`=877400,`mindamage`=11000,`maxdamage`=12000 WHERE `entry`=16168;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9000,`maxdamage`=11000 WHERE `entry`=16244;;
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=8000,`maxdamage`=11000 WHERE `entry`=16243;;
    Loot code, drops are correct to nearest 3%
    Code:
    DELETE FROM `loot_creatures` WHERE `entryid`=15956;
DELETE FROM `loot_creatures` WHERE `entryid`=15953;
DELETE FROM `loot_creatures` WHERE `entryid`=15952;
DELETE FROM `loot_creatures` WHERE `entryid`=15954;
DELETE FROM `loot_creatures` WHERE `entryid`=15936;
DELETE FROM `loot_creatures` WHERE `entryid`=16011;
DELETE FROM `loot_creatures` WHERE `entryid`=16028;
DELETE FROM `loot_creatures` WHERE `entryid`=16060;
DELETE FROM `loot_creatures` WHERE `entryid`=15931;
DELETE FROM `loot_creatures` WHERE `entryid`=15932;
DELETE FROM `loot_creatures` WHERE `entryid`=15928;
DELETE FROM `loot_creatures` WHERE `entryid`=16061;
DELETE FROM `loot_creatures` WHERE `entryid`=16061;
DELETE FROM `loot_creatures` WHERE `entryid`=15989;
DELETE FROM `loot_creatures` WHERE `entryid`=15990;
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39716', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39714', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39712', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39717', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39704', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39721', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39720', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39706', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39722', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39719', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39718', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39701', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39702', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '39703', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40080', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40075', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40064', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15956', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39723', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39725', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39727', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39756', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39731', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39757', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39735', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39728', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39732', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39730', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39733', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39729', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '39734', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40065', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40074', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40080', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40075', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40107', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40071', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40064', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15953', '40069', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40063', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39768', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40061', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39766', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39763', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39758', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39767', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40062', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40060', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39764', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39760', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39765', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39762', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39759', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '39761', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40257', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15952', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40193', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40198', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40191', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40197', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40185', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40200', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40184', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40602', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40189', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40196', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40187', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40192', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40186', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40188', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40190', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15954', '40264', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40235', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40237', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40207', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40236', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40210', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40238', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40233', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40206', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40205', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40208', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40234', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40204', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40209', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40203', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40201', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15936', '40257', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40639', '75', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40638', '60', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40637', '55', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40249', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40245', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40244', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40239', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40247', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40242', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40243', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40241', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40240', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16011', '40246', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40247', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40272', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40269', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40263', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40266', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40271', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40265', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40261', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40262', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40264', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40259', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40270', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40273', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40260', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40268', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40075', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40108', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40074', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40065', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40071', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40107', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40069', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40080', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16028', '40064', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40289', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40278', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40281', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40288', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40283', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40287', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40285', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40282', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40279', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40284', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40280', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40277', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40274', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40258', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40253', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40250', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40256', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40251', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40254', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40252', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40255', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15931', '40257', '10', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40621', '12', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40612', '12', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40624', '12', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40620', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40623', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40619', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40611', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40622', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '40610', '9', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15932', '39345', '1', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40303', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40636', '74', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40635', '60', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40634', '60', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40300', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40304', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40301', '22', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40298', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40296', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40299', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40294', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40297', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15928', '40302', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '39345', '22', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '39369', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40324', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40316', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40320', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40317', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40322', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40325', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40306', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40321', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40315', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40323', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40305', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40075', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16061', '40069', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39392', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39345', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39369', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39388', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39344', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39386', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39379', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39390', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '16060', '39389', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '44577', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40378', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40373', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40375', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40368', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40379', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40370', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40376', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40372', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40381', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40367', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40366', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40365', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40369', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40380', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40371', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40362', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40377', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15989', '40403', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40395', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40405', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40402', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40396', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40383', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40388', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40398', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40401', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40400', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40384', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40387', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40399', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40386', '20', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40633', '70', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40632', '50', '0', '1', '1', '0');
INSERT INTO `loot_creatures` VALUES ('NULL', '15990', '40631', '50', '0', '1', '1', '0');
    Last edited by Iksf; 04-01-2009 at 04:47 PM. Reason: Adding Loot support
    Reply With Quote Reply With Quote
    Naxxramas 80 Update SQL script
  2. 01-31-2009 #2
    Hellgawd's Avatar
    Hellgawd
    Hellgawd is offline
    Account not activated by Email
    Reputation
    710
    Join Date
    Jun 2007
    Posts
    2,480
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to Hellgawd
    Not really a guide, perhaps you should post this in the releases section? And please put the queries in a code tag. thanks
    Reply With Quote Reply With Quote
  3. 01-31-2009 #3
    coltrain7's Avatar
    coltrain7
    coltrain7 is offline
    Member
    Reputation
    41
    Join Date
    Mar 2008
    Posts
    60
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Hellgawd View Post
    Not really a guide, perhaps you should post this in the releases section? And please put the queries in a code tag. thanks
    And Iksf if you don't know how to put it in code here you go...... In front of the first Letter of sql put [code[ then at end put [/code]! I didnt know how to do this at first so hopefully this helped!
    Reply With Quote Reply With Quote
  4. 01-31-2009 #4
    Iksf's Avatar
    Iksf
    Iksf is offline
    Active Member
    Reputation
    18
    Join Date
    May 2008
    Posts
    129
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Cool good idea didn't think of it
    Reply With Quote Reply With Quote
  5. 02-01-2009 #5
    Boiko7530bg's Avatar
    Boiko7530bg
    Boiko7530bg is offline
    Member
    Reputation
    8
    Join Date
    Jul 2008
    Posts
    129
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    But this is for Mangos.Pls can you give me for Arcemu
    Reply With Quote Reply With Quote
  6. 02-01-2009 #6
    knaur's Avatar
    knaur
    knaur is offline
    Elite User
    Reputation
    400
    Join Date
    Nov 2007
    Posts
    634
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Boiko7530bg View Post
    But this is for Mangos.Pls can you give me for Arcemu
    lol??? wtf you talking about??

    this is arcemu...

    Mangos has NEVER used creature_proto tables....


    anyway +4rep for this job
    Last edited by knaur; 02-01-2009 at 08:24 AM.
    ------------------------------------------------------
    Knaur - Founder of The Norwegian Elite Team
    Reply With Quote Reply With Quote
  7. 02-01-2009 #7
    Boiko7530bg's Avatar
    Boiko7530bg
    Boiko7530bg is offline
    Member
    Reputation
    8
    Join Date
    Jul 2008
    Posts
    129
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by knaur View Post
    lol??? wtf you talking about??

    this is arcemu...

    Mangos has NEVER used creature_proto tables....


    anyway +4rep for this job

    Well i tryed again but i cant import it


    Query:
    /* */
    /* WORLD BOSS */
    UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

    Error occured at:2008-06-21 02:36:22
    Line no.:4
    Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

    Query:
    /* */
    /* WORLD BOSS */
    UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

    Error occured at:2008-06-21 02:37:35
    Line no.:4
    Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

    Query:
    /* */
    /* WORLD BOSS */
    UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

    Error occured at:2008-06-21 02:37:36
    Line no.:4
    Error Code: 1146 - Table 'mangos.creature_template' doesn't exist

    Query:
    /* THIS FILE CONTAINS ADDITIONAL SQL REQUIRED FOR SCRIPTS TO WORK PROPERLY */
    /* CAN BE INCLUDED IN ANY DATABASE IF SCRIPTDEV SUPPORT IS WANTED BY DEFAULT */
    /* It's recommended to run this SQL after any regular database update */
    /* */
    Reply With Quote Reply With Quote
  8. 02-01-2009 #8
    knaur's Avatar
    knaur
    knaur is offline
    Elite User
    Reputation
    400
    Join Date
    Nov 2007
    Posts
    634
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    the sql you pasted there isnt even the same than in this thread??

    /* WORLD BOSS */
    UPDATE `creature_template` SET `ScriptName` = 'boss_ysondre' WHERE `entry` = 14887

    thats a sql for some boss npc????

    Code:
    UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038574,`maxhealth`=13038576,`attacktime`=1799,`mindamage`=17001,`maxdamage`=18004 WHERE `entry`=16028
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9596000,`maxhealth`=9596000,`mana`=120000,`mindamage`=14000,`maxdamage`=14001,`respawntime`=0 WHERE `entry`=15931
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=11432000,`maxhealth`=11432000,`mana`=12000,`mindamage`=12000,`maxdamage`=12500,`respawntime`=0 WHERE `entry`=15932
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=30400000,`maxhealth`=30400000,`mindamage`=13500,`maxdamage`=15200,`respawntime`=0 WHERE `entry`=15928
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6763000,`maxhealth`=6763000,`mindamage`=9000,`maxdamage`=14000,`respawntime`=0 WHERE `entry`=15956
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=6600 WHERE `entry`=16573
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mana`=0,`mindamage`=5000,`maxdamage`=7900 WHERE `entry`=15976
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=46000,`maxhealth`=46000,`mana`=0,`mindamage`=3000,`maxdamage`=4000 WHERE `entry`=15974
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=234000,`maxhealth`=234000,`mana`=0,`maxdamage`=3000 WHERE `entry`=15975
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`maxdamage`=2200 WHERE `entry`=15977
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=586500,`maxhealth`=586500,`mindamage`=4000,`maxdamage`=7000 WHERE `entry`=15978
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=160000,`maxhealth`=160000,`maxdamage`=6900 WHERE `entry`=16453
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=3000,`maxdamage`=3500 WHERE `entry`=15980
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=2000,`maxdamage`=3000 WHERE `entry`=15981
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6760000,`maxhealth`=6760000,`mindamage`=11000,`maxdamage`=13000,`respawntime`=0 WHERE `entry`=15953
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=4400 WHERE `entry`=16505
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=40000,`maxhealth`=40000,`mindamage`=5500,`maxdamage`=6600 WHERE `entry`=16449
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=120000,`maxhealth`=120000,`mindamage`=7800,`maxdamage`=8000 WHERE `entry`=16368
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=7600000,`maxhealth`=7600000,`mindamage`=15900,`maxdamage`=16000 WHERE `entry`=15952
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=456000,`maxhealth`=456000,`mindamage`=8000,`maxdamage`=12000 WHERE `entry`=15979
UPDATE `creature_proto` SET `minhealth`=143000,`maxhealth`=143000,`mindamage`=11000,`maxdamage`=22000 WHERE `entry`=16017
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81 WHERE `entry`=16017
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=176000,`maxhealth`=176000,`mindamage`=9020,`maxdamage`=11015 WHERE `entry`=16018
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=252000,`maxhealth`=252000,`mindamage`=7090,`maxdamage`=1101,`walk_speed`=1.5,`run_speed`=4 WHERE `entry`=16375
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=51000,`maxhealth`=51000,`mindamage`=8000,`maxdamage`=10900,`walk_speed`=1,`run_speed`=4 WHERE `entry`=16024
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=7086,`maxdamage`=9010 WHERE `entry`=16020
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=188000,`maxhealth`=188000,`mindamage`=10000,`maxdamage`=12000 WHERE `entry`=16021
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=88000,`maxhealth`=88000,`mindamage`=5200,`maxdamage`=6400 WHERE `entry`=16022
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=539000,`maxhealth`=539000,`mindamage`=14000,`maxdamage`=17000 WHERE `entry`=16025
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=134000,`maxhealth`=134000,`mindamage`=11000,`maxdamage`=11000 WHERE `entry`=16029
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=12000,`maxdamage`=18000 WHERE `entry`=15930
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=16000,`maxdamage`=20000 WHERE `entry`=15929
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9700,`maxdamage`=11000 WHERE `entry`=16156
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=98000,`maxhealth`=98000,`mindamage`=6000,`maxdamage`=9000 WHERE `entry`=16158
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=342000,`maxhealth`=342000,`mindamage`=11000,`maxdamage`=14000 WHERE `entry`=16146
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mindamage`=15700,`maxdamage`=17600 WHERE `entry`=16145
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=8900,`maxdamage`=11000 WHERE `entry`=16167
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=50000,`maxhealth`=50000 WHERE `entry`=16157
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=404000,`maxhealth`=404000,`mindamage`=12000,`maxdamage`=14000,`armor`=38000 WHERE `entry`=16803
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=10100000,`maxhealth`=10100000,`mindamage`=50000,`maxdamage`=60000,`respawntime`=0 WHERE `entry`=16061
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=390990,`maxhealth`=390990,`mindamage`=12000,`maxdamage`=14000 WHERE `entry`=16163
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=187668,`maxhealth`=187668,`mindamage`=11000,`maxdamage`=19000 WHERE `entry`=16165
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=14000,`maxdamage`=22000 WHERE `entry`=16448
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2510000,`maxhealth`=2510000,`mana`=4500000,`mindamage`=12000,`maxdamage`=15000,`respawntime`=0 WHERE `entry`=16060
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=7000,`respawntime`=0 WHERE `entry`=16064
UPDATE `creature_proto` SET `entry`=30549,`minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=3300,`maxdamage`=7700,`respawntime`=0 WHERE `entry`=16062
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`respawntime`=0 WHERE `entry`=16063
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=8000 WHERE `entry`=16067
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038000,`maxhealth`=13038000,`mindamage`=12000,`maxdamage`=18000,`respawntime`=0 WHERE `entry`=15989
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`) VALUES (113491,81,81,21,207000,207000,0,1,0,2000,0,11000,22000,0,0,0,0,360000,5000,0,0,0,0,0,0,1,1,'',0,1450,0,0,1,4,8,0,0,0,0,0,0,0)
UPDATE `creature_proto` SET `minhealth`=2370000,`maxhealth`=2370000 WHERE `entry`=16065
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2200000,`maxhealth`=2200000,`mindamage`=8200,`maxdamage`=12000,`respawntime`=0 WHERE `entry`=16011
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=10879,`maxhealth`=10879,`mindamage`=900,`maxdamage`=1200 WHERE `entry`=16057
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=140000,`maxhealth`=140000,`mindamage`=1100,`maxdamage`=1200 WHERE `entry`=16056
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9270000,`maxhealth`=9270000,`mindamage`=10000,`maxdamage`=11000 WHERE `entry`=15936
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=8440000,`maxhealth`=8440000,`mindamage`=11000,`maxdamage`=16000 WHERE `entry`=15954
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=563260,`maxhealth`=563260,`mindamage`=6600,`maxdamage`=7800 WHERE `entry`=16034
UPDATE `creature_proto` SET `minhealth`=195000,`maxhealth`=195000 WHERE `entry`=16034
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=5000,`maxdamage`=7000 WHERE `entry`=16036
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=6000,`maxdamage`=7000 WHERE `entry`=16037
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=877400,`maxhealth`=877400,`mindamage`=11000,`maxdamage`=12000 WHERE `entry`=16168
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9000,`maxdamage`=11000 WHERE `entry`=16244
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=8000,`maxdamage`=11000 WHERE `entry`=16243
    where is the creature_template and boss script part in the sql??

    Execute the correct sql into your database may work better....
    ------------------------------------------------------
    Knaur - Founder of The Norwegian Elite Team
    Reply With Quote Reply With Quote
  9. 02-01-2009 #9
    ~Jagris's Avatar
    ~Jagris
    ~Jagris is offline
    Contributor
    Reputation
    154
    Join Date
    Apr 2007
    Posts
    1,479
    Thanks G/R
    2/2
    Trade Feedback
    1 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Boiko7530bg View Post
    Table 'mangos.creature_template' doesn't exist
    That mangos. manes thats the name of the DATABASE not the table.

    Reply With Quote Reply With Quote
  10. 02-01-2009 #10
    moltn's Avatar
    moltn
    moltn is offline
    Member
    Reputation
    45
    Join Date
    Dec 2007
    Posts
    81
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to moltn
    I get this when I try to execute

    Code:
    UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038574,`maxhealth`=13038576,`attacktime`=1799,`mindamage`=17001,`maxdamage`=18004 WHERE `entry`=16028
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9596000,`maxhealth`=9596000,`mana`=120000,`mindamage`=14000,`maxdamage`=14001,`respawntime`=0 WHERE `entry`=15931
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=11432000,`maxhealth`=11432000,`mana`=12000,`mindamage`=12000,`maxdamage`=12500,`respawntime`=0 WHERE `entry`=15932
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=30400000,`maxhealth`=30400000,`mindamage`=13500,`maxdamage`=15200,`respawntime`=0 WHERE `entry`=15928
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6763000,`maxhealth`=6763000,`mindamage`=9000,`maxdamage`=14000,`respawntime`=0 WHERE `entry`=15956
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=6600 WHERE `entry`=16573
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mana`=0,`mindamage`=5000,`maxdamage`=7900 WHERE `entry`=15976
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=46000,`maxhealth`=46000,`mana`=0,`mindamage`=3000,`maxdamage`=4000 WHERE `entry`=15974
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=234000,`maxhealth`=234000,`mana`=0,`maxdamage`=3000 WHERE `entry`=15975
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`maxdamage`=2200 WHERE `entry`=15977
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=586500,`maxhealth`=586500,`mindamage`=4000,`maxdamage`=7000 WHERE `entry`=15978
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=160000,`maxhealth`=160000,`maxdamage`=6900 WHERE `entry`=16453
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=3000,`maxdamage`=3500 WHERE `entry`=15980
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=52000,`maxhealth`=52000,`mindamage`=2000,`maxdamage`=3000 WHERE `entry`=15981
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=6760000,`maxhealth`=6760000,`mindamage`=11000,`maxdamage`=13000,`respawntime`=0 WHERE `entry`=15953
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=3300,`maxdamage`=4400 WHERE `entry`=16505
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=203000,`maxhealth`=203000,`mana`=100000,`mindamage`=2900,`maxdamage`=2900 WHERE `entry`=16506
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=40000,`maxhealth`=40000,`mindamage`=5500,`maxdamage`=6600 WHERE `entry`=16449
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=120000,`maxhealth`=120000,`mindamage`=7800,`maxdamage`=8000 WHERE `entry`=16368
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=7600000,`maxhealth`=7600000,`mindamage`=15900,`maxdamage`=16000 WHERE `entry`=15952
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=456000,`maxhealth`=456000,`mindamage`=8000,`maxdamage`=12000 WHERE `entry`=15979
UPDATE `creature_proto` SET `minhealth`=143000,`maxhealth`=143000,`mindamage`=11000,`maxdamage`=22000 WHERE `entry`=16017
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81 WHERE `entry`=16017
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=176000,`maxhealth`=176000,`mindamage`=9020,`maxdamage`=11015 WHERE `entry`=16018
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=252000,`maxhealth`=252000,`mindamage`=7090,`maxdamage`=1101,`walk_speed`=1.5,`run_speed`=4 WHERE `entry`=16375
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=51000,`maxhealth`=51000,`mindamage`=8000,`maxdamage`=10900,`walk_speed`=1,`run_speed`=4 WHERE `entry`=16024
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=7086,`maxdamage`=9010 WHERE `entry`=16020
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=188000,`maxhealth`=188000,`mindamage`=10000,`maxdamage`=12000 WHERE `entry`=16021
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=88000,`maxhealth`=88000,`mindamage`=5200,`maxdamage`=6400 WHERE `entry`=16022
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=539000,`maxhealth`=539000,`mindamage`=14000,`maxdamage`=17000 WHERE `entry`=16025
UPDATE `creature_proto` SET `minlevel`=82,`maxlevel`=82,`minhealth`=134000,`maxhealth`=134000,`mindamage`=11000,`maxdamage`=11000 WHERE `entry`=16029
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=12000,`maxdamage`=18000 WHERE `entry`=15930
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2091000,`maxhealth`=2091000,`mindamage`=16000,`maxdamage`=20000 WHERE `entry`=15929
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9700,`maxdamage`=11000 WHERE `entry`=16156
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=98000,`maxhealth`=98000,`mindamage`=6000,`maxdamage`=9000 WHERE `entry`=16158
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=342000,`maxhealth`=342000,`mindamage`=11000,`maxdamage`=14000 WHERE `entry`=16146
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=391000,`maxhealth`=391000,`mindamage`=15700,`maxdamage`=17600 WHERE `entry`=16145
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=8900,`maxdamage`=11000 WHERE `entry`=16167
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=50000,`maxhealth`=50000 WHERE `entry`=16157
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=404000,`maxhealth`=404000,`mindamage`=12000,`maxdamage`=14000,`armor`=38000 WHERE `entry`=16803
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=10100000,`maxhealth`=10100000,`mindamage`=50000,`maxdamage`=60000,`respawntime`=0 WHERE `entry`=16061
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=390990,`maxhealth`=390990,`mindamage`=12000,`maxdamage`=14000 WHERE `entry`=16163
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=187668,`maxhealth`=187668,`mindamage`=11000,`maxdamage`=19000 WHERE `entry`=16165
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=195000,`maxhealth`=195000,`mindamage`=14000,`maxdamage`=22000 WHERE `entry`=16448
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2510000,`maxhealth`=2510000,`mana`=4500000,`mindamage`=12000,`maxdamage`=15000,`respawntime`=0 WHERE `entry`=16060
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=7000,`respawntime`=0 WHERE `entry`=16064
UPDATE `creature_proto` SET `entry`=30549,`minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=3300,`maxdamage`=7700,`respawntime`=0 WHERE `entry`=16062
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`respawntime`=0 WHERE `entry`=16063
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2370000,`maxhealth`=2370000,`mindamage`=5000,`maxdamage`=8000 WHERE `entry`=16067
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=13038000,`maxhealth`=13038000,`mindamage`=12000,`maxdamage`=18000,`respawntime`=0 WHERE `entry`=15989
INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`attacktype`,`mindamage`,`maxdamage`,`can_ranged`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`respawntime`,`armor`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`fly_speed`,`extra_a9_flags`,`spell1`,`spell2`,`spell3`,`spell4`,`spell_flags`,`modImmunities`) VALUES (113491,81,81,21,207000,207000,0,1,0,2000,0,11000,22000,0,0,0,0,360000,5000,0,0,0,0,0,0,1,1,'',0,1450,0,0,1,4,8,0,0,0,0,0,0,0)
UPDATE `creature_proto` SET `minhealth`=2370000,`maxhealth`=2370000 WHERE `entry`=16065
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=2200000,`maxhealth`=2200000,`mindamage`=8200,`maxdamage`=12000,`respawntime`=0 WHERE `entry`=16011
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=10879,`maxhealth`=10879,`mindamage`=900,`maxdamage`=1200 WHERE `entry`=16057
UPDATE `creature_proto` SET `minlevel`=79,`maxlevel`=79,`minhealth`=140000,`maxhealth`=140000,`mindamage`=1100,`maxdamage`=1200 WHERE `entry`=16056
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=9270000,`maxhealth`=9270000,`mindamage`=10000,`maxdamage`=11000 WHERE `entry`=15936
UPDATE `creature_proto` SET `minlevel`=83,`maxlevel`=83,`minhealth`=8440000,`maxhealth`=8440000,`mindamage`=11000,`maxdamage`=16000 WHERE `entry`=15954
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=563260,`maxhealth`=563260,`mindamage`=6600,`maxdamage`=7800 WHERE `entry`=16034
UPDATE `creature_proto` SET `minhealth`=195000,`maxhealth`=195000 WHERE `entry`=16034
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=5000,`maxdamage`=7000 WHERE `entry`=16036
UPDATE `creature_proto` SET `minlevel`=80,`maxlevel`=80,`minhealth`=37800,`maxhealth`=37800,`mindamage`=6000,`maxdamage`=7000 WHERE `entry`=16037
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=877400,`maxhealth`=877400,`mindamage`=11000,`maxdamage`=12000 WHERE `entry`=16168
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=156000,`maxhealth`=156000,`mindamage`=9000,`maxdamage`=11000 WHERE `entry`=16244
UPDATE `creature_proto` SET `minlevel`=81,`maxlevel`=81,`minhealth`=521000,`maxhealth`=521000,`mindamage`=8000,`maxdamage`=11000 WHERE `entry`=16243
    1064 - You have an error in your SQL syntax; check the the manual that corresponds to your MYSQL server version for the right syntax to use near "UPDATE `creature_proto`SET`minilevel`=83,`minhealth`=959600,`max' at line 2

    Any idea whats wrong with it or what I did wrong? +Rep for helpers!
    Reply With Quote Reply With Quote
  11. 02-01-2009 #11
    Kabukiblood's Avatar
    Kabukiblood
    Kabukiblood is offline
    Member
    Reputation
    18
    Join Date
    Oct 2008
    Posts
    38
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am getting a syntax error:

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySql server version for the right syntax to use near 'UPDATE 'creature_proto' SET 'minlevel'=83, maxlevel'=83,'minhealth'=9596000,'max'at line 2
    Reply With Quote Reply With Quote
  12. 02-01-2009 #12
    moltn's Avatar
    moltn
    moltn is offline
    Member
    Reputation
    45
    Join Date
    Dec 2007
    Posts
    81
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Send a message via MSN to moltn
    We've been robbed, Kabukiblood. Lol xD (I think the update doesn't like us. :P Lol?)
    Reply With Quote Reply With Quote
  13. 02-01-2009 #13
    Kabukiblood's Avatar
    Kabukiblood
    Kabukiblood is offline
    Member
    Reputation
    18
    Join Date
    Oct 2008
    Posts
    38
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    lol, I don't think it's the repack, or are version of MySql.
    Reply With Quote Reply With Quote
  14. 02-02-2009 #14
    Choices's Avatar
    Choices
    Choices is offline
    Member
    Reputation
    94
    Join Date
    Apr 2008
    Posts
    231
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    WoWhead infoz fail. Use the direct source Worldofwarcraft.com then get the WDB dump :P
    Reply With Quote Reply With Quote
  15. 02-02-2009 #15
    Iksf's Avatar
    Iksf
    Iksf is offline
    Active Member
    Reputation
    18
    Join Date
    May 2008
    Posts
    129
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yep sorry guys i got the SQL syntax wrong but i have just fixed it, try again now
    Reply With Quote Reply With Quote
Page 1 of 3 123 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. 2 Mount SQL Scripts and a World Enlarger!
    By Festigio in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 01-26-2008, 09:08 PM
  2. Basic understanding of SQL Scripting.
    By Drop_Warcrack in forum WoW EMU Guides & Tutorials
    Replies: 0
    Last Post: 12-28-2007, 09:15 AM
  3. Handy: Update SQL, List of all the needed SQL updates since Antrix
    By [Shon3m] in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 10-28-2007, 06:21 PM
All times are GMT -5. The time now is 12:25 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search