Quote:Sql Fehler: SELECT Count(id) As exist_village,userid,id,name,x,y,continent,r_wood,r_stone,r_iron,last_prod_aktu,r_bh,control_villages,recruited_snobs,attacks,agreement,agreement_aktu,dealers_outside,create_time,main,barracks,stable,garage,smith,snob,place,statue,market,wood,stone,iron,farm,storage,hide,wall,unit_spear_tec_level,unit_sword_tec_level,unit_axe_tec_level,unit_archer_tec_level,unit_spy_tec_level,unit_light_tec_level,unit_marcher_tec_level,unit_heavy_tec_level,unit_ram_tec_level,unit_catapult_tec_level from villages where id='1' GROUP BY
userid,id,name,x,y,continent,r_wood,r_stone,r_iron,last_prod_aktu,r_bh,control_villages,recruited_snobs,attacks,agreement,agreement_aktu,dealers_outside,create_time,main,barracks,stable,garage,smith,snob,place,statue,market,wood,stone,iron,farm,storage,hide,wall,unit_spear_tec_level,unit_sword_tec_level,unit_axe_tec_level,unit_archer_tec_level,unit_spy_tec_level,unit_light_tec_level,unit_marcher_tec_level,unit_heavy_tec_level,unit_ram_tec_level,unit_catapult_tec_level
MySql Error: Unknown column 'statue' in 'field list'

Quote:

Code:

$cl_units->add_unit("Bogenschuetze","unit_archer");
$cl_units->set_woodprice("100");
$cl_units->set_stoneprice("30");
$cl_units->set_ironprice("60 ");
$cl_units->set_bhprice("1");
$cl_units->set_time("1250");
$cl_units->set_att("15","1.045");
$cl_units->set_def("50","1.045");
$cl_units->set_defcav("40","1.045");
$cl_units->set_defarcher("5","1.045");
$cl_units->set_speed("720");
$cl_units->set_booty("10");
$cl_units->set_needed(array("barracks"=>"5","smith"=>"5" ));
$cl_units->set_recruit_in("barracks");
$cl_units->set_specials(array(""));
$cl_units->set_group("foot");
$cl_units->set_col("A");
$cl_units->set_description("Der Bogenschuetze ist ein effektiver Verteidiger.Selbst gepanzerte Ruestungen werden im Pfeilhagel durchschlagen.");

$cl_units->add_unit("Berittener Bogenschuetze","unit_marcher");
$cl_units->set_woodprice("250");
$cl_units->set_stoneprice("100");
$cl_units->set_ironprice("150 ");
$cl_units->set_bhprice("5");
$cl_units->set_time("5422");
$cl_units->set_att("120","1.045");
$cl_units->set_def("40","1.045");
$cl_units->set_defcav("30","1.045");
$cl_units->set_defarcher("50","1.045");
$cl_units->set_speed("600");
$cl_units->set_booty("50");
$cl_units->set_needed(array("stable"=>"5","smith"=>"2" ));
$cl_units->set_recruit_in("stable");
$cl_units->set_specials(array(""));
$cl_units->set_group("cav");
$cl_units->set_col("B");
$cl_units->set_description("Der berittene Bogenschuetze ist besonders geeignet um mit prezisen Schuessen feindliche Bogenschuetzen von der Mauer zu holen.");

Quote:

Code:

$cl_techs->add_tech("Bogen","archer");
$cl_techs->set_group("Infanterie");
$cl_techs->set_woodprice("640","1.6");
$cl_techs->set_stoneprice("560","1.6");
$cl_techs->set_ironprice("740","1.6");
$cl_techs->set_time("2458","1.75");
$cl_techs->set_maxStage("1");
$cl_techs->set_needed(array("smith"=>"2" ));
$cl_techs->set_description("Der Bogenschuetze ist ein effektiver Verteidiger.Selbst gepanzerte Ruestungen werden im Pfeilhagel durchschlagen.");

$cl_techs->add_tech("Berittener Bogenschuetze","marcher");
$cl_techs->set_group("Kavallerie");
$cl_techs->set_woodprice("3000","1.6");
$cl_techs->set_stoneprice("2400","1.6");
$cl_techs->set_ironprice("2000","1.6");
$cl_techs->set_time("2154","1.75");
$cl_techs->set_maxStage("1");
$cl_techs->set_needed(array("stable"=>"5","smith"=>"2" ));
$cl_techs->set_description("Der berittene Bogenschuetze ist besonders geeignet um mit prezisen Schuessen feindliche Bogenschuetzen von der Mauer zu holen.");