[Share]Punishment System.

[Coyote™]

Well, hello everybody.

Here I am with a new share, which is a kind of "adaption".

 

Let me remind what Intrepid once said:

The only way to give sense to Interlude, is to apply Gracia Features in it.

 

So, I thought to take the punishment system from Gracia Epilogue, and change it to support Interlude.

 

If you are interested in adding it, follow the patch step by step.

It has NO compile errors, since I tested it on a clear Interlude pack, taken from L2j Server's branches.

 

So, here you are:

Link

 

 

Don't forget to add the server (sql) part!

Go at characters.sql, and:

 

Delete these:

in_jail decimal(1,0) DEFAULT 0,
 jail_timer decimal(20,0) DEFAULT 0,

 

And instead of them, add these:

punish_level TINYINT UNSIGNED NOT NULL DEFAULT 0,
 punish_timer INT UNSIGNED NOT NULL DEFAULT 0,

 

It has been tested and it works.

Have Fun using it!

 

Best Regards,

Coyote™.

[B1ggBoss]

nice :). So bad donator members cannot karma people

[Coyote™]

nice :). So bad donator members cannot karma people

 

Actually it is good.

You know, most users aren't like you.

What I mean is that, since most of the members don't know how to use the priv properly, there is chaos in mxc because of the abuses =P

 

Thank you very much, by the way! :)

[xAddytzu]

I'm glad that someone does something for Max

 

btw: You forgot sql file :)

[Coyote™]

btw: You forgot sql file :)

 

Oh, right.

Forgot to add it at the patch!

 

I added on the first post.

Hf!

[MasterDisaster]

Can you explain what it does?I am out of date really.

Gracia final has that as a default feature?

[Coyote™]

Can you explain what it does?I am out of date really.

Gracia final has that as a default feature?

 

It's epilogue, but final has the same feature too.

Remember the old boring chatban and jail system?

 

Where the durations and actions were standard and boring.

Now it is advanced:

 

There are a few types of punishments, such as jail, chat, acc, etc.

 

You can easily set your own duration and kind of punishment in an easier and better way than before.

 

 

Add it and you'll find out more by yourself.

[MasterDisaster]

It's epilogue, but final has the same feature too.

Remember the old boring chatban and jail system?

 

Where the durations and actions were standard and boring.

Now it is advanced:

 

There are a few types of punishments, such as jail, chat, acc, etc.

 

You can easily set your own duration and kind of punishment in an easier and better way than before.

 

 

Add it and you'll find out more by yourself.

I get it now.

Damn me,I have to read about the new features.

Thanks for sharing that with us.Will help shitlude lovers :P

[TheMpouri®™]

Thanks dude. But interlude needs very much work!

[xAddytzu]

Coyote™, I found a mistake ..

I did a littel patch

 

Index: gameserver.handler.admincommandhandlers.AdminBan

private void jailOfflinePlayer(L2PcInstance activeChar, String name, int delay)
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();

-			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, in_jail=?, jail_timer=? WHERE char_name=?");
+			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, punish_level=?, punish_timer=? WHERE char_name=?");
@@
private void unjailOfflinePlayer(L2PcInstance activeChar, String name)
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
-			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, in_jail=?, jail_timer=? WHERE char_name=?");
+			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, punish_level=?, punish_timer=? WHERE char_name=?");
		statement.setInt(1, 17836);

[Coyote™]

Coyote™, I found a mistake ..

I did a littel patch

 

Index: gameserver.handler.admincommandhandlers.AdminBan

private void jailOfflinePlayer(L2PcInstance activeChar, String name, int delay)
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();

-			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, in_jail=?, jail_timer=? WHERE char_name=?");
+			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, punish_level=?, punish_timer=? WHERE char_name=?");
@@
private void unjailOfflinePlayer(L2PcInstance activeChar, String name)
{
	Connection con = null;
	try
	{
		con = L2DatabaseFactory.getInstance().getConnection();
-			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, in_jail=?, jail_timer=? WHERE char_name=?");
+			PreparedStatement statement = con.prepareStatement("UPDATE characters SET x=?, y=?, z=?, punish_level=?, punish_timer=? WHERE char_name=?");
		statement.setInt(1, 17836);

 

so, where's the mistake? =P

[xAddytzu]

You forgot to change  punish_level=?, punish_timer=?

[Coyote™]

You forgot to change  punish_level=?, punish_timer=?

 

Why to change it? o.O

This is what I added..

I still can't get you..

 

EDIT: I just saw the "Index" at your post..

The patch was not normal, so I didn't see it xD

Gonna fix it, sec.

[xAddytzu]

You`ve got it at last

 

> Tested and Working <

[Coyote™]

You`ve got it at last

 

yea, I didn't notice the class you were mentioning, since the patch was handmade ;p

 

> Tested and Working <

 

Thanks for providing feedback.