http://www.eblah.com/eblah11/Blah.pl

It's been updated with the latest source.  

Here are some stats on it:

0.0571 seconds
6 opened
Queries: 9
gzip Enabled
CPU load: 0.19

As of now, I'm still debating whether or not everything will go to SQL.  Smaller files, such as the themes list, will probably not be moved over to SQL.  I may move them over to the Settings.pl file, which may be better anyway.  I want to limit the queries so the load can stay pretty low, so I'm working as best I can with it.  All files that are written to often will be moved over to SQL.  It's going slow going because I'm changing the way a lot of the data is actually manipulated.

That said, I plan on trying to keep the queries for most pages between 5 to 10, and hopefully not more than that.

The SQL driver has been built where SQL injection will not be a problem, and it's a little flexible.  Here's a little data on how to interact with it as of this point:

Code $sql = SQL->new('table name','column name','debug'); $sql->columns('field'); $sql->where('field','name','to','match'); %return = $sql->select('column','value','',''); foreach($sql->col_array()) { print $return{$_}{'field'}; # $_ equals the value of 'column name' }

It's not near complete still, but E-Blah SQL works.    It's quite quick too.  SQL CPU usage didn't appear to be great when I checked it earlier.  I'm doing all I can to make sure everything will work with the quickest speed.

So without further ado, here's the latest version.  I'd like to start getting some testers together who wouldn't mind using it and don't mind trying to find all the bugs they can.  As of now, boards, categories, posting, editing, delete (threads and posts), sticky, lock, member functions should all work.  I've just started on the actual member ranks, so it works without the files now but you can't do anything in Admin center with them yet.

Edit your SQL server login in the file SQL.pm.  If there are any issues with things I mentioned SHOULD work above, let me know.

Only MySQL right now.

This kinda works with just testing it and all.  I can't get posting to work, which I've not really developed the driver at all yet ...

Good news.  I spent some time working on a converter today.  It works pretty well (minus several bugs, specifically with a little member data).    I converted the entire forum from the backup last night and the night before (for THIS forum).  It probably took about 15 second to a minute to transfer the data to my closet server's MySQL server (so it's a little slower).  

I'll find many more bugs with a larger forum like this one to work with.

I've moved the themes list and censor list to Settings.pl, because it's loaded all the time anyway and is relatively small.

On a smaller note, Blah.pl will be renamed index.pl, which will make it a little more attractive in URL (though I like dropping it all together and using mod_rewrite).  

I'm just above 10 queries each load with the data from here, but several of those will be done away with when I work on it later.  

There's now a caching system so queries are limited.  So far it uses 7 for the board index.  

Oh, and only 4 files are being opened.  

Justin can you put the source up in the test pit or somewhere; I'd like to run some tests on it and be able to get each newest version as you produce them

Not quite yet.  Soon though.  

The PM center has been completed.  A few things have been removed, such as the auto reply.  The counts have been removed, but they may be readded in the release after 11.  The PM system was one of the few parts of E-Blah that hasn't been ever fully rewritten since the first release.  It was very ugly, but the changes should be good.  

Oh, and there's over 31K PM's with the users here on this forum (and only 4,930 are sent PM's; 359 are in storage; 25,872 are in the inbox: 21,546 are NEW and 4,326 are read).  

Quoted from mealybar

Justin can you put the source up in the test pit or somewhere; I'd like to run some tests on it and be able to get each newest version as you produce them

Released it, let me know how it's going.  

More stuff that works now ... in the Admin Center:

• Click log (only logging atm)
  
• Ban Log (full)
  
• Error log (full)
  
• Encryption (should work fully)
  
• Member Groups (should work fully)
  
• Mailing list (fully)
  
• Post recounting (fully)
  
• Validation of Members (fully -- and so fast )
  

I got rid of a few things that wasn't needed anymore, such as member list rebuild.  I think I forgot to mention with the last update that the notification service is completely working too.  Now, it's about time for a break.