News:

Wondering if this will always be free?  See why free is better.

Main Menu

Topics Filter v3.0

Started by M-DVD, October 10, 2007, 06:57:55 PM

Previous topic - Next topic

acappella7

I'm newbie admin for webboard with SMF. I used SMF version 1.1.9.
I interested this MOD so much!!!
BUT I got some problem that I need some helps!!
I install Topic Filter 3.0 by Manual Install Instructions for SMF 1.1.9

http://custom.simplemachines.org/mods/index.php?mod=965

I don't understand about install_1.php that manual guide suggest me to query manaully because the codes cannot be execute standalone.

So...

How can I execute this code manually?

I tried to run install_1.php on web browser (Firefox). It showed me this words
"Fatal error: Call to undefined function db_query() in /var/www/forum/TopicsFilter_v3_0/install_1.php on line 15"

Please I need some helps!!!

ps. I managed this webboards on Linux Ubuntu.
ps2. Sorry for bad English.  >:(

M-DVD

Quote from: Eclipse16V on June 01, 2009, 11:59:54 PM
OK,
here 2 version i make it.
all two version dosen´t work.

Your attach look fine.

Maybe, your forum cached hasn't been updated. (in SMF 2XX)

Do the change, clean this cache, and test.

--

Quote from: MaxiPes on June 02, 2009, 09:56:04 AM
2 M-DVD I make the translation for version 3.0 too ;)

Sorry, I must be blind, I see only the translation of the old version. :P

Quote from: MaxiPes on June 01, 2009, 03:04:09 AM
Topics Filter V2.5
THX M-DVD  :o
http://www.simplemachines.org/community/index.php?topic=199770.0

do souboru
www/Themes/default/languages/Modifications.czech-utf8.php
vložte toto:

// Topics Filter
$txt['filter_saved'] = '[Nastaveno]';
$txt['filter_date_title'] = '=Filtrovat podle data=';
$txt['filter_date_0'] = 'Žádný filtr';
$txt['filter_date_1'] = 'Dnes';
$txt['filter_date_2'] = 'Včera a dnes';
$txt['filter_date_7'] = 'Posledních 7 dní';
$txt['filter_date_30'] = 'Posledních 30 dní';
$txt['filter_date_60'] = 'Posledních 60 dní';
$txt['filter_date_90'] = 'Posledních 90 dní';
$txt['filter_date_180'] = 'Posledních 120 dní';
$txt['filter_date_270'] = 'Posledních 270 dní';
$txt['filter_date_365'] = 'Posledních 365 dní';
$txt['filter_date_366'] = 'Více jak 365 dní';
$txt['filter_topics_title'] = '=Filtrovat podle postů/druhu témat=';
$txt['filter_topics_0'] = 'Žádný filtr';
$txt['filter_topics_1'] = 'Témata bez odpovědí';
$txt['filter_topics_2'] = 'Oblíbená témata';
$txt['filter_topics_3'] = 'Hodně oblíbená témata';
$txt['filter_topics_4'] = 'Ankety';
$txt['filter_topics_5'] = 'Zamknutá témata';
$txt['filter_topics_6'] = 'Vlastní témata';
$txt['filter_paginate_title'] = '=Témat na stránku=';
$txt['filter_paginate_10'] = 10 ;
$txt['filter_paginate_20'] = 20 ;
$txt['filter_paginate_30'] = 30 ;
$txt['filter_paginate_40'] = 40 ;
$txt['filter_paginate_50'] = 50 ;
$txt['filter_paginate_forumdefault'] = 'Základní nastavení fóra';
$txt['filter_paginate_perpage'] = 'témat na stránku';
$txt['filter_alphanum'] = 'Povolit filtrovací řádek s abecedou';
$txt['filter_alphanum_desc'] = 'Zobrazí pouze posty začínající na určité písmeno';
$txt['filter_alphanum_all'] = 'Vše';


--

