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

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

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.6 by rabit, Tue Aug 31 02:41:40 2004 UTC revision 1.11 by rabit, Sun Sep 5 06:07:01 2004 UTC
# Line 24  global $common; Line 24  global $common;
24  }  }
25    
26  // The starting entry in the benchmark steps list:  // The starting entry in the benchmark steps list:
27  common_benchmark_addstep('COMMON: start');  common_benchmark_addstep('common: start');
28    
29  //----------------------------------------------------------  //----------------------------------------------------------
30  //- Developer host setups:  //- Developer host setups:
# Line 59  if(isset($hostsetups[$_SERVER['SERVER_NA Line 59  if(isset($hostsetups[$_SERVER['SERVER_NA
59    
60  unset($hostsetups);  unset($hostsetups);
61    
62    common_benchmark_addstep('common: host setup');
63    
64  //----------------------------------------------------------  //----------------------------------------------------------
65  //- Site variable setups:  //- Site variable setups:
66    
# Line 77  $common['site']['gfxurl'] = $common['sit Line 79  $common['site']['gfxurl'] = $common['sit
79  $common['page']['filename'] = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '/') + 1);  $common['page']['filename'] = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '/') + 1);
80  $common['page']['url'] = $_SERVER['PHP_SELF'];  $common['page']['url'] = $_SERVER['PHP_SELF'];
81    
82  common_benchmark_addstep('COMMON: setup');  common_benchmark_addstep('common: site/page setup');
83    
84  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
85  //- Includes:  //- Includes:
86    
87  //common_include('cfg/cfg.php.inc');  //common_include('cfg/cfg.php.inc');
88  //common_benchmark_addstep('COMMON: CFG included');  //common_benchmark_addstep('common: CFG included');
89    
90  common_include('xmlcp/xmlcp.php.inc');  include($common['site']['incroot'] . 'xmlcp/xmlcp.php.inc');
91  common_benchmark_addstep('COMMON: XMLCP included');  common_benchmark_addstep('common: XMLCP included');
92    
93  common_include('cms/cms.php.inc');  include($common['site']['incroot'] . 'cms/cms.php.inc');
94  common_benchmark_addstep('COMMON: CMS included');  common_benchmark_addstep('common: CMS included');
95    
96  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
97  //- MySQL connection:  //- MySQL connection:
98    
99  $common['dbc']['dbconnected'] = common_dbc_connectdb();  common_dbc_connectdb();
100    common_benchmark_addstep('common: connect database');
 common_benchmark_addstep('COMMON: connect database');  
101    
102  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
103  //- Session setup:  //- Session setup:
104    
105  // Neither proxies, nor the clients are allowed to cache session data:  if(!isset($common['client']['session_enabled'])) {
106  session_cache_limiter('nocache');  
107      // Neither proxies, nor the clients are allowed to cache session data:
108      session_cache_limiter('nocache');
109    
110  // This is neccessary to make the $_SESSION global available:    // This is neccessary to make the $_SESSION global available:
111  session_start();    session_start();
112    
113  common_benchmark_addstep('COMMON: session init');  }
114    
115    common_benchmark_addstep('common: session init');
116    
117  if(!isset($_SESSION['common_sessiondata'])) {  if(!isset($_SESSION['common_sessiondata'])) {
118    
119    // The session variable isn't set, create it:    // The session variable isn't set, create it:
120    
121    common_benchmark_addstep('COMMON: New session: start');    common_benchmark_addstep('common: New session: start');
122    
123    $common_sessiondata = array(    $common_sessiondata = array(
124    
125     'birthtime' => time(),     'birthtime' => time(),
126     'firstrequest' => 1, // Mark the very first page request.     'firstrequest' => 1, // Mark the very first page request.
127    
128     // Empty user data sub array:     // User data and authorisation:
129     'userdata' => array(     'user_auth' => array(
130      'name' => '',      'name' => '',
131      'password' => '',      'password' => '',
132      'authorised' => false,      'authorised' => false
133       ),
134    
135       // User preferences and preferred settings:
136       'user_prefs' => array(
137        'benchlist' => null,
138        'debug' => null,
139        'language_id' => null,
140        'outputtype' => null
141     ),     ),
142    
143     // Content related additional data:     // Content related additional data:
# Line 132  if(!isset($_SESSION['common_sessiondata' Line 145  if(!isset($_SESSION['common_sessiondata'
145    
146    );    );
147    
148    common_benchmark_addstep('COMMON: New session: create session');    common_benchmark_addstep('common: New session: create session');
149    
150    // Protocol the visitors hit and store the columns insertion ID:    // Protocol the visitors hit and store the columns insertion ID:
151    $common_sessiondata['hit_id'] = common_protocolhit();    $common_sessiondata['hit_id'] = common_protocolhit();
152    
153    common_benchmark_addstep('COMMON: New session: protocol hit');    common_benchmark_addstep('common: New session: protocol hit');
154    
155    // Store a reference to the session data array:    // Store a reference to the session data array:
156    $_SESSION['common_sessiondata'] = &$common_sessiondata;    $_SESSION['common_sessiondata'] = &$common_sessiondata;
157    
158    common_benchmark_addstep('COMMON: New session: store session/end');    common_benchmark_addstep('common: New session: store session/end');
159    
160  } else {  } else {
161    
# Line 154  if(!isset($_SESSION['common_sessiondata' Line 167  if(!isset($_SESSION['common_sessiondata'
167    
168    // Update the request count in the "hits" table:    // Update the request count in the "hits" table:
169    
170    $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'] . "';";
171    
172    mysql_query($sql);    common_dbc_query($sql);
173    
174    common_benchmark_addstep('COMMON: session/hit data updated');    common_benchmark_addstep('common: session/hit data updated');
175    
176  }  }
177    
178  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
 //- URL parameter flags and variables:  
   
 if(isset($_GET['devstate'])) $common_sessiondata['userdata']['devstate'] = $_GET['devstate'];  
   
 if(isset($common_sessiondata['userdata']['devstate'])) $common['hostsetup']['devstate'] = $common_sessiondata['userdata']['devstate'];  
   
 //------------------------------------------------------------------------------  
179  //- Functions:  //- Functions:
180    
181  function common_checkauthorisation() {  function common_authorise($username, $password) {
182    
183  global $common_sessiondata;  global $common_sessiondata;
184    
   $username = $common_sessiondata['userdata']['name'];  
   $password = $common_sessiondata['userdata']['password'];  
   
185    if((strlen($username) < 2) || (strlen($password) < 2)) return false;    if((strlen($username) < 2) || (strlen($password) < 2)) return false;
186    
187    $sql = "SELECT id, rights, logincount, lastlogin FROM users WHERE name='$username' AND password='$password';";    $sql = "SELECT id, rights, logincount, lastlogin FROM users WHERE name='$username' AND password='$password';";
188    
189    $res = mysql_query($sql);    $res = common_dbc_query($sql);
190    
191    if(!$res) return false;    if(!$res) return false;
192    
# Line 191  global $common_sessiondata; Line 194  global $common_sessiondata;
194    
195    // Congratulations - authorisation suxxessful!    // Congratulations - authorisation suxxessful!
196    
197      $common_sessiondata['user_auth']['authorised'] = true;
198    
199      $common_sessiondata['user_auth']['name'] = $username;
200      $common_sessiondata['user_auth']['password'] = $password;
201    
202    $logintime = time();    $logintime = time();
203    
204    $userid = $row[0];    $userid = $row[0];
# Line 198  global $common_sessiondata; Line 206  global $common_sessiondata;
206    $logincount = $row[2] + 1;    $logincount = $row[2] + 1;
207    $lastlogin = $row[3];    $lastlogin = $row[3];
208    
209    $common_sessiondata['userdata']['authorised'] = true;    $common_sessiondata['user_auth']['id'] = $userid;
210      $common_sessiondata['user_auth']['lastlogin'] = $lastlogin;
211    $common_sessiondata['userdata']['id'] = $userid;    $common_sessiondata['user_auth']['rights'] = $rights;
   $common_sessiondata['userdata']['lastlogin'] = $lastlogin;  
   $common_sessiondata['userdata']['rights'] = $rights;  
212    
213    // Break if the user already has authorised in this session:    // Break if the user already has authorised in this session:
214    if(isset($common_sessiondata['userdata']['logintime'])) return false;    if(isset($common_sessiondata['user_auth']['logintime'])) return false;
215    
216    $common_sessiondata['userdata']['logincount'] = $logincount;    $common_sessiondata['user_auth']['logincount'] = $logincount;
217    $common_sessiondata['userdata']['logintime'] = $logintime;    $common_sessiondata['user_auth']['logintime'] = $logintime;
218    
219  //  print_r($common_sessiondata['userdata']);    // Protocol the login:
220      common_protocollogin();
221    
222    $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";    $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";
223    
224    $res = mysql_query($sql);    $res = common_dbc_query($sql);
225    
226    if(!$res) return false;    if(!$res) return false;
227    
# Line 235  global $common, $common_sessiondata; Line 242  global $common, $common_sessiondata;
242    $unixtime = $common_sessiondata['birthtime'];    $unixtime = $common_sessiondata['birthtime'];
243    $useragent = $_SERVER['HTTP_USER_AGENT'];    $useragent = $_SERVER['HTTP_USER_AGENT'];
244    
245    $sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');";    $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'));";
246    
247    $res = mysql_query($sql);    $res = common_dbc_query($sql);
248    
249    if ($errstr = mysql_error()) {    if(!$res) return false;
250    
251      print $errstr . "\n";    return mysql_insert_id($common['dbc']['h_myqsllink']);
252    
253    }  }
254    
255    function common_protocollogin() {
256    
257    global $common_sessiondata;
258    
259      $hitid = $common_sessiondata['hit_id'];
260      $sessionid = session_id();
261      $logintime = $common_sessiondata['user_auth']['logintime'];
262      $userid = $common_sessiondata['user_auth']['id'];
263    
264      $sql = "INSERT INTO logins (id, timestamp, user_id, sessionid, hit_id) VALUES (NULL, FROM_UNIXTIME('$logintime'), '$userid', '$sessionid', '$hitid');";
265    
266      $res = common_dbc_query($sql);
267    
268    if(!$res) return false;    if(!$res) return false;
269    
270    return mysql_insert_id($common['dbc']['h_myqsllink']);    return true;
271    
272  }  }
273    
274  //----------------------------------------------------------  //----------------------------------------------------------
   
275  //- Database functions:  //- Database functions:
276    
277  function common_dbc_connect() {  function common_dbc_connect() {
# Line 294  global $common; Line 313  global $common;
313    
314  function common_dbc_connectdb() {  function common_dbc_connectdb() {
315    
   return (common_dbc_connect() && common_dbc_selectdb());  
   
 }  
   
 //----------------------------------------------------------  
   
 //- File functions:  
   
 function common_include($filename) {  
   
316  global $common;  global $common;
317    
318    return include($common['site']['incroot'] . $filename);    $common['dbc']['dbconnected'] = (common_dbc_connect() && common_dbc_selectdb());
   
 }  
   
 //----------------------------------------------------------  
   
 //- 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;  
   
   common_headline(trim($xmlcp_cdata));  
   
   $xmlcp_cdata = '';  
319    
320  }    return $common['dbc']['dbconnected'];
   
 function common_cb_xmlcp_start_headline($h_parser, $tagname, $attribs) {  
   
 global $xmlcp_cdata;  
   
   $xmlcp_cdata = '';  
   
 }  
   
 function common_cb_xmlcp_end_paragraph($h_parser, $tagname) {  
   
 global $xmlcp_cdata;  
   
   common_paragraph(trim($xmlcp_cdata));  
   
   $xmlcp_cdata = '';  
   
 }  
   
 function common_cb_xmlcp_start_paragraph($h_parser, $tagname, $attribs) {  
   
 global $xmlcp_cdata;  
   
   $xmlcp_cdata = '';  
321    
322  }  }
323    
324  //----------------------------------------------------------  function common_dbc_query($sql) {
   
 //- ML functions:  
   
 function common_codeparagraph($contents) {  
   
   echo '<p align="justify" class="hl11">  
 <code>  
 ' . $contents . '  
 </code>  
 </p>  
   
 ';  
   
 }  
   
 //----------------------------------------------------------  
   
 function common_headline($caption) {  
   
   echo '<h4>' . $caption . '</h4>  
   
 ';  
   
 }  
   
 //----------------------------------------------------------  
   
 function common_page($keyname, $language_id = 0) {  
325    
326  global $common;  global $common;
327    
328    common_benchmark_addstep('COMMON: PAGE: start');    if(!$common['dbc']['dbconnected']) return false;
   
   $list = cms_getlist('xmlpage', $keyname);  
   
   common_benchmark_addstep('COMMON: PAGE: CMS get list');  
   
   $contentdata = cms_getcontent('xmlpage', $keyname, $language_id);  
   
   common_benchmark_addstep('COMMON: PAGE: CMS get content');  
   
   $xml = $contentdata['content'];  
   
   common_pageheader();  
   
   common_benchmark_addstep('COMMON: PAGE: header');  
   
   if($xml) {  
   
     $titledata = '';  
   
     for($i = 0; $i < count($list); $i++) {  
329    
330        $imgtag = '<img border="0" height="12" src="' . $common['site']['gfxurl'] . 'icons/flags/' . $list[$i][3] . '.gif" width="17" />';    $res = mysql_query($sql);
   
       $titledata .= ($i ? '  
 ' : '') . (($language_id == $list[$i][3]) ? $imgtag : '<a href="?li=' . $list[$i][3] . '">' . $imgtag . '</a>');  
   
     }  
   
     common_pagetitle($contentdata['description'], $titledata . '<br />');  
   
     xmlcp_xmlpage2html($xml);  
   
     common_benchmark_addstep('COMMON: PAGE: xmlpage2html');  
   
 /*  
     common_headline('$list array, readable:');  
     common_codeparagraph('$list = ' . nl2br(htmlentities(print_r($list, true))));  
   
     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)));  
331    
332  */    if($errormsg = mysql_error()) {
333    
334      // Only show the informations when "devstate" is set:      // >>> MTC <<<
     if($common['hostsetup']['devstate']) {  
335    
336        common_paragraph('<small>      echo $errormsg . '<br />
 <b>Content informations:</b><br />  
337  <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.');  
   
   }  
   
   common_benchmark_addstep('COMMON: PAGE: content');  
   
   common_pagefooter();  
   
 }  
   
 //----------------------------------------------------------  
   
 function common_pageheader() {  
   
 global $common, $common_sessiondata;  
   
   echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
   
 <html xmlns="http://www.w3.org/1999/xhtml">  
   
 <head>  
 <title>www.netfrag.org</title>  
 <style type="text/css"><!--  
 body, input, table { font: 10pt verdana, serif; }  
 h4 { font-size:12pt; }  
 input { border:1px; }  
 small { font-size:8pt; }  
 .bg11, .box1, .f11, .hl11 { background-color:#50f8f0; }  
 .bg12, .f12 { background-color:#40e8e0; }  
 .bg13 { background-color:#20a0c0; }  
 .bg21, .box2, .f21, .hl21 { background-color:#90fff0; }  
 .bg22, .f22 { background-color:#80f0e0; }  
 .bg23 { background-color:#40c080; }  
 .box1, .f11, .f12 { border:2px solid #20a0c0; }  
 .box2, .f21, .f22 { border:1px solid #40c080; }  
 .box1, .box2, .hl11, .hl21 { padding:4px; }  
 --></style>  
 </head>  
   
 <body>  
   
 <form action="" method="post">  
 <table cellspacing="0" cellpadding="0" width="100%">  
 <tr>  
 <th class="box1" width="100%">  
 <font size="5" style="letter-spacing:4pt;"><b>www.netfrag.org</b></font>  
 </td>  
 <td>&nbsp;</td>  
 <td>  
 <table cellspacing="0" cellpadding="2" class="f22">  
 <tr>  
 <th class="box2" rowspan="2"><b>User<br />login</b></th>  
 <td>&nbsp;User:</td><td><input name="un" size="8" type="text" value="' . $common_sessiondata['userdata']['name'] . '" /></td>  
 <td rowspan="2"><input type="submit" value="Go" />&nbsp;</td>  
 <tr>  
 <td>&nbsp;Pass:</td><td><input name="pw" size="8" type="password" /></td>  
 </tr>  
 </table>  
 </td>  
 </tr>  
 </table>  
 </form>  
   
 ';  
   
 }  
   
 //----------------------------------------------------------  
   
 function common_pagefooter() {  
   
 global $common;  
   
   // Only show the benchmark list when "devstate" is set:  
   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) {  
   
         $timediff = (float)($mtimesegs[1] - $lastmtimesegs[1]);  
         $timediff += $mtimesegs[0] - $lastmtimesegs[0];  
   
         $contents .= '<b>+' . round($timediff * 1000000) / 1000 . '</b> ms<br />  
338  ';  ';
339    
       } else {  
   
         $contents .= 'Start time: <b>' . date('H:i:s', $mtimesegs[1]) . substr($mtimesegs[0], 1, 4) . '</b><br />  
 ';  
   
       }  
   
       $lastmtimesegs = $mtimesegs;  
   
     }  
   
     common_paragraph('<small>  
 <b>Partial execution times:</b><br />  
 <br />  
 ' . $contents . '</small>', 'box2');  
   
340    }    }
341    
342    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];  
   
   $devstate = $common['hostsetup']['devstate'];  
   
   echo '<table cellspacing="0" cellpadding="0" class="box1" width="100%">  
 <tr>  
 <td valign="top">  
 Page execution time: <code>' . round($timediff * 100000) / 100 . '</code> ms.<br />  
 [ ' . ($devstate ? '<a href="?devstate=0">devstate off</a>' : '<a href="?devstate=1">devstate on</a>') . ' ]  
 </td>  
 <td align="right" valign="middle"><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>  
343    
344  </body>    return $res;
   
 </html>  
 ';  
345    
346  }  }
347    
348  //----------------------------------------------------------  //----------------------------------------------------------
349    //- File functions:
 function common_pagetitle($title, $additionalcontents = '') {  
   
   echo '<p class="box2">  
 <big><b>&bull; ' . $title . '</b>&nbsp;</big>  
 ' . ($additionalcontents ? $additionalcontents . '  
 ' : '') . '</p>  
   
 ';  
   
 }  
350    
351  //----------------------------------------------------------  //----------------------------------------------------------
352    //- Utility functions:
353    
354  function common_paragraph($contents, $class = '') {  function common_get_baseurl() {
355    
356    echo '<p align="justify"' . ($class ? ' class="' . $class . '"' : '') . '>  global $common;
 ' . $contents . '  
 </p>  
357    
358  ';    return $common['site']['url'];
359    
360  }  }
361    
362  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
363    
364  common_benchmark_addstep('COMMON: end');  common_benchmark_addstep('common: end');
365    
366  //------------------------------------------------------------------------------  //------------------------------------------------------------------------------
367    
Legend:
Removed from v.1.6  
changed lines
  Added in v.1.11
MailToCvsAdmin">MailToCvsAdmin
 ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed