[HELP]Reset Command

DragonStar · 09/14/2008, 01:36

How would you go about making a reset command like
/resetallpkp <<< would reset all characters in the database pkps to 0
using lotf source

~~tao4229~~ · 09/14/2008, 02:59

Quote:

Originally Posted by DragonStar

How would you go about making a reset command like
/resetallpkp <<< would reset all characters in the database pkps to 0
using lotf source

My LOTF had /clearpkp in it.. but if you need it here it is...

Code:

                                        if (Splitter[0] == "@clearpkp")
                                        {
                                            MyChar.PKPoints = 0;
                                            MyChar.BlueName = false;
                                            World.UpdateSpawn(MyChar);
                                            SendPacket(General.MyPackets.CharacterInfo(MyChar));
                                            MyChar.SendEquips(false);
                                            SendPacket(General.MyPackets.Vital(MyChar.UID, 26, MyChar.GetStat()));
                                        }

Yeah, i use @commands though >.>

Edit::OH, you mean all characters... that's my bad =P
Like, if you want all characters online, you can just run foreach loop, else it'd take some different coding D=<

Mouse>Pro · 09/14/2008, 03:31

Quote:

Originally Posted by tao4229

My LOTF had /clearpkp in it.. but if you need it here it is...

Code:

                                        if (Splitter[0] == "@clearpkp")
                                        {
                                            MyChar.PKPoints = 0;
                                            MyChar.BlueName = false;
                                            World.UpdateSpawn(MyChar);
                                            SendPacket(General.MyPackets.CharacterInfo(MyChar));
                                            MyChar.SendEquips(false);
                                            SendPacket(General.MyPackets.Vital(MyChar.UID, 26, MyChar.GetStat()));
                                        }

Yeah, i use @commands though >.>

Edit::OH, you mean all characters... that's my bad =P
Like, if you want all characters online, you can just run foreach loop, else it'd take some different coding D=<

nice but i think he means that he want a command that reset all pkps from all characters in lotf

~~tao4229~~ · 09/14/2008, 03:38

Quote:

Originally Posted by Mouse>Pro

nice but i think he means that he want a command that reset all pkps from all characters in lotf

Too bad you didn't read my Edit.

Mouse>Pro · 09/14/2008, 03:41

Quote:

Originally Posted by tao4229

Too bad you didn't read my Edit.

oh sorry, my fault.

DragonStar · 09/14/2008, 04:17

Quote:

Originally Posted by tao4229

My LOTF had /clearpkp in it.. but if you need it here it is...

Code:

                                        if (Splitter[0] == "@clearpkp")
                                        {
                                            MyChar.PKPoints = 0;
                                            MyChar.BlueName = false;
                                            World.UpdateSpawn(MyChar);
                                            SendPacket(General.MyPackets.CharacterInfo(MyChar));
                                            MyChar.SendEquips(false);
                                            SendPacket(General.MyPackets.Vital(MyChar.UID, 26, MyChar.GetStat()));
                                        }

Yeah, i use @commands though >.>

Edit::OH, you mean all characters... that's my bad =P
Like, if you want all characters online, you can just run foreach loop, else it'd take some different coding D=<

trying to get it too do it to all chars in the database regardless if ther online
or offline, still playing around w/the code

~~kinshi88~~ · 09/14/2008, 08:28

Something like this maybe?
Haven't tested it.

Code:

                                            if (Splitter[0] == "/clearallpkp")
                                            {
                                                foreach (DictionaryEntry DE in World.AllChars)
                                                {
                                                    MyChar.PKPoints = 0;
                                                    MyChar.BlueName = false;
                                                    SendPacket(General.MyPackets.Vital(MyChar.UID, 6, MyChar.PKPoints));
                                                    World.UpdateSpawn(MyChar);
                                                    SendPacket(General.MyPackets.CharacterInfo(MyChar));
                                                    MyChar.SendEquips(false);
                                                    SendPacket(General.MyPackets.Vital(MyChar.UID, 26, MyChar.GetStat()));
                                                    World.SpawnMeToOthers(MyChar, true);
                                                }
                                            }

