Ban Manager (V.1.0.3.1)[rework of CRemoteBanlist V 1.0.0.11]

[ImportBot]

Originally Posted by p19blo*:

 

i get this

 

Internal Server Error

 

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

when trying to install.php

 

this is when ive granted the chmod 777 to the files im told to.

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

webpage_banmanager_v2.1a_beta

 

Add Ban Manuel don't work properly

i Ban 1 player 6 times Manuel now he is at the top10 list (.)) but not visible at the ban list.

As i understood there is no corresponding entry in bm_banlist but you can see the player in bm_soldiers?

[ImportBot]

Originally Posted by DaMagicSW*:

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

when trying to install.php

 

this is when ive granted the chmod 777 to the files im told to.

ok you have no right to give the rights you need to write your data manual in config and then try install.php

[ImportBot]

Originally Posted by DaMagicSW*:

 

@berndel the top 10 list count how many a soldier were banned on server not the current

[ImportBot]

Originally Posted by Berndel*:

 

@berndel the top 10 list count how many a soldier were banned on server not the current

if we ban an gamer thats mean he is baned forever ! not how many time ? you joking or _

[ImportBot]

Originally Posted by p19blo*:

 

ok you have no right to give the rights you need to write your data manual in config and then try install.php

did this before and i get the error

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

did this before and i get the error

Are you sure config.php and install.php have 777 rights? What DamagicSW means is, if you have no rights to change the rights for this files you need to manuell enter the data in the config.php

[ImportBot]

Originally Posted by p19blo*:

 

Are you sure config.php and install.php have 777 rights? What DamagicSW means is, if you have no rights to change the rights for this files you need to manuell enter the data in the config.php

yeah, both have 777 rights. if i only do config with 777 rights the page shows config.php as green and install.php red, i change install.php to 777 and thats when i get this error. ive also manually put the information into the config

[ImportBot]

Originally Posted by DaMagicSW*:

 

yeah, both have 777 rights. if i only do config with 777 rights the page shows config.php as green and install.php red, i change install.php to 777 and thats when i get this error. ive also manually put the information into the config

the install.php check 777 rights of both phps

if you can grant rights to config also can grant to install may you need to delete install and upload it again

[ImportBot]

Originally Posted by p19blo*:

 

the install.php check 777 rights of both phps

if you can grant rights to config also can grant to install may you need to delete install and upload it again

 

done the re upload, same issue. if anyone cares to teamview me im ok with it

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

More information about this error may be available in the server error log.

Maybe you can have a look in you error log's cause so we cant tell whats going wrong there. Also DaMagicSW may assists you via Teamviewer but i think he can only do this @ weekend.

[ImportBot]

Originally Posted by p19blo*:

 

Code:

[09-Apr-2013 14:52:35] PHP Warning:  file_get_contents(html/page_en.html) [<a href='function.file-get-contents'>function.file-get-contents</a>]: failed to open stream: No such file or directory in /home/p19blo/public_html/stats1/manager.php on line 117
[09-Apr-2013 14:54:32] PHP Warning:  Manager::__destruct() [<a href='manager.--destruct'>manager.--destruct</a>]: Couldn't fetch mysqli in /home/p19blo/public_html/stats1/manager.php on line 68
[09-Apr-2013 14:57:09] PHP Warning:  Manager::__destruct() [<a href='manager.--destruct'>manager.--destruct</a>]: Couldn't fetch mysqli in /home/p19blo/public_html/stats1/manager.php on line 68
[09-Apr-2013 14:57:46] PHP Warning:  Manager::__destruct() [<a href='manager.--destruct'>manager.--destruct</a>]: Couldn't fetch mysqli in /home/p19blo/public_html/stats1/manager.php on line 68

[ImportBot]

Originally Posted by DaMagicSW*:

 

I give you an manual you can install webpage without install.php

 

first:

edit config and insert your data

second:

open your phpmyadmin in your database an execute the following sql

 

