About 12,255 results: "mysql_query"
Page 8 of 50
Filter Results
Sources
Languages
Filter Results
Try Search On




  1.     // ????????? ???????? ? "??????"
  2.     $q = mysql_query("SELECT * FROM `friends` WHERE `id_user` = '$user->id' AND `id_friend` = '$ank->id' LIMIT 1");
  3.                 // ??????? ???????????? ?? ??????
  4.                 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}'");
  5.                 // ?? ????????? ??????????? ??????
  6.                 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'");
  7.                 mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` - '1' WHERE `id` = '{$user->id}' LIMIT 1");
  8. 
                        
  9.                 // ????????? ??????????? ??????
  10.                 mysql_query("UPDATE `friends` SET `confirm` = '1' WHERE `id_user` = '$user->id' AND `id_friend` = '$ank->id' LIMIT 1");
  11.                 mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` - '1' WHERE `id` = '{$user->id}' LIMIT 1");
  12.                 // ?? ?????? ?????? ???????? ???????? ???? (???? ??? ??? ?????? ????), ???? ??? ??? ????, ?? ????????????? ?? ?????
  13.                 mysql_query("INSERT INTO `friends` (`confirm`, `id_user`, `id_friend`) VALUES ('1', '$ank->id', '$user->id')");
  14.             // ??????? ? ??????? ??????
  15.             mysql_query("INSERT INTO `friends` (`confirm`, `id_user`, `id_friend`) VALUES ('0', '$ank->id', '$user->id'), ('1', '$user->id', '$ank->id')");
  16.             mysql_query("UPDATE `users` SET `friend_new_count` = `friend_new_count` + '1' WHERE `id` = '{$ank->id}' LIMIT 1");

  1. 		global $db;
  2. 		$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'");
  3. 			return false;
  4. 		mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['lastlogin']."=NOW() WHERE ".$db['users']['id']."='".intval($this->id)."' LIMIT 1;"); 
  5. 			return false;
  6. 		$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;");
  7. 		if ($result) //(mysql_num_rows($result) == 1)
  8. 			mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['server']."=NULL WHERE ".$db['users']['id']."='".intval($this->id)."'"); 
  9. 		if (!$this->id) return false;
  10. 		$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;");
  11. 			return false;
  12. 		$result = mysql_query("SELECT ".$db['users']['username']." FROM ".$db['tables']['users']." WHERE ".$db['users']['username']."='$newname'");
  13. 				return 13;
  14. 			$result = mysql_query("SELECT ".$db['users']['password']." FROM ".$db['tables']['users']." WHERE ".$db['users']['username']."='".$this->name."'"); 
  15. 			return false;
  16. 		mysql_query("UPDATE ".$db['tables']['users']." SET ".$db['users']['level']."='$newlvl' WHERE ".$db['users']['username']."='".$this->name."'"); 













  1. 		{
  2. 		$query=mysql_query("select * from {$pref}db_{$modul} where id={$_POST['pid']} $home_parent limit 1");
  3. 		while ($parid<>0) {
  4. 			$parid=mysql_result(mysql_query("select * from {$pref}db_{$modul} where id=$parid $home_parent "),0, 'pid');
  5. 		// $parent=$parent2;
  6. 		if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$id} $home_parent limit 1"))==0) {die();}
  7. 
                        
  8. 		mysql_query("delete from {$pref}db_structure_alias where id_type=$id_modules and id_el={$id}");
  9. 		if (intval(mysql_num_rows(mysql_query("select * from {$pref}db_structure_alias where href='{$href}'")))>0)
  10. 		$mes_er="<font><b class='saveinfo'>Ошибка создания алиаса</b></font>";
  11. 		else
  12. 		mysql_query("insert into {$pref}db_structure_alias set href='{$href}',id_page='{$id}',id_type={$id_modules},id_el={$id}");
  13. 
                        
  14. 		$mes="<font color='green'><b class='saveinfo'>Сохранено</b></font>";
  15. 		mysql_query("update {$pref}db_{$modul} set href='{$href}',alias='{$name}',anons='{$anons}',title='{$title}',name='{$fname}',error='{$error}',menu_name='{$mname}',`description`='{$descr}',`keyword`='{$key_w}',text='{$text}',pid='{$pid}',parent='{$parent}',type='{$typ}',menu1='{$menu1}',menu2='{$menu2}',menu3='{$menu3}',menu4='{$menu4}',menu4_par='{$menu4_par}',catalog='{$catalog}',materials='{$materials}',catalog2='{$banners1}',materials2='{$banners2}',menu='{$banners3}',access_admin='{$access_admin}',access_moder='{$access_moder}',access_user='{$access_user}',access_notuser='{$access_notuser}',tpl='{$tpl}',status='{$status}' where id='{$id}'  $home_parent ");


Back to Top