Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2014, 06:08 PM
Xenerox's Avatar
Xenerox
Hill Giant
 
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
Default random loot generator (not understanding)

http://wiki.eqemulator.org/p?Diablo_...ster_Reference im sorry but could someone please explain this one to me a little better ? how do i use it where do i put it ?
Reply With Quote
  #2  
Old 08-06-2014, 06:21 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Xenerox View Post
http://wiki.eqemulator.org/p?Diablo_...ster_Reference im sorry but could someone please explain this one to me a little better ? how do i use it where do i put it ?
I don't know how the page doesn't explain it better, both the questions you just answered are clearly in the page:

"Run the script in your server directory as 'DiabloLoot.pl'"

"Example of how you run the script: perl DiabloLoot.pl all - does a complete cycle of the script, deletes old entries and creates all new - You should probably just run this option if you don't know what you're doing"

And I go into the detail of the pre-requisites on the page.

?
Reply With Quote
  #3  
Old 08-06-2014, 07:11 PM
Xenerox's Avatar
Xenerox
Hill Giant
 
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
Default

its just it says open it just opens a black screen and closes idk what im doing incorrectly
Reply With Quote
  #4  
Old 08-06-2014, 07:22 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Ah, I see your issue, you open this with the command prompt. You can run them from the command prompt. So suppose you had the file in C:\EQ\Scripts you would open the command prompt, type cd C:\EQ\Scripts then hit enter then type perl DiabloLoot.pl all.
Reply With Quote
  #5  
Old 08-06-2014, 07:34 PM
Xenerox's Avatar
Xenerox
Hill Giant
 
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
Default

okay i tried its not connecting for some odd reason so i download the georges tools diablo tool and it keeps giving me runtime errors after installing the ODBC drivers
Reply With Quote
  #6  
Old 08-06-2014, 07:45 PM
Xenerox's Avatar
Xenerox
Hill Giant
 
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
Default

C:\PEQ RIP\EQ\EQEmuServer>DiabloLoot.pl all
DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'lo
alhost' (using password: NO) at C:\PEQ RIP\EQ\EQEmuServer\DiabloLoot.pl line 35
DBI connect(':localhost:3306','',...) failed: Access denied for user 'ODBC'@'lo
alhost' (using password: NO) at C:\PEQ RIP\EQ\EQEmuServer\DiabloLoot.pl line 36
Can't call method "prepare" on an undefined value at C:\PEQ RIP\EQ\EQEmuServer\
iabloLoot.pl line 54.
Loading Loot Definitions...
C:\PEQ RIP\EQ\EQEmuServer>
Reply With Quote
  #7  
Old 08-06-2014, 08:04 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

It's not getting a valid database connection.

It uses your database credentials from eqemu_config.xml, if that is not correct then the script is going to have trouble making a successful connection to your database.
Reply With Quote
  #8  
Old 08-06-2014, 08:50 PM
Xenerox's Avatar
Xenerox
Hill Giant
 
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
Default

idk i tried everything
Reply With Quote
  #9  
Old 08-25-2014, 04:27 AM
Mill3nia
Fire Beetle
 
Join Date: Apr 2007
Posts: 13
Default

also having the same issues, perhaps we're not completely understanding how to run it. my config file is fine, when I try to run the script I get no database is selected error
Reply With Quote
  #10  
Old 08-25-2014, 12:10 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Mill3nia View Post
also having the same issues, perhaps we're not completely understanding how to run it. my config file is fine, when I try to run the script I get no database is selected error
Can you post a screenshot or something else?
Reply With Quote
  #11  
Old 08-25-2014, 01:44 PM
Mill3nia
Fire Beetle
 
Join Date: Apr 2007
Posts: 13
Default

here is a screenshot of what happens when I try to load it http://imgur.com/UCwTyLG
any help getting this running would be awesome, been wanting to run another random loot drop server, the old diablo loot tool I used no longer works, this seems to be the only option I have left. thanks in advance!
Reply With Quote
  #12  
Old 08-25-2014, 02:26 PM
Akkadius's Avatar
Akkadius
Administrator
 
Join Date: Feb 2009
Location: MN
Posts: 2,071
Default

