[bazhenov93]

hi, I founded some tutorials here, but I can't understand it! I don't understand nothing in php and mysql.. and I want to learn just the basic..

Can anyone please make for me a simple function?

php-->
save & read data from sql

1. Change my name


sql -->
read data, send to server..

1. function will save the choosen name into sql, plugin will read database, when client join the server, the name will auto changed

plugin-->
function that read the saved/founded on sql


please

[Exolent[jNr]]

PHP code:

Spoiler

PHP Code:

<?php

// Configure the MySQL settings
$mysql_config = array(
    'host' => 'localhost',
    'user' => 'root',
    'pass' => '',
    'db'   => 'amxx'
);

// Connect to the MySQL server
$mysqli = new mysqli($mysql_config['host'], $mysql_config['user'], $mysql_config['pass'], $mysql_config['db']);

// Check if connected
if($mysqli)
{
    // Reading data from the table
    // ==========================================
    
    // Query the table for results
    $steamid = 'STEAM_0:1:23456';
    $query = $mysqli->query("SELECT * FROM mytable WHERE steamid = '" . $mysqli->real_escape_string($steamid) . "';");
    
    // Check if valid query result
    if($query)
    {
        // Grab data from query
        $data = $query->fetch_array();
        
        // Format of data:
        // $data['column_name'] = 'value';
    }
    
    // ==========================================
    
    // Saving data to the table
    // ==========================================
    
    // Know what data we are saving
    $name = 'Exolent';
    
    // Query the table for setting data
    $query = $mysqli->query("REPLACE INTO mytable (steamid, name) VALUES ('" . $mysqli->real_escape_string($steamid) . "', '" . $mysqli->real_escape_string($name) . "');");
    
    // ==========================================
    
    // Close the connection
    $mysqli->close();
}

Pawn code:

Spoiler

#include <amxmodx>
#include <sqlx>
#include <fakemeta>

// Max players possible, keep at 32 unless VALVe somehow makes more than 32 players
#define MAX_PLAYERS 32

// SQL tuple for the connections
new Handle:gSqlTuple = Empty_Handle;

// The current threaded query index so we don't overlap threaded queries for a player
new gThreadIndex[MAX_PLAYERS + 1];

// Use plugin_cfg() since it is after the sql.cfg is executed
public plugin_cfg()
{
    // Create the SQL tuple from amx_sql_* cvars
    gSqlTuple = SQL_MakeStdTuple();
    
    // Grab any players that have connected
    new players[32], pnum;
    get_players(players, pnum);
    
    // Check their names
    while(pnum)
    {
        CheckName(players[--pnum]);
    }
}

public client_putinserver(id)
{
    // Check if already made the tuple
    if(gSqlTuple != Empty_Handle)
    {
        // Query player for name
        CheckName(id);
    }
}

public client_infochanged(id)
{
    // Check if the SQL tuple has been made and if player is connected
    if(gSqlTuple != Empty_Handle && is_user_connected(id))
    {
        // Grab old and new names
        new oldName[32], newName[32];
        get_user_name(id, oldName, charsmax(oldName));
        get_user_info(id, "name", newName, charsmax(newName));
        
        // Check if name changed
        if(!equal(oldName, newName))
        {
            // Check new name against the database
            CheckName(id, newName);
        }
    }
}

CheckName(id, name[32] = "")
{
    // Check if name was passed to function
    if(!name[0])
    {
        // Grab current name instead
        get_user_name(id, name, charsmax(name));
    }
    
    // Get player's SteamID for the query
    new steamID[35];
    get_user_authid(id, steamID, charsmax(steamID));
    
    // Format the query
    new query[128];
    formatex(query, charsmax(query), "SELECT name FROM mytable WHERE steamid = '%s';", steamID);
    
    // Prepare data for the query
    new data[4];
    data[0] = id;
    data[1] = get_user_userid(id);
    data[2] = ++gThreadIndex[id];
    data[3] = EncodeText(name);
    
    // Query the MySQL server for data
    SQL_ThreadQuery(gSqlTuple, "QuerySelectData", query, data, sizeof(data));
}

public QuerySelectData(failstate, Handle:query, errcode, error[], data[], dataSize, Float:queueTime)
{
    // Check if the query failed at all
    switch(failstate)
    {
        case TQUERY_CONNECT_FAILED: log_amx("Failed to connect for query: %s", error);
        case TQUERY_QUERY_FAILED  : log_amx("Failed query: %s", error);
        default:
        {
            // Grab player ID from data
            new id = data[0];
            
            // Check if player is connected and matches user id from data
            if(is_user_connected(id) && get_user_userid(id) == data[1])
            {
                // Check if threaded query index matches
                if(data[2] == gThreadIndex[id])
                {
                    // Check if the query has results
                    if(SQL_NumResults(query))
                    {
                        // Grab the player's name that we are checking
                        new name[32];
                        DecodeText(data[3], name, charsmax(name));
                        
                        // Grab the name from the database
                        new found[32];
                        SQL_ReadResult(query, 0, found, charsmax(found));
                        
                        // Check if names match
                        if(!equal(name, found))
                        {
                            // Change name back
                            set_user_info(id, "name", found);
                        }
                    }
                }
            }
        }
    }
}

