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

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Tutorials::Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=597)

- - Setting up pre5/11 Velious Beta1 + 6.1DR1 + Minilogin(windows) (https://www.eqemulator.org/forums/showthread.php?t=18707)

Legar, im stuck at connecting, are you behind a router? I've had this working a long long time ago.. and i remember switching between localhost/127.0.0.1/and my ip 192.168.-.- and had my wife and I both playing. but i can't get the right combo. My eq version is correct, i can play on other eqemulator servers.

holy balls! id just like to say thanks, ive been looking for a viable everquest emulator for going on a year and ive tried more tutorials on doing one than i should have. got everything working on this one up to the point of 1017 cause i am yet to find a working eq version, but i think that will do it so id like to say THANKS!
*edit*
I have managed to get a working version, but at the moment all i can access is fatesdestiny, if i change my eqhost to whats on the tutorial, the window just hangs after i hit connect

Omgsh! Great awsome guide!

Worked Magic for me! :D

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

Thanks again!

Hey, I dont know where all the errors are coming from. I ran this guide on a few computers now and it worked perfectly for me.

As for *where* the PEQ pre5/11 patch is i cant say. Sorry, i dont know if its a rule over at projecteq, but i would probably ask over there instead.

Hopefully this works for most, i honestly cant say why your servers are not showing up. Like i said before, sometimes that would happen, but if i logout or restart my EQ client it would show up, it was never permanent. If you put everything in the way it was stated in the guide you should be good to go. I would say if you change any of the 127.0.0.1 to localhost, that you change them all.

If you cannot connect to the worldserver, then i would make sure your loginserver and worldserver are actually takling to each other. If they are, then theres probably a problem between the two of them, but thats a guess.

So once again, sorry for thsoe who it isnt working for. I can try to help where i can, but i cant offer up the info on where the patch is, and i dont know why the servers arent showing up. Sorry :(

As for a working internet version, i cant say. I am behind a military network, so i basically built this for my personal laptop, since i get no chance to play on my live account and im having withdrawls :P

Maybe some experienced veterans will come visit and inform on some of the errors. Because i dont know :(

the default and plugin for eqemu is that supposed to be saved as a .sql also or .pl? nevermind i figured it out

This guide is fantastic..I just can't get to server select for some reason.. Keep getting the "make sure you are online" window Must be my host file?

reading some .txt files in my eq folder, most say october 25th, not sure that is accurate.. but I've tried 0.6.0 DR 3 and 0.6.1 DR2... with 6.0 minilogin and 6.1 to match. I can play on other servers just fine.. and I can even see mine on that list. I've dished out 15$ for a domain name as well, trying to get past my D-Link router.. Still trying.

i typed cd c:\mysql\bin
then mysql -u root
then create database eq;
i get ERROR 1007: cant crate database 'eq' database exist
this is the first time ive installed and tried to pust this together

Aradorn:
http://dev.mysql.com/doc/mysql/en/drop-database.html

Look there... Try dropping the database and recreating it.

Grim:

Quote:

Keep getting the "make sure you are online" window Must be my host file?

Are you talking about the patch window..? If so you didnt make youre EQ shortcut read patchme... If youre talking about 1027 or 1017 in EQ then it could be your host file, could be your login server...

ive done the patchme thing along time ago it just says the database already exist

i went on to step 16 and typed Source load_system.sql;
and everyitem when it tried to source said it was duplicate i sat for over an hour and it did this

Quote:

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

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.

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

Thanks Iwantavr4, my issue is when i type username and password in EQ (after the patchme thing) it just pauses for a minute then says, make sure you are online, can't connect to server. I can't get past that when using minilogin. If i use eqemu login i can get to others servers and such, and even see mine if i start world.exe and all, Course i can't play on mine i get 1017:) so i tried getting a dns $15.00 and all kinds of other combos

Not going to give up. I have had this working, and im awesome at database work.. i populated like 12 zones with correct mob named and itemized drops. I really liked doing that and am trying to get this working so i can do it again lol. May have to wait for eqemu to catch live. Would probably be best.

Quote:

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

No brackets around the user/password.

Quote:

Course i can't play on mine i get 1017 so i tried getting a dns $15.00 and all kinds of other combos

If youre trying to set this up with a network i cant help you... I didnt set mine up that way. I set it up to fly solo on my own PC. 127.0.0.1 is local loopback for computers.