CREATE TABLE IF NOT EXISTS `bm_userlist` (

`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,

`username` varchar(100) NOT NULL,

`password` varchar(100) NOT NULL,

`banadd` tinyint(1) NOT NULL,

`banedit` tinyint(1) NOT NULL,

`bandel` tinyint(1) NOT NULL,

`enabled` tinyint(1) NOT NULL,

`editconfig` tinyint(1) NOT NULL,

`oldbanlist` tinyint(1) NOT NULL,

`cleanup` tinyint(1) NOT NULL,

`edituser` tinyint(1) NOT NULL,

`sid` varchar(50) NOT NULL,

PRIMARY KEY (`userid`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8

third create a user with following sql (can be edited for an other name or password)

INSERT INTO bm_userlist (userid,username,password,banadd,banedit,bandel,en abled,editconfig,edituser,oldbanlist,cleanup)

VALUES (NULL, 'Superadmin', MD5('123456'), 1,1,1,1,1,1,1,1)

now you can login with Superadmin and 123456

[ImportBot]

Originally Posted by DaMagicSW*:

 

if you can wait i can do that at weekand via teamviewer

[ImportBot]

Originally Posted by p19blo*:

 

if you can wait i can do that at weekand via teamviewer

luckily im not too bad when it comes to doing the above, i'll post back the results. thank you

[ImportBot]

Originally Posted by p19blo*:

 

first bit went without a hitch

 

second though creating the user gave me this error

 

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abled,editconfig,edituser,oldbanlist,cleanup) VALUES (NULL, 'Superadmin', MD5('' at line 1

[ImportBot]

Originally Posted by ty_ger07*:

 

first bit went without a hitch

 

second though creating the user gave me this error

 

Code:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'abled,editconfig,edituser,oldbanlist,cleanup) VALUES (NULL, 'Superadmin', MD5('' at line 1

Seems the forum put a space between 'en' and 'abled' in the word 'enabled' because it wordwrapped the code into a new line. Just make sure there is no space in 'enabled'.

 

Perhaps this is a different way to visual it:

Code:

INSERT INTO bm_userlist
(
userid,
username,
password,
banadd,
banedit,
bandel,
enabled,
editconfig,
edituser,
oldbanlist,
cleanup
)
VALUES
(
NULL,
'Superadmin',
MD5('123456'),
1,
1,
1,
1,
1,
1,
1,
1
)

That should work. But you probably want to user a name other than Superadmin and a password other than 123456 since the whole internet now knows your username and password.

 

I wonder why SID does not have a default value though and is not dealt with in that query.

[ImportBot]

Originally Posted by p19blo*:

 

that worked thanks.

 

now when I login I get

 

Fatal error: Call to a member function fetch_object() on a non-object in /home/p19blo/public_html/stats1/login.php on line 33

 

heres my login.php

 

Code:

<_php

/*
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                       +
+         COPYRIGHT BY =NRG= CLAN [url=http://www.nrg-esports.de]www.nrg-esports.de[/url]    +
+                                                       +
+                                                       +
+              Website created by DaMagicSW             +
+                           and                         +
+                 Plugin by DaMagicWobber               +
+                                                       +
+                                                       +
+  edit of website and remove of copyright not allowed  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/

include "manager.php";

$manager = new Manager("login");

if(isset($_SESSION["adminlogin"]) && $_SESSION["adminlogin"] != "")
{
  header("Location: index.php");
}
elseif(!isset($_POST["submit"]))
  $manager->insert_content(file_get_contents("modules/login/index_".$manager->language.".html"));
else
{
  if(isset($_POST["name"]) && $_POST["name"] != "" && isset($_POST["pass"]) && $_POST["pass"] != "")
  {
    $query = $manager->db->query("SELECT COUNT(*) as cnt FROM bm_userlist WHERE username = '".mysqli_real_escape_string($manager->db,$_POST["name"])."' AND `userpassword` = MD5('".mysqli_real_escape_string($manager->db,$_POST["pass"])."') AND enabled=1");
    $result = $query->fetch_object();
    if($result->cnt == 0)
    {
      $manager->insert_content(file_get_contents("modules/login/failed_".$manager->language.".html"));
    }
    else
    {
      $secure = $manager->get_secureCode(50);
      $_SESSION["adminlogin"] = $secure;
      $manager->db->query("UPDATE bm_userlist SET sid='".$secure."' WHERE username = '".mysqli_real_escape_string($manager->db,$_POST["name"])."'");
      header("Location: index.php");
    }
  }
  else
    $manager->insert_content(file_get_contents("modules/login/failed_".$manager->language.".html"));
}


_>

[ImportBot]

Originally Posted by dyn*:

 

I had similar issues but am working without a hitch now. Have you run the procon plugin yet?

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

that worked thanks.

 

now when I login I get

 

Fatal error: Call to a member function fetch_object() on a non-object in /home/p19blo/public_html/stats1/login.php on line 33

 

heres my login.php

 

Code:

<_php

/*
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                       +
+         COPYRIGHT BY =NRG= CLAN [url=http://www.nrg-esports.de]www.nrg-esports.de[/url]    +
+                                                       +
+                                                       +
+              Website created by DaMagicSW             +
+                           and                         +
+                 Plugin by DaMagicWobber               +
+                                                       +
+                                                       +
+  edit of website and remove of copyright not allowed  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/

include "manager.php";

$manager = new Manager("login");

if(isset($_SESSION["adminlogin"]) && $_SESSION["adminlogin"] != "")
{
  header("Location: index.php");
}
elseif(!isset($_POST["submit"]))
  $manager->insert_content(file_get_contents("modules/login/index_".$manager->language.".html"));
else
{
  if(isset($_POST["name"]) && $_POST["name"] != "" && isset($_POST["pass"]) && $_POST["pass"] != "")
  {
    $query = $manager->db->query("SELECT COUNT(*) as cnt FROM bm_userlist WHERE username = '".mysqli_real_escape_string($manager->db,$_POST["name"])."' AND `userpassword` = MD5('".mysqli_real_escape_string($manager->db,$_POST["pass"])."') AND enabled=1");
    $result = $query->fetch_object();
    if($result->cnt == 0)
    {
      $manager->insert_content(file_get_contents("modules/login/failed_".$manager->language.".html"));
    }
    else
    {
      $secure = $manager->get_secureCode(50);
      $_SESSION["adminlogin"] = $secure;
      $manager->db->query("UPDATE bm_userlist SET sid='".$secure."' WHERE username = '".mysqli_real_escape_string($manager->db,$_POST["name"])."'");
      header("Location: index.php");
    }
  }
  else
    $manager->insert_content(file_get_contents("modules/login/failed_".$manager->language.".html"));
}


_>

We tried the webpage now x times without any error. So for the moment we have no idea whats going wrong there. Only way for the moment is to assist you via teamviewer and may find out whats going wrong there

[ImportBot]

Originally Posted by p19blo*:

 

I had similar issues but am working without a hitch now. Have you run the procon plugin yet?

yeah, no errors showing up

 

We tried the webpage now x times without any error. So for the moment we have no idea whats going wrong there. Only way for the moment is to assist you via teamviewer and may find out whats going wrong there

ok bud I shall be at home later and we can try figure this out

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

i get this

 

Internal Server Error

 

The server encountered an internal error or misconfiguration and was unable to complete your request.

 

Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

 

More information about this error may be available in the server error log.

 

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

 

when trying to install.php

 

this is when ive granted the chmod 777 to the files im told to.

For everybody getting the same error. You get this error because your server hoster block php with 777 rights. We will change the needed rights to 755 in the next version of the webpage so this problem should be solved then.

[ImportBot]

Originally Posted by kunoichia*:

 

For everybody getting the same error. You get this error because your server hoster block php with 777 rights. We will change the needed rights to 755 in the next version of the webpage so this problem should be solved then.

Any ETA for this new version as we also have this issue and cant get it to work atm because of this.

[ImportBot]

Originally Posted by p19blo*:

 

Any ETA for this new version as we also have this issue and cant get it to work atm because of this.

overwrite your current install.php with this code

 

Code:

<_php

/*
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                       +
+         COPYRIGHT BY =NRG= CLAN www.nrg-esports.de    +
+                                                       +
+                                                       +
+              Website created by DaMagicSW             +
+                           and                         +
+                 Plugin by DaMagicWobber               +
+                                                       +
+                                                       +
+  edit of website and remove of copyright not allowed  +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*/

include "manager.php";

$manager = new Manager("install");

if(!isset($_POST["submitfirst"]) && !isset($_POST["submitsecond"]) && !isset($_POST["submitthird"]) && !isset($_POST["submitfourth"]) && !isset($_POST["submitfive"]))
{
  $content = file_get_contents("modules/install/first.html");
  
  if(DIRECTORY_SEPARATOR == "\\")
  {
    $content = str_replace("[OS]","Windows.",$content);
    $content = str_replace("[action]","<p>All rights granted. You can continue with installation.",$content);
    $content = str_replace("[button]",'<p><input type="submit" name="submitfirst" value="Continue">',$content);
  }
  else if(DIRECTORY_SEPARATOR == "/")
  {
    $content = str_replace("[OS]","Linux.",$content);
    $phps = "";
    $i = 0;
    $content = str_replace("[action]","<p><b>Please grant 777 rights to: <p> [phps]</b>",$content);
    if(100755 != decoct ( fileperms ( "install.php" ) ))
    {
      $phps .= ' <font color="#F00"> install.php </font> ';
      $i++;
    }
    else
      $phps .= ' <font color="#067a00"> install.php </font> ';
    
    if(100755 != decoct ( fileperms ( "config.php" ) ))
    {
      $phps .= ' <font color="#F00"> config.php </font> ';
      $i++;
    }
    else
      $phps .= ' <font color="#067a00"> config.php </font> ';
  
    
    $content = str_replace("[phps]",$phps,$content);
    if($i > 0)
      $content = str_replace("[button]",'<p>To continue with installion reload the website.',$content);
    else
      $content = str_replace("[button]",'<p><input type="submit" name="submitfirst" value="Continue">',$content);
  }
}
elseif(isset($_POST["submitfirst"]))
{
  $content = file_get_contents("modules/install/second.html");
  $content = str_replace("[button]",'<p><input type="submit" name="submitsecond" value="Continue">',$content);
}
elseif(isset($_POST["submitsecond"]))
{
  $content = file_get_contents("modules/install/third.html");
  if($_POST["host"] == "" || $_POST["name"] == "" || $_POST["pass"] == "" || $_POST["dbname"] == "")
  {
    $content = str_replace("[action]","Please fill in all fields.",$content);
    $content = str_replace("[button]",'<p><input type="submit" name="submitfirst" value="Back">',$content);
  }
  else
  {
    $db = new mysqli($_POST["host"],$_POST["name"],$_POST["pass"],$_POST["dbname"],($_POST["dbport"] == "" _ 3306 : $_POST["dbport"]));
    $action = "";
    $i = 0;
    if($db->connect_errno)
    {
      $i++;
      $action = '<font color="#F00"> Database connection error. ("'.$db->connect_error.'")</font>';
    }
    else
      $action = '<font color="#067a00"> Database connection OK.</font>';
    
    if($db->query("CREATE TABLE `test` (`test` INT NOT NULL)"))
    {
      $action .= '<p><font color="#067a00"> Rights OK.</font>';
    }
    else
    {
      $action .= '<p><font color="#F00"> Rights failed. Please grant '.$_POST['name'].' all Rights for the database '.$_POST["dbname"].'</font>';
    }
    $db->query("DROP TABLE `test`");
    
    $content = str_replace("[action]",$action,$content);
    $db->close();
    
    if($i == 0)
    {
      $f = fopen("config.php","w");
      $fp = fopen("config.php","w");
	  fwrite($fp,'<_php 
');
	  fwrite($fp,'
$hostname = "'.$_POST["host"].'"; //  Host of Datenbank
');
	  fwrite($fp,'
$username = "'.$_POST["name"].'"; //  Loginname of Datenbank
');
	  fwrite($fp,'
$password = "'.$_POST["pass"].'"; //  Passwort for Login
');
	  fwrite($fp,'
$dbname = "'.$_POST["dbname"].'"; //  Databasename
');
	  fwrite($fp,'
$port = "'.$_POST["dbport"].'"; //  Databaseport (if empty the defaultport will be set)
');
	  fwrite($fp,'
$folder = "'.$_POST["folder"].'"; //  Subfolder of an other website for example "nrg-esports.de/admintool/" --> $folder = "admintool" 
');
	  fwrite($fp,'
_>');
	  fclose($fp);
      fclose($f);
      $content = str_replace("[button]",'<p><input type="submit" name="submitthird" value="Continue">',$content);
    }
    else
      $content = str_replace("[button]",'<p><input type="submit" name="submitfirst" value="Back">',$content);
  }
}
elseif(isset($_POST["submitthird"]))
{
  $content = file_get_contents("modules/install/fourth.html");
  include "config.php";
  
  $db = new mysqli($hostname,$username,$password,$dbname,($port == "" _ 3306 : $port));
  
  $db->query("CREATE TABLE IF NOT EXISTS `bm_userlist` (
		`userid` int(10) unsigned NOT NULL AUTO_INCREMENT,
		`username` varchar(100) NOT NULL,
		`userpassword` varchar(100) NOT NULL,
		`banadd` tinyint(1) NOT NULL,
		`banedit` tinyint(1) NOT NULL,
		`bandel` tinyint(1) NOT NULL,
		`enabled` tinyint(1) NOT NULL,
		`editconfig` tinyint(1) NOT NULL,
		`oldbanlist` tinyint(1) NOT NULL,
		`cleanup` tinyint(1) NOT NULL,
		`edituser` tinyint(1) NOT NULL,
		`sid` varchar(50) NOT NULL,
		PRIMARY KEY (`userid`)
	  ) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;");
  
  $db->close();
  
  $content = str_replace("[action]","<p> All tables for the website have been created.",$content);
  
  $content = str_replace("[button]",'<p><input type="submit" name="submitfourth" value="Continue">',$content);
}
elseif(isset($_POST["submitfourth"]))
{
  $content = file_get_contents("modules/install/five.html");
  $content = str_replace("[button]",'<p><input type="submit" name="submitfive" value="Continue">',$content);
}
elseif(isset($_POST["submitfive"]))
{
  $content = file_get_contents("modules/install/last.html");
  if(isset($_POST["name"]) && isset($_POST["pass"]) && isset($_POST["pass2"]) && $_POST["name"] != "" && $_POST["pass"] != "" && $_POST["pass"] == $_POST["pass2"])
  {
    include "config.php";
    $db = new mysqli($hostname,$username,$password,$dbname,($port == "" _ 3306 : $port));
    $db->query("INSERT INTO bm_userlist (`userid`,`username`,`userpassword`,`banadd`,`banedit`,`bandel`,`enabled`,`editconfig`,`edituser`,`oldbanlist`,`cleanup`,`sid`)
               VALUES (
               NULL,
               '".mysqli_real_escape_string($db,$_POST["name"])."',
               MD5('".mysqli_real_escape_string($db,$_POST["pass"])."'),
               1,1,1,1,1,1,1,1,''
               )
               ");
    $db->close();
    $content = str_replace("[action]","<p>User created. Installation finished. Please remove install.php from mainfolder.",$content);
    $content = str_replace("[button]",'<p><a href="[dir]index.php"><input type="button" name="submit" value="Continue"></a>',$content);
  }
  else
  {
    $content = str_replace("[action]","<p>User can't be created. Please try again.",$content);
    $content = str_replace("[button]",'<p><input type="submit" name="submitfourth" value="Back">',$content);
  }
}

$manager->insert_content($content);

_>

CHMOD install.php and config.php to 755

 

when on www.yoursite.com/folder/install.php

 

it will still say make the files 777 ignore it and continue.

[ImportBot]

Originally Posted by kunoichia*:

 

cheers will give it a go

[ImportBot]

Originally Posted by BTFU_Maverick*:

 

Wobber, while I must applaud your work on the new beta version of the plugin and the webpage, I have a request. I understand that the coding that goes into these PHP pages is a pain in the ass, especially when dealing with databases. However, Liebhold's prior page was more indepth than the page you have created. Again, not trying to put down your work because I do applaud you for it. My request is this: is there any way you could reconsider recoding Liebholds page to work with your database? My reasoning behind this request is that his page offered a lot more information on player statistics as it was linked with the BF3 Stat/Chat Logger plugin, it allowed us to search for users chat history which is very useful in our ban appeal process, and it was overall very function and easy to utilize. He has all the existing framework and functions there and I think that converting it for someone with your PHP skills would not be a daunting task. Its very useful for us to be able to use all this information in one place and Im sure many others out there would appreciate your efforts as well.

[ImportBot]

Originally Posted by DaMagicWoBBeR*:

 

No fear, we add more features soon for the webpage. But for now we only want to test basic features and if they working correct we will add your wishes.

 

We fixed the "bug" with 777 rights for the beta in Version 2.1b_beta.

[ImportBot]

Originally Posted by p19blo*:

 

No fear, we add more features soon for the webpage. But for now we only want to test basic features and if they working correct we will add your wishes.

 

We fixed the "bug" with 777 rights for the beta in Version 2.1b_beta.

how can i become a tester or is it just when you upload ?

[ImportBot]

Originally Posted by kunoichia*:

 

Got it to work today (WOOHOOOO highfive me).

 

Noticed the chatlog was stripped out of the webpanel_? Any change this can be implemented again as this comes in real handy sorting problems that occured on the server and can just filter a persons name and see both sides of a story. As most banappeals usually only tell one side of a story and not in context.

 

Would be much apreciated and thanks for all the efforts with this plugin/webpanel. Once this chatlog can be implemented expect a donation from our side (cq247.co.uk) to say thanks.

[ImportBot]

Originally Posted by Berndel*:

 

any updates for the Ban Manager ?