Quote from: acappella7 on June 03, 2009, 06:05:48 AM
I'm newbie admin for webboard with SMF. I used SMF version 1.1.9.
I interested this MOD so much!!!
BUT I got some problem that I need some helps!!
I install Topic Filter 3.0 by Manual Install Instructions for SMF 1.1.9

http://custom.simplemachines.org/mods/index.php?mod=965

I don't understand about install_1.php that manual guide suggest me to query manaully because the codes cannot be execute standalone.

So...

How can I execute this code manually?

I tried to run install_1.php on web browser (Firefox). It showed me this words
"Fatal error: Call to undefined function db_query() in /var/www/forum/TopicsFilter_v3_0/install_1.php on line 15"

Please I need some helps!!!

ps. I managed this webboards on Linux Ubuntu.
ps2. Sorry for bad English.  >:(


You can:

1.-  Edit the install_1.php and Add:

if (file_exists(dirname(__FILE__) . '/SSI.php') && !defined('SMF'))
  require_once(dirname(__FILE__) . '/SSI.php');
elseif (!defined('SMF'))
  die('<b>Error:</b> Cannot install - please verify you put this in the same place as SMF\'s index.php.');


After <?php

2.- Upload and Run install_1.php.

3.- And Erase this file :)

acappella7

Thank you very much M-DVD

I can use it already!!!

Cool MOD!!!  :D

Eclipse16V

Yes,
cache is clean. But it dosen´t work.  :(
I worked with:
SMF 2 in German

Shop:
SID Giessen

M-DVD

Quote from: acappella7 on June 03, 2009, 11:23:59 PM
Thank you very much M-DVD

I can use it already!!!

Cool MOD!!!  :D

Your welcome :)

--

Quote from: Eclipse16V on June 03, 2009, 11:48:16 PM
Yes,
cache is clean. But it dosen´t work.  :(

What happens?

I see fine your forum and the topic filter working ::)

Eclipse16V

And how I become this error in the logs:

QuoteDatenbankfehler: Unknown column 't.id_topic' in 'field list'


SELECT t.id_topic
FROM smf_topics AS tLEFT JOIN smf_messages AS ml ON (ml.id_msg = t.id_last_msg)
LEFT JOIN smf_messages AS mf ON (mf.id_msg = t.id_first_msg)
WHERE t.id_board = 26



ORDER BY is_sticky DESC, id_last_msg DESC
LIMIT 20, 20

Datei: .../Sources/MessageIndex.php
Zeile: 513

:(
I worked with:
SMF 2 in German

Shop:
SID Giessen

acappella7

I want to modify this to filter topic by year and by month that topic posted.

Can you suggest me ?

I read those code I think I will modify those code at /Source/MessageIndex.php but I don't understand some variables.

Can you help me for this?

Thank you.

MaXiForum.cz

Quote from: M-DVD on June 03, 2009, 10:57:59 PM
Quote from: MaxiPes on June 02, 2009, 09:56:04 AM
2 M-DVD I make the translation for version 3.0 too ;)

Sorry, I must be blind, I see only the translation of the old version. :P

Version 3.0  :D ;)
http://www.simplemachines.org/community/index.php?topic=301494

djkmmo

Quote from: djkmmo on June 01, 2009, 07:58:48 PM
Quote from: M-DVD on June 01, 2009, 07:47:24 PM
Thanks for the sample. Yes, is for the rewritten urls.

I will check it. Maybe I can include the fix with the MOD.
I would prefer a binding promise  ;D. (Just kidding). But it would be sweet to get both of them working.

An update... It's the PrettyURL Board URLs that are causing the trouble. Everything works just fine if I inactivate the board urls and just use Topics and Actions  URLs. To put it another way: a quick fix is to setup the boards with Pretty URL board URLs activated and inactivate it afterwards. That way all of the Boards are accessible via the base URL, but the URL shown in the addres bar when you visit a topic will be the topics Pretty URL.

M-DVD

Quote from: Eclipse16V on June 04, 2009, 12:42:23 AM
And how I become this error in the logs:
:(

Yes, I know this bug. In the next version I will fix it.

But before, I want solved the issue with Pretty_URL (although, I will cannot make a generic solution that works for everyone, regardless whether or not to have this MOD installed).

--

Quote from: acappella7 on June 04, 2009, 02:59:45 AM
I want to modify this to filter topic by year and by month that topic posted.

Can you suggest me ?

I read those code I think I will modify those code at /Source/MessageIndex.php but I don't understand some variables.

Can you help me for this?

Thank you.

Try, search:

(10 == $user_info['filter_date'] ? ' > ml.posterTime' : ' <= ml.posterTime');

Replace:
(10 == $user_info['filter_date'] ? ' > mf.posterTime' : ' <= mf.posterTime');

I think, it should work  :-\

--

Quote from: MaxiPes on June 04, 2009, 12:55:34 PM
Quote from: M-DVD on June 03, 2009, 10:57:59 PM
Quote from: MaxiPes on June 02, 2009, 09:56:04 AM
2 M-DVD I make the translation for version 3.0 too ;)

Sorry, I must be blind, I see only the translation of the old version. :P

Version 3.0  :D ;)
http://www.simplemachines.org/community/index.php?topic=301494

Thanks, your translation have been uploaded  :D

--

Quote from: djkmmo on June 04, 2009, 01:15:47 PM
An update... It's the PrettyURL Board URLs that are causing the trouble. Everything works just fine if I inactivate the board urls and just use Topics and Actions  URLs. To put it another way: a quick fix is to setup the boards with Pretty URL board URLs activated and inactivate it afterwards. That way all of the Boards are accessible via the base URL, but the URL shown in the addres bar when you visit a topic will be the topics Pretty URL.

Thanks for the tip.

Maybe I cannot included a fix, but this can help, for a fix or for the people with this problem.

MaXiForum.cz

M-DVD, I have a question.
Database code from the version 2.5 is not usable for the version 3.0, is it?
Does the version 2.5 have to be uninstalled to upgrade it to the version 3.0?

I have a problem in the version 2.5 with CZ character Ě Š Č Ř Ž Ý Á Í É
Topics with this character on the first line are not viewed :(
Is it fixed in verison 3.0?
I don´t want to do the upgrade uselessly.
Thanks ;)

M-DVD

Quote from: MaxiPes on June 16, 2009, 01:38:15 PMDatabase code from the version 2.5 is not usable for the version 3.0, is it?
No

Quote from: MaxiPes on June 16, 2009, 01:38:15 PMDoes the version 2.5 have to be uninstalled to upgrade it to the version 3.0?
Yes

Quote from: MaxiPes on June 16, 2009, 01:38:15 PM
I have a problem in the version 2.5 with CZ character Ě Š Č Ř Ž Ý Á Í É
Topics with this character on the first line are not viewed :(
Is it fixed in verison 3.0?
I don´t want to do the upgrade uselessly.
Thanks ;)

I don't know if I understood you.

You say?... if an topic has title "Águila Volando" (for example), then, in the 'letter filter' you choose the letter A, this topic doesn't appear in the result.

?

MaXiForum.cz

Quote from: M-DVD on June 17, 2009, 01:02:57 AM
No

I thought so

Quote from: M-DVD on June 17, 2009, 01:02:57 AM
Yes

OK

Quote from: M-DVD on June 17, 2009, 01:02:57 AM
I don't know if I understood you.

You say?... if an topic has title "Águila Volando" (for example), then, in the 'letter filter' you choose the letter A, this topic doesn't appear in the result.

?

Yes
http://www.maxiforum.cz/index.php/board,43.0/letter,C.html
" Č " characte not viewed.
Topics with  "Č" character doesn't appear in the result. :(

Thanks ;)

M-DVD

@Translators: I need the nexts texts. If I have the translation complete, I could add more languajes in the package for the next version.

Thanks :)


$txt
['topicsfilter_date1'] = 'Enable Filter by Date Topic';
$txt['topicsfilter_date2'] = 'Enable Filter by Date Reply';
$txt['topicsfilter_sortby'] = 'Enable Sort Method';

