[Cloman]

Originally Posted by MaloModo Does this still work?

For me and others it does.
Have you tried it ?

[Kamil445]

Simple Steam2 to Steam3 PHP converter (convert STEAM_0: to U:0

DO NOT FORGET CREATE BACKUP!!!

PHP Code:

<?php 
define('HOST', 'localhost');        //set MySQL host 
define('USER', 'root');             //MySQL username 
define('PASS', 'pass');         //MySQL password 
define('DB', '');                //MySQL DB Name 
 
 
try { 
    $db = new PDO('mysql:host=' . HOST . ';dbname=' . DB . ';charset=utf8', USER, PASS); 
    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); 
    $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false); 
} catch (Exception $ex) { 
    echo "unable to connect to database"; 
    die(); 
} 
 
$stmt = $db->prepare("UPDATE player SET `STEAMID` = ? WHERE STEAMID =?"); 
 
foreach ($db->query("SELECT STEAMID FROM player") as $steam2) { 
    try { 
        if (strpos($steam2['STEAMID'], '[U:') === false) { 
            $steam3 = steam3($steam2['STEAMID']); 
            $stmt->bindParam(1, $steam3); 
            $stmt->bindParam(2, $steam2['STEAMID']); 
            $stmt->execute(); 
 
            printf("Updating %s to %s<br />", $steam2['STEAMID'], $steam3); 
        } else { 
            printf('skipping %s<br />', $steam2['STEAMID']); 
        } 
    } catch (Exception $ex) { 
        printf('Updating %s failed', $steam2['STEAMID']); 
    } 
} 
 
function steam3($steam2) { 
    $id = explode(':', $steam2); 
    $id3 = ($id[2] * 2) + $id[1]; 
    return '[U:1:' . $id3 . ']'; 
}

[Disrupted_Hunter]

Is there a way to remove everyone's points that has ever been on the server? I tried to unload the plugin and then reload it but that did not work

[Cloman]

Originally Posted by Disrupted_Hunter Is there a way to remove everyone's points that has ever been on the server? I tried to unload the plugin and then reload it but that did not work

Only the player points or just a fresh start ?
Do you use mysql or out of the box database setup ?

As if you use sqllite you can just delete the tf2stats.sq3
in location "\tf\addons\sourcemod\data\sqlite\" and reload(better restart) and your ready to go.

[Disrupted_Hunter]

Originally Posted by Cloman Only the player points or just a fresh start ? Do you use mysql or out of the box database setup ? As if you use sqllite you can just delete the tf2stats.sq3 in location "\tf\addons\sourcemod\data\sqlite\" and reload(better restart) and your ready to go.

Just the player points. I don't use the web ranking, I unfortunately have no idea how to set it up

[Gutty]

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

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!

[Jillchang]

any way to make this where at round end, it shows a menu panel listing top 10 players THAT are currently in server?

I'd be willing to donate money for this feature as a big thank you...

[Sil3nt702]

Pretty sure this has been answered but don't feel like searching through a hundred pages... Does this have the option to purge stats if a player hasn't been on the server after (x) days?

[Jillchang]

Originally Posted by Sil3nt702 Pretty sure this has been answered but don't feel like searching through a hundred pages... Does this have the option to purge stats if a player hasn't been on the server after (x) days?

Yes.

Do you know if there is any way to make this where at round end, it shows a menu panel listing top 10 players THAT are currently in server?

[Sil3nt702]

How do I add multiple databases in settings.php? I have two db's and have it setup like this:

$mysql_database = "tf2_stats";"tf2_turbine";

But it's only seeing people from the first db "tf2_stats"