ошибка в статусе замков
3 ответов102 просмотровСейчас просматривают: 1
· 21.12.2008, 21:50
всем здрасте помагите плиз
скрипт отображает статистику и выдаёт ощибку
Код
Warning: mssql_query(): WARNING! Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?'). (severity 16) in c:/Apache/htdocs/castle.php on line 10
вот сам скрипт
Код
<?
mssql_connect("ХХХХХХХХХХ", "ХХХХХХХХХХ", "ХХХХХХХХХХ");
mssql_select_db(lin2world);
$result=mssql_query("
select *
from castle as a
left outer join pledge as b on a.pledge_id=b.pledge_id
left outer join user_data as c on b.ruler_id=c.char_id
order by id");
$castle=array();
for ($x=1;$castle[$x]=mssql_fetch_assoc($result);$x++){ }
$castle_list=array("Gludio Castle","Dion Castle","Giran Castle","Oren Castle","Aden Castle","Innadril Castle","Goddard Castle","Rune Castle","Schuttgart Castle");
$stake=array("0%","5%","10%","15%");
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td class="h-cell b-tblr t-bold">Контроль замков</td>
</tr>
</table>
<? for ($i=1;$i<=9;$i++) { ?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<?=$sep?>
<tr>
<td><?=$castle_list[$i-1]?></td>
</tr>
<tr>
<td width="234"><img src="module/images/castles/castle<?=$i?>.jpg"></td>
<td>
<table width="90%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="50%">Контролируется:</td>
<td width="50%" class="info">
<?
if ($castle[$i]["name"])
echo '<a href="/?id=show_clan_info&indx='.$castle[$i]["pledge_id"].'">'.$castle[$i]["name"].'</a>';
else
echo 'Нет хозяина';
?>
</td>
</tr>
<tr>
<td>Лидер клана:</td>
<td class="info">
<?
if ($castle[$i]["char_name"])
echo $castle[$i]["char_name"];
else
echo 'Нет';
?>
</td>
</tr>
<tr>
<td>Ставка налога:</td>
<td class="info"><?=$castle[$i]["tax_rate"]?>%</td>
</tr>
<tr>
<td>Статус осады:</td>
<td class="info">
<?
if ($castle[$i]["next_war_time"]!=0)
echo date("F j, Y, G:i",$castle[$i]["next_war_time"]);
else
echo 'Дата не определена';
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<? } ?>
mssql_connect("ХХХХХХХХХХ", "ХХХХХХХХХХ", "ХХХХХХХХХХ");
mssql_select_db(lin2world);
$result=mssql_query("
select *
from castle as a
left outer join pledge as b on a.pledge_id=b.pledge_id
left outer join user_data as c on b.ruler_id=c.char_id
order by id");
$castle=array();
for ($x=1;$castle[$x]=mssql_fetch_assoc($result);$x++){ }
$castle_list=array("Gludio Castle","Dion Castle","Giran Castle","Oren Castle","Aden Castle","Innadril Castle","Goddard Castle","Rune Castle","Schuttgart Castle");
$stake=array("0%","5%","10%","15%");
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td class="h-cell b-tblr t-bold">Контроль замков</td>
</tr>
</table>
<? for ($i=1;$i<=9;$i++) { ?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<?=$sep?>
<tr>
<td><?=$castle_list[$i-1]?></td>
</tr>
<tr>
<td width="234"><img src="module/images/castles/castle<?=$i?>.jpg"></td>
<td>
<table width="90%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="50%">Контролируется:</td>
<td width="50%" class="info">
<?
if ($castle[$i]["name"])
echo '<a href="/?id=show_clan_info&indx='.$castle[$i]["pledge_id"].'">'.$castle[$i]["name"].'</a>';
else
echo 'Нет хозяина';
?>
</td>
</tr>
<tr>
<td>Лидер клана:</td>
<td class="info">
<?
if ($castle[$i]["char_name"])
echo $castle[$i]["char_name"];
else
echo 'Нет';
?>
</td>
</tr>
<tr>
<td>Ставка налога:</td>
<td class="info"><?=$castle[$i]["tax_rate"]?>%</td>
</tr>
<tr>
<td>Статус осады:</td>
<td class="info">
<?
if ($castle[$i]["next_war_time"]!=0)
echo date("F j, Y, G:i",$castle[$i]["next_war_time"]);
else
echo 'Дата не определена';
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<? } ?>
0
· 11.01.2009, 21:21
CODE
<?
include("module/stat-menu.php");
mssql_connect($mssql_server,$mssql_user,$mssql_pass);
mssql_select_db($mssql_db);
$result=mssql_query("
select *
from castle as a
left outer join pledge as b on a.pledge_id=b.pledge_id
left outer join user_data as c on b.ruler_id=c.char_id
order by id");
$castle=array();
for ($x=1;$castle[$x]=mssql_fetch_assoc($result);$x++){ }
$castle_list=array("Gludio Castle","Dion Castle","Giran Castle","Oren Castle","Aden Castle","Innadril Castle","Goddard Castle","Rune Castle","Schuttgart Castle");
$stake=array("0%","5%","10%","15%");
?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
<td class="h-cell b-tblr t-bold">Контроль замков</td>
</tr>
</table>
<? for ($i=1;$i<=9;$i++) { ?>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<?=$sep?>
<tr>
<td><?=$castle_list[$i-1]?></td>
</tr>
<tr>
<td width="234"><img src="module/images/castles/castle<?=$i?>.jpg"></td>
<td>
<table width="90%" cellpadding="0" cellspacing="0" align="center">
<tr>
<td width="50%">Контролируется:</td>
<td width="50%" class="info">
<?
if ($castle[$i]["name"])
echo '<a href="/?id=show_clan_info&indx='.$castle[$i]["pledge_id"].'">'.$castle[$i]["name"].'</a>';
else
echo 'Нет хозяина';
?>
</td>
</tr>
<tr>
<td>Лидер клана:</td>
<td class="info">
<?
if ($castle[$i]["char_name"])
echo $castle[$i]["char_name"];
else
echo 'Нет';
?>
</td>
</tr>
<tr>
<td>Ставка налога:</td>
<td class="info"><?=$castle[$i]["tax_rate"]?>%</td>
</tr>
<tr>
<td>Статус осады:</td>
<td class="info">
<?
if ($castle[$i]["next_war_time"]!=0)
echo date("F j, Y, G:i",$castle[$i]["next_war_time"]);
else
echo 'Дата не определена';
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<? } ?>
Нормально работает, вроде без глюков)
0
· 19.03.2009, 13:14
Мммм читаем на англицком
Warning: mssql_query(): WARNING! Some character(s) could not be converted into client's character set. Unconverted bytes were changed to question marks ('?'). (severity 16) in c:/Apache/htdocs/castle.php on line 10
Если хочешь убрать просто появление ошибки - поставь @ перед функцией..
А так проблема судя по всему с кодировкой базы\чего-либо еще
0
Тема закрыта для ответов


