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; }