added e-mail to people database, made it so I can assign tasks to myself

diff --git a/index.php b/index.php
index 46a27e3..91c24ee 100644 (file)
--- a/index.php
+++ b/index.php
@@ -53,7 +53,7 @@ function _index_main() {
        if(logged_in_as_contractor()) {
                tem_show('needs_attention_header');
                task_summary('needs_approval', 'where state=%i order by id desc', TASK_WORKING);
        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);
                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);

diff --git a/people.sql b/people.sql
new file mode 100644 (file)
index 0000000..4c38c44
--- /dev/null
+++ b/people.sql
@@ -0,0 +1,11 @@
+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
+);