Reply to thread

Message

<blockquote data-quote="Mikee" data-source="post: 420465" data-attributes="member: 76567">Jay is right, shoulda done it this way.Make a class for NameColours that gets called when a user loads up the client. It calls RetrieveColours.Then when setcolor is called, run a null check to make sure that RetrieveColours was actually called. So just check its size is greater 0.If is is, then access the public list ColorsAvailable from NameColours to get that color.UpdateColorsCommand would pretty much just run this RetrieveColours method again and store it. If you wanted to u could store it inside habbo.cs, but this should be enough to get u going. Don't have enough time to code it fully and proper and i did it on a texteditor, so excuse me for any linting errors.[CODE]public List&lt;int&gt; ColorsAvailable = new List&lt;int&gt;();NumberOfRows = 0;public static void RetreiveColours(){using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()){dbClient.SetQuery(&quot;SELECT COUNT(*) from colors&quot;);NumberOfRows = dbClient.GetInteger();for (x = 1; x &lt;= NumberOfRows; x++){&nbsp;dbClient.SetQuery(&quot;SELECT hex FROM colors WHERE id = '&quot; + x);&nbsp;Colours.Add(dbClient.GetInteger());}}[/CODE]edit: I realized u need the modify the code i have above, the list needs to be a hashmap instead. An array wouldn't work either. A hashmap would be needed to find the key and the value.</blockquote>

[QUOTE="Mikee, post: 420465, member: 76567"] Jay is right, shoulda done it this way. Make a class for NameColours that gets called when a user loads up the client. It calls RetrieveColours. Then when setcolor is called, run a null check to make sure that RetrieveColours was actually called. So just check its size is greater 0. If is is, then access the public list ColorsAvailable from NameColours to get that color. UpdateColorsCommand would pretty much just run this RetrieveColours method again and store it. If you wanted to u could store it inside habbo.cs, but this should be enough to get u going. Don't have enough time to code it fully and proper and i did it on a texteditor, so excuse me for any linting errors. [CODE] public List<int> ColorsAvailable = new List<int>(); NumberOfRows = 0; public static void RetreiveColours(){ using (IQueryAdapter dbClient = PlusEnvironment.GetDatabaseManager().GetQueryReactor()){ dbClient.SetQuery("SELECT COUNT(*) from colors"); NumberOfRows = dbClient.GetInteger(); for (x = 1; x <= NumberOfRows; x++){ dbClient.SetQuery("SELECT hex FROM colors WHERE id = '" + x); Colours.Add(dbClient.GetInteger()); } } [/CODE] edit: I realized u need the modify the code i have above, the list needs to be a hashmap instead. An array wouldn't work either. A hashmap would be needed to find the key and the value. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members