I need a little help - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: I need a little help (/showthread.php?tid=647057)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: I need a little help (/showthread.php?tid=647057)
I need a little help - C5Perfect - 29.12.2017
PHP код:
stock LoadBusinesses()
{
for(new BizzID = 0; BizzID < MAX_BUSINESSES; BizzID++)
{
new query[300], savingstring[200], ifnotowned[144], ifisowned[144];
format(query, sizeof(query), "SELECT * FROM Businesses WHERE ID ='%d' LIMIT 1", BizzID);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
mysql_fetch_row(query);
mysql_fetch_field_row(savingstring, "Price"); BusinessInfo[BizzID][bPrice] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Interior"); BusinessInfo[BizzID][bInterior] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Owned"); BusinessInfo[BizzID][bOwned] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Owner"); BusinessInfo[BizzID][bOwner] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Stored"); BusinessInfo[BizzID][bStored] = strval(savingstring);
mysql_fetch_field_row(savingstring, "X"); BusinessInfo[BizzID][bX] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Y"); BusinessInfo[BizzID][bY] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Z"); BusinessInfo[BizzID][bZ] = strval(savingstring);
mysql_fetch_field_row(savingstring, "EnterX"); BusinessInfo[BizzID][bEnterX] = strval(savingstring);
mysql_fetch_field_row(savingstring, "EnterY"); BusinessInfo[BizzID][bEnterY] = strval(savingstring);
mysql_fetch_field_row(savingstring, "EnterZ"); BusinessInfo[BizzID][bEnterZ] = strval(savingstring);
mysql_fetch_field_row(savingstring, "Level"); BusinessInfo[BizzID][bLevel] = strval(savingstring);
if(BusinessInfo[BizzID][bLevel] == 1)// 24/7
{
format(ifnotowned, sizeof(ifnotowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Status: {FFFFFF}For Sale\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}24/7", BizzID, BusinessInfo[BizzID][bPrice]);
format(ifisowned, sizeof(ifisowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Owner: {FFFFFF}%s\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}24/7", BizzID, BusinessInfo[BizzID][bOwner], BusinessInfo[BizzID][bPrice]);
}
else if(BusinessInfo[BizzID][bLevel] == 2) // Disco
{
format(ifnotowned, sizeof(ifnotowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Status: {FFFFFF}For Sale\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}Disco", BizzID, BusinessInfo[BizzID][bPrice]);
format(ifisowned, sizeof(ifisowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Owner: {FFFFFF}%s\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}Disco", BizzID, BusinessInfo[BizzID][bOwner], BusinessInfo[BizzID][bPrice]);
}
else if(BusinessInfo[BizzID][bLevel] == 3) // Bar
{
format(ifnotowned, sizeof(ifnotowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Status: {FFFFFF}For Sale\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}Bar", BizzID, BusinessInfo[BizzID][bPrice]);
format(ifisowned, sizeof(ifisowned), "{00FF00}Business ID: {FFFFFF}%d\n{00FF00}Owner: {FFFFFF}%s\n{00FF00}Price: {FFFFFF}%d$\n{00FF00}Type: {FFFFFF}Bar", BizzID, BusinessInfo[BizzID][bOwner], BusinessInfo[BizzID][bPrice]);
}
if(BusinessInfo[BizzID][bOwned] == 0)
{
BusinessInfo[BizzID][bPick] = CreatePickup(1318, 1, BusinessInfo[BizzID][bX], BusinessInfo[BizzID][bY], BusinessInfo[BizzID][bZ], 0);
BusinessInfo[BizzID][bLabel] = Create3DTextLabel(ifnotowned, 0xFFFFFFFF, BusinessInfo[BizzID][bX], BusinessInfo[BizzID][bY], BusinessInfo[BizzID][bZ], 25.0, 0, 0);
}
else if(BusinessInfo[BizzID][bOwned] == 1)
{
BusinessInfo[BizzID][bPick] = CreatePickup(1318, 1, BusinessInfo[BizzID][bX], BusinessInfo[BizzID][bY], BusinessInfo[BizzID][bZ], 0);
BusinessInfo[BizzID][bLabel] = Create3DTextLabel(ifisowned, 0xFFFFFFFF, BusinessInfo[BizzID][bX], BusinessInfo[BizzID][bY], BusinessInfo[BizzID][bZ], 25.0, 0, 0);
}
businessid++;
}
}
printf("LOADED BIZZS: %d/%d", businessid, MAX_BUSINESSES);
mysql_free_result();
}
// ----------
but it doesn't create any business.. i can't find the problem.. help?
Re: I need a little help - Jstylezzz - 29.12.2017
What does it say in the console? Does the line 'LOADED BIZZS: xx/xx" show up at all? If it does and there are 0 businesses, then you probably don't have any entries in your SQL database.
Re: I need a little help - C5Perfect - 29.12.2017
@Jstylezzz
Thanks for the reply! It appears and is showing right information
Re: I need a little help - C5Perfect - 29.12.2017
bump
Re: I need a little help - Jstylezzz - 29.12.2017
Your query only retrieves 1 result from the database.
PHP код:
format(query, sizeof(query), "SELECT * FROM Businesses WHERE ID ='%d' LIMIT 1", BizzID);