Add one field “上半场” to match

Add Field

First of all, add this field in phpMyAdmin:

ALTER TABLE  `jos_bl_match` ADD  `first_half` VARCHAR( 10 ) NOT NULL DEFAULT  '' AFTER  `score2`

Then, alert View jos_bl_arrangement to include this new 'first_half'.

/administrator/components/com_joomsport/admin.joomsport.html.php

對函數‘bl_editMatch’，增加：

	<!-- first half added by Vincent 20th-May-2012 -->
	<tr>
		<td width="100">
			<?php echo JText::_( '上半場比分' ); ?>
		</td>
		<td>
			<?php echo '<input type="text" name="first_half" value="'.$row->first_half.'" size="5" maxlength="10" />';?>
		</td>
	</tr>
	<!-- end -->

No need to change the saving function, because that behavior is performed by default.

Show this new item in the layout:

 

Alter View: Arrangement

Export the SQL to back up.

Download the SQL, like:

-- phpMyAdmin SQL Dump
-- version 3.4.3.1
-- http://www.phpmyadmin.net
--
-- 主機: localhost
-- 產生日期: 2012 年 05 月 20 日 13:25
-- 伺服器版本: 5.1.57
-- PHP 版本: 5.2.17

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- 資料庫: `cmculcator_soccer`
--

-- --------------------------------------------------------

--
--  view結構 `jos_bl_arrangement`
--

CREATE ALGORITHM=UNDEFINED DEFINER=`cmculcator`@`localhost` SQL SECURITY DEFINER VIEW `jos_bl_arrangement` AS select `m`.`m_id` AS `mday_id`,month(`m`.`m_date`) AS `mon`,date_format(`m`.`m_date`,'%d/%m/%Y') AS `m_date`,dayofweek(`m`.`m_date`) AS `dayweek`,`m`.`team2_id` AS `team2_id`,`m`.`team1_id` AS `team1_id`,`m`.`score1` AS `score1`,`m`.`score2` AS `score2`,`m`.`m_time` AS `m_time`,`m`.`m_location` AS `m_location`,`m`.`m_remark` AS `m_remark`,`t1`.`t_name` AS `home`,`t2`.`t_name` AS `away`,`g1`.`group_name` AS `homegroup`,`g2`.`group_name` AS `awaygroup`,`g1`.`s_id` AS `season_id1`,`g2`.`s_id` AS `season_id2` from ((((((`jos_bl_match` `m` join `jos_bl_teams` `t1`) join `jos_bl_teams` `t2`) join `jos_bl_grteams` `gt1`) join `jos_bl_grteams` `gt2`) join `jos_bl_groups` `g1`) join `jos_bl_groups` `g2`) where ((`t1`.`id` = `m`.`team1_id`) and (`t1`.`id` = `gt1`.`t_id`) and (`gt1`.`g_id` = `g1`.`id`) and (`t2`.`id` = `m`.`team2_id`) and (`t2`.`id` = `gt2`.`t_id`) and (`gt2`.`g_id` = `g2`.`id`));

--
-- VIEW  `jos_bl_arrangement`
-- 資料: 無
--


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Modify it, and then use the changed SQL to update the view: