Как исправить ошибку открытия Гильдии в MU Online

[Platinum]

Из личных побуждений использую именно 4.3 демо.
При открытии Гильдии выскакивает ошибка:
Warning: mssql_query() [function.mssql-query]: message: Cannot resolve collation conflict for equal to operation. (severity 16) in C:AppServwwwpgsguildinfo.php on line 1

Warning: mssql_query() [function.mssql-query]: Query failed in C:AppServwwwpgsguildinfo.php on line 1

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:AppServwwwpgsguildinfo.php on line 1
Может кто- нибудь помочь?

Из личных побуждений использую именно 4.3 демо.
При открытии Гильдии выскакивает ошибка:
Warning: mssql_query() [function.mssql-query]: message: Cannot resolve collation conflict for equal to operation. (severity 16) in C:AppServwwwpgsguildinfo.php on line 1

Warning: mssql_query() [function.mssql-query]: Query failed in C:AppServwwwpgsguildinfo.php on line 1

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:AppServwwwpgsguildinfo.php on line 1
Может кто- нибудь помочь?

Под спойлером привел весь guildinfo.php

Спойлер

<? /* Enemy Mu Web Demo Version 4.3. Coded by GrInYa. ICQ: 392409945. Skype: grinya_90. Full version you can get only from my self */ ?> <?php include ("functions/getclass.php"); include ("functions/guildlogo.php"); if (!isset($_GET['guild_name'])) { exit("<center>Guild Not Found!</center>"); } $guild_name = $_GET['guild_name']; print "<h4>".guild_info.": $guild_name</h4> <table id='pgs' style='margin:0px auto;' border='0' cellspacing='0' cellpadding='0'><tr><td>"; $hide_nicks = explode(',', $top['hide_nicks']); $i = 0; do { $nick_hide = "and character.name != '$hide_nicks[$i]' "; $i++; } while ($i < count($hide_nicks)); if ($top['hide_gm'] == 1) { $hide_gm = 'and CtlCode != 8 and CtlCode != 10 and CtlCode != 12 and CtlCode != 32'; } else { $hide_gm = ''; } $result = mssql_query("SELECT character.name,class,clevel,G_Mark,gu.G_Name,G_Score,G_Notice,$reset_column,accountid,ctlcode$masterlevel from character$masterleveltable_,guildmember g,guild gu where 1=1 $masterlevelwhere_ $nick_hide $hide_gm and g.G_name = '$guild_name' and gu.G_name = '$guild_name' and character.name = g.name order by $reset_column$masterlevelorder,clevel desc"); $result3 = mssql_query("select Name from guildmember where g_status=64 and G_name = '$guild_name'"); if (mssql_num_rows($result3) > 0) { $myrow3 = mssql_fetch_array($result3); do { $assistant .= "$myrow3

• "; } while ($myrow3 = mssql_fetch_array($result3)); } $result4 = mssql_query("select Name from guildmember where g_status=32 and G_name = '$guild_name'"); if (mssql_num_rows($result4) > 0) { $myrow4 = mssql_fetch_array($result4); do { $battlemaster .= "$myrow4
• "; } while ($myrow4 = mssql_fetch_array($result4)); } if (mssql_num_rows($result) > 0) { $result2 = mssql_query("SELECT count(*),G_Master from guildmember gm,guild g where gm.G_name = '$guild_name' and g.G_name = '$guild_name' group by g_master"); $myrow2 = mssql_fetch_array($result2); $myrow = mssql_fetch_array($result); $id = 1; echo "<table style='margin:0px auto;' border='0' cellpadding='1' cellspacing='5'> <tr> <td rowspan='7' align=center>".guildlogo($myrow['G_Mark'],15)."</td> <td align=right><strong>".guild_gname."</strong></td> <td><strong>$myrow[G_Name]</strong></a></td> </tr> <tr> <td align=right><strong>".guild_gmaster."</strong></td> <td>".nickname($myrow2[1])."</td> </tr> <tr><td align=right><strong>".guild_gscore."</strong></td><td>$myrow[G_Score]</td></tr> <tr><td align=right><strong>".guild_gmembers."</strong></td><td>$myrow2
• </td></tr> <tr><td align=right><strong>".guild_gassist."</strong></td><td>$assistant</td></tr> <tr><td align=right><strong>".guild_gbm."</strong></td><td>$battlemaster</td></tr> <tr><td align=right><strong>".guild_gnotice."</strong></td><td>$myrow[G_Notice]</td></tr> </table>"; echo "<table width='100%' align=center border='0' cellpadding='1' cellspacing='1'> <tr class='top_table'> <td><b>№</b></td> <td><b>".table_name."</b></td> <td><b>".table_class."</b></td> <td><b>".table_level."$mlvlname<br>"; if ($Option['is_resets'] == 1){ echo "( ".table_reset; echo " )"; } print "</b></td> <td><b>".server_stat."</b></td> </tr>"; do { $result2 = mssql_query("Select ConnectStat from MEMB_STAT where memb___id = '$myrow[accountid]'"); $myrow2 = mssql_fetch_array($result2); $result3 = mssql_query("SELECT G_name from GuildMember where name = '$myrow[name]'"); $myrow3 = mssql_fetch_array($result3); if ($myrow2['ConnectStat'] == '1') { $result4 = mssql_query("Select GameIDC from AccountCharacter where Id = '$myrow[accountid]'"); $result4 = mssql_fetch_array($result4); } if ($result4['GameIDC'] == $myrow['name']) { $myrow2['ConnectStat'] = '1'; } else { $myrow2['ConnectStat'] = '0'; } if ($myrow2['ConnectStat'] == '0') { $myrow2['ConnectStat'] = "<font color='red'>".status_offline."</font>"; } if ($myrow2['ConnectStat'] == '1') { $myrow2['ConnectStat'] = "<font color='#A0FFA0'>".status_online."</font>"; } $mlevel = NULL; if ($server['Season4Master'] == 1) { $mlevel = " / <font color='#84FF00'>".$myrow[$masterlevel_]."</font>"; } if ($Option['is_resets'] == 1) { $reset = " ( $myrow[$reset_column]"; $reset .= " )"; } printf ("<tr class='contet_table' align='center'> <td><b>%s</b></td> <td>%s</td> <td>%s</td> <td>%s%s%s</td> <td>%s</td> </tr>", $id, $myrow
• , char_class($myrow['class']), $myrow['clevel'], $mlevel, $reset, $myrow2['ConnectStat']); $id++; } while ($myrow = mssql_fetch_array($result)); } else { exit("<center>".something_wrong."</center>"); } echo "</table>"; ?></td></tr></table>

[свернуть]

[ShoT]

Наподобии такого когда-то было.... С EMW 4.2 стяни guildinfo.php и переинсталь сайт...
И зачем ты поставил 4.3 Demo если на форуме есть 4.3 Premium?

[epmak]

