Alphabetical List Thread

[Asterix_ita]

Alphabetical List Post is a simple addon for vBulletin 4
you can create a totally automated an alphabetical list of threads present in a forum. The list is placed inside of a post without any change of template.

The creation of the discussion list is very quick and simple:


create a new thread on the forum enabled
to the post insert only the secret key ( for your security don't use passwords already used in other applications)
save


Installation:

1. Import product-ct_thread_list.xml
2. Configure the hack in vBulletin Options -> CT-> Simple Alphabetical List

Changelog:

4.0.0 started version
4.0.1 fix adding CSS if Store CSS Stylesheets as Files is active (thank Lynne for help)
4.0.2 no vbseo user (refresh page)
4.0.3 / 4.0.4 /4.0.5 tests for vbseo
4.0.6 added compatibility vbseo - fix refresh page on click anchor link - added option sticky on list
04/04/12 change dependency maxversion from 4.1.9 to 4.2.99
4.0.9 fix for vbseo 3.6
4.0.9s for only spanish language add letter ?

Translations:

Italian language: Collectiontricks (http://www.collectiontricks.it/vbulletin-4-traduzione-ct-simple-alphabetical-vers-4-0-0-63.html)

Support:
Low priority will be given to posters who do not have this marked as installed

Brand:
The addon insert the brand, if you want to use addons do not remove

Donation:
Any donation is always welcome

Attention with TapaTalk the list is not created, the secretkey is displayed in the post

At this address (link (http://www.collectiontricks.it/forum/webmania/Ct3479-lista-alfabetica-discussioni.html)) there is a detailed description of the addon, unfortunately it is only Italian.

[Asterix_ita]

reserved

[Asterix_ita]

reserved 2

[Hornstar]

I might have to test this one out. It looks very interesting :)

[tarzan22]

It hurts, does not work in 4.1.5

http://img855.imageshack.us/img855/5840/screenshot006dj.png

thanks

[Asterix_ita]

it is a problem with the template css, apparently in your site the template is not loaded,
you can try to add this css code on template additional.css


#charlistnav {
border:solid {vb:stylevar lightweightbox_border.borderWidth}px {vb:stylevar lightweightbox_border.borderColor};
-moz-border-radius:5px;
-webkit-border-radius:5px;
border-radius:5px;
padding:3px;
margin-bottom:1em;
width:auto;
}

#bitletter {
border:solid {vb:stylevar lightweightbox_border.borderWidth}px {vb:stylevar lightweightbox_border.borderColor};
-moz-border-radius:5px;
-webkit-border-radius:5px;
border-radius:5px;
padding:3px;
margin-bottom:1em;
width:auto;
}
#charlistnav dt {
float:{vb:stylevar left};
width:13%;
}

#charlistnav dd {
float:{vb:stylevar left} ;
width:3.2%;
}



#charlistnav dd a {
font-size:{vb:stylevar small_fontSize};
padding:2px 1px;
border:solid {vb:stylevar lightweightbox_border.borderWidth}px {vb:stylevar lightweightbox_border.borderColor};
-moz-border-radius:3px;
-webkit-border-radius:3px;
border-radius:3px;
background-color:{vb:stylevar lightweightbox_background.backgroundColor};
text-decoration:none;
display:block;
text-align:center;

}

#charlistnav dd span {
font-size:{vb:stylevar small_fontSize};
padding:2px 1px;
border:solid {vb:stylevar lightweightbox_border.borderWidth}px {vb:stylevar lightweightbox_border.borderColor};
-moz-border-radius:3px;
-webkit-border-radius:3px;
border-radius:3px;
background-color:{vb:stylevar lightweightbox_background.backgroundColor};
text-decoration:none;
display:block;
text-align:center;

}

#charlistnav dd a:hover {
border-color:{vb:stylevar link_color};
background:{vb:stylevar link_color};
color:white;
}

[tarzan22]

excellent work

It could do this with less height?


http://img824.imageshack.us/img824/8193/screenshot007li.png

Many thanks

pardon my English

[Asterix_ita]

Then pass me the link to the discussion
which browser do you use?

On my test site it works fine

thanks

[tarzan22]

Works well with all browsers.

I mean remove the blank header

thanks

[Asterix_ita]

I see nothing in the code that creates the space.
I use the same CSS that vbulletin use to create the alphabetical list member.

you can pass me the link in private to the alphabetical discussion

Regards

[Asterix_ita]

Tarzan you have this vbulletin options active -> Store CSS Stylesheets as Files

Regards

[tarzan22]

Thank you very much, perfect

http://www.foroxd.com/dvdrip-bdrip-castellano/281342-indices.html

[FReeSTER]

this will be a great option if it could be add it to the MyPages mod...
Very interesting :up:

[Asterix_ita]

Fix bug for vbseo user

[misericorde]

I'm sorry :

It s not good for 4.1.5 and no working for it.

[snowlion]

Warning: include_once(includes/functions_vbseo.php) [function.include-once]: failed to open stream: No such file or directory in [path]/includes/class_postbit.php(340) : eval()'d code on line 322

Warning: include_once() [function.include]: Failed opening 'includes/functions_vbseo.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/includes/class_postbit.php(340) : eval()'d code on line 322



I don't use vbseo. :D
*Edit: Fixed by comment "include_once 'includes/functions_vbseo.php';"
One more issue: the page refresh when click "Top" link.
Stickied threads don't list on Alphabetical list

[Asterix_ita]

during my tests was never presented, I have now added a condition.

the stickies threads are deliberately excluded from list.

One more issue: the page refresh when click "Top" link.

I will run verification with rewrite url active

Thanks

regards


Edit: There was a bug in creating links, it should be resolved.

[snowlion]

Thanks for the update:D
Anchor link ok now but...
When I click a letter in alphabetical bar, it redirect me straight to index page not jump to the list, like this http://www.domain.com/forum/#D

[Asterix_ita]

I use vbseo and I don't have problem demo (http://www.collectiontricks.it/forum/webmania/Ct3561-demo-plugin-lista-automatica-integrata-nel-post.html)

Thanks

[snowlion]

Here the link of my forum. I'm using Mod Rewrite Friendly URLs.
http://www.bentinhyeu.info/forum/threads/14130

[CILGINKRAL_]

Warning: include_once(includes/functions_vbseo.php) [function.include-once]: failed to open stream: No such file or directory in [path]/includes/class_postbit.php(340) : eval()'d code on line 322

Warning: include_once() [function.include]: Failed opening 'includes/functions_vbseo.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/includes/class_postbit.php(340) : eval()'d code on line 322

I don't use vbseo. :D
*Edit: Fixed by comment "include_once 'includes/functions_vbseo.php';"
One more issue: the page refresh when click "Top" link.
Stickied threads don't list on Alphabetical list

