vb.org Archive
Page 6 of 9 « First 45 6 78 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)
-   -   Soft Deleted Archive v2.7 (https://vborg.vbsupport.ru/showthread.php?t=70878)

Revan 11-01-2004 04:38 PM
Try running it several times?
Lol only thing I can think of

Oblivion Knight 11-01-2004 04:51 PM
That query won't work on the other 3 because they weren't deleted by a moderator, so there's no record of them in the moderatorlog.. Is there any other way to get the timestamp?

mtha 11-01-2004 07:12 PM
Quote:
Originally Posted by Oblivion Knight
That query won't work on the other 3 because they weren't deleted by a moderator, so there's no record of them in the moderatorlog.. Is there any other way to get the timestamp?
.. or your moderatorlog was pruned sometime before.

hehe, yes. Ask those who deleted it, when he/she did delete the post/thread and fill them in.

If you make up some number, it wouldnt be different from 00:00, 1st Jan 1970 right?

I dont know if there's any other place that record this timestamp, so for my forum, I just ... let it be, or try to ... hard delete them if they are worth to be deleted.

if you can find the place where this deletion time recorded, let me know

mtha 11-01-2004 07:14 PM
Quote:
Originally Posted by Revan
Ive implemented both fixes, and they work just fine.
Cheers :)

Updated to v2.5:
To upgrade, replace softdeladmin.php with the one in the zip.
I'd think that you should state what's new/fix for each version, easier to keep track of hack :)

Revan 11-02-2004 05:09 AM
Hm okay lol :p

Fixes/Features for v2.5:
  • Fixed calculation of pages
  • Fixed calculation of threads/posts
  • Fixed broken redirect when hard deleting records
  • Added Posted By in the record view

I think thats about it :)



And @ the missing timestamps: Unless they are posts/threads that you want sticking around for usage as evidence against spammers, why not just remove them and be done with it ;)

mtha 11-02-2004 02:18 PM
Quote:
Originally Posted by Revan
And @ the missing timestamps: Unless they are posts/threads that you want sticking around for usage as evidence against spammers, why not just remove them and be done with it ;)
:) I have about 1000 softdeleted post timestamps missing :p. it'll take sometime to check and hard delete all of them :D



anyway, if post's owner want to delete a post, there's no reason for not delete them (unless it contains valuable information that you want to keep).

msimplay 11-02-2004 05:50 PM
PHP Code:
open includes/functions_databuild
 _____________________________
 
 Find (around line 401-407):
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason)
                 VALUES
                 ($postinfo[postid], 'post', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                 '" . addslashes(fetch_censored_text(htmlspecialchars_uni($delinfo['reason']))) . "')
             ");
 
 
 Replace with:
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason, deldate)
                 VALUES
                 ($postinfo[postid], 'post', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                 '" . addslashes(fetch_censored_text(htmlspecialchars_uni($delinfo['reason']))) . "', '" . TIMENOW . "')
             ");
 
 
 
 Find (around line 295-301):
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason)
                 VALUES
                 ($threadinfo[threadid], 'thread', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                  '" . addslashes(htmlspecialchars_uni(fetch_censored_text($delinfo['reason']))) . "')
             ");
 
 
 Replace with:
 -----------------------------
 
             $DB_site->query("
                 REPLACE INTO " . TABLE_PREFIX . "deletionlog
                 (primaryid, type, userid, username, reason, deldate)
                 VALUES
                 ($threadinfo[threadid], 'thread', $delinfo[userid], '" . addslashes($delinfo['username']) . "',
                  '" . addslashes(htmlspecialchars_uni(fetch_censored_text($delinfo['reason']))) . "', '" . TIMENOW . "')
             "); 
just wanted to know if those file edits are absolutely neccessary as the hack seemed to work well even without those
the reason i know is because i had some trouble with my functions_databuild.php and i didn't do the file edits until i realised that they were meant to be there for this hack

Revan 11-02-2004 07:41 PM
If you do not perform that edit, the date stamp of the deleted posts/threads will appear as "00:00, 1st Jan 1970" (in whatever default date format you have).
So if you dont care much for when they are deleted, and you wouldnt use the sorting feature anyways, then its not needed :)

msimplay 11-02-2004 07:57 PM
Quote:
Originally Posted by Revan
If you do not perform that edit, the date stamp of the deleted posts/threads will appear as "00:00, 1st Jan 1970" (in whatever default date format you have).
So if you dont care much for when they are deleted, and you wouldnt use the sorting feature anyways, then its not needed :)
hmm i'm using version 3.0 and i didn't have to do those edits for the right time

Revan 11-03-2004 01:29 PM
I am referring to future records ;)
If they dont get a date inserted, how will the script know what date they were deleted, hm? :p


All times are GMT. The time now is 10:11 PM.
Page 6 of 9 « First 45 6 78 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.01342 seconds
  • Memory Usage 1,766KB
  • 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_php_printable
  • (4)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