Ich habe das Rekrutierungsmodul von cristiang und den Raidplaner von Balthasar3K installiert.
Das Rekrutierungsmodul habe ich für mich etwas erweitert und angepasst. Jetzt habe ich aber folgendes Problem, dass die im Formular eingegebene Skillung nicht in die Datenbank eingetragen wird.
Die Formularfelder charakter[s1], charakter[s2] und charakter[s3] werden nicht in die DB-Felder skill1, skill2 und skill3 eingetragen.
Kann mir bitte jemand einen Tipp geben.
<?php
# Copyright by Cristian Gheorghiu
# Support www.cristiang.de
defined ('main') or die ( 'no direct access' );
require_once("include/includes/func/b3k_func.php");
if( isset( $_POST['kid'] ))
{ exit(classSpecialization($_POST['kid']));
}
$title = $allgAr['title'].' :: Rekrutierung';
$hmenu = 'Rekrutierung';
$design = new design ( $title , $hmenu );
$design->header();
// pruefen ob Eintraege existieren
$result_classes = db_num_rows(db_query("SELECT * FROM `prefix_wow_classes`"));
$result_recruits = db_num_rows(db_query("SELECT * FROM `prefix_wow_recruit`"));
// vorhandene Rassen in Arrays speichern
$ergebnis = db_query("SELECT * FROM `prefix_wow_race` WHERE fraction LIKE '". $allgAr['wow_fraction'] ."' ORDER BY id ASC");
while($row = db_fetch_object($ergebnis))
{
$form_races .= '<option value="'. $row->id .'">'. $row->name .'</option>';
}
// vorhandene Klassen in Arrays speichern
if( $result_classes > 0 ) {
$form_classes .= '<option>Klasse wählen!</option>';
$abf = 'SELECT a.classid, b.* FROM prefix_wow_recruit AS a, prefix_wow_classes AS b WHERE a.classid = b.id';
$ergebnis = db_query($abf);
while($row = db_fetch_object($ergebnis))
{
$wow_array_a[] = $row->id;
$wow_array_b[] = $row->name;
$wow_array_c[] = $row->icon;
$form_classes .= '<option value="'. $row->id .'">'. $row->name .'</option>';
}
$wow_class['klasse'] = array_combine($wow_array_a, $wow_array_b);
$wow_class['icon'] = array_combine($wow_array_a, $wow_array_c);
}
// vorhandene Berufe in Arrays speichern
$ergebnis = db_query("SELECT * FROM `prefix_raid_berufe` ORDER BY berufe ASC");
while($row = db_fetch_object($ergebnis))
{
$form_berufe .='<option value="'. $row->id .'">'. $row->berufe .'</option>';
$form_berufe1 .='<option value="'. $row->id .'">'. $row->berufe .'</option>';
}
// vorhandene Level in Arrays speicher
$ergebnis = db_query("SELECT * FROM `prefix_raid_level` ORDER BY level ASC");
while($row = db_fetch_object($ergebnis))
{
$form_level .='<option value="'. $row->id .'">'. $row->level .'</option>';
}
// vorhandene Realms in Arrays speichern
$ergebnis = db_query("SELECT * FROM `prefix_wow_realm` ORDER BY name ASC");
while($row = db_fetch_object($ergebnis))
{
$wow_realm[$row->id] = $row->name;
$form_server .='<option value="'. $row->id .'">'. $row->name .'</option>';
}
// vorhandene Fraktionen in Arrays speichern
$ergebnis = db_query("SELECT * FROM `prefix_wow_realm` ORDER BY id ASC");
$wow_fraktionen = array(
1 => 'PvE',
2 => 'PvP',
3 => 'WvW'
);
// Bewerbung verarbeiten
//-----------------------------------------------------//
if( !empty($_REQUEST['submit']) ) {
if( chk_antispam('recruit') ) {
$_POST['user'] = escape($_POST['user'], 'string');
$_POST['acc'] = escape($_POST['acc'], 'string');
$_POST['birth'] = escape($_POST['birth'], 'string');
$_POST['email'] = escape($_POST['email'], 'string');
$_POST['char'] = escape($_POST['char'], 'string');
$_POST['race'] = escape($_POST['race'], 'string');
$_POST['class'] = escape($_POST['class'], 'string');
$_POST['level'] = escape($_POST['level'], 'string');
/* $_POST['spz'] = "Klasse wählen!";
/* $_POST['skill'] = escape($_POST['skill'], 'integer');
$_POST['skill2'] = escape($_POST['skill2'], 'integer');
$_POST['skill3'] = escape($_POST['skill3'], 'integer');
$_POST['skill4'] = escape($_POST['skill4'], 'integer');
$_POST['skill5'] = escape($_POST['skill5'], 'integer');*/
$_POST['mberuf'] = escape($_POST['mberuf'], 'string');
$_POST['mskill'] = escape($_POST['mskill'], 'integer');
$_POST['sberuf'] = escape($_POST['sberuf'], 'string');
$_POST['sskill'] = escape($_POST['sskill'], 'integer');
$_POST['equip'] = escape($_POST['equip'], 'textarea');
$_POST['arsenalurl'] = escape($_POST['arsenalurl'], 'string');
$_POST['onlinetime'] = escape($_POST['onlinetime'], 'string');
$_POST['server'] = escape($_POST['server'], 'string');
$_POST['gameexp'] = escape($_POST['gameexp'], 'textarea');
$_POST['pvp'] = escape($_POST['pvp'], 'textarea');
$_POST['message'] = escape($_POST['message'], 'textarea');
// Alle Pflichtfelder
$result_account = false;
if (preg_match("/.\.([0-9]{4})$/", $_POST['acc'])) {
$result_account = true;
}
if( !empty($_POST['user']) and !empty($_POST['acc']) and !empty($_POST['email']) and !empty($_POST['char']) and !empty($_POST['class']) and !empty($_POST['level']) and !empty($_POST['onlinetime']) and !empty($_POST['gameexp']) and !empty($_POST['pvp']) and !empty($_POST['message']) ) {
// pruefen ob User oder eMail schon vorhanden sind und Account eingetragen wurde
$result_applikation = db_num_rows(db_query("SELECT * FROM `prefix_wow_applications` WHERE
user = '". $_POST['user'] ."' OR email = '". $_POST['email'] ."'
"));
$result_user = db_num_rows(db_query("SELECT * FROM `prefix_user` WHERE
name = '". $_POST['user'] ."' OR email = '". $_POST['email'] ."'
"));
if( $result_applikation == 0 and $result_user == 0 and $result_account == true ) {
// DB Eintrag
db_query("INSERT INTO `prefix_wow_applications` (
user,
acc,
user_age,
email,
user_char,
race,
char_class,
level,
skill1,
skill2,
skill3,
mberuf,
mskill,
sberuf,
sskill,
equip,
arsenal,
user_online,
server,
experience,
pvp,
user_message
) VALUES (
'". $_POST['user'] ."',
'". $_POST['acc'] ."',
'". $_POST['birth'] ."',
'". $_POST['email'] ."',
'". $_POST['char'] ."',
'". $_POST['race'] ."',
'". $_POST['class'] ."',
'". $_POST['level'] ."',
'". $_POST['charakter[s1]'] ."',
'". $_POST['charakter[s2]'] ."',
'". $_POST['charakter[s3]'] ."',
'". $_POST['mberuf'] ."',
'". $_POST['mskill'] ."',
'". $_POST['sberuf'] ."',
'". $_POST['sskill'] ."',
'". $_POST['equip'] ."',
'". $_POST['arsenalurl'] ."',
'". $_POST['onlinetime'] ."',
'". $_POST['server'] ."',
'". $_POST['gameexp'] ."',
'". $_POST['pvp'] ."',
'". $_POST['message'] ."'
)");
// Bestaetigungs-eMail versenden an Bewerber
$text = "Hallo ". $_POST['user'] .",
deine Bewerbung ist bei uns eingegangen.
Du bekommst eine eMail sobald wir deine Bewerbung annehmen oder ablehnen.
Mit freundlichen Grüßen
". $allgAr['allg_default_subject'];
mail($_POST['email'], 'Deine Bewerbung ist angekommen!', $text, "From: ". $allgAr['allg_default_subject'] ." <". $allgAr['adminMail'] .">");
// Bestaetigungs-eMail versenden an Admin
if( $allgAr['wow_application_email'] == 1) {
// Emailempfänger auswählen (ab Recht -5 ist Offi)
$ergebnis = db_query("SELECT * FROM `prefix_user` WHERE recht <= '-5'");
while($row = db_fetch_object($ergebnis))
{
$mail = $row->email;
$text = "Hallo,
es wurde soeben eine Bewerbung von ". $_POST['user'] ." eingereicht.
Die Bewerbung kann im Adminbereich ausgewertet werden.
Mit freundlichen Grüßen
die Gildenleitung";
mail($mail, 'Neue Bewerbung ist eingegangen!', $text, "From: ". $_POST['user'] ." <". $_POST['email'] .">"); }
}
$message = '<big><strong>Erfolg:</strong> Deine Bewerbung ist bei uns eingegangen!</big><br>';
$formular = 'leeren';
} else { $message .= '<big><strong>Fehler:</strong> Der User bzw. die eMail-Adresse existiert bereits oder der Accountname (muss einen Punkt und die 4 anschliessenden 4 Ziffern besitzen) ist nicht korrekt!</big><br>'; }
} else { $message .= '<big><strong>Fehler:</strong> Es wurden nicht alle Pflichtfelder ausgefüllt!</big><br>'; }
} else { $message .= '<big><font-color="#FE2EF7"><strong>Fehler:</strong> Der eingetragene Antispam ist falsch!</big><br>'; }
}
$tpl = new tpl ( 'recruit.htm' );
// Seite ausgeben
//-----------------------------------------------------//
// Information
$ar = array (
'fraktion_img' => $allgAr['wow_fraction'],
'gildenname' => $allgAr['wow_guild_name'],
'fraktion' => $wow_fraktionen[$allgAr['wow_fraction']],
'realm' => $wow_realm[$allgAr['wow_realm']]
);
$tpl->set_ar_out($ar, 0 );
// Rekrutierung
if( $result_recruits > 0 ) {
$tpl->out(1);
// Gesuche ausgeben
$ergebnis = db_query("SELECT * FROM `prefix_wow_recruit`");
while($row = db_fetch_object($ergebnis))
{
$tpl->out(2);
$ar['klicon'] = $wow_class['icon'][$row->classid];
$ar['klname'] = $wow_class['klasse'][$row->classid];
$ar['anzahl'] = $row->numbers;
$tpl->set_ar_out($ar, 3 );
// Positionen
if( !empty($row->position1) or !empty($row->position2) ) {
if( empty($row->position1) and empty($row->position2) ) {
$blank = "";
} elseif( !empty($row->position1) and !empty($row->position2) ) {
$blank = " / ";
} elseif( empty($row->position1) or empty($row->position2) ) {
$blank = "";
}
$class_position = $row->position1.$blank.$row->position2;
$ar['position'] = $class_position;
$tpl->set_ar_out($ar, 4 );
}
// Beschreibung
if( !empty($row->subscribe) ) {
$ar['beschreibung'] = bbcode($row->subscribe);
$tpl->set_ar_out($ar, 5 );
}
$tpl->out(6);
}
} else {
$tpl->out(1);
echo 'Wir suchen im Moment keine speziellen Klassen.';
}
// Formular ausgeben
//-----------------------------------------------------//
if ( !loggedin() and $result_recruits > 0 ) {
if( empty($_REQUEST['submit']) ) {
$ar['MESSAGE'] = '';
} else {
$ar['MESSAGE'] = '<p>'. $message .'</p>';
}
$ar['minlevel'] = $allgAr['wow_min_level'];
$ar['rasse'] = $form_races;
$ar['classes'] = $form_classes;
$ar['level'] = $form_level;
$ar['berufe'] = $form_berufe;
$ar['berufe1'] = $form_berufe1;
$ar['server'] = $form_server;
$tpl->set('ANTISPAM', get_antispam('recruit',100));
if( $formular == 'leeren' ) {
$ar['form_user'] = "";
$ar['form_acc'] = "";
$ar['form_birth'] = "";
$ar['form_email'] = "";
$ar['form_char'] = "";
$ar['spz'] = "";
/* $ar['form_skill'] = "";
$ar['form_skill2'] = "";
$ar['form_skill3'] = "";
$ar['form_skill4'] = "";
$ar['form_skill5'] = "";*/
$ar['form_mskill'] = "";
$ar['form_sskill'] = "";
$ar['form_equip'] = "";
$ar['form_arsenalurl'] = "";
$ar['form_onlinetime'] = "";
$ar['form_gameexp'] = "";
$ar['form_pvp'] = "";
$ar['form_message'] = "";
} else {
$ar['form_user'] = $_POST['user'];
$ar['form_acc'] = $_POST['acc'];
$ar['form_birth'] = $_POST['birth'];
$ar['form_email'] = $_POST['email'];
$ar['form_char'] = $_POST['char'];
$ar['form_classes'] = $_POST['class'];
$ar['spz'] = classSpecialization($charakter['class_id'], $charakter['s1'], $charakter['s2'], $charakter['s3']);
/* $ar['form_skill'] = $_POST['skill'];
$ar['form_skill2'] = $_POST['skill2'];
$ar['form_skill3'] = $_POST['skill3'];
$ar['form_skill4'] = $_POST['skill4'];
$ar['form_skill5'] = $_POST['skill5'];*/
$ar['form_mskill'] = $_POST['mskill'];
$ar['form_sskill'] = $_POST['sskill'];
$ar['form_equip'] = $_POST['equip'];
$ar['form_arsenalurl'] = $_POST['arsenalurl'];
$ar['form_onlinetime'] = $_POST['onlinetime'];
$ar['form_gameexp'] = $_POST['gameexp'];
$ar['form_pvp'] = $_POST['pvp'];
$ar['form_message'] = $_POST['message'];
}
$tpl->set_ar_out($ar, 7 );
}
echo '<p> </p><p align="center"><a href="http://www.cristiang.de" target="_blank" class="smallfont">Rekrutierungs-System © CristianG.de</a></p>';
$design->footer();
?>
<?php
require_once 'include/raidplaner/raidplaner.php';
CreatRaidSession();
$raid = new Raidplaner();
function copyright(){
echo "<br><div align='center' class='smallfont'>[ Raidplaner & DKP System v1.2.2 © by <a href='http://Balthazar3k.funpic.de' target='_blank'>Balthazar3k.funpic.de</a> ]</div>\n";
}
###### RAIDPLANER HEADER
$raid->header()
->set('font-awesome/css/font-awesome.min.css')
->set('jquery/js/jquery-1.10.2.js')
->set('jquery/js/jquery-ui-1.10.4.custom.min.js')
->set('jquery/css/ui-darkness/jquery-ui-1.10.4.custom.min.css')
->set('../../includes/css/raidplaner.css')
->set('../../includes/js/b3k.js');
$raid->header()->get('font-awesome', 'jquery', '..');
### Sessions der mainchars Generieren.
function CreatRaidSession(){
if( !loggedin() ){
$arr = array('charname', 'charid', 'charrang','charklasse','stammgrp');
foreach( $arr as $a ){
$_SESSION[$a] = '';
}
}
if( loggedin() ){
$ses = db_query( "SELECT id, name, rang, klassen FROM prefix_raid_chars WHERE user='".$_SESSION['authid']."' ORDER BY id LIMIT 1" );
$my = db_fetch_assoc($ses);
$_SESSION['charname'] = $my['name'];
$_SESSION['charid'] = $my['id'];
$_SESSION['charrang'] = $my['rang'];
$_SESSION['charklasse'] = $my['klassen'];
$_SESSION['stammgrp'][0] = 1;
if( !empty( $_SESSION['charid'] ) ){
$res = db_query("SELECT sid FROM prefix_raid_stammrechte WHERE cid=".$my['id']);
while( $row = db_fetch_object( $res )){
$_SESSION['stammgrp'][$row->sid] = 1;
}
}
### adminaccess neu mit 1.1p
$perm = db_query( "
SELECT
a.uid, a.mid, b.url
FROM prefix_modulerights AS a
LEFT JOIN prefix_modules AS b ON a.mid = b.id
WHERE
a.uid = ".$_SESSION['authid']."
AND b.name LIKE 'R:%'
");
while( $row = db_fetch_assoc( $perm ) ){
$_SESSION['adminaccess'][$row['url']] = true;
}
}else{
$_SESSION['charname'] = $_SESSION['charid'] = $_SESSION['charrang'] = $_SESSION['charklasse'] = 0;
}
}
### Raid Errors ##############################################
##############################################################
function RaidErrorMsg(){
global $allgAr;
### Raids auf Gültigkeit �berpr�fen
$res = db_query("SELECT id, ende FROM prefix_raid_raid WHERE statusmsg=1 AND ende<=".(time()-7200) );
while( $row = db_fetch_assoc( $res )){
db_query("UPDATE prefix_raid_raid SET statusmsg=17 WHERE id=".$row['id'] );
}
### Fehler nur für Admins
if( is_admin() ){
include("include/raidplaner/raidplaner.updater.php");
$updater = new updater();
$isRaidGrp = db_result(db_query('SELECT COUNT(id) FROM prefix_raid_gruppen'),0);
$error['isRaidGrp'] = ( $isRaidGrp == 0 ? 'Raidplaner: Es müssen DKP Gruppen angelegt werden, '.aLink('Anlegen','raidgruppen',1).'!' : '');
$isInzen = db_result(db_query('SELECT COUNT(id) FROM prefix_raid_inzen'),0);
$error['isInzen'] = ( $isInzen == 0 ? 'Raidplaner: Es müssen Instanzen angelegt werden, '.aLink('Anlegen','raidinzen',1).'!' : '');
}
### Fehler f�r Raidleiter, Super Raidleiter, Offizer, Gildenmeister & Admins
if( RaidPermission() ){
### Wenn's ausstehende Raids gibt wird man Informiert.
$res = db_query("SELECT id, inv FROM prefix_raid_raid WHERE statusmsg=17");
while( $row = db_fetch_assoc( $res )){
$error['chkRaids'] .= "<div align='center'>";
$error['chkRaids'] .= "ERROR: Ausstehender Raid vom: <a href='admin.php?raid-edit-".$row['id']."'>". DateFormat("D d.m.Y H:i", $row['inv'])."</a> ";
$error['chkRaids'] .= "(Status ändern!)";
$error['chkRaids'] .= "</div>";
}
}
### Ab Rang Super Raidleiter Anzeigen!
if( $_SESSION['charrang'] >= 6 ){
$cBewerber = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_chars WHERE rang=1"),0);
if( $cBewerber == 1 ){
$error['cBewerber'] = "Es liegt eine Bewerbung vor, ".alink("Ansehen","bewerbung")."!";
}elseif( $cBewerber > 1 ){
$error['cBewerber'] = "Es liegen ".$cBewerber." Bewerbungen vor, ".alink("Ansehen","bewerbung")."!";
}
}
### Charakter überprüfen!
$error['exRaidChar'] = exRaidChar(1);
$error['isRaidKalender'] = ( $allgAr['isRaidKalender'] == 0 ? '' : isRaidKalender(1) );
### Überprüfe ob es Errors gibt!
$redwindow = FALSE;
foreach( $error as $key => $value ){
if( !empty($error[$key]) or $error[$key] ){
$redwindow = TRUE;
}
}
### Errors Ausgeben wenn vorhanden
if( $redwindow ){
$i=0;
echo '
<div class="Cnorm" style="text-shadow: 1px 1px 0 #FFF; padding: 5px; border-radius: 10px; border: 5px solid red; margin-bottom: 5px;">
<h3 style="margin-top: 0;">Folgende Fehler sind aufgetreten!</h3>
<ol>
';
foreach( $error as $value ){
if( !empty( $value ) ){
$br = ( $i > 0 ? '<br>' : '' );
echo "<li style='font-weight: bold; color: darkred;'>".$value."</li>";
$i++;
}
}
echo '</ol></div>';
}
}
### Raidplaner Menu Leiste
function aRaidMenu(){
global $menu;
$raidLinks = array(
"Index" => "raidindex",
"<i class=\"fa fa-calendar fa-lg\"></i> Raidplaner" => "raid",
"<i class=\"fa fa-group\"></i> Charaktere" => "chars",
"<i class=\"fa fa-clock-o\"></i> Zeiten" => "raidzeiten",
"Klassen" => "raidclasses",
"Config" => "raidconfig",
"DKP Gruppen" => "raidgruppen",
"Stammgruppen" => "raidstammgrp",
"Instanzen" => "raidinzen",
"Bosse" => "raidbosse",
"Ränge" => "raidrang",
"Punkte (DKP)" => "raiddkps-0"
);
echo "<div class=\"buttonset btn-group btn-group-sm\">";
foreach( $raidLinks as $name => $url )
{
if( isset( $_SESSION['authmod'][$url] ) && $_SESSION['authmod'][$url] == 1 || is_admin() )
{
echo "<a class=\"btn btn-default\" href='admin.php?".$url."'>".$name."</a> ";
}
}
echo "</div><br /><br />";
}
### Ist der User Stamm?
function isStamm($i){
if( $_SESSION['stammgrp'][$i] ){
return (TRUE);
}else{
return (FALSE);
}
}
### Links
function aLink( $name, $pfad, $if=0 ){
if( $if == 0 or $if == 1 ){
return ( $if == 0 ? '<a href="index.php?'.$pfad.'">'.$name.'</a>' :'<a href="admin.php?'.$pfad.'">'.$name.'</a>');
}elseif( $if == 2 ){
return '<a href="'.$pfad.'">'.$name.'</a>';
}
}
### Design Class
function cssClass($i){
return ( $i == "Cmite" ? "Cnorm" : "Cmite" );
}
### �berpr�fen ob User einen Char hat!
function exRaidChar($is=0){
global $allgAr;
if( loggedin() and RaidRechte($allgAr['addchar']) ){
if( $_SESSION['charid'] != ''){
return ( $is == 0 ? TRUE : '');
}else{
return ( $is == 0 ? FALSE : "Sie haben kein Charakter, <a href='index.php?chars-newchar'>Erstellen</a>." );
}
}else{
return (FALSE);
}
}
### �berpr�fen ob Char Kalendereintr�ge hat wenn ein Char exestiert!
function isRaidKalender($is=0){
$erg = db_result(db_query("SELECT COUNT(cid) FROM prefix_raid_kalender WHERE cid='".$_SESSION['charid']."'"),0);
if( $erg != 0 ){
return ( $is == 0 ? TRUE : '');
}else{
$ifChar = ( exRaidChar() ? "Es wurde kein Raid Kalender eintrag gefunden! <a href='index.php?chars-show-".$_SESSION['charid']."'>Nachtragen</a>." : "" );
return ( $is == 0 ? FALSE : $ifChar);
}
}
### �berpr�fen ob Char eine Skillung hat wenn ein Char exestiert!
function isRaidSkillung($is=0){
$erg = db_query("SELECT `s1`,`s2`,`s3` FROM `prefix_raid_chars` WHERE id='".$_SESSION['charid']."'");
$sc = db_fetch_assoc($erg);
if( $sc['s1'] != 0 or $sc['s2'] != 0 or $sc['s3'] != 0 ){
return ( $is == 0 ? TRUE : '');
}else{
$ifChar = ( exRaidChar() ? "Es wurde keine Skillung gefunden! <a href='index.php?chars-edit-".$_SESSION['charid']."'>Nachtragen</a>." : "" );
return ( $is == 0 ? FALSE : $ifChar );
}
}
### User die Raidleiter, SuperRaidleiter, Offiziere oder H�her sind bekommt rechte f�r die raid u. Dkp module Automatisch
#setModulrightsForCharRang(65,'insert');
function setModulrightsForCharRang($cid,$if){
$res = db_query("
SELECT
a.user,
b.module
FROM prefix_raid_chars AS a
LEFT JOIN prefix_raid_rang AS b ON a.rang=b.id
WHERE
a.id=".$cid."
LIMIT 1
");
$char = db_fetch_assoc( $res );
$module = explode(",", $char['module'] );
if( $if == 'insert' ){
foreach( $module as $mid ){
if( $mid != NULL ){
@db_query("INSERT INTO prefix_modulerights (uid, mid) VALUES(".$char['user'].", ".trim($mid).");");
}
}
}elseif( $if == 'remove'){
foreach( $module as $mid ){
if( $mid != NULL ){
@db_query("DELETE FROM prefix_modulerights WHERE uid=".$char['user']." AND mid=".trim($mid));
}
}
}
}
##############################################
function RaidPermission($rid=0, $onlyGaO=FALSE){
$uid = ( $rid == 0 ? $rid : db_result(db_query('SELECT von FROM prefix_raid_raid WHERE id='. $rid),0)) ;
if( $_SESSION['authid'] == $uid ){ # Eigentümer kann die eigenen Raids Bearbeiten!
return (TRUE);
}elseif( $_SESSION['charrang'] == 10 and $_SESSION['authid'] == $uid and $onlyGaO == FALSE ){ # Rang: Raidleiter
return (TRUE);
}elseif( $_SESSION['charrang'] == 11 and $onlyGaO == FALSE ){ # Rang: Super Raidleiter
return (TRUE);
}elseif( $_SESSION['charrang'] >= 13 ){ # Rang: Offiezier oder Höher
return (TRUE);
}elseif( is_admin() ){ # wenn alle kriterien nicht zu treffen ist der admin daf�r verantwortlich!
return (TRUE);
}else{ # Tja wenn dann immer noch niemand Rechte hat und jemand soweit kommt wird alles verweigert
return (FALSE);
}
}
##############################################
function RaidRechte( $i ){
if( $i >= $_SESSION['authright'] ){ return(TRUE); }else{ return (FALSE); }
}
##############################################
if( !function_exists( "DateFormat" ) )
{ function DateFormat( $format, $timestamp=0)# D f�r wochentag
{ $wochentagRename = array( "Sun" => "So", "Mon" => "Mo", "Tue" => "Di", "Wed" => "Mi", "Thu" => "Do", "Fri" => "Fr", "Sat" => "Sa");
$timestamp = DateToTimestamp( $timestamp );
$timestamp = ( $timestamp == 0 ? time() : $timestamp );
$return = date( $format, $timestamp );
if( preg_match( "/D/" , $format ) ){
foreach( $wochentagRename as $key => $value ){
$return = str_replace( $key, $value, $return );
}
}
return ($return);
}
}
### allgAr Daten
function allgArInsert( $string ){
global $allgAr;
foreach( $allgAr as $key => $val ){
if( eregi( "{".$key."}", $string )){
$string = str_replace("{".$key."}", $val, $string );
}
}
return ($string);
}
##############################################
function CountFiles( $pfad )
{
$open = @opendir( $pfad );
$i = 0;
while( $files = @readdir( $open )){
if( is_file( $pfad . $files )){
$i++;
}
}
@rewind($open);
@closedir( $open );
return $i;
}
##############################################
function is_img( $pfad ){
if( eregi('.jpg', $pfad) || eregi('.png', $pfad) || eregi('.gif', $pfad) || eregi('.bmp', $pfad) ){
return (true);
}else{
return (false);
}
}
##############################################
function img_popup( $pfad, $feld, $select = NULL ){
$open = opendir( $pfad );
$return = '<select name="'.$feld.'" id="name">';
$return .= "<option value=''></option>";
$return .= "<option value='true'><-Bild Hochladen-></option>";
while( $pic = readdir( $open )){
if( is_file( $pfad.$pic )){
$sel = ( $pic == $select ? " selected" : "" );
$return .= "<option value='".$pic."'".$sel.">".$pic."</option>";
}
}
$return .= '</select>';
closedir($open);
return ($return);
}
##############################################
function drop_down_menu($sql, $input, $select, $id, $where = false){
if( $id != "" ){ $iid = $id."_"; }else{ $iid = ""; }
if( $where ){
$res = db_query( $sql );
}else{
$res = db_query( "SELECT * FROM ".$sql );
}
$menu = "<select name='".$iid.$input."'>\n";
$menu .= "\t<option value=''>....</option>\n";
while( $row = db_fetch_assoc( $res )){
$key = array_keys($row);
if( $select != $row[$key[0]] ){
$menu .= "\t<option value='".$row['id']."'>".$row[$key[1]]."</option>\n";
}else{
$menu .= "\t<option value='".$row['id']."' selected>".$row[$key[1]]."</option>\n";
}
}
$menu .= "</select>\n";
return $menu;
}
###############################################
function db_value( $db, $feld, $id, $and = "" ){
if( $id != 0 ){
$res = db_query("SELECT ".$feld." FROM ".$db." WHERE `id`='".$id."' ".$and);
return db_result( $res, 0 );
}else{
return "Fehler, id #0 Datenbank!";
}
}
###############################################
function bossinfos($ini, $rid){
$cssPfad = 'include/designs/'.$_SESSION['authgfx'].'/';
$cssErmitteln = opendir( $cssPfad );
while( $css = readdir( $cssErmitteln )){
if( ereg('.css', $css ) ){ $cssFile = $css; break; }else{ $cssFile = NULL; }
}
closedir($cssErmitteln);
$ret .= "<title>Boss Info</title>";
$ret .= "<link rel='stylesheet' type='text/css' href='".$cssPfad.$cssFile."'>\n";
$res = db_query("SELECT id, bosse, img FROM prefix_raid_bosse WHERE inzen = '".$ini."'");
$resRaid = db_query("SELECT inv, pull, ende, gruppen FROM prefix_raid_raid WHERE id=".$rid);
$raid = db_fetch_assoc( $resRaid );
$inz = db_result(db_query("SELECT name FROM prefix_raid_inzen WHERE id =". $ini),0);
$cb = db_result(db_query("SELECT maxbosse FROM prefix_raid_inzen WHERE id=".$ini),0);
$ck = db_result(db_query("SELECT COUNT(id) FROM prefix_raid_bosscounter WHERE rid='".$rid."'"),0);
$ret .= '<table width="100%" border="0" cellspacing="1" cellpadding="5" class="border">';
$ret .= '<tr><td colspan=3 class="Chead"><b>'.$inz.' Raid Fortschritt</b></td></tr>';
$ret .= "<tr class='Cdark'><td colspan=3>";
$ret .= "Raid Datum: ".DateFormat("D d.m.Y",$raid['inv']) . "<br>";
$ret .= "Raid Invite: ".DateFormat("H:i",$raid['inv']) . "<br>";
$ret .= "Raid Pull: ".DateFormat("H:i",$raid['pull']) . "<br>";
$ret .= "Raid ende: ".DateFormat("H:i",$raid['ende']) . "<br>";
$ret .= $ck."/".$cb." Bosse sind Tot";
$ret .= "</td></tr>";
$ret .= "<tr class='Cnorm'><td colspan=3>".pzVortschritsAnzeige($ck, $cb, "Vortschritt:")."</td></tr>";
$ret .= "<tr><td colspan=3 class='Cdark'>Aktion: ".button("Aktualisieren","",11).button("Schlie�en","",7)."</td></tr>";
if( db_num_rows($res) != 0 ){
while( $row = db_fetch_assoc( $res )){
$class = cssClass($class);
$ret .= "<tr>";
$ret .= '<td width="75" class="'.$class.'"><center><img height=50 src="include/raidplaner/images/bosse/'.$row['img'].'"></center></td>';
$ret .= '<td class="'.$class.'" nowrap><b>'.$row['bosse'].'</b></td>';
$erg = @db_result(@db_query("SELECT id FROM prefix_raid_bosscounter WHERE rid='".$rid."' AND bid='".$row['id']."'"),0);
$time = @db_result(@db_query("SELECT time FROM prefix_raid_bosscounter WHERE rid='".$rid."' AND bid='".$row['id']."'"),0);
if( $erg != "" ){
$ret .= '<td bgcolor="GREEN">'.'<center><b><font color="#FFFFFF">ELIMINIERT</font></b><br>Kill: '.date("H:i:s",$time).'</center>'.'</td>';
}else{
$ret .= '<td bgcolor="RED">'.'<b><font color="#FFFFFF"><center>ALIVE</center></font></b>'.'</td>';
}
$ret .= "</tr>";
}
}else{
$ret .= "<tr><td colspan=3 class='Cnorm'>Es wurden keine Bosse in die Datenbank eingetragen.</td></tr>";
}
$ret .= "<tr><td colspan=3 class='Cdark'>Aktion: ".button("Aktualisieren","",11).button("Schlie�en","",7)."</td></tr>";
$ret .= "</table>";
return $ret;
}
###############################################
### Habe keine gut l�sung f�r diese function gefunden ^^ wenn jemand eine bessere idee hat so meldet sie mir ^^
function char_skill( $a, $b, $c, $d, $e = 11 ){ # a=skill 1 b=skill 2, c=skill 3, d=klassenid, e=berechnungswert
global $raid;
$a = $raid->db('raid_classification')->select('name')->where('id', $a)->cell();
$b = $raid->db('raid_classification')->select('name')->where('id', $b)->cell();
$c = $raid->db('raid_classification')->select('name')->where('id', $c)->cell();
return $a ." / ". $b ." / ". $c;
}
### SKILLGRUPPE
function skillgruppe($opt=0,$checked=0){
if( $opt == 0 ){
$gruppen = array( "0"=>"n/a", "1"=>"Tank", "2"=>"Healer", "3"=>"Damage Dealer" );
return ($gruppen[$checked]);
}elseif( $opt == 1 ){
$gruppen = array( "1"=>"Tank", "2"=>"Healer", "3"=>"Damage Dealer" );
foreach( $gruppen as $id => $value ){
$checkin = ( $checked == $id ? 'checked="checked"' : '' );
$return .= "<label><input type='radio' name='charakter[skillgruppe]' value='".$id."' ".$checkin."> ".$value."</label><br>";
}
return ($return);
}
}
####
function class_img($i){
$link = 'include/raidplaner/images/class/class_'.$i.'.gif';
if( file_exists($link)){
return "<img src='".$link."'>";
}
}
####
function pz($a, $b, $c = 0){
if( $a == 0 or $b == 0 ){
return (0);
}else{
return round( ( $a * 100 ) / $b , $c );
}
}
####
function pzVortschritsAnzeige($a, $b, $msg='', $r=0){
global $allgAr;
$pz = pz($a,$b,$r);
$msg = ( !empty( $msg ) ? "<tr><td class='Chead' colspan=3>".$msg."</td></tr>" : "" );
return ("<table width='100%' class='border' cellspacing=1 cellpadding=1 border=0>"
.$msg
."<tr>"
."<td width='10%' class='Cnorm'><div align='center'>000%</div></td>"
."<td width='80%' class='Cmite'>"
."<table width='".$pz."%' class='border' cellspacing=1><tr><td style='".$allgAr['pzBalkenStyle']."'><div align='right'>".$pz."%</div></td></tr></table>"
."</td>"
."<td width='10%' class='Cnorm'><div align='center'>100%</div></td>"
."</tr>"
."</table>");
}
####
function button( $name, $url, $if = 0 ){
global $menu, $allgAr;
$who = $_SERVER['PHP_SELF'].'?'.$_SERVER['argv'][0];
$arrAction = array(6 => 'javascript:window.close()',
7 => 'javascript:window.close()',
8 => 'javascript:history.back()',
9 => 'javascript:history.back()',
10 => $_SERVER['PHP_SELF'].'?'.$_SERVER['argv'][0],
11 => $_SERVER['PHP_SELF'].'?'.$_SERVER['argv'][0]);
foreach( $arrAction as $key => $val ){
if( $key == $if ){
$url = $val;
break;
}
}
$bt = "<a href='{url}' title='{name}' class='buttons'>{name}</a> ";
$bt = str_replace( "{name}", $name, $bt);
$bt = str_replace( "{url}", $url, $bt);
switch( $if ){
case "0": print $bt; break;
case "1": if( user_has_admin_right ($menu,false) ){ print $bt; } break;
case "2": return $bt; break;
case "3": if( user_has_admin_right ($menu,false) ){ return $bt; } break;
case "4": if( is_admin() ){ print $bt; } break;
case "5": if( is_admin() ){ return $bt; } break;
case "6": print $bt; break;
case "7": return $bt; break;
case "8": print $bt; break;
case "9": return $bt; break;
case "10": print $bt; break;
case "11": return $bt; break;
case "12": print ( RaidPermission( 0, TRUE) ? $bt : '' );
case "13": return ( RaidPermission( 0, TRUE) ? $bt : '' );
}
}
####
function ascape( $string ){
if( is_integer( $string )){
$option = 'integer';
}elseif( is_string( $string ) && strlen( $string ) > 250 ){
$option = 'textarea';
}else{
$option = 'string';
}
return escape( $string, $option );
}
### Automatische Tabelle Generieren ########################################################################################
# F�r Kleine unaufwendige Tabellen, geignet.
# Hinweise, um einen L�sch Icon hinzuzubekommen mus man in der SQL Abfrage beispiel das feld id as del umbenen, zudem muss
# auf $db_table_del ein True zugewisen werden als function oder "true" umd das l�schen zu Aktivieren. In einem fall habe
# ich das so gemacht "$db_table_del = is_admin();" wenn einer admin ist die function true zur�ck geben.
# das feld $ord ist f�r den anfang der Tabelle f�r die erste spalte damit nicht alles in <center> angeordnet wird.
# $db_table_breite hier wird die breite f�r jede selbst definiert die dan zu % wird, bsp. $db_table_breite = 50;
# nun ist jede spalte 50% gro�.
# $db_table_url weist f�r den l�schlink die url zu die dan noch um $_GET erweitert wird.
############################################################################################################################
function db_table( $sql, $ord ){
global $db_table_breite, $db_table_del, $db_table_url;
# Die Breite im Global bestimmen.
$breite = ( $db_table_breite != '' ? $db_table_breite."%" : "" );
# Eine Abfrage als Unsichpaar erstellen.
$img_del = "<img src='include/images/icons/del.gif' border='0'>";
# Die Erste Datenbank herausfiltern!
preg_match("/prefix_([_]?[0-9a-zA-Z])*/", $sql, $db);
#print_r($array);
if($res = db_query( $sql )){
### Header
$anz = mysql_num_fields($res);
$num = db_num_rows($res);
$table .= "<table width='100%' border='0' cellpadding='2' cellspacing='1' class='border'>";
$table .= "<tr>";
for($a=0; $a < $anz; $a++ ){
$orda = ( $a == $ord ? 'left' : 'center' );
if( mysql_field_name($res,$a) != "del" ){
$table .= "<td class='Chead' width='".$breite."'>"
."<center><div align='".$orda."'><b>"
. ucfirst(str_replace("_"," ",mysql_field_name($res,$a)))
."</b></div></center></td>";
}else{
if( $db_table_del ){
$table .= "<td class='Chead' width='0%' valign='top'>". $img_del ."</td>";
}else{
$table .= "";
}
}
}
$table .= "</tr>";
### Content
for($b=0; $b < $num; $b++ ){
$class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' );
$table .= "<tr class='".$class."'>";
$row = mysql_fetch_assoc($res);
# Autmatische Spalten erstellen!
for($c=0; $c < $anz; $c++){
$ordc = ( $c == $ord ? 'left' : 'center' );
$fn = mysql_field_name($res,$c);
if( $fn != "del" ){
$table .= "<td valign='top'><div align=".$ordc.">". bbcode($row[$fn]) ."</div></td>";
}else{
if( $db_table_del ){
$table .= "<td valign='top'><div align='".$ordc."'>"
."<a href='".$db_table_url."&del=".$row[$fn]."&table=".$db[0]."'>". $img_del ."</a></div></td>";
}else{
$table .= "";
}
}
}
$table .= "</tr>";
}
### Footer
$table .= "</table>";
print $table;
}else{
print "MySQL ERROR";
}
}
####
if( !function_exists( "Alter" ) )
{ function Alter( $date )
{ if( preg_match( DateFormate('DATE'), $date, $tmp)){ $bj = $tmp[3]; $bm = $tmp[2]; $bt = $tmp[1]; }
elseif( preg_match( DateFormate('MYSQL'), $date, $tmp)){ $bj = $tmp[1]; $bm = $tmp[2]; $bt = $tmp[3]; }
else { return "00"; }
$j = date("Y")-$bj;
if( $bm > date("m") ) $j--;
if( $bm == date("m") AND $bt > date("d")) $j--;
return $j;
}
}
####
/* Ist nur eine Kopie aus show_posts.php vom Forum
require_once("include/includes/func/b3k_func.php");
if( $res = db_query( "SELECT a.name, b.klassen, c.level, a.id FROM prefix_raid_chars AS a, prefix_raid_klassen AS b, prefix_raid_level AS c WHERE user='".$row['erstid']."' AND a.klassen=b.id AND a.level=c.id ORDER BY a.id LIMIT 1" ) ){
$x = mysql_fetch_array($res);
$row['char'] = "<a href='index.php?chars-show-".$x[3]."'>".$x[0]."</a>";
$row['lvl'] = $x[2];
$row['klassen'] = class_img($x[1]);
}else{
$row['char'] = '';
$row['lvl'] = '';
$row['klassen'] = '';
}
*/
function arrPrint(){
foreach( func_get_args() as $val ){
echo "<pre>";
print_r( $val );
echo "</pre>";
}
}
if( !function_exists( "DateFormate" ) )
{ function DateFormate( $key )
{ $formate = array(
"MYSQL" => "/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2})/",
"MYSQLaTIME" => "/([0-9]{4})-([0-9]{1,2})-([0-9]{1,2}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})/",
"DATE" => "/([0-9]{1,2})\.([0-9]{1,2})\.([0-9]{4})/",
"DATEaTIME" => "/([0-9]{1,2})\.([0-9]{1,2})\.([0-9]{4}) ([0-9]{1,2}):([0-9]{1,2}):([0-9]{1,2})/");
return $formate[$key];
}
}
#### Datum zum Timestamp umwandeln.
if( !function_exists( "DateToTimestamp" ) )
{ function DateToTimestamp( $date )
{ global $formate;
if( !empty( $date ) )
{ if( preg_match( DateFormate('MYSQLaTIME'), $date, $tmp ) ){ return mktime( $tmp[4], $tmp[5], $tmp[6], $tmp[2], $tmp[3], $tmp[1]); }
elseif( preg_match( DateFormate('DATEaTIME'), $date, $tmp ) ) { return mktime( $tmp[4], $tmp[5], $tmp[6], $tmp[2], $tmp[1], $tmp[3]); }
elseif( preg_match( DateFormate('DATE'), $date, $tmp ) ) { return mktime( 0, 0, 0, $tmp[2], $tmp[1], $tmp[3]); }
elseif( preg_match( DateFormate('MYSQL'), $date, $tmp ) ){ return mktime( 0, 0, 0, $tmp[2], $tmp[3], $tmp[1]);}
else { return $date; }
}
}
}
### ITEMS on BUFFED!!
### DKP
function RaidItems( $txt, $i )
{ if( preg_match_all( "/\{_raiditem_([0-9]*)\}/", $txt, $items ) )
{ $rpl = $set = array();
foreach( $items[1] as $k => $id )
{ $rpl[] = $items[0][$k];
$iName = @db_result(@db_query("SELECT name FROM prefix_raid_items WHERE id='".$id."' LIMIT 1"),0);
$iClass = @db_result(@db_query("SELECT class FROM prefix_raid_items WHERE id='".$id."' LIMIT 1"),0);
$image = "http://wowdata.buffed.de/tooltips/items/gif/".$id.".gif";
$set[] = ( empty( $iName ) ? "" : "<br /><span style='font-size: 9px;'>Loot: </span><a href='http://wowdata.buffed.de/?i=".$id."' target='_blank' class='".$iClass."'>".$iName."</a> ");
}
return str_replace($rpl, $set, $txt);
}
return $txt;
}
function agoTimeMsg( $wert, $lastMsg = 'vor wenigen Sekunden' )
{ $TIME_AGO_sec = round( time() - DateToTimestamp($wert) );
$TIME_AGO_min = round( $TIME_AGO_sec / 60);
$TIME_AGO_hrs = round( $TIME_AGO_min / 60);
$TIME_AGO_day = round( $TIME_AGO_hrs / 24);
$TIME_AGO_wek = round( $TIME_AGO_day / 7);
$TIME_AGO_yea = round( $TIME_AGO_day / 365);
$TIME_AGO_mon = round( $TIME_AGO_day / 30.42, 0); # 30,42 Tage Durschschnit f�r ein Monat im Jahr
if($TIME_AGO_sec > ( 86400 * 365 )) return 'vor '. $TIME_AGO_yea .' '.( $TIME_AGO_yea > 1 ? "Jahren" : "Jahr");
elseif($TIME_AGO_day > 30) return 'vor '. $TIME_AGO_mon .' '.( $TIME_AGO_mon > 1 ? "Monaten" : "Monat");
elseif($TIME_AGO_sec > ( 86400 * 7 )) return 'vor '. $TIME_AGO_wek .' Wochen';
elseif ($TIME_AGO_sec > 86400) return 'vor '.$TIME_AGO_day.' Tagen';
elseif ($TIME_AGO_sec > 3600) return 'vor '.$TIME_AGO_hrs.' Stunden';
elseif ($TIME_AGO_sec > 60) return 'vor '.$TIME_AGO_min.' Minuten';
else return $lastMsg;
}
function urlSerialize( $array )
{
return urlencode(serialize( $array ));
}
function urlUnserialize( $string )
{
$string = urldecode( $string );
return unserialize($string);
}
function nuller( $i )
{
return ( strlen( $i ) == 1 ? "0".$i : $i );
}
function sendpm_2_legitimate($title, $text, $status = 0){
$res = db_query('SELECT DISTINCT user FROM `prefix_raid_chars` WHERE rang < 6');
while( $row = db_fetch_assoc($res) ){
sendpm($_SESSION['authid'], $row['user'], $title, $text, $status);
}
}
function classSpecialization($id, $selected_1 = NULL, $selected_2 = NULL, $selected_3 = NULL){
global $raid;
if( empty($id) )
return 'Wählen Sie bitte eine Klasse aus!';
$res = $raid->db('raid_classification')
->select('id', 'name')
->where('class_id', $id)
->rows();
$specialization = array();
foreach( $res as $val ){
if( $selected_1 == $val['id'] ){
$specialization[1][] = sprintf('<option value="%s" selected="selected">%s</option>', $val['id'], $val['name']);
}else{
$specialization[1][] = sprintf('<option value="%s">%s</option>', $val['id'], $val['name']);
}
if( $selected_2 == $val['id'] ){
$specialization[2][] = sprintf('<option value="%s" selected="selected">%s</option>', $val['id'], $val['name']);
}else{
$specialization[2][] = sprintf('<option value="%s">%s</option>', $val['id'], $val['name']);
}
if( $selected_3 == $val['id'] ){
$specialization[3][] = sprintf('<option value="%s" selected="selected">%s</option>', $val['id'], $val['name']);
}else{
$specialization[3][] = sprintf('<option value="%s">%s</option>', $val['id'], $val['name']);
}
}
$kspz = "<select name=\"charakter[s1]\">".implode('\n', $specialization[1])."</select>";
$kspz .= "<select name=\"charakter[s2]\">".implode('\n', $specialization[2])."</select>";
$kspz .= "<select name=\"charakter[s3]\">".implode('\n', $specialization[3])."</select>";
return $kspz;
}
function getPost($key){
$val = $_POST[$key];
unset($_POST[$key]);
return $val;
}
?>
lg
Sarah
verwendete ilch Version: 1.1 P
betroffene Homepage: rbl.gilde-web.de
