1
hiflyer
Retrieve deleted posts from CBB
  • 2008/7/26 21:20

  • hiflyer

  • Not too shy to talk

  • Posts: 107

  • Since: 2006/3/7 3


Is there a way to retrieve posts users or admins have delete in CBB? (I thought I had been able to find them in the database via phpMyAdmin in the past but can't seem to now so maybe I'm mistaken.)

2
jdseymour
Re: Retrieve deleted posts from CBB

Not without a backup. Once deleted, the posts are removed from the database.

3
hiflyer
Re: Retrieve deleted posts from CBB
  • 2008/7/28 16:39

  • hiflyer

  • Not too shy to talk

  • Posts: 107

  • Since: 2006/3/7 3


I think I actually figured it out. Looks like every post remains in the database, just can't get to it through the site.
in phpMyAdmin I first exported the bb_posts_text. Searched and found the text I was looking for even though it had been deleted online. (Also notice that I don't see any gaps in the post ID #s.) To find the user who made the post I exported the bb_posts table and correlated the post_ID from the _text table to the one in the _posts table.

I think I just confused myself describing that...if anyone else needs to do it let me know and I'll try a better explanation.

4
hiflyer
Re: Retrieve deleted posts from CBB
  • 2008/7/28 16:58

  • hiflyer

  • Not too shy to talk

  • Posts: 107

  • Since: 2006/3/7 3


Or maybe not, that got me to some posts that were not on the site but maybe not necessarily all of them... I'll dig into it some more.

5
iHackCode
Re: Retrieve deleted posts from CBB

what version of cbb?
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

6
hiflyer
Re: Retrieve deleted posts from CBB
  • 2008/7/29 2:56

  • hiflyer

  • Not too shy to talk

  • Posts: 107

  • Since: 2006/3/7 3


CBB 3.05

7
iHackCode
Re: Retrieve deleted posts from CBB

i know that in 3.08 there is a button on the bottom right. near that [XOOPS CBB] image. there is a link that says 'Admin', and that would make the 'Admin CP' appear. where u can administrate the pending, deleted, all posts & topics. and some other things.
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

8
hiflyer
Re: Retrieve deleted posts from CBB
  • 2008/7/29 13:27

  • hiflyer

  • Not too shy to talk

  • Posts: 107

  • Since: 2006/3/7 3


The Admin>Deleted function is in 3.05 too. Looks like the same ones I got from the SQL export so maybe that's all of them.
Thanks!

Login

Who's Online

220 user(s) are online (155 user(s) are browsing Support Forums)


Members: 0


Guests: 220


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits