Reply to thread

Message

<blockquote data-quote="Sledmore" data-source="post: 309133" data-attributes="member: 591">Your problem there is that you'll only ever have one result. Also, you should check this line:[PHP]id.addParameter(&quot;user&quot;, id);[/PHP]You have no error because the addParameter void requires an object(which you passed through), but you never use the &quot;user&quot; parameter, and have no reason to do it like that.Here is a little advice:[PHP]StringBuilder builder = new StringBuilder();builder.Append(&quot;Hey, &quot; + Session.GetHabbo().Username + &quot; Here is a list of Twitch Streamers, it will be Very Apreciated if you Follow these :D.\n&quot;);builder.Append(&quot;\n&quot;);using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().getQueryreactor()){&nbsp; &nbsp; //I removed the `id` column as it seemed you didn't use it, maybe ORDER BY?&nbsp; &nbsp; dbClient.setQuery(&quot;SELECT `username`,`twitch` FROM `twitch_users`&quot;);&nbsp; &nbsp; DataTable GetStreamers = dbClient.getTable();//Fetch the streamers.&nbsp; &nbsp; if (GetStreamers != null)//Check if there are any streamers.&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; foreach (DataRow Row in GetStreamers.Rows)//Iterate the rows, and append each streamer.&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Streamer:\n&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; builder.Append(&quot;Twitch Username: &quot; + Row[&quot;Twitch&quot;] + &quot; Twitch Link = http://twitch.tv/ &quot; + Row[&quot;Twitch&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; //This would be a nice place to append a string saying there are no streamers.&nbsp; &nbsp; }}builder.Append(&quot;Do you stream on twitch &amp; want to show here? Contact Brad in-game.\n&quot;);Session.SendNotifWithScroll(builder.ToString());[/PHP]Good job though, and keep it up. <img src="/styles/default/xenforo/smilies/emojione/tongue.png"&nbsp; class="smilie" loading="lazy" alt=":p" title="Stick Out Tongue&nbsp; &nbsp; :p" data-shortname=":p" /></blockquote>

[QUOTE="Sledmore, post: 309133, member: 591"] Your problem there is that you'll only ever have one result. Also, you should check this line: [PHP]id.addParameter("user", id);[/PHP] You have no error because the addParameter void requires an object(which you passed through), but you never use the "user" parameter, and have no reason to do it like that. [B] Here is a little advice:[/B] [PHP] StringBuilder builder = new StringBuilder(); builder.Append("Hey, " + Session.GetHabbo().Username + " Here is a list of Twitch Streamers, it will be Very Apreciated if you Follow these :D.\n"); builder.Append("\n"); using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().getQueryreactor()) { //I removed the `id` column as it seemed you didn't use it, maybe ORDER BY? dbClient.setQuery("SELECT `username`,`twitch` FROM `twitch_users`"); DataTable GetStreamers = dbClient.getTable();//Fetch the streamers. if (GetStreamers != null)//Check if there are any streamers. { foreach (DataRow Row in GetStreamers.Rows)//Iterate the rows, and append each streamer. { builder.Append("Streamer:\n"); builder.Append("Twitch Username: " + Row["Twitch"] + " Twitch Link = http://twitch.tv/ " + Row["Twitch"] + "\n"); builder.Append("in-game Username: " + Row["username"] + "\n"); builder.Append("\n"); } } else { //This would be a nice place to append a string saying there are no streamers. } } builder.Append("Do you stream on twitch & want to show here? Contact Brad in-game.\n"); Session.SendNotifWithScroll(builder.ToString());[/PHP] Good job though, and keep it up. :P [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members