Request for a useful tool for admins :)

~~RumorUS~~ · 04/16/2011, 09:15

A tool would be great that a server admin can give to his GMs which works this way:

1) I can define my own mysql server ip, port, and password into the program.
2) It must be made in a way so that he cannot see the pass and all this to the database...
3) He clicks a button called Refresh Admin Rights (or something like this).
4) The program finds his IP address and updates the database of server with his new IP.
5) Now the program does "/reload a"

This way if you have GM who have different IP each day they can fix it themselves while you are asleep :P.

I'm not really good at making things like this so I have to request it. I can provide English and Spanish translation.

Milchschokolade · 04/16/2011, 10:11

hmm..
ich werd mich mal ransetzen.

»Côoper«™ · 04/16/2011, 11:14

Doesn't it work with a proxy server?

I think that changes by it self whenever your ip changes, but i am not sure about it

~~RumorUS~~ · 04/16/2011, 13:26

idk but chocolate mind typing it in a way I can understand ?

Milchschokolade · 04/16/2011, 13:34

If you want the tool...vote for "Ja"

atag · 10/20/2011, 05:26

Here is a minimalist version

Spoiler

PHP Code:


			
<?php

/*



Metin2 admin-reload by ATAG



*/

//-------CONFIGURATION--------

$IP="123.456.123.456"; //server IP, it _MUST_ be adminpage_ip1 in CONFIG!

$Port=13000; //server port

$api_pass="SHOWMETHEMONEY";



$db_addr="localhost";

$db_user="mt2";

$db_pass="mt2!@#";

//-----END CONFIGURATION------



function getRealIP() //proxy support, tested with Squid

{

    if (!empty($_SERVER['HTTP_X_FORWARDED_FOR']))

    {

      $ip=$_SERVER['HTTP_X_FORWARDED_FOR'];

    }

    else

    {

      $ip=$_SERVER['REMOTE_ADDR'];

    }

    return $ip;

}



function doRefresh()

{

global $IP, $Port, $api_pass;

//Metin2 Bash-Panel by .Infinity

$socket = socket_create (AF_INET, SOCK_STREAM, SOL_TCP);

$result = socket_connect ($socket, $IP, $Port);

$query = "\x40".$api_pass."\x0A\x40RELOAD A\x0A";

$query_size = strlen($query);

$write_res = socket_write($socket, $query, $query_size);

$recv_res = socket_recv($socket, $output, 5056, 0);

if ($recv_res==31) { //i'm not sure about this :-/

    return "<br/><b>Frissítés sikeres, most már beléphetsz a játékba.</b>"; //success, you can log into the game now

} else {

    return "<br/><b>Hiba a frissítés során! Manuálisan kell elvégezni, sorry :(</b>"; //Error during the update! Do it manually, sorry

}

socket_close($socket);    

}

?>

<html>

    <head>

        <title>Admin reload</title>

    </head>

    <body>

<?php

if ($_POST['refresh']) {

    $con= mysql_connect($db_addr,$db_user,$db_pass) || die(mysql_error());

    $query="SELECT COUNT(*) FROM common.gmhost WHERE mIP='".getRealIP()."'";

    $result=mysql_query($query);



    $count=mysql_result($result,0);

    mysql_free_result($result);



    if ($count==0) {

        $query="INSERT INTO common.gmhost SET mIP='".getRealIP()."'";

        $res=mysql_query($query) || die(mysql_error());

        if ($res) {

            echo "IP-d (".getRealIP().") felvéve a listába, frissítés...<br/>"; //your ip was successfully added to the list

            

            echo doRefresh();

            

        } else {

            echo "Nem tudtam hozzáadni a listához, sorry :("; //i culdn't add your IP to the list, sorry

        }

    } else {

        echo "Már benne van az ip-d a listában (".getRealIP().")<br/>"; //you IP is already included

    }



    mysql_close();

} elseif ($_POST['reload']) {

    echo doRefresh();

} else {

?>

    <center>

        <form method="POST">

            <div id="input">

            <br />

            <br />

            <input type="submit" name="refresh" value="Add my IP!"/>

            <br />

            <br />

            <br />

            </div>

            <input type="submit" name="reload" value="Reload only!"/>

            <br />

            <br />

            </b>

        </form>

    </center>

    </div><?php } ?>

    </body>

</html>

PS: I'm not a php/html expert