Navigacija

Vartotojų tinkle

Prisijungusių svečių: 540
Prisijungusių narių: 0
Prisijungusių narių nėra

Registruoti nariai: 25,956
Naujausias narys: saulyzas

Naujausi straipsniai

Paskutiniai nariai

saulyzas 6 dienos
MaFetas 1 savaitė
TOMIJUS 2 savaitės
ozzWANTED 2 savaitės
Reikalas11 savaitės
Jaunelis17 savaitės
lanis17 savaitės
And2s18 savaitės
Memento Mori23 savaitės
Quwqkibor25 savaitės
asirija29 savaitės
tomeem31 savaitės
weberiz34 savaitės
mRokass37 savaitės
kartoonas38 savaitės
grunskiz41 savaitės
Bruksnys41 savaitės
illusion41 savaitės
ordo42 savaitės
Jurgaila43 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 3.14.132.178
Naujienų: 529
Straipsnių: 235
Temų: 52,588
Postų: 522,537
Postų pask. parą: 0
Shout'ų pask. parą: 0
P.S.C. pask. parą: 0
Nuorodų kataloge: 13

Lankomumo Statistika

Peržiūrų šiandien: 22

Iš viso peržiūrų: 22948724

Prisijungti

REGISTRUOTIS
Nario vardas

Slaptažodis



Pamiršai slaptažodį?
Paprašyk naujo

Aktyvuoti save

Šaukykla

Jei norite rašyti žinutes, turite prisijungti.

MaFetas
2024 Lap. 13 22:11:57
hey how, geras dar veikiantis saitas?

Jaunelis
2024 Lie. 25 11:07:43
Oho vis dar veikia svetainė akinanti šypsen Šimtas metų, matau Šaukykloje nuostalgija. Smagu panaršyt po forumą ir pažiūrėt senas temas šypsosi

And2s
2024 Lie. 17 19:07:04
2008 pirmą kart čia patekau, man buvo 10m ir čia pramokau programavimo.. smagu skaityti senas žinutes, tokia nostalgija akinanti šypsen ačiū Ozz kad saugoji šitą kultūrinį reliktą šypsosi

ozzWANTED
2024 Sau. 17 01:01:00
Desperatiškus komentarus šaukykloje su accountu po mėnesio prasibuvimo, ištryniau. Pasaulis ir taip juodas. Įjungiam šviesą, prašviesės. šypsosi

Majakas
2023 Gru. 10 19:12:39
Negaliu patikėti jog žinutės/pranešimai visi yra nuo 2008 m akinanti šypsen

Šaukyklos archyvas

Apklausa

Ar esate patenkinti lietuviško vertimo kokybe?

Taip!

Taip, bet yra ką taisyti (parašysiu komentaruose)

Ne

Norėdamas balsuoti turite prisijungti.
Archyvas
Reklama 400x60
Downloads.php failų padėtis
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Bendri PHP-F klausimai

Autorius: Tadziokaz Peržiūrų: 2334      Spausdinti temą
2009 Vas. 6 21:02:09          1 žinutė iš 9
Spausdinti pranešimą
Kaip padaryti kad lenteles rikiuotusi taip? Ir taip kokias 5 eilutes apacioj iki kito lapo? nes dabar eina va kaip - http://themes.gan.lt/downloads.p...


Download.php kodas:
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."downloads.php";

if (isset($download_id) && !isNum($download_id)) fallback("index.php");

if (isset($download_id)) {
   $res = 0;
   if ($data = dbarray(dbquery("SELECT download_url,download_cat FROM ".$db_prefix."downloads WHERE download_id='$download_id'"))) {
      $cdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'"));
      if (checkgroup($cdata['download_cat_access'])) {
         $res = 1;
         $result = dbquery("UPDATE ".$db_prefix."downloads SET download_count=download_count+1 WHERE download_id='$download_id'");
         redirect($data['download_url']);
      }
   }
   if ($res == 0) redirect("downloads.php");
}



if (isset($d_id)) {
include INCLUDES."ratings_include.php";
include INCLUDES."comments_include.php";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$d_id'");
while ($data = dbarray($result)) {
               $id = $data['download_cat'];
               if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
                  $new = " <span class='small'>".$locale['410']."</span>";
               } else {
                  $new = "";
               }
               $time = $data['download_datestamp'];
               $laikas = showdate( "%d.%m.%y", $time);
               $kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);
               echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
               echo "<tr>
<td colspan='5' class='forum-caption'>
               <table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>

               <td>&nbsp;<a href='".FUSION_SELF."' class='small' title='Siuntiniai'><b>Siuntiniai</b></a>&nbsp;>>&nbsp;<a href='".FUSION_SELF."?cat_id=".$data['download_cat']."' class='small' title='Siuntinio Kategorija'><b>$kat</b></a>&nbsp;>&nbsp;<a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&amp;download_id=".$data['download_id']."' title='Atsisiųsti Siuntinį'><b>".$data['download_title']."</b></a> </td>
               
               </tr></table></td>
</tr>\n";
               if ($data['download_description'] != "") echo "<tr>\n
               <td colspan='5' class='tbl1'>".nl2br(stripslashes($data['download_description']))."</td></tr>\n";
               echo "<tr>
               
               <td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n<td class='tbl2' align='left' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&amp;download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>";

               echo "<td width='30%' class='tbl2'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
               echo "</table>\n";
               
               if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
            }
            
showcomments("D","downloads","download_id",$d_id,FUSION_SELF."?d_id=$d_id");

showratings("D",$d_id,FUSION_SELF."?d_id=$d_id");

} else {



if (!isset($cat_id)) {
   opentable($locale['400']);
   $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
   $rows = dbrows($result);
   if ($rows != 0) {
      $counter = 0; $columns = 2;
      echo "<center><img src='".IMAGES."downloads.png' alt='' border='0'></center>";
      echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%' align='center'>";
      
      echo "<tr>
<td class='tbl1' colspan='2' align='center'>
<form name='searchform' method='post' action='search.php' style='display: inline;'>
      <b>Ieškoti Siuntinių:</b>&nbsp; <input name='stext' class='textbox' style='width: 200px;' type='text'>
      <input name='stype' value='d' type='hidden'><input name='search' value='Ieškoti!' class='button' type='submit'>
      </form>
</td>
</tr>";
      
      while ($data = dbarray($result)) {
         
         $num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
         echo "<tr>
<td class='tbl1' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'><img src='images/dl_cats/".$data['download_cat_image']."' alt='".$data['download_cat_name']."' border='0'>
</a></td>
         <td class='tbl2' align='left' valign='center'><img src='".THEME."images/bullet.gif' alt='' border='0'>
         <a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'>".$data['download_cat_name']."</a> <span class='small2'>($num)</span><br>
         <span class='small'>".$data['download_cat_description']."</span></td>
</tr>";
         $counter++;
      }
      echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%'>
<tr>
   <td class='forum-caption' colspan='2' width='1%'>Statistika</td>

</tr>
<tr>
   <td class='tbl1' align='center' width='1%'><img src='images/dl_stats.png' alt='Siuntinių statistika' border='0'></td>
   <td class='tbl2'>
<table border='0' cellpadding='0' cellspacing='1'>";

$dataq = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,1"));
echo "<tr><td>Naujausias siuntinys: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$dataq['download_id']."' title=''>".$dataq['download_title']."</a></td>
</tr>";

$datax = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,1"));
echo "<tr><td>Populiariausias: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$datax['download_id']."' title=''>".$datax['download_title']."</a></td>
</tr>";

$cats = dbresult(dbquery("SELECT count(download_cat_id) FROM ".$db_prefix."download_cats"), 0);
echo "<tr><td>Kategorijų: </td>
<td class='small2'> $cats</td></tr>";

$countd = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"), 0);
echo "<tr>
   <td>Siuntinių: </td>
<td class='small2'> $countd</td>
</tr>";

$counth = dbresult(dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"), 0);
echo "<tr><td>Atsisiųsta: </td>
<td class='small2'> $counth</td></tr>";

echo "</table>
</td>
</tr>
</table>";
      
      $result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,20");
if (dbrows($result)) {

echo "<table class='tbl-border' style='margin-top: 10px;' border='0' cellpadding='0' cellspacing='1' width='100%'>
<tr>
      <td class='forum-caption' style='white-space: nowrap;'>Naujausi siuntiniai</td>
      <td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Data</td>

      <td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Siuntimai</td>
</tr>";
while ($data = dbarray($result)) {
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "<tr>
         <td class='tbl1'><img src='".THEME."images/bullet.gif' alt='' border='0'> <a class='small' href='downloads.php?d_id=".$data['download_id']."'>".$data['download_title']."</a></td>

         <td class='tbl1' align='center'>$laikas</td>

         <td class='tbl1' align='center'>".$data['download_count']."</td>

</tr>";
}
echo "</table>";
}
      

   } else {
      echo "<center><br>\n".$locale['430']."<br><br>\n</center>\n";
   }
   closetable();
} else {
   $res = 0;
   if (!isNum($cat_id)) fallback(FUSION_SELF);
   $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'");
   if (dbrows($result) != 0) {
      $cdata = dbarray($result);
      if (checkgroup($cdata['download_cat_access'])) {
         $res = 1;
         opentable($locale['400'].": ".$cdata['download_cat_name']);
         $rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
         if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
         if ($rows != 0) {
            $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='$cat_id' ORDER BY ".$cdata['download_cat_sorting']." LIMIT $rowstart,15");
            //s
            $catdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'"));
            $count = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads WHERE download_cat='$cat_id'"), 0);
            echo "
            <table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>
<tr>
         <td class='tbl2' style='white-space: nowrap;' align='center' valign='middle' width='1%'><a class='small' href='downloads.php?cat_id=$cat_id' title='".$catdata['download_cat_name']."'><img src='images/dl_cats/".$catdata['download_cat_image']."' alt='".$catdata['download_cat_name']."' border='0'>
</a></td>
         <td class='tbl1' valign='top'><span><a class='small' href='downloads.php'>Siuntiniai</a> » ".$catdata['download_cat_name']."</span><br>
         ".$catdata['download_cat_description']."<br><br>Siuntimų kategorijoje: <span class='small2'>$count</span></td>
</tr>

</table>

<table cellpadding='0' cellspacing='0' width='100%'><tbody><tr>
<td height='8'>
</td>
</tr>
</tbody></table>";
            //e
            
            
            $numrows = dbrows($result); $i = 1;
            while ($data = dbarray($result)) {
            $id = $data['download_id'];
               if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
                  $new = " <span class='small'>".$locale['410']."</span>";
               } else {
                  $new = "";
               }
               $time = $data['download_datestamp'];
               $laikas = showdate( "%d.%m.%y", $time);
               echo "<table width='25%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
               echo "<tr>
<td colspan='5' class='forum-caption'>
               <table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
               <td width='1%'><a class='small' style='font-weight: bold;'><img src='".IMAGES."down.png' border='0'></a></td>

               <td>&nbsp;<a class='small' style='font-weight: bold;'><b>".$data['download_title']."</b></a></td>
               </tr></table></td>
</tr>\n";
               if ($data['download_description'] != "") echo "<tr>\n
               <td colspan='5' class='tbl1'>".nl2br(stripslashes($data['download_description']))."</td>\n</tr>\n";
               echo "<tr>\n
               
               
               
               <td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n
               <td class='tbl2' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=$cat_id&amp;download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>";
               echo "</tr>\n";
               echo "<td width='30%' class='tbl2'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
               echo "</table>\n";
               
               if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
            }
            closetable();
            if ($rows > 15) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=$cat_id&amp;")."\n</div>\n";
         } else {
            echo $locale['431']."\n";
            closetable();
         }
      }
   }
   if ($res == 0) redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>





Redagavo Tadziokaz 2009 Vas. 7 10:02:54
2009 Vas. 6 22:02:02          2 žinutė iš 9
Spausdinti pranešimą
UP, davai gi kas nors ...

2009 Vas. 6 22:02:10          3 žinutė iš 9
Spausdinti pranešimą
kogero columns nusistatyk...

s.k.y.p.e - pavojuz
2009 Vas. 6 22:02:07          4 žinutė iš 9
Spausdinti pranešimą
ziurint kaip nustatyti? jei tik skaiciu padydint tai nieko kazko nesikeicia.... Beto kas moka isimti komentarus? nes ble jie mane nervina...


Redagavo Tadziokaz 2009 Vas. 6 22:02:04
2009 Vas. 7 10:02:32          5 žinutė iš 9
Spausdinti pranešimą
UP... nu tai padekit gi nežino

2009 Vas. 7 10:02:43          6 žinutė iš 9
Spausdinti pranešimą
Ne nu ... nei uzdarbis nei cia... Negi nera protingu zmoniu? galvoja Sorry uz flooda bet reiktu man susitvarkyti...

2009 Vas. 8 18:02:01          7 žinutė iš 9
Spausdinti pranešimą
Cia gers dalykas tavo. o gal kas nors zino kaip padaryt kaip jis sako , man ir praverstu merkia akį
2009 Vas. 8 19:02:15          8 žinutė iš 9
Spausdinti pranešimą
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."downloads.php";

if (isset($download_id) && !isNum($download_id)) fallback("index.php");

if (isset($download_id)) {
   $res = 0;
   if ($data = dbarray(dbquery("SELECT download_url,download_cat FROM ".$db_prefix."downloads WHERE download_id='$download_id'"))) {
      $cdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='".$data['download_cat']."'"));
      if (checkgroup($cdata['download_cat_access'])) {
         $res = 1;
         $result = dbquery("UPDATE ".$db_prefix."downloads SET download_count=download_count+1 WHERE download_id='$download_id'");
         redirect($data['download_url']);
      }
   }
   if ($res == 0) redirect("downloads.php");
}



if (isset($d_id)) {
include INCLUDES."ratings_include.php";
$result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$d_id'");
while ($data = dbarray($result)) {
               $id = $data['download_cat'];
               if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
                  $new = " <span class='small'>".$locale['410']."</span>";
               } else {
                  $new = "";
               }
               $time = $data['download_datestamp'];
               $laikas = showdate( "%d.%m.%y", $time);
               $kat = dbresult(dbquery("SELECT download_cat_name FROM ".$db_prefix."download_cats WHERE download_cat_id='$id'"), 0);
               echo "<table width='100%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
               echo "<tr>
<td colspan='5' class='forum-caption'>
               <table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>

               <td>&nbsp;<a href='".FUSION_SELF."' class='small' title='Siuntiniai'><b>Siuntiniai</b></a>&nbsp;>>&nbsp;<a href='".FUSION_SELF."?cat_id=".$data['download_cat']."' class='small' title='Siuntinio Kategorija'><b>$kat</b></a>&nbsp;>&nbsp;<a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&amp;download_id=".$data['download_id']."' title='Atsisiųsti Siuntinį'><b>".$data['download_title']."</b></a> </td>
               
               </tr></table></td>
</tr>\n";
               if ($data['download_description'] != "") echo "<tr>\n
               <td colspan='5' class='tbl1'>".nl2br(stripslashes($data['download_description']))."</td></tr>\n";
               echo "<tr>
               
               <td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n<td class='tbl2' align='left' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&amp;download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>";

               echo "<td width='30%' class='tbl2'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
               echo "</table>\n";
               
               if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
            }
           
showcomments("D","downloads","download_id",$d_id,FUSION_SELF."?d_id=$d_id");

showratings("D",$d_id,FUSION_SELF."?d_id=$d_id");

} else {



if (!isset($cat_id)) {
   opentable($locale['400']);
   $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name");
   $rows = dbrows($result);
   if ($rows != 0) {
      $counter = 0; $columns = 2;
      echo "<center><img src='".IMAGES."downloads.png' alt='' border='0'></center>";
      echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%' align='center'>";
     
      echo "<tr>
<td class='tbl1' colspan='2' align='center'>
<form name='searchform' method='post' action='search.php' style='display: inline;'>
      <b>Ieškoti Siuntinių:</b>&nbsp; <input name='stext' class='textbox' style='width: 200px;' type='text'>
      <input name='stype' value='d' type='hidden'><input name='search' value='Ieškoti!' class='button' type='submit'>
      </form>
</td>
</tr>";
     
      while ($data = dbarray($result)) {
         
         $num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'");
         echo "<tr>
<td class='tbl1' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'><img src='images/dl_cats/".$data['download_cat_image']."' alt='".$data['download_cat_name']."' border='0'>
</a></td>
         <td class='tbl2' align='left' valign='center'><img src='".THEME."images/bullet.gif' alt='' border='0'>
         <a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat_id']."' style='font-weight: bold;'>".$data['download_cat_name']."</a> <span class='small2'>($num)</span><br>
         <span class='small'>".$data['download_cat_description']."</span></td>
</tr>";
         $counter++;
      }
      echo "<table class='tbl-border' style='margin-top: 10px;' cellpadding='0' cellspacing='1' width='100%'>
<tr>
   <td class='forum-caption' colspan='2' width='1%'>Statistika</td>

</tr>
<tr>
   <td class='tbl1' align='center' width='1%'><img src='images/dl_stats.png' alt='Siuntinių statistika' border='0'></td>
   <td class='tbl2'>
<table border='0' cellpadding='0' cellspacing='1'>";

$dataq = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,1"));
echo "<tr><td>Naujausias siuntinys: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$dataq['download_id']."' title=''>".$dataq['download_title']."</a></td>
</tr>";

$datax = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_count DESC LIMIT 0,1"));
echo "<tr><td>Populiariausias: </td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$datax['download_id']."' title=''>".$datax['download_title']."</a></td>
</tr>";

$cats = dbresult(dbquery("SELECT count(download_cat_id) FROM ".$db_prefix."download_cats"), 0);
echo "<tr><td>Kategorijų: </td>
<td class='small2'> $cats</td></tr>";

$countd = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"), 0);
echo "<tr>
   <td>Siuntinių: </td>
<td class='small2'> $countd</td>
</tr>";

$counth = dbresult(dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"), 0);
echo "<tr><td>Atsisiųsta: </td>
<td class='small2'> $counth</td></tr>";

echo "</table>
</td>
</tr>
</table>";
     
      $result = dbquery("SELECT * FROM ".$db_prefix."downloads ORDER BY download_id DESC LIMIT 0,20");
if (dbrows($result)) {

echo "<table class='tbl-border' style='margin-top: 10px;' border='0' cellpadding='0' cellspacing='1' width='100%'>
<tr>
      <td class='forum-caption' style='white-space: nowrap;'>Naujausi siuntiniai</td>
      <td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Data</td>

      <td class='forum-caption' style='white-space: nowrap;' align='center' width='1%'>Siuntimai</td>
</tr>";
while ($data = dbarray($result)) {
$time = $data['download_datestamp'];
$laikas = showdate( "%d.%m.%y", $time);
echo "<tr>
         <td class='tbl1'><img src='".THEME."images/bullet.gif' alt='' border='0'> <a class='small' href='downloads.php?d_id=".$data['download_id']."'>".$data['download_title']."</a></td>

         <td class='tbl1' align='center'>$laikas</td>

         <td class='tbl1' align='center'>".$data['download_count']."</td>

</tr>";
}
echo "</table>";
}
     

   } else {
      echo "<center><br>\n".$locale['430']."<br><br>\n</center>\n";
   }
   closetable();
} else {
   $res = 0;
   if (!isNum($cat_id)) fallback(FUSION_SELF);
   $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'");
   if (dbrows($result) != 0) {
      $cdata = dbarray($result);
      if (checkgroup($cdata['download_cat_access'])) {
         $res = 1;
         opentable($locale['400'].": ".$cdata['download_cat_name']);
         $rows = dbcount("(*)", "downloads", "download_cat='$cat_id'");
         if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
         if ($rows != 0) {
            $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_cat='$cat_id' ORDER BY ".$cdata['download_cat_sorting']." LIMIT $rowstart,15");
            //s
            $catdata = dbarray(dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_id='$cat_id'"));
            $count = dbresult(dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads WHERE download_cat='$cat_id'"), 0);
            echo "
            <table class='tbl-border' cellpadding='0' cellspacing='1' width='100%'>
<tr>
         <td class='tbl2' style='white-space: nowrap;' align='center' valign='middle' width='1%'><a class='small' href='downloads.php?cat_id=$cat_id' title='".$catdata['download_cat_name']."'><img src='images/dl_cats/".$catdata['download_cat_image']."' alt='".$catdata['download_cat_name']."' border='0'>
</a></td>
         <td class='tbl1' valign='top'><span><a class='small' href='downloads.php'>Siuntiniai</a> » ".$catdata['download_cat_name']."</span><br>
         ".$catdata['download_cat_description']."<br><br>Siuntimų kategorijoje: <span class='small2'>$count</span></td>
</tr>

</table>

<table cellpadding='0' cellspacing='0' width='100%'><tbody><tr>
<td height='8'>
</td>
</tr>
</tbody></table>";
            //e
           
           
            $numrows = dbrows($result); $i = 1;
            while ($data = dbarray($result)) {
            $id = $data['download_id'];
               if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
                  $new = " <span class='small'>".$locale['410']."</span>";
               } else {
                  $new = "";
               }
               $time = $data['download_datestamp'];
               $laikas = showdate( "%d.%m.%y", $time);
               echo "<table width='25%' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
               echo "<tr>
<td colspan='5' class='forum-caption'>
               <table style='border-collapse: collapse;' border='0' cellpadding='0' cellspacing='0' width='100%'>
<tr>
               <td width='1%'><a class='small' style='font-weight: bold;'><img src='".IMAGES."down.png' border='0'></a></td>

               <td>&nbsp;<a class='small' style='font-weight: bold;'><b>".$data['download_title']."</b></a></td>
               </tr></table></td>
</tr>\n";
               if ($data['download_description'] != "") echo "<tr>\n
               <td colspan='5' class='tbl1'>".nl2br(stripslashes($data['download_description']))."</td>\n</tr>\n";
               echo "<tr>\n
               
               
               
               <td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n
               <td class='tbl2' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=$cat_id&amp;download_id=".$data['download_id']."' title='Atsisiųsti Failą' style='font-weight: bold;'><img src='".IMAGES."download.png' alt='Atsisiųsti Failą' border='0'></a></td>";
               echo "</tr>\n";
               echo "<td width='30%' class='tbl2'><b>".$locale['415']."</b> ".$data['download_count']."</td>\n<td width='40%' class='tbl2'><b>Dydis:</b> ".($data['download_filesize'] ? "".$data['download_filesize']."" : "Nėra")."</td>\n</tr>\n";
               echo "</table>\n";
               
               if ($i != $numrows) { echo "<div align='center'><img src='".THEME."images/blank.gif' alt='' height='15' width='1'></div>\n"; $i++; }
            }
            closetable();
            if ($rows > 15) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,15,$rows,3,FUSION_SELF."?cat_id=$cat_id&amp;")."\n</div>\n";
         } else {
            echo $locale['431']."\n";
            closetable();
         }
      }
   }
   if ($res == 0) redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>





komentarus isemiau
2009 Vas. 8 19:02:57          9 žinutė iš 9
Spausdinti pranešimą
Dekui tau ;]
Peršokti į forumą: