|
|
Project List
No Database Selected SELECT *,CASE
WHEN maxbudget>4000 AND 4000>0 THEN 5
WHEN minbudget>4000 AND 4000>0 THEN 5
WHEN maxbudget>2000 AND 4000>0 AND 2000>0 THEN 4
WHEN minbudget>2000 AND 2000>0 THEN 4
WHEN maxbudget>1000 AND 2000>0 AND 1000>0 THEN 3
WHEN minbudget>1000 AND 1000>0 THEN 3
WHEN maxbudget>500 AND 1000>0 AND 500>0 THEN 2
WHEN minbudget>500 AND 500>0 THEN 2
ELSE 1
END as mlevel,UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) AS timeleft
FROM radlance_projects
WHERE type='Open' AND sell=0 AND job=0 AND UNIX_TIMESTAMP(dateexpire)-UNIX_TIMESTAMP(NOW()) > 0
|