Data-Management
[ class tree: Data-Management ] [ index: Data-Management ] [ all elements ]
Packages:
WikiTimeScale
Data-Management
Global
Graph
Interface
Webpages


Files:
DBAccessClass.php
MySQLAccessClass.php
SessionDBClass.php

Classes:
DBAccess
MySQLAccess
SessionDB

Class: DBAccess

Source Location: /library/DBAccessClass.php

Class Overview

AbstractClass
   |
   --DBAccess

All database related methods and processings; Storing, reading and using of data stored in the database


Author(s):

  • Markus Szumovski

Version:

  • 2.41

Variables

Methods

Inherited Variables

Class: AbstractClass

AbstractClass::$abs

Inherited Methods

Class: AbstractClass

AbstractClass::calcAbstract()
AbstractClass::doAbstract()
AbstractClass::getAbstract()
AbstractClass::getDay()
AbstractClass::getDays()
AbstractClass::getDifTimes()
AbstractClass::getDuration()
AbstractClass::getMinDif()
AbstractClass::getMonth()
AbstractClass::getYear()
AbstractClass::getYMD()
AbstractClass::revertAbstract()
AbstractClass::setAbstract()

Class Details

[line 42]
All database related methods and processings; Storing, reading and using of data stored in the database



Tags:

author:  Markus Szumovski
version:  2.41


[ Top ]

Class Variables

$arrGroups =

[line 49]


Type:   mixed


[ Top ]

$arrNoShow =

[line 48]


Type:   mixed


[ Top ]

$arrShow =

[line 47]


Type:   mixed


[ Top ]

$changes =

[line 68]


Type:   mixed


[ Top ]

$ext_result =

[line 55]


Type:   mixed


[ Top ]

$firstid =

[line 65]


Type:   mixed


[ Top ]

$glob =

[line 45]


Type:   mixed


[ Top ]

$imagecnt =

[line 61]


Type:   mixed


[ Top ]

$isGroup =

[line 50]


Type:   mixed


[ Top ]

$limitcnt =

[line 60]


Type:   mixed


[ Top ]

$limitcur =

[line 59]


Type:   mixed


[ Top ]

$limitgo =

[line 58]


Type:   mixed


[ Top ]

$limitmax =

[line 63]


Type:   mixed


[ Top ]

$limitmaxshow =

[line 64]


Type:   mixed


[ Top ]

$mindif =

[line 67]


Type:   mixed


[ Top ]

$mysql =

[line 44]


Type:   mixed


[ Top ]

$ov_limitcnt =

[line 66]


Type:   mixed


[ Top ]

$searchstr =

[line 56]


Type:   mixed


[ Top ]

$showtimeWhere =

[line 52]


Type:   mixed


[ Top ]

$sql_cnt_str =

[line 62]


Type:   mixed


[ Top ]

$sql_select_str =

[line 57]


Type:   mixed


[ Top ]

$timeWhere =

[line 51]


Type:   mixed


[ Top ]

$wherestrMain =

[line 53]


Type:   mixed


[ Top ]

$wherestrShow =

[line 54]


Type:   mixed


[ Top ]


Class Methods

constructor DBAccess [line 70]

DBAccess DBAccess( &$glob, $imagecnt)



Parameters:

   &$glob  
   $imagecnt  

[ Top ]

method acceptPropErase [line 1541]

void acceptPropErase( $eventtitle, $LangName, $eraseid, $accept, $reason, $ip, $user)



Parameters:

   $eventtitle  
   $LangName  
   $eraseid  
   $accept  
   $reason  
   $ip  
   $user  

[ Top ]

method acceptProposal [line 1883]

void acceptProposal( $propid, $evid, $LangName, $accept, $reason, $ip, $user)



Parameters:

   $propid  
   $evid  
   $LangName  
   $accept  
   $reason  
   $ip  
   $user  

[ Top ]

method activateLang [line 1384]

void activateLang( $LangName)



Parameters:

   $LangName  

[ Top ]

method addBild [line 4761]

void addBild( $picname, $tmpname, $toname, [ $LangName = ''])



Parameters:

   $picname  
   $tmpname  
   $toname  
   $LangName  

[ Top ]

method addGlobChange [line 5574]

void addGlobChange( $chng, $eventid)



Parameters:

   $chng  
   $eventid  

[ Top ]

method addGroupToLegend [line 3303]

void addGroupToLegend( $lgrp, $title, $red, $green, $blue)



Parameters:

   $lgrp  
   $title  
   $red  
   $green  
   $blue  

[ Top ]

method addLangChange [line 5579]

void addLangChange( [ $chng = 0], $eventid)



Parameters:

   $chng  
   $eventid  

[ Top ]

method addRootDir [line 5273]

void addRootDir( $link)



Parameters:

   $link  

[ Top ]

method addTimeBars [line 2842]

void addTimeBars( $grp, $result, [ $symb = 1], [ $addShow = 1], [ $showUps = 1], [ $arrParentsP = NULL], [ $showext = 1])



Parameters:

   $grp  
   $result  
   $symb  
   $addShow  
   $showUps  
   $arrParentsP  
   $showext  

[ Top ]

method addToGroup [line 3017]

void addToGroup( $ev_id)



Parameters:

   $ev_id  

[ Top ]

method addToNoShow [line 2979]

void addToNoShow( $ev_id)



Parameters:

   $ev_id  

[ Top ]

method addToShow [line 2942]

void addToShow( $ev_id)



Parameters:

   $ev_id  

[ Top ]

method addVersion [line 2130]

void addVersion( $evid, $shorttitle, $title, $description, $wikilink, $searchkeys, $LangName, $from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $alt_from_year, $alt_from_month, $alt_from_day, $alt_to_year, $alt_to_month, $alt_to_day, $until_today, $groupid, $protectmode)



Parameters:

   $evid  
   $shorttitle  
   $title  
   $description  
   $wikilink  
   $searchkeys  
   $LangName  
   $from_year  
   $from_month  
   $from_day  
   $to_year  
   $to_month  
   $to_day  
   $alt_from_year  
   $alt_from_month  
   $alt_from_day  
   $alt_to_year  
   $alt_to_month  
   $alt_to_day  
   $until_today  
   $groupid  
   $protectmode  

[ Top ]

method addVersionStr [line 2264]

void addVersionStr( &$updverfields, &$updvervalues, &$ver, $ev, $stat, $name, [ $quote = 0], [ $evid = 0], [ $const_chng_glob = 0], [ $const_chng_lang = 0])



Parameters:

   &$updverfields  
   &$updvervalues  
   &$ver  
   $ev  
   $stat  
   $name  
   $quote  
   $evid  
   $const_chng_glob  
   $const_chng_lang  

[ Top ]

method addWebDir [line 5278]

void addWebDir( $link)



Parameters:

   $link  

[ Top ]

method blockedIPTryed [line 1695]

void blockedIPTryed( $ip)



Parameters:

   $ip  

[ Top ]

method blockedUserTryed [line 1689]

void blockedUserTryed( $username)



Parameters:

   $username  

[ Top ]

method blockIP [line 1234]

void blockIP( $ip, $reason, $byuser, $byip)



Parameters:

   $ip  
   $reason  
   $byuser  
   $byip  

[ Top ]

method blockUser [line 1227]

void blockUser( $user, $reason, $byuser, $byip)



Parameters:

   $user  
   $reason  
   $byuser  
   $byip  

[ Top ]

method changeOldToNewTitle [line 196]

void changeOldToNewTitle( $oldtitle, $newtitle, $text)



Parameters:

   $oldtitle  
   $newtitle  
   $text  

[ Top ]

method changePassword [line 3745]

void changePassword( $username, $userpassword_new, $userpassword_old, [ $nooldpassword = FALSE])



Parameters:

   $username  
   $userpassword_new  
   $userpassword_old  
   $nooldpassword  

[ Top ]

method changeTitleInEvents [line 181]

void changeTitleInEvents( $evtitle_old, $evtitle_new, $arrev, $LangName)



Parameters:

   $evtitle_old  
   $evtitle_new  
   $arrev  
   $LangName  

[ Top ]

method checkChanged [line 436]

void checkChanged( $sqlstr)



Parameters:

   $sqlstr  

[ Top ]

method checkEventEdit [line 1957]

void checkEventEdit( $eventid, $edittime, $LangName)



Parameters:

   $eventid  
   $edittime  
   $LangName  

[ Top ]

method checkIfStillBot [line 456]

void checkIfStillBot( $ip)



Parameters:

   $ip  

[ Top ]

method clearDB [line 2667]

void clearDB( )



[ Top ]

method clearLogs [line 552]

void clearLogs( )



[ Top ]

method copyLang [line 5607]

void copyLang( $FromLangName, $ToLangName)



Parameters:

   $FromLangName  
   $ToLangName  

[ Top ]

method copyTable [line 5663]

void copyTable( $FromLangName, $ToLangName, $table, $strcolumns)



Parameters:

   $FromLangName  
   $ToLangName  
   $table  
   $strcolumns  

[ Top ]

method createDateCalc [line 4933]

void createDateCalc( $LangName, $addyear, $addmonth, $addday, $title, $utid)



Parameters:

   $LangName  
   $addyear  
   $addmonth  
   $addday  
   $title  
   $utid  

[ Top ]

method createDateVer [line 5023]

void createDateVer( $LangName, $firstymd, $secondymd, $thirdymd, $namemonth, $firstcutsign, $secondcutsign, $thirdcutsign, $thousandsign, $title, $utid)



Parameters:

   $LangName  
   $firstymd  
   $secondymd  
   $thirdymd  
   $namemonth  
   $firstcutsign  
   $secondcutsign  
   $thirdcutsign  
   $thousandsign  
   $title  
   $utid  

[ Top ]

method createEvent [line 2051]

void createEvent( $shorttitle, $title, $description, $wikilink, $searchkeys, $LangName, $from_year, $from_month, $from_day, $to_year, $to_month, $to_day, $alt_from_year, $alt_from_month, $alt_from_day, $alt_to_year, $alt_to_month, $alt_to_day, $until_today, $groupid, [ $createdbyuser = ''], [ $createdbyip = ''], [ $evid = -1], [ $protectmode = CONST_DONT_PROTECT], [ $interpret = TRUE])



Parameters:

   $shorttitle  
   $title  
   $description  
   $wikilink  
   $searchkeys  
   $LangName  
   $from_year  
   $from_month  
   $from_day  
   $to_year  
   $to_month  
   $to_day  
   $alt_from_year  
   $alt_from_month  
   $alt_from_day  
   $alt_to_year  
   $alt_to_month  
   $alt_to_day  
   $until_today  
   $groupid  
   $createdbyuser  
   $createdbyip  
   $evid  
   $protectmode  
   $interpret  

[ Top ]

method createFAQ [line 4702]

void createFAQ( $LangName, $title, $text, $nringroup)



Parameters:

   $LangName  
   $title  
   $text  
   $nringroup  

[ Top ]

method createForum [line 4307]

void createForum( $title, $right, $user, $ip, $user_right, [ $parentforum = 0])



Parameters:

   $title  
   $right  
   $user  
   $ip  
   $user_right  
   $parentforum  

[ Top ]

method createForumEntry [line 4330]

void createForumEntry( $forumid, $forumtitle, $forumtext, $user, $ip, $user_right, [ $parententry = 0])



Parameters:

   $forumid  
   $forumtitle  
   $forumtext  
   $user  
   $ip  
   $user_right  
   $parententry  

[ Top ]

method createGroup [line 2365]

void createGroup( $grouptitle, $LangName, $r_color, $g_color, $b_color, [ $sortnr = 2], [ $grpid = -1])



Parameters:

   $grouptitle  
   $LangName  
   $r_color  
   $g_color  
   $b_color  
   $sortnr  
   $grpid  

[ Top ]

method createHelp [line 4569]

void createHelp( $helpname, $LangName, $helptitle, $helptext, $nringroup, [ $parentname = ''])



Parameters:

   $helpname  
   $LangName  
   $helptitle  
   $helptext  
   $nringroup  
   $parentname  

[ Top ]

method createLang [line 5601]

void createLang( $LangName, $DomainPrefix, $LangLongName, $WikiDomain, $FontFile)



Parameters:

   $LangName  
   $DomainPrefix  
   $LangLongName  
   $WikiDomain  
   $FontFile  

[ Top ]

method createMenu [line 4069]

void createMenu( $groupid, $LangName, $NrInGroup, $Name, $Link, $msid, $rgidarr, $showmenu, $hidemenu, $showatbegin)



Parameters:

   $groupid  
   $LangName  
   $NrInGroup  
   $Name  
   $Link  
   $msid  
   $rgidarr  
   $showmenu  
   $hidemenu  
   $showatbegin  

[ Top ]

method createMenuGroup [line 4093]

void createMenuGroup( $menuid, $LangName, $NrInGroup, $Title, $rgidarr)



Parameters:

   $menuid  
   $LangName  
   $NrInGroup  
   $Title  
   $rgidarr  

[ Top ]

method createQuickLink [line 4823]

void createQuickLink( $LangName, $fromyear, $frommonth, $fromday, $toyear, $tomonth, $today, $title, [ $until_today = 0])



Parameters:

   $LangName  
   $fromyear  
   $frommonth  
   $fromday  
   $toyear  
   $tomonth  
   $today  
   $title  
   $until_today  

[ Top ]

method createRight [line 5211]

void createRight( $RightNr, $RightName, $RightDescription, $rgidarr)



Parameters:

   $RightNr  
   $RightName  
   $RightDescription  
   $rgidarr  

[ Top ]

method createRightGroup [line 5113]

void createRightGroup( $rgname, $rgdescription)



Parameters:

   $rgname  
   $rgdescription  

[ Top ]

method createSet [line 2508]

void createSet( $LangName, $setname, $setdescription, $groupid, $setowneruser, $setownerip)



Parameters:

   $LangName  
   $setname  
   $setdescription  
   $groupid  
   $setowneruser  
   $setownerip  

[ Top ]

method createUser [line 3336]

void createUser( $username, $userpassword, $ip)



Parameters:

   $username  
   $userpassword  
   $ip  

[ Top ]

method cryptPWD [line 3324]

void cryptPWD( $password, &$encrypted, &$salt)



Parameters:

   $password  
   &$encrypted  
   &$salt  

[ Top ]

method deactivateLang [line 1390]

void deactivateLang( $LangName)



Parameters:

   $LangName  

[ Top ]

method deleteAsBot [line 450]

void deleteAsBot( $ip)



Parameters:

   $ip  

[ Top ]

method deleteBild [line 4814]

void deleteBild( $picname, [ $LangName = ''])



Parameters:

   $picname  
   $LangName  

[ Top ]

method deleteDateCalc [line 4964]

void deleteDateCalc( $dcid, $LangName)



Parameters:

   $dcid  
   $LangName  

[ Top ]

method deleteDateVer [line 5054]

void deleteDateVer( $dvid, $LangName)



Parameters:

   $dvid  
   $LangName  

[ Top ]

method deleteEvent [line 2328]

void deleteEvent( $evid, $LangName)



Parameters:

   $evid  
   $LangName  

[ Top ]

method deleteFAQ [line 4735]

void deleteFAQ( $faqid, $LangName)



Parameters:

   $faqid  
   $LangName  

[ Top ]

method deleteForum [line 4349]

void deleteForum( $forumid, [ $user_right = -1])



Parameters:

   $forumid  
   $user_right  

[ Top ]

method deleteForumEntry [line 4385]

void deleteForumEntry( $forumentry, $forumid, [ $user_right = -1])



Parameters:

   $forumentry  
   $forumid  
   $user_right  

[ Top ]

method deleteGroup [line 2438]

void deleteGroup( $grpid, $LangName)



Parameters:

   $grpid  
   $LangName  

[ Top ]

method deleteHelp [line 4581]

void deleteHelp( $helpname, $LangName)



Parameters:

   $helpname  
   $LangName  

[ Top ]

method deleteMenu [line 4235]

void deleteMenu( $menuid)



Parameters:

   $menuid  

[ Top ]

method deleteMenuGroup [line 4264]

void deleteMenuGroup( $groupid)



Parameters:

   $groupid  

[ Top ]

method deletePageRight [line 5531]

void deletePageRight( $link)



Parameters:

   $link  

[ Top ]

method deletePropErase [line 1555]

void deletePropErase( $eventtitle, $eraseid, $LangName)



Parameters:

   $eventtitle  
   $eraseid  
   $LangName  

[ Top ]

method deleteProposal [line 1889]

void deleteProposal( $propid, $evid, $LangName)



Parameters:

   $propid  
   $evid  
   $LangName  

[ Top ]

method deleteQuickLink [line 4861]

void deleteQuickLink( $qlid, $LangName)



Parameters:

   $qlid  
   $LangName  

[ Top ]

method deleteRight [line 5223]

void deleteRight( $RightNr)



Parameters:

   $RightNr  

[ Top ]

method deleteRightGroup [line 5125]

void deleteRightGroup( $rgid)



Parameters:

   $rgid  

[ Top ]

method deleteSet [line 2485]

void deleteSet( $setid)



Parameters:

   $setid  

[ Top ]

method deleteText [line 1066]

void deleteText( $name)



Parameters:

   $name  

[ Top ]

method delogip [line 3671]

void delogip( $ip)



Parameters:

   $ip  

[ Top ]

method doTimeBars [line 2746]

void doTimeBars( $grp, [ $showToggleBar = 1], [ $symb = 1], [ $showext = 1])



Parameters:

   $grp  
   $showToggleBar  
   $symb  
   $showext