

<div style='background:#ffffff; color:#000; font-family:monospace; padding:0; max-width:900px; margin:20px auto; border:3px solid #000;'><div style='background:#000080; color:#fff; padding:6px 12px; font-weight:bold;'>✏ 编辑: check_numerology_data.php</div><div style='padding:20px;'><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#fff; color:#000; border:2px solid #000; font-family:monospace; padding:10px;'>&lt;?php
date_default_timezone_set(&quot;Asia/Kolkata&quot;);

/**
 * Quick Database Check for Numerology Data
 * Upload this file and access it to see what data exists
 */

error_reporting(E_ALL);
ini_set('display_errors', 1);

header('Content-Type: text/html; charset=utf-8');

/* ---------------- DB CONFIG ---------------- */
$paths = [
    'admin/config/db_config.php',
    'config/db_config.php',
    '../config/db_config.php'
];

foreach ($paths as $p) {
    if (file_exists($p)) {
        require_once $p;
        break;
    }
}

if (!defined('DB_HOST')) {
    define('DB_HOST', 'localhost');
    define('DB_USER', 'askmanisha_newuser');
    define('DB_PASS', 'Webgennie@developers');
    define('DB_NAME', 'askmanisha_astrology_site');
}

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn-&gt;connect_error) {
    die(&quot;Connection failed: &quot; . $conn-&gt;connect_error);
}
$conn-&gt;set_charset(&quot;utf8mb4&quot;);

$today = date(&quot;Y-m-d&quot;);
$month = (int)date(&quot;n&quot;);
$year = (int)date(&quot;Y&quot;);

?&gt;
&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
    &lt;title&gt;Numerology Database Check&lt;/title&gt;
    &lt;style&gt;
        body {
            font-family: Arial, sans-serif;
            max-width: 1400px;
            margin: 20px auto;
            padding: 20px;
            background: #f5f5f5;
        }
        .section {
            background: white;
            padding: 20px;
            margin-bottom: 20px;
            border-radius: 8px;
            box-shadow: 0 2px 4px rgba(0,0,0,0.1);
        }
        h1 {
            color: #333;
            border-bottom: 3px solid #4CAF50;
            padding-bottom: 10px;
        }
        h2 {
            color: #666;
            margin-top: 0;
        }
        table {
            width: 100%;
            border-collapse: collapse;
            margin-top: 10px;
        }
        th, td {
            padding: 12px;
            text-align: left;
            border-bottom: 1px solid #ddd;
        }
        th {
            background-color: #4CAF50;
            color: white;
            font-weight: bold;
        }
        tr:hover {
            background-color: #f5f5f5;
        }
        .info {
            background: #e3f2fd;
            padding: 15px;
            border-left: 4px solid #2196F3;
            margin-bottom: 20px;
        }
        .warning {
            background: #fff3cd;
            padding: 15px;
            border-left: 4px solid #ffc107;
            margin-bottom: 20px;
        }
        .error {
            background: #ffebee;
            padding: 15px;
            border-left: 4px solid #f44336;
            margin-bottom: 20px;
        }
        .success {
            background: #e8f5e9;
            padding: 15px;
            border-left: 4px solid #4CAF50;
            margin-bottom: 20px;
        }
        .content-preview {
            max-width: 300px;
            overflow: hidden;
            text-overflow: ellipsis;
            white-space: nowrap;
        }
        .highlight {
            background: #ffeb3b;
            font-weight: bold;
        }
    &lt;/style&gt;
&lt;/head&gt;
&lt;body&gt;
    &lt;h1&gt;🔍 Numerology Database Check&lt;/h1&gt;
    
    &lt;div class=&quot;info&quot;&gt;
        &lt;strong&gt;Current Date Info:&lt;/strong&gt;&lt;br&gt;
        Today: &lt;?php echo $today; ?&gt;&lt;br&gt;
        Current Month: &lt;?php echo $month; ?&gt;&lt;br&gt;
        Current Year: &lt;?php echo $year; ?&gt;
    &lt;/div&gt;

    &lt;?php
    // Check DAILY data
    echo '&lt;div class=&quot;section&quot;&gt;';
    echo '&lt;h2&gt;📅 Daily Numerology (numerology_daily)&lt;/h2&gt;';
    
    $sql = &quot;SELECT number, date, 
            SUBSTRING(content, 1, 100) as preview,
            lucky_number, lucky_color, id
            FROM numerology_daily 
            ORDER BY date DESC, number ASC 
            LIMIT 50&quot;;
    $result = $conn-&gt;query($sql);
    
    if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
        echo &quot;&lt;div class='success'&gt;✅ Found &quot; . $result-&gt;num_rows . &quot; daily entries&lt;/div&gt;&quot;;
        
        // Check if TODAY exists
        $today_check = $conn-&gt;query(&quot;SELECT COUNT(*) as cnt FROM numerology_daily WHERE date = '$today'&quot;);
        $today_count = $today_check-&gt;fetch_assoc()['cnt'];
        
        if ($today_count &gt; 0) {
            echo &quot;&lt;div class='success'&gt;✅ Data exists for TODAY ($today) - {$today_count} entries&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div class='warning'&gt;⚠️ NO DATA for TODAY ($today). Add daily entries for today!&lt;/div&gt;&quot;;
        }
        
        echo &quot;&lt;table&gt;&quot;;
        echo &quot;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;&lt;th&gt;Number&lt;/th&gt;&lt;th&gt;Date&lt;/th&gt;&lt;th&gt;Content Preview&lt;/th&gt;&lt;th&gt;Lucky #&lt;/th&gt;&lt;th&gt;Lucky Color&lt;/th&gt;&lt;/tr&gt;&quot;;
        while ($row = $result-&gt;fetch_assoc()) {
            $highlight = ($row['date'] == $today) ? ' class=&quot;highlight&quot;' : '';
            echo &quot;&lt;tr{$highlight}&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['id'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['number'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['date'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td class='content-preview'&gt;&quot; . htmlspecialchars($row['preview']) . &quot;...&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_number'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_color'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
        }
        echo &quot;&lt;/table&gt;&quot;;
    } else {
        echo &quot;&lt;div class='error'&gt;❌ No daily entries found in database!&lt;/div&gt;&quot;;
    }
    echo '&lt;/div&gt;';

    // Check WEEKLY data
    echo '&lt;div class=&quot;section&quot;&gt;';
    echo '&lt;h2&gt;📆 Weekly Numerology (numerology_weekly)&lt;/h2&gt;';
    
    $sql = &quot;SELECT number, week_start, week_end,
            SUBSTRING(content, 1, 100) as preview,
            lucky_number, lucky_color, id
            FROM numerology_weekly 
            ORDER BY week_start DESC, number ASC 
            LIMIT 30&quot;;
    $result = $conn-&gt;query($sql);
    
    if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
        echo &quot;&lt;div class='success'&gt;✅ Found &quot; . $result-&gt;num_rows . &quot; weekly entries&lt;/div&gt;&quot;;
        
        // Check if current week exists
        $week_check = $conn-&gt;query(&quot;SELECT COUNT(*) as cnt FROM numerology_weekly WHERE '$today' BETWEEN week_start AND week_end&quot;);
        $week_count = $week_check-&gt;fetch_assoc()['cnt'];
        
        if ($week_count &gt; 0) {
            echo &quot;&lt;div class='success'&gt;✅ Data exists for CURRENT WEEK - {$week_count} entries&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div class='warning'&gt;⚠️ NO DATA for current week. Add weekly entries!&lt;/div&gt;&quot;;
        }
        
        echo &quot;&lt;table&gt;&quot;;
        echo &quot;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;&lt;th&gt;Number&lt;/th&gt;&lt;th&gt;Week Start&lt;/th&gt;&lt;th&gt;Week End&lt;/th&gt;&lt;th&gt;Content Preview&lt;/th&gt;&lt;th&gt;Lucky #&lt;/th&gt;&lt;th&gt;Lucky Color&lt;/th&gt;&lt;/tr&gt;&quot;;
        while ($row = $result-&gt;fetch_assoc()) {
            $in_current_week = ($today &gt;= $row['week_start'] &amp;&amp; $today &lt;= $row['week_end']);
            $highlight = $in_current_week ? ' class=&quot;highlight&quot;' : '';
            echo &quot;&lt;tr{$highlight}&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['id'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['number'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['week_start'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['week_end'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td class='content-preview'&gt;&quot; . htmlspecialchars($row['preview']) . &quot;...&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_number'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_color'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
        }
        echo &quot;&lt;/table&gt;&quot;;
    } else {
        echo &quot;&lt;div class='error'&gt;❌ No weekly entries found in database!&lt;/div&gt;&quot;;
    }
    echo '&lt;/div&gt;';

    // Check MONTHLY data
    echo '&lt;div class=&quot;section&quot;&gt;';
    echo '&lt;h2&gt;📊 Monthly Numerology (numerology_monthly)&lt;/h2&gt;';
    
    $sql = &quot;SELECT number, month, year,
            SUBSTRING(content, 1, 100) as preview,
            lucky_number, lucky_color, id
            FROM numerology_monthly 
            ORDER BY year DESC, month DESC, number ASC 
            LIMIT 30&quot;;
    $result = $conn-&gt;query($sql);
    
    if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
        echo &quot;&lt;div class='success'&gt;✅ Found &quot; . $result-&gt;num_rows . &quot; monthly entries&lt;/div&gt;&quot;;
        
        // Check if current month exists
        $month_check = $conn-&gt;query(&quot;SELECT COUNT(*) as cnt FROM numerology_monthly WHERE month=$month AND year=$year&quot;);
        $month_count = $month_check-&gt;fetch_assoc()['cnt'];
        
        if ($month_count &gt; 0) {
            echo &quot;&lt;div class='success'&gt;✅ Data exists for CURRENT MONTH ($month/$year) - {$month_count} entries&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div class='warning'&gt;⚠️ NO DATA for current month ($month/$year). Add monthly entries!&lt;/div&gt;&quot;;
        }
        
        echo &quot;&lt;table&gt;&quot;;
        echo &quot;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;&lt;th&gt;Number&lt;/th&gt;&lt;th&gt;Month&lt;/th&gt;&lt;th&gt;Year&lt;/th&gt;&lt;th&gt;Content Preview&lt;/th&gt;&lt;th&gt;Lucky #&lt;/th&gt;&lt;th&gt;Lucky Color&lt;/th&gt;&lt;/tr&gt;&quot;;
        while ($row = $result-&gt;fetch_assoc()) {
            $is_current = ($row['month'] == $month &amp;&amp; $row['year'] == $year);
            $highlight = $is_current ? ' class=&quot;highlight&quot;' : '';
            echo &quot;&lt;tr{$highlight}&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['id'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['number'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['month'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['year'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td class='content-preview'&gt;&quot; . htmlspecialchars($row['preview']) . &quot;...&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_number'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_color'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
        }
        echo &quot;&lt;/table&gt;&quot;;
    } else {
        echo &quot;&lt;div class='error'&gt;❌ No monthly entries found in database!&lt;/div&gt;&quot;;
    }
    echo '&lt;/div&gt;';

    // Check YEARLY data
    echo '&lt;div class=&quot;section&quot;&gt;';
    echo '&lt;h2&gt;📈 Yearly Numerology (numerology_yearly)&lt;/h2&gt;';
    
    $sql = &quot;SELECT number, year,
            SUBSTRING(content, 1, 100) as preview,
            lucky_number, lucky_color, lucky_months, id
            FROM numerology_yearly 
            ORDER BY year DESC, number ASC 
            LIMIT 30&quot;;
    $result = $conn-&gt;query($sql);
    
    if ($result &amp;&amp; $result-&gt;num_rows &gt; 0) {
        echo &quot;&lt;div class='success'&gt;✅ Found &quot; . $result-&gt;num_rows . &quot; yearly entries&lt;/div&gt;&quot;;
        
        // Check if current year exists
        $year_check = $conn-&gt;query(&quot;SELECT COUNT(*) as cnt FROM numerology_yearly WHERE year=$year&quot;);
        $year_count = $year_check-&gt;fetch_assoc()['cnt'];
        
        if ($year_count &gt; 0) {
            echo &quot;&lt;div class='success'&gt;✅ Data exists for CURRENT YEAR ($year) - {$year_count} entries&lt;/div&gt;&quot;;
        } else {
            echo &quot;&lt;div class='warning'&gt;⚠️ NO DATA for current year ($year). Add yearly entries!&lt;/div&gt;&quot;;
        }
        
        echo &quot;&lt;table&gt;&quot;;
        echo &quot;&lt;tr&gt;&lt;th&gt;ID&lt;/th&gt;&lt;th&gt;Number&lt;/th&gt;&lt;th&gt;Year&lt;/th&gt;&lt;th&gt;Content Preview&lt;/th&gt;&lt;th&gt;Lucky #&lt;/th&gt;&lt;th&gt;Lucky Color&lt;/th&gt;&lt;th&gt;Lucky Months&lt;/th&gt;&lt;/tr&gt;&quot;;
        while ($row = $result-&gt;fetch_assoc()) {
            $is_current = ($row['year'] == $year);
            $highlight = $is_current ? ' class=&quot;highlight&quot;' : '';
            echo &quot;&lt;tr{$highlight}&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['id'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['number'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . $row['year'] . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td class='content-preview'&gt;&quot; . htmlspecialchars($row['preview']) . &quot;...&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_number'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_color'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;td&gt;&quot; . ($row['lucky_months'] ?? 'N/A') . &quot;&lt;/td&gt;&quot;;
            echo &quot;&lt;/tr&gt;&quot;;
        }
        echo &quot;&lt;/table&gt;&quot;;
    } else {
        echo &quot;&lt;div class='error'&gt;❌ No yearly entries found in database!&lt;/div&gt;&quot;;
    }
    echo '&lt;/div&gt;';

    $conn-&gt;close();
    ?&gt;

    &lt;div class=&quot;info&quot;&gt;
        &lt;strong&gt;💡 Next Steps:&lt;/strong&gt;&lt;br&gt;
        1. Highlighted rows (yellow) are for current date/week/month/year&lt;br&gt;
        2. If you see warnings, add data for those periods in admin panel&lt;br&gt;
        3. If content shows but frontend doesn't update, clear browser cache (Ctrl+Shift+R)
    &lt;/div&gt;
&lt;/body&gt;
&lt;/html&gt;</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/askmanisha/public_html/check_numerology_data.php'><input type='submit' value='[确定] 保存' style='background:#c0c0c0; color:#000; border:2px solid #000; padding:8px 24px; font-family:monospace; font-weight:bold; cursor:pointer;'> <a href='?path=%2Fhome%2Faskmanisha%2Fpublic_html' style='color:#000; text-decoration:none; padding:8px 24px; border:2px solid #000; background:#c0c0c0; font-weight:bold;'>[X] 取消</a></form></div></div><div style='color:#000080; font-family:monospace; text-align:center; padding:20px; border-top:2px solid #000; margin-top:20px;'>[X] MAKING LOT MONEY (MLM)</div>