Defining db tables and fields
From Aikiframework wiki
Aikiframework uses an array to process db tables and create forms for inserting and editing.
Aiki db arrays
"tablename" => "aiki_users"
"pkey" => "id"
"events" => "upload_success:assets/lib/update_num_uploads.php?user=[user_name]"
"send_email" => "webmaster@aikiframework.org|[sender_email]|[email_topic]|[message]"
"permission" => "user_name|SystemGOD"
"staticselect" => "publish_cond|SystemGOD:Publish Cond:custome:Yes>1&No>0&"
"selection" => "usergroup|SystemGOD:User Group:aiki_users_groups:id:name"
"selection" => "usergroup|SystemGOD:User Group:aiki_users_groups:id:name:where id = (1)"
"textinput" => "title|SystemGOD|true:Article Title"
"textinput" => "full_path:Full Image Path:full_path"
"textinput" => "email_address:Email Address:email"
imagenoupload
image
unique_textinput
password
verify_password
textblock
"bigtextblock" => "text|SystemGOD:Comment"
bigwikiblock
upload
imagefolderupload
datetime
hidden
textinput_if_valid -> email - url
autofiled
"autofiled" => "time:Upload date:uploaddate"
static_input
inserting in more than one table:
lets say we have table1 and table2
table1:id, name1
table2: id, name2
if we want to insert the value of table1.name1 in table2.name2 from the form of tabl21: add a hidden field to the form of table1:
name2->table2|SystemGOD:Display Name:value:[name1]
other possible options:
name2->table2|SystemGOD:Display Name:value:insertedby_username
name2->table2|SystemGOD:Display Name:value:this_pkey
name2->table2|SystemGOD:Display Name:value:(!(1)!)
