if (isset($_SESSION['membershipid'])) { $membershipid = $_SESSION['membershipid']; } else { $membershipid = -1; }
if (isset($_SESSION['level'])) { $level = $_SESSION['level']; } else { $level = 'X'; }
// Count number of projects in database.
$sql = "SELECT COUNT(*) AS total FROM allp WHERE status = 2 OR status = 3";
if ( ! $db_result = $dbx->query($sql)) { exit(dbErrorSend("", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); }
$row = $db_result->fetch_assoc();
if ($row['total'] <= 0) { print "
No Projects Found
"; exit; }
$show_amount = round($row['total'] * ($show_percent/100));
if ($show_amount < 1) { print "
No projects Available
"; exit; }
print "
Projects/Business Opportunities
";
print "
Click
here to reload this page and view more samples of available projects and business opportunities in the eAllianceMaker network.
Click the [contact] link in the opportunity to view and evaluate its details. Only registered members can access the contact information. Registration is quick, easy, and $free.
";
// Display project records.
$num = $show_amount;
$sql = "SELECT * FROM allp WHERE status=2 or status=3 ORDER BY RAND() LIMIT $num";
if ( ! $db_result = $dbx->query($sql)) { exit(dbErrorSend("", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); }
while ($row = $db_result->fetch_assoc()) {
$id = $row['id'];
$refid = $row['refid'];
$datecreated = $row['datecreated'];
$category = $row['category'];
$status = $row['status'];
$position = $row['position'];
$country = $row['country'];
$price = $row['price'];
$projectdescription = $row['projectdescription'];
$positiontext = ($position == 'S') ? 'Seeking' : 'Offering';
$name_2 = NULL;
$email_2 = NULL;
if ($membershipid == $refid) { // Project was added by someone in viewer's alliance.
// Get name and email of network alliance member.
$table2 = 'allc';
$sql2 = "SELECT name, email FROM $table2 WHERE membershipid = $refid LIMIT 1";
if ( ! $db_result2 = $dbx->query($sql)) { exit(dbErrorSend("Attempt to get member info failed.", $sql, basename(__FILE__), __FILE__, __LINE__, $dbx->error, $dbx->errno )); }
$row2 = $db_result2->fetch_assoc();
$name_2 = $row2['name'];
$email_2 = $row2['email'];
}
print "
";
if ($membershipid > 0) { $v = checkViewed($id, $membershipid, $dbx); } else { $v = NULL; }
print "
$category ($positiontext)
$country
";
if ($status == 2) {
print "
";
}
if ($status == 3) {
//if (($level == 'B') or ($level == 'E')) {
print "
";
//} else {
// print "
[ Contact ] $v | ";
//}
}
print "
";
if ($v != NULL) { print "
$v
"; }
if ($name_2 != NULL || $email_2 != NULL) { print "
★ $name_2 $email_2
"; }
print "
$projectdescription
";
print "
";
}
?>