Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 2.x > vBulletin 2.x Full Releases
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Details »»

Version: , by DR2000 DR2000 is offline
Developer Last Online: Jun 2008 Show Printable Version Email this Page

Version: 2.2.x Rating:
Released: 11-13-2001 Last Update: Never Installs: 18
 
No support by the author.

#### Subject Preview by DR2000 ####
I looked at all other hack avaliable for this, and all of them
are trying to do too much by editing your database structure,
and modifying the way data is inserted. Why overcomplicate
things, when all data is already there, and it only needs to be
extracted...

#### DEMO ####
To see this hack in action take a look at
http://forum.4adrive.com

#### FEATURES ####
- Shows the subject of the last active post on the front page
- Shows the icon of the last active post on the front page
- No need to alter database, and risk to screwing something up
- Only one file to change
- If the subject was very long, shows trunkated version of it,
and replaces the rest with '...', preventing your main page
layout from being screwed up.

#### #### ####
Nov 14, 2001
#### #### ####

Note: Tested with 2.0.3, 2.2.0 and 2.2.1.

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #32  
Old 11-19-2001, 12:21 AM
DR2000's Avatar
DR2000 DR2000 is offline
 
Join Date: Nov 2001
Location: Brooklyn, NY
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by LuBi
I got mine to work

I updated but it wasn't good enough, I had to instal lthat damn prefix hack and now I'm waitin for the creator to get back to me to fix his syntax error...
Er, what wasn't good enough, and what syntax error are you speaking off? I'm not aware of any.
Reply With Quote
  #33  
Old 11-19-2001, 06:37 AM
LuBi LuBi is offline
 
Join Date: Oct 2001
Posts: 416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by DR2000


Er, what wasn't good enough, and what syntax error are you speaking off? I'm not aware of any.
lol sorry two different things, the I got mine working is to you. The other statement was personal problems, I was making a remark to the fact I tried to install this Prefix hack and it caused me a lot of trouble. Your hack and the prefix hack were the last 2 I was installing of the 20+ that were in already... Thanks the hack worked great no complaints!
Reply With Quote
  #34  
Old 11-19-2001, 09:49 AM
Sufian Sufian is offline
 
Join Date: Oct 2001
Posts: 15
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Can someone please help me? Again, I installed the hack and all on 2.2.0, but I got this error when I went to my forum:

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT forum.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title as thtitle FROM forum left outer join thread on thread.forumid = forum.forumid and thread.lastpost >= (forum.lastpost-30) LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
mysql error: You have an error in your SQL syntax near 'WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title ' at line 1
Reply With Quote
  #35  
Old 11-19-2001, 12:21 PM
DR2000's Avatar
DR2000 DR2000 is offline
 
Join Date: Nov 2001
Location: Brooklyn, NY
Posts: 21
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by Sufian
Can someone please help me? Again, I installed the hack and all on 2.2.0, but I got this error when I went to my forum:

Database error in vBulletin 2.2.0:

Invalid SQL: SELECT forum.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title as thtitle FROM forum left outer join thread on thread.forumid = forum.forumid and thread.lastpost >= (forum.lastpost-30) LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
mysql error: You have an error in your SQL syntax near 'WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title ' at line 1
Eh, don't know what you did wrong. Make sure when you were inserting lines, you didn't insert any extra line breaks... That's the only thing I could think of at this moment. Maybe some one else will have an idea where you did wrong.
Reply With Quote
  #36  
Old 11-19-2001, 12:43 PM
Syphin Syphin is offline
 
Join Date: Oct 2001
Posts: 115
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I cant get this to work on any 2.2.1 forum, and ive tried on diffrent servers too... >_<

-Syphin
Reply With Quote
  #37  
Old 11-19-2001, 12:54 PM
LuBi LuBi is offline
 
Join Date: Oct 2001
Posts: 416
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It's just an index.php and template hack..? Worked fine on my forum... try again I gues. goodluck
Reply With Quote
  #38  
Old 11-19-2001, 02:32 PM
Syphin Syphin is offline
 
Join Date: Oct 2001
Posts: 115
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i know its just a index.php and templete hack... And trust me, ive tried it on 4 diffrent boards...
Ive copy and pasted, and typed it in myself.... for some damn reason it wont work... >_< lol

-Syphin
Reply With Quote
  #39  
Old 11-19-2001, 07:47 PM
xware's Avatar
xware xware is offline
 
Join Date: Nov 2001
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

bug:Can't display sub forum's last title .
but I've fixed it .
thanks.
Reply With Quote
  #40  
Old 11-19-2001, 07:54 PM
FWC's Avatar
FWC FWC is offline
 
Join Date: Oct 2001
Location: Ontario, CA
Posts: 821
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally posted by xware
bug:Can't display sub forum's last title .
but I've fixed it .
thanks.
What was the fix?
Reply With Quote
  #41  
Old 11-19-2001, 08:15 PM
xware's Avatar
xware xware is offline
 
Join Date: Nov 2001
Posts: 74
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'll release a new version some time later.
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 08:26 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06361 seconds
  • Memory Usage 2,303KB
  • Queries Executed 27 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete