WebDev $lol Just another WordPress site

$lol->php – Alpha v1.0 released

Just incase you have not already taken note, early this week, Weston packaged up and released the $lol->php framework with its MVC components added into it, for an even easier and an even more rapid development experience.

Download Now!

It is essentially the same framework, but with a bunch more libraries and configs added:

• closure_compiler - Google's closure compiler used for Javascript. Basically its a code-based version of this application.
• css - handle the loading of cascading style sheets into your MVC.
• data - miscellaneous data that we find to be often used by web developers (eg: months, states).
• db - MySQL Database class, it also parses your sql query to know what to return.. as long as you don't start with a new line as your sql..
• developer - I don't really use this one all that often.. it may have one of our random IP addresses statically coded in there, but its supposed to be used for debugging things on a live website so that you can see them and your client(s) cannot.
• error - show an error when the lol framework hits an error (you may also use it to show errors, ie: restricting access to a user group)
• files - handle some file stuff.
• input_filter - mostly used to block cross-site scripting attacks, also used by DB in its "esc" function for cleaning data before inserting into the database.
• js - handle the loading of javascript (inline & in-script) into your MVC.
• output - handle the output buffer (the template class uses this for the most part, but you also have access to it).
• plugins - loads plugins.
• template - sets (and renders) the template, handles loading views as well.
• text - format your text!
• url - parses and redistributes the url into the MVC structure.
• validate - validate that ____ is a phone number, or that ______ is an email, etc~.
• view - load views into your template, and pass those views (optional) variables.

Another main difference is that if you want to use the MVC structure instead of just the base object loader, then you call ignite.php instead of fire.php. You also must rename and move the .htaccess file into the root of your web server.

MySQL Proper Function

Its awesome.  Its like a "MySQL UC First" function.

I stole it from here: http://www.artfulsoftware.com/infotree/queries.php#122
They have more handy little MySQL functions: http://www.artfulsoftware.com/infotree/queries.php

Just incase link is down, here it is:

DROP FUNCTION IF EXISTS proper;
SET GLOBAL  log_bin_trust_function_creators=TRUE;
DELIMITER |
CREATE FUNCTION proper( str VARCHAR(128) )
RETURNS VARCHAR(128)
BEGIN
DECLARE c CHAR(1);
DECLARE s VARCHAR(128);
DECLARE i INT DEFAULT 1;
DECLARE bool INT DEFAULT 1;
DECLARE punct CHAR(18) DEFAULT ' ()[]{},.-_!@;:?/'; -- David Rabby added \'
SET s = LCASE( str );
WHILE i <= LENGTH( str ) DO -- Jesse Palmer corrected from < to <= for last char
BEGIN
SET c = SUBSTRING( s, i, 1 );
IF LOCATE( c, punct ) > 0 THEN
SET bool = 1;
ELSEIF bool=1 THEN
BEGIN
IF c >= 'a' AND c <= 'z' THEN
BEGIN
SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1));
SET bool = 0;
END;
ELSEIF c >= '0' AND c <= '9' THEN
SET bool = 0;
END IF;
END;
END IF;
SET i = i+1;
END;
END WHILE;
RETURN s;
END;
|
DELIMITER ;

POD Update

Hiyea folks, just another update on the status of POD and how its coming along. We are now (well sometime tomorrow) accepting any requests for the Alpha-2 version of POD.

• Loads of bugfixes
• Loading & Storing multiple sites
• Login / Registration
• Add "ftp sites" to your account.
• Read data from "ftp site" you select and load into its files for the editor (Hooray!!)
• Encryption on Passwords - I am not going to say how, since that would decay the security just by saying "lol its an md5" (by the way, its not just an md5), at any rate the important fact I want to share is that a crazy encrypted string is stored in our database - not your FTP password.  Then the FTP password is decoded upon the time that it goes to get used. This is so that if our system is ever hacked and they steal our database, they won't be able to easily retrieve your FTP passwords. Host and User are not encrypted - I felt that might be going overboard.
• Added support for future stuff, like line-height, scroll speed, etc--
• Added a Code Navigator (OOoooo! Fancy! - but fairly buggy right now. Works great on smaller files, large files murder it)
• Split FTP files into 2 seconds - FTP Tree and FTP Files, concept was taken from Filezilla (I love filezilla!). If you find this feature annoying, the code navigator shares a space with the ftp tree, so you can just never open the ftp tree if you don't want to.
• Added FTP Passive/Active mode option.
• Added an option for SSL to FTP connection.

Sorry if I seem disjointed, I just got done working on this stuff, and its 2am, so I am quite sleepy. Goodnight, Everybody!!

Notice: Not all of these features listed above are 100% complete, some of them are just started on.