И зачем ты поставил 4.3 Demo если на форуме есть 4.3 Premium?

Из личных побуждений использую именно 4.3 демо.

проблема не в вебе, а в колейшене в базе. при запросе используется обращение не  1 базе, а ему и выдает
"Cannot resolve collation conflict for equal to operation." на русском примерно:

Не удается разрешить конфликт параметров сортировки для равной операции.

©гугл
в общем есть 3 варианта:
1. написать грине
2. переписать щапросы
3. проследить чтобы collation у всех таблиц, учавствующих в запросе был одинаковый или соответствовал колайшену в запросе(код неразборчивый, сплошной, поэтому не читал)

[GrInYa]

Спойлер

Код Выделить Развернуть

<? /* Enemy Mu Web Demo Version 4.3. Coded by GrInYa. ICQ: 392409945. Skype: grinya_90. Full version you can get only from my self */ ?> <?php include ("functions/getclass.php"); include ("functions/guildlogo.php"); if (!isset($_GET['guild_name'])) { exit("<center>Guild Not Found!</center>"); } $guild_name = $_GET['guild_name']; print "<h4>".guild_info.": $guild_name</h4> <table id='pgs' style='margin:0px auto;' border='0' cellspacing='0' cellpadding='0'><tr><td>"; $hide_nicks = explode(',', $top['hide_nicks']); $i = 0; do { $nick_hide = "and character.name != '$hide_nicks[$i]' "; $i++; } while ($i < count($hide_nicks)); if ($top['hide_gm'] == 1) { $hide_gm = 'and CtlCode != 8 and CtlCode != 10 and CtlCode != 12 and CtlCode != 32'; } else { $hide_gm = ''; } $result = mssql_query("SELECT character.name,class,clevel,G_Mark,gu.G_Name,G_Score,G_Notice,$reset_column,accountid,ctlcode$masterlevel from character$masterleveltable_,guildmember g,guild gu where 1=1 $masterlevelwhere_ $nick_hide $hide_gm and g.G_name = '$guild_name' and gu.G_name = '$guild_name' and character.name COLLATE DATABASE_DEFAULT = g.name COLLATE DATABASE_DEFAULT order by $reset_column$masterlevelorder,clevel desc"); $result3 = mssql_query("select Name from guildmember where g_status=64 and G_name = '$guild_name'"); if (mssql_num_rows($result3) > 0) { $myrow3 = mssql_fetch_array($result3); do { $assistant .= "$myrow3[0] "; } while ($myrow3 = mssql_fetch_array($result3)); } $result4 = mssql_query("select Name from guildmember where g_status=32 and G_name = '$guild_name'"); if (mssql_num_rows($result4) > 0) { $myrow4 = mssql_fetch_array($result4); do { $battlemaster .= "$myrow4[0] "; } while ($myrow4 = mssql_fetch_array($result4)); } if (mssql_num_rows($result) > 0) { $result2 = mssql_query("SELECT count(*),G_Master from guildmember gm,guild g where gm.G_name = '$guild_name' and g.G_name = '$guild_name' group by g_master"); $myrow2 = mssql_fetch_array($result2); $myrow = mssql_fetch_array($result); $id = 1; echo "<table style='margin:0px auto;' border='0' cellpadding='1' cellspacing='5'> <tr> <td rowspan='7' align=center>".guildlogo($myrow['G_Mark'],15)."</td> <td align=right><strong>".guild_gname."</strong></td> <td><strong>$myrow[G_Name]</strong></a></td> </tr> <tr> <td align=right><strong>".guild_gmaster."</strong></td> <td>".nickname($myrow2[1])."</td> </tr> <tr><td align=right><strong>".guild_gscore."</strong></td><td>$myrow[G_Score]</td></tr> <tr><td align=right><strong>".guild_gmembers."</strong></td><td>$myrow2[0]</td></tr> <tr><td align=right><strong>".guild_gassist."</strong></td><td>$assistant</td></tr> <tr><td align=right><strong>".guild_gbm."</strong></td><td>$battlemaster</td></tr> <tr><td align=right><strong>".guild_gnotice."</strong></td><td>$myrow[G_Notice]</td></tr> </table>"; echo "<table width='100%' align=center border='0' cellpadding='1' cellspacing='1'> <tr class='top_table'> <td><b>№</b></td> <td><b>".table_name."</b></td> <td><b>".table_class."</b></td> <td><b>".table_level."$mlvlname<br>"; if ($Option['is_resets'] == 1){ echo "( ".table_reset; echo " )"; } print "</b></td> <td><b>".server_stat."</b></td> </tr>"; do { $result2 = mssql_query("Select ConnectStat from MEMB_STAT where memb___id = '$myrow[accountid]'"); $myrow2 = mssql_fetch_array($result2); $result3 = mssql_query("SELECT G_name from GuildMember where name = '$myrow[name]'"); $myrow3 = mssql_fetch_array($result3); if ($myrow2['ConnectStat'] == '1') { $result4 = mssql_query("Select GameIDC from AccountCharacter where Id = '$myrow[accountid]'"); $result4 = mssql_fetch_array($result4); } if ($result4['GameIDC'] == $myrow['name']) { $myrow2['ConnectStat'] = '1'; } else { $myrow2['ConnectStat'] = '0'; } if ($myrow2['ConnectStat'] == '0') { $myrow2['ConnectStat'] = "<font color='red'>".status_offline."</font>"; } if ($myrow2['ConnectStat'] == '1') { $myrow2['ConnectStat'] = "<font color='#A0FFA0'>".status_online."</font>"; } $mlevel = NULL; if ($server['Season4Master'] == 1) { $mlevel = " / <font color='#84FF00'>".$myrow[$masterlevel_]."</font>"; } if ($Option['is_resets'] == 1) { $reset = " ( $myrow[$reset_column]"; $reset .= " )"; } printf ("<tr class='contet_table' align='center'> <td><b>%s</b></td> <td>%s</td> <td>%s</td> <td>%s%s%s</td> <td>%s</td> </tr>", $id, $myrow[0], char_class($myrow['class']), $myrow['clevel'], $mlevel, $reset, $myrow2['ConnectStat']); $id++; } while ($myrow = mssql_fetch_array($result)); } else { exit("<center>".something_wrong."</center>"); } echo "</table>"; ?></td></tr></table>

[свернуть]

[Platinum]

Спойлер

Код Выделить Развернуть

