Register for your free account! | Forgot your password?

You last visited: Today at 22:11

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


[RELEASE] Faction Change Rune

Reply
 
Old 06/20/2015, 18:43   #31
 
elite*gold: 0
Join Date: Aug 2012
Posts: 20
Received Thanks: 2
When the chars is Faction Change, the account DC.. Any ideas please ?



KalySuky is offline  
Old 06/21/2015, 06:57   #32
 
elite*gold: 0
Join Date: Jun 2015
Posts: 81
Received Thanks: 136
if the account is dc after fc there is a new error in your log files post your log files so we might help you find the problem your looking for although I doubt its anything to really do with this script here if you followed the instructions correctly I use something like this script and I haven't had any problems with it although this script really isn't completed fully because when you fc all the saved tele points aren't erased so when someone uses this version of the fc they can still port into the other factions maps


[Alcatraz] is offline  
Old 06/21/2015, 12:19   #33
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,235
The ep5.4 ps_game.exe doesn't let accounts go in if
Code:
(Country = 0 AND Family NOT IN (0, 1)) OR (Country = 1 AND Family NOT IN (2, 3))
, which forces you to stop using this stupid script.

Good job OS, you showed them.
nubness is offline  
Thanks
3 Users
Old 06/21/2015, 13:05   #34
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 261
I'm trying some like that

But this change only faction without gears and clasess.
As query this work fine

Code:
if (@ActionType=114 and @Value2='100254') --FC Rune L-D
begin


Declare @Toon1 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='0' and del ='0')
Declare @Toon2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='1' and del ='0')
Declare @Toon3 int =(Select  top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='2' and del ='0')
Declare @Toon4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='3' and del ='0')
Declare @Toon5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='4' and del ='0')


UPDATE PS_GameData.dbo.UserMaxGrow
set Country='1'
where [email protected]

UPDATE PS_GameData.dbo.CharItems
SET [Type]=(
CASE Type
 
 WHEN 16 THEN 31
 WHEN 17 THEN 32
 WHEN 18 THEN 33
 WHEN 19 THEN 34
 WHEN 20 THEN 35
 WHEN 21 THEN 36

 ELSE [Type]
END)
where CharID in (@toon1,@toon2,@toon3,@toon4,@toon5) And TypeID in (35,120,216)


UPDATE PS_GameData.dbo.Chars 
SET [Family] = (
CASE 

 WHEN Family=0 AND Job=5 THEN 2
 WHEN Family=0 AND Job IN (0,1) THEN 3

 WHEN Family=1 AND Job=3 THEN 3
 WHEN Family=1 AND Job IN (2,4) THEN 2

 ELSE Family
END)
where CharID in (@toon1,@toon2,@toon3,@toon4,@toon5)
end


SnickQ is offline  
Thanks
1 User
Old 06/21/2015, 13:29   #35
 
elite*gold: 0
Join Date: Jan 2013
Posts: 398
Received Thanks: 427
Quote:
Originally Posted by SnickQ View Post
I'm trying some like that

But this change only faction without gears and clasess.
As query this work fine

Code:
if (@ActionType=114 and @Value2='100254') --FC Rune L-D
begin


Declare @Toon1 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='0' and del ='0')
Declare @Toon2 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='1' and del ='0')
Declare @Toon3 int =(Select  top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='2' and del ='0')
Declare @Toon4 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='3' and del ='0')
Declare @Toon5 int =(Select top 1 CharID From PS_GameData.dbo.chars where UserUID [email protected] and slot ='4' and del ='0')


UPDATE PS_GameData.dbo.UserMaxGrow
set Country='1'
where [email protected]

UPDATE PS_GameData.dbo.CharItems
SET [Type]=(
CASE Type
 
 WHEN 16 THEN 31
 WHEN 17 THEN 32
 WHEN 18 THEN 33
 WHEN 19 THEN 34
 WHEN 20 THEN 35
 WHEN 21 THEN 36

 ELSE [Type]
END)
where CharID in (@toon1,@toon2,@toon3,@toon4,@toon5) And TypeID in (35,120,216)


UPDATE PS_GameData.dbo.Chars 
SET [Family] = (
CASE 

 WHEN Family=0 AND Job=5 THEN 2
 WHEN Family=0 AND Job IN (0,1) THEN 3

 WHEN Family=1 AND Job=3 THEN 3
 WHEN Family=1 AND Job IN (2,4) THEN 2

 ELSE Family
END)
where CharID in (@toon1,@toon2,@toon3,@toon4,@toon5)
end
You are updating some gears and no weapons/capes/mounts etc. You should reset the skills and give back the skill points; like alcatraz said need remote tele points and this script is only for change to dark account.
i suggest to make the change faction like website script. It maked atleast for me my life easier when i maked mine.
beetols is offline  
Old 06/21/2015, 14:19   #36
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 261
All skills and weap we have for both faction that's why change only gear where TypeID in 35, 120 ,216
SnickQ is offline  
Old 06/21/2015, 19:06   #37
 
elite*gold: 0
Join Date: Jun 2015
Posts: 81
Received Thanks: 136
the way I did it was I used the script released here but moved it to try_gamelogout_r then added a new table to record actions needed after a logout was completed and added a new insert into table script into the action log for the new table so that when the user logs out the full script begins to work so the info isn't overwritten when it comes to clearing the tele points I tried it with out any problems on my 5.4 test server but I didn't add the gear changes to the script its a fc only change like what was release from the main script here

my attempts to do this while the account was still login failed do to the fact the info for the tele points that was clear was over written when the account was logged out

here is my version of the same script with the part to remove the saved tele points

try_gamelogout_r
Code:
USE [PS_UserData]
GO
/****** Object:  StoredProcedure [dbo].[usp_Try_GameLogout_R]    Script Date: 6/21/2015 1:36:04 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/****** Object:  Stored Procedure dbo.usp_Try_GameLogout_R    Script Date: 2008-6-7 18:34:05 ******/
ALTER        Proc [dbo].[usp_Try_GameLogout_R]

/* 
Created by humanws, 2005-10-18
???? ?? ??
*/

@UserUID int,
@SessionID bigint,
@LogoutType smallint = 0,
@ErrType int = 0

AS

SET NOCOUNT ON

DECLARE @LogTime datetime
DECLARE @Sql nvarchar(4000)
DECLARE @yyyy varchar(4)
DECLARE @mm varchar(2)
DECLARE @dd varchar(2)
DECLARE @LogType bit	-- Login:0, Logout:1

SET @LogType = 1
SET @LogTime = GETDATE()
SET @yyyy = DATEPART(yyyy, @LogTime)
SET @mm = DATEPART(mm, @LogTime)
SET @dd = DATEPART(dd, @LogTime)

IF( LEN(@mm) = 1 )
BEGIN
	SET @mm = '0' + @mm
END

IF( LEN(@dd) = 1 )
BEGIN
	SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.UserLog
(SessionID, UserUID, LogType, LogTime, LogoutType, ErrType)
VALUES(@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType)'

EXEC sp_executesql @Sql, 
N'@SessionID bigint, @UserUID int, @LogType bit, @LogTime datetime, @LogoutType smallint, @ErrType int',
@SessionID, @UserUID, @LogType, @LogTime, @LogoutType, @ErrType
update PS_userdata.dbo.UserLoginStatus
set loginstatus=0,[email protected],[email protected],LastPlayTime=datediff(minute,LoginTime,@LogTime)
where [email protected]

DECLARE @LoginTime DATETIME = (SELECT LoginTime FROM PS_UserData.dbo.UserLoginStatus WHERE UserUID = @UserUID)
DECLARE @LastPlayTime INT = (SELECT LastPlayTime FROM PS_UserData.dbo.UserLoginStatus WHERE UserUID = @UserUID)
DECLARE @OldPoint INT = (SELECT Point FROM PS_userdata.dbo.Users_Master WHERE UserUID = @UserUID)
DECLARE @LoginSession BIGINT = (SELECT LoginSession FROM PS_UserData.dbo.UserLoginStatus WHERE UserUID = @UserUID)

IF (@[email protected])
BEGIN
	Update PS_userdata.dbo.Users_Master
	SET Point = Point
	WHERE UserUID = @UserUID
	INSERT INTO PS_UserData.DBO.UserOnlineTimeLog(UserUid,OldPoint,Addpoint,LoginTime,LogoutTime,SessionID)
	VALUES(@UserUid,@OldPoint,@LastPlayTime,@LoginTime,@LogTime,@SessionID)
END

-- FACTION CHANGE BY ALCATRAZ --
DECLARE @L_UserUID INT = (SELECT UserUID FROM LastMin_Changes WHERE UserUID = @UserUID AND FC = 1)
IF @UserUID = @L_UserUID
BEGIN
SELECT CharID INTO #UserChars FROM [PS_GameData].dbo.Chars WHERE UserUID = @UserUID

UPDATE 
PS_GameData.dbo.UserMaxGrow
SET Country = CASE
WHEN Country = 1 THEN 0
WHEN Country = 0 THEN 1
ELSE Country
END
WHERE UserUID = @UserUID

UPDATE PS_GameData.dbo.Chars
SET PosX = 61.000 ,PosY = 1.800 ,PosZ = 67.000	,Map = 42 
WHERE UserUID = @UserUID 

