Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 15:09

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #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.
namtuoc13 is offline  
Old 07/21/2010, 14:47   #2
 
lilprohacker's Avatar
 
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.
lilprohacker is offline  
Old 07/21/2010, 14:52   #3
 
elite*gold: 0
Join Date: Jun 2010
Posts: 616
Received Thanks: 104
What prison? O.o
SiggyMaker is offline  
Old 07/21/2010, 18:25   #4
 
AriezOMG's Avatar
 
elite*gold: 100
Join Date: Mar 2009
Posts: 552
Received Thanks: 1,003
Quote:
Originally Posted by lilprohacker View Post
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.
AriezOMG is offline  
Old 07/21/2010, 20:20   #5
 
lilprohacker's Avatar
 
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"
lilprohacker is offline  
Old 07/21/2010, 23:28   #6
 
AriezOMG's Avatar
 
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
AriezOMG is offline  
Old 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?
SiggyMaker is offline  
Old 07/22/2010, 02:26   #8
 
lilprohacker's Avatar
 
elite*gold: 20
Join Date: Jun 2009
Posts: 790
Received Thanks: 2,727
Quote:
Originally Posted by Apocalypsist View Post
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 View Post
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
lilprohacker is offline  
Old 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?
HolyWater93 is offline  
Old 07/22/2010, 20:54   #10
 
AriezOMG's Avatar
 
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.
AriezOMG is offline  
Old 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?
Jaden151 is offline  
Old 07/28/2010, 09:42   #12
 
elite*gold: 0
Join Date: Oct 2009
Posts: 4
Received Thanks: 0
Thanks Lilpro so much ^^
namtuoc13 is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.