EQ Solo Server DB Updates

[djeryv]

I have posted this quite a long time ago but I still use it for my EQEmu-Rev2214 server that I thought I would repost the file for anyone that may want to use it. These settings are meant for a very low population server without BOTS. Because of the low population, you lack certain things like cool Bazaar items for sale and help from other classes/races for grouping, getting bound, and doing trade skills (like getting imbued metals and such). You also cannot call the help of a Shaman to cast SOW on you when you are about to travel with a low population server. Areas are easier to fight in alone as you can fight things one at a time (usually) and respawn times are increased for you to have time to thin the area out (especially because you are on a low population server and you usually always have an area/dungeon all to yourself). Faster Mana/Health recovery helps you keep pressing on, eliminating down time. When monsters con blue (for example) you know you really could win (and not "you could win if you have 5 friends with you because they punch super hard for a blue con"). The items you get from Tasks, or the Bazaar, are very good...but that is because you are playing alone (usually). To use this...

1. Setup EQEmu and install the PEQ DB to fill the world. Make sure it works then shut it down.
2. Download This FILE (http://www.wizardawn.com/files/eq_solo_server.zip).
3. Move all of the *.pl files into your quests/templates folder.
4. Source the solo_server.sql into your peq database.
5. Start up the server and off you go.

This package does quite a bit of stuff...

1. There are Witch NPCs outside almost all starting cities (and Plane of Knowledge) with 400+ tasks total.
2. A NPC in the Bazaar that will trade crafting items for Witch Task items. The crafting items are of the sort that are hard to get usually due to needing a high level class player character to make it.
3. A Shaman in the Plane of Knowledge that will cast Spirit of Bih'Li.
4. Stores in the Bazaar selling tons of magic items. These merchants are in the vendor stalls of the Bazaar.
5. Stores in the Bazaar selling rare spells. They are located in the center ring of the Bazaar.
6. Aggro radius decreased.
7. NPCs don't usually help their comrades.
8. Mounts are cheaper.
9. Recover Mana/Health quickly when resting.
10. Respawn times for NPCs increased.
11. No Drop/No Transfer disabled.
12. NPCs have their stats appropriate for their level (meaning you do not have a level 50 monster hitting you like they are level 70).
13. You do not lose XP or gear when you die.
14. There is a witch in the Plane of Knowledge library that will help you find level appropriate zones to play in.
15. One of the merchants in the Bazaar sells gate, binding, and spirit of wolf potions.
16. You don't lose gear or XP when you die.
17. Monster stats are tweaked so a monster that cons blue...truly is blue...not blue if you had 8 friends with you.

As for the witches with tasks...one will be in the Plane of Knowledge and the others will be near most of the starting cities (except Felwithe as there is one next to Kelethin). These NPCs are Witches of the Velvet Order. They are FINDABLE and they each have a handful of tasks that need to be done. They are placed far enough from the towns so any race can approach them and do the tasks they have. There are a total of 447 tasks among all the different Witches. The Witch in the Plane of Knowledge has tasks from Levels 20-35. The other Witches have tasks from Levels 6-20. They give Cash and XP rewards. They will also have a list of a few items that they will give for completing a task. When you get a task from one of the Witches, you will get a detailed task they want you to do. You will also see all the different items that you may get when you do the task. When a task is complete, you will get the first item in the list. If you do not want that item, simply give the item back to the Witch and she will give you the next item in the list. You can do this around and around until you get the item (from the list of rewards) that you want. Each task will have a sentence at the end that states you may trade in items in this fashion. Each task also has a recommended level so you know if you are ready to handle it or not. Each task is repeatable and has no time limits or level restrictions. Many of the witch rewards (for tasks) have their prices reduced so players can't just go off and sell them for a huge profit. The witches generally give tasks that take place around them (items to get...monsters to kill). You get rewards that will help you play solo even better.

All of the Priests of Discord get replaced with this package and turned into Teachers of Norrath. What these characters do is train the crafting skills past 21 if you have the skill points available. They also bind if asked.

Both Witches and Teachers will explain to the player where they can find the witch that will help them find level appropriate zones to play in. They will also tell the player about the Barbarian in the Plane of Knowledge. They will say where they can get gate, binding, and SOW potions. They will also bind players if asked. They will explain that Brother Dremel may have some crafting items and where to find him. Basically their dialog should really help any player find all of this stuff out...which is perfect since these characters are in all major settlement areas.

I have the no XP/Gear loss only because my wife and I like to play, but nothing is more frustrating when you have to make dinner and you just died..."man...I have to go all the way there and get my body back"...or..."the kids just left me alone for an hour and I got a bubble of XP...only to lose it in a single death". If you want to remove/tweak this, just look in the sql file for this...

UPDATE rule_values SET rule_value='100' WHERE rule_name='Character: DeathItemLossLevel';
UPDATE rule_values SET rule_value='100' WHERE rule_name='Character: DeathExpLossLevel';

...and change/delete to your liking.

Hope this makes your low population server as fun as mine is.

NOTE: Thanks goes out to Akkadius for posting the perl code for the Witch that teleports you to a zone of your choice.

-Djeryv

[c0ncrete]

there are multiple instances in brother dremel's script (holy crap it's huge!) where you are looking to match exactly the same text in more than one condition. it will always stop at the first match it finds in the chain.

in the following example, if a client says "I require a Carved Sedgewood 1-Cam Bow, good sir!", he will always respond with "Sorry, I do not have that..."
elsif($text=~/Carved Sedgewood 1-Cam Bow/i){quest::say("Sorry, I do not have that...");}
elsif($text=~/Carved Sedgewood 1-Cam Bow/i){quest::say("I do have a Carved Sedgewood 1-Cam Bow, but I need a Golden Long Spear...");}
elsif($text=~/Carved Sedgewood 1-Cam Bow/i){quest::say("I do have a Carved Sedgewood 1-Cam Bow, but I need a Platinum Bastard Sword...");}
elsif($text=~/Carved Sedgewood 1-Cam Bow/i){quest::say("I do have a Carved Sedgewood 1-Cam Bow, but I need a Berserker Leggings...");}
it'll still exchange the correct items, but the player won't know what those are without looking through the perl script, which kind of defeats the purpose of the dialog in those cases.

additionally, he'll eat anything you give him, regardless of whether or not it was something he had requested for exchange since you're not using the check_handin() and return_items() plugins.

[djeryv]

You are correct. I found quite a few duplicate named items that I have to figure out how to deal with. Brother Dremel does give back items that he does not want now though...as I just updated the zip file for that function.

With the duplicate items...I wonder how people figure out which Ancient Coin (for example) they need to do their crafting with (as there are many different ones in the database with the same exact name)? Without seeing the ID numbers...or being told you don't have the right ingredients...how would one figure it out "in game"?

[sorvani]

the identify spell provides the item lore information.

[djeryv]

the identify spell provides the item lore information.
What does the lore provide to help one determine if they have the right Ancient Coin though? Do you have an example?

[c0ncrete]

you could always have a task system set up to let the client see all of the available options for each item with variations.

the bows in the example above are all end results and not used to fashion other items. i'm not sure you intended to offer things that could be fashioned by players, assuming they could get the components via your task/exchange system where they would normally drop, but aren't assigned to loot tables yet in the latest database. eqtraders has them listed as silk, linen, hemp, and sinew.

including the variation name in the conditional statement and/or having a separate text prompt that lists the variants for the player to choose from if they request one of the items in question would help clear things up, but it'll make poor dremel have to remember even more stuff. :)

[djeryv]

Yeah...basically what I did a year or so ago was do a db dump of all items set as parts of recipes but were not available in stores. I think I even excluded items that dropped on monsters. Then I ran with the remainder to come up with what I got. I will have to think about this a bit more. If I cannot come up with a reasonable solution...maybe Brother Dremel will have to retire.

[c0ncrete]

i personally like the idea of having an alternate way to get trade skill items that aren't available yet through normal means (when i play a ranger anyway). i was considering working on something very similar myself, but wanted to make sure i didn't include items that were available via other quests (summoned via script, but never dropped) first. it may be more trouble than it's worth at the moment, seeing as how the devs are working on large database update which we'll hopefully be seeing soon.

[sorvani]

What does the lore provide to help one determine if they have the right Ancient Coin though? Do you have an example?

All items can potentially have lore information. On live (without MQ2) the only way to know what piece of something you have is to put the item on your cursor and then have someone cast the identify spell. The item's lore informatino will then be put into the chat window.

Take the PoTactics alt access quest. You have to hunt for 4 Quarter of a Diaku Emblem. See this screenshot.
http://everquest.allakhazam.com/db/item.html?item=21761

Then look at the items table in your database.
SELECT id,Name,lore FROM items WHERE id BETWEEN 29216 AND 29219;

id , Name , lore
29216, Quarter of a Diaku Emblem, The top right quarter
29217, Quarter of a Diaku Emblem, The bottom right quarter
29218, Quarter of a Diaku Emblem, The top left quarter
29219, Quarter of a Diaku Emblem, The bottom left quarter


Obviously since these are lore you can just keep trying to loot until you have 4, but you get the idea.

The VP quest pieces are another example. and you do not want to get those all messed up and turn in the wrong ones at the wrong time.

[djeryv]

Alright...I think I have it straightened out enough for Brother Dremel to stay. Out of the hundreds and thousands of items, there were very few duplicate in name. I now just have Brother Dremel give all of the items with the exact name and then the player can sort it out after that. This means if they ask for a "Carved Sedgewood 1-Cam Bow", Brother Dremel will state that he has 4 of them and give all 4 different ones when he gets the item he wants. The download link in the original post at the top has the latest files for this change.

[Dabloon]

What would cause the issue where the witches do not respond when players say the words simple or difficult?

EDIT: I changed the ids to 1,2,3,4,5 as a test and the witches responded to the text but still do not respond to the text when using the ids given in your sql

[Furinex]

Sorry for resurrecting this. You wouldnt happen to have just the merchaints in the bazaar and their item pools in an SQL would you?

[djeryv]

Here are the spell merchants in the Bazaar...

LOCK TABLES `npc_types` WRITE;
INSERT INTO npc_types (id, merchant_id, name, lastname, level, race, class, bodytype, hp, gender, texture, face, ac, findable) VALUES
('800083', '800083', 'Tabarang', 'Scribed Spells', '50', '3', '41', '1', '9000', '0', '10', '1', '9000', '1'),
('800084', '800084', 'Reliska', 'Scribed Spells', '50', '6', '41', '1', '9000', '1', '12', '1', '9000', '1'),
('800085', '800085', 'Srakar', 'Scribed Spells', '50', '12', '41', '1', '9000', '0', '13', '1', '9000', '1'),
('800086', '800086', 'Jezbella', 'Scribed Spells', '50', '330', '41', '1', '9000', '1', '14', '1', '9000', '1');
UNLOCK TABLES;

LOCK TABLES `spawn2` WRITE;
INSERT INTO spawn2 (spawngroupID, zone, x, y, z, heading, respawntime) VALUES
('800083', 'bazaar', '-56.4626', '-56.514', '2', '32', '300'),
('800084', 'bazaar', '-18.5366', '-79.4465', '2', '248', '300'),
('800085', 'bazaar', '68.9053', '-48.2277', '2', '205', '300'),
('800086', 'bazaar', '-16.3776', '82.6584', '2', '134', '300');
UNLOCK TABLES;

LOCK TABLES `spawngroup` WRITE;
INSERT INTO spawngroup (id, name) VALUES
('800083', 'bazaar_djeryv_aa'),
('800084', 'bazaar_djeryv_bb'),
('800085', 'bazaar_djeryv_cc'),
('800086', 'bazaar_djeryv_dd');
UNLOCK TABLES;

LOCK TABLES `spawnentry` WRITE;
INSERT INTO spawnentry (spawngroupID, npcID, chance) VALUES
('800083', '800083', '100'),
('800084', '800084', '100'),
('800085', '800085', '100'),
('800086', '800086', '100');
UNLOCK TABLES;

UPDATE items SET price=7877 WHERE id=59572;
UPDATE items SET price=7877 WHERE id=15924;
UPDATE items SET price=7877 WHERE id=9722;

LOCK TABLES `merchantlist` WRITE;
INSERT INTO merchantlist (merchantid, item, slot) VALUES
('800083', '7117', '1'),
('800083', '7118', '2'),
('800083', '7119', '3'),
('800083', '7120', '4'),
('800083', '7121', '5'),
('800083', '7608', '6'),
('800083', '7609', '7'),
('800083', '7610', '8'),
('800083', '7618', '9'),
('800083', '7619', '10'),
('800083', '7620', '11'),
('800083', '7628', '12'),
('800083', '7629', '13'),
('800083', '7630', '14'),
('800083', '7640', '15'),
('800083', '7648', '16'),
('800083', '7649', '17'),
('800083', '7650', '18'),
('800083', '7656', '19'),
('800083', '7658', '20'),
('800083', '7659', '21'),
('800083', '7660', '22'),
('800083', '7668', '23'),
('800083', '7669', '24'),
('800083', '7670', '25'),
('800083', '9722', '26'),
('800083', '15021', '27'),
('800083', '15024', '28'),
('800083', '15025', '29'),
('800083', '15049', '30'),
('800083', '15055', '31'),
('800083', '15056', '32'),
('800083', '15064', '33'),
('800083', '15073', '34'),
('800083', '15074', '35'),
('800083', '15090', '36'),
('800083', '15103', '37'),
('800083', '15104', '38'),
('800083', '15105', '39'),
('800083', '15127', '40'),
('800083', '15132', '41'),
('800083', '15178', '42'),
('800083', '15180', '43'),
('800083', '15184', '44'),
('800083', '15185', '45'),
('800083', '15186', '46'),
('800083', '15191', '47'),
('800083', '15192', '48'),
('800083', '15193', '49'),
('800083', '15194', '50'),
('800083', '15199', '51'),
('800083', '15228', '52'),
('800083', '15261', '53'),
('800083', '15281', '54'),
('800083', '15305', '55'),
('800083', '15335', '56'),
('800083', '15364', '57'),
('800083', '15370', '58'),
('800083', '15413', '59'),
('800083', '15415', '60'),
('800083', '15417', '61'),
('800083', '15440', '62'),
('800083', '15441', '63'),
('800083', '15442', '64'),
('800083', '15454', '65'),
('800083', '15456', '66'),
('800083', '15457', '67'),
('800083', '15459', '68'),
('800083', '15460', '69'),
('800083', '15461', '70'),
('800083', '15462', '71'),
('800083', '15463', '72'),
('800083', '15467', '73'),
('800083', '15468', '74'),
('800083', '15469', '75'),
('800083', '15471', '76'),
('800083', '15478', '77'),
('800083', '15492', '78'),
('800083', '15495', '79'),
('800084', '15496', '1'),
('800084', '15497', '2'),
('800084', '15498', '3'),
('800084', '15499', '4'),
('800084', '15561', '5'),
('800084', '15566', '6'),
('800084', '15569', '7'),
('800084', '15570', '8'),
('800084', '15571', '9'),
('800084', '15572', '10'),
('800084', '15573', '11'),
('800084', '15574', '12'),
('800084', '15575', '13'),
('800084', '15576', '14'),
('800084', '15622', '15'),
('800084', '15623', '16'),
('800084', '15624', '17'),
('800084', '15625', '18'),
('800084', '15628', '19'),
('800084', '15629', '20'),
('800084', '15630', '21'),
('800084', '15631', '22'),
('800084', '15633', '23'),
('800084', '15634', '24'),
('800084', '15635', '25'),
('800084', '15643', '26'),
('800084', '15646', '27'),
('800084', '15731', '28'),
('800084', '15863', '29'),
('800084', '15924', '30'),
('800084', '15995', '31'),
('800084', '15997', '32'),
('800084', '16217', '33'),
('800084', '16219', '34'),
('800084', '16226', '35'),
('800084', '16240', '36'),
('800084', '16318', '37'),
('800084', '16319', '38'),
('800084', '16321', '39'),
('800084', '16339', '40'),
('800084', '16417', '41'),
('800084', '16418', '42'),
('800084', '16426', '43'),
('800084', '16428', '44'),
('800084', '16430', '45'),
('800084', '16434', '46'),
('800084', '16441', '47'),
('800084', '16443', '48'),
('800084', '16445', '49'),
('800084', '19203', '50'),
('800084', '19206', '51'),
('800084', '19209', '52'),
('800084', '19212', '53'),
('800084', '19216', '54'),
('800084', '19218', '55'),
('800084', '19221', '56'),
('800084', '19222', '57'),
('800084', '19223', '58'),
('800084', '19224', '59'),
('800084', '19225', '60'),
('800084', '19228', '61'),
('800084', '19229', '62'),
('800084', '19230', '63'),
('800084', '19232', '64'),
('800084', '19233', '65'),
('800084', '19234', '66'),
('800084', '19235', '67'),
('800084', '19241', '68'),
('800084', '19244', '69'),
('800084', '19246', '70'),
('800084', '19247', '71'),
('800084', '19250', '72'),
('800084', '19252', '73'),
('800084', '19253', '74'),
('800084', '19255', '75'),
('800084', '19256', '76'),
('800084', '19258', '77'),
('800084', '19259', '78'),
('800084', '19260', '79'),
('800085', '19261', '1'),
('800085', '19262', '2'),
('800085', '19263', '3'),
('800085', '19264', '4'),
('800085', '19266', '5'),
('800085', '19267', '6'),
('800085', '19269', '7'),
('800085', '19271', '8'),
('800085', '19274', '9'),
('800085', '19275', '10'),
('800085', '19277', '11'),
('800085', '19278', '12'),
('800085', '19280', '13'),
('800085', '19281', '14'),
('800085', '19282', '15'),
('800085', '19284', '16'),
('800085', '19285', '17'),
('800085', '19286', '18'),
('800085', '19288', '19'),
('800085', '19289', '20'),
('800085', '19290', '21'),
('800085', '19291', '22'),
('800085', '19292', '23'),
('800085', '19293', '24'),
('800085', '19296', '25'),
('800085', '19297', '26'),
('800085', '19299', '27'),
('800085', '19302', '28'),
('800085', '19303', '29'),
('800085', '19305', '30'),
('800085', '19307', '31'),
('800085', '19309', '32'),
('800085', '19311', '33'),
('800085', '19312', '34'),
('800085', '19313', '35'),
('800085', '19314', '36'),
('800085', '19315', '37'),
('800085', '19317', '38'),
('800085', '19318', '39'),
('800085', '19319', '40'),
('800085', '19322', '41'),
('800085', '19326', '42'),
('800085', '19328', '43'),
('800085', '19330', '44'),
('800085', '19331', '45'),
('800085', '19332', '46'),
('800085', '19335', '47'),
('800085', '19336', '48'),
('800085', '19339', '49'),
('800085', '19341', '50'),
('800085', '19342', '51'),
('800085', '19343', '52'),
('800085', '19344', '53'),
('800085', '19345', '54'),
('800085', '19347', '55'),
('800085', '19348', '56'),
('800085', '19351', '57'),
('800085', '19354', '58'),
('800085', '19356', '59'),
('800085', '19358', '60'),
('800085', '19360', '61'),
('800085', '19361', '62'),
('800085', '19362', '63'),
('800085', '19363', '64'),
('800085', '19364', '65'),
('800085', '19367', '66'),
('800085', '19370', '67'),
('800085', '19371', '68'),
('800085', '19372', '69'),
('800085', '19374', '70'),
('800085', '19384', '71'),
('800085', '19387', '72'),
('800085', '19388', '73'),
('800085', '19389', '74'),
('800085', '19391', '75'),
('800085', '19395', '76'),
('800085', '19396', '77'),
('800085', '19400', '78'),
('800085', '19401', '79'),
('800086', '19402', '1'),
('800086', '19405', '2'),
('800086', '19406', '3'),
('800086', '19407', '4'),
('800086', '19408', '5'),
('800086', '19409', '6'),
('800086', '19410', '7'),
('800086', '19411', '8'),
('800086', '19413', '9'),
('800086', '19414', '10'),
('800086', '19415', '11'),
('800086', '19416', '12'),
('800086', '19417', '13'),
('800086', '19418', '14'),
('800086', '19419', '15'),
('800086', '19420', '16'),
('800086', '19421', '17'),
('800086', '19422', '18'),
('800086', '19423', '19'),
('800086', '19424', '20'),
('800086', '19425', '21'),
('800086', '19473', '22'),
('800086', '19474', '23'),
('800086', '19480', '24'),
('800086', '19481', '25'),
('800086', '19495', '26'),
('800086', '19496', '27'),
('800086', '19497', '28'),
('800086', '19519', '29'),
('800086', '19520', '30'),
('800086', '19522', '31'),
('800086', '19523', '32'),
('800086', '19525', '33'),
('800086', '19526', '34'),
('800086', '19527', '35'),
('800086', '19528', '36'),
('800086', '19529', '37'),
('800086', '19533', '38'),
('800086', '19534', '39'),
('800086', '19535', '40'),
('800086', '19536', '41'),
('800086', '19543', '42'),
('800086', '21691', '43'),
('800086', '21692', '44'),
('800086', '21693', '45'),
('800086', '21694', '46'),
('800086', '21695', '47'),
('800086', '28454', '48'),
('800086', '28456', '49'),
('800086', '28462', '50'),
('800086', '28463', '51'),
('800086', '28466', '52'),
('800086', '28467', '53'),
('800086', '30404', '54'),
('800086', '30405', '55'),
('800086', '30406', '56'),
('800086', '30409', '57'),
('800086', '30410', '58'),
('800086', '30411', '59'),
('800086', '30414', '60'),
('800086', '30416', '61'),
('800086', '30422', '62'),
('800086', '30426', '63'),
('800086', '30430', '64'),
('800086', '30431', '65'),
('800086', '30432', '66'),
('800086', '30435', '67'),
('800086', '30442', '68'),
('800086', '30446', '69'),
('800086', '30447', '70'),
('800086', '30460', '71'),
('800086', '30472', '72'),
('800086', '30475', '73'),
('800086', '59572', '74');
UNLOCK TABLES;

Here are the other merchants in the Bazaar...

LOCK TABLES `npc_types` WRITE;
INSERT INTO npc_types (id, merchant_id, name, lastname, level, race, class, bodytype, hp, gender, texture, face, ac, findable) VALUES
('800023', '800023', 'Brother_Xalattis', 'Velvet Order Merchant', '50', '3', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800024', '800024', 'Sister_Odana', 'Velvet Order Merchant', '50', '6', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800025', '800025', 'Brother_Hakaf', 'Velvet Order Merchant', '50', '12', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800026', '800026', 'Sister_Oraura', 'Velvet Order Merchant', '50', '330', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800027', '800027', 'Brother_Kenun', 'Velvet Order Merchant', '50', '6', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800028', '800028', 'Sister_Esea', 'Velvet Order Merchant', '50', '5', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800029', '800029', 'Brother_Olzix', 'Velvet Order Merchant', '50', '3', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800030', '800030', 'Sister_Vilida', 'Velvet Order Merchant', '50', '128', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800031', '800031', 'Brother_Zuta', 'Velvet Order Merchant', '50', '1', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800032', '800032', 'Sister_Kemni', 'Velvet Order Merchant', '50', '5', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800033', '800033', 'Brother_Necabas', 'Velvet Order Merchant', '50', '3', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800034', '800034', 'Sister_Xode', 'Velvet Order Merchant', '50', '6', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800035', '800035', 'Brother_Zotav', 'Velvet Order Merchant', '50', '12', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800036', '800036', 'Sister_Duxlia', 'Velvet Order Merchant', '50', '128', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800037', '800037', 'Brother_Rahre', 'Velvet Order Merchant', '50', '1', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800038', '800038', 'Sister_Telra', 'Velvet Order Merchant', '50', '5', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800039', '800039', 'Brother_Surek', 'Velvet Order Merchant', '50', '3', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800040', '800040', 'Sister_Ladra', 'Velvet Order Merchant', '50', '6', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800041', '800041', 'Brother_Sedod', 'Velvet Order Merchant', '50', '12', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800042', '800042', 'Sister_Aziba', 'Velvet Order Merchant', '50', '330', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800022', '800022', 'Sister_Iria', 'Velvet Order Merchant', '50', '5', '41', '1', '9000', '1', '11', '1', '9000', '1'),
('800021', '800021', 'Brother_Satu', 'Velvet Order Merchant', '50', '1', '41', '1', '9000', '0', '11', '1', '9000', '1'),
('800020', '800020', 'Sister_Iria', 'Velvet Order Merchant', '50', '128', '41', '1', '9000', '1', '11', '1', '9000', '1');
UNLOCK TABLES;

LOCK TABLES `spawn2` WRITE;
INSERT INTO spawn2 (spawngroupID, zone, x, y, z, heading, respawntime) VALUES
('800020', 'bazaar', '-217.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800021', 'bazaar', '-230.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800022', 'bazaar', '-248.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800023', 'bazaar', '-262.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800024', 'bazaar', '-280.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800025', 'bazaar', '-294.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800026', 'bazaar', '-377.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800027', 'bazaar', '-390.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800028', 'bazaar', '-407.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800029', 'bazaar', '-422.000000', '113.000000', '-29.000000', '250.000000', '300'),
('800030', 'bazaar', '-422.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800031', 'bazaar', '-407.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800032', 'bazaar', '-390.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800033', 'bazaar', '-377.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800034', 'bazaar', '-359.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800035', 'bazaar', '-344.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800036', 'bazaar', '-317.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800037', 'bazaar', '-294.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800038', 'bazaar', '-280.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800039', 'bazaar', '-262.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800040', 'bazaar', '-248.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800041', 'bazaar', '-230.000000', '197.000000', '-29.000000', '130.000000', '300'),
('800042', 'bazaar', '-217.000000', '197.000000', '-29.000000', '130.000000', '300');
UNLOCK TABLES;

LOCK TABLES `spawngroup` WRITE;
INSERT INTO spawngroup (id, name) VALUES
('800020', 'bazaar_djeryv_a'),
('800021', 'bazaar_djeryv_b'),
('800022', 'bazaar_djeryv_c'),
('800023', 'bazaar_djeryv_d'),
('800024', 'bazaar_djeryv_e'),
('800025', 'bazaar_djeryv_f'),
('800026', 'bazaar_djeryv_g'),
('800027', 'bazaar_djeryv_h'),
('800028', 'bazaar_djeryv_i'),
('800029', 'bazaar_djeryv_j'),
('800030', 'bazaar_djeryv_k'),
('800031', 'bazaar_djeryv_l'),
('800032', 'bazaar_djeryv_m'),
('800033', 'bazaar_djeryv_n'),
('800034', 'bazaar_djeryv_o'),
('800035', 'bazaar_djeryv_p'),
('800036', 'bazaar_djeryv_q'),
('800037', 'bazaar_djeryv_r'),
('800038', 'bazaar_djeryv_s'),
('800039', 'bazaar_djeryv_t'),
('800040', 'bazaar_djeryv_u'),
('800041', 'bazaar_djeryv_v'),
('800042', 'bazaar_djeryv_w');
UNLOCK TABLES;

LOCK TABLES `spawnentry` WRITE;
INSERT INTO spawnentry (spawngroupID, npcID, chance) VALUES
('800020', '800020', '100'),
('800021', '800021', '100'),
('800022', '800022', '100'),
('800023', '800023', '100'),
('800024', '800024', '100'),
('800025', '800025', '100'),
('800026', '800026', '100'),
('800027', '800027', '100'),
('800028', '800028', '100'),
('800029', '800029', '100'),
('800030', '800030', '100'),
('800031', '800031', '100'),
('800032', '800032', '100'),
('800033', '800033', '100'),
('800034', '800034', '100'),
('800035', '800035', '100'),
('800036', '800036', '100'),
('800037', '800037', '100'),
('800038', '800038', '100'),
('800039', '800039', '100'),
('800040', '800040', '100'),
('800041', '800041', '100'),
('800042', '800042', '100');
UNLOCK TABLES;

LOCK TABLES `merchantlist` WRITE;
INSERT INTO merchantlist (merchantid, item, slot) VALUES
('800020', '11452', '1'),
('800020', '11453', '2'),
('800020', '11454', '3'),
('800020', '11455', '4'),
('800020', '11458', '5'),
('800020', '11459', '6'),
('800020', '11460', '7'),
('800020', '11461', '8'),
('800020', '11464', '9'),
('800020', '11468', '10'),
('800020', '11469', '11'),
('800020', '11470', '12'),
('800020', '11471', '13'),
('800020', '14193', '14'),
('800020', '14281', '15'),
('800020', '14459', '16'),
('800020', '14460', '17'),
('800020', '14461', '18'),
('800020', '14462', '19'),
('800020', '14463', '20'),
('800020', '14464', '21'),
('800020', '14467', '22'),
('800020', '14468', '23'),
('800020', '14469', '24'),
('800020', '14532', '25'),
('800020', '14533', '26'),
('800020', '14607', '27'),
('800020', '14619', '28'),
('800020', '14627', '29'),
('800020', '14631', '30'),
('800020', '14635', '31'),
('800020', '14639', '32'),
('800020', '14643', '33'),
('800020', '14647', '34'),
('800020', '14651', '35'),
('800020', '14655', '36'),
('800020', '14659', '37'),
('800020', '14663', '38'),
('800020', '14667', '39'),
('800020', '14671', '40'),
('800020', '14675', '41'),
('800020', '14679', '42'),
('800020', '14686', '43'),
('800020', '14687', '44'),
('800020', '14688', '45'),
('800020', '14689', '46'),
('800020', '14690', '47'),
('800020', '14691', '48'),
('800020', '14692', '49'),
('800020', '14693', '50'),
('800020', '14695', '51'),
('800020', '14696', '52'),
('800020', '14697', '53'),
('800020', '14698', '54'),
('800020', '14699', '55'),
('800020', '14700', '56'),
('800020', '14701', '57'),
('800020', '14702', '58'),
('800020', '14703', '59'),
('800020', '14704', '60'),
('800020', '14705', '61'),
('800020', '14706', '62'),
('800020', '14707', '63'),
('800020', '16614', '64'),
('800020', '16638', '65'),
('800020', '16647', '66'),
('800020', '16654', '67'),
('800020', '16655', '68'),
('800020', '16662', '69'),
('800020', '16670', '70'),
('800020', '16678', '71'),
('800020', '16686', '72'),
('800020', '16687', '73'),
('800020', '16694', '74'),
('800020', '16702', '75'),
('800020', '16703', '76'),
('800020', '16710', '77'),
('800020', '16718', '78'),
('800020', '16726', '79'),
('800021', '16734', '1'),
('800021', '16735', '2'),
('800021', '16742', '3'),
('800021', '16743', '4'),
('800021', '16750', '5'),
('800021', '16751', '6'),
('800021', '16758', '7'),
('800021', '16774', '8'),
('800021', '16776', '9'),
('800021', '16778', '10'),
('800021', '16780', '11'),
('800021', '16782', '12'),
('800021', '16784', '13'),
('800021', '16785', '14'),
('800021', '16786', '15'),
('800021', '16789', '16'),
('800021', '16790', '17'),
('800021', '16791', '18'),
('800021', '16792', '19'),
('800021', '16794', '20'),
('800021', '16796', '21'),
('800021', '16798', '22'),
('800021', '16800', '23'),
('800021', '16802', '24'),
('800021', '16804', '25'),
('800021', '16806', '26'),
('800021', '16808', '27'),
('800021', '16810', '28'),
('800021', '16812', '29'),
('800021', '16814', '30'),
('800021', '16889', '31'),
('800021', '20548', '32'),
('800021', '20552', '33'),
('800021', '20553', '34'),
('800021', '20554', '35'),
('800021', '20555', '36'),
('800021', '20556', '37'),
('800021', '20560', '38'),
('800021', '20561', '39'),
('800021', '20562', '40'),
('800021', '20563', '41'),
('800021', '20564', '42'),
('800021', '20568', '43'),
('800021', '20569', '44'),
('800021', '20570', '45'),
('800021', '20571', '46'),
('800021', '20572', '47'),
('800021', '20573', '48'),
('800021', '20574', '49'),
('800021', '20575', '50'),
('800021', '20576', '51'),
('800021', '20580', '52'),
('800021', '20584', '53'),
('800021', '20588', '54'),
('800021', '20592', '55'),
('800021', '20596', '56'),
('800021', '20890', '57'),
('800021', '20894', '58'),
('800021', '21037', '59'),
('800021', '21040', '60'),
('800021', '21041', '61'),
('800021', '21042', '62'),
('800021', '21043', '63'),
('800021', '21044', '64'),
('800021', '21046', '65'),
('800021', '21047', '66'),
('800021', '21048', '67'),
('800021', '21071', '68'),
('800021', '21074', '69'),
('800021', '21075', '70'),
('800021', '21076', '71'),
('800021', '21077', '72'),
('800021', '21078', '73'),
('800021', '21080', '74'),
('800021', '21081', '75'),
('800021', '21082', '76'),
('800021', '21083', '77'),
('800021', '21086', '78'),
('800021', '21087', '79'),
('800022', '21088', '1'),
('800022', '21089', '2'),
('800022', '21090', '3'),
('800022', '21092', '4'),
('800022', '21093', '5'),
('800022', '21094', '6'),
('800022', '21095', '7'),
('800022', '21098', '8'),
('800022', '21099', '9'),
('800022', '21101', '10'),
('800022', '21102', '11'),
('800022', '21103', '12'),
('800022', '21104', '13'),
('800022', '21105', '14'),
('800022', '21106', '15'),
('800022', '21107', '16'),
('800022', '21110', '17'),
('800022', '21111', '18'),
('800022', '21112', '19'),
('800022', '21113', '20'),
('800022', '21114', '21'),
('800022', '21116', '22'),
('800022', '21117', '23'),
('800022', '21118', '24'),
('800022', '21119', '25'),
('800022', '21122', '26'),
('800022', '21123', '27'),
('800022', '21124', '28'),
('800022', '21125', '29'),
('800022', '21126', '30'),
('800022', '21128', '31'),
('800022', '21129', '32'),
('800022', '21130', '33'),
('800022', '21131', '34'),
('800022', '21134', '35'),
('800022', '21135', '36'),
('800022', '21136', '37'),
('800022', '21137', '38'),
('800022', '21138', '39'),
('800022', '21140', '40'),
('800022', '21141', '41'),
('800022', '21142', '42'),
('800022', '21143', '43'),
('800022', '21146', '44'),
('800022', '21147', '45'),
('800022', '21148', '46'),
('800022', '21149', '47'),
('800022', '21150', '48'),
('800022', '21151', '49'),
('800022', '21152', '50'),
('800022', '21153', '51'),
('800022', '21154', '52'),
('800022', '21155', '53'),
('800022', '21158', '54'),
('800022', '21159', '55'),
('800022', '21160', '56'),
('800022', '21161', '57'),
('800022', '21162', '58'),
('800022', '21164', '59'),
('800022', '21165', '60'),
('800022', '21167', '61'),
('800022', '21170', '62'),
('800022', '21171', '63'),
('800022', '21172', '64'),
('800022', '21173', '65'),
('800022', '21174', '66'),
('800022', '21176', '67'),
('800022', '21177', '68'),
('800022', '21215', '69'),
('800022', '21218', '70'),
('800022', '21219', '71'),
('800022', '21220', '72'),
('800022', '21221', '73'),
('800022', '21222', '74'),
('800022', '21224', '75'),
('800022', '21225', '76'),
('800022', '21227', '77'),
('800022', '21230', '78'),
('800022', '21231', '79'),
('800023', '21232', '1'),
('800023', '21233', '2'),
('800023', '21234', '3'),
('800023', '21236', '4'),
('800023', '21237', '5'),
('800023', '21240', '6'),
('800023', '21243', '7'),
('800023', '21244', '8'),
('800023', '21245', '9'),
('800023', '21246', '10'),
('800023', '21247', '11'),
('800023', '21249', '12'),
('800023', '21250', '13'),
('800023', '21252', '14'),
('800023', '21255', '15'),
('800023', '21256', '16'),
('800023', '21257', '17'),
('800023', '21258', '18'),
('800023', '21259', '19'),
('800023', '21261', '20'),
('800023', '21262', '21'),
('800023', '21264', '22'),
('800023', '21267', '23'),
('800023', '21268', '24'),
('800023', '21269', '25'),
('800023', '21270', '26'),
('800023', '21271', '27'),
('800023', '21273', '28'),
('800023', '21274', '29'),
('800023', '21277', '30'),
('800023', '21280', '31'),
('800023', '21281', '32'),
('800023', '21282', '33'),
('800023', '21283', '34'),
('800023', '21284', '35'),
('800023', '21286', '36'),
('800023', '21287', '37'),
('800023', '21293', '38'),
('800023', '21295', '39'),
('800023', '21300', '40'),
('800023', '21527', '41'),
('800023', '21535', '42'),
('800023', '21546', '43'),
('800023', '21548', '44'),
('800023', '21550', '45'),
('800023', '21551', '46'),
('800023', '22345', '47'),
('800023', '22346', '48'),
('800023', '22347', '49'),
('800023', '22348', '50'),
('800023', '22349', '51'),
('800023', '22350', '52'),
('800023', '22351', '53'),
('800023', '22352', '54'),
('800023', '22353', '55'),
('800023', '22354', '56'),
('800023', '22355', '57'),
('800023', '22356', '58'),
('800023', '22381', '59'),
('800023', '22382', '60'),
('800023', '22383', '61'),
('800023', '22384', '62'),
('800023', '22385', '63'),
('800023', '22386', '64'),
('800023', '22387', '65'),
('800023', '22388', '66'),
('800023', '22389', '67'),
('800023', '22390', '68'),
('800023', '22391', '69'),
('800023', '22392', '70'),
('800023', '22417', '71'),
('800023', '22418', '72'),
('800023', '22419', '73'),
('800023', '22420', '74'),
('800023', '22421', '75'),
('800023', '22422', '76'),
('800023', '22423', '77'),
('800023', '22424', '78'),
('800023', '22425', '79'),
('800024', '22426', '1'),
('800024', '22427', '2'),
('800024', '22428', '3'),
('800024', '22432', '4'),
('800024', '22434', '5'),
('800024', '22439', '6'),
('800024', '22444', '7'),
('800024', '22446', '8'),
('800024', '22451', '9'),
('800024', '22456', '10'),
('800024', '22458', '11'),
('800024', '22463', '12'),
('800024', '22780', '13'),
('800024', '22784', '14'),
('800024', '22786', '15'),
('800024', '22794', '16'),
('800024', '22796', '17'),
('800024', '23381', '18'),
('800024', '23387', '19'),
('800024', '23389', '20'),
('800024', '23394', '21'),
('800024', '23399', '22'),
('800024', '23401', '23'),
('800024', '23406', '24'),
('800024', '23411', '25'),
('800024', '23413', '26'),
('800024', '23418', '27'),
('800024', '23423', '28'),
('800024', '23425', '29'),
('800024', '23430', '30'),
('800024', '23435', '31'),
('800024', '23437', '32'),
('800024', '23442', '33'),
('800024', '23447', '34'),
('800024', '23449', '35'),
('800024', '23454', '36'),
('800024', '23459', '37'),
('800024', '23461', '38'),
('800024', '23466', '39'),
('800024', '23471', '40'),
('800024', '23473', '41'),
('800024', '23478', '42'),
('800024', '24017', '43'),
('800024', '24756', '44'),
('800024', '24757', '45'),
('800024', '24758', '46'),
('800024', '24759', '47'),
('800024', '24760', '48'),
('800024', '24761', '49'),
('800024', '24762', '50'),
('800024', '24763', '51'),
('800024', '24764', '52'),
('800024', '24765', '53'),
('800024', '24766', '54'),
('800024', '25665', '55'),
('800024', '25666', '56'),
('800024', '25667', '57'),
('800024', '25668', '58'),
('800024', '25669', '59'),
('800024', '25670', '60'),
('800024', '25671', '61'),
('800024', '25672', '62'),
('800024', '25673', '63'),
('800024', '25674', '64'),
('800024', '25675', '65'),
('800024', '25676', '66'),
('800024', '25677', '67'),
('800024', '25678', '68'),
('800024', '25679', '69'),
('800024', '25680', '70'),
('800024', '25681', '71'),
('800024', '25682', '72'),
('800024', '25683', '73'),
('800024', '25684', '74'),
('800024', '25685', '75'),
('800024', '25686', '76'),
('800024', '25687', '77'),
('800024', '25688', '78'),
('800024', '25689', '79'),
('800025', '2985', '50'),
('800025', '2989', '51'),
('800025', '2990', '52'),
('800025', '25690', '1'),
('800025', '25691', '2'),
('800025', '25692', '3'),
('800025', '25693', '4'),
('800025', '25694', '5'),
('800025', '25697', '6'),
('800025', '25698', '7'),
('800025', '25699', '8'),
('800025', '25700', '9'),
('800025', '25701', '10'),
('800025', '25702', '11'),
('800025', '25703', '12'),
('800025', '25704', '13'),
('800025', '25705', '14'),
('800025', '25706', '15'),
('800025', '25707', '16'),
('800025', '25708', '17'),
('800025', '25709', '18'),
('800025', '25710', '19'),
('800025', '25711', '20'),
('800025', '25712', '21'),
('800025', '25713', '22'),
('800025', '25714', '23'),
('800025', '25715', '24'),
('800025', '29038', '25'),
('800025', '29039', '26'),
('800025', '29040', '27'),
('800025', '29041', '28'),
('800025', '29042', '29'),
('800025', '29043', '30'),
('800025', '29044', '31'),
('800025', '29045', '32'),
('800025', '29046', '33'),
('800025', '29047', '34'),
('800025', '29048', '35'),
('800025', '29049', '36'),
('800025', '29083', '37'),
('800025', '29103', '38'),
('800025', '29628', '39'),
('800025', '29629', '40'),
('800025', '29646', '41'),
('800025', '29659', '42'),
('800025', '29660', '43'),
('800025', '29662', '44'),
('800025', '29663', '45'),
('800025', '29664', '46'),
('800025', '29666', '47'),
('800025', '29689', '48'),
('800025', '29699', '49'),
('800025', '30198', '53'),
('800025', '30199', '54'),
('800025', '30298', '55'),
('800025', '30299', '56'),
('800025', '30300', '57'),
('800025', '30301', '58'),
('800025', '30302', '59'),
('800025', '30303', '60'),
('800025', '30304', '61'),
('800025', '30305', '62'),
('800025', '30306', '63'),
('800025', '30307', '64'),
('800025', '30308', '65'),
('800025', '30309', '66'),
('800025', '30310', '67'),
('800025', '30311', '68'),
('800025', '30312', '69'),
('800025', '30313', '70'),
('800025', '30314', '71'),
('800025', '30315', '72'),
('800025', '30316', '73'),
('800025', '30317', '74'),
('800025', '30318', '75'),
('800025', '30319', '76'),
('800025', '30320', '77'),
('800025', '30321', '78'),
('800025', '30322', '79'),
('800026', '30323', '1'),
('800026', '30324', '2'),
('800026', '30325', '3'),
('800026', '30326', '4'),
('800026', '30327', '5'),
('800026', '30328', '6'),
('800026', '30329', '7'),
('800026', '30330', '8'),
('800026', '30331', '9'),
('800026', '30332', '10'),
('800026', '30333', '11'),
('800026', '30334', '12'),
('800026', '30335', '13'),
('800026', '30336', '14'),
('800026', '30337', '15'),
('800026', '30338', '16'),
('800026', '30339', '17'),
('800026', '30340', '18'),
('800026', '30341', '19'),
('800026', '30342', '20'),
('800026', '30343', '21'),
('800026', '30344', '22'),
('800026', '30345', '23'),
('800026', '30346', '24'),
('800026', '30347', '25'),
('800026', '30348', '26'),
('800026', '30349', '27'),
('800026', '30350', '28'),
('800026', '30351', '29'),
('800026', '30352', '30'),
('800026', '30353', '31'),
('800026', '30354', '32'),
('800026', '30355', '33'),
('800026', '30360', '34'),
('800026', '30361', '35'),
('800026', '30362', '36'),
('800026', '30363', '37'),
('800026', '30364', '38'),
('800026', '30365', '39'),
('800026', '30366', '40'),
('800026', '30367', '41'),
('800026', '30368', '42'),
('800026', '30397', '43'),
('800026', '30424', '44'),
('800026', '30441', '45'),
('800026', '30465', '46'),
('800026', '30466', '47'),
('800026', '30467', '48'),
('800026', '30468', '49'),
('800026', '30469', '50'),
('800026', '30470', '51'),
('800026', '30550', '52'),
('800026', '30600', '53'),
('800026', '30845', '54'),
('800026', '30847', '55'),
('800026', '30849', '56'),
('800026', '30851', '57'),
('800026', '30907', '58'),
('800026', '30910', '59'),
('800026', '30912', '60'),
('800026', '30913', '61'),
('800026', '30914', '62'),
('800026', '30915', '63'),
('800026', '30916', '64'),
('800026', '30917', '65'),
('800026', '30918', '66'),
('800026', '30919', '67'),
('800026', '30920', '68'),
('800026', '30921', '69'),
('800026', '30923', '70'),
('800026', '30924', '71'),
('800026', '30925', '72'),
('800026', '30926', '73'),
('800026', '30927', '74'),
('800026', '30928', '75'),
('800026', '30929', '76'),
('800026', '30930', '77'),
('800026', '30931', '78'),
('800026', '30932', '79'),
('800027', '30933', '1'),
('800027', '30934', '2'),
('800027', '30935', '3'),
('800027', '30936', '4'),
('800027', '30937', '5'),
('800027', '30938', '6'),
('800027', '30939', '7'),
('800027', '30940', '8'),
('800027', '30941', '9'),
('800027', '30942', '10'),
('800027', '30943', '11'),
('800027', '30944', '12'),
('800027', '30945', '13'),
('800027', '30946', '14'),
('800027', '30947', '15'),
('800027', '30948', '16'),
('800027', '30949', '17'),
('800027', '30950', '18'),
('800027', '30951', '19'),
('800027', '30952', '20'),
('800027', '30953', '21'),
('800027', '30954', '22'),
('800027', '30955', '23'),
('800027', '30956', '24'),
('800027', '30957', '25'),
('800027', '30958', '26'),
('800027', '30959', '27'),
('800027', '30960', '28'),
('800027', '30999', '29'),
('800027', '31198', '30'),
('800027', '31199', '31'),
('800027', '31247', '32'),
('800027', '31248', '33'),
('800027', '31249', '34'),
('800027', '31296', '35'),
('800027', '31297', '36'),
('800027', '31298', '37'),
('800027', '31299', '38'),
('800027', '31456', '39'),
('800027', '31457', '40'),
('800027', '31458', '41'),
('800027', '31459', '42'),
('800027', '31474', '43'),
('800027', '31497', '44'),
('800027', '31498', '45'),
('800027', '31499', '46'),
('800027', '31512', '47'),
('800027', '31513', '48'),
('800027', '31514', '49'),
('800027', '31532', '50'),
('800027', '31533', '51'),
('800027', '31534', '52'),
('800027', '31535', '53'),
('800027', '31536', '54'),
('800027', '31537', '55'),
('800027', '31538', '56'),
('800027', '31539', '57'),
('800027', '31540', '58'),
('800027', '31541', '59'),
('800027', '31542', '60'),
('800027', '31543', '61'),
('800027', '31544', '62'),
('800027', '31545', '63'),
('800027', '31546', '64'),
('800027', '31547', '65'),
('800027', '31548', '66'),
('800027', '32247', '67'),
('800027', '32299', '68'),
('800027', '32589', '69'),
('800027', '32590', '70'),
('800027', '33687', '71'),
('800027', '33688', '72'),
('800027', '33689', '73'),
('800027', '33690', '74'),
('800027', '33691', '75'),
('800027', '33692', '76'),
('800027', '33693', '77'),
('800027', '33694', '78'),
('800027', '33695', '79'),
('800028', '33696', '1'),
('800028', '33697', '2'),
('800028', '33698', '3'),
('800028', '33699', '4'),
('800028', '33700', '5'),
('800028', '33701', '6'),
('800028', '33702', '7'),
('800028', '33703', '8'),
('800028', '33704', '9'),
('800028', '33705', '10'),
('800028', '33706', '11'),
('800028', '33707', '12'),
('800028', '33708', '13'),
('800028', '33709', '14'),
('800028', '33710', '15'),
('800028', '33711', '16'),
('800028', '33712', '17'),
('800028', '33713', '18'),
('800028', '33714', '19'),
('800028', '33715', '20'),
('800028', '33716', '21'),
('800028', '33717', '22'),
('800028', '33718', '23'),
('800028', '33719', '24'),
('800028', '33720', '25'),
('800028', '33721', '26'),
('800028', '33723', '27'),
('800028', '33725', '28'),
('800028', '33726', '29'),
('800028', '33727', '30'),
('800028', '33728', '31'),
('800028', '33729', '32'),
('800028', '33730', '33'),
('800028', '33731', '34'),
('800028', '33732', '35'),
('800028', '33733', '36'),
('800028', '33734', '37'),
('800028', '33735', '38'),
('800028', '33736', '39'),
('800028', '33737', '40'),
('800028', '33738', '41'),
('800028', '33739', '42'),
('800028', '33740', '43'),
('800028', '33741', '44'),
('800028', '33742', '45'),
('800028', '33743', '46'),
('800028', '33744', '47'),
('800028', '33745', '48'),
('800028', '33746', '49'),
('800028', '33747', '50'),
('800028', '33748', '51'),
('800028', '33749', '52'),
('800028', '33750', '53'),
('800028', '33751', '54'),
('800028', '33752', '55'),
('800028', '33753', '56'),
('800028', '33754', '57'),
('800028', '33755', '58'),
('800028', '33756', '59'),
('800028', '33757', '60'),
('800028', '33758', '61'),
('800028', '33759', '62'),
('800028', '33761', '63'),
('800028', '37604', '64'),
('800028', '37607', '65'),
('800028', '37610', '66'),
('800028', '37613', '67'),
('800028', '37616', '68'),
('800028', '37693', '69'),
('800028', '37696', '70'),
('800028', '37699', '71'),
('800028', '37702', '72'),
('800028', '37705', '73'),
('800028', '37708', '74'),
('800028', '37709', '75'),
('800028', '37710', '76'),
('800028', '37711', '77'),
('800028', '37712', '78'),
('800028', '37713', '79'),
('800029', '37714', '1'),
('800029', '37715', '2'),
('800029', '37716', '3'),
('800029', '37717', '4'),
('800029', '37718', '5'),
('800029', '37719', '6'),
('800029', '37720', '7'),
('800029', '37721', '8'),
('800029', '37722', '9'),
('800029', '37723', '10'),
('800029', '37726', '11'),
('800029', '37729', '12'),
('800029', '37732', '13'),
('800029', '37735', '14'),
('800029', '37738', '15'),
('800029', '37739', '16'),
('800029', '37740', '17'),
('800029', '37741', '18'),
('800029', '37742', '19'),
('800029', '37743', '20'),
('800029', '37744', '21'),
('800029', '37745', '22'),
('800029', '37746', '23'),
('800029', '37747', '24'),
('800029', '37748', '25'),
('800029', '37749', '26'),
('800029', '37750', '27'),
('800029', '37751', '28'),
('800029', '37752', '29'),
('800029', '37783', '30'),
('800029', '37784', '31'),
('800029', '37785', '32'),
('800029', '37786', '33'),
('800029', '37787', '34'),
('800029', '37788', '35'),
('800029', '37789', '36'),
('800029', '37790', '37'),
('800029', '37791', '38'),
('800029', '37792', '39'),
('800029', '37793', '40'),
('800029', '37794', '41'),
('800029', '37795', '42'),
('800029', '37796', '43'),
('800029', '37797', '44'),
('800029', '38967', '45'),
('800029', '38968', '46'),
('800029', '38969', '47'),
('800029', '38970', '48'),
('800029', '38971', '49'),
('800029', '38972', '50'),
('800029', '38973', '51'),
('800029', '38974', '52'),
('800029', '38975', '53'),
('800029', '38976', '54'),
('800029', '38982', '55'),
('800029', '38983', '56'),
('800029', '38984', '57'),
('800029', '38985', '58'),
('800029', '38986', '59'),
('800029', '39724', '60'),
('800029', '39725', '61'),
('800029', '39726', '62'),
('800029', '39727', '63'),
('800029', '39728', '64'),
('800029', '39729', '65'),
('800029', '39730', '66'),
('800029', '39731', '67'),
('800029', '39732', '68'),
('800029', '39733', '69'),
('800029', '39735', '70'),
('800029', '39736', '71'),
('800029', '39737', '72'),
('800029', '39738', '73'),
('800029', '39739', '74'),
('800029', '39740', '75'),
('800029', '39741', '76'),
('800029', '39742', '77'),
('800029', '39743', '78'),
('800029', '39744', '79'),
('800030', '4037', '5'),
('800030', '4101', '6'),
('800030', '4102', '7'),
('800030', '4103', '8'),
('800030', '4104', '9'),
('800030', '4105', '10'),
('800030', '4106', '11'),
('800030', '4107', '12'),
('800030', '4108', '13'),
('800030', '4109', '14'),
('800030', '4110', '15'),
('800030', '4111', '16'),
('800030', '4112', '17'),
('800030', '4120', '18'),
('800030', '4121', '19'),
('800030', '4122', '20'),
('800030', '4123', '21'),
('800030', '4124', '22'),
('800030', '4125', '23'),
('800030', '4126', '24'),
('800030', '4127', '25'),
('800030', '4128', '26'),
('800030', '4129', '27'),
('800030', '4130', '28'),
('800030', '4131', '29'),
('800030', '4146', '30'),
('800030', '4147', '31'),
('800030', '4148', '32'),
('800030', '4413', '33'),
('800030', '4419', '34'),
('800030', '4421', '35'),
('800030', '4426', '36'),
('800030', '4428', '37'),
('800030', '4431', '38'),
('800030', '4432', '39'),
('800030', '4433', '40'),
('800030', '4434', '41'),
('800030', '4435', '42'),
('800030', '4437', '43'),
('800030', '4438', '44'),
('800030', '4451', '45'),
('800030', '4453', '46'),
('800030', '4458', '47'),
('800030', '4500', '48'),
('800030', '4503', '49'),
('800030', '4812', '61'),
('800030', '4813', '62'),
('800030', '4814', '63'),
('800030', '4815', '64'),
('800030', '4816', '65'),
('800030', '4817', '66'),
('800030', '39745', '1'),
('800030', '39746', '2'),
('800030', '39747', '3'),
('800030', '39748', '4'),
('800030', '46306', '50'),
('800030', '46307', '51'),
('800030', '46308', '52'),
('800030', '46309', '53'),
('800030', '46350', '54'),
('800030', '46351', '55'),
('800030', '46352', '56'),
('800030', '46353', '57'),
('800030', '46402', '58'),
('800030', '46403', '59'),
('800030', '46405', '60'),
('800030', '58712', '67'),
('800030', '58798', '68'),
('800030', '58801', '69'),
('800030', '58804', '70'),
('800030', '58805', '71'),
('800030', '58806', '72'),
('800030', '58807', '73'),
('800030', '58808', '74'),
('800030', '58809', '75'),
('800030', '58810', '76'),
('800030', '58817', '77'),
('800030', '58818', '78'),
('800030', '58819', '79'),
('800031', '58820', '1'),
('800031', '58821', '2'),
('800031', '58822', '3'),
('800031', '58823', '4'),
('800031', '58824', '5'),
('800031', '58825', '6'),
('800031', '58832', '7'),
('800031', '58833', '8'),
('800031', '58835', '9'),
('800031', '58836', '10'),
('800031', '58837', '11'),
('800031', '58838', '12'),
('800031', '58839', '13'),
('800031', '58840', '14'),
('800031', '58856', '15'),
('800031', '58859', '16'),
('800031', '58862', '17'),
('800031', '58863', '18'),
('800031', '58864', '19'),
('800031', '58865', '20'),
('800031', '58866', '21'),
('800031', '58867', '22'),
('800031', '58868', '23'),
('800031', '58875', '24'),
('800031', '58876', '25'),
('800031', '58877', '26'),
('800031', '58878', '27'),
('800031', '58879', '28'),
('800031', '58880', '29'),
('800031', '58881', '30'),
('800031', '58882', '31'),
('800031', '58883', '32'),
('800031', '58890', '33'),
('800031', '58891', '34'),
('800031', '58892', '35'),
('800031', '58893', '36'),
('800031', '58894', '37'),
('800031', '58895', '38'),
('800031', '58896', '39'),
('800031', '58897', '40'),
('800031', '58898', '41'),
('800031', '58914', '42'),
('800031', '58917', '43'),
('800031', '58920', '44'),
('800031', '58921', '45'),
('800031', '58922', '46'),
('800031', '58923', '47'),
('800031', '58924', '48'),
('800031', '58926', '49'),
('800031', '58933', '50'),
('800031', '58934', '51'),
('800031', '58935', '52'),
('800031', '58936', '53'),
('800031', '58937', '54'),
('800031', '58938', '55'),
('800031', '58939', '56'),
('800031', '58941', '57'),
('800031', '58948', '58'),
('800031', '58949', '59'),
('800031', '58950', '60'),
('800031', '58951', '61'),
('800031', '58952', '62'),
('800031', '58953', '63'),
('800031', '58954', '64'),
('800031', '58955', '65'),
('800031', '58956', '66'),
('800031', '58972', '67'),
('800031', '58975', '68'),
('800031', '58978', '69'),
('800031', '58981', '70'),
('800031', '58993', '71'),
('800031', '58994', '72'),
('800031', '58996', '73'),
('800031', '58997', '74'),
('800031', '58998', '75'),
('800031', '58999', '76'),
('800031', '62501', '77'),
('800031', '62502', '78'),
('800031', '62503', '79'),
('800032', '6328', '24'),
('800032', '62504', '1'),
('800032', '62511', '2'),
('800032', '62512', '3'),
('800032', '62513', '4'),
('800032', '62514', '5'),
('800032', '63177', '6'),
('800032', '63178', '7'),
('800032', '63179', '8'),
('800032', '63180', '9'),
('800032', '63181', '10'),
('800032', '63182', '11'),
('800032', '63183', '12'),
('800032', '63184', '13'),
('800032', '63185', '14'),
('800032', '63201', '15'),
('800032', '63204', '16'),
('800032', '63207', '17'),
('800032', '63208', '18'),
('800032', '63209', '19'),
('800032', '63210', '20'),
('800032', '63211', '21'),
('800032', '63212', '22'),
('800032', '63213', '23'),
('800032', '63318', '25'),
('800032', '63319', '26'),
('800032', '63320', '27'),
('800032', '63321', '28'),
('800032', '63322', '29'),
('800032', '63323', '30'),
('800032', '63324', '31'),
('800032', '63325', '32'),
('800032', '63326', '33'),
('800032', '63333', '34'),
('800032', '63334', '35'),
('800032', '63335', '36'),
('800032', '63336', '37'),
('800032', '63337', '38'),
('800032', '63338', '39'),
('800032', '63339', '40'),
('800032', '63340', '41'),
('800032', '63341', '42'),
('800032', '63357', '43'),
('800032', '63360', '44'),
('800032', '63363', '45'),
('800032', '63364', '46'),
('800032', '63365', '47'),
('800032', '63366', '48'),
('800032', '63367', '49'),
('800032', '63369', '50'),
('800032', '63376', '51'),
('800032', '63379', '52'),
('800032', '63380', '53'),
('800032', '63381', '54'),
('800032', '63383', '55'),
('800032', '63384', '56'),
('800032', '63391', '57'),
('800032', '63392', '58'),
('800032', '63393', '59'),
('800032', '63394', '60'),
('800032', '63395', '61'),
('800032', '63396', '62'),
('800032', '63397', '63'),
('800032', '63398', '64'),
('800032', '63399', '65'),
('800032', '63415', '66'),
('800032', '63418', '67'),
('800032', '63421', '68'),
('800032', '63422', '69'),
('800032', '63423', '70'),
('800032', '63424', '71'),
('800032', '63425', '72'),
('800032', '63427', '73'),
('800032', '63434', '74'),
('800032', '63435', '75'),
('800032', '63436', '76'),
('800032', '63437', '77'),
('800032', '63438', '78'),
('800032', '63439', '79'),
('800033', '63440', '1'),
('800033', '63442', '2'),
('800033', '63449', '3'),
('800033', '63450', '4'),
('800033', '63451', '5'),
('800033', '63452', '6'),
('800033', '63453', '7'),
('800033', '63454', '8'),
('800033', '63455', '9'),
('800033', '63456', '10'),
('800033', '63457', '11'),
('800033', '63476', '12'),
('800033', '63479', '13'),
('800033', '63481', '14'),
('800033', '63482', '15'),
('800033', '63484', '16'),
('800033', '63485', '17'),
('800033', '63492', '18'),
('800033', '63493', '19'),
('800033', '63494', '20'),
('800033', '63495', '21'),
('800033', '63496', '22'),
('800033', '63497', '23'),
('800033', '63498', '24'),
('800033', '63500', '25'),
('800033', '63507', '26'),
('800033', '63508', '27'),
('800033', '63509', '28'),
('800033', '63510', '29'),
('800033', '63511', '30'),
('800033', '63512', '31'),
('800033', '63513', '32'),
('800033', '63514', '33'),
('800033', '63515', '34'),
('800033', '63531', '35'),
('800033', '63534', '36'),
('800033', '63537', '37'),
('800033', '63538', '38'),
('800033', '63539', '39'),
('800033', '63540', '40'),
('800033', '63541', '41'),
('800033', '63542', '42'),
('800033', '63543', '43'),
('800033', '63550', '44'),
('800033', '63551', '45'),
('800033', '63552', '46'),
('800033', '63553', '47'),
('800033', '63554', '48'),
('800033', '63555', '49'),
('800033', '63556', '50'),
('800033', '63557', '51'),
('800033', '63558', '52'),
('800033', '63565', '53'),
('800033', '63566', '54'),
('800033', '63567', '55'),
('800033', '63568', '56'),
('800033', '63569', '57'),
('800033', '63570', '58'),
('800033', '63571', '59'),
('800033', '63572', '60'),
('800033', '63573', '61'),
('800033', '63589', '62'),
('800033', '63592', '63'),
('800033', '63595', '64'),
('800033', '63596', '65'),
('800033', '63597', '66'),
('800033', '63598', '67'),
('800033', '63599', '68'),
('800033', '63600', '69'),
('800033', '63601', '70'),
('800033', '63608', '71'),
('800033', '63609', '72'),
('800033', '63610', '73'),
('800033', '63611', '74'),
('800033', '63612', '75'),
('800033', '63613', '76'),
('800033', '63614', '77'),
('800033', '63615', '78'),
('800033', '63616', '79'),
('800034', '63623', '1'),
('800034', '63624', '2'),
('800034', '63625', '3'),
('800034', '63626', '4'),
('800034', '63627', '5'),
('800034', '63628', '6'),
('800034', '63629', '7'),
('800034', '63630', '8'),
('800034', '63631', '9'),
('800034', '63647', '10'),
('800034', '63650', '11'),
('800034', '63653', '12'),
('800034', '63654', '13'),
('800034', '63655', '14'),
('800034', '63656', '15'),
('800034', '63657', '16'),
('800034', '63658', '17'),
('800034', '63659', '18'),
('800034', '63666', '19'),
('800034', '63667', '20'),
('800034', '63668', '21'),
('800034', '63669', '22'),
('800034', '63670', '23'),
('800034', '63671', '24'),
('800034', '63672', '25'),
('800034', '63673', '26'),
('800034', '63674', '27'),
('800034', '63681', '28'),
('800034', '63682', '29'),
('800034', '63683', '30'),
('800034', '63684', '31'),
('800034', '63685', '32'),
('800034', '63686', '33'),
('800034', '63687', '34'),
('800034', '63688', '35'),
('800034', '63689', '36'),
('800034', '63705', '37'),
('800034', '63708', '38'),
('800034', '63711', '39'),
('800034', '63712', '40'),
('800034', '63713', '41'),
('800034', '63714', '42'),
('800034', '63715', '43'),
('800034', '63716', '44'),
('800034', '63717', '45'),
('800034', '63724', '46'),
('800034', '63725', '47'),
('800034', '63726', '48'),
('800034', '63727', '49'),
('800034', '63728', '50'),
('800034', '63729', '51'),
('800034', '63730', '52'),
('800034', '63731', '53'),
('800034', '63732', '54'),
('800034', '63739', '55'),
('800034', '63740', '56'),
('800034', '63741', '57'),
('800034', '63742', '58'),
('800034', '63743', '59'),
('800034', '63744', '60'),
('800034', '63745', '61'),
('800034', '63746', '62'),
('800034', '63747', '63'),
('800034', '65003', '64'),
('800034', '65007', '65'),
('800034', '65011', '66'),
('800034', '65015', '67'),
('800034', '65019', '68'),
('800034', '65023', '69'),
('800034', '65026', '70'),
('800034', '65027', '71'),
('800034', '65030', '72'),
('800034', '65031', '73'),
('800034', '65034', '74'),
('800034', '65035', '75'),
('800034', '65038', '76'),
('800034', '65039', '77'),
('800034', '65042', '78'),
('800034', '65043', '79'),
('800035', '65046', '1'),
('800035', '65047', '2'),
('800035', '65050', '3'),
('800035', '65051', '4'),
('800035', '65054', '5'),
('800035', '65055', '6'),
('800035', '65058', '7'),
('800035', '65059', '8'),
('800035', '65062', '9'),
('800035', '65063', '10'),
('800035', '65066', '11'),
('800035', '65067', '12'),
('800035', '65070', '13'),
('800035', '65071', '14'),
('800035', '65086', '15'),
('800035', '65087', '16'),
('800035', '65088', '17'),
('800035', '65089', '18'),
('800035', '65090', '19'),
('800035', '65091', '20'),
('800035', '65092', '21'),
('800035', '65093', '22'),
('800035', '65094', '23'),
('800035', '65095', '24'),
('800035', '65096', '25'),
('800035', '65097', '26'),
('800035', '65098', '27'),
('800035', '65099', '28'),
('800035', '65100', '29'),
('800035', '65101', '30'),
('800035', '65102', '31'),
('800035', '65103', '32'),
('800035', '65104', '33'),
('800035', '65105', '34'),
('800035', '65106', '35'),
('800035', '65107', '36'),
('800035', '65108', '37'),
('800035', '65109', '38'),
('800035', '65110', '39'),
('800035', '65111', '40'),
('800035', '65112', '41'),
('800035', '65113', '42'),
('800035', '65114', '43'),
('800035', '65117', '44'),
('800035', '79562', '45'),
('800035', '40681', '46'),
('800035', '65118', '47'),
('800035', '65120', '48'),
('800035', '65121', '49'),
('800035', '65122', '50'),
('800035', '86119', '51'),
('800035', '86127', '52'),
('800035', '86178', '53'),
('800035', '86187', '54'),
('800035', '86247', '55'),
('800035', '86254', '56'),
('800035', '86264', '57'),
('800035', '86310', '58'),
('800035', '86321', '59'),
('800035', '86330', '60'),
('800035', '86502', '61'),
('800035', '86560', '62'),
('800035', '86590', '63'),
('800035', '86945', '64'),
('800035', '90055', '65'),
('800035', '90110', '66'),
('800035', '90137', '67'),
('800035', '90196', '68'),
('800035', '90233', '69'),
('800035', '90252', '70'),
('800035', '95277', '71'),
('800035', '95278', '72'),
('800035', '95279', '73'),
('800035', '95280', '74'),
('800035', '95281', '75'),
('800035', '95282', '76'),
('800035', '95283', '77'),
('800035', '95284', '78'),
('800035', '95285', '79'),
('800035', '95286', '80'),
('800035', '95287', '81'),
('800036', '95288', '1'),
('800036', '95289', '2'),
('800036', '95290', '3'),
('800036', '95291', '4'),
('800036', '95292', '5'),
('800036', '95293', '6'),
('800036', '95294', '7'),
('800036', '95295', '8'),
('800036', '95296', '9'),
('800036', '95297', '10'),
('800036', '95298', '11'),
('800036', '95299', '12'),
('800036', '95300', '13'),
('800036', '95301', '14'),
('800036', '95302', '15'),
('800036', '95303', '16'),
('800036', '95304', '17'),
('800036', '95305', '18'),
('800036', '95306', '19'),
('800036', '95307', '20'),
('800036', '95308', '21'),
('800036', '95309', '22'),
('800036', '95310', '23'),
('800036', '95311', '24'),
('800036', '95312', '25'),
('800036', '95313', '26'),
('800036', '95314', '27'),
('800036', '95315', '28'),
('800036', '95316', '29'),
('800036', '95317', '30'),
('800036', '95318', '31'),
('800036', '95319', '32'),
('800036', '95320', '33'),
('800036', '95321', '34'),
('800036', '95322', '35'),
('800036', '95323', '36'),
('800036', '95324', '37'),
('800036', '95325', '38'),
('800036', '95326', '39'),
('800036', '95327', '40'),
('800036', '95328', '41'),
('800036', '95329', '42'),
('800036', '95330', '43'),
('800036', '95331', '44'),
('800036', '95332', '45'),
('800036', '95333', '46'),
('800036', '95334', '47'),
('800036', '95335', '48'),
('800036', '95336', '49'),
('800036', '95337', '50'),
('800036', '95338', '51'),
('800036', '95339', '52'),
('800036', '95340', '53'),
('800036', '95341', '54'),
('800036', '95342', '55'),
('800036', '95343', '56'),
('800036', '95344', '57'),
('800036', '95345', '58'),
('800036', '95346', '59'),
('800036', '95347', '60'),
('800036', '95348', '61'),
('800036', '95349', '62'),
('800036', '95350', '63'),
('800036', '95351', '64'),
('800036', '95352', '65'),
('800036', '95353', '66'),
('800036', '95354', '67'),
('800036', '95355', '68'),
('800036', '95356', '69'),
('800036', '95357', '70'),
('800036', '95358', '71'),
('800036', '95359', '72'),
('800036', '95360', '73'),
('800036', '95361', '74'),
('800036', '95362', '75'),
('800036', '95363', '76'),
('800036', '95364', '77'),
('800036', '95365', '78'),
('800036', '95366', '79'),
('800037', '95367', '1'),
('800037', '95368', '2'),
('800037', '95369', '3'),
('800037', '95370', '4'),
('800037', '95371', '5'),
('800037', '95372', '6'),
('800037', '95373', '7'),
('800037', '95374', '8'),
('800037', '95375', '9'),
('800037', '95376', '10'),
('800037', '95377', '11'),
('800037', '95378', '12'),
('800037', '95379', '13'),
('800037', '95380', '14'),
('800037', '95381', '15'),
('800037', '95382', '16'),
('800037', '95383', '17'),
('800037', '95384', '18'),
('800037', '95385', '19'),
('800037', '95386', '20'),
('800037', '95387', '21'),
('800037', '95388', '22'),
('800037', '95389', '23'),
('800037', '95390', '24'),
('800037', '95391', '25'),
('800037', '95392', '26'),
('800037', '95393', '27'),
('800037', '95394', '28'),
('800037', '95395', '29'),
('800037', '95396', '30'),
('800037', '95397', '31'),
('800037', '95398', '32'),
('800037', '95399', '33'),
('800037', '95400', '34'),
('800037', '95401', '35'),
('800037', '95402', '36'),
('800037', '95403', '37'),
('800037', '95404', '38'),
('800037', '95405', '39'),
('800037', '95406', '40'),
('800037', '95407', '41'),
('800037', '95408', '42'),
('800037', '95409', '43'),
('800037', '95410', '44'),
('800037', '95411', '45'),
('800037', '95412', '46'),
('800037', '95413', '47'),
('800037', '95414', '48'),
('800037', '95415', '49'),
('800037', '95416', '50'),
('800037', '95417', '51'),
('800037', '95418', '52'),
('800037', '95419', '53'),
('800037', '95420', '54'),
('800037', '95421', '55'),
('800037', '95422', '56'),
('800037', '95423', '57'),
('800037', '95424', '58'),
('800037', '95425', '59'),
('800037', '95426', '60'),
('800037', '95427', '61'),
('800037', '95428', '62'),
('800037', '95429', '63'),
('800037', '95430', '64'),
('800037', '95431', '65'),
('800037', '95432', '66'),
('800037', '95433', '67'),
('800037', '95434', '68'),
('800037', '95435', '69'),
('800037', '95436', '70'),
('800037', '95437', '71'),
('800037', '95438', '72'),
('800037', '95439', '73'),
('800037', '95440', '74'),
('800037', '95441', '75'),
('800037', '95442', '76'),
('800037', '95443', '77'),
('800037', '95444', '78'),
('800037', '95445', '79'),
('800038', '95446', '1'),
('800038', '95447', '2'),
('800038', '95448', '3'),
('800038', '95449', '4'),
('800038', '95450', '5'),
('800038', '95451', '6'),
('800038', '95452', '7'),
('800038', '95453', '8'),
('800038', '95454', '9'),
('800038', '95455', '10'),
('800038', '95456', '11'),
('800038', '95457', '12'),
('800038', '95458', '13'),
('800038', '95459', '14'),
('800038', '95460', '15'),
('800038', '95461', '16'),
('800038', '95462', '17'),
('800038', '95463', '18'),
('800038', '95464', '19'),
('800038', '95465', '20'),
('800038', '95466', '21'),
('800038', '95467', '22'),
('800038', '95468', '23'),
('800038', '95469', '24'),
('800038', '95470', '25'),
('800038', '95471', '26'),
('800038', '95472', '27'),
('800038', '95473', '28'),
('800038', '95474', '29'),
('800038', '95475', '30'),
('800038', '95476', '31'),
('800038', '95477', '32'),
('800038', '95478', '33'),
('800038', '95479', '34'),
('800038', '95480', '35'),
('800038', '95481', '36'),
('800038', '95482', '37'),
('800038', '95483', '38'),
('800038', '95484', '39'),
('800038', '95485', '40'),
('800038', '95486', '41'),
('800038', '95487', '42'),
('800038', '95488', '43'),
('800038', '95489', '44'),
('800038', '95490', '45'),
('800038', '95491', '46'),
('800038', '95492', '47'),
('800038', '95493', '48'),
('800038', '95494', '49'),
('800038', '95495', '50'),
('800038', '95496', '51'),
('800038', '95497', '52'),
('800038', '95498', '53'),
('800038', '95499', '54'),
('800038', '95500', '55'),
('800038', '95501', '56'),
('800038', '95502', '57'),
('800038', '95503', '58'),
('800038', '95504', '59'),
('800038', '95505', '60'),
('800038', '95506', '61'),
('800038', '95507', '62'),
('800038', '95508', '63'),
('800038', '95509', '64'),
('800038', '95510', '65'),
('800038', '95511', '66'),
('800038', '95512', '67'),
('800038', '95513', '68'),
('800038', '95514', '69'),
('800038', '95515', '70'),
('800038', '95516', '71'),
('800038', '95517', '72'),
('800038', '95518', '73'),
('800038', '95519', '74'),
('800038', '95520', '75'),
('800038', '95521', '76'),
('800038', '95522', '77'),
('800038', '95523', '78'),
('800038', '95524', '79'),
('800039', '95525', '1'),
('800039', '95526', '2'),
('800039', '95527', '3'),
('800039', '95528', '4'),
('800039', '95529', '5'),
('800039', '95530', '6'),
('800039', '95531', '7'),
('800039', '95532', '8'),
('800039', '95533', '9'),
('800039', '95534', '10'),
('800039', '95535', '11'),
('800039', '95536', '12'),
('800039', '95537', '13'),
('800039', '95538', '14'),
('800039', '95539', '15'),
('800039', '95540', '16'),
('800039', '95541', '17'),
('800039', '95542', '18'),
('800039', '95543', '19'),
('800039', '95544', '20'),
('800039', '95545', '21'),
('800039', '95546', '22'),
('800039', '95547', '23'),
('800039', '95548', '24'),
('800039', '95549', '25'),
('800039', '95550', '26'),
('800039', '95551', '27'),
('800039', '95552', '28'),
('800039', '95553', '29'),
('800039', '95554', '30'),
('800039', '95555', '31'),
('800039', '95556', '32'),
('800039', '95557', '33'),
('800039', '95558', '34'),
('800039', '95559', '35'),
('800039', '95560', '36'),
('800039', '95561', '37'),
('800039', '95562', '38'),
('800039', '95563', '39'),
('800039', '95564', '40'),
('800039', '95565', '41'),
('800039', '95566', '42'),
('800039', '95567', '43'),
('800039', '95568', '44'),
('800039', '95569', '45'),
('800039', '95570', '46'),
('800039', '95571', '47'),
('800039', '95572', '48'),
('800039', '95573', '49'),
('800039', '95574', '50'),
('800039', '95575', '51'),
('800039', '95576', '52'),
('800039', '95577', '53'),
('800039', '95578', '54'),
('800039', '95579', '55'),
('800039', '95580', '56'),
('800039', '95581', '57'),
('800039', '95582', '58'),
('800039', '95583', '59'),
('800039', '95584', '60'),
('800039', '95585', '61'),
('800039', '95586', '62'),
('800039', '95587', '63'),
('800039', '95588', '64'),
('800039', '95589', '65'),
('800039', '95590', '66'),
('800039', '95591', '67'),
('800039', '95592', '68'),
('800039', '95593', '69'),
('800039', '95594', '70'),
('800039', '95595', '71'),
('800039', '95596', '72'),
('800039', '95597', '73'),
('800039', '95598', '74'),
('800039', '95599', '75'),
('800039', '95600', '76'),
('800039', '95601', '77'),
('800039', '95602', '78'),
('800039', '95603', '79'),
('800040', '95604', '1'),
('800040', '95605', '2'),
('800040', '95606', '3'),
('800040', '95607', '4'),
('800040', '95608', '5'),
('800040', '95609', '6'),
('800040', '95610', '7'),
('800040', '95611', '8'),
('800040', '95612', '9'),
('800040', '95613', '10'),
('800040', '95614', '11'),
('800040', '95615', '12'),
('800040', '95616', '13'),
('800040', '95617', '14'),
('800040', '95618', '15'),
('800040', '95619', '16'),
('800040', '95620', '17'),
('800040', '95621', '18'),
('800040', '95622', '19'),
('800040', '95623', '20'),
('800040', '95624', '21'),
('800040', '95625', '22'),
('800040', '95626', '23'),
('800040', '95627', '24'),
('800040', '95628', '25'),
('800040', '95629', '26'),
('800040', '95630', '27'),
('800040', '95631', '28'),
('800040', '95632', '29'),
('800040', '95633', '30'),
('800040', '95634', '31'),
('800040', '95635', '32'),
('800040', '95636', '33'),
('800040', '95637', '34'),
('800040', '95638', '35'),
('800040', '95639', '36'),
('800040', '95640', '37'),
('800040', '95641', '38'),
('800040', '95642', '39'),
('800040', '95643', '40'),
('800040', '95644', '41'),
('800040', '95645', '42'),
('800040', '95646', '43'),
('800040', '95647', '44'),
('800040', '95648', '45'),
('800040', '95649', '46'),
('800040', '95650', '47'),
('800040', '95651', '48'),
('800040', '95652', '49'),
('800040', '95653', '50'),
('800040', '95654', '51'),
('800040', '96511', '52'),
('800040', '96512', '53'),
('800040', '96514', '54'),
('800040', '96515', '55'),
('800040', '96517', '56'),
('800040', '96518', '57'),
('800040', '96519', '58'),
('800040', '96520', '59'),
('800040', '96521', '60'),
('800040', '96522', '61'),
('800040', '96523', '62'),
('800040', '96524', '63'),
('800040', '96525', '64'),
('800040', '96526', '65'),
('800040', '96527', '66'),
('800040', '96528', '67'),
('800040', '96529', '68'),
('800040', '96530', '69'),
('800040', '96531', '70'),
('800040', '96532', '71'),
('800040', '96533', '72'),
('800040', '96534', '73'),
('800040', '96940', '74'),
('800040', '96941', '75'),
('800040', '96942', '76'),
('800040', '96943', '77'),
('800040', '97962', '78'),
('800040', '97963', '79'),
('800041', '97964', '1'),
('800041', '97965', '2'),
('800041', '97966', '3'),
('800041', '97967', '4'),
('800041', '97968', '5'),
('800041', '97969', '6'),
('800041', '97970', '7'),
('800041', '97971', '8'),
('800041', '97972', '9'),
('800041', '97973', '10'),
('800041', '97974', '11'),
('800041', '97975', '12'),
('800041', '97976', '13'),
('800041', '97977', '14'),
('800041', '97978', '15'),
('800041', '97979', '16'),
('800041', '97980', '17'),
('800041', '97981', '18'),
('800041', '97982', '19'),
('800041', '97983', '20'),
('800041', '97984', '21'),
('800041', '97985', '22'),
('800041', '97986', '23'),
('800041', '97987', '24'),
('800041', '97988', '25'),
('800041', '97989', '26'),
('800041', '97990', '27'),
('800041', '97991', '28'),
('800041', '97992', '29'),
('800041', '97993', '30'),
('800041', '97994', '31'),
('800041', '97995', '32'),
('800041', '97996', '33'),
('800041', '97997', '34'),
('800041', '97998', '35'),
('800041', '97999', '36'),
('800041', '98000', '37'),
('800041', '98001', '38'),
('800041', '98002', '39'),
('800041', '98003', '40'),
('800041', '98004', '41'),
('800041', '98005', '42'),
('800041', '98006', '43'),
('800041', '98007', '44'),
('800041', '98008', '45'),
('800041', '98009', '46'),
('800041', '98010', '47'),
('800041', '98011', '48'),
('800041', '98012', '49'),
('800041', '98013', '50'),
('800041', '98014', '51'),
('800041', '98015', '52'),
('800041', '98016', '53'),
('800041', '98017', '54'),
('800041', '98018', '55'),
('800041', '98019', '56'),
('800041', '98020', '57'),
('800041', '98021', '58'),
('800041', '98022', '59'),
('800041', '98023', '60'),
('800041', '98024', '61'),
('800041', '98025', '62'),
('800041', '98026', '63'),
('800041', '98027', '64'),
('800041', '98028', '65'),
('800041', '98029', '66'),
('800041', '98030', '67'),
('800041', '98031', '68'),
('800041', '98032', '69'),
('800041', '98033', '70'),
('800041', '98034', '71'),
('800041', '98035', '72'),
('800041', '98036', '73'),
('800041', '98037', '74'),
('800041', '98038', '75'),
('800041', '98039', '76'),
('800041', '98040', '77'),
('800041', '98041', '78'),
('800041', '98042', '79'),
('800042', '32557', '1'),
('800042', '98043', '2'),
('800042', '98044', '3'),
('800042', '98045', '4'),
('800042', '98046', '5'),
('800042', '98047', '6'),
('800042', '98048', '7'),
('800042', '98049', '8'),
('800042', '98050', '9'),
('800042', '98051', '10'),
('800042', '98052', '11'),
('800042', '98053', '12'),
('800042', '98054', '13'),
('800042', '98055', '14'),
('800042', '98056', '15'),
('800042', '98057', '16'),
('800042', '98058', '17'),
('800042', '98059', '18'),
('800042', '98060', '19'),
('800042', '98061', '20'),
('800042', '98062', '21'),
('800042', '98063', '22'),
('800042', '98064', '23'),
('800042', '98065', '24'),
('800042', '98066', '25'),
('800042', '98067', '26'),
('800042', '98068', '27'),
('800042', '98069', '28'),
('800042', '98070', '29'),
('800042', '98071', '30'),
('800042', '98072', '31'),
('800042', '98073', '32'),
('800042', '98074', '33'),
('800042', '98075', '34'),
('800042', '98076', '35'),
('800042', '98077', '36'),
('800042', '98078', '37'),
('800042', '98079', '38'),
('800042', '98080', '39'),
('800042', '98081', '40'),
('800042', '98082', '41'),
('800042', '98083', '42'),
('800042', '98084', '43'),
('800042', '98085', '44'),
('800042', '98086', '45'),
('800042', '98087', '46');
UNLOCK TABLES;

[djeryv]

I haven't done anything EQ related in years and so I put the files in a temporary file sharing site as I no longer am keeping them...

http://www38.zippyshare.com/v/11520321/file.html

...so if anyone is going to keep this alive, get it before it vanishes forever.

-Djeryv

[Twilightmist]

I know I am late in seeing this, but is there any way you can repost the sql for the solo server? I just started my own server and would love to have this in my own server.

[skyy]

also new to eqemu and would love to get my hands on solo server configs / modifications.

I would also be keen on any hints on scaling up players by removing/lifting skill and stat caps in order to beat raid encounters (i wouldnt mind trivialize regular content).

[djeryv]

LINK (http://mangar.ddns.net/eq/eq_solo.zip)

[djeryv]

I wish these forums would let you edit your posts...ugh...so after rearranging my files structure on my web server...lets try this again...

http://mangar.ddns.net/files/eq_solo.zip

LINK (http://mangar.ddns.net/files/eq_solo.zip)

[N0ctrnl]

I can edit my posts...

[djeryv]

I can edit my posts...

But after a certain period of time...you cannot. Otherwise, I would just have kept editing my original post with the new link whenever I shuffled stuff around.

[Indev]

Sorry for thread necro, but I wanted to point out to the community that there are a couple promising Solo servers up and running, but no one can apparently connect to- talking mainly about Wanderlust and Howling Sky.

If anyone knows either server op, kindly alert them to a remedy.

Thanks :)