I have a game stats plugin that outputs a link that you have to manually set as
Code:
#define pgL_sql_files "http://192.168.1.250"
, Then the game server outputs
Code:
stats15/fs_easyblock?&authid=STEAM_0:1:3447830
and i'd like to cross reference that id with data generated from a sql database. For example, the database has map_id 1, mapname bhop_fastrun, authid, STEAM_, name playername, time 1234, date 1234 . The plugin owner advised me to create my own motd based off the sql database, since he didnt have access to the pql_sql_file webserver files.
link corresponds from the game server to the webserver
http://192.168.1.250/stats15/fs_easy...AM_0:1:3447830
easiest method to generate this data and output it on a webpage for them to see? I looked at nuclears sql_file setup and there is alot of data to look at but heres a reference :
https://forums.alliedmods.net/showthread.php?t=130417
example sites
https://www.kz-endo.us/records/STEAM...Id=10&typeId=1
I took this snippet from an example from HLxce stats. The sql code to access the data is relatively easy to understand, but when it comes to using PHP to output it thats where im having trouble.
Code:
$q = "SELECT * FROM kz_pro15 WHERE mapname='". $_GET['map'] ."' ORDER BY time, name LIMIT 15";
$r = mysql_query($q, $sql);