[Help] бц и дс

naiden4o · Sep 15, 2009

имам следния проблем не ми записва точките от дс в ранка и ако някой може да ми каже как се прави бц ранк.

128ve980 · Sep 16, 2009

за коя версия е това?

naiden4o · Sep 16, 2009

Става въпрос за версия 97d

naiden4o · Sep 28, 2009

значи говорим за сайта . искъм да им записва точките като се направи класация . както и да си сложа бц ранк , ако някой знае да каже

killar4eto · Sep 28, 2009

Ето ти как става:

For MuWeb:

Code:

elseif($muweb['connection']=='mssql'){
$db = &ADONewConnection('mssql');
$connect_mssql = $db->Connect($muweb['dbhost'],$muweb['dbuser'],$muweb['dbpassword'],MuOnline);
if (!$connect_mssql) die("<img src=images/warning.gif> Connection with SQL Server failed! Error #119");
}
 
$query = "SELECT top $top_rank charactername,class,point from event_info order by Point desc"; 
$result = $db->Execute($query);

For DarksWeb:

Code:

if($web['connection']=='mssql'){
$db = 'mssql';
$connect_mssql = mssql_connect($web['dbhost'],$web['dbuser'],$web['dbpassword'],MuOnline);
if (!$connect_mssql) die("Couldn't connect to SQL Server");
}
$query = "SELECT top 20 charactername,class,point,class from EVENT_INFO order by Point desc"; 
$result = mssql_query($query);

Става за BC и DS

BC скрипта е същото, но сменяте само EVENT_INFO с правилната таблица!

Aragorn · Sep 28, 2009

не ве хора той няма проблеми с сайта ползва xtyling web-a а там си работи ДС ранкинга на него не му се записват точките от ДС и БЦ в ДБ... И при мен е така не се записват...

6efa · Sep 28, 2009

<?php include"home.php"; ?>
</style></head>
<style type="text/css">
.style1 {color: #FF0000}
</style>
<body leftmargin="0" topmargin="0">
<div align="center">
<table align="center" border="1" bordercolor="#666666" cellpadding="0" bgcolor="white" cellspacing="0" frame="vsides" rules="none" width="760">
<tbody><tr>
<td align="left" background="images/left_bg.gif" valign="top" width="204"><p><img src="images/left_top_news.gif" height="36" width="204">
<?php include"pictures.php"; ?>
<?php include"ranks.php"; ?>
</p></td>
<td background="images/xu.gif" height="190" width="1"></td>
<td align="center" valign="top" width="553"> <p align=middle vAlign=center><br><font color=red >Top 100 Guilds</font><p>
<?
include('Config.php');
$_I6otf=mssql_connect("$_I6ooJ","$_I6Cto","$_I6i8Q");
$_I6iiJ=mssql_select_db("Ranking",$_I6otf);
$_I6joJ = 'SELECT TOP 100 CharacterName, Class, Point from event_info order by Point desc';
$_I6J8j = mssql_query($_I6joJ);
echo '<center><TABLE border=0 cellPadding=0 cellSpacing=0>
<TD>
<TR><TD><center>
<table height=10 border="0" cellpadding="5" cellspacing="0" width="98%" bordercolor=#666666>
<tr>
<td valign=top align=center bgcolor=#c6c6c6 width=34><font color=black>Rank</td>
<td valign=top align=center bgcolor=#c6c6c6 width=184><font color=black>Character</td>
<td valign=top align=center bgcolor=#c6c6c6 width=104><font color=black>Class</td>
<td valign=top align=center bgcolor=#c6c6c6 width=184><font color=black>Points</td>
';
$_I6JC6 = 'black';
for($_I6JL6=0;$_I6JL6 < mssql_num_rows($_I6J8j);++$_I6JL6)
{
$_I66L1 = mssql_fetch_row($_I6J8j);
$_I6fi1 = $_I6JL6+1;
$_I68j8 = '0';
if ($_I6JC6 == 'black') {
$_I6JC6 = 'darkblue';
$_I686t = 'white';
$_I68j8 = '1'; }
if ($_I6JC6 == 'darkblue') {
if ($_I68j8 != '1') {
$_I6JC6 = 'black';
$_I686t = '#f4f4f4'; } }
if ($_I6fi1 == '1') {
$_I686t = 'orange'; }
$_I6tQl = $_I6JL6 + 1;

if($_I66L1[1] == 99){ $_I66L1[1] ='DW';
}
if($_I66L1[1] == 0){ $_I66L1[1] ='SM';
}
if($_I66L1[1] == 99){ $_I66L1[1] ='DK';
}
if($_I66L1[1] == 1){ $_I66L1[1] ='BK';
}
if($_I66L1[1] == 99){ $_I66L1[1] ='ELF';
}
if($_I66L1[1] == 2){ $_I66L1[1] ='ME';
}
if($_I66L1[1] == 3){ $_I66L1[1] ='MG';
}
if($_I66L1[1] == 99){ $_I66L1[1] ='DL';
}

echo "<tr><td valign=top bgcolor=$_I686t align=center>$_I6fi1</b></td>
<td valign=top bgcolor=$_I686t align=center><a href='whoiz.php?name=$_I66L1[0]'>".htmlspecialchars($_I66L1[0])."</td>
<td valign=top bgcolor=$_I686t align=center>$_I66L1[1]</td>
<td valign=top bgcolor=$_I686t align=center>$_I66L1[2]</td>

</tr></center>";

}
?>
</p>
</table>
<p><center>
</center> </p>
</div>
</body></html>

ето ви кода на дс.пхп можели дамиго фихнете

killar4eto · Sep 28, 2009

$_I6iiJ=mssql_select_db("Ranking",$_I6otf);

смени това Ranking на MuOnline!!!

naiden4o · Sep 30, 2009

ако може да ми дадете и пхп кода за бц

а по дсто сега почвам да работя , да видя до къде ще стигна

Search

Search

[Help] бц и дс

naiden4o

New Member

128ve980

Active Member

naiden4o

New Member

naiden4o

New Member

killar4eto

Well-Known Member

Aragorn

Well-Known Member

6efa

New Member

killar4eto

Well-Known Member

naiden4o

New Member

Similar threads