Etiket Tags Kurulum
Forum,sayfa,liste,index tags etiket sistemi cotonti version
Bu Sitede Kullandşgşm Etiket Sistemidir..
Kuruluma Başlşyoruz.
///////////////////////////////////////////////////////////
Datas/config.php yi aşşn Alttakini bulun
Kod:
$db_auth = 'sed_auth';
şstşne Ekleyin.
Kod:
$db_tag_references = 'sed_tag_references';
$db_tags = 'sed_tags';
/////////////////////////////////////////////////////////
system/fonksiyon.php yi aşşn En altşna inin
ş> şstşne ekleyin Alttakileri
Kod:
/*
* ===================================== Tags API ==========================================
*/
function sed_tag($tag, $item, $area = 'pages')
{
global $db_tag_references;
$item = (int) $item;
if(sed_tag_isset($tag, $item, $area))
{
return false;
}
sed_sql_query("INSERT INTO $db_tag_references VALUES('$tag', $item, '$area')");
sed_tag_register($tag);
return true;
}
function sed_tag_cloud($area = 'all', $order = 'tag', $limit = null)
{
global $db_tag_references;
$res = array();
$limit = is_null($limit) ş '' : ' LIMIT ' . $limit;
switch($order)
{
case 'Alphabetical':
$order = '`tag`';
break;
case 'Frequency':
$order = '`cnt` DESC';
break;
default:
$order = 'RAND()';
}
$where = $area == 'all' ş '' : "WHERE tag_area = '$area'";
$sql = sed_sql_query("SELECT `tag`, COUNT(*) AS `cnt`
FROM $db_tag_references
$where
GROUP BY `tag`
ORDER BY $order $limit");
while($row = sed_sql_fetchassoc($sql))
{
$res[$row['tag']] = $row['cnt'];
}
sed_sql_freeresult($sql);
return $res;
}
function sed_tag_complete($tag, $min_length = 3)
{
global $db_tags;
if(mb_strlen($tag) < $min_length)
{
return false;
}
$res = array();
$sql = sed_sql_query("SELECT `tag` FROM $db_tags WHERE `tag` LIKE '$tag%'");
while($row = sed_sql_fetchassoc($sql))
{
$res[] = $row['tag'];
}
sed_sql_freeresult($sql);
return $res;
}
function sed_tag_count($tag, $area = '')
{
global $db_tag_references;
$query = "SELECT COUNT(*) FROM $db_tag_references WHERE `tag` = '$tag'";
if(!empty($area))
{
$query .= " AND tag_area = '$area'";
}
return (int) sed_sql_result(sed_sql_query($query), 0, 0);
}
function sed_tag_exists($tag)
{
global $db_tags;
return sed_sql_result(sed_sql_query("SELECT COUNT(*) FROM $db_tags WHERE `tag` = '$tag'"), 0, 0) == 1;
}
function sed_tag_isset($tag, $item, $area = 'pages')
{
global $db_tag_references;
$item = (int) $item;
$sql = sed_sql_query("SELECT COUNT(*) FROM $db_tag_references WHERE `tag` = '$tag' AND tag_item = $item AND tag_area = '$area'");
return sed_sql_result($sql, 0, 0) == 1;
}
function sed_tag_list($item, $area = 'pages')
{
global $db_tag_references;
$res = array();
$sql = sed_sql_query("SELECT `tag` FROM $db_tag_references WHERE tag_item = $item AND tag_area = '$area'");
while($row = sed_sql_fetchassoc($sql))
{
$res[] = $row['tag'];
}
sed_sql_freeresult($sql);
return $res;
}
function sed_tag_parse($input)
{
$res = array();
$invalid = array('`', '^', ':', 'ş', '=', '|', '\\', '/', '"', "\t", "\r\n", "\n");
$tags = explode(',', $input);
foreach($tags as $tag)
{
$tag = str_replace($invalid, ' ', $tag);
$tag = preg_replace('#\s\s+#', ' ', $tag);
$tag = trim($tag);
if(!empty($tag))
{
$res[] = sed_tag_prep($tag);
}
}
$res = array_unique($res);
return $res;
}
function sed_tag_prep($tag)
{
return sed_sql_prep(mb_strtolower($tag));
}
function sed_tag_register($tag)
{
global $db_tags;
sed_sql_query("INSERT IGNORE INTO $db_tags VALUES('$tag')");
}
function sed_tag_remove($tag, $item, $area = 'pages')
{
global $db_tag_references;
if(sed_tag_isset($tag, $item, $area))
{
sed_sql_query("DELETE FROM $db_tag_references WHERE `tag` = '$tag' AND tag_item = $item AND tag_area = '$area'");
return true;
}
return false;
}
function sed_tag_remove_all($item = 0, $area = 'pages')
{
global $db_tag_references;
if($item == 0)
{
sed_sql_query("DELETE FROM $db_tag_references WHERE tag_area = '$area'");
}
else
{
sed_sql_query("DELETE FROM $db_tag_references WHERE tag_item = $item AND tag_area = '$area'");
}
return sed_sql_affectedrows();
}
function sed_tag_title($tag)
{
return mb_convert_case($tag, MB_CASE_TITLE);
}
function sed_tag_unregister($tag)
{
global $db_tags;
sed_sql_query("DELETE FROM $db_tags WHERE `tag` = '$tag'");
}
/*
* ==========================================================================
*/
de]
///////////////////////////////////////////////////////////////////////////
şimdi Tema Dşzenlemesi yapalşm..
///////////////// Forum Başlşyor /////////////////
forums.editpost.tpl yi aşşm alttakini bulun
Kod:
<table class="cells">
<tr>
<td>
<div style="width:96%;">{FORUMS_EDITPOST_TEXTBOXER}</div>
</td>
</tr>
Altşna Ekleyin.
Kod:
<!-- BEGIN: FORUMS_EDITPOST_TAGS --> <tr> <td>{FORUMS_EDITPOST_TOP_TAGS}: {FORUMS_EDITPOST_FORM_TAGS} ({FORUMS_EDITPOST_TOP_TAGS_HINT})</td> </tr>
<!-- END: FORUMS_EDITPOST_TAGS -->
forums.newtopic.tpl yi aşşn alttakini bulun
Kod:
<tr>
<td>
<div style="width:96%;">{FORUMS_NEWTOPIC_TEXTBOXER}</div>
</td>
</tr>
Altşna Ekleyin
Kod:
<!-- BEGIN: FORUMS_NEWTOPIC_TAGS -->
<tr> <td>
{FORUMS_NEWTOPIC_TOP_TAGS}: {FORUMS_NEWTOPIC_FORM_TAGS} ({FORUMS_NEWTOPIC_TOP_TAGS_HINT})
</td> </tr>
<!-- END: FORUMS_NEWTOPIC_TAGS -->
forums.topics.tpl yi aşşn alttakini bulun
Kod:
<td class="{FORUMS_TOPICS_ROW_ODDEVEN}">
<strong><a href="{FORUMS_TOPICS_ROW_URL}">{FORUMS_TOPICS_ROW_TITLE}</a></strong><br />
<span class="desc">{FORUMS_TOPICS_ROW_DESC} {FORUMS_TOPICS_ROW_PAGES}</span>
</td>
Alttakiyle Degiştirin
<td class="{FORUMS_TOPICS_ROW_ODDEVEN}">
<strong><a href="{FORUMS_TOPICS_ROW_URL}">{FORUMS_TOPICS_ROW_TITLE}</a></strong><br />
<span class="desc">{FORUMS_TOPICS_ROW_DESC} {FORUMS_TOPICS_ROW_PAGES}</span>{FORUMS_TOPICS_ROW_TAGS}
</td>
]
forums.sections.tpl yi aşşn Alttakini bulun
Kod:
</div>
<!-- END: MAIN -->
şstşne Ekleyin
Kod:
{FORUMS_SECTIONS_TAG_CLOUD},{FORUMS_SECTIONS_TOP_TAG_CLOUD}
///////////// Forum Bitti /////////////////////
///////// Sayfalar Pages //////////////////////
Page.tpl yi aşşn Alttakini bulun
Kod:
<!-- END: PAGE_MULTI -->
Altşna Ekleyin
Kod:
<div class="block">
<strong>{PHP.L.Tags}:</strong>
<!-- BEGIN: PAGE_TAGS_ROW -->
<a href="{PAGE_TAGS_ROW_URL}">{PAGE_TAGS_ROW_TAG}</a>
<!-- END: PAGE_TAGS_ROW -->
<!-- BEGIN: PAGE_NO_TAGS -->
{PAGE_NO_TAGS}
<!-- END: PAGE_NO_TAGS --> </div>
page.add.tpl yi aşşn alttakini bulun
Kod:
<tr>
<td>{PHP.skinlang.pageadd.Alias}</td>
<td>{PAGEADD_FORM_ALIAS}</td>
</tr>
Altşna Ekleyin
Kod:
<!-- BEGIN: TAGS -->
<tr>
<td>{PAGEADD_TOP_TAGS}:</td>
<td>{PAGEADD_FORM_TAGS} ({PAGEADD_TOP_TAGS_HINT})</td>
</tr>
<!-- END: TAGS -->
page.edit.tpl yi aşşn lttakini bulun
Kod:
<tr>
<td>{PHP.skinlang.pageedit.Alias}</td>
<td>{PAGEEDIT_FORM_ALIAS}</td>
</tr>
Altşna Ekleyin
Kod:
<!-- BEGIN: TAGS -->
<tr>
<td>{PAGEEDIT_TOP_TAGS}:</td>
<td>{PAGEEDIT_FORM_TAGS} ({PAGEEDIT_TOP_TAGS_HINT})</td>
</tr>
<!-- END: TAGS -->
///////////// Sayfa şşlemleri bitti //////////////////////////
list.tpl yi aşşn alttakini bulun
Kod:
</div>
<!-- END: MAIN -->
şstşne Ekleyin
Kod:
<h4>{LIST_TOP_TAG_CLOUD}</h4>
<div class="block">
{LIST_TAG_CLOUD}
</div>
index.tpl yi aşşn istedişiniz yere alttakieri ekleyin
Kod:
<div class="rboxHD">{INDEX_TOP_TAG_CLOUD} :</div>
<div class="rboxBody">{INDEX_TAG_CLOUD}</div>
şrnek Resimler Dosya işerisinde Mevcut.
şnemli not: Bir sayfayş veya konuyu silmeden şnce etiketlerini silmeniz gerekmektedir.
Aksi halde etiketler kalşyor ve tşklandşgşnda hata veriyor.
Bu konuda dikkat etmenizi tavsiye ederim.
Sql.txt dosyasşndakileri phpmyadmin sayfasşndan import ediniz.
Sql yi import ederken tek tek yşkleyiniz.
Kurulum şşlemi bitmiştir..
Eklentiden doşabilecek sorunlardan kesinlikle sitemiz sorumlu deşildir..
1.
