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