Plugin Author
YOP
(@yourownprogrammer)
Hi thpword,
Please let us know what YOP Poll version you use so we may assist.
Regards,
YOP Team
Thanks for getting back. Version 5.1
Just did another check and also not showing for latest Poll i.e. if more than 1 Poll, Poll 2 onwards are not showing at all.
Plugin Author
YOP
(@yourownprogrammer)
Hey,
Edit abstract_model.php and in __construct function, right above this line
$data = self::get_data_by( 'id', $id ); add
if($id=="-3"){
$filters = array();
$filters[] = array(
'field' => 'poll_type',
'value' => 'poll',
'operator' => '='
);
$filters[] = array(
'field' => 'poll_start_date',
'value' => current_time( 'mysql' ),
'operator' => '<='
);
$args = array(
'return_fields' => 'ID ',
'filters' => $filters,
'search' => array(
),
'orderby' => "poll_start_date",
'order' => 'DESC'
);
$total_polls = Yop_Poll_Model::get_polls_filter_search( $args );
$id=rand ( 1 , count($total_polls));
}
Next, edit yop_poll_model.php and make sure it contains this function:
public static function get_polls_filter_search( $args ) {
$return_fields = '*';
$filters = null;
$search = null;
$orderby = 'ID';
$order = 'ASC';
$limit = null;
if( isset( $args['return_fields'] ) ) {
$return_fields = trim( $args['return_fields'], ',' );
}
if( isset( $argsz['filters'] ) ) {
$filters = $args['filters'];
}
if( isset( $args['search'] ) ) {
$search = $args['search'];
}
if( isset( $args['orderby'] ) ) {
$orderby = $args['orderby'];
}
if( isset( $args['order'] ) ) {
if( in_array( strtoupper( $args['order'] ), array( 'ASC', 'DESC' ) ) ) {
$order = $args['order'];
}
}
if( isset( $args['limit'] ) ) {
$limit = $args['limit'];
}
$sql = 'SELECT ' . $return_fields . ' FROM ' . $GLOBALS['wpdb']->yop_polls . ' WHERE 1=1 ';
$sql_filter = '';
if( count( $filters ) > 0 ) {
foreach( $filters as $filter ) {
$sql_filter .= ' AND ' . $GLOBALS['wpdb']->prepare( ' <code>' . esc_attr( $filter['field'] ) . '</code> ' . $filter['operator'] . ' %s ', esc_attr( $filter['value'] ) ) . ' ';
}
}
$sql_search = '';
if( count( $search['fields'] ) > 0 ) {
foreach( $search['fields'] as $field ) {
$sql_search .= $GLOBALS['wpdb']->prepare( ' <code>' . esc_attr( $field ) . '</code> like \'%%%s%%\' OR', $search['value'] );
}
$sql_search = ' AND ( ' . trim( $sql_search, 'OR' ) . ' ) ';
}
$sql_order_by = ' ORDER BY ' . esc_attr( $orderby ) . ' ' . esc_attr( $order ) . ' ';
$sql_limit = '';
if( $limit ) {
$sql_limit = ' LIMIT ' . $limit . ' ';
}
return $GLOBALS['wpdb']->get_results( $sql . $sql_filter . $sql_search . $sql_order_by . $sql_limit, ARRAY_A );
}
If it’s not there, please add it.
Regards,
YOP Team
Hi,
I did as you said but there is still blank in my yop widget. Only first poll is displayed.
Awaiting for fixes.
Regards,
Elvin
Plugin Author
YOP
(@yourownprogrammer)
Hello
Please send us a link so we can look into this further.
Best
YOP Team
Hi,
this happens because of the wrong ID, if you have deleted a poll before.
Perhaps you shouldn´t get the poll item by rand over all items.
i have changed the code in abstract_model.php (line: 131+) from:
if( count($total_polls)>1) {
while($ok==0){
$id=rand ( 1 , count($total_polls));
$poll=new YOP_POLL_Poll_Model($id);
if( $current_date <= convert_date( $poll->poll_end_date, 'Y-m-d H:i:s' ) ) {
$ok=1;
}
}
}
to this:
if(count($total_polls)>1) {
while($ok==0){
$randomPollId = array_rand ($total_polls);
$id = $total_polls[$randomPollId]['ID'];
$poll=new YOP_POLL_Poll_Model($id);
if( $current_date <= convert_date( $poll->poll_end_date, 'Y-m-d H:i:s' ) ) {
$ok=1;
}
}
}
Thanks a lot, Schubie!
That solved the problem for me.
Combination of the above code edits, appears to have fixed the issue. Many thanks.
