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

Post Reply
Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

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

Post by Delaide » Thu Jan 05, 2017 3:04 am

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:
Last edited by Delaide on Thu Jan 05, 2017 9:39 pm, edited 1 time in total.

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

Re: @Whasf, error in the wiki

Post by TeoTwawki » Thu Jan 05, 2017 5:53 pm

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)
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

Delaide
Posts: 478
Joined: Sat Jun 14, 2014 8:58 am

Re: @Whasf, error in the wiki

Post by Delaide » Thu Jan 05, 2017 9:38 pm

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.

User avatar
TeoTwawki
Developer
Posts: 527
Joined: Mon Jul 15, 2013 9:50 pm

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

Post by TeoTwawki » Fri Jan 06, 2017 2:40 am

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. ;)
Hi, I run The Demiurge server.


Image
Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. - Martin Golding
PLS USE [ code ] CODE TAGS [ /code ] WHEN POSTING CODE
DO NOT PRIVATE MESSAGE ME ABOUT BUGS

Post Reply