Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
accounting.lib.php	9.12 KB	-rw-r--r--	2022-09-27 16:06
admin.lib.php	66.42 KB	-rw-r--r--	2022-09-27 16:06
agenda.lib.php	18.22 KB	-rw-r--r--	2022-09-27 16:06
ajax.lib.php	31.31 KB	-rw-r--r--	2022-09-27 16:06
asset.lib.php	4.8 KB	-rw-r--r--	2022-09-27 16:06
bank.lib.php	12.94 KB	-rw-r--r--	2022-09-27 16:06
barcode.lib.php	15.26 KB	-rw-r--r--	2022-09-27 16:06
categories.lib.php	3.43 KB	-rw-r--r--	2022-09-27 16:06
company.lib.php	79.8 KB	-rw-r--r--	2022-09-27 16:06
contact.lib.php	4.51 KB	-rw-r--r--	2022-09-27 16:06
contract.lib.php	4.77 KB	-rw-r--r--	2022-09-27 16:06
cron.lib.php	4.69 KB	-rw-r--r--	2022-09-27 16:06
date.lib.php	37.78 KB	-rw-r--r--	2022-09-27 16:06
doc.lib.php	6.73 KB	-rw-r--r--	2022-09-27 16:06
doleditor.lib.php	3.93 KB	-rw-r--r--	2022-09-27 16:06
donation.lib.php	3.61 KB	-rw-r--r--	2022-09-27 16:06
ecm.lib.php	5.12 KB	-rw-r--r--	2022-09-27 16:06
emailing.lib.php	2.25 KB	-rw-r--r--	2022-09-27 16:06
eventorganization.lib.php	2.21 KB	-rw-r--r--	2022-09-27 16:06
expedition.lib.php	3.9 KB	-rw-r--r--	2022-09-27 16:06
expensereport.lib.php	5.6 KB	-rw-r--r--	2022-09-27 16:06
fichinter.lib.php	6.45 KB	-rw-r--r--	2022-09-27 16:06
files.lib.php	122.46 KB	-rw-r--r--	2022-09-27 16:06
fiscalyear.lib.php	1.86 KB	-rw-r--r--	2022-09-27 16:06
format_cards.lib.php	2.8 KB	-rw-r--r--	2022-09-27 16:06
fourn.lib.php	10.09 KB	-rw-r--r--	2022-09-27 16:06
functions.lib.php	429.39 KB	-rw-r--r--	2022-09-27 16:06
functions2.lib.php	91.31 KB	-rw-r--r--	2022-09-27 16:06
functions_ch.lib.php	3.66 KB	-rw-r--r--	2022-09-27 16:06
functionsnumtoword.lib.php	9.96 KB	-rw-r--r--	2022-09-27 16:06
geturl.lib.php	14.68 KB	-rw-r--r--	2022-09-27 16:06
holiday.lib.php	3.43 KB	-rw-r--r--	2022-09-27 16:06
hrm.lib.php	3.21 KB	-rw-r--r--	2022-09-27 16:06
images.lib.php	24.95 KB	-rw-r--r--	2022-09-27 16:06
import.lib.php	1.89 KB	-rw-r--r--	2022-09-27 16:06
intracommreport.lib.php	2.59 KB	-rw-r--r--	2022-09-27 16:06
invoice.lib.php	50.52 KB	-rw-r--r--	2022-09-27 16:06
invoice2.lib.php	9.16 KB	-rw-r--r--	2022-09-27 16:06
json.lib.php	10.92 KB	-rw-r--r--	2022-09-27 16:06
ldap.lib.php	5.37 KB	-rw-r--r--	2022-09-27 16:06
loan.lib.php	5.24 KB	-rw-r--r--	2022-09-27 16:06
mailmanspip.lib.php	1.24 KB	-rw-r--r--	2022-09-27 16:06
member.lib.php	10.23 KB	-rw-r--r--	2022-09-27 16:06
memory.lib.php	9.5 KB	-rw-r--r--	2022-09-27 16:06
modulebuilder.lib.php	13.56 KB	-rw-r--r--	2022-09-27 16:06
multicurrency.lib.php	2.07 KB	-rw-r--r--	2022-09-27 16:06
oauth.lib.php	5.73 KB	-rw-r--r--	2022-09-27 16:06
order.lib.php	9.82 KB	-rw-r--r--	2022-09-27 16:06
parsemd.lib.php	2.54 KB	-rw-r--r--	2022-09-27 16:06
payments.lib.php	17.44 KB	-rw-r--r--	2022-09-27 16:06
pdf.lib.php	104 KB	-rw-r--r--	2022-09-27 16:06
phpsessionindb.lib.php	8.28 KB	-rw-r--r--	2022-09-27 16:06
prelevement.lib.php	3.23 KB	-rw-r--r--	2022-09-27 16:06
price.lib.php	21.38 KB	-rw-r--r--	2022-09-27 16:06
product.lib.php	24.78 KB	-rw-r--r--	2022-09-27 16:06
project.lib.php	111.69 KB	-rw-r--r--	2022-09-27 16:06
propal.lib.php	9.38 KB	-rw-r--r--	2022-09-27 16:06
receiptprinter.lib.php	2.19 KB	-rw-r--r--	2022-09-27 16:06
reception.lib.php	4.69 KB	-rw-r--r--	2022-09-27 16:06
report.lib.php	3.84 KB	-rw-r--r--	2022-09-27 16:06
resource.lib.php	4.7 KB	-rw-r--r--	2022-09-27 16:06
salaries.lib.php	3.54 KB	-rw-r--r--	2022-09-27 16:06
security.lib.php	38.24 KB	-rw-r--r--	2022-09-27 16:06
security2.lib.php	18.07 KB	-rw-r--r--	2022-09-27 16:06
sendings.lib.php	16.55 KB	-rw-r--r--	2022-09-27 16:06
signature.lib.php	4.08 KB	-rw-r--r--	2022-09-27 16:06
stock.lib.php	3.6 KB	-rw-r--r--	2022-09-27 16:06
supplier_proposal.lib.php	4.82 KB	-rw-r--r--	2022-09-27 16:06
takepos.lib.php	2.18 KB	-rw-r--r--	2022-09-27 16:06
tax.lib.php	56.03 KB	-rw-r--r--	2022-09-27 16:06
ticket.lib.php	36.72 KB	-rw-r--r--	2022-09-27 16:06
treeview.lib.php	9.23 KB	-rw-r--r--	2022-09-27 16:06
trip.lib.php	1.98 KB	-rw-r--r--	2022-09-27 16:06
usergroups.lib.php	42.7 KB	-rw-r--r--	2022-09-27 16:06
vat.lib.php	2.6 KB	-rw-r--r--	2022-09-27 16:06
website.lib.php	53.39 KB	-rw-r--r--	2022-09-27 16:06
website2.lib.php	24.95 KB	-rw-r--r--	2022-09-27 16:06
ws.lib.php	3.34 KB	-rw-r--r--	2022-09-27 16:06
xcal.lib.php	16.9 KB	-rw-r--r--	2022-09-27 16:06

Rename

<?php
/* Copyright (C) 2020 Laurent Destailleur  <eldy@users.sourceforge.net>
 *
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 * or see https://www.gnu.org/
 */

/**
 *  \file		htdocs/core/lib/phpsessionindb.lib.php
 *  \ingroup    core
 *  \brief		Set function handlers for PHP session management in DB.
 */

// The session handler file must be included just after the call of the master.inc.php into main.inc.php
// The $conf is already defined from conf.php file.
// To use it set in your PHP.ini:  session.save_handler = user

/**
 * The session open handler called by PHP whenever a session is initialized.
 *
 * @param	string	$save_path      Value of session.save_path into php.ini
 * @param	string	$session_name	Session name (Example: 'DOLSESSID_xxxxxx')
 * @return	boolean					Always true
 */
function dolSessionOpen($save_path, $session_name)
{
	global $dbsession;

global $dolibarr_main_db_type, $dolibarr_main_db_host;
	global $dolibarr_main_db_user, $dolibarr_main_db_pass, $dolibarr_main_db_name, $dolibarr_main_db_port;

global $dolibarr_session_db_type, $dolibarr_session_db_host;
	global $dolibarr_session_db_user, $dolibarr_session_db_pass, $dolibarr_session_db_name, $dolibarr_session_db_port;

if (empty($dolibarr_session_db_type)) {	$dolibarr_session_db_type = $dolibarr_main_db_type; }
	if (empty($dolibarr_session_db_host)) {	$dolibarr_session_db_host = $dolibarr_main_db_host; }
	if (empty($dolibarr_session_db_user)) {	$dolibarr_session_db_user = $dolibarr_main_db_user; }
	if (empty($dolibarr_session_db_pass)) {	$dolibarr_session_db_pass = $dolibarr_main_db_pass; }
	if (empty($dolibarr_session_db_name)) {	$dolibarr_session_db_name = $dolibarr_main_db_name; }
	if (empty($dolibarr_session_db_port)) {	$dolibarr_session_db_port = $dolibarr_main_db_port; }
	//var_dump('open '.$database_name.' '.$table_name);

$dbsession = getDoliDBInstance($dolibarr_session_db_type, $dolibarr_session_db_host, $dolibarr_session_db_user, $dolibarr_session_db_pass, $dolibarr_session_db_name, $dolibarr_session_db_port);

return true;
}

/**
 * This function is called whenever a session_start() call is made and reads the session variables.
 *
 * @param	string		$sess_id	Session ID
 * @return	string					Returns "" when a session is not found  or (serialized)string if session exists
 */
function dolSessionRead($sess_id)
{
	global $dbsession;
	global $sessionlastvalueread;
	global $sessionidfound;

$sql = "SELECT session_id, session_variable FROM ".MAIN_DB_PREFIX."session";
	$sql .= " WHERE session_id = '".$dbsession->escape($sess_id)."'";

// Execute the query
	$resql = $dbsession->query($sql);
	$num_rows = $dbsession->num_rows($resql);
	if ($num_rows == 0) {
		// No session found - return an empty string
		$sessionlastvalueread = '';
		$sessionidfound = '';
		return '';
	} else {
		// Found a session - return the serialized string
		$obj = $dbsession->fetch_object($resql);
		$sessionlastvalueread = $obj->session_variable;
		$sessionidfound = $obj->session_id;
		//var_dump($sessionlastvalueread);
		//var_dump($sessionidfound);
		return $obj->session_variable;
	}
}

/**
 * This function is called when a session is initialized with a session_start(  ) call, when variables are registered or unregistered,
 * and when session variables are modified. Returns true on success.
 *
 * @param	string		$sess_id		Session iDecodeStream
 * @param	string		$val			Content of session
 * @return	boolean						Always true
 */
