<?php

$tables = array( 'cart_inventory', 'char', 'charlog', 'friends', 'global_reg_value', 'guild', 'guild_alliance', 'guild_castle', 'guild_expulsion', 'guild_member','guild_position', 'guild_skill', 
				'guild_storage', 'interlog', 'inventory', 'login', 'mail', 'memo', 'party', 'pet', 'ragsrvinfo', 'skill', 'sstatus', 'storage');


$sql = new mysqli(..);
if(!$sql){
	fprintf(STDERR, "Failed to connect to DBSERVER\n");
	return 1;
}

function check_int($str){
	$start =  ord('0');
	$end = ord('9');

	if(is_int($str))
		return true;	

	$len = strlen($str);
	for($i = 0; $i < $len; $i++){
		$c = ord($str[$i]);
		if($c < $start || $c > $end)
			return false;
	}
	
	return true;
}


//
foreach($tables as $n => &$table){
	
	$r = $sql->query('SELECT * FROM `'.$table.'`;');
	if(!$r){
		fprintf(STDERR, "Failed to SELECT * FROM $table\n");
		return 1;
	}
	
	fprintf(STDERR, 'Begin %s ', $table);
	fflush(STDERR);
	$outSQL = "BEGIN TRANSACTION;\n";
	$n = 0;
	$rows = 0;
	$needHead = true;
	while( ($row = $r->fetch_assoc()) ){
		$n++;
		$rows++;
		if($n == 300){
			$outSQL .= ";\n";
			$outSQL .= "COMMIT TRANSACTION;\n";
			$outSQL .= "BEGIN TRANSACTION;\n";
			fprintf(STDERR, '.');
			fflush(STDERR);
			$needHead = true;
			$n = 0;
		}
		
		$cols = '';
		$data = '';
		$i = 0;
		foreach($row as $name => &$value){
			if($i++ > 0){ 
				$cols .= ', ';
				$data .= ', ';
			}
			
			$cols .= "[$name]";
			
			if(check_int($value))
				$data .= "$value";
			else
				$data .= "'".addslashes($value)."'";
		}
		unset($name, $value);

		if($needHead){
			$needHead = false;
			$outSQL .= "INSERT INTO [$table] ($cols) VALUES ";
			$outSQL .= "($data)";
		}else
			$outSQL .= ", ($data)";
		//$outSQL .= "INSERT INTO [$table] ($cols) VALUES ($data);\n";
		
		unset($cols, $data);
		
	}
	$outSQL .= ";\n";
	$outSQL .= "COMMIT TRANSACTION;\n";
	$outSQL .= "-- Table $table => $rows Rows\n\n";
	fprintf(STDERR, " done (%u Rows)\n", $rows);
	
	print $outSQL;
	
	unset($r, $outSQL);
}