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;
}
}*/
?>
Some tubas from the 1840s to the 1890s were very narrow and looked a lot like this example. While there were some reed instruments that had/have a similar shape, they have keys and finger holes. As your resident tuba kitsch expert, my vote is tuba.
Allee Willis
I’m voting sax over tuba because of the shape.
This is one cute little guy!
Domitype
Some tubas from the 1840s to the 1890s were very narrow and looked a lot like this example. While there were some reed instruments that had/have a similar shape, they have keys and finger holes. As your resident tuba kitsch expert, my vote is tuba.