EQEmulator Forums - Upgrading old Underfoot Server

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Upgrading old Underfoot Server (https://www.eqemulator.org/forums/showthread.php?t=40359)

Upgrading old Underfoot Server

Hello,

I have been hosing a underfoot client server with level cap 85 since about 2011/2012. I would like to get the latest and greatest. Is it Rain of Fear? I am trying to locate an upgrade path so I can use RoF or better. I think I have the correct client downloaded. How would I upgrade the server and DB? Again, it's been a while so I am trying to locate the proper threads.

Unless creating a new server would be better?

Thanks

From what i understand, you can add the OPCodes via eqemu_update.pl

That loads supports for other clients

His code base may be old enough that it doesn't have support for RoF/2.

The more recent code has the clients registered and adding/removing opcode conf files will work in those scenarios.

So for future reference to those who are using outdated source code, would be to reload the source and load the new opcodes?

Are there any conflict if you simply reload the opcodes with an outdated server code?

Probably wouldn't be a conflict..but, any additional opcodes (features) in the conf file wouldn't be handled by the server.

Vice-verse for old conf files and newer source code.

As a rule, I always make sure that all of my stuff is up-to-date..but, I generally develop on the same server that I play solo on.

Thanks for the replies. It sounds like I might need to build semi fresh. I just don't want to overwrite the config file that allows people to connect to me without hosting on eqemu servers.

Now to recall how to make the install/upgrade...

What does the /2 mean in "RoF/2" ?? I have the RoF steam client download from December 19 2014.

I truncated the descript..I just mean "RoF" or "RoF2"

That build date doesn't look familiar.

Try connecting that client to you current server (it will fail..), then going into the client's log folder and open the dbg.txt and post that date, if you would :)

I was able to get to server select but no further using the below RoF client on UF server. Is this client build compatable with the latest DB for RoF?

Quote:

[Thu Jan 28 15:12:45 2016]00000:Starting EverQuest (Built May 10 2013 23:30:08)
[Thu Jan 28 15:12:45 2016]00001:EverQuest Configuration Type: RELEASE_NON_AVATAR
[Thu Jan 28 15:12:45 2016]00002:Timezone: UTC-5h00m
[Thu Jan 28 15:12:45 2016]00003:Loading graphics DLL.
[Thu Jan 28 15:12:45 2016]00004:Parsing INI file .\defaults.ini
[Thu Jan 28 15:12:45 2016]00005:INI file .\defaults.ini loaded.
[Thu Jan 28 15:12:45 2016]00006:Parsing INI file .\eqclient.ini
[Thu Jan 28 15:12:45 2016]00007:INI file .\eqclient.ini loaded.

[Thu Jan 28 15:13:39 2016]00039:INI file .\defaults.ini loaded.
[Thu Jan 28 15:13:39 2016]00040:Memory mode defaulted to Balanced
[Thu Jan 28 15:13:39 2016]00041:Networking: using port [55826].
[Thu Jan 28 15:13:39 2016]00042:Networking: Connection Established [1]
[Thu Jan 28 15:13:39 2016]00043:WorldAuthenticate: Initiating Login.

That build date is the ROF2 client that was on steam and should work with the latest compile/db

Thanks for verifying. My server is running the PEQ DB on SQL on Win2008 Ent x64.

Do you think there wpuld be any issues just updating the SQL DB to the latest OPcodes, Maps, Quests, Etc DB?

Or do you recommend I just startup fresh instance?

I am not concerned with any customization i did with george's tools on this server.

I don't think the code-base will compile on that server any longer.

Pretty sure the min VS is 2012 now and that requires Win7.

I haven't done it..but, you may still be able to 'target' your os version and build on a newer system.

Going to try a source DB upgrade first. I have been searching the forums but cannot find the opcodes for ROF/2

Running eqemu_update.pl manually should give you the options to update most of 'updateable' requirements.

Thanks,
I have SVN updated folders already but DB sourcing is taking a while to source in the SQL DB. The version I had before this was peqdatabase-Rev2294. latest opcodes.conf file is from 2012.

I do not have a eqemu_update.pl file

https://github.com/EQEmu/Server/blob...qemu_update.pl

But (BUT,) you will need to have a recent binary to execute the db update portion - world.exe is called to determine the required db_version.

Not sure if it will actually run without the updated world binary..but, if so, you can at least get the other stuff updated.

Wow, you guys have been busy since I first built the server 5ish years ago. I am very impressed by the update script. Going through and updating everything. I'll let you know how it turns out.

Thanks, greatly apretiated. I will have to get back to scripting to contribute back to the group.

Just went through all the updates on the updater and looks good in the eqemu file directory. I now just need to update the .sql tables. Note to self- don't use navicat for executing the queries (IE: peqbeta_2015-08-12-02_01.sql), takes too long...

Oh, and would there need to be any updates to the server start batch file:

Code:

@echo off

Echo Starting EQEmuLoginServer

c:

cd C:\eqemu

start eqemuloginserver.exe

echo

echo



cd C:\eqemu

start world.exe

echo waiting a bit for world to finish loading...

echo.

echo.

ping -n 10 127.0.0.1 > nul



echo starting zone

start eqlaunch.exe zone

exit

What does magelo.sql do for me?

Delete. re-run worked if anyone already read this post

ok everything is updated but now having connection / start issues. I did not change eqemu_config or the eqemuloginserver.exe from before when it did work successfully with the client.

When trying to login I am getting that the eqemuloginserver stopped working. after that world.exe stays up but then eqlaunch.exe is just hanging there.

Looking at the logs it doesn't look like a good connection is being made with the DB? again - using older eqemuloginserver

Below is the login server logs:

Code:

[Debug] [01.29.16 - 03:55:39] Logging System Init.

[Debug] [01.29.16 - 03:55:39] Config System Init.

[Debug] [01.29.16 - 03:55:39] MySQL Database Init.

[Database] [01.29.16 - 03:55:40] Failed to connect to MySQL database.

[Debug] [01.29.16 - 03:55:40] Encryption Initialize.

[Debug] [01.29.16 - 03:55:40] Encryption Loaded Successfully.

[Debug] [01.29.16 - 03:55:40] Server Manager Initialize.

[Network] [01.29.16 - 03:55:40] ServerManager listening on port 5999

[Debug] [01.29.16 - 03:55:40] Client Manager Initialize.

[Network] [01.29.16 - 03:55:40] ClientManager listening on Titanium stream.

[Network] [01.29.16 - 03:55:40] ClientManager listening on SoD stream.

[Debug] [01.29.16 - 03:55:40] Server Started.

[Network] [01.29.16 - 03:57:02] New SoD client connection from 192.168.1.162:51280

[Network] [01.29.16 - 03:57:02] Application packet recieved from client (size 14)

[Network] [01.29.16 - 03:57:02] Session ready recieved from client.

[Network] [01.29.16 - 03:57:02] Application packet recieved from client (size 28)

[Network] [01.29.16 - 03:57:02] Login recieved from client.

[Client] [01.29.16 - 03:57:02] User: ken1

[Client] [01.29.16 - 03:57:02] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00

Wondering if i need to rebuild the login server? I have a seperate DB for the peqlogindb

I noticed the logs are saying SoD connection but im using RoF/2 client..

--
I tried cutting out the old files and running the eqemu_update option 13 for loginserver but it is not pulling in a new eqemu_config.xml

So I tried just updating the login.ini file and was able to login but since no eqemu_config.xml I was not able to see the server... but It looks like it created a user account... but the user account was already in the the old peglogindb. I hope I will not lose all the login accounts?

Code:

[Login Server] Logging System Init.

[Login Server] Config System Init.

[Login Server] MySQL Database Init.

[Login Server] Encryption Initialize.

[Login Server] Encryption Loaded Successfully.

[Login Server] Server Manager Initialize.

[Login Server] ServerManager listening on port 5999

[Login Server] Client Manager Initialize.

[Login Server] ClientManager listening on Titanium stream.

[Login Server] ClientManager listening on SoD stream.

[Login Server] Server Started.

[Login Server] New SoD client connection from 192.168.1.162:50046

[Login Server] Application packet received from client (size 14)

[Login Server] Session ready received from client.

[Login Server] Application packet received from client (size 28)

[Login Server] Login received from client.

[Error] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM logins

r_accounts WHERE AccountName = 'ken1'

[Error] User ken1 does not exist in the database, so we created it...

[Login Server] Application packet received from client (size 12)

[Login Server] Server list request received from client.

[Login Server] Client disconnected from the server, removing client.

EQ Launch remains a black screen. There is something wrong with the login server and it pointing to the correct login DB and seeing the server...

Code:

[Debug] [01.29.16 - 04:20:26] Logging System Init.

[Debug] [01.29.16 - 04:20:26] Config System Init.

[Debug] [01.29.16 - 04:20:26] MySQL Database Init.

[Debug] [01.29.16 - 04:20:26] Encryption Initialize.

[Debug] [01.29.16 - 04:20:26] Encryption Loaded Successfully.

[Debug] [01.29.16 - 04:20:26] Server Manager Initialize.

[Network] [01.29.16 - 04:20:26] ServerManager listening on port 5999

[Debug] [01.29.16 - 04:20:26] Client Manager Initialize.

[Network] [01.29.16 - 04:20:26] ClientManager listening on Titanium stream.

[Network] [01.29.16 - 04:20:26] ClientManager listening on SoD stream.

[Debug] [01.29.16 - 04:20:26] Server Started.

[Network] [01.29.16 - 04:20:35] New world server connection from 192.168.1.131:50181

[Database] [01.29.16 - 04:20:35] Mysql query returned no result: SELECT WSR.ServerID, WSR.ServerTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeDescription, WSR.ServerAdminID FROM loginserver_world_server_registration AS WSR JOIN loginserver_server_list_type AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.ServerLongName = 'The Everquest Afterlife, Dragons of Doom' AND WSR.ServerShortName = 'eqafdod'

[World] [01.29.16 - 04:20:35] Server The Everquest Afterlife, Dragons of Doom(eqafdod) attempted to log in but database couldn't find an entry but unregistered servers are allowed.

[Network] [01.29.16 - 04:21:37] New SoD client connection from 192.168.1.162:61960

[Network] [01.29.16 - 04:21:37] Application packet recieved from client (size 14)

[Network] [01.29.16 - 04:21:37] Session ready recieved from client.

[Network] [01.29.16 - 04:21:37] Application packet recieved from client (size 28)

[Network] [01.29.16 - 04:21:37] Login recieved from client.

[Client] [01.29.16 - 04:21:37] User: ken2

[Client] [01.29.16 - 04:21:37] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00

[Database] [01.29.16 - 04:21:37] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'ken2'

[Client Error] [01.29.16 - 04:21:37] Error logging in, user ken2 does not exist in the database.

[Network] [01.29.16 - 04:21:45] Client disconnected from the server, removing client.

[Network] [01.29.16 - 04:21:45] New SoD client connection from 192.168.1.162:61961

[Network] [01.29.16 - 04:21:45] Application packet recieved from client (size 14)

[Network] [01.29.16 - 04:21:45] Session ready recieved from client.

[Network] [01.29.16 - 04:21:45] Application packet recieved from client (size 28)

[Network] [01.29.16 - 04:21:45] Login recieved from client.

[Client] [01.29.16 - 04:21:45] User: ken3

[Client] [01.29.16 - 04:21:45] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00

[Database] [01.29.16 - 04:21:45] Mysql query returned no result: SELECT LoginServerID, AccountPassword FROM loginserver_server_accounts WHERE AccountName = 'ken3'

[Client Error] [01.29.16 - 04:21:45] Error logging in, user ken3 does not exist in the database.

[Network] [01.29.16 - 04:21:53] Client disconnected from the server, removing client.

[Network] [01.29.16 - 04:21:53] New SoD client connection from 192.168.1.162:61962

[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 14)

[Network] [01.29.16 - 04:21:53] Session ready recieved from client.

[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 28)

[Network] [01.29.16 - 04:21:53] Login recieved from client.

[Client] [01.29.16 - 04:21:53] User: ken1

[Client] [01.29.16 - 04:21:53] Hash: 6e62fb32466ad6458d1003c6295db87018b32a00

[Network] [01.29.16 - 04:21:53] Application packet recieved from client (size 12)

[Network] [01.29.16 - 04:21:53] Server list request recieved from client.

[Network] [01.29.16 - 04:21:58] Client disconnected from the server, removing client.

[Network] [01.29.16 - 04:22:04] World server disconnected from the server, removing server and freeing connection.

from world.exe:

Code:

[World Server] Loading server configuration..

[World Server] CURRENT_VERSION: 1.1.3

[World Server] Added loginserver ucdataeq01:5999

[World Server] Connecting to MySQL...

[World Server] HTTP world service disabled.

[World Server] Checking Database Conversions..

[Upgrade Script] No script update necessary

Perl Version is 5.12.4

============================================================

           EQEmu: Automatic Upgrade Check

============================================================

        (Windows) MySQL is in system path

        Path = C:\mysql\bin/mysql

============================================================

        Binary Revision / Local: (9091 / 1000)

You have missing database updates, type 1 or 2 to backup your database before running them as recomm

ended...



============================================================

#::: EQEmu Update Utility Menu: (eqemu_update.pl)

============================================================

 1) [Backup Database] :: (Saves to Backups folder)

 2) [Backup Database Compressed] :: (Saves to Backups folder)

 3) [EQEmu DB Schema] :: Check and stage pending REQUIRED Database updates

 4) [EQEmu DB Bots Schema] Check for Bot REQUIRED database updates... (Must have bots enabled)

 5) [OPCodes] :: Download latest opcodes for each EQ Client

 6) [Maps] :: Download latest map and water files

 7) [Plugins (Perl)] :: Download latest Perl plugins

 8) [Quests (Perl/LUA)] :: Download latest PEQ quests and stage updates

 9) [LUA Modules] :: Download latest LUA Modules (Required for Lua)

 10) [DB Data : Alternate Advancement] :: Download Latest AA's from PEQ (This overwrites existing da

