vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Super Mod deleted his attachments when he left (https://vborg.vbsupport.ru/showthread.php?t=143434)

Cloud Strife 04-03-2007 10:40 AM

Not really my fault, its default for any user to be able to remove their attachments. Anyway, this isn't about who's in the wrong, it's about fixing the problem at hand. So if anyone could be kind enugh to let me know what query to use to restore the attachments from my old SQL backup it would be much appreciated. :)

wengi 04-03-2007 11:00 AM

If you have a forum backup taken from cpanel these can be restored whn upping tht backup ... whilst giving the mods/supermods access to permanently delete posts is wrong . Better be safe and patient to remove post yourself thn be sorry after.

Regards
Wengi

Cloud Strife 04-03-2007 11:02 AM

Yes, but the sql backup is quite old. A lot has happened on the board since then, so simply restoring an old backup is not an option.

Paul M 04-03-2007 11:12 AM

There is no easy way.

Restore the old attachments table (to a table called attachments2). Delete all the records that are not his (from attachments2) and then copy the records that are left back into your live attachments table.

(A bit more fancy sql could actually just copy the relevant records from the attachments2 table directly to the live attachments table)

wengi 04-03-2007 11:18 AM

Quote:

Originally Posted by Cloud Strife (Post 1218976)
Yes, but the sql backup is quite old.

Wasnt refeering to a bdsql backup as tht is taken from admincp ... was refeering to a complete forum backup taken from cpanel


All times are GMT. The time now is 03:44 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.01094 seconds
  • Memory Usage 1,716KB
  • 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)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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