MuCore Online/Offline Check Status with ODBC gives N/A.

[awesomo]

Someone must have fixed this by now. Anyone?



get.php

if (isset($_GET['aG'])) {
    include("engine/connect_core.php");
    $acc_G  = base64_decode(crypt_it(set_limit($_GET['aG'], '12', ''), $core['config']['crypt_key']));
    $acc_Gs = safe_input($acc_G, '');
    $c_s    = $core_db2->Execute("Select connectstat from MEMB_STAT where memb___id=?", array(
        $acc_Gs
    ));
    if ($c_s->EOF) {
        echo 'N/A';
    } else {
        if ($c_s->fields[0] == '0') {
            echo '<span style="color:#990000;"><b>Offline</b></span>';
        } elseif ($c_s->fields[0] == '1') {
            echo '<span style="color:#99CC00;"><b>Online</b></span>';
        }
    } 

rankings.php

<tr>
                        <td align="left" class="iR_status">';
                            if ($get_config->char_status == '1') {
                                echo '<div id="s_' . $cache_count . '"><a href="javascript:void(0)" onclick="get_data(\'s_' . $cache_count . '\',\'#s_' . $cache_count . '\', \'get.php?aG=' . base64_encode(crypt_it($r_cache[10], $core['config']['crypt_key'])) . '\', null, \'data=s_' . $cache_count . '\');">Check Status</a></div>';
                            }
                            
                            echo '</td>
                        <td align="left" class="iR_status">';
                            if ($get_config->location == '1') {
                                echo '<div id="m_' . $cache_count . '"><a href="javascript:void(0)" onclick="get_data(\'m_' . $cache_count . '\',\'#m_' . $cache_count . '\', \'get.php?aM=' . $r_cache[0] . '\', null, \'data=m_' . $cache_count . '\');">Location</a></div>';
                            }
                            echo '</td>
                        <td align="left" class="iR_stats">Com: ';
                            if ($hide_stats == '1') {
                                echo '--';
                            } else {
                                echo number_format($r_cache[9]);
                            }
                            echo '</td>
                        <td align="left" class="iR_stats_reset">Resets ' . ($r_cache[4]) . ', Grand Resets ' . $r_cache[12] . '</td>
                        </tr> 

[MentaL]

[KarLi]

But why u wanna check stats with odbc if status can be shown with mssql normally?

[awesomo]

For some reason mucore doesn't work or install if I select mssql. Still have to find out why.

[KarLi]

weird, so mssql is not working ? or ur xampp isnt good with it?