EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Hello ALL, working on an updated MWnpcmov release (https://www.eqemulator.org/forums/showthread.php?t=11591)

tcsmyworld 01-26-2004 04:24 PM
Hello ALL, working on an updated MWnpcmov release
 
Trying to get out a compatable DB, with several fixes too.
I need people to log onto my test server (TCsMyWorld_Test) and give me feedback.
Wanting to know if you spot any dupe spawns, empty vendors, and anything else that may seem odd.
We appreciate your help in testing the DB, it will help speed up development if we can get feedback.

NOTE: since we are gathering info for a base DB for public ditribution, the server is "Legit" except for the #zone command, so we can get input about aggro,faction,npc hp/damage,vendors, etc.

P.S. : Sorry for my long absence, didn't have I-net connection.
I'm back now, with cable connection :)
I'm ready to dive back in and get some releases rolling out :)

Bud9Wieser where are you??????

Shadow-Wolf 01-26-2004 04:26 PM
cant login right now but i can tell you felwithe has dupe spawns(guards, soulbinder, Tynkale) and little rats hitting hard

tcsmyworld 01-26-2004 04:29 PM
On the server I just set up??

Shadow-Wolf 01-26-2004 04:31 PM
well i wouldn't know but i know the newest version of the db i could find for download had dupes in felwithe with mega rats im still using old 5.1 5.2 alpha 2 for my 5.3 server because im too lazy to get rid of the dupes in the db myself...

tcsmyworld 01-26-2004 04:33 PM
This is an update with over 2400 dupes removed :)
If you could log onto server and check the spots that had dupes for us , it would help a lot :)
Let us know what you find.

Shadow-Wolf 01-26-2004 04:37 PM
cant log in tonight or tommarow for that fact but i will try and find some time to help....

masticism 01-26-2004 07:00 PM
Any chance you could enable access to the #npcstats and #goto command. It will make it easier to report any dups if we can just give you the npc id number directly don't ya think?

As for the goto command....I just like it better than zone ;)

Lurker_005 01-26-2004 07:10 PM
Here, I just worked out the SQL to find NPC venders with empty item lists.
Code:
select id, name, merchant_id from npc_types left join merchantlist on merchant_id = merchantid where merchant_id <> 0 and merchantid is null;
and also to find items used on vendors but not in the DB
Code:
select npc_types.id, npc_types.name, merchant_id, merchantlist.slot, merchantlist.item from npc_types, merchantlist left join items on merchantlist.item = items.id where merchant_id <> 0 and merchant_id = merchantid and items.id is null;
and finally items used in loot but not in the DB
Code:
select npc_types.id, npc_types.name, npc_types.loottable_id, lootdrop_entries.item_id from npc_types, loottable_entries, lootdrop_entries left join items on lootdrop_entries.item_id = items.id where npc_types.loottable_id <> 0 and npc_types.loottable_id=loottable_entries.loottable_id and loottable_entries.lootdrop_id=lootdrop_entries.lootdrop_id and items.id is null;
Whew.
Hope that helps out. Note this will not find "broken" stuff if a a lootdrop or merchantlist entry

Oh one more for the tradeskill table items, sorry not sure of a way to make it all 1 query
Code:
select tradeskillrecipe.id, product from tradeskillrecipe left join items on product = items.id where product <> 0 and items.id is null;
select tradeskillrecipe.id, product2 from tradeskillrecipe left join items on product2 = items.id where product2 <> 0 and items.id is null;
select tradeskillrecipe.id, failproduct from tradeskillrecipe left join items on failproduct = items.id where failproduct <> 0 and items.id is null;
select tradeskillrecipe.id, i1  from tradeskillrecipe left join items on i1  = items.id where i1  <> 0 and items.id is null;
select tradeskillrecipe.id, i2  from tradeskillrecipe left join items on i2  = items.id where i2  <> 0 and items.id is null;
select tradeskillrecipe.id, i3  from tradeskillrecipe left join items on i3  = items.id where i3  <> 0 and items.id is null;
select tradeskillrecipe.id, i4  from tradeskillrecipe left join items on i4  = items.id where i4  <> 0 and items.id is null;
select tradeskillrecipe.id, i5  from tradeskillrecipe left join items on i5  = items.id where i5  <> 0 and items.id is null;
select tradeskillrecipe.id, i6  from tradeskillrecipe left join items on i6  = items.id where i6  <> 0 and items.id is null;
select tradeskillrecipe.id, i7  from tradeskillrecipe left join items on i7  = items.id where i7  <> 0 and items.id is null;
select tradeskillrecipe.id, i8  from tradeskillrecipe left join items on i8  = items.id where i8  <> 0 and items.id is null;
select tradeskillrecipe.id, i9  from tradeskillrecipe left join items on i9  = items.id where i9  <> 0 and items.id is null;
select tradeskillrecipe.id, i10 from tradeskillrecipe left join items on i10 = items.id where i10 <> 0 and items.id is null;
These could be modified to use unique to get just the items that are missing, but you should get the idea.

