コード例 #1
0
ファイル: myshortcuts.php プロジェクト: sdgdsffdsfff/Queen
 $post_src_check = false;
 if ($actSrcId and $actSrcType) {
     if (2 == $actSrcType) {
         $query = "select dummy from " . $mysql_ini['prefix'] . "dummy where dummy={$actSrcId} limit 1";
     } else {
         $query = "select tid from " . $mysql_ini['prefix'] . "token where tid={$actSrcId} limit 1";
     }
     $result = $db->query($query);
     if (1 == mysqli_num_rows($result)) {
         $post_src_check = true;
     }
 }
 $query_dummy = "";
 $query_token = "";
 if (3 == $actType) {
     $dummy_id = GlobalFunc::get_dummy_from_cid($uid, $actAid, $db, $mysql_ini);
     if ($dummy_id) {
         $actType = 2;
         $actAid = $dummy_id;
     }
 }
 if (2 == $actType) {
     $query = "select dummy from " . $mysql_ini['prefix'] . "dummy where dummy={$actAid} limit 1";
 } else {
     $query = "select tid from " . $mysql_ini['prefix'] . "token where tid={$actAid} limit 1";
 }
 $result = $db->query($query);
 if (1 == mysqli_num_rows($result)) {
     if (2 == $actType) {
         $query_dummy = ' where dummy=' . $actAid . ' limit 1';
     } else {
コード例 #2
0
ファイル: shortcut.php プロジェクト: sdgdsffdsfff/Queen
 $db = GlobalFunc::connect_db($mysql_ini);
 if (!$db) {
     $lasterror[] = $language['fail_db'];
 } else {
     if (false !== $sid) {
         $query = 'select a.data from ' . $mysql_ini['prefix'] . 'shortcuts as a left join ' . $mysql_ini['prefix'] . 'dummy as b on b.dummy = a.dummy where a.sid=' . $sid . ' limit 1';
         $result = $db->query($query);
         if (1 == mysqli_num_rows($result)) {
             $result = $result->fetch_assoc();
             $data = $result['data'];
         } else {
             $lasterror[] = $language['invalid_sid'];
         }
     }
     if (!$lasterror) {
         $dummy = GlobalFunc::get_dummy_from_cid($uid, $cid, $db, $mysql_ini);
         if (false === $dummy) {
             $lasterror[] = $language['client_off_line'];
         }
     }
     if (!$lasterror) {
         $query = 'insert into ' . $mysql_ini['prefix'] . 'shortcuts values (NULL,?,0,?,?,?,NULL)';
         $stmt = $db->prepare($query);
         $stmt->bind_param('isss', $dummy, $shortcut_name, $mid, $data);
         if ($stmt->execute()) {
             $query = 'update ' . $mysql_ini['prefix'] . 'dummy set shortcuts_num = shortcuts_num + 1 where dummy = ' . $dummy . ' limit 1';
             $db->query($query);
         } else {
             $lasterror[] = $language['insert_db_fail'];
         }
     }
コード例 #3
0
ファイル: cpanel.php プロジェクト: sdgdsffdsfff/Queen
 $db = GlobalFunc::connect_db($mysql_ini);
 if (!$db) {
     $lasterror[] = $language['fail_db'];
 }
 if (!$lasterror) {
     if ('group_list' === $_POST['act']) {
         $group_list[23]['name'] = '我的群,啦啦啦';
         $group_list[23]['online'] = '12/100';
         include $template->getfile('group_list.htm');
         exit;
     } elseif ('client_panel' === $_POST['act']) {
         $clientId = intval($_POST['cid']);
         $new_alias = $_POST['new_alias'];
         if ($clientId) {
             if ($new_alias) {
                 $dummy_id = GlobalFunc::get_dummy_from_cid($uid, $clientId, $db, $mysql_ini);
                 if ($dummy_id) {
                     $query = 'update ' . $mysql_ini['prefix'] . 'dummy set alias=? where dummy=' . $dummy_id . ' limit 1';
                     $stmt = $db->prepare($query);
                     $stmt->bind_param("s", $new_alias);
                     $stmt->execute();
                     if ($stmt->affected_rows) {
                         $lastsuccess[] = $language['success_set_alias'];
                     } else {
                         $lasterror[] = $language['fail_set_alias'];
                     }
                     $stmt->close();
                 } else {
                     $lasterror[] = $language['fail_set_alias'];
                 }
             }