Lavalair Mods...

[asadkhan]

need ibwf_users table plz

[bOrN2pwn]

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.

[nimeshka]

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

[metulj]

need more scipts...

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

[chathumax]

need more scipts...

[Sreekanth P R]

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

[brand]

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

[nclemale36]

truth or dare

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

dont forget the thankyou button

[srecnica]

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.

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

[kafa]

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.

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]

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]

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]

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

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]

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

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

[skyjokey]

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

else if($action=="viewcat")
{
$cid = $_GET["cid"];
addonline(getuid_sid($sid),"Gleda kategorije","");
$cinfo = mysql_fetch_array(mysql_query("SELECT name from iwbf_fcats WHERE id='".$cid."'"));

echo "<p align=\"center\">";
echo getshoutbox($sid);
echo "</p>";
echo "<p>";
$forums = mysql_query("SELECT id, name FROM iwbf_forums WHERE cid='".$cid."' AND clubid='0' ORDER BY position, id, name");
echo "";
while($forum = mysql_fetch_array($forums))
{
if(canaccess(getuid_sid($sid), $forum[0]))
{
$notp = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM iwbf_topics WHERE fid='".$forum[0]."'"));
$nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM iwbf_posts a INNER JOIN iwbf_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;f id=$forum[0]\">$iml$forum[1]($notp[0]/$nops[0])</a><br/>";
$lpt = mysql_fetch_array(mysql_query("SELECT id, name FROM iwbf_topics WHERE fid='".$forum[0]."' ORDER BY lastpost DESC LIMIT 0,1"));
$nops = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM iwbf_posts WHERE tid='".$lpt[0]."'"));
if($nops[0]==0)
{
$pinfo = mysql_fetch_array(mysql_query("SELECT authorid FROM iwbf_topics WHERE id='".$lpt[0]."'"));
$tluid = $pinfo[0];

}else{
$pinfo = mysql_fetch_array(mysql_query("SELECT uid FROM iwbf_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;t id=$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 u temi: $tpclnk, od: $vulnk<br/><br/>";
}
}
echo "";
echo "</p>";
echo "<p align=\"center\">";
$tmsg = getpmcount(getuid_sid($sid));
$umsg = getunreadpm(getuid_sid($sid));
if($umsg>0)
{
echo "<a href=\"inbox.php?action=main&amp;sid=$sid\">Inbox( $umsg/$tmsg)</a><br/>";
}
echo "<a href=\"index.php?action=main&amp;sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p>";

}