words.php

jsp程序开发系统

	dev_words_export($location);
	admin_footer();
	exit;
}

if ($_REQUEST['do'] == 'dev_import_do') {

	developer_check();
	
	admin_header('Languages', 'Import From Files');
	if (ini_set('track_errors', 1) === FALSE) {
		$errors[] = "[WARNING] track_errors is not enabled and could not be enabled; detailed errors will not be available.";
		$php_errormsg = 'Unknown error.';
	}

	$location = dirname(__FILE__) . '/templates/words';

	dev_words_import($location);
	exit;
}

// Search for unused wordrefs

if ($_REQUEST['do'] == "search_wordref") {

	developer_check();

	admin_header('Languages', 'Find Unused Words');

	if (is_win()) {
		echo "<B>Error:</B> This function is not currently supported on Windows platforms.";
		admin_footer();
		exit;
	}

	$words = $db->query_return_array("SELECT DISTINCT wordref FROM template_words");

	if (is_array($words)) {
		foreach ($words AS $word) {
			$db->query("SELECT id FROM template WHERE template LIKE '%\$dplang[%$word[wordref]%]%'");
			if ($db->num_rows()) {
				continue;
			}

			exec('grep -ri "dplang\[\'*' . $word['wordref'] . '\'*\]" ../*', $messages, $return);
			if (count($messages)) {
				continue;
			}

			unset($messages);

			// jump('*', 'foo');
			exec('grep -ri "jump(.*' . $word['wordref'] . '.*)" ../*', $messages, $return);
			if (count($messages)) {
				continue;
			}

			unset($messages);

			$disused[] = $word['wordref'];
		}
	}

	print "<P><B>Unused Words:</B><BR>";
	if (is_array($disused)) {
		if (count($disused)) {
			foreach($disused AS $word) {
				print "$word<BR>\n";
			}
		} else {
			print "None";
		}
	} else {
		print "None";
	}

	print "</P>";
	exit;
}


############################### UPDATE WORDS (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "updatewords") {

	developer_check();

	$db->query("DELETE FROM template_words WHERE language = 0");

	foreach ($_REQUEST['wordname'] AS $key => $var) {

		if ($var != '' AND (!@in_array($var, $array))) {

			$array[] = $var;

		$db->query("INSERT INTO template_words SET
					text = '" . mysql_escape_string($_REQUEST['text'][$key]) . "',
					wordref = '" . mysql_escape_string($var) . "',
					category = '" . $_REQUEST['category'][$key] . "'
				");	
		}
	}

	$_REQUEST['do'] = 'admin_edit';

}

############################### REBUILD ENGLISH DEFAULTS (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "default_langs") {

	developer_check();

	new_db_class(2);

	$entries = $db->query_return_array("SELECT * FROM template_words WHERE cust");
	if ($db->num_rows()) {
		foreach ($entries AS $entry) {
			$db->query("UPDATE template_words SET
				language = '$entry[language]',
				wordref = '" . mysql_escape_string($entry[wordref]) . "',
				text = '" . mysql_escape_string($entry[text]) . "',
				category = '$entry[category]',
				cust = 0
			");
		}
		$db->query("DELETE FROM languages WHERE cust");
	}

}

############################### VIEW WORDS (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "admin_edit") {

	developer_check();

	$db->query("SELECT * FROM template_words_cat");
	while ($result = $db->row_array()) {
		$cat[$result[id]] = $result[name];
	}

	$db->query("SELECT template_words.*, template_words_cat.name AS catname FROM template_words 
				LEFT JOIN template_words_cat ON (template_words_cat.id = template_words.category)
				WHERE language = 0 
				ORDER BY category, wordref
				");
		
		unset($lastname);

	while ($result = $db->row_array()) {

		if ($result[catname] != $lastname) {
			$table[] = table_midheader($result[catname]);
		}

		$i++;

		$table[] = array(
			form_input($i, $result[wordref], 30, 'wordname', 1),
			form_select($i, $cat, 'category', $result[category], NULL, NULL, NULL, NULL, 1),
			form_input($i, $result[text], 125, 'text', 1)
		);

		$lastname = $result[catname];

	}

	$table[] = table_midheader('Blank');

	while ($y < 10) {

		$i++;

		$table[] = array(
			form_input($i, $result[wordref], 30, 'wordname', 1),
			form_select($i, $cat, 'category', $result[category], NULL, NULL, NULL, NULL, 1),
			form_input($i, $result[text], 125, 'text', 1)
		);

		$y++;

	}

	table_header('Default Words', 'words.php', array('do' => 'updatewords'));
	table_content('', $table);
	table_footer('Updatewords');

	?>
	<br /><hr>
	<a href="words.php?do=viewcats">View Categories</a><br />
	<a href="words.php?do=view">View Words</a><br />
	<a href="words.php?do=default_langs">Rebuild language defaults</a><br />
	<form method="post" action="words.php"><input type="hidden" name="do" value="newcat">
	New Category <input type="text" name="name"><input type="submit" name="submit" value="submit">
	</form>
	<?php

}

############################### NEW CATEGORY (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "newcat") {

	developer_check();

	$db->query("INSERT INTO template_words_cat SET name = '" . mysql_escape_string($_REQUEST['name']) . "'");
	$_REQUEST['do'] = "admin_cats";

}

############################### UPDATE CATEGORIES (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "catupdate") {

	developer_check();

	foreach ($_REQUEST['name'] AS $key => $var) {
		$db->query("UPDATE template_words_cat SET
					name = '" . mysql_escape_string($_REQUEST['newname'][$key]) . "',
					displayorder = '" . mysql_escape_string($_REQUEST['displayorder'][$key]) . "'
					WHERE name = '$key'
				");

	}

	$_REQUEST['do'] = "admin_cats";
}

############################### VIEW CATEGORIES (DEVELOPER ONLY) ###############################

if ($_REQUEST['do'] == "admin_cats") {

	developer_check();

	$db->query("SELECT * FROM template_words_cat ORDER BY displayorder");
	while ($result = $db->row_array()) {
		$table[] = array(form_input($result[name], $result[displayorder], 3, 'displayorder', 1),
						form_hidden($result[name], $result[name], 'name', 1),
						form_input($result[name], $result[name], 30, 'newname', 1));
	}

	table_header('Categories', 'words.php', array('do' => 'catupdate'));
	table_content('', $table);
	table_footer('Submit');

	?>
	<br /><hr>
	<a href="words.php?do=viewcats">View Categories</a><br />
	<a href="words.php?do=view">View Words</a><br />
	<a href="words.php?do=default_langs">Rebuild language defaults</a><br />
	<form method="post" action="words.php"><input type="hidden" name="do" value="newcat">
	New Category <input type="text" name="name"><input type="submit" name="submit" value="submit">
	</form>
	<?php

}

?>