Criminal Posted April 3, 2008 Share Posted April 3, 2008 Hey i tryed fixing this file but i cant when i put id in 4 and the record reason i press go and it refreshes to same page can anyone please fix it and post it here thank you <?php include "sglobals.php"; //This contains gang stuffs switch($_GET['action']) { case 'grecord': admin_gang_record(); break; case 'gcredit': admin_gang_credit(); break; case 'gwar': admin_gang_wars(); break; case 'gwardelete': admin_gang_wardelete(); break; case 'gedit': admin_gang_edit_begin(); break; case 'gedit_name': admin_gang_edit_name(); break; case 'gedit_prefix': admin_gang_edit_prefix(); break; case 'gedit_finances': admin_gang_edit_finances(); break; case 'gedit_staff': admin_gang_edit_staff(); break; case 'gedit_capacity': admin_gang_edit_capacity(); break; case 'gedit_crime': admin_gang_edit_crime(); break; case 'gedit_ament': admin_gang_edit_ament(); break; default: print "Error: This script requires an action."; break; } function absint($in, $neg=1) { if($neg) { return abs((int) $in); } else { return (int) $in; } } function admin_gang_record() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); if ( $gang ) { $q=$db->query("SELECT g.* FROM gangs g WHERE g.gangID=$gang"); if(!$db->num_rows($q)) { $_GET['gang']=0; admin_gang_record(); } else if (!$_GET['reason']) { $_GET['gang']=0; admin_gang_record(); } else { $r=$db->fetch_row($q); print "<table width='100%' border='1'> <tr> <td> Gang Name: {$r['gangNAME']} Gang Description: {$r['gangDESC']} Prefix: {$r['gangPREF']} Money: {$r['gangMONEY']} Crystals: {$r['gangCRYSTALS']} Respect: {$r['gangRESPECT']} President: {$r['gangPRESIDENT']} Vice-President: {$r['gangVICEPRES']} Capacity: {$r['gangCAPACITY']} Crime: {$r['gangCRIME']} Hours Left: {$r['gangCHOURS']} Annnouncement: {$r['gangAMENT']} </td> </tr> </table>"; stafflog_add("{$ir['username']} looked at gang id {$r['gangID']} ({$r['gangNAME']})'s record. with the reason {$_GET['reason']}"); } } else { 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; } } function admin_gang_credit() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_POST['gang'] ); $submit = absint( $_POST['submit'] ); $money = absint( $_POST['money'] , 0); $crystals = absint( $_POST['crystals'] , 0); $reason = $_POST['reason']; if ( $submit && $gang && ($money != 0 || $crystals != 0) && $reason) { $db->query("UPDATE gangs SET gangMONEY=gangMONEY+$money, gangCRYSTALS=gangCRYSTALS+$crystals WHERE gangID = $gang"); print "The gang was successfully credited."; stafflog_add("{$ir['username']} credited gang ID {$gang} with {$money} money and/or {$crystals} crystals with the reason {$reason}"); } else if( $gang && ($money != 0 || $crystals != 0)) { $q=$db->query("SELECT gangNAME FROM gangs WHERE gangID = $gang"); print "You are crediting ".$db->fetch_single($q)." with £$money and/or $crystals crystals. <form action='staff_gangs.php?action=gcredit' method='post'> <input type='hidden' name='gang' value='$gang' /> <input type='hidden' name='money' value='$money' /> <input type='hidden' name='crystals' value='$crystals' /> <input type='hidden' name='submit' value='1' /> Reason: <input type='text' name='reason' /> <input type='submit' value='Credit' /> </form>"; } else { print "<h3>Credit Gang</h3> <form action='staff_gangs.php?action=gcredit' method='post'> <table border='1' width='50%'> <tr> <td align='right'>Gang's ID:</td> <td align='left'><input type='text' name='gang' value='1' /></td> </tr> <tr> <td align='right'>Money:</td> <td align='left'><input type='text' name='money' value='1000' /></td> </tr> <tr> <td align='right'>Crystals:</td> <td align='left'><input type='text' name='crystals' value='10' /></td> </tr> <tr> <td align='center' colspan='2'> <input type='submit' value='Credit' /> </td> </tr> </table>"; } } function admin_gang_wars() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } print "<h3>Manage Gang Wars</h3> <table width=75% border='2'>"; $q=$db->query("SELECT w.*,g1.gangNAME as declarer, g1.gangRESPECT as drespect, g2.gangNAME as defender, g2.gangRESPECT as frespect FROM gangwars w LEFT JOIN gangs g1 ON w.warDECLARER=g1.gangID LEFT JOIN gangs g2 ON w.warDECLARED=g2.gangID"); while($r=$db->fetch_row($q)) { print "<tr> <td width=40%>[url='gangs.php?action=view&ID={$r[']{$r['declarer']}[/url] [{$r['drespect']} respect]</a></td> <td width=10%>vs.</td> <td width=40%>[url='gangs.php?action=view&ID={$r[']{$r['defender']}[/url] [{$r['frespect']} respect]</a></td> <td>[[url='staff_gangs.php?action=gwardelete&war={$r[']Delete[/url]]</td></tr>"; } print "</table>"; } function admin_gang_wardelete() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $q=$db->query("SELECT w.*,g1.gangNAME as declarer, g1.gangRESPECT as drespect, g2.gangNAME as defender, g2.gangRESPECT as frespect FROM gangwars w LEFT JOIN gangs g1 ON w.warDECLARER=g1.gangID LEFT JOIN gangs g2 ON w.warDECLARED=g2.gangID WHERE w.warID={$_GET['war']}"); $r=$db->fetch_row($q); $db->query("DELETE FROM gangwars WHERE warID={$_GET['war']}"); print "War cleared."; stafflog_add("{$ir['username']} deleted war ID {$_GET['war']} ([url='gangs.php?action=view&ID={$r[']{$r['declarer']}[/url] [{$r['drespect']} respect]</a> vs. [url='gangs.php?action=view&ID={$r[']{$r['defender']}[/url] [{$r['frespect']} respect]</a>)"); } function admin_gang_edit_begin() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_POST['gang'] ); if ( $gang ) { $q=$db->query("SELECT gangNAME FROM gangs WHERE gangID = $gang"); $theirname=$db->fetch_single($q); $edits = array ( 1 => array ( 'Name And Description', 'gedit_name', '4' ), 2 => array ( 'Prefix', 'gedit_prefix', '4' ), 3 => array ( 'Finances + Respect', 'gedit_finances', '4' ), 4 => array ( 'Staff', 'gedit_staff', '4' ), 5 => array ( 'Capacity', 'gedit_capacity', '4' ), 6 => array ( 'Organised Crime', 'gedit_crime', '4' ), 7 => array ( 'Announcement', 'gedit_ament', '4' ) ); print "<h3>Manage Gang</h3> You are managing the gang: $theirname Choose an edit to perform. <table width='80%' class='table' cellspacing='1'><tr style='background: gray'><th>Edit Type</th> <th>Available For Use</th> <th>Use</th> </tr>\n"; foreach ( $edits as $k => $v) { if ($v[2] >= $ir['user_level']) { $a="green'>Yes";$l="[url='staff_gangs.php?action=$v[1]&gang=$gang']Go[/url]"; } else { $a="red'>No";$l="N/A"; } print "<tr> <td>$v[0]</td> <td>[b]<font color='$a</font>[/b]</td> <td>$l</td></tr>\n"; } print "</table>"; } else { print <<<EOF <form action='staff_gangs.php?action=gedit' method='post'> <h4>Gang Management</h4> Enter a gang ID to manage: <input type='text' name='gang' value='1' /> <input type='submit' value='Go' /> </form> EOF; } } function admin_gang_edit_name() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $submit = absint( $_POST['submit'] ); $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang", $c); $r=$db->fetch_row($q); if ( $submit ) { $db->query("UPDATE gangs SET gangNAME='{$_POST['gangNAME']}', gangDESC='{$_POST['gangDESC']}' WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add($userid, "{$ir['username']} edited gang ID $gang's name and/or description", $c); } else { print <<<EOF <h3>Gang Management: Name/Description</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_name&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Name:</td> <td align=left><input type='text' name='gangNAME' value='{$r['gangNAME']}' /></td> </tr> <tr> <td align=right>Description:</td> <td align=left><textarea rows='7' cols='40' name='gangDESC'>{$r['gangDESC']}</textarea></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_prefix() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $submit = absint( $_POST['submit'] ); $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit ) { $db->query("UPDATE gangs SET gangPREF='{$_POST['gangPREF']}' WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's prefix"); } else { print <<<EOF <h3>Gang Management: Prefix</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_prefix&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Prefix:</td> <td align=left><input type='text' name='gangPREF' value='{$r['gangPREF']}' /></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_finances() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $money = absint( $_POST['money'], 0 ); $crystals = absint( $_POST['crystals'], 0 ); $respect = absint( $_POST['respect'], 0 ); $submit = absint( $_POST['submit'] ); $reason = $_POST['reason']; $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit && $reason ) { $db->query("UPDATE gangs SET gangMONEY=$money, gangCRYSTALS=$crystals, gangRESPECT=$respect WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's finances with the reason $reason"); } else { print <<<EOF <h3>Gang Management: Financial Details</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_finances&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Money:</td> <td align=left><input type='text' name='money' value='{$r['gangMONEY']}' /></td> </tr> <tr> <td align=right>Crystals:</td> <td align=left><input type='text' name='crystals' value='{$r['gangCRYSTALS']}' /></td> </tr> <tr> <td align=right>Respect:</td> <td align=left><input type='text' name='respect' value='{$r['gangRESPECT']}' /></td> </tr> <tr> <td align=right>Reason for editing:</td> <td align=left><input type='text' name='reason' value='' /></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_staff() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $president = absint( $_POST['president'], 0 ); $vicepres = absint( $_POST['vicepres'], 0 ); $submit = absint( $_POST['submit'] ); $reason = $_POST['reason']; $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit && $reason ) { $db->query("UPDATE gangs SET gangPRESIDENT=$president, gangVICEPRES=$vicepres WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's staff with the reason $reason"); } else { print <<<EOF <h3>Gang Management: Staff</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_staff&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>President:</td> <td align=left><input type='text' name='president' value='{$r['gangPRESIDENT']}' /></td> </tr> <tr> <td align=right>Vice-President:</td> <td align=left><input type='text' name='vicepres' value='{$r['gangVICEPRES']}' /></td> </tr> <tr> <td align=right>Reason for editing:</td> <td align=left><input type='text' name='reason' value='' /></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_capacity() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $capacity = absint( $_POST['capacity'], 0 ); $submit = absint( $_POST['submit'] ); $reason = $_POST['reason']; $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit && $reason ) { $db->query("UPDATE gangs SET gangCAPACITY=$capacity WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's capacity with the reason $reason"); } else { print <<<EOF <h3>Gang Management: Capacity</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_capacity&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Capacity:</td> <td align=left><input type='text' name='capacity' value='{$r['gangCAPACITY']}' /></td> </tr> <tr> <td align=right>Reason for editing:</td> <td align=left><input type='text' name='reason' value='' /></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_crime() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $crime = absint( $_POST['crime'], 0 ); $chours = absint( $_POST['chours'], 0 ); $submit = absint( $_POST['submit'] ); $reason = $_POST['reason']; $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit && $reason ) { $db->query("UPDATE gangs SET gangCRIME=$crime, gangCHOURS=$chours WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's organised crime with the reason $reason"); } else { print <<<EOF <h3>Gang Management: Organised Crimes</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_crime&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Crime ID:</td> <td align=left><input type='text' name='crime' value='{$r['gangCRIME']}' /></td> </tr> <tr> <td align=right>Crime Hours Left:</td> <td align=left><input type='text' name='chours' value='{$r['gangCHOURS']}' /></td> </tr> <tr> <td align=right>Reason for editing:</td> <td align=left><input type='text' name='reason' value='' /></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function admin_gang_edit_ament() { global $db,$ir, $userid, $c; if($ir['user_level'] > 3) { die("403"); } $gang = absint( $_GET['gang'] ); $submit = absint( $_POST['submit'] ); $q=$db->query("SELECT * FROM gangs WHERE gangID = $gang"); $r=$db->fetch_row($q); if ( $submit ) { $db->query("UPDATE gangs SET gangAMENT='{$_POST['gangAMENT']}' WHERE gangID=$gang"); print "Gang has been successfully modified."; stafflog_add("{$ir['username']} edited gang ID $gang's announcement"); } else { print <<<EOF <h3>Gang Management: Announcement</h3> Editing the gang: {$r['gangNAME']} <form action='staff_gangs.php?action=gedit_ament&gang=$gang' method='post'> <table width='50%' cellspacing='1' class='table'> <tr> <td align=right>Announcement:</td> <td align=left><textarea rows='7' cols='40' name='gangAMENT'>{$r['gangAMENT']}</textarea></td> </tr> <tr> <td align=center colspan=2><input type='hidden' name='submit' value='1' /><input type='submit' value='Edit' /></td> </tr> </table> </form> EOF; } } function report_clear() { global $db,$db,$ir,$c,$h,$userid; if($ir['user_level'] > 3) { die("403"); } $_GET['ID'] = abs((int) $_GET['ID']); stafflog_add("Cleared player report ID {$_GET['ID']}"); $db->query("DELETE FROM preports WHERE prID={$_GET['ID']}"); print "Report cleared and deleted! [url='staff_users.php?action=reportsview']> Back[/url]"; } $h->endpage(); ?> Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Anyone know the problam Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 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? Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Yes hes my gang leader Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 Re: Gang records messed up Yes hes my gang leader no it goes by the gangs id, not a users id Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Ok how do we find out gang id Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Its ok i have figured the gang id thank you i thought user id i dident look it properly thank you for ur help m8 my bad Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Any one know how to add a new row on gangs so it sayes Gang id so then indtead of going on phpmyadmin gangs to check gang id Can some one put the code here please i tryed figuring it out but failed am a noob and new to coding am learning php on a book thank you Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Thank you lostone :wink: Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up No mate dident work GANG ID Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up gangcentral.php v2 <?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</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>[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(); ?> Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 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(); ?> Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Thank you very much fbiss :-) Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 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>"; Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up Thank you very much again Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up One more problam crystal bak isent giving 2% a day cbank.php <?php include "globals.php"; print "<h3>Crystal Reserve</h3>"; if($ir['cbank']>-1) { switch($_GET['action']) { case "deposit": deposit(); break; case "withdraw": withdraw(); break; default: index(); break; } } else { if(isset($_GET['buy'])) { if($ir['money']>4999999) { print "Congratulations, you bought a crystal reserve account for \$5,000,000! [url='bank.php']Start using my account[/url]"; $db->query("UPDATE users SET money=money-5000000,cbank=0 WHERE userid=$userid"); } else { print "You do not have enough money to open an account. [url='explore.php']Back to town...[/url]"; } } else { print "Open a crystal reserve account today, just \$5,000,000! [url='cbank.php?buy']> Yes, sign me up![/url]"; } } function index() { global $db, $ir,$c,$userid,$h; print "\n[b]You currently have {$ir['cbank']} in the crystal reserve.[/b] At the end of each day, your crystal reserve balance will go up by 2%. <table width='75%' cellspacing=1 class='table'> <tr> <td width='50%'>[b]Deposit Crystals[/b] It will cost you 15% of the crystals you deposit, rounded up. The maximum fee is \$3,000.<form action='cbank.php?action=deposit' method='post'> Amount: <input type='text' name='deposit' value='{$ir['crystals']}' /> <input type='submit' value='Deposit' /></form></td> <td> [b]Withdraw Crystals[/b] There is no fee on withdrawals.<form action='cbank.php?action=withdraw' method='post'> Amount: <input type='text' name='withdraw' value='{$ir['cbank']}' /> <input type='submit' value='Withdraw' /></form></td> </tr> </table>"; } function deposit() { global $db,$ir,$c,$userid,$h; $_POST['deposit']=abs((int) $_POST['deposit']); if($_POST['deposit'] > $ir['crystals']) { print "You do not have enough crystals to deposit this amount."; } else { $fee=ceil($_POST['deposit']*15/100); if($fee > 3000) { $fee=3000; } $gain=$_POST['deposit']-$fee; $ir['cbank']+=$gain; $db->query("UPDATE users SET cbank=cbank+$gain, crystals=crystals-{$_POST['deposit']} where userid=$userid"); print "You hand over {$_POST['deposit']} to be deposited, after the fee is taken ($fee), $gain crystals is added to your crystal reserve account. [b]You now have {$ir['cbank']} in the crystal reserve.[/b] [url='cbank.php']> Back[/url]"; } } function withdraw() { global $db,$ir,$c,$userid,$h; $_POST['withdraw']=abs((int) $_POST['withdraw']); if($_POST['withdraw'] > $ir['cbank']) { print "You do not have enough reserved crystals to withdraw this amount."; } else { $gain=$_POST['withdraw']; $ir['cbank']-=$gain; $db->query("UPDATE users SET cbank=cbank-$gain, crystals=crystals+$gain where userid=$userid"); print "You ask to withdraw $gain, the crystal reserve automated teller spits out your crystals into a little satchel. A robotic arm then picks up the satchel and drops it into your hand. You there hear a robotic voice chime - Have a nice day {$ir['username']} - [b]You now have {$ir['cbank']} crystals in the crystal reserve.[/b] [url='cbank.php']> Back[/url]"; } } $h->endpage(); ?> Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 Re: Gang records messed up do you have a cron setup to run cron_day.php? Quote Link to comment Share on other sites More sharing options...
Criminal Posted April 4, 2008 Author Share Posted April 4, 2008 Re: Gang records messed up cron_day.php is working i have this for crystal bank $db->query("UPDATE users SET cbank=cbank+(cbank/50) where cbank>0"); on cron_day Quote Link to comment Share on other sites More sharing options...
fbiss Posted April 4, 2008 Share Posted April 4, 2008 Re: Gang records messed up without seeing anything esle , that looks right Quote Link to comment Share on other sites More sharing options...
Ishy Posted April 8, 2008 Share Posted April 8, 2008 Re: Gang records messed up Is there a field in users table called 'cbank' ? If not, that is your problem. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.