[HOW TO]Administrate Server

[SeaLife]

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!