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.6 2004/08/31 02:41: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:

// 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:


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

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