[Release]SwordsMan Online (arcgames.com)

[grishalter]

I'll send anyone who wants GM tool existed in...

.pck Tool

You must be registered to see links

interfaces.pck not valid packed.

 

[MeGaMaX]

:

You must be registered to see links

You must be registered to see links

you are using my client ^^

 

[ngochacn4]

to installation server SwordsMan me to load
1. VMware
2. SQL server
only VMware and SQL
then begin to run server???

 

[SviT]

You must be registered to see links

Only unpack pck files.

 

[trexsh]

A lot of ppl just need a VMWARE image with the working server, but I guess nobody want to upload that.
If somebody can help with my error, i can upload the entire game and the vmware image with the working server...

You know guys, more people with a working server, more people working into the english tanslation.

this is the error:

"warning: glinkd:Connect to delivery failed.

Running into VMWARE 10 with Ubuntu 12- .

 

[Acnathon]

Hi all.
For "warning: glinkd:Connect to delivery failed." u should make sure the gdeliveryd is runing and all ips are put correct.
There are some needed files for gdeliveryd to run if the files not present it gives an error on chinese in the log files but it doesnt tell you which files are missing.
List of the files:

I already got almost everything to work but im having an error that wont go away no matter what i try :S

Error codes list:

gdeliveryd: err:DS::RegisterZone: send to uniquenamed failed ret=-2.
gdeliveryd: err:DS::UserLogin: userid=32,retcode=10
gdeliveryd: err:DS::Find Scene Master Mirror Wrong,scene_tag:count,(42:0,76:0,98:0,)
gamedbd: err:GameDBServer::OnDelSession, sid=8.
gdeliveryd: err:gdelivery::Erase gameserver 1(sid=3) and drop all related players
glinkd-1: err:LS::GProviderServer: reconnection timeout, drop all players on gameserver 1
gdeliveryd: err:DS::GDeliveryServer: Disconnect from linkserver sid=3, drop 0 users

After this the gamed crashes and start to give these errors:

gamedbd: err:Protocol Unknown . sid=11,type=71,size=69,acceptsize=143
gamedbd: err:GameDBServer::OnDelSession, sid=11.
gamedbd: err:Protocol Unknown . sid=12,type=71,size=69,acceptsize=143
gamedbd: err:GameDBServer::OnDelSession, sid=12.

Theres also some warnings that im not sure of (its spammed alot of times - multiple times / second):

gs001: warning:GProviderClient::OnAbortSession,sid=0,lineid=1,is_del=0

And finally heres a pic of the game with the error but cannot enter since gs crashes:

Anyone any ideas about the above errors/warnings?

 

[privategame]

with 205 error, you need to clear the temp in db. it's easy.

i finished all of this server. but sorry to my network so slow. cant upload the server to here.

i will reply with all of the error if someone got it.

 

[morbitangel]

no the 205 error is not about the db its bout a certain instance not running aka the tutorial it actually shows you in the server console if youre watching it while logging in that i think world/instance 2823 is invalid tid or something aka that instance/map isnt running you need to start a gameserver with galias10.conf if i remember correctly.
all that said i do have a centos image with these files and i am able to login with megamax his client but at login every character i make has 0 hp and im not sure why atm. and i dont see the point in uploading a semi bugged virtual machine just to get complaints that it isnt working xD

ps. yes i did try synching client data files to server side as is pretty standard with perfect world games.

 

[Acnathon]

Hmm so the 205 error is fixed with other gsalias but then a little later the gamed still crashes.

Client error:

Server error still similar like before:

gdeliveryd: err:DS::RegisterZone: send to uniquenamed failed ret=-2.
gdeliveryd: err:DS::Find Scene Master Mirror Wrong,scene_tag:count,(18:0,26:0,74:0,76:0,85:0,86:0,91:0,95:0,97:0,1051:0,1310:0,2003:0,)
gamedbd: err:GameDBServer::OnDelSession, sid=8.
gdeliveryd: err:gdelivery::Erase gameserver 10(sid=3) and drop all related players
glinkd-1: err:LS::GProviderServer: reconnection timeout, drop all players on gameserver 10
gamedbd: err:GameDBServer::OnDelSession, sid=9.
gdeliveryd: err:gdelivery::Erase gameserver 10(sid=4) and drop all related players
glinkd-1: err:LS::GProviderServer: reconnection timeout, drop all players on gameserver 10

