Raised This Month: $32 Target: $400
 8% 

generate game stats from sql database


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Infamanious
Senior Member
Join Date: Dec 2005
Old 12-04-2022 , 06:04   generate game stats from sql database
Reply With Quote #1

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);
Infamanious is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 00:39.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode