Quote:
Originally Posted by dniMTheory
Got it installed with no problems at all. Perfect instructions.
A few things.
1. My "open until" and "payout on" dates are the same as the time I posted the thread.
It just says "This event will pay out after 1 Minute Ago at 12:00 AM" even though i set the payout for two days from now. Same thing for event info.
2. I'm using Ucash and the display of richest people is way off.
|
1. I've never had that problem, so it's difficult to suggest what the reason is without access to your forum/event. I will try to replicate it. What timezone are you using?
2. The query I'm using is this:
PHP Code:
$q = "SELECT u.username, p.".$vboptions['uttpoints_pointsfield']." AS cash FROM " . TABLE_PREFIX . $vboptions['uttpoints_pointtable']." AS p LEFT JOIN " . TABLE_PREFIX . "user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5";
That should work out something like:
[sql]
SELECT u.username, p.money AS cash FROM user AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5
[/sql]
It might be that I don't understand uCash properly, as I don't really use it. I'll try to find out what's what and iron out any glitches.