Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function LoadProperty() {
- new result[100],index = 0;
- mysql_query(SQL,"SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC");
- mysql_store_result();
- while(mysql_retrieve_row()) {
- housess++;
- index++;
- new i = index;
- mysql_get_field("ID", result); HouseInfo[i][hID] = strval(result);
- mysql_get_field("Entrancex", result); HouseInfo[i][hEntrancex] = floatstr(result);
- mysql_get_field("Entrancey", result); HouseInfo[i][hEntrancey] = floatstr(result);
- mysql_get_field("Entrancez", result); HouseInfo[i][hEntrancez] = floatstr(result);
- mysql_get_field("Exitx", result); HouseInfo[i][hExitx] = floatstr(result);
- mysql_get_field("Exity", result); HouseInfo[i][hExity] = floatstr(result);
- mysql_get_field("Exitz", result); HouseInfo[i][hExitz] = floatstr(result);
- mysql_get_field("Owner", result); strmid(HouseInfo[i][hOwner], result, 0, 32, 32);
- mysql_get_field("Discription", result); strmid(HouseInfo[i][hDiscription], result, 0, 24, 24);
- mysql_get_field("Value", result); HouseInfo[i][hValue] = strval(result);
- mysql_get_field("Hel", result); HouseInfo[i][hHel] = strval(result);
- mysql_get_field("Arm", result); HouseInfo[i][hArm] = strval(result);
- mysql_get_field("Interior", result); HouseInfo[i][hInterior] = strval(result);
- mysql_get_field("Lockk", result); HouseInfo[i][hLock] = strval(result);
- mysql_get_field("Owned", result); HouseInfo[i][hOwned] = strval(result);
- mysql_get_field("Rent", result); HouseInfo[i][hRent] = strval(result);
- mysql_get_field("Rentabil", result); HouseInfo[i][hRentabil] = strval(result);
- mysql_get_field("Takings", result); HouseInfo[i][hTakings] = strval(result);
- mysql_get_field("Level", result); HouseInfo[i][hLevel] = strval(result);
- mysql_get_field("Virtual", result); HouseInfo[i][hVirtual] = strval(result);
- mysql_get_field("Radio", result); HouseInfo[i][hRadio] = strval(result);
- UpdateLabel(1,HouseInfo[i][hID]);
- }
- mysql_free_result();
- printf("Houses: %d", index);
- return 1;
- }
Add Comment
Please, Sign In to add comment