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;
}
}*/
?>
Allee Willis
So cute. And really unusual for a wall pocket.