Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Alphabetical List Thread Details »
Alphabetical List Thread
Mod Version: 4.0.9, by Asterix_ita (Coder) Asterix_ita is offline
Developer Last Online: Sep 2018 I like it Show Printable Version Email this Page

vB Version: 4.2.0 Rating: (7 votes - 4.71 average) Installs: 46
Released: 24 Aug 2011 Last Update: 01 Sep 2013 Downloads: 377
Not Supported Uses Plugins Translations  

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.

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #61  
Old 31 Aug 2013, 18:41
Asterix_ita's Avatar
Asterix_ita Asterix_ita is offline
 
Join Date: Aug 2009
Sorry and thanks now I have managed to replicate the error

solved



Regards
Attached Files
File Type: xml product-ct_thread_list_4_0_9s.xml (36.6 KB, 9 views)
__________________
Mods
Reply With Quote
  #62  
Old 31 Aug 2013, 20:38
rechoncho rechoncho is offline
 
Join Date: Aug 2012
You are a genius

I see you have solved the problem.

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?

Thank you for all.

Last edited by rechoncho; 31 Aug 2013 at 20:49.
Reply With Quote
  #63  
Old 31 Aug 2013, 21:19
Asterix_ita's Avatar
Asterix_ita Asterix_ita is offline
 
Join Date: Aug 2009
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
__________________
Mods
Reply With Quote
  #64  
Old 31 Aug 2013, 23:59
rechoncho rechoncho is offline
 
Join Date: Aug 2012
Originally Posted by Asterix_ita View Post
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!!!
Reply With Quote
  #65  
Old 15 Nov 2013, 19:19
Ross L Ross L is offline
 
Join Date: Apr 2008
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).
__________________
Xbox 360 Forums - Xbox One Forums

Last edited by Ross L; 15 Nov 2013 at 19:34.
Reply With Quote
  #66  
Old 16 Nov 2013, 22:54
Toxic2 Toxic2 is offline
 
Join Date: Jul 2009
Oh this is sweet ! Thank you
Reply With Quote
  #67  
Old 08 Apr 2014, 19:05
JesWhite JesWhite is offline
 
Join Date: Apr 2014
Real name: Jes
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 ?
Reply With Quote
  #68  
Old 09 Sep 2015, 13:05
Gn_Snake Gn_Snake is offline
 
Join Date: Feb 2006
Works in 4.2.3?
Reply With Quote
  #69  
Old 09 Sep 2015, 21:17
Manoel Jśnior's Avatar
Manoel Jśnior Manoel Jśnior is offline
 
Join Date: Feb 2009
Real name: Manoel Jśnior
Originally Posted by Gn_Snake View Post
Works in 4.2.3?
Yes
Reply With Quote
  #70  
Old 15 Feb 2018, 17:07
Stratis's Avatar
Stratis Stratis is offline
 
Join Date: Jan 2010
Real name: Stratis
Can someone help please?
How insert (target="_blank) in this code:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Thanks in advance
Reply With Quote
  #71  
Old 15 Feb 2018, 17:43
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
Originally Posted by Stratis View Post
Can someone help please?
How insert (target="_blank) in this code:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Thanks in advance
You would need to find where that variable is constructed in the plugin PHP code and edit the links there.
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #72  
Old 15 Feb 2018, 18:21
Stratis's Avatar
Stratis Stratis is offline
 
Join Date: Jan 2010
Real name: Stratis
Maybe this is the one


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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
Reply With Quote
  #73  
Old 15 Feb 2018, 20:15
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
I'm good Stratis...and you?

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


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Or perhaps even better:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #74  
Old 15 Feb 2018, 20:35
Stratis's Avatar
Stratis Stratis is offline
 
Join Date: Jan 2010
Real name: 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

Last edited by Stratis; 16 Feb 2018 at 05:49.
Reply With Quote
  #75  
Old 16 Feb 2018, 17:03
Emad ELsayed's Avatar
Emad ELsayed Emad ELsayed is offline
 
Join Date: Feb 2013
Sorry
Not working on 4.2.5
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:41.

Layout Options | Width: Wide Color: