PHP configureDateTables函数代码示例

 * Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
 * Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
 */
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['jobs']) {
    header('Location: admin.php');
    die('No acces');
}
$sprache = getlanguagefile('api', $user_language, $reseller_id);
if ($ui->w('action', 4, 'post') and !token(true)) {
    $template_file = $spracheResponse->token;
} else {
    if ($ui->w('action', 4, 'post') == 'dl' and !$ui->id('id', 19, 'get')) {
        $i = 0;
        if ($ui->id('id', 19, 'post')) {
            foreach ($ui->id('id', 19, 'post') as $id) {
                if ($reseller_id == 0) {
                    $delete = $sql->prepare("DELETE FROM `jobs` WHERE `jobID`=? LIMIT 1");
                    $delete->execute(array($id));
                } else {
                    $delete = $sql->prepare("DELETE FROM `jobs` WHERE `jobID`=? AND `resellerID`=? LIMIT 1");
                    $delete->execute(array($id, $reseller_id));
                }
                $i++;
            }
        }
        $template_file = $i . ' ' . $gsprache->jobs . ' deleted';
    } else {
        configureDateTables('-1', '0, "desc"', 'ajax.php?w=datatable&d=joblog');
        $template_file = 'admin_jobs_list.tpl';
    }
}

            $dns = $row['dns'];
            $tsdnsRootID = $row['tsdnsID'];
            $deleteDNS = $row['ip'] . ' ' . $row['port'] . ' ' . $row['dns'];
        }
        $serverFound = $query->rowCount();
        if ($ui->st('action', 'post') == 'dl' and count($errors) == 0 and $serverFound > 0) {
            $query = $sql->prepare("SELECT *,AES_DECRYPT(`ssh2port`,:aeskey) AS `decryptedssh2port`,AES_DECRYPT(`ssh2user`,:aeskey) AS `decryptedssh2user`,AES_DECRYPT(`ssh2password`,:aeskey) AS `decryptedssh2password` FROM `voice_tsdns` WHERE `active`='Y' AND `id`=:id AND `resellerid`=:reseller_id LIMIT 1");
            $query->execute(array(':aeskey' => $aeskey, ':id' => $tsdnsRootID, ':reseller_id' => $resellerLockupID));
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $dnsReturn = tsdns('dl', $row['ssh2ip'], $row['decryptedssh2port'], $row['decryptedssh2user'], $row['publickey'], $row['keyname'], $row['decryptedssh2password'], 0, $row['serverdir'], $row['bitversion'], array($ip), array($port), array($dns), $resellerLockupID);
            }
            $query = $sql->prepare("DELETE FROM `voice_dns` WHERE `dnsID`=? AND `resellerid`=? LIMIT 1");
            $query->execute(array($id, $resellerLockupID));
            if ($query->rowCount() > 0) {
                $loguseraction = '%del% %tsdns% %dns% ' . $deleteDNS;
                $insertlog->execute();
                $template_file = $spracheResponse->table_del;
            } else {
                $template_file = $spracheResponse->error_table;
            }
        }
        // Nothing submitted yet or csfr error, display the delete form
        if (!$ui->st('action', 'post') or count($errors) != 0) {
            // Check if we could find an entry and if not display 404 page
            $template_file = $serverFound > 0 ? 'admin_voice_dns_dl.tpl' : 'admin_404.tpl';
        }
    } else {
        configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=tsdns');
        $template_file = 'admin_voice_dns_list.tpl';
    }
}

                        $query = $sql->prepare("DELETE FROM `gserver_file_templates` WHERE `templateID`=? AND `userID`=? AND `resellerID`=? LIMIT 1");
                        $query->execute(array($id, $user_id, $resellerLockupID));
                    }
                    if ($query->rowCount() > 0) {
                        $loguseraction = '%del% %template% ' . $name;
                        $insertlog->execute();
                        $template_file = $spracheResponse->table_del;
                    } else {
                        $template_file = $spracheResponse->error_table;
                    }
                } else {
                    $template_file = 'admin_404.tpl';
                }
            }
        } else {
            $table = array();
            if (isset($adminInclude)) {
                $query = $sql->prepare("SELECT `templateID`,`name`,`servertype` FROM `gserver_file_templates` WHERE `userID` IS NULL AND `resellerID`=?");
                $query->execute(array($resellerLockupID));
            } else {
                $query = $sql->prepare("SELECT `templateID`,`name`,`servertype` FROM `gserver_file_templates` WHERE `userID`=? AND `resellerID`=?");
                $query->execute(array($user_id, $resellerLockupID));
            }
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $table[] = array('id' => $row['templateID'], 'name' => $row['name'], 'servertype' => $row['servertype']);
            }
            configureDateTables('-1, -2');
            $template_file = 'global_gserver_file_template_list.tpl';
        }
    }
}

 *
 * Easy-WI is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with Easy-WI.  If not, see <http://www.gnu.org/licenses/>.
 *
 * Diese Datei ist Teil von Easy-WI.
 *
 * Easy-WI ist Freie Software: Sie koennen es unter den Bedingungen
 * der GNU General Public License, wie von der Free Software Foundation,
 * Version 3 der Lizenz oder (nach Ihrer Wahl) jeder spaeteren
 * veroeffentlichten Version, weiterverbreiten und/oder modifizieren.
 *
 * Easy-WI wird in der Hoffnung, dass es nuetzlich sein wird, aber
 * OHNE JEDE GEWAEHELEISTUNG, bereitgestellt; sogar ohne die implizite
 * Gewaehrleistung der MARKTFAEHIGKEIT oder EIGNUNG FUER EINEN BESTIMMTEN ZWECK.
 * Siehe die GNU General Public License fuer weitere Details.
 *
 * Sie sollten eine Kopie der GNU General Public License zusammen mit diesem
 * Programm erhalten haben. Wenn nicht, siehe <http://www.gnu.org/licenses/>.
 */
if (!isset($admin_id) or $main != 1 or isset($admin_id) and !$pa['log']) {
    header('Location: admin.php');
    die('No Access');
}
$sprache = getlanguagefile('logs', $user_language, $reseller_id);
configureDateTables('', '0, "desc"', 'ajax.php?w=datatable&d=adminuserlog');
$template_file = 'admin_logs.tpl';

                    $query = $sql->prepare("DELETE FROM `userdata_social_providers` WHERE `serviceProviderID`=? AND `resellerID`=? LIMIT 1");
                    $query->execute(array($id, $resellerLockupID));
                    // Check if a row was affected meaning an entry could be deleted. If yes add log entry and display success message
                    if ($query->rowCount() > 0) {
                        $query = $sql->prepare("DELETE FROM `userdata_social_identities` WHERE `serviceProviderID`=? AND `resellerID`=? LIMIT 1");
                        $query->execute(array($id, $resellerLockupID));
                        $template_file = $spracheResponse->table_del;
                        $loguseraction = '%del% Social Provider ' . $name;
                        $insertlog->execute();
                        // Nothing was deleted, display an error
                    } else {
                        $template_file = $spracheResponse->error_table;
                    }
                    // GET Request did not add up. Display 404 error.
                } else {
                    $template_file = 'admin_404.tpl';
                }
            }
            // List the available entries
        } else {
            $table = array();
            $query = $sql->prepare("SELECT `serviceProviderID`,`active`,`filename`  FROM `userdata_social_providers` WHERE `resellerID`=?");
            $query->execute(array($resellerLockupID));
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $table[] = array('id' => $row['serviceProviderID'], 'active' => $row['active'], 'name' => $row['filename']);
            }
            configureDateTables('-1');
            $template_file = 'admin_social_provider_list.tpl';
        }
    }
}

            } else {
                if ($ui->st('action', 'post') == 'dl' and isset($name)) {
                    $query = $sql->prepare("DELETE FROM `custom_columns_settings` WHERE `customID`=? LIMIT 1");
                    $query->execute(array($id));
                    if ($query->rowCount() > 0) {
                        $query = $sql->prepare("DELETE FROM `custom_columns` WHERE `customID`=?");
                        $query->execute(array($id));
                        $query = $sql->prepare("DELETE FROM `translations` WHERE `type`='cc' AND `transID`=?");
                        $query->execute(array($id));
                        $loguseraction = "%del% Custom Column {$name}";
                        $insertlog->execute();
                        $template_file = $spracheResponse->table_del;
                    } else {
                        $template_file = $spracheResponse->error_table;
                    }
                } else {
                    $template_file = 'admin_404.tpl';
                }
            }
        } else {
            $table = array();
            $query = $sql->prepare("SELECT * FROM `custom_columns_settings`");
            $query->execute();
            while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                $table[] = array('id' => $row['customID'], 'active' => $row['active'], 'name' => $row['name'], 'type' => $row['type'] == 'I' ? $sprache->int : $sprache->var);
            }
            configureDateTables('-1', '1, "desc"');
            $template_file = 'admin_settings_columns_list.tpl';
        }
    }
}

                $email = $row['email'];
                $homepage = $row['homepage'];
                $ip = $row['ip'];
                $dns = $row['dns'];
                $markedSpam = $row['markedSpam'];
                $spamReason = $row['spamReason'];
                $moderateAccepted = $row['moderateAccepted'];
            }
            if (isset($comment)) {
                $template_file = 'admin_page_comments_md.tpl';
            } else {
                $template_file = 'admin_404.tpl';
            }
        } else {
            if ($ui->st('d', 'get') == 'dl' and $ui->id('id', 19, 'get')) {
                $query = $sql->prepare("DELETE FROM `page_comments` WHERE `commentID`=? AND `resellerID`=? LIMIT 1");
                $query->execute(array($ui->id('id', 19, 'get'), $reseller_id));
                if ($query->rowCount() > 0) {
                    $loguseraction = '%del% %comment% ' . $ui->id('id', 19, 'get');
                    $insertlog->execute();
                    $template_file = $spracheResponse->table_del;
                } else {
                    $template_file = $spracheResponse->error_table;
                }
            } else {
                configureDateTables('-1', '1, "desc"', 'ajax.php?w=datatable&d=pagecomments');
                $template_file = 'admin_page_comments_list.tpl';
            }
        }
    }
}

                    $query = $sql->prepare("SELECT `description` FROM `servertypes` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                    $query->execute(array($id, $resellerLockupID));
                    $description = $query->fetchColumn();
                    $template_file = $description != '' ? 'admin_images_dl.tpl' : 'admin_404.tpl';
                } else {
                    if ($ui->st('action', 'post') == 'dl') {
                        $query = $sql->prepare("SELECT `shorten` FROM `servertypes` WHERE id=? AND resellerid=? LIMIT 1");
                        $query->execute(array($id, $resellerLockupID));
                        $shorten = $query->fetchColumn();
                        $query = $sql->prepare("DELETE FROM `servertypes` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                        $query->execute(array($id, $resellerLockupID));
                        if ($query->rowCount() > 0) {
                            $loguseraction = '%del% %template% ' . $shorten;
                            $insertlog->execute();
                            $template_file = $spracheResponse->table_del;
                        } else {
                            $template_file = $spracheResponse->error_table;
                        }
                        $query = $sql->prepare("DELETE FROM `rservermasterg` WHERE `servertypeid`=? AND `resellerid`=? LIMIT 1");
                        $query->execute(array($id, $resellerLockupID));
                    } else {
                        $template_file = 'admin_404.tpl';
                    }
                }
            } else {
                configureDateTables('-1', '0, "asc"', 'ajax.php?w=datatable&d=gameimages');
                $template_file = 'admin_images_list.tpl';
            }
        }
    }
}

                                $queryip = $row['ssh2ip'];
                                $ssh2port = $row['decryptedssh2port'];
                                $ssh2user = $row['decryptedssh2user'];
                                $ssh2password = $row['decryptedssh2password'];
                                $serverdir = $row['serverdir'];
                                $keyname = $row['keyname'];
                                $bitversion = $row['bitversion'];
                            }
                        }
                        tsdns('dl', $queryip, $ssh2port, $ssh2user, $publickey, $keyname, $ssh2password, $mnotified, $serverdir, $bitversion, array($ip), array($port), array($dns), $resellerLockupID);
                    }
                } else {
                    if ($ui->w('safeDelete', 1, 'post') == 'S' and (!isset($errorcode) or strpos($errorcode, 'error id=0') === false)) {
                        $template_file = isset($errorcode) ? 'Error: ' . $errorcode : 'Error: Could not connect to TS3 masterserver';
                    } else {
                        $template_file = $spracheResponse->error_table;
                    }
                }
            }
            // Nothing submitted yet or csfr error, display the delete form
            if (!$ui->st('action', 'post') or count($errors) != 0) {
                // Check if we could find an entry and if not display 404 page
                $template_file = $serverFound > 0 ? 'admin_voiceserver_dl.tpl' : 'admin_404.tpl';
            }
            // List the available entries
        } else {
            configureDateTables('-1, -2, -3', '1, "asc"', 'ajax.php?w=datatable&d=voiceserver');
            $template_file = 'admin_voiceserver_list.tpl';
        }
    }
}

                    if ($ui->st('action', 'post') == 'ri') {
                        $mailData = array('userId' => $row['uid'], 'name' => strlen($description) > 0 ? $description : $row['dbname'], 'mailConnectInfo' => array('ip' => $row['user_connect_ip'], 'port' => $row['port']));
                        $remotesql->AddDB($mailData, $row['dbname'], $row['decryptedpassword'], $row['ips'], $row['max_queries_per_hour'], $row['max_connections_per_hour'], $row['max_updates_per_hour'], $row['max_userconnections_per_hour']);
                        $loguseraction = '%ri% MYSQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
                        $template_file = $spracheResponse->reinstall_success;
                    } else {
                        $query2 = $sql->prepare("DELETE FROM `mysql_external_dbs` WHERE `id`=? AND `resellerid`=? LIMIT 1");
                        $query2->execute(array($id, $resellerLockupID));
                        customColumns('D', $id, 'del');
                        $loguseraction = '%del% MySQL DB ' . $row['dbname'] . ' (' . $row['ip'] . ')';
                        $template_file = $spracheResponse->table_del;
                    }
                    $insertlog->execute();
                } else {
                    $template_file = $remotesql->error;
                }
            }
        }
        // Nothing submitted yet or csfr error, display the delete form
        if (!$ui->st('action', 'post') or count($errors) != 0 and $serverFound > 0) {
            $template_file = $ui->st('d', 'get') == 'ri' ? 'admin_mysql_db_ri.tpl' : 'admin_mysql_db_dl.tpl';
        }
        // Check if we could find an entry and if not display 404 page
        if (!isset($template_file)) {
            $template_file = 'admin_404.tpl';
        }
    } else {
        configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=mysqldb');
        $template_file = 'admin_mysql_db_list.tpl';
    }
}

                    $pages[] = $start == $selectpage ? '<a href="admin.php?w=ad&amp;d=md&amp;o=' . $o . '&amp;a=' . $amount . '&p=' . $selectpage . '" class="bold">' . $i . '</a>' : '<a href="admin.php?w=ad&amp;d=md&amp;o=' . $o . '&amp;a=' . $amount . '&p=' . $selectpage . '">' . $i . '</a>';
                    $i++;
                }
                $pages = implode(', ', $pages);
                $query = $sql->prepare("SELECT `id`,`menudescription`,`active`,`type` FROM `addons` WHERE `resellerid`=? ORDER BY {$orderby} LIMIT {$start},{$amount}");
                $query2 = $sql->prepare("SELECT GROUP_CONCAT(DISTINCT s.`shorten` ORDER BY s.`shorten` ASC SEPARATOR ', ') AS `list`, COUNT(s.`id`) AS `amount` FROM `addons_allowed` AS a INNER JOIN `servertypes` AS s ON a.`servertype_id`=s.`id` WHERE a.`addon_id`=? AND s.`resellerid`=?");
                $query->execute(array($reseller_id));
                while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
                    $gamesList = '(0)';
                    if ($row['active'] == 'Y') {
                        $imgName = '16_ok';
                        $imgAlt = 'Active';
                    } else {
                        $imgName = '16_bad';
                        $imgAlt = 'Inactive';
                    }
                    $query2->execute(array($row['id'], $reseller_id));
                    while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
                        $gamesList = '(' . $row2['amount'] . ') ' . $row2['list'];
                    }
                    if (strlen($gamesList) > 40) {
                        $gamesList = substr($gamesList, 0, 40) . '...';
                    }
                    $table[] = array('id' => $row['id'], 'active' => $row['active'], 'img' => $imgName, 'alt' => $imgAlt, 'gametype' => $gamesList, 'description' => $row['menudescription'], 'type' => $row['type'] == 'map' ? $sprache->map : $sprache->tool);
                }
                configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=gameserveraddons');
                $template_file = 'admin_addons_list.tpl';
            }
        }
    }
}

                $dns = strlen($row['description']) == 0 ? 'web-' . $id : $row['description'];
            }
            // Nothing submitted yet, display the delete form
            if (!$ui->st('action', 'post')) {
                // Check if we could find an entry and if not display 404 page
                $template_file = $query->rowCount() > 0 ? 'admin_web_vhost_ri.tpl' : 'admin_404.tpl';
                // User submitted remove the entry
            } else {
                if ($ui->st('action', 'post') == 'ri') {
                    $vhostObject = new HttpdManagement($webMasterID, $resellerLockupID);
                    if ($vhostObject != false and $vhostObject->ssh2Connect() and $vhostObject->sftpConnect()) {
                        $vhostObject->vhostReinstall($id);
                        $vhostObject->restartHttpdServer();
                        $template_file = $spracheResponse->table_del;
                        $loguseraction = '%ri% %webvhost% ' . $dns;
                        $insertlog->execute();
                    } else {
                        $template_file = $spracheResponse->error_table;
                    }
                    // GET Request did not add up. Display 404 error.
                } else {
                    $template_file = 'admin_404.tpl';
                }
            }
            // List the available entries
        } else {
            configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=webvhost');
            $template_file = 'admin_web_vhost_list.tpl';
        }
    }
}

                        }
                        if ($row['state'] == 'A') {
                            $status = $sprache->status_author;
                        } else {
                            if ($row['state'] == 'C') {
                                $status = $sprache->status_confirmed;
                            } else {
                                if ($row['state'] == 'D') {
                                    $status = $sprache->status_done;
                                } else {
                                    if ($row['state'] == 'N') {
                                        $status = $sprache->status_new;
                                    } else {
                                        if ($row['state'] == 'P') {
                                            $status = $sprache->status_process;
                                        } else {
                                            $status = $sprache->status_reopen;
                                        }
                                    }
                                }
                            }
                        }
                        $table[] = array('id' => $row['id'], 'priority' => $priority, 'userPriority' => $userPriority, 'writedate' => $row['writedate'], 'supporter' => trim($row['supportername']) != '' ? trim($row['supportername']) : $row['supporter'], 'user_id' => $row['userid'], 'user' => trim($row['username']) != '' ? trim($row['username']) : $row['cname'], 'subject' => $topic, 'status' => $status, 'rawState' => $row['state']);
                    }
                    configureDateTables('-1', '1, "DESC"');
                    $template_file = "admin_tickets_list.tpl";
                }
            }
        }
    }
}

                $released = $row['released'] == 1 ? $gsprache->yes : $gsprache->no;
                $query2->execute(array($row['authorid'], $resellerLockupID));
                while ($row2 = $query2->fetch(PDO::FETCH_ASSOC)) {
                    $author = (($row2['name'] == '' or $row2['name'] == null) and ($row2['vname'] == '' or $row2['vname'] == null)) ? $row2['cname'] : $row2['vname'] . ' ' . $row2['name'];
                }
                unset($p_languages);
                $query3->execute(array($row['id'], $resellerLockupID));
                while ($row3 = $query3->fetch(PDO::FETCH_ASSOC)) {
                    $p_languages[] = $row3['language'];
                }
                if (($row['title'] == null or $row['title'] == '') and isset($p_languages[0])) {
                    $query4->execute(array($row['id'], $p_languages[0], $resellerLockupID));
                    $page_title = $query4->fetchColumn();
                } else {
                    if ($row['title'] == null or $row['title'] == '') {
                        $page_title = '';
                        $p_languages = array();
                    }
                }
                if ($row['subpage'] != $row['id']) {
                    $page_title = ' - ' . $page_title;
                }
                $link = $seo == 'N' ? $page_url . '/index.php?site=page&id=' . $row['id'] : $page_url . '/' . $row['language'] . '/' . strtolower(szrp($row['title'])) . '/';
                $date = $user_language == 'de' ? date('d.m.Y H:m:s', strtotime($row['date'])) : $row['date'];
                $table[] = array('id' => $row['id'], 'author' => $author, 'date' => $date, 'released' => $released, 'title' => $page_title, 'link' => $link, 'languages' => $p_languages, 'sort' => $row['sort']);
            }
            configureDateTables('-1, -2', '1, "asc"');
            $template_file = 'admin_page_pages_list.tpl';
        }
    }
}

                                    $appServer->removeApp($removeTemplates);
                                }
                                $query2->execute(array($serverID));
                                while ($row = $query2->fetch(PDO::FETCH_ASSOC)) {
                                    $started[] = $row['serverip'] . ':' . $row['port'];
                                    $appServer->addApp(array(), true);
                                }
                            }
                            if (count($started) > 0) {
                                $template_file = $gsSprache->reinstall . ': ' . implode('<br>', $started);
                                $appServer->execute();
                                if (isset($dbConnect['debug']) and $dbConnect['debug'] == 1) {
                                    $template_file .= '<br><pre>' . implode("\r\n", $appServer->debug()) . '</pre>';
                                }
                            } else {
                                $template_file = 'admin_404.tpl';
                            }
                        } else {
                            $template_file = 'admin_404.tpl';
                        }
                    }
                } else {
                    $template_file = 'admin_404.tpl';
                }
            } else {
                configureDateTables('-1', '1, "asc"', 'ajax.php?w=datatable&d=appserver');
                $template_file = 'admin_roots_list.tpl';
            }
        }
    }
}