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
  #1  
Old 05-13-2014, 01:59 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default Akka's Diablo Loot Generator Script

This thing is pretty much the shit, it's a few years old but I've compiled it for all the people who have been wanting it over the years.

It is as is, have fun.

http://wiki.eqemulator.org/p?Diablo_...ster_Reference

Reply With Quote
  #2  
Old 05-13-2014, 03:13 AM
knowom's Avatar
knowom
Discordant
 
Join Date: Jun 2006
Posts: 371
Default

Quote:
Originally Posted by Akkadius View Post
It's just a Perl script that reads from a database table and then does insane amounts of loops based on criteria.
Sounds need on the topic of randomization. For me personally my ideal randomization tool would just to select random 1-10, 1-100, or random 1-1000 and have a button to click to do that to a individual stat selected this could then either be added to the stat value or determine the stat value. It would be endlessly fun and a great way to spice up loot tables.

I liked how randomization was handled in UO for magic items. It wasn't so all over the place in terms of "RNG is RNG" randomization Diablo's known for.

http://wiki.uosecondage.com/Item_ID
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #3  
Old 05-13-2014, 03:17 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by knowom View Post
Sounds need on the topic of randomization. For me personally my ideal randomization tool would just to select random 1-10, 1-100, or random 1-1000 and have a button to click to do that to a individual stat selected this could then either be added to the stat value or determine the stat value. It would be endlessly fun and a great way to spice up loot tables.

I liked how randomization was handled in UO for magic items. It wasn't so all over the place in terms of "RNG is RNG" randomization Diablo's known for.

http://wiki.uosecondage.com/Item_ID
Huh? You could easily extend this to have that functionality. Not making a whole lot of sense.
Reply With Quote
  #4  
Old 05-13-2014, 03:51 AM
Splose
Banned
 
Join Date: Apr 2014
Posts: 279
Default

Quote:
Originally Posted by knowom View Post
Sounds need on the topic of randomization. For me personally my ideal randomization tool would just to select random 1-10, 1-100, or random 1-1000 and have a button to click to do that to a individual stat selected this could then either be added to the stat value or determine the stat value. It would be endlessly fun and a great way to spice up loot tables.

I liked how randomization was handled in UO for magic items. It wasn't so all over the place in terms of "RNG is RNG" randomization Diablo's known for.

http://wiki.uosecondage.com/Item_ID
Reply With Quote
  #5  
Old 05-13-2014, 03:54 AM
knowom's Avatar
knowom
Discordant
 
Join Date: Jun 2006
Posts: 371
Default

Hmmm never mind then I guess it's more flexible than I was thinking or understand it at least. I'll have to read the wiki on it in more depth at some point.
__________________
"We are all on the same team, and I think not enough people realize this."
- Leetsauce
Reply With Quote
  #6  
Old 05-14-2014, 08:16 AM
Trubles
Sarnak
 
Join Date: May 2014
Posts: 80
Default

Knowom, I've stolen this and modified it to include chance drops, let me know if you'd like me to post.
Reply With Quote
  #7  
Old 05-14-2014, 11:49 AM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Trubles View Post
Knowom, I've stolen this and modified it to include chance drops, let me know if you'd like me to post.
'chance drops', what?
Reply With Quote
  #8  
Old 05-14-2014, 01:06 PM
Trubles
Sarnak
 
Join Date: May 2014
Posts: 80
Default

I don't even know, I broke the script lol.
Reply With Quote
  #9  
Old 05-17-2014, 04:06 PM
vithmiris's Avatar
vithmiris
Sarnak
 
Join Date: Dec 2013
Posts: 46
Default

Attempting to run 'perl DiabloLoot.pl' from my Server dir and am receiving:

DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'localhost' (using password: NO) at DiabloLoot.pl line 35
DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'localhost' (using password: NO) at DiabloLoot.pl line 36

I've installed ppm install http://www.bribes.org/perl/ppm/DBD-mysql.ppd

Am I missing something with my connect configuration?
Reply With Quote
  #10  
Old 05-17-2014, 04:48 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Quote:
Originally Posted by vithmiris View Post
Attempting to run 'perl DiabloLoot.pl' from my Server dir and am receiving:

DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'localhost' (using password: NO) at DiabloLoot.pl line 35
DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'localhost' (using password: NO) at DiabloLoot.pl line 36

I've installed ppm install http://www.bribes.org/perl/ppm/DBD-mysql.ppd

Am I missing something with my connect configuration?
You're not supplying a password. Do you have a password set? If you do, it won't let you connect, even if you're on localhost, without the password.
Reply With Quote
  #11  
Old 05-18-2014, 07:25 PM
vithmiris's Avatar
vithmiris
Sarnak
 
Join Date: Dec 2013
Posts: 46
Default

I was under the impression the script looked inside eqemu_config.xml for DB credentials.

If this isn't the case, does DBI need to be configured in some manner?
Reply With Quote
  #12  
Old 05-18-2014, 09:39 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

If it isn't looking into your eqemu_config.xml, yes, it will need the same database information used within the eqemu_config.xml.
Reply With Quote
  #13  
Old 05-19-2014, 12:41 AM
lerxst2112
Demi-God
 
Join Date: Aug 2010
Posts: 1,743
Default

It should read from the config file assuming it can find it in the current directory. If not it should print ""Unable to open config: eqemu_config.xml"

You could always modify the script to print what it found for those variables so you can maybe figure out where it went wrong.
Reply With Quote
  #14  
Old 09-29-2014, 03:22 PM
ionhsmith
Discordant
 
Join Date: Jun 2014
Posts: 284
Default

ok trying to learn how to do all this so bare with me ... I followed what I could from the wiki and I have the diabloloot.pl in the plugins folder of my server but how do i run the script? i get this when i try ... DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 109.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 95.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 97.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 99.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 105.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 107.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 109.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 95.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 97.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 99.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 105.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 107.
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 109.
Generating General Loot... Please wait...
DBD::mysql::st fetchrow_array failed: fetch() without execute() at Diabloloot.pl
line 137.
Items Processed: 0
DBD::mysql::st execute failed: No database selected at Diabloloot.pl line 186.
Generating Augments Loot... Please wait...
DBD::mysql::st fetchrow_array failed: fetch() without execute() at Diabloloot.pl
line 189.

Loot has been successfully generated
Items Processed: 0


Job took 1 seconds

C:\EQ\EQEMUServer>

Last edited by ionhsmith; 09-29-2014 at 05:31 PM.. Reason: new info
Reply With Quote
  #15  
Old 09-29-2014, 08:25 PM
cleramsey
Fire Beetle
 
Join Date: May 2010
Posts: 6
Default

If you have DiabloLoot.pl in your plugin folder need to move it your your actually server directory folder in order to run it properly.
__________________
Tegolas
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 03:36 PM.


 

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