inc/common/common.php.inc

<?php
/*------------------------------------------------------------------------------
--- www.netfrag.org
--- Setup and common functions include file.
--------------------------------------------------------------------------------
--- rabit, 04:31 24.08.2004
--- $Id: common.php.inc,v 1.10 2004/09/04 03:06:10 rabit Exp $
------------------------------------------------------------------------------*/

//------------------------------------------------------------------------------
//- Benchmarking:

// Create the benchmark steps array inside "$common":
$common['benchmark'] = array();

function common_benchmark_addstep($caption) {

global $common;

  $step = array($caption, microtime());

  array_push($common['benchmark'], $step);

}

// The starting entry in the benchmark steps list:
common_benchmark_addstep('common: start');

//----------------------------------------------------------
//- Developer host setups:

$hostsetups = array(

 'default' => array(
  'urlrel' => '/nfo/',
  'devstate' => false,
  'mysql_host' => 'localhost',
  'mysql_user' => 'nfo',
  'mysql_pass' => 'b2-cV5RF',
  'mysql_db' => 'nfo'
 ),

 'psl.no-ip.com' => array(
  'urlrel' => '/work/www.netfrag.org/',
  'devstate' => true,
  'mysql_host' => 'localhost',
  'mysql_user' => 'php',
  'mysql_pass' => 'A289tpQ1',
  'mysql_db' => 'nfo'
 ),

);

// Set the default host setup:
$common['hostsetup'] = $hostsetups['default'];

// Set the host setup if a listed host name is given:
if(isset($hostsetups[$_SERVER['SERVER_NAME']])) $common['hostsetup'] = $hostsetups[$_SERVER['SERVER_NAME']];

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:

$common['page']['filename'] = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '/') + 1);
$common['page']['url'] = $_SERVER['PHP_SELF'];

common_benchmark_addstep('common: site/page setup');

//------------------------------------------------------------------------------
//- Includes:

//common_include('cfg/cfg.php.inc');
//common_benchmark_addstep('common: CFG included');

include($common['site']['incroot'] . 'xmlcp/xmlcp.php.inc');
common_benchmark_addstep('common: XMLCP included');

include($common['site']['incroot'] . 'cms/cms.php.inc');
common_benchmark_addstep('common: CMS included');

//------------------------------------------------------------------------------
//- MySQL connection:

common_dbc_connectdb();
common_benchmark_addstep('common: connect database');

//------------------------------------------------------------------------------
//- Session setup:

if(!isset($common['client']['session_enabled'])) {

  // Neither proxies, nor the clients are allowed to cache session data:
  session_cache_limiter('nocache');

  // This is neccessary to make the $_SESSION global available:
  session_start();

}

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_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');

  // Protocol the visitors hit and store the columns insertion ID:
  $common_sessiondata['hit_id'] = common_protocolhit();

  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');

} else {

  // Restore the session data array reference:
  $common_sessiondata = &$_SESSION['common_sessiondata'];

  // Reset the first page request flag:
  $common_sessiondata['firstrequest'] = null;

  // Update the request count in the "hits" table:

  $sql = "UPDATE hits SET requestcount=requestcount+1, lastrequest=NOW() WHERE id='" . $common_sessiondata['hit_id'] . "';";

  common_dbc_query($sql);

  common_benchmark_addstep('common: session/hit data updated');

}

//------------------------------------------------------------------------------
//- Functions:

function common_authorise($username, $password) {

global $common_sessiondata;

  if((strlen($username) < 2) || (strlen($password) < 2)) return false;

  $sql = "SELECT id, rights, logincount, lastlogin FROM users WHERE name='$username' AND password='$password';";

  $res = common_dbc_query($sql);

  if(!$res) return false;

  if(!($row = mysql_fetch_row($res))) return false;

  // Congratulations - authorisation suxxessful!

  $common_sessiondata['user_auth']['authorised'] = true;

  $common_sessiondata['user_auth']['name'] = $username;
  $common_sessiondata['user_auth']['password'] = $password;

  $logintime = time();

  $userid = $row[0];
  $rights = $row[1];
  $logincount = $row[2] + 1;
  $lastlogin = $row[3];

  $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;

  $common_sessiondata['user_auth']['logincount'] = $logincount;
  $common_sessiondata['user_auth']['logintime'] = $logintime;

  // Protocol the login:
  common_protocollogin();

  $sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";

  $res = common_dbc_query($sql);

  if(!$res) return false;

  return true;

}

//------------------------------------------------------------------------------

function common_protocolhit() {

global $common, $common_sessiondata;

  $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'));";

  $res = common_dbc_query($sql);

  if(!$res) return false;

  return mysql_insert_id($common['dbc']['h_myqsllink']);

}

