Index: viewheadline.php =================================================================== RCS file: /var/cvs/phpgroupware/headlines/viewheadline.php,v retrieving revision 1.9.4.1 diff -u -r1.9.4.1 viewheadline.php --- viewheadline.php 10 Oct 2003 01:13:44 -0000 1.9.4.1 +++ viewheadline.php 13 Nov 2003 13:48:38 -0000 @@ -61,7 +61,7 @@ $phpgw->template->set_var('input_type',$phpgw->db->f('newstype')); - $phpgw->db->query('SELECT title,link FROM phpgw_headlines_cached' + $phpgw->db->query('SELECT title,url FROM phpgw_headlines_cached' . ' WHERE site=' . intval($con),__LINE__,__FILE__); $phpgw->template->set_var('th_bg2',$phpgw_info['theme']['th_bg']); @@ -77,7 +77,7 @@ while ($phpgw->db->next_record()) { $phpgw->nextmatchs->template_alternate_row_color($phpgw->template); - $phpgw->template->set_var('value','<a href="' . $phpgw->db->f('link') . '" target="_new">' . $phpgw->db->f('title') . '</a>'); + $phpgw->template->set_var('value','<a href="' . $phpgw->db->f('url') . '" target="_new">' . $phpgw->db->f('title') . '</a>'); $phpgw->template->parse('listing_rows','listing_row',True); } Index: inc/functions.inc.php =================================================================== RCS file: /var/cvs/phpgroupware/headlines/inc/Attic/functions.inc.php,v retrieving revision 1.16.4.1 diff -u -r1.16.4.1 functions.inc.php --- inc/functions.inc.php 10 Oct 2003 01:13:45 -0000 1.16.4.1 +++ inc/functions.inc.php 13 Nov 2003 13:48:38 -0000 @@ -99,7 +99,7 @@ // get the links from the database function getLinksDB() { - $GLOBALS['phpgw']->db->query("SELECT title, link FROM phpgw_headlines_cached WHERE site = ".$this->con); + $GLOBALS['phpgw']->db->query("SELECT title, url FROM phpgw_headlines_cached WHERE site = ".$this->con); if (! $GLOBALS['phpgw']->db->num_rows()) { Index: setup/tables_baseline.inc.php =================================================================== RCS file: /var/cvs/phpgroupware/headlines/setup/tables_baseline.inc.php,v retrieving revision 1.2 diff -u -r1.2 tables_baseline.inc.php --- setup/tables_baseline.inc.php 23 Sep 2001 11:47:13 -0000 1.2 +++ setup/tables_baseline.inc.php 13 Nov 2003 13:48:38 -0000 @@ -37,7 +37,7 @@ 'fd' => array( 'site' => array('type' => 'int', 'precision' => 4,'nullable' => False), 'title' => array('type' => 'varchar', 'precision' => 255,'nullable' => True), - 'link' => array('type' => 'varchar', 'precision' => 255,'nullable' => True) + 'url' => array('type' => 'varchar', 'precision' => 255,'nullable' => True) ), 'pk' => array(), 'fk' => array(), Index: setup/tables_current.inc.php =================================================================== RCS file: /var/cvs/phpgroupware/headlines/setup/tables_current.inc.php,v retrieving revision 1.5 diff -u -r1.5 tables_current.inc.php --- setup/tables_current.inc.php 22 Sep 2001 02:05:38 -0000 1.5 +++ setup/tables_current.inc.php 13 Nov 2003 13:48:38 -0000 @@ -37,7 +37,7 @@ 'fd' => array( 'site' => array('type' => 'int', 'precision' => 4,'nullable' => False), 'title' => array('type' => 'varchar', 'precision' => 255,'nullable' => True), - 'link' => array('type' => 'varchar', 'precision' => 255,'nullable' => True) + 'url' => array('type' => 'varchar', 'precision' => 255,'nullable' => True) ), 'pk' => array(), 'fk' => array(), Index: setup/tables_update.inc.php =================================================================== RCS file: /var/cvs/phpgroupware/headlines/setup/tables_update.inc.php,v retrieving revision 1.1 diff -u -r1.1 tables_update.inc.php --- setup/tables_update.inc.php 22 Sep 2001 02:05:38 -0000 1.1 +++ setup/tables_update.inc.php 13 Nov 2003 13:48:38 -0000 @@ -24,4 +24,14 @@ return $setup_info['headlines']['currentver']; } -?> \ No newline at end of file + + $test[] = '0.8.1.001'; + function headlines_upgrade0_8_1_001() + { + $GLOBALS['setup_info']->oProc->RenameColumn('phpgw_p_projects','num','p_number',True); + + $GLOBALS['setup_info']['headlines']['currentver'] = '0.8.1.002'; + return $GLOBALS['setup_info']['headlines']['currentver']; + } + +?>