function deleteCookbooks($user_id, $link)
{
$sql = "SELECT cookbook_id FROM Cookbook_list WHERE user_id = '{$user_id}'";
$result = $link->query($sql);
$count = $result->num_rows;
$i = 0;
if ($count > 0) {
while ($row = $result->fetch_assoc()) {
$cb_id[$i] = $row['cookbook_id'];
//store all cookbook ids to array
deleteTags("COOKBOOK", $cb_id[$i], $link);
//delete cookbook tags
deleteFriends("COOKBOOK", $cb_id[$i], $link);
//check privacy to delete friends
$i++;
}
for ($j = 0; $j < $i; $j++) {
$current = $cb_id[$j];
$sql4 = "DELETE FROM Cookbook WHERE cookbook_id = '{$current}'";
//delete cookbook
if ($link->query($sql4) != true) {
//unsuccessful query
echo "ERROR: Could not able to execute {$sql3}. " . $link->connect_error;
}
}
}
}
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_bookmarks.php';
if (isset($add)) {
addBookMarks();
}
showBookMarks(1);
break;
case 'delbookmarks':
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_bookmarks.php';
deleteBookMarks();
break;
case 'friends':
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_friends.php';
if (isset($add)) {
addFriends();
}
showFriends(1);
break;
case 'add':
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_friends.php';
addFriends();
break;
case 'deletefriend':
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_friends.php';
deleteFriends();
break;
case 'images':
default:
include XOOPS_ROOT_PATH . '/modules/galleries/include/cp_images.php';
showImages();
break;
}
