VOTE ON THE BOARD FIX!!! HURRY BEFORE THEY ARE ALL GONE!!

[BD]

Make yer pick

[KrAzYdAvE]

I'm cool with starting over, is there any way to get the content of a thread though?

I kinda need the content for that LAN party thread, whoever posted isn't important, just need content. If it's too big of a deal, don't worry about it.

[Akira]

I can get the cLAN topic to display content, as soon as I know what SQL query/command to run to update poster_id to be mine or your's for that matter. I don't know alot about MySQL.

What I need to do, is update poster_id that equals -1, in topic_id that equals 1161 to update poster_id to be 3

As for all other posts, I can go through and just delete them all instead of attempting recovery. Just one big mess to try to regain them all. If cLAN one is needed, at least that should be straight forward.

[Serpent]

I can get the cLAN topic to display content, as soon as I know what SQL query/command to run to update poster_id to be mine or your's for that matter. I don't know alot about MySQL.

What I need to do, is update poster_id that equals -1, in topic_id that equals 1161 to update poster_id to be 3

As for all other posts, I can go through and just delete them all instead of attempting recovery. Just one big mess to try to regain them all. If cLAN one is needed, at least that should be straight forward.

update <tablename> set <this> = <that> where <this> = <that>

http://dev.mysql.com/doc/mysql/en/update.html

[Akira]

Makes sense, but I still can't figure out how to be explicit for the particular topic_id

Ugh. Sorry, I'm just not very good with this sort of stuff. Setting up MySQL is one thing, modifying tables/data is just not me.

[Baron[CotC]]

Ive never seen the table so this is just a guess but its similar to this:


update <tablename> set poster_id = KD where topic_id = cLanParty

[Akira]

I tried my grand idea, and no go. Gonna probably have to delete things. But can't do so via phpBB, only in MySQL, and as that is, hard to really tell what's what.

[Serpent]

Red has got it... and if you are still having problems maybe I can help... (I (UNFORTUNATELY) have setup mysql and had to restore massive tables inside of databases, etc... restoral, backup, table maintenance, replication, etc... the works. heh... I personally hate MySQL, but have a lot of experience. )

[Akira]

See, my lack of knowledge with MySQL doesn't help, but I think what is worse is that I don't know where/what to repair in the database!

I don't know what causes the board to not display message content, but continues to display the original poster and subject. If you were to figure out that, I can give you access to do so.

[Greg Boyington]

i have only posted like 4 times so nothing important to me

[Serpent]

See, my lack of knowledge with MySQL doesn't help, but I think what is worse is that I don't know where/what to repair in the database!

I don't know what causes the board to not display message content, but continues to display the original poster and subject. If you were to figure out that, I can give you access to do so.

I'll download it and uncompress it on my computer here and then go through the code... I'll look over the source.. shouldnt be too hard to find the tables related to the boards.... and then just see how they all interact together... I'll get back to you on this...

(unless you are going to just drop the tables or delete the rows from them anyway...)