Video to MP3
Sometimes you just want to listen to your YouTube videos, right?
Video2mp3.net
Video2mp3 is a free YouTube, MyVideo, Clipfish, Sevenload, Dailymotion, MySpace to MP3 Converter and allows you to convert and download a video to MP3 file online. This service is fast, free, and requires no signup. All you need is a Video URL, and our software will transfer the video to our server, extract the MP3, and give you a link to download the audio file. So you are able to listen to your favorite YouTube tracks on every MP3 player.
How To Convert YouTube Videos into MP3s
Pretty simple, just click on the photo above for Video2mp3.net and follow the easy instructions. It is all totally free. Be sure to check out his terms of service, remember some files are not meant to be copied…
CRON Jobs
Cron is a time-based job scheduler in Unix-like computer operating systems. The name cron comes from the word chronograph (a time-piece).[citation needed] Cron enables users to schedule jobs (commands or shell scripts) to run automatically at a certain time or date. It is commonly used to automate system maintenance or administration.
Custom Help Desk Web Application
I have mentioned before that I am an IT consultant and have clients up and down the east coast, mainly in Massachusetts. However I now have clients all over the world and need a better way to manage my tasks for them.
I am not 100 percent finished, but that’s not uncommon for me when I am working on projects for myself. I always have a good system but am never satisfied with the design (not unlike this site). Anyway lets get to the point; I created an automatic system to keep track of my maintenance contracts. Basically, I have a schedule of work to accomplish and I don’t want to forget about it, plus I want to keep track of all the work I do.
Configuring CRON Jobs
The concept here is simple. I have an order of things I need to accomplish and I want it done automatically.
- Check daily to see if there is any work for me
- If so, create the help desk ticket automatically
- Notify requester and myself by email
This is pretty simple and I do it with one PHP file. My maintenance plans account for daily, weekly, biweekly and monthly. To keep this short I will only show you my daily maintenance.
<?php
// Add code to Connect to Database and for Security
// 1 - Grab all Maintenance Plans that are enabled and active within date span...
$sql = "SELECT * FROM maintenance WHERE enabled = 1 AND DATE(CURDATE()) BETWEEN datestart AND dateend;";
// 2 - Create help desk ticket
$qryDaily = "INSERT INTO tickets (member_id, ticketstatus, dtcreate, priority, problem, summary)
// 3 - Add code to Send notification emails I use phpMailer
?>
CRON Manager
Depending on your hosting provider, there may be different ways to do this. I use GoDaddy.com Grid Hosting so there is a control panel and it is very simple to configure.
Basically you are creating the PHP file above and telling the server to run it using this schedule. By clicking on the Browse button you can easily select the your PHP file and wait for your emails.
If anyone wants a real example, I can create one for you.
Speeding up WordPress
More like cleaning up WordPress, but anyway. I see this code all the time and I use it,but I can see how some people may get confused by it. So I am going to try and tell you how to modify it for your own WP database.
The code below is pretty simple, but you cannot just copy and paste for it to work. You will need to be using PHPMyAdmin which you normally get from your hosting provider. Once inside here find your database on the left hand side and look for your WordPress tables.
Normally your tables will look something like wp_posts, but if you are a little more secure then you will have changed the prefix wp to something else.
The PREFIX is in red, make sure you change the red code below to your prefix.
DELETE a, b, c
FROM prefix_posts a
LEFT JOIN prefix_term_relationships b
ON a.ID = b.object_id
LEFT JOIN prefix_postmeta c
ON a.ID = c.post_id
WHERE a.post_type = 'revision'