Delete

Jesse60905 · February 3, 2008

Re: Delete

Much better... Suggestion. Don't run that query I posted...

Open your staff_users.php file and run a search & replace. Find: int Replace With: float

Then in your users and userstats db replace all the int with bigint and all the 11's with 20.

Criminal · February 3, 2008

Re: Delete

I copyed all the file on notepad wot is it ctrl to find it

ignite · February 3, 2008

Re: Delete

I would love t see your game, it sounds very advance

Jesse60905 · February 3, 2008

Re: Delete

Just hit edit & search and replace...

Criminal · February 3, 2008

Re: Delete

<?php

include "sglobals.php";

//This contains user stuffs

switch($_GET['action'])

{

case 'newuser': new_user_form(); break;

case 'newusersub': new_user_submit(); break;

case 'edituser': edit_user_begin(); break;

case 'edituserform': edit_user_form(); break;

case 'editusersub': edit_user_sub(); break;

case 'invbeg': inv_user_begin(); break;

case 'invuser': inv_user_view(); break;

case 'deleinv': inv_delete(); break;

case 'creditform': credit_user_form(); break;

case 'creditsub': credit_user_submit(); break;

case 'masscredit': mcredit_user_form(); break;

case 'masscreditsub': mcredit_user_submit(); break;

case 'reportsview': reports_view(); break;

case 'repclear': report_clear(); break;

case 'deluser': deluser(); break;

case 'forcelogout': forcelogout(); break;

default: print "Error: This script requires an action."; break;

}

function htmlspcl($in)

{

return str_replace("'", "'", htmlspecialchars($in));

}

function new_user_form()

{

global $db,$ir, $c;

if($ir['user_level'] != 2)

{

die("403");

}

print "Adding a new user.

Username: <input type='text' name='username' />

Login Name: <input type='text' name='login_name' />

Email: <input type='text' name='email' />

Password: <input type='text' name='userpass' />

Type: <input type='radio' name='user_level' value='0' />NPC <input type='radio' name='user_level' value='1' checked='checked' />Regular Member

Level: <input type='text' name='level' value='1' />

Money: <input type='text' name='money' value='100' />

Crystals: <input type='text' name='crystals' value='0' />

Donator Days: <input type='text' name='donatordays' value='0' />

Gender: <select name='gender' type='dropdown'><option>Male</option><option>Female</option></select>

Stats

Strength: <input type='text' name='strength' value='10' />

Agility: <input type='text' name='agility' value='10' />

Guard: <input type='text' name='guard' value='10' />

Labour: <input type='text' name='labour' value='10' />

IQ: <input type='text' name='labour' value='10' />

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

}

function new_user_submit()

{

global $db,$ir,$c,$userid;

if($ir['user_level'] != 2)

{

die("403");

}

if(!isset($_POST['username']) || !isset($_POST['login_name']) || !isset($_POST['userpass']))

{

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

> Back";

$h->endpage();

exit;

}

$level=abs((float) $_POST['level']);

$money=abs((float) $_POST['money']);

$crystals=abs((float) $_POST['crystals']);

$donator=abs((float) $_POST['donatordays']);

$ulevel=abs((float) $_POST['user_level']);

$strength=abs((float) $_POST['strength']);

$agility=abs((float) $_POST['agility']);

$guard=abs((float) $_POST['guard']);

$labour=abs((float) $_POST['labour']);

$iq=abs((int) $_POST['iq']);

$energy=10+$level*2;

$brave=3+$level*2;

$hp=50+$level*50;

$db->query("INSERT INTO users (username, login_name, userpass, level, money, crystals, donatordays, user_level, energy, maxenergy, will, maxwill, brave, maxbrave, hp, maxhp, location, gender, signedup, email, bankmoney) VALUES( '{$_POST['username']}', '{$_POST['login_name']}', md5('{$_POST['userpass']}'), $level, $money, $crystals, $donator, $ulevel, $energy, $energy, 100, 100, $brave, $brave, $hp, $hp, 1, '{$_POST['gender']}', unix_timestamp(), '{$_POST['email']}', -1)");

$i=mysql_insert_id($c);

$db->query("INSERT INTO userstats VALUES($i, $strength, $agility, $guard, $labour, $iq)");

print "User created!";

stafflog_add("Created user {$_POST['username']} [$i]");

}

