Forsaken World [ Server Files ]

Nikol@ · May 28, 2012

gpadmin said:
Thank you guys. How add kubi here?
call usecash (ID , 1, 0, 19, 0, 1000000, 1, @error) > ADD CASH

where i need post it? I try use my old script for kubi from PW server. Data correct adding to DB in table usecashnow but server not add it to game account later in game? What i miss? Kubi system here different?

via phpmyadmin ...
also, u have

You must be registered to see links

(u need to start it first)
and there u can add gold/money and everything else ...

bloodknight · Jun 16, 2012

can anyone reupload the files from mediafire. they are not there anymore or they are not working. please? i really would like to make a private server if anyone can help me.

vrusolik · Jun 22, 2012

worked thanks

trickstertik · Jun 26, 2012

Thanks !

Varang · Jun 26, 2012

When I use the SELEdit, I get an error when I try to save. I was wondering if you've updated configs or anything and wouldn't mind sharing them with us. I'd be thankful for that.

segredu · Jun 27, 2012

phprap said:
-------------------------------------------------
OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0
gauthd: 13 Apr 2012 01:28:01,396 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=1024,zoneid=1,sn=-4,ret=-8
gauthd: 13 Apr 2012 01:28:01,692 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=1024,zoneid=1,sn=-3,ret=-8
gauthd: 13 Apr 2012 01:28:01,997 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=1024,zoneid=1,sn=-2,ret=-8
gauthd: 13 Apr 2012 01:28:02,090 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=1024,zoneid=1,sn=-1,ret=-8
gauthd: 13 Apr 2012 01:28:02,371 INFO GAuthServer:? - UseCashTimerTask: status=0,userid=8202,zoneid=1,sn=-1,ret=-8
TRACE : gamed(1):: OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0
TRACE : gamed(1):: OnAbortSession 0

he is not adding the account

Eyrda Leaf = 0

HELP? I using (auth mysql) and comand

call addGM (ID , 1) ( WORK FINE )

call usecash (ID , 1, 0, 1, 0, 1000000, 1, @error) ( NOT WORK )

USAGE: call usecash (CHAR_ID , 1, 0, 19, 0, 999999, 1, @error);
Check too: /root/phprap/mauthd/etc/table.xml
because it had an error at line 1

2012-06-27 00-06-24 - Forsaken World [ Server Files ] - RaGEZONE Forums

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>
<application debug="false" >
<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/fw?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true" username="root" password="root"/>

<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="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 time_to_sec(timediff(Now(),fb.ctime))<=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 = ? AND creatime < date_add(now(), INTERVAL '-200' SECOND)"/>
	<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>

datcom · Jun 27, 2012

segredu said:

USAGE: call usecash (CHAR_ID , 1, 0, 19, 0, 999999, 1, @error);
Check too: /root/phprap/mauthd/etc/table.xml
because it had an error at line 1
View attachment 107779

Code:

<?xml version="1.0" encoding="ISO-8859-1"?>
<?xml-stylesheet type="text/xsl" href="table.xsl"?>
<application debug="false" >
<driver name="com.mysql.jdbc.Driver" />
<connection name="auth0" poolsize="3" url="jdbc:mysql://localhost:3306/fw?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true" username="root" password="root"/>

<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="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 time_to_sec(timediff(Now(),fb.ctime))<=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 = ? AND creatime < date_add(now(), INTERVAL '-200' SECOND)"/>
	<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>

Check:/etc/table.xml

NetskyDE · Jul 11, 2012

1. Is there any guide for setting up a server?
2. Can somebody upload the files on an european site?

mylove1412 · Jul 12, 2012

How can i connect to server with Nightfall Client?

vixio_dv · Jul 25, 2012

gs can't start

BrushMan.cpp:64: void SvrCD::CBrushMan::SetSmTree(SvrCD::CSMTree*): Assertion `pSmTree' failed.

anyone know?

vixio_dv · Jul 27, 2012

solved by changing OS, and get a new problem without error log. lol

uebari - Forsaken World [ Server Files ] - RaGEZONE Forums

Exotic2012 · Aug 11, 2012

Ok Im having an issue not sure what it is maybe one of you know
The error is ./gs: undefined symbol: _Z17LoadTasksFromPackP14elementdatamanPKxS2_S2_P9lue_State
I'm truing to put it on a redhat vmware, as the ubuntu release I have is total crap. everything works but the GS and Im unfamiliar with the error

and if you don't know pls just don't respond, I notice most fo these 52 pages I just read through was totally useless, was people wanting whole thing working for free, people flaming or people advertising their servers - waste fo 2 hours of reading through 100 pages on this forum

Fixed that and auth, shows no errors at all but still cant connect now

Ok well got all working but damn thing just not communicating right with db so guess Ill start trying different authd

Bazhon · Aug 26, 2012

This server uses the cliet version 0.84?

Exotic2012 · Aug 26, 2012

Ill be releasing a repack on a vmware setup soon with client and the vm and instructions on how to get it going
May be a few days Im pretty busy running 4 servers atm

PockieNinja · Aug 30, 2012

Manova said:
Dude,
You must be registered to see links
Halcyon just launched today. :/

For specific details regarding this suspension, please contact Perfect World Entertainment's Customer Service Group via the ticketing system

Bazhon · Aug 31, 2012

This server uses the cliet version 0.84?

Bazhon · Sep 3, 2012

uebari said:
Hey everyone,

I'm happy to announce as my big thing for this year and kinda to piss off a few people, to finally release the Forsaken World server files, these files are compatible with Forsaken World Celestia or possibly even the Forsaken World Halcyon clients. Though these files are raw and have no instructions I think it would be good for the community to band together to create it's own section and possibly even post the instructions on how to put this together.

These files require RHEL ( Red Hat Enterprise Linux ) or any flavour such as CentOS / Fedora Core.

These files were released on the premise of people trying to figure them out and helping each other, don't be so stubborn to tell people on how you set them up. This is a public release not a private one for bigotry and ignorance.

----

Server Files :

MF MIRRORS

You must be registered to see links

You must be registered to see links

You must be registered to see links

Uploading Mirror

You must be registered to see links

Leak Provided by Warv0x

could you please reup the link?
are broken thanks

Bazhon · Sep 4, 2012

what good could upgrade nigthfall ^ ^

kalilyrr · Sep 6, 2012

Thanks for sharing the information Mhan. I really appreciate it a lot.

alladyn5 · Sep 6, 2012

edit the file .. tasks.data / gshop.data ?? what program

Welcome!

Forsaken World [ Server Files ]

Skilled Illusionist

Initiate Mage

Initiate Mage

Newbie Spellweaver

Initiate Mage

Junior Spellweaver

Attachments

Experienced Elementalist

Newbie Spellweaver

Newbie Spellweaver

Don't Ask About Tideborn

Don't Ask About Tideborn

Skilled Illusionist

Newbie Spellweaver

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

RaGEZONE Sponsor

About Us

Forum statistics

Partners