weewooz Posted February 15, 2008 Posted February 15, 2008 Hi does anyone kow anything bout a level cap on vr1 i have been talking with lostone and he knows nothing about a level cap the thing is my players are stuck on level 356 and they not go any higher any help on what and where to change would be a great help thank you in advance Quote
-Matt- Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 I think seany got one posted here check the forums. Quote
weewooz Posted February 15, 2008 Author Posted February 15, 2008 Re: Help With level cap vr1 i have searched mate i cant find anything at all just getting my players mad lol any help please Quote
JDubz Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 maybe there not getting enough experience... if thats not the issue then change it to like bigint (25). Quote
weewooz Posted February 15, 2008 Author Posted February 15, 2008 Re: Help With level cap vr1 were what page would i change that never had these problems before Quote
weewooz Posted February 15, 2008 Author Posted February 15, 2008 Re: Help With level cap vr1 in admin pan i can set to any level i want but the players playing not go past lvl 356 they cant go up no more werid or what Quote
weewooz Posted February 15, 2008 Author Posted February 15, 2008 Re: Help With level cap vr1 there stuck on 356 with 99exp so what do i have to change on what page thanks again in advance Quote
marshman_007 Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 i have the same problem but with v2 and it stops at lvl 165 with 99% exp Quote
JDubz Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 Um I have no idea, maybe open your phpMyAdmin and open user table, and alter the int(11) to bigint(25) im guessing. See if that works if it dont then come back. Quote
HITMAN 17 Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 Um I have no idea, maybe open your phpMyAdmin and open user table, and alter the int(11) to bigint(25) im guessing. See if that works if it dont then come back. if u do it properly it shud work yes Quote
Criminal Posted February 15, 2008 Posted February 15, 2008 Re: Help With level cap vr1 v2 go to file manager find staff_users.php and replace this <?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. <form action='staff_users.php?action=newusersub' method='post'> 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> [b]Stats[/b] 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. [url='admin.php?action=newuser']> Back[/url]"; $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((float) $_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. <form action='staff_users.php?action=edituserform' method='post'> User: ".user_dropdown($c,'user')." <input type='submit' value='Edit User' /></form> OR enter a user ID to edit: <form action='staff_users.php?action=edituserform' method='post'> 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> <form action='staff_users.php?action=editusersub' method='post'> <input type='hidden' name='userid' value='{$_POST['user']}' /> 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']=(float) $_POST['level']; $_POST['strength']=abs((float) $_POST['strength']); $_POST['agility']=abs((float) $_POST['agility']); $_POST['guard']=abs((float) $_POST['guard']); $_POST['labour']=abs((float) $_POST['labour']); $_POST['IQ']=abs((float) $_POST['IQ']); $_POST['money']=(float) $_POST['money']; $_POST['bankmoney']=(float) $_POST['bankmoney']; $_POST['cybermoney']=(float) $_POST['cybermoney']; $_POST['crystals']=(float) $_POST['crystals']; $_POST['mailban']=(float) $_POST['mailban']; $_POST['forumban']=(float) $_POST['forumban']; $maxwill=abs((float) $_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 " [url='admin.php?action=edituser']> Back[/url]"; $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. <form action='staff_users.php?action=deluser&step=2' method='post'> User: ".user_dropdown($c,'user')." <input type='submit' value='Delete User' /></form> OR enter a user ID to Delete: <form action='staff_users.php?action=deluser&step=2' method='post'> 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"]."? <form action='staff_users.php?action=deluser&step=3' method='post'> <input type='hidden' name='userid' value='$target' /> <input type='submit' name='yesorno' value='Yes' /> <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. [url='staff_users.php?action=deluser']>Back to main Delete Users page.[/url]"); } 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. [url='staff_users.php?action=deluser']>Back to main Delete Users page.[/url]"; 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. <form action='staff_users.php?action=invuser' method='post'> 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 "[b]This person has no items![/b]"; } else { print "[b]Their items are listed below.[/b] <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>[[url='staff_users.php?action=deleinv&ID={$i[']Delete[/url]]"; 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. <form action='staff_users.php?action=creditsub' method='post'> 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. <form action='staff_users.php?action=masscreditsub' method='post'> 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'] = (float) $_POST['money']; $_POST['crystals'] = (float) $_POST['crystals']; $db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']}"); print "All Users credited. Click [url='staff.php?action=announce']here to add an announcement[/url] or [url='staff_special.php?action=massmailer']here to send a mass mail[/url] 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>[url='viewuser.php?u={$r[']{$r['reporter']}[/url] [{$r['prREPORTER']}]</td> <td>[url='viewuser.php?u={$r[']{$r['offender']}[/url] [{$r['prREPORTED']}]</td> <td>{$r['prTEXT']}</td> <td>[url='staff_users.php?action=repclear&ID={$r[']Clear[/url]</td> </tr>"; } print "</table>"; } function forcelogout() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 2) { die("403"); } $_POST['userid'] = abs((float) $_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((float) $_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(); ?> Then go to Phpmyadmin users table go on money then chnage it from int to BIGINT Thanks hope it works Quote
marshman_007 Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 v2 go to file manager find staff_users.php and replace this <?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. <form action='staff_users.php?action=newusersub' method='post'> 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> [b]Stats[/b] 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. [url='admin.php?action=newuser']> Back[/url]"; $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((float) $_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. <form action='staff_users.php?action=edituserform' method='post'> User: ".user_dropdown($c,'user')." <input type='submit' value='Edit User' /></form> OR enter a user ID to edit: <form action='staff_users.php?action=edituserform' method='post'> 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> <form action='staff_users.php?action=editusersub' method='post'> <input type='hidden' name='userid' value='{$_POST['user']}' /> 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']=(float) $_POST['level']; $_POST['strength']=abs((float) $_POST['strength']); $_POST['agility']=abs((float) $_POST['agility']); $_POST['guard']=abs((float) $_POST['guard']); $_POST['labour']=abs((float) $_POST['labour']); $_POST['IQ']=abs((float) $_POST['IQ']); $_POST['money']=(float) $_POST['money']; $_POST['bankmoney']=(float) $_POST['bankmoney']; $_POST['cybermoney']=(float) $_POST['cybermoney']; $_POST['crystals']=(float) $_POST['crystals']; $_POST['mailban']=(float) $_POST['mailban']; $_POST['forumban']=(float) $_POST['forumban']; $maxwill=abs((float) $_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 " [url='admin.php?action=edituser']> Back[/url]"; $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. <form action='staff_users.php?action=deluser&step=2' method='post'> User: ".user_dropdown($c,'user')." <input type='submit' value='Delete User' /></form> OR enter a user ID to Delete: <form action='staff_users.php?action=deluser&step=2' method='post'> 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"]."? <form action='staff_users.php?action=deluser&step=3' method='post'> <input type='hidden' name='userid' value='$target' /> <input type='submit' name='yesorno' value='Yes' /> <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. [url='staff_users.php?action=deluser']>Back to main Delete Users page.[/url]"); } 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. [url='staff_users.php?action=deluser']>Back to main Delete Users page.[/url]"; 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. <form action='staff_users.php?action=invuser' method='post'> 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 "[b]This person has no items![/b]"; } else { print "[b]Their items are listed below.[/b] <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>[[url='staff_users.php?action=deleinv&ID={$i[']Delete[/url]]"; 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. <form action='staff_users.php?action=creditsub' method='post'> 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. <form action='staff_users.php?action=masscreditsub' method='post'> 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'] = (float) $_POST['money']; $_POST['crystals'] = (float) $_POST['crystals']; $db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']}"); print "All Users credited. Click [url='staff.php?action=announce']here to add an announcement[/url] or [url='staff_special.php?action=massmailer']here to send a mass mail[/url] 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>[url='viewuser.php?u={$r[']{$r['reporter']}[/url] [{$r['prREPORTER']}]</td> <td>[url='viewuser.php?u={$r[']{$r['offender']}[/url] [{$r['prREPORTED']}]</td> <td>{$r['prTEXT']}</td> <td>[url='staff_users.php?action=repclear&ID={$r[']Clear[/url]</td> </tr>"; } print "</table>"; } function forcelogout() { global $db,$ir,$c,$h,$userid; if($ir['user_level'] > 2) { die("403"); } $_POST['userid'] = abs((float) $_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((float) $_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(); ?> Then go to Phpmyadmin users table go on money then chnage it from int to BIGINT Thanks hope it works so replace my staff_users.php with that one then? and it should work Quote
Criminal Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 yes thats for v2 Quote
marshman_007 Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 thats the exact thing i have. every single word of it. Quote
Criminal Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 Did it work Quote
marshman_007 Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 nope it didnt work Quote
marshman_007 Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 nope it didnt work. that stuff was the same that i was already using. Quote
Krafty Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 level cap?..why want such a high level Quote
Aqua Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 Maybe because his current players are at that level... Quote
Zytraw Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 i wanted to sort out level cap once, i think on v1 or v2 mccodes its 165, im guessing from what i can remeber. i did used to know how to sort it out but forgot sorry, ill try and jiggle my mind. if i remeber ill post it in for you. Quote
Godhand Posted February 16, 2008 Posted February 16, 2008 Re: Help With level cap vr1 In php my admin change level to big int 25... and the experience needed to big int 25.. Quote
riderdaz Posted February 18, 2008 Posted February 18, 2008 Re: Help With level cap vr1 Hi does anyone kow anything bout a level cap on vr1 i have been talking with lostone and he knows nothing about a level cap the thing is my players are stuck on level 356 and they not go any higher any help on what and where to change would be a great help thank you in advance level 356 please say your game is 5+ years old Quote
Godhand Posted February 27, 2008 Posted February 27, 2008 Re: Help With level cap vr1 Hi does anyone kow anything bout a level cap on vr1 i have been talking with lostone and he knows nothing about a level cap the thing is my players are stuck on level 356 and they not go any higher any help on what and where to change would be a great help thank you in advance level 356 please say your game is 5+ years old If his game was +5 years old he would be able to code the fix. :wink:. I know I coded past it when my game was less than a month old. I did it for planning in the feature. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.