[Jochemd]

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

[pyrodave]

The plugin may be multithreaded but pawn is not. The plugin cannot pass a value to the callback because its executing your loop and execution won't be handed back until it finishes (which of course, it wont). What you're trying to do cannot be done with the multithreading enabled. (Simply returning a value in a function like that).

The best solution off the top of my head would be to store a static or global variable for your FreeDiskID and update it as disks are used and freed. There are probably better solutions however its difficult to say without knowing the nature of the full system.

[Jochemd]

Quote:

Originally Posted by pyrodave The best solution off the top of my head would be to store a static or global variable for your FreeDiskID and update it as disks are used and freed. There are probably better solutions however its difficult to say without knowing the nature of the full system.

I did not fully get you there; Do you mind making a small example?

[AndreT]

GetFreeDiskID and ReturnFreeDatabaseID do not run in separate threads. That's why ReturnFreeDatabaseID can never run (the server is stuck in a loop in GetFreeDiskID). This is not how you are supposed to thread stuff.