¤ The Complete PW Package ¤

[Caosfox]

you need to enable debug mode at ptemplate file inside gamedb folder
next create a .bat file and put inside this
elementclient.exe game:cpw console:1
put the bat file in the same place where elementclient.exe is
run the bat file (it loads the game and you can login)

press shift + ~ inside game to open gm console ( is not the same console as ctrl + g )
then you must type that gm commands

[lordmegamanx72]

yea i did shift + ~ i just searched and did what was in this link http://forum.ragezone.com/f746/guide...tivate-958011/
and it fails

[Indelible]

yea i did shift + ~ i just searched and did what was in this link http://forum.ragezone.com/f746/guide...tivate-958011/
and it fails

Helps if you not using GM commands from Allods Online.

Try searching google for: d_c2scmd for examples

[lordmegamanx72]

now new problem getting dcs
when i use these codes

[Teemo Cell]

My first account have the ID 1024. On 1.3.6. server are the first account 32 and not 1024. Waste of time this Release

[Caosfox]

what about cleaning the db?

- - - Updated - - -

and true, use only perfect world cheat codes... not any game cheat codes
all gm commands are in that excel file at pw_dev.iso

- - - Updated - - -

and remember to enable debug mode at server side (normal mode = no gm "cheat" works)

[bojangle78]

Is there a way to uninstall everything from the ubuntu server so I can reinstall? My databases are messed up or something because its not letting me create characters. Anyone?

[lordmegamanx72]

yea there is way
if i were you i would go to pwAdmin delete the characters then delete the accounts then go to phpmyadmin and select the data base you created such like pw and choose operations drop data base and go
then go to database the icon that seem like house and click on mysql section
and past this there and click on go

CREATE DATABASE pw CHARACTER SET utf8 COLLATE utf8_general_ci;
use pw;

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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;

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;

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;

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;

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;

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;


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;

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;

DELIMITER $$
CREATE PROCEDURE `acquireuserpasswd`(in name1 VARCHAR(64), out uid1 INTEGER, out passwd1 VARCHAR(64))
BEGIN
SELECT id, passwd INTO uid1, passwd1 FROM users WHERE name = name1;
END$$

CREATE PROCEDURE `addForbid`(in userid1 INTEGER, in type1 INTEGER, in forbid_time1 INTEGER, in reason1 BINARY(255), in gmroleid1 INTEGER)
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE forbid SET ctime = now(), forbid_time = forbid_time1, reason = reason1, gmroleid = gmroleid1 WHERE userid = userid1 AND type = type1;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
INSERT INTO forbid VALUES(userid1, type1, now(), forbid_time1, reason1, gmroleid);
END IF;
COMMIT;
END$$

CREATE PROCEDURE `addGM`(in userid INTEGER, in zoneid INTEGER)
BEGIN
DECLARE x INTEGER;
START TRANSACTION;
SET x = 0;
WHILE x < 12 DO
INSERT INTO auth VALUES (userid, zoneid, x);
SET x = x + 1;
END WHILE;
SET x = 100;
WHILE x < 106 DO
INSERT INTO auth VALUES (userid, zoneid, x);
SET x = x + 1;
END WHILE;
SET x = 200;
WHILE x < 215 DO
INSERT INTO auth VALUES (userid, zoneid, x);
SET x = x + 1;
END WHILE;
SET x = 500;
WHILE x < 519 DO
INSERT INTO auth VALUES (userid, zoneid, x);
SET x = x + 1;
END WHILE;
COMMIT;
END$$

CREATE PROCEDURE `adduser`(
in name1 VARCHAR(64),
in passwd1 VARCHAR(64),
in prompt1 VARCHAR(32),
in answer1 VARCHAR(32),
in truename1 VARCHAR(32),
in idnumber1 VARCHAR(32),
in email1 VARCHAR(32),
in mobilenumber1 VARCHAR(32),
in province1 VARCHAR(32),
in city1 VARCHAR(32),
in phonenumber1 VARCHAR(32),
in address1 VARCHAR(64),
in postalcode1 VARCHAR(8),
in gender1 INTEGER,
in birthday1 VARCHAR(32),
in qq1 VARCHAR(32),
in passwd21 VARCHAR(64)
)
BEGIN
DECLARE idtemp INTEGER;
SELECT IFNULL(MAX(id), 1008) + 16 INTO idtemp FROM users;
INSERT INTO users (id,name,passwd,prompt,answer,truename,idnumber,email,mobilenumber,province,city,phonenumber,address,postalcode,gender,birthday,creatime,qq,passwd2) VALUES( idtemp, name1, passwd1, prompt1, answer1, truename1, idnumber1, email1, mobilenumber1, province1, city1, phonenumber1, address1, postalcode1, gender1, birthday1, now(), qq1, passwd21 );
END$$

