random loot generator (not understanding)

[Xenerox]

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 ?

[Akkadius]

Originally Posted by Xenerox

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.

?

[Xenerox]

its just it says open it just opens a black screen and closes idk what im doing incorrectly

[Kingly_Krab]

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.

[Xenerox]

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

[Xenerox]

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>

[Akkadius]

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.

[Xenerox]

idk i tried everything

[Mill3nia]

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

[Akkadius]

Originally Posted by Mill3nia

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?

[Mill3nia]

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!

[Akkadius]

Originally Posted by Mill3nia

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.

[Mill3nia]

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.

<?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>

[Mill3nia]

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.

[wolfwalkereci]

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