ta)

 11) [Windows Server Build] :: Download Latest and Stable Server Build (Overwrites existing .exe's,

includes .dll's)

 12) [Windows Server .dll's] :: Download Pre-Requisite Server .dll's

 13) [Windows Server Loginserver Setup] :: Download and install Windows Loginserver

 14) [Remove Duplicate Rule Values] :: Looks for redundant rule_values entries and removes them

 19) [EQEmu DB Drop Bots Schema] :: Remove Bots schema and return database to normal state

 20) [Update the updater] Force update this script (Redownload)

 0) Exit



 Enter numbered option and press enter...



> 0

[World Server] Loading variables..

[World Server] Loading zones..

[World Server] Clearing groups..

[World Server] Clearing raids..

[World Server] Clearing inventory snapshots..

[World Server] Loading items..

[World Server] Error: Could not load item data. But ignoring

[World Server] Loading skill caps..

[World Server] Error: Could not load skill cap data. But ignoring

[World Server] Loading guilds..

[World Server] Loaded default rule set 'default'

[World Server] Loading EQ time of day..

[World Server] Loading launcher list..

[World Server] Reboot zone modes OFF

[World Server] Deleted 0 stale player corpses from database

[World Server] Loading adventures...

[World Server] Purging expired instances

[World Server] Loading char create info...

