0,0 → 1,277 |
<?php |
/************************* |
Coppermine Photo Gallery |
************************ |
Copyright (c) 2003-2005 Coppermine Dev Team |
v1.1 originaly written by Gregory DEMAR |
|
This program is free software; you can redistribute it and/or modify |
it under the terms of the GNU General Public License as published by |
the Free Software Foundation; either version 2 of the License, or |
(at your option) any later version. |
******************************************** |
Coppermine version: 1.3.3 |
$Source: /cvsroot/coppermine/stable/db_ecard.php,v $ |
$Revision: 1.5 $ |
$Author: gaugau $ |
$Date: 2005/04/19 03:17:10 $ |
**********************************************/ |
|
define('IN_COPPERMINE', true); |
define('DB_ECARD_PHP', true); |
global $CONFIG; |
|
require('include/init.inc.php'); |
if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__, 'false'); |
|
$sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : ''; |
$start = isset($_REQUEST['start']) ? $_REQUEST['start'] : ''; |
$count = isset($_REQUEST['count']) ? $_REQUEST['count'] : ''; |
//set default values |
$selectOptions = array(25,50,75,100); |
$sortBy = 'date'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_date']; |
$sortDirectionText = $lang_db_ecard_php['ecard_descending']; |
if (!$start) {$startFrom = '0';}else{$startFrom=$start;} |
if (!$count) {$countTo = $selectOptions[0];}else{$countTo=$count;} |
$tabOutput = ''; |
|
//delete selected ecards |
if (isset($_REQUEST['eid'])) { |
foreach ($_REQUEST['eid'] as $key) { |
//print $key; |
//print "<br>"; |
$query = "DELETE FROM {$CONFIG['TABLE_ECARDS']} WHERE eid='$key'"; |
$result = db_query($query); |
} |
} |
|
switch ($sort) { |
case 'snd' : |
$sortBy = 'sender_name'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_name']; |
break; |
case 'sna' : |
$sortBy = 'sender_name'; |
$sortDirection = 'ASC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_name']; |
break; |
case 'sed' : |
$sortBy = 'sender_email'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_email']; |
break; |
case 'sea' : |
$sortBy = 'sender_email'; |
$sortDirection = 'ASC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_email']; |
break; |
case 'id' : |
$sortBy = 'sender_ip'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_ip']; |
break; |
case 'ia' : |
$sortBy = 'sender_ip'; |
$sortDirection = 'ASC'; |
$sortText = $lang_db_ecard_php['ecard_by_sender_ip']; |
break; |
case 'rnd' : |
$sortBy = 'recipient_name'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_recipient_name']; |
break; |
case 'rna' : |
$sortBy = 'recipient_name'; |
$sortDirection = 'ASC'; |
$sortText = $lang_db_ecard_php['ecard_by_recipient_name']; |
break; |
case 'red' : |
$sortBy = 'recipient_email'; |
$sortDirection = 'DESC'; |
$sortText = $lang_db_ecard_php['ecard_by_recipient_email']; |
break; |
case 'rea' : |
$sortBy = 'recipient_email'; |
$sortDirection = 'ASC'; |
$sortText = $lang_db_ecard_php['ecard_by_recipient_email']; |
break; |
case 'da' : |
$sortBy = 'date'; |
$sortDirection = 'ASC'; |
break; |
} |
|
if ($sortDirection == 'ASC'){$sortDirectionText = $lang_db_ecard_php['ecard_ascending'];} |
|
// determine the total number of entries |
$result = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_ECARDS']}"); |
if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_errors['ecards_empty'], __FILE__, __LINE__, false); |
$totalEcards = mysql_fetch_array($result); |
$totalEcards = $totalEcards[0]; |
$result = db_query("SELECT eid, sender_name, sender_email, recipient_name, recipient_email, link, date, sender_ip FROM {$CONFIG['TABLE_ECARDS']} ORDER BY $sortBy $sortDirection LIMIT $startFrom,$countTo"); |
if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_errors['ecards_empty'], __FILE__, __LINE__, false); |
|
pageheader($lang_db_ecard_php['title']); |
|
$formTarget = cpgGetUrlVars('count'); |
print '<form method="post" name="ecardselect" action="'.$formTarget.'" onSubmit="return defaultagree(this)">'; |
?> |
<script language="javascript" type="text/javascript"> |
<!-- |
function checkAll(field) |
{ |
for (i = 0; i < field.length; i++) |
field[i].checked = true ; |
} |
|
function uncheckAll(field) |
{ |
for (i = 0; i < field.length; i++) |
field[i].checked = false ; |
} |
|
var checkobj |
|
function agreesubmit(el){ |
checkobj=el |
if (document.all||document.getElementById){ |
for (i=0;i<checkobj.form.length;i++){ //hunt down submit button |
var tempobj=checkobj.form.elements[i] |
if(tempobj.type.toLowerCase()=="submit") |
tempobj.disabled=!checkobj.checked |
} |
} |
} |
|
function defaultagree(el){ |
if (!document.all&&!document.getElementById){ |
if (window.checkobj&&checkobj.checked) |
return true |
else{ |
alert("<?php print $lang_db_ecard_php['ecards_delete_confirm']; ?>") |
return false |
} |
} |
} |
|
--> |
</script> |
<?php |
// create tabbed display (non-coppermine standard); maybe this could be changed later using the coppermine standard method |
// step 1: calculate the number of pages |
$pageTotal = ceil($totalEcards/$countTo); |
// step 2: get the current url without 'start' and 'count' |
$urlWithoutStart = $_SERVER["SCRIPT_NAME"]."?"; |
foreach ($_GET as $key => $value) { |
if ($key!='start' && $key!='count'){$urlWithoutStart.= $key . "=" . $value . "&";} |
} |
//print $pageTotal; |
//step 3: loop through the pages & create the links |
for ($page = 1 ; $page <= $pageTotal; $page++) { |
if ($page != $startFrom/$countTo+1) { |
$tabOutput .= '<a href="'.$urlWithoutStart.'start='.($page-1)*$countTo.'&count='.$countTo.'">'; |
} |
else { |
$currentPage = $page; |
$currentStart = ($page-1)*$countTo+1; |
$currentEnd = $currentStart+$countTo-1; |
if ($currentEnd > $totalEcards) {$currentEnd =$totalEcards;} |
} |
$tabOutput .= $page; |
//$tabOutput .= '('.$page.'/'.$startFrom/$countTo.') '; |
if ($page != $startFrom/$countTo+1) { |
$tabOutput .= '</a>'; |
} |
$tabOutput .= ' '; |
} |
$maxPage = $page-1; |
|
|
$tableHeader1 = $lang_db_ecard_php['title']." (".$lang_db_ecard_php['ecard_sorted']." ".$sortText.", ".$sortDirectionText.")"; |
starttable('100%',$tableHeader1,3); |
print '<tr><td class="tableb_compact">'; |
printf($lang_db_ecard_php['ecard_number'], $currentStart, $currentEnd, $totalEcards); |
print '</td><td class="tableb_compact">'; |
if ($maxPage > 1) { |
print $lang_db_ecard_php['ecard_goto_page'].' '; |
print $tabOutput; |
} |
print '</td><td align="right" class="tableb_compact">'; |
print $lang_db_ecard_php['ecard_records_per_page']; |
print ' <select onChange="if(this.options[this.selectedIndex].value) window.location.href=\''.$formTarget.'count=\'+this.options[this.selectedIndex].value;" name="count" class="listbox">'; |
foreach ($selectOptions as $key ) { |
print ' <option value="'.$key.'" '; |
if ($key == $countTo) {print 'selected="selected"';} |
print '>'.$key.'</option>'; |
} |
print ' </select>'; |
print '</td></tr>'; |
endtable(); |
|
print '<br />'; |
|
|
$urlWithoutSort = cpgGetUrlVars('sort'); |
starttable('100%'); |
//print '<table border="1">'; |
print "<tr> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\" rowspan=\"2\"></th> |
<th class=\"tableh1_compact\" colspan=\"3\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_sender']."</th> |
<th class=\"tableh1_compact\" colspan=\"2\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_recipient']."</th> |
<th class=\"tableh1_compact\" rowspan=\"2\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_date']." <a href=\"".$urlWithoutSort."sort=da\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=dd\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
<th class=\"tableh1_compact\" rowspan=\"2\" align=\"left\" valign=\"bottom\"></th> |
</tr>"; |
print "<tr> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_name']." <a href=\"".$urlWithoutSort."sort=sna\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=snd\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_email']." <a href=\"".$urlWithoutSort."sort=sea\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=sed\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_ip']." <a href=\"".$urlWithoutSort."sort=ia\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=id\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_name']." <a href=\"".$urlWithoutSort."sort=rna\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=rnd\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
<th class=\"tableh1_compact\" align=\"left\" valign=\"bottom\">".$lang_db_ecard_php['ecard_email']." <a href=\"".$urlWithoutSort."sort=rea\"><img src=\"images/ascending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_ascending']."\" /></a> <a href=\"".$urlWithoutSort."sort=red\"><img src=\"images/descending.gif\" width=\"9\" height=\"9\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_descending']."\" /></a></th> |
</tr>"; |
$tempClass = ' class="tableb"'; |
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { |
print "\t<tr>\n"; |
print "<td".$tempClass." align=\"center\"><input type=\"Checkbox\" name=\"eid[]\" value=\"".$line['eid']."\" id=\"eidselector\" class=\"checkbox\"></td>\n"; |
print "<td".$tempClass."><b class=\"thumb_caption\">".$line['sender_name']."</b></td>\n"; |
print "<td".$tempClass."><span class=\"thumb_caption\"><a href=\"mailto:".$line['sender_email']."\">".$line['sender_email']."</a></span></td>\n"; |
print "<td".$tempClass."><span class=\"thumb_caption\"><a href=\"http://ws.arin.net/cgi-bin/whois.pl?queryinput=".$line['sender_ip']."\">".$line['sender_ip']."</a></span></td>\n"; |
print "<td".$tempClass."><b class=\"thumb_caption\">".$line['recipient_name']."</b></td>\n"; |
print "<td".$tempClass."><span class=\"thumb_caption\"><a href=\"mailto:".$line['recipient_email']."\">".$line['recipient_email']."</a></span></td>\n"; |
print "<td".$tempClass."><span class=\"thumb_caption\">".strftime($lastcom_date_fmt,$line['date'])."</span></td>\n"; |
print "<td align=\"center\"".$tempClass."><span class=\"thumb_caption\"><a href=\"displayecard.php?data=".$line['link']."\"><img src=\"images/ecard.gif\" width=\"16\" height=\"16\" border=\"0\" alt=\"\" title=\"".$lang_db_ecard_php['ecard_display']."\" /></a></span></td>\n"; |
print "\t</tr>\n"; |
if ($tempClass == ' class="tableb"'){$tempClass = ' class="tableh2"';}else{$tempClass = ' class="tableb"';} |
} |
|
print '<tr><td class="tableh1_compact" align="center"><img src="images/arrow_upleft.gif" width="31" height="22" border="0" alt="" /></td>'; |
print '<td colspan="3" class="tableh1_compact">'; |
print '<input type="button" name="CheckAll" class="button" value="'.$lang_db_ecard_php['check_all'].'" onClick="checkAll(document.ecardselect.eidselector)"> '; |
print '<input type="button" name="UnCheckAll" class="button" value="'.$lang_db_ecard_php['uncheck_all'].'" onClick="uncheckAll(document.ecardselect.eidselector)">'; |
print '</td>'; |
print '<td colspan="4" class="tableh1_compact" align="left">'; |
print '<input type="submit" class="button" name="delete" value="'.$lang_db_ecard_php['ecards_delete_selected'].'" disabled="disabled"> '; |
print '<input name="agreecheck" type="checkbox" onClick="agreesubmit(this)">'.$lang_db_ecard_php['ecards_delete_sure']; |
print '</td>'; |
print '</tr>'; |
endtable(); |
|
print "</form>\n"; |
|
pagefooter(); |
|
|
|
function cpgGetUrlVars($exception) |
// get the url vars |
{ |
$cpgGetUrl = $_SERVER["SCRIPT_NAME"]."?"; |
foreach ($_GET as $key => $value) { |
if ($key!=$exception){$cpgGetUrl.= $key . "=" . $value . "&";} |
} |
return $cpgGetUrl; |
} |
|
?> |