Pradinis
Pagalba
Užsisakyk!
- Reklamą
- Hostingą
- El. pašto dėžutę
Užsisakyk!
Įrankiai
Pasidalink
- Visos temos
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Bendri PHP-F klausimai |
Autorius: Jointass | Peržiūrų: 2609 |
Jointass Narys Kapitonas Pranešimai: 647 Įstojęs: 2007 Spa. 31 20:10:10 | |
Sveiki, tai va iškilo toke problema pas mane buvo news.php kad paspaudus svečiui "skaityti daugiau" parašydavo kad tik nariams dabar pasidariau nauja news.php kad veiktu reitingas ir pradingo tas naujienos tik nariams tai kas galit padarykit mano news.php kad butu naujienos tik nariams. Va mano news.php: <?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"; if (isset($readmore) && !isNum($readmore)) fallback(FUSION_SELF); // Predefined variables, do not edit these values if ($settings['news_style'] == "1") { $i = 0; $rc = 0; $ncount = 1; $ncolumn = 1; $news_[0] = ""; $news_[1] = ""; $news_[2] = ""; } else { $i = 1; } // This number should be an odd number to keep layout tidy $items_per_page = 11; if (!isset($readmore)) { $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)) { $num_votes = dbresult(dbquery("SELECT COUNT(rating_item_id) FROM ".DB_PREFIX."ratings WHERE rating_item_id='".$data['news_id']."' AND rating_type='N'"),0); $tot_votes = dbresult(dbquery("SELECT SUM(rating_vote) FROM ".DB_PREFIX."ratings WHERE rating_item_id='".$data['news_id']."' AND rating_type='N'"),0); if (( $num_votes > 0 ) && ($tot_votes > 0)) { $pct_rating = ceil(round($tot_votes / $num_votes)); $voto = "<img src='".IMAGES."rating".$pct_rating.".gif' border='0'>"; } else { $voto = "<img src='".IMAGES."rating0.gif' border='0'>"; } $news_rating = "$voto"; $news_cat_image = ""; $news_subject = "<a href='".BASEDIR."news.php?readmore=".$data['news_id']."'>".stripslashes($data['news_subject'])."</a>"; if ($data['news_cat_image']) { $news_cat_image = "<a href='news_cats.php?cat_id=".$data['news_cat_id']."'><img src='".IMAGES_NC.$data['news_cat_image']."' alt='".$data['news_cat_name']."' align='left' style='border:0px;margin-top:3px;margin-right:5px'></a>"; } 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] .= "<table width='100%' cellpadding='0' cellspacing='0'>\n"; $news_[0] .= "<tr>\n<td class='tbl2'><b>$news_subject</b></td>\n</tr>\n"; $news_[0] .= "<tr>\n<td class='tbl1' style='text-align:justify'>$news_news</td>\n</tr>\n"; $news_[0] .= "<tr>\n<td align='center' class='tbl2'>\n"; if (iSUPERADMIN && checkrights("N")) $news_[0] .= "<form name='editnews".$news_info['news_id']."' method='post' action='".ADMIN."news.php".$aidlink."&news_id=".$news_info['news_id']."'>\n"; $news_[0] .= "<span class='small2'><img src='".THEME."images/bullet.gif' alt=''> <a href='profile.php?lookup=".$news_info['user_id']."'>".$news_info['user_name']."</a> ".$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" ? "<a href='".FUSION_SELF."?readmore=".$news_info['news_id']."'>".$locale['042']."</a> ·\n" : ""; $news_[0] .= $news_info['news_allow_comments'] ? "<a href='".FUSION_SELF."?readmore=".$news_info['news_id']."'>".$news_info['news_comments'].$locale['043']."</a> ·\n" : ""; $news_[0] .= $news_info['news_reads'].$locale['044']." ·\n"; } $news_[0] .= "<a href='print.php?type=N&item_id=".$news_info['news_id']."'><img src='".THEME."images/printer.gif' alt='".$locale['045']."' style='border:0px;vertical-align:middle;'></a>"; if (iSUPERADMIN && checkrights("N")) { $news_[0] .= " · <input type='hidden' name='edit' value='edit'><a href='javascript:document.editnews".$news_info['news_id'].".submit();'><img src='".IMAGES."edit.gif' alt='".$locale['048']."' title='".$locale['048']."' style='vertical-align:middle;border:0px;'></a></span>\n</form>\n"; } else { $news_[0] .= "</span>\n"; } $news_[0] .= "</td>\n</tr>\n</table>\n"; if ($ncount != $rows) $news_[0] .= "<div><img src='".THEME."images/blank.gif' alt='' width='1' height='8'></div>\n"; } else { if ($i == $nrows && $ncolumn != 2) { $ncolumn = 2; $i = 0; } $row_color = ($rc % 2 == 0 ? "tbl2" : "tbl1"); $news_[$ncolumn] .= "<table width='100%' cellpadding='0' cellspacing='0'>\n"; $news_[$ncolumn] .= "<tr>\n<td class='tbl2'><b>$news_subject</b></td>\n</tr>\n"; $news_[$ncolumn] .= "<tr>\n<td class='tbl1' style='text-align:justify'>$news_news</td>\n</tr>\n"; $news_[$ncolumn] .= "<tr>\n<td align='center' class='tbl2'>\n"; if (iSUPERADMIN && checkrights("N")) $news_[$ncolumn] .= "<form name='editnews".$news_info['news_id']."' method='post' action='".ADMIN."news.php".$aidlink."&news_id=".$news_info['news_id']."'>\n"; $news_[$ncolumn] .= "<span class='small2'><img src='".THEME."images/bullet.gif' alt=''> <a href='profile.php?lookup=".$news_info['user_id']."'>".$news_info['user_name']."</a> ".$locale['041'].showdate("longdate", $news_info['news_date']); if ($news_info['news_ext'] == "y" || $news_info['news_allow_comments']) { $news_[$ncolumn] .= "<br>\n"; $news_[$ncolumn] .= $news_info['news_ext'] == "y" ? "<a href='".FUSION_SELF."?readmore=".$news_info['news_id']."'>".$locale['042']."</a> ·\n" : ""; $news_[$ncolumn] .= $news_info['news_allow_comments'] ? "<a href='".FUSION_SELF."?readmore=".$news_info['news_id']."'>".$news_info['news_comments'].$locale['043']."</a> ·\n" : ""; $news_[$ncolumn] .= $news_info['news_reads'].$locale['044']." ·\n"; } else { $news_[$ncolumn] .= " ·\n"; } $news_[$ncolumn] .= "<a href='print.php?type=N&item_id=".$news_info['news_id']."'><img src='".THEME."images/printer.gif' alt='".$locale['045']."' style='border:0px;vertical-align:middle;'></a>\n"; if (iSUPERADMIN && checkrights("N")) { $news_[$ncolumn] .= " · <input type='hidden' name='edit' value='edit'><a href='javascript:document.editnews".$news_info['news_id'].".submit();'><img src='".IMAGES."edit.gif' alt='".$locale['048']."' title='".$locale['048']."' style='vertical-align:middle;border:0px;'></a></span>\n</form>\n"; } else { $news_[$ncolumn] .= "</span>\n"; } $news_[$ncolumn] .= "</td>\n</tr>\n</table>\n"; if ($ncolumn == 1 && $i < ($nrows - 1)) $news_[$ncolumn] .= "<div><img src='".THEME."images/blank.gif' alt='' width='1' height='8'></div>\n"; if ($ncolumn == 2 && $i < (dbrows($result) - $nrows - 2)) $news_[$ncolumn] .= "<div><img src='".THEME."images/blank.gif' alt='' width='1' height='8'></div>\n"; $i++; $rc++; } $ncount++; } else { render_news($news_subject, $news_news, $news_info, $news_rating); if ($i != $numrows) { tablebreak(); } $i++; } } if ($settings['news_style'] == "1") { opentable($locale['046']); echo "<table cellpadding='0' cellspacing='0' style='width:100%'>\n<tr>\n<td colspan='3' style='width:100%'>\n"; echo $news_[0]; echo "</td>\n</tr>\n<tr>\n<td style='width:50%;vertical-align:top;'>\n"; echo $news_[1]; echo "</td>\n<td style='width:10px'><img src='".THEME."images/blank.gif' alt='' width='10' height='1'></td>\n<td style='width:50%;vertical-align:top;'>\n"; echo $news_[2]; echo "</td>\n</tr>\n</table>\n"; closetable(); } if ($rows > $items_per_page) echo "<div align='center' style='margin-top:5px;'>\n".makePageNav($rowstart,$items_per_page,$rows,3)."\n</div>\n"; } else { opentable($locale['046']); echo "<center><br>\n".$locale['047']."<br><br>\n</center>\n"; closetable(); } } 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='$readmore'" ); $num_votes = dbresult(dbquery("SELECT COUNT(rating_item_id) FROM ".DB_PREFIX."ratings WHERE rating_item_id='$readmore' AND rating_type='N'"),0); $tot_votes = dbresult(dbquery("SELECT SUM(rating_vote) FROM ".DB_PREFIX."ratings WHERE rating_item_id='$readmore' AND rating_type='N'"),0); if (( $num_votes > 0 ) && ($tot_votes > 0)) { $pct_rating = ceil(round($tot_votes / $num_votes)); $voto = "<img src='".IMAGES."rating".$pct_rating.".gif' border='0'>"; } else { $voto = "<img src='".IMAGES."rating0.gif' border='0'>"; } if (dbrows($result)!=0) { $data = dbarray($result); if (checkgroup($data['news_visibility'])) { $news_rating = "$voto"; $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='$readmore'"); $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 = "<a href='news_cats.php?cat_id=".$data2['news_cat_id']."'><img src='".IMAGES_NC.$data2['news_cat_image']."' alt='".$data2['news_cat_name']."' align='left' style='border:0px;margin-top:3px;margin-right:5px'></a>"; } } $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, $news_rating); if ($data['news_allow_comments']) showcomments("N","news","news_id",$readmore,FUSION_SELF."?readmore=$readmore"); if ($data['news_allow_ratings']) showratings("N",$readmore,FUSION_SELF."?readmore=$readmore"); } else { redirect(FUSION_SELF); } } else { redirect(FUSION_SELF); } } require_once "side_right.php"; require_once "footer.php"; ?> Tai kam nesunku padarykit pats bandžiau meta errora ;/ |
|
Vilme Narys Kapitonas Pranešimai: 670 Įstojęs: 2008 Vas. 17 21:02:35 | |
O pries tai pats buvai pasidares ??? |
|
Jointass Narys Kapitonas Pranešimai: 647 Įstojęs: 2007 Spa. 31 20:10:10 | |
pajemiau iš skriptu bibliotekos naujienos tik nariams... |
|
Vilme Narys Kapitonas Pranešimai: 670 Įstojęs: 2008 Vas. 17 21:02:35 | |
Nu tai jei pries tai buvai pasidares ko db negali ??? |
|
Jointass Narys Kapitonas Pranešimai: 647 Įstojęs: 2007 Spa. 31 20:10:10 | |
nu ten isas news.php buvo o čia jei pakeisiu news.php nebus rating.... |
|
Vilme Narys Kapitonas Pranešimai: 670 Įstojęs: 2008 Vas. 17 21:02:35 | |
Tai susirask kur metei rating koda tada pakeis news.php i ta koda naujienos tik nariams ir tada darasyk tik rating ta koda |
|
Jointass Narys Kapitonas Pranešimai: 647 Įstojęs: 2007 Spa. 31 20:10:10 | |
nieko nesigauna gal kas galit padaryt labai prašau |
|
Vilme Narys Kapitonas Pranešimai: 670 Įstojęs: 2008 Vas. 17 21:02:35 | |
Turi rating koda??? |
|
Jointass Narys Kapitonas Pranešimai: 647 Įstojęs: 2007 Spa. 31 20:10:10 | |
tai gi viršui parašiau visa theme.php su rating atskirai nėra... |
|
dumis Narys Fruktas Pranešimai: 26 Įstojęs: 2008 Kov. 30 18:03:35 | |
. |
Peršokti į forumą: |