SQL-Befehle:

ALTER TABLE `accounts` ADD `schoollesson` TINYINT( 4 ) DEFAULT '3' NOT NULL ;
ALTER TABLE `accounts` ADD `schooltest` TINYINT( 4 ) DEFAULT '1' NOT NULL ;
ALTER TABLE `accounts` ADD `iq` INT( 11 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `accounts` ADD `testright` TINYINT( 4 ) DEFAULT '0' NOT NULL ;
ALTER TABLE `accounts` ADD `testfalse` TINYINT( 4 ) DEFAULT '0' NOT NULL ;


ffne village.php

suche:
addnav("Tavernenstrasse");

fge danach ein:
addnav("Dorfschule","dorfschule.php");


ffne dragon.php

suche (2x):
,"reputation"=>1

fge danach ein:
,"iq"=>1


ffne hof.php

suche:
addnav("Edelsteine", "hof.php?op=gems&subop=$subop&page=$page");

fge danach ein:
addnav("Intelligenz", "hof.php?op=iq&subop=$subop&page=$page");

suche:
} elseif ($_GET[op] == "gems") {
	$sql = "SELECT name FROM accounts WHERE locked=0 ORDER BY gems $order, level $order, experience $order, acctid $order LIMIT $limit";
	if ($_GET[subop] == "least") $adverb = "wenigsten";
	else $adverb = "meisten";
	$title = "Die Krieger mit den $adverb Edelsteinen";
	display_table($title, $sql);

fge danach ein:
} elseif ($_GET[op]=="iq"){
	$sql = "SELECT name,iq AS data1,$sexsel AS data2,$racesel AS data3 FROM accounts WHERE locked=0 ORDER BY iq $order, level $order, experience $order, acctid $order LIMIT $limit";
	$adverb = "intelligentesten";
	if ($_GET[subop] == "least") $adverb = "dmmsten";
	$title = "Die $adverb Krieger in diesem Land.";
	$headers = array("Intelligenz", "<img src=\"images/female.gif\">/<img src=\"images/male.gif\">", "Rasse");
	display_table($title, $sql, false, false, $headers, false);