If a server is shutdown unexpectedly (power outage or hardware failure), one or more MySQL tables can be locked open and may need to be […]
Continue readingAuthor: kevin
Output the Date in a Windows Batch Script
This simple script will output the date in the MMDDYYYY format. The script can be used to enhance other scripts, for log files, etc. @echo […]
Continue readingFunction to Create an Array from Database Results in PHP
This simple function will create an array out of the multi-dimensional rows returned from a database query. function mysql_fetch_array_r($result,$result_type=MYSQL_NUM) { $arr = array(); for($i=0;$i<@mysql_num_rows($result);$i++) { […]
Continue readingFunction to Format a Date in PHP
This is a really simple function to format a date. function date_formatter($date) { return date(“Y-m-d G:i:s”,$date); }
Continue readingOutput File Size in PHP
Pass a file size to this function like this: $filesize = get_file_size(2048); And return a nicely formatted file size: 2 MB // function to get […]
Continue readingScript to Set a Proxy Server
This VBScript will set a user’s proxy on a Windows XP workstation. This is great for login scripts. The script will enable the proxy, set […]
Continue readingScript to Zip Log Files
This is a very simple VBScript that will zip all files and folders within a specified folder. This script is useful if you want to […]
Continue readingRead Each Line of a File with VBScript
A very useful script that will read each line of a text file and output the results. I use this for everything from reading log […]
Continue readingInactive Replication Subscriptions
If database replication has been disconnected for too long, the subscription may become inactive. The error message may read: “The subscription(s) have been marked inactive […]
Continue reading