{"push_id":1035434398,"size":14,"distinct_size":14,"ref":"refs/heads/zoph-0.9.2","head":"4c91b61843e0a311b42cf1b7c19c9235af88b89d","before":"85a6d2ba7615059871440bc7a2cacc87d8c4acbe","commits":[{"sha":"4811fedcd3d3a05390f3d876319d9767b13ad5d7","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Added documentation to db classes","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/4811fedcd3d3a05390f3d876319d9767b13ad5d7"},{"sha":"1189ac6edf2f0b98af7b884b8010ecb559be4b02","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Fixed displaying of an error \"no people found\" when all people are in circles\n\n- refactored a bit, merging 2 seperate if sections\n- some changes in wording of the error disply\n- Moved error message into a template","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/1189ac6edf2f0b98af7b884b8010ecb559be4b02"},{"sha":"c4e1febee566c59f6bd2059a6c046092422ce5a6","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Added \"details\" popup to circles","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/c4e1febee566c59f6bd2059a6c046092422ce5a6"},{"sha":"e9b7a253d8caacf3737aa6cef07889dae1809f2a","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Fixed: Error about missing $actionlinks on people page","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/e9b7a253d8caacf3737aa6cef07889dae1809f2a"},{"sha":"6eba5f96238e34545de849b5f1d6a06fb763ad5b","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Fixed an issue where the person pulldown on the add user page appeared to be empty","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/6eba5f96238e34545de849b5f1d6a06fb763ad5b"},{"sha":"bde4a73b30a076544e62e8308cc581ca7e5af80f","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Remove a user from a group when a the user is deleted\n\nUntil now, a user with no name would stay behind when checking the group\nscreen.","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/bde4a73b30a076544e62e8308cc581ca7e5af80f"},{"sha":"263e8e713cb3afc503640b9e7c5aa2d6f7e29cfb","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Added JOIN with subquery\n\nRemoved possibility to do a SELECT query or JOIN with no alias\nThis was not used, and some code could be simplified if the possibility\nof a table with no alias could be completely ruled out.","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/263e8e713cb3afc503640b9e7c5aa2d6f7e29cfb"},{"sha":"6bee3b86e250fc157f74fd1059924b05ac4efccc","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Modified query for photo access rights to a view for performance reasons\n\nBecause of the way Zoph's permissions system works, determining which\nphotos, categories, people, albums and places a specific user is allowed\nto see is a non-trivial excercise. It involves several tables, and thus\na complex query consisting of serveral JOINs. The way the query was\nbuilt was not working very well with MySQL's query optimizer, and caused\nsome of these queries to take up to 2 seconds to run (with a large\ndatabase). If a page executes several of these queries, browsing through\nZoph can because very slow. Especially the people page suffered from\nthis problem.\n\nThis change adds a view to Zoph, which simplifies the queries a lot,\nsince all the complexity is hidden in the view, but also enables the\nMySQL query optimizer to do a much better job to retrieve the same data.\nThe above-mentionned queries that took 2 seconds are now down to about\n150ms...","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/6bee3b86e250fc157f74fd1059924b05ac4efccc"},{"sha":"507aa9c0876462b295b3c87bab31443685a05925","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Changed logging so SQL query log to file can be done without displaying debug info","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/507aa9c0876462b295b3c87bab31443685a05925"},{"sha":"5c9b64d5ecd01fd7083b18a7d59aaecab7b9e944","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Performance improvement on place page\n\nThe place page could take a long time when loading, especially for non-\nadmin users. In this changed I implemented the same solution as I\npreviously implemented in categories.\n\nI took the code from categories and made it reusable and modified places\nto use it too.\n\nThe \"remove_empty()\" function is now no longer used, so it was removed.\n(It turned out not to be a very good idea anyway)\n\nI also removed the ancestorCache since it didn't work very well and\ndidn't cause any noticable improvement in performance.","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/5c9b64d5ecd01fd7083b18a7d59aaecab7b9e944"},{"sha":"ae24bd76a87915681e00d0056cd6f2b1faff4f06","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Added a posibility to debug queries including parameters\n\nThis was partly the implementation already in logToFile, with\nimprovements.","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/ae24bd76a87915681e00d0056cd6f2b1faff4f06"},{"sha":"6ce62d5f2308a6ef4c4bf9cc86c9674447669081","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Fixed a warning about unknown variable on places page","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/6ce62d5f2308a6ef4c4bf9cc86c9674447669081"},{"sha":"5ad5a9944eecd9d4c3ec0f9661f8072586e41a55","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"People count on homepage was wrong\n\nIt displayed all people instead of only the people the user was allowed\nto see.","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/5ad5a9944eecd9d4c3ec0f9661f8072586e41a55"},{"sha":"4c91b61843e0a311b42cf1b7c19c9235af88b89d","author":{"email":"fd3fb11d20dd2b55b441515e5cc120796bf92f11@zoph.org","name":"jeroenrnl"},"message":"Fixed wrong category count on homepage","distinct":true,"url":"https://api.github.com/repos/jeroenrnl/zoph/commits/4c91b61843e0a311b42cf1b7c19c9235af88b89d"}]}