Original author: [email protected] (March 06, 2013 06:19:40)

Add TagManager and Manifest input options to:

TfTypexkeys
TfTypelanguages

Original issue: http://code.google.com/p/tablefield/issues/detail?id=26

Original author: [email protected] (March 11, 2013 01:14:03)

TfType->intag() is called per each and every form element.
Making it fast and light is important.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=47

Original author: [email protected] (May 19, 2011 17:49:44)

Create a utility that makes translation of a new language easier.
The flow:

1. Select Language
2. A list of all strings will be listed in a 2-row table. The original strings on the left, in gray. The translated (if available) in blue on the right, editable with a click.
3. Strings which includes vars on the original but not on the translated, or visa versa, should be red, with a small icon+title to indicate this problem.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=12

Original author: [email protected] (March 10, 2013 00:08:44)

Allow adding lines to sub-tables on Edit mode

Original issue: http://code.google.com/p/tablefield/issues/detail?id=43

Original author: [email protected] (May 19, 2011 17:21:49)

Create this documentation both in a DOC file (or PDF or RTF),
and also on Google-Code-Wiki

Original issue: http://code.google.com/p/tablefield/issues/detail?id=9

Original author: [email protected] (March 10, 2013 00:05:16)

Find an open source ready-to-use solution to export data,
Add it as a plugin

Original issue: http://code.google.com/p/tablefield/issues/detail?id=42

Original author: [email protected] (March 28, 2012 03:17:21)

Add the option to add tables/fields from an existing database
by selecting them with checkboxes, and setting up the types, labels and permissions on the spot.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=23

Original author: [email protected] (March 06, 2013 22:47:15)

param -> format

Original issue: http://code.google.com/p/tablefield/issues/detail?id=31

Original author: [email protected] (March 06, 2013 06:22:12)

Inspired by Wordpress...

Make sure to use cdn.tablefield.com

Original issue: http://code.google.com/p/tablefield/issues/detail?id=28

Original author: [email protected] (March 06, 2013 06:24:57)

Use Bootstrap icon-* classes instead of current GIFs in tfimg folder.
Then dump tfimg folder completely...

Original issue: http://code.google.com/p/tablefield/issues/detail?id=29

Original author: [email protected] (May 19, 2011 16:52:25)

A better way of loading TF Field Types PHP Classes.
Perhaps just including all files from custom/tftypes/tftype.*.php

Original issue: http://code.google.com/p/tablefield/issues/detail?id=3

Original author: [email protected] (March 11, 2013 03:08:01)

I don't think they work, fix them.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=50

Original author: [email protected] (May 19, 2011 19:08:15)

chpass.php: Use text from translation system, instead of the current hard coded Hebrew(?!)

Original issue: http://code.google.com/p/tablefield/issues/detail?id=16

This class should implement support for custom string fields in a single field value.
To allow implementation of the custom "vars" of every field.
Should also support predefined list of vars.
OMG it's like a small TF inside a single field!
Not working yet - need to test.
Future - add the option to add and edit new text parameters on the spot.

Original author: [email protected] (May 19, 2011 16:57:39)

This class should be a general string, which allows implementing JQuery classes!
It should be an addon tftype with several predefined JQuery classes (similar to TFType PHP Classes)

One of them should be the multiple selection tool.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=5

Original author: [email protected] (March 08, 2013 20:45:51)

Have a security expert review the code.

Prevent direct calling of include files.

The entire security system is based on the session variable $_SESSION[$tf['db.pre'].'USER'] -- user group.

Login: Penetration testing, session hacking and hijacking.

SQL query external-values validation - change to "prepare" when available?
It'll be a great idea to use sqlRun() as a 1-line prepare->exec shortcut.
Problem - xkey and similar types supports bare-sql expressions, which can never be a good thing... at least they are checked using sqlbalanced().

sqlbalanced() review.

POST processing abuse in all pages that process POST:
auth tfHandleLogin() , tfadmin.php, tftedit.php, tfinstall.php, tfconfigure.php.

Downloading custom/dbconfig.php would be catastrophic.
Is there a safe way to encrypt it?
Plus review ways to prevent accessing it, allow only includes of this file.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=37

Original author: [email protected] (March 06, 2013 23:32:33)

Discard that predefined number of add-lines nonsense.
Either preload a hundred lines and show them when needed,
or JS create them on the fly.

Can attach to 'update' event of previous line

Original issue: http://code.google.com/p/tablefield/issues/detail?id=32

Original author: [email protected] (March 07, 2013 16:49:29)

Show a large nice preview of HTML and TEXT fields,
Add WYSIWYG option to HTML,
And support optional RTL.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=35

Original author: [email protected] (May 19, 2011 16:59:15)

tfadmin.php: add the option to update a single line using AJAX.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=6

These fields are rarely used...
So use params for it instead.
This way you can add 'prefix', 'postfix', 'prefixnew', etc...

Hmmm... When AJAX layout is ready and form input handling is moved into TfTable class I could actually implement it on the spot, no iframe needed!
But for the time being - iframe it is...

Original author: [email protected] (March 11, 2013 02:42:50)

Allow downloading file from BLOB

Original issue: http://code.google.com/p/tablefield/issues/detail?id=49

Original author: [email protected] (March 10, 2013 12:17:31)

Reproduce:

1. Open edit mode with sub tables
2. change something on sub table and dont save
3. Save something on main table and hit save
4. Hit 'stay in page' (it's the subtable's notice) -- the main form save-changes button disappears

Original issue: http://code.google.com/p/tablefield/issues/detail?id=45

Original author: [email protected] (March 07, 2013 12:57:21)

Detect foreing key constraints and use it to create xkey class.

SELECT
k.table_schema as 'schema',
k.table_name as 'table' ,
k.column_name as 'column',
k.constraint_name as 'constraint_name'
FROM information_schema.KEY_COLUMN_USAGE k
where
k.referenced_column_name is not null

Original issue: http://code.google.com/p/tablefield/issues/detail?id=34

Original author: [email protected] (March 11, 2013 01:34:39)

Instead of passing the htmlform parameter, pass a mandatory table object. All required parameters can be taken from their and from $fetch.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=48

Original author: [email protected] (March 06, 2013 09:25:10)

It is unclear what should be saved in global $tf and what in global $tfconfig...
Moving $tf declaration to tfconfig.php messed some stuff.

In short -- short is better.
Move everything to global $tf and forget about $tfconfig.

Update this wiki afterwards in coordination.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=30

Original author: [email protected] (February 23, 2012 19:40:13)

oria.inc.php fix4sql* functions adds the 'quotes' around the values and fields.
TableField code is based on a very old version of oria.inc.php and it should be updated to use fix4sql* properly - by not adding these quotes by itself to the sql queries.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=20

Original author: [email protected] (February 28, 2012 22:36:46)

A website for this project is already on the go...

http://www.tablefield.com

Original issue: http://code.google.com/p/tablefield/issues/detail?id=21

Original author: [email protected] (May 21, 2011 21:50:14)

= Flow =

Welcome. Enter DB details, Master email, Master TF user/password

Generate initial tables: tbl.info, tbl.users, tbl.trans, tbl.log

Redirect to config utility

= Sub-Tasks =

Create an SQL file for creating initial tables: Done :)

Create the config utility: Issue 1

Original issue: http://code.google.com/p/tablefield/issues/detail?id=17

Original author: [email protected] (March 06, 2013 06:21:23)

Inspired by Wordpress...

Original issue: http://code.google.com/p/tablefield/issues/detail?id=27

Original author: [email protected] (May 19, 2011 16:47:35)

Empty the files inside custom on the deployment package.
Make a configuration utility for these options:

• Editor for header.inc.php and footer.inc.php
• auth.inc.php functions
• RTL or LTR modes (optionally include tfrtl.css stylesheet)
• Language selector
• Link to tfadmin trans editor

Original issue: http://code.google.com/p/tablefield/issues/detail?id=1

Original author: [email protected] (March 07, 2013 22:37:43)

As a service (like wordpress.com)
Every user translates into a unique db.pre
no no no for security and control reasons it's better that each user has their own database.
Maybe offer a free shared Database versus paid unique one?
In any case need to give the service freely to personal use (not academic! they might host a million records. On second thought, there's a record/size limit for the free version)
Need to find a way to limit each database size and resources.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=36

Original author: [email protected] (July 14, 2011 08:33:57)

Add a css for printing the page
<link rel="stylesheet" href="tfimg/print.css" type="text/css" media="print" />
(it should also fix the random FOUC phenomena)

Original issue: http://code.google.com/p/tablefield/issues/detail?id=18

Original author: [email protected] (March 11, 2013 00:40:54)

1. Rename TfTypeTable to TfTable
2. Move enameToID into TfTable class
3. Add var $table into TfType
4. Move these vars from TfType into TfTable: htmlform, curid, rowc

5.... Move entire tfadmin login into TfTable->processpost(), TfTable->displayTable() ........ arrhggghhhhhhhhh!!!

Original issue: http://code.google.com/p/tablefield/issues/detail?id=46

Original author: [email protected] (March 09, 2013 20:01:56)

Display order of fields - drag and drop

Sort - Drag & drop + drag down to "don't sort by" box
(Plus the existing arrows of ASC/DESC ofcourse)

Original issue: http://code.google.com/p/tablefield/issues/detail?id=41

Original author: [email protected] (May 19, 2011 16:55:50)

This class should implement support for custom string fields in a single field value.
To allow implementation of the custom "vars" of every field.
Should also support predefined list of vars.
OMG it's like a small TF inside a single field!

Original issue: http://code.google.com/p/tablefield/issues/detail?id=4

Original author: [email protected] (March 06, 2012 02:10:03)

To the installation wizard add the option to download ready-to-use database templates such as 'dating website','lectures management','volunteers management' and so on.

Add these templates both to be selected from the wizard, and available to download from http://tablefield.com/templates

The wizard should connect to tablefield website to get the list of templates and read the specific template.

The templates are actually just SQL export file with CREATE TABLEs and INSERTs.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=22

Original author: [email protected] (March 04, 2013 03:51:24)

...By normal editing of tf_info table.

Complete issue 4 to allow editing of params

Add fictive class types that can actually create or alter table and field names in DB + validation

Original issue: http://code.google.com/p/tablefield/issues/detail?id=25

Original author: [email protected] (March 09, 2013 05:56:48)

Add more search options:

"NOT" checkbox

Exact ('=')
Exact Case Insensitive ('LIKE' - only for textual fields)
Starting with
Ending with
Contains
Larger Than
Smaller Than

Original issue: http://code.google.com/p/tablefield/issues/detail?id=40

Original author: [email protected] (May 19, 2011 18:23:27)

Make all configuration keys in "context.option" format (ie "ui.rtl"):

• Move DB values out of Array and into cohesive "db.user" format
• Move $DEBUG global param to "notifications.debug" config option
• Move table names to "tbl.info" format
• Move login screen options to "login.pagein" format
• Move "imgdir" to "url.img"
• Move "refprefix" to "url.rel" as relative location marker for the site root
• Move "dirprefix" to "path.rel" as relative location marker for the site root
• Add "url.base" and "path.base" as the base path for urls and inner paths (will it replace "url.ref"/"path.ref" eventually?)

On the Configuration Utility:

1. Add a $tfconfig_desc array with short description of every option
2. Add a $tfconfig_defaults array with default values (when applicable) so it could highlight the non-default ones.

• Note: The errors strings should be handled differently and using the regular translation utility, with the correct context.
  Another issue will be opened for it.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=15

Original author: [email protected] (May 19, 2011 17:18:18)

Make a tfimg/tfrtl.css file
Add $tfconfig['ui.rtl'] Boolean option. Default false.
Optionally include that stylesheet when the rtl option is on.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=8

Original author: [email protected] (May 19, 2011 17:53:21)

Debug mode indicator -
Change global $DEBUG to global $tfconfig['debug']

Original issue: http://code.google.com/p/tablefield/issues/detail?id=14

Original author: [email protected] (May 19, 2011 17:29:00)

1. Change the Eng/Heb language codes to some standard language codes.
2. Make a TFTypeLanguages suitable for selecting languages, and implement it in the translations table.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=11

Original author: [email protected] (May 19, 2011 17:51:50)

Drupal style translations are the best.
Whole sentences, with context and vars.

Also applies to Issue #12

Original issue: http://code.google.com/p/tablefield/issues/detail?id=13

Original author: [email protected] (March 09, 2013 05:43:37)

Move 'indexed' to 'Default sort by'
Move 'Display order of fields' and 'Searchable' to 'Labels and ename'

Strict ename to a valid one with [a-zA-Z0-9_]

Redesign (make it simple and intuitive) 'permissions screen' - use TfTypeenums so one could select/deselect groups.
Add borders here to make it more easy to see.
If it works ok - drop the mass-fill thingie.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=39

Original author: [email protected] (March 10, 2013 03:53:42)

1. Do not touch TfTypeenum or TfTypeenums - they are ok as is. Just add some UI widget to them from params.
2. Set up a good basic list class
   With populate_values function, and optgroups
   Supports either simple list of values or sub value=display%20name pairs (use %2c to put a comma ,)
3. Set up a good basic multi-list class
   Remember to apply 'okmax' when calling jquery extension.
4. Set up a good suggested list class
5. Set up a good suggested multi-list class

Use only <select>
Add class=grid or class=whatever to change the select list later with jQuery, for example:

$('select.multiselect').multiselect();
$('select.multipleselectbox').multipleSelectBox();
$('select.selectlist').selectList();
$('select.selectable').each(...change to li?...).selectable();
$('select.grid').selectable();

Recommended:
http://plugins.jquery.com/jQueryMultipleSelectBox/
http://dl.dropbox.com/u/8316573/index.html#

http://www.erichynds.com/examples/jquery-ui-multiselect-widget/demos/#filter

http://jqueryui.com/selectable/#display-grid

http://odyniec.net/projects/selectlist/examples.html

Original issue: http://code.google.com/p/tablefield/issues/detail?id=44

Original author: [email protected] (March 04, 2013 03:46:28)

Implement a JQuery spreadsheet plugin as one of the display options.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=24

Original author: [email protected] (May 19, 2011 17:25:41)

Documentation for End Users who will eventually need to update the database.
It should be a DOC (or RTF) that can be update by the administrator.

Also include a more thorough documentation which includes permission editing, for the webmaster.

Did you get the difference between the webmaster and the admin?
The admin is a kind of End User of this system.
It may be the same person, but in many cases it won't.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=10

Original author: [email protected] (May 19, 2011 16:49:09)

Design a new logo for the TableField project
And a favicon.
And also short TF versions.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=2

Original author: [email protected] (September 06, 2011 19:00:33)

The authorization system (auth.inc.php) needs to be reviewed...
Should support the following features:

• anonymous login - tfconfig setting option auth.anonymous: when true, allows users to connect as the anonymous user without a password.
• customized login functions should be somehow supported from custom/auth.inc.php.
  The auth.php file should automatically check for user connected.
  The auth.inc.php file should include all functions that auth.php is using (to allow custom files to rewrite these functions or use them in other places).

Original issue: http://code.google.com/p/tablefield/issues/detail?id=19

Original author: [email protected] (March 09, 2013 03:58:40)

jQueryUI and Bootstrap themes are not working well together...
Why oh why?
oh well, it's not that important.

For the time being I've cancelled the theme-select option all together.

Original issue: http://code.google.com/p/tablefield/issues/detail?id=38