Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page random loot generator (not understanding)

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

Reply
 
Thread Tools Display Modes
  #1  
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
  #2  
Old 08-25-2014, 02:26 PM
Akkadius's Avatar
Akkadius
Administrator
  
Join Date: Feb 2009
Location: MN
Posts: 2,072
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
  #3  
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
  #4  
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
  #5  
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
  #6  
Old 08-26-2014, 09:49 PM
Akkadius's Avatar
Akkadius
Administrator
  
Join Date: Feb 2009
Location: MN
Posts: 2,072
Default
Quote:
Originally Posted by Mill3nia View Post
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.
The code works just fine, I used it for years.

Make sure you have DBI installed correctly.

http://wiki.eqemulator.org/p?Install...ster_Reference
Reply With Quote
  #7  
Old 08-29-2014, 02:38 AM
pennywse's Avatar
pennywse
Fire Beetle
  
Join Date: Sep 2012
Posts: 9
Default I am having the same issue.
I am having the same issue.. I have went over the instructions at least 30 times and checked to make sure I did everything right. Still get the following error. I can start my server up, and log in and play so I know my eqemu_config settings are okay (at least I hope).

Code:
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 133.
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>
Reply With Quote
  #8  
Old 08-30-2014, 02:36 AM
pennywse's Avatar
pennywse
Fire Beetle
  
Join Date: Sep 2012
Posts: 9
Default I came up with a solution.
I came up with a solution and it might help others that are having the same problem. Change the mysql values to your own and it should execute properly.

Code:
###########################################################
#::: Akka's Diablo Loot
#::: This script is designed to generate thousands of lootdrop entries to be dynamically assigned on top of an NPC's original loot.
#::: This script is ran pre-server-up once, or as many times as you wish until you feel like you have your loot the way you want it.
#::: This script has been designed to be ran as many times as you wish as it will purge all of the created entries each time you run it, only to create loads of new entries based on the new criteria that you have fed it.
#::: All criteria that this script uses is strictly specified in the table `cust_npc_loot_scale` that is shown below
#::: Example: perl DiabloLoot.pl
###########################################################
 
