Go Back   EQEmulator Home > EQEmulator Forums > Quests > Quests::Plugins & Mods

Quests::Plugins & Mods Completed plugins for public use as well as modifications.

Reply
 
Thread Tools Display Modes
  #46  
Old 04-22-2015, 06:37 PM
Pdizzle
Sarnak
 
Join Date: Nov 2013
Location: United States
Posts: 32
Default

I figured out the answers to my questions above...

Now I have a new question. I'm using Akka's repack, and have applied his diablo loot script to my database. What I've found is that there aren't really any raid mobs designated as ##. Some of the raid mobs are designated as #, and some named mobs are designated as # in their names. Is there an easy way for me to add # to all named NPCs and ## to all raid NPCs so the script can work properly? I'm not sure what type of identifier I can use to run a mass query.
Reply With Quote
  #47  
Old 04-22-2015, 07:48 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Pdizzle View Post
I figured out the answers to my questions above...

Now I have a new question. I'm using Akka's repack, and have applied his diablo loot script to my database. What I've found is that there aren't really any raid mobs designated as ##. Some of the raid mobs are designated as #, and some named mobs are designated as # in their names. Is there an easy way for me to add # to all named NPCs and ## to all raid NPCs so the script can work properly? I'm not sure what type of identifier I can use to run a mass query.
There is no easy way.

It is a convention I came up with and you will have to adhere to if you want to use it.

All you have to do is add it to the names of the NPC's you want at that caliber.
Reply With Quote
  #48  
Old 04-22-2015, 08:35 PM
Pdizzle
Sarnak
 
Join Date: Nov 2013
Location: United States
Posts: 32
Default

Quote:
Originally Posted by Akkadius View Post
There is no easy way.

It is a convention I came up with and you will have to adhere to if you want to use it.

All you have to do is add it to the names of the NPC's you want at that caliber.
Thanks for the quick response, Akka. Also, thanks for the tools you've provided.
Reply With Quote
  #49  
Old 08-21-2015, 07:54 PM
chasem
Fire Beetle
 
Join Date: Apr 2014
Posts: 23
Default

First off thanks Akka for this super simple way to implement Diablo-style loot!

Question: Is there any way to keep it from adding random loot to summoned pets?

Thanks!!
Reply With Quote
  #50  
Old 08-22-2015, 01:56 AM
royzzz's Avatar
royzzz
Fire Beetle
 
Join Date: Jun 2015
Posts: 8
Default

This is a really useful tool! Thanks Akka! Was easy to adjust all of the rows to customize the loot. My only complaint is the drop chance does not seem to be working right. Under drop_chance I used Heidi to change all to .15 with loottable_multiplier of 1. I am guessing maybe it does not allow a chance under 1?
Reply With Quote
  #51  
Old 08-22-2015, 04:58 AM
Splose
Banned
 
Join Date: Apr 2014
Posts: 279
Default

Quote:
Originally Posted by royzzz View Post
This is a really useful tool! Thanks Akka! Was easy to adjust all of the rows to customize the loot. My only complaint is the drop chance does not seem to be working right. Under drop_chance I used Heidi to change all to .15 with loottable_multiplier of 1. I am guessing maybe it does not allow a chance under 1?
design table (at least in navicat) -> change data type from integer to float/decimal.. you can do this for the zone scaling system and it works straight out.. not sure if this would work with the diabloloot.. I haven't looked at it in months but I don't see why it wouldnt.
Reply With Quote
  #52  
Old 08-22-2015, 03:56 PM
royzzz's Avatar
royzzz
Fire Beetle
 
Join Date: Jun 2015
Posts: 8
Default

The drop chance and aug drop chance are set to be float already. I was excited to try that, as I did not look at that before I posted, but Akka already had it set this way!
Reply With Quote
  #53  
Old 08-22-2015, 09:54 PM
chasem
Fire Beetle
 
Join Date: Apr 2014
Posts: 23
Default

Anyone know if it's possible to not have pets spawn with random items? Tried a few different things without much success. Players can't give them weapons when they spawn with items.
Reply With Quote
  #54  
Old 08-22-2015, 10:00 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by chasem View Post
Anyone know if it's possible to not have pets spawn with random items? Tried a few different things without much success. Players can't give them weapons when they spawn with items.
You can add a check to skip NPC's that have an owner ID.

Code:
sub EVENT_SPAWN{
	#::: START: Akka's Diablo Loot Handler :::#
	$NTYPE = 0; #::: TRASH
	if(substr($npc->GetName(), 0, 1) eq "#" && substr($npc->GetName(), 1, 2) ne "#"){  $NTYPE = 1; } #::: NAMED
	if(substr($npc->GetName(), 0, 2) eq "##" && substr($npc->GetName(), 2, 3) ne "#"){ $NTYPE = 2; } #::: RAID
	$LID = (200000 + ($NTYPE * 1000) + $npc->GetLevel());
	if($npc->GetLoottableID() != $LID){
		if($npc->GetOwnerID() > 0){
			return;
		}
		$npc->ModifyNPCStat("loottable_id", (210000 + ($NTYPE * 1000) + $npc->GetLevel())); $npc->AddLootTable();
		$npc->ModifyNPCStat("loottable_id", (200000 + ($NTYPE * 1000) + $npc->GetLevel())); $npc->AddLootTable(); 
	}
	#::: END: Akka's Diablo Loot Handler :::#
}
Reply With Quote
  #55  
Old 08-22-2015, 10:39 PM
chasem
Fire Beetle
 
Join Date: Apr 2014
Posts: 23
Default

Awesome thanks Akka! Very much appreciated!!
Reply With Quote
  #56  
Old 08-22-2015, 11:32 PM
royzzz's Avatar
royzzz
Fire Beetle
 
Join Date: Jun 2015
Posts: 8
Default

Figured out my issue. Once editor has run and you are happy, and dont plan on rerunning you can go under table loottable_entries and change the probability there with a sql script. That way you can adjust getting less than one item to drop from a mob. as even with having drop_chance set to a number less than one and float instead of integer set, once loottables are created the probablilty is 100. Hope that helps someone else with a similar issue! Again thank you Akka for this great tool!
Reply With Quote
  #57  
Old 09-01-2015, 05:40 PM
Gregk
Sarnak
 
Join Date: Mar 2010
Posts: 41
Default

Help...
DBD::mysql::st execute failed: Column 'multiplier' cannot be null at diabloloot.
pl line 98, <F> line 59.
DBD::mysql::st execute failed: Column 'multiplier' cannot be null at diabloloot.
pl line 108, <F> line 59.
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the m
anual that corresponds to your MySQL server version for the right syntax to use
near 'ORDER by hp' at line 19 at diabloloot.pl line 132, <F> line 59.
Generating General Loot... Please wait...
Reply With Quote
  #58  
Old 07-12-2016, 11:45 AM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

Akkadius, this script is awesome :P

Would you consider adding a function to the script where devs could omit items from being selected. Such as custom items that could be disregarded by maybe the "source" column? Just an idea.

Thanks for the awesome stuff bro!

Kimura
Reply With Quote
  #59  
Old 07-12-2016, 12:07 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Script is pretty much as is at this point, I have another way of doing this that does things completely on the fly in-game which is way faster and allows hot reloading.
Reply With Quote
  #60  
Old 07-12-2016, 12:20 PM
kimura
Hill Giant
 
Join Date: Oct 2011
Posts: 132
Default

eh, ok was just a suggestion, thanks for the quick response
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:49 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3