public string mdl_question_attempt_steps_max()
{
string procname = @"SELECT max(id) FROM `mdl_question_attempt_steps` WHERE 1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
public string mdl_logstore_standard_log_DS_Top1()
{
string procname = @"SELECT userid from mdl_logstore_standard_log ORDER BY mdl_logstore_standard_log.timecreated DESC LIMIT 0,1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
public string mdl_quiz_grades_ID_1()
{
string procname = @"ALTER TABLE `mdl_quiz_grades` AUTO_INCREMENT = 1";
DbAccessMySqlOffline db = new DbAccessMySqlOffline();
db.CreateNewSqlCommand_Text();
return(db.ExecuteData_string(procname));
}
