corruptcity || skalman

its ok problem sovled id made a cock up with the query this might aswell be deleted now

yeah i have

hi ive got a wierd problem with this function but the problem did happen straigt after i coded it it wasnt til after i added a few more function to the whole script that it started giving me this problem and the problem is that it shows double the records from the db i.e if you had 2 records in the table t would show 4 when you run the code and 2 would have the same ID as would the other 2 ive gone thru it and i cant seem to find anythink wrong with it but here it is

what i would do with if($ir['donatordays'] < 1) { die('This is for donators only!'); } change it to this if($ir['donatordays'] < 1) { echo"This is for donators only!"; $h->endpage(); exit; } that way it ends the header and stops the rest of the code

if you add me on msn ill help u out its [email protected] or if not post your code up here

kk if not you can add me on msn if you want and ill see what i can do

if this is in the header what you need todo is in the userdata function look for the print<<< OUT that is under the $bgcolor and change that to echo" then look for the and under that there should be a OUT; and change that to "; i had todo the same when need to add if statements in there

Look for where its says SQL in the top menu bar its should be between structure and search click SQL then copy the sql in to text area then click go and your dont or if the sql is in a text file you can inport it in by clicking inporting

yeah once youve bought it you can do whatever you want todo to it and its the same with same v2

MTG has made a few gud ones aswell

hey i found this surfing the web today and i think its proper hilar its a clip from a british tv program that mitchell and webb look the clips called a prayer and a mint enjoy http://www.youtube.com/watch?v=h6nrj7A-E1s

lolrus josh

i was just on the tinternet and found this old school vid

lol wud b more funny if she had a hockey mask and like a knife or chainsaw or shout boo as they walk thru

lol no he means like this <?php include "globals.php"; $_GET['shop'] = abs((int) $_GET['shop']); if(!$_GET['shop']) { print "You begin looking through town and you see a few shops. "; $q=$db->query("SELECT * FROM shops WHERE shopLOCATION={$ir['location']}"); print "<table width=85% cellspacing=1 class='table'><tr style='background: gray;'><th>Shop</th><th>Description</th></tr>"; while($r=$db->fetch_row($q)) { print "<tr><td>[url='shops.php?shop={$r[']{$r['shopNAME']}[/url]</td><td>{$r['shopDESCRIPTION']}</td></tr>"; } print "</table>"; } else { $sd=$db->query("SELECT * FROM shops WHERE shopID={$_GET['shop']}"); if($db->num_rows($sd)) { $shopdata=$db->fetch_row($sd); if($shopdata['shopLOCATION'] == $ir['location']) { print "Browsing items at [b]{$shopdata['shopNAME']}...[/b] <table cellspacing=1 class='table'><tr style='background: gray;'><th>Item</th><th>Description</th><th>Price</th><th>Sell Price</th><th>Buy</th><th>Buy with Credit Card</th></tr>"; $qtwo=$db->query("SELECT si.*,i.*,it.* FROM shopitems si LEFT JOIN items i ON si.sitemITEMID=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE si.sitemSHOP={$_GET['shop']} ORDER BY i.itmtype ASC, i.itmbuyprice ASC, i.itmname ASC"); $lt=""; while($r=$db->fetch_row($qtwo)) { if($lt!=$r['itmtypename']) { $lt=$r['itmtypename']; print "\n<tr style='background: gray;'><th colspan=6>{$lt}</th></tr>"; } $buyprice=money_formatter($r['itmbuyprice']); $sellprice=money_formatter($r['itmsellprice']); $creditcardbuyprice=money_formatter($r['itmbuyprice']); ?><tr><td><? echo $r['itmname']; ?></td><td><? echo $r['itmdesc']; ?></td><td><? echo $buyprice; ?></td><td><? echo $sellprice; ?></td><td><form action='itembuy.php?ID=<? echo $r['itmid']; ?>' name="shopbuy" method='post'> Qty: <input type='text' name='qty' value='1' onkeyup="tot(<? echo $r['itmid']; ?>,<? echo $r['itmbuyprice']; ?>,this.value);" onfocus="clearText(this);" onblur="returnText(this);" /><input type='submit' value='Buy' /></form><div id="res<? echo $r['itmid']; ?>" align="center"></div></td><td> <form action='creditcarditembuy.php?ID=<? echo $r['itmid']; ?>' name="shopbuy" method='post'> Qty: <input type='text' name='qty' value='1' onkeyup="tot(<? echo $r['itmid']; ?>,<? echo $r['itmbuyprice']; ?>,this.value);" onfocus="clearText(this);" onblur="returnText(this);" /><input type='submit' value='Buy' /></form><div id="res<? echo $r['itmid']; ?>" align="center"></div></td> </tr> <? } print "</table>"; } else { print "You are trying to access a shop in another city!"; } } else { print "You are trying to access an invalid shop!"; } } $h->endpage(); ?>

i didnt feel like being a jack of clubs with this bloke lol and its ok

pudda i think youll find i said that a few posts again

if you do the 1st option make sure afterwards you delete installer.php and close register to stop people hacking your game or re running your installer which then re writes your config file

you havent run the installer.php file or there is a sql file in the upload folder that you can just insert into a db in myadmin

you did set xp for the crime? and not made it like 0 or somethink

go into phpmyadmin in the cities table add donator or somthink like that to it then once you travel there you have an this bit of code this would go near the bit where you select the city where cityid = $_GET['ID'] and after the fetch_row so lets say for this that its $r=$db->fetch_row($whatever); as i dont have a copy of mccodes on this OS im on atm i cant double check if($r['donator'] == 1) { if($ir['donatordays > 0) { $db->query("UPDATE users SET location = $_GET['ID'] } else { echo"Sorry only donators can go visit that city Back"; $h->endpage(); exit; } now ino ive not finished it and its only a rough idea of how todo it i would test it/ make a working version if i was on my other OS that has my xampp running on it

config.php

ok you click the link to manually run the cron when you want you donut

heres what i do with my local copy make 4 links on the mainmenu for each cron + code so then when you need to run then you just click the link

bump