[mickael002]

Hello,

(Sorry for my bad english, i'm french)

I have a problem for get a info from database.

I have this error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':1:21011029' at line 1

Script :

PHP Code:

#include <sourcemod>
#include <sdktools>
#include <sdkhooks>
#include <morecolors>

#define PLUGIN_VERSION "1.0"
#define MAX_LINE_WIDTH 60
#define MAX_AUTHID_LENGTH 50


new Handle:db;
new DEBUG = 1

new String:steamIdSave[64][255];



public Plugin:myinfo =
{
    name = "",
    author = "Mickael",
    description = "Regenere le mot de passe de la boutique vip",
    version = PLUGIN_VERSION,
    url = "www.team-ninja.fr"
}

public OnPluginStart()
{
    // Loading plugin translations.
    LoadTranslations("cadeau_noel.phrases");
    
    RegConsoleCmd("sm_getinfosql", Command_getinfosql);
    
    SQL_TConnect(LoadMySQLBase, "default");
}


public Command_getinfosql(client, args)
{
    get_data_forcmd(client);
}

public get_data_forcmd(client){        
        if (db != INVALID_HANDLE)
        {        
            decl String:steamId[64];
            GetClientAuthString(client, steamId, sizeof(steamId));
            steamIdSave[client] = steamId;
            
            decl String:buffer[250];
            (Format(buffer, sizeof(buffer), "SELECT mdp FROM vip_membres WHERE steamid = '%s'", steamIdSave[client]))
            
            PrintToChat(client, "Votre SteamId : %s", steamIdSave[client]);

            if(DEBUG == 1){
                PrintToServer("DEBUG: Action:initPlayerBase (%s)", buffer);
            }
            SQL_TQuery(db, SQLDataLoad, buffer, client);
        }
}
public LoadMySQLBase(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    if (hndl == INVALID_HANDLE)
    {
        PrintToServer("Failed to connect: %s", error)
        db = INVALID_HANDLE;
        return;
    } else {
        PrintToServer("DEBUG: DatabaseInit (CONNECTED)");
    }

    db = hndl;
} 


Can you help me plz ?

[berni]

Originally Posted by mickael002 PHP Code:             steamIdSave[client] = steamId;

You can't copy arrays like this, you have to use strcopy to copy a String.

PHP Code:             (Format(buffer, sizeof(buffer), "SELECT mdp FROM vip_membres WHERE steamid = '%s'", steamIdSave[client]))

Why did put this in ( ) ? You only have to put a ; at the end.

[mickael002]

I have changed to :

PHP Code:

public get_data_forcmd(client){        
        if (db != INVALID_HANDLE)
        {        
            decl String:steamId[64];
            GetClientAuthString(client, steamId, sizeof(steamId));
            strcopy(steamIdSave[client], sizeof(steamIdSave[client]), steamId);
            
            decl String:buffer[250];
            Format(buffer, sizeof(buffer), "SELECT mdp FROM vip_membres WHERE steamid = '%s'", steamIdSave[client]);
            
            PrintToChat(client, "Votre SteamId : %s", steamIdSave[client]);

            if(DEBUG == 1){
                PrintToServer("DEBUG: Action:initPlayerBase (%s)", buffer);
            }
            SQL_TQuery(db, SQLDataLoad, buffer, client);
    } 


But i have now a lot of errors :

- error 001: expected token: "]", but found "-identifier-" (line : strcopy(steamIdSave[client], sizeof(steamIdSave[client]), steamId); ) x2
- error 029: invalid expression, assumed zero (idem line)
fatal error 127: too many error message on one line

Originally Posted by berni You can't copy arrays like this, you have to use strcopy to copy a String. Why did put this in ( ) ? You only have to put a ; at the end.

[berni]

the client isn't relevant for sizeof() for the compiler.

Instead of:

PHP Code:

            decl String:steamId[64];
            GetClientAuthString(client, steamId, sizeof(steamId));
            strcopy(steamIdSave[client], sizeof(steamIdSave[client]), steamId); 


You can just do:

PHP Code:

GetClientAuthString(client, steamIdSave[client],  sizeof(steamIdSave[])); 


But I don't understand why there is a global array with size of 64.
If you want to keep track of SteamID's you have to use a dynamic array, which can hold unlimited steamID's.

[mickael002]

Thanks !

PHP Code:

public get_data_forcmd(client){        
        if (db != INVALID_HANDLE)
        {        
            decl String:steamId[64];
            GetClientAuthString(client, steamId, sizeof(steamId));
            
            decl String:buffer[250];
            Format(buffer, sizeof(buffer), "SELECT mdp FROM vip_membres WHERE steamid = '%s';", steamId);
            
            PrintToChat(client, "Votre SteamId : %s", steamId);

            if(DEBUG == 1){
                PrintToServer("DEBUG: Action:initPlayerBase (%s)", buffer);
            }
            SQL_TQuery(db, SQLDataLoad, buffer, client);
        }
} 


Working perfectly !

Originally Posted by berni the client isn't relevant for sizeof() for the compiler. Instead of: PHP Code:             decl String:steamId[64];             GetClientAuthString(client, steamId, sizeof(steamId));             strcopy(steamIdSave[client], sizeof(steamIdSave[client]), steamId);  You can just do: PHP Code: GetClientAuthString(client, steamIdSave[client],  sizeof(steamIdSave[]));  But I don't understand why there is a global array with size of 64. If you want to keep track of SteamID's you have to use a dynamic array, which can hold unlimited steamID's.