CNCat hacks

Jak zprovoznit RSS?

Postup je poměrně jednoduchý. Potřebujete vytvořit dva soubory: configrss.php a rss.php. Configrss.php je ořezanou verzí konfiguračho souboru config.php, pomocí kterého se katalog zprovozuje. Hvězdičky představují vaše konfigurační data.

<?
$db["host"]="*************";
$db["user"]="*************";
$db["password"]="*************";
$db["name"]="*************";
$db["prefix"]="*************";

$db["alogin"]="*************";
$db["apassword"]="*************";

$cat["mailifnewlink"]="yes";
$cat["mailifnewlinkto"]="*************";
$cat["mailifnewlinksubject"]="Frogman - novy odkaz do katalogu";
$cat["duptestcount"]=10;
$cat["shownew"]=1;
$cat["shownewcount"]=10;
$cat["linksatmain"]=1;
$cat["rows"]=1;
$cat["resfield1"]="";
$cat["resfield2"]="";
$cat["resfield3"]="";
$cat["defaultorder"]=0;

$CATNAME="Potápěč  - úvodní strana";
$LANGFILE="lang_cs.php";

$TMPL["newlinkstbit"]="

<item>
<title>%TITLE</title>
<link>http://kotrla.com/frogman/jump.php?%ID</link>
<description>%DESC75</description>
</item> ";

////////////////////////////////////////////

@mysql_connect($db["host"],$db["user"],$db["password"]);
@mysql_select_db($db["name"]);

function mhtml($s) {
	$s=StripSlashes($s);
	$s=str_replace("'","'",$s);
	$s=str_replace("\"",""",$s);
	return($s);
	}

Soubor rss.php pak obsahuje následující kód (nezapomeňte mé údaje, které ponechávám pro ilustraci, nahradit vlastními!):

<?php echo "<?xml version=\"1.0\" encoding=\"windows-1250\"?".">"; ?>

<rss version="0.91">
<channel>
<title>Potápěč</title>
<link>http://kotrla.com/frogman/index.php
<description>Váš dýchací přístroj ve světě literatury</description>
<language>cs</language>
<image>
<title>Potápěč</title>
<url>http://kotrla.com/frogman/img/frogmanbutt.gif</url>
<link>http://kotrla.com/frogman/index.php
<description>Váš dýchací přístroj ve světě literatury</description>
</image>
<?

error_reporting(E_ALL & ~E_NOTICE);
ini_set("session.use_trans_sid",0);
session_register("sid");

if (is_file("install.php") && !is_file("configrss.php")) {include "install.php";die();}

require "configrss.php";
require "lang/".$LANGFILE;

$o=$_GET["o"];
$c=$_GET["c"];
$defaultorder=intval($cat["defaultorder"]);
if ($defaultorder<0 || $defaultorder>3) $defaultorder=0;
if (($o<0 && $o>3) || !isset($o)) $o=$defaultorder;

function ShowParts($cid) {
	GLOBAL $cat,$TMPL,$db;

$r=mysql_query("SELECT name,cid,count FROM ".$db["prefix"]."cat WHERE parent='$cid' ORDER BY name") or die(mysql_error());
	$num=0;
	$cnt=mysql_num_rows($r);
	if ($cnt==0) return;
	print $TMPL["partstop"];
	for ($i=0;$i<$cnt;$i++) {
		$num++;
		if ($num==1) print $TMPL["partsdelimtop"];

$template=$TMPL["partsbit"];
		$template=str_replace("%CTITLE",mysql_result($r,$i,0),$template);
		$template=str_replace("%CID",mysql_result($r,$i,1),$template);
		$template=str_replace("%CCOUNT",mysql_result($r,$i,2),$template);
		print $template;
		if ($num==$cat["rows"]) {print $TMPL["partsdelimbottom"];$num=0;}
		}
	print $TMPL["partsbottom"];
	}

function ShowCat($cid,$best=0) {
	GLOBAL $start,$pp,$o,$sid,$LANG,$TMPL,$db;

if ($best==1) $bestsql="AND moder_vote=10"; else $bestsql="AND moder_vote!=10";

if ($o==0) $order="ORDER BY gin DESC,gout DESC";
	if ($o==1) $order="ORDER BY title";
	if ($o==2) $order="ORDER BY moder_vote DESC, gout DESC";
	if ($o==3) $order="ORDER BY insert_date DESC";

if ($cid!=0) $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid $order LIMIT $start,$pp;";
	else $Q="SELECT lid,url,title,description,gin,gout,moder_vote,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 $bestsql $order LIMIT $start,$pp;";
	$r=mysql_query($Q) or die(mysql_error());
	$cnt=mysql_num_rows($r);
	if ($cnt==0 && $best!=1) print $LANG["linksnotfound"];

while ($ar=mysql_fetch_array($r)) {
		$admin="";
		if (isset($sid)) {
			$admin.=" [<a href=admin/edit.php?lid=".$ar["lid"]."&type=255 class=slink>".$LANG["edit"]."</a>]";
			$admin.="[<a href=admin/moveto.php?lid=".$ar["lid"]."&type=1&to=2 class=slink>".$LANG["delete"]."</a>] [";
			for ($j=1;$j<11;$j++) {
				if ($j==$ar["moder_vote"]) $admin.="".$j." ";
				else $admin.="<a href=admin/vote.php?lid=".$ar["lid"]."&vote=$j&type=255 class=slink>".$j."</a> ";
				}
			$admin.="]";
			}

$template=($best==1)?$TMPL["bestlinksbit"]:$TMPL["linksbit"];
		$template=str_replace("%ID",$ar["lid"],$template);
		$template=str_replace("%TITLE",$ar["title"],$template);
		$template=str_replace("%GIN",$ar["gin"],$template);
		$template=str_replace("%GOUT",$ar["gout"],$template);
		$template=str_replace("%MODERVOTE",$ar["moder_vote"],$template);
		$template=str_replace("%DESC",$ar["description"],$template);
		$template=str_replace("%URL",$ar["url"],$template);
		$template=str_replace("%BEST","<img src=./cat/star.gif width=15 height=16 hspace=3>",$template);
		$template=str_replace("%BROKENTEXT",$LANG["broken"],$template);
		$template=str_replace("%RESFIELD1",$ar["resfield1"],$template);
		$template=str_replace("%RESFIELD2",$ar["resfield2"],$template);
		$template=str_replace("%RESFIELD3",$ar["resfield3"],$template);
		$template=str_replace("%ADMINIFACE",$admin,$template);
		print $template;
		}
	if ($best!=1) {
		if ($cid!=0) return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql AND cat1=$cid;"),0,0));
		else return(mysql_result(mysql_query("SELECT count(*) FROM ".$db["prefix"]."main WHERE type=1 $bestsql;"),0,0));
		}
	}

$c=intval($c);
$start=intval($start);
$pp=10;
	$cid=$c;$l="";
	do {
		$r=mysql_query("SELECT parent,name,cid FROM ".$db["prefix"]."cat WHERE cid='$cid';") or die(mysql_error());
		if (mysql_num_rows($r)==1) {
			$id=mysql_result($r,0,2);
			$title=mysql_result($r,0,1);
			if ($cid==$c)
				$l=mysql_result($r,0,1).$l;
			else
				$l="<a class=bold href=./?c=".$id.">".$title."</a> » ".$l;
			$cid=mysql_result($r,0,0);
			}
		else $cid=0;
		} while ($cid!=0);
	$r=mysql_query("SELECT name FROM ".$db["prefix"]."cat WHERE cid='$c';") or die(mysql_error());
	if (mysql_num_rows($r)!=0) $title=mysql_result($r,0,0)." / ".$CATNAME;
	else $title=$CATNAME;

$template=$TMPL["bmenu"];
	$template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template);
	$template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template);
	$template=str_replace("%MAINTEXT",$LANG["main"],$template);
	print $template;

$template=$TMPL["brokenscript"];
	$template=str_replace("%YESTEXT",$LANG["yes"],$template);
	$template=str_replace("%NOTEXT",$LANG["no"],$template);
	$template=str_replace("%BROKENSURETEXT",$LANG["brokensure"],$template);
	print $template;

$sform=$TMPL["searchform"];
	$sform=str_replace("%SEARCHTEXT",$LANG["search"],$sform);
	$sform=str_replace("%QUERYTEXT",$q,$sform);
	print $sform;
	
	$template=$TMPL["catname"];
	$template=str_replace("%MAINTEXT",$CATNAME,$template);
	$template=str_replace("%OTHERTEXT",$l,$template);
	print $template;

ShowParts($c);

if (intval($c)==0 && $cat["shownew"]==1) {
		if ($o==0) $sortbypop="".$LANG["popuarity"].""; else $sortbypop="<a href=./?o=0&c=$c>".$LANG["popuarity"]."</a>";
		if ($o==1) $sortbytitle="".$LANG["title"].""; else $sortbytitle="<a href=./?o=1&c=$c>".$LANG["title"]."</a>";
		if ($o==2) $sortbymoder="".$LANG["modervote"].""; else $sortbymoder="<a href=./?o=2&c=$c>".$LANG["modervote"]."</a>";
		if ($o==3) $sortbyin="".$LANG["sortbyin"].""; else $sortbyin="<a href=./?o=3&c=$c>".$LANG["sortbyin"]."</a>";

$template=$TMPL["sortby"];
		$template=str_replace("%SORTBYPOP",$sortbypop,$template);
		$template=str_replace("%SORTBYTITLE",$sortbytitle,$template);
		$template=str_replace("%SORTBYMODER",$sortbymoder,$template);
		$template=str_replace("%SORTBYIN",$sortbyin,$template);
		$template=str_replace("%SORTBYTEXT",$LANG["sortby"],$template);
		print $template;

$newlinkstop=$TMPL["newlinkstop"];
		$newlinkstop=str_replace("%NEWLINKSTEXT",$LANG["newlinks"],$newlinkstop);
		print $newlinkstop;
		$r=mysql_query("SELECT lid,title,description,resfield1,resfield2,resfield3 FROM ".$db["prefix"]."main WHERE type=1 ORDER by lid DESC LIMIT ".$cat["shownewcount"].";");
		while ($ar=mysql_fetch_array($r)) {
			if (strlen($ar["description"])>75) $ar["description75"]=substr($ar["description"],0,75)."..."; else $ar["description75"]=$ar["description"];

$template=$TMPL["newlinkstbit"];
			$template=str_replace("%ID",$ar["lid"],$template);
			$template=str_replace("%TITLE",$ar["title"],$template);
			$template=str_replace("%GIN",$ar["gin"],$template);
			$template=str_replace("%GOUT",$ar["gout"],$template);
			$template=str_replace("%MODERVOTE",$ar["moder_vote"],$template);
			$template=str_replace("%DESC75",$ar["description75"],$template);
			$template=str_replace("%DESC",$ar["description"],$template);
			$template=str_replace("%URL",$ar["url"],$template);
			$template=str_replace("%RESFIELD1",$ar["resfield1"],$template);
			$template=str_replace("%RESFIELD2",$ar["resfield2"],$template);
			$template=str_replace("%RESFIELD3",$ar["resfield3"],$template);
			print $template;
			}
		print $TMPL["newlinkstbottom"];
		}

if ($cat["linksatmain"]==1 || $c!=0) {
		print $TMPL["linkstop"]; 
		ShowCat($c,1);
		print str_replace("%NUM",(1+$start),$TMPL["linksmiddle"]);
		$total=ShowCat($c);
		print $TMPL["linksbottom"];
		}

$template=$TMPL["bmenu"];
$template=str_replace("%MODERATORSTEXT",$LANG["moderators"],$template);
$template=str_replace("%ADDLINKTEXT",$LANG["addlink"],$template);
$template=str_replace("%MAINTEXT",$LANG["main"],$template);
print $template;

</channel>
</rss>

Můžete si ověřit, že zmiňovaný postup funguje. Na adrese http://kotrla.com/frogman/rss.php je RSS výstup používaný katalogem Potápěč. Výstup je dokonce i validní, jak se lze přesvědčit pomocí http://rss.scripting.com/?url=http%3A%2F%2Fkotrla.com%2Ffrogman%2Frss.php

Pokud nevíte jak a k čemu RSS použít, tak si můžete přečíst můj starčí příspěvek na http://kotrla.com/pmpro/more.php?id=A7_0_1_0_M

CNCAT hacks

Tato stránka je věnována scriptu pro vytváření katalogu odkazů, který můžete získat na adrese http://www.cn-software.com. Do verze 2.1 byl skript poskytován bezplatně.

Jak zprovoznit RSS?

Čeština pro CnCat

Jak zprovoznit postranní lištu pro Operu?

Jak zprovoznit postranní lištu pro Mozillu?

Jak zprovoznit RSS?

Čeština pro CnCat

Jak zprovoznit postranní lištu pro Operu?

Jak zprovoznit postranní lištu pro Mozillu?