DrupalBin
Submit Code
About
Recent Posts
Fix for Views cumulus: tag_cloud
Fix for Code
sjfgjgjfgidfgh
Code
Code
test.berniecram.com.alias.drushrc.php
Code
provision-deploy error
Create node programmatically with file
Code
more
User login
Log in using OpenID:
What is OpenID?
Username:
*
Password:
*
Log in using OpenID
Cancel OpenID login
Create new account
Request new password
Tags
CCK
drupal
fapi
jquery
menu
module
php
simpletest
taxonomy
test
theme
views
more tags
Home
Fix for Number of nodes of specific type created since last login
View
Fix
December 11, 2008 - 12:43pm — Anonymous
SELECT
COUNT
(
1
)
FROM
{
nodes
}
n
WHERE
n.created
>
(
SELECT
login
FROM
{
users
}
u
WHERE
uid
=
%
d
)
AND
n.
type
=
'
%
s'
count
last login
mysql
node
user
Submit Fix
Summary:
Tags:
Any tags you'd like to associate with your code, delimitered by commas (example: Views, CCK, Module, etc).
Show summary in full view
SELECT COUNT(1) FROM {nodes} n WHERE n.created > (SELECT login FROM {users} u WHERE uid = %d) AND n.type = '%s'
Syntax highlighting mode:
ActionScript
ColdFusion
Diff
Drupal 5
Drupal 6
HTML
INI
Javascript
MySQL
PHP
Python
robots.txt
SQL
Text
Select the syntax highlighting mode to use.
See Also:
Order
Title:
URL:
-1
0
1
Title:
URL:
-1
0
1
Any links you'd like to have associated with the post (Drupal.org issue, Wikipedia article, etc).
File attachments
Changes made to the attachments are not permanent until you save this post. The first "listed" file will be included in RSS feeds.
Attach new file:
The maximum upload size is
1 MB
. Only files with the following extensions may be uploaded:
jpg jpeg gif png txt doc xls pdf ppt pps odt ods odp phps
.
