Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public LoadBizz()
- {
- new PropertyString[256], result[100],index = 0;
- mysql_query(SQL,"SELECT * FROM `bizz` ORDER BY `bizz`.`ID` ASC");
- mysql_store_result();
- while(mysql_retrieve_row())
- {
- bussines++;
- index++;
- new i = index;
- mysql_get_field("ID", result); BizzInfo[i][bID] = strval(result);
- mysql_get_field("Owned", result); BizzInfo[i][bOwned] = strval(result);
- mysql_get_field("Owner", result); strmid(BizzInfo[i][bOwner], result, 0, 32, 32);
- mysql_get_field("Message", result); strmid(BizzInfo[i][bMessage], result, 0, 100, 100);
- mysql_get_field("EntranceX", result); BizzInfo[i][bEntranceX] = floatstr(result);
- mysql_get_field("EntranceY", result); BizzInfo[i][bEntranceY] = floatstr(result);
- mysql_get_field("EntranceZ", result); BizzInfo[i][bEntranceZ] = floatstr(result);
- mysql_get_field("ExitX", result); BizzInfo[i][bExitX] = floatstr(result);
- mysql_get_field("ExitY", result); BizzInfo[i][bExitY] = floatstr(result);
- mysql_get_field("ExitZ", result); BizzInfo[i][bExitZ] = floatstr(result);
- mysql_get_field("LevelNeeded", result); BizzInfo[i][bLevelNeeded] = strval(result);
- mysql_get_field("BuyPrice", result); BizzInfo[i][bBuyPrice] = strval(result);
- mysql_get_field("EntranceCost", result); BizzInfo[i][bEntranceCost] = strval(result);
- mysql_get_field("Till", result); BizzInfo[i][bTill] = strval(result);
- mysql_get_field("Locked", result); BizzInfo[i][bLocked] = strval(result);
- mysql_get_field("Interior", result); BizzInfo[i][bInterior] = strval(result);
- mysql_get_field("Products", result); BizzInfo[i][bProducts] = strval(result);
- mysql_get_field("MaxProducts", result); BizzInfo[i][bMaxProducts] = strval(result);
- mysql_get_field("PriceProd", result); BizzInfo[i][bPriceProd] = strval(result);
- mysql_get_field("Virtual", result); BizzInfo[i][bVirtual] = strval(result);
- if(BizzInfo[i][bOwned] == 0)
- {
- DestroyDynamic3DTextLabel(BizzLabel[i]);
- format(PropertyString, sizeof(PropertyString),"{357AB7}%s \n{FFFFFF}Business {357AB7}#%d \n{357AB7}This Business is for sale(/buybiz) ! \n {FFFFFF}Price: {357AB7}%s \n{FFFFFF}Level: {357AB7}%d",BizzInfo[i][bMessage],i,FormatNumber(BizzInfo[i][bBuyPrice]),BizzInfo[i][bLevelNeeded]);
- BizzLabel[i] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFFF,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
- CreateDynamicPickup(1239, 1, BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
- pickups++;
- }
- else if(BizzInfo[i][bOwned] == 1)
- {
- DestroyDynamic3DTextLabel(BizzLabel[i]);
- format(PropertyString, sizeof(PropertyString),"{357AB7}%s \n{FFFFFF}Business {357AB7}#%d \n{FFFFFF}Owner: {357AB7}%s \n{FFFFFF}Fee: {357AB7}$%s",BizzInfo[i][bMessage],i,BizzInfo[i][bOwner],FormatNumber(BizzInfo[i][bEntranceCost]));
- BizzLabel[i] = CreateDynamic3DTextLabel(PropertyString ,0x0066FFFF,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
- CreateDynamicPickup(1239, 1, BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]);
- pickups++;
- }
- }
- mysql_free_result();
- printf("Bussines: %d", index);
- return 1;
- }
Add Comment
Please, Sign In to add comment