Imam sajt www.mrakcafe.net i postavio sam neku skriptu za linkove ...
Posto se ja razumem povrsno u php ja sam ju i povrsno modifikovao ...
Oko jedne stvari se ja mucim vec danima zelim da mi se na prvoj stranici po svakoj kategoriji izlista po recimo 5 linkova
i u svakoj kategoriji posle ti linkova da bude link za otvaranje te kategorije ...
Od programa za php imam adobe DW i phpDesigner 8
evo dio koda de se to ja mislim mora modefikovati ...
unapred cu vam biti zahvalan ...
kako ta skripta trenutno radi mozete pogledati na www.mrakcafe.net
Posto se ja razumem povrsno u php ja sam ju i povrsno modifikovao ...
Oko jedne stvari se ja mucim vec danima zelim da mi se na prvoj stranici po svakoj kategoriji izlista po recimo 5 linkova
i u svakoj kategoriji posle ti linkova da bude link za otvaranje te kategorije ...
Od programa za php imam adobe DW i phpDesigner 8
evo dio koda de se to ja mislim mora modefikovati ...
Code:
ENDHTML;
if($ldir_acceptlinks && $c['acceptlinks']) {
echo "<a href=\"{$site_url}/addlink.php?c={$c['catid']}\" class=\"submitlink\">Dodaj Internet Stranicu</a>\n";
}
echo <<<ENDHTML
</td></tr>
</table>
ENDHTML;
/* Show any sub categories for this category */
$res = mysql_query("SELECT ctitle, catid, cdesc, csafe, curl FROM {$prefix}cat WHERE cparent='{$c['catid']}' ORDER BY ctitle ASC", $db);
if(mysql_num_rows($res)) {
echo "<table border=\"0\" cellpadding=\"2px\" cellspacing=\"0\" class=\"dirsublist\" width=\"100%\">\n";
echo "<tr><td>\n";
while($row = mysql_fetch_array($res)) {
echo "<span class=\"subdir\"><a href=\"{$site_url}/";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/":"browse.php?c={$row['catid']}");
echo "\">{$row['ctitle']}</a><br>\n";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/":"{$site_url}/browse.php?c={$row['catid']}");
echo "<p>".substr($row['cdesc'],0,200)."...</p></span>\n";
}
echo "</td></tr>\n";
echo "</table>\n";
}
/* Show links for this category */
$view = 0;
$show = 20;
$res = mysql_query("SELECT COUNT(*) FROM {$prefix}link WHERE bactive=1 AND catid='{$c['catid']}'", $db);
$count = mysql_result($res,0);
if(isset($_GET['view']) && is_numeric($_GET['view']) && $_GET['view']>0 && $_GET['view']<$count) {
$view = round($_GET['view']);
}
if($count>$show) {
$pagelist = "<div class=\"pagelist\">\n";
$ahtm = "<a href=\"{$site_url}/";
$ahtm.= ($ldir_usestatic?"{$ldir_folderroot}/{$c['curl']}/?":"browse.php?c={$c['catid']}&");
$ahtm.= "view=";
if($view>0) {
$pageli5st.= $ahtm.(($view-$show)<0?0:($view-$show))."\">Back</a> ";
}
for($i=0;$i<floor($count/$show);$i++) {
if(($i*$show)==$view) { $pagelist.= "<b>".($i+1)."</b> "; }
else {
$pagelist.= $ahtm.($i*$show)."\">".($i+1)."</a> ";
}
}
if(($view+$show)<$count) {
$pagelist.= $ahtm.($view+$show)."\">Next</a>";
}
$pagelist.= "</div>\n";
echo $pagelist;
}
if($count) {
$res = mysql_query("SELECT ltitle, lurl, ldesc, linkid, ctime, allowrating, lhits, rate1, rate2, rate3, rate4, rate5, lsafe, curl FROM {$prefix}link WHERE bactive=1 AND catid='{$c['catid']}' ORDER BY lrank DESC, ctime DESC LIMIT {$view},{$show}", $db);
while($row = mysql_fetch_array($res)) {
$row['nhits'] = number_format($row['lhits']);
$row['nratings'] = number_format($row['rate1']+$row['rate2']+$row['rate3']+$row['rate4']+$row['rate5']);
if(!$row['nratings']) { $row['nscore'] = "(not yet rated)"; }
else {
$row['nscore'] = round(($row['rate1']+($row['rate2']*2)+($row['rate3']*3)+($row['rate4']*4)+($row['rate5']*5))/$row['nratings']);
}
echo "<div class=\"dirlink\">";
if($row['allowrating'] && $ldir_allowrating && $row['nratings']) {
echo "<span class=\"linkrating\">";
for($i=1;$i<=5;$i++) {
if($i<=$row['nscore']) {
echo "<img src=\"{$site_url}/imgs/ico_star_full.gif\" alt=\"{$i}\" border=\"0\" width=\"20px\" height=\"20px\">";
} else {
echo "<img src=\"{$site_url}/imgs/ico_star_empty.gif\" alt=\"{$i}\" border=\"0\" width=\"20px\" height=\"20px\">";
}
}
echo "</span>\n";
}
echo "<a href=\"{$site_url}/";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/{$row['lsafe']}.html":"viewlink.php?l={$row['linkid']}");
echo "\">{$row['ltitle']}</a><br>\n";
echo "<i>Added ".date('jS F, Y', $row['ctime'])."</i>\n";
echo "<span class=\"linkhits\">{$row['nhits']} Visits</span>\n";
echo "<p>".substr($row['ldesc'],0,200)."...";
echo "</p></div>\n";
ENDHTML;
if($ldir_acceptlinks && $c['acceptlinks']) {
echo "<a href=\"{$site_url}/addlink.php?c={$c['catid']}\" class=\"submitlink\">Dodaj Internet Stranicu</a>\n";
}
echo <<<ENDHTML
</td></tr>
</table>
ENDHTML;
/* Show any sub categories for this category */
$res = mysql_query("SELECT ctitle, catid, cdesc, csafe, curl FROM {$prefix}cat WHERE cparent='{$c['catid']}' ORDER BY ctitle ASC", $db);
if(mysql_num_rows($res)) {
echo "<table border=\"0\" cellpadding=\"2px\" cellspacing=\"0\" class=\"dirsublist\" width=\"100%\">\n";
echo "<tr><td>\n";
while($row = mysql_fetch_array($res)) {
echo "<span class=\"subdir\"><a href=\"{$site_url}/";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/":"browse.php?c={$row['catid']}");
echo "\">{$row['ctitle']}</a><br>\n";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/":"{$site_url}/browse.php?c={$row['catid']}");
echo "<p>".substr($row['cdesc'],0,200)."...</p></span>\n";
}
echo "</td></tr>\n";
echo "</table>\n";
}
/* Show links for this category */
$view = 0;
$show = 20;
$res = mysql_query("SELECT COUNT(*) FROM {$prefix}link WHERE bactive=1 AND catid='{$c['catid']}'", $db);
$count = mysql_result($res,0);
if(isset($_GET['view']) && is_numeric($_GET['view']) && $_GET['view']>0 && $_GET['view']<$count) {
$view = round($_GET['view']);
}
if($count>$show) {
$pagelist = "<div class=\"pagelist\">\n";
$ahtm = "<a href=\"{$site_url}/";
$ahtm.= ($ldir_usestatic?"{$ldir_folderroot}/{$c['curl']}/?":"browse.php?c={$c['catid']}&");
$ahtm.= "view=";
if($view>0) {
$pageli5st.= $ahtm.(($view-$show)<0?0:($view-$show))."\">Back</a> ";
}
for($i=0;$i<floor($count/$show);$i++) {
if(($i*$show)==$view) { $pagelist.= "<b>".($i+1)."</b> "; }
else {
$pagelist.= $ahtm.($i*$show)."\">".($i+1)."</a> ";
}
}
if(($view+$show)<$count) {
$pagelist.= $ahtm.($view+$show)."\">Next</a>";
}
$pagelist.= "</div>\n";
echo $pagelist;
}
if($count) {
$res = mysql_query("SELECT ltitle, lurl, ldesc, linkid, ctime, allowrating, lhits, rate1, rate2, rate3, rate4, rate5, lsafe, curl FROM {$prefix}link WHERE bactive=1 AND catid='{$c['catid']}' ORDER BY lrank DESC, ctime DESC LIMIT {$view},{$show}", $db);
while($row = mysql_fetch_array($res)) {
$row['nhits'] = number_format($row['lhits']);
$row['nratings'] = number_format($row['rate1']+$row['rate2']+$row['rate3']+$row['rate4']+$row['rate5']);
if(!$row['nratings']) { $row['nscore'] = "(not yet rated)"; }
else {
$row['nscore'] = round(($row['rate1']+($row['rate2']*2)+($row['rate3']*3)+($row['rate4']*4)+($row['rate5']*5))/$row['nratings']);
}
echo "<div class=\"dirlink\">";
if($row['allowrating'] && $ldir_allowrating && $row['nratings']) {
echo "<span class=\"linkrating\">";
for($i=1;$i<=5;$i++) {
if($i<=$row['nscore']) {
echo "<img src=\"{$site_url}/imgs/ico_star_full.gif\" alt=\"{$i}\" border=\"0\" width=\"20px\" height=\"20px\">";
} else {
echo "<img src=\"{$site_url}/imgs/ico_star_empty.gif\" alt=\"{$i}\" border=\"0\" width=\"20px\" height=\"20px\">";
}
}
echo "</span>\n";
}
echo "<a href=\"{$site_url}/";
echo ($ldir_usestatic?"{$ldir_folderroot}/{$row['curl']}/{$row['lsafe']}.html":"viewlink.php?l={$row['linkid']}");
echo "\">{$row['ltitle']}</a><br>\n";
echo "<i>Added ".date('jS F, Y', $row['ctime'])."</i>\n";
echo "<span class=\"linkhits\">{$row['nhits']} Visits</span>\n";
echo "<p>".substr($row['ldesc'],0,200)."...";
echo "</p></div>\n";
unapred cu vam biti zahvalan ...
kako ta skripta trenutno radi mozete pogledati na www.mrakcafe.net
Potpis
The Outsider