Hey, ich habe das problem das sich keine Handynummer erstellt bzw. In der Mysql Log versucht er immer neu eine Handynummer zu erstellen.
Der Stock wird aufgerufen wen man ein Handy kauft.
stock CreateHandyNumber(playerid)
{
new string[128];
if(SpielerInfo[playerid][pHandyNummer] == 0)
{
new randphone = 100000 + random(899999);
format(string,sizeof(string),"SELECT * FROM `accounts` WHERE handynummer=%d",randphone);
mysql_function_query(Handle,string,true,"CheckNummer","ii",playerid,randphone);
}
return 1;
}
forward CheckNummer(playerid,nummer);
public CheckNummer(playerid,nummer)
{
new rows,fields;
cache_get_data(rows,fields);
if(!rows)
{
CreateHandyNumber(playerid);
}
else
{
SpielerInfo[playerid][pHandyNummer] = nummer;
SaveAccount(playerid);
}
return 1;
}
Und das geht immer so weiter ich glaube 15k Zeilen lang oder so.
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=140738 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=140738)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=552146 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=552146)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=551936 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=551936)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=413115 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=413115)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=428651 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=428651)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=271963 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=271963)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=229648 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=229648)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=329754 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=329754)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=887707 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=887707)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=989016 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=989016)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=580148 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=580148)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=629794 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=629794)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=250290 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=250290)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=873910 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=873910)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=319288 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=319288)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=951626 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=951626)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=675524 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=675524)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=410243 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=410243)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=577874 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=577874)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=924229 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=924229)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=919291 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=919291)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=688131 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=688131)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=133040 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=133040)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=616462 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=616462)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=333001 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=333001)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=912571 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=912571)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[17:47:57] CheckNummer(ii) - Threaded function called.
[17:47:57] >> cache_get_data( Connection handle: 1 )
[17:47:57] >> mysql_query_callback( Connection handle: 1 )
[17:47:57] ProcessTick() - The cache has been cleared.
[17:47:57] Passing query SELECT * FROM `accounts` WHERE handynummer=988302 | ii
[17:47:57] ProcessQueryThread(CheckNummer) - Query was successful. (SELECT * FROM `accounts` WHERE handynummer=988302)
[17:47:57] ProcessQueryThread(CheckNummer) - Data caching enabled.
[17:47:57] CMySQLHandler::StoreResult() - Result was stored.
[17:47:57] CMySQLHandler::FreeResult() - Result was successfully free'd.
[17:47:57] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()