require_once 'includes/rlsmart/header.php';
require_once "includes/get_sql_value_string.php";
require_once 'userviews_class.php';
require_once 'classes/class_rafl.php';
//find user
$mysql = new mysqlquery();
$userview = new userviews();
$parent_data = $userview->findParent($_GET['item_id'], "rafl");
// Check rights
if (strlen($_GET['share_id'])) {
$userview->checkSharedRights($_GET['share_id']);
} else {
$userview->checkViewRights();
}
if (strlen($_SESSION['USER']->id)) {
$userData = $mysql->getRow("SELECT mb_icon FROM {$_SESSION['RealS_prefix']}members WHERE mb_id=" . $_SESSION['USER']->id);
$icon = $userData['mb_icon'];
}
$colname_rs_success = "-1";
if (isset($_GET['item_id'])) {
$colname_rs_success = $_GET['item_id'];
}
mysql_select_db($CFG->dbname, $smart);
// Gimme all success criteria
// Subquery: Conclude from the comment item id what the comment count for each success item must be
$query_rs_success = "SELECT\r\n\t \t{$_SESSION['RealS_prefix']}items.item_id,\r\n\t \t{$_SESSION['RealS_prefix']}webcells.webcell_title,\r\n\t \t{$_SESSION['RealS_prefix']}webcells.webcell_text,\r\n\t \t{$_SESSION['RealS_prefix']}rafl.rafl_collective,\r\n\t \t{$_SESSION['RealS_prefix']}rafl.rafl_success_evid_req,\r\n\t \t{$_SESSION['RealS_prefix']}rafl.rafl_success_obj\r\n\t FROM {$_SESSION['RealS_prefix']}items\r\n\t \tLEFT OUTER JOIN {$_SESSION['RealS_prefix']}webcells ON {$_SESSION['RealS_prefix']}webcells.webcell_id={$_SESSION['RealS_prefix']}items.item_webcell\r\n\t \tLEFT OUTER JOIN {$_SESSION['RealS_prefix']}rafl ON {$_SESSION['RealS_prefix']}rafl.rafl_item={$_SESSION['RealS_prefix']}items.item_id\r\n\t \tLEFT OUTER JOIN {$_SESSION['RealS_prefix']}members ON {$_SESSION['RealS_prefix']}webcells.webcell_member = {$_SESSION['RealS_prefix']}members.mb_id\r\n\t WHERE {$_SESSION['RealS_prefix']}items.item_parent_item = " . GetSQLValueString($colname_rs_success, "int") . "\r\n\t \tAND {$_SESSION['RealS_prefix']}items.item_default_type = 1\r\n\t ORDER BY {$_SESSION['RealS_prefix']}rafl.rafl_order";
//$query_rs_success = sprintf("SELECT {$_SESSION['RealS_prefix']}webcells.*, {$_SESSION['RealS_prefix']}items.item_id, {$_SESSION['RealS_prefix']}rafl.* FROM rafl INNER JOIN items ON {$_SESSION['RealS_prefix']}rafl.rafl_item = {$_SESSION['RealS_prefix']}items.item_id INNER JOIN webcells ON {$_SESSION['RealS_prefix']}items.item_webcell = {$_SESSION['RealS_prefix']}webcells.webcell_id WHERE item_parent_item = %s", GetSQLValueString($colname_rs_success, "int"));
$mysql = new mysqlquery();
$successes = $mysql->runsql($query_rs_success);
//$rs_success = mysql_query($query_rs_success, $smart) or die(mysql_error());
//$success = mysql_fetch_assoc($rs_success);
