Jump to content
MakeWebGames

Recommended Posts

Posted

I put this in to try to edit crimes under admin panel

<u>Crimes</u>

[Create New Crime]

[Edit Crime]

[Delete Crime]

[Create New Crimegroup]

[Edit Crimegroup]

[Delete Crimegroup]

 

and this to edit them but i cannot get them working i get the error

Fatal error: Call to undefined function crimegroup_dropdown() in /home/gangstas/public_html/admin.php on line 960

 

function new_crime_form()

{

global $ir, $c;

print "Adding a new crime.

<form action='admin.php?action=newcrimesub' method='post'>

Crime Name: <input type='text' name='crimeNAME' />

Crime Brave Cost: <input type='text' name='crimeBRAVE' />

Crime PERCFORM: <input type='text' name='crimePERCFORM' value='((WILL*0.8)/2.5)+(LEVEL/4)' />

Success Money: <input type='text' name='crimeSUCCESSMUNY' />

Crime Group: ".crimegroup_dropdown($c,'crimeGROUP')."

CrimeITEXT: <textarea rows=4 cols=40 name='crimeITEXT' /></textarea>

Crime Success TEXT: <textarea rows=4 cols=40 name='crimeSTEXT' /></textarea>

Crime Failure TEXT: <textarea rows=4 cols-40 name='crimeFTEXT' /></textarea>

crime ITEM Number(0 for none): <input type='text' name='crimeITEM' value='0' />

<input type='submit' value='Create Crime' /></form>";

}

function new_crime_submit()

{

global $ir,$c,$userid;

if(!isset($_POST['crimeNAME']) || !isset($_POST['crimeBRAVE']) || !isset($_POST['crimePERCFORM']) || !isset($_POST['crimeSUCCESSMUNY']) || !isset($_POST['crimeGROUP']) || !isset($_POST['crimeITEXT']) || !isset($_POST['crimeSTEXT']) || !isset($_POST['crimeFTEXT']))

{

print "You missed one or more of the required fields. Please go back and try again.

> Back";

$h->endpage();

exit;

}

mysql_query("INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeITEM) VALUES( '{$_POST['crimeNAME']}', '{$_POST['crimeBRAVE']}', '{$_POST['crimePERCFORM']}', '{$_POST['crimeSUCCESSMUNY']}', '{$_POST['crimeGROUP']}', '{$_POST['crimeITEXT']}', '{$_POST['crimeSTEXT']}', '{$_POST['crimeFTEXT']}', '{$_POST['crimeITEM']}')", $c);

print "Crime created!";

}

function edit_crime_begin()

{

global $ir,$c,$h,$userid;

print "<h3>Editing Crime</h3>

You can edit any aspect of this crime.

<form action='admin.php?action=editcrimeform' method='post'>

Crime: ".crime_dropdown($c,'crime')."

<input type='submit' value='Edit Crime' /></form>";

}

function edit_crime_form()

{

global $ir,$c,$h,$userid;

$d=mysql_query("SELECT * FROM crimes WHERE crimeID={$_POST['crime']}",$c);

$itemi=mysql_fetch_array($d);

print "<h3>Editing Crime</h3>

<form action='admin.php?action=editcrimesub' method='post'>

<input type='hidden' name='crimeID' value='{$_POST['crime']}' />

Crime Name: <input type='text' name='crimeNAME' value='{$itemi['crimeNAME']}' />

Crime Brave Cost: <input type='text' name='crimeBRAVE' value='{$itemi['crimeBRAVE']}' />

Crime PERCFORM: <input type='text' name='crimePERCFORM' value='{$itemi['crimePERCFORM']}' />

Success Money: <input type='text' name='crimeSUCCESSMUNY' value='{$itemi['crimeSUCCESSMUNY']}' />

Crime Group: ".crimegroup_dropdown($c,'crimeGROUP')."

CrimeITEXT: <textarea rows=4 cols=40 name='crimeITEXT' />'{$itemi['crimeITEXT']}'</textarea>

Crime Success TEXT: <textarea rows=4 cols=40 name='crimeSTEXT' />'{$itemi['crimeSTEXT']}'</textarea>

Crime Failure TEXT: <textarea rows=4 cols-40 name='crimeFTEXT' />'{$itemi['crimeFTEXT']}' </textarea>

crime ITEM Number(0 for none): <input type='text' name='crimeITEM' value='{$itemi['crimeITEM']}' />

<input type='submit' value='Edit Crime' /></form>";

}

function edit_crime_sub()

{

global $ir,$c,$h,$userid;

if(!isset($_POST['crimeNAME']) || !isset($_POST['crimeBRAVE']) || !isset($_POST['crimePERCFORM']) || !isset($_POST['crimeSUCCESSMUNY']) || !isset($_POST['crimeGROUP']) || !isset($_POST['crimeITEXT']) || !isset($_POST['crimeSTEXT']) || !isset($_POST['crimeFTEXT']))

{

print "You missed one or more of the required fields. Please go back and try again.

> Back";

$h->endpage();

exit;

}

else

{

$oq=mysql_query("SELECT * FROM crimes WHERE crimeID={$_POST['crimeID']}",$c);

$rm=mysql_fetch_array($oq);

mysql_query("UPDATE crimes SET crimeNAME='{$_POST['crimeNAME']}', crimeBRAVE='{$_POST['crimeBRAVE']}', crimePERCFORM='{$_POST['crimePERCFORM']}', crimeSUCCESSMUNY='{$_POST['crimeSUCCESSMUNY']}', crimeGROUP='{$_POST['crimeGROUP']}', crimeITEXT='{$_POST['crimeITEXT']}', crimeSTEXT='{$_POST['crimeSTEXT']}', crimeFTEXT='{$_POST['crimeFTEXT']}', crimeITEM='{$_POST['crimeITEM']}' WHERE crimeID={$_POST['crimeID']}", $c) or die(mysql_error());

print "Crime edited...";

}

}

function delcrime()

{

global $ir,$c,$h,$userid;

switch ($_GET['step'])

{

default:

echo "<h3>Deleting Crimes</h3>

Here you can delete a crime.

<form action='admin.php?action=delcrime&step=2' method='post'>

Crime: ".crime_dropdown($c,'crime')."

<input type='submit' value='Delete Crime' /></form>";

break;

case 2:

$target = $_POST['crime'];

$d=mysql_query("SELECT crimeNAME FROM crimes WHERE crimeID='$target'") or die(mysql_error());

$itemi=mysql_fetch_array($d);

print "<h3>Confirm</h3>

Delete crime - ".$itemi[0]."?

<form action='admin.php?action=delcrime&step=3' method='post'>

<input type='hidden' name='crimeID' value='$target' />

<input type='submit' name='yesorno' value='Yes' />

<input type='submit' name='yesorno' value='No' onclick=\"window.location='admin.php';\" /></form>";

break;

case 3:

$target = $_POST['crimeID'];

if($_POST['yesorno']=='No')

{

die("Crime not deleted.

>Back to main admin page.");

}

if ($_POST['yesorno'] != ("No" || "Yes")) die('Eh');

mysql_query("DELETE FROM crimes WHERE crimeID='$target'") or die(mysql_error());

echo "Crime Deleted.

>Back to main admin page.";

break;

}

}

function new_crimegroup_form()

{

global $ir, $c;

print "Adding a new crimegroup.

<form action='admin.php?action=newcrimegroupsub' method='post'>

Crimegroup Name: <input type='text' name='cgNAME' />

Crimegroup Order Number: <input type='text' name='cgORDER' />

<input type='submit' value='Create CrimeGroup' /></form>";

}

function new_crimegroup_submit()

{

global $ir,$c,$userid;

if(!isset($_POST['cgNAME']) || !isset($_POST['cgORDER']))

{

print "You missed one or more of the required fields. Please go back and try again.

> Back";

$h->endpage();

exit;

}

$res = mysql_query("INSERT INTO `crimegroups` (`cgNAME`, `cgORDER`) VALUES('".$_POST["cgNAME"]."','".$_POST["cgORDER"]."')");

if (!$res) { die('error: '.mysql_error()); }

print "Crimegroup created!";

}

function edit_crimegroup_begin()

{

global $ir,$c,$h,$userid;

print "<h3>Editing Crimegroups</h3>

Edit Crimegroups here.

<form action='admin.php?action=editcrimegroupform' method='post'>

Crimegroup: ".crimegroup_dropdown($c,'crimeGROUP')."

<input type='submit' value='Edit Crimegroup' /></form>";

}

function edit_crimegroup_form()

{

global $ir,$c,$h,$userid;

$d=mysql_query("SELECT * FROM crimegroups WHERE cgID={$_POST['crimeGROUP']}",$c);

$itemi=mysql_fetch_array($d);

print "<h3>Editing CrimeGroup</h3>

<form action='admin.php?action=editcrimegroupsub' method='post'>

<input type='hidden' name='cgID' value='{$_POST['crimeGROUP']}' />

Crimegroup Name: <input type='text' name='cgNAME' value='{$itemi['cgNAME']}' />

Crimegroup Order Number: <input type='text' name='cgORDER' value='{$itemi['cgORDER']}' />

<input type='submit' value='Edit CrimeGroup' /></form>";

}

function edit_crimegroup_sub()

{

global $ir,$c,$h,$userid;

if(!isset($_POST['cgORDER']) || !isset($_POST['cgNAME']))

{

print "You missed one or more of the required fields. Please go back and try again.

> Back";

$h->endpage();

exit;

}

else

{

$oq=mysql_query("SELECT * FROM crimegroups WHERE cgID={$_POST['cgID']}",$c);

$rm=mysql_fetch_array($oq);

mysql_query("UPDATE crimegroups SET cgNAME='".$_POST['cgNAME']."', cgORDER='".$_POST['cgORDER']."' WHERE cgID='{$_POST['cgID']}'", $c) or die(mysql_error());

print "Crimegroup edited...";

}

}

function delcrimegroup()

{

global $ir,$c,$h,$userid;

switch ($_GET['step'])

{

default:

echo "<h3>Deleting Crimegroups</h3>

Here you can delete a crimegroup.

<form action='admin.php?action=delcrimegroup&step=2' method='post'>

Crimegroup: ".crimegroup_dropdown($c,'crimeGROUP')."

<input type='submit' value='Delete Crimegroup' /></form>";

break;

case 2:

$target = $_POST['crimeGROUP'];

$d=mysql_query("SELECT cgNAME FROM crimegroups WHERE cgID='$target'") or die(mysql_error());

$itemi=mysql_fetch_array($d);

print "<h3>Confirm</h3>

Delete crimegroup - ".$itemi[0]."?

<form action='admin.php?action=delcrimegroup&step=3' method='post'>

<input type='hidden' name='cgID' value='$target' />

<input type='submit' name='yesorno' value='Yes' />

<input type='submit' name='yesorno' value='No' onclick=\"window.location='admin.php';\" /></form>";

break;

case 3:

$target = $_POST['crimeID'];

if($_POST['yesorno']=='No')

{

die("Crimegroup not deleted.

>Back to main admin page.");

}

if ($_POST['yesorno'] != ("No" || "Yes")) die('Eh');

mysql_query("DELETE FROM crimegroups WHERE cgID='{$_POST['cgID']}'") or die(mysql_error());

echo "Crimegroup Deleted.

>Back to main admin page.";

break;

 

now this is 960

Crime Group: ".crimegroup_dropdown($c,'crimeGROUP')."

 

if anyone can help me i would greatly appreciate it

Posted

Re: Crimes

First of all your global_func.php requires a dropdown for crimes. Here it is:

Add the code below to your global_func.php

 

function crimegroup_dropdown($connection,$ddname="crimegroup",$selected=-1)
{
$ret="<select name='$ddname' type='dropdown'>";
$q=mysql_query("SELECT * FROM crimegroups   ORDER BY cgNAME ASC");
if($selected == -1) { $first=0; } else { $first=1; }
while($r=mysql_fetch_assoc($q))
{
$ret.="\n<option value='{$r['cgID']}'";
if ($selected == $r['cgID'] || $first == 0) { $ret.=" selected='selected'";$first=1; } 
$ret.=">{$r['cgNAME']}</option>";
}
$ret.="\n</select>";
return $ret;
}

 

if that dont work then its ur fault that you never put this code in right.

Posted

Re: Crimes

mysql_query = v1

$db->query = v2

This is not always the case thought but on unedited codes it is so this looks v1 to me i have not read your post so unable to help sorry.

reply to zeon's post below this...

i posted explaining why v2....

No i didnt buy version 2? why is that the v2 code?

Guest Anonymous
Posted

Re: Crimes

 

mysql_query = v1

$db->query = v2

 

 

I don't think it even makes a huge difference.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...