EntryIndia
Items Needing Approval
roles as $role)
{
if (strcmp($role, "administrator") == 0)
{
$authorized = true;
}
}
if ($authorized)
{
$num_comment = db_query('SELECT COUNT(nid)
FROM comment c
WHERE c.status = :status_val',
array(':status_val' => 0))->fetchField();
$output .= "Comments
\r\n"; $output .= "
\r\n"; // Get a list of all content types $type_res = db_query('SELECT nt.type, nt.name FROM node_type nt ORDER BY name ASC'); // Cycle through each content type foreach($type_res as $cur_type) { if ((strcmp($cur_type->type, "dev_debug") != 0) && (strcmp($cur_type->type, "entry_india_utilities") != 0)) { $node_res = db_query('SELECT n.nid, n.title FROM node n WHERE type = :node_type AND status = 0 ORDER BY title ASC', array(':node_type' => $cur_type->type)); // If this user has more than 1 node of this type do if ($node_res->rowCount() > 0) { // Print out name of this content type $output .= "" . $cur_type->name . "
\r\n"; $output .= "
\r\n"; } } } } else { $output .= "
\r\n"; $output .= "
\r\n"; // Get a list of all content types $type_res = db_query('SELECT nt.type, nt.name FROM node_type nt ORDER BY name ASC'); // Cycle through each content type foreach($type_res as $cur_type) { if ((strcmp($cur_type->type, "dev_debug") != 0) && (strcmp($cur_type->type, "entry_india_utilities") != 0)) { $node_res = db_query('SELECT n.nid, n.title FROM node n WHERE type = :node_type AND status = 0 ORDER BY title ASC', array(':node_type' => $cur_type->type)); // If this user has more than 1 node of this type do if ($node_res->rowCount() > 0) { // Print out name of this content type $output .= "" . $cur_type->name . "
\r\n"; $output .= "
- \r\n";
// Print out a list of content hyperlinked to the view page of that node
foreach($node_res as $cur_node)
{
$output .= "
- " . "nid . "/edit\">" . $cur_node->title . " \r\n"; } $output .= "
\r\n"; } } } } else { $output .= "