Make changes to website

1) Please look into using the jQuery javascript library [login to view URL] - we like the look & feel, the functionality of sorting the resultset, searching within the resultset and pagination very much. 2) Please see if you can realize the server-side processing example. [login to view URL] This would fit us very well because we are using the website mostly from underway when we are at tournaments where mobile internet connection is not that good. Some players have 1000s of rows of data, so loading smaller datasets would be good for us. "With server-side processing enabled, all paging, searching, ordering etc actions that DataTables performs are handed off to a server where an SQL engine (or similar) can perform these actions on the large data set (after all, that's what the database engine is designed for!). As such, each draw of the table will result in a new Ajax request being made to get the required data." 3) The club leaderboard does not load correctly somehow. Please check if the correct query is loading (see attached) and if the clubid is being handed over to the query. It is a long query and there are several spots where the clubid from the selection would need to be handed over to the query. I have indicated these with “-- put selected clubid here” comments in the attached text file. Example: Searching for “SV Hurlach” does not return the right players in the result table. 4) Fix error message when I want to show "30 records" of the club leaderboard, then the following message appears. The requested URL /club_leaderboard.php&d=30 was not found on this server. 5) Somehow we would like to make the search more user-friendly. For example, if I select from the dropdown the option "club leaderboard" and then search for a club, the leaderboard should already load without that we need to specify a player. It should be enough to select only the club and "club leaderboard". 6) Is it possible that the search fields keep the value which was searched or selected even if the result loaded? For example, I search for a club, and afterwards select the player. After I selected the player, the club name does not display anymore. 7) Please show the players dropdown in alphabetical order. 8) We would like to show the matches history of two players when somebody clicks on the “+” to expand the row. There is an example on the datatables website for this scenario as well: [login to view URL] 9) Please add a : character (colon). The example: 3312 is coming from two different fields and should read 33:12 – 110 should read 11:0.