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
I love how completely happy and goofy looking he is. I’d have him in a very prominent spot.
Quite impressive for a handmade project. I would’ve totally thought he was store bought until I saw the bottom.
Nessa
I’m pretty sure this is store bought, what about the bottom makes you think it isn’t?
I’ve seen this planter in numerous variations.
Allee Willis
Just that there was no manufacturer mark on the bottom.
k2dtw
LOVE!!!
Nessa
Thanks!