function getToken()
{
    require_once 'comm.php';
    $currnet = time();
    $Token_result = new connect();
    $sql = "SELECT * FROM options where type='token'";
    $result = $Token_result->query($sql);
    $arr = mysql_fetch_array($result);
    $time_token = $arr['value'];
    if ($currnet >= $time_token) {
        $appid = "wxa2986e7d8863b2ab";
        $secret = "08d000097799e646d11b57e0acd71a9f";
        $access_token = file_get_contents("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid={$appid}&secret={$secret}");
        $access_token = json_decode($access_token);
        $access_token = $access_token->{'access_token'};
        //修改新的token信息
        $time = $currnet + 7200;
        $sql = "UPDATE options SET title='" . $access_token . "',value='" . $time . "' where type='token'";
        $Token_result->query($sql);
    } else {
        $access_token = $arr['title'];
        //$access_token ="48QToD2xXqQSwSNF8uqn6iF3o3P4yDEqvrrxaDDO0nxqcZFgg95IwA_xAafzwhsVxcM4Hh0tQTtwIcTqFxEa_B1IUpXE67cVUmpBnq_09rE";
    }
    return $access_token;
}

function state($ch)
{
    $con = new connect();
    $rs = $con->Query(" select * from admin,client where email='{$ch}' and admin.id=client.id_client ");
    $data = $rs->fetch_array();
    return $data["state"];
}

 function edit_privilege_one($table, $id)
 {
     if ($_SESSION['user_type'] == 1) {
         return "1";
     }
     $ob1 = new connect();
     if ($table == "users") {
         $sql = mysqli_query($ob1->dbcon(), "SELECT * FROM `{$table}` WHERE  `user_id` = '{$id}'");
     } else {
         $sql = mysqli_query($ob1->dbcon(), "SELECT * FROM `{$table}` WHERE  `id` = '{$id}'");
     }
     if ($row = mysqli_fetch_array($sql)) {
         if ($table != "accounts") {
             //check if this assigned to this user
             if ($row['assignedto'] == $_SESSION['user_id']) {
                 return "1";
             }
         }
         if ($_SESSION['_' . $row['group']][$table] == 2 || $_SESSION['_' . $row['group']][$table] == 3 || $_SESSION['_' . $row['group']][$table] == 6 || $_SESSION['_' . $row['group']][$table] == 7) {
             return "1";
         } else {
             return "0";
         }
     }
 }

 function __construct()
 {
     require_once "include/connect.php";
     $db = new connect();
     //instance of the class connect
     $this->conn = $db->db_connect();
     //connecting to the databse using $conn
 }

 function inscrire($nom, $prenom, $email, $pwd, $state)
 {
     $con = new connect();
     if ($con->Query(" insert into admin (email,password) values ('{$email}','{$pwd}') ")) {
         $a = $con->Query("select * from admin where email='{$email}' ");
         $data = $a->fetch_array();
         $this->id_client = $data["id"];
         $RIB = $this->generateID();
         $con->Query(" insert into client (nom,prenom,id_client,state,RIB,solde) values ('{$nom}','{$prenom}','{$this->id_client}','{$state}','{$RIB}','0') ");
         echo "registered with success";
     } else {
         echo "fail to insert";
     }
 }

 /**
  * почти конструктор
  * @param null|int|string $type
  * @param null|string $host
  * @param null|string $base
  * @param null|string $user
  * @param null|string $pwd
  * @return connect|null
  */
 public static function start($type = NULL, $host = NULL, $base = NULL, $user = NULL, $pwd = NULL)
 {
     if (self::$inst == null) {
         self::$inst = new connect($type, $host, $base, $user, $pwd);
     }
     return self::$inst;
 }

 private function setConexion()
 {
     $conf = connect::getInstance();
     $this->servidor = $conf->getHostDB();
     $this->base_datos = $conf->getDB();
     $this->usuario = $conf->getUserDB();
     $this->password = $conf->getPassDB();
 }

 /**
  * builder constructor.
  * @param string $tbuild
  * @param string $lang
  * @param int $server
  * @param string $mwcedb
  */
 public function __construct($tbuild, $lang, $server, $mwcedb = "mwce_settings")
 {
     $this->DB = connect::start();
     $this->build = $tbuild;
     $this->lang = $lang;
     $this->server = $server;
     $this->mwcedb = $mwcedb;
     $this->checkBase();
 }

 public static function connectToRealmDB($realmid)
 {
     self::selectDB('webdb');
     if ($GLOBALS['realms'][$realmid]['mysql_host'] != $GLOBALS['connection']['host'] || $GLOBALS['realms'][$realmid]['mysql_user'] != $GLOBALS['connection']['user'] || $GLOBALS['realms'][$realmid]['mysql_pass'] != $GLOBALS['connection']['password']) {
         mysql_connect($GLOBALS['realms'][$realmid]['mysql_host'], $GLOBALS['realms'][$realmid]['mysql_user'], $GLOBALS['realms'][$realmid]['mysql_pass']) or buildError("<b>Database Connection error:</b> A connection could not be established to Realm. Error: " . mysql_error(), NULL);
     } else {
         self::connectToDB();
     }
     mysql_select_db($GLOBALS['realms'][$realmid]['chardb']) or buildError("<b>Database Selection error:</b> The realm database could not be selected. Error: " . mysql_error(), NULL);
     self::$connectedTo = 'chardb';
 }

 function countrows1($tablename, $field, $value)
 {
     $ob1 = new connect();
     $ids = join(',', $_SESSION['user_groups']);
     $sql = mysqli_query($ob1->dbcon(), "SELECT COUNT(id) AS `count` FROM `{$tablename}` WHERE `deleted` = '0' AND `{$field}`='{$value}' AND `group` IN ({$ids})");
     //  this use for users
     if ($_SESSION['user_type'] == '1') {
         $sql = mysqli_query($ob1->dbcon(), "SELECT COUNT(id) AS `count` FROM `{$tablename}` WHERE `deleted` = '0' AND `{$field}`='{$value}' ");
         // this use for admin
     }
     $row = mysqli_fetch_assoc($sql);
     return $row['count'];
 }

 public static function init($type)
 {
     if ($GLOBALS['enablePlugins'] == true) {
         if ($_SESSION['loaded_plugins'] != NULL) {
             $bad = array('.', '..', 'index.html');
             $loaded = array();
             foreach ($_SESSION['loaded_plugins'] as $folderName) {
                 connect::selectDB('webdb');
                 $chk = mysql_query("SELECT COUNT(*) FROM disabled_plugins WHERE foldername='" . mysql_real_escape_string($folderName) . "'");
                 if (mysql_result($chk, 0) == 0 && file_exists('plugins/' . $folderName . '/' . $type . '/')) {
                     $folder = scandir('plugins/' . $folderName . '/' . $type . '/');
                     foreach ($folder as $fileName) {
                         if (!in_array($fileName, $bad)) {
                             $loaded[] = 'plugins/' . $folderName . '/' . $type . '/' . $fileName;
                         }
                     }
                     $_SESSION['loaded_plugins_' . $type] = $loaded;
                 }
             }
         }
     }
 }

 function user_can_delete_groups($table)
 {
     $loguser = $_SESSION['user_id'];
     $ob1 = new connect();
     // $sql=" SELECT * FROM `user_group` WHERE `user_id` = '$loguser' AND ($table > '2' OR $table > '3' OR $table > '6' OR $table > '7' )";
     if ($_SESSION['user_type'] == '1') {
         $sql = "SELECT * FROM groups WHERE deleted = '0' ";
     } else {
         $sql = "SELECT user_group.*,groups.group_name FROM user_group\n                           LEFT OUTER JOIN groups ON user_group.group_id = groups.group_id\n                           WHERE user_group.user_id = '{$loguser}' AND (user_group.{$table} ='1' OR user_group.{$table} = '3' OR user_group.{$table} = '5' OR user_group.{$table} = '7' )";
     }
     // echo $sql;
     return mysqli_query($ob1->dbcon(), $sql);
 }

.link{
background-color:#DAA520;
color:#484848;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body bgcolor="#A9A9A9">
<center>
<h1>COURSE RERGISTRATION</h1>
<form method="post" action="#">
<?php 
if (isset($_POST['submit'])) {
    require_once "reg.php";
    $x = new connect();
    if ($x->course()) {
        header('Location: home.php');
    } else {
        echo "error";
    }
}
?>
<pre>

GRADUATION:	<input type="radio" name="graduation" value="UG" />UG	<input type="radio" name="graduation" value="PG" />PG

Degree:		<select name="degree">
<option value="select option" selected> Select category</option>
<option value="B.Tech">B.Tech</option>
<option value="M.Tech">M.Tech</option>

 public function DeleteData($users, $passwords, $dbName, $table, $id)
 {
     $con_user = $users;
     $con_pass = $passwords;
     $con_name = $dbName;
     $connection_object = new connect();
     if (!empty($con_user) && !empty($con_pass)) {
         $dbcon = $connection_object->connection('localhost', $con_user, $con_pass, $con_name);
     } else {
         $dbcon = $connection_object->connection('localhost', 'root', '', $con_name);
     }
     $sql = "delete from {$table} where `id`={$id}";
     //$query=mysql_query($sql);
     $deleteStatement = $dbcon->prepare($sql);
     $deleteStatement->execute(array(':id' => $id));
 }

    var $pass;
    var $db;
    public $connect;
    public function connection($hostname, $username, $passwoard, $database)
    {
        $this->host = $hostname;
        $this->user = $username;
        $this->pass = $passwoard;
        $this->db = $database;
        $connect = new PDO("mysql:host={$this->host};dbname={$this->db}", $this->user, $this->pass, array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
        $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        $connect->setAttribute(PDO::ATTR_PERSISTENT, true);
        return $connect;
    }
}
$connection_object = new connect();
include 'database_config.php';
$db_user = $database_user;
$db_pass = $databse_pass;
$dbcon = $connection_object->connection('localhost', $db_user, $db_pass, 'student_kpi');
//start from here
$batch = $_POST['b_id'];
$group = $_POST['g_id'];
$student_id = $_POST['s_id'];
$std_names = $_POST['name'];
$att = $_POST['attendance'];
$en_date = $_POST['entry_date'];
$preparedStatement = $dbcon->prepare('INSERT INTO student_attendance (s_id, name, b_id, g_id, attendance, entry_date)
	VALUES (:sid, :sname, :bid, :gid, :atten, :ent_date)');
$arrlength = count($student_id);
for ($x = 0; $x < $arrlength; $x++) {

<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
include "connect.php";
$name = $_POST["name"];
$pass = $_POST["pass"];
$query = "Select * from login where Name=\"" . $name . "\" and Password=\"" . $pass . "\";";
$q = "Select * from customer where name=\"" . $name . "\";";
$c = new connect();
$conn = $c->con();
$result = $c->execute($conn, $query);
if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    if ($row["Class"] == 1) {
        $r = $c->execute($conn, $q);
        $val = $r->fetch_assoc();
        session_start();
        $_SESSION["id"] = $val["id"];
        //  echo $val["id"];
        header('Location: CustomerProfile.html');
    } else {
        if ($row["Class"] == 2) {
            header('Location: Admin_Interface.html');
        }
    }
} else {
    echo "0 results\n";

<?php 
    if ($GLOBALS['service'][$service]['currency'] == "vp") {
        echo "<span class='currency'>Vote Points: " . account::loadVP($_SESSION['cw_user']) . "</span>";
    } elseif ($GLOBALS['service'][$service]['currency'] == "dp") {
        echo "<span class='currency'>" . $GLOBALS['donation']['coins_name'] . ": " . account::loadDP($_SESSION['cw_user']) . "</span>";
    }
}
account::isNotLoggedIn();
connect::selectDB('webdb');
$num = 0;
$result = mysql_query('SELECT char_db,name FROM realms ORDER BY id ASC');
while ($row = mysql_fetch_assoc($result)) {
    $acct_id = account::getAccountID($_SESSION['cw_user']);
    $realm = $row['name'];
    $char_db = $row['char_db'];
    connect::selectDB($char_db);
    $result = mysql_query('SELECT name,guid,gender,class,race,level,online FROM characters WHERE account=' . $acct_id);
    while ($row = mysql_fetch_assoc($result)) {
        ?>
<div class='charBox'>
    <table width="100%">
	        <tr>
                <td width="73">
                <?php 
        if (!file_exists('styles/global/images/portraits/' . $row['gender'] . '-' . $row['race'] . '-' . $row['class'] . '.gif')) {
            echo '<img src="styles/' . $GLOBALS['template']['path'] . '/images/unknown.png" />';
        } else {
            ?>
                <img src="styles/global/images/portraits/
					<?php 
            echo $row['gender'] . '-' . $row['race'] . '-' . $row['class'];

}
// language selection by settings
if (SETTINGS_SITE_LANGUAGE && file_exists(ROOT . 'languages/' . SETTINGS_SITE_LANGUAGE . '.php')) {
    include_once ROOT . 'languages/' . SETTINGS_SITE_LANGUAGE . '.php';
}
include_once ROOT . 'languages/default.php';
if (defined('SETTINGS_SITE_TIMEZONE')) {
    ini_set('date.timezone', SETTINGS_SITE_TIMEZONE);
}
$session = new session("prj");
set_time_limit(0);
$socket_connected = 0;
$latest_urls_time = 0;
while (1) {
    include_once DIR_MODULES . 'connect/connect.class.php';
    $connect = new connect();
    $connect->getConfig();
    if (!$connect->config['CONNECT_SYNC']) {
        echo "Connect sync turned off.";
        exit;
    } else {
        /*
        $connect->sendMenu(1);
        */
        $sqlQuery = "SELECT *\n                     FROM commands";
        $commands = SQLSelect($sqlQuery);
        $total = count($commands);
        for ($i = 0; $i < $total; $i++) {
            $cmd_values[$commands[$i]['ID']] = $commands[$i]['CUR_VALUE'];
            $cmd_titles[$commands[$i]['ID']] = $commands[$i]['RENDER_TITLE'];
            $cmd_data[$commands[$i]['ID']] = $commands[$i]['RENDER_DATA'];

<?php

include 'lib/connect.php';
$obj = new connect();
$modelid = $_POST['modelid'];
$qnty = $_POST['qnty'];
$n = $obj->save_cart($modelid, $qnty);
header('Location:cart.php');

 public static function logThis($desc, $service, $realmid)
 {
     $desc = mysql_real_escape_string($desc);
     $realmid = (int) $realmid;
     $service = mysql_real_escape_string($service);
     $account = (int) $_SESSION['cw_user_id'];
     connect::selectDB('webdb');
     mysql_query("INSERT INTO user_log VALUES(NULL,'" . $account . "','" . $service . "','" . time() . "','" . $_SERVER['REMOTE_ADDR'] . "','" . $realmid . "','" . $desc . "')");
 }