Reply to thread

Message

<blockquote data-quote="Seriosk" data-source="post: 410829" data-attributes="member: 72056">Lol.. not really awesome BUT..Hello. Many of you may of seen, or even coded a cool-down for an RP or hotel command. But what happens when the cool-down gets too large, and the user could just reload the client and bypass it? That is where this comes in.. it stores it in the database, so even if the emulator went down, the user would still have a cooldown on their head. It works via Date Times so it knows exactly when it was added, which results in it knowing exactly when it expires. With this tiny tiny tiny pretty useless library you can set cool downs for hours, days, weeks, anything you like.I've seen emulators such as Rage, Habbo, Fabbo, Holo all do horrible cooldown systems, but this system actually seems really easy to use, and its amazing how small it is, along with its amazing simplicity of using it.It's coded in pretty good standards, so it should be fine... It's in my opinion far better than any other cooldown system I have seen released on this forum.&nbsp; And before people starting commenting &quot;its useless&quot;, maybe.. but I just coded it for simple usage, I just shared it for people looking for the same thing.SQL:[CODE]DROP TABLE IF EXISTS `user_roleplay_cooldowns`;CREATE TABLE `user_roleplay_cooldowns` (&nbsp; `user_id` int(11) DEFAULT NULL,&nbsp; `cooldown_name` varchar(255) DEFAULT NULL,&nbsp; `cooldown_added` varchar(255) DEFAULT NULL,&nbsp; `cooldown_duration` int(11) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/CODE]C#:[CODE]namespace Plus.Roleplay.Handlers{&nbsp; &nbsp; using System;&nbsp; &nbsp; internal class RoleplayCooldownHandler&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public bool UserHasCooldown(int userId, string cooldownName)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (var databaseConnection = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.SetQuery(&quot;SELECT * FROM `rise_user_roleplay_cooldowns` WHERE `user_id` = @userId AND `cooldown_name` = @cooldownName&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;userId&quot;, userId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;cooldownName&quot;, cooldownName);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var cooldownRow = databaseConnection.GetRow();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (cooldownRow == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var dateTimeAdded = DateTime.Parse(Convert.ToString(cooldownRow[&quot;cooldown_added&quot;]));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var span = DateTime.Now - dateTimeAdded;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var duration = Convert.ToInt32(cooldownRow[&quot;cooldown_duration&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return !(span.TotalSeconds &gt;= duration);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void AddCooldown(int userId, string cooldownName, int cooldownDuration)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (var databaseConnection = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.SetQuery(&quot;INSERT INTO `rise_user_roleplay_cooldowns` (`user_id`, `cooldown_name`, `cooldown_added`, `cooldown_duration`) VALUES (@userId, @cooldownName, @cooldownAdded, @cooldownDuration)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;userId&quot;, userId);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;cooldownName&quot;, cooldownName);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;cooldownAdded&quot;, DateTime.Now.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.AddParameter(&quot;cooldownDuration&quot;, cooldownDuration);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; databaseConnection.RunQuery();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]</blockquote>

[QUOTE="Seriosk, post: 410829, member: 72056"] Lol.. not really awesome BUT.. Hello. Many of you may of seen, or even coded a cool-down for an RP or hotel command. But what happens when the cool-down gets too large, and the user could just reload the client and bypass it? That is where this comes in.. it stores it in the database, so even if the emulator went down, the user would still have a cooldown on their head. It works via Date Times so it knows exactly when it was added, which results in it knowing exactly when it expires. With this tiny tiny tiny pretty useless library you can set cool downs for hours, days, weeks, anything you like. I've seen emulators such as Rage, Habbo, Fabbo, Holo all do horrible cooldown systems, but this system actually seems really easy to use, and its amazing how small it is, along with its amazing simplicity of using it. It's coded in pretty good standards, so it should be fine... It's in my opinion far better than any other cooldown system I have seen released on this forum. And before people starting commenting "its useless", maybe.. but I just coded it for simple usage, I just shared it for people looking for the same thing. SQL: [CODE]DROP TABLE IF EXISTS `user_roleplay_cooldowns`; CREATE TABLE `user_roleplay_cooldowns` ( `user_id` int(11) DEFAULT NULL, `cooldown_name` varchar(255) DEFAULT NULL, `cooldown_added` varchar(255) DEFAULT NULL, `cooldown_duration` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;[/CODE] C#: [CODE]namespace Plus.Roleplay.Handlers { using System; internal class RoleplayCooldownHandler { public bool UserHasCooldown(int userId, string cooldownName) { using (var databaseConnection = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { databaseConnection.SetQuery("SELECT * FROM `rise_user_roleplay_cooldowns` WHERE `user_id` = @userId AND `cooldown_name` = @cooldownName"); databaseConnection.AddParameter("userId", userId); databaseConnection.AddParameter("cooldownName", cooldownName); var cooldownRow = databaseConnection.GetRow(); if (cooldownRow == null) { return false; } var dateTimeAdded = DateTime.Parse(Convert.ToString(cooldownRow["cooldown_added"])); var span = DateTime.Now - dateTimeAdded; var duration = Convert.ToInt32(cooldownRow["cooldown_duration"]); return !(span.TotalSeconds >= duration); } } public void AddCooldown(int userId, string cooldownName, int cooldownDuration) { using (var databaseConnection = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { databaseConnection.SetQuery("INSERT INTO `rise_user_roleplay_cooldowns` (`user_id`, `cooldown_name`, `cooldown_added`, `cooldown_duration`) VALUES (@userId, @cooldownName, @cooldownAdded, @cooldownDuration)"); databaseConnection.AddParameter("userId", userId); databaseConnection.AddParameter("cooldownName", cooldownName); databaseConnection.AddParameter("cooldownAdded", DateTime.Now.ToString()); databaseConnection.AddParameter("cooldownDuration", cooldownDuration); databaseConnection.RunQuery(); } } } }[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members