Help to create Script for Active in 24H in mucore

Results 1 to 8 of 8
  1. #1
    Apprentice silviosinger is offline
    MemberRank
    Aug 2013 Join Date
    13Posts

    Help to create Script for Active in 24H in mucore

    Hi comunnity i need to create a module to read the active number accounts in last 24 hours plis help me to create. like this





    Last edited by silviosinger; 29-09-14 at 05:34 AM.


  2. #2
    Alpha Member 2009x2014 is offline
    MemberRank
    Dec 2009 Join Date
    2,765Posts

    Re: Help to create Script for Active in 24H in mucore

    No need module just single query & add result in template html.

    PHP Code:
    SELECT COUNT( * ) as online_last_24hour From MEMB_STAT Where DisConnectTM >= DATEADD(hour, -24GETDATE()) 
    Last edited by 2009x2014; 29-09-14 at 06:11 PM.

  3. #3
    Apprentice silviosinger is offline
    MemberRank
    Aug 2013 Join Date
    13Posts

    Re: Help to create Script for Active in 24H in mucore

    How i add the result in my template bro ??

  4. #4
    Alpha Member 2009x2014 is offline
    MemberRank
    Dec 2009 Join Date
    2,765Posts

    Re: Help to create Script for Active in 24H in mucore

    Quote Originally Posted by silviosinger View Post
    How i add the result in my template bro ??
    Best would be if you tell what cms you use -> upload full template & show where you want to display last 24 hour

  5. #5
    Apprentice silviosinger is offline
    MemberRank
    Aug 2013 Join Date
    13Posts

    Re: Help to create Script for Active in 24H in mucore

    I use Mucore 1.08 and my template is crystal i put here ;) https://mega.co.nz/#!HMUHDZID!tyRXyf...DYBv5eZXNvduxc

  6. #6
    Alpha Member 2009x2014 is offline
    MemberRank
    Dec 2009 Join Date
    2,765Posts

    Re: Help to create Script for Active in 24H in mucore

    Quote Originally Posted by silviosinger View Post
    I use Mucore 1.08 and my template is crystal i put here ;) https://mega.co.nz/#!HMUHDZID!tyRXyf...DYBv5eZXNvduxc
    Sure it will be

    PHP Code:
    $core_db2->Execute("SELECT COUNT( * ) From MEMB_STAT Where DisConnectTM >= DATEADD(hour, -24, GETDATE())"); 
    Added to your index.php -> replace & test :)

    Download
    https://www.sendspace.com/file/x8tgmq

  7. #7
    Account Upgraded | Title Enabled! cripssy is offline
    MemberRank
    Jun 2010 Join Date
    467Posts

    Re: Help to create Script for Active in 24H in mucore

    plss add it on immortal templates

  8. #8

    Re: Help to create Script for Active in 24H in mucore

    make it pls for linksfire template..



Advertisement