Raised This Month: $120 Target: $400
 30% 

SQL Matches


Post New Thread Reply   
 
Thread Tools Display Modes
Author
WardPearce
Junior Member
Join Date: Apr 2017
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 , 02:39   SQL Matches
    Reply With Quote #1

    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
    WardPearce is offline
    gildevanaraujo
    Member
    Join Date: Oct 2018
    Location: Brazil
    Old 12-06-2018 , 11: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, 42 views)
    gildevanaraujo is offline
    WardPearce
    Junior Member
    Join Date: Apr 2017
    Old 12-06-2018 , 11:20   Re: SQL Matches
    Reply With Quote #3

    Have matches been saved into your database?
    WardPearce is offline
    gildevanaraujo
    Member
    Join Date: Oct 2018
    Location: Brazil
    Old 12-06-2018 , 11: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 11:25.
    gildevanaraujo is offline
    deezcnuts
    New Member
    Join Date: Dec 2018
    Location: India
    Old 12-13-2018 , 08: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 13:47.
    deezcnuts is offline
    WardPearce
    Junior Member
    Join Date: Apr 2017
    Old Today , 02: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
    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 13:31.


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