+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Guides & Help Section (https://lckb.dev/forum/forumdisplay.php?fid=193)
+---- Forum: Tutorials & Guides (https://lckb.dev/forum/forumdisplay.php?fid=124)
+----- Forum: Ep1 Guides (https://lckb.dev/forum/forumdisplay.php?fid=178)
+----- Thread: [HOW TO]Administrate Server (/showthread.php?tid=1164)
- SeaLife - 09-28-2012
Welcome... now i'll show you how to do something with 2008 server files (120518 fix by blankname server)
Delete "You have been hacked" error:
1. Shutdown all server!
2. Go in "phpMyAdmin" to your "newproject_db" and then to the table "t_users"..
3. run SQL in this table:
UPDATE t_users SET a_zone_num = ('-1');
3. you got a response like: "115 Zeilen betroffen. ( die Abfrage dauerte 0.0031 sek. )"
4. Start Server and join!
Ban an Account:
1. Go in "phpMyAdmin" to your "newproject_db" and then to the table "t_users" ..
2. Search the user you want to ban, for example:
You want to ban the account named "SeaLife"...
Run SQL:
SELECT * FROM t_users WHERE a_idname = ('SeaLife');
Press (Edit/Bearbeiten)
Set colum "a_enable" to "2" (1 is active, 0 is inactive, 2 is banned)
Imortant: If you know the Username, run this SQL:
UPDATE t_users SET a_enable = ('2') WHERE a_idname = ('SeaLife');
3. Kick the char out of the game or restart server => User is banned!
Set ingame Cash:
1. Go in "phpMyAdmin" to your "newproject_db_auth" and then to the fist table, named "bg_user".
2. Run SQL:
UPDATE bg_user SET cash = ('50000') WHERE user_id = ('SeaLife');
3. The User (LOGIN NAME) got 50k cash on his account!
The user got the cash in realtime, he dont need to logout.
4. Have Fun!
Change PW/Username of a Account:
1. Go in "phpMyAdmin" to your "newproject_db_auth" and then to the table "bg_user"
2. Search the user you want to change, for example we want to change the account id "541" (named: "SeaLife")
Important: If you know the username or ID, you dont need to search
3. run SQL:
Username:
UPDATE bg_user SET passwd = ('test123'), user_id = ('newuser1') WHERE user_id = ('SeaLife');
UserID:
UPDATE bg_user SET passwd = ('test123'), user_id = ('newuser1') WHERE user_code = ('541');
4. The new username of Sealife is: "newuser1" and the new Password is: "test123"!
I Edit this thread if i get mor infos etc...
with this SQL Commands you can make a .php file and run it via Internet (like XAMPP or Apache)
How to run SQL Commands without Navicat or phpMyAdmin:
<?php
// SET YOUR MYSQL INFOS HERE:
$HOST = ""; // YOUR HOST NAME
$USER = ""; // YOUR ROOT USER
$PASS = ""; // YOUR ROOT PW
$DB = ""; // YOUR DATABASE NAME
$SQL = ""; // YOUR SQL COMMAND
mysql_connect($HOST,$USER,$PASS) or die (mysql_error());
mysql_select_db($DB);
mysql_query($SQL) or die (mysql_error());
echo "Finished";
?>
Save this file as "sql.php" in your WebRoot folder (e.g.: "C:/xampp/htdocs/")
Fo example:
$HOST = "127.0.0.1";
$USER = "root";
$PASS = "root";
$DB = "newproject_db_auth";
$SQL = "UPDATE bg_user SET passwd = ('test123'), user_id = ('newuser1') WHERE user_id = ('SeaLife');";
=> Open in Google Chrome or Mozilla or browser of your choise: "http//127.0.0.1/sql.php"
The SQL Command is executed!
I Use this ways to administrate my Server (Security-Lastchaos)
Have Fun!
- MrBeaN - 09-28-2012
Nice guide
- SibaN - 09-29-2012
nice