Merge branch 'development' into h-node

1 files changed, 0 insertions, 542 deletions

diff --git a/h-source/Application/Include/myFunctions.php b/h-source/Application/Include/myFunctions.php
deleted file mode 100644
index b121424..0000000
--- a/h-source/Application/Include/myFunctions.php
+++ /dev/null
@@ -1,542 +0,0 @@
-<?php
-
-// h-source, a web software to build a community of people that want to share their hardware information.
-// Copyright (C) 2010  Antonio Gallo (h-source-copyright.txt)
-//
-// This file is part of h-source
-//
-// h-source is free software: you can redistribute it and/or modify
-// it under the terms of the GNU General Public License as published by
-// the Free Software Foundation, either version 3 of the License, or
-// (at your option) any later version.
-// 
-// h-source is distributed in the hope that it will be useful,
-// but WITHOUT ANY WARRANTY; without even the implied warranty of
-// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-// GNU General Public License for more details.
-// 
-// You should have received a copy of the GNU General Public License
-// along with h-source.  If not, see <http://www.gnu.org/licenses/>.
-
-if (!defined('EG')) die('Direct access not allowed!');
-
-function encodeUrl($url)
-{
-	$url = str_replace(' ','-',$url);
-	$url = str_replace('.','-',$url);
-	$url = str_replace(',','-',$url);
-	$url = str_replace('[','-',$url);
-	$url = str_replace(']','-',$url);
-	$url = str_replace('(','-',$url);
-	$url = str_replace(')','-',$url);
-	$url = str_replace('/','-',$url);
-	$url = str_replace('&#039;','-',$url);
-	$url = str_replace('@','-at-',$url);
-	$url = str_replace('?','-',$url);
-	
-// 	$temp = null;
-// 	for ($i=0;$i<strlen($url); $i++)
-// 	{
-// 		if (strcmp($url[$i],' ') === 0)
-// 		{
-// 			$temp .= '-';
-// 		}
-// 		else
-// 		{
-// 			if (preg_match('/^[a-zA-Z0-9\-]$/',$url[$i])) $temp .= $url[$i];
-// 		}
-// 	}
-
-// 	$url = urlencode($url);
-// 	$url = urlencode($url);
-	return $url;
-}
-
-function titleForRedirect($title)
-{
-	return html_entity_decode(encodeUrl($title),ENT_QUOTES,DEFAULT_CHARSET);
-}
-
-// function encodeUrl($url)
-// {
-// 	$url = str_replace(' ','-',$url);
-// 	$url = str_replace('[','-',$url);
-// 	$url = str_replace(']','-',$url);
-// 	$url = str_replace('(','-',$url);
-// 	$url = str_replace(')','-',$url);
-// 	$url = str_replace('/','-',$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')
-{
-	if (strcmp($lang,'en'))
-	{
-		return date('H:i, j F Y',strtotime($uglyDate));
-	}
-	else
-	{
-		return date('H:i, j ',strtotime($uglyDate)).gtext(date('F',strtotime($uglyDate))).date(' Y',strtotime($uglyDate));
-	}
-}
-
-function pubDateFormat($uglyDate = null)
-{
-	return date('r',strtotime($uglyDate));
-}
-
-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, hardware.id_hard desc';
-			break;
-		case 'compatibility-desc':
-                        $orderBy = 'compatibility desc, hardware.id_hard desc';
-                        break;
-		case 'wifi-works':
-			$orderBy = 'wifi_works desc, hardware.id_hard desc';
-			break;
-		case 'video-card-works':
-                        $orderBy = 'video_card_works desc, hardware.id_hard desc';
-                        break;
-		case 'sound-card-works':
-                        $orderBy = 'sound_card_works desc, hardware.id_hard desc';
-                        break;
-		case 'webcam-works':
-                        $orderBy = 'webcam_works desc, hardware.id_hard desc';
-                        break;
-		case 'bluetooth-works':
-                        $orderBy = 'bluetooth_works desc, hardware.id_hard desc';
-                        break;
-		case 'fingerprint-works':
-                        $orderBy = 'fingerprint_works desc, hardware.id_hard desc';
-                        break;
-		case 'ethernet-works':
-                        $orderBy = 'ethernet_card_works desc, hardware.id_hard desc';
-                        break;
-		case 'sdcard-works':
-                        $orderBy = 'sd_card_works desc, hardware.id_hard desc';
-                        break;
-		case 'undef':
-			$orderBy = 'compatibility, hardware.id_hard desc';
-			break;
-		default:
-			$orderBy = 'compatibility, hardware.id_hard desc';
-	}
-	return $orderBy;
-}
-
-//remove empty elements
-function removeEmptyStrings($oArray)
-{
-	$nArray = array();
-	foreach ($oArray as $oValue)
-	{
-		if (strcmp($oValue,'') !== 0)
-		{
-			$nArray[] = $oValue;
-		}
-	}
-	return $nArray;
-}
-
-function diff($old, $new)
-{
-	$maxlen = 0;
-	foreach($old as $oindex => $ovalue)
-	{
-			$nkeys = array_keys($new, $ovalue);
-// 			echo memory_get_peak_usage(true)."<br />";
-			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(removeEmptyStrings(explode(' ', $old)),removeEmptyStrings(explode(' ', $new)));
-	foreach($diff as $k)
-	{
-			if(is_array($k))
-					$ret .= (!empty($k['d'])?"<del>".implode(' ',$k['d'])."</del> ":'').
-							(!empty($k['i'])?"<ins>".implode(' ',$k['i'])."</ins> ":'');
-			else $ret .= $k . ' ';
-	}
-	return $ret;
-}
-
-
-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 "<a href='".Url::getRoot()."meet/user/".Lang::$current."/$user'>$user</a>";
-	}
-}
-
-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 "<b>duplication</b> of the model having id <b><a href='".Url::getRoot().$controller."/view/".Lang::$current."/".$clean['id_hard']."/".$name."'>".$clean['id_hard']."</a></b>";
-	}
-	else
-	{
-		return "<b>".$row['deletion']['object']."</b>";
-	}
-}
-
-//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;
-}
-
-function singular($string)
-{
-	if (isset(Lang::$singular[Lang::$current][$string]))
-	{
-		return Lang::$singular[Lang::$current][$string];
-	}
-	return $string;
-}
-
-function plural($string)
-{
-	if (isset(Lang::$plural[Lang::$current][$string]))
-	{
-		return Lang::$plural[Lang::$current][$string];
-	}
-	return $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 count($res) > 0 ? $res[0]['hardware'] : null;
-}
-
-//get hardware info from id
-function getHardwareInfoFromId($id = 0)
-{
-	$clean['id'] = (int)$id;
-	$hw = new HardwareModel();
-	$res = $hw->select()->where(array('id_hard'=>$clean['id']))->send();
-	$controller = 'home/index/en';
-	$model = '';
-	if (count($res) > 0)
-	{
-		$controller = Hardware::getControllerFromType($res[0]['hardware']['type']);
-		$controller = strcmp($controller,'') !== 0 ? $controller : 'home/index/en';
-		$model = $res[0]['hardware']['model'];
-	}
-	
-	return array('controller'=>$controller,'model'=>$model);
-}
-
-//get the wiki page info from the talk id
-function getWikiPageInfoFromTalkId($id = 0)
-{
-	$clean['id'] = (int)$id;
-	$talk = new WikitalkModel();
-	$res = $talk->select('wiki.id_wiki')->from('wiki inner join wiki_talk')->using('id_wiki')->where(array('id_talk'=>$clean['id']))->send();
-	return count($res) > 0 ? $res[0]['wiki']['id_wiki'] : '';
-}
-
-//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 count($res) > 0 ? $res[0] : '';
-}
-
-//get thw wiki name from the id
-function getWikiNameFromId($id = 0)
-{
-	$clean['id'] = (int)$id;
-	$wiki = new WikiModel();
-	$name = $wiki->getTheModelName($clean['id']);
-	return $name;
-}
-
-//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']);
-			if (isset($hardInfo))
-			{
-				$controller = Hardware::$typeToController[$hardInfo['type']];
-				$url = $controller.'/talk/'.Lang::$current.'/'.$hardInfo['id_hard'].'#talk-'.$row['id'];
-			}
-			else
-			{
-				$url = 'last/modactions/'.Lang::$current;
-			}
-			break;
-		case 'user':
-			$url = 'meet/user/'.Lang::$current.'/'.getUserName($row['id']);
-			break;
-		case 'issue':
-			$url = 'issues/view/'.Lang::$current.'/'.$row['id'];
-			break;
-		case 'issue_del':
-			$url = 'issues/view/'.Lang::$current.'/'.$row['id'];
-			break;
-		case 'wiki_talk':
-			$url = 'wiki/talk/'.Lang::$current.'/'.getWikiPageInfoFromTalkId($row['id']).'#wiki-talk-'.$row['id'];
-			break;
-		case 'page':
-			$url = 'wiki/page/'.Lang::$current.'/'.encodeUrl(getWikiNameFromId($row['id']));
-			break;
-		case 'page_del':
-			$url = 'wiki/page/'.Lang::$current.'/'.encodeUrl(getWikiNameFromId($row['id']));
-			break;
-		case 'device':
-			$hardInfo = getHardwareInfoFromId($row['id']);
-			$url = $hardInfo['controller'].'/view/'.Lang::$current.'/'.$row['id'].'/'.encodeUrl($hardInfo['model']);
-			break;
-		case 'device_app':
-			$hardInfo = getHardwareInfoFromId($row['id']);
-			$url = $hardInfo['controller'].'/view/'.Lang::$current.'/'.$row['id'].'/'.encodeUrl($hardInfo['model']);
-			break;
-		case 'device_cl':
-			$hardInfo = getHardwareInfoFromId($row['id']);
-			$url = $hardInfo['controller'].'/view/'.Lang::$current.'/'.$row['id'].'/'.encodeUrl($hardInfo['model']);
-			break;
-		case 'message_ins':
-			$url = 'issues/view/'.Lang::$current.'/'.getIssueNumberFromMessageId($row['id']).'#message-'.$row['id'];
-			break;
-		case 'wiki_talk_ins':
-			$url = 'wiki/talk/'.Lang::$current.'/'.getWikiPageInfoFromTalkId($row['id']).'#wiki-talk-'.$row['id'];
-			break;
-		case 'issue_ins':
-			$url = 'issues/view/'.Lang::$current.'/'.$row['id'];
-			break;
-		case 'talk_ins':
-			$hardInfo = getHardwareInfoFromTalkId($row['id']);
-			if (isset($hardInfo))
-			{
-				$controller = Hardware::$typeToController[$hardInfo['type']];
-				$url = $controller.'/talk/'.Lang::$current.'/'.$hardInfo['id_hard'].'#talk-'.$row['id'];
-			}
-			else
-			{
-				$url = 'last/modactions/'.Lang::$current;
-			}
-			break;
-		case 'hardware':
-			$hardInfo = getHardwareInfoFromId($row['id']);
-			$url = $hardInfo['controller'].'/view/'.Lang::$current.'/'.$row['id'].'/'.encodeUrl($hardInfo['model']);
-			break;
-		case 'wiki':
-			$url = 'wiki/page/'.Lang::$current.'/'.encodeUrl(getWikiNameFromId($row['id']));
-			break;
-	}
-	return Url::getRoot($url);
-}
-
-function getUrlsFromIdHard($id_hard)
-{
-	$clean['id_hard'] = (int)$id_hard;
-	
-	$urlView = $urlTalk = Url::getRoot();
-
-	$deviceName = null;
-	
-	$hard = new HardwareModel();
-	$res = $hard->select('type,model')->where(array('id_hard'=>$clean['id_hard']))->send();
-	if (count($res) > 0)
-	{
-		$urlView = Url::getRoot().Hardware::$typeToController[$res[0]['hardware']['type']]."/view/".Lang::$current."/".$clean['id_hard']."/".encodeUrl($res[0]['hardware']['model']);
-		
-		$urlTalk = Url::getRoot().Hardware::$typeToController[$res[0]['hardware']['type']]."/talk/".Lang::$current."/".$clean['id_hard'];
-
-		$deviceName = $res[0]['hardware']['model'];
-	}
-	
-	return array('urlView'=>$urlView,'urlTalk'=>$urlTalk,'modelName'=>$deviceName);
-	
-}
-
-function getDiffArray($associativeArray, $oldArray, $newArray)
-{
-	$diffArray = array();
-	foreach ($associativeArray as $field => $label)
-	{
-		if (array_key_exists($field,$oldArray) and array_key_exists($field,$newArray))
-		{
-			$diffArray[$label] = htmlDiff($oldArray[$field], $newArray[$field]);
-		}
-	}
-	return $diffArray;
-}
-
-//get the translation function
-function getTranslationFunction($fieldName)
-{
-	$fieldsFunc = array(
-		"vendor"	=>	"betterVendor",
-		"interface"	=>	"translate_and_gtext",
-		"subtype"	=>	"translate_and_gtext",
-	);
-
-	if (array_key_exists($fieldName,$fieldsFunc))
-	{
-		return $fieldsFunc[$fieldName];
-	}
-
-	return "gtext";
-}
-
-//Map db type names to display names
-function displayName($name) { 
-	switch ($name) {
-		case '3G-card':
-			$name = '3G cards';
-			break;
-		case 'bluetooth':
-			$name = 'Bluetooth';
-			break;
-		case 'ethernet-card':
-			$name = 'Ethernet cards';
-			break;
-		case 'fingerprint-reader':
-			$name = 'Fingerprint readers';
-			break;
-		case 'host-controller':
-			$name = 'Host Controllers';
-			break;
-		case 'modem':
-			$name = 'Modems';
-			break;
-		case 'notebook':
-			$name = 'Notebooks';
-			break;
-		case 'printer':
-			$name = 'Printers';
-			break;
-		case 'RAID-adapter';
-			$name = 'RAID adapters';
-			break;
-		case 'scanner':
-			$name = 'Scanners';
-			break;
-		case 'sd-card-reader':
-			$name = 'SD card readers';
-			break;
-		case 'soundcard':
-			$name = 'Sound cards';
-			break;
-		case 'videocard':
-			$name = 'Video cards';
-			break;
-		case 'webcam':
-			$name = 'Webcams';
-			break;
-		case 'wifi':
-			$name = 'Wifi cards';
-			break;
-		case 'acquisition-card':
-			$name = 'Acquisition cards';
-			break;
-	}
-	return $name;
-}