hmm anyone have the faction change script

~~retrogod~~ · 09/10/2012, 10:35

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

TeddyBear94 · 09/10/2012, 15:14

i only got a faction change script as sql one not as php one ö.ö

UPDATE [GameData].[dbo].[UserMaxGrow]

SET Country= '0'
WHERE UserUID= '0

ShaiyaOmega · 09/10/2012, 16:46

I am not sure where it came from but here is one i have stored...

JuuF · 09/10/2012, 16:59

If you didnt add class names manually to your database, you have to delete this part from fc.txt ;

Quote:

UPDATE PS_GameData.dbo.Chars
SET [Class] = (
CASE
WHEN Class='Fighter' THEN 'Warrior'
WHEN Class='Warrior' THEN 'Fighter'
WHEN Class='Defender' THEN 'Guardian'
WHEN Class='Guardian' THEN 'Defender'
WHEN Class='Ranger' THEN 'Assassin'
WHEN Class='Assassin' THEN 'Ranger'
WHEN Class='Priest' THEN 'Oracle'
WHEN Class='Oracle' THEN 'Priest'
WHEN Class='Archer' THEN 'Hunter'
WHEN Class='Hunter' THEN 'Archer'
WHEN Class='Mage' THEN 'Pagan'
WHEN Class='Pagan' THEN 'Mage'

ELSE Class
END)
WHERE UserUID=@User
PRINT 'toon changed sucessfully'

Credits goes to Dash o,o

~~retrogod~~ · 09/10/2012, 19:35

Quote:

Originally Posted by JuuF

If you didnt add class names manually to your database, you have to delete this part from fc.txt ;

Credits goes to Dash o,o

nope dash may have made the database side but my freind made the script himself so if anything Mystery gets credits for the php scripting
aka foxy
<html>
<head>
<title>Faction Change</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">
body,td,th {
color: #FFF;
font-size: xx-large;
}

body {
background-color: #000;
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<form action="processorfc.php" method="POST" class="style1">
<fieldset>

Quote:

Demonic Shaiya Faction Change<----he made this when running demonic shaiya so yea

<p>
<label for="login">User ID
<input type="text" name="userid"/><p>
<label for="pass">Password
<input type="password"name="pass"/><p>
<input type=submit class=Butt value='Submit'>
</fieldset>
</form>
</body>
</html>

JuuF · 09/10/2012, 19:51

Quote:

Originally Posted by retrogod

nope dash may have made the database side but my freind made the script himself so if anything Mystery gets credits for the php scripting
aka foxy

Did i say anything about it? Please be sure what i am talking about.. I didnt say Dash made it, i just said Credits goes to Dash for FIX.

~~retrogod~~ · 09/10/2012, 20:23

Quote:

Originally Posted by JuuF

Did i say anything about it? Please be sure what i am talking about.. I didnt say Dash made it, i just said Credits goes to Dash for FIX.

you stated credits go to dash but yet never stated what exactly so you could have been more specific next time. thanks regards legions of shaiya

[GM]Precious · 03/10/2015, 12:51

Thanks for the release. I tried it and works on SQL 2008/R2 both faction change and item change but had issues on SQL 2012, it changes the faction correctly but the Items remain the same.

Anyone knows what might be the problem?