<?php
require_once dirname(__FILE__).'/accesscheck.php';

if (isset($_GET['delete'])) {
  # delete the index in delete
  $delete = sprintf('%d',$_GET['delete']);
  print $GLOBALS['I18N']->get('Deleting')." $delete ...\n";
  $result = Sql_query("delete from ".$tables["template"]." where id = $delete");
  $result = Sql_query("delete from ".$tables["templateimage"]." where template = $delete");
  print "... ".$GLOBALS['I18N']->get('Done')."<br /><hr /><br />\n";
}
if (isset($_POST['defaulttemplate'])) {
  saveConfig('defaultmessagetemplate',sprintf('%d',$_POST['defaulttemplate']));
}
if (isset($_POST['systemtemplate'])) {
  saveConfig('systemmessagetemplate',sprintf('%d',$_POST['systemtemplate']));
}

$req = Sql_Query("select * from {$tables["template"]} order by listorder");
if (!Sql_Affected_Rows())
  print '<p class="information">'.$GLOBALS['I18N']->get("No template have been defined").'</p>';

$defaulttemplate = getConfig('defaultmessagetemplate');
$systemtemplate = getConfig('systemmessagetemplate');
print formStart('name="templates" class="templatesEdit" ');
$ls = new WebblerListing($GLOBALS['I18N']->get("Existing templates"));
while ($row = Sql_fetch_Array($req)) {
  $img_template = '<img src="images/no-image-template.png" />';
  if(file_exists('templates/'.$row['id'].'.jpg')){ $img_template = '<img src="templates/'.$row['id'].'.jpg" />';}
  $element = $row['title'];
  $ls->addElement($element,PageUrl2('template&amp;id='.$row['id']));
  $ls->setClass($element,'row1');
  $ls->addColumn($element,$GLOBALS['I18N']->get('ID'),$row['id']);
  $ls->addRow($element,$img_template,'<span class="button">'.PageLinkDialogOnly("viewtemplate&amp;id=".$row["id"],$GLOBALS['img_view']).'</span>'.sprintf('<span class="delete"><a class="button" href="javascript:deleteRec(\'%s\');" title="'.$GLOBALS['I18N']->get('delete').'">%s</a>',PageUrl2("templates","","delete=".$row["id"]),$GLOBALS['I18N']->get('delete')));
#  $imgcount = Sql_Fetch_Row_query(sprintf('select count(*) from %s where template = %d',
#    $GLOBALS['tables']['templateimage'],$row['id']));
#  $ls->addColumn($element,$GLOBALS['I18N']->get('# imgs'),$imgcount[0]);
#  $ls->addColumn($element,$GLOBALS['I18N']->get('View'),);
  $ls->addColumn($element,$GLOBALS['I18N']->get('Campaign Default'),sprintf('<input type=radio name="defaulttemplate" value="%d" %s onchange="document.templates.submit();">',
    $row['id'],$row['id'] == $defaulttemplate ? 'checked':''));
  $ls->addColumn($element,$GLOBALS['I18N']->get('System'),sprintf('<input type=radio name="systemtemplate" value="%d" %s onchange="document.templates.submit();">',
    $row['id'],$row['id'] == $systemtemplate ? 'checked':''));

}
print $ls->display();

print '</form>';

print '<p class="button">'.PageLink2("template",$GLOBALS['I18N']->get('Add new Template'))."</p>";

$exists = Sql_Fetch_Row_Query(sprintf('select * from %s where title = "System Template"',$GLOBALS['tables']['template']));
if (empty($exists[0])) {
  print '<p class="button">'.PageLink2("defaultsystemtemplate",$GLOBALS['I18N']->get('Add default system template'))."</p>";
}

