Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

pwAdmin 151

sora1984

sora1984

Skilled Illusionist
10 Happy Years
Joined
Feb 2, 2011
Messages
382
Reaction score
200
sick of typing this....
.pwadminconf.jsp

it all works..........

hashed passwords in account don't use base 64 but who cares...
 
The Best DDoS Protected Servers
R

Regano

Newbie Spellweaver
Joined
Feb 21, 2012
Messages
94
Reaction score
14
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:
L

luckyjackz

Newbie Spellweaver
Joined
Sep 6, 2012
Messages
47
Reaction score
0
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 ?
 

Attachments

You must be registered for see attachments list
Latyos

Latyos

Junior Spellweaver
Joined
Jul 8, 2011
Messages
116
Reaction score
14
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
 
R

Regano

Newbie Spellweaver
Joined
Feb 21, 2012
Messages
94
Reaction score
14
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
You must be registered to see links

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

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

You must be registered to see links


You must be registered to see links


You must be registered to see links


You must be registered to see links



You must be registered to see links
 
Last edited:
Latyos

Latyos

Junior Spellweaver
Joined
Jul 8, 2011
Messages
116
Reaction score
14
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

You must be registered to see links


You must be registered to see links


You must be registered to see links


You must be registered to see links



You must be registered to see links
Click to expand...

did u edit .pwadminconf.jsp for your database name, password etc?
 
sora1984

sora1984

Skilled Illusionist
10 Happy Years
Joined
Feb 2, 2011
Messages
382
Reaction score
200
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 */;
 
NanayaQ

NanayaQ

QuoteShiek Member
500 Posts 10 Happy Years
Joined
Jul 2, 2012
Messages
790
Reaction score
125
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:
R

Regano

Newbie Spellweaver
Joined
Feb 21, 2012
Messages
94
Reaction score
14
Thank You.

but.

Import after...
Synchronize GameDB with MySQL Role Table

white charackter page :(
 
A

arturluiz007

Newbie Spellweaver
Joined
Jun 14, 2009
Messages
26
Reaction score
3
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?
 
Latyos

Latyos

Junior Spellweaver
Joined
Jul 8, 2011
Messages
116
Reaction score
14
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`
--
 
R

Regano

Newbie Spellweaver
Joined
Feb 21, 2012
Messages
94
Reaction score
14
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.
 
L

luckyjackz

Newbie Spellweaver
Joined
Sep 6, 2012
Messages
47
Reaction score
0
anyone who knows how to learn / get all skill for any race / class ?
 
fgru

fgru

RaGEZONER
Loyal Member
1000 Posts 10 Happy Years
Joined
Sep 29, 2009
Messages
1,565
Reaction score
321
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 ...
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
193
Guests online
6,242
Total visitors
6,435
Totals may include hidden visitors.

Forum statistics

Threads
429,034
Messages
4,589,968
Members
280,375
Latest member
Maelit0
Most visitors online was 8830 , on 6 Feb 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top