MySQL related; server gets stuck
#1

Hello,

pawn Код:
stock GetFreeDiskID()
{
    GlobalInfo[LoadingDatabaseFinished] = 0;
    mysql_function_query(1,"SELECT * FROM `CompactDiskInfo`",true,"ReturnFreeDatabaseID","","");
    for(;;) if(GlobalInfo[LoadingDatabaseFinished] == 1) break; // Breaking first to avoid the 'return a value' warning
    return GlobalInfo[ReturnDatabaseID];
}
pawn Код:
public ReturnFreeDatabaseID()
{
    new fields;
    cache_get_data(GlobalInfo[ReturnDatabaseID],fields);
    GlobalInfo[LoadingDatabaseFinished] = 1;
    return 1;
}
How come the server gets stuck? It's obvious it has to do with the loop, but the MySQL function runs as it's threaded and should be done very soon.

Jochem
Reply


Messages In This Thread
MySQL related; server gets stuck - by Jochemd - 14.07.2012, 11:18
Re: MySQL related; server gets stuck - by pyrodave - 14.07.2012, 11:29
Re: MySQL related; server gets stuck - by Jochemd - 14.07.2012, 11:38
Re: MySQL related; server gets stuck - by AndreT - 14.07.2012, 11:40

Forum Jump:


Users browsing this thread: 1 Guest(s)