...

View Full Version : Stock Script



Philey
03-15-2009, 09:52 PM
can someone help me the stock wont update the price and shows no new or no oldprice


<?
session_start();
include_once "includes/db_connect.php";
include_once "includes/functions.php";

$fetch=mysql_fetch_object(mysql_query("SELECT * FROM users WHERE username='$username'"));


$stats12 = mysql_fetch_object(mysql_query("SELECT * FROM site_stats WHERE id='1'"));

$stockam = explode("-", $fetch->stock);
$prices=explode("-", $stats12->newstockp);
$prices1=explode("-", $stats12->oldstockp);
if ($stats12->stime <= time()){
$newtime1 = time() + 600;
$a1 = $prices[0] + rand(-10,15);
$a2 = $prices[1] + rand(-10,15);
$a3 = $prices[2] + rand(-10,15);
$a4 = $prices[3] + rand(-10,15);
$a5 = $prices[4] + rand(-10,15);

$newpricess1="$a1-$a2-$a3-$a4-$a5";

mysql_query("UPDATE site_stats SET oldstockp='$stats12->newstockp' WHERE id='1'");
mysql_query("UPDATE site_stats SET newstockp='$newpricess1' WHERE id='1'");
mysql_query("UPDATE site_stats SET stime='$newtime1' WHERE id='1'");
}
/////////diffrent ranks can hold diffrent stocks
if ($fetch->rank == "Tramp"){
$maxstocks = "7";
}
if ($fetch->rank == "thief"){
$maxstocks = "12";
}
if ($fetch->rank == "hooligan"){
$maxstocks = "22";
}
if ($fetch->rank == "criminal"){
$maxstocks = "35";
}
if ($fetch->rank == "gangster"){
$maxstocks = "40";
}
if ($fetch->rank == "boss"){
$maxstocks = "50";
}
if ($fetch->rank == "supreme boss"){
$maxstocks = "65";
}
if ($fetch->rank == "don"){
$maxstocks = "70";
}
if ($fetch->rank == "legendry don"){
$maxstocks = "90";
}
if ($fetch->rank == "Moderator"){
$maxstocks = "2000";
}
if ($fetch->rank == "Head Moderator"){
$maxstocks = "2000";
}
if ($fetch->rank == "Admin"){
$maxstocks = "1000000000";
}




