Mini Mods - Alphabetical List Thread

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

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) there is a detailed description of the addon, unfortunately it is only Italian.

[Asterix_ita]

Sorry and thanks now I have managed to replicate the error

solved



Regards

[rechoncho]

You are a genius

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

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]

Originally Posted by 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

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!

Problem solved!!!! I'm very happy

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]

Originally Posted by Gn_Snake

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