-
mucore name change
PHP Code:
$query = $core_db->Execute("select Name from Character where AccountID='".$user_auth_id."'"); $mychars= ''; while($char=mssql_fetch_array($query)) { $mychars.="<option class=\"clchg\" value=\"".htmlspecialchars($query->fields[0])."\">".iconv("gb2312","utf-8",$query->fields[0])."</option>"; }
use ODBC Abnormal connection
mssql_fetch_array Wrong
Complete code below
PHP Code:
<?php$name_settings = simplexml_load_file('engine/config_mods/name_change.xml');$price = $name_settings->price;
if ($_POST['newname']) { $online_check = $core_db->Execute("SELECT ConnectStat FROM MEMB_STAT WHERE memb___id='$user_auth_id'"); $character = HTMLSpecialChars(trim($_POST['character']), ENT_QUOTES); $$result = $core_db->Execute("select [AccountID] from [Character] where [Name]='".$character."'"); $mycred = $core_db->Execute("SELECT WCoinC FROM GameShopPoint WHERE AccountID='$user_auth_id'"); $guildcheck = $core_db->Execute("select [Name] from [GuildMember] where [Name]='".$character."'"); //check ci mas dostatok kreditov if ($price > $mycred->fields[0]) { echo msg('0','没有足够的 WCoinC点.'); } //check ci ti patri postava else if ($result->fields[0] != $user_auth_id) { echo msg('0','This character doesn\'t belongs to you.'); } //check ci is offline else if($online_check->fields[0] != 0 ) { echo msg('0','您的帐户正在使用中,请断开连接.'); } else if (strlen($_POST['newname']) < 3 || strlen($_POST['newname']) > 10) { echo msg('0','您的角色名必须有3-10字符.'); } else if($guildcheck->fields[0] != NULL) { echo msg('0','您必须退出战盟才能更改角色名.'); } else { $newname = HTMLSpecialChars(trim($_POST['newname']), ENT_QUOTES); $result = $core_db->Execute("select [Name] from [Character] where [Name]='".$newname."'"); if ($result->fields[0]) { echo msg('0','该角色名已被使用.'); } else { $v = $core_db->Execute(" update [Character] set [Name]='".$newname."' where [Name]='".$character."'; update [AccountCharacter] set [GameID1]='".$newname."' where [GameID1]='".$character."'; update [AccountCharacter] set [GameID2]='".$newname."' where [GameID2]='".$character."'; update [AccountCharacter] set [GameID3]='".$newname."' where [GameID3]='".$character."'; update [AccountCharacter] set [GameID4]='".$newname."' where [GameID4]='".$character."'; update [AccountCharacter] set [GameID5]='".$newname."' where [GameID5]='".$character."'; update [AccountCharacter] set [GameIDC]='".$newname."' where [GameIDC]='".$character."'; update [Guild] set [G_Master]='".$newname."' where [G_Master]='".$character."'; update [GuildMember] set [Name]='".$newname."' where [Name]='".$character."'; update [T_WaitFriend] set [FriendName]='".$newname."' where [FriendName]='".$character."'; update [T_FriendMail] set [FriendName]='".$newname."' where [FriendName]='".$character."'; update [T_FriendMain] set [Name]='".$newname."' where [Name]='".$character."'; update [T_CGuid] set [Name]='".$newname."' where [Name]='".$character."'; update [OptionData] set [Name]='".$newname."' where [Name]='".$character."'; update [GameShopPoint] set [WCoinC] = [WCoinC] - '".$price."' where [AccountID]='".$user_auth_id."'; "); if($v) echo msg('1', "您的角色名已更改成功."); else echo msg('0', "ERROR: ".mssql_get_last_message()); } } } print '<fieldset style="width=100%"><legend class="mu_style2" style="padding: 0px;font-weight:bold;">更改角色名 </legend><div>'; $query = $core_db->Execute("select Name from Character where AccountID='".$user_auth_id."'"); $mychars= ''; while($char=mssql_fetch_array($query)) { $mychars.="<option class=\"clchg\" value=\"".htmlspecialchars($query->fields[0])."\">".iconv("gb2312","utf-8",$query->fields[0])."</option>"; } print '<form method="post" action=""> <table width=300PX border=0 cellpadding=2 cellspacing=3><tr><td>角色: </td><td><select style="color: #000000;" id="character" name="character"><optgroup label="选择一个角色">'.$mychars.'</select></td></tr><tr><td>新角色名: </td><td> <input type="text" name="newname" id="newname" maxlength="10" size="10"> (3-10 字符)</td></tr><tr><td><b>'.$price.'</b> WCoinC</td><td><input type="Submit" value="更改"></td></tr></table>'; print '</form>'; print '</fieldset></div><br><br>';
?>
<fieldset><legend>注意</legend><div align="justify">在使用更改角色名之前,必须先离开战盟.</div></fieldset>