narkk3
Умник
Здравствуйте!
Помогите пожалуйста перевести версию MySQL с R6.5 на R41-2.
Сам вот пробовал делать, запутался и вообще не понимаю, что к чему. (в коде ниже ошибка vehicleid и вообще я не уверен что он правильный) Помогите пожалуйста довести до ума.
Помогите пожалуйста перевести версию MySQL с R6.5 на R41-2.
Код:
stock LoadCar() // Загрузка автомобилей (mySQL R6.5)
{
new fetch[200];
new Float:pos[4*2], vehid, p, vehicleid;
mysql_query("SELECT * FROM car");
mysql_store_result();
if(mysql_num_rows()>0)
{
while(mysql_fetch_row_format(fetch))
{
sscanf(fetch, "p<|>ffffddffff",
pos[0],
pos[1],
pos[2],
pos[3],
vehid,
p,
pos[4],
pos[5],
pos[6],
pos[7]);
if(!p && pos[0] != 0 && pos[1] != 0){vehicleid = CreateVehicle(vehid, pos[0], pos[1], pos[2], pos[3], 1, 1, -1);}
else if(!p && pos[0] == 0 && pos[1] == 0){vehicleid = CreateVehicle(vehid, pos[4], pos[5], pos[6], pos[7], 1, 1, -1);}
else if(p == 1){vehicleid = CreateVehicle(vehid, pos[4], pos[5], pos[6], pos[7], 1, 1, -1);}
sscanf(fetch, "p<|>ffffddffffdds[24]ddd",
pCarServer[vehicleid][pX],
pCarServer[vehicleid][pY],
pCarServer[vehicleid][pZ],
pCarServer[vehicleid][pR],
pCarServer[vehicleid][pVehID],
pCarServer[vehicleid][pPockupcka],
pCarServer[vehicleid][pNewX],
pCarServer[vehicleid][pNewY],
pCarServer[vehicleid][pNewZ],
pCarServer[vehicleid][pNewR],
pCarServer[vehicleid][pStatus],
pCarServer[vehicleid][pZena],
pCarServer[vehicleid][pNamePlayer],
pCarServer[vehicleid][pColor1],
pCarServer[vehicleid][pColor2],
pCarServer[vehicleid][pIDbd]
);
ChangeVehicleColor(vehicleid, pCarServer[vehicleid][pColor1], pCarServer[vehicleid][pColor2]);
pCarServer[vehicleid][pID] = vehicleid;
if(pCarServer[vehicleid][pPockupcka] == 1)
{
format(string, sizeof(string), "{FF8400}Транспорт продается\n\n{FFFFFF}Модель: {C0C0C0}%s (%d)\n{FFFFFF}Номер: {C0C0C0}SP (%d)\n{FFFFFF}Стоимость: {C0C0C0}%d", VehicleNameS[vehid - 400], vehid,vehicleid,pCarServer[vehicleid][pZena]);
pCarServer[vehicleid][pText3DCar] = Create3DTextLabel(string, 0xFFFFFFFF, 0, 0, 0, 25.0, 0, 1);
Attach3DTextLabelToVehicle(pCarServer[vehicleid][pText3DCar], vehicleid, 0.0, 0.0, 0.3);
}
}
}
printf("[Личный т.с] - Было загружено %i т.с за %i ms.", mysql_num_rows());
mysql_free_result();
}
Код:
@LoadCar();
@LoadCar()
{
new time = GetTickCount();
#if MYSQL_R41_2 == true
new rows;
new string[300];
cache_get_row_count(rows);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
cache_get_value_index_int(idx-1, 0, pCarServer[vehicleid][pX]);
cache_get_value_index_float(idx-1, 1, pCarServer[vehicleid][pY]);
cache_get_value_index_float(idx-1, 2, pCarServer[vehicleid][pZ]);
cache_get_value_index_float(idx-1, 3, pCarServer[vehicleid][pR]);
cache_get_value_index_float(idx-1, 4, pCarServer[vehicleid][pVehID]);
cache_get_value_index_float(idx-1, 5, pCarServer[vehicleid][pPockupcka]);
cache_get_value_index_float(idx-1, 6, pCarServer[vehicleid][pNewX]);
cache_get_value_index_float(idx-1, 7, pCarServer[vehicleid][pNewY]);
cache_get_value_index_float(idx-1, 8, pCarServer[vehicleid][pNewZ]);
cache_get_value_index_float(idx-1, 9, pCarServer[vehicleid][pNewR]);
cache_get_value_index_float(idx-1, 10, pCarServer[vehicleid][pStatus]);
cache_get_value_index_float(idx-1, 11, pCarServer[vehicleid][pZena]);
cache_get_value_index_float(idx-1, 12, pCarServer[vehicleid][pNamePlayer]);
cache_get_value_index_float(idx-1, 13, pCarServer[vehicleid][pColor1]);
cache_get_value_index_float(idx-1, 14, pCarServer[vehicleid][pColor2]);
cache_get_value_index_float(idx-1, 15, pCarServer[vehicleid][pIDbd]);
ChangeVehicleColor(vehicleid, pCarServer[vehicleid][pColor1], pCarServer[vehicleid][pColor2]);
pCarServer[vehicleid][pID] = vehicleid;
TOTALCAR++;
if(pCarServer[vehicleid][pPockupcka] == 1)
{
format(string, sizeof(string), "{FF8400}Транспорт продается\n\n{FFFFFF}Модель: {C0C0C0}%s (%d)\n{FFFFFF}Номер: {C0C0C0}SP (%d)\n{FFFFFF}Стоимость: {C0C0C0}%d", VehicleNameS[vehid - 400], vehid,vehicleid,pCarServer[vehicleid][pZena]);
pCarServer[vehicleid][pText3DCar] = Create3DTextLabel(string, 0xFFFFFFFF, 0, 0, 0, 25.0, 0, 1);
Attach3DTextLabelToVehicle(pCarServer[vehicleid][pText3DCar], vehicleid, 0.0, 0.0, 0.3);
}
}
}
#else
new rows, fields;
new string[300];
new vehicleid;
cache_get_data(rows, fields);
if(rows)
{
for(new idx = 1; idx <= rows; idx++)
{
pCarServer[vehicleid][pX] = cache_get_row_int(idx-1, 0, dbHandle);
pCarServer[vehicleid][pY] = cache_get_row_float(idx-1, 1, dbHandle);
pCarServer[vehicleid][pZ] = cache_get_row_float(idx-1, 2, dbHandle);
pCarServer[vehicleid][pR] = cache_get_row_float(idx-1, 3, dbHandle);
pCarServer[vehicleid][pVehID] = cache_get_row_float(idx-1, 4, dbHandle);
pCarServer[vehicleid][pPockupcka] = cache_get_row_float(idx-1, 5, dbHandle);
pCarServer[vehicleid][pNewX] = cache_get_row_float(idx-1, 6, dbHandle);
pCarServer[vehicleid][pNewY] = cache_get_row_float(idx-1, 7, dbHandle);
pCarServer[vehicleid][pNewZ] = cache_get_row_float(idx-1, 8, dbHandle);
pCarServer[vehicleid][pNewR] = cache_get_row_float(idx-1, 9, dbHandle);
pCarServer[vehicleid][pStatus] = cache_get_row_float(idx-1, 10, dbHandle);
pCarServer[vehicleid][pZena] = cache_get_row_float(idx-1, 11, dbHandle);
pCarServer[vehicleid][pNamePlayer] = cache_get_row_float(idx-1, 12, dbHandle);
pCarServer[vehicleid][pColor1] = cache_get_row_float(idx-1, 13, dbHandle);
pCarServer[vehicleid][pColor2] = cache_get_row_float(idx-1, 14, dbHandle);
pCarServer[vehicleid][pIDbd] = cache_get_row_float(idx-1, 15, dbHandle);
ChangeVehicleColor(vehicleid, pCarServer[vehicleid][pColor1], pCarServer[vehicleid][pColor2]);
pCarServer[vehicleid][pID] = vehicleid;
TOTALCAR++;
if(pCarServer[vehicleid][pPockupcka] == 1)
{
format(string, sizeof(string), "{FF8400}Транспорт продается\n\n{FFFFFF}Модель: {C0C0C0}%s (%d)\n{FFFFFF}Номер: {C0C0C0}SP (%d)\n{FFFFFF}Стоимость: {C0C0C0}%d", VehicleNameS[vehid - 400], vehid,vehicleid,pCarServer[vehicleid][pZena]);
pCarServer[vehicleid][pText3DCar] = Create3DTextLabel(string, 0xFFFFFFFF, 0, 0, 0, 25.0, 0, 1);
Attach3DTextLabelToVehicle(pCarServer[vehicleid][pText3DCar], vehicleid, 0.0, 0.0, 0.3);
}
}
}
#endif
printf("[Личный транспорт] - Было загружено %i личного транспорта за %i ms.", TOTALCAR, GetTickCount() - time);
return 1;
}
