[creeperdank]

But my game server is not on my computer. Its hosted by http://www.gameservers.com

Do i need that php script and if so where should i putt it.

[moonboi03]

i guess ima have to scratch this mod from my server...

thanx for ur help

[Cyb3rH4Xter]

Originally Posted by moonboi03 i guess ima have to scratch this mod from my server... thanx for ur help

Yesah, but gungame still works, huh?

[Cyb3rH4Xter]

Originally Posted by creeperdank But my game server is not on my computer. Its hosted by http://www.gameservers.com Do i need that php script and if so where should i putt it.

Okey, let's collect what we've got untill know:

You have a working gungame server, right?

You host it at www.gameservers.com.

You have a webserver at webhostingbuzz.

You have a mysql database named amx at webhostingbuzz?

What you still need:

Add you game server ip to the cpanel to allow mysql connections from your gameserver.

Put the ggsql cvars into your gungame.cfg and edit the info so it fits with your connection info to your mysql database.

What you can wait with but still need to do later:

Upload the gungamesql_example.php to your webhost and configure it to work with your stats.



If you are unshure about anything, please ask me.

[Cyb3rH4Xter]

Btw, i always get this error:

L 05/18/2009 - 20:02:01: [gungame_sql.amxx] Could not execute query "INSERT INTO `gg_stats` ( `authid`, `wins`, `lastname`, `timestamp`, `points`, `serverip` ) VALUES ( '', '0', '', '0', '0', '192.168.1.5:27015' );" -- Error #1062: Duplicate entry '' for key 1

[phoenixlipo]

Perhaps the best part about the Gun Game, and the Gun Game server I play on is that not many people know about it. This means a lot less hackers and a more personal connection with the players you are playing Counter-Strike: Source with. If you have a great Gun Game server, post it here as I will do the same.

[viktor6]

Help

PHP Code:

<?php
echo "Updating GG Top 10 Statistics...<br>";


 $amx_sql_host    = "localhost";
 $amx_sql_user    = "root";
 $amx_sql_pass    = "123456";
 $amx_sql_db    = "gg_stats";
 
      $db = mysql_connect($amx_sql_host,$amx_sql_user,$amx_sql_pass);
     mysql_select_db($amx_sql_db,$db);
 

$ch = curl_init();
$timeout = 5; // set to zero for no timeout
curl_setopt ($ch, CURLOPT_URL, 'http://my site/gungame.stats');


curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_CONNECTTIMEOUT, $timeout);
$file_contents = curl_exec($ch);
curl_close($ch);
$lines = array();
$lines = explode("\n", $file_contents);

// display file line by line
$details = array();

foreach($lines as $line_num => $line) {
    
    $details = explode( "\t", $line );
    // 0 - authid
    // 1 - wins
    // 2 - lastname
    // 3 - timestamp
    // 4 - points
        
     $details[2] = htmlspecialchars($details[2]);
     
     $query = "SELECT * FROM gg_stats WHERE authid='$details[0]'";
     $result = mysql_query( $query, $db );
     $rows = mysql_num_rows($result);
     $myrow = mysql_fetch_array( $result );
     
     if( $rows > 0 &&  strlen( $details[0] ) > 5 ){
     // There is already a record for this user, we need to update this record
     
     // Find out what is different
     if( strcmp($myrow["wins"], $details[1]) != 0 ){
         printf("Wins Differ, new wins: <b>%s</b> | old wins: %s<br>", $details[1], $myrow["wins"] );
        $query = "UPDATE gg_stats SET wins='$details[1]' WHERE authid='$details[0]'";
        mysql_query( $query );        
        
    }if( strcmp($myrow["lastname"], $details[2]) != 0 ){
         printf("Lastname Differs, new name: %s<br>", $details[2] );
        $query = "UPDATE gg_stats SET lastname='$details[2]' WHERE authid='$details[0]'";
        mysql_query( $query );
        
    }if( strcmp($myrow["timestamp"], $details[3]) != 0 ){
         printf("Timestamp Differs, new timestamp: %s<br>", $details[3] );
        $query = "UPDATE gg_stats SET timestamp='$details[3]' WHERE authid='$details[0]'";
        mysql_query( $query );
    }
     
     
     }elseif( strlen( $details[0] ) > 5 ){
         // New user, we need to add them
         $query = "INSERT INTO gg_stats ( authid, wins, lastname, timestamp, points  )
                        VALUES ( '$details[0]', '$details[1]', '$details[2]', '$details[3]', '$details[4]' )";
          mysql_query( $query );
          
          printf("New user <b>%s</b><br>", $details[0] );
     }
     
     
    
}


echo "<br>Done.";

?>

Updating GG Top 10 Statistics... Fatal error: Call to undefined function curl_init() in /home/www/test/test.php on line 14

[8088]

http://php.net/manual/en/curl.setup.php

[alexinno]

thank you Krim // Relgam.com for the php script, maybe you'll update it for new gungame plugin
also i wanned to say that you can use this to update mysql table periodically with a cronjob on linux if you run a web server on the same machine where the gungame server is runing
Example: create a file , i named ggupdate.sh , i chmoded it to be executable (chmod +x ggupdate.sh) and write this lines in it

/bin/cp -rf /home/games/gungame/cstrike/gungame.txt /home/web/public_html/ 
chown web:apache /home/web/public_html/gungame.txt 
php -q /root/cronjobs/gungame_update.php

the gungame_update.php is the php script posted by Krim // Relgam.com
after this add the cronjob, edit crontab:

crontab -e

add a line to run this script , i'm runing it every 15 min

*/15 * * * * /root/cronjobs/ggupdate.sh >/dev/null 2>&1

i'm runing this cronjob as root , but you can run it as any user you want