Reply to thread

Message

<blockquote data-quote="Brad" data-source="post: 308095" data-attributes="member: 17995">[SPOILER=&quot;:FAQ&quot;]Noting much but just thought I'd Release it.[PHP]case &quot;welcome&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (!this.Session.GetHabbo().GotCommand(&quot;commands&quot;))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return false;//2D3B;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ((Params[1] != null))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string username = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GameClient client6 = null;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; username = Params[1];&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; client6 = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(username);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Room room42 = client6.GetHabbo().CurrentRoom;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (client6 == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.Session.SendNotif(&quot;User could not be found.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; client6.SendWhisper(&quot;Welcome To Buzz Hotel, From &quot; + this.Session.GetHabbo().Username);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;//2D3B;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.Session.SendNotif(&quot;You left something empty.&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;[/PHP]Just change Plus to Mercury. yes I've renamed Mercury back to it's original name.only the user you sent it to will see it.Command line::welcome (username)Screenshot:<a href="http://gyazo.com/5aa23d51a93d37a8dc3b480fdfe35dad" target="_blank">http://gyazo.com/5aa23d51a93d37a8dc3b480fdfe35dad</a>[/SPOILER][SPOILER=&quot;TWITCH&quot;]Ok got a new command, :twitch<img src="http://i.gyazo.com/8aac8d6d47dfb059e1f94183b19c50f5.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />[SPOILER=&quot;CODE&quot;][PHP]case &quot;twitch&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &quot;stream&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case &quot;streamers&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter id = PlusEnvironment.GetDatabaseManager().getQueryreactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; StringBuilder builder = new StringBuilder();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Hey, &quot; + this.Session.GetHabbo().Username + &quot; Here is a list of Twitch Streamers, it will be Very Apreciated if you Follow these :D.\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id.setQuery(&quot;SELECT id,username,twitch FROM twitch_users&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; id.addParameter(&quot;user&quot;, id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DataRow row3 = id.getRow();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Streamer:\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Twitch Username: &quot;+row3[2]+&quot; Twitch Link = http://twitch.tv/ &quot;+row3[2]+ &quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;in-game Username: &quot; + row3[1] + &quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Do you stream on twitch &amp; want to show here? Contact Brad in-game.\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.Session.SendNotifWithScroll(builder.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;[/PHP][/SPOILER][SPOILER=&quot;MySQL Query&quot;][CODE]DROP TABLE IF EXISTS `twitch_users`;CREATE TABLE `twitch_users` (&nbsp; `id` int(11) unsigned NOT NULL AUTO_INCREMENT,&nbsp; `username` varchar(550) DEFAULT NULL,&nbsp; `twitch` varchar(255) DEFAULT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;-- ------------------------------ Records of twitch_users-- ----------------------------INSERT INTO `twitch_users` VALUES ('1', 'Brad', 'Cappercom');[/CODE][/SPOILER]You could altar this for Fansites if your hotel Promotes them, This is yet an easy and quick command,[/SPOILER][SPOILER=&quot;Fansites&quot;][PHP]case &quot;fansites&quot;:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter id = PlusEnvironment.GetDatabaseManager().getQueryreactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; StringBuilder builder = new StringBuilder();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Hey, &quot; + Session.GetHabbo().Username + &quot; Here is a list of Our Official Fansites, it will be Very Apreciated if you check then out :D.\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; builder.Append(&quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().getQueryreactor())&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; dbClient.setQuery(&quot;SELECT `name`,`username`,`link` FROM `fansites`&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; DataTable GetFansites = dbClient.getTable();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (GetFansites != null)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow Row in GetFansites.Rows)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Fansite:\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Fansite Name: &quot; + Row[&quot;name&quot;] + &quot; Fansite Link = &quot; + Row[&quot;link&quot;] + &quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;in-game Username: &quot; + Row[&quot;username&quot;] + &quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;There are currently no Fansites.\n&quot;);&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; }}builder.Append(&quot;Want yours to show here? Message (your username) in-game to sort this out! :D\n&quot;);Session.SendNotifWithScroll(builder.ToString());&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;[/PHP][CODE]CREATE TABLE `fansites` (&nbsp; `name` int(11) unsigned NOT NULL AUTO_INCREMENT,&nbsp; `username` varchar(550) DEFAULT NULL,&nbsp; `link` varchar(255) DEFAULT NULL,) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;[/CODE][/SPOILER]</blockquote>

