Navigacija

Vartotojų tinkle

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

Registruoti nariai: 25,956
Naujausias narys: saulyzas

Naujausi straipsniai

Paskutiniai nariai

MaFetas 2 savaitės
ozzWANTED 3 savaitės
saulyzas 5 savaitės
TOMIJUS 6 savaitės
Reikalas15 savaitės
Jaunelis21 savaitės
lanis22 savaitės
And2s22 savaitės
Memento Mori27 savaitės
Quwqkibor30 savaitės
asirija34 savaitės
tomeem36 savaitės
weberiz39 savaitės
mRokass41 savaitės
kartoonas42 savaitės
grunskiz45 savaitės
Bruksnys46 savaitės
illusion46 savaitės
ordo47 savaitės
Jurgaila47 savaitės

Informacija:


OS: Unknown
Naršyklė: Nežinoma
IP: 3.144.89.197
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.

ozzWANTED
2024 Lap. 30 15:11:14
Taip, vis dar up šypsosi

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

Š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
Gal kas gali padaryt
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Bendri PHP-F klausimai

Autorius: Zidezzon Peržiūrų: 1693      Spausdinti temą
2008 Lie. 16 15:07:59          1 žinutė iš 6
Spausdinti pranešimą
Gal kas gali padaryti kad pvz foto galerijoj nebutu siu teksto:

Data: 16/07/2008 15:38
Įdėjo: Kaukucas
Dydis: 425 x 149 pikselių
Failo dydis: 141.96Kb
Komentarai: 0
Reitingas: Nėra
Peržiūrų skaičius: 0

Stai photogallery.php failas

<?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."photogallery.php";

define("SAFEMODE", @ini_get("safe_mode") ? true : false);
if (isset($photo_id) && !isNum($photo_id)) fallback(FUSION_SELF);
if (isset($album_id) && !isNum($album_id)) fallback(FUSION_SELF);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;

if(isset($photo_id)){
   $result = dbquery(
      "SELECT tp.*, ta.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
      FROM ".$db_prefix."photos tp
      LEFT JOIN ".$db_prefix."photo_albums ta USING (album_id)
      LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id
      LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'
      WHERE photo_id='$photo_id' GROUP BY tp.photo_id"
   );
   $data = dbarray($result);
   if (!checkgroup($data['album_access'])) {
      fallback(FUSION_SELF);
   } else {
      define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$data['album_id']."/" : ""));
      include INCLUDES."comments_include.php";
      include INCLUDES."ratings_include.php";
      $result=dbquery("UPDATE ".$db_prefix."photos SET photo_views=(photo_views+1) WHERE photo_id='".$photo_id."'");

      $pres = dbquery("SELECT photo_id FROM ".$db_prefix."photos WHERE photo_order='".($data['photo_order']-1)."' AND album_id='".$data['album_id']."'");
      $nres = dbquery("SELECT photo_id FROM ".$db_prefix."photos WHERE photo_order='".($data['photo_order']+1)."' AND album_id='".$data['album_id']."'");
      if (dbrows($pres)) $prev = dbarray($pres);
      if (dbrows($nres)) $next = dbarray($nres);

      opentable($locale['450']);
      if ($data['photo_thumb2']) { $photo_thumb = PHOTODIR.$data['photo_thumb2']; } else { $photo_thumb = ""; }
      $photo_file = PHOTODIR.$data['photo_filename'];
      $photo_size = @getimagesize($photo_file);

      echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n<td class='tbl2'>\n";
      echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> &gt;\n";
      echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a> &gt;\n";
      echo "<a href='".FUSION_SELF."?photo_id=$photo_id'>".$data['photo_title']."</a>\n</td>\n";      
      if ((isset($prev['photo_id']) && isNum($prev['photo_id'])) || (isset($next['photo_id']) && isNum($next['photo_id']))) {
         if (isset($prev)) echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$prev['photo_id']."' title='".$locale['451']."'>&lt;&lt;</a></td>\n";
         if (isset($next)) echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$next['photo_id']."' title='".$locale['452']."'>&gt;&gt;</a></td>\n";
      }
      echo "</tr>\n</table>\n";
      tablebreak();      
      echo "<div align='center' style='margin:5px;'>\n";
      echo "<a href=\"javascript:;\" onclick=\"window.open('showphoto.php?photo_id=".$data['photo_id']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=".($photo_size[0]+20).",height=".($photo_size[1]+20)."')\">";
      echo "<img src='".($photo_thumb ? $photo_thumb : $photo_file)."' alt='".$data['photo_filename']."' title='".$locale['453']."' border='0'></a>\n</div>\n";
      echo "<div align='center' style='margin:5px 0px 5px 0px'>\n";
      if ($data['photo_description']) echo nl2br(parseubb($data['photo_description']))."</b><br><br>\n";
      echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br>\n";
      echo $locale['434']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
      echo $locale['454']."$photo_size[0] x $photo_size[1] ".$locale['455']."<br>\n";
      echo $locale['456'].parsebytesize(filesize($photo_file))."<br>\n";
      echo $locale['436'].dbcount("(comment_id)", "comments", "comment_type='P' AND comment_item_id='".$data['photo_id']."'")."<br>\n";
      echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br>\n";
      echo $locale['457'].$data['photo_views']."\n";
      closetable();
      if ($data['photo_allow_comments'] == "1") showcomments("P","photos","photo_id",$photo_id,FUSION_SELF."?photo_id=$photo_id");
      if ($data['photo_allow_ratings']) showratings("P",$photo_id,FUSION_SELF."?photo_id=$photo_id");
   }
} elseif (isset($album_id)) {
   define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$album_id."/" : ""));
   $result = dbquery(
      "SELECT ta.*, tu.user_id,user_name FROM ".$db_prefix."photo_albums ta
      LEFT JOIN ".$db_prefix."users tu ON ta.album_user=tu.user_id
      WHERE album_id='$album_id'"
   );
   if (!dbrows($result)) {
      fallback(FUSION_SELF);
   } else {
      $data = dbarray($result);
      if (!checkgroup($data['album_access'])) {
         fallback(FUSION_SELF);
      } else {
         $rows = dbcount("(photo_id)", "photos", "album_id='$album_id'");
         opentable($locale['420']);
         tablebreak();
         echo "<table align='center' cellpadding='0' cellspacing='0' width='80%'>\n<tr>\n";
         echo "<td rowspan='2' align='center' class='tbl1'><img src='".PHOTOS.$data['album_thumb']."'></td>\n";
         echo "<td valign='top' width='100%'><div class='tbl2' style='font-weight:bold;vertical-align:top'>".$locale['421'].$data['album_title']."</div>\n";
         echo "<div class='tbl1' style='vertical-align:middle'>".nl2br(parseubb($data['album_description']))."</div>\n</td>\n</tr>\n";
         echo "<tr>\n<td valign='bottom' width='100%'>\n<div class='tbl2' style='vertical-align:bottom'>\n";
         if ($rows) {
            $pdata = dbarray(dbquery("SELECT tp.*, tu.user_id,user_name FROM ".$db_prefix."photos tp LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id WHERE album_id='$album_id' ORDER BY photo_datestamp DESC LIMIT 1"));
            echo $locale['422']."$rows<br>\n";
            echo $locale['423']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$pdata['user_name']."</a>".$locale['424'].showdate("longdate", $pdata['photo_datestamp'])."\n";
         } else {
            echo $locale['425']."\n";
         }
         echo "</div>\n</td>\n</tr>\n</table>";
         tablebreak();
         closetable();
         if ($rows) {
            tablebreak();
            opentable($locale['430']);
            $result = dbquery(
               "SELECT tp.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
               FROM ".$db_prefix."photos tp
               LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id
               LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'
               WHERE album_id=$album_id GROUP BY photo_id ORDER BY photo_order LIMIT $rowstart,".$settings['thumbs_per_page']
            );
            $counter = 0;
            echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n<td class='tbl2'>\n";
            echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> &gt;\n";
            echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a>\n";
            echo "</td>\n</tr>\n</table>\n";
            tablebreak();
            echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
            while ($data = dbarray($result)) {
               if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "</tr>\n<tr>\n";
               echo "<td align='center' valign='top' class='tbl'>\n";
               echo "<b>".$data['photo_title']."</b><br><br>\n<a href='".FUSION_SELF."?photo_id=".$data['photo_id']."'>";
               if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){
                  echo "<img src='".PHOTODIR.$data['photo_thumb1']."' alt='".$data['photo_thumb1']."' title='".$locale['431']."' border='0'>";
               } else {
                  echo $locale['432'];
               }
               echo "</a><br><br>\n<span class='small'>\n";
               echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br>\n";
               echo $locale['434']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
               echo $locale['436'].dbcount("(comment_id)", "comments", "comment_type='P' AND comment_item_id='".$data['photo_id']."'")."<br>\n";
               echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br>\n";
               echo $locale['435'].$data['photo_views']."</span><br>\n";
               echo "</td>\n";
               $counter++;
            }
            echo "</tr>\n</table>\n";
            closetable();
         }
         if ($rows > $settings['thumbs_per_page']) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3,FUSION_SELF."?album_id=$album_id&amp;")."\n</div>\n";
      }
   }
} else {
   opentable($locale['400']);
   $rows = dbcount("(album_id)", "photo_albums", groupaccess('album_access'));
   if ($rows) {
      $result = dbquery(
         "SELECT ta.*, tu.user_id,user_name FROM ".$db_prefix."photo_albums ta
         LEFT JOIN ".$db_prefix."users tu ON ta.album_user=tu.user_id
         WHERE ".groupaccess('album_access')." ORDER BY album_order
         LIMIT $rowstart,".$settings['thumbs_per_page']
      );
      $counter = 0; $r = 0; $k = 1;
      echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
      while ($data = dbarray($result)) {
         if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "</tr>\n<tr>\n";
         echo "<td align='center' valign='top' class='tbl'>\n";
         echo "<b>".$data['album_title']."</b><br><br>\n<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>";
         if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
            echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' title='".$locale['401']."' border='0'>";
         } else {
            echo $locale['402'];
         }
         echo "</a><br><br>\n<span class='small'>\n";
         echo $locale['403'].showdate("shortdate", $data['album_datestamp'])."<br>\n";
         echo $locale['404']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
         echo $locale['405'].dbcount("(photo_id)", "photos", "album_id='".$data['album_id']."'")."</span><br>\n";
         echo "</td>\n";
         $counter++; $k++;
      }
      echo "</tr>\n</table>\n";
      closetable();
      if ($rows > $settings['thumbs_per_page']) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3)."\n</div>\n";
   }else{
      echo "<center><br>".$locale['406']."<br><br></center>\n";
      closetable();
   }
}

