tyrbo wrote: Thu Dec 28, 2017 3:00 pm It's fine for it to live in a separate database.

You may need some table updates or something though. I recently had to set up Minilogin locally myself and had to tinker with a few things to get it up to date with the live client.

Minilogin will only be used if you're not connecting to the official login server.

One thing to note is that the login server does keep track of the characters you've created, so if you are flip/flopping between Minilogin and the official server, there's a good chance you'll end up out of sync with what characters the official server thinks you have and what characters Minilogin thinks you have.

I handled the flip/flop in EQ1 Emu by updating all my local loginserver account IDs to be the same account ID as used when connecting to the normal loginserver. Super simple fix.

One other question - and I admit I haven't gotten back this far yet - how are the server database tables created and populated? Is it auto-created by the server executable? And also, if this is the case, are the tables it pulls down going to be the ones that are populated per all of John's work?

P.S. - Minilogin has a heartbeat.

Uh, you should be able to enable the updates and have it pull down.. things.
I'm not sure what it gives you, I don't use the database updater.

There is a mass population dump that leaves things in a pretty messy but populated state. I don't know if you get that through the updater. Probably?

tyrbo wrote: Thu Dec 28, 2017 3:18 pm Uh, you should be able to enable the updates and have it pull down.. things.
I'm not sure what it gives you, I don't use the database updater.

There is a mass population dump that leaves things in a pretty messy but populated state. I don't know if you get that through the updater. Probably?

And that is my question for someone to answer. I don't care if it's messy right now really. Having some stuff populated is better than nothing. I'm just messing around with it locally solo right now, anyway.

I'd just turn on the update options for the table stuff and see what it gets you.

The DB Patchers will give you the tables and only the required data to run a server. For actual content check out the content svn, it has a complete dump of the db used on the emulator server as well as all the scripts.

I'm not 100% sure, but patching the db will create the structure and minimum data that allows server to run. Would be very little content using this method by itself. The information you want is on the SVN under trunk/database/dumps/dev_db. There is a file called EQ2DBProject_Current.tar.gz. That contains the current db.

SVN Username: anonymous (no password required)

You will also want to grab the scripts while you are in the content SVN.

So I pulled in my previous copy of the server (like 2 years old) and I'm getting a bunch of errors trying to patch.

19:23:50 E DBCore : #1054: Unknown column 'cast_while_moving' in 'field list'
Query:
replace into spells (`id`,`soe_spell_crc`,`type`,`cast_type`,`name`,`description`,`icon`,`icon_heroic_op`,`icon_backdrop`,`class_skill`,`mastery_skill`,`min_class_skill_req`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`cast_while_moving`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`display_spell_tier`,`friendly_spell`,`group_spell`,`det_type`,`control_effect_type`,`incurable`,`linked_timer_id`,`not_maintained`,`casting_flags`,`persist_through_death`,`savage_bar`,`savage_bar_slot`,`is_active`,`is_aa`,`is_deity`,`deity`,`last_auto_update`,`soe_last_update`) values(4072,0,3,0,'Tempering','Tempering allows you to counter Red Hot Material, Orange Hot Material, and White Hot Material. Progress is increased, but the success chance is slightly lowered.',428,65535,65535,3395302654,4032608519,0,0,0,'','',1,0,'Spells/Tradeskills/SuccessModProgressAdd.lua',0,'',3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
19:23:50 E Patcher : Error in updating tables query 'replace into spells (`id`,`soe_spell_crc`,`type`,`cast_type`,`name`,`description`,`icon`,`icon_heroic_op`,`icon_backdrop`,`class_skill`,`mastery_skill`,`min_class_skill_req`,`duration_until_cancel`,`target_type`,`success_message`,`fade_message`,`interruptable`,`cast_while_moving`,`lua_script`,`spell_visual`,`effect_message`,`spell_book_type`,`can_effect_raid`,`affect_only_group_members`,`display_spell_tier`,`friendly_spell`,`group_spell`,`det_type`,`control_effect_type`,`incurable`,`linked_timer_id`,`not_maintained`,`casting_flags`,`persist_through_death`,`savage_bar`,`savage_bar_slot`,`is_active`,`is_aa`,`is_deity`,`deity`,`last_auto_update`,`soe_last_update`) values(4072,0,3,0,'Tempering','Tempering allows you to counter Red Hot Material, Orange Hot Material, and White Hot Material. Progress is increased, but the success chance is slightly lowered.',428,65535,65535,3395302654,4032608519,0,0,0,'','',1,0,'Spells/Tradeskills/SuccessModProgressAdd.lua',0,'',3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)': #1054: Unknown column 'cast_while_moving' in 'field list'
19:23:50 E Patcher : Data Updated: 'spells' = FAILED!

...

19:24:51 I World : Loading System Data...
19:25:08 E Rules : Unknown rule with category 'R_World' and type 'IRCGlobalEnabled'
19:25:08 E Rules : Unknown rule with category 'R_Player' and type 'MaxLastNameLength'
19:25:08 E Rules : Unknown rule with category 'R_Player' and type 'MinLastNameLength'
19:25:08 E Rules : Unknown rule with category 'R_Player' and type 'MinLastNameLevel'
19:25:08 E Rules : Unknown rule with category 'R_Zone' and type 'CheckAttackNPC'
19:25:08 E Rules : Unknown rule with category 'R_Zone' and type 'CheckAttackPlayer'
19:25:08 E Rules : Unknown rule with category 'R_Zone' and type 'HOTime'
19:25:08 E Rules : Unknown rule with category 'R_Zone' and type 'SpawnDeleteTimer'
19:25:08 E Rules : Unknown rule with category 'R_World' and type 'SavePaperdollImage'
19:25:08 E Rules : Unknown rule with category 'R_World' and type 'SaveHeadshotImage'
19:25:08 E Rules : Unknown rule with category 'R_World' and type 'SendPaperdollImagesToLogin'
19:25:08 E Rules : Unknown rule with category 'R_World' and type 'TreasureChestDisabled'

Is this still correct:

[UpdateServer]
updateserveraddress=updates.eq2emulator.net
updateserverport=9103

I was able to get all the way connected with the world server when set to use the eq2emulator login server.

And how would I go about starting fresh with the database? I think I'm just too out of sync and am fine with clean slate.

Also, one more thing:

If I try to use Minilogin, I get an error logging in "The client's version does not match the server's, rerun the patcher." (maybe not word for word)

Try port 9104 for the updater. That was recently changed.

tyrbo wrote: Thu Dec 28, 2017 6:18 pm Try port 9104 for the updater. That was recently changed.

20:21:15 I Patcher : Connecting to DB PatchServer...
20:21:20 W Patcher : Please wait...
20:21:45 E Patcher : Error while getting updates!
20:21:45 I Patcher : DB Update check completed...


Looks like it was doing better on 9103 lmao.

Also, I think part of this is that I think I'm not running the latest server binaries. I just realized (sadly) that .0.7.2 is by far not a new build. I had seen that as most recent and pulled that in precompiled form to run. Is a bleeding-edge source available to compile, or precompiled of the latest with current patch level support? Note - I connect to eq2emulator server fine, so I know current patch is supported.

elkay wrote: Thu Dec 28, 2017 5:26 pm If I try to use Minilogin, I get an error logging in "The client's version does not match the server's, rerun the patcher." (maybe not word for word)

You will need to dump the opcodes table from your world db then source it into the loginserver database. Loginserver opcodes do not update automatically.

As for the patcher I really have no clue now. [mention]Jabantiz[/mention] will have to weigh in on this since I don't know if the new patcher is even up right now.

Starting with a fresh database is as easy as dropping your database, connecting to patcher, then sourcing in the current db dump. Alternatively you can create a new database and point login and World to use your new db

Cynnar wrote: Thu Dec 28, 2017 6:57 pm

elkay wrote: Thu Dec 28, 2017 5:26 pm If I try to use Minilogin, I get an error logging in "The client's version does not match the server's, rerun the patcher." (maybe not word for word)

You will need to dump the opcodes table from your world db then source it into the loginserver database. Loginserver opcodes do not update automatically.

As for the patcher I really have no clue now. @Jabantiz will have to weigh in on this since I don't know if the new patcher is even up right now.

Starting with a fresh database is as easy as dropping your database, connecting to patcher, then sourcing in the current db dump. Alternatively you can create a new database and point login and World to use your new db

Ok cool, will try all of that. Thanks!

Also, FYI, I found the GIT repository, since apparently we aren't using SVN anymore. I was able to pull it all, and already had VS 2017 full version installed because I also use it for work. Unfortunately, when I use Cmake GUI it throws an error "Configuring incomplete, errors occurred!".. yet doesn't give me any verbose information. So dead end at the moment on a current compile until someone weighs in on that one.

P.S. - Getting caught up on Vikings to pass the time while I'm chipping at this. If you haven't watched, it's included with Prime and you should def watch!

We are using svn still as far as I am aware. Whatever git repo you found probably isn't the official one.

Might be mine (?)

elkay wrote: Thu Dec 28, 2017 7:12 pm Also, FYI, I found the GIT repository, since apparently we aren't using SVN anymore

Don't know who's it is. Currently we still host Eq2emulator code on the svn.

Well CRAP!!! LOL. Deleting the git pull LOL. So 0.7.2 is the current version running on eq2emulator? I'm not going to go through all the rhythms of rebuilding it if it's the same code base. It's fun and all knowing all this stuff, but I'm not adding extra steps for myself just to say I can!