[HowTO] add cronjob on Debian Lenny Improved

Code:
<?php

/*

* (?) 2009, Russia, Moscow

* Serge Obookhoff AKA Hong Lee

* www.data-stream.ru && www.veterinars.ru

* Last Revision at 01/2009

*     Written for ispCP Team (www.isp-control.net) ONLY.

*     Written using the old, dead blanks VHCS.

* All Functions rewritten.

*

* Notice: If you use this script you have own risks.

*

*

* Modified on 29-12-2009 by xtc007

* Functionality added : fixed white square display in top on 1.0.3

* RT Media Inc ~ www.rtmedia.ca

* 

*/



require '../include/ispcp-lib.php';



check_login(__FILE__);



$tpl = new pTemplate();

$tpl->define_dynamic('page', Config::get('CLIENT_TEMPLATE_PATH') . '/cronjobs_overview.tpl');

$tpl->define_dynamic('page_message', 'page');

$tpl->define_dynamic('logged_from', 'page');

$tpl->define_dynamic('cronjobs', 'page');



$theme_color = Config::get('USER_INITIAL_THEME');



$tpl->assign(

    array('TR_CLIENT_CRONJOBS_TITLE' => tr('ispCP - Client/Cronjob Manager'),

        'THEME_COLOR_PATH' => "../themes/$theme_color",

        'THEME_CHARSET' => tr('encoding'),

        'ISP_LOGO' => get_logo($_SESSION['user_id'])

        )

    );



# Getting user's right to reading and using  the Jobs











function gen_cron_user(&$tpl, &$sql, $domain) {

# 

}



function gen_cron_jobs(&$tpl, &$sql, $user_id) {



    $query = <<<SQL_QUERY

        SELECT

            id, name, lastrun, activ, coment, domain

        FROM

            hcrondtab

        WHERE

            domain = $user_id

        ORDER BY

            id

SQL_QUERY;



    $rs = exec_query($sql, $query, array($user_id));



    if ($rs->RecordCount() == 0) {

        $tpl->assign(

            array('NAME' => tr('Jobs list is empty!'),

                'DESCRIPTION' => '',

                'ACTIVE' => '',

                'LASTRUN' => '',

                'EDIT' => '',

                'DELETE' => ''

                )

            );



    } else {



        $counter = 0;

        while (!$rs->EOF) {

            if ($counter % 2 == 0) {

                $tpl->assign('ITEM_CLASS', 'content');

            } else {

                $tpl->assign('ITEM_CLASS', 'content2');

            }



            if ($rs->fields['activ'] == 1) {$activ = 'Yes';}

            else {$activ = 'No';};

            $lastrun = $rs->fields['lastrun'];

            if ($lastrun == 0 ) {$lastrun = '';}

                else {$lastrun = date("Y-m-d H:i:s",$lastrun);}

            $tpl->assign(

                array('NAME' => $rs->fields['name'],

                    'DESCRIPTION' => $rs->fields['coment'],

                    'LASTRUN' => $lastrun,

                    'ACTIVE' => $activ,

                    'ID'  => $rs->fields['id'],

                    'EDIT' => '<img src="{THEME_COLOR_PATH}/images/icons/edit.png" width="16" height="16" align="absmiddle"> <a href="cronjobs_edit.php?cron_id={ID}" class="link">{TR_EDIT}</a>',

                    'DELETE' => '<img src="{THEME_COLOR_PATH}/images/icons/delete.png" width="16" height="16" border="0" align="absmiddle"> <a href="#" class="link" onclick="action_delete(\'cronjobs_delete.php?cron_id={ID}\', \'{NAME}\')">{TR_DELETE}</a>'

                    )

                );

            $tpl->parse('CRONJOBS', '.cronjobs');

            $rs->MoveNext();

            $counter++;

        }



    }



} // End of gen_cron_job();



/*

 *

 * static page messages.

 *

 */



gen_client_mainmenu($tpl, Config::get('CLIENT_TEMPLATE_PATH') . '/main_menu_webtools.tpl');

gen_client_menu($tpl, Config::get('CLIENT_TEMPLATE_PATH') . '/menu_webtools.tpl');



gen_logged_from($tpl);



check_permissions($tpl);



gen_cron_jobs($tpl, $sql, $_SESSION['user_id']);



$tpl->assign(

    array('TR_CRON_MANAGER' => tr('Cronjob Manager'),

        'TR_MESSAGE_DELETE' => tr('Are you sure you want to delete %s?', true, '%s'),

        'TR_CRONJOBS' => tr('Cronjobs'),

        'TR_ACTIVE' => tr('Active'),

        'TR_ACTION' => tr('Active'),

        'TR_EDIT' => tr('Edit'),

        'TR_DELETE' => tr('Delete'),

        'TR_ADD' => tr('Add Cronjob')

        )

    );



gen_page_message($tpl);



$tpl->parse('PAGE', 'page');

$tpl->prnt();



if (Config::get('DUMP_GUI_DEBUG'))

    dump_gui_debug();



unset_messages();



?>