Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
I've attached it for you. I looked again and couldn't find it. I bet you somehow it's right in front of my eyes lol.
 

Attachments

  • PhpMyAdmin.zip
    15.3 KB · Views: 139
Thanks for sending. I figured out what's wrong.

I downloaded phpBB 3.0.4 which is the latest stable release and examined the database schema files via phpMyAdmin and compared with yours. They matched so your database is perfect, but nothing matched mine. Meaning....

The folks at phpBB have completely re-designed the category system in this series, removing the old table. The other tables for topics, forums and posts are nearly identical - but not for categories. Your original script worked on my phpBB, for example. I suspect this change is very recent because the documentation angelwatt found clearly is outdated already, and so is my phpBB which isn't that old. phpBB is entitled to improve their product, but at the same time hackers need to re-learn the new way of doing things too.

I looked at the new database format, and it's not obvious how categories are handled internally. I won't be upgrading so you need to approach one of the phpBB hack sites like this one and ask anyone who is knowledgeable of the new format and willing to write you a new script that works specifically on 3.0.4 - be sure to mention the version as it matters!

If anyone else is following this, feel free to help if you have the latest installed and are familiar with database concepts.

-jim
 
Also consider using the link I provided you and posting to the "3.0.x Mod Requests" forum there. That's where I would post on said issue.

Because your original script worked on my phpBB, I could not have foreseen this "complication" simply by introducing a category constraint, and phpBB has used the same category format for roughly 8 years. Until, of course, now! Sorry if I seemed to get a little miffed, it was totally perplexing at the time and a complete surprise you couldn't get it to work considering I tested it, blah blah blah.

Glad we got to the bottom of it, eventually, enjoy your shiny new phpBB and hope someone out there helps you out soon. Cheers and good day.

:cool:

-jim
 
I still haven't had a reply but I've made a work around. I display each forum underneath each other under a piece of html stating its category. It does its job. :) I'm now wondering how I can add the actual post content to the homepage. I'm going to replace my wordpress with forum posts on the homepage. Any ideas thanks. :D
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.