MuCore Modules REQ

Results 1 to 10 of 10
  1. 22-12-12 #1
    S37uP!Update
    wWw.F403.OrG S37uP!Update is offline
    MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,304Posts

    MuCore Modules REQ

    Hello guys, i've been searching around the forum for this MuCore modules and i couldn't find them.

    Online Players (To show wich player is online,not how many players are online)
    And i have a problem with the Exchange Online Hours module, instead of showing the hours to hours it show me hours to minutes and i can't receive the reward because the hours are showed up as minutes...
    And one more is Top Online Players, this module doesn't show nothing, i saw on other ppl this module is working...but idk why not working on me.
    Cheers

    This is the script Exchange Online Hours:
    PHP Code:
    <?php
    define    ('phrase_chngtime',"Puedes cambiar la cantidad de horas jugadas por");
    define('phrase_chng1',"Horas online ");
    define('phrase_chng2',"Recompensa ");
        

    $Otime['bonus']                = 'pcpoints';             // zen / pcpoints / mucoins
    $Otime['rate']                = 2;                    // [Zen/PCPoints/MuCoins] * hora

    if ($Otime['bonus'] == 'zen'){
            $Currency['name'] = 'Zen';
    }elseif (    $Otime['bonus'] == 'pcpoints'){
            $Currency['name'] = 'PC Points';
    }elseif (    $Otime['bonus'] == 'mucoins'){
            $Currency['name'] = 'Mu Coins';
    }

    function     Query($query) {
                global     $Query_Count;
                    $Query_Count = $Query_Count + 1;
                return     mssql_query($query);
            }
            
                $minute_reslut    = $core_db->Execute("SELECT OnlineHours from MEMB_STAT where memb___id='$user_auth_id'");
                $minute_row        = $minute_reslut->fetchRow();

            if((    $minute_row[0] % 60) > 0) {
                    $minutes    = ($minute_row[0] % 60);
                    $hours        = (($minute_row[0] - $minutes) / 60);
            }
            else {
                    $hours        = '0';
                if(    $minute_row[0] > 0)    {    $minutes        = $minute_row[0];                }
                else                    {        $minutes        = '0';                            }
            }

            if(    $hours > 0)                {    $add_credits    = ($hours * $Otime['rate']);    }
            else                        {        $add_credits    = '0';                            }

            if (    $Otime['bonus'] == 'zen') {
                    $update_money    = "UPDATE dbo.Warehouse SET Money = Money + $add_credits WHERE AccountId = '$user_auth_id'";
            }
            elseif (    $Otime['bonus'] == 'pcpoints') {
                    $update_money = "UPDATE dbo.Character SET SCFPCPoints = SCFPCPoints + '$add_credits'  WHERE AccountID = '$user_auth_id'";
            }
            elseif (    $Otime['bonus'] == 'mucoins') {
                    $update_money    = "UPDATE dbo.MEMB_CREDITS SET credits = credits + '$add_credits' WHERE memb___id = '$user_auth_id'";
            }
            else {
                    $update_money    = "";
            }
                $bonus = $Currency['name'];
            
            if(isset(    $_POST['change']))    {
                if(    $hours > 0) {
                        $sql_online_check = mssql_query("SELECT * FROM MEMB_STAT WHERE ConnectStat=0 AND memb___id='$user_auth_id'");
                        $online_check = mssql_num_rows($sql_online_check);
                        if (    $online_check <= 0){ 
                            echo         msg('0','Tu personaje debe estar desconectado del juego.');
                        }else{
                                $delminutes        = $hours * 60;
                                $removeotime    = $core_db->Execute("UPDATE MEMB_STAT SET OnlineHours = OnlineHours - $delminutes WHERE memb___id='$user_auth_id'");
                                $addmoney        = $core_db->Execute($update_money);
                            echo        msg('1',"Las horas online han sido cambiadas correctamente.");
                            }
                }
                else {
                    echo        msg('0',"Horas online insuficientes para ser cambiadas.");
                }
            }

    ?>

        <table width="100%">
            <tr>
                <td class="text_default" style='width:95%; text-align:justify; padding:5px 10px 5px 10px; border:1px dashed #B9955B;'>
                <?php echo phrase_chngtime;?> <? echo $bonus; ?>.
                </td>
            </tr>
        </table>
        <br>

        <table align="center" border="0" cellpadding="2" cellspacing="2" style="border:1px solid #B9955B; font-family:Tahoma; color:#9d8666; font-size:11px;">
            <tr class="bgcol1">
                <td class="text_default" align="right" width="50%"><b><?php echo phrase_chng1;?>:</b></td>
                <td class="text_default"><?php echo $hours." h ".$minutes." m";?></td>
            </tr>
            <tr>
                <td class="text_default" align="right" width="50%"><b><?php echo phrase_chng2;?>:</b></td>
                <td class="text_default"><?php echo $add_credits." ".$bonus; ?></td>
            </tr>    
        </table>
        <form method="post" action="" name="changetime_start">
        <table align="center">
        <br>
            <tr>
                <td>
                    <input type="hidden" name="change" value="1">
                    <input type="button" class="submit-form" onclick="this.disabled=true; this.value='Cargando...'; changetime_start.submit();" value="Obtener <? echo $Currency['name']; ?>">
                </td>
            </tr>
        </table>
        </form>
    Top Online Players:
    PHP Code:
    <? 
    $i     = 0;
    $status = mssql_query("SELECT DISTINCT 
    AccountCharacter.GameIDC, 
    memb_stat.ServerName, memb_stat.ServerName, 
    memb_stat.IP, memb_stat.ConnectTM, 
    memb_stat.DisConnectTM 
    from 
    Memb_stat 
    join 
    AccountCharacter 
    on 
    Memb_stat.memb___id = AccountCharacter.ID 
    collate Latin1_general_CI_AS 
    where Memb_stat.connectstat = 1"    );
    ?>

    <br>
    <table width="100%" align="center" cellpadding="2" cellspacing="0">
      <tbody>
        <tr>
          <td><table border="0" cellpadding="1" cellspacing="1" width="100%">
            <tbody>
              <tr>
                <td height="25"   align="center" background="http://forum.ragezone.com/images/li2x.png">#</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Name</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Class</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Mapa</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Reset</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Lvl</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">On</td>
                <td  align="center" background="http://forum.ragezone.com/images/li2x.png">Pais</td>
              </tr>
    <?php
    $i     = 0;
    while(    $row=mssql_fetch_array($status)) {
                    $dados_query = mssql_query("SELECT * FROM Character WHERE Name='$row[GameIDC]'");
                    $dados = mssql_fetch_array($dados_query);
                    $rst_query = mssql_query("SELECT * FROM Character WHERE Name='$row[GameIDC]'");
                    $rst = mssql_fetch_array($rst_query);
                    $membstat_query = mssql_query("SELECT * FROM MEMB_STAT WHERE memb___id='$dados[AccountID]'");
                    $membstat = mssql_fetch_array($membstat_query);
                    $pais_query = mssql_query("SELECT vip, country FROM MEMB_INFO WHERE memb___id='$dados[AccountID]'");
                    $row2 = mssql_fetch_array($pais_query);
                    $zebe1 = mssql_query("Select ConnectStat from MEMB_STAT where memb___id='$dados[AccountID]'");
                    $zebe2 = mssql_fetch_array($zebe1);
                    $zo1 = mssql_query("Select MapPosX,MapPosY,Class from Character where Name='$row[GameIDC]'");
                    $zo2 = mssql_fetch_row($zo1);

                    $i = $i+1;    
                if(    $zebe2[0] == 0){ $zebe2[0] ='<font color=#FF0000 size=1><b>OFF</b></font>'; }
                if(    $zebe2[0] == 1){ $zebe2[0] ='<font color=#009900 size=1><b>ON</b></font>'; }
                if(    $zo2[2] == 0){ $zo2[2] ='<img src=images/class/DW.jpg>';}
                if(    $zo2[2] == 1){ $zo2[2] ='<img src=images/class/SM.jpg>';}
                if(    $zo2[2] == 16){ $zo2[2] ='<img src=images/class/DK.jpg>';}
                if(    $zo2[2] == 17){ $zo2[2] ='<img src=images/class/BK.jpg>';}
                if(    $zo2[2] == 32){ $zo2[2] ='<img src=images/class/FE.jpg>';}
                if(    $zo2[2] == 33){ $zo2[2] ='<img src=images/class/ME.jpg>';}
                if(    $zo2[2] == 80){ $zo2[2] ='<img src=images/class/SU.jpg>';}
                if(    $zo2[2] == 81){ $zo2[2] ='<img src=images/class/BS.jpg>';}
                if(    $zo2[2] == 48){ $zo2[2] ='<img src=images/class/MG.jpg>';}
                if(    $zo2[2] == 49){ $zo2[2] ='<img src=images/class/DM.jpg>';}
                if(    $zo2[2] == 64){ $zo2[2] ='<img src=images/class/DL.jpg>';}
                if(    $zo2[2] == 2){ $zo2[2] ='<img src=images/class/GM.jpg>';}
                if(    $zo2[2] == 18){ $zo2[2] ='<img src=images/class/BM.jpg>';}
                if(    $zo2[2] == 34){ $zo2[2] ='<img src=images/class/HE.jpg>';}
                if(    $zo2[2] == 50){ $zo2[2] ='<img src=images/class/DM.jpg>';}
                if(    $zo2[2] == 66){ $zo2[2] ='<img src=images/class/LE.jpg>';}
                if(    $zo2[2] == 65){ $zo2[2] ='<img src=images/class/LE.jpg>';}
                if(    $zo2[2] == 82){ $zo2[2] ='<img src=images/class/DS.jpg>';}
                if(    $zo2[2] == 96){ $zo2[2] ='<img src=images/class/rf.jpg>';}
                if(    $zo2[2] == 98){ $zo2[2] ='<img src=images/class/fm.jpg>';}
                
                if(    $row2[1] == 'Argentina'){ $row2[1] ='<img src=images/flags/Argentina.png>';}
                if(    $row2[1] == '9'){ $row2[1] ='<img src=images/flags/Argentina.png>';}
                if(    $row2[1] == 'Alemania'){ $row2[1] ='<img src=images/flags/Alemania.png>';}
                if(    $row2[1] == 'Bolivia'){ $row2[1] ='<img src=images/flags/Bolivia.png>';}
                if(    $row2[1] == '25'){ $row2[1] ='<img src=images/flags/Bolivia.png>';}
                if(    $row2[1] == 'Brazil'){ $row2[1] ='<img src=images/flags/Brazil.png>';}
                if(    $row2[1] == 'Canada'){ $row2[1] ='<img src=images/flags/Canada.png>';}
                if(    $row2[1] == 'Chile'){ $row2[1] ='<img src=images/flags/Chile.png>';}
                if(    $row2[1] == '39'){ $row2[1] ='<img src=images/flags/Chile.png>';}
                if(    $row2[1] == 'China'){ $row2[1] ='<img src=images/flags/China.png>';}
                if(    $row2[1] == 'Colombia'){ $row2[1] ='<img src=images/flags/Colombia.png>';}
                if(    $row2[1] == '42'){ $row2[1] ='<img src=images/flags/Colombia.png>';}
                if(    $row2[1] == 'Croacia'){ $row2[1] ='<img src=images/flags/Croacia.png>';}
                if(    $row2[1] == 'Ecuador'){ $row2[1] ='<img src=images/flags/Ecuador.png>';}
                if(    $row2[1] == 'Escocia'){ $row2[1] ='<img src=images/flags/Escocia.png>';}
                if(    $row2[1] == 'Espana'){ $row2[1] ='<img src=images/flags/Espana.png>';}
                if(    $row2[1] == '184'){ $row2[1] ='<img src=images/flags/Espana.png>';}
                if(    $row2[1] == 'Francia'){ $row2[1] ='<img src=images/flags/Francia.png>';}
                if(    $row2[1] == 'Gales'){ $row2[1] ='<img src=images/flags/Gales.png>';}
                if(    $row2[1] == 'Grecia'){ $row2[1] ='<img src=images/flags/Grecia.png>';}
                if(    $row2[1] == 'Guatemala'){ $row2[1] ='<img src=images/flags/Guatemala.png>';}
                if(    $row2[1] == 'Holanda'){ $row2[1] ='<img src=images/flags/Holanda.png>';}
                if(    $row2[1] == 'Honduras'){ $row2[1] ='<img src=images/flags/Honduras.png>';}
                if(    $row2[1] == 'India'){ $row2[1] ='<img src=images/flags/India.png>';}
                if(    $row2[1] == 'Inglaterra'){ $row2[1] ='<img src=images/flags/Inglaterra.png>';}
                if(    $row2[1] == 'Italia'){ $row2[1] ='<img src=images/flags/Italia.png>';}
                if(    $row2[1] == 'Jamaica'){ $row2[1] ='<img src=images/flags/Jamaica.png>';}
                if(    $row2[1] == 'Japon'){ $row2[1] ='<img src=images/flags/Japon.png>';}
                if(    $row2[1] == 'Kenia'){ $row2[1] ='<img src=images/flags/Kenia.png>';}
                if(    $row2[1] == 'Korea'){ $row2[1] ='<img src=images/flags/Korea.png>';}
                if(    $row2[1] == 'Mexico'){ $row2[1] ='<img src=images/flags/Mexico.png>';}
                if(    $row2[1] == '131'){ $row2[1] ='<img src=images/flags/Mexico.png>';}
                if(    $row2[1] == 'Nicaragua'){ $row2[1] ='<img src=images/flags/Nicaragua.png>';}
                if(    $row2[1] == 'Nigeria'){ $row2[1] ='<img src=images/flags/Nigeria.png>';}
                if(    $row2[1] == 'Noruega'){ $row2[1] ='<img src=images/flags/Noruega.png>';}
                if(    $row2[1] == 'Panama'){ $row2[1] ='<img src=images/flags/Panama.png>';}
                if(    $row2[1] == '154'){ $row2[1] ='<img src=images/flags/Panama.png>';}
                if(    $row2[1] == 'Paraguay'){ $row2[1] ='<img src=images/flags/Paraguay.png>';}
                if(    $row2[1] == '156'){ $row2[1] ='<img src=images/flags/Paraguay.png>';}
                if(    $row2[1] == ''){ $row2[1] ='<img src=images/flags/Peru.png>';}
                if(    $row2[1] == '157'){ $row2[1] ='<img src=images/flags/Peru.png>';}
                if(    $row2[1] == 'Peru'){ $row2[1] ='<img src=images/flags/Peru.png>';}
                if(    $row2[1] == 'Polonia'){ $row2[1] ='<img src=images/flags/Polonia.png>';}
                if(    $row2[1] == 'Portugal'){ $row2[1] ='<img src=images/flags/Portugal.png>';}
                if(    $row2[1] == 'Puerto'){ $row2[1] ='<img src=images/flags/Puerto.png>';}
                if(    $row2[1] == 'Rusia'){ $row2[1] ='<img src=images/flags/Rusia.png>';}
                if(    $row2[1] == 'Salvador'){ $row2[1] ='<img src=images/flags/Salvador.png>';}
                if(    $row2[1] == 'Turquia'){ $row2[1] ='<img src=images/flags/Turquia.png>';}
                if(    $row2[1] == 'Ucrania'){ $row2[1] ='<img src=images/flags/Ucrania.png>';}
                if(    $row2[1] == 'Uruguay'){ $row2[1] ='<img src=images/flags/Uruguay.png>';}
                if(    $row2[1] == '208'){ $row2[1] ='<img src=images/flags/Uruguay.png>';}
                if(    $row2[1] == 'USA'){ $row2[1] ='<img src=images/flags/USA.png>';}
                if(    $row2[1] == 'Venezuela'){ $row2[1] ='<img src=images/flags/Venezuela.png>';}            
                if(    $row2[1] == '212'){ $row2[1] ='<img src=images/flags/Venezuela.png>';}            
                if(    $row2[1] == '158'){ $row2[1] ='<img src=images/flags/Banderas/Philippines.gif>';}            
                
                
                
                if (    $dados[MapNumber] == 0) {$dados[MapNumber] = 'Lorencia';}
                if (    $dados[MapNumber] == 1) {$dados[MapNumber] = 'Dungeon';}
                if (    $dados[MapNumber] == 2) {$dados[MapNumber] = 'Devias';}
                if (    $dados[MapNumber] == 3) {$dados[MapNumber] = 'Noria';}
                if (    $dados[MapNumber] == 4) {$dados[MapNumber] = 'Lost Tower';}
                if (    $dados[MapNumber] == 6) {$dados[MapNumber] = 'Arena';}
                if (    $dados[MapNumber] == 7) {$dados[MapNumber] = 'Atlans';}
                if (    $dados[MapNumber] == 8) {$dados[MapNumber] = 'Tarkan';}
                if (    $dados[MapNumber] == 9) {$dados[MapNumber] = 'Devil Square';}
                if (    $dados[MapNumber] == 10) {$dados[MapNumber] = 'Icarus';}
                if (    $dados[MapNumber] == 11) {$dados[MapNumber] = 'Blood Castle I';}
                if (    $dados[MapNumber] == 12) {$dados[MapNumber] = 'Blood Castle II';}
                if (    $dados[MapNumber] == 13) {$dados[MapNumber] = 'Blood Castle III';}
                if (    $dados[MapNumber] == 14) {$dados[MapNumber] = 'Blood Castle IV';}
                if (    $dados[MapNumber] == 15) {$dados[MapNumber] = 'Blood Castle V';}
                if (    $dados[MapNumber] == 16) {$dados[MapNumber] = 'Blood Castle VI';}
                if (    $dados[MapNumber] == 17) {$dados[MapNumber] = 'Blood Castle VII';}
                if (    $dados[MapNumber] == 18) {$dados[MapNumber] = 'Chaos Castle I';}
                if (    $dados[MapNumber] == 19) {$dados[MapNumber] = 'Chaos Castle II';}
                if (    $dados[MapNumber] == 20) {$dados[MapNumber] = 'Chaos Castle III';}
                if (    $dados[MapNumber] == 21) {$dados[MapNumber] = 'Chaos Castle IV';}
                if (    $dados[MapNumber] == 22) {$dados[MapNumber] = 'Chaos Castle V';}
                if (    $dados[MapNumber] == 23) {$dados[MapNumber] = 'Chaos Castle VI';}
                if (    $dados[MapNumber] == 24) {$dados[MapNumber] = 'Kalima I';}
                if (    $dados[MapNumber] == 25) {$dados[MapNumber] = 'Kalima II';}
                if (    $dados[MapNumber] == 26) {$dados[MapNumber] = 'Kalima III';}
                if (    $dados[MapNumber] == 27) {$dados[MapNumber] = 'Kalima IV';}
                if (    $dados[MapNumber] == 28) {$dados[MapNumber] = 'Kalima V';}
                if (    $dados[MapNumber] == 29) {$dados[MapNumber] = 'Kalima VI';}
                if (    $dados[MapNumber] == 30) {$dados[MapNumber] = 'Valley Of Loren';}
                if (    $dados[MapNumber] == 31) {$dados[MapNumber] = 'Lands Of Trial';}
                if (    $dados[MapNumber] == 32) {$dados[MapNumber] = 'Devil Square';}
                if (    $dados[MapNumber] == 33) {$dados[MapNumber] = 'Aida';}
                if (    $dados[MapNumber] == 34) {$dados[MapNumber] = 'CryWolf';}
                if (    $dados[MapNumber] == 36) {$dados[MapNumber] = 'Kalima VII';}
                if (    $dados[MapNumber] == 37) {$dados[MapNumber] = 'Kantru';}
                if (    $dados[MapNumber] == 38) {$dados[MapNumber] = 'Kantru Ruins';}
                if (    $dados[MapNumber] == 39) {$dados[MapNumber] = 'Kantru Tower';}
                if (    $dados[MapNumber] == 40) {$dados[MapNumber] = 'Silent Map';}
                if (    $dados[MapNumber] == 41) {$dados[MapNumber] = 'Barrakas';}
                if (    $dados[MapNumber] == 42) {$dados[MapNumber] = 'Refuge';}
                if (    $dados[MapNumber] == 45) {$dados[MapNumber] = 'Illusion Temple I';}
                if (    $dados[MapNumber] == 46) {$dados[MapNumber] = 'Illusion Temple II';}
                if (    $dados[MapNumber] == 47) {$dados[MapNumber] = 'Illusion Temple III';}
                if (    $dados[MapNumber] == 48) {$dados[MapNumber] = 'Illusion Temple IV';}
                if (    $dados[MapNumber] == 49) {$dados[MapNumber] = 'Illusion Temple V';}
                if (    $dados[MapNumber] == 50) {$dados[MapNumber] = 'Illusion Temple VI';}
                if (    $dados[MapNumber] == 51) {$dados[MapNumber] = 'Elbeland';}
                if (    $dados[MapNumber] == 52) {$dados[MapNumber] = 'Blood Castle VIII';}
                if (    $dados[MapNumber] == 53) {$dados[MapNumber] = 'Chaos Castle VII';}
                if (    $dados[MapNumber] == 56) {$dados[MapNumber] = 'Swamp Of Calmness';}
                if (    $dados[MapNumber] == 57) {$dados[MapNumber] = 'Raklion';}
                if (    $dados[MapNumber] == 58) {$dados[MapNumber] = 'Raklion II';}
                if (    $dados[MapNumber] == 62) {$dados[MapNumber] = 'Santa Town';}
                if (    $dados[MapNumber] == 63) {$dados[MapNumber] = 'Vulcan';}            
                if (    $dados[MapNumber] == 64) {$dados[MapNumber] = 'Vulcan';}
                if (    $dados[MapNumber] == 79) {$dados[MapNumber] = 'Loren Market';}
                if (    $dados[MapNumber] == 80) {$dados[MapNumber] = 'Kalrutan';}
                

    echo    "

            <tr>
              <td  background='images/dentro.png' align='center'>    $i</td>
              <td  background='images/dentro.png' align='center'>    $row[0]</td>
              <td  background='images/dentro.png' align='center'>    $zo2[2]</td>
              <td  background='images/dentro.png' align='center'>    $dados[MapNumber]</td>
              <td  background='images/li2x.png' align='center'>    $rst[37]</td>
                <td  background='images/dentro.png' align='center'>    $rst[2]</td>
                <td  background='images/dentro.png' align='center'>    $zebe2[0]</td>
              <td  background='images/dentro.png' align='center'>    $row2[1]</td>          
            </tr>
     
              "    ;;            }
    ?>     
            </tbody>
          </table></td>
        </tr>
      </tbody>
    </table>
    <br>
    Edit: I already tryed to give them access to SQL from ADD PAGE in MuCore but nothing happen...
    Last edited by S37uP!Update; 22-12-12 at 05:12 AM.
  2. Check out our sponsor
    MuCore Modules REQ
  3. 22-12-12 #2
    ScriptKid
    Am i? ScriptKid is offline
    MemberRank
    Oct 2006 Join Date
    $Location="??";Location
    1,810Posts

    Re: MuCore Modules REQ

    see if your connection is MSSQL or ODBC
  4. 22-12-12 #3
    S37uP!Update
    wWw.F403.OrG S37uP!Update is offline
    MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,304Posts

    Re: MuCore Modules REQ

    Well, Top Online Players solved, i changed from ODBC to MSSQL connection from config.php but about the exchange hours in credits...the problem is same...
  5. 22-12-12 #4
    varcush
    Enthusiast varcush is offline
    MemberRank
    Jun 2008 Join Date
    <?=$Romania;?>Location
    45Posts

    Re: MuCore Modules REQ

    I think the procedure wz_disconnect_member from MuOnline.dbo must be in mi (minutes) not hours
  6. 22-12-12 #5
    S37uP!Update
    wWw.F403.OrG S37uP!Update is offline
    MemberRank
    Oct 2008 Join Date
    F403.ORGLocation
    1,304Posts

    Re: MuCore Modules REQ

    can you tell me how can i do that?
  7. 23-12-12 #6
    varcush
    Enthusiast varcush is offline
    MemberRank
    Jun 2008 Join Date
    <?=$Romania;?>Location
    45Posts

    Re: MuCore Modules REQ

    Go to SQL Server Enterprise -> Local -> MuOnline -> Stored Procedures -> Search for WZ_DISCONNECT_MEMB

    Double click on WZ_DISCONNECT_MEMB

    Search for line:
    SET DisConnectTM = (getdate()), connectstat = 0, OnlineHours = OnlineHours+(DATEDIFF(mi,ConnectTM,getdate())) WHERE memb___id
    make sure highlighted mi shows there
  8. 23-12-12 #7
    daezugun
    Newbie daezugun is offline
    MemberRank
    Feb 2011 Join Date
    127.0.0.1Location
    787Posts

    Re: MuCore Modules REQ

    Quote Originally Posted by varcush View Post
    Go to SQL Server Enterprise -> Local -> MuOnline -> Stored Procedures -> Search for WZ_DISCONNECT_MEMB

    Double click on WZ_DISCONNECT_MEMB

    Search for line:


    make sure highlighted mi shows there
    where to put that php script of Exchange Online Hours?
    i want that one too to test it and can you give a full script in WZ_DISCONNECT_MEMB too?
  9. 23-12-12 #8
    varcush
    Enthusiast varcush is offline
    MemberRank
    Jun 2008 Join Date
    <?=$Romania;?>Location
    45Posts

    Re: MuCore Modules REQ

    Whole WZ_DISCONNECT_MEMB

    ALTER PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]

    @uid varchar(20)
    AS
    Begin

    BEGIN TRANSACTION

    SET NOCOUNT ON

    IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)
    WHERE memb___id = @uid )
    Begin
    UPDATE MEMB_STAT
    SET DisConnectTM = (getdate()), connectstat = 0, OnlineHours = OnlineHours+(DATEDIFF(mi,ConnectTM,getdate())) WHERE memb___id = @uid
    End
    ELSE
    Begin
    INSERT INTO MEMB_STAT ( memb___id,DisConnectTM,connectstat,OnlineHours) valueS (
    @uid,
    (getdate()),
    0,
    0
    )
    End


    IF(@@Error <> 0 )
    ROLLBACK TRANSACTION
    ELSE
    COMMIT TRANSACTION

    SET NOCOUNT OFF
    End
  10. 23-12-12 #9
    daezugun
    Newbie daezugun is offline
    MemberRank
    Feb 2011 Join Date
    127.0.0.1Location
    787Posts

    Re: MuCore Modules REQ

    Quote Originally Posted by varcush View Post
    Whole WZ_DISCONNECT_MEMB
    Thank you..

    and where do i put that PHP "script Exchange Online Hours" above in order to work?
  11. 23-12-12 #10
    varcush
    Enthusiast varcush is offline
    MemberRank
    Jun 2008 Join Date
    <?=$Romania;?>Location
    45Posts

    Re: MuCore Modules REQ

    Quote Originally Posted by varcush View Post
    Go to SQL Server Enterprise -> Local -> MuOnline -> Stored Procedures -> Search for WZ_DISCONNECT_MEMB

    Double click on WZ_DISCONNECT_MEMB

    Search for line:


    make sure highlighted mi shows there

    this is not php script

    make sure you have made exactly steps


« Previous Thread | Next Thread »

Advertisement