masticism 01-26-2004 07:26 PM
paineel
 
Paineel Issues (complete except for MOBS)

DUPLICATE NPCS

Code:
(y x z) (Quantity) name

(733.9 826.72 -54.22) (2) tormented souls (different appearances)

(1162 399 -38 ) (2) "a spirit chanter"

(1212 450 -38 ) (2) "a spirit chanter"

Approx. Loc (948 833 -80)
(2) Loleluz
(2) Kelkarn
(2) Lolenton
(2) Gernatis

All of the following have "Guard" before their name:
(879 828 -79) (2) Lidozarn

(877 807 -80) (2) Hetorzuz 

(910 724 -80) (2) Yerlash

(905 505 -122) (2) Rireboln

(844 506 122) (2) Abbilash

(875 480 -120) (2) Pendleir

(863 600 -122) (2) Lelton

(887 600 -122) (2) Kellolonren

(666 542 -94) (2) Tynaryn

(615 496 -94) (2) Lecknar


(1075 852 -38 ) (2) Notzxatl

(1060 760 -38 ) (2) Nextloxtl

(1039 759 -38 ) (2) Exclorpt

(1133 793 -38 ) (2) Ezrothe

(1126 685 -38 ) (2) Lomanres

(1141 735 -38 ) (2) Sheltuin

(1165 736 -38 ) (2) Ishvlor

(1141 634 -38 ) (2) Mertanor

(1165 633 -38 ) (2) Ackin

(1225 682 -38 ) (2) Potren

(1255 751 -38 ) (2) Lesunra

(1282 759 -38 ) (2) Perelin

(1253 619 -39 ) (2) Lehlufa

(1040 600 -38 ) (2) Abrebla

(893 -134 3.78) (2) Heridion

(946 -95 3.76) (2) Menbuknar
MERCHANTS:
Code:
(y x z) name (freebies) [Further Notes]

(675 805 -54 ) Nedorl Ipabrun (Damask Gloves)

(1093 723 -37 ) Dannis Faleet (Earring of Desecration, Tome of Miragul, Darkened knights Breastplate)

(1124 428 38 )  Oren Calferdo (silvered mace, Forged Firebrand Mace, Forged Firebrand Morning Star, Focused Ethereal Warhammer)  --> [exchange all merchant's items with Jenkin Fleetmore, Jenkin has spells and should have weapons, Oren should have the spells]

(1121 738 -38 ) Zarnlel Apridor --> [exchange all merchant's items with Kervis Ackblor, Kervis should have armor, Zarnlel should have spells]

(1095 437 -38 ) Jenkin Fleetmore [exchange with Oren above]

(1095 429 -38 ) Kervis Ackblor [exchange with Zarnlel above]

(1214 549 -38 ) Lilian Han Oni (Imbued Shield of Paineel) --> [supposed to be a spells merchant]

(1222 548 -38 ) Erelin Verisue (Bloodstained Gloves, Steelsilk Helm, Steelsilk Greeves, Imbued Steelsilk Helm, Imbued Steelsilk Mask, Imbued Steelsilk Pauldron, Imbued Steelsilk Cloak, Imbued Steelsilk Bracers,  Imbued Steelsilk Guanlets, Imbued Steelsilk Greaves) --> [supposed to be a spells merchant]

(1223 522 -38 ) Tenralus Brackmar (Forged Mace, Bronze Flail)

(954 758 -79) Geomar Hapera (Tailored Wrist Pouch, Tailored Large Belt, Tailored Small Bag, Medium Metal Container, Large Metal Container)

(992 803-79) Taria Clayspinner (Block of Magic Clay)

(994 806 -79) Tentus Brackmar (Small Brick of Brellium, Large Brick of Brellium, Block of Brellium)

(994 814 -79) Evus Dorakmul (Imbued Black Pearl)

(939 422 -120) Faratain (Paineel Steel: Mask, Collar, Breastplate, Pauldron, Cloak, Girdle, Vambraces, Bracers, Greaves, Boots)

(898 442 -120) Dovan Sires (Forged Deathsteel: Bastard Sword, Battle Axe, Short Sword, Long Sword, Morning Sword, Warhammer, Dagger, Spear, Rapier, Two Handed Sword, Halberd)

DOORS:
Lift door still doesn't work (I believe it's door id -9, -10 and -13 if it hasn't changed from the previous release)


GMs:
Necro GMs, ShadowKnight GMs, and Cleric GMs still show up as Enchanters (i.e. they won't train you)

Defualt Binding location is (3 3 3) which is in a box with teleport numbers.


LOOT DROPS:
Can't check the loot drops because I'm a wussy 1st lvl necro without a #kill command ;)

wize_one 01-27-2004 03:56 AM
Halas
 
halas:
Dargon McPherson 474 -444 4(empty merchant)
Lysbith McNaff 554 -414 -17(empty merchant)
Kylan O'danon 576 -490 -17 (empty merchant)

no warrior trainer located in warrior starting area.

Cindl 273 -172 4 (merchant, bear-hide tunic free, wolf-hide cape free)

Greta Terrilon 283 -325 4 (merchant, embroidering needle free)

April 180 296 4 (merchant, fine plate being sold for far less then standard plate)

Guthan Shawnasy 192 -326 4 (merchant, pick free)

Kevan McPherson 203 -329 4 (merchant, northman long dagger free, imbued northman dagger free)

Murtog MacYee 122 -366 4(merchant, earring of magic reflection free, worn brass ring free, runed ring of fire free)

Brin McQuaid 91 221 4(merchant, corking device free)

Donald McQuaid 91 -206 4 (merchant, hulgarsh free)

Hetie McDonald 239 156 4(merchant, vegetable soup free, shark fillet free)

Becka McGuzzlin 199 -141 4(merchant, cup of flour free, baking spirits free(listed 2 times))

Brandyn McDonald 180 -152 4(merchant, hulgarsh free)

Ambril McRohler 321 -306 25(merchant, about northman ringmail free)

Sissia 361 -326 25(merchant, baking spirits free(listed 2 times))

Scon McDaniel 341 -345 4(merchant, hulgarsh free)

banker and guards out of place

Elona McMahon 210 180 30(merchant, celestial suspension free, giant wasp venom free, gelsemium root free, dogbane free, castorbean free, wood rose free, snake head iris free, hounds tongue free, red hellebore free, bundle of wormwood free)

Rogue trainers reporting as beastlord
elyn connoy
dun mcdowell
ysanna macgibbon
cappi mctarnigal

Jac MacGrove 196 402 4(merchant, velium topaz necklace free)

Merin 260 276 4(merchant, block of magic clay free)

Waltor Felligan 300 271 4 (merchant, empty)

Corak 314 423 -19(merchant, northman ring mail(looks like arms but is chest item) free, northman ringmantle free, northman ring sleeves free, northman ring gauntlets free, northman ring boots free, imbued northman ring helm free, imbued northman ring boots free)

Tukanta 350 422 -19(merchant, bronze flail free, forged mace free)

Jinkus Felligan 318 447 -19 (merchant, empty)

Telvina 317 450 -19(merchant, lost marble free)

Margyn McCann 334 481 -19(merchant, empty)

Rose McDowell 396 160 5(merchant, tailored wrist pouch free, tailored large belt pouch free, ailored small bag free, medium metal container free, large metal container free)

Shenigan McMacky 645 234 4 (nothing, should be bst spells)

Quillion O'Zinn -29 56 4(merchant, yellowjacket dry fly free, busy bee dry fly free, giant bloodsucker treble fly free, yappin doggy dry fly free, screeching dry fly free, squeaking nibbler dry fly free, night swooper dry fly free)

Skoni 3 -34 4(merchant, beer braised mammoth free, mammoth sandwich free)

raft doesnt line up on everfrost side(about 45 degree angle to landing)
============================

think thats it for halas

wize_one 01-27-2004 06:16 AM
Everfrost
 
(all done with barb warrior)

newbie mobs all hitting 300+ no moving mobs in zone that i could find.

most spawns with wrong textures were missing faction hits.

being zone for about a hour i went LD not sure what that mmight be related to, happens on my server too)

zone report:

Seria O'Danos 3613 700 4(merchant, bronze axe free, bronze broad sword free, bronze claymore free, bronze flail free)

guards to halas missing

a_polar_bear_cub useing wrong texture(looks like brown bears, possible double spawn at 2468 -236 -44)
instant respawn at
910 -520 -57
1276 -316 -59
1362 -295 -59
2468 -236 -44(x2)
2708 -16 -59
2533 473 -59
433 847 -59
-1435 -103 -60
190 -528 -60
-196 -731 -59
-630 -684 -58
-1383 -515 -59


a_white_wolf(wrong texture)
instant respawn at:
1983 -96 -56
401 867 -59
21 899 -59
-743 632 -55
-1394 -28 -60
-518 -702 -59


a_decaying_skeleton(amiably faction, no faction hit on most)
instant respawn at:
2057 -108 -59
2700 185 -59
1621 734 -59
1361 693 -56
1211 600 -59
424 862 -59
-1144 866 -60
-1195 752 -60
-1221 -738 -46


vengeful_composer 281 -501 -57 instant respawn no faction


Z-axis in zone table needs to be fixed, should be -59.53 falling for 35 or so dmg on respawn from death


a_mammoth_calf(wrong texture)
instant respawn at:
263 -2441 -61


a_snow_wolf(wrong texture)
instant respawn at:
-322 -2293 -69
-1110 -2826 -41
-1258 -2861 -23
189 -2995 -81
2150 -2522 -60


ice_boned_skeleton(no faction)
instant respawn at:
-1027 -2980 -60
-530 -5714 -14
4754 -4185 -97
4756 -4124 -97
4939 -4823 -97
4981 -5121 -86(also has double spawn)
4366 -4858 -96


a_snow_leopard(wrong texture)
instant respawn at:
91 -5451 -61
257 -2964 -104
494 -5778 -60
537 -5866 -60
459 -6164 -60
824 -5602 -23
1155 -3144 -62
2269 -2702 -60
2420 -5231 -69
1563 -5764 -27


a_wooly_mammoth_calf(wrong texture)
instant respawn at:
-1198 -4393 -101
-1195 -5158 -50
-1210 -5958 -84
1841 -4894 -75
1769 -5745 -63

a_polar_bear(wrong texture)
instant respawn at:
-299 -2991 -57
1222 -2407 -77
1565 -3047 -114


a_skeleton
instant respawn at:
-295 -2593 -24
1125 -2323 -91
1638 -2312 -92


a_wooly_mammoth(wrong texture)
instant respawn at:
760 -4894 -101
2048 -4521 -60
2045 -5064 -57

dark_assassin(amiably faction, blue at 65)
qeynos citizens faction got worse with death

tundra_jack(ally faction, light blue at 65)
halas citizens got worse on death
iceberg did not assist

iceberg(all faction, green at 65)
halas citizens got worse on death
has dupe spawn at 2046 -3840 -60(wrong texture wrong faction)


an_ice_goblin_scout and a_goblin_caster double spawn -964 -1565 -59

snowflake 2019 -1157 -60
double spawn one right faction one wrong faction

sulgar 3030 -2390 -60(blue to 65, apprehensively faction)
qeynos faction got worse on death

stan_bearjumper(wrong texture, showing naked barb male, light blue 65)
halas citizens got worse on death

megan oreilly 2034 -4229 -64(wrong sex wrong texture)
halas citizens got worse on death

martar icebear 2255 -4428 -101 (wrong texture, wearing chain and should be leather)
halas citizens got worse on death(isnt martar the outcast? shouldnt it be getting better?)


an_ice_giant (all 3)(size is off, should be like 25) on vox facion (respawn should be about 7 mins, been about 20 mins and no respawn)


ice_goblin_diver 3607 -3815 -97 (has wrong Z-axis point, floating at roof level)

lich of miragul 4909 -3339 -97(faction indiff, light blue 65, both him and pet are in skel form)
standing with heretics got worse on death

sulon mcmoor 4762 -3188 -97(blue 65, dubious faction)
qeynos citizens got worse on death

ban mcmarrin 733 -1477 -57 (name should be bandl mcmarrin)
halas citizens got worse on death

wize_one 01-27-2004 07:56 AM
Permafrost
 
no mobs from entrance to flag room

invis mob "several roars" -195 -35 4, amiably faction, instant respawn, no faction on death

flag room only 2 spawns

missing door 246 -3 4

a_young_dire_wolf 237 444 -37(double spawn, one is instant)

a_dire_pup
instant respawn at:
273 432 -37

a_large_dire_wolf 326 375 -37(double spawn, one is instant)

a_young_dire_wolf 365 334 -37(instant respawn)

a_dire_wolf and a_young_dire_wolf 351 230 -37(double spawn, young dire is instant respawn)

a_dire_wolf 461 364 -37(instant respawn)

a_dire_wolf and a_dire_pup 460 266 -37(dire wolf instant respawn)

a_young_dire_wolf 339 169 -37(double spawn, one is instant respawn)

a_dire_pup 328 85 -18(instant respawn)
a_dire_pup 341 -4 -23(instant respawn)

a_young_dire_wolf and a_dire_pup 418 54 -37(young dire wolf instant respawn)

354 116 -37 triple spawn
a_large_dire_wolf(x2 one wrong size and texture)
a_young_dire_wolf

a_dire_wolf 371 86 -37(instant respawn)

420 191 23 double spawn a_goblin_evoker and a_goblin_archeologist

Vox lair appears to be ok(lady vox could use a beef up)

a_giant_polar_bear 1142 -99 -67(wrong texture, instant respawn)

889 54 -79 double spawn a_giant_polar_bear

843 -2 -107 triple spawn a_giant_polar_bear

933 -21 -107 triple spawn a_giant_polar_bear

930 -71 -107 instant respawn a_giant_polar_bear

918 -144 -107 double spawn a_giant_polar_bear

909 246 -79 double spawn, instant respawn x2 a_giant_dire_wolf

1004 241 79 double spawn, instant respawn x2 a_giant_dire_wolf

the door to the alchemist does not open right

deye coolbreeze 185 -539 3(new mob never seen before,barb male, rdy to atk) on vox faction

180 -499 3 double spawn a_goblin_wizard and an_ice_goblin

38 -268 2 double spawn an_icy_goblin and a_goblin_wizard

wize_one 01-27-2004 08:37 AM
blackburrow
 
invis mob named courier spawner(amiably faction) -7 1 4
no faction on deadth

gnoll merchant 92 24 4(new mob to me) selling armor, works fine(on blackburrow faction)

243 229 -85 double spawn a_giant_snake, one instant respawn

zone point to jagged pine 162 149 -154 not working

296 -50 -123 instant respawn a_giant_snake

322 -55 -123 double spawn one instant respawn a_giant_snake

251 -12 -94 instant repawn a_giant_snake

210 141 -55 instant respawn a_giant_snake

189 90 -55 instant respawn a_giant_snake

door at -30 -103 -33 not in right place

door at 170 379 -124 doesnt open all the way

a_gnoll_brewer 75 69 -140(merchant, looks like it's working fine, blackburrow faction)

a_razorgill 25 -74 -223, instant respawn
a_razorgill 48 -77 -223, instant respawn
a_razorgill -8 -59 -223, instant respawn
a_razorgill 0 -79 -223, instant respawn

-220 -320 -61 double spawn, one instant respawn

wize_one 01-27-2004 09:00 AM
qeynos hills aka qeytoqrg
 
door at 1366 288 9 missing

Marton Sayer 1377 279 8(merchant, block of magic clay free)

Mira Sayer 1409 304 8(merchant, embroidering needle free)

gornolin 351 1104 -3(merchant, bronze flail free, bronze claymore free, bronze broad sword free, bronze axe free) the shack he is by turns if you click it(same with shack at 350 -1123 -3)

no double spawns found. no mob movement either

Trumpcard 01-27-2004 09:33 AM
This man is a testing MACHINE !

wize_one 01-27-2004 09:34 AM
hehe just a couple mins err hours of checking things..8) and thats just what 5 zones...theres only 2?? to go? 8|

Tertiary 01-27-2004 09:38 AM
Quote:
Originally Posted by Trumpcard
This man is a testing MACHINE !
Not to derail the thread, but do the Dev's have an official 'test script' that you use to test EQEmu before each release ? Might be useful to the 'code tinkerers' out there to thoroughly test our changes/fixes before submission ?

wize_one 01-27-2004 09:40 AM
this is a thread about testing and working on a updated database release. would try the dev area for answers on your question.

Tertiary 01-27-2004 09:55 AM
Quote:
Originally Posted by wize_one
this is a thread about testing and working on a updated database release. would try the dev area for answers on your question.
Apologies ... I just saw Trumpcard talk about testing and thought my question was relevant ... I promise not to post off topic again :oops:

Trumpcard 01-27-2004 10:07 AM
In a word, no.. Would I like to have them? Of course! It would be tough to write scripted test cases for a client server app like this.. It would be nice to do some CUnit integration, but I dont think it would work very well in this case....

Kroeg 01-27-2004 10:17 AM
The developers do release a DB used for 'tinkering' .. it's a fresh blank DB with only the structure of the DB required for EQEmulator.. it's called db.sql (typically packed with each offical release).

As to the content filled DBs developers use on public servers, those are all private and I'm pretty sure will always stay that way. The only DBs available are the ones found on the forum here in the Worldbuilding section, or others on EQEmulator fan pages.

wize_one 01-27-2004 11:52 AM
surefall galde (aka qrg)
 
some moving bears out in normal area no mobs in caves.
========================

Hager Sureshot 107 89 3(merchant, empty)(i believe he's suposed to be ranger guildmaster)

Larsk Juton 250 -71 1(merchant, empty should be ranger GM)

Frannie -35 10 4(merchant, wrong texture)

door missing 111 -35 4

Gillarian Naelev 175 -34 4(should be ranger GM)

Errin Pinewhisper 173 -13 4(should be ranger GM)

Merona Castekin 134 -105 4(should be ranger GM)

Tonsia 123 -107 4(merchant, should have arrow making parts, fletching kit)

Bukem Breewood 107 -75 4(merchant, fine steel tonfa free, reinforced bamboo wakizashi bo free, reinforced bamboo tanto bo free, suposed to be spell vender)

Grathin Nilm 107 -84 4(merchant, studded tunic free, studded gloves free, reinforced skullcap free, reinforced tunic free, reinforced cloak free, reinforced gloves free, reinforced boots free)

Durvinna Barkkis 106 -105 4(merchant, cloak of the earth free, woven bark gloves free)

Vesteri Nomanoi -117 -297 1(should be druid GM)

Sallah -156 -285 1(merchant, reinforced cloak free, fine splinted cloak(x2))

Gerael Woodone -182 -399 1(should be druid GM, reporting as beastlord gm)

Te`Anara -198 -425 4(reporting as beastlord gm)

Salmekia Treherth -221 -429 4(should be druid GM)

portal to jaggedpine not working 37 -511 40

Scorpious2k 01-28-2004 03:45 AM
Quote:
Originally Posted by Tertiary
do the Dev's have an official 'test script' that you use to test EQEmu before each release ? Might be useful to the 'code tinkerers' out there to thoroughly test our changes/fixes before submission ?
I test things on a test server with minilogon if they are "dangerous" and then move them to our server before they get posted/added to cvs... the undangerous stuff goes straight to our server for testing first.

Aquelin 01-28-2004 08:20 PM
Get rid of twink-item selling merchant fewls plzkby.

diolas 01-29-2004 03:17 AM
What to include?
 
I'd very much like to help out, though I need to know the level of detail you're interested in. Is Wize_One's post a good example? Also, what kind of specifics do you need. For example, if I were to mention that a nesting rat is missing at x, y co-ordinates would you know the details of that mob or would I need to give it? I'm interested in doing the Qeynos Catacombs as I've spent more hours there than any other single zone in EQ.

At any rate, I'm going to start compiling information and I'll check back here later to see what specifics you request.

Kroeg 01-29-2004 05:19 AM
It is an all-around general type of thing. You use the db and load your eq client. Once in-game, you spend your time testing everything out. Check spawn placement (yes, even npcs facing walls is something that is worth fixing), check if spawns are spawned in the air/on top of one another... see if zonepoints are bringing you where they should.. stuff like that. There is no real method to fixing a db... it's a trial-and-error sort of thing.

I'd suggest using mysql-front (or any other sql editor that gives you sql queries for everything you change) ... then whenever you make a change, copy the sql query down below into a text file, and comment each query with what it changes/does.

diolas 01-29-2004 06:33 AM
Ok, sounds good.
One last question, i need to have a link to the DB. I've got so many DB's loaded on my server right now it's hard to know which is which. I apologize ahead of time for requesting this as I know I'll probably get flamed for it.

Tell you what, here's a list of my DB's right now. You can let me know which ones to use.

0.5.2-update.sql
db.sql
dumpeditems.sql
jan24.sql
notes.sql
spawns.sql
tradeskill_arcaneorder.sql
tradeskill_rotlc.sql
tradeskills.sql

Thanks in advance

tcsmyworld 01-29-2004 08:48 AM
Basically , if you grab the last release of MW DB, 052_053_alpha2 and source it, then the Jan24Update.sql you'll be running about the same as I have on the test server right now.

diolas 01-29-2004 09:18 AM
Ok, I'll give that a try. I have played on the test server for a bit already. A few things I noted:
- Low lvl mobs have way too much hp. Lvl 1 mobs were giving me a hard time at lvl 2. I'm pretty sure it's not the damage output, just the number of hp's they have.

- Need to fix the safe co-ordinates for qeynos aqueducts. The current one makes you die when you pop in at some times. I'll get you the exact co-ordinates to use for each zone in tonight or tomorrow.

- Starting Human Sk's in Qeynos (bertox) need starting gear as well as the Necros.

haloboycs 01-29-2004 02:48 PM
Merchants
East Cabilis - Smithy Zern (empty)
East Cabilis - Drill Master Vygan (wasnt he suppose to be Warrior GM?)
East Cabilis - Drill Master Kyg (another Trainer GM?)
West Cabilis - Visar Glolith (empty)

GM Trainers
West Cabilis - Ton of robed Iksar are Enchanter GM (theres no Iksar Enchanter combination, so i assume its all necro GM)

Items
Wand of Filth - no atk/dly on it but effect : combat??? (no clicky?)
Potion of Greater Rejuvenation - combat
Potion of Negation - combat
Potion of Insight - combat
Potion of Charming Deceit - combat
Potion of Troll's Essence - combat
Potion of Frosty Insurgery - combat
Potion of Gnomish Boils - combat
Potion of Fleeting Lanquor - combat
Potion of Copal's Demise - combat
Potion of Assailing - combat
Potion of Graveyard Dust - combat
Potion of Soluan's Vigor - combat
Potion of Corpse Retrevial - combat and wrong class/race? (mag / hum eru hie def gnm)

*dang crashed zoning from WCab to ECab, i'll get more later*

haloboycs 01-29-2004 04:04 PM
Merchants
Ak'anon - TONS of missing cleric/pally merchants in Muse building
Ak'anon - TONS of missing necro/evil cleric merchants in evil mine
Ak'anon - a clockwork priest (empty)
Ak'anon - a clockwork rogue (below Muse, empty)
Ak'anon - Rylin Coil (empty)
Ak'anon - Clockwork Merchant (the one standing near Priest of Discord, empty, hes also at wrong spot)

Missing Mobs
Ak'anon - a_mechanic (that stand next to Rylin Coil)
Ak'anon - waterfall wheel (i know not a mob)
Ak'anon - a_mechanic (across waterfall in building)
Ak'anon - a_mechanic (loc 820, -110, 30, somewhere in the back with 3 spiders)

Wrong Mobs Location
Ak'anon - a_rock_spider (does not spawn next to Sandfyrd Featherhead, supposely inside evil mine)
Ak'anon - Zapho the Ancient (supposely stand next to priest of discord)
Ak'anon - one of "Clockwork Merchant" standing near Priest of Discord, doesnt stand there, i think supposely standing inside dirt hut (near sewing stand)
Ak'anon - 1 or 2 of those a_mechanic near King room, are at wrong spot, one of them supposely in room with 2 tanks

Mob Race/Texture
Ak'anon - Silox Azrix (wrong sex, supposely male)
Ak'anon - obsolete model (rat that wander in evil mine, wrong texture, need to be machine texture)
Ak'anon - Rilgor Plegnog (wrong robe texture; need to be brown robe)
Ak'anon - a_rock_snake (wrong texture; black/red)
Ak'anon - Guide # (i think all of them are Gnome Machine FEMALE)
Ak'anon - a_rock_spider (wrong texture; black/red)

GM Trainer
Ak'anon - Iony Gredlong (wrong sex, wrong texture; has to be leather, not an enchanter GM; has to be cleric GM)
Ak'anon - Digetha Chogaller (not cleric GM flagged?)
Ak'anon - Lobal Postugger (not rogue GM flagged?)
Ak'anon - Welno Tanboots (not a beastlord GM; supposely to be rogue GM)
Ak'anon - Evah Xokez (not an enchanter GM; supposely to be cleric GM, wrong sex; female, wrong texture; leather)
Ak'anon - Dewis Caneal (not necro GM flagged? brown robe)
Ak'anon - Eonis Mournunder (not an enchanter GM; supposely to be necro GM, brown robe)
Ak'anon - Garret Zethkog (not an enchanter GM, supposely to be SK GM)
Ak'anon - Kaxon Frennor (not a beastlord GM, supposely to be rogue GM, wrong texture; leather)
Ak'anon - Vaenor Husga (not a merchant, supposely mage GM, wrong sex; male)
Ak'anon - Velena Corgtec (not a beastlord GM, i think wiz GM, wrong sex; female, wrong robe texture; brown robe)
Ak'anon - Naygog Mitope (not a merchant, supposely to be warrior GM)

Items
Mischievous Dazzler Leggings - combat effect

*this isnt exact info, just catching something odd or checking on allakazam*

*edit - added a_rock_spider to texture*

diolas 01-29-2004 05:53 PM
Still Playing around with using mysql editors (noob at all this stuff but I'm learning!!! :D )

I noticed that the entry in zone_points id 472 (qeynos2) ends up in feerott for some reason... Am I on to something or is it just my DB?

I just did a fresh install of the db from the 0.5.2 and then used the jan 24 update. Am I missing anything?

Quote:
Originally Posted by tcsmyworld
Basically , if you grab the last release of MW DB, 052_053_alpha2 and source it, then the Jan24Update.sql you'll be running about the same as I have on the test server right now.
For some reason I couldn't find 052_53_alpha2s DB.sql

I have EQEmu_0.5.3DR2-ZP with an update.sql and zoneproxy_update.sql within, should I source those.

Feel free to /slap me if you think I should just start posting in a support forum. I can be very helpful with just a little more assistance.

wize_one 01-29-2004 06:05 PM
follow the link in siggy..downloads section

diolas 01-29-2004 06:37 PM
Bah, after much painful searching on my HD, I'd discovered that I already had it downloaded. Feel free to /slap me again.

Thanks anyways wize_one.

wize_one 01-30-2004 06:55 AM
there have been some changes, please log on to the tcsmyworld server to do further checking

haloboycs 01-30-2004 09:38 AM
Trainer GM
Ak'anon - Narron Jenork (not warrior GM flagged?)
Ak'anon - Lewis Reldnok (wrong Gm class, supposed to be paladin GM, wrong texture; plated)
Ak'anon - Tobon Starpyre (not a beastlord GM - correct GM unknown?)
Ak'anon - Lot of incorrect / unflagged GM Trainer in caster guild

Texture/Race/Gender
Ak'anon - Baxok Curhunter (wrong texture; chain)

Missing Mobs
Ak'anon - a mechanic (near zone-in)
Steamfont - minotaur (at loc 1240, 1977, -101.56)

Merchants
Ak'anon - Drekon Vebnebber (empty)
Ak'anon - a clockwork cobbler (empty)
Ak'anon - TONS of missing merchant at "good" caster guild
Ak'anon - Tergon Brenclog (empty)
Steamfont - Fodin Frugrin (empty)
Steamfont - Crisyn (empty and wrong sex - female, texture;leather)

Faction
Ak'anon - a lesser minotaur (wrong faction, hes scowl, supposely to be on akanon faction)
Steamfont - elementals (dubious, they supposely to be scowl to everyone)
Steamfont - a ebon lesser drakes (scowl, supposely to be dubious to everyone)
Steamfont - a small mountain lion (dubious, i think threatening to non-druid)

Misc
Steamfont - Driver Bryggin (doesnt spawn regularly, only spawns at Cargo Clockwork death)
Steamfont - Minotaur Sentry (doesnt spawn outside, only inside minotaur cave)


All times are GMT -4. The time now is 02:18 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.