Basically had an issue with phpmyadin and needed to get a decent dump of someones database. Problem is they setup restrictions on ip addresses so I had to be a bit creative. Most my normal tools such as SQL pro could not connect around all this (At lease to my best effort.)
mysqldump -h mysql.yourserver.com -u mysql_user -p database_name table_name
Here is an list of sites I have done in the last 6+ months.
These sites I basically will cut up the designs and make into workable sites.
Primarly these are all wedding industry...
It happens... You get busy, articles and writing and everything in between gets left in the dust. Projects are left unfinished and seemingly you can never get the dust off them.
So here it goes I am slowly going to try and clean off the dust off some of the many projects I once started and left semi-unfinished to nearly unfinished.
I roughly have about 15 projects in general. 2-3 which are never ending and the others could be "finishable." All of which that can be "completed" it would be sweet to finish them this year. Though even that may not be easily done.
I have been developing my own CMS for roughly 2 years now. And only now starting to see the benefits of it. I haven't spoken much on what it is capable of but figured it was time to talk about one of the neat features it has!
Multi-Site handling. Sure WordPress recently has this functionality in it it. But my CMS has the ability to work on multiple pieces of content (articles, dancesteps, movies, and more.) All in one page. In a lot of ways you could consider it the GMail of CMS's.
Recently I needed to create a patch for a project and we have references in our database for wizards. These wizards exist in each folder, but cannot have more than one at a time in each folder. Currently the table does not have a unique key so I could not use:
Because of this I resorted to the following:
INSERT INTO tblName (reportName, folderId) SELECT 'Wizard', 1 FROM tblName2 WHERE NOT EXISTS (SELECT 1 FROM tblName2 WHERE reportName='Wizard' AND folderId = 1) LIMIT 1;
Hope it helps someone...
Recently I got curious and adventurous into setting up a Virtual Environment on my Mac's VMware Fusion with Ubuntu, Apache, MySQL and PHP. As a Web Developer I often find little need to be a Sysadmin and spend WAY more time developing. It may come as a shocker but its often not a required effort to need to have the knowledge now days of how to setup the environment I work in! An analogy behind this is a mechanic doesn't necessarily build cars, but rather fixes them. While they may understand the details behind it they may have never put a car together from start to finish, but if they had to they could...
So I figured I would post a little bit about what I did to get it going. Because this was my first run of doing this it took a little longer than it should have. But now that I have gone through it I could probably do it as fast as my machine can download.
Lately I have had "caching" on the brain and have been working on a decent way of caching.
So far I have found that caching is obviously faster and in XML format makes it really easy to iterate through in Object format.
My methods so far are
- Checking a database table for current cached item information.
- If it has an expiration date or does not exist the feed needs to be cached.
- If needs to be cached - Caching will grab the feed via curl, fopen, or file_get_contents()
- Feed will then be stored in a file in a specific directory on the server.
- Database will either be updated or inserted with feed information.
Recently I did a post about website loading. Which had me thinking... Paginiation! Its a lovely device that allows you to not have to display all the content on the same page. There are so many forms of pagination and pagination theories. One of which is a newer method called. "Auto Pagination." It is seen on many sites such as local pages on google and several others.
It basically detects the "windows" scroll and once a certain position on the page has been achieved it loads more content into the page. Some other neat useages of this window scroll is on mashable.com when reading an article if you scroll far enough down it will display the next article on the list. But this is about pagination...
Here is a small list of features:
- Unlimited number of sites to hook into.
- Targeting content / tagging content to pages/tags.
- Unlimited varations of content types. Ex: Articles, Banners, and more...
- Records impressions and clicks on specific content types.
- Email Campaigns - Send HTML emails to a list of registered members.
- User/Member Handling - Allows extensive registration details for membership base sites.
- Read more...
Hacking seems to be a common occurance now days. While it seems to be a somewhat complicated process in reality it is mostly simple hacks that result in tremeduous damage, costs, and lose of data.
Two Types of Web Hacks
XSS and SQL Injections. There are obviously more such as DDOS attacks, but those are short term.
What are they?
SQL Injections are a wider range of possibilities. They allow you to delete an entire database, to outputting important information. Or even logging in as an adminstrator.
- Manage Multiple Sites in one.
- Member Registration
- Page Control / SEO
- And so much more...
Sugar Snap Photography
- Custom Gallery System with CMS.
- Previewing Gallery for customers.
- Front page uses JQuery Gallery from: http://tympanus.net
- Tons of JQuery affects and plugins.
- Blog is powered by Wordpress
- Utilizes Font Face for fancy font changes.
- Branding done by Marco Suarez
- Transformers: Robots in Disguise by Hasbro, Ince https://t.co/25I6K4UvyD by shauncs 907 days ago via iOS
- Its been a long time sense I have "tinkered" in 3D. This brings back memories of working in Adobe Atmosphere. https://t.co/JxPuNSgsK1 by shauncs 1164 days ago via Twitter Web Client
- SO ya my 2 year old and 4 year old sharing there scores on my twitter... I guess they thought I wasn't active enough... by shauncs 1216 days ago via Twitter Web Client
- I got 4736 points while escaping from a Giant Demon Monkey. Beat that! http://t.co/rNGWoAQorL http://t.co/9JLQi5ZpaF by shauncs 1234 days ago via Temple Run 2 on iOS
- I just flew 168m in a brilliant game of #JetpackJoyride on iPad. http://t.co/uUZBoW8vcD http://t.co/iwtRX95hPt by shauncs 1245 days ago via Jetpack Joyride on iOS
- HTML (23)
- PHP (22)
- MySQL (19)
- JQuery (14)
- CSS (14)
- Websites (11)
- Ubuntu (11)
- Unix (8)
- HTML5 (6)
- Linux (6)
- Tutorials (6)
- Terminal (5)
- Custom Frame Work (5)
- Wordpress (5)
- Games (4)
- Nerdy (3)
- Transformer Customizing (3)
- Windows (2)
- 3D Modeling (2)
- Network (2)
- Transformers (2)
- Hacking (2)
- Reviews (2)
- Plugins (2)
- Apple (2)
- 3D Printing (2)
- Apache (2)
- Mobile (2)
- XML (2)
- Imagemagick (2)
- Roku (2)
- Photoshop (1)
- Categories (1)
- JSON (1)
- Macbook (1)
- Photography (1)
- Web Services (1)
- Movies (1)
- Cannon (1)
- GD Library (1)
- Mark II 5D (1)
- Deals (1)
- Startups (1)