?>
</a></p>
<p><?php
echo vereinsbeschreibung;
?>
</p>
</div>
<?php
if (isset($_SESSION['userid'])) {
?>
<h2>Helferinnen und Helfer</h2>
<table>
<?php
getHelper($dbmysql, $_SESSION['fullEvent']);
?>
</table>
<h2>Hallo <?php
echo $_SESSION['username'];
?>
, hier kannst du dich noch eintragen: </h2>
<div id="todoForm">
<form method="post" action="<?php
echo $_SERVER['PHP_SELF'];
?>
">
<table id="openToDos">
<thead>
<tr>
function selectHelper($parameters)
{
global $db;
// check the parameters and add to where clause
$where = '';
// find helper by string
if (!empty($parameters['searchAll'])) {
// there are two possibilities: find string in keyword, file_ending or in context-info
// check in DB for entries matching
$query = "\n SELECT\n `id`\n FROM\n `" . $GLOBALS['dataBaseToUse'] . "`.`tl_helper`\n WHERE\n (`firstname` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `lastname` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `street` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `city` like '%" . addslashes($parameters['searchAll']) . "%'\n OR `postal` like '%" . addslashes($parameters['searchAll']) . "%')\n ";
$result = $db->query($query);
$helperIdArray = array(0);
while ($row = mysqli_fetch_assoc($result)) {
$helperIdArray[] = $row['id'];
}
$where .= "\n `tl_helper`.`id` in (" . implode(', ', $helperIdArray) . ")";
}
// paging contains results per block as blocksize and number of block used for the query
if (!empty($parameters['paging'])) {
// blocksize from setting or standard
if (!empty($parameters['paging']['blocksize'])) {
$blocksize = 0 + $parameters['paging']['blocksize'];
} else {
$blocksize = 20;
}
if (!empty($parameters['paging']['block'])) {
$block = 0 + $parameters['paging']['block'];
} else {
$block = 1;
}
$parameters['limit'] = " LIMIT " . ($block - 1) * $blocksize . ", " . $blocksize . " ";
}
if (!empty($parameters['order'])) {
$where .= addslashes($parameters['order']);
}
if (!empty($parameters['limit'])) {
$where .= addslashes($parameters['limit']);
}
// select Helper
// get ids for helper entries
$query = "\n\t\t SELECT\n SQL_CALC_FOUND_ROWS\n `tl_helper`.`id`\n FROM\n\t\t `" . $GLOBALS['dataBaseToUse'] . "`.`tl_helper`\n\n\t\t WHERE\n\n " . $where . "\n\t ";
$result = $db->query($query);
$return = array();
// reports
$return['parameters'] = $parameters;
$return['numResults'] = '';
while ($row = mysqli_fetch_assoc($result)) {
$return['data'][$row['id']] = array();
}
// number of possible results
$countResult = $db->query("SELECT FOUND_ROWS()");
$countArray = $row = mysqli_fetch_assoc($countResult);
$return['numResults'] = $countArray['FOUND_ROWS()'];
// now get the values
if (!empty($return['data'])) {
$helperData = getHelper(array_keys($return['data']));
#print_r($helperData);
foreach ($helperData as $idHelper => $row) {
$return['data'][$idHelper] = $row;
}
}
return $return;
}
