ifunctions.php

泛微协同办公系统标准版E-office V5.5的源代码内含泛微办公系统V5.5自动注册文件。

						$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportCreateTable'], "phpQAdmin" );
						return 0;
					}
					if ( !mysql_query( "INSERT INTO phpQAdmin (Passwd,".join( ",", $phpQF[$table] ).") VALUES (".phpq2sql( $phpQAdmin['Passwd'] ).",".join( ",", $sqlvalues ).")" ) )
					{
						$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportInsertTable'], "phpQAdmin" );
						return 0;
					}
					$tcreated[$table] = 1;
				}
			}
			else if ( isset( $phpQF[$table] ) )
			{
				if ( $flag == "erase" && !$tcreated[$table] )
				{
					mysql_query( "DROP TABLE {$table}" );
					if ( !mysql_query( $phpQC[$table] ) )
					{
						$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportCreateTable'], $table );
						return 0;
					}
					$tcreated[$table] = 1;
				}
				$i = 0;
				for ( ;	$i < count( $phpQR[$table] );	$i += 2	)
				{
					$rid = $phpQR[$table][$i];
					$rname = $phpQR[$table][$i + 1];
					if ( isset( $idmap[$rname][$sqlvalues[$rid]] ) )
					{
						$sqlvalues[$rid] = "\"".protectmysql( $idmap[$rname][$sqlvalues[$rid]] )."\"";
					}
				}
				$mqinsert = mysql_query( "INSERT INTO {$table} (".join( ",", $phpQF[$table] ).") VALUES (".join( ",", $sqlvalues ).")" );
				if ( !$mqinsert && $flag != "erase" && isset( $phpQU[$table] ) )
				{
					$tnames = $phpQF[$table];
					$tvalues = $sqlvalues;
					array_splice( $tnames, $phpQU[$table][0], 1 );
					array_splice( $tvalues, $phpQU[$table][0], 1 );
					$ufield = $phpQU[$table][1];
					$uvalue = $ufield == "UID" ? generateuid( ) : "NULL";
					if ( mysql_query( "INSERT INTO {$table} ({$ufield},".join( ",", $tnames ).") VALUES ({$uvalue},".join( ",", $tvalues ).")" ) )
					{
						$uvalue = $ufield == "UID" ? $uvalue : mysql_insert_id( );
						$idmap[$ufield][$sqlvalues[$phpQU[$table][0]]] = $uvalue;
					}
					else
					{
						$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportInsertTable'], $table );
						return 0;
					}
				}
				else if ( !$mqinsert )
				{
					$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportInsertTable'], $table );
					return 0;
				}
			}
		}
	}
	if ( $flag == "erase" )
	{
		$tablea = array( "phpQSurvey", "phpQQuestion", "phpQAnswer", "phpQUser" );
		$i = 0;
		for ( ;	$i < count( $tablea );	++$i	)
		{
			$table = $tablea[$i];
			if ( !$tcreated[$table] )
			{
				mysql_query( "DROP TABLE {$table}" );
				if ( !mysql_query( $phpQC[$table] ) )
				{
					$GLOBALS['message'] = $action.sprintf( $phpQlang['ImportCreateTable'], $table );
					return 0;
				}
				$tcreated[$table] = 1;
			}
		}
	}
	return $sid;
}

function phpq2sql( $mystring )
{
	if ( $mystring == "=NULL=" )
	{
		$mystring = "";
	}
	return "\"".protectmysql( urldecode( $mystring ) )."\"";
}

function finditemplate( $template )
{
	$templates = gettemplates( );
	if ( !count( $templates ) )
	{
		return "";
	}
	if ( isset( $templates[$template] ) )
	{
		return $template;
	}
	global $phpQAdmin;
	if ( isset( $templates[$phpQAdmin['Template']] ) )
	{
		return $phpQAdmin['Template'];
	}
	if ( isset( $templates['default'] ) )
	{
		return "default";
	}
	foreach ( $templates as $temp => $name )
	{
		return $temp;
	}
	return "";
}

function findilanguage( $language )
{
	$languages = getlanguages( );
	if ( !count( $languages ) )
	{
		return "";
	}
	if ( isset( $languages[$language] ) )
	{
		return $language;
	}
	global $phpQAdmin;
	if ( isset( $languages[$phpQAdmin['Language']] ) )
	{
		return $phpQAdmin['Language'];
	}
	if ( isset( $languages['chinese'] ) )
	{
		return "chinese";
	}
	foreach ( $languages as $lang => $name )
	{
		return $lang;
	}
	return "";
}

function generateuid( )
{
	global $HTTP_SERVER_VARS;
	global $REMOTE_ADDR;
	list( $usec, $sec ) = explode( " ", microtime( ) );
	$usec *= 1000000;
	$ip = $REMOTE_ADDR ? $REMOTE_ADDR : $HTTP_SERVER_VARS['REMOTE_ADDR'];
	mt_srand( time( ) ^ ( integer )$usec ^ ip2long( $ip ) ^ ( integer )getmypid( ) );
	$loop = true;
	while ( $loop )
	{
		$randval = mt_rand( 1000000000, 1999999999 );
		$mquser = mysql_query( "select * from phpQUser where UID = \"{$randval}\"" );
		if ( !( $mauser = mysql_fetch_array( $mquser ) ) )
		{
			$loop = false;
		}
	}
	return $randval;
}

?>