[zethon]

Originally Posted by christianb

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.

I wonder, are you using a table prefix? I will have to go through the code and make sure everything is set up properly to work with table prefixes.

Originally Posted by christianb

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

Yes, that is how it's suppose to work. That change is the market change based on the last trade. Take a look at: http://finance.yahoo.com/q?s=twx

Even though the market is closed today, it still shows a "change". What you want to pay attention to to se how much you've made is the "Gain" and "Gain %" fields.

Originally Posted by christianb

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

Some of my users trade "penny stocks" where one share might cost .045 cents. WIth only two decimal places, it was impossible to make a profit all these stocks, so I took the mod to 3 decimal places.