function common_protocollogin() {

global $common_sessiondata;

  $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');";

  $res = common_dbc_query($sql);

  if(!$res) return false;

  return true;

}

//----------------------------------------------------------
//- Database functions:

function common_dbc_connect() {

global $common;

  $common['dbc']['connected'] = false;

  $h_myqsllink = mysql_pconnect(
   $common['hostsetup']['mysql_host'],
   $common['hostsetup']['mysql_user'],
   $common['hostsetup']['mysql_pass']
  );

  if(!$h_myqsllink) return false;

  $common['dbc']['connected'] = true;
  $common['dbc']['h_myqsllink'] = $h_myqsllink;

  return true;

}

function common_dbc_selectdb() {

global $common;

  $common['dbc']['dbselected'] = false;

  if(
   !mysql_selectdb($common['hostsetup']['mysql_db'])
  ) return false;

  $common['dbc']['dbselected'] = true;

  return true;

}

function common_dbc_connectdb() {

global $common;

  $common['dbc']['dbconnected'] = (common_dbc_connect() && common_dbc_selectdb());

  return $common['dbc']['dbconnected'];

}

function common_dbc_query($sql) {

global $common;

  if(!$common['dbc']['dbconnected']) return false;

  $res = mysql_query($sql);

  if($errormsg = mysql_error()) {

    // >>> MTC <<<

    echo $errormsg . '<br />
<br />
';

  }

  if(!$res) return false;

  return $res;

}

//----------------------------------------------------------
//- File functions:

//----------------------------------------------------------
//- Utility functions:

function common_get_baseurl() {

global $common;

  return $common['site']['url'];

}

//------------------------------------------------------------------------------

common_benchmark_addstep('common: end');

//------------------------------------------------------------------------------

?>
1	rabit	1.1	<?php
2			/*------------------------------------------------------------------------------
3			--- www.netfrag.org
4			--- Setup and common functions include file.
5			--------------------------------------------------------------------------------
6			--- rabit, 04:31 24.08.2004
7	rabit	1.11	--- $Id: common.php.inc,v 1.10 2004/09/04 03:06:10 rabit Exp $
8	rabit	1.1	------------------------------------------------------------------------------*/
9
10	rabit	1.2	//------------------------------------------------------------------------------
11			//- Benchmarking:
12
13	rabit	1.3	// Create the benchmark steps array inside "$common":
14	rabit	1.2	$common['benchmark'] = array();
15
16			function common_benchmark_addstep($caption) {
17
18			global $common;
19
20			$step = array($caption, microtime());
21
22			array_push($common['benchmark'], $step);
23
24			}
25
26			// The starting entry in the benchmark steps list:
27	rabit	1.7	common_benchmark_addstep('common: start');
28	rabit	1.2
29	rabit	1.1	//----------------------------------------------------------
30	rabit	1.2	//- Developer host setups:
31	rabit	1.1
32	rabit	1.2	$hostsetups = array(
33	rabit	1.1
34			'default' => array(
35			'urlrel' => '/nfo/',
36	rabit	1.2	'devstate' => false,
37			'mysql_host' => 'localhost',
38			'mysql_user' => 'nfo',
39			'mysql_pass' => 'b2-cV5RF',
40			'mysql_db' => 'nfo'
41	rabit	1.1	),
42
43			'psl.no-ip.com' => array(
44			'urlrel' => '/work/www.netfrag.org/',
45	rabit	1.2	'devstate' => true,
46			'mysql_host' => 'localhost',
47			'mysql_user' => 'php',
48			'mysql_pass' => 'A289tpQ1',
49			'mysql_db' => 'nfo'
50	rabit	1.1	),
51
52			);
53
54	rabit	1.2	// Set the default host setup:
55			$common['hostsetup'] = $hostsetups['default'];
56
57			// Set the host setup if a listed host name is given:
58			if(isset($hostsetups[$_SERVER['SERVER_NAME']])) $common['hostsetup'] = $hostsetups[$_SERVER['SERVER_NAME']];
59
60			unset($hostsetups);
61
62	rabit	1.7	common_benchmark_addstep('common: host setup');
63
64	rabit	1.2	//----------------------------------------------------------
65			//- Site variable setups:
66
67	rabit	1.6	// Paths:
68	rabit	1.2	$common['site']['docroot'] = $_SERVER['DOCUMENT_ROOT'] . $common['hostsetup']['urlrel'];
69			$common['site']['incroot'] = $common['site']['docroot'] . 'inc/';
70	rabit	1.6	$common['site']['libroot'] = $common['site']['docroot'] . 'libs/';
71
72			// URLs:
73			$common['site']['url'] = 'http://' . $_SERVER['HTTP_HOST'] . $common['hostsetup']['urlrel'];
74			$common['site']['gfxurl'] = $common['site']['url'] . 'gfx/';
75	rabit	1.2
76			//----------------------------------------------------------
77			//- Page variable setups:
78
79			$common['page']['filename'] = substr($_SERVER['PHP_SELF'], strrpos($_SERVER['PHP_SELF'], '/') + 1);
80			$common['page']['url'] = $_SERVER['PHP_SELF'];
81
82	rabit	1.7	common_benchmark_addstep('common: site/page setup');
83	rabit	1.2
84			//------------------------------------------------------------------------------
85			//- Includes:
86
87			//common_include('cfg/cfg.php.inc');
88	rabit	1.7	//common_benchmark_addstep('common: CFG included');
89	rabit	1.2
90	rabit	1.7	include($common['site']['incroot'] . 'xmlcp/xmlcp.php.inc');
91			common_benchmark_addstep('common: XMLCP included');
92	rabit	1.2
93	rabit	1.7	include($common['site']['incroot'] . 'cms/cms.php.inc');
94			common_benchmark_addstep('common: CMS included');
95	rabit	1.2
96			//------------------------------------------------------------------------------
97			//- MySQL connection:
98	rabit	1.1
99	rabit	1.7	common_dbc_connectdb();
100			common_benchmark_addstep('common: connect database');
101	rabit	1.2
102			//------------------------------------------------------------------------------
103			//- Session setup:
104
105	rabit	1.9	if(!isset($common['client']['session_enabled'])) {
106	rabit	1.2
107	joko	1.8	// 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:
111			session_start();
112
113			}
114	rabit	1.2
115	rabit	1.7	common_benchmark_addstep('common: session init');
116	rabit	1.2
117			if(!isset($_SESSION['common_sessiondata'])) {
118
119			// The session variable isn't set, create it:
120
121	rabit	1.7	common_benchmark_addstep('common: New session: start');
122	rabit	1.2
123			$common_sessiondata = array(
124
125			'birthtime' => time(),
126			'firstrequest' => 1, // Mark the very first page request.
127
128	rabit	1.10	// User data and authorisation:
129			'user_auth' => array(
130	rabit	1.6	'name' => '',
131			'password' => '',
132	rabit	1.10	'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	rabit	1.6	),
142
143			// Content related additional data:
144	rabit	1.2	'additionaldata' => array()
145
146			);
147
148	rabit	1.7	common_benchmark_addstep('common: New session: create session');
149	rabit	1.2
150			// Protocol the visitors hit and store the columns insertion ID:
151			$common_sessiondata['hit_id'] = common_protocolhit();
152
153	rabit	1.7	common_benchmark_addstep('common: New session: protocol hit');
154	rabit	1.2
155			// Store a reference to the session data array:
156			$_SESSION['common_sessiondata'] = &$common_sessiondata;
157
158	rabit	1.7	common_benchmark_addstep('common: New session: store session/end');
159	rabit	1.1
160			} else {
161
162	rabit	1.2	// Restore the session data array reference:
163			$common_sessiondata = &$_SESSION['common_sessiondata'];
164
165			// Reset the first page request flag:
166			$common_sessiondata['firstrequest'] = null;
167	rabit	1.1
168	rabit	1.2	// Update the request count in the "hits" table:
169
170	rabit	1.11	$sql = "UPDATE hits SET requestcount=requestcount+1, lastrequest=NOW() WHERE id='" . $common_sessiondata['hit_id'] . "';";
171	rabit	1.1
172	rabit	1.7	common_dbc_query($sql);
173	rabit	1.1
174	rabit	1.7	common_benchmark_addstep('common: session/hit data updated');
175	rabit	1.1
176	rabit	1.2	}
177	rabit	1.5
178			//------------------------------------------------------------------------------
179	rabit	1.1	//- Functions:
180
181	rabit	1.10	function common_authorise($username, $password) {
182	rabit	1.6
183			global $common_sessiondata;
184
185			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';";
188
189	rabit	1.7	$res = common_dbc_query($sql);
190	rabit	1.6
191			if(!$res) return false;
192
193			if(!($row = mysql_fetch_row($res))) return false;
194
195			// Congratulations - authorisation suxxessful!
196
197	rabit	1.10	$common_sessiondata['user_auth']['authorised'] = true;
198
199			$common_sessiondata['user_auth']['name'] = $username;
200			$common_sessiondata['user_auth']['password'] = $password;
201
202	rabit	1.6	$logintime = time();
203
204			$userid = $row[0];
205			$rights = $row[1];
206			$logincount = $row[2] + 1;
207			$lastlogin = $row[3];
208
209	rabit	1.10	$common_sessiondata['user_auth']['id'] = $userid;
210			$common_sessiondata['user_auth']['lastlogin'] = $lastlogin;
211			$common_sessiondata['user_auth']['rights'] = $rights;
212	rabit	1.6
213			// Break if the user already has authorised in this session:
214	rabit	1.10	if(isset($common_sessiondata['user_auth']['logintime'])) return false;
215	rabit	1.6
216	rabit	1.10	$common_sessiondata['user_auth']['logincount'] = $logincount;
217			$common_sessiondata['user_auth']['logintime'] = $logintime;
218	rabit	1.6
219	rabit	1.11	// Protocol the login:
220			common_protocollogin();
221
222	rabit	1.6	$sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";
223
224	rabit	1.7	$res = common_dbc_query($sql);
225	rabit	1.6
226			if(!$res) return false;
227
228			return true;
229
230			}
231
232			//------------------------------------------------------------------------------
233
234	rabit	1.2	function common_protocolhit() {
235
236			global $common, $common_sessiondata;
237
238			$address = $_SERVER['REMOTE_ADDR'] . ':' . $_SERVER["REMOTE_PORT"];
239			$entryurl = $_SERVER['REQUEST_URI'];
240			$referer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
241			$sessionid = session_id();
242			$unixtime = $common_sessiondata['birthtime'];
243			$useragent = $_SERVER['HTTP_USER_AGENT'];
244
245	rabit	1.11	$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	rabit	1.2
247	rabit	1.7	$res = common_dbc_query($sql);
248	rabit	1.2
249			if(!$res) return false;
250
251			return mysql_insert_id($common['dbc']['h_myqsllink']);
252	rabit	1.11
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;
269
270			return true;
271	rabit	1.2
272			}
273
274			//----------------------------------------------------------
275			//- Database functions:
276
277			function common_dbc_connect() {
278
279			global $common;
280
281			$common['dbc']['connected'] = false;
282
283			$h_myqsllink = mysql_pconnect(
284			$common['hostsetup']['mysql_host'],
285			$common['hostsetup']['mysql_user'],
286			$common['hostsetup']['mysql_pass']
287			);
288
289			if(!$h_myqsllink) return false;
290
291			$common['dbc']['connected'] = true;
292			$common['dbc']['h_myqsllink'] = $h_myqsllink;
293
294			return true;
295
296			}
297
298			function common_dbc_selectdb() {
299
300			global $common;
301
302			$common['dbc']['dbselected'] = false;
303
304			if(
305			!mysql_selectdb($common['hostsetup']['mysql_db'])
306			) return false;
307
308			$common['dbc']['dbselected'] = true;
309
310			return true;
311
312			}
313
314			function common_dbc_connectdb() {
315
316			global $common;
317
318	rabit	1.7	$common['dbc']['dbconnected'] = (common_dbc_connect() && common_dbc_selectdb());
319	rabit	1.2
320	rabit	1.7	return $common['dbc']['dbconnected'];
321	rabit	1.2
322			}
323
324	rabit	1.7	function common_dbc_query($sql) {
325	rabit	1.2
326			global $common;
327
328	rabit	1.7	if(!$common['dbc']['dbconnected']) return false;
329	rabit	1.2
330	rabit	1.7	$res = mysql_query($sql);
331	rabit	1.3
332	rabit	1.7	if($errormsg = mysql_error()) {
333	rabit	1.3
334	rabit	1.7	// >>> MTC <<<
335	rabit	1.2
336	rabit	1.7	echo $errormsg . '<br />
337	rabit	1.2	<br />
338	rabit	1.1	';
339
340	rabit	1.2	}
341
342	rabit	1.7	if(!$res) return false;
343	rabit	1.1
344	rabit	1.7	return $res;
345	rabit	1.1
346			}
347
348			//----------------------------------------------------------
349	rabit	1.7	//- File functions:
350	rabit	1.1
351	joko	1.8	//----------------------------------------------------------
352			//- Utility functions:
353	rabit	1.9
354	joko	1.8	function common_get_baseurl() {
355	rabit	1.9
356			global $common;
357
358			return $common['site']['url'];
359
360	joko	1.8	}
361	rabit	1.1
362			//------------------------------------------------------------------------------
363
364	rabit	1.7	common_benchmark_addstep('common: end');
365	rabit	1.2
366			//------------------------------------------------------------------------------
367
368			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26