<?php

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/similar/similar.php
Version=0.99
Updated=18-jan-2007
Type=Plugin
Author=Raveex
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=similar
Part=main
File=similar.main
Hooks=page.tags
Tags=page.tpl:{SIMILAR_PAGES}
Order=1
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

$relev = $cfg['plugin']['similar']['relev'];
$limit = $cfg['plugin']['similar']['max_sim'];

$sql_sim = sed_sql_query("SELECT p.*, u.user_name FROM $db_pages AS p LEFT JOIN $db_users AS u ON u.user_id=p.page_ownerid WHERE (p.page_state='0' OR p.page_state='2') AND p.page_id != $pag[page_id] AND MATCH (page_title) AGAINST ('$pag[page_title]')>$relev LIMIT $limit");

$i=1;
$plugin_out = "<table width=\"100%\" class=\"cells\">\n";
$plugin_out .= "<tr><td width=\"8\" align=center>#</td><td align=center>Çàãîëîâîê</td><td align=center>Àâòîğ</td><td align=center>Ğàçäåë</td><td align=center>Ïğîñìîòğîâ</td><td align=center>Äàòà</td></tr>\n";
if (sed_sql_numrows($sql_sim)==0)
    {
            $plugin_out .= "<tr><td colspan=\"6\">Íåò Ïîõîæèõ Ñòğàíèö</td></tr>";
    }
while ($row = sed_sql_fetcharray($sql_sim))
       {
               $row['page_pageurl'] = (empty($row['page_alias'])) ? "page.php?id=".$row['page_id'] : "page.php?al=".$row['page_alias'];
               $plugin_out .= "<tr><td>$i</td><td><a href=\"$row[page_pageurl]\">$row[page_title]</a></td><td align=center>".sed_build_user($row['page_ownerid'], sed_cc($row['user_name']))."</td><td>".sed_build_catpath($row['page_cat'], "<a href=\"list.php?c=%1\$s\">%2\$s</a>")."</td><td align=center>$row[page_count]</td><td align=center>".date($cfg['dateformat'], $row['page_date'] + $usr['timezone'] * 3600)."</td></tr>\n";
               $i++;
       }
$plugin_out .= "</table>";

$t->assign("SIMILAR_PAGES", $plugin_out);

?>

<?php

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/similar/similar.query.php
Version=0.99
Updated=18-jan-2007
Type=Plugin
Author=Raveex
Description=
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=similar
Part=query
File=similar.query
Hooks=standalone
Tags=
Order=1
[END_SED_EXTPLUGIN]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

$sql_tmp = sed_sql_query("SELECT config_value FROM $db_config WHERE config_name = 'fulltext' LIMIT 2");

if (sed_sql_numrows($sql_tmp)>0)
    {
            echo "Benzer sayfa yok";
    }
else
    {
            $sql_tmp = sed_sql_query("ALTER TABLE $db_pages ADD FULLTEXT(page_title)");
            $sql_tmp = sed_sql_query("INSERT INTO $db_config (config_owner, config_cat, config_order, config_name, config_type, config_value, config_default, config_text) VALUES ('Raveex', 'Raveex', '1', 'fulltext', '1', '1', '1', 'Raveex')");
    }
?>

<?php

/* ====================
Seditio - Website engine
Copyright Neocrome
http://www.neocrome.net

[BEGIN_SED]
File=plugins/similar/similar.setup.php
Version=0.99
Updated=18-jan-2007
Type=Plugin
Author=Raveex
Description=Similar Pages
[END_SED]

[BEGIN_SED_EXTPLUGIN]
Code=similar
Name=Similar Pages
Description=Ïëàãèí "Ïîõîæèå ñòğàíèöû"! Äëÿ àêòèâàöèè îáÿçàòåëüíî çàéäèòå â ïëóã!
Version=0.99
Date=18-jan-2007
Author=Raveex
Copyright=Âñå ïğàâûå â ğåçåğâå!
Notes=Created by Raveex - www.NovaMobile.net
SQL=
Auth_guests=R
Lock_guests=W12345A
Auth_members=R
Lock_members=W12345A
[END_SED_EXTPLUGIN]

[BEGIN_SED_EXTPLUGIN_CONFIG]
max_sim=01:select:1,2,3,4,5,6,7,8,9,10:5:Ìàêñ. Êîë-âî ïîõîæèõ ñòğàíèö äëÿ âûâîäà
relev=02:select:0,1,2,3,4,5:2:Æåñòêîñòü ğåëåâàíòíîñòè
[END_SED_EXTPLUGIN_CONFIG]
==================== */

if (!defined('SED_CODE')) { die('Wrong URL.'); }

?>