COSMOS
文章平均质量分 70
zlxadhkust
这个作者很懒,什么都没留下…
展开
-
Get Minutes for Match Event Back!!!
For the new pop-up window functionality, we need this field back.And how does the field look in real world?So this is the time when the backups come to be useful. I have backed up原创 2012-08-01 20:59:48 · 552 阅读 · 0 评论 -
Change Logo
1. update logo to overwrite the logo: /templates/gk_sporter/images/logo.png;2. open css: /templates/gk_sporter/css/template.css,To redefine the logo dimension:To redefine the height of t原创 2012-07-01 20:42:13 · 1831 阅读 · 0 评论 -
Parse Date-time From String With PHP & MySQL
STR_TO_DATE:You need to tell MySQL how to parse the string, and you do that byfiguring out the pattern and pass it to STR_TO_DATE() as the second parameter.DATE_FORMAT:This functio原创 2011-10-24 00:17:14 · 991 阅读 · 3 评论 -
Joomla! (DAY 10) - Joomsport (DAY 8): Create my own JElement
This is a trial on how to create a new JElement for menu type parameter: 'mon'.Before the view can receive the parameter, we need a interface for user to set the parameter; before that,原创 2011-10-25 16:55:51 · 806 阅读 · 0 评论 -
Add one field “上半场” to match
Add FieldFirst 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_原创 2012-05-20 13:48:52 · 557 阅读 · 0 评论 -
Joomla!1.5 Error 500: Layout 'xxx' not found
今天遇到这个奇怪的问题,之所以称其奇怪,是因为在上载到服务器空间之前在本地试过没有问题的。可是在服务器上面,开了之后竟然是赫然一个错误:在一阵子思考之后,我觉得还是应该是相应的PHP布局模板文件没有被找到,可是这怎么可能呢?从URL的链接来看,layout=kickoffSecondPart,而这个布局的这个模板的PHP和XML的文件名都和这个参数的值一模一样,在该视图原创 2012-04-24 16:40:36 · 5445 阅读 · 0 评论 -
Create Module for Joomla!1.5 - Investigation on JS Match Result
The XML of JoomSport Match Result is:<extension type="module" version="1.6.0" client="site" method="upgrade"> JoomSport match results BearDev April 2011 Copyright (C)2010 BearDev. All原创 2012-02-20 12:25:35 · 1036 阅读 · 0 评论 -
Apply JQuery UI in Joomla!1.5 site
Before that, I want to report one discovery:When I create my view layout for my component, if I use:it won't work, its width is not affected.However, if I use:generally spe原创 2012-02-18 22:32:20 · 843 阅读 · 0 评论 -
Change Log of Joomsport: 增加赛事晋级图第二至第四阶段布局
这个图表非常复杂,需要仔细分析下:Level1的比赛信息的格式有一些不同,其他level上面的就都是一样了。将 /administrator/components/com_joomsport/admin.joomsport.html.php中的方法bl_editMatch做修改:将:<?phpif(3 == $li原创 2012-01-15 22:59:12 · 697 阅读 · 0 评论 -
HTML 常用符号编码表
HTML Character Entity EncodingHTML Symbol Entities ReferenceStandard ASCII set, HTML Entity names, ISO 10646, ISO 8879, ISO 8859-1 Latin alphabet No. 1Browser support: All browse原创 2012-01-17 13:55:41 · 473 阅读 · 0 评论 -
Add Linkage between Team and MatchDay, with remarks and bonus
问题描述:在“成绩龙虎榜”里面,下属于联赛盃的第一循环和第二循环的数据都是联赛盃的总成绩的数据,即是错误。创建存储所以,我们首先需要一个新表,来表示matchday与team之间的直接关系,就像season_teams一样:我将称之为matchday_teams。通过输出season_teams表,得到一个SQL的参考,修改部分参数:原创 2012-07-07 22:11:38 · 777 阅读 · 0 评论 -
修正每个球队在每个赛季的额外信息的缺陷
保留已经建立的team与season关联的数据,和team与matchday关联的数据这些信息目前是额外扣除的纪律分与备注。问题在于(上篇描述过),当赛季被重新保存时,关于球队与该赛季的联合数据会被清除,原因是保存的方法是先删除season_teams表中所以属于该赛季的记录,然后再重新插入新记录,为每个球队。现在将要采取的解决办法是:首先验证每个球原创 2012-07-14 13:05:01 · 461 阅读 · 0 评论 -
Change Log of Joomsport: 改變[VIEW]賽事編排的mon參數(Synchronized with server)
1.修改default.XML文件,增加: 請選擇月份 1月 2月 3月 4月 5月 6月 7月 9月 10月 11月 12月 刪掉:2.將文件 /components/com_joomsport/views/arrangement/view.html.php做如下修改:將:$原创 2011-12-11 17:13:18 · 479 阅读 · 0 评论 -
給視圖的某個佈局的XML描述文件中,增加自定義參數
As we discussed previously, in Joomla!, a component can have several views, and one certain view can have multiple layouts. Each layout has a php file, with an XML description file which has exactly原创 2011-12-11 12:23:05 · 2126 阅读 · 0 评论 -
Cosmos的新功能
第一步:data design首先,需要修改jos_bl_arrangement视图。所以备份这个视图的SQL,然后修改,在前面加上查询id:select `m`.`id` AS `id`,`m`.`m_id` AS `mday_id`,month(`m`.`m_date`) AS `mon`,...然后,重新执行这个SQL创建视图。去到文件:/comp原创 2012-08-08 21:22:31 · 691 阅读 · 0 评论 -
Add One Bool Field to Player Extra Field
這次的問題之所以有點麻煩,是因為extra field是一個在預料不到系統會做什麽擴展的情況下預留的擴展能力,而它必然有局限性。局限性的體現就是,jos_bl_extra_values表只能將這個值存放為字符類型數據。實際上,在處理這部份問題時,我採用的做法是將三個表聯合:jos_bl_players,jos_bl_extra_filds與jos_bl_extra_values。在jo原创 2012-07-21 13:30:21 · 559 阅读 · 0 评论 -
在Joomla!的组件里创建web service - 03: Joomla!自身的Component设计
我想我还是回到Joomla!原本的组件的MVC设计中。以JoomSport为例,它的模块入口为:/components/com_joomsport/joomsport.php。打开它来看看它都做了哪些事:<?php// no direct accessdefined('_JEXEC') or die('Restricted access');// Require spe原创 2012-08-04 12:04:45 · 598 阅读 · 0 评论 -
JSON in PHP
Refs:PHP: json_encode - ManualPHP 讓 json_encode() 指定回傳格式如何正确运用PHP json_encode函数进行中文转换PHP json_encode() 函数介绍原创 2012-08-03 21:54:33 · 322 阅读 · 0 评论 -
在Joomla!的组件里创建web service - opening
其实web service的定义不是那么明确,基本上在一个RPC操作过程中在服务器端扮演提供者的东西都可列入其中。而在我当前的语境里,我所指的是一个输出JSON格式数据的功能,这个功能会在一个组件之中:JoomSport。问题就是,正常情况下,我们在一个组件中创建一个controller,Joomla会根据index.php页面请求的task参数导向这个controller;接下来我们原创 2012-08-02 11:24:22 · 623 阅读 · 0 评论 -
在Joomla!的组件里创建web service - 01: JElement 回顾
因为关于这个话题,之前说过很多,为了避免重复讲同样的东西,我希望这次可以全面一点,那么我就需要再多做一些实验。原创 2012-08-02 22:00:17 · 428 阅读 · 0 评论 -
在Joomla!的组件里创建web service - 02: JDump
作为一个plugin级别的插件,JDump同时有前台和后台的代码在工作。原创 2012-08-02 22:02:00 · 422 阅读 · 0 评论 -
Change Log of Joomsport: [VIEW]晉級圖-淘汰盃:增加字段number_label1,number_label2到match表(synchronized with ser)
這兩個字段分別用來紀律一場比賽中主場與客場的編號:class JTableMatch extends JTable{ var $id = null; var $m_id = null; var $team1_id = null; var $team2_id = null; var $score1原创 2011-12-10 11:59:19 · 561 阅读 · 1 评论 -
根據賽事類型,輸出不同的match編輯介面
/administrator/components/com_joomsport/admin.joomsport.phpadd lines to function ‘BL_MatchEdit’ // added by Vincent 10th Dec 2011 $query = "SELECT t.t_type FROM #__bl_tournament AS t, #原创 2011-12-11 19:47:22 · 341 阅读 · 0 评论 -
Change Log for Joomsport: [VIEW] 成績龍虎榜(Ranking List) SQL Programming
For each Group, perform:{for each team belongs to this group, perform:{QUERY1: get the accumulated 'Played-Matches', 'Goals', 'Misses' and 'Diff'SELECT(SELECT COUNT(id) FROM jos_bl_m原创 2011-11-05 11:03:02 · 936 阅读 · 3 评论 -
Change Log for Joomsport: Get Extra Field back for Player & Team
The Reasons:actually it is for the extra unregulated field:playerteamThe relations in Database:we can make use of the two tables: 'extra_filds', and 'extr原创 2011-11-11 21:39:16 · 981 阅读 · 0 评论 -
PHP下,截取中文字符串
One Chinese char inUFT-8 encoding holds 3 bytes, and let's suppose that your string is encoded by 'UTF-8', and you've already set your page's encoding method is 'UTF-8', then the following lines w原创 2011-11-23 11:17:09 · 424 阅读 · 0 评论 -
Joomla! (DAY 8) - Joomsport (DAY 6):
Now exam the controller for backend and the procedures of handling a request.In admin.joomsport.php:function BL_TourList($option){ //$lim = JRequest::getVar('limit', null, '', 'int');原创 2011-10-12 21:48:32 · 609 阅读 · 0 评论 -
在Jooml1!1.5 下,根據用戶角色輸出不同菜單
It is a pretty simple task in fact, since the 'usertype' variable is a public member, we can reference it directly: $user =& JFactory::getUser(); if("Super Administrator" == $user->usertype)原创 2011-11-18 22:12:44 · 832 阅读 · 0 评论 -
Joomla! (DAY 9) - Joomsport (DAY 7): Create a Real View 'Home VS Away'
Step 1: Output the basic table structureWe will design a view-layout shows this kind of table:The file structure:metadata.xml: view.html.php原创 2011-10-16 21:02:15 · 761 阅读 · 0 评论 -
Change Log of Joomsport: Overwrite the CSS
Add the lines to file '/templates/gk_sporter/css/template.css'/*added by Vincent 17 Nov 2011*/.vincent_align_txt_center {text-align:center;}.vincent_red_font {color:red;}.vincent_full_width {原创 2011-11-18 18:09:17 · 560 阅读 · 0 评论 -
CSS Overwrite in Joomla!1.5::Sporter::Joomsport
So, describe the problem firstly:this piece is the HTML output of [VIEW]HomeVsAway: 主客對賽表 (丁組) 作客\主場(1)Vancity FC(2)研華(3原创 2011-11-17 21:05:29 · 926 阅读 · 0 评论 -
Change Log of Joomsport: Remove Undesired HTML(Synchronized with Server)
Season:/administrator/components/com_joomsport/admin.joomsport.html.phpfunction 'bl_editSeason'remove: ::"> s_win_away)?>" /> ::"> s_原创 2011-11-14 22:11:12 · 678 阅读 · 0 评论 -
Change Log of Joomsport: Add two fields to season table
Target:There are two values: for one certain season, the discipline point for team and player.Database Change:run the SQL in phpMyAdmin:ALTER TABLE jos_bl_seasons ADD s_t原创 2011-11-12 12:12:25 · 613 阅读 · 0 评论 -
[VIEW]成績龍虎榜(Ranking List),排序算法 with PHP
賽規:聯賽兩個循環後積分最高之球隊為總冠軍,如有同分,則先以雙方對賽成績計算勝負(即兩勝對手或一勝一和);但雙方如各勝一場或兩場都賽和而未能分出高下,則以得失球差計算,多者為冠軍;如得失球差相同,則以入球較多者為冠軍;如入球數字亦相同,則須安排一場附加賽決定名次。依照如上賽規進行排序的話,將無法使用PHP的array_multisort函原创 2011-11-13 16:23:59 · 1152 阅读 · 0 评论 -
Change Log of Joomsport: Error in Joomsport (Synchronized with Server)
in: /administrator/components/com_joomsport/admin.joomsport.html.phpfunction 'bl_editSeason' definition:changefunction submitbutton(pressbutton) { var form = document.adminForm;原创 2011-12-03 20:58:35 · 452 阅读 · 1 评论 -
Change Log of Joomsport: [VIEW]晉級圖-主席盃、碟及盾:给match表增加三个字段:grp_id,ordering,level(synchronized with ser
Target:For extended functionalities of [赛事晋级图]. Match table should have at least more 3 fields: grp_id, ordering and level.grp_id: the match belongs to witch Group: A组, B组...ordering: th原创 2011-12-06 22:40:24 · 1104 阅读 · 0 评论 -
Change Log of Joomsport: [VIEW]晉級圖-淘汰盃 增加comment1, comment2到match表(synchronized with server)
這兩個字段用來存儲淘汰盃第一階段比賽信息中,兩球隊的備註信息:在phpMyAdmin中增加此兩個字段的SQL:class JTableMatch extends JTable{ var $id = null; var $m_id = null; var $team1_id = null; var $t原创 2011-12-10 23:49:32 · 661 阅读 · 0 评论 -
Change Log of Joomsport:[VIEW]晉級圖: 增加ranking_alias字段到team,重新使用match的match_descr字段(synchronized)
這個變量是用來記錄每一個球隊在聯賽盃出線后,進入到以下階段的賽事時將會被提示的成績排名,比如:甲組第一名。數據庫的修改:增加成員變量'$ranking_alias'到'JTableTeams'類:/administrator/components/com_joomsport/admin.joomsport.class.ph原创 2011-12-10 00:17:59 · 488 阅读 · 0 评论 -
[VIEW]赛事晋级图-[LAYOUT]主席盃
Firstly, we...And next up is to list the match data for each group within this season:Get the current season:SELECT MAX(s_id) FROM jos_bl_seasons WHERE t_id = 1 AND published原创 2011-12-07 22:13:58 · 845 阅读 · 1 评论 -
Change Log of Joomsport: Adding 't_type' field for Tournament
TargetThe system should be able to discriminate three different type of competition systems:Round-robin;Knock-out;ChampionDatabase ChangeTable: jos_bl_tournament原创 2011-10-23 09:04:36 · 595 阅读 · 0 评论