Re: Retrieve deleted posts from CBB [Module usage questions]

1

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

Re: Retrieve deleted posts from CBB

2008/7/27 4:01
jdseymour
Friend of XOOPS
Posts: 3782
Since: 2004/11/11

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

Proactive Support for Sites and Servers

WebServerMasters.com | XOOPS Tutorials

3

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

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

Re: Retrieve deleted posts from CBB

2008/7/29 2:43
iHackCode
Module Developer
Posts: 1038
Since: 2004/6/29

what version of cbb?

CBB / LatestNews / Publisher / XM-Spotlight

(ﾉ◕ヮ◕)ﾉ*:･ﾟ✧

6

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

Re: Retrieve deleted posts from CBB

2008/7/29 4:38
iHackCode
Module Developer
Posts: 1038
Since: 2004/6/29

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

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!

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Re: Retrieve deleted posts from CBB

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}