Someone know how to solve change online hours in mucore premium,2.2.0 module aoh_canj_horas.php...all players have 0 online hours..
I use IGCN season server files
picture Memb_info
picture memb_stat
This is the php code from module aoh_canje_horas.php
<?
$config00 = simplexml_load_file('engine/config_mods/mu_coins_settings.xml');
$config2 = simplexml_load_file('engine/config_mods/aoh_canje_horas.xml');
$active = trim($config2->active);
if($CoD3e4rN0lCl_xF2S3A52CvZ !='x"CwFhks26N|*zgf93NS'){
echo msg('0','Necesitas MuCore Premium para utilizar este Modulo');
}elseif($active == '0'){
echo msg('0',text_sorry_feature_disabled);
}else{
if(isset($_GET['quest'])){
echo '<div style="margin-top: 10px;">';
if(empty($_GET['quest'])){
header('Location: '.$core_run_script.'');
exit();
}else{
if(account_online($user_auth_id) === true){
echo msg('0',text_clearinventory_t1);
}else{
$CheckUSer_Data = $core_db->Execute("Select OnlineHours From MEMB_STAT WHERE memb___id = ?", array($user_auth_id));
$CheckUSer_Data2 = $core_db->Execute("Select AOH_Horas_Canje From MEMB_INFO WHERE memb___id = ?", array($user_auth_id));
$DiferenciaHoras = $CheckUSer_Data->fields[0] - $CheckUSer_Data2->fields[0];
if($DiferenciaHoras < 1) {
echo msg('0','No tienes suficientes Horas Online para participar');
}else{
//Quest 1
if ($_GET['quest']==1){
$PuntosNuevos = $DiferenciaHoras * $config2->credits_mount1;
$querymod1 = $core_db->Execute("UPDATE MEMB_INFO SET AOH_Horas_Canje = AOH_Horas_Canje + ? WHERE memb___id = ?", array($DiferenciaHoras, $user_auth_id));
$querymod2 = $core_db->Execute("UPDATE ".$config00->credits_table." SET ".$config00->credits_column." = ".$config00->credits_column." + ? WHERE ".$config00->user_column." = ?", array($PuntosNuevos, $user_auth_id));
echo msg('1','Felicidades has Ganado '.$PuntosNuevos.' de '.$config00->money_name1.'');
}
//Quest 2
if ($_GET['quest']==2){
$PuntosNuevos = $DiferenciaHoras * $config2->credits_mount2;
$querymod1 = $core_db->Execute("UPDATE MEMB_INFO SET AOH_Horas_Canje = AOH_Horas_Canje + ? WHERE memb___id = ?", array($DiferenciaHoras, $user_auth_id));
$querymod2 = $core_db->Execute("UPDATE ".$config00->credits2_table." SET ".$config00->credits2_column." = ".$config00->credits2_column." + ? WHERE ".$config00->user2_column." = ?", array($PuntosNuevos, $user_auth_id));
echo msg('1','Felicidades has Ganado '.$PuntosNuevos.' de '.$config00->money_name2.'');
}
}
}
}
echo '</div>';
}
echo '
<div class="panel panel-info">
<div class="panel-heading">
<h3 class="panel-title">Especificaciones</h3>
</div>
<div class="panel-body panel-fix">
<table class="table">
<thead>
<tr>
<th>Quest 1</th>
<th>Quest 2</th>
</tr>
</thead>
<tbody>
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td>Premio: '.$config2->credits_mount1.' de <b>'.$config00->money_name1.'</b> por Hora Online</td>
<td>Premio: '.$config2->credits_mount2.' de <b>'.$config00->money_name2.'</b> por Hora Online</td>
</tr>
</tbody>
</table>
</div>
</div>
';
?>
<?
//Creando las columnas si no existen
$chekHorasCanje = $core_db->Execute("Select top 1 AOH_Horas_Canje from MEMB_INFO");
if (!$chekHorasCanje) {
// Si no encontramos la columna, la agregamos
$core_db->Execute("alter table MEMB_INFO add AOH_Horas_Canje int not null default 0");
echo msg('1','Columna Creada Correctamente');
}
?>
<div class="panel panel-default panel-body-cont">
<div class="panel-body panel-fix">
<table class="table-fix">
<?
$queryHorasUser = $core_db->Execute("Select OnlineHours From MEMB_STAT WHERE memb___id = ?", array($user_auth_id));
$queryHorasUser2 = $core_db->Execute("Select AOH_Horas_Canje From MEMB_INFO WHERE memb___id = ?", array($user_auth_id));
$HorasSinCanje = $queryHorasUser->fields[0]-$queryHorasUser2->fields[0];
if ($HorasSinCanje<0){
$HorasSinCanje=0;
}
?>
<tr>
<td></td>
<td></td>
<td>
Total de Horas Online: <?=$queryHorasUser->fields[0];?><br>
Horas sin Canjear: <?=$HorasSinCanje;?><br>
</td>
</tr>
<tr>
<td width="66" rowspan="2"></td>
<td align="left" class="iR_name" width="100"></td>
<td rowspan="2">
<input type="button" class="btn btn-primary btn-sm" value="Hacer Quest 1" onclick="ask_url('Seguro que desea Continuar con la Quest 1?','<?=$core_run_script;?>&quest=1');">
<input type="button" class="btn btn-warning btn-sm" value="Hacer Quest 2" onclick="ask_url('Seguro que desea Continuar con la Quest 2?','<?=$core_run_script;?>&quest=2');">
</td>
</tr>
<tr>
<td algin="left"></td>
</tr>
</table>
</div>
</div>
<?
}
?>