index.php

dezender php 4 bb :-)

<?php
require( "functions.php" );
include_once( "common.php" );
checkinstallfolder( $smarty );
$smarty->assign( "section", "available courses and tests" );
$smarty->assign( "lector_email", $_SESSION['EMail'] );
if ( isset( $_SESSION['CurStudent'] ) )
{
    $smarty->assign( "cur_student", $_SESSION['CurStudent'] );
    if ( !( $new_result = mysql_query( "SELECT * FROM STUDENTS WHERE StudentID=".$_SESSION['CurStudentID'], $link ) ) )
    {
        displayerrmsg( sprintf( "internal error %d:%s\n", mysql_errno( ), mysql_error( ) ) );
        return 0;
    }
    $new_row = mysql_fetch_array( $new_result );
    $user_name = stripslashes( $new_row['Name'] );
    $user_name .= " ";
    $user_name .= stripslashes( $new_row['Surename'] );
    $smarty->assign( "user_name", $user_name );
}
if ( !( $result = mysql_query( "SELECT * FROM NEWS WHERE KillDate>".mktime( )." AND Date<=".mktime( )." ORDER BY Priority, DATE DESC LIMIT 0,10", $link ) ) )
{
    displayerrmsg( sprintf( "internal error %d:%s\n", mysql_errno( ), mysql_error( ) ) );
    return 0;
}
$num = 0;
while ( $row = mysql_fetch_array( $result ) )
{
    $news_top[$num]['NewsID'] = $row['NewsID'];
    $news_top[$num]['Subj'] = stripslashes( $row['Subj'] );
    $news_top[$num]['Date'] = date( "d M Y", $row['Date'] );
    ++$num;
}
if ( isset( $news_top ) )
{
    $smarty->assign( "news_top", $news_top );
}
$rs = mysql_query( "select value from SETTINGS where name='top_courses'", $link );
$top = mysql_fetch_array( $rs );
if ( $top['value'] == "last" )
{
    $query = "SELECT CourseID FROM COURSE WHERE Active='Y' ORDER BY Date desc Limit 3";
    $r1 = mysql_query( $query, $link );
    $i = 0;
    while ( $curs1 = mysql_fetch_array( $r1 ) )
    {
        $curs_id[$i] = $curs1['CourseID'];
        ++$i;
    }
    $curs_id = implode( " ,", $curs_id );
}
else
{
    $curs_id = explode( "_", $top['value'] );
    $curs_id = implode( " ,", $curs_id );
}
if ( $result = mysql_query( "SELECT CourseID, CategoryID, Subj, Descr, Image, Cost FROM COURSE WHERE CourseID in (".$curs_id.") ORDER BY CategoryID,priority", $link ) )
{
    $num = 0;
    while ( $row = mysql_fetch_array( $result ) )
    {
        if ( $row['Image'] )
        {
            $pathim = getcourseimagefolder( $row['CourseID'], $row['Subj'] );
            $pathim .= "/";
            $pathim .= urlencode( "thumb_".$row['Image'] );
            $image_size = getnewsize( $pathim );
            $course['image_width'] = $image_size['width'];
            $course['image_height'] = $image_size['height'];
            $courses_top[$num]['Image'] = "<img class='cur_top' src='".$pathim."'  ".getnewlittlesize( $pathim, 150, 75 )." >\n";
        }
        else
        {
            $courses_top[$num]['Image'] = "<div align='center' style='width: 150px; height: 75px; vertical-align: middle;' class='noimage'>NO IMAGE</div>";
        }
        $courses_top[$num]['CourseID'] = $row['CourseID'];
        $i = 0;
        if ( $new_result = mysql_query( "SELECT count(LessonID) as count FROM LESSONS WHERE CourseID=".$courses_top[$num]['CourseID']." AND free='1' Group BY LessonID Order BY LessonID", $link ) )
        {
            $new_row = mysql_fetch_array( $new_result );
            if ( 0 < $new_row['count'] )
            {
                $courses_top[$num]['lessonsfree'] = "free";
            }
        }
        $courses_top[$num]['Subj'] = stripslashes( $row['Subj'] );
        $courses_top[$num]['Cost'] = $row['Cost'];
        if ( $courses_top[$num]['Cost'] == 0 )
        {
            $courses_top[$num]['Cost'] = "free";
        }
        if ( 100 < strlen( $courses_top[$num]['Subj'] ) )
        {
            $courses_top[$num]['Subj'] = substr( $courses_top[$num]['Subj'], 0, 100 )."...";
        }
        $courses_top[$num]['Descr'] = stripslashes( $row['Descr'] );
        if ( 100 < strlen( $courses_top[$num]['Descr'] ) )
        {
            $courses_top[$num]['Descr'] = substr( $courses_top[$num]['Descr'], 0, 100 )."...";
        }
        if ( !( $categor_1 = mysql_query( "SELECT Subj as Category FROM COURSECATEGORY WHERE CategoryID=".$row['CategoryID'], $link ) ) )
        {
            displayerrmsg( sprintf( "internal error %d:%s\n", mysql_errno( ), mysql_error( ) ) );
            return 0;
        }
        $categor = mysql_fetch_array( $categor_1 );
        $courses_top[$num]['Category'] = $categor['Category'];
        if ( !( $new_result = mysql_query( "SELECT LessonID FROM LESSONS WHERE CourseID=".( $row['CourseID'] ), $link ) ) )
        {
            displayerrmsg( sprintf( "internal error %d:%s\n", mysql_errno( ), mysql_error( ) ) );
            return 0;
        }
        $new_row = mysql_num_rows( $new_result );
        if ( $new_row == 0 )
        {
            continue;
        }
        else
        {
            ++$num;
        }
    }
}
$smarty->assign( "courses_top", $courses_top );
( "courses_top_count", count( $courses_top ) );
$smarty->assign( "page", "home" );
( trimslash( $index_theme_path )."/index.tpl" );
?>