Frank H wrote:in the rules, you could easily end up with more than 255 chars ... as you set them with
txt"jpg"jpeg"gif"bmp"tga"tiff"tif"zip"z01"z02"z03"z04"rar"r00"r01"r02
and so on...
(and since it doesn't store so many lines, I figured it would be ok ... as it's only a per forum and per group setting)
Thanks for the input though, it's always nice to get tips and such
Okay, I'll give you that it's possible, I guess I just changed it to something I knew would work for my particular situation because screw typing in that many extensions
Oh, there is also a matter of your AP_* file being pretty incompatible with Postgres. In this case, one of the problems is changing tinyint(1) to Boolean (which I admit isn't actually necessary as INT works just fine, but from a semantic point of view using Boolean is better), so all your "WHERE 1" statements need to be changed to "WHERE true", though I see no reason for those statements anyway, I mean "true" is always "true" just like "1" is always "1", right? Once again, I could be wrong here. Also, for compatability reasons you should avoid using ` as a quote character, instead use ', ", or nothing as the case dictates. I can supply a more compatible version of this file if you like.
I think the JOIN is easily the best way to go, the only extra "gotcha" associated with it is the loop to delete duplicate posts, but if v1.3 has a "proper" templating system then you won't even need that. There's quite a bit of optimization that could be done, but to be perfectly honest the only place it really matters is in viewtopic.php, all the other stuff either can't suffer from its time complexity or is an Admin area, and who cares how fast those are
Good luck with the next version
EDIT: Most of the Admin Plugin for this mod is incompatible with Postgres, too