12.08.2012, 12:16
(
Last edited by Julian2574; 12/08/2012 at 01:44 PM.
)
Alright as the topic name is, I am trying to retrieve a float through mysql + sscanf 2 using G-Stylez mysql system.
You see every time I retrieve the EntranceX, Y and Z it gives me this
and I've tried anyway I can to solving this but I can't..
The code:
Debug
Resolved - Had to include the enum into sscanf instead of using enum ..
Resolve code:
You see every time I retrieve the EntranceX, Y and Z it gives me this
Code:
000.000 000.000 000.000
The code:
pawn Code:
enum Building{
bID,
bName,
bInterior,
bxWorld,
beWorld,
Float:bEntX,
Float:bEntY,
Float:bEntZ,
Float:bExitX,
Float:bExitY,
Float:bExitZ
}
new BuildingInfo[MAX_BUILDINGS][Building];
public LoadBuildings()
{
new row[1200];
mysql_query("SELECT * FROM buildings");
mysql_store_result();
new idx=1;
if(mysql_num_rows() > 0){
totalbuildings = mysql_num_rows();
while(mysql_fetch_row(row)){
sscanf(row,"p<|>e<ifffi>",BuildingInfo[idx]);
printf("%f",BuildingInfo[idx][bEntX]); //Debug text
printf("[Building ID]%d[Loaded]",BuildingInfo[idx][bID]);
idx++;
}
}
mysql_free_result();
printf("%d Buildings loaded from database",totalbuildings);
return 1;
}
Code:
[08:14:46] CMySQLHandler::Query(SELECT * FROM buildings) - Successfully executed. [08:14:46] >> mysql_store_result( Connection handle: 1 ) [08:14:46] CMySQLHandler::StoreResult() - Result was stored. [08:14:46] >> mysql_num_rows( Connection handle: 1 ) [08:14:46] CMySQLHandler::NumRows() - Returned 4 row(s) [08:14:46] >> mysql_num_rows( Connection handle: 1 ) [08:14:46] CMySQLHandler::NumRows() - Returned 4 row(s) [08:14:46] >> mysql_fetch_row_format( Connection handle: 1 ) [08:14:46] CMySQLHandler::FetchRow() - Return: 2|-2867.16|1066.49|31.5308|1 [08:14:46] >> mysql_fetch_row_format( Connection handle: 1 ) [08:14:46] CMySQLHandler::FetchRow() - Return: 3|-2864.55|1062.38|31.9056|1 [08:14:46] >> mysql_fetch_row_format( Connection handle: 1 ) [08:14:46] CMySQLHandler::FetchRow() - Return: 4|-2856.35|1053.34|32.8544|1 [08:14:46] >> mysql_fetch_row_format( Connection handle: 1 ) [08:14:46] CMySQLHandler::FetchRow() - Return: 5|-2854.77|1044.88|34.4064|1 [08:14:46] >> mysql_fetch_row_format( Connection handle: 1 ) [08:14:46] >> mysql_free_result( Connection handle: 1 ) [08:14:46] CMySQLHandler::FreeResult() - Result was successfully free'd.
Resolve code:
pawn Code:
sscanf(row,"p<|>ifffifffi",BuildingInfo[idx][bID],BuildingInfo[idx][bEntX],BuildingInfo[idx][bEntY],BuildingInfo[idx][bEntZ],BuildingInfo[idx][beWorld],BuildingInfo[idx][bExitX],BuildingInfo[idx][bExitY],BuildingInfo[idx][bExitZ], BuildingInfo[idx][bxWorld]);