Add-On Releases - Stock Trader for vBulletin

Stock Trader

Summary

This add-on gives your users the ability to use the money system on your board to "invest" in stock. Users can purchase and sell stock at market values. This plugin uses a stock feed from Yahoo to get real time stock quotes.

Release Notes

This product is considered to still be in Beta.This should be ending by the end of January.

This add-on is known to be compatible with vBulletin's built-in reputation system, vbBux and iCash.

Product Specifications

1. two plugins
2. one cron job
3. file uploads
4. one new DB table
5. one template
6. several phrases

Installation
Approx 2-5 mins

1. As always: Back up your Database!
2. upload the files in the "upload" directory, preserving the directory structure
3. Go into AdminCP and import the product-stocktrader.xml file.
4. (OPTIONAL) add a link in the navbar template or wherever your users can find it!

Upgrading/Updating

1. upload all files in the upload directory, overwriting any existing files
2. re-import the XML file, setting "Overwrite" to "Yes"

Configuration

1. vBulletin Options -> Stock Trader Options

Change History

• 0.9.9 (07-25-01) - fixed problem with trading mutual funds, fixed cheat with buying off hours (I think)
• 0.9.8 (07-18-01) - added new options and fixed bug with purchasing really cheap stock
• 0.9.7 (07-15-01) - fixed bug in top portfolios when using a table prefix
• 0.9.6 (07-15-01) - fixed table prefix issues, fixed portfolio.gif problem
• 0.9.5 (07-14-01) - added statistics page, ability to view other user portfolios, and postbit friendly variables
• 0.9.4 (07-09-01) - added a Capital Gains Tax option
• 0.9.3 (07-02-01) - fixed error with purchasing negative stock, fixed compatibility with iCash
• 0.9.2 (07-05-01) - bug fixes
• 0.9.1 (06-30-12) - added AJAX stock info lookup
• 0.9.0 (06-29-12) - initial Beta release

Future Features

• stock ticker marquee for users

Official Support

http://code.google.com/p/vbtrade/

PLEASE CLICK INSTALL!

[Quantnet]

Anyone got a better portfolio.gif ?
my portfolio.gif image is not shown properly. It should have been /forum/images/misc/portfolio.gif but it points to /images/misc/portfolio.gif

To fix this, in vbtrade.php around line 496 change <img src='/images/misc/portfolio.gif' to <img src='images/misc/portfolio.gif'

[davidw]

Originally Posted by zethon

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.

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.

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.

Yes, I am, which the hack does cover to an extent (the query does set up the table prefix to vb_ in the sql error).

[zethon]

Originally Posted by Quantnet.org

Anyone got a better portfolio.gif ?
my portfolio.gif image is not shown properly. It should have been /forum/images/misc/portfolio.gif but it points to /images/misc/portfolio.gif

To fix this, in vbtrade.php around line 496 change <img src='/images/misc/portfolio.gif' to <img src='images/misc/portfolio.gif'

Damn leading slash, I will take care of that. Thanks!

Originally Posted by christianb

Yes, I am, which the hack does cover to an extent (the query does set up the table prefix to vb_ in the sql error).

I've found a couple instances where the table prefix was missing. This will be fixed in an update I'm about to post. Let me know if this fixes your issue.

[Quantnet]

Thanks for the quick response, zethon

The latest version fixed the amount display problem. Now it displays 100,000.000 instead of 100000.000

Thanks

[d8tabyte]

Originally Posted by d8tabyte

Yup me too cept I am running PHP Version 4.4.4 and VB 3.6.4

I am still recieving a DB error with that link.

<td class="vbmenu_option"><a href="vbtrade.php?do=main">$vbphrase[ambst_title]</a></td>
</tr>
<tr>	
<td class="vbmenu_option"><a href="vbtrade.php?do=topportfolios">$vbphrase[ambst_topinv]</a></td>

My nav bar code ( I have it included in a drop down )

The page with error
http://digitalet.net/forum/vbtrade.php?do=topportfolios

I have downloaded the latest version, overwrote all and re-imported product with overwrite on.

Database error in vBulletin 3.6.4:

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

MySQL Error : Unknown table 'user' in field list
Error Number : 1109

[Tulsa]

Originally Posted by Tulsa

When I load up the top portfolio screen, it's not populated at all. I get a nice header for members, portfolio value, total earning and percentage but nothing else is listed.

Well it's working now so I guess it needed to run it's cron job first before populating.

[davidw]

Originally Posted by zethon

Damn leading slash, I will take care of that. Thanks!

I've found a couple instances where the table prefix was missing. This will be fixed in an update I'm about to post. Let me know if this fixes your issue.

This still doesn't work - everything else works fine - but the portfolio as before.

[Quantnet]

How often is the value in postbit updated ?
My topportfolion http://www.quantnet.org/forum/vbtrad...=topportfolios show different values than when you go to the portfolio value http://www.quantnet.org/forum/vbtrad...olio&userid=74

[Magz]

Database error in vBulletin 3.6.4:

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

MySQL Error : Unknown table 'user' in field list
Error Number : 1109

I have had no other ussues while following this product, my users love it btw, but following all the updates, i still get the following error when trying to view the portfolios.

regards

[Lionel]

try adding "AS user"

FROM magical_user AS user