1. 24 Jan, 2011 2 commits
  2. 10 Nov, 2010 1 commit
  3. 17 Apr, 2010 1 commit
  4. 29 Nov, 2009 1 commit
  5. 13 Nov, 2009 1 commit
    • Evangelos Foutras's avatar
      Implement 'Password Reset' facility (FS#3061) · 861cbf49
      Evangelos Foutras authored
      This works by adding a new field to the 'Users' table called 'ResetKey',
      which is a 32 characters long, random string. When the user requests a
      password reset, a new 'reset key' is generated and sent to the user's
      e-mail address in the form of a link in the following format:
      
        http://aur.archlinux.org/passreset.php?resetkey=<reset
      
       key>
      
      When the above link is followed, the user is presented with a form to
      verify his/her e-mail address and specify the new desired password. If
      the e-mail address matches the reset key in the database, the new
      password is assigned to the account. If there is an error, a relevant
      message is displayed and the user is prompted to re-enter the required
      information. Upon successful completion of this procedure, the ResetKey
      field in the database is blanked and the specific key cannot be reused.
      
      One SQL query is needed to add the ResetKey field to the 'Users' table:
      
        ALTER TABLE `Users` ADD `ResetKey` CHAR(32) NOT NULL DEFAULT '';
      
      Signed-off-by: default avatarLoui Chang <louipc.ist@gmail.com>
      861cbf49
  6. 18 Jun, 2009 1 commit
    • Dan McGee's avatar
      Add multicolumn indexes on votes and notifications tables · e2b3bd1c
      Dan McGee authored
      
      
      To put a long story short, when we do joins on these tables in our
      pkg_search_page() function, we always join on both the user ID and package
      ID columns. By creating multicolumn indices, we can always get the exact row
      we are looking for in the table.
      
      The benefits of adding a unique index should also speak for themselves, as
      we previously did not have this on either of these tables.
      
      This is part one of a two-part series to address the fact that this query
      was often showing up in our slow query logs.
      
      Signed-off-by: default avatarDan McGee <dan@archlinux.org>
      Signed-off-by: default avatarLoui Chang <louipc.ist@gmail.com>
      e2b3bd1c
  7. 27 Mar, 2008 1 commit
  8. 23 Mar, 2008 2 commits
  9. 20 Jan, 2008 7 commits
  10. 17 Sep, 2007 1 commit
  11. 16 Aug, 2007 1 commit
  12. 01 Feb, 2007 1 commit
  13. 22 Aug, 2006 1 commit
  14. 10 Aug, 2006 1 commit
  15. 03 Aug, 2006 1 commit
  16. 29 Jul, 2005 1 commit
  17. 08 Jun, 2005 1 commit
    • simo's avatar
      SQL CHANGES: New table CommentNotify with fields: · 6adf639a
      simo authored
      	PkgID
      	UserID
      This implements emailing comment notifications, including a user option to
      enable/disable it on the package page. It uses php's mail() function to do
      it and sends to everyone on the notify list as BCC.
      
      This needs some more testing before public consumption.
      6adf639a
  18. 08 May, 2005 1 commit
    • simo's avatar
      Added ModifiedTS to Packages database · f7a0009e
      simo authored
      Implemented ModifiedTS such that:
        -ModifiedTS changed ONLY when package updated
        -SubmittedTS changed ONLY when new package
      Also made DummyPkg fixups in tupkgupdate
      f7a0009e
  19. 09 Apr, 2005 1 commit
  20. 06 Apr, 2005 1 commit
    • pjmattal's avatar
      many changes in prep for launch · 71b5b9e6
      pjmattal authored
      new doc page added
      changed AUR to community
      lower-cased unsupported
      fixed half of the bug with changing categories:
        categories now can't be changed for packages in community
        however they can still be changed out from under maintainers by joe users for unsupported packages
      debugged problem with package details not found when unsupported uploads were with Category 0 (changed default to 19)
      71b5b9e6
  21. 20 Mar, 2005 1 commit
  22. 06 Mar, 2005 1 commit
  23. 05 Mar, 2005 1 commit
  24. 24 Jan, 2005 1 commit
  25. 15 Dec, 2004 5 commits
  26. 06 Dec, 2004 1 commit
  27. 20 Sep, 2004 1 commit
  28. 12 Jul, 2004 1 commit