MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Development > Change Who's Online breadcrumb
Full Version: Change Who's Online breadcrumb
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

jesuite

2017-01-14, 07:34 PM
I have a plugin that shows on my online list as "quickstats". I would like it to show as "Quick Stats" but I am not sure how to accomplish this. Could someone help me with this please? Here is my plugin code: 

<?php
/**
* Author: Gina
* Date: June 6th' 2014
* Purpose: Automates your quick stats.
* Comments:
* Please make the changes told in the comments to make it work !
*/
 
// Please insert the access to your Database you also used during the install !
define('DBUSER', '****');
define('DBPASS', '****');
define('DBSERVER', '****');
define('DBNAME', '****');

$conn = new mysqli(DBSERVER, DBUSER, DBPASS, DBNAME);

if (!$conn) {
    die('error connecting to database');
}
 
 
//automated quickstats by Gina
 
define('IN_MYBB', 1);
require "./global.php";
require "./inc/config.php";
 
add_breadcrumb("Quick Stats", "quickstats.php");

//Start of Weres
 
// Replace the fid[#] with the fid and the ID of the were-species profile field! For example - fid1
$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'bear' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$bears .= \"".$templates->get("quickstats_entry")."\";");   
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'fox' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$foxes .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'hyena' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$hyenas .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'leopard' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$leopards .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'lion' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$lions .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'rat' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$rats .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'tiger' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$tigers .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid44 = 'wolf' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$wolves .= \"".$templates->get("quickstats_entry")."\";");     
}

//Start of Psychic power #1

// Replace the fid[#] with the fid and the ID of the psychic profile fields! For example - fid1
$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'aerokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$aero .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'alteration' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$alter .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'cryokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$cryo .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'electrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$electro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'healing' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$heal .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'hydrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$hydro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'illusion' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$illusion .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'invisibility' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$invis .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'metallokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$metal .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'negation' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$nega .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'nosokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$noso .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'phasing' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$phase .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'pyrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$pyro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'summoning' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$summon .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'technokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$techno .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'telekinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$telek .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'telepathy' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$telepath .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'teleportation' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$teleport .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'terrakinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$terra .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'touch clairvoyance' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$touch .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid39 = 'veritokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$verito .= \"".$templates->get("quickstats_entry")."\";");     
}

//Start of Psychic power #2

// Replace the fid[#] with the fid and the ID of the psychic profile fields! For example - fid1
$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'aerokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$aero .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'alteration' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$alter .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'cryokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$cryo .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'electrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$electro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'healing' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$heal .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'hydrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$hydro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'illusion' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$illusion .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'invisibility' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$invis .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'metallokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$metal .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'negation' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$nega .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'nosokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$noso .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'phasing' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$phase .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'pyrokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$pyro .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'summoning' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$summon .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'technokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$techno .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'telekinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$telek .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'telepath' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$telepath .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'teleportation' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$teleport .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'terrakinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$terra .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'touch clairvoyance' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$touch .= \"".$templates->get("quickstats_entry")."\";");     
}


$quickstats=$db->query("SELECT * FROM mybb_users LEFT JOIN mybb_userfields ON mybb_users.uid = mybb_userfields.ufid WHERE fid40 = 'veritokinesis' AND mybb_users.usergroup NOT IN (2,3,4,5,6,7,15,23,25) ORDER BY mybb_userfields.fid7 ASC"); 
                   
                   
while($result=$db->fetch_array($quickstats)) {
      $userid = $result['uid'];
      $username = $result['username'];
eval("\$verito .= \"".$templates->get("quickstats_entry")."\";");     
}

eval("\$quickstats = \"".$templates->get("quickstats")."\";");
output_page($quickstats);


?>

fizz

2017-01-14, 08:35 PM
This code makes a new page called quickstats.php and runs a bunch of (really poorly optimized) sql queries on it. This isn't your plugin file, that's in 
inc/plugins
.

jesuite

2017-01-14, 08:48 PM
(2017-01-14, 08:35 PM)fizz Wrote: [ -> ]This code makes a new page called quickstats.php and runs a bunch of (really poorly optimized) sql queries on it. This isn't your plugin file, that's in 
inc/plugins
.

Sorry if I did not use the correct terminology or that the queries are poorly optimized, I'm still learning this so I am trying my best. Smile I just wanted to know how to add in the breadcrumb, but I can ask elsewhere if this was incorrect.

fizz

2017-01-14, 08:53 PM
(2017-01-14, 08:48 PM)jesuite Wrote: [ -> ]
(2017-01-14, 08:35 PM)fizz Wrote: [ -> ]This code makes a new page called quickstats.php and runs a bunch of (really poorly optimized) sql queries on it. This isn't your plugin file, that's in 
inc/plugins
.

Sorry if I did not use the correct terminology or that the queries are poorly optimized, I'm still learning this so I am trying my best. Smile I just wanted to know how to add in the breadcrumb, but I can ask elsewhere if this was incorrect.

