Free PHP Contact Form

I’ve been busy building a new site and was in need of a contact form. Dashed over to HotScripts and found this fine freebie:

Fusion Contact

Fusion Contact is a mail form, that allows a user/visitor from your site to send you or your staff an email , with easy custumization of the form fields, Add/Remove email accounts, Add/Remove subjects, you can even edit the template for which will displayed on your website. All this can be done from the Admincp.

It’s a snap to install and does work nicely. One thing I noted is that it suggests the script was built to install in the main folder, rather than its own subfolder. Nope, I don’t do that, I like to keep my files neat and seperate. πŸ˜† So I did install it in its own subfolder and changed this include:

<?php include(“form.php”); ?>

to read as:

<?php include(“http://mynewdomain.com/subfolder/form.php”); ?>

So far that’s all its needed and it’s working like a charm!

I also found the template I’m using on the new site at:

Open Source Web Design (Hello! always my first stop) and found a gorgeous template to use that was coded by Now-Design.co.uk..

This new site has nothing to do with the Clickin’ It Rich project, yeesh I’m behind! πŸ˜†

Free Google Adsense Monitor

This is new to me, SysSense Google AdSense Monitor

SysSense is your personal desktop Google AdSense monitor. It keeps your current Google AdSense information in the Windows system tray.

It displays your adsense imps, clicks, earnings and more.

I haven’t had a chance to install or test it, and I don’t know if it tracks one website or many – but thought someone might be interested.

It does look like a nice little tool, and free to boot! πŸ™‚

Blogs To Riches Offer

Just an update on the Blogs To Riches offer I wrote about in January (Free Offer – Blogs To Riches):

I did receive the ebook from Jim Kukral yesterday, but haven’t had a chance to read it yet. I sent an email to him on Sunday asking about the offer as I hadn’t received the ebook yet (it was past the 45 days mentioned in the terms), but all’s well and I did get my copy.

Free Datafeed Cleaner

AMWSO has released a new beta version of its datafeed cleaner. You can grab it here:

Datafeed Cleaner 2.0 Beta

Version 2.0 Beta is NOW available for download, testing and feedback. New Features/fixes in version 2.0.

1. Load data from local or remote Anonymous FTP / HTTP location.
2. Load data from local or remote Secure FTP / HTTP location.
3. Integrated RSS Affiliate Marketing News Feed
4. Data Filter system that allows for custom slices of data.
5. Auto detects the number of columns in TXT files.
6. CSV import error fixed.
7. ShareASale dropped column error fixed.

Free Auto MySQL Backup Script

Last week a friend of mine lost a week’s worth of entries on her blog. Seems her host only backs up weekly when she understood it was daily.

Here’s a script you can try so you’ll always have a fresh copy of your blog and other databases:

Download the latest version of this Auto MySQL Backup Script. It’s version 2.2 as of today.

Open this file in your text editor and change the following:

# Username to access the MySQL server e.g. dbuser
USERNAME=dbuser Your hosting account username

# Username to access the MySQL server e.g. password PASSWORD=password Your hosting account password

# Host name (or IP address) of MySQL server e.g localhost DBHOST=localhost

# List of DBNAMES for Daily/Weekly Backup e.g. “DB1 DB2 DB3″ DBNAMES=”DB1 DB2 DB3” Use “all” or enter each database name you want backed up

# Backup directory location e.g /backups
BACKUPDIR=”/backups” Delete the backslash so it’s just “backups”

# Mail setup
# What would you like to be mailed to you?
# – log : send only log file
# – files : send log file and sql files as attachments (see docs)
# – stdout : will simply output the log to the screen if run manually.
MAILCONTENT=”files”

# Set the maximum allowed email size in k. (4000 = approx 5MB email [see docs])
MAXATTSIZE=”4000″

# Email Address to send mail to? (user@domain.com)
MAILADDR=”user@domain.com” Change to your email adress

Everything else stays the same.

Now into your hosting account, then File Manager

Create a folder named backups
Create a folder named scripts
In the scripts folder, upload the file automysqlbackup.sh.2.2
Once it is uploaded, click on the file and change the Permissions to 744

Leave the File Manager section and go back to your cPanel home and then into the Cron Jobs section (usually towards the bottom)
Select ‘Standard’
Enter the email address you are sending the backup to
Command line to run: /home/hostusername/scripts/automysqlbackup.sh.2.2
Minute Box: Click on 42
Hours: Click on 2 am
Day: Every day
Month: Every month
Weekday: Every weekday

Click Save Crontab

If set up correctly, you should be emailed a copy of each of your databases every night at 2:42 am (well unless your hosting goes down!). A copy of the databases will also be sent to the ‘backups’ folder you created. Since the backups are both named and dated, none of them will be overwritten each night. If you’re tight on space, you can clean this out every other week by simply deleting the files.

You can set any time you’d like for the cron tab, but usually it’s good practice to do this in the middle of the night when the server is less active.

You can also choose whatever folder names you like, they don’t have to be ‘backups’ and ‘scripts’. Just make sure the names you choose are reflected in both the Cron command line and the script itself.

That’s it!

πŸ˜€