Module: Heart::Vbulletin4

Defined in:
lib/heart/vbulletin4.rb

Instance Method Summary collapse

Instance Method Details

#fetch_vbulletin4BlogsNew ⇒ Object 



3
4
5
 
# File 'lib/heart/vbulletin4.rb', line 3

def fetch_vbulletin4BlogsNew
  self.vbulletin4BlogsNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM blog WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4InfractionsNew ⇒ Object 



7
8
9
 
# File 'lib/heart/vbulletin4.rb', line 7

def fetch_vbulletin4InfractionsNew
  self.vbulletin4InfractionsNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM infraction WHERE points > 0 AND dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4InfractionsNewWarning ⇒ Object 



11
12
13
 
# File 'lib/heart/vbulletin4.rb', line 11

def fetch_vbulletin4InfractionsNewWarning
  self.vbulletin4InfractionsNewWarning = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM infraction WHERE points = 0 AND dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4MessagesPrivateNew ⇒ Object 



39
40
41
 
# File 'lib/heart/vbulletin4.rb', line 39

def fetch_vbulletin4MessagesPrivateNew
  self.vbulletin4MessagesPrivateNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM pmtext WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4MessagesThanksNew ⇒ Object 



47
48
49
 
# File 'lib/heart/vbulletin4.rb', line 47

def fetch_vbulletin4MessagesThanksNew
  self.vbulletin4MessagesThanksNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM post_thanks WHERE date BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4MessagesVisitorNew ⇒ Object 



43
44
45
 
# File 'lib/heart/vbulletin4.rb', line 43

def fetch_vbulletin4MessagesVisitorNew
  self.vbulletin4MessagesVisitorNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM visitormessage WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4PostsNew ⇒ Object 



15
16
17
 
# File 'lib/heart/vbulletin4.rb', line 15

def fetch_vbulletin4PostsNew
  self.vbulletin4PostsNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM post WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4ThreadsNew ⇒ Object 



31
32
33
 
# File 'lib/heart/vbulletin4.rb', line 31

def fetch_vbulletin4ThreadsNew
  self.vbulletin4ThreadsNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM thread WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4ThreadsUpdated ⇒ Object 



35
36
37
 
# File 'lib/heart/vbulletin4.rb', line 35

def fetch_vbulletin4ThreadsUpdated
  self.vbulletin4ThreadsUpdated = Heart::Metric.find_by_sql("SELECT count(DISTINCT(threadid)) as the_count FROM post WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4UsersActivePosts ⇒ Object 



23
24
25
 
# File 'lib/heart/vbulletin4.rb', line 23

def fetch_vbulletin4UsersActivePosts
  self.vbulletin4UsersActivePosts = Heart::Metric.find_by_sql("SELECT count(DISTINCT(userid)) as the_count FROM post WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4UsersActiveThreads ⇒ Object 



27
28
29
 
# File 'lib/heart/vbulletin4.rb', line 27

def fetch_vbulletin4UsersActiveThreads
  self.vbulletin4UsersActiveThreads = Heart::Metric.find_by_sql("SELECT count(DISTINCT(postuserid)) as the_count FROM thread WHERE dateline BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end

#fetch_vbulletin4UsersNew ⇒ Object 



19
20
21
 
# File 'lib/heart/vbulletin4.rb', line 19

def fetch_vbulletin4UsersNew
  self.vbulletin4UsersNew = Heart::Metric.find_by_sql("SELECT count(*) as the_count FROM user WHERE joindate BETWEEN UNIX_TIMESTAMP('#{fulldate} 00:00:00') AND UNIX_TIMESTAMP('#{fulldate} 23:59:59')").first.the_count
end