Topic: Restoring the db after the Altan hack

Hey all,

Was hacked on Saturday morning and he deleted 3 of my forums.

I upgraded to 1.2.7, then put it in maintenance mode until my host restored the db.

They finally just emailed me and said they restored it - but I'm not seeing the 3 forums.

What should I be looking for in phpMyAdmin to see if they're really there, and if they are, how can I get punBB to recognize them again?

Thanks!

Re: Restoring the db after the Altan hack

OK I just went in and I see the forums in the db, so they were restored.  there's actually 4 forums that he deleted, the bastard.

so what do I have to edit in the punBB code to associate the forums?

id 7, 12, 16, 18 are the forums that were deleted.

Re: Restoring the db after the Altan hack

Well, if you restored the full database, you should see them like it was before. I really can't tell without looking in the database.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

4 (edited by lament 2005-09-13 20:19)

Re: Restoring the db after the Altan hack

well I'm thinking because I upgraded to 1.2.7 with the databases NOT in there at the time, now that they're restored - punBB doesn't see them?

I can give you access..

edit: I went from 1.2.4 to hacked (4 forums removed) to 1.2.7, then db restore.

Re: Restoring the db after the Altan hack

anybody?

Re: Restoring the db after the Altan hack

Well, is the category id for it an existing category (I'm just guessing here)? If not, create a category with that ID, or switch the forums to new categories via MySQL

7 (edited by lament 2005-09-14 00:04)

Re: Restoring the db after the Altan hack

the db was restored to its previous state before it was hacked.

however, like I said, I updated from 1.2.4 to 1.2.7 between the time it was hacked and the time the db was restored. 

so punbb thinks I have 4 less dbs than I really do.

so where in the punbb code can I poke around and make sure that it looks for forum ids  7, 12, 16, 18 (the forums that were deleted but are now restored) and stick those in there?

do i need to delete some cache files or something?

Re: Restoring the db after the Altan hack

4 less dbs? o.O
Well, if you updated to 1.2.7 FILES but have a 1.2.4 for database, you should run 12_to_127_update.php or whatever it's called to update it (which is basically just incrementing the version).
That shouldn't do anything though. Like Rickard said, it's hard to tell without seeing the database

Re: Restoring the db after the Altan hack

There were no database changes between 1.2.4 and 1.2.7 apart from the version number increment, so the fact that you updated the scripts has no effect what so ever. I guess you could try deleting the .php scripts in the cache-folder. I doubt it would do any good though.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

10 (edited by lament 2005-09-14 00:35)

Re: Restoring the db after the Altan hack

@Smartys:

i ran the updater and it updated fine.

here's what's in my cache folder:

cache_bans.php
cache_config.php
cache_quickjump1.php
cache_quickjump3.php
cache_ranks.php
.htaccess

should i delete it all?

thanks for the help guys.. i just really want to get this thing back up and running. i have 750 users wondering wtf is up. smile

Re: Restoring the db after the Altan hack

All except the .htaccess

12 (edited by lament 2005-09-14 00:53)

Re: Restoring the db after the Altan hack

did that, but they're still not showing up.

I just took this screen shot of the admin.  The ones in red are the ones that were deleted from the forum and are now restored, but not showing up on the site.

http://www.sadreminders.com/images/categories.gif

and as you can see from the dropdown, they're still being recognized.

http://www.sadreminders.com/images/forums.gif

I don't want to re-add that forum to the category that's not showing up on the site because I'm thinking it might wipe out what's in there, which I don't want.

Rickard whatever screen shots you need on phpMyAdmin, let me know.

Re: Restoring the db after the Altan hack

Those are categories, not forums. There are no forums in those categories it seems

14 (edited by lament 2005-09-14 01:05)

Re: Restoring the db after the Altan hack

yeah there are.. smile

http://www.sadreminders.com/images/phpmyadmin.gif

and here's how it's showing on the site:

http://www.sadreminders.com/images/current_forums.gif

Re: Restoring the db after the Altan hack

and cat_id is set correctly for them to an existing category id?

16

Re: Restoring the db after the Altan hack

Smartys wrote:

and cat_id is set correctly for them to an existing category id?

i guess?  like i said, the db is restored back to normal, i updated punbb to 1.2.7.

how would i check that?

Re: Restoring the db after the Altan hack

Check cat_id on the forums, then check the categories table to see if that's a valid ID

18 (edited by lament 2005-09-14 01:12)

Re: Restoring the db after the Altan hack

i'm a noob with phpmyadmin.. the cat IDs are listed in the screen shot.. here's what the categories are showing:

http://www.sadreminders.com/images/pun_cats.gif

i'm leaving work but I'll be home shortly if you respond.. thanks for the help here so far.

Re: Restoring the db after the Altan hack

OK, now what's the cat_id column of the forum table? smile

20

Re: Restoring the db after the Altan hack

the one in post #14?

Re: Restoring the db after the Altan hack

yeah, what values do they have in the cat_id column?

22

Re: Restoring the db after the Altan hack

http://www.sadreminders.com/images/forum_cat_ids.gif

23 (edited by Smartys 2005-09-14 01:42)

Re: Restoring the db after the Altan hack

That's odd, it seems perfect :-/
Can you try clearing your cache (on your browser) or Ctrl-F5?

24

Re: Restoring the db after the Altan hack

done that several times. sad

Re: Restoring the db after the Altan hack

And all of your files are clean 1.2.7 files?