This tutorial will help you make an alphabetical search menu similar to what we see in memberlist.php
I had been looking for this for quite some time, opened a thread too but no help. Now, after some little programming homework I find it quite easy. Hope few of you find this useful.
Assuming you have intermediate knowledge of HTML and PHP.
Its hard for me to understand how this is done in memberlist.php. But this is the most easy way.
Do follow the comments in code.
I am not a coder.
1. First, we create a template for our product titled alphamenu and copy this code into it.
2. Then in our custom vbulletin page.php, we create a subpage called alphasearch and copy the below code into it. Ofcourse, this would require editing according to your needs, so read the comments carefully.
//****Beginning Page Navigation ***//
// Default page variables
$perpage = $vbulletin->input->clean_gpc('r', 'perpage', TYPE_UINT);
$pagenumber = $vbulletin->input->clean_gpc('r', 'pagenumber', TYPE_UINT);
// Count all log entries
$itemcount = $db->query_first("
SELECT COUNT(`uid`) AS `itemcount`
FROM `" . TABLE_PREFIX . "mytable` WHERE colname LIKE '" . $letter . "%'"); //Change colname to actual column name in table that you want to search in.
if ($itemcount['itemcount'] == 0) { // Show if recordset empty
$emptysearch=true; // With this, you can easily create a condition in the template to show NO ITEMS message
} // Show if recordset empty
// Make sure all these variables are cool
sanitize_pageresults($itemcount['itemcount'], $pagenumber, $perpage, 10, 8); //Change 8 to as many records you want to show per page
// Default lower and upper limit variables
$limitlower = ($pagenumber - 1) * $perpage + 1;
$limitupper = $pagenumber * $perpage;
if ($limitupper > $itemcount['itemcount'])
{
// Too many for upper limit
$limitupper = $itemcount['itemcount'];
if ($limitlower > $itemcount['itemcount'])
{
// Too many for lower limit
$limitlower = $itemcount['itemcount'] - $perpage;
}
}
if ($limitlower <= 0)
{
// Can't have negative or null lower limit
$limitlower = 1;
}
eval('$alphamenu .= "' . fetch_template('alphamenu') . '";'); //Use this line of code to show alphamenu in any sub-page you want. Then simply use $alphamenu variable in the associated template.
$query_Searchltr=$db->query_read("SELECT * from " . TABLE_PREFIX . "mytable WHERE colname LIKE '" . $letter . "%' LIMIT " . ($limitlower - 1) . ", $perpage"); //Change colname to the same column name you had set in the above count query
while ($search_result = $db->fetch_array($query_Searchltr))
{
$row_id=$search_result['uid'];
$row_name=$search_result['name'];
$row_class=$search_result['class'];
// and so on...
}
// Finally construct the page nav
$pagenav = construct_page_nav($pagenumber, $perpage, $itemcount['itemcount'], 'page.php?do=alphasearch' . $vbulletin->session->vars['sessionurl'] . '&ltr=' . $letter);
//****End Page Navigation******//
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('mysearchbits') . '");'); //The main output prints on mysearchbits template, so create it and use variables defined within the while loop above for results
$db->free_result($query_Searchltr);
}
//*******END ALPHA SEARCH MENU*******
Now, as said earlier in comments, simply use this line in any sub-page and put $alphamenu in the associated template. This would show the menu.
do not understand that part of -> So, in our usual vbulletin page.php, we will create a sub-called alphasearch and copy the code below for this. Sure, it would require editing to suit your needs, so read the comments.
and where it can help? pa of creating for instance in the cinema section of my forum?
Caution: This "Tutorial" does NOT describe a WORKING mod and does not work as written. It is COMPLETELY based on a "theoretical" model and is completely worthless as a realtime MOD that just needs to be "tweaked". Not sure what the author was thinking when he called it a tutorial?
Caution: This "Tutorial" does NOT describe a WORKING mod and does not work as written. It is COMPLETELY based on a "theoretical" model and is completely worthless as a realtime MOD that just needs to be "tweaked". Not sure what the author was thinking when he called it a tutorial?
ehm.. that is what an article is. ROFL!
Quote:
Originally Posted by 1st point of article
# Assuming you have intermediate knowledge of HTML and PHP.
08-11-2008, 10:00 PM
09-21-2008, 06:40 PM
