File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/CampusIEA/all_php_files/site.php

<?php
if (!function_exists('site_db')) {
 function site_db()
 {
 global $dbConn;
 return $dbConn;
 }
}

if (!function_exists('campus_clean_text')) {
    function campus_clean_text($value)
    {
        $text = (string)$value;
        $map = array(
            'Ã ' => 'à',
            'Ã¨' => 'è',
            'Ã©' => 'é',
            'Ã¬' => 'ì',
            'Ã²' => 'ò',
            'Ã¹' => 'ù',
            'Ã€' => 'À',
            'Ãˆ' => 'È',
            'Ã‰' => 'É',
            'ÃŒ' => 'Ì',
            'Ã’' => 'Ò',
            'Ã™' => 'Ù',
            'Ã§' => 'ç',
            'â€œ' => '"',
            'â€' => '"',
            'â€™' => "'",
            'â€˜' => "'",
            'â€“' => '-',
            'â€”' => '-',
            'â€¦' => '...',
            'Â ' => ' ',
            'Â' => ''
        );
        return strtr($text, $map);
    }
}

if (!function_exists('h')) {
    function h($value)
    {
        return htmlspecialchars(campus_clean_text($value), ENT_QUOTES, 'UTF-8');
    }
}

if (!function_exists('site_lang')) {
    function site_lang()
    {
        static $lang = null;
        if ($lang !== null) {
            return $lang;
        }

$requested = isset($_GET['lang']) ? strtolower($_GET['lang']) : '';
        if (!in_array($requested, array('it', 'en'), true)) {
            $requested = isset($_COOKIE['campus_lang']) ? strtolower($_COOKIE['campus_lang']) : 'it';
        }

$lang = in_array($requested, array('it', 'en'), true) ? $requested : 'it';
        if (!headers_sent()) {
            setcookie('campus_lang', $lang, time() + 31536000, '/');
        }
        return $lang;
    }
}

if (!function_exists('t')) {
    function t($it, $en = '')
    {
        return campus_clean_text(site_lang() === 'en' && $en !== '' ? $en : $it);
    }
}

if (!function_exists('site_lang_url')) {
    function site_lang_url($lang)
    {
        $lang = in_array($lang, array('it', 'en'), true) ? $lang : 'it';
        $path = isset($_SERVER['REQUEST_URI']) ? (string)$_SERVER['REQUEST_URI'] : '/index.php';
        $parts = parse_url($path);
        $base = isset($parts['path']) ? $parts['path'] : '/index.php';
        $query = array();
        if (isset($parts['query'])) {
            parse_str($parts['query'], $query);
        }
        $query['lang'] = $lang;
        return $base . '?' . http_build_query($query);
    }
}

if (!function_exists('site_url')) {
    function site_url($path = '')
    {
        $path = ltrim((string)$path, '/');
        if (preg_match('#^about/([^?]+)(?:\?(.*))?$#', $path, $matches)) {
            $aboutId = 0;
            if (preg_match('/^([0-9]+)/', $matches[1], $idMatch)) {
                $aboutId = (int)$idMatch[1];
            }
            if ($aboutId > 0) {
                $query = array('pid' => $aboutId);
                if (isset($matches[2]) && $matches[2] !== '') {
                    parse_str($matches[2], $extraQuery);
                    if (is_array($extraQuery)) {
                        $query = array_merge($extraQuery, $query);
                    }
                }
                $query['lang'] = site_lang();
                return '/about.php?' . http_build_query($query);
            }
        }
        $separator = strpos($path, '?') === false ? '?' : '&';
        return '/' . $path . $separator . 'lang=' . site_lang();
    }
}

if (!function_exists('slug')) {
    function slug($string, $spaceRepl = "-")
    {
        $string = str_replace("&", "and", (string)$string);
        $string = preg_replace("/[^a-zA-Z0-9 _-]/", "", $string);
        $string = strtolower($string);
        $string = preg_replace("/[ ]+/", " ", $string);
        return str_replace(" ", $spaceRepl, $string);
    }
}

if (!function_exists('content_url')) {
    function content_url($title, $fallbackCategory = '')
    {
        $titleSql = db_escape($title);
        $where = "titulli='$titleSql'";
        if ($fallbackCategory !== '') {
            $catSql = db_escape($fallbackCategory);
            $where .= " OR kategoria='$catSql'";
        }
        $row = db_row("SELECT id, titulli FROM permbledhje WHERE $where ORDER BY id DESC LIMIT 1");
        if ($row) {
            return site_url('about/' . $row['id'] . '-' . slug($row['titulli']));
        }
        return site_url('search.php?kategori=' . urlencode($fallbackCategory !== '' ? $fallbackCategory : $title));
    }
}

if (!function_exists('db_all')) {
    function db_all($sql)
    {
        $rows = array();
        $result = mysqli_query(site_db(), $sql);
        if ($result) {
            while ($row = mysqli_fetch_assoc($result)) {
                $rows[] = $row;
            }
        }
        return $rows;
    }
}

if (!function_exists('db_row')) {
    function db_row($sql)
    {
        $result = mysqli_query(site_db(), $sql);
        return $result ? mysqli_fetch_assoc($result) : null;
    }
}

if (!function_exists('db_value')) {
    function db_value($sql, $default = '')
    {
        $row = db_row($sql);
        if (!$row) {
            return $default;
        }
        $values = array_values($row);
        return isset($values[0]) ? $values[0] : $default;
    }
}

if (!function_exists('db_escape')) {
    function db_escape($value)
    {
        return mysqli_real_escape_string(site_db(), (string)$value);
    }
}

if (!function_exists('db_has_table')) {
    function db_has_table($table)
    {
        $table = db_escape($table);
        $result = mysqli_query(site_db(), "SHOW TABLES LIKE '$table'");
        return $result && mysqli_num_rows($result) > 0;
    }
}

if (!function_exists('db_has_column')) {
    function db_has_column($table, $column)
    {
        $table = db_escape($table);
        $column = db_escape($column);
        $result = mysqli_query(site_db(), "SHOW COLUMNS FROM `$table` LIKE '$column'");
        return $result && mysqli_num_rows($result) > 0;
    }
}

if (!function_exists('site_setting')) {
    function site_setting($key, $default = '')
    {
        if (!db_has_table('site_settings')) {
            return $default;
        }
        $key = db_escape($key);
        $lang = site_lang();
        $field = $lang === 'en' ? 'value_en' : 'value_it';
        if (!db_has_column('site_settings', $field)) {
            return $default;
        }
        $row = db_row("SELECT value_it, value_en FROM site_settings WHERE setting_key='$key' LIMIT 1");
        if (!$row) {
            return $default;
        }
        $value = $lang === 'en' && trim((string)$row['value_en']) !== '' ? $row['value_en'] : $row['value_it'];
        return trim((string)$value) !== '' ? $value : $default;
    }
}

if (!function_exists('localized_field')) {
    function localized_field($row, $base, $fallback = '')
    {
        if (!is_array($row)) {
            return $fallback;
        }
        $enKey = $base . '_en';
        if (site_lang() === 'en' && isset($row[$enKey]) && trim((string)$row[$enKey]) !== '') {
            return campus_clean_text($row[$enKey]);
        }
        return isset($row[$base]) && trim((string)$row[$base]) !== '' ? campus_clean_text($row[$base]) : $fallback;
    }
}

if (!function_exists('campus_excerpt')) {
    function campus_excerpt($html, $length = 150)
    {
        $text = trim(strip_tags(campus_clean_text($html)));
        if (function_exists('mb_substr')) {
            return mb_strlen($text) > $length ? mb_substr($text, 0, $length) . '...' : $text;
        }
        return strlen($text) > $length ? substr($text, 0, $length) . '...' : $text;
    }
}

if (!function_exists('category_label')) {
    function category_label($category)
    {
        $category = trim((string)$category);
        if (site_lang() !== 'en') {
            return $category;
        }
        $labels = array(
            'Academy' => 'Academy',
            'Admission' => 'Admission',
            'Certificati' => 'Certificates',
            'Chi Siamo' => 'About',
            'Clausola Privacy' => 'Privacy clause',
            'Corsi Popolari' => 'Courses',
            'Eventi' => 'Events',
            'Mobilita Europea' => 'European mobility',
            'Orientamento Studenti' => 'Student guidance',
            'Procuratore Sportivo' => 'Sports agent',
            'ricerca' => 'Research',
            'Scopri di piu' => 'Discover more',
            'Seminar' => 'Seminar',
            'Servizi' => 'Services',
            'Slide' => 'Highlights',
            'tirocinio' => 'Traineeship',
            'Tirocinio Medicina' => 'Medicine traineeship',
            'Tirocinio Odontoiatria' => 'Dentistry traineeship',
            'Universita' => 'Universities',
            'Universita di Albania' => 'Universities in Albania',
            'Universita di Italia' => 'Universities in Italy',
            'Universita in Romania' => 'Universities in Romania'
        );
        return isset($labels[$category]) ? $labels[$category] : $category;
    }
}

if (!function_exists('campus_category_children')) {
    function campus_category_children($category)
    {
        $map = array(
            'Universita' => array(
                array('title' => 'Universita in Romania', 'category' => 'Universita in Romania'),
                array('title' => 'Universita in Albania', 'category' => 'Universita di Albania'),
                array('title' => 'Universita in Italia', 'category' => 'Universita di Italia')
            ),
            'Universita in Romania' => array(
                array('title' => 'Universita Carol Davila, Facolta Medicina', 'category' => 'Universita in Romania'),
                array('title' => 'Universita statale Dunarea de Jos Galati', 'category' => 'Universita in Romania'),
                array('title' => 'Universita statale Brasov', 'category' => 'Universita in Romania')
            ),
            'Universita di Albania' => array(
                array('title' => 'Universita Medicina di Tirana', 'category' => 'Universita di Albania')
            ),
            'Universita di Italia' => array(
                array('title' => 'Universita Dante Alighieri', 'category' => 'Universita di Italia'),
                array('title' => 'Universita ECampus', 'category' => 'Universita di Italia'),
                array('title' => 'Universita Pegaso', 'category' => 'Universita di Italia')
            ),
            'tirocinio' => array(
                array('title' => 'Tirocinio Medicina', 'category' => 'Tirocinio Medicina'),
                array('title' => 'Tirocinio Odontoiatria', 'category' => 'Tirocinio Odontoiatria'),
                array('title' => 'TIROCINIO IN FISIOTERAPIA', 'category' => 'tirocinio'),
                array('title' => 'Tutoraggio e Tirocinio al Corso di Laurea in Infermieristica', 'category' => 'tirocinio')
            ),
            'ricerca' => array(
                array('title' => 'IRSD', 'category' => 'ricerca'),
                array('title' => 'Medical Center', 'category' => 'ricerca'),
                array('title' => 'IEC', 'category' => 'ricerca'),
                array('title' => 'Centro Studi Athena Milano', 'category' => 'ricerca'),
                array('title' => 'Associazione La Koine Sicilia', 'category' => 'ricerca'),
                array('title' => 'Universita Centro Studi Bucarest', 'category' => 'ricerca')
            ),
            'Servizi' => array(
                array('title' => 'OFFERTA DI LAVORO', 'category' => 'Servizi'),
                array('title' => 'Procuratore Sportivo', 'category' => 'Procuratore Sportivo')
            )
        );
        return isset($map[$category]) ? $map[$category] : array();
    }
}

if (!function_exists('campus_general_material')) {
 function campus_general_material($title, $category)
 {
 $titleSafe = h($title);
 return array(
 'it' => '' . $titleSafe . ' raccoglie informazioni generali, orientamento e indicazioni operative per studenti e professionisti interessati ai servizi Campus IEA.Il materiale presenta una panoramica del percorso, dei requisiti di accesso, delle opportunita disponibili e dei passaggi consigliati per ricevere assistenza personalizzata.Per dettagli aggiornati, documentazione e supporto alla candidatura, contatta lo staff Campus IEA.',
 'en' => '' . $titleSafe . ' provides general information, guidance and practical notes for students and professionals interested in Campus IEA services.The material includes an overview of the pathway, access requirements, available opportunities and recommended steps for personalised assistance.For updated details, documentation and application support, contact the Campus IEA staff.'
 );
 }
}

if (!function_exists('campus_ensure_public_modules')) {
    function campus_ensure_public_modules()
    {
        mysqli_query(site_db(), "CREATE TABLE IF NOT EXISTS certificates (
            id int(11) NOT NULL AUTO_INCREMENT,
            certificate_no varchar(80) NOT NULL,
            student_name varchar(180) NOT NULL,
            course_title varchar(220) NOT NULL,
            issue_date date NOT NULL,
            language enum('it','en') NOT NULL DEFAULT 'it',
            status enum('valid','revoked','expired') NOT NULL DEFAULT 'valid',
            issuer varchar(180) NOT NULL DEFAULT 'Campus IEA',
            notes text DEFAULT NULL,
            created_at timestamp NOT NULL DEFAULT current_timestamp(),
            PRIMARY KEY (id),
            UNIQUE KEY certificate_no (certificate_no)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

if (!db_has_column('certificates', 'pdf_path')) {
            mysqli_query(site_db(), "ALTER TABLE certificates ADD pdf_path varchar(255) DEFAULT NULL AFTER notes");
        }
        if (!db_has_column('certificates', 'pdf_original_name')) {
            mysqli_query(site_db(), "ALTER TABLE certificates ADD pdf_original_name varchar(255) DEFAULT NULL AFTER pdf_path");
        }

mysqli_query(site_db(), "CREATE TABLE IF NOT EXISTS shop_orders (
            id int(11) NOT NULL AUTO_INCREMENT,
            product_id int(11) NOT NULL,
            customer_name varchar(180) NOT NULL,
            customer_email varchar(180) NOT NULL,
            customer_phone varchar(80) NOT NULL,
            quantity int(11) NOT NULL DEFAULT 1,
            message text DEFAULT NULL,
            status varchar(40) NOT NULL DEFAULT 'new',
            created_at timestamp NOT NULL DEFAULT current_timestamp(),
            PRIMARY KEY (id)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");
    }
}

if (!function_exists('campus_ensure_event_modules')) {
    function campus_ensure_event_modules()
    {
        mysqli_query(site_db(), "CREATE TABLE IF NOT EXISTS campus_events (
            id int(11) NOT NULL AUTO_INCREMENT,
            event_type enum('post','album','video') NOT NULL DEFAULT 'post',
            title_it varchar(255) NOT NULL,
            title_en varchar(255) DEFAULT NULL,
            description_it mediumtext NOT NULL,
            description_en mediumtext DEFAULT NULL,
            cover_image varchar(255) DEFAULT NULL,
            video_file varchar(255) DEFAULT NULL,
            video_url varchar(500) DEFAULT NULL,
            video_caption_it varchar(255) DEFAULT NULL,
            video_caption_en varchar(255) DEFAULT NULL,
            event_date date DEFAULT NULL,
            home_featured tinyint(1) NOT NULL DEFAULT 0,
            home_priority int(11) NOT NULL DEFAULT 0,
            location_it varchar(255) DEFAULT NULL,
            location_en varchar(255) DEFAULT NULL,
            status enum('draft','published') NOT NULL DEFAULT 'published',
            created_at timestamp NOT NULL DEFAULT current_timestamp(),
            updated_at timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            PRIMARY KEY (id),
            KEY status (status),
            KEY event_date (event_date),
            KEY event_type (event_type)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

mysqli_query(site_db(), "ALTER TABLE campus_events MODIFY event_type enum('post','album','video') NOT NULL DEFAULT 'post'");
        if (!db_has_column('campus_events', 'video_file')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD video_file varchar(255) DEFAULT NULL AFTER cover_image");
        }
        if (!db_has_column('campus_events', 'video_url')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD video_url varchar(500) DEFAULT NULL AFTER video_file");
        }
        if (!db_has_column('campus_events', 'video_caption_it')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD video_caption_it varchar(255) DEFAULT NULL AFTER video_url");
        }
        if (!db_has_column('campus_events', 'video_caption_en')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD video_caption_en varchar(255) DEFAULT NULL AFTER video_caption_it");
        }
        if (!db_has_column('campus_events', 'home_featured')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD home_featured tinyint(1) NOT NULL DEFAULT 0 AFTER event_date");
        }
        if (!db_has_column('campus_events', 'home_priority')) {
            mysqli_query(site_db(), "ALTER TABLE campus_events ADD home_priority int(11) NOT NULL DEFAULT 0 AFTER home_featured");
        }

mysqli_query(site_db(), "CREATE TABLE IF NOT EXISTS campus_event_photos (
            id int(11) NOT NULL AUTO_INCREMENT,
            event_id int(11) NOT NULL,
            image_path varchar(255) NOT NULL,
            caption_it varchar(255) DEFAULT NULL,
            caption_en varchar(255) DEFAULT NULL,
            sort_order int(11) NOT NULL DEFAULT 0,
            created_at timestamp NOT NULL DEFAULT current_timestamp(),
            PRIMARY KEY (id),
            KEY event_id (event_id),
            KEY sort_order (sort_order)
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci");

mysqli_query(site_db(), "UPDATE campus_events SET event_date=NULL WHERE event_date='0000-00-00'");

$eventCount = (int)db_value("SELECT COUNT(*) FROM campus_events", 0);
        if ($eventCount === 0 && db_has_table('permbledhje')) {
            $legacyEvents = db_all("SELECT * FROM permbledhje WHERE TRIM(kategoria)='Eventi' ORDER BY data DESC, id DESC LIMIT 20");
            foreach ($legacyEvents as $legacy) {
                $titleIt = db_escape($legacy['titulli']);
                $titleEn = isset($legacy['titulli_en']) ? db_escape($legacy['titulli_en']) : '';
                $bodyIt = db_escape($legacy['pershkrimi']);
                $bodyEn = isset($legacy['pershkrimi_en']) ? db_escape($legacy['pershkrimi_en']) : '';
                $cover = trim((string)$legacy['foto']) !== '' ? 'images/' . trim((string)$legacy['foto']) : 'images/event1.jpg';
                $coverSql = db_escape($cover);
                $dateSql = trim((string)$legacy['data']) !== '' ? "'" . db_escape($legacy['data']) . "'" : "NULL";
                mysqli_query(site_db(), "INSERT INTO campus_events (event_type, title_it, title_en, description_it, description_en, cover_image, event_date, status) VALUES ('post', '$titleIt', '$titleEn', '$bodyIt', '$bodyEn', '$coverSql', $dateSql, 'published')");
            }
        }
    }
}
?>

Batal

⬅ Naik ke CampusIEA 9 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘db_conx.php	php	425 B	2026-05-17 08:33	✏️ Edit 👁️ View
🐘db_credentials.php	php	504 B	2026-05-17 08:30	✏️ Edit 👁️ View
🐘dbconnect.php	php	1.7 KB	2026-05-17 08:46	✏️ Edit 👁️ View
🐘image_resize.php	php	803 B	2026-05-04 15:13	✏️ Edit 👁️ View
🐘photo_system.php	php	3.4 KB	2026-05-04 15:13	✏️ Edit 👁️ View
🐘session_bootstrap.php	php	322 B	2026-05-16 11:27	✏️ Edit 👁️ View
🐘shop_public.php	php	18.4 KB	2026-05-16 11:56	✏️ Edit 👁️ View
🐘site.php	php	19 KB	2026-05-17 02:54	✏️ Edit 👁️ View
🐘status.php	php	1.7 KB	2026-05-04 15:13	✏️ Edit 👁️ View