[World Server] Zone (TCP) listener started.

[World Server] Client (UDP) listener started.

[World Server] New TCP connection from 127.0.0.1:50197

Something is preventing the login server and server db from linking... or eqlaunch.exe from running... unless I have a bad start .bat file. ?

eqemu_config.xml - Only working with old eqemuloginserver.exe. This is what worked with underfoot build with no issues...

Code:

<?xml version="1.0">

<server>

        <world>

                <shortname>eqafdod</shortname>

                <longname>The Everquest Afterlife, Dragons of Doom</longname>



                <!-- Only specify these two if you really think you need to.  (read: You don't) -->

                <address>xxxxxxxxx</address>

                <localaddress>192.168.1.131</localaddress>



                <!-- Loginserver information.  Defaults shown -->

                <loginserver>

                        <host>xxxxxxxxxx</host>

                        <port>5999</port>

                        <account>Admin</account>

                        <password>xxxxxxx</password>

                </loginserver>



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



                <!-- <unlocked/> -->



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

                <tcp ip="localhost" port="9000" telnet="disable"/>



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

                <key>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</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>xxxxxxxx</host>

                <port>7778</port>

        </chatserver>



        <!-- Mailserver (in-game mail) information.  Defaults shown -->

        <mailserver>

                <host>xxxxxxxxx</host>

                <port>7779</port>

        </mailserver>



        <zones>

                <defaultstatus>0</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>localhost</host>

                <port>3306</port>

                <username>root</username>

                <password>xxxxxxxx</password>

                <db>peq</db>

        </database>



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

below is the login.ini file that works with loginserver.exe from the eqemu_update.pl

Code:

[database]

host = 127.0.0.1

port = 3306

db = peq

user = root

password = xxxxxxxxx

subsystem = MySQL



[options]

unregistered_allowed = TRUE

reject_duplicate_servers = FALSE

trace = TRUE

world_trace = FALSE

dump_packets_in = FALSE

dump_packets_out = FALSE

listen_port = 5999

local_network = 192.168.1.

auto_create_accounts = TRUE



[security]

plugin = EQEmuAuthCrypto

mode = 5



[Titanium]

port = 5998

opcodes = login_opcodes.conf



[SoD]

port = 5999

opcodes = login_opcodes_sod.conf



[schema]

account_table = loginserver_server_accounts

world_registration_table = loginserver_world_server_registration

world_admin_registration_table = loginserver_server_admin_registration

world_server_type_table = loginserver_server_list_type

Some people put a shared_memory.exe call in their script to make sure that it's up-to-date every time.

You should at least make sure that it's run once..you may need to create the sub-folder '\..\shared\' in your server directory, if it doesn't exist.

(It does need to be run whenever there are changes to database entries or, especially, when there are changes in pertinent structure sizes in the code.)

Are you using 32-bit or 64-bit binaries?

I added the shared folder and the shared_memory.exe in the startup script. I should be using x64 binaries but the C++ runtime is calling for x32 so it might be x32 on a 64bit server. there a way to call up an output to show binary bit?

The one thing I noticed was there are new loginDB tables under the base PEQ DB. Do we not use a seperate DB for account logins anymore? Because last login is not populating in any login tables but the account is able to login initially... I do not see the server listed and eqlaunch.exe screen is blank.

Wassn't there some table in PEQ where I need to update the name of the server and login info? Like in rule_values or something? Since I overwrote the entire DB? Something is not calling the correct login DB and Server...

I just found multiple login server entries in the PEQ DB

login_server_accounts.

And

tblloginserveraccounts

It looks like when it works it is reading from the login_server_accounts and not the older peqlogindb or the PEQ DB > tblloginserveraccounts

I dont care if I have to copy the tables over for account logins. I just need to get is working for one. whereever the login tables are... then copy over the accounts....

Is this a normal occurance? I must be missing some setting somewhere

Just tossing out a quick suggestion. If you have the ability to spin up a windows VM, you could download and install Akka's new windows installer and then have a working server to check your DB against. It might make it a bit easier to have one to compare to.

As for the login server on this new server to compare to, you can do the steps presented on Akka's wiki to get that going. Or he may have added that option to install the login server I am not sure to his auto windows install.

To answer your above question, all you need to do is rename your login.ini referenced tables to the ones that match in the database.

Celestial

ok... so after I determined that the login tables were different I copied the table entries

From --- To
peqlogindb>tblloginserveraccounts --To-- PEQ>login_server_accounts

peqlogindb>tblserveradminregistration --To-- PEQ>loginserver_server_admin_registration

peqlogindb>tblserverlisttype --To-- PEQ>lloginserver_server_list_type

peqlogindb>tblworldserverregistration --To-- PEQ>loginserver_world_server_registration

Then... I noticed that world.exe would not load unless 127.0.0.1 instead of localhost was in the eqemu_conf file. So I changed that as well. Again still using the the older EQEMUloginserver.exe

Then updated the start script:

Code:

@echo off

Echo Starting EQEmuLoginServer

c:

cd C:\eqemu

echo

shared_memory.exe

echo

start eqemuloginserver.exe

echo

start world.exe

echo waiting for the world to finish before starting zone...

ping -n 10 127.0.0.1 > nul

start queryserv.exe

start ucs.exe

start eqlaunch.exe zone

exit

I was now able to see the eqlaunch.exe change to sleeping. and have the below output on the server windows. BUT When trying to login to a zone (tutorialb) the eqclient just crashes. When trying to enter crescent reach as well with a new toon EQ crashes.

Nothing notable in the log file but I see the below in world.exe when trying to zone in:

Code:

[World Server] Loading variables..

[World Server] Loading zones..

[World Server] Clearing groups..

[World Server] Clearing raids..

[World Server] Clearing inventory snapshots..

[World Server] Loading items..

[World Server] Loading skill caps..

[World Server] Loading guilds..

[World Server] Loaded default rule set 'default'

[World Server] Loading EQ time of day..

[World Server] Loading launcher list..

[World Server] Reboot zone modes OFF

[World Server] Deleted 0 stale player corpses from database

[World Server] Loading adventures...

[World Server] Purging expired instances

[World Server] Loading char create info...

[World Server] Zone (TCP) listener started.

[World Server] Client (UDP) listener started.

[World Server] New TCP connection from 127.0.0.1:52963

[World Server] New TCP connection from 127.0.0.1:52965

[World Server] New TCP connection from 127.0.0.1:52967

[World Server] New connection from 192.168.1.162:51104

[World Server] Checking inbound connection 192.168.1.162 against BannedIPs table

[World Server] Connection 192.168.1.162 PASSED banned IPs check. Processing connection.

[World Server] New TCP connection from 127.0.0.1:52969

[World Server] New TCP connection from 127.0.0.1:52971

[World Server] New TCP connection from 127.0.0.1:52973

[World Server] New connection from 192.168.1.162:51108

[World Server] Checking inbound connection 192.168.1.162 against BannedIPs table

[World Server] Connection 192.168.1.162 PASSED banned IPs check. Processing connection.

No start_zones entry in database, using defaults

but there is a start_zones table

************************************************** **

Thanks, I might try to spin up another VM to compare as well. I can get to character create now so that is a plus... can't zone in

Do you have any zones set to startup, even just a bunch of dynamic zones?

Your script is calling this "start eqlaunch.exe zone", So there should be in the table "LAUNCHER" an and the first column should have an entry called "ZONE" and the other column a number (the heading of the second column is dynamics). Make sure there is a number in there. By default its usually 5. That will allow you to zone into at least 5 zones simultaniously (multiple players in different zones).

In the table "Launcher zones" you can specify zones to launch statically.

Celestial

My Launcher Table:

Code:

Name        dynamics

PEQ          40

zome         5

my launcher_zones table:

Code:

NULL

I have a start_zones table that is fully populated

I don't think there's a requirement to put the login server tables in a separate db..mine works just fine in the same db.

All (4) of my login server tables are prefixed with 'tbl'

Thanks all for the assistance. I got it working where I can login to the game. Was missing some file updates that prevented me from getting into the game.

What is the best way to verify that RoF along with all associated is working properly? My first guess is to make the GM character and #level and mess aroundl; but was wondering if there was any neat validation tool that someone developed since I've been away.

If you have the latest binaries, db changes and rof conf file - and can log into the server - that's a pretty good indicator that you're up-to-date :)

