Skip to content
La2Base
Home
DownloadsWikiForumFAQ
Search
ruen
Sign up Login
HomeFilesWikiLogin
  • Home
  • Downloads
  • Wiki
  • FAQ
  • Contact Us
  • About
  • Rules
  • Privacy
  • Terms of Service

© 2026 la2base.com · All rights reserved

ruen
Forum/Веб обвязка/ошибка в статусе замков
Search

ошибка в статусе замков

3 replies103 viewsCurrently viewing: 1
IIIeiK
IIIeiK

User

Участник

Posts: 85

На форуме с: 10/04/2008

Репутация: +35

Рейтинг: 0

· 12/21/2008, 09:50 PM

всем здрасте помагите плиз

скрипт отображает статистику и выдаёт ощибку

Код
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>
<? } ?>

0
DionSupport
DionSupport

User

Новичок

Posts: 19

На форуме с: 10/07/2008

Репутация: +6

Рейтинг: 0

· 01/11/2009, 09:21 PM

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
A
andreykopisx

User

Новичок

Posts: 12

На форуме с: 11/03/2008

Рейтинг: 0

· 03/19/2009, 01:14 PM

Мммм читаем на англицком
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
Topic is closed for replies