<?php
require_once '../htdocs/config.inc';
require_once LIB . 'Default/SmrMySqlDatabase.class.inc';
require_once LIB . 'Default/Globals.class.inc';
require_once LIB . 'Default/SmrPlayer.class.inc';
$db = new SmrMySqlDatabase();
$db2 = new SmrMySqlDatabase();
//$db->query('SELECT * FROM combat_logs WHERE type=\'PLAYER\' ORDER BY OCTET_LENGTH(result) DESC LIMIT 1');
//if($db->nextRecord())
//{
// $x = $db->getField('result');
// $y = gzuncompress($x);
// var_dump($y);
//
// $z = serialize(unserialize($y));
// var_dump($z);
//
// var_dump(strlen($x));
// var_dump(strlen(gzcompress($z)));
// var_dump(strlen(bzcompress($z)));
//}
$db->query('SELECT result,log_id FROM combat_logs');
while ($db->nextRecord()) {
$db2->query('UPDATE combat_logs SET result=' . $db2->escapeBinary(gzcompress(serialize(unserialize(gzuncompress($db->getField('result')))))) . ' WHERE log_id=' . $db->getField('log_id'));
}
