mdl & time

select * from mdl_log,mdl_block_timestat where mdl_log.id = mdl_block_timestat.log_id

id

SELECT course, FROM_UNIXTIME( timemodified ) FROM mdl_assign

SELECT id, FROM_UNIXTIME( timemodified ) FROM mdl_course

select course,FROM_UNIXTIME( timemodified ) FROM  mdl_feedback

select course,FROM_UNIXTIME( timemodified ) FROM  mdl_folder

SELECT courseid, FROM_UNIXTIME( timemodified ) FROM  `mdl_event`

select course,,FROM_UNIXTIME( timemodified ) from mdl_quiz


SELECT course, FROM_UNIXTIME( TIME )
FROM mdl_log
WHERE ACTION =  'update'
AND module =  'course'


select course,,FROM_UNIXTIME( timemodified ) from mdl_quiz

SELECT *,FROM_UNIXTIME(timemodified) FROM `mdl_event`

score of assignment

SELECT u.id,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email, u.id as userid, s.status as status, s.id as submissionid, s.timecreated as firstsubmission, s.timemodified as timesubmitted, s.attemptnumber as attemptnumber, g.id as gradeid, g.grade as grade, g.timemodified as timemarked, g.timecreated as firstmarked, uf.mailed as mailed, uf.locked as locked, uf.extensionduedate as extensionduedate, uf.workflowstate as workflowstate, uf.allocatedmarker as allocatedmarker FROM mdl_user u LEFT JOIN mdl_assign_submission s ON u.id = s.userid AND  s.latest = 1 LEFT JOIN mdl_assign_grades g ON u.id = g.userid AND g.attemptnumber = s.attemptnumber LEFT JOIN mdl_assign_user_flags uf ON u.id = uf.userid

SELECT c.id, c.shortname, g.assignment, a.name, u.username, g.grade
FROM prefix_assign_grades AS g
JOIN prefix_user AS u ON g.userid = u.id
JOIN prefix_assign AS a ON g.assignment = a.id
JOIN prefix_course AS c ON a.course = c.id
WHERE c.id = ## AND u.id = ##

Showing rows 0 - 29 ( 16,818 total, Query took 0.0011 sec)

SELECT u.id, u.picture, u.firstname, u.lastname, u.firstnamephonetic, u.lastnamephonetic, u.middlename, u.alternatename, u.imagealt, u.email, u.id AS userid, s.status AS
STATUS , s.id AS submissionid, s.timecreated AS firstsubmission, s.timemodified AS timesubmitted, s.attemptnumber AS attemptnumber, g.id AS gradeid, g.grade ASgrade, g.timemodified AS timemarked, g.timecreated AS firstmarked, uf.mailed AS mailed, uf.locked AS locked, uf.extensionduedate AS extensionduedate,uf.workflowstate AS workflowstate, uf.allocatedmarker AS allocatedmarker
FROM mdl_user u
LEFT JOIN mdl_assign_submission s ON u.id = s.userid
AND s.latest =1
LEFT JOIN mdl_assign_grades g ON u.id = g.userid
AND g.attemptnumber = s.attemptnumber
LEFT JOIN mdl_assign_user_flags uf ON u.id = uf.userid
LIMIT 0 , 30

can not install postgresql

https://ubuntuforums.org/showthread.php?t=2277582

https://askubuntu.com/questions/888098/ubuntuunable-to-correct-problems-you-have-held-broken-packages

4432

https://drive.google.com/file/d/0BxriXuT0xeaFZldxTlZRNUk3blU/view?usp=sharing

https://drive.google.com/file/d/0BxriXuT0xeaFa3g4V3BGcGl4b00/view?usp=sharing

love2

https://drive.google.com/file/d/0BxriXuT0xeaFYUo4cXJnZWRHMm8/view?usp=sharing

as

   <asp:GridView ID="GridView1" runat="server" AllowPaging="True"
            AutoGenerateColumns="False" CellPadding="4" EnableModelValidation="True"
            ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:TemplateField HeaderText="xtitle">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("xtitle") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("xtitle") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField HeaderText="xsubtitle">
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("xsubtitle") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("xsubtitle") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
        </asp:GridView>


 Protected Sub GridView1_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles GridView1.PageIndexChanging
        GridView1.PageIndex = e.NewPageIndex
        bindGridView()
    End Sub
    Sub bindGridView()
        Dim strDbCon As String = "Data Source=(local);Initial Catalog=DB14017;Persist Security Info=True;User ID=sa;Password=5342601water"
        Dim con As New SqlConnection(strDbCon)
        Dim ad As New SqlDataAdapter("select * from tw_job_tb where xpublish='yes' order by xcredate desc", con)
        Dim dt As New DataTable
        ad.Fill(dt)
        With GridView1
            .DataSource = dt
            .DataBind()

        End With
    End Subㄎ