Dodger Posted March 7, 2012 Share Posted March 7, 2012 I'm looking for someone to help me fix an issue with my hospital and jail both always showing 0 players whether empty or not. Paying by paypal. Thanks Quote Link to comment Share on other sites More sharing options...
Uridium Posted March 7, 2012 Share Posted March 7, 2012 I'll have a quick look at my copy and make a fix... Quote Link to comment Share on other sites More sharing options...
Mystical Posted March 7, 2012 Share Posted March 7, 2012 I'm looking for someone to help me fix an issue with my hospital and jail both always showing 0 players whether empty or not. Paying by paypal. Thanks I had the same problem. I finally figured out that the crons needed to be running to show the people in the jail or hospital. Are your crons running? Quote Link to comment Share on other sites More sharing options...
rulerofzu Posted March 7, 2012 Share Posted March 7, 2012 Yeah the cron needs to be running. IDK what made them think that was a good idea but my suggestion would be to remove it Quote Link to comment Share on other sites More sharing options...
Dabomstew Posted March 7, 2012 Share Posted March 7, 2012 Every v2 release has had the crons update hospital/jail count since otherwise it wasted 2 queries every page. Making sure they're on will solve any such problem Quote Link to comment Share on other sites More sharing options...
Dodger Posted March 7, 2012 Author Share Posted March 7, 2012 Thanks for the info all, the minute cron isnt running properly. I'm on a paid host that allows 1 minute crons Quote Link to comment Share on other sites More sharing options...
rulerofzu Posted March 7, 2012 Share Posted March 7, 2012 Every v2 release has had the crons update hospital/jail count since otherwise it wasted 2 queries every page. Making sure they're on will solve any such problem No it wouldnt if you did it correctly. Quote Link to comment Share on other sites More sharing options...
Dabomstew Posted March 7, 2012 Share Posted March 7, 2012 No it wouldnt if you did it correctly. Do elaborate if you wish here or in a PM; i see a way to make it 1 query per pageload for the both but no more efficient than that without *some* form of cache, or updating a count every time someone enters/leaves one of the two. Quote Link to comment Share on other sites More sharing options...
HauntedDawg Posted March 7, 2012 Share Posted March 7, 2012 Use, query caching. http://devzone.zend.com/171/sql-query-caching/ Quote Link to comment Share on other sites More sharing options...
Dabomstew Posted March 7, 2012 Share Posted March 7, 2012 That has the same shortfalls as caching it any other way in V2 since we load settings either way. But it is interesting for other purposes. Quote Link to comment Share on other sites More sharing options...
HauntedDawg Posted March 7, 2012 Share Posted March 7, 2012 I don't think you understand the concept of "Caching". Also, if your game has 1000 active user's, theres no need for a number to be displayed in any case. As you'll always know there WILL be some one in the hospital or jail. To me, having a counter next to the jail or hospital is for small games. Quote Link to comment Share on other sites More sharing options...
Dodger Posted March 11, 2012 Author Share Posted March 11, 2012 My 1 minute cron isn't running, when I manually run it I get this error message on the page Critical Error A critical error has occurred, and this page cannot be displayed. Please try again later. Query failed. Any help would be much appreciated Quote Link to comment Share on other sites More sharing options...
Dabomstew Posted March 11, 2012 Share Posted March 11, 2012 The v2.0.4 cron_minute file has a small bug in it causing this issue. It will be fixed in a future patch but here's the immediate fix: Open the file, and replace every time it has GREATER (there should be 2) with GREATEST. Save and it should work. Quote Link to comment Share on other sites More sharing options...
Dodger Posted March 11, 2012 Author Share Posted March 11, 2012 Thanks that did the trick Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.