Page 1 of 1

Not error in the wiki, just a DB issue...

Posted: Thu Jan 05, 2017 3:04 am
by Delaide
Whasf, I checked: https://wiki.dspt.info/index.php/Database
Find the mob you want to modify from the sql/mob_pools.sql table.

With the poolid find the mob in sql/mob_groups.sql.

Get the dropid then find the table in sql/mob_droplist.sql.
So, I tried this, and the results failed:

Find mob "leaping_lizzy" in sql/mob_pools.sql -> poolID = 2384

Code: Select all

INSERT INTO `mob_pools` VALUES (2384,'Leaping_Lizzy',174,0x0000480100000000000000000000000000000000,1,1,7,240,100,0,0,0,1,2,0,0,0,3,0,0,0,1,0,174);
Find poolID in sql/mob_groups.sql -> dropid = 2035

Code: Select all

INSERT INTO `mob_groups` VALUES (2591,2384,77,0,128,2035,0,0,75,80,0);
Find dropid in sql/mob_droplist.sql -> Drops are not correct for 2035:

Example: INSERT INTO `mob_droplist` VALUES (2035,0,18592,20);
Itemid 18592 =
Elder Staff]
[Main] All Races
DPS: 821 DMG:55 Delay:402
LV 75 SCH
So, I checked on irc, and got this reply:
check mob_spawn_points -> mob_groups.sql -> mob_droplist.sql

For this, I get these results:
Find groupid in mob_spawn_points.sql -> groupid = 5947

Code: Select all

INSERT INTO `mob_spawn_points` VALUES (17215868,'Leaping_Lizzy','Leaping Lizzy',5947,-283.760,21.444,-412.182,127);
Find dropid in mob_groups.sql -> dropid = 2036

Code: Select all

INSERT INTO `mob_groups` VALUES (5947,2384,107,18000,128,2036,0,0,10,11,0);
Correct unique item found in correct dropid value:

Example: INSERT INTO `mob_droplist` VALUES (2036,0,15351,70);
Itemid 15351 =
Bounding Boots
[Feet] All Races
DEF:3 DEX+3 AGI+3
LV 7 WAR RDM THF PLD DRK BST BRD RNG SAM NIN DRG BLU COR DNC RUN
I think the wiki may need the information updated, since it seems to not work correctly when I try finding dropids using the documentation...
Unless there is some other reason why this is right in one instance, wrong in another :shock:

Re: @Whasf, error in the wiki

Posted: Thu Jan 05, 2017 5:53 pm
by TeoTwawki
What was said was
"mob_spawn_points -> mob_groups -> mob_pools"
Because you seemed to think pools table had the group id, and its the other way around with group table having a pool id next to the group id.

Code: Select all

INSERT INTO `mob_groups` VALUES (groupid,poolid,zoneid,respawntime,spawntype,dropid,HP_override,MP_override,minLevel,maxLevel,allegiance);
Both the pool ID and droplist ID are in the group table.


you prolly found a bunch of ID that got used twice by mistake (there is a ton of that)

Re: @Whasf, error in the wiki

Posted: Thu Jan 05, 2017 9:38 pm
by Delaide
Hmm, Teo, you may be right.

I found a second entry in mob groups:

Code: Select all

INSERT INTO `mob_groups` VALUES (5947,2384,107,18000,128,2036,0,0,10,11,0);
This matched the proper item drops.

First one is from line 2626 that has the error, the second is from line 5982 that is correct.

Sorry, guess this should have been bug report, not wiki report...I will see if I can change the thread title.
But, wouldn't that mean Leaping Lizzy is dropping nyzul island gear, since the poolid matches LLs?

Well, guess I will have to spawn and check.

Re: Not error in the wiki, just a DB issue...

Posted: Fri Jan 06, 2017 2:40 am
by TeoTwawki
Well, Nyzul isle has its own version of Leaping lizzy, right? Andvthey have different drops on retail, right? Nyzul version drops a '???' item to be appraised. In this case, there should be 2 IDs (or more, s.gusta alone has 2 dunno who many copies nyzul has) in diff zones in spawn points, 2 groups, 2 pools, 2 drop lists..So maybe this one isn't an error after all.

Now the wotg beatsmen on the other hand..They just wound up mixed with existing groups. ;)