Solo server question

[vindr3d]

It has been a while since I created my eq server. I was wanting to change it to where a friend and I could duo. It is fully functioning.

I remember seeing a list of commands you could put in a config file or something to tweak mob hps, aggro radius, assist other mob radius, etc etc.

Does anyone know where that list is? I can't seem to find it.

I would appreciate any help!! Thank you ahead of time!

[Krran]

as far as i know it is easiest to do that through SQL commands in the DB, unless that is what you are already talking about.

Poke around in the DB with a SQL tool enough and you will see the rows that you want to change and write a few little scripts.

[vindr3d]

Yeah. Pretty sure it was SQL commands.

I'm not very familiar with it though.

[vindr3d]

Finally found another post that has a little more detail that i was looking for.

http://www.eqemulator.org/forums/showthread.php?t=36024

Thank you for your help!!!

[Portal63]

On this topic. Be careful when you reduce values. Make sure you aren't going to change something important (like hitpoints, damage, etc.) to 0, and don't forget that pets for pet classes are in the npc_types table, so if you do something like cutting all HP totals in half, you'll also be crippling pet classes in the process.

[Uleat]

You may also need to check the actual scripts. There have been changes to db tables and core systems in the server code, so they may be out-of-date.

[vindr3d]

Ok thanks. I was just going to tweak the gear like that post i linked. Up the stats on all the equip.

Only thing is I couldn't really find an option for increasing weapon damages. Anyone know how to do that?

[vindr3d]

Another question if y'all don't mind.

I recompiled my server and it is working again (I didn't have bots enabled the first time around it seems).

Now, I keep getting name rejected except if I use the random "Get Name" button at the bottom. Anyone know how to fix this?

This is an error on the world server that I see and have no idea how to fix or if it is even related to the rejected name error I get trying to make a new character:

[Error] Error in AdventureManager:::GetLeaderboardInfo: SELECT ch.name. ch.id, adc_stats.* FROM adventure_stats AS adv_stats LEFT JOIN 'character_data' AS ch ON adv_stats.player_id = ch.id; <#1146: Table 'peqbots.character_data' doesn't exist>


Again, I appreciate any help! Thank you!

[chrsschb]

Originally Posted by vindr3d

Another question if y'all don't mind.

I recompiled my server and it is working again (I didn't have bots enabled the first time around it seems).

Now, I keep getting name rejected except if I use the random "Get Name" button at the bottom. Anyone know how to fix this?

This is an error on the world server that I see and have no idea how to fix or if it is even related to the rejected name error I get trying to make a new character:

[Error] Error in AdventureManager:::GetLeaderboardInfo: SELECT ch.name. ch.id, adc_stats.* FROM adventure_stats AS adv_stats LEFT JOIN 'character_data' AS ch ON adv_stats.player_id = ch.id; <#1146: Table 'peqbots.character_data' doesn't exist>


Again, I appreciate any help! Thank you!

When it comes to SQL the answer is usually in the error.

[vindr3d]

I rebooted the server and now the random generated names won't work either.


edit: meant to edit the above post but I was in the wrong box. Sorry!

[Portal63]

There were some significant changes to character tables. There is no longer a table named character_data. It sounds like you have an old (not current) copy of the emu source and perhaps a newer copy of the database build scripts.

You'll want to get the latest source and latest schema, or use the version of the database that corresponds to your emu source. IMO, just go with the latest of both and you should be OK.

[vindr3d]

I was following the windows setup guide and downloaded everything that it told me to. So I'm not sure what to do different.

[jdoran]

Are you building the server from source, or using a pre-built binary?
If the binary, which one? Perhaps it is an old version...

[vindr3d]

Currently you must download the latest database from the following location (you will get redirected to a Google Drive folder):

http://peqtgc.com/releases

The filename will be something like:-

peqbeta_{Date_and_Time}.tar.gz

where {Date_and_Time} is actually the time it was generated e.g 2014-04-01-02:01
Next, go to the folder C:\EQ\SQL and unzip the file.
If double-clicking on peqbeta_{Date_and_Time}.tar.gz does not launch 7-zip or your preferred unzipper, you may need to launch 7-manually (possibly using 'Run as Administrator' and go into the settings/options and tell it to associate it with .gz files).

It is peqbeta_2014-08-11-02-01.tar.gz.

[vindr3d]

I was able to figure it out with the help of KLS.

Thank you everyone for your input!