[versatile_bfg]

What would be needed in the mysql table:
"CREATE TABLE IF NOT EXISTS `warmod_table` (`match_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `match_start` DATETIME NOT NULL, `match_end` DATETIME NOT NULL, `map` VARCHAR(64) NOT NULL, `max_rounds` TINYINT(3) unsigned NOT NULL, `overtime_max_rounds` TINYINT(3) UNSIGNED NOT NULL, `overtime_count` TINYINT(3) UNSIGNED NOT NULL, `played_out` TINYINT(1) NOT NULL, `t_name` VARCHAR(12 NOT NULL, `t_overall_score` TINYINT(3) UNSIGNED NOT NULL, `t_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_overtime_score` TINYINT(3) UNSIGNED NOT NULL, `ct_name` VARCHAR(12 NOT NULL, `ct_overall_score` TINYINT(3) UNSIGNED NOT NULL, `ct_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_overtime_score` TINYINT(3) UNSIGNED NOT NULL, 'demo' VARCHAR(12, PRIMARY KEY (`match_id`));

[SirNickParks]

Sadly I have logging off as to conserve the minimal space I have. I'll see if I can run another one and try to grab it though.

[SirNickParks]

Originally Posted by versatile_bfg What would be needed in the mysql table: "CREATE TABLE IF NOT EXISTS `warmod_table` (`match_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `match_start` DATETIME NOT NULL, `match_end` DATETIME NOT NULL, `map` VARCHAR(64) NOT NULL, `max_rounds` TINYINT(3) unsigned NOT NULL, `overtime_max_rounds` TINYINT(3) UNSIGNED NOT NULL, `overtime_count` TINYINT(3) UNSIGNED NOT NULL, `played_out` TINYINT(1) NOT NULL, `t_name` VARCHAR(12 NOT NULL, `t_overall_score` TINYINT(3) UNSIGNED NOT NULL, `t_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_overtime_score` TINYINT(3) UNSIGNED NOT NULL, `ct_name` VARCHAR(12 NOT NULL, `ct_overall_score` TINYINT(3) UNSIGNED NOT NULL, `ct_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_overtime_score` TINYINT(3) UNSIGNED NOT NULL, 'demo' VARCHAR(12, PRIMARY KEY (`match_id`));

Looks great

Can't wait till it's released

[versatile_bfg]

Originally Posted by SirNickParks Sadly I have logging off as to conserve the minimal space I have. I'll see if I can run another one and try to grab it though.

dw about the log. It was only to see what maps were left.

[kurodz]

Originally Posted by versatile_bfg What would be needed in the mysql table: "CREATE TABLE IF NOT EXISTS `warmod_table` (`match_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `match_start` DATETIME NOT NULL, `match_end` DATETIME NOT NULL, `map` VARCHAR(64) NOT NULL, `max_rounds` TINYINT(3) unsigned NOT NULL, `overtime_max_rounds` TINYINT(3) UNSIGNED NOT NULL, `overtime_count` TINYINT(3) UNSIGNED NOT NULL, `played_out` TINYINT(1) NOT NULL, `t_name` VARCHAR(12 NOT NULL, `t_overall_score` TINYINT(3) UNSIGNED NOT NULL, `t_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `t_overtime_score` TINYINT(3) UNSIGNED NOT NULL, `ct_name` VARCHAR(12 NOT NULL, `ct_overall_score` TINYINT(3) UNSIGNED NOT NULL, `ct_first_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_second_half_score` TINYINT(3) UNSIGNED NOT NULL, `ct_overtime_score` TINYINT(3) UNSIGNED NOT NULL, 'demo' VARCHAR(12, PRIMARY KEY (`match_id`));

maybe RWS & ELO system ?

[SirNickParks]

Originally Posted by kurodz maybe RWS & ELO system ?

I don't know much about RWS so I won't comment on it.

However as for an ELO system I feel like that's the providers deal to handle, E.G. creating the system himself and having it based off the SQL inserts the plugin would do it and assign ELO per who won etc.

An ELO system just doesn't seem like it should be the plugins job to handle, nor do I feel like it should really belong in the plugin.

Just my opinion though

[versatile_bfg]

yeah don't see myself doing something like that.

[versatile_bfg]

Beta 0.5.6 - 13-08-2015
- Added MySQL results upload
-- wm_upload_results "0" //Enable or disable the uploading of match results via MySQL
-- wm_table_name "wm_results" //The MySQL table name to store match results in
- added arrays to wm_forceteam
-- arrays are cleared on lo3/ko3 and by these commands
--- wm_clear_forceteam_all //Clears the list for forced teams
--- wm_clear_forceteam_t //Clears the list for forced terrorist team
--- wm_clear_forceteam_ct //Clears the list for forced counter-terrorist team
- added previous score to score command if match is not active
- added check captain file for team name and logo/flag

[versatile_bfg]

For MySQL database you will need to add this to your sourcemod databases.cfg

    "warmod"
    {
        "driver"            "default"
        "host"            "localhost"
        "database"        "sourcemod"
        "user"            "root"
        "pass"            ""
        //"timeout"        "0"
        //"port"            "0"
    }

[SirNickParks]

Are the players still required to be in the server in order to force them to a team?