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