DragonStar · 09/14/2008, 08:39

Quote:

Originally Posted by kinshi88

Something like this maybe?
Haven't tested it.

Code:

                                            if (Splitter[0] == "/clearallpkp")
                                            {
                                                foreach (DictionaryEntry DE in World.AllChars)
                                                {
                                                    MyChar.PKPoints = 0;
                                                    MyChar.BlueName = false;
                                                    SendPacket(General.MyPackets.Vital(MyChar.UID, 6, MyChar.PKPoints));
                                                    World.UpdateSpawn(MyChar);
                                                    SendPacket(General.MyPackets.CharacterInfo(MyChar));
                                                    MyChar.SendEquips(false);
                                                    SendPacket(General.MyPackets.Vital(MyChar.UID, 26, MyChar.GetStat()));
                                                    World.SpawnMeToOthers(MyChar, true);
                                                }
                                            }

nah that still only does one char not all

DragonStar · 09/14/2008, 08:58

well this is just the first part im trying to figure out, wut im trying to do is first figure out
how to reset every1's pkp even if ther offline, then my next step after i figure that out
is to figure out how to make it automatically reset all pkp n the database at a certain time
of day, example 0:00 every day it would reset the pkp

adz06676 · 09/14/2008, 10:56

Quote:

Originally Posted by DragonStar

well this is just the first part im trying to figure out, wut im trying to do is first figure out
how to reset every1's pkp even if ther offline, then my next step after i figure that out
is to figure out how to make it automatically reset all pkp n the database at a certain time
of day, example 0:00 every day it would reset the pkp

its this:

Quote:

if (Splitter[0] == "/clearallpkp")
{
foreach (DictionaryEntry DE in World.AllChars)
{
Character Char = (Character)DE.Value;
{
Char.PKPoints = 0;
Char.BlueName = false;
SendPacket(General.MyPackets.Vital(Char.UID, 6, Char.PKPoints));
World.UpdateSpawn(Char);
SendPacket(General.MyPackets.CharacterInfo(Char));
Char.SendEquips(false);
SendPacket(General.MyPackets.Vital(Char.UID, 26, Char.GetStat()));
World.SpawnMeToOthers(Char, true);
}
}
}

DragonStar · 09/14/2008, 11:36

@adz06676 - tyvm, n i kinda feel dum now lol

next gta try to get it to clear pkp from even the ppl who are offline

adz06676 · 09/14/2008, 11:47

Quote:

Originally Posted by DragonStar

@adz06676 - tyvm, n i kinda feel dum now lol

next gta try to get it to clear pkp from even the ppl who are offline

lol no problem

© Haydz · 09/20/2008, 01:48

For all the characters in the database:

i assume your running lotf based database and source so it will be somewhat along the lines of

Code:

MySqlCommand MySqlCmd = new MySqlCommand("UPDATE `characters` SET `PKPoints` = 0", Connection);
MySqlCmd.ExecuteNonQuery();

I am far from a genius with mysql so no doubt that will need correcting

Rechocto · 09/20/2008, 02:28

Quote:
Originally Posted by © Haydz
For all the characters in the database:

i assume your running lotf based database and source so it will be somewhat along the lines of
Code:
MySqlCommand MySqlCmd = new MySqlCommand("UPDATE `characters` SET `PKPoints` = 0", Connection);
MySqlCmd.ExecuteNonQuery();
I am far from a genius with mysql so no doubt that will need correcting

LMAO, why did it take that long for someone to post this? XD.. it's so dang obvious XDDD -- as soon as I read the first post I had that ready in my mind but had to read other posts so as to make sure not to repost... everyone that gave anything other than this -- it is now plainly obvious that you do nothing but copypaste and minor edits

InfamousNoone · 09/20/2008, 05:44

Quote:

Originally Posted by Rechocto

LMAO, why did it take that long for someone to post this? XD.. it's so dang obvious XDDD -- as soon as I read the first post I had that ready in my mind but had to read other posts so as to make sure not to repost... everyone that gave anything other than this -- it is now plainly obvious that you do nothing but copypaste and minor edits

Because nobody honestly gives a ****.