Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
florin27x
Try getting a new gs.conf file and the npc fix in the posts behind and it will work (works almost everything xcept dragon mountain for me)
i try using Henmoro(Rose)gs.conf file from page 8, and download ed "http://forum.ragezone.com/6927821-post39.html Morbitangel's attachment and place them in /usr/zx2/gamed/config/ folders follow by z1 z2 z23" i changed at server gs.conf file and replaced z2 and z23 folders, and now got error "Server update in progress, pls patch and try again"
EDIT: I tried golfgto2527 gs.conf from page 11 and now works thx all :) btw could someone upload z26 file (this chinese link i think dont work), i mean from here http://forum.ragezone.com/6939762-post116.html this link http://115.com/file/behnmmdi
btw what map is this z26??
1 Attachment(s)
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
jozefpawelec
Here you go!
It's the npcs that missing from Dragon Mountain not map.
So extract the z26/npcgen.data and replace over the old one in /usr/zx2/gamed/config/z26/npcgen.data
Enjoy....
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
zoneoflove
how come it's not work with me:?: what your mean "Solved". I open the task edit it work fine but it cannot read the task.data 977:blink: i dont known why:(:
Solved - I meant, I'd got it working, it actually open and read the Tasks.data! At first i had the program but with incorrect informations, like the Serial, Name and key in the mifeng.key which needed by the program Task Editor for it to recognised as a registered user. Which the NS.txt that comes with the packed is the one! Just delete the mifeng.key and rename the NS.txt to mifeng.key and it finally read the Tasks.data! and one more thing you need to run it as Admin...
So there - now you have it. Enjoy! :w00t:
Quote:
Originally Posted by
jozefpawelec
ty :)
Glad to help :P:
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
Dekeract
Does anyone mind uploading a copy of the database "sm", it'd be greatly appreciated.
Code:
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=MyISAM 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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `online` (
`ID` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
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=MyISAM 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=MyISAM 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=MyISAM 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=MyISAM DEFAULT CHARSET=utf8;
DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `acquireuserpasswd`(in name1 VARCHAR(64), out uid1 INTEGER, out passwd1 VARCHAR(64))
BEGIN
DECLARE passwdtemp VARCHAR(64);
START TRANSACTION;
SELECT id, passwd INTO uid1, passwdtemp FROM users WHERE name = name1;
SELECT fn_varbintohexsubstring(1,passwdtemp,1,0) INTO passwd1;
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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), 16) + 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` PROCEDURE `addUserPriv`(in userid INTEGER, in zoneid INTEGER, in rid INTEGER)
BEGIN
START TRANSACTION;
INSERT INTO auth VALUES(userid, zoneid, rid);
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `changePasswd`(in name1 VARCHAR(64), in passwd1 VARCHAR(64))
BEGIN
START TRANSACTION;
UPDATE users SET passwd = passwd1 WHERE name = name1;
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `changePasswd2`(in name1 VARCHAR(64), in passwd21 VARCHAR(64))
BEGIN
START TRANSACTION;
UPDATE users SET passwd2 = passwd21 WHERE name = name1;
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `clearonlinerecords`(in zoneid1 INTEGER, in aid1 INTEGER)
BEGIN
START TRANSACTION;
UPDATE point SET zoneid = NULL, zonelocalid = NULL WHERE aid = aid1 AND zoneid = zoneid1;
DELETE FROM online;
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteTimeoutForbid`(in userid1 INTEGER)
BEGIN
START TRANSACTION;
DELETE FROM forbid WHERE userid = userid1 AND timestampdiff(second, ctime, now()) > forbid_time;
COMMIT;
END$$
CREATE DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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;
DELETE FROM online WHERE ID = uid1;
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 DEFINER=`root`@`localhost` 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;
INSERT INTO online (ID) VALUES (uid1);
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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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 DEFINER=`root`@`localhost` 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$$
CREATE DEFINER=`root`@`localhost` FUNCTION `fn_varbintohexsubstring`(fsetprefix bit,pbinin varbinary(8000),startoffset int,cbytesin int) RETURNS varchar(4000) CHARSET latin1
READS SQL DATA
BEGIN
DECLARE pstrout VARCHAR(4000);
DECLARE i int;
DECLARE firstnibble int;
DECLARE secondnibble int;
DECLARE tempint int;
DECLARE hexstring char( 16);
BEGIN
IF( pbinin IS NOT NULL) THEN
SET i= 0, cbytesin= CASE WHEN( cbytesin> 0) THEN cbytesin ELSE LENGTH( pbinin) END,
pstrout= CASE WHEN( fsetprefix= 1) THEN '0x' ELSE '' END,
hexstring= '0123456789abcdef';
IF((( cbytesin * 2) + 2> 4000) or( startoffset< 1)) THEN
RETURN NULL;
END IF;
WHILE( i< cbytesin) DO
SET tempint= ASCII( substring( pbinin, i + startoffset, 1));
SET firstnibble= TRUNCATE((tempint / 16),0);
SET secondnibble= tempint % 16;
SET pstrout= CONCAT(pstrout ,cast( substring( hexstring,( firstnibble+1), 1) AS CHAR), cast( substring( hexstring,( secondnibble+1), 1) AS CHAR));
SET i= i + 1;
END WHILE;
RETURN pstrout;
END IF;
RETURN NULL;
END;
END$$
DELIMITER ;
1 Attachment(s)
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
hi,
Can someone please help me. WinSCP and Navicat work, Char was created and is also present in the db. But it is the "Name or password incorrect".All patch sind fixed.
Have this error found.Pls help
Sry for my bad english
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
MrSimple
hi,
Can someone please help me. WinSCP and Navicat work, Char was created and is also present in the db. But it is the "Name or password incorrect".All patch sind fixed.
Have this error found.Pls help
Sry for my bad english
See config files and if u changed password be sure u change it on there too.
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Thanks for the quick reply. I only have the IP and change the db name as in the instructions. 've Now been installed and uninstalled x times always the same error. :*:
PS: Problem solved. I don´t know is how it all at once
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
i got a probelm with winscp when i put my linux ip in there and username and password i press login and it give me this error saying connections failed or host not found could anyone help me
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Quote:
Originally Posted by
jozefpawelec
Hi I need help pls. I configured all VM etc, but im stuck at client. I downloaded file, instaled it but didnt patched and what to do next???I tried change serverlist.txt file, but each time i try open elementclient.exe it auto close . Sorry im newbie in this :(
I figured out this problem very quickly.
Open your patcher.exe as an administrator, then click the settings option.
Click optimize, or set your resolutions etc. to whatever you desire. Close and start. Simple!
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
anyone got a better tool for element.data beside Elements_TT or Race_player_TT both sux plus they can only open upto 137 and my element is 138
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Hi guys, I have only one realm, how can I add more?
Thank you
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
There should be a pre-made file in root named gs, or gs1, gs01, That'll start another realm when ran threw the linux prompt.
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Re: [Release] Zhu Xian 2 - 9 Classes - mySQL Server Enabled
Due to the thread being helpful it has been stickyed for all of you.
Henmoro.
