StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP cron job Codes not functioning properly
primarykey
Id
17736514
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
9
CommunityOwnedDate
CreationDate
2013-07-19T01:01:02.113
FavoriteCount
1
LastActivityDate
2013-07-19T01:50:12.897
LastEditDate
2013-07-19T01:50:12.897
LastEditorUserId
1068539
OwnerUserId
2130080
ParentId
0
PostTypeId
1
Score
0
ViewCount
182
LastEditorDisplayName
text
Body
<p>My cron job is not generating report from my moodle database.</p> <p>There is no mistake with my query, it just doesn't display the result. </p> <p>By the way my moodle version is 2.2</p> <p>Any help?</p> <p>Here is the php code:</p> <pre><code><? $username="****"; $password="#####"; $database="moodle"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "SELECT user.firstname, user.lastname, stats.userid, stats.roleid, SUM( statsreads ) AS numreads, SUM( statswrites ) AS numwrites, SUM( statsreads ) + SUM( statswrites ) AS totalactivity FROM `mdl_stats_user_daily` stats, `mdl_user` user WHERE userid IN (SELECT userid FROM mdl_role_assignments WHERE roleid IN (1,2,3,4)) AND user.id = stats.userid AND stats.timeend > ".(time() - 604800)." GROUP BY userid ORDER BY totalactivity DESC"; $result=mysql_query($query); $num_rows = mysql_num_rows($result); echo "$num_rows Rows\n"; echo "To: arjay.almanzor@gmail.com\n"; echo "From: \"Arjay Almanzor\" root@sesc.org\n"; echo "Subject: Weekly Moodle Report\n"; echo "Content-Type: text/html; charset=\"us-ascii\"\n"; echo "<html> <body>\n"; echo "<h1>Moodle Report</h1>"; echo "as of ".date('l jS \of F Y h:i:s A'); echo "<h2>Top Users This Week</h1>\n"; echo "<table>\n"; echo "<tr><td>First Name</td><td>Last Name</td><td>Total Activity(Pageviews/Updates) </td>"; while ($row = mysql_fetch_assoc($result)) { echo "<tr>"; echo "<td>".$row['firstname']."</td>"; echo "<td>".$row['lastname']."</td>"; echo "<td>".$row['totalactivity']."</td>"; echo "</tr>"; echo "\n"; } echo "</table>\n"; $query = "SELECT user.firstname, user.lastname, stats.userid, stats.roleid, SUM( statsreads ) AS numreads, SUM( statswrites ) AS numwrites, SUM( statsreads ) + SUM( statswrites ) AS totalactivity FROM `mdl_stats_user_monthly` stats, `mdl_user` user WHERE userid IN (SELECT userid FROM mdl_role_assignments WHERE roleid IN (1,2,3,4)) AND user.id = stats.userid AND stats.timeend > ".(time() - 2419200)." GROUP BY userid ORDER BY totalactivity DESC"; $result=mysql_query($query); echo "<h2>Top Users This Month</h1>\n"; echo "<table>\n"; echo "<tr><td>First Name</td><td>Last Name</td><td>Total Activity(Pageviews/Updates) </td>"; while ($row = mysql_fetch_assoc($result)) { echo "<tr>"; echo "<td>".$row['firstname']."</td>"; echo "<td>".$row['lastname']."</td>"; echo "<td>".$row['totalactivity']."</td>"; echo "</tr>"; echo "\n"; } echo "</table>\n"; echo "</body> </html>"; mysql_close(); ?> </code></pre>
Tags
<php><cron><moodle>
Title
PHP cron job Codes not functioning properly
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USSharkofMirkwood
UserOwnerUserId
1. USYOUn'Me
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POPHP cron job Codes not functioning properly
  UserUserId
  USYOUn'Me
  VoteTypeVoteTypeId
  VTFavorite
2. VO
  singulars
  PostPostId
  POPHP cron job Codes not functioning properly
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
3. VO
  singulars
  PostPostId
  POPHP cron job Codes not functioning properly
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.