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^

 

[Booms]

Re: [Release] Change nick php script

Thanks Brat.. testing

 

[christoper]

Re: [Release] Change nick php script

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

 

[Kudo^]

Re: [Release] Change nick php script

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=]

Re: [Release] Change nick php script

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]

Re: [Release] Change nick php script

ha ha can fix ?

 

[penihop]

Re: [Release] Change nick php script

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

 

[[RCZ]ShadowKing]

Re: [Release] Change nick php script

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

 

[PsychoJr]

Re: [Release] Change nick php script

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

 

[oggyss]

Re: [Release] Change nick php script

: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^]

Re: [Release] Change nick php script

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.]

Re: [Release] Change nick php script

nothing new^^

 

[RayOfLight]

Re: [Release] Change nick php script

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...unch:

 

[BoneDragoN]

Re: [Release] Change nick php script

Then why release it again...unch:

haha...Answer now xD!

Anyway thnx

 

[netaxis200]

Re: [Release] Change nick php script

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

 

[Lisko]

Re: [Release] Change nick php script

yup nothing new