<?php require_once '../../includes/ssl.php'; if (!empty($_SESSION['auth'])) { header('Location:' . LINKADRLISTS); } $fileInfo = array('title' => 'Join', 'fileName' => 'join/index.php'); $debug->newFile($fileInfo['fileName']); $buildPage = new Adrlist_BuildPage(); $buildPage->addIncludes('joinMethods.php'); $buildPage->addJs(array('join.js', 'https://www.google.com/recaptcha/api/js/recaptcha_ajax.js')); /* if(!isset($_GET['invitationCode'])){ $buildPage->addJs('http://www.google.com/recaptcha/api/js/recaptcha_ajax.js'); } */ echo $buildPage->output(), ' <div class="layout" id="main"> <div class="textCenter textXlarge"> ', $fileInfo['title'], ' </div> <div class="textCenter red" id="responseElement"> ', $message, ' </div> <noscript class="red textCenter">Javascript is required.</noscript> <div id="joinUser" style="display:none"> ', buildJoin(), ' </div> </div> ', $buildPage->buildFooter();
function buildJoin($hier) { foreach ($hier->Join as $join) { $i = 0; $left = $join['leftKey']; $right = $join['rightKey']; $alias = $join['rightAlias']; foreach ($join->Table as $table) { $t[$i] = $table['name']; $i = $i + 1; } if ($i == 2) { $strJoin = " right join {$t['1']} on {$t['0']}.{$left}={$t['1']}.{$right}"; return $strJoin; } else { $strJoin = " right join {$alias} on {$t['0']}.{$left}={$alias}.{$right} " . buildJoin($join); return $strJoin; } } }