[Logicampus-cvs] logicampus/src/logicreate/services/welcome dummy_students.lcp, 1.4, 1.5 news.lcp,
Brought to you by:
trilexcom
From: Mark K <har...@us...> - 2007-10-08 14:32:02
|
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); } |