X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=fortunate%2Fcookie.php;h=3022776ce3ea72292cc7b5fd236a01387e0c2859;hb=87a392a3c793b1b9b781939b46cf4189f15fb881;hp=0acfa2302f076f46c789c5a691b394aeb8e9e413;hpb=2517e7716ebcd118b170695b77b3bff074e620fe;p=friendica-addons.git diff --git a/fortunate/cookie.php b/fortunate/cookie.php index 0acfa230..3022776c 100644 --- a/fortunate/cookie.php +++ b/fortunate/cookie.php @@ -23,7 +23,7 @@ else $adult = 0; $length = (($_GET['length']) ? intval($_GET['length']) : 0); -$numlines = ((intval($_GET['numlines'])) ? intval($_GET['numlines']) : 0); +$numlines = ((intval($_GET['numlines'])) ? intval($_GET['numlines']) : 0); $cat = (($_GET['cat'] == '1') ? 1 : 0); $equal = (($_GET['equal'] == '1') ? 1 : 0); $stats = (($_GET['stats'] == '1') ? 1 : 0); @@ -50,7 +50,7 @@ if($numlines < 0) function do_query($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$regex,$equal) { global $db; $rnd = mt_rand(); - $r = array(); + $r = []; $typesql = (($table) ? " WHERE `category` = '$table' " : " WHERE 1 "); $lengthsql = (($length) ? " AND LENGTH(`text`) < $length " : "" ); @@ -80,24 +80,24 @@ function do_query($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$re $eqsql = ''; if($equal) { - $catsavail = array(); - $res = @$db->query("SELECT DISTINCT ( `category` ) FROM `fortune` + $catsavail = []; + $res = @$db->query("SELECT DISTINCT ( `category` ) FROM `fortune` $typesql $adultsql $lengthsql $langsql - $patsql + $patsql $regexsql "); if($res->num_rows) { while($x = $res->fetch_array(MYSQL_ASSOC)) $catsavail[] = $x['category']; - + $eqsql = " AND `category` = '" . $catsavail[mt_rand(0,$res->num_rows - 1)] . "' "; } } - $result = @$db->query("SELECT `text`, `category` FROM `fortune` + $result = @$db->query("SELECT `text`, `category` FROM `fortune` $typesql $adultsql $lengthsql @@ -105,7 +105,7 @@ function do_query($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$re $patsql $regexsql $eqsql - ORDER BY RAND($rnd) + ORDER BY RAND($rnd) LIMIT $limit"); if($result->num_rows) { @@ -120,7 +120,7 @@ function do_query($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$re function do_stats($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$regex,$equal) { global $db; $rnd = mt_rand(); - $r = array(); + $r = []; $typesql = (($table) ? " WHERE `category` = '$table' " : " WHERE 1 "); $lengthsql = (($length) ? " AND LENGTH(`text`) < $length " : "" ); @@ -149,7 +149,7 @@ function do_stats($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$re $eqsql = ''; - $result = @$db->query("SELECT `text`, `category` FROM `fortune` + $result = @$db->query("SELECT `text`, `category` FROM `fortune` $typesql $adultsql $lengthsql @@ -162,22 +162,22 @@ function do_stats($table,$length,$numlines,$adult,$cat,$limit,$lang,$pattern,$re echo '
' . $result->num_rows . ' matching quotations.
'; - $res = @$db->query("SELECT DISTINCT ( `category` ) FROM `fortune` + $res = @$db->query("SELECT DISTINCT ( `category` ) FROM `fortune` $typesql $adultsql $lengthsql $langsql - $patsql + $patsql $regexsql "); if($res->num_rows) { echo '
Matching Databases:
'; while($x = $res->fetch_array(MYSQL_ASSOC)) echo $x['category'].'
'; - + } else echo '
No matching databases using those search parameters - please refine your options.
'; - + } @@ -195,23 +195,23 @@ function fortune_to_html($s) { // So for now, just remove them. $s = str_replace( - array("&", + ["&", "<", ">", '"', "\007", "\t", "\r", - "\n"), + "\n"], - array("&", + ["&", "<", ">", """, "", "        ", "", - "
"), + "
"], $s); // Replace pseudo diacritics // These were used to produce accented characters. For instance an accented