[tjdrico]

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.