Lavalair Mods...

Collapse
This is a sticky topic.
X
X
Collapse
 
  • Page of 10
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 4 5 6 7 8 9 10 template Next
    #121
    Exclamation HELP To speedup this!

    SOMEONE HELP to speed up "View category" func?it very slow to open this...this is code what I using now
    Just exclude some stuff like i have done, and add in every mysql select at the end LIMIT 1 or LIMIT 0,1 except you have a while loop, then that would be a bad idea

    PHP Code:
    if(canaccess(getuid_sid($sid), $forum[0]))
    {
           $notp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE fid='".$forum[0]."' LIMIT 0,1"));
    // $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts, ibwf_topics WHERE ibwf_posts.tid = ibwf_topics.id AND ibwf_topics.fid = '".$forum[0]."' LIMIT 0,1"));
    // $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts a INNER JOIN ibwf_topics b ON a.tid = b.id WHERE b.fid='".$forum[0]."'"));
    $iml = "<img src=\"images/1.gif\" alt=\"*\"/>";
    echo     "<a href=\"index.php?action=viewfrm&amp;sid=$sid&amp;fid=$forum[0]\">$iml$forum[1] ($notp[0] topika)</a><br/>";
    $lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM ibwf_topics WHERE fid='".$forum[0]."' ORDER BY lastpost DESC LIMIT 0,1"));
              $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE tid='".$lpt[0]."' LIMIT 1"));
          if(    $nops[0]==0)
          {
              $pinfo = mysql_fetch_array(mysql_query("SELECT authorid FROM ibwf_topics WHERE id='".$lpt[0]."' LIMIT 0,1"));
              $tluid = $pinfo[0];
          }else{
              $pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_posts WHERE tid='".$lpt[0]."' ORDER BY dtpost DESC LIMIT 0,1"));
              $tluid = $pinfo[0];
          }      
              $tlnm = htmlspecialchars($lpt[1]);
              $tlnick = getnick_uid($tluid);
              $tpclnk = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$lpt[0]&amp;go=last\">$tlnm</a>";
              $vulnk = "<a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$tluid\">$tlnick</a>";
          echo     "Zadnji post: $tpclnk, od: $vulnk<br/><br/>";
      } 
    Last edited by kafa; 17.08.11, 22:25. Reason: forgot to quote previous post

    Comment

      #122
      Originally posted by kafa View Post
      Just exclude some stuff like i have done, and add in every mysql select at the end LIMIT 1 or LIMIT 0,1 except you have a while loop, then that would be a bad idea

      PHP Code:
      if(canaccess(getuid_sid($sid), $forum[0]))
      {
               $notp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE fid='".$forum[0]."' LIMIT 0,1"));
      // $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts, ibwf_topics WHERE ibwf_posts.tid = ibwf_topics.id AND ibwf_topics.fid = '".$forum[0]."' LIMIT 0,1"));
      // $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts a INNER JOIN ibwf_topics b ON a.tid = b.id WHERE b.fid='".$forum[0]."'"));
      $iml = "<img src=\"http://coding-talk.com/images/1.gif\" alt=\"*\"/>";
      echo       "<a href=\"index.php?action=viewfrm&amp;sid=$sid&amp;fid=$forum[0]\">$iml$forum[1] ($notp[0] topika)</a><br/>";
      $lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM ibwf_topics WHERE fid='".$forum[0]."' ORDER BY lastpost DESC LIMIT 0,1"));
                  $nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_posts WHERE tid='".$lpt[0]."' LIMIT 1"));
            if(      $nops[0]==0)
            {
                  $pinfo = mysql_fetch_array(mysql_query("SELECT authorid FROM ibwf_topics WHERE id='".$lpt[0]."' LIMIT 0,1"));
                  $tluid = $pinfo[0];
            }else{
                  $pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM ibwf_posts WHERE tid='".$lpt[0]."' ORDER BY dtpost DESC LIMIT 0,1"));
                  $tluid = $pinfo[0];
            }      
                  $tlnm = htmlspecialchars($lpt[1]);
                  $tlnick = getnick_uid($tluid);
                  $tpclnk = "<a href=\"index.php?action=viewtpc&amp;sid=$sid&amp;tid=$lpt[0]&amp;go=last\">$tlnm</a>";
                  $vulnk = "<a href=\"index.php?action=viewuser&amp;sid=$sid&amp;who=$tluid\">$tlnick</a>";
            echo       "Zadnji post: $tpclnk, od: $vulnk<br/><br/>";
        } 
      I have long time ago added everywhere LIMIT 0.1 , but all categories is very slow to open....
      sigpichttp://happy.srecnica.com/web

      Comment

        #123
        Originally posted by srecnica View Post
        I have long time ago added everywhere LIMIT 0.1 , but all categories is very slow to open....
        Go to phpmyadmin, select all tables and do "repair tables", this could do some speed-up
        Also delete often all PM's cus inbox.php is a big CPU eater.
        Delete old topics and big topics with few thousand posts and open new ones.
        Also delete all unnecessary stuff from big tables like sellecting number of posts where"somestuff"="something" or number of PM's, cus every MYSQL SELECT uses CPU time and if you have 10 or 20 mysql requests on one page, then you have as result a very slow page.
        Do so much as possible to put all mysql reqs into one request.

        I hope this could help you to do some speed-up

        Comment

          #124
          Originally posted by kafa View Post
          Go to phpmyadmin, select all tables and do "repair tables", this could do some speed-up
          Also delete often all PM's cus inbox.php is a big CPU eater.
          Delete old topics and big topics with few thousand posts and open new ones.
          Also delete all unnecessary stuff from big tables like sellecting number of posts where"somestuff"="something" or number of PM's, cus every MYSQL SELECT uses CPU time and if you have 10 or 20 mysql requests on one page, then you have as result a very slow page.
          Do so much as possible to put all mysql reqs into one request.

          I hope this could help you to do some speed-up
          yes, thank you. Although often do everything that you said, clean the old threads, inbox ... but I think the problem with opening speed categories in fact the number of links in the category itself. I noticed when I cut down the number one category subforum it to be opened more quickly .. The problem is that our forums crowded subforum ( mnogo podforuma u kategoriji.... previse linkova ;) )
          sigpichttp://happy.srecnica.com/web

          Comment

            #125
            Originally posted by srecnica View Post
            yes, thank you. Although often do everything that you said, clean the old threads, inbox ... but I think the problem with opening speed categories in fact the number of links in the category itself. I noticed when I cut down the number one category subforum it to be opened more quickly .. The problem is that our forums crowded subforum ( mnogo podforuma u kategoriji.... previse linkova ;) )
            so cut it off, delete some subcategories

            for real speed just delete every mysql SELECT FROM ibwf_posts. You will have top speed, but you will not be able to see the last post.

            View demo.

            PHP Code:
            else if($action=="viewcat")
            {
            $cid = $_GET["cid"];
            $cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_fcats WHERE id='".$cid."' LIMIT 0,1"));
            echo             "<card id=\"main\" title=\"MERAK.mobi\">";
            echo             "<p align=\"center\"><b>$cinfo[0] forum</b><br/><br/>";
            echo             "</p><p>";
            $forums = mysql_query("SELECT id, name FROM ibwf_forums WHERE cid='".$cid."' AND clubid='0' ORDER BY position, id, name");

              while(            $forum = mysql_fetch_array($forums))
              {
              if(            canaccess(getuid_sid($sid), $forum[0]))
              {
                          $notp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE fid='".$forum[0]."'"));
                          $iml = "<img src=\"images/1.gif\" alt=\"*\"/> ";
              echo             "<a href=\"index.php?action=gviewfrm&amp;sid=$sid&amp;fid=$forum[0]\">$iml$forum[1] ($notp[0] topika)</a><br/>";
              }
              }
              echo             "</p>";
              echo             "<p align=\"center\">";
              echo             "<a href=\"index.php?action=gforumindx&amp;sid=$sid\">Forum</a><br/>";
              echo             "<a href=\"index.php\"><img src=\"images/home.gif\" alt=\"\"/><br/>Home</a>";
              echo             "</p>";
            echo             "</card>";
            } 

            Comment

              #126
              Originally posted by kafa View Post
              so cut it off, delete some subcategories

              for real speed just delete every mysql SELECT FROM ibwf_posts. You will have top speed, but you will not be able to see the last post.

              View demo.

              PHP Code:
              else if($action=="viewcat")
              {
              $cid = $_GET["cid"];
              $cinfo = mysql_fetch_array(mysql_query("SELECT name from ibwf_fcats WHERE id='".$cid."' LIMIT 0,1"));
              echo               "<card id=\"main\" title=\"MERAK.mobi\">";
              echo               "<p align=\"center\"><b>$cinfo[0] forum</b><br/><br/>";
              echo               "</p><p>";
              $forums = mysql_query("SELECT id, name FROM ibwf_forums WHERE cid='".$cid."' AND clubid='0' ORDER BY position, id, name");

                while(              $forum = mysql_fetch_array($forums))
                {
                if(              canaccess(getuid_sid($sid), $forum[0]))
                {
                              $notp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_topics WHERE fid='".$forum[0]."'"));
                              $iml = "<img src=\"http://coding-talk.com/images/1.gif\" alt=\"*\"/> ";
                echo               "<a href=\"index.php?action=gviewfrm&amp;sid=$sid&amp;fid=$forum[0]\">$iml$forum[1] ($notp[0] topika)</a><br/>";
                }
                }
                echo               "</p>";
                echo               "<p align=\"center\">";
                echo               "<a href=\"index.php?action=gforumindx&amp;sid=$sid\">Forum</a><br/>";
                echo               "<a href=\"index.php\"><img src=\"http://coding-talk.com/images/home.gif\" alt=\"\"/><br/>Home</a>";
                echo               "</p>";
              echo               "</card>";
              } 
              Thank you so much) where I wiped the last message was written much faster and really works! ) Thanks ))
              sigpichttp://happy.srecnica.com/web

              Comment

                #127
                truth or dare

                i made this years ago. aint seen it anywere else so thought id share .

                dont forget the thankyou button
                Attached Files
                Wapchat4u


                Topsites4u
                • Likes 1

                Comment

                  #128
                  Originally posted by nclemale36 View Post
                  i made this years ago. aint seen it anywere else so thought id share .

                  dont forget the thankyou button
                  this is kool and got it on v2 script
                  HELP THEM WHO HELPS YOU



                  i only work on wapdesire v_2 coding only

                  Comment

                    #129
                    Originally posted by WhiteWarrior View Post
                    Post Your Custom Made Mods Here For The Lavalair Script.

                    - - - - - - - - - -

                    Topic Made And Pinned As Requested By Members

                    Thanks for all the mods posted.
                    very useful thread

                    Comment

                      #130
                      need more scipts...

                      Comment

                        #131
                        Originally posted by chathumax View Post
                        need more scipts...
                        ... and ... ?
                        make them and stop moaning...
                        It's better to keep your mouth shut and give the impression that you're stupid, than to open it and remove all doubt.
                        ⓣⓗⓔ ⓠⓤⓘⓔⓣⓔⓡ ⓨⓞⓤ ⓑⓔ©ⓞⓜⓔ, ⓣⓗⓔ ⓜⓞⓡⓔ ⓨⓞⓤ ⓐⓡⓔ ⓐⓑⓛⓔ ⓣⓞ ⓗⓔⓐⓡ !
                        ιη тнєσяу, тнє ρяα¢тι¢є ιѕ α яєѕυℓт σƒ тнє тнєσяу, вυт ιη ρяα¢тι¢є ιѕ тнє σρρσѕιтє.
                        ｷﾉgんｲﾉ刀g 4 ｱ乇ﾑc乇 ﾉ丂 ﾚﾉズ乇 ｷucズﾉ刀g 4 √ﾉ尺gﾉ刀ﾉｲﾘ!

                        Comment

                          #132
                          Still this is pinned? I came here after around 2 yrs...so don't blame me because i posted in this topic, I did because this one is pinned


                          I'm Proud to be a Sri Lankan!

                          Comment

                            #133
                            I had plenty of mods for this LOL. But as time moved on so did this. phpBB is the new kid on the block now to mod.
                            BakGat
                            Code:
                            class Counter {
public:
  void Count();
  int  ReadDisplay();
private:
  int  CurrentCount;
};








                            Back up my hard drive? How do I put it in reverse?
                            My Community
                            BakGat
                            sigpic

                            Comment

                              #134
                              need ibwf_users table plz

                              Comment

                                #135
                                Originally posted by asadkhan View Post
                                need ibwf_users table plz
                                CREATE TABLE IF NOT EXISTS `iwbf_users` (
                                `id` int(100) NOT NULL AUTO_INCREMENT,
                                `name` varchar(30) NOT NULL DEFAULT '',
                                `pass` varchar(60) NOT NULL DEFAULT '',
                                `birthday` varchar(50) NOT NULL DEFAULT '',
                                `sex` char(1) NOT NULL DEFAULT '',
                                `location` varchar(100) NOT NULL DEFAULT '',
                                `perm` char(1) NOT NULL DEFAULT '0',
                                `posts` int(100) NOT NULL DEFAULT '0',
                                `plusses` int(100) NOT NULL DEFAULT '0',
                                `signature` varchar(100) NOT NULL DEFAULT '',
                                `avatar` varchar(100) NOT NULL DEFAULT '',
                                `email` varchar(50) NOT NULL DEFAULT '',
                                `site` varchar(50) NOT NULL DEFAULT '',
                                `browserm` varchar(100) NOT NULL DEFAULT '',
                                `ipadd` varchar(30) NOT NULL DEFAULT '',
                                `lastact` int(100) NOT NULL DEFAULT '0',
                                `regdate` int(100) NOT NULL DEFAULT '0',
                                `chmsgs` int(100) NOT NULL DEFAULT '0',
                                `chmood` int(100) NOT NULL DEFAULT '0',
                                `shield` char(1) NOT NULL DEFAULT '0',
                                `gplus` int(100) NOT NULL DEFAULT '0',
                                `budmsg` varchar(100) NOT NULL DEFAULT '',
                                `lastpnreas` varchar(100) NOT NULL DEFAULT '',
                                `lastplreas` varchar(100) NOT NULL DEFAULT '',
                                `shouts` int(100) NOT NULL DEFAULT '0',
                                `pollid` int(100) NOT NULL DEFAULT '0',
                                `rbcid` varchar(255) NOT NULL DEFAULT '',
                                `hvia` char(1) NOT NULL DEFAULT '1',
                                `lastvst` int(100) NOT NULL,
                                `battlep` int(100) NOT NULL DEFAULT '0',
                                PRIMARY KEY (`id`),
                                UNIQUE KEY `name` (`name`)
                                ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

                                Comment

                                Previous 1 4 5 6 7 8 9 10 template Next
                                Working...
                                X