@storedusername = cookies[:usernamecookie]
    @storedpassword = cookies[:userpasswordcookie]

    @multimedia_title = Array.new
    @multimedia_path = Array.new
    @multimedia_id = Array.new

    i = 0

      for ii in MemberMultimedia.find(:all, :conditions => "image_path is null and video_path is not null and youtube_video_url is null",:order =>"id DESC",:limit=>5)
        @multimedia_title[i] = ii.video_name
        @multimedia_id[i] = ii.member_id
        @multimedia_path[i] = ii.video_path
      i=i+2
      end
    i=1

      for ii in MemberMultimedia.find(:all, :conditions => "image_path is null and video_path is not null and youtube_video_url is not null",:order =>"id DESC",:limit=>5)
        @multimedia_title[i] = ii.video_name
        @multimedia_id[i] = ii.member_id
        @multimedia_path[i] = ii.video_path
      i=i+2
    end
    session['totalmembers'] = Member.count_by_sql("select count(*) from members where activation_status=0")
    session['totalloggedin'] = Member.count_by_sql(["select count(*) from members where online_status=1"])
    session['totalblogsposted'] = MemberBlog.count_by_sql(["select count(*) from member_blogs"])
    session['totalmultimediastaff'] = MemberMultimedia.count_by_sql(["select count(*) from member_multimedias"])

    @blogs_list = MemberBlog.find_by_sql(
      "SELECT "+
      "member_blog_posts.id as post_id, post_title, LEFT(post_text, 160) as post_message, blog_title, post_date_time, first_name, "+
      "member_infos.member_id as member_id, age, TIMESTAMPDIFF (MINUTE, post_date_time, CURRENT_TIMESTAMP()) as diff "+
      "FROM "+
      "member_blogs, member_blog_posts, member_infos "+
      "WHERE  member_blog_posts.publish= 1 and "+
      "member_infos.member_id = member_blogs.member_id and member_infos.member_id = member_blog_posts.member_id "+
      "order by "+
      "member_blog_posts.id desc limit 0,3")

    @top_blogs = MemberBlog.find_by_sql("SELECT member_blogs.id, post_date_time, member_blogs.member_id, member_blogs.blog_title, blog_voting_rank FROM member_blogs, member_blog_posts where member_blog_posts.publish= 1 and member_blogs.id=member_blog_posts.member_blog_id and member_blogs.blog_voting_rank > 0 group by blog_title LIMIT 0 , 3")
    @members=Member.find(:all,:order =>"id DESC")
    @top_blogs = MemberBlog.find_by_sql("SELECT member_blogs.id, post_date_time, member_blogs.member_id, member_blogs.blog_title, blog_voting_rank FROM member_blogs, member_blog_posts where member_blog_posts.publish= 1 and member_blogs.id=member_blog_posts.member_blog_id and member_blogs.blog_voting_rank > 0 group by blog_title LIMIT 0 , 3")
    @new_members = MemberInfo.find(:all, :conditions=>"#{Date.today} - date_of_joining <= 15 - member_image_path is not null", :limit=>25, :order=>"id desc")
    @country_lists = MemberCountry.find(:all, :order=>"country_name ASC")
    @group_clouds = Group.find(:all,:order=>"'id' desc" ,:limit=>15)
    @allmem=Member.find(:all,:conditions=>"activation_status=0")
    @online=Member.find(:all,:conditions=>"online_status=1")
    @top_members = Member.find(:all, :conditions=>"activation_status != 1 and rank_position >=1 and rank_position <=100", :order=> "RAND()", :limit=>3)