Alright. I hate asking people for help but god damnit here i am. Resistance is futile. I started out following this post just as it said:
http://www.eqemulator.net/forums/viewtopic.php?t=17531
I got all the downloads and everything, and installed all the programs in the proper directories.
I am using..
11-09-04_compiled_perl
ActivePerl-5.8.2.808.MSWin32-x86
peq_kunark_release-1099244294
mysql-4.0.22-win
NMAKE.exe (cant remember where I got it but it took me a while to find)
and the default.pl and plugin.pl from the post.
I didnt know what "additional database files I need"ed so I didnt bother with those yet.
Installation Steps:
1) I installed MySQL, but what the hell was "run the prog i had you download?"
You gain experience!
2) extracted compiled perl to c:\eqemu as well as spells_us.txt
You gain experience!
3)installed perl 5.8
You gain experience!
4) put NMAKE.exe into c:\perl\bin
You gain experience!
5) disaster struck-
a Perl 5.8 scowls at you, ready to attack. What would you like your tombstone to say?
I open cmd prpt, type perl -MCPAN -e shell
and c:\Perl folder opens up. clearly not what i wanted to happen. So i say fuck it and go ahead with the instructions.. I dont get anything prompting me for anything.
I restart my computer just because instructions say so. then i type install IO::Scalar into cmd prpt. instead of installing something, it simply opens my c:\WINDOWS\system32 folder 0.o
So, I sigh to myself and trudge forward.
I type perl -MIO::Scalar -e "print 'Installed'" into cmd prpt and like the first substep of 5), opens my c:\Perl folder.
Soo.. reading down, I am directed to search
http://search.cpan.org for Scalar.pm and WrapTie.pm.
Cpan.org looks at you apprehensively. You appear to have the upper hand.
This only takes me a few minutes, I download the 2 files, stick em in the c:\Perl\lib\IO folder and set to try to backtrack over the last few steps I described. I repeated them many times now, with the same results. (So step 5 is completely fucked up)
Pain and suffering hits YOU for 1242 points of damage!
6) copied plugin.pl to the c:\eqemu directory
-created c:\eqemu\quests and copied default.pl to said folder
Extracted PEQ_Kunark_RC1 to c:\mysql\bin
Run WinMySQLAdmin.exe and selected my inherently easy, unforgettable user/pass, and stuck it in the slots.
You gain experience!
mysql.exe scowls at you, ready to attack. What would you like your tombstone to say?
I get my little window, looks like this:
-----------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.22-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
-----------------------------------------------------------------------------
Ok, i say to myself hell this cant be that hard..
mysql> GRANT ALL PRIVELAGES ON eq.* TO pooky@localhost IDENTIFIED BY 'mypassword' WITH GRANT OPTION; (enter)
ERROR 1044: Access denied for user: '@localhost' to database 'eq'
mysql>
-----------------------------------------------------------------------------
So naturally what do i do? of course I try every little change I can make to the "user" "pass" and "localhost" areas. I searched many many forums across the net, not only eqemu (which said to use image@113.113.13.13 --- 'bleh' after altering the db.ini)
It seems the access denied (1044) goes hand in hand with error 1064..
-------------------------------------------------------------------------------
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13 to server version: 4.0.22-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> create database Forum
-> grant all privileges on eq.* to pooky@localhost
-> identified by 'mypassword';
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'grant all privileges on eq.* to pooky@localhost identified;
mysql>
---------------------------------------------------------------------------------
I read this..
Try this
mysql -u root -p PASSWORD
<---where the hell do I type this?
Where PASSWORD is the password of the root account.
If I type it in cmd prpt, i get nothing, and if I type it in mysql> I get nothing lol.
Pain and suffering hits YOU for 32000 points of damage!
You have been slain by MySQL!
LOADING...PLEASE WAIT
Sorry for the really long post, I just wanted you guys to know each of my steps so you could maybe figure exactly what I did wrong. And tossed in a little EQ Humor to lighten the mood =)
I am gaining more and more interest in programming, im just... not that good at it
