function getMembershipRequests()
{
/**
* only admins can get it
*/
//$this->_makeAdminControl();
$to_return = array();
$res =& $this->Database->getAll("SELECT member_id, comment FROM membership_requests", array(), 2);
if (PEAR::isError($res)) {
die($res->getMessage());
}
foreach ($res as $r) {
$email =& $this->Database->getOne("SELECT email FROM members WHERE member_id='{$r['member_id']}'");
if (PEAR::isError($email)) {
die($email->getMessage());
}
_filter_res_var($r['member_id']);
_filter_res_var($email);
_filter_res_var($r['comment']);
$to_return[] = array('id' => $r['member_id'], 'email' => $email, 'comment' => $r['comment']);
}
return $to_return;
}
function getWall($member_id)
{
global $access_isGroupAdmin;
global $access_isGroupMember;
_filter_var($member_id);
// now filter member_id
// if it is set to be -1
// then this means we'll use a random
// value
// FOR NOW: not random; the first user..
if ($member_id == -1) {
$ms = $this->getPeople();
if ($ms == null || sizeof($ms) < 1) {
die('Error');
// should be impossible!
}
$member_id = $ms[0]['id'];
}
$html = "";
// we'll return this
$comments = $this->getComments($member_id);
if (sizeof($comments) > 0) {
if ($access_isGroupMember) {
$html .= <<<EOS
\t <div style="text-align:center;">
\t\t\t<form style="margin:0">
\t\t\t<input type="hidden" id="wallid" value="{$member_id}" />
\t<textarea id="mycomment" style="width:95%;height:100px;" onfocus="empty_wall(this)">Write something on my wall...</textarea>
\t<br /><input type="button" value="Post" style="width:95%" onclick="make_wall_comment()" />
\t</form>
\t</div>
\t
\t<p> </p>
\t
EOS;
}
foreach ($comments as $comment) {
$cmt = $comment['comment'];
//parse_bbcode($cmt);
_filter_res_var($cmt);
$html .= "<div style=\"margin-bottom:20px;\">";
$html .= "<div style=\"margin-bottom:5px;font-weight:bold;font-size:1.1em;background:#ddd;\">";
$html .= "<img src=\"{$comment['icon']}\" border=\"0\" width=\"16\" height=\"16\" alt=\"\" /> ";
$html .= "<a href=\"javascript:void(popUp('http://grou.ps/msg.do?to={$comment['author_username']}&group={}&toname={$comment['author']}'))\">{$comment['author']}</a> {$comment['date']}</div>";
$html .= $cmt;
if ($access_isGroupAdmin || $access_isGroupMember && ($this->isCommentOwner($comment['id']) || $this->isCommentSubject($comment['id']))) {
$html .= "<p><button onclick=\"comment_delete({$comment['id']})\"><img src=\"http://grou.ps/images/delete.gif\" align=\"absbottom\"/> Delete</button></p>";
}
$html .= "</div>";
//$html .= "<hr />";
}
} else {
if ($access_isGroupMember) {
$html .= <<<EOS
\t
\t<script>
\tvar initial_wall_value = 1;
\tfunction empty_wall(obj) {
\t\tif(initial_wall_value==1) {
\t\t\tobj.value="";
\t\t\tinitial_wall_value = 0;\t
\t\t}
\t}
\t</script>
\t
\t\t\t<form style="margin:0">
\t\t\t<input type="hidden" id="wallid" value="{$member_id}" />
\t<p><textarea id="mycomment" style="width:100%;height:100px;" onfocus="empty_wall(this)">Be the first to write something on my wall...</textarea></p>
\t<p><input type="button" value="Post" style="width:100%" onclick="make_wall_comment()" /></p>
\t</form>
\t
EOS;
} else {
$html .= "<center><img src=\"http://grou.ps/images/nodata.png\" alt=\"No Data\" border=\"0\" /></center>";
}
}
return $html;
}
\t\t\t\t\t<table width="100%" border="0" cellpadding="10" cellspacing="0">
<col style="width:200px;" />
<col style="width:auto;" />
<tr>
<th align="left">{$temp_translation_string_1}</th>
<th align="left">{$temp_translation_string_2}</th>
</tr>
EOS;
$userid = _getMemberID($_SESSION['valid_user']);
$im = new InternalMessages();
$msgs = $im->getOutgoingMessages($userid);
$i = 0;
$r = "";
foreach ($msgs as $msg) {
$res_msg = $msg['msg'];
_filter_res_var($res_msg);
$res_msg = nl2br($res_msg);
$res_counter = "";
$subj_username = _getMemberUsername($msg['to']);
$subj = new User($subj_username);
$res_counter = $subj->getEmail();
$res_date = getStyledDateDiff($msg['date'], date('Y-m-d'));
$i++;
if ($i % 2 == 0) {
$r = " style=\"background-color:#eee;\"";
} else {
$r = "";
}
$html .= <<<EOS
<tr{$r}>
/**
* This function returns absolute URL of the avatar
*/
function getMapMarker($group_name, $type = '')
{
global $app_base;
// we'll return absolute URL of the
// avatar
$addr = "";
if ($type == 'souvenir') {
$addr_base = "http://grou.ps/avatars/%s/marker.png";
$addr_file = $app_base . "avatars/%s/marker.png";
} elseif ($type == 'current_location') {
$addr_base = "http://grou.ps/avatars/%s/marker-blue.png";
$addr_file = $app_base . "avatars/%s/marker-blue.png";
} else {
$addr_base = "http://grou.ps/avatars/%s/marker.png";
$addr_file = $app_base . "avatars/%s/marker.png";
}
$membership_id = $this->getMembershipID($group_name);
$avatar =& $this->Database->getOne("SELECT avatar FROM memberships WHERE membership_id='{$membership_id}'");
if (PEAR::isError($avatar)) {
die($avatar->getMessage());
}
_filter_res_var($avatar);
$avatar = intval($avatar);
// one of the defaul avatars
// when the avatar # increases
// the 15 number SHOULD change also
if ($avatar >= 1 && $avatar <= 15) {
$iid = "b";
// $iid = "a{$avatar}"; // aTOb
$addr = sprintf($addr_base, $iid);
return $addr;
} elseif ($avatar == -1) {
$addr = sprintf($addr_base, $membership_id);
$addr_file = sprintf($addr_file, $membership_id);
if (!file_exists($addr_file)) {
// default pict
$addr = sprintf($addr_base, "b");
// $addr = sprintf($addr_base, "a12"); // aTOb
return $addr;
} else {
return $addr;
}
return $addr;
} else {
// default pict
$addr = sprintf($addr_base, "b");
// $addr = sprintf($addr_base, "a12"); // aTOb
return $addr;
}
}
