April 14, 2007 by Eric Heikkinen | Comments Off
OpenID, Database and New Mods
I found a handy script
from PHPClasses to ease my OpenID
module development. The goal of this mod is too allow both regular logins and OpenID logins. Currently the BETA version of this mod only works for existing accounts. The user will go into their profile and set their OpenID url. They will then be able to login using OpenID. Note: this plugin requires the latest SVN available (at least Rev 957
). When finished the mod will allow people to quickly register on a Pligg site using their OpenID account.
Aside from keeping a record of every vote submitted, we also keep a ‘count’ of those votes in a column the links table itself. This is so every time a story is viewed, we don’t have to count(*) from the votes table, we just look at the row we just read from the links table. A week ago we added comment count and just yesterday added ‘reports’. On an average Pligg site the index / home page will show 8 main stories, 5 upcoming and 5 top today. 18 stories * 2 queries (comments and reporting) = 36 unnecessary queries that have now been removed. Many changes have been made to the code to reduce the overall number of MySQL queries and more work is still being done.
Today our good friend ChuckRoast released a new ‘mod’
today for translating the ‘story’ page from English into 6 other languages. He’s been a member of the forums for close to a year now and has a history of creating nice little mods that get added into the Pligg code.