if ( current_user_can('level_10') ) { ?>
} ?>
$uid=get_current_user_id();
if (empty($uid)) $uid=0;
if (!empty($_REQUEST['set_like']) && !empty($uid))
{
// set here
$sql="select * from island_like where user_id=\"".mysql_real_escape_string($uid)."\",1,0) and post_id=\"".mysql_real_escape_string(get_the_ID())."\"";
$rs = $wpdb->get_results($sql);
if (count($rs)<1) // not yet added
{
$sql="insert into island_like (user_id, post_id, date_added) values (\"".mysql_real_escape_string($uid)."\", \"".mysql_real_escape_string(get_the_ID())."\", NOW());";
$rs = $wpdb->get_results($sql);
}
}
elseif (!empty($_REQUEST['remove_like']) && !empty( $uid))
{
// unset here
$sql="delete from island_like where user_id=\"".mysql_real_escape_string($uid)."\" and post_id=\"".mysql_real_escape_string(get_the_ID())."\";";
$rs = $wpdb->get_results($sql);
}
/*
$sql="select U.display_name, U.user_nicename, U.id as uid, if(U.id=\"".mysql_real_escape_string($uid)."\",1,0) as is_current, if (U.id=19, 1,0) as is_allee ".
"from island_like as L, wp_users as U ".
"where L.post_id=\"".mysql_real_escape_string(get_the_ID())."\" ".
"and U.ID=L.user_id ".
"order by is_current DESC, is_allee DESC, date_added DESC;";
$jealous_rs = $wpdb->get_results($sql);
$user_is_jealous=0;
if (count($jealous_rs)>0)
{
if ($jealous_rs[0]->uid==$uid)
{
$user_is_jealous=1;
}
}*/
?>
Wonder if the cat ever thought the dog might be a prime suspect in this caper….My favorite used to be let’s see who can be the first to christen the clean box, sometimes within seconds of the clean one being placed back upon the floor.
Allee Willis
That so looks like my sweetie Sweet Potato, who is largely responsible for filling the litter box around here at Willis Wonderland.
I wish someone other than me were regularly stealng his “gifts”.
BRBill
Wonder if the cat ever thought the dog might be a prime suspect in this caper….My favorite used to be let’s see who can be the first to christen the clean box, sometimes within seconds of the clean one being placed back upon the floor.