vb.org Archive
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Administrative and Maintenance Tools - Expired Threads (https://vborg.vbsupport.ru/showthread.php?t=70302)

clearchannel 02-11-2005 05:09 PM
I'd like to remove this hack. I installed this hack in VB 3.06 and am now receiving database errors. How do I remove the database quary?

database error.
Code:
Database error in vBulletin 3.0.6:

Invalid SQL:
  SELECT
 
  thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 12243)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(70,3,23,14,16,102,103,15,20,17,10,122,13,11,9,12,21,104,25,68,55,4,19,100,27,123,5,52,99,8,121,69,29,22,124,125,120,105,117,119,108,114,118,107,109,113,116,7,110,30,54,47,111,60,65,61,66,64,62,63,72,112,90,75,85,84,86,87,93,92,48,115,101,83,91,97,98,78,79,80,81,82,95,94,96,88,51,53,49,50,28,24,18,71,26,56,73,69,29,22,124,125) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10
' at line 15

mysql error number: 1064

Date: Friday 11th of February 2005 08:49:58 AM
Script: http://www.yourdomain.com/
Referer:
Username: anonymous
IP Address: xxx.x.xxx.xx

Logikos 02-11-2005 06:41 PM
Quote:
Originally Posted by clearchannel
I'd like to remove this hack. I installed this hack in VB 3.06 and am now receiving database errors. How do I remove the database quary?

database error.
Code:
Database error in vBulletin 3.0.6:

Invalid SQL:
  SELECT
 
  thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
  , thread.iconid AS threadiconid, iconpath AS threadiconpath
,thread.forumid, forum.title AS forumtitle
, post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread as thread
LEFT JOIN icon USING (iconid)
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN deletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 12243)
WHERE open <> '10' AND thread.visible = 1 AND thread.forumid NOT IN(70,3,23,14,16,102,103,15,20,17,10,122,13,11,9,12,21,104,25,68,55,4,19,100,27,123,5,52,99,8,121,69,29,22,124,125,120,105,117,119,108,114,118,107,109,113,116,7,110,30,54,47,111,60,65,61,66,64,62,63,72,112,90,75,85,84,86,87,93,92,48,115,101,83,91,97,98,78,79,80,81,82,95,94,96,88,51,53,49,50,28,24,18,71,26,56,73,69,29,22,124,125) Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10

mysql error: You have an error in your SQL syntax near 'Array AND deletionlog.primaryid IS NULL
ORDER BY lastpost DESC
LIMIT 10
' at line 15

mysql error number: 1064

Date: Friday 11th of February 2005 08:49:58 AM
Script: http://www.yourdomain.com/
Referer:
Username: anonymous
IP Address: xxx.x.xxx.xx
That query error isn't caused by my hack.

clearchannel 02-11-2005 07:50 PM
Quote:
Originally Posted by Live Wire
That query error isn't caused by my hack.
I'm not claiming it is. This is the only hack I installed before I started receiving the error messages.

I contacted support at vbulletin and was told they could not provide support with a hack installed.

I would like to uninstall this hack and see if I can duplicate the error. If I can duplicate the database error, I can go back to support at vbulletin, but first, I have to uninstall the hack.

I can make the file changes, I need help removing the table I added to the database in order to install this hack.

Thank you in advance.

ThePimp 03-21-2005 06:00 AM
Installed, and all I get is a blank screen when I go to Forum Manager.

ThePimp 03-30-2005 09:39 AM
Quote:
Originally Posted by ThePimp
Installed, and all I get is a blank screen when I go to Forum Manager.
Nevermind, I fixed the problem. Your syntax was off, and you had a misspelling in your instructions with capitalization.

Anyhow, I installed this, and set the days to expire, as well as turned it on. However, it didn't seem to do anything. I set the expire time to be 7 days, and then went to the very first thread ever started (nearly 7 months ago) and could still reply.

Does anyone have an explaination for this?

ThePimp 03-30-2005 09:42 AM
Nevermind... as "Admin" you can still reply to old threads.

007 04-19-2005 07:12 AM
There is a pretty bad typo in the forums.php instructions. It should be:

PHP Code:
        print_input_row($vbphrase['how_many_days_till_expire'], 'forum[daysexpired]', $forum['daysexpired']); 
Other than that everything works fine.

[high]* 007 licks the install button! :p[/high]

kobescoresagain 05-02-2005 03:31 PM
Do you actually get to pick the thread that you want to expire or do you have to do it to all in a certain forum? Also how easy would it be to change it to a certain day. For instance, I would want it to expire on 3/1/06 Instead of having to figure out how many days it is until then (which would be an extreme hassel, I would like to just type in that date and it would show up expired on the beinging (or end) of that day?

Logikos 05-02-2005 04:14 PM
Quote:
Originally Posted by kobescoresagain
Do you actually get to pick the thread that you want to expire or do you have to do it to all in a certain forum? Also how easy would it be to change it to a certain day. For instance, I would want it to expire on 3/1/06 Instead of having to figure out how many days it is until then (which would be an extreme hassel, I would like to just type in that date and it would show up expired on the beinging (or end) of that day?
No you can't pick which thread can expire on a certain date. This allows all threads in a certain fourm to expire after x days of no replies. If there is a thread that no has replied to for 90 days, chances are its done with and this hack is to stop thread diggers from bummping old threads.

rjordan 05-02-2005 09:26 PM
Quote:
Originally Posted by Live Wire
No you can't pick which thread can expire on a certain date. This allows all threads in a certain fourm to expire after x days of no replies. If there is a thread that no has replied to for 90 days, chances are its done with and this hack is to stop thread diggers from bummping old threads.
Darn, I was hoping it would do this too. We post messages with time limits on responses, but not all and not all for the same time frame.


All times are GMT. The time now is 04:54 PM.
Page 4 of 5 « First 23 4 5
Show 40 post(s) from this thread on one page

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.01316 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete