- Size: 2.35 KB
- MD5 Hash: 413768f06404f432a3fdf9f25375b3a7
- Downloads: 124
- Last Updated: 09-11-2011, 12:54 PM
- Uploaded: 09-11-2011, 12:54 PM
- MyBB Compatibility: 1.6
What does it do? It gets a number of random games and displays them on the index/portal/area of your choice.
WARNING: This query uses order by RAND() and is NOT cached. If you have memcache installed and working on your server then I can also add a cached version on request.
Order by RAND is not advisable where you have a large table to query - if you have less than 100 games on your board then this should be fine, otherwise I do NOT advise using this plugin.
leefish;9514 Wrote:WARNING: This query uses order by RAND() and is NOT cached. If you have memcache installed and working on your server then I can also add a cached version on request.
I dont know anything about php. So I couldnt understand this sentence. But one thing that I know is that this plugin is awesome and it works well. Thankyou very much for this plugin!
It is the order by RAND that does it Ted - over 100 games and it will hammer your DB and slow your board.
The other thing - is it will not be truly random. It will get a block of games from a random start point, so if the first game chosen is Game id 14, then the other games will be sequential, that is, games 14,15,16, 17 18.
BUT - it is quite fast.