public function contribution($id = "") { $data = array(); $sql = "select `contributions`.* from `contributions` where `contributions`.`id`='" . mysql_real_escape_string($id) . "' and `contributions`.`table`='investment_orgs' "; $q = $this->db->query($sql); $contribution = $q->result_array(); $contribution = $contribution[0]; if ($contribution['id']) { $investment_org = json_decode($contribution['json_data']); $investment_org = objectToArray($investment_org); $sql = "select * from `web_users` where `id`=" . $this->db->escape($contribution['web_user_id']); $q = $this->db->query($sql); $web_user = $q->result_array(); $web_user = $web_user[0]; $web_user = getWebUser($web_user); $data['web_user'] = $web_user; } if ($web_user) { $data['contribution'] = $contribution; $sql = "select * from `categories`"; $q = $this->db->query($sql); $categories = $q->result_array(); $data['categories'] = $categories; $sql = "select * from `countries`"; $q = $this->db->query($sql); $countries = $q->result_array(); $sql = "select distinct `code`, `currency` from `currencies` where LOWER(`currency`) not like 'uses%'"; $q = $this->db->query($sql); $currencies = $q->result_array(); $data['currencies'] = $currencies; $data['countries'] = $countries; $people = array(); if (is_array($investment_org['p_ids'])) { foreach ($investment_org['p_ids'] as $key => $value) { $sql = "select * from `people` where `id`='" . mysql_real_escape_string($value) . "'"; $q = $this->db->query($sql); $p = $q->result_array(); $p = $p[0]; $person = array(); $person['investment_org_id'] = $investment_org_id; $person['person_id'] = $value; $person['role'] = $investment_org['p_roles'][$key]; $person['start_date'] = $investment_org['p_start_dates'][$key]; $person['start_date_ts'] = strtotime($investment_org['p_start_dates'][$key]); $person['end_date'] = $investment_org['p_end_dates'][$key]; $person['end_date_ts'] = strtotime($investment_org['p_end_dates'][$key]); $person['name'] = $p['name']; $person['slug'] = $p['slug']; $people[] = $person; } } $data['people'] = $people; //remove arrays $unsets = array(); foreach ($investment_org as $key => $value) { if (is_array($value)) { $unsets[] = $key; } } foreach ($unsets as $key) { unset($investment_org[$key]); } $data['investment_org'] = $investment_org; $data['content'] = $this->load->view('investment_orgs/add', $data, true); $this->load->view('layout/main', $data); } }
<?php @session_start(); $myaccount = false; if (!$user) { $user = getWebUser($_SESSION['web_user']); $myaccount = true; } ?> <table cellpadding="0" cellspacing="0" class="p100"> <tr> <td class="contents2"> <table cellpadding="0" cellspacing="0" class='p100'> <tr> <td class='breadcrumbs' colspan="3"> <a href='<?php echo site_url(); ?> '>Home</a> > <?php echo "<a href='" . site_url() . "account/" . $user['id'] . "'>" . $user['name'] . "</a>"; ?> > Account </td> </tr> <tr> <td class='account_left'> <?php if (trim($user['img'])) { ?> <table cellpadding="0" cellspacing="0" class="p100">
function account($userid = "") { $data = array(); if ($_SERVER['HTTP_HOST'] == 'localhost' && !$_SESSION['web_user']) { $_SESSION['web_user'] = unserialize('a:7:{s:2:"id";s:1:"5";s:5:"fb_id";s:15:"100004077843297";s:8:"fb_email";s:21:"*****@*****.**";s:7:"fb_data";s:284:"{"id":"100004077843297","name":"Jerome Lee","first_name":"Jerome","last_name":"Lee","link":"http://www.facebook.com/jerome.lee.98892","username":"******","gender":"male","email":"*****@*****.**","timezone":8,"locale":"en_US","updated_time":"2012-07-11T10:27:49 0000"}";s:10:"fb_friends";s:1316:"{"data":[{"name":"Sasha Fox","id":"100000505245095"},{"name":"Mikee Dela Peña Guarino","id":"100000629589263"},{"name":"Carla Villa","id":"100000851593945"},{"name":"Faye Santos","id":"100002110669999"},{"name":"Romnick Edullantes","id":"100002143982649"},{"name":"Szophisticated Rhoze Genuiztah","id":"100002518556374"},{"name":"Ingrid Mendoza Rivera","id":"100002938532983"},{"name":"Rendell Paulo","id":"100002974236892"},{"name":"Jeany Masangkay","id":"100003194877986"},{"name":"Muniquinn Doll","id":"100003516535179"},{"name":"Shäina Rose Besa IV","id":"100003549304942"},{"name":"Shiela Marie Echavez","id":"100003569125646"},{"name":"Yandii Olid III","id":"100003574885667"},{"name":"Jullian Delrosario","id":"100003588335313"},{"name":"Lyra Farro","id":"100004101694332"},{"name":"Marjorie Orbase","id":"100004191425468"},{"name":"Junaina Gon","id":"100004307443721"},{"name":"Samantha Moh","id":"100004431932704"},{"name":"Ann Sarap","id":"100004483902375"},{"name":"Ganda MaLdita","id":"100004629572460"},{"name":"Mahal Khani Khate","id":"100004682401219"},{"name":"Arnie Samonte","id":"100004688465647"}],"paging":{"next":"https://graph.facebook.com/100004077843297/friends?access_token=AAAB7W3LmGYIBACvqZCfHc5VqzaN0QlzmQ657WBhjDEvgojWZCyUBgnSfVScl6vaTdcaQKOhrAMemv97aVsM2YFQPXU8ypwmqdB3P1q3kvuPVc5RNX8";s:9:"dateadded";s:19:"2012-12-04 14:21:52";s:11:"dateupdated";s:19:"2012-12-06 13:20:50";}'); } if (!$_SESSION['web_user'] && !$_SESSION['user']) { header('HTTP/1.1 301 Moved Permanently'); header("Location: " . site_url()); exit; } if (!$userid) { $userid = $_SESSION['web_user']['id']; } if ($userid) { $sql = "select * from `web_users` where `id`='" . mysql_real_escape_string($userid) . "'"; $q = $this->db->query($sql); $web_user = $q->result_array(); $web_user = $web_user[0]; if ($web_user['id']) { $data['user'] = getWebUser($web_user); } } $sql = "select * from `revisions` where `web_user_id`='" . mysql_real_escape_string($web_user['id']) . "' order by `dateupdated_ts` desc limit 20"; $q = $this->db->query($sql); $revisions = $q->result_array(); $data['revisions'] = $revisions; $sql = "select * from `contributions` where `web_user_id`='" . mysql_real_escape_string($web_user['id']) . "' order by `dateupdated_ts` desc limit 20"; $q = $this->db->query($sql); $contributions = $q->result_array(); $data['contributions'] = $contributions; $data['content'] = $this->load->view('startuplist/account', $data, true); $this->load->view('startuplist/main', $data); }
<?php echo "<a href='" . site_url() . "investment_org/" . $investment_org['slug'] . "/" . $investment_org['id'] . "'>" . $investment_org['name'] . "</a>"; ?> Revisions </td> </tr> <tr> <td class="description"> <?php if (is_array($revisions)) { foreach ($revisions as $key => $revision) { $sql = "select * from `web_users` where `id`=" . $this->db->escape($revision['web_user_id']); $q = $this->db->query($sql); $web_user = $q->result_array(); $web_user = $web_user[0]; $web_user = getWebUser($web_user); $approved = ""; if ($revision['approved'] == '1') { $approved = "<a style='color:green' class='bold'>APPROVED</a>"; } else { if ($revision['approved'] == '-1') { $approved = "<a style='color:red' class='bold'>REJECTED</a>"; } else { $approved = "<a style='color:black' class='bold'>PENDING</a>"; } } echo "<div class='revision padb5'>[ " . date("M d, Y H:i:s", $revision['dateupdated_ts']) . " ] Revision submitted by <a href='" . site_url() . "account/" . $web_user['id'] . "'>" . $web_user['name'] . "</a> ... {$approved} </div>"; } } ?>
</div> <div class='list'> <table> <tr> <th style="width:20px"></th> <th>Login E-mail / Business E-mail</th> <th>Name</th> <th>Type</th> <th>Date Added</th> <th></th> </tr> <?php $t = count($web_users); for ($i = 0; $i < $t; $i++) { $user = getWebUser($web_users[$i]); if (!trim($user['name'])) { continue; } ?> <tr id="tr<?php echo htmlentitiesX($user['id']); ?> " class="row" > <td><?php echo $start + $i + 1; ?> </td> <td> <?php if (trim($user['business_email'])) {
function sendApproveContrib($contrib_id, $person_id) { $sql = "select * from `people` where `id`='" . mysql_real_escape_string($person_id) . "'"; $q = $this->db->query($sql); $person = $q->result_array(); $person = $person[0]; $sql = "select * from `web_users` where `id` in (select `web_user_id` from `contributions` where `id`='" . mysql_real_escape_string($contrib_id) . "')"; $q = $this->db->query($sql); $web_user = $q->result_array(); $web_user = $web_user[0]; $user = getWebUser($web_user); $emailtos = array(); $name = $user['name']; $zemail = trim(strtolower($web_user['email'])); $business_email = trim(strtolower($web_user['business_email'])); $fb_email = trim(strtolower($web_user['fb_email'])); $emails = array(); if ($zemail) { if (!in_array($zemail, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $zemail; $emailtos[] = $email; $emails[] = $zemail; } } if ($business_email) { if (!in_array($business_email, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $business_email; $emailtos[] = $email; $emails[] = $business_email; } } if ($fb_email) { if (!in_array($fb_email, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $fb_email; $emailtos[] = $email; $emails[] = $fb_email; } } if (count($emailtos) && $person['id']) { $from = "*****@*****.**"; $fromname = "27x"; $subject = "Your Submission is now Online"; $template = array(); $template['data'] = array(); $template['data']['content'] = "Hi {$name},\n\n\t\t\tYour 27x Startup List contribution <b>" . $person['name'] . "</b> is now accessible <a href='http://27x.co/person/" . $person['slug'] . "'>http://27x.co/person/" . $person['slug'] . "</a>\n\n\t\t\tYou can edit it further by:\n\t\t\t\n\t\t\ta) Checking that the general information is complete.\n\t\t\tb) Adding career details.\n\t\t\tc) Adding a profile image of the person.\n\t\t\td) Make sure associated investment organization is updated.\n\t\t\t\n\t\t\t\n\t\t\tYou can also follow any changes made to this person's data by viewing the Revision History\n\t\t\t<a href='http://27x.co/editperson/" . $person['id'] . "/revisions'>http://27x.co/editperson/" . $person['id'] . "/revisions</a>\n\t\t\t\n\t\t\t\n\t\t\tThanks!\n\t\t\t\n\t\t\t- 27x Team\n\t\t\t<a href='http://27x.co'>27x.co</a>\n\t\t\t"; $template['data']['content'] = nl2br($template['data']['content']); //$template['data'] = json_encode($template['data']); $template['slug'] = "startuplist-wrap"; send_email($from, $fromname, $emailtos, $subject, $message, $template); } }
function sendApproveContrib($contrib_id, $company_id) { $sql = "select * from `companies` where `id`='" . mysql_real_escape_string($company_id) . "'"; $q = $this->db->query($sql); $company = $q->result_array(); $company = $company[0]; $sql = "select * from `web_users` where `id` in (select `web_user_id` from `contributions` where `id`='" . mysql_real_escape_string($contrib_id) . "')"; $q = $this->db->query($sql); $web_user = $q->result_array(); $web_user = $web_user[0]; $user = getWebUser($web_user); $emailtos = array(); $name = $user['name']; $zemail = trim(strtolower($web_user['email'])); $business_email = trim(strtolower($web_user['business_email'])); $fb_email = trim(strtolower($web_user['fb_email'])); $emails = array(); if ($zemail) { if (!in_array($zemail, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $zemail; $emailtos[] = $email; $emails[] = $zemail; } } if ($business_email) { if (!in_array($business_email, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $business_email; $emailtos[] = $email; $emails[] = $business_email; } } if ($fb_email) { if (!in_array($fb_email, $emails)) { $email = array(); $email['name'] = $name; $email['email'] = $fb_email; $emailtos[] = $email; $emails[] = $fb_email; } } if (count($emailtos) && $company['id']) { $from = "*****@*****.**"; $fromname = "27x"; $subject = "Your Submission is now Online"; $template = array(); $template['data'] = array(); $template['data']['content'] = "Hi {$name},\r\n\r\n\t\t\tYour 27x Startup List contribution <b>" . $company['name'] . "</b> is now accessible <a href='http://27x.co/company/" . $company['slug'] . "'>http://27x.co/company/" . $company['slug'] . "</a>\r\n\r\n\t\t\tYou can edit it further by:\r\n\t\t\t\r\n\t\t\ta) Checking that the general information is complete\r\n\t\t\tb) Adding funding milestones for this company \r\n\t\t\tc) Adding a screenshot of the company's products.\r\n\t\t\td) Make sure the funding data is up-to-date.\r\n\t\t\te) Fill out profiles for the executive team and linking them to the company.\r\n\t\t\t\r\n\t\t\t\r\n\t\t\tYou can also follow any changes made to this company's data by viewing the Revision History\r\n\t\t\t<a href='http://27x.co/editcompany/" . $company['id'] . "/revisions'>http://27x.co/editcompany/" . $company['id'] . "/revisions</a>\r\n\t\t\t\r\n\t\t\t\r\n\t\t\tThanks!\r\n\t\t\t\r\n\t\t\t- 27x Team\r\n\t\t\t<a href='http://27x.co'>27x.co</a>\r\n\t\t\t"; $template['data']['content'] = nl2br($template['data']['content']); //$template['data'] = json_encode($template['data']); $template['slug'] = "startuplist-wrap"; send_email($from, $fromname, $emailtos, $subject, $message, $template); } }