Help! What happens here in the last 24 hours

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
    #1

    Help! What happens here in the last 24 hours

    Hello friends, I have this code in the file index.pgp, what happened in the last 24 hours
    PHP Code:
    echo "<p>";
            //echo "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
            $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));
        echo     "<a href=\"lists.php?action=members&amp;sid=$sid\">»Members($norm[0])</a><br/>";
            $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE sex='M'")); 
    and
    PHP Code:
    else if($action=="l24")
    {
          $mmsg = htmlspecialchars(getsetmood(getuid_sid($sid)));
            addonline(getuid_sid($sid),"Statistics ($mmsg)","");
        echo     "<head>";
        echo     "<title>Statistiche</title>";
        echo     "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
        echo     "</head>";
        echo     "<body>";
        echo     "<p>";
            /////
            echo "What happened to the $ sitename in the last 24 hours<br/><br/>";
            $tm24 = time() - (24*60*60);
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE lastact>'".$tm24."'"));
        echo     "Members active: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE regdate>'".$tm24."'"));
        echo     "Members Registered: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_blogs WHERE bgdate>'".$tm24."'"));
        echo     "Blogs Created: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE joined>'".$tm24."' AND accepted='1'"));
        echo     "Members who have joined the Clubs: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubs WHERE created>'".$tm24."'"));
        echo     "Clubs Created: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE reqdt>'".$tm24."' AND agreed='1'"));
        echo     "Friends Added: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_gbook WHERE dtime>'".$tm24."'"));
        echo     "Guestbooks writings: <b>$aut[0]</b><br/>";
        if(    ismod(getuid_sid($sid))){
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog WHERE actdt>'".$tm24."'"));
        echo     "ModLog Action: <b>$aut[0]</b><br/>";
      }
          $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_polls WHERE pdt>'".$tm24."'"));
        echo     "Polls Added: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE dtpost>'".$tm24."'"));
        echo     "Posts: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE timesent>'".$tm24."'"));
        echo     "PMs writing: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_shouts WHERE shtime>'".$tm24."'"));
        echo     "Shouts: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE crdate>'".$tm24."'"));
        echo     "Topics Created: <b>$aut[0]</b><br/>";
            $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_vault WHERE pudt>'".$tm24."'"));
        echo     "Vault (download) Added: <b>$aut[0]</b><br/>;";
        echo     "</p>";
        echo     "<p align=\"center\">";
    echo     "<b>5 </b><a accesskey=\"5\" href=\"index.php?action=stats&amp;sid=$sid\">Statistics</a><br/>";
      echo     "<br/><b>6 </b><a accesskey=\"6\" href=\"inbox.php?action=main&amp;sid=$sid\">Inbox</a><br/>"; 
    but in statistche unchecked, it is not seen. can you help me please?

    Tags: None
    #2
    This code works for me
    else if($action=="l24")
    {
    addonline(getuid_sid($sid),"24h statistika HTML","index.php?action=$action");

    $pstyle = gettheme($sid);
    echo xhtmlhead("24 Hour Statistics",$pstyle);
    echo "<p>";
    echo "<small>";
    /////
    echo "Sta se dogadjalo na HAPPY-ju za poslednja 24h<br/><br/>";
    $tm24 = (time() - $timeadjust) - (24*60*60) ;
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE lastact>'".$tm24."'"));
    echo "Aktivnih: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE regdate>'".$tm24."'"));
    echo "Registrivanih: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_blogs WHERE bgdate>'".$tm24."'"));
    echo "Kreiranih blogova: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE joined>'".$tm24."' AND accepted='1'"));
    echo "Uclanjenih u klubove: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubs WHERE created>'".$tm24."'"));
    echo "Kreiranih klubova: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE reqdt>'".$tm24."' AND agreed='1'"));
    echo "Dodatih prijatelja: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_gbook WHERE dtime>'".$tm24."'"));
    echo "Upisa u GB: <b>$aut[0]</b><br/>";
    if(ismod(getuid_sid($sid))){
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog WHERE actdt>'".$tm24."'"));
    echo "ModCP Akcija: <b>$aut[0]</b><br/>";
    }
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_polls WHERE pdt>'".$tm24."'"));
    echo "Dodatih fotki: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE dtpost>'".$tm24."'"));
    echo "Postova: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE timesent>'".$tm24."'"));
    echo "PP poruka: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_shouts WHERE shtime>'".$tm24."'"));
    echo "Razglasa: <b>$aut[0]</b><br/>";
    $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE crdate>'".$tm24."'"));
    echo "Kreiranih tema: <b>$aut[0]</b><br/>";
    echo "</small></p>";
    echo "<p align=\"center\">";
    echo "<a href=\"index.php?action=stats&amp;sid=$sid\"><img src=\"images/stat.gif\" alt=\"*\"/>";
    echo "Statistika</a><br/>";
    $thid = mysql_fetch_array(mysql_query("SELECT themeid FROM ibwf_users WHERE id='".$uid."'"));
    $themeimageset = mysql_fetch_array(mysql_query("SELECT themedir FROM ibwf_iconset WHERE id='".$thid[0]."'"));
    echo "<img src=\"images/themes/$themeimageset[0]/home.gif\" alt=\"*\"/> <a href=\"index.php?action=main&amp;sid=$sid\">";
    echo "HAPPY</a>";
    echo "</p>";
    echo xhtmlfoot();
    }
    Translate to your language, but the features are the same
    sigpichttp://happy.srecnica.com/web

    Comment

      #3
      but then your code there are different tables, does not go through the same! or if anyone has wapdesire laval, so you see my code
      PHP Code:
      echo "<p>";
                //echo "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));
          echo       "<a href=\"lists.php?action=members&amp;sid=$sid\">»Members($norm[0])</a><br/>";
                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE sex='M'")); 

      Comment

        #4
        lacking the function in file list.php???

        Comment

          #5
          Code:
          echo "<p>";
    echo "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
    $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));
    echo "<a href=\"lists.php?action=members&amp;sid=$sid\">»Members($norm[0])</a><br/>";
    $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE sex='M'"));
          now add this juz copy n paste ;)

          Comment

            #6
            you see, check this written
            What happens here in the last 24 hours

            and when I click takes me out of the community, the home

            Comment

              #7
              Originally posted by Leviathan73 View Post
              Hello friends, I have this code in the file index.pgp, what happened in the last 24 hours
              PHP Code:
              echo "<p>";
                                //echo "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
                                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));
                  echo               "<a href=\"lists.php?action=members&amp;sid=$sid\">»Members($norm[0])</a><br/>";
                                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE sex='M'")); 
              and
              PHP Code:
              else if($action=="l24")
              {
                              $mmsg = htmlspecialchars(getsetmood(getuid_sid($sid)));
                                addonline(getuid_sid($sid),"Statistics ($mmsg)","");
                  echo               "<head>";
                  echo               "<title>Statistiche</title>";
                  echo               "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
                  echo               "</head>";
                  echo               "<body>";
                  echo               "<p>";
                                /////
                                echo "What happened to the $ sitename in the last 24 hours<br/><br/>";
                                $tm24 = time() - (24*60*60);
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE lastact>'".$tm24."'"));
                  echo               "Members active: <b>$aut[0]</b><br/>";
              $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE regdate>'".$tm24."'"));
                  echo               "Members Registered: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_blogs WHERE bgdate>'".$tm24."'"));
                  echo               "Blogs Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE joined>'".$tm24."' AND accepted='1'"));
                  echo               "Members who have joined the Clubs: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubs WHERE created>'".$tm24."'"));
                  echo               "Clubs Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE reqdt>'".$tm24."' AND agreed='1'"));
                  echo               "Friends Added: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_gbook WHERE dtime>'".$tm24."'"));
                  echo               "Guestbooks writings: <b>$aut[0]</b><br/>";
                  if(              ismod(getuid_sid($sid))){
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog WHERE actdt>'".$tm24."'"));
                  echo               "ModLog Action: <b>$aut[0]</b><br/>";
                }
                              $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_polls WHERE pdt>'".$tm24."'"));
                  echo               "Polls Added: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE dtpost>'".$tm24."'"));
                  echo               "Posts: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE timesent>'".$tm24."'"));
                  echo               "PMs writing: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_shouts WHERE shtime>'".$tm24."'"));
                  echo               "Shouts: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE crdate>'".$tm24."'"));
                  echo               "Topics Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_vault WHERE pudt>'".$tm24."'"));
                  echo               "Vault (download) Added: <b>$aut[0]</b><br/>;";
                  echo               "</p>";
                  echo               "<p align=\"center\">";
              echo               "<b>5 </b><a accesskey=\"5\" href=\"index.php?action=stats&amp;sid=$sid\">Statistics</a><br/>";
                echo               "<br/><b>6 </b><a accesskey=\"6\" href=\"inbox.php?action=main&amp;sid=$sid\">Inbox</a><br/>"; 
              but in statistche unchecked, it is not seen. can you help me please?
              ..i think because of your wrong action
              .. try this


              PHP Code:
              echo "<p>";
                  echo               "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
                                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users"));
                  echo               "<a href=\"lists.php?action=members&amp;sid=$sid\">»Members($norm[0])</a><br/>";
                                $norm = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE sex='M'")); 
              and

              PHP Code:
              else if($action=="124")
              {
                              $mmsg = htmlspecialchars(getsetmood(getuid_sid($sid)));
                                addonline(getuid_sid($sid),"Statistics ($mmsg)","");
                  echo               "<head>";
                  echo               "<title>Statistiche</title>";
                  echo               "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
                  echo               "</head>";
                  echo               "<body>";
                  echo               "<p>";
                                /////
                                echo "What happened to the $ sitename in the last 24 hours<br/><br/>";
                                $tm24 = time() - (24*60*60);
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE lastact>'".$tm24."'"));
                  echo               "Members active: <b>$aut[0]</b><br/>";
              $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE regdate>'".$tm24."'"));
                  echo               "Members Registered: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_blogs WHERE bgdate>'".$tm24."'"));
                  echo               "Blogs Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubmembers WHERE joined>'".$tm24."' AND accepted='1'"));
                  echo               "Members who have joined the Clubs: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_clubs WHERE created>'".$tm24."'"));
                  echo               "Clubs Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_buddies WHERE reqdt>'".$tm24."' AND agreed='1'"));
                  echo               "Friends Added: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_gbook WHERE dtime>'".$tm24."'"));
                  echo               "Guestbooks writings: <b>$aut[0]</b><br/>";
                  if(              ismod(getuid_sid($sid))){
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_mlog WHERE actdt>'".$tm24."'"));
                  echo               "ModLog Action: <b>$aut[0]</b><br/>";
                }
                              $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_polls WHERE pdt>'".$tm24."'"));
                  echo               "Polls Added: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE dtpost>'".$tm24."'"));
                  echo               "Posts: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_private WHERE timesent>'".$tm24."'"));
                  echo               "PMs writing: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_shouts WHERE shtime>'".$tm24."'"));
                  echo               "Shouts: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE crdate>'".$tm24."'"));
                  echo               "Topics Created: <b>$aut[0]</b><br/>";
                                $aut = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_vault WHERE pudt>'".$tm24."'"));
                  echo               "Vault (download) Added: <b>$aut[0]</b><br/>;";
                  echo               "</p>";
                  echo               "<p align=\"center\">";
              echo               "<b>5 </b><a accesskey=\"5\" href=\"index.php?action=stats&amp;sid=$sid\">Statistics</a><br/>";
                echo               "<br/><b>6 </b><a accesskey=\"6\" href=\"inbox.php?action=main&amp;sid=$sid\">Inbox</a><br/>"; 
              Did I help you?
              You can help me too
              Your donations will help me finance my studies.

              Comment

                #8
                Why has blocked this line?.. Remove // the beginning of a line

                //echo "<a href=\"index.php?action=124&amp;sid=$sid\">»What happens here in the last 24 hours</a><br/>";
                sigpichttp://happy.srecnica.com/web

                Comment

                  #9
                  thanks friends! thank you key

                  Comment

                    #10
                    .. is problem solved already ??

                    .. thanks button is aLways there =)
                    Did I help you?
                    You can help me too
                    Your donations will help me finance my studies.

                    Comment

                      #11
                      sigpichttp://happy.srecnica.com/web

                      Comment

                      Previous template Next
                      Working...
                      X