Cum rezolv ? phpbb3

[hopa ;x]

Salut. am gasit pe net un admin stats.. si am ceva probleme.. ma poate ajuta cineva ?



Imi poate spune cineva ce sa-i fac?

[miber]

Cand o fii imaginea mare atunci poate o sa te ajutam.

[hopa ;x]

Edit !

[k i n g]

ai pus baza de date? l-ai instalat complet?

[hopa ;x]

Code: Select all

ai pus baza de date? l-ai instalat complet?

da la-m instalat 100%.

[k i n g]

posteaza liniile care apar acolo sa vedem si noi despre ce e vorba.

[hopa ;x]

nu stiu care-s liniile exacte... uitati index..

| Afiseaza codul

<?php

//////////////////////////////////////////


if (file_exists("install")) {			
echo '<div style="width=650px; padding: 15px; margin: 0 auto; background-color: #000; border:1px solid #F00; text-align:center; color:#FFF;">
Sterge directorul "install" sau redenumeste-l !</div>';
}

ob_start();

include("includes/config.php");
include("template/header.tpl");

function m2h($mins) { 
            if ($mins < 0) { 
                $min = abs($mins); 
            } else { 
                $min = $mins; 
            } 
            $H = floor($min / 60); 
            $M = ($min - ($H * 60)) / 100; 
            $hours = $H +  $M; 
            if ($mins < 0) { 
                $hours = $hours * (-1); 
            } 
            $expl = explode(".", $hours); 
            $H = $expl[0]; 
            if (empty($expl[1])) { 
                $expl[1] = 00; 
            } 
            $M = $expl[1]; 
            if (strlen($M) < 2) { 
                $M = $M . 0; 
            } 
            $hours = $H . ":" . $M; 
            return $hours; 
    } 
	
$day = date("d");
$month = date("m");
$year = date("Y");
$time = strtotime("now");
$last = strtotime("now") - 3500;

echo "<div align='center'><br><table class='x'><tr>
<td width='40px' class='title'>Rank</td>
<td class='title' width='150px'>User</td>
<td width='100px' class='title'>Redirectati</td>
<td width='150px' class='title'>Timp total Azi</td>
<td width='150px' class='title'>Timp Total</td>
<td width='150px' class='title'>Active</td>
<td width='200px' class='title'>Ultimul redirectat</td>
<td width='200px' class='title'>Total Redirectionati</td>
<td width='50px' class='title'>Detalii</td>
</tr>";

$i=1;

$getdata = mysql_query("SELECT * FROM fdev_redirect WHERE day = '$day' AND month = '$month' ORDER BY players DESC");
  
while($row = mysql_fetch_array($getdata))
{
  if($i&1) { $class = 'class="odd"';} else {$class = 'class="even"';} 
  $propietar = $row['admin'];
  $time = $row['time'];
  $total = $row['players'];
  $totaltimeazi = m2h($row['totaltime']);
  
  $gets0 = mysql_query("SELECT propietar FROM fdev_redirect_stats WHERE propietar = '$propietar'");
  if(mysql_num_rows($gets0) > 0) {

$totaltime = mysql_result(mysql_query("SELECT SUM($totaltime) FROM fdev_redirect WHERE admin = '{$propietar}' "),0);

  print("<tr $class><td align='center'><center>$i</center></td><td align='left'>&nbsp;&nbsp;<i>$propietar</i></td>");
  print("<td align='center'><center>$total</center></td>");
  print("<td align='center'><center>$totaltimeazi</center></td>");
  print("<td align='center'><center>".m2h($totaltime)."</center></td>");
  print("<td align='center'>");
  
  $gets1 = mysql_query("SELECT COUNT(port) FROM fdev_redirect_stats WHERE propietar = '$propietar' AND day = '$day' AND month = '$month' AND time > '$last' GROUP BY propietar");
  if(mysql_num_rows($gets1) > 0) {
  while($row = mysql_fetch_array($gets1))
  {
   echo "<font color='#FF0000'><center>".$row['COUNT(port)']."</center></font>";
  }
  } else { echo "<center>0</center>"; }
 
$totalred = mysql_result(mysql_query("SELECT SUM(players) FROM fdev_redirect WHERE admin = '{$propietar}' "),0);

    print("</td>");
	print("<td align='center'><center>$time</center></td>");
	print("<td align='center'><center>$totalred</center></td>");
    print('<td align="center"><a href="details.php?n='.$propietar.'" title="Click pentru detalii"><img src="template/images/plus.png" border="0"></a></td></tr>');

$i++;
}

}

echo "</table></div><br><br><div align='center'>";

