COMPLETE PUBLIC SERVER SETUP - Jan-2011

[Emmeric]

Thank you for the responses. With the accurate directions, I changed the target to 512 and received 5 successes.

In Step 10, there are instructions to copy files. Before I go any further, I noted that both the WORLD and ZONE folders have red exclamation points. Inside world, EQWparser is exclamation. Everything else green. Inside zone, embperl is exclamation, everything else green. These two folders cause all the parent files to show exclamation points (C:\EQEmuSVNFiles\EQEmu\trunk\EQEmuServer\)

Should I be concerned about this? I do not want to advance the process only to find these things mattered and have to start over.

If they do matter, could someone indicate precise steps that I can follow to correct this?

Thanks!

[lerxst2112]

The exclamation point means that a file is changed, or a folder contains one or more files that are changed. It's nothing to worry about.

[Emmeric]

Originally Posted by lerxst2112

The exclamation point means that a file is changed, or a folder contains one or more files that are changed. It's nothing to worry about.

Good, thanks.

The attempt to use the peqdb is not working. When downloading the DB using this link in Tortoise SVN (http://projecteqdb.googlecode.com/sv...k/peqdatabase), we get a zipped database_incremental. When that is unzipped, a folder named database incremental is formed with a db_dump text file inside. There are no .sql files.

Commands to use either the incremental folder or the dump text do not source the DB as the guide directs.

What should I be doing here? I read through this thread but didn't see a definite or clear answer to this issue.

Thanks for your help so far! Things are proceeding smoothly as long as I stop at every hitch and ask...

[BrandeX]

Try again. I just d/l and unzipped database_incremental.zip and got db_dump.sql

Do you have "hide file extensions enabled in windows explorer?

[Emmeric]

Originally Posted by BrandeX

Try again. I just d/l and unzipped database_incremental.zip and got db_dump.sql

Do you have "hide file extensions enabled in windows explorer?

That was exactly it, thank you.

Received a ton of duplicate errors when running load_player.sql. Nothing I should worry about, I imagine?

Also, should I be running any updates to the incremental file? Most look like optional pre-made modifications if I chose to use them?

[Emmeric]

I sampled an sql update, #106 Optional proc rules. It returned an unsuccessful update using Navicat.

[Err] 1136 - Column count doesn't match value count at row 1
[Err] insert into rule_values values (0, 'Combat:AdjustProcPerMinute', 'true');
[Msg] Finished - Unsuccessfully

Using Visual C++, I can locate the lines and simply change them there. Would this work? If I make the changes through Vis C++, would I need to run anything again - the build? The mysql db commands?

[lerxst2112]

Your database is version 1900+, you wouldn't want to apply update 106 to it.

If you look in your rule_values table you should see all of those rules already there.

[Emmeric]

Yes, it appears most of them are already there, thank you.

I was able to login to the world server, though it showed my server locked. I was able to enter the character creation screen, as was my wife at the same time. This is a very large success considering my attempts last week that would only allow 1 person at a time to login.

However, I am receiving a couple of errors and neither myself nor my wife can actually enter the world as whatever zone is "unavailable."

Here are the errors in the exe windows:

[08.24. - 16:40:12] [WORLD__INIT] Loading items..
[08.24. - 16:40:12] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring
[08.24. - 16:40:12] [WORLD__INIT_ERR] Unable to load eqtime.cfg
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2792
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_world, and it did not match.
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: First opcode 0x4dd0 did not match expected 0x2ec9
[08.24. - 16:41:11] [NET__IDENT_TRACE] 192.168.0.2:3314: Tried patch 6.2_zone, and it did not match.
[08.24. - 16:42:50] [WORLD__CLIENT] xxxxxxx: Attempting autobootup of rivervale (19:0)
[08.24. - 16:42:50] [WORLD__CLIENT_ERR] xxxxxxx: No zoneserver available to boot up.

Still searching the forums, but if you see this while I'm looking, what might be the issue in the failure to load zones?


EDIT: Went into the rebuild of Visual and identified a couple problems. I had added a couple things to the exp race and class bonuses:

if(GetBaseRace() == DARK_ELF || GetBaseRace() == HALFLING) {
if(GetClass() == ROGUE) || GetClass() == WARRIOR || GetClass() == CLERIC) {


Apparently they don't like what I thought was a logical structure. Working on fixing it now.

[Emmeric]

Fixed all issues.

Now need to tweak.

Thank you everyone for your help.

[keglo]

I do not get any SVN options when I right click my folder. No SVN Checkout, nothing. I have installed Tortoise a couple of times, restarted, and still nothing. Anyone have any ideas?

[lerxst2112]

Make sure you're installing the 32 or 64 bit version to match your OS. You should see the Tortoise SVN Menu on any folder you right-click on. If not it's either installed incorrectly or there's something else wrong with your computer.

[keglo]

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

[werebat]

Originally Posted by keglo

Oh ok. I downloaded the 32 bit version although I'm running Windows 7 64 bit. I thought I read somewhere to use the 32 bit versions on everything. I'll try installing the 64 bit version. Thank you!!

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

[keglo]

Originally Posted by werebat

Tortoise 64bit works fine. I am using it on my XP 64bit. But MySQL 64bit gives me errors so I had to go to 32bit for that.

Yes. Installing 64 bit did work for me. Thanks for the help. Now I'm having anew problem at step 9 when I do the "Build">"Build Solution" I get the following:

Build: 3 succeeded, 2 failed, 0 up-to-date, 0 skipped

I have tried it twice with the same results. Any ideas?

[lerxst2112]

You would need to post the specific errors in order for us to do anything other than guess.

You probably missed adding one or more of the include/library directories to Visual Studio.