#!/usr/bin/php
<?php 
/**
 * languagess
 */
namespace CB;

$path = dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . 'httpsdocs' . DIRECTORY_SEPARATOR;
require_once $path . 'config_platform.php';
// select main translations
$T = array();
$cfg = Config::getPlatformDBConfig();
$languages = explode(',', $cfg['languages']);
$res = DB\dbQuery('SELECT name, `' . implode('`,`', $languages) . '`
    FROM ' . \CB\PREFIX . '_casebox.translations
    WHERE `type` in (0,2)') or die(DB\dbQueryError());
while ($r = $res->fetch_assoc()) {
    reset($r);
    $name = current($r);
    while (($v = next($r)) !== false) {
        $T[key($r)][] = "'" . $name . "':'" . addcslashes($v, "'") . "'";
    }
}
$res->close();
//save each translations as main language file
saveFiles($T);
echo "main language files saved\n";
//iterate cores and collect those that have custom translations
$cores = array();
$res = DB\dbQuery('SELECT name, cfg FROM ' . \CB\PREFIX . '_casebox.cores') or die(DB\dbQueryError());
while ($r = $res->fetch_assoc()) {