that edit didnt change anythign and my

uttpoints_pointsfield ----uttpoints
and
uttpoints_pointtable ----user

Well, I'm a bit puzzled then. Unless I'm just missing something blatently obvious. I don't have a well-used forum handy that uses uCash that I can try an duplicate this problem on. I tried to view your forum but it required registration for viewing.

Do you know how to run SQL commands using the console or mySQL? You could try running the select and what it looks like.

It should be:

[sql]SELECT u.username, p.uttpoints AS cash FROM user AS p LEFT JOIN user AS u ON u.userid=p.userid ORDER BY cash DESC LIMIT 5;[/sql]

i ran the quey and this si what it says

Creeper 990
Platinum~Pimp 98
|†|KryptoniK|†| 9485
shinoda 93
ºDissØrderlyº 9152
yo-yo's-r-us 91
madhatter 9
~*Ladie Berretta*~ 88
nimbus 87
STYLES 8679469
Blak Siinz 855
K-jun 85
Katana no Mune 83
Exact SkillZ 82
PURE*EVIL 80
ThOr-O 8
Denze 8
.:.¼¦¶Lü§.:. 8
Q_skinnypimp 8
Eye Solation 8

Oh, wait... it's using a character field, not an integer. So it uses "dictionary" ordering. Two ticks while I look up the mySQL syntax to cast a VARCHAR to an INT. =)

OK, if you do the following, it should fix that little problem:

Open includes/functions_vbookie.php

Find:
Replace with:

nope

Did for me. Are you sure you saved it? Uploaded it? What version of mySQL are you using? Did you try it at the console too?

i only use the one in the console

i can give you ful ladmin access to my site and ftp info and stuff and you can see if you can do it

What about:

Maybe your version of mySQL handles the +0 differently. The CONVERT() function should be the same though I think. I'm not sure about older versions of mySQL - this manual is for 4.0.9

Oh, I just read that "The CAST() and CONVERT() functions were added in MySQL 4.0.2. " so if you're on mySQL 3 then it'll still be unhappy. =) I'll look some more.