PHP -> SQL -> server

To175 · Feb 16, 2014

Hi,
Can you make this please ?
A system to do a command on webpage with php and it is communicated to the server. This can be quite easy : With php we write the command in the MySQL database and the server scan every x second the datas (like for other datas) so that when there is a command, the server can run the command then delete the row !
And we don't need any weird configuration with ports etc...
Do you understand what I meen ?
Thanks !

timtower · Feb 16, 2014

To175 So input commands in the php page and run them on the server? You can also do that with JSONAPI

To175 · Feb 16, 2014

Thanks ,

timtower said: ↑

do that with JSONAPI
Click to expand...

To175 said: ↑

don't need any weird configuration with ports etc...
Click to expand...

I can't open ports, that's why I am asking for an easy plugin which can be fast to use and efficient

timtower · Feb 16, 2014

To175 said: ↑

I can't open ports, that's why I am asking for an easy plugin which can be fast to use and efficient
Click to expand...

JSONAPI can use the minecraft port these days, other ports aren't really needed

To175 · Feb 16, 2014

Thanks,
I don't understand...
I have configured JSONAPI but it didn't work at all with a simple call. My server host said that my server host had to open the ports and they don't want ! So I can't have the same ports open on server and website...
JSONAPI need ports, I don't understand your msg sorry.

timtower · Feb 16, 2014

To175 From experience: put the port on 25565 ( or your other minecraft port ) last time I used it it worked fine

To175 · Feb 16, 2014

Thanks for your help, I will be more clear
I CAN'T OPEN ANY PORTS THAT IS WHY I ASK FOR THIS PLUGIN
So, a such plugin does not existe but it could be verry usefull for webmaster like me...
And I think this is not soo hard to develop that's why I asked for.

So I am waiting for a nice developper to do it

timtower · Feb 16, 2014

To175 Let's make myself clear: you don't need to open new ports!

To175 · Feb 16, 2014

whyyyyyy so you say that and preconize the 25565 ??
And why my jsonapi doesn't work ?

timtower · Feb 16, 2014

To175 said: ↑

whyyyyyy so you say that and preconize the 25565 ??
And why my jsonapi doesn't work ?
Click to expand...

1. Yes, used it myself that way.
2. Don't know, error log?
3. If this all is not working then I can make this

To175 · Feb 16, 2014

Thanks,
There is only this on my page :

<?php

require 'JSONAPI.php';

$api = new JSONAPI("88.xx.xx.xx", 10252, "to175", "PASSWORD", "salt");

var_dump($api->call("getPlayerLimit"));
?>
Click to expand...

"salt" there is nothing because it has been removed by the autors.
10252 is the port to connect my server 88.xx.xx.xx:10252
BUT I have also used 40088 which is the only other port open in my server.
Var_dump returns NULL !

LOGs :

[16:17:25] [Thread-12/INFO]: [JSONAPI] Remote Toolkit cannot be loaded because it depends on a plugin that is not installed: 'RemoteToolkitPlugin'
[16:17:25] [Thread-12/INFO]: [JSONAPI] Dynmap cannot be loaded because it depends on a plugin that is not installed: 'dynmap'
[16:17:25] [Thread-12/INFO]: [JSONAPI] Dynmap cannot be loaded because it depends on a plugin that is not installed: 'dynmap'
[16:17:25] [Thread-12/INFO]: [JSONAPI] Remote Toolkit methods cannot be loaded because it depends on a plugin that is not installed: 'RemoteToolkitPlugin'
[16:17:25] [Thread-12/INFO]: [JSONAPI] 378 methods loaded in 7 namespaces.
[16:17:25] [Thread-12/INFO]: [JSONAPI] ------[Connection information]-------
[16:17:25] [Thread-12/INFO]: [JSONAPI] JSON Server listening on 40088
[16:17:25] [Thread-12/INFO]: [JSONAPI] JSON Stream Server listening on 40089
[16:17:25] [Thread-12/INFO]: [JSONAPI] JSON WebSocket Stream Server listening on 40090
[16:17:25] [Thread-12/INFO]: [JSONAPI] Active and listening for requests.
[16:17:25] [Thread-12/INFO]: [JSONAPI] External IP: 62.xx.xx.xx
[16:17:25] [Thread-12/INFO]: [JSONAPI] Port 40088 is properly forwarded and is externally accessible.
[16:17:25] [Thread-12/INFO]: [JSONAPI] Port 40089 is properly forwarded and is externally accessible.
[16:17:26] [Thread-12/INFO]: [JSONAPI] Port 40090 is properly forwarded and is externally accessible.
[16:17:26] [Thread-12/INFO]: [JSONAPI] -------------------------------------
Click to expand...

I see an other IP here... what it is ?

Finally, I used the standart php file :

<?php
/**
* A PHP class for access Minecraft servers that have Bukkit with the {@link http://github.com/alecgorge/JSONAPI JSONAPI} plugin installed.
*
* This class handles everything from key creation to URL creation to actually returning the decoded JSON as an associative array.
*
* @author Alec Gorge <[email protected]>
* @version Alpha 5
* Link http://github.com/alecgorge/JSONAPI
* @package JSONAPI
* @since Alpha 5
*/
class JSONAPI {
private $host;
private $port;
private $username;
private $password;
const URL_FORMAT = 'http://%s:%d/api/2/call?json=%s';
private $timeout;

/**
* Creates a new JSONAPI instance.
*/
public function __construct ($host, $port, $uname, $pword, $salt = '', $timeout = 10) {
$this->host = $host;
$this->port = $port;
$this->username = $uname;
$this->password = $pword;
$this->salt = $salt;
$this->timeout = $timeout;
}

/**
* Generates the proper SHA256 based key from the given method suitable for use as the key GET parameter in a JSONAPI API call.
*
* @param string $method The name of the JSONAPI API method to generate the key for.
* @return string The SHA256 key suitable for use as the key GET parameter in a JSONAPI API call.
*/
public function createKey($method) {
if(is_array($method)) {
$method = json_encode($method);
}
return hash('sha256', $this->username . $method . $this->password);
}

/**
* Generates the proper URL for a standard API call the given method and arguments.
*
* @param string $method The name of the JSONAPI API method to generate the URL for.
* @param array $args An array of arguments that are to be passed in the URL.
* @return string A proper standard JSONAPI API call URL. Example: "http://localhost:20059/api/call?method=methodName&args=jsonEncodedArgsArray&key=validKey".
*/
public function makeURL($method, array $args) {
return sprintf(self::URL_FORMAT, $this->host, $this->port, rawurlencode(json_encode($this->constructCall($method, $args))));
}

/**
* Generates the proper URL for a multiple API call the given method and arguments.
*
* @param array $methods An array of strings, where each string is the name of the JSONAPI API method to generate the URL for.
* @param array $args An array of arrays, where each array contains the arguments that are to be passed in the URL.
* @return string A proper multiple JSONAPI API call URL. Example: "http://localhost:20059/api/call-mul...rgs=jsonEncodedArrayOfArgsArrays&key=validKey".
*/
public function makeURLMultiple(array $methods, array $args) {
return sprintf(self::URL_FORMAT, $this->host, $this->port, rawurlencode(json_encode($this->constructCalls($methods, $args))));
}

/**
* Calls the single given JSONAPI API method with the given args.
*
* @param string $method The name of the JSONAPI API method to call.
* @param array $args An array of arguments that are to be passed.
* @return array An associative array representing the JSON that was returned.
*/
public function call($method, array $args = array()) {
if(is_array($method)) {
return $this->callMultiple($method, $args);
}

$url = $this->makeURL($method, $args);

return json_decode($this->curl($url), true);
}

private function curl($url) {
if(extension_loaded('cURL')) {
$c = curl_init($url);
curl_setopt($c, CURLOPT_PORT, $this->port);
curl_setopt($c, CURLOPT_HEADER, false);
curl_setopt($c, CURLOPT_RETURNTRANSFER, true);
curl_setopt($c, CURLOPT_TIMEOUT, $this->timeout);
$result = curl_exec($c);
curl_close($c);
return $result;
}else{
$opts = array('http' =>
array(
'timeout' => $this->timeout
)
);
return file_get_contents($url, false, stream_context_create($opts));
}
}

private function constructCall($method, array $args) {
$json = array();
$json['name'] = $method;
$json['arguments'] = $args;
$json['key'] = $this->createKey($method);
$json['username'] = $this->username;
return $json;
}

private function constructCalls(array $methods, array $args) {
$calls = array();
foreach ($methods as $key => $method) {
$calls[] = $this->constructCall($method, $args[$key]);
}
return $calls;
}

/**
* Calls the given JSONAPI API methods with the given args.
*
* @param array $methods An array strings, where each string is the name of a JSONAPI API method to call.
* @param array $args An array of arrays of arguments that are to be passed.
* @throws Exception When the length of the $methods array and the $args array are different, an exception is thrown.
* @return array An array of associative arrays representing the JSON that was returned.
*/
public function callMultiple(array $methods, array $args = array()) {
if(count($methods) !== count($args)) {
throw new Exception(sprintf('The length of the arrays %s and %s are different! You need an array of arguments for each method!', $methods, $args));
}

$url = $this->makeURLMultiple($methods, $args);

return json_decode($this->curl($url), true);
}
/**
* The default function called if no one matched for JSONAPI.
*
* @param string $method The name of the JSONAPI API method to call.
* @param array $params An array of arguments that are to be passed.
* @return array An associative array representing the JSON that was returned.
*/
function __call($method, $params) {
if(is_array($params)) {
return $this->call($method, $params);
} else {
return $this->call($method, array($params));
}
}

/**
* @return string
*/
public function getHost() {
return $this->host;
}

/**
* @param string $newhost
* @return JSONAPI This object, for method chaining
*/
public function setHost($host) {
$this->host = $host;

return $this;
}

/**
* @return integer
*/
public function getPort() {
return $this->port;
}

/**
* @param integer $newport
* @return JSONAPI This object, for method chaining
*/
public function setPort($port) {
$port = (int) $port;
if ($port < 1 || $port > 65535) {
throw new Exception('The port must be between 1 and 65535, you supplied ' . $port);
}
$this->port = $port;

return $this;
}

/**
* @return string
*/
public function getUsername() {
return $this->username;
}

/**
* @param string $newusername
* @return JSONAPI This object, for method chaining
*/
public function setUsername($username) {
$this->username = $username;

return $this;
}

/**
* @return string
*/
public function getPassword() {
return $this->password;
}

/**
* @param string $newpassword
* @return JSONAPI This object, for method chaining
*/
public function setPassword($username) {
$this->password = $password;

return $this;
}

/**
* @return integer
*/
public function getTimeout() {
return $this->timeout;
}

/**
* @param integer $newtimeout
* @return JSONAPI This object, for method chaining
*/
public function setTimeout($timeout) {
$this->timeout = (int) $timeout;

return $this;
}
}
Click to expand...

timtower · Feb 16, 2014

To175 Config of JSONAPI is not configured on the server port

To175 · Feb 16, 2014

what ?

timtower · Feb 16, 2014

To175 said: ↑

what ?
Click to expand...

Could you post your jsonapi config?

To175 · Feb 16, 2014

which ? I have post all I have...
Isn't it ?

<?php

require 'JSONAPI.php';

$api = new JSONAPI("88.xx.xx.xx 40088, "to175", "xxx", "salt");

var_dump($api->call("getPlayerLimit"));
?>
Click to expand...

timtower · Feb 16, 2014

To175 JSONAPI has a config file in plugins/JSONAPI, talking about that one

To175 · Feb 16, 2014

I have posted it...
this is :

<?php
/**
* A PHP class for access Minecraft servers that have Bukkit with the {@link http://github.com/alecgorge/JSONAPI JSONAPI} plugin installed.
*
* This class handles everything from key creation to URL creation to actually returning the decoded JSON as an associative array.
*
* @author Alec Gorge <[email protected]>
* @version Alpha 5
* @Link http://github.com/alecgorge/JSONAPI
* @package JSONAPI
* @since Alpha 5
*/
class JSONAPI {
private $host;
private $port;
private $username;
private $password;
const URL_FORMAT = 'http://%s:%d/api/2/call?json=%s';
private $timeout;

/**
* Creates a new JSONAPI instance.
*/
public function __construct ($host, $port, $uname, $pword, $salt = '', $timeout = 10) {
$this->host = $host;
$this->port = $port;
$this->username = $uname;
$this->password = $pword;
$this->salt = $salt;
$this->timeout = $timeout;
}

/**
* Generates the proper SHA256 based key from the given method suitable for use as the key GET parameter in a JSONAPI API call.
*
* @param string $method The name of the JSONAPI API method to generate the key for.
* @return string The SHA256 key suitable for use as the key GET parameter in a JSONAPI API call.
*/
public function createKey($method) {
if(is_array($method)) {
$method = json_encode($method);
}
return hash('sha256', $this->username . $method . $this->password);
}

/**
* Generates the proper URL for a standard API call the given method and arguments.
*
* @param string $method The name of the JSONAPI API method to generate the URL for.
* @param array $args An array of arguments that are to be passed in the URL.
* @return string A proper standard JSONAPI API call URL. Example: "http://localhost:20059/api/call?method=methodName&args=jsonEncodedArgsArray&key=validKey".
*/
public function makeURL($method, array $args) {
return sprintf(self::URL_FORMAT, $this->host, $this->port, rawurlencode(json_encode($this->constructCall($method, $args))));
}

/**
* Generates the proper URL for a multiple API call the given method and arguments.
*
* @param array $methods An array of strings, where each string is the name of the JSONAPI API method to generate the URL for.
* @param array $args An array of arrays, where each array contains the arguments that are to be passed in the URL.
* @return string A proper multiple JSONAPI API call URL. Example: "http://localhost:20059/api/call-mul...rgs=jsonEncodedArrayOfArgsArrays&key=validKey".
*/
public function makeURLMultiple(array $methods, array $args) {
return sprintf(self::URL_FORMAT, $this->host, $this->port, rawurlencode(json_encode($this->constructCalls($methods, $args))));
}

/**
* Calls the single given JSONAPI API method with the given args.
*
* @param string $method The name of the JSONAPI API method to call.
* @param array $args An array of arguments that are to be passed.
* @return array An associative array representing the JSON that was returned.
*/
public function call($method, array $args = array()) {
if(is_array($method)) {
return $this->callMultiple($method, $args);
}

$url = $this->makeURL($method, $args);

return json_decode($this->curl($url), true);
}

private function curl($url) {
if(extension_loaded('cURL')) {
$c = curl_init($url);
curl_setopt($c, CURLOPT_PORT, $this->port);
curl_setopt($c, CURLOPT_HEADER, false);
curl_setopt($c, CURLOPT_RETURNTRANSFER, true);
curl_setopt($c, CURLOPT_TIMEOUT, $this->timeout);
$result = curl_exec($c);
curl_close($c);
return $result;
}else{
$opts = array('http' =>
array(
'timeout' => $this->timeout
)
);
return file_get_contents($url, false, stream_context_create($opts));
}
}

private function constructCall($method, array $args) {
$json = array();
$json['name'] = $method;
$json['arguments'] = $args;
$json['key'] = $this->createKey($method);
$json['username'] = $this->username;
return $json;
}

private function constructCalls(array $methods, array $args) {
$calls = array();
foreach ($methods as $key => $method) {
$calls[] = $this->constructCall($method, $args[$key]);
}
return $calls;
}

/**
* Calls the given JSONAPI API methods with the given args.
*
* @param array $methods An array strings, where each string is the name of a JSONAPI API method to call.
* @param array $args An array of arrays of arguments that are to be passed.
* @throws Exception When the length of the $methods array and the $args array are different, an exception is thrown.
* @return array An array of associative arrays representing the JSON that was returned.
*/
public function callMultiple(array $methods, array $args = array()) {
if(count($methods) !== count($args)) {
throw new Exception(sprintf('The length of the arrays %s and %s are different! You need an array of arguments for each method!', $methods, $args));
}

$url = $this->makeURLMultiple($methods, $args);

return json_decode($this->curl($url), true);
}
/**
* The default function called if no one matched for JSONAPI.
*
* @param string $method The name of the JSONAPI API method to call.
* @param array $params An array of arguments that are to be passed.
* @return array An associative array representing the JSON that was returned.
*/
function __call($method, $params) {
if(is_array($params)) {
return $this->call($method, $params);
} else {
return $this->call($method, array($params));
}
}

/**
* @return string
*/
public function getHost() {
return $this->host;
}

/**
* @param string $newhost
* @return JSONAPI This object, for method chaining
*/
public function setHost($host) {
$this->host = $host;

return $this;
}

/**
* @return integer
*/
public function getPort() {
return $this->port;
}

/**
* @param integer $newport
* @return JSONAPI This object, for method chaining
*/
public function setPort($port) {
$port = (int) $port;
if ($port < 1 || $port > 65535) {
throw new Exception('The port must be between 1 and 65535, you supplied ' . $port);
}
$this->port = $port;

return $this;
}

/**
* @return string
*/
public function getUsername() {
return $this->username;
}

/**
* @param string $newusername
* @return JSONAPI This object, for method chaining
*/
public function setUsername($username) {
$this->username = $username;

return $this;
}

/**
* @return string
*/
public function getPassword() {
return $this->password;
}

/**
* @param string $newpassword
* @return JSONAPI This object, for method chaining
*/
public function setPassword($username) {
$this->password = $password;

return $this;
}

/**
* @return integer
*/
public function getTimeout() {
return $this->timeout;
}

/**
* @param integer $newtimeout
* @return JSONAPI This object, for method chaining
*/
public function setTimeout($timeout) {
$this->timeout = (int) $timeout;

return $this;
}
}
Click to expand...

timtower · Feb 16, 2014

To175 It is not a PHP file, it is a config file, one with a .yml extension, in the server!

To175 · Feb 16, 2014

ok , config.yml :

# API methods on the method-whitelist will be
# able to called without any sort of authentication
method-whitelist:
- getPlayerLimit
- dynmap.getPort
options:
stream_pusher:
max_queue_age: 30
max_queue_length: 500
startup-delay: 2000
port: 40088
ip-whitelist: []
log-to-console: true
log-to-file: 'false'
anyone-can-use-calladmin: false
use-new-api: true
Click to expand...

timtower · Feb 16, 2014

To175 That was the one.
Try this one:

Code:

# API methods on the method-whitelist will be
# able to called without any sort of authentication
method-whitelist:
- getPlayerLimit
- dynmap.getPort
options:
stream_pusher:
max_queue_age: 30
max_queue_length: 500
startup-delay: 2000
port: 10252
ip-whitelist: []
log-to-console: true
log-to-file: 'false'
anyone-can-use-calladmin: false
use-new-api: true

To175 · Feb 16, 2014

[18:39:13] [Server thread/INFO]: [JSONAPI] Enabling JSONAPI v5.5.0
[18:39:13] [Server thread/INFO]: [JSONAPI] Logging to file: false
[18:39:13] [Server thread/INFO]: [JSONAPI] Logging to console: true
[18:39:13] [Server thread/INFO]: [JSONAPI] IP Whitelist = None, all requests are allowed.
[18:39:13] [Server thread/ERROR]: [JSONAPI] Couldn't start server!

[18:39:13] [Server thread/WARN]: java.net.BindException: Adresse déjà utilisée
[18:39:13] [Server thread/WARN]: at java.net.PlainSocketImpl.socketBind(Native Method)
[18:39:13] [Server thread/WARN]: at java.net.AbstractPlainSocketImpl.bind(AbstractPlainSocketImpl.java:376)
[18:39:13] [Server thread/WARN]: at java.net.ServerSocket.bind(ServerSocket.java:376)
[18:39:13] [Server thread/WARN]: at java.net.ServerSocket.<init>(ServerSocket.java:237)
[18:39:13] [Server thread/WARN]: at java.net.ServerSocket.<init>(ServerSocket.java:128)
[18:39:13] [Server thread/WARN]: at com.alecgorge.minecraft.jsonapi.NanoHTTPD.<init>(NanoHTTPD.java:277)
[18:39:13] [Server thread/WARN]: at com.alecgorge.minecraft.jsonapi.NanoHTTPD.<init>(NanoHTTPD.java:302)
[18:39:13] [Server thread/WARN]: at com.alecgorge.minecraft.jsonapi.JSONServer.<init>(JSONServer.java:51)
[18:39:13] [Server thread/WARN]: at com.alecgorge.minecraft.jsonapi.JSONAPI.onEnable(JSONAPI.java:518)
[18:39:13] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:218)
[18:39:13] [Server thread/WARN]: at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:457)
[18:39:13] [Server thread/WARN]: at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:384)
[18:39:13] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_7_R1.CraftServer.loadPlugin(CraftServer.java:298)
[18:39:13] [Server thread/WARN]: at org.bukkit.craftbukkit.v1_7_R1.CraftServer.enablePlugins(CraftServer.java:280)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.m(MinecraftServer.java:342)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.g(MinecraftServer.java:319)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.a(MinecraftServer.java:275)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.DedicatedServer.init(DedicatedServer.java:175)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:424)
[18:39:13] [Server thread/WARN]: at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617)
Click to expand...

