Lavalair Mods...

**kafa** · 17.08.11, 22:23

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/>";

  }

**srecnica** · 18.08.11, 07:17

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....

**kafa** · 18.08.11, 11:43

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

**srecnica** · 18.08.11, 12:30

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 ;) )

**kafa** · 18.08.11, 15:09

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>";
}

**srecnica** · 18.08.11, 20:12

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

))

**nclemale36** · 31.08.11, 15:44

truth or dare

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

dont forget the thankyou button

Attached Files

truth.rar (10.6 KB, 290 views)

**brand** · 10.11.11, 08:00

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

**Sreekanth P R** · 02.06.13, 06:53

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

**chathumax** · 26.07.13, 15:54

need more scipts...

**metulj** · 26.07.13, 16:59

Originally posted by chathumax View Post

need more scipts...

... and ... ?
make them and stop moaning...

**nimeshka** · 16.10.14, 10:26

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

**bOrN2pwn** · 19.11.14, 12:28

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.

**asadkhan** · 25.04.15, 03:52

need ibwf_users table plz

**stefan998** · 20.08.17, 22:19

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 ;

Lavalair Mods...

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment