bugsybunny

Re: property market error Any advice guys?

Re: Ask Staff [Mccodes V2] thank you so much guys :) you have saved me many headache's lol

Re: Ask Staff [Mccodes V2] QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIX_TIMESTAMP(),0,'Your question was answered in the ask staff section, please ' at line 1 Query was INSERT INTO events VALUES('',,UNIX_TIMESTAMP(),0,'Your question was answered in the ask staff section, please go there to see it.')

Re: Ask Staff [Mccodes V2]   add that line right before this and it should to the trick... echo 'Your responce was given to the question.';   iv tried that before i asked for help, it sends the event to the person that ANSWERED the question, instead of the person that asked it. thats why im confused lol but thanks

Re: Ask Staff [Mccodes V2] great mod, one problem, im trying to add an event so that once staff answer it, the member that asked the question gets an event saying it has been answered. event_add ($ir[`userid`], "Your question was answered in the ask staff section, please go there to see it."); thats the closest i got lol as you can all see its wrong, i really cant get it to work :(

Re: can someone help me   this took me like 3 reads to get it:) but it did make me laugh !

howdy all, im having a massive problem with the propety market, when a member adds it for sale its fine, when some one buys it, its fine, BUT when the owner trys and removes it, it comes off the market, but it will give them a different property back, its driving me mad! any help ?? <?php include "globals.php"; print "<center><font size='4' face='Arial, Helvetica, sans-serif'>Property Market</font> "; switch($_GET['action']) { case "buy": buy_house(); break; case "remove": remove_house(); break; default: market_index(); break; } function market_index() { global $db,$ir,$c,$userid; print "<table width=90% cellspacing=1 class='table'> <tr> <th>Owner</th> <th>House</th> <th>Price</th> <th>Links</th> </tr>"; $q=$db->query("SELECT pr.*, h.*, u.* FROM propertymarket pr LEFT JOIN houses h ON prHOUSE=h.hID LEFT JOIN users u ON u.userid=pr.prOWNER ORDER BY pr.prCOST ASC",$c); $lt=""; while($r=$db->fetch_row($q)) { if($r['prOWNER'] == $userid) { $link = "[[url='propertymarket.php?action=remove&ID={$r[']Remove[/url]]"; } else { $link = "[[url='propertymarket.php?action=buy&ID={$r[']Buy[/url]]"; } $cost=money_formatter($r['prCOST']); print "<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td>{$r['hNAME']}</td> <td>$cost</td> <td>$link</td> </tr>"; } print "</table>"; } function remove_house() { global $db,$ir,$c,$userid,$h; $q=$db->query("SELECT pr.*, h.*, u.* FROM propertymarket pr LEFT JOIN houses h ON prHOUSE=h.hID LEFT JOIN users u ON u.userid=pr.prOWNER ORDER BY pr.prCOST ASC",$c); if(!$db->num_rows($q)) { print "Error, either this house does not exist, or you are not the owner. [url='propertymarket.php']> Back[/url]"; $h->endpage(); exit; } $r=$db->fetch_row($q); $db->query("INSERT INTO `properties` (`prID`, `prOWNER`, `prHOUSE`) VALUES ('NULL', '$userid', '{$r['hID']}');",$c); $db->query("DELETE FROM propertymarket WHERE prID={$_GET['ID']}",$c); print "House removed from market! [url='propertymarket.php']> Back[/url]"; } function buy_house() { global $db,$ir,$c,$userid,$h; $q=$db->query("SELECT pr.*, h.*, u.* FROM propertymarket pr LEFT JOIN houses h ON prHOUSE=h.hID LEFT JOIN users u ON u.userid=pr.prOWNER ORDER BY pr.prCOST ASC",$c); if(!$db->num_rows($q)) { print "Error, either this house does not exist, or it has already been sold. [url='propertymarket.php']> Back[/url]"; $h->endpage(); exit; } $r=$db->fetch_row($q); if($r['prCOST'] > $ir['money']) { print "Error, you do not have the funds to buy this house. [url='propertymarket.php']> Back[/url]"; $h->endpage(); exit; } $db->query("INSERT INTO `properties` (`prID`, `prOWNER`, `prHOUSE`) VALUES ('NULL', '$userid', '{$r['hID']}');",$c); event_add($r['prOWNER'],"[url='viewuser.php?u=$userid']{$ir['username']}[/url] bought your {$r['hNAME']} from the property market for {$r['prCOST']}.",$c); $db->query("DELETE FROM propertymarket WHERE prID={$_GET['ID']}",$c); print "You bought the {$r['hNAME']} from the market for \$".number_format($r['prCOST'])."."; } $h->endpage(); ?> thank you in advance

