Database: svn://emupedia.com/svn/ncdb
Builds u can find on Http://wow.rockon.no
If u need suport to get your server online and working.. use search on this forum!!
WRDB IS DEAD!! I STARTED ON MAKEING FIXES FOR NCDB!!
Database: svn://emupedia.com/svn/ncdb
Builds u can find on Http://wow.rockon.no
If u need suport to get your server online and working.. use search on this forum!!
WRDB IS DEAD!! I STARTED ON MAKEING FIXES FOR NCDB!!
Last edited by HenningTM; 27-08-07 at 09:28 AM.
nice , ill give a try thank you
where do i put da fix pack part 1- 6? just pun in the sql folder?
fix pack is database sql fixes. just unpack it and execute all sql files to the database useing navicat or sqlog
i got error on BT mob fix
Query:
INSERT INTO creature_spawns
(id, entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink)
VALUES
(140266350, 22900, 0, "-8835,786133", "629,271729", "94,013855", "3,439256", 0, 19653, 35, 524288, 50331648, 0, 0, 0)
Error occured at:2007-07-07 23:51:18
Line no.:11
Error Code: 1265 - Data truncated for column 'x' at row 1
Query:
INSERT INTO creature_spawns
(id, entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink)
VALUES
(140266350, 22900, 0, "-8835,786133", "629,271729", "94,013855", "3,439256", 0, 19653, 35, 524288, 50331648, 0, 0, 0)
Error occured at:2007-07-07 23:52:03
Line no.:11
Error Code: 1265 - Data truncated for column 'x' at row 1
Query:
INSERT INTO creature_spawns
(id, entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink)
VALUES
(140266350, 22900, 0, "-8835,786133", "629,271729", "94,013855", "3,439256", 0, 19653, 35, 524288, 50331648, 0, 0, 0)
Error occured at:2007-07-07 23:57:02
Line no.:11
Error Code: 1265 - Data truncated for column 'x' at row 1
Query:
INSERT INTO gameobject_spawns
(Entry, Map, x, y, z, Facing, o1, o2, o3, o4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
(23305, 0, "-4801,4", "-1121,89", "500,207", "4,09192", 0, 0, "0,889219", "-0,457483", 1, 0, 0, 1, 0)
Error occured at:2007-07-08 00:00:45
Line no.:4
Error Code: 1265 - Data truncated for column 'x' at row 1
Query:
INSERT INTO gameobject_spawns
(Entry, Map, y, z, Facing, o1, o2, o3, o4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
(23305, 0, "-4801,4", "-1121,89", "500,207", "4,09192", 0, 0, "0,889219", "-0,457483", 1, 0, 0, 1, 0)
Error occured at:2007-07-08 00:01:40
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO gameobject_spawns
(Entry, Map, y, z, Facing, o1, o2, o3, o4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
(23305, 0, "-4801,4", "-1121,89", "500,207", "4,09192", 0, 0, "0,889219", "-0,457483", 1, 0, 0, 1, 0)
Error occured at:2007-07-08 00:02:17
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO gameobject_spawns
(Entry, Map, y, z, Facing, o1, o2, o3, o4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
(23305, 0, "-4801,4", "-1121,89", "500,207", "4,09192", 0, 0, "0,889219", "-0,457483", 1, 0, 0, 1, 0)
Error occured at:2007-07-08 00:02:29
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO gameobject_spawns
(Entry, Map, y, z, Facing, o1, o2, o3, o4, State, Flags, Faction, Scale, stateNpcLink)
VALUES
(23305, 0, "-4801,4", "-1121,89", "500,207", "4,09192", 0, 0, "0,889219", "-0,457483", 1, 0, 0, 1, 0)
Error occured at:2007-07-08 00:03:02
Line no.:4
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO `gameobject_spawns` VALUES ('278832', '181366', '533', '2517.55', '-2948.02', '245.552', '5.45286', '0', '0', '0.403338', '-0.915051', '1', '0', '0', '1', '0')
Error occured at:2007-07-08 00:04:23
Line no.:11
Error Code: 1062 - Duplicate entry '278832' for key 1
Query:
UPDATE creature_proto SET level = '72', mindamage = '900.0', mana = '0', maxdamage = '1174,0', resistance0_armor = '7387', health = '44280' WHERE entry = '22174'
Error occured at:2007-07-08 00:08:17
Line no.:29
Error Code: 1265 - Data truncated for column 'maxdamage' at row 1
Query:
INSERT INTO creature_proto
(entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss)
VALUES
(22954, 72, 14, 200000, 0, 3, 0, 1216, 900, 1000, 1338, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 1, 1, "0", 0)
Error occured at:2007-07-08 00:09:31
Line no.:4
Error Code: 1062 - Duplicate entry '22954' for key 1
Query:
INSERT INTO creature_proto
(entry, level, faction, health, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss)
VALUES
(22954, 72, 14, 200000, 0, 3, 0, 1216, 900, 1000, 1338, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 120, 0, 0, 0, 0, 0, 0, 0, 1, 1, "0", 0)
Error occured at:2007-07-08 00:09:38
Line no.:4
Error Code: 1062 - Duplicate entry '22954' for key 1
pelase help me out
where is ilidan :S
ilidan dont spawn befor u do the quest. (this is blizzlike)
and for the 1 fix that got error just jump over it.
too bad you did not make any of these fixes yourself, well maybe a few but nothin too big, I have fixed BT 100% and I am not letting anybody have it lol.
Credit go`s to all that have posted fixes on terranet, silvermoonproject, emupedia, antrixproject, wow.rockon.no
yeh to bad its people like u.. i like to give a way all fixes i make and the fixes i can find on the dev forums..
try and keep it all open source:D
I gave away a few fixes for Bt but I am not gonna give them all away, you actually have 1 of my fixes in that release :D the BT mob fixes
So whats the deal with BT mobs dude.I have them all as they should be.It was fixed in BT long before you made any BT fix.If you dont wanna share its OK.Use it for yourself.
As for this fix pack, its a good thing, but should be revised first and put delete queries in fron of every new insert, since I know that in few days ppls will start complaining how they have double loots, double spawns or whatever.
...sorry that I ask, but where to find that quest?Originally Posted by HenningTM
Cheers
If you're Gm just add him manualy, if you want to kill him that is.
...it seems that he isn't in my DB, couse when I use command .lookupcreature Illidan, it doesnt give me any result, lol!
Any help?!?
Cheers
I must have an old TerraNetDB in my Sqlyog or just extract TerraNetDBRev6 and then install fixes??? If i need an old TerraNetDB . which???
ill try this one out =) , thanks for sharing it ^^
illidan is in this server, to get the quest for spawning him try and look around where he is gonna spawn im sure u find a quest giver (quests are hard) hehe.
and to people that dont get this to work, giveitup or read some post about makeing a antrix server or something..
and for or maybe if some small dobble loots gona be added ,i dont realy care, becouse 2-4days we get the best creature loot table ever. so hang in there:D
can anyone put the FULL DB , which contain all fixis
Error occured at:2007-07-08 21:38:27
Line no.:12
Error Code: 1146 - Table 'mysql.time_zone_name' doesn't exist
end more:(
Last edited by sorelsorel; 09-07-07 at 12:53 AM. Reason: er
hello! i have downloaded this. buti haven't got NPC's... why???
Big creatureloot Fix ---> hopefully this isnt my fix, since the one I posted is completely messed up and I'm working on a new one.
deeprun tram fix ---> you still fall off with this fix.
reqdisenchantskill fix ---> I made this fix and its in testing stages, lol you shouldnt just download and add everything.
Black Bow of the Betrayer ---> this is already in my items.epics.
Just a heads up.
creatureloot and quest= 14developers are makeing on my dev forum.
i dont have all fixes install on my server, but in this post i just post all i find.
deepruntram i know, it work as long as u stay still.
BIN REV 800 and FIXpack 6 (new)
Isn't the deeprun tram fix from emupedia's forums?
lol 14 developer. I did the entire creatureloot myself, it was bugged at first but I fixed it, now its complete creatureloot. And I'm almost done objectloot. Then going back to fix up creatureloot that has low drop rate.
when i log in there's no npc where did they go?
Reply With Quote