require "side_right.php";
require "footer.php";
?>




2008 Lie. 16 16:07:14          2 žinutė iš 6
Spausdinti pranešimą
echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br>\n";
echo $locale['434']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
echo $locale['454']."$photo_size[0] x $photo_size[1] ".$locale['455']."<br>\n";
echo $locale['456'].parsebytesize(filesize($photo_file))."<br>\n";
echo $locale['436'].dbcount("(comment_id)", "comments", "comment_type='P' AND comment_item_id='".$data['photo_id']."'")."<br>\n";
echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br>\n";
echo $locale['457'].$data['photo_views']."\n";


istrink sita

ex best admin!
2008 Lie. 16 16:07:13          3 žinutė iš 6
Spausdinti pranešimą
Še...
<?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."photogallery.php";

define("SAFEMODE", @ini_get("safe_mode") ? true : false);
if (isset($photo_id) && !isNum($photo_id)) fallback(FUSION_SELF);
if (isset($album_id) && !isNum($album_id)) fallback(FUSION_SELF);
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;

if(isset($photo_id)){
   $result = dbquery(
      "SELECT tp.*, ta.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
      FROM ".$db_prefix."photos tp
      LEFT JOIN ".$db_prefix."photo_albums ta USING (album_id)
      LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id
      LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'
      WHERE photo_id='$photo_id' GROUP BY tp.photo_id"
   );
   $data = dbarray($result);
   if (!checkgroup($data['album_access'])) {
      fallback(FUSION_SELF);
   } else {
      define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$data['album_id']."/" : ""));
      include INCLUDES."comments_include.php";
      include INCLUDES."ratings_include.php";
      $result=dbquery("UPDATE ".$db_prefix."photos SET photo_views=(photo_views+1) WHERE photo_id='".$photo_id."'");

      $pres = dbquery("SELECT photo_id FROM ".$db_prefix."photos WHERE photo_order='".($data['photo_order']-1)."' AND album_id='".$data['album_id']."'");
      $nres = dbquery("SELECT photo_id FROM ".$db_prefix."photos WHERE photo_order='".($data['photo_order']+1)."' AND album_id='".$data['album_id']."'");
      if (dbrows($pres)) $prev = dbarray($pres);
      if (dbrows($nres)) $next = dbarray($nres);

      opentable($locale['450']);
      if ($data['photo_thumb2']) { $photo_thumb = PHOTODIR.$data['photo_thumb2']; } else { $photo_thumb = ""; }
      $photo_file = PHOTODIR.$data['photo_filename'];
      $photo_size = @getimagesize($photo_file);

      echo "<table cellpadding='0' cellspacing='0' width='100%'>\n<tr>\n<td class='tbl2'>\n";
      echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> &gt;\n";
      echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a> &gt;\n";
      echo "<a href='".FUSION_SELF."?photo_id=$photo_id'>".$data['photo_title']."</a>\n</td>\n";     
      if ((isset($prev['photo_id']) && isNum($prev['photo_id'])) || (isset($next['photo_id']) && isNum($next['photo_id']))) {
         if (isset($prev)) echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$prev['photo_id']."' title='".$locale['451']."'>&lt;&lt;</a></td>\n";
         if (isset($next)) echo "<td width='1%' class='tbl2'><a href='".FUSION_SELF."?photo_id=".$next['photo_id']."' title='".$locale['452']."'>&gt;&gt;</a></td>\n";
      }
      echo "</tr>\n</table>\n";
      tablebreak();     
      echo "<div align='center' style='margin:5px;'>\n";
      echo "<a href=\"javascript:;\" onclick=\"window.open('showphoto.php?photo_id=".$data['photo_id']."','','scrollbars=yes,toolbar=no,status=no,resizable=yes,width=".($photo_size[0]+20).",height=".($photo_size[1]+20)."')\">";
      echo "<img src='".($photo_thumb ? $photo_thumb : $photo_file)."' alt='".$data['photo_filename']."' title='".$locale['453']."' border='0'></a>\n</div>\n";
      echo "<div align='center' style='margin:5px 0px 5px 0px'>\n";
      if ($data['photo_description']) echo nl2br(parseubb($data['photo_description']))."</b><br><br>\n";
     
      closetable();
      if ($data['photo_allow_comments'] == "1") showcomments("P","photos","photo_id",$photo_id,FUSION_SELF."?photo_id=$photo_id");
      if ($data['photo_allow_ratings']) showratings("P",$photo_id,FUSION_SELF."?photo_id=$photo_id");
   }
} elseif (isset($album_id)) {
   define("PHOTODIR", PHOTOS.(!SAFEMODE ? "album_".$album_id."/" : ""));
   $result = dbquery(
      "SELECT ta.*, tu.user_id,user_name FROM ".$db_prefix."photo_albums ta
      LEFT JOIN ".$db_prefix."users tu ON ta.album_user=tu.user_id
      WHERE album_id='$album_id'"
   );
   if (!dbrows($result)) {
      fallback(FUSION_SELF);
   } else {
      $data = dbarray($result);
      if (!checkgroup($data['album_access'])) {
         fallback(FUSION_SELF);
      } else {
         $rows = dbcount("(photo_id)", "photos", "album_id='$album_id'");
         opentable($locale['420']);
         tablebreak();
         echo "<table align='center' cellpadding='0' cellspacing='0' width='80%'>\n<tr>\n";
         echo "<td rowspan='2' align='center' class='tbl1'><img src='".PHOTOS.$data['album_thumb']."'></td>\n";
         echo "<td valign='top' width='100%'><div class='tbl2' style='font-weight:bold;vertical-align:top'>".$locale['421'].$data['album_title']."</div>\n";
         echo "<div class='tbl1' style='vertical-align:middle'>".nl2br(parseubb($data['album_description']))."</div>\n</td>\n</tr>\n";
         echo "<tr>\n<td valign='bottom' width='100%'>\n<div class='tbl2' style='vertical-align:bottom'>\n";
         if ($rows) {
            $pdata = dbarray(dbquery("SELECT tp.*, tu.user_id,user_name FROM ".$db_prefix."photos tp LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id WHERE album_id='$album_id' ORDER BY photo_datestamp DESC LIMIT 1"));
            echo $locale['422']."$rows<br>\n";
            echo $locale['423']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$pdata['user_name']."</a>".$locale['424'].showdate("longdate", $pdata['photo_datestamp'])."\n";
         } else {
            echo $locale['425']."\n";
         }
         echo "</div>\n</td>\n</tr>\n</table>";
         tablebreak();
         closetable();
         if ($rows) {
            tablebreak();
            opentable($locale['430']);
            $result = dbquery(
               "SELECT tp.*, tu.user_id,user_name, SUM(tr.rating_vote) AS sum_rating, COUNT(tr.rating_item_id) AS count_votes
               FROM ".$db_prefix."photos tp
               LEFT JOIN ".$db_prefix."users tu ON tp.photo_user=tu.user_id
               LEFT JOIN ".$db_prefix."ratings tr ON tr.rating_item_id = tp.photo_id AND tr.rating_type='P'
               WHERE album_id=$album_id GROUP BY photo_id ORDER BY photo_order LIMIT $rowstart,".$settings['thumbs_per_page']
            );
            $counter = 0;
            echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n<td class='tbl2'>\n";
            echo "<a href='".FUSION_SELF."'>".$locale['400']."</a> &gt;\n";
            echo "<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>".$data['album_title']."</a>\n";
            echo "</td>\n</tr>\n</table>\n";
            tablebreak();
            echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
            while ($data = dbarray($result)) {
               if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "</tr>\n<tr>\n";
               echo "<td align='center' valign='top' class='tbl'>\n";
               echo "<b>".$data['photo_title']."</b><br><br>\n<a href='".FUSION_SELF."?photo_id=".$data['photo_id']."'>";
               if ($data['photo_thumb1'] && file_exists(PHOTODIR.$data['photo_thumb1'])){
                  echo "<img src='".PHOTODIR.$data['photo_thumb1']."' alt='".$data['photo_thumb1']."' title='".$locale['431']."' border='0'>";
               } else {
                  echo $locale['432'];
               }
               echo "</a><br><br>\n<span class='small'>\n";
               echo $locale['433'].showdate("shortdate", $data['photo_datestamp'])."<br>\n";
               echo $locale['434']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
               echo $locale['436'].dbcount("(comment_id)", "comments", "comment_type='P' AND comment_item_id='".$data['photo_id']."'")."<br>\n";
               echo $locale['437'].($data['count_votes'] > 0 ? str_repeat("<img src='".IMAGES."star.gif' alt='*' style='vertical-align:middle'>", ceil($data['sum_rating'] / $data['count_votes'])) : $locale['438'])."<br>\n";
               echo $locale['435'].$data['photo_views']."</span><br>\n";
               echo "</td>\n";
               $counter++;
            }
            echo "</tr>\n</table>\n";
            closetable();
         }
         if ($rows > $settings['thumbs_per_page']) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3,FUSION_SELF."?album_id=$album_id&amp;")."\n</div>\n";
      }
   }
} else {
   opentable($locale['400']);
   $rows = dbcount("(album_id)", "photo_albums", groupaccess('album_access'));
   if ($rows) {
      $result = dbquery(
         "SELECT ta.*, tu.user_id,user_name FROM ".$db_prefix."photo_albums ta
         LEFT JOIN ".$db_prefix."users tu ON ta.album_user=tu.user_id
         WHERE ".groupaccess('album_access')." ORDER BY album_order
         LIMIT $rowstart,".$settings['thumbs_per_page']
      );
      $counter = 0; $r = 0; $k = 1;
      echo "<table cellpadding='0' cellspacing='1' width='100%'>\n<tr>\n";
      while ($data = dbarray($result)) {
         if ($counter != 0 && ($counter % $settings['thumbs_per_row'] == 0)) echo "</tr>\n<tr>\n";
         echo "<td align='center' valign='top' class='tbl'>\n";
         echo "<b>".$data['album_title']."</b><br><br>\n<a href='".FUSION_SELF."?album_id=".$data['album_id']."'>";
         if ($data['album_thumb'] && file_exists(PHOTOS.$data['album_thumb'])){
            echo "<img src='".PHOTOS.$data['album_thumb']."' alt='".$data['album_thumb']."' title='".$locale['401']."' border='0'>";
         } else {
            echo $locale['402'];
         }
         echo "</a><br><br>\n<span class='small'>\n";
         echo $locale['403'].showdate("shortdate", $data['album_datestamp'])."<br>\n";
         echo $locale['404']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br>\n";
         echo $locale['405'].dbcount("(photo_id)", "photos", "album_id='".$data['album_id']."'")."</span><br>\n";
         echo "</td>\n";
         $counter++; $k++;
      }
      echo "</tr>\n</table>\n";
      closetable();
      if ($rows > $settings['thumbs_per_page']) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$settings['thumbs_per_page'],$rows,3)."\n</div>\n";
   }else{
      echo "<center><br>".$locale['406']."<br><br></center>\n";
      closetable();
   }
}

require "side_right.php";
require "footer.php";
?>



2008 Lie. 16 17:07:18          4 žinutė iš 6
Spausdinti pranešimą
Galit padaryt kad butu taip: http://kalvarija.xz.lt/images/1....
Ir taip: http://kalvarija.xz.lt/images/2....
2008 Lie. 16 17:07:56          5 žinutė iš 6
Spausdinti pranešimą
plzz man greitai reik drovus
2008 Lie. 16 17:07:34          6 žinutė iš 6
Spausdinti pranešimą
Eik skaitykis kurnors...Ir galėjei redaguoti postą neflodines.Jeigu niekas neatrašo tai padėti vadinasi negali...piktas

Peršokti į forumą: