Subversion Repositories SmartDukaan

Rev

Rev 20479 | Rev 20481 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 20479 Rev 20480
Line 695... Line 695...
695 
				$options['conditions'] = array($type =>$search);
695 
				$options['conditions'] = array($type =>$search);
696 
			}else{
 696 
			}else{
697 
				$options['conditions'] = array($type.' LIKE '=>"%$search%");
697 
				$options['conditions'] = array($type.' LIKE '=>"%$search%");
698 
			}
 698 
			}
699 
		}else{
 699 
		}else{
700 
			$options['conditions'] = array('status'=>1, 'activated'=>null);
 700 
			$options['conditions'] = array('status'=>1, 'activated'=>0);
701 
			$options['limit']=10;
701 
			$options['limit']=10;
702 
		}
702 
		}
703 
		// $db = ConnectionManager::getDataSource("default"); // name of your database connection
 703 
		// $db = ConnectionManager::getDataSource("default"); // name of your database connection
704 
		// $last_act = $db->fetchAll("SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ");
 704 
		// $last_act = $db->fetchAll("SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ");
705 
		$sql = "SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ";
 705 
		$sql = "SELECT * from (SELECT * from daily_visitors order by visited desc) as x group by x.user_id ";