]>
src.bluestatic.org Git - bugdar.git/blob - includes/functions_datastore.php
2 /*=====================================================================*\
3 || ################################################################### ||
4 || # [#]app[#] [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # All parts of this file are ©2003-[#]year[#] Iris Studios, Inc. No # ||
7 || # part of this file may be reproduced in any way: part or whole. # ||
8 || # --------------------------------------------------------------- # ||
9 || # ©2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 // ###################### Start build_languages ######################
14 function build_languages()
16 global $DB_sql, $bugsys;
18 $languages = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "language");
19 while ($language = $DB_sql->fetch_array($languages))
21 $tempstore["$language[languageid]"] = $language;
25 ### replacing the language cache ###
26 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
27 VALUES ('language', '" . addslasheslike(serialize($tempstore)) . "')"
30 $bugsys->datastore
['language'] = $tempstore;
33 // ####################### Start build_settings ######################
34 function build_settings()
36 global $DB_sql, $bugsys;
38 $settings = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "setting");
39 while ($setting = $DB_sql->fetch_array($settings))
41 $options["$setting[varname]"] = $setting['value'];
45 ### replacing the setting cache ###
46 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
47 VALUES ('setting', '" . addslasheslike(serialize($options)) . "')"
50 $bugsys->datastore
['setting'] = $options;
53 // ###################### Start build_usergroups #####################
54 function build_usergroups()
56 global $DB_sql, $bugsys;
58 $usergroups = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "usergroup");
59 while ($usergroup = $DB_sql->fetch_array($usergroups))
61 $groups["$usergroup[usergroupid]"] = $usergroup;
65 ### replacing usergroup cache ###
66 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
67 VALUES ('usergroup', '" . addslasheslike(serialize($groups)) . "')"
70 $bugsys->datastore
['usergroup'] = $groups;
73 // ####################### Start build_statuses ######################
74 function build_statuses()
76 global $DB_sql, $bugsys;
78 $statuses = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "status ORDER BY displayorder ASC");
79 while ($status = $DB_sql->fetch_array($statuses))
81 $tempstore["$status[statusid]"] = $status;
85 ### replacing status cache ###
86 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
87 VALUES ('status', '" . addslasheslike(serialize($tempstore)) . "')"
90 $bugsys->datastore
['status'] = $tempstore;
93 // ###################### Start build_severities #####################
94 function build_severities()
96 global $DB_sql, $bugsys;
98 $severities = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "severity ORDER BY displayorder ASC");
99 while ($severity = $DB_sql->fetch_array($severities))
101 $tempstore["$severity[severityid]"] = $severity;
105 ### replacing severity cache ###
106 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
107 VALUES ('severity', '" . addslasheslike(serialize($tempstore)) . "')"
110 $bugsys->datastore
['severity'] = $tempstore;
113 // ###################### Start build_priorities #####################
114 function build_priorities()
116 global $DB_sql, $bugsys;
118 $priorities = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "priority ORDER BY displayorder ASC");
119 while ($priority = $DB_sql->fetch_array($priorities))
121 $tempstore["$priority[priorityid]"] = $priority;
125 ### replacing priority cache ###
126 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
127 VALUES ('priority', '" . addslasheslike(serialize($tempstore)) . "')"
130 $bugsys->datastore
['priority'] = $tempstore;
133 // ###################### Start build_assignedto #####################
134 function build_assignedto()
136 global $DB_sql, $bugsys;
138 $users = $DB_sql->query("
139 SELECT user.email, user.displayname, user.userid, user.showemail
140 FROM " . TABLE_PREFIX
. "user AS user
141 LEFT JOIN " . TABLE_PREFIX
. "usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid)
142 WHERE (usergroup.permissions & " . CANBEASSIGNEDTO
. ")"
144 while ($user = $DB_sql->fetch_array($users))
146 fetch_user_display_name($user);
147 $devs["$user[userid]"] = $user;
151 ### replacing developer / assign to cache ###
152 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
153 VALUES ('assignto', '" . addslasheslike(serialize($devs)) . "')"
156 $bugsys->datastore
['assignto'] = $devs;
159 // ##################### Start build_resolutions #####################
160 function build_resolutions()
162 global $DB_sql, $bugsys;
164 $resolutions = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "resolution ORDER BY displayorder ASC");
165 while ($resolution = $DB_sql->fetch_array($resolutions))
167 $tempstore["$resolution[resolutionid]"] = $resolution;
171 ### replacing resolution cache ###
172 REPLACE INTO " . TABLE_PREFIX
. "datastore (title, data)
173 VALUES ('resolution', '" . addslasheslike(serialize($tempstore)) . "')"
176 $bugsys->datastore
['resolution'] = $tempstore;
179 /*=====================================================================*\
180 || ###################################################################
183 || ###################################################################
184 \*=====================================================================*/