Posts Tagged ‘MySQL’
SerenadeCMS: Part 1… A
Posted by MrSaints in Projects, Spotlight Tuesday, 20 October 2009 20:39 5 Comments
As I promised, i’ll be making a new post in continuation to my SerenadeCMS 2.0 streak 
But due to the lack of time I have and the lack of ideas I have on making the post interesting, I decided to take a break from that episode and hopefully something will strike me once I get something in mind. As the title states, Part 1A. Clearly this is not the actual continuation to the previous post on Serenade but I just decided to post a few (or 1, for now) images that some people might have forgotten or never seen before, but clearly it was one of the first few steps I took in creating a successful CMS, which I guess, led me to where I am today (as cheesy as it sounds).
And like many bloggers, lets communicate with the audience! So, if you like to see more, then drop a reply below this post and say along the lines of, “WE WANT MORE”. Who know’s what I might do! So have fun, and sorry I haven’t been doing much lately, I’m a slacker!
One more thing, as there were quite a few suggestions lately about setting up a forum for the hostings, I taken the liberty to set one up at http://www.frozonenetworks.com/, drop by when you get the time 
Its still in the progress of being setup fully! VOTE THE PICTURE 5 STARS. OR ELSE.
The Packet Sector CMS – Ancient Stuff.
Posted by MrSaints in Horrible Critics, Projects, Spotlight Friday, 14 August 2009 05:26 8 Comments
Disclaimer
All content are properties of their respective owner(s), we take no credit for the images used that are not under the trademark or creation of Aerosol Studios or The Packet Sector. We are in no way affiliated with Nexon America, Wizet or relevant organizations. The development of such script/web application is for the benefit and intentions of EDUCATIONAL PURPOSES. We will not be held liable for any further charges.
Firstly, I would like to acknownledge Cris (aka CrisTheWind), original founder of Packet Sector and The Packet Sector Networks (etc – despite the fact it wasn’t open for long), for making this CMS possible today Alongside with me he was helping out with the SVN commits and working with me to make this a great CMS which was unfortunetly never used
This was a project I worked on during my times with FrozoneCMS as well as the planning of upcoming Serenade 2.0. It helped me a lot with practicing and putting into action variou jQuery techniques and skills as well as PHP (despite the fact I wasted around $5 for Assembla D:).
Just recently I have posted a small video (which didn’t turn out so good thanks to the poor render) taking a sneak peak around the CMS. You can check it out on YouTube, I have embedded the video below, enjoy.
Now instead of talking a whole lot of crap and turning your attention away I’ll just go brief to the point. When Cris and I first planned out this CMS, it seemed like a lot of work and back then I wasn’t really strong and farmilliar with OOP. One of the main guidelines on the construction of this OdinMS CMS was that it was to be attractive, User-Friendly, Browser Compatible as well as further capabilities with 3rd Party systems like SHOUTcast. The CMS is an almost full-fledged ajax powered site (including registration + login). Alongside with an extensive control panel (several control panel to be precise) as well multiple functions and features to help accessibility.
For security, the class dealt with proper error handling as well as potential SSL capabilities and a complete visitor tracking system with Geo Location. So, instead of this constant talk, I’ll just let the pictures do the talking, enjoy!
[ GALLERY REMOVED AS IMAGES WERE LOST DURING THE ROLLBACK, SORRY ]
So there it is If you have any queries or questions related to this, feel free to comment 
COMMENT COMMENT COMMENT.
kthnxbai.
LiveZilla, the Web 3.0?
Posted by MrSaints in Horrible Critics, Spotlight Sunday, 21 June 2009 03:18 1 Comment
Geotracking + LiveZilla Client
What is Web 2.0 in the first place?
The second generation of the World Wide Web, especially the movement away from static webpages to dynamic and shareable content. E.g. Ajax; dynamically loading pages without even refreshing or leaving the current URL or even dynamic form validation to prevent the consecutive form submissions till its valid.
So what is Web 3.0 then?
Well, if you ask me, a website can’t go any further from being dynamic besides being ultra dynamic, but how about site management? Recently I was using LiveZilla for my hosting services (as a Live Support), I was amazed at how everything worked and I would say this might be a clear example of a future Web 3.0 if not 4.0 web application.
Data Transfer (communication to web)
To start with, I downloaded LiveZilla executable file wondering where the PHP side of it were. Yes I was that clueless. But after a while when I was clicking through the installation file, I have figured that LiveZilla executable came along with a LiveZilla Server Administration client. This client guided me through uploading the files from my computer to the correct directory through FTP (note: the files were all on the client! It was that simple! I need not do anything!). The database part was simple too, I only had to create a new database then click “Create Tables” on the client to build the database
So basically LiveZilla treated the standard PHP files and MySQL database as a SERVER. Now as most of you know a simple chatroom software would work like this:
Chatroom Client => Chat Room Server (most likely hosted and running as an executable or boot file).
Likewise with LiveZilla:
Administration Client => LiveZilla Server (Which is basically a bunch of files hosted on my web hosting).
Live Chat @ Live Zilla!
So whats so UNIQUE about this?
In all my time of Web Development so far, I have not encounteered any Web system that allowed you to manage your web application as a whole through an external client. The fact you could just keep an application open and wait for a *ring* to realize someone is requesting a live support makes a huge difference compared to the historical method of keeping a web-based client opened that continuosly refreshes through the use of Ajax timeouts.
Its coming together.
If you haven’t realized already, Wordpress has already created their own iPhone/iPod Touch application which allows you to manage your posts and your blog as a whole through just one application. With the new generation of the iPod Touch and iPhone, Web APIs has become more and more popular. Web 3.0 is already here, and sites such as Twitter.com has led to the development of vast majority of external applications allowing us to communicate with their server.
In my opinion, the ease of web management is basically having the ability to manage it anywhere anytime. And API does the trick. So why is LiveZilla so good once again?
LiveZilla User Management (external Client)
Let me ask a simple question.
Would you rather manage your Wordpress blog through visiting your admin panel at a specific domain… Or:
Would you rather have a software which you can launch and keep on the background allowing you to manage your database, plugins and everything just like visiting the standard URL.
In addition to this, the software may even feature a live feed that informs you with a single beep or alert box when someone has made a comment on your post or subscribed to your RSS.
MUCH MORE!
This is more than just creating a simple application that utilizes TWebBrowser component linking to a specific domain. Applications like these would feature a very easy to use interface with buttons like, “Add New Post!” or “Add New Page!”. It can be that simple.
So, Web 2.0 was all about the simplicity of delivering the content the viewers, but Web 3.0 would be all about the communication of Viewers -> Content -> Webmasters. Some say Web 3.0 will be the transition from Web Application to Web Services, but in my opinion, it can be anything
Button Creating Wizard! Transfers images upon selection.
Just Imagine.
Just imagine one day, a Content Management System such as my SerenadeCMS being managed through an external application/software and accessible through a web client that communicates with the server providing live access details and possibly utilizing Geotracking, oh wonders.
For those MapleStory private servers out there, make life easier. Create a GM external-application that communicates with your SQL server and perhaps everytime some player makes a report, the external-application will recieve a server response and *beep* giving you a wake up. This saves so much time compared to the standard “web-based logs”. Or perhaps even accessing it through your iPhone or iPod Touch, and now with 3G, you can be doing it anywhere!
This is a really smart system in my opinion, and webmasters should really begin to open up and allow the development of their vast service such as what Facebook has done with Facebook Applications. The whole point of web development is to improve the feasibility of management and access.
Hope you enjoyed this article!
External Client -> Web Database