I get the same error. :(

[Asterix_ita]

I restored the 4.0.2 version. I am having problems using the anchors. The variable relpath has some problems.

thanks

[POL_ED]

vb 4.1.6 - working :up:
Thanks

[CILGINKRAL_]

vBSEO does not work :(

[Asterix_ita]

in 4.0.2 version vbseo don't work fine.

On my site i have the vbseo demo, for now I don't find problems

[CILGINKRAL_]

in 4.0.2 version vbseo don't work fine.

On my site i have the vbseo demo, for now I don't find problems

vBulletin 4.1.5 version, custom rew dont

[Asterix_ita]

On 4.0.6

added compatibility vbseo (the addon is online to my site and it works fine)
fix refresh page on click anchor link
added option sticky on list

I also run tests on a vbulletin 4.1.6 without vbseo on locally and I don't have refresh on click anchor

I thank everyone for alerts

regards

Asterix_ita

[snowlion]

*Updated
Work great now, thanks for the update :d

[Gn_Snake]

Another great work, thanks!!

[dvL-den]

So what do we do when we get this error message?

Warning: include_once(includes/functions_vbseo.php) [function.include-once]: failed to open stream: No such file or directory in [path]/includes/class_postbit.php(340) : eval()'d code on line 429

Warning: include_once() [function.include]: Failed opening 'includes/functions_vbseo.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in [path]/includes/class_postbit.php(340) : eval()'d code on line 429

I really didn't understand how to fix this issue...

[Asterix_ita]

do you have vbseo installed?
I check if vbseo is active with:


if(defined('VBSEO_ENABLED') && VBSEO_ENABLED)
{

the answer on your forum is active, if not it is very strange because it sees the variable active vbseo

did you have vbseo installed and then removed?

[dvL-den]

Never uninstalled vbseo and I am using it as always...I am using another hack similar to this and no problems, thank you for trying to help anyways...maybe when bugs are sorted this hack will work better...

[Asterix_ita]

I do not understand why he does not find the file "includes/functions_vbseo.php", seen that you using vbseo

you can try to set the full path of file on

admincp -> plugin & product -> plugin manager -> select "Create Alphabetical list vbseo"

include_once ('your_path_vbseo/includes/functions_vbseo.php');

you change your_path_vbseo

regards

[solohdes]

Your hack is awesome, I love it, you save me a ton of work in my forum.

A sugestion, can be possible to do with users too? Will be great.

[alhidaya]

Hello,

Can you do for version 4.1.1.1, please ?

[Asterix_ita]

I change dependency maxversion from 4.1.9 to 4.2.99

download the file again

[alhidaya]

Hello

I installed the product but I see nothing;

Active Plugin
Do you want to activate the plugin? Yes

Enabled Forums - Select the forum to be enabled Alphabetical List Navigation. : I have the forum selection. : ok

But I don't see Alphabetical in my forum

[Asterix_ita]

do you have create a new thread on the forum enabled?
do you have insert only the secret key to the post? ( for your security don't use passwords already used in other applications)

regards

[Sworm]

will work on 4.2.0?

Regards

[dny18]

Sorry, where do i insert the secret key?

I don't see Alphabetical List in my forum

[Asterix_ita]

Sorry, where do i insert the secret key?

On first post are write:

The creation of the discussion list is very quick and simple:

- create a new thread on the forum enabled
- to the post insert only the secret key ( for your security don't use passwords already used in other applications)
- save

In the option:
do you have select the forum?
do you have select the user enable?

Regards

[franzes80]

No work on 4.20 pl3

[Mr_Running]

Yes, I am trying to get it to work on 4.2.0 patch 3
Not working so far...Tagged. :)

[Asterix_ita]

released version 4.08 on my site works fine demo (http://www.collectiontricks.it/forum/webmania/Ct3561-demo-plugin-lista-automatica-integrata-nel-post.html)

Regards

[Mr_Running]

Thanks for the demo.
It was different then what I was expecting.
I will try it again :)

Edit: I installed 4.0.6

[fastcom]

v.4.08 not work on vB4.20 pl3.

step1: download v.4.08 and install it.
step2: active(default), Setting\Options\CT -> Simple Alphabetical List\
- Enabled Forums: choose all forum
- Enabled User: 25220
- secret key: 1234567890
step 3:
create new thread with secect key 1234567890 but forum not show Alphabel List navigator.

I have try with 4.06 but it not success. Please let me know, how can fix it?

[tidus78]

Ciao Asterix,il tuo plugin funziona sul mio forum ma mi appare uno strano messaggio di errore permanente in cima alla pagina :

Warning: include_once(includes/functions_vbseo.php) [function.include-once]: failed to open stream: No such file or directory in [path]/includes/class_postbit.php(345) : eval()'d code on line 165

Warning: include_once() [function.include]: Failed opening 'includes/functions_vbseo.php' for inclusion (include_path='.:/php5/lib/php/') in [path]/includes/class_postbit.php(345) : eval()'d code on line 165

Qualche idea a riguardo?Ottimo plugin

[Asterix_ita]

Do you have vbseo install? if so, what version

Thanks

regards

[tidus78]

Vbseo 3.6.0. PL2 :)

[Asterix_ita]

Fix on vers. 4.0.9

Regards

[fastcom]

It's still not work for me and don't show any error. I don't use any Vbseo.
Please help me.

[Prorockz]

not working on VB 4.2.0 Patch Level 3 list not show.

[Asterix_ita]

On my site online it works fine http://www.collectiontricks.it/forum/webmania/Ct3561-demo-plugin-lista-automatica-integrata-nel-post.html

[rechoncho]

Thank you very much.
This mod is amazing, but in my forum, I have a little problem.
My forum uses a spanish language and sometimes the users post a thread with a ?, and in the list appears two N when there is a thread that begins with ?.

This is the problem:

http://forocer.org/listado-de-metal.html-12629


https://vborg.vbsupport.ru/external/2013/08/7.png

https://vborg.vbsupport.ru/external/2013/08/8.png




Is there any posibility to solve this?
Is it possible to add the ? letter to the mod?

Sorry, my english is not too good. :o

Regards,

[Asterix_ita]

Hi

I was unable to reproduce the error as you can see

https://vborg.vbsupport.ru/external/2013/08/5.png

try to rewrite the title.

Regards

[rechoncho]

Hi Asterix.
Thank you for answering. :)

OK, I'm trying to explain it better.

In the spanish language exists one more letter, the letter ?, that is not the same that the letter N.
Our alphabet is:
A - B - C - D - E - F - G - H - I - J - K - L - M - N - ? - O - .......

If I rewrite the title of these threads, changing the first letter, ?, with a N, the problem disappears, but It would not be correct, because for example ?u is the name of an animal, and Nu is nothing.

I don't know if I explain.

When the title of a post begins with ?, in the alphabetical list mod appears two or more N.
I think the mod confuses N and ?.

Is it posible to add the letter ? to the programming of this mod, or to do anything to solve this problem for those who use the spanish language?

I've tried to add a ? to de XML of the mod, but I don't know how to do it. :(


Regards.

[Asterix_ita]

Hi
you can try this beta version
I do not have vBSEO in my local server for testing.

Regards

PS: Tell me if it works, about this version does not guarantee support

Test run with db latin1_swedish_ci

[rechoncho]

Hello again, Asterix.

You are very nice with me.

I have tested it just now.
Look at the result:

https://vborg.vbsupport.ru/external/2013/08/2.png

The header is PERFECT !

But in the list...

https://vborg.vbsupport.ru/external/2013/08/3.png

Appear two N, the letter ? appears too but between the two N. :erm:

My db is in Latin1 too.

If you think that it is very complicated do not worry any more, I will be grateful for it to you equally.

Good weekend.

[Asterix_ita]

for the problem of double N I wrote to you here (https://vborg.vbsupport.ru/showpost.php?p=2441943&postcount=55)

Can you try?

I can not reproduce the problem

Regards

[rechoncho]

for the problem of double N I wrote to you here (https://vborg.vbsupport.ru/showpost.php?p=2441943&postcount=55)

Can you try?

I can not reproduce the problem

Regards

OK, I think is easy to reproduce the problem.
You can try in your localhost.

Create several threads whose title begins with N, for example:
- Nocturnia-Sin Retorno
- Northern Light Orchestra
- Nox Arcana
- Nuclear Assaul

And then, create several threads whose title begins with ?, for example:
- ?u Fuego
- ?u Viejos Himnos
- ?u Y Nadie Escap?

And I'm sure you'll see in the list two letters N, and the three threads with ? will appear at the end of the list. (with the original mod).

Regards.

[Asterix_ita]

Sorry and thanks now I have managed to replicate the error

solved

https://vborg.vbsupport.ru/external/2013/08/1.png

Regards

[rechoncho]

You are a genius :eek:

I see you have solved the problem. :up:

I have installed in my forum, and now I have a db error message, when I accede to the list.


Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM foros_thread
WHERE forumid=89 AND sticky=0 AND visible=1
ORDER BY title ASC COLLATE latin1_spanish_ci;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'COLLATE latin1_spanish_ci' at line 4
Error Number : 1064
Request Date : Saturday, August 31st 2013 @ 08:55:46 PM
Error Date : Saturday, August 31st 2013 @ 08:55:46 PM
Script : http://forocer.org/showthread.php?t=12629
Referrer : http://forocer.org/metal/f89.html
IP Address : ****
Username : ****
Classname : vB_Database
MySQL Version : 5.1.67





:confused:

Do you know what happen? :erm:

Thank you for all.

[Asterix_ita]

in my server that syntax works, you can try with:

open the file xml and find (two string)

ORDER BY title ASC COLLATE latin1_spanish_ci

replace with

ORDER BY title COLLATE latin1_spanish_ci

or

ORDER BY title COLLATE latin1_general_ci

save and install addon

Regards

[rechoncho]

in my server that syntax works, you can try with:

open the file xml and find (two string)

ORDER BY title ASC COLLATE latin1_spanish_ci

replace with

ORDER BY title COLLATE latin1_spanish_ci

or

ORDER BY title COLLATE latin1_general_ci

save and install addon

Regards

Yes, yes, YESSSS !!!!!!

It's works PERFECT !!!!

Take a look:
http://forocer.org/listado-de-metal.html-12629

A LOT OF THANKS my friend.

You're a real GENIUS! http://forocer.org/images/smilies/rezo.gif

Problem solved!!!! I'm very happy http://forocer.org/images/smilies/bravo.gif

See you soon!

REGARDS!!!

[Ross L]

I've managed to get this working on the mobile theme. It isn't perfect, but if you just add the templates it works (you also need to add an additional.css and add the CSS edits from page one).

[Toxic2]

Oh this is sweet ! Thank you

[JesWhite]

this addon is very nice...
nice working...
but i moved another forum and changed everything...
can you fix this problem...
again for example i will add a forum id and addon shows this id's threads...
and when i moved thread this addon shows i added forum threads...

you understand me ?

[Gn_Snake]

Works in 4.2.3?

[Manoel J?nior]

Works in 4.2.3?
Yes

[Stratis]

Can someone help please?
How insert (target="_blank) in this code:
<vb:if condition="$ctlist['active_other']">{vb:raw template_ct_thread_list_all_bit}</vb:if>

Thanks in advance :)

[MarkFL]

Can someone help please?
How insert (target="_blank) in this code:
<vb:if condition="$ctlist['active_other']">{vb:raw template_ct_thread_list_all_bit}</vb:if>

Thanks in advance :)

You would need to find where that variable is constructed in the plugin PHP code and edit the links there. :)

[Stratis]

Maybe this is the one

$ctlist['link'] = '<a href="showthread.php?'. $riga['threadid'] .'-'.$riga['title'].'">'.$riga['title'].'</a>';

Actually I want the threads that shows in the list to open on new window, now it opens in same.

How are you Mark? and thanks for answering :)

[MarkFL]

I'm good Stratis...and you?

That code looks like a good candidate...try changing it to:

$ctlist['link'] = '<a href="showthread.php?'. $riga['threadid'] .'-'.$riga['title'].'" target="_blank">'.$riga['title'].'</a>';

Or perhaps even better:

$ctlist['link'] = '<a href="' . fetch_seo_url('thread', $riga) . '" target="_blank">'.$riga['title'].'</a>';

[Stratis]

I am fine to, weather here is a bit cold though.


Thank you for another time for your help, I will test and see what happens. :)


EDIT:
It works fine Mark :)

[Emad ELsayed]

Sorry
Not working on 4.2.5

[Stratis]

Sorry
Not working on 4.2.5
It works fine for me in vb4.2.5 and with 7.0.26 PHP
I do not remember in 7.1 php and can not test it again. :)

[hhwforum]

Hi! This mod available for vb3.8x?

[RedHacker]

No work in 4.2.5