Changeset 1187

Show
Ignore:
Timestamp:
10/24/06 15:38:29 (2 years ago)
Author:
jm3
Message:

modifed SQL for new bornon date for users
test page for db now fn
added new_users_today query to pull today's new users -- NOT YET CALLED ANYWHERE...

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • feedmelinks/modules/news-data.inc.php

    r839 r1187  
    22        $newsItems = Array(); 
    33 
    4         array_push( $newsItems, Array( "11/20/2005", '<a href="http://codeswami.com/2005/11/20/feed-me-links-going-open-source/">FML going Open Source</a>' )); 
    5         array_push( $newsItems, Array( "1/3/2005", 'Code development is now <a href="http://cia.navi.cx/stats/project/feedmelinks">completely visible</a>' )); 
     4        array_push( $newsItems, Array( "10/24/2006", '<a href="/245724">Trench warefare with link-spammers</a>' )); 
     5        array_push( $newsItems, Array( "10/23/2006", '<a href="/u/formalplay">alex</a> and <a href="/u/dRAUPP">dwayne</a> make the homepage!' )); 
     6        array_push( $newsItems, Array( "11/20/2005", '<a href="http://codeswami.com/2005/11/20/feed-me-links-going-open-source/">Feed Me Links goes completely  Open Source</a>' )); 
     7        array_push( $newsItems, Array( "1/3/2005", 'Code development is now <a href="http://toolstomaketools.svnrepository.com/codepot/trac.cgi/browser/feedmelinks">completely visible</a>' )); 
    68        array_push( $newsItems, Array( "1/2/2005", '<a href="/install/search">Firefox / Mozilla Search Plugin</a> available' )); 
    79 

  • feedmelinks/modules/utils.inc.php

    r1184 r1187  
    15891589                        LEFT JOIN linksCategoriesXRef ON links.ID = linksCategoriesXRef.linkID WHERE linksCategoriesXRef.linkID IS NULL "; 
    15901590 
     1591        } else if( $argWhichQuery  == "new_users_today" ) { 
     1592          return " 
     1593                SELECT COUNT(id) FROM linksUsers WHERE bornOn < DATE_FORMAT(DATE_ADD(CURRENT_TIMESTAMP(), INTERVAL 1 DAY),'%Y%m%d000000') AND bornOn >= DATE_FORMAT(CURRENT_TIMESTAMP(),'%Y%m%d000000');"; 
     1594 
    15911595        } else if( $argWhichQuery  == "find_user" ) { 
    15921596          return " 
    …… 
    24282432        $name     = urlencode( $argName ); 
    24292433 
    2430         $qs = "INSERT INTO linksUsers VALUES(NULL,'$userId','$email', '$password', '$name','', 2, 1, NULL);"; 
     2434        $qs = "INSERT INTO linksUsers VALUES(NULL,'$userId','$email', '$password', '$name','', 2, 1, NULL, NULL);"; 
    24312435 
    24322436        l( "new_user: $argUserId, $argEmail" );