# -*- Mode: perl; indent-tabs-mode: nil -*- # # The contents of this file are subject to the Mozilla Public # License Version 1.1 (the "License"); you may not use this file # except in compliance with the License. You may obtain a copy of # the License at http://www.mozilla.org/MPL/ # # Software distributed under the License is distributed on an "AS # IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or # implied. See the License for the specific language governing # rights and limitations under the License. # # The Original Code is the Bugzilla Bug Tracking System. # # The Initial Developer of the Original Code is Netscape Communications # Corporation. Portions created by Netscape are # Copyright (C) 1998 Netscape Communications Corporation. All # Rights Reserved. # # Contributor(s): Terry Weissman # Dan Mosedale # Jacob Steenhagen # Bradley Baetz # Christopher Aillon # Max Kanat-Alexander # Frédéric Buclin # Marc Schumann package Bugzilla::Util; use strict; use base qw(Exporter); @Bugzilla::Util::EXPORT = qw(trick_taint detaint_natural detaint_signed html_quote url_quote xml_quote css_class_quote html_light_quote url_decode i_am_cgi correct_urlbase remote_ip do_ssl_redirect_if_required use_attachbase diff_arrays on_main_db trim wrap_hard wrap_comment find_wrap_point format_time validate_date validate_time datetime_from file_mod_time is_7bit_clean bz_crypt generate_random_password validate_email_syntax clean_text get_text template_var disable_utf8); use Bugzilla::Constants; use Date::Parse; use Date::Format; use DateTime; use DateTime::TimeZone; use Digest; use Email::Address; use List::Util qw(first); use Scalar::Util qw(tainted); use Template::Filters; use Text::Wrap; sub trick_taint { require Carp; Carp::confess("Undef to trick_taint") unless defined $_[0]; my $match = $_[0] =~ /^(.*)$/s; $_[0] = $match ? $1 : undef; return (defined($_[0])); } sub detaint_natural { my $match = $_[0] =~ /^(\d+)$/; $_[0] = $match ? int($1) : undef; return (defined($_[0])); } sub detaint_signed { my $match = $_[0] =~ /^([-+]?\d+)$/; # The "int()" call removes any leading plus sign. $_[0] = $match ? int($1) : undef; return (defined($_[0])); } # Bug 120030: Override html filter to obscure the '@' in user # visible strings. # Bug 319331: Handle BiDi disruptions. sub html_quote { my ($var) = Template::Filters::html_filter(@_); # Obscure '@'. $var =~ s/\@/\@/g; if (Bugzilla->params->{'utf8'}) { # Remove the following characters because they're # influencing BiDi: # -------------------------------------------------------- # |Code |Name |UTF-8 representation| # |------|--------------------------|--------------------| # |U+202a|Left-To-Right Embedding |0xe2 0x80 0xaa | # |U+202b|Right-To-Left Embedding |0xe2 0x80 0xab | # |U+202c|Pop Directional Formatting|0xe2 0x80 0xac | # |U+202d|Left-To-Right Override |0xe2 0x80 0xad | # |U+202e|Right-To-Left Override |0xe2 0x80 0xae | # -------------------------------------------------------- # # The following are characters influencing BiDi, too, but # they can be spared from filtering because they don't # influence more than one character right or left: # -------------------------------------------------------- # |Code |Name |UTF-8 representation| # |------|--------------------------|--------------------| # |U+200e|Left-To-Right Mark |0xe2 0x80 0x8e | # |U+200f|Right-To-Left Mark |0xe2 0x80 0x8f | # -------------------------------------------------------- $var =~ s/[\x{202a}-\x{202e}]//g; } return $var; } sub html_light_quote { my ($text) = @_; # List of allowed HTML elements having no attributes. my @allow = qw(b strong em i u p br abbr acronym ins del cite code var dfn samp kbd big small sub sup tt dd dt dl ul li ol fieldset legend); if (!Bugzilla->feature('html_desc')) { my $safe = join('|', @allow); my $chr = chr(1); # First, escape safe elements. $text =~ s#<($safe)>#$chr$1$chr#go; $text =~ s##$chr/$1$chr#go; # Now filter < and >. $text =~ s#<#<#g; $text =~ s#>#>#g; # Restore safe elements. $text =~ s#$chr/($safe)$chr##go; $text =~ s#$chr($safe)$chr#<$1>#go; return $text; } else { # We can be less restrictive. We can accept elements with attributes. push(@allow, qw(a blockquote q span)); # Allowed protocols. my $safe_protocols = join('|', SAFE_PROTOCOLS); my $protocol_regexp = qr{(^(?:$safe_protocols):|^[^:]+$)}i; # Deny all elements and attributes unless explicitly authorized. my @default = (0 => { id => 1, name => 1, class => 1, '*' => 0, # Reject all other attributes. } ); # Specific rules for allowed elements. If no specific rule is set # for a given element, then the default is used. my @rules = (a => { href => $protocol_regexp, title => 1, id => 1, name => 1, class => 1, '*' => 0, # Reject all other attributes. }, blockquote => { cite => $protocol_regexp, id => 1, name => 1, class => 1, '*' => 0, # Reject all other attributes. }, 'q' => { cite => $protocol_regexp, id => 1, name => 1, class => 1, '*' => 0, # Reject all other attributes. }, ); my $scrubber = HTML::Scrubber->new(default => \@default, allow => \@allow, rules => \@rules, comment => 0, process => 0); return $scrubber->scrub($text); } } sub email_filter { my ($toencode) = @_; if (!Bugzilla->user->id) { my @emails = Email::Address->parse($toencode); if (scalar @emails) { my @hosts = map { quotemeta($_->host) } @emails; my $hosts_re = join('|', @hosts); $toencode =~ s/\@(?:$hosts_re)//g; return $toencode; } } return $toencode; } # This originally came from CGI.pm, by Lincoln D. Stein sub url_quote { my ($toencode) = (@_); utf8::encode($toencode) # The below regex works only on bytes if Bugzilla->params->{'utf8'} && utf8::is_utf8($toencode); $toencode =~ s/([^a-zA-Z0-9_\-.])/uc sprintf("%%%02x",ord($1))/eg; return $toencode; } sub css_class_quote { my ($toencode) = (@_); $toencode =~ s#[ /]#_#g; $toencode =~ s/([^a-zA-Z0-9_\-.])/uc sprintf("&#x%x;",ord($1))/eg; return $toencode; } sub xml_quote { my ($var) = (@_); $var =~ s/\&/\&/g; $var =~ s//\>/g; $var =~ s/\"/\"/g; $var =~ s/\'/\'/g; # the following nukes characters disallowed by the XML 1.0 # spec, Production 2.2. 1.0 declares that only the following # are valid: # (#x9 | #xA | #xD | [#x20-#xD7FF] | [#xE000-#xFFFD] | [#x10000-#x10FFFF]) $var =~ s/([\x{0001}-\x{0008}]| [\x{000B}-\x{000C}]| [\x{000E}-\x{001F}]| [\x{D800}-\x{DFFF}]| [\x{FFFE}-\x{FFFF}])//gx; return $var; } # This function must not be relied upon to return a valid string to pass to # the DB or the user in UTF-8 situations. The only thing you can rely upon # it for is that if you url_decode a string, it will url_encode back to the # exact same thing. sub url_decode { my ($todecode) = (@_); $todecode =~ tr/+/ /; # pluses become spaces $todecode =~ s/%([0-9a-fA-F]{2})/pack("c",hex($1))/ge; return $todecode; } sub i_am_cgi { # I use SERVER_SOFTWARE because it's required to be # defined for all requests in the CGI spec. return exists $ENV{'SERVER_SOFTWARE'} ? 1 : 0; } # This exists as a separate function from Bugzilla::CGI::redirect_to_https # because we don't want to create a CGI object during XML-RPC calls # (doing so can mess up XML-RPC). sub do_ssl_redirect_if_required { return if !i_am_cgi(); return if !Bugzilla->params->{'ssl_redirect'}; my $sslbase = Bugzilla->params->{'sslbase'}; # If we're already running under SSL, never redirect. return if uc($ENV{HTTPS} || '') eq 'ON'; # Never redirect if there isn't an sslbase. return if !$sslbase; Bugzilla->cgi->redirect_to_https(); } sub correct_urlbase { my $ssl = Bugzilla->params->{'ssl_redirect'}; my $urlbase = Bugzilla->params->{'urlbase'}; my $sslbase = Bugzilla->params->{'sslbase'}; if (!$sslbase) { return $urlbase; } elsif ($ssl) { return $sslbase; } else { # Return what the user currently uses. return (uc($ENV{HTTPS} || '') eq 'ON') ? $sslbase : $urlbase; } } sub remote_ip { my $ip = $ENV{'REMOTE_ADDR'} || '127.0.0.1'; my @proxies = split(/[\s,]+/, Bugzilla->params->{'inbound_proxies'}); if (first { $_ eq $ip } @proxies) { $ip = $ENV{'HTTP_X_FORWARDED_FOR'} if $ENV{'HTTP_X_FORWARDED_FOR'}; } return $ip; } sub use_attachbase { my $attachbase = Bugzilla->params->{'attachment_base'}; return ($attachbase ne '' && $attachbase ne Bugzilla->params->{'urlbase'} && $attachbase ne Bugzilla->params->{'sslbase'}) ? 1 : 0; } sub diff_arrays { my ($old_ref, $new_ref) = @_; my @old = @$old_ref; my @new = @$new_ref; # For each pair of (old, new) entries: # If they're equal, set them to empty. When done, @old contains entries # that were removed; @new contains ones that got added. foreach my $oldv (@old) { foreach my $newv (@new) { next if ($newv eq ''); if ($oldv eq $newv) { $newv = $oldv = ''; } } } my @removed = grep { $_ ne '' } @old; my @added = grep { $_ ne '' } @new; return (\@removed, \@added); } sub trim { my ($str) = @_; if ($str) { $str =~ s/^\s+//g; $str =~ s/\s+$//g; } return $str; } sub wrap_comment { my ($comment, $cols) = @_; my $wrappedcomment = ""; # Use 'local', as recommended by Text::Wrap's perldoc. local $Text::Wrap::columns = $cols || COMMENT_COLS; # Make words that are longer than COMMENT_COLS not wrap. local $Text::Wrap::huge = 'overflow'; # Don't mess with tabs. local $Text::Wrap::unexpand = 0; # If the line starts with ">", don't wrap it. Otherwise, wrap. foreach my $line (split(/\r\n|\r|\n/, $comment)) { if ($line =~ qr/^>/) { $wrappedcomment .= ($line . "\n"); } else { # Due to a segfault in Text::Tabs::expand() when processing tabs with # Unicode (see http://rt.perl.org/rt3/Public/Bug/Display.html?id=52104), # we have to remove tabs before processing the comment. This restriction # can go away when we require Perl 5.8.9 or newer. $line =~ s/\t/ /g; $wrappedcomment .= (wrap('', '', $line) . "\n"); } } chomp($wrappedcomment); # Text::Wrap adds an extra newline at the end. return $wrappedcomment; } sub find_wrap_point { my ($string, $maxpos) = @_; if (!$string) { return 0 } if (length($string) < $maxpos) { return length($string) } my $wrappoint = rindex($string, ",", $maxpos); # look for comma if ($wrappoint < 0) { # can't find comma $wrappoint = rindex($string, " ", $maxpos); # look for space if ($wrappoint < 0) { # can't find space $wrappoint = rindex($string, "-", $maxpos); # look for hyphen if ($wrappoint < 0) { # can't find hyphen $wrappoint = $maxpos; # just truncate it } else { $wrappoint++; # leave hyphen on the left side } } } return $wrappoint; } sub wrap_hard { my ($string, $columns) = @_; local $Text::Wrap::columns = $columns; local $Text::Wrap::unexpand = 0; local $Text::Wrap::huge = 'wrap'; my $wrapped = wrap('', '', $string); chomp($wrapped); return $wrapped; } sub format_time { my ($date, $format, $timezone) = @_; # If $format is not set, try to guess the correct date format. if (!$format) { if (!ref $date && $date =~ /^(\d{4})[-\.](\d{2})[-\.](\d{2}) (\d{2}):(\d{2})(:(\d{2}))?$/) { my $sec = $7; if (defined $sec) { $format = "%Y-%m-%d %T %Z"; } else { $format = "%Y-%m-%d %R %Z"; } } else { # Default date format. See DateTime for other formats available. $format = "%Y-%m-%d %R %Z"; } } my $dt = ref $date ? $date : datetime_from($date, $timezone); $date = defined $dt ? $dt->strftime($format) : ''; return trim($date); } sub datetime_from { my ($date, $timezone) = @_; # In the database, this is the "0" date. return undef if $date =~ /^0000/; # strptime($date) returns an empty array if $date has an invalid # date format. my @time = strptime($date); unless (scalar @time) { # If an unknown timezone is passed (such as MSK, for Moskow), # strptime() is unable to parse the date. We try again, but we first # remove the timezone. $date =~ s/\s+\S+$//; @time = strptime($date); } return undef if !@time; # strptime() counts years from 1900, and months from 0 (January). # We have to fix both values. my %args = ( year => $time[5] + 1900, month => $time[4] + 1, day => $time[3], hour => $time[2], minute => $time[1], # DateTime doesn't like fractional seconds. # Also, sometimes seconds are undef. second => defined($time[0]) ? int($time[0]) : undef, # If a timezone was specified, use it. Otherwise, use the # local timezone. time_zone => Bugzilla->local_timezone->offset_as_string($time[6]) || Bugzilla->local_timezone, ); # If something wasn't specified in the date, it's best to just not # pass it to DateTime at all. (This is important for doing datetime_from # on the deadline field, which is usually just a date with no time.) foreach my $arg (keys %args) { delete $args{$arg} if !defined $args{$arg}; } my $dt = new DateTime(\%args); # Now display the date using the given timezone, # or the user's timezone if none is given. $dt->set_time_zone($timezone || Bugzilla->user->timezone); return $dt; } sub file_mod_time { my ($filename) = (@_); my ($dev,$ino,$mode,$nlink,$uid,$gid,$rdev,$size, $atime,$mtime,$ctime,$blksize,$blocks) = stat($filename); return $mtime; } sub bz_crypt { my ($password, $salt) = @_; my $algorithm; if (!defined $salt) { # If you don't use a salt, then people can create tables of # hashes that map to particular passwords, and then break your # hashing very easily if they have a large-enough table of common # (or even uncommon) passwords. So we generate a unique salt for # each password in the database, and then just prepend it to # the hash. $salt = generate_random_password(PASSWORD_SALT_LENGTH); $algorithm = PASSWORD_DIGEST_ALGORITHM; } # We append the algorithm used to the string. This is good because then # we can change the algorithm being used, in the future, without # disrupting the validation of existing passwords. Also, this tells # us if a password is using the old "crypt" method of hashing passwords, # because the algorithm will be missing from the string. if ($salt =~ /{([^}]+)}$/) { $algorithm = $1; } my $crypted_password; if (!$algorithm) { # Wide characters cause crypt to die if (Bugzilla->params->{'utf8'}) { utf8::encode($password) if utf8::is_utf8($password); } # Crypt the password. $crypted_password = crypt($password, $salt); # HACK: Perl has bug where returned crypted password is considered # tainted. See http://rt.perl.org/rt3/Public/Bug/Display.html?id=59998 unless(tainted($password) || tainted($salt)) { trick_taint($crypted_password); } } else { my $hasher = Digest->new($algorithm); # We only want to use the first characters of the salt, no # matter how long of a salt we may have been passed. $salt = substr($salt, 0, PASSWORD_SALT_LENGTH); $hasher->add($password, $salt); $crypted_password = $salt . $hasher->b64digest . "{$algorithm}"; } # Return the crypted password. return $crypted_password; } sub generate_random_password { my $size = shift || 10; # default to 10 chars if nothing specified return join("", map{ ('0'..'9','a'..'z','A'..'Z')[rand 62] } (1..$size)); } sub validate_email_syntax { my ($addr) = @_; my $match = Bugzilla->params->{'emailregexp'}; my $ret = ($addr =~ /$match/ && $addr !~ /[\\\(\)<>&,;:"\[\] \t\r\n]/); if ($ret) { # We assume these checks to suffice to consider the address untainted. trick_taint($_[0]); } return $ret ? 1 : 0; } sub validate_date { my ($date) = @_; my $date2; # $ts is undefined if the parser fails. my $ts = str2time($date); if ($ts) { $date2 = time2str("%Y-%m-%d", $ts); $date =~ s/(\d+)-0*(\d+?)-0*(\d+?)/$1-$2-$3/; $date2 =~ s/(\d+)-0*(\d+?)-0*(\d+?)/$1-$2-$3/; } my $ret = ($ts && $date eq $date2); return $ret ? 1 : 0; } sub validate_time { my ($time) = @_; my $time2; # $ts is undefined if the parser fails. my $ts = str2time($time); if ($ts) { $time2 = time2str("%H:%M:%S", $ts); if ($time =~ /^(\d{1,2}):(\d\d)(?::(\d\d))?$/) { $time = sprintf("%02d:%02d:%02d", $1, $2, $3 || 0); } } my $ret = ($ts && $time eq $time2); return $ret ? 1 : 0; } sub is_7bit_clean { return $_[0] !~ /[^\x20-\x7E\x0A\x0D]/; } sub clean_text { my $dtext = shift; if ($dtext) { # change control characters into a space $dtext =~ s/[\x00-\x1F\x7F]+/ /g; } return trim($dtext); } sub on_main_db (&) { my $code = shift; my $original_dbh = Bugzilla->dbh; Bugzilla->request_cache->{dbh} = Bugzilla->dbh_main; $code->(); Bugzilla->request_cache->{dbh} = $original_dbh; } sub get_text { my ($name, $vars) = @_; my $template = Bugzilla->template_inner; $vars ||= {}; $vars->{'message'} = $name; my $message; if (!$template->process('global/message.txt.tmpl', $vars, \$message)) { require Bugzilla::Error; Bugzilla::Error::ThrowTemplateError($template->error()); } # Remove the indenting that exists in messages.html.tmpl. $message =~ s/^ //gm; return $message; } sub template_var { my $name = shift; my $cache = Bugzilla->request_cache->{util_template_var} ||= {}; my $template = Bugzilla->template_inner; my $lang = $template->context->{bz_language}; return $cache->{$lang}->{$name} if defined $cache->{$lang}; my %vars; # Note: If we suddenly start needing a lot of template_var variables, # they should move into their own template, not field-descs. my $result = $template->process('global/field-descs.none.tmpl', { vars => \%vars, in_template_var => 1 }); # Bugzilla::Error can't be "use"d in Bugzilla::Util. if (!$result) { require Bugzilla::Error; Bugzilla::Error::ThrowTemplateError($template->error); } $cache->{$lang} = \%vars; return $vars{$name}; } sub disable_utf8 { if (Bugzilla->params->{'utf8'}) { binmode STDOUT, ':bytes'; # Turn off UTF8 encoding. } } 1; __END__ =head1 NAME Bugzilla::Util - Generic utility functions for bugzilla =head1 SYNOPSIS use Bugzilla::Util; # Functions for dealing with variable tainting trick_taint($var); detaint_natural($var); detaint_signed($var); # Functions for quoting html_quote($var); url_quote($var); xml_quote($var); email_filter($var); # Functions for decoding $rv = url_decode($var); # Functions that tell you about your environment my $is_cgi = i_am_cgi(); my $urlbase = correct_urlbase(); # Data manipulation ($removed, $added) = diff_arrays(\@old, \@new); # Functions for manipulating strings $val = trim(" abc "); $wrapped = wrap_comment($comment); # Functions for formatting time format_time($time); datetime_from($time, $timezone); # Functions for dealing with files $time = file_mod_time($filename); # Cryptographic Functions $crypted_password = bz_crypt($password); $new_password = generate_random_password($password_length); # Validation Functions validate_email_syntax($email); validate_date($date); # DB-related functions on_main_db { ... code here ... }; =head1 DESCRIPTION This package contains various utility functions which do not belong anywhere else. B. Do not add methods to this package unless it is intended to be used for a significant number of files, and it does not belong anywhere else. =head1 FUNCTIONS This package provides several types of routines: =head2 Tainting Several functions are available to deal with tainted variables. B to avoid security holes. =over 4 =item C Tricks perl into untainting a particular variable. Use trick_taint() when you know that there is no way that the data in a scalar can be tainted, but taint mode still bails on it. B =item C This routine detaints a natural number. It returns a true value if the value passed in was a valid natural number, else it returns false. You B check the result of this routine to avoid security holes. =item C This routine detaints a signed integer. It returns a true value if the value passed in was a valid signed integer, else it returns false. You B check the result of this routine to avoid security holes. =back =head2 Quoting Some values may need to be quoted from perl. However, this should in general be done in the template where possible. =over 4 =item C Returns a value quoted for use in HTML, with &, E, E, E<34> and @ being replaced with their appropriate HTML entities. Also, Unicode BiDi controls are deleted. =item C Returns a string where only explicitly allowed HTML elements and attributes are kept. All HTML elements and attributes not being in the whitelist are either escaped (if HTML::Scrubber is not installed) or removed. =item C Quotes characters so that they may be included as part of a url. =item C Quotes characters so that they may be used as CSS class names. Spaces and forward slashes are replaced by underscores. =item C This is similar to C, except that ' is escaped to '. This is kept separate from html_quote partly for compatibility with previous code (for ') and partly for future handling of non-ASCII characters. =item C Converts the %xx encoding from the given URL back to its original form. =item C Removes the hostname from email addresses in the string, if the user currently viewing Bugzilla is logged out. If the user is logged-in, this filter just returns the input string. =back =head2 Environment and Location Functions returning information about your environment or location. =over 4 =item C Tells you whether or not you are being run as a CGI script in a web server. For example, it would return false if the caller is running in a command-line script. =item C Returns either the C or C parameter, depending on the current setting for the C parameter. =item C Returns true if an alternate host is used to display attachments; false otherwise. =back =head2 Data Manipulation =over 4 =item C Description: Takes two arrayrefs, and will tell you what it takes to get from @old to @new. Params: @old = array that you are changing from @new = array that you are changing to Returns: A list of two arrayrefs. The first is a reference to an array containing items that were removed from @old. The second is a reference to an array containing items that were added to @old. If both returned arrays are empty, @old and @new contain the same values. =back =head2 String Manipulation =over 4 =item C Removes any leading or trailing whitespace from a string. This routine does not modify the existing string. =item C Wraps a string, so that a line is I longer than C<$size>. Returns the string, wrapped. =item C Takes a bug comment, and wraps it to the appropriate length. The length is currently specified in C. Lines beginning with ">" are assumed to be quotes, and they will not be wrapped. The intended use of this function is to wrap comments that are about to be displayed or emailed. Generally, wrapped text should not be stored in the database. =item C Search for a comma, a whitespace or a hyphen to split $string, within the first $maxpos characters. If none of them is found, just split $string at $maxpos. The search starts at $maxpos and goes back to the beginning of the string. =item C Returns true is the string contains only 7-bit characters (ASCII 32 through 126, ASCII 10 (LineFeed) and ASCII 13 (Carrage Return). =item C Disable utf8 on STDOUT (and display raw data instead). =item C Returns the parameter "cleaned" by exchanging non-printable characters with spaces. Specifically characters (ASCII 0 through 31) and (ASCII 127) will become ASCII 32 (Space). =item C =over =item B This is a method of getting localized strings within Bugzilla code. Use this when you don't want to display a whole template, you just want a particular string. It uses the F template to return a string. =item B =over =item C<$message> - The identifier for the message. =item C<$vars> - A hashref. Any variables you want to pass to the template. =back =item B A string. =back =item C This is a method of getting the value of a variable from a template in Perl code. The available variables are in the C template. Just pass in the name of the variable that you want the value of. =back =head2 Formatting Time =over 4 =item C Takes a time and converts it to the desired format and timezone. If no format is given, the routine guesses the correct one and returns an empty array if it cannot. If no timezone is given, the user's timezone is used, as defined in his preferences. This routine is mainly called from templates to filter dates, see "FILTER time" in L. =item C Returns a DateTime object given a date string. If the string is not in some valid date format that C understands, we return C. You can optionally specify a timezone for the returned date. If not specified, defaults to the currently-logged-in user's timezone, or the Bugzilla server's local timezone if there isn't a logged-in user. =back =head2 Files =over 4 =item C Takes a filename and returns the modification time. It returns it in the format of the "mtime" parameter of the perl "stat" function. =back =head2 Cryptography =over 4 =item C Takes a string and returns a hashed (encrypted) value for it, using a random salt. An optional salt string may also be passed in. Please always use this function instead of the built-in perl C function, when checking or setting a password. Bugzilla does not use C. =begin undocumented Random salts are generated because the alternative is usually to use the first two characters of the password itself, and since the salt appears in plaintext at the beginning of the encrypted password string this has the effect of revealing the first two characters of the password to anyone who views the encrypted version. =end undocumented =item C Returns an alphanumeric string with the specified length (10 characters by default). Use this function to generate passwords and tokens. =back =head2 Validation =over 4 =item C Do a syntax checking for a legal email address and returns 1 if the check is successful, else returns 0. Untaints C<$email> if successful. =item C Make sure the date has the correct format and returns 1 if the check is successful, else returns 0. =back =head2 Database =over =item C Runs a block of code always on the main DB. Useful for when you're inside a subroutine and need to do some writes to the database, but don't know if Bugzilla is currently using the shadowdb or not. Used like: on_main_db { my $dbh = Bugzilla->dbh; $dbh->do("INSERT ..."); } =back