- Регистрация
- 12 Июн 2018
- Сообщения
- 21
- Лучшие ответы
- 0
- Репутация
- 1
Здравствуйте, помогите мне перевести код на MysQL R41-4. Пытался сам. Получилась фигня.
Вот код:
Вот код:
PHP:
stock LoadHouses()
{
new data[256],str[128];
mysql_query("SELECT * FROM `house`");
mysql_store_result();
while(mysql_fetch_row_format(dbHandle, data, " "))
{
new i;
strval(strtok(data, i));
format(HouseInfo[houses][owner],24,"%s",strtok(data, i));
HouseInfo[houses][cost] = strval(strtok(data, i));
HouseInfo[houses][interior] = strval(strtok(data, i));
HouseInfo[houses][hx] = floatstr(strtok(data, i));
HouseInfo[houses][hy] = floatstr(strtok(data, i));
HouseInfo[houses][hz] = floatstr(strtok(data, i));
format(HouseInfo[houses][name],24,"%s",strtok(data, i));
HouseInfo[houses][lock] = strval(strtok(data, i));
if(!strcmp(HouseInfo[houses][owner], "None", true))
{
format(str,sizeof(str),"ID: %d\nДом на продаже!\nЦена: $%d",houses,HouseInfo[houses][cost]);
HouseInfo[houses][txt] = CreateDynamic3DTextLabel(str, -1, HouseInfo[houses][hx],HouseInfo[houses][hy],HouseInfo[houses][hz],20.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,-1,-1,-1,20.0);
HouseInfo[houses][pickup] = CreateDynamicPickup(1273, 23, HouseInfo[houses][hx],HouseInfo[houses][hy],HouseInfo[houses][hz],-1,-1,-1,20.0);
}
else
{
format(str,sizeof(str),"ID: %d\nВладелец: %s\nНазвание: %s",houses,HouseInfo[houses][owner],HouseInfo[houses][name]);
HouseInfo[houses][txt] = CreateDynamic3DTextLabel(str, -1, HouseInfo[houses][hx],HouseInfo[houses][hy],HouseInfo[houses][hz],20.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,-1,-1,-1,20.0);
HouseInfo[houses][pickup] = CreateDynamicPickup(1272, 23, HouseInfo[houses][hx],HouseInfo[houses][hy],HouseInfo[houses][hz],-1,-1,-1,20.0);
}
houses++;
}
mysql_free_result();
printf("Загружено %d домов. - Система Darth'a",houses);
}