Not a problem, just wanted to let you know! But what I'm saying is if you post the code for the plugin file in inc/plugins I can help you, this just isn't the right file. The breadcrumb being set in this file is already what you want I believe though: 
add_breadcrumb("Quick Stats", "quickstats.php");
will show up as "Quick Stats" and if you click it it'll take you to quickstats.php

jesuite

2017-01-14, 08:58 PM
(2017-01-14, 08:53 PM)fizz Wrote: [ -> ]Not a problem, just wanted to let you know! But what I'm saying is if you post the code for the plugin file in inc/plugins I can help you, this just isn't the right file. The breadcrumb being set in this file is already what you want I believe though:
add_breadcrumb("Quick Stats", "quickstats.php");
will show up as "Quick Stats" and if you click it it'll take you to quickstats.php

Hmmm. Okay. I don't have an additional code in inc/plugins. I have this in the root folder and then the templates that I've made for it.

fizz

2017-01-14, 09:06 PM
Weird...so you just manually inserted the templates into your database? Also what exactly are you wanting to do here? I feel like we're not on the same page lol

jesuite

2017-01-14, 09:16 PM
Haha No no. I created the templates in the ACP.

Global Templates -> quickstats
<html>
<head>
<title>{$settings['bbname']} - Quick Stats</title>
{$headerinclude}
</head>
<body>
{$header}
	
	
<div class="page_title">
	<div class="page_title_style">Quick Stats</div>
</div>

	
<div class="page_container">
	<div class="page_background">
		<h2>Weres</h2>
		<p>Are you curious as to who's a part of what Were group? Or maybe you're checking the popularity of an Were species before giving it to your character? This is a great place to start. All Weres are sorted by their respective animal species.</p>
	</div>
	<br/>
	<div class="claim_table">
		<div class="tr">
			<div class="td4">
				<h3>Bears</h3><br />
				$bears
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Coyotes</h3><br />
				$coyotes
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Foxes</h3><br />
				$foxes
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Hyenas</h3><br />
				$hyenas
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Leopards</h3><br />
				$leopards
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Lions</h3><br />
				$lions
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Rats</h3><br />
				$rats
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Tigers</h3><br />
				$tigers
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Wolverines</h3><br />
				$wolverines
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Wolves</h3><br />
				$wolves
			</div>
		</div>
	</div>	

	<br/>
	<div class="page_background">
		
		<h2>Psychic Abilities</h2>
		<p>Curious as to who has what power? Or maybe you're checking the popularity of a power before leveling your character? Either way, this list is a good place to start. If you're not sure what a power is, check out their definitions in the <a href="misc.php?action=help&hid=22#Aerokinesis">guidebook</a>.</p>	
	</div>
	<br/>
	
	<div class="claim_table">
		<div class="tr">
			<div class="td4">
				<h3>Aerokinesis</h3><br />
				$aero
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Alteration</h3><br />
				$alter
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Cryokinesis</h3><br />
				$cryo
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Electrokinesis</h3><br />
				$electro
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Healing</h3><br />
				$healing
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Hydrokinesis</h3><br />
				$hydro
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Illusion</h3><br />
				$illusion
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Invisibility</h3><br />
				$invis
			</div>
		</div>	
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Metallokinesis</h3><br />
				$metal
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Negation</h3><br />
				$nega
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Nosokinesis</h3><br />
				$noso
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Phasing</h3><br />
				$phase
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Pyrokinesis</h3><br />
				$pyro
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Summoning</h3><br />
				$summon
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Technokinesis</h3><br />
				$techno
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Telekinesis</h3><br />
				$telek
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Telepathy</h3><br />
				$telepath
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Teleportation</h3><br />
				$teleport
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Terrakinesis</h3><br />
				$terra
			</div>
			<div class="td_blank"></div>
			<div class="td4">
				<h3>Touch Clairvoyance</h3><br />
				$touch
			</div>
		</div>
		<br/>
		<div class="tr">
			<div class="td4">
				<h3>Veritokinesis</h3><br />
				$verito
			</div>
		</div>	
	</div>	
	
</div>	


{$footer}
</body>
</html>

Global Templates -> quickstats_entry
<a id="{$userUid}" href="member.php?action=profile&uid={$userid}">$username</a>

<br/>
What I am trying to do is change this:
https://www.dropbox.com/s/2tw4758azqa63g...9.png?dl=0
to be the title of the page rather than the name of the php file. So "Quick Stats" instead of "quickstats" on the Who's Online list.

fizz

2017-01-14, 09:20 PM
Ahh I gotcha. Try changing the name of the file to "Quick Stats.php" and replace the add_breadcrumb line with this:
add_breadcrumb("Quick Stats", "Quick Stats.php");

Not sure if it'll work so be sure you back up what you've got.

jesuite

2017-01-14, 09:28 PM
It worked perfectly! Thank you!

fizz

2017-01-14, 09:30 PM
(2017-01-14, 09:28 PM)jesuite Wrote: [ -> ]It worked perfectly! Thank you!

Awesome! Glad I could help.
MyBB Community Forums > Extensions > Plugins > Plugin Development > Change Who's Online breadcrumb