$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 {
$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']; } }
$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']; } }