[fricx]

Hello,

As topic says, sqlx module is returning data and assigning it to a variables. It works fine like this:

PHP Code:


SQL_ReadResult(Query, 8, data, 31) 


but how can I assign it to data[id] and make it unique for that player so it doesn't get overwritten on next query with other players db info.

I tried with:

PHP Code:


SQL_ReadResult(Query, 8, data[id], 31) 


but I am getting [AMXX] Run time error 4: index out of bounds.

[lucas_7_94]

new g_variable[33][33]

SQL_ReadResult( Query , 8 , g_variable[id] , charsmax(g_variable[]) )

[fricx]

Originally Posted by lucas_7_94 new g_variable[33][33] SQL_ReadResult( Query , 8 , g_variable[id] , charsmax(g_variable[]) )

So I have:

PHP Code:

global... overall_time[33][33]
...
SQL_ReadResult(Query, 14, overall_time[id], charsmax(overall_time[])) 


and when I do

PHP Code:


ShowSyncHudMsg(0, g_SyncObj[1], "Overall time: %s", overall_time[id]) 


I still get [AMXX] Run time error 4: index out of bounds

[lucas_7_94]

show complete load funcion please.

[Exolent[jNr]]

Explain exactly what you are retrieving from the database (what it's called, data type, etc.) and exactly how you want it stored into a variable.

[fricx]

Originally Posted by Exolent[jNr] Explain exactly what you are retrieving from the database (what it's called, data type, etc.) and exactly how you want it stored into a variable.

Hello,

I am doing a left inner join query, which executes successfully and gives me database fields that I am requesting. The query itself is working, and I am getting the data from database. For example this works:

PHP Code:


SQL_ReadResult(Query, 14, overall_time, 31) 


but what I want to do is to assign overall_time to this specific player, like overall_time[id], so I can use it to display this information via HUD(id) function only to that player. Like this:

PHP Code:


public Hud(id)
 {
      if(is_member[id])
       {
        set_hudmessage(0, 0, 0, -0.85, 0.01, 0, UPDATETIME+0.1, 0.5, 1.0, 1.0, -1)
        ShowSyncHudMsg(0, g_SyncObj[0], "Overall time: %s", overall_time[id])
      }
} 


Without [id], overall_time variable gets replaced by other player sql data when he connects to the server, and so on...

The query is called on register_client function.

Just to add that fields types in db are, int, varchar and float, maybe I am missing something.

The error I keep getting in server log is: [AMXX] Run time error 4: index out of bounds

Thank you for your reply.

[lucas_7_94]

new g_playername[33][33]

SQL_ReadResult( Query , numofcolumn , g_playername[ id ] , charsmax( g_playername[] ) )

client_print( index , print_chat, "The name in db is %s" , g_playername [ index ] )

For me always works , i repeat , if you can post code, will be great.