sebaturen / blizzard-wow-guild-information-panel Goto Github PK
View Code? Open in Web Editor NEWBlizzard Wow Guild Information Panel
Home Page: http://www.artofwar.cl
Blizzard Wow Guild Information Panel
Home Page: http://www.artofwar.cl
Hello,
It's been a while :D
It seems you change the way to run your project, can you update the installation guide on the Readme when you're available ?
Hope you're alright,
Cheers
Erreur
Requête SQL :
CREATE TABLE `character_info` (
`internal_id` int NOT NULL,
`battlegroup` varchar(50) NOT NULL,
`class` int NOT NULL,
`race` int NOT NULL,
`gender` int NOT NULL,
`level` int NOT NULL,
`achievementPoints` bigint(20) NOT NULL,
`thumbnail` varchar(70) NOT NULL,
`calcClass` varchar(2) NOT NULL,
`faction` int NOT NULL,
`totalHonorableKills` bigint(20) NOT NULL,
`bestMythicPlusScore` TEXT DEFAULT "{}",
`mythicPlusScores` TEXT DEFAULT "{}",
`guild_name` varchar(50) NOT NULL,
`lastModified` bigint(20) NOT NULL,
PRIMARY KEY(internal_id),
FOREIGN KEY(internal_id) REFERENCES gMembers_id_name(internal_id),
FOREIGN KEY(`class`) REFERENCES playable_class(id),
FOREIGN KEY(race) REFERENCES playable_races(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
MySQL a répondu: Documentation
#1101 - BLOB 'bestMythicPlusScore' ne peut avoir de valeur par défaut
Wich is - Error number: 1101; Symbol: ER_BLOB_CANT_HAVE_DEFAULT; SQLSTATE: 42000
Message: BLOB, TEXT, GEOMETRY or JSON column '%s' can't have a default value
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package test;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Calendar;
import java.util.Date;
import java.util.TimeZone;
import org.json.simple.JSONObject;
/**
*
* @author 세바
*/
public class Test {
public static final int RESET_DAY = Calendar.TUESDAY; //dey of week
public static final int RESET_HOUR = 9; //hore of day (24h)
/**
* @param args the command line arguments
*/
public static void main(String[] args) {
//quiero obtener el tiempo desde el ultimo dia del reset [fecha actual - {fecha hasta reset}]
Date sTime = new Test().getServerTime();
System.out.println("sTime> "+ sTime);
Calendar c = Calendar.getInstance();
c.setTime(sTime);
System.out.println("C> "+ c.get(Calendar.DAY_OF_WEEK));
long lastUpdate;
if(c.get(Calendar.DAY_OF_WEEK) == RESET_DAY) //reset day
{
if(c.get(Calendar.HOUR_OF_DAY) >= RESET_HOUR) //is reset day
lastUpdate = getLastReset(c, true);
else //last reset day
lastUpdate = getLastReset(c, false);
}
else //last reset day
lastUpdate = getLastReset(c, false);
}
public static long getLastReset(Calendar time, boolean isMartes)
{
if(!isMartes)
{
do
{
time.add(Calendar.DAY_OF_WEEK, -1);
} while(time.get(Calendar.DAY_OF_WEEK) != RESET_DAY);
}
time.set(Calendar.HOUR_OF_DAY, RESET_HOUR);
time.set(Calendar.MINUTE, 0);
time.set(Calendar.SECOND, 0);
System.out.println("Fecha> "+ time.get(Calendar.DAY_OF_MONTH) +"/"+ time.get(Calendar.MONTH)+1);
System.out.println("Hora> "+ time.get(Calendar.HOUR_OF_DAY) +":"+ time.get(Calendar.MINUTE));
System.out.println("Calendar> "+ time.getTimeInMillis());
Date currentTime = null;
try {
currentTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(
time.get(Calendar.YEAR) +"-"+
(time.get(Calendar.MONTH)+1) +"-"+ //calendar object start month in 0
time.get(Calendar.DAY_OF_MONTH) +" "+
time.get(Calendar.HOUR_OF_DAY) +":"+
time.get(Calendar.MINUTE) +":"+
time.get(Calendar.SECOND));
} catch (ParseException ex) {
System.out.println("Error> "+ ex);
}
System.out.println("Calendar 2> "+ currentTime);
System.out.println("Calendar 2> "+ currentTime.getTime());
return time.getTimeInMillis();
}
public Date getServerTime()
{
Date currentTime = null;
try {
Calendar currentCalendar = Calendar.getInstance();
currentCalendar.setTimeZone(TimeZone.getTimeZone("America/Los_Angeles"));
currentTime = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(
currentCalendar.get(Calendar.YEAR) +"-"+
(currentCalendar.get(Calendar.MONTH)+1) +"-"+ //calendar object start month in 0
currentCalendar.get(Calendar.DAY_OF_MONTH) +" "+
currentCalendar.get(Calendar.HOUR_OF_DAY) +":"+
currentCalendar.get(Calendar.MINUTE) +":"+
currentCalendar.get(Calendar.SECOND));
} catch (ParseException ex) {
System.out.println("Error> "+ ex);
}
return currentTime;
}
}
fix polls isEnable and isDisable :D
Hello,
I followed the instructions and I cant start the webapps ,
I got the following errors in logs
28-Jan-2019 18:07:32.470 INFOS [http-nio-8080-exec-4] org.apache.catalina.core.ApplicationContext.log HTMLManager: start: Starting web application '/Blizzard-WoW-Guild-information-panel'
28-Jan-2019 18:07:36.605 GRAVE [http-nio-8080-exec-4] org.apache.catalina.core.StandardContext.listenerStart Erreur lors de la configuration de la classe d'écoute de l'application (application listener) com.blizzardPanel.blizzardAPI.Upd$
java.lang.ClassNotFoundException: com.blizzardPanel.blizzardAPI.UpdateRunning
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1285)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1119)
at org.apache.catalina.core.DefaultInstanceManager.loadClass(DefaultInstanceManager.java:511)
at org.apache.catalina.core.DefaultInstanceManager.loadClassMaybePrivileged(DefaultInstanceManager.java:492)
at org.apache.catalina.core.DefaultInstanceManager.newInstance(DefaultInstanceManager.java:118)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4675)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5215)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1307)
at org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:669)
at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:217)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:136)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:108)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:587)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1458)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Version
Mariadb 10.1.37
tomcat 8
content in /var/lib/tomcat/lib mariadb-java-client-2.3.0.jar
java version openjdk version "1.8.0_181"
OpenJDK Runtime Environment (build 1.8.0_181-8u181-b13-2~deb9u1-b13)
OpenJDK 64-Bit Server VM (build 25.181-b13, mixed mode)
os debian 9 x64
Cheers and thanks for your support
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.