Entonces utilizo la forma 2, y para guardar datos hago esto:
PHP Code:
public guardar_datos( id )
{
if( g_estado[ id ] != LOGUEADO )
return;
static szQuery[ 128 ], iData[ 2 ];
iData[ 0 ] = id;
iData[ 1 ] = GUARDAR_DATOS;
formatex( szQuery, charsmax( szQuery ), "UPDATE %s SET Experiencia='%d' WHERE id='%d'", TABLE, g_experiencia[ id ], g_id[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
formatex( szQuery, charsmax( szQuery ), "UPDATE %s SET Level='%d' WHERE id='%d'", TABLE, g_level[ id ], g_id[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
formatex( szQuery, charsmax( szQuery ), "UPDATE %s SET Puntos='%d' WHERE id='%d'", TABLE, g_puntos[ id ], g_id[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
}
public cargar_datos( id )
{
static szQuery[ 128 ], iData[ 2 ];
iData[ 0 ] = id;
iData[ 1 ] = CARGAR_DATOS;
formatex( szQuery, charsmax( szQuery ), "SELECT id, Experiencia FROM %s WHERE Usuario=^"%s^"", TABLE, g_usuario[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
formatex( szQuery, charsmax( szQuery ), "SELECT id, Level FROM %s WHERE Usuario=^"%s^"", TABLE, g_usuario[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
formatex( szQuery, charsmax( szQuery ), "SELECT id, Puntos FROM %s WHERE Usuario=^"%s^"", TABLE, g_usuario[ id ] );
SQL_ThreadQuery( g_hTuple, "DataHandler", szQuery, iData, 2 );
}