[QUOTE="Brad, post: 308095, member: 17995"] [SPOILER=":FAQ"]Noting much but just thought I'd Release it. [PHP]case "welcome": if (!this.Session.GetHabbo().GotCommand("commands")) { return false;//2D3B; } if ((Params[1] != null)) { string username = null; GameClient client6 = null; username = Params[1]; client6 = PlusEnvironment.GetGame().GetClientManager().GetClientByUsername(username); Room room42 = client6.GetHabbo().CurrentRoom; if (client6 == null) { this.Session.SendNotif("User could not be found."); return true; } client6.SendWhisper("Welcome To Buzz Hotel, From " + this.Session.GetHabbo().Username); return true;//2D3B; } this.Session.SendNotif("You left something empty."); return true;[/PHP] Just change Plus to Mercury. yes I've renamed Mercury back to it's original name. only the user you sent it to will see it. Command line: :welcome (username) Screenshot: [URL]http://gyazo.com/5aa23d51a93d37a8dc3b480fdfe35dad[/URL][/SPOILER] [SPOILER="TWITCH"] Ok got a new command, :twitch [IMG]http://i.gyazo.com/8aac8d6d47dfb059e1f94183b19c50f5.png[/IMG] [SPOILER="CODE"] [PHP]case "twitch": case "stream": case "streamers": { using (IQueryAdapter id = PlusEnvironment.GetDatabaseManager().getQueryreactor()) { StringBuilder builder = new StringBuilder(); builder.Append("Hey, " + this.Session.GetHabbo().Username + " Here is a list of Twitch Streamers, it will be Very Apreciated if you Follow these :D.\n"); builder.Append("\n"); id.setQuery("SELECT id,username,twitch FROM twitch_users"); id.addParameter("user", id); DataRow row3 = id.getRow(); builder.Append("Streamer:\n"); builder.Append("Twitch Username: "+row3[2]+" Twitch Link = http://twitch.tv/ "+row3[2]+ "\n"); builder.Append("in-game Username: " + row3[1] + "\n"); builder.Append("\n"); builder.Append("\n"); builder.Append("Do you stream on twitch & want to show here? Contact Brad in-game.\n"); this.Session.SendNotifWithScroll(builder.ToString()); } } return true;[/PHP] [/SPOILER] [SPOILER="MySQL Query"] [CODE]DROP TABLE IF EXISTS `twitch_users`; CREATE TABLE `twitch_users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(550) DEFAULT NULL, `twitch` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of twitch_users -- ---------------------------- INSERT INTO `twitch_users` VALUES ('1', 'Brad', 'Cappercom');[/CODE] [/SPOILER] You could altar this for Fansites if your hotel Promotes them, This is yet an easy and quick command, [/SPOILER] [SPOILER="Fansites"] [PHP]case "fansites": { using (IQueryAdapter id = PlusEnvironment.GetDatabaseManager().getQueryreactor()) { StringBuilder builder = new StringBuilder(); builder.Append("Hey, " + Session.GetHabbo().Username + " Here is a list of Our Official Fansites, it will be Very Apreciated if you check then out :D.\n"); builder.Append("\n"); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().getQueryreactor()) { dbClient.setQuery("SELECT `name`,`username`,`link` FROM `fansites`"); DataTable GetFansites = dbClient.getTable(); if (GetFansites != null) { foreach (DataRow Row in GetFansites.Rows) { builder.Append("Fansite:\n"); builder.Append("Fansite Name: " + Row["name"] + " Fansite Link = " + Row["link"] + "\n"); builder.Append("in-game Username: " + Row["username"] + "\n"); builder.Append("\n"); } } else { builder.Append("There are currently no Fansites.\n"); } } builder.Append("Want yours to show here? Message (your username) in-game to sort this out! :D\n"); Session.SendNotifWithScroll(builder.ToString()); } } return true;[/PHP] [CODE]CREATE TABLE `fansites` ( `name` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(550) DEFAULT NULL, `link` varchar(255) DEFAULT NULL, ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;[/CODE] [/SPOILER] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members