Btw character HP ad all stats seems to be fine with default files from package.

 

[privategame]

zz... 80% of world map need galias1.

 

[Bola]

download gs and gsalias1 mine

You must be registered to see links

this will make a startfull of server, i use 5gb on my vmware and run fine

command to start GS
./gs gs.conf gmserver.conf config/gsalias1.conf

----------------------update------------------------------------
here my gdeliveryd module working fine on centos 6.5 64bits on VMware 10, case someone have some problem on this module

You must be registered to see links

----------------------------------update --------------------------------------------------

there's no fix for cash to mysql authd system

 

[bloodforevil]

İp Change

[QUOTE]<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>

<application debug="false" >

<!-- MSSQL -->
<driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.200.100:1433;databasename=UserDB" username="sa" password="123456"/>


<table name="users" connection="auth0" operate="replaceA"> 
	<column name="id"           sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="name"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="passwd"       sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="true" />
	<column name="prompt"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="answer"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="truename"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="idnumber"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="email"        sql-type="varchar(64)" java-type="java.lang.String"  not-null="true" />
	<column name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
	<column name="province"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
	<column name="city"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
	<column name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
	<column name="address"      sql-type="varchar(64)" java-type="java.lang.String"  not-null="false" />
	<column name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String"  not-null="false" />
	<column name="gender"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="birthday"     sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
	<column name="creatime"     sql-type="datetime"    java-type="java.util.Date"    not-null="true" />
	<column name="qq"           sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
	<column name="passwd2"      sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="false" />

	<primarykey name="pk_id" column="id" />
	<index name="ind_name" unique="true" column="name" />
	<index name="ind_creatime" column="creatime" />
</table>

<table name="account" connection="auth0" operate="replaceA"> 
	<column name="id"           sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="name"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
	<column name="passwd"       sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="true" />
	<column name="creatime"     sql-type="datetime"    java-type="java.util.Date"    not-null="true" />
	<column name="usertype"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />

	<primarykey name="pk_id" column="id" />
	<index name="ind_name" unique="true" column="name" />
	<index name="ind_creatime" column="creatime" />
</table>

<table name="iplimit" connection="auth0" operate="replaceA">
	<column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="ipaddr1"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="ipmask1"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
	<column name="ipaddr2"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="ipmask2"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
	<column name="ipaddr3"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="ipmask3"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
	<column name="enable"       sql-type="char(1)"     java-type="java.lang.String" not-null="false" />
	<column name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" not-null="false" />

	<primarykey name="pk_iplimit" column="uid" />
</table>

<table name="auth" connection="auth0" operate="replaceA">
	<column name="userid"       sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="zoneid"      	sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="rid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<primarykey name="pk_id" column="userid, zoneid, rid" />
</table>

<table name="forbid" connection="auth0" operate="replaceA">
	<column name="userid"       sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
	<column name="type"	        sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
	<column name="ctime"        sql-type="datetime"     java-type="java.util.Date" 	 not-null="true" />
	<column name="forbid_time"  sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
	<column name="reason"     sql-type="varbinary(255)" java-type="java.lang.reflect.Array" not-null="true" />
	<column name="gmroleid"     sql-type="integer"      java-type="java.lang.Integer" not-null="false"/>

	<primarykey name="pk_id" column="userid,type" />
</table>

<table name="point" connection="auth0" operate="replaceA">
	<column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="aid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="time"         sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
	<column name="zoneid"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="zonelocalid"  sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
	<column name="accountstart" sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
	<column name="lastlogin"    sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
	<column name="enddate"      sql-type="datetime"    java-type="java.util.Date"    not-null="false" />

	<primarykey name="pk_id" column="uid, aid" />
	<index name="ind_aid" column="aid,zoneid" />
