ArcEmu: No Loot In Gameobject - ArcEmu

Jump to content

Toggle shoutbox Lastest Announcements

dfighter  : (07 December 2014 - 12:06 PM) Arcemu is in hibernation mode, please read http://arcemu.org/fo...showtopic=26903
dfighter  : (01 January 2013 - 05:56 PM) Arcemu wishes you all a happy new year!
Hasbro  : (12 September 2012 - 10:01 AM) Please excuse our outage from the web! Our web host had a major malfunction!
dfighter  : (01 September 2012 - 04:05 PM) Since the spam bots just don't want to stop, I've enabled admin verification when registering.
dfighter  : (23 January 2012 - 09:56 PM) Please note that from now on you will need to confirm your email on the wiki in order to edit it!
Hasbro  : (31 December 2011 - 12:50 PM) Happy New Years all!
Navid  : (26 December 2011 - 04:09 AM) Merry Christmas !!!!!! Happy holidays all :)
WAmadeus  : (24 December 2011 - 03:54 PM) Merry Christmas to all!
dfighter  : (24 December 2011 - 11:05 AM) The Arcemu team wishes y'all a Merry Christmukkah!
Hasbro  : (05 October 2011 - 12:53 PM) Looking for web designers for upcoming web related project. If you're interested in designing user interfaces contact me
dfighter  : (02 September 2011 - 03:47 PM) So who here wants vehicles in Arcemu? :P http://arcemu.org/fo...showtopic=25440
Hasbro  : (14 August 2011 - 03:25 PM) Join us on irc, grab an irc client and connect to irc.freenode.net join channel #arcemu /server irc.freenode.net:6667 /join #arcemu
jackpoz  : (03 August 2011 - 05:33 AM) to all Lua Engine (old one) users: please check http://arcemu.org/fo...showtopic=25274
Hasbro  : (20 May 2011 - 05:27 PM) Looking for people experienced with CMake configuration and setup! Contact me asap
Hasbro  : (15 May 2011 - 05:03 PM) ArcEmu is recruiting C++ programmers, contact Hasbro if interested.
paroxysm  : (03 May 2011 - 06:26 PM) Updated luabridge gossip example to describe the whole gossip creation process rather than just how to create menu. Gossip tutorial
paroxysm  : (23 April 2011 - 11:35 AM) Lua writers can refer to the Luabridge Tutorials section in the Wiki to learn how to write gossip code correctly.
Hasbro  : (20 April 2011 - 05:22 PM) Thank you for your continuous contribution of bug reports, we are working on them.
Hasbro  : (17 April 2011 - 03:20 AM) Please consider donating to support our bills. Donations can be sent using PayPal to donations@arcemu.org - Thank you for your support.
paroxysm  : (10 April 2011 - 12:43 AM) Refer to the Luabridge Tutorials section in the Wiki to learn the new syntax of luabridge.
Resize Shouts Area

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

No Loot In Gameobject

#1 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 19 February 2012 - 11:33 AM

I'm trying the different event SQL patches for calendar events like noblegarden. Unfortunately most of the patches are not finished or have some faults.

Now I have a question to the Noblegarden_spawns.sql

This is the original file: ftp://arc_dev:arc_de...arden_Spawn.sql
That's my file: ftp://arc_dev:arc_de...arden_Spawn.sql

I changed INSERT INTO `loot_gameobjects` because of the new table structure.

But my question is: I do not have any of the loots like Candy Bar in my eggs (item 113768). Instead there is the Noblegarden-Chocolate.

Why is that ?
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#2 User is offline   Sdyess94 

  • Member
  • Pip
  • Group: Members
  • Posts: 70
  • Joined: 10-August 08

Posted 19 February 2012 - 11:59 AM

Candy Bar is from the Halloween world event I believe.

http://old.wowhead.c...=45072#contains (Egg loot)
http://old.wowhead.c...ntained-in-item (Candy Bar Containers)
0

#3 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 19 February 2012 - 12:40 PM

View PostSdyess94, on 19 February 2012 - 11:59 AM, said:

Candy Bar is from the Halloween world event I believe.

http://old.wowhead.c...=45072#contains (Egg loot)
http://old.wowhead.c...ntained-in-item (Candy Bar Containers)

Thanks for the link. But everthing is strange.

I got in rare cases the Spring Robe and of course everytime the Noblegarden Chocolate. But both items are NOT in my loot_gameobjects table. Is that maybe somewhere hardcoded ?
On the other side the 3 items of Halloween (you are right) are in the items table. So even if it is not correct for this event they should appear.

Now I have changed my SQL like that: ftp://arc_dev:arc_de...arden_Spawn.sql
I add 3 items and gave all items a chance of 100%.

But now I loot only the chocolate :P.

To be honest, I also don't know exactly the meaning of normal10percentchance, normal25percentchance, heroic10percentchance, heroic25percentchance

normal10percentchance means that when i set the chance to 100 I have still to try about 10x ?

Please help, I can't eat anymore chocolate :D

