Page 51 of 185 FirstFirst ... 41495051525361101151 ... LastLast
Results 501 to 510 of 1843
  1. #501
    Will the plugin be updated to add an option to exclude the commo-rose spam?

  2. #502
    Community Contributor
    Join Date
    Nov 2011
    Posts
    3,031
    Quote Originally Posted by TMiland View Post
    Will the plugin be updated to add an option to exclude the commo-rose spam?
    The plugin already has the option for you to add any regex you want to filter out any text you want.

  3. #503
    Quote Originally Posted by ty_ger07 View Post
    The plugin already has the option for you to add any regex you want to filter out any text you want.
    Any idea what that regex would look like?

    Nm, found it! https://forum.myrcon.com/showthread....ll=1#post84205

    And 24236 rows deleted from database!! That's a few commo-rose entries :P
    Last edited by TMiland; 21-01-2014 at 06:54.

  4. #504
    Hi
    Question, must i delete after few weeks the Stats from the plugin, cause Server Crashes.
    How can i erase it?

  5. #505
    Quote Originally Posted by chesterfield View Post
    Hi
    Question, must i delete after few weeks the Stats from the plugin, cause Server Crashes.
    How can i erase it?
    Don't understand the question/issue

  6. #506
    Hey XpKiller,

    I love the plugin. I just have an idea for an option.

    First i'll explain what i would like to do.

    I would like to make a reward system on my server and reward the top 10 players of every month.
    At first i was trying to use the wtop10 query, but that doesn't do it because it lists the top10 over an interval of #days.

    Is it possible to insert a query that lists the top 10 players of the previous month?
    So in February list the top10 of January and in march list the top10 of February.

    I think this would make a nice feature for the plugin.

    I would be happy to donate if necessary.

    Greetings
    Last edited by Gijzijtdood; 21-01-2014 at 15:27.

  7. #507
    Community Contributor
    Join Date
    Nov 2011
    Posts
    3,031
    Quote Originally Posted by Gijzijtdood View Post
    Hey XpKiller,

    I love the plugin. I just have an idea for an option.

    First i'll explain what i would like to do.

    I would like to make a reward system on my server and reward the top 10 players of every month.
    At first i was trying to use the wtop10 query, but that doesn't do it because it lists the top10 over an interval of #days.

    Is it possible to insert a query that lists the top 10 players of the previous month?
    So in February list the top10 of January and in march list the top10 of February.

    I think this would make a nice feature for the plugin.

    I would be happy to donate if necessary.

    Greetings
    The query is essentially the same, you just need to change the range of dates in the WHERE clause.

    BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')

    For instance see some webpage code here:
    https://github.com/tyger07/BF4-Serve...ommon/potw.php

    For example, in the code linked above, you can find this query:
    SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths, (SUM(`Kills`)/SUM(`Deaths`)) AS KDR, SUM(`Headshots`) AS Headshots, (SUM(`Headshots`)/SUM(`Kills`)) AS HSR
    FROM `tbl_sessions` tss
    INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
    INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
    WHERE tsp.`ServerID` = {$ServerID}
    AND tss.`Starttime` BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE()
    AND tpd.`GameID` = {$GameID}
    GROUP BY tpd.`PlayerID`
    The above query is for player stats for the last 7 days (not what you want, but let me explain how it is used first) in no particular order.

    {$ServerID} would be substituted for the correct server ID. Default server ID would be 1 if you have only one server.

    {$GameID} would be substituted for whichever servers in your database are BF4 servers. If you only have BF4 server(s) in your database, the default game ID would be 1.


    Now, this is an example of how to find the last month's top players (as you requested) and order them by score using a modified version of the above query:

    SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths, (SUM(`Kills`)/SUM(`Deaths`)) AS KDR, SUM(`Headshots`) AS Headshots, (SUM(`Headshots`)/SUM(`Kills`)) AS HSR
    FROM `tbl_sessions` tss
    INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
    INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
    WHERE tsp.`ServerID` = 1
    AND tss.`Starttime` BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')
    AND tpd.`GameID` = 1
    GROUP BY tpd.`PlayerID`
    ORDER BY Score DESC
    I don't know what your application is and don't know if you are executing a query in phpmyadmin for your own viewing pleasure, or modifying XpKiller's plugin for your purposes, or are using some other application, but I hope I helped.
    Last edited by ty_ger07; 22-01-2014 at 01:17.

  8. #508
    Quote Originally Posted by ty_ger07 View Post
    The query is essentially the same, you just need to change the range of dates in the WHERE clause.

    BETWEEN DATE_FORMAT(NOW() - INTERVAL 1 MONTH, '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW() - INTERVAL 1 MONTH), '%Y-%m-%d 23:59:59')

    For instance see some webpage code here:
    https://github.com/tyger07/BF4-Serve...ommon/potw.php

    For example, in the code linked above, you can find this query:


    The above query is for player stats for the last 7 days (not what you want, but let me explain how it is used first) in no particular order.

    {$ServerID} would be substituted for the correct server ID. Default server ID would be 1 if you have only one server.

    {$GameID} would be substituted for whichever servers in your database are BF4 servers. If you only have BF4 server(s) in your database, the default game ID would be 1.


    Now, this is an example of how to find the last month's top players (as you requested) and order them by score using a modified version of the above query:



    I don't know what your application is and don't know if you are executing a query in phpmyadmin for your own viewing pleasure, or modifying XpKiller's plugin for your purposes, or are using some other application, but I hope I helped.
    Thx for the explanation, it makes some things more clear for me

    Having this query for myself is a first step. Now i would like it being implemented in XpKillers's plugin so the players can call the query ingame.

    Something like: top10 = top 10 players since beginning of logs
    mtop10= top 10 players of the current month (from logs started on the 1th of the current month)
    lmtop10= top 10 players from last month.

    I hope my request is understandable, my English isn't to good

    Kind regards,

  9. #509
    Senior Member
    Join Date
    Nov 2013
    Location
    Netherlands
    Posts
    128
    You want a ingame command for people to see who had a reserved slot rewarded last month?

  10. #510
    XpKiller,

    I have another issue.
    Now that i have a working query for the session data i have noticed that the data of the sessions is different then the overall ranking.

    My logs are started the 1th of this month. So my guess is that the rank score of my first player would be equal with the sum of he's session scores.
    This is not the case. The session score is allmost double of his ranking score. It's the same with all other players.

    Here the query's i use

    Top 30 stats

    SELECT tpd.playerID, tpd.SoldierName, tps.Score, tps.Kills, tps.Deaths, tps.Headshots, Playtime, LastSeenOnServer
    FROM tbl_playerstats tps
    INNER JOIN tbl_server_player tsp ON tsp.StatsID = tps.StatsID
    INNER JOIN tbl_playerdata tpd ON tsp.PlayerID = tpd.PlayerID
    WHERE tps.rankScore BETWEEN 1 AND 30
    ORDER BY tps.rankScore ASC;
    result:

    134 ElekTr1C 1307103 4217 1813 643 188385 2014-01-21 23:36:32
    205 drdrsch 1073614 2828 1917 438 258427 2014-01-21 23:04:19
    145 lr_Invisibal 946671 2365 1511 396 152551 2014-01-21 23:03:46
    133 lr_Speedy 917096 2648 1825 424 189578 2014-01-21 23:03:47
    128 lr_StalinOrgan 753100 2204 918 369 120106 2014-01-21 22:50:52
    451 Yke5 494963 1849 1050 251 107743 2014-01-21 22:06:05
    33 triplec0re 402132 1135 794 225 86955 2014-01-06 01:29:12
    954 lr_SpiderPig 395754 1190 750 171 79217 2014-01-21 21:30:07
    6 Kigents 376567 960 821 131 77603 2014-01-21 20:33:07
    861 LeReum 370567 920 929 133 89683 2014-01-19 20:54:37
    1377 Ront0 316680 837 569 110 73400 2014-01-21 18:45:23
    42 lr_gijzijtdood 260004 884 496 140 397663 2014-01-22 08:02:41
    1 RealLionheart_NL 255822 878 481 129 55327 2014-01-21 16:45:00
    611 LincNL 237945 679 485 105 47110 2014-01-19 17:06:43
    18 k0571n 234730 702 562 128 53790 2014-01-19 20:55:34
    146 lr_Parks 221536 636 649 105 58395 2014-01-22 00:11:47
    2557 HelloIAmAcid 219391 673 596 178 57198 2014-01-20 22:17:04
    942 Donkey-Kong-nl 212106 575 509 88 44977 2014-01-21 21:20:25
    160 Palanco 203494 642 406 110 40011 2014-01-05 19:31:24
    165 lr_Watergate 195240 423 289 71 45624 2014-01-21 23:53:15
    1755 Obl1v10n11 186179 467 497 86 55886 2014-01-18 21:28:17
    434 AS_DDr 176571 492 428 58 39501 2014-01-05 16:15:20
    103 Satchz 176439 595 363 96 40984 2014-01-21 19:22:04
    2820 uncouthbear 174210 463 366 69 46954 2014-01-17 16:03:52
    5626 Tydino 167079 484 451 70 43514 2014-01-20 19:35:57
    3322 Mr_Copycat98 162232 502 334 55 45726 2014-01-20 15:38:33
    1164 ManMang0 151539 461 293 68 38444 2014-01-22 02:40:56
    2749 CitrcSquid 144610 400 262 73 33343 2014-01-21 20:15:17
    662 ze_human_fly 144401 483 179 70 27112 2014-01-15 21:02:50
    852 Semaki 144262 317 480 44 40718 2014-01-20 18:40:49
    sessions query:

    SELECT tpd.`PlayerID`, tpd.`SoldierName`, SUM(tss.`Score`) AS Score, SUM(`Kills`) AS Kills, SUM(`Deaths`) AS Deaths, (SUM(`Kills`)/SUM(`Deaths`)) AS KDR, SUM(`Headshots`) AS Headshots, (SUM(`Headshots`)/SUM(`Kills`)) AS HSR
    FROM `tbl_sessions` tss
    INNER JOIN `tbl_server_player` tsp ON tss.`StatsID` = tsp.`StatsID`
    INNER JOIN `tbl_playerdata` tpd ON tsp.`PlayerID` = tpd.`PlayerID`
    WHERE tsp.`ServerID` = 1
    AND tss.`Starttime` BETWEEN DATE_FORMAT(NOW(), '%Y-%m-01 00:00:00') AND DATE_FORMAT(LAST_DAY(NOW()), '%Y-%m-%d 23:59:59')
    AND tpd.`GameID` = 1
    GROUP BY tpd.`PlayerID`
    ORDER BY Score DESC
    result: (first 30 lines)

    134 ElekTr1C 2261020 3958 1924 2.0572 615 0.1554
    205 drdrsch 2047613 2845 2061 1.3804 439 0.1543
    145 lr_Invisibal 1733218 2299 1760 1.3063 387 0.1683
    133 lr_Speedy 1578796 2523 1963 1.2853 402 0.1593
    128 lr_StalinOrgan 1410092 2207 1087 2.0304 369 0.1672
    451 Yke5 953432 1848 1133 1.6311 246 0.1331
    33 triplec0re 729329 1137 858 1.3252 225 0.1979
    954 lr_SpiderPig 722562 1192 829 1.4379 171 0.1435
    6 Kigents 637735 882 813 1.0849 120 0.1361
    1377 Ront0 593240 838 611 1.3715 110 0.1313
    861 LeReum 551342 709 780 0.9090 103 0.1453
    1 RealLionheart_NL 481655 857 525 1.6324 127 0.1482
    146 lr_Parks 419075 638 701 0.9101 105 0.1646
    611 LincNL 418919 616 464 1.3276 95 0.1542
    2557 HelloIAmAcid 417029 674 634 1.0631 178 0.2641
    942 Donkey-Kong-nl 403527 575 563 1.0213 88 0.1530
    42 lr_gijzijtdood 399780 725 450 1.6111 114 0.1572
    160 Palanco 379968 645 442 1.4593 110 0.1705
    18 k0571n 374194 568 476 1.1933 108 0.1901
    2820 uncouthbear 354016 527 435 1.2115 78 0.1480
    1755 Obl1v10n11 349605 483 527 0.9165 86 0.1781
    165 lr_Watergate 341830 419 329 1.2736 70 0.1671
    103 Satchz 332618 598 391 1.5294 96 0.1605
    434 AS_DDr 316741 487 449 1.0846 58 0.1191
    5626 Tydino 312611 484 490 0.9878 70 0.1446
    3322 Mr_Copycat98 299207 527 367 1.4360 55 0.1044
    1164 ManMang0 286843 462 312 1.4808 68 0.1472
    662 ze_human_fly 275157 484 205 2.3610 70 0.1446
    852 Semaki 272711 317 520 0.6096 44 0.1388
    Am i doing something wrong or is the session data incorrect?

    Greetings

 

 

Posting Permissions

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