if ($_POST['doit']){
$doit = $_POST['doit'];
if ($doit == 'buy'){
/////////ny trains
if ($_POST['nytl']){
$stocka = (strip_tags($_POST['nytl']));
$totala=$stocka*$prices[0];
}else{
$stocka=0;
}

/////////ny trains
if ($_POST['tnyt']){
$stockb = (strip_tags($_POST['tnyt']));
$totalb=$stockb*$prices[1];
}else{
$stockb=0;
}

/////////ny trains
if ($_POST['qits']){
$stockc = (strip_tags($_POST['qits']));
$totalc=$stockc*$prices[2];
}else{
$stockc=0;
}

/////////ny trains
if ($_POST['abco']){
$stockd=(strip_tags($_POST['abco']));
$totald=$stockd*$prices[3];
}else{
$stockd=0;
}

/////////bronx consultancy
if ($_POST['brcg']){
$stocke=(strip_tags($_POST['brcg']));
$totale=$stocke*$prices[4];
}else{
$stocke=0;
}
///////////////////
if(ereg("[^[:digit:]]", $stocka)){
echo "
Bad amount!!</font>";
}elseif (!ereg("[^[:digit:]]", $stocka)){
///////////////////
if(ereg("[^[:digit:]]", $stockb)){
echo "
Bad amount!!</font>";
}elseif (!ereg("[^[:digit:]]", $stockb)){
///////////////////
if(ereg("[^[:digit:]]", $stockc)){
echo "
Bad amount!!</font>";
}elseif (!ereg("[^[:digit:]]", $stockc)){
///////////////////
if(ereg("[^[:digit:]]", $stockd)){
echo "
Bad amount!!</font>";
}elseif (!ereg("[^[:digit:]]", $stockd)){
///////////////////
if(ereg("[^[:digit:]]", $stocke)){
echo "
Bad amount!!</font>";
}elseif (!ereg("[^[:digit:]]", $stocke)){
///////////////////

if ($stockam[0] != 0){
$stocka = $stocka + $stockam[0];
}
if ($stockam[1] != 0){
$stockb = $stockb + $stockam[1];
}
if ($stockam[2] != 0){
$stockc = $stockc + $stockam[2];
}
if ($stockam[3] != 0){
$stockd = $stockd + $stockam[3];
}
if ($stockam[4] != 0){
$stocke = $stocke + $stockam[4];
}
$total = $stocka+$stockb+$stockc+$stockd+$stocke;

if ($total > $maxstocks){
echo "You can only have $maxstocks stocks</font>";
}elseif ($total <= $maxstocks){
$totalprice = $totala + $totalb + $totalc + $totald + $totale;
if ($totalprice > $fetch->money){
echo "You cant afford that.";
}elseif ($totalprice <= $fetch->money){
$newstocks = "$stocka-$stockb-$stockc-$stockd-$stocke";
$new_money=$fetch->money-$totalprice;
mysql_query("UPDATE users SET money=$new_money WHERE username='$username'");
mysql_query("UPDATE users SET stock='$newstocks' WHERE username='$username'");
echo "Successful transaction.";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=stocks.php\">";

}}}}}}}}}
/////////////sell stocks
if ($_POST['doit']){
$doit = $_POST['doit'];
if ($doit == 'sell'){
if ($_POST['nytl']){
$sell1 = intval(strip_tags($_POST['nytl']));
$totals1 = $sell1* $prices[0];
}else{
$sell1 = 0;
}
if ($_POST['tnyt']){
$sell2 = intval(strip_tags($_POST['tnyt']));
$totals2 = $sell2* $prices[1];
}else{
$sell2 = 0;
}
if ($_POST['qits']){
$sell3 = intval(strip_tags($_POST['qits']));
$totals3 = $sell3* $prices[2];
}else{
$sell3 = 0;
}
if ($_POST['abco']){
$sell4 = intval(strip_tags($_POST['abco']));
$totals4 = $sell4* $prices[3];
}else{
$sell4 = 0;
}
if ($_POST['brcg']){
$sell5 = intval(strip_tags($_POST['brcg']));
$totals5 = $sell5* $prices[4];
}else{
$sell5 = 0;
}
////////////check for invalid digits
if(ereg("[^[:digit:]]", $sell1)){
echo "
<font color=red>Bad ammount!!</font>";
}elseif (!ereg("[^[:digit:]]", $sell1)){
//////////////////////////
if(ereg("[^[:digit:]]", $sell1)){
echo "
<font color=red>Bad ammount!!</font>";
}elseif (!ereg("[^[:digit:]]", $sell2)){
////////////////////////////
if(ereg("[^[:digit:]]", $sell3)){
echo "
<font color=red>Bad ammount!!</font>";
}elseif (!ereg("[^[:digit:]]", $sell3)){
///////////////////////
if(ereg("[^[:digit:]]", $sell4)){
echo "
<font color=red>Bad ammount!!</font>";
}elseif (!ereg("[^[:digit:]]", $sell4)){
////////////////
if(ereg("[^[:digit:]]", $sell5)){
echo "
<font color=red>Bad ammount!!</font>";
}elseif (!ereg("[^[:digit:]]", $sell5)){
////////// check to see if they have that many stocks
if($sell1 > $stockam[0]){
echo "You dont have that many!";
}elseif ($sell1 <= $stockam[0]){
if($sell2 > $stockam[1]){
echo "You dont have that many!";
}elseif ($sell2 <= $stockam[1]){
if($sell3 > $stockam[2]){
echo "You dont have that many!";
}elseif ($sell3 <= $stockam[2]){
if($sell4 > $stockam[3]){
echo "You dont have that many!";
}elseif ($sell4 <= $stockam[3]){
if($sell5 > $stockam[4]){
echo "You dont have that many!";
}elseif ($sell5 <= $stockam[4]){
///////////work out new values of each stock
if ($stockam[0] != 0){
$sell1 =$stockam[0] - $sell1;
}
if ($stockam[1] != 0){
$sell2 =$stockam[1] - $sell2;
}

if ($stockam[2] != 0){
$sell3 =$stockam[2] - $sell3;
}
if ($stockam[3] != 0){
$sell4 =$stockam[3] - $sell4;
}
if ($stockam[4] != 0){
$sell5 =$stockam[4] - $sell5;
}
////////// workout values if you sell all stocks
if ($sell1 == ""){
$sell1 = 0;
}
if ($sell2 == ""){
$sell2 = 0;
}
if ($sell3 == ""){
$sell3 = 0;
}
if ($sell4 == ""){
$sell4 = 0;
}
if ($sell5 == ""){
$sell5 = 0;
}
//////////////work out money and new stocks and insert it into db
$new_stocks1 = "$sell1-$sell2-$sell3-$sell4-$sell5";
$setmemycash = $totals1 + $totals2 + $totals3 + $totals4 + $totals5;
$new_money_1 = $fetch->money + $setmemycash;
mysql_query("UPDATE users SET money='$new_money_1', stock='$new_stocks1' WHERE username='$username'");
echo "Successful transaction.";
echo "<meta http-equiv=\"refresh\" content=\"0;URL=stocks.php\">";
}}}}}}}}}}}}

