vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Moving a thread with php and mysql (https://vborg.vbsupport.ru/showthread.php?t=177336)

PH03N1X 04-27-2008 07:28 PM

Moving a thread with php and mysql
 
I am making a rapidshare link checker for vbulletin and I need to find out how to move a thread with php and mysql so when it finds a dead link in the first post; it will move it to a dead link forum out of sight.
Does any one have simple code for doing this?

King Kovifor 04-27-2008 07:39 PM

Depending on what triggers the move, changing the thread ID should work for you...

PH03N1X 04-27-2008 07:54 PM

I changed the forumid to the thread to 8 (which is the forum I am sending it to) and it keeped the post count, thread count, and last post in the thread the same which it should bring down to the right amount of thread count and post count and also it should change the last post to the one before the one that got moved. it did move it except for those things.

--------------- Added [DATE]1209330989[/DATE] at [TIME]1209330989[/TIME] ---------------

I guess I can run this sql command to get the last post for the forum and put the info in the last post of the forum.
Quote:

SELECT lastpostid FROM vb_thread WHERE forumid = 2 ORDER BY lastpost DESC LIMIT 1;
and minus how many post there where from the thread from the forum and get the post count stuff right


All times are GMT. The time now is 02:43 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.01106 seconds
  • Memory Usage 1,712KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete