API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2018
111
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 104.03 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. function config($file){
  3. $array = array();
  4. $scan = fopen($file, "r");
  5. if($scan){
  6. while($line = fgets($scan)){
  7. $what = substr($line, 0, strpos($line, "="));
  8. $str = substr($line, strpos($line, "=")+1, strlen($line));
  9. $array[$what] = $str;
  10. }
  11. return $array;
  12. }else{
  13. return "nope";
  14. }
  15. }
  16.  
  17. function printNav($file){
  18. $scan = fopen($file, "r");
  19. if($scan){
  20. while($line = fgets($scan)){
  21. if(substr($line, 0, 2) == "<-"){
  22. while($line = fgets($scan)){
  23. if(substr($line, 0, strpos($line, "=")) == "name"){
  24. $name = substr($line, strpos($line, "=")+1, strlen($line));
  25. }else if(substr($line, 0, strpos($line, "=")) == "link"){
  26. $link = substr($line, strpos($line, "=")+1, strlen($line));
  27. }else if(substr($line, 0, 2) == "->"){
  28. if($name != "0" && $link != "0"){
  29. echo "<a href='".$link."' class='btn'>".$name."</a>";
  30. }
  31. break;
  32. }
  33. }
  34. }
  35. }
  36. }else{
  37. return "nope";
  38. }
  39. }
  40.  
  41. function printFotNav($file){
  42. $scan = fopen($file, "r");
  43. if($scan){
  44. while($line = fgets($scan)){
  45. if(substr($line, 0, 2) == "<-"){
  46. while($line = fgets($scan)){
  47. if(substr($line, 0, strpos($line, "=")) == "name"){
  48. $name = substr($line, strpos($line, "=")+1, strlen($line));
  49. }else if(substr($line, 0, strpos($line, "=")) == "link"){
  50. $link = substr($line, strpos($line, "=")+1, strlen($line));
  51. }else if(substr($line, 0, 2) == "->"){
  52. if($name != "0" && $link != "0"){
  53. echo "<a href='".$link."'>".$name."</a>";
  54. }
  55. break;
  56. }
  57. }
  58. }
  59. }
  60. }else{
  61. return "nope";
  62. }
  63. }
  64.  
  65. function getVideoList(){
  66. $folder = "data/video";
  67. $scan = scandir($folder);
  68. $array = array();
  69. $count = 0;
  70. foreach($scan as $file){
  71. if($file != ".." && $file != "." && !is_dir($folder."/".$file)){
  72. $array[$count] = $file;
  73. $count++;
  74. }
  75. }
  76. return $array;
  77. }
  78.  
  79. function getVideoCount(){
  80. $folder = "data/video";
  81. $scan = scandir($folder);
  82. $count = 0;
  83. foreach($scan as $file){
  84. if($file != ".." && $file != "." && !is_dir($folder."/".$file)){
  85. $count++;
  86. }
  87. }
  88. return $count;
  89. }
  90. function navigationPrinter(){
  91. $file = "data/config/navigation.lexx";
  92. $name = "";
  93. $link = "";
  94. $read = fopen($file, "r");
  95. while($line = fgets($read)){
  96. if(substr($line, 0, 2) == "<-"){
  97. while($line = fgets($read)){
  98. if(substr($line, 0, 4) == "name"){
  99. $name = substr($line, strpos($line, "=")+1, strlen($line));
  100. }
  101. if(substr($line, 0, 4) == "link"){
  102. $link = substr($line, strpos($line, "=")+1, strlen($line));
  103. }
  104. if(substr($line, 0, 2) == "->"){
  105. if($name != "" && $link != ""){
  106. echo "
  107. <a href='".$link."' class='btn'>".$name."</a>
  108. ";
  109. $name = "";
  110. $link = "";
  111. }
  112. break;
  113. }
  114. }
  115. }
  116. }
  117. }
  118.  
  119. function footerLinksPrinter(){
  120. $file = "data/config/footer-links.lexx";
  121. $name = "";
  122. $link = "";
  123. $read = fopen($file, "r");
  124. while($line = fgets($read)){
  125. if(substr($line, 0, 2) == "<-"){
  126. while($line = fgets($read)){
  127. if(substr($line, 0, 4) == "name"){
  128. $name = substr($line, strpos($line, "=")+1, strlen($line));
  129. }
  130. if(substr($line, 0, 4) == "link"){
  131. $link = substr($line, strpos($line, "=")+1, strlen($line));
  132. }
  133. if(substr($line, 0, 2) == "->"){
  134. if($name != "" && $link != ""){
  135. echo "
  136. <a href='".$link."' class='footer-link'>".$name."</a>
  137. ";
  138. $name = "";
  139. $link = "";
  140. }
  141. break;
  142. }
  143. }
  144. }
  145. }
  146. }
  147.  
  148. function PrintFooterLinks(){
  149. $file = "data/config/footer-links.lexx";
  150. $name = "";
  151. $link = "";
  152. $read = fopen($file, "r");
  153. while($line = fgets($read)){
  154. if(substr($line, 0, 2) == "<-"){
  155. while($line = fgets($read)){
  156. if(substr($line, 0, 4) == "name"){
  157. $name = substr($line, strpos($line, "=")+1, strlen($line));
  158. }
  159. if(substr($line, 0, 4) == "link"){
  160. $link = substr($line, strpos($line, "=")+1, strlen($line));
  161. }
  162. if(substr($line, 0, 2) == "->"){
  163. if($name != "" && $link != ""){
  164. echo "
  165. <li>
  166. <a href='".$link."' target='_blank'>".$name."</a>
  167. </li>
  168. ";
  169. $name = "";
  170. $link = "";
  171. }
  172. break;
  173. }
  174. }
  175. }
  176. }
  177. }
  178.  
  179. function PrintFooterSimpleLinks(){
  180. $file = "data/config/BaseFooter/sample-links.lexx";
  181. $name = "";
  182. $link = "";
  183. $icon = "";
  184. $read = fopen($file, "r");
  185. while($line = fgets($read)){
  186. if(substr($line, 0, 2) == "<-"){
  187. while($line = fgets($read)){
  188. if(substr($line, 0, 4) == "name"){
  189. $name = substr($line, strpos($line, "=")+1, strlen($line));
  190. }
  191. if(substr($line, 0, 4) == "link"){
  192. $link = substr($line, strpos($line, "=")+1, strlen($line));
  193. }
  194. if(substr($line, 0, 4) == "icon"){
  195. $icon = substr($line, strpos($line, "=")+1, strlen($line));
  196. }
  197. if(substr($line, 0, 2) == "->"){
  198. if($name != "" && $link != "" && $icon != ""){
  199. echo "
  200. <li>
  201. <a class='".$icon."' href='".$link."'>".$name."</a>
  202. </li>
  203. ";
  204. $name = "";
  205. $link = "";
  206. $icon = "";
  207. }
  208. break;
  209. }
  210. }
  211. }
  212. }
  213. }
  214.  
  215.  
  216.  
  217. function PrintContactDetails(){
  218. $file = "data/config/BaseFooter/contact-details.lexx";
  219. $header = "";
  220. $value = "";
  221. $icon = "";
  222. $type = "";
  223. $link = "";
  224. $read = fopen($file, "r");
  225. while($line = fgets($read)){
  226. if(substr($line, 0, 2) == "<-"){
  227. while($line = fgets($read)){
  228. if(substr($line, 0, 4) == "head"){
  229. $header = substr($line, strpos($line, "=")+1, strlen($line));
  230. }
  231. if(substr($line, 0, 4) == "valu"){
  232. $value = substr($line, strpos($line, "=")+1, strlen($line));
  233. }
  234. if(substr($line, 0, 4) == "icon"){
  235. $icon = substr($line, strpos($line, "=")+1, strlen($line));
  236. }
  237. if(substr($line, 0, 4) == "type"){
  238. $type = substr($line, strpos($line, "=")+1, strlen($line));
  239. }
  240. if(substr($line, 0, 4) == "link"){
  241. $link = substr($line, strpos($line, "=")+1, strlen($line));
  242. }
  243. if(substr($line, 0, 2) == "->"){
  244. if($header != "" && $value != "" && $icon != "" && $type != ""){
  245. if(substr($type, 0, 4) == "text"){
  246. echo "
  247. <span class='".$icon."'>".$header.": </span>".$value."<br>
  248. ";
  249. }else if(substr($type, 0, 4) == "href"){
  250. echo "
  251. <span class='".$icon."'>".$header.":</span>
  252. <a href='".$link."'>".$value."</a>
  253. <br>
  254. ";
  255. }
  256. $header = "";
  257. $value = "";
  258. $icon = "";
  259. $type = "";
  260. $link = "";
  261. }
  262. break;
  263. }
  264. }
  265. }
  266. }
  267. }
  268.  
  269.  
  270. function PrintSocialIcons(){
  271. $file = "data/config/social-links.lexx";
  272. $title = "";
  273. $link = "";
  274. $sicon = "";
  275. $read = fopen($file, "r");
  276. while($line = fgets($read)){
  277. if(substr($line, 0, 2) == "<-"){
  278. while($line = fgets($read)){
  279. if(substr($line, 0, 6) == "s-icon"){
  280. $sicon = substr($line, strpos($line, "=")+1, strlen($line));
  281. }
  282. if(substr($line, 0, 4) == "link"){
  283. $link = substr($line, strpos($line, "=")+1, strlen($line));
  284. }
  285. if(substr($line, 0, 4) == "titl"){
  286. $title = substr($line, strpos($line, "=")+1, strlen($line));
  287. }
  288. if(substr($line, 0, 2) == "->"){
  289. if($title != "" && $link != "" && $sicon != ""){
  290. echo "
  291. <li class='".$sicon."'>
  292. <a href='".$link."' target='_blank' title='".$title."'></a>
  293. </li>
  294. ";
  295. $title = "";
  296. $link = "";
  297. $sicon = "";
  298. }
  299. break;
  300. }
  301. }
  302. }
  303. }
  304. }
  305.  
  306.  
  307. function printNavigation1(){
  308. $folder = "data/config/navigation/";
  309. $scan = scandir($folder);
  310. if($scan){
  311. $name="";
  312. $icon="";
  313. $link="";
  314. $type="";
  315. foreach($scan as $file){
  316. if(!is_dir($folder.$file)){
  317. $read = fopen($folder.$file, "r");
  318. while($line = fgets($read)){
  319. if(substr($line, 0, 4) == "type"){
  320. $type = substr($line, strpos($line, "=")+1, strlen($line));
  321. }
  322. if(substr($line, 0, 4) == "icon"){
  323. $icon = substr($line, strpos($line, "=")+1, strlen($line));
  324. }
  325. if(substr($line, 0, 4) == "link"){
  326. $link = substr($line, strpos($line, "=")+1, strlen($line));
  327. }
  328. if(substr($line, 0, 4) == "name"){
  329. $name = substr($line, strpos($line, "=")+1, strlen($line));
  330. }
  331. if($link != "" && $type != "" && $name != "" && $icon != ""){
  332. if(substr($type, 0, 4) == "href"){
  333. echo "
  334. <li>
  335. <a href='".$link."' class='".$icon."'>".$name."</a>
  336. </li>
  337. ";
  338. }
  339. else if(substr($type, 0, 4) == "drop"){
  340. echo "
  341. <li>
  342. <span class='".$icon."'>".$name."</span>
  343. <ul>
  344. ";
  345.  
  346.  
  347. $name2 = "";
  348. $link2 = "";
  349. $folder2 = $folder.substr($name, 0,-2)."/";
  350. $scan2 = scandir($folder2);
  351. if($scan2){
  352. foreach($scan2 as $file2){
  353. if(!is_dir($folder2.$file2)){
  354. $read2 = fopen($folder2.$file2, "r");
  355. while($line2 = fgets($read2)){
  356. if(substr($line2, 0, 4) == "name"){
  357. $name2 = substr($line2, strpos($line2, "=")+1, strlen($line2));
  358. }
  359. if(substr($line2, 0, 4) == "link"){
  360. $link2 = substr($line2, strpos($line2, "=")+1, strlen($line2));
  361. }
  362. if($link2 != "" && $name2 != ""){
  363. echo "
  364. <li>
  365. <a href='".$link2."'>".$name2."</a>
  366. </li>
  367. ";
  368. $name2 = "";
  369. $link2 = "";
  370. }
  371. }
  372. }
  373. }
  374. }else{
  375. echo "
  376. <li>
  377. <a href='#'>ERROR</a>
  378. </li>
  379. ";
  380. }
  381.  
  382.  
  383. echo "
  384. </ul>
  385. </li>
  386. ";
  387. }
  388. $name="";
  389. $icon="";
  390. $link="";
  391. $type="";
  392. }
  393.  
  394. }
  395.  
  396. }
  397. }
  398. }else{
  399. echo "Error";
  400. }
  401. }
  402.  
  403. function werbungCount(){
  404. $folder = "werbungen/";
  405. $count = 0;
  406. $cscan = scandir($folder);
  407. foreach($cscan as $file){
  408. if($file != "." && $file != ".."){
  409. $count++;
  410. }
  411. }
  412. return $count;
  413. }
  414.  
  415. function werbung(){
  416. $count = werbungCount();
  417. $nrrand = rand(0, $count);
  418. $nrofwerb = 0;
  419. if($count == 0){
  420. return;
  421. }
  422. $folder = "werbungen/";
  423. $cscan = scandir($folder);
  424. foreach($cscan as $file){
  425. if($file != "." && $file != ".."){
  426. if($nrofwerb == $nrrand){
  427. $wFolder = $folder.$file."/";
  428. $link = "";
  429. $img = "";
  430. $link = file_get_contents($wFolder."link.lexx");
  431. $wscan = scandir($wFolder);
  432. foreach($wscan as $wFile){
  433. if(exif_imagetype($wFolder.$wFile) == IMAGETYPE_JPEG){
  434. $img = $wFolder.$wFile;
  435. }
  436. }
  437. if($link != "" && $img != ""){
  438. echo "
  439. <div class='row'>
  440. <div class='col-md-12 no-padding'>
  441. <!-- Portfolio Item -->
  442. <div class='col-md-12 margin-bottom-40' style='background-color: #000000; text-align: center;'>
  443. <a href='".$link."' style='width: 100%;'>
  444.  
  445. <img src='".$img."' style='max-height: 150px;'>
  446.  
  447. </a>
  448. </div>
  449. <!-- End Portfolio Item -->
  450.  
  451. </div>
  452. </div>
  453. ";
  454. return;
  455. }
  456. }
  457. $nrofwerb++;
  458. }
  459. }
  460. }
  461.  
  462. function errorlog($error, $location){
  463. $file = "data/log/error-log.lexx";
  464. $time = "W".date("W")."_".date("D")." ".date("d").".".date("m").".".date("y")."_".date("s").":".date("i").":".date("H");
  465. $write = fopen($file,"a");
  466. $string = $time." | ".$error." -> ".$location."\n";
  467. fwrite($write, $string);
  468. fclose($write);
  469. }
  470.  
  471. function RandomString()
  472. {
  473. $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
  474. $randstring = '';
  475. for ($i = 0; $i < 10; $i++) {
  476. $randstring .= $characters[rand(0, strlen($characters))];
  477. }
  478. return $randstring;
  479. }
  480.  
  481. function createUUID(){
  482. $String = "";
  483. $codeAlphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
  484. $sql = mysqlData();
  485. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  486. if($con){
  487. if(mysqli_select_db($con, $sql['database'])){
  488. $iw = 0;
  489. while($iw != 100){
  490. $String = RandomString();
  491. $query = mysqli_query($con, "select * from regUsers where UUID = '".$String."'");
  492. $rows= mysqli_num_rows($query);
  493. if($rows == 0){
  494. return $String;
  495. }
  496. }
  497. errorlog("Cant Create UUID", __FUNCTION__);
  498. }else{
  499. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  500. }
  501. }else{
  502. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  503. }
  504. return "ERROR";
  505. }
  506.  
  507.  
  508. function sysSendMail($tomail, $message, $header, $name){
  509.  
  510. error_reporting(E_ALL);
  511. require("PHPMailer_5.2.4/class.phpmailer.php");
  512.  
  513. $setbody = $message;
  514.  
  515. $mail = new PHPMailer();
  516.  
  517. $mail->IsSMTP();
  518. $mail->SMTPDebug = 2;
  519. $mail->From = getMailData('from');
  520. $mail->FromName = getMailData('firmaName');
  521. $mail->Host = getMailData('host');
  522. $mail->SMTPSecure = getMailData('protokoll');
  523. $mail->Port = getMailData('port');
  524. $mail->SMTPAuth = true;
  525. $mail->Username = getMailData('benutzer');
  526. $mail->Password = getMailData('password');
  527. $mail->AddAddress($tomail,$name);
  528. $mail->AddReplyTo(getMailData('antwortAdr'),getMailData('antwortName'));
  529. $mail->WordWrap = 50;
  530.  
  531. $mail->IsHTML(true);
  532. $mail->Subject = $header;
  533. $mail->Body = $setbody;
  534.  
  535. if($mail->Send()){
  536. return "OK";
  537. }else{
  538. return "ERROR";
  539. }
  540. }
  541.  
  542. function infoSendMail($tomail, $message, $header, $name){
  543.  
  544. error_reporting(E_ALL);
  545. require("PHPMailer_5.2.4/class.phpmailer.php");
  546.  
  547. $setbody = $message;
  548.  
  549. $mail = new PHPMailer();
  550.  
  551. $mail->IsSMTP();
  552. $mail->SMTPDebug = 2;
  553. $mail->From = getInfoMailData('from');
  554. $mail->FromName = getInfoMailData('firmaName');
  555. $mail->Host = getInfoMailData('host');
  556. $mail->SMTPSecure = getInfoMailData('protokoll');
  557. $mail->Port = getInfoMailData('port');
  558. $mail->SMTPAuth = true;
  559. $mail->Username = getInfoMailData('benutzer');
  560. $mail->Password = getInfoMailData('password');
  561. $mail->AddAddress($tomail,$name);
  562. $mail->AddReplyTo(getInfoMailData('antwortAdr'),getInfoMailData('antwortName'));
  563. $mail->WordWrap = 50;
  564.  
  565. $mail->IsHTML(true);
  566. $mail->Subject = $header;
  567. $mail->Body = $setbody;
  568.  
  569. if($mail->Send()){
  570. return "OK";
  571. }else{
  572. return "ERROR";
  573. }
  574. }
  575.  
  576. function supSendMail($tomail, $message, $header, $name){
  577.  
  578. error_reporting(E_ALL);
  579. require("PHPMailer_5.2.4/class.phpmailer.php");
  580.  
  581. $setbody = $message;
  582.  
  583. $mail = new PHPMailer();
  584.  
  585. $mail->IsSMTP();
  586. $mail->SMTPDebug = 2;
  587. $mail->From = getSuppMailData('from');
  588. $mail->FromName = getSuppMailData('firmaName');
  589. $mail->Host = getSuppMailData('host');
  590. $mail->SMTPSecure = getSuppMailData('protokoll');
  591. $mail->Port = getSuppMailData('port');
  592. $mail->SMTPAuth = true;
  593. $mail->Username = getSuppMailData('benutzer');
  594. $mail->Password = getSuppMailData('password');
  595. $mail->AddAddress($tomail,$name);
  596. $mail->AddReplyTo(getSuppMailData('antwortAdr'),getSuppMailData('antwortName'));
  597. $mail->WordWrap = 50;
  598.  
  599. $mail->IsHTML(true);
  600. $mail->Subject = $header;
  601. $mail->Body = $setbody;
  602.  
  603. if($mail->Send()){
  604. return "OK";
  605. }else{
  606. return "ERROR";
  607. }
  608. }
  609.  
  610. function PWCoder($pw){
  611. $pass = md5(md5(md5($pw)));
  612. return $pass;
  613. }
  614.  
  615. function getTime(){
  616. $time = date("d").".".date("m").".".date("y")."_".date("s").":".date("i");
  617. return $time;
  618. }
  619.  
  620. function getIP(){
  621. $client = @$_SERVER['HTTP_CLIENT_IP'];
  622. $forward = @$_SERVER['HTTP_X_FORWARDED_FOR'];
  623. $remote = $_SERVER['REMOTE_ADDR'];
  624.  
  625. if(filter_var($client, FILTER_VALIDATE_IP))
  626. {
  627. $ip = $client;
  628. }
  629. elseif(filter_var($forward, FILTER_VALIDATE_IP))
  630. {
  631. $ip = $forward;
  632. }
  633. else
  634. {
  635. $ip = $remote;
  636. }
  637.  
  638. return $ip;
  639. }
  640.  
  641. function registerNewUser($Uuser, $Umail, $Upw){
  642. $sql = mysqlData();
  643. $uuid = createUUID();
  644. $uPassword = PWCoder($Upw);
  645. $time = getTime();
  646. $IP = getIP();
  647. $session = "000";
  648. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  649. if($con){
  650. if(mysqli_select_db($con, $sql['database'])){
  651. $check = mysqli_query($con, "select * from regUsers where e_Mail = '".$Umail."'");
  652. if(mysqli_num_rows($check)){
  653. return "Diese Email ".$Umail." ist bereits Registriert!";
  654. }
  655. $check = mysqli_query($con, "select * from regUsers where R_User = '".$Uuser."'");
  656. if(mysqli_num_rows($check)){
  657. return "Dieser Benutzer ".$Uuser." existiert bereits. Wählen sie einen anderen Namen";
  658. }
  659. $query = mysqli_query($con, "insert into regUsers (e_Mail, R_User, PW, UUID, Session_Key, last_login_IP, Last_Login_Date)
  660. values('".$Umail."','".$Uuser."','".$uPassword."','".$uuid."','".$session."','".$IP."', '".$time."')");
  661. if($query){
  662. $mailtopbox = file_get_contents("data/config/mail-layout/top-box.lexx");
  663. $mailbotbox = file_get_contents("data/config/mail-layout/bot-box.lexx");
  664. $message = "
  665. Herzlich willkommen ".$Uuser." bei<br>
  666. <b>Die Deutsche Sturm Truppen</b>
  667. <br><br>
  668. Sie haben sich vorher auf <a href='http://ddst.eu/'>ddst</a> Webseite registriert.<br><br>
  669. Klicken sie auf den Link darunter um ihres Konto zu aktivieren.<br>
  670. <a href='http://ddst.eu/action.php?action=AccActive&UUID=".$uuid."'>Konto Aktivieren</a><br><br>
  671. Falls es nicht ihres Wunsch sich auf dieser Webseite zu registrieren? dan -> <span style='color: #ff0000;'>Klicken sie auf diesen Link Nicht drauf ! !</span>
  672. und melden sie sich beim Support von <a href='http://ddst.eu/'>DDST</a>.
  673. ";
  674. $mailMessage = $mailtopbox.$message.$mailbotbox;
  675. $mail = sysSendMail($Umail, $mailMessage, "[DDST System] Aktiviere deinen Account!", $name);
  676. if($mail == "OK"){
  677. return "OK";
  678. }else{
  679. errorlog("[MAIL] Cant Send Activation Mal to new User ".$Umail, __FUNCTION__);
  680. return "Ein Unbekantes System Fehler ist aufgetretten!";
  681. }
  682. }else{
  683. errorlog("[SQL] Cant Create Account from ".$Umail.". Cant insert Data into table!", __FUNCTION__);
  684. return "Ein Unbekantes System Fehler ist aufgetretten!";
  685.  
  686. }
  687. }else{
  688. errorlog("[SQL] Cant Select Database", __FUNCTION__);
  689. return "Ein Unbekantes System Fehler ist aufgetretten!";
  690.  
  691. }
  692. }else{
  693. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  694. return "Ein Unbekantes System Fehler ist aufgetretten!";
  695. }
  696. }
  697.  
  698. function setSession($id){
  699. $sql = mysqlData();
  700. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  701. if($con){
  702. if(mysqli_select_db($con, $sql['database'])){
  703. $select = mysqli_query($con, "select * from regUsers where ID = '".$id."'");
  704. if(mysqli_num_rows($select)){
  705. $fetch = mysqli_fetch_assoc($select);
  706. $UUID = $fetch['UUID'];
  707. $SessKey = md5(RandomString());
  708. $update = mysqli_query($con, "update regUsers set Session_Key='".$SessKey."' where ID = '".$id."'");
  709. if($update){
  710. setcookie('DDSTSession', $SessKey, time()+3200);
  711. setcookie('DDSTUser', $UUID);
  712. return "OK";
  713. }else{
  714. errorlog("[SQL] Cant Update Session from RUSER ID: ".$id, __FUNCTION__);
  715. return "Ein Unbekantes System Fehler ist aufgetretten!";
  716. }
  717. }else{
  718. errorlog("[SQL] Cant Select Data from regUsers of ID: ".$id, __FUNCTION__);
  719. return "Ein Unbekantes System Fehler ist aufgetretten!";
  720. }
  721. }else{
  722. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  723. return "Ein Unbekantes System Fehler ist aufgetretten!";
  724. }
  725. }else{
  726. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  727. return "Ein Unbekantes System Fehler ist aufgetretten!";
  728. }
  729. }
  730.  
  731. function registerActiveAccount($UUID){
  732. $sql = mysqlData();
  733. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  734. if($con){
  735. if(mysqli_select_db($con, $sql['database'])){
  736. $check = mysqli_query($con, "select * from regUsers where UUID = '".$UUID."' and Account_Activation = '0'");
  737. if(mysqli_num_rows($check)){
  738. $update = mysqli_query($con, "update regUsers set Account_Activation='1' where UUID = '".$UUID."'");
  739. if($update){
  740. $select = mysqli_query($con, "select * from regUsers where UUID = '".$UUID."'");
  741. $fetch = mysqli_fetch_assoc($select);
  742. $Uuser = $fetch['R_User'];
  743. $mail = $fetch['e_Mail'];
  744. $id = $fetch['ID'];
  745. return "OK";
  746. }else{
  747. errorlog("[SQL] Cant update Table regUsers by uuid: ".$UUID, __FUNCTION__);
  748. return "Ein Unbekantes System Fehler ist aufgetretten!";
  749. }
  750. }else{
  751. return "Ihre Activation Parametern sind Falsch!";
  752. }
  753. }else{
  754. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  755. return "Ein Unbekantes System Fehler ist aufgetretten!";
  756. }
  757. }else{
  758. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  759. return "Ein Unbekantes System Fehler ist aufgetretten!";
  760. }
  761. }
  762.  
  763. function login($Uuser, $Upw, $sli){
  764. $sql = mysqlData();
  765. $pw = PWCoder($Upw);
  766. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  767. if($con){
  768. if(mysqli_select_db($con, $sql['database'])){
  769. $check = mysqli_query($con, "select * from regUsers where R_User = '".$Uuser."'
  770. and PW = '".$pw."'");
  771. if(mysqli_num_rows($check)){
  772. $fetch = mysqli_fetch_assoc($check);
  773. if($fetch['Account_Activation'] == "0"){
  774. return "Aktiviere dein account zuerst";
  775. }
  776. $session = md5(RandomString());
  777. $user = $fetch["UUID"];
  778. $datum = date("d").".".date("m").".".date("y")."_".date("s").":".date("i").":".date("H");
  779. $update = mysqli_query($con, "update regUsers set Session_Key='".$session."',Last_Login_Date='".$datum."' where UUID = '".$user."'");
  780. if($update){
  781. if($sli == "1"){
  782. setcookie('DDSTSession', $session, time()+999999999);
  783. }else{
  784. setcookie('DDSTSession', $session, time()+3200);
  785. }
  786. setcookie('DDSTUser', $user);
  787. return "OK";
  788. }else{
  789. errorlog("[SQL] Cant Update User Session from ".$Uuser, __FUNCTION__);
  790. return "ERROR: Ein Unbekantes Fehler ist aufgetretten!";
  791. }
  792.  
  793. }else{
  794. return "Benutzer oder Password Falsch";
  795. }
  796. }else{
  797. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  798. }
  799. }else{
  800. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  801. }
  802.  
  803. }
  804.  
  805. function IsLoggedIn(){
  806. $ses = $_COOKIE['DDSTSession'];
  807. $uuid = $_COOKIE['DDSTUser'];
  808. if($ses == "000"){
  809. return "NO";
  810. }
  811. $sql = mysqlData();
  812. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  813. if($con){
  814. if(mysqli_select_db($con, $sql['database'])){
  815. $query = mysqli_query($con, "select * from regUsers where UUID = '".$uuid."' and Session_Key = '".$ses."'");
  816. if(mysqli_num_rows($query)){
  817. return "YES";
  818. }else{
  819. return "NO";
  820. }
  821. }else{
  822. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  823. }
  824. }else{
  825. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  826. }
  827. }
  828.  
  829.  
  830. function getAccountData($uuid, $atr){
  831. $sql = mysqlData();
  832. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  833. if($con){
  834. if(mysqli_select_db($con, $sql['database'])){
  835. $select = mysqli_query($con, "select * from regUsers where UUID = '".$uuid."'");
  836. if(mysqli_num_rows($select)){
  837. $fetch = mysqli_fetch_assoc($select);
  838. return $fetch[$atr];
  839. }else{
  840. errorlog("[SQL] Cant select Data from UUID: ".$uuid, __FUNCTION__);
  841. return "ERROR";
  842. }
  843. }else{
  844. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  845. }
  846. }else{
  847. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  848. }
  849. }
  850.  
  851. function forgLoginUser($mail){
  852. $sql = mysqlData();
  853. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  854. if($con){
  855. if(mysqli_select_db($con, $sql['database'])){
  856. $select = mysqli_query($con, "select * from regUsers where e_Mail = '".$mail."'");
  857. if(mysqli_num_rows($select)){
  858. $fetch = mysqli_fetch_assoc($select);
  859. $name = $fetch['R_User'];
  860. $mailtopbox = file_get_contents("data/config/mail-layout/top-box.lexx");
  861. $mailbotbox = file_get_contents("data/config/mail-layout/bot-box.lexx");
  862. $message = "<h1 style='color: #ffaa00;'>Hallo ".$name."</h1><p>Du hast anscheinend dein Login Name vergessen!</p><br><br>Benutzer:<br><h2 style='background-color: #777777;'>".$name."</h2>";
  863.  
  864. $msg = $mailtopbox.$message.$mailbotbox;
  865. $send = sysSendMail($mail, $msg, "[DDST System] Login Daten Vergesssen!", $name);
  866. if($send == "OK"){
  867. return "OK";
  868. }else{
  869. errorlog("[MAIL] Cant Send Forgote Login Date Mail for ".$mail, __FUNCTION__);
  870. return "Ein unbekanntes Fehler ist aufgetretten. versuchen sie es erneuert.";
  871. }
  872. }else{
  873. return "Dieses Email ist nicht registriert!";
  874. }
  875. }else{
  876. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  877. }
  878. }else{
  879. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  880. }
  881. }
  882.  
  883. function forgLoginPass($mail){
  884. $sql = mysqlData();
  885. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  886. if($con){
  887. if(mysqli_select_db($con, $sql['database'])){
  888. $select = mysqli_query($con, "select * from regUsers where e_Mail = '".$mail."'");
  889. if(mysqli_num_rows($select)){
  890. $fetch = mysqli_fetch_assoc($select);
  891. $name = $fetch['R_User'];
  892. $randS = RandomString();
  893. $newPw = PWCoder($randS);
  894. $update = mysqli_query($con, "update regUsers set PW='".$newPw."' where e_Mail = '".$mail."'");
  895. if($update){
  896. $mailtopbox = file_get_contents("data/config/mail-layout/top-box.lexx");
  897. $mailbotbox = file_get_contents("data/config/mail-layout/bot-box.lexx");
  898. $message = "<h1 style='color: #ffaa00;'>Hallo ".$name."</h1>
  899. <p>Ihre neues Password lautet: <span style='color: #ffaa00;'>".$randS."</span></p>
  900. ";
  901. $msg = $mailtopbox.$message.$mailbotbox;
  902. $send = sysSendMail($mail, $msg, "[DDST System] Login Daten Vergesssen!", $name);
  903. if($send == "OK"){
  904. return "OK";
  905. }else{
  906. errorlog("[MAIL] Cant Send Forgote Login Date Mail for ".$mail, __FUNCTION__);
  907. return "Ein unbekanntes Fehler ist aufgetretten. versuchen sie es erneuert.";
  908. }
  909. }else{
  910. errorlog("[MAIL] Cant Update new Password for User ".$mail, __FUNCTION__);
  911. return "Ein unbekanntes Fehler ist aufgetretten. versuchen sie es erneuert.";
  912. }
  913. }else{
  914. return "Dieses Email ist nicht registriert!";
  915. }
  916. }else{
  917. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  918. }
  919. }else{
  920. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  921. }
  922. }
  923.  
  924. function changeUserPassword($uuid, $pws){
  925. $sql = mysqlData();
  926. $pw = PWCoder($pws);
  927. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  928. if($con){
  929. if(mysqli_select_db($con, $sql['database'])){
  930. $update = mysqli_query($con, "update regUsers set PW='".$pw."' where UUID='".$uuid."'");
  931. if($update){
  932. return "OK";
  933. }else{
  934. errorlog("[SQL] Cant change Password from uuid ".$uuid, __FUNCTION__);
  935. return "ERROR: Dein Password konnte nicht geändert werden. Kontaktier den Admin";
  936. }
  937. }else{
  938. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  939. }
  940. }else{
  941. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  942. }
  943. }
  944.  
  945.  
  946. function changeUserData($uuid, $atr, $value){
  947. $sql = mysqlData();
  948. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  949. if($con){
  950. if(mysqli_select_db($con, $sql['database'])){
  951. $check = mysqli_query($con, "select * from regUser where ".$atr." = '".$value."'");
  952. if(mysqli_num_rows($check)){
  953. return $value." Existiert bereits";
  954. }else{
  955. $update = mysqli_query($con, "update regUsers set ".$atr."='".$value."' where UUID = '".$uuid."'");
  956. if($update){
  957. return "OK";
  958. }else{
  959. errorlog("[SQL] Cant Change data From UUID: ".$uuid, __FUNCTION__);
  960. return "ERROR: Deine Daten konnten nicht geändert werden. Kontaktieren sie den Admin";
  961. }
  962. }
  963. }else{
  964. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  965. }
  966. }else{
  967. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  968. }
  969. }
  970.  
  971.  
  972. function printFAQ(){
  973. $folder = "data/FAQ/";
  974. $count = 0;
  975. $scan = scandir($folder);
  976. if($scan){
  977. foreach($scan as $file){
  978. if($file != "." && $file != ".."){
  979. if(substr($file, -4, strlen($file)) == "lexx"){
  980. $head = substr($file, 0, strlen($file)-5);
  981. $text = file_get_contents($folder.$file);
  982. $count++;
  983. echo "
  984. <div class='panel panel-default panel-faq'>
  985. <div class='panel-heading'>
  986. <a data-toggle='collapse' data-parent='#accordion' href='#faq-sub-".$count."'>
  987. <h4 class='panel-title'>
  988. ".$head."
  989. <span class='pull-right'>
  990. <i class='glyphicon glyphicon-plus'></i>
  991. </span>
  992. </h4>
  993. </a>
  994. </div>
  995. <div id='faq-sub-".$count."' class='panel-collapse collapse'>
  996. <div class='panel-body'>
  997. ".$text."
  998. </div>
  999. </div>
  1000. </div>
  1001. ";
  1002. }
  1003. }
  1004.  
  1005. }
  1006. if($count == 0){
  1007. echo "Kein F.A.Q. Fragen forhanden";
  1008. }
  1009. }else{
  1010. echo "ERROR";
  1011. }
  1012.  
  1013. }
  1014.  
  1015. function UserHavePerms($perm){
  1016. $uuid = $_COOKIE['DDSTUser'];
  1017. $sql = mysqlData();
  1018. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1019. if($con){
  1020. if(mysqli_select_db($con, $sql['database'])){
  1021. $selectU = mysqli_query($con, "select regUsers.UUID,Groups.G_ID,Groups.".$perm." from regUsers left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.UUID = '".$uuid."'");
  1022. if($selectU){
  1023. $fetch = mysqli_fetch_assoc($selectU);
  1024. if($fetch[$perm] == "1"){
  1025. return "YES";
  1026. }else{
  1027. return "NO";
  1028. }
  1029. }else{
  1030. return "NO";
  1031. }
  1032. }else{
  1033. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1034. }
  1035. }else{
  1036. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1037. }
  1038. }
  1039.  
  1040. function getUserGroup(){
  1041. $uuid = $_COOKIE['DDSTUser'];
  1042. $sql = mysqlData();
  1043. $data = array();
  1044. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1045. if($con){
  1046. if(mysqli_select_db($con, $sql['database'])){
  1047. $selectU = mysqli_query($con, "select regUsers.UUID,Groups.G_ID,Groups.Group_Name,Groups.Group_Prefix,Groups.color
  1048. from regUsers left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.UUID = '".$uuid."'");
  1049. if($selectU){
  1050. $fetch = mysqli_fetch_assoc($selectU);
  1051. $data['name'] = $fetch["Group_Name"];
  1052. $data['prefix'] = $fetch["Group_Prefix"];
  1053. $data['color'] = $fetch["color"];
  1054. return $data;
  1055. }else{
  1056. return $data;
  1057. }
  1058. }else{
  1059. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1060. }
  1061. }else{
  1062. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1063. }
  1064. }
  1065.  
  1066. function getPortalVideosOptions($nowe){
  1067. $folder = "data/video";
  1068. $scan = scandir($folder);
  1069. foreach($scan as $file){
  1070. $now = substr($nowe, 0, strlen($file));
  1071. if($file != ".." && $file != "." && !is_dir($folder."/".$file)){
  1072. echo "
  1073. <option value=".$file." ";
  1074. if($file == $now){echo "selected";}
  1075. echo ">".$file."</option>
  1076. ";
  1077. }
  1078. }
  1079. }
  1080.  
  1081. function getBackgroundOptions($nowe){
  1082. $folder = "data/pic/bg";
  1083. $scan = scandir($folder);
  1084. foreach($scan as $file){
  1085. $now = substr($nowe, 0, strlen($file));
  1086. if($file != ".." && $file != "." && !is_dir($folder."/".$file)){
  1087. echo "
  1088. <option value=".$file." ";
  1089. if($file == $now){echo "selected";}
  1090. echo ">".$file."</option>
  1091. ";
  1092. }
  1093. }
  1094. }
  1095.  
  1096. function editConfig($file, $what, $value){
  1097. $rewrite = "";
  1098. $read = fopen($file, "r");
  1099. if($read){
  1100. while($line = fgets($read)){
  1101. if(substr($line, 0, strpos($line, "=")) == $what){
  1102. $rewrite .= $what."=".$value."\n";
  1103. }else{
  1104. $rewrite .= $line;
  1105. }
  1106. }
  1107. file_put_contents($file, $rewrite);
  1108. return "OK";
  1109. }else{
  1110. errorlog("[SYSTEM] Cant Cant open File ".$file, __FUNCTION__);
  1111. return "ERROR";
  1112. }
  1113. }
  1114.  
  1115. function sitesOptions($sel){
  1116. $folder = "./";
  1117. $is = "";
  1118. $scan = scandir($folder);
  1119. if($scan){
  1120. foreach($scan as $file){
  1121. $is = "";
  1122. if($file != "." && $file != ".." && !is_dir($folder.$file) && $file != ".ftpquota"){
  1123. if(substr($file, 0, 5) != "admin"){
  1124. if(substr($file, 0, strlen($file)) == substr($sel, 0, -2)){
  1125. $is = "selected";
  1126. }
  1127. echo "<option value='".$file."' ".$is.">".$file."</option>";
  1128. }
  1129. }
  1130. }
  1131. }else{
  1132. echo "<option>ERROR</option>";
  1133. }
  1134. }
  1135.  
  1136. function PortalNavigationEditor(){
  1137. $file = "data/config/navigation.lexx";
  1138. $name = "";
  1139. $type = "";
  1140. $link = "";
  1141. $count = 0;
  1142. $read = fopen($file, "r");
  1143. while($line = fgets($read)){
  1144. if(substr($line, 0, 2) == "<-"){
  1145. while($line = fgets($read)){
  1146. $href = "";
  1147. if(substr($line, 0, 4) == "name"){
  1148. $name = substr($line, strpos($line, "=")+1, strlen($line));
  1149. }
  1150. if(substr($line, 0, 4) == "link"){
  1151. $link = substr($line, strpos($line, "=")+1, strlen($line));
  1152. }
  1153. if(substr($line, 0, 4) == "type"){
  1154. $type = substr($line, strpos($line, "=")+1, strlen($line));
  1155. }
  1156. if(substr($line, 0, 2) == "->"){
  1157. $count++;
  1158. if($name != "" && $link != "" && $type != ""){
  1159. echo "
  1160.  
  1161. <div class='col-md-4'>
  1162. <label>Name</label>
  1163. <input type='text' class='form-control' name='name".$count."' value='".$name."' placeholder='name des Links'>
  1164. </div>
  1165. <div class='col-md-8'>
  1166. <div class='col-md-6'>
  1167. <input type='radio' name='site".$count."' value='site'";
  1168. if(substr($type, 0, 4) == "site"){
  1169. echo "checked";
  1170. }
  1171. echo "> Vorhandene Seite
  1172. <select name='sitePage1' class='form-control'>
  1173. ";
  1174. sitesOptions($link);
  1175. echo "
  1176. </select>
  1177. </div>
  1178. <div class='col-md-6'>
  1179. <input type='radio' name='site".$count."' value='link' ";
  1180. if(substr($type, 0, 4) == "http"){
  1181. echo "checked";
  1182. }
  1183. if(substr($type, 0, 4) != "site"){
  1184. $href = $link;
  1185. }
  1186. echo "> Link
  1187. <input type='text' name='link".$count."' class='form-control' value='".$href."' placeholder='http Link hier'>
  1188. </div>
  1189. </div>
  1190. <div class='col-md-12 margin-vert-30'>
  1191. <hr>
  1192. </div>
  1193.  
  1194. ";
  1195. }
  1196. break;
  1197. }
  1198. }
  1199. }
  1200. }
  1201. }
  1202.  
  1203. function howBGs(){
  1204. $folder = "data/pic/bg/";
  1205. $scan = scandir($folder);
  1206. foreach($scan as $file){
  1207. if($file != "." && $file != ".." && !is_dir($folder.$file)){
  1208. echo "
  1209. <div class='col-md-4 margin-vert-20 margin-horiz-20'>
  1210. <img src='data/pic/bg/".$file."'>
  1211. <label>".$file."</label><br>
  1212. <a href='admin-bg-control.php?del=".$file."' class='btn btn-xs btn-red' title='löschen'><i class='glyphicon glyphicon-floppy-remove'></i></a>
  1213. <a href='data/pic/bg/".$file."' class='btn btn-xs btn-blue' target='_blanc' title='Ansehen oder HD herunterladen'><i class='glyphicon glyphicon-eye-open'></i></a>
  1214. </div>
  1215. ";
  1216. }
  1217. }
  1218. }
  1219.  
  1220. function howVIDs(){
  1221. $folder = "data/video/";
  1222. $scan = scandir($folder);
  1223. foreach($scan as $file){
  1224. if($file != "." && $file != ".." && !is_dir($folder.$file)){
  1225. echo "
  1226. <div class='col-md-4 margin-vert-20 margin-horiz-20'>
  1227. <video width='200' controls>
  1228. <source src='data/video/".$file."' type='video/mp4'>
  1229. Dein Browser Supportet kein HTML5.
  1230. </video>
  1231. <label>".$file."</label><br>
  1232. <a href='admin-vid-control.php?del=".$file."' class='btn btn-xs btn-red' title='löschen'><i class='glyphicon glyphicon-floppy-remove'></i></a>
  1233. <a href='data/video/".$file."' class='btn btn-xs btn-blue' target='_blanc' title='Ansehen oder HD herunterladen'><i class='glyphicon glyphicon-eye-open'></i></a>
  1234. </div>
  1235. ";
  1236. }
  1237. }
  1238. }
  1239.  
  1240.  
  1241.  
  1242. function printNavigation(){
  1243. $file = "data/config/top-navigation.lexx";
  1244. $read = fopen($file, "r");
  1245. if($read){
  1246. while($line = fgets($read)){
  1247. if(substr($line, 0, 3) == "<B-"){
  1248. while($line = fgets($read)){
  1249. if(substr($line, 0, 4) == "icon"){
  1250. $icon = substr($line, strpos($line, "=")+1, strlen($line));
  1251. }
  1252. if(substr($line, 0, 4) == "name"){
  1253. $name = substr($line, strpos($line, "=")+1, strlen($line));
  1254. }
  1255. if(substr($line, 0, 4) == "link"){
  1256. $link = substr($line, strpos($line, "=")+1, strlen($line));
  1257. }
  1258. if(substr($line, 0, 4) == "perm"){
  1259. $perm = substr($line, strpos($line, "=")+1, strlen($line));
  1260. if(IsLoggedIn() == "YES"){
  1261. $perms = substr($perm, 0, -2);
  1262. if(UserHavePerms($perms) != "YES"){
  1263. $name = "";
  1264. $link = "";
  1265. $perm = "";
  1266. break;
  1267. }
  1268. }else{
  1269. $name = "";
  1270. $link = "";
  1271. $perm = "";
  1272. break;
  1273. }
  1274. }
  1275. if(substr($line, 0, 5) == "<DD--"){
  1276. echo "
  1277. <li>
  1278. <span class='".$icon."'>".$name."</span>
  1279. <ul>
  1280. ";
  1281. while($line = fgets($read)){
  1282. if(substr($line, 0, 4) == "<DB-"){
  1283. while($line = fgets($read)){
  1284. if(substr($line, 0, 4) == "name"){
  1285. $name = substr($line, strpos($line, "=")+1, strlen($line));
  1286. }
  1287. if(substr($line, 0, 4) == "link"){
  1288. $link = substr($line, strpos($line, "=")+1, strlen($line));
  1289. }
  1290. if(substr($line, 0, 4) == "perm"){
  1291. $perm = substr($line, strpos($line, "=")+1, strlen($line));
  1292. if(IsLoggedIn() == "YES"){
  1293. $perms = substr($perm, 0, -2);
  1294. if(UserHavePerms($perms) != "YES"){
  1295. $name = "";
  1296. $link = "";
  1297. $perm = "";
  1298. break;
  1299. }
  1300. }else{
  1301. $name = "";
  1302. $link = "";
  1303. $perm = "";
  1304. break;
  1305. }
  1306. }
  1307. if(substr($line, 0, 4) == "-DB>"){
  1308. if($name != "" && $link != ""){
  1309. echo "
  1310. <li>
  1311. <a href='".$link."'>".$name."</a>
  1312. </li>
  1313. ";
  1314. }
  1315. $name = "";
  1316. $link = "";
  1317. $perm = "";
  1318. break;
  1319. }
  1320. }
  1321. }
  1322. if(substr($line, 0, 5) == "--DD>"){
  1323. echo "
  1324. </ul>
  1325. </li>
  1326. ";
  1327. break;
  1328. }
  1329. }
  1330. }
  1331. if(substr($line, 0, 3) == "-B>"){
  1332. if($icon != "" && $name != "" && $link != ""){
  1333. echo "
  1334. <li>
  1335. <a href='".$link."' class='".$icon."'> ".$name."</a>
  1336. </li>
  1337. ";
  1338. }
  1339. $icon = "";
  1340. $name = "";
  1341. $link = "";
  1342. $perm = "";
  1343. break;
  1344. }
  1345. }
  1346. }
  1347. }
  1348. }
  1349. }
  1350.  
  1351. function adminShowFaqs(){
  1352. $folder = "data/FAQ/";
  1353. $scan = scandir($folder);
  1354. if($scan){
  1355. foreach($scan as $file){
  1356. if(!is_dir($folder.$file)){
  1357. $name = substr($file, 0, -5);
  1358. echo "
  1359. <div class='col-md-12 margin-vert-30'>
  1360. <div class='col-md-6'>
  1361. <b>".$name."</b>
  1362. </div>
  1363. <div class='col-md-6'>
  1364. <a href='admin-faq-edit.php?action=edit&name=".$name."' class='btn btn-xs btn-warning' title='bearbeiten'><i class='fa fa-pencil'></i></a>
  1365. <a href='admin-faq-edit.php?action=delete&name=".$name."' class='btn btn-xs btn-danger' title='löschen'><i class='fa fa-times'></i></a>
  1366. </div>
  1367. </div>
  1368. ";
  1369. }
  1370. }
  1371. }else{
  1372. echo "ERROR: Folder Error.";
  1373. }
  1374. }
  1375.  
  1376. function getUserData($what){
  1377. $UUID = $_COOKIE['DDSTUser'];
  1378. $sql = mysqlData();
  1379. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1380. if($con){
  1381. if(mysqli_select_db($con, $sql['database'])){
  1382. $query = mysqli_query($con, "select * from regUsers where UUID='".$UUID."'");
  1383. if(mysqli_num_rows($query)){
  1384. $fetch = mysqli_fetch_assoc($query);
  1385. return $fetch[$what];
  1386. }else{
  1387. errorlog("[SQL] Cant Select Userdata From ".$UUID, __FUNCTION__);
  1388. }
  1389. }else{
  1390. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1391. }
  1392. }else{
  1393. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1394. }
  1395. }
  1396.  
  1397. function getAnotherUserData($uuid, $what){
  1398. $UUID = $uuid;
  1399. $sql = mysqlData();
  1400. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1401. if($con){
  1402. if(mysqli_select_db($con, $sql['database'])){
  1403. $query = mysqli_query($con, "select * from regUsers where UUID='".$UUID."'");
  1404. if(mysqli_num_rows($query)){
  1405. $fetch = mysqli_fetch_assoc($query);
  1406. return $fetch[$what];
  1407. }else{
  1408. errorlog("[SQL] Cant Select Userdata From ".$UUID, __FUNCTION__);
  1409. }
  1410. }else{
  1411. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1412. }
  1413. }else{
  1414. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1415. }
  1416. }
  1417.  
  1418. function postNewSupportTicket($id, $thema, $topic){
  1419. $date = date("d").".".date("M").".".date("Y");
  1420. $time = date("i").":".date("H");
  1421. $DisID = $id.md5(RandomString());
  1422. $sql = mysqlData();
  1423. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1424. if($con){
  1425. if(mysqli_select_db($con, $sql['database'])){
  1426. $update = mysqli_query($con, "insert into SupportTickets (PostBy, Discussion_ID, Type, Stats, Datum, Zeit, Thema, Topic) values('".$id."','".$DisID."','Ticket','Open','".$date."','".$time."','".$thema."','".$topic."')");
  1427. if($update){
  1428. return "OK";
  1429. }else{
  1430. errorlog("[SQL] Cant Insert New Support Ticket from User ".$_COOKIE['DDSTUser'], __FUNCTION__);
  1431. }
  1432. }else{
  1433. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1434. }
  1435. }else{
  1436. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1437. }
  1438. }
  1439.  
  1440. function printTickets(){
  1441. $sql = mysqlData();
  1442. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1443. if($con){
  1444. if(mysqli_select_db($con, $sql['database'])){
  1445. $select = mysqli_query($con, "select
  1446. SupportTickets.T_ID,
  1447. regUsers.R_User,
  1448. SupportTickets.Stats,
  1449. SupportTickets.Datum,
  1450. SupportTickets.Thema,
  1451. SupportTickets.Discussion_ID,
  1452. SupportTickets.Zeit
  1453. from SupportTickets
  1454. left join regUsers on SupportTickets.PostBy = regUsers.ID
  1455. where SupportTickets.Stats = 'Open' and SupportTickets.Type = 'Ticket' or SupportTickets.Stats = 'Working' and SupportTickets.Type = 'Ticket' ");
  1456. if(mysqli_num_rows($select)){
  1457. while($fetch = mysqli_fetch_assoc($select)){
  1458. if($fetch['Stats'] == "Open"){
  1459. $status = "<span style='color: #00aaff;'>Offen</span>";
  1460. }
  1461. if($fetch['Stats'] == "Working"){
  1462. $status = "<span style='color: #ffaa00;'>Im Verarbeitung</span>";
  1463. }
  1464. if($fetch['Stats'] == "Closed"){
  1465. $status = "<span style='color: #ff0000;'>Abgeschlossen</span>";
  1466. }
  1467. echo "
  1468. <div class='col-md-12 margin-vert-30'>
  1469. <div class='row'>
  1470. <div class='col-md-1'>
  1471. <label>Nr: </label> ".$fetch['T_ID']."
  1472. </div>
  1473. <div class='col-md-11'>
  1474. <label>Benutzer: </label> ".$fetch['R_User']."
  1475. </div>
  1476. </div>
  1477. <div class='row'>
  1478. <div class='col-md-4'>
  1479. <label>Datum | Zeit: </label> ".$fetch['Datum']."_".$fetch['Zeit']."
  1480. </div>
  1481. <div class='col-md-2'>
  1482. <label>Status: </label> ".$status."
  1483. </div>
  1484. <div class='col-md-6'>
  1485. <label>Thema: </label> ".$fetch['Thema']."
  1486. </div>
  1487. </div>
  1488. <div class='col-md-12'>
  1489. <a href='support-panel-tickets.php?show=".$fetch['Discussion_ID']."' class='btn btn-xs btn-aqua' title='Ticke ansehen'><i class='fa fa-location-arrow'></i></a>
  1490. <a href='support-panel-tickets.php?action=close&tid=".$fetch['Discussion_ID']."' class='btn btn-xs btn-warning' title='Ticke schlissen'><i class='fa fa-thumbs-up'></i></a>
  1491. </div>
  1492. </div>
  1493. ";
  1494. }
  1495. }else{
  1496. echo "Zurzeit keine Tickets vorhanden";
  1497. }
  1498. }else{
  1499. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1500. }
  1501. }else{
  1502. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1503. }
  1504. }
  1505.  
  1506. function showTicketDis($show){
  1507. $sql = mysqlData();
  1508. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1509. if($con){
  1510. if(mysqli_select_db($con, $sql['database'])){
  1511. $select = mysqli_query($con, "select
  1512. SupportTickets.T_ID,
  1513. SupportTickets.Stats,
  1514. SupportTickets.Datum,
  1515. SupportTickets.Thema,
  1516. SupportTickets.Type,
  1517. SupportTickets.Stats,
  1518. SupportTickets.Discussion_ID,
  1519. SupportTickets.Zeit,
  1520. SupportTickets.Topic,
  1521. regUsers.R_User,
  1522. Groups.Group_Name,
  1523. Groups.color
  1524. from SupportTickets
  1525. left join regUsers on SupportTickets.PostBy = regUsers.ID
  1526. left join Groups on regUsers.G_ID = Groups.G_ID
  1527. where SupportTickets.Discussion_ID = '".$show."'
  1528. order by SupportTickets.Type desc");
  1529. if(mysqli_num_rows($select)){
  1530. while($fetch = mysqli_fetch_assoc($select)){
  1531. if($fetch['Stats'] == "Open"){
  1532. $status = "<span style='color: #00aaff;'>Offen</span>";
  1533. }
  1534. if($fetch['Stats'] == "Working"){
  1535. $status = "<span style='color: #ffaa00;'>Verarbeitung</span>";
  1536. }
  1537. if($fetch['Stats'] == "Closed"){
  1538. $status = "<span style='color: #ff0000;'>Geschlossen</span>";
  1539. }
  1540. if($fetch['Type'] == "Ticket"){
  1541. echo "
  1542. <div class='col-md-12'>
  1543. <div class=row'>
  1544. <div class='col-md-4'>
  1545. <span style='color: ".$fetch['color'].";'>".$fetch['Group_Name']."</span> <span style='font-size: 16px;'>".$fetch['R_User']."</span><br><br>
  1546. Gepostet am: <i>".$fetch['Datum']." | ".$fetch['Zeit']."</i><br>
  1547. </div>
  1548. <div class='col-md-8'>
  1549. <h3>".$fetch['Thema']."</h3>".$status."<br><br>
  1550. ".$fetch['Topic']."
  1551. </div>
  1552. </div>
  1553. </div>
  1554. <div class='col-md-12'><hr></div>
  1555. ";
  1556. }else{
  1557. echo "
  1558.  
  1559. <div class='col-md-12'>
  1560. <div class=row'>
  1561. <div class='col-md-4'>
  1562. <span style='color: ".$fetch['color'].";'>".$fetch['Group_Name']."</span> <span style='font-size: 16px;'>".$fetch['R_User']."</span><br><br>
  1563. Gepostet am: <i>".$fetch['Datum']." | ".$fetch['Zeit']."</i><br>
  1564. </div>
  1565. <div class='col-md-8'>
  1566. ".$fetch['Topic']."
  1567. </div>
  1568. </div>
  1569. </div>
  1570. ";
  1571. }
  1572.  
  1573. }
  1574. echo "<div class='col-md-12'><hr></div>
  1575. <div class='col-md-12 margin-vert-30'>
  1576. <form action='support-panel-tickets.php?show=".$show."' method='post'>
  1577. <input type='hidden' name='action' value='Answer'>
  1578. <input type='hidden' name='ticket' value='".$show."'>
  1579. <textarea name='topic' id='editor1' rows='5' cols='80'></textarea>
  1580. <script>
  1581. CKEDITOR.replace( 'editor1' );
  1582. </script>
  1583. <br><br>
  1584. <button class='btn btn-aqua'><i class='fa fa-save'></i> Antworten</button>
  1585. </form><br><br>
  1586. <a href='support-panel-tickets.php?action=close&tid=".$show."' class='btn btn-warning'><i class='fa fa-thumbs-up'></i> Ticket Schliessen</a>
  1587. </div>
  1588. ";
  1589. }else{
  1590. echo "Momentan Keine Tickets vorhanden";
  1591. errorlog("[SQL] Cant select all Information for the Ticket Shows", __FUNCTION__);
  1592. }
  1593. }else{
  1594. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1595. }
  1596. }else{
  1597. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1598. }
  1599. }
  1600.  
  1601.  
  1602. function answerToTicket($DisId, $topic){
  1603. $date = date("d").".".date("M").".".date("Y");
  1604. $time = date("i").":".date("H");
  1605. $UID = getUserData("ID");
  1606. $sql = mysqlData();
  1607. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1608. if($con){
  1609. if(mysqli_select_db($con, $sql['database'])){
  1610. $insert = mysqli_query($con, "insert into SupportTickets (PostBy ,Discussion_ID, Type, Stats, Datum, Zeit, Topic) values('".$UID."','".$DisId."','Answer', 'OK','".$date."','".$time."','".$topic."')");
  1611. if($insert){
  1612. $update = mysqli_query($con, "update SupportTickets set Stats='Working' where Discussion_ID='".$DisId."'");
  1613. if($update){
  1614. return "OK";
  1615. }else{
  1616. return "ERROR: 3";
  1617. errorlog("[SQL] Cant Update Stats Support Ticket from ".$DisId, __FUNCTION__);
  1618. }
  1619. }else{
  1620. errorlog("[SQL] Cant Insert Answer Support Ticket from ".$DisId, __FUNCTION__);
  1621. return "ERROR: 2";
  1622. }
  1623. }else{
  1624. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1625. return "ERROR: 1";
  1626. }
  1627. }else{
  1628. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1629. }
  1630. }
  1631.  
  1632.  
  1633. function closeTicket($TID){
  1634. $sql = mysqlData();
  1635. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1636. if($con){
  1637. if(mysqli_select_db($con, $sql['database'])){
  1638. $update = mysqli_query($con, "update SupportTickets set Stats='Closed' where Discussion_ID='".$TID."'");
  1639. if($update){
  1640. return "OK";
  1641. }else{
  1642. return "ERROR: Cant close Ticket ".$TID;
  1643. }
  1644. }else{
  1645. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1646. }
  1647. }else{
  1648. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1649. }
  1650. }
  1651.  
  1652.  
  1653. function showMyTickets(){
  1654. $UID = getUserData("ID");
  1655. $sql = mysqlData();
  1656. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1657. if($con){
  1658. if(mysqli_select_db($con, $sql['database'])){
  1659. $select = mysqli_query($con, "select
  1660. SupportTickets.T_ID,
  1661. regUsers.R_User,
  1662. SupportTickets.Stats,
  1663. SupportTickets.Datum,
  1664. SupportTickets.Thema,
  1665. SupportTickets.Discussion_ID,
  1666. SupportTickets.Zeit
  1667. from SupportTickets
  1668. left join regUsers on SupportTickets.PostBy = regUsers.ID
  1669. where SupportTickets.Type = 'Ticket' and SupportTickets.PostBy = '".$UID."'");
  1670. if(mysqli_num_rows($select)){
  1671. while($fetch = mysqli_fetch_assoc($select)){
  1672. if($fetch['Stats'] == "Open"){
  1673. $status = "<span style='color: #00aaff;'>Offen</span>";
  1674. }
  1675. if($fetch['Stats'] == "Working"){
  1676. $status = "<span style='color: #ffaa00;'>Im Verarbeitung</span>";
  1677. }
  1678. if($fetch['Stats'] == "Closed"){
  1679. $status = "<span style='color: #ff0000;'>Abgeschlossen</span>";
  1680. }
  1681. echo "
  1682. <div class='col-md-12 margin-vert-30'>
  1683. <div class='row'>
  1684. <div class='col-md-1'>
  1685. <label>Nr: </label> ".$fetch['T_ID']."
  1686. </div>
  1687. <div class='col-md-11'>
  1688. <label>Benutzer: </label> ".$fetch['R_User']."
  1689. </div>
  1690. </div>
  1691. <div class='row'>
  1692. <div class='col-md-4'>
  1693. <label>Datum | Zeit: </label> ".$fetch['Datum']."_".$fetch['Zeit']."
  1694. </div>
  1695. <div class='col-md-2'>
  1696. <label>Status: </label> ".$status."
  1697. </div>
  1698. <div class='col-md-6'>
  1699. <label>Thema: </label> ".$fetch['Thema']."
  1700. </div>
  1701. </div>
  1702. <div class='col-md-12'>
  1703. <a href='MyTickets.php?show=".$fetch['Discussion_ID']."' class='btn btn-xs btn-aqua' title='Ticke ansehen'><i class='fa fa-location-arrow'></i></a>
  1704. ";
  1705. if($fetch['Stats'] != "Closed"){
  1706. echo "<a href='MyTickets.php?action=close&tid=".$fetch['Discussion_ID']."' class='btn btn-xs btn-warning' title='Ticke schlissen'><i class='fa fa-thumbs-up'></i></a>";
  1707. }
  1708. echo "
  1709. </div>
  1710. </div>
  1711. ";
  1712. }
  1713. }else{
  1714. echo "Zurzeit keine Tickets vorhanden";
  1715. }
  1716. }else{
  1717. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1718. }
  1719. }else{
  1720. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1721. }
  1722. }
  1723.  
  1724.  
  1725. function showMyTicketDis($show){
  1726. $sql = mysqlData();
  1727. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  1728. if($con){
  1729. if(mysqli_select_db($con, $sql['database'])){
  1730. $select = mysqli_query($con, "select
  1731. SupportTickets.T_ID,
  1732. SupportTickets.Stats,
  1733. SupportTickets.Datum,
  1734. SupportTickets.Thema,
  1735. SupportTickets.Type,
  1736. SupportTickets.Stats,
  1737. SupportTickets.Discussion_ID,
  1738. SupportTickets.Zeit,
  1739. SupportTickets.Topic,
  1740. regUsers.R_User,
  1741. Groups.Group_Name,
  1742. Groups.color
  1743. from SupportTickets
  1744. left join regUsers on SupportTickets.PostBy = regUsers.ID
  1745. left join Groups on regUsers.G_ID = Groups.G_ID
  1746. where SupportTickets.Discussion_ID = '".$show."'
  1747. order by SupportTickets.Type desc");
  1748. if(mysqli_num_rows($select)){
  1749. while($fetch = mysqli_fetch_assoc($select)){
  1750. if($fetch['Stats'] == "Open"){
  1751. $status = "<span style='color: #00aaff;'>Offen</span>";
  1752. }
  1753. if($fetch['Stats'] == "Working"){
  1754. $status = "<span style='color: #ffaa00;'>Verarbeitung</span>";
  1755. }
  1756. if($fetch['Stats'] == "Closed"){
  1757. $status = "<span style='color: #ff0000;'>Geschlossen</span>";
  1758. }
  1759. if($fetch['Type'] == "Ticket"){
  1760. echo "
  1761. <div class='col-md-12'>
  1762. <div class=row'>
  1763. <div class='col-md-4'>
  1764. <span style='color: ".$fetch['color'].";'>".$fetch['Group_Name']."</span> <span style='font-size: 16px;'>".$fetch['R_User']."</span><br><br>
  1765. Gepostet am: <i>".$fetch['Datum']." | ".$fetch['Zeit']."</i><br>
  1766. </div>
  1767. <div class='col-md-8'>
  1768. <h3>".$fetch['Thema']."</h3>".$status."<br><br>
  1769. ".$fetch['Topic']."
  1770. </div>
  1771. </div>
  1772. </div>
  1773. <div class='col-md-12'><hr></div>
  1774. ";
  1775. $myTicketStats = $fetch['Stats'];
  1776. }else{
  1777. echo "
  1778.  
  1779. <div class='col-md-12'>
  1780. <div class=row'>
  1781. <div class='col-md-4'>
  1782. <span style='color: ".$fetch['color'].";'>".$fetch['Group_Name']."</span> <span style='font-size: 16px;'>".$fetch['R_User']."</span><br><br>
  1783. Gepostet am: <i>".$fetch['Datum']." | ".$fetch['Zeit']."</i><br>
  1784. </div>
  1785. <div class='col-md-8'>
  1786. ".$fetch['Topic']."
  1787. </div>
  1788. </div>
  1789. </div>
  1790. ";
  1791. }
  1792.  
  1793. }
  1794. if($myTicketStats != "Closed"){
  1795. echo "<div class='col-md-12'><hr></div>
  1796. <div class='col-md-12 margin-vert-30'>
  1797. <form action='support-panel-tickets.php?show=".$show."' method='post'>
  1798. <input type='hidden' name='action' value='Answer'>
  1799. <input type='hidden' name='ticket' value='".$show."'>
  1800. <textarea name='topic' id='editor1' rows='5' cols='80'></textarea>
  1801. <script>
  1802. CKEDITOR.replace( 'editor1' );
  1803. </script>
  1804. <br><br>
  1805. <button class='btn btn-aqua'><i class='fa fa-save'></i> Antworten</button>
  1806. </form><br><br>
  1807. <p>Wurde ihre Frage beantwortet? wenn ja? dan schlissen sie den Ticket selber. oder die Supporters werden es in einer Woche selber schliessen.</p>
  1808. <a href='MyTickets.php?action=close&tid=".$show."' class='btn btn-warning'><i class='fa fa-thumbs-up'></i> Ticket Schliessen</a>
  1809. </div>
  1810. ";
  1811. }else{
  1812. echo "<a href='MyTickets.php' class='btn btn-aqua'>Zurück</a><BR><BR>";
  1813. }
  1814.  
  1815. }else{
  1816. echo "Momentan Keine Tickets vorhanden";
  1817. errorlog("[SQL] Cant select all Information for the Ticket Shows", __FUNCTION__);
  1818. }
  1819. }else{
  1820. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  1821. }
  1822. }else{
  1823. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  1824. }
  1825. }
  1826.  
  1827. function printBewBedingungen(){
  1828. $file = "data/config/exernalData/bewbed.lexx";
  1829. $content = file_get_contents($file);
  1830. echo $content;
  1831. }
  1832.  
  1833.  
  1834. function showBewerbungen(){
  1835. $folder = "bewerbungen/";
  1836. $scan = scandir($folder);
  1837. if($scan){
  1838. $count = 0;
  1839. foreach($scan as $file){
  1840. if(is_dir($folder.$file) && $file != "." && $file != ".."){
  1841. $bewFolder = $folder.$file."/";
  1842. if(file_exists($bewFolder."stats.lexx") && file_exists($bewFolder."infoItems.lexx")){
  1843. $stats = file_get_contents($bewFolder."stats.lexx");
  1844. if($stats == "beworben=1\n\n"){
  1845. $count++;
  1846. $uuid = $file;
  1847. $private = config($bewFolder."perivat.lexx");
  1848. $name = $private['name'];
  1849. $vorname = $private['vorname'];
  1850. $username = getAnotherUserData($uuid, "R_User");
  1851. $Items = config($bewFolder."TankInfo.lexx");
  1852. $lvlnr = $Items['higstTank'];
  1853. $type = $Items['likeTankType'];
  1854. if(substr($type, 0, 5) == "light"){
  1855. $like = "data/pic/icon/TankLight.png";
  1856. }
  1857. if(substr($type, 0, 6) == "medium"){
  1858. $like = "data/pic/icon/TankMedium.png";
  1859. }
  1860. if(substr($type, 0, 5) == "heavy"){
  1861. $like = "data/pic/icon/TankHeavy.png";
  1862. }
  1863. if(substr($type, 0, 6) == "jeager"){
  1864. $like = "data/pic/icon/TankJeager.png";
  1865. }
  1866. if(substr($type, 0, 4) == "arti"){
  1867. $like = "data/pic/icon/TankArti.png";
  1868. }
  1869.  
  1870.  
  1871. if(substr($lvlnr, 0, 1) == "1"){ $lvl = "I"; }
  1872. if(substr($lvlnr, 0, 1) == "2"){ $lvl = "II"; }
  1873. if(substr($lvlnr, 0, 1) == "3"){ $lvl = "III"; }
  1874. if(substr($lvlnr, 0, 1) == "4"){ $lvl = "IV"; }
  1875. if(substr($lvlnr, 0, 1) == "5"){ $lvl = "V"; }
  1876. if(substr($lvlnr, 0, 1) == "6"){ $lvl = "VI"; }
  1877. if(substr($lvlnr, 0, 1) == "7"){ $lvl = "VII"; }
  1878. if(substr($lvlnr, 0, 1) == "8"){ $lvl = "VIII"; }
  1879. if(substr($lvlnr, 0, 1) == "9"){ $lvl = "IX"; }
  1880. if(substr($lvlnr, 0, 2) == "10"){ $lvl = "X"; }
  1881. echo "
  1882. <div class='col-md-12 margin-vert-30'>
  1883. <div class='row'>
  1884. <a href='admin-bew-manager.php?show=".$uuid."&action=show' class='col-md-12'>
  1885. <div class='col-md-4'>
  1886. ".$name." ".$vorname."
  1887. </div>
  1888. <div class='col-md-8'>
  1889. <div class='col-md-12'>
  1890. <div class='col-md-4'>
  1891. ".$lvl."
  1892. </div>
  1893. <div class='col-md-4'>
  1894. <img src='".$like."' width='20px'>
  1895. </div>
  1896. <div class='col-md-4'>
  1897. ".$username."
  1898. </div>
  1899. </div>
  1900. <div class='col-md-12'>
  1901. <a href='admin-bew-manager.php?show=".$uuid."&action=show' class='btn-sm btn-blue' title='Bewerbung ansehen'><i class='fa fa-eye'></i></a>
  1902. </div>
  1903. </div>
  1904. </a>
  1905. </div>
  1906. </div>
  1907. ";
  1908. }
  1909. }
  1910. }
  1911. }
  1912. if($count == 0){
  1913. echo "Zurzeit stehen keine Bewerbungen vor";
  1914. }
  1915. }else{
  1916. echo "ERROR: Cant Catch the Folder ".$folder;
  1917. }
  1918. }
  1919.  
  1920.  
  1921.  
  1922. function showBewerbungID($uuid){
  1923. $folder = "bewerbungen/".$uuid."/";
  1924. $whyJoinUs = file_get_contents($folder."whyJoinUs.lexx");
  1925. $isInClan = config($folder."isInClan.lexx");
  1926. $TankInfo = config($folder."TankInfo.lexx");
  1927. $infoItems = config($folder."infoItems.lexx");
  1928. $privat = config($folder."perivat.lexx");
  1929. if(substr($infoItems['muchOnline'], 0, 1) == "0"){
  1930. $oftOnline = "Schwer zu sagen";
  1931. }
  1932. if(substr($infoItems['muchOnline'], 0, 1) == "1"){
  1933. $oftOnline = "Fast gar nie";
  1934. }
  1935. if(substr($infoItems['muchOnline'], 0, 1) == "2"){
  1936. $oftOnline = "Teilweise";
  1937. }
  1938. if(substr($infoItems['muchOnline'], 0, 1) == "3"){
  1939. $oftOnline = "Viel";
  1940. }
  1941. $lvlnr = $TankInfo['higstTank'];
  1942. if(substr($lvlnr, 0, 1) == "1"){ $lvl = "I"; }
  1943. if(substr($lvlnr, 0, 1) == "2"){ $lvl = "II"; }
  1944. if(substr($lvlnr, 0, 1) == "3"){ $lvl = "III"; }
  1945. if(substr($lvlnr, 0, 1) == "4"){ $lvl = "IV"; }
  1946. if(substr($lvlnr, 0, 1) == "5"){ $lvl = "V"; }
  1947. if(substr($lvlnr, 0, 1) == "6"){ $lvl = "VI"; }
  1948. if(substr($lvlnr, 0, 1) == "7"){ $lvl = "VII"; }
  1949. if(substr($lvlnr, 0, 1) == "8"){ $lvl = "VIII"; }
  1950. if(substr($lvlnr, 0, 1) == "9"){ $lvl = "IX"; }
  1951. if(substr($lvlnr, 0, 2) == "10"){ $lvl = "X"; }
  1952. $plvlnr = $TankInfo['premiumTank'];
  1953. if(substr($plvlnr, 0, 1) == "1"){ $plvl = "I"; }
  1954. if(substr($plvlnr, 0, 1) == "2"){ $plvl = "II"; }
  1955. if(substr($plvlnr, 0, 1) == "3"){ $plvl = "III"; }
  1956. if(substr($plvlnr, 0, 1) == "4"){ $plvl = "IV"; }
  1957. if(substr($plvlnr, 0, 1) == "5"){ $plvl = "V"; }
  1958. if(substr($plvlnr, 0, 1) == "6"){ $plvl = "VI"; }
  1959. if(substr($plvlnr, 0, 1) == "7"){ $plvl = "VII"; }
  1960. if(substr($plvlnr, 0, 1) == "8"){ $plvl = "VIII"; }
  1961. if(substr($plvlnr, 0, 1) == "9"){ $plvl = "IX"; }
  1962. if(substr($plvlnr, 0, 2) == "10"){ $plvl = "X"; }
  1963. $type = $TankInfo['likeTankType'];
  1964. if(substr($type, 0, 5) == "light"){
  1965. $like = "data/pic/icon/TankLight.png";
  1966. }
  1967. if(substr($type, 0, 6) == "medium"){
  1968. $like = "data/pic/icon/TankMedium.png";
  1969. }
  1970. if(substr($type, 0, 5) == "heavy"){
  1971. $like = "data/pic/icon/TankHeavy.png";
  1972. }
  1973. if(substr($type, 0, 6) == "jeager"){
  1974. $like = "data/pic/icon/TankJeager.png";
  1975. }
  1976. if(substr($type, 0, 4) == "arti"){
  1977. $like = "data/pic/icon/TankArti.png";
  1978. }
  1979. if(substr($isInClan['inInClan'], 0, 3) == "YES"){
  1980. $istImClan = "Ja";
  1981. }else{
  1982. $istImClan = "Nein";
  1983. }
  1984. echo "
  1985. <div class='col-md-12 margin-vert-30'>
  1986. <h4>Wie lange Spiele ich schon World of Tanks</h4>
  1987. <div class='col-md-12' style='background-color: #eeeeee; padding: 20px;'>
  1988. ".$infoItems['wotPlayTime']."
  1989. </div>
  1990. </div>
  1991. <div class='col-md-12 margin-vert-30'>
  1992. <h4>Wieso will ich ihres Clan beitretten?</h4>
  1993. <div class='col-md-12' style='background-color: #eeeeee; padding: 20px;'>
  1994. ".$whyJoinUs."
  1995. </div>
  1996. </div>
  1997. <div class='col-md-12 margin-vert-30'>
  1998. <h4>Wie viel Zeit verbringe ich mit World of Tanks?</h4>
  1999. <label>".$oftOnline."</label>
  2000. <div class='col-md-12' style='background-color: #eeeeee; padding: 20px;'>
  2001. ".$infoItems['muchOnlineHardSay']."
  2002. </div>
  2003. </div>
  2004. <div class='col-md-12'>
  2005. <div class='col-md-4'>
  2006. <label>Welches Level ist mein höchster Panzer?</label><br>
  2007. ".$lvl."
  2008. </div>
  2009.  
  2010. <div class='col-md-4'>
  2011. <label>Mit welchem Panzer Spiele ich am liebsten?</label><br>
  2012. <img src='".$like."' width='20px;'>
  2013. </div>
  2014. <div class='col-md-4'>
  2015. <label>Habe ich auch ein Premium Panzer?</label><br>
  2016. ".$plvl."
  2017. </div>
  2018. </div>
  2019. <div class='col-md-12 margin-vert-30'>
  2020. <h2>Personalien</h2>
  2021. ".$privat['name']." ".$privat['vorname']."<br>
  2022. ".$privat['strasse']." ".$privat['hausNr']." <br>
  2023. ".$privat['plz']." ".$privat['ort']."<br>
  2024. Land: ".$privat['land']."<br><br>
  2025.  
  2026. Telefon: (".$privat['telvor'].")".$privat['telefon']."<br><br>
  2027. GeburtsDatum: ".$privat['birth']."
  2028. </div>
  2029. <div class='col-md-12'>
  2030. <label>Bin ich bereits in einem Clan?</label><br>
  2031. ".$istImClan."<br>
  2032. ".$isInClan['ClanName']."
  2033. </div>
  2034. <div class='col-md-12 margin-vert-30'>
  2035. <div class='col-md-4'>
  2036. <a href='admin-bew-manager.php?action=1&uuid=".$uuid."' class='btn btn-green'>Annehmen</a>
  2037. </div>
  2038. <div class='col-md-4' style='text-align: center;'>
  2039. <a href='admin-bew-manager.php?action=2&uuid=".$uuid."' class='btn btn-warning'>Diskussion</a>
  2040. </div>
  2041. <div class='col-md-4' style='text-align: right;'>
  2042. <a href='admin-bew-manager.php?action=3&uuid=".$uuid."' class='btn btn-red'>Ablehnen</a>
  2043. </div>
  2044. </div>
  2045. <div calss='col-md-12'>
  2046. <a href='admin-bew-manager.php' class='btn btn-aqua'><i class='fa fa-arrow-left'></i> Zurück zu Bewerbungen</a>
  2047. </div>
  2048.  
  2049. ";
  2050. }
  2051.  
  2052. function printMyMSG(){
  2053. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2054. $sql = mysqlData();
  2055. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2056. if($con){
  2057. if(mysqli_select_db($con, $sql['database'])){
  2058. $query = mysqli_query($con, "select * from MSG where msg_to = '".$UID."' order by msg_read");
  2059. if(mysqli_num_rows($query)){
  2060. while($fetch = mysqli_fetch_assoc($query)){
  2061. $getdata = mysqli_query($con, "select * from regUsers where ID = '".$fetch['msg_from']."'");
  2062. $fetch2 = mysqli_fetch_assoc($getdata);
  2063. $fromuser = $fetch2['R_User'];
  2064. $readed = $fetch['msg_read'];
  2065. $message = $fetch['message'];
  2066. $date = $fetch['datum'];
  2067. $dest = $fetch['destination'];
  2068. $type = $fetch['type'];
  2069. $msgID = $fetch['MSG_ID'];
  2070. $extras = "";
  2071. if($readed == "0"){
  2072. $new = "<img src='data/pic/icon/neu.png' height='40px'>";
  2073. }else{
  2074. $new = "";
  2075. }
  2076. if($type=="warning"){
  2077. $extras = "<img src='data/pic/icon/warning.png' width='30px'>";
  2078. }
  2079. echo "
  2080. <div class='col-md-12 margin-vert-30 login-page'>
  2081. <div class='row'>
  2082. <a href='MyMSG.php?action=delete&id=".$msgID."' class='btn btn-xs btn-red' title='löschen'><i class='fa fa-times'></i></a>";
  2083. if($readed == "0"){
  2084. echo "<a href='MyMSG.php?action=markread&id=".$msgID."' class='btn btn-xs btn-blue' title='als gelesen markieren'><i class='fa fa-eye'></i></a>";
  2085. }
  2086. echo "</div>
  2087. <h4>".$fromuser." ".$extras."</h4>
  2088. <p><b>Datum:</b> ".$date." ".$new."</p>
  2089. <p>
  2090. ".$message."
  2091. </p>
  2092. </div>
  2093. ";
  2094. }
  2095. }else{
  2096. echo "zuerzeit keine Nachrichten.";
  2097. }
  2098. }else{
  2099. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2100. }
  2101. }else{
  2102. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2103. }
  2104. }
  2105.  
  2106. function setPostReaded($msgID){
  2107. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2108. $sql = mysqlData();
  2109. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2110. if($con){
  2111. if(mysqli_select_db($con, $sql['database'])){
  2112. $update = mysqli_query($con, "update MSG set msg_read = '1' where msg_to = '".$UID."' and MSG_ID = '".$msgID."'");
  2113. if($update){
  2114. return "OK";
  2115. }else{
  2116. return "ERROR: Dein Nachricht konte nicht als gelesen markiert werden!";
  2117. }
  2118. }else{
  2119. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2120. }
  2121. }else{
  2122. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2123. }
  2124. }
  2125. function deleteMSGPost($msgID){
  2126. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2127. $sql = mysqlData();
  2128. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2129. if($con){
  2130. if(mysqli_select_db($con, $sql['database'])){
  2131. $update = mysqli_query($con, "delete from MSG where msg_to = '".$UID."' and MSG_ID = '".$msgID."'");
  2132. if($update){
  2133. return "OK";
  2134. }else{
  2135. return "ERROR: Dein Nachricht konte nicht als gelesen markiert werden!";
  2136. }
  2137. }else{
  2138. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2139. }
  2140. }else{
  2141. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2142. }
  2143. }
  2144.  
  2145. function markAllMsgReaded(){
  2146. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2147. $sql = mysqlData();
  2148. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2149. if($con){
  2150. if(mysqli_select_db($con, $sql['database'])){
  2151. $update = mysqli_query($con, "update MSG set msg_read='1' where msg_to='".$UID."'");
  2152. if($update){
  2153. return "OK";
  2154. }else{
  2155. return "ERROR: Deine Nachrichten konnten nicht verarbeitet werden!";
  2156. }
  2157. }else{
  2158. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2159. }
  2160. }else{
  2161. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2162. }
  2163. }
  2164.  
  2165. function deleteAllMsg(){
  2166. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2167. $sql = mysqlData();
  2168. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2169. if($con){
  2170. if(mysqli_select_db($con, $sql['database'])){
  2171. $update = mysqli_query($con, "delete from MSG where msg_to = '".$UID."'");
  2172. if($update){
  2173. return "OK";
  2174. }else{
  2175. return "ERROR: Deine Nachrichten konnten nicht verarbeitet werden!";
  2176. }
  2177. }else{
  2178. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2179. }
  2180. }else{
  2181. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2182. }
  2183. }
  2184.  
  2185. function getFormUserOptions(){
  2186. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2187. $sql = mysqlData();
  2188. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2189. if($con){
  2190. if(mysqli_select_db($con, $sql['database'])){
  2191. $get = mysqli_query($con, "select * from regUsers where ID != 1");
  2192. while($fetch = mysqli_fetch_assoc($get)){
  2193. if($fetch['ID'] != $UID){
  2194. echo "
  2195. <option value='".$fetch['ID']."'>".$fetch['R_User']."</option>
  2196. ";
  2197. }
  2198. }
  2199. }else{
  2200. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2201. }
  2202. }else{
  2203. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2204. }
  2205. }
  2206.  
  2207. function sendMSG($to, $from, $type, $dest, $message, $msgType, $mailType){
  2208. $sql = mysqlData();
  2209. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2210. if($con){
  2211. if(mysqli_select_db($con, $sql['database'])){
  2212. if($msgType == "msg"){
  2213. $date = date("d").".".date("M").".".date("Y")." ".date("H").":".date("i");
  2214. $add = mysqli_query($con, "insert into MSG (msg_to, msg_from, type, destination, datum, message)
  2215. values('".$to."','".$from."', '".$type."', '".$dest."', '".$date."', '".$message."')");
  2216. if($add){
  2217. $ans = "OK";
  2218. }
  2219. }
  2220. if($mailType == "mail"){
  2221. $select = mysqli_query($con, "select * from regUsers where ID = '".$to."'");
  2222. $fetch = mysqli_fetch_assoc($select);
  2223. $email = $fetch['e_Mail'];
  2224. $user = $fetch['R_User'];
  2225. $fromname = getAccountData($_COOKIE['DDSTUser'], "R_User");
  2226. $content = "Du hast eine Private Nachricht von".$fromname."<br><br>".$message;
  2227. $send = infoSendMail($email, $content, "[DDST] Private Nachricht von ".$fromname, $user);
  2228. if($send){
  2229. $ans = "OK";
  2230. }
  2231. }else{
  2232. if($ans == "OK"){
  2233. return "OK";
  2234. }else{
  2235. return "ERROR: Dein Nachricht wurde nicht gepostet";
  2236.  
  2237. }
  2238. }
  2239.  
  2240. }else{
  2241. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2242. }
  2243. }else{
  2244. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2245. }
  2246. }
  2247.  
  2248.  
  2249.  
  2250.  
  2251. function getMyMessageCount(){
  2252. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2253. $sql = mysqlData();
  2254. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2255. if($con){
  2256. if(mysqli_select_db($con, $sql['database'])){
  2257. $query = mysqli_query($con, "select count(MSG_ID) from MSG where msg_to = '".$UID."' and msg_read = '0'");
  2258. $fetch = mysqli_fetch_assoc($query);
  2259. return $fetch['count(MSG_ID)'];
  2260. }else{
  2261. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2262. }
  2263. }else{
  2264. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2265. }
  2266. }
  2267.  
  2268. function checkForExistedDiscussion($uuid){
  2269. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2270. $sql = mysqlData();
  2271. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2272. if($con){
  2273. if(mysqli_select_db($con, $sql['database'])){
  2274. $check = mysqli_query($con, "select * from BewDis where UserDis = '".$uuid."' and type = 'topic'");
  2275. if(mysqli_num_rows($check)){
  2276. ?>
  2277. <script>
  2278. window.location.href = "bew-diskussion.php?action=show&dis=<? echo $uuid; ?>";
  2279. </script>
  2280. <?
  2281. }else{
  2282. ?>
  2283. <form action="bew-diskussion.php" method="post">
  2284. <input type="hidden" name="action" value="startNewDis">
  2285. <input type="hidden" name="DisID" value="<? echo $uuid; ?>">
  2286. <textarea name="topic" id="editor1" rows="20" cols="80"><? echo $_POST['message']; ?></textarea>
  2287. <script>
  2288. CKEDITOR.replace( 'editor1' );
  2289. </script>
  2290. <button class="btn btn-warning margin-vert-30">Diskussion erstellen <i class="fa fa-share"></i></button>
  2291. </form>
  2292. <?
  2293. }
  2294. }else{
  2295. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2296. }
  2297. }else{
  2298. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2299. }
  2300. }
  2301.  
  2302. function createNewBewDis($DisID, $topic){
  2303. $sql = mysqlData();
  2304. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2305. if($con){
  2306. if(mysqli_select_db($con, $sql['database'])){
  2307. $date = date("d").".".date("M").".".date("Y")." ".date("H").":".date("i");
  2308. $fromU = getAccountData($_COOKIE['DDSTUser'], "ID");
  2309. $type = "topic";
  2310. $stats = "work";
  2311. $insert = mysqli_query($con, "insert into BewDis (UserDis,type,fromU,datum,sstats,topic) values('".$DisID."','".$type."','".$fromU."','".$date."','".$stats."','".$topic."')");
  2312. if($insert){
  2313. echo "insert=".$insert;
  2314. $toID = getAccountData($DisID, "ID");
  2315. $mess = getAccountData($_COOKIE['DDSTUser'], "R_User")." hat mit ihnen eine Diskussion angefangen: <a href=\"bew-diskussion.php?action=show&dis=".$DisID."\">Hier</a>";
  2316. $test = "insert into MSG (msg_to, msg_from, type, destination, datum, message)
  2317. values('".$toID."','1','warning','privat','".$date."','".$mess."')";
  2318. $sendMGS = mysqli_query($con, $test);
  2319. if(!mysqli_errno($con)){
  2320. return "OK";
  2321. }else{
  2322. echo mysqli_error($con);
  2323. }
  2324. }else{
  2325. return "ERROR: Cant insert new Data in BewDis!";
  2326. }
  2327. }else{
  2328. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2329. }
  2330. }else{
  2331. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2332. }
  2333. }
  2334.  
  2335. function printDis($disId){
  2336. $sql = mysqlData();
  2337. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2338. if($con){
  2339. if(mysqli_select_db($con, $sql['database'])){
  2340. if(getAccountData($_COOKIE['DDSTUser'], "UUID") == $disId || UserHavePerms("ADMIN_BEWERBUNG_MANAGER") == "YES"){
  2341. $select = mysqli_query($con, "
  2342. select BewDis.BWD_ID,BewDis.UserDis,BewDis.fromU,BewDis.datum,BewDis.sstats,BewDis.topic,regUsers.ID,regUsers.R_User,regUsers.G_ID,Groups.G_ID,Groups.Group_Name,Groups.color from BewDis
  2343. left join regUsers on BewDis.fromU=regUsers.ID
  2344. left join Groups on regUsers.G_ID=Groups.G_ID
  2345. where BewDis.UserDis = '".$disId."' and sstats = 'work'
  2346. order by BewDis.BWD_ID
  2347. ");
  2348. if(mysqli_num_rows($select)){
  2349. $checker = 0;
  2350. while($fetch = mysqli_fetch_assoc($select)){
  2351. $datum = $fetch['datum'];
  2352. $Gcolor = $fetch['color'];
  2353. $Groupname = $fetch['Group_Name'];
  2354. $user = $fetch['R_User'];
  2355. $UID = $fetch['fromU'];
  2356. $topic = $fetch['topic'];
  2357. if($fetch['sstats'] == "work"){
  2358. $checker = 1;
  2359. }
  2360. echo "
  2361. <div class='col-md-12 margin-vert-30'>
  2362. <div class='row'>
  2363. <div class='col-md-3'>
  2364. <div class='col-md-12 login-page'>
  2365. <a href='Users.php?action=show&id=".$UID."' style='color: #000000;'><span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$Gcolor.";'>".$Groupname."</span> <b>".$user."</b></a>
  2366. <br><br>
  2367. <b>Datum:</b> ".$datum."
  2368. </div>
  2369. </div>
  2370. <div class='col-md-9' style='border-left: 2px solid #000000;'>
  2371. <p>
  2372. ".$topic."
  2373. </p>
  2374. </div>
  2375. </div>
  2376. </div>
  2377. ";
  2378. }
  2379. if($checker == 1){
  2380. echo "
  2381. <div class='col-md-12'><hr></div>
  2382. <div class='col-md-12'>
  2383. <form action='bew-diskussion.php' method='post'>
  2384. <input type='hidden' name='action' value='answer'>
  2385. <input type='hidden' name='disID' value='".$disId."'>
  2386. <textarea name='message' id='editor1' rows='20' cols='80'></textarea>
  2387. <script>
  2388. CKEDITOR.replace( 'editor1' );
  2389. </script><br><br>
  2390. <button class='btn btn-aqua'>Antworten</button>
  2391. </form>
  2392. </div>
  2393. ";
  2394. echo "
  2395. <div class='col-md-12'>
  2396. <div class='col-md-12 margin-vert-30'>
  2397. <div class='col-md-4'>
  2398. <a href='admin-bew-manager.php?action=1&uuid=".$disId."' class='btn btn-green'>Annehmen</a>
  2399. </div>
  2400. <div class='col-md-4'>
  2401. </div>
  2402. <div class='col-md-4' style='text-align: right;'>
  2403. <a href='admin-bew-manager.php?action=3&uuid=".$disId."' class='btn btn-red'>Ablehnen</a>
  2404. </div>
  2405. </div>
  2406. </div>
  2407. ";
  2408. }
  2409. }else{
  2410. echo "<span style='color: #ff0000;'>ERROR: Dieses Diskussion existiert nicht!</span>";
  2411. }
  2412. }else{
  2413. ?><script>window.location.href="home.php";</script><?
  2414. }
  2415. }else{
  2416. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2417. }
  2418. }else{
  2419. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2420. }
  2421. }
  2422.  
  2423. function answerToBewDis($disID, $message){
  2424. $sql = mysqlData();
  2425. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2426. if($con){
  2427. if(mysqli_select_db($con, $sql['database'])){
  2428. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2429. $date = date("d").".".date("M").".".date("Y")." ".date("H").":".date("i");
  2430. $insert = mysqli_query($con, "insert into BewDis (UserDis,type,fromU,datum,sstats,topic)
  2431. values('".$disID."','answer','".$UID."','".$date."','work','".$message."')");
  2432. if($insert){
  2433. echo "User Diskussion gespeichert";
  2434. return;
  2435. }else{
  2436. echo "User Diskussion NICHT gespeichert";
  2437. return;
  2438. }
  2439. }else{
  2440. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2441. }
  2442. }else{
  2443. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2444. }
  2445. }
  2446.  
  2447. function IsInTeam(){
  2448. $UUID = $_COOKIE['DDSTUser'];
  2449. $sql = mysqlData();
  2450. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2451. if($con){
  2452. if(mysqli_select_db($con, $sql['database'])){
  2453. $check = mysqli_query($con, "select regUsers.ID,regUsers.UUID,Team.TEAMID,Team.U_ID from regUsers left join Team on regUsers.ID = Team.U_ID where regUsers.UUID = '".$UUID."' and TEAMID != ''");
  2454. if(mysqli_num_rows($check)){
  2455. return "YES";
  2456. }else{
  2457. return "NO";
  2458. }
  2459. }else{
  2460. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2461. }
  2462. }else{
  2463. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2464. }
  2465. }
  2466.  
  2467. function getOptionsGroups($now){
  2468. $sql = mysqlData();
  2469. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2470. if($con){
  2471. if(mysqli_select_db($con, $sql['database'])){
  2472. echo "<option value='2' selected>Default</option>";
  2473. $select = mysqli_query($con, "select * from Groups where Group_Name != 'User'");
  2474. while($fetch = mysqli_fetch_assoc($select)){
  2475. if($fetch['Group_Name'] == $now){
  2476. echo "<option value='".$fetch['G_ID']."' selected>".$fetch['Group_Name']."</option>";
  2477. }else{
  2478. echo "<option value='".$fetch['G_ID']."'>".$fetch['Group_Name']."</option>";
  2479. }
  2480.  
  2481. }
  2482. }else{
  2483. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2484. }
  2485. }else{
  2486. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2487. }
  2488. }
  2489.  
  2490. function getOptionsRanks($now){
  2491. $sql = mysqlData();
  2492. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2493. if($con){
  2494. if(mysqli_select_db($con, $sql['database'])){
  2495. $select = mysqli_query($con, "select * from Ranks");
  2496. while($fetch = mysqli_fetch_assoc($select)){
  2497. if($fetch['R_Name'] == $now){
  2498. echo "<option value='".$fetch['RK_ID']."' selected>".$fetch['R_Name']."</option>";
  2499. }else{
  2500. echo "<option value='".$fetch['RK_ID']."'>".$fetch['R_Name']."</option>";
  2501. }
  2502. }
  2503. }else{
  2504. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2505. }
  2506. }else{
  2507. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2508. }
  2509. }
  2510. function getTeamID($uuid){
  2511. $sql = mysqlData();
  2512. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2513. if($con){
  2514. if(mysqli_select_db($con, $sql['database'])){
  2515. $select = mysqli_query($con, "select regUsers.UUID,Team.TEAMID from regUsers left join Team on Team.U_ID = regUsers.ID where regUsers.UUID = '".$uuid."'");
  2516. $fetch = mysqli_fetch_assoc($select);
  2517. return $fetch['TEAMID'];
  2518. }else{
  2519. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2520. }
  2521. }else{
  2522. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2523. }
  2524. }
  2525.  
  2526. function addNewTeamer($uuid, $gid, $rid){
  2527. $sql = mysqlData();
  2528. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2529. if($con){
  2530. if(mysqli_select_db($con, $sql['database'])){
  2531. $folder = "bewerbungen/".$uuid."/";
  2532. $whyJoinUs = file_get_contents($folder."whyJoinUs.lexx");
  2533. $isInClan = config($folder."isInClan.lexx");
  2534. $TankInfo = config($folder."TankInfo.lexx");
  2535. $infoItems = config($folder."infoItems.lexx");
  2536. $privat = config($folder."perivat.lexx");
  2537. $UID = getAccountData($uuid, "ID");
  2538. $date = date("d").".".date("M").".".date("Y")." ".date("H").":".date("i");
  2539. $insert = mysqli_query($con, "insert into Team (U_ID,Rank_ID,RL_Name,RL_Vorname,RL_2Name,Strasse,HausNummer,PLZ,Stadt,Land,Geburts_Datum,telefon,tel_Vor,Activity,Nationalitat)
  2540. values('".$UID."','".$rid."','".$privat['name']."','".$privat['vorname']."','-','".$privat['strasse']."','".$privat['hausNr']."',
  2541. '".$privat['plz']."','".$privat['ort']."','".$privat['land']."','".$privat['birth']."','".$privat['telefon']."','".$privat['telvor']."','0','-')");
  2542. if($insert){
  2543. $upgradeGroup = mysqli_query($con, "update regUsers set G_ID='".$gid."' where UUID = '".$uuid."'");
  2544. if($upgradeGroup){
  2545. $TID = getTeamID($uuid);
  2546. $queryStr = "insert into wotInfo (T_ID,Tank_highst,Tank_Type,Eintritt_Datum) values('".$TID."','".$TankInfo['higstTank']."','".$TankInfo['likeTankType']."','".$date."')";
  2547. $addWotInfos = mysqli_query($con, $queryStr);
  2548. if($addWotInfos){
  2549. return "OK";
  2550. }else{
  2551. return "ERROR: Cant Add Data to WOT Info from UUID: ".$uuid. " SQL ERROR: ".$addWotInfos." Query: ".$queryStr;
  2552. }
  2553. }else{
  2554. return "ERROR: Cant Set Group from UUID: ".$uuid;
  2555. }
  2556. }else{
  2557. echo "ERROR: Cant insert New User in Team Table!";
  2558. }
  2559. }else{
  2560. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2561. }
  2562. }else{
  2563. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2564. }
  2565. }
  2566.  
  2567. function sendTeamChatMessage($message){
  2568. $UID = getAccountData($_COOKIE['DDSTUser'],"ID");
  2569. $UUID = getAccountData($_COOKIE['DDSTUser'],"UUID");
  2570. $time = date("G").":".date("i").":".date("s");
  2571. $sql = mysqlData();
  2572. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2573. if($con){
  2574. if(mysqli_select_db($con, $sql['database'])){
  2575. $query = mysqli_query($con, "insert into TeamChat (from_UI,Zeit,Message) values('".$UID."','".$time."','".$message."')");
  2576. if($query){
  2577. return "OK";
  2578. }else{
  2579. return "ERROR: cant send Message from ".$UUID;
  2580. }
  2581. }else{
  2582. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2583. }
  2584. }else{
  2585. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2586. }
  2587. }
  2588.  
  2589. function printTeamChat(){
  2590. $sql = mysqlData();
  2591. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2592. if($con){
  2593. if(mysqli_select_db($con, $sql['database'])){
  2594. $select = mysqli_query($con, "select TeamChat.from_UI,TeamChat.Zeit,TeamChat.Message,regUsers.R_User,Groups.Group_Prefix,Groups.color,Team.Rank_ID,Ranks.R_Prefix,Ranks.R_Color from
  2595. TeamChat left join regUsers on TeamChat.from_UI=regUsers.ID left join Groups on regUsers.G_ID=Groups.G_ID left join Team on Team.U_ID = regUsers.ID left join Ranks on
  2596. Team.Rank_ID = Ranks.RK_ID order by TeamChat.C_ID desc limit 5");
  2597. while($fetch = mysqli_fetch_assoc($select)){
  2598. $time = $fetch['Zeit'];
  2599. $GroupPrefix = $fetch['Group_Prefix'];
  2600. $GroupColor = $fetch['color'];
  2601. $RankPrefix = $fetch['R_Prefix'];
  2602. $RankColor = $fetch['R_Color'];
  2603. $UserName = $fetch['R_User'];
  2604. $message = $fetch['Message'];
  2605. echo "
  2606. <div class='col-md-12 padding-vert-10' style='border-bottom: 3px solid #dddddd;'>
  2607. <div class='col-md-1'>
  2608. ".$time."
  2609. </div>
  2610. <div class='col-md-3'>
  2611. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$GroupColor.";'>".$GroupPrefix."</span>
  2612. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$RankColor.";'>".$RankPrefix."</span>
  2613. <a href='#' style='color #ffaa00;'>".$UserName."</a>
  2614. </div>
  2615. <div class='col-md-7'>
  2616. ".$message."
  2617. </div>
  2618. </div>
  2619. ";
  2620. }
  2621. }else{
  2622. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2623. }
  2624. }else{
  2625. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2626. }
  2627. }
  2628.  
  2629. function getRank(){
  2630. $sql = mysqlData();
  2631. $uuid = $_COOKIE['DDSTUser'];
  2632. $rank = array();
  2633. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2634. if($con){
  2635. if(mysqli_select_db($con, $sql['database'])){
  2636. if(IsInTeam() == "YES"){
  2637. $query = mysqli_query($con, "select regUsers.R_User,Ranks.R_Name,Ranks.R_Prefix,Ranks.R_Color from regUsers left join Team on regUsers.ID=Team.U_ID left join Ranks on Team.Rank_ID=Ranks.RK_ID where regUsers.UUID = '".$uuid."'");
  2638. if(mysqli_num_rows($query)){
  2639. $fetch = mysqli_fetch_assoc($query);
  2640. $rank['R_User'] = $fetch['R_User'];
  2641. $rank['R_Name'] = $fetch['R_Name'];
  2642. $rank['R_Prefix'] = $fetch['R_Prefix'];
  2643. $rank['R_Color'] = $fetch['R_Color'];
  2644. return $rank;
  2645. }else{
  2646. return "ERROR";
  2647. }
  2648. }
  2649. return $rank;
  2650. }else{
  2651. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2652. }
  2653. }else{
  2654. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2655. }
  2656. }
  2657. function getRankFrom($UID){
  2658. $sql = mysqlData();
  2659. $uuid = $_COOKIE['DDSTUser'];
  2660. $rank = array();
  2661. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2662. if($con){
  2663. if(mysqli_select_db($con, $sql['database'])){
  2664. if(IsInTeam() == "YES"){
  2665. $query = mysqli_query($con, "select regUsers.R_User,Ranks.R_Name,Ranks.R_Prefix,Ranks.R_Color from regUsers left join Team on regUsers.ID=Team.U_ID left join Ranks on Team.Rank_ID=Ranks.RK_ID where regUsers.ID = '".$UID."'");
  2666. if(mysqli_num_rows($query)){
  2667. $fetch = mysqli_fetch_assoc($query);
  2668. $rank['R_User'] = $fetch['R_User'];
  2669. $rank['R_Name'] = $fetch['R_Name'];
  2670. $rank['R_Prefix'] = $fetch['R_Prefix'];
  2671. $rank['R_Color'] = $fetch['R_Color'];
  2672. return $rank;
  2673. }else{
  2674. return "ERROR";
  2675. }
  2676. }
  2677. return $rank;
  2678. }else{
  2679. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2680. }
  2681. }else{
  2682. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2683. }
  2684. }
  2685. function countOfUsers(){
  2686. $sql = mysqlData();
  2687. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2688. if($con){
  2689. if(mysqli_select_db($con, $sql['database'])){
  2690. $query = mysqli_query($con, "select count(ID) from regUsers");
  2691. $fetch = mysqli_fetch_assoc($query);
  2692. return $fetch['count(ID)'];
  2693. }else{
  2694. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2695. }
  2696. }else{
  2697. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2698. }
  2699. }
  2700. function showTeamList($number, $number2){
  2701. $sql = mysqlData();
  2702. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2703. if($con){
  2704. if(mysqli_select_db($con, $sql['database'])){
  2705. $select = mysqli_query($con, "select regUsers.ID,regUsers.UUID,regUsers.R_User,Groups.Group_Name,Groups.color,Team.Rank_ID,Ranks.R_Name,Ranks.R_Color from regUsers
  2706. left Join Groups on regUsers.G_ID=Groups.G_ID left join Team on regUsers.ID=Team.U_ID left join Ranks on Team.Rank_ID=Ranks.RK_ID where regUsers.ID != '1' or regUsers.R_User != 'SYSTEM'");
  2707. $count = 0;
  2708. while($fetch = mysqli_fetch_assoc($select)){
  2709. $count++;
  2710. if($count >= $number && $count <= $number2){
  2711. if($fetch['R_User'] == "SYSTEM" || $fetch['ID'] == "1"){
  2712. continue;
  2713. }
  2714. echo "
  2715. <div class='col-md-12 margin-vert-30'>
  2716. <div class='col-md-3'>
  2717. <a href='admin-team-manager.php?account=".$fetch['ID']."&action=showAccount'>".$fetch['R_User']."</a>
  2718. </div>
  2719. <div class='col-md-3'>
  2720. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$fetch['color'].";'>".$fetch['Group_Name']."</span>
  2721. ";
  2722. if($fetch['Rank_ID'] != NULL){
  2723. echo "
  2724.  
  2725. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: #00aaff;'>Rank</span>
  2726. ";
  2727. }
  2728. echo "
  2729. </div>
  2730. <div class='col-md-6' style='text-align: right;'>
  2731. <a href='#' class='btn btn-blue' title='Benutzer Settings'><i class='fa fa-gear'></i></a>
  2732. <a href='#' class='btn btn-info' title='Benutzer Details'><i class='fa fa-user'></i></a>
  2733. <a href='#' class='btn btn-warning' title='Zur Team Adden'><i class='fa fa-plus-square'></i></a>
  2734. <a href='#' class='btn btn-red' title='Benutzer aus dem Login kicken'><i class='fa fa-unlock-alt'></i></a>
  2735. <a href='#' class='btn btn-red' title='Benutzer Bannen'><i class='fa fa-ban'></i></a>
  2736. <a href='#' class='btn btn-danger' title='Benutzer Reseten'><i class='fa fa-refresh'></i></a>
  2737. <a href='#' class='btn btn-danger' title='Benutzer löschen'><i class='fa fa-times'></i></a>
  2738. </div>
  2739. </div>
  2740. ";
  2741. }
  2742. }
  2743. }else{
  2744. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2745. }
  2746. }else{
  2747. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2748. }
  2749. }
  2750. function UserIsInTeam($userId){
  2751. $sql = mysqlData();
  2752. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2753. if($con){
  2754. if(mysqli_select_db($con, $sql['database'])){
  2755. $query = mysqli_query($con, "select * from Team where U_ID = '".$userId."'");
  2756. if(mysqli_num_rows($query)){
  2757. return true;
  2758. }else{
  2759. return false;
  2760. }
  2761. }else{
  2762. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2763. }
  2764. }else{
  2765. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2766. }
  2767. }
  2768. function AdminShowAccountAsNoTeam($uid){
  2769. $sql = mysqlData();
  2770. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2771. if($con){
  2772. if(mysqli_select_db($con, $sql['database'])){
  2773. $query = mysqli_query($con, "select * from regUsers left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.ID = '".$uid."'");
  2774. if(mysqli_num_rows($query)){
  2775. $fetch = mysqli_fetch_assoc($query);
  2776. $email = $fetch['e_Mail'];
  2777. $UID = $fetch['ID'];
  2778. $User = $fetch['R_User'];
  2779. $groupName = $fetch['Group_Name'];
  2780. $groupPrefix = $fetch['Group_Prefix'];
  2781. $groupFarbe = $fetch['color'];
  2782. echo "
  2783. <h2 style='color: #ffaa00;'>".$User."</h2>
  2784. <div class='row'>
  2785. <h4>Account</h4>
  2786. <div class='col-md-12 login-page margin-horiz-10'>
  2787.  
  2788. <div class='col-md-1'>
  2789. <label>ID</label><br>
  2790. ".$uid."
  2791. </div>
  2792. <div class='col-md-5'>
  2793. <label>Username</label><br>
  2794. ".$User."
  2795. </div>
  2796. <div class='col-md-6'>
  2797. <label>E Mail</label><br>
  2798. ".$email."
  2799. </div>
  2800. </div>
  2801. </div>
  2802. <div class='row margin-vert-20'>
  2803. <div class='col-md-12'>
  2804. <div class='col-md-4 margin-horiz-10'>
  2805. <h4>Berechtingungen</h4>
  2806. </div>
  2807. </div>
  2808. <div class='row'><br><br></div>
  2809. <div class='col-md-12'>
  2810. <div class='col-md-4 login-page margin-horiz-10'>
  2811. <label>Gruppe</label>
  2812. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$groupFarbe.";'>".$groupName."</span>
  2813. </div>
  2814. </div>
  2815. <div class='col-md-12 margin-vert-20 login-page'>
  2816. <a href='admin-team-manager.php?action=editUser&account=".$uid."' class='btn btn-blue' title='Benutzer Settings'><i class='fa fa-gear'></i> Benutzer bearbeiten</a>
  2817. <a href='#' class='btn btn-warning' title='Zur Team Adden'><i class='fa fa-plus-square'></i> Benutzer Zur Team einladen</a>
  2818. <a href='#' class='btn btn-red' title='Benutzer aus dem Login kicken'><i class='fa fa-unlock-alt'></i> Benutzer Sofort aussloggen</a>
  2819. <a href='#' class='btn btn-red' title='Benutzer Bannen'><i class='fa fa-ban'></i> Benutzer Bannen</a>
  2820. <a href='#' class='btn btn-danger' title='Benutzer Reseten'><i class='fa fa-refresh'></i> Benutzer reseten</a>
  2821. <a href='#' class='btn btn-danger' title='Benutzer löschen'><i class='fa fa-times'></i> Benutzer Instant löschen!</a>
  2822. </div>
  2823. </div>
  2824. ";
  2825. }else{
  2826. return "ERROR: SQL: 05";
  2827. }
  2828. }else{
  2829. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2830. }
  2831. }else{
  2832. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2833. }
  2834. }
  2835. function AdminShowAccountAsTeam($uid){
  2836. $sql = mysqlData();
  2837. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2838. if($con){
  2839. if(mysqli_select_db($con, $sql['database'])){
  2840. $query = mysqli_query($con, "select * from regUsers left join Team on regUsers.ID = Team.U_ID left join Ranks on Team.Rank_ID = Ranks.RK_ID left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.ID = '".$uid."'");
  2841. if(mysqli_num_rows($query)){
  2842. $fetch = mysqli_fetch_assoc($query);
  2843. $email = $fetch['e_Mail'];
  2844. $User = $fetch['R_User'];
  2845. $nachname = $fetch['RL_Name'];
  2846. $vorname = $fetch['RL_Vorname'];
  2847. $SecNachname = $fetch['RL_2Name'];
  2848. $adrStrasse = $fetch['Strasse'];
  2849. $adrHausNr = $fetch['HausNummer'];
  2850. $adrPlz = $fetch['PLZ'];
  2851. $adrOrt = $fetch['Stadt'];
  2852. $country = $fetch['Land'];
  2853. $GBDatum = $fetch['Geburts_Datum'];
  2854. $telefon = $fetch['telefon'];
  2855. $telVor = $fetch['tel_Vor'];
  2856. $AccountActivation = $fetch['Activity'];
  2857. $nationalitat = $fetch['Nationalitat'];
  2858. $rankName = $fetch['R_Name'];
  2859. $rankPrefix = $fetch['R_Prefix'];
  2860. $rankFarbe = $fetch['R_Color'];
  2861. $groupName = $fetch['Group_Name'];
  2862. $groupPrefix = $fetch['Group_Prefix'];
  2863. $groupFarbe = $fetch['color'];
  2864. echo "
  2865. <h2 style='color: #ffaa00;'>".$User."</h2>
  2866. <div class='row'>
  2867. <h4>Account</h4>
  2868. <div class='col-md-12 login-page margin-horiz-10'>
  2869.  
  2870. <div class='col-md-1'>
  2871. <label>ID</label><br>
  2872. ".$uid."
  2873. </div>
  2874. <div class='col-md-5'>
  2875. <label>Username</label><br>
  2876. ".$User."
  2877. </div>
  2878. <div class='col-md-6'>
  2879. <label>E Mail</label><br>
  2880. ".$email."
  2881. </div>
  2882. </div>
  2883. </div>
  2884. <div class='row margin-vert-20'>
  2885. <div class='col-md-12'>
  2886. <div class='col-md-4 margin-horiz-10'>
  2887. <h4>Berechtingungen</h4>
  2888. </div>
  2889. <div class='col-md-7 margin-horiz-10'>
  2890. <h4>Personal Daten</h4>
  2891. </div>
  2892. </div>
  2893. <div class='row'><br><br></div>
  2894. <div class='col-md-12'>
  2895. <div class='col-md-4 login-page margin-horiz-10'>
  2896. <label>Gruppe</label>
  2897. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$groupFarbe.";'>".$groupName."</span><br>
  2898. <br>
  2899. <label>Rank</label>
  2900. <span class='btn btn-xs btn-default' style='color: #ffffff; background-color: ".$rankFarbe.";'>".$rankName."</span>
  2901. </div>
  2902. <div class='col-md-7 login-page margin-horiz-10'>
  2903. <div class='col-md-5'>
  2904. ".$nachname." ".$vorname."<br>
  2905. ".$adrStrasse." ".$adrHausNr."<br>
  2906. ".$adrPlz." ".$adrOrt."<br>
  2907. Land: ".$country."
  2908. </div>
  2909. <div class='col-md-7'>
  2910. <b>GeburtsDatum:</b> ".$GBDatum."<br>
  2911. <b>Telefon:</b> ".$telVor." ".$telefon."<br>
  2912. <b>Nationalität:</b> ".$nationalitat."
  2913. </div>
  2914. </div>
  2915. </div>
  2916. <div class='col-md-12 margin-vert-20 login-page'>
  2917. <a href='admin-team-manager.php?action=editUser&account=".$uid."' class='btn btn-blue' title='Benutzer Settings'><i class='fa fa-gear'></i> Benutzer bearbeiten</a>
  2918. <a href='admin-team-manager.php?action=teamKick&account=".$uid."' class='btn btn-warning' title='Zur Team Adden'><i class='fa fa-plus-square'></i> Aus der Team kicken</a>
  2919. <a href='admin-team-manager.php?action=logoutUser&account=".$uid."' class='btn btn-red' title='Benutzer aus dem Login kicken'><i class='fa fa-unlock-alt'></i> Benutzer Sofort aussloggen</a>
  2920. <a href='admin-team-manager.php?action=banUser&account=".$uid."' class='btn btn-red' title='Benutzer Bannen'><i class='fa fa-ban'></i> Benutzer Bannen</a>
  2921. <a href='admin-team-manager.php?action=resetUser&account=".$uid."' class='btn btn-danger' title='Benutzer Reseten'><i class='fa fa-refresh'></i> Benutzer reseten</a>
  2922. <a href='admin-team-manager.php?action=deleteUser&account=".$uid."' class='btn btn-danger' title='Benutzer löschen'><i class='fa fa-times'></i> Benutzer Instant löschen!</a>
  2923. </div>
  2924. </div>
  2925. ";
  2926. }else{
  2927. return "ERROR: SQL: 05";
  2928. }
  2929. }else{
  2930. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  2931. }
  2932. }else{
  2933. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  2934. }
  2935. }
  2936.  
  2937. function AdminEditNoTeamAccount($uid){
  2938. $sql = mysqlData();
  2939. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  2940. if($con){
  2941. if(mysqli_select_db($con, $sql['database'])){
  2942. $query = mysqli_query($con, "select * from regUsers left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.ID = '".$uid."'");
  2943. if(mysqli_num_rows($query)){
  2944. $fetch = mysqli_fetch_assoc($query);
  2945. $email = $fetch['e_Mail'];
  2946. $UID = $fetch['ID'];
  2947. $User = $fetch['R_User'];
  2948. $groupName = $fetch['Group_Name'];
  2949. echo "
  2950. <form action='admin-team-manager.php'>
  2951. <h2 style='color: #ffaa00;'>".$User."</h2>
  2952. <div class='row'>
  2953. <h4>Account</h4>
  2954. <div class='col-md-12 login-page margin-horiz-10'>
  2955.  
  2956. <div class='col-md-1'>
  2957. <label>ID</label><br>
  2958. ".$uid."
  2959. <input type='hidden' name='UID' value='".$uid."'>
  2960. </div>
  2961. <div class='col-md-5'>
  2962. <label>Username</label><br>
  2963. <input type='text' value='".$User."' class='form-control' name='UserName' placeholder='Benutzer Name'>
  2964. </div>
  2965. <div class='col-md-6'>
  2966. <label>E Mail</label><br>
  2967. <input type='text' value='".$email."' class='form-control' name='UserEmail' placeholder='Benutzer E-Mail Adresse'>
  2968. </div>
  2969. </div>
  2970. </div>
  2971. <div class='row margin-vert-20'>
  2972. <div class='col-md-12'>
  2973. <div class='col-md-4 margin-horiz-10'>
  2974. <h4>Berechtingungen</h4>
  2975. </div>
  2976. </div>
  2977. <div class='row'><br><br></div>
  2978. <div class='col-md-12'>
  2979. <div class='col-md-4 login-page margin-horiz-10'>
  2980. <label>Gruppe</label>
  2981. <select name='groups' class='form-control'>
  2982. ";
  2983. getOptionsGroups($groupName);
  2984. echo "
  2985. </select>
  2986. </div>
  2987. </div>
  2988. <div class='col-md-12 margin-vert-20 login-page'>
  2989. <button class='btn btn-aqua'><i class='fa fa-save'></i> Speichern</button>
  2990. <a href='admin-team-manager.php' class='btn btn-red'><i class='fa fa-times'> Abbrechen</i></a>
  2991. </div>
  2992. </div>
  2993. </form>
  2994. ";
  2995. }else{
  2996. return "ERROR: SQL: 05";
  2997. }
  2998. }else{
  2999. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  3000. }
  3001. }else{
  3002. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  3003. }
  3004. }
  3005. function AdminEditTeamAccount($uid){
  3006. $sql = mysqlData();
  3007. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  3008. if($con){
  3009. if(mysqli_select_db($con, $sql['database'])){
  3010. $query = mysqli_query($con, "select * from regUsers left join Team on regUsers.ID = Team.U_ID left join Ranks on Team.Rank_ID = Ranks.RK_ID left join Groups on regUsers.G_ID = Groups.G_ID where regUsers.ID = '".$uid."'");
  3011. if(mysqli_num_rows($query)){
  3012. $fetch = mysqli_fetch_assoc($query);
  3013. $email = $fetch['e_Mail'];
  3014. $User = $fetch['R_User'];
  3015. $nachname = $fetch['RL_Name'];
  3016. $vorname = $fetch['RL_Vorname'];
  3017. $SecNachname = $fetch['RL_2Name'];
  3018. $adrStrasse = $fetch['Strasse'];
  3019. $adrHausNr = $fetch['HausNummer'];
  3020. $adrPlz = $fetch['PLZ'];
  3021. $adrOrt = $fetch['Stadt'];
  3022. $country = $fetch['Land'];
  3023. $GBDatum = $fetch['Geburts_Datum'];
  3024. $telefon = $fetch['telefon'];
  3025. $telVor = $fetch['tel_Vor'];
  3026. $AccountActivation = $fetch['Activity'];
  3027. $nationalitat = $fetch['Nationalitat'];
  3028. $rankName = $fetch['R_Name'];
  3029. $rankPrefix = $fetch['R_Prefix'];
  3030. $rankFarbe = $fetch['R_Color'];
  3031. $groupName = $fetch['Group_Name'];
  3032. $groupPrefix = $fetch['Group_Prefix'];
  3033. $groupFarbe = $fetch['color'];
  3034. echo "
  3035. <form action='admin-team-manager.php'>
  3036. <h2 style='color: #ffaa00;'>".$User."</h2>
  3037. <div class='row'>
  3038. <h4>Account</h4>
  3039. <div class='col-md-12 login-page margin-horiz-10'>
  3040.  
  3041. <div class='col-md-1'>
  3042. <label>ID</label><br>
  3043. ".$uid."
  3044. <input type='hidden' name='UID' value='".$uid."'>
  3045. </div>
  3046. <div class='col-md-5'>
  3047. <label>Username</label><br>
  3048. <input type='text' value='".$User."' class='form-control' name='UserName' placeholder='Benutzer Name'>
  3049. </div>
  3050. <div class='col-md-6'>
  3051. <label>E Mail</label><br>
  3052. <input type='text' value='".$email."' class='form-control' name='UserEmail' placeholder='Benutzer E-Mail Adresse'>
  3053. </div>
  3054. </div>
  3055. </div>
  3056. <div class='row margin-vert-20'>
  3057. <div class='col-md-12'>
  3058. <div class='col-md-4 margin-horiz-10'>
  3059. <h4>Berechtingungen</h4>
  3060. </div>
  3061. <div class='col-md-7 margin-horiz-10'>
  3062. <h4>Personalien</h4>
  3063. </div>
  3064. </div>
  3065. <div class='row'><br><br></div>
  3066. <div class='col-md-12'>
  3067. <div class='col-md-4 login-page margin-horiz-10'>
  3068. <label>Gruppe</label>
  3069. <select name='groups' class='form-control'>
  3070. ";
  3071. getOptionsGroups($groupName);
  3072. echo "
  3073. </select>
  3074. <br>
  3075. <label>Rank</label>
  3076. <select name='groups' class='form-control'>
  3077. ";
  3078. getOptionsRanks($rankName);
  3079. echo "
  3080. </select>
  3081. </div>
  3082. <div class='col-md-7 login-page margin-horiz-10'>
  3083. <label>Name/Vorname</label>
  3084. <input type='text' name='nachname' class='form-control' value='".$nachname."'>
  3085. <input type='text' name='vorname' class='form-control' value='".$vorname."'><br><br>
  3086. <label>Addresse</label>
  3087. <input type='text' name='adrstrasse' class='form-control' value='".$adrStrasse."'>
  3088. <input type='text' name='adrHausNr' class='form-control' value='".$adrHausNr."'><br><br>
  3089. <label>PLZ/Ort</label>
  3090. <input type='text' name='PLZ' class='form-control' value='".$adrPlz."'>
  3091. <input type='text' name='Ort' class='form-control' value='".$adrOrt."'><br><br>
  3092. <input type='text' name='country' class='form-control' value='".$country."'><br><br>
  3093. <input type='date' name='geburtsdatum' class='form-control' value='".$GBDatum."'>
  3094. <input type='text' name='telefon' class='form-control' value='".$telefon."'>
  3095. <input type='text' name='telvor' class='form-control' value='".$telVor."'>
  3096. <input type='text' name='Nation' class='form-control' value='".$nationalitat."'>
  3097. </div>
  3098. </div>
  3099. <div class='col-md-12 margin-vert-20 login-page'>
  3100. <button class='btn btn-aqua'><i class='fa fa-save'></i> Speichern</button>
  3101. <a href='admin-team-manager.php' class='btn btn-red'><i class='fa fa-times'> Abbrechen</i></a>
  3102. </div>
  3103. </div>
  3104. </form>
  3105. ";
  3106. }else{
  3107. return "ERROR: SQL: 05";
  3108. }
  3109. }else{
  3110. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  3111. }
  3112. }else{
  3113. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  3114. }
  3115. }
  3116. /*
  3117. $sql = mysqlData();
  3118. $con = mysqli_connect($sql['host'],$sql['user'],$sql['password'],$sql['database']);
  3119. if($con){
  3120. if(mysqli_select_db($con, $sql['database'])){
  3121.  
  3122. }else{
  3123. errorlog("[SQL] Cant Cant Select Database", __FUNCTION__);
  3124. }
  3125. }else{
  3126. errorlog("[SQL] Cant Connect to MySQL Server", __FUNCTION__);
  3127. }
  3128.  
  3129. */
  3130.  
  3131.  
  3132.  
  3133.  
  3134.  
  3135.  
  3136.  
  3137.  
  3138.  
  3139.  
  3140.  
  3141.  
  3142.  
  3143. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!