Проблем с дб

[HiDeOfThePaiN]

Ами почнах да пиша една система за видео и почнах да може да прави групи. Но ето че дойдеха и проблемите дава ми това през браузъра Unknown column 'group_media.vid' in 'on clause' а дбто ми го има защо така ?

 

[relax]

Защото не го правиш както трябва дай да видим как го правиш не сме гадатели

 

[HiDeOfThePaiN]

ето файла grouper.php

<?php


  //=====================================================
  //  Стартираме
  //===================================================== 
  $group_key = quote_smart($_GET['key']);
  $lang = load_language("lang_group");
  $smarty->assign("page_title", "Group - $group_key");
  
  if ($group_key == '')
  {
  	$errors[] = $lang['error_id_not_found'];
  }
  
  if (!isset($errors))
  {	  
	  //=====================================================
  	  //  General Details
  	  //=====================================================
	  $result = mysql_query("SELECT * FROM groups WHERE url_key = '$group_key'") or die(mysql_error());
	  $details = mysql_fetch_assoc($result);
	  
	  //=====================================================
	  //  Add Media To Group
	  //=====================================================	  
	  if(isset($_POST['add_group_media']))
	  {
	    // Check member login
		if (!$login)
		{
		  redirect($config['siteurl'].'/login/');
		}
		
		// Check if submitting is owner only...If so, check if user is owner
		if ($details['upload_type'] == 'owner_only' && $user['id'] != $details['oid'])
		{
		  $errors[] = $lang['error_media_oo'];
		}
		
		// If there are no errors, continue
		if (!isset($errors))
		{
			// Check if media already exists in group
			$check = mysql_query("SELECT * FROM group_media WHERE gid=".$details['gid']." AND vid=".quote_smart($_POST['file_id'])."");
			if (mysql_num_rows($check) >= 1)
			{
				$msg = $lang['error_media_duplicate'];
			}
			else
			{
				// Add to group
				$result = mysql_query("INSERT INTO group_media VALUES ('', '".$details['gid']."', '".quote_smart($_POST['file_id'])."', '".$user['id']."', 'yes')") or die(mysql_error());
				if ($details['upload_type'] == 'owner_approve' && $user['id'] != $details['oid'])
				{
					$result = mysql_query("UPDATE group_media SET approved='no' WHERE gid='".$details['gid']."' AND vid=".quote_smart($_POST['file_id'])."") or die(mysql_error());
					$msg = $lang['msg_media_approval'];
				}
				else
				{
					if ($details['thumbnail_type'] == 'immediate')
					{
					    $result = mysql_query("UPDATE groups SET thumbnail='".quote_smart($_POST['thumb'])."' WHERE gid=".$details['gid']."") or die(mysql_error());
					}
					$msg = $lang['msg_media_added'];
				}
			}
			$smarty->assign('msg', $msg);
		}
	  }
	  
	  //=====================================================
  	  //  Join Group
  	  //=====================================================
	  if (isset($_POST['joingroup']))
	  {
	    // Check member login
		if (!$login)
		{
		  redirect($config['siteurl'].'/login/');
		}
		else
		{
		    // Check if user has already joined this group
			$checker = mysql_query("SELECT mid FROM group_members WHERE mid='".$user['id']."' AND gid='".$details['gid']."'") or die(mysql_error());
			if (mysql_num_rows($checker) > 0) {
				$errors[] = "You are already a member of this group.";
			}
			
			// Check group typw
			if ($details['type'] == 'protected')
			{
			  $approved = 'no';
			}
			else
			{
			  $approved = 'yes';
			}
			
			if (!isset($errors))
			{
			  $query = mysql_query("INSERT INTO group_members (id, gid, mid, joined, approved) VALUES ('', '".$details['gid']."', '".$user['id']."', '$date', '$approved')") or die(mysql_error());
			  if ($query)
			  {
				if ($details['type'] == 'protected')
				{
				  $msg = $lang['msg_join_protected'];
				}
				else
				{
				  $msg = $lang['msg_join_complete'];
				}
				
				$smarty->assign('msg', $msg);
			  }
			}
		}
	  }
	  
	  //=====================================================
  	  //  Leave Group
  	  //=====================================================
	  if (isset($_POST['leavegroup']))
	  {
	    // Check member login
		if (!$login)
		{
		  redirect($config['siteurl'].'/login/');
		}
		else
		{
		    // Check if user is a member this group
			$checker = mysql_query("SELECT mid FROM group_members WHERE mid='".$user['id']."' AND gid='".$details['gid']."'") or die(mysql_error());
			if (mysql_num_rows($checker) == 0) {
				$errors[] = "You are not a member of this group.";
			}
			
			if (!isset($errors))
			{
			  $query = mysql_query("DELETE FROM group_members WHERE gid=".$details['gid']." AND mid=".$user['id']."") or die(mysql_error());
			  $msg = $lang['msg_leave_left'].' <b>'.$details['name'].'</b>.  ';
			  $smarty->assign('msg', $msg);
			}
		}
	  }
	  
	  //=====================================================
  	  //  General Details - Again to update
  	  //=====================================================
	  $result = mysql_query("SELECT * FROM groups WHERE url_key = '$group_key'") or die(mysql_error());
	  $details = mysql_fetch_assoc($result);
	  
	  //=====================================================
  	  //  Media
  	  //=====================================================
	  $result = mysql_query("SELECT group_media.*, files.*, categories.* FROM group_media, categories LEFT JOIN files ON(group_media.vid=files.file_id) WHERE group_media.gid = '".$details['gid']."' AND group_media.approved = 'yes' AND categories.category_id=files.category_id LIMIT 4") or die(mysql_error());
	  $gvideos = mysql_fetch_rows($result);
	  $gmedia_count = @mysql_num_rows($result);
	  
	  //=====================================================
  	  //  Members
  	  //=====================================================
	  $result = mysql_query("SELECT group_members.*, users.* FROM group_members, users WHERE group_members.mid=users.id AND group_members.gid = '".$details['gid']."' AND group_members.approved = 'yes' LIMIT 4") or die(mysql_error());
	  $gmems = mysql_fetch_rows($result);
	  $gmem_count = @mysql_num_rows($result);
	  
	  //=====================================================
  	  //  Check If Group Member
  	  //=====================================================
	  if ($login)
	  {
		  $check = mysql_query("SELECT * FROM group_members WHERE gid = ".$details['gid']." AND mid = ".$user['id']."");
		  $mem_check = mysql_fetch_assoc($check);
		  $is_mem = $mem_check['approved'];
	  }
	  
	  //=====================================================
  	  //  Output To Smarty
  	  //=====================================================
	  $array = array('details' => $details, 'gvideos' => $gvideos, 'gmedia_count' => $gmedia_count, 'mems' => $gmems, 'gmem_count' => $gmem_count, 'is_mem' => $is_mem);
	  
  }
  
?>