vB Stocks 1.0.0 for vB 3.0.3

vB Stocks 1.0.0

by Antonbomb22(Anthony Scudese)

Compatiability:
Compatiable with 3.0.x(Tested on 3.0.3)

Description:
This hack uses Yahoo Finance's external CSV feature. It converts the CSV to a readable array. This allows you to get stock quotes(not realtime but updated daily) for whatever stocks Yahoo Finance provides via stock symbols(Google = GOOG). You can also get quotes on the DowJones. Also this hack allows your users to look up stocks that you may not have already being pulled from Yahoo Finance.

Author(s):
-AN-Net
-joeaic(developed code basis)

Code Based Off Of:
http://www.phpbuilder.com/snippet/de...snippet&id=163

Live Demo:
http://www.animationation.net/community/stocks.php

Support:
Any modification to the provided files is not supportable. I also hold the right to deny support to anyone at anytime.

Where to Get Support:
-Official vB Stocks Forum
-Aim: Antonbomb22
-Email: antonbomb22@animationation.net
-this thread

Special Thanks To:
Yahoo Finance for providing the CSV and great service

Zip Includes:
-install.txt
-stocks.php
-stocksmanager.php

[sim tech]

Originally Posted by interfx

Great add-on... Anyone figure out to add the actual company name yet???

Would this work? This is what I did, but I'm having problems having it write to the table & then xfer to the template.

I created a field in the stocks table in MySQL called 'comapnyname' and then modded the admin file so that it would write the company name to the table. (see image). It's close but no cigar yet. Do I have to make 'companyname' a global? Also - no data in the table as of yet. Anyone?? Thanx

PHP Code:

<?PHP

///////////////////////////////////
//vB Stocks(1.0.0) by Antonbomb22//
//Code Basis by joeaic/////////////
//May not be redisitributed,copied/
//or modifed without permission////
///////////////////////////////////

require_once('./global.php');

if(empty($_REQUEST['do']))
{
    $_REQUEST['do']="showstocks";
}

if($_REQUEST['do']=="showstocks")
{

    print_cp_header("Stock Manager");
    print_table_start();
    print_table_header("Manage Stocks", 3);

    print_cells_row("stocksymbol", "Stock Status", "stocktitle", "companyname", "Stock Options", 1, '', -1);
    $getstocks= $DB_site->query("SELECT stockname,active FROM ".TABLE_PREFIX."stocks");
    while($stock= $DB_site->fetch_array($getstocks))
    {
        if($stock['active']==1)
        {
            $status= "Active";
        }
        else
        {
            $status= "Inactive";
        }
        print "<tr class=\"".fetch_row_bgclass()."\"><td><a href=\"http://finance.yahoo.com/q?s=".$stock['stockname']."\">".$stock['stockname']."</a></td><td>".$status."</td><td>[<a href=\"stocksmanager.php?do=edit&sym=".$stock['stockname']."\">Edit</a>][<a href=\"stocksmanager.php?do=delete&sym=".$stock['stockname']."\">Delete</a>]</td></tr>";
    }
    print_table_footer();
}
if($_REQUEST['do']=="edit")


{
    $stock= $DB_site->query_first("SELECT stockname, active FROM ".TABLE_PREFIX."stocks");
    print_cp_header("Stock Edit: ".$stock['stockname']."'");
    print_form_header('stocksmanager', 'update');
    construct_hidden_code("origsym", $stock['stockname']);
    print_table_header("Stock Edit: ".$stock['stockname']."'");
    print_input_row("Stock Symbol:<dfn>example: YHOO, ^DJI, GOOG</dfn>", "stocksymbol", $stock['stockname'], "'");


//  ATG stock name mod


    print_input_row("Company Name:<dfn>example: Northwest Airlines</dfn>", "companyname", $stock['companyname'], "'");

    print_yes_no_row("Stock Active?", "active", $stock['active']);
    print_submit_row("Update Stock");


}
if($_POST['do']=="update")
{
    globalize($_POST, array(
        'stockname' => TEXT,
//    ATG *******************************************
        'companyname' => TEXT,
        'active' => INT,
        'origsym' => TEXT
    ));
    $DB_site->query("UPDATE ".TABLE_PREFIX."stocks SET stockname='".addslashes($stocksymbol)."', active=".$active." WHERE stockname='".addslashes($origsym)."'");
// ATG ********************************************
    $DB_site->query("UPDATE ".TABLE_PREFIX."stocks SET companyname='".addslashes($companyname). "'");

    define('CP_REDIRECT', 'stocksmanager.php?do=showstocks');
    print_stop_message('stock_updated_successfully');
}
if($_REQUEST['do']=="delete")
{
    $DB_site->query("DELETE FROM ".TABLE_PREFIX."stocks WHERE stockname='".addslashes($sym)."'");
    define('CP_REDIRECT', 'stocksmanager.php?do=showstocks');
    print_stop_message('stock_deleted_successfully');
}
if($_REQUEST['do']=="add")
{
    print_cp_header("Add Stock");
    print_form_header('stocksmanager', 'insert');
    print_table_header("Add Stock");
    print_input_row("Stock Symbol:<dfn>example: YHOO, ^DJI, NWAC</dfn>", "stocksymbol");
//   ATG *********************************************
    print_input_row("Company Name:<dfn>example: Northwest Airlines</dfn>", "companyname");

    print_yes_no_row("Stock Active?", "active", 0);
    print_submit_row("Add Stock");
}
if($_POST['do']=="insert")
{
    globalize($_POST, array(
        'stocksymbol' => TEXT,
        'active' => INT
    ));
    $DB_site->query("INSERT INTO ".TABLE_PREFIX."stocks (stockname,active) VALUES ('".addslashes($stocksymbol)."', ".intval($active).")");
    define('CP_REDIRECT', 'stocksmanager.php?do=showstocks');
    print_stop_message('stock_inserted_successfully');
}
print_cp_footer();
exit;
?>

[Marco van Herwaarden]

///////////////////////////////////
//vB Stocks(1.0.0) by Antonbomb22//
//Code Basis by joeaic/////////////
//May not be redisitributed,copied/
//or modifed without permission////
///////////////////////////////////

Maybe this is the problem

[sim tech]

Doh!

[scottct1]

I love this hack but my users hate it because they can not make their own portfolio.
Please start on version 2.0

[HHU]

Would Be Nice To See This Ported With Ability To Buy Stocks With Ucash

[Carl Anderson]

Originally Posted by HHU

Would Be Nice To See This Ported With Ability To Buy Stocks With Ucash

Agreed - a vb3.5 plugin.......

I would pay to have it...........

[HHU]

Can this be shown, only in one specific forum?

I only want to have it displaying in the top of my financial forum...

Thanks... nice hack if I can do that, I'll be installing this

[Carl Anderson]

Anyone working on this or something like it for 3.5? Will this hack be ported?

[Joe Blow]

I'm also interested in whether there is a version in the works for 3.5.X...

A great hack that deserves to live on with new versions of vbulletin!

[Joe Blow]

Will this hack work with vbulletin 3.5.X?

Would love to know if anyone has got it working or if there is a new version planned.