exit;
}
if (isset($_GET["today-zoom-popup"])) {
today_zoom_popup();
exit;
}
if (isset($_GET["left-status"])) {
left_status();
exit;
}
if (isset($_GET["members-query"])) {
member_query_js();
exit;
}
if (isset($_GET["members-query-popup"])) {
member_query();
exit;
}
if (isset($_GET["members-query-list"])) {
member_query_list();
exit;
}
page();
function getDaysInWeek($weekNumber, $year)
{
$time = strtotime($year . '0104 +' . ($weekNumber - 1) . ' weeks');
$mondayTime = strtotime('-' . (date('w', $time) - 1) . ' days', $time);
$dayTimes = array();
for ($i = 0; $i < 7; ++$i) {
$dayTimes[] = strtotime('+' . $i . ' days', $mondayTime);
}
/**
* Return a record from member_publish or the default one if it doesn't exist
* @param $member_id member id (numeric)
* @return assoc array / not stripslashes
*/
function get_member_publish($member_id)
{
$sql = "select member_id, email_publish, website_url, logo_url, phone_publish, fax, description, \n section_flag, publish_address, publish_all\n\t from member_publish\n\t where member_id = '" . addslashes($member_id) . "'";
if (($result = member_query($sql)) !== FALSE) {
$assoc = mysql_fetch_assoc($result);
if ($assoc !== FALSE) {
return $assoc;
}
}
// return an empty default line
// note that the member_id is 0
return array('member_id' => 0, 'email_publish' => '', 'website_url' => '', 'logo_url' => '', 'phone_publish' => '', 'fax' => '', 'description' => '', 'section_flag' => 0, 'publish_address' => 1, 'publish_all' => 0);
}
<?php
require_once '../../functions.php';
$sql = 'SELECT member.id, email, DATE_ADD(max(date_paid),INTERVAL 1 YEAR) as lastdate FROM member INNER JOIN invoice ON member.id=invoice.member_id GROUP BY member.id, member.email HAVING DATE_ADD(max(date_paid),INTERVAL 1 YEAR) < NOW()';
$i = 0;
if ($qry = member_query($sql)) {
while ($row = mysql_fetch_assoc($qry)) {
if ($i != 0) {
echo ', ';
}
echo stripslashes($row['email']);
// echo ' (' . $row['lastdate'] . ')' . "\n";
$i++;
}
}
/**
* Insert or update the member_publish row
* @param id Member id
* @return trure if every thing is ok
*/
function updateMemberPublish($id)
{
if ($id === 0 || !is_numeric($id)) {
return false;
}
$section_flag = 0;
$publish_address = isset($_POST['publish_address']) ? 1 : 0;
$publish_all = isset($_POST['publish_all']) ? 1 : 0;
$description = $_POST['description'];
$website_url = $_POST['website_url'];
$email_publish = $_POST['email_publish'];
$sqlReplaceMemberPublish = 'REPLACE INTO member_publish
SET member_id=\'' . addslashes($id) . '\'
, email_publish=\'' . addslashes($email_publish) . '\'
, website_url=\'' . addslashes($website_url) . '\'
, logo_url=\'' . addslashes($_POST['logo_url']) . '\'
, phone_publish=\'' . addslashes($_POST['phone_publish']) . '\'
, fax=\'' . addslashes($_POST['fax']) . '\'
, description=\'' . addslashes(wintoutf8($description)) . '\'
, section_flag=' . $section_flag . '
, publish_all=' . $publish_all . '
, publish_address=' . $publish_address;
if (member_query($sqlReplaceMemberPublish)) {
return true;
}
return false;
}