DELETE
FROM [PS_GameData].dbo.CharSavePoint
WHERE CharID IN (SELECT CharID FROM #UserChars)

DROP TABLE #UserChars

DELETE 
FROM PS_UserData.dbo.LastMin_Changes
WHERE UserUID = @UserUID AND FC = 1
END
-- FACTION CHANGE END --
SET NOCOUNT OFF
usp_insert_action_log_e
Code:
USE [PS_GameLog]
GO
/****** Object:  StoredProcedure [dbo].[usp_Insert_Action_Log_E]    Script Date: 6/21/2015 1:40:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER  Proc [dbo].[usp_Insert_Action_Log_E]

@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTime datetime,
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS

-- FACTION CHANGE BY ALCATRAZ --
 IF @ActionType = 112 AND @Text2 = 'use_item' AND @Value2 = 100001 -- 100001 = ETAIN CHANGE TO YOUR ITEM NUMBER THE ITEM MUST BE A CONSUMABLE
BEGIN
	
	INSERT INTO [PS_UserData].[dbo].[LastMin_Changes] VALUES (@UserUID, @CharID, 1, NULL, NULL, NULL)
END
-- FACTION CHANGE END --

SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
	SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
	SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID,  PosX, PosY, PosZ, ActionTime, ActionType, 
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql, 
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50), 
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, 
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int, 
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4
and lastly the newtable I used LastMin_Changes
Code:
USE [PS_UserData]
GO

/****** Object:  Table [dbo].[LastMin_Changes]    Script Date: 6/21/2015 1:43:50 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LastMin_Changes](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[UserUID] [int] NULL,
	[CharID] [int] NULL,
	[FC] [tinyint] NULL,
	[Level] [tinyint] NULL,
	[StatPoints] [int] NULL,
	[SkillPoints] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[RowID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
These scripts work the same way as the earlier released scripts it will only do a faction change and keep the current class but it will also delete all char saved tele points for all chars on that account so you don't have to worry about people teleporting into the other factions maps I also used a consumable item instead of a item being sold currently item is a etain potions

testing included 3 chars all on the same account with full saved tele points on sql 2014 for ep5.4 testing completed with out error, all chars was faction changed, and all tele points was cleared
[Alcatraz] is offline  
Thanks
5 Users
Old 09/17/2015, 10:20   #38
 
elite*gold: 0
Join Date: Sep 2011
Posts: 136
Received Thanks: 9
This fc is for gears account?
I need script.or query for change faction all in account!!
Chatacter
Items
Mounts
Etc....please any1 can give me it?
lolodh is offline  
Old 04/22/2018, 11:07   #39
 
elite*gold: 0
Join Date: Nov 2017
Posts: 118
Received Thanks: 221
this scripts don't work for me
faction changed but chars deleted
XareL is offline  
Old 04/22/2018, 14:17   #40
 
elite*gold: 0
Join Date: Sep 2011
Posts: 407
Received Thanks: 261
Becouse ep 5.4 ps_game.exe not allow appearance of the opposite faction
SnickQ is offline  
Thanks
1 User
Old 04/22/2018, 14:31   #41
 
elite*gold: 0
Join Date: Nov 2017
Posts: 118
Received Thanks: 221
this function editing in ps_game ?
XareL is offline  
Old 08/25/2018, 04:42   #42
 
elite*gold: 0
Join Date: Jul 2018
Posts: 2
Received Thanks: 1
i made different own"Faction Change rune"(normal chest) "Faction Change skill"(show who fced)
its works all episode
this scripts without any error to your game.
i already made query manually has all Codes Start From Level 1 to 70 Gears/Weapons/Capes/Mounts
(Total Valid Code For Light And Dark Row ID 4465)
if you are interested contact me in
image:
wifosagittarius is offline  
Thanks
1 User
Old 08/25/2018, 08:33   #43
 
elite*gold: 0
Join Date: Jul 2013
Posts: 24
Received Thanks: 3
thanks wifo, the script is very good.
Trustworthy seller



Realp0rta is offline  
Reply

Tags
dev, private server, shaiya



« [Tiny Release] Shaiya Episode 1 Game Client (Light & Darkness) | [RELEASE]EP5 files that work »

Similar Threads
[RELEASE] Faction Change
07/19/2016 - Shaiya PServer Guides & Releases - 4 Replies
Hello, I'm Alex new developper of 1 year ago. I will release mine faction change script and some screenshot, it easy to use 1. Download Files. 2. Put on your xampp/hotdocs the 2 files. 3. Open db.config.php put your sql user and password. 4. Open it on your web. 5. Done you can faction change.
hmm anyone have the faction change script
03/10/2015 - Shaiya Private Server - 7 Replies
Since I've searched for it but it only gives dashes database side release not the actual php script if anyone has it if they are willing to share it here so i may have it that would be super thanks. regards legions of shaiya
How can I do faction change ? [EMERGENCY]
09/12/2012 - Shaiya Private Server - 6 Replies
How can I do faction change ? Thx.
Hp Glitch/Faction Change
01/20/2012 - Shaiya Private Server - 4 Replies
Has Any Body Found A Fix For The Hp Glitch?? & Also does anybody have a faction change script?? thankss
S: Faction Change B: Look in.
07/04/2011 - World of Warcraft Trading - 0 Replies
Wie oben beschrieben suche ich nen Faction Change, und ich biete dafür, den Basic Bot, von Pirox, und level / farm dienste! PM ME!



All times are GMT +1. The time now is 22:11.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.