Page 161 of 162 FirstFirst ... 61111151159160161162 LastLast
Results 1,601 to 1,610 of 1617
  1. #1601
    Quote Originally Posted by B7ackhawk View Post
    and what i do ?
    Attachment 4619
    Go to your stat logger plugin and enable the 'live scoreboard in database' setting.
    ____

  2. #1602
    Quote Originally Posted by ColColonCleaner View Post
    Go to your stat logger plugin and enable the 'live scoreboard in database' setting.
    its on Capture.PNG

  3. #1603
    He's running hacked servers, right? Do hacked servers retrieve info from BL?




  4. #1604
    Quote Originally Posted by Sp0rAdiC View Post
    He's running hacked servers, right? Do hacked servers retrieve info from BL?
    Who asked for your opinion?..Do not interfere with what does not concern you

  5. #1605

  6. #1606
    again Who asked for your opinion??

  7. #1607
    Community Contributor
    Join Date
    Nov 2011
    Posts
    3,011
    You never did tell me your version of Apache and PHP. You responded to my question with a question.

    I have a hunch that my ORDER BY is too ambiguous.

    In phpmyadmin, run this query.

    Code:
    SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`
    FROM `tbl_currentplayers` cp
    LEFT JOIN
    (
    	SELECT tpd.`PlayerID`, tpd.`SoldierName`
    	FROM `tbl_playerdata` tpd
    	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
    	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
    	WHERE tpd.`GameID` = 1
    	AND tsp.`ServerID` = 1
    ) sub ON sub.`SoldierName` = cp.`SoldierName`
    WHERE cp.`ServerID` = 1
    AND cp.`TeamID` = 1
    GROUP BY cp.`SoldierName`
    ORDER BY Score DESC;
    What is the result?

    And then try:

    Code:
    SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`
    FROM `tbl_currentplayers` cp
    LEFT JOIN
    (
    	SELECT tpd.`PlayerID`, tpd.`SoldierName`
    	FROM `tbl_playerdata` tpd
    	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
    	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
    	WHERE tpd.`GameID` = 1
    	AND tsp.`ServerID` = 1
    ) sub ON sub.`SoldierName` = cp.`SoldierName`
    WHERE cp.`ServerID` = 1
    AND cp.`TeamID` = 1
    GROUP BY cp.`SoldierName`
    ORDER BY cp.`Score` DESC;
    What is the result?

    And then try:

    Code:
    SELECT cp.`Soldiername`, cp.`Score`, cp.`Kills`, cp.`Deaths`, cp.`TeamID`, cp.`SquadID`, cp.`CountryCode`, sub.`PlayerID`, sub.`ban_status`
    FROM `tbl_currentplayers` cp
    LEFT JOIN
    (
    	SELECT tpd.`PlayerID`, tpd.`SoldierName`, adk.`ban_status`
    	FROM `tbl_playerdata` tpd
    	INNER JOIN `tbl_server_player` tsp ON tsp.`PlayerID` = tpd.`PlayerID`
    	INNER JOIN `tbl_playerstats` tps ON tps.`StatsID` = tsp.`StatsID`
    	LEFT JOIN `adkats_bans` adk ON adk.`player_id` = tpd.`PlayerID`
    	WHERE tpd.`GameID` = 1
    	AND tsp.`ServerID` = 1
    ) sub ON sub.`SoldierName` = cp.`SoldierName`
    WHERE cp.`ServerID` = 1
    AND cp.`TeamID` = 1
    GROUP BY cp.`SoldierName`
    ORDER BY Score DESC;
    What is the result?
    Last edited by ty_ger07; 18-01-2018 at 00:53.

  8. #1608
    Super Moderator
    Join Date
    Jul 2010
    Location
    Very North Darwin
    Posts
    1,538
    Quote Originally Posted by B7ackhawk View Post
    Who asked for your opinion?..Do not interfere with what does not concern you
    Are you running an illegal server?

    If you are then we will have to ban you.

  9. #1609
    Community Contributor
    Join Date
    Nov 2011
    Posts
    3,011
    I don't know how to help you if you can't understand my English and aren't providing me useful information. Maybe you can find a translator.

    Here is my suggestion:

    In the file ./common/home/scoreboard-live.php, make the following changes:

    line 395 and line 415 (in two places total),
    change:
    Code:
    ORDER BY {$rank} {$order};
    to:
    Code:
    ORDER BY cp.{$rank} {$order};
    My assumption is that your sql server is providing an error message because "ORDER BY whatever" is ambiguous because those particular queries contain subqueries, and your sql server may prefer "ORDER BY cp.whatever" to remove ambiguity. Most databases probably make the assumption just fine without providing an error message, but your server configuration or version numbers may be different, extra strict, or otherwise lack ability to make such assumptions.

    If you can't understand that suggestion, I don't know how I can help you.


    If that works for everyone, I can make that change official in the stats webpage code.
    Last edited by ty_ger07; 18-01-2018 at 13:01.

  10. #1610
    Quote Originally Posted by ty_ger07 View Post
    I don't know how to help you if you can't understand my English and aren't providing me useful information. Maybe you can find a translator.

    Here is my suggestion:

    In the file ./common/home/scoreboard-live.php, make the following changes:

    line 395 and line 415 (in two places total),
    change:
    Code:
    ORDER BY {$rank} {$order};
    to:
    Code:
    ORDER BY cp.{$rank} {$order};
    My assumption is that your sql server is providing an error message because "ORDER BY whatever" is ambiguous because those particular queries contain subqueries, and your sql server may prefer "ORDER BY cp.whatever" to remove ambiguity. Most databases probably make the assumption just fine without providing an error message, but your server configuration or version numbers may be different, extra strict, or otherwise lack ability to make such assumptions.

    If you can't understand that suggestion, I don't know how I can help you.


    If that works for everyone, I can make that change official in the stats webpage code.
    thank for you help. i change it but not work

 

 

Posting Permissions

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