//Total SUM
$totaljucatori = mysql_query("SELECT SUM(players), SUM(totaltime) FROM fdev_redirect WHERE month = '$month' AND day = '$day'");
while($row = mysql_fetch_array($getdata))
{
  $totalj = $row['SUM(players)'];
  $totalt = m2h($row['SUM(totaltime)']);
  print("Total jucatori redirectionati: $totalj &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
}

  $gettr = mysql_query("SELECT COUNT(port) FROM fdev_redirect_stats WHERE day = '$day' AND month = '$month' AND time > '$last'");
  if(mysql_num_rows($gettr) > 0) {
  while($row = mysql_fetch_array($getdata))
  {
	$totalr = $row['COUNT(port)'];
    print("Total redirecturi pornite: $totalr");
  }
  } else {  print("Total redirecturi pornite: 0"); }
 
print("</div><br><br>");
$footer = 1;
include("template/footer.tpl");
// Update grafic
$last_modified = filemtime("grafic.png");
$now = strtotime("now");
$old = $now - $last_modified;

if($old > 3600) {
@include("grafic.php");
}
///////////////////////////////////

$bufferContent = ob_get_contents();
ob_end_flush();
$fp = fopen ( 'cache/index.html' , 'w' ) or die ( 'Error opening cache file' );
fwrite ( $fp , $bufferContent );
fclose( $fp );
?>

[k i n g]

Am incercat ceva:

| Afiseaza codul

<?php

//////////////////////////////////////////


if (file_exists("install")) {			
echo '<div style="width=650px; padding: 15px; margin: 0 auto; background-color: #000; border:1px solid #F00; text-align:center; color:#FFF;">
Sterge directorul "install" sau redenumeste-l !</div>';
}

ob_start();

include("includes/config.php");
include("template/header.tpl");

function m2h($mins) { 
            if ($mins < 0) { 
                $min = abs($mins); 
            } else { 
                $min = $mins; 
            } 
            $H = floor($min / 60); 
            $M = ($min - ($H * 60)) / 100; 
            $hours = $H +  $M; 
            if ($mins < 0) { 
                $hours = $hours * (-1); 
            } 
            $expl = explode(".", $hours); 
            $H = $expl[0]; 
            if (empty($expl[1])) { 
                $expl[1] = 00; 
            } 
            $M = $expl[1]; 
            if (strlen($M) < 2) { 
                $M = $M . 0; 
            } 
            $hours = $H . ":" . $M; 
            return $hours; 
    } 
	
$day = date("d");
$month = date("m");
$year = date("Y");
$time = strtotime("now");
$last = strtotime("now") - 3500;

echo "<div align='center'><br><table class='x'><tr>
<td width='40px' class='title'>Rank</td>
<td class='title' width='150px'>User</td>
<td width='100px' class='title'>Redirectati</td>
<td width='150px' class='title'>Timp total Azi</td>
<td width='150px' class='title'>Timp Total</td>
<td width='150px' class='title'>Active</td>
<td width='200px' class='title'>Ultimul redirectat</td>
<td width='200px' class='title'>Total Redirectionati</td>
<td width='50px' class='title'>Detalii</td>
</tr>";

$i=1;

$getdata = mysql_query("SELECT * FROM fdev_redirect WHERE day = '$day' AND month = '$month' ORDER BY players DESC");
  
if(is_resource($result))
    {
        while($row = mysql_fetch_array($result))
            {//process your code here}
    }
{
  if($i&1) { $class = 'class="odd"';} else {$class = 'class="even"';} 
  $propietar = $row['admin'];
  $time = $row['time'];
  $total = $row['players'];
  $totaltimeazi = m2h($row['totaltime']);
  
  $gets0 = mysql_query("SELECT propietar FROM fdev_redirect_stats WHERE propietar = '$propietar'");
  if(mysql_num_rows($gets0) > 0) {

$totaltime = mysql_result(mysql_query("SELECT SUM($totaltime) FROM fdev_redirect WHERE admin = '{$propietar}' "),0);

  print("<tr $class><td align='center'><center>$i</center></td><td align='left'>&nbsp;&nbsp;<i>$propietar</i></td>");
  print("<td align='center'><center>$total</center></td>");
  print("<td align='center'><center>$totaltimeazi</center></td>");
  print("<td align='center'><center>".m2h($totaltime)."</center></td>");
  print("<td align='center'>");
  
  $gets1 = mysql_query("SELECT COUNT(port) FROM fdev_redirect_stats WHERE propietar = '$propietar' AND day = '$day' AND month = '$month' AND time > '$last' GROUP BY propietar");
  if(mysql_num_rows($gets1) > 0) {
  while($row = mysql_fetch_array($gets1))
  {
   echo "<font color='#FF0000'><center>".$row['COUNT(port)']."</center></font>";
  }
  } else { echo "<center>0</center>"; }
 
$totalred = mysql_result(mysql_query("SELECT SUM(players) FROM fdev_redirect WHERE admin = '{$propietar}' "),0);

    print("</td>");
	print("<td align='center'><center>$time</center></td>");
	print("<td align='center'><center>$totalred</center></td>");
    print('<td align="center"><a href="details.php?n='.$propietar.'" title="Click pentru detalii"><img src="template/images/plus.png" border="0"></a></td></tr>');

$i++;
}

}

echo "</table></div><br><br><div align='center'>";

//Total SUM
$totaljucatori = mysql_query("SELECT SUM(players), SUM(totaltime) FROM fdev_redirect WHERE month = '$month' AND day = '$day'");
while($row = mysql_fetch_array($getdata))
{
  $totalj = $row['SUM(players)'];
  $totalt = m2h($row['SUM(totaltime)']);
  print("Total jucatori redirectionati: $totalj &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;");
}

  $gettr = mysql_query("SELECT COUNT(port) FROM fdev_redirect_stats WHERE day = '$day' AND month = '$month' AND time > '$last'");
  if(mysql_num_rows($gettr) > 0) {
if(is_resource($result))
    {
        while($row = mysql_fetch_array($result))
            {//process your code here}
    }
  {
	$totalr = $row['COUNT(port)'];
    print("Total redirecturi pornite: $totalr");
  }
  } else {  print("Total redirecturi pornite: 0"); }
 
print("</div><br><br>");
$footer = 1;
include("template/footer.tpl");
// Update grafic
$last_modified = filemtime("grafic.png");
$now = strtotime("now");
$old = $now - $last_modified;

if($old > 3600) {
@include("grafic.php");
}
///////////////////////////////////

$bufferContent = ob_get_contents();
ob_end_flush();
$fp = fopen ( 'cache/index.html' , 'w' ) or die ( 'Error opening cache file' );
fwrite ( $fp , $bufferContent );
fclose( $fp );
?>

[The Kalu]

#1 posteaza header.tpl ca ai si acolo o eroare.
#2 sigur ai pus si baza de date?

[hopa ;x]

Header

| Afiseaza codul

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr" >

<head>
  <meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <meta name="robots" content="index, follow" />
  <meta name="keywords" content="joomla, Joomla" />
  <meta name="description" content="Admin Stats" />
  <meta name="generator" content="Joomla! 1.5 - Open Source Content Management" />
<?php
$getdata = mysql_query("SELECT * FROM fdev_settings");
while($row = mysql_fetch_array($getdata))
{
  $site_name = $row['site_name'];
  $site_description = $row['site_description'];
  $website_url = $row['website_adress'];
  $forum_url = $row['forum_adress'];
  $script_path = $row['script_path'];
?>

  <title><?php echo $site_name;?></title>
  <link href="index7ebc.php@option=com_content&view=section&layout=blog&id=3&Itemid=61&format=feed&type=rss" rel="alternate" type="application/rss+xml" title="RSS 2.0" />
  <link href="index32c5.php@option=com_content&view=section&layout=blog&id=3&Itemid=61&format=feed&type=atom" rel="alternate" type="application/atom+xml" title="Atom 1.0" />
<link rel="stylesheet" type="text/css" href="template/style.css">
		<script src="templates/scripts/jquery-1.3.2.min.js" type="text/javascript"></script>
    <script src="templates/scripts/cufon-yui.js" type="text/javascript"></script>
<script src="templates/scripts/cufon-replace.js" type="text/javascript"></script>
    <script src="templates/scripts/Swis721_BT_5F400.font.js" type="text/javascript"></script>
    <script src="templates/scripts/Franklin_Gothic_Book_5F400.font.js" type="text/javascript"></script>
    <script src="templates/scripts/jquery.infinitecarousel.js" type="text/javascript"></script>
    <script src="templates/scripts/tiny.js" type="text/javascript"></script>
	<script type="text/javascript">
<!--
    function toggle_visibility(id) {
       var e = document.getElementById(id);
       if(e.style.display == 'block')
          e.style.display = 'none';
       else
          e.style.display = 'block';
    }
//-->
</script>
	<script type="text/javascript">
	var $j = jQuery.noConflict();
		$j(document).ready(function(){
		$j('.menu-nav li').hover(
			function() {
				$j(this).addClass("active");
				$j(this).find('.ulwrapper').stop(false, true).slideDown();
				$j(this).find('.ulwrapper .ulwrapper').stop(false, true).slideUp('fast');
			},
			function() {
				$j(this).removeClass("active");        
				$j(this).find('div').stop(false, true).slideUp('fast');
			}
		);
		$j('.ulwrapper').hover(
			function() {
				$j('.parent').addClass("active_tab");
			},
			function() {
				$j('.parent').removeClass("active_tab");        
			}
		);
	});
	

	</script>
    <script type="text/javascript"> 
		var $j = jQuery.noConflict();
		$j.fn.cycle.defaults.timeout = 6000;
		$j(function() {
		// run the code in the markup!
		$j('table pre code').not('#skip,#skip2').each(function() {
			eval($j(this).text());
		});
		
		$j('#s4').before('<div id="nav" class="nav">').cycle({
			fx:     'fade',
			speed:  'slow',
			autostopCount:   4,
			autostop:   4,
			timeout: 6000,
			pager:  '#nav'
		});
	});
	$j(document).ready(function(){
		$j('#carousel1').bxCarousel({
			display_num: 5,
			move: 2,
			prev_image: '../joomla_29443/templates/images/icon_arrow_left.gif',
			next_image: '../joomla_29443/templates/images/icon_arrow_right.gif',
			margin: 10
		});
	});
	 
	
	</script> 


	<!--[if IE 6]><script type="text/javascript" src="../../info.template-help.com/files/ie6_warning/ie6_script_other.js"></script><![endif]-->

	<link rel="stylesheet" href="templates/css/constant.css" type="text/css" />
	<link rel="stylesheet" href="templates/css/template.css" type="text/css" />
	</head>
       <SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/fusioncharts.js"></SCRIPT> 
		<body class="all">
	    <div class="main"> 
      <!--header-->
      <div class="header">
				<div class="sub_header_title">
					<?php echo $site_name;?>				</div>
				<div class="sub_header_title_shadow">
					<?php echo $site_name;?>				</div>            
				
<div id="menu">
<ul class="menu-nav">
	<li id="current" class="top active item53">
		<a href="index.php">
			<strong>Home</strong>
		</a>
	</li>
	
	<li class="top parent item55">
		<a href=""><strong>Redirect Stats</strong>
		</a>
        <div class="ulwrapper">
			<ul>
				<li class="item59">
					<a href="index.php">
						<strong>Clasamentul zilei</strong>
					</a>
				</li>
				<li class="item59">
					<a href="clas_lunar.php">
						<strong>Clasamentul Lunar</strong>
					</a>
				</li>
				<li class="item59">
					<a href="clas_anual.php">
						<strong>Clasamentul Anual</strong>
					</a>
				</li> 				
				<li class="item60">
					<a href="download_redirect.php">
						<strong>Download redirect</strong>
					</a>
				</li>

			</ul>
		</div>
	</li>
	<li class="top item56">
		<a href="<?php echo $website_url;?>">
			<strong>Forum</strong>
		</a>

	</li>
	<li class="top item57">
		<a href="admin.php">
			<strong>Configurare</strong>
		</a>
	</li>
</ul>	    
</div>
<h1 id="logo"><a href="index.php" title="Super Team"><img  title="Admin Stats" src="templates/images/logo.png"   alt="Admin Stats"  /></a></h1>
			 
           
      </div>
      <!--slider-->
      <div class="wrapper-content content-top" id="content">
       
      	
        
        <div class="clear p1"> 
          <!--content-->
             <!--left-->
                            <div id="left_index">
                 <div class="bgs_top_content"><div class="bgs_top_content1"></div></div>      
                 <!-- <div class="bgs_top">-->
                  	<div class="bgs_bottom">
                    <div class="bg">
                  	  <h2><div class="welcom_more"><?php echo $site_name;?></div></h2>
                  	  
                  	    
<?php
include ("server.php");
?> 

               	      

                  	    <p>&nbsp;</p>
                    </div></div>
              
                 </div>  
                          
              <!--center-->
              <div class="container">
                <div class="clear">
                                    <div class="bgs_top_content"><div class="bgs_top_content1"></div></div>
                  	<div class="bg_content">
                          <?php } ?>

de pus am puso . dar nu cred ca o puses bine :-?

[The Kalu]

adauga la fiecare interogare.

Code: Select all

 or die(mysql_error());

Exemplu:

Code: Select all

mysql_query("SELECT * FROM fdev_settings") or die(mysql_error());

Si spune-mi ce eroare afiseaza.

[hopa ;x]

ma ajuta careva? :-ss