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^
Printable View
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^
Thanks Brat.. testing :)
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?Quote:
Originally Posted by christoper
stfu , think before post!
Is not good, if u change nick, all characters nick will have same nick like the one you change
PHP Code:$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'");
ha ha can fix ?
first u need to get GameID from the char name,, and use the "IF" :D
i will try to fix it,if i will have time tomorrow will be ready
P.S: nice idea kudo
Kudo^ this is not your work . I've downloaded this php script some days ago from an old thread .
:xmas:
Code:$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'
";
Not my work ?!?!?!?!?! :fyou:Quote:
Originally Posted by PsychoJr
THINK BEFORE POST!!!!!!!!!!!
If you fount it somewhere it's because i have released it some time ago(it's old!)
nothing new^^
Then why release it again...:punch:Quote:
Originally Posted by Kudo^
haha...Answer now xD!Quote:
Originally Posted by RayOfLight
Anyway thnx
still...not a gud idea....ppl on your server will keep spamming and then change nick...
yup nothing new :)