[Release] Report player command

[pro4never]

Ok so this is a messy release that I'm sure no one will use but I figured I'd throw it out there for people who want it.


What it is is a command to report a player and it will store who used the command, who was reported and the reason in a handy little database for gm's to use later.

Personally I plan to use it (or a cleaned up version) to allow moderators to report problems or hackers for when a gm is not online. It's not perfect as it is but it works.

Note: this version is CoEmu but really... it's not hard at all to convert.

Handlers>Chat.cs

 Spoiler

PHP Code:

case "report":
                            {
                                if (CSocket.Client.isPM || CSocket.Client.isGM || CSocket.Client.isHH)
                                {
                                    try
                                    {
                                        Monitor.Enter(Nano.ClientPool);
                                        foreach (KeyValuePair<int, ClientSocket> Player in Nano.ClientPool)
                                        {
                                            if (Player.Value.Client.Name.ToLower() == Command[1].ToLower())
                                            {
                                                if (Player.Value.Client.isPM || Player.Value.Client.isPM)
                                                    CSocket.Send(ConquerPacket.Chat(0, "SYSTEM", CSocket.Client.Name, "GM and PM chars cannot be reported", Struct.ChatType.Top));
                                                else
                                                {
                                                    
                                                    Result = Command1.Remove(0, Command[0].Length);
                                                    Result = Result.Remove(0, (Command[1].Length + 1));
                                                    Database.Database.ReportPlayer(CSocket, Player.Value, Result);
                                                    ConquerPacket.ToServer(ConquerPacket.Chat(0, "SYSTEM", "ALLUSERS", Player.Value.Client.Name + " has been reported by " + CSocket.Client.Name, Struct.ChatType.Center), 0);
                                                    /
                                                }
                                                break;
                                            }
                                        }
                                        
                                    }
                                    catch (Exception e)
                                    {
                                        Console.WriteLine(e.ToString());
                                    }
                                    finally
                                    {
                                        Monitor.Exit(Nano.ClientPool);
                                    }
                                }
                                break;
                            } 


Notice you will have some undefined strings. Go up to the top of the file and see string[] Command = Message.Substring(1).Split(' ');

Place these two under that

string Command1 = Message.Substring(1);
string Result = "";

That's just what I used for clearing out the initial part of the msg so that you could write more than 1 word reasons for reporting a player. Simple but somewhat messy fix.


Now Database>Database.cs

PHP Code:

 public static void ReportPlayer(ClientSocket CSocket, ClientSocket RSocket, string Report1)
        {
            lock (DatabaseConnection.NewConnection())
            {

                MySqlCommand Cmd = new MySqlCommand("insert into `Report`(`WhoReport`, `WhoReported`, `Report`) values ('" + CSocket.Client.Name + "', '" + RSocket.Client.Name + "', '" + Report1 + "')", DatabaseConnection.NewConnection());

                Cmd.ExecuteNonQuery();
            }
        } 


And for the database itself. Open up navicat and create a new database.

Mine is called "Report" with the following fields

ReportUID, int, 11, 0 notnull, key, auto incrimented
WhoReport, varchar, 20, 0, notnull
WhoReported, varchar, 20, 0, notnull
Report, varchar, 200, 0, notnull

That should be all you need, you will wanna add a bool under Characters.cs for "isHH", that's the new moderator position I am adding for players with improved server rights (such as reporting, don't want noobs spamming up the log)


You can also use this type of a thing to log server events such as errors for later reference.... but that's a different thing and I'm super tired so yah.

Enjoy,
Pro4never

[sawickas]

I like xD

[Metapod]

good job

[hunterman01]

This is actually a useful release

[Arcо]

I can see this being abused+spammed database.
Not saying its bad lol.
Good job I just see it being abused.

[pro4never]

Originally Posted by .Arco

I can see this being abused+spammed database.
Not saying its bad lol.
Good job I just see it being abused.

That's why it's only a gm/pm/moderator command. Normal players can't report players for that simple reason.

[copz1337]

could you please convert this for 5165?

[pro4never]

No: None of my releases are for 5165 because I have no interest whatsoever in that source.

Beside, any time I spend coding (or awake it seems) is spent working on my server. Working on finishing up my 1v1 dueling system right now actually... I release some of the features I code from time to time simply because I enjoy contributing to epvp.

[hunterman01]

Originally Posted by pro4never

No: None of my releases are for 5165 because I have no interest whatsoever in that source.

Beside, any time I spend coding (or awake it seems) is spent working on my server. Working on finishing up my 1v1 dueling system right now actually... I release some of the features I code from time to time simply because I enjoy contributing to epvp.

Except the stuff we code isnt getting released

Btw i found that top spouse status i was looking for

[pro4never]

Originally Posted by hunterman01

Except the stuff we code isnt getting released

Btw i found that top spouse status i was looking for

yah exactly. I do release small stuff though that helps people without giving away the functionality of my server (aka this)


Nice job with top spouse! If you could get a list of all the halo id's for reference that would be awesome. As it is right now I only remember a few of them.

As soon as I compile the next rev we will have

-Fully functioning beta duel system (everything works perfectly, simplified for testing though)
-Perfectly balanced ninja skills (since my corrected distance checks to avoid laggy hits ninjas are OVER nerfed lol)
-Correct more attack bugs
-Finally get around to fixing the status update packet so all the effects are working again (shhhh, that was a 6 am coding fuckup after being up all night)

After that is done all I can think of that needs to happen is more systems, minor bug fixes, more npcs and, obviously, more systems (I'm thinking guild war reward system next so that people have a reason to do guild war)

Honestly if we can finish up a few more events and track down a few more bugs we will be very prepared for beta (I'll leave pre-beta up for another week or so though so we can fully test the new **** before going beta)


Damnit! I always do this, I go off topic and ramble where no one cares what I have to say.


Back to my mini-release

[vgcman1500]

Nice release ^^

[xI NiNJA DuCKey]

+1, Nice Release, Use [code] next time

[Arcо]

Originally Posted by xI NiNJA DuCKey

+1, Nice Release, Use [code] next time

[code] or [php], he used [php], as long as it keeps it organized it doesn't really matter.

[herekorvac]

great job

[xI NiNJA DuCKey]

use [code] ftw?
Thanks.