<? /* Enemy Mu Web Demo Version 4.3. Coded by GrInYa. ICQ: 392409945. Skype: grinya_90. Full version you can get only from my self */ ?> <?php include ("functions/getclass.php"); include ("functions/guildlogo.php"); if (!isset($_GET['guild_name'])) { exit("<center>Guild Not Found!</center>"); } $guild_name = $_GET['guild_name']; print "<h4>".guild_info.": $guild_name</h4> <table id='pgs' style='margin:0px auto;' border='0' cellspacing='0' cellpadding='0'><tr><td>"; $hide_nicks = explode(',', $top['hide_nicks']); $i = 0; do { $nick_hide = "and character.name != '$hide_nicks[$i]' "; $i++; } while ($i < count($hide_nicks)); if ($top['hide_gm'] == 1) { $hide_gm = 'and CtlCode != 8 and CtlCode != 10 and CtlCode != 12 and CtlCode != 32'; } else { $hide_gm = ''; } $result = mssql_query("SELECT character.name,class,clevel,G_Mark,gu.G_Name,G_Score,G_Notice,$reset_column,accountid,ctlcode$masterlevel from character$masterleveltable_,guildmember g,guild gu where 1=1 $masterlevelwhere_ $nick_hide $hide_gm and g.G_name = '$guild_name' and gu.G_name = '$guild_name' and character.name COLLATE DATABASE_DEFAULT = g.name COLLATE DATABASE_DEFAULT order by $reset_column$masterlevelorder,clevel desc"); $result3 = mssql_query("select Name from guildmember where g_status=64 and G_name = '$guild_name'"); if (mssql_num_rows($result3) > 0) { $myrow3 = mssql_fetch_array($result3); do { $assistant .= "$myrow3[0] "; } while ($myrow3 = mssql_fetch_array($result3)); } $result4 = mssql_query("select Name from guildmember where g_status=32 and G_name = '$guild_name'"); if (mssql_num_rows($result4) > 0) { $myrow4 = mssql_fetch_array($result4); do { $battlemaster .= "$myrow4[0] "; } while ($myrow4 = mssql_fetch_array($result4)); } if (mssql_num_rows($result) > 0) { $result2 = mssql_query("SELECT count(*),G_Master from guildmember gm,guild g where gm.G_name = '$guild_name' and g.G_name = '$guild_name' group by g_master"); $myrow2 = mssql_fetch_array($result2); $myrow = mssql_fetch_array($result); $id = 1; echo "<table style='margin:0px auto;' border='0' cellpadding='1' cellspacing='5'> <tr> <td rowspan='7' align=center>".guildlogo($myrow['G_Mark'],15)."</td> <td align=right><strong>".guild_gname."</strong></td> <td><strong>$myrow[G_Name]</strong></a></td> </tr> <tr> <td align=right><strong>".guild_gmaster."</strong></td> <td>".nickname($myrow2[1])."</td> </tr> <tr><td align=right><strong>".guild_gscore."</strong></td><td>$myrow[G_Score]</td></tr> <tr><td align=right><strong>".guild_gmembers."</strong></td><td>$myrow2[0]</td></tr> <tr><td align=right><strong>".guild_gassist."</strong></td><td>$assistant</td></tr> <tr><td align=right><strong>".guild_gbm."</strong></td><td>$battlemaster</td></tr> <tr><td align=right><strong>".guild_gnotice."</strong></td><td>$myrow[G_Notice]</td></tr> </table>"; echo "<table width='100%' align=center border='0' cellpadding='1' cellspacing='1'> <tr class='top_table'> <td><b>№</b></td> <td><b>".table_name."</b></td> <td><b>".table_class."</b></td> <td><b>".table_level."$mlvlname<br>"; if ($Option['is_resets'] == 1){ echo "( ".table_reset; echo " )"; } print "</b></td> <td><b>".server_stat."</b></td> </tr>"; do { $result2 = mssql_query("Select ConnectStat from MEMB_STAT where memb___id = '$myrow[accountid]'"); $myrow2 = mssql_fetch_array($result2); $result3 = mssql_query("SELECT G_name from GuildMember where name = '$myrow[name]'"); $myrow3 = mssql_fetch_array($result3); if ($myrow2['ConnectStat'] == '1') { $result4 = mssql_query("Select GameIDC from AccountCharacter where Id = '$myrow[accountid]'"); $result4 = mssql_fetch_array($result4); } if ($result4['GameIDC'] == $myrow['name']) { $myrow2['ConnectStat'] = '1'; } else { $myrow2['ConnectStat'] = '0'; } if ($myrow2['ConnectStat'] == '0') { $myrow2['ConnectStat'] = "<font color='red'>".status_offline."</font>"; } if ($myrow2['ConnectStat'] == '1') { $myrow2['ConnectStat'] = "<font color='#A0FFA0'>".status_online."</font>"; } $mlevel = NULL; if ($server['Season4Master'] == 1) { $mlevel = " / <font color='#84FF00'>".$myrow[$masterlevel_]."</font>"; } if ($Option['is_resets'] == 1) { $reset = " ( $myrow[$reset_column]"; $reset .= " )"; } printf ("<tr class='contet_table' align='center'> <td><b>%s</b></td> <td>%s</td> <td>%s</td> <td>%s%s%s</td> <td>%s</td> </tr>", $id, $myrow[0], char_class($myrow['class']), $myrow['clevel'], $mlevel, $reset, $myrow2['ConnectStat']); $id++; } while ($myrow = mssql_fetch_array($result)); } else { exit("<center>".something_wrong."</center>"); } echo "</table>"; ?></td></tr></table>

[свернуть]

Thx.
Так же взгляни пожалуйста под спойлер, тут надеюсь тоже поправишь. В админ панели "редактор аккаунта" при вводе имени персонажа вылетает

Спойлер

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'from'. (severity 15) in C:AppServwwwpgsmngeacc.php on line 1

Warning: mssql_query() [function.mssql-query]: Query failed in C:AppServwwwpgsmngeacc.php on line 1

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:AppServwwwpgsmngeacc.php on line 1

[свернуть]

и сам файл mngeacc.php

Спойлер