CREATE PROCEDURE `adduserpoint`(in uid1 INTEGER, in aid1 INTEGER, in time1 INTEGER)
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE point SET time = IFNULL(time,0) + time1 WHERE uid1 = uid AND aid1 = aid;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
INSERT INTO point (uid,aid,time) VALUES (uid1,aid1,time1);
END IF;
COMMIT;
END$$

CREATE PROCEDURE `addUserPriv`(in userid INTEGER, in zoneid INTEGER, in rid INTEGER)
BEGIN
START TRANSACTION;
INSERT INTO auth VALUES(userid, zoneid, rid);
COMMIT;
END$$

CREATE PROCEDURE `changePasswd`(in name1 VARCHAR(64), in passwd1 VARCHAR(64))
BEGIN
START TRANSACTION;
UPDATE users SET passwd = passwd1 WHERE name = name1;
COMMIT;
END$$

CREATE PROCEDURE `changePasswd2`(in name1 VARCHAR(64), in passwd21 VARCHAR(64))
BEGIN
START TRANSACTION;
UPDATE users SET passwd2 = passwd21 WHERE name = name1;
COMMIT;
END$$

CREATE PROCEDURE `clearonlinerecords`(in zoneid1 INTEGER, in aid1 INTEGER)
BEGIN
START TRANSACTION;
UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE aid = aid1 AND zoneid = zoneid1;
COMMIT;
END$$

CREATE PROCEDURE `deleteTimeoutForbid`(in userid1 INTEGER)
BEGIN
START TRANSACTION;
DELETE FROM forbid WHERE userid = userid1 AND timestampdiff(second, ctime, now()) > forbid_time;
COMMIT;
END$$

CREATE PROCEDURE `delUserPriv`(in userid1 INTEGER, in zoneid1 INTEGER, in rid1 INTEGER, in deltype1 INTEGER)
BEGIN
START TRANSACTION;
IF deltype1 = 0 THEN
DELETE FROM auth WHERE userid = userid1 AND zoneid = zoneid1 AND rid = rid1;
ELSE
IF deltype1 = 1 THEN
DELETE FROM auth WHERE userid = userid1 AND zoneid = zoneid1;
ELSE
IF deltype1 = 2 THEN
DELETE FROM auth WHERE userid = userid1;
END IF;
END IF;
END IF;
COMMIT;
END$$

CREATE PROCEDURE `enableiplimit`(in uid1 INTEGER, in enable1 CHAR(1))
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE iplimit SET enable=enable1 WHERE uid=uid1;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
INSERT INTO iplimit (uid,enable) VALUES (uid1,enable1);
END IF;
COMMIT;
END$$

CREATE PROCEDURE `lockuser`(in uid1 INTEGER, in lockstatus1 CHAR(1))
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE iplimit SET lockstatus=lockstatus1 WHERE uid=uid1;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
INSERT INTO iplimit (uid,lockstatus,enable) VALUES (uid1,lockstatus1,'t');
END IF;
COMMIT;
END$$

CREATE PROCEDURE `recordoffline`(in uid1 INTEGER, in aid1 INTEGER, inout zoneid1 INTEGER, inout zonelocalid1 INTEGER, inout overwrite1 INTEGER)
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE uid = uid1 AND aid = aid1 AND zoneid = zoneid1;
SET rowcount = ROW_COUNT();
IF overwrite1 = rowcount THEN
SELECT zoneid, zonelocalid INTO zoneid1, zonelocalid1 FROM point WHERE uid = uid1 AND aid = aid1;
END IF;
COMMIT;
END$$

CREATE PROCEDURE `recordonline`(in uid1 INTEGER, in aid1 INTEGER, inout zoneid1 INTEGER, inout zonelocalid1 INTEGER, inout overwrite INTEGER)
BEGIN
DECLARE tmp_zoneid INTEGER;
DECLARE tmp_zonelocalid INTEGER;
DECLARE rowcount INTEGER;
START TRANSACTION;
SELECT SQL_CALC_FOUND_ROWS zoneid, zonelocalid INTO tmp_zoneid, tmp_zonelocalid FROM point WHERE uid = uid1 and aid = aid1;
SET rowcount = FOUND_ROWS();
IF rowcount = 0 THEN
INSERT INTO point (uid, aid, time, zoneid, zonelocalid, lastlogin) VALUES (uid1, aid1, 0, zoneid1, zonelocalid1, now());
ELSE IF tmp_zoneid IS NULL OR overwrite = 1 THEN
UPDATE point SET zoneid = zoneid1, zonelocalid = zonelocalid1, lastlogin = now() WHERE uid = uid1 AND aid = aid1;
END IF;
END IF;
IF tmp_zoneid IS NULL THEN
SET overwrite = 1;
ELSE
SET zoneid1 = tmp_zoneid;
SET zonelocalid1 = tmp_zonelocalid;
END IF;
COMMIT;
END$$

CREATE PROCEDURE `remaintime`(in uid1 INTEGER, in aid1 INTEGER, out remain INTEGER, out freetimeleft INTEGER)
BEGIN
DECLARE enddate1 DATETIME;
DECLARE now1 DATETIME;
DECLARE rowcount INTEGER;
START TRANSACTION;
SET now1 = now();
IF aid1 = 0 THEN
SET remain = 86313600;
SET enddate1 = date_add(now1, INTERVAL '30' DAY);
ELSE
SELECT time, IFNULL(enddate, now1) INTO remain, enddate1 FROM point WHERE uid = uid1 AND aid = aid1;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
SET remain = 0;
INSERT INTO point (uid,aid,time) VALUES (uid1, aid1, remain);
END IF;
END IF;
SET freetimeleft = 0;
IF enddate1 > now1 THEN
SET freetimeleft = timestampdiff(second, now1, enddate1);
END IF;
COMMIT;
END$$

CREATE PROCEDURE `setiplimit`(in uid1 INTEGER, in ipaddr11 INTEGER, in ipmask11 VARCHAR(2), in ipaddr21 INTEGER, in ipmask21 VARCHAR(2), in ipaddr31 INTEGER, in ipmask31 VARCHAR(2), in enable1 CHAR(1))
BEGIN
DECLARE rowcount INTEGER;
START TRANSACTION;
UPDATE iplimit SET ipaddr1 = ipaddr11, ipmask1 = ipmask11, ipaddr2 = ipaddr21, ipmask2 = ipmask21, ipaddr3 = ipaddr31, ipmask3 = ipmask31 WHERE uid = uid1;
SET rowcount = ROW_COUNT();
IF rowcount = 0 THEN
INSERT INTO iplimit (uid, ipaddr1, ipmask1, ipaddr2, ipmask2, ipaddr3, ipmask3, enable1) VALUES (uid1, ipaddr11, ipmask11, ipaddr21, ipmask21, ipaddr31, ipmask31,'t');
END IF;
COMMIT;
END$$

CREATE PROCEDURE `updateUserInfo`(
in name1 VARCHAR(32),
in prompt1 VARCHAR(32),
in answer1 VARCHAR(32),
in truename1 VARCHAR(32),
in idnumber1 VARCHAR(32),
in email1 VARCHAR(32),
in mobilenumber1 VARCHAR(32),
in province1 VARCHAR(32),
in city1 VARCHAR(32),
in phonenumber1 VARCHAR(32),
in address1 VARCHAR(32),
in postalcode1 VARCHAR(32),
in gender1 INTEGER,
in birthday1 VARCHAR(32),
in qq1 VARCHAR(32)
)
BEGIN
START TRANSACTION;
UPDATE users SET prompt = prompt1, answer = answer1, truename = truename1, idnumber = idnumber1, email = email1, mobilenumber = mobilenumber1, province = province1, city = city1, phonenumber = phonenumber1, address = address1, postalcode = postalcode1, gender = gender1, birthday = birthda1, qq = qq1 WHERE name = name1;
COMMIT;
END$$

CREATE PROCEDURE `usecash`(
in userid1 INTEGER,
in zoneid1 INTEGER,
in sn1 INTEGER,
in aid1 INTEGER,
in point1 INTEGER,
in cash1 INTEGER,
in status1 INTEGER,
out error INTEGER
)
BEGIN
DECLARE sn_old INTEGER;
DECLARE aid_old INTEGER;
DECLARE point_old INTEGER;
DECLARE cash_old INTEGER;
DECLARE status_old INTEGER;
DECLARE createtime_old DATETIME;
DECLARE time_old INTEGER;
DECLARE need_restore INTEGER;
DECLARE exists1 INTEGER;
DECLARE rowcount INTEGER;
START TRANSACTION;
SET error = 0;
SET need_restore = 0;
SELECT SQL_CALC_FOUND_ROWS sn, aid, point, cash, status, creatime INTO sn_old, aid_old, point_old, cash_old, status_old, createtime_old FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn >= 0;
SET rowcount = FOUND_ROWS();
IF rowcount = 1 THEN
SET exists1 = 1;
ELSE
SET exists1 = 0;
END IF;
IF status1 = 0 THEN
IF exists1 = 0 THEN
SELECT aid, point INTO aid1, point1 FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn1;
SET point1 = IFNULL(point1,0);
UPDATE point SET time = time-point1 WHERE uid = userid1 AND aid = aid1 AND time >= point1;
SET rowcount = ROW_COUNT();
IF rowcount = 1 THEN
UPDATE usecashnow SET sn = 0, status = 1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn1;
ELSE
SET error = -8;
END IF;
END IF;
ELSE
IF status1 = 1 THEN
IF exists1 = 0 THEN
UPDATE point SET time = time-point1 WHERE uid = userid1 AND aid = aid1 AND time >= point1;
SET rowcount = ROW_COUNT();
IF rowcount = 1 THEN
INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES (userid1, zoneid1, sn1, aid1, point1, cash1, status1, now());
ELSE
INSERT INTO usecashnow SELECT userid1, zoneid1, IFNULL(min(sn),0)-1, aid1, point1, cash1, 0, now() FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND 0 >= sn;
SET error = -8;
END IF;
ELSE
INSERT INTO usecashnow SELECT userid1, zoneid1, IFNULL(min(sn),0)-1, aid1, point1, cash1, 0, now() FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND 0 >= sn;
SET error = -7;
END IF;
ELSE
IF status1 = 2 THEN
IF exists1 = 1 AND status_old = 1 AND sn_old = 0 THEN
UPDATE usecashnow SET sn = sn1, status = status1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old;
ELSE
SET error = -9;
END IF;
ELSE
IF status1 = 3 THEN
IF exists1 = 1 AND status_old = 2 THEN
UPDATE usecashnow SET status = status1 WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old;
ELSE
SET error = -10;
END IF;
ELSE
IF status1 = 4 THEN
IF exists1 = 1 THEN
DELETE FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old;
INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES (userid1, zoneid1, sn_old, aid_old, point_old, cash_old, status1, createtime_old, now());
END IF;
IF NOT (exists1 = 1 AND status_old = 3) THEN
SET error = -11;
END IF;
ELSE
SET error = -12;
END IF;
END IF;
END IF;
END IF;
END IF;
IF need_restore = 1 THEN
UPDATE point SET time = time+point_old WHERE uid = userid1 AND aid = aid_old;
DELETE FROM usecashnow WHERE userid = userid1 AND zoneid = zoneid1 AND sn = sn_old;
INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES (userid1, zoneid1, sn_old, aid_old, point_old, cash_old, status1, createtime_old, now());
END IF;
COMMIT;
END$$

DELIMITER ;

this will create new database

- - - Updated - - -

what is darklord fashion ID ? and where do i know any item's ID ?

- - - Updated - - -

i have few last questions i hope so
1-How can i learn all skills in an instant ? for example instead i go to trainer and learn them when i create new classes , is there way to make them learned already once you log on ?
2-how can i make quest port player from location 62 * primal world * to any place i like ?
i know i am bothering but it kills me when i dont ask for any little and i am really glad for all your help until now

[Teemo Cell]

yea there is way
if i were you i would go to pwAdmin delete the characters then delete the accounts then go to phpmyadmin and select the data base you created such like pw and choose operations drop data base and go
then go to database the icon that seem like house and click on mysql section
and past this there and click on go

this will create new database

- - - Updated - - -

what is darklord fashion ID ? and where do i know any item's ID ?

- - - Updated - - -

i have few last questions i hope so
1-How can i learn all skills in an instant ? for example instead i go to trainer and learn them when i create new classes , is there way to make them learned already once you log on ?
2-how can i make quest port player from location 62 * primal world * to any place i like ?
i know i am bothering but it kills me when i dont ask for any little and i am really glad for all your help until now

Here u can get the ID's http://www.pwdatabase.com/pwi

or use elements editor and search in the fashion row


1-Use pwAdmin Addons "Skill hexgen" Choose the skill for what class. Copy the hex code and past it in your Char template.

For example "TEMPLATE ARCHER FEMALE" Search for <variable name="skills" type="Octets">1f0000004a010000000000000a000000ea000000000000000a00000012010000000000000a000000fe000000000000000a000000ff000000000000000a000000f7000000000000000a000000f8000000000000000a000000fc0000000000000001000000f9000000000000000a000000fd000000000000000a000000f5000000000000000a000000f6000000000000000a000000fa000000000000000a000000fb000000000000000a000000f2000000000000000a000000f3000000000000000a000000f4000000000000000a000000f0000000000000000a000000f1000000000000000a0000009f000000000000000a0000009e000000000000000a000000a7000000000000000100000049010000000000000a00000000010000000000000a000000a0000000000000000a000000a1000000000000000a000000ee000000000000000a000000ef000000000000000a000000eb000000000000000a000000ec000000000000000a000000ed000000000000000a000000</variable>
Delete the old Hexcode and past the new one.

- - - Updated - - -

Wokr the Release with Ubuntu 64Bit or only with 32 bit?

[ROmenGod]

thanks for the full auto install server and client

I tested PW server 131 and 136 server and Client both working without issues

now my torrent download for 146 client finished and installed

using service pwversion 146 i moved to 146 version and updated my ip on server and client on
and started server via pwadmin (all started without vissible issues ) (showing all service online and gs01:world Online)

Created a new account via pwadming
Issue

After loging in at user creating Client window its showing timeout , tried many times (I tried Ping in local server (192.168.249.135) its success




thanks for admin note showing location of logs


ubunt gdeliveryd: err: gdelivery::erase gameserver 1 sid =2
glink disconnect from gameserver 1, drop all players


My User ID starting from 1136



system config of Server VM

4 Core VM /(6 Core CPU)
4 GB Ram VM /(16GB total
1 GB swap

[Ben]

thanks for the full auto install server and client

I tested PW server 131 and 136 server and Client both working without issues

now my torrent download for 146 client finished and installed

using service pwversion 146 i moved to 146 version and updated my ip on server and client on
and started server via pwadmin (all started without vissible issues ) (showing all service online and gs01:world Online)

Created a new account via pwadming
Issue

After loging in at user creating Client window its showing timeout , tried many times (I tried Ping in local server (192.168.249.135) its success




thanks for admin note showing location of logs


ubunt gdeliveryd: err: gdelivery::erase gameserver 1 sid =2
glink disconnect from gameserver 1, drop all players


My User ID starting from 1136



system config of Server VM

4 Core VM /(6 Core CPU)
4 GB Ram VM /(16GB total
1 GB swap

Check libs it could be libtask.so

[ROmenGod]

Check libs it could be libtask.so

Reinstalled again ,i am able to play 146 now , after few hours testing , i found Send Mail not working , i am unable to send Item to char (no gui errors ) ,

when i get time i will check it in details , hopefully some1 might have had same issue here , so fixing might b easy

[oldngrey]

ROmenGod,
Did sending mail to other players ever work for you?
I have v146 of 343's distro here and mail definitely does work (I even waited an hour to check)

[Teemo Cell]

pw-136-server_07.JAN.2014-ubuntu12.04
and
pw-131-server_07.JAN.2014-ubuntu12.04
ARE THE SAME

are you fucking kidding me?????????????

[Caosfox]

maybe inside the game they looks the same (i bet 1.3.1 and 1.3.6 not too different, ofc i never tried 1.3.1)
but about if the files are identical, they are not
pw-131-server_07.JAN.2014-ubuntu12.04.3_amd64 = 159.842.304 bytes
pw-136-server_07.JAN.2014-ubuntu12.04.3_amd64 = 508.985.344 bytes