1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / nc6d095 / pas.nisan.space / admin / inc /
Filename : funcs.php
back
<?php
function startSession(){
    if(! isset($_SESSION) || count($_SESSION) == 0){
        session_start();
    }
}

function now() {
    return date('Y-m-d H:i:s');
}

function pageRedirect($location){
    echo '<script>window.location = "'.$location.'";</script>';
}

function pageReload($time,$location){
    echo '<script> setTimeout(function() { window.location = "'.$location.'"; }, '.$time.'); </script>';
}

function startAlertTime(){
    $_SESSION['showMsg_start'] = time();
}

//compress images
function compressImage($source, $destination, $quality){
    $info = getimagesize($source);

    if($info['mime'] == 'image/jpeg')
        $image = imagecreatefromjpeg($source);

    elseif($info['mime'] == 'image/png')
        $image = imagecreatefrompng($source);

    imagejpeg($image, $destination, $quality);
}

function addLog($db,$activity,$type){
    $sqlQuery = mysqli_query($db, "INSERT INTO activity_logs(activity,type,dc) VALUES('$activity','$type',NOW())");
    if($sqlQuery){
        $sMsg = "Log has been created for this action";
        return $sMsg;
    }
    else{
        $eMsg = "Log could not be created";
        return $eMsg;
    }
}

function getTimeAgo($logTime){
    $actualTime = time() - $logTime;
    if($actualTime < 1){
        return "-1 sec ago";
    }

    $timeVariations = array(
        12 * 30 * 24 * 60 * 60 => 'yr',
        30 * 24 * 60 * 60      => 'month',
        24 * 60 * 60           => 'day',
        60 * 60                => 'hr',
        60                     => 'min',
        1                      => 'sec',
    );

    foreach($timeVariations as $secs => $str){
        $diff = $actualTime/$secs;
        if($diff >= 1){
            $roundedValue = round($diff);
            return $roundedValue." ".$str.($roundedValue > 1 ? 's' : '')." ago";
        }
    }
}

function ridBadXter($string){
    return trim(preg_replace('/\s+/', ' ', preg_replace('/[^A-Za-z0-9 ]/', '', $string)));
}

#CRUD FUNCTIONS

function dbInsert($table,$param=array()){
    global $db;
    $table_columns = implode(',', array_keys($param));
    $table_value = implode("','", $param);

    $query = mysqli_query($db, "INSERT INTO $table($table_columns) VALUES('$table_value')");
    if($query){
        return 'success';
    }
    else{
        return 'error';
    }
}


function dbUpdate($table,$param=array(),$id=0){
    $args = array();
    global $db;

    foreach ($param as $key => $value) {
        $args[] = "$key = '$value'";
    }

    $sql="UPDATE  $table SET " . implode(',', $args);

    $sql .=" WHERE $id";

    $query = mysqli_query($db,$sql);
    if($query){
        return 'success';
    }
    else{
        return 'error '.mysqli_error($db);
    }
}

function dbDelete($table,$id){
    global $db;
    $sql="DELETE FROM $table";
    $sql.=" WHERE $id ";
    $sql;
    $query = mysqli_query($db,$sql);
    if($query){
        return 'success';
    }
    else{
        return 'error';
    }
}


function dbSelect($table,$rows="*",$where = null, $order = null, $limit = null, $offset = null){
    global $db;
    if ($where != null) {
        $sql="SELECT $rows FROM $table WHERE $where";
    }else{
        $sql="SELECT $rows FROM $table";
    }
    if($order != null){
        $sql .= ' ORDER BY '.$order;
    }
    if($limit != null){
        $sql .= ' LIMIT '.$limit;
    }
    if($offset != null){
        $sql .= ' OFFSET '.$offset;
    }

    $query = mysqli_query($db,$sql);
    if($query){
        return $query;
    }
    else{
        return 'error';
    }
}


# OTHERS

function checkDuplicates($tbl,$col){
    global $db;
    $q = mysqli_query($db, "SELECT * FROM $tbl WHERE $col");
    $rows = mysqli_num_rows($q);
    return $rows;
}

function formatDate($date,$format=null){
    if(!empty($date)){
        if($format != null){
            return date($format, strtotime($date));
        }
        else{
            return date("F jS, Y h:ia", strtotime($date));
        }
    }
    else{ return ""; }
}

function getStatusColor($status){
    $color = "";
    if($status == 'active' || $status == 'Active'){
        $color = 'success';
    }
    elseif($status == 'inactive' || $status == 'Inactive'){
        $color = 'dark';
    }
    elseif($status == 'pending' || $status == 'Pending'){
        $color = 'secondary';
    }
    elseif($status == 'trashed' || $status == 'Trashed'){
        $color = 'warning';
    }
    return $color;
}

function getRows($tbl, $col = "*",$where=null){
    global $db;
    if($where != null){
        $q = mysqli_query($db, "SELECT $col FROM $tbl WHERE $where");
    }
    else{
        $q = mysqli_query($db, "SELECT $col FROM $tbl");
    }
    return $q;
}



function getProfileScore($fnm,$lnm,$mnm,$dob,$gnd,$phn,$eml,$bio,$edu,$adr,$stt,$cty,$lga,$img,$covImg){
    $score = 0;
    if(!empty($fnm)){ $score += 3; }else{ $score += 0; }
    if(!empty($lnm)){ $score += 3; }else{ $score += 0; }
    if(!empty($mnm)){ $score += 5; }else{ $score += 0; }
    if(!empty($dob)){ $score += 10; }else{ $score += 0; }
    if(!$gnd == 0){ $score += 10; }else{ $score += 0; }
    if(!empty($phn)){ $score += 5; }else{ $score += 0; }
    if(!empty($eml)){ $score += 10; }else{ $score += 0; }
    if(!empty($bio)){ $score += 15; }else{ $score += 0; }
    if(!$edu == 0){ $score += 5; }else{ $score += 0; }
    if(!empty($adr)){ $score += 5; }else{ $score += 0; }
    if(!$stt == 0){ $score += 5; }else{ $score += 0; }
    if(!empty($cty)){ $score += 5; }else{ $score += 0; }
    if(!$lga == 0){ $score += 5; }else{ $score += 0; }
    if(!empty($img) || $img != "default.png"){ $score += 10; }else{ $score += 0; }
    if(!empty($covImg) || $covImg != "default.jpg"){ $score += 4; }else{ $score += 0; }
    return $score;
}

function getPColor($score){
    $color = "";
    if($score > 70){ $color = "success"; }
    if($score > 50 && $score <= 70){ $color = "info"; }
    if($score >= 40 && $score <= 50){ $color = "warning"; }
    if($score < 40){ $color = "danger"; }
    return $color;
}


if(isset($_POST['doSub'])){
    $emailAdd = trim(stripslashes(mysqli_real_escape_string($db, $_POST['emailAdd'])));
    if(empty($emailAdd)){
        array_push($errs, $emailSubErr = "");
        $emsg = "Kindly enter your email to continue";
    }else{
        $subCheck = dbSelect("newsletter_subs","*","email='$emailAdd'");
        if(mysqli_num_rows($subCheck) == 1){
            array_push($errs, $emailSubErr = "");
            $emsg = "You have already subscribed";
        }
        if(count($errs) == 0){
            $qry = dbInsert("newsletter_subs",['email' => $emailAdd, 'dc' => $now]);
            if($qry){ $smsg = "subscription successful"; }
            else{ $emsg = "Something went wrong. Try again"; }
        }
    }
}

function cntRows($tbl, $where = null){
    if($where != null){
        $query = dbSelect("$tbl","*","$where");
    }
    else{
        $query = dbSelect("$tbl","*");
    }
    $cnt = mysqli_num_rows($query);
    return $cnt;
}


function getCatType($subCat){
    if(!empty($subCat) || $subCat > 0) {
        $catId = getDBVal('subcategories', $subCat, 'category');
        return getDBVal('categories', $catId, 'type');
    }
}

function getCatTypeName($subCat){
    if(!empty($subCat) || $subCat > 0) {
        $catId = getDBVal('subcategories', $subCat, 'category');
        $typeId = getDBVal('categories', $catId, 'type');
        return getDBVal('category_types', $typeId);
    }
}

