|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::Windows Servers Support forum for Windows EQEMu users. |
08-06-2014, 06:08 PM
|
|
Hill Giant
|
|
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
|
|
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 ?
|
08-06-2014, 06:21 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
Originally Posted by Xenerox
|
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.
?
|
08-06-2014, 07:11 PM
|
|
Hill Giant
|
|
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
|
|
its just it says open it just opens a black screen and closes idk what im doing incorrectly
|
08-06-2014, 07:22 PM
|
Administrator
|
|
Join Date: May 2013
Location: United States
Posts: 1,589
|
|
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.
|
08-06-2014, 07:34 PM
|
|
Hill Giant
|
|
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
|
|
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
|
08-06-2014, 07:45 PM
|
|
Hill Giant
|
|
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
|
|
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>
|
08-06-2014, 08:04 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
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.
|
08-06-2014, 08:50 PM
|
|
Hill Giant
|
|
Join Date: Aug 2009
Location: Shelby Twp, MI
Posts: 114
|
|
idk i tried everything
|
08-25-2014, 04:27 AM
|
Fire Beetle
|
|
Join Date: Apr 2007
Posts: 13
|
|
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
|
08-25-2014, 12:10 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
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?
|
08-25-2014, 01:44 PM
|
Fire Beetle
|
|
Join Date: Apr 2007
Posts: 13
|
|
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!
|
08-25-2014, 02:26 PM
|
|
Administrator
|
|
Join Date: Feb 2009
Location: MN
Posts: 2,071
|
|
Quote:
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.
|
|
|
|
08-25-2014, 02:40 PM
|
Fire Beetle
|
|
Join Date: Apr 2007
Posts: 13
|
|
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>
|
|
|
|
08-26-2014, 11:17 AM
|
Fire Beetle
|
|
Join Date: Apr 2007
Posts: 13
|
|
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.
|
08-26-2014, 02:41 PM
|
Discordant
|
|
Join Date: Dec 2005
Posts: 435
|
|
Ok random question, do you have the correct modules installed?
__________________
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 12:24 PM.
|
|
|
|
|
|
|
|
|
|
|
|
|