Help MySQL
#15

CMD:createdealer(playerid, params[])
Code:
CMD:createdealer(playerid, params[])
{
	new
	    price,
		dealername[32],
		Float:radius,
		dealershipid = -1,
		bool:assigned = false,
		string[256],
		Float:x,
		Float:y,
		Float:z;

	GetPlayerPos(playerid, x, y, z);

	if(sscanf(params, "dfs[32]", price, radius, dealername))
		return SendClientMessage(playerid, -1, "* [Usage]: /createdealer [price] [radius] [name of dealership]");

	for(new i = 1; i < MAX_DEALERSHIPS; i++)
	{
	    if(dealership_taken[i] == false)
	    {
	        dealershipid = i;
	        assigned = true;
	        break;
		}
	}
	if(assigned == false) return SendClientMessage(playerid, -1, "Something went wrong while creating the dealership !");
	strmid(DealershipStatistics[dealershipid][dealership_name], dealername, 0, strlen(dealername), 255);
	strmid(DealershipStatistics[dealershipid][dealership_owner], "No-one", 0, strlen("No-one"), 255);
	DealershipStatistics[dealershipid][dealership_price] = price;
	DealershipStatistics[dealershipid][dealership_owned] = 0;
	DealershipStatistics[dealershipid][dealership_x] = x;
	DealershipStatistics[dealershipid][dealership_y] = y;
	DealershipStatistics[dealershipid][dealership_z] = z;
	DealershipStatistics[dealershipid][dealership_radius] = radius;
	DealershipStatistics[dealershipid][dealership_id] = CreatePickup(1274, 23, x, y, z);
	format(string, sizeof(string), "{FF6347}%s{FFFFFF} is for sale!\n\n{FF6347}Price:{FFFFFF} $%d\n\nTo purchase this dealership, type /buydealer.", dealername, price);
	DealershipStatistics[dealershipid][dealership_label] = Create3DTextLabel(string, -1, x, y, z, 10.0, 0);
	format(string, sizeof(string), " Dealership %d created.", dealershipid);
	SendClientMessage(playerid, -1, string);
	dealership_taken[dealershipid] = true;

	new query[221];
	mysql_format(g_SQL, query, sizeof query, "INSERT INTO `dealerships` (`dealership_id`) VALUES ('%d')", DealershipStatistics[dealershipid][dealership_id]);
	mysql_tquery(g_SQL, query);

	SaveDealership(dealershipid);
	return 1;
}
Reply


Messages In This Thread
Help MySQL - by KamilPolska - 01.11.2018, 12:55
Re: Help MySQL - by TheToretto - 01.11.2018, 13:13
Re: Help MySQL - by KamilPolska - 01.11.2018, 13:33
Re: Help MySQL - by TheToretto - 01.11.2018, 13:49
Re: Help MySQL - by KamilPolska - 01.11.2018, 13:51
Re: Help MySQL - by Heress - 01.11.2018, 14:16
Re: Help MySQL - by KamilPolska - 01.11.2018, 15:07
Re: Help MySQL - by TheToretto - 01.11.2018, 15:39
Re: Help MySQL - by KamilPolska - 01.11.2018, 15:48
Re: Help MySQL - by TheToretto - 01.11.2018, 16:15
Re: Help MySQL - by KamilPolska - 01.11.2018, 16:43
Re: Help MySQL - by TheToretto - 01.11.2018, 16:50
Re: Help MySQL - by KamilPolska - 01.11.2018, 17:11
Re: Help MySQL - by KinderClans - 01.11.2018, 17:20
Re: Help MySQL - by KamilPolska - 01.11.2018, 17:28
Re: Help MySQL - by TheToretto - 01.11.2018, 17:35
Re: Help MySQL - by KamilPolska - 01.11.2018, 18:13
Re: Help MySQL - by TheToretto - 01.11.2018, 19:18
Re: Help MySQL - by KamilPolska - 01.11.2018, 20:29
Re: Help MySQL - by TheToretto - 01.11.2018, 20:56
Re: Help MySQL - by KamilPolska - 01.11.2018, 21:07

Forum Jump:


Users browsing this thread: 1 Guest(s)