[Freedom.]

Here is what you want

Код:

COMMAND:activekeys(playerid, params[])
{
	new Cache:result = mysql_query(g_SQL, "SELECT `key`, `score`, `money` FROM keys");
	if(cache_num_rows())
	{
    	new dialog_msg[256], key[25], score, money;
  		format(dialog_msg, sizeof  dialog_msg, "");
		format(dialog_msg, sizeof dialog_msg, "#\tKey\tScore\tMoney\n");
		for(new i = 0; i != cache_num_rows(); i++)
		{
		    cache_get_value_name(i, "key", key, 25);
			cache_get_value_name_int(i, "score", score);
			cache_get_value_name_int(i, "money", money);
			format(dialog_msg, sizeof dialog_msg, "%s%d\t%s\t%d\t%d\n", dialog_msg, i+1, key, score, money);
		}
		ShowPlayerDialog(playerid, 1234, DIALOG_STYLE_TABLIST_HEADERS, "Active Keys", dialog_msg, "Close", "");
	}
	cache_delete(result);
    return 1;
}

COMMAND:addkey(playerid, params[])
{
	new score, money, key[25];
	if(sscanf(params, "dds[25]", score, money, key))
	    return SendClientMessage(playerid, -1, "/addkey <score> <money> <key>");

	format(query, sizeof(query), "INSERT INTO `keys` (key, score, money) VALUES ('%s', %d, %d)", key, score, money);
	mysql_tquery(g_SQL, query);
    return 1;
}

COMMAND:key(playerid, params[])
{
	ShowPlayerDialog(playerid, 1235, DIALOG_STYLE_INPUT, "Input Key", "Enter the what you got", "Okay", "Close");
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    switch(dialogid)
    {
		case 1235:
        {
            new keytxt[256];
  		    mysql_escape_string(inputtext, keytxt);
  		    
			format(query, sizeof(query), "SELECT * FROM `keys` WHERE `key` = '%s'", keytxt);
			new Cache:result = mysql_query(g_SQL, query);
			
			if(cache_num_rows())
			{
				new key_id, score, money;
		  		cache_get_value_int(0, "id", key_id);
		    	cache_get_value_int(0, "score", score);
				cache_get_value_int(0, "money", money);

				GivePlayerMoney(playerid, money);
				GivePlayerScore(playerid, score);

				mysql_format(g_SQL, query, sizeof(query), "DELETE FROM `keys` WHERE `id` = %d", key_id);
				mysql_tquery(g_SQL, query);
		    }
		    else
			{
				SendClientMessage(playerid, -1, "It is used");
		    }

		    cache_delete(result);
			return 1;
		}
	}
	
	return 1;
}

CREATE TABLE `keys` (
  `id` int(3) NOT NULL auto_increment,
  `key` varchar(25) NOT NULL,
  `score` mediumint(6) NOT NULL,
  `money` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;