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