my Top Players package has been released :)
get it here:
www.megaupload.com/?d=7LYUAXV1
Just follow the instructions in Top Players.txt ;)
Printable View
my Top Players package has been released :)
get it here:
www.megaupload.com/?d=7LYUAXV1
Just follow the instructions in Top Players.txt ;)
I put this together as a package, main JSP and PHP credis as follows:
-JSP-------------------------------------- BY MARHAZK & **********
-JSP MSSQL-MySQL Modifications---- ADSLPREDATOR, 2008
-PHP-------------------------------------- by HHP- Hendrik
************
* Top Players *
************a package by 343
Here is a preview:
username / passwd = xxx /// localhost / 172.0.0.x / etc.pp - no work
Code:HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Exception in JSP: /addons/Top Players/index.jsp:36
33: Class.forName("com.mysql.jdbc.Driver");
34: //Class.forName("com.goldhuman.util.MySqlCon");
35:
36: connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/dbo?useUnicode=true&characterEncoding=utf8", "xxx", "xxx");
37: Statement statement = connection.createStatement();
38:
39: //
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:451)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
javax.servlet.ServletException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:841)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:774)
org.apache.jsp.addons.Top_0020Players.index_jsp._jspService(index_jsp.java:171)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
com.mysql.jdbc.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1115)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2257)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:350)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.addons.Top_0020Players.index_jsp._jspService(index_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
com.mysql.jdbc.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1115)
com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2178)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:350)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.addons.Top_0020Players.index_jsp._jspService(index_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
root cause
java.net.ConnectException: Connection refused
java.net.PlainSocketImpl.socketConnect(Native Method)
java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
java.net.SocksSocketImpl.connect(SocksSocketImpl.java:367)
java.net.Socket.connect(Socket.java:524)
java.net.Socket.connect(Socket.java:474)
java.net.Socket.<init>(Socket.java:371)
java.net.Socket.<init>(Socket.java:213)
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:292)
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2178)
com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:784)
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:350)
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
org.apache.jsp.addons.Top_0020Players.index_jsp._jspService(index_jsp.java:87)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
Apache Tomcat/5.5.28
The only time I have been able to reproduce errors anything like this is when I either did not import the database, or did not have all parts of the server running.
Checklist:
make sure you imported dbo.sql
make sure you have your MySql running
make sure you have apache (http server) running
make sure you have all PW services running as well (including at least just the world map)
make sure you have apache (tomcat) running
make sure not to change the directory name away from 'Top Players' for addons
---------- Post added at 11:22 PM ---------- Previous post was at 11:13 PM ----------
Ok, I was able to reproduce your exact error. You must start MySql ;)
why not take all from game data base and display it in real time and not insert and select from mysql :D
Totally agree... :/:Quote:
Originally Posted by www
And the imported data are reset each time a player see the top rank :scared: !!!
WTF ?! :scared:
I disabled the auto refresh to prevent overload of CPU usage...... :/:
Because at every refresh of the page, it reset the database and re-import the roles data again and again and again in the mysql database.... :O:
credits!
Hendrik
Owesome!
Idia: Germania, Hemer
Credits : Hemer for PHP script, Romulan for the Basic Script.
Some people always forget ;)
greetings
germania
" Ok, I was able to reproduce your exact error. You must start MySql ;) " is running btw
uh oh :( That was the only way I was able to reproduce that exact error :( Looks like it's back to the drawing boards!Quote:
Originally Posted by fgru
you use tomecat for it or lampp?
we use both
Correct, both are required:
Apache HTTP server
&
Apache Tomcat
@fgru - I am really drawing blanks here :( The only way I can reproduce that exact error is when I don't start MySQL server :(
The only other thing I can think of to try at the moment would be to download my pack of pwAdmin 1.0a; and see if it works with that :\
http://forum.ragezone.com/5761146-post701.html
pwadmin is the newest :) i have little time for pserver - so its not important for me :) sry bad grammar :(
This script is nasty for big databases.
---------- Post added at 04:39 PM ---------- Previous post was at 04:33 PM ----------
Addition to this:
If your db has over 30,000 accounts u will have some issues transferring the information, possibly memory issues etc but i dont see this being the problem as I have 16gb ram, duo quadcore machine and had it running the server on world map only as well as all services running to handle the load and still it will crash at around 16,000 characters, system load of only 5.2 and still nothing it will crash.
Good script for small servers bad script for big ones, very nice release tho, only way i found to get around would be every 100,000th id reset the script.
i agree...
Ok the script is handling too much data at once it kills your auth and gamedbd process, keep the script running and simply start ur server back up via the shell and it will kick back in and add whatever else is missing.
Since i have over 70,000 Characters on my db it stops a few times, im re-writing the script including exceptions so if it does occur it will automatically restart your gamedb services and auth services.
Link off '-'
Yes sorry, I have removed this file since I have an entire release. You can find this within my release package... ;)Quote:
Originally Posted by Suedevander
get me link ?
Hi 343, could you provide us with a Link to your Complete Package? As I can't find it anywhere and I am sure I looked (but might be wrong I am stupidly blind sometimes lol)Quote:
Originally Posted by 343
regards
far