Webmaster общности: Predpriemach.com | SearchEngines.bg

    Webagent + бан система

    Автор: jooorooo

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

    addban.php

    <?php
    
    session_start();
    
    if(!$_SESSION['username']){
    
    echo "Please <a href=admin.php>login.</a>";
    
    exit;
    
    }
    ?>
    <html>
    <head>
    <title>ИП адреси</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <style type="text/css">
    
    #nav {
    background-color: #D5D5D5;
    border: 1px solid #B8B8B8;
    padding-top: 8px;
    height: 21px;
    padding-left: 3px;
    }
    #nav a {
    border: 1px solid #B7B7B7;
    padding: 4px;
    background-color: #F3F3F3;
    color: #0077B4;
    font-weight: bold;
    text-decoration: none;
    font-family: Verdana, Sans-Serif;
    font-size: 12px;
    }
    #nav a:hover {
    color: #00A8FF;
    background-color: #ffffff;
    border: 1px solid #727272;
    border-bottom: 1px solid #ffffff;
    }
    </style>
    </head>
    <body class="UsePageBg">
    <div id="nav">
    <a href="viewip.php">Посещения</a> <a href="viewban.php">Баннати IP</a> <a href=logout.php>Изход</a>
    </div><br><br>
    <?php
    include ("config.php");
    $ip = $_GET['ip'];
    $data = date("F j, Y, g:i a");
    
    mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $query = "INSERT INTO `ban` ( `id_ban` , `ip`, `data`)
    VALUES (
    'NULL', '$ip', '$data'
    );";
    $ok = mysql_query($query);
    if($ok){
    echo "IP $ip беше баннат";
    }else{
    echo "Възникна грешка";
    }
    
    ?>
    
    </body>
    </html>

    admin.php

    <?php session_start();
    
    include('pro1.php');
    
    $username = $_POST['username'];
    
    $password = $_POST['password'];
    
    
    ?>
    
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    
    <html>
    
    <head>
    
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    
    <title>Админ панел</title>
    
    <style type="text/css">
    
    <!--
    
    body,td,th {
    
    font-family: Verdana, Arial, Helvetica, sans-serif;
    
    font-size: 10px;
    
    color: #000000;
    
    }
    
    a:link {
    
    color: #FF0000;
    
    text-decoration: none;
    
    }
    
    a:visited {
    
    text-decoration: none;
    
    color: #FF0000;
    
    }
    
    a:hover {
    
    text-decoration: underline;
    
    color: #FF6600;
    
    }
    
    a:active {
    
    text-decoration: none;
    
    color: #FF6600;
    
    }
    
    a {
    
    font-size: 10px;
    
    }
    
    -->
    
    </style></head>
    
    
    
    <body>
    
    <table width="400" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#999999">
    
    <tr>
    
    <td><table width="400" border="0" align="center" cellpadding="0" cellspacing="0">
    
    <tr>
    
    <td><div align="center"></div></td>
    
    </tr>
    <br>
    <center>Административен панел</center>
    <br>
    
    <tr>
    
    <td height="145">
    
    <?php if($_POST['submit']){
    
    if($username == $username2 && $password == $password2) {
    
    session_register("username");
    
    $_SESSION['username'] = $username;
    
    echo "<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=viewip.php\">";
    
    }
    
    } ?>
    
    <form name="form1" method="post" action="">
    
    Username:<br>
    
    <input name="username" type="text" id="username">
    
    <br>
    
    Password: <br>
    
    <input name="password" type="password" id="password">
    
    <br>
    
    <br>
    
    <input name="submit" type="submit" id="submit" value="Login!">
    
    <br>
    
    <br>
    
    </form></td>
    
    </tr>
    
    <tr>
    
    <td><div align="center">Powered by <a href="http://webjo.to.md" target="_blank">Web-Journal</a></div></td>
    
    </tr>
    
    </table></td>
    
    </tr>
    
    </table>
    
    </body>
    
    </html>
    

    agent.php

    <?php
    
    $ip = $_SERVER['REMOTE_ADDR'];
    $data = date("j/n/Y G:i:s");
    $adres = 'http://'.$_SERVER['SERVER_NAME'].$_SERVER['PHP_SELF'];
    $useragent = ($_SERVER['HTTP_USER_AGENT']);
    $brouser = ($_SERVER['HTTP_USER_AGENT']);
    $var = file("http://api.hostip.info/get_html.php?ip=".$_SERVER["REMOTE_ADDR"]);
    $img = "http://api.hostip.info/flag.php?ip=$ip";
    
    $info1 = $var[0];
    $info2 = $var[1];
    
    include "config.php";
    
    
    $connect = mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $query = "INSERT INTO `agent` ( `id` , `ip` , `data`, `adres`, `brouser`, `info1`, `info2`, `img`)
    VALUES (
    'NULL', '$ip', '$data', '$adres', '$brouser', '$info1', '$info2', '$img'
    );";
    mysql_query($query);
    
    
    ?>

    ban.php

    <?php
    
    include "config.php";//инклудваме конфигуриращия файл
    
    $ipblock = $_SERVER[REMOTE_ADDR];//засичаме IP адреса на потребителя
    
    //тук правиме връзка с базата данни
    mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $query="SELECT * FROM ban";
    $result=mysql_query($query);
    
    $num=mysql_numrows($result);
    
    mysql_close();
    
    $i=0;
    while ($i < $num) {
    
    $ip=mysql_result($result,$i,"ip");
    
    //сравняваме дали IP-то на потребителя не е записано в базата данни и ако е му забраняваме достъпа.
    if (ereg($ipblock,$ip))
    {
    echo "Достъпа от IP $ip е забранен";
    exit();
    }
    $i++;
    }
    ?>

    config.php

    <?php
    
    $server = "localhost";
    $dbusername = "username";
    $dbpassword = "password";
    $db_name = "dbname";
    
    $PageSize = 25; //по колко реда на страница да показва
    
    ?>

    delban.php

    <?php
    
    session_start();
    
    if(!$_SESSION['username']){
    
    echo "Please <a href=admin.php>login.</a>";
    
    exit;
    
    }
    
    ?>
    
    <html>
    <head>
    <title>ИП адреси</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <style type="text/css">
    
    #nav {
    background-color: #D5D5D5;
    border: 1px solid #B8B8B8;
    padding-top: 8px;
    height: 21px;
    padding-left: 3px;
    }
    #nav a {
    border: 1px solid #B7B7B7;
    padding: 4px;
    background-color: #F3F3F3;
    color: #0077B4;
    font-weight: bold;
    text-decoration: none;
    font-family: Verdana, Sans-Serif;
    font-size: 12px;
    }
    #nav a:hover {
    color: #00A8FF;
    background-color: #ffffff;
    border: 1px solid #727272;
    border-bottom: 1px solid #ffffff;
    }
    </style>
    </head>
    <body class="UsePageBg">
    <div id="nav">
    <a href="viewip.php">Посещения</a> <a href="viewban.php">Баннати IP</a> <a href=logout.php>Изход</a>
    </div><br><br>
    <?php
    
    include ("config.php");
    mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $id_ban = $_GET['id_ban'];
    if(isset($id_ban)){
    $query1 = "delete from `ban` where id_ban=$id_ban";
    $result = mysql_query($query1);
    }
    $ok = mysql_query($query1);
    if($ok){
    echo "Баннатия IP адрес беше премахнат";
    }else{
    echo "Възникна грешка";
    
    };
    ?>
    </body>
    </html>

    logout.php

    <?php
    
    session_start();
    header("Cache-control: private");
    
    ?>
    <html>
    <head>
    <title>logout</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <LINK REL="STYLESHEET" TYPE="text/css">
    </head>
    <body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">
    
    <?php
    if(!$_SESSION['username']){
    echo "Ти не си влязъл!"; // Това се показва когато не си влязъл
    } else {
    
    $_SESSION['username'] = FALSE;
    echo "Ти излезна успешно";
    
    }
    ?>
    </body>
    </html>

    pro1.php

    <?php
    $username2 = "admin"; // име
    $password2 = "admin"; // парола
    ?>

    viewban.php

    <?php
    
    session_start();
    
    if(!$_SESSION['username']){
    
    echo "Please <a href=admin.php>login.</a>";
    
    exit;
    
    }
    
    
    
    include ("config.php");
    
    
    
    $StartRow = 0;
    
    
    if(empty($_GET['PageNo'])){
    if($StartRow == 0){
    $PageNo = $StartRow + 1;
    }
    }else{
    $PageNo = $_GET['PageNo'];
    $StartRow = ($PageNo - 1) * $PageSize;
    }
    
    
    if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
    }else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
    }
    
    $CounterEnd = $CounterStart + ($PageSize - 1);
    ?>
    
    <html>
    <head>
    <title>ИП адреси</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <style type="text/css">
    
    BODY {
    FONT-SIZE: 8pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    H3 {
    COLOR: #526ba5
    }
    H4 {
    COLOR: #526ba5
    }
    .Issue {
    BACKGROUND-COLOR: #c6c6ce
    }
    .NormalField {
    FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Verdana;BACKGROUND-COLOR: #ffffff
    }
    .NormalFieldTwo {
    FONT-SIZE: 10pt;
    COLOR: Red;
    FONT-FAMILY: Verdana;
    background : #E4E4E4;
    font-weight : bold
    }
    .NormalFieldThree {
    FONT-SIZE: 10pt;
    COLOR: Yellow;
    FONT-FAMILY: Verdana;
    background : #0C79B4;
    font-weight : bold;
    text-align : center;
    }
    
    .NormalFieldFour {
    FONT-SIZE: 10pt;
    COLOR: Yellow;
    FONT-FAMILY: Verdana;
    background : Black;
    font-weight : bold;
    text-align : center;
    }
    .NormalFieldFive {
    FONT-WEIGHT: bold;
    FONT-SIZE: 10pt;
    COLOR: Navy;
    FONT-FAMILY: Verdana;
    BACKGROUND-COLOR: #ffffff
    }
    .NormalFieldSix {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    
    .TableText {
    FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Arial
    }
    .TableBorder{
    border-color : Black;
    }
    .NormalTable {
    BACKGROUND-COLOR: #ffffff
    }
    .NormalTableTwo {
    BACKGROUND-COLOR: #eeeeee
    }
    .UsePageBG {
    BACKGROUND-COLOR: #cccccc
    }
    .UseTableBG {
    BACKGROUND-COLOR: #526ba5
    }
    .UseDialogBG {
    BACKGROUND-IMAGE: url(../Graphics/Images/DialogBackGround.gif)
    }
    .ReadOnlyField {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #526000; FONT-FAMILY: Arial
    }
    .InternalHeader {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-FAMILY: Arial; BACKGROUND-COLOR: #526ba5;
    }
    .AttachedFiles {
    BACKGROUND-COLOR: #99ccff;
    color : Black
    }
    .SpecialAnchor {
    FONT-FAMILY: Arial; TEXT-DECORATION: none
    }
    UNKNOWN {
    FONT-WEIGHT: lighter; FONT-SIZE: 8pt; TEXT-TRANSFORM: capitalize; COLOR: navy; FONT-STYLE: normal; FONT-FAMILY: 'Arial', Times New Roman, Verdana; FONT-VARIANT: normal; TEXT-DECORATION: underline
    }
    .SearchResults {
    FONT-WEIGHT: normal; FONT-SIZE: 8pt; COLOR: #000000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .MandatoryFields {
    FONT-WEIGHT: normal; FONT-SIZE: 10pt; COLOR: #ff0000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .tab-above-heading {
    FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: #000000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .textareaLabel {
    FONT-WEIGHT: bolder; FONT-SIZE: 10pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    .linkStyle {
    TEXT-DECORATION: none
    }
    .PageTitle {
    FONT-WEIGHT: bold; FONT-SIZE: 16pt; COLOR: #526ba5; FONT-FAMILY: Tahoma
    }
    .smallfont {
    FONT-SIZE: 7.5pt; COLOR: #000000; FONT-FAMILY: Arial
    }
    A {
    COLOR: Red;
    TEXT-DECORATION: none
    }
    
    #nav {
    background-color: #D5D5D5;
    border: 1px solid #B8B8B8;
    padding-top: 8px;
    height: 21px;
    padding-left: 3px;
    }
    #nav a {
    border: 1px solid #B7B7B7;
    padding: 4px;
    background-color: #F3F3F3;
    color: #0077B4;
    font-weight: bold;
    text-decoration: none;
    font-family: Verdana, Sans-Serif;
    font-size: 12px;
    }
    #nav a:hover {
    color: #00A8FF;
    background-color: #ffffff;
    border: 1px solid #727272;
    border-bottom: 1px solid #ffffff;
    }
    </style>
    </head>
    <body class="UsePageBg">
    <div id="nav">
    <a href="viewip.php">Посещения</a> <a href="viewban.php">Баннати IP</a>
    </div><br><br>
    <?php
    mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $TRecord = mysql_query("SELECT * FROM `ban`");
    $result = mysql_query("SELECT * FROM `ban` ORDER BY `id_ban` DESC LIMIT $StartRow,$PageSize");
    
    
    $RecordCount = mysql_num_rows($TRecord);
    
    
    $MaxPage = $RecordCount % $PageSize;
    if($RecordCount % $PageSize == 0){
    $MaxPage = $RecordCount / $PageSize;
    }else{
    $MaxPage = ceil($RecordCount / $PageSize);
    }
    ?>
    
    <table width="100%" border="0" class="InternalHeader">
    <tr>
    <td width="24%"><a href=logout.php>Изход</a></td>
    <td width="76%">
    <div align="right">
    <?php print "$RecordCount record(s) founds - You are at page $PageNo of $MaxPage" ?></div>
    </td>
    </tr>
    </table>
    <br>
    <table width="100%" border="0" class="NormalTableTwo">
    <tr>
    <td class="InternalHeader" width="4%">Номер</td>
    <td class="InternalHeader" width="36%">ID</td>
    <td class="InternalHeader" width="20%">IP</td>
    <td class="InternalHeader" width="20%">Дата</td>
    <td class="InternalHeader" width="20%">Дата</td>
    </tr>
    <?php
    $i = 1;
    while($row = mysql_fetch_array($result))
    {
    $id_ban=$row[id_ban];
    $data=$row[data];
    $ip=$row[ip];
    
    $bil = $i + ($PageNo-1)*$PageSize;
    ?>
    <tr>
    <td class="NormalFieldTwo" width="4%"><?php echo $bil ?></td>
    <td class="NormalFieldTwo" width="36%"><?php echo $id_ban ?></td>
    <td class="NormalFieldTwo" width="20%"><?php echo $ip ?></td>
    <td class="NormalFieldTwo" width="20%"><?php echo $data ?></td>
    <td class="NormalFieldTwo" width="20%"><a href=delban.php?id_ban=<?php echo $id_ban; ?>>Махане на банна</a></td>
    </tr>
    <?php
    $i++;
    }?>
    </table><br>
    <table width="100%" border="0" class="InternalHeader">
    <tr>
    <td>
    
    <div align="center">
    <?php
    
    if($CounterStart != 1){
    $PrevStart = $CounterStart - 1;
    print "<a href=?PageNo=1>Първи </a>: ";
    print "<a href=?PageNo=$PrevStart>Предишни $PageSize </a>";
    }
    print " [ ";
    $c = 0;
    
    
    for($c=$CounterStart;$c<=$CounterEnd;$c++){
    if($c < $MaxPage){
    if($c == $PageNo){
    if($c % $PageSize == 0){
    print "$c ";
    }else{
    print "$c ,";
    }
    }elseif($c % $PageSize == 0){
    echo "<a href=?PageNo=$c>$c</a> ";
    }else{
    echo "<a href=?PageNo=$c>$c</a> ,";
    }//END IF
    }else{
    if($PageNo == $MaxPage){
    print "$c ";
    break;
    }else{
    echo "<a href=?PageNo=$c>$c</a> ";
    break;
    }//END IF
    }//END IF
    }//NEXT
    
    echo "] ";
    
    if($CounterEnd < $MaxPage){
    $NextPage = $CounterEnd + 1;
    echo "<a href=?PageNo=$NextPage>Следващи $PageSize</a>";
    }
    
    
    if($CounterEnd < $MaxPage){
    $LastRec = $RecordCount % $PageSize;
    if($LastRec == 0){
    $LastStartRecord = $RecordCount - $PageSize;
    }
    else{
    $LastStartRecord = $RecordCount - $LastRec;
    }
    
    print " : ";
    echo "<a href=?PageNo=$MaxPage>Последни</a>";
    }
    ?>
    </div>
    </td>
    </tr>
    </table>
    <?php
    mysql_free_result($result);
    mysql_free_result($TRecord);
    ?>
    </body>
    </html>

    viewip.php

    <?php
    
    session_start();
    
    if(!$_SESSION['username']){
    
    echo "Please <a href=admin.php>login.</a>";
    
    exit;
    
    }
    
    
    
    include ("config.php");
    
    
    $StartRow = 0;
    
    
    if(empty($_GET['PageNo'])){
    if($StartRow == 0){
    $PageNo = $StartRow + 1;
    }
    }else{
    $PageNo = $_GET['PageNo'];
    $StartRow = ($PageNo - 1) * $PageSize;
    }
    
    
    if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
    }else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
    }
    
    
    $CounterEnd = $CounterStart + ($PageSize - 1);
    ?>
    
    <html>
    <head>
    <title>ИП адреси</title>
    <meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
    <style type="text/css">
    
    BODY {
    FONT-SIZE: 8pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    H3 {
    COLOR: #526ba5
    }
    H4 {
    COLOR: #526ba5
    }
    .Issue {
    BACKGROUND-COLOR: #c6c6ce
    }
    .NormalField {
    FONT-WEIGHT: bold; FONT-SIZE: 10pt; COLOR: red; FONT-FAMILY: Verdana;BACKGROUND-COLOR: #ffffff
    }
    .NormalFieldTwo {
    FONT-SIZE: 7pt;
    
    FONT-FAMILY: Verdana;
    background : #E4E4E4;
    font-weight : bold
    }
    .NormalFieldThree {
    FONT-SIZE: 10pt;
    COLOR: Yellow;
    FONT-FAMILY: Verdana;
    background : #0C79B4;
    font-weight : bold;
    text-align : center;
    }
    
    .NormalFieldFour {
    FONT-SIZE: 10pt;
    COLOR: Yellow;
    FONT-FAMILY: Verdana;
    background : Black;
    font-weight : bold;
    text-align : center;
    }
    .NormalFieldFive {
    FONT-WEIGHT: bold;
    FONT-SIZE: 10pt;
    COLOR: Navy;
    FONT-FAMILY: Verdana;
    BACKGROUND-COLOR: #ffffff
    }
    .NormalFieldSix {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    
    .TableText {
    FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Arial
    }
    .TableBorder{
    border-color : Black;
    }
    .NormalTable {
    BACKGROUND-COLOR: #ffffff
    }
    .NormalTableTwo {
    BACKGROUND-COLOR: #eeeeee
    }
    .UsePageBG {
    BACKGROUND-COLOR: #cccccc
    }
    .UseTableBG {
    BACKGROUND-COLOR: #526ba5
    }
    .UseDialogBG {
    BACKGROUND-IMAGE: url(../Graphics/Images/DialogBackGround.gif)
    }
    .ReadOnlyField {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #526000; FONT-FAMILY: Arial
    }
    .InternalHeader {
    FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-FAMILY: Arial; BACKGROUND-COLOR: #526ba5;
    }
    .AttachedFiles {
    BACKGROUND-COLOR: #99ccff;
    color : Black
    }
    .SpecialAnchor {
    FONT-FAMILY: Arial; TEXT-DECORATION: none
    }
    UNKNOWN {
    FONT-WEIGHT: lighter; FONT-SIZE: 8pt; TEXT-TRANSFORM: capitalize; COLOR: navy; FONT-STYLE: normal; FONT-FAMILY: 'Arial', Times New Roman, Verdana; FONT-VARIANT: normal; TEXT-DECORATION: underline
    }
    .SearchResults {
    FONT-WEIGHT: normal; FONT-SIZE: 8pt; COLOR: #000000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .MandatoryFields {
    FONT-WEIGHT: normal; FONT-SIZE: 10pt; COLOR: #ff0000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .tab-above-heading {
    FONT-WEIGHT: bold; FONT-SIZE: 12pt; COLOR: #000000; FONT-STYLE: normal; FONT-FAMILY: Arial, Helvetica, sans-serif; TEXT-DECORATION: none
    }
    .textareaLabel {
    FONT-WEIGHT: bolder; FONT-SIZE: 10pt; COLOR: #526ba5; FONT-FAMILY: Arial
    }
    .linkStyle {
    TEXT-DECORATION: none
    }
    .PageTitle {
    FONT-WEIGHT: bold; FONT-SIZE: 16pt; COLOR: #526ba5; FONT-FAMILY: Tahoma
    }
    .smallfont {
    FONT-SIZE: 7.5pt; COLOR: #000000; FONT-FAMILY: Arial
    }
    A {
    COLOR: Red;
    TEXT-DECORATION: none
    }
    
    #nav {
    background-color: #D5D5D5;
    border: 1px solid #B8B8B8;
    padding-top: 8px;
    height: 21px;
    padding-left: 3px;
    }
    #nav a {
    border: 1px solid #B7B7B7;
    padding: 4px;
    background-color: #F3F3F3;
    color: #0077B4;
    font-weight: bold;
    text-decoration: none;
    font-family: Verdana, Sans-Serif;
    font-size: 12px;
    }
    #nav a:hover {
    color: #00A8FF;
    background-color: #ffffff;
    border: 1px solid #727272;
    border-bottom: 1px solid #ffffff;
    }
    </style>
    </head>
    <body class="UsePageBg">
    <div id="nav">
    <a href="viewip.php">Посещения</a> <a href="viewban.php">Баннати IP</a>
    </div><br><br>
    <?php
    mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
    @mysql_select_db($db_name) or die("Грешна база данни");
    $TRecord = mysql_query("SELECT * FROM `agent`");
    $result = mysql_query("SELECT * FROM `agent` ORDER BY `id` DESC LIMIT $StartRow,$PageSize");
    
    
    $RecordCount = mysql_num_rows($TRecord);
    
    
    $MaxPage = $RecordCount % $PageSize;
    if($RecordCount % $PageSize == 0){
    $MaxPage = $RecordCount / $PageSize;
    }else{
    $MaxPage = ceil($RecordCount / $PageSize);
    }
    ?>
    
    <table width="100%" border="0" class="InternalHeader">
    <tr>
    <td width="24%"><a href=logout.php>Изход</a></td>
    <td width="76%">
    <div align="right">
    <?php print "$RecordCount record(s) founds - You are at page $PageNo of $MaxPage" ?></div>
    </td>
    </tr>
    </table>
    <br>
    <table width="100%" border="0" class="NormalTableTwo">
    <tr>
    <td class="InternalHeader" width="2%">Номер</td>
    <td class="InternalHeader" width="8%">Дата</td>
    <td class="InternalHeader" width="10%">IP</td>
    <td class="InternalHeader" width="25%">Адрес</td>
    <td class="InternalHeader" width="35%">Браузер</td>
    <td class="InternalHeader" width="20%">Инфо</td>
    </tr>
    <?php
    $i = 1;
    while($row = mysql_fetch_array($result))
    {
    $id=$row[id];
    $data=$row[data];
    $ip=$row[ip];
    $adres=$row[adres];
    $brouser=$row[brouser];
    $info1=$row[info1];
    $info2=$row[info2];
    $img=$row[img];
    
    $bil = $i + ($PageNo-1)*$PageSize;
    ?>
    <tr>
    <td class="NormalFieldTwo" width="2%"><?php echo $bil ?></td>
    <td class="NormalFieldTwo" width="8%"><?php echo $data ?></td>
    <td class="NormalFieldTwo" width="10%"><a href=addban.php?ip=<?php echo $ip ?>><?php echo $ip ?></a></td>
    <td class="NormalFieldTwo" width="25%"><?php echo $adres ?></td>
    <td class="NormalFieldTwo" width="35%"><?php echo $brouser ?></td>
    <td class="NormalFieldTwo" width="20%"><?php echo "<img width=20 height=10 border=1 src=$img> $info2 <br> $info1"; ?></td>
    </tr>
    <?php
    $i++;
    }?>
    </table><br>
    <table width="100%" border="0" class="InternalHeader">
    <tr>
    <td>
    
    <div align="center">
    <?php
    //Print First & Previous Link is necessary
    if($CounterStart != 1){
    $PrevStart = $CounterStart - 1;
    print "<a href=?PageNo=1>Първи </a>: ";
    print "<a href=?PageNo=$PrevStart>Предишни $PageSize </a>";
    }
    print " [ ";
    $c = 0;
    
    //Print Page No
    for($c=$CounterStart;$c<=$CounterEnd;$c++){
    if($c < $MaxPage){
    if($c == $PageNo){
    if($c % $PageSize == 0){
    print "$c ";
    }else{
    print "$c ,";
    }
    }elseif($c % $PageSize == 0){
    echo "<a href=?PageNo=$c>$c</a> ";
    }else{
    echo "<a href=?PageNo=$c>$c</a> ,";
    }//END IF
    }else{
    if($PageNo == $MaxPage){
    print "$c ";
    break;
    }else{
    echo "<a href=?PageNo=$c>$c</a> ";
    break;
    }//END IF
    }//END IF
    }//NEXT
    
    echo "] ";
    
    if($CounterEnd < $MaxPage){
    $NextPage = $CounterEnd + 1;
    echo "<a href=?PageNo=$NextPage>Следващи $PageSize</a>";
    }
    
    //Print Last link if necessary
    if($CounterEnd < $MaxPage){
    $LastRec = $RecordCount % $PageSize;
    if($LastRec == 0){
    $LastStartRecord = $RecordCount - $PageSize;
    }
    else{
    $LastStartRecord = $RecordCount - $LastRec;
    }
    
    print " : ";
    echo "<a href=?PageNo=$MaxPage>Последни</a>";
    }
    ?>
    </div>
    </td>
    </tr>
    </table>
    <?php
    mysql_free_result($result);
    mysql_free_result($TRecord);
    ?>
    </body>
    </html>

    и остана само db.sql

    CREATE TABLE `agent` (
    `id` int(11) NOT NULL auto_increment,
    `ip` varchar(30) NOT NULL,
    `data` varchar(30) NOT NULL,
    `adres` text NOT NULL,
    `brouser` varchar(255) NOT NULL,
    `info1` varchar(200) NOT NULL,
    `info2` varchar(200) NOT NULL,
    `img` varchar(250) NOT NULL,
    PRIMARY KEY (`id`)
    );
    
    
    CREATE TABLE `ban` (
    `id_ban` int(11) NOT NULL auto_increment,
    `ip` varchar(30) NOT NULL,
    `data` varchar(30) NOT NULL,
    PRIMARY KEY (`id_ban`)
    );

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

    а сега за системата, ноцно е да редактирате файловете config.php и pro1.php.

    а във всички страници на саита ви наи горе трябва да инклуднете файловете ban.php и agent.php

    read my.txt

    преди да започнете работа има няколко стъпки които трябва да изпълните.
    
    1. да импортирате базата данни
    2. да отворите файл config.php и да нагласите настройките
    3. да отворите файл pro1.php и да въведете потребителско име и парола за админ панела
    4. да инклуднете файл ban.php във всяка ваша страница в самото начало и непосредствено
    след него файл agent.php
    
    Пример:
    <?php
    include "ban.php";
    ?>
    <?php
    include "agent.php";
    ?>
    
    5. може да започнете работа.

    Това е всичко. при въпроси на ЛС или тук Smile

    Забравих да кажа, че има хостинг компании който забраняват функцията file() която се ползва в agent.php. за да се избегне показването на грешка, просто намерете следния ред

    $var = file("http://api.hostip.info/get_html.php?ip=".$_SERVER["REMOTE_ADDR"]);

    и сложете две наклонени черти пред него.

    //$var = file("http://api.hostip.info/get_html.php?ip=".$_SERVER["REMOTE_ADDR"]);