Example #1
0
 public function getLastNikEmployee()
 {
     $sql_id = " SELECT SUBSTR(EmployeeID,3,3) as id FROM employee ORDER BY ABS(employee_id) DESC ";
     $q = $this->db->query($sql_id);
     $row = $q->row_array();
     if ($row) {
         $id = autocode(number_format($row['id'], 0) + 1);
     } else {
         $id = autocode(0);
     }
     return substr(date('Y'), 2, 2) . $id;
 }
Example #2
0
<?php

/**
 * Created by PhpStorm.
 * User: master
 * Date: 2016/1/25
 * Time: 15:14
 */
require "includes/init.php";
require 'includes/lib_user.php';
require 'lang/' . $_SESSION['lang'] . '/user.php';
$nowtime = time();
$token = rawurldecode($_GET['token']);
$token = autocode($token, 'DECODE', constant('KEY'));
preg_match_all("/:([^:!]+)!/", $token, $match);
$username = $match[1][0];
$password = md5($match[1][1]);
$email = $match[1][2];
$regtime = $match[1][3];
$token_exptime = $regtime + 60 * 60 * 24;
//过期时间为24小时后
if ($nowtime > $token_exptime) {
    $msg = $_LANG['overTime'];
} else {
    $sql = "select id from admin.users where name='" . $username . "'";
    $rst = $GLOBALS['db']->getOne($sql);
    if (!empty($rst)) {
        $msg = $_LANG['alreadyActive'];
    } else {
        $sql = "insert into admin.users(`name`,`password`,`email`,`regtime`)";
        $sql .= " values ('{$username}', '{$password}','{$email}','{$regtime}')";