function edit_user_begin()

{

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

if($ir['user_level'] != 2)

{

die("403");

}

print "<h3>Editing User</h3>

You can edit any aspect of this user.

User: ".user_dropdown($c,'user')."

OR enter a user ID to edit:

User: <input type='text' name='user' value='0' />

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

}

function edit_user_form()

{

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

if($ir['user_level'] != 2)

{

die("403");

}

$d=$db->query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us on u.userid=us.userid WHERE u.userid={$_POST['user']}");

$itemi=$db->fetch_row($d);

$itemi['hospreason']=htmlspcl($itemi['hospreason']);

$itemi['jail_reason']=htmlspcl($itemi['jail_reason']);

print "<h3>Editing User</h3>

Username: <input type='text' name='username' value='{$itemi['username']}' />

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

Duties: <input type='text' name='duties' value='{$itemi['duties']}' />

Staff Notes: <input type='text' name='staffnotes' value='{$itemi['staffnotes']}' />

Level: <input type='text' name='level' value='{$itemi['level']}' />

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

Bank: \$<input type='text' name='bankmoney' value='{$itemi['bankmoney']}' />

Cyber Bank: \$<input type='text' name='cybermoney' value='{$itemi['cybermoney']}' />

Crystals: <input type='text' name='crystals' value='{$itemi['crystals']}' />

Mail Ban: <input type='text' name='mailban' value='{$itemi['mailban']}' />

Mail Ban Reason: <input type='text' name='mb_reason' value='{$itemi['mb_reason']}' />

Forum Ban: <input type='text' name='forumban' value='{$itemi['forumban']}' />

Forum Ban Reason: <input type='text' name='fb_reason' value='{$itemi['fb_reason']}' />

Hospital time: <input type='text' name='hospital' value='{$itemi['hospital']}' />

Hospital reason: <input type='text' name='hospreason' value='{$itemi['hospreason']}' />

Jail time: <input type='text' name='jail' value='{$itemi['jail']}' />

Jail reason: <input type='text' name='jail_reason' value='{$itemi['jail_reason']}' />

House: ".house2_dropdown($c, "maxwill", $itemi['maxwill'])."

<h4>Stats</h4>

Strength: <input type='text' name='strength' value='{$itemi['strength']}' />

Agility: <input type='text' name='agility' value='{$itemi['agility']}' />

Guard: <input type='text' name='guard' value='{$itemi['guard']}' />

Labour: <input type='text' name='labour' value='{$itemi['labour']}' />

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

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

}

function edit_user_sub()

