Reply to thread

Message

<blockquote data-quote="Brad" data-source="post: 308845" data-attributes="member: 17995">It's for the lets just say &quot;lazy&quot; users. I said it's nothing much, alot of users Requested me to add it so i did.[DOUBLEPOST=1413739248,1413738936][/DOUBLEPOST]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;]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; &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 <img src="/styles/default/xenforo/smilies/emojione/biggrin.png"&nbsp; class="smilie" loading="lazy" alt=":D" title="Big Grin&nbsp; &nbsp; :D" data-shortname=":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; &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 = <a href="http://twitch.tv/" target="_blank">http://twitch.tv/</a> &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return true;[/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,</blockquote>

[QUOTE="Brad, post: 308845, member: 17995"] It's for the lets just say "lazy" users. I said it's nothing much, alot of users Requested me to add it so i did.[DOUBLEPOST=1413739248,1413738936][/DOUBLEPOST]Ok got a new command, :twitch [IMG]http://i.gyazo.com/8aac8d6d47dfb059e1f94183b19c50f5.png[/IMG] [SPOILER="CODE"] 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 = [url]http://twitch.tv/[/url] "+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; [/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, [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members