validate(&$url, &$name, &$ldesc, &$keywords, &$category, &$subcategory,
&$rating, &$public, &$public_db)) return false;
## Does the bookmark already exist?
$query = sprintf("select id from bookmark where url='%s' and username = '%s'",$url, $auth->auth["uname"]);
$db->query($query);
if ($db->Errno != 0) return false;
if ($db->nf() > 0) {
$error_msg .= sprintf("
URL %s already exists!", $url);
return false;
}
## Get the next available ID key
$id = $db->nextid('bookmark');
if ($db->Errno != 0) return false;
## Insert the bookmark
$query = sprintf("insert into bookmark (id, url, name, ldesc, keywords, category_id,
subcategory_id, rating_id, username, public_f, added)
values(%s, '%s', '%s', '%s','%s',%s,%s,%s, '%s', '%s', %s)",
$id, $url, addslashes($name), addslashes($ldesc), addslashes($keywords),
$category, $subcategory, $rating, $auth->auth["uname"], $public_db,
$bk_db_callout->get_current_date_sql());
$db->query($query);
if ($db->Errno != 0) return false;
$maintain_url = "maintain.php3?id=".$id;
$msg .= sprintf("Bookmark %s created sucessfully.
Click here to modify this bookmark.
![](\"%smail.png\")
",
$id, $sess->url($maintain_url), $id, $bookmarker->image_url_prefix);
## Update the PHPLIB user variable that keeps track of how
## many bookmarks this user has.
$this->update_user_total_bookmarks($auth->auth["uname"]);
return true;
}
function update($id, $url, $name, $ldesc, $keywords, $category, $subcategory,
$rating, $public) {
global $auth, $perm, $error_msg, $msg, $bookmarker, $validate, $db;
if (!$this->validate(&$url, &$name, &$ldesc, &$keywords, &$category, &$subcategory,
&$rating, &$public, &$public_db)) return false;
## Update bookmark information.
$query = sprintf("update bookmark set url='%s', name='%s', ldesc='%s' , keywords='%s',
category_id=%s, subcategory_id=%s, rating_id=%s, public_f='%s'
where id=%s and username='%s'",
$url, addslashes($name), addslashes($ldesc), addslashes($keywords),
$category, $subcategory, $rating, $public_db, $id, $auth->auth["uname"]);
$db->query($query);
if ($db->Errno != 0) return false;
$msg .= "Bookmark changed sucessfully.";
## Update the PHPLIB user variable that keeps track of how
## many bookmarks this user has.
$this->update_user_total_bookmarks($auth->auth["uname"]);
return true;
}
function delete($id) {
global $db, $auth, $perm, $error_msg, $msg;
## Do we have permission to do so?
if (!$perm->have_perm("editor")) {
$error_msg .= "You do not have permission to delete bookmarks.";
return false;
}
## Delete that bookmark.
$query = sprintf("delete from bookmark where id='%s' and username='%s'", $id, $auth->auth["uname"]);
$db->query($query);
if ($db->Errno != 0) return false;
$msg .= "Bookmark deleted sucessfully.";
## Update the PHPLIB user variable that keeps track of how
## many bookmarks this user has.
$this->update_user_total_bookmarks($auth->auth["uname"]);
return true;
}
function validate (&$url, &$name, &$ldesc, &$keywords, &$category, &$subcategory,
&$rating, &$public, &$public_db) {
global $perm, $error_msg, $msg, $bookmarker, $validate;
## Do we have permission to do so?
if (!$perm->have_perm("editor")) {
$error_msg .= "
You do not have permission to maintain bookmarks.";
}
## trim the form fields
$url = $validate->strip_space($url);
$name = trim($name);
$desc = trim($ldesc);
$keyw = trim($keywords);
## Do we have all necessary data?
if (empty($url)) {
$error_msg .= "
URL is required.";
}
if (empty($name)) {
$error_msg .= "
Name is required.";
}
if (isset($category) && $category >= 0 ) {
} else {
$error_msg .= "
Category is required.";
}
if (isset($subcategory) && $subcategory >= 0 ) {
} else {
$error_msg .= "
Subcategory is required.";
}
if (isset($rating) && $rating >= 0 ) {
} else {
$error_msg .= "
Rating is required.";
}
## does the admin want us to check URL format
if ($bookmarker->url_format_check > 0 ) {
## Is the URL format valid
if (!$validate->is_url($url)) {
$format_msg = "
URL invalid. Format must be http:// or
ftp:// followed by a valid hostname and
URL!
$validate->ERROR ";
## does the admin want this formatted as a warning or an error?
if ( $bookmarker->url_format_check == 2 ) {
$error_msg .= $format_msg;
} else {
$msg .= $format_msg;
}
}
}
## Does the URL respond
if ($bookmarker->url_responds_check) {
if (!$validate->url_responds($url)) {
$msg .= "
**WARNING**: The URL you entered is not responding.
$validate->ERROR ";
}
}
if ($public == "on") {
$public_db = "Y";
} else {
$public_db = "N";
}
## if we found an error, then return false
if (!empty($error_msg)) {
return false;
} else {
return true;
}
}
function update_user_total_bookmarks($uname) {
global $user_total_bookmarks, $auth;
if ($uname == $auth->auth["uname"]) {
$user_total_bookmarks = 0;
$db = new bk_db;
$query = sprintf("select count(id) as total_bookmarks
from bookmark
where username = '%s'",
$auth->auth["uname"]);
$db->query($query);
if ($db->Errno == 0) {
if ($db->next_record())
$user_total_bookmarks = $db->f("total_bookmarks");
} else return false;
}
# need to find out how many public bookmarks exist from
# this user so other users can correctly calculate pages
# on the list page.
$total_public = 0;
$db = new bk_db;
$query = sprintf("select count(id) as total_public
from bookmark
where username = '%s' and public_f='Y'",
$uname);
$db->query($query);
if ($db->Errno == 0) {
if ($db->next_record()) $total_public = $db->f("total_public");
} else return false;
$query = sprintf("update auth_user set total_public_bookmarks=%s
where username = '%s'",
$total_public, $uname);
$db->query($query);
if ($db->Errno != 0) return false;
return true;
}
}