if(!$ARGV[0]) { print "Usage create - creates entries, delete - deletes entries, all - does a complete cycle"; }
else{
    use DBI;
    use DBD::mysql;
    my $start_run = time();
 
    my $Debug = 1;
     
    # CONFIG VARIABLES - Parsed from eqemu_config.xml
    my $confile = "eqemu_config.xml"; #default
    open(F, "<$confile") or die "Unable to open config: $confile\n";
    my $indb = 0;
    while(<f>) {
        s/\r//g;
        if(/<database>/i) { $indb = 1; }
        next unless($indb == 1);
        if(/<\/database>/i) { $indb = 0; last; }
        if(/<host>(.*)<\/host>/i) { $host = $1; }
        elsif(/<username>(.*)<\/username>/i) { $user = $1; }
        elsif(/<password>(.*)<\/password>/i) { $pass = $1; }
        elsif(/<db>(.*)<\/db>/i) { $db = $1; }
    }
    
      # CHANGE THESE VALUES 
	$db=your_db;
	$user=your_username;
	$pass=your_password;
	
    # PERL DBI CONNECT
    $dsn = "dbi:mysql:$db:localhost:3306";
    if(!$connect){ $connect = DBI->connect($dsn, $user, $pass); }
    if(!$connect2){ $connect2 = DBI->connect($dsn, $user, $pass); }
    #####################################################
 
    $n = 0;
    while($ARGV[$n]){ if($ARGV[$n] eq "debug"){ $Debug = " " ; } else{ $Debug = ""; } $n++; }
 
    #::: Script Options :::#
    $MaxLevel = 110;
    $BaseLoottableID = 200000;
    $BaseLoottableIDAugs = 210000;
    $TypeMultiplier = 1000;
    $GenName = "Akkas_Diablo_Loot";
    $GenNameAugs = "Akkas_Diablo_Loot_Augs";
 
    ####################
     
    ###  Load Loot Definitions into Memory so it can be quickly iterated through
    print "Loading Loot Definitions...";
    $query_handle = $connect->prepare("SELECT level, type, hp_min, hp_max, drop_chance, loottable_multiplier, min_plat, max_plat, aug_hp_min, aug_hp_max, aug_ac_max, aug_drop_chance, aug_drop_multiplier FROM `cust_npc_loot_scale` ORDER BY `type`, `level`"); $query_handle->execute();
    while(@row = $query_handle->fetchrow_array()){ $LootDefs[$row[0]][$row[1]] = [@row]; }
    print " Done\n\n";
     
    if($ARGV[0] eq "delete" || $ARGV[0] eq "all"){
        for($i = 0; $i <= 1; $i++){
            if($i == 0){ $ID = $BaseLoottableID; $LT = "'General Loot'"; }
            elsif($i == 1) { $ID = $BaseLoottableIDAugs; $LT = "'Aug Loot'"; }
            print "Creating Loot Table ID's\n" if $Debug;
            $query = "DELETE FROM `lootdrop_entries` WHERE `lootdrop_id` >= " . $ID . " AND `lootdrop_id` <= " . ($ID + 3000) . ";"; 
            $query_handle = $connect->prepare($query);
            my $row = $query_handle->execute(); if($row eq "0E0"){ $row = 0; }
            print "Purging Diablo lootdrop_entries... " . $LT . " rows affected ". $row . "\n";
             
            $query = "DELETE FROM `lootdrop` WHERE `id` >= " . $ID . " AND `id` <= " . ($ID + 3000) . ";";   
            $query_handle = $connect->prepare($query);
            my $row = $query_handle->execute(); if($row eq "0E0"){ $row = 0; }
            print "Purging Diablo lootdrop... " . $LT . " rows affected ". $row . "\n";
             
            $query = "DELETE FROM `loottable_entries` WHERE `lootdrop_id` >= " . $ID . " AND `lootdrop_id` <= " . ($ID + 3000) . ";";
            $query_handle = $connect->prepare($query);
            my $row = $query_handle->execute(); if($row eq "0E0"){ $row = 0; }
            print "Purging Diablo loottable_entries... " . $LT . " rows affected ". $row . "\n";
             
            $query = "DELETE FROM `loottable` WHERE `id` >= " . $ID . " AND `id` <= " . ($ID + 3000) . ";";  
            $query_handle = $connect->prepare($query);
            my $row = $query_handle->execute(); if($row eq "0E0"){ $row = 0; }
            print "Purging Diablo loottable... " . $LT . " rows affected ". $row . "\n";
             
        }
        if($ARGV[0] eq "delete"){ return; }
    }
 
    if($ARGV[0] eq "create" || $ARGV[0] eq "all"){
        print "Creating Loot Table ID's\n" if $Debug;
        for($t = 0; $t <= 2; $t++){
            for($i = 1; $i < $MaxLevel; $i++){
             
                ### Create General Loot Tables ###
                $ID = ($BaseLoottableID + ($TypeMultiplier * $t) + $i);
                $query_handle = $connect->prepare("REPLACE INTO `loottable` (id, name, mincash, maxcash, avgcoin) VALUES (?, ?, ?, ?, ?)");
                $query_handle->execute($ID, $ID . "_" . $GenName, ($LootDefs[$i][$t][6] * 1000),($LootDefs[$i][$t][7] * 1000), 0);
                $query_handle = $connect->prepare("REPLACE INTO `lootdrop` (id, name) VALUES (?, ?)");
                $query_handle->execute($ID, $ID . "_" . $GenName);
                $query_handle = $connect->prepare("REPLACE INTO `loottable_entries` (loottable_id, lootdrop_id, multiplier, droplimit, mindrop, probability) VALUES (?, ?, ?, ?, ?, ?)");
                $query_handle->execute($ID, $ID, $LootDefs[$i][$t][5], 1, 0, 100);
                #sprint $LootDefs[$i][$t][5] . "\n";
                 
                ### Create Augment Tables ###
                $ID = ($BaseLoottableIDAugs + ($TypeMultiplier * $t) + $i);
                $query_handle = $connect->prepare("REPLACE INTO `loottable` (id, name, mincash, maxcash, avgcoin) VALUES (?, ?, ?, ?, ?)");
                $query_handle->execute($ID, $ID . "_" . $GenNameAugs, 0, 0, 0);
                $query_handle = $connect->prepare("REPLACE INTO `lootdrop` (id, name) VALUES (?, ?)");
                $query_handle->execute($ID, $ID . "_" . $GenNameAugs);
                $query_handle = $connect->prepare("REPLACE INTO `loottable_entries` (loottable_id, lootdrop_id, multiplier, droplimit, mindrop, probability) VALUES (?, ?, ?, ?, ?, ?)");
                $query_handle->execute($ID, $ID, $LootDefs[$i][$t][12], 1, 0, 100);
            }
        }
        if($ARGV[0] eq "create"){ return; }
    }
     
    $query_handle = $connect->prepare("SELECT
        items.id,
        items.minstatus,
        items.`Name`,
        items.augtype,
        items.hp,
        items.mana,
        items.ac,
        items.price,
        items.reclevel,
        items.reqlevel,
        items.itemtype
        FROM
        items
        WHERE hp > 0
        AND augtype = 0
        AND minstatus = 0
        AND hp > " . $LootDefs[1][0][3] . "
        ORDER by hp"); $query_handle->execute();
    print "Generating General Loot... Please wait...\n";
     
    $n = 0;
    while(@row = $query_handle->fetchrow_array()){
        my ($id, $MinStatus, $Name, $AugType, $hp, $mana, $ac, $price, $reclevel, $reqlevel, $itemtype) = ($row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8],  $row[9], $row[10]);
        print "Loop: $n HP: " . $row[4] . " ID: " .  $row[0] . " NAME: " . $row[2] . " "  . "\n" if $Debug;
         
        $TypeCycle = 0;
        while($TypeCycle <= 2){
            $InRange = 0;
            $LevIter = 1;
            while($LevIter < 250){
                $Mult = 1;
                if($itemtype == 1 || $itemtype == 4 || $itemtype == 35){ $Mult = 1.79 } ### We use a multiplier for 2 handed weapons...
                $HPMIN = $LootDefs[$LevIter][$TypeCycle][2] * $Mult;
                $HPMAX = $LootDefs[$LevIter][$TypeCycle][3] * $Mult;
                if($hp > $HPMIN && $hp < $HPMAX){
                    print "(($BaseLoottableID + ($TypeMultiplier * $TypeCycle)) + $LevIter);\n" if $Debug;
                    $ID = (($BaseLoottableID + ($TypeMultiplier * $TypeCycle)) + $LevIter);
                    if($TypeCycle == 1){ print "INSERTING REG - ITEM ID: " . $id . " HP " . $hp . " "  . $ID . " LVL " . $LevIter . " Type " . $TypeCycle . "\n" if $Debug; }
                    $query_handle2 = $connect2->prepare("INSERT INTO `lootdrop_entries` (lootdrop_id, item_id, item_charges, equip_item, chance, minlevel, maxlevel, multiplier) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
                    $query_handle2->execute($ID, $id, 1, 1, $LootDefs[$LevIter][$TypeCycle][4], 0, 250, 1);
                    $InRange = 1;
                }
                elsif($InRange == 1){ last; }
                $LevIter++;
            }
            #if($TypeCycle > 0){ print $TypeCycle . "\n"; }
            $TypeCycle++;
        }
        $n++;
    }
     
    print "Items Processed: " . $n . "\n";
     
    ### Process Augment Items ###
    $query_handle = $connect->prepare("SELECT
        items.id,
        items.minstatus,
        items.`Name`,
        items.augtype,
        items.hp,
        items.mana,
        items.ac,
        items.price,
        items.reclevel,
        items.reqlevel
        FROM
        items
        WHERE hp > 0
        AND augtype > 0
        AND minstatus = 0
        ORDER by hp"); $query_handle->execute();
    print "Generating Augments Loot... Please wait...\n";
     
    while(@row = $query_handle->fetchrow_array()){
        my ($id, $MinStatus, $Name, $AugType, $hp, $mana, $ac, $price, $reclevel, $reqlevel) = ($row[0], $row[1], $row[2], $row[3], $row[4], $row[5], $row[6], $row[7], $row[8],  $row[9]);
        print "Loop: $n HP: " . $row[4] . " ID: " .  $row[0] . " NAME: " . $row[2] . " "  . "\n" if $Debug;
        $TypeCycle = 0;
        while($TypeCycle <= 2){
            $InRange = 0;
            $LevIter = 1;
            while($LevIter < 250){
                ### Make sure the definitions fall within the stat ranges specified
                if($hp > $LootDefs[$LevIter][$TypeCycle][8] && $hp < $LootDefs[$LevIter][$TypeCycle][9]){
                    $ID = (($BaseLoottableIDAugs + ($TypeMultiplier * $TypeCycle)) + $LevIter);
                    $query_handle2 = $connect2->prepare("INSERT INTO `lootdrop_entries` (lootdrop_id, item_id, item_charges, equip_item, chance, minlevel, maxlevel, multiplier) VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
                    $query_handle2->execute($ID, $id, 1, 1, $LootDefs[$LevIter][$TypeCycle][11], 0, 250, 1);
                    $InRange = 1;
                }
                elsif($InRange == 1){ last; }
                $LevIter++;
            }
            #if($TypeCycle > 0){ print $TypeCycle . "\n"; }
            $TypeCycle++;
        }
        $n++;
    }
 
    print "\n Loot has been successfully generated\n";
    print "Items Processed: " . $n . "\n";
     
    my $end_run = time();
    my $run_time = $end_run - $start_run;
    print "\n\nJob took $run_time seconds\n";
 
}
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

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 01:16 PM.

EQEmulator - Archive - Top

 

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 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3