I when use /createclan and i'm created clan not saved in database.
Code:
COMMAND:createclan(playerid,params[])
{
if(GetPlayerCash(playerid) >= 499999)
{
new cname[30], ctag[30];
if(!sscanf(params, "s[30]s[30]", cname, ctag))
{
CreateClan(playerid, cname, ctag, "1515", "", "Welcome.", 22, 25, 29, 180, 211, "New", "Member", "GoldMember", "Tester", "Coleadr", "Leader", "ClanMaker");
return 1;
} else Usage(playerid,"createclan <clan name> <clan tag>");
}
return 1;
}
Code:
stock CreateClan(playerid, clan_name[], clan_tag[], clan_pass[], clan_description[], clan_motd[],weap1, weap2, weap3, skin, skinex, crank1[], crank2[], crank3[], crank4[], crank5[], crank6[], crank7[])
{
if(strlen(clan_pass) < 3 || strlen(clan_pass) > 10) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan password lenght is {FF0000}invalid{FFFFFF}, please try again!");
if(IsPlayerAnyClanMember(playerid) == 0)
{
CallLocalFunction("OnPlayerClanCreate", "is", playerid, clan_name);
new clanquery3[100];
format(clanquery3, sizeof(clanquery3), "SELECT clanname FROM clans WHERE clanname = '%s'", clan_name);
mysql_query(1,clanquery3);
mysql_store_result();
new rows = mysql_num_rows();
if(rows >= 1) return SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}Clan with that name already exists!");
mysql_free_result();
new clanquery[300];
format(clanquery,sizeof(clanquery),"INSERT INTO clans(clanname, clantag, clanpass, clandes, clanmotd, weap1, weap2, weap3, skin, skinex, crank1, crank2, crank3, crank4, crank5, crank6, crank7) VALUES('%s', '%s', '%s', '%s', '%s', %d, %d, %d, %d, %d, '%s', '%s', '%s', '%s', '%s', '%s', '%s')", clan_name, clan_tag, clan_pass, clan_description, clan_motd, weap1, weap2, weap3, skin, skinex, crank1, crank2, crank3, crank4, crank5, crank6, crank7);
mysql_query(1,clanquery);
new player_name[MAX_PLAYER_NAME];
GetPlayerName(playerid,player_name,sizeof(player_name));
new clanquery2[300];
format(clanquery2,sizeof(clanquery2),"INSERT INTO members(clanname, playername, playerclanrank, isinclan) VALUES('%s', '%s', 7, 1)", clan_name, player_name);
mysql_query(1,clanquery2);
return 1;
}
else SendClientMessage(playerid,-1,"{FF0000}ERROR: {FFFFFF}You are already in a clan, you cant create new one!");
return 1;
}