[davidw]

Originally Posted by zethon

The proper link should be: vbtrade.php?do=topportfolios

This link, along with the link in the installation text file, both give me a database error

Database error in vBulletin 3.6.3:

Invalid SQL:
SELECT user.userid,user.username,user.ambportval, user.ambportgainamt, user.ambportgainper FROM vb_user WHERE (user.ambportval > 0) ORDER BY user.ambportgainamt desc LIMIT 20;;

MySQL Error  : Unknown column 'user.userid' in 'field list'
Error Number : 1054
Date         : Sunday, January 14th 2007 @ 07:44:55 PM
Script       : mywebsite /vbtrade.php?do=topportfolios
Referrer     : 
IP Address   : nope
Username     : sorry
Classname    : vB_Database

I am using MySQL 5.0.20. Playing around with it and removing the user. in the field list and in the WHERE and ORDER BY temporarily issues a fix, but nothing is displayed for users.

Second, I just purchased stocks yet it shows a change - even though no change is displayed. Screenshot for clarification.

Third, just trivial, but why 3 digit decimal places?