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         global $bugsys;
  46         fetch_user_display_name($userinfo);
  47         eval('$username = "' . $bugsys->template->fetch('username_display') . '";');
  48         return $username;
  49 }
  50
  51 // ######################## Start can_perform ########################
  52 // short-hand for bitwise &
  53 function can_perform($bitmask, $userinfo = null)
  54 {
  55         global $_PERMISSION;
  56
  57         if (!isset($_PERMISSION["$bitmask"]))
  58         {
  59                 trigger_error('Invalid bitmask "' . $bitmask . '" specified for can_perform() [includes/functions.php]', E_USER_WARNING);
  60         }
  61
  62         if (!$userinfo)
  63         {
  64                 global $bugsys;
  65                 return ($bugsys->userinfo['permissions'] & $_PERMISSION["$bitmask"]);
  66         }
  67         return ($userinfo['permissions'] & $_PERMISSION["bitmask"]);
  68 }
  69
  70 // #################### Start construct_pcv_select ###################
  71 // constructs a product/component/version select with one go :-)
  72 // NB: need to make sure we have the option to turn off just p/c selection without v
  73 function construct_pcv_select($select = '', $prefix = '--')
  74 {
  75         global $bugsys;
  76         static $HTML;
  77
  78         if ($HTML)
  79         {
  80                 return $HTML;
  81         }
  82
  83
  84         $selected = ' selected="selected"';
  85
  86         foreach ($bugsys->datastore['product'] AS $product)
  87         {
  88                 if ($product['componentmother'])
  89                 {
  90                         $components["$product[componentmother]"]["$product[productid]"] = $product;
  91                 }
  92                 else
  93                 {
  94                         $products["$product[productid]"] = $product;
  95                 }
  96         }
  97
  98         foreach ($bugsys->datastore['version'] AS $version)
  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(), $ignore21mask = false, $nodefault = false)
 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 = " . intval($bug['bugid']));
 347
 348         $fieldbits = '';
 349
 350         foreach ($fields AS $field)
 351         {
 352                 if ($nodefault)
 353                 {
 354                         $field['defaultvalue'] = '';
 355                 }
 356
 357                 if (!is_null($bug["field$field[fieldid]"]))
 358                 {
 359                         $bugsys->debug("not null: $field[fieldid]");
 360                         $value = $bug["field$field[fieldid]"];
 361                 }
 362                 else
 363                 {
 364                         $value = $field['defaultvalue'];
 365                 }
 366
 367                 if ($ignore21mask)
 368                 {
 369                         $field['mask'] = 2;
 370                 }
 371
 372                 if ($field['mask'] == 2)
 373                 {
 374                         switch ($field['type'])
 375                         {
 376                                 case 'input_text':
 377                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_text') . '";');
 378                                 break;
 379
 380                                 case 'input_checkbox':
 381                                         $selected = (($value) ? ' checked="checked"' : '');
 382                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_input_checkbox') . '";');
 383                                 break;
 384
 385                                 case 'select_single':
 386                                         $selects = unserialize($field['selects']);
 387                                         $value = trim($value);
 388
 389                                         $options = '';
 390
 391                                         $id = -1;
 392                                         $select = '';
 393                                         if (!$field['usedefault'] AND !trim($value))
 394                                         {
 395                                                 $selected = ' selected="selected"';
 396                                         }
 397                                         else
 398                                         {
 399                                                 $selected = '';
 400                                         }
 401                                         eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
 402
 403                                         foreach ($selects AS $id => $select)
 404                                         {
 405                                                 $selected = '';
 406                                                 $select = stripslashes(trim($select));
 407                                                 if ($select == $value)
 408                                                 {
 409                                                         $selected = ' selected="selected"';
 410                                                 }
 411                                                 else if ($field['usedefault'] AND $id == 0)
 412                                                 {
 413                                                         $selected = ' selected="selected"';
 414                                                 }
 415                                                 eval('$options .= "' . $bugsys->template->fetch('bugfield_select_single_option') . '";');
 416                                         }
 417                                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_select_single') . '";');
 418                                 break;
 419                         }
 420                 }
 421                 else
 422                 {
 423                         $bugsys->debug('mask 1 processing');
 424                         if (is_null($fieldvalues["field$field[fieldid]"]))
 425                         {
 426                                 $bugsys->debug("is null: $field[fieldid]");
 427                                 if ($field['type'] == 'select_single')
 428                                 {
 429                                         if ($field['usedefault'])
 430                                         {
 431                                                 $temp = unserialize($field['selects']);
 432                                                 $value = trim($temp[0]);
 433                                         }
 434                                         else
 435                                         {
 436                                                 $value = $fieldvalues["field$field[fieldid]"];
 437                                         }
 438                                 }
 439                                 else
 440                                 {
 441                                         $value = $field['defaultvalue'];
 442                                 }
 443                         }
 444                         else
 445                         {
 446                                 $value = $fieldvalues["field$field[fieldid]"];
 447                         }
 448
 449                         if ($field['type'] == 'input_checkbox')
 450                         {
 451                                 $value = (($value) ? 'True' : 'False');
 452                         }
 453                         $field['value'] = $value;
 454                         eval('$tempfield = "' . $bugsys->template->fetch('bugfield_static_text') . '";');
 455                 }
 456                 $fieldbits[] = $tempfield;
 457         }
 458
 459         return $fieldbits;
 460 }
 461
 462 // ################### Start process_custom_fields ###################
 463 function process_custom_fields($bugid, $inputdata = array())
 464 {
 465         global $bugsys;
 466
 467         if (!$inputdata)
 468         {
 469                 $inputdata =& $bugsys->in;
 470         }
 471
 472         $fields = $bugsys->db->query("
 473                 SELECT bugfield.*
 474                 FROM " . TABLE_PREFIX . "bugfield AS bugfield
 475                 LEFT JOIN " . TABLE_PREFIX . "bugfieldpermission AS permission
 476                         ON (bugfield.fieldid = permission.fieldid)
 477                 WHERE permission.mask = 2
 478                 AND permission.usergroupid = {$bugsys->userinfo['usergroupid']}"
 479         );
 480         while ($field = $bugsys->db->fetch_array($fields))
 481         {
 482                 if ($field['type'] == 'input_checkbox')
 483                 {
 484                         $fieldbuild[] = 'field' . $field['fieldid'];
 485                         if (isset($inputdata["field$field[fieldid]"]))
 486                         {
 487                                 $fieldvalue[] = 1;
 488                         }
 489                         else
 490                         {
 491                                 $fieldvalue[] = 0;
 492                         }
 493                         continue;
 494                 }
 495
 496                 if ($field['required'] AND empty($inputdata["field$field[fieldid]"]))
 497                 {
 498                         $errorlist[] = sprintf($bugsys->lang->string('The field titled "%1$s" is a required field.'), $field['name']);
 499                         continue;
 500                 }
 501
 502                 if (isset($inputdata["field$field[fieldid]"]))
 503                 {
 504                         $fieldbuild[] = 'field' . $field['fieldid'];
 505
 506                         if ($field['type'] == 'input_text')
 507                         {
 508                                 $fieldvalue[] = "'" . $inputdata["field$field[fieldid]"] . "'";
 509                         }
 510                         else
 511                         {
 512                                 if ($inputdata["field$field[fieldid]"] == -1)
 513                                 {
 514                                         $fieldvalue[] = "''";
 515                                         continue;
 516                                 }
 517
 518                                 $temp = unserialize($field['selects']);
 519                                 $fieldvalue[] = "'" . trim($temp[ intval($inputdata["field$field[fieldid]"]) ]) . "'";
 520                         }
 521                 }
 522         }
 523
 524         if ($errorlist)
 525         {
 526                 return $errorlist;
 527         }
 528
 529         if (count($fieldbuild) < 1)
 530         {
 531                 return;
 532         }
 533
 534         $bugsys->db->query("REPLACE INTO " . TABLE_PREFIX . "bugvaluefill (bugid, " . implode(', ', $fieldbuild) . ") VALUES ($bugid, " . implode(', ', $fieldvalue) . ")");
 535 }
 536
 537 /*=====================================================================*\
 538 || ###################################################################
 539 || # $HeadURL$
 540 || # $Id$
 541 || ###################################################################
 542 \*=====================================================================*/
 543 ?>