 <?php
// data_popular.php

// Include database connection
include 'config.php'; // adjust if your DB config is elsewhere

// Include Smarty (adjust path if needed)
require_once 'libs/Smarty.class.php';

$smarty = new Smarty;

// Pagination (optional)
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$per_page = 15; // same as $t_per_page in your config
$start = ($page - 1) * $per_page;

// Fetch lists ordered by highest votes
$sql = "SELECT * FROM lists ORDER BY list_votes DESC LIMIT :start, :per_page";
$stmt = $pdo->prepare($sql);
$stmt->bindValue(':start', $start, PDO::PARAM_INT);
$stmt->bindValue(':per_page', $per_page, PDO::PARAM_INT);
$stmt->execute();
$output_page = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Assign to Smarty
$smarty->assign('output_page', $output_page);

// Optional: site link for comments in template
$site_link = 'https://votters.com'; // replace with your actual site URL
$smarty->assign('site_link', $site_link);

// Display the template
$smarty->display('popular_lists.tpl'); // replace with your actual template file