[iskenderkebab33]

Hey, as the title say, how to select from a database and print out in chat, example: ("SELECT * FROM test WHERE name='%s'", userName);

and then in chat: You have .. Points.

[CliptonHeist]

PHP Code:

public void SomeFunction(int Client)
{
    if(!IsClientInGame(Client)) return;

    char sQuery[1024], userName[64];
    GetClientName(Client, userName, sizeof(userName));
    g_Database.Escape(userName, userName, sizeof(userName));

    Format(sQuery, sizeof(sQuery), "SELECT * FROM test WHERE name='%s';", userName);
    g_Database.Query(SQL_SelectTest, sQuery, GetClientUserId(Client));
}

public void SQL_SelectTest(Database db, DBResultSet results, const char[] sError, any data)
{
    if(results == null)
    {
        LogError("MySQL Query Failed: %s", sError);
        return;
    }

    if(!results.FetchRow()) return;

    int Client = GetClientOfUserId(data);
    if(!IsClientInGame(Client)) return;

    int pointsCol;
    results.FieldNameToNum("points", pointsCol);
    int points = results.FetchInt(idCol);
    PrintToChat(Client, "You have %i Points.", points);
} 


Obviously you need a valid database connection before doing any of this which you can see how to do here: https://wiki.alliedmods.net/SQL_(Sou...)#Connecting_2

[iskenderkebab33]

Originally Posted by CliptonHeist PHP Code: public void SomeFunction(int Client) {     if(!IsClientInGame(Client)) return;     char sQuery[1024], userName[64];     GetClientName(Client, userName, sizeof(userName));     g_Database.Escape(userName, userName, sizeof(userName));     Format(sQuery, sizeof(sQuery), "SELECT * FROM test WHERE name='%s';", userName);     g_Database.Query(SQL_SelectTest, sQuery, GetClientUserId(Client)); } public void SQL_SelectTest(Database db, DBResultSet results, const char[] sError, any data) {     if(results == null)     {         LogError("MySQL Query Failed: %s", sError);         return;     }     if(!results.FetchRow()) return;     int Client = GetClientOfUserId(data);     if(!IsClientInGame(Client)) return;     int pointsCol;     results.FieldNameToNum("points", pointsCol);     int points = results.FetchInt(idCol);     PrintToChat(Client, "You have %i Points.", points); }  Obviously you need a valid database connection before doing any of this which you can see how to do here: https://wiki.alliedmods.net/SQL_(Sou...)#Connecting_2

thanks, will do it.

[iskenderkebab33]

and how to get text row like from "sirname" ("SELECT * FROM test WHERE name='%s', userName") and print it out in chat: Your sirname is X.

[CliptonHeist]

PHP Code:

public void SomeFunction(int Client) 
{ 
    if(!IsClientInGame(Client)) return; 

    char sQuery[1024], userName[64]; 
    GetClientName(Client, userName, sizeof(userName)); 
    g_Database.Escape(userName, userName, sizeof(userName)); 

    Format(sQuery, sizeof(sQuery), "SELECT * FROM test WHERE name='%s';", userName); 
    g_Database.Query(SQL_SelectTest, sQuery, GetClientUserId(Client)); 
} 

public void SQL_SelectTest(Database db, DBResultSet results, const char[] sError, any data) 
{ 
    if(results == null) 
    { 
        LogError("MySQL Query Failed: %s", sError); 
        return; 
    } 

    if(!results.FetchRow()) return; 

    int Client = GetClientOfUserId(data); 
    if(!IsClientInGame(Client)) return; 

    int nameCol; 
    results.FieldNameToNum("sirname", nameCol); 
    char name[64]; results.FetchString(nameCol, name, sizeof(name)); 
    PrintToChat(Client, "Your sirname is %s.", name); 
} 


[iskenderkebab33]

how to print in chat to client if sirname is empty? like PrintToChat(client, "Sirname is empty. Please give a sirname"); thanks

[CliptonHeist]

PHP Code:

if(StrEqual(sName, "");
    PrintToChat(Client, "Surname is empty, please give surname.); 


[MAGNAT2645]

Better to use:

if ( sName[ 0 ] == '\0' ) // or even sName[ 0 ] == 0
    PrintToChat( Client, "Surname is empty, please give surname." );

It's better for performance.

[iskenderkebab33]

thanks you 2, gona test it

[iskenderkebab33]

and how to do a if() example:

if(sirname = "Tom")
{
PrintToChat(Client, "You sirname is Tom");
}
else
{
PrintToChat(Client, "You sirname is NOT Tom");
}