Warum "Dead Connection" ?
SQL
[14:25:58] CMySQLHandler::Connect() - Connection was successful.
[14:25:58] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[14:25:58] >> mysql_query( Connection handle: 1 )
[14:25:58] CMySQLHandler::Query(SELECT * FROM `houses` WHERE `HausID` = 1) - Successfully executed.
[14:25:58] >> mysql_num_rows( Connection handle: 1 )
[14:25:58] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[14:25:58] >> mysql_store_result( Connection handle: 1 )
[14:25:58] CMySQLHandler::StoreResult() - Result was stored.
[14:25:58] >> mysql_retrieve_row( Connection handle: 1 )
Alles anzeigen
for(new i=1; i<1000 ; i++)
{
new string[128];
format(string, sizeof(string), "SELECT * FROM `houses` WHERE `HausID` = %d", i);
mysql_query(string);
if(mysql_num_rows())
{
mysql_store_result();