Change nick php script

[Kudo^]

Hello everyone there, i have nothing to say you all, test and report bugs.

=Master= , please check my code if there is something wrong fix it and share with people, i did my best.

Credits : Kudo^

[MentaL]

[Booms]

Thanks Brat.. testing :)

[christoper]

SSS? Please.. i wanna see Example can you put SSS Please

[Kudo^]

SSS? Please.. i wanna see Example can you put SSS Please

You need an screenshot of a simple page with login field , password , old nick new nick?
stfu , think before post!

[=Master=]

Is not good, if u change nick, all characters nick will have same nick like the one you change

    $query4 = mssql_query("UPDATE AccountCharacter SET GameID1 = '$newnick' WHERE GameID1 = '$oldnick' AND Id = '$login'");
    $query5 = mssql_query("UPDATE AccountCharacter SET GameID2 = '$newnick' WHERE GameID2 = '$oldnick' AND Id = '$login'");
    $query6 = mssql_query("UPDATE AccountCharacter SET GameID3 = '$newnick' WHERE GameID3 = '$oldnick' AND Id = '$login'");
    $query7 = mssql_query("UPDATE AccountCharacter SET GameID4 = '$newnick' WHERE GameID4 = '$oldnick' AND Id = '$login'");
    $query8 = mssql_query("UPDATE AccountCharacter SET GameID5 = '$newnick' WHERE GameID5 = '$oldnick' AND Id = '$login'");
    $query9 = mssql_query("UPDATE AccountCharacter SET GameIDC = '$newnick' WHERE GameIDC = '$oldnick' AND Id = '$login'"); 

[oleg35]

ha ha can fix ?

[penihop]

first u need to get GameID from the char name,, and use the "IF" :D

[[RCZ]ShadowKing]

i will try to fix it,if i will have time tomorrow will be ready
P.S: nice idea kudo

[PsychoJr]

Kudo^ this is not your work . I've downloaded this php script some days ago from an old thread .

[oggyss]

:xmas:

$msquery="
    Update dbo.AccountCharacter
	SET GameID1 = '$new_nick'  WHERE GameID1 = '$old_nick' and Id = '$login'
	Update dbo.AccountCharacter
	SET GameID2 = '$new_nick'  WHERE GameID2 = '$old_nick' and Id = '$login'
	Update dbo.AccountCharacter
	SET GameID3 = '$new_nick'  WHERE GameID3 = '$old_nick' and Id = '$login'
	Update dbo.AccountCharacter
	SET GameID4 = '$new_nick'  WHERE GameID4 = '$old_nick' and Id = '$login'
	Update dbo.AccountCharacter
	SET GameID5 = '$new_nick'  WHERE GameID5 = '$old_nick' and Id = '$login'
	Update dbo.Character
	SET Name = '$new_nick' WHERE AccountID = '$login' AND Name = '$old_nick'
	Update dbo.Guild
	SET G_Master = '$new_nick' WHERE G_Master = '$old_nick'
	Update dbo.GuildMember
	SET Name = '$new_nick' WHERE Name = '$old_nick'
	Update dbo.T_CGuid
	SET Name = '$new_nick' WHERE Name = '$old_nick'
	Update dbo.T_FriendList
	SET FriendName = '$new_nick' WHERE FriendName = '$old_nick'
	Update dbo.T_FriendMail
	SET FriendName = '$new_nick' WHERE FriendName = '$old_nick'
	Update dbo.T_FriendMain
	SET Name = '$new_nick' WHERE Name = '$old_nick'
	Update dbo.T_WaitFriend
	SET FriendName = '$new_nick' WHERE FriendName = '$old_nick'
	Update dbo.OptionData
	SET Name = '$new_nick' WHERE Name = '$old_nick'
	";

[Kudo^]

Kudo^ this is not your work . I've downloaded this php script some days ago from an old thread .

Not my work ?!?!?!?!?! :fyou:
THINK BEFORE POST!!!!!!!!!!!
If you fount it somewhere it's because i have released it some time ago(it's old!)

[DarkMaster.]

nothing new^^

[RayOfLight]

Not my work ?!?!?!?!?! :fyou:
THINK BEFORE POST!!!!!!!!!!!
If you fount it somewhere it's because i have released it some time ago(it's old!)

Then why release it again...:punch:

[BoneDragoN]

Then why release it again...:punch:

haha...Answer now xD!

Anyway thnx

[netaxis200]

still...not a gud idea....ppl on your server will keep spamming and then change nick...