pwAdmin 1.4.4

so far i have about 90% of things working

only thing i have a problem with is the characterlist and roles of database.

cant seem to find issue.

where would one make the roles list for database in roles...

so far it doesnt run like standard structure of 136

example... userid 32 (role:32)

this new one runs with something different.

userid example 32 and role via character example id 1024 or what not just an example.

any ideas on it.... as its all i got left to fix on pwAdmin just for full functionality.

so far what works is:

-send mail
-whos online
-list of gm's
-gm control
-start/stop server
-start/stop specific maps
-backup / restore functions
-accounts (create edit delete add gold remove gold add gm remove gm change password and see all accounts)
server configureation (cannot change exp but can enable double exp drop coin sp etc....) hangtime of 1 minute shows online accounts etc.
-live chat (little buggy but works 80% of the time)

------------
my programs

VERSION CHANGER for 1.4.4

------------

Quote:

---

Originally Posted by 88supra86

so far i have about 90% of things working

only thing i have a problem with is the characterlist and roles of database.

cant seem to find issue.

where would one make the roles list for database in roles...

so far it doesnt run like standard structure of 136

example... userid 32 (role:32)

this new one runs with something different.

userid example 32 and role via character example id 1024 or what not just an example.

any ideas on it.... as its all i got left to fix on pwAdmin just for full functionality.

so far what works is:

-send mail
-whos online
-list of gm's
-gm control
-start/stop server
-start/stop specific maps
-backup / restore functions
-accounts (create edit delete add gold remove gold add gm remove gm change password and see all accounts)
server configureation (cannot change exp but can enable double exp drop coin sp etc....) hangtime of 1 minute shows online accounts etc.
-live chat (little buggy but works 80% of the time)

------------
my programs

VERSION CHANGER for 1.4.4

------------

---

yes me to 80 % work :D:

live chat : just horn speker need to edit semile and GM broadcast

i have same problem on roles. Still trying to find from where came this issue

link? or it's only text :D

Quote:

---

Originally Posted by dj1818

link? or it's only text :D

---

Why don't you try to read the version changer post? >.>
Posted via Mobile Device

This may be a temp solution that we are using till we figure out how the rest works.

Mysql TABLE

Code:

---

--
-- Table structure for table `cuid`
--

CREATE TABLE IF NOT EXISTS `cuid` (
  `id` int(11) NOT NULL,
  `uid` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

update.jsp

Code:

---

<%@ page contentType="text/html; charset=UTF-8" %>
<%@ page import="java.util.*"%>
<%@ page import="com.goldhuman.auth.AuthFilter"%>
<%@ page import="com.goldhuman.service.interfaces.LogInfo"%>
<%@ page import="com.goldhuman.service.interfaces.SimpleRoleBean"%>
<%@ page import="com.goldhuman.service.interfaces.GMService"%>
<%@ page import="com.goldhuman.service.GMServiceImpl"%>
<%@ page import="org.apache.commons.logging.LogFactory"%>
<%@ page import="com.goldhuman.util.LocaleUtil"%>
<%@ page import="java.sql.*"%>
<%@page import="java.io.*"%>
<%@page import="java.sql.*"%>
<%@page import="protocol.*"%>
<%@page import="java.text.*"%>
<%@page import="java.util.Iterator"%>
<%@page import="com.goldhuman.Common.Octets"%>
<%@page import="com.goldhuman.IO.Protocol.Rpc.Data.DataVector"%>
<%@page import="org.apache.commons.lang.StringEscapeUtils"%>
<%@ page import="com.goldhuman.auth.AuthFilter"%>
<%@ page import="com.goldhuman.service.interfaces.LogInfo"%>
<%@ page import="com.goldhuman.service.interfaces.CashInfoBean"%>
<%@ page import="com.goldhuman.service.interfaces.GMService"%>
<%@ page import="com.goldhuman.service.GMServiceImpl"%>
<%@page import="org.apache.commons.logging.LogFactory"%>
<%@page import="com.goldhuman.util.LocaleUtil"%>


        String db_host = "localhost";
        String db_port = "3306";
        String db_user = "user";
        String db_password = "password";
        String db_database = "database";
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
Statement statement = connection.createStatement();
ResultSet rs;
                                                                        String trucate = "TRUNCATE TABLE cuid";
                                                                        statement.executeUpdate(trucate);
String command = null;
rs = (statement.executeQuery("SELECT ID FROM users"));
                // Get registered users
                while(rs.next())
                        {
                        int uid = Integer.parseInt(rs.getString("ID"));
                        DataVector dv = GameDB.getRolelist(uid);
                                                        if(dv != null)
                                                        {
                                                                Iterator itr = dv.iterator();
                                                                while(itr.hasNext())
                                                                {
                                                                        Connection connection2 = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
                                                                        Statement statement2 = connection2.createStatement();
                                                                      IntOctets ios = (IntOctets)itr.next();
                                                                      int roleid = ios.m_int;
                                                                        if(roleid != 0)
                                                                        {
                                                                        String commandd = "INSERT INTO cuid (id, uid) VALUES ('"+uid+"', '"+roleid+"')";
                                                                        statement2.executeUpdate(commandd);
                                                                        }
                                                                        else
                                                                        {
                                                                        out.println("Done.");
                                                                        }
                                                                        connection2.close();
                                                                }       
                                                        }
                               

                        }
                       
                        rs.close();
                        connection.close();
}
catch(Exception e)
{
out.println(e);
}

---

Role.jsp example

Code:

---

RoleBean character;
                        //GET ACCOUNT BY USER ID
                       
                        if(request.getParameter("type") != null && request.getParameter("type").compareTo("uid") == 0)
                        {
                       
                        int rid2 = Integer.parseInt(request.getParameter("ident"));
                        userid = rid2;
                       
                        DataVector dv = GameDB.getRolelist(rid2);
                        if(dv != null)
                        {
                        Iterator itr = dv.iterator();
                        while(itr.hasNext())
                        {
                        IntOctets ios = (IntOctets)itr.next();
                        uid = ios.m_int;
                        id = ios.m_int;
                        String rolename = ios.m_octets.getString();
                        }
                        }
                        }
                        //GET ACCOUNT BY Character ID
                        else if(request.getParameter("type") != null && request.getParameter("type").compareTo("id") == 0)
                        {
                        int rid2 = Integer.parseInt(request.getParameter("ident"));
                       
                        if (request.getParameter("been") == null)
                        {
                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                        connectionselect = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
                        statementselect = connectionselect.createStatement();
                        rsselect = statementselect.executeQuery("SELECT * FROM cuid WHERE uid='" + rid2 + "'");
                        if (rsselect.next())
                        {
                        userid=rsselect.getInt("id");
                        rsselect.close();
                        connectionselect.close();
                        }
                       
                        else
                        {
                        pageContext.include("update.jsp");
                        rsselect.next();
                        userid=rsselect.getInt("id");
                        rsselect.close();
                        connectionselect.close();
                        }
                        id = rid2;
                        uid = userid;
                        }
                        else
                        {
                        userid=Integer.parseInt(request.getParameter("been"));
                        id = rid2;
                        uid = rid2;
                        }
                        }
                        //GET ACCOUNT BY Character NAME
                else
                {
                        rnameN = request.getParameter("ident");
                        try {
                                GMService gs = new GMServiceImpl();
                                int tem = gs.getRoleIdByName(rnameN, new LogInfo());
                                useridN = (tem & 0xFFFFFFF0) + "";
                               
                        } catch (Exception e) {
                        }
                       
                        int rid2 = Integer.parseInt(useridN);
                        Class.forName("com.mysql.jdbc.Driver").newInstance();
                        connectionselect = DriverManager.getConnection("jdbc:mysql://" + db_host + ":" + db_port + "/" + db_database, db_user, db_password);
                        statementselect = connectionselect.createStatement();                       
                        rsselect = statementselect.executeQuery("SELECT * FROM cuid WHERE uid='" + rid2 + "'");
                        if (rsselect.next())
                        {
                        userid=rsselect.getInt("id");
                        id = rid2;
                        uid = rid2;
                        rsselect.close();
                        connectionselect.close();
                        }
                       
                        else
                        {
                        pageContext.include("update.jsp");
                        rsselect.next();
                        userid=rsselect.getInt("id");
                        id = rid2;
                        uid = rid2;
                        rsselect.close();
                        connectionselect.close();
                       
                        }
       

                       
                               
                }

                        character = GameDB.get(id);


                       
                       
                       
                       
                        //### Apply Modifications

---

i got this error when open http://myip:8080/pwAdmin/update.jsp

HTTP ERROR 500
Problem accessing /pwAdmin/update.jsp. Reason:

PWC6033: Unable to compile class for JSP

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package



Caused by:
org.apache.jasper.JasperException: PWC6033: Unable to compile class for JSP

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package


at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:123)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:296)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:376)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:437)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:608)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:360)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:346)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)
at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529)
at java.lang.Thread.run(Thread.java:679)


--------------------------------------------------------------------------------
Powered by Jetty://

How to establish?

Quote:

---

Originally Posted by cogame

i got this error when open http://myip:8080/pwAdmin/update.jsp

HTTP ERROR 500
Problem accessing /pwAdmin/update.jsp. Reason:

PWC6033: Unable to compile class for JSP

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package



Caused by:
org.apache.jasper.JasperException: PWC6033: Unable to compile class for JSP

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package

PWC6199: Generated servlet error:
Only a type can be imported. com.goldhuman.util.LocaleUtil resolves to a package


at org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:123)
at org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:296)
at org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:376)
at org.apache.jasper.compiler.Compiler.compile(Compiler.java:437)
at org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:608)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:360)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:486)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:380)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:538)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:480)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:225)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:937)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:183)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:871)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:247)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:149)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
at org.eclipse.jetty.server.Server.handle(Server.java:346)
at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:589)
at org.eclipse.jetty.server.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:1048)
at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:601)
at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:214)
at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:411)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:535)
at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:40)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:529)
at java.lang.Thread.run(Thread.java:679)


--------------------------------------------------------------------------------
Powered by Jetty://

---

delete <%@ page import="com.goldhuman.util.LocaleUtil"%>

or install the cases of new iweb

Has anybody noticed if GMControl options are the same in 1.4.4 server?
I'm probably going to update it anyway for support of multiple server databases.

Quote:

---

Originally Posted by rbb138

Has anybody noticed if GMControl options are the same in 1.4.4 server?
I'm probably going to update it anyway for support of multiple server databases.

---

Its 100% the same i tested it.

Quote:

---

Originally Posted by LegalSin

Its 100% the same i tested it.

---

:thumbup1: yes work

yup the gm control is the same only thing thats different is it does not load character names for the selected user ID but yes works 100% for functionality

and i dont know who else is having problems with the live chat and broadcast from it but mine works fine :S

My admin panel works 100%

Quote:

---

Originally Posted by LegalSin

My admin panel works 100%

---

admin web pwAdmin you mean ? and xml mode work ?