How do I update PEQ?

[maverick3n1]

I figured out how to use the query tool in LCC to run some of the SQL files (to clear the tables etc..), but the main 100meg sql dbase file is too large for LCC and it crashes LCC. There has to be a simple mysql command that would allow me to install it.

[maverick3n1]

I found the mysql command (\.) to insert the new sql tables etc... All of that went well, also updated to the most recent version of 0.7.0 and did all of the additional query's as requested. I have one remaining problem... Everything worked prior to doing the two things above... now it seems to loop on the startup screen.

it keeps repeating the following in the eqlaunch.exe window:

[Debug] [NET_WORLD] Connected to World: 127.0.0.1:9000

If I attempt to log in, I can get to the login screen, but then when it goes to list the minilogin servers, there are none visible.

[maverick3n1]

nobody has any suggestions? =(

[Magefeu]

Your world seems booting in loop. I have no clue on how to solve this. But if your goal is to play on luclin I think that you should just use the cavedude with a 0.7.0-845 update as lunclin RC1 is older that 0.7.0-845.

It should solve your problems.

[maverick3n1]

I thought the Luclin RC-1 came out more recently. From what I was reading, the last patch that the Cavedude Server Pack 3.52 was from sometime in mid April, so I assumed the Luclin PEQ that came with it was also outdated.

If what you're saying is true, I'll wipe the DB and reinstall with the Cavedude Server Pack 3.52. then update to 0.7.0-845 of EQEmu.

[InsaneWallaby]

Eh, I resourced with the July (17, I think) PEQ database. It worked well, except for a few things that I have found. First, kunark goblin faction was obliterated to where the only hit you take is goblins of mountain death (big ouch for firiona vie and sarnak lovers). Second, to play EQ with the PEQ database, you will need to apply the SQL file after redoing the database:

ALTER TABLE `traps` ADD `message` VARCHAR( 200 ) NOT NULL AFTER `effectvalue2` ;

This is likely due to the date of the database. If you source it from scratch, you'll probably have to apply more--look in the "logs" section of the source code downloads on this website, and look at all of the SQL queries that you were required to make since the date your database was posted for download. I merely resourced my database. I found the resourcing to be 95% worth it. It also removed the zone-in loop from akheva to dawnshroud and replaced it with a proper zone.

To fix that outdated PEQ, you're going to need to follow the sourcing directions and whatnot given within the download from the PEQ website. If you can't get that 100mb critter to source, then you'll probably need to split it up into two files or something, which you might be able to do if you split it carefully. Mine sourced fine through importing with SQLYog (free), although it did take a really long time to complete.

[maverick3n1]

There weren't any directions included with the PEQ files I downloaded from the official site. I just ran the 2 sql files that wiped the tables first, and then ran the users file and the system file afterwards, using the actual mysql command prompt (\. load_system.sql). It reprocessed the dbase. Then I installed all of the updates from here that came out after the version of cavedude I had installed.