includes/functions.php

   1 <?php
   2 /*=====================================================================*\
   3 || ################################################################### ||
   4 || # BugStrike [#]version[#]
   5 || # --------------------------------------------------------------- # ||
   6 || # Copyright ©2002-[#]year[#] by Iris Studios, Inc. All Rights Reserved. # ||
   7 || # This file may not be reproduced in any way without permission.  # ||
   8 || # --------------------------------------------------------------- # ||
   9 || # User License Agreement at http://www.iris-studios.com/license/  # ||
  10 || ################################################################### ||
  11 \*=====================================================================*/
  12
  13 // ################## Start fetch_user_display_name ##################
  14 // preps a dispaly name if one isn't set
  15 // should be able to be removed by the final version as registration should set this
  16 function fetch_user_display_name(&$userinfo)
  17 {
  18         if (!$userinfo['displayname'])
  19         {
  20                 $userinfo['displayname'] = ucwords(trim(str_replace(array('@', '.com', '.net', '.edu', '.org', '.info', '.biz'), ' ', $userinfo['email'])));
  21         }
  22 }
  23
  24 // ################## Start construct_option_select ##################
  25 // creates a <select> menu from an array
  26 // key vars are used when you need to get data out of the $label array
  27 function construct_option_select($name, $array, $selected = 0, $valuekey = '', $labelkey = '', $includenil = false)
  28 {
  29         // if we're not working on a boolean false, we use it for the value (allows -1 and 0)
  30         if ($includenil !== false)
  31         {
  32                 $opts[] = '<option value="' . $includenil . '"' . ((!$selected) ? ' selected="selected"' : '') . '>Not Selected</option>';
  33         }
  34         foreach ($array AS $value => $label)
  35         {
  36                 $opts[] = '<option value="' . (($valuekey) ? $label["$valuekey"] : $value) . '"' . (($selected == (($valuekey) ? $label["$valuekey"] : $value)) ? ' selected="selected"' : '') . '>' . (($labelkey) ? $label["$labelkey"] : $label) . '</option>';
  37         }
  38         return '<select name="' . $name . '">' . implode("\n\t", $opts) . "\r</select>";
  39 }
  40
  41 // ################### Start construct_user_display ##################
  42 // $userinfo needs userid, email, displayname, and showemail
  43 function construct_user_display($userinfo, $userid = true)
  44 {
  45         fetch_user_display_name($userinfo);
  46         return "$userinfo[displayname]" . (($userinfo['showemail']) ? " &lt;$userinfo[email]&gt;" : '') . (($userid) ? " (userid: $userinfo[userid])" : '');
  47 }
  48
  49 // ######################## Start can_perform ########################
  50 // short-hand for bitwise &
  51 function can_perform($bitmask, $userinfo = null)
  52 {
  53         global $_PERMISSION;
  54
  55         if (!isset($_PERMISSION["$bitmask"]))
  56         {
  57                 trigger_error('Invalid bitmask "' . $bitmask . '" specified for can_perform() [includes/functions.php]', E_USER_WARNING);
  58         }
  59
  60         if (!$userinfo)
  61         {
  62                 global $bugsys;
  63                 return ($bugsys->userinfo['permissions'] & $_PERMISSION["$bitmask"]);
  64         }
  65         return ($userinfo['permissions'] & $_PERMISSION["bitmask"]);
  66 }
  67
  68 // #################### Start construct_pcv_select ###################
  69 // constructs a product/component/version select with one go :-)
  70 // NB: need to make sure we have the option to turn off just p/c selection without v
  71 function construct_pcv_select($select = '', $prefix = '--')
  72 {
  73         global $bugsys;
  74         static $HTML;
  75
  76         if ($HTML)
  77         {
  78                 return $HTML;
  79         }
  80
  81
  82         $selected = ' selected="selected"';
  83
  84         $products_fetch = $bugsys->db->query("SELECT * FROM " . TABLE_PREFIX . "product ORDER BY displayorder ASC");
  85         while ($product = $bugsys->db->fetch_array($products_fetch))
  86         {
  87                 if ($product['componentmother'])
  88                 {
  89                         $components["$product[componentmother]"]["$product[productid]"] = $product;
  90                 }
  91                 else
  92                 {
  93                         $products["$product[productid]"] = $product;
  94                 }
  95         }
  96
  97         $versions_fetch = $bugsys->db->query("SELECT * FROM " . TABLE_PREFIX . "version ORDER BY displayorder");
  98         while ($version = $bugsys->db->fetch_array($versions_fetch))
  99         {
 100                 $versions["$version[productid]"]["$version[versionid]"] = $version;
 101         }
 102
 103         foreach ($products AS $product)
 104         {
 105                 $row['prefix'] = '';
 106                 $valuepfx = "p$product[productid]";
 107                 $row['value'] = "{$valuepfx}c0v0";
 108                 $row['title'] = $product['title'];
 109                 $row['optgroup'] = true;
 110                 $row['description'] = $product['description'];
 111                 $show['input'] = false;
 112                 $begin = true;
 113                 eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 114                 $HTML .= construct_pcv_select_global_version($product['productid'], 0, $versions, $prefix, $select);
 115                 if (is_array($versions["$product[productid]"]))
 116                 {
 117                         foreach ($versions["$product[productid]"] AS $version)
 118                         {
 119                                 $row['prefix'] = $prefix . $prefix . ' ';
 120                                 $row['value'] = "{$valuepfx}c0v$version[versionid]";
 121                                 $row['title'] = $version['version'];
 122                                 $row['optgroup'] = false;
 123                                 $row['selected'] = (($select == $row['value']) ? $selected : '');
 124                                 $row['description'] = '';
 125                                 $show['input'] = true;
 126                                 eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 127                         }
 128                 }
 129
 130                 if (is_array($components["$product[productid]"]))
 131                 {
 132                         foreach ($components["$product[productid]"] AS $component)
 133                         {
 134                                 $row['prefix'] = $prefix . ' ';
 135                                 $valuepfx .= "c$component[productid]";
 136                                 $row['value'] = "{$valuepfx}v0";
 137                                 $row['selected'] = (($select == $row['value']) ? $selected : '');
 138                                 $row['title'] = $component['title'];
 139                                 $row['depth'] = 1;
 140                                 $row['optgroup'] = true;
 141                                 $begin = true;
 142                                 $row['description'] = $component['description'];
 143                                 $show['input'] = false;
 144                                 eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 145                                 $HTML .= construct_pcv_select_global_version($component['componentmother'], $component['productid'], $versions, $prefix, $select);
 146                                 if (is_array($versions["$component[productid]"]))
 147                                 {
 148                                         foreach ($versions["$component[productid]"] AS $version)
 149                                         {
 150                                                 $show['input'] = true;
 151                                                 $row['prefix'] = $prefix . $prefix . ' ';
 152                                                 $row['value'] = "{$valuepfx}v$version[versionid]";
 153                                                 $row['selected'] = (($select == $row['value']) ? $selected : '');
 154                                                 $row['title'] = $version['version'];
 155                                                 $row['optgroup'] = false;
 156                                                 $row['description'] = '';
 157                                                 eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 158                                         }
 159                                 }
 160                         }
 161                         $row['optgroup'] = true;
 162                         $begin = false;
 163                         eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 164                 }
 165                 $row['optgroup'] = true;
 166                 $begin = false;
 167                 eval('$HTML .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 168         }
 169
 170         return $HTML;
 171 }
 172
 173 // ############ Start construct_pcv_select_global_version ############
 174 function construct_pcv_select_global_version($product = 0, $component = 0, $versions = array(), $prefix = '', $select = '')
 175 {
 176         global $bugsys;
 177         if (is_array($versions['0']))
 178         {
 179                 foreach ($versions['0'] AS $version)
 180                 {
 181                         $row['prefix'] = $prefix . $prefix. ' ';
 182                         $row['typeselect'] = $type;
 183                         $row['value'] = "p{$product}c{$component}v$version[versionid]";
 184                         $row['selected'] = (($select == $row['value']) ? ' selected="selected"' : '');
 185                         $row['title'] = $version['version'];
 186                         $row['optgroup'] = false;
 187                         $row['description'] = '';
 188                         $show['input'] = true;
 189                         eval('$global_versions_html .= "' . $bugsys->template->fetch('pcv_select_row') . '";');
 190                 }
 191         }
 192         return $global_versions_html;
 193 }
 194
 195 // ###################### Start parse_pcv_select #####################
 196 function parse_pcv_select($input, $validate = false)
 197 {
 198         global $bugsys;
 199
 200         $input = trim($input);
 201
 202         /*
 203         yummy regex tests....
 204         var_dump(preg_match('#^p(\d+?)c(\d+?)v(\d+?)$#', $input));
 205         var_dump(preg_match('#^p(\d.+?)c(\d.+?)v(\d.+?)$#', $input));
 206         var_dump(preg_match('#^p([0-9]+?)c([0-9]+?)v([0-9]+?)$#', $input));
 207         var_dump(preg_match('#^p([0-9].+?)c([0-9].+?)v([0-9].+?)$#', $input));
 208         */
 209
 210         if (preg_match('#^p(\d+?)c(\d+?)v(\d+?)$#', $input) == 0)
 211         {
 212                 return false;
 213         }
 214
 215         $trio = preg_split('#(p|c|v)#i', $input, -1, PREG_SPLIT_NO_EMPTY);
 216         if (count($trio) != 3)
 217         {
 218                 return false;
 219         }
 220
 221         $pcv = array('product' => intval($trio[0]), 'component' => intval($trio[1]), 'version' => intval($trio[2]));
 222
 223         if (!$validate)
 224         {
 225                 return $return;
 226         }
 227         else
 228         {
 229                 // -------------------------------------------------------------------
 230                 // pcv validation
 231                 $product = $bugsys->datastore['product'][ $pcv['product'] ];
 232                 if (!$product)
 233                 {
 234                         return false;
 235                 }
 236                 $version = $bugsys->datastore['version'][ $pcv['version'] ];
 237                 if (!$version)
 238                 {
 239                         return false;
 240                 }
 241                 // no component
 242                 if ($pcv['component'] == 0)
 243                 {
 244                         // not global version and version.productid != product.productid
 245                         if ($version['productid'] != 0 AND $version['productid'] != $product['productid'])
 246                         {
 247                                 return false;
 248                         }
 249                 }
 250                 // using a component
 251                 else
 252                 {
 253                         $component = $bugsys->datastore['product'][ $pcv['component'] ];
 254                         // component has the right mother
 255                         if ($component['componentmother'] == $product['productid'])
 256                         {
 257                                 // version.productid != {component.productid | product.productid}
 258                                 if (($version['productid'] != $component['productid'] AND $version['productid'] != $product['productid']) AND $version['productid'] != 0)
 259                                 {
 260                                         return false;
 261                                 }
 262                         }
 263                         else
 264                         {
 265                                 return false;
 266                         }
 267                 }
 268
 269                 return $pcv;
 270         }
 271 }
 272
 273 // ################# Start construct_datastore_select ################
 274 // loops through the specified datastore to create <select>s
 275 function construct_datastore_select($datastore, $labelname, $valuename, $selectedvalue = 0, $includeblank = false, $adminmode = false)
 276 {
 277         global $bugsys;
 278
 279         if ($adminmode)
 280         {
 281                 global $admin;
 282         }
 283
 284         $select = '';
 285
 286         if ($includeblank)
 287         {
 288                 if ($adminmode)
 289                 {
 290                         $admin->list_item('', '', ((!$selectedvalue) ? true : false));
 291                 }
 292                 else
 293                 {
 294                         $label = '';
 295                         $value = '';
 296                         $selected = ((!$selectedvalue) ? true : false);
 297                         eval('$select .= "' . $bugsys->template->fetch('selectoption') . '";');
 298                 }
 299         }
 300
 301         foreach ($bugsys->datastore["$datastore"] AS $item)
 302         {
 303                 $label = $item["$labelname"];
 304                 $value = $item["$valuename"];
 305                 $selected = (($value == $selectedvalue) ? true : false);
 306
 307                 if ($adminmode)
 308                 {
 309                         $admin->list_item($label, $value, $selected);
 310                 }
 311                 else
 312                 {
 313                         eval('$select .= "' . $bugsys->template->fetch('selectoption') . '";');
 314                 }
 315         }
 316
 317         if (!$adminmode)
 318         {
 319                 return $select;
 320         }
 321 }
 322
 323 // ################## Start construct_custom_fields ##################
 324 function construct_custom_fields($bug = array())
 325 {
 326         global $bugsys;
 327         static $fields;
 328
 329         if (!is_array($fields))
 330         {
 331                 $fields = array();
 332                 $fields_fetch = $bugsys->db->query("
 333                         SELECT bugfield.*, permission.mask
 334                         FROM " . TABLE_PREFIX . "bugfield AS bugfield
 335                         LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
 336                                 ON (bugfield.fieldid = permission.fieldid)
 337                         WHERE (permission.mask = 2 OR permission.mask = 1)
 338                         AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
 339                 );
 340                 while ($field = $bugsys->db->fetch_array($fields_fetch))
 341                 {
 342                         $fields["$field[fieldid]"] = $field;
 343                 }
 344         }
 345
 346         $fieldvalues = $bugsys->db->query_first("SELECT * FROM " . TABLE_PREFIX . "bugvaluefill WHERE bugid = $bug[bugid]");
 347
 348         $fieldbits = '';
 349
 350         foreach ($fields AS $field)
 351         {
 352                 if (!is_null($bug["field$field[fieldid]"]))
 353                 {
 354                         $bugsys->debug("not null: $field[fieldid]");
 355                         $value = $bug["field$field[fieldid]"];
 356                 }
 357                 else
 358                 {
 359                         $value = $field['defaultvalue'];
 360                 }
 361
 362                 if ($field['mask'] == 2)
 363                 {
 364                         switch ($field['type'])
 365                         {
 366                                 case 'input_text':
 367                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_text') . '";');
 368                                 break;
 369
 370                                 case 'input_checkbox':
 371                                         $selected = (($value) ? ' checked="checked"' : '');
 372                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_checkbox') . '";');
 373                                 break;
 374
 375                                 case 'select_single':
 376                                         $selects = unserialize($field['selects']);
 377                                         $value = trim($value);
 378
 379                                         $options = '';
 380
 381                                         $id = -1;
 382                                         $select = '';
 383                                         if (!$field['usedefault'] AND !trim($value))
 384                                         {
 385                                                 $selected = ' selected="selected"';
 386                                         }
 387                                         else
 388                                         {
 389                                                 $selected = '';
 390                                         }
 391                                         eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
 392
 393                                         foreach ($selects AS $id => $select)
 394                                         {
 395                                                 $selected = '';
 396                                                 $select = stripslashes(trim($select));
 397                                                 if ($select == $value)
 398                                                 {
 399                                                         $selected = ' selected="selected"';
 400                                                 }
 401                                                 else if ($field['usedefault'] AND $id == 0)
 402                                                 {
 403                                                         $selected = ' selected="selected"';
 404                                                 }
 405                                                 eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
 406                                         }
 407                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_select_single') . '";');
 408                                 break;
 409                         }
 410                 }
 411                 else
 412                 {
 413                         $bugsys->debug('mask 1 processing');
 414                         if (is_null($fieldvalues["field$field[fieldid]"]))
 415                         {
 416                                 $bugsys->debug("is null: $field[fieldid]");
 417                                 if ($field['type'] == 'select_single')
 418                                 {
 419                                         if ($field['usedefault'])
 420                                         {
 421                                                 $temp = unserialize($field['selects']);
 422                                                 $value = trim($temp[0]);
 423                                         }
 424                                         else
 425                                         {
 426                                                 $value = $fieldvalues["field$field[fieldid]"];
 427                                         }
 428                                 }
 429                                 else
 430                                 {
 431                                         $value = $field['defaultvalue'];
 432                                 }
 433                         }
 434                         else
 435                         {
 436                                 $value = $fieldvalues["field$field[fieldid]"];
 437                         }
 438
 439                         if ($field['type'] == 'input_checkbox')
 440                         {
 441                                 $value = (($value) ? 'True' : 'False');
 442                         }
 443                         $field['value'] = $value;
 444                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_static_text') . '";');
 445                 }
 446                 $fieldbits[] = $tempfield;
 447         }
 448
 449         return $fieldbits;
 450 }
 451
 452 // ################### Start process_custom_fields ###################
 453 function process_custom_fields($bugid, $inputdata = array())
 454 {
 455         global $bugsys;
 456
 457         if (!$inputdata)
 458         {
 459                 $inputdata =& $bugsys->in;
 460         }
 461
 462         $fields = $bugsys->db->query("
 463                 SELECT bugfield.*
 464                 FROM " . TABLE_PREFIX . "bugfield AS bugfield
 465                 LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
 466                         ON (bugfield.fieldid = permission.fieldid)
 467                 WHERE permission.mask = 2
 468                 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
 469         );
 470         while ($field = $bugsys->db->fetch_array($fields))
 471         {
 472                 if ($field['type'] == 'input_checkbox')
 473                 {
 474                         $fieldbuild[] = 'field' . $field['fieldid'];
 475                         if (isset($inputdata["field$field[fieldid]"]))
 476                         {
 477                                 $fieldvalue[] = 1;
 478                         }
 479                         else
 480                         {
 481                                 $fieldvalue[] = 0;
 482                         }
 483                         continue;
 484                 }
 485
 486                 if ($field['required'] AND empty($inputdata["field$field[fieldid]"]))
 487                 {
 488                         $errorlist[] = lang::p('field_x_is_required', $field['name']);
 489                         continue;
 490                 }
 491
 492                 if (isset($inputdata["field$field[fieldid]"]))
 493                 {
 494                         $fieldbuild[] = 'field' . $field['fieldid'];
 495
 496                         if ($field['type'] == 'input_text')
 497                         {
 498                                 $fieldvalue[] = "'" . $inputdata["field$field[fieldid]"] . "'";
 499                         }
 500                         else
 501                         {
 502                                 if ($inputdata["field$field[fieldid]"] == -1)
 503                                 {
 504                                         $fieldvalue[] = "''";
 505                                         continue;
 506                                 }
 507
 508                                 $temp = unserialize($field['selects']);
 509                                 $fieldvalue[] = "'" . trim($temp[ intval($inputdata["field$field[fieldid]"]) ]) . "'";
 510                         }
 511                 }
 512         }
 513
 514         if ($errorlist)
 515         {
 516                 return $errorlist;
 517         }
 518
 519         if (count($fieldbuild) < 1)
 520         {
 521                 return;
 522         }
 523
 524         $bugsys->db->query("REPLACE INTO " . TABLE_PREFIX . "bugvaluefill (bugid, " . implode(', ', $fieldbuild) . ") VALUES ($bugid, " . implode(', ', $fieldvalue) . ")");
 525 }
 526
 527 /*=====================================================================*\
 528 || ###################################################################
 529 || # $HeadURL$
 530 || # $Id$
 531 || ###################################################################
 532 \*=====================================================================*/
 533 ?>