function cntCatItems($cat,$where=null){
    if($where != null){
        $q = dbSelect("items","*","category=$cat AND $where");
    }else{
        $q = dbSelect("items","*","category=$cat");
    }

    $cnt = mysqli_num_rows($q);
    //return ($cnt > 0 ? $cnt : 0);
    return $cnt;
}

function changeStatus($tbl, $newStatus, $id){
    global $db;
    $q = mysqli_query($db, "UPDATE $tbl SET status='$newStatus', du=NOW() WHERE id=$id");
    return $q;
}

function dltRow($tbl, $id){
    global $db;
    $q = mysqli_query($db, "DELETE FROM $tbl WHERE id=$id");
    return $q;
}

function getDBVal($tbl, $id, $col='name'){
    global $db;
    if(!empty($id) && !empty($tbl)){
        $q = mysqli_query($db, "SELECT $col FROM $tbl WHERE id=$id");
        $dbVal = mysqli_fetch_array($q);
        return $dbVal[$col];
    }
}

function getDBValNoID($tbl, $where, $col='name'){
    global $db;
    $q = mysqli_query($db, "SELECT $col FROM $tbl WHERE $where");
    $dbVal = mysqli_fetch_array($q);
    return $dbVal[$col];
}

function checkActive($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(LCASE(status)='active') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkApproved($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(status='Approved' OR status='approved') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkRejected($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(status='Rejected' OR status='rejected') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkPending($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(status='Pending' OR status='pending') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkInactive($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(LCASE(status)='inactive' OR status='Suspended' OR status='suspended' OR status='Pending' OR status='pending') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkPublished($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(status='Published' OR status='published') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkPrivate($tbl, $id){
    global $db;
    $q = dbSelect($tbl, "*","(status='Private' OR status='private') AND id=$id");
    if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
}

function checkDo($do, $tbl, $id, $status=null){
    global $db;
    if($do == 'manage' && $status != null){
        $q = dbSelect($tbl, "*","LCASE(status)='$status' AND id=$id");
        if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
    }
    if($do == 'delete'){
        $q = dbSelect($tbl, "*","id=$id");
        if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
    }
}

function makeSlug($str){
    return strtolower(preg_replace('/-+/', '-', implode("-",explode(" ",$str))));
}

function slugToStr($slug){
    $str = ucwords(implode(" ",explode("-",$slug)));
    return $str;
}

function jsRefresh($url,$timer){
    echo "<script> setTimeout(function() { window.location = '$url'; }, $timer); </script>";
}


function validateDateFormat($date) {
    return preg_match('/^(\d{2})-(\d{2})-(\d{4})$/', $date);
}


function validateDateVals($date) {
    list($day, $month, $year) = explode('-', $date);
    return checkdate($month, $day, $year);
}

function formatLeaveDates($dates){
    $dateArr = explode(",",$dates);
    $newArr = [];
    foreach($dateArr as $date){
        array_push($newArr,$date);
    }
    return $newArr;
}

function checkPageViewIP($page,$ip){

    if(!empty($page) && !empty($ip)){
        $q = dbSelect('pageviews',"ipAddress","page='$page' AND ipAddress='$ip'");
        if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
    }
}

function checkItemViewIP($item,$type,$ip){

    if(!empty($item) && !empty($ip) && !empty($type)){
        $q = dbSelect('itemviews',"ipAddress","item=$item AND itemType='$type' AND ipAddress='$ip'");
        if(mysqli_num_rows($q) > 0){ return true; }else{ return false; }
    }
}

function getPostItem($item, $type){
    if(!empty($type) && !empty($item)){
        switch ($type){
            case 'event':
                $itemName = getDBVal('events',$item,'title');
                break;
            case 'webinar':
                $itemName = getDBVal('webinars',$item,'title');
                break;
            case 'resource':
                $itemName = getDBVal('resources',$item,'title');
                break;
            case 'podcast':
                $itemName = getDBVal('podcasts',$item,'title');
                break;
        }
        return $itemName;
    }
}

function validateGeneratedVal($tbl, $val, $col='ID'){
    $q = dbSelect($tbl, $col, "$col='$val'");
    if(mysqli_num_rows($q) > 0){
        return 'exist';
    }
    else{
        return 'ok';
    }
}