?> </span> <table class="user-table"> <caption><img src="images/cd-page-icon.png" width="32" height="32" alt="" /><?php echo $display; ?> <small>Everything Echelon knows about <?php echo $display; ?> </small></caption> <tbody> <tr> <th>Name</th> <td><?php echo tableClean($username); ?> </td> <th>Display Name</th> <td><?php echo $display; ?> </td> </tr> <tr> <th>Email</th> <td><?php echo emailLink($email, $display); ?> </td> <th>IP Address</th>
function displayEchLog($array, $style = 'client') { global $tformat; // import the time format varible for use in this function foreach ($array as $ech_log) { ## get vars $id = $ech_log['id']; $type = $ech_log['type']; $msg = tableClean($ech_log['msg']); $time_add = $ech_log['time_add']; $time_add_read = date($tformat, $time_add); $game_id = $ech_log['game_id']; ## Page row color alternate $alter = alter(); if ($style == 'admin') { $cid = $ech_log['client_id']; $client_link = clientLink($cid, $cid, $game_id); $table = <<<EOD \t\t\t<tr class="{$alter}"> \t\t\t\t<td>{$id}</td> \t\t\t\t<td>{$type}</td> \t\t\t\t<td>{$msg}</td> \t\t\t\t<td><em>{$time_add_read}</em></td> \t\t\t\t<td>{$client_link}</td> \t\t\t</tr> EOD; } else { // if client $user_name = tableClean($ech_log['user_name']); $user_link = echUserLink($ech_log['user_id'], $user_name); $table = <<<EOD \t\t\t<tr class="{$alter}"> \t\t\t\t<td>{$id}</td> \t\t\t\t<td>{$type}</td> \t\t\t\t<td>{$msg}</td> \t\t\t\t<td><em>{$time_add_read}</em></td> \t\t\t\t<td>{$user_link}</td> \t\t\t</tr> EOD; } echo $table; // echo out the formated data } }
<th colspan="7"></th> </tr> </tfoot> <tbody> <?php if ($num_rows > 0) { // query contains stuff foreach ($data_set as $pen) { // get data from query and loop $ban_id = $pen['ban_id']; $type = $pen['type']; $time_add = $pen['time_add']; $time_expire = $pen['time_expire']; $reason = tableClean($pen['reason']); $client_id = $pen['client_id']; $client_name = tableClean($pen['name']); $duration = $pen['duration']; ## Tidt data to make more human friendly if ($time_expire != '-1') { $duration_read = time_duration($duration * 60); } else { $duration_read = ''; } $time_expire_read = timeExpirePen($time_expire); $time_add_read = date($tformat, $time_add); $reason_read = removeColorCode($reason); if ($mem->loggedIn()) { $client_name_read = clientLink($client_name, $client_id); } else { $client_name_read = $client_name; }
if ($num_rows > 0) { // query contains stuff foreach ($data_set as $data) { // get data from query and loop $type = $data['type']; $time_add = $data['time_add']; $time_expire = $data['time_expire']; $reason = tableClean($data['reason']); $pen_data = tableClean($data['data']); $duration = $data['duration']; $client_id = $data['client_id']; $client_name = tableClean($data['client_name']); if ($type_admin) { // only admin type needs these lines $admin_id = $data['admins_id']; $admin_name = tableClean($data['admins_name']); } ## Tidt data to make more human friendly if ($time_expire != '-1') { $duration_read = time_duration($duration * 60); } else { $duration_read = ''; } $time_expire_read = timeExpirePen($time_expire); $time_add_read = date($tformat, $time_add); $reason_read = removeColorCode($reason); if ($type_admin) { // admin cell only needed for admin type $admin = '<td><strong>' . clientLink($admin_name, $admin_id) . '</strong></td>'; } else { $admin = NULL;
<td><?php echo $connections; ?> </td> </tr> <tr> <th>GUID</th> <td> <?php echo guidLink($mem, $config['game']['game'], $guid); ?> </td> <th>IP Address</th> <td> <?php $ip = tableClean($ip); if ($mem->reqLevel('view_ip')) { if ($ip != "") { ?> <a href="clients.php?s=<?php echo $ip; ?> &t=ip" title="Search for other users with this IP adreess"><?php echo $ip; ?> </a> <a href="http://whois.domaintools.com/<?php echo $ip; ?> " title="Whois IP Search"><img src="images/id_card.png" width="16" height="16" alt="W" /></a>
</thead> <tfoot> <tr> <th colspan="5">Click client name to see details</th> </tr> </tfoot> <tbody> <?php if ($num_rows > 0) { foreach ($data_set as $notice) { // get data from query and loop $cname = tableClean($notice['client_name']); $cid = $notice['client_id']; $aname = tableClean($notice['admin_name']); $aid = $notice['admin_id']; $reason = tableClean($notice['reason']); $time_add = $notice['time_add']; ## Change to human readable time $time_add = date($tformat, $time_add); ## Row color $alter = alter(); $client = clientLink($cname, $cid); $admin = clientLink($aname, $aid); // setup heredoc (table data) $data = <<<EOD \t\t\t<tr class="{$alter}"> \t\t\t\t<td><strong>{$client}</strong></td> \t\t\t\t<td>@{$cid}</td> \t\t\t\t<td><em>{$time_add}</em></td> \t\t\t\t<td>{$reason}</td> \t\t\t\t<td><strong>{$admin}</strong></td>
</thead> <tfoot> <tr> <th colspan="4"></th> </tr> </tfoot> <tbody> <?php if ($num_rows > 0) { // query contains stuff foreach ($data_set as $data) { // get data from query and loop $time_add = $data['time_add']; $reason = tableClean($data['reason']); $client_id = $data['target_id']; $client_name = tableClean($data['target_name']); ## Tidt data to make more human friendly if ($time_expire != '-1') { $duration_read = time_duration($duration * 60); } else { $duration_read = ''; } $time_add_read = date($tformat, $time_add); $reason_read = removeColorCode($reason); $client_link = clientLink($client_name, $client_id); ## Row color $alter = alter(); // setup heredoc (table data) $data = <<<EOD \t\t\t<tr class="{$alter}"> \t\t\t\t<td><strong>{$client_link}</strong></td>
// bind in the client_id for the query $stmt->execute(); // run query $stmt->store_result(); // store the result - needed for the num_rows check if ($stmt->num_rows) { // if results exist $stmt->bind_result($pid, $type, $time_add, $time_expire, $reason, $data, $inactive, $duration, $admin_id, $admin_name); while ($stmt->fetch()) { // fetcht the results and store in an array // Change into readable times $time_add = date($tformat, $time_add); $time_expire_read = timeExpire($time_expire, $type, $inactive); $reason = tableClean(removeColorCode($reason)); $data = tableClean($data); $admin_name = tableClean($admin_name); if ($type_inc != 'Kick' && $type_inc != 'Notice' && $time_expire != '-1') { $duration = time_duration($duration * 60, 'yMwdhm'); } else { $duration = ''; } // Row odd/even colouring $alter = alter(); if ($admin_id != 1) { // if admin is not B3 show clientdetails link else show just the name $admin_link = '<a href="clientdetails.php?id=' . $admin_id . '" title="View the admin\'s client page">' . $admin_name . '</a>'; } else { $admin_link = $admin_name; } if ($mem->reqLevel('unban')) { // if user has access to unban show unban button
$stmt->bind_result($name); echo '<ol>'; while ($stmt->fetch()) { echo '<li onClick="fill(\'' . tableClean($name) . '\');">' . $name . '</li>'; } echo '</ol>'; } else { // if nothing try even more flexible query $query_3 = "SELECT name FROM clients WHERE SUBSTRING(SOUNDEX(name),2) = SUBSTRING(SOUNDEX('%%%" . $string . "%%%'),2) ORDER BY name LIMIT 10"; $stmt = $db->mysql->prepare($query_3); $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows) { // if something return data $stmt->bind_result($name); echo '<ol>'; while ($result = $query_3->fetch_object()) { echo '<li onClick="fill(\'' . tableClean($name) . '\');">' . $name . '</li>'; } echo '</ol>'; } else { // if nothing try even more flexible query echo '<ol><li>There are no matches to your search</li></ol>'; } // show error if nothing gotten overal } // end if two returned nothing! } // end if query one returned nothing ! echo '<ol><li>There was nothing in the search box</li></ol>'; }
<th>Time</th> </tr> </thead> <tfoot> <tr><td colspan="4"></td></tr> </tfoot> <?php // nested while loop for content if ($num_rows_[$i] > 0) { foreach ($records[$i] as $record) { //there are still rows in results $id = $record['id']; $time = date($tformat, $record['msg_time']); $type = tableClean($record['msg_type']); $msg = tableClean($record['msg']); ## Highlight Commands ## if (substr($msg, 0, 1) == '!' or substr($msg, 0, 1) == '@') { $msg = '<span class="chat-cmd">' . $msg . "</span>"; } ## Row color $alter = alter(); ## preapre heredoc $data = <<<EOD \t\t\t\t\t<tr class="{$alter}"> \t\t\t\t\t\t<td>{$id}</td> \t\t\t\t\t\t<td>{$type}</td> \t\t\t\t\t\t<td>{$msg}</td> \t\t\t\t\t\t<td><em>{$time}</em></td> \t\t\t\t\t</tr> EOD;