{

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

if($ir['user_level'] != 2)

{

die("403");

}

$go=0;

if(!isset($_POST['level'])) { $go=1; }

if(!isset($_POST['money'])) { $go=1; }

if(!isset($_POST['bankmoney'])) { $go=1; }

if(!isset($_POST['crystals'])) { $go=1; }

if(!isset($_POST['strength'])) { $go=1; }

if(!isset($_POST['agility'])) { $go=1; }

if(!isset($_POST['guard'])) { $go=1; }

if(!isset($_POST['labour'])) { $go=1; }

if(!isset($_POST['IQ'])) { $go=1; }

if(!isset($_POST['username'])) { $go=1; }

if(!isset($_POST['login_name'])) { $go=1; }

if($go)

{

print "You did not fully fill out the form.";

$_POST['user']=$_POST['userid'];

edit_user_form();

}

else

{

$_POST['level']=(int) $_POST['level'];

$_POST['strength']=abs((int) $_POST['strength']);

$_POST['agility']=abs((int) $_POST['agility']);

$_POST['guard']=abs((int) $_POST['guard']);

$_POST['labour']=abs((int) $_POST['labour']);

$_POST['IQ']=abs((int) $_POST['IQ']);

$_POST['money']=(int) $_POST['money'];

$_POST['bankmoney']=(int) $_POST['bankmoney'];

$_POST['cybermoney']=(int) $_POST['cybermoney'];

$_POST['crystals']=(int) $_POST['crystals'];

$_POST['mailban']=(int) $_POST['mailban'];

$_POST['forumban']=(int) $_POST['forumban'];

$maxwill=abs((int) $_POST['maxwill']);

//check for username usage

$u=$db->query("SELECT * FROM users WHERE username='{$_POST['username']}' and userid != {$_POST['userid']}");

if($db->num_rows($u) != 0)

{

print "That username is in use, choose another.";

print "

> Back";

$h->endpage();

exit;

}

$oq=$db->query("SELECT * FROM users WHERE userid={$_POST['userid']}");

$rm=$db->fetch_row($oq);

$will=($rm['will'] > $maxwill) ? $maxwill: $rm['will'];

$energy=10+$_POST['level']*2;

$nerve=3+$_POST['level']*2;

$hp=50+$_POST['level']*50;

$db->query("UPDATE users SET username='{$_POST['username']}', level={$_POST['level']}, money={$_POST['money']}, crystals={$_POST['crystals']}, energy=$energy, brave=$nerve, maxbrave=$nerve, maxenergy=$energy, hp=$hp, maxhp=$hp, hospital={$_POST['hospital']}, jail={$_POST['jail']}, duties='{$_POST['duties']}', staffnotes='{$_POST['staffnotes']}', mailban={$_POST['mailban']}, mb_reason='{$_POST['mb_reason']}', forumban={$_POST['forumban']}, fb_reason='{$_POST['fb_reason']}', hospreason='{$_POST['hospreason']}', jail_reason='{$_POST['jail_reason']}', login_name='{$_POST['login_name']}', will=$will, maxwill=$maxwill WHERE userid={$_POST['userid']}");

$db->query("UPDATE userstats SET strength={$_POST['strength']}, agility={$_POST['agility']}, guard={$_POST['guard']}, labour={$_POST['labour']}, IQ={$_POST['IQ']} WHERE userid={$_POST['userid']}");

stafflog_add("Edited user {$_POST['username']} [{$_POST['userid']}]");

print "User edited....";

} }

function deluser()

{

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

if($ir['user_level'] != 2)

{

die("403");

}

$undeletable = array('1','2'); // add more IDs here, such as NPCs

switch ($_GET['step'])

{

default:

echo "<h3>Deleteing User</h3>

Here you can delete a user.

User: ".user_dropdown($c,'user')."

OR enter a user ID to Delete:

User: <input type='text' name='user' value='0' />

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

break;

case 2:

$target = $_POST['user'];

if (!is_numeric($target)) exit;

if (in_array($target,$undeletable)) {

die('You cannot delete this person.');

}

$d=$db->query("SELECT username FROM users WHERE userid='$target'");

$itemi=$db->fetch_row($d);

print "<h3>Confirm</h3>

Delete user ".$itemi["username"]."?

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

break;

case 3:

$target = $_POST['userid'];

if (!is_numeric($target)) exit;

if (in_array($target,$undeletable)) {

die('You cannot delete this person.');

}

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

{

die("User not deleted.

>Back to main Delete Users page.");

}

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

$d=$db->query("SELECT username FROM users WHERE userid='$target'");

$itemi=$db->fetch_row($d);

$db->query("DELETE FROM users WHERE userid='$target'");

$db->query("DELETE FROM userstats WHERE userid='$target'");

$db->query("DELETE FROM inventory WHERE inv_userid='$target'");

$db->query("DELETE FROM fedjail WHERE fed_userid='$target'");

echo "User {$itemi['username']} Deleted.

>Back to main Delete Users page.";

stafflog_add("Deleted User {$itemi['username']} [{$_POST['userid']}]");

break;

}

function inv_user_begin()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

print "<h3>Viewing User Inventory</h3>

You may browse this user's inventory.

User: ".user_dropdown($c,'user')."

<input type='submit' value='View Inventory' /></form>";

}

function inv_user_view()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

$d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'");

$un=$db->fetch_single($d);

$inv=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_userid={$_POST['user']}");

if ($db->num_rows($inv) == 0)

{

print "This person has no items!";

}

else

{

print "Their items are listed below.

<table width=100%><tr style='background-color:gray;'><th>Item</th><th>Sell Value</th><th>Total Sell Value</th><th>Links</th></tr>";

while($i=$db->fetch_row($inv))

{

print "<tr><td>{$i['itmname']}";

if ($i['inv_qty'] > 1)

{

print " x{$i['inv_qty']}";

}

print "</td><td>\${$i['itmsellprice']}</td><td>";

print "$".($i['itmsellprice']*$i['inv_qty']);

print "</td><td>[Delete]";

print "</td></tr>";

}

print "</table>";

}

stafflog_add("Viewed user {$un} [{$_POST['user']}] inventory");

}

function inv_delete()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

$db->query("DELETE FROM inventory WHERE inv_id={$_GET['ID']}");

print "Item deleted from inventory.";

stafflog_add("Deleted inventory ID {$_GET['ID']}");

}

function credit_user_form()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

print "<h3>Crediting User</h3>

You can give a user money/crystals.

User: ".user_dropdown($c,'user')."

Money: <input type='text' name='money' /> Crystals: <input type='text' name='crystals' />

<input type='submit' value='Credit User' /></form>";

}

function credit_user_submit()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

$_POST['money'] = (float) $_POST['money'];

$_POST['crystals'] = (float) $_POST['crystals'];

$db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']} WHERE u.userid={$_POST['user']}");

print "User credited.";

$d=$db->query("SELECT username FROM users WHERE userid='{$_POST['user']}'");

$un=$db->fetch_single($d);

stafflog_add("Credited $un [{$_POST['user']}] \${$_POST['money']} and/or {$_POST['crystals']} crystals.");

}

function mcredit_user_form()

{

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

if($ir['user_level'] > 2)

{

die("403");

}

print "<h3>Mass Payment</h3>

You can give all users money/crystals.

Money: <input type='text' name='money' /> Crystals: <input type='text' name='crystals' />

<input type='submit' value='Credit User' /></form>";

}

function mcredit_user_submit()

{

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

if($ir['user_level'] > 2)

{

die("403");

}

$_POST['money'] = (int) $_POST['money'];

$_POST['crystals'] = (int) $_POST['crystals'];

$db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']}");

print "All Users credited. Click here to add an announcement or here to send a mass mail explaining why.";

stafflog_add("Credited all users \${$_POST['money']} and/or {$_POST['crystals']} crystals.");

}

function reports_view()

{

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

if($ir['user_level'] > 3)

{

die("403");

}

print "<h3>Player Reports</h3>

<table width=80%><tr style='background:gray'><th>Reporter</th> <th>Offender</th> <th>What they did</th> <th> </th> </tr>";

$q=$db->query("SELECT pr.*,u1.username as reporter, u2.username as offender FROM preports pr LEFT JOIN users u1 ON u1.userid=pr.prREPORTER LEFT JOIN users u2 ON u2.userid=pr.prREPORTED ORDER BY pr.prID DESC");

while($r=$db->fetch_row($q))

{

print "\n<tr> <td>{$r['reporter']} [{$r['prREPORTER']}]</td> <td>{$r['offender']} [{$r['prREPORTED']}]</td> <td>{$r['prTEXT']}</td> <td>Clear</td> </tr>";

}

print "</table>";

}

function forcelogout()

