pwAdmin 151

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 ?
 
Last edited:
oh maaaan, thanks all who helped me, now the PWAdmin work success...
qHscxHP - pwAdmin 151 - RaGEZONE Forums

But the Character Page is blank... what is the error ?
 
sora1984 said:
Urrg!! learn!!

cd to /

create a new file call it pwadmin.sh paste this into 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/"

save it.

Run it:

Code: 
chmod 755 pwadmin.sh
./pwadmin.sh
Click to expand...

Noob install for centos users also:

Code: 
cd /home
wget http://212.175.84.61/pwadmin/pwadmin.sh
chmod 755 pwadmin.sh
./pwadmin.sh

pwadmin.sh:

Code: 
#!/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"

btw works great thanks for release
 
Server Install.
http://forum.ragezone.com/f751/pw-server-files-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.

apt-get install openssh-server
apt-get install openjdk-7-jre

cd / home
wget
To view the content, you need to sign in or register

chmod 755 pwadmin.sh
. / pwadmin.sh
Click to expand...
after

i Edit /var/lib/tomcat7/webapps/pwAdmin/WEB-INF/.pwadminconf.jsp for admin password

To view the content, you need to sign in or register


To view the content, you need to sign in or register


To view the content, you need to sign in or register


To view the content, you need to sign in or register



To view the content, you need to sign in or register
 
Last edited:
Regano said:
Server Install.
http://forum.ragezone.com/f751/pw-server-files-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.


after

i Edit /var/lib/tomcat7/webapps/pwAdmin/WEB-INF/.pwadminconf.jsp for admin password

To view the content, you need to sign in or register


To view the content, you need to sign in or register


To view the content, you need to sign in or register


To view the content, you need to sign in or register



To view the content, you need to sign in or register
Click to expand...

did u edit .pwadminconf.jsp for your database name, password etc?
 
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 */;
 
sora1984 said:
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 */;
Click to expand...

Thanks I was missing that on the 151 release.

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.
 
Last edited:
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?
 
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 [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 `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`
--
 
fgru said:
roles table not release content . its ONLY for pwadmin



maybe wrong java installed or any other similar problem ...
Click to expand...

roles is supposed to be automatically generated by the pwadmin?
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.
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,503
Guests online
7,275
Total visitors
9,778
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back