based off @DaMadBoy fixed 148 and @Bola iweb 151
this pwAdmin works with xml, import charater to db ect ect
edit the configs in
/pwAdmin/WEB-INF/.pwadminconf.jsp
https://mega.co.nz/#!uk4FHK6Q!gVinTV...bOmefeqoC1zNCs
Printable View
based off @DaMadBoy fixed 148 and @Bola iweb 151
this pwAdmin works with xml, import charater to db ect ect
edit the configs in
/pwAdmin/WEB-INF/.pwadminconf.jsp
https://mega.co.nz/#!uk4FHK6Q!gVinTV...bOmefeqoC1zNCs
i have been waiting for this thankssora sama :)
Do you have working iweb? my iweb load char xml not correct
hereQuote:
Originally Posted by letanduy
http://forum.ragezone.com/f753/help-...ml#post8008352
do not forget set /etc/iweb.conf with the same configs of /PWServer/gdeliveryd/gamesys.conf
Thanks Mr: Bola your iweb with save xml work i can now save xml using tomcat7 tyvm :):
I hope someone make pwAdmin full function like save xml char and other i like pwAdmin style
updated OP with new link to cleaned up version, start server starts "world map" & "origination"
hi
my iweb works character creation and alot of things but i cant start any map .
i cant log on pwAdmin i tryed Pass: root /change pass ,, but nothing heapens
someone can help me please
if pwadmin not work try the startscript of your server
tested it on a couple of servers works fine check, nothings changed from the old iweb apart from protocols
/pwAdmin/WEB-INF/.pwadminconf.jsp
that the info matches that of your SQL and SERVER
server start work perfect with tomcat / jarkata from bola ...
did it also start is62 for you?
but login failed xD gs and 62 are running xD
- - - Updated - - -
after stop 62 login possible xD
pwAdmin login or game login?
- - - Updated - - -
thats strange haha i'll have a poke around lol
game login ... but thats crazy xD
server start = ok / login to world = ok / go to primal world ( is62 ) = cant enter [ take quest and end quest for same time ] / create a new char and login = enter is62 oO oO oO
- - - Updated - - -
start all with startscript = all ok / all enter
primal world is is63 !! Starter town is is62 are you getting mixed up?
i know .. i restart the vm i think its vm / memory problem
- - - Updated - - -
all ok was a vm / memory problem btw in my post i mean 63 ... sorry ...
that's that problem solved haha :thumbup1:
- - - Updated - - -
I hardly use pwAdmin I start my server using a bash script I wrote haha
https://dl.dropboxusercontent.com/u/...6/adminpan.png
can you share it sora? I mean the bash script you used :w00t:
Possibly when I'm 100% happy with it... got a few ideas for it just to try and implement them haha
nice script sora :drool:
Thanks !
where should i put this pwAdmin Folder at ubuntu ?
- - - Updated - - -
My Error is like this :
http://i.imgur.com/Q37GgKq.png
Can You Help me ?
if u have read post #10 and if error again let us know ur os / tomcat repo install or manuall copied from other location
I am very newbie for PW Server / Linux...
by the way, sorry I did not mean to blog promotion
i download the server from this blogspot : http://tuan565.blogspot.com/2014/03/...-151-v101.html
this is the download link for the server : https://drive.google.com/folderview?...1U&usp=sharing
If you want to help me, you can PM me ya, hehehe
Urrg!! learn!!
cd to /
create a new file call it pwadmin.sh paste this into it:
save it.Code:#!/bin/bash
#noob installer lol
ip=`/sbin/ifconfig|grep inet|head -1|sed 's/\:/ /'|awk '{print $3}'`
apt-get install -y unzip tomcat7
cd var/lib/tomcat7/webapps/
service tomcat7 stop
wget https://dl.dropboxusercontent.com/u/19918926/pwadmin1.5.1.zip
unzip -o pwadmin1.5.1.zip
service tomcat7 start
echo ""
echo "Open your browser and go to http://"$ip":8080/pwAdmin/"
Run it:
Code:chmod 755 pwadmin.sh
./pwadmin.sh
Hey @sora1984 its cool everything working good just a doubt though . Although i am not sure if its my server setup thats wrong or pwiadmin not working ..
Using the live chat i am able to send chat to game i know it calls a function for sending broadcast and decodes the world2.chat file to see other players chat ..
My case i am Using MrKiller's release of server files and all the services are running but I am not seeing the world2.chat file with other chat apart form the one's i send from Live chat plugin .
Any directions here ?
Thanks
Off the top of my head what logs you get depends on the gamesys.conf of logservice
- - - Updated - - -
my gamesys.conf
if that helps anyCode:[LogserviceServer]
type = udp
port = 11100
address = 127.0.0.1
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 2097152
obuffermax = 16384
tcp_nodelay = 0
listen_backlog = 10
accumulate = 2097152
[LogserviceTcpServer]
type = tcp
port = 11101
address = 127.0.0.1
so_sndbuf = 65536
so_rcvbuf = 65536
ibuffermax = 2097152
obuffermax = 16384
tcp_nodelay = 0
listen_backlog = 10
accumulate = 2097152
[logservice]
threshhold = LOG_DEBUG
fd_err = /home/logs/world2.err
fd_log = /home/logs/world2.log
fd_formatlog = /home/logs/world2.formatlog
fd_trace = /home/logs/world2.trace
fd_chat = /home/logs/world2.chat
fd_cash = /home/logs/world2.cash
fd_statinfom = /home/logs/statinfom
fd_statinfoh = /home/logs/statinfoh
fd_statinfod = /home/logs/statinfod
[ThreadPool]
threads = (0,1)(1,5)
max_queuesize = 1048576
Quote:
Originally Posted by sora1984
This is mine .... btw its logservice.conf right ?Code:[LogserviceServer]
type = udp
port = 11100
address = 127.0.0.1
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 2097152
obuffermax = 16384
tcp_nodelay = 0
listen_backlog = 10
accumulate = 2097152
[LogserviceTcpServer]
type = tcp
port = 11101
address = 127.0.0.1
so_sndbuf = 16384
so_rcvbuf = 16384
ibuffermax = 2097152
obuffermax = 16384
tcp_nodelay = 0
listen_backlog = 10
accumulate = 2097152
[logservice]
threshhold = LOG_DEBUG
fd_err = ./logs/world2.err
fd_log = ./logs/world2.log
fd_formatlog = ./logs/world2.formatlog
fd_trace = ./logs/world2.trace
fd_chat = ./logs/world2.chat
fd_cash = ./logs/world2.cash
fd_statinfom = ./logs/statinfom
fd_statinfoh = ./logs/statinfoh
fd_statinfod = ./logs/statinfod
[ThreadPool]
threads = (0,1)(1,5)
max_queuesize = 1048576
- - - Updated - - -
Thanks @sora1984 i thought initially that ./logs mean parent directory but just changed it to /home/logs its working fine . thanks for the tip .
Thx @sora1984Quote:
Originally Posted by sora1984
But This is a new error again :
http://i.imgur.com/yjb8F2r.png
I hope you want help me again, hehehe..,
??
java -version
My Java Version :
http://i.imgur.com/AR7vSDy.png
If It's too low, how to update that ? Thx Again
my server runs Ubuntu 12.04.4 LTS (GNU/Linux 3.8.0-36-generic x86_64)
java version "1.6.0_30"
OpenJDK Runtime Environment (IcedTea6 1.13.1) (6b30-1.13.1-1ubuntu2~0.12.04.1)
OpenJDK 64-Bit Server VM (build 23.25-b01, mixed mode)
apt-get install openjdk-6-jre
jarkata tomcat
try this version [ includes working iweb ] > copy it to any location on your server > go to anyplaceonyourserver/bin/startup.sh [ i.e. /home/tomcat/bin/startup.sh ]
pwAmin
try this release and copy it to anyplaceonyourserver/webapps/ [ i.e. /home/tomcat/webapps ]
go to your brower yourserverip:8080/paAdmin
i hope it help all ...
jarkata ? tomcat ? > http://en.wikipedia.org/wiki/Apache_Tomcat > Apache Tomcat (or simply Tomcat, formerly also Jakarta Tomcat)
ive always used java 7
apt-get install openjdk-7-jre
- - - Updated - - -
@fgru
if he used the installer i made before he has tomcat7
tested and works so java version could be issue
ok all it's opened at my browser... thanks :D
but the PWadmin is blank like this :
http://i.imgur.com/jFUKaUG.png
And my iweb : Failed to get role info from the database, maybe this role didn't exist or access timed out.Please try again.
I think my settings / my config are wrong / error...
So, how do i repaired it ?
/pwAdmin/WEB-INF/
.pwadminconf.jsp
edit that file
when i open login.jsp :
http://i.imgur.com/BsCz1eS.png
Are this :
String pw_server_exp = "?";
String pw_server_sp = "?";
String pw_server_drop = "?";
String pw_server_coins = "?";
Must be edited too ?
example please ? and i don't know the database name -_-
@luckyjackz Read what it says under "java.io.FileNotFoundException" and it will tell you what to do.
so what i have to do ? i hope you want help me step by step, i am very newbie for this things T.TQuote:
Originally Posted by Expedition
It can't be much more obvious, try to actually READ the error, instead of panicing and clogging up these forums with another useless post.Quote:
Originally Posted by luckyjackz
Cheers
sorry.
ACCOUNT REGISTRATION and SERVER CONFIGURATION and Character edit.
notwork.
why?
sick of typing this....
.pwadminconf.jsp
it all works..........
hashed passwords in account don't use base 64 but who cares...
i changed .pwadminconf.jsp
String iweb_password
and
String db_password
What I have changed This is the only.
not work accounts and Serversettings... :(
sora1984 work ACCOUNT REGISTRATION ?
oh maaaan, thanks all who helped me, now the PWAdmin work success...
http://i.imgur.com/qHscxHP.png
But the Character Page is blank... what is the error ?
click sync with db....
Noob install for centos users also:Quote:
Originally Posted by sora1984
pwadmin.sh:Code:cd /home
wget http://212.175.84.61/pwadmin/pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh
btw works great thanks for releaseCode:#!/bin/bash
#noob install pwadmin for centos
ip=`/sbin/ifconfig|grep inet|head -1|sed 's/\:/ /'|awk '{print $3}'`
cd /var/lib
wget http://www.eu.apache.org/dist/tomcat/tomcat-7/v7.0.52/bin/apache-tomcat-7.0.52.tar.gz
tar xzf apache-tomcat-7.0.52.tar.gz
mv /var/lib/apache-tomcat-7.0.52 /var/lib/tomcat7
cd /var/lib/tomcat7/webapps/
wget https://dl.dropboxusercontent.com/u/19918926/pwadmin1.5.1.zip
unzip -o pwadmin1.5.1.zip
cd /var/lib/tomcat7/bin/
./startup.sh
echo "Install done"
echo "Open your browser and go to http://"$ip":8080/pwAdmin/"
echo "Edit /var/lib/tomcat7/webapps/pwAdmin/WEB-INF/.pwadminconf.jsp for admin password"
echo "Default admin password is "root"
Server Install.
http://forum.ragezone.com/f751/pw-se...-1-5-a-989364/
OS
ubuntu-12.04.4-server-amd64.iso
".3.4 Execute commands:" After I have run up, you run the following command.
afterQuote:
apt-get install openssh-server
apt-get install openjdk-7-jre
cd / home
wget http://212.175.84.61/pwadmin/pwadmin.sh
chmod 755 pwadmin.sh
. / pwadmin.sh
i Edit /var/lib/tomcat7/webapps/pwAdmin/WEB-INF/.pwadminconf.jsp for admin password
http://s17.postimg.org/fmxzc9mwf/addusr.jpg
http://s17.postimg.org/bcjbgohtb/char.jpg
http://s17.postimg.org/84a8pw65r/svrconf.jpg
http://s17.postimg.org/h39hueptb/svrcont.jpg
screenshot windows
did u edit .pwadminconf.jsp for your database name, password etc?Quote:
Originally Posted by Regano
white charackter page > roles table are missing ...
Quote:
Originally Posted by Latyos
yes. :(Quote:
Originally Posted by fgru
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 @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @old_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 @old_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS @old_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION @old_COLLATION_CONNECTION */;
Thanks I was missing that on the 151 release.Quote:
Originally Posted by sora1984
also if you guys run mysql version 5+
change /*!.........*/ to #
P.S
I also have problem with Creating/Change/Delete Account dunno if it suppose to work or not but It kept saying not connected to mysql so far
Gamemaster/Cubi Transfer works fine and it also show my account on the Account Browser.
Thank You.
but.
Import after...
Synchronize GameDB with MySQL Role Table
white charackter page :(
sora1984, maps aren't loading properly through pwAdmin, they just don't load.
But if I execute iweb_map.sh from my ssh console it start just fine.
I suppose that it need root permission, do you know how can I give it these permissions?
roles table not release content . its ONLY for pwadminQuote:
Thanks I was missing that on the 151 release.
maybe wrong java installed or any other similar problem ...Quote:
Import after...
Synchronize GameDB with MySQL Role Table
white charackter page :(
If somebody needs, this is my db structrue which working with pwadmin and 1.5.1 auth.
Code:-- phpMyAdmin SQL Dump
-- version 3.3.5.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 15, 2014 at 01:33 AM
-- Server version: 5.0.95
-- PHP Version: 5.3.3
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @old_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `pw`
--
-- --------------------------------------------------------
--
-- Table structure for table `auth`
--
CREATE TABLE IF NOT EXISTS `auth` (
`userid` int(11) NOT NULL default '0',
`zoneid` int(11) NOT NULL default '0',
`rid` int(11) NOT NULL default '0',
PRIMARY KEY (`userid`,`zoneid`,`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `auth`
--
INSERT INTO `auth` (`userid`, `zoneid`, `rid`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `forbid`
--
CREATE TABLE IF NOT EXISTS `forbid` (
`userid` int(11) NOT NULL default '0',
`type` int(11) NOT NULL default '0',
`ctime` datetime NOT NULL,
`forbid_time` int(11) NOT NULL default '0',
`reason` blob NOT NULL,
`gmroleid` int(11) default '0',
PRIMARY KEY (`userid`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `forbid`
--
-- --------------------------------------------------------
--
-- Table structure for table `iplimit`
--
CREATE TABLE IF NOT EXISTS `iplimit` (
`uid` int(11) NOT NULL default '0',
`ipaddr1` int(11) default '0',
`ipmask1` varchar(2) default '',
`ipaddr2` int(11) default '0',
`ipmask2` varchar(2) default '',
`ipaddr3` int(11) default '0',
`ipmask3` varchar(2) default '',
`enable` char(1) default '',
`lockstatus` char(1) default '',
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `iplimit`
--
-- --------------------------------------------------------
--
-- Table structure for table `online`
--
CREATE TABLE IF NOT EXISTS `online` (
`ID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `online`
--
-- --------------------------------------------------------
--
-- Table structure for table `point`
--
CREATE TABLE IF NOT EXISTS `point` (
`uid` int(11) NOT NULL default '0',
`aid` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`zoneid` int(11) default '0',
`zonelocalid` int(11) default '0',
`accountstart` datetime default NULL,
`lastlogin` datetime default NULL,
`enddate` datetime default NULL,
PRIMARY KEY (`uid`,`aid`),
KEY `IX_point_aidzoneid` (`aid`,`zoneid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `point`
--
INSERT INTO `point` (`uid`, `aid`, `time`, `zoneid`, `zonelocalid`, `accountstart`, `lastlogin`, `enddate`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `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;
--
-- Dumping data for table `roles`
--
INSERT INTO `roles` (`account_id`, `role_id`, `role_name`, `role_level`, `role_race`, `role_occupation`, `role_gender`, `role_spouse`, `faction_id`, `faction_name`, `faction_level`, `faction_domains`, `role_faction_rank`, `pvp_time`, `pvp_kills`, `pvp_deads`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `usecashlog`
--
CREATE TABLE IF NOT EXISTS `usecashlog` (
`userid` int(11) NOT NULL default '0',
`zoneid` int(11) NOT NULL default '0',
`sn` int(11) NOT NULL default '0',
`aid` int(11) NOT NULL default '0',
`point` int(11) NOT NULL default '0',
`cash` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`creatime` datetime NOT NULL,
`fintime` datetime NOT NULL,
KEY `IX_usecashlog_creatime` (`creatime`),
KEY `IX_usecashlog_uzs` (`userid`,`zoneid`,`sn`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `usecashlog`
--
-- --------------------------------------------------------
--
-- Table structure for table `usecashnow`
--
CREATE TABLE IF NOT EXISTS `usecashnow` (
`userid` int(11) NOT NULL default '0',
`zoneid` int(11) NOT NULL default '0',
`sn` int(11) NOT NULL default '0',
`aid` int(11) NOT NULL default '0',
`point` int(11) NOT NULL default '0',
`cash` int(11) NOT NULL default '0',
`status` int(11) NOT NULL default '0',
`creatime` datetime NOT NULL,
PRIMARY KEY (`userid`,`zoneid`,`sn`),
KEY `IX_usecashnow_creatime` (`creatime`),
KEY `IX_usecashnow_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `usecashnow`
--
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`ID` int(11) NOT NULL default '0',
`name` varchar(32) NOT NULL default '',
`passwd` varchar(64) NOT NULL,
`Prompt` varchar(32) NOT NULL default '',
`answer` varchar(32) NOT NULL default '',
`truename` varchar(32) NOT NULL default '',
`idnumber` varchar(32) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`mobilenumber` varchar(32) default '',
`province` varchar(32) default '',
`city` varchar(32) default '',
`phonenumber` varchar(32) default '',
`address` varchar(64) default '',
`postalcode` varchar(8) default '',
`gender` int(11) default '0',
`birthday` datetime default NULL,
`creatime` datetime NOT NULL,
`qq` varchar(32) default '',
`passwd2` varchar(64) default NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `IX_users_name` (`name`),
KEY `IX_users_creatime` (`creatime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`ID`, `name`, `passwd`, `Prompt`, `answer`, `truename`, `idnumber`, `email`, `mobilenumber`, `province`, `city`, `phonenumber`, `address`, `postalcode`, `gender`, `birthday`, `creatime`, `qq`, `passwd2`) VALUES
-- --------------------------------------------------------
--
-- Table structure for table `uwebplayers`
--
CREATE TABLE IF NOT EXISTS `uwebplayers` (
`roleid` int(11) NOT NULL,
`rolename` varchar(50) default NULL,
`rolelevel` int(11) default NULL,
`rolestatus` int(11) default NULL,
`rolegender` int(11) default NULL,
`roleprof` bigint(20) default NULL,
`rolerep` bigint(20) default NULL,
`redname` bigint(20) default NULL,
`rednametime` bigint(20) default NULL,
`pinknametime` bigint(20) default NULL,
PRIMARY KEY (`roleid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `uwebplayers`
--
roles is supposed to be automatically generated by the pwadmin?Quote:
Originally Posted by fgru
It has been automatically generated in ¤ The Complete PW Package ¤.
What people are working properly do you have installed?
I have installed openjdk-7-jre.
View of character and adding accounts, editing,
And server setting does not work correctly.
¤ The Complete PW Package ¤ (1.3.6)
In both were working properly.
I'm really in trouble.
anyone who knows how to learn / get all skill for any race / class ?
I've been adding the skills to the plugin will release when I'm done with it
thx sora
for any1 that cant wait:
create a char > get all skills > go to iweb > copy all from section skills for future actions
but i thinks many ppl are too lazy to do this ...
It's not hard to find and add the skill hex I will do a quick guide when I'm home
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...
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:
omg ... xml ? pwadmin ? iweb ? u need more ?
and where do you get the skills ?Quote:
i think it's more good when create char and then get all skills
btw first time u need to read ALL pases like this
thats the problem these days, you show people how to do things and they still want it doing for them
skills - 0100000001000000000000000a000000Quote:
Originally Posted by sora1984
01000000 - count
skill 1: 01000000000000000a000000
- 01000000 - id
- 00000000 - progress (always 0 if not a craft)
- 0a000000 - level (from 1 to 10)
00000000 - progress (always 0 if not a craft)
i did wonder if that was the case just couldn't be fucked checking haha
thanks
where did i put this? create new sql or what?Quote:
Originally Posted by sora1984
Import into 'pw' database.Quote:
Originally Posted by xpr013
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 @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT #;
#40101 SET @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS #;
#40101 SET @old_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 @old_CHARACTER_SET_CLIENT #;
#40101 SET CHARACTER_SET_RESULTS @old_CHARACTER_SET_RESULTS #;
#40101 SET COLLATION_CONNECTION @old_COLLATION_CONNECTION #;
Please help me!
My PwAdmin cant doing it bot load
http://a.disquscdn.com/uploads/media...9/original.jpg
omg !!! stupid, stupid, stupid ...
http://forum.ragezone.com/f751/pwadm...9/#post8010559
But how edit?
i dont know how changer
Code:<%@page import="java.io.*"%>
<%
//-------------------------------------------------------------------------------------------------------------------------
//------------------------------- SETTINGS --------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------
// pwadmin access password as md5 encrypted string
// default password is root -> 63a9f0ea7bb98050796b649e85481845
String iweb_password = "63a9f0ea7bb98050796b649e85481845";
// connection settings to the mysql pw database
String db_host = "localhost";
String db_port = "3306";
String db_user = "root";
String db_password = "root";
String db_database = "pw";
// Type of your items database required for mapping id's to names
// Options are my or pwi
String item_labels = "pwi";
// Absolute path to your PW-Server main directory (startscript, stopscript, /gamed)
// requires a tailing slash
String pw_server_path = "/home/";
// If you have hundreds of characters or heavy web acces through this site
// It is recommend to turn the realtime character list feature off (false)
// to prevent server from overload injected by character list generation
boolean enable_character_list = true;
String pw_server_name = "Perfect World";
String pw_server_description = "Fixed by DaMadBoy, 151 iweb from Bola, Merged by Sora1984";
//-------------------------------------------------------------------------------------------------------------------------
//----------------------------- END SETTINGS ------------------------------------------------------------------------------
//-------------------------------------------------------------------------------------------------------------------------
String pw_server_exp = "?";
String pw_server_sp = "?";
String pw_server_drop = "?";
String pw_server_coins = "?";
BufferedReader bfr = new BufferedReader(new FileReader(pw_server_path + "gamed/ptemplate.conf"));
String row;
while((row = bfr.readLine()) != null)
{
row = row.replaceAll("\\s", "");
if(row.indexOf("exp_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_exp = row.substring(10, pos);
}
if(row.indexOf("sp_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_sp = row.substring(9, pos);
}
if(row.indexOf("drop_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_drop = row.substring(11, pos);
}
if(row.indexOf("money_bonus=") != -1)
{
int pos = row.length();
if(row.indexOf("#") != -1)
{
pos = row.indexOf("#");
}
pw_server_coins = row.substring(12, pos);
}
}
bfr.close();
if(request.getSession().getAttribute("items") == null)
{
String[] items = new String[30001];
try
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/default.dat")), "UTF8"));
if(item_labels.compareTo("my") == 0)
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/my.dat")), "UTF8"));
}
if(item_labels.compareTo("pwi") == 0)
{
bfr = new BufferedReader(new InputStreamReader(new FileInputStream(new File(request.getRealPath("/include/items") + "/pwi.dat")), "UTF8"));
}
int count = 0;
while((row = bfr.readLine()) != null && count < 30001)
{
items[count] = row;
count++;
}
bfr.close();
}
catch(Exception e)
{
}
request.getSession().setAttribute("items", items);
}
%>
@khatvong0702 config:
Make sure you have role table in your perfect world database.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";
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-----
Spoiler:
.........
-----catalina.2014-03-06.log-----
Spoiler:
spoiler tag plz !!!!
sorry.
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?Quote:
Originally Posted by gebryas
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 ?
Answer hereQuote:
Originally Posted by gebryas
Quote:
Originally Posted by sora1984
Mr sora, in this pwAdmin ¿work the function "import role to mysql db"? on character tab
I tested it slightly and get "Roles Imported to MySQL Table" but no players on my role table
http://imageshack.com/a/img46/89/rgyq.jpg
Iam asking because maybe im doing something wrong or need add some steps on the editing of the web
Thank you for your time!
Regards
@elche27 you see that recycle arrow icon near Player, click on that and *BAAM* magic.
Hello mr NanayaQ, yes, the pic is after i clicked on that icon XDQuote:
Originally Posted by NanayaQ
That is why iam asking if is working or im doing something wrong on installation.
Thank you for ur reply.
Edited:
I was doing something wrong...it is working
http://imageshack.com/a/img27/1439/02ap.jpg
Anyone know if addon are working? Because for example on getgold ask me a user and pass but when i enter it, nothing happens
Regards!
i did all i got in search but the rank page didnt work on 1.5.1 , i have to say again in role tabel in db pvp_kills pvp_deads are 0 and dont change with killing or death ? cuz these are 0 the ranking shows for all ppl 0 killing , bt what is sultion for this ?Quote:
Originally Posted by argonaut
:lol:
- - - Updated - - -
i noticed for some player pk mode is on and some other is off but all are in pk mode in game , i'm :dontknow::hmmmm2:Quote:
Originally Posted by StrangerJr
Everything works clear on this else than the char editor shows blank page. Any soloution?
Pwadmin :- http://postimg.org/image/70fd22nbn/
Conf:- http://postimg.org/image/3savp111v/
maybe you don't have the role database...Quote:
Originally Posted by NoName123456
I dont but How should I edit it? please tell me n.n
Originally Posted by sora1984 .
Spoiler:
1.open phpMyadmin
2.select "pw" databasename
3.Click SQL TAB
copy and Paste this
Code:
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;
weeeeew thanks alot bro it worked :))
- - - Updated - - -
But It keeps loading and dont open anychar
- - - Updated - - -
And when I type my char Id it shows a blank page
Me, too.
---Console---
gamedbd: debug : GetUserRoles, userid=1024
Whats the fix for this? when I edit my acc culti it keeps loading and it doesnt end/edit it.
Anyhelp?
Good Night Mr Sora,Quote:
Originally Posted by sora1984
Sorry for bother you but i am having some issue with addon's tab. My first problem is i cant log an account. My problem is on login.jsp, more specific on the code of this function:
Could you share your code? Since i am not good on jsp i dont know how to use thisCode:String pw_encode(String salt, MessageDigest alg)
{
alg.reset();
alg.update(salt.getBytes());
byte[] digest = alg.digest();
StringBuffer hashedpasswd = new StringBuffer();
String hx;
for(int i=0; i<digest.length; i++)
{
hx = Integer.toHexString(0xFF & digest[i]);
//0x03 is equal to 0x3, but we need 0x03 for our md5sum
if(hx.length() == 1)
{
hx = "0" + hx;
}
hashedpasswd.append(hx);
}
salt = "0x" + hashedpasswd.toString();
return salt;
}
.Code:base64_encode(md5($user.$pass, true));
My second problem is:
I managed to make work "GET GOLD ADDON" on a char BUT with a GM account
http://imageshack.com/a/img834/3778/xuwi.jpg
When i try with a normal account, i cant make it work, dont know why
http://imageshack.com/a/img59/2114/wyq2.jpg
Even more, i used same method as GM account and work on other addon like GET ITEM like you can see here
http://imageshack.com/a/img27/553/urv9.jpg
Any clue why? Thank you in advance!
Regards
Thank You Mr Regano for your answer but i replaced your index,jsp and get an errorQuote:
Originally Posted by Regano
http://sia1.subirimagenes.net/img/20...4902743513.jpg
And iif i use the code on login.jsp, i get error too
But you gave me some ideas...ill try to resolve it...thank you!Quote:
String pw_encode(String salt, MessageDigest alg)
{
alg.reset();
alg.update(salt.getBytes());
byte[] digest = alg.digest();
return Base64Util.encode(digest);
}
Please copy and overwrite all of the target folder.
No need Mr Regano XD!Quote:
Originally Posted by Regano
Just need to do this change on login.jsp
And put your Base64Util.class on /WEB-INF/classes/org/seasar/framework/util/Base64Util.class or overwrite the folder class hehe, sry for explain with apple and banana but not all have the skill to know.Code:<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page import="java.security.*"%>
<%@page import="org.seasar.framework.util.Base64Util"%>
<%@include file="../../WEB-INF/.pwadminconf.jsp"%>
<%!
String pw_encode(String salt, MessageDigest alg)
{
alg.reset();
alg.update(salt.getBytes());
byte[] digest = alg.digest();
String passCod = Base64Util.encode(digest);
return passCod;
}
%>
That is all! Work to me!
http://sia1.subirimagenes.net/img/20...2730857299.jpg
Thank to you Mr Regano, i could fix this problem. Regards!
Guys, thanks verry mutch for the tips, but they dont works for me!!!
First, i accesed http://192.168.200.100:8080/pwAdmin/ and i got this:
http://i.epvpimg.com/8ZeBe.png
Now, after i got the error, i was looking in the thread to find a fix, and i found this:
And so i did, i went to /<root> and pasted the file "pwadmin.sh" (i also saved it on root dir, just in case!)Quote:
Originally Posted by sora1984
http://i.epvpimg.com/8GoAc.png
And now, i`m try to run it, first time i used "chmod 755 pwadmin.sh" and second "./pwadmin.sh" but it seem that non of them work! And i`m kinda blocked here, and dont know what do to next\1
http://i.epvpimg.com/w7AQe.png
if you made the file on Crapdows then do:
cd /
apt-get install tofrodos
fromdos pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh
Also the ~# means the current users folder! eg. "/root" not root dir "/"
if you ever need to know the exact directory you are in then use pwd
basic unix knowledge is a must!!
Can you have a look please, i always have problems when i use command "apt-get install or update"Quote:
Originally Posted by sora1984
http://i.epvpimg.com/xLZAe.png
http://i.epvpimg.com/vluBb.png
i use your tips for get item and get gold. After i change that login.jsp and copy base64, when i try to login to pwAdmin, it can't login...Quote:
Originally Posted by elche27