Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows)

[Belfedia]

Nice tutorial, this one of best i see
But link for download pre-patch 05/11/2005 everquest files is against forum's rules... (http://www.eqemulator.net/forums/announcement.php?f=586).
You may be permaban for that :(
I'm not moderator, administrator or devs in eqemu, this is just a advice.
This is my last message for this kind of rules. In french country, backpatch are not considered like warez, if you have the original software.

[Calabeth]

Hopefully if he just takes that link out and puts a notice that ppl have to have copy of the pre 5/11 patch he should be gtg.
I will erase my old DB and try and mostly start from scratch trying this see if I can finally get my lil server going correctly and be seen hehe.

[iamjooish]

Originally Posted by Belfedia

Nice tutorial, this one of best i see
But link for download pre-patch 05/11/2005 everquest files is against forum's rules... (http://www.eqemulator.net/forums/announcement.php?f=586).
You may be permaban for that :(
I'm not moderator, administrator or devs in eqemu, this is just a advice.
This is my last message for this kind of rules. In french country, backpatch are not considered like warez, if you have the original software.

nor is it /truely/ considered 'warez' here in the states, but everyone uses the word in the broadest possible sense anyways.

strike what I said earlier. eqemu works as well as it does because it's developed in the legal grey/white area and because SOE can't do anything about them as long as that's the case. (for now!) allowing links to older files, even for just a few moments, puts the emu's developement at risk.

I don't think he has to change his language, however. He could link to Dr. Zauis's system resore idea, for example. A number of custom-legit servers, too, have a solution for this problem.

[solid11]

Yeah, great tutorial, but do us all a favor and edit that link for pre patch from your post please. Don't want one mistake to ruin it for the rest of us.

[HalberdBlue]

I just tried updating to live from the patch given above. There is NOTHING different. All the server downloaded was eqhost.ini which I had changed, even after a full file scan. The EQ Version number program gave the same version number as well.

Dunno if that means he has to take it down, but that patch isn't worth much unless you know what version of EQ you have to patch it from.

So I'm thinking that the fact I get stuck at the 1017 error and can't get past the log in screen trying to log onto other EQEmu servers is because the patch given above is the same as live.

[iamjooish]

bull... I just ran everquest.exe and it replaced my eqgame.exe, among other things.


it doesn't bother me, I have the subject thread and the silly zipfile nested nicely in one of my folders. Besides, there are much less riskier ways of of reverting to the december patch, why put this great guide at risk...


edit

one last little thing

[Quest] Loading perlemb plugins.
[Quest] Loading perl commands...
[Quest] Warning - commands.pl: Perl runtime error: open 'commands.pl' No such file or directory at (eval 4) line 1.

something I shourd be worried about?

[sylverwolf]

Ok. a little note to any new folks out there (like me) and hope everyone reads this whole thread before doing this (this is a really well put together guide btw)

When i sourced the first database (the big one), i went for a cup of coffee and did a couple more things and came back and waited...and waited. when it got done, i lost track of where i was and cut right to the next procedure (the delete items deal)

DON'T MAKE THE SAME MISTAKE I DID!

be sure to source the other little items into the database first. what happened was when i ran the perl load items, i got a crapload of errors because i skipped the 6.0-6.1 convert and had to start ALL OVER hehe

[tancor]

Are there any other places other then activestate.com to get those few utility addons? I can't seem to get access to that site - I'm very much looking forward to trying the tutorial.

-- Edit --

Nevermind - I managed to get into it finally, must have just been really busy this morning and got the modules needed.

[iwantavr4]

Okay, i editted out the patch thing, didnt realise. Thanks alot for letting me know Belf, i see your posts everywhere, you are very informative! And there were quite a few files that were updated on 5/11. I havent gotten it to work yet with the newest patch.

As for the command.pl aparently its an unnecisary file and you can create a blank one if you wish. The PEQ guys told me its not needed... I tried what they said and it just gave me another error. So im not going to bother posting what it was.

Also, if someone else is new to this like me... You need to eb careful when you are in zones like AkAnon, Dragon Necropolis, Veeshans Peak, and Sleepers Tomb... You will get a ton of errors from zone.exe in regards to petstruct not being redefined... And if you click abort it will basically LD you from the zone.

Hope the guide works for everyone else, really sorry about the patch thing. I didnt realise that was warez or whatever...

[kl9470spin]

Omgsh! Great awsome guide!

Worked Magic for me!

if you figure out how to do a internet server let us know

Thanks again!

[Aradorn]

sorry bout that i see it now thanks.... one last question im not clear on. on step 14 I dont put the bracket around username and password right

[iwantavr4]

Okay i changed step 5 of the guide, it now has a link to the eqemu compile perl version from the eqemulator sourceforge site. Download that file, extract all the files within to your C:\eqemu\ then overwrite world.exe, perlzone.exe and emusharemem with the updated files from the other 6.1perl zip file.

[ShadowVax]

When i try t odo the Source Items stuff... i an error stating: ERROR 1146: Table 'eq101.items'(i remade database) dosent exist... it isnt evein in the test or regualr eq database.

I just started this a few days ago and i have everything u linked to download... Hopefully u can help. Sorry for the uber noobnes...

[Aradorn]

Originally Posted by iamjooish

bull... I just ran everquest.exe and it replaced my eqgame.exe, among other things.


it doesn't bother me, I have the subject thread and the silly zipfile nested nicely in one of my folders. Besides, there are much less riskier ways of of reverting to the december patch, why put this great guide at risk...


edit

one last little thing





something I shourd be worried about?

i did everything in the post to do and i got his error too
when i did source the Source items-0.6.0-DR2-0.6.1-DR1-convert.sql;

Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Brandon>cd\ c:\mysql\bin
The filename, directory name, or volume label syntax is incorrect.

C:\Documents and Settings\Brandon>cd c:\mysql\bin

C:\Mysql\bin>mysql -u root
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 37 to server version: 4.0.23-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use eq;
Database changed
mysql> source items-0.6.0-DR2-0.6.1-DR1-convert.sql;
ERROR 1054: Unknown column 'unknown021' in 'items'
ERROR 1054: Unknown column 'unknown022' in 'items'
ERROR 1054: Unknown column 'unknown023' in 'items'
ERROR 1054: Unknown column 'unknown064' in 'items'
ERROR 1054: Unknown column 'unknown070' in 'items'
ERROR 1054: Unknown column 'unknown072' in 'items'
ERROR 1054: Unknown column 'combatskill' in 'items'
ERROR 1054: Unknown column 'combatskilldmg' in 'items'
ERROR 1054: Unknown column 'booktype' in 'items'
ERROR 1054: Unknown column 'unknown108' in 'items'
ERROR 1054: Unknown column 'banedmgamt2' in 'items'
ERROR 1054: Unknown column 'augmentrestriction' in 'items'
ERROR 1054: Unknown column 'tribute' in 'items'
ERROR 1054: Unknown column 'attackbonus' in 'items'
ERROR 1054: Unknown column 'hpregen' in 'items'
ERROR 1054: Unknown column 'hastepercent' in 'items'
ERROR 1054: Unknown column 'unknown125' in 'items'
ERROR 1054: Unknown column 'unknown126' in 'items'
ERROR 1054: Unknown column 'unknown127' in 'items'
ERROR 1054: Unknown column 'distiller' in 'items'
ERROR 1054: Unknown column 'unknown129' in 'items'
ERROR 1054: Unknown column 'unknown130' in 'items'
Query OK, 0 rows affected (0.06 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'unknown131' in 'items'
ERROR 1054: Unknown column 'unknown132' in 'items'
ERROR 1060: Duplicate column name 'UNK121'
ERROR 1060: Duplicate column name 'pointtype'
ERROR 1060: Duplicate column name 'potionbelt'
ERROR 1060: Duplicate column name 'UNK124'
ERROR 1060: Duplicate column name 'stacksize'
ERROR 1054: Unknown column 'hasteproclvl' in 'items'
ERROR 1054: Unknown column 'spellid' in 'items'
ERROR 1054: Unknown column 'focusid' in 'items'
ERROR 1054: Unknown column 'effecttype' in 'items'
ERROR 1054: Unknown column 'level' in 'items'
ERROR 1060: Duplicate column name 'UNK129'
ERROR 1060: Duplicate column name 'proceffect'
ERROR 1060: Duplicate column name 'proctype'
ERROR 1060: Duplicate column name 'proclevel'
ERROR 1060: Duplicate column name 'UNK133'
ERROR 1060: Duplicate column name 'worneffect'
ERROR 1060: Duplicate column name 'worntype'
ERROR 1060: Duplicate column name 'wornlevel'
ERROR 1060: Duplicate column name 'UNK137'
ERROR 1060: Duplicate column name 'focustype'
ERROR 1060: Duplicate column name 'focuslevel'
ERROR 1060: Duplicate column name 'UNK141'
ERROR 1060: Duplicate column name 'scrolleffect'
ERROR 1060: Duplicate column name 'scrolltype'
ERROR 1060: Duplicate column name 'scrolllevel'
ERROR 1060: Duplicate column name 'UNK145'
ERROR 1054: Unknown column 'cost' in 'items'
ERROR 1054: Unknown column 'casttime2' in 'items'
ERROR 1054: Unknown column 'proc_rate_mod' in 'items'
ERROR 1054: Unknown column 'charmformula' in 'items'
Query OK, 0 rows affected (0.07 sec)
Records: 0 Duplicates: 0 Warnings: 0

ERROR 1054: Unknown column 'ldonpointtheme' in 'items'
ERROR 1054: Unknown column 'ldonpointcost' in 'items'
ERROR 1054: Unknown column 'gmflag' in 'items'
ERROR 1060: Duplicate column name 'serialized'
ERROR 1060: Duplicate column name 'verified'
ERROR 1060: Duplicate column name 'serialization'
ERROR 1060: Duplicate column name 'source'
ERROR 1060: Duplicate column name 'UNK033'
ERROR 1091: Can't DROP 'charges'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown001'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_slot_id'. Check that column/key exists
ERROR 1091: Can't DROP 'merchantprice'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown004'. Check that column/key exists
ERROR 1091: Can't DROP 'collected_inst_id'. Check that column/key exists
ERROR 1091: Can't DROP 'unknown006'. Check that column/key exists
ERROR 1091: Can't DROP 'spellcharges'. Check that column/key exists
Query OK, 0 rows affected (0.05 sec)
Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 0 Changed: 0 Warnings: 0

mysql>

i know this is out of order with the steps but this is what happend when i did all the steps in synch
im doing a fresh install with no other server to be upgraded

[iwantavr4]

Aradorn:
Drop the EQ Database! I linked to a page where it describes how to drop a database. You already aparently have a eq database.(and from the looks of it, one which isnt current, or is incomplete)

If you dont want to drop the databse then simply make the database name eqb or eq2 or testing, or database. And just make sure you change the db.ini file to point to your new database.

You dont need it named EQ. It looks as though you already have a eq database.

The second way you can rid yourself of the database is to navigate to your mysql/data directory and DELETE the eq folder. Then restart your computer, and start from step 1.

Either way, you missed my post about dropping teh database, you already have one there, youre trying to overwrite it.