09.11.2018, 11:35
I when use /createclan and i'm created clan not saved in database.
how to fix
Errors:
how to fix

Errors:
Code:
[13:20:28] [ERROR] cache_get_field_content_int - invalid datatype [13:20:28] [ERROR] cache_get_field_content_int - invalid datatype
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; }