no problem.
sightings.php
PHP Code:
<?php
// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);
// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'sightings');
define('CSRF_PROTECTION', true);
// change this depending on your filename
// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();
// get special data templates from the datastore
$specialtemplates = array();
// pre-cache templates used by all actions
$globaltemplates = array('custom_sightings',
);
// pre-cache templates used by specific actions
$actiontemplates = array();
// ######################### REQUIRE BACK-END ############################
// if your page is outside of your normal vb forums directory, you should change directories by uncommenting the next line
// chdir ('/path/to/your/forums');
require_once('./global.php');
// #######################################################################
// ######################## START MAIN SCRIPT ############################
// #######################################################################
$navbits = construct_navbits(array('' => 'Sightings'));
$navbar = render_navbar_template($navbits);
// ###### YOUR CUSTOM CODE GOES HERE #####
$pagetitle = 'Sightings';
$link = mysql_connect("xxxxxxxxxxxxx", "xxxxxxx", "xxxxxxx") or die("Impossible to connect :" . mysql_error());
$row_usersightings = array ();
$vbulletin->input->clean_array_gpc('r', array(
'perpage' => TYPE_UINT,
'pagenumber' => TYPE_UINT,
));
mysql_select_db("mothstats") or die(mysql_error());
$cel_users = mysql_query("
SELECT COUNT('id') AS row_count
FROM sightings
");
sanitize_pageresults($cel_users['row_count'], $pagenumber, $perpage, 100, 20);
if ($vbulletin->GPC['pagenumber'] < 1)
{
$vbulletin->GPC['pagenumber'] = 1;
}
else if ($vbulletin->GPC['pagenumber'] > ceil(($cel_users['row_count'] + 1) / $perpage))
{
$vbulletin->GPC['pagenumber'] = ceil(($cel_users['row_count'] + 1) / $perpage);
}
$limitlower = ($vbulletin->GPC['pagenumber'] - 1) * $perpage;
$limitupper = ($vbulletin->GPC['pagenumber']) * $perpage;
$usersightings = mysql_query("SELECT * FROM sightings
ORDER BY id DESC
LIMIT $limitlower, $perpage");
while ($row = mysql_fetch_assoc($usersightings))
{
$row_usersightings[] = $row;
}
$pagenav = construct_page_nav(
$vbulletin->GPC['pagenumber'],
$perpage,
$cel_users['row_count'],
'sightings.php?' . $vbulletin->session->vars['sessionurl'] // the pagenav-link
);
// ###### NOW YOUR TEMPLATE IS BEING RENDERED ######
vB_Template::preRegister('custom_sightings',array('row_usersightings' => $row_usersightings));
$templater = vB_Template::create('custom_sightings');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
$templater->register('row_usersightings', $row_usersightings);
$templater->register('pagenav', $pagenav);
$templater->register('pagenumber', $pagenumber);
$templater->register('perpage', $perpage);
$templater->register('output', $output);
print_output($templater->render());
?>
Templats : custom_sightings
PHP Code:
{vb:stylevar htmldoctype}
<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">
<head>
<title>{vb:raw vboptions.bbtitle}</title>
{vb:raw headinclude}
</head>
<body>
{vb:raw header}
{vb:raw navbar}
<vb:if condition="$pagenav">
<div id="pagination_top">
{vb:raw pagenav}
</div>
</vb:if>
<div id="pagetitle">
<h1>{vb:raw pagetitle}</h1>
</div>
<h2 class="blockhead">Title</h2>
<div class="blockbody">
<div class="blockrow">
<div id="container">
<div style="padding-left: 10px; padding-top:5px;">
<a href="sightingssubmit.php"><strong>Submit a sighting </strong></a> | <a href="sightings.php"><strong>Show all sightings </strong></a>
</div>
<br />
<table width="95%" border="0" align="center" bgcolor="#FCFCFC">
<tr>
<td bgcolor="#848E7B"><div align="left" class="style1">No.</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Species</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Date</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Location</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Recorder</div></td>
<td bgcolor="#848E7B"><div align="left" class="style1">Details</div></td>
</tr>
<vb:each from="row_usersightings" key="rowid" value="rowinfo">
<tr>
<td width="30" valign="top" bgcolor="#FFFff4"><div align="left" class="style131 "> {vb:var rowinfo.id} </div></td>
<td width="150" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"> {vb:var rowinfo.species}</div></td>
<td width="50" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"> {vb:var rowinfo.date}</div></td>
<td width="120" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"> {vb:var rowinfo.location}</div></td>
<td width="100" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"> {vb:var rowinfo.recorder}</div></td>
<td width="350" valign="top" bgcolor="#FFFff4"><div align="left" class="style131"> {vb:var rowinfo.details}</div></td>
</tr>
</vb:each>
</table>
</div>
</div>
</div>
{vb:raw footer}
</body>
</html>
More Information