AppGini Community Forums

Code: Select all

         function Pelajar_init(&$options, $memberInfo, &$args) {

		if($memberInfo['group'] == 'Pelajar') {
			
			//return false;
			
			$memberid1 = ($memberInfo['username']);
			$getrecordcount = sqlValue("select COUNT(tableName) FROM membership_userrecords WHERE tableName = 'Pelajar' AND memberID = '$memberid1' ");
			
			if ($getrecordcount > 0) {
				
				$pkValue = sqlValue("select pkValue FROM membership_userrecords WHERE tableName = 'Pelajar' AND memberID = '$memberid1' ");
				
				//redirect("Pelajar_view.php?SelectedID=".$pkValue);
				header("Location: Pelajar_view.php?SelectedID=".$pkValue);
				//exit;
				return false;
			}
		}
		
		return TRUE;

Code: Select all

function Pelajar_init(&$options, $memberInfo, &$args) {

	if($memberInfo['group'] == 'Pelajar') {
		
		$table = "Pelajar";
		$getrecordcount = sqlValue("select COUNT(tableName) FROM membership_userrecords WHERE tableName = '".$table."' AND memberID = '".$memberInfo['username']."'");			
			
		if ($getrecordcount > 0) {
			
			$recid = sqlValue("select id FROM ".$table." WHERE milik = '".$memberInfo['username']."'");
			
			//redirect($table."_view.php?SelectedID=".$recid);

			return TRUE;
			
		} else {
			
			$tarikh_buat = date("j/m/Y h:i:s a");
			$masuk = "insert into ".$table." (tarikh_buat, milik, nama, nokp, notel, emel) VALUES ('".$tarikh_buat."', '".$memberInfo['username']."', '".$memberInfo['custom'][0]."', '".$memberInfo['custom'][1]."', '".$memberInfo['custom'][2]."', '".$memberInfo['email']."')";
			sql($masuk, $eo);
			
			$rid = sqlValue("select id FROM ".$table." WHERE milik = '".$memberInfo['username']."'");
			set_record_owner($table, $rid, $memberInfo['username']);

			$izin = "INSERT INTO `membership_userpermissions`(`memberID`, `tableName`, `allowInsert`, `allowView`, `allowEdit`, `allowDelete`) VALUES ('" . $memberInfo['username'] . "', '".$table."', '0', '1', '1', '0')";
			sql($izin, $eo);
			
			//this redirection works properly if the above redirection is commented
			redirect($table."_view.php?SelectedID=".$rid);
			
			return TRUE;
		}
		
	}
	
	return TRUE;
}

Code: Select all

function Pelajar_init(&$options, $memberInfo, &$args) {

	if($memberInfo['group'] == 'Pelajar') {
			
		redirect("Pelajar_view.php?SelectedID=".$recid);
		exit();
	}
	
	return TRUE;
}

Code: Select all

function Pelajar_init(&$options, $memberInfo, &$args) {

	if($memberInfo['group'] == 'Pelajar') {
		
		$RecID = sqlValue("select id FROM Pelajar WHERE milik = '".$memberInfo['username']."'");			
		redirect("Pelajar_view.php?SelectedID=".$RecID);
		exit();
	}
	
	return TRUE;
}

Code: Select all

<!-- file: hooks/header-extras.php -->
<?php

if (HOMEPAGE) {

    $tn = "items"; // tablename
    $pk = 123; // get pk of current user's record

    /* dont' touch this unless you know what you are doing here ;-)  */
    echo '<script>$j(document).ready(function(){ let a = $j(\'.table_links > div > .panel > .panel-body > a[href="' . $tn . '_view.php"]\'); if (a.length) a.attr("href", "' . $tn . '_view.php?SelectedID=' . $pk . '");  })</script>';
}

?>

Code: Select all

<!-- file: hooks/header-extras.php -->
<?php

if (HOMEPAGE) {
    
    /* Change homepage link:
     * redirect user to specific record rather than to TV
     * with automatic detection of pk.
     * this will fetch the pk of the latest record created by current user
     */

     // change your tablename
    $tn = "items"; 

    /* don't touch the code below unless you know what you are doing ;-) */
    $pk = sqlValue("SELECT pkValue FROM membership_userrecords WHERE tableName='" . makeSafe($tn) . "' AND memberID='" . getLoggedMemberID() . "' ORDER BY pkValue DESC LIMIT 1");
    if ($pk !== false) echo '<script>$j(document).ready(function(){ let a = $j(\'.table_links > div > .panel > .panel-body > a[href="' . $tn . '_view.php"]\'); if (a.length) a.attr("href", "' . $tn . '_view.php?SelectedID=' . $pk . '");  })</script>';
}

?>

Code: Select all

["group"]=> string(8) "Penyelia"