Raised This Month: $12 Target: $400
 3% 

SQL Matches


Post New Thread Reply   
 
Thread Tools Display Modes
Author
WardPearce
Senior Member
Join Date: Apr 2017
Location: New Zealand
Plugin ID:
6359
Plugin Version:
1.0.0
Plugin Category:
Statistical
Plugin Game:
Counter-Strike: GO
Plugin Dependencies:
    Servers with this Plugin:
     
    Plugin Description:
    Saves CS:GO matches into a SQL database, includes web script.
    Old 12-06-2018 , 01:39   SQL Matches
    Reply With Quote #1

    Looking for the SQL Matches remake?
    https://forums.alliedmods.net/showthread.php?t=326644

    SQL Matches

    I was looking around for a script what did something like this, couldn't find anything so I decided to create my own.

    Setup tutorial on github.

    Preview:




    Download:
    https://github.com/WardPearce/Sourcemod-SQLMatches

    Last edited by WardPearce; 10-20-2020 at 19:43. Reason: Added new rewrite
    WardPearce is offline
    gildevanaraujo
    Senior Member
    Join Date: Oct 2018
    Location: Brazil
    Old 12-06-2018 , 10:06   Re: SQL Matches
    Reply With Quote #2

    I'm doing everything right, but no match appears on the page. Did I do something wrong?

    Image:
    Attached Images
    File Type: jpg Screenshot_1.jpg (69.4 KB, 745 views)
    gildevanaraujo is offline
    WardPearce
    Senior Member
    Join Date: Apr 2017
    Location: New Zealand
    Old 12-06-2018 , 10:20   Re: SQL Matches
    Reply With Quote #3

    Have matches been saved into your database?
    WardPearce is offline
    gildevanaraujo
    Senior Member
    Join Date: Oct 2018
    Location: Brazil
    Old 12-06-2018 , 10:24   Re: SQL Matches
    Reply With Quote #4

    Quote:
    Originally Posted by WardPearce View Post
    Have matches been saved into your database?

    Code:
    "sql_matches"
    	{
        "driver"            "mysql"
        "host"                "localhost"
        "database"            "sql_matches"
        "user"                "*****"
        "pass"                "****"
        //"timeout"            "0"
        "port"            "3306"
    Code:
    <?php
    $site_name = "Tabela de Jogos - Kingdom Server"; // Name of Site
    
    $api_key = "0AD31C84B7949E54DF41F1166*******"; // Steam API Key
    
    $servername = "localhost"; // Server IP
    $username = "****"; // DB Username
    $password = "****"; // DB Password
    $dbname = "sql_matches"; // DB Name
    
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    ?>

    Last edited by gildevanaraujo; 12-06-2018 at 10:25.
    gildevanaraujo is offline
    deezcnuts
    New Member
    Join Date: Dec 2018
    Location: India
    Old 12-13-2018 , 07:27   Re: SQL Matches
    Reply With Quote #5



    Hi, are there any cvars for this plugin?
    I have added the plugin and added it to the web server, but unable to see games. Does it detect demo files automatically or need some specific directory?
    Thank you for your plugin!

    Edit: What cvars are needed for SourceTV in server.cfg(if any)
    __________________

    Last edited by deezcnuts; 12-13-2018 at 12:47.
    deezcnuts is offline
    WardPearce
    Senior Member
    Join Date: Apr 2017
    Location: New Zealand
    Old 12-16-2018 , 01:47   Re: SQL Matches
    Reply With Quote #6

    Hey, all you need to do is add the database details into databases.cfg. The plugin doesn't interact with demos.
    WardPearce is offline
    Lubricant Jam
    AlliedModders Donor
    Join Date: Oct 2016
    Location: United Kingdom
    Old 12-17-2018 , 08:20   Re: SQL Matches
    Reply With Quote #7

    You need to protect your GET requests from SQL injections.
    Lubricant Jam is offline
    vikir
    Junior Member
    Join Date: Jun 2018
    Old 12-21-2018 , 10:56   Re: SQL Matches
    Reply With Quote #8

    Plugin created SQL tables in database, after that no entries, all empty, match finished no games in DB... atleast with splewis PUG setup. Anu help ?

    Last edited by vikir; 12-21-2018 at 10:57.
    vikir is offline
    WardPearce
    Senior Member
    Join Date: Apr 2017
    Location: New Zealand
    Old 12-30-2018 , 18:30   Re: SQL Matches
    Reply With Quote #9

    Updated github, should be fixed now.
    WardPearce is offline
    neploho
    Member
    Join Date: Jul 2010
    Old 01-01-2019 , 05:44   Re: SQL Matches
    Reply With Quote #10

    Hello!

    Quote:
    L 01/01/2019 - 158:14: SourceMod error session started
    L 01/01/2019 - 158:14: Info (map "de_dust2") (file "errors_20190101.log")
    L 01/01/2019 - 158:14: [SM] Exception reported: Configuration "sql_matches" not found
    L 01/01/2019 - 158:14: [SM] Blaming: sqlmatch.smx
    L 01/01/2019 - 158:14: [SM] Call stack trace:
    L 01/01/2019 - 158:14: [SM] [0] SetFailState
    L 01/01/2019 - 158:14: [SM] [1] Line 10, sqlmatch.sp::OnPluginStart
    L 01/01/2019 - 158:14: [SM] Unable to load plugin "sqlmatch.smx": Error detected in plugin startup (see error logs)
    Quote:
    "sql_matches"
    {
    "driver" "mysql"
    "host" "localhost"
    "database" "sql_matches"
    "user" "sql_matches"
    "pass" "*********"
    //"timeout" "0"
    "port" "3306"
    }
    Quote:
    <?php
    $site_name = "Matches"; // Name of Site

    $api_key = "1C7EF803A7AFEEA5BA**********"; // Steam API Key

    $servername = "localhost"; // Server IP
    $username = "sql_matches"; // DB Username
    $password = "***********"; // DB Password
    $dbname = "sql_matches"; // DB Name

    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
    }
    ?>

    Last edited by neploho; 01-01-2019 at 05:51.
    neploho is offline
    Reply


    Thread Tools
    Display Modes

    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 11:54.


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