[T-z3P]

Hi, I need some help. I'm trying to execute 3 queries in the same function but I don't need them to be executed at the same time. The plan is pretty much like this: execute first query, execute second query, take some data with second query from database and use it to execute third query. How to do this?

[doondook]

set_task

[mabaclu]

Use threaded queries so that you only make the second one after the first is done.

[mottzi]

??? I dont get the Problem... PseudoCode:

funktion()
{
query1()
result = query2()
query3(result) //<- Do things with the result of query 2
}

[DjOptimuS]

PHP Code:

SQL_ThreadQuery ( Handle:db_tuple, const handler[], const query[], const data[]="", dataSize=0 ) 


the handler is a forward which is called when the Query is finished, there you can put the second query you need.

[mottzi]

Yeah if he is using threaded queries.

[DjOptimuS]

post the full code

[T-z3P]

PHP Code:

public RNRegister(id, level, cid)
{
    if (!cmd_access(id, level, cid, 2))
        return PLUGIN_HANDLED
    
    if (!is_user_connected(id))
    {
        return PLUGIN_CONTINUE
    }
    
    if(is_user_admin(id))
    {
        client_print(id, print_console, "Your nickname is already registered!")
        
        return PLUGIN_HANDLED
    }
    
    new activation_key[25]
    new authid[64]
    new cache[256]
    new email[64]
    new error[128]
    new errno
    new Handle:info = SQL_MakeStdTuple()
    new Handle:query
    new Handle:sql = SQL_Connect(info, errno, error, 127)
    new name[32]
    new password[64]
    new password_field[32]
    new prefix[32]
    new register_date = get_systime()
    
    random_str(activation_key, charsmax(activation_key))
    read_argv(1, email, 63)
    read_argv(2, password, 31)
    
    if(containi(email, "@")==-1)
    {
        client_print(id, print_console, "Invalid e-mail address!")
        
        return PLUGIN_HANDLED
    }
    
    if(strlen(password) <= 5)
    {
        client_print(id, print_console, "Password must have at least 6 characters!")
        return PLUGIN_HANDLED
    }
    
    get_cvar_string("amx_password_field", password_field, 31)
    get_cvar_string("amx_sql_table_prefix", prefix, 31)
    get_user_authid(id, authid, 63)
    get_user_name(id,name,31)
        
    if (sql == Empty_Handle)
    {
        server_print("[AMXX] SQL Error: %s", error)
        
        return PLUGIN_HANDLED
    }
        
    query = SQL_PrepareQuery(sql, "INSERT INTO `%susers` (`login`, `password`, `email`, `register_date`, `active`, `activation_key`, `account_flags`) VALUES ('%s', '%s', '%s', '%d', '1', '%s', 'ab')", prefix, name, password, email, register_date, activation_key)
    
    if (!SQL_Execute(query))
    {
        SQL_QueryError(query, error, 127)
        server_print("[AMXX] SQL Error: %s", error)
        
        return PLUGIN_HANDLED
    } 
    
    SQL_FreeHandle(query)
       
    formatex(cache, sizeof(cache)-1, "SELECT ID FROM `%susers` WHERE login='%s'", prefix, name)
    SQL_ThreadQuery(info, "RNGetUserID", cache)
    
    SQL_FreeHandle(sql)
    SQL_FreeHandle(info)
    
    client_print(id, print_console, "Your account is now registered!")
    client_print(id, print_console, "Write the next line in your console, or you will be kicked in 10 seconds:")
    client_print(id, print_console, "setinfo %s %s", password_field, password)
    
    return PLUGIN_CONTINUE
}

public RNGetUserID(FailState, Handle:query, error[], Errcode, Data[], DataSize)
{
    new error[128]
    new errno
    new Handle:another_query
    new Handle:info = SQL_MakeStdTuple()
    new Handle:sql = SQL_Connect(info, errno, error, 127)
    new prefix[32]
    new rn_account_type = get_pcvar_num(amx_rn_account_type)
    new server_id[32]
    new user_id
    
    while(SQL_MoreResults(query))
    {
        user_id = SQL_ReadResult(query,0)    
        SQL_NextRow(query)
    }
    
    get_cvar_string("amx_sql_table_prefix", prefix, 31)
    get_cvar_string("amx_sql_serverid", server_id, 31)
    
    if(rn_account_type == 0)
    {
        another_query = SQL_PrepareQuery(sql, "INSERT INTO `%susers_access` (`user_ID`, `server_ID`, `group_ID`) VALUES ('%d', '0', '0')", prefix, user_id)
    }
    else
    {
        another_query = SQL_PrepareQuery(sql, "INSERT INTO `%susers_access` (`user_ID`, `server_ID`, `group_ID`) VALUES ('%d', '%d', '0')", prefix, user_id, server_id)
    }
    
    if (!SQL_Execute(another_query))
    {
        SQL_QueryError(another_query, error, 127)
        server_print("[AMXX] SQL Error: %s", error)
        
        return PLUGIN_HANDLED
    } 
    
    SQL_FreeHandle(another_query)
    SQL_FreeHandle(sql)
    SQL_FreeHandle(info)
    
    set_task(10.0, "cmdReload")
    
    return PLUGIN_CONTINUE
} 

random_str(output[], len)
{
    for(new i=0; i<len; i++)
    {
        output[i] = random_num('0', '9');
    }
    
    output[len]=EOS;
}
#endif 


[Exolent[jNr]]

Originally Posted by T-z3P PHP Code:     new activation_key = random_num(000000000000000000000000, 999999999999999999999999)

Umm...

Pawn variables are stored as cells, which are 32-bit integers.
32-bit integers range from −2,147,483,648 to 2,147,483,647.

If you want a number that long, you'll have to use a string instead.

[T-z3P]

I didn't knew how to do it, so this was the first idea in my head.. I need a random number of 24 digits.