2 IA Julia servers on 1 machine

**m1nd3** · 26-12-16

Hello all, i need help, i launch 2 servers on 1 PC, looks everything works good, i use MvCore 1.17.0 and try MvCore 1.0.8, but the same, online players show in one server, web does not separate them. Maybe i did something wrong in server side. Because webs support 2 database, but show in one. Maybe it's problem in my ODBC...

Code:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\AccountDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\LOGIN]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\LocalServer]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MU2003_EVENT_DB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnlin2]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnlin2Admin]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MuOnlin2JoinDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\PC_MUONLIN2]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\PE_MUONLIN2]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\MatchDB]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\Ranking]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\USELOG]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="(local)"
"Database"="MuOnlin2"
"LastUser"="Administrator"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]
"AccountDB"="SQL Server"
"LOGIN"="SQL Server"
"LocalServer"="SQL Server"
"MU2003_EVENT_DB"="SQL Server"
"MuOnlin2"="SQL Server"
"MuOnlin2Admin"="SQL Server"
"MuOnlin2JoinDB"="SQL Server"
"PC_MUONLIN2"="SQL Server"
"PE_MUONLIN2"="SQL Server"
"MatchDB"="SQL Server"
"Ranking"="SQL Server"
"USELOG"="SQL Server"

I'm sure in 99% that is my ODBC problem, but i don't know how to write it correct.

**MentaL**

**KarLi** · 28-12-16

why u dont do manually ODBC?
https://www.youtube.com/watch?v=fs-7CuXzj08
do that but instead of muonline - > muonlin2 and target it on your muonlin2 database

**m1nd3** · 28-12-16

I was trying, but necessary , and i think i found problem, i was trying a lot of ways to edit ODBC, and all of them i found on my pc in regedit.exe so now i deleted everything and tomorrow i will try again. Thanks again for the link.

**m1nd3** · 29-12-16

Nop, it's the same, not exactly same, because i try now to create Me_MuOnline, and now show accounts in both servers at the same time. If without Me_MuOnline from both servers show online in 1st server on website. Is any way to separate them. I'm already trying to do this about 2 weeks...

**KarLi** · 29-12-16

look all i can think of its when u want to show statistics from web to muonlin2 then you must connect to port 5590X (subserver MuOnlin2 GameServer Port) and not same port of muonline

**m1nd3** · 29-12-16

My ports are different
(MuOnline) GS: C:\MuOnline\GameServer\GameServer.exe 127.0.0.1 55970 127.0.0.1 55960 55901
(MuOnline2) GS: C:\MuOnline2\GameServer\GameServer.exe 127.0.0.1 55970 127.0.0.1 55964 55921 127.0.0.1 55966 127.0.0.1 55915
And it's not SubSerer, i run second server.

**KarLi** · 30-12-16

well in website statistics.php or wherever it fetch statistics from server it must connect to port 55915 to show correct statistic

**m1nd3** · 30-12-16

I think my knowing about coding is not so good, because there is no anything about ports in statistics.php

Code:

<?php if(!$mvcore['Statistics'] == 'on') { echo'<div class="mvcore-nNote mvcore-nFailure">'.eng_for_the_moment_tpi_disabled.'</div>'; } ?>
<?php if($mvcore['Statistics'] == 'on') { ?>
<?PHP

$sql100 = mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectStat = '1'");
$acr1 =mssql_result($sql100, 0, 0);

$sql101 = mssql_query("SELECT count(*) FROM ".$mvcore_medb_i."");
$acr2 =mssql_result($sql101, 0, 0);

$sql102 = mssql_query("SELECT count(*) FROM Character");
$acr3 =mssql_result($sql102, 0, 0);

$sql103 = mssql_query("SELECT count(*) FROM Guild");
$acr4 =mssql_result($sql103, 0, 0);

$sql104 = mssql_query("SELECT count(*) FROM Character WHERE CtlCode = '32'");
$acr5 =mssql_result($sql104, 0, 0);

$sql105 = mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectStat = '1'");
$total['online']=mssql_result($sql105, 0, 0);

$month_today = date("M", time());
$day_today  = date("j", time());
$year_today  = date("Y", time());
$query   =mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectTM LIKE '%".$month_today."%".$day_today."%".$year_today."%' OR DisConnectTM LIKE '%".$month_today."%".$day_today."%".$year_today."%'");
$online_today = mssql_result($query, 0, 0);
$sql = mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectStat = 1");


$sql106 = mssql_query("SELECT Owner_Guild FROM MuCastle_Data");
$acr7 = mssql_fetch_row($sql106);

$sql107 = mssql_query("SELECT Siege_End_Date From MuCastle_Data");
$acr8 = mssql_fetch_row($sql107);
$acr8s = strtotime($acr8[0]) - 86400;

$sql108 = mssql_query("SELECT G_Master FROM Guild WHERE G_Name ='$acr7[0]'");
$acr9 = mssql_fetch_row($sql108);

$Crywolfs = mssql_query("SELECT CRYWOLF_OCCUFY FROM MuCrywolf_DATA WHERE MAP_SVR_GROUP ='0'");
$Crywolfs_Drop = mssql_fetch_row($Crywolfs);

if($Crywolfs_Drop[1] >= '1') { $dropStated = '<font color="green">'.main_p_statistics_protected.'</font>'; } else { $dropStated = '<font color="red">'.main_p_statistics_notprotected.'</font>'; };


$points_totak_vaneter = mssql_query("SELECT sum(cast(".$mvcore['gens_contricol_name']." AS integer)) AS TotalVaneter FROM ".$mvcore['gens_tab_name']." WHERE ".$mvcore['gens_famicol_name']." = '2'");
$points_totak_vaneter = mssql_fetch_row($points_totak_vaneter);
$points_totak_duprain = mssql_query("SELECT sum(cast(".$mvcore['gens_contricol_name']." AS integer)) AS TotalDuprain FROM ".$mvcore['gens_tab_name']." WHERE ".$mvcore['gens_famicol_name']." = '1'");
$points_totak_duprain = mssql_fetch_row($points_totak_duprain);

$total_vanert =  mssql_query("SELECT count(*) FROM ".$mvcore['gens_tab_name']." WHERE ".$mvcore['gens_famicol_name']." = '2'");
$sVener =mssql_result($total_vanert, 0, 0);
$total_duprian =  mssql_query("SELECT count(*) FROM ".$mvcore['gens_tab_name']." WHERE ".$mvcore['gens_famicol_name']." = '1'");
$sDupri =mssql_result($total_duprian, 0, 0);

if($sDupri == '0') { $durpriDropPoints = '0'; } else { $durpriDropPoints = $points_totak_duprain[0]; };
if($sVener == '0') { $venriDropPoints = '0'; } else { $venriDropPoints = $points_totak_vaneter[0]; };


//Class Count Information
$class0 = mssql_query("SELECT count(*) FROM Character WHERE class = '0'"); // DW
$classD0 =mssql_result($class0, 0, 0);

$class1 = mssql_query("SELECT count(*) FROM Character WHERE class = '1'"); // SM
$classD1 =mssql_result($class1, 0, 0);

$class2 = mssql_query("SELECT count(*) FROM Character WHERE class >= '2' and class <= '3'"); // GM
$classD2 =mssql_result($class2, 0, 0);


$class16 = mssql_query("SELECT count(*) FROM Character WHERE class = '16'"); // DK
$classD16 =mssql_result($class16, 0, 0);

$class17 = mssql_query("SELECT count(*) FROM Character WHERE class = '17'"); // BK
$classD17 =mssql_result($class17, 0, 0);

$class18 = mssql_query("SELECT count(*) FROM Character WHERE class >= '18' and class <= '19'"); // BM
$classD18 =mssql_result($class18, 0, 0);


$class32 = mssql_query("SELECT count(*) FROM Character WHERE class = '32'"); // Elf
$classD32 =mssql_result($class32, 0, 0);

$class33 = mssql_query("SELECT count(*) FROM Character WHERE class = '33'"); // Muse Elf
$classD33 =mssql_result($class33, 0, 0);

$class34 = mssql_query("SELECT count(*) FROM Character WHERE class >= '34' and class <= '35'"); // Hight Elf
$classD34 =mssql_result($class34, 0, 0);


$class48 = mssql_query("SELECT count(*) FROM Character WHERE class = '48'"); // MG
$classD48 =mssql_result($class48, 0, 0);

$class49 = mssql_query("SELECT count(*) FROM Character WHERE class >= '49' and class <= '51'"); // DM
$classD49 =mssql_result($class49, 0, 0);


$class64 = mssql_query("SELECT count(*) FROM Character WHERE class = '64'"); // DL
$classD64 =mssql_result($class64, 0, 0);

$class65 = mssql_query("SELECT count(*) FROM Character WHERE class >= '65' and class <= '67'"); // LE
$classD65 =mssql_result($class65, 0, 0);


$class80 = mssql_query("SELECT count(*) FROM Character WHERE class = '80'"); // Sum
$classD80 =mssql_result($class80, 0, 0);

$class81 = mssql_query("SELECT count(*) FROM Character WHERE class = '81'"); // Bloody Sum
$classD81 =mssql_result($class81, 0, 0);

$class82 = mssql_query("SELECT count(*) FROM Character WHERE class >= '82' and class <= '83'"); // Dimension Master
$classD82 =mssql_result($class82, 0, 0);


$class96 = mssql_query("SELECT count(*) FROM Character WHERE class = '96'"); // RF
$classD96 =mssql_result($class96, 0, 0);

$class97 = mssql_query("SELECT count(*) FROM Character WHERE class >= '97' and class <= '98'"); // FM
$classD97 =mssql_result($class97, 0, 0);


$class112 = mssql_query("SELECT count(*) FROM Character WHERE class >= '112' and class <= '114'"); // GL
$classD112 =mssql_result($class112, 0, 0);

?>
<?php if( $mvcore['db_season'] >= '6') { ?>
<table width="100%" align="center" border="0" cellspacing="0" cellpadding="0">
    <tr width="100%" align="center">
        <td><img src="system/engine_images/gens/family.png" alt="duprian"></td>
    </tr>
</table>
<table class="mvcore-tablestat" width="100%" align="center" border="0" cellspacing="0" cellpadding="0">
    <tr width="100%" align="center">
        <td colspan="4"><?php echo main_p_statistics_gensfamilypoints;?></td>
    </tr>
    <tr width="100%" align="center">
            <td><img src="system/engine_images/gens/DupriansFamily.png"></td>
        <td><?php echo main_p_statistics_members;?>: <?php echo $sDupri;?> <br> <?php echo main_p_statistics_points;?>: <?php echo $durpriDropPoints;?></td>
            <td><img src="system/engine_images/gens/StewardsFamily.png"></td>
        <td><?php echo main_p_statistics_members;?>: <?php echo $sVener;?><br><?php echo main_p_statistics_points;?>: <?php echo $venriDropPoints;?></td>
    </tr>
</table>
<br>
<br>
<?php } ?>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td colspan="2"><?php echo main_p_statistics_serverinfo;?></td>
    </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_maxstat;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $mvcore['server_max_stat'];?></td>
                </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_maxskslot;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $mvcore['max_sock_opt'];?></td>
                </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_totalacc;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $acr2;?></td>
                </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_totalchar;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $acr3;?></td>
                </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_totalguild;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $acr4;?></td>
                </tr>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_totalgmaster;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $acr5;?></td>
                </tr>
                <?php if($mvcore['onoff_player_count'] == 'show') { ?>
                    <tr style='border-collapse: collapse; border-spacing: 0px;'>
                        <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_totalonline;?></td>
                        <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;color:green;"><?php echo $acr1;?></td>
                    </tr>
                <?php } ?>
                <tr style='border-collapse: collapse; border-spacing: 0px;'>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_todayactive;?></td>
                    <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;color:red;"><?php echo $online_today;?></td>
                </tr>

</table>
<br>
<?php 
$sys_startsas = mssql_query("select top 1 event_name from MVCore_Event_Timer where type = '2'");
$sys_startsass = mssql_fetch_row($sys_startsas);
if( $sys_startsass[0] != '') { ?>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td colspan="5" style="padding-left: 15px;"><?php echo''.main_p_statistics_staticeventi.'';?></td>
    </tr>
</table>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">

    <tr class="mvcore-tabletr">
        <td><?php echo''.main_p_statistics_eventname.'';?></td>
        <td><?php echo''.main_p_statistics_eventsarthr.'';?></td>
        <td><?php echo''.main_p_statistics_eventstartemin.'';?></td>
        <td><?php echo''.main_p_statistics_eventtime.'';?></td>
        <td><?php echo''.main_p_statistics_eventrewas.'';?></td>
    </tr>
<?php
$sys_startsa = mssql_query("select top 100 event_name, event_hour, event_min, event_interval, event_run_time, event_reward_info, type, date, event_start_date from MVCore_Event_Timer where type = '2' order by date desc");
for($i=0;$i < mssql_num_rows($sys_startsa);++$i) {
$drop_info = mssql_fetch_row($sys_startsa);
                                
echo'
        <tr style="border-collapse: collapse; border-spacing: 0px;">
            <td style="text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$drop_info[0].'</td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$drop_info[1].'</td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$drop_info[2].'</td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$drop_info[4].'</td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$drop_info[5].'</td>
        </tr>
';
};
?>
</table>
<br>
<?php } ?>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td colspan="2"><?php echo main_p_statistics_crywolfinfo;?></td>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo main_p_statistics_statueoffortress;?></td>
            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $dropStated;?></td>
        </tr>
</table>
<br>
<br>

<?php
if ($acr7[0] == ' ' || $acr7[0] == ''){
    echo'
        <table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
            <tr class="mvcore-tabletr">
                <td colspan="2">'.main_p_statistics_castleownerexit.'</td>
            </tr>
        </table>
    ';
} else { 
    echo'
        <table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
            <tr class="mvcore-tabletr">
                <td colspan="2" style="padding-left: 15px;">'.main_p_statistics_castlesiegeinfo.'</td>
            </tr>
                        <tr style="border-collapse: collapse; border-spacing: 0px;">
                            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.main_p_statistics_castleownerguil.'</td>
                            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$acr7[0].'</td>
                        </tr>
                        <tr style="border-collapse: collapse; border-spacing: 0px;">
                            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.main_p_statistics_ownname.'</td>
                            <td style="padding: 6px 3px 6px 3px;width:50%;text-align: center;border: 0;border-bottom: 1px solid '.$mvcore['table_s_borcolor'].';">'.$acr9[0].'</td>
                        </tr>
        </table>
    '; 
}; ?>
<div class="mvcore-nNote mvcore-nInformation"><?php echo main_p_statistics_castlesieocupy;?> <?php echo date('m-d-Y',$acr8s);?></div>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td>Dark Wizard</td>
        <td>Soul Master</td>
        <?php if( $mvcore['db_season'] >= '3'){ ?><td>Grand Master</td><?php } ?>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD0;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD1;?></td>
            <?php if( $mvcore['db_season'] >= '3'){ ?><td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD2;?></td><?php } ?>
        </tr>
</table>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td>Dark Knight</td>
        <td>Blade Knight</td>
        <?php if( $mvcore['db_season'] >= '3'){ ?><td>Blade Master</td><?php } ?>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD16;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD17;?></td>
            <?php if( $mvcore['db_season'] >= '3'){ ?><td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD18;?></td><?php } ?>
        </tr>
</table>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td>Elf</td>
        <td>Muse Elf</td>
        <?php if( $mvcore['db_season'] >= '3'){ ?><td>Hight Elf</td><?php } ?>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD32;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD33;?></td>
            <?php if( $mvcore['db_season'] >= '3'){ ?><td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD34;?></td><?php } ?>
        </tr>
</table>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td> - </td>
        <td>Magic Gladiator</td>
        <?php if( $mvcore['db_season'] >= '3'){ ?><td>Duel Master</td><?php } ?>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"> - </td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD48;?></td>
            <?php if( $mvcore['db_season'] >= '3'){ ?><td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD49;?></td><?php } ?>
        </tr>
</table>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td> - </td>
        <td>Dark Lord</td>
        <?php if( $mvcore['db_season'] >= '3'){ ?><td>Lord Emperor</td><?php } ?>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"> - </td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD64;?></td>
            <?php if( $mvcore['db_season'] >= '3'){ ?><td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD65;?></td><?php } ?>
        </tr>
</table>
<?php if( $mvcore['db_season'] >= '4'){ ?>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td>Summoner</td>
        <td>Bloody Summoner</td>
        <td>Dimension Master</td>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD80;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD81;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD82;?></td>
        </tr>
</table>
<?php } ?>
<?php if( $mvcore['db_season'] >= '6'){ ?>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td> - </td>
        <td>Rage Fighter</td>
        <td>Fist Master</td>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"> - </td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD96;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD97;?></td>
        </tr>
</table>
<?php } ?>
<?php if( $mvcore['db_season'] >= '10'){ ?>
<br>
<table class="mvcore-tablestat" cellpadding="0" cellspacing="0">
    <tr class="mvcore-tabletr">
        <td>Grow Lancer</td>
        <td> - </td>
        <td> - </td>
    </tr>
        <tr style='border-collapse: collapse; border-spacing: 0px;'>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"><?php echo $classD112;?></td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"> - </td>
            <td style="text-align: center;border: 0;border-bottom: 1px solid <?php echo''.$mvcore['table_s_borcolor'].'';?>;"> - </td>
        </tr>
</table>
<?php } ?>
<?php } ?>

**KarLi** · 30-12-16

well for me it looks like it only connects to MuOnline DB... thats the issue for not showing status of muonlin2, what about in template index.php? any other files that retrieve statistics etc

**m1nd3** · 30-12-16

C:\xampp\htdocs\themes\th_Original\index.php

Code:

<!DOCTYPE html>
<html lang="en-US">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
        <meta name="Keywords" content="Massively multiplayer online games, mmo, rpg online games, games, game, free online games, Webzen, new slogan, next generation, MVCore, Mu Online, Mu, Game, Online, Server, Play, For, Free, Season, s2, s3, s4, s5, s6, s7, s8, s9, blade master, grand master, hight elf, dimension master, duel master, lord emperor, fist master, massive portal promotion, Jump Start with fully-Geared High leveled characters, Skip the low, Jump to hight,Top-notch, high level avatars">
        <meta name="description" content="MuOnline Private Server Website" />
        <title><?php echo $mvcore['title'];?></title> <!-- Can edit from AdminCP -->
        <link rel="shortcut icon" href="system/engine_images/favi.png" /> <!-- MVCore ICO -->
        <script src="//code.jquery.com/jquery-1.10.2.js"></script> <!-- JS-->
        <?php include('system/theme_inc/inc.item_viewer.php'); ?> <!-- Item View JS -->
        <?php include('system/engine_css/mvcore_style.php'); ?> <!-- Engine CSS -->

        <style>
            body {
                background-attachment: fixed !important;
                background-color: transparent;
                background: url("/themes/<?php echo $mvcore['theme_dir'];?>/img/body_bg.jpg") no-repeat center top;
                height:100%;
                font-family: "Helvetica Neue", Helvetica, Arial, sans-serif;
                color:#4a4a4a;
                font-size:13px;
            }
            
            a {
                color:#ff5b5b;
                text-decoration: none;
                -webkit-transition-delay: 0.30s linear;
                transition-delay: 0.30s linear;
                transition: all 0.30s linear;
            }
            
            a:hover {
                color:#666666;
                text-decoration: none;
            }
            
            .tmenu ul li a {
                text-decoration: none;
                color:#9fa1a7;
                text-transform: uppercase;
                padding:15px;
                font-weight:bold;
                font-size:12px;
                text-shadow: 0 1px 0 rgba(255, 255, 255, 0.5);
                -webkit-transition-delay: 0.30s linear;
                transition-delay: 0.30s linear;
                transition: all 0.30s linear;
            }
            
            .tmenu ul li a:hover {
                color:#FFFFFF;
                text-decoration: none;
            }
            
            .tmenu ul li { display: inline; }
            
            div a {
                color:#ff5b5b;
                text-decoration: none;
                -webkit-transition-delay: 0.30s linear;
                transition-delay: 0.30s linear;
                transition: all 0.30s linear;
            }
            
            div a:hover {
                color:#666666;
                text-decoration: none;
            }
            
            .server-time-stl {
                color:#FF0000;
                font-size:16px;
                text-decoration: none;
                text-transform: uppercase;
                -webkit-transition-delay: 0.30s linear;
                transition-delay: 0.30s linear;
                transition: all 0.30s linear;
            }
            
            .server-time-stl:hover {
                color:#000000;
                text-decoration: none;
            }
            
        </style>
    </head>
    <body>
    <table width="100%" valign="top" align="center" border="0" cellpadding="0" cellspacing="0" style="font-size:13px;max-width:1100px;">
        <tr><td style="height:60px;"></td></tr>
            <tr align="right"><td><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/logo.png"></td></tr>
        <tr><td style="height:60px;"></td></tr>
        <tr align="left">
            <td style="background: url('/themes/<?php echo $mvcore['theme_dir'];?>/img/menu.png') no-repeat center top; background-size: 100%; width:100%; height:50px;" class="tmenu">
                <ul style="float:left;list-style-type: none;" valign="top">
                    <?php if($mvcore['News']=='on') { ?><li><a href="-id-News.html"><?php echo''.theme_link_news.''; ?></a></li><?php } ?>
                    <li><a href="-id-Rules.html"><?php echo''.Rules.''; ?></a></li>
                    <?php if($mvcore['Register']=='on' && $_SESSION['user_login'] != 'ok') { ?><li><a href="-id-Register.html"><?php echo''.theme_link_register.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Downloads']=='on') { ?><li><a href="-id-Downloads.html"><?php echo''.theme_link_downloads.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Rankings']=='on') { ?><li><a href="-id-Rankings.html"><?php echo''.theme_link_rankings.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Statistics']=='on') { ?><li><a href="-id-Statistics.html"><?php echo''.theme_link_statistics.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Banned_Players']=='on') { ?><li><a href="-id-Banned_Players.html"><?php echo''.theme_link_bannedp.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Gallery']=='on') { ?><li><a href="-id-Gallery.html"><?php echo''.theme_link_gallery.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Market']=='on') { ?><li><a href="-id-Market.html"><?php echo''.theme_link_market.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Webshop']=='on') { ?><li><a href="-id-Webshop.html"><?php echo''.theme_link_webshop.''; ?></a></li><?php } ?>
                    <?php if($mvcore['Forum']=='on') { ?><li><a target="blank" href="<?php echo $mvcore['forurl']; ?>"><?php echo''.theme_link_forum.''; ?></a></li><?php } ?>
                </ul>
            </td>
        </tr>
        <tr><td style="height:20px;"></td></tr>
        <tr><td style="background: url('/themes/<?php echo $mvcore['theme_dir'];?>/img/c_top.jpg') no-repeat center bottom; background-size: 100%; width:100%; height:10px;"></td></tr>
        <tr>
            <td style="background: url('/themes/<?php echo $mvcore['theme_dir'];?>/img/c_mid.jpg') repeat-y center top; background-size: 100%; width:100%; padding-top:25px;padding-bottom:25px;padding-right:35px;padding-left:35px;">
                <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                    <tr width="100%">
                        <td valign="top" width="67%">
                        
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top">
                                        <?php include('system/theme_inc/inc.slider.php'); ?> <!-- Slider Image Output -->
                                    </td>
                                </tr>
                                    <tr><td valign="top" height="35px" align="center"></td></tr>
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;"><?php include('system/engine_ptext.php'); ?> <!-- Used To Output Page Names --></div>
                                        <div style="padding:20px;">
                                            <div align="center"> <?php echo $mvcore['ads_spt_468x60']; ?> <!-- Banner ( 468 x 60 ) --> </div>
                                            <?php include('system/engine_pages.php'); ?>
                                        </div>
                                    </td>
                                </tr>
                            </table>
                            
                        </td>
                        <td valign="top" style="width:25px !important;"></td>
                        <td valign="top" width="30%">
                        
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;text-transform: uppercase;">USER <?php if($_SESSION['user_login'] == 'ok') { echo $_SESSION['username']; } else { echo'LOGIN';} ?></div>
                                        <div style="padding:20px;">
                                            <?php if($_SESSION['user_login'] != 'ok') { ?>
                                            <form action="" method="POST">
                                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0">
                                                    <?php
                                                        if($mvcore['multi_dbs_supp'] == 'on' && $mvcore['multi_dbs_app_t_sw'] == 'swsbl') {
                                                            echo '<tr align="center"><td><select name="database_load" class="mvcore-select-main" style="width:230px !important;">';
                                                            $cmulti_dbs = explode(',',$mvcore['multi_dbs_names']);
                                                            $cmulti_dbs_titl = explode(',',$mvcore['multi_dbs_titlen']);
                                                            for($i=0;$i < count($cmulti_dbs);++$i) {
                                                                if($_SESSION['database_load']==$cmulti_dbs[$i]){ $opdsvgf[$i] = 'selected'; }else{ $opdsvgf[$i] = ''; };
                                                                echo '<option value="'.$cmulti_dbs[$i].'" '.$opdsvgf[$i].'>'.$cmulti_dbs_titl[$i].'</option>';
                                                            };
                                                            echo '</select></td></tr>';
                                                        };
                                                    ?>
                                                <tr align="center">
                                                    <td><input type="text" name="usern" class="mvcore-input-main" value="" placeholder="Username" style="width:230px !important;"></td>
                                                </tr>
                                                <tr align="center">
                                                    <td><input type="password" name="passn" class="mvcore-input-main" value="" placeholder="Password" style="width:230px !important;"></td>
                                                </tr>
                                                <tr align="center">
                                                    <td>
                                                        <button class="mvcore-button-style" name="loginacc" style="cursor:pointer" type="submit"><?php echo main_p_user_login_login; ?></button>
                                                        <?php if($mvcore['Register']=='on' && $_SESSION['user_login'] != 'ok') { ?><a class="mvcore-button-style" href="-id-Register.html"><?php echo''.theme_link_register.''; ?></a><?php } ?>
                                                        <br>
                                                        <?php if($mvcore['Lost_Password']=='on'  && $_SESSION['user_login'] != 'ok') { ?><a href="-id-Lost_Password.html"><?php echo''.theme_link_lpassword.''; ?></a><?php } ?>
                                                    </td>
                                                </tr>
                                            </table>
                                            </form>
                                            <?php } else { ?>
                                                
                                                    <?php
                                                        if($mvcore['multi_dbs_supp'] == 'on') {
                                                            echo '<div class="latest-twitter-tweett"><img src="/themes/'.$mvcore['theme_dir'].'/img/pc.png" width="15px"> Server: <b>';
                                                            $cmulti_dbs = explode(',',$mvcore['multi_dbs_names']);
                                                            $cmulti_dbs_titl = explode(',',$mvcore['multi_dbs_titlen']);
                                                            for($i=0;$i < count($cmulti_dbs);++$i) {
                                                                if($cmulti_dbs[$i] == $db_name_multi) { echo ''.$cmulti_dbs_titl[$i].''; break; } else {};
                                                            };
                                                            echo '</b></div>';
                                                        };
                                                    ?>
                                                
                                                <div class="latest-twitter-tweett"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/cred.png"> <?php echo $mvcore['money_name1']; ?>: <b><?php echo $mvc_Money_credits; ?></b></div>
                                                <div class="latest-twitter-tweett"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/gold.png"> <?php echo $mvcore['money_name2']; ?>: <b><?php echo $mvc_Money_goldcredits; ?></b></div>
                                                <div class="latest-twitter-tweett"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/wcoins.png"> wCoins: <b><?php echo $mvc_Money_wcoins; ?></b></div>
                                                <div class="latest-twitter-tweett"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/zen.png"> Vault Zen: <b><?php echo $mvc_Money_VaultZen; ?></b></div>
                                                
                                                <!-- =-=-= Main Pages For Users ( Contains PHP To Hide Link If Page Disabled In AdminCP ) =-=-= -->
                                                <?php if($mvcore['Account_Settings']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Account_Settings.html"><?php echo''.theme_link_accountsett.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Payment_System']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Payment_System.html" style="color:red;"><?php echo''.theme_link_paymentsys.''; ?></a></div><?php } ?>
                                                <div class="latest-twitter-tweett"><a href="-id-Game_Panel.html"><b>Game Panel</b></a></div>
                                                <?php if($mvcore['Vote']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Vote.html"><?php echo''.theme_link_freevote.''; ?></a></div><?php } ?>


                                                <!-- =-=-= Extra Pages For Users ( Contains PHP To Hide Link If Page Disabled In AdminCP ) =-=-= -->
                                                <?php if($mvcore['Hide_Information']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Hide_Information.html"><?php echo''.theme_link_hideiteminfo.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Friend_System']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Friend_System.html"><?php echo''.theme_link_friendsys.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Exchange_System']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Exchange_System.html"><?php echo''.theme_link_exchangesys.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['GM_Buy']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-GM_Buy.html"><?php echo''.theme_link_gmbuy.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Vip_Buy']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Vip_Buy.html"><?php echo''.theme_link_vipbuy.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Lottery_System']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Lottery_System.html"><?php echo''.theme_link_lotterysys.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Warehouse']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Warehouse.html"><?php echo''.theme_link_warehouse.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Castle_Siege_Register']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Castle_Siege_Register.html"><?php echo''.theme_link_caslesiegereg.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Item_Upgrade_System']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Item_Upgrade_System.html"><?php echo''.theme_link_itemupgradesys.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['anc_mob_onoff']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Ancient_Exchange.html"><?php echo''.theme_link_ancexc.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['My_Sponsor']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-My_Sponsor.html"><?php echo''.theme_link_mysponsors.''; ?></a></div><?php } ?>
                                                <?php if($mvcore['Scramble']=='on') { ?><div class="latest-twitter-tweett"><a href="-id-Scramble_Event.html"><?php echo''.theme_link_scrambleevent.''; ?></a></div><?php } ?>
                                                
                                                <!-- =-=-= Admin/GM Panel Buttons ( Secured With PHP ) =-=-= -->
                                                <?php if($_SESSION['admin_panel']=='ok') { ?><div class="latest-twitter-tweett"><a target="_blank" href="-id-admincp-id-Dashboard.html">Admin Panel</a></div><?php } ?>
                                                <?php if($_SESSION['gm_panel']=='ok') { ?><div class="latest-twitter-tweett"><a href="-id-gm_cp-id-GM_Panel.html"><?php echo''.theme_link_gmpanel.''; ?></a></div><?php } ?>
                                                <div class="latest-twitter-tweett"><a href="-id-exitacc.html"><?php echo''.theme_link_logout.''; ?></a></div> <!-- Logout -->
                                            <?php } ?>
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="15px"></td></tr></table>
                                
                                    <div align="center" class="server-time-stl">Server Time: <?php include('system/theme_inc/inc.date.php'); ?> <!-- Server Time Output --></div>
                                
                                <table><tr><td height="15px"></td></tr></table>
                                
                                <div align="center">
                                    <a style="padding-left:3px;padding-right:3px;" target="_blank" href="<?php echo $mvcore['yt_s_url']; ?>"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/youtube.png" width="40px"></a>
                                    <a style="padding-left:3px;padding-right:3px;" target="_blank" href="<?php echo $mvcore['fb_s_url']; ?>"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/facebook.png" width="40px"></a>
                                    <a style="padding-left:3px;padding-right:3px;" target="_blank" href="<?php echo $mvcore['tw_s_url']; ?>"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/twitter.png" width="40px"></a>
                                    <a style="padding-left:3px;padding-right:3px;" target="_blank" href="<?php echo $mvcore['gp_s_url']; ?>"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/googleplus.png" width="40px"></a>
                                    <a style="padding-left:3px;padding-right:3px;" target="_blank" href="<?php echo $mvcore['rss_s_url']; ?>"><img src="/themes/<?php echo $mvcore['theme_dir'];?>/img/rss.png" width="40px"></a>
                                </div>
                                
                                <table><tr><td height="15px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">SERVER STATISTIC</div>
                                        <div style="padding:20px;">
                                            <div class="latest-twitter-tweett">
                                                <table width="100%" align="center" cellpadding="0" cellspacing="0">
                                                    <tr>
                                                        <td style="padding-left:15px;"><b>Game Server</b>:</td>
                                                        <td style="float:right;padding-right:15px;"><?php echo $fn_serverStatus_GS; ?> <!-- Game Server Status Output --></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="latest-twitter-tweett">
                                                <table width="100%" align="center" cellpadding="0" cellspacing="0">
                                                    <tr>
                                                        <td style="padding-left:15px;"><b>Castle Siege Server</b>:</td>
                                                        <td style="float:right;padding-right:15px;"><?php echo $fn_serverStatus_GS2; ?> <!-- Game Server2 Status Output --></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="latest-twitter-tweett">
                                                <table width="100%" align="center" cellpadding="0" cellspacing="0">
                                                    <tr>
                                                        <td style="padding-left:15px;"><b>Join Server</b>:</td>
                                                        <td style="float:right;padding-right:15px;"><?php echo $fn_serverStatus_JS; ?> <!-- Join Server Status Output --></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <div class="latest-twitter-tweett">
                                                <table width="100%" align="center" cellpadding="0" cellspacing="0">
                                                    <tr>
                                                        <td style="padding-left:15px;"><b>Connect Server</b>:</td>
                                                        <td style="float:right;padding-right:15px;"><?php echo $fn_serverStatus_CS; ?> <!-- Connect Server Status Output --></td>
                                                    </tr>
                                                </table>
                                            </div>
                                            <?php include('system/theme_inc/inc.statistic.php'); ?> <!-- Statistics -->
                                            <div align="center">
                                                <form action="" method="POST">
                                                    <select name="mvclangc" class="mvcore-select-main" onchange="this.form.submit()" style="width:260px !important;">
                                                        <option value="eng" <?php if($_SESSION['mvcoreLang']=='eng'){echo'selected';}else{};?>>English</option>
                                                    </select>
                                                </form>
                                            </div>
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table align="center"><tr><td height="30px"><div align="center"> <?php echo $mvcore['ads_spt_300x250']; ?> <!-- Medium Rectangle ( 300 x 250 ) --> </div></td></tr></table>
                                
                                <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">Vote</div>
                                        <div style="padding:20px;">
                                            <?php include('system/vote/vote.php'); ?> <!-- Latest Forum Posts -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">LATEST MARKET ITEMS</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.last_market_items.php'); ?> <!-- Market Latest Items -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="30px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">TOP CHARACTERS</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.top_characters.php'); ?> <!-- Top 10 Characters -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="30px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">TOP GUILDS</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.top_guilds.php'); ?> <!-- Top 10 Guilds -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="30px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">EVENT TIMER</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.event_timer.php'); ?> <!-- Event Timer -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="30px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">LATEST FORUM POSTS</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.forum_latest_posts.php'); ?> <!-- Latest Forum Posts -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                                <table><tr><td height="30px"></td></tr></table>
                            <table width="100%" align="center" border="0" cellpadding="0" cellspacing="0" >
                                <tr>
                                    <td valign="top" style="background-color: #FFF;">
                                        <div style="background-color: #333;height:20px;margin-top:0px;line-height:20px;padding:10px;margin-bottom:0px;font-size:14px;color:#fa5452;font-weight:bold;">LATEST FORUM TOPICS</div>
                                        <div style="padding:20px;">
                                            <?php include('system/theme_inc/inc.forum_latest_topics.php'); ?> <!-- Latest Forum Topics -->
                                        </div>
                                    </td>
                                </tr>
                            </table>
                            
                            <div align="center"> <?php echo $mvcore['ads_spt_300x600']; ?> <!-- Large Skycraper ( 300 x 600 ) --> </div>
                            
                        </td>
                    </tr>
                </table>
            </td>
        </tr>
        <tr><td style="background: url('/themes/<?php echo $mvcore['theme_dir'];?>/img/c_bottom.jpg') no-repeat center top; background-size: 100%; width:100%; height:10px;"></td></tr>
        <tr><td style="height:10px;"></td></tr>
        <tr align="center"><td><?php echo $mvcore['ads_spt_728x90']; ?> <!-- Leaderboard ( 728 x 90 ) --> </td></tr>
        <tr><td style="height:10px;"></td></tr>
        <tr align="left">
            <td style="background: url('/themes/<?php echo $mvcore['theme_dir'];?>/img/footer.jpg') no-repeat center top; background-size: 100%; width:100%; height:45px; font-size:15px;color:#5d6666;padding-left:15px;">
                Copyright &copy; 2015-<?php echo date("Y"); ?> <a href="http://mvcore.lv">MVCore Website <?php echo $MVCoreVersion;?></a>
            </td>
        </tr>
    </table>
    </body>
</html>

**KarLi** · 30-12-16

i think you will have to add code in statistics.php to retrieve new statistics of MuOnlin2 because the code that its in there its only for the default DB (muonline) can't u take and implement another statistics module for ur website?

**m1nd3** · 30-12-16

Have you any suggestions, witch one is easy to try?

**KarLi** · 30-12-16

do u want to make a complete statistics for the muonlin2 or just Players Online count?

complete =
Total Accounts
Total Characters
Total Guilds
Total Game Masters
Players Online
Today Active

for that u will have to dupicate this whole module and then make it fetch statistics from MuOnlin2.

i dont realy know right now how to explain the whole progress cus i am not php/web coder either.. i just know its possible.

**m1nd3** · 30-12-16

I'm thinking about complete module, i'm just didn't know, how make module read from MuOnline2 database

- - - Updated - - -

By the way, from MuOnline2 not reading only "Online" and "Today Active"

- - - Updated - - -

I'm not sure about Online Today, because Online not show :)

- - - Updated - - -

And what is these numbers in red, how it count from sql?

Code:

$sql104 = mssql_query("SELECT count(*) FROM Character WHERE CtlCode = '32'");
$acr5 =mssql_result($sql104, 0, 0);

$sql105 = mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectStat = '1'");
$total['online']=mssql_result($sql105, 0, 0);

$month_today = date("M", time());
$day_today  = date("j", time());
$year_today  = date("Y", time());
$query   =mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectTM LIKE '%".$month_today."%".$day_today."%".$year_today."%' OR DisConnectTM LIKE '%".$month_today."%".$day_today."%".$year_today."%'");
$online_today = mssql_result($query, 0, 0);
$sql = mssql_query("SELECT count(*) FROM ".$mvcore_medb_s." WHERE ConnectStat = 1");

**m1nd3** · 01-01-17

now i'm 100% sure, the problem is ODBC file, i try to create manually like in post https://www.youtube.com/watch?v=fs-7CuXzj08 but no luck, because some entry is for both servers, so then asking me to replace, if i replacing then "Ranking" show in MuOnlin2 website. For example :

Code:

LOGIN
AccountDB
LocalServer
MatchDB
MU2003_EVENT_DB
MuEvent
MuRanking
Ranking
RMDB_CONNECTLOG
USELOG
WPaymentDB

Any idea, how to change it for MuOnlin2? And it's the same in ODBC.reg some lines isn't way how to change for MuOnlin2. Maybe some one,who have run two servers will share this secret with me.

2 IA Julia servers on 1 machine

Thread Tools

Search Thread

2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Re: 2 IA Julia servers on 1 machine

Advertisement