function addVideoLecture($name, $format, $examyear, $start, $end, $creator)
{
$conn = getConnection();
do {
$temp_url = md5($name . random_gen(10) . getCurrentInstituteID1());
$query = "SELECT * FROM video WHERE url LIKE '" . $temp_url . "'";
$result = mysql_query($query);
$rows = mysql_num_rows($result);
if ($rows == 0) {
$tempflag = false;
} else {
$tempflag = true;
}
} while ($tempflag);
$url = $temp_url . '.' . $format;
$query = "INSERT INTO video(name ,url,examyear,activeflag ,createdby , start_date, end_date, lastupdated) VALUES('" . $name . "' ,'" . $url . "' ,'" . $examyear . "' , 1 , " . $creator . ", '" . $start . "', '" . $end . "',NOW())";
$result = mysql_query($query);
if ($result) {
$temp = array(true, mysql_insert_id());
} else {
$temp = array(false, mysql_error());
}
return $temp;
}
function removeStudentFromMainTable($mainID)
{
$instituteID = getCurrentInstituteID1();
$conn = getMainConnection();
$query = "SELECT * FROM `studentinstituteid` WHERE `studentID` = '" . $mainID . "' AND `instituteID` = '" . $instituteID . "' AND `activeflag` = 1";
$result = mysql_query($query, $conn);
$rows = mysql_num_rows($result);
if ($rows == 1) {
$member = mysql_fetch_array($result);
$query1 = "UPDATE `studentinstituteid` SET `activeflag` = 0 WHERE `ID` = '" . $member['ID'] . "'";
$result1 = mysql_query($query1, $conn);
return true;
}
return false;
}
function getAllClassNotices()
{
$conn = getMainConnection();
$query = "SELECT * FROM notice WHERE activeflag = 1 ORDER BY ID DESC";
$result = mysql_query($query);
$id = getCurrentInstituteID1();
$output = '';
$flag = false;
while ($member = mysql_fetch_array($result)) {
$flag = true;
$temp = explode(';', $member['classID']);
$flag = in_array($id, $temp);
if ($flag || $member['classID'] == 0) {
$output .= '<li><h4>' . $member['name'] . '<h4></li>';
}
$output .= '<br />';
}
if ($flag) {
$output = '<h3> Note : </h3>' . $output;
}
return $output;
}
function assignRecurringStructure($type, $name, $BatchObj, $userID)
{
$list = getAllActiveUsersByBranch(getCurrentInstituteID1(), $BatchObj->getBranchObj()->getID());
$conn = getConnection();
for ($i = 0; $i < count($list); $i++) {
$query = "SELECT * FROM recurring_structure WHERE associate = '" . $type . "' AND staffID = '" . $list[$i]->getID() . "' AND activeflag = 1";
$result = mysql_query($query);
$numrows = mysql_affected_rows();
if ($numrows == 0) {
} else {
while ($member = mysql_fetch_array($result)) {
assignTasksOfStructureToStaff($member['structureID'], $member['staffID'], $member['priority'], $name, $userID);
}
}
}
}