The Arcive of Official vBulletin Modifications Site.

Stock Trader for vBulletin · **Released**: 12-29-2006

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

two plugins
one cron job
file uploads
one new DB table
one template
several phrases

Installation
Approx 2-5 mins

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

Upgrading/Updating

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

Configuration

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!

zethon · #**142** 01-14-2007, 11:23 PM

Quote:

Originally Posted by Quantnet.org

Can you give me instructions on how to display top 10 earners in Cyb - Advanced forum Stat mod ? Similar like top 10 posters....

I had Uncached templates: forumdisplay_sortarrow
when trying to reach vbtrade.php?do=topportfolios

I am not familiar with that plugin or what you're trying to do. You may want to ask the author of that mod how to include my data into his stats. :-\

davidw · #**143** 01-15-2007, 12:00 AM

Quote:

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

Code:

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?

xxxsaint · #**144** 01-15-2007, 01:27 AM

upgraded and running perfectly fine on 3.6.4!

Thanks so much , we all really appreciate your hard work

** Noticed though , that we now have commas in place on the amount of stock quantities owned. If you copy and paste your quantity into the " sell " box , it's not reading all of the digits past the 2nd comma, just a heads up , almost sold 7.2 million worth of stock for 7,200

d8tabyte · #**145** 01-15-2007, 05:23 AM

Quote:

Originally Posted by christianb

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

Code:

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?

Quote:

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
Date : Monday, January 15th 2007 @ 01:20:50 AM
Script : http://digitalet.net/forum/vbtrade.php?do=topportfolios
Referrer : http://digitalet.net/forum/vbtrade.php?do=main
IP Address : ....
Username : ...
Classname : vb_database

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

Quantnet · #**146** 01-15-2007, 05:32 AM

no error here php 4.4.4 and vb 3.6.4

Quantnet · #**147** 01-15-2007, 06:00 AM

anyone has a working demo of this mod using reputation as cash ? Did anyone got this working in postbit ?

zethon · #**148** 01-15-2007, 05:06 PM

Quote:

Originally Posted by christianb

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

Code:

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.

Quote:

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.

Quote:

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.

zethon · #**149** 01-15-2007, 05:07 PM

Quote:

Originally Posted by Quantnet.org

anyone has a working demo of this mod using reputation as cash ? Did anyone got this working in postbit ?

You can check out my board. I use reputation as the cash system and I also have the info working in postbit.

Quantnet · #**150** 01-15-2007, 06:15 PM

I sign up for your board to check out

I add this to my postbit_legacy

<span id="repdisplay_$post[postid]_$post[userid]">Portfolio :$post[ambportval] ($post[ambportgainper]%)</span></div>

This is how it shows Portfolio: 101505.000$ (0.039%) this should have been 3.9% but i notice you divide them to decimal.

I notice on your forum you have it shown as Porfolio: 9,323.75 rep
(+ 12%)

How do you add +/- in front of the percentage return. Also, can you add , in the thousand to make 100K become 100,000.000 as the way US uses.

Can we trim 000 after decimal point ? If those 3 decimals are all 0, why should we keep it.

Tulsa · #**151** 01-15-2007, 06:34 PM

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.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06273 seconds Memory Usage 2,332KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (8)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (1)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

Благодарность от:
ivanov73

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!