Issues » List

Issues

ID	Title	Project	Target Version	Status	Last Updated	Manage
#15	Ads in subcategories not searched	PHP Classifieds	7.6	Implemented	20/12/2009	View
#14	And a lot more fixes / improvements	PHP Classifieds	7.6	Implemented	01/09/2009	View
#13	Added features to tell admin about possible problems	PHP Classifieds	7.6	Implemented	01/09/2009	View
#12	Ioncube license encryption	PHP Classifieds	7.6	Implemented	01/09/2009	View
#11	Membership with ad limit	PHP Classifieds	7.6	Implemented	01/09/2009	View
#10	New bannerprogram w. Flash	PHP Classifieds	7.6	Implemented	01/06/2009	View
#9	Added option to add Ads from Admin Area	PHP Classifieds	7.6	Implemented	26/05/2009	View
#8	Added option to add users from Admin Area	PHP Classifieds	7.6	Implemented	21/05/2009	View
#7	Content Management System	PHP Classifieds	7.6	Implemented	21/05/2009	View
#6	Email notifications after approval only	PHP Classifieds	7.6	Implemented	31/05/2009	View
« Previous 123 Next »

Debug

Query History (15 Queries)

SELECT id, category, name, value FROM arctic_config
SELECT p.id, p.tag, pt.name AS type_name FROM arctic_permission p JOIN arctic_permission_type pt ON pt.id = p.type_id WHERE p.default_guest = 1
SELECT id, manager_id, title, description, private, date_added FROM arctic_project ORDER BY title
SELECT id, field_id, model, name, language_category, language_phrase, title, enabled, display_order FROM arctic_issue_column WHERE enabled = 1 ORDER BY display_order
SELECT id, user_id, built_in, title, options FROM arctic_filter WHERE user_id = 0
SELECT COUNT(i.id) AS count FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned WHERE i.project_id IN (1) AND s.hide = 0
SELECT i.id, i.title, i.date_added, i.date_updated, p.id AS project_id, p.title AS project_title, s.title AS status_title, s.prefix AS status_prefix, s.suffix AS status_suffix, s.open AS status_open, tv.number AS version_number, uadd.id AS user_added_id, uadd.username AS user_added_username, uass.id AS user_assigned_id, uass.username AS user_assigned_username FROM arctic_issue i JOIN arctic_project p ON p.id = i.project_id JOIN arctic_issue_status s ON s.id = i.status_id LEFT JOIN arctic_user uadd ON uadd.id = i.user_id_added LEFT JOIN arctic_user uass ON uass.id = i.user_id_assigned LEFT JOIN arctic_project_version tv ON tv.id = i.version_id WHERE ((i.private = 0 AND i.project_id IN (1)) OR (i.private = 1 AND i.project_id IN (0))) AND s.hide = 0 ORDER BY i.id DESC LIMIT 10,10
SELECT v.id, v.issue_id, v.field_id, v.value, f.type FROM arctic_custom_field_value v RIGHT JOIN arctic_custom_field f ON v.field_id = f.id AND v.issue_id IN (15, 14, 13, 12, 11, 10, 9, 8, 7, 6)
SELECT p.id, p.title FROM arctic_project p JOIN arctic_issue i ON i.project_id = p.id WHERE p.id IN (1) ORDER BY p.title
SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_added ORDER BY u.username
SELECT u.id, u.username FROM arctic_user u JOIN arctic_issue i ON u.id = i.user_id_assigned ORDER BY u.username
SELECT s.id, s.title, s.open FROM arctic_issue_status s JOIN arctic_issue i ON s.id = i.status_id ORDER BY s.title
SELECT DISTINCT s.open FROM arctic_issue_status s JOIN arctic_issue i ON i.status_id = s.id
SELECT v.id, v.number, v.project_id FROM arctic_project_version v JOIN arctic_issue i ON v.id = i.version_id WHERE v.project_id IN (1) ORDER BY v.number
SELECT id, project_id, type, title, default_value, display_order, options, required, filters FROM arctic_custom_field WHERE type IN ("Checkbox", "Dropdown") AND filters = 1 ORDER BY display_order

Statistics

Script Execution Time: 0.035 seconds

Project:	Created By:	Assigned To:
Status:	Open/Closed:	Target Version:

New Filter:
Existing Filters: