function showuploaddlg()
{
# ------------------------
# v02 BH 2005/10/5
# -----------------------
#//
#// display user dialog which loads a file and stores it in egate folder
#//
global $usertoken, $gatecode;
echo setPageTitle('E-Gate Upload / User: '******'uname']);
echo '<p>Upload Gate zu unterschiedlichen Teilen des LSDB Systems. Verwende unbedingt die Preview Funktion um sicherzustellen dass die upload-dateien keine korrekt interpretiert werden.</p>';
echo '<h3>Vorschau</h3>';
echo '<table><tr><td>';
echo LS_uploaddialog('Preview [Tab] Seperated File', $gatecode . '?func=previewtab', 'Preview');
echo '</td><td>';
echo LS_uploaddialog('Preview [;] Seperated File', $gatecode . '?func=previewcsv', 'Preview');
echo '</td></tr></table>';
echo '<br/>';
echo '<h3>Spielpläne</h3>';
echo LS_uploaddialog('Upload/Process League Schedule File for Events', $gatecode . '?func=uploadmatches', 'Upload');
echo 'FORMAT für den Spielplan Upload' . '<div class="code"><pre>
event;runde;teamhome;teamaway;datum
51;1;89;78;2007-09-02
51;1;73;99;2007-09-02
</pre></div><br/>';
$element = ' Pass Nummer: ' . Select_Membertype('mtype', 1, '', 0);
echo '<h3>Spieler</h3>';
echo LS_uploaddialog('Upload Player File', $gatecode . '?func=loadplayer', 'Upload', $element);
echo "FORMAT der Spielerdatei" . "<div class=\"code\"><pre>\r\nPassNummer;Vorname;Nachname;Geburtstag;Geschlecht;Nation;Stadt;PLZ;Strasse;Tel1;Tel2;email;Kommentar\r\nA234567;Max;Muster;1968-03-24;H;AUT;Wien;1050;Feldg.3/11;0676 234567;+436991234;max@mail.at;Sinnloser Kommentar\r\n</pre></div>";
debug('Die Spieler werden mittels der Spielerpassnummer identifiziert und synchronisiert, handelt es sich um eine unbekannte Passnummer so wird ein neuer Spieler angelegt.');
$element = ' Mitgliedsart: ' . Select_Membertype('mtype', 1, '', 0);
echo '<h3>Mitgliedschaften</h3>';
echo LS_uploaddialog('Upload Player / Membership Records', $gatecode . '?func=loadmember', 'Upload', $element);
echo 'FORMAT of PAYMENTS File' . '<div class=\'code\'><pre>
Passnummer;DatumAnfang;DatumEnde;Nachname;Vorname;ZVRVerein
1010345;2007-01-01;2007-12-31;Muster;Fred;2007/34/08
1010346;2007-01-01;2007-12-31;Huber;Walter;1234567-AT
</pre></div><br/>';
debug('Liste aller Vereine eines Bundeslandes (evtl. den Parameter P1 ändern): <a href=\'query.php?name=allvereinbyblcode&p1=1\' target=\'_blank\'>LINK</a>');
echo '<h3>SSI Resultate</h3>';
echo LS_uploaddialog('Upload/Process League System OutputFile for SSI', $gatecode . '?func=loadgames', 'Upload');
echo 'FORMAT für den SSI Spiele Upload' . '<div class=\'code\'><pre>
event match matchdate Beschreibung Runde Spiel MatchKey ID Nachname Vorname Legs
51 712 2006-09-14 WDV 1.Liga R 1 6078 e51r1h269a268 360 KNAPP Thomas 3
51 712 2006-09-14 WDV 1.Liga R 1 6078 e51r1h269a268 136 RIHS Roland 0
</pre></div><br/>';
}
<?php
/*
* make sure that idnames are syncronized between player,wfplayer,membership forms
* some js-functions are shared ...
*/
if (isset($WFPLAYERFORM_READONLY)) {
$input_flag = 2;
} else {
$input_flag = 1;
}
$OUT = "<table width=\"100%\" cellpadding=\"2\" cellspacing=\"2\">" . "<tr><td valign=\"top\" class=\"bluebox\" width=\"150\">PID / WFPID</td>" . "<td width=\"200\">" . _input(2, 'pid', $obj['pid'], 6, 6) . _input(2, 'wfpid', $obj['wfplayer_id'], 6, 6) . '</td>' . "<td valign=\"top\" class=\"bluebox\" width=\"150\">Meldeart *</td>" . "<td>" . Select_Membertype('mtype', $obj['ttypemember_id']) . '</td></tr>';
$OUT = $OUT . '<tr><td valign="top" class="bluebox">Neuer Pass</td>' . '<td>' . _button('Generate Pass', 'genautopass()') . '</td>' . '<td valign="top" class="bluebox">Auto PassNr.</td>' . '<td>' . _input(2, 'vpassnr', $obj['ppassnr'], 12, 20) . '</td></tr>';
$OUT = $OUT . "<tr><td valign=\"top\" class=\"bluebox\">Vorname *</td>" . "<td>" . _input($input_flag, 'wffname', $obj['pfname'], 30, 40) . '</td>' . "<td valign=\"top\" class=\"bluebox\">Nachname *</td>" . "<td>" . _input($input_flag, 'wflname', $obj['plname'], 30, 40) . "</td></tr>" . "<tr><td valign=\"top\" class=\"bluebox\">Geb. Datum * (yyyy-mm-dd)</td>" . "<td>" . _input($input_flag, 'wfbirthdate', $obj['pbirthdate'], 30, 20) . '</td>' . "<td valign=\"top\" class=\"bluebox\" width=\"150\">Geschlecht (H/D/J)</td>" . "<td width=\"200\">" . Select_Gender('vgender', $obj['pgender']) . "</td></tr>" . "<tr><td colspan=\"4\"><hr></td></tr>" . "<tr><td valign=\"top\" class=\"bluebox\">PLZ</td>" . "<td>" . _input($input_flag, 'wfplz', $obj['pplz'], 30, 20) . '</td>' . "<td valign=\"top\" class=\"bluebox\">Stadt</td>" . "<td>" . _input($input_flag, 'wftown', $obj['ptown'], 30, 40) . "</td></tr>" . "<tr>" . "<td valign=\"top\" class=\"bluebox\">Strasse</td>" . "<td colspan=3>" . _input($input_flag, 'wfstreet', $obj['pstreet'], 60, 40) . "</td></tr>" . "<tr><td valign=\"top\" class=\"bluebox\">Tel</td>" . "<td>" . _input($input_flag, 'wftel1', $obj['ptel1'], 30, 20) . '</td>' . "<td valign=\"top\" class=\"bluebox\">E-mail</td>" . "<td>" . _input($input_flag, 'wfemail', $obj['pemail'], 30, 40) . "</td></tr>" . '<tr>' . '<td valign="top" class="bluebox">Kommentar</td>' . '<td colspan="2">' . _input($input_flag, 'pcomment', $obj['pcomment'], 60, 60) . '</td>' . '<td></td></tr>';
$OUT = $OUT . '</table><div id="check"><table class="tchild" id="lineupP' . $obj['pid'] . '" name="lineupP' . $obj['pid'] . '">';
# ////////////////////// inject the master child table here ...'
#$RS1=DB_listEventWFTeamPlayers($dbi,1,$obj['pid']);
#$RS2=DB_listEventTeamWFPlayers($dbi,1,$obj['pid']);
#$RS=array_merge($RS1,$RS2);
#if (!sizeof($RS)>0) return ('<font color=green>Keine Mannschaftsmeldungen für Spieler:'.$obj['pid'].'</font>');
#$aTH=array('LigaGruppe','Bewerb / Liga','Saison','Teamname','Vorname','Nachname',);
#$OUT=$OUT.'';
#$OUT=$OUT.ArrayToTableHead($aTH);
#$OUT=$OUT.RecordsetToDataTable($RS,array(1,3,4,6,8,9));
# ////////////////////
return $OUT . '</table></div>';
<?php
/*
* define the membership form to be used as an embedded child detail.
* no action buttons, simple table
*/
$FRM = '<table width="100%" cellpadding="2" cellspacing="2">' . '<tr><td valign="top" class="bluebox">Pass Nr.</td>' . '<td><table><tr><td>' . _input(1, 'vpassnr', $aMEM['mpassnr'], 30, 10) . '</td><td>' . _button('Generate Pass', 'genautopass()') . '</td></tr></table></td>' . '<td valign="top" class="bluebox">Meldung</td>' . '<td>' . Select_Membertype('mtype', $aMEM['mtype'], 'setmdate(this)', 0) . '</td></tr>' . '<tr><tr><td valign="top" class="bluebox">Verein</td>' . '<td>' . Select_Verein('vid', $aMEM['mvereinid'], $usertoken['registermap'], '', 0) . '</td>' . '<td valign="top" class="bluebox">Beginn</td>' . '<td>' . _input(1, 'vmstart', $aMEM['mstart'], 14, 12) . '</td>' . '<td valign="top" class="bluebox">Ende</td>' . '<td>' . _input(1, 'vmend', $aMEM['mend'], 14, 12) . '</td></tr>' . '<tr><td colspan="2">Last modification by: ' . $aMEM['mcre_user'] . ' on ' . $aMEM['mcre_date'] . '</td>' . '<td>' . _input(0, 'vmid', $aMEM['mid']) . _input(0, 'vpid', $aMEM['mpid']) . '</td></tr>';
return $FRM . '</table>';
<?php
/**
* purpose: render form to search players+membership records
* params: none
* returns: form
* code: lsdbfunc.js::listmembers()
*/
$ret = 'Zeige Meldungen:<br />';
$ret = $ret . Select_RealmFromRegisterMap('vrealm', 0, 'listmemberr()') . Select_Membertype('mtyper', 1, 'listmemberr()', 0);
$ret = $ret . '<br />' . _checkbox('mcurrent', 1, 'Nur Aktuelle');
return $ret;
#$OUT=$OUT._button('Zeige Liste','listmemberr()');
function _editverein($vvid)
{
//
// v02 BH 09.2005
// added homepagelink 02.2007
//
/*
* added user.verein access layer ...
*/
global $dbi, $vereinsdb, $sctdcolor, $dartred, $dartgreen, $usertoken;
/*
* fetch Verein DATA
*/
$precord = mysql_query('select * from tverein where vid=' . $vvid);
$vereininfo = mysql_fetch_array($precord);
// this is a case sensitive array !!!
if (mysql_num_rows($precord) == 0) {
die('<h3>Error:V0:VereinNotFound=' . $vvid . '</h3>');
}
/*
* check ACCESS
*/
switch ($usertoken['usertype_id']) {
case '1':
die('<h3>Error:V1:Type=' . $usertoken['usertype_id']) . '</h3>';
break;
case '2':
if (!$usertoken['verein_id'] == $vvid) {
die('<h3>Error:V2:WrongVerein</h3>');
}
break;
default:
if (sizeof($usertoken['registermap']) < 1) {
die('<h3>Error:V3:Size:0</h3>');
}
if ($usertoken['registermap'][$vereininfo['verband_id']] < 2) {
die('<h3>No rights in ' . $vereininfo['verband_id'] . '...</h3>');
}
if ($usertoken['usertype_id'] == 5 || $usertoken['usertype_id'] == 6) {
echo '<script language=\'JavaScript\' src=\'code/account.js\'></script>';
}
break;
}
/*
* Start OUTPUT
*/
setPageTitle('Vereins Eintrag Bearbeiten');
// Vereinsformular
OpenTable();
echo '<form action="' . $vereinsdb . '?func=save&vvid=' . $vvid . '" method="post">';
echo form_Verein($vereininfo);
echo '</form>';
CloseTable();
// Account Line + Button
if ($usertoken['usertype_id'] == 5 || $usertoken['usertype_id'] == 6) {
echo '<div id="pnladmin">';
OpenTable();
echo include 'forms/vereinsaccount.php';
CloseTable();
echo '</div>';
}
// CHILD INFO
echo '<h3>Aktive Teams</h3><div class="child">';
$RS = DB_listTeams($dbi, 0, 0, '', 1, '', $vereininfo['vid']);
echo RecordsetToSelectOptionList($RS, array(4, 2, 5), 'teamid', 0, 'getlineup(this.value)') . ' Wähle ein Team um die Aufstellung anzuzeigen.';
echo '<div id="lineUp"></div></div>';
echo '<h3>Aktuelle Mitglieder</h3><div class="child">';
echo Select_Membertype('mtype', 1, 'listmemberv(this.value)', 0) . ' Wähle eine Mitgliedsart um die aktuellen Mitglieder anzuzeigen.';
echo '<div id="frmMember"></div>';
echo '<div id="memberv"></div></div>';
}