vBa CMPS Stock Addon

Compatibility: 3.0.x
Tested On: 3.0.3

What does the hack do?

This is an addon for vBadvanced CMPS, it uses AN-NET's stock hack to provide a module for your portal.

You must have vB Stocks already installed, this includes all required templates, files, and database changes.

Install Process:

(1) New File
(2) New Templates
(1) New CMPS module

Install Time: Quick, Less then 5 Minutes

Screen Shots Can Be Seen Below

Please click

Updates:
Reduce one query, template error
Now the module's "change" color depends on whether it's a negative or postive change. Screen Shot's below

[KW802]

Ah, you got it working. Looks nice.

[interfx]

Awesome, works great...

Found a bug that adds an additional query. For those who installed this hack please add

stocks_dropdown

into the templates used section of the module. I edited the zip file too. Sorry about that.

[interfx]

I'm getting a connection refused error on line 15 of stocksmanager.php... Bringin my site to a "crawl"...

Anyone else have this issue? I posed this on VBStocks, but not sure where this coming from... I installed this add on for VB CMPS, maybe I'm pullign to much from Yahoo???

Anyone seen this?

It still works fine on the stocks.php page, but when I add module onto home page, it says connection refused...

That's odd, it's working for me. If the actual stocks hack works, so should the addon since there both doing the same exact thing...have you narrowed it down to this addon or are there others that can be causing this?

Also, the stocksmanager.php is part of AN-net's stock hack, so I think he'll be able to fix it for you.

I updated the addon so the font-color of the "change" is green if the change is postive and it's red if the change is negative.

For those who have this installed change adv_portal_stocksbits

to this

<tr>
<td class="alt1" nowrap="nowrap"><a href="http://finance.yahoo.com/q?s=$quote[sym]" id="stock$quote[sym]">$quote[sym]</a>$dropdown</td>
<td class="alt2" nowrap="nowrap" align="center">$quote[lasttrade]</td>
<td class="alt1" nowrap="nowrap" align="center">$quote[open]</td>
<if condition="$quote[change]< 0"><td class="alt2" nowrap="nowrap" align="center" style="color:red">$quote[change]</td><else /><td class="alt2" nowrap="nowrap" align="center" style="color:green">$quote[change]</td></if>
<td class="alt1" nowrap="nowrap" align="center">$quote[day_lowrange] - $quote[day_highrange]</td>
<td class="alt2" nowrap="nowrap" align="center">$quote[volume]</td>
<td class="alt1" nowrap="nowrap" align="center">$quote[update_date] - $quote[update_time]</td>
</tr>

and for those who want to install it, I updated the zip so it will work.

-Danny.

[YLP1]

Hi everyone... I am running ver 3.0.7 and when I activate this mod this is the error I am getting:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT stockname FROM vb3_stocks WHERE active=1
mysql error: Table 'ylpforums.vb3_stocks' doesn't exist

mysql error number: 1146

I am fairly new to VB and PHP so any guidance on how to fix this is greatly appreciated.

You need AN-NET's Stock Hack for this to work, it seems from the error you didnt run the query needed in his hack.

Here's a link to AN-net's hack, here

[SRuvbnhad]

Is there any reason that this should interfere with a RSS Newsfeed module? After I installed the two stock hacks it basically shut down the news feed. When I disabled the stock module it works perfectly again.