// Functions for encoding/decoding strings to integers
EncodeText(const string[])
{
    return engfunc(EngFunc_AllocString, string);
}
DecodeText(const string, output[], output_len)
{
    return global_get(glb_pStringBase, string, output, output_len);
}

Nothing in here creates the table, though.

[.Dare Devil.]

Originally Posted by Exolent[jNr] PHP code: Spoiler PHP Code: <?php // Configure the MySQL settings $mysql_config = array(     'host' => 'localhost',     'user' => 'root',     'pass' => '',     'db'   => 'amxx' ); // Connect to the MySQL server $mysqli = new mysqli($mysql_config['host'], $mysql_config['user'], $mysql_config['pass'], $mysql_config['db']); // Check if connected if($mysqli) {     // Reading data from the table     // ==========================================          // Query the table for results     $steamid = 'STEAM_0:1:23456';     $query = $mysqli->query("SELECT * FROM mytable WHERE steamid = '" . $mysqli->real_escape_string($steamid) . "';");          // Check if valid query result     if($query)     {         // Grab data from query         $data = $query->fetch_array();                  // Format of data:         // $data['column_name'] = 'value';     }          // ==========================================          // Saving data to the table     // ==========================================          // Know what data we are saving     $name = 'Exolent';          // Query the table for setting data     $query = $mysqli->query("REPLACE INTO mytable (steamid, name) VALUES ('" . $mysqli->real_escape_string($steamid) . "', '" . $mysqli->real_escape_string($name) . "');");          // ==========================================          // Close the connection     $mysqli->close(); } Pawn code: Spoiler #include <amxmodx> #include <sqlx> #include <fakemeta> // Max players possible, keep at 32 unless VALVe somehow makes more than 32 players #define MAX_PLAYERS 32 // SQL tuple for the connections new Handle:gSqlTuple = Empty_Handle; // The current threaded query index so we don't overlap threaded queries for a player new gThreadIndex[MAX_PLAYERS + 1]; // Use plugin_cfg() since it is after the sql.cfg is executed public plugin_cfg() {     // Create the SQL tuple from amx_sql_* cvars     gSqlTuple = SQL_MakeStdTuple();         // Grab any players that have connected     new players[32], pnum;     get_players(players, pnum);         // Check their names     while(pnum)     {         CheckName(players[--pnum]);     } } public client_putinserver(id) {     // Check if already made the tuple     if(gSqlTuple != Empty_Handle)     {         // Query player for name         CheckName(id);     } } public client_infochanged(id) {     // Check if the SQL tuple has been made and if player is connected     if(gSqlTuple != Empty_Handle && is_user_connected(id))     {         // Grab old and new names         new oldName[32], newName[32];         get_user_name(id, oldName, charsmax(oldName));         get_user_info(id, "name", newName, charsmax(newName));                 // Check if name changed         if(!equal(oldName, newName))         {             // Check new name against the database             CheckName(id, newName);         }     } } CheckName(id, name[32] = "") {     // Check if name was passed to function     if(!name[0])     {         // Grab current name instead         get_user_name(id, name, charsmax(name));     }         // Get player's SteamID for the query     new steamID[35];     get_user_authid(id, steamID, charsmax(steamID));         // Format the query     new query[128];     formatex(query, charsmax(query), "SELECT name FROM mytable WHERE steamid = '%s';", steamID);         // Prepare data for the query     new data[4];     data[0] = id;     data[1] = get_user_userid(id);     data[2] = ++gThreadIndex[id];     data[3] = EncodeText(name);         // Query the MySQL server for data     SQL_ThreadQuery(gSqlTuple, "QuerySelectData", query, data, sizeof(data)); } public QuerySelectData(failstate, Handle:query, errcode, error[], data[], dataSize, Float:queueTime) {     // Check if the query failed at all     switch(failstate)     {         case TQUERY_CONNECT_FAILED: log_amx("Failed to connect for query: %s", error);         case TQUERY_QUERY_FAILED  : log_amx("Failed query: %s", error);         default:         {             // Grab player ID from data             new id = data[0];                         // Check if player is connected and matches user id from data             if(is_user_connected(id) && get_user_userid(id) == data[1])             {                 // Check if threaded query index matches                 if(data[2] == gThreadIndex[id])                 {                     // Check if the query has results                     if(SQL_NumResults(query))                     {                         // Grab the player's name that we are checking                         new name[32];                         DecodeText(data[3], name, charsmax(name));                                                 // Grab the name from the database                         new found[32];                         SQL_ReadResult(query, 0, found, charsmax(found));                                                 // Check if names match                         if(!equal(name, found))                         {                             // Change name back                             set_user_info(id, "name", found);                         }                     }                 }             }         }     } } // Functions for encoding/decoding strings to integers EncodeText(const string[]) {     return engfunc(EngFunc_AllocString, string); } DecodeText(const string, output[], output_len) {     return global_get(glb_pStringBase, string, output, output_len); } Nothing in here creates the table, though.

Max players possible, keep at 32 unless VALVe somehow makes more than 32 players

Do you know something about this?

[Exolent[jNr]]

Originally Posted by .Dare Devil. Do you know something about this?

I know it's not possible unless the game is rewritten, which is not likely to happen.

[bazhenov93]

Exolent, thanks, but i'm sorry if you wasted time, because i tried and no result, because I don't understand nothing in this

I learned something in pawn, but php and mysql is hard for me, I don't know why