function consolidateDB($db_name, $file_display, $file_original, $file_thumb, $files_total) { global $rsgConfig; require_once JPATH_RSGALLERY2_ADMIN . '/config.rsgallery2.php'; $file_diff = array_diff($files_total, $db_name); ?> <script language="Javascript"> function db_create() { alert('Database creation does not work yet!'); } function db_createX() { var form = document.adminForm; form.t_id.value = t_id; form.g_id.value = g_id; form.submit(); } </script> <form method="post" action="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=createDbEntries" name="adminForm"> <input type="hidden" name="t_id" value="" /> <input type="hidden" name="g_id" value="" /> <table width="100%" border="0"> <tr> <td width="15%"> </td> <td width="70%"> <table class="adminlist" border="0"> <tr> <td colspan="9" align="center"> <div style="clear: both; margin: 3px; margin-top: 10px; padding: 5px 15px; display: block; float: left; border: 1px solid #cc0000; background: #ffffcc; text-align: left; width: 80%;"> <p style="color: #CC0000;"> <img src="<?php echo JURI_SITE; ?> /includes/js/ThemeOffice/warning.png" alt="Warning icon" /> NOTICE:<br />Experimental at this stage. Single image regeneration works. <br /> Database entries do NOT work!. <?php //echo JText::_('CONSDB_NOTICE'); ?> </p> </div> <div class='rsg2-clr'> </div> </td> </tr> <tr> <th>#</th> <th><?php echo JText::_('Filename'); ?> </th> <th align="center"><?php echo JText::_('In<br>database'); ?> </th> <th align="center"><?php echo JText::_('Display<br>folder'); ?> </th> <th align="center"><?php echo JText::_('Original<br>folder'); ?> </th> <th align="center"><?php echo JText::_('Thumb<br>folder'); ?> </th> <th> </th> <th align="center"><?php echo JText::_('Image'); ?> </th> <th align="center"><?php echo JText::_('Action'); ?> </th> </tr> <tr> <td colspan="9"> </td> </tr> <?php $yes = "<td align=\"center\"><img src=\"" . JURI_SITE . "administrator/images/tick.png\" alt=\"" . JText::_('Image in folder') . "\" border=\"0\"></td>"; $no = "<td align=\"center\"><img src=\"" . JURI_SITE . "administrator/images/publish_x.png\" alt=\"" . JText::_('Image NOT in folder') . "\" border=\"0\"></td>"; $z = 0; $c = 0; //Check database and crossreference against filesystem foreach ($db_name as $name) { $c++; $i = 0; $fid = galleryUtils::getFileIdFromName($name); $html = "<tr><td><input type=\"checkbox\" id=\"cb{$c}\" name=\"xid[]\" value=\"{$name}\" onclick=\"isChecked(this.checked);\" /></td><td>{$name}</td>" . $yes; if (in_array($name, $file_display)) { $i++; $html .= $yes; $display = true; } else { $z++; $html .= $no; $display = false; } if (in_array($name, $file_original)) { $i++; $html .= $yes; $original = true; } else { $z++; $html .= $no; $original = false; } if (in_array($name, $file_thumb)) { $i++; $html .= $yes; $thumb = true; } else { $z++; $html .= $no; $thumb = false; } if ($i < 3) { echo $html; ?> <td> </td> <td> <img src="<?php echo imgUtils::getImgThumb($name); ?> " name="image" width="<?php echo $rsgConfig->get('thumb_width'); ?> " alt="<?php echo $name; ?> "/> </td> <td align="center"> <a href="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=deleteImages&name=<?php echo $name; ?> "><?php echo '[ ' . JText::_('Delete_from_database') . ' ]'; ?> </a><br /> <?php if ($original == true or $display == true) { ?> <a href="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=createImages&id=<?php echo $fid; ?> "><?php echo '[ ' . JText::_('Create_missing_images') . ' ]'; ?> </a> <?php } ?> </td></tr> <?php } else { continue; } } ?> </tr> <?php $zz = 0; $t = 0; //Check filesystem and crossreference against database foreach ($file_diff as $diff) { $t++; $y = 0; $html2 = "<tr><td><input type=\"checkbox\" id=\"cb{$t}\" name=\"xid[]\" value=\"{$t}\" onclick=\"isChecked(this.checked);\" /></td><td><font color=\"#FF0000\">{$diff}</font></td>{$no}"; if (in_array($diff, $file_display)) { $y++; $html2 .= $yes; $display2 = true; } else { $zz++; $html2 .= $no; $display2 = false; } if (in_array($diff, $file_original)) { $y++; $html2 .= $yes; $original2 = true; } else { $zz++; $html2 .= $no; $original2 = false; } if (in_array($diff, $file_thumb)) { $y++; $html2 .= $yes; $thumb2 = true; } else { $zz++; $html2 .= $no; $thumb2 = false; } if ($y < 4) { echo $html2; ?> <td> <?php echo galleryUtils::galleriesSelectList(NULL, 'gallery_id[]', false, false); ?> <input type="hidden" name="name[]" value="<?php echo $diff; ?> " /> </td> <td> <img src="<?php echo imgUtils::getImgThumb($diff); ?> " name="image" width="<?php echo $rsgConfig->get('thumb_width'); ?> " /> </td> <td align="center"> <a href="javascript:void();" onClick="javascript:db_create();"><?php echo '[ ' . JText::_('Create_Database_entry') . ' ]'; ?> </a><br /> <a href="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=deleteImages&name=<?php echo $diff; ?> "><?php echo '[ ' . JText::_('Delete_images'), ' ]'; ?> </a> <?php if ($original2 == true and $display2 == true and $thumb2 == true) { continue; } else { ?> <br /><a href="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=createImages&name=<?php echo $diff; ?> "><?php echo '[ ' . JText::_('Create missing images') . ' ]'; ?> </a> <?php } ?> </td> <?php } else { continue; } } if ($t == 0 and $z == 0) { echo "<tr><td colspan=\"8\"><font color=\"#008000\"><strong>" . JText::_('No inconsistencies in database') . "</strong></font></td>"; } ?> </tr> <tr> <th colspan="9" align="center"> <a href="index2.php?option=com_rsgallery2&rsgOption=maintenance&task=consolidateDB">Refresh</a> </th> </tr> <!-- <tr> <td colspan="2"><input type="checkbox" name="toggle" value="" onclick="checkAll(<?php echo count($db_name) + count($file_diff); ?> );" /></td> <td colspan="5"> With selection:<br /> <a href="javascript:void();" onClick="javascript:alert('<?php echo JText::_('Not working yet'); ?> ');"><?php echo JText::_('Delete from filesystem'); ?> </a> | <a href="javascript:void();" onClick="javascript:alert('<?php echo JText::_('Not working yet'); ?> ');"><?php echo JText::_('Create missing images'); ?> </a> | <a href="javascript:void();" onClick="javascript:alert('<?php echo JText::_('Not working yet'); ?> ');"><?php echo JText::_('Create database entries'); ?> </a> </td> </tr> --> </table> </td> <td width="15%"> </td> </tr> </table> </form> <?php }