/[cvs]/nfo/site/htdocs/inc/common/common.php.inc

Diff of /nfo/site/htdocs/inc/common/common.php.inc

Parent Directory | Revision Log | View Patch Patch

-revision 1.2 by rabit,
Mon Aug 30 02:16:19 2004 UTC
+revision 1.11 by rabit,
Sun Sep  5 06:07:01 2004 UTC
 Line 4
  --- Setup and common functions include file.
  --------------------------------------------------------------------------------
  --- rabit, 04:31 24.08.2004
- --- $$id$$
+ --- $Id$
  ------------------------------------------------------------------------------*/
  //------------------------------------------------------------------------------
  //- Benchmarking:
+ // Create the benchmark steps array inside "$common":
  $common['benchmark'] = array();
  function common_benchmark_addstep($caption) {
-Line 23 
 global $common;
+Line 24 
 global $common;
  }
  // The starting entry in the benchmark steps list:
- common_benchmark_addstep('COMMON: start');
+ common_benchmark_addstep('common: start');
  //----------------------------------------------------------
  //- Developer host setups:
-Line 58 
 if(isset($hostsetups[$_SERVER['SERVER_NA
+Line 59 
 if(isset($hostsetups[$_SERVER['SERVER_NA
  unset($hostsetups);
+ common_benchmark_addstep('common: host setup');
  //----------------------------------------------------------
  //- Site variable setups:
+ // Paths:
  $common['site']['docroot'] = $_SERVER['DOCUMENT_ROOT'] . $common['hostsetup']['urlrel'];
  $common['site']['incroot'] = $common['site']['docroot'] . 'inc/';
+ $common['site']['libroot'] = $common['site']['docroot'] . 'libs/';
+ // URLs:
+ $common['site']['url'] = 'http://' . $_SERVER['HTTP_HOST'] . $common['hostsetup']['urlrel'];
+ $common['site']['gfxurl'] = $common['site']['url'] . 'gfx/';
  //----------------------------------------------------------
  //- Page variable setups:
-Line 70 
 $common['site']['incroot'] = $common['si
+Line 79 
 $common['site']['incroot'] = $common['si
  $common['page']['filename'] = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '/') + 1);
  $common['page']['url'] = $_SERVER['PHP_SELF'];
- common_benchmark_addstep('COMMON: setup');
+ common_benchmark_addstep('common: site/page setup');
  //------------------------------------------------------------------------------
  //- Includes:
  //common_include('cfg/cfg.php.inc');
- //common_benchmark_addstep('COMMON: CFG included');
+ //common_benchmark_addstep('common: CFG included');
- common_include('xmlcp/xmlcp.php.inc');
+ include($common['site']['incroot'] . 'xmlcp/xmlcp.php.inc');
- common_benchmark_addstep('COMMON: XMLCP included');
+ common_benchmark_addstep('common: XMLCP included');
- common_include('cms/cms.php.inc');
+ include($common['site']['incroot'] . 'cms/cms.php.inc');
- common_benchmark_addstep('COMMON: CMS included');
+ common_benchmark_addstep('common: CMS included');
  //------------------------------------------------------------------------------
  //- MySQL connection:
- $common['dbc']['dbconnected'] = common_dbc_connectdb();
+ common_dbc_connectdb();
+ common_benchmark_addstep('common: connect database');
- common_benchmark_addstep('COMMON: connect database');
  //------------------------------------------------------------------------------
  //- Session setup:
- // Neither proxies, nor the clients are allowed to cache session data:
+ if(!isset($common['client']['session_enabled'])) {
- session_cache_limiter('nocache');
- // This is neccessary to make the $_SESSION global available:
+   // Neither proxies, nor the clients are allowed to cache session data:
- session_start();
+   session_cache_limiter('nocache');
+   // This is neccessary to make the $_SESSION global available:
+   session_start();
+ }
- common_benchmark_addstep('COMMON: session init');
+ common_benchmark_addstep('common: session init');
  if(!isset($_SESSION['common_sessiondata'])) {
    // The session variable isn't set, create it:
-   common_benchmark_addstep('COMMON: New session: start');
+   common_benchmark_addstep('common: New session: start');
    $common_sessiondata = array(
     'birthtime' => time(),
     'firstrequest' => 1, // Mark the very first page request.
+    // User data and authorisation:
+    'user_auth' => array(
+     'name' => '',
+     'password' => '',
+     'authorised' => false
+    ),
+    // User preferences and preferred settings:
+    'user_prefs' => array(
+     'benchlist' => null,
+     'debug' => null,
+     'language_id' => null,
+     'outputtype' => null
+    ),
+    // Content related additional data:
     'additionaldata' => array()
    );
-   common_benchmark_addstep('COMMON: New session: create session');
+   common_benchmark_addstep('common: New session: create session');
    // Protocol the visitors hit and store the columns insertion ID:
    $common_sessiondata['hit_id'] = common_protocolhit();
-   common_benchmark_addstep('COMMON: New session: protocol hit');
+   common_benchmark_addstep('common: New session: protocol hit');
    // Store a reference to the session data array:
    $_SESSION['common_sessiondata'] = &$common_sessiondata;
-   common_benchmark_addstep('COMMON: New session: store session/end');
+   common_benchmark_addstep('common: New session: store session/end');
  } else {
-Line 139 
 if(!isset($_SESSION['common_sessiondata'
+Line 167 
 if(!isset($_SESSION['common_sessiondata'
    // Update the request count in the "hits" table:
-   $sql = "UPDATE hits SET requestcount=requestcount+1 WHERE id='" . $common_sessiondata['hit_id'] . "';";
+   $sql = "UPDATE hits SET requestcount=requestcount+1, lastrequest=NOW() WHERE id='" . $common_sessiondata['hit_id'] . "';";
-   mysql_query($sql);
+   common_dbc_query($sql);
-   common_benchmark_addstep('COMMON: session/hit data updated');
+   common_benchmark_addstep('common: session/hit data updated');
  }
  //------------------------------------------------------------------------------
  //- Functions:
- function common_protocolhit() {
+ function common_authorise($username, $password) {
- global $common, $common_sessiondata;
+ global $common_sessiondata;
-   $address = $_SERVER['REMOTE_ADDR'] . ':' . $_SERVER["REMOTE_PORT"];
+   if((strlen($username) < 2) || (strlen($password) < 2)) return false;
-   $entryurl = $_SERVER['REQUEST_URI'];
-   $referer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
-   $sessionid = session_id();
-   $unixtime = $common_sessiondata['birthtime'];
-   $timestamp = date('YmdHis', $common_sessiondata['birthtime']);
-   $useragent = $_SERVER['HTTP_USER_AGENT'];
-   $sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount) VALUES (DEFAULT, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');";
+   $sql = "SELECT id, rights, logincount, lastlogin FROM users WHERE name='$username' AND password='$password';";
-   $res = mysql_query($sql);
+   $res = common_dbc_query($sql);
    if(!$res) return false;
-   return mysql_insert_id($common['dbc']['h_myqsllink']);
+   if(!($row = mysql_fetch_row($res))) return false;
- }
- //----------------------------------------------------------
- //- Database functions:
- function common_dbc_connect() {
- global $common;
+   // Congratulations - authorisation suxxessful!
-   $common['dbc']['connected'] = false;
+   $common_sessiondata['user_auth']['authorised'] = true;
-   $h_myqsllink = mysql_pconnect(
+   $common_sessiondata['user_auth']['name'] = $username;
-    $common['hostsetup']['mysql_host'],
+   $common_sessiondata['user_auth']['password'] = $password;
-    $common['hostsetup']['mysql_user'],
-    $common['hostsetup']['mysql_pass']
-   );
-   if(!$h_myqsllink) return false;
+   $logintime = time();
-   $common['dbc']['connected'] = true;
+   $userid = $row[0];
-   $common['dbc']['h_myqsllink'] = $h_myqsllink;
+   $rights = $row[1];
+   $logincount = $row[2] + 1;
+   $lastlogin = $row[3];
-   return true;
+   $common_sessiondata['user_auth']['id'] = $userid;
+   $common_sessiondata['user_auth']['lastlogin'] = $lastlogin;
+   $common_sessiondata['user_auth']['rights'] = $rights;
- }
+   // Break if the user already has authorised in this session:
+   if(isset($common_sessiondata['user_auth']['logintime'])) return false;
- function common_dbc_selectdb() {
+   $common_sessiondata['user_auth']['logincount'] = $logincount;
+   $common_sessiondata['user_auth']['logintime'] = $logintime;
- global $common;
+   // Protocol the login:
+   common_protocollogin();
-   $common['dbc']['dbselected'] = false;
+   $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";
-   if(
+   $res = common_dbc_query($sql);
-    !mysql_selectdb($common['hostsetup']['mysql_db'])
-   ) return false;
-   $common['dbc']['dbselected'] = true;
+   if(!$res) return false;
    return true;
  }
- function common_dbc_connectdb() {
+ //------------------------------------------------------------------------------
-   return (common_dbc_connect() && common_dbc_selectdb());
- }
- //----------------------------------------------------------
- //- File functions:
- function common_include($filename) {
- global $common;
-   return include($common['site']['incroot'] . $filename);
- }
- //----------------------------------------------------------
- //- XMLCP setup:
- xmlcp_registertagcallbacks('b', 'common_cb_xmlcp_start_bold', 'common_cb_xmlcp_end_bold');
- xmlcp_registertagcallbacks('h', 'common_cb_xmlcp_start_headline', 'common_cb_xmlcp_end_headline');
- xmlcp_registertagcallbacks('p', 'common_cb_xmlcp_start_paragraph', 'common_cb_xmlcp_end_paragraph');
- xmlcp_registertagcallbacks('page', 'common_cb_xmlcp_start_page', 'common_cb_xmlcp_end_page');
- function common_cb_xmlcp_end_bold($h_parser, $tagname) {
- global $xmlcp_cdata;
-   $xmlcp_cdata .= '</b>';
- }
- function common_cb_xmlcp_start_bold($h_parser, $tagname, $attribs) {
- global $xmlcp_cdata;
-   $xmlcp_cdata .= '<b>';
- }
- function common_cb_xmlcp_end_page($h_parser, $tagname) {
- }
- function common_cb_xmlcp_start_page($h_parser, $tagname, $attribs) {
- }
- function common_cb_xmlcp_end_headline($h_parser, $tagname) {
- global $xmlcp_cdata;
+ function common_protocolhit() {
-   common_headline(trim($xmlcp_cdata));
+ global $common, $common_sessiondata;
-   $xmlcp_cdata = '';
+   $address = $_SERVER['REMOTE_ADDR'] . ':' . $_SERVER["REMOTE_PORT"];
+   $entryurl = $_SERVER['REQUEST_URI'];
+   $referer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
+   $sessionid = session_id();
+   $unixtime = $common_sessiondata['birthtime'];
+   $useragent = $_SERVER['HTTP_USER_AGENT'];
- }
+   $sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount, lastrequest) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1', FROM_UNIXTIME('$unixtime'));";
- function common_cb_xmlcp_start_headline($h_parser, $tagname, $attribs) {
+   $res = common_dbc_query($sql);
- global $xmlcp_cdata;
+   if(!$res) return false;
-   $xmlcp_cdata = '';
+   return mysql_insert_id($common['dbc']['h_myqsllink']);
  }
- function common_cb_xmlcp_end_paragraph($h_parser, $tagname) {
+ function common_protocollogin() {
- global $xmlcp_cdata;
-   common_paragraph(trim($xmlcp_cdata));
+ global $common_sessiondata;
-   $xmlcp_cdata = '';
+   $hitid = $common_sessiondata['hit_id'];
+   $sessionid = session_id();
+   $logintime = $common_sessiondata['user_auth']['logintime'];
+   $userid = $common_sessiondata['user_auth']['id'];
- }
+   $sql = "INSERT INTO logins (id, timestamp, user_id, sessionid, hit_id) VALUES (NULL, FROM_UNIXTIME('$logintime'), '$userid', '$sessionid', '$hitid');";
- function common_cb_xmlcp_start_paragraph($h_parser, $tagname, $attribs) {
+   $res = common_dbc_query($sql);
- global $xmlcp_cdata;
+   if(!$res) return false;
-   $xmlcp_cdata = '';
+   return true;
  }
  //----------------------------------------------------------
+ //- Database functions:
- //- ML functions:
+ function common_dbc_connect() {
- function common_codeparagraph($contents) {
-   echo '<p align="justify" class="hl">
- <code>
- ' . $contents . '
- </code>
- </p>
- ';
+ global $common;
- }
+   $common['dbc']['connected'] = false;
- //----------------------------------------------------------
+   $h_myqsllink = mysql_pconnect(
+    $common['hostsetup']['mysql_host'],
+    $common['hostsetup']['mysql_user'],
+    $common['hostsetup']['mysql_pass']
+   );
- function common_headline($caption) {
+   if(!$h_myqsllink) return false;
-   echo '<h4>' . $caption . '</h4>
+   $common['dbc']['connected'] = true;
+   $common['dbc']['h_myqsllink'] = $h_myqsllink;
- ';
+   return true;
  }
- //----------------------------------------------------------
+ function common_dbc_selectdb() {
- function common_page($keyname, $language_id = 0) {
  global $common;
-   common_benchmark_addstep('COMMON: PAGE: start');
+   $common['dbc']['dbselected'] = false;
-   $contentdata = cms_getcontent('xmlpage', $keyname);
-   common_benchmark_addstep('COMMON: PAGE: CMS get content');
-   $xml = $contentdata['content'];
-   common_pageheader();
-   common_benchmark_addstep('COMMON: PAGE: header');
-   if($xml) {
-     common_pagetitle($contentdata['description']);
-     xmlcp_xmlpage2html($xml);
-     common_benchmark_addstep('COMMON: PAGE: xmlpage2html');
- /*
-     common_headline('$contentdata array, readable:');
-     common_codeparagraph('$contentdata = ' . nl2br(htmlentities(print_r($contentdata, true))));
-     common_headline('$common array, readable:');
-     common_codeparagraph('$common = ' . nl2br(htmlentities(print_r($common, true))));
-     common_headline('$common_sessiondata array, readable:');
-     common_codeparagraph('$common_sessiondata = ' . nl2br(htmlentities(print_r($common_sessiondata, true))));
-     common_headline('Content XML:');
-     common_codeparagraph(nl2br(htmlentities($xml)));
- */
-     // Only show the informations when "devstate" is set:
-     if($common['hostsetup']['devstate']) {
-       common_paragraph('<small>
- <b>Content informations:</b><br />
- <br />
- Description: "<b>' . $contentdata['description'] . '</b>" (Type: "xmlpage")<br />
- Creator: "<b>' . $contentdata['creator_name'] . '</b>"<br />
- Date, Time: "<b>' . date('d.m.Y, H:i:s', $contentdata['unixtime']) . '</b>"<br />
- Language: "<b>' . $contentdata['language_name'] . '</b>"<br />
- XML content size: <b>' . strlen($xml) . '</b> bytes
- </small>', 'box2');
-     }
-   } else {
-     common_pagetitle('Bad content request');
-     common_paragraph('Sorry, but the requested content is unknown.');
-   }
+   if(
+    !mysql_selectdb($common['hostsetup']['mysql_db'])
+   ) return false;
-   common_benchmark_addstep('COMMON: PAGE: content');
+   $common['dbc']['dbselected'] = true;
-   common_pagefooter();
+   return true;
  }
- //----------------------------------------------------------
+ function common_dbc_connectdb() {
- function common_pageheader() {
  global $common;
-   echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+   $common['dbc']['dbconnected'] = (common_dbc_connect() && common_dbc_selectdb());
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
+   return $common['dbc']['dbconnected'];
- <title>www.netfrag.org</title>
- <style type="text/css"><!--
- body { font: 11pt verdana, serif; }
- h2 { text-align:center; }
- h2, .box, .box2, .hl { padding:8px; }
- h2, .box, .hl { background-color:#40f0f0; }
- h2, .box { border:2px solid #20a0c0; }
- h4 { font-size:12pt; }
- small { font-size:8pt; }
- .box2 { background-color:#80fff0; border:1px solid #40c080; }
- --></style>
- </head>
- <body>
- <h2>www.netfrag.org</h2>
- ';
  }
- //----------------------------------------------------------
+ function common_dbc_query($sql) {
- function common_pagefooter() {
  global $common;
-   // Only show the benchmark list when "devstate" is set:
+   if(!$common['dbc']['dbconnected']) return false;
-   if($common['hostsetup']['devstate']) {
-     $contents = '';
-     for($i = 0; $i < count($common['benchmark']); $i++) {
-       $mtimesegs = explode(' ', $common['benchmark'][$i][1]);
-       $contents .= '"<b>' . $common['benchmark'][$i][0] . '</b>": ';
-       if($i) {
+   $res = mysql_query($sql);
-         $timediff = (float)($mtimesegs[1] - $lastmtimesegs[1]);
-         $timediff += $mtimesegs[0] - $lastmtimesegs[0];
-         $contents .= '<b>+' . round($timediff * 1000000) / 1000 . '</b> ms<br />
- ';
-       } else {
-         $contents .= 'Start time: <b>' . date('H:i:s', $mtimesegs[1]) . substr($mtimesegs[0], 1, 4) . '</b><br />
- ';
-       }
-       $lastmtimesegs = $mtimesegs;
+   if($errormsg = mysql_error()) {
-     }
+     // >>> MTC <<<
-     common_paragraph('<small>
+     echo $errormsg . '<br />
- <b>Partial execution times:</b><br />
  <br />
- ' . $contents . '</small>', 'box2');
+ ';
    }
-   common_benchmark_addstep('COMMON: page footer');
+   if(!$res) return false;
-   $endmtimesegs = explode(' ', microtime());
-   $startmtimesegs = explode(' ', $common['benchmark'][0][1]);
-   $timediff = (float)($endmtimesegs[1] - $startmtimesegs[1]);
-   $timediff += $endmtimesegs[0] - $startmtimesegs[0];
-   echo '<table cellspacing="0" cellpadding="0" class="box" width="100%">
- <tr>
- <td valign="top">
- Page execution time: <code>' . round($timediff * 100000) / 100 . '</code> ms.
- </td>
- <td align="right"><a href="http://validator.w3.org/check?uri=referer" target="_blank"><img alt="This page is valid XHTML 1.0" border="0" height="31" src="http://www.w3.org/Icons/valid-xhtml10" width="88" /></a>
- <a href="http://jigsaw.w3.org/css-validator/check/referer" target="_blank"><img style="border:0;width:88px;height:31px" src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" /></a></td>
- </tr>
- </table>
- </body>
- </html>
+   return $res;
- ';
  }
  //----------------------------------------------------------
+ //- File functions:
- function common_pagetitle($title, $additionalcontents = '') {
-   echo '<p class="box2">
- <big><b>&bull; ' . $title . '</b></big><br />
- ' . ($additionalcontents ? $additionalcontents . '
- ' : '') . '</p>
- ';
- }
  //----------------------------------------------------------
+ //- Utility functions:
- function common_paragraph($contents, $class = '') {
+ function common_get_baseurl() {
-   echo '<p align="justify"' . ($class ? ' class="' . $class . '"' : '') . '>
+ global $common;
- ' . $contents . '
- </p>
- ';
+   return $common['site']['url'];
  }
  //------------------------------------------------------------------------------
- common_benchmark_addstep('COMMON: end');
+ common_benchmark_addstep('common: end');
  //------------------------------------------------------------------------------

 Legend:



Removed from v.1.2
 


changed lines


 
Added in v.1.11
 Legend:



Removed from v.1.2
 


changed lines


 
Added in v.1.11
-Removed from v.1.2
+Added in v.1.11

MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26