VegasKiller Posted June 18, 2013 Share Posted June 18, 2013 My stock script is only allowing shares to be bought in coca cola, I try to buy stocks in the other companies and they are not added to my portfolio. Can someone please help me? <?php echo "<table width='100%'><tr><td valign='left' width='95%'><font size=2 color=silver><b>Stock Market</b></font></td><td><table width=100%><tr><td align=right>"; include('../beta/files/link.php'); echo" Stock Market. Users can come buy stocks here. Stock values are calculated every 5 minutes and connect to the real stock ticker to give some realism to the feature. So like real stocks users have the chance to gain or lose stock value without random methods.'></a></td></tr></table><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br /><br />"; if(!isset($tools)){ echo"<font color=red><b>Error | It Seems Something Went Wrong Processing Your Account. Please Try Logging Out And Then Logging Back In. If The Problem Persists Please Email Support At [email protected]. We Apologize For The Inconvenience.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; session_destroy(); exit();} echo"<font color=red><b>Error | The Stock Market Is Currently Closed. Sorry For The Inconvenience.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; exit(); //********************************************* // SETTINGS //********************************************* $comission=".03"; //broker percentage based comission on all trades $comissiondisplay="3%"; //just used to show them how much their paying //********************************************* if ($action=="trade" AND $company) { // kill non numbers preg_match_all("/([0-9]+)/",$shares,$regs); $shares=implode("",$regs[1]); $sql_shares="SELECT shares, total FROM `stocks_shares` WHERE `company`='$company' AND `uid` ='" . $player->uid . "'"; $sql_shares=mysql_query($sql_shares); $row_shares=mysql_fetch_row($sql_shares); $port_total=$row_shares[1]; $port_shares=$row_shares[0]; $sql="SELECT `price`, `company` FROM `stocks_companies` WHERE `ticker`='$company'"; $sql=mysql_query($sql); $row=mysql_fetch_row($sql); $price=$row[0]; $name=$row[1]; $trade_value=$price * $shares; $comission_paid=$trade_value * $comission; if ($type=="buy") { $paid=$trade_value + $comission_paid; if($shares <= 0) { echo"<font color=red><b>Error | You Did Not Enter An Amount Of Stock Shares To Purchase.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; } elseif ($stats_array[cash] < $paid) { echo"<font color=red><b>Error | You Need At Least $".number_format($trade_value)." In Cash To Complete This Trade.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; } else { $sql="UPDATE `user_characters` SET `cash`=cash-$paid WHERE `uid`='" . $player->uid . "'"; mysql_query($sql); if(mysql_num_rows($sql_shares)==0) { $sql="INSERT INTO stocks_shares (`uid`,`company`,`shares`,`total`) VALUES('" . $player->uid . "', '$company','$shares','$trade_value')"; mysql_query($sql); } else { $sql="UPDATE `stocks_shares` SET `shares`=shares+$shares, `total`=total+$trade_value WHERE `uid`='" . $player->uid . "' AND `company`='$company'"; mysql_query($sql); } echo"<font color=green><b>Ciao | You Have Purchased ".number_format($shares)." Share(s) Of $name For $".number_format($paid).". The Broker Took A $commisiondisplay Fee Of $".number_format($comission_paid,2).".</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br /><META HTTP-EQUIV=Refresh CONTENT='5;url=driver.php?x=stockmarket'>"; } } elseif ($type=="sell") { $payout=$trade_value - $comission_paid; if($shares <= 0) { echo"<font color=red><b>Error | You Did Not Enter An Amount Of Stock Shares To Sell.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; } elseif($port_shares < $shares) { echo"<font color=red><b>Error | You Do Not Have ".number_format($shares)." Share(s) Of $name.</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; } else { if($port_shares==$shares) { $sql="DELETE FROM `stocks_shares` WHERE `uid`='" . $player->uid . "' AND `company`='$company'"; mysql_query($sql); } else { $sql="UPDATE `stocks_shares` SET shares=shares-$shares, total=total-$trade_value WHERE `uid`='" . $player->uid . "' AND `company`='$company'"; mysql_query($sql); } $sql="UPDATE `user_characters` SET `cash`=cash+$payout WHERE `uid`='" . $player->uid . "'"; mysql_query($sql); echo"<font color=green><b>Ciao | You Have Sold ".number_format($shares)." Share(s) Of $name For $".number_format($payout).". The Broker Took A $commisiondisplay Fee Of $".number_format($comission_paid,2).".</b></font><br /><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br /><META HTTP-EQUIV=Refresh CONTENT='5;url=driver.php?x=stockmarket'>"; } } } echo "<table width=100% align=center><tr valign=top><td align=center colspan=2>"; // BETTER DISPLAY echo "<table width='600' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr> <td bgcolor=#11111 align=center><font color=silver><b>Company</b></font></td> <td bgcolor=#11111 align=center><font color=silver><b>Sector</b></font></td> <td bgcolor=#11111 align=center><font color=silver><b>Price</b></font></td> <td bgcolor=#11111 align=center><font color=silver><b>Change Today</b></font></td> </tr>"; $color=1; $sql= "SELECT `ticker`, `company`, `industry`, `price`, `change` FROM `stocks_companies` ORDER BY `industry`"; $sql = mysql_query($sql); while($row=mysql_fetch_row($sql)) { $stocks_company[$row[0]]=$row[1]; $stocks_ticker[$row[1]]=$row[0]; $stocks_price[$row[0]]=$row[3]; if ($color==1) { $rowcolor="#11111"; $color=2; } else { $rowcolor="11111"; $color=1; } echo "<tr bgcolor=$rowcolor> <td align=center><a href=http://finance.yahoo.com/q?s=".$row[0]." target=_href><font color=#FFFFFF><b>".$row[1]."</b></></a></td> <td align=center><font color=#FFFFFF>".$row[2]."</font></td> <td align=center><font color=#FFFFFF>$".$row[3]."</td><td align=center>"; if ($row[4] < 0) { echo "<font color=red>"; } else { echo "<font color=lime>"; } echo "$row[4]</font></td></tr>"; } echo "</table><br /><center><img src='/beta/layout_images/headertop.gif' width=100% height=4></center><br />"; echo "</td><tr><td align=center valign=top>"; // BETTER DISPLAY echo "<font size=4 color=silver><center><b>Portfolio</b></center></font> <table width='80%' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr> <td bgcolor=11111 align=center><font color=silver><b>COMPANY</b></font></td> <td bgcolor=11111 align=center><font color=silver><b>SHARES</b></font></td> <td bgcolor=11111 align=center><font color=silver><b>VALUE</b></font></td> <td bgcolor=11111 align=center><font color=silver><b>GAIN/LOSS</b></font></td> </tr>"; $color=1; $sql= "SELECT company, shares, total FROM `stocks_shares` WHERE `uid`='" . $player->uid . "'"; $sql = mysql_query($sql); while($row=mysql_fetch_row($sql)) { if ($color==1) { $rowcolor="#111111"; $color=2; } else { $rowcolor="black"; $color=1; } $ticker=$row[0]; $value=$row[1] * $stocks_price[$ticker]; $gainorloss=$value - $row[2]; echo "<tr bgcolor=$rowcolor> <td align=center><a href=http://finance.yahoo.com/q?s=".$row[0]." target=_href><font color=#FFFFFF><b>$stocks_company[$ticker]</b></font></a></td> <td align=center><font color=#FFFFFF>".number_format($row[1])."</font></td> <td align=center><font color=#FFFFFF>$".number_format($value,2)."</font></td><td align=center>"; if ($gainorloss < 0) { echo "<font color=red>"; } else { echo "<font color=lime>"; } echo "$".number_format($gainorloss,2)."</font></td></tr>"; } echo "</table></td><td valign=top>"; echo "<font size=4 color=silver><center><b>Trading Floor</b></center></font> <form action=?x=stockmarket&action=trade method=post> <table width='360' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr bgcolor=#11111> <td> <font face=verdana size=2 color=#FFFFFF><b>Company:</b></font> <td> <select name=company style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\">"; foreach ($stocks_ticker as $tick) { echo "<option value=$tick>$stocks_company[$tick]</option>"; } echo "</select> </td> </tr> <tr bgcolor=#11111> <td> <font face=verdana size=2 color=#FFFFFF><b># of Shares:</b></font> </td> <td> <input type=text name=shares maxlength=15 value=\"$victim\" size=15 style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\"> </td> </tr> <tr bgcolor=#11111> <td> <font face=verdana size=2 color=#FFFFFF><b>Action:</b></font> </td> <td> <select name=type style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\"> <option value=buy>BUY</option> <option value=sell>SELL</option> </select> </td> </tr> <tr> <td align=center colspan=2> <font color=#888888>Broker Fee: $comissiondisplay per trade</font> <br> <input type=submit name=Submit value=\"Complete Trade\"> </td> </tr> </table></form>"; echo "</td></tr></table>"; // BETTER DISPLAY ?> Quote Link to comment Share on other sites More sharing options...
Magictallguy Posted July 5, 2013 Share Posted July 5, 2013 NOTE: Tested for parse errors only <table width='100%'><tr><td valign='left' width='95%'><font size=2 color='silver'><strong>Stock Market</strong></font></td><td><table width=100%><tr><td align=right> <?php include('../beta/files/link.php'); ?>Stock Market. Users can come buy stocks here. Stock values are calculated every 5 minutes and connect to the real stock ticker to give some realism to the feature. So like real stocks users have the chance to gain or lose stock value without random methods.'</td></tr></table><img src='/beta/layout_images/headertop.gif' width=100% height=4 /><?php if(!isset($tools)) { ?><font color=red><strong>Error | It Seems Something Went Wrong Processing Your Account. Please Try Logging Out And Then Logging Back In. If The Problem Persists Please Email Support At [email protected]. We Apologize For The Inconvenience.</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center><?php session_destroy(); exit(); } echo "<font color=red><strong>Error | The Stock Market Is Currently Closed. Sorry For The Inconvenience.</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center>"; exit; //********************************************* // SETTINGS //********************************************* $comission = 0.03; //broker percentage based comission on all trades $comissiondisplay = ($comission * 100) . '%'; //just used to show them how much their paying //********************************************* $company = isset($company) && ctype_digit($company) ? abs(@intval($company)) : null; if((isset($action) && $action == "trade") && !empty($company)) { // kill non numbers preg_match_all("/([0-9]+)/", $shares, $regs); $shares = implode("", $regs[1]); $sql_shares = mysql_query("SELECT `shares`, `total` FROM `stocks_shares` WHERE ((`company` = " . $company . ") AND (`uid` = " . $player->uid . "))") or exit(mysql_error()); $row_shares = mysql_fetch_assoc($sql_shares); $port_total = $row_shares['total']; $port_shares = $row_shares['shares']; $sql = mysql_query("SELECT `price`, `company` FROM `stock_companies` WHERE (`ticker` = " . $company . ")") or exit(mysql_error()); if(!mysql_num_rows($sql)) { echo "There appears to be an issue. Please inform an administrator"; exit; } $row = mysql_fetch_assoc($sql); $price = $row['price']; $name = $row['company']; $trade_value = $price * $shares; $comission_paid = $trade_value * $comission; if($type == "buy") { $paid = $trade_value + $comission_paid; if($shares <= 0) { echo "<font color=red><strong>Error | You did not enter an amount of stock shares to purchase.</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center>"; exit; } if($stats_array['cash'] < $paid) { echo "<font color=red><strong>Error | You need at least $" . number_format($trade_value) . " in cash to complete this trade.</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center>"; exit; } mysql_query("UPDATE `user_characters` SET `cash` = `cash` - " . $paid . " WHERE (`uid` = " . $player->uid . ")") or exit(mysql_error()); $sql = (!mysql_num_rows($sql_shares)) ? "INSERT INTO `stocks_shares` (`uid`, `company`, `shares`, `total`) VALUES (" . $player->uid . "', " . $company . ", " . $shares . ", " . $trade_value . ")" : "UPDATE `stocks_shares` SET `shares` = `shares` + " . $shares . ", `total` = `total` + " . $trade_value . " WHERE ((`uid` = " . $player->uid . ") AND (`company` = " . $company . "))"; mysql_query($sql) or exit(mysql_error()); echo "<font color=green><strong>Ciao | You have purchased ", number_format($shares), " share", (($shares == 1) ? '' : 's'), " of ", stripslashes(htmlentities($name)), " for $", number_format($paid), ". The broker took a ", $commisiondisplay, " fee of $", number_format($comission_paid, 2), ".</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center><meta http-equiv='refresh' content='5;url=driver.php?x=stockmarket'>"; } else if($type == "sell") { $payout = $trade_value - $comission_paid; if($shares <= 0) { echo "<font color=red><strong>Error | You did not enter an amount of stock shares to sell.</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center>"; exit; } if($port_shares < $shares) { echo "<font color=red><strong>Error | You do not have ", number_format($shares), " Share", (($shares == 1) ? '' : 's'), " of ", stripslashes(htmlentities($name)), ".</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center>"; exit; } $sql = ($port_shares == $shares) ? "DELETE FROM `stocks_shares` WHERE ((`uid` = " . $player->uid . ") AND (`company` = " . $company . "))" : "UPDATE `stocks_shares` SET `shares` = `shares` - " . $shares . ", `total` = `total` - " . $trade_value . " WHERE ((`uid` = " . $player->uid . ") AND (`company` = " . $company . "))"; mysql_query($sql) or exit(mysql_error()); } mysql_query("UPDATE `user_characters` SET `cash` = `cash` + " . $payout . " WHERE (`uid` = " . $player->uid . ")") or exit(mysql_error()); echo "<font color=green><strong>Ciao | You have sold ", number_format($shares), " Share", (($shares == 1) ? '' : 's'), " of ", stripslashes(htmlentities($name)), " for $", number_format($payout), ". The broker took a ", $commisiondisplay, " fee of $", number_format($comission_paid, 2), ".</strong></font><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center><meta http-equiv='refresh' CONTENT='5;url=driver.php?x=stockmarket'>"; } ?><table width=100% align='center'><tr valign=top><td align='center' colspan=2> <table width='600' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr> <td bgcolor='#111111' align='center'><font color='silver'><strong>Company</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>Sector</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>Price</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>Change Today</strong></font></td> </tr><?php $color = 1; $sql = mysql_query("SELECT `ticker`, `company`, `industry`, `price`, `change` FROM `stocks_companies` ORDER BY `industry`") or exit(mysql_error()); if(!mysql_num_rows($sql)) { ?><tr><td colspan='4' style='text-align:center;'>There are no companies</td></tr><?php } else { $stocks_company = array(); $stocks_ticker = array(); $stocks_price = array(); while($row = mysql_fetch_assoc($sql)) { $stocks_company[$row['ticker']] = $row['company']; $stocks_ticker[$row['company']] = $row['ticker']; $stocks_price[$row['ticker']] = $row['price']; switch($color) { case 1: $rowcolor = '#111111'; $color = 2; break; case 2: $rowcolor = '#111111'; $color = 1; break; } echo "<tr bgcolor='$rowcolor'> <td align='center'><a href=http://finance.yahoo.com/q?s=" . $row['ticker'] . " target='new'><font color=#FFFFFF><strong>" . $row['company'] . "</strong></></a></td> <td align='center'><font color=#FFFFFF>" . $row['industry'] . "</font></td> <td align='center'><font color=#FFFFFF>$" . $row['price'] . "</td> <td align='center'><span style='color:", (($row['change'] < 0) ? 'red' : 'lime'), ";'>", $row['change'], "</span></td></tr>"; } } ?></table><center><img src='/beta/layout_images/headertop.gif' width='100%' height='4' /></center> </td><tr><td align='center' valign='top'> <font size=4 color='silver'><center><strong>Portfolio</strong></center></font> <table width='80%' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr> <td bgcolor='#111111' align='center'><font color='silver'><strong>COMPANY</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>SHARES</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>VALUE</strong></font></td> <td bgcolor='#111111' align='center'><font color='silver'><strong>GAIN/LOSS</strong></font></td> </tr><?php $sql = mysql_query("SELECT `company`, `shares`, `total` FROM `stocks_shares` WHERE (`uid` = " . $player->uid . ")") or exit(mysql_error()); if(!mysql_num_rows($sql)) { ?><tr><td colspan='4' style='text-align:center;'>You have no stocks</td></tr><?php } else { while($row = mysql_fetch_assoc($sql)) { switch($color) { case 1: $rowcolor = '#111'; $color = 2; break; case 2: $rowcolor = '#000'; $color = 1; break; } $ticker = $row['company']; $value = $row['shares'] * $stocks_price[$ticker]; $gainorloss = $value - $row['total']; echo "<tr bgcolor=$rowcolor> <td align='center'><a href=http://finance.yahoo.com/q?s=", $row['company'], " target=_href><font color=#FFFFFF><strong>", $stocks_company[$ticker], "</strong></font></a></td> <td align='center'><font color=#FFFFFF>", number_format($row['shares']), "</font></td> <td align='center'><font color=#FFFFFF>$", number_format($value, 2), "</font></td> <td align='center'><span style='color:", (($gainorloss < 0) ? 'red' : 'lime'), ";'>$", number_format($gainorloss, 2), "</span></td> </tr>"; } } ?></table></td><td valign=top> <font size=4 color='silver'><center><strong>Trading Floor</strong></center></font> <form action=?x=stockmarket&action=trade method=post> <table width='360' cellpadding='1' cellspacing='3' border='2' bordercolor='black' style='margin:0 auto;background-image: url(/beta/layout_images/bg_2.gif);'> <tr bgcolor='#111111'> <td> <font face=verdana size=2 color=#FFFFFF><strong>Company:</strong></font> <td> <select name=company style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\"><?php foreach($stocks_ticker as $tick) { printf("<option value='%u'>%s</option>", $tick, $stocks_company[$tick]); } ?></select> </td> </tr> <tr bgcolor='#111111'> <td> <font face=verdana size=2 color=#FFFFFF><strong># of Shares:</strong></font> </td> <td> <input type=text name=shares maxlength=15 value=\"$victim\" size=15 style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\"> </td> </tr> <tr bgcolor='#111111'> <td> <font face=verdana size=2 color=#FFFFFF><strong>Action:</strong></font> </td> <td> <select name=type style=\"FONT-WEIGHT: none; FONT-SIZE: 8pt; COLOR: #FFFFFF; FONT-FAMILY: Arial; BACKGROUND-COLOR: #000000; border-color: #FFFFFF\"> <option value=buy>BUY</option> <option value=sell>SELL</option> </select> </td> </tr> <tr> <td align='center' colspan=2> <font color=#888888>Broker Fee: <?php echo $comissiondisplay; ?> per trade</font> <input type=submit name=Submit value=\"Complete Trade\"> </td> </tr> </table></form> </td></tr></table> If you receive any errors, either fix 'em yourself or post here Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.