fbiss

Re: City Names Instead of adding a query, first try to change that line to:   You begin exploring {$ir['cityname']}

Re: Warning when mailing a admin haha.. nice LostOne

Re: [Video] Web 2.0 cool video mdshare

Re: wtf tables are f d up *wrong category, moving topic*

Re: Mccodes Mods I agree this is the correct category for a topic such as his.

Re: Voting redemption centre error Obviously you are missing the mny_stripfmt function from this mod.

Re: Advance Search {V2} I suggest if you are going to use this mod that you secure it.

Re: House Tax I think you need to relook at this code.. you have all sorts of problems going on.. your event_add is using $ir['userid'] instead of $r['userid'] which the code suggests it should be. The event also implies they lose their house if they dont have enough money on hand, yet i dont see a query to set their will and maxwill back to 100. Instead of asking everyone for every little minor peice of code that you need, you should really study the code that you have that is working and in place, as well study php. if you cant figure out a query to alter the user to a stock house, logically you could look to see how its done estate.php under sell house.

Re: Staff Apps Event   Agreed!

Re: House Tax what do u mean ? u mean like this?   //House Tax Update $uq = $db->query("SELECT * FROM users"); $Row = 0; while ($r = $db->fetch_row($uq)) { $will = $r['maxwill']; $hq = $db->query("SELECT * FROM houses WHERE hWILL='{$will}'"); if ($db->num_rows($hq) == 0) { } $r2 = $db->fetch_row($hq); if ($r['money'] < $r2['hTAX']) { $money = $r['money']; event_add($ir['userid'], "You failed to pay the tax, so you have lost the house."); print "You gave {$_POST['qty']} of item ID {$_POST['item']} to user ID {$_POST['user']}"; } else { $db->query("UPDATE users SET money=money-'{$r2['hTAX']}' WHERE userid='{$r['userid']}'"); } $Rows++; }

Re: Please help.... webster2001 , please be more carefull to post topics in the correct category. *moving topic*

Re: Please Help Me! marFur93, please be more to post topics in the correct categories. *moving topic*

Re: Gang records messed up without seeing anything esle , that looks right

Re: Gang records messed up do you have a cron setup to run cron_day.php?

Re: Gang records messed up to make the viewing the recods even easier (adds a drop down list of the gangs) in staff_gangs.php replace print <<<EOF <form action='staff_gangs.php' method='get'> <input type='hidden' name='action' value='grecord' /> <h4>Gang Record</h4> Enter a gang ID to view the record of: <input type='text' name='gang' value='1' /> Reason for viewing: <input type='text' name='reason' value='' /> <input type='submit' value='Go' /> </form> EOF;   with   print "<form action='staff_gangs.php' method='get'> <input type='hidden' name='action' value='grecord' /> <h4>Gang Record</h4> Select Gang: <select name='gang' type='dropdown'>"; $q=$db->query("SELECT * FROM gangs"); while($r=$db->fetch_row($q)) { print "<option value='{$r['gangID']}'>{$r['gangNAME']}</option>\n"; } print "</select> Reason for viewing: <input type='text' name='reason' value='' /> <input type='submit' value='Go' /> </form>";

Re: Gang records messed up replace your gangcentral.php v2 with   <?php include "globals.php"; print "<h3>Gang Central</h3> [url='creategang.php']> Create A Gang Here[/url] <hr /><u>Gang Listings</u> <table cellspacing=1 class='table'><tr style='background:black;'><th>Gang ID</th><th>Gang Name</th><th>Members</th><th>President</th><th>Respect Level</th></tr>"; $gq=$db->query("SELECT g.*,u.* FROM gangs g LEFT JOIN users u ON g.gangPRESIDENT=u.userid ORDER BY g.gangID ASC;"); while($gangdata=$db->fetch_row($gq)) { print "<tr><td>{$gangdata['gangID']}</td><td>[url='gangs.php?action=view&ID={$gangdata[']{$gangdata['gangNAME']}[/url]</td><td>"; $cnt=mysql_query("SELECT username FROM users WHERE gang={$gangdata['gangID']}",$c); print mysql_num_rows($cnt)."</td><td>[url='viewuser.php?u={$gangdata[']{$gangdata['username']}[/url]</td> <td>{$gangdata['gangRESPECT']}</td></tr>"; } print "</table>"; $h->endpage(); ?>

Re: Gang records messed up   no it goes by the gangs id, not a users id

Re: Gang records messed up Im not seeing any thing wrong with your function admin_gang_record() are you sure that id gang 4 exists?

Re: promo code   yes   if($_POST['promo'] == "testing") { $sm+=100; }

Re: promo code in register.php you will find something like this   if($_POST['promo'] == "Your Promo Code Here") { $sm+=100; }

Re: pictures jimmytubbs - Again.. be more carefull which category you post questions.. the free mod category isn't the proper category for this topic.

Re: Court (v2) I have used this mod, it is very easy to install and works great!

Re: stop same ip transfers Hi mikrows, You could make that query alot smaller and faster by using: $it=$db->query("SELECT lastip FROM users WHERE userid={$_GET['ID']}"); $er=$db->fetch_row($it); if($ir['lastip'] == $er['lastip']) { print "You can't transfer to someone on the same IP. [url='index.php']> Back[/url]"; $h->endpage(); exit; }   This way it only pulls the lastip from the user , instead of fetching all of their user and and userstats information.

Re: guess the 4 digit coed script   try mysql_query("UPDATE users SET daysold=daysold+1, gess=0",$c);

Re: [V2] Reward the active. - Punish the inactive. For those who posted that they didnt understand the unix_timestamp.. for V2: $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0 AND laston>unix_timestamp()-432000");   for V1: mysql_query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0 AND laston>unix_timestamp()-432000",$c);   The -432000 is how many seconds are in 5 days 1440 (minutes in a day) x 60 (seconds in a minute) x 5 (Days) = 432000 seconds