Update of /cvsroot/logicampus/logicampus/src/logicreate/services/welcome
In directory sc8-pr-cvs6.sourceforge.net:/tmp/cvs-serv24452/welcome
Modified Files:
dummy_students.lcp news.lcp
Log Message:
Change function "next_record" to "nextRecord".
Index: news.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/welcome/news.lcp,v
retrieving revision 1.2
retrieving revision 1.3
diff -C2 -d -r1.2 -r1.3
*** news.lcp 10 Nov 2006 20:16:45 -0000 1.2
--- news.lcp 8 Oct 2007 14:31:26 -0000 1.3
***************
*** 11,16 ****
$db->queryOne("select * from lcHtml where filename='welcome.html' $where");
! $t["title"] = $db->Record["title"];
! $t["file"] = $db->Record[filename];
/********
* The following two SQL queries only pull articles
--- 11,16 ----
$db->queryOne("select * from lcHtml where filename='welcome.html' $where");
! $t["title"] = $db->record["title"];
! $t["file"] = $db->record[filename];
/********
* The following two SQL queries only pull articles
***************
*** 28,38 ****
$db->query("select introtext, title, articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'Articles' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
$db->RESULT_TYPE = MYSQL_ASSOC;
! while ($db->next_record() ) {
! $t[articles][] = PersistantObject::createFromArray("NewsArticle",$db->Record);
}
$db->query("select introtext,title,articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'News' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
$db->RESULT_TYPE = MYSQL_ASSOC;
! while ($db->next_record() ) {
! $t[news][] = PersistantObject::createFromArray("NewsArticle",$db->Record);
}
--- 28,38 ----
$db->query("select introtext, title, articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'Articles' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
$db->RESULT_TYPE = MYSQL_ASSOC;
! while ($db->nextRecord() ) {
! $t[articles][] = PersistantObject::createFromArray("NewsArticle",$db->record);
}
$db->query("select introtext,title,articles.pkey from articles left join lcCategories on lcCategories.pkey = articles.catid where lcCategories.name = 'News' and (articles.startdate <= ".DB::getFuncName('NOW()')." and articles.enddate >= ".DB::getFuncName('NOW()').") and ( ($groups) and not ($notgroups)) and status='Active' order by pkey DESC limit 2");
$db->RESULT_TYPE = MYSQL_ASSOC;
! while ($db->nextRecord() ) {
! $t[news][] = PersistantObject::createFromArray("NewsArticle",$db->record);
}
Index: dummy_students.lcp
===================================================================
RCS file: /cvsroot/logicampus/logicampus/src/logicreate/services/welcome/dummy_students.lcp,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** dummy_students.lcp 9 Feb 2007 19:49:49 -0000 1.4
--- dummy_students.lcp 8 Oct 2007 14:31:26 -0000 1.5
***************
*** 26,33 ****
$db->query($sql);
! while ( $db->next_record() ) {
$sql = "insert into class_assignments_link
! set id_class_assignments='{$db->Record['id_class_assignments']}',
! id_class_lessons='{$db->Record['id_class_lessons']}'";
$db2->query($sql);
}
--- 26,33 ----
$db->query($sql);
! while ( $db->nextRecord() ) {
$sql = "insert into class_assignments_link
! set id_class_assignments='{$db->record['id_class_assignments']}',
! id_class_lessons='{$db->record['id_class_lessons']}'";
$db2->query($sql);
}
|
