Adding Charset and Collation to System Info Report

		  <tr>
			<td><?php echo $_lang['database_charset']?></td>
			<td> </td>
			<td><strong><?php 
	$sql1 = "show variables like 'character_set_database'";
    $res = $modx->db->query($sql1);
    $charset = $modx->db->getRow($res, 'num');
    echo $charset[1];			
			?></strong></td>
		  </tr>
		  <tr>
			<td><?php echo $_lang['database_collation']?></td>
			<td> </td>
			<td><strong><?php
    $sql2 = "show variables like 'collation_database'";
    $res = $modx->db->query($sql2);
    $collation = $modx->db->getRow($res, 'num');
    echo $collation[1];
            ?></strong></td>
		  </tr>
[/code

I added the two fields to the $_lang array in the lang files. I have attached the modified files in a zipped archive. Rename your original sysinfo.static.php to keep it, and upload the modified one. Do the same to your manager/includes/lang folder.