function ExportCSVCard($sep)
{
global $db, $config, $func, $party;
include_once "modules/seating/class_seat.php";
$seat2 = new seat2();
$user_export = $config['lansuite']['version'] . " CSV Export\r\nParty: " . $config['lanparty']['name'] . "\r\nExportdate: " . $func->unixstamp2date(time(), 'daydatetime') . "\r\n\r\n";
$user_export .= "username;name;firstname;clan;seatblock;col;row;seat;ip\n";
$query = $db->qry("SELECT s.* FROM %prefix%seat_seats AS s\n LEFT JOIN %prefix%seat_block AS b ON s.blockid = b.blockid\n WHERE b.party_id = %int% AND s.status = 2\n ORDER BY s.blockid", $party->party_id);
while ($row_seat = $db->fetch_array($query)) {
$userid = $row_seat["userid"];
$row = $db->qry_first("SELECT u.*, c.name AS clan, c.url AS clanurl, p.paid, p.checkin, p.checkout, p.signondate, p.seatcontrol\n FROM %prefix%user AS u\n LEFT JOIN %prefix%party_user AS p ON p.user_id = u.userid\n \t\t\tLEFT JOIN %prefix%clan AS c ON u.clanid = c.clanid\n WHERE u.userid=%int%\n ", $userid);
$username = str_replace(">", "", $row["username"]);
$username = str_replace("<", "", $username);
$username = str_replace(">", "", $username);
$username = str_replace("<", "", $username);
$username = trim($username);
$user_export .= $username . $sep;
$user_export .= $row["name"] . $sep;
$user_export .= $row["firstname"] . $sep;
$user_export .= $row["clan"] . $sep;
$blockid = $row_seat["blockid"];
$row_block = $db->qry_first("SELECT orientation, name FROM %prefix%seat_block WHERE blockid=%int%", $blockid);
$seatindex = $seat2->CoordinateToName($row_seat["col"] + 1, $row_seat["row"], $row_block["orientation"]);
$user_export .= $row_block["name"] . $sep;
$user_export .= $row_seat["col"] . $sep;
$user_export .= $row_seat["row"] . $sep;
$user_export .= $seatindex . $sep;
$user_export .= $row_seat["ip"];
$user_export .= "\r\n";
}
// end while
return $user_export;
}
