$query = DBQuery("SELECT * FROM esselbach_st_subscribers WHERE sub_user = '$ldata[0]' AND sub_file = '$id' OR sub_user = '$ldata[0]' AND sub_file = '0'");

                     

                    if (!mysql_num_rows($query))

                    {

                        echo GetTemplate("download_error_subscribersonly");

                        FooterBlock();

                        echo GetTemplate("footer");

                        exit;

                    }

                     

                    $subinfo = mysql_fetch_array($query);

                    $ddate = explode("-", $subinfo[sub_expire]);

                    $uedate = mktime (0, 0, 0, $ddate[2], $ddate[1], $ddate[0]);

                    $udate = time();

                     

                    if ($udate > $uedate)

                    {

                        echo GetTemplate("download_error_subscribersonly");

                        FooterBlock();

                        echo GetTemplate("footer");

                        exit;

                    }