| Author | Message |
inzar
124 posts |
#2805 2007-05-25 21:47 GMT |
|
dvdbil sorum aramada portaldaki arama bloku ona bir kelime yazıyorum şonuçlerı vermiyor benim şimdi ben seditio v120 deki arama puginsini kullanıyorum şuan kullanıdğım sürüm v121 aşağıda kodlarınıda veriyorum istersen bi bak benim istediğim portalda aram kısmına kelime girdiğimde direk şonuçları vermesi Code: <center><div class="cb_small_title">Arama</div></center>
<div class="cb_main"><br> <center><form id="ssearch" action="plug.php?e=search&a=search" method="post"> <input type="text" class="text" name="sq" value="ara..." size="15" onBlur="if(this.value=='') this.value='search...';" onFocus="if(this.value=='search...') this.value='';" maxlength="32" /> <input type="submit" class="submit" value="{PHP.skinlang.btn_search}" alt ="" /> <input type="hidden" name="searchin_frm" value="1" /> <input type="hidden" name="frm_sub[]" value="9999"/> <input type="hidden" name="searchin_pag" value="1" /> <input type="hidden" name="pag_sub[]" value="all" /> <input type="hidden" name="searchin_use" value="1" /> </form> <center><a href="plug.php?e=search">{PHP.skinlang.advanced_search}</a> </div> <div class="cb_footer"> </div> |
|
Dvdbil
2,232 posts |
#2808 2007-05-25 23:51 GMT |
|
Code: <center><div class="cb_small_title">Arama</div></center>
<div class="cb_main"><br> <center> <form id="search" action="plug.php?e=search&a=search" method="post" /> <input onblur="if (value == '') {value = 'Ara...'}" onfocus="if (value == 'Ara...') {value =''}" type="text" class="text" name="sq" value="Ara..." size="16" maxlength="32" /> <input type="submit" value="Ara"> <input type="hidden" name="searchin_frm" value="1" /> <input type="hidden" name="frm_sub[]" value="9999" /> <input type="hidden" name="searchin_pag" value="1" /> <input type="hidden" name="pag_sub[]" value="all" /> <input type="hidden" name="searchin_use" value="1" /> </form> <center><a href="plug.php?e=search">{PHP.skinlang.advanced_search}</a> </div> <div class="cb_footer"> </div> |
|
|
Sitelerinize profesyonel anlamda hizmet verilir;
- Performans optimizasyonu, - Üst düzey güvenlik yamaları, - İsteğe bağlı eklentiler, - Her çeşit bot (program, video, resim, arsiv, haber), - Profesyonel görsel skin. Tüm tasarım, kodlamalar ve optimizasyon Neocrome referansı ile tarafımca hazırlanmakta. *************************İSTATİSTİKLER************************* Müşterim olan danışmanlığını yaptığım toplam kişi sayısı: 23 Sadece Eklenti hazırladığım kişi sayısı: 21 Uygulama yaptığım toplam site sayısı: 38 ------------------------------------------------- Müşterinin isteği doğrultusunda hazırladığım; - eklenti sayısı: 44 - skin sayısı: 8 - bot sayısı: 15 - özel güvenlik yamaları: 21 - Sql performans optimizasyonu: 13 (yüksek hitli siteler için) - Portal genel cache ve materyal optimizasyonu: 15 *************************************************************** |
|
inzar
124 posts |
#2813 2007-05-26 06:32 GMT |
|
dvdbil yine aynı portalda arama butonuna bastığımda şonuçlar çıkacağına böyle bir şey çıkıyo eğer gerekiyosa arama kodlarını verdim  Code: <?PHP
/* ==================== Seditio - Website engine Copyright Neocrome http://www.neocrome.net [BEGIN_SED] File=plugins/search/search.php Version=120 Updated=2007-mar-8 Type=Plugin Author=Olivier C. & Spartan Description= [END_SED] [BEGIN_SED_EXTPLUGIN] Code=search Part=main File=search Hooks=standalone Tags= Order=10 [END_SED_EXTPLUGIN] ==================== */ if (!defined('SED_CODE') || !defined('SED_PLUG')) { die('Wrong URL.'); } /* === EDIT THE FOLLOWING === */ $cfg_maxwords = 5; $cfg_maxwords_frm = 5; $cfg_maxwords_pag = 5; $cfg_maxitems = 50; /* === DO NOT EDIT THE FOLLOWING === */ $sq = sed_import('sq','P','TXT'); $pre = sed_import('pre','G','TXT'); $a = sed_import('a','G','TXT'); $tab = sed_import('tab','G','TXT'); $frm = sed_import('frm','G','BOL'); if ($frm) { $tab='frm'; } /* === FORUM TAB === */ if ($tab=='frm') { $sea_frmtitle = sed_import('sea_frmtitle','P','INT'); $sea_frmtext = sed_import('sea_frmtext','P','INT'); $sea_frmreply = sed_import('sea_frmreply','P','INT'); $sea_frmtime = sed_import('sea_frmtime','P','INT'); $sea_frmtime2 = sed_import('sea_frmtime2','P','TXT'); $sea_frmsort = sed_import('sea_frmsort','P','INT'); $sea_frmsort2 = sed_import('sea_frmsort2','P','TXT'); $sq = (!empty($pre)) ? $pre : $sq; $plugin_title = $L['plu_title_frmtab']; $plugin_subtitle .= "[ <a href=\"plug.php?e=search\">".$L['plu_tabs_all']."</a> ] [ <b>".$L['plu_tabs_frm']."</b> ] [ <a href=\"plug.php?e=search&tab=pag\">".$L['plu_tabs_pag']."</a> ]"; $plugin_subtitle .= "<br>".$L['plu_title_frmtab_s']; $plugin_body .= "<form id=\"search\" action=\"plug.php?e=search&tab=frm&a=search\" method=\"post\">"; $plugin_body .= "<table class=\"cells\">"; $plugin_body .= "<tr><td width=\"20%\">".$L['plu_searchin1']."</td>"; $plugin_body .= "<td width=\"80%\"><input type=\"text\" class=\"text\" name=\"sq\" value=\"".sed_cc($sq)."\" size=\"16\" maxlength=\"32\" />".$L['plu_searchin2']."</td></tr>"; if (!$cfg['disable_forums']) { $sql1 = sed_sql_query("SELECT s.fs_id, s.fs_title, s.fs_category FROM $db_forum_sections AS s LEFT JOIN $db_forum_structure AS n ON n.fn_code=s.fs_category ORDER by fn_path ASC, fs_order ASC"); $plugin_body .= "<tr><td>"; $plugin_body .= $L['Forums']."<br />".$L['plu_frm_hint']."</td><td><select multiple name=\"frm_sub[]\" size=\"5\">"; $plugin_body .= "<option value=\"9999\" selected=\"selected\">".$L['plu_allsections']."</option>"; while ($row1 = mysql_fetch_array($sql1)) { if (sed_auth('forums', $row1['fs_id'], 'R')) { $plugin_body .= "<option value=\"".$row1['fs_id']."\">".sed_build_forums($row1['fs_id'], $row1['fs_title'], $row1['fs_category'], FALSE)."</option>"; } } $plugin_body .= "</select></td></tr>"; $plugin_body .= "<tr><td>".$L['plu_searchin']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_frmtitle\" checked=\"checked\" value=\"1\" />Title<input type=\"checkbox\" class=\"checkbox\" name=\"sea_frmtext\" checked=\"checked\" value=\"1\" />Post</td></tr>"; $plugin_body .= "<tr><td>".$L['plu_frm_rep']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_frmreply\" value=\"1\" /></td></tr>"; $plugin_body .= "<tr><td>Find results from</td><td><select name=\"sea_frmtime\"><option value=\"86400\">A day ago</option>"; $plugin_body .= "<option value=\"604800\">A week ago</option>"; $plugin_body .= "<option value=\"1209600\">2 weeks ago</option>"; $plugin_body .= "<option value=\"2419200\">A month ago</option>"; $plugin_body .= "<option value=\"7257600\">3 months ago</option>"; $plugin_body .= "<option value=\"14515200\">6 months ago</option>"; $plugin_body .= "<option value=\"29030400\">A year ago</option>"; $plugin_body .= "<option value=\"999999999\" selected=\"selected\">Any date</option>"; $plugin_body .= "</select><select name=\"sea_frmtime2\">"; $plugin_body .= "<option value=\"new\" select=\"selected\">And newer</option>"; $plugin_body .= "<option value=\"old\">And older</option></select></td></tr>"; $plugin_body .= "<tr><td>Sort results by</td><td><select name=\"sea_frmsort\"><option value=\"1\" selected=\"selected\">Last updated</option>"; $plugin_body .= "<option value=\"2\">Creation date</option>"; $plugin_body .= "<option value=\"3\">Title</option>"; $plugin_body .= "<option value=\"4\">Number of replies</option>"; $plugin_body .= "<option value=\"5\">Number of views</option>"; $plugin_body .= "</select><select name=\"sea_frmsort2\">"; $plugin_body .= "<option value=\"DESC\" select=\"selected\">Descending</option>"; $plugin_body .= "<option value=\"ASC\">Ascending</option></select></td></tr>"; $plugin_body .= "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" class=\"submit\" value=\"".$L['Search']."\" /></td></tr>"; } $plugin_body .= "</table></form>"; if ($a=='search') { if (strlen($sq)<3) { $plugin_body .= "<p>".$L['plu_querytooshort']."</p>"; $a = ''; } $sq = sed_sql_prep($sq); $words = explode(" ", $sq); $words_count = count($words); if ($words_count > $cfg_maxwords_frm) { $plugin_body .= "<p>".$L['plu_toomanywords']." ".$cfg_maxwords_frm."</p>"; $a = ''; } $sqlsearch = implode("%", $words); $sqlsearch = "%".$sqlsearch."%"; if (!$cfg['disable_forums']) { $frm_sub = sed_import('frm_sub','P','ARR'); if ($frm_sub[0]==9999) { $sqlsections = ''; } else { foreach($frm_sub as $i => $k) { $sections1[] = "s.fs_id='".$k."'"; } $sqlsections = "AND (".implode(' OR ', $sections1).")"; } if ($sea_frmreply=='1') { $frm_reply = "AND t.ft_postcount>1"; } if ($sea_frmtime2=='new') { $sqlsections2 = "AND t.ft_updated>(".$sys['now_offset']."-".$sea_frmtime.")"; } elseif ($sea_frmtime2=='old') { $sqlsections2 = "AND t.ft_updated<(".$sys['now_offset']."-".$sea_frmtime.")"; } if ($sea_frmsort=='1') { $orderby = "ft_updated ".$sea_frmsort2; } elseif ($sea_frmsort=='2') { $orderby = "ft_creationdate ".$sea_frmsort2; } elseif ($sea_frmsort=='3') { $orderby = "ft_title ".$sea_frmsort2; } elseif ($sea_frmsort=='4') { $orderby = "ft_postcount ".$sea_frmsort2; } elseif ($sea_frmsort=='5') { $orderby = "ft_viewcount ".$sea_frmsort2; } if ($sea_frmtitle=='1' && $sea_frmtext!='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (t.ft_title LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id $frm_reply AND p.fp_sectionid=s.fs_id $sqlsections $sqlsections2 GROUP BY t.ft_id ORDER BY $orderby LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } elseif ($sea_frmtext=='1' && $sea_frmtitle!='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id $frm_reply AND p.fp_sectionid=s.fs_id $sqlsections $sqlsections2 GROUP BY t.ft_id ORDER BY $orderby LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } elseif ($sea_frmtext=='1' && $sea_frmtitle=='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".sed_sql_prep($sqlsearch)."' OR t.ft_title LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id $frm_reply AND p.fp_sectionid=s.fs_id $sqlsections $sqlsections2 GROUP BY t.ft_id ORDER BY $orderby LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } else { $plugin_body .= "<p>blahbla</p>"; $a = ''; $items = "0"; } if ($items!='0') { $plugin_body .= "<h4>".$L['Forums']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>"; $plugin_body .= "<table class=\"cells\" width=\"100%\"><tr><td width=\"30%\">".$L['plu_fs']."</td><td width=\"60%\">".$L['plu_ft']."</td><td width=\"10%\">".$L['plu_fo']."</td></tr>"; while ($row = mysql_fetch_array($sql)) { if (sed_auth('forums', $row['fs_id'], 'R')) { $plugin_body .= "<tr><td>".sed_build_forums($row['fs_id'], $row['fs_title'], $row['fs_category'], TRUE)."</td><td><a href=\"forums.php?m=posts&p=".$row['fp_id']."#".$row['fp_id']."\">".sed_cc($row['ft_title'])."</a></td><td>".sed_build_user($row['ft_firstposterid'],$row['ft_firstpostername'])."</td></tr>"; } } $plugin_body .= "</table>"; $sections++; } } } /* === PAGE TAB === */ } elseif ($tab=='pag') { $sea_pagtitle = sed_import('sea_pagtitle','P','INT'); $sea_pagdesc = sed_import('sea_pagdesc','P','INT'); $sea_pagtext = sed_import('sea_pagtext','P','INT'); $sea_pagfile = sed_import('sea_pagfile','P','INT'); $sea_pagtime = sed_import('sea_pagtime','P','INT'); $sea_pagtime2 = sed_import('sea_pagtime2','P','TXT'); $sea_pagsort = sed_import('sea_pagsort','P','INT'); $sea_pagsort2 = sed_import('sea_pagsort2','P','TXT'); $sq = (!empty($pre)) ? $pre : $sq; $plugin_title = $L['plu_title_pagtab']; $plugin_subtitle .= "[ <a href=\"plug.php?e=search\">".$L['plu_tabs_all']."</a> ] [ <a href=\"plug.php?e=search&tab=frm\">".$L['plu_tabs_frm']."</a> ] [ <b>".$L['plu_tabs_pag']."</b> ]"; $plugin_subtitle .= "<br>".$L['plu_title_pagtab_s']; $plugin_body .= "<form id=\"search\" action=\"plug.php?e=search&tab=pag&a=search\" method=\"post\">"; $plugin_body .= "<table class=\"cells\">"; $plugin_body .= "<tr><td width=\"20%\">".$L['plu_searchin1']."</td>"; $plugin_body .= "<td width=\"80%\"><input type=\"text\" class=\"text\" name=\"sq\" value=\"".sed_cc($sq)."\" size=\"16\" maxlength=\"32\" />".$L['plu_searchin2']."</td></tr>"; if (!$cfg['disable_page']) { $plugin_body .= "<tr><td>"; $plugin_body .= $L['Pages']."<br />".$L['plu_pag_hint']."</td><td><select multiple name=\"pag_sub[]\" size=\"5\">"; $plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>"; foreach ($sed_cat as $i =>$x) { if ($i!='all' && $i!='system' && sed_auth('page', $i, 'R')) { $selected = ($i == $check) ? "selected=\"selected\"" : ''; $plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>"; } } $plugin_body .= "</select></td></tr>"; $plugin_body .= "<tr><td>".$L['plu_searchin']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagtitle\" checked=\"checked\" value=\"1\" />Title<input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagdesc\" checked=\"checked\" value=\"1\" />Description<input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagtext\" checked=\"checked\" value=\"1\" />Body</td></tr>"; $plugin_body .= "<tr><td>".$L['plu_pag_fil']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagfile\" value=\"1\" /></td></tr>"; $plugin_body .= "<tr><td>Find results from</td><td><select name=\"sea_pagtime\"><option value=\"86400\">A day ago</option>"; $plugin_body .= "<option value=\"604800\">A week ago</option>"; $plugin_body .= "<option value=\"1209600\">2 weeks ago</option>"; $plugin_body .= "<option value=\"2419200\">A month ago</option>"; $plugin_body .= "<option value=\"7257600\">3 months ago</option>"; $plugin_body .= "<option value=\"14515200\">6 months ago</option>"; $plugin_body .= "<option value=\"29030400\">A year ago</option>"; $plugin_body .= "<option value=\"999999999\" selected=\"selected\">Any date</option>"; $plugin_body .= "</select><select name=\"sea_pagtime2\">"; $plugin_body .= "<option value=\"new\" select=\"selected\">And newer</option>"; $plugin_body .= "<option value=\"old\">And older</option></select></td></tr>"; $plugin_body .= "<tr><td>Sort results by</td><td><select name=\"sea_pagsort\"><option value=\"1\" selected=\"selected\">Creation date</option>"; $plugin_body .= "<option value=\"2\">Title</option>"; $plugin_body .= "<option value=\"3\">Number of views</option>"; $plugin_body .= "</select><select name=\"sea_pagsort2\">"; $plugin_body .= "<option value=\"DESC\" select=\"selected\">Descending</option>"; $plugin_body .= "<option value=\"ASC\">Ascending</option></select></td></tr>"; $plugin_body .= "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" class=\"submit\" value=\"".$L['Search']."\" /></td></tr>"; } $plugin_body .= "</table></form>"; if ($a=='search') { if (strlen($sq)<3) { $plugin_body .= "<p>".$L['plu_querytooshort']."</p>"; $a = ''; } $sq = sed_sql_prep($sq); $words = explode(" ", $sq); $words_count = count($words); if ($words_count > $cfg_maxwords_pag) { $plugin_body .= "<p>".$L['plu_toomanywords']." ".$cfg_maxwords_pag."</p>"; $a = ''; } $sqlsearch = implode("%", $words); $sqlsearch = "%".$sqlsearch."%"; if (!$cfg['disable_page']) { $pag_sub = sed_import('pag_sub','P','ARR'); if ($pag_sub[0]=='all') { $sqlsections = ''; } else { $sub = array(); foreach($pag_sub as $i => $k) { $sub[] = "page_cat='".$k."'"; } $sqlsections = "AND (".implode(' OR ', $sub).")"; } if ($sea_pagtitle=='1' && $sea_pagdesc!='1' && $sea_pagtext!='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc=='1' && $sea_pagtext!='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."' OR p.page_desc LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc!='1' && $sea_pagtext=='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc=='1' && $sea_pagtext!='1') { $pagsql = "(p.page_desc LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc=='1' && $sea_pagtext=='1') { $pagsql = "(p.page_desc LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc!='1' && $sea_pagtext=='1') { $pagsql = "(p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc=='1' && $sea_pagtext=='1') { $pagsql = "(p.page_text LIKE '".$sqlsearch."' OR p.page_title LIKE '".$sqlsearch."' OR p.page_desc LIKE '".sed_sql_prep($sqlsearch)."') AND "; } else { $pagsql = ""; $plugin_body .= "<p>blahbla</p>"; $cancel = "1"; } if ($sea_pagtime2=='new') { $sqlsections2 = "AND page_date>(".$sys['now_offset']."-".$sea_pagtime.")"; } elseif ($sea_pagtime2=='old') { $sqlsections2 = "AND page_date<(".$sys['now_offset']."-".$sea_pagtime.")"; } if ($sea_pagsort=='1') { $orderby = "page_date ".$sea_pagsort2; } elseif ($sea_pagsort=='2') { $orderby = "page_title ".$sea_pagsort2; } elseif ($sea_pagsort=='3') { $orderby = "page_count ".$sea_pagsort2; } if ($cancel!='1') { if ($sea_pagfile=='1') { $sql = sed_sql_query("SELECT page_id, page_ownerid, page_title, page_cat from $db_pages p, $db_structure s WHERE $pagsql p.page_file='1' AND p.page_state='0' AND p.page_cat=s.structure_code AND p.page_cat NOT LIKE 'system' $sqlsections2 $sqlsections ORDER by $orderby LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } else { $sql = sed_sql_query("SELECT page_id, page_ownerid, page_title, page_cat from $db_pages p, $db_structure s WHERE $pagsql p.page_state='0' AND p.page_cat=s.structure_code AND p.page_cat NOT LIKE 'system' $sqlsections2 $sqlsections ORDER by $orderby LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } $plugin_body .= "<h4>".$L['Pages']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>"; $plugin_body .= "<table class=\"cells\" width=\"100%\"><tr><td width=\"30%\">".$L['plu_ps']."</td><td width=\"60%\">".$L['plu_pt']."</td><td width=\"10%\">".$L['plu_po']."</td></tr>"; while ($row = mysql_fetch_array($sql)) { if (sed_auth('page', $row['page_cat'], 'R')) { $ownername = sed_sql_fetcharray(sed_sql_query("SELECT user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."'")); $plugin_body .= "<tr><td><a href=\"list.php?c=".$row['page_cat']."\">".$sed_cat[$row['page_cat']]['tpath']."</a></td>"; $plugin_body .= "<td><a href=\"page.php?id=".$row['page_id']."\">"; $plugin_body .= sed_cc($row['page_title'])."</a></td><td>".sed_build_user($row['page_ownerid'],$ownername['user_name'])."</td></tr>"; } } $plugin_body .= "</table>"; $sections++; } } } /* === DEFAULT TAB === */ } else { $sea_frmtitle = sed_import('sea_frmtitle','P','INT'); $sea_frmtext = sed_import('sea_frmtext','P','INT'); $sea_pagtitle = sed_import('sea_pagtitle','P','INT'); $sea_pagdesc = sed_import('sea_pagdesc','P','INT'); $sea_pagtext = sed_import('sea_pagtext','P','INT'); $sq = (!empty($pre)) ? $pre : $sq; $plugin_title = $L['plu_title_alltab']; $plugin_subtitle .= "[ <b>".$L['plu_tabs_all']."</b> ] [ <a href=\"plug.php?e=search&tab=frm\">".$L['plu_tabs_frm']."</a> ] [ <a href=\"plug.php?e=search&tab=pag\">".$L['plu_tabs_pag']."</a> ]"; $plugin_subtitle .= "<br>".$L['plu_title_alltab_s']; $plugin_body .= "<form id=\"search\" action=\"plug.php?e=search&a=search\" method=\"post\">"; $plugin_body .= "<table class=\"cells\">"; $plugin_body .= "<tr><td width=\"20%\">".$L['plu_searchin1']."</td>"; $plugin_body .= "<td width=\"80%\"><input type=\"text\" class=\"text\" name=\"sq\" value=\"".sed_cc($sq)."\" size=\"16\" maxlength=\"32\" />".$L['plu_searchin2']."</td></tr>"; if (!$cfg['disable_forums']) { $sql1 = sed_sql_query("SELECT s.fs_id, s.fs_title, s.fs_category FROM $db_forum_sections AS s LEFT JOIN $db_forum_structure AS n ON n.fn_code=s.fs_category ORDER by fn_path ASC, fs_order ASC"); $plugin_body .= "<tr><td>"; $plugin_body .= $L['Forums']."<br />".$L['plu_frm_hint']."</td><td><select multiple name=\"frm_sub[]\" size=\"5\">"; $plugin_body .= "<option value=\"9999\" selected=\"selected\">".$L['plu_allsections']."</option>"; while ($row1 = mysql_fetch_array($sql1)) { if (sed_auth('forums', $row1['fs_id'], 'R')) { $plugin_body .= "<option value=\"".$row1['fs_id']."\">".sed_build_forums($row1['fs_id'], $row1['fs_title'], $row1['fs_category'], FALSE)."</option>"; } } $plugin_body .= "</select></td></tr>"; $plugin_body .= "<tr><td>".$L['plu_searchin']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_frmtitle\" checked=\"checked\" value=\"1\" />Title<input type=\"checkbox\" class=\"checkbox\" name=\"sea_frmtext\" checked=\"checked\" value=\"1\" />Post</td></tr>"; } if (!$cfg['disable_page']) { $plugin_body .= "<tr><td>"; $plugin_body .= $L['Pages']."<br />".$L['plu_pag_hint']."</td><td><select multiple name=\"pag_sub[]\" size=\"5\">"; $plugin_body .= "<option value=\"all\" selected=\"selected\">".$L['plu_allcategories']."</option>"; foreach ($sed_cat as $i =>$x) { if ($i!='all' && $i!='system' && sed_auth('page', $i, 'R')) { $selected = ($i == $check) ? "selected=\"selected\"" : ''; $plugin_body .= "<option value=\"".$i."\" $selected> ".$x['tpath']."</option>"; } } $plugin_body .= "</select></td></tr>"; $plugin_body .= "<tr><td>".$L['plu_searchin']."</td><td><input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagtitle\" checked=\"checked\" value=\"1\" />Title<input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagdesc\" checked=\"checked\" value=\"1\" />Description<input type=\"checkbox\" class=\"checkbox\" name=\"sea_pagtext\" checked=\"checked\" value=\"1\" />Body</td></tr>"; } $plugin_body .= "<tr><td colspan=\"2\" align=\"center\"><input type=\"submit\" class=\"submit\" value=\"".$L['Search']."\" /></td></tr>"; $plugin_body .= "</table></form>"; if ($a=='search') { if (strlen($sq)<3) { $plugin_body .= "<p>".$L['plu_querytooshort']."</p>"; $a = ''; } $sq = sed_sql_prep($sq); $words = explode(" ", $sq); $words_count = count($words); if ($words_count > $cfg_maxwords) { $plugin_body .= "<p>".$L['plu_toomanywords']." ".$cfg_maxwords."</p>"; $a = ''; } $sqlsearch = implode("%", $words); $sqlsearch = "%".$sqlsearch."%"; if (!$cfg['disable_page']) { $pag_sub = sed_import('pag_sub','P','ARR'); if ($pag_sub[0]=='all') { $sqlsections = ''; } else { $sub = array(); foreach($pag_sub as $i => $k) { $sub[] = "page_cat='".$k."'"; } $sqlsections = "AND (".implode(' OR ', $sub).")"; } if ($sea_pagtitle=='1' && $sea_pagdesc!='1' && $sea_pagtext!='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc=='1' && $sea_pagtext!='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."' OR p.page_desc LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc!='1' && $sea_pagtext=='1') { $pagsql = "(p.page_title LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc=='1' && $sea_pagtext!='1') { $pagsql = "(p.page_desc LIKE '".$sqlsearch."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc=='1' && $sea_pagtext=='1') { $pagsql = "(p.page_desc LIKE '".$sqlsearch."' OR p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle!='1' && $sea_pagdesc!='1' && $sea_pagtext=='1') { $pagsql = "(p.page_text LIKE '".sed_sql_prep($sqlsearch)."') AND "; } elseif ($sea_pagtitle=='1' && $sea_pagdesc=='1' && $sea_pagtext=='1') { $pagsql = "(p.page_text LIKE '".$sqlsearch."' OR p.page_title LIKE '".$sqlsearch."' OR p.page_desc LIKE '".sed_sql_prep($sqlsearch)."') AND "; } else { $pagsql = ""; $plugin_body .= "<p>blahbla</p>"; $cancel = "1"; } if ($cancel!='1') { $sql = sed_sql_query("SELECT page_id, page_ownerid, page_title, page_cat from $db_pages p, $db_structure s WHERE $pagsql p.page_state='0' AND p.page_cat=s.structure_code AND p.page_cat NOT LIKE 'system' $sqlsections ORDER by page_cat ASC, page_title ASC LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); $plugin_body .= "<h4>".$L['Pages']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>"; $plugin_body .= "<table class=\"cells\" width=\"100%\"><tr><td width=\"30%\">".$L['plu_ps']."</td><td width=\"60%\">".$L['plu_pt']."</td><td width=\"10%\">".$L['plu_po']."</td></tr>"; while ($row = mysql_fetch_array($sql)) { if (sed_auth('page', $row['page_cat'], 'R')) { $ownername = sed_sql_fetcharray(sed_sql_query("SELECT user_name FROM $db_users WHERE user_id='".$row['page_ownerid']."'")); $plugin_body .= "<tr><td><a href=\"list.php?c=".$row['page_cat']."\">".$sed_cat[$row['page_cat']]['tpath']."</a></td>"; $plugin_body .= "<td><a href=\"page.php?id=".$row['page_id']."\">"; $plugin_body .= sed_cc($row['page_title'])."</a></td><td>".sed_build_user($row['page_ownerid'],$ownername['user_name'])."</td></tr>"; } } $plugin_body .= "</table>"; $sections++; } } if (!$cfg['disable_forums']) { $frm_sub = sed_import('frm_sub','P','ARR'); if ($frm_sub[0]==9999) { $sqlsections = ''; } else { foreach($frm_sub as $i => $k) { $sections1[] = "s.fs_id='".$k."'"; } $sqlsections = "AND (".implode(' OR ', $sections1).")"; } if ($sea_frmtitle=='1' && $sea_frmtext!='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (t.ft_title LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id AND p.fp_sectionid=s.fs_id $sqlsections GROUP BY t.ft_id ORDER BY fp_id DESC LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } elseif ($sea_frmtext=='1' && $sea_frmtitle!='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id AND p.fp_sectionid=s.fs_id $sqlsections GROUP BY t.ft_id ORDER BY fp_id DESC LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } elseif ($sea_frmtext=='1' && $sea_frmtitle=='1') { $sql = sed_sql_query("SELECT p.fp_id, t.ft_firstposterid, t.ft_firstpostername, t.ft_title, t.ft_id, s.fs_id, s.fs_title, s.fs_category FROM $db_forum_posts p, $db_forum_topics t, $db_forum_sections s WHERE 1 AND (p.fp_text LIKE '".sed_sql_prep($sqlsearch)."' OR t.ft_title LIKE '".sed_sql_prep($sqlsearch)."') AND p.fp_topicid=t.ft_id AND p.fp_sectionid=s.fs_id $sqlsections GROUP BY t.ft_id ORDER BY fp_id DESC LIMIT $cfg_maxitems"); $items = mysql_num_rows($sql); } else { $plugin_body .= "<p>blahbla</p>"; $a = ''; $items = "0"; } if ($items!='0') { $plugin_body .= "<h4>".$L['Forums']." : ".$L['plu_found']." ".$items." ".$L['plu_match']."</h4>"; $plugin_body .= "<table class=\"cells\" width=\"100%\"><tr><td width=\"30%\">".$L['plu_fs']."</td><td width=\"60%\">".$L['plu_ft']."</td><td width=\"10%\">".$L['plu_fo']."</td></tr>"; while ($row = mysql_fetch_array($sql)) { if (sed_auth('forums', $row['fs_id'], 'R')) { $plugin_body .= "<tr><td>".sed_build_forums($row['fs_id'], $row['fs_title'], $row['fs_category'], TRUE)."</td><td><a href=\"forums.php?m=posts&p=".$row['fp_id']."#".$row['fp_id']."\">".sed_cc($row['ft_title'])."</a></td><td>".sed_build_user($row['ft_firstposterid'],$row['ft_firstpostername'])."</td></tr>"; } } $plugin_body .= "</table>"; $sections++; } } } } ?> |
|
Kaan
2,075 posts |
#2820 2007-05-26 10:38 GMT |
|
Plugini degiştir ve aradıgın kelime önemli forumda yoksa cıkmaz.
|
|
inzar
124 posts |
#2833 2007-05-26 16:50 GMT |
|
o resimdeki sitede olan konu ismini girincede aynı oluyo ben bu sorunu öğrenmek istiyorum bakın index.tpl arama kodunu ekledim portalda aramaya basıyorum ama resimdeki çıkıyo ama
''plug.php?e=search'' da aranacak kelime girdiğimde hemen buluyo benim öğrenmek istediğim index.tpl deki verdiğim kodda uyumsuzluk olduğu ve buna uygun bir arama kodu bulunması |
|
Kaan
2,075 posts |
#2870 2007-05-28 10:27 GMT |
|
Bununla degiştir Test Ettim Çalısıyor bende..
Code: <div class="cb_small_title">» {PHP.skinlang.quick_search}</div>
<div class="cb_main"> <form id="ssearch" action="plug.php?e=search&a=search" method="post"> <input type="text" class="text" name="sq" value="search..." size="15" onBlur="if(this.value=='') this.value='search...';" onFocus="if(this.value=='search...') this.value='';" maxlength="32" /> <input type="submit" class="submit" value="{PHP.skinlang.btn_search}" alt ="" /> <input type="hidden" name="searchin_frm" value="1" /> <input type="hidden" name="frm_sub[]" value="9999"/> <input type="hidden" name="searchin_pag" value="1" /> <input type="hidden" name="pag_sub[]" value="all" /> <input type="hidden" name="searchin_use" value="1" /> </form> <a href="plug.php?e=search">{PHP.skinlang.advanced_search}</a> </div> |
|
> 1 <
Benzer konular (Similar topics) #BETA
| Konular | Mesajlar | Son Yazar | Güncelleme |
| Sayfalarla ilgili bir sorun | 6 | Raven | 222 Gün |
| Leetlogin İle ilgili bir sorun var | 7 | Kaan | 510 Gün |
| Ekran Boyutu İla İlgili Sorun.! | 2 | Kaan | 398 Gün |
| t3-exodus teması ile ilgili bir sorun | 3 | Kripteks | 411 Gün |
| seditio da link ile ilgili sorun | 3 | inzar | 521 Gün |