hey guys, just installed this as an alternative. everything seems pretty good overall, I do however have an issue with the weapons section coming back with db errors. From what I can tell, its due to the item not being in the plugin anymore or something similar.
The issue is as follows:
http://tfstats.getsome.co.nz/weapon_ranking.php
Code:
Query SELECT sum(bat) as Sum FROM `Player` failed: Unknown column 'bat' in 'field list'Query SELECT sum(bottle) as Sum FROM `Player` failed: Unknown column 'bottle' in 'field list'Query SELECT sum(fireaxe) as Sum FROM `Player` failed: Unknown column 'fireaxe' in 'field list'Query SELECT sum(club) as Sum FROM `Player` failed: Unknown column 'club' in 'field list'Query SELECT sum(knife) as Sum FROM `Player` failed: Unknown column 'knife' in 'field list'Query SELECT sum(fists) as Sum FROM `Player` failed: Unknown column 'fists' in 'field list'Query SELECT sum(shovel) as Sum FROM `Player` failed: Unknown column 'shovel' in 'field list'Query SELECT sum(wrench) as Sum FROM `Player` failed: Unknown column 'wrench' in 'field list'Query SELECT sum(bonesaw) as Sum FROM `Player` failed: Unknown column 'bonesaw' in 'field list'Query SELECT sum(shotgun_primary) as Sum FROM `Player` failed: Unknown column 'shotgun_primary' in 'field list'Query SELECT sum(shotgun_soldier) as Sum FROM `Player` failed: Unknown column 'shotgun_soldier' in 'field list'Query SELECT sum(shotgun_hwg) as Sum FROM `Player` failed: Unknown column 'shotgun_hwg' in 'field list'Query SELECT sum(shotgun_pyro) as Sum FROM `Player` failed: Unknown column 'shotgun_pyro' in 'field list'Query SELECT sum(scattergun) as Sum FROM `Player` failed: Unknown column 'scattergun' in 'field list'Query SELECT sum(sniperrifle) as Sum FROM `Player` failed: Unknown column 'sniperrifle' in 'field list'Query SELECT sum(minigun) as Sum FROM `Player` failed: Unknown column 'minigun' in 'field list'Query SELECT sum(smg) as Sum FROM `Player` failed: Unknown column 'smg' in 'field list'Query SELECT sum(syringegun_medic) as Sum FROM `Player` failed: Unknown column 'syringegun_medic' in 'field list'Query SELECT sum(tf_projectile_rocket) as Sum FROM `Player` failed: Unknown column 'tf_projectile_rocket' in 'field list'Query SELECT sum(tf_projectile_pipe) as Sum FROM `Player` failed: Unknown column 'tf_projectile_pipe' in 'field list'Query SELECT sum(tf_projectile_pipe_remote) as Sum FROM `Player` failed: Unknown column 'tf_projectile_pipe_remote' in 'field list'Query SELECT sum(flamethrower) as Sum FROM `Player` failed: Unknown column 'flamethrower' in 'field list'Query SELECT sum(pistol) as Sum FROM `Player` failed: Unknown column 'pistol' in 'field list'Query SELECT sum(pistol_scout) as Sum FROM `Player` failed: Unknown column 'pistol_scout' in 'field list'Query SELECT sum(revolver) as Sum FROM `Player` failed: Unknown column 'revolver' in 'field list'Query SELECT sum(blutsauger) as Sum FROM `Player` failed: Unknown column 'blutsauger' in 'field list'Query SELECT sum(ubersaw) as Sum FROM `Player` failed: Unknown column 'ubersaw' in 'field list'Query SELECT sum(axtinguisher) as Sum FROM `Player` failed: Unknown column 'axtinguisher' in 'field list'Query SELECT sum(flaregun) as Sum FROM `Player` failed: Unknown column 'flaregun' in 'field list'Query SELECT sum(backburner) as Sum FROM `Player` failed: Unknown column 'backburner' in 'field list'Query SELECT sum(natascha) as Sum FROM `Player` failed: Unknown column 'natascha' in 'field list'Query SELECT sum(gloves) as Sum FROM `Player` failed: Unknown column 'gloves' in 'field list'Query SELECT sum(sandman) as Sum FROM `Player` failed: Unknown column 'sandman' in 'field list'Query SELECT sum(force_a_nature) as Sum FROM `Player` failed: Unknown column 'force_a_nature' in 'field list'Query SELECT sum(tf_projectile_arrow) as Sum FROM `Player` failed: Unknown column 'tf_projectile_arrow' in 'field list'Query SELECT sum(ambassador) as Sum FROM `Player` failed: Unknown column 'ambassador' in 'field list'Query SELECT sum(rocketlauncher_directhit) as Sum FROM `Player` failed: Unknown column 'rocketlauncher_directhit' in 'field list'Query SELECT sum(unique_pickaxe) as Sum FROM `Player` failed: Unknown column 'unique_pickaxe' in 'field list'Query SELECT sum(sticky_resistance) as Sum FROM `Player` failed: Unknown column 'sticky_resistance' in 'field list'Query SELECT sum(demoshield) as Sum FROM `Player` failed: Unknown column 'demoshield' in 'field list'Query SELECT sum(sword) as Sum FROM `Player` failed: Unknown column 'sword' in 'field list'Query SELECT sum(wrangler_kill) as Sum FROM `Player` failed: Unknown column 'wrangler_kill' in 'field list'Query SELECT sum(frontier_justice) as Sum FROM `Player` failed: Unknown column 'frontier_justice' in 'field list'Query SELECT sum(robot_arm_combo_kill) as Sum FROM `Player` failed: Unknown column 'robot_arm_combo_kill' in 'field list'Query SELECT sum(robot_arm) as Sum FROM `Player` failed: Unknown column 'robot_arm' in 'field list'Query SELECT sum(sledgehammer) as Sum FROM `Player` failed: Unknown column 'sledgehammer' in 'field list'Query SELECT sum(paintrain) as Sum FROM `Player` failed: Unknown column 'paintrain' in 'field list'Query SELECT sum(southern_hospitality) as Sum FROM `Player` failed: Unknown column 'southern_hospitality' in 'field list'Query SELECT sum(samrevolver) as Sum FROM `Player` failed: Unknown column 'samrevolver' in 'field list'Query SELECT sum(wrench_golden) as Sum FROM `Player` failed: Unknown column 'wrench_golden' in 'field list'Query SELECT sum(tribalkukri) as Sum FROM `Player` failed: Unknown column 'tribalkukri' in 'field list'Query SELECT sum(battleaxe) as Sum FROM `Player` failed: Unknown column 'battleaxe' in 'field list'Query SELECT sum(battleneedle) as Sum FROM `Player` failed: Unknown column 'battleneedle' in 'field list'Query SELECT sum(powerjack) as Sum FROM `Player` failed: Unknown column 'powerjack' in 'field list'Query SELECT sum(degreaser) as Sum FROM `Player` failed: Unknown column 'degreaser' in 'field list'Query SELECT sum(short_stop) as Sum FROM `Player` failed: Unknown column 'short_stop' in 'field list'Query SELECT sum(holy_mackerel) as Sum FROM `Player` failed: Unknown column 'holy_mackerel' in 'field list'Query SELECT sum(letranger) as Sum FROM `Player` failed: Unknown column 'letranger' in 'field list'Query SELECT sum(eternal_reward) as Sum FROM `Player` failed: Unknown column 'eternal_reward' in 'field list'Query SELECT sum(blackbox) as Sum FROM `Player` failed: Unknown column 'blackbox' in 'field list'Query SELECT sum(sydney_sleeper) as Sum FROM `Player` failed: Unknown column 'sydney_sleeper' in 'field list'Query SELECT sum(bushwacka) as Sum FROM `Player` failed: Unknown column 'bushwacka' in 'field list'Query SELECT sum(gloves_running_urgently) as Sum FROM `Player` failed: Unknown column 'gloves_running_urgently' in 'field list'Query SELECT sum(fryingpan) as Sum FROM `Player` failed: Unknown column 'fryingpan' in 'field list'Query SELECT sum(headtaker) as Sum FROM `Player` failed: Unknown column 'headtaker' in 'field list'Query SELECT sum(maxgun) as Sum FROM `Player` failed: Unknown column 'maxgun' in 'field list'Query SELECT sum(iron_curtain) as Sum FROM `Player` failed: Unknown column 'iron_curtain' in 'field list'Query SELECT sum(amputator) as Sum FROM `Player` failed: Unknown column 'amputator' in 'field list'Query SELECT sum(crusaders_crossbow) as Sum FROM `Player` failed: Unknown column 'crusaders_crossbow' in 'field list'Query SELECT sum(ullapool_caber_explosion) as Sum FROM `Player` failed: Unknown column 'ullapool_caber_explosion' in 'field list'Query SELECT sum(ullapool_caber) as Sum FROM `Player` failed: Unknown column 'ullapool_caber' in 'field list'Query SELECT sum(loch_n_load) as Sum FROM `Player` failed: Unknown column 'loch_n_load' in 'field list'Query SELECT sum(warrior_spirit) as Sum FROM `Player` failed: Unknown column 'warrior_spirit' in 'field list'Query SELECT sum(brass_beast) as Sum FROM `Player` failed: Unknown column 'brass_beast' in 'field list'Query SELECT sum(candy_cane) as Sum FROM `Player` failed: Unknown column 'candy_cane' in 'field list'Query SELECT sum(boston_basher) as Sum FROM `Player` failed: Unknown column 'boston_basher' in 'field list'Query SELECT sum(back_scratcher) as Sum FROM `Player` failed: Unknown column 'back_scratcher' in 'field list'Query SELECT sum(claidheamohmor) as Sum FROM `Player` failed: Unknown column 'claidheamohmor' in 'field list'Query SELECT sum(wrench_jag) as Sum FROM `Player` failed: Unknown column 'wrench_jag' in 'field list'Query SELECT sum(steel_fists) as Sum FROM `Player` failed: Unknown column 'steel_fists' in 'field list'Query SELECT sum(lava_axe) as Sum FROM `Player` failed: Unknown column 'lava_axe' in 'field list'Query SELECT sum(lava_bat) as Sum FROM `Player` failed: Unknown column 'lava_bat' in 'field list'Query SELECT sum(detonator) as Sum FROM `Player` failed: Unknown column 'detonator' in 'field list'Query SELECT sum(warfan) as Sum FROM `Player` failed: Unknown column 'warfan' in 'field list'Query SELECT sum(kunai) as Sum FROM `Player` failed: Unknown column 'kunai' in 'field list'Query SELECT sum(demokatana) as Sum FROM `Player` failed: Unknown column 'demokatana' in 'field list'Query SELECT sum(shahanshah) as Sum FROM `Player` failed: Unknown column 'shahanshah' in 'field list'Query SELECT sum(bazaar_bargain) as Sum FROM `Player` failed: Unknown column 'bazaar_bargain' in 'field list'Query SELECT sum(persian_persuader) as Sum FROM `Player` failed: Unknown column 'persian_persuader' in 'field list'Query SELECT sum(splendid_screen) as Sum FROM `Player` failed: Unknown column 'splendid_screen' in 'field list'Query SELECT sum(proto_syringe) as Sum FROM `Player` failed: Unknown column 'proto_syringe' in 'field list'Query SELECT sum(solemn_vow) as Sum FROM `Player` failed: Unknown column 'solemn_vow' in 'field list'Query SELECT sum(liberty_launcher) as Sum FROM `Player` failed: Unknown column 'liberty_launcher' in 'field list'Query SELECT sum(reserve_shooter) as Sum FROM `Player` failed: Unknown column 'reserve_shooter' in 'field list'Query SELECT sum(market_gardener) as Sum FROM `Player` failed: Unknown column 'market_gardener' in 'field list'Query SELECT sum(saxxy) as Sum FROM `Player` failed: Unknown column 'saxxy' in 'field list'Query SELECT sum(tomislav) as Sum FROM `Player` failed: Unknown column 'tomislav' in 'field list'Query SELECT sum(family_business) as Sum FROM `Player` failed: Unknown column 'family_business' in 'field list'Query SELECT sum(eviction_notice) as Sum FROM `Player` failed: Unknown column 'eviction_notice' in 'field list'Query SELECT sum(cow_mangler) as Sum FROM `Player` failed: Unknown column 'cow_mangler' in 'field list'Query SELECT sum(cow_mangler) as Sum FROM `Player` failed: Unknown column 'cow_mangler' in 'field list'Query SELECT sum(righteous_bison) as Sum FROM `Player` failed: Unknown column 'righteous_bison' in 'field list'Query SELECT sum(mantreads) as Sum FROM `Player` failed: Unknown column 'mantreads' in 'field list'Query SELECT sum(disciplinary_action) as Sum FROM `Player` failed: Unknown column 'disciplinary_action' in 'field list'Query SELECT sum(soda_popper) as Sum FROM `Player` failed: Unknown column 'soda_popper' in 'field list'Query SELECT sum(the_winger) as Sum FROM `Player` failed: Unknown column 'the_winger' in 'field list'Query SELECT sum(atomizer) as Sum FROM `Player` failed: Unknown column 'atomizer' in 'field list'Query SELECT sum(scout_sword) as Sum FROM `Player` failed: Unknown column 'scout_sword' in 'field list'Query SELECT sum(mailbox) as Sum FROM `Player` failed: Unknown column 'mailbox' in 'field list'Query SELECT sum(enforcer) as Sum FROM `Player` failed: Unknown column 'enforcer' in 'field list'Query SELECT sum(big_earner) as Sum FROM `Player` failed: Unknown column 'big_earner' in 'field list'Query SELECT sum(the_maul) as Sum FROM `Player` failed: Unknown column 'the_maul' in 'field list'Query SELECT sum(nonnonviolent_protest) as Sum FROM `Player` failed: Unknown column 'nonnonviolent_protest' in 'field list'Query SELECT sum(nessieclub) as Sum FROM `Player` failed: Unknown column 'nessieclub' in 'field list'Query SELECT sum(quake_rl) as Sum FROM `Player` failed: Unknown column 'quake_rl' in 'field list'Query SELECT sum(diamondback) as Sum FROM `Player` failed: Unknown column 'diamondback' in 'field list'Query SELECT sum(player_penetration) as Sum FROM `Player` failed: Unknown column 'player_penetration' in 'field list'Query SELECT sum(machina) as Sum FROM `Player` failed: Unknown column 'machina' in 'field list'Query SELECT sum(widowmaker) as Sum FROM `Player` failed: Unknown column 'widowmaker' in 'field list'Query SELECT sum(short_circuit) as Sum FROM `Player` failed: Unknown column 'short_circuit' in 'field list'Query SELECT sum(unarmed_combat) as Sum FROM `Player` failed: Unknown column 'unarmed_combat' in 'field list'Query SELECT sum(voodoo_pin) as Sum FROM `Player` failed: Unknown column 'voodoo_pin' in 'field list'Query SELECT sum(apocofists) as Sum FROM `Player` failed: Unknown column 'apocofists' in 'field list'Query SELECT sum(pomson) as Sum FROM `Player` failed: Unknown column 'pomson' in 'field list'Query SELECT sum(eureka_effect) as Sum FROM `Player` failed: Unknown column 'eureka_effect' in 'field list'Query SELECT sum(thirddegree) as Sum FROM `Player` failed: Unknown column 'thirddegree' in 'field list'Query SELECT sum(phlogistinator) as Sum FROM `Player` failed: Unknown column 'phlogistinator' in 'field list'Query SELECT sum(manmelter) as Sum FROM `Player` failed: Unknown column 'manmelter' in 'field list'Query SELECT sum(scotland_shard) as Sum FROM `Player` failed: Unknown column 'scotland_shard' in 'field list'Query SELECT sum(sharp_dresser) as Sum FROM `Player` failed: Unknown column 'sharp_dresser' in 'field list'Query SELECT sum(wrap_assassin) as Sum FROM `Player` failed: Unknown column 'wrap_assassin' in 'field list'Query SELECT sum(spy_cicle) as Sum FROM `Player` failed: Unknown column 'spy_cicle' in 'field list'Query SELECT sum(holiday_punch) as Sum FROM `Player` failed: Unknown column 'holiday_punch' in 'field list'Query SELECT sum(black_rose) as Sum FROM `Player` failed: Unknown column 'black_rose' in 'field list'Query SELECT sum(ball) as Sum FROM `Player` failed: Unknown column 'ball' in 'field list'Query SELECT sum(bleed_kill) as Sum FROM `Player` failed: Unknown column 'bleed_kill' in 'field list'Query SELECT sum(taunt_demoman) as Sum FROM `Player` failed: Unknown column 'taunt_demoman' in 'field list'Query SELECT sum(deflect_arrow) as Sum FROM `Player` failed: Unknown column 'deflect_arrow' in 'field list'Query SELECT sum(tf_projectile_energy_ball) as Sum FROM `Player` failed: Unknown column 'tf_projectile_energy_ball' in 'field list'Query SELECT sum(deflect_flare) as Sum FROM `Player` failed: Unknown column 'deflect_flare' in 'field list'Query SELECT sum(deflect_promode) as Sum FROM `Player` failed: Unknown column 'deflect_promode' in 'field list'Query SELECT sum(deflect_rocket) as Sum FROM `Player` failed: Unknown column 'deflect_rocket' in 'field list'Query SELECT sum(deflect_sticky) as Sum FROM `Player` failed: Unknown column 'deflect_sticky' in 'field list'Query SELECT sum(taunt_guitar_kill) as Sum FROM `Player` failed: Unknown column 'taunt_guitar_kill' in 'field list'Query SELECT sum(world) as Sum FROM `Player` failed: Unknown column 'world' in 'field list'Query SELECT sum(eyeball_rocket) as Sum FROM `Player` failed: Unknown column 'eyeball_rocket' in 'field list'Query SELECT sum(taunt_spy) as Sum FROM `Player` failed: Unknown column 'taunt_spy' in 'field list'Query SELECT sum(goomba) as Sum FROM `Player` failed: Unknown column 'goomba' in 'field list'Query SELECT sum(taunt_pyro) as Sum FROM `Player` failed: Unknown column 'taunt_pyro' in 'field list'Query SELECT sum(taunt_scout) as Sum FROM `Player` failed: Unknown column 'taunt_scout' in 'field list'Query SELECT sum(compound_bow) as Sum FROM `Player` failed: Unknown column 'compound_bow' in 'field list'Query SELECT sum(taunt_soldier) as Sum FROM `Player` failed: Unknown column 'taunt_soldier' in 'field list'Query SELECT sum(obj_minisentry) as Sum FROM `Player` failed: Unknown column 'obj_minisentry' in 'field list'Query SELECT sum(robot_arm_blender_kill) as Sum FROM `Player` failed: Unknown column 'robot_arm_blender_kill' in 'field list'Query SELECT sum(tf_pumpkin_bomb) as Sum FROM `Player` failed: Unknown column 'tf_pumpkin_bomb' in 'field list'Query SELECT sum(obj_sentrygun) as Sum FROM `Player` failed: Unknown column 'obj_sentrygun' in 'field list'Query SELECT sum(obj_sentrygun2) as Sum FROM `Player` failed: Unknown column 'obj_sentrygun2' in 'field list'Query SELECT sum(obj_sentrygun3) as Sum FROM `Player` failed: Unknown column 'obj_sentrygun3' in 'field list'Query SELECT sum(taunt_heavy) as Sum FROM `Player` failed: Unknown column 'taunt_heavy' in 'field list'Query SELECT sum(taunt_sniper) as Sum FROM `Player` failed: Unknown column 'taunt_sniper' in 'field list'Query SELECT sum(player) as Sum FROM `Player` failed: Unknown column 'player' in 'field list'Query SELECT sum(telefrag) as Sum FROM `Player` failed: Unknown column 'telefrag' in 'field list'Query SELECT sum(taunt_soldier_lumbricus) as Sum FROM `Player` failed: Unknown column 'taunt_soldier_lumbricus' in 'field list'
Can I also make a suggestion for a slight modification, to be able to make categories, so we can have the mvm servers separate from normal gameplay servers. as mvm pushes stats up.
I mean having a second db just wont work for the same system, I do not want it to be separate systems.
cheers!