Help! How to use map 41: Secret Prison?

[namtuoc13]

Pls help me how to use the secret prison to impound character?If he has recall run (capital, bootleggery...), he can go out.

Thanks so much.

[lilprohacker]

step
1: bring him to prison.
2. make him sit down so you can tell him why and for how long he is there
3. /stopon <toonname> -Use this to make him not be able to stand up

I believe that will keep most people in there. and like I tell people that I send there, if they aren't there when I go to release them they get a permanent IP ban.

[SiggyMaker]

What prison? O.o

[AriezOMG]

Originally Posted by lilprohacker

step
1: bring him to prison.
2. make him sit down so you can tell him why and for how long he is there
3. /stopon <toonname> -Use this to make him not be able to stand up

I believe that will keep most people in there. and like I tell people that I send there, if they aren't there when I go to release them they get a permanent IP ban.

lilpro, I love your work and was wondering if you could give a tutorial on how to ban in any way, i've yet to figure out a few things and banning just happens to be one of them.

[lilprohacker]

I use a custom query but you can use the built in stored procedure.
[dbo].[usp_Update_UserStatus] which is under the USerData db.

Just pass the UserUID, "2" for status, "Unban Date", and "GM name for logging"

[AriezOMG]

say i was banning somebody named "Joe", UID number "47" how would this procedure be modified?

USE [PS_userdata]
GO
/****** Object:  StoredProcedure [dbo].[usp_Update_UserStatus]    Script Date: 07/21/2010 14:26:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** Object:  Stored Procedure dbo.usp_Update_UserStatus    Script Date: 2008-6-7 18:34:05 ******/






/*==================================================
@author	lenasoft
@date	2006-10-27
@return	
@brief	상태변경.
==================================================*/
ALTER  Proc [dbo].[usp_Update_UserStatus]
@UserUID 	int,
@Status		smallint,
@BlockEndDate 	datetime = null,
@GmID		varchar(32) = null
AS

SET NOCOUNT ON

DECLARE
@ReturnValue int

BEGIN TRAN

UPDATE Users_Master SET Status = @Status WHERE UserUID = @UserUID

IF @@ERROR <> 0
GOTO ERROR

-- Block Set
IF ( @Status = 2 )
BEGIN
	IF EXISTS ( SELECT UserUID FROM Users_Block WHERE UserUID = @UserUID )
	BEGIN
		UPDATE Users_Block SET BlockEndDate = @BlockEndDate
			WHERE UserUID = @UserUID
	END
	ELSE
	BEGIN
		
		INSERT INTO Users_Block ( UserUID, BlockEndDate)
			VALUES( @UserUID, @BlockEndDate )
	END
END

IF @@ERROR <> 0
GOTO ERROR

-- InsertLog
IF ( @GmID IS NOT NULL )
BEGIN
	INSERT INTO Users_BlockLog ( UserUID, Status, BlockEndDate, GmID, InsertDate) 
		VALUES( @UserUID, @Status, @BlockEndDate, @GmID, GETDATE()  )
	IF @@ERROR <> 0
	GOTO ERROR
END


SET @ReturnValue = 1
COMMIT TRAN
SET NOCOUNT OFF
RETURN @ReturnValue

ERROR:
SET @ReturnValue = -1
ROLLBACK TRAN
SET NOCOUNT OFF
RETURN @ReturnValue

[SiggyMaker]

AGAIN I ASK WHAT'S THIS PRISON?

[lilprohacker]

Originally Posted by Apocalypsist

say i was banning somebody named "Joe", UID number "47" how would this procedure be modified?

Execute the procedure and where it says UserUID put "47", under status put "2", under BanDate put the date that you want to release the ban, and under GMid put the GM name who wants the ban.

Originally Posted by SiggyMaker

AGAIN I ASK WHAT'S THIS PRISON?

It's a secret map that is a prison, it has cells that you can summon people there as a punishment. It's map id 41

[HolyWater93]

cant you use capital rune while sitting on the ground?

[AriezOMG]

Okay so i've been trying for quite some time now and just can't figure it out lilpro, can you redo the script with the names filled in as an example? I need to figure this out, as you're probably well aware its 100% necessary.

[Jaden151]

Works Perfect Thank lilpro! been looking for this for weeks!!0-

Apocaly, Worked perfect for me. What part is it coming up for an error in your db?

[namtuoc13]

Thanks Lilpro so much ^^