Скрипты
2 ответов1,095 просмотровСейчас просматривают: 1
· 31.07.2007, 11:38
top10.php
Код
<html>
<head>
<title>[Heavens Gate L2 - TOP 15 PvP]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>TOP 10 PvP</p>
<table border="0" width="300" class="tabela">
<tr class="tabelatitle"><td>Char</td><td> PvP</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("SELECT char_name, Duel FROM dbo.user_data WHERE Duel > 0 ORDER BY Duel DESC");
$maxr = 0;
while ($consulta = mssql_fetch_array($query) AND $maxr < 10)
{
$maxr = $maxr + 1;
print "<td>$consulta[char_name] </td><td> $consulta[Duel]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
<head>
<title>[Heavens Gate L2 - TOP 15 PvP]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>TOP 10 PvP</p>
<table border="0" width="300" class="tabela">
<tr class="tabelatitle"><td>Char</td><td> PvP</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("SELECT char_name, Duel FROM dbo.user_data WHERE Duel > 0 ORDER BY Duel DESC");
$maxr = 0;
while ($consulta = mssql_fetch_array($query) AND $maxr < 10)
{
$maxr = $maxr + 1;
print "<td>$consulta[char_name] </td><td> $consulta[Duel]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
top10pk.php
Код
<html>
<head>
<title>[Heavens Gate L2 - TOP 15 PK]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>TOP 10 PK</p>
<table border="0" width="300" class="tabela">
<tr class="tabelatitle"><td>Char</td><td> Pk</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("SELECT char_name, PK FROM dbo.user_data WHERE PK > 0 ORDER BY PK DESC");
$maxr = 0;
while ($consulta = mssql_fetch_array($query) AND $maxr < 10)
{
$maxr = $maxr + 1;
print "<td>$consulta[char_name] </td><td> $consulta[PK]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
<head>
<title>[Heavens Gate L2 - TOP 15 PK]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>TOP 10 PK</p>
<table border="0" width="300" class="tabela">
<tr class="tabelatitle"><td>Char</td><td> Pk</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("SELECT char_name, PK FROM dbo.user_data WHERE PK > 0 ORDER BY PK DESC");
$maxr = 0;
while ($consulta = mssql_fetch_array($query) AND $maxr < 10)
{
$maxr = $maxr + 1;
print "<td>$consulta[char_name] </td><td> $consulta[PK]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
Сколько времени прошло....
— Administrator
0
· 01.08.2007, 18:28
Дополню)
Castle.php
Код
<html>
<head>
<title>[Heavens Gate L2 - Castle]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>Castle Status</p>
<table border="0" width="700" class="tabela">
<tr class="tabelatitle"><td>Castle Name</td><td>Clan</td><td>Castle Owner</td><td>Alliance</td><td> Tax Rate</td><td>Next War</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("exec lin_getcastlelist");
$maxr = 0;
$nome = null;
while ($consulta = mssql_fetch_array($query) AND $maxr < 15)
{
$maxr = $maxr + 1;
if ($consulta[id] == 1) { $nome = "Gludio Castle"; }
if ($consulta[id] == 2) { $nome = "Dion Castle"; }
if ($consulta[id] == 3) { $nome = "Giran Caslte"; }
if ($consulta[id] == 4) { $nome = "Oren Caslte"; }
if ($consulta[id] > 4) { $nome = "Castle CLOSED"; }
$atualdate = date('D\, j M Y H\:i',$consulta[next_war_time]);
print "<td>$nome </td><td> $consulta[pledge_name]</td><td>$consulta[ruler_name]</td><td>$consulta[alliance_name]</td><td>$consulta[tax_rate] </td><td>$atualdate </td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
<head>
<title>[Heavens Gate L2 - Castle]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>Castle Status</p>
<table border="0" width="700" class="tabela">
<tr class="tabelatitle"><td>Castle Name</td><td>Clan</td><td>Castle Owner</td><td>Alliance</td><td> Tax Rate</td><td>Next War</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("exec lin_getcastlelist");
$maxr = 0;
$nome = null;
while ($consulta = mssql_fetch_array($query) AND $maxr < 15)
{
$maxr = $maxr + 1;
if ($consulta[id] == 1) { $nome = "Gludio Castle"; }
if ($consulta[id] == 2) { $nome = "Dion Castle"; }
if ($consulta[id] == 3) { $nome = "Giran Caslte"; }
if ($consulta[id] == 4) { $nome = "Oren Caslte"; }
if ($consulta[id] > 4) { $nome = "Castle CLOSED"; }
$atualdate = date('D\, j M Y H\:i',$consulta[next_war_time]);
print "<td>$nome </td><td> $consulta[pledge_name]</td><td>$consulta[ruler_name]</td><td>$consulta[alliance_name]</td><td>$consulta[tax_rate] </td><td>$atualdate </td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
hero.php
Код
<html>
<head>
<title>[Heavens Gate L2 - Heroes]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>Heroes</p>
<table border="0" width="600" class="tabela">
<tr class="tabelatitle"><td>Char</td><td>Count</td><td>Class</td><td>Clan</td><td>Ally</td><td>PVP</td><td>PK</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("
SELECT char_name, subjob0_class, win_count, PK, Duel, clan.name as clan_name, ally.name as ally_name
FROM lin2world.dbo.user_data usr
LEFT JOIN lin2world.dbo.user_nobless nob
ON usr.char_id = nob.char_id
LEFT JOIN lin2world.dbo.pledge clan
ON usr.pledge_id = clan.pledge_id OR clan.pledge_id IS NULL
LEFT JOIN lin2world.dbo.Alliance ally
ON clan.alliance_id = ally.id
WHERE nob.hero_type >= 2 ");
$mainclass = 'sem_classe';
$classes = array( 88 => 'Duelist'
, 89 => 'Dreadnought'
, 90 => 'Phoenix Knight'
, 91 => 'Hell Knight'
, 92 => 'Sagittarius'
, 93 => 'Adventurer'
, 94 => 'Archmage'
, 95 => 'Soultaker'
, 96 => 'Arcana Lord'
, 97 => 'Cardinal'
, 98 => 'Hierophant'
, 99 => 'Eva Templar'
, 100 => 'Sword Muse'
, 101 => 'Wind Rider'
, 102 => 'Moonlight Sentinel'
, 103 => 'Mystic Muse'
, 104 => 'Elemental Master'
, 105 => 'Eva Saint'
, 106 => 'Shillien Templar'
, 107 => 'Spectral Dancer'
, 108 => 'Ghost Hunter'
, 109 => 'Ghost Sentinel'
, 110 => 'Storm Screamer'
, 111 => 'Spectral Master'
, 112 => 'Shillien Saint'
, 113 => 'Titan'
, 114 => 'Gran Khavatari'
, 115 => 'Dominator'
, 116 => 'Doom Cryer'
, 117 => 'Fortune Seeker'
, 118 => 'Maestro'
);
while ($consulta = mssql_fetch_array($query))
{
$mainclass = $classes[$consulta[subjob0_class]];
print "<td>$consulta[char_name]</td><td>$consulta[win_count]</td><td> $mainclass</td><td>$consulta[clan_name]</td><td>$consulta[ally_name]</td><td>$consulta[Duel]</td><td>$consulta[PK]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
<head>
<title>[Heavens Gate L2 - Heroes]</title>
<style type="text/css">
.tabela {
background: #2C261B;
background-color: #2C261B;
font-size: 12px;
}
.tabelatitle {
background-color: #211D15;
font-size: 14px;
font-weight: bold;
}
body {
background-color: #211D15;
color: #FFFFFF;
font-family: tahoma;
font-size: 19px;
}
</style>
<body>
<p>Heroes</p>
<table border="0" width="600" class="tabela">
<tr class="tabelatitle"><td>Char</td><td>Count</td><td>Class</td><td>Clan</td><td>Ally</td><td>PVP</td><td>PK</td><tr>
<tr class="tabela">
<?php
mssql_connect("localhost", "", "") or die("Nгo foi possнvel a conexгo com o servidor");
mssql_select_db("lin2world") or die("Nгo foi possнvel selecionar o banco de dados");
//print "Conexгo OK<br><br><br>";
$query = mssql_query("
SELECT char_name, subjob0_class, win_count, PK, Duel, clan.name as clan_name, ally.name as ally_name
FROM lin2world.dbo.user_data usr
LEFT JOIN lin2world.dbo.user_nobless nob
ON usr.char_id = nob.char_id
LEFT JOIN lin2world.dbo.pledge clan
ON usr.pledge_id = clan.pledge_id OR clan.pledge_id IS NULL
LEFT JOIN lin2world.dbo.Alliance ally
ON clan.alliance_id = ally.id
WHERE nob.hero_type >= 2 ");
$mainclass = 'sem_classe';
$classes = array( 88 => 'Duelist'
, 89 => 'Dreadnought'
, 90 => 'Phoenix Knight'
, 91 => 'Hell Knight'
, 92 => 'Sagittarius'
, 93 => 'Adventurer'
, 94 => 'Archmage'
, 95 => 'Soultaker'
, 96 => 'Arcana Lord'
, 97 => 'Cardinal'
, 98 => 'Hierophant'
, 99 => 'Eva Templar'
, 100 => 'Sword Muse'
, 101 => 'Wind Rider'
, 102 => 'Moonlight Sentinel'
, 103 => 'Mystic Muse'
, 104 => 'Elemental Master'
, 105 => 'Eva Saint'
, 106 => 'Shillien Templar'
, 107 => 'Spectral Dancer'
, 108 => 'Ghost Hunter'
, 109 => 'Ghost Sentinel'
, 110 => 'Storm Screamer'
, 111 => 'Spectral Master'
, 112 => 'Shillien Saint'
, 113 => 'Titan'
, 114 => 'Gran Khavatari'
, 115 => 'Dominator'
, 116 => 'Doom Cryer'
, 117 => 'Fortune Seeker'
, 118 => 'Maestro'
);
while ($consulta = mssql_fetch_array($query))
{
$mainclass = $classes[$consulta[subjob0_class]];
print "<td>$consulta[char_name]</td><td>$consulta[win_count]</td><td> $mainclass</td><td>$consulta[clan_name]</td><td>$consulta[ally_name]</td><td>$consulta[Duel]</td><td>$consulta[PK]</td></tr>";
}
mssql_close();
?>
</table>
<br />
<span class="tabela">website by eduardoboss.com</span>
</body>
</html>
— Пидарас №1 в рунете
0
Тема закрыта для ответов