CMD:fcreate(playerid,params[])
{
new query[115], DBResult: result, string[128];
if(isnull(params)) return SendClientMessage(playerid, -1, "{3498db}* [USAGE]: {FFFFFF} /fcreate [faction name]");
if(!strcmp(params,"INVALID",true)) return SendClientMessage(playerid, COLOR_LIGHTRED, "* Chosen faction name is invalid.");
format(query,sizeof(query),"SELECT FactionName FROM Factions WHERE FactionName = '%q'",params);
result = db_query(Database, query);
if(db_num_rows(result))
{
db_free_result(result);
return SendClientMessage(playerid, COLOR_LIGHTRED, "* This faction name already has been taken.");
}
db_free_result(result);
ShowPlayerDialog(playerid,DIALOG_FACTION_COLOR,DIALOG_STYLE_LIST,"Faction Color",""BLUE"Blue\n"RED"RED\n"WHITE"White\n"PINK"Pink\n"CYAN"Cyan\n"ORANGE"Orange\n"GREEN"Green\n"YELLOW"Yellow","Select","Cancel");
new Query[217];
format( Query, sizeof(Query), "INSERT INTO Factions (FactionName,FactionColor) VALUES ('%q','%q')", FactionInfo[playerid][factionname],FactionInfo[playerid][factioncolor]);
db_query(Database,Query);
result = db_query(Database, "SELECT last_insert_rowid()");
FactionInfo[playerid][factionid] = db_get_field_int(result);
db_free_result(result);
SendClientMessage(playerid, COLOR_YELLOW, "* You have sucessfully created a faction!");
format(string,sizeof(string),""GREEN"%s "WHITE"has created a new faction named "GREEN"%s!"WHITE"",FactionInfo[playerid][username],FactionInfo[playerid][factionname]);
SendClientMessageToAll(-1,string);
return 1;
}
format(query,sizeof(query),"SELECT `FactionName` FROM `Factions` WHERE `FactionName` = '%q'",params); format( Query, sizeof(Query), "INSERT INTO `Factions` (FactionName,FactionColor) VALUES ('%q','%q')",
Check if your database user, password, IP and database name are right.
|
new Query[217];
format(Query, sizeof(Query), "INSERT INTO `Factions` (FactionName,FactionColor) VALUES ('%q','%q')", db_query(Database,Query);
format(Query, sizeof(Query), "INSERT INTO `Factions` (`FactionName`,`FactionColor`) VALUES ('%q','%q')",FactionInfo[playerid][factionname],FactionInfo[playerid][factioncolor];
error 001: expected token: ",", but found ";" |