Okay so I had alot of trouble with getting my paladin database on the server so I thought I would tell you guys how this works in steps...
1) Download the server files [Only registered and activated users can see links. Click Here To Register...]
2) Download and install Wamp5 if you need to.
3) Put the my2 folder from srvr4ever.rar into: Wamp --> MySQL --> Data
4) Then from there go up a folder and go to bin and open WinMySQLadmin.exe
5) If it requests you put in a username and password use these credidentials:
Username: test
Password: test
6) Make sure you have NavicatLite installed because you'll need this to edit database files.
7) Go into navicat, click File --> New Connection
8) When the connection window opens put in this info:
Connection Name = My Server Data
Host Name/IP Adress = localhost
Username = test
Password = test
Then click on Test connection, if it says access denied for test@localhost then click okay and change the password to nothing. If the connection suceeds then click okay
9) [This Step is for the peoples who's test password didn't work. If it did on yours skip to step 10] After you are in the database you should see most probly 3 databases, my2, test and mysql. Click on the Manage Users near the top left corner.
It will then open a window about what users are allowed on your database. You should also see test@localhost click on that user and then click edit user.
It will then pop up with a window. Ignore the Username and host just change the password fields to test. Then click okay and close and restart WinMySQL from running. Then move onto the next step
10) We havent finished the serverside work yet. Go into Users tab in Navicat again and make a new user with this information:
Username: ODBC
Host: localhost
Leave the password fields blank. Then move on to the next step...
11) We have now finished the server database side work. Now go into srvr4ever folder then into ACCserver folder...
Change the account.ini to:
Then change your config and shell in the gameserver folder and run the server programs like you would for any other server...
If you want to delete records from the old Alpha Online server then use this Query or command whatever it is :P
1) Download the server files [Only registered and activated users can see links. Click Here To Register...]
2) Download and install Wamp5 if you need to.
3) Put the my2 folder from srvr4ever.rar into: Wamp --> MySQL --> Data
4) Then from there go up a folder and go to bin and open WinMySQLadmin.exe
5) If it requests you put in a username and password use these credidentials:
Username: test
Password: test
6) Make sure you have NavicatLite installed because you'll need this to edit database files.
7) Go into navicat, click File --> New Connection
8) When the connection window opens put in this info:
Connection Name = My Server Data
Host Name/IP Adress = localhost
Username = test
Password = test
Then click on Test connection, if it says access denied for test@localhost then click okay and change the password to nothing. If the connection suceeds then click okay
9) [This Step is for the peoples who's test password didn't work. If it did on yours skip to step 10] After you are in the database you should see most probly 3 databases, my2, test and mysql. Click on the Manage Users near the top left corner.
It will then open a window about what users are allowed on your database. You should also see test@localhost click on that user and then click edit user.
It will then pop up with a window. Ignore the Username and host just change the password fields to test. Then click okay and close and restart WinMySQL from running. Then move onto the next step
10) We havent finished the serverside work yet. Go into Users tab in Navicat again and make a new user with this information:
Username: ODBC
Host: localhost
Leave the password fields blank. Then move on to the next step...
11) We have now finished the server database side work. Now go into srvr4ever folder then into ACCserver folder...
Change the account.ini to:
Change the cofig to:Quote:
[Account1]
SERVERNAME=[ServerName]
LOGINNAME=test
PASSWORD=test
FREE_DEBUG=3
Change your AuthorizeDB file to:Quote:
[System]
LOGINLISTENPORT = 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS = 5000
SERVER_BUSY_DELAY_SECS = 3000
SERVERNAME = [ServerName]
LOGINNAME = test
PASSWORD = test
SERVERIP = [ServerIP]
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my2
DBUSER=test
DBPASSWORD=test
Change the places where it says [ServerName] and [ServerIP] to your information......Quote:
127.0.0.1 test test my2 account name password id
count_stat server_name status
127.0.0.1 test 378b243e220ca493 my2
Then change your config and shell in the gameserver folder and run the server programs like you would for any other server...
If you want to delete records from the old Alpha Online server then use this Query or command whatever it is :P
If this guide helped you I would appriciate it if you pressed the Thanks button below :)Quote:
DELETE from my.cq_user;
DELETE from my2.cq_eudemon;
DELETE from my2.cq_item;
DELETE from my2.cq_account;
DELETE from my2.cq_castle;
DELETE from my2.cq_castleitem;
DELETE from my2.cq_castlemap;
DELETE from my2.cq_enemy;
DELETE from my2.e_money;
