morgan1122

Doesnt acsept Google payments :(

ok thanks i have started that but im looking to get tought as i do it thats why i would love to help someone then they can teach me stuff like securing and advance php

I am a basic coder and wants to learn a lot more looking to help someone with there game even if its going to be started from scratch and i dont want any of the profits just would be nice if you could teach me a bit as we code :D

ok thanks i will leave this then but all of the older mods im not being able to add my game because of errors i have been trying to edit them so that they work but they still wont work :(

whats the best method of securing it then just the normal security.

Getting this error :( Unknown column 'Time Left' in 'field list'

echo '<tr> <td><a href="houses.php?page=estate&id='.$r['hID'].'" target="_blank">'.stripslashes($r['hNAME']).'</a></td> <td>'.number_format($r['hWILL']).' mood bar</td> <td>$'.number_format($r['hPRICE']).'</td> </tr>'; } line 195 is the first line im getting Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/houses.php on line 196

Thanks everyone i feel stupid now i looked at it for 10 mins and didnt even think of it

Or just add it sglobals.php

<?php include_once('globals.php'); echo '<p class="heading">Your Houses</p>'; switch ($_GET['page']) { case 'move': move_house(); break; case 'move_out': move_out(); break; case 'estate': estate_agent(); break; case 'sell': sell_house(); break; case 'rentals': rental_market(); break; case 'rent': rent_house(); break; case 'upgrade': upgrade_house(); break; default: houses_index(); break; } function houses_index() { global $ir; $houses = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseOwner` = '%u' || `uhouseTenant` = '%u') AND `uhouseId` != '%d'", $ir['userid'], $ir['userid'], $ir['house'])); echo '<table width="600"> <tr> <td width="50%" align="center"><a href="http://houses.php?page=estate" target="_blank">Estate agent</a></td> <td width="50%" align="center"><a href="http://houses.php?page=rentals" target="_blank">Rent a house</a></td> </tr> </table> '; if($ir['house']) { $fetch = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) WHERE (`uhouseId` = '%u')", $ir['house'])); $h = mysql_fetch_assoc($fetch); echo '<b>Current house:</b> <table width="300" class="table"> <tr> <th width="50%">Current house</th> <th width="50%">Move out</th> </tr> <tr> <td>'.stripslashes($h['hNAME']).'</td> <td><a href="http://houses.php?page=move_out" target="_blank">Move out</a></td> </tr> </table> '; } echo '<table width="600" class="table"> <tr> <th width="25%">House name</th> <th width="25%">Owner</th> <th width="25%">Mood value</th> <th width="25%">Manage</th> </tr>'; if(!mysql_num_rows($houses)) { echo '<tr> <td colspan="5">You have no houses at this time, purchase one at the estate agent\'s.</td> </tr>'; } while($r = mysql_fetch_assoc($houses)) { echo '<tr>'; echo '<td>' . stripslashes($r['hNAME']) . '</td>'; echo '<td><a href="http://viewuser.php?u=' . $r['userid'] . '" target="_blank">' . stripslashes($r['username']) . '</a></td>'; echo '<td>' . number_format($r['uhouseMood']) . ' mood bar</td>'; echo '<td><a href="http://houses.php?page=move&id=' . $r['uhouseId'] . '" target="_blank">Move in</a>'; echo '</tr>'; echo '<a href="http://houses.php?page=sell&id='.$r['uhouseId'].'" target="_blank">Sell house</a>'; echo '<a href="http://houses.php?page=rent&id='.$r['uhouseId'].'" target="_blank">Rent house</a>'; echo '<a href="http://houses.php?page=upgrade&id='.$r['uhouseId'].'" target="_blank">Add upgrades</a></td>'; echo '</tr>'; } echo '</table>'; } function move_house() { global $ir; $fetch = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseId` = '%u')", abs((int) $_GET['id']))); if(!isset($_GET['id'])) { echo 'You did not select a house to move in to.'; } else if(!mysql_num_rows($fetch)) { echo 'You cannot move into a non-existant house.'; } else { $r = mysql_fetch_assoc($fetch); if($r['uhouseOwner'] != $ir['userid'] AND $r['uhouseTenant'] != $ir['userid']) { echo 'You are not permitted to move into this house.'; } else if($r['uhouseRTime'] AND $r['uhouseOwner'] == $ir['userid']) { echo 'You cannot move into a house while it is being rented to another member.'; } else { mysql_query(sprintf("UPDATE `users` SET `house` = '%d', `maxwill` = '%d' WHERE (`userid` = '%u')", abs((int) $_GET['id']), $r['uhouseMood'], $ir['userid'])); echo 'You have moved into the '.stripslashes($r['hNAME']).', You now have a maximum mood bar of '.number_format($r['uhouseMood']).'.'; } } } function move_out() { global $ir; $fetch = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseId` = '%u')", $ir['house'])); if(!mysql_num_rows($fetch)) { echo 'You cannot move out of a non-existant house.'; } else { $r = mysql_fetch_assoc($fetch); if($r['uhouseOwner'] != $ir['userid'] AND $r['uhouseTenant'] != $ir['userid']) { echo 'You are not permitted to move out of this house.'; } else { mysql_query(sprintf("UPDATE `users` SET `house` = '0', `maxwill` = '100' WHERE (`userid` = '%u')", $ir['userid'])); echo 'You have moved out of the '.stripslashes($r['hNAME']).', You now have a maximum mood bar of 100.'; } } } function sell_house() { global $ir; $fetch = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseOwner` = '%u') AND (`uhouseId` = '%u')", $ir['userid'], abs((int) $_GET['id']))); if(!isset($_GET['id'])) { echo 'You did not select a house to sell.'; } else if(!mysql_num_rows($fetch)) { echo 'You cannot attempt to sell a non-existant house.'; } else { $r = mysql_fetch_assoc($fetch); if($r['uhouseOwner'] != $ir['userid']) { echo 'You do not own this house, so don\'t attempt to sell it.'; } else if($r['uhouseTenant']) { echo 'You cannot sell a house while it is being rented to another member.'; } else { mysql_query(sprintf("UPDATE `users` SET `money` = `money` + '%d' WHERE (`userid` = '%u')", $r['houseCost'], $ir['userid'])); mysql_query(sprintf("DELETE FROM `owned_houses` WHERE (`uhouseId` = '%u')", abs((int) $_GET['id']))); echo 'You have sold the '.stripslashes($r['hNAME']).' for a total of $'.number_format($r['hPRICE']).'.'; } } } function estate_agent() { global $ir; if(isset($_GET['id'])) { $house = mysql_query(sprintf("SELECT * FROM `houses` WHERE (`hID` = '%u')", abs((int) $_GET['id']))); $r = mysql_fetch_assoc($house); if(!mysql_num_rows($house)) { echo 'You cannot attempt to purchase a non-existant house.'; } else if($ir['money'] < $r['hPRICE']) { echo 'You cannot afford to purchase this house right now, come back another time.'; } else { mysql_query(sprintf("UPDATE `users` SET `money` = `money` - '%d' WHERE (`userid` = '%u')", $r['hPRICE'], $ir['userid'])); mysql_query(sprintf("INSERT INTO `owned_houses` (`uhouseId`, `uhouseOwner`, `uhouseHouse`, `uhouseMood`) VALUES ('NULL','%u', '%d', '%d')", $ir['userid'], $r['hID'], $r['hWILL'])); echo 'You have purchased the '.stripslashes($r['hNAME']).' for a total of $'.number_format($r['houseCost']).'!'; } } else { $houses = mysql_query(sprintf("SELECT * FROM `houses` ORDER BY `hWILL` ASC")); echo '<table width="600" class="table"> <tr> <th>House name</th> <th>Mood value</th> <th>Cost</th> </tr>'; while($r = mysql_fetch_assoc($houses)) { echo '<tr> <td><a href="http://houses.php?page=estate&id='.$r['hID'].'" target="_blank">'.stripslashes($r['hNAME']).'</a></td> <td>'.number_format($r['hWILL']).' mood bar</td> <td>$'.number_format($r['hPRICE']).'</td> </tr>'; } print '</table>'; } } function rental_market() { global $ir; if(isset($_GET['id'])) { $house = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseId` = '%u')", abs((int) $_GET['id']))); $r = mysql_fetch_assoc($house); if(!mysql_num_rows($house)) { echo 'You cannot rent a house that does not exist.'; } else if($r['uhouseOwner'] == $ir['userid']) { echo 'You own this house at this time, You cannot rent it aswell.'; } else { mysql_query(sprintf("UPDATE `owned_houses` SET `uhouseTenant` = '%d' WHERE (`uhouseId` = '%u')", $ir['userid'], abs((int) $_GET['id']))); echo 'You are now renting the '.stripslashes($r['hNAME']).' for a total of $'.number_format($r['uhouseRent']).' each night!'; } } else { $houses = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE `uhouseTenant` = '0' AND `uhouseRent` > '0' ORDER BY `uhouseRent` ASC")); echo '<table width="600" class="table"> <tr> <th>House name</th> <th>Owner</th> <th>Mood value</th> <th>Cost each night</th> <th>Rental time</th> <th>Manage</th> </tr>'; while($r = mysql_fetch_assoc($houses)) { echo '<tr> <td>'.stripslashes($r['hNAME']).'</td> <td><a href="http://userprofile.php?id='.$r['userid'].'" target="_blank">'.stripslashes($r['username']).'</a></td> <td>'.number_format($r['uhouseMood']).' mood bar</td> <td>$'.number_format($r['uhouseRent']).'</td> <td>'.number_format($r['uhouseRTime']).' nights</td> <td><a href="http://houses.php?page=rentals&id='.$r['uhouseId'].'" target="_blank">Rent house</a></td> </tr>'; } print '</table>'; } } function rent_house() { global $ir; $fetch = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseOwner` = '%u') AND (`uhouseId` = '%u')", $ir['userid'], abs((int) $_GET['id']))); if(!isset($_GET['id'])) { echo 'You did not select a house to rent out to members.'; } else if(!mysql_num_rows($fetch)) { echo 'You cannot attempt to rent out a non-existant house.'; } else { $r = mysql_fetch_assoc($fetch); if($r['uhouseOwner'] != $ir['userid']) { echo 'You do not own this house, so don\'t attempt to rent it out to people.'; } else if($r['uhouseTenant']) { echo 'You cannot rent out a house while it is being rented to another member.'; } else { if(isset($_POST['time']) AND isset($_POST['cost'])) { mysql_query(sprintf("UPDATE `owned_houses` SET `uhouseRent` = '%d', `uhouseRTime` = '%d' WHERE (`uhouseId` = '%u')", abs((int) $_POST['cost']), abs((int) $_POST['time']), abs((int) $_GET['id']))); echo 'You have added the '.stripslashes($r['hNAME']).' the the rental market at a cost of $'.number_format($_POST['cost']).' per night.'; } else { echo '<form action="houses.php?page=rent&id='.$_GET['id'].'" method="post"> <table width="600"> <tr> <td><b>Amount of nights:</b></td> <td><input type="text" name="time" value="30" /></td> </tr> <tr> <td><b>Cost per nights:</b></td> <td><input type="text" name="cost" value="250" /></td> </tr> <tr> <td colspan="2" align="center"><input type="submit" value="Submit rental" /></td> </tr> </table> </form>'; } } } } function upgrade_house() { global $ir; if(!isset($_POST['id'])) { if(isset($_GET['id'])) { echo '<form action="houses.php?page=upgrade&id='.$_GET['id'].'" method="post" name="upgrades"> <table class="table" width="600"> <tr> <th width="45%">Upgrade name</th> <th width="25%">Mood gain</th> <th width="25%">Cost</th> <th width="5%"></th> </tr>'; $fetch = mysql_query("SELECT * FROM `house_upgrades` ORDER BY `upgradeMood` ASC"); while ($r = mysql_fetch_assoc($fetch)) { echo '<tr> <td>'.stripslashes($r['upgradeName']).'</td> <td>'.number_format($r['upgradeMood']).' mood</td> <td>$'.number_format($r['upgradeCost']).'</td> <td><input type="radio" name="id" value="'.$r['upgradeId'].'" onClick="document.upgrades.submit();" /></td> </tr>'; } echo '</table>'; } else { echo 'You did not select a house to add upgrades to.'; } } else { $upgrade = mysql_query(sprintf("SELECT * FROM `house_upgrades` WHERE `upgradeId` = '%u'", abs((int) $_POST['id']))); if(!mysql_num_rows($upgrade)) { echo 'This upgrade does not exist at this time, if this problem continues report it to staff.'; } else if(!isset($_GET['id'])) { echo 'You did not select a house to add upgrades to.'; } else { $house = mysql_query(sprintf("SELECT * FROM `owned_houses` LEFT JOIN `houses` ON (`hID` = `uhouseHouse`) LEFT JOIN `users` ON (`userid` = `uhouseOwner`) WHERE (`uhouseId` = '%u')", abs((int) $_GET['id']))); $h = mysql_fetch_assoc($house); $r = mysql_fetch_array($upgrade); if(!mysql_num_rows($house)) { echo 'You cannot add upgrades to a non-existant house.'; } else if($h['uhouseOwner'] != $ir['userid']) { echo 'You are not permitted to add upgrades to this house.'; } else if($ir['money'] < $r['upgradeCost']) { echo 'You do not have enough cash to purchase this upgrade right now.'; } else { $check = mysql_query(sprintf("SELECT * FROM `owned_upgrades` WHERE (`ownupHouse` = '%u') AND (`ownupUpgrade` = '%d')", abs((int) $_GET['id']), abs((int) $_POST['id']))); if(mysql_num_rows($check)) { echo 'This house has this upgrade at this time, it cannot be bought again.'; } else { mysql_query(sprintf("UPDATE `users` SET `money` = `money` - '%d' WHERE `userid` = '%u'", $r['upgradeCost'], $ir['userid'])); mysql_query(sprintf("UPDATE `owned_houses` SET `uhouseMood` = `uhouseMood` + '%d' WHERE `uhouseId` = '%u'", $r['upgradeMood'], abs((int) $_GET['id']))); mysql_query(sprintf("INSERT INTO `owned_upgrades` (`ownupId`, `ownupHouse`, `ownupUpgrade`) VALUES ('NULL','%u', '%d')", abs((int) $_GET['id']), abs((int) $_POST['id']))); echo 'You have purchased the '.stripslashes($r['upgradeName']).' for $'.number_format($r['upgradeCost']).'.'; } } } } } $h->endpage(); ?>   Got error Parse error: syntax error, unexpected '<' in /home/morgan95/public_html/houses.php on line 74 The below is showing up in gray so there is somthing wrong with this but what?? http://houses.php?page=rent&id='.$r['uhouseId'].'" target="_blank">Rent house</a>';

Done now danny :)

Thanks dom its loading now but a bit of an error to my template on on that page it dont show the template heres the script <?php include_once('globals.php'); print "<h2>Stock Market</h2>"; $arrs = array('buy','log','sell','view'); $x = (isset($_GET['trip']) && ctype_alnum($_GET['trip']) && in_array($_GET['trip'], $arrs)) ? trim($_GET['trip']) : FALSE; # False making it not exist making it default page. switch($x) { case 'buy': buy_stock(); break; case 'sell': sell_stock(); break; case 'view': view_stock(); break; case 'log': view_stock_log(); break; default: stock_default(); break; } function view_stock_log() { global $db,$ir; $log = $db->query("SELECT recordTIME,recordTEXT FROM `stock_records` WHERE `recordUSER` = ".$ir['userid']." ORDER BY `recordTIME` DESC"); if($db->num_rows($log) == 0) { echo 'You do not have any log records.'; } else { while($soc = $db->fetch_row($log)) { $time = date('F jS Y g:i:s', $soc['recordTIME']); echo '<b>'.$time.'</b> '.str_replace('me', 'You', $soc['recordTEXT']).' '; } } } function sell_stock() { global $ir,$db; $id=abs((int) $_GET['ID']); $holding = $db->query("SELECT holdingID,holdingSTOCK,holdingQTY FROM `stock_holdings` WHERE `holdingID` = ".$id." AND `holdingUSER` = ".$ir['userid']); if($db->num_rows($holding) == 0) { echo 'This holding ID does not exist, or you do not own it.'; return; } else { $soc = $db->fetch_row($holding); $stock = $db->query("SELECT stockNAME,stockNPRICE FROM `stock_stocks` WHERE `stockID` = ".$soc['holdingSTOCK']); $stock = $db->fetch_row($stock); $tot = ($stock['stockNPRICE'] * $soc['holdingQTY']); $db->query("DELETE FROM `stock_holdings` WHERE `holdingID` = ".$soc['holdingID']); $db->query("INSERT INTO `stock_records` (`recordUSER`,`recordTIME`,`recordTEXT`) VALUES (".$ir['userid'].",unix_timestamp(),'me sold ".$soc['holdingQTY']." of stock ".$stock['stockNAME']." for ".money_formatter($tot)."')"); $db->query("UPDATE `users` SET `money` = (`money` + ".$tot.") WHERE `userid` = ".$ir['userid']); echo 'You sold '.number_format($soc['holdingQTY']).' stock of '.$stock['stockNAME'].' for '.money_formatter($tot).'!'; } } function view_stock() { global $ir,$db; $holdings = $db->query("SELECT holdingID,holdingSTOCK,holdingQTY FROM `stock_holdings` WHERE `holdingUSER` = ".$ir['userid']); if($db->num_rows($holdings) == 0) { echo 'You do not hold any shares in any stocks atm.'; } else { echo ' <table border="0" cellspacing="0" cellpadding="0" class="stocks" width="50%"> <tr> <th>Stock Name</th> <th>Shares</th> <th>Sell Price</th> <th>Sell</th> </tr>'; while($soc = $db->fetch_row($holdings)) { $stock = $db->query("SELECT stockNAME,stockNPRICE FROM `stock_stocks` WHERE `stockID` = ".$soc['holdingSTOCK']); $stock = $db->fetch_row($stock); echo ' <tr> <td>'.$stock['stockNAME'].'</td> <td>'.number_format($soc['holdingQTY']).'</td> <td>'.money_formatter($stock['stockNPRICE'] * $soc['holdingQTY']).'</td> <td><a href="?trip=sell&ID='.$soc['holdingID'].'" target="_blank">Sell Stock</a></td> </tr>'; } echo ' </table>'; } } function buy_stock() { global $ir,$db; $id=abs((int) $_GET['ID']); $rows = $db->query("SELECT stockID FROM `stock_stocks` WHERE `stockID` = ".$id); if($db->num_rows($rows) == 0) { echo 'This stock does not exist.'; return; } if(isset($_POST['buy'])) { $amnt = abs((int) $_POST['amnt']); $fetch_stock = $db->query("SELECT stockID,stockNPRICE,stockNAME FROM `stock_stocks` WHERE `stockID` = ".$id); $stock = $db->fetch_row($fetch_stock); $mprice = ($stock['stockNPRICE'] * $amnt); if($ir['money'] <= $mprice) { echo 'You do not have enough money for this amount of stocks.'; return; } $stock_holds = $db->query("SELECT holdingID FROM `stock_holdings` WHERE `holdingUSER` = ".$ir['userid']." AND `holdingSTOCK` = ".$stock['stockID']); if($db->num_rows($stock_holds)) { $db->query("UPDATE `stock_holdings` SET `holdingQTY` = (`holdingQTY` + ".$amnt.") WHERE `holdingUSER` = ".$ir['userid']." AND `holdingSTOCK` = ".$stock['stockID']); } else { $db->query("INSERT INTO `stock_holdings` (`holdingUSER`,`holdingSTOCK`,`holdingQTY`) VALUES (".$ir['userid'].",".$stock['stockID'].",".$amnt.")"); } $db->query("UPDATE `users` SET `money` = (`money` - ".$mprice.") WHERE `userid` = ".$ir['userid']); $db->query("INSERT INTO `stock_records` (`recordUSER`,`recordTIME`,`recordTEXT`) VALUES (".$ir['userid'].",unix_timestamp(),'me bought ".$amnt." of stock ".$stock['stockNAME']." for ".money_formatter($mprice)."')"); echo 'You successfuly bought '.number_format($amnt).' stocks of '.$stock['stockNAME'].'.'; } else { $stock = $db->query("SELECT stockID,stockNAME,stockCHANGE,stockNPRICE,stockUD, stockOPRICE FROM `stock_stocks` WHERE `stockID` = ".$id); $stock = $db->fetch_row($stock); $symb = ($stock['stockUD'] == 1) ? '<big>?</big>' : '<big>?</big>'; $class = ($stock['stockUD'] == 1) ? 'green' : 'red'; $blip = ($stock['stockUD'] == 1) ? '+' : '-'; $clor = ($stock['stockOPRICE'] < $soc['stockNPRICE']) ? 'green' : 'red'; echo ' <table border="0" cellspacing="0" width="50%"> <tr> <td>Stock Name</td> <td>'.$stock['stockNAME'].'</td> </tr> <tr> <td>Price Change</td> <td><span class="'.$class.'">'.$blip.' '.money_formatter($stock['stockCHANGE']).' '.$symb.'</span></td> </tr> <tr> <td>Original Price</td> <td>'.money_formatter($stock['stockOPRICE']).'</td> </tr> <tr> <td>Now Price</td> <td>'.money_formatter($stock['stockNPRICE']).'</td> </tr> <tr> <td>Buy Stock</td> <td> <form action="?trip=buy&ID='.$id.'" method="post"> QTY: <input type="text" name="amnt" value="0" /> <input type="submit" value="Buy" name="buy" /> </form> </td> </tr> </table>'; } } function stock_default() { global $ir,$db; echo ' Here is a list of stocks available along with their price and such. -> <a href="?trip=view" target="_blank">View your stocks</a> -> <a href="?trip=log" target="_blank">View your log</a> <table border="0" cellspacing="0" cellpadding="0" class="stock" width="70%"> <tr> <th>Stock Name</th> <th>Stock Orig Price</th> <th>Stock Now Price</th> <th>Price Change</th> <th>View</th> </tr>'; $stocks = $db->query("SELECT stockID,stockNAME,stockOPRICE,stockNPRICE,stockCHANGE,stockUD FROM `stock_stocks`"); if($db->num_rows($stocks) == 0) { echo ' <tr> <td align="center" colspan="5">No stocks available</td> </tr> </table>'; return; } while($soc = $db->fetch_row($stocks)) { $symb = ($soc['stockUD'] == 1) ? '?' : '?'; $class = ($soc['stockUD'] == 1) ? 'green' : 'red'; $blip = ($soc['stockUD'] == 1) ? '+' : '-'; $clor = ($soc['stockOPRICE'] < $soc['stockNPRICE']) ? 'green' : 'red'; $blic = ($soc['stockOPRICE'] < $soc['stockNPRICE']) ? '+' : '-'; echo ' <tr> <td>'.$soc['stockNAME'].'</td> <td>'.money_formatter($soc['stockOPRICE']).'</td> <td><span class="'.$clor.'">'.$blic.' '.money_formatter($soc['stockNPRICE']).'</span></td> <td><span class="'.$class.'">'.$blip.' '.money_formatter($soc['stockCHANGE']).' '.$symb.'</span></td> <td><a href="?trip=buy&ID='.$soc['stockID'].'" target="_blank">Buy Or View</a></td> </tr>'; } echo ' </table>'; } ?>

Still got Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/houses.php on line 64 sorry

oh sorry the updated one now the error is Parse error: syntax error, unexpected '}' in /home/morgan95/public_html/stocks.php on line 115 echo 'You do not have enough money for this amount of stocks.'; return; } 111 $stock_holds = $db->query("SELECT holdingID FROM `stock_holdings` WHERE `holdingUSER` = ".$ir['userid']." AND `holdingSTOCK` = ".$stock['stockID']); 112 if($db->num_rows($stock_holds)) { 113 $db->query("UPDATE `stock_holdings` SET `holdingQTY` = (`holdingQTY` + ".$amnt.") WHERE `holdingUSER` = ".$ir['userid']." AND `holdingSTOCK` = 114".$stock['stockID']) 115 } 116 else { $db->query("INSERT INTO `stock_holdings` (`holdingUSER`,`holdingSTOCK`,`holdingQTY`) VALUES (".$ir['userid'].",".$stock['stockID'].",".$amnt.")"); }

Sorry i dont know what to change it too im rubbish at coding and trying to learn it

yes dom :(

I tryed that :/

echo '<tr> <td>'.stripslashes($r['hNAME']).'</td> <td><a href="http://viewuser.php?u='.$r['userid'].'" target="_blank">'.stripslashes($r['username']).'</a></td> <td>'.number_format($r['uhouseMood']).' mood bar</td> <td><a href="http://houses.php?page=move&id='.$r['uhouseId'].'" target="_blank">Move in</a> Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/houses.php on line 64 sorry but i still cant work it out :(

Thanks dom

sorry i got an error im rubbish at coding so sorry if its just basic   Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/stocks.php on line 109

Im a rubbish coder and im getting this error i have had a look at it but why is there " in a print i thought they had to be ' sorry to be a newsence Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/houses.php on line 64

Im looking for a partnership with some that has experiance in games creating crimes jobs ect and can do some basic coding Message me on [email protected] My games: Under Construction and only just started work on it.

Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/morgan95/public_html/houses.php on line 64

Thats my template you have reason to even use it let alone sell it.

what would the sql be to make the database??