</table>

<table name="usecashnow" connection="auth0" operate="replaceA">
	<column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<!--status 1.create; 2.get sn; 3.send addcash; 4.finish; -->
	<column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
	<column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>

	<primarykey name="pk_usecashnow" column="userid, zoneid, sn" />
	<index name="ind_usecashnow_status" column="status" />
	<index name="ind_usecashnow_creatime" column="creatime" />
</table>

<table name="usecashlog" connection="auth0" operate="replaceA">
	<column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
	<column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
	<column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>
	<column name="fintime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>

	<index name="ind_usecashlog_uzs" column="userid, zoneid, sn" />
	<index name="ind_usecashlog_creatime" column="creatime" />
</table>

<query name="getUserid">
	<table name="users" alias="u" />
	<column name="id" column="u.id" />
	<select name="byName" condition="WHERE u.name = ?" />
</query>

<query name="getUserInfo">
	<table name="users" alias="u" />
	<column name="id" column="u.id" />
	<column name="prompt" column="u.prompt" />
	<column name="answer" column="u.answer" />
	<column name="truename" column="u.truename" />
	<column name="idnumber" column="u.idnumber" />
	<column name="email" column="u.email" />
	<column name="mobilenumber" column="u.mobilenumber" />
	<column name="province" column="u.province" />
	<column name="city" column="u.city" />
	<column name="phonenumber" column="u.phonenumber" />
	<column name="address" column="u.address" />
	<column name="postalcode" column="u.postalcode" />
	<column name="gender" column="u.gender" />
	<column name="birthday" column="u.birthday" />
	<column name="creatime" column="u.creatime" />
	<column name="qq" column="u.qq" />
	<select name="byName" condition="WHERE u.name = ?" />
</query>

<query name="getUsername">
	<table name="users" alias="u" />
	<column name="name" column="u.name" />
	<select name="byId" condition="WHERE u.id = ?"/>
</query>

<query name="acquireIdPasswd">
	<table name="users" alias="u" />
	<column name="id" column="u.id" />
	<column name="passwd" column="u.passwd" />
	<column name="creatime" column="u.creatime" />
	<select name="byName" condition="WHERE u.name = ?"/>
</query>

<query name="acquireIdPasswd2">
	<table name="users" alias="u" />
	<column name="id" column="u.id" />
	<column name="passwd2" column="u.passwd2" />
	<select name="byName" condition="WHERE u.name = ?"/>
</query>

<query name="acquireUserCreatime">
	<table name="users" alias="u" />
	<column name="creatime" column="u.creatime" />
	<select name="byUid" condition="WHERE u.id = ?"/>
</query>

<query name="getIPLimit">
	<table name="iplimit" alias="i" />
	<column name="uid" column="i.uid" />
	<column name="ipaddr1" column="i.ipaddr1" />
	<column name="ipmask1" column="i.ipmask1" />
	<column name="ipaddr2" column="i.ipaddr2" />
	<column name="ipmask2" column="i.ipmask2" />
	<column name="ipaddr3" column="i.ipaddr3" />
	<column name="ipmask3" column="i.ipmask3" />
	<column name="enablue" column="i.enable" />
	<column name="lockstatus" column="i.lockstatus" />
	<select name="byUid" condition="WHERE i.uid = ?"/>
</query>

<query name="acquireUserPrivilege">
	<table name="auth" alias="au" />
	<column name="rid" column="au.rid" />
	<select name="byUidZid" condition="WHERE au.userid = ? AND au.zoneid = ?"/>
</query>

<query name="acquirePrivilege">
	<table name="auth" alias="au" />
	<table name="users" alias="users" />
	<column name="userid" column="au.userid" />
	<column name="zoneid" column="au.zoneid" />
	<column name="rid" column="au.rid" />
	<column name="name" column="users.name" />
	<column name="creatime" column="users.creatime" />
	<select name="byZid" condition="WHERE au.userid = users.id AND au.zoneid = ?"/>
	<select name="byUid" condition="WHERE au.userid = users.id AND au.userid = ?"/>
	<select name="byUidZid" condition="WHERE au.userid = users.id AND au.userid = ? AND au.zoneid = ?"/>
	<select name="byRidZid" condition="WHERE au.userid = users.id AND au.rid = ? AND au.zoneid = ?"/>
	<select name="byAll" condition="WHERE au.userid = users.id"/>
</query>

<query name="acquireForbid">
	<table name="forbid" alias="fb"/>
	<column name="userid" column="fb.userid"/>
	<column name="type" column="fb.type"/>
	<column name="ctime" column="fb.ctime"/>
	<column name="forbid_time" column="fb.forbid_time"/>
	<column name="reason" column="fb.reason"/>
	<column name="gmroleid" column="fb.gmroleid"/>
	<select name="byUid" condition="WHERE fb.userid = ? and datediff(ss,fb.ctime,getdate())<=fb.forbid_time"/>
</query>

<query name="getUserOnlineInfo">
	<table name="point" alias="p"/>
	<column name="zoneid" column="p.zoneid"/>
	<column name="localsid" column="p.zonelocalid"/>
	<column name="aid" column="p.aid"/>
	<select name="byUid" condition="WHERE p.uid = ?"/>
</query>

<query name="getUserPoints">
	<table name="point" alias="p" />
	<column name="aid" column="p.aid" />
	<column name="time" column="p.time" />
	<column name="enddate" column="p.enddate" />
	<select name="byuid" condition="where p.uid=? and NOT p.aid=0" />
</query>

<query name="getusecashnow">
	<table name="usecashnow" alias="u"/>
	<column name="userid" column="u.userid"/>
	<column name="zoneid" column="u.zoneid"/>
	<column name="sn" column="u.sn"/>
	<column name="aid" column="u.aid"/>
	<column name="point" column="u.point"/>
	<column name="cash" column="u.cash"/>
	<column name="status" column="u.status"/>
	<column name="creatime" column="u.creatime"/>

	<select name="bystatus" condition="WHERE status = ?"/>
	<select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
	<select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
	<select name="byuser" condition="WHERE u.userid = ?"/>
</query>

<query name="getusecashlog">
	<table name="usecashlog" alias="u"/>
	<column name="userid" column="u.userid"/>
	<column name="zoneid" column="u.zoneid"/>
	<column name="sn" column="u.sn"/>
	<column name="aid" column="u.aid"/>
	<column name="point" column="u.point"/>
	<column name="cash" column="u.cash"/>
	<column name="status" column="u.status"/>
	<column name="creatime" column="u.creatime"/>
	<column name="fintime" column="u.fintime"/>

	<select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
	<select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
	<select name="byuser" condition="WHERE u.userid = ?"/>
</query>

<procedure name="acquireuserpasswd" connection="auth0" operate="replaceA"> 
 <parameter name="name1"     sql-type="varchar(64)"  java-type="java.lang.String"  in="true"  out="false" /> 
 <parameter name="uid1"      sql-type="integer"      java-type="java.lang.Integer" in="false" out="true" /> 
 <parameter name="passwd1"   sql-type="varchar(64)"  java-type="java.lang.String"  in="false" out="true" /> 
</procedure>

<procedure name="adduser" connection="auth0" operate="replaceA">
	<parameter name="name"     sql-type="varchar(64)"  java-type="java.lang.String" in="true" out="false" />
	<parameter name="passwd"   sql-type="binary(16)"   java-type="java.lang.reflect.Array" in="true" out="false" />
	<parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
	<parameter name="gender"   sql-type="integer"  java-type="java.lang.Integer" in="true" out="false" />
	<parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="passwd2"  sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="updateUserInfo" connection="auth0" operate="replaceA">
	<parameter name="name"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
	<parameter name="gender"   sql-type="integer"    java-type="java.lang.Integer" in="true" out="false" />
	<parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
</procedure>

<procedure name="changePasswd" connection="auth0" operate="replaceA">
	<parameter name="name"   sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="passwd" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="changePasswd2" connection="auth0" operate="replaceA">
	<parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
	<parameter name="passwd2" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
</procedure>

<procedure name="setiplimit" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="ipaddr1"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="ipmask1"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
	<parameter name="ipaddr2"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="ipmask2"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
	<parameter name="ipaddr3"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="ipmask3"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="enableiplimit" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="enable"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="lockuser" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
</procedure>

<procedure name="addUserPriv" connection="auth0" operate="replaceA">
	<parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
	<parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
	<parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
</procedure>

<procedure name="delUserPriv" connection="auth0" operate="replaceA">
	<parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
	<parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
	<parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
	<parameter name="deltype"  sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
</procedure>

<procedure name="addForbid" connection="auth0" operate="replaceA">
	<parameter name="userid"   sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="type"     sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
	<!--parameter name="ctime" sql-type="datetime"    java-type="java.util.Date" 	in="true" out="false"/-->
	<parameter name="forbid_time" sql-type="integer"  java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="reason"   sql-type="varbinary(255)" java-type="java.lang.reflect.Array"  in="true" out="false"/>
	<parameter name="gmroleid" sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
</procedure>

<procedure name="deleteTimeoutForbid" connection="auth0" operate="replaceA">
	<parameter name="userid"	sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
</procedure>

<procedure name="clearonlinerecords" connection="auth0" operate="replaceA">
	<parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
	<parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
</procedure>

<procedure name="recordonline" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
	<parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
	<parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
	<parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
	<parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true"  />
</procedure>

<procedure name="recordoffline" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
	<parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
	<parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
	<parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
	<parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true" />
</procedure>

<procedure name="remaintime" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
	<parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
	<parameter name="remain"   sql-type="integer"  java-type="java.lang.Integer"    in="false" out="true" />
	<parameter name="freetimeleft" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" />
</procedure>

<procedure name="adduserpoint" connection="auth0" operate="replaceA">
	<parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
	<parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
	<parameter name="time"     sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
</procedure>

<procedure name="usecash" connection="auth0" operate="replaceA">
	<parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="zoneid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="sn"     sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="aid"    sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="point"  sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="cash"   sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
	<parameter name="error"  sql-type="integer" java-type="java.lang.Integer" in="false" out="true"/>
</procedure>

</application>
[/QUOTE]

 

[Sinisterial]

download gs and gsalias1 mine

You must be registered to see links

this will make a startfull of server, i use 5gb on my vmware and run fine

command to start GS
./gs gs.conf gmserver.conf config/gsalias1.conf

----------------------update------------------------------------
here my gdeliveryd module working fine on centos 6.5 64bits on VMware 10, case someone have some problem on this module

You must be registered to see links

----------------------------------update --------------------------------------------------

there's no fix for cash to mysql authd system

Use debug command for cash. for the people that are using mysql

 

[Bola]

Use debug command for cash. for the people that are using mysql

how private servers will work giving cash for players in debug mode ? , and about another player use this console ?

 

[Ben]

O: same setup as PWI on the files i see of the SS's posted in the earlier posts. gonna take a look

 

[Bola]

O: same setup as PWI on the files i see of the SS's posted in the earlier posts. gonna take a look

yes. developed by Beijing in Angelica engine 3 , but authd no work like perfect world

 

[Ben]

yes. developed by Beijing in Angelica engine 3 , but authd no work like perfect world

;-; crap the authd tho even with client files and the maps there is alot that should be able to be done in my eyes. by applying it to PW

 

[Sinisterial]

how private servers will work giving cash for players in debug mode ? , and about another player use this console ?

I didnt mean for public server lol. But for time being people can use that when someone tests stuff

 

[yaclon]

plz help fix this

 

[bloodforevil]

plz help fix this

authd for db ip change XML files