Witam.
Skopiowa??m w bazie danych fusion_articles i fusion_articles_cats na usion_articles2 i fusion_articles_cats2
W php-files/articles.php skopiowa??m na porady.php oraz readarticles.php na readporady.php
W php-files/administration/articles.php i articles_cats.php skopiowa??m na porady.php i porady_cats.php
W php-files/locale/polish/articles.php skopiowa?em na porady.php oraz w pliku news_cats doda?em odpowiednie wpisy np: zamiast dodaj artyku? to dodaj porad? itd.
W php-files/locale/polish/admin/news-articles.php skopiowa?em na news_porady.php
W ka?dym b?d? razie porady dzia?aj? prawid?owo.
Dodatkowo chcia??m aby u?ytkownik móg? dodawa? porad? tak samo jak artyku?.
Odpowiednio zmodyfikowa??m plik php-file/submit.php oraz php-file/administration/submissions.php
Napewno to zrobi??m dobrze bo nie ma problemu w dodawaniu porady przez u?ytkownika.
Mój problem polega na tym ?e:
Chcia?em doda? w pliku php-files/search.php wpis który by szuka? w poradach czyli w skopiowanych tabelach w bazie danych fusion_articles2 oraz fusion_articles_cats2
Skopiowa??m
<input type='radio' name='stype' value='a'".($stype == "a" ? " checked" : "")."> ".$locale['402']."
zamieniaj?c na
<input type='radio' name='stype' value='p'".($stype == "p" ? " checked" : "")."> ".$locale['402']."
oraz
if ($stype == "a") {
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."articles ta
INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id
WHERE ".groupaccess('article_cat_access')." AND (article_subject LIKE '%$stext%' || article_article LIKE '%$stext%')"
);
$rows = dbrows($result);
if ($rows != 0) {
echo $rows." ".($rows == 1 ? $locale['410'] : $locale['411']).$locale['422'].":<br><br>\n";
$result = dbquery(
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".$db_prefix."articles ta
INNER JOIN ".$db_prefix."article_cats tac ON ta.article_cat=tac.article_cat_id
LEFT JOIN ".$db_prefix."users tu ON ta.article_name=tu.user_id
WHERE ".groupaccess('article_cat_access')." AND (article_subject LIKE '%$stext%' || article_article LIKE '%$stext%')
ORDER BY article_datestamp DESC LIMIT $rowstart,10"
);
while ($data = dbarray($result)) {
if (eregi($stext, $data['article_subject']) && eregi($stext, $data['article_article'])) {
$subj_c = substr_count(strtolower($data['article_subject']), strtolower($stext));
$text_c = substr_count(strtolower($data['article_article']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$subj_c." ".($subj_c == 1 ? "Match" : "Matches").$locale['432'].$locale['433'].", ";
echo $text_c." ".($text_c == 1 ? "Match" : "Matches").$locale['432'].$locale['434']."</span><br><br>";
} elseif (eregi($stext, $data['article_article'])) {
$text_c = substr_count(strtolower($data['article_article']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$text_c." ".($text_c == 1 ? "Match" : "Matches").$locale['432'].$locale['434']."</span><br><br>";
} elseif (eregi($stext, $data['article_subject'])) {
$subj_c = substr_count(strtolower($data['article_subject']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$subj_c." ".($subj_c == 1 ? "Match" : "Matches").$locale['432'].$locale['433']."</span><br>";
}
zamieniaj?c na
if ($stype == "p") {
$result = dbquery(
"SELECT ta.*,tac.* FROM ".$db_prefix."articles2 ta
INNER JOIN ".$db_prefix."article_cats2 tac ON ta.article_cat=tac.article_cat_id
WHERE ".groupaccess('article_cat_access')." AND (article_subject LIKE '%$stext%' || article_article LIKE '%$stext%')"
);
$rows = dbrows($result);
if ($rows != 0) {
echo $rows." ".($rows == 1 ? $locale['410'] : $locale['411']).$locale['422'].":<br><br>\n";
$result = dbquery(
"SELECT ta.*,tac.*, tu.user_id,user_name FROM ".$db_prefix."articles2 ta
INNER JOIN ".$db_prefix."article_cats2 tac ON ta.article_cat=tac.article_cat_id
LEFT JOIN ".$db_prefix."users tu ON ta.article_name=tu.user_id
WHERE ".groupaccess('article_cat_access')." AND (article_subject LIKE '%$stext%' || article_article LIKE '%$stext%')
ORDER BY article_datestamp DESC LIMIT $rowstart,10"
);
while ($data = dbarray($result)) {
if (eregi($stext, $data['article_subject']) && eregi($stext, $data['article_article'])) {
$subj_c = substr_count(strtolower($data['article_subject']), strtolower($stext));
$text_c = substr_count(strtolower($data['article_article']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$subj_c." ".($subj_c == 1 ? "Match" : "Matches").$locale['432'].$locale['433'].", ";
echo $text_c." ".($text_c == 1 ? "Match" : "Matches").$locale['432'].$locale['434']."</span><br><br>";
} elseif (eregi($stext, $data['article_article'])) {
$text_c = substr_count(strtolower($data['article_article']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$text_c." ".($text_c == 1 ? "Match" : "Matches").$locale['432'].$locale['434']."</span><br><br>";
} elseif (eregi($stext, $data['article_subject'])) {
$subj_c = substr_count(strtolower($data['article_subject']), strtolower($stext));
echo "<a href='readarticle.php?article_id=".$data['article_id']."'>".$data['article_subject']."</a><br>\n";
echo "<span class='small2'>".$locale['040']."<a href='profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a>\n";
echo $locale['041'].showdate("longdate", $data['article_datestamp'])."</span><br>\n";
echo "<span class='small'>".$subj_c." ".($subj_c == 1 ? "Match" : "Matches").$locale['432'].$locale['433']."</span><br>";
}
Mój problem polega na tym ?e opcja szukaj nie dzia?a nie znajduje ?adnych wyników a w dodatku zmienia si? rozmiar modu?u search i stopka idzie do góry.
Sami zobaczcie szukaj?? w poradach http://www.ko-mp....
Co jest nie tak w pliku search.php z góry dzi?kuje za pomoc
Zapraszam na moj? stron? http://ko-mp.eu
|
