StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
14835579
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-02-12T15:09:07.937
FavoriteCount
0
LastActivityDate
2013-02-12T15:09:07.937
LastEditDate
LastEditorUserId
0
OwnerUserId
1750212
ParentId
12916401
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Indeed I was using a very old "plugin template" before wordpress had the $instance call. so people used to make their own instances, wich is what I was doing. I've cleaned up my code and got it working. The only problem I encountered is that my css won't work in the plugin once jQuery takes over. But that is a different question. here is my fix</p> <pre><code> <?php /* Plugin Name: Yelp Reviews Ticker Plugin URI: http://wordpress.org/extend/plugins/ Description: This reviews ticker allows you to show your yelp reviews and also customize its display to your taste in a easy manner Version: 0.5 Author: Flavio Domeneck Jr Author URI: http://www.flaviotreeservice.com/ License: GPL2 Copyright 2013 FDJ (email : contactflavio@gmail.com ) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, version 2, as published by the Free Software Foundation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ class yrtWidget extends WP_Widget { function yrtWidget() { parent::__construct( false, 'Yelp Reviews Ticker', array( 'description' => "Yelp Reviews Ticker shows your yelp reviews cleanly and pain free" ) ); } function widget( $args, $instance ) { extract($args); echo $before_widget; echo $before_title.$instance['title'].$after_title; // // Partially from // http://non-diligent.com/articles/yelp-apiv2-php-example/ // https://github.com/Yelp/yelp-api/blob/master/v2/php/example.php // // Enter the path that the oauth library is in relation to the php file require_once ('lib/OAuth.php'); // Set instance values $speed = $instance['speed']; $pause = $instance['pause']; $showitems = $instance['showitems']; $animation = $instance['animation']; $mousepause = $instance['mousepause']; $direction = $instance['direction']; $yelp_url = $instance['yelp_url']; $unsigned_url = $instance['unsigned_url']; $consumer_key = $instance['consumer_key']; $consumer_secret = $instance['consumer_secret']; $token = $instance['token']; $token_secret = $instance['token_secret']; // Token object built using the OAuth library $token = new OAuthToken($token, $token_secret); // Consumer object built using the OAuth library $consumer = new OAuthConsumer($consumer_key, $consumer_secret); // Yelp uses HMAC SHA1 encoding $signature_method = new OAuthSignatureMethod_HMAC_SHA1(); // Build OAuth Request using the OAuth PHP library. Uses the consumer and token object created above. $oauthrequest = OAuthRequest::from_consumer_and_token($consumer, $token, 'GET', $unsigned_url); // Sign the request $oauthrequest->sign_request($signature_method, $consumer, $token); // Get the signed URL $signed_url = $oauthrequest->to_url(); // Send Yelp API Call $ch = curl_init($signed_url); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_HEADER, 0); $data = curl_exec($ch); // Yelp response curl_close($ch); // Handle Yelp response data $response = json_decode($data); $arr = (array) $response; if(is_array($arr['reviews'])){ ?>  <script type="text/javascript"> $(function(){ $('#yelp-review-ticker').vTicker({ <? echo " speed: " . $instance['speed'] . ",\n"; echo " pause: " . $instance['pause'] . ",\n"; echo " animation: '" . $instance['animation'] . "',\n"; echo " mousePause: " . $instance['mousepause'] . ",\n"; echo " direction: '" . $instance['direction'] . "',\n"; echo " showItems: " . $instance['showitems'] . "\n"; ?> }); }); </script>  <div id="yelp-review-ticker"><ul> <? foreach($arr['reviews'] as $review){ ?> <li> <table> <tr> <td style="text-align:center; padding:5px; font-size:90%"> <? echo " <img src=\"" . $review->user->image_url . "\" width=\"60px\"/>\n"; echo " <br />" . $review->user->name . "\n"; echo " <br /><img src=\"" . $review->rating_image_small_url . "\" />\n"; ?> </td> <td> <? echo " <p>" . $review->excerpt . "</p>\n"; echo " <div style=\"text-align:right; font-size:80%;\"><a href=\"" . $instance['yelp_url'] . "\" target=\"_blank\"> " . gmdate("m/d/Y", $review->time_created) . " more at \n"; echo " <img src=\"http://s3-media1.ak.yelpcdn.com/assets/2/www/img/14f29ad24935/map/miniMapLogo.png\"/></a>\n"; ?> </div> </td> </tr> </table> </li> <? } ?> </ul> </div> <? } echo $after_widget; } // End function widget. function yrtWidget_header(){ // jQuery vTicker from // http://www.jugbit.com/jquery-vticker-vertical-news-ticker/ echo ' <script type="text/javascript" src="' . plugins_url( 'lib/jquery-1.8.3.min.js' , __FILE__ ) . '"></script> <script type="text/javascript" src="' . plugins_url( 'lib/jquery.vticker-min.js' , __FILE__ ) . '"></script> <style type="text/css" media="all" src="' . plugins_url( 'css/yelprt.css' , __FILE__ ) . '"></style> '; } // Updates the settings. function update( $new_instance, $old_instance ) { return $new_instance; } function form( $instance ) { //<- set default parameters of widget if($instance){ $title = $instance['title']; $speed = $instance['speed']; $pause = $instance['pause']; $showitems = $instance['showitems']; $animation = $instance['animation']; $mousepause = $instance['mousepause']; $direction = $instance['direction']; $yelp_url = $instance['yelp_url']; $unsigned_url = $instance['unsigned_url']; $consumer_key = $instance['consumer_key']; $consumer_secret = $instance['consumer_secret']; $token = $instance['token']; $token_secret = $instance['token_secret']; } else{ $title = 'Reviews'; $speed = '2500'; $pause = '6000'; $showitems = '2'; $animation = 'fade'; $mousepause = 'true'; $direction = 'up'; $yelp_url = 'http://www.yelp.com/biz/'; $unsigned_url = 'http://api.yelp.com/v2/business/'; $consumer_key = ''; $consumer_secret = ''; $token = ''; $token_secret = ''; } ?> <p> <label for="<?php echo $this->get_field_id('title');?>">Widget Title</label><br /> <input id="<?php echo $this->get_field_id('title');?>" name="<?php echo $this->get_field_name('title');?>" type="text" value="<?php echo $title; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('speed');?>">Speed</label><br /> <input id="<?php echo $this->get_field_id('speed');?>" name="<?php echo $this->get_field_name('speed');?>" type="text" value="<?php echo $speed; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('pause');?>">Pause</label><br /> <input id="<?php echo $this->get_field_id('pause');?>" name="<?php echo $this->get_field_name('pause');?>" type="text" value="<?php echo $pause; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('showitems');?>"># of reviews</label><br /> <input id="<?php echo $this->get_field_id('showitems');?>" name="<?php echo $this->get_field_name('showitems');?>" type="text" value="<?php echo $showitems; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('animation');?>">Fade</label><br /> Yes <input id="<?php echo $this->get_field_id('animation');?>" name="<?php echo $this->get_field_name('animation');?>" type="radio" <?php if($animation == 'fade') echo 'checked="checked"'; ?> value="fade"/> No <input id="<?php echo $this->get_field_id('animation');?>" name="<?php echo $this->get_field_name('animation');?>" type="radio" <?php if($animation == '') echo 'checked="checked"'; ?> value=""/> </p> <p> <label for="<?php echo $this->get_field_id('mousepause');?>">Mouse Pause</label><br /> Yes <input id="<?php echo $this->get_field_id('mousepause');?>" name="<?php echo $this->get_field_name('mousepause');?>" type="radio" <?php if($mousepause == 'true') echo 'checked="checked"'; ?> value="true"/> No <input id="<?php echo $this->get_field_id('mousepause');?>" name="<?php echo $this->get_field_name('mousepause');?>" type="radio" <?php if($mousepause == 'false') echo 'checked="checked"'; ?> value="false"/> </p> <p> <label for="<?php echo $this->get_field_id('direction');?>">Direction</label><br /> Up <input id="<?php echo $this->get_field_id('direction');?>" name="<?php echo $this->get_field_name('direction');?>" type="radio" <?php if($direction == 'up') echo 'checked="checked"'; ?> value="up"/> Down <input id="<?php echo $this->get_field_id('direction');?>" name="<?php echo $this->get_field_name('direction');?>" type="radio" <?php if($direction == 'down') echo 'checked="checked"'; ?> value="down"/> </p> <p> <label for="<?php echo $this->get_field_id('yelp_url');?>">Yelp Business URL</label><br /> http://www.yelp.com/biz/...<br /> <input id="<?php echo $this->get_field_id('yelp_url');?>" name="<?php echo $this->get_field_name('yelp_url');?>" type="text" value="<?php echo $yelp_url; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('unsigned_url');?>">API Business URL</label><br /> http://api.yelp.com/v2/business/...<br /> <input id="<?php echo $this->get_field_id('unsigned_url');?>" name="<?php echo $this->get_field_name('unsigned_url');?>" type="text" value="<?php echo $unsigned_url; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('consumer_key');?>">Consumer Key</label><br /> <input id="<?php echo $this->get_field_id('consumer_key');?>" name="<?php echo $this->get_field_name('consumer_key');?>" type="text" value="<?php echo $consumer_key; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('consumer_secret');?>">Consumer Secret</label><br /> <input id="<?php echo $this->get_field_id('consumer_secret');?>" name="<?php echo $this->get_field_name('consumer_secret');?>" type="text" value="<?php echo $consumer_secret; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('token');?>">Token</label><br /> <input id="<?php echo $this->get_field_id('token');?>" name="<?php echo $this->get_field_name('token');?>" type="text" value="<?php echo $token; ?>"/> </p> <p> <label for="<?php echo $this->get_field_id('token_secret');?>">Token Secret</label><br /> <input id="<?php echo $this->get_field_id('token_secret');?>" name="<?php echo $this->get_field_name('token_secret');?>" type="text" value="<?php echo $token_secret; ?>"/> </p> <?php } // end function form } // end class // Register the widget. function yrtw_register() { register_widget( 'yrtWidget' ); } add_action('wp_head', 'add_yrt_header'); function add_yrt_header(){ echo ' <script type="text/javascript" src="' . plugins_url( 'lib/jquery-1.8.3.min.js' , __FILE__ ) . '"></script> <script type="text/javascript" src="' . plugins_url( 'lib/jquery.vticker-min.js' , __FILE__ ) . '"></script> <style type="text/css" media="all" src="' . plugins_url( 'css/yelprt.css' , __FILE__ ) . '"></style> '; } add_action( 'widgets_init', 'yrtw_register' ); ?> </code></pre> <p>I hope it helps someone else</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POWordpress Yelp Review Ticker Plugin
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USFlavio_D
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POWordpress Yelp Review Ticker Plugin
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTAcceptedByOriginator
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.