EOT;
$catList = buildCatList();
//$albList = albumselect();
$picAlbList = albumselect('picAlbum');
if ($_REQUEST['category'] && $_REQUEST['what'] == 'getCat') {
$selected = " selected";
}
starttable('100%', 'Select the item for which you want to enter language strings', 6);
echo <<
EOT;
endtable();
if (isset($_GET['sync'])) {
$allowedTypes = array('categories', 'albums', 'pictures','lang');
if (!in_array($_GET['sync'], $allowedTypes)) {
cpg_die(ERROR, 'Invalid Sync Type', __FILE__, __LINE__);
}
$func = "sync_".$_GET['sync'];
$func();
}
if (isset($_POST['update'])) {
updateLangData();
}
if (isset($_REQUEST['what'])) {
switch($_REQUEST['what']) {
case 'getCat':
buildForm($_REQUEST['category'], 'getCat');
break;
case 'getAlb':
buildForm($_REQUEST['category'], 'getAlb');
break;
case 'getPic':
buildForm($_REQUEST['picAlbum'], 'getPic');
break;
default:
cpg_die(ERROR, 'Invalid action performed', __FILE__, __LINE__);
}
}
pagefooter();
function buildForm($val, $what) {
global $CONFIG, $catPerPage, $picPerPage, $albPerPage, $start;
$langArr = explode(',', $CONFIG['mod_active_lang']);
$langCount = count($langArr);
if ($what == 'getAlb' && $val == 'none') {
return;
}
if ($what == 'getCat' && !$val) {
return;
}
if ($what == 'picAlbum' && !$val) {
return;
}
if ($what == 'getCat') {
$lowerLimit = $start*$catPerPage*$langCount;
$higherLimit = $catPerPage*$langCount;
$hiddenFields = '';
$queryString = "&category=$val";
$query = "SELECT * FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE original != '' AND (type = 'catName' OR type = 'catDesc') ORDER BY origId, type LIMIT $lowerLimit, $higherLimit";
$countQuery = "SELECT count(id) FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE original != '' AND (type = 'catName' OR type = 'catDesc')";
} elseif ($what == 'getAlb') {
// Get the albums for the selected category..
if ($val == 1) {
$whereClause = " WHERE category > '".FIRST_USER_CAT."'";
} else {
$whereClause = " WHERE category = '$val'";
}
$query = "SELECT aid FROM {$CONFIG['TABLE_ALBUMS']} $whereClause";
$result = cpg_db_query($query);
$aidArr = array();
while ($row = cpg_db_fetch_row($result)) {
$aidArr[] = $row['aid'];
}
if (!count($aidArr)) {
cpg_die(ERROR, 'No albums in this category', __FILE__, __LINE__);
}
$aidStr = implode(',', $aidArr);
$lowerLimit = $start*$albPerPage*$langCount;
$higherLimit = $albPerPage*$langCount;
$hiddenFields = '';
$queryString = "&category=$val";
$query = "SELECT * FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE origId IN ($aidStr) AND original != '' AND (type = 'albName' OR type = 'albDesc') ORDER BY origId, type LIMIT $lowerLimit, $higherLimit";
$countQuery = "SELECT count(id) FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE origId IN ($aidStr) AND original != '' AND (type = 'albName' OR type = 'albDesc')";
} elseif ($what == 'getPic') {
$query = "SELECT pid FROM {$CONFIG['TABLE_PICTURES']} WHERE aid = '$val'";
$result = cpg_db_query($query);
$pidArr = array();
while ($row = cpg_db_fetch_row($result)) {
$pidArr[] = $row['pid'];
}
if (!count($pidArr)) {
cpg_die(ERROR, 'No pictures in this album', __FILE__, __LINE__);
}
$pidStr = implode(',', $pidArr);
$lowerLimit = $start*$picPerPage*$langCount;
$higherLimit = $picPerPage*$langCount;
$hiddenFields = '';
$queryString = "&picAlbum=$val";
$query = "SELECT * FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE origId IN ($pidStr) AND original != '' AND (type = 'picTitle' OR type = 'picDesc') ORDER BY origId, type LIMIT $lowerLimit, $higherLimit";
$countQuery = "SELECT count(id) FROM {$CONFIG['TABLE_LANG_STRINGS']} WHERE origId IN ($pidStr) AND original != '' AND (type = 'picTitle' OR type = 'picDesc')";
}
$result = cpg_db_query($query);
$countResult = cpg_db_query($countQuery);
while ($row1 = cpg_db_fetch_row($result)) {
$rowset[$row1['origId']][$row1['type']]['lang'][$row1['lang']] = array($row1['id'], $row1['translated']);
$rowset[$row1['origId']][$row1['type']]['original'] = $row1['original'];
}
$nr = cpg_db_fetch_row($countResult);
$totalCount = $nr[0];
$totalPages = ceil($totalCount/$higherLimit);
echo "
EOT;
}
function updateLangData() {
global $CONFIG;
foreach ($_POST as $key => $val) {
if (is_numeric($key)) {
$query = "UPDATE {$CONFIG['TABLE_LANG_STRINGS']} SET translated = '$val' WHERE id = '$key'";
cpg_db_query($query);
}
}
}
?>