===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
spotweb-20130826+dfsg3/Math/BigInteger.php-1849- *
spotweb-20130826+dfsg3/Math/BigInteger.php:1850: * Calculates $x%$n, where $n = 2**$e, for some $e. Since this is basically the same as doing $x & ($n-1),
spotweb-20130826+dfsg3/Math/BigInteger.php-1851- * we'll just use this function as a wrapper for doing that.
##############################################
spotweb-20130826+dfsg3/index.php-70- SpotTiming::start('auth');
spotweb-20130826+dfsg3/index.php:71: $spotUserSystem = new SpotUserSystem($db, $settings);
spotweb-20130826+dfsg3/index.php-72- if ($req->doesExist('apikey')) {
##############################################
spotweb-20130826+dfsg3/install.php-126- <tr> <th> Include files </th> <th> Result </th> </tr>
spotweb-20130826+dfsg3/install.php:127: <tr> <td> Settings file </td> <td> <?php $result=testInclude("settings.php"); echo showResult($result, true, $result); ?> </td> </tr>
spotweb-20130826+dfsg3/install.php:128: <tr> <td> Own settings file </td> <td> <?php $result=testInclude("ownsettings.php"); echo showResult($result, true, $result, "optional"); ?> </td> </tr>
spotweb-20130826+dfsg3/install.php-129- </table>
##############################################
spotweb-20130826+dfsg3/install.php-436- */
spotweb-20130826+dfsg3/install.php:437: $spotUserSystem = new SpotUserSystem($db, new SpotSettings(array()));
spotweb-20130826+dfsg3/install.php-438- $errorList = $spotUserSystem->validateUserRecord($form, false);
##############################################
spotweb-20130826+dfsg3/install.php-543- */
spotweb-20130826+dfsg3/install.php:544: $spotUserSystem = new SpotUserSystem($db, $spotSettings);
spotweb-20130826+dfsg3/install.php-545- $spotUser = $_SESSION['spotsettings']['adminuser'];
##############################################
spotweb-20130826+dfsg3/install.php-685-
spotweb-20130826+dfsg3/install.php:686: function testInclude($fname) {
spotweb-20130826+dfsg3/install.php:687: @include_once($fname);
spotweb-20130826+dfsg3/install.php-688- foreach (get_included_files() as $filename) {
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-104- // Execute (save responce to var for manual following redirects)
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:105: $header = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-106-
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-204- // Execute
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:205: $body = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-206-
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-299- // Execute
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:300: $body = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-301-
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-462- // Execute
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:463: $body = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-464-
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-547- // Execute
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:548: $body = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-549-
##############################################
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-592- // Execute
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php:593: $body = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotAlternateDownload.php-594-
##############################################
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php-143- function createXsrfSecret() {
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php:144: $userSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php-145- $secret = substr($userSystem->generateUniqueId(), 0, 8);
##############################################
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php-153- function createPasswordSalt() {
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php:154: $userSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotSettingsUpgrader.php-155- $salt = $userSystem->generateUniqueId() . $userSystem->generateUniqueId();
##############################################
spotweb-20130826+dfsg3/lib/SpotsOverview.php-448- } # if
spotweb-20130826+dfsg3/lib/SpotsOverview.php:449: $response = curl_exec($ch);
spotweb-20130826+dfsg3/lib/SpotsOverview.php-450- SpotTiming::stop(__FUNCTION__ . ':curl', array($response));
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-17- function removeOldList($listUrl, $idtype) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:18: $this->_conn->modify("DELETE FROM spotteridblacklist WHERE (ouruserid = -1) AND (origin = 'external') AND (idtype = %d)",Array((int) $idtype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:19: $this->_conn->modify("DELETE FROM cache WHERE (resourceid = '%s') AND (cachetype = '%s')", Array(md5($listUrl), SpotCache::Web));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-20- } # removeOldList
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-67- $this->_conn->modify("INSERT INTO spotteridblacklist (spotterid,ouruserid,idtype,origin) VALUES ('%s','-1',%d,'external')", Array($updl, (int) $idtype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:68: $this->_conn->modify("UPDATE spotteridblacklist SET doubled = '%s' WHERE spotterid = '%s'AND ouruserid != -1 AND idtype = %d ", Array($this->_conn->bool2dt(true), $updl, (int) $idtype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-69- } elseif ($updatelist[$updl] == 2) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-71- $countdellistspotterid++;
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:72: $this->_conn->modify("DELETE FROM spotteridblacklist WHERE (spotterid = '%s') AND (ouruserid = -1) AND (origin = 'external')", Array($updl));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:73: $this->_conn->modify("UPDATE spotteridblacklist SET doubled = '%s' WHERE spotterid = '%s' AND ouruserid != -1 AND idtype = %d ", Array($this->_conn->bool2dt(true), $updl, (int) $idtype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-74- } elseif ($updatelist[$updl] == 4) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-75- $countnewlistspotterid++;
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:76: $this->_conn->modify("UPDATE spotteridblacklist SET idtype = 1 WHERE (spotterid = '%s') AND (ouruserid = -1) AND (origin = 'external')", Array($updl));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:77: $this->_conn->modify("UPDATE spotteridblacklist SET doubled = (idtype = 1) WHERE spotterid = '%s' AND ouruserid != -1", Array($updl));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-78- }
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-87- function addSpotterToList($spotterId, $ourUserId, $origin, $idType) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:88: $existInList = $this->_conn->singleQuery("SELECT idtype FROM spotteridblacklist WHERE spotterid = '%s' AND ouruserid = %d", Array($spotterId, (int) $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-89- if (empty($existInList)) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-92- } else {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php:93: $this->_conn->modify("UPDATE spotteridblacklist SET idtype = %d, origin = '%s' WHERE spotterid = '%s' AND ouruserid = %d", Array( (int) $idType, $origin, $spotterId, (int) $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_BlackWhiteList.php-94- }
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-17- function expireCache($expireDays) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php:18: return $this->_conn->modify("DELETE FROM cache WHERE (cachetype = %d OR cachetype = %d OR cachetype = %d) AND stamp < %d", Array(SpotCache::Web, SpotCache::Statistics, SpotCache::StatisticsData,(int) time()-$expireDays*24*60*60));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-19- } # expireCache
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-24- function isCached($resourceid, $cachetype) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php:25: $tmpResult = $this->_conn->singleQuery("SELECT resourceid FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", Array($resourceid, $cachetype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-26-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-33- function getCache($resourceid, $cachetype) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php:34: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-35- if (!empty($tmp)) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-57- function updateCacheStamp($resourceid, $cachetype) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php:58: $this->_conn->exec("UPDATE cache SET stamp = %d WHERE resourceid = '%s' AND cachetype = '%s'", Array(time(), $resourceid, $cachetype));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Cache.php-59- } # updateCacheStamp
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php-28- # Retrieve the database id for the messageid given
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php:29: $commentId = $this->_conn->singleQuery("SELECT id FROM commentsxover WHERE messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php-30-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php-170- LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = f.spotterid) AND (bl.doubled = '%s'))
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php:171: WHERE c.nntpref = '%s' AND ((bl.spotterid IS NULL) OR (((bl.ouruserid = " . $this->_conn->safe( (int) $userId) . ") OR (bl.ouruserid = -1)) AND (bl.idtype = 2)))
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Comment.php-172- ORDER BY c.id", array($this->_conn->bool2dt(false), $nntpRef));
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-18- function setMaxArticleId($server, $maxarticleid) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:19: $this->_conn->exec("UPDATE nntp SET maxarticleid = '%s' WHERE server = '%s'", Array((int) $maxarticleid, $server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-20- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-29- function getMaxArticleId($server) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:30: $artId = $this->_conn->singleQuery("SELECT maxarticleid FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-31- if ($artId == null) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-42- function isRetrieverRunning($server) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:43: $artId = $this->_conn->singleQuery("SELECT nowrunning FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-44- return ((!empty($artId)) && ($artId > (time() - 900)));
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-56-
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:57: $this->_conn->modify("UPDATE nntp SET nowrunning = %d WHERE server = '%s'", Array((int) $runTime, $server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-58- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-66- function setLastUpdate($server) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:67: return $this->_conn->modify("UPDATE nntp SET lastrun = '%d' WHERE server = '%s'", Array(time(), $server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-68- } # getLastUpdate
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-73- function getLastUpdate($server) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php:74: return $this->_conn->singleQuery("SELECT lastrun FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Nntp.php-75- } # getLastUpdate
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php-35- function removeSetting($name) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php:36: $this->_conn->exec("DELETE FROM settings WHERE name = '%s'", Array($name));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php-37- } # removeSetting
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php-50-
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php:51: $this->_conn->exec("UPDATE settings SET value = '%s', serialized = '%s' WHERE name = '%s'", Array($value, $this->_conn->bool2dt($serialized), $name));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Setting.php-52- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php-159- FROM spots AS s
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php:160: WHERE s.messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php-161- SpotTiming::stop(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php-208- JOIN spotsfull AS f ON f.messageid = s.messageid
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php:209: WHERE s.messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_Spot.php-210- if (empty($tmpArray)) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php-18- # vraag eerst het id op
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php:19: $reportId = $this->_conn->singleQuery("SELECT id FROM reportsxover WHERE messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php-20-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php-69- function isReportPlaced($messageid, $userId) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php:70: $tmpResult = $this->_conn->singleQuery("SELECT messageid FROM reportsposted WHERE inreplyto = '%s' AND ouruserid = %d", Array($messageid, $userId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotReport.php-71-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-21-
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php:22: $this->_conn->modify("UPDATE spotstatelist SET " . $list . " = %d WHERE messageid = '%s' AND ouruserid = %d", array($stamp, $messageId, $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-23- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-43- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php:44: $this->_conn->modify("UPDATE spotstatelist SET seen = NULL WHERE (ouruserid = %d) AND (download IS NULL) AND (watch IS NULL) ", array( (int) $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php:45: $this->_conn->modify("UPDATE spotstatelist SET seen = %d WHERE (ouruserid = %d) AND (download IS NOT NULL) OR (watch IS NOT NULL) ", array( (int) time(), (int) $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-46- SpotTiming::stop(__FUNCTION__, array($ourUserId));
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-53- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php:54: $this->_conn->modify("UPDATE spotstatelist SET download = NULL WHERE ouruserid = %d", array( (int) $ourUserId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_SpotStateList.php-55- SpotTiming::stop(__FUNCTION__, array($ourUserId));
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-18- function findUserIdForName($username) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:19: return $this->_conn->singleQuery("SELECT id FROM users WHERE username = '%s'", Array($username));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-20- } # findUserIdForName
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-25- function userEmailExists($mail) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:26: $tmpResult = $this->_conn->singleQuery("SELECT id FROM users WHERE mail = '%s'", Array($mail));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-27-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-233- */
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:234: $user['userid'] = $this->_conn->singleQuery("SELECT id FROM users WHERE username = '%s'", Array($user['username']));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-235-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-251- if ($username === false) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:252: $tmp = $this->_conn->arrayQuery("SELECT id FROM users WHERE apikey = '%s' AND NOT DELETED", Array($passhash));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-253- } else {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:254: $tmp = $this->_conn->arrayQuery("SELECT id FROM users WHERE username = '%s' AND passhash = '%s' AND NOT DELETED", Array($username, $passhash));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-255- } # if
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-267- function setUserAvatar($userId, $imageEncoded) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:268: $this->_conn->modify("UPDATE usersettings SET avatar = '%s' WHERE userid = %d", Array( $imageEncoded, (int) $userId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-269- } # setUserAvatar
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-344- function getSecurityGroup($groupId) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:345: return $this->_conn->arrayQuery("SELECT id,name FROM securitygroups WHERE id = %d", Array($groupId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-346- } # getSecurityGroup
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-351- function setSecurityGroup($group) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:352: $this->_conn->modify("UPDATE securitygroups SET name = '%s' WHERE id = %d", Array($group['name'], $group['id']));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-353- } # setSecurityGroup
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-365- function removeSecurityGroup($group) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:366: $this->_conn->modify("DELETE FROM securitygroups WHERE id = %d", Array($group['id']));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-367- } # removeSecurityGroup
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-373- # We wissen eerst huidige group membership
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php:374: $this->_conn->modify("DELETE FROM usergroups WHERE userid = %d", array($userId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_User.php-375-
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php-72- function removeAllFilters($userId) {
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php:73: $this->_conn->modify("DELETE FROM filters WHERE userid = %d", Array((int) $userId));
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php-74- } # removeAllfilters
##############################################
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php-172- FROM filters
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php:173: WHERE userid = %d " . $filterTypeFilter . "
spotweb-20130826+dfsg3/lib/dao/Base/Dao_Base_UserFilter.php-174- ORDER BY tparent,torder", /* was: id, tparent, torder */
##############################################
spotweb-20130826+dfsg3/lib/dao/Mysql/Dao_Mysql_Cache.php-22- function getCache($resourceid, $cachetype) {
spotweb-20130826+dfsg3/lib/dao/Mysql/Dao_Mysql_Cache.php:23: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, UNCOMPRESS(content) AS content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/lib/dao/Mysql/Dao_Mysql_Cache.php-24-
##############################################
spotweb-20130826+dfsg3/lib/dao/Postgresql/Dao_Postgresql_Cache.php-32- function getCache($resourceid, $cachetype) {
spotweb-20130826+dfsg3/lib/dao/Postgresql/Dao_Postgresql_Cache.php:33: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/lib/dao/Postgresql/Dao_Postgresql_Cache.php-34- if (!empty($tmp)) {
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php-15- */
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php:16: abstract function rawExec($sql);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php-17-
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php-91- */
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php:92: function exec($s, $p = array()) {
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php:93: return $this->rawExec($this->prepareSql($s, $p));
spotweb-20130826+dfsg3/lib/dbeng/dbeng_abs.php-94- } # exec()
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-45-
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php:46: function rawExec($s) {
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-47- SpotTiming::start(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-62-
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php:63: $res = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-64- if (!is_bool($res)) {
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-74-
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php:75: $res = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-76- $row = mysql_fetch_array($res);
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-87-
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php:88: $res = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_mysql.php-89- while ($rows[] = mysql_fetch_assoc($res));
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-57- }
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php:58: public function rawExec($s) {
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-59- SpotTiming::start(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-87- */
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php:88: public function exec($s, $p = array()) {
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-89- SpotTiming::start(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-108-
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php:109: $res = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-110- $res->closeCursor();
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-157- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php:158: $stmt = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-159- $row = $stmt->fetch();
##############################################
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-180- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php:181: $stmt = $this->exec($s, $p);
spotweb-20130826+dfsg3/lib/dbeng/dbeng_pdo.php-182- $tmpArray = $stmt->fetchAll();
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-58- function indexExists($idxname, $tablename) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:59: $q = $this->_dbcon->arrayQuery("SHOW INDEXES FROM " . $tablename . " WHERE key_name = '%s'", Array($idxname));
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-60- return !empty($q);
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-64- function columnExists($tablename, $colname) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:65: $q = $this->_dbcon->arrayQuery("SHOW COLUMNS FROM " . $tablename . " WHERE Field = '%s'", Array($colname));
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-66- return !empty($q);
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-77- if ($idxType == "UNIQUE") {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:78: $this->_dbcon->rawExec("ALTER IGNORE TABLE " . $tablename . " ADD " . $idxType . " INDEX " . $idxname . "(" . implode(",", $colList) . ");");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-79- } else {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:80: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ADD " . $idxType . " INDEX " . $idxname . "(" . implode(",", $colList) . ");");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-81- } # else
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-142- if ($this->indexExists($idxname, $tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:143: $this->_dbcon->rawExec("DROP INDEX " . $idxname . " ON " . $tablename);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-144- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-210- if ($this->columnExists($tablename, $colName)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:211: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP COLUMN " . $colName);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-212- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-229-
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:230: $this->_dbcon->rawExec("CREATE TABLE " . $tablename . " (id INTEGER PRIMARY KEY AUTO_INCREMENT) " . $colSetting);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-231- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-236- if ($this->tableExists($tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:237: $this->_dbcon->rawExec("DROP TABLE " . $tablename);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-238- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-244- FROM information_schema.TABLES
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:245: WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = '" . $tablename . "'");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-246-
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-247- if (strtolower($q) != strtolower($engine)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:248: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ENGINE=" . $engine);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-249- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-253- function renameTable($tablename, $newTableName) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:254: $this->_dbcon->rawExec("RENAME TABLE " . $tablename . " TO " . $newTableName);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-255- } # renameTable
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-266- foreach($q as $res) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:267: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP FOREIGN KEY " . $res['CONSTRAINT_NAME']);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-268- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-280- if (empty($q)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:281: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ADD FOREIGN KEY (" . $colname . ")
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-282- REFERENCES " . $reftable . " (" . $refcolumn . ") " . $action);
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-294- FROM information_schema.COLUMNS
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php:295: WHERE TABLE_NAME = '" . $tablename . "'
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_mysql.php-296- AND COLUMN_NAME = '" . $colname . "'
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-126- case 'UNIQUE': {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:127: $this->_dbcon->rawExec("CREATE UNIQUE INDEX " . $idxname . " ON " . $tablename . "(" . implode(",", $colList) . ")");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-128- break;
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-131- case 'FULLTEXT' : {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:132: $this->_dbcon->rawExec("CREATE INDEX " . $idxname . " ON " . $tablename . " USING gin(to_tsvector('dutch', " . implode(",", $colList) . "))");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-133- break;
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-136- default : {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:137: $this->_dbcon->rawExec("CREATE INDEX " . $idxname . " ON " . $tablename . "(" . implode(",", $colList) . ")");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-138- } # default
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-153- if ($this->indexExists($idxname, $tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:154: $this->_dbcon->rawExec("DROP INDEX " . $idxname);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-155- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-220- # Alter the column type
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:221: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ALTER COLUMN " . $colName . " TYPE " . $colType);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-222-
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-224- if (strlen($colDefault) > 0) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:225: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ALTER COLUMN " . $colName . " SET " . $colDefault);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-226- } else {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:227: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ALTER COLUMN " . $colName . " DROP DEFAULT");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-228- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-231- if (strlen($notNull) > 0) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:232: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ALTER COLUMN " . $colName . " SET NOT NULL");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-233- } else {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:234: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ALTER COLUMN " . $colName . " DROP NOT NULL");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-235- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-240- if ($this->columnExists($tablename, $colName)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:241: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP COLUMN " . $colName);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-242- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-246- function tableExists($tablename) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:247: $q = $this->_dbcon->arrayQuery("SELECT tablename FROM pg_tables WHERE schemaname = CURRENT_SCHEMA() AND (tablename = '%s')", array($tablename));
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-248- return !empty($q);
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-264-
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:265: $this->_dbcon->rawExec("CREATE TABLE " . $tablename . " (id SERIAL PRIMARY KEY) " . $colSetting);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-266- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-271- if ($this->tableExists($tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:272: $this->_dbcon->rawExec("DROP TABLE " . $tablename);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-273- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-282- function renameTable($tablename, $newTableName) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:283: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " RENAME TO " . $newTableName);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-284- } # renameTable
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-308- foreach($q as $res) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:309: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP CONSTRAINT " . $res['constraint_name']);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-310- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-335- if (empty($q)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php:336: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ADD FOREIGN KEY (" . $colname . ")
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_pgsql.php-337- REFERENCES " . $reftable . " (" . $refcolumn . ") " . $action);
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-94- $this->dropTable($ftsname);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:95: $this->_dbcon->rawExec("DROP TRIGGER IF EXISTS " . $ftsname . "_insert");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-96-
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-97- # and recreate the virtual table and link the update trigger to it
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:98: $this->_dbcon->rawExec("CREATE VIRTUAL TABLE " . $ftsname . " USING FTS3(" . implode(',', $colList) . ", tokenize=porter)");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-99-
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:100: $this->_dbcon->rawExec("INSERT INTO " . $ftsname . "(rowid, " . implode(',', $colList) . ") SELECT rowid," . implode(',', $colList) . " FROM " . $tablename);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-101- $this->_dbcon->rawExec("CREATE TRIGGER " . $ftsname . "_insert AFTER INSERT ON " . $tablename . " FOR EACH ROW
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-139- switch(strtolower($idxType)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:140: case '' : $this->_dbcon->rawExec("CREATE INDEX " . $idxname . " ON " . $tablename . "(" . implode(",", $colList) . ");"); break;
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:141: case 'unique' : $this->_dbcon->rawExec("CREATE UNIQUE INDEX " . $idxname . " ON " . $tablename . "(" . implode(",", $colList) . ");"); break;
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-142- } # switch
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-156- if ($this->indexExists($idxname, $tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:157: $this->_dbcon->rawExec("DROP INDEX " . $idxname);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-158- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-201- if (!$this->tableExists($tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:202: $this->_dbcon->rawExec("CREATE TABLE " . $tablename . " (id INTEGER PRIMARY KEY ASC)");
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-203- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-208- if ($this->tableExists($tablename)) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:209: $this->_dbcon->rawExec("DROP TABLE " . $tablename);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-210- } # if
##############################################
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-229- function renameTable($tablename, $newTableName) {
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php:230: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " RENAME TO " . $newTableName);
spotweb-20130826+dfsg3/lib/dbstruct/SpotStruct_sqlite.php-231- } # renameTable
##############################################
spotweb-20130826+dfsg3/lib/images/pchart/pData.class.php-717- $Expression = "\$return = '!'.(".str_replace("z",$i,$Formula).");";
spotweb-20130826+dfsg3/lib/images/pchart/pData.class.php:718: if ( @eval($Expression) === FALSE ) { $return = VOID; }
spotweb-20130826+dfsg3/lib/images/pchart/pData.class.php-719- if ( $return == "!" ) { $return = VOID; } else { $return = $this->right($return,strlen($return)-1); }
##############################################
spotweb-20130826+dfsg3/lib/notifications/boxcar/boxcar_api.php-241-
spotweb-20130826+dfsg3/lib/notifications/boxcar/boxcar_api.php:242: $result = curl_exec ($ch);
spotweb-20130826+dfsg3/lib/notifications/boxcar/boxcar_api.php-243-
##############################################
spotweb-20130826+dfsg3/lib/notifications/nma/class.nma.php-150-
spotweb-20130826+dfsg3/lib/notifications/nma/class.nma.php:151: $return = curl_exec($this->_obj_curl);
spotweb-20130826+dfsg3/lib/notifications/nma/class.nma.php-152- curl_close($this->_obj_curl);
##############################################
spotweb-20130826+dfsg3/lib/notifications/prowl/Connector.php-406-
spotweb-20130826+dfsg3/lib/notifications/prowl/Connector.php:407: $sReturn = curl_exec($this->rCurl);
spotweb-20130826+dfsg3/lib/notifications/prowl/Connector.php-408- curl_close($this->rCurl);
##############################################
spotweb-20130826+dfsg3/lib/notifications/prowl/SecureConnector.php-90-
spotweb-20130826+dfsg3/lib/notifications/prowl/SecureConnector.php:91: $sReturn = curl_exec($this->rCurl);
spotweb-20130826+dfsg3/lib/notifications/prowl/SecureConnector.php-92- curl_close($this->rCurl);
##############################################
spotweb-20130826+dfsg3/lib/notifications/twitter/twitteroauth.php-224- curl_setopt($ci, CURLOPT_URL, $url);
spotweb-20130826+dfsg3/lib/notifications/twitter/twitteroauth.php:225: $response = curl_exec($ci);
spotweb-20130826+dfsg3/lib/notifications/twitter/twitteroauth.php-226- $this->http_code = curl_getinfo($ci, CURLINFO_HTTP_CODE);
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Clientsabnzbd.php-22- {
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Clientsabnzbd.php:23: $title = urlencode($this->cleanForFileSystem($spot['title']));
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Clientsabnzbd.php-24- $category = urlencode($this->convertCatToSabnzbdCat($spot));
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php-22- {
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php:23: $filename = $this->cleanForFileSystem($fullspot['title']) . '.nzb';
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php-24- # nzbget does not support zip files, must merge
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php-325-
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php:326: $name = cleanForFileSystem($name);
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Nzbget.php-327-
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Pushsabnzbd.php-24- $nzb = $this->prepareNzb($fullspot, $nzblist);
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Pushsabnzbd.php:25: $title = urlencode($this->cleanForFileSystem($fullspot['title']));
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Pushsabnzbd.php-26- $category = urlencode($this->convertCatToSabnzbdCat($fullspot));
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Runcommand.php-43- # execute the command
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Runcommand.php:44: exec($cmdToRun, $saveOutput, $status);
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_Runcommand.php-45-
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-66- */
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php:67: protected function cleanForFileSystem($title)
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-68- {
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-90- # add category to path als dat gevraagd is
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php:91: $path = str_replace('$SABNZBDCAT', $this->cleanForFileSystem($category), $path);
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-92-
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-142- $result['mimetype'] = 'application/x-nzb';
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php:143: $result['filename'] = $this->cleanForFileSystem($fullspot['title']) . '.nzb';
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-144- break;
##############################################
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-209- foreach($nzbList as $nzb) {
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php:210: $zip->addFromString($this->cleanForFileSystem($nzb['spot']['title']) . '.nzb', $nzb['nzb']);
spotweb-20130826+dfsg3/lib/nzbhandler/NzbHandler_abs.php-211- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_blacklistspotter.php-33- # Make sure the anonymous user and reserved usernames cannot post content
spotweb-20130826+dfsg3/lib/page/SpotPage_blacklistspotter.php:34: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_blacklistspotter.php-35- if (!$spotUserSystem->allowedToPost($this->_currentSession['user'])) {
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_catsjson.php-95- /* First parse the search string so we know which items to select and which not */
spotweb-20130826+dfsg3/lib/page/SpotPage_catsjson.php:96: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_catsjson.php-97- $spotsOverview = new SpotsOverview($this->_db, $this->_settings);
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_createuser.php-27- # Instantieer het Spot user system
spotweb-20130826+dfsg3/lib/page/SpotPage_createuser.php:28: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_createuser.php-29-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_editfilter.php-32- # Instantieer het Spot user system
spotweb-20130826+dfsg3/lib/page/SpotPage_editfilter.php:33: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_editfilter.php-34-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_editsecgroup.php-22- # Instantieer het Spot user system
spotweb-20130826+dfsg3/lib/page/SpotPage_editsecgroup.php:23: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_editsecgroup.php-24-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_edituser.php-43- # Instantiate the spotuser object
spotweb-20130826+dfsg3/lib/page/SpotPage_edituser.php:44: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_edituser.php-45-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_edituserprefs.php-28- # Instantiat the user system as necessary for the management of user preferences
spotweb-20130826+dfsg3/lib/page/SpotPage_edituserprefs.php:29: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_edituserprefs.php-30-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_index.php-33- # en sorteringen etc
spotweb-20130826+dfsg3/lib/page/SpotPage_index.php:34: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_index.php-35- $parsedSearch = $spotsOverview->filterToQuery($this->_params['search'],
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_login.php-27- # Instantieer het Spot user system
spotweb-20130826+dfsg3/lib/page/SpotPage_login.php:28: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_login.php-29-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_logout.php-8- # Instanatiate the spotweb user system
spotweb-20130826+dfsg3/lib/page/SpotPage_logout.php:9: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_logout.php-10-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_markallasread.php-8- # en update het user record
spotweb-20130826+dfsg3/lib/page/SpotPage_markallasread.php:9: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_markallasread.php-10-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_newznabapi.php-178-
spotweb-20130826+dfsg3/lib/page/SpotPage_newznabapi.php:179: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_newznabapi.php-180- $parsedSearch = $spotsOverview->filterToQuery($search, array('field' => 'stamp', 'direction' => 'DESC'), $this->_currentSession,
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_postcomment.php-46- # Make sure the anonymous user and reserved usernames cannot post content
spotweb-20130826+dfsg3/lib/page/SpotPage_postcomment.php:47: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_postcomment.php-48- if (!$spotUser->allowedToPost($this->_currentSession['user'])) {
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_postspot.php-50- # Make sure the anonymous user and reserved usernames cannot post content
spotweb-20130826+dfsg3/lib/page/SpotPage_postspot.php:51: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_postspot.php-52- if (!$spotUser->allowedToPost($this->_currentSession['user'])) {
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_reportpost.php-43- # Make sure the anonymous user and reserved usernames cannot post content
spotweb-20130826+dfsg3/lib/page/SpotPage_reportpost.php:44: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_reportpost.php-45- if (!$spotUser->allowedToPost($this->_currentSession['user'])) {
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_rss.php-24- # en sorteringen etc
spotweb-20130826+dfsg3/lib/page/SpotPage_rss.php:25: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_rss.php-26- $parsedSearch = $spotsOverview->filterToQuery($this->_params['search'],
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_statistics.php-15- $spotsOverview = new SpotsOverview($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_statistics.php:16: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_statistics.php-17-
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_twitteroauth.php-16- # Instantieer het Spot user system & notificatiesysteem
spotweb-20130826+dfsg3/lib/page/SpotPage_twitteroauth.php:17: $spotUserSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/page/SpotPage_twitteroauth.php-18- $spotsNotifications = new SpotNotifications($this->_db, $this->_settings, $this->_currentSession);
##############################################
spotweb-20130826+dfsg3/lib/page/SpotPage_Abs.php-100- if (file_exists($tplPath . $tpl . '.inc.php')) {
spotweb-20130826+dfsg3/lib/page/SpotPage_Abs.php:101: require_once($tplPath . $tpl . '.inc.php');
spotweb-20130826+dfsg3/lib/page/SpotPage_Abs.php-102-
##############################################
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-365- function allowedToPost() {
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php:366: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-367- return $spotUser->allowedToPost($this->_currentSession['user']);
##############################################
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1117- function getUserFilterList() {
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php:1118: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1119- return $spotUser->getFilterList($this->_currentSession['user']['userid'], 'filter');
##############################################
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1125- function getUserFilter($filterId) {
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php:1126: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1127- return $spotUser->getFilter($this->_currentSession['user']['userid'], $filterId);
##############################################
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1133- function getIndexFilter() {
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php:1134: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/lib/SpotTemplateHelper.php-1135- return $spotUser->getIndexFilter($this->_currentSession['user']['userid']);
##############################################
spotweb-20130826+dfsg3/lib/SpotClassAutoload.php-25- if (count($parts) == 2) {
spotweb-20130826+dfsg3/lib/SpotClassAutoload.php:26: require_once ('lib/' . strtolower($parts[0]) . '/' . $class_name . '.php');
spotweb-20130826+dfsg3/lib/SpotClassAutoload.php-27- } else {
spotweb-20130826+dfsg3/lib/SpotClassAutoload.php:28: require_once ('lib/' . strtolower($parts[0]) . '/' . $parts[1] . '/' . $class_name . '.php');
spotweb-20130826+dfsg3/lib/SpotClassAutoload.php-29- } # else
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-64- $dbCon->exec("UPDATE users SET id = 1 WHERE username = 'anonymous'");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:65: $dbCon->exec("UPDATE usersettings SET userid = 1 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-66- } # createAnonymous
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-129- $dbCon->exec("UPDATE users SET id = 2 WHERE username = 'admin'");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:130: $dbCon->exec("UPDATE usersettings SET userid = 2 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-131- } # createAdmin
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-146- */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:147: $dbCon->rawExec("DELETE FROM usergroups WHERE userid = " . $user['userid']);
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-148-
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-163- # Admin user
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:164: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:165: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:166: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:167: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-168- } else {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-169- # Grant the regular users all the necessary security groups
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:170: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:171: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-172-
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-174- if (($systemType == 'shared') || ($systemType == 'single')) {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:175: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-176- } # if
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-179- if ($systemType == 'single') {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:180: $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-181- } # if
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-356- foreach($anonPerms as $anonPerm) {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:357: $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(2, " . $anonPerm . ")");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-358- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-368- foreach($authedPerms as $authedPerm) {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:369: $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(3, " . $authedPerm . ")");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-370- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-415- foreach($adminPerms as $adminPerm) {
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:416: $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(5, " . $adminPerm . ")");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-417- } # foreach
##############################################
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-455- /* Image */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:456: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Image', 'film', 0, 0, 'cat0_z0')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-457- $beeldFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:458: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DivX', 'divx', 0, " . $beeldFilterId . ", 'cat0_z0_a0')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:459: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'WMV', 'wmv', 1, " . $beeldFilterId . ", 'cat0_z0_a1')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:460: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'MPEG', 'mpg', 2, " . $beeldFilterId . ", 'cat0_z0_a2')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:461: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DVD', 'dvd', 3, " . $beeldFilterId . ", 'cat0_z0_a3,cat0_z0_a10')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:462: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'HD', 'hd', 4, " . $beeldFilterId . ", 'cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:463: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Series', 'tv', 5, " . $beeldFilterId . ", 'cat0_z1')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-464-
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-465- /* Books */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:466: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Books', 'book', 6, " . $beeldFilterId . ", 'cat0_z2')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-467- $boekenFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:468: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Dutch', 'book', 0, " . $boekenFilterId . ", 'cat0_z2_c11')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:469: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'English', 'book', 1, " . $boekenFilterId . ", 'cat0_z2_c10')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:470: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Others', 'book', 2, " . $boekenFilterId . ", 'cat0_z2,~cat0_z2_c10,~cat0_z2_c11')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-471-
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-472- /* Erotica */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:473: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Erotica', 'female', 7, " . $beeldFilterId. ", 'cat0_z3')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-474- $erotiekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:475: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Hetero', 'female', 0, " . $erotiekFilterId . ", 'cat0_z3_d75,cat0_z3_d23')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:476: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay male', 'female', 1, " . $erotiekFilterId . ", 'cat0_z3_d74,cat0_z3_d24')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:477: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay female', 'female', 2, " . $erotiekFilterId . ", 'cat0_z3_d73,cat0_z3_d25')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:478: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Bi', 'female', 3, " . $erotiekFilterId . ", 'cat0_z3_d72,cat0_z3_d26')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-479-
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-480- /* Music */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:481: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Sounds', 'music', 2, 0, 'cat1')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-482- $muziekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:483: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Compressed', 'music', 0, " . $muziekFilterId . ", 'cat1_a0,cat1_a3,cat1_a5,cat1_a6')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:484: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lossless', 'music', 1, " . $muziekFilterId . ", 'cat1_a2,cat1_a4,cat1_a7,cat1_a8')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-485-
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-486- /* Games */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:487: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Games', 'controller', 3, 0, 'cat2')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-488- $gameFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:489: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'windows', 0, " . $gameFilterId . ", 'cat2_a0')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:490: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux', 'linux', 1, " . $gameFilterId . ", 'cat2_a1,cat2_a2')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:491: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Playstation', 'playstation', 2, " . $gameFilterId . ", 'cat2_a3,cat2_a4,cat2_a5,cat2_a12')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:492: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'XBox', 'xbox', 3, " . $gameFilterId . ", 'cat2_a6,cat2_a7')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:493: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nintendo', 'nintendo_ds', 4, " . $gameFilterId . ", 'cat2_a8,cat2_a9,cat2_a10,cat2_a11')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:494: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Smartphone / PDA', 'pda', 5, " . $gameFilterId . ", 'cat2_a13,cat2_a14,cat2_a15')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-495-
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-496- /* Applications */
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:497: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Applications', 'application', 4, 0, 'cat3')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-498- $appFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:499: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'vista', 0, " . $appFilterId . ", 'cat3_a0')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:500: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux / OS2', 'linux', 1, " . $appFilterId . ", 'cat3_a1,cat3_a2,cat3_a3')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php:501: $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'PDA / Navigation', 'pda', 2, " . $appFilterId . ", 'cat3_a4,cat3_a5,cat3_a6,cat3_a7')");
spotweb-20130826+dfsg3/lib/SpotUserUpgrader.php-502- } # foreach
##############################################
spotweb-20130826+dfsg3/retrieve.php-70-# het admin-account op
spotweb-20130826+dfsg3/retrieve.php:71:$spotUserSystem = new SpotUserSystem($db, $settings);
spotweb-20130826+dfsg3/retrieve.php-72-if (!SpotCommandline::isCommandline()) {
##############################################
spotweb-20130826+dfsg3/tests/testInsert.php-22-
spotweb-20130826+dfsg3/tests/testInsert.php:23: mysql_query($sql);
spotweb-20130826+dfsg3/tests/testInsert.php-24-
##############################################
spotweb-20130826+dfsg3/tests/testPost.php-30-$spotPosting = new SpotPosting($db, $spotSettings);
spotweb-20130826+dfsg3/tests/testPost.php:31:$spotUserSystem = new SpotUserSystem($db, $spotSettings);
spotweb-20130826+dfsg3/tests/testPost.php-32-
##############################################
spotweb-20130826+dfsg3/tests/testRead.php-29-$spotPosting = new SpotPosting($db, $spotSettings);
spotweb-20130826+dfsg3/tests/testRead.php:30:$spotUserSystem = new SpotUserSystem($db, $spotSettings);
spotweb-20130826+dfsg3/tests/testRead.php-31-
##############################################
spotweb-20130826+dfsg3/utils/transifex/README.md-49-2. Install gettext: `brew install gettext`
spotweb-20130826+dfsg3/utils/transifex/README.md:50:3. `msgfmt` won't be in your path, so run: `$(brew --prefix gettext)/bin/msgfmt`
spotweb-20130826+dfsg3/utils/transifex/README.md-51-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/Math/BigInteger.php-1849- *
spotweb-20130826+dfsg3/debian/db-update/v20111210/Math/BigInteger.php:1850: * Calculates $x%$n, where $n = 2**$e, for some $e. Since this is basically the same as doing $x & ($n-1),
spotweb-20130826+dfsg3/debian/db-update/v20111210/Math/BigInteger.php-1851- * we'll just use this function as a wrapper for doing that.
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-32- if ($user['userid'] > 2) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:33: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 1, 1)");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:34: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 2)");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-35- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-78- $dbCon->exec("UPDATE users SET id = 1 WHERE username = 'anonymous'");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:79: $dbCon->exec("UPDATE usersettings SET userid = 1 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-80-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-123- $dbCon->exec("UPDATE users SET id = 2 WHERE username = 'admin'");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:124: $dbCon->exec("UPDATE usersettings SET userid = 2 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-125-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-258- foreach($anonPerms as $anonPerm) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:259: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(1, " . $anonPerm . ")");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-260- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-268- foreach($authedPerms as $authedPerm) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:269: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(2, " . $authedPerm . ")");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-270- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-274- foreach($adminPerms as $adminPerm) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:275: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(3, " . $adminPerm . ")");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-276- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-440- /* Beeld */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:441: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Beeld', 'film', 0, 0, 'cat0_z0')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-442- $beeldFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:443: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DivX', 'divx', 0, " . $beeldFilterId . ", 'cat0_z0_a0')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:444: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'WMV', 'wmv', 1, " . $beeldFilterId . ", 'cat0_z0_a1')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:445: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'MPEG', 'mpg', 2, " . $beeldFilterId . ", 'cat0_z0_a2')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:446: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DVD', 'dvd', 3, " . $beeldFilterId . ", 'cat0_z0_a3,cat0_z0_a10')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:447: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'HD', 'hd', 4, " . $beeldFilterId . ", 'cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:448: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Series', 'tv', 5, " . $beeldFilterId . ", 'cat0_z1')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-449-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-450- /* Boeken */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:451: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Boeken', 'book', 6, " . $beeldFilterId . ", 'cat0_z2')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-452- $boekenFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:453: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nederlands', 'book', 0, " . $boekenFilterId . ", 'cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:454: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Engels', 'book', 1, " . $boekenFilterId . ", 'cat0_z2_c10')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:455: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Anders', 'book', 2, " . $boekenFilterId . ", 'cat0_z2,~cat0_z2_c10,~cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-456-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-457- /* Erotiek */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:458: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Erotiek', 'female', 7, " . $beeldFilterId. ", 'cat0_z3')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-459- $erotiekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:460: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Hetero', 'female', 0, " . $erotiekFilterId . ", 'cat0_z3_d75,cat0_z3_d23')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:461: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Homo', 'female', 1, " . $erotiekFilterId . ", 'cat0_z3_d74,cat0_z3_d24')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:462: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lesbo', 'female', 2, " . $erotiekFilterId . ", 'cat0_z3_d73,cat0_z3_d25')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:463: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Bi', 'female', 3, " . $erotiekFilterId . ", 'cat0_z3_d72,cat0_z3_d26')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-464-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-465- /* Muziek */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:466: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Muziek', 'music', 2, 0, 'cat1')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-467- $muziekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:468: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Compressed', 'music', 0, " . $muziekFilterId . ", 'cat1_a0,cat1_a3,cat1_a5,cat1_a6')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:469: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lossless', 'music', 1, " . $muziekFilterId . ", 'cat1_a2,cat1_a4,cat1_a7,cat1_a8')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-470-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-471- /* Spellen */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:472: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Spellen', 'controller', 3, 0, 'cat2')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-473- $gameFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:474: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'windows', 0, " . $gameFilterId . ", 'cat2_a0')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:475: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux', 'linux', 1, " . $gameFilterId . ", 'cat2_a1,cat2_a2')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:476: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Playstation', 'playstation', 2, " . $gameFilterId . ", 'cat2_a3,cat2_a4,cat2_a5,cat2_a12')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:477: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'XBox', 'xbox', 3, " . $gameFilterId . ", 'cat2_a6,cat2_a7')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:478: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nintendo', 'nintendo_ds', 4, " . $gameFilterId . ", 'cat2_a8,cat2_a9,cat2_a10,cat2_a11')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:479: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Smartphone / PDA', 'pda', 5, " . $gameFilterId . ", 'cat2_a13,cat2_a14,cat2_a15')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-480-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-481- /* Applicaties */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:482: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Applicaties', 'application', 4, 0, 'cat3')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-483- $appFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:484: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'vista', 0, " . $appFilterId . ", 'cat3_a0')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:485: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux / OS2', 'linux', 1, " . $appFilterId . ", 'cat3_a1,cat3_a2,cat3_a3')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php:486: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'PDA / Navigatie', 'pda', 2, " . $appFilterId . ", 'cat3_a4,cat3_a5,cat3_a6,cat3_a7')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotUserUpgrader.php-487- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-173- function isReportPlaced($messageid, $userId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:174: $tmpResult = $this->_conn->singleQuery("SELECT messageid FROM reportsposted WHERE inreplyto = '%s' AND ouruserid = %d", Array($messageid, $userId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-175-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-213- function removeSetting($name) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:214: $this->_conn->exec("DELETE FROM settings WHERE name = '%s'", Array($name));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-215- } # removeSetting
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-237- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:238: $this->_conn->exec("UPDATE settings SET value = '%s', serialized = '%s' WHERE name = '%s'", Array($value, $this->bool2dt($serialized), $name));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-239- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-323- function usernameExists($username) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:324: $tmpResult = $this->_conn->singleQuery("SELECT username FROM users WHERE username = '%s'", Array($username));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-325-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-332- function userEmailExists($mail) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:333: $tmpResult = $this->_conn->singleQuery("SELECT id FROM users WHERE mail = '%s'", Array($mail));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-334-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-514- # lastInsertId() exposed in de db klasse
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:515: $user['userid'] = $this->_conn->singleQuery("SELECT id FROM users WHERE username = '%s'", Array($user['username']));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-516-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-530- if ($username === false) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:531: $tmp = $this->_conn->arrayQuery("SELECT id FROM users WHERE apikey = '%s' AND NOT DELETED", Array($passhash));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-532- } else {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:533: $tmp = $this->_conn->arrayQuery("SELECT id FROM users WHERE username = '%s' AND passhash = '%s' AND NOT DELETED", Array($username, $passhash));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-534- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-551- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:552: $this->_conn->exec("UPDATE nntp SET maxarticleid = '%s' WHERE server = '%s'", Array((int) $maxarticleid, $server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-553- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-565- function getMaxArticleId($server) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:566: $artId = $this->_conn->singleQuery("SELECT maxarticleid FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-567- if ($artId == null) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-620- function isRetrieverRunning($server) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:621: $artId = $this->_conn->singleQuery("SELECT nowrunning FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-622- return ((!empty($artId)) && ($artId > (time() - 900)));
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-643- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:644: $this->_conn->modify("UPDATE nntp SET nowrunning = %d WHERE server = '%s'", Array((int) $runTime, $server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-645- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-692- # vraag eerst het id op
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:693: $commentId = $this->_conn->singleQuery("SELECT id FROM commentsxover WHERE messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-694-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-709- # vraag eerst het id op
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:710: $reportId = $this->_conn->singleQuery("SELECT id FROM reportsxover WHERE messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-711-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-724- function setLastUpdate($server) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:725: return $this->_conn->modify("UPDATE nntp SET lastrun = '%d' WHERE server = '%s'", Array(time(), $server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-726- } # getLastUpdate
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-731- function getLastUpdate($server) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:732: return $this->_conn->singleQuery("SELECT lastrun FROM nntp WHERE server = '%s'", Array($server));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-733- } # getLastUpdate
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1028- FROM spots AS s
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1029: WHERE s.messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1030- if (empty($tmpArray)) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1071- JOIN spotsfull AS f ON f.messageid = s.messageid
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1072: WHERE s.messageid = '%s'", Array($messageId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1073- if (empty($tmpArray)) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1333- function removeComment($msgId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1334: $this->_conn->modify("DELETE FROM commentsfull WHERE messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1335: $this->_conn->modify("DELETE FROM commentsxover WHERE messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1336- } # removeComment
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1344- case 'pdo_sqlite' : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1345: $this->_conn->modify("DELETE FROM spots WHERE messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1346: $this->_conn->modify("DELETE FROM spotsfull WHERE messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1347: $this->_conn->modify("DELETE FROM commentsfull WHERE messageid IN (SELECT messageid FROM commentsxover WHERE nntpref= '%s')", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1348: $this->_conn->modify("DELETE FROM commentsxover WHERE nntpref = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1349: $this->_conn->modify("DELETE FROM spotstatelist WHERE messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1350: $this->_conn->modify("DELETE FROM reportsxover WHERE nntpref = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1351: $this->_conn->modify("DELETE FROM reportsposted WHERE inreplyto = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1352: $this->_conn->modify("DELETE FROM cache WHERE resourceid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1353- break;
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1363- LEFT JOIN cache ON spots.messageid=cache.resourceid
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1364: WHERE spots.messageid = '%s'", Array($msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1365- } # default
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1372- function markSpotModerated($msgId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1373: $this->_conn->modify("UPDATE spots SET moderated = '%s' WHERE messageid = '%s'", Array($this->bool2dt(true), $msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1374- } # markSpotModerated
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1379- function markCommentModerated($msgId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1380: $this->_conn->modify("UPDATE commentsxover SET moderated = '%s' WHERE messageid = '%s'", Array($this->bool2dt(true), $msgId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1381- } # markCommentModerated
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1543- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1544: $this->_conn->modify("UPDATE spotstatelist SET " . $verifiedList . " = %d WHERE messageid = '%s' AND ouruserid = %d", array($stamp, $messageId, $ourUserId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1545- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1556- $verifiedList = $this->verifyListType($list);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1557: $this->_conn->modify("UPDATE spotstatelist SET " . $verifiedList . " = NULL WHERE ouruserid = %d", array($ourUserId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1558- SpotTiming::stop(__FUNCTION__, array($list, $ourUserId));
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1656- function getSecurityGroup($groupId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1657: return $this->_conn->arrayQuery("SELECT id,name FROM securitygroups WHERE id = %d", Array($groupId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1658- } # getSecurityGroup
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1663- function setSecurityGroup($group) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1664: $this->_conn->modify("UPDATE securitygroups SET name = '%s' WHERE id = %d", Array($group['name'], $group['id']));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1665- } # setSecurityGroup
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1677- function removeSecurityGroup($group) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1678: $this->_conn->modify("DELETE FROM securitygroups WHERE id = %d", Array($group['id']));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1679- } # removeSecurityGroup
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1685- # We wissen eerst huidige group membership
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1686: $this->_conn->modify("DELETE FROM usergroups WHERE userid = %d", array($userId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1687-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1821- function removeAllFilters($userId) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1822: $this->_conn->modify("DELETE FROM filters WHERE userid = %d", Array((int) $userId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1823- } # removeAllfilters
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1920- FROM filters
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:1921: WHERE userid = %d " . $filterTypeFilter . "
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-1922- ORDER BY tparent,torder", /* was: id, tparent, torder */
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2259- function cleanCache($expireDays) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2260: return $this->_conn->modify("DELETE FROM cache WHERE (cachetype = %d OR cachetype = %d OR cachetype = %d) AND stamp < %d", Array(SpotCache::Web, SpotCache::Statistics, SpotCache::StatisticsData,(int) time()-$expireDays*24*60*60));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2261- } # cleanCache
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2263- function isCached($resourceid, $cachetype) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2264: $tmpResult = $this->_conn->singleQuery("SELECT resourceid FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", Array($resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2265-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2271- case 'pdo_pgsql' : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2272: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2273- if (!empty($tmp)) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2281- case 'pdo_mysql' : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2282: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, UNCOMPRESS(content) AS content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2283- break;
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2286- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2287: $tmp = $this->_conn->arrayQuery("SELECT stamp, metadata, serialized, content FROM cache WHERE resourceid = '%s' AND cachetype = '%s'", array($resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2288- } # default
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2303- function updateCacheStamp($resourceid, $cachetype) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2304: $this->_conn->exec("UPDATE cache SET stamp = %d WHERE resourceid = '%s' AND cachetype = '%s'", Array(time(), $resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2305- } # updateCacheStamp
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2324- case 'pdo_pgsql' : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2325: $this->_conn->exec("UPDATE cache SET stamp = %d, metadata = '%s', serialized = '%s', content = '%b' WHERE resourceid = '%s' AND cachetype = '%s'", Array(time(), $metadata, $this->bool2dt($serialize), $content, $resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2326- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2333- case 'pdo_mysql' : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2334: $this->_conn->exec("UPDATE cache SET stamp = %d, metadata = '%s', serialized = '%s', content = COMPRESS('%s') WHERE resourceid = '%s' AND cachetype = '%s'", Array(time(), $metadata, $this->bool2dt($serialize), $content, $resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2335- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2341- default : {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2342: $this->_conn->exec("UPDATE cache SET stamp = %d, metadata = '%s', serialized = '%s', content = '%s' WHERE resourceid = '%s' AND cachetype = '%s'", Array(time(), $metadata, $this->bool2dt($serialize), $content, $resourceid, $cachetype));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2343- if ($this->_conn->rows() == 0) {
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2353- function setUserAvatar($userId, $imageEncoded) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2354: $this->_conn->modify("UPDATE usersettings SET avatar = '%s' WHERE userid = %d", Array( $imageEncoded, (int) $userId));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2355- } # setUserAvatar
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2382- $this->_conn->modify("DELETE FROM spotteridblacklist WHERE (ouruserid = -1) AND (origin = 'external')");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2383: $this->_conn->modify("DELETE FROM cache WHERE (resourceid = '%s') AND (cachetype = '%s')", Array(md5($blacklistUrl), SpotCache::Web));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2384- } # removeOldBlackList
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2421- $countdelblacklistspotterid++;
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php:2422: $this->_conn->modify("DELETE FROM spotteridblacklist WHERE (spotterid = '%s') AND (ouruserid = -1) AND (origin = 'external')", Array($updl));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotDb.php-2423- }
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-47- function indexExists($idxname, $tablename) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:48: $q = $this->_dbcon->arrayQuery("SHOW INDEXES FROM " . $tablename . " WHERE key_name = '%s'", Array($idxname));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-49- return !empty($q);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-53- function columnExists($tablename, $colname) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:54: $q = $this->_dbcon->arrayQuery("SHOW COLUMNS FROM " . $tablename . " WHERE Field = '%s'", Array($colname));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-55- return !empty($q);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-62- if ($idxType == "UNIQUE") {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:63: $this->_dbcon->rawExec("ALTER IGNORE TABLE " . $tablename . " ADD " . $idxType . " INDEX " . $idxname . "(" . implode(",", $colList) . ");");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-64- } else {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:65: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ADD " . $idxType . " INDEX " . $idxname . "(" . implode(",", $colList) . ");");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-66- } # else
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-125- if ($this->indexExists($idxname, $tablename)) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:126: $this->_dbcon->rawExec("DROP INDEX " . $idxname . " ON " . $tablename);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-127- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-191- if ($this->columnExists($tablename, $colName)) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:192: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP COLUMN " . $colName);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-193- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-210-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:211: $this->_dbcon->rawExec("CREATE TABLE " . $tablename . " (id INTEGER PRIMARY KEY AUTO_INCREMENT) " . $colSetting);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-212- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-217- if ($this->tableExists($tablename)) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:218: $this->_dbcon->rawExec("DROP TABLE " . $tablename);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-219- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-225- FROM information_schema.TABLES
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:226: WHERE TABLE_SCHEMA = DATABASE() AND TABLE_NAME = '" . $tablename . "'");
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-227-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-228- if (strtolower($q) != strtolower($engine)) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:229: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ENGINE=" . $engine);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-230- } # if
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-234- function renameTable($tablename, $newTableName) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:235: $this->_dbcon->rawExec("RENAME TABLE " . $tablename . " TO " . $newTableName);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-236- } # renameTable
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-247- foreach($q as $res) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:248: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " DROP FOREIGN KEY " . $res['CONSTRAINT_NAME']);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-249- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-261- if (empty($q)) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:262: $this->_dbcon->rawExec("ALTER TABLE " . $tablename . " ADD FOREIGN KEY (" . $colname . ")
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-263- REFERENCES " . $reftable . " (" . $refcolumn . ") " . $action);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-275- FROM information_schema.COLUMNS
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php:276: WHERE TABLE_NAME = '" . $tablename . "'
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbstruct/SpotStruct_mysql.php-277- AND COLUMN_NAME = '" . $colname . "'
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php-14- */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php:15: abstract function rawExec($sql);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php-16-
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php-90- */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php:91: function exec($s, $p = array()) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php:92: return $this->rawExec($this->prepareSql($s, $p));
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_abs.php-93- } # exec()
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-56- }
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php:57: public function rawExec($s) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-58- SpotTiming::start(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-86- */
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php:87: public function exec($s, $p = array()) {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-88- SpotTiming::start(__FUNCTION__);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-107-
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php:108: $res = $this->exec($s, $p);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-109- $res->closeCursor();
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-156- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php:157: $stmt = $this->exec($s, $p);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-158- $row = $stmt->fetch();
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-179- SpotTiming::start(__FUNCTION__);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php:180: $stmt = $this->exec($s, $p);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/dbeng/dbeng_pdo.php-181- $tmpArray = $stmt->fetchAll();
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php-121- function createXsrfSecret() {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php:122: $userSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php-123- $secret = substr($userSystem->generateUniqueId(), 0, 8);
##############################################
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php-130- function createPasswordSalt() {
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php:131: $userSystem = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/debian/db-update/v20111210/lib/SpotSettingsUpgrader.php-132- $salt = $userSystem->generateUniqueId() . $userSystem->generateUniqueId();
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-24- # Admin user
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:25:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:26:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:27:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:28:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:29:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:30:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:31:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:32:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-33- } else {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-34- # Grant the regular users all the necessary security groups
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:35:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:36:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:37:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:38:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-39-
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-41- if (($systemType == 'shared') || ($systemType == 'single')) {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:42:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:43:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-44- } # if
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-47- if ($systemType == 'single') {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:48:- $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:49:+ $dbCon->rawExec("INSERT IGNORE INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-50- } # if
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-82- foreach($anonPerms as $anonPerm) {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:83:- $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(2, " . $anonPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:84:+ $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(2, " . $anonPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-85- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-91- foreach($authedPerms as $authedPerm) {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:92:- $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(3, " . $authedPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:93:+ $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(3, " . $authedPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-94- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-166- foreach($adminPerms as $adminPerm) {
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:167:- $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(5, " . $adminPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:168:+ $dbCon->rawExec("INSERT IGNORE INTO grouppermissions(groupid,permissionid) VALUES(5, " . $adminPerm . ")");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-169- } # foreach
##############################################
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-200- /* Image */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:201:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Image', 'film', 0, 0, 'cat0_z0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-202-- $beeldFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:203:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DivX', 'divx', 0, " . $beeldFilterId . ", 'cat0_z0_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:204:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'WMV', 'wmv', 1, " . $beeldFilterId . ", 'cat0_z0_a1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:205:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'MPEG', 'mpg', 2, " . $beeldFilterId . ", 'cat0_z0_a2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:206:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DVD', 'dvd', 3, " . $beeldFilterId . ", 'cat0_z0_a3,cat0_z0_a10')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:207:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'HD', 'hd', 4, " . $beeldFilterId . ", 'cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:208:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Series', 'tv', 5, " . $beeldFilterId . ", 'cat0_z1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:209:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Image', 'film', 0, 0, 'cat0_z0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-210-+ $beeldFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:211:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DivX', 'divx', 0, " . $beeldFilterId . ", 'cat0_z0_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:212:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'WMV', 'wmv', 1, " . $beeldFilterId . ", 'cat0_z0_a1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:213:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'MPEG', 'mpg', 2, " . $beeldFilterId . ", 'cat0_z0_a2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:214:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DVD', 'dvd', 3, " . $beeldFilterId . ", 'cat0_z0_a3,cat0_z0_a10')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:215:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'HD', 'hd', 4, " . $beeldFilterId . ", 'cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:216:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Series', 'tv', 5, " . $beeldFilterId . ", 'cat0_z1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-217-
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-218- /* Books */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:219:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Books', 'book', 6, " . $beeldFilterId . ", 'cat0_z2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-220-- $boekenFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:221:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Dutch', 'book', 0, " . $boekenFilterId . ", 'cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:222:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'English', 'book', 1, " . $boekenFilterId . ", 'cat0_z2_c10')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:223:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Others', 'book', 2, " . $boekenFilterId . ", 'cat0_z2,~cat0_z2_c10,~cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:224:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Books', 'book', 6, " . $beeldFilterId . ", 'cat0_z2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-225-+ $boekenFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:226:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Dutch', 'book', 0, " . $boekenFilterId . ", 'cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:227:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'English', 'book', 1, " . $boekenFilterId . ", 'cat0_z2_c10')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:228:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Others', 'book', 2, " . $boekenFilterId . ", 'cat0_z2,~cat0_z2_c10,~cat0_z2_c11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-229-
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-230- /* Erotica */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:231:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Erotica', 'female', 7, " . $beeldFilterId. ", 'cat0_z3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-232-- $erotiekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:233:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Hetero', 'female', 0, " . $erotiekFilterId . ", 'cat0_z3_d75,cat0_z3_d23')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:234:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay male', 'female', 1, " . $erotiekFilterId . ", 'cat0_z3_d74,cat0_z3_d24')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:235:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay female', 'female', 2, " . $erotiekFilterId . ", 'cat0_z3_d73,cat0_z3_d25')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:236:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Bi', 'female', 3, " . $erotiekFilterId . ", 'cat0_z3_d72,cat0_z3_d26')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:237:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Erotica', 'female', 7, " . $beeldFilterId. ", 'cat0_z3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-238-+ $erotiekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:239:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Hetero', 'female', 0, " . $erotiekFilterId . ", 'cat0_z3_d75,cat0_z3_d23')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:240:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay male', 'female', 1, " . $erotiekFilterId . ", 'cat0_z3_d74,cat0_z3_d24')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:241:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay female', 'female', 2, " . $erotiekFilterId . ", 'cat0_z3_d73,cat0_z3_d25')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:242:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Bi', 'female', 3, " . $erotiekFilterId . ", 'cat0_z3_d72,cat0_z3_d26')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-243-
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-244- /* Music */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:245:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Sounds', 'music', 2, 0, 'cat1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-246-- $muziekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:247:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Compressed', 'music', 0, " . $muziekFilterId . ", 'cat1_a0,cat1_a3,cat1_a5,cat1_a6')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:248:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lossless', 'music', 1, " . $muziekFilterId . ", 'cat1_a2,cat1_a4,cat1_a7,cat1_a8')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:249:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Sounds', 'music', 2, 0, 'cat1')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-250-+ $muziekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:251:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Compressed', 'music', 0, " . $muziekFilterId . ", 'cat1_a0,cat1_a3,cat1_a5,cat1_a6')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:252:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lossless', 'music', 1, " . $muziekFilterId . ", 'cat1_a2,cat1_a4,cat1_a7,cat1_a8')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-253-
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-254- /* Games */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:255:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Games', 'controller', 3, 0, 'cat2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-256-- $gameFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:257:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'windows', 0, " . $gameFilterId . ", 'cat2_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:258:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux', 'linux', 1, " . $gameFilterId . ", 'cat2_a1,cat2_a2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:259:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Playstation', 'playstation', 2, " . $gameFilterId . ", 'cat2_a3,cat2_a4,cat2_a5,cat2_a12')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:260:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'XBox', 'xbox', 3, " . $gameFilterId . ", 'cat2_a6,cat2_a7')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:261:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nintendo', 'nintendo_ds', 4, " . $gameFilterId . ", 'cat2_a8,cat2_a9,cat2_a10,cat2_a11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:262:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Smartphone / PDA', 'pda', 5, " . $gameFilterId . ", 'cat2_a13,cat2_a14,cat2_a15')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:263:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Games', 'controller', 3, 0, 'cat2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-264-+ $gameFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:265:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'windows', 0, " . $gameFilterId . ", 'cat2_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:266:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux', 'linux', 1, " . $gameFilterId . ", 'cat2_a1,cat2_a2')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:267:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Playstation', 'playstation', 2, " . $gameFilterId . ", 'cat2_a3,cat2_a4,cat2_a5,cat2_a12')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:268:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'XBox', 'xbox', 3, " . $gameFilterId . ", 'cat2_a6,cat2_a7')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:269:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nintendo', 'nintendo_ds', 4, " . $gameFilterId . ", 'cat2_a8,cat2_a9,cat2_a10,cat2_a11')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:270:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Smartphone / PDA', 'pda', 5, " . $gameFilterId . ", 'cat2_a13,cat2_a14,cat2_a15')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-271-
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-272- /* Applications */
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:273:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Applications', 'application', 4, 0, 'cat3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-274-- $appFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:275:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'vista', 0, " . $appFilterId . ", 'cat3_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:276:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux / OS2', 'linux', 1, " . $appFilterId . ", 'cat3_a1,cat3_a2,cat3_a3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:277:- $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'PDA / Navigation', 'pda', 2, " . $appFilterId . ", 'cat3_a4,cat3_a5,cat3_a6,cat3_a7')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:278:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Applications', 'application', 4, 0, 'cat3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-279-+ $appFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:280:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'vista', 0, " . $appFilterId . ", 'cat3_a0')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:281:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux / OS2', 'linux', 1, " . $appFilterId . ", 'cat3_a1,cat3_a2,cat3_a3')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch:282:+ $dbCon->rawExec("INSERT IGNORE INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'PDA / Navigation', 'pda', 2, " . $appFilterId . ", 'cat3_a4,cat3_a5,cat3_a6,cat3_a7')");
spotweb-20130826+dfsg3/debian/patches/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch-283- } # foreach
##############################################
spotweb-20130826+dfsg3/.pc/0003-Fix-template-search-location.patch/lib/page/SpotPage_Abs.php-100- if (file_exists($tplPath . $tpl . '.inc.php')) {
spotweb-20130826+dfsg3/.pc/0003-Fix-template-search-location.patch/lib/page/SpotPage_Abs.php:101: require_once($tplPath . $tpl . '.inc.php');
spotweb-20130826+dfsg3/.pc/0003-Fix-template-search-location.patch/lib/page/SpotPage_Abs.php-102-
##############################################
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-365- function allowedToPost() {
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php:366: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-367- return $spotUser->allowedToPost($this->_currentSession['user']);
##############################################
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1111- function getUserFilterList() {
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php:1112: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1113- return $spotUser->getFilterList($this->_currentSession['user']['userid'], 'filter');
##############################################
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1119- function getUserFilter($filterId) {
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php:1120: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1121- return $spotUser->getFilter($this->_currentSession['user']['userid'], $filterId);
##############################################
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1127- function getIndexFilter() {
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php:1128: $spotUser = new SpotUserSystem($this->_db, $this->_settings);
spotweb-20130826+dfsg3/.pc/0004-Fix-static-file-locations.patch/lib/SpotTemplateHelper.php-1129- return $spotUser->getIndexFilter($this->_currentSession['user']['userid']);
##############################################
spotweb-20130826+dfsg3/.pc/0006-Use-Debian-php-net-nntp-library-instead-of-bundled-f.patch/lib/SpotClassAutoload.php-25- if (count($parts) == 2) {
spotweb-20130826+dfsg3/.pc/0006-Use-Debian-php-net-nntp-library-instead-of-bundled-f.patch/lib/SpotClassAutoload.php:26: require_once ('lib/' . strtolower($parts[0]) . '/' . $class_name . '.php');
spotweb-20130826+dfsg3/.pc/0006-Use-Debian-php-net-nntp-library-instead-of-bundled-f.patch/lib/SpotClassAutoload.php-27- } else {
spotweb-20130826+dfsg3/.pc/0006-Use-Debian-php-net-nntp-library-instead-of-bundled-f.patch/lib/SpotClassAutoload.php:28: require_once ('lib/' . strtolower($parts[0]) . '/' . $parts[1] . '/' . $class_name . '.php');
spotweb-20130826+dfsg3/.pc/0006-Use-Debian-php-net-nntp-library-instead-of-bundled-f.patch/lib/SpotClassAutoload.php-29- } # else
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-64- $dbCon->exec("UPDATE users SET id = 1 WHERE username = 'anonymous'");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:65: $dbCon->exec("UPDATE usersettings SET userid = 1 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-66- } # createAnonymous
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-129- $dbCon->exec("UPDATE users SET id = 2 WHERE username = 'admin'");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:130: $dbCon->exec("UPDATE usersettings SET userid = 2 WHERE userid = '%s'", Array( (int) $currentId));
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-131- } # createAdmin
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-146- */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:147: $dbCon->rawExec("DELETE FROM usergroups WHERE userid = " . $user['userid']);
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-148-
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-163- # Admin user
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:164: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:165: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:166: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:167: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-168- } else {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-169- # Grant the regular users all the necessary security groups
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:170: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 2, 1)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:171: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 3, 2)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-172-
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-174- if (($systemType == 'shared') || ($systemType == 'single')) {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:175: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 4, 3)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-176- } # if
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-179- if ($systemType == 'single') {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:180: $dbCon->rawExec("INSERT INTO usergroups(userid,groupid,prio) VALUES(" . $user['userid'] . ", 5, 4)");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-181- } # if
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-356- foreach($anonPerms as $anonPerm) {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:357: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(2, " . $anonPerm . ")");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-358- } # foreach
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-368- foreach($authedPerms as $authedPerm) {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:369: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(3, " . $authedPerm . ")");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-370- } # foreach
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-415- foreach($adminPerms as $adminPerm) {
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:416: $dbCon->rawExec("INSERT INTO grouppermissions(groupid,permissionid) VALUES(5, " . $adminPerm . ")");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-417- } # foreach
##############################################
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-455- /* Image */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:456: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Image', 'film', 0, 0, 'cat0_z0')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-457- $beeldFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:458: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DivX', 'divx', 0, " . $beeldFilterId . ", 'cat0_z0_a0')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:459: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'WMV', 'wmv', 1, " . $beeldFilterId . ", 'cat0_z0_a1')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:460: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'MPEG', 'mpg', 2, " . $beeldFilterId . ", 'cat0_z0_a2')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:461: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'DVD', 'dvd', 3, " . $beeldFilterId . ", 'cat0_z0_a3,cat0_z0_a10')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:462: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'HD', 'hd', 4, " . $beeldFilterId . ", 'cat0_z0_a4,cat0_z0_a6,cat0_z0_a7,cat0_z0_a8,cat0_z0_a9')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:463: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Series', 'tv', 5, " . $beeldFilterId . ", 'cat0_z1')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-464-
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-465- /* Books */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:466: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Books', 'book', 6, " . $beeldFilterId . ", 'cat0_z2')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-467- $boekenFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:468: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Dutch', 'book', 0, " . $boekenFilterId . ", 'cat0_z2_c11')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:469: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'English', 'book', 1, " . $boekenFilterId . ", 'cat0_z2_c10')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:470: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Others', 'book', 2, " . $boekenFilterId . ", 'cat0_z2,~cat0_z2_c10,~cat0_z2_c11')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-471-
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-472- /* Erotica */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:473: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Erotica', 'female', 7, " . $beeldFilterId. ", 'cat0_z3')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-474- $erotiekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:475: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Hetero', 'female', 0, " . $erotiekFilterId . ", 'cat0_z3_d75,cat0_z3_d23')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:476: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay male', 'female', 1, " . $erotiekFilterId . ", 'cat0_z3_d74,cat0_z3_d24')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:477: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Gay female', 'female', 2, " . $erotiekFilterId . ", 'cat0_z3_d73,cat0_z3_d25')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:478: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Bi', 'female', 3, " . $erotiekFilterId . ", 'cat0_z3_d72,cat0_z3_d26')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-479-
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-480- /* Music */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:481: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Sounds', 'music', 2, 0, 'cat1')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-482- $muziekFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:483: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Compressed', 'music', 0, " . $muziekFilterId . ", 'cat1_a0,cat1_a3,cat1_a5,cat1_a6')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:484: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Lossless', 'music', 1, " . $muziekFilterId . ", 'cat1_a2,cat1_a4,cat1_a7,cat1_a8')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-485-
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-486- /* Games */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:487: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Games', 'controller', 3, 0, 'cat2')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-488- $gameFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:489: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'windows', 0, " . $gameFilterId . ", 'cat2_a0')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:490: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux', 'linux', 1, " . $gameFilterId . ", 'cat2_a1,cat2_a2')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:491: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Playstation', 'playstation', 2, " . $gameFilterId . ", 'cat2_a3,cat2_a4,cat2_a5,cat2_a12')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:492: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'XBox', 'xbox', 3, " . $gameFilterId . ", 'cat2_a6,cat2_a7')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:493: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Nintendo', 'nintendo_ds', 4, " . $gameFilterId . ", 'cat2_a8,cat2_a9,cat2_a10,cat2_a11')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:494: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Smartphone / PDA', 'pda', 5, " . $gameFilterId . ", 'cat2_a13,cat2_a14,cat2_a15')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-495-
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-496- /* Applications */
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:497: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Applications', 'application', 4, 0, 'cat3')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-498- $appFilterId = $dbCon->lastInsertId('filters');
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:499: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Windows', 'vista', 0, " . $appFilterId . ", 'cat3_a0')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:500: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'Mac / Linux / OS2', 'linux', 1, " . $appFilterId . ", 'cat3_a1,cat3_a2,cat3_a3')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php:501: $dbCon->rawExec("INSERT INTO filters(userid,filtertype,title,icon,torder,tparent,tree) VALUES(" . $user['userid'] . ", 'filter', 'PDA / Navigation', 'pda', 2, " . $appFilterId . ", 'cat3_a4,cat3_a5,cat3_a6,cat3_a7')");
spotweb-20130826+dfsg3/.pc/0007-Replace-insert-with-insert-ignore-to-prevent-errors-.patch/lib/SpotUserUpgrader.php-502- } # foreach