CMD:fazione(playerid, params[])
{
if (Player[playerid][AccountLevel] < 5) return 0;
new factionname[30], newrankname[30], rank, query[200];
if(sscanf(params, "s[30]ds[30]", factionname, rank, newrankname)) return SCM(playerid, COLOR_LIGHTRED, "* [USAGE]: /fazione [faction name] [rank to edit] [new rank name]");
format(query, sizeof(query), "UPDATE `Factions` SET `Name` = '%s', Rank1 = '%s'", factionname, newrankname);
mysql_tquery(g_SQL, query);
return 1;
}
sscanf(params, "s[30]ds[30]", factionname, rank, newrankname))
sscanf(params, "ds[30]s[30]", rank, factionname, newrankname))
format(query, sizeof(query), "UPDATE `Factions` SET `Name` = '%s', Rank1 = '%s'", factionname, newrankname);
mysql_tquery(g_SQL, query);
mysql_format(query, sizeof(query), "UPDATE `Factions` SET `Name` = '%e', Rank1 = '%e'", factionname, newrankname);
mysql_tquery(g_SQL, query);
CMD:editfrank(playerid, params[])
{
new string[128], rname[32], query[400], fid, rid;
if(sscanf(params, "dds[32]", fid, rid, rname)) return SCM(playerid, COLOR_WHITE, "USAGE: /editrank [faction id] [rank id] [rank name]\nTIPS: Rank ID = 1 - 10");
switch(rid)
{
case 1:
{
format(Factions[fid][Rank1], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 1 name to %s", fid, Factions[fid][Rank1]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank1 = '%s' WHERE ID = %d", Factions[fid][Rank1], fid);
mysql_tquery(g_SQL, query);
}
case 2:
{
format(Factions[fid][Rank2], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 2 name to %s", fid, Factions[fid][Rank2]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank2 = '%s' WHERE ID = %d", Factions[fid][Rank2], fid);
mysql_tquery(g_SQL, query);
}
case 3:
{
format(Factions[fid][Rank3], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 3 name to %s", fid, Factions[fid][Rank3]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank3 = '%s' WHERE ID = %d", Factions[fid][Rank3], fid);
mysql_tquery(g_SQL, query);
}
case 4:
{
format(Factions[fid][Rank4], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 4 name to %s", fid, Factions[fid][Rank4]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank4 = '%s' WHERE ID = %d", Factions[fid][Rank4], fid);
mysql_tquery(g_SQL, query);
}
case 5:
{
format(Factions[fid][Rank5], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 5 name to %s", fid, Factions[fid][Rank5]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank5 = '%s' WHERE ID = %d", Factions[fid][Rank5], fid);
mysql_tquery(g_SQL, query);
}
case 6:
{
format(Factions[fid][Rank6], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 6 name to %s", fid, Factions[fid][Rank6]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank6 = '%s' WHERE ID = %d", Factions[fid][Rank6], fid);
mysql_tquery(g_SQL, query);
}
case 7:
{
format(Factions[fid][Rank7], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 7 name to %s", fid, Factions[fid][Rank7]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank7 = '%s' WHERE ID = %d", Factions[fid][Rank7], fid);
mysql_tquery(g_SQL, query);
}
case 8:
{
format(Factions[fid][Rank8], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 8 name to %s", fid, Factions[fid][Rank8]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank8 = '%s' WHERE ID = %d", Factions[fid][Rank8], fid);
mysql_tquery(g_SQL, query);
}
case 9:
{
format(Factions[fid][Rank9], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 9 name to %s", fid, Factions[fid][Rank9]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank9 = '%s' WHERE ID = %d", Factions[fid][Rank9], fid);
mysql_tquery(g_SQL, query);
}
case 10:
{
format(Factions[fid][Rank10], 32, "%s", rname);
format(string, sizeof(string), "You have set faction id %d rank 10 name to %s", fid, Factions[fid][Rank10]);
mysql_format(g_SQL, query, sizeof(query), "UPDATE `Factions` SET Rank10 = '%s' WHERE ID = %d", Factions[fid][Rank10], fid);
mysql_tquery(g_SQL, query);
}
}
return 1;
}
Ok but the "Rank1" should not be static, since the admin has to choose WHICH rank to edit (Rank1, Rank2 etc).
How? |