Reply to thread

Message

<blockquote data-quote="Altercationz" data-source="post: 448570" data-attributes="member: 59038">I seen a release from [USER=83881]@Hypothesis[/USER] which was a delete user command which didn't execute everything properly, or delete everything.&nbsp; This should do the trick.Credits to him for the idea.I don't know why'd you would need this as retros cant afford to lose any user nowadays.But, if you want to delete some annoying kid here you go <img src="/styles/icons/smile/bttv/LUL.png"&nbsp; class="smilie" loading="lazy" alt="LUL" title="LUL&nbsp; &nbsp; LUL" data-shortname="LUL" />- This command will check if the user has logged on within the last 3 days, if that happens to be true the user will not be deleted.- I put a couple sql queries to delete pretty much everything to not keep useless data in your tables.- I put a query which will give all of the user's rooms to you, never know if he has a sick room or something lmfao.- Obviously if the user is online it won't delete their account.- Can't delete anybody higher than rank 4.so yeah, have fun.[CODE]using System;using System.Linq;using System.Text;using System.Collections.Generic;using Plus.Communication.Packets.Incoming;using Plus.Communication.Packets.Outgoing.Rooms.Engine;using Plus.Communication.Packets.Outgoing.Users;using Plus.Database.Interfaces;using Plus.HabboHotel.GameClients;using Plus.Communication.Packets.Outgoing.Rooms.Chat;using Plus.Utilities;using Plus.HabboHotel.Users;namespace Plus.HabboHotel.Rooms.Chat.Commands.Administrator{&nbsp; &nbsp; class&nbsp; &nbsp; DeleteUserCommand : IChatCommand&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; public string PermissionRequired&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;command_delete&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Parameters&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;%username%&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public string Description&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; get { return &quot;Delete a user.&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Params.Length == 1)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;Oops, you forgot to enter the username! Command Usage: :delete (user)&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Habbo User = PlusEnvironment.GetHabboByUsername(Params[1]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DateTime Now = DateTime.Now;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; double LastLogin = Convert.ToSingle(Now.AddDays(-3));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; double OnlineNow = Convert.ToSingle(Now);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (User.LastOnline == LastLogin)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Session.SendWhisper(&quot;The user &quot; + Params[1] + &quot; has logged on within the last 3 days, therefore it cannot be deleted.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (User.LastOnline == OnlineNow)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (Session.GetHabbo().Username == User.Username)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (User.Rank &gt; 4)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter Adapter = PlusEnvironment.GetDatabaseManager().GetQueryReactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `users` WHERE username = '&quot; + User + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `user_stats` WHERE id = '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `user_info` WHERE user_id = '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `user_relationships` WHERE user_id = '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `user_login_attemps WHERE userid = '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;UPDATE `rooms` SET owner = '&quot; + Session.GetHabbo().Id + &quot;' WHERE owner = '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Adapter.RunQuery(&quot;DELETE FROM `user_achievements` WHERE userid =&nbsp; '&quot; + User.Id + &quot;' LIMIT 1&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }}[/CODE]</blockquote>

[QUOTE="Altercationz, post: 448570, member: 59038"] I seen a release from [USER=83881]@Hypothesis[/USER] which was a delete user command which didn't execute everything properly, or delete everything. This should do the trick. Credits to him for the idea. I don't know why'd you would need this as retros cant afford to lose any user nowadays. [B]But, [/B]if you want to delete some annoying kid here you go LUL - This command will check if the user has logged on within the last 3 days, if that happens to be true the user will not be deleted. - I put a couple sql queries to delete pretty much everything to not keep useless data in your tables. - I put a query which will give all of the user's rooms to you, never know if he has a sick room or something lmfao. - Obviously if the user is online it won't delete their account. - Can't delete anybody higher than rank 4. so yeah, have fun. [CODE] using System; using System.Linq; using System.Text; using System.Collections.Generic; using Plus.Communication.Packets.Incoming; using Plus.Communication.Packets.Outgoing.Rooms.Engine; using Plus.Communication.Packets.Outgoing.Users; using Plus.Database.Interfaces; using Plus.HabboHotel.GameClients; using Plus.Communication.Packets.Outgoing.Rooms.Chat; using Plus.Utilities; using Plus.HabboHotel.Users; namespace Plus.HabboHotel.Rooms.Chat.Commands.Administrator { class DeleteUserCommand : IChatCommand { public string PermissionRequired { get { return "command_delete"; } } public string Parameters { get { return "%username%"; } } public string Description { get { return "Delete a user."; } } public void Execute(GameClients.GameClient Session, Rooms.Room Room, string[] Params) { if (Params.Length == 1) { Session.SendWhisper("Oops, you forgot to enter the username! Command Usage: :delete (user)"); return; } Habbo User = PlusEnvironment.GetHabboByUsername(Params[1]); DateTime Now = DateTime.Now; double LastLogin = Convert.ToSingle(Now.AddDays(-3)); double OnlineNow = Convert.ToSingle(Now); if (User.LastOnline == LastLogin) { Session.SendWhisper("The user " + Params[1] + " has logged on within the last 3 days, therefore it cannot be deleted."); } if (User.LastOnline == OnlineNow) { return; } if (Session.GetHabbo().Username == User.Username) { return; } if (User.Rank > 4) { return; } using (IQueryAdapter Adapter = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { Adapter.RunQuery("DELETE FROM `users` WHERE username = '" + User + "' LIMIT 1"); Adapter.RunQuery("DELETE FROM `user_stats` WHERE id = '" + User.Id + "' LIMIT 1"); Adapter.RunQuery("DELETE FROM `user_info` WHERE user_id = '" + User.Id + "' LIMIT 1"); Adapter.RunQuery("DELETE FROM `user_relationships` WHERE user_id = '" + User.Id + "' LIMIT 1"); Adapter.RunQuery("DELETE FROM `user_login_attemps WHERE userid = '" + User.Id + "' LIMIT 1"); Adapter.RunQuery("UPDATE `rooms` SET owner = '" + Session.GetHabbo().Id + "' WHERE owner = '" + User.Id + "' LIMIT 1"); Adapter.RunQuery("DELETE FROM `user_achievements` WHERE userid = '" + User.Id + "' LIMIT 1"); } } } }[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members