Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Naujausi siuntiniai
Parašė gintulys· 2009 Lie. 7 20:07:40
#1
Stai naudoju tokia naujausiu siuntiniu panele bet gal kas turi koda kad rasytu kiek komentaru parasyta na kaip yra kiek aciustia man dar reikia kad butu kiek komentaru.
Jei kas turi si koduka gal pasidalintu :?
Redagavo gintulys· 2009 Lie. 7 21:07:33
Parašė zDon· 2009 Lie. 7 20:07:17
#2
Kokią sistemą naudoji ?
Parašė gintulys· 2009 Lie. 7 20:07:47
#3
v6
Parašė Pakartoti slaptažodį· 2009 Lie. 7 20:07:00
#4
Pagal šnapso siuntinių modą galima prisitaikyt. :)
Parašė gintulys· 2009 Lie. 7 20:07:51
#5
na tai cia is download.php failo galima isimt ta koda bet nlb man iseina :D Todel ir prasau
Redagavo gintulys· 2009 Lie. 7 20:07:21
Parašė zDon· 2009 Lie. 7 20:07:02
#6
Tai gal duosi downloads.php ? :?
Parašė gintulys· 2009 Lie. 7 21:07:40
#7
<?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> <a href='".FUSION_SELF."' class='small' title='Siuntiniai'><b>Siuntiniai</b></a> >> <a href='".FUSION_SELF."?cat_id=".$data['download_cat']."' class='small' title='Siuntinio Kategorija'><b>$kat</b></a> > <a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&download_id=".$data['download_id']."' title='Atsisiøsti Siuntiná'><b>".$data['download_title']."</b></a> </td>
<td align='right'><span class='small2'><b>Pridëtas:</b> $laikas</span></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 rowspan='2' class='tbl1' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=".$data['download_cat']."&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>
<td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n<td width='30%' class='tbl1'><b>".$locale['411']."</b> ".$data['download_license']."</td>\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }
echo "<td width='40%' class='tbl2'><b>Komentarai:</b> $komentarai</td>\n</tr>\n<tr>\n<td width='30%' class='tbl2'><b>".$locale['412']."</b> ".$data['download_os']." </td>\n";
echo "<td width='30%' class='tbl1'><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> <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='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 width='1%'><a class='small' href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Þiûrëti failà' style='font-weight: bold;'><img src='".IMAGES."down.png' alt='Þiûrëti failà' border='0'></a></td>
<td> <a class='small' href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Þiûrëti failà' style='font-weight: bold;'><b>".$data['download_title']."</b></a> </td>
<td align='right'><span class='small2'><b>Pridëtas:</b> $laikas</span></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 rowspan='2' class='tbl1' align='center' valign='middle' width='1%'><a class='small' href='".FUSION_SELF."?cat_id=$cat_id&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>
<td width='30%' class='tbl2'><b>".$locale['413']."</b> ".$data['download_version']."</td>\n<td width='30%' class='tbl1'><b>".$locale['411']."</b> ".$data['download_license']."</td>\n";
$kom = dbquery("SELECT count(comment_id) FROM ".$db_prefix."comments WHERE comment_type='D' AND comment_item_id='$id'");
$kon = dbresult($kom, 0);
if ($kon == 0) { $komentarai = 0; } else { $komentarai = $kon; }
echo "<td width='40%' class='tbl2'><b>Komentarai:</b> $komentarai</td>
<td class='tbl1' rowspan='2' colspan='1' align='right' valign='bottom' width='1%'>
<a href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Þiûrëti failo komentarus'><img src='images/comments.png' alt='Komentuoti' border='0'></a><br>
<a href='".FUSION_SELF."?d_id=".$data['download_id']."' title='Þiûrëti failo reitingus'><img src='images/ratings.png' alt='Vertinti' border='0'></a>
</td>\n</tr>\n<tr>\n<td width='30%' class='tbl2'><b>".$locale['412']."</b> ".$data['download_os']." </td>\n";
echo "<td width='30%' class='tbl1'><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&")."\n</div>\n";
} else {
echo $locale['431']."\n";
closetable();
}
}
}
if ($res == 0) redirect(FUSION_SELF);
}
}
require_once "side_right.php";
require_once "footer.php";
?>
Parašė And2s· 2009 Lie. 7 21:07:31
#8
dbcount("(comment_id)", DB_PREFIX."comments", "comment_type='D' AND comment_item_id='".$data['download_id']."'");
Redagavo And2s· 2009 Lie. 7 21:07:54
Parašė gintulys· 2009 Lie. 7 21:07:07
#9
O gal galetumet sita koda pakeist kad rotitu kiek komentaru o ne kiek aciusta ?
<td align='right'>Komentarai:</td>
<td align='right'>".$data['download_count']."</td>
Redagavo gintulys· 2009 Lie. 7 21:07:38
Parašė And2s· 2009 Lie. 7 21:07:41
#10
gintulys parašė:
O gal galetumet sita koda pakeist kad rotitu kiek komentaru o ne kiek aciusta ?
<td align='right'>Komentarai:</td>
<td align='right'>".dbcount("(comment_id)", DB_PREFIX."comments", "comment_type='D' AND comment_item_id='".$data['download_id']."'")."</td>
Redagavo And2s· 2009 Lie. 7 21:07:08
Parašė gintulys· 2009 Lie. 7 21:07:09
#11
Table '_1.fusion_fusion_comments' doesn't existTable '_1.fusion_fusion_comments' doesn't
Kodel sita meta:?
Redagavo gintulys· 2009 Lie. 7 21:07:09
Parašė And2s· 2009 Lie. 7 21:07:34
#12
<td align='right'>Komentarai:</td>
<td align='right'>".dbcount("(comment_id)", "comments", "comment_type='D' AND comment_item_id='".$data['download_id']."'")."</td>
Parašė gintulys· 2009 Lie. 7 21:07:15
#13
O dabar gerai lb dekui tau ;) Bet visitek pamirsai smailus isjunkt :D