755555555555

#include <a_samp>
#include <a_mysql>
#include <YSI_Coding\y_hooks>

enum {
    dialog_EASYQUEST,
};

enum QuestData {
	bool:qt_EasyQuest[3],
	bool:qt_EasyRewardQuest[3]
}
new questInfo[MAX_PLAYERS][QuestData];

private checkPlayerQuests(playerid)
{
	new rows;
	cache_get_row_count(rows);

	if(rows)
	{
        cache_get_value_name_int(0, "easy_quest_1", questInfo[playerid][qt_EasyQuest][0]);
        cache_get_value_name_int(0, "easy_quest_2", questInfo[playerid][qt_EasyQuest][1]);
        cache_get_value_name_int(0, "easy_quest_3", questInfo[playerid][qt_EasyQuest][2]);

        cache_get_value_name_int(0, "easy_reward_quest_1", questInfo[playerid][qt_EasyRewardQuest][0]);
        cache_get_value_name_int(0, "easy_reward_quest_2", questInfo[playerid][qt_EasyRewardQuest][1]);
        cache_get_value_name_int(0, "easy_reward_quest_3", questInfo[playerid][qt_EasyRewardQuest][2]);
	}
	else
	{
		new q[1000];
		mysql_format( _dbConnector, q, sizeof(q),
			"INSERT INTO `quests` (user_id, easy_quest_1, easy_quest_2, easy_quest_3, \
			easy_reward_quest_1, easy_reward_quest_2, easy_reward_quest_3) \
			VALUES('%d', '0', '0', '0', '0', '0', '0')", PI[playerid][pSqlID]);
		mysql_tquery( _dbConnector, q);
	}
	return 1;
}

private sql_UpdateQuest(playerid)
{
	new qQuest[1000];
	mysql_format( _dbConnector, qQuest, sizeof(qQuest), "UPDATE `quests` \
		SET `easy_quest_1`='%d', `easy_quest_2`='%d', `easy_quest_3`='%d' WHERE `user_id`='%d'",
		questInfo[playerid][qt_EasyQuest][0], questInfo[playerid][qt_EasyQuest][1], questInfo[playerid][qt_EasyQuest][2], PI[playerid][pSqlID]);
	mysql_tquery( _dbConnector, qQuest);

	mysql_format( _dbConnector, qQuest, sizeof(qQuest), "UPDATE `quests` \
		SET `easy_reward_quest_1`='%d', `easy_reward_quest_2`='%d', `easy_reward_quest_3`='%d' WHERE `user_id`='%d'",
		questInfo[playerid][qt_EasyRewardQuest][0], questInfo[playerid][qt_EasyRewardQuest][1], questInfo[playerid][qt_EasyRewardQuest][2], PI[playerid][pSqlID]);
	mysql_tquery( _dbConnector, qQuest);
	return 1;
}

CMD:zadaci(playerid, params[])
{
	new vrsta[8];
	if(sscanf(params, "s[8]", vrsta)) return Cmd(playerid, "/zadaci (pocetni/misije)");

	if(strcmp(vrsta, "pocetni", true) == 0)
	{
		new string[1128];
		format(string, sizeof(string), "#\tZADATAK\tSTATUS\tNAGRADA\n\
										"COL_BH"(1).\tPodigni novac sa racuna\t%s {FFFFFF}(%s{FFFFFF})\t50.000$\n\
										"COL_BH"(2).\tProcitaj listu novih stvari na /update\t%s {FFFFFF}(%s{FFFFFF})\t25.000$\n\
										"COL_BH"(3).\tNapravi 2.000 kill-s u DeathMatch Aren-i\t%s {FFFFFF}(%s{FFFFFF})\t500.000$",
			questInfo[playerid][qt_EasyQuest][0] == true ? "{469930}Rijeseno" : "{C14549}Nije rijeseno",
			questInfo[playerid][qt_EasyRewardQuest][0] == true ? "{469930}+" : "{C14549}-",
			questInfo[playerid][qt_EasyQuest][1] == true ? "{469930}Rijeseno" : "{C14549}Nije rijeseno",
			questInfo[playerid][qt_EasyRewardQuest][1] == true ? "{469930}+" : "{C14549}-",
			questInfo[playerid][qt_EasyQuest][2] == true ? "{469930}Rijeseno" : "{C14549}Nije rijeseno",
			questInfo[playerid][qt_EasyRewardQuest][2] == true ? "{469930}+" : "{C14549}-");
		ac_SPD(playerid, dialog_EASYQUEST, DIALOG_STYLE_TABLIST_HEADERS, "Zadaci - Pocetni", string, "Preuzmi", "Zatvori");
	}
	else if(strcmp(vrsta, "misije", true) == 0)
	{
		Error(playerid, "Trenutno nedostupno...");
	}
	else Cmd(playerid, "/zadaci (pocetni/misije)");
	return 1;
}