From: Jason Woofenden <jason283@herkamire.com>
Date: Thu, 13 Nov 2008 23:19:19 +0000 (-0500)
Subject: added e-mail to people database, made it so I can assign tasks to myself
X-Git-Url: https://jasonwoof.com/gitweb/?p=contractor-progress.git;a=commitdiff_plain;h=cd31f0e08af5e737de8d25a1c27f62d811345bc2

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
--- 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);
-		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);
diff --git a/people.sql b/people.sql
new file mode 100644
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
+);