function dolSessionWrite($sess_id, $val)
{
	global $dbsession;
	global $sessionlastvalueread;
	global $sessionidfound;

/*var_dump('write '.$sess_id);
	var_dump($val);
	var_dump('sessionlastvalueread='.$sessionlastvalueread.' sessionidfound='.$sessionidfound);
	*/

//$sessionlastvalueread='';
	if ($sessionlastvalueread != $val) {
		$time_stamp = dol_now();

if (empty($sessionidfound)) {
			// No session found, insert a new one
			$insert_query = "INSERT INTO ".MAIN_DB_PREFIX."session";
			$insert_query .= "(session_id, session_variable, last_accessed, fk_user, remote_ip, user_agent)";
			$insert_query .= " VALUES ('".$dbsession->escape($sess_id)."', '".$dbsession->escape($val)."', '".$dbsession->idate($time_stamp)."', 0, '".$dbsession->escape(getUserRemoteIP())."', '".$dbsession->escape(substr($_SERVER['HTTP_USER_AGENT'], 0, 255))."')";

$result = $dbsession->query($insert_query);
			if (!$result) {
				dol_print_error($dbsession);
				return false;
			}
		} else {
			if ($sessionidfound != $sess_id) {
				// oops. How can this happen ?
				dol_print_error($dbsession, 'Oops sess_id received in dolSessionWrite differs from the cache value $sessionidfound. How can this happen ?');
				return false;
			}
			/*$sql = "SELECT session_id, session_variable FROM ".MAIN_DB_PREFIX."session";
			$sql .= " WHERE session_id = '".$dbsession->escape($sess_id)."'";

// Execute the query
			$resql = $dbsession->query($sql);
			$num_rows = $dbsession->num_rows($resql);
			if ($num_rows == 0) {
			// No session found, insert a new one
			$insert_query = "INSERT INTO ".MAIN_DB_PREFIX."session";
			$insert_query .= "(session_id, session_variable, last_accessed, fk_user, remote_ip, user_agent)";
			$insert_query .= " VALUES ('".$dbsession->escape($sess_id)."', '".$dbsession->escape($val)."', '".$dbsession->idate($time_stamp)."', 0, '".$dbsession->escape(getUserRemoteIP())."', '".$dbsession->escape(substr($_SERVER['HTTP_USER_AGENT'], 0, 255)."')";
			var_dump($insert_query);
			$result = $dbsession->query($insert_query);
			if (!$result) {
				dol_print_error($dbsession);
				return false;
			}
			} else {
			*/
			// Existing session found - Update the session variables
			$update_query = "UPDATE ".MAIN_DB_PREFIX."session";
			$update_query .= " SET session_variable = '".$dbsession->escape($val)."',";
			$update_query .= " last_accessed = '".$dbsession->idate($time_stamp)."',";
			$update_query .= " remote_ip = '".$dbsession->escape(getUserRemoteIP())."',";
			$update_query .= " user_agent = '".$dbsession->escape($_SERVER['HTTP_USER_AGENT'])."'";
			$update_query .= " WHERE session_id = '".$dbsession->escape($sess_id)."'";

$result = $dbsession->query($update_query);
			if (!$result) {
				dol_print_error($dbsession);
				return false;
			}
		}
	}

return true;
}

/**
 * This function is executed on shutdown of the session.
 *
 * @return	boolean					Always returns true.
 */
function dolSessionClose()
{
	global $dbsession;

//var_dump('close');

$dbsession->close();

return true;
}

/**
 * This is called whenever the session_destroy() function call is made. Returns true if the session has successfully been deleted.
 *
 * @param	string	$sess_id		Session iDecodeStream
 * @return	boolean					Always true
 */
function dolSessionDestroy($sess_id)
{
	global $dbsession;

//var_dump('destroy');

$delete_query = "DELETE FROM ".MAIN_DB_PREFIX."session";
	$delete_query .= " WHERE session_id = '".$dbsession->escape($sess_id)."'";
	$dbsession->query($delete_query);

return true;
}

/**
 * This function is called on a session's start up with the probability specified in session.gc_probability.
 * Performs garbage collection by removing all sessions that haven't been updated in the last $max_lifetime seconds as set in session.gc_maxlifetime.
 *
 * @param	int		$max_lifetime		Max lifetime
 * @return	boolean						true if the DELETE query succeeded.
 */
function dolSessionGC($max_lifetime)
{
	global $dbsession;

$time_stamp = dol_now();

$delete_query = "DELETE FROM ".MAIN_DB_PREFIX."session";
	$delete_query .= " WHERE last_accessed < '".$dbsession->idate($time_stamp - $max_lifetime)."'";

$resql = $dbsession->query($delete_query);
	if ($resql) {
		return true;
	} else {
		return false;
	}
}

// Call to register user call back functions.
session_set_save_handler("dolSessionOpen", "dolSessionClose", "dolSessionRead", "dolSessionWrite", "dolSessionDestroy", "dolSessionGC");