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

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Auto move threads to archive forum after x days (https://vborg.vbsupport.ru/showthread.php?t=74772)

trafix 01-23-2005 11:02 AM
thats where you are going wrong ..... your phpmyadmin wont understand $DB_site

if you put the script in the cron folder you can use the task manager to "run now"

The Realist 01-23-2005 11:13 AM
Lost on this one M8.

Bison 01-23-2005 11:35 AM
Quote:
Originally Posted by The Realist
Same error.

Im using phpmyadmin to run the query.
Sorry for intruding, but this query is a PHP code dependant query and you cannot run it in phpMyadmin, or in the admin cp query. That's why you are getting errors. MySQL doesn't know what a "$db_site->(query" is! LOL!

If you want to test the query (the MySQL way), just type this (and fill in the blanks):

PHP Code:
UPDATE thread
SET forumid = [forumid number where all the threads will be moved ]
Where lastpost <= [what move date value]
AND forumid != [forumid number where all the threads will be moved]
OR sticky != 1 
BTW, this won't be a test on your forums ... it going to do the deed!

trafix 01-23-2005 12:00 PM
Quote:
Originally Posted by Bison
Sorry for intruding, but this query is a PHP code dependant query and you cannot run it in phpMyadmin, or in the admin cp query. That's why you are getting errors. MySQL doesn't know what a "$db_site->(query" is! LOL!

If you want to test the query (the MySQL way), just type this (and fill in the blanks):

PHP Code:
UPDATE thread
SET forumid = [forumid number where all the threads will be moved ]
Where lastpost <= [what move date value]
AND forumid != [forumid number where all the threads will be moved]
OR sticky != 1 
BTW, this won't be a test on your forums ... it going to do the deed!
Tnanks for explaining that Bison :)

catocom2 01-29-2005 02:45 PM
This is the closest hack to what I'm looking for that I've found.
Except...
Instead of moving, closing, or what not, I'd just like it to add a little
clock icon in the left column if the thread is older than xx, when someone
replies to it.
Is there an easy way to mod this mod to do that?

Thanks. This cron stuff is just a little beyond my programming skills ATM.
This is a great looking hack.

trafix 01-29-2005 04:06 PM
Quote:
Originally Posted by catocom2
This is the closest hack to what I'm looking for that I've found.
Except...
Instead of moving, closing, or what not, I'd just like it to add a little
clock icon in the left column if the thread is older than xx, when someone
replies to it.
Is there an easy way to mod this mod to do that?

Thanks. This cron stuff is just a little beyond my programming skills ATM.
This is a great looking hack.
so ... the clock replaces the original icon selected? ... or appears under it?

catocom2 01-29-2005 06:40 PM
Quote:
Originally Posted by trafix
so ... the clock replaces the original icon selected? ... or appears under it?
exactly :)

I'm not really sure it's a cron job thing though..?
Maybe just a conditional.

trafix 01-29-2005 07:19 PM
Quote:
Originally Posted by catocom2
exactly :)

I'm not really sure it's a cron job thing though..?
Maybe just a conditional.
yep ist php/template coding i can look at it

catocom2 01-30-2005 10:50 PM
Thanks man, but I got it now. :smoke:
fury@otcentral replied and told me how he did it.

http://otcentral.com/forum/showthread.php?t=17762

catocom2 01-31-2005 02:16 AM
here's the code I did:

place it the "threadbit" template where you want it...

PHP Code:
<!-- ---------------------- clock ------------------------------- -->
<if condition="$thread['dateline'] <(TIMENOW-86400*180)"><img src="http://catocom.com/forum/images/smilies/clock.gif" alt="This thread was started more than 6 months ago"></if>
<!-- ---------------------- /clock ------------------------------- --> 
and an icon I altered

http://catocom.com/forum/images/smilies/clock.gif


All times are GMT. The time now is 01:46 AM.
Page 4 of 7 « First 23 4 56 Last »
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.01138 seconds
  • Memory Usage 1,749KB
  • 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
  • (3)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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