public function executeBatchSend(sfWebRequest $request)
{
$limit = $request->getParameter('limit', 3);
$queues = MailQueueTable::getQueuesForSend($limit, false)->execute();
$keys = $queues->getPrimaryKeys();
if (!empty($keys)) {
MailQueueTable::getInstance()->CreateQuery('q')->update('MailQueue')->set('inprogress', '1')->where('id in (' . implode(',', $keys) . ')')->execute();
}
$i = 0;
foreach ($queues as $queue) {
$mailer = $this->getMailer();
$message = $mailer->compose(array($queue->from_mail => $queue->from_name), array($queue->to_email => $queue->to_name), $queue->subject, $queue->content);
$message->setBody($queue->content, 'text/html');
if ($mailer->send($message)) {
$queue->setSended(true);
$queue->save();
$i++;
}
}
echo $i . ' level lett kiküldve';
return sfView::NONE;
}
/**
* This function runs all the table that uses the system default language
* Particular for 1.6.1, since 1.6 didn't convret all table
*/
function convertTableBySysDefault_161(){
global $errors;
$temp_table = new AdminsTable($this->table_prefix, 'admins', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'admins was not converted.';
$_SESSION['redo_conversion'][$course_title]['AdminsTable'] = array($this->table_prefix, 'admins', $this->sys_default_lang, $course_id);
}
$temp_table = new AdminLogTable($this->table_prefix, 'admin_log', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'admin_log was not converted.';
$_SESSION['redo_conversion'][$course_title]['AdminLogTable'] = array($this->table_prefix, 'admin_log', $this->sys_default_lang, $course_id);
}
$temp_table = new AutoEnrollTable($this->table_prefix, 'auto_enroll', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'auto_enroll was not converted.';
$_SESSION['redo_conversion'][$course_title]['AutoEnrollTable'] = array($this->table_prefix, 'auto_enroll', $this->sys_default_lang, $course_id);
}
$temp_table = new AutoEnrollCoursesTable($this->table_prefix, 'auto_enroll_courses', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'auto_enroll_courses was not converted.';
$_SESSION['redo_conversion'][$course_title]['AutoEnrollCourses'] = array($this->table_prefix, 'auto_enroll_courses', $this->sys_default_lang, $course_id);
}
$temp_table = new ConfigTable($this->table_prefix, 'config', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'config was not converted.';
$_SESSION['redo_conversion'][$course_title]['ConfigTable'] = array($this->table_prefix, 'config', $this->sys_default_lang, $course_id);
}
$temp_table = new CourseAccessTable($this->table_prefix, 'course_access', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'course_access was not converted.';
$_SESSION['redo_conversion'][$course_title]['CourseAccessTable'] = array($this->table_prefix, 'course_access', $this->sys_default_lang, $course_id);
}
$temp_table = new CourseStatsTable($this->table_prefix, 'course_stats', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'course_stats was not converted.';
$_SESSION['redo_conversion'][$course_title]['CourseStatsTable'] = array($this->table_prefix, 'course_stats', $this->sys_default_lang, $course_id);
}
$temp_table = new FeedsTable($this->table_prefix, 'feeds', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'feeds was not converted.';
$_SESSION['redo_conversion'][$course_title]['FeedsTable'] = array($this->table_prefix, 'feeds', $this->sys_default_lang, $course_id);
}
$temp_table = new FileStorageGroupsTable($this->table_prefix, 'file_storage_groups', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'file_storage_groups was not converted.';
$_SESSION['redo_conversion'][$course_title]['FileStorageGroupsTable'] = array($this->table_prefix, 'file_storage_groups', $this->sys_default_lang, $course_id);
}
$temp_table = new ForumsAccessedTable($this->table_prefix, 'forums_accessed', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'forums_accessed was not converted.';
$_SESSION['redo_conversion'][$course_title]['ForumsAccessedTable'] = array($this->table_prefix, 'forums_accessed', $this->sys_default_lang, $course_id);
}
$temp_table = new ForumsCoursesTable($this->table_prefix, 'forums_courses', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'forums_courses was not converted.';
$_SESSION['redo_conversion'][$course_title]['ForumsCoursesTable'] = array($this->table_prefix, 'forums_courses', $this->sys_default_lang, $course_id);
}
$temp_table = new ForumsGroupsTable($this->table_prefix, 'forums_groups', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'forums_groups was not converted.';
$_SESSION['redo_conversion'][$course_title]['ForumsGroupsTable'] = array($this->table_prefix, 'forums_groups', $this->sys_default_lang, $course_id);
}
$temp_table = new ForumsSubscriptionsTable($this->table_prefix, 'forums_subscriptions', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'forums_subscriptions was not converted.';
$_SESSION['redo_conversion'][$course_title]['ForumsSubscriptionsTable'] = array($this->table_prefix, 'forums_subscriptions', $this->sys_default_lang, $course_id);
}
$temp_table = new GroupsMembersTable($this->table_prefix, 'groups_members', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'groups_members was not converted.';
$_SESSION['redo_conversion'][$course_title]['GroupsMembersTable'] = array($this->table_prefix, 'groups_members', $this->sys_default_lang, $course_id);
}
$temp_table = new HandbookNotesTable($this->table_prefix, 'handbook_notes', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'handbook_notes was not converted.';
$_SESSION['redo_conversion'][$course_title]['HandbookNotesTable'] = array($this->table_prefix, 'handbook_notes', $this->sys_default_lang, $course_id);
}
$temp_table = new InstructorApprovalsTable($this->table_prefix, 'instructor_approvals', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'instructor_approvals was not converted.';
$_SESSION['redo_conversion'][$course_title]['InstructorApprovalsTable'] = array($this->table_prefix, 'instructor_approvals', $this->sys_default_lang, $course_id);
}
$temp_table = new LanguagesTable($this->table_prefix, 'languages', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'languages was not converted.';
$_SESSION['redo_conversion'][$course_title]['LanguagesTable'] = array($this->table_prefix, 'languages', $this->sys_default_lang, $course_id);
}
$temp_table = new LanguagePagesTable($this->table_prefix, 'language_pages', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'language_pages was not converted.';
$_SESSION['redo_conversion'][$course_title]['LanguagePagesTable'] = array($this->table_prefix, 'language_pages', $this->sys_default_lang, $course_id);
}
$temp_table = new LanguageTextTable($this->table_prefix, 'language_text', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'language_text was not converted.';
$_SESSION['redo_conversion'][$course_title]['LanguageTextTable'] = array($this->table_prefix, 'language_text', $this->sys_default_lang, $course_id);
}
$temp_table = new MailQueueTable($this->table_prefix, 'mail_queue', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'mail_queue was not converted.';
$_SESSION['redo_conversion'][$course_title]['MailQueueTable'] = array($this->table_prefix, 'mail_queue', $this->sys_default_lang, $course_id);
}
$temp_table = new MasterListTable($this->table_prefix, 'master_list', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'master_list was not converted.';
$_SESSION['redo_conversion'][$course_title]['MasterListTable'] = array($this->table_prefix, 'master_list', $this->sys_default_lang, $course_id);
}
$temp_table = new MemberTrackTable($this->table_prefix, 'member_track', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'member_track was not converted.';
$_SESSION['redo_conversion'][$course_title]['MemberTrackTable'] = array($this->table_prefix, 'member_track', $this->sys_default_lang, $course_id);
}
$temp_table = new ModulesTable($this->table_prefix, 'modules', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'modules was not converted.';
$_SESSION['redo_conversion'][$course_title]['ModulesTable'] = array($this->table_prefix, 'modules', $this->sys_default_lang, $course_id);
}
$temp_table = new PollsMembersTable($this->table_prefix, 'polls_members', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'polls_members was not converted.';
$_SESSION['redo_conversion'][$course_title]['PollsMembersTable'] = array($this->table_prefix, 'polls_members', $this->sys_default_lang, $course_id);
}
$temp_table = new RelatedContentTable($this->table_prefix, 'related_content', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'related_content was not converted.';
$_SESSION['redo_conversion'][$course_title]['RelatedContentTable'] = array($this->table_prefix, 'related_content', $this->sys_default_lang, $course_id);
}
$temp_table = new TestsGroupsTable($this->table_prefix, 'tests_groups', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'tests_groups was not converted.';
$_SESSION['redo_conversion'][$course_title]['TestsGroupsTable'] = array($this->table_prefix, 'tests_groups', $this->sys_default_lang, $course_id);
}
$temp_table = new TestsQuestionsAssocTable($this->table_prefix, 'tests_questions_assoc', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'tests_questions_assoc was not converted.';
$_SESSION['redo_conversion'][$course_title]['TestsQuestionsAssocTable'] = array($this->table_prefix, 'tests_questions_assoc', $this->sys_default_lang, $course_id);
}
$temp_table = new TestsResultsTable($this->table_prefix, 'tests_results', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'tests_results was not converted.';
$_SESSION['redo_conversion'][$course_title]['TestsResultsTable'] = array($this->table_prefix, 'tests_results', $this->sys_default_lang, $course_id);
}
$temp_table = new ThemesTable($this->table_prefix, 'themes', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'themes was not converted.';
$_SESSION['redo_conversion'][$course_title]['ThemesTable'] = array($this->table_prefix, 'themes', $this->sys_default_lang, $course_id);
}
$temp_table = new UsersOnlineTable($this->table_prefix, 'users_online', $this->sys_default_lang);
if (!$temp_table->convert()){
$errors[]= $this->table_prefix.'users_online was not converted.';
$_SESSION['redo_conversion'][$course_title]['UsersOnlineTable'] = array($this->table_prefix, 'users_online', $this->sys_default_lang, $course_id);
}
}