Version: 2.3.0, by Almotmaiz.Net
Developer Last Online: Oct 2013
Category: Miscellaneous Hacks -
Version: 3.6.x
Rating:
Released: 06-06-2007
Last Update: 10-24-2007
Installs: 353
Uses Plugins Auto-Templates
Translations
No support by the author.
================
??? ???? ?????? ??????
================ Please remember to click Mark as Installed if you use this modification.
Support questions from members who have not marked this as installed will be considered low priority.
Thanks to all who nominated this for the MOTM Click here to vote
================ ABOUT THIS MOD
this mod Show Last Thread Order by ,Lastpost,thread Datelline, Sticky Threads, Most Views,Most Replies - In Marquee , JavaScript Effects
ADVNTAGES IN THIS MOD
without templates edit
effectively OR ineffectively Hack from CP
Option to SELECT showing type"ordering by"
Lastpost
thread Datelline
Sticky Threads
Most Views
Most Replies
Option to SELECT showing style
Marquee
JavaScript Effects
Option to Determining LIMITATION threads
Option to Shortening titles
Option to Determining Characters to short title
Option to SELECT Display Place:-
FORUMHOME-before forums
FORUMHOME-after forums
after navbar
before Footer
before footer
manuall
Option to SELECT Display in
NO Table
Table with collapse
Table without collapse
Option to show Author name
Option to show lastposter name
Option to show views count
Option to show replies count
Option to SELECT javascript effect
Option to Determining javascript speed
Option to SELECT link target
Option to Determining Marquee speed
Option to SELECT Marquee hight
Show names colors via usergroup
Option to show Date & Time
Option to externaled as ifame , javascript
Option to show thread info such as (lastposter , time .. etc) in link title
Option to SELECT special groups to see this mod
Option to show thread icon new 2.3.0
Option to choose one of many pre-defined styles for the titles to show, or you can even use your own personnalized CSS style. new 2.3.0
Note:
All the above options are set in the vBulletin Options.
The mod has been fully translated to French, Arabic, and German. You are kindly encouraged to contribute to this mod by translatic it to your language and sending it back to us so that we may include it in the official package.
I hope to see your developmental notice:up:
Thanx to webmaster74 to translated product to English , French
HOW TO INSTALL?
import product into vbulletin as a product in ur forum
edit the hacks settings area vBulletin Options
FINISH !!
HOW TO UPGRADE?
import product into vbulletin as a product in ur forum (Overwrite)
Added the function to show titles according to the permissions of the usergroup of each user in each category - 25/10/2007
Added a function to let you choose one of many pre-defined styles for the titles to show, or you can even use your own personnalized CSS style. - 25/10/2007
The issue of html code appearing in the titles where a title includes special non-ascii characters was also addressed and correctly fixed - 25/10/2007
The issue related to the presence of an apostrophe (') in the username was also addressed. - 25/10/2007
All other problems that we were made aware of, were correctly fixed.
Version 2.2
Add Option to show Author name - 15/6/2007
Change Add new places to show - 15/6/2007
Add 2 JavaScript works in All browser - 15/6/2007
Add Option to show thread info such as (lastposter , time .. etc) in link title - 15/6/2007
Add Option to SELECT special groups to see this mod - 15/6/2007
Add Option to show in external pages using (ifame, JavaScript) - 15/6/2007
Change Add new show style
Version 2.1
Add Option to show Date & Time - 8/6/2007
Add show names colors via usergroup - 8/6/2007
Add Option to SELECT Marquee hight - 8/6/2007
Add Automatically parse titles if have BBCODE in - 8/6/2007
Change Show in Table - Add more options - 8/6/2007
I get this error sometimes in the forum .. Ideas ??
Database error in vBulletin 3.6.9:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN(4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,167,172,20,,4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,165,166,167,172,221,222,0)
ORDER BY lastpost DESC
LIMIT 0, 10;
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 '4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,165,166,167,172,221,222,0)
' at line 9
Error Number : 1064
Date : Saturday, April 12th 2008 @ 11:11:39 AM
I am getting this same error. It only happens if a "guest" user (web crawler) tries to access a forum that does not exist. If I am logged in and go to the same link vbulletin gives the invalid forum error as it should. If I log out and try it I get the database error and it sends me the email error message. If I disable the marquee the problem goes away. It looks to me that for some reason something is adding an extra comma in the code. In your error above there is an extra comma between the 20 and the 4.
Mine has the extra comma between two forum IDs also.
I get this error sometimes in the forum .. Ideas ??
Database error in vBulletin 3.6.9:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount,
thread.lastposter, thread.dateline, thread.postusername, thread.postuserid, thread.iconid,
IF(views<=replycount, replycount+1, views) AS views, thread.visible, thread.open,
user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open != '10'
AND thread.forumid NOT IN(4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,1 67,172,20,,4,8,3,5,164,151,152,204,205,622,644,6,7 ,11,12,165,166,167,172,221,222,0)
ORDER BY lastpost DESC
LIMIT 0, 10;
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 '4,8,3,5,164,151,152,204,205,622,644,6,7,11,12,165 ,166,167,172,221,222,0)
' at line 9
Error Number : 1064
Date : Saturday, April 12th 2008 @ 11:11:39 AM
My board does this exact thing too.... I never traced it to BOT activity.
Hello Mr. Almotamyz,
i found error that when you go to an deleted thread or deleted forum link you will have Data base error , deactive the product all things work agin .. i insert replay in your forum :
My board does this exact thing too.... I never traced it to BOT activity.
I am guessing it is bot activity because users would not never go to a deleted forum since there is nothing for them to clik on. Also, all the errors have been traced to only "GUEST" users which are usaly bots.
I still have the problem, but just live with it. I see others are having the problem too.
Advanced Last X Thread in Marquee,JavaScript with External Options 2.2 Details »»
About Developer
Visit Web Site
Uses Plugins 
No support by the author.
05-22-2008, 10:00 PM
