pwAdmin 151

Ok skills Octects

octects for skills Eg Tiger Maw level 1:

01000000010000000000000001000000
the first 8 are the amount of skills 01000000 = 1
the next 16 is the skill 0100000000000000 = 1
the last 8 are the skill level 01000000 = 1


heres how to get the skill hex
configs.pck > skillstr.txt

we use this but remove that last digit
11 "^ffffffTiger Maw (Level %d)

so we use 1 convert to hex (double 8 bytes) > 0100000000000000
add its level, im gonna do level 1
1 > (double 4 bytes) > 01000000

"010000000000000001000000" = level 1 Tiger Maw

now lets add

21 "^ffffffDraw Blood (Level %d)

so take 21 - the last digit > 2
to hex (double 8 bytes) > 0200000000000000
add the level, im gonna do level 10 this time
10 > (double 4 bytes) > 0a000000
"02000000000000000a000000" = level 10 Draw Blood

put them together: so now we have

01000000000000000100000002000000000000000a000000
now all we are missing is the 1st 8 which is the amount of skill we have 2 so its
2 > (double 4 bytes) > 02000000

0200000001000000000000000100000002000000000000000a000000

2 skills | tiger maw level 1 | draw blood level 10
02000000 0100000000000000 01000000 0200000000000000 0a000000

hope that is clear enough...
 
Last edited:
after we get this :
2 skills | tiger maw level 1 | draw blood level 10
02000000 0100000000000000 01000000 0200000000000000 0a000000
and then ? put that on where ?

i think it's more good when create char and then get all skills :drool:
 
Ok skills Octects

octects for skills Eg Tiger Maw level 1:

01000000010000000000000001000000
the first 8 are the amount of skills 01000000 = 1
the next 16 is the skill 0100000000000000 = 1
the last 8 are the skill level 01000000 = 1


heres how to get the skill hex
configs.pck > skillstr.txt

we use this but remove that last digit
11 "^ffffffTiger Maw (Level %d)

so we use 1 convert to hex (double 8 bytes) > 0100000000000000
add its level, im gonna do level 1
1 > (double 4 bytes) > 01000000

"010000000000000001000000" = level 1 Tiger Maw

now lets add

21 "^ffffffDraw Blood (Level %d)

so take 21 - the last digit > 2
to hex (double 8 bytes) > 0200000000000000
add the level, im gonna do level 10 this time
10 > (double 4 bytes) > 0a000000
"02000000000000000a000000" = level 10 Draw Blood

put them together: so now we have

01000000000000000100000002000000000000000a000000
now all we are missing is the 1st 8 which is the amount of skill we have 2 so its
2 > (double 4 bytes) > 02000000

0200000001000000000000000100000002000000000000000a000000

2 skills | tiger maw level 1 | draw blood level 10
02000000 0100000000000000 01000000 0200000000000000 0a000000

hope that is clear enough...
skills - 0100000001000000000000000a000000

01000000 - count
skill 1: 01000000000000000a000000
  • 01000000 - id
  • 00000000 - progress (always 0 if not a craft)
  • 0a000000 - level (from 1 to 10)
 
roles table


Code:
-- phpMyAdmin SQL Dump
-- version 4.1.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 14, 2014 at 12:07 AM
-- Server version: 5.5.35-0ubuntu0.12.04.2
-- PHP Version: 5.3.10-1ubuntu3.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `pw`
--

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `account_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `role_name` varchar(64) NOT NULL,
  `role_level` smallint(6) NOT NULL,
  `role_race` tinyint(4) NOT NULL,
  `role_occupation` tinyint(4) NOT NULL,
  `role_gender` tinyint(4) NOT NULL,
  `role_spouse` int(11) NOT NULL,
  `faction_id` int(11) NOT NULL,
  `faction_name` varchar(64) NOT NULL,
  `faction_level` int(11) NOT NULL,
  `faction_domains` varchar(132) NOT NULL,
  `role_faction_rank` int(11) NOT NULL,
  `pvp_time` int(11) NOT NULL,
  `pvp_kills` int(11) NOT NULL,
  `pvp_deads` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `roles`
--

TRUNCATE TABLE `roles`;
/*!40101 SET CHARACTER_SET_CLIENT [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION [USER=1333464006]old[/USER]_COLLATION_CONNECTION */;

where did i put this? create new sql or what?
 
Here is the role table for mysql 5.1.73+
I know someone going to ask why there is an error or just to lazy to replace /*! ........ */ with # etc etc etc....
Code:
-- phpMyAdmin SQL Dump
-- version 5.1.73
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 14, 2014 at 12:07 AM
-- Server version: 5.5.35-0ubuntu0.12.04.2
-- PHP Version: 5.3.10-1ubuntu3.10

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


#40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT #;
#40101 SET [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS #;
#40101 SET [USER=1333464006]old[/USER]_COLLATION_CONNECTION=@@COLLATION_CONNECTION #;
#40101 SET NAMES utf8 #;

--
-- Database: `pw`
--

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

--
-- Table structure for table `roles`
--

DROP TABLE IF EXISTS `roles`;
CREATE TABLE IF NOT EXISTS `roles` (
  `account_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `role_name` varchar(64) NOT NULL,
  `role_level` smallint(6) NOT NULL,
  `role_race` tinyint(4) NOT NULL,
  `role_occupation` tinyint(4) NOT NULL,
  `role_gender` tinyint(4) NOT NULL,
  `role_spouse` int(11) NOT NULL,
  `faction_id` int(11) NOT NULL,
  `faction_name` varchar(64) NOT NULL,
  `faction_level` int(11) NOT NULL,
  `faction_domains` varchar(132) NOT NULL,
  `role_faction_rank` int(11) NOT NULL,
  `pvp_time` int(11) NOT NULL,
  `pvp_kills` int(11) NOT NULL,
  `pvp_deads` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Truncate table before insert `roles`
--

TRUNCATE TABLE `roles`;
#40101 SET CHARACTER_SET_CLIENT [USER=1333464006]old[/USER]_CHARACTER_SET_CLIENT #;
#40101 SET CHARACTER_SET_RESULTS [USER=1333464006]old[/USER]_CHARACTER_SET_RESULTS #;
#40101 SET COLLATION_CONNECTION [USER=1333464006]old[/USER]_COLLATION_CONNECTION #;
 
Please help me!
My PwAdmin cant doing it bot load
sora1984 - pwAdmin 151 - RaGEZONE Forums
 
But how edit?
i dont know how changer
Code:
[COLOR=#3F4549]<%@page import="[URL="http://java.io/"]java.io[/URL].*"%>[/COLOR]
[COLOR=#3F4549]<%[/COLOR]
[COLOR=#3F4549]//-------------------------------------------------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]//------------------------------- SETTINGS --------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]//-------------------------------------------------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]// pwadmin access password as md5 encrypted string[/COLOR]
[COLOR=#3F4549]// default password is root -> 63a9f0ea7bb98050796b649e85481845[/COLOR]
[COLOR=#3F4549]String iweb_password = "63a9f0ea7bb98050796b649e85481845";[/COLOR]
[COLOR=#3F4549]// connection settings to the mysql pw database[/COLOR]
[COLOR=#3F4549]String db_host = "localhost";[/COLOR]
[COLOR=#3F4549]String db_port = "3306";[/COLOR]
[COLOR=#3F4549]String db_user = "root";[/COLOR]
[COLOR=#3F4549]String db_password = "root";[/COLOR]
[COLOR=#3F4549]String db_database = "pw";[/COLOR]
[COLOR=#3F4549]// Type of your items database required for mapping id's to names[/COLOR]
[COLOR=#3F4549]// Options are my or pwi[/COLOR]
[COLOR=#3F4549]String item_labels = "pwi";[/COLOR]
[COLOR=#3F4549]// Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)[/COLOR]
[COLOR=#3F4549]// requires a tailing slash[/COLOR]
[COLOR=#3F4549]String pw_server_path = "/home/";[/COLOR]
[COLOR=#3F4549]// If you have hundreds of characters or heavy web acces through this site[/COLOR]
[COLOR=#3F4549]// It is recommend to turn the realtime character list feature off (false)[/COLOR]
[COLOR=#3F4549]// to prevent server from overload injected by character list generation[/COLOR]
[COLOR=#3F4549]boolean enable_character_list = true;[/COLOR]
[COLOR=#3F4549]String pw_server_name = "Perfect World";[/COLOR]
[COLOR=#3F4549]String pw_server_description = "Fixed by DaMadBoy, 151 iweb from Bola, Merged by Sora1984";[/COLOR]
[COLOR=#3F4549]//-------------------------------------------------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]//----------------------------- END SETTINGS ------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]//-------------------------------------------------------------------------------------------------------------------------[/COLOR]
[COLOR=#3F4549]String pw_server_exp = "?";[/COLOR]
[COLOR=#3F4549]String pw_server_sp = "?";[/COLOR]
[COLOR=#3F4549]String pw_server_drop = "?";[/COLOR]
[COLOR=#3F4549]String pw_server_coins = "?";[/COLOR]
[COLOR=#3F4549]BufferedReader bfr = new BufferedReader(new FileReader(pw_server_path + "gamed/ptemplate.conf"));[/COLOR]
[COLOR=#3F4549]String row;[/COLOR]
[COLOR=#3F4549]while((row = bfr.readLine()) != null)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]row = row.replaceAll("\\s", "");[/COLOR]
[COLOR=#3F4549]if(row.indexOf("exp_bonus=") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]int pos = row.length();[/COLOR]
[COLOR=#3F4549]if(row.indexOf("#") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]pos = row.indexOf("#");[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]pw_server_exp = row.substring(10, pos);[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]if(row.indexOf("sp_bonus=") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]int pos = row.length();[/COLOR]
[COLOR=#3F4549]if(row.indexOf("#") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]pos = row.indexOf("#");[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]pw_server_sp = row.substring(9, pos);[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]if(row.indexOf("drop_bonus=") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]int pos = row.length();[/COLOR]
[COLOR=#3F4549]if(row.indexOf("#") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]pos = row.indexOf("#");[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]pw_server_drop = row.substring(11, pos);[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]if(row.indexOf("money_bonus=") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]int pos = row.length();[/COLOR]
[COLOR=#3F4549]if(row.indexOf("#") != -1)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]pos = row.indexOf("#");[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]pw_server_coins = row.substring(12, pos);[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]bfr.close();[/COLOR]
[COLOR=#3F4549]if(request.getSession().getAttribute("items") == null)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]String[] items = new String[30001];[/COLOR]
[COLOR=#3F4549]try[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/default.dat")), "UTF8"));[/COLOR]
[COLOR=#3F4549]if(item_labels.compareTo("my") == 0)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/my.dat")), "UTF8"));[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]if(item_labels.compareTo("pwi") == 0)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/pwi.dat")), "UTF8"));[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]int count = 0;[/COLOR]
[COLOR=#3F4549]while((row = bfr.readLine()) != null && count < 30001)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]items[count] = row;[/COLOR]
[COLOR=#3F4549]count++;[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]bfr.close();[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]catch(Exception e)[/COLOR]
[COLOR=#3F4549]{[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]request.getSession().setAttribute("items", items);[/COLOR]
[COLOR=#3F4549]}[/COLOR]
[COLOR=#3F4549]%>[/COLOR]
 
Last edited by a moderator:
@khatvong0702 config:
Code:
String db_host = "localhost";
String db_port = "3306";
String db_user = "YOUR MYSQL USER";
String db_password = "YOUR MYSQL PASSWORD";
String db_database = "YOUR MYSQL DATABASE NAME";

Make sure you have role table in your perfect world database.
 
I'm really in trouble.

I can not create an account.
Roll table is not created.

Why is that?
I am able to connect to SQL (database).

And I get the following error when connecting.

-----catalina.out-----
Mar 6, 2014 11:21:28 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-openjdk-amd64/jre/lib/amd64/server:/usr/lib/jvm/java-6-openjdk-amd64/jre/lib/amd64:/usr/lib/jvm/java-6-openjdk-amd64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib/jni:/lib:/usr/lib
Mar 6, 2014 11:21:29 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Mar 6, 2014 11:21:29 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8089"]
Mar 6, 2014 11:21:29 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1306 ms
Mar 6, 2014 11:21:29 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Mar 6, 2014 11:21:29 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.19
Mar 6, 2014 11:21:29 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory pwAdmin
java.lang.NullPointerException
at com.goldhuman.Common.Conf.GetInstance(Conf.java:95)
at protocol.IwebVersionManager.<init>(IwebVersionManager.java:14)
at protocol.IwebVersionManager.<clinit>(IwebVersionManager.java:10)
at StartupServlet.init(StartupServlet.java:86)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1216)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1135)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
iweb.conf version=
iweb.conf update=,game=
iweb.conf comment=,buildDate=
java.lang.NullPointerException
at protocol.JioConfig.GetInstance(JioConfig.java:100)
at protocol.IwebVersionManager.<init>(IwebVersionManager.java:29)
at protocol.IwebVersionManager.<clinit>(IwebVersionManager.java:10)
at StartupServlet.init(StartupServlet.java:86)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1216)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1135)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
version.conf version=
version.conf update=,game=
version.conf comment=,buildDate=
iweb: 06 Mar 2014 23:21:30,789 INFO - iweb web service startup!
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@4b9ba20 activeio = com.goldhuman.IO.ActiveIO@3d6a8d4c
DeliveryClientManager reconnect
DeliveryClientManager::OnAbortSession com.goldhuman.IO.Protocol.Session@4b9ba20
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@e0b5509 activeio = com.goldhuman.IO.ActiveIO@9fbc913
ClientManager::OnAbortSession,peer=/127.0.0.1:29400
Mar 6, 2014 11:21:30 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory iweb
iweb.conf version=
iweb.conf update=,game=
iweb.conf comment=,buildDate=
version.conf version=20120611
version.conf update=20120611,game=w2i
version.conf comment=扈呎眠蜉蝮。蠅槫刈謗・蜿」,荳コ螳檎セ主嵜髯・圏鄒惹ソョ謾ケReport2GM・梧キサ蜉aid,line,com_roleid,com_rolename<p>User, GROleStatus,buildDate=20120628172616
javax.management.InstanceAlreadyExistsException: Counter:type=Protocol
at com.sun.jmx.mbeanserver.Repository.addMBean(Repository.java:467)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.internal_addObject(DefaultMBeanServerInterceptor.java:1519)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerDynamicMBean(DefaultMBeanServerInterceptor.java:985)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerObject(DefaultMBeanServerInterceptor.java:937)
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.registerMBean(DefaultMBeanServerInterceptor.java:330)
at com.sun.jmx.mbeanserver.JmxMBeanServer.registerMBean(JmxMBeanServer.java:526)
at com.goldhuman.Common.Counter.<init>(Counter.java:99)
at com.goldhuman.IO.Protocol.Protocol.<clinit>(Protocol.java:17)
at StartupServlet.init(StartupServlet.java:88)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1216)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1135)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
at java.util.concurrent.FutureTask.run(FutureTask.java:166)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:701)
iweb: 06 Mar 2014 23:21:32,261 INFO - iweb web service startup!
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@6a76000a activeio = com.goldhuman.IO.ActiveIO@68fcc720
DeliveryClientManager reconnect
DeliveryClientManager::OnAbortSession com.goldhuman.IO.Protocol.Session@6a76000a
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@744c2b5e activeio = com.goldhuman.IO.ActiveIO@34b363f8
ClientManager::OnAbortSession,peer=/127.0.0.1:29400
Mar 6, 2014 11:21:32 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Mar 6, 2014 11:21:32 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8089"]
Mar 6, 2014 11:21:32 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 3145 ms
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@36c51c9c activeio = com.goldhuman.IO.ActiveIO@46d961db
ClientManager::OnAbortSession,peer=/127.0.0.1:29400
java.net.ConnectException: Connection refused
at sun.nio.ch.SocketChannelImpl.checkConnect(Native Method)
at sun.nio.ch.SocketChannelImpl.finishConnect(SocketChannelImpl.java:601)
at com.goldhuman.IO.ActiveIO.Close(ActiveIO.java:39)
at com.goldhuman.IO.PollIO.Poll(PollIO.java:60)
at com.goldhuman.IO.Task.run(Task.java:13)
at com.goldhuman.Common.ThreadPool.run(ThreadPool.java:48)
at java.lang.Thread.run(Thread.java:701)
assoc_session = com.goldhuman.IO.Protocol.Session@6518ca7d activeio = com.goldhuman.IO.ActiveIO@3e960865
DeliveryClientManager reconnect
.........


-----catalina.2014-03-06.log-----
Mar 6, 2014 11:21:28 PM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/java-6-openjdk-amd64/jre/lib/amd64/server:/usr/lib/jvm/java-6-openjdk-amd64/jre/lib/amd64:/usr/lib/jvm/java-6-openjdk-amd64/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib/jni:/lib:/usr/lib
Mar 6, 2014 11:21:29 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["http-bio-8080"]
Mar 6, 2014 11:21:29 PM org.apache.coyote.AbstractProtocol init
INFO: Initializing ProtocolHandler ["ajp-bio-8089"]
Mar 6, 2014 11:21:29 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1306 ms
Mar 6, 2014 11:21:29 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Mar 6, 2014 11:21:29 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.19
Mar 6, 2014 11:21:29 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory pwAdmin
Mar 6, 2014 11:21:30 PM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory iweb
Mar 6, 2014 11:21:32 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Mar 6, 2014 11:21:32 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["ajp-bio-8089"]
Mar 6, 2014 11:21:32 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 3145 ms
 
Last edited:
hi guys

i have a problem , in CHARACTER INFO , PK mode is off , also online player list is emty :*: maybe like role some tabel missing in db , any solution for this ? i searched and nothing got to work for me

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

oh found something , i have to edit datebase info ( username and password ) also in addon's item in pwAdmin folders , but still didnt find any solution for PK mode
 
Last edited:
hi guys

i have a problem , in CHARACTER INFO , PK mode is off , also online player list is emty :*: maybe like role some tabel missing in db , any solution for this ? i searched and nothing got to work for me

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

oh found something , i have to edit datebase info ( username and password ) also in addon's item in pwAdmin folders , but still didnt find any solution for PK mode
maybe pariah_time?
 
there is no pariah_time is my db :( , what should i do ? or what info u need to i give ?

i tried to add PvP ranking and all of them shows 0 kill , i noticed in roles , pvp_time pvp_kills pvp_deads , all are 0 and those do not change by kill and die in game , any solution ? maybe i asked in wrong section my question ?
 
hi guys

i have a problem , in CHARACTER INFO , PK mode is off , also online player list is emty :*: maybe like role some tabel missing in db , any solution for this ? i searched and nothing got to work for me

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

oh found something , i have to edit datebase info ( username and password ) also in addon's item in pwAdmin folders , but still didnt find any solution for PK mode

 
Back