DIR : /home/kozerus/public_html/go/dgs0/scripts/updates/ChangeLog_1_0_13
/home/kozerus/public_html/go/dgs0/scripts/updates
==================================================================
Release [2007-12-19] - DGS 1.0.13 - CVS-tag [DGS-stable-200712]
# History:
2007-10-06: first big update of DGS 1.0.13
2007-11-07: bug fix update
2007-12-19: bug fix update + release
2008-01-10: bug fix update (see above DGS 1.0.13.b)
2007-12-27 juga
* translationdata.mysql, INSTALL:
- removed translation-data from distribution
- downloads from snapshot-page
- info about GD & FreeType and refs to scripts-READMEs
2007-12-19 rodival
* statratingspng.php:
- fixing a new MySQL5 bug: renaming the temporary field "rank" to "p_rank"
* statisticspng.php:
- added missing mysql_free_result()
* forum/forum_functions.php (draw_post):
- forum-search: use new 3-line-header, postpone 3-<TR>-header
2007-12-19 juga
* all files containing license preamble:
- replaced preamble for license-change: GPLv2 -> Affero GPLv3
* scripts/change_files.pl:
- helping script to replace license-preamble
* NEWS:
- document changes since last bug-update at 26-Oct-2007
* show_games.php:
- extend color-filter for my running games: filter on my color / my move
2007-12-18 juga
* COPYING, licence.php, docs.php, site_map.php, NEWS:
- replaced GPLv2 with AGPL (Affero GPLv3 - 19-Nov-2007)
- changed some licence[BE] -> license[AE] like in AGPL
* edit_contact.php, list_contacts.php, include/contacts.php (load_globals),
include/filter.php (FilterRelativeDate):
- added TODOs for init of global vars
* forum/forum_functions.php (draw_post):
- forum-search: use former 2-line-header, postpone 3-line-header
2007-12-02 juga
* waiting_room.php:
- fix typo of 'Fischer'-time
* forum/forum_functions.php (make_link_array, forum_start_table),
forum/search.php, NEWS:
- added max-rows for forum-search (don't use TableMaxRows from player)
- only show max number of rows (instead of +1)
* include/std_functions.php:
- added max-rows for forum-search: MAXROWS_PER_PAGE_FORUM,
- removed some globals
2007-11-25 juga
* include/filter.php (FilterMysqlMatch.extract_match_terms):
- fix for escaping of regex-delimiter '/'
* include/filter.php (FilterRelativeDate.build_query):
- implement suggested alternative to build query (WEEK=7*DAY)
2007-11-20 rodival
* include/filter.php (FilterRelativeDate),
include/contacts.php (load_globals),
edit_contact.php, list_contacts.php:
- delayed the load of the globals containing translations
* include/filter.php (Filter.build_generic_selectbox_elem),
include/form_functions.php (print_insert_select_box),
game.php (draw_moves, draw_add_time):
- fixed safe HTML inside <OPTION></OPTION>
* include/filter.php (FilterSelection.parse_value, SearchFilter.add_filter):
- fixed the sql query in case of empty clause (parse_value)
- changed an eval() to a more conventional call (add_filter)
* include/std_functions.php (start_html):
- fixed safe HTML inside <TITLE></TITLE>
2007-11-18 rodival
* forum/forum_functions.php (draw_post):
- added an auto-reference link to posts (to allow its address copy&paste)
* skins/dragon/screen.css,
forum/read.php (revision_history),
forum/forum_functions.php (draw_post):
- adjusted some links problems
- added some missing (ugly) globals... waiting better!
2007-11-17 juga
* include/filter.php (FilterMysqlMatch.extract_match_terms),
include/tokenizer.php (Token, StringTokenizer.parse_quote_quote):
- Filter: special handling for "quoted-text" in mysql-match search-pattern
- Tokenizer: mark quoted token-text using added Token.flags
2007-11-16 rodival
* include/std_functions.php (delete_all_observers):
- exclude guest from message notifications for observers
* include/std_functions.php (parse_html_safe),
include/filter_functions.php (sql_extract_terms):
- set the $parse_mark_regex delimiter to a more natural '/'
* include/std_functions.php (parse_tags_safe):
- fixed a bad marking of the search-term of the </code> tag
- ajusted some comments
* include/message_functions.php (echo_folders),
search_messages.php:
- introduced the FOLDER_COLS_MODULO constant
* include/message_functions.php (message_list_table):
- changed the links of the Correspondent and Subject columns to make
them more intuitive and like thoses of the search-message table
* skins/dragon/screen.css, skins/dragon/print.css,
forum/forum_functions.php (draw_post):
- fixed the layout of the approved/hidden status cell
- moved the "found in forum" part above the subject line in the search page
2007-11-16 juga
* include/filter_functions.php (sql_extract_terms):
- fixes: if handling of trailing (un-)escaped '%' and avoid dublette,
add regex-delimiter to escape and escape '\' correctly
2007-11-16 rodival
* include/filter_functions.php (sql_extract_terms):
- don't remove a trailing "\%" from the sql_term
* include/filter_parser.php (parse):
- typo ($v1 => $v2)
2007-11-16 juga
* forum/forum_functions.php (draw_post):
- allow '0' as regex-term (replace empty-check)
2007-11-15 rodival
* include/faq_functions.php (faq_item_html),
include/message_functions.php (message_info_table, message_list_table),
include/filter.php (get_terms -> get_rx_terms),
include/filter_functions.php (sql_extract_terms),
code_examples/filter_example2.php,
forum/read.php (revision_history), forum/search.php,
forum/forum_functions.php (make_link_array, draw_post),
translate.php, search_messages.php, message.php, list_messages.php,
list_contacts.php, admin_faq.php:
- searching some missing urlencode() around the search terms like in
the Mac Safari/Camino problem
- to trace the previous inconsistancy and clearly separate what
is "reg_exp" and "sql_like" terms, a bunch of vars renaming.
- moved the $rx_term variable (old name: $markterms) used in
revision_history() from the global array to the arguments list
(like for the draw_post() function)
- changed the URL-var name from "terms" to "xterm" (reg_exp)
in message.php, list_messages.php, include/message_functions.php
- changed the URL-var name from "markterms" to "xterm" (reg_exp)
in forum/read.php, forum/forum_functions.php
- changed the URL-var name from "term" to "qterm" (sql_like)
in admin_faq.php
- renamed the get_terms() function to get_rx_terms() to avoid ambiguities
in include/filter.php, code_examples/filter_example2.php, forum/search.php,
search_messages.php, list_contacts.php
2007-11-14 juga
* forum/forum_functions.php:
- optimize-fix: remove search-terms (not needed, are extracted from filter)
* forum/search.php:
- fix: prevent SQL-injection on ordering (map order values)
- added ascending ordering for creation and modification date
2007-11-12 rodival
* scripts/test.php:
- a second test to debug the Mac Safari/Camino problem of url-decoding
2007-11-10 rodival
* forum/search.php:
- one protection from an incoming injection to a MySQL query...
* scripts/test.php:
- one test to debug the Mac Safari/Camino problem of url-decoding
2007-11-09 rodival
* translate.php:
- better handling of the rows of prev/next with the empty 3rd column.
* skins/dragon/print.css:
- typo
2007-11-08 rodival
* translate.php:
- re-added the fake empty 3rd column.
It may be useful in case of a very long unbreakable word in some
browsers, while not disturbing other browsers.
* skins/dragon/screen.css,
statistics.php, snapshot.php, news.php:
- some W3C compliance fixes.
2007-11-07 rodival
* translate.php:
- adjusted the text of the quick-info box, mainly about the use of
our pseudo-html tags.
- removed the useless 3rd column.
2007-11-07 juga
* robots.txt:
- disallow all pages to web-crawlers for now
2007-11-04 juga
* include/table_columns.php:
- bugfix: use filter-prefix (not table-prefix) for filter-toggles
2007-10-31 rodival
* statratingspng.php:
- adjusted the relative scales of graphs.
2007-10-29 rodival
* translate.php:
- adjusted the boxes size to the max of original and translated strings.
2007-10-26 ejlo
* docs.php, snapshot.php:
- added snapshot-page
2007-10-26 juga
* people.php:
- switched role of FAQ-maintainer/editor of Ingmar <-> jug
* INSTALL:
- adjust CVS-hostname on SourceForge
2007-10-25 rodival
* send_message.php:
- don't reject the messages of an invitation discussion when the
contact flags are "messages reject" and "invite accept"
- also allow to continue an already started invitation
* skins\dragon\print.css,
opponents.php, send_message.php:
- comments adds and garbages
* init.mysql:
- adjustments to release
2007-10-25 juga
* scripts/player_consistency.php (cnt_diff):
- correct echo for DEBUG-mode
2007-10-24 rodival
* scripts/player_consistency.php,
clock_tick.php:
- minor fixes and comment adds
* skins/dragon/screen.css,
include/make_translationfiles.php,
people.php:
- fix a bad translation of languages (with uppercase letters) in the people
page
- adjusted CSS for the people page
2007-10-20 juga
* scripts/player_consistency.php (cnt_diff):
- minimize duration of read-locks on tables
- added SQL_BUFFER_RESULT for selects (default),
added arg 'buffer=no' to deactivate it
- GROUP BY already sorts result, do additional sorting in PHP
- added times needed
- replaced SQL-operator '!=' on Games.Rated
2007-10-18 juga
* userinfo.php, site_map.php, NEWS:
- added bottom-link to show my opponents
2007-10-16 juga
* clock_tick.php:
- fix slow-query by returning to former query (for running games)
using index-optimization
2007-10-16 rodival
* skins/dragon/screen.css, skins/dragon/print.css:
- updated the CSS printer part
* include/message_functions.php:
- CSSed the MessageBox rows
* include/std_functions.php:
- translation of the vault message
* scripts/data_report.php:
- disable the unbuffered feature
* scripts/message_consistency.php,
include/message_functions.php,
message.php:
- On 2007-10-15, we have found, in the DGS database,
30 records of MessageCorrespondents with .mid == 0
all between "2004-06-03 09:25:17" and "2006-08-10 20:40:31".
While this should not have occured, those "lost" records can disturb
some queries where, for instance, .mid is compared to .ReplyTo which
may be 0 (meaning "no reply").
We have strengthened those queries but also manually changed the faulty
.mid from 0 to -9999 (directly in the database) to move them apart.
2007-10-15 juga
* NEWS:
- added bugfix (about SGF-download)
2007-10-13 juga
* NEWS:
- added <home_ page>... opening new window
* skins/dragon/screen.css, translate.php:
- JUG's dream of page-layout for translate-page
- fix extracting of highlight-regex term (leading & trailing %, 0)
2007-10-13 rodival
* skins/dragon/screen.css, translate.php:
- fix the embossed tables display for the browsers not understanding
the 'outset' and/or 'inset' border style of CSS.
* include/board.php:
- closing the board display problems.
2007-10-12 rodival
* skins/dragon/screen.css,
include/board.php:
- An other try to analyze the board display problems.
2007-10-11 rodival
* include/filter.php:
- minor HTML args enhancement
* translate.php:
- just adjusted the profile-encoding for the translators' ADMINS only
* include/std_functions.php:
- enabling the <home_ ...> pseudo-tags
- enhanced the $html_safe_preg by the way
* skins/dragon/screen.css,
include/board.php:
- An other try to analyze the board display problems.
2007-10-10 rodival
* sgf.php:
- Changed the header Content-Disposition: inline; to attachment;
2007-10-09 rodival
* skins/dragon/screen.css,
translate.php:
- A midway page re-format to simplify the translators work
* skins/dragon/screen.css,
include/board.php:
- A try to analyze the [Go Ban Joe (Banjo)] PocketPC IE problem
around the board display.
2007-10-09 juga
* waiting_room.php:
- preserve filter-values for links:
Info-button, bottom-link to add new game
* show_games.php:
- bugfix: show values Rated & Last moved for observed games
2007-10-08 rodival
* scripts/generate_translation_texts.php,
status.php, opponents.php, waiting_room.php, message_functions.php:
- Adjusting and adding strings to translation
2007-10-08 juga
* NEWS:
- adjusted text about <image>-tag (release 1.0.13)
* quick_play.php:
- fix: mismatch of an empty argument
2007-10-07 juga
* include/filter.php (FilterRating.parse_value):
- fix handling of range-search using '-' with upper limit
* opponents.php:
- show form-submits for opponents-info game-stats-view
2007-10-07 rodival
* translate.php, skins/dragon/screen.css:
- better display of found term vs raw code
* include/std_functions.php, scripts/mailtest.php,
admin.php, admin_admins.php, people.php:
- Changed the ADMIN_ADMINS constant name to a more obvious one (ADMIN_SUPERADMIN)
* include/std_functions.php:
- re-enabled the <TT> pseudo tag
* forum/index.php:
- minor CSS fix
2007-10-06 rodival
* skins/dragon/screen.css,
game.php:
- adjustment of the "Go back" button placement in the game page.
* include/message_functions.php:
- description for 'Proper handicap' completion
* scripts/translation_consistency.php:
- adjusting the detection of the "FAQ entries without 'FAQ' group"
* scripts/game_consistency.php:
- removed an extract($row)
- adjusted the detections according to the args limitations
- added some warning messages
* scripts/roadmap_1_0_12_to_1_0_13.txt:
- minor adjustments correlated to the previous commits
2007-10-05 juga
* NEWS:
- changed final release date
* include/filter.php (FilterRating),
include/filter_parser.php (TextParser.handle_reverse_range):
- fix: FilterRating, correct range-search of percentaged rating
- fix: remove non-ASCII7-char
* include/message_functions.php:
- short description for 'Proper handicap'
2007-09-11 juga
* INSTALL:
- removed board-link in images-dir
* NEWS:
- game-page title, bio textinput width, no pie-chart in rating, <image>-tag
2007-09-10 rodival
* ratingpng.php:
- hidden the win/lost pie
* skins/dragon/screen.css,
include/std_functions.php:
- fixed the bad left-alignment of the "not logged" or "is down" pages
- adjusted some comments of the fever vault
* game.php:
- added the game ID and move number to the page title
* scripts/other_changes_1_0_12_to_1_0_13.txt,
include/std_functions.php:
- hard-coded the re-direction of <image board/*> to /17/*
-----------
Caution: maybe not needed, this is a rollback of a previous modification
remove the soft-link on server: go to the dragon root-directory (e.g. 'htdocs' for the devel server)
cd images
rm board
-----------
2007-09-09 juga
* init.mysql, scripts/database_changes_1_0_12_to_1_0_13.mysql:
- split combined indexes (Forum_ID and Pos) into separate indexes
to speed up forum-search and forum-views/sort,
particularly on PosIndex and Lastchanged
-----------
ALTER TABLE `Posts`
DROP INDEX `Pos` ;
ALTER TABLE `Posts`
ADD INDEX `Thread_ID` (`Thread_ID`) ;
ALTER TABLE `Posts`
ADD INDEX `PosIndex` (`PosIndex`) ;
ALTER TABLE `Posts`
DROP INDEX `Forum_ID` ; -- on some servers this is named 'List'
ALTER TABLE `Posts`
ADD INDEX `Forum_ID` (`Forum_ID`) ;
ALTER TABLE `Posts`
ADD INDEX `Lastchanged` (`Lastchanged`) ;
-----------
* include/filter.php (FilterRating):
- bugfix FilterRating: fix rank-conversion for rating with percentage
* include/filter.php (all Filters), code_examples/filter_example2.php,
specs/filters.txt:
- added syntax-help-id in syntax-hover-text-description (for FAQ-reference),
added with #filterhelp-namespace to allow adjustment and translations
- added FC_SYNTAX_HELP-config to overwrite syntax-help-id
2007-09-07 juga
* scripts/database_changes_1_0_12_to_1_0_13.mysql:
- consolidate changes on Contacts-table
2007-08-29 rodival
* scripts/roadmap_1_0_12_to_1_0_13.txt:
- "how to" for next update
2007-08-23 ejlo
* scripts/database_changes_1_0_12_to_1_0_13.mysql,
scripts/other_changes_1_0_12_to_1_0_13.txt:
- initial commit of two files containing a collection of changes
for updating from v1.0.12 to v1.0.13.
2007-08-23 juga
* search_messages.php:
- select folder form-element: use 8 columns to display folders
2007-08-21 rodival
* include/std_functions.php,
include/make_translationfiles.php (add_text_to_translate),
admin_faq.php, admin_do_translators.php, list_contacts.php:
- removed the "LOWER(...) LIKE strtolower($pattern)" tricks.
- changed the TranslationTexts.Text field to latin1 as it should contain
only english phrases
- changed (reversed) the Contacts.Notes field to latin1
-----------
ALTER TABLE `TranslationTexts`
CHANGE `Text` `Text` text NOT NULL ;
ALTER TABLE `Contacts`
CHANGE `Notes` `Notes` varchar(255) NOT NULL DEFAULT '' ;
-----------
- added related latin1 checks in admin_faq.php and make_translationfiles.php
- removed the translated strings from admin_do_translators.php
2007-08-21 juga
* INSTALL:
- hint about needing /images/board link
2007-08-19 rodival
* include/std_functions.php:
- added the <image> pseudo tag
- must be completed by a "Linux soft-link" (or an "Apache alias")
from /images/board to /17
-----------
Caution: no more needed (see rollback above)
add soft-link on server: go to the dragon root-directory (e.g. 'htdocs' for the devel server)
cd images
ln -s ../17 board
-----------
2007-08-19 juga
* NEWS:
- added: bio-fix, new-window-links, language=N profile
* show_games.php:
- spare translators-work (reverted change): observed games are always mine
2007-08-18 rodival
* skins/dragon/screen.css,
include/form_functions.php, include/message_functions.php,
forum/search.php, forum/forum_functions.php,
waiting_room.php, game.php, forgot.php, index.php:
- CSS and layout adjustments
* include/make_translationfiles.php,
include/translation_functions.php,
edit_profile.php, change_profile.php:
- fixed glued translation files when they must be emptied
- highlighted the NativeText for the ?language=N option
- allowed to set language=N in profile for translators
* skins/dragon/screen.css,
include/message_functions.php, include/form_functions.php (sptext)
edit_profile.php, waiting_room.php:
- CSSed the radio/check boxes of forms. Added sptext() to help. Temporary
solution
* userinfo.php, edit_bio.php, change_bio.php:
- allowed to input a foreign category with the same spelling as one of
the default english categories without seeing it translated
- distinguished them in the database with a leading '=':
-----------
UPDATE Bio SET Category=CONCAT('=',Category)
WHERE !(Category IN('Country','City','State','Club','Homepage','Email','ICQ-number',
'Game preferences','Hobbies','Occupation','Native Language','Language Competence')
OR LEFT(Category,1)='=') ;
-----------
* skins/dragon/screen.css,
include/form_functions.php,
forum/forum_functions.php,
admin_faq.php, edit_contact.php, edit_profile.php, message.php, waiting_room.php:
- CSSed some other Form parts.
2007-08-17 juga
* NEWS:
- added: on-vacation showing hours too, bottom-links left-alignment,
'&language=browsercode'
- removed goodies
- cleanup (FAQ-refs, double entries, better text)
* docs.php, site_map.php:
- "hide" unwanted translations for Goodies
2007-08-16 rodival
* skins/dragon/screen.css,
include/message_functions.php (echo_folders, echo_folder_box),
include/filter.php (get_input_element),
include/form_functions.php (create_form_string),
search_messages.php:
- fixed the left alignement of the CheckboxArray of folders
- changed the signature:
echo_folder_box($folders, $folder_nr, $bgcolor=null, $attbs='', $layout_fmt='')
where $layout_fmt is a sprintf format string to replace the previous
$prefix and $suffix arguments.
* include/time_functions.php (echo_onvacation)
status.php, userinfo.php:
- introduced echo_onvacation() to have the vacations displayed on a hour basis
* skins/dragon/screen.css,
include/table_columns.php (make_tablehead, make_table_filter):
- a try to fix the alignement of the headers and remove tools for JUG browser
2007-08-15 juga
* NEWS:
- added info about bugfix: move numbering hover option
* docs.php, site_map.php:
- don't show goodies (Greasemonkey-scripts) as they are no DGS-features
- reverted minor translation changes
* introduction.php:
- added todo-note about wrong sentence
* site_map.php:
- completed items for other user info
2007-08-15 rodival
* include/translation_functions.php:
- fixed the "&language=de" shortcut
2007-08-14 rodival
* userinfo.php:
- fixed the "<color red>" display problem in Open and Rank infos
* skins/dragon/screen.css:
- centered the folders tabs table
- left aligned and narrowed the table of the bottom links
* include/message_functions.php (echo_folder_box),
search_messages.php:
- reduced the space betwwen the checkbox and the folder name
* userinfo.php, waiting_room.php, edit_bio.php, opponents.php,
list_contacts.php, edit_contact.php, faq.php, people.php,
admin_admins.php,
scripts/update_translation_pages.php, scripts/translation_consistency.php,
scripts/start_frozen_clocks.php, scripts/recalculate_ratings2.php,
scripts/player_consistency.php, scripts/message_consistency.php,
scripts/game_consistency.php, scripts/convert_from_old_forum.php,
scripts/browser_stats.php,
forum/index.php, forum/search.php, forum/list.php, forum/read.php:
- added some mysql_free_result()
Note: with my new local server, omitting them induce some warning messages
to be added after the end our HTML code. Because of thoses and our
ob_start('ob_gzhandler'), this make the IE5 browser unable to even display
the page, reporting a "page not found" error message (in the best case!)
* docs.php:
- removed the "goodies" link: this is NOT a DGS feature.
* join_waitingroom_game.php, waiting_room.php:
- adjusted the join and delete forms
- cleaned some links
- fixed glued games (not deleted when count reach 0)
2007-08-13 juga
* list_contacts.php:
- avoid to show 'filter' term to users
* forum/search.php:
- removed empty row between search elements and order element
* include/form_functions.php:
- removed old build_areas() algorithm
* site_map.php:
- cleanup, adding new and missing pages:
contacts, opponents, add time, show observers, news, people, goodies
- order roughly oriented at main-menu
* docs.php:
- more descriptions for items, more logical order
- added Goodies, DGSWishlist on SL
* show_games.php:
- allow B/W to translate
- hide score filter (saving col-space)
- use absolute RelativeDate-Filter on end-date
2007-08-13 rodival
* include/message_functions.php (message_list_query, message_list_table),
include/std_functions.php (send_message),
scripts/message_consistency.php,
rss/status.php, wap/status.php,
quick_status.php, join_waitingroom_game.php, confirm.php, message.php,
halfhourly_cron.php, clock_tick.php:
- adjusted the use of the new MessageCorrespondents enum type 'S'
- added the recovery of 'S' type from old messages in message_consistency.php
- added the recovery of old 'result' messages in message_consistency.php
* list_messages.php:
- fixed a move-message bug
* scripts/update_translation_pages.php, scripts/translation_consistency.php,
scripts/start_frozen_clocks.php, scripts/start_frozen_clocks.php,
scripts/player_consistency.php, scripts/generate_translation_texts.php,
scripts/convert_posindex.php:
- better url args handling
* skins/dragon/screen.css,
include/std_functions.php (attb_build),
include/form_functions.php (create_form_string),
opponents.php, search.php, search_messages.php,
code_examples/filter_example2.php:
- attb_build: remove useless colspan
- removed (partially) the Align property of the forms. Changed it to 'Attbs'
to allow to add 'class=???' arguments... a step to a full CSS management.
- changed FEA_ALIGN to FEA_ATTBS
- aligned the descriptions of search_message
* include/make_translationfiles.php,
generate_translation_texts.php,
forum/forum_functions.php, forum/post.php:
- re-added previously badly suppressed $TranslateGroups[]
- added small debug infos
2007-08-12 rodival
* init.mysql,
scripts/data_export.php:
- adjusted init.mysql to the current state of the devel server database
2007-08-12 juga
* include/filter.php, include/filter_parser.php, include/tokenizer.php,
include/message_functions.php (message_list_table),
list_contacts.php, opponents.php, search_messages.php, show_games.php,
status.php, users.php, waiting_room.php:
- use different table headers and filter texts to allow saving space with
shorter translations and provide a clear context for text
- provide shorter filter input-elements to save column width space
* opponents.php:
- no filter on Rank-Info and Open-for-matches (no efficient search)
* include/filter.php (FilterRelativeDate.get_input_elements):
- remove in RelativeDate-filter layout
* forum/search.php, list_contacts.php, opponents.php,
search_messages.php, show_games.php, users.php, waiting_room.php:
- added accesskey 'x' for search, 'e' for reset search
- removed second pair of filter-submits (if external-form)
* include/filter.php (set_accesskeys, get_submit_elements):
- added config for accesskeys for filter-submit elements search & reset
- replaced technical 'filter' term by user-friendly 'search' term
* include/table_columns.php (make_table, make_add_column_form):
- searching wants focus on table-data, not add-column-form
- replaced technical 'filter' term by user-friendly 'search' term
on filter-submit elements
* search_messages.php:
- removed filter on Message-type
- added checkbox to show pending invitations
- added Server as direction (Sender = 'S')
-----------
ALTER TABLE `MessageCorrespondents`
CHANGE `Sender` `Sender` enum('M','N','Y','S') NOT NULL DEFAULT 'Y' ;
ALTER TABLE `MessageCorrespondents` -- +2 MB (for filter/sort)
ADD INDEX `Sender` (`Sender`) ;
-----------
* all files
except the following
init.mysql, translationdata.mysql, goodies/*.js, include/config.php,
scripts/README.developers, scripts/README.translations,
scripts/doxygenConfig:
- changed copyright notice and added where missing (-2007)
* NEWS, news.php, skins/dragon/screen.css:
- make an emphasized release title with anchor
for reference in SL's DGSWishlist
* NEWS:
- added new features and changes of last release [2006-08-07]
2007-08-11 juga
* NEWS, news.php:
- added new features and changes since last release [2006-08-07]
- resolve DGS-tags in NEWS-page
2007-08-09 rodival
* skins/dragon/screen.css,
include/std_functions.php (section, centered_container),
docs.php, admin.php, licence.php:
- adjusted the problem of centered containers
2007-08-08 rodival
* scripts/FAQtransl_consistency.php, scripts/translation_consistency.php:
- renamed scripts/FAQtransl_consistency.php
to scripts/translation_consistency.php
* userinfo.php, opponents.php:
- Rank and Open html_safe adds
* skins/dragon/screen.css,
include/std_functions.php (section),
status.php:
- CSS ajustments of PendingApproval section
2007-08-07 rodival
* include/faq_functions.php,
forum/admin.php,
admin_faq.php, error.php:
- reviewed and CSSed forum/admin.php
- normalized forum/admin.php and admin_faq.php to have an easier comparison
- moved the TD_button() function to faq_functions.php to share it between
admin_faq.php and forum/admin.php
- removed the unused 'admin_already_translated' message
* include/filter_functions.php,
include/table_columns.php (make_table_filter),
include/form_functions.php (print_insert_filtererror),
forum/forum_functions.php,
game.php (draw_game_info, draw_board_info),
admin.php, search.php, post.php, index.php, login.php:
- CSS and W3C fixes
- minor translation related fixes
* userinfo.php:
- removed the 'forced column' part of the links to show_games.php
2007-08-06 rodival
* include/std_functions.php (section, start_html, end_page,
add_link_page_link, parse_tags_safe):
- introduced the section() function which allow to split the page
in distinct sections
- introduced the $ThePage['class'] to temporary solve some CSS problems
- adjusted add_link_page_link() to fully handle the structure
- fix potentially corrupted marks of TT tag in parse_tags_safe()... to be reviewed
* skins/dragon/screen.css,
docs.php, admin.php, links.php, people.php, site_map.php,
introduction.php, todo.php, news.php, licence.php, install.php:
- full CSS of the Docs pages
* skins/dragon/screen.css,
include/std_functions.php (section, parse_tags_safe),
status.php, faq.php:
- added sections in the status page
- removed linefeeds causing insert of badly placed <br>
- checked and fixed the W3C compliance of the CSS sheet
* include/table_infos.php, include/table_columns.php,
include/form_functions.php,
links.php, edit_folders.php, list_contacts.php:
- minor fixes around W3C compliance
2007-08-05 rodival
* skins/dragon/screen.css,
include/table_columns.php (make_table_filter):
- adjusted some CSS of filters
* include/std_functions.php:
- removed the of the TD_EMPTY definition
* userinfo.php, include/table_columns.php (add_or_del_column):
- as a first try to enable the columns when a filter is requested...
but it actually fail to active the filters when the column is added.
* include/game_functions.php, include/time_functions.php (time_remaining),
game.php:
- adjusted the time check in case of byoyomi disabled
* userinfo.php, edit_contact.php, list_contacts.php:
- excluded guest from contacts features (edit and add... but not list)
- jump to list_contacts.php after a Contact had been saved
* include/contacts.php, include/message_functions.php,
send_message.php, join_waitingroom_game.php, waiting_room.php:
- denied the access to a waitingroom game protected by its owner
- rejection of messages or invitations to protected users
- renaming some column and row headers from 'Color' to 'Type' when they
contain datas like 'Double game', 'Proper handicap' or 'Even game'.
* skins/dragon/screen.css,
code_examples/form_example2.php,
opponents.php:
- CSS and layout bug fixes
2007-08-04 juga
* game.php,
include/game_functions.php (allow_add_time_opponent, add_time_opponent):
- add-time: no byoyomi-reset if there is no byoyomi,
don't allow if maintime would exceed 365 days,
allow up to 14 days to add,
corrected some relating texts
* include/message_functions.php:
- added 'AS' in SQL
* include/table_columns.php (make_filter_row):
- removed useless arg 'thead'
* admin_faq.php, include/faq_functions.php (faq_item_html):
- highlight terms for edit-FAQ and returning (except preview)
* include/filter_parser.php (TextParser.parse, TextParser.extract_terms),
include/filter_functions.php (sql_extract_terms):
- moved sql_extract_terms-func from filter_parser -> filter_functions
* edit_contact.php:
- fix: show errormsg for invalid contact-user
- delete-cancel returns to contact-list
- delete is only confirm (don't show edit-elements)
* list_contacts.php:
- use case-insensitive filter-search on now binary Notes-column
- removed alt-attrib in some filter-form-elements: changed FC_MULTIPLE-format
- default sort by name
* include/filter.php (build_generic_input_text_elem, build_input_text_elem,
build_generic_checkbox_elem, FilterCheckboxArray),
code_examples/filter_example2.php, search_messages.php:
- cleanup: removed alt-attrib in some filter-form-elements,
changed FC_MULTIPLE-format
* show_games.php, userinfo.php:
- introduced named filter-columns for Rated/Won fields in show_games.php
- make Rated (14) and Won (11) games-column static
to provide valid links from userinfo
2007-08-04 rodival
* include/contacts.php (update_contact, load_contact),
list_contacts.php, edit_contact.php:
- modified some $uid/$cid checks
- changed the Notes field of the Contacts table (including its name)
-----------
ALTER TABLE `Contacts`
CHANGE `Note` `Notes` varbinary(255) NOT NULL DEFAULT '' ;
-----------
- CSSed the pages
* opponents.php:
- added buttons to have a more visible stat link column
- CSSed the page
- adjusted the appearence of some bottom-of-the-page links
* include/form_functions.php (add_empty_row):
- changed add_empty_row() to respect the colspan of the table
- others modifications are just TAB re-formats
* include/filter.php (build_generic_input_text_elem,
build_generic_checkbox_elem, get_input_element):
- removed the useless "alt=" of the "<input>" tags
removed the "$alt" parameters from build_generic_checkbox_elem()
and of the code calling it
* include/std_classes.php (merge):
- fixed an error() call
* include/table_columns.php:
- adjusted some id cases
* include/std_functions.php (user_reference), error.php:
- added some comments and adjusted the code
* admin_faq.php:
- removed useless empty_row
2007-08-04 juga
* error.php, confirm.php, game.php, opponents.php,
include/contacts.php (Contact, load_contact),
include/filter.php, include/filter_parser.php,
include/form_functions.php, include/std_classes.php,
include/table_columns.php, include/tokenizer.php:
- added error-codes: invalid_user, invalid_opponent, invalid_filter
- fix error()-calls: adjusted errorcode and debug-message
* edit_contact.php, include/contacts.php:
- show user-error (not internal-error) for adding own user,
so no check for equal user- and contact-id in loading-funcs but update
* skins/dragon/screen.css:
- changed some styles for JUG-devel-server
2007-08-03 rodival
* include/form_functions.php (build_areas, create_form_string, get_merged_attbs),
code_examples/form_example2.php:
- proposition for a new build_areas() layout managment
- removed some useless levels of tables nesting
- added the $TRlevel argument to build_areas() (default to previous behaviour)
- introduced the optional 'title' of the areas
- added the get_merged_attbs() function
- fixed some error messages
2007-08-02 rodival
* include/make_translationfiles.php:
- fix to search case-insensitive on mysql-binary translation-texts
* translate.php:
- highlighted the found terms.
* include/std_functions.php (parse_html_safe, parse_tags_safe):
- removed the first newline after div-like pseudo-tags
- fixed a bug in parse_html when $html_code is empty
* include/translation_functions.php (T_, include_translate_group):
- introduced the &language=N argument to disable any translation of the page
- allowed more shortcuts to this argument: &language={browser_code}
* include/table_infos.php (make_tablerow):
- changed the priority of the class option of the rows
- removed row highlight for the info tables
* list_messages.php, edit_bio.php, admin_admins.php:
- CSS adjustments
* list_contacts.php, edit_contact.php:
- disabled for guest
* forum/list.php, forum/forum_functions.php (draw_post):
- fixed the wrong display of 'first new'
2007-08-01 juga
* list_contacts.php:
- bugfix: show only own contacts
* admin_faq.php:
- fix to search case-insensitive on mysql-binary translation-texts
2007-07-31 rodival
* include/game_functions.php (add_time_opponent),
confirm.php, game.php:
- fixed the add_time error when nothing is changed in byoyomi settings
* skins/dragon/screen.css,
admin_faq.php:
- CSS adjusted (for IE, Opera and Avant), info box adjusted
* list_contact.php:
- added or modified images for 16x16 buttons of list_contact.php
-----------
copy /images/send.gif
copy /images/read.gif
copy /images/invite.gif
copy /images/edit.gif
copy /images/trashcan.gif
-----------
2007-07-29 rodival
* skins/dragon/screen.css,
include/table_columns.php (make_table, make_tablerow, make_next_prev_links),
include/form_functions.php (create_form_string),
forum/forum_functions.php (echo_links),
search_messages.php, game.php, opponents.php:
- added the 'ROW' form command
- various CSS adjustments
* translate.php, admin_faq.php:
- CSSed the pages (final?)
* include/std_functions.php (start_page),
list_contacts.php:
- quick fix of some contacts stuff (remove center tags) (more to come!)
* opponents.php, userinfo.php, game.php, confirm.php, show_games.php:
- normalized the $my_id var.
- comments fixed
* userinfo.php:
- CSS adjustment
- ajusted the links on the games list (using filters)
* include/std_functions.php, include/board.php (load_from_db, draw_board),
include/game_functions.php, include/time_functions.php (time_remaining),
game.php (draw_game_info, draw_board_info), confirm.php (do_add_time),
sgf.php:
- checked the add_time stuff
- adjusted time_remaining() to handle the byoyomi settings reset
- changed POSX_ADDTIME from -5 to -50 (somehow enabling a "settings" section
far from the terminating moves)
- added the add_time infos in game.php from board.php via the new function
draw_board_info()
- moved the database updates from do_add_time() to add_time_opponent()
- removed the $gid argument from add_time_opponent()
- normalized most of the error handlers of add_time_opponent() (few stay)
2007-07-29 juga
* waiting_room.php:
- implement Contacts system-flag "Deny game":
don't show games from players that "deny games" to current user
* edit_contact.php, list_contacts.php, include/contacts.php:
- added categorized contact-list for other users,
support for system categories: deny game, etc.
support for user categories: friend, student, etc.
allow free-text notes about contact, save created and lastchanged-date,
show some players-data (name, userid, country, rating, lastaccess)
- added Contacts table
-----------
CREATE TABLE Contacts (
uid int(11) NOT NULL default '0',
cid int(11) NOT NULL default '0',
SystemFlags smallint(5) unsigned NOT NULL default '0',
UserFlags int(10) unsigned NOT NULL default '0',
Created datetime NOT NULL default '0000-00-00 00:00:00',
Lastchanged datetime NOT NULL default '0000-00-00 00:00:00',
Note varchar(255) NOT NULL default '',
PRIMARY KEY Contact (uid,cid)
) TYPE=MyISAM;
ALTER TABLE `Players`
ADD `ContactColumns` int(10) unsigned NOT NULL default '225' AFTER `WaitingroomColumns`;
-----------
* include/table_columns.php (make_tablerow):
- added top-vertical-alignment on table-rows (for contacts),
need some CSS-magic to fix that
* include/std_functions.php (start_page):
- main-menu: added Contacts-link
- main-menu: moved Translate-link into bottom-bar (show only for translators)
* userinfo.php:
- added bottom-link to add or edit user as contact
* include/filter.php (get_terms, FilterText, FilterCheckboxArray),
code_examples/filter_example2.php,
specs/filters.txt:
- added filter-config FC_SUBSTRING for Text-filter for auto-substring-search
- added filter-config FC_BITMASK for CheckboxArray-filter
to build sql-query using bitmask
- added extracting of regex-terms also for Text-Filter (when using wildcards)
* include/filter_parser.php (TextParser):
- added TEXTPARSER_IMPLICIT_WILD to support substring-search for filters
- added extracting of regex-terms (when using wildcards)
2007-07-28 juga
* confirm.php (do_add_time), game.php,
include/std_functions.php (POSX_ADDTIME),
include/game_functions.php (add_time_opponent),
* sgf.php, include/board.php, scripts/game_consistency.php:
- game: write add-time into database,
can choose to reset byo-yomi on add-time (not for Fisher-time),
jump to add-time form if adding time
- added support to add-time for opponent,
adding hours to maintime and/or reset byoyomi,
- added add-time-entry into Moves-table:
PosX=POSX_ADDTIME, Stone=time-adder, PosY=BYO-RESET, Hours=added-hours
* message.php, search_messages.php, send_message.php,
include/message_functions.php, scripts/ChangeLog:
- removed add-time-support (moved to game-page)
- reverted change to Message.Type enum: removed ADDTIME
2007-07-27 juga
* game.php:
- add-time: reduced to one bottom-link to game-page for validation
- also show add-time for my games where it's the opponents to move next
* include/game_functions.php:
- removed some comments, added TODO for no-add-time option
2007-07-27 rodival
* skins/dragon/screen.css, include/std_functions.php,
game_comments.php:
- CSSed the game_comment page.
- fixed a bug leaving the <c> and <h> tags unchanged in the HTML.
2007-07-26 rodival
* include/time_functions.php (time_convert_to_hours),
include/message_functions.php (interpret_time_limit_forms),
send_message.php, game_functions.php, clock_tick.php:
- introduced the time_convert_to_hours() function
* include/quick_common.php (setTZ)
status.php, daily_cron.php, userinfo.php,
users.php, change_profile.php:
- moved (and fixed) the summertime changes check from daily_cron.php
to status.php in a "by user" basis.
- now setTZ() return the previous timezone (backup purpose)
- added a way to check the clock of a user in userinfo.php
- comments adjusted for the other files
* scripts/message_consistency.php,
include/message_functions.php,
status.php, add_to_waitingroom.php, join_waitingroom_game.php,
list_messages.php, search_messages.php:
- checked and removed the useless init_standard_folders(). This function
could be merged into get_folders() as they are always used together.
2007-07-25 juga
* game.php:
- experimental support for adding time for opponent
- added 3 alternative links for add-time for discussion
* include/std_functions.php (make_menu):
- support for allowing Form-object included in bottom-links
2007-07-24 rodival
* skins/dragon/screen.css, include/message_functions.php:
- messages and folders CSS adjustments
* include/faq_functions.php, faq.php:
- remove translations from the admin_faq preview.
* include/std_functions.php, include/faq_functions.php,
faq.php, admin_faq.php, translate.php,
skins/dragon/screen.css:
- full (and final?) CSS refund of the FAQ pages
- introduced the "note" pseudo-tag which is always removed from display.
this allow, for example, the faq admins to send infos to the translators.
* edit_folders.php:
- fix a bug disabling the possibility of renaming the STANDARD_FOLDERS
- now, one can use mysql slashed chars in the folders' names
2007-07-23 rodival
* include/make_game.php,
send_message.php, join_waitingroom_game.php, error.php:
- problem of "bad Running count" fix: more checks to find if the
game had already been accepted.
* game.php:
- minor W3C compliance fix.
* include/std_functions.php:
- added an easier way to configure the vault parameters
* edit_profile.php:
- added the 'x' access key to the submit button
* skins/dragon/screen.css, game.php, include/board.php:
- forum list and board page CSS adjustments
- players rating info fixed to CurrentRating/EndRating
added StartRating in a CSS hidden element
2007-07-22 rodival
* include/faq_functions.php, faq.php, admin_faq.php:
- enhanced the admin_faq preview.
added the file faq_functions.php for the common functions of the
faq scripts.
removed the T_() from admin_faq.php
* include/form_functions.php:
- removed useless include, added a comment
2007-07-22 juga
* include/message_functions.php (message_list_table):
- set correspondent for server-message or if unknown
* game.php, message.php, search_messages.php, send_message.php,
include/game_functions.php (allow_add_time_opponent, add_time_opponent):
- added support to add time for opponent
* error.php:
- fixed typos
2007-07-22 rodival
* include/countries.php, include/filter.php:
- removed the obsolet 'Serbia and Montenegro (Yugoslavia)'
from countries list
* search_messages.php, docs.php, translate.php:
- minor comments adjustments
* include/error_functions.php (echo_error_list),
clock_tick.php, halfhourly_cron.php, daily_cron.php:
- enhanced a little the error handling of cron jobs
added an argument $prefix to echo_error_list()
added completion flags in the cron scripts (using the Ticks
field of their owned clock)
2007-07-22 juga
* links.php:
- removed invalid and corrected existing links and texts
- added IGF as mediator to most international go associations
- added OGS
2007-07-21 juga
* forum/search.php, include/filter.php, include/form_functions.php,
include/tokenizer.php, opponents.php, search_messages.php,
show_games.php, site_map.php:
- corrected translated texts (typo, upper/lower-case,
use '#'-notation to avoid ambiguities and allow notes-like namespaces)
* docs.php:
- added NEWS as "Release notes"
* translate.php:
- more instructive text about '#'-notation
* admin_faq.php:
- mark "current" entry with green marker
- moved marker in front of entries (inbetween hard to see)
- added cookie-based move-distance for up-/down-move of entries
resettable with 0 to default 1
* include/message_functions.php (message_list_table),
search_messages.php:
- abstracted details of types-filter to: Private, Game messages
- moved 'Myself' into direction-column as message with from & to
changed texts of direction-filter: Recieved/Sent -> From/To
- left-aligned text in colored folder-checkboxes
- removed bottom-links (Browser/Edit folders),
because redundant with main-menu-links
* admin_faq.php:
- added preview-option in new/edit-entry page
- added search to find texts also in hidden entries
- locate page roughly where recent working took place using anchors
- overworked instructions, some more comments
- minor layout-adjustments: submit-button, labels, alignment
* include/form_functions.php:
- allows to omit maxlength of INPUTBOX-element specifying as <0
2007-07-21 rodival
* include/std_functions.php, admin_admins.php:
- introduced 2 new admins classes: developers and skinners
-----------
UPDATE `Players`
SET `Adminlevel`=-1 WHERE `ID`=2 LIMIT 1 ;
-----------
* edit_profile.php:
- reduced the access to the skins (temporary)
* translate.php, update_translation.php,
include/make_translationfiles.php:
- gave an access to all languages to the ADMIN_TRANSLATORS
* include/std_functions.php, admin_do_translators.php, admin.php,
admin_faq.php, admin_password.php, admin_translators.php,
change_password.php, people.php, send_new_password.php, status.php,
* scripts/convert_from_old_forum.php, scripts/convert_posindex.php,
scripts/data_export.php, scripts/data_report.php,
scripts/FAQtransl_consistency.php, scripts/game_consistency.php,
scripts/generate_translation_texts.php, scripts/mailtest.php,
scripts/message_consistency.php, scripts/player_consistency.php,
scripts/recalculate_ratings2.php, scripts/start_frozen_clocks.php,
scripts/update_translation_pages.php,
* forum/admin.php, forum/index.php, forum/list.php, forum/read.php,
forum/search.php:
- removed the global $admin_level (use $player_row['admin_level'] instead)
- normalization of each places where $player_row['admin_level'] is used
2007-07-20 rodival
* forum/forum_functions.php, skins/dragon/screen.css:
- added a "go back to first new" link at bottom of lists
CSSed the "new" links
- adjusted the MarkTerm colors
* admin_password.php, send_new_password.php, forgot.php:
- added a way to overwrite the current new password process for admins.
* include/make_translationfiles.php, admin_faq.php, faq.php,
translate.php, update_translation.php:
- add of a better 'translated' flags management between the translators
and the FAQ admins.
now, the different languages may set their translated flag independently.
-----------
ALTER TABLE `Translations`
ADD `Translated` ENUM( 'Y', 'N') NOT NULL DEFAULT 'N' AFTER `Text` ;
UPDATE `Translations` SET `Translated` = 'Y';
-----------
- changed the 'hidden' and 'translatable' buttons of admin_faq.php
from a toggle process to a set/reset process. Basicaly, they acts
the same way but a simple refresh of the page will not "toggle-back"
the option now.
- modified the "move" part of admin_faq.php to allow a move greater
than 1: admin_faq.php?move=u&dir=3 now move the item 3 steps higher.
alas, actualy, this is only usable my manualy modifying the URL.
* scripts/FAQtransl_consistency.php:
- added file (as a seed for more)
2007-07-19 rodival
* admin_translators.php, admin_do_translators.php:
- added a 'Known languages' listing
2007-07-18 juga
* change_profile.php, edit_profile.php,
include/std_functions.php (get_maxrows, build_maxrows_array),
include/table_columns.php:
- added TableMaxRows (can be locally changed using cookie),
store table-max-rows in new column Players.TableMaxRows
- Table: URL-var 'maxrows' overrules user-prefs for max-rows
- changed default for RowsPerPage: 50 -> 20
- added limits for profiled maxrows: MAXROWS_PER_PAGE_PROFILE
- added maxrows-default for get_maxrows(): MAXROWS_PER_PAGE_DEFAULT
- added default rows-limit for build_maxrows_array() to restrict
max-rows in edit-profile to MAXROWS_PER_PAGE [50]
-----------
ALTER TABLE `Players`
ADD `TableMaxRows` smallint(5) unsigned default 20 NOT NULL;
-----------
* list_messages.php:
- reverted bottom-link to verbal form: Search messages (according to site-map)
* include/filter.php (add_or_del_filter):
- removed todo to save filter (for now)
* include/filter.php (is_static),
code_examples/filter_example.php, code_examples/filter_example2.php:
- added global const FILTER_CONF_FORCE_STATIC making all
filter-elements static (no filter-hide, set at the moment),
added filter-config FC_HIDE to overrule that const
- use default size 8 for Rating-Filters
* opponents.php, users.php, waiting_room.php:
- added filter-config FC_HIDE on Country-filter
- use (default) size 8 for Rating-Filters
* search_messages.php:
- SQL-optimization: replaced 'Game_ID<>0' with 'Game_ID>0'
2007-07-18 rodival
* include/std_functions.php, include/quick_common.php:
- moved the IS_RUNNING_GAME constant in quick_common.php to make it
usable by the rss and wap stuff and the 'quick_*' suite.
* include/config.php:
- moved a line closer to its friends.
* include/message_functions.php, include/countries.php, site_map.php:
- minor fixes, comments and translated strings.
2007-07-18 juga
* opponents.php, user_stats.php, site_map.php, userinfo.php, users.php,
include/filter.php, code_examples/filter_example.php:
- "renamed" user_stats.php (removed) to opponents.php (added),
copied full CVS-log from user_stats.php on initial revision
* show_games.php, user_stats.php:
- optimized SQL replacing 'OR'-operator with UNION-based SQL-query,
activated with global const ALLOW_SQL_UNION in "include/config.php",
needed to adjust sort-fieldnames (UNION forces to use fields from SELECT)
- used more detailed bottom link-texts for games-page to show
where you are and where you can go (showing my/all/other-users games,
without adding more links), for observer-game-view added additional
links to show all games (preserving shared URL-vars)
* include/config.php (ALLOW_SQL_UNION):
- added ALLOW_SQL_UNION as on/off-switch to control UNION-support,
default now is to support UNION-queries
* search_messages.php:
- avoid SQL-'OR'-operator by reducing Correspondent-filter on Players.Handle,
may later be reverted by using UNION-based-query
- extended filters syntax-description with hint to what can be searched (Userid)
- changed bottom-link to 'Browse folders'
* include/message_functions.php (message_list_table):
- changed message-list for search-messages-page to show
full user-name with handle and link to userinfo,
added message-link on subject
* include/filter.php (get_syntax_description, get_syntax_hint),
specs/filters.txt, code_examples/filter_example2.php:
- added filter-config FC_SYNTAX_HINT allowing to extend a filters
hover-text-syntax-description
- added example for filter-config FC_SYNTAX_HINT
2007-07-17 juga
* include/std_functions.php (not_in_clause):
- added constant SQL-clause-part IS_RUNNING_GAME to apply for Games.Status
to optimize SQL getting rid of '!='-operator to use index
- changed func: build_not_in_clausepart(..) -> not_in_clause( enum-array, var-args )
to build optimized 'NOT IN'-surrogate with IN for any table-column
- removed func: not_in_Games_Status(), use not_in_clause( $ENUM_GAMES_STATUS, ...)
* clock_tick.php, confirm.php, daily_cron.php, edit_vacation.php,
halfhourly_cron.php, quick_status.php, show_games.php, status.php,
scripts/player_consistency.php, scripts/start_frozen_clocks.php,
user_stats.php, rss/status.php, wap/status.php:
- optimized SQL getting rid of '!='-operator to use index on Games.Status,
replaced using SQL-clause-part IS_RUNNING_GAME
* forum/search.php:
- changed Author-filter:
only filtering on Players.Handle, removed OR with Players.Name
adjusted Text by adding '(Userid)'
2007-07-16 juga
* include/std_functions.php (build_not_in_clausepart, not_in_Games_Status):
- added funcs to provide optimized SQL-part IN-clause using index,
but allowing to express it with negated values,
e.g. Status not_in_Games_Status('INVITE') <=> Status != 'INVITE'
<=> Status NOT IN ('INVITE')
!! all '!=' and 'NOT IN' SQL-parts should be replaced if the
databases index cardinality on that field is >2 or at least if >3
2007-07-16 rodival
* include/std_functions.php (send_message, delete_all_observers):
- ajusted the arguments of send_message() including the previous
message modifications
enabled the use of send_message()
changed the escaped state of the Text argument of delete_all_observers()
now it should NOT be escaped before the call.
* send_message.php, join_waitingroom_game.php, clock_tick.php:
- enabled the use of send_message()
* confirm.php:
- enabled the use of send_message() and notify()
* include/std_functions.php, include/make_game.php (create_game),
include/rating.php (get_rating_at, convert_to_rating, read_rating),
include/filter.php (convert_rank):
- introduced the OUT_OF_RATING constant (ominous limit for ratings).
now read_rating() always return a numeric value.
* skins/dragon/screen.css:
- adjusted the size of the separations of the forum posts.
added some comments
* user_stats.php, show_games.php:
- reversed the "NOT IN ('INVITED','FINISHED')" clauses
2007-07-16 juga
* include/std_classes.php (get_select, get_select_normal),
code_examples/query_sql.php:
- QuerySQL: added basic UNION-support allowing non-template-WHERE-clause,
specify with SQLP_UNION_WHERE; added example
2007-07-15 juga
* include/filter_functions.php (createTokenizerConfig),
include/filter_parser.php (TextParser.parse):
- changed default filter-quote-type: use quoting using single-quotes "'"
- fixed bug: wildcard '*' now has higher precedence over separator '-',
can be controlled using TEXTPARSER_PRECEDENCE_SEP-flag
* skins/dragon/screen.css:
- removed no longer needed style for Filter <sup> after using
Filter-hide-image
* users.php:
- widened input-box-size for Rating-filter
2007-07-15 rodival
* include/filter.php (build_generic_selectbox_elem):
- moved the "\n" before "</select>" to avoid a spacing effect after the
select box.
* include/table_columns.php (make_table_filter),
skins/dragon/screen.css:
- inserted the CSSed "hide" buttons for the filters, the same way those
from the column headers.
2007-07-15 juga
* include/filter.php (parse_value), code_examples/filter_example2.php:
- FilterRelativeDate: allowed '<unit' as additional syntax
2007-07-14 juga
* include/std_classes.php (merge_from_parts):
- QuerySQL: assure mysql5.0-compatibility by replacing ','-join
with INNER JOIN
* search_messages.php:
- layout-changes:
- use smaller padding (6 -> 4px) for folder-boxes
- compact form and page (reorder filters and less empty rows)
* user_stats.php, waiting_room.php:
- compact form and page (less empty rows)
* users.php:
- use proper upper/lower-case on title
* forum/search.php:
- removed anchor on table-search (filters can have errors)
* include/table_columns.php, skins/dragon/screen.css:
- compact table (less empty rows)
- right-align paging next-link
2007-07-14 rodival
* include/table_columns.php:
- added the set_sort() function to force the table sort
* status.php, users.php, user_stats.php:
- managed the sort arguments the new way.
* include/message_functions.php, include/filter.php, list_messages.php,
search_messages.php, site_map.php, forum/search.php:
- adjusted some comments and T_() strings
* include/filter.php (get_submit_elements),
include/table_columns.php (make_add_column_form),
forum/search.php:
- a proposition for the get_submit_elements() function: added a
$filtertype argument to manage the buttons name.
modified the other files accordingly.
2007-07-13 juga
* include/filter.php (FilterMysqlMatch.get_terms, get_submit_elements):
- bugfix get_terms() for Mysql-match:
filter shouldn't return terms if inactive
- renamed start-/reset-search -> apply/reset-filter
- comment for minimum mysql-version for fulltext-search:
mysql 4.0.1 (boolean-mode), 4.1.1 (query-expansion)
2007-07-12 rodival
* include/std_functions.php (parse_tags_safe, parse_html_safe),
include/message_functions.php (message_info_table,
message_list_table),
* forum/list.php, forum/forum_functions.php (draw_post,
display_posts_pending_approval),
skins/dragon/screen.css:
- moved the mark_terms feature into the make_html_safe process.
added the $mark_terms argument to parse_html_safe() and make_html_safe()
removed the <term> pseudo-tag previously used to mark the terms
removed the now obsolete mark_terms() function
- introduced the SUBJECT_HTML constant to highlight to common "style"
of the subjects.
* forum/search.php, forum/forum_functions.php (make_link_array),
include/filter.php:
- changed the type of the search form to POST because a GET one plus
a url #id part make the buttons inactive if no fields have changed.
added a 'x' accesskey to the main button of the search page
fixed some minor weakness.
a try to include a "moderator" search but this need to define a new
subclass in draw_post: added a comment and postponed it.
* include/table_columns.php, faq.php, waiting_room.php,
forum/read.php:
- minor changes on comments.
2007-07-11 juga
* include/filter.php (class FilterMysqlMatch, extract_match_terms):
- FilterMysqlMatch: renamed boolean-mode -> expert-mode,
simplified extracting of regex-terms
2007-07-11 rodival
* include/table_columns.php (make_tablehead),
include/table_infos.php (make_tablerow),
skins/dragon/screen.css:
- enhanced the row highlight display
- renamed 'remcol.gif' to the more general 'remove.gif'
* include/std_functions.php:
- enable the javascript tools.
* include/translation_functions.php:
- new try for T_ #info: cut if the char before '#' is not a space
2007-07-10 rodival
* edit_bio.php:
- readonly+message instead of disabled
* game.php:
- onchange on gotomove select box
* people.php:
- "language name not found" now display the language code
* include/translation_functions.php:
- better T_ #info cut
2007-07-09 rodival
* join_waitingroom_game.php, include/make_game.php (create_game(),
make_standard_placement_of_handicap_stones()):
- an other try to fix the bad Running count bug:
a small enhancement of the handicap management.
a rewrite of join_waitingroom_game.php to make easier the comparison
with the similar part (create game) of send_message.php.
* game.php:
- add of a message to invite the player to validate his action.
2007-07-09 juga
* game.php:
- deactivated prev/next game-navigation with images
* include/message_functions.php:
- fix last fix for highlighting terms in message: using correct var
2007-07-09 rodival
* include/std_functions.php, scripts/mailtest.php:
- adjustments to test a mass email post.
* forum/forum_functions.php:
- reverted last fix
2007-07-08 rodival
* forum/list.php, forum/forum_functions.php,
include/message_functions.php:
- emphasized the fact (and fixed some of buggy ones) that a Subject
must not contain HTML tags. Some fixes around mark_term() are
temporary and will be better handled soon.
* forum/search.php:
- default JOIN changed with INNER JOIN
* edit_bio.php:
- limitation of the cells size in an other way than cut_string(),
not based on the text length but on the box size,
using disabled or readonly textarea
* halfhourly_cron.php, send_new_password.php,
include/std_functions.php:
- enabled the new send_mail() function everywhere... with a rollback
possibility because I have no way to test the emails nor on my
private server either on the devel server. >>> should be tested.
2007-07-08 juga
* game.php:
- added images (start/end, previous/next-moves) as links to navigate
within game; used existing images start/backward/forward/end.gif
[later removed]
* users.php, code_examples/query_sql.php, forum/search.php,
include/message_functions.php:
- added 'AS' for SQL-table aliases
2007-07-07 rodival
* show_games.php, users.php, include/message_functions.php,
include/std_classes.php:
- default JOIN changed with INNER JOIN
* include/table_columns.php (make_tablehead),
skins/dragon/screen.css:
- added images in the header to show how the table columns are sorted.
this implied to change the previous hidding red 'x' to an image too.
- added a constant to disable the second level of sort.
* images/sort1a.gif, images/sort1d.gif,
images/sort2a.gif, images/sort2d.gif, images/remove.gif:
- new images added used for table-sort-indicator
2007-07-07 rodival
* include/std_functions.php (send_email, send_message, clean_url,
is_logged_in):
- added the send_email() and send_message() functions
- adjusted clean_url() to chop all the trailing '?' and '&' chars
- introduced the "fever vault" in is_logged_in(). May be adjusted
or disabled whith the FEVER_CNT constant. May be tunned for the
guest account which is a multiple account and so should have larger
limits.
The "fever vault" process had 3 main variables: if a user produces
more that FEVER_CNT page calls during "one hour", he will be
vaulted for one day (i.e. unable to log himself while receiving
an info message).
-----------
ALTER TABLE `Players`
CHANGE `Hits` `Hits` int(11) NOT NULL DEFAULT 0 ,
ADD `VaultTime` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `Hits` ,
ADD `VaultCnt` smallint(5) unsigned default 0 NOT NULL AFTER `Hits` ;
-----------
2007-07-07 rodival
* include/connect2mysql.php (connect2mysql):
- changed the returned value by connect2mysql(true): in case of
error, it returns the error message now instead of false.
- added the mysql_single_col() function
* error.php,
* include/error_functions.php (set_mode, add_error, error):
- now set_mode() return the previous mode (to save and restore it)
- now add_error() and error() return false if the errors are not
fatal. This allow $result = mysql_query(...) or error(...);
to continue with $result === false
- finally, if an error occurs during the initialization of
error.php, it will no more recall error.php and thus not fall
in a recursive trap.
2007-07-07 rodival
* update_translation_pages.php, generate_translation_texts.php,
message_consistency.php, player_consistency.php, recalculate_ratings2.php,
start_frozen_clocks.php, convert_posindex.php, convert_from_old_forum.php,
phpinfo.php:
- disabled some one shot scripts, enhanced the others
2007-07-06 rodival
* confirm.php, quick_play.php:
- moved the place where the GameNotes are deleted
- few minor debug messages adjustments (quick_play accordingly)
2007-07-06 rodival
* admin_faq.php:
- hidden the info box and added an anchor to show it.
- adjusted some colspan= of the main table.
- allowed to edit an item even if hidden.
- inverted the icon of Hide and Show buttons.
2007-07-05 rodival
* translate.php, update_translation.php,
* include/make_translationfiles.php (translations_query):
- modified the 'Untranslated' option (may be applied on every group).
therefore, added a 'All groups' option.
- hidden the now big info box and added an anchor to show it.
2007-07-03 rodival
* translate.php, update_translation.php,
* include/make_translationfiles.php (translations_query):
- added a filter on the english part.
added the $filter_en argument to translations_query()
* INSTALL:
- added a step to protect the scripts/ folder.
2007-07-02 juga
* show_games.php:
- added hover-text on colors-column for "my running games"
2007-07-01 juga
* include/std_functions.php (make_url):
- reverted changes to make_url-func to fix bug
2007-06-30 juga
* waiting_room.php:
- changed bottom-link to 'Show all suitable games' to indicate it's a reset
2007-06-30 juga
* include/filter.php,
include/filter_functions.php,
include/filter_parser.php,
include/std_classes.php,
include/tokenizer.php,
* code_examples/filter_example.php,
code_examples/filter_example2.php,
code_examples/query_sql.php,
code_examples/tokenizer_example.php,
* skins/dragon/screen.css,
* specs/filters.txt:
- added classes and functions comprising new Filter-framework
- added examples for filter-stuff
- added some CSS for filters
- added main-doc in specs/filters.txt
* include/table_columns.php (Table.constructor, set_externalform,
set_rows_per_page, use_show_rows, current_filter_string,
add_or_del_column, handle_show_rows, current_rows_string,
get_displayed_tableheads, register_filter, get_query,
add_external_parameters, current_extparams_string):
- added searching capabilities on table-columns using Filter-framework
see specs/filters.txt and code_examples/form_example2.php
- fixed paging-link-bug preserving form-values with links
- added maxrows-selection to restrict row-size of table-list
* include/form_functions.php (set_config, get_config,
set_attr_form_element, set_layout, set_area, add_empty_row,
create_form_string, get_areaconf),
* code_examples/form_example.php, code_examples/form_example2.php:
- added Form-types 'FILTER' and 'FILTERERROR' for Filter-framework
- added area-group layouting and some additional layout-config
when used as External-Form with Table(-Filters)
- added example for area-layouting, allow examples to be opened in browser
* show_games.php, users.php, waiting_room.php, message.php, status.php,
* forum/search.php:
- added or extended searching capabilities using filter-framework
- adjustments for using filters
- added (recommended) new indexes to support new filters;
needed space + reasons given as comment:
-----------
ALTER TABLE `Games` -- +3 MB (for filter)
ADD INDEX `Handicap` (`Handicap`) ;
ALTER TABLE `Games` -- +2 MB (for filter/sort)
ADD INDEX `Moves` (`Moves`) ;
ALTER TABLE `Games` -- +3 MB (for filter/sort)
ADD INDEX `Score` (`Score`) ;
ALTER TABLE `Posts` -- +0.2 MB (for filter)
ADD INDEX `Parent_ID` (`Parent_ID`) ;
ALTER TABLE `Posts` -- +0.2 MB (for filter/sort)
ADD INDEX `Time` (`Time`) ;
ALTER TABLE `Players` -- +0.2 MB (for filter)
ADD INDEX `Country` (`Country`) ;
ALTER TABLE `Players` -- +0.4 MB (for filter/sort, often changed)
ADD INDEX `Lastaccess` (`Lastaccess`) ;
-----------
* search_messages.php, list_messages.php,
* include/message_functions.php (init_standard_folders, echo_folder_box,
message_list_query, message_list_table):
- added new page for searching messages using filters
- signature-change of funcs to change layout or highlight search-terms:
message_list_query/_list_table/_info_table, echo_folder_box
- signature-change of message_list_table-func adding args to control
message-list output including fields for message-searching:
folder, type, Direction, message partner
- added (mandatory) fulltext-index for search on messages
- slight modifications of SQL using table-alias and join on
MessageCorrespondents
-----------
ALTER TABLE `Messages` -- +4 MB (for joins/filter)
ADD INDEX `ReplyTo` (`ReplyTo`) ;
ALTER TABLE `Messages` -- ca. +80% of data-size (biggest change)
ADD FULLTEXT INDEX `Subject` (`Subject`,`Text`) ;
-----------
* users.php:
- replaced URL-var 'showall' and page-bottom-link with 'Active'-Table-Filter
* user_stats.php, userinfo.php, users.php:
- added new page to show opponents and games-statistics for two players
* waiting_room.php:
- added Player-Country-column and Filter on it
- bugfix: used wrong SQL-field for table-column #1 (sort by name)
- replaced URL-var 'showall' and page-bottom-link with two Table-Filters
Suitable-Handicap and Suitable-Rating-Range
- change page-title reflecting current "suitable"-state
- re-added page-bottom-links "Show all games" and "Show only suitable
games" to reset to filter-defaults
* forum/read.php, forum/search.php,
forum/forum_functions.php (make_link_array, forum_start_table),
* include/quick_common.php:
- added order-selectbox in forum-search
- added support to highlight search-terms in a post or message
- fixed bug for paging to preserve form- and filter-values
- fixed bug with relevance when using search-terms in boolean-mode
- added const DAYS_NEW_END used for forum-reads
* include/std_functions.php (DEBUG_SQL, map_to_string, mark_terms,
get_maxrows, build_maxrows_array, make_url, clean_url, has_observers,
blend_alpha_hex):
- added some functions and consts to support Filter-framework:
- support to handle maxrows of table-listing, added funcs
get_maxrows, build_maxrows_array
- added allowed HTML-text <term> to support term-highlighting
- added mark_terms-func to highlight terms within potential XML-text
- added defaults for Table-Filter-layout
- adjusted body-width to 90% fixing some strange centric-related layout-
effects with nested tables (may hopefully get fixed later using CSS)
- fixed bug in make_url-func only append URI_AMP or '?' if not there,
added clean_url-func to chop off trailing URI_AMP or '?'
- changed default-handling of bgcolor for echo_folder_box-func
- added has_observers-func
* edit_bio.php:
- reduce output of bio-texts to 200 chars when changing order
* site_map.php:
- added new and search pages
* game.php:
- added page-bottom-link to show observers (users.php?observe=<gid>)
* NEWS, TODO:
- cleanup some items done
* INSTALL:
- move also dot-files like .cvsignore after CVS-checkout
* scripts/README.developers:
- added categories and more hints about (surprising) PHP-behaviour
- don't use filenames with upper-case
2007-06-30 rodival
* include/std_functions.php, list.php:
- removed the unused $MaxRowsPerPage global var.
* include/make_translationfiles.php (translations_query),
* translate.php, update_translation.php:
- added a "prev/next" management of the translators' pages.
added the $from_row argument to translations_query()
* scripts/README.translations:
- documenting the "do_it" URL argument of generate_translation_texts.php
2007-06-29 rodival
* people.php, admin_faq.php:
- added the info about FAQadmins' activity to "LastUpdate".
-----------
ALTER TABLE `FAQlog`
ADD `Date` timestamp(14) NOT NULL AFTER `Answer` ;
UPDATE `FAQlog` SET `Date` = '0' ;
-----------
* include/translation_functions.php (language_exists,
T_, get_language_descriptions_translated),
* translate.php:
- case insensitive search of the language name in language_exists().
- added an automatic cut of the #xxx part of the alternate english words
in T_().
- added a $keep_english parameter to get_language_descriptions_translated().
- changed all $langcode names to the now more accurate $browsercode.
* include/make_translationfiles.php (translations_query),
* admin_translators.php, admin_do_translators.php,
translate.php, update_translation.php,
* scripts/generate_translation_texts.php:
- added the add_text_to_translate function.
- added the insertion of the new language names in the translation process.
- added an optional alphabetical sort in translations_query().
- added a better "T_(...)" template detection using eval() in
generate_translation_texts.php. Also added a "do_it" URL argument.
- changed all $langcode names to the now more accurate $browsercode.
* scripts/update_translation_pages.php (find_php_files):
- updated the $directories array in find_php_files().
- added a "Fatal error" - waiting for a fix - in case of a $TranslateGroups
not found in the database. The bug may come from a typo in the PHP code
or from a missing row in the database. The default "do_it" action fix
this last case.
2007-06-28 rodival
* statistics.php, graph.php, ratingpng.php, statisticspng.php:
- added the statratingspng.php file which display stats on ratings.
Minor adjustments of other files to handle it.
Added the function patterncolor() to graph.php.
2007-06-26 rodival
* add_to_waitingroom.php, join_waitingroom_game.php, waiting_room.php:
- fixed the "double game" handicap option from the waitingroom.
In the waitingroom table, renamed the old "Handicap" column to
"Colors" and added the new "Handicap" one containing the number
of handicap stones.
-----------
ALTER TABLE `Waitingroom`
ADD `Handicap` int(11) NOT NULL default '0' AFTER `Komi` ;
-----------
* include/message_functions.php (game_info_table),
include/make_game.php,
* send_message.php:
- adjusted to follow the "double game" handicap fix and its display.
- and a try to fix the bad Running count bug:
In the Players table, near 20 of the Running counts were 1 or 2
points too high. I've not found why this occured. Maybe a script
abort between two MySQL updates, I don't know.
Other counts like Finished, Won or Lost were not corrupted.
2007-06-25 rodival
* scripts/data_report.php:
- implementation of a two steps validation:
first, just the EXPLAIN, then the full result.
- differenciation of the NULL values.
* scripts/data_export.php:
- including the translations tables export
and hidding some minor variations.
2007-06-24 rodival
* scripts/game_consistency.php, include/move.php (check_move):
- enhanced consistency check. Added some Time and Rating checks.
Now, check_move() returns '' if no error or the error message
(instead of returning false on error and true else).
* people.php:
- changed the info about translators' activity to "LastUpdate".
2007-06-03 rodival
* game.php, confirm.php:
- fixed the bug: can't deleted a game while PASS or SCORE step entered
before the delete limit.
added the GamesNotes deletion to the delete feature.
* include/std_functions.php (user_reference):
- because of old DGS users having a pure numeric Handle (not starting
by a letter), the illegal_chars($player_ref) call had been replaced
by a simple ereg() comparison here.
* userinfo.php, users.php:
- changed the Percent calculus to 100*(Won+Jigo/2)/RatedGames instead
of the previous 100*Won/RatedGames.
2007-03-27 rodival
* edit_vacation.php:
- fixed the bug: adding 2.00 days to 0.25 days gave 2.00 days.
In fact, when OnVacation was < 1, one can't add but just start vacations.
2007-03-17 rodival
* confirm.php:
- added a missing parenthesis.
* admin_faq.php:
- adjusting a 'NULL'.
2007-03-01 rodival
* images/flags/ls.gif:
- replaced by the new Lesotho flag (old one kept in ls_old.gif)
-----------
* images/forward.gif, images/backward.gif,
images/end.gif, images/start.gif,
images/plus.gif, images/minus.gif, images/cross.gif:
- added images
-----------
2007-02-04 rodival
* init.mysql, include/std_functions.php (make_session_code):
- new MySQL 4.1 behaviour: the PASSWORD() produce a 41-byte hash value
- modifying Sessioncode in a same spirit
-----------
ALTER TABLE `Players`
CHANGE `Password` `Password` VARCHAR( 41 ) NOT NULL default '' ,
CHANGE `Newpassword` `Newpassword` VARCHAR( 41 ) NOT NULL default '' ,
CHANGE `Sessioncode` `Sessioncode` VARCHAR( 41 ) NOT NULL default '' ;
-----------
* init.mysql:
- full periodic check, previous missing update
-----------
ALTER TABLE `TournamentRound`
CHANGE `Handicaptype` `HandicapType` int(11) NOT NULL default '0' ;
ALTER TABLE `TranslationGroups`
CHANGE `Groupname` `Groupname` varchar( 32 ) NOT NULL default '' ;
ALTER TABLE `Translations`
CHANGE `Text` `Text` blob NOT NULL ;
ALTER TABLE `Adminlog`
CHANGE `Handle` `Handle` varchar(16) NOT NULL default '' ,
CHANGE `Message` `Message` text NOT NULL ;
-- ALTER TABLE `Adminlog`
-- ADD `IP` varchar(16) NOT NULL default '' AFTER `Date` ;
ALTER TABLE `FAQ`
CHANGE `Level` `Level` int(11) NOT NULL default '0' ,
CHANGE `Question` `Question` int(11) NOT NULL default '0' ,
CHANGE `Answer` `Answer` int(11) NOT NULL default '0' ;
-----------
* data_export.php:
- Create_options management added and CSS adjusted.
2007-02-03 rodival
* include/graph.php, ratingpng.php, ratinggraph.php:
- rating graph displayed "by number of games"
(new X-axis option added to the old "by date of games")
- complete rebuild of graph.php. Graph class added.
handling the "bynum" option
* statisticspng.php, statistics.php:
- using the new Graph class
* include/rating.php, include/std_functions.php:
- small modifications consequently
2007-01-25 rodival
* include/table_columns.php:
- enhancements mainly to fix the "button" column min-width
until CSS min-width is working
- introduced use of external form (var ExternalForm)
- added funcs: set_default_sort(), get_arg()
* include/std_functions.php (split_url, yesno, modf & more),
include/message_functions.php:
- added funcs
- adaptations for enhanced Table_Info class, "button" columns and
common to waitingroom and message
* skins/dragon/screen.css,
* edit_bio.php,
list_messages.php,
message.php,
show_games.php,
status.php,
userinfo.php,
waiting_room.php:
- using new Table_Info class properties, for games infos and
common to waitingroom and message
* NEWS, news.php, skins/dragon/screen.css:
- adding NEWS file [initally built by JUG] with user-visible changes
2007-01-21 rodival
* scripts/README.developers, scripts/CHANGELOG.developers, CHANGELOG:
- added info files
2007-01-12 rodival
* include/connect2mysql.php (mysql_addslashes) + most of the other
files (used nearly everywhere):
- generalization of the right MySQL addslashes feature,
introducing function to properly escape value in SQL-statements
* do_registration.php:
- rejection of some account usurpers
* whole set of forum files/functions using table 'Posts.PosIndex':
- changed 'Posts.PosIndex' to NOT NULL
-----------
ALTER TABLE `Posts`
CHANGE `PosIndex` `PosIndex` varchar(80) binary NOT NULL default '' ;
-----------
- removing NULL fields
the Posts.crc32 int(11) default NULL, seems to be
kept (while not yet used)
-----------
ALTER TABLE `Players`
CHANGE `IP` `IP` varchar(16) NOT NULL default '' ;
ALTER TABLE `Posts`
CHANGE `Time` `Time` datetime NOT NULL default '0000-00-00 00:00:00' ,
CHANGE `Lastchanged` `Lastchanged` datetime NOT NULL default '0000-00-00 00:00:00' ,
CHANGE `Lastedited` `Lastedited` datetime NOT NULL default '0000-00-00 00:00:00' ,
CHANGE `LastPost` `LastPost` int(11) NOT NULL DEFAULT 0 ,
CHANGE `Subject` `Subject` varchar(80) NOT NULL default '' ,
CHANGE `Text` `Text` text NOT NULL ,
CHANGE `User_ID` `User_ID` int(11) NOT NULL DEFAULT 0 ,
CHANGE `Parent_ID` `Parent_ID` int(11) NOT NULL DEFAULT 0 ,
CHANGE `PostsInThread` `PostsInThread` int(11) NOT NULL DEFAULT 0 ,
CHANGE `old_ID` `old_ID` int(11) NOT NULL DEFAULT 0 ;
-----------
* include/table_infos.php:
- enhanced Table_Info class to handle waiting_room particularities and
games info
- changed syntax of row/column-description (properties)
* waiting_room.php, userinfo.php, edit_bio.php, status.php:
- using the new Table_infos class properties
* skins/dragon/screen.css:
- to follow the Table_infos modifications
2007-01-10 rodival
* include/table_infos.php:
- adding class Table_infos for more CSS friendship
* userinfo.php, edit_bio.php, status.php:
- using class Table_infos
2007-01-09 rodival
* change_bio.php, edit_bio.php: [from code mailing of JUG]
- adding the "bio infos order" feature
- removing NULL fields
-----------
ALTER TABLE `Bio`
ADD `SortOrder` INT( 11 ) DEFAULT 0 NOT NULL AFTER `Text` ;
ALTER TABLE `Bio`
CHANGE `Category` `Category` VARCHAR( 40 ) NOT NULL DEFAULT '' ,
CHANGE `Text` `Text` TEXT NOT NULL DEFAULT '' ;
-----------
2006-12-29 rodival
* include/std_functions.php (verify_email) + all callers:
- adjusted error signature and error behaviour
2006-12-28 rodival
* init.mysql:
- removing NULL fields in database
- added 'RESULT' to enum Messages.Type for a futur message chain walking
throught the game comments. The 'RESULT' messages are those send at
the end of a game.
-----------
ALTER TABLE `Messages`
CHANGE `Type` `Type` ENUM( 'NORMAL', 'INVITATION', 'ACCEPTED', 'DECLINED', 'DELETED', 'DISPUTED', 'RESULT' ) DEFAULT 'NORMAL' NOT NULL ,
CHANGE `ReplyTo` `ReplyTo` INT( 11 ) DEFAULT 0 NOT NULL ,
CHANGE `Game_ID` `Game_ID` INT( 11 ) DEFAULT 0 NOT NULL ,
CHANGE `Time` `Time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL ,
CHANGE `Subject` `Subject` VARCHAR( 80 ) DEFAULT '' NOT NULL ,
CHANGE `Text` `Text` TEXT NOT NULL ;
ALTER TABLE `MessageCorrespondents`
CHANGE `uid` `uid` INT( 11 ) DEFAULT 0 NOT NULL ,
CHANGE `mid` `mid` INT( 11 ) DEFAULT 0 NOT NULL ;
-----------
* include/time_functions.php (echo_time_remaining) + all callers:
- fix bad display of JAP byoyomi when byoyomi reached
( "--- + 3 periods of 4h" instead of "4h + 3 periods of 1d" )
* include/std_functions.php (mysql_single_fetch) + all callers:
- force to use $debugmsg with mysql_single_fetch()
2006-12-27 rodival
* images/flags/__.gif:
- resizing
-----------
* images/flags/eu.gif:
- added, though not enabled in countries.php
-----------
2006-12-23 rodival
* init.mysql:
- added skinname
-----------
ALTER TABLE `Players`
ADD `SkinName` VARCHAR( 32 ) DEFAULT '' NOT NULL AFTER `OnVacation` ;
-----------
* skins/,
skins/index.php,
skins/known_skins.php,
skins/dragon/index.php,
skins/dragon/screen.css,
skins/dragon/print.css:
- added CSS files for skins
* include/std_functions.php (start_page) + all callers:
- use of skins
* sgf.php:
- score 0 for Jigo
-----------
==================================================================
Release [2006-08-07] - DGS 1.0.12 - CVS-tag [DGS-stable-200608]
//
koh5_pano
Drag mouse to navigate.
Navigation
- Left/Right Mouse drag: Changes camera heading.
- Up/Sown Mouse drag: Changes camera pitch.
- Scroll wheel: Changes camera field of view.
- I-Key: Displays Info panel with canvas size, image size and FPS.
17.Aug.2010, Martin Wengenmayer