EDIT: There may be features that are not implemented or fully working (correctly)..so, don't take something not working as your server being dated.

Thanks. I was able to #zone into grelleth in RoF expansion with the GM. but cannot #zone potimea or click from pofire to potranquility. Getting you do not own expansions message.

I see that expansions in rules table shows as 16383

Could be a status thing as well. Look at your zone table for clues.

Thanks for the help. That fixed the zoning issue but I have a bigger problem that I updated in another thread. Any level past 85 gives the character only 5HP/Mana and sticks at 0% (with the auto build on new server) On my server that I was updating from UF any character over 85 is stuck at 75% health/mana

Looks like the issue is client side or both server and client side? When I target the character they show up as 100% but on that toon they are 0% health in UI, and 5HP/Mana in the inventory screen... not sure how to fix this. My main goal is to have a lvl 100 server.

It's your HP calc.

Code:

INSERT INTO `rule_values` VALUES ('1', 'Character:SoDClientUseSoDHPManaEnd', 'false', 'Setting this to true will allow SoD clients to use the SoD HP/Mana/End formulas and previous clients will use the old formulas');

There's a thread around with some lvl 85 issues called out..not sure if they will pertain directly to this case or not. (Can't recall the poster atm..was a server admin, though)

On your 'Getting you do not own expansions message' message..

I ran into this with RoF and Secrets fixed it. Most likely, it's the same issue again in RoF2.

The client had a change in its zoning failure enumeration and we probably just need to update the RoF2 cases in our code. (Yes, it's very likely a level restriction message)

Thanks again everyone for the help. This community is the best. changing that value to true and then updating my base_data files for lvl 100 fixed the issue.

Just a note. Both upgrading from UF and installing new via the Wiki Script works fine with Win2008 Ent x64 R2

Hello,

May I ask how did you update your base_data information?
I believe I am having the same issue you were having where any character above 85, ends up with 5hp and won't regen hp. As soon as I change it back to 85, everything works fine.

I did update the rule_values Character:SoDClientUseSoDHPManaEnd to true.

Any assistance would be greatly appreciated.
*edit*
realized wasn't showing all fields, as the data does go to 85.