[zhulo]

Hello. I wanted to find some tutorials and informations about this but I did not find anything understandable. So I decided to ask for help. I wanna make a server status for my website, which will get informations right from the server through the mysql (or some better connection server/web if u know). I can make the pawn code but i dont know how to connect it to the web.

Here are some things which I wanna connect (pawn)

Connected players count and max players:

PHP Code:

public plugin_init()
{
    g_maxplayers = get_maxplayers()
}

getconnected()
{
    static iConnected, id
    iConnected = 0
    
    for (id = 1; id <= g_maxplayers; id++)
    {
        if (is_user_connected(id))            
            iConnected++
    }
    
    return iConnected;
} 


Current map name:

PHP Code:

    new map[32]
    get_mapname(map, 31) 


Of course there will be much more informations, this is just an example.

So, when I have the pawn code and the .amxx plugin, now I need to take this informations right to the web (php).

The table should look like this:

[IMG]http://img338.**************/img338/5376/statuuus.jpg[/IMG]


Can someone help me to make it?

[YamiKaitou]

Better yet, query the server through the master servers, you can get all that information plus more. No need to an AMXX plugin

[zhulo]

I need to get the informations right from the plugins.

[YamiKaitou]

But you can get all 4 columns from just querying the master servers, no need for a plugin.

If you do require more than that, maybe set them to a public cvar and then query the server rules and pull the values that way? Or use sockets?

[zhulo]

Im using it now, but it is very slow and it takes much more time to connect, so the page is loading longer...

I have a reasons for make it like I said...

[lucas_7_94]

What information you need ? if its a cvar like MrYami says , you can use sockets, or a Query Source.

[zhulo]

ok, I need the current map, current players count, max players, and time left.

[lucas_7_94]

Use this, its better to load or store info in SQL.

[zhulo]

I am using it now, but, like I said, its very slow, so, I need to get info right from the amx plugins.

[lucas_7_94]

Spoiler

<?php
    $mysql_host = "localhost";
    $mysql_db = "test";
    $mysql_user = "root";
    $mysql_pass = "root";
    
    $con = mysql_connect( $host , $mysql_user, $mysql_pass);
    $mysql_select_db($mysql_db, $con);
    
    $result = mysql_query("SELECT * FROM ServerTableInfo");
    
    echo "<table border='1'><tr><th>Current Map</th><th>Players</th><th>Timeleft</th></tr>";
    
    while ( $row = mysql_fetch_array( $result ) ) 
    {
        echo "<tr>";
        echo "<td>" . $row['ColumWithMap'] . "</td>";
        echo "<td>", $row['ColumnWithPlayersPlaying'], "/", $row['ColumWithMaxPlayersInServer'],"</td>";
        echo "<td>". $row['TimeLeftServer'] ."</td>";
        echo "</tr>";
    }
    echo "</table>";

    mysql_close($con);
?>

Well , this dont have relation with amxx i think , you should post in offtopic ..