Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

eval(base64_decode('CmRlZmluZWQoJ0JBU0VQQVRIJykgT1IgZXhpdCgnTm8gZGlyZWN0IHNjcmlwdCBhY2Nlc3..

Decoded Output download


defined('BASEPATH') OR exit('No direct script access allowed');

class Users_model extends CI_Model {
    
    public function getDatausers($id = null) {
        $this->datatables->select('users.id, username, first_name, last_name, email, FROM_UNIXTIME(created_on) as created_on, last_login, active, groups.name as level');
        $this->datatables->from('users_groups');
        $this->datatables->join('users', 'users_groups.user_id=users.id');
        $this->datatables->join('groups', 'users_groups.group_id=groups.id');
        if($id !== null){
            $this->datatables->where('users.id !=', $id);
        }
        return $this->datatables->generate();
    }

	public function getLevelGuru() {
		$query = $this->db->get('level_guru')->result();
		return $query;
	}

	public function getDataadmin() {
		$this->datatables->select('users.id, username, first_name, last_name, email, FROM_UNIXTIME(created_on) as created_on, last_login, active, groups.name as level');
		$this->datatables->from('users_groups');
		$this->datatables->join('users', 'users_groups.user_id=users.id');
		$this->datatables->join('groups', 'users_groups.group_id=groups.id');
		$this->datatables->where('group_id =', 1);
		return $this->datatables->generate();
	}
	/*
	public function getDatasiswa() {
		$this->datatables->select('users.id, username, first_name, last_name, email, FROM_UNIXTIME(created_on) as created_on, last_login, active, groups.name as level');
		$this->datatables->from('users_groups');
		$this->datatables->join('users', 'users_groups.user_id=users.id');
		$this->datatables->join('groups', 'users_groups.group_id=groups.id');
		$this->datatables->where('group_id =', 3);
		return $this->datatables->generate();
	}*/

	public function getUserGuru($tp, $smt) {
		$this->datatables->select('a.id_guru, a.nama_guru, a.username, a.password, c.level, e.id, (SELECT COUNT(id) FROM users WHERE e.username = a.username) AS aktif');
		$this->datatables->from('master_guru a');
		$this->datatables->join('jabatan_guru b', 'a.id_guru=b.id_guru AND b.id_tp='.$tp.' AND b.id_smt='.$smt.'', 'left');
		$this->datatables->join('level_guru c', 'b.id_jabatan=c.id_level', 'left');
		$this->datatables->join('users e', 'a.username=e.username', 'left');
		return $this->datatables->generate();
	}

	public function getDataGuru($id) {
		$this->db->select('*');
		$this->db->from('master_guru');
		$this->db->where('id_guru', $id);
		$query = $this->db->get()->row();
		return $query;
	}

	public function getDetailGuru($id) {
		$this->db->select('a.id_guru, a.nama_guru, a.username, a.password, a.email, c.level, e.id, (SELECT COUNT(id) FROM users WHERE e.username = a.username) AS aktif');
		$this->db->from('master_guru a');
		$this->db->join('jabatan_guru b', 'a.id_guru=b.id_guru', 'left');
		$this->db->join('level_guru c', 'b.id_jabatan=c.id_level', 'left');
		$this->db->join('users e', 'a.username=e.username', 'left');
		$this->db->where('a.id_guru', $id);
		$query = $this->db->get()->row();
		return $query;
	}

	public function getGuruByUsername($username) {
		$this->db->where('username', $username);
		$query = $this->db->get('master_guru')->row();
		return $query;
	}

	public function getUsers($username) {
		$this->db->where('username', $username);
		$query = $this->db->get('users')->row();
		return $query;
	}

    public function getGroupSiswa() {
	    $this->db->select('*');
	    $this->db->from('users_groups a');
	    $this->db->join('users b', 'a.user_id=b.id', 'left');
        $this->db->where('group_id', 3);
        $query = $this->db->get()->result();
        return $query;
    }

	public function getKelas($tp, $smt) {
        $this->db->where('id_tp', $tp);
        $this->db->where('id_smt', $smt);
		$query = $this->db->get('master_kelas')->result();
		return $query;
	}

	public function getMapel() {
		$query = $this->db->get('master_mapel')->result();
		return $query;
	}

	public function getUserSiswa($tp, $smt) {
		$this->datatables->select('a.id_siswa, a.nis,.a.nama, a.username, a.password, c.nama_kelas, d.id, (SELECT COUNT(id) FROM users WHERE d.username = a.username) AS aktif');
		$this->datatables->from('master_siswa a');
		$this->datatables->join('kelas_siswa b', 'b.id_siswa=a.id_siswa AND b.id_tp='.$tp.' AND b.id_smt='.$smt.'', 'left');
		$this->datatables->join('master_kelas c', 'c.id_kelas=b.id_kelas', 'left');
		$this->datatables->join('users d', 'd.username=a.username', 'left');
		return $this->datatables->generate();
	}

	public function getDataSiswa($id) {
		$this->db->select('nis, nisn, nama, username, password');
		$this->db->from('master_siswa');
		$this->db->where('id_siswa', $id);
		$query = $this->db->get()->row();
		return $query;
	}

	public function getSiswaAktif() {
		$this->db->select('a.id_siswa, c.id, (SELECT COUNT(id) FROM users WHERE users.username = a.username) AS aktif');
		$this->db->join('users c', 'a.username=c.username', 'left');
		return $this->db->get('master_siswa a')->result();
	}

    public function getGuruAktif() {
        $this->db->select('a.id_guru, c.id, (SELECT COUNT(id) FROM users WHERE users.username = a.username) AS aktif');
        $this->db->join('users c', 'a.username=c.username', 'left');
        return $this->db->get('master_guru a')->result();
    }
}

Did this file decode correctly?

Original Code

eval(base64_decode('CmRlZmluZWQoJ0JBU0VQQVRIJykgT1IgZXhpdCgnTm8gZGlyZWN0IHNjcmlwdCBhY2Nlc3MgYWxsb3dlZCcpOwoKY2xhc3MgVXNlcnNfbW9kZWwgZXh0ZW5kcyBDSV9Nb2RlbCB7CiAgICAKICAgIHB1YmxpYyBmdW5jdGlvbiBnZXREYXRhdXNlcnMoJGlkID0gbnVsbCkgewogICAgICAgICR0aGlzLT5kYXRhdGFibGVzLT5zZWxlY3QoJ3VzZXJzLmlkLCB1c2VybmFtZSwgZmlyc3RfbmFtZSwgbGFzdF9uYW1lLCBlbWFpbCwgRlJPTV9VTklYVElNRShjcmVhdGVkX29uKSBhcyBjcmVhdGVkX29uLCBsYXN0X2xvZ2luLCBhY3RpdmUsIGdyb3Vwcy5uYW1lIGFzIGxldmVsJyk7CiAgICAgICAgJHRoaXMtPmRhdGF0YWJsZXMtPmZyb20oJ3VzZXJzX2dyb3VwcycpOwogICAgICAgICR0aGlzLT5kYXRhdGFibGVzLT5qb2luKCd1c2VycycsICd1c2Vyc19ncm91cHMudXNlcl9pZD11c2Vycy5pZCcpOwogICAgICAgICR0aGlzLT5kYXRhdGFibGVzLT5qb2luKCdncm91cHMnLCAndXNlcnNfZ3JvdXBzLmdyb3VwX2lkPWdyb3Vwcy5pZCcpOwogICAgICAgIGlmKCRpZCAhPT0gbnVsbCl7CiAgICAgICAgICAgICR0aGlzLT5kYXRhdGFibGVzLT53aGVyZSgndXNlcnMuaWQgIT0nLCAkaWQpOwogICAgICAgIH0KICAgICAgICByZXR1cm4gJHRoaXMtPmRhdGF0YWJsZXMtPmdlbmVyYXRlKCk7CiAgICB9CgoJcHVibGljIGZ1bmN0aW9uIGdldExldmVsR3VydSgpIHsKCQkkcXVlcnkgPSAkdGhpcy0+ZGItPmdldCgnbGV2ZWxfZ3VydScpLT5yZXN1bHQoKTsKCQlyZXR1cm4gJHF1ZXJ5OwoJfQoKCXB1YmxpYyBmdW5jdGlvbiBnZXREYXRhYWRtaW4oKSB7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPnNlbGVjdCgndXNlcnMuaWQsIHVzZXJuYW1lLCBmaXJzdF9uYW1lLCBsYXN0X25hbWUsIGVtYWlsLCBGUk9NX1VOSVhUSU1FKGNyZWF0ZWRfb24pIGFzIGNyZWF0ZWRfb24sIGxhc3RfbG9naW4sIGFjdGl2ZSwgZ3JvdXBzLm5hbWUgYXMgbGV2ZWwnKTsKCQkkdGhpcy0+ZGF0YXRhYmxlcy0+ZnJvbSgndXNlcnNfZ3JvdXBzJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ3VzZXJzJywgJ3VzZXJzX2dyb3Vwcy51c2VyX2lkPXVzZXJzLmlkJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ2dyb3VwcycsICd1c2Vyc19ncm91cHMuZ3JvdXBfaWQ9Z3JvdXBzLmlkJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPndoZXJlKCdncm91cF9pZCA9JywgMSk7CgkJcmV0dXJuICR0aGlzLT5kYXRhdGFibGVzLT5nZW5lcmF0ZSgpOwoJfQoJLyoKCXB1YmxpYyBmdW5jdGlvbiBnZXREYXRhc2lzd2EoKSB7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPnNlbGVjdCgndXNlcnMuaWQsIHVzZXJuYW1lLCBmaXJzdF9uYW1lLCBsYXN0X25hbWUsIGVtYWlsLCBGUk9NX1VOSVhUSU1FKGNyZWF0ZWRfb24pIGFzIGNyZWF0ZWRfb24sIGxhc3RfbG9naW4sIGFjdGl2ZSwgZ3JvdXBzLm5hbWUgYXMgbGV2ZWwnKTsKCQkkdGhpcy0+ZGF0YXRhYmxlcy0+ZnJvbSgndXNlcnNfZ3JvdXBzJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ3VzZXJzJywgJ3VzZXJzX2dyb3Vwcy51c2VyX2lkPXVzZXJzLmlkJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ2dyb3VwcycsICd1c2Vyc19ncm91cHMuZ3JvdXBfaWQ9Z3JvdXBzLmlkJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPndoZXJlKCdncm91cF9pZCA9JywgMyk7CgkJcmV0dXJuICR0aGlzLT5kYXRhdGFibGVzLT5nZW5lcmF0ZSgpOwoJfSovCgoJcHVibGljIGZ1bmN0aW9uIGdldFVzZXJHdXJ1KCR0cCwgJHNtdCkgewoJCSR0aGlzLT5kYXRhdGFibGVzLT5zZWxlY3QoJ2EuaWRfZ3VydSwgYS5uYW1hX2d1cnUsIGEudXNlcm5hbWUsIGEucGFzc3dvcmQsIGMubGV2ZWwsIGUuaWQsIChTRUxFQ1QgQ09VTlQoaWQpIEZST00gdXNlcnMgV0hFUkUgZS51c2VybmFtZSA9IGEudXNlcm5hbWUpIEFTIGFrdGlmJyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmZyb20oJ21hc3Rlcl9ndXJ1IGEnKTsKCQkkdGhpcy0+ZGF0YXRhYmxlcy0+am9pbignamFiYXRhbl9ndXJ1IGInLCAnYS5pZF9ndXJ1PWIuaWRfZ3VydSBBTkQgYi5pZF90cD0nLiR0cC4nIEFORCBiLmlkX3NtdD0nLiRzbXQuJycsICdsZWZ0Jyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ2xldmVsX2d1cnUgYycsICdiLmlkX2phYmF0YW49Yy5pZF9sZXZlbCcsICdsZWZ0Jyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ3VzZXJzIGUnLCAnYS51c2VybmFtZT1lLnVzZXJuYW1lJywgJ2xlZnQnKTsKCQlyZXR1cm4gJHRoaXMtPmRhdGF0YWJsZXMtPmdlbmVyYXRlKCk7Cgl9CgoJcHVibGljIGZ1bmN0aW9uIGdldERhdGFHdXJ1KCRpZCkgewoJCSR0aGlzLT5kYi0+c2VsZWN0KCcqJyk7CgkJJHRoaXMtPmRiLT5mcm9tKCdtYXN0ZXJfZ3VydScpOwoJCSR0aGlzLT5kYi0+d2hlcmUoJ2lkX2d1cnUnLCAkaWQpOwoJCSRxdWVyeSA9ICR0aGlzLT5kYi0+Z2V0KCktPnJvdygpOwoJCXJldHVybiAkcXVlcnk7Cgl9CgoJcHVibGljIGZ1bmN0aW9uIGdldERldGFpbEd1cnUoJGlkKSB7CgkJJHRoaXMtPmRiLT5zZWxlY3QoJ2EuaWRfZ3VydSwgYS5uYW1hX2d1cnUsIGEudXNlcm5hbWUsIGEucGFzc3dvcmQsIGEuZW1haWwsIGMubGV2ZWwsIGUuaWQsIChTRUxFQ1QgQ09VTlQoaWQpIEZST00gdXNlcnMgV0hFUkUgZS51c2VybmFtZSA9IGEudXNlcm5hbWUpIEFTIGFrdGlmJyk7CgkJJHRoaXMtPmRiLT5mcm9tKCdtYXN0ZXJfZ3VydSBhJyk7CgkJJHRoaXMtPmRiLT5qb2luKCdqYWJhdGFuX2d1cnUgYicsICdhLmlkX2d1cnU9Yi5pZF9ndXJ1JywgJ2xlZnQnKTsKCQkkdGhpcy0+ZGItPmpvaW4oJ2xldmVsX2d1cnUgYycsICdiLmlkX2phYmF0YW49Yy5pZF9sZXZlbCcsICdsZWZ0Jyk7CgkJJHRoaXMtPmRiLT5qb2luKCd1c2VycyBlJywgJ2EudXNlcm5hbWU9ZS51c2VybmFtZScsICdsZWZ0Jyk7CgkJJHRoaXMtPmRiLT53aGVyZSgnYS5pZF9ndXJ1JywgJGlkKTsKCQkkcXVlcnkgPSAkdGhpcy0+ZGItPmdldCgpLT5yb3coKTsKCQlyZXR1cm4gJHF1ZXJ5OwoJfQoKCXB1YmxpYyBmdW5jdGlvbiBnZXRHdXJ1QnlVc2VybmFtZSgkdXNlcm5hbWUpIHsKCQkkdGhpcy0+ZGItPndoZXJlKCd1c2VybmFtZScsICR1c2VybmFtZSk7CgkJJHF1ZXJ5ID0gJHRoaXMtPmRiLT5nZXQoJ21hc3Rlcl9ndXJ1JyktPnJvdygpOwoJCXJldHVybiAkcXVlcnk7Cgl9CgoJcHVibGljIGZ1bmN0aW9uIGdldFVzZXJzKCR1c2VybmFtZSkgewoJCSR0aGlzLT5kYi0+d2hlcmUoJ3VzZXJuYW1lJywgJHVzZXJuYW1lKTsKCQkkcXVlcnkgPSAkdGhpcy0+ZGItPmdldCgndXNlcnMnKS0+cm93KCk7CgkJcmV0dXJuICRxdWVyeTsKCX0KCiAgICBwdWJsaWMgZnVuY3Rpb24gZ2V0R3JvdXBTaXN3YSgpIHsKCSAgICAkdGhpcy0+ZGItPnNlbGVjdCgnKicpOwoJICAgICR0aGlzLT5kYi0+ZnJvbSgndXNlcnNfZ3JvdXBzIGEnKTsKCSAgICAkdGhpcy0+ZGItPmpvaW4oJ3VzZXJzIGInLCAnYS51c2VyX2lkPWIuaWQnLCAnbGVmdCcpOwogICAgICAgICR0aGlzLT5kYi0+d2hlcmUoJ2dyb3VwX2lkJywgMyk7CiAgICAgICAgJHF1ZXJ5ID0gJHRoaXMtPmRiLT5nZXQoKS0+cmVzdWx0KCk7CiAgICAgICAgcmV0dXJuICRxdWVyeTsKICAgIH0KCglwdWJsaWMgZnVuY3Rpb24gZ2V0S2VsYXMoJHRwLCAkc210KSB7CiAgICAgICAgJHRoaXMtPmRiLT53aGVyZSgnaWRfdHAnLCAkdHApOwogICAgICAgICR0aGlzLT5kYi0+d2hlcmUoJ2lkX3NtdCcsICRzbXQpOwoJCSRxdWVyeSA9ICR0aGlzLT5kYi0+Z2V0KCdtYXN0ZXJfa2VsYXMnKS0+cmVzdWx0KCk7CgkJcmV0dXJuICRxdWVyeTsKCX0KCglwdWJsaWMgZnVuY3Rpb24gZ2V0TWFwZWwoKSB7CgkJJHF1ZXJ5ID0gJHRoaXMtPmRiLT5nZXQoJ21hc3Rlcl9tYXBlbCcpLT5yZXN1bHQoKTsKCQlyZXR1cm4gJHF1ZXJ5OwoJfQoKCXB1YmxpYyBmdW5jdGlvbiBnZXRVc2VyU2lzd2EoJHRwLCAkc210KSB7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPnNlbGVjdCgnYS5pZF9zaXN3YSwgYS5uaXMsLmEubmFtYSwgYS51c2VybmFtZSwgYS5wYXNzd29yZCwgYy5uYW1hX2tlbGFzLCBkLmlkLCAoU0VMRUNUIENPVU5UKGlkKSBGUk9NIHVzZXJzIFdIRVJFIGQudXNlcm5hbWUgPSBhLnVzZXJuYW1lKSBBUyBha3RpZicpOwoJCSR0aGlzLT5kYXRhdGFibGVzLT5mcm9tKCdtYXN0ZXJfc2lzd2EgYScpOwoJCSR0aGlzLT5kYXRhdGFibGVzLT5qb2luKCdrZWxhc19zaXN3YSBiJywgJ2IuaWRfc2lzd2E9YS5pZF9zaXN3YSBBTkQgYi5pZF90cD0nLiR0cC4nIEFORCBiLmlkX3NtdD0nLiRzbXQuJycsICdsZWZ0Jyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ21hc3Rlcl9rZWxhcyBjJywgJ2MuaWRfa2VsYXM9Yi5pZF9rZWxhcycsICdsZWZ0Jyk7CgkJJHRoaXMtPmRhdGF0YWJsZXMtPmpvaW4oJ3VzZXJzIGQnLCAnZC51c2VybmFtZT1hLnVzZXJuYW1lJywgJ2xlZnQnKTsKCQlyZXR1cm4gJHRoaXMtPmRhdGF0YWJsZXMtPmdlbmVyYXRlKCk7Cgl9CgoJcHVibGljIGZ1bmN0aW9uIGdldERhdGFTaXN3YSgkaWQpIHsKCQkkdGhpcy0+ZGItPnNlbGVjdCgnbmlzLCBuaXNuLCBuYW1hLCB1c2VybmFtZSwgcGFzc3dvcmQnKTsKCQkkdGhpcy0+ZGItPmZyb20oJ21hc3Rlcl9zaXN3YScpOwoJCSR0aGlzLT5kYi0+d2hlcmUoJ2lkX3Npc3dhJywgJGlkKTsKCQkkcXVlcnkgPSAkdGhpcy0+ZGItPmdldCgpLT5yb3coKTsKCQlyZXR1cm4gJHF1ZXJ5OwoJfQoKCXB1YmxpYyBmdW5jdGlvbiBnZXRTaXN3YUFrdGlmKCkgewoJCSR0aGlzLT5kYi0+c2VsZWN0KCdhLmlkX3Npc3dhLCBjLmlkLCAoU0VMRUNUIENPVU5UKGlkKSBGUk9NIHVzZXJzIFdIRVJFIHVzZXJzLnVzZXJuYW1lID0gYS51c2VybmFtZSkgQVMgYWt0aWYnKTsKCQkkdGhpcy0+ZGItPmpvaW4oJ3VzZXJzIGMnLCAnYS51c2VybmFtZT1jLnVzZXJuYW1lJywgJ2xlZnQnKTsKCQlyZXR1cm4gJHRoaXMtPmRiLT5nZXQoJ21hc3Rlcl9zaXN3YSBhJyktPnJlc3VsdCgpOwoJfQoKICAgIHB1YmxpYyBmdW5jdGlvbiBnZXRHdXJ1QWt0aWYoKSB7CiAgICAgICAgJHRoaXMtPmRiLT5zZWxlY3QoJ2EuaWRfZ3VydSwgYy5pZCwgKFNFTEVDVCBDT1VOVChpZCkgRlJPTSB1c2VycyBXSEVSRSB1c2Vycy51c2VybmFtZSA9IGEudXNlcm5hbWUpIEFTIGFrdGlmJyk7CiAgICAgICAgJHRoaXMtPmRiLT5qb2luKCd1c2VycyBjJywgJ2EudXNlcm5hbWU9Yy51c2VybmFtZScsICdsZWZ0Jyk7CiAgICAgICAgcmV0dXJuICR0aGlzLT5kYi0+Z2V0KCdtYXN0ZXJfZ3VydSBhJyktPnJlc3VsdCgpOwogICAgfQp9Cg=='))

Function Calls

defined 1
base64_decode 1

Variables

None

Stats

MD5 e019c54899a148b7a5ed966ec9f772c6
Eval Count 1
Decode Time 104 ms