. if (!defined('EG')) die('Direct access not allowed!'); function encodeUrl($url) { $url = str_replace(' ','-',$url); $url = str_replace('[',null,$url); $url = str_replace(']',null,$url); $url = str_replace('(',null,$url); $url = str_replace(')',null,$url); $url = str_replace('@','-at-',$url); $url = urlencode($url); // $url = html_entity_decode($url, ENT_QUOTES); // $url = xml_encode($url); return $url; } function smartDate($uglyDate = null, $lang = 'en') { switch ($lang) { case 'en': $smDate = date('H:i, d F Y',strtotime($uglyDate)); break; default: $smDate = date('H:i, d F Y',strtotime($uglyDate)); } return $smDate; } function sanitizeString($string) { $string = preg_match('/^[a-zA-Z0-9\-\_\.\+\s]+$/',$string) ? sanitizeAll($string) : 'undef'; return $string; } function sanitizeAlphanum($string) { $string = ctype_alnum($string) ? sanitizeAll($string) : 'undef'; return $string; } function sanitizePciid($string) { $string = preg_match('/^[a-zA-Z0-9]{4}(\:)[a-zA-Z0-9]{4}$/',$string) ? sanitizeAll($string) : '0'; return $string; } function getOrderByClause($string) { switch ($string) { case 'last-inserted': $orderBy = 'hardware.id_hard desc'; break; case 'alphabetically': $orderBy = 'model'; break; case 'alphabetically-desc': $orderBy = 'model desc'; break; case 'compatibility': $orderBy = 'compatibility'; break; case 'undef': $orderBy = 'hardware.id_hard desc'; break; default: $orderBy = 'hardware.id_hard desc'; } return $orderBy; } function diff($old, $new){ $maxlen = 0; foreach($old as $oindex => $ovalue){ // $nkeys = getNewKeys($new,$ovalue); $nkeys = array_keys($new, $ovalue); foreach($nkeys as $nindex){ $matrix[$oindex][$nindex] = isset($matrix[$oindex - 1][$nindex - 1]) ? $matrix[$oindex - 1][$nindex - 1] + 1 : 1; if($matrix[$oindex][$nindex] > $maxlen){ $maxlen = $matrix[$oindex][$nindex]; $omax = $oindex + 1 - $maxlen; $nmax = $nindex + 1 - $maxlen; } } } if($maxlen == 0) return array(array('d'=>$old, 'i'=>$new)); return array_merge( diff(array_slice($old, 0, $omax), array_slice($new, 0, $nmax)), array_slice($new, $nmax, $maxlen), diff(array_slice($old, $omax + $maxlen), array_slice($new, $nmax + $maxlen))); } function htmlDiff($old, $new){ $old = str_replace("\r\n"," \r\n ",$old); $new = str_replace("\r\n"," \r\n ",$new); $ret = null; $diff = diff(explode(' ', $old), explode(' ', $new)); foreach($diff as $k){ if(is_array($k)) $ret .= (!empty($k['d'])?"".implode(' ',$k['d'])." ":''). (!empty($k['i'])?"".implode(' ',$k['i'])." ":''); else $ret .= $k . ' '; } return $ret; } //a cosa serve? function applyBreaks($values,$fields) { $fieldsArray = explode(',',$fields); foreach ($fieldsArray as $field) { if (array_key_exists($field,$values)) { $values[$field] = nl2br($values[$field]); } } return $values; } function getLinkToUser($user) { if (strstr($user,'__')) { return str_replace('__',null,$user); } else { return "$user"; } } //decode the text of the wiki function decodeWikiText($string) { $string = preg_replace('/(\[hr\])/', '
',$string); $string = preg_replace_callback('/(\[a\])(.*?)(\[\/a\])/', 'linkTo',$string); $string = preg_replace_callback('/(\[a\])(.*?)\|(.*?)(\[\/a\])/', 'linkToWithText',$string); $string = preg_replace_callback('/(\[notebook\])([0-9]*?)(\[\/notebook\])/s', 'linkToNotebook',$string); $string = preg_replace_callback('/(\[wifi\])([0-9]*?)(\[\/wifi\])/s', 'linkToWifi',$string); $string = preg_replace_callback('/(\[videocard\])([0-9]*?)(\[\/videocard\])/s', 'linkToVideocard',$string); $string = preg_replace('/(\[b\])(.*?)(\[\/b\])/s', '${2}',$string); $string = preg_replace('/(\[u\])(.*?)(\[\/u\])/s', '${2}',$string); $string = preg_replace('/(\[i\])(.*?)(\[\/i\])/s', '${2}',$string); $string = preg_replace('/(\[del\])(.*?)(\[\/del\])/s', '${2}',$string); $string = preg_replace('/(\[\*\])(.*?)(\[\/\*\])/s', '
  • ${2}
  • ',$string); $string = preg_replace('/(\[list\])(.*?)(\[\/list\])/s', '',$string); $string = preg_replace('/(\[enum\])(.*?)(\[\/enum\])/s', '
      ${2}
    ',$string); $string = preg_replace('/(\[code\])(.*?)(\[\/code\])/s', '
    ${2}
    ',$string); $string = preg_replace('/(\[p\])(.*?)(\[\/p\])/s', '

    ${2}

    ',$string); $string = preg_replace('/(\[h1\])(.*?)(\[\/h1\])/s', '
    ${2}
    ',$string); $string = preg_replace('/(\[h2\])(.*?)(\[\/h2\])/s', '
    ${2}
    ',$string); $string = preg_replace('/(\[h3\])(.*?)(\[\/h3\])/s', '
    ${2}
    ',$string); return $string; } function checkUrl($url) { // $match = '/^http\:\/\/(www\.)?[a-zA-Z0-9\-\_]+(\.[a-zA-Z0-9\-\_]+)?\.(com|net|it|info|org|eu|uk)((\/[a-zA-Z0-9\_\-\+]+)+[\/]?)?(\?([a-zA-Z0-9\_\-\+\s]+\=[a-zA-Z0-9\_\-\s\+\&]+)+)?(#[a-zA-Z0-9\_\-\+\s]+)?([\s]*)?$/'; $match = '/^http\:\/\/(www\.)?[a-zA-Z0-9\-\_]+(\.[a-zA-Z0-9\-\_]+)?\.(com|net|it|info|org|eu|uk|ca)((\/[a-zA-Z0-9\_\-\+]+)*(\/([a-zA-Z0-9\_\-\.\+]+\.(php|html|htm|asp|aspx|jsp|cgi))?)?)?(\?([a-zA-Z0-9\_\-\+\s]+\=[a-zA-Z0-9\_\-\s\+\&]+)+)?(#[a-zA-Z0-9\_\-\+\s]+)?([\s]*)?$/'; if (preg_match($match,$url)) { return true; } else { return false; } } function vitalizeUrl($string) { if (checkUrl($string)) { return "".$string.""; } return $string; } function linkTo($match) { if (checkUrl($match[2])) { return "".$match[2].""; } else { return $match[0]; } } function linkToWithText($match) { if (checkUrl($match[2])) { return "".$match[3].""; } else { return $match[0]; } } //create the link to the wiki page of the notebook function linkToNotebook($match) { $hardware = new HardwareModel(); $clean['id_hard'] = (int)$match[2]; $name = encodeUrl($hardware->getTheModelName($clean['id_hard'])); $href = "HTTP://".DOMAIN_NAME."/notebooks/view/".Lang::$current."/".$clean['id_hard']."/$name"; return (strcmp($name,'') !== 0) ? "".$name."" : $match[0]; } //create the link to the wiki page of the wifi function linkToWifi($match) { $hardware = new HardwareModel(); $clean['id_hard'] = (int)$match[2]; $name = encodeUrl($hardware->getTheModelName($clean['id_hard'])); $href = "HTTP://".DOMAIN_NAME."/wifi/view/".Lang::$current."/".$clean['id_hard']."/$name"; return (strcmp($name,'') !== 0) ? "".$name."" : $match[0]; } //create the link to the wiki page of the videocard function linkToVideocard($match) { $hardware = new HardwareModel(); $clean['id_hard'] = (int)$match[2]; $name = encodeUrl($hardware->getTheModelName($clean['id_hard'])); $href = "HTTP://".DOMAIN_NAME."/videocards/view/".Lang::$current."/".$clean['id_hard']."/$name"; return (strcmp($name,'') !== 0) ? "".$name."" : $match[0]; } function getUserName($id_user = 0) { $clean['id_user'] = (int)$id_user; $u = new UsersModel(); return $u->getUser($clean['id_user']); } function getMotivation($row,$controller) { if (strcmp($row['deletion']['object'],'duplication') === 0) { $clean['id_hard'] = (int)$row['deletion']['id_duplicate']; $hardware = new HardwareModel(); $name = encodeUrl($hardware->getTheModelName($clean['id_hard'])); return "duplication of the model having id ".$clean['id_hard'].""; } else { return "".$row['deletion']['object'].""; } } //get the text in the right language function gtext($string) { if (isset(Lang::$i18n[Lang::$current][$string])) { return Lang::$i18n[Lang::$current][$string]; } return $string; } //rewrite the vendor name function betterVendor($string) { $names = array( "AT-T" => "AT&T", "Franklin-Wireless-Corporation" => "Franklin Wireless Corporation", "Novatel-Wireless" => "Novatel Wireless", "Sierra-Wireless" => "Sierra Wireless", "ALi-Corporation" => "ALi Corporation", "Advanced-Micro-Devices" => "Advanced Micro Devices (AMD)", "Analog-Devices" => "Analog Devices", "ATI-Technologies-Inc" => "ATI Technologies Inc", "Aureal-Semiconductor" => "Aureal Semiconductor", "Avance-Logic-Inc" => "Avance Logic Inc (ALI)", "Aztech-System-Ltd" => "Aztech System Ltd", "Brooktree-Corporation" => "Brooktree Corporation", "C-Media-Electronics-Inc" => "C-Media Electronics Inc", "Cirrus-Logic" => "Cirrus Logic", "Creative-Labs" => "Creative Labs", "Ensoniq" => "Ensoniq", "ESS-Technology" => "ESS Technology", "ForteMedia-Inc" => "ForteMedia Inc", "Intel-Corporation" => "Intel Corporation", "Motorola" => "Motorola", "National-Semiconductor-Corporation" => "National Semiconductor Corporation", "Neomagic-Corp" => "Neomagic Corp", "nVidia-Corporation" => "nVidia Corporation", "RME" => "RME", "S3 Inc" => "S3-Inc", "Silicon-Integrated-Systems" => "Silicon Integrated Systems (SiS)", "Trident-Microsystems" => "Trident Microsystems", "VIA-Technologies-Inc" => "VIA Technologies Inc", "Xilinx-Corporation" => "Xilinx Corporation", "Yamaha-Corporation" => "Yamaha Corporation", ); return (array_key_exists($string,$names)) ? $names[$string] : $string; } //get the hardware info from the talk id function getHardwareInfoFromTalkId($id = 0) { $clean['id'] = (int)$id; $talk = new TalkModel(); $res = $talk->select('hardware.type,hardware.id_hard')->from('hardware inner join talk')->using('id_hard')->where(array('id_talk'=>$clean['id']))->send(); return $res[0]['hardware']; } //get the issue info from the message id function getIssueNumberFromMessageId($id = 0) { $clean['id'] = (int)$id; $mess = new MessagesModel(); $res = $mess->select('issues.id_issue')->from('issues inner join messages')->using('id_issue')->where(array('id_mes'=>$clean['id']))->toList('issues.id_issue')->send(); return $res[0]; } //return the URL to the moderated object page function goToModeratedItem( $row = array() ) { $url = null; switch ($row['type']) { case 'message': $url = 'issues/view/'.Lang::$current.'/'.getIssueNumberFromMessageId($row['id']).'#message-'.$row['id']; break; case 'talk': $hardInfo = getHardwareInfoFromTalkId($row['id']); $controller = MyStrings::$reverse[$hardInfo['type']]; $url = $controller.'/talk/'.Lang::$current.'/'.$hardInfo['id_hard'].'#talk-'.$row['id']; break; case 'user': $url = 'meet/user/'.Lang::$current.'/'.getUserName($row['id']); break; case 'issue': $url = 'issues/view/'.Lang::$current.'/'.$row['id']; break; } return 'http://'.DOMAIN_NAME.'/'.$url; } function getUrlsFromIdHard($id_hard) { $clean['id_hard'] = (int)$id_hard; $urlView = "http://".DOMAIN_NAME; $urlTalk = "http://".DOMAIN_NAME; $hard = new HardwareModel(); $res = $hard->select('type,model')->where(array('id_hard'=>$clean['id_hard']))->send(); if (count($res) > 0) { $urlView = "http://".DOMAIN_NAME."/".MyStrings::$reverse[$res[0]['hardware']['type']]."/view/".Lang::$current."/".$clean['id_hard']."/".encodeUrl($res[0]['hardware']['model']); $urlTalk = "http://".DOMAIN_NAME."/".MyStrings::$reverse[$res[0]['hardware']['type']]."/talk/".Lang::$current."/".$clean['id_hard']; } return array('urlView'=>$urlView,'urlTalk'=>$urlTalk); }