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);