<? /* Enemy Mu Web Demo Version 4.3. Coded by GrInYa. ICQ: 392409945. Skype: grinya_90. Full version you can get only from my self */ ?> <?php include ("adminaccess.php"); include ("functions/getclass.php"); include ("functions/pklevel.php"); include ("functions/getmap.php"); include ("functions/getstatus.php"); print "<h4>".admin_char."</h4> <table id='pgs' style='margin:0px auto;' border='0' cellspacing='0' cellpadding='0'><tr><td>"; ?><table width="100%" cellpadding="0" cellspacing="0"><tr valign="top"><td width="50%"> <table border='0' cellspacing='0' width="100%" cellpadding='0'><tr><td> <form onsubmit="request('form_s','sh_','POST','getpage.php?cat=Account-Manager'); return false;" id="form_s"> <? echo char_name;?>: <input name="char_name" type="text" size="14" maxlength="10"> <input name="edit_char" type="submit" value="GO"> </form> <? if (isset($_POST['save_edit'])) { $name = stripslashes($_POST['name']); $clevel = $_POST['clevel']; $mlevel = $_POST['mlevel']; $leveluppoint = $_POST['leveluppoint']; $class = $_POST['class']; $strength = $_POST['strength']; $dexterity = $_POST['dexterity']; $vitality = $_POST['vitality']; $energy = $_POST['energy']; $money = $_POST['money']; $mapnumber = $_POST['mapnumber']; $mapposx = $_POST['mapposx']; $mapposy = $_POST['mapposy']; $pkcount = $_POST['pkcount']; $pklevel = $_POST['pklevel']; $pktime = $_POST['pktime']; $ctlcode = $_POST['ctlcode']; $leadership = $_POST['leadership']; $resets = $_POST['resets']; $gresets = $_POST['gresets']; $nicknamee = stripslashes($_POST['nicknamee']); if (empty($name) or empty($nicknamee)) { echo "<ul><li>".eror_complete_correct."</li></ul>"; } elseif (!eregi('^['.$enemy["allow_char"].']{'.strlen($name).','.strlen($name).'}', $name) || !eregi('^['.$enemy["allow_char"].']{'.strlen($nicknamee).','.strlen($nicknamee).'}', $nicknamee) || !eregi('^[0-9]{'.strlen($clevel).','.strlen($clevel).'}', $clevel) || !eregi('^[0-9]{'.strlen($mlevel).','.strlen($mlevel).'}', $mlevel) || !eregi('^[0-9]{'.strlen($leveluppoint).','.strlen($leveluppoint).'}', $leveluppoint) || !eregi('^[0-9]{'.strlen($class).','.strlen($class).'}', $class) || !eregi('^[0-9]{'.strlen($strength).','.strlen($strength).'}', $strength) || !eregi('^[0-9]{'.strlen($dexterity).','.strlen($dexterity).'}', $dexterity) || !eregi('^[0-9]{'.strlen($vitality).','.strlen($vitality).'}', $vitality) || !eregi('^[0-9]{'.strlen($energy).','.strlen($energy).'}', $energy) || !eregi('^[0-9]{'.strlen($money).','.strlen($money).'}', $money) || !eregi('^[0-9]{'.strlen($mapnumber).','.strlen($mapnumber).'}', $mapnumber) || !eregi('^[0-9]{'.strlen($mapposx).','.strlen($mapposx).'}', $mapposx) || !eregi('^[0-9]{'.strlen($mapposy).','.strlen($mapposy).'}', $mapposy) || !eregi('^[0-9]{'.strlen($pkcount).','.strlen($pkcount).'}', $pkcount) || !eregi('^[0-9]{'.strlen($pklevel).','.strlen($pklevel).'}', $pklevel) || !eregi('^[0-9]{'.strlen($pktime).','.strlen($pktime).'}', $pktime) || !eregi('^[0-9]{'.strlen($ctlcode).','.strlen($ctlcode).'}', $ctlcode) || !eregi('^[0-9]{'.strlen($leadership).','.strlen($leadership).'}', $leadership) || !eregi('^[0-9]{'.strlen($resets).','.strlen($resets).'}', $resets) || !eregi('^[0-9]{'.strlen($gresets).','.strlen($gresets).'}', $gresets)) { echo "<ul><li>".eror_complete_correct."</li></ul>"; } elseif ($strength > 32767 or $dexterity > 32767 or $vitality > 32767 or $energy > 32767 or $leadership > 32767) { echo "<ul><li>".eror_stats_insert."</li></ul>"; } elseif ($mapposx > 255 or $mapposy > 255) { echo "<ul><li>".eror_map_coord."</li></ul>"; } else { $result = mssql_query("Select accountid,name,clevel,leveluppoint,class,strength,dexterity,vitality,energy,mone
y,mapnumber,mapposx,mapposy,pkcount,pklevel,pktime,ctlcode,leadership,$reset_column,$greset_column$masterlevel from character$masterleveltable_ where name='$nicknamee' $masterlevelwhere_"); if (mssql_num_rows($result) == 0) { echo "<input type="hidden" id="refreshpage" value="Account-Manager">"; exit(); } $myrow = mssql_fetch_array($result); if ($server['Season4Master'] == 1) { $edit_character = mssql_query("update $server[Season4mlvlt] set $masterlevel_='$mlevel' where $server[Season4mlvlw]='$nicknamee'"); } $edit_character = mssql_query("update character set name='$name',clevel='$clevel',leveluppoint='$leveluppoint',class='$class',strength='$strength',dexterity='$dexterity',vitality='$vitality',energy='$energy',money='$money',mapnumber='$mapnumber',mapposx='$mapposx',mapposy='$mapposy',pkcount='$pkcount',pklevel='$pklevel',pktime='$pktime',ctlcode='$ctlcode',leadership='$leadership',$greset_column='$gresets',$reset_column='$resets' where name='$nicknamee'"); $rename_ = mssql_query("update blocking set char_name='$name' where char_name='$nicknamee'"); $rename_ = mssql_query("update charpreview set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update guild set g_master='$name' where g_master='$nicknamee'"); $rename_ = mssql_query("update guildmember set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update optiondata set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update t_cguid set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update t_curcharname set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update t_friendlist set friendname='$name' where friendname='$nicknamee'"); $rename_ = mssql_query("update t_friendmail set friendname='$name' where friendname='$nicknamee'"); $rename_ = mssql_query("update t_friendmain set name='$name' where name='$nicknamee'"); $rename_ = mssql_query("update t_waitfriend set friendname='$name' where friendname='$nicknamee'"); $rename_ = mssql_query("update T_FriendMail set FriendName='$name' where FriendName='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameid1='$name' where gameid1='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameid2='$name' where gameid2='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameid3='$name' where gameid3='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameid4='$name' where gameid4='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameid5='$name' where gameid5='$nicknamee'"); $edit_character = mssql_query("update accountcharacter set gameidc='$name' where gameidc='$nicknamee'"); echo "<ul><li>".succes_update_char."</li></ul>"; } } elseif (isset($_POST['edit_char'])) { $search_name = stripslashes($_POST['char_name']); if (empty($search_name)) { echo "<ul><li>".eror_empty_search."</li></ul>"; } elseif (!eregi('^['.$enemy["allow_char"].']{'.strlen($search_name).','.strlen($search_name).'}', $search_name)) { echo "<ul><li>".eror_char_not_exist."</li></ul>"; } else { $result = mssql_query("Select accountid,name,clevel,leveluppoint,class,strength,dexterity,vitality,energy,mone
y,mapnumber,mapposx,mapposy,pkcount,pklevel,pktime,ctlcode,leadership,$reset_column,$greset_column$masterlevel from character$masterleveltable_ where name='$search_name' $masterlevelwhere_"); if (mssql_num_rows($result) > 0) { $myrow = mssql_fetch_array($result); ?> <form onsubmit="request('edit_charr','sh_','POST','getpage.php?cat=Account-Manager'); return false;" id="edit_charr"> <table border="0" cellspacing="4" cellpadding="0"> <tr> <td width="100" align="right"><? echo accountid;?>:</td> <td width="100"><? echo $myrow['accountid'];?></td> </tr> <tr> <td align="right"><? echo table_name;?>:</td> <td><input name="name" type="text" value="<? echo $myrow['name'];?>" size="14" maxlength="10"></td> </tr> <tr> <td align="right"><? echo table_level;?>:</td> <td><input name="clevel" type="text" value="<? echo $myrow['clevel'];?>" size="14" maxlength="4"></td> </tr> <? if ($server['Season4Master'] == 1) {?> <tr> <td align="right"><? echo master_level;?>:</td> <td><input name="mlevel" type="text" value="<? echo $myrow[$masterlevel_];?>" size="14" maxlength="4"></td> </tr> <? }?> <? if ($Option['is_resets'] == 1) {?> <tr> <td align="right"><? echo table_reset;?>:</td> <td><input name="resets" type="text" value="<? echo $myrow[$reset_column];?>" size="14" maxlength="4"></td> </tr> <? }?> <? if ($Option['is_gresets'] == 1) {?> <tr> <td align="right"><? echo table_greset;?>:</td> <td><input name="gresets" type="text" value="<? echo $myrow[$greset_column];?>" size="14" maxlength="4"></td> </tr> <? }?> <tr> <td align="right"><? echo table_pk_lvl;?>:</td> <td> <select name="pklevel"> <? if ($myrow['pklevel'] < '2') { ?><option value='1' selected>Hero st.2</option> <? } else {?><option value='1'>Hero st.2</option><? } ?> <? if ($myrow['pklevel'] == '2') { ?><option value='2' selected>Hero st.1</option> <? } else {?><option value='2'>Hero st.1</option><? } ?> <? if ($myrow['pklevel'] == '3') { ?><option value='3' selected>Commoner</option> <? } else {?><option value='3'>Commoner</option><? } ?> <? if ($myrow['pklevel'] == '4') { ?><option value='4' selected>Murder st.1</option> <? } else {?><option value='4'>Murder st.1</option><? } ?> <? if ($myrow['pklevel'] == '5') { ?><option value='5' selected>Murder st.2</option> <? } else {?><option value='5'>Murder st.2</option><? } ?> <? if ($myrow['pklevel'] > '5') { ?><option value='6' selected>Phonoman</option> <? } else {?><option value='6'>Phonoman</option><? } ?> </select> </td> </tr> <tr> <td align="right"><? echo table_pk_count;?>:</td> <td><input name="pkcount" type="text" value="<? echo $myrow['pkcount'];?>" size="14" maxlength="4"></td> </tr> <tr> <td align="right"><? echo table_pk_time;?>:</td> <td><input name="pktime" type="text" value="<? echo $myrow['pktime'];?>" size="14" maxlength="4"></td> </tr> <tr> <td align="right"><? echo free_points;?>:</td> <td><input name="leveluppoint" type="text" value="<? echo $myrow['leveluppoint'];?>" size="14" maxlength="6"></td> </tr> <tr> <td align="right"><? echo table_class;?>:</td> <td> <select name="class"> <? if ($myrow['class'] == '0') {?><option value='0' selected>DW</option> <? } else {?><option value='0'>DW</option><? }?> <? if ($myrow['class'] == '1') {?><option value='1' selected>SM</option> <? } else {?><option value='1'>SM</option><? }?> <? if ($myrow['class'] == '2') {?><option value='2' selected>GM</option> <? } else {?><option value='2'>GM</option><? }?> <? if ($myrow['class'] == '3') {?><option value='3' selected>GM</option> <? } else {?><option value='3'>GM</option><? }?> <? if ($myrow['class'] == '16') {?><option value='16' selected>DK</option> <? } else {?><option value='16'>DK</option><? }?> <? if ($myrow['class'] == '17') {?><option value='17' selected>BK</option> <? } else {?><option value='17'>BK</option><? }?> <? if ($myrow['class'] == '18') {?><option value='18' selected>BM</option> <? } else {?><option value='18'>BM</option><? }?> <? if ($myrow['class'] == '19') {?><option value='19' selected>BM</option> <? } else {?><option value='19'>BM</option><? }?> <? if ($myrow['class'] == '32') {?><option value='32' selected>Elf</option> <? } else {?><option value='32'>Elf</option><? }?> <? if ($myrow['class'] == '33') {?><option value='33' selected>ME</option> <? } else {?><option value='33'>ME</option><? }?> <? if ($myrow['class'] == '34') {?><option value='34' selected>HE</option> <? } else {?><option value='34'>HE</option><? }?> <? if ($myrow['class'] == '35') {?><option value='35' selected>HE</option> <? } else {?><option value='35'>HE</option><? }?> <? if ($myrow['class'] == '48') {?><option value='48' selected>MG</option> <? } else {?><option value='48'>MG</option><? }?> <? if ($myrow['class'] == '49') {?><option value='49' selected>DM</option> <? } else {?><option value='49'>DM</option><? }?> <? if ($myrow['class'] == '50') {?><option value='50' selected>DM</option> <? } else {?><option value='50'>DM</option><? }?> <? if ($myrow['class'] == '64') {?><option value='64' selected>DL</option> <? } else {?><option value='64'>DL</option><? }?> <? if ($myrow['class'] == '65') {?><option value='65' selected>LE</option> <? } else {?><option value='65'>LE</option><? }?> <? if ($myrow['class'] == '66') {?><option value='66' selected>LE</option> <? } else {?><option value='66'>LE</option><? }?> <? if ($myrow['class'] == '80') {?><option value='80' selected>Sum.</option> <? } else {?><option value='80'>Sum.</option><? }?> <? if ($myrow['class'] == '81') {?><option value='81' selected>B.Sum</option> <? } else {?><option value='81'>B.Sum</option><? }?> <? if ($myrow['class'] == '82') {?><option value='82' selected>D.M</option> <? } else {?><option value='82'>D.M</option><? }?> <? if ($myrow['class'] == '83') {?><option value='83' selected>D.M</option> <? } else {?><option value='83'>D.M</option><? }?> </select> </td> </tr> <tr> <td align="right"><? echo strength;?>:</td> <td><input name="strength" type="text" value="<? echo $myrow['strength'];?>" size="14" maxlength="5"></td> </tr> <tr> <td align="right"><? echo agility;?>:</td> <td><input name="dexterity" type="text" value="<? echo $myrow['dexterity'];?>" size="14" maxlength="5"></td> </tr> <tr> <td align="right"><? echo vitality;?>:</td> <td><input name="vitality" type="text" value="<? echo $myrow['vitality'];?>" size="14" maxlength="5"></td> </tr> <tr> <td align="right"><? echo energy;?>:</td> <td><input name="energy" type="text" value="<? echo $myrow['energy'];?>" size="14" maxlength="5"></td> </tr> <tr> <td align="right"><? echo command;?>:</td> <td><input name="leadership" type="text" value="<? echo $myrow['leadership'];?>" size="14" maxlength="5"></td> </tr> <tr> <td align="right"><? echo money;?>:</td> <td><input name="money" type="text" value="<? echo $myrow['money'];?>" size="14" maxlength="10"></td> </tr> <tr> <td align="right"><? echo map;?>:</td> <td> <select name="mapnumber"> <? for ($i=0;$i<=100;$i++) { if ($myrow['mapnumber'] == $i) echo "<option value='$i' selected>".get_map($i)."</option>"; elseif ($myrow['mapnumber'] != $i and get_map($i) != 'Unknown Map') echo "<option value='$i'>".get_map($i)."</option>"; } ?> </select> </td> </tr> <tr> <td align="right"><? echo map_pos_x;?>:</td> <td><input name="mapposx" type="text" value="<? echo $myrow['mapposx'];?>" size="14" maxlength="3"></td> </tr> <tr> <td align="right"><? echo map_pos_y;?>:</td> <td><input name="mapposy" type="text" value="<? echo $myrow['mapposy'];?>" size="14" maxlength="3"></td> </tr> <tr> <td align="right"><? echo table_status;?>:</td> <td> <select name="ctlcode"> <? if ($myrow['ctlcode'] == '0') {?><option value='0' selected>Normal</option> <? } else {?><option value='0'>Normal</option><? }?> <? if ($myrow['ctlcode'] == '1') {?><option value='1' selected>Banned(Character)</option> <? } else {?><option value='1'>Banned(Character)</option><? }?> <? if ($myrow['ctlcode'] == '4') {?><option value='4' selected>Normal(Invisibility)</option> <? } else {?><option value='4'>Normal(Invisibility)</option><? }?> <? if ($myrow['ctlcode'] == '8') {?><option value='8' selected>GM(No Mobs)</option> <? } else {?><option value='8'>GM(No Mobs)</option><? }?> <? if ($myrow['ctlcode'] == '10') {?><option value='10' selected>Admin(No Mobs)</option> <? } else {?><option value='10'>Admin(No Mobs)</option><? }?> <? if ($myrow['ctlcode'] == '12') {?><option value='12' selected>GM(Invisibility)</option> <? } else {?><option value='12'>GM(Invisibility)</option><? }?> <? if ($myrow['ctlcode'] == '17') {?><option value='17' selected>Banned(Account)</option> <? } else {?><option value='17'>Banned(Account)</option><? }?> <? if ($myrow['ctlcode'] == '24') {?><option value='24' selected>Banned(Admin)</option> <? } else {?><option value='24'>Banned(Admin)</option><? }?> <? if ($myrow['ctlcode'] == '32') {?><option value='32' selected>Game Master</option> <? } else {?><option value='32'>Game Master</option><? }?> </select> </td> </tr> <tr> <td align="center" colspan='2'> <input name="nicknamee" type="hidden" value="<? echo $myrow['name'];?>"> <input name="save_edit" type="submit" value="<? echo save;?>"> </td> </tr> </table> </form> <? } else { echo "<p><ul><li>".eror_char_not_exist."</li></ul></p>"; } } } ?> </td></tr></table></td><td> <table border='0' width="100%" cellspacing='0' cellpadding='0'><tr><td> <form onsubmit="request('form_ss','sh_','POST','getpage.php?cat=Account-Manager'); return false;" id="form_ss"> <? echo acc_id;?>: <input name="acc_id" type="text" size="14" maxlength="10"> <input name="edit_acc" type="submit" value="GO"> </form> <? if (isset($_POST['save_editt'])) { $memb___id = $_POST['memb___id']; $memb__pwd = $_POST['memb__pwd']; $memb_name = $_POST['memb_name']; $sno__numb = trim($_POST['sno__numb']); $mail_addr = $_POST['mail_addr']; $fpas_ques = $_POST['fpas_ques']; $fpas_answ = $_POST['fpas_answ']; $bloc_code = $_POST['bloc_code']; $credits = $_POST['credits']; if (isset($_POST['tel__numb'])) $tel__numb = $_POST['tel__numb']; if (isset($_POST['icq'])) $icq = $_POST['icq']; if (isset($_POST['skype'])) $skype = $_POST['skype']; if (isset($_POST['msn'])) $msn = $_POST['msn']; if (isset($_POST['yahoo'])) $yahoo = $_POST['yahoo']; if (isset($_POST['aim'])) $aim = $_POST['aim']; if (isset($_POST['country'])) $country = $_POST['country']; if (isset($_POST['city'])) $city = $_POST['city']; if (isset($_POST['gen'])) $gen = $_POST['gen']; if (isset($_POST['birthday'])) $birthday = $_POST['birthday']; if (isset($_POST['birthmonth'])) $birthmonth = $_POST['birthmonth']; if (isset($_POST['birthyear'])) $birthyear = $_POST['birthyear']; if (isset($_POST['signature'])) $signature = stripslashes($_POST['signature']); if (isset($_POST['avatar'])) $avatar = stripslashes($_POST['avatar']); if (empty($memb___id)) { echo "<ul><li>".eror_complete_correct."</li></ul>"; } elseif (!eregi('^[0-9 +]{'.strlen($tel__numb).','.strlen($tel__numb).'}', $tel__numb) || !eregi('^[0-9 ]{'.strlen($icq).','.strlen($icq).'}', $icq) || !eregi('^[a-z0-9_.- ]{'.strlen($skype).','.strlen($skype).'}', $skype) || !eregi('^[a-z0-9_.- ]{'.strlen($msn).','.strlen($msn).'}', $msn) || !eregi('^[a-z0-9_.- ]{'.strlen($yahoo).','.strlen($yahoo).'}', $yahoo) || !eregi('^[a-z0-9_.- ]{'.strlen($aim).','.strlen($aim).'}', $aim) || !eregi('^[a-z0-9 ]{'.strlen($country).','.strlen($country).'}', $country) || !eregi('^[a-z0-9 ]{'.strlen($city).','.strlen($city).'}', $city) || !eregi('^[0-9 ]{'.strlen($birthday).','.strlen($birthday).'}', $birthday) || !eregi('^[0-9 ]{'.strlen($birthmonth).','.strlen($birthmonth).'}', $birthmonth) || !eregi('^[0-9 ]{'.strlen($birthyear).','.strlen($birthyear).'}', $birthyear) || !eregi('^[a-z0-9]{'.strlen($memb___id).','.strlen($memb___id).'}', $memb___id) || !eregi('^[a-z0-9]{'.strlen($memb__pwd).','.strlen($memb__pwd).'}', $memb__pwd) || !eregi('^[a-z0-9]{'.strlen($memb_name).','.strlen($memb_name).'}', $memb_name) || !eregi('^[0-9]{'.strlen($sno__numb).','.strlen($sno__numb).'}', $sno__numb) || !eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[a-z]{2,3})$", $mail_addr) || !eregi('^[a-z0-9]{'.strlen($fpas_ques).','.strlen($fpas_ques).'}', $fpas_ques) || !eregi('^[a-z0-9]{'.strlen($fpas_answ).','.strlen($fpas_answ).'}', $fpas_answ) || !eregi('^[0-9]{'.strlen($bloc_code).','.strlen($bloc_code).'}', $bloc_code) || !eregi('^[0-9.]{'.strlen($credits).','.strlen($credits).'}', $credits) || round($credits,2) != $credits) { echo "<ul><li>".eror_complete_correct."</li></ul>"; } elseif (!(($birthday != NULL && $birthmonth != NULL && $birthyear != NULL) || ($birthday == NULL && $birthmonth == NULL && $birthyear == NULL))) { echo "<p><ul><li>".eror_complete_data."</li></ul></p>"; } else { $birthday = $birthday.".".$birthmonth.".".$birthyear; $result = mssql_query("Select memb___id,memb__pwd,memb_name,sno__numb,mail_addr,fpas_ques,fpas_answ,bloc_code,
tel__numb,icq,skype,msn,yahoo,aim,country,city,gen,signature,birthday,avatar from memb_info where memb___id='$memb___id'"); if (mssql_num_rows($result) == 0) { echo "<input type="hidden" id="refreshpage" value="Account-Manager">"; exit(); } $result2 = mssql_query("select credits from EW_CREDITS where memb___id='$memb___id'"); if (mssql_num_rows($result2) == 0) { echo "<input type="hidden" id="refreshpage" value="Account-Manager">"; exit(); } $myrow = mssql_fetch_array($result); $myrow2 = mssql_fetch_array($result2); switch($myrow['bloc_code']) { case 0: $myrow['bloc_code1'] = 'Normal'; break; case 1 : $myrow['bloc_code1'] = 'Blocked'; break; default: $myrow['bloc_code1'] = 'Blocked'; break; } switch($bloc_code) { case 0: $bloc_code1 = 'Normal'; break; case 1 : $bloc_code1 = 'Blocked'; break; default: $bloc_code1 = 'Blocked'; break; } if ($enemy['md5'] == 1) { if ($_POST['md5_check'] == 1) $md5_pwd = "memb__pwd=[dbo].[EW_MD5]('$memb__pwd', '$memb___id'),"; else $md5_pwd = ""; } else { $md5_pwd = "memb__pwd='$memb__pwd',"; } $edit_character = mssql_query("update memb_info set $md5_pwd memb_name='$memb_name',mail_addr='$mail_addr',fpas_ques='$fpas_ques',fpas_answ='$fpas_answ',bloc_code='$bloc_code' where memb___id='$memb___id'"); if ($sno__numb != NULL) mssql_query("update memb_info set sno__numb='$sno__numb' where memb___id='$memb___id'"); else mssql_query("update memb_info set sno__numb=NULL where memb___id='$memb___id'"); if ($tel__numb != NULL) mssql_query("update memb_info set tel__numb='$tel__numb' where memb___id='$memb___id'"); else mssql_query("update memb_info set tel__numb=NULL where memb___id='$memb___id'"); if ($icq != NULL) mssql_query("update memb_info set icq='$icq' where memb___id='$memb___id'"); else mssql_query("update memb_info set icq=NULL where memb___id='$memb___id'"); if ($skype != NULL) mssql_query("update memb_info set skype='$skype' where memb___id='$memb___id'"); else mssql_query("update memb_info set skype=NULL where memb___id='$memb___id'"); if ($msn != NULL) mssql_query("update memb_info set msn='$msn' where memb___id='$memb___id'"); else mssql_query("update memb_info set msn=NULL where memb___id='$memb___id'"); if ($yahoo != NULL) mssql_query("update memb_info set yahoo='$yahoo' where memb___id='$memb___id'"); else mssql_query("update memb_info set yahoo=NULL where memb___id='$memb___id'"); if ($aim != NULL) mssql_query("update memb_info set aim='$aim' where memb___id='$memb___id'"); else mssql_query("update memb_info set aim=NULL where memb___id='$memb___id'"); if ($country != NULL) mssql_query("update memb_info set country='$country' where memb___id='$memb___id'"); else mssql_query("update memb_info set country=NULL where memb___id='$memb___id'"); if ($city != NULL) mssql_query("update memb_info set city='$city' where memb___id='$memb___id'"); else mssql_query("update memb_info set city=NULL where memb___id='$memb___id'"); if ($gen != NULL) mssql_query("update memb_info set gen='$gen' where memb___id='$memb___id'"); else mssql_query("update memb_info set gen=NULL where memb___id='$memb___id'"); if ($birthday != NULL) mssql_query("update memb_info set birthday='$birthday' where memb___id='$memb___id'"); else mssql_query("update memb_info set birthday=NULL where memb___id='$memb___id'"); if ($avatar != NULL) mssql_query("update memb_info set avatar='$avatar' where memb___id='$memb___id'"); else mssql_query("update memb_info set avatar=NULL where memb___id='$memb___id'"); if ($signature != NULL) mssql_query("update memb_info set signature='$signature' where memb___id='$memb___id'"); else mssql_query("update memb_info set signature=NULL where memb___id='$memb___id'"); $edit_character = mssql_query("update ew_posts set post_by='$memb_name' where post_by='$myrow[memb_name]'"); $edit_character = mssql_query("update EW_CREDITS set credits='$credits' where memb___id='$memb___id'"); echo "<ul><li>".succes_update_acc."</li></ul>"; } } elseif (isset($_POST['edit_acc'])) { $search_id = $_POST['acc_id']; if (empty($search_id)) { echo "<ul><li>".eror_empty_search."</li></ul>"; } elseif (!eregi('^['.$enemy["allow_char"].']{'.strlen($search_id).','.strlen($search_id).'}', $search_id)) { echo "<ul><li>".eror_char_not_exist."</li></ul>"; } else { $result = mssql_query("Select mi.memb___id,memb__pwd,memb_name,sno__numb,mail_addr,fpas_ques,fpas_answ,bloc_co
de,credits,tel__numb,icq,skype,msn,yahoo,aim,country,city,gen,signature,birthday,
avatar from memb_info mi,EW_CREDITS mc where mi.memb___id COLLATE DATABASE_DEFAULT=mc.memb___id COLLATE DATABASE_DEFAULT and mi.memb___id='$search_id'"); if (mssql_num_rows($result) > 0) { $myrow = mssql_fetch_array($result); switch($myrow['bloc_code']) { case 0: $myrow['bloc_code1'] = 'Normal'; break; case 1 : $myrow['bloc_code1'] = 'Blocked'; break; default: $myrow['bloc_code1'] = 'Blocked'; break; } $birhday = explode(".", $myrow['birthday']); ?> <form onsubmit="request('edit_accc','sh_','POST','getpage.php?cat=Account-Manager'); return false;" id="edit_accc"> <table border="0" cellspacing="4" cellpadding="0" width="100%"> <tr> <td align="right"><? echo acc_id;?>:</td> <td><? echo $myrow['memb___id'];?></td> </tr> <tr> <td align="right"><? echo password;?>:</td> <td> <? if ($enemy['md5'] == 1) $myrow['memb__pwd'] = bin2hex($myrow['memb__pwd']);?> <input name="memb__pwd" type="text" value="<? echo $myrow['memb__pwd'];?>" size="14" maxlength="10"> <? if ($enemy['md5'] == 1) echo "<br><input id='md5' type='checkbox' name='md5_check' value='1'><label for="md5"> | Pwd is changed</label>"; ?> </td> </tr> <tr> <td align="right"><? echo table_name;?>:</td> <td><input name="memb_name" type="text" value="<? echo $myrow['memb_name'];?>" size="14" maxlength="10"></td> </tr> <tr> <td align="right"><? echo personal_id;?>:</td> <td><input name="sno__numb" type="text" value="<? echo trim($myrow['sno__numb']);?>" size="14" maxlength="12"></td> </tr> <tr> <td align="right"><? echo email;?>:</td> <td><input name="mail_addr" type="text" value="<? echo $myrow['mail_addr'];?>" size="14" maxlength="20"></td> </tr> <tr> <td align="right"><? echo sec_q;?>:</td> <td><input name="fpas_ques" type="text" value="<? echo $myrow['fpas_ques'];?>" size="14" maxlength="20"></td> </tr> <tr> <td align="right"><? echo sec_a;?>:</td> <td><input name="fpas_answ" type="text" value="<? echo $myrow['fpas_answ'];?>" size="14" maxlength="20"></td> </tr> <td align="right"><? echo table_status;?>:</td> <td> <select name="bloc_code"> <? if ($myrow['bloc_code'] == '0') {?><option value='0' selected>Normal</option> <? } else {?><option value='0'>Normal</option><? }?> <? if ($myrow['bloc_code'] == '1') {?><option value='1' selected>Blocked</option> <? } else {?><option value='1'>Blocked</option><? }?> </select> </td> </tr> <tr> <td align="right"><? echo credits;?>:</td> <td><input name="credits" type="text" value="<? echo $myrow['credits'];?>" size="14" maxlength="20"></td> </tr> <tr> <td align="right" valign="top"><? echo "<img alt='' src='$template/img/im_icq.png'>";?> <strong>ICQ :</strong></td> <td align="left" valign="top"><input name="icq" type="text" value="<? echo $myrow['icq'];?>" size="20" maxlength="10"></td> </tr> <tr> <td align="right" valign="center"><? echo "<img alt='' src='$template/img/im_skype.png'>";?> <strong>Skype :</strong></td> <td align="left" valign="center"> <input type="text" name="skype" value="<? echo $myrow['skype'];?>" size="20" maxlength="20"> </td> </tr> <tr> <td align="right" valign="center"><? echo "<img alt='' src='$template/img/im_msn.png'>";?> <strong>MSN :</strong></td> <td align="left" valign="center"><input type="text" name="msn" value="<? echo $myrow['msn'];?>" size="20" maxlength="20"></td> </tr> <tr> <td align="right" valign="center"><? echo "<img alt='' src='$template/img/im_yahoo.png'>";?> <strong>Yahoo :</strong></td> <td align="left" valign="center"> <input type="text" name="yahoo" value="<? echo $myrow['yahoo'];?>" size="20" maxlength="20"> </td> </tr> <tr> <td align="right" valign="center"><? echo "<img alt='' src='$template/img/im_aim.png'>";?> <strong>AIM :</strong></td> <td align="left" valign="center"><input type="text" name="aim" value="<? echo $myrow['aim'];?>" size="20" maxlength="20"></td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_country;?></strong></td> <td align="left" valign="center"> <input type="text" name="country" value="<? echo $myrow['country'];?>" size="20" maxlength="30"> </td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_city;?></strong></td> <td align="left" valign="center"><input type="text" name="city" value="<? echo $myrow['city'];?>" size="20" maxlength="30"></td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_tel;?></strong></td> <td align="left" valign="center"> <input type="text" name="tel__numb" value="<? echo $myrow['tel__numb'];?>" size="20" maxlength="15"> </td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_birthday;?></strong></td> <td align="left" valign="center"> <select name="birthday"> <? echo "<option value=''>--"; for($i = 1; $i <= 31; $i++) { if ($birhday[0] != $i) echo "<option value='$i'>$i</option>"; else echo "<option value='$i' selected>$i</option>"; } ?> </select> - <select name="birthmonth"> <? echo "<option value=''>--"; for($i = 1; $i <= 12; $i++) { if ($birhday[1] != $i) echo "<option value='$i'>$i</option>"; else echo "<option value='$i' selected>$i</option>"; } ?> </select> - <select name="birthyear"> <? echo "<option value=''>----"; for($i = (date("Y") - 100); $i <= date("Y"); $i++) { if ($birhday[2] != $i) echo "<option value='$i'>$i</option>"; else echo "<option value='$i' selected>$i</option>"; } ?> </select> </td> </tr> <tr> <td align="right" valign="top"><strong><? echo profile_gen;?></strong></td> <td align="left" valign="top"> <? if ($myrow['gen'] == 'Male') {?><input id='male' type="radio" name="gen" value="Male" checked> <? } else {?><input id='male' type="radio" name="gen" value="Male"><label for="male"> <? } echo profile_male."</label>"; if ($myrow['gen'] == 'Female') {?> <input id='female' type="radio" name="gen" value="Female" checked> <? } else {?><input id='female' type="radio" name="gen" value="Female"><label for="female"><? } echo profile_female."</label>";?> </td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_sign;?></strong></td> <td align="left" valign="center"> <input type="text" name="signature" value="<? echo UTF8RawUrlDecode(htmlspecialchars($myrow['signature']));?>" size="20" maxlength="255"> </td> </tr> <tr> <td align="right" valign="center"><strong><? echo profile_avatar;?></strong></td> <td align="left" valign="center"> <input type="text" name="avatar" value="<? echo $myrow['avatar'];?>" size="20" maxlength="15"> </td> </tr> <tr> <td align="center" colspan='2'> <input name="memb___id" type="hidden" value="<? echo $myrow['memb___id'];?>"> <input name="save_editt" type="submit" value="<? echo save;?>"> </td> </tr> </table> </form> <? } else { echo "<p><ul><li>".eror_acc_not_exist."</li></ul></p>"; } } } ?> </td></tr></table></td><tr></table></td><tr></table>

[свернуть]

[dn0]

Platinum если гриня тут не отвечает,может очень занят попробуй ему в ICQ напиши или тут в ЛС.
вот его ICQ : 392-409-945