1.  format(g_sql_string,255,"SELECT * FROM `items` WHERE id='1'");

2.  format(g_sql_string,255,"INSERT into `inventory` (`authid`,`item`) values ('%s','%d')", authid, item_id);

3.  format(g_sql_string,255,"UPDATE `players` SET helmet=%d,armour=%d,leftarm=%d,rightarm=%d,legs=%d,boots=%d WHERE authid='%s'", g_player_helmet[id], g_player_armour[id], g_player_leftArm[id], g_player_rightArm[id], g_player_legs[id], g_player_boots[id], authid);

public player_load(id)
{
                       static authid[33],name[33];
                       new password[35];
                       get_user_authid(id,authid,32);
                       get_user_name (id,name,32);
                        
                       format(g_sql_string,255,"SELECT * FROM `players` WHERE authid='%s'",authid);
                       g_sql_query = SQL_PrepareQuery(g_sql_connect,g_sql_string);
                       if(!SQL_Execute(g_sql_query))
                       {
                        database_error(g_sql_query);
                       }
                        
                       new found;
                        
                       if(SQL_MoreResults(g_sql_query))
                       {
                        found = SQL_ReadResult(g_sql_query,0);
                       }
                        
                       if(found)
                       {
                        format(password,34,"%s",SQL_ReadResult(g_sql_query,3));
                          
                        g_player_helmet[id] = SQL_ReadResult(g_sql_query,5);
                        g_player_armour[id] = SQL_ReadResult(g_sql_query,6);
                        g_player_leftArm[id] = SQL_ReadResult(g_sql_query,7);
                        g_player_rightArm[id] = SQL_ReadResult(g_sql_query,8);
                        g_player_legs[id] = SQL_ReadResult(g_sql_query,9);
                        g_player_boots[id] = SQL_ReadResult(g_sql_query,10);
                        SQL_FreeHandle(g_sql_query);
                       }
                       else
                       {
                        client_print(id,print_chat,"%s xxx",PLUGIN_PREFIX);
                        client_print(id,print_chat,"%s xxx",PLUGIN_PREFIX);
                        client_print(id,print_chat,"%s xxx",PLUGIN_PREFIX);
                          
                        g_player_helmet[id] = 1;
                        g_player_armour[id] = 1;
                        g_player_leftArm[id] = 1;
                        g_player_rightArm[id] = 1;
                        g_player_legs[id] = 1;
                        g_player_boots[id] = 1;
                        SQL_FreeHandle(g_sql_query);
                          
                        player_save(id);
                       }

                       format(g_sql_string,255,"UPDATE `players` SET name=^"%s^",timestamp=UNIX_TIMESTAMP() WHERE authid='%s'",name,authid);
                       g_sql_query = SQL_PrepareQuery(g_sql_connect,g_sql_string);
                       if(!SQL_Execute(g_sql_query))
                       {
                        database_error(g_sql_query);
                       }

                       SQL_FreeHandle(g_sql_query);
                        
                       if((equal(password,"")) && (found))
                       {
                        return 0;
                       }
                        
                       return 1;
}