Register for your free account! | Forgot your password?

You last visited: Today at 00:37

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

Advertisement



[Release]Exchange script Faction

Discussion on [Release]Exchange script Faction within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
[Dev]Matheus's Avatar
 
elite*gold: 0
Join Date: May 2013
Posts: 60
Received Thanks: 44
[Release]Exchange script Faction

My scripts to change faction

Code:
-- 1. First: Put Character Name in.
Declare @Name as varchar(255)
Set @Name='xxxx' --Place Character name of the person here.

-- This searches for their Current Family and Job (and to see if it is the right person) when script is Executed.
--(Theres after change checkup too, to see if the Family and Job changed to right ones.)
Select UserID, UserUID, CharID, CharName, Del, Family, Job, Level, LoginStatus From PS_GameData.dbo.Chars Where CharName=@Name and Del='0'

-- 2. Second: Put the New Family Value they want.
Update PS_GameData.dbo.Chars
Set Family='0' -- Warning:If runned empty then changes value to 0.
-- For Family: 0 Human / 1 Elves / 2 Vail / 3 Nordein
Where CharName=@Name and Del='0'

-- 3. Third: Put the New Job Value they want.
Update PS_GameData.dbo.Chars
Set Job='0' -- Warning:If runned empty then changes value to 0.
-- For Job: 0 Warrior-Fighter / 1 Guardian-Defender / 2 Assassin-Ranger
-- 3 Hunter-Archer / 4 Pagan-Mage / 5 Oracle-Priest
Where CharName=@Name and Del='0'

-- This is the After change checkup to compare Old Family and Job to New values when script is Executed.
Select UserID, UserUID, CharID, CharName, Del, Family, Job, Level, LoginStatus From PS_GameData.dbo.Chars Where CharName=@Name and Del='0'
Credits: Unknown
[Dev]Matheus is offline  
Thanks
4 Users
Old 04/30/2015, 22:44   #2
 
elite*gold: 0
Join Date: Jul 2009
Posts: 352
Received Thanks: 83
dose any 1 no why u carnt do this on the 5.4 ps_game seems to make the toon unuseable on my 5.0 server i was able to do fighters on fury faction and warriors on light faction .ect but with 5.4 ps_game it seems to make the account unuseable any ideas ?
Big_ is offline  
Reply


Similar Threads Similar Threads
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
My Faction change script
11/29/2013 - Shaiya PServer Guides & Releases - 4 Replies
this has posably been released some were but i forget if i have seen it around so i will releace my faction change quary i created with help from tyler. as far as i remember ( been a while sence i used it) everything is 100% acuret and workeing EXCEPT some wepons dont swap acuretly as i had multy used wepons meaning mixed faction style wepons. i can go thrue when i have a bit more time on my hands and acuretly add ALL wepons to alow swapeing of them to exact counter faction wepons. i hope you...
[Tut] Exchange Script
07/11/2011 - Flyff Private Server - 6 Replies
1. Schritt: Ihr sucht euch ein Script aus was ihr wollt. 2. Schritt: Ihr ändert es, wie ihr es wollt. Ich erkläre es jetzt an dem Beispiel Topaz Pieces SET TID_GAME_COLLECT_COND04 //Name der Funktion {
Script for exchange market
12/19/2009 - Rohan - 5 Replies
hello, how works that script in exchange market which auto-buy high level items and characters at a low price?



All times are GMT +2. The time now is 00:37.


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.