Hi, Steve
This is the internal tool and has no access outside. I can give you the sample app I downloaded from your website and see if that would help:
conf.ini:
- Code: Select all
title="profiles_demo"
[_database]
host = "localhost"
user = "db_user"
password = "db_password"
name = "profiles_demo"
[_tables]
people = "People"
posts = "Posts"
people_categories = "Categories"
[_prefs]
;disable_ajax_record_details=0
tables/people/fields.ini:
- Code: Select all
[fieldgroup:surname]
label="Surname"
order = 1
section:order = 1
[fieldgroup:givename]
label="Given Name"
order = 2
section:order = 2
[first_name]
widget:label = "Given Name"
widget:description = "Please enter your first name"
validators:required = 1
validators:required:message = "Please enter your given name"
group = givename
[last_name]
widget:label = "Surname"
widget:description = "Please enter your last name"
validators:required = 1
validators:required:message = "Please enter your surname"
group = surname
[bio]
widget:type=htmlarea
[category]
widget:type=select
vocabulary=categories
tables/people/valuelists.ini:
- Code: Select all
[categories]
__sql__ = "select user_entry_id, user_name from users order by user_name"
;1=Mail men
;2=politicians
;3=Tech guys
tables/people/relationships.ini:
- Code: Select all
[posts]
posts.owner_id = "$person_id"
tables/posts/fields.ini:
- Code: Select all
[body]
widget:type=htmlarea
[owner_id]
widget:label = "Poster"
widget:type=select
vocabulary=owners
tables/posts/valuelists.ini:
- Code: Select all
[owners]
__sql__ = "select posts.owner_id, CONCAT(people.first_name, ' ', people.last_name) as owner from posts, people where posts.owner_id = people.person_id"
tables/posts/relationships.ini:
- Code: Select all
[people]
people.person_id = "$owner_id"
The database structures look like the following:
- Code: Select all
CREATE TABLE IF NOT EXISTS `people` (
`person_id` int(10) NOT NULL AUTO_INCREMENT,
`first_name` varchar(64) NOT NULL,
`last_name` varchar(64) NOT NULL,
`bio` text NOT NULL,
`category` int(10) NOT NULL,
PRIMARY KEY (`person_id`)
);
CREATE TABLE IF NOT EXISTS `posts` (
`post_id` int(10) NOT NULL AUTO_INCREMENT,
`body` text NOT NULL,
`owner_id` int(10) NOT NULL,
PRIMARY KEY (`post_id`)
);
CREATE TABLE IF NOT EXISTS `people_categories` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
PRIMARY KEY (`id`)
);
The attached is the screenshot for the view of the entry in people table.
