function dinstaller_table_count($dbname) {
$res = mysql_query("SELECT COUNT(*) AS count FROM information_schema.tables WHERE table_schema = '{$dbname}' ");
function dinstaller_table_row_count($table_name) {
$total = mysql_query("SELECT COUNT(*) FROM `$table_name`");
$sql = "CREATE DATABASE IF NOT EXISTS `{$dbname}`";
mysql_query($sql);
$found_tables = null;
if($result = mysql_query($sql, $conn)){
$sql = "DROP TABLE `{$dbname}`.{$table_name}";
if(! $result = mysql_query($sql, $conn)){
while ($temp < $len) {
mysql_query(($res[$temp]));
dinstaller_log("transient cached cleanup enabled:performing cleanup.\n");
mysql_query("DELETE FROM `wp_options` WHERE `option_name` LIKE ('_transient%')");
mysql_query("DELETE FROM `wp_options` WHERE `option_name` LIKE ('_site_transient%')");
}
$industry_sql = "SELECT id FROM $industry_tbl WHERE a_industry.name = '$industry_api_name'";
$industry_result = mysql_query($industry_sql);
$industry_sql_insert = "INSERT INTO $industry_tbl (name) VALUES ('$ind_api_name')";
$industry_insert_result = mysql_query($industry_sql_insert);
//check if everithing went OK
mysql_query($sql)or die(mysql_error());
$industry_sql = "SELECT id FROM $industry_tbl WHERE a_industry.name = '$industry_api_name'";
$industry_result = mysql_query($industry_sql);
$industry_sql_insert = "INSERT INTO $industry_tbl (name) VALUES ('$ind_api_name')";
$industry_insert_result = mysql_query($industry_sql_insert);
$skill_sql = "SELECT id FROM $skill_tbl WHERE a_skill.name = '$skill_name'";
$skill_result = mysql_query($skill_sql);
$skill_sql_insert = "INSERT INTO $skill_tbl (name) VALUES ('$skill_api_name')";
$skill_insert_result = mysql_query($skill_sql_insert);
mysql_query($sql)or die(mysql_error());
// ????????? ???????? ? "??????"
$q = mysql_query("SELECT * FROM `friends` WHERE `id_user` = '$user->id' AND `id_friend` = '$ank->id' LIMIT 1");
// ??????? ???????????? ?? ??????
mysql_query("DELETE FROM `friends` WHERE `id_user` = '{$user->id}' AND `id_friend` = '{$ank->id}' OR `id_user` = '{$ank->id}' AND `id_friend` = '{$user->id}'");
// ?? ????????? ??????????? ??????
mysql_query("DELETE FROM `friends` WHERE `id_user` = '$user->id' AND `id_friend` = '$ank->id' OR `id_user` = '$ank->id' AND `id_friend` = '$user->id'");
mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` - '1' WHERE `id` = '{$user->id}' LIMIT 1");
// ????????? ??????????? ??????
mysql_query("UPDATE `friends` SET `confirm` = '1' WHERE `id_user` = '$user->id' AND `id_friend` = '$ank->id' LIMIT 1");
mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` - '1' WHERE `id` = '{$user->id}' LIMIT 1");
// ?? ?????? ?????? ???????? ???????? ???? (???? ??? ??? ?????? ????), ???? ??? ??? ????, ?? ????????????? ?? ?????
mysql_query("INSERT INTO `friends` (`confirm`, `id_user`, `id_friend`) VALUES ('1', '$ank->id', '$user->id')");
// ??????? ? ??????? ??????
mysql_query("INSERT INTO `friends` (`confirm`, `id_user`, `id_friend`) VALUES ('0', '$ank->id', '$user->id'), ('1', '$user->id', '$ank->id')");
mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` + '1' WHERE `id` = '{$ank->id}' LIMIT 1");
global $db;
$result = mysql_query("SELECT ".$db['users']['username'].",".$db['users']['id'].",".$db['users']['level'].",".$db['users']['temp'].",".$db['users']['ip'].",".$db['users']['email']." FROM ".$db['tables']['users']." WHERE $method='$input'");
return false;
mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['lastlogin']."=NOW() WHERE ".$db['users']['id']."='".intval($this->id)."' LIMIT 1;");
return false;
$result = mysql_query("SELECT ".$db['users']['id']." FROM ".$db['tables']['users']." WHERE ".$db['users']['server']." IS NOT NULL and ".$db['users']['id']."='".intval($this->id)."' LIMIT 1;");
if ($result) //(mysql_num_rows($result) == 1)
mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['server']."=NULL WHERE ".$db['users']['id']."='".intval($this->id)."'");
if (!$this->id) return false;
$result = mysql_query("SELECT ".$db['users']['lastlogin']." FROM ".$db['tables']['users']." WHERE ".$db['users']['lastlogin']."<>'0000-00-00 00:00:00' and ".$db['users']['id']."='".intval($this->id)."' LIMIT 1;");
return false;
$result = mysql_query("SELECT ".$db['users']['username']." FROM ".$db['tables']['users']." WHERE ".$db['users']['username']."='$newname'");
return 13;
$result = mysql_query("SELECT ".$db['users']['password']." FROM ".$db['tables']['users']." WHERE ".$db['users']['username']."='".$this->name."'");
return false;
mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['level']."='$newlvl' WHERE ".$db['users']['username']."='".$this->name."'");
$game is a gamedata object, or something
$unitrow is an array of unit data (retrived by mysql_fetch_array off of a mysql_query)
$query = "UPDATE units SET x=$x, y=$y, moves=0 WHERE id=$unitid";
mysql_query($query) or die(json_encode( array( 'status' => mysql_error())));
$query = "SELECT * FROM units WHERE gameid=$gameid";
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
}
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
}
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
$query = "SELECT * FROM units WHERE id = $unitid";
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
$query = "SELECT * FROM units WHERE x = $x AND y = $y AND gameid = $gameid";
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
$query = "SELECT resources FROM usergames WHERE gameid = $gameid AND userid = $userid";
$result = mysql_query( $query ) or die( array( 'status' => mysql_error()) );
$message = mysql_query("SELECT u2.username sender, m.subject, m.time, m.content FROM user u1, user u2, message m WHERE u1.uid=m.ownerid AND u2.uid=m.senderid AND u1.username='$user'");
$pending = mysql_query("SELECT u1.username requesting, u1.uid uid FROM user u1, user u2, pending_friend p WHERE u1.uid=p.requesting AND u2.uid=p.requested AND u2.username='$user'");
$userinfo = mysql_query("SELECT * FROM user u WHERE u.username='$user'");
$education = mysql_query("SELECT * FROM user u, attended a, school s WHERE u.uid=a.uid AND a.sid=s.sid AND u.username='$user'");
$employment = mysql_query("SELECT * FROM user u, company c, employment e WHERE u.uid=e.uid AND c.cid=e.cid AND u.username='$user'");
$songresult = mysql_query("SELECT * FROM user u, song s, likesSong ls WHERE ls.sid = s.sid AND ls.uid = u.uid AND u.username ='$user'
GROUP BY s.sname");
$artistresult = mysql_query("SELECT * FROM user u, artist a, likesArtist la WHERE la.aid = a.aid AND la.uid = u.uid AND u.username = '$user' GROUP BY name");
$activityresult = mysql_query("SELECT * FROM user u, activity a, interested_in i WHERE i.uid = u.uid AND i.actid = a.aid AND u.username = '$user' Group BY aname");
$friendslist = mysql_query("SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$user')");
$mutualfriends = mysql_query("SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$curr') AND u2.username IN (SELECT u2.username FROM user u1, user u2, friend f WHERE ((u1.uid=f.user1 AND u2.uid=f.user2) OR (u1.uid=f.user2 AND u2.uid=f.user1)) AND (u1.username='$user'))");
$relationship = mysql_query("select u2.firstname, u2.lastname, r.status, u2.username from user u1, user u2, in_relationship_with r WHERE ((u1.uid=r.user1 AND u2.uid=r.user2) OR (u1.uid=r.user2 AND u2.uid=r.user1)) AND (u1.username = '$user')");
$curruser = $_SESSION['username'];
$education = mysql_query("SELECT * FROM user u, attended a, school s WHERE u.uid=a.uid AND a.sid=s.sid AND u.username='$curruser'");
$schoolrow = mysql_fetch_array($education);
$schoollist = mysql_query("SELECT * FROM school");
$res = mysql_query($query,$con);
$sname = setval($_POST['school']);
$srow = mysql_fetch_array(mysql_query("SELECT sid FROM school WHERE sname=$sname"));
$row = mysql_fetch_array(mysql_query("SELECT a.uid, a.sid, a.degree FROM attended a, school s, user u WHERE u.uid=a.uid AND s.sid=a.sid AND u.uid=$uid"));
$sres = mysql_query($squery, $con);
if (isset($_POST['editemployment'])) {
$erow = mysql_fetch_array(mysql_query("SELECT e.cid FROM user u, company c, employment e WHERE u.uid=e.uid AND c.cid=e.cid AND u.username='$curruser'"));
$actquery = "INSERT INTO activity VALUES ($aname, $aid)";
$actinsert = mysql_query($actquery, $con);
$q = "INSERT INTO " . TB_PREFIX . "users (id,username,password,access,email,timestamp,tribe,location,act,protect) VALUES (3, '$username', '$password', " . USER . ", '$email', ".time().", $tribe, '', '', 0)";
mysql_query($q);
generateBase(0, $uid, $username);
$wid = mysql_fetch_assoc(mysql_query("SELECT * FROM " . TB_PREFIX . "vdata WHERE owner = $uid"));
$q = "UPDATE " . TB_PREFIX . "vdata SET pop = 834 WHERE owner = $uid";
mysql_query($q) or die(mysql_error());
$q2 = "UPDATE " . TB_PREFIX . "users SET access = 0 WHERE id = $uid";
mysql_query($q2) or die(mysql_error());
$q3 = "UPDATE " . TB_PREFIX . "units SET u41 = " . (64700 * $speed) . ", u42 = " . (295231 * $speed) . ", u43 = " . (180747 * $speed) . ", u44 = " . (7 * $speed) . ", u45 = " . (364401 * $speed) . ", u46 = " . (217602 * $speed) . ", u47 = " . (2034 * $speed) . ", u48 = " . (1040 * $speed) . " , u49 = " . (1 * $speed) . ", u50 = " . (9 * $speed) . " WHERE vref = " . $wid['wref'] . "";
mysql_query($q3) or die(mysql_error());
$q4 = "UPDATE " . TB_PREFIX . "users SET desc2 = '$desc' WHERE id = $uid";
mysql_query($q4) or die(mysql_error());
$database->addABTech($wid);
mysql_query("UPDATE " . TB_PREFIX . "vdata SET pop = 163 WHERE wref = $wid");
mysql_query("UPDATE " . TB_PREFIX . "vdata SET name = '$village_name' WHERE wref = $wid");
$rs = mysql_query($sql);
mysql_query($sql);
$sql = "SELECT t_id FROM teacher WHERE t_name = '" . $t_name[$i] . "' "; // คิวรี่ t_id
$rs = mysql_query($sql);
$rs3 = mysql_query($sql);
$sql = "SELECT * FROM supervision WHERE company_id = '" . $company_id . "' "; //เช็ค หน่วยงานซ้ำ
$result3 = mysql_query($sql);
$result = mysql_query($sql);
$sql = "SELECT * FROM supervision WHERE t_id = '" . $t_id . "' ";
$result4 = mysql_query($sql);
$result = mysql_query($sql);
$sSQL = "SELECT poID FROM prodoptions WHERE poOptionGroup=" . @$_POST["id"];
$result = mysql_query($sSQL) or print(mysql_error());
$sSQL = "DELETE FROM options WHERE optGroup=" . @$_POST["id"];
mysql_query($sSQL) or print(mysql_error());
$sSQL = "DELETE FROM optiongroup WHERE optGrpID=" . @$_POST["id"];
mysql_query($sSQL) or print(mysql_error());
$sSQL .= " WHERE optGrpID=" . $iID;
mysql_query($sSQL) or print(mysql_error());
$sSQL .= " WHERE optGroup=" . $iID;
mysql_query($sSQL) or print(mysql_error());
$sSQL .= "'," . $optFlags . ")";
mysql_query($sSQL) or print(mysql_error());
$sSQL .= " WHERE optGrpID=" . $iID;
mysql_query($sSQL) or print(mysql_error());
$sSQL .= " WHERE optID=" . $aOption[$rowcounter][6];
mysql_query($sSQL) or print(mysql_error());
if (!function_exists('mysql_set_charset')) {
mysql_query("set names utf8",$db);
$sql = "SELECT id FROM utilisateur WHERE nom='".$data["nom"]."' AND prenom='".$data["prenom"]."'";
$req = mysql_query($sql) or die("Erreur: $sql<br />".mysql_error());
/* Exécution de la requête */
mysql_query($sql) or die ("Erreur: $sql<br />".mysql_error());
$sql = "SELECT id FROM utilisateur ORDER BY id DESC";
$req = mysql_query($sql);
/* Exécution de la requête */
mysql_query($sql) or die ("Erreur: ".$sql);
$sql = "SELECT * FROM photo WHERE user_id='$id'";
$num = mysql_num_rows(mysql_query($sql));
$sql = "DELETE FROM photo WHERE user_id='$id'";
@mysql_query($sql);
$sql = "INSERT INTO photo SET id='', user_id='$id', photo='$imgdata', extension='$ext', height='$height', width='$width'";
@mysql_query($sql);
if(!mysql_query("SET NAMES 'UTF8'",$this->connection))
{
$result = mysql_query("SHOW COLUMNS FROM $this->tablename");
$qry = "SELECT email FROM $this->tablename WHERE $fieldname='".$field_val."'";
$result = mysql_query($qry,$this->connection);
$insert_query = 'INSERT INTO '.$this->tablename.'(itrixid, name, email, gender) VALUES ("'.$uniqueid.'","' . $this->SanitizeForSQL($formvars['name']) . '","' . $this->SanitizeForSQL($formvars['email']) . '","' . $this->SanitizeForSQL($formvars['gender']) . '")';
if(!mysql_query( $insert_query ,$this->connection))
$update_query = "UPDATE $this->tablename SET logincount =".$counter." WHERE email = '".$emailaddress."'";
if(!mysql_query( $update_query ,$this->connection))
$get_query = "SELECT * FROM $this->tablename WHERE email = '".$key."'";
$get_result = mysql_query( $get_query ,$this->connection);
$qry = "SELECT * FROM ".$this->tablename." WHERE email='".$formvars['email']."' AND password='".$formvars['password']."'";
$result = mysql_query($qry,$this->connection);
$qry = "SELECT * FROM ".$this->tablename." WHERE email='".$formvars['email']."'";
$result = mysql_query($qry,$this->connection);
$user_query = mysql_query("
{
$user_privs_query = mysql_query("
$category_query = mysql_query("
$article_query = mysql_query("
$link_query = mysql_query("
$link_category_query = mysql_query("
{
$rs = mysql_query("
// can not use array slash due to way on which comments are selected
$rs = mysql_query("
$que_jur ="SELECT description FROM kajur WHERE id='$c'";
$jal_jur = mysql_query($que_jur);
$que_dosen ="SELECT kodejurusan FROM dosen WHERE id='$c'";
$jal_dosen = mysql_query($que_dosen);
$que_mhs ="SELECT kodejurusan FROM mhsw WHERE id='$c'";
$jal_mhs = mysql_query($que_mhs);
$per_sel_mah = "SELECT nim FROM mhsw WHERE id='$c'";
$jalan_sel_mah = mysql_query($per_sel_mah);
$que_karjur ="SELECT Kode FROM karyawan_jurusan WHERE ID='$c'";
$jal_karjur = mysql_query($que_karjur);
ORDER BY d.id_jadwal ASC";
$jalan = mysql_query($perintah);
ORDER BY d.id_jadwal ASC";
$jalan = mysql_query($perintah);
$perintah_nama = "SELECT a.nim,b.Name FROM skr_peserta a,mhsw b WHERE a.nim=b.NIM AND b.KodeJurusan='$hasil_id_jur[0]'";
$jalan_nama = mysql_query($perintah_nama);
$result = mysql_query("SELECT `last_id`, `table_name`, `field_name` FROM `hs_hr_unique_id`;");
$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_unique_id`"));
$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_language`"));
$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_project`"));
$this->assertTrue(mysql_query("TRUNCATE TABLE `hs_hr_customer`"));
// Initialize the id table.
$this->assertTrue(mysql_query('INSERT INTO `hs_hr_unique_id`(table_name, field_name, last_id) VALUES("hs_hr_test_table", "id_col", 0)'));
$this->assertTrue(mysql_query('INSERT INTO `hs_hr_unique_id`(table_name, field_name, last_id) VALUES("hs_hr_test2_table", "id", 1002)'));
// Initialize the id table.
$this->assertTrue(mysql_query('INSERT INTO `hs_hr_unique_id`(table_name, field_name, last_id) VALUES("hs_hr_test_table", "id_col", 0)'));
$this->assertTrue(mysql_query('INSERT INTO `hs_hr_unique_id`(table_name, field_name, last_id) VALUES("hs_hr_test2_table", "id", 1002)'));
$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `nilai` = '0000-00-00' WHERE `key` = 'hsp_accrued_last_updated'"));
$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `nilai` = '0000-00-00' WHERE `key` = 'hsp_used_last_updated'"));
$result = mysql_query("SELECT `value` FROM `hs_hr_config` WHERE `nilai` = 'timesheet_period_set'");
// For LeaveBroughtForward Setter
$result = mysql_query("SELECT `key` FROM `hs_hr_config` WHERE `nilai` = 'LeaveBroughtForward".date('Y')."'");
} else {
$this->assertTrue(mysql_query("DELETE FROM `hs_hr_config` WHERE `nilai` = 'LeaveBroughtForward".date('Y')."'"), mysql_error());
// For Leave BroughtForward Getter
$result = mysql_query("SELECT `key` FROM `hs_hr_config` WHERE `nilai` = 'LeaveBroughtForward".(date('Y')+1)."'");
if (mysql_num_rows($result) == 0) {
$this->assertTrue(mysql_query("INSERT INTO `hs_hr_config` (`nilai`, `value`) VALUES('LeaveBroughtForward".(date('Y')+1)."', 'set')"), mysql_error());
$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `nilai` = '0000-00-00' WHERE `key` = 'hsp_accrued_last_updated'"));
$this->assertTrue(mysql_query("UPDATE `hs_hr_config` SET `nilai` = '0000-00-00' WHERE `key` = 'hsp_used_last_updated'"));
mysql_query("DROP TABLE `bill_history`");
mysql_query($create_sql);
mysql_query("ALTER TABLE `bills` ADD `bill_quota` bigint(20) NOT NULL AFTER `bill_gb`;");
mysql_query("ALTER TABLE `bills` DROP `rate_95th_in`;");
mysql_query("ALTER TABLE `bills` DROP `rate_95th_out`;");
mysql_query("ALTER TABLE `bills` DROP `rate_95th`;");
mysql_query("ALTER TABLE `bills` DROP `dir_95th`;");
mysql_query("ALTER TABLE `bills` DROP `total_data`;");
mysql_query("ALTER TABLE `bills` DROP `total_data_in`;");
mysql_query("ALTER TABLE `bills` DROP `total_data_out`;");
mysql_query("ALTER TABLE `bills` DROP `rate_average_in`;");
mysql_query("ALTER TABLE `bills` DROP `rate_average_out`;");
mysql_query("ALTER TABLE `bills` DROP `rate_average`;");
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
/* delete hot music */
$delhot = mysql_query("Delete From music_hot where id=".$_REQUEST['id']."");
$sql_det = "delete from `music_hot` where `id` = '".$value."'";
$res_det = mysql_query($sql_det);
$sql_det = "delete from `music_hot` where `id` = '".$user_id."'";
$res_det = mysql_query($sql_det);
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
VALUES ('', '".$_REQUEST['hottitle']."', '', '', '', '".$_REQUEST['musicinfo']."')" ;
$inserhot_res = mysql_query($inserhot);
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
$update_sql = "Update music_featured set title='".$_REQUEST['mustitle']."' , music_id =".$_REQUEST['musicinfo']." where id=".$_REQUEST['hid']."";
mysql_query($update_sql);
{
$result = mysql_query("select url,admin_username,admin_password from mantisconfig",$this->connection);
{
mysql_query('delete from mantisconfig',$this->connection);
$config = mysql_query($insertSql,$this->connection);
{
mysql_query('delete from bitbucketdata',$this->connection);
$insertSql = "insert into bitbucketdata values ('".$row['username']."','".$row['emailid']."')";
$ret = mysql_query($insertSql,$this->connection);
{
$result = mysql_query("select userid,username,realname,emailid from facebookdata",$this->connection);
{
mysql_query('delete from facebookdata',$this->connection);
$ret = mysql_query($insertSql,$this->connection);
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
/* delete hot music */
$delhot = mysql_query("Delete From music_hot where id=".$_REQUEST['id']."");
$sql_det = "delete from `music_hot` where `id` = '".$value."'";
$res_det = mysql_query($sql_det);
$sql_det = "delete from `music_hot` where `id` = '".$user_id."'";
$res_det = mysql_query($sql_det);
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
VALUES ('', '".$_REQUEST['hottitle']."', '', '', '', '".$_REQUEST['musicinfo']."')" ;
$inserhot_res = mysql_query($inserhot);
$music_cat[0] = "Select Category";
$select_music_category = mysql_query("Select * from music_categories");
$update_sql = "Update music_featured set title='".$_REQUEST['mustitle']."' , music_id =".$_REQUEST['musicinfo']." where id=".$_REQUEST['hid']."";
mysql_query($update_sql);