(P.S: On our developer server the SQL read access is public: http://landofelves.net/phpmyadmin username and password: arc_dev, just only to tell you :D)
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#4 User is offline   Grimnir 

  • Occasional Poster
  • PipPip
  • Group: Members
  • Posts: 112
  • Joined: 03-November 11
  • Gender:Male
  • Server OS:Linux

Posted 19 February 2012 - 01:24 PM

http://www.arcemu.or...oot_gameobjects

Quote

normal10percentchance

The percent chance (1 - 100) that the Item will drop in Normal 10-mode.

normal25percentchance

The percent chance (1 - 100) that the Item will drop in Normal 25-mode.

herioc10percentchance

The percent chance (1 - 100) that the Item will drop in Heroic 10-mode.

heroic25percentchance

The percent chance (1 - 100) that the Item will drop in Heroic 25-mode.

0

#5 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 19 February 2012 - 01:47 PM

View PostGrimnir, on 19 February 2012 - 01:24 PM, said:


OK, and where is the droprate for normal player not 10/25 ? And why there is no candy stick ? :P

And where is the respawn time for an opened egg ?
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#6 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 19 February 2012 - 02:07 PM

View PostMagnifikator, on 19 February 2012 - 01:47 PM, said:

OK, and where is the droprate for normal player not 10/25 ? And why there is no candy stick ? :P

The normal loot is the normal10percentchance.
As for why the item doesn't drop for you, maybe you are simply just unlucky? :D
( but no, tbh as I can see it's because you are doing the loot table conversion wrong. You leave the first field to be 0, when it should be the sound1 field of the gameobject it drops from, oh yea and also the gameobject has to be type 3 ( chest iirc ) )
"The demand for free goods is infinite."
0

#7 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 19 February 2012 - 04:59 PM

View Postdfighter, on 19 February 2012 - 02:07 PM, said:

The normal loot is the normal10percentchance.
As for why the item doesn't drop for you, maybe you are simply just unlucky? :D
( but no, tbh as I can see it's because you are doing the loot table conversion wrong. You leave the first field to be 0, when it should be the sound1 field of the gameobject it drops from, oh yea and also the gameobject has to be type 3 ( chest iirc ) )

Must be my luck :D
But I donīt agree with you. I think the sql is correct.(Have you seen that some lines are remarked out /* */). And the egg has type 3 (chest). But now I'm too tired after handling one day on eastereggs :P and work now only on a laptop. Will check it tomorrow in detail. And I set normal10percentchance to 100 for all loots in the egg. I excpected than the items will loot every time when I open an egg (for testing purpose only).
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#8 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 19 February 2012 - 05:32 PM

View PostMagnifikator, on 19 February 2012 - 04:59 PM, said:

Must be my luck :D
But I donīt agree with you. I think the sql is correct.(Have you seen that some lines are remarked out /* */). And the egg has type 3 (chest). But now I'm too tired after handling one day on eastereggs :P and work now only on a laptop. Will check it tomorrow in detail. And I set normal10percentchance to 100 for all loots in the egg. I excpected than the items will loot every time when I open an egg (for testing purpose only).

Yes you are right, I was looking at the wrong one, but still what I said stands.

INSERT INTO `loot_gameobjects` (`entryid`, `itemid`, `normal10percentchance`, `heroic10percentchance`, `mincount`, `maxcount`) VALUES
	( '113768', '7807', '100', '0', '1', '1' ),			-- Candy Bar
	( '113768', '7808', '100', '0', '1', '1' ),			-- Chocolate Square
	( '113768', '7806', '100', '0', '1', '1' ),			-- Lollipop
	( '113768', '6835', '100', '0', '1', '1' ),			-- Black Tuxedo Pants
	( '113768', '6833', '100', '0', '1', '1' ),			-- White Tuxedo Shirt
	( '113768', '19028', '100', '0', '1', '1' ),		-- Elegant Dress

That entryid is not the entry ( 113768 ) of the gameobject, but the sound1 field of that gameobject entry, which is 26884 in this case...
"The demand for free goods is infinite."
0

#9 User is offline   aaron02 

  • Member
  • Pip
  • Group: Members
  • Posts: 35
  • Joined: 04-February 09
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 20 February 2012 - 04:15 PM

i knwo what you are doing wrong
0

#10 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 20 February 2012 - 04:19 PM

View Postdfighter, on 19 February 2012 - 05:32 PM, said:

That entryid is not the entry ( 113768 ) of the gameobject, but the sound1 field of that gameobject entry, which is 26884 in this case...

Now I see what you mean. Well, I have used the Noblegarden_Spawn.sql from ArcEmu Git Source. But I think nobody has tested theses sql dumps ever :P

Do you think the table should than be loot_items instead of loot_gameobjects ?

My understanding of these table are:
1. gameobject_names: You create something like a prototype - the Brightly Colored Egg with an id of 113768
2. loot_items: You define what is inside in the id 113768, f.ex. a candy bar (7807) or a Elegant Dress (19028)
3: gameobject_spawns: Place the gameobjects in the world.

Correct ? Or not ?

But for what is loot_gameobjects than, with a sound id ? Sounds I have seen already in the gameobject_names (sound1 - sound 9)

I got nightmare about these eggs. They are everywhere. :D
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#11 User is offline   dfighter 

  • Titles are overrated
  • PipPipPipPipPipPipPipPipPipPip
  • Group: Administrator
  • Posts: 5,189
  • Joined: 14-June 08
  • IRC:dfighter
  • Gender:Male
  • Server OS:Linux

Posted 20 February 2012 - 05:21 PM

Yes all those SQL files are quite old now, Arcemu has changed a lot since when those were last used...

gameobject_names is the prototype of the GO. ( sound1 is the loot id for type 3 gamobjects, but only for those! That loot id goes into loot_gameobjects )
gameobject_spawns is the actual instances of that GO ( the spawns in the world )
loot_gameobject is the loot that is in the GOs.


loot_items is the loot in the items, like bags, or milling loot, disenchanting loot, etc. So it's not anyhow related to gameobjects.
"The demand for free goods is infinite."
0

#12 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 21 February 2012 - 12:46 PM

Thanks dfighter and aaron.

I got it. :P

Attached 3 sql files you may use for replacing the old ones in the git source.
I divided it in 3 parts: A setup file, you may never need because data it's already in the whydb but you can use it for educational purpose :D
And a spawn and despawn file.

Of course this is not the whole Noblegarden event. But unfortunately I don't know where to catch the other data.

Attached File(s)


Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#13 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 12 March 2012 - 06:39 AM

View PostMagnifikator, on 21 February 2012 - 12:46 PM, said:

Thanks dfighter and aaron.

I got it. :D

Attached 3 sql files you may use for replacing the old ones in the git source.
I divided it in 3 parts: A setup file, you may never need because data it's already in the whydb but you can use it for educational purpose :D
And a spawn and despawn file.

Of course this is not the whole Noblegarden event. But unfortunately I don't know where to catch the other data.
You can use Trinity DB. I got some events data from there. Mainly spawns and quest relations. But the spawns have wrong flags or / and factions (well the factions are easy to fix) because the tables there are much more different than the ones in arcemu. I get all spawns and the main events work in a way, but not all values are blizzlike.
0

#14 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 13 March 2012 - 01:16 PM

View PostSatanail, on 12 March 2012 - 06:39 AM, said:

You can use Trinity DB. I got some events data from there. Mainly spawns and quest relations. But the spawns have wrong flags or / and factions (well the factions are easy to fix) because the tables there are much more different than the ones in arcemu. I get all spawns and the main events work in a way, but not all values are blizzlike.

I have already tried to have a look into Trinity dbs. But I'm absolut not familar with that. So if somebody could help us on our arcemu developer server I really would appreciate this. Even if it's only a part of the event. Now we have only the eggs :D :D
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#15 User is offline   Satanail 

  • Enthusiast
  • PipPipPip
  • Group: Members
  • Posts: 150
  • Joined: 11-March 12
  • Gender:Male
  • Location:Absurdistan
  • Server OS:Windows

Posted 13 March 2012 - 06:07 PM

Well as much as i can see, the only gameobjects related to this event are the eggs. Here are the files i am working with now. Note that this is incomplete yet.
gameobject_spawns (completed)
DELETE FROM `gameobject_spawns` WHERE `id` BETWEEN '110000' AND '110219';
INSERT INTO `gameobject_spawns` (`id`, `Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`, `stateNpcLink`, `phase`, `overrides`) VALUES
	('110000','113768','0','-5572.18','-462.293','402.306','4.1197','0','0','0.882777','-0.469792','1','0','0','1','0','1','0'),
	('110001','113769','0','-5588.73','-514.072','404.096','5.47452','0','0','0.393407','-0.919364','1','0','0','1','0','1','0'),
	('110002','113770','0','-5657.99','-509.341','398.747','1.01738','0','0','0.487035','0.873382','1','0','0','1','0','1','0'),
	('110003','113771','0','-5679.2','-527.206','396.599','0.129883','0','0','0.0648957','0.997892','1','0','0','1','0','1','0'),
	('110004','113772','0','-5648.93','-500.956','396.669','5.91827','0','0','0.181445','-0.983401','1','0','0','1','0','1','0'),
	('110005','113768','0','-5606.29','-445.915','403.953','4.50064','0','0','0.777873','-0.628421','1','0','0','1','0','1','0'),
	('110006','113769','0','-5610.05','-425.467','403.297','4.33964','0','0','0.825888','-0.563834','1','0','0','1','0','1','0'),
	('110007','113770','0','-5549.5','-438.023','405.233','4.35534','0','0','0.821434','-0.570304','1','0','0','1','0','1','0'),
	('110008','113771','0','-5568.58','-417.381','416.157','3.67204','0','0','0.965034','-0.262126','1','0','0','1','0','1','0'),
	('110009','113772','0','-5597.9','-420.422','412.014','3.52674','0','0','0.981515','-0.191384','1','0','0','1','0','1','0'),
	('110010','113768','0','-5585','-427.035','424.522','4.22181','0','0','0.857652','-0.514231','1','0','0','1','0','1','0'),
	('110011','113769','0','-5531.16','-459.015','403.516','4.19039','0','0','0.865625','-0.500693','1','0','0','1','0','1','0'),
	('110012','113770','0','-5543.29','-475.611','397.919','4.41423','0','0','0.804289','-0.594238','1','0','0','1','0','1','0'),
	('110013','113771','0','-5539.12','-501.709','402.718','3.42463','0','0','0.990003','-0.141047','1','0','0','1','0','1','0'),
	('110014','113772','0','-5550.12','-499.479','401.691','1.09592','0','0','0.520947','0.853589','1','0','0','1','0','1','0'),
	('110015','113768','0','-5552.1','-528.526','403.379','0.699295','0','0','0.342566','0.939494','1','0','0','1','0','1','0'),
	('110016','113769','0','-5577.98','-516.152','404.097','2.76804','0','0','0.982608','0.185694','1','0','0','1','0','1','0'),
	('110017','113770','0','-5589.02','-499.368','400.114','3.61626','0','0','0.971968','-0.235114','1','0','0','1','0','1','0'),
	('110018','113771','0','-5595.03','-507.466','401.138','0.835169','0','0','0.405553','0.914071','1','0','0','1','0','1','0'),
	('110019','113772','0','-5615.28','-523.667','402.662','2.11537','0','0','0.87122','0.490892','1','0','0','1','0','1','0'),
	('110020','113768','0','-5615.63','-532.978','406.92','1.49097','0','0','0.678329','0.734758','1','0','0','1','0','1','0'),
	('110021','113769','0','-5639.01','-531.358','405.116','1.07471','0','0','0.511866','0.859065','1','0','0','1','0','1','0'),
	('110022','113770','0','-5645.02','-506.352','397.389','6.13267','0','0','0.0751855','-0.99717','1','0','0','1','0','1','0'),
	('110023','113771','0','-5629.9','-478.085','397.148','4.82499','0','0','0.666198','-0.745775','1','0','0','1','0','1','0'),
	('110024','113772','0','-5596.35','-454.242','402.532','5.13522','0','0','0.54298','-0.839746','1','0','0','1','0','1','0'),
	('110025','113768','0','-5584.47','-462.246','402.873','1.54203','0','0','0.696862','0.717205','1','0','0','1','0','1','0'),
	('110026','113769','0','-5591.92','-476.967','396.981','5.29231','0','0','0.475419','-0.87976','1','0','0','1','0','1','0'),
	('110027','113770','0','-9471.12','43.1883','56.5597','1.5067','0','0','0.684088','0.7294','1','0','0','1','0','1','0'),
	('110028','113771','0','-9437.51','112.982','57.576','4.86507','0','0','0.651119','-0.758976','1','0','0','1','0','1','0'),
	('110029','113772','0','-9423.57','109.77','58.6395','1.88449','0','0','0.808879','0.587974','1','0','0','1','0','1','0'),
	('110030','113768','0','-9424.83','63.7018','57.5696','4.42918','0','0','0.799825','-0.600233','1','0','0','1','0','1','0'),
	('110031','113769','0','-9416.75','54.7442','59.1231','5.99605','0','0','0.143077','-0.989712','1','0','0','1','0','1','0'),
	('110032','113770','0','-9425.34','56.1924','57.1307','0.756653','0','0','0.369366','0.929284','1','0','0','1','0','1','0'),
	('110033','113771','0','-9455.38','38.8205','56.6227','4.03962','0','0','0.900876','-0.434077','1','0','0','1','0','1','0'),
	('110034','113772','0','-9452.97','27.2894','56.5301','2.98326','0','0','0.996868','0.0790825','1','0','0','1','0','1','0'),
	('110035','113768','0','-9437.04','39.389','57.0626','1.83658','0','0','0.794565','0.607179','1','0','0','1','0','1','0'),
	('110036','113769','0','-9454.61','17.6726','58.0491','2.26462','0','0','0.905396','0.424568','1','0','0','1','0','1','0'),
	('110037','113770','0','-9470.77','-9.74519','56.5758','1.7227','0','0','0.758722','0.651415','1','0','0','1','0','1','0'),
	('110038','113771','0','-9477.11','7.08912','56.7995','0.151903','0','0','0.0758784','0.997117','1','0','0','1','0','1','0'),
	('110039','113772','0','-9484.17','13.6372','56.8493','0.576018','0','0','0.284044','0.958811','1','0','0','1','0','1','0'),
	('110040','113768','0','-9477.59','39.3136','57.4807','0.316842','0','0','0.157759','0.987478','1','0','0','1','0','1','0'),
	('110041','113769','0','-9485.15','46.0046','57.2156','0.242232','0','0','0.12082','0.992674','1','0','0','1','0','1','0'),
	('110042','113770','0','-9513.08','35.1837','57.3331','0.0851526','0','0','0.0425635','0.999094','1','0','0','1','0','1','0'),
	('110043','113771','0','-9501.08','61.728','56.6617','5.84212','0','0','0.218747','-0.975782','1','0','0','1','0','1','0'),
	('110044','113772','0','-9504.1','68.101','56.7047','5.03709','0','0','0.583512','-0.812105','1','0','0','1','0','1','0'),
	('110045','113768','0','-9499.42','83.8596','57.4257','5.81071','0','0','0.234046','-0.972226','1','0','0','1','0','1','0'),
	('110046','113769','0','-9511.45','101.96','58.6933','3.55663','0','0','0.978546','-0.206031','1','0','0','1','0','1','0'),
	('110047','113770','0','-9473.96','119.593','57.1435','4.68367','0','0','0.717187','-0.696881','1','0','0','1','0','1','0'),
	('110048','113771','0','-9469.15','101.676','58.0043','0.693849','0','0','0.340007','0.940423','1','0','0','1','0','1','0'),
	('110049','113772','0','-9473.1','78.0493','57.4364','5.28843','0','0','0.477122','-0.878837','1','0','0','1','0','1','0'),
	('110050','113768','0','-9463.99','81.5619','57.0823','1.29076','0','0','0.601501','0.798872','1','0','0','1','0','1','0'),
	('110051','113769','0','-9454.56','77.5214','57.0453','2.07616','0','0','0.86143','0.507876','1','0','0','1','0','1','0'),
	('110052','113770','0','2265.24','273.786','35.1652','3.01138','0','0','0.997881','0.0650598','1','0','0','1','0','1','0'),
	('110053','113771','0','2285.1','254.969','34.3626','4.85628','0','0','0.654447','-0.756108','1','0','0','1','0','1','0'),
	('110054','113772','0','2288.74','269.683','35.1812','5.66446','0','0','0.304454','-0.952527','1','0','0','1','0','1','0'),
	('110055','113768','0','2278.93','277.294','35.1826','6.10428','0','0','0.0893348','-0.996002','1','0','0','1','0','1','0'),
	('110056','113769','0','2217.46','260.101','34.3656','6.16319','0','0','0.0599639','-0.998201','1','0','0','1','0','1','0'),
	('110057','113770','0','2241.09','240.359','34.1166','6.0925','0','0','0.0951979','-0.995458','1','0','0','1','0','1','0'),
	('110058','113771','0','2238.64','254.641','36.0388','4.69843','0','0','0.712026','-0.702153','1','0','0','1','0','1','0'),
	('110059','113772','0','2242.84','256.763','34.1151','4.9851','0','0','0.604425','-0.796662','1','0','0','1','0','1','0'),
	('110060','113768','0','2257.66','267.047','35.0788','3.00197','0','0','0.997564','0.069754','1','0','0','1','0','1','0'),
	('110061','113769','0','2265.36','253.863','34.8159','3.9523','0','0','0.918962','-0.394345','1','0','0','1','0','1','0'),
	('110062','113770','0','2285.8','254.474','34.2964','3.24545','0','0','0.998652','-0.0519028','1','0','0','1','0','1','0'),
	('110063','113771','0','2306.67','255.891','35.0947','2.94307','0','0','0.995077','0.0991001','1','0','0','1','0','1','0'),
	('110064','113772','0','2319.59','261.456','35.1823','3.96408','0','0','0.916623','-0.399752','1','0','0','1','0','1','0'),
	('110065','113768','0','2327.93','292.866','35.1823','3.35147','0','0','0.994499','-0.104749','1','0','0','1','0','1','0'),
	('110066','113769','0','2385.44','323.192','38.5898','4.96547','0','0','0.612215','-0.790691','1','0','0','1','0','1','0'),
	('110067','113770','0','2369.98','347.343','38.1937','5.98648','0','0','0.147807','-0.989016','1','0','0','1','0','1','0'),
	('110068','113771','0','2345.9','323.965','36.1689','1.27017','0','0','0.593245','0.805022','1','0','0','1','0','1','0'),
	('110069','113772','0','2315.1','313.901','36.7118','4.96547','0','0','0.612216','-0.790691','1','0','0','1','0','1','0'),
	('110070','113768','0','2304.19','329.028','37.3369','4.01513','0','0','0.906123','-0.423014','1','0','0','1','0','1','0'),
	('110071','113769','0','2289.53','334.538','34.6499','6.25743','0','0','0.0128751','-0.999917','1','0','0','1','0','1','0'),
	('110072','113770','0','2249.87','335.382','35.1891','1.72569','0','0','0.759695','0.650279','1','0','0','1','0','1','0'),
	('110073','113771','0','2267.7','337.796','35.1685','3.85019','0','0','0.93789','-0.346934','1','0','0','1','0','1','0'),
	('110074','113772','0','2270.61','345.306','35.1892','4.16435','0','0','0.872071','-0.48938','1','0','0','1','0','1','0'),
	('110075','113768','0','2262.43','353.117','35.1892','5.36993','0','0','0.440922','-0.897545','1','0','0','1','0','1','0'),
	('110076','113769','0','2253.53','346.854','35.1891','6.17104','0','0','0.0560442','-0.998428','1','0','0','1','0','1','0'),
	('110077','113770','0','2234.79','324.935','36.5233','3.29962','0','0','0.99688','-0.078933','1','0','0','1','0','1','0'),
	('110078','113771','0','2244.76','336.054','35.1877','4.98587','0','0','0.604116','-0.796896','1','0','0','1','0','1','0'),
	('110079','113772','0','2205.68','326.787','34.9419','5.99903','0','0','0.141602','-0.989924','1','0','0','1','0','1','0'),
	('110080','113768','0','2213.65','331.877','35.1961','1.57331','0','0','0.707996','0.706217','1','0','0','1','0','1','0'),
	('110081','113769','0','2208.33','304.79','34.3426','5.39428','0','0','0.429966','-0.902845','1','0','0','1','0','1','0'),
	('110082','113770','0','2220.88','310.768','36.7282','0.210651','0','0','0.105131','0.994458','1','0','0','1','0','1','0'),
	('110083','113771','0','2230.58','301.918','36.5037','4.42039','0','0','0.802456','-0.596711','1','0','0','1','0','1','0'),
	('110084','113772','0','2223.24','303.344','35.1879','2.28803','0','0','0.910303','0.413943','1','0','0','1','0','1','0'),
	('110085','113768','0','2229.29','278.899','35.1555','0.332388','0','0','0.16543','0.986221','1','0','0','1','0','1','0'),
	('110086','113769','530','9510.57','-6804.62','17.073','1.8242','0','0','0.79079','0.612087','1','0','0','1','0','1','0'),
	('110087','113770','530','9521.05','-6860.13','21.0781','0.130877','0','0','0.0653918','0.99786','1','0','0','1','0','1','0'),
	('110088','113771','530','9551.75','-6830.38','17.6104','4.12699','0','0','0.88106','-0.473005','1','0','0','1','0','1','0'),
	('110089','113772','530','9554.75','-6830.2','16.4929','3.1688','0','0','0.999907','-0.0136057','1','0','0','1','0','1','0'),
	('110090','113768','530','9545.42','-6851','17.3644','1.13069','0','0','0.535708','0.844403','1','0','0','1','0','1','0'),
	('110091','113769','530','9543.39','-6863.25','21.0009','0.482738','0','0','0.239032','0.971012','1','0','0','1','0','1','0'),
	('110092','113770','530','9516.05','-6858.05','16.5391','4.97522','0','0','0.608352','-0.793667','1','0','0','1','0','1','0'),
	('110093','113771','530','9502.24','-6843.39','16.56','5.42682','0','0','0.415217','-0.909723','1','0','0','1','0','1','0'),
	('110094','113772','530','9484.62','-6829.57','16.6185','1.74331','0','0','0.765395','0.643561','1','0','0','1','0','1','0'),
	('110095','113768','530','9483.2','-6824.64','16.7831','5.22262','0','0','0.505777','-0.862665','1','0','0','1','0','1','0'),
	('110096','113769','530','9477.32','-6816.1','16.8213','5.45824','0','0','0.400877','-0.916132','1','0','0','1','0','1','0'),
	('110097','113770','530','9475.34','-6803.15','16.4955','6.04336','0','0','0.119626','-0.992819','1','0','0','1','0','1','0'),
	('110098','113771','530','9456.02','-6798.33','17.8346','4.60608','0','0','0.743677','-0.668539','1','0','0','1','0','1','0'),
	('110099','113772','530','9465.68','-6770.04','16.5745','3.57721','0','0','0.976373','-0.216091','1','0','0','1','0','1','0'),
	('110100','113768','530','9491.99','-6764.23','16.5058','2.80359','0','0','0.985753','0.168197','1','0','0','1','0','1','0'),
	('110101','113769','530','9516.86','-6771.11','16.4938','2.97638','0','0','0.99659','0.0825122','1','0','0','1','0','1','0'),
	('110102','113770','530','9524.29','-6814.98','16.4936','4.54718','0','0','0.76304','-0.646351','1','0','0','1','0','1','0'),
	('110103','113771','530','9543.14','-6794.87','16.4834','3.05493','0','0','0.999061','0.0433192','1','0','0','1','0','1','0'),
	('110104','113772','530','9551.25','-6807.38','16.4899','3.45155','0','0','0.988015','-0.154361','1','0','0','1','0','1','0'),
	('110105','113768','530','9555.84','-6824.24','16.4953','5.61925','0','0','0.325903','-0.945403','1','0','0','1','0','1','0'),
	('110106','113769','530','-4179.49','-12498.6','44.3612','5.3454','0','0','0.451898','-0.89207','1','0','0','1','0','1','0'),
	('110107','113770','530','-4193.3','-12458.3','45.7142','4.74457','0','0','0.695638','-0.718392','1','0','0','1','0','1','0'),
	('110108','113771','530','-4162.99','-12451.8','44.0466','2.34911','0','0','0.922517','0.385956','1','0','0','1','0','1','0'),
	('110109','113772','530','-4143.88','-12490','44.6714','3.43296','0','0','0.989407','-0.145167','1','0','0','1','0','1','0'),
	('110110','113768','530','-4140','-12518.8','45.7765','3.23896','0','0','0.998815','-0.0486653','1','0','0','1','0','1','0'),
	('110111','113769','530','-4141.64','-12533.2','45.3098','1.42862','0','0','0.655096','0.755546','1','0','0','1','0','1','0'),
	('110112','113770','530','-4154.66','-12537.1','45.5719','0.00704861','0','0','0.0035243','0.999994','1','0','0','1','0','1','0'),
	('110113','113771','530','-4168.66','-12542.6','45.3842','1.21656','0','0','0.571458','0.820632','1','0','0','1','0','1','0'),
	('110114','113772','530','-4183.33','-12564.4','40.1308','0.572535','0','0','0.282374','0.959304','1','0','0','1','0','1','0'),
	('110115','113768','530','-4207.6','-12559.9','40.677','0.541119','0','0','0.267271','0.963621','1','0','0','1','0','1','0'),
	('110116','113769','530','-4232.77','-12558.5','39.8764','5.32812','0','0','0.459588','-0.888132','1','0','0','1','0','1','0'),
	('110117','113770','530','-4233.57','-12534.1','45.78','0.462585','0','0','0.229236','0.973371','1','0','0','1','0','1','0'),
	('110118','113771','530','-4239.76','-12515.8','46.5776','1.43256','0','0','0.656582','0.754255','1','0','0','1','0','1','0'),
	('110119','113772','530','-4224.28','-12520.9','57.3901','5.37918','0','0','0.436767','-0.899575','1','0','0','1','0','1','0'),
	('110120','113768','530','-4219.7','-12506.3','45.4059','5.20247','0','0','0.514443','-0.857525','1','0','0','1','0','1','0'),
	('110121','113769','530','-4218.81','-12483.2','50.1845','1.57158','0','0','0.707385','0.706828','1','0','0','1','0','1','0'),
	('110122','113770','530','-4220.81','-12485','45.2711','3.44083','0','0','0.988828','-0.149061','1','0','0','1','0','1','0'),
	('110123','113771','530','-4227.3','-12471.5','45.7186','2.96173','0','0','0.995959','0.0898078','1','0','0','1','0','1','0'),
	('110124','113772','530','-4219.91','-12462.1','46.1824','4.96842','0','0','0.611046','-0.791595','1','0','0','1','0','1','0'),
	('110125','113768','530','-4215.75','-12440.2','44.6023','4.66605','0','0','0.723299','-0.690535','1','0','0','1','0','1','0'),
	('110126','113769','530','-4198.54','-12443.1','45.5096','5.7931','0','0','0.242598','-0.970127','1','0','0','1','0','1','0'),
	('110127','113770','530','-4186.59','-12437.9','43.6709','4.19482','0','0','0.864515','-0.502607','1','0','0','1','0','1','0'),
	('110128','113771','1','9834.42','996.991','1306.67','3.38578','0','0','0.992556','-0.121791','1','0','0','1','0','1','0'),
	('110129','113772','1','9857.8','973.055','1304.8','0.638475','0','0','0.313843','0.949475','1','0','0','1','0','1','0'),
	('110130','113768','1','9866.01','985.069','1309.35','1.02725','0','0','0.491336','0.87097','1','0','0','1','0','1','0'),
	('110131','113769','1','9871.22','987.366','1309.17','1.77338','0','0','0.774983','0.631982','1','0','0','1','0','1','0'),
	('110132','113770','1','9888.79','968.334','1309.37','5.51187','0','0','0.376167','-0.926552','1','0','0','1','0','1','0'),
	('110133','113771','1','9894.91','964.248','1310.49','5.24091','0','0','0.497866','-0.867254','1','0','0','1','0','1','0'),
	('110134','113772','1','9906.85','945.62','1313.48','0.940855','0','0','0.453267','0.891375','1','0','0','1','0','1','0'),
	('110135','113768','1','9905.5','936.252','1313.62','5.27625','0','0','0.482465','-0.875915','1','0','0','1','0','1','0'),
	('110136','113769','1','9912.13','918.466','1316.43','5.68858','0','0','0.292941','-0.956131','1','0','0','1','0','1','0'),
	('110137','113770','1','9923.98','905.402','1317.22','0.0180063','0','0','0.00900304','0.999959','1','0','0','1','0','1','0'),
	('110138','113771','1','9892.76','918.799','1307.59','2.46845','0','0','0.943892','0.330254','1','0','0','1','0','1','0'),
	('110139','113772','1','9860.8','910.839','1306.14','3.37558','0','0','0.993164','-0.116729','1','0','0','1','0','1','0'),
	('110140','113768','1','9851.2','880.204','1310.25','4.59294','0','0','0.748052','-0.66364','1','0','0','1','0','1','0'),
	('110141','113769','1','9835.31','897.141','1308.78','2.44095','0','0','0.939263','0.343199','1','0','0','1','0','1','0'),
	('110142','113770','1','9824.87','900.498','1305.55','3.75649','0','0','0.953108','-0.30263','1','0','0','1','0','1','0'),
	('110143','113771','1','9824.11','920.98','1304.55','1.81263','0','0','0.787238','0.61665','1','0','0','1','0','1','0'),
	('110144','113772','1','9809.87','935.889','1307.93','1.35318','0','0','0.626136','0.779714','1','0','0','1','0','1','0'),
	('110145','113768','1','9825.82','943.887','1306.73','1.2118','0','0','0.569504','0.821989','1','0','0','1','0','1','0'),
	('110146','113769','1','9818.16','941.709','1308.82','5.04848','0','0','0.57888','-0.815412','1','0','0','1','0','1','0'),
	('110147','113770','1','9797.18','927.063','1306.86','3.00644','0','0','0.997718','0.0675235','1','0','0','1','0','1','0'),
	('110148','113771','1','9785.09','936.851','1307.38','1.35318','0','0','0.626138','0.779713','1','0','0','1','0','1','0'),
	('110149','113772','1','9809.68','977.31','1304.27','1.82676','0','0','0.791575','0.611072','1','0','0','1','0','1','0'),
	('110150','113768','1','9784.31','964.786','1309.44','3.73921','0','0','0.955688','-0.294381','1','0','0','1','0','1','0'),
	('110151','113769','1','9837.54','978.538','1307.14','4.27721','0','0','0.843082','-0.537785','1','0','0','1','0','1','0'),
	('110152','113770','1','9778.77','964.973','1306.69','6.20301','0','0','0.0400778','-0.999197','1','0','0','1','0','1','0'),
	('110153','113771','1','9738.77','984.013','1303.77','1.04137','0','0','0.497472','0.86748','1','0','0','1','0','1','0'),
	('110154','113772','1','9726.77','970.323','1294.58','5.7459','0','0','0.265423','-0.964132','1','0','0','1','0','1','0'),
	('110155','113768','1','9698.11','952.961','1291.53','0.185278','0','0','0.0925063','0.995712','1','0','0','1','0','1','0'),
	('110156','113769','1','9700.25','889.704','1298.97','5.08616','0','0','0.563413','-0.826176','1','0','0','1','0','1','0'),
	('110157','113770','1','9738.64','884.265','1295.69','5.848','0','0','0.215879','-0.97642','1','0','0','1','0','1','0'),
	('110158','113771','1','9785.18','883.167','1298.1','4.90553','0','0','0.635633','-0.771991','1','0','0','1','0','1','0'),
	('110159','113772','1','9778.44','884.651','1297.97','3.8099','0','0','0.944688','-0.327969','1','0','0','1','0','1','0'),
	('110160','113768','1','9767.38','886.362','1298.14','4.77201','0','0','0.685717','-0.727868','1','0','0','1','0','1','0'),
	('110161','113769','1','297.2','-4657.1','16.7732','6.04909','0','0','0.11678','-0.993158','1','0','0','1','0','1','0'),
	('110162','113770','1','268.569','-4693.75','15.0267','5.3658','0','0','0.442777','-0.896632','1','0','0','1','0','1','0'),
	('110163','113771','1','266.882','-4717.16','15.0265','0.853685','0','0','0.413999','0.910277','1','0','0','1','0','1','0'),
	('110164','113772','1','273.893','-4729.49','13.5919','2.55407','0','0','0.957162','0.289553','1','0','0','1','0','1','0'),
	('110165','113768','1','273.773','-4777.38','11.8478','2.2085','0','0','0.893127','0.449805','1','0','0','1','0','1','0'),
	('110166','113769','1','297.468','-4797.06','10.145','5.99019','0','0','0.145974','-0.989288','1','0','0','1','0','1','0'),
	('110167','113770','1','284.923','-4810.53','11.9429','0.81442','0','0','0.396049','0.918229','1','0','0','1','0','1','0'),
	('110168','113771','1','289.461','-4840.14','10.9166','5.97841','0','0','0.151797','-0.988412','1','0','0','1','0','1','0'),
	('110169','113772','1','297.084','-4847.31','11.7787','2.48339','0','0','0.946333','0.323194','1','0','0','1','0','1','0'),
	('110170','113768','1','310.245','-4850.53','10.2372','2.31845','0','0','0.916494','0.400048','1','0','0','1','0','1','0'),
	('110171','113769','1','312.713','-4860.69','10.549','2.2517','0','0','0.902633','0.430411','1','0','0','1','0','1','0'),
	('110172','113770','1','332.089','-4843.46','12.0247','0.936158','0','0','0.451173','0.892437','1','0','0','1','0','1','0'),
	('110173','113771','1','345.731','-4852.46','10.3662','0.896889','0','0','0.433564','0.901123','1','0','0','1','0','1','0'),
	('110174','113772','1','338.115','-4858.18','10.3123','2.32239','0','0','0.917279','0.398244','1','0','0','1','0','1','0'),
	('110175','113768','1','337.55','-4834.48','9.99127','3.84999','0','0','0.937926','-0.346837','1','0','0','1','0','1','0'),
	('110176','113769','1','359.585','-4836.23','11.2313','4.3173','0','0','0.832134','-0.554575','1','0','0','1','0','1','0'),
	('110177','113770','1','341.753','-4809.21','10.2911','4.10917','0','0','0.88524','-0.465134','1','0','0','1','0','1','0'),
	('110178','113771','1','318.85','-4782.25','10.137','3.20596','0','0','0.999482','-0.032176','1','0','0','1','0','1','0'),
	('110179','113772','1','334.174','-4770.39','12.6355','4.27017','0','0','0.844969','-0.534816','1','0','0','1','0','1','0'),
	('110180','113768','1','366.98','-4754.08','11.812','4.71785','0','0','0.705173','-0.709035','1','0','0','1','0','1','0'),
	('110181','113769','1','367.509','-4719.81','13.5495','3.90497','0','0','0.928038','-0.372486','1','0','0','1','0','1','0'),
	('110182','113770','1','380.013','-4722.65','12.8458','3.27272','0','0','0.997851','-0.0655165','1','0','0','1','0','1','0'),
	('110183','113771','1','386.571','-4708.25','13.4001','3.43765','0','0','0.989064','-0.14749','1','0','0','1','0','1','0'),
	('110184','113772','1','364.009','-4699.68','14.6481','4.76497','0','0','0.688275','-0.72545','1','0','0','1','0','1','0'),
	('110185','113768','1','344.324','-4660.83','16.4647','6.01375','0','0','0.134308','-0.99094','1','0','0','1','0','1','0'),
	('110186','113769','1','316.132','-4664.03','16.0927','4.80424','0','0','0.673899','-0.738824','1','0','0','1','0','1','0'),
	('110187','113770','1','321.541','-4678.85','16.7263','0.951858','0','0','0.458164','0.888868','1','0','0','1','0','1','0'),
	('110188','113771','1','319.174','-4698.69','15.9669','2.43233','0','0','0.937775','0.347243','1','0','0','1','0','1','0'),
	('110189','113772','1','322.49','-4706.93','16.7168','3.99528','0','0','0.910278','-0.413999','1','0','0','1','0','1','0'),
	('110190','113768','1','-2318.7','-427.27','-5.00784','1.80544','0','0','0.785014','0.619479','1','0','0','1','0','1','0'),
	('110191','113769','1','-2310.73','-453.481','28.0788','3.27413','0','0','0.997805','-0.0662205','1','0','0','1','0','1','0'),
	('110192','113770','1','-2281.93','-440.985','-7.68513','2.9207','0','0','0.993907','0.110221','1','0','0','1','0','1','0'),
	('110193','113771','1','-2282.04','-507.952','-9.42411','1.94367','0','0','0.825921','0.563786','1','0','0','1','0','1','0'),
	('110194','113772','1','-2240.59','-319.837','-9.42471','3.51842','0','0','0.982303','-0.1873','1','0','0','1','0','1','0'),
	('110195','113768','1','-2255.57','-331.142','-9.13563','0.961946','0','0','0.462642','0.886545','1','0','0','1','0','1','0'),
	('110196','113769','1','-2213.08','-373.327','-8.34503','3.49878','0','0','0.984094','-0.177647','1','0','0','1','0','1','0'),
	('110197','113770','1','-2239.43','-402.529','-9.42193','1.70022','0','0','0.751353','0.6599','1','0','0','1','0','1','0'),
	('110198','113771','1','-2245.06','-285.102','-9.42489','3.49878','0','0','0.984094','-0.177647','1','0','0','1','0','1','0'),
	('110199','113772','1','-2250.85','-256.279','-9.47737','3.22389','0','0','0.999153','-0.0411391','1','0','0','1','0','1','0'),
	('110200','113768','1','-2282.03','-257.974','-8.4252','3.20033','0','0','0.999569','-0.0293655','1','0','0','1','0','1','0'),
	('110201','113769','1','-2318.96','-265.509','-8.65507','4.93998','0','0','0.62224','-0.782827','1','0','0','1','0','1','0'),
	('110202','113770','1','-2334.42','-275.734','-8.54136','3.66764','0','0','0.965608','-0.260001','1','0','0','1','0','1','0'),
	('110203','113771','1','-2350.32','-305.64','-9.42338','4.88108','0','0','0.645024','-0.764162','1','0','0','1','0','1','0'),
	('110204','113772','1','-2384.46','-329.426','-9.56387','5.92172','0','0','0.179749','-0.983712','1','0','0','1','0','1','0'),
	('110205','113768','1','-2373.96','-317.655','-9.66495','0.235438','0','0','0.117447','0.993079','1','0','0','1','0','1','0'),
	('110206','113769','1','-2389.36','-349.159','-9.39815','1.51956','0','0','0.688762','0.724988','1','0','0','1','0','1','0'),
	('110207','113770','1','-2361.47','-364.775','-8.53755','2.54843','0','0','0.956342','0.292251','1','0','0','1','0','1','0'),
	('110208','113771','1','-2355.47','-364.996','-8.6927','0.522106','0','0','0.258098','0.966119','1','0','0','1','0','1','0'),
	('110209','113772','1','-2338.21','-367.223','-6.49505','2.64661','0','0','0.96953','0.244973','1','0','0','1','0','1','0'),
	('110210','113768','1','-2340.9','-352.75','-8.96522','2.37172','0','0','0.926822','0.3755','1','0','0','1','0','1','0'),
	('110211','113769','1','-2379.72','-322.666','2.84507','0.215802','0','0','0.107692','0.994184','1','0','0','1','0','1','0'),
	('110212','113770','1','-2361.47','-338.039','-8.82528','5.60756','0','0','0.331425','-0.943482','1','0','0','1','0','1','0'),
	('110213','113771','1','-2341.06','-317.455','-9.18516','4.56297','0','0','0.757911','-0.652358','1','0','0','1','0','1','0'),
	('110214','113772','1','-2325.19','-384.338','-8.10101','0.659543','0','0','0.323827','0.946116','1','0','0','1','0','1','0'),
	('110215','113768','1','-2296.58','-385.843','-9.01576','1.23288','0','0','0.578135','0.815941','1','0','0','1','0','1','0'),
	('110216','113769','1','-2306.12','-417.744','-8.10044','4.24096','0','0','0.852689','-0.522419','1','0','0','1','0','1','0'),
	('110217','113770','1','-2326.03','-440.102','-5.43827','4.10744','0','0','0.885641','-0.464371','1','0','0','1','0','1','0'),
	('110218','113771','1','-2330.82','-457.583','-6.74765','5.70572','0','0','0.284736','-0.958606','1','0','0','1','0','1','0'),
	('110219','113772','1','-2351.25','-495.771','-8.98241','3.82863','0','0','0.941576','-0.336801','1','0','0','1','0','1','0');


creature_spawns (Incomplete. The commoners in TDB are messed up and there might me more spawns than there should be. There might be a problem with the display ids of the commoners.
DELETE FROM `creature_spawns` WHERE `id` BETWEEN '710000' AND '710188';
INSERT INTO `creature_spawns` (`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`, `death_state`, `mountdisplayid`, `slot1item`, `slot2item`, `slot3item`, `CanFly`, `phase`) VALUES
	('710000',32798,0,'2236.33','247.326','33.6595','2.84096',1,28304,35,'0','2048','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710001',32798,1,'323.943','-4703.51','15.8903','4.29373',1,28305,35,'0','67584','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710002',32798,530,'9495.4','-6841.51','16.986','0.807895',1,28304,35,'0','2048','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710003',32798,1,'-2336.63','-355.656','-8.74798','5.58244',1,28305,35,'0','67584','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710004',32799,0,'-5596.99','-506.959','401.155','2.73583',1,28302,35,'0','2048','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710005',32799,1,'9837.29','969.65','1308.21','0.383221',1,28303,35,'0','67584','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710006',32799,0,'-9453.86','44.7409','56.7139','1.45433',1,28302,35,'0','2048','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710007',32799,530,'-4150.79','-12492.3','44.6553','3.75029',1,28303,35,'0','67584','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710008',32836,0,'-5601.03','-512.86','401.492','1.56166',1,28306,35,'0','16777472','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710009',32836,1,'9839.27','961.92','1308.29','0.271694',1,28307,35,'0','512','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710010',32836,0,'-9451.26','42.2403','57.173','0.641447',1,28311,35,'0','16777472','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710011',32836,530,'-4155.63','-12486.1','44.7758','3.96234',1,28312,35,'0','512','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710012',32837,0,'2244.84','262.273','34.148','2.9156',1,28308,35,'0','16777472','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710013',32837,1,'333.091','-4707.97','15.6644','4.12487',1,28309,35,'0','512','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710014',32837,530,'9487.64','-6833.65','16.986','0.819677',1,28313,35,'0','16777472','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710015',32837,1,'-2343.08','-364.618','-8.4062','5.82199',1,28314,35,'0','512','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710016',20102,0,'-14440.1','509.034','26.2717','1.3439',0,1140,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710017',20102,0,'-14440.2','510.301','26.2619','5.07891',0,22368,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710018',20102,0,'-14468.7','463.642','36.9241','4.13643',0,22368,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710019',20102,0,'-14469.6','462.223','36.9248','0.279253',0,22368,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710066',20102,1,'-924.656','-3715.91','9.13173','5.06145',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710067',20102,1,'-924.099','-3718','9.18514','1.69297',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710068',20102,1,'-898.024','-3765.59','11.868','1.25664',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710069',20102,1,'-897.124','-3763.23','11.9882','4.32842',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710070',19176,1,'-1240.55','90.6357','129.002','4.83456',0,18871,104,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710071',19176,1,'-1240.74','88.4645','129.187','2.23402',0,18872,104,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710072',19173,1,'9921.56','2499.58','1317.77','5.61996',0,18867,80,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710073',19173,1,'9922.97','2498.76','1317.86','2.44346',0,18867,80,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710074',19169,530,'9374.67','-7155.09','9.33675','4.95674',0,18841,1604,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710075',19169,530,'9375.07','-7157.06','9.25588','1.6057',0,18841,1604,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710076',19169,530,'9689.33','-7345.39','11.9144','4.20624',0,18841,1604,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710077',19169,530,'9687.96','-7346.09','11.956','1.50098',0,18841,1604,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710078',19178,0,'1573.04','265.955','-43.0193','0.593412',0,18876,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710079',19178,0,'1574.55','267.583','-43.0193','3.76991',0,18875,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710080',19178,0,'1627.8','224.57','-43.0193','4.15388',0,18875,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710081',19178,0,'1626.7','222.7','-43.0193','1.01229',0,18876,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710082',19172,0,'-4829.88','-1173.25','502.277','2.49582',0,18847,875,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710083',19172,0,'-4831.74','-1172.58','502.278','6.19592',0,18846,875,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710084',20102,0,'-14313.5','508.853','8.69121','4.27606',0,19341,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710085',20102,0,'-14314','507.109','8.68829','1.22173',0,19341,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710086',20102,0,'-14440.1','509.034','26.2717','1.3439',0,19341,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710087',20102,0,'-14440.2','510.301','26.2619','5.07891',0,19341,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710088',20102,0,'-14468.7','463.642','36.9241','4.13643',0,21067,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710089',20102,0,'-14469.6','462.223','36.9248','0.279253',0,21067,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710090',19171,530,'-4045.58','-11785','9.10616','5.60251',0,18842,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710091',19171,530,'-4044.45','-11786','9.11559','2.53073',0,18842,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710092',19171,530,'-3810.52','-11710.6','-106.411','2.28638',0,18842,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710093',19171,530,'-3811.42','-11709.2','-106.409','4.64258',0,18842,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710094',19171,530,'-3909.22','-11614.8','-138.101','3.1765',0,18843,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710095',19171,530,'-3910.78','-11615.7','-138.115','0.820305',0,18843,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710096',19171,530,'-3954.31','-11702.2','-138.799','2.6529',0,18843,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710097',19171,530,'-3955.85','-11701.5','-138.82','5.72468',0,18842,1638,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710098',19148,0,'-4900.87','-957.314','501.541','4.17134',0,18844,55,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710099',19148,0,'-4901.8','-958.955','501.543','1.01229',0,18845,55,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710100',18927,0,'-8837.9','553.154','95.9797','0.15708',0,18860,12,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710101',18927,0,'-8837.23','554.917','95.7154','5.044',0,18858,12,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710102',18927,0,'-8854.78','649.83','96.7417','1.43117',0,18860,12,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710103',18927,0,'-8855.72','651.851','96.6895','5.70723',0,18860,12,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710104',20102,1,'-1030.97','-3678.41','23.2479','1.62316',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710105',20102,1,'-1031.03','-3676.2','23.1851','4.69494',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710106',20102,1,'-1031.03','-3676.2','23.1851','4.69494',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710107',20102,1,'-898.024','-3765.59','11.868','1.25664',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710108',20102,1,'-897.124','-3763.23','11.9882','4.32842',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710109',20102,1,'-924.656','-3715.91','9.13173','5.06145',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710110',20102,1,'-924.099','-3718','9.18514','1.69297',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710111',20102,1,'6791.34','-4747.01','701.617','2.21657',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710112',20102,1,'-7144.12','-3830.95','8.50543','3.26377',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710113',20102,1,'-7147.06','-3830.22','8.51396','6.05629',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710114',20102,1,'-7217.57','-3735.16','8.45314','2.28638',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710115',20102,1,'-7219.66','-3731.91','8.4635','5.13127',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710116',20102,1,'-7182.97','-3811.81','8.80395','2.3911',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710117',20102,1,'-7185.2','-3809.25','9.01346','5.51524',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710118',20102,1,'-7053.62','-3777.21','10.2047','5.25344',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710119',20102,1,'-7053','-3779.9','10.1478','1.53589',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710120',20102,1,'-7053','-3779.9','10.1478','1.53589',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710121',20102,1,'-7217.57','-3735.16','8.45314','2.28638',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710122',20102,1,'-7219.66','-3731.91','8.4635','5.13127',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710123',20102,1,'-7144.12','-3830.95','8.50543','3.26377',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710124',20102,1,'-7147.06','-3830.22','8.51396','6.05629',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710125',20102,530,'-1818.99','5305.67','-12.3448','4.03171',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710126',20102,530,'-1821.12','5303.35','-12.3448','0.767945',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710127',20102,530,'-1748.08','5493.86','-12.3448','4.2586',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710128',20102,530,'-1747.9','5492.11','-12.3448','1.3439',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710129',20102,530,'-1978.82','5365.21','-12.3448','3.63029',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710130',20102,530,'-1980.72','5364.88','-12.3225','0.226893',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710131',20102,530,'-1875.93','5376.2','-12.3448','0.820305',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710132',20102,530,'-1875.06','5378.04','-12.3448','4.36332',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710133',20102,530,'-2175.76','5414.62','50.3112','5.60251',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710134',20102,530,'-2174.14','5413.06','50.3112','2.56563',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710135',20102,530,'-1809.92','5418.64','-12.3448','5.55015',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710136',20102,530,'-1808.36','5417.01','-12.3448','2.32129',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710137',20102,530,'-1917.81','5441.85','-12.3448','2.35619',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710138',20102,530,'-1920.17','5443.52','-12.3448','5.86431',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710139',20102,530,'-1883.61','5769.28','129.641','4.15388',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710140',20102,530,'-1884.14','5766.55','129.641','1.309',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710141',20102,0,'-14440.1','509.034','26.2717','1.3439',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710142',20102,0,'-14440.2','510.301','26.2619','5.07891',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710143',20102,0,'-14468.7','463.642','36.9241','4.13643',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710144',20102,0,'-14469.6','462.223','36.9248','0.279253',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710145',20102,0,'-14313.5','508.853','8.69121','4.27606',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710146',20102,0,'-14314','507.109','8.68829','1.22173',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710147',20102,0,'-14468.7','463.642','36.9241','4.13643',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710148',20102,0,'-14469.6','462.223','36.9248','0.279253',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710149',20102,0,'-14313.5','508.853','8.69121','4.27606',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710150',20102,0,'-14314','507.109','8.68829','1.22173',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710151',20102,0,'-14440.1','509.034','26.2717','1.3439',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710152',20102,0,'-14440.2','510.301','26.2619','5.07891',0,16431,35,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710159',19175,1,'1623.41','-4402.24','12.7889','5.68977',0,16438,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710160',19175,1,'1625','-4402.88','13.1966','2.60054',0,16436,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710163',19177,1,'1689.75','-4334.92','61.7469','0.15708',0,16446,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1'),
	('710164',19177,1,'1693.4','-4334.83','61.9237','3.03687',0,16446,714,'0','0','0','4097',0,'0','0','0','0',0,0,'0','0','0','0',0,'1');

creature_quest_starter (incomplete)
DELETE FROM `creature_quest_starter` WHERE `id` IN ('18927', '19148', '19171', '19172', '19173', '20102', '19169', '19175', '19176', '19177', '19178');
INSERT INTO `creature_quest_starter` (`id`,`quest`) VALUES
 (18927,13484),
 (19148,13484),
 (19171,13484),
 (19172,13484),
 (19173,13484),
 (20102,13484),
 (20102,13483),
 (19169,13483),
 (19175,13483),
 (19176,13483),
 (19177,13483),
 (19178,13483);
 

0

#16 User is offline   Magnifikator 

  • Interested
  • PipPipPipPip
  • Group: Members
  • Posts: 398
  • Joined: 05-October 11
  • Gender:Male
  • Location:Switzerland
  • Server OS:Windows

Posted 20 March 2012 - 10:15 AM

View PostSatanail, on 13 March 2012 - 06:07 PM, said:

Well as much as i can see, the only gameobjects related to this event are the eggs. Here are the files i am working with now. Note that this is incomplete yet.
gameobject_spawns (completed)

Sorry for late response and thank you so much for the sql list. I will test it on our servers this week. But if you post another long list may better to use pastebin.com. Because this forum crashs nearly about the load. :D

And you have a PM :D
Try out the LoE ArcEmu World database. Please visit dev.LandOfElves.net.

Posted Image


0

#17 User is offline   Garvey 

  • is a cool guy
  • Group: Super Moderator
  • Posts: 331
  • Joined: 23-November 09
  • Gender:Male
  • Location:England
  • Server OS:Windows

Posted 21 March 2012 - 07:09 AM

View PostSatanail, on 13 March 2012 - 06:07 PM, said:

DELETE FROM `gameobject_spawns` WHERE `id` BETWEEN '110000' AND '110219';
INSERT INTO `gameobject_spawns` (`id`, `Entry`, `map`, `position_x`, `position_y`, `position_z`, `Facing`, `orientation1`, `orientation2`, `orientation3`, `orientation4`, `State`, `Flags`, `Faction`, `Scale`, `stateNpcLink`, `phase`, `overrides`) VALUES
	...
 



Maybe next time, you could use pastebin for walls of text? :D
But I, being poor, have only my dreams;
I have spread my dreams under your feet;
Tread softly because you tread on my dreams.
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users