webagent ?

iwanov · 29 Март 2007

Начи направил съм webagentа на жоро и изкам да попитам как да направя потребителите да могат да виждат само резултатите без да могат да барат нищо ?

Galli · 30 Март 2007

Така става ли? Просто съм махнал няколко реда. Запиши го в нов файл. Иначе ако искаш по сложно, ще трябва да да сложиш някакви левъли на потребителите.

Код:

<?php

include ("config.php");


//Set the page size

$StartRow = 0;

//Set the page no
if(empty($_GET['PageNo'])){
    if($StartRow == 0){
        $PageNo = $StartRow + 1;
    }
}else{
    $PageNo = $_GET['PageNo'];
    $StartRow = ($PageNo - 1) * $PageSize;
}

//Set the counter start
if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
}else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}

//Counter End
$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">
<?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");

 //Total of record
 $RecordCount = mysql_num_rows($TRecord);

 //Set Maximum Page
 $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="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>

iwanov · 30 Март 2007

Galli мерси много за труда който си положил ама ми трябва да показва само уникалните щото тук показва всичко. :wink:

Galli · 31 Март 2007

Трябваше и двете да ги напиша, няма голям труд. Ето ти за уникалните.

Код:

<?php
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: #202c46; FONT-FAMILY: Verdana
}
H3 {
	COLOR: #526ba5
}
H4 {
	COLOR: #526ba5
}
.UsePageBG {
	BACKGROUND-COLOR: #cccccc
}
.InternalHeader {
	FONT-WEIGHT: bold; FONT-SIZE: 8pt; COLOR: #ffffff; FONT-FAMILY: Arial; BACKGROUND-COLOR: #234051;
}
.NormalTableTwo {
	BACKGROUND-COLOR: #eeeeee
}
.NormalFieldTwo {
	FONT-SIZE: 7pt;

	FONT-FAMILY: Verdana;
	background : #E4E4E4;
	font-weight : bold
}	
A {
	COLOR: Red;
	TEXT-DECORATION: none
}

#nav {
background-color: #234051;
border: 0px solid #B8B8B8;
padding-top: 1px;
height: 19px;
padding-left: 0px;
}
#nav a {
border: 0px solid #B7B7B7;
padding: 4px;
background-color: #234051;
color: #6191ac;
font-weight: bold;
text-decoration: none;
font-family: Verdana, Sans-Serif;
font-size: 12px;
}
#nav a:hover {
color: #d0d0d0;
background-color: #234051;
border: 0px solid #727272;
border-bottom: 0px 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 `agentuni`");
$result = mysql_query("SELECT * FROM `agentuni` 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>

flex · 31 Март 2007

някой може ли да ми помогне защото като си сложих на жоро webagent-а ми дава грешка като го отворя :

Код:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, support@freehostia.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Apache/1.3.33 Server at f1r3fl3x.freehostia.com Port 80

iwanov · 31 Март 2007

Мерси много за помоща.

webagent ?

iwanov

Registered

Galli

Registered

iwanov

Registered

Galli

Registered

flex

Registered

iwanov

Registered