$SystemModuleKey="quiz";
include("../../kcontrol/quiz/config.php");
$sql="SELECT ".$myModule_Table_Quiz_Group."_Name, ".$myModule_Table_Quiz_Group."_Desc,".$myModule_Table_Quiz_Group."_ID FROM ".$myModule_Table_Quiz_Group." WHERE ".$myModule_Table_Quiz_Group."_Status='Enable' AND ".$myModule_Table_Quiz_Group."_ModuleKey='".$SystemModuleKey."' AND ".$myModule_Table_Quiz_Group."_Language='".$System_Session_Language."' ORDER BY ".$myModule_Table_Quiz_Group."_Order Desc";
$query_group=mysql_query($sql);
while($row_group=mysql_fetch_array($query_group)){
?>
=$row_group[$myModule_Table_Quiz_Group."_Name"]?>
$sql="SELECT * FROM ".$myModule_Table_Quiz." WHERE ".$myModule_Table_Quiz."_GroupID='".$row_group[$myModule_Table_Quiz_Group."_ID"]."' AND ".$myModule_Table_Quiz."_Status='Enable' ORDER BY ".$myModule_Table_Quiz."_Order DESC LIMIT 0,1 ";
$query=mysql_query($sql);
$row=mysql_fetch_array($query);
if($row[$myModule_Table_Quiz."_PictureFile"]!=""){
$PicturePath=$System_RootPath_Upload."/".$SystemModuleKey."/thumbnail/".$row[$myModule_Table_Quiz."_PictureFile"];
}else{
$PicturePath=$System_RootPath."/images/default.gif";
}
if(mysql_num_rows($query)>0){
?>
$MySession=session_id();
$sql="SELECT count(*) FROM ".$myModule_Table_Counter_Check." WHERE ".$myModule_Table_Counter_Check."_Session='".$MySession."' AND ".$myModule_Table_Counter_Check."_CreateDate='".date('Y-m-d')."' AND ".$myModule_Table_Counter_Check."_CID=".$CounterID;
$Query_Counter=mysql_query($sql);
$Row_Counter=mysql_fetch_row($Query_Counter);
if($Row_Counter[0]==0){
$sql="UPDATE ".$myModule_Table_Counter." SET ".$myModule_Table_Counter."_Counter=".$myModule_Table_Counter."_Counter+1 WHERE ".$myModule_Table_Counter."_Key='".$CounterKey."' ";
$Query=mysql_query($sql);
$sql="INSERT INTO ".$myModule_Table_Counter_Check." ( ".$myModule_Table_Counter_Check."_CID,".$myModule_Table_Counter_Check."_Session,".$myModule_Table_Counter_Check."_CreateDate )VALUES( ".$CounterID.",'".$MySession."',NOW()) ";
$Query=mysql_query($sql);
}
$sql="DELETE FROM ".$myModule_Table_Counter_Check." WHERE ".$myModule_Table_Counter_Check."_CreateDate < '".date('Y-m-d')."'";
$Query=mysql_query($sql);
?>