Organised Crimes Not showing in Gangs

Raven1992 · August 21, 2012

Hey People I Have a Big Problem I have folowed the instructions on how to add a gang crime into the gangs. But when I go to my Gang and clicked on Staff menu then Organised Crimes I don't see the Crimes i Made Is there anyone out there that can help me on this Thanks

Newbie · August 22, 2012

have you checked that the crime is in the database?

post up your gang file/s would be easier to check

Raven1992 · August 22, 2012

here the file of my gang php

require_once('globals.php');
if (!isset($_GET['ID']))
{
   $_GET['ID'] = 0;
}
$_GET['ID'] = abs((int) $_GET['ID']);
if (!$_GET['ID'])
{
   echo "Invalid use of file";
}
else
{
   $gq =
           $db->query(
                   "SELECT `gangPRESIDENT`, `gangVICEPRES`, `gangNAME`,
                    `gangID`, `gangRESPECT`, `gangDESC`
   				 FROM `gangs`
   				 WHERE `gangID` = {$_GET['ID']}");
   $gangdata = $db->fetch_row($gq);
   if (!isset($_GET['action']))
   {
       $_GET['action'] = '';
   }
   switch ($_GET['action'])
   {
   case 'view':
       gang_view();
       break;

   case 'userlist':
       gang_userlist();
       break;

   case 'apply':
       gang_applyform();
       break;

   case 'applys':
       gang_applysubmit();
       break;

   default:
       gang_view();
       break;
   }
}

function gang_view()
{
   global $db, $ir, $c, $h, $gangdata;
   $pq =
           $db->query(
                   "SELECT `userid`, `username`
   				 FROM `users`
   				 WHERE `userid` = {$gangdata['gangPRESIDENT']}
   				 LIMIT 1");
   if ($db->num_rows($pq) == 0)
   {
       $ldr = array('userid' => 0);
   }
   else
   {
       $ldr = $db->fetch_row($pq);
   }
   $db->free_result($pq);
   $vpq =
           $db->query(
                   "SELECT `userid`, `username`
                    FROM `users`
                    WHERE `userid` = {$gangdata['gangVICEPRES']}");
   if ($db->num_rows($vpq) == 0)
   {
       $coldr = array('userid' => 0);
   }
   else
   {
       $coldr = $db->fetch_row($vpq);
   }
   $db->free_result($vpq);
   echo "<h3><u>{$gangdata['gangNAME']} Gang</u></h3><hr />";
   if ($ldr['userid'] > 0)
   {
       print
               "President: <a href='viewuser.php?u={$ldr['userid']}'>{$ldr['username']}</a><br />";
   }
   else
   {
       print "President: N/A<br />";
   }
   if ($coldr['userid'] > 0)
   {
       print
               "Vice-President: <a href='viewuser.php?u={$coldr['userid']}'>{$coldr['username']}</a><hr />";
   }
   else
   {
       print "Vice-President: N/A<hr />";
   }
   $cnt =
           $db->query(
                   "SELECT COUNT(`userid`)
                    FROM `users`
                    WHERE `gang` = {$gangdata['gangID']}");
   echo "<b>Members:</b> " . $db->fetch_single($cnt)
           . "<br />
	  <b>Description: </b> {$gangdata['gangDESC']}<br />
	  <b>Respect Level: </b> {$gangdata['gangRESPECT']}<br />
	 > <a href='gangs.php?action=userlist&ID={$gangdata['gangID']}'>
	  User List
	 </a><br />
	 > <a href='gangs.php?action=apply&ID={$gangdata['gangID']}'>
	  Apply
	 </a>";
   $db->free_result($cnt);
}

function gang_userlist()
{
   global $db, $ir, $c, $h, $gangdata;
   echo "<h3>Userlist for {$gangdata['gangNAME']}</h3>
	  <table>
	  	<tr style='background: gray;'>
	  		<th>User</th>
	  		<th>Level</th>
	  		<th>Days In Gang</th>
	  	</tr>";
   $q =
           $db->query(
                   "SELECT `userid`, `username`, `level`, `daysingang`
                    FROM `users`
                    WHERE `gang` = {$gangdata['gangID']}
                    ORDER BY `daysingang` DESC, `level` DESC");
   while ($r = $db->fetch_row($q))
   {
       echo "<tr>
       		<td><a href='viewuser.php?u={$r['userid']}'>
                {$r['username']}
       		</a></td>
       		<td>{$r['level']}</td>
       		<td>{$r['daysingang']}</td>
       	  </tr>";
   }
   $db->free_result($q);
   echo "</table><br />
> <a href='gangs.php?action=view&ID={$gangdata['gangID']}'>
Back
</a>";
}

function gang_applyform()
{
   global $ir, $c, $h, $gangdata;
   if ($ir['gang'] == 0)
   {
       $apply_csrf = request_csrf_code('gang_apply');
       echo "<form action='gangs.php?action=applys&ID={$_GET['ID']}' method='post'>
Type the reason you should be in this faction.<br />
<textarea name='application' rows='7' cols='40'></textarea><br />
<input type='hidden' name='verf' value='{$apply_csrf}' />
<input type='submit' value='Apply' /></form>";
   }
   else
   {
       echo "You cannot apply for a gang when you are already in one.";
   }
}

function gang_applysubmit()
{
   global $db, $ir, $c, $h, $gangdata, $userid;
   $application =
           (isset($_POST['application']) && is_string($_POST['application']))
                   ? $db->escape(
                           htmlentities(
                                   stripslashes($_POST['application']),
                                   ENT_QUOTES, 'ISO-8859-1')) : '';
   if (!isset($_POST['verf'])
           || !verify_csrf_code('gang_apply', stripslashes($_POST['verf'])))
   {
       echo "
       Your request to apply to this gang has expired. Please try again.<br />
       > <a href='gangs.php?action=apply&ID={$_GET['ID']}'>Back</a>
          ";
       die($h->endpage());
   }
   if (!$ir['gang'])
   {
       $db->query(
               "INSERT INTO `applications`
                VALUES(NULL, $userid, {$_GET['ID']}, '{$application}')");
       $gev =
               $db->escape(
                       "<a href='viewuser.php?u={$userid}'>{$ir['username']}</a>"
                               . " sent an application to join this gang.");
       $db->query(
               "INSERT INTO `gangevents`
                VALUES(NULL, {$_GET['ID']}, " . time() . ", '{$gev}')");
       echo "You sent your application to the {$gangdata['gangNAME']} gang.";
   }
   else
   {
       echo "You cannot apply for a gang when you are already in one.";
   }
}
$h->endpage();

and here the file of my s_gang.php

require_once('sglobals.php');
//This contains gang stuffs
if (!isset($_GET['action']))
{
   $_GET['action'] = '';
}
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;
case 'createoc': 
   create_oc_form();
   break;
case 'createocsub': 
   create_oc_sub();
   break;
default:
   echo 'Error: This script requires an action.';
   break;
}

function admin_gang_record()
{
   global $db, $ir, $userid, $c, $h;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_POST['gang']) && is_numeric($_POST['gang']))
                   ? abs(intval($_POST['gang'])) : '';
   $_POST['reason'] =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   if ($gang)
   {
       staff_csrf_stdverify('staff_gangs_record',
               'staff_gangs.php?action=grecord');
       $q =
               $db->query(
                       "SELECT `gangNAME`, `gangDESC`, `gangPREF`,
                        `gangMONEY`, `gangCRYSTALS`, `gangRESPECT`,
                        `gangPRESIDENT`, `gangVICEPRES`, `gangCAPACITY`,
                        `gangCRIME`, `gangCHOURS`, `gangAMENT`, `gangID`
                        FROM `gangs`
                        WHERE `gangID`  = $gang");
       if ($db->num_rows($q) == 0)
       {
           $db->free_result($q);
           $_POST['gang'] = 0;
           admin_gang_record();
       }
       else if (!$_POST['reason'])
       {
           $_POST['gang'] = 0;
           admin_gang_record();
       }
       else
       {
           $r = $db->fetch_row($q);
           $db->free_result($q);
           echo "
           <table width='100%' border='1'>
           		<tr>
           	<td>
           Gang Name: {$r['gangNAME']}
           <br />
           Gang Description: {$r['gangDESC']}
           <br />
           Prefix: {$r['gangPREF']}
           <br />
           Money: {$r['gangMONEY']}
           <br />
           Crystals: {$r['gangCRYSTALS']}
           <br />
           Respect: {$r['gangRESPECT']}
           <br />
           President: {$r['gangPRESIDENT']}
           <br />
           Vice-President: {$r['gangVICEPRES']}
           <br />
           Capacity: {$r['gangCAPACITY']}
           <br />
           Crime: {$r['gangCRIME']}
           <br />
           Hours Left: {$r['gangCHOURS']}
           <br />
           Annnouncement: {$r['gangAMENT']}
           	</td>
           		</tr>
           </table>
  			";
           stafflog_add(
                   $ir['username'] . ' looked at gang id ' . $r['gangID']
                           . ' (' . $r['gangNAME']
                           . ')\'s record. with the reason '
                           . $_POST['reason']);
       }
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_record');
       echo "
	<form action='staff_gangs.php?action=grecord' method='post'>
	<h4>Gang Record</h4>
		Enter a gang ID to view the record of: <input type='text' name='gang' value='1' /><br />
		Reason for viewing: <input type='text' name='reason' value='' /><br />
        {$csrf}
		<input type='submit' value='Go' />
	</form>
 		 ";
   }
}

function admin_gang_credit()
{
   global $db, $ir, $userid, $c, $h;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_POST['gang']) && is_numeric($_POST['gang']))
                   ? abs(intval($_POST['gang'])) : '';
   $money =
           (isset($_POST['money']) && is_numeric($_POST['money']))
                   ? abs(intval($_POST['money'])) : 0;
   $crystals =
           (isset($_POST['crystals']) && is_numeric($_POST['crystals']))
                   ? abs(intval($_POST['crystals'])) : 0;
   $reason =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   if (($money != 0 || $crystals != 0) && ($gang && $reason))
   {
       $q =
               $db->query(
                       "SELECT `gangNAME`
                        FROM `gangs`
                        WHERE `gangID` = $gang");
       if ($db->num_rows($q) == 0)
       {
           $db->free_result($q);
           echo "Invalid gang.";
           die($h->endpage());
       }
       staff_csrf_stdverify('staff_gangs_credit2',
               'staff_gangs.php?action=gcredit');
       $gangname = $db->fetch_single($q);
       $db->free_result($q);
       $db->query(
               "UPDATE `gangs`
                SET `gangMONEY` = `gangMONEY` + $money,
                `gangCRYSTALS` = `gangCRYSTALS` + $crystals
                WHERE `gangID` = $gang");
       echo "The gang {$gangname} was successfully credited.";
       stafflog_add(
               "{$ir['username']} credited {$gangname} (gang ID {$gang})
                with {$money} money and/or {$crystals} crystals
                with the reason {$reason}");
   }
   else if ($gang && ($money != 0 || $crystals != 0))
   {
       staff_csrf_stdverify('staff_gangs_credit1',
               'staff_gangs.php?action=gcredit');
       $q =
               $db->query(
                       "SELECT `gangNAME`
                        FROM `gangs`
                        WHERE `gangID` = $gang");
       if ($db->num_rows($q) == 0)
       {
           $db->free_result($q);
           echo "Invalid gang.";
           die($h->endpage());
       }
       $csrf = request_csrf_html('staff_gangs_credit2');
       echo "
       You are crediting " . $db->fetch_single($q) . " with "
               . money_formatter($money)
               . " and/or $crystals crystals.
       <br />
       <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' />
       	{$csrf}
       	Reason: <input type='text' name='reason' />
       <br />
       	<input type='submit' value='Credit' />
       </form>
          ";
       $db->free_result($q);
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_credit1');
       echo "
       <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'>
                       {$csrf}
                       <input type='submit' value='Credit' />
                   </td>
       		</tr>
       </table>
          ";
   }
}

function admin_gang_wars()
{
   global $db, $ir, $userid, $c, $h;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   echo '
<h3>Manage Gang Wars</h3>
<table width="75%" border="2">
  	';
   $q =
           $db->query(
                   "SELECT `warID`, `warDECLARED`, `warDECLARER`,
                    `g1`.`gangNAME` AS `declarer`,
                    `g1`.`gangRESPECT` AS `drespect`,
                    `g2`.`gangNAME` AS `defender`,
                    `g2`.`gangRESPECT` AS `frespect`
                    FROM `gangwars` AS `w`
                    LEFT JOIN `gangs` AS `g1`
                    ON `w`.`warDECLARER` = `g1`.`gangID`
                    LEFT JOIN `gangs` AS `g2`
                    ON `w`.`warDECLARED` = `g2`.`gangID`");
   while ($r = $db->fetch_row($q))
   {
       $csrf = request_csrf_html("staff_gangs_wardelete{$r['warID']}");
       echo "
	<tr>
		<td width='40%'>
			<a href='gangs.php?action=view&ID={$r['warDECLARER']}'>
                   {$r['declarer']}
               </a>
			[{$r['drespect']} respect]
		</td>
		<td width='10%'>vs.</td>
		<td width='40%'>
			<a href='gangs.php?action=view&ID={$r['warDECLARED']}'>
                   {$r['defender']}
               </a>
               [{$r['frespect']} respect]
           </td>
		<td>
			<form action='staff_gangs.php?action=gwardelete&war={$r['warID']}' method='post'>
		        {$csrf}
				<input type='submit' value='Delete' />
			</form>
		</td>
	</tr>
  		";
   }
   $db->free_result($q);
   echo '</table>';
}

function admin_gang_wardelete()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />> <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $_GET['war'] =
           (isset($_GET['war']) && is_numeric($_GET['war']))
                   ? abs(intval($_GET['war'])) : 0;
   staff_csrf_stdverify("staff_gangs_wardelete{$_GET['war']}",
           'staff_gangs.php?action=gwar');
   $q =
           $db->query(
                   "SELECT `warDECLARED`, `warDECLARER`,
                    `g1`.`gangNAME` AS `declarer`,
                    `g1`.`gangRESPECT` AS `drespect`,
                    `g2`.`gangNAME` AS `defender`,
                    `g2`.`gangRESPECT` AS `frespect`
                    FROM `gangwars` AS `w`
                    LEFT JOIN `gangs` AS `g1`
                    ON `w`.`warDECLARER` = `g1`.`gangID`
                    LEFT JOIN `gangs` AS `g2`
                    ON `w`.`warDECLARED` = `g2`.`gangID`
                    WHERE `w`.`warID` = {$_GET['war']}");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid war.<br />
       > <a href="staff_gangs.php?action=gwar">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   $db->query("DELETE FROM `gangwars`
   			WHERE `warID` = {$_GET['war']}");
   echo 'War cleared.<br />
   > <a href="staff_gangs.php?action=gwar">Go Back</a>';
   stafflog_add(
           "{$ir['username']} deleted war ID {$_GET['war']}
            (<a href='gangs.php?action=view&ID={$r['warDECLARER']}'>{$r['declarer']}</a>
            	[{$r['drespect']} respect]
            	vs.
             <a href='gangs.php?action=view&ID={$r['warDECLARED']}'>{$r['defender']}</a>
             	[{$r['frespect']} respect])");
}

function admin_gang_edit_begin()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_POST['gang']) && is_numeric($_POST['gang']))
                   ? abs(intval($_POST['gang'])) : '';
   if ($gang)
   {
       $q =
               $db->query(
                       "SELECT `gangNAME`
                        FROM `gangs`
                        WHERE `gangID` = $gang");
       if ($db->num_rows($q) == 0)
       {
           $db->free_result($q);
           echo "Invalid gang.";
           die($h->endpage());
       }
       $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'));
       echo "
       <h3>Manage Gang</h3>
       You are managing the gang: $theirname
       <br />
       Choose an edit to perform.
       <br />
       <table width='80%' class='table' cellspacing='1'>
       		<tr>
       			<th>Edit Type</th>
       			<th>Available For Use</th>
       			<th>Use</th>
       		</tr>
  		";
       foreach ($edits as $k => $v)
       {
           if ($v[2] >= $ir['user_level'])
           {
               $a = "green'>Yes";
               $l =
                       "<a href='staff_gangs.php?action=$v[1]&gang=$gang'>Go</a>";
           }
           else
           {
               $a = "red'>No";
               $l = "N/A";
           }
           echo "
		<tr>
			<td>$v[0]</td>
			<td><span style='font-weight: bold; color: $a</span></td>
			<td>$l</td>
		</tr>
  			";
       }
       echo '</table>';
   }
   else
   {
       echo "
	<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' />
		<br />
		<input type='submit' value='Go' />
	</form>
  		";
   }
}

function admin_gang_edit_name()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $_POST['gangNAME'] =
           (isset($_POST['gangNAME'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['gangNAME']))
                   ? $db->escape(strip_tags(stripslashes($_POST['gangNAME'])))
                   : '';
   $_POST['gangDESC'] =
           (isset($_POST['gangDESC']))
                   ? $db->escape(strip_tags(stripslashes($_POST['gangDESC'])))
                   : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`,`gangDESC`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $_POST['gangNAME'] && $_POST['gangDESC'])
   {
       staff_csrf_stdverify('staff_gangs_edit_name',
               "staff_gangs.php?action=gedit_name&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangNAME` = '{$_POST['gangNAME']}',
                `gangDESC` = '{$_POST['gangDESC']}'
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add($userid,
               "{$ir['username']} edited gang ID $gang's name and/or description",
               $c);
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_name');
       echo "
       <h3>Gang Management: Name/Description</h3>
       Editing the gang: {$r['gangNAME']}
       <br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_prefix()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $_POST['gangPREF'] =
           (isset($_POST['gangPREF']) && strlen($_POST['gangPREF']) <= 5)
                   ? $db->escape(strip_tags(stripslashes($_POST['gangPREF'])))
                   : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangPREF`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $_POST['gangPREF'])
   {
       staff_csrf_stdverify('staff_gangs_edit_prefix',
               "staff_gangs.php?action=gedit_prefix&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangPREF` = '{$_POST['gangPREF']}'
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add("{$ir['username']} edited gang ID $gang's prefix");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_prefix');
       echo "
       <h3>Gang Management: Prefix</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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']}' maxlength='5' />
       			</td>
       		</tr>
       		<tr>
       			<td align='center' colspan='2'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_finances()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />> <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $money =
           (isset($_POST['money']) && is_numeric($_POST['money']))
                   ? abs(intval($_POST['money'])) : 0;
   $crystals =
           (isset($_POST['crystals']) && is_numeric($_POST['crystals']))
                   ? abs(intval($_POST['crystals'])) : 0;
   $reason =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   $respect =
           (isset($_POST['respect']) && is_numeric($_POST['respect']))
                   ? abs(intval($_POST['respect'])) : 0;
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangMONEY`, `gangCRYSTALS`,
                    `gangRESPECT`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $reason)
   {
       staff_csrf_stdverify('staff_gangs_edit_finances',
               "staff_gangs.php?action=gedit_finances&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangMONEY` = $money, `gangCRYSTALS` = $crystals,
                `gangRESPECT` = $respect
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add(
               "{$ir['username']} edited gang ID $gang's finances with the reason $reason");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_finances');
       echo "
       <h3>Gang Management: Financial Details</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_staff()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />> <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $president =
           (isset($_POST['president']) && is_numeric($_POST['president']))
                   ? abs(intval($_POST['president'])) : '';
   $vicepres =
           (isset($_POST['vicepres']) && is_numeric($_POST['vicepres']))
                   ? abs(intval($_POST['vicepres'])) : '';
   $reason =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangPRESIDENT`, `gangVICEPRES`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $reason && $president && $vicepres)
   {
       staff_csrf_stdverify('staff_gangs_edit_staff',
               "staff_gangs.php?action=gedit_staff&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangPRESIDENT` = $president,
                `gangVICEPRES` = $vicepres
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add(
               "{$ir['username']} edited gang ID $gang's staff with the reason $reason");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_staff');
       echo "
       <h3>Gang Management: Staff</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_capacity()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />> <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $capacity =
           (isset($_POST['capacity']) && is_numeric($_POST['capacity']))
                   ? abs(intval($_POST['capacity'])) : '';
   $reason =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangCAPACITY`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $reason && $capacity)
   {
       staff_csrf_stdverify('staff_gangs_edit_capacity',
               "staff_gangs.php?action=gedit_capacity&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangCAPACITY` = $capacity
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add(
               "{$ir['username']} edited gang ID $gang's capacity with the reason $reason");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_capacity');
       echo "
       <h3>Gang Management: Capacity</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_crime()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />
       > <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : 0;
   $crime =
           (isset($_POST['crime']) && is_numeric($_POST['crime']))
                   ? abs(intval($_POST['crime'])) : '';
   $chours =
           (isset($_POST['chours']) && is_numeric($_POST['chours']))
                   ? abs(intval($_POST['chours'])) : '';
   $reason =
           (isset($_POST['reason'])
                   && preg_match(
                           "/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                           $_POST['reason']))
                   ? $db->escape(strip_tags(stripslashes($_POST['reason'])))
                   : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangCRIME`, `gangCHOURS`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $reason && $crime && $chours)
   {
       staff_csrf_stdverify('staff_gangs_edit_crime',
               "staff_gangs.php?action=gedit_crime&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangCRIME` = $crime, `gangCHOURS` = $chours
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add(
               "{$ir['username']} edited gang ID $gang's organised crime with the reason $reason");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_crime');
       echo "
       <h3>Gang Management: Organised Crimes</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}

function admin_gang_edit_ament()
{
   global $db, $ir, $userid, $h, $c;
   if (!in_array($ir['user_level'], array(2, 3)))
   {
       echo 'You cannot access this area.<br />> <a href="index.php">Go Back</a>';
       die($h->endpage());
   }
   $gang =
           (isset($_GET['gang']) && is_numeric($_GET['gang']))
                   ? abs(intval($_GET['gang'])) : '';
   $_POST['gangAMENT'] =
           (isset($_POST['gangAMENT']))
                   ? $db->escape(
                           strip_tags(stripslashes($_POST['gangAMENT']))) : '';
   $q =
           $db->query(
                   "SELECT `gangNAME`, `gangAMENT`
                    FROM `gangs`
                    WHERE `gangID` = $gang");
   if ($db->num_rows($q) == 0)
   {
       $db->free_result($q);
       echo 'Invalid gang.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       die($h->endpage());
   }
   $r = $db->fetch_row($q);
   $db->free_result($q);
   if ($gang && $_POST['gangAMENT'])
   {
       staff_csrf_stdverify('staff_gangs_edit_ament',
               "staff_gangs.php?action=gedit_ament&gang={$gang}");
       $db->query(
               "UPDATE `gangs`
                SET `gangAMENT` = '{$_POST['gangAMENT']}'
                WHERE `gangID` = $gang");
       echo 'Gang has been successfully modified.<br />
       > <a href="staff_gangs.php?action=gedit">Go Back</a>';
       stafflog_add("{$ir['username']} edited gang ID $gang's announcement");
       die($h->endpage());
   }
   else
   {
       $csrf = request_csrf_html('staff_gangs_edit_ament');
       echo "
       <h3>Gang Management: Announcement</h3>
       Editing the gang: {$r['gangNAME']}<br />
       <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'>
                       {$csrf}
                       <input type='submit' value='Edit' />
                   </td>
       		</tr>
       </table>
       </form>
          ";
   }
}
function create_oc_form()
{
global $db,$ir,$c,$h,$userid;
if($ir['user_level'] != 2)
{
die("403");
}
print "
<form action='staff_gangs.php?action=createocsub' method='POST'>
<h4>Create OC</h4>
Name: <input type='text' name='ocNAME'/>

Minimum users for crime: <input type='text' name='ocUSERS'/>

Text: <textarea rows=4 cols=40 name='ocSTARTTEXT'  /></textarea>

Success Text: <textarea rows=4 cols=40 name='ocSUCCTEXT'  /></textarea>

Failure Text <textarea rows=4 cols=40 name='ocFAILTEXT'  /></textarea>

Minimum Possible Money <input type='text' name='ocMINMONEY'/>

Maximum Possible Money <input type='text' name='ocMAXMONEY'/>

Respect Gain <input type='text' name='ocRESPECT'/>

<input type='submit' value='Create' />
</form>";
}
function create_oc_sub()
{
global $ir,$c,$userid,$db,$h;
if($ir['user_level'] != 2)
{
die("403");
}
$db->query("INSERT INTO orgcrimes VALUES('', '{$_POST['ocNAME']}', '{$_POST['ocUSERS']}', '{$_POST['ocSTARTTEXT']}', '{$_POST['ocSUCCTEXT']}', '{$_POST['ocFAILTEXT']}', '{$_POST['ocMINMONEY']}', '{$_POST['ocMAXMONEY']}')");
print "
The organised crime was successfully created.
<a href='staff_gangs.php?action=createoc'>Back</a>

";
stafflog_add("Created Organise Crime: {$_POST['ocNAME']}");
}
$h->endpage();
?>

Newbie · August 22, 2012

ok i replaced my gangs.php and staff_gangs.php with your code and everything is working fine i can set up gang crimes from staff menu in yourgang.php

You have started to plan this crime. It will take 24 hours.

if its not showing up i would go back and check the orgcrimes table ill post it below if you dont have

CREATE TABLE IF NOT EXISTS `orgcrimes` (
 `ocID` int(11) NOT NULL AUTO_INCREMENT,
 `ocNAME` varchar(255) NOT NULL DEFAULT '',
 `ocUSERS` int(11) NOT NULL DEFAULT '0',
 `ocSTARTTEXT` text NOT NULL,
 `ocSUCCTEXT` text NOT NULL,
 `ocFAILTEXT` text NOT NULL,
 `ocMINMONEY` int(11) NOT NULL DEFAULT '0',
 `ocMAXMONEY` int(11) NOT NULL DEFAULT '0',
 PRIMARY KEY (`ocID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `orgcrimes` (`ocID`, `ocNAME`, `ocUSERS`, `ocSTARTTEXT`, `ocSUCCTEXT`, `ocFAILTEXT`, `ocMINMONEY`, `ocMAXMONEY`) VALUES
(1, 'Rob a Bank', 1, '1. You head out and get your crew.<br />\r\n2. You move towards the bank with your mask on.<br />\r\n3. You storm the bank with your crew.', '<font color=green>You Succeeded</font>', '<font color=red>you failed</font>', 1000, 5000);

Raven1992 · August 22, 2012

ok it works it didn't have the mysql stuff for it thanks newbie for that

Tangled · October 10, 2014

I followed the instructions give here and it helped...but there's no way to tell how many crimes are needed. And there's no event to say a gang crime has started or ended.

Also could someone tell me how to add different types of things for the gang to do like instead of crimes say the had to do so many mugs or busts or attacks.

NonStopCoding · October 10, 2014

well its been a bit since i have looked into mccodes but i guess you would need to add a new field to the gangs table called mugs or whatever then in the mug file add something like

if($ir['gang'] > 0) {
   $check = $db->query("SELECT `something` FROM `gangtable` WHERE `something` = {$ir['gang']}");
   $ret = $db->fetch_row($check);
   // if attack is successfull
   $update = $db->query("UPDATE `gangtable` SET `mugs` = `mugs` + 1 WHERE `something` = {$ir['gang']}");
}

there is probz better way of doing it but off the top of my head

Sign In

Organised Crimes Not showing in Gangs

Recommended Posts

Raven1992

Link to comment

Share on other sites

Newbie

Link to comment

Share on other sites

Raven1992

Link to comment

Share on other sites

Newbie

Link to comment

Share on other sites

Raven1992

Link to comment

Share on other sites

Tangled

Link to comment

Share on other sites

NonStopCoding

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Hosting

Marketplace