|
You last visited: Today at 15:09
Advertisement
Help! How to use map 41: Secret Prison?
Discussion on Help! How to use map 41: Secret Prison? within the Shaiya Private Server forum part of the Shaiya category.
07/21/2010, 08:03
|
#1
|
elite*gold: 0
Join Date: Oct 2009
Posts: 4
Received Thanks: 0
|
Help! How to use map 41: Secret Prison?
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.
|
|
|
07/21/2010, 14:47
|
#2
|
elite*gold: 20
Join Date: Jun 2009
Posts: 790
Received Thanks: 2,727
|
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.
|
|
|
07/21/2010, 14:52
|
#3
|
elite*gold: 0
Join Date: Jun 2010
Posts: 616
Received Thanks: 104
|
What prison? O.o
|
|
|
07/21/2010, 18:25
|
#4
|
elite*gold: 100
Join Date: Mar 2009
Posts: 552
Received Thanks: 1,003
|
Quote:
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.
|
|
|
07/21/2010, 20:20
|
#5
|
elite*gold: 20
Join Date: Jun 2009
Posts: 790
Received Thanks: 2,727
|
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"
|
|
|
07/21/2010, 23:28
|
#6
|
elite*gold: 100
Join Date: Mar 2009
Posts: 552
Received Thanks: 1,003
|
say i was banning somebody named "Joe", UID number "47" how would this procedure be modified?
Code:
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
|
|
|
07/21/2010, 23:32
|
#7
|
elite*gold: 0
Join Date: Jun 2010
Posts: 616
Received Thanks: 104
|
AGAIN I ASK WHAT'S THIS PRISON?
|
|
|
07/22/2010, 02:26
|
#8
|
elite*gold: 20
Join Date: Jun 2009
Posts: 790
Received Thanks: 2,727
|
Quote:
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.
Quote:
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
|
|
|
07/22/2010, 02:45
|
#9
|
elite*gold: 0
Join Date: Apr 2010
Posts: 37
Received Thanks: 2
|
cant you use capital rune while sitting on the ground?
|
|
|
07/22/2010, 20:54
|
#10
|
elite*gold: 100
Join Date: Mar 2009
Posts: 552
Received Thanks: 1,003
|
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.
|
|
|
07/23/2010, 19:45
|
#11
|
elite*gold: 0
Join Date: May 2010
Posts: 97
Received Thanks: 14
|
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?
|
|
|
07/28/2010, 09:42
|
#12
|
elite*gold: 0
Join Date: Oct 2009
Posts: 4
Received Thanks: 0
|
Thanks Lilpro so much ^^
|
|
|
Similar Threads
|
[RELEASE]WALLHACK+secret bypass+secret method [3minutes only]
03/02/2010 - Soldier Front Philippines - 4 Replies
By the way im rockerboi. . .pusoy23 is my ka shop. . .and i secret release this for you. . .
SORI SA HINDI MGA MAKAKUHA PUNTA NA LANG KAU SITE KO. . .NI POST NA NI PINOYCODERS UN. . .
THE DOWNLOAD LINK is CLOSED
P.S
rockerboi
:cool:
|
How can i get out of prison
04/03/2006 - World of Warcraft - 2 Replies
i got in prison , can anybody help me????
|
getting out of prison
09/10/2005 - Conquer Online 2 - 1 Replies
Can someone please tell me how to get out of prison once you are arrested and since i havent found a topic replying to this matter can someone help me please.
P.S on volcano server my ranger happend to get sent to prison wilist I WAS PLAYING not using any hacks or anything to get my self into that position.
|
All times are GMT +1. The time now is 15:09.
|
|