Page 738 of 741 FirstFirst ... 238638688728736737738739740 ... LastLast
Results 7,371 to 7,380 of 7405
  1. #7371
    hi, i try to add script but get thisq error
    9 erreurs trouvées lors de l'analyse.

    Caractère inattendu. (near "$" at position 41)
    Caractère inattendu. (near "$" at position 43)
    Une expression était attendue. (near "IN" at position 16)
    Mot clé non reconnu. (near "IN" at position 16)
    Mot clé non reconnu. (near "EXISTS" at position 19)
    Jeton inattendu. (near "addLogPlayerID" at position 26)
    Jeton inattendu. (near "$" at position 41)
    Jeton inattendu. (near "$" at position 43)
    Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)
    Requête SQL : Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

    MySQL a répondu : Documentation

    #1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2

  2. #7372
    Translation:
    9 errors found during the analysis.

    Unexpected character (near "$" at position 41)
    Unexpected character (near "$" at position 43)
    An expression was expected. (near "IN" at position 16)
    Unrecognized keyword. (near "IN" at position 16)
    Unrecognized keyword. (near "EXISTS" at position 19)
    Unexpected token (near "addLogPlayerID" at position 26)
    Unexpected token (near "$" at position 41)
    Unexpected token (near "$" at position 43)
    A new statement has been found, but there is no delimiter between it and the previous one. (near "CREATE" at position 46)
    SQL query: Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID () BEGIN - Add column logPlayerID safely IF NOT EXISTS ((SELECT * FROM info_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE () AND COLUMN_NAME = 'logPlayerID' AND TABLE_NAME = 'tbl_chatlog' )) THEN ALTER TABLE `tbl_chatlog` ADD COLUMN `logPlayerID` INT (10) DEFAULT UNSIGNED NULL

    MySQL replied: Documentation

    # 1064 - Syntax error near 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID () START - Add 'to line 2

  3. #7373
    Quote Originally Posted by HARAFAT69 View Post
    hi, i try to add script but get thisq error
    9 erreurs trouvées lors de l'analyse.

    Caractère inattendu. (near "$" at position 41)
    Caractère inattendu. (near "$" at position 43)
    Une expression était attendue. (near "IN" at position 16)
    Mot clé non reconnu. (near "IN" at position 16)
    Mot clé non reconnu. (near "EXISTS" at position 19)
    Jeton inattendu. (near "addLogPlayerID" at position 26)
    Jeton inattendu. (near "$" at position 41)
    Jeton inattendu. (near "$" at position 43)
    Un nouvel énoncé a été trouvé, mais il n'y a aucun délimiteur entre celui-ci et le précédent. (near "CREATE" at position 46)
    Requête SQL : Documentation

    DROP PROCEDURE IN EXISTS addLogPlayerID $ $ CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajouter la colonne logPlayerID en toute sécurité IF NOT EXISTS( ( SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = DATABASE() AND COLUMN_NAME = ' logPlayerID ' ET TABLE_NAME = ' tbl_chatlog ') ) ALORS ALTER TABLE ` tbl_chatlog ` ADD COLUMN ` logPlayerID ` INT(10) DEFAULT UNSIGNED NULL

    MySQL a répondu : Documentation

    #1064 - Erreur de syntaxe près de 'IN EXISTS addLogPlayerID $ $
    CREATE PROCEDURE addLogPlayerID() COMMENCER - Ajou' à la ligne 2
    "IN EXISTS" is incorrect syntax. Something translated this code into an invalid state. Please run the script exactly as-is without any changes.
    ____

  4. #7374
    thanks, i didn't see chrome traduct pages and code in this case so it's fixed

  5. #7375
    what can cause tbl_extendedroundstats to be empty ? have adkats feeding the statlogger and table was created but nothing is ever written to it.

  6. #7376
    Quote Originally Posted by sixpax12 View Post
    what can cause tbl_extendedroundstats to be empty ? have adkats feeding the statlogger and table was created but nothing is ever written to it.
    extended round stats is actually an AdKats table. AdKats creates it and fills it. It was probably dumb to create it with the stat logger prefix tbl though.

    There were some issues with roundID not being incremented so that could be the reason. You'll know you have the issue if the 'Server Round (Display)' setting in the server setting section always shows 1. That issue was patched so update to the latest test version and wait for a few rounds.
    ____

  7. #7377
    Quote Originally Posted by ColColonCleaner View Post
    extended round stats is actually an AdKats table. AdKats creates it and fills it. It was probably dumb to create it with the stat logger prefix tbl though.

    There were some issues with roundID not being incremented so that could be the reason. You'll know you have the issue if the 'Server Round (Display)' setting in the server setting section always shows 1. That issue was patched so update to the latest test version and wait for a few rounds.
    thank you colcolon have updated all servers so will wait for some rounds to complete ... i noticed the server round setting was set to zero instead of 1 after layer reboot ...

    Edit: The table is populating with data across all servers !
    Last edited by sixpax12; 27-03-2019 at 23:26.

  8. #7378
    i have searched for this query and have not been able to locate it anywhere.

    'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.

  9. #7379
    Quote Originally Posted by sixpax12 View Post
    i have searched for this query and have not been able to locate it anywhere.

    'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.
    checking in on where I can find said query from above.

  10. #7380
    Quote Originally Posted by sixpax12 View Post
    i have searched for this query and have not been able to locate it anywhere.

    'Post Map Benefit/Detriment Statistics' - Whether to post statistics on which maps are most beneficial/detrimental to the population of the server. Queries to extract meaning from this information can be acquired in the main AdKats forum thread.
    https://forum.myrcon.com/showthread....l=1#post111562

    Code:
    SELECT 
        `InnerResults`.*,
        ROUND((`map_benefit` - `map_detriment`)/`map_rounds`, 2) AS `map_benefit_numeric`
    FROM
    (
    SELECT
        `server_id` AS `server`,
        `tbl_server`.`ServerName` AS `server_name`,
        `target_name` AS `map_code`,
        (
            SELECT 
                count(`stat_id`)
            FROM 
                `adkats_statistics`
            WHERE
                `server_id` = `server`
            AND
                `target_name` = `map_code`
            AND
                `stat_type` = 'map_benefit'
        ) AS `map_rounds`,
        (
            SELECT 
                SUM(`stat_value`)
            FROM 
                `adkats_statistics`
            WHERE
                `server_id` = `server`
            AND
                `target_name` = `map_code`
            AND
                `stat_type` = 'map_benefit'
        ) AS `map_benefit`,
        (
            SELECT 
                SUM(`stat_value`)
            FROM 
                `adkats_statistics`
            WHERE
                `server_id` = `server`
            AND
                `target_name` = `map_code`
            AND
                `stat_type` = 'map_detriment'
        ) AS `map_detriment`
    FROM
        `adkats_statistics`
    INNER JOIN
        `tbl_server`
    ON
        `server_id` = `tbl_server`.`ServerID`
    WHERE
        `stat_type` = 'map_benefit'
        OR
        `stat_type` = 'map_detriment'
    GROUP BY
        `server_id`, `target_name`
    ) AS `InnerResults`
    ORDER BY
        `InnerResults`.`server` ASC, `map_benefit_numeric` DESC;
    Another query: https://forum.myrcon.com/showthread....l=1#post111613

    Looks like i never actually added that section to the manual with these queries.
    ____

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •