vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Add-On Releases - Stock Trader for vBulletin (https://vborg.vbsupport.ru/showthread.php?t=135084)

Quantnet 01-15-2007 06:50 PM

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 01-15-2007 07:09 PM

Quote:

Originally Posted by zethon (Post 1159972)
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 01-15-2007 08:46 PM

Quote:

Originally Posted by Quantnet.org (Post 1160075)
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!

Quote:

Originally Posted by christianb (Post 1160089)
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 01-15-2007 09:06 PM

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 01-16-2007 03:56 AM

Quote:

Originally Posted by d8tabyte (Post 1159603)
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.

HTML Code:

<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.


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

Tulsa 01-16-2007 01:01 PM

Quote:

Originally Posted by Tulsa (Post 1160061)
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 01-16-2007 02:25 PM

Quote:

Originally Posted by zethon (Post 1160152)
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 01-16-2007 05:13 PM

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 01-16-2007 06:40 PM

Quote:

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 01-16-2007 06:46 PM

try adding "AS user"

FROM magical_user AS user


All times are GMT. The time now is 02:52 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01518 seconds
  • Memory Usage 1,750KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_html_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete