$artical1 .= "Please visit to Unfollow project by clicking on following link.<br />\n\t\t\t\t\t<a href='" . $base_url . "browseproject/" . $projectId . "/" . Slug($sel_ProjTitle['projectTitle']) . '/' . "' target='_blank'>Click Here</a><br />";
$artical1 .= "<br /><br />Kind Regards,<br />" . DISPLAYSITENAME . " Team</body></html>";
$subject1 = "Unfollow project At " . DISPLAYSITENAME . "";
$mailbody1 = $artical1;
$headers1 = "MIME-Version: 1.0\r\n";
$headers1 .= "Content-type: text/html\r\n";
$headers1 .= FROMEMAILADDRESS;
@mail(base64_decode($sel_login_user_email1['emailAddress']), $subject1, $mailbody1, $headers1);
}
$sel_project_user = mysql_fetch_assoc($con->recordselect("SELECT * FROM projects WHERE projectId='{$projectId}'"));
$sel_login_user_email = mysql_fetch_assoc($con->recordselect("SELECT * FROM users WHERE userId='" . $sel_project_user['userId'] . "'"));
if ($sel_login_user_email['newFollower'] == 1) {
$artical = "";
$artical = "<html><head><style>.body{font-family:Arial, Helvetica, sans-serif; font-size:12px; }</style></head>";
$artical .= "<body><strong>Hello " . $sel_login_user_email['name'] . ", </strong><br />";
$artical .= "<br />" . $_SESSION['name'] . " has Unfollowed your project " . $sel_ProjTitle['projectTitle'] . ".<br /><br />";
$artical .= "Please visit to Unfollow project by clicking on following link.<br />\n\t\t\t\t\t<a href='" . $base_url . "browseproject/" . $projectId . "/" . Slug($sel_ProjTitle['projectTitle']) . '/' . "' target='_blank'>Click Here</a><br />";
$artical .= "<br /><br />Kind Regards,<br />" . DISPLAYSITENAME . " Team</body></html>";
$subject = $_SESSION['name'] . " Unfollow project At " . DISPLAYSITENAME . "";
$mailbody = $artical;
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html\r\n";
$headers .= FROMEMAILADDRESS;
@mail(base64_decode($sel_login_user_email['emailAddress']), $subject, $mailbody, $headers);
}
redirect($base_url . "browseproject/" . $projectId . "/" . Slug($sel_ProjTitle['projectTitle']) . '/');
}
}
} else {
redirect($base_url . "browseproject/" . $projectId);
}
$sel_project_backer_user = mysql_fetch_assoc($con->recordselect("SELECT * FROM users WHERE userId='" . $sel_project_backers['userId'] . "'"));
if ($sel_project_backer_user['updatesNotifyBackedProject'] == 1) {
$artical = "";
//tableborder { border: 1px solid #CCCCCC; }
$artical = "<html><head><style>.body{font-family:Arial, Helvetica, sans-serif; font-size:12px; }\n\t\t\t.mtext {font-family: Arial, Helvetica, sans-serif;font-size: 12px;color: #333333;text-decoration: none;}\n\t\t\ta { font-family: Arial, Helvetica, sans-serif;font-size: 12px;color: #A11B1B;font-weight: normal;text-decoration: underline;}\n\t\t\ta:hover {font-family: Arial, Helvetica, sans-serif;font-size: 12px;font-weight: normal;color: #A11B1B;text-decoration: none;}\n\t\t\t</style></head>";
$artical .= "<body><strong>Hello " . $sel_project_backer_user['name'] . ", </strong><br />";
$artical .= "<br /><table width='100%' cellspacing='0' cellpadding='0' class='tableborder' align='left'>";
/*$artical.="<tr><td height='80' style='border-bottom:solid 1px #f2f2f2; padding:5px; background-color: #999999;' valign='middle'><img src='".SITE_IMG."logo_fundraiser.png' /></td>
</tr>";*/
$artical .= "<tr><td colspan='2'>Updates on <b>" . $sel_project_name['projectTitle'] . " Edited: </b> " . "</td></tr>";
$artical .= "<tr><td colspan='2'>Update #" . $num_of_rows . " " . unsanitize_string($_POST['updateTitle']) . "</td></tr>";
$artical .= "<tr><td colspan='2'>" . $textcontent . "</td></tr>";
$artical .= "<tr><td colspan='2'> </td></tr>";
$artical .= "<tr><td colspan='2'> </td></tr></table><br />";
$artical .= "Kind Regards, <br />" . DISPLAYSITENAME . " Admin</body></html>";
$subject = "Updates on " . SlugMailSubject(unsanitize_string($sel_project_name['projectTitle'])) . " Edited";
$mailbody = $artical;
$headers = "MIME-Version: 1.0\r\n";
$headers .= "Content-type: text/html\r\n";
$headers .= FROMEMAILADDRESS;
@mail(base64_decode($sel_project_backer_user['emailAddress']), $subject, $mailbody, $headers);
}
}
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "Update Edited Successfully");
redirect(SITE_URL . "browseproject/" . $sel_project_id['projectId'] . "/" . Slug($sel_project_name['projectTitle']) . "/&update=" . $num_of_rows . "#b");
}
}
$module = 'user';
$page = 'projectupdate';
$content = $module . '/' . $page;
require_once DIR_TMP . "main_page.tpl.php";
</div>
</fieldset>
</div>
</div>
</div>
<div class="content_right" style="display:none;">
<a target="_blank" href="<?php
echo SITE_URL;
?>
content/<?php
echo $sel_ContentPage['id'];
?>
/<?php
echo Slug($sel_ContentPage['title']) . '/';
?>
/" class="awesome_project background_light">
<span>How to</span><br>
Make an Awesome Project
</a>
<div class="project_cart_preview background_light">
<div class="project_cart_wrapper">
<div class="project_cart">
<div class="project_thumb" id="BiggerThumb">
<?php
print isset($projectImages) ? $projectImages['image400by300'] : '';
if (isset($projectImages) && $projectImages['image200by156'] != '') {
?>
<img id="test" src="<?php
echo $base_url . $projectImages['image200by156'];
<?php
require "../../includes/config.php";
if (isset($_POST['queryString'])) {
//$queryString = preg_replace('/\s+/', '', $_POST['queryString']);
$queryString = sanitize_string($_POST['queryString']);
if (strlen($queryString) > 0) {
$totalFaqQuestion = $con->recordselect("SELECT faqQuestion as value,faqCategoryParentId,faqCategoryId FROM faqquestionanswer WHERE faqQuestion LIKE '%{$queryString}%'");
$total_faq_question = mysql_num_rows($totalFaqQuestion);
//echo "SELECT faqque.faqQuestion as value,faqque.faqCategoryParentId,faqque.faqCategoryId,faqque.faqQuestionAnswerId,faqque.faqQuestionAnswerTime FROM `faqquestionanswer` as faqque, `faqcategory` as faqcat WHERE faqque.faqQuestion AND faqque.faqCategoryParentId=faqcat.faqCategoryId AND faqcat.faqStatus!='0' AND faqque.faqQuestion LIKE '%$queryString%' LIMIT 5";
$query = $con->recordselect("SELECT faqque.faqQuestion as value,faqque.faqCategoryParentId,faqque.faqCategoryId,faqque.faqQuestionAnswerId,faqque.faqQuestionAnswerTime FROM `faqquestionanswer` as faqque, `faqcategory` as faqcat WHERE faqque.faqCategoryParentId=faqcat.faqCategoryId AND faqcat.faqStatus!='0' AND faqque.faqQuestion LIKE '%{$queryString}%' LIMIT 5");
if (mysql_num_rows($query) > 0) {
while ($result = mysql_fetch_assoc($query)) {
$main_cat = mysql_fetch_assoc($con->recordselect("SELECT * FROM faqcategory WHERE faqCategoryId='" . $result['faqCategoryParentId'] . "'"));
$sub_cat = mysql_fetch_assoc($con->recordselect("SELECT * FROM faqcategory WHERE faqCategoryId='" . $result['faqCategoryId'] . "'"));
echo '<li onclick="fill(' . $main_cat['faqCategoryId'] . ',' . addQuotes(Slug($result['value'])) . ');" class="">
<h3 class="faq_questionlist">' . $result['value'] . '</h3>
<div class="faq-category">in ' . $main_cat['faqcategoryName'] . ' / ' . $sub_cat['faqcategoryName'] . '</div>
</li>';
}
echo '<a href="javascript:void(0)"><span class="faq-icon-arrow-search"></span> see all ' . $total_faq_question . ' results </a>';
} else {
echo 'Sorry, we couldn\'t find anything.';
}
} else {
}
}
?>
images/captcha-ref.jpg" alt="Captcha Refresh" border="0" class="fl" /></a>
</div>
<?php
}
?>
<div class="inputfield checkbox" style="padding-top:20px;">
<input class="hidden" name="user[send_newsletters]" type="hidden" value="0" />
<input checked="checked" class="checkbox" id="user_send_newsletters" name="txtTerms" tabindex="8" type="checkbox" value="1" />
<div class="float-left"><strong>Discover New Projects</strong></div>
<p>With Our Weekly Newsletter</p><br>
<?php
/* In the following line sel_ContentPage is set for terms of service by loginsignup.php */
?>
<!-- <p>By signing up, you agree to our <a href="<?php
echo SITE_URL . 'content/' . $sel_ContentPage['id'] . '/' . Slug($sel_ContentPage['title']) . '/';
?>
" target="_blank">terms of use</a>.</p> -->
</div>
<div class="inputfield">
<input name="submitSignup" tabindex="8" type="submit" value="Sign Me Up!">
</div>
</form>
</div>
<!--Signup div end-->
<div class="signupbox" <?php
echo $hidden;
?>
>
<!--Facebook div start-->
}
?>
</li>
<img src="<?php
echo SITE_IMG;
?>
location.png" />
<li>
<a title="<?php
echo unsanitize_string(ucfirst($sel_starproject['projectLocation']));
?>
" href="<?php
echo SITE_URL;
?>
city/<?php
echo $sel_starredproject1['projectId'] . '/' . Slug($sel_starproject['projectLocation']) . '/';
?>
">
<?php
echo unsanitize_string(ucfirst($sel_starproject['projectLocation']));
?>
</a>
</li>
<div class="clear"></div>
</ul>
<p><?php
echo unsanitize_string(ucfirst($sel_starproject['shortBlurb']));
?>
</p>
<?php
$chktime_cur = time();
?>
<section id="container" class="backer_reward">
<script type="text/javascript" src="Common/sdk_functions.js"></script>
<div id="get_started_header_detail" class="head_content temp">
<a href="<?php
echo SITE_URL . 'browseproject/' . $projectBasic['projectId'] . '/' . Slug($projectBasic['projectTitle']) . '/';
?>
" >
<h3><?php
echo unsanitize_string(ucfirst($projectBasic['projectTitle']));
?>
</h3>
</a>
<p id="marginbottom30">by
<a href="<?php
echo SITE_URL . 'profile/' . $projectByUser['userId'] . '/' . Slug($projectByUser['name']) . '/';
?>
" >
<?php
echo unsanitize_string(ucfirst(trim($projectByUser['name'])));
?>
</a>
</p>
</div>
<div class="wrapper ">
<div class="tabs_content_bg">
<div class="tab_content">
<div class="tabs_left">
<div class="tabs_left_pledge">
<div class="tout_checkout">
<h1>Check out with Paypal</h1>
function takePreApprovalFromBacker_sendCreatormail($array)
{
extract($array);
//$this->con->insert("insert into preapproval_detail (detail) values ('a')");
if ($backer_id != '') {
$projectBacker = mysql_fetch_array($this->con->recordselect("SELECT name FROM users where userId='{$backer_id}' LIMIT 1"));
$backer_name = $projectBacker['name'];
}
$projectCreater = mysql_fetch_array($this->con->recordselect("SELECT * FROM projects as pro, users as usr, projectbasics as pb where pro.projectId=" . $projectId . " and pro.userId=usr.userId AND pb.projectId =" . $projectId));
if ($projectCreater['pledgeMail'] == 1) {
$artical1 = "";
$artical1 = "<html><head><style>.body{font-family:Arial, Helvetica, sans-serif; font-size:12px; }</style></head>";
$artical1 .= "<body><strong>Hello " . $projectCreater['name'] . ", </strong><br />";
$artical1 .= "<br />";
$artical1 .= $backer_name . " has committed {$amount} to your project <b>" . unsanitize_string(ucfirst($projectCreater['projectTitle'])) . "</b><br />";
$artical1 .= "You can visit your project page by clicking the following link.<br />\n\t\t\t\t<a href='" . SITE_URL . "browseproject/" . $projectId . "/" . Slug($projectCreater['projectTitle']) . '/' . "' target='_blank'>Click Here</a><br />";
$artical1 .= "<br /><br />Regards,<br />" . DISPLAYSITENAME . " Team</body></html>";
$subject1 = "New backing for " . unsanitize_string(ucfirst($projectCreater['projectTitle']));
$mailbody1 = $artical1;
$headers1 = "MIME-Version: 1.0\r\n";
$headers1 .= "Content-type: text/html\r\n";
$headers1 .= FROMEMAILADDRESS;
@mail(base64_decode($projectCreater['emailAddress']), $subject1, $mailbody1, $headers1);
@mail('admin@' . $_SERVER['SERVER_NAME'], 'cc: ' . $subject1, $mailbody1, $headers1);
}
}
$message_time = time();
$con->insert("INSERT INTO usermessages (`messageId` ,`message` ,`projectId` ,`receiverId` ,`senderId` ,`messageTime`)\n\t\tVALUES (NULL , '" . sanitize_string($user_message) . "', '" . $_GET['project'] . "', '" . $sel_pro['userId'] . "', '" . $_SESSION['userId'] . "', '{$message_time}')");
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => 'Message succesfully sent.');
}
// message code end
if (isset($_GET['project']) && $_GET['project'] != NULL) {
$project_id = mysql_real_escape_string($_GET['project']);
$fill_form_projecttitle = mysql_fetch_array($con->recordselect("SELECT * FROM projectbasics WHERE projectId ='" . $project_id . "' "));
}
if (isset($_GET['reviewId']) && $_GET['reviewId'] != NULL) {
//echo $_GET['status'];
if ($_GET['status'] == 'off') {
//echo 'hiii';exit;
$con->update("UPDATE projectreview SET reviewstatus=0 WHERE `reviewId`= '" . $_GET['reviewId'] . "'");
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => 'Review succesfully deactivated.');
} else {
if ($_GET['status'] == 'on') {
//echo 'hi';exit;
$con->update("UPDATE projectreview SET reviewstatus=1 WHERE `reviewId`= '" . $_GET['reviewId'] . "'");
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => 'Review succesfully activated.');
}
}
redirect(SITE_URL . "browseproject/" . $_GET['project'] . '/' . Slug($sel_pro_basic['projectTitle']) . '/');
}
$ses_user = isset($_SESSION['userId']) ? $_SESSION['userId'] : NULL;
$get_project = isset($_GET['project']) ? $_GET['project'] : NULL;
$get_updates = isset($_GET['update']) ? $_GET['update'] : NULL;
$module = 'browse';
$page = 'browseproject';
$content = $module . '/' . $page;
require_once DIR_TMP . "main_page.tpl.php";
?>
"/>
<?php
}
?>
</a>
</div>
<div class="project_profile_right1">
<a title="<?php
echo unsanitize_string($sel_project_detail['projectTitle']);
?>
" href="<?php
echo SITE_URL;
?>
browseproject/<?php
echo $sel_project_detail['projectId'] . '/' . Slug($sel_project_detail['projectTitle']) . '/';
?>
">
<?php
echo unsanitize_string($sel_project_detail['projectTitle']);
?>
</a>
<?php
/*?><h6>By <?php echo $sel_project_user['name'] ?></h6><?php */
?>
<h6>By <?php
echo $sel_creator_name1['name'];
?>
</h6>
<span >By <a title="' . ucfirst($sel_starprojectusername['name']) . '" class="linkblue" href="' . SITE_URL . 'profile/' . $sel_starprojectusername['userId'] . '/' . Slug($sel_starprojectusername['name']) . '/' . '">' . ucfirst($sel_starprojectusername['name']) . '</a>
</span>
<ul>
<img src="' . SITE_IMG . 'category.png" />
<li>';
if ($sel_starproject_cat['isActive'] == 1) {
$html_content .= '<a title="' . unsanitize_string(ucfirst($sel_starproject_cat['categoryName'])) . '" href="' . SITE_URL . 'category/' . $sel_starproject_cat['categoryId'] . '/' . Slug($sel_starproject_cat['categoryName']) . '/' . '">' . unsanitize_string(ucfirst($sel_starproject_cat['categoryName'])) . '</a>';
} else {
$html_content .= '<a title="' . unsanitize_string(ucfirst($sel_starproject_cat['categoryName'])) . '" href="javascript:void(0);">
' . unsanitize_string(ucfirst($sel_starproject_cat['categoryName'])) . '
</a>';
}
$html_content .= '</li>
<img src="' . SITE_IMG . 'location.png" />
<li>
<a title="' . unsanitize_string(ucfirst($sel_starproject['projectLocation'])) . '" href="' . SITE_URL . 'city/' . $sel_starredproject1['projectId'] . '/' . Slug($sel_starproject['projectLocation']) . '/' . '">
' . unsanitize_string(ucfirst($sel_starproject['projectLocation'])) . '
</a>
</li>
<div class="clear"></div>
</ul>
<p>' . unsanitize_string(ucfirst($sel_starproject['shortBlurb'])) . '</p>';
$chktime_cur = time();
if ($sel_starproject['projectEnd'] <= $chktime_cur) {
$html_content .= '<h4 class="sticker">';
if ($sel_starproject['rewardedAmount'] >= $sel_starproject['fundingGoal']) {
$html_content .= 'SUCCESSFUL!';
} else {
$html_content .= 'FUNDING UNSUCCESSFUL';
}
$html_content .= '</h4>';
if (isset($_POST) && isset($_POST['preapprove_backing'])) {
// handle pre-approval request
if ($_SERVER['SERVER_NAME'] != 'emptyrocket.com') {
// only permit tests on emptyrocket
///// TEMP TURN OFF SUPPORT FOR BACKING UNTIL NEW PAYPAL SDK INTEGRATED ///////
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "Backing temporarily unavailable while new PayPal code is integrated.");
$sel_pro_basicdata = mysql_fetch_assoc($con->recordselect("SELECT * FROM projectbasics WHERE projectId='" . $_POST['projectId'] . "'"));
redirect(SITE_URL . "browseproject/" . $_POST['projectId'] . '/' . Slug($sel_pro_basicdata['projectTitle']) . '/');
///////////////////////////////////////////////////////////////////////////////
}
$backerId = sanitize_string($_POST['backerId']);
if (!isset($_SESSION['userId']) || $_SESSION['userId'] != $backerId) {
wrtlog("WARNING: preapprove_backing request userId ({$backerId}) does not match session (" . $_SESSION['userId'] . ") ");
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "Request does not match logged-in user.");
redirect($base_url . 'index.php');
} else {
$Pay = new Payment();
$response = $Pay->doPreapproval($_POST);
wrtlog("WARNING: unexpected return from call to Pay->doPreapprovePayment in projectBacker/index.php");
wrtlog("....... post vars: " . print_r($_POST, true));
wrtlog("....... response: " . print_r($response, true));
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "Preapproval failed. See log.");
$sel_pro_basicdata = mysql_fetch_assoc($con->recordselect("SELECT * FROM projectbasics WHERE projectId='" . $_POST['projectId'] . "'"));
redirect(SITE_URL . "browseproject/" . $_POST['projectId'] . '/' . Slug($sel_pro_basicdata['projectTitle']) . '/');
}
} else {
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "No project found");
redirect($base_url . 'index.php');
}
}
}
echo $base_url;
?>
images/category.png" style="float:left;padding-right: 5px;padding-left: 10px;" /><h2>Categories</h2></span><br/>
<div class="flclear"></div>
<?php
while ($row = mysql_fetch_assoc($selCategory)) {
?>
<li><a title="<?php
echo ucfirst(unsanitize_string($row['categoryName']));
?>
" href="<?php
echo SITE_URL;
?>
category/<?php
echo $row['categoryId'] . '/' . Slug($row['categoryName']) . '/';
?>
"
<?php
if (isset($_GET['catId']) && ($_GET['catId'] != NULL && !isset($titlename)) && $_GET['catId'] == $row['categoryId']) {
echo "class='active'";
}
?>
><?php
echo ucfirst(unsanitize_string($row['categoryName']));
?>
</a></li>
<?php
}
?>
$projectBacking = $con->insert("INSERT INTO projectbacking (rewardId, projectId, userId, pledgeAmount, backingTime, paypalId)\n\t\t\t\t\tVALUES('" . $rewardId . "','" . $projectId . "', " . $_SESSION['userId'] . ", '" . $amount . "', " . time() . "," . $paypalId . ");");
// jwg - also bump contributor count if first time contributing to this project
$bumpcontributor = '';
$backedbefore = $this->con->recordselect("SELECT * FROM projectbacking WHERE userId='{$userId}' and projectId='{$projectId}'");
if (mysql_num_rows($backedbefore) <= 0) {
$bumpcontributor = ', rewardedContributor = rewardedContributor + 1';
}
//$updateProjectGoal = $con->update("UPDATE projectbasics set rewardedAmount = rewardedAmount +".$amount." where projectId =".$projectId. " LIMIT 1");
$updateProjectGoal = $con->update("UPDATE projectbasics set rewardedAmount = rewardedAmount +" . $amount . "{$bumpcontributor} where projectId =" . $projectId . " LIMIT 1");
$projectCreater = mysql_fetch_array($con->recordselect("SELECT * FROM projects as pro, users as usr, projectbasics as pb where pro.projectId=" . $projectId . " and pro.userId=usr.userId AND pb.projectId =" . $projectId));
if ($projectCreater['pledgeMail'] == 1) {
$artical1 = "";
$artical1 = "<html><head><style>.body{font-family:Arial, Helvetica, sans-serif; font-size:12px; }</style></head>";
$artical1 .= "<body><strong>Hello " . $projectCreater['name'] . ", </strong><br />";
$artical1 .= "<br />";
$artical1 .= $_SESSION['name'] . " has pledged on your project <b>" . $projectCreater['projectTitle'] . "</b><br />";
$artical1 .= "Amount: \$" . $amount . "<br />";
$artical1 .= "Please visit pledged project by clicking on following link.<br />\n\t\t\t<a href='" . $base_url . "browseproject/" . $projectId . "/" . Slug($projectCreater['projectTitle']) . '/' . "' target='_blank'>Click Here</a><br />";
$artical1 .= "<br /><br />Kind Regards,<br />" . DISPLAYSITENAME . " Team</body></html>";
$subject1 = "Pledge on " . unsanitize_string(ucfirst($projectCreater['projectTitle']));
$mailbody1 = $artical1;
$headers1 = "MIME-Version: 1.0\r\n";
$headers1 .= "Content-type: text/html\r\n";
$headers1 .= FROMEMAILADDRESS;
@mail(base64_decode($projectCreater['emailAddress']), $subject1, $mailbody1, $headers1);
}
/*$inserTransaction = $con->insert("INSERT INO paypaltransaction(correlationId,amount,transactionId,userId)
VALUES ('".$resArray['CORRELATIONID']."', ".$amount.", '".$resArray['TRANSACTIONID']."', ".$_SESSION['uid'].")");*/
$_SESSION['msgType'] = array('from' => 'user', 'type' => 'error', 'var' => "multiple", 'val' => "Thank you for backing the project");
redirect($base_url . "browseproject/" . $projectId . "/" . Slug($projectCreater['projectTitle']) . '/');
}
">
<a name="<?php
echo Slug($selSubTitle1['faqcategoryName']);
?>
" ></a>
<h2><?php
echo $selSubTitle1['faqcategoryName'];
?>
</h2><h6><a href="#">Top ↑</a></h6>
<div class="clear"></div>
<?php
$sel_faq_questionanswer = $con->recordselect("SELECT * FROM `faqquestionanswer` WHERE faqCategoryId='" . $selSubTitle1['faqCategoryId'] . "'");
while ($selFaqQuestionAnswer = mysql_fetch_assoc($sel_faq_questionanswer)) {
?>
<h3 id="<?php
echo Slug($selFaqQuestionAnswer['faqQuestion']);
?>
"><?php
echo unsanitize_string($selFaqQuestionAnswer['faqQuestion']);
?>
</h3>
<p><?php
echo unsanitize_string($selFaqQuestionAnswer['faqAnswer']);
?>
</p>
<?php
}
?>
</li>
<?php
?>
" href="<?php
echo SITE_URL . 'browseproject/' . $sel_pro_basic['projectId'] . '/' . Slug($sel_pro_basic['projectTitle']) . '/';
?>
" >
<h3><?php
echo unsanitize_string(ucfirst($sel_pro_basic['projectTitle']));
?>
</h3>
</a>
<p id="marginbottom30">by
<a title="<?php
echo unsanitize_string(ucfirst(trim($sel_pro_user['name'])));
?>
" href="<?php
echo SITE_URL . 'profile/' . $sel_pro_user['userId'] . '/' . Slug($sel_pro_user['name']) . '/';
?>
" >
<?php
echo unsanitize_string(ucfirst(trim($sel_pro_user['name'])));
?>
</a>
</p>
</div>
<div class="wrapper">
<div class="tabs_content_bg">
<div class="tab_content">
<div class="tabs_left">
<form id="projectBacker" name="projectBacker" method="post" action="<?php
echo $base_url;
"/>
<?php
}
?>
</a>
</div>
<div class="staff-text">
<div class="textsmall-b">
<a title="<?php
echo ucfirst($project_detail["projectTitle"]);
?>
" href="<?php
echo SITE_URL;
?>
browseproject/<?php
echo $project_detail['projectId'] . '/' . Slug($project_detail["projectTitle"]) . '/';
?>
">
<strong><?php
echo ucfirst($project_detail["projectTitle"]);
?>
</strong>
</a>
</div>
<div class="spaser1"></div>
<?php
$user_name = $con->recordselect("SELECT p.userId,u.name FROM `projects` as p ,`users` as u WHERE p.projectId =" . $project_detail['projectId'] . " AND p.userId = u.userId AND p.accepted='1'");
if (mysql_num_rows($user_name) > 0) {
$project_by = mysql_fetch_assoc($user_name);
} else {
$project_by = "Not set";
while ($selFaqQuestion = mysql_fetch_assoc($sel_faq_question)) {
?>
<?php
/*?><li><a class="anchor" href="<?php echo $base_url; ?>help/<?php echo $sel_main_category['faqCategoryId']; ?>/#<?php echo $selFaqQuestion['faqQuestionAnswerTime']; ?>"><?php echo $selFaqQuestion['faqQuestion']; ?></a></li><?php */
?>
<li><a title="<?php
echo $selFaqQuestion['faqQuestion'];
?>
" class="anchor" href="<?php
echo $base_url;
?>
help/<?php
echo $sel_main_category['faqCategoryId'];
?>
/#<?php
echo Slug($selFaqQuestion['faqQuestion']) . '/';
?>
">
<?php
echo $selFaqQuestion['faqQuestion'];
?>
</a>
</li>
<?php
}
//While Over
?>
</ul>
<a class="faq-see-all" href="<?php
echo $base_url;
?>
}
?>
</li>
<img src="<?php
echo SITE_IMG;
?>
location.png" />
<li>
<a title="<?php
echo ucfirst($sel_4_data['projectLocation']);
?>
" href="<?php
echo SITE_URL;
?>
city/<?php
echo $news_array[$i]['projectId'] . '/' . Slug($sel_4_data['projectLocation']) . '/';
?>
">
<?php
echo ucfirst($sel_4_data['projectLocation']);
?>
</a>
</li>
<div class="clear"></div>
</ul>
<span class="activity-icon-quote"></span>
<blockquote class="activity-project_update-blockquote">
<?php
$unsanaprotit2 = unsanitize_string($news_array[$i]['updateComment']);
$protit_len = strlen($unsanaprotit2);
if ($protit_len > 350) {
}
?>
</a>
</div>
<!--.info-panel-img-->
<div class="info-panel-content info-panel-content-ext">
<span class="blue-txt">
<?php
if ($sel_staff_2['accepted'] == '1') {
?>
<a href="<?php
echo SITE_URL;
?>
browseproject/<?php
echo $sel_staff_2['projectId'] . '/' . Slug($sel_project2['projectTitle']) . '/';
?>
" target="_blank">
<b style="word-wrap:break-word;"><?php
echo $sel_project2['projectTitle'];
?>
</b>
</a><?php
} else {
?>
<b style="word-wrap:break-word;"><?php
echo $sel_project2['projectTitle'];
?>
</b>
<?php
}
<?php
if (!isset($links1)) {
$links1 = '';
}
if (!isset($links2)) {
$links2 = '';
}
$selectQuery = $con->recordselect("SELECT * from content");
if (mysql_num_rows($selectQuery) > 0) {
while ($cms_arr = mysql_fetch_assoc($selectQuery)) {
$column = $cms_arr['column'];
if ($column == 1) {
$href = $base_url . 'content/' . $cms_arr['id'] . '/' . Slug($cms_arr['title']) . '/';
$links1 .= "<a title='" . ucfirst($cms_arr['title']) . "' href='" . $href . "'><span class='footerblack'>" . $cms_arr['title'] . "</span></a><br/>";
} elseif ($column == 2) {
$href = $base_url . 'content/' . $cms_arr['id'] . '/' . Slug($cms_arr['title']) . '/';
$links2 .= "<a title='" . ucfirst($cms_arr['title']) . "' href='" . $href . "'><span class='footerblack'>" . $cms_arr['title'] . "</span></a><br/>";
}
}
}
?>
</li>
<li class="linkdiv hovereffect">
<p class="textnormal">Company Info</p>
<?php
echo $links1;
?>
<a title="SITEMAP" href="<?php
echo $base_url;
?>
sitemap/"><span class='footerblack'>Site Map</span></a><br/>
?>
" src="<?php
echo SITE_URL . 'images/missing_little1.png';
?>
" height="80" width="100" >
<?php
}
?>
<?php
if ($sel_backprojectacceptedterms['accepted'] == '1') {
?>
<a title="<?php
echo unsanitize_string(ucfirst($sel_backproject['projectTitle']));
?>
" href="<?php
echo SITE_URL . 'browseproject/' . $sel_backedproject1['projectId'] . '/' . Slug($sel_backproject['projectTitle']) . '/';
?>
">
<?php
echo unsanitize_string(ucfirst($sel_backproject['projectTitle']));
?>
</a>
<?php
} else {
if ($sel_backprojectacceptedterms['accepted'] == '3') {
?>
<a title="<?php
echo unsanitize_string(ucfirst($sel_backproject['projectTitle']));
?>
" href="#">
<?php
?>
logout/">Log Out</a></div></li>
</ul>
<?php
$sel_created_project = $con->recordselect("SELECT * FROM projects AS pro, projectbasics AS pb\n\t\t\t\t\t\t\tWHERE pro.userId ='" . $_SESSION['userId'] . "' AND pro.projectId = pb.projectId\n\t\t\t\t\t\t\tORDER BY `pro`.`projectId` DESC LIMIT 5");
if (mysql_num_rows($sel_created_project) > 0) {
?>
<ul class="my_created">
<h3>My Created Projects</h3>
<?php
while ($selCreatedProject = mysql_fetch_assoc($sel_created_project)) {
?>
<li>
<a href="<?php
if ($selCreatedProject['published'] == 1 && $selCreatedProject['accepted'] == 1) {
echo $base_url . 'browseproject/' . $selCreatedProject['projectId'] . '/' . Slug($selCreatedProject['projectTitle']) . '/';
} else {
echo $base_url . 'createproject/' . $selCreatedProject['projectId'];
}
?>
" title="<?php
if ($selCreatedProject['projectTitle'] != '') {
echo $selCreatedProject['projectTitle'];
} else {
echo 'Untitled';
}
?>
" >
<?php
if ($selCreatedProject['projectTitle'] != '') {
echo stringShorter($selCreatedProject['projectTitle'], 18);
</a>
<?php
$sel_faq_subcat = $con->recordselect("SELECT * FROM `faqcategory` WHERE faqCategoryParentId='" . $sel_main_category['faqCategoryId'] . "'");
while ($selFaqSubCat = mysql_fetch_assoc($sel_faq_subcat)) {
?>
<li class="subcat"><a title="<?php
echo $selFaqSubCat['faqcategoryName'];
?>
" data="HowItWork" href="<?php
echo $base_url;
?>
help/<?php
echo $sel_main_category['faqCategoryId'];
?>
/#<?php
echo Slug($selFaqSubCat['faqcategoryName']) . '/';
?>
">
<?php
echo $selFaqSubCat['faqcategoryName'];
?>
</a></li>
<?php
}
?>
<div class="space20"></div>
</li>
<?php
}
?>
$con->connect(SITE_DB_HOST, SITE_DB_NAME, SITE_DB_USER, SITE_DB_PASS);
if (!isset($links1)) {
$links1 = '';
}
if (!isset($links2)) {
$links2 = '';
}
$selectQuery = $con->recordselect("SELECT * from content");
if (mysql_num_rows($selectQuery) > 0) {
while ($cms_arr = mysql_fetch_assoc($selectQuery)) {
$column = $cms_arr['column'];
if ($column == 1) {
$href = SITE_URL . 'content/' . $cms_arr['id'] . '/' . Slug($cms_arr['title']) . '/';
$links1 .= "<a title='" . ucfirst($cms_arr['title']) . "' href='" . $href . "'><span class='footerblack'>" . $cms_arr['title'] . "</span></a><br/>";
} elseif ($column == 2) {
$href = SITE_URL . 'content/' . $cms_arr['id'] . '/' . Slug($cms_arr['title']) . '/';
$links2 .= "<a title='" . ucfirst($cms_arr['title']) . "' href='" . $href . "'><span class='footerblack'>" . $cms_arr['title'] . "</span></a><br/>";
}
}
}
?>
</li>
<li class="linkdiv hovereffect">
<p class="textnormal">Company Info</p>
<?php
echo $links1;
?>
<a title="SITEMAP" href="<?php
echo $base_url;
?>
sitemap/"><span class='footerblack'>Site Map</span></a><br/>
$chktime_cur = strtotime(date("Y-m-d H:i:s", time()));
$chktime_cur = time();
$selCitie = $con->recordselect("SELECT pb.projectLocation, pb.projectId FROM `projectbasics` as pb,`projects` as pr WHERE pb.fundingStatus='y' OR (pb.projectEnd >'" . $chktime_cur . "' AND pb.fundingStatus='r') AND pb.projectId=pr.projectId AND pr.published='1' AND pr.accepted='1' GROUP BY projectLocation ");
//$selCitie = $con->recordselect("SELECT projectLocation, projectId FROM projectbasics WHERE fundingStatus='y' OR (projectEnd >'".$chktime_cur."' AND fundingStatus='r') GROUP BY projectLocation ");
while ($row = mysql_fetch_assoc($selCitie)) {
if ($row['projectLocation'] != '') {
?>
<li>
<a title="<?php
echo ucfirst(unsanitize_string($row['projectLocation']));
?>
" href="<?php
echo SITE_URL;
?>
city/<?php
echo $row['projectId'] . '/' . Slug($row['projectLocation']) . '/';
?>
" <?php
if (isset($titlename) && $titlename == $row['projectLocation']) {
echo "class='active'";
}
?>
>
<?php
$unsanaprotit = unsanitize_string(ucfirst($row['projectLocation']));
$protit_len = strlen($unsanaprotit);
if ($protit_len > 35) {
echo substr($unsanaprotit, 0, 35) . '...';
} else {
echo substr($unsanaprotit, 0, 35);
}
?>
</a>
</div>
<div class="spaser-small"></div>
<div class="textsmall-g">
<span class="location-small"></span>
<a title="<?php
echo unsanitize_string(ucfirst($sel_project['projectLocation']));
?>
" href="<?php
echo SITE_URL;
?>
city/<?php
echo $sel_project['projectId'] . '/' . Slug(ucfirst($sel_project['projectLocation'])) . '/';
?>
">
<?php
$unsanaprotit2 = unsanitize_string(ucfirst($sel_project['projectLocation']));
$protit_len = strlen($unsanaprotit2);
if ($protit_len > 23) {
echo substr($unsanaprotit2, 0, 23) . '...';
} else {
echo substr($unsanaprotit2, 0, 23);
}
?>
</a>
</div>
<?php
$chktime_cur = time();
<div class="comment_box_left1">
<a href="' . SITE_URL . 'profile/' . $sel_updateCommentUsr['userId'] . '/' . Slug($sel_updateCommentUsr['name']) . '/' . '">';
$check_usr12proimg = str_split($sel_updateCommentUsr['profilePicture80_80'], 4);
if ($sel_updateCommentUsr['profilePicture80_80'] != '' && $sel_updateCommentUsr['profilePicture80_80'] != NULL && file_exists(DIR_FS . $sel_updateCommentUsr['profilePicture80_80']) && $check_usr12proimg[0] == 'imag') {
$html_content .= '<img src="' . SITE_URL . $sel_updateCommentUsr['profilePicture80_80'] . '" class="avatar-thumb" alt="' . $sel_updateCommentUsr['name'] . '" title="' . $sel_updateCommentUsr['name'] . '">';
} else {
if ($sel_updateCommentUsr['profilePicture80_80'] != '' && $sel_updateCommentUsr['profilePicture80_80'] != NULL && $check_usr12proimg[0] == 'http') {
$html_content .= '<img src="' . $sel_updateCommentUsr['profilePicture80_80'] . '" class="avatar-thumb" alt="' . $sel_updateCommentUsr['name'] . '" title="' . $sel_updateCommentUsr['name'] . '">';
} else {
$html_content .= '<img width="80" height="80" src="' . NOIMG2 . '" class="avatar-thumb" alt="' . $sel_updateCommentUsr['name'] . '" title="' . $sel_updateCommentUsr['name'] . '">';
}
}
$html_content .= '</a>
</div>
<div class="comment_box_right1">
<a href="' . SITE_URL . 'profile/' . $sel_updateCommentUsr['userId'] . '/' . Slug($sel_updateCommentUsr['name']) . '/' . '" class="float-left">';
$html_content .= unsanitize_string(ucfirst($sel_updateCommentUsr['name']));
$html_content .= '</a>
<h6 class="float-right"><a href="javascript:void(0);">About ';
$update_comment_time = $sel_updateProjectComments['updateCommentTime'];
$html_content .= ago($update_comment_time);
$html_content .= '</a></h6>
<div class="clear"></div>
<p>' . $sel_updateProjectComments['updateComment'] . '</p>';
$sel_backers = "SELECT DISTINCT `userId` FROM `projectbacking` WHERE `projectId` = '" . $get_project . "' ";
$sel_backersuser = mysql_query($sel_backers);
while ($backers = mysql_fetch_array($sel_backersuser)) {
if ($backers['userId'] == $sel_updateProjectComments['userId'] && $backers['userId'] == $_SESSION['userId']) {
$html_content .= '<div><a href="' . SITE_URL . 'browseproject/' . $sel_updateProjectComments['updatecommentId'] . '/updatecomment/' . $get_project . '" onclick="return confirm(\'Are you sure you want to delete this comment?\');">Delete</a></div>';
}
}
