EOT; // Loop through the database content foreach ($newsletter_categories_db as $category_loop => $row) { if ($row['open_for_subscription'] == 'YES') { $open_for_subscription = 'checked="checked"'; } else { $open_for_subscription = ''; } if ($row['public_view'] == 'YES') { $publicly_viewable = 'checked="checked"'; } else { $publicly_viewable = ''; } // Get the number of mailings for this category $mailings_count = newsletter_mailings_per_category($row['category_id']); $number_of_subscriptions = newsletter_subscriptions_per_category($row['category_id']); $newsletter_frequency_options = newsletter_frequency_options($row['frequency_year']); echo <<<EOT \t<tr> \t\t<td align="center"> \t\t\t<input type="hidden" name="cat_id[{$loopCounter}]" value="{$row['category_id']}" /> \t\t\t<input type="checkbox" name="delete[{$loopCounter}]" id="delete{$loopCounter}" value="1" class="checkbox" onclick="if (this.checked) return confirm('{$lang_plugin_newsletter['category_delete_confirmation']}');" /> \t\t</td> \t\t<td> \t\t\t<input type="text" name="name[{$loopCounter}]" id="name{$loopCounter}" class="textinput" size="20" maxlength="100" value="{$row['name']}" /> \t\t</td> \t\t<td> \t\t\t<textarea name="description[{$loopCounter}]" id="description{$loopCounter}" rows="1" cols="40" class="textinput elastic" style="max-height:200px;">{$row['description']}</textarea> \t\t</td> \t\t<td> \t\t\t<input type="checkbox" name="open_for_subscription[{$loopCounter}]" id="open_for_subscription{$loopCounter}" value="1" class="checkbox" {$open_for_subscription} />
\t<tr> \t\t<td valign="top" colspan="3" class="tableb"> \t\t\t{$browse_by_category_output} \t\t</td> \t</tr> EOT; } elseif ($mailing != '') { // Display an individual mailing $result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PREFIX']}plugin_newsletter_mailings WHERE mailing_id='{$mailing}' LIMIT 1"); $mailing_array = mysql_fetch_assoc($result); mysql_free_result($result); $result = cpg_db_query("SELECT * FROM {$CONFIG['TABLE_PREFIX']}plugin_newsletter_categories WHERE category_id='{$mailing_array['category_id']}' LIMIT 1"); $category_array = mysql_fetch_assoc($result); mysql_free_result($result); $date_sent = localised_date($mailing_array['date_sent'], $lang_date['comment']); $number_of_subscriptions = newsletter_subscriptions_per_category($mailing_array['category_id']); if ($number_of_subscriptions == 1) { $number_of_subscriptions = $lang_plugin_newsletter['one_subscription']; } else { $number_of_subscriptions = sprintf($lang_plugin_newsletter['x_subscriptions'], $number_of_subscriptions); } if ($category_array['public_view'] == 'YES' || GALLERY_ADMIN_MODE) { // It's allowed to display that category echo <<<EOT \t<tr> \t\t<td valign="top" class="tableb"> \t\t\t{$lang_plugin_newsletter['subject']} \t\t</td> \t\t<td valign="top" colspan="2" class="tableb"> \t\t <strong>{$mailing_array['subject']}</strong> \t\t</td>