{

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

if($ir['user_level'] > 2)

{

die("403");

}

$_POST['userid'] = abs((int) $_POST['userid']);

if($_POST['userid'])

{

$db->query("UPDATE users SET force_logout=1 WHERE userid={$_POST['userid']}");

print "User ID {$_POST['userid']} successfully forced to logout.";

stafflog_add("Forced User ID {$_POST['userid']} to logout");

}

else

{

print "<h3>Force User Logout</h3><hr />

The user will be automatically logged out next time he/she makes a hit to the site.<form action='staff_users.php?action=forcelogout' method='post'>

User: ".user_dropdown($c, 'userid')."

<input type='submit' value='Force User to Logout' /></form>";

}

function report_clear()

{

global $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!

> Back";

}

$h->endpage();

?>

is that ok

Criminal · February 3, 2008

Re: Delete

I GOT IT SORTED

Godhand · February 4, 2008

Re: Delete

pft in the database all you had to do was change int (21) into big int(92)

and in the corresponding files change (int) into (float)

Redeye · February 4, 2008

Re: Delete

pft in the database all you had to do was change int (21) into big int(92)

and in the corresponding files change (int) into (float)

Why would you need it big int(92)...

Why not just something like big int(50)

Otherwise the economy would be like wooooooof

Magictallguy · February 5, 2008

Re: Delete

Yea, like he cares...His game is gonna be pretty crap anyway... And badboy, next time you post code, can you encase it in the BBCode [ code ] tags please. I'm sick of scrolling through almost an A3 sheet!

Godhand · February 6, 2008

Re: Delete

Well I was predicting his game was going to rapidly increase and I was saving him the hassle of having to expand it. I know I haven't ran past it in my game yet for big int(50) but... I know some games 1 trillion $ is not very much much similar to $1 for a level 1 in a game that has balanced economy. With over 2.xx bill in his game and stats I'm sure within 3 months it will boom on up.

BlatantDude · February 6, 2008

Re: Delete

Whats his domain ?

POG1 · February 6, 2008

Re: Delete

Yea, like he cares...His game is gonna be pretty crap anyway... And badboy, next time you post code, can you encase it in the BBCode [ code ] tags please. I'm sick of scrolling through almost an A3 sheet!

magicaltallguy. wasnt you helping dazzer on banburyco? im creating a game called banburyco with him now :P

February 6, 2008

Re: Delete

cba looking its ok if sum posts it here thnx

Seriously with an attitude like that I dont know how you can expect people to help you...or intend to run a game...

Criminal · February 6, 2008

Re: Delete

My site

http://gangsta-city.890m.com/login.php

Vorlen · February 6, 2008

Re: Delete

cba looking its ok if sum posts it here thnx

Seriously with an attitude like that I dont know how you can expect people to help you...or intend to run a game...

Beat me to the punch line Scarlet! :lol:

P.S. In any game I've ever done, Bigint 20 was sufficient... What number would 92 get? Seriously that's massive, and pointless...

YoungGold · February 6, 2008

Re: Delete

cba looking its ok if sum posts it here thnx

Seriously with an attitude like that I dont know how you can expect people to help you...or intend to run a game...

Beat me to the punch line Scarlet! :lol:

P.S. In any game I've ever done, Bigint 20 was sufficient... What number would 92 get? Seriously that's massive, and pointless...

Exactly what i was thinkinh if your game has already hit that mark of money and stats you have a problem...i would expect to see that after a game has run for 1 year minimum or you have some bloomin gd donaters...i mean come on.....whats the point in a game if its going to be trashed and capped out on everything...in 2 days :/

BlatantDude · February 6, 2008

Re: Delete

My site

http://gangsta-city.890m.com/login.php

Thanks !

BlatantDude · February 6, 2008

Re: Delete

Thats MCCodes V2.. Why are you still on a free host ?

YoungGold · February 6, 2008

Re: Delete

if you can afford v2 codes ($300) then you can afford a paid hosting service not a free host...my conclusion probably illegal codes..

BlatantDude · February 6, 2008

Re: Delete

More than likely is..

Criminal · February 6, 2008

Re: Delete

You tell me Why buy a cpanel if you not a fully coder and cant do some stuff once i learn php coding then i will buy .com but now am starting of wid free host to start gettings use to the codes and by testing them on free host instead buying a proper domain happy!!!!!!!!!!!!1 :wink:

BlatantDude · February 6, 2008

Re: Delete

Not really i don't really beleive that :? But thats just my opinion..

Godhand · February 6, 2008

Re: Delete

That is the point of using lite to get the ropes on a free host. I know my newest project is to notice a difference between lite and v2. I'll be starting it out on a free host that gives a domain.

Criminal · February 6, 2008

Re: Delete

Godhand thnx for ur reply i will try lite to start of my php coding

Godhand · February 6, 2008

Re: Delete

No problem... its just questionable using $300 codes then putting them on some free host. Now lite and a free host that isn't questionable because both are free. :lol:

Sign In

Delete

Recommended Posts

Jesse60905

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Criminal

ignite

Jesse60905

Criminal

Criminal

Godhand

Redeye

Magictallguy

Godhand

BlatantDude

POG1

Guest Anonymous

Criminal

Vorlen

YoungGold

BlatantDude

BlatantDude

YoungGold

BlatantDude

Criminal

BlatantDude

Godhand

Criminal

Godhand

Join the conversation

Browse

Activity

Hosting