Remove Extension PHP

I'm using a Joomla module called JX List Files. Simple, nice little module to list files in a directory. My only complaint was that it left the file extension in the name, so I added this little function I found.

function remext($strName){
 $ext = strchr($strName, '.');
 if($ext !== false){
   $strName = substr($strName, 0, -strlen($ext));
 }
 return $strName;
}

Show/Hide with Select

This isn't complicated, but I forgot how I did it before, so I'm going to write it down this time.

The Case:
I have a form with a select box, if you select Yes, you get one set of options, and No gets another. The two pieces are in divs, both with style=display:none. The dropdown is a required field and it starts as a blank box.

The JavaScript:

function showHide(show, hide){
  document.getElementById(show).style.display='block';
  document.getElementById(hide).style.display='none';
}

The HTML:

<select id="yesno">
 <option>  </option>
 <option value="yes" onclick="showHide('pickYes', 'pickNo')">Yes</option>
 <option value="no" onclick="showHide('pickNo', 'pickYes')">No</option>
</select>
<div id="pickYes" style="display:none">
 I display if Yes is selected
</div>
<div id="pickNo" style="display:none">
 I display if No is selected
</div>

:UPDATE:
Oh man, I totally lied. That only works in Firefox. onclick isn't an option javascript event. Oops. Here's the real solution

Javascript:

function showHide(){
 var sel = document.getElementById('yesno').value;
 if (sel == 'yes'){
   document.getElementById('pickYes').style.display='block';
   document.getElementById('pickNo').style.display='none';
 }
 else if (sel == 'no'){ 
   document.getElementById('pickNo').style.display='block';
   document.getElementById('pickYes').style.display='none';
 }else{ 
   document.getElementById('pickYes').style.display='none';
   document.getElementById('pickNo').style.display='none';
 }
}

HTML:

<select id="yesno" onchange="showHide()">
<option>  </option>
<option value="yes" onclick="showHide('pickYes', 'pickNo')">Yes</option>
<option value="no" onclick="showHide('pickNo', 'pickYes')">No</option>
</select>

So yeah... this isn't as pretty, but it works in other browsers.

ANOTHER UPDATE (from months in the future):

This whole ugliness can be completely avoided by just using JQuery :)

Random CSS Background

The Case:
We have a header background image on the top of the site. The customer wants it to rotate randomly between any number of images.

The Javascript:

var images=new Array();
images[0] = "header1.jpg";
images[1] = "header2.jpg";
images[2] = "header3.jpg";
images[3] = "header4.jpg";
images[4] = "header5.jpg";
var path = "http://example.com/images/";

function changeHeader(){
 var rn=Math.floor(Math.random()*images.length);
 document.getElementById('header').style.background = "url('"+path+images[rn]+"')";
}

And the HTML:

<script type="text/javascript">
window.onload=function(){
 changeHeader();
 setInterval("changeHeader()",5000);
}</script>

Don't forget to set a default image for those who don't use javascript.

Addendum about Sum()

It seems like it's totally okay if you're selecting just the sum to leave out the group by part. I needed to pull data and put it in rows, then show the total on the bottom. I don't know if I necessarily did this the _right_ way, but it worked.

My two queries:

$query1 = "SELECT * FROM table";
$query2 = "SELECT sum(amt) FROM table";

It was in a table so I used a while loop to add rows, then after the loop, added

<tr>
<td>TOTAL</td>
<td>$<?=number_format($row1['sum(pay_amt)'],2)?></td>
</tr>

of course, don't forget to define them. i defined row1 before the while loop.

Notes to Self

Populating a table from csv:

  LOAD DATA LOCAL INFILE '/data.csv'
->INTO TABLE test_table
->FIELDS TERMINATED BY ','
->LINES TERMINATED BY '\r\n'
->(field1, filed2, field3);

Fields for money, use DECIMAL(N,2). N is however long the number will be and 2 is for the cents.

Then use PHP's number_format($number,2) to make it look pretty/readable.

Quick and dirty sum (via tizag):

<?php
$query = "SELECT type, SUM(price) FROM products GROUP BY type";

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

// Print out result
while($row = mysql_fetch_array($result)){
echo "Total ". $row['type']. " = $". $row['SUM(price)'];
echo "<br />";
}
?>

Don't use & in your $_GET var. Do a str_replace to something else (no, not & amp; either), then change it back before the query

Gigundo tables will time out before loading the page

We are 2.6 parsecs from Sirius

Hacking QContacts

For the "Contact us" portion of our sites, we use QContacts instead of the plain Joomla contact module. The main reason is because it has the ability to add more fields to the email form. However, I decided a couple things needed to be changed.

1. It uses a captcha type field using the php secureimage stuff. We need to use something that's ADA Compliant, so I wanted to use ReCaptcha.
2. We have a big, complex site and every page has a "Contact Webmaster" link. Although it specifically says in bold print right at the top of the form to include the link of the page you're talking about, guess how many people do. Yes, about 1%. So, I wanted to add a referring link to the email.
   

Luckily, the code for QContacts is pretty straightforward. There were only two files I needed to change, and one I needed to add (for the ReCaptcha).

ReCaptcha Replacement

Using the recaptcha site as a reference, first we edit the file: /components/com_qcontacts/views/contact/tmpl/default_form.php. This is the page containing the actual form (and the hardest to find the first time). I put the recaptchalib.php file into the same place the original securimage.php file was (com_qcontacts/includes/secureimage). Down near the bottom, there will be the captcha code. it starts

if ($this->params->get('captcha')) {

which the following would replace the original code:

require_once JPATH_COMPONENT . DS . 'includes' . DS . 'securimage' . DS . 'recaptchalib.php';
$publickey = "..."; // you got this from the signup page
echo recaptcha_get_html($publickey);
}

Simple enough. Now, we need to validate the user input. This is in the file com_qcontacts/models/contact.php.

Near the top (around line 40 or so) will start the function __construct(). We need to add the following line:

$this->_data->captcha = JRequest::getString('recaptcha_response_field', '', 'post');

This gets the recaptcha_response_field as a post variable from the previous page. This should replace the existing captcha line. But wait, there's more!

Farther down in the code in this same file is the function __validateInputs and in here is where the captcha is validated. We need to replace the code after

if($sc) {

With

require_once JPATH_COMPONENT . DS . 'includes' . DS . 'securimage' . DS . 'recaptchalib.php';
$privatekey = "...";
$resp = recaptcha_check_answer ($privatekey,
                     $_SERVER["REMOTE_ADDR"],
                     $_POST["recaptcha_challenge_field"],
                     $captcha);

if (!$resp->is_valid) {
$this->setError( JText::_('Security code was incorrect, please try again', true));
return false;
}

So, fairly simple. In the Joomla backend, when you enable captcha, it will be replaced with ReCaptcha. None of the other parameters have any effect anymore. Now for #2.

Adding Referrer

This one is much simpler. We'll start with the same file as the last one (com_qcontacts/views/contact/tmpl/default_form.php).

At the end of the form, add:

<input type="hidden" name="refer" value="<?=$_SERVER['HTTP_REFERER']?>" />

Now on the other page (com_qcontacts/models/contact.php), add a line to function __construct again:

$this->_data->refer = JRequest::getString('refer', '', 'post');

Then find a line in the email creation section. I stuck the code after the show_ip param so it'd be at the end of the email.

$body .= "\r\n\r\n" . JText::_('Referring Page').': '.$this->_data->refer;

And that's it!

JCalPro Multiple Recent Events

This isn't even worth writing about, but it took me forever to figure out, so it's just a reminder.

Using JCalPro and the latest events module is pretty much easy. Just have to keep track of your category IDs and calendar IDs. I wanted mine pretty short, so I turned off everything but Start Time, Category Name and Event Date. I turned on Show Month Separators cause I think it looks nice. I used a <br /> to separate events.

One thing cool I found out was at the bottom, the box for "Specific Itemid for displaying the module" is what controls where the link goes that says "View Full Calendar." Put the calendar ID in there if it's not going to the right one.

So my main problem was, my events weren't showing up! It would just say "There are no upcoming events currently scheduled." I read support forums and almost all said it was a problem with versions. Well, that wasn't it; I'm using Joomla 1.5.10, PHP 5 and JCalPro 2.1.5. I put in some more test dates, and guess what, they showed up! After thinking about it a while, I noticed it was only the recurring events that weren't showing up. Not even the parent events. Hmmm. I looked through the module settings again and saw my problem. I don't know how I passed over it so many times before: