MySQL - invalid datatype
#1

I when use /createclan and i'm created clan not saved in database.
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;
}
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)