function addtag($id) { if (!$id) { exit; } $mysqldb = new mysql(); $mysqldb->connect(); $mysqldb->select(); $mysqldb->query("SELECT Keyw FROM articles WHERE FileID='{$id}'"); $row = $mysqldb->fetchObject(); $keystotags = $row->Keyw; // place keywords into tags table. $arrkeywords = explode(' ', $keystotags); foreach ($arrkeywords as $keyword) { if (strlen($keyword) > 4) { $mysqldb->query("INSERT INTO tags (fileid, tag) VALUES ('{$fileid}', '{$keyword}')"); } } }
<?php // a_authordetails.php -- Admin view Author Details include './functions.php'; require_once './config/auth.php'; require './config/config.php'; include "./classes/mysql.class.php"; $mysqldb = new mysql(); $mysqldb->connect(); $mysqldb->select(); $authorid = mifi($_REQUEST[aid]); $mysqldb->query("SELECT CONCAT(FirstName, ' ', LastName) AS name, Approved, UserName, Email, DATE_FORMAT(RegistrationDate, '%M %d, %Y') AS dr, (SELECT count(*) from articles WHERE Approved = 'N' AND AuthorID='{$authorid}') AS PendingArticles, (SELECT count(*) from articles WHERE Approved = 'Y' AND AuthorID='{$authorid}') AS ApprovedArticles, (SELECT count(*) from articles WHERE Approved = 'S' AND AuthorID='{$authorid}') AS SavedArticles FROM authors WHERE AuthorID='{$authorid}'"); $row = $mysqldb->fetchObject(); $totalarticles = $row->ApprovedArticles + $row->PendingArticles + $row->SavedArticles; if (isset($_REQUEST['newperms'])) { $title = 'Permissions Updated'; } else { $title = 'Author details for ' . $row->name . ' (' . $row->UserName . ')'; } $approved = $row->Approved; if ($approved != 'Y') { $approved = "<a href=\"aufe2a.php?aid={$authorid}\">{$row->Approved}</a>"; } head_page($title); menu_options($title, $vnum, $viewop, $pid, $keys, $adfl); contentinit($title); echo <<<_AUTHORDETAILS AuthorID : {$authorid}<br /> UserName : {$row->UserName}<br /> Full Name : {$row->name}<br /> Permissions : {$row->Approved}<br>
$start = 0; } $query = "SELECT CONCAT(au.LastName, ', ', au.FirstName) AS name, au.AuthorID, DATE_FORMAT(RegistrationDate, '%M %d, %Y') AS dr,(SELECT COUNT(*) FROM articles AS a WHERE a.AuthorID=au.AuthorID AND a.Approved='N' AND a.ParentID='0') AS pending, (SELECT COUNT(*) FROM articles AS a WHERE a.AuthorID=au.AuthorID AND a.Approved='S' AND a.ParentID='0') AS saved, (SELECT COUNT(*) FROM articles AS a WHERE a.AuthorID=au.AuthorID AND a.Approved='Y' AND a.ParentID='0') AS approved, (SELECT COUNT(*) FROM articles AS a WHERE a.AuthorID=au.AuthorID AND a.ParentID='0') AS total FROM authors AS au"; $viewquery = $query . " LIMIT {$start}, {$display}"; // That's the end of our query making. $mysqldb->query($query); $num_records = $mysqldb->numRows($query); $mysqldb->query($viewquery); if ($num_records > $display) { // more than one page $num_pages = ceil($num_records / $display); } else { $num_pages = 1; } $first = TRUE; while ($row = $mysqldb->fetchObject()) { $bg = $bg == '#f5f5f5' ? '#cccccc' : '#f5f5f5'; if ($first) { //name dr pending approved total echo <<<EOF <table border="0" cellspacing="0" cellpadding="5" align="center" width="95%"><tr> <td align="left" width = "30%"><small>Name</small></td> <td align="right" width = "30%"><small>Register Date</small></td> <td align = "left" width = "10%"><small>Pending</small></td> <td align = "left" width = "10%"><small>Saved</small></td> <td align = "left" width = "10%"><small>Approved</small></td> <td align = "right" width = "10%"><small>Total</small></td></tr> EOF; } echo "<tr bgcolor=\"{$bg}\"><td align=\"left\"><a href=\"a_authordetails.php?aid={$row->AuthorID}\">{$row->name}</a></td>\n\n<td align=\"right\"> {$row->dr}</td>\n\n<td align=\"center\"> {$row->pending}</td>\n<td align=\"center\"> {$row->saved}</td>\n<td align=\"center\"> {$row->approved}</td>\n<td align=\"center\"> {$row->total}</td>\n\n\n</tr>"; $first = FALSE;