Pradinis
Pagalba
Užsisakyk!
- Reklamą
- Hostingą
- El. pašto dėžutę
Užsisakyk!
Įrankiai
Pasidalink
- Visos temos
Forumas | PHP-Fusion, WordPress, Shopify, PHP ir MySQL (PROGRAMAVIMAS) | Expert PHP, MySQL klausimai |
Autorius: lilas | Peržiūrų: 1296 |
lilas Narys Kapitonas Pranešimai: 793 Įstojęs: 2007 Lap. 20 15:11:44 | |
Net nzn paaiskint.. Kaip padaryte kad man ieskotu ne tik is download_title bet is download_title ir programos_kurejai? <?php /*-------------------------------------------------------+ | PHP-Fusion Content Management System | Copyright (C) 2002 - 2008 Nick Jones | http://www.php-fusion.co.uk/ +--------------------------------------------------------+ | Filename: search_downloads_include.php | Author: Robert Gaudyn (Wooya) +--------------------------------------------------------+ | This program is released as free software under the | Affero GPL license. You can redistribute it and/or | modify it under the terms of this license which you | can read by viewing the included agpl.txt or online | at www.gnu.org/licenses/agpl.html. Removal of this | copyright header is strictly prohibited without | written permission from the original author(s). +--------------------------------------------------------*/ if (!defined("IN_FUSION")) { die("Access Denied"); } include LOCALE.LOCALESET."search/downloads.php"; if ($_GET['stype'] == "downloads" || $_GET['stype'] == "all") { if ($_GET['sort'] == "datestamp") { $sortby = "download_datestamp"; } else if ($_GET['sort'] == "subject") { $sortby = "download_title"; } else { $sortby = "download_datestamp"; } $ssubject = search_querylike("download_title"); $smessage = search_querylike("download_description"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject); } else if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage); } else if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject, $smessage); } else { $fieldsvar = ""; } if ($fieldsvar) { $result = dbquery( "SELECT td.*,tdc.* FROM ".DB_DOWNLOADS." td INNER JOIN ".DB_DOWNLOAD_CATS." tdc ON td.download_cat=tdc.download_cat_id WHERE ".groupaccess('download_cat_access')." AND ".$fieldsvar." ".($_GET['datelimit'] != 0 ? " AND download_datestamp>=".(time() - $_GET['datelimit']):"") ); $rows = dbrows($result); } else { $rows = 0; } if ($rows != 0) { $items_count .= THEME_BULLET." <a href='".FUSION_SELF."?stype=downloads&stext=".$_GET['stext']."&".$composevars."'>".$rows." ".($rows == 1 ? $locale['d401'] : $locale['d402'])." ".$locale['522']."</a><br />\n"; $result = dbquery( "SELECT td.*,tdc.* FROM ".DB_DOWNLOADS." td INNER JOIN ".DB_DOWNLOAD_CATS." tdc ON td.download_cat=tdc.download_cat_id WHERE ".groupaccess('download_cat_access')." AND ".$fieldsvar." ".($_GET['datelimit'] != 0 ? " AND download_datestamp>=".(time() - $_GET['datelimit']):"")." ORDER BY ".$sortby." ".($_GET['order'] == 1 ? "ASC" : "DESC").($_GET['stype'] != "all" ? " LIMIT ".$_GET['rowstart'].",10" : "") ); while ($data = dbarray($result)) { $search_result = ""; if ($data['download_datestamp']+604800 > time()+($settings['timeoffset']*3600)) { $new = " <span class='small' style='color:#ff0000'>".$locale['d403']."</span>"; } else { $new = ""; } $text_all = $data['download_description']; $text_all = search_striphtmlbbcodes($text_all); $text_frag = search_textfrag($text_all); $subj_c = search_stringscount($data['download_title']); $text_c = search_stringscount($data['download_description']); $text_frag = highlight_words($swords, $text_frag); $search_result .= "<a href='downloads.php?kategorijos_id=".$data['download_cat']."&download_id=".$data['download_id']."' target='_blank'>".highlight_words($swords, $data['download_title'])."</a> - ".$data['download_filesize']." $new<br>\n"; if ($text_frag != "") $search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>".$text_frag."</div>"; $search_result .= "<span class='small'><span class='alt'>".$locale['d404']."</span> ".$data['download_license']." |\n"; $search_result .= "<span class='alt'>".$locale['d405']."</span> ".$data['download_os']." |\n"; $search_result .= "<span class='alt'>".$locale['d406']."</span> ".$data['download_version']."<br />\n"; $search_result .= "<span class='alt'>".$locale['d407']."</span> ".showdate("%d.%m.%y", $data['download_datestamp'])." |\n"; $search_result .= "<span class='alt'>".$locale['d408']."</span> ".$data['download_count']."</span><br /><br />\n"; search_globalarray($search_result); } } else { $items_count .= THEME_BULLET." 0 ".$locale['d402']." ".$locale['522']."<br />\n"; } $navigation_result = search_navigation($rows); } ?> Gyvenkim šiandiena sugrįžkim namo kur širdys gyvena |
|
Narys Antras po Dievo Pranešimai: 4956 Įstojęs: 2007 Spa. 26 20:10:01 | |
$ssubject = search_querylike("download_title"); $smessage = search_querylike("download_description"); Čia žiurėkis Rules: 21 & 22 Read first! |
|
lilas Narys Kapitonas Pranešimai: 793 Įstojęs: 2007 Lap. 20 15:11:44 | |
Meginau $ssubject = search_querylike("download_title") & search_querylike("programos_kurejai"); bet neisejo. O kaip tokis variantas butu geras? $ssubject = search_querylike("download_title"); $sgrupe = search_querylike("programos_kurejai"); $smessage = search_querylike("download_description"); if ($_GET['fields'] == 0) { $fieldsvar = search_fieldsvar($ssubject,$sgrupe); } else if ($_GET['fields'] == 1) { $fieldsvar = search_fieldsvar($smessage, $sgrupe); } else if ($_GET['fields'] == 2) { $fieldsvar = search_fieldsvar($ssubject, $smessage, $sgrupe); } else { $fieldsvar = ""; } Ir... Jei yra toks kodas: $subj_c = search_stringscount($data['download_title']); ir man reikia padaryt kad ieskotu is abieju taip taisyklingai kodas turi buti taip? $subj_c = search_stringscount($data['download_title'] & $data['programos_kurejai']); Gyvenkim šiandiena sugrįžkim namo kur širdys gyvena Redagavo lilas 2009 Vas. 4 21:02:24 |
Peršokti į forumą: |