PHP-Fusion Mods
Navigacija
Apsauga
Apsauga Neleista registracija: 38936
Šiandien: 15
Prisijungę nariai
» Svečių: 9
» Narių: 0

» Viso narių: 10,235
» Naujausias: ruslanas tuk

Prisijungimų istorija:
tabux09:10:58
sanpernepamenu
Zbigniew@nepamenu
CepelinasXnepamenu
VV91DDnepamenu
Minusnepamenu
priezilviciunepamenu
EdvinasG1337nepamenu
rolandas94nepamenu
Edis2nepamenu
klubogerbejasnepamenu
Miskinisnepamenu
Pask. modai
Prisijungti
Vardas

Slaptažodis



Dar ne narys?
Registruotis.

Pamiršai slaptažodį?
Prašyk naujo!.

Naujausi prašymai
[L] testas
Narių apklausa
Ar dar kuriate tinklalapius?

Ne
Ne
0% [0 Balsai]

Taip
Taip
88% [7 Balsai]

Naudojuosi socialiniais tinklais
Naudojuosi socialiniais tinklais
13% [1 Balsas]

Balsai: 8
Kad galėtum balsuoti, turi prisijungti.
Pradėta: 2022-05-29 19:54
Shoutbox
You must login to post a message.

2026-03-21 19:07

2025-07-13 17:07
svx, smagu kad dar atsiranda naujų narių Šypsosi2

2024-03-07 22:13
Oj Tabux… apkabinčiau už tą moderatorių 😁

2024-02-22 17:40
Šypsosi2 jo buvo laikai.. Senukai jau mes. Bega laikas greiciau nei noretusi. Smagu matyti kad uzsuka seni nariai, ne as vienas Šypsosi

2024-02-20 22:18
Zodziu.. Nostalgija. Sorry Tabux uz spam’a, netelpa viskas i viena shout’a. 😁

Shoutbox Archive
Peržiūrėti temą
PHP-Fusion Mods :: PHP-Fusion modifikacijų forumas :: Patobulinimai
 Spausdinti temą
v6 news.php patobulinimas
Delite
#1 Spausdinti pranešimą
parašyta 2009-11-18 18:03
Pradinukas



Reputacija: 0

Pranešimai: 29
Įstojo: 2009-06-10

Taigi sveiki man eilini karta reikia js pagalbos kaip padaryti kaip ant sraipsniu yra kad reiktu spausti ant naujienos pavadinimo, kad nukeltu prie skaityti daugiau nes dabar reikia spausti plaiau



ia news.php

Download source  Code

require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";

if (isset($naujiena) && !isNum($naujiena)) fallback(FUSION_SELF);

if ($settings['news_style'] == \"1\") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = \"\"; $news_[1] = \"\"; $news_[2] = \"\"; } else { $i = 1; }

$items_per_page = 11;

if (!isset($naujiena)) {
   $rows = dbcount(\"(news_id)\", \"news\", groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")\");
   if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
   if ($rows != 0) {
      $result = dbquery(
         \"SELECT tn.*, tc.*, user_id, user_name FROM \".$db_prefix.\"news tn
         LEFT JOIN \".$db_prefix.\"users tu ON tn.news_name=tu.user_id
         LEFT JOIN \".$db_prefix.\"news_cats tc ON tn.news_cat=tc.news_cat_id
         WHERE \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\")
         ORDER BY news_sticky DESC, news_datestamp DESC LIMIT $rowstart,$items_per_page\"
      );      
      $numrows = dbrows($result);
      if ($settings['news_style'] == \"1\") $nrows = round((dbrows($result) - 1) / 2);
      while ($data = dbarray($result)) {
         $news_cat_image = \"\";
         $news_subject = \"\".stripslashes($data['news_subject']);
         if ($data['news_cat_image']) {
            $news_cat_image = \"'\".$data['news_cat_name'].\"'\";
         } else {
            $news_cat_image = \"\";
         }
         $news_news = $data['news_breaks'] == \"y\" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
         if ($news_cat_image != \"\") $news_news = $news_cat_image.$news_news;
         $news_info = array(
            \"news_id\" => $data['news_id'],
            \"user_id\" => $data['user_id'],
            \"user_name\" => $data['user_name'],
            \"news_date\" => $data['news_datestamp'],
            \"news_ext\" => $data['news_extended'] ? \"y\" : \"n\",
            \"news_reads\" => $data['news_reads'],
            \"news_comments\" => dbcount(\"(comment_id)\", \"comments\", \"comment_type='N' AND comment_item_id='\".$data['news_id'].\"'\"),
            \"news_allow_comments\" => $data['news_allow_comments']
         );
         if ($settings['news_style'] == \"1\") {
            if ($rows <= 2 || $ncount == 1) {
               $news_[0] .= \"\n\";
               $news_[0] .= \"\n\n\n\";
               $news_[0] .= \"\n\n\n\";
               $news_[0] .= \"\n\n\n
$news_subject
$news_news
\n\";
               if (checkrights(\"N\")) $news_[0] .= \"
\n\";
               $news_[0] .= \"'' \".$news_info['user_name'].\" \".$locale['041'].showdate(\"longdate\", $news_info['news_date']).\" \n\";
               if ($news_info['news_ext'] == \"y\" || $news_info['news_allow_comments']) {
                  $news_[0] .= $news_info['news_ext'] == \"y\" ? \"\".$locale['042'].\" \n\" : \"\";
                  $news_[0] .= $news_info['news_allow_comments'] ? \"\".$news_info['news_comments'].$locale['043'].\" \n\" : \"\";
                  $news_[0] .= $news_info['news_reads'].$locale['044'].\" \n\";
               }
               $news_[0] .= \"'\".$locale['045'].\"'\";
               if (checkrights(\"N\")) { $news_[0] .= \" '\".$locale['048'].\"'
\n
\n\"; } else { $news_[0] .= \"\n\"; }
               $news_[0] .= \"
\n\";
               if ($ncount != $rows) $news_[0] .= \"
''
\n\";
            } else {
               if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; }
               $row_color = ($rc % 2 == 0 ? \"tbl2\" : \"tbl1\");
               $news_[$ncolumn] .= \"\n\";
               $news_[$ncolumn] .= \"\n\n\n\";
               $news_[$ncolumn] .= \"\n\n\n\";
               $news_[$ncolumn] .= \"\n\n\n
$news_subject
$news_news
\n\";
               if (checkrights(\"N\")) $news_[$ncolumn] .= \"
\n\";
               $news_[$ncolumn] .= \"'' \".$news_info['user_name'].\" \".$locale['041'].showdate(\"longdate\", $news_info['news_date']);
               if ($news_info['news_ext'] == \"y\" || $news_info['news_allow_comments']) {
                  $news_[$ncolumn] .= \"
\n\";
                  $news_[$ncolumn] .= $news_info['news_ext'] == \"y\" ? \"\".$locale['042'].\" \n\" : \"\";
                  $news_[$ncolumn] .= $news_info['news_allow_comments'] ? \"\".$news_info['news_comments'].$locale['043'].\" \n\" : \"\";
                  $news_[$ncolumn] .= $news_info['news_reads'].$locale['044'].\" \n\";
               } else {
                  $news_[$ncolumn] .= \" \n\";
               }
               $news_[$ncolumn] .= \"'\".$locale['045'].\"'\n\";
               if (checkrights(\"N\")) { $news_[$ncolumn] .= \" '\".$locale['048'].\"'
\n
\n\"; } else { $news_[$ncolumn] .= \"\n\"; }
               $news_[$ncolumn] .= \"
\n\";
               if ($ncolumn == 1 && $i < ($nrows - 1)) $news_[$ncolumn] .= \"
''
\n\";
               if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) $news_[$ncolumn] .= \"
''
\n\";
               $i++; $rc++;
            }
            $ncount++;
         } else {
            render_news($news_subject, $news_news, $news_info);
            if ($i != $numrows) { tablebreak(); } $i++;
         }
      }

if (isset($archyvas)) {

$query3 = dbquery(\"SELECT * FROM \".$db_prefix.\"news ORDER BY news_datestamp DESC\");
if (mysql_num_rows($query3) == 0) {
echo \"
Naujien nra
\";
} else {
while ($data = dbarray($query3)) {
echo \"\".trimlink($data[news_subject], 100).\"
\";
}
}

} elseif ($settings['news_style'] == \"1\") {
    opentable(\"Naujienos\");
$result=dbquery(\"SELECT * FROM \".DB_PREFIX.\"news ORDER BY news_datestamp DESC LIMIT 0,4\");

if(dbrows($result)!=0){
while($data=dbarray($result)){
$result2 = dbquery(\"SELECT news_cat_name FROM \".DB_PREFIX.\"news_cats WHERE news_cat_id='$data[news_cat]'\");
$n_id = $data['news_id'];
$comments_n = dbcount(\"(comment_id)\", \"comments\", \"comment_type='N' AND comment_item_id=\".$data['news_id'].\"\");
$date = $data['news_datestamp'];
$n_date = showdate(\"%Y %m %d\", $date);
$v_id = $data['news_reads'];

$category = dbresult($result2,0);

$news_news = $data['news_breaks'] == \"y\" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
$query = dbquery(\"SELECT news_cat_image FROM \".$db_prefix.\"news_cats WHERE news_cat_id = '\".$data['news_cat'].\"'\");
$cat = dbarray($query);
echo \"\n

\";
echo \"   

\".trimlink($data[news_subject], 100).\" ($n_date) - Plačiau

\".$news_news.\"

\";
   }   
$result3 = dbquery(\"SELECT * FROM \".DB_PREFIX.\"news WHERE \".groupaccess('news_visibility').\" AND (news_start='0'||news_start<=\".time().\") AND (news_end='0'||news_end>=\".time().\") ORDER BY news_datestamp DESC LIMIT 0\");
echo \"\n\";
while ($data = dbarray($result3)) {
$title = $data['news_subject'];
$sh_title = $title;
$comments_n = dbcount(\"(comment_id)\", \"comments\", \"comment_type='N' AND comment_item_id=\".$data['news_id'].\"\");
$v_id = $data['news_reads'];
$date = $data['news_datestamp'];
$n_date = showdate(\"%Y %m %d\", $date);
echo \"
\n\";
}
echo \"\n\";
echo \"

$n_date 
\".trimlink($data[news_subject], 100).\" [$v_id | $comments_n]

- Naujienu archyvas
\n\";
}


closetable();


      }
      if ($rows > $items_per_page) echo \"
\n\".makePageNav($rowstart,$items_per_page,$rows,3).\"\n
\n\";
   } else {

echo \"\";

   }
} else {
   include INCLUDES.\"comments_include.php\";
   include INCLUDES.\"ratings_include.php\";
   $result = dbquery(
      \"SELECT tn.*, user_id, user_name FROM \".$db_prefix.\"news tn
      LEFT JOIN \".$db_prefix.\"users tu ON tn.news_name=tu.user_id
      WHERE news_id='$naujiena'\"
   );
   if (dbrows($result)!=0) {
      $data = dbarray($result);
      if (checkgroup($data['news_visibility'])) {
         $news_cat_image = \"\";
         if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
             $result2 = dbquery(\"UPDATE \".$db_prefix.\"news SET news_reads=news_reads+1 WHERE news_id='$naujiena'\");
             $data['news_reads']++;
         }
         $news_subject = $data['news_subject'];
         if ($data['news_cat'] != 0) {
            $result2 = dbquery(\"SELECT * FROM \".$db_prefix.\"news_cats WHERE news_cat_id='\".$data['news_cat'].\"'\");
            if (dbrows($result2)) {
               $data2 = dbarray($result2);
               $news_cat_image = \"'\".$data2['news_cat_name'].\"'\";
            }
         }
         $news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
         if ($data['news_breaks'] == \"y\") { $news_news = nl2br($news_news); }
         if ($news_cat_image != \"\") $news_news = $news_cat_image.$news_news;
         $news_info = array(
            \"news_id\" => $data['news_id'],
            \"user_id\" => $data['user_id'],
            \"user_name\" => $data['user_name'],
            \"news_date\" => $data['news_datestamp'],
            \"news_ext\" => \"n\",
            \"news_reads\" => $data['news_reads'],
            \"news_comments\" => dbcount(\"(comment_id)\", \"comments\", \"comment_type='N' AND comment_item_id='\".$data['news_id'].\"'\"),
            \"news_allow_comments\" => $data['news_allow_comments']
         );
         render_news($news_subject, $news_news, $news_info);
         if ($data['news_allow_comments']) showcomments(\"N\",\"news\",\"news_id\",$naujiena,FUSION_SELF.\"?naujiena=$naujiena\");
         if ($data['news_allow_ratings']) showratings(\"N\",$naujiena,FUSION_SELF.\"?naujiena=$naujiena\");
      } else {
         redirect(FUSION_SELF);
      }
   } else {
      redirect(FUSION_SELF);
   }
}

require_once \"side_right.php\";
require_once \"footer.php\";
?>




Gal galtu kas padti
Redagavo Delite 2009-11-20 09:08
 
PM
Logix
#2 Spausdinti pranešimą
parašyta 2009-11-23 19:13
Savekas



Reputacija: 0

Pranešimai: 111
Įstojo: 2009-07-20


require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

if (isset($naujiena) && !isNum($naujiena)) fallback(FUSION_SELF);

if ($settings['news_style'] == "1") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = ""; $news_[1] = ""; $news_[2] = ""; } else { $i = 1; }

$items_per_page = 11;

if (!isset($naujiena)) {
$rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT $rowstart,$items_per_page"
);
$numrows = dbrows($result);
if ($settings['news_style'] == "1") $nrows = round((dbrows($result) - 1) / 2);
while ($data = dbarray($result)) {
$news_cat_image = "";
$news_subject = "".stripslashes($data['news_subject']);
if ($data['news_cat_image']) {
$news_cat_image = "'".$data['news_cat_name']."'";
} else {
$news_cat_image = "";
}
$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
if ($settings['news_style'] == "1") {
if ($rows <= 2 || $ncount == 1) {
$news_[0] .= "\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[0] .= "
\n";
$news_[0] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date'])." \n";
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[0] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[0] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[0] .= $news_info['news_reads'].$locale['044']." \n";
}
$news_[0] .= "'".$locale['045']."'";
if (checkrights("N")) { $news_[0] .= " '".$locale['048']."'
\n
\n"; } else { $news_[0] .= "\n"; }
$news_[0] .= "
\n";
if ($ncount != $rows) $news_[0] .= "
''
\n";
} else {
if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; }
$row_color = ($rc % 2 == 0 ? "tbl2" : "tbl1");
$news_[$ncolumn] .= "\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date']);
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[$ncolumn] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[$ncolumn] .= $news_info['news_reads'].$locale['044']." \n";
} else {
$news_[$ncolumn] .= " \n";
}
$news_[$ncolumn] .= "'".$locale['045']."'\n";
if (checkrights("N")) { $news_[$ncolumn] .= " '".$locale['048']."'
\n
\n"; } else { $news_[$ncolumn] .= "\n"; }
$news_[$ncolumn] .= "
\n";
if ($ncolumn == 1 && $i < ($nrows - 1)) $news_[$ncolumn] .= "
''
\n";
if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) $news_[$ncolumn] .= "
''
\n";
$i++; $rc++;
}
$ncount++;
} else {
render_news($news_subject, $news_news, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
}

if (isset($archyvas)) {

$query3 = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC");
if (mysql_num_rows($query3) == 0) {
echo "
Naujien nra
";
} else {
while ($data = dbarray($query3)) {
echo "".trimlink($data[news_subject], 100)."
";
}
}

} elseif ($settings['news_style'] == "1") {
opentable("Naujienos");
$result=dbquery("SELECT * FROM ".DB_PREFIX."news ORDER BY news_datestamp DESC LIMIT 0,4");

if(dbrows($result)!=0){
while($data=dbarray($result)){
$result2 = dbquery("SELECT news_cat_name FROM ".DB_PREFIX."news_cats WHERE news_cat_id='$data[news_cat]'");
$n_id = $data['news_id'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
$v_id = $data['news_reads'];

$category = dbresult($result2,0);

$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
$query = dbquery("SELECT news_cat_image FROM ".$db_prefix."news_cats WHERE news_cat_id = '".$data['news_cat']."'");
$cat = dbarray($query);
echo "\n

";
echo "

".trimlink($data[news_subject], 100)." ($n_date) - Plačiau

".$news_news."

";
}
$result3 = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0");
echo "\n";
while ($data = dbarray($result3)) {
$title = $data['news_subject'];
$sh_title = $title;
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$v_id = $data['news_reads'];
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
echo "
\n";
}
echo "\n";
echo "

$n_date
".trimlink($data[news_subject], 100)." [$v_id | $comments_n]

- Naujienu archyvas
\n";
}


closetable();


}
if ($rows > $items_per_page) echo "
\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n
\n";
} else {

echo "";

}
} else {
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$naujiena'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
$news_cat_image = "";
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$naujiena'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
if ($data['news_cat'] != 0) {
$result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");
if (dbrows($result2)) {
$data2 = dbarray($result2);
$news_cat_image = "'".$data2['news_cat_name']."'";
}
}
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news, $news_info);
if ($data['news_allow_comments']) showcomments("N","news","news_id",$naujiena,FUSION_SELF."?naujiena=$naujiena");
if ($data['news_allow_ratings']) showratings("N",$naujiena,FUSION_SELF."?naujiena=$naujiena");
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}

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

sicia tu nieko nepadarysi turi susirasti kad butu parasyta sakityti placiau ar kjp ten ir pakeisti kjp nori jtp supratau? cia turi locale ieskot cia geriau admin pagalbos prasyk


jei supratau akd butu sakityti daugiau pamegink sitaip
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

if (isset($naujiena) && !isNum($naujiena)) fallback(FUSION_SELF);

if ($settings['news_style'] == "1") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = ""; $news_[1] = ""; $news_[2] = ""; } else { $i = 1; }

$items_per_page = 11;

if (!isset($naujiena)) {
$rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT $rowstart,$items_per_page"
);
$numrows = dbrows($result);
if ($settings['news_style'] == "1") $nrows = round((dbrows($result) - 1) / 2);
while ($data = dbarray($result)) {
$news_cat_image = "";
$news_subject = "".stripslashes($data['news_subject']);
if ($data['news_cat_image']) {
$news_cat_image = "'".$data['news_cat_name']."'";
} else {
$news_cat_image = "";
}
$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
if ($settings['news_style'] == "1") {
if ($rows <= 2 || $ncount == 1) {
$news_[0] .= "\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[0] .= "
\n";
$news_[0] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date'])." \n";
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[0] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[0] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[0] .= $news_info['news_reads'].$locale['044']." \n";
}
$news_[0] .= "'".$locale['045']."'";
if (checkrights("N")) { $news_[0] .= " '".$locale['048']."'
\n
\n"; } else { $news_[0] .= "\n"; }
$news_[0] .= "
\n";
if ($ncount != $rows) $news_[0] .= "
''
\n";
} else {
if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; }
$row_color = ($rc % 2 == 0 ? "tbl2" : "tbl1");
$news_[$ncolumn] .= "\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date']);
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[$ncolumn] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[$ncolumn] .= $news_info['news_reads'].$locale['044']." \n";
} else {
$news_[$ncolumn] .= " \n";
}
$news_[$ncolumn] .= "'".$locale['045']."'\n";
if (checkrights("N")) { $news_[$ncolumn] .= " '".$locale['048']."'
\n
\n"; } else { $news_[$ncolumn] .= "\n"; }
$news_[$ncolumn] .= "
\n";
if ($ncolumn == 1 && $i < ($nrows - 1)) $news_[$ncolumn] .= "
''
\n";
if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) $news_[$ncolumn] .= "
''
\n";
$i++; $rc++;
}
$ncount++;
} else {
render_news($news_subject, $news_news, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
}

if (isset($archyvas)) {

$query3 = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC");
if (mysql_num_rows($query3) == 0) {
echo "
Naujien nra
";
} else {
while ($data = dbarray($query3)) {
echo "".trimlink($data[news_subject], 100)."
";
}
}

} elseif ($settings['news_style'] == "1") {
opentable("Naujienos");
$result=dbquery("SELECT * FROM ".DB_PREFIX."news ORDER BY news_datestamp DESC LIMIT 0,4");

if(dbrows($result)!=0){
while($data=dbarray($result)){
$result2 = dbquery("SELECT news_cat_name FROM ".DB_PREFIX."news_cats WHERE news_cat_id='$data[news_cat]'");
$n_id = $data['news_id'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
$v_id = $data['news_reads'];

$category = dbresult($result2,0);

$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
$query = dbquery("SELECT news_cat_image FROM ".$db_prefix."news_cats WHERE news_cat_id = '".$data['news_cat']."'");
$cat = dbarray($query);
echo "\n

";
echo "

".trimlink($data[news_subject], 100)." ($n_date) - Daugiau

".$news_news."

";
}
$result3 = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0");
echo "\n";
while ($data = dbarray($result3)) {
$title = $data['news_subject'];
$sh_title = $title;
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$v_id = $data['news_reads'];
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
echo "
\n";
}
echo "\n";
echo "

$n_date
".trimlink($data[news_subject], 100)." [$v_id | $comments_n]

- Naujienu archyvas
\n";
}


closetable();


}
if ($rows > $items_per_page) echo "
\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n
\n";
} else {

echo "";

}
} else {
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$naujiena'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
$news_cat_image = "";
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$naujiena'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
if ($data['news_cat'] != 0) {
$result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");
if (dbrows($result2)) {
$data2 = dbarray($result2);
$news_cat_image = "'".$data2['news_cat_name']."'";
}
}
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news, $news_info);
if ($data['news_allow_comments']) showcomments("N","news","news_id",$naujiena,FUSION_SELF."?naujiena=$naujiena");
if ($data['news_allow_ratings']) showratings("N",$naujiena,FUSION_SELF."?naujiena=$naujiena");
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}

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



require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";

if (isset($naujiena) && !isNum($naujiena)) fallback(FUSION_SELF);

if ($settings['news_style'] == "1") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = ""; $news_[1] = ""; $news_[2] = ""; } else { $i = 1; }

$items_per_page = 11;

if (!isset($naujiena)) {
$rows = dbcount("(news_id)", "news", groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")");
if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
if ($rows != 0) {
$result = dbquery(
"SELECT tn.*, tc.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
LEFT JOIN ".$db_prefix."news_cats tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().")
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT $rowstart,$items_per_page"
);
$numrows = dbrows($result);
if ($settings['news_style'] == "1") $nrows = round((dbrows($result) - 1) / 2);
while ($data = dbarray($result)) {
$news_cat_image = "";
$news_subject = "".stripslashes($data['news_subject']);
if ($data['news_cat_image']) {
$news_cat_image = "'".$data['news_cat_name']."'";
} else {
$news_cat_image = "";
}
$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => $data['news_extended'] ? "y" : "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
if ($settings['news_style'] == "1") {
if ($rows <= 2 || $ncount == 1) {
$news_[0] .= "\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n";
$news_[0] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[0] .= "
\n";
$news_[0] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date'])." \n";
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[0] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[0] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[0] .= $news_info['news_reads'].$locale['044']." \n";
}
$news_[0] .= "'".$locale['045']."'";
if (checkrights("N")) { $news_[0] .= " '".$locale['048']."'
\n
\n"; } else { $news_[0] .= "\n"; }
$news_[0] .= "
\n";
if ($ncount != $rows) $news_[0] .= "
''
\n";
} else {
if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; }
$row_color = ($rc % 2 == 0 ? "tbl2" : "tbl1");
$news_[$ncolumn] .= "\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n";
$news_[$ncolumn] .= "\n\n\n
$news_subject
$news_news
\n";
if (checkrights("N")) $news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= "'' ".$news_info['user_name']." ".$locale['041'].showdate("longdate", $news_info['news_date']);
if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) {
$news_[$ncolumn] .= "
\n";
$news_[$ncolumn] .= $news_info['news_ext'] == "y" ? "".$locale['042']." \n" : "";
$news_[$ncolumn] .= $news_info['news_allow_comments'] ? "".$news_info['news_comments'].$locale['043']." \n" : "";
$news_[$ncolumn] .= $news_info['news_reads'].$locale['044']." \n";
} else {
$news_[$ncolumn] .= " \n";
}
$news_[$ncolumn] .= "'".$locale['045']."'\n";
if (checkrights("N")) { $news_[$ncolumn] .= " '".$locale['048']."'
\n
\n"; } else { $news_[$ncolumn] .= "\n"; }
$news_[$ncolumn] .= "
\n";
if ($ncolumn == 1 && $i < ($nrows - 1)) $news_[$ncolumn] .= "
''
\n";
if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) $news_[$ncolumn] .= "
''
\n";
$i++; $rc++;
}
$ncount++;
} else {
render_news($news_subject, $news_news, $news_info);
if ($i != $numrows) { tablebreak(); } $i++;
}
}

if (isset($archyvas)) {

$query3 = dbquery("SELECT * FROM ".$db_prefix."news ORDER BY news_datestamp DESC");
if (mysql_num_rows($query3) == 0) {
echo "
Naujien nra
";
} else {
while ($data = dbarray($query3)) {
echo "".trimlink($data[news_subject], 100)."
";
}
}

} elseif ($settings['news_style'] == "1") {
opentable("Naujienos");
$result=dbquery("SELECT * FROM ".DB_PREFIX."news ORDER BY news_datestamp DESC LIMIT 0,4");

if(dbrows($result)!=0){
while($data=dbarray($result)){
$result2 = dbquery("SELECT news_cat_name FROM ".DB_PREFIX."news_cats WHERE news_cat_id='$data[news_cat]'");
$n_id = $data['news_id'];
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
$v_id = $data['news_reads'];

$category = dbresult($result2,0);

$news_news = $data['news_breaks'] == "y" ? nl2br(stripslashes($data['news_news'])) : stripslashes($data['news_news']);
$query = dbquery("SELECT news_cat_image FROM ".$db_prefix."news_cats WHERE news_cat_id = '".$data['news_cat']."'");
$cat = dbarray($query);
echo "\n

";
echo "

".trimlink($data[news_subject], 100)." ($n_date) - Daugiau

".$news_news."

";
}
$result3 = dbquery("SELECT * FROM ".DB_PREFIX."news WHERE ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().") AND (news_end='0'||news_end>=".time().") ORDER BY news_datestamp DESC LIMIT 0");
echo "\n";
while ($data = dbarray($result3)) {
$title = $data['news_subject'];
$sh_title = $title;
$comments_n = dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id=".$data['news_id']."");
$v_id = $data['news_reads'];
$date = $data['news_datestamp'];
$n_date = showdate("%Y %m %d", $date);
echo "
\n";
}
echo "\n";
echo "

$n_date
".trimlink($data[news_subject], 100)." [$v_id | $comments_n]

- Naujienu archyvas
\n";
}


closetable();


}
if ($rows > $items_per_page) echo "
\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n
\n";
} else {

echo "";

}
} else {
include INCLUDES."comments_include.php";
include INCLUDES."ratings_include.php";
$result = dbquery(
"SELECT tn.*, user_id, user_name FROM ".$db_prefix."news tn
LEFT JOIN ".$db_prefix."users tu ON tn.news_name=tu.user_id
WHERE news_id='$naujiena'"
);
if (dbrows($result)!=0) {
$data = dbarray($result);
if (checkgroup($data['news_visibility'])) {
$news_cat_image = "";
if (!isset($_POST['post_comment']) && !isset($_POST['post_rating'])) {
$result2 = dbquery("UPDATE ".$db_prefix."news SET news_reads=news_reads+1 WHERE news_id='$naujiena'");
$data['news_reads']++;
}
$news_subject = $data['news_subject'];
if ($data['news_cat'] != 0) {
$result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats WHERE news_cat_id='".$data['news_cat']."'");
if (dbrows($result2)) {
$data2 = dbarray($result2);
$news_cat_image = "'".$data2['news_cat_name']."'";
}
}
$news_news = stripslashes($data['news_extended'] ? $data['news_extended'] : $data['news_news']);
if ($data['news_breaks'] == "y") { $news_news = nl2br($news_news); }
if ($news_cat_image != "") $news_news = $news_cat_image.$news_news;
$news_info = array(
"news_id" => $data['news_id'],
"user_id" => $data['user_id'],
"user_name" => $data['user_name'],
"news_date" => $data['news_datestamp'],
"news_ext" => "n",
"news_reads" => $data['news_reads'],
"news_comments" => dbcount("(comment_id)", "comments", "comment_type='N' AND comment_item_id='".$data['news_id']."'"),
"news_allow_comments" => $data['news_allow_comments']
);
render_news($news_subject, $news_news, $news_info);
if ($data['news_allow_comments']) showcomments("N","news","news_id",$naujiena,FUSION_SELF."?naujiena=$naujiena");
if ($data['news_allow_ratings']) showratings("N",$naujiena,FUSION_SELF."?naujiena=$naujiena");
} else {
redirect(FUSION_SELF);
}
} else {
redirect(FUSION_SELF);
}
}

require_once "side_right.php";
require_once "footer.php";
?>
va no smiles rry uz flood
Redagavo Logix 2009-11-23 19:15
 
PM
Peršokti į forumą: