Personal Livescore

2 comments on “Personal Livescore”

1. Hello. I’m trying to implement a responsive table to view live games, modifying your page code pl-refresh.php, but unfortunately blank page. I’ll write you the code maybe you can help, I thank you in advance.

   [code]
   get_results(“SELECT * FROM ” . $wpdb->prefix . “livescore WHERE pl_active=1 AND pl_id=” . $rel . ” ORDER BY pl_datetime DESC LIMIT 1″, ARRAY_A);
   else
   $results = $wpdb->get_results(“SELECT * FROM ” . $wpdb->prefix . “livescore WHERE pl_active=1 ORDER BY pl_datetime DESC”, ARRAY_A);

   $pl_is_active = ” . __(‘Finale’, ‘pl’) . ”;

   $display .= ” . get_option(‘pl_label_live’) . ”;

   foreach($results as $row) {
   if($row[‘pl_set’] != 0) $pl_set = ‘ ‘ . __(‘SET’, ‘pl’) . ‘ ‘ . $row[‘pl_set’] . ”;
   $display .= ”;
   $display .= ”;
   $display .= ”;
   $display .= ”;
   $display .= ” . $row[‘pl_datetime’] . ”;
   $display .= ” . $row[‘pl_sport’] . ”;
   $display .= ” . $row[‘pl_location’] . ”;
   $display .= ” . $row[‘pl_team1’] . ‘ vs ‘ . $row[‘pl_team2’] . ”;
   $display .= ” . $row[‘pl_score1’] . ‘:’ . $row[‘pl_score2’] . ”;
   $display .= ‘SET ‘ . $row[‘pl_set’] . ”;
   $display .= ”
   Link with href
   ”;
   $display .= ”;

   }

   ”;
   ”;

   content collapse

   // begin display goals
   $goals_results = $wpdb->get_results(“SELECT * FROM ” . $wpdb->prefix . “livescore_goals WHERE goal_match_id = ” . $row[‘pl_id’], ARRAY_A);
   if($wpdb->num_rows > 0) {
   $display .= ”;
   $display .= ‘Dettagli partita’;
   foreach($goals_results as $goals_row) {
   $display .= ” . $goals_row[‘goal_time’] . ‘ ‘ . $goals_row[‘goal_scorer’] . ”;
   }
   $display .= ”;
   }
   // end display goals

   $display .= ”;
   $pl_set = ”;
   }

   // display upcoming scores
   $results = $wpdb->get_results(“SELECT * FROM ” . $wpdb->prefix . “livescore WHERE pl_active=2 ORDER BY pl_datetime DESC”, ARRAY_A);

   $pl_is_active = ‘»’;

   $display .= ” . get_option(‘pl_label_upcoming’) . ”;
   foreach($results as $row) {
   $display .= ”;
   $display .= ” . $row[‘pl_sport’] . $row[‘pl_location’] . ” . ‘ ‘ . $row[‘pl_datetime’] . $pl_is_active . ”;
   $display .= ” . $row[‘pl_team1’] . ‘0’;
   $display .= ” . $row[‘pl_team2’] . ‘0’;
   $display .= ”;
   }

   // banner ad
   // $display .= ”;

   $display .= ” . get_option(‘pl_copyright_line’) . ”;

   echo $display;

   [end code]

   Reply

2. Don’t modify the code, just add a class on the main DIV and then use that class to make everything responsive.

   Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.