Guild management

[Pirate123]

Hey, im creating a server, and i saw that jkennedy was having a problem with the guild management window. im having the same problem as well with no one showing up in it. I tried using the patches you guys posted for sof and titanium but now when i go to log into the server it crashes the login screen and keeps telling me i need to rerun the patcher. but when i revert back to the original sof and titanium patches i can log in just fine. Do i need to source those patches in somehow or something? or place them in the EQ directory somewhere?

[jkennedy]

u need to update ur revision

[Pirate123]

Hmm ok, so i have revision 1143, how do i go about updating the database and such to match that revision?

[Pirate123]

cause right now the db rev im using is peq 1052

[Derision]

Hmm ok, so i have revision 1143, how do i go about updating the database and such to match that revision?

If your database is at Rev1052 and you want to upgrade to 1143, you need to go here:

http://code.google.com/p/projecteqemu/source/browse/#svn/trunk/EQEmuServer/utils/sql/svn

and download each .sql file that has a prefix between 1053 and 1143 and source them into your database (using the mysql command line tool, or whatever GUI tool you use (navicat etc.))

There isn't an SQL file for every revision between 1053 and 1143, just when any database changes are made. Glancing at the list, these are the ones you need:

1057_titles.sql
1077_botgroups.sql
1136_spell_globals.sql

[Pirate123]

hmmm, still getting a connection error 10061 when world.exe tries to load up the window disappears.

[Pirate123]

I got it working disregard. :) thanks for the help

[nezmyth]

randomroam plugin isnt working for me i was told i need to update the DB, would sourcing the same sql's fix the problem for me ?

[OscarGrouch05]

might try this OP_GuildMemberList=0x147d see if they show up now

[trevius]

Nezmyth, maybe you meant to reply to this thread?:

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

For the randomroam.pl to work, you need to be running revision 1175 or later of the source code. The database revision you are running doesn't matter in this case, because you need the source from 1175 or later to have access to the new functions that get the NPCs spawn and guard points as well as the new LoS checks I added.

The plugin::RandomRoam(min,max) plugin definitely works. I now have a couple hundred NPCs using it in some new outdoor zones I am working on and it works and looks pretty darn good. Saved me a ton of time with pathing :D

[Pirate123]

Ok, anyone kno whats with the "unknown class" in guild management window? shows my class but doesnt show anyone elses class. comes up as an "unknown class" even on the game i have open. guild leader shows up fine, invite another toon of mine to test it out, shows up as unknown class on guild leaders GM window, and then even shows up as Unknown class on that characters GM window.

[Pirate123]

ok, now in the world.exe its saying

first opcode 0x4dd0 did not match expected 0x2792,
tried patch 6.2_world, it did not match.
first opcode 0x4dd0 did not match expected 0x2ec9
tried patch 6.2_world, it did not match.
first opcode 0x4dd0 did not match exptected 464.

take it i need to update patch 6.2 and opcode files or no?

[OscarGrouch05]

yes for opcode and sof and anv then after u get them working you have Ls_Server working 80) don't forget to decode the world 464 i done it once before.
the best part after done you have LS_World and LS_Server both working since i coudln't find my old files that is what i'm working on now.