aYoub
prefix . "trakttvcache";
$file = fopen('sql.txt','w');
fwrite($file,'PREFIX: ');
fwrite($file,$wpdb->prefix);
fwrite($file,"\n---\n");
fwrite($file,$sql);
fclose($file);
$sql = "CREATE TABLE IF NOT EXISTS `{$table_name}` (
`caid` bigint(20) NOT NULL,
`type` char(1) NOT NULL COMMENT 'm=movie, s=show',
`id` varchar(20) NOT NULL COMMENT 'imdb/tvdb id',
`other` varchar(40) DEFAULT NULL COMMENT 'season,episode',
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`rating` char(1) NOT NULL COMMENT '0 - none, 1 - sucks, 2 - good'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;";
createTable($table_name, $sql); //Little function to check that the table does not already exist
}
function createTable($theTable, $sql){//reusable function
global $wpdb;//call $wpdb to the give us the access to the DB
if($wpdb->get_var("show tables like '". $theTable . "'") != $theTable) { //using the get_var routine which is best to get a single value
$wpdb->query($sql); //the query function lets us execute most MySQL querys
}
}
// #############################################################################
// ### Ładujemy własny CSS
add_action( 'wp_print_styles', 'trakttv_widget_add_stylesheet' );
/**
* Adds custom stylesheet to head section of the page
*/
function trakttv_widget_add_stylesheet() {
// TODO: dynamic css
wp_register_style( 'trakttvWidgetStyle', plugins_url("/trakttv.css",__FILE__) );
wp_enqueue_style( 'trakttvWidgetStyle');
}
// #############################################################################
// ### Ładujemy widget
add_action('widgets_init', 'load_trakt_widgets');
function load_trakt_widgets() {
register_widget ("Trakt_Actions_Widget");
}
// #############################################################################
// ### Klasa widgetu - magic starts here
class Trakt_Actions_Widget extends WP_Widget {
function Trakt_Actions_Widget() {
// settings
$widget_ops = array(
'classname' => 'trakttv',
'description' => 'This widget shows user\'s last actions in trakt.tv.' );
/* Widget control settings. */
$control_ops = array( 'id_base' => 'trakttv-actions-widget' );
/* Create the widget. */
$this->WP_Widget( 'trakttv-actions-widget', 'TraktTV Actions Widget', $widget_ops, $control_ops );
}
private function zerofill($number, $positions=2) {
for($i=1;$i<$positions;$i++) {
if($number < pow(10,$i))
$number = '0' . $number;
}
return $number;
}
function widget( $args, $instance ) {
extract( $args );
$maxActions = 10; // make it settable in panel
/* User-selected settings. */
$title = apply_filters('widget_title', $instance['title'] );
$username = $instance['username'];
$apikey = $instance['apikey'];
/* Before widget (defined by themes). */
echo $before_widget;
/* Title of widget (before and after defined by themes). */
if ( $title )
echo $before_title . $title . $after_title;
/* Podłączamy się do API TraktTV */
if($username && $apikey) {
$ch = curl_init();
$url = 'http://api.trakt.tv/activity/user/json/' . $apikey . '/' . $username . '/all/seen';
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, true);
$contents = curl_exec ($ch);
curl_close($ch);
$out = json_decode($contents, TRUE);
print "
- ";
for($i=0;$i<$maxActions;$i++) {
if(isset($out['activity'][$i]['show'])) { // obsługujemy serial
$season = $this->zerofill($out['activity'][$i]['episodes'][0]['season']);
$episode = $this->zerofill($out['activity'][$i]['episodes'][0]['episode']);
if($i == 0) {
// pierwszy element listy - rozszerzone informacje
print "
- ";
print "
"; print "". $out['activity'][$i]['show']['title'] . "
"; print ''; print "
S" . $season . "E" . $episode . " (" . $out['activity'][$i]['episodes'][0]['title'] .")
"; print ""; } else { // kolejne elementy print " - ";
print "
"; print "". $out['activity'][$i]['show']['title'] . "
"; print "S" . $season . "E" . $episode . " (" . $out['activity'][$i]['episodes'][0]['title'] .")
"; } print " ";
} elseif(isset($out['activity'][$i]['movie'])) { // obsługujemy film
if($i == 0) {
// pierwszy element
print ' - ';
print '
' . $out['activity'][$i]['movie']['title'] . '
'; print ''; print '
Year: ' . $out['activity'][$i]['movie']['year']; if($out['activity'][$i]['movie']['trailer']) print ', trailer'; print "
"; } else { // kolejne elementy print ' - ';
print '
' . $out['activity'][$i]['movie']['title'] . '
'; print 'Year: ' . $out['activity'][$i]['movie']['year']; if($out['activity'][$i]['movie']['trailer']) print ', trailer'; } print '
';
//$debug = print_r($out['activity'][$i],1);
}
}
print "
