$ls->addElement($row["id"]); $ls->addColumn($row["id"], $GLOBALS['I18N']->get('filename'), $row["remotefile"]); $ls->addColumn($row["id"], $GLOBALS['I18N']->get('desc'), $row["description"]); $ls->addColumn($row["id"], $GLOBALS['I18N']->get('size'), $row["size"]); $phys_file = $GLOBALS["attachment_repository"] . "/" . $row["filename"]; if (is_file($phys_file) && filesize($phys_file)) { $ls->addColumn($row["id"], $GLOBALS['I18N']->get('file'), $GLOBALS["img_tick"]); } else { $ls->addColumn($row["id"], $GLOBALS['I18N']->get('file'), $GLOBALS["img_cross"]); } $ls->addColumn($row["id"], $GLOBALS['I18N']->get('del'), sprintf('<input type=checkbox name="deleteattachments[]" value="%s">', $row["linkid"])); // Probably need to check security rights here... # $tabletext .= "<td><input type=checkbox name=\"deleteattachments[]\" value=\"".$row["linkid"]."\"></td>"; # $tabletext .= "</tr>\n"; } $ls->addButton($GLOBALS['I18N']->get('delchecked'), "javascript:document.sendmessageform.submit()"); $att_content .= '<tr><td colspan=2>' . $ls->display() . '</td></tr>'; # if ($tabletext) { # print "<tr><td colspan=2><table border=1><tr><td>Filename</td><td>Description</td><td>Size</td><td> </td></tr>\n"; # print "$tabletext"; # print "<tr><td colspan=4 align=\"center\"><input type=submit name=deleteatt value=\"Delete Checked\"></td></tr>"; # print "</table></td></tr>\n"; # } } for ($att_cnt = 1; $att_cnt <= NUMATTACHMENTS; $att_cnt++) { $att_content .= sprintf('<tr><td>%s</td><td><input type=file name="attachment%d"> <input type=submit name="save" value="%s"></td></tr>', $GLOBALS['I18N']->get('newattachment'), $att_cnt, $GLOBALS['I18N']->get('addandsave')); if (FILESYSTEM_ATTACHMENTS) { $att_content .= sprintf('<tr><td><b>%s</b> %s:</td><td><input type=text name="localattachment%d" size="50"></td></tr>', $GLOBALS['I18N']->get('or'), $GLOBALS['I18N']->get('pathtofile'), $att_cnt, $att_cnt); } $att_content .= sprintf('<tr><td colspan=2>%s:</td></tr> <tr><td colspan=2><textarea name="attachment%d_description" cols=65 rows=3 wrap="virtual"></textarea></td></tr>', $GLOBALS['I18N']->get('attachmentdescription'), $att_cnt);
$totalSize = 0; while ($row = Sql_fetch_array($result)) { $ls->addElement($row['id']); $ls->addColumn($row['id'], $GLOBALS['I18N']->get('filename'), $row['remotefile']); $ls->addColumn($row['id'], $GLOBALS['I18N']->get('desc'), $row['description']); $ls->addColumn($row['id'], $GLOBALS['I18N']->get('size'), formatBytes($row['size'])); $totalSize += $row['size']; $phys_file = $GLOBALS['attachment_repository'] . '/' . $row['filename']; if (is_file($phys_file) && filesize($phys_file)) { $ls->addColumn($row['id'], $GLOBALS['I18N']->get('file'), $GLOBALS['img_tick']); } else { $ls->addColumn($row['id'], $GLOBALS['I18N']->get('file'), $GLOBALS['img_cross']); } $ls->addColumn($row['id'], $GLOBALS['I18N']->get('del'), sprintf('<input type="checkbox" name="deleteattachments[]" value="%s"/>', $row['linkid'])); } $ls->addButton(s('Delete checked'), 'javascript:document.sendmessageform.submit()'); $att_content .= '<div>' . $ls->display() . '</div>'; } if (defined('MAX_MAILSIZE') && 3 * $totalSize > MAX_MAILSIZE) { ## the 3 is roughly the size increase to encode the string $att_content .= Warn(s('The total size of attachments is very large. Sending this campaign may fail due to resource limits.')); } for ($att_cnt = 1; $att_cnt <= NUMATTACHMENTS; ++$att_cnt) { $att_content .= sprintf('<div>%s</div><div><input type="file" name="attachment%d"/> <input class="submit" type="submit" name="save" value="%s"/></div>', $GLOBALS['I18N']->get('New Attachment'), $att_cnt, $GLOBALS['I18N']->get('Add (and save)')); if (FILESYSTEM_ATTACHMENTS) { $att_content .= sprintf('<div><b>%s</b> %s:</div><div><input type="text" name="localattachment%d" size="50"/></div>', $GLOBALS['I18N']->get('or'), $GLOBALS['I18N']->get('Path to file on server'), $att_cnt, $att_cnt); } $att_content .= sprintf('<div>%s:</div> <div><textarea name="attachment%d_description" cols="65" rows="3" wrap="virtual"></textarea></div>', $GLOBALS['I18N']->get('Description of attachment'), $att_cnt); } $att_content .= '</div>';
$numdraft = Sql_Num_Rows($req); if ($numdraft > 0 && !isset($_GET['id']) && !isset($_GET['new'])) { print '<p>' . PageLinkActionButton('send&new=1', $I18N->get('start a new message'), '', '', s('Start a new campaign')) . '</p>'; print '<p><h3>' . $I18N->get('Choose an existing draft message to work on') . '</h3></p><br/>'; $ls = new WebblerListing($I18N->get('Draft messages')); $ls->noShader(); while ($row = Sql_Fetch_Array($req)) { $element = '<!--' . $row['id'] . '-->' . $row['subject']; $ls->addElement($element, PageUrl2('send&id=' . $row['id'])); $ls->setClass($element, 'row1'); # $ls->addColumn($element,$I18N->get('edit'),PageLink2('send&id='.$row['id'],$I18N->get('edit'))); $ls->addColumn($element, $I18N->get('entered'), $row['entered']); $ls->addColumn($element, $I18N->get('age'), secs2time($row['age'])); $ls->addRow($element, '', '<a class="del" href="' . PageUrl2('send&delete=' . $row['id']) . '" title="' . $I18N->get('del') . '">' . $I18N->get('del') . '</a>'); } $ls->addButton($I18N->get('delete all'), PageUrl2('send&delete=alldraft')); print $ls->display(); return; } } include "send_core.php"; if ($done) { if ($GLOBALS["commandline"]) { ob_end_clean(); print clineSignature(); print "Message with subject " . $_POST["subject"] . " was sent to " . $lists . "\n"; exit; } return; } /*if (!$_GET["id"]) {
Redirect('list'); } else { Info(s('Categories saved'), true); } } $req = Sql_Query(sprintf('select * from %s %s', $tables['list'], $subselect)); if (!Sql_Affected_Rows()) { Info(s('All lists have already been assigned a category') . '<br/>' . PageLinkButton('list', s('Back')), true); } print '<div class="fright">' . PageLinkButton('catlists&show=all', s('Re-edit all lists')) . '</div>'; print '<div class="fright">' . PageLinkButton('configure&id=list_categories&ret=catlists', $I18N->get('Configure Categories')) . '</div>'; $ls = new WebblerListing(s('Categorise lists')); $aListCategories = listCategories(); if (count($aListCategories)) { while ($row = Sql_Fetch_Assoc($req)) { $ls->addELement($row['id']); $ls->addColumn($row['id'], $GLOBALS['I18N']->get('Name'), stripslashes($row['name'])); $catselect = '<select name="category[' . $row['id'] . ']">'; $catselect .= '<option value="">-- ' . s('choose category') . '</option>'; $catselect .= '<option value="">-- ' . s('none') . '</option>'; foreach ($aListCategories as $category) { $category = trim($category); $catselect .= sprintf('<option value="%s" %s>%s</option>', $category, $category == $row['category'] ? 'selected="selected"' : '', $category); } $catselect .= '</select>'; $ls->addColumn($row['id'], s('Category'), $catselect); } } $ls->addButton(s('save'), 'javascript:document.categoryedit.submit();'); print $ls->display(); print '</form>';
# var_dump( $used_systemattr); foreach ($_SESSION["import_attribute"] as $column => $rec) { /* print '<pre>'; print '<br/>'.$column.'<br/>'; var_dump($rec); print '</pre>'; */ if (trim($column) != '' && !$rec["record"]) { $request_mapping = 1; $ls->addElement($column); $ls->addColumn($column, $GLOBALS['I18N']->get('select'), '<select name="column' . $rec["index"] . '">' . $options . '</select>'); } } if ($request_mapping) { $ls->addButton($GLOBALS['I18N']->get('Continue'), 'javascript:document.importform.submit()'); print '<p class="information">' . $GLOBALS['I18N']->get('Please identify the target of the following unknown columns') . '</p>'; print '<form name="importform" method="post">'; print $ls->display(); print '</form>'; /* print '<pre>'; var_dump($_SESSION['import_attribute']); print '</pre>'; */ return; } } ### show summary if (!empty($_SESSION["test_import"])) { if (!isset($_SESSION["systemindex"]["email"])) {
} $tc++; } } if ($num) { $userselection_query = "select {$select_clause} where {$where_clause}"; # $count_query = addslashes($count_query); if ($_GET["calculate"]) { ob_end_flush(); print "<h3>{$userselection_query}</h3>"; print '<p class="information">Calculating ...'; flush(); $req = Sql_Query($userselection_query); print '.. ' . Sql_Num_Rows($req) . " users apply</p>"; } $ls->addButton("Calculate", $baseurl . '&tab=' . $_GET["tab"] . '&calculate="1"'); $ls->addButton("Reset", $baseurl . '&tab=' . $_GET["tab"] . '&reset="1"'); $existing_criteria = $ls->display(); } $att_js = ' <script language="Javascript" type="text/javascript"> var values = Array(); var operators = Array(); var value_divs = Array(); var value_default = Array(); '; if (sizeof($used_attributes)) { $already_used = ' and id not in (' . join(',', $used_attributes) . ')'; } else { $already_used = ""; }
$ls->addColumn($row["id"],"filename",$row["remotefile"]); $ls->addColumn($row["id"],"desc",$row["description"]); $ls->addColumn($row["id"],"size",$row["size"]); $phys_file = $GLOBALS["attachment_repository"]."/".$row["filename"]; if (is_file($phys_file) && filesize($phys_file)) { $ls->addColumn($row["id"],"file",$GLOBALS["img_tick"]); } else { $ls->addColumn($row["id"],"file",$GLOBALS["img_cross"]); } $ls->addColumn($row["id"],"del",sprintf('<input type=checkbox name="deleteattachments[]" value="%s">',$row["linkid"])); // Probably need to check security rights here... # $tabletext .= "<td><input type=checkbox name=\"deleteattachments[]\" value=\"".$row["linkid"]."\"></td>"; # $tabletext .= "</tr>\n"; } $ls->addButton("Delete Checked","javascript:document.sendmessageform.submit()"); print '<tr><td colspan=2>'.$ls->display().'</td></tr>'; # if ($tabletext) { # print "<tr><td colspan=2><table border=1><tr><td>Filename</td><td>Description</td><td>Size</td><td> </td></tr>\n"; # print "$tabletext"; # print "<tr><td colspan=4 align=\"center\"><input type=submit name=deleteatt value=\"Delete Checked\"></td></tr>"; # print "</table></td></tr>\n"; # } } for ($att_cnt = 1;$att_cnt <= NUMATTACHMENTS;$att_cnt++) { printf ('<tr><td>New Attachment</td><td><input type=file name="attachment%d"> <input type=submit name="save" value="Add (and save)"></td></tr>',$att_cnt); if (FILESYSTEM_ATTACHMENTS) { printf('<tr><td><b>or</b> path to file on server:</td><td><input type=text name="localattachment%d" size="50"></td></tr>',$att_cnt,$att_cnt); } printf ('<tr><td colspan=2>Description of attachment:</td></tr>