Scienco.org

<?php	
/**
 * Taken partially from wp-db-backup [1] and is partially self-made [2].
 *
 * [1] uses some libraries, whereas I [2] don't. This is possibly slower and less fail
 * tolerant, but then it doesn't depent on anything other than PHP and MySQL.
 *
 * I [2] am fully aware that it could be done nice with more functions, classes
 * and so on. But this is ment to be simple and do nothing else, so I've
 * permitted myself [2] to write these lines so "messy" :-).
 *
 * [1] : http://www.ilfilosofo.com/blog/wp-db-backup/
 * [2] : Mikkel Meyer Andersen (aka. mikl-dk), http://www.scienco.org 
 */
 
/*
 * Here a MySQL-connection is made and the database chosen
 */
require('../top.php');
 
/*
 * Just a nice little function seperated from the other mess
 */
function secure_addslashes($str = '') 
{
	return str_replace('\'', '\\\'', str_replace('\\', '\\\\', $str));
} 
 
$output = '';
 
/* 
 * From [1]: ensures that the different non-printable chars are printed, e.g. newline
 */
$search = array("\x00", "\x0a", "\x0d", "\x1a");
$replace = array('\0', '\n', '\r', '\Z');
 
/*
 * All the tables from the selected database are selected
 */
$result = @mysql_query("SHOW TABLES") or exception(mysql_error());
 
while ($data = mysql_fetch_array($result))
{
	/* From [1]: Used to differ between using ' to non-integer types 
	 * and use nothing to integer types
	 */
	$result_f = @mysql_query("DESCRIBE `" . $data[0] . "`") or exception(mysql_error());
 
	$ints = array();
 
	while ($data_f = mysql_fetch_assoc($result_f))
	{
		if (
				(false !== strpos(strtolower($data_f['Type']), 'tinyint')) 		||
				(false !== strpos(strtolower($data_f['Type']), 'smallint')) 	||
				(false !== strpos(strtolower($data_f['Type']), 'mediumint')) 	||
				(false !== strpos(strtolower($data_f['Type']), 'int')) 			||
				(false !== strpos(strtolower($data_f['Type']), 'bigint')) 		||
				(false !== strpos(strtolower($data_f['Type']), 'timestamp')) 
			) 
		{
				$ints[strtolower($data_f['Field'])] = "1";
		}
	}	
 
	$result_t = @mysql_query("SHOW CREATE TABLE `" . $data[0] . "`") or exception(mysql_error());
	$data_t = mysql_fetch_array($result_t);
 
	$output .= "DROP TABLE IF EXISTS `" . $data[0] . "`;";
	$output .= "\n\n";
	$output .= $data_t[1] . " ;\n";
	$output .= "\n\n";
 
	$result_d = @mysql_query("SELECT * FROM `" . $data[0] . "`") or exception(mysql_error());
	$entries = 'INSERT INTO `' . $data[0] . '` VALUES (';
 
	while ($data_d = mysql_fetch_assoc($result_d))
	{		
		$values = array();
 
		foreach ($data_d as $key => $value) 
		{		
			if ($ints[strtolower($key)]) 
			{
				$values[] = $value;
			} 
 
			else 
			{
				$values[] = "'" . str_replace($search, $replace, secure_addslashes($value)) . "'";
			}
		}
 
		$output .= " \n" . $entries . implode(', ', $values) . ') ;';
	}
 
	$output .= "\n\n\n";
}
 
echo $output;
?>

$filename = date("Y-m-d") . '.gz';
$zp = gzopen($filename, "w9");
gzwrite($zp, $output);
gzclose($zp);

using System;
using System.Collections;
using System.Collections.Generic;
 
namespace experiments
{
	class MainClass
	{
		public static void Main(string[] args)
		{
			C<int> c = new C<int>(1, 2, 3, 4, 5);
 
			Console.WriteLine("IEnumerable<T>:");
			foreach (int e in c)
			{				
				Console.WriteLine(e);
			}
			Console.WriteLine();
 
			Console.WriteLine("Implicit conversion to List<T>:");			
			foreach (int e in (List<int>)c)
			{
				Console.WriteLine(e);
			}
			Console.WriteLine();
 
			Console.WriteLine("Implicit conversion to T[]:");
			foreach (int e in (int[])c)
			{
				Console.WriteLine(e);
			}
		}
	}	
 
	class C<T> : IEnumerable<T> 		
	{		
		protected List<T> list;
 
		public C(params T[] elements)
		{		
			this.list = new List<T>();
 
			for (int i = 0; i < elements.Length; ++i)
			{
				this.list.Add(elements[i]);
			}
		}
 
		public IEnumerator<T> GetEnumerator() 
		{
			for (int i = this.list.Count - 1; i >= 0; --i)
			{
				yield return this.list[i];
			}
		}
 
		IEnumerator IEnumerable.GetEnumerator() 
		{
			return GetEnumerator();
		}
 
		public static implicit operator List<T>(C<T> c)
		{
			return new List<T>(c.list);
		}		
 
		public static implicit operator T[](C<T> c)
		{
			T[] arr = new T[c.list.Count];			
 
			if (c.list.Count > 0)
			{
				int j = 0;
 
				for (int i = c.list.Count / 2; i >= 0; --i)
				{
					arr[j++] = c.list[i];
				}
 
				for (int i = (c.list.Count / 2) + 1; i < c.list.Count; ++i)
				{
					arr[j++] = c.list[i];
				}
			}
 
			return arr;
		}		
	}
}

IEnumerable<T>:
5
4
3
2
1
 
Implicit conversion to List<T>:
1
2
3
4
5
 
Implicit conversion to T[]:
3
2
1
4
5

<soapenv:envelope
	xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
	xmlns="http://tews6/wsdl"
	xmlns:xsd="http://www.w3.org/2001/XMLSchema"
	xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://schemas.xmlsoap.org/soap/envelope/ http://schemas.xmlsoap.org/soap/envelope/">
	<soapenv:body>
		<soapenv:fault>
			<faultcode>soapenv:Client</faultcode>
			<faultstring>Error performing operation.</faultstring>
			<detail>
				<imsexception version="6.0">
					<exception>
						<name>CheckForDuplicates</name>
						<code>500</code>
						<description><!--[CDATA[User id johndoe is a duplicate. ProcessStep::BLTHValidate TabName:  ERRORLEVEL::Error]]--></description>
					</exception>
				</imsexception>
			</detail>
		</soapenv:fault>
	</soapenv:body>
</soapenv:envelope>

ssh user@ssh-server -L local-port-to-bind-to:host-to-reach:the-port-on-the-host

ssh user@ssh-server -L x:y:z