LuDa_KaTeRiCa
Registered
Значи имам следния проблем!
http://prikachi.com/images/243/2751243n.jpg
Ето го кода
CSS са
SQL
Искам ако може да ми направите таблицата подредена не така разбъркана ако е нужно ще платя с смс !
http://prikachi.com/images/243/2751243n.jpg
Ето го кода
Код:
<?php
include 'main.php';
?>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link rel="stylesheet" type="text/css" href="css/menu1_style.css" />
<style type="textcss" >
#page { }
#pageh { }
</style>
<div id="nav">
<a href="survers1.php" class="selected" ><b>Сървъри</b></a>
<a href="addserver1.php" ><b>Добави</b></a>
<a href="advertisement.php" ><b>Реклама</b></a>
<a href="baneri.php" ><b>Банери</b></a>
<a href="kontakti.php" ><b>Контакти</b></a>
<br/>
</div>
<?php
echo ('<div id="centerbox">');
echo ('<center>');
$server = "localhost";
$dbusername = "root";
$dbpassword = "***";
$db_name = "cs_sistem";
$table_name = "servers";
mysql_connect($server, $dbusername, $dbpassword)or die("1111");
@mysql_select_db($db_name) or die("2222");
$page = (int)$_GET['page'];
if($page == 0 || $page == NULL || $page < 0)
{
$page = 1;
}
$pp = 10;
$start = ($page*$pp) - $pp;
$qu = mysql_query("SELECT * FROM $table_name ");
$broi = mysql_num_rows($qu);
$total = ceil($broi/$pp);
$query=mysql_query("SELECT * FROM $table_name ORDER BY `id` DESC LIMIT $start,$pp")or die(mysql_error());
while($row = mysql_fetch_array($query)) {
$id = $row['id'];
$name = $row['name'];
$ip = $row['ip'];
$port = $row['port'];
$cheat = $row['cheat'];
$type = $row['type'];
$website = $row['website'];
echo "<div id='hoverman'><td valign='top'>
<table cellpadding='0' cellspacing='0' style='border: #000000 1px solid;padding-left: 3px; width:100%' class='title'>
<tr><td class='nameandip' style='border: #cccccc 1px solid;background: #FFFFFF;' align='center'><a href='info.php?id=$id''><span style='color:#000000'>$name<br>$ip:$port</span></a></td><td class='tip' align='center' style='border: #cccccc 1px solid;background: #FFFFFF;'><a href='index.php?module=servers&cid=6'><span style='color:#000000'>$type</span></a></td><td align='center' class='igrachi' style='border: #cccccc 1px solid;background: #FFFFFF;'>0/0</td><td align='center' class='karta' style='border: #cccccc 1px solid;background: #FFFFFF;'>N/A</td><td align='center' class='stat' style='border: #cccccc 1px solid;background: #FFFFFF;'><font color='red'>Offline</font</td></tr>
</table><center></div>";
}
echo "<div color:#fff;'>";
echo"</div>";
echo ('</center>');
echo ('</div>');
echo ('<div class="butoncheta"');
if (!$page or ($page > $total)) {
$page="1";
}
if ($total < 10) {
for($i=1 ; $i<=$total ; $i++) {
if ( ($page)==$i ) {
echo "<b id='page'>$i</b> ";
}
else {
echo "<a id='pageh' href=\"?page=".$i."\"><b>".$i."</b></a> ";
}
}
}
else {
for($i=1 ; $i<=3 ; $i++) {
if ( ($page)==$i ) {
echo "<b id='page'>$i</b> ";
}
else {
echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
}
if ($page <= 3) {
if ($page == 3) echo "<a id='pageh' href=\"?page=4\">4</a> ";
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
if ($page == 5) $parva.= "<a id='pageh' href=\"?page=4\">4</a> ";
if ( ($page == 4) or ($page == 5) ) {
for ($i=$page; $i<=$page+1; $i++) {
if ($page == $i) echo "<b id='page'>$i</b> ";
else echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
if ( ($page > 5) and ($page < ($total - 4)) ) {
echo "... ";
for ($i=$page-1; $i<=$page+1; $i++) {
if ($page == $i) echo "<b id='page'>$i</b> ";
else echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
echo "... ";
for ($i=$total-2; $i<=$total; $i++)
echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
if ( $page > ($total - 5) ) {
echo "... ";
for ($i=$total-5; $i<=$total; $i++) {
if ($page == $i) echo "<b id='page'>$i</b> ";
else echo "<a id='pageh' href=\"?page=".$i."\">".$i."</a> ";
}
}
}
echo ('</div>');
?>CSS са
Код:
html, body {
margin:0;
padding:0;
text-align:center;
font-family:Tahoma;
border:0px;
}
#hoverman {
width: 500px;
background-color: #f0f0f0;
color:#000;
border:1px solid:#000;
}
#hoverman:hover {
width: 500px;
background-color: #fffea0;
color:#000;
border-style:solid;
border:1px solid:#000;
}
#centerbox {
background:#fff;
width:500px;
margin:0 auto;
-moz-border-radius:5px;
-webkit-border-radius:5px;
border-radius:0px;
border:1px solid black;
padding-top:2px;
-moz-opacity:5.1;
-webkit-opacity:5.1;
opacity:5.1;
position: absolute;
top: 290px;
left: 230px;
}
.title-dobaviserv
{
position:absolute;
left:260px;
top:220px;
}
.title-dobaviserv-txt
{
position:absolute;
left:450px;
top:215px;
}
.title_serverdob {
position: absolute;
left: 420px;
top: 260px;
}
.butoncheta {
position: absolute;
left: 420px;
top: 700px;
}
.nameandip {
width: 340px;
background-color: #f0f0f0;
color:#000;
}
.tip {
width: 145px;
background-color: #f0f0f0;
color:#000;
}
.igrachi {
width: 50px;
background-color: #f0f0f0;
color:#000;
}
.karta {
width: 100px;
background-color: #f0f0f0;
color:#000;
}
.stat {
width: 80px;
background-color: #f0f0f0;
color:#000;
}
.title {
background: url('images/title.png');
height: 20;
text-align: center;
font-family: tahoma;
font-size: 12px;
font-weight: bold;
color: #3c3a3b;
border: #000000 1px solid;
}SQL
Код:
CREATE TABLE IF NOT EXISTS `servers` (
`id` bigint(255) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`ip` varchar(255) NOT NULL,
`port` text NOT NULL,
`cheat` text NOT NULL,
`type` text NOT NULL,
`email` text NOT NULL,
`dopinfo` text NOT NULL,
`website` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=6 ;Искам ако може да ми направите таблицата подредена не така разбъркана ако е нужно ще платя с смс !