[mccode] Reset your users without deleating them

[Redeye]

Hey all,

This mod was made by me for people who want to keep all their users with their ids and login names and passwors etc.

I know some can code this in a couple of mins and I defently know I am a avarage coder compared to certain ce coders but I wanted to share this mod for all the people who cannot code as good as me...

 

Name it reset.php

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Redeye]

Re: [v1 & v2]Reset your users without deleating them

Here is v2

name it reset.php

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[fbiss]

Re: [v1 & v2]Reset your users without deleating them

Why you using so many querys? you can shrink that to 3 querys

for example for users you can do something like:

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

etc.

[Redeye]

Re: [v1 & v2]Reset your users without deleating them

lol, I made this ages ago when i was less experianced but only just found it when I was looking around my lappy

[ignite]

Re: [v1 & v2]Reset your users without deleating them

What about events and fed jail etc ?

[HITMAN 17]

Re: [v1 & v2]Reset your users without deleating them

this may come in handy

[Ragnar]

Re: [v1 & v2]Reset your users without deleating them

Does this have any security feature to keep players from loading the page and reseting everyone!! I'm guessing it's best to only have this script uploaded when you actually want to do this!

[Klikoka]

Re: [v1 & v2]Reset your users without deleating them

 

Does this have any security feature to keep players from loading the page and reseting everyone!! I'm guessing it's best to only have this script uploaded when you actually want to do this!

Just Add This To The Top

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Ragnar]

Re: [v1 & v2]Reset your users without deleating them

Is there an easy way to do this with out the NPC's geting reset? I'm guessing something like

UPDATE users SET hp=100 WHERE user_level=1;

though there is no user_level code in the userstats table.

[iseeyou94056]

Re: [v1 & v2]Reset your users without deleating them

every time you add anything to the users table you will need to add it to the code

[Zero-Affect]

Re: [v1 & v2]Reset your users without deleating them

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

Maybe that would be better?

theres not really any point clearing fedjail because well they normally did something bad...

[Ragnar]

Re: [v1 & v2]Reset your users without deleating them

Read my post again, there is no user_level in userstats so that won't work.

userid int(11) NOT NULL default '10',

strength bigint(25) NOT NULL default '10',

agility bigint(25) NOT NULL default '10',

guard bigint(25) NOT NULL default '10',

labour bigint(25) NOT NULL default '10',

IQ bigint(25) NOT NULL default '10'

You have to add some

$q=$db->query("SELECT userstats.*, users.* FROM blah blah blah...",$c);

code if it can be made to work.

[Zero-Affect]

Re: [v1 & v2]Reset your users without deleating them

my bad

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[Ragnar]

Re: [v1 & v2]Reset your users without deleating them

For stats and NPCs, I think the easiest way would be to create user_level in the userstats

ALTER TABLE `userstats` ADD `user_level` int(11) NOT NULL default 1;

and change the user_level there for any one not at Level 1. Then

mysql_query("UPDATE userstats SET strength=10,agility=10,guard=10,labour=10,IQ=10 WHERE user_level=1", $c) or die(mysql_error());

would work.

[Magictallguy]

Re: [v1 & v2]Reset your users without deleating them

What about resetting staff too? xD

[Magictallguy]

Re: [v1 & v2]Reset your users without deleating them

I know how to do it, but a *lot* of people don't. And I'm too tired to do it no was I've been awake for more than 24 hours (I don't like being up this long - I get grumpy! xD)

[Zero-Affect]

Re: [v1 & v2]Reset your users without deleating them

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

That also only resets staff and users since npc is user level 0 on my site but it will reset there stats which is easy to re-add

[timpitts]

Re: [v1 & v2]Reset your users without deleating them

what is it for v2

[Magictallguy]

Re: [v1 & v2]Reset your users without deleating them

For V2

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

That should work fine. Post any errors here!

[Reaper]

Re: [v1 & v2]Reset your users without deleating them

if i put this mod on my c panel do i need to put it anywhere else like in the staff panel for the reset or anything like that

[iR00T]

Re: [v1 & v2]Reset your users without deleating them

ahhhhhhhhhh

add into ur files

put a link into ur staff panel

[Reaper]

Re: [v1 & v2]Reset your users without deleating them

wot link do i put in is it just reset in the staff part of it

[Tonka]

Re: [v1 & v2]Reset your users without deleating them

put reset.php in the staff panel

[Reaper]

Re: [v1 & v2]Reset your users without deleating them

thanks mate ill do that now

[Reaper]

Re: [v1 & v2]Reset your users without deleating them

Parse error: syntax error, unexpected T_STRING in /home/reaper66/public_html/reset.php on line 10

 

i get that when i add it in i got the link in there but i click it to test it and i get that message how do i fix it i used the updated version for v2