f0Re3t
Компетентный
Ребят, кто может помочь перевести с sql на mysql r7.
PHP:
new Result:house_interior = sql_query(zConn, "SELECT * FROM `hints`", QUERY_CACHED);
for(new interior = 0; interior < sql_num_rows(house_interior); interior++)
{
sql_fetch_row(house_interior, "|", zRes);
sql_next_row(house_interior);
sscanf(zRes, "p<|>e<iffffffffis[32]>", gHints[interior]);
gHintStoreArea[interior] = CreateDynamicSphere(gHintStore[interior][0], gHintStore[interior][1], gHintStore[interior][2], 2.0);
gHintSafeArea[interior] = CreateDynamicSphere(gHintSafe[interior][0], gHintSafe[interior][1], gHintSafe[interior][2], 2.0);
gHintFreezArea[interior] = CreateDynamicSphere(gHintFreez[interior][0], gHintFreez[interior][1], gHintFreez[interior][2], 2.0);
if(interior < HINTS_COUNT)
{
for(new temporary = 0; temporary < 9; temporary++) CreateDynamicObject(gHintGunID[temporary], gHintGun[interior][temporary][0], gHintGun[interior][temporary][1], gHintGun[interior][temporary][2], gHintGun[interior][temporary][3], gHintGun[interior][temporary][4], gHintGun[interior][temporary][5], interior + 500);
}
}
sql_free_result(house_interior);