Quote:
Originally Posted by Mill3nia View Post
here is a screenshot of what happens when I try to load it http://imgur.com/UCwTyLG
any help getting this running would be awesome, been wanting to run another random loot drop server, the old diablo loot tool I used no longer works, this seems to be the only option I have left. thanks in advance!
Need to make sure that your database configuration in your eqemu_config.xml is valid and that you can actually connect to your DB using it.
Reply With Quote
  #13  
Old 08-25-2014, 02:40 PM
Mill3nia
Fire Beetle
 
Join Date: Apr 2007
Posts: 13
Default

yeah the configuration is fine, I'm able to run the server, connect, and play no problems. perhaps the format is wrong of my configuration?
and if I turn off mysql, I receive a Cannot Connect error in place of what I posted previously.
Code:
<?xml version="1.0"?>
<server>
	<world>
		<shortname>Roxor</shortname>
		<longname>Roxor</longname>

		<!-- Only specify these two if you really think you need to.  (read: You don't) -->
		<!-- <address>some.server.com</address> -->
		<!-- <localaddress>24.247.126.26</localaddress> -->

		<!-- Loginserver information.  Defaults shown -->
		<loginserver>
			<host>login.eqemulator.net</host>
			<port>5998</port>
			<account></account>
			<password></password>
		</loginserver>

		<!-- Server status.  Default is unlocked -->
		<!--<locked/>-->
		<!-- <unlocked/> -->

		<!-- Sets the ip/port for the tcp connections.  Both zones and console (if enabled).  Defaults are shown -->
		<tcp ip="127.0.0.1" port="9000" telnet="disable"/>

		<!-- Sets the shared key used by zone/launcher to connect to world -->
		<key>some long random string</key>

		<!-- Enable and set the port for the HTTP service.  Defaults are shown -->
		<http port="9080" enabled="false" mimefile="mime.types" />
	</world>

	<!-- Chatserver (channels) information.  Defaults shown -->
	<chatserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</chatserver>

	<!-- Mailserver (in-game mail) information.  Defaults shown -->
	<mailserver>
		<host>channels.eqemulator.net</host>
		<port>7778</port>
	</mailserver>

	<zones>
		<defaultstatus>20</defaultstatus>

		<!-- Sets port range for world to use to auto configure zones -->
		<ports low="7000" high="7100"/>
	</zones>

	<!-- Database configuration, replaces db.ini.  Defaults shown -->
	<database>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>PASSWORD</password>
		<db>peq</db>
	</database>

	<qsdatabase>
		<host>127.0.0.1</host>
		<port>3306</port>
		<username>root</username>
		<password>PASSWORD</password>
		<db>peq</db>
	</qsdatabase>

	<!-- Launcher Configuration -->
	<launcher>
		<!-- <logprefix>logs/zone-</logprefix> -->
		<!-- <logsuffix>.log</logsuffix> -->
		<!-- <exe>zone.exe or ./zone</exe> -->
		<!-- <timers restart="10000" reterminate="10000"> -->
	</launcher>

	<!-- File locations.  Defaults shown -->
	<files>
		<!-- <spells>spells_us.txt</spells> -->
		<!-- <opcodes>opcodes.conf</opcodes> -->
		<!-- <logsettings>log.ini</logsettings> -->
		<!-- <eqtime>eqtime.cfg</eqtime> -->
	</files>
	<!-- Directory locations.  Defaults shown -->
	<directories>
		<!-- <maps>Maps</maps> -->
		<!-- <quests>quests</quests> -->
		<!-- <plugins>plugins</plugins> -->
	</directories>
</server>
Reply With Quote
  #14  
Old 08-26-2014, 11:17 AM
Mill3nia
Fire Beetle
 
Join Date: Apr 2007
Posts: 13
Default

any possibly answers? really looking forward to using this =\

looks like the code to go in and read config is wonky, seems to work by bypassing it.
Reply With Quote
  #15  
Old 08-26-2014, 02:41 PM
wolfwalkereci
Discordant
 
Join Date: Dec 2005
Posts: 435
Default

Ok random question, do you have the correct modules installed?
__________________

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 10:45 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