Gang records messed up

Criminal · 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();
?>

Criminal · April 4, 2008

Re: Gang records messed up

Anyone know the problam

fbiss · 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?

Criminal · April 4, 2008

Re: Gang records messed up

Yes hes my gang leader

fbiss · April 4, 2008

Re: Gang records messed up

Yes hes my gang leader

no it goes by the gangs id, not a users id

Criminal · April 4, 2008

Re: Gang records messed up

Ok how do we find out gang id

Criminal · 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

Criminal · 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

Criminal · April 4, 2008

Re: Gang records messed up

Thank you lostone :wink:

Criminal · April 4, 2008

Re: Gang records messed up

No mate dident work GANG ID

Criminal · 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();
?>

fbiss · 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();
?>

Criminal · April 4, 2008

Re: Gang records messed up

Thank you very much fbiss :-)

fbiss · 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>";

Criminal · April 4, 2008

Re: Gang records messed up

Thank you very much again

Criminal · 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();
?>

fbiss · April 4, 2008

Re: Gang records messed up

do you have a cron setup to run cron_day.php?

Criminal · 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

fbiss · April 4, 2008

Re: Gang records messed up

without seeing anything esle , that looks right

Ishy · April 8, 2008

Re: Gang records messed up

Is there a field in users table called 'cbank' ?

If not, that is your problem.

Sign In

Gang records messed up

Recommended Posts

Criminal

Criminal

fbiss

Criminal

fbiss

Criminal

Criminal

Criminal

Criminal

Criminal

Criminal

fbiss

Criminal

fbiss

Criminal

Criminal

fbiss

Criminal

fbiss

Ishy

Join the conversation

Browse

Activity

Hosting