[r3D w0LF]

So, i am having a hard time dealing with SQL queries.

This is the first part (im using SQL_TConnect to connect on plugin start):

PHP Code:

    char mainQuery[512];
    Format(mainQuery, sizeof(mainQuery), "SELECT entry FROM table WHERE steamID LIKE '%s'", szAuth);
    SQL_TQuery(g_hEntriesDb, checkEntry, mainQuery, client); 


And this is the checkEntry part:

PHP Code:

public checkEntry(Handle:owner, Handle:handle, const String:error[], any:data)
{
    if(handle == INVALID_HANDLE)
    {
        PrintToConsole(data, "Error searching in database: %s", error);
        return;
    }

    char question[255];
    int i = 0;
    while(SQL_FetchRow(handle))
    {
        SQL_FetchString(handle, 0, question, sizeof(question));
        
        for(new j; j <= sizeof(g_serverEntry); j++)
        {
            if(strlen(g_serverEntry[j]))
            {
                if(StrEqual(g_serverEntry[j], question) == true)
                {
                    PrintToConsole(data, "Entry: %s has been found", question);
                } else
                {
                    PrintToConsole(data, "Entry: %s missing", question);
                }
                
            } else
            {
                break;
            }
        }
        i++;
    }
} 


This returns:

Entry: E1 has been found
Entry: E1 missing
Entry: E2 missing
Entry: E2 has been found

However when omitting

PHP Code:

 else
{
    PrintToConsole(data, "Entry: %s missing", question);
} 


It seems to run fine. Maybe is there something I am doing wrong?

[mug1wara]

"SELECT entry FROM table WHERE steamID LIKE '%s'", szAuth

I'd say that is your main problem (haven't really checked the rest of the code that well).

What the query tells me is; find anything in the steamID column that ends with an s.

To any of you out there... no, it doesn't matter if it's a string or not.

Replace LIKE with =

[r3D w0LF]

Originally Posted by mug1wara "SELECT entry FROM table WHERE steamID LIKE '%s'", szAuth I'd say that is your main problem (haven't really checked the rest of the code that well). What the query tells me is; find anything in the steamID column that ends with an s. To any of you out there... no, it doesn't matter if it's a string or not. Replace LIKE with =

isnt that how you prepare/format a query? (half-prepare anyway)
And no, = and LIKE didnt make a difference:

Entry: E1 missing
Entry: E2 missing
Entry: E1 has been answered
Entry: E2 has been answered

Yes, they have switched places this time, but thats because i changed the order they print in console.

EDIT: Here is the missing line

char szAuth[32];
GetClientAuthId(client, AuthId_Steam2, szAuth, sizeof(szAuth));

But either way, if the query was not formatted correctly i think it wouldnt return anything.

And also, the queries are in a remote database

[Fyren]

It's not clear what your problem is without knowing the data.

If your query returns two strings, "E1" and "E2", and your g_serverEntry array also has two non-empty values that are "E1" and "E2", then I would expect your function to print out exactly what you said it did in your first post.

[Powerlord]

LIKE doesn't do partial matches unless you use wildcards to tell it to. In SQL, _ matches a single character, and % matches any number of characters.

Bear in mind that to pass a % through a format function, you have to use %% instead.

[mug1wara]

Could you PrintToServer g_serverEntry please?

[r3D w0LF]

Originally Posted by mug1wara Could you PrintToServer g_serverEntry please?

I hardcoded it inside the plugin i am going to upload.

Here is a raw test plugin, the same issue persists, i thought this will be better than just posting pieces of the main plugin.
Same issue persists:

E1 and E2 are in database, server entries are E1, E2

Entry: E2 NOT found
Entry: E1 NOT found
Total results: 2
Entry: E1 found
Entry: E2 found

E3 and E4 are in database, server entries are E1, E2

Entry: E4 NOT found
Entry: E4 NOT found
Entry: E3 NOT found
Entry: E3 NOT found
Total results: 2

E2 and E3 are in database, server entries are E1, E2

Entry: E2 NOT found
Entry: E3 NOT found
Entry: E3 NOT found
Total results: 2
Entry: E2 found

EDIT: For some reason i replaced g_serverEntry with g_kvEntry

EDIT2: Also uploaded the database used for the plugin

[Ilusion9]

PHP Code:

    Format(g_kvEntry[0], sizeof(g_kvEntry), "E1");
    Format(g_kvEntry[1], sizeof(g_kvEntry), "E2"); 


use sizeof(g_kvEntry[]). with your code g_kvEntry[0] will take size 10 and not 255, but this is not the problem.

PHP Code:

for(new j; j <= sizeof(g_kvEntry); j++) 


correct: j < sizeof(g_kvEntry)

you have some minor errors in your code, you should solve them and then solve the big problem.

[r3D w0LF]

Originally Posted by Ilusion9 PHP Code:     Format(g_kvEntry[0], sizeof(g_kvEntry), "E1");     Format(g_kvEntry[1], sizeof(g_kvEntry), "E2");  use sizeof(g_kvEntry[]). with your code g_kvEntry[0] will take size 10 and not 255, but this is not the problem. PHP Code: for(new j; j <= sizeof(g_kvEntry); j++)  correct: j < sizeof(g_kvEntry) you have some minor errors in your code, you should solve them and then solve the big problem.

Yeah, thanks

Regarding this thread, nvm, i figured it out. Could mark it as solved.