$txt['filter_date1_title'] = 'Reply Date Filter';
$txt['filter_date2_title'] = 'Topic Date Filter';
$txt['filter_sort_title'] = 'Sort by';
$txt['filter_sort_title_values'][] = 'First Post';


--

Quote from: MaxiPes on June 17, 2009, 01:56:31 AM
http://www.maxiforum.cz/index.php/board,43.0/letter,C.html
" Č " characte not viewed.
Topics with  "Č" character doesn't appear in the result. :(

Thanks ;)

Ok.

There is a long answer. I cannot program a solution for this, because this type of rules is change depending on the language. But the biggest obstacle is, I don't know all the languages, and perhaps there is a similarity in XX languaje, but not in another YY languaje.

Example 1: In Spanish:
á ≡ a
é ≡ e
í ≡ i
ó ≡ o
ú ≡ u
ch ≡ c

but
n ≠ ñ

Example 2: In Czech:
Č ≡ C
And, afaik
Ch ≠ C

Anything else?
Anything else languaje?


But luckily there is a short answer. And the solution :P

Your problem is with the DB's collation.

If in your DB, you use the czech collation, You will not have more problems  ;D

MaXiForum.cz

Hmm in my forum

C ≠ Č

My language is czech with UTF-8
My version is 2.5
OK, thanks ;)

djkmmo

Ji!

I have run in to another little problem: I can't access the stats page if I have action rewrite rules activated. Anyone else with this problem?

[Core]

Thanks for the great mod.

M-DVD

Quote from: MaxiPes on June 21, 2009, 05:15:58 PM
Hmm in my forum

C ≠ Č

My language is czech with UTF-8
My version is 2.5
OK, thanks ;)

Ok.

Make sure you have the czech collation in the DB.

Look this info:
http://dev.mysql.com/doc/refman/5.0/en/charset-general.html
http://dev.mysql.com/doc/refman/5.0/en/charset-show.html
http://dev.mysql.com/doc/refman/5.0/en/collation-character-set-applicability-table.html

--

Quote from: djkmmo on June 30, 2009, 05:07:08 AM
Ji!

I have run in to another little problem: I can't access the stats page if I have action rewrite rules activated. Anyone else with this problem?

You'll have more answers in the support topic of that MOD :P

--

Quote from: [<Sharp>] on June 30, 2009, 05:26:44 AM
Thanks for the great mod.

Thanks for your comment :)

arkanoidblue

OK .
Minha pequena contribuição
Ptbr ISO 8859-1

Quote$txt['topicsfilter_date1'] = 'Habilitar Filtro por Data do Tópico';
$txt['topicsfilter_date2'] = 'Habilitar Filtro por Data de Respostas';
$txt['topicsfilter_sortby'] = 'Habilitar Metodo de Ordenação;

$txt['filter_date1_title'] = 'Filtro por data de resposta';
$txt['filter_date2_title'] = 'Filtro por data do tópico';
$txt['filter_sort_title'] = 'Ordenar por';
$txt['filter_sort_title_values'][] = 'Primeiro Post';


Ptbr utf-8

Quote$txt['topicsfilter_date1'] = 'Habilitar Filtro por Data do T&oacute;pico';
$txt['topicsfilter_date2'] = 'Habilitar Filtro por Data de Respostas';
$txt['topicsfilter_sortby'] = 'Habilitar Metodo de Ordena&ccedil;&aatilde;o';

$txt['filter_date1_title'] = 'Filtro por data de resposta';
$txt['filter_date2_title'] = 'Filtro por data do t&oacute;pico';
$txt['filter_sort_title'] = 'Ordenar por';
$txt['filter_sort_title_values'][] = 'Primeiro Post';

Kimmie

added this mod to RC1.2. Everything went ok (no test fails) however, it didnt add the Letter Filter part at all. I aM also seeing these errors when trying to view a topic:

Unknown column 't.id_topic' in 'field list'


Any ideas?


Advertisement: