if(logged_in_as_contractor()) {
tem_show('needs_attention_header');
task_summary('needs_approval', 'where state=%i order by id desc', TASK_WORKING);
- task_summary('needs_fixing', 'where state=%i || state=%i order by id desc', TASK_NEEDS_QUOTE, TASK_BUG);
+ task_summary('needs_fixing', 'where (state=%i || state=%i) || (client_id=1 && state<%i) order by id desc', TASK_NEEDS_QUOTE, TASK_BUG, TASK_QUEUED);
task_summary('finished_unpaid', 'where state=%i && paid = 0 order by id desc', TASK_FINISHED);
task_summary('finished_paid', 'where state=%i && paid = 1 order by id desc', TASK_FINISHED);
task_summary('queue', 'where state=%i order by client_id, ord', TASK_QUEUED);
--- /dev/null
+drop table if exists people;
+create table people (
+ id int unique auto_increment,
+ username varchar(20) not null default "",
+ password char(35) not null default "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:xx",
+ email varchar(40) not null default "",
+ name varchar(200) not null default "",
+ privs int not null default 0,
+ balance decimal(10,2) not null default 0.0,
+ tiny_agreement int not null default 0
+);