Hello ALL, working on an updated MWnpcmov release

tcsmyworld · #1 01-26-2004, 04:24 PM

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 · #2 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 · #3 01-26-2004, 04:29 PM

On the server I just set up??

Shadow-Wolf · #4 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 · #5 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 · #6 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 · #7 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 · #8 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 &lt;> 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 &lt;> 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 &lt;> 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 &lt;> 0 and items.id is null;
select tradeskillrecipe.id, product2 from tradeskillrecipe left join items on product2 = items.id where product2 &lt;> 0 and items.id is null;
select tradeskillrecipe.id, failproduct from tradeskillrecipe left join items on failproduct = items.id where failproduct &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i1  from tradeskillrecipe left join items on i1  = items.id where i1  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i2  from tradeskillrecipe left join items on i2  = items.id where i2  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i3  from tradeskillrecipe left join items on i3  = items.id where i3  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i4  from tradeskillrecipe left join items on i4  = items.id where i4  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i5  from tradeskillrecipe left join items on i5  = items.id where i5  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i6  from tradeskillrecipe left join items on i6  = items.id where i6  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i7  from tradeskillrecipe left join items on i7  = items.id where i7  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i8  from tradeskillrecipe left join items on i8  = items.id where i8  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i9  from tradeskillrecipe left join items on i9  = items.id where i9  &lt;> 0 and items.id is null;
select tradeskillrecipe.id, i10 from tradeskillrecipe left join items on i10 = items.id where i10 &lt;> 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 · #9 01-26-2004, 07:26 PM

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 · #10 01-27-2004, 03:56 AM

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 · #11 01-27-2004, 06:16 AM

(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 · #12 01-27-2004, 07:56 AM

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 · #13 01-27-2004, 08:37 AM

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 · #14 01-27-2004, 09:00 AM

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 · #15 01-27-2004, 09:33 AM

This man is a testing MACHINE !