04.08.2013, 13:53
Okay im using this code:
But theres always a problem with the connection. Even though when i join mysql is used and runs fine.
This is the error:
[15:38:24] errorid: 2013 | error: "Lost connection to MySQL server during query" | callback: "" | query: "SELECT * FROM ClubCars" | connectionHandle: 1
pawn Код:
public ClubCarTimer()
{
new Query[128], rows, fields, i = 0, Day, Month, Year, Date[128];
getdate(Year, Month, Day);
format(Date, sizeof(Date), "%02d-%02d-%02d", Day, Month, Year);
format(Query, sizeof(Query), "SELECT * FROM ClubCars");
mysql_function_query( Handle, Query, false, "", "" );
cache_get_data( rows, fields, Handle);
while(rows > i < MAX_CLUBCARS)
{
cache_get_row(i, 3 , ClubVehicles[i][ExpireDate], Handle, 24);
if(strmatch(ClubVehicles[i][ExpireDate], Date))
{
}
}
return 1;
}
This is the error:
[15:38:24] errorid: 2013 | error: "Lost connection to MySQL server during query" | callback: "" | query: "SELECT * FROM ClubCars" | connectionHandle: 1