LoadMySQLGarages ( )
{
mysql_query("SELECT * FROM `Garages` ORDER BY `Garages`.`gID` ASC");
mysql_store_result();
for(new i; i < TOTAL_GARAGES; i++) strmid( global_garages[ i ][ gOwner ], "None", 0, strlen("None"), 24);
if(mysql_num_rows() > 0)
{
for(new g = 1; g <= mysql_num_rows(); g++)
{
mysql_fetch_row(Query);
sscanf(Query, "p<|>ifffs[24]ii",global_garages[ g ][ gID ],global_garages[ g ][ gPosX ],global_garages[ g ][ gPosY ],global_garages[ g ][ gPosZ ],global_garages[ g ][ gOwner ],global_garages[ g ][ gPrice ],global_garages[ g ][ gVW ]);
if(!strcmp( global_garages [ g ][ gOwner ], "None", true ) )
{
global_garages [ g ][ gPickup ] = CreatePickup(1277, 1, global_garages [ g ][ gPosX ], global_garages [ g ][ gPosY ], global_garages [ g ][ gPosZ ] );
format(strin,sizeof(strin),"{339900}Гараж [{ffcc33}Number %i{339900}].\nГараж выставлен на продажу.\nЦена: [{ffcc33}%i${339900}].", g, global_garages [ g ][ gPrice ]);
}
else
{
global_garages [ g ][ gPickup ] = CreatePickup(1277, 1, global_garages [ g ][ gPosX ], global_garages [ g ][ gPosY ], global_garages [ g ][ gPosZ ] );
format(strin,sizeof(strin),"{339900}Гараж [{ffcc33}Number %i{339900}].\nВладелец гаража: [{ffcc33}%s{339900}].", g, global_garages [ g ][ gOwner ]);
}
global_garages [ g ][ gLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, global_garages [ g ][ gPosX ],global_garages [ g ][ gPosY ],global_garages [ g ][ gPosZ ], 15.0,0,1);
CreatePickup ( 1318, 1, 608.7586,-18.4321,1000.9206, -1 );
++ TOTAL_GARAGES;
}
}
mysql_free_result(), printf("[ Система гаражей ]: Загружено %i гаражей.", TOTAL_GARAGES);
}
LoadMySQLHouses ( )
{
mysql_query("SELECT * FROM `ExclusiveHouses` ORDER BY `ExclusiveHouses`.`hID` ASC");
mysql_store_result();
for(new i; i < TOTAL_HOUSES; i++) strmid( HouseInfo[ i ][ hOwner ], "None", 0, strlen("None"), 24);
if(mysql_num_rows() > 0)
{
for(new h = 1; h <= mysql_num_rows(); h++)
{
mysql_fetch_row(Query);
sscanf(Query, "p<|>iffffffs[24]iiii",HouseInfo[ h ][ hID ],HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ],HouseInfo[ h ][ ExitX ],HouseInfo[ h ][ ExitY ],HouseInfo[ h ][ ExitZ ],HouseInfo[ h ][ hOwner ],HouseInfo[ h ][ hPrice ],HouseInfo[ h ][ hInt ],HouseInfo[ h ][ hVW ],HouseInfo[ h ][ hLock ] );
if(!strcmp( HouseInfo[ h ][ hOwner ], "None", true ) )
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", h, HouseInfo[ h ][ hPrice ]);
}
else
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1318, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nВладелец дома: %s.", h, HouseInfo[ h ][ hOwner ]);
}
CreatePickup(19134, 1, HouseInfo[ h ][ ExitX ], HouseInfo[ h ][ ExitY ], HouseInfo[ h ][ ExitZ ], HouseInfo [ h ] [ hVW ] );
HouseInfo[ h ][ hLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ], 15.0,0,1);
++ TOTAL_HOUSES;
}
}
mysql_free_result(), printf("[ Система домов ]: Загружено %i домов.", TOTAL_HOUSES);
}
Дело в том что загрузка гаражей/домов происходит через сканф... |
native sscanf(const data[], const format[], {Float,_}:...);
stock sscanf(string[], format[], {Float,_}:...) { #if defined isnull if (isnull(string)) #else if (string[0] == 0 || (string[0] == 1 && string[1] == 0)) #endif { return format[0]; } #pragma tabsize 4 new formatPos = 0, stringPos = 0, paramPos = 2, paramCount = numargs(), delim = ' '; while (string[stringPos] && string[stringPos] <= ' ') { stringPos++; } while (paramPos < paramCount && string[stringPos]) { switch (format[formatPos++]) { case '\0': { return 0; } case 'i', 'd': { new neg = 1, num = 0, ch = string[stringPos]; if (ch == '-') { neg = -1; ch = string[++stringPos]; } do { stringPos++; if ('0' <= ch <= '9') { num = (num * 10) + (ch - '0'); } else { return -1; } } while ((ch = string[stringPos]) > ' ' && ch != delim); setarg(paramPos, 0, num * neg); } case 'h', 'x': { new num = 0, ch = string[stringPos]; do { stringPos++; switch (ch) { case 'x', 'X': { num = 0; continue; } case '0' .. '9': { num = (num << 4) | (ch - '0'); } case 'a' .. 'f': { num = (num << 4) | (ch - ('a' - 10)); } case 'A' .. 'F': { num = (num << 4) | (ch - ('A' - 10)); } default: { return -1; } } } while ((ch = string[stringPos]) > ' ' && ch != delim); setarg(paramPos, 0, num); } case 'c': { setarg(paramPos, 0, string[stringPos++]); } case 'f': { new changestr[16], changepos = 0, strpos = stringPos; while(changepos < 16 && string[strpos] && string[strpos] != delim) { changestr[changepos++] = string[strpos++]; } changestr[changepos] = '\0'; setarg(paramPos,0,_:floatstr(changestr)); } case 'p': { delim = format[formatPos++]; continue; } case '\'': { new end = formatPos - 1, ch; while ((ch = format[++end]) && ch != '\'') {} if (!ch) { return -1; } format[end] = '\0'; if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1) { if (format[end + 1]) { return -1; } return 0; } format[end] = '\''; stringPos = ch + (end - formatPos); formatPos = end + 1; } case 'u': { new end = stringPos - 1, id = 0, bool:num = true, ch; while ((ch = string[++end]) && ch != delim) { if (num) { if ('0' <= ch <= '9') { id = (id * 10) + (ch - '0'); } else { num = false; } } } if (num && IsPlayerConnected(id)) { setarg(paramPos, 0, id); } else { #if !defined foreach #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2)) #define __SSCANF_FOREACH__ #endif string[end] = '\0'; num = false; new name[MAX_PLAYER_NAME]; id = end - stringPos; foreach (Player, playerid) { GetPlayerName(playerid, name, sizeof (name)); if (!strcmp(name, string[stringPos], true, id)) { setarg(paramPos, 0, playerid); num = true; break; } } if (!num) { setarg(paramPos, 0, INVALID_PLAYER_ID); } string[end] = ch; #if defined __SSCANF_FOREACH__ #undef foreach #undef __SSCANF_FOREACH__ #endif } stringPos = end; } case 's', 'z': { new i = 0, ch; if (format[formatPos]) { while ((ch = string[stringPos++]) && ch != delim) { setarg(paramPos, i++, ch); } if (!i) { return -1; } } else { while ((ch = string[stringPos++])) { setarg(paramPos, i++, ch); } } stringPos--; setarg(paramPos, i, '\0'); } default: { continue; } } while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ') { stringPos++; } while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' ')) { stringPos++; } paramPos++; } do { if ((delim = format[formatPos++]) > ' ') { if (delim == '\'') { while ((delim = format[formatPos++]) && delim != '\'') {} } else if (delim != 'z') { return delim; } } } while (delim > ' '); return 0; }
LoadMySQLHouses ( )
{
mysql_query("SELECT * FROM `ExclusiveHouses` ORDER BY `ExclusiveHouses`.`hID` ASC");
mysql_store_result();
for(new i; i < TOTAL_HOUSES; i++) strmid( HouseInfo[ i ][ hOwner ], "None", 0, strlen("None"), 24);
if(mysql_num_rows() > 0)
{
for(new h = 1; h <= mysql_num_rows(); h++)
{
//mysql_fetch_row(Query);
mysql_get_field("EnterX", Query);
HouseInfo[ h ][ EnterX ] = floatstr(Query);
mysql_get_field("EnterY", Query);
HouseInfo[ h ][ EnterY ] = floatstr(Query);
mysql_get_field("EnterZ", Query);
HouseInfo[ h ][ EnterZ ] = floatstr(Query);
mysql_get_field("ExitX", Query);
HouseInfo[ h ][ ExitX ] = floatstr(Query);
mysql_get_field("ExitY", Query);
HouseInfo[ h ][ ExitY ] = floatstr(Query);
mysql_get_field("ExitZ", Query);
HouseInfo[ h ][ ExitZ ] = floatstr(Query);
mysql_get_field("hOwner", Query);
strmid(HouseInfo[ h ][ hOwner ], Query, 0, strlen(Query), 255);
mysql_get_field("hPrice", Query);
HouseInfo[ h ][ hPrice ] = strval(Query);
mysql_get_field("hInt", Query);
HouseInfo[ h ][ hInt ] = strval(Query);
mysql_get_field("hVW", Query);
HouseInfo[h][hVW] = strval(Query);
mysql_get_field("hLock", Query);
HouseInfo[h][hLock] = strval(Query);
//sscanf(Query, "p<|>iffffffs[24]iiii",HouseInfo[ h ][ hID ],HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ],HouseInfo[ h ][ ExitX ],HouseInfo[ h ][ ExitY ],HouseInfo[ h ][ ExitZ ],HouseInfo[ h ][ hOwner ],HouseInfo[ h ][ hPrice ],HouseInfo[ h ][ hInt ],HouseInfo[ h ][ hVW ],HouseInfo[ h ][ hLock ] );
if(!strcmp( HouseInfo[ h ][ hOwner ], "None", true ) )
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", h, HouseInfo[ h ][ hPrice ]);
}
else
{
HouseInfo[ h ][ hPickup ] = CreatePickup(1318, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );
format(strin,sizeof(strin),"Номер дома: %i.\nВладелец дома: %s.", h, HouseInfo[ h ][ hOwner ]);
}
CreatePickup(19134, 1, HouseInfo[ h ][ ExitX ], HouseInfo[ h ][ ExitY ], HouseInfo[ h ][ ExitZ ], HouseInfo [ h ] [ hVW ] );
HouseInfo[ h ][ hLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ], 15.0,0,1);
++ TOTAL_HOUSES;
}
}
mysql_free_result(), printf("[ Система домов ]: Загружено %i домов.", TOTAL_HOUSES);
}