Reply to thread

Message

<blockquote data-quote="Mikee" data-source="post: 416954" data-attributes="member: 76567">sure but icba to code it properly,[CODE]public void SendNameColorPacket()&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (IsBot || GetClient() == null || GetClient().GetHabbo() == null)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //if (GetClient().GetHabbo().ChatColor == null || GetClient().GetHabbo().ChatColor == String.Empty)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //&nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (GetClient().GetHabbo().ChatPreference)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&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; dbClient.SetQuery(&quot;SELECT `rank_tag` FROM `users` WHERE username = '&quot; + GetClient().GetHabbo().Username + &quot;'&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; this.rankTag = dbClient.GetString();&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if (this.rankTag != String.Empty)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Username = &quot;&lt;font color='&quot; + GetClient().GetHabbo().ChatColor + &quot;'&gt; [&quot; + this.rankTag + &quot;] &quot; + GetClient().GetHabbo().Username + &quot;&lt;/font&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GetRoom().SendPacket(new UserNameChangeComposer(RoomId, VirtualId, Username));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; string Username = &quot;&lt;font color='&quot; + GetClient().GetHabbo().ChatColor + &quot;'&gt;&quot; + GetClient().GetHabbo().Username + &quot;&lt;/font&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GetRoom().SendPacket(new UserNameChangeComposer(RoomId, VirtualId, Username));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; }[/CODE]I DO NOT RECOMMEND USING THIS CODEIt will flood ur SQL Server.What you should do is store the RankTag as a session variable in Habbo.cs then call it.I released this bit as an example as to how it could be done.</blockquote>

[QUOTE="Mikee, post: 416954, member: 76567"] sure but icba to code it properly, [CODE]public void SendNameColorPacket() { if (IsBot || GetClient() == null || GetClient().GetHabbo() == null) return; //if (GetClient().GetHabbo().ChatColor == null || GetClient().GetHabbo().ChatColor == String.Empty) // return; if (GetClient().GetHabbo().ChatPreference) return; using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()) { dbClient.SetQuery("SELECT `rank_tag` FROM `users` WHERE username = '" + GetClient().GetHabbo().Username + "'"); this.rankTag = dbClient.GetString(); } if (this.rankTag != String.Empty) { string Username = " [" + this.rankTag + "] " + GetClient().GetHabbo().Username + ""; GetRoom().SendPacket(new UserNameChangeComposer(RoomId, VirtualId, Username)); return; } else { string Username = "" + GetClient().GetHabbo().Username + ""; GetRoom().SendPacket(new UserNameChangeComposer(RoomId, VirtualId, Username)); return; } }[/CODE] I DO NOT RECOMMEND USING THIS CODE It will flood ur SQL Server. What you should do is store the RankTag as a session variable in Habbo.cs then call it. I released this bit as an example as to how it could be done. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members