?>
<link rel="stylesheet" href="file:///C|/Documents%20and%20Settings/J/My%20Documents/My%20Received%20Files/main.css" type="text/css">
<link href="/includes/in.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {color: #CCCCCC}
-->
</style>
<center>
<span class="style1"> You can hold <? echo "$maxstocks"; ?> stocks
</span>
<form action='' method='post'>
<table width="61%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="000000" class="thinline">
<tr>
<td class="header" colspan=7><div align="center">Stock Market </div></td>
</tr> </tr>
<tr bgcolor=#666666>
<td width="29%" colspan=6 class=tip><div align="center">The prices will change in <? echo "".maketime($stats12->stime).""; ?></div></td>
</tr>
<tr bgcolor=#666666>
<td width="29%" class=tip><div align="center">Company</div></td>
<td width="10%" class=tip><div align="center">Symbol</div></td>
<td width="10%" class=tip><div align="center">Price </div></td>

<td width="10%" class=tip><div align="center">Old Price </div></td>
<td width="11%" class=tip><div align="center"># Owned </div></td>
<td width="15%" class=tip><div align="center">Buy/Sell</div></td>
<tr>
<td><strong>Coca-Cola</strong></td>
<td>CC</td>
<td><strong><? echo "$".makecomma($prices[0]).""; ?></strong></td>

<td><? echo "$".makecomma($prices1[0]).""; ?></td>
<td><? echo "$stockam[0]"; ?></td>
<td><input name="nytl" type="text" class="submit" size="8" maxlength="4"></td>
</tr>
<tr>
<td><strong>Samsung</strong></td>
<td>Sa</td>
<td><strong><? echo "$".makecomma($prices[1]).""; ?></strong></td>

<td><? echo "$".makecomma($prices1[1]).""; ?></td>
<td><? echo "$stockam[1]"; ?></td>
<td><input name="tnyt" type="text" class="submit" size="8" maxlength="4"></td>
</tr>
<tr>
<td><strong>British airways </strong></td>
<td>BA</td>
<td><strong><? echo "$".makecomma($prices[2]).""; ?></strong></td>

<td><? echo "$".makecomma($prices1[3]).""; ?></td>
<td><? echo "$stockam[2]"; ?></td>
<td><input name="qits" type="text" class="submit" size="8" maxlength="4"></td>
</tr>
<tr>
<td><strong>Sony</strong></td>
<td>So</td>
<td><strong><? echo "$".makecomma($prices[3]).""; ?></strong></td>

<td><? echo "$".makecomma($prices1[3]).""; ?></td>
<td><? echo "$stockam[3]"; ?></td>
<td><input name="abco" type="text" class="submit" size="8" maxlength="4"></td>
</tr>
<tr>
<td><strong>Tesco</strong></td>
<td>Te</td>
<td><strong><? echo "$".makecomma($prices[4]).""; ?></strong></td>

<td><? echo "$".makecomma($prices1[4]).""; ?></td>
<td><? echo "$stockam[4]"; ?></td>
<td><input name="brcg" type="text" class="submit" size="8" maxlength="4"></td>
</tr>

<tr>
<td>&nbsp;</td>
<td><input type="radio" name="doit" value="buy" checked="checked"/>
Buy</td>
<td><input type="radio" name="doit" value="sell"/>
Sell</td>

<td>&nbsp;</td>
<td>Total: <? $total3456=$stockam[0]+$stockam[1]+$stockam[2]+$stockam[3]+$stockam[4]; echo "$total3456"; ?></td>
<td>
<input name="Submit" type="submit" class="submit" value="Submit"/> </td>
</tr>
</table>
</form>

<div align="center">
<p>The Stock Market may crash at anytime </p>
<p><a href="stocks.php">Refresh</a><br>
</p>
</div>
<?php include_once"includes/footer.php"; ?>


please help maybe someone know how this works correctly

student101
03-16-2009, 01:41 PM
I have no clue where this script came from, maybe the short open tag isn't enabled? Change <? to <?php
If that isn't it, Do the select statements work on their own?

Cheers



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum