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.7 2004/09/01 08:58:40 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 ($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.

   // Empty user data sub array:
   'userdata' => array(
    'name' => '',
    'password' => '',
    'authorised' => false,
   ),

   // 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 WHERE id='" . $common_sessiondata['hit_id'] . "';";

  common_dbc_query($sql);

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

}

//------------------------------------------------------------------------------
//- 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'];

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

function common_checkauthorisation() {

global $common_sessiondata;

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

  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!

  $logintime = time();

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

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

  $common_sessiondata['userdata']['id'] = $userid;
  $common_sessiondata['userdata']['lastlogin'] = $lastlogin;
  $common_sessiondata['userdata']['rights'] = $rights;

  // Break if the user already has authorised in this session:
  if(isset($common_sessiondata['userdata']['logintime'])) return false;

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

//  print_r($common_sessiondata['userdata']);

  $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) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');";

  $res = common_dbc_query($sql);

  if(!$res) return false;

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

}

//----------------------------------------------------------
//- 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() {
  $baseurl = "http://" . $_SERVER['SERVER_NAME'] . "" . $_SERVER['SCRIPT_NAME'] . "/";
  return $baseurl;
}

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

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	joko	1.8	--- $Id: common.php.inc,v 1.7 2004/09/01 08:58:40 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	joko	1.8	if ($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.6	// Empty user data sub array:
129			'userdata' => array(
130			'name' => '',
131			'password' => '',
132			'authorised' => false,
133			),
134
135			// Content related additional data:
136	rabit	1.2	'additionaldata' => array()
137
138			);
139
140	rabit	1.7	common_benchmark_addstep('common: New session: create session');
141	rabit	1.2
142			// Protocol the visitors hit and store the columns insertion ID:
143			$common_sessiondata['hit_id'] = common_protocolhit();
144
145	rabit	1.7	common_benchmark_addstep('common: New session: protocol hit');
146	rabit	1.2
147			// Store a reference to the session data array:
148			$_SESSION['common_sessiondata'] = &$common_sessiondata;
149
150	rabit	1.7	common_benchmark_addstep('common: New session: store session/end');
151	rabit	1.1
152			} else {
153
154	rabit	1.2	// Restore the session data array reference:
155			$common_sessiondata = &$_SESSION['common_sessiondata'];
156
157			// Reset the first page request flag:
158			$common_sessiondata['firstrequest'] = null;
159	rabit	1.1
160	rabit	1.2	// Update the request count in the "hits" table:
161
162			$sql = "UPDATE hits SET requestcount=requestcount+1 WHERE id='" . $common_sessiondata['hit_id'] . "';";
163	rabit	1.1
164	rabit	1.7	common_dbc_query($sql);
165	rabit	1.1
166	rabit	1.7	common_benchmark_addstep('common: session/hit data updated');
167	rabit	1.1
168	rabit	1.2	}
169	rabit	1.5
170			//------------------------------------------------------------------------------
171			//- URL parameter flags and variables:
172
173			if(isset($_GET['devstate'])) $common_sessiondata['userdata']['devstate'] = $_GET['devstate'];
174
175			if(isset($common_sessiondata['userdata']['devstate'])) $common['hostsetup']['devstate'] = $common_sessiondata['userdata']['devstate'];
176	rabit	1.1
177			//------------------------------------------------------------------------------
178			//- Functions:
179
180	rabit	1.6	function common_checkauthorisation() {
181
182			global $common_sessiondata;
183
184			$username = $common_sessiondata['userdata']['name'];
185			$password = $common_sessiondata['userdata']['password'];
186
187			if((strlen($username) < 2) \|\| (strlen($password) < 2)) return false;
188
189			$sql = "SELECT id, rights, logincount, lastlogin FROM users WHERE name='$username' AND password='$password';";
190
191	rabit	1.7	$res = common_dbc_query($sql);
192	rabit	1.6
193			if(!$res) return false;
194
195			if(!($row = mysql_fetch_row($res))) return false;
196
197			// Congratulations - authorisation suxxessful!
198
199			$logintime = time();
200
201			$userid = $row[0];
202			$rights = $row[1];
203			$logincount = $row[2] + 1;
204			$lastlogin = $row[3];
205
206			$common_sessiondata['userdata']['authorised'] = true;
207
208			$common_sessiondata['userdata']['id'] = $userid;
209			$common_sessiondata['userdata']['lastlogin'] = $lastlogin;
210			$common_sessiondata['userdata']['rights'] = $rights;
211
212			// Break if the user already has authorised in this session:
213			if(isset($common_sessiondata['userdata']['logintime'])) return false;
214
215			$common_sessiondata['userdata']['logincount'] = $logincount;
216			$common_sessiondata['userdata']['logintime'] = $logintime;
217
218			// print_r($common_sessiondata['userdata']);
219
220			$sql = "UPDATE users SET logincount='$logincount', lastlogin=FROM_UNIXTIME('$logintime') WHERE id='$userid';";
221
222	rabit	1.7	$res = common_dbc_query($sql);
223	rabit	1.6
224			if(!$res) return false;
225
226			return true;
227
228			}
229
230			//------------------------------------------------------------------------------
231
232	rabit	1.2	function common_protocolhit() {
233
234			global $common, $common_sessiondata;
235
236			$address = $_SERVER['REMOTE_ADDR'] . ':' . $_SERVER["REMOTE_PORT"];
237			$entryurl = $_SERVER['REQUEST_URI'];
238			$referer = (isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '');
239			$sessionid = session_id();
240			$unixtime = $common_sessiondata['birthtime'];
241			$useragent = $_SERVER['HTTP_USER_AGENT'];
242
243	bd	1.4	$sql = "INSERT INTO hits (id, timestamp, address, entryurl, referer, sessionid, useragent, requestcount) VALUES (NULL, FROM_UNIXTIME('$unixtime'), '$address', '$entryurl', '$referer', '$sessionid', '$useragent', '1');";
244	rabit	1.2
245	rabit	1.7	$res = common_dbc_query($sql);
246	rabit	1.2
247			if(!$res) return false;
248
249			return mysql_insert_id($common['dbc']['h_myqsllink']);
250
251			}
252
253			//----------------------------------------------------------
254			//- Database functions:
255
256			function common_dbc_connect() {
257
258			global $common;
259
260			$common['dbc']['connected'] = false;
261
262			$h_myqsllink = mysql_pconnect(
263			$common['hostsetup']['mysql_host'],
264			$common['hostsetup']['mysql_user'],
265			$common['hostsetup']['mysql_pass']
266			);
267
268			if(!$h_myqsllink) return false;
269
270			$common['dbc']['connected'] = true;
271			$common['dbc']['h_myqsllink'] = $h_myqsllink;
272
273			return true;
274
275			}
276
277			function common_dbc_selectdb() {
278
279			global $common;
280
281			$common['dbc']['dbselected'] = false;
282
283			if(
284			!mysql_selectdb($common['hostsetup']['mysql_db'])
285			) return false;
286
287			$common['dbc']['dbselected'] = true;
288
289			return true;
290
291			}
292
293			function common_dbc_connectdb() {
294
295			global $common;
296
297	rabit	1.7	$common['dbc']['dbconnected'] = (common_dbc_connect() && common_dbc_selectdb());
298	rabit	1.2
299	rabit	1.7	return $common['dbc']['dbconnected'];
300	rabit	1.2
301			}
302
303	rabit	1.7	function common_dbc_query($sql) {
304	rabit	1.2
305			global $common;
306
307	rabit	1.7	if(!$common['dbc']['dbconnected']) return false;
308	rabit	1.2
309	rabit	1.7	$res = mysql_query($sql);
310	rabit	1.3
311	rabit	1.7	if($errormsg = mysql_error()) {
312	rabit	1.3
313	rabit	1.7	// >>> MTC <<<
314	rabit	1.2
315	rabit	1.7	echo $errormsg . '<br />
316	rabit	1.2	<br />
317	rabit	1.1	';
318
319	rabit	1.2	}
320
321	rabit	1.7	if(!$res) return false;
322	rabit	1.1
323	rabit	1.7	return $res;
324	rabit	1.1
325			}
326
327			//----------------------------------------------------------
328	rabit	1.7	//- File functions:
329	rabit	1.1
330	joko	1.8	//----------------------------------------------------------
331			//- Utility functions:
332			function common_get_baseurl() {
333			$baseurl = "http://" . $_SERVER['SERVER_NAME'] . "" . $_SERVER['SCRIPT_NAME'] . "/";
334			return $baseurl;
335			}
336	rabit	1.1
337			//------------------------------------------------------------------------------
338
339	rabit	1.7	common_benchmark_addstep('common: end');
340	rabit	1.2
341			//------------------------------------------------------------------------------
342
343			?>
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26