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;
}
}*/
?>
Yeah, I need this throne all to myself.No sharing with kittie. But I admire the enterprising spirit of the toilet trainer. But I agree with you, if the felines are already using it as a drinking fountain I wouldn’t want to throw “chocolate” into the mix.
Yeah, I”m with you guys. Apparently this sort of thing can actually work, but then you have to teach them to read the paper and it just gets too time consuming…As much as I hate scooping the turd field, I can’t imagine sharing the throne with casper…I mean, what if we both have to go a the same time?!
Allee Willis
Yeah, I need this throne all to myself.No sharing with kittie. But I admire the enterprising spirit of the toilet trainer. But I agree with you, if the felines are already using it as a drinking fountain I wouldn’t want to throw “chocolate” into the mix.
windupkitty
Yeah, I”m with you guys. Apparently this sort of thing can actually work, but then you have to teach them to read the paper and it just gets too time consuming…As much as I hate scooping the turd field, I can’t imagine sharing the throne with casper…I mean, what if we both have to go a the same time?!