Adding/Removing GMs and Adding CubiGold
Use the excellent BatGM v0.08a by adslpredator Originally found on MMORPG Dev
http://www.mmorpg-devs.com/forum/showthread.php?t=894
I reupped it so you dont have to register to DL it
http://www.megaupload.com/?d=WGXZPKUY
you will have to allow BatGM to Access the Mysql database so do the following..
In phpmyadmin (after you have logged in as root) select your database (dbo) then select the privileges tab, once you have done that select "open new phpmyadmin window"
once that opens you should see the user overview page
1. select add user
2. add the following..
USER = root
HOST = IP of the comp that has BATGM on it
PASSWORD = Your Password
Retype Password = Your Password
Ignore Generate Password
3. now select for Database for user Grant all privileges on wildcard name (username\_%)
4. select check all
5. hit go
that will give you access to the MySql database from BATGM. :thumbup:
Errors found so far..
* 1HP/MP bug
To fix, simply edit the following file by typing this..
Code:
nano /PWServer/gamed/gs.conf
and changing this line
to
save and reboot server
* eth0 doesn't start
Edit the following file by typing this..
Code:
nano /etc/udev/rules.d/70-persistent-net.rules
and change the line
Code:
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{address}=="00:0c:29:68:9e:a3", ATTR{type}=="1", KERNEL=="eth*", NAME="eth0"
to
Code:
SUBSYSTEM=="net", ACTION=="add", DRIVERS=="?*", ATTR{type}=="1", KERNEL=="eth*", NAME="eth0"
and remove any line concerning eth1, once done, save and reboot server
To change SQL password
Code:
cd/opt/lampp/bin
./mysqladmin -u root -p password YOURNEWPASSWORD
it will ask for a password which you enter the old one which in this case it's
root
this new password will have an immediate effect so here are files to edit so PW still functions correctly..
/etc/tables.xml
change line
Code:
connection name="auth0" poolsize="3" url="jdbc:mysql://127.0.0.1/dbo?useUnicode=true&characterEncoding=utf8" username="root" password="root"/>
to
Code:
connection name="auth0" poolsize="3" url="jdbc:mysql://127.0.0.1/dbo?useUnicode=true&characterEncoding=utf8" username="root" password="YOURNEWPASSWORD"/>
/opt/lampp/htdocs/register/config.php
change line
Code:
$DBPassword = "root"; // Database password
to
Code:
$DBPassword = "YOURNEWPASSWORD"; // Database password
Also now you can access
http://192.168.0.51/phpmyadmin with the new password
Changing Root password
this is very easy, just type in the command whilst being logged in as root..
it will then ask you to type in a new unix password then ask again for you to type it in for verification..
oh and I dont do MSN support n stuff, any questions will have to go thru here sorry
