pwAdmin 151

**NanayaQ** · 14-03-14

Originally Posted by sora1984

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.

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.

**Regano** · 14-03-14

Thank You.

but.

Import after...
Synchronize GameDB with MySQL Role Table

white charackter page :(

**arturluiz007** · 14-03-14

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?

**fgru** · 14-03-14

Thanks I was missing that on the 151 release.

roles table not release content . its ONLY for pwadmin

Import after...
Synchronize GameDB with MySQL Role Table

white charackter page :(

maybe wrong java installed or any other similar problem ...

**Latyos** · 15-03-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 @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`
--

**Regano** · 15-03-14

Originally Posted by fgru

roles table not release content . its ONLY for pwadmin

maybe wrong java installed or any other similar problem ...

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.

**luckyjackz** · 15-03-14

anyone who knows how to learn / get all skill for any race / class ?

**sora1984** · 15-03-14

I've been adding the skills to the plugin will release when I'm done with it

**fgru** · 15-03-14

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 ...

**sora1984** · 15-03-14

It's not hard to find and add the skill hex I will do a quick guide when I'm home

**sora1984** · 15-03-14

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...

**luckyjackz** · 16-03-14

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

**fgru** · 16-03-14

omg ... xml ? pwadmin ? iweb ? u need more ?

i think it's more good when create char and then get all skills

and where do you get the skills ?

btw first time u need to read ALL pases like this

**sora1984** · 16-03-14

thats the problem these days, you show people how to do things and they still want it doing for them

**StrangerJr** · 17-03-14

Originally Posted by sora1984

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)

**sora1984** · 17-03-14

00000000 - progress (always 0 if not a craft)
i did wonder if that was the case just couldn't be fucked checking haha

thanks

**xpr013** · 19-03-14

Originally Posted by sora1984

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 */;

where did i put this? create new sql or what?

**argonaut** · 19-03-14

Originally Posted by xpr013

where did i put this? create new sql or what?

Import into 'pw' database.

**NanayaQ** · 19-03-14

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 #;

**khatvong0702** · 19-03-14

Please help me!
My PwAdmin cant doing it bot load

**fgru** · 19-03-14

omg !!! stupid, stupid, stupid ...

http://forum.ragezone.com/f751/pwadm...9/#post8010559

**khatvong0702** · 20-03-14

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);
}
%>

**NanayaQ** · 20-03-14

@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.

**Regano** · 21-03-14

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:

**fgru** · 21-03-14

spoiler tag plz !!!!

pwAdmin 151

Thread Tools

Search Thread

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Re: pwAdmin 151

Advertisement