Yes :

[18:39:13] [Server thread/WARN]: java.net.BindException: Adresse déjà utilisée
Click to expand...

This is the port to CONNECT MY SERVER ! ... of course it is busy ....

timtower · Feb 16, 2014

To175 said: ↑

Yes :

This is the port to CONNECT MY SERVER ! ... of course it is busy ....
Click to expand...

Did work before, will make this plugin for you then

To175 · Feb 16, 2014

ok thanks you verry much !
But do you think that the plugin I descibed is a really good idea ?

timtower · Feb 16, 2014

To175 said: ↑

ok thanks you verry much !
But do you think that the plugin I descibed is a really good idea ?
Click to expand...

It all depends on what you are using it for.
https://www.dropbox.com/s/kpbz72uvs67ochy/WebCommand.jar
Config contains default database stuff, table variable ( you can define it yourself ), time variable, in seconds.
Table is self creating, contains 2 columns. First one is the ID, used to identify the command ( for removal ) second one is the command, without the /

When not working: post the full startup log till the moment that you stop the server ( or after the complete error )
ID column is auto_increment btw, so don't need to insert on that one

To175 · Jun 6, 2016

Thanks !!!
I have some issues right after putting the .jar in my folder !

...
9 more

[Erreur Java]
org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:173) ~[craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
java.lang.Class.forName(Class.java:270) ~[?:1.7.0_25]

[Erreur Java]
java.lang.Class.forName0(Native Method) ~[?:1.7.0_25]

[Erreur Java]
java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.7.0_25]

[Erreur Java]
java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.7.0_25]

[Erreur Java]
org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:53) ~[craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.plugin.java.PluginClassLoader.findClass0(PluginClassLoader.java:80) ~[craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
java.net.URLClassLoader.findClass(URLClassLoader.java:354) ~[?:1.7.0_25]

[Erreur Java]
java.security.AccessController.doPrivileged(Native Method) ~[?:1.7.0_25]

[Erreur Java]
java.net.URLClassLoader$1.run(URLClassLoader.java:355) ~[?:1.7.0_25]

[Erreur Java]
java.net.URLClassLoader$1.run(URLClassLoader.java:366) ~[?:1.7.0_25]

Caused
by: java.lang.ClassNotFoundException: nl.timdebrouwer.webcheck.WebCommand

[Erreur Java]
net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:424) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
net.minecraft.server.v1_7_R1.DedicatedServer.init(DedicatedServer.java:126) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
net.minecraft.server.v1_7_R1.DedicatedPlayerList.(SourceFile:14) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
net.minecraft.server.v1_7_R1.PlayerList.(PlayerList.java:63) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.craftbukkit.v1_7_R1.CraftServer.(CraftServer.java:233) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.craftbukkit.v1_7_R1.CraftServer.loadPlugins(CraftServer.java:255) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:231) [craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:308) ~[craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

[Erreur Java]
org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:184) ~[craftbukkit-beta.jar:git-Bukkit-1.7.2-R0.2-b2974jnks]

org.bukkit.plugin.InvalidPluginException:
java.lang.ClassNotFoundException: nl.timdebrouwer.webcheck.WebCommand

[16:46:45]
[Server thread/ERROR] : Could not load 'plugins/WebCommand.jar' in folder 'plugins'
Click to expand...

And I was thinking about new features :
• somethings to run this command on the server :
/wcSend xxx
Like that a row is inserted => || ID : "n" | command : "wcsend xxx" | player : "to175" ||

• somethings to timeout the command :
I do /wcsend 60 pex user to175 group set defaut.
Like that the command is ran 1 (real) minute later !
· And on my website => server I can insert "wcReceive 60 pex user to175 group set defaut", it will does the same things.
Row : || ID : "n" | command : "wcReceive pex user to175 group set defaut" | player : "to175" | timeout : "60"||

Thanks !

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

timtower · Feb 17, 2014

To175 1. Fixed the error: https://www.dropbox.com/s/kpbz72uvs67ochy/WebCommand.jar
2. This plugin isn't designed to perform insert statements or to delay certain commands

To175 · Feb 17, 2014

url: jdbc:mysql://xxx.xxx.xxx:xxxx/db_db
user: db_user
password: pass
table: commands
time: 300
Click to expand...

[19:20:51]
[Server thread/INFO] : [WebCheck] Connection tested, everything working like it should

[19:20:49]
[Server thread/INFO] : [WebCheck] Enabling WebCheck v0.0.1
Click to expand...

[19:31:50]
[pool-3-thread-3/INFO]: [WebCheck] Disabling WebCheck v0.0.1

The
last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

[19:31:50]
[pool-3-thread-3/ERROR]: [WebCheck] Communications link failure

[19:31:50]
[pool-3-thread-3/ERROR]: [WebCheck] Connection could not be made, disable this plugin

[19:26:52]
[pool-3-thread-3/INFO]: £123 ajoutés au compte de to175. Nouveau solde : £3149

[19:26:52]
[pool-3-thread-3/INFO]: CONSOLE issued server command: /eco give to175 123
Click to expand...

Ok it works anyway !!

timtower · Feb 17, 2014

To175 Could you please upload the entire log to http://pastebin.com ?
And please use the tahg button if you reply to me

To175 · Feb 17, 2014

@timetower http://pastebin.com/tmJ1U88w

timtower · Feb 17, 2014

To175 said: ↑

@timetower http://pastebin.com/tmJ1U88w
Click to expand...

And the entire server log?

Log in or Sign up

PHP -> SQL -> server

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

To175

timtower Administrator Administrator Moderator

Share This Page

PHP -> SQL -> server

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

timtower Administrator Administrator Moderator

Share This Page

Useful Searches