/*---------------------------------------------------------------------
-------------------Tanush Dynamic Rule Maker V1------------------------*/
#include <a_samp>
#include <zcmd>
#include <a_mysql>
#include <sscanf2>

#define COLOR_LIMEGREEN 0x32CD32AA
#define COLOR_YELLOW 0xFFFF00AA
#define lightyellow 0xFFFFA8FF
#define grey 0xAFAFAFAA
#define red 0xFF0000FF
#define MAX_RULES 10//edit if you like, your decision
new str[128],message[128],query[1000];
public OnFilterScriptInit()
{
	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}
CMD:rules(playerid,params[])
{
    new rID,rRule[128];
    format(query,sizeof(query),"SELECT * FROM Rules ORDER BY ID ASC");
    mysql_query(query);
    mysql_store_result();
    SendClientMessage(playerid,-1,"-------------------------Rules-------------------------");
    SendClientMessage(playerid,red,"Failing to follow these rules will result you in a admin punishment.");
    while(mysql_retrieve_row())
    {
        mysql_fetch_field_row(str,"ID"); rID = strval(str);
        mysql_fetch_field_row(rRule,"Message");
        format(str,sizeof(str),"%d. %s",rID,rRule);
        SendClientMessage(playerid,lightyellow,str);
    }
    mysql_free_result();
    return 1;
}
CMD:createrule(playerid,params[])
{
	new ruleid = GetRuleid();
	if(!IsPlayerAdmin(playerid)) return 0;
	if(sscanf(params,"s[128",message)) return SendClientMessage(playerid,grey,"USAGE: /createrule [message]");
	if(ruleid == 0) return SendClientMessage(playerid,red,"ERROR: You have reached the maximum ID");//lol you put 0, i know because when i
	format(str,sizeof(str),"INSERT INTO Rules (ID,Message) VALUES ('%d','%s')",GetRuleid(),message);
	mysql_query(str);
	format(str,sizeof(str),"You have created rule id %d, rule:",ruleid);
	SendClientMessage(playerid,COLOR_YELLOW,str);
	format(str,sizeof(str),"%s",message);
	SendClientMessage(playerid,-1,str);
	return 1;
}
CMD:deleterule(playerid,params[])
{
	new ruleid;
	if(!IsPlayerAdmin(playerid)) return 0;
	if(sscanf(params,"i",ruleid)) return SendClientMessage(playerid,grey,"USAGE: /deleterule [Rule ID]");
	format(str,sizeof(str),"SELECT * FROM Rules WHERE ID = '%d'",ruleid);
	mysql_query(str);
	mysql_store_result();
	if(mysql_num_rows() != 0)
	{
	    mysql_free_result();
	    format(str,sizeof(str),"You have deleted rule id %d",ruleid);
	    SendClientMessage(playerid,COLOR_LIMEGREEN,str);
	    format(str,sizeof(str),"DELETE FROM Rules WHERE ID = '%d'",ruleid);
	    mysql_query(str);
	}
	else
	{
	    SendClientMessage(playerid,red,"ERROR: This Rule ID is not created.");
	}
	return 1;
}
CMD:rhelp(playerid,params[])
{
	SendClientMessage(playerid,-1,"COMMANDS: /createrule (rcon) /deleterule (rcon) /rules (everyone)");
	return 1;
}
stock GetRuleid()
{
	for(new i=1; i<MAX_RULES; i++)
	{
		format(query,sizeof(query),"SELECT * FROM Rules WHERE `ID` = %d LIMIT 1",i);
	 	mysql_query(query);
	 	mysql_store_result();
		if(mysql_num_rows() == 0)
		{
		    mysql_free_result();
			return i;
		}
		mysql_free_result();
	}
	return 0;
}