Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 414367" data-attributes="member: 36373">Yes it does have a fix..RoomData.cs Line 87:[CODE] if (!string.IsNullOrEmpty(Row[&quot;users_now&quot;].ToString()))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UsersNow = Convert.ToInt32(Row[&quot;users_now&quot;]);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UsersNow = 0;[/CODE]Change to this:[CODE]int intUsers;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(!string.IsNullOrEmpty(Row[&quot;users_now&quot;].ToString()) &amp;&amp; Int32.TryParse(Row[&quot;users_now&quot;].ToString(), out intUsers))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UsersNow = intUsers;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; UsersNow = 0;[/CODE]It could be faulting because the first code is testing to see if the string is Null or Empty, but then it doesn't check to see if its a valid integer when parsing. The 2nd code will do both.After doing the above you can run these queries as well:[CODE]ALTER TABLE `rooms` CHANGE `allow_pets` `allow_pets` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_pets_eat` `allow_pets_eat` INT(1) NOT NULL DEFAULT '0', CHANGE `room_blocking_disabled` `room_blocking_disabled` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_hidewall` `allow_hidewall` INT(1) NOT NULL DEFAULT '0', CHANGE `mute_settings` `mute_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `ban_settings` `ban_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `kick_settings` `kick_settings` INT(1) NOT NULL DEFAULT '1';[/CODE]</blockquote>

[QUOTE="JayC, post: 414367, member: 36373"] Yes it does have a fix.. RoomData.cs Line 87: [CODE] if (!string.IsNullOrEmpty(Row["users_now"].ToString())) UsersNow = Convert.ToInt32(Row["users_now"]); else UsersNow = 0;[/CODE] Change to this: [CODE] int intUsers; if(!string.IsNullOrEmpty(Row["users_now"].ToString()) && Int32.TryParse(Row["users_now"].ToString(), out intUsers)) UsersNow = intUsers; else UsersNow = 0; [/CODE] It could be faulting because the first code is testing to see if the string is Null or Empty, but then it doesn't check to see if its a valid integer when parsing. The 2nd code will do both. After doing the above you can run these queries as well: [CODE]ALTER TABLE `rooms` CHANGE `allow_pets` `allow_pets` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_pets_eat` `allow_pets_eat` INT(1) NOT NULL DEFAULT '0', CHANGE `room_blocking_disabled` `room_blocking_disabled` INT(1) NOT NULL DEFAULT '0', CHANGE `allow_hidewall` `allow_hidewall` INT(1) NOT NULL DEFAULT '0', CHANGE `mute_settings` `mute_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `ban_settings` `ban_settings` INT(1) NOT NULL DEFAULT '1', CHANGE `kick_settings` `kick_settings` INT(1) NOT NULL DEFAULT '1';[/CODE] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members