code Archives - Fauxzen.com

September 23, 2015November 17, 2015

Remove Javascript and CSS versioning from WordPress

While trying to optimize my site a while back I came across some issues with Javascript and CSS versions causing caching issues, or rather not being cached. This lack of caching of the Javascript and CSS files was lowering the site score on many testing sites including WebPageTest.

I searched around a bit and came across the following code snippet which will remove most, if not all of the versioning from Javascript and CSS files on your WordPress site.

To enable this you will need add the following code to your themes function.

//* Remove JS/CSS versions
function remove_cssjs_ver( $src ) {
	if( strpos( $src, '?ver=' ) )
		$src = remove_query_arg( 'ver', $src );
	return $src;
}
add_filter( 'style_loader_src', 'remove_cssjs_ver', 1000 );
add_filter( 'script_loader_src', 'remove_cssjs_ver', 1000 );

//* Remove JS/CSS versions

function remove_cssjs_ver( $src ) {

if( strpos( $src, '?ver=' ) )

$src = remove_query_arg( 'ver', $src );

return $src;

}

add_filter( 'style_loader_src', 'remove_cssjs_ver', 1000 );

add_filter( 'script_loader_src', 'remove_cssjs_ver', 1000 );

If you are using a caching plugin such as WP-Super Cache/W3 Total Cache you will need to of course clear your cache before these changes will be shown

June 7, 2011November 17, 2015

WP-Installer Revisited

A while back I started work on WP-Installer.com then I just stopped. No real reason why, but anyways I recently jumped back into the code again. Hope to have a very alpha version up an running in the next couple of days… though it will probably lead into a few weeks. More details will be posted as I make progress.

April 27, 2010November 17, 2015

Adding users from a CSV file to a MySQL database

I recently was hit with an issue where I had to import about 500 employees into a database and having each one added to multiple departments. With the use of an array I was able to write up some pretty simple code to import a CSV file that simply contained “username, realname” into the database. Thought I would post it in case anyone ever needed to do something along these lines.

&lt;?php
include('../config.php');
$departments = array(&quot;department1&quot;, &quot;department2&quot;, &quot;department3&quot;, &quot;department4&quot;);
mysql_connect(&quot;$dbhost&quot;, &quot;$dbuser&quot;, &quot;$dbpass&quot;) or die(mysql_error());
mysql_select_db(&quot;$dbase&quot;) or die(mysql_error());
$handle = fopen(&quot;employees.csv&quot;, &quot;r&quot;);
while (($data = fgetcsv($handle, 5000, &quot;,&quot;)) !== FALSE) {
    foreach ($departments as &amp;$value) {
        $query = &quot;INSERT INTO employees (`id`, `name`, `realname`, `tickets`, `dept`) VALUES (NULL, '$data[0]', '$data[1]', '0', '$value')&quot;;
        $result = mysql_query($query) or die(mysql_error());
        echo $data[1] . ' successfully added to ' . $value . ' department&lt;br&gt;';
    }
}
unset($value);
?&gt;

<?php

include('../config.php');

$departments = array("department1", "department2", "department3", "department4");

mysql_connect("$dbhost", "$dbuser", "$dbpass") or die(mysql_error());

mysql_select_db("$dbase") or die(mysql_error());

$handle = fopen("employees.csv", "r");

while (($data = fgetcsv($handle, 5000, ",")) !== FALSE) {

foreach ($departments as &$value) {

$query = "INSERT INTO employees (`id`, `name`, `realname`, `tickets`, `dept`) VALUES (NULL, '$data[0]', '$data[1]', '0', '$value')";

$result = mysql_query($query) or die(mysql_error());

echo $data[1] . ' successfully added to ' . $value . ' department<br>';

}

unset($value);