Newbie Spellweaver
- Joined
- Mar 15, 2009
- Messages
- 52
- Reaction score
- 1
I'll send anyone who wants GM tool existed in...
.pck Tool
https://mega.co.nz/#!oEAC3ZCB!N3niws9MICCQL8RftcNXYWtIlXl5Hy9-5d2wwKfRitA
interfaces.pck not valid packed.
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
I'll send anyone who wants GM tool existed in...
.pck Tool
https://mega.co.nz/#!oEAC3ZCB!N3niws9MICCQL8RftcNXYWtIlXl5Hy9-5d2wwKfRitA
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
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.
gs001: warning:GProviderClient::OnAbortSession,sid=0,lineid=1,is_del=0
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
[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]
download gs and gsalias1 mine
https://mega.co.nz/#!zdlBnA4J!2g29tMwpZZSHCZMqS77vq7cCFJCstOZnVczEbBtgM-I
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
https://mega.co.nz/#!OUM3wJgL!JCJBIwsLUp7yAvS3l4uyEVDMaCKLhnX7ra1_VlslF98
----------------------------------update --------------------------------------------------
there's no fix for cash to mysql authd system
Use debug command for cash. for the people that are using mysql
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
how private servers will work giving cash for players in debug mode ? , and about another player use this console ?
plz help fix this