Re: Honor Market - My Mod! is this the one that danny696 helped you with ?? and then you converted it to your version?

Re: IRC Trouble iv tried that lol but i dont want the whole header menu ect ect i just want the applet on its own.

Re: change user ids what about inventory ? gang ect ect, anything that stores the users id will need to be changed

Re: honor exchange help look at other pages that gives items to users, like staff_items.php, they show how the items are given using the query.

Re: honor exchange help have you tried doing a query for inserting something into items?? thats the way id do it. instead of cash do it for inserting items. or am i completely wrong?

Good evening all, im having a play around with an irc applet, only i want it to use the usernames the members use ingame, now normally its easy, but iv never used html and php in the same page before! I've been playing for two days now with no luck. here's what i have: <html> <head> <title>IRC</title> </head> <body> <h1>IRC</h1><hr> <applet code=IRCApplet.class archive="irc.jar,pixx.jar" width=640 height=400> <param name="CABINETS" value="irc.cab,securedirc.cab,pixx.cab"> global $ir, $r, $userid; <param name="nick" value="<?php print "{$ir['username']} test";?>"/> <param name="alternatenick" value="Anon???"> <param name="name" value="Java User"> <param name="host" value="irc.test.org"> <param name="gui" value="pixx"> <param name="quitmessage" value="Time to go!"> <param name="asl" value="true"> <param name="style:bitmapsmileys" value="true"> <param name="style:smiley1" value=":) img/sourire.gif"> <param name="style:smiley2" value=":-) img/sourire.gif"> <param name="style:smiley3" value=":-D img/content.gif"> <param name="style:smiley4" value=":d img/content.gif"> <param name="style:smiley5" value=":-O img/OH-2.gif"> <param name="style:smiley6" value=":o img/OH-1.gif"> <param name="style:smiley7" value=":-P img/langue.gif"> <param name="style:smiley8" value=":p img/langue.gif"> <param name="style:smiley9" value=";-) img/clin-oeuil.gif"> <param name="style:smiley10" value=";) img/clin-oeuil.gif"> <param name="style:smiley11" value=":-( img/triste.gif"> <param name="style:smiley12" value=":( img/triste.gif"> <param name="style:smiley13" value=":-| img/OH-3.gif"> <param name="style:smiley14" value=":| img/OH-3.gif"> <param name="style:smiley15" value=":'( img/pleure.gif"> <param name="style:smiley16" value=":$ img/rouge.gif"> <param name="style:smiley17" value=":-$ img/rouge.gif"> <param name="style:smiley18" value="(H) img/cool.gif"> <param name="style:smiley19" value="(h) img/cool.gif"> <param name="style:smiley20" value=":-@ img/enerve1.gif"> <param name="style:smiley21" value=":@ img/enerve2.gif"> <param name="style:smiley22" value=":-S img/roll-eyes.gif"> <param name="style:smiley23" value=":s img/roll-eyes.gif"> <param name="style:floatingasl" value="true"> <param name="pixx:highlight" value="true"> <param name="pixx:highlightnick" value="true"> </applet> <hr></body> </html> ok so iv tried this was (plus many others, but this is the closest) it shows the word test but not the user name!! so im guessing its looking for it, but not finding it, im not getting any errors except i cant see the name !! Please, if its a silly mistake im making, take the piss and help me out :) Thank you.

Re: Sell Your Gang VR1 ahh i found a post helping with it!! gotta love that search ! if($ir['userid'] != ($gangdata['gangPRESIDENT'])) { die ("You need to be president to do this!"); } now i just need to find out where lol

Re: Sell Your Gang VR1 yeah, iv added the file and sql, but it still lets me put the gang on the market even though im not president