[Release]BOI Odin Patch - Best and stable release

outdated

Re: [Release]BOI Odin Patch - Best and stable release

I like the changes I will try it out.

Re: [Release]BOI Odin Patch - Best and stable release

where is the database?

Re: [Release]BOI Odin Patch - Best and stable release

sorry ^^
Data Base Download Link

Re: [Release]BOI Odin Patch - Best and stable release

i doesn't connect to mysql? why?

Re: [Release]BOI Odin Patch - Best and stable release

It works fine.. If you did a fresh install Centos or linux and install mysql make sure your password on linux side is "game". If its MSSQL recheck your MSSQL name.

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by NanayaQ

It works fine.. If you did a fresh install Centos or linux and install mysql make sure your password on linux side is "game". If its MSSQL recheck your MSSQL name.

How to install mysql? i use toss last repack but i dont know commands ( grant all *.* ...)

Re: [Release]BOI Odin Patch - Best and stable release

Please help up

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by asere

How to install mysql? i use toss last repack but i dont know commands ( grant all *.* ...)

mysql --user=root --pass=game
CREATE USER 'host'@'192.168.137.1' IDENTIFIED BY 'pw';
GRANT ALL PRIVILEGES ON *.* TO 'host'@'192.168.137.1' WITH GRANT OPTION;

Re: [Release]BOI Odin Patch - Best and stable release

@nec, you have the files NPC Natasha unlock Exalted System same in BOI Oracle ?

Re: [Release]BOI Odin Patch - Best and stable release

Can you tell me which client should I use ? Thanks for your release

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by Yeikel

Can you tell me which client should I use ? Thanks for your release

Battle of Immortals Odin Wraith

Re: [Release]BOI Odin Patch - Best and stable release

http://u1312.hizliresim.com/1j/4/v4zt9.jpg

What is problem?

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by palamon123

@nec, you have the files NPC Natasha unlock Exalted System same in BOI Oracle ?

yes

put this line on any npc option or on player.s under OnLogin function

Quote:

ActivateFieldLevel(-1)

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by asere

http://u1312.hizliresim.com/1j/4/v4zt9.jpg

What is problem?

Check your firewall and IP, make sure you turn off firewall on linux side and window side unless you "ruled the port" them.

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by NanayaQ

Check your firewall and IP, make sure you turn off firewall on linux side and window side unless you "ruled the port" them.

i turn off firewall linux and windows. i defined 1433 and 3306 port windows, checked ip auth files and key similiar on both 2 sides but show same error.

auagent.conf

Code:

[AuAgentServer] zoneid = 904 aid = 9 type = tcp port = 29250 address = 192.168.2.2 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/m_trace.link [GameDBClient] type = tcp port = 29251 address = 192.168.2.137 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 tcp_nodelay = 1 ;listen_backlog = 10 mtrace = /tmp/m_trace.link cashfile = d:\cash_backup.data [GAuthClient] type = tcp port = 29200 address = 192.168.2.137 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 409600 obuffermax = 819200 ;so_broadcast = 1 tcp_nodelay = 1 osec = 2 oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds isec = 2 iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje ;if use certverify between au,1:use,0:not use,default use issupport_cert = 0 [ThreadPool] config = (1,1)(2,4)(3,2) max_queuesize = 1048576 ;prior_strict = 1 [SpeedLimit] window = 20 high = 2 [TimeoutLimit] ;window > 60 window = 180 high = 200 [CouponLimit] ;GetUserCoupon limit window = 300 high = 2 [CouponExchangeLimit] ;CouponExchange limit window = 120 high = 2

bin/authd.conf

Code:

[GAuthServer] type = tcp port = 29200 address = 192.168.2.137 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/mtrace.authd osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje isabroad = true ismssql = true [ThreadPool] config = (1,1)(2,10)(3,1)(101,5) max_queuesize = 1048576

config/authd.conf

Code:

[GAuthServer] type = tcp port = 29200 address = 192.168.2.137 so_sndbuf = 131072 so_rcvbuf = 131072 ibuffermax = 819200 obuffermax = 819200 tcp_nodelay = 1 listen_backlog = 10 mtrace = /tmp/mtrace.authd osec = 2 oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l isec = 2 iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje isabroad = true ismssql = true [ThreadPool] config = (1,1)(2,10)(3,1)(101,5) max_queuesize = 1048576

table.xml

Code:

<?xml version="1.0" encoding="ISO-8859-1"?> <?xml-stylesheet type="text/xsl" href="table.xsl"?> <application debug="false" beans="com.wanmei.db.passport" beanbase="src/beans"> <connection name="auth0" poolsize="8" url="jdbc:microsoft:sqlserver://192.168.2.2:1433;databasename=PassBOI" username="sa" password="94856461"/> <driver name="com.microsoft.jdbc.sqlserver.SQLServerDriver" /> <cache name="account_by_id" type="reference" ip="226.1.1.1" port="4444" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="account_by_name" type="reference" ip="226.1.1.1" port="4445" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="function_by_id" type="direct" ip="226.1.1.2" port="4446" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="forbid_by_id" type="direct" ip="226.1.1.3" port="4447" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="matrix_by_uid" type="direct" ip="226.1.1.4" port="4448" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="phoneuser_by_phone" type="direct" ip="226.1.1.5" port="4449" local_ip="192.168.2.137" size="262144" partition="0"/> <cache name="userinfo_by_id" type="direct" ip="226.1.1.6" port="4450" local_ip="192.168.2.137" size="131072" partition="0"/> <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="awardnew" connection="auth0" operate="replaceA"> <column name="rid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="number" sql-type="char(8)" java-type="java.lang.String" not-null="true" /> <primarykey name="pk_awardnew" column="number" /> <index name="ind_awardnew_rid" column="rid" /> </table> <table name="awardrecord" connection="auth0" operate="replaceA"> <column name="id" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="code" sql-type="varchar(8)" java-type="java.lang.String" not-null="true" /> <column name="number" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="endtime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="creator" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="creatime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="auditor" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="auditime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="status" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> 0: create 1: available 2: overdue <column name="func" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="used" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_awardrecord" column="id" /> </table> <table name="awardused" connection="auth0" operate="replaceA"> <column name="rid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="number" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="namefrom" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="nameto" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="usedate" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="ip" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_awardused" column="number" /> <index name="ind_nameto" column="nameto" /> <index name="ind_usedate" column="usedate" /> </table> <table name="cardnew" connection="auth0" operate="replaceA"> <column name="rid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="number" sql-type="char(25)" java-type="java.lang.String" not-null="true" /> <column name="status" sql-type="tinyint" java-type="java.lang.Integer" not-null="true" /> 0: create 1: available 2: overdue <primarykey name="pk_cardnew" column="number" /> <index name="ind_cardnew_rid" column="rid" /> </table> <table name="cardrecord" connection="auth0" operate="replaceA"> <column name="id" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="code" sql-type="varchar(12)" java-type="java.lang.String" not-null="true" /> <column name="number" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="price" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="rate" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="pointcard" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="exchangepoint" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="endtime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="creator" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="creatime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="auditor" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="auditime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="status" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> 0: create 1: available 2: overdue <column name="func" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="funcparm" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="used" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="score" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_cardrecord" column="id" /> </table> <table name="cardused" connection="auth0" operate="replaceA"> <column name="rid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="number" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="namefrom" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="nameto" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="usedate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <column name="ip" 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="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_cardused" column="number" /> <index name="ind_nameto" column="nameto" /> <index name="ind_usedate" column="usedate" /> </table> <table name="cardstatuslog" connection="auth0" operate="replaceA"> <column name="date" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <column name="fromnumber" sql-type="char(25)" java-type="java.lang.String" not-null="true" /> <column name="tonumber" sql-type="char(25)" java-type="java.lang.String" not-null="true" /> <column name="fromstatus" sql-type="tinyint" java-type="java.lang.Integer" not-null="true" /> <column name="tostatus" sql-type="tinyint" java-type="java.lang.Integer" not-null="true" /> <column name="op" sql-type="varchar(32)" java-type="java.lang.String" not-null="true" /> <column name="retcount" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_cardstatuslog" column="date" /> </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="byte[]" 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="point_free" 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="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="lastlogin" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <primarykey name="pk_id" column="uid, aid" /> </table> <table name="function" connection="auth0" operate="replaceA"> <column name="uid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="adduptime" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="score" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="func" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="funcparm" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="addupmoney" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="adduppoint" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="addupscore" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="coin" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="addupcoin" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="soldpoint" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_id" column="uid" /> </table> <table name="users" connection="auth0" operate="replaceA"> <column name="id" sql-type="integer" java-type="java.lang.Integer" 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="qq" sql-type="varchar(32)" java-type="java.lang.String" not-null="false" /> <column name="passwd2" sql-type="binary(16)" java-type="byte[]" not-null="false" /> <primarykey name="pk_id" column="id" /> </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="char(16)" java-type="java.lang.String" not-null="true" /> <column name="passwd" sql-type="binary(16)" java-type="byte[]" 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="true" /> <primarykey name="pk_account" column="id" /> <index name="ind_name" unique="true" column="name" /> <index name="ind_creatime" column="creatime" /> </table> <table name="usb_key" connection="auth0" operate="replaceA"> <column name="sn" sql-type="binary(8)" java-type="byte[]" not-null="true" /> <column name="passwd" sql-type="binary(16)" java-type="byte[]" not-null="true" /> <column name="refcnt" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_id" column="sn" /> </table> <table name="agentbill" connection="auth0" operate="replaceA"> <column name="billid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="agent" sql-type="char(1)" java-type="java.lang.String" not-null="true" /> <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="cardtype" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="money" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="addpoint" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="addscore" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="usedate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <column name="cookie1" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="cookie2" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="addcoin" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="awarduid" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="awardpoint" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="awardscore" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_agentbill" column="billid, agent" /> <index name="ind_agentbill_uidaid" column="uid,aid" /> <index name="ind_agentbill_usedate" column="usedate" /> </table> <table name="max_ids" connection="auth0" operator="replaceA"> <column name="type" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="maxid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <primarykey name="pk_max_ids" column="type" />  </table> <table name="monthbill" 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="usepoint" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="monthcount" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="enddate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <column name="usedate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <index name="ind_monthbill_uidaid" column="uid,aid" /> <index name="ind_monthbill_usedate" column="usedate" /> </table> <table name="innerbill" 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="addpoint" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="operator" sql-type="varchar(19)" java-type="java.lang.String" not-null="true" /> <column name="enddate" sql-type="datetime" java-type="java.util.Date" not-null="false" /> <column name="usedate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <column name="monthcount" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="addscore" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <index name="ind_innerbill_uidaid" column="uid,aid" /> <index name="ind_innerbill_usedate" column="usedate" /> </table> <table name="translog" connection="auth0" operate="replaceA"> <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="serial" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="seller" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="sellid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="buyer" sql-type="integer" java-type="java.lang.Integer" not-null="true"/> <column name="price" 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="aid" 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="date" sql-type="datetime" java-type="java.util.Date" not-null="true"/> <primarykey name="pk_translog" column="zoneid, serial" /> <index name="ind_translog_seller" column="seller" /> <index name="ind_translog_buyer" column="buyer" /> <index name="ind_translog_date" column="date" /> </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"/>  <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"/> <index name="ind_usecashnow_uzs" unique="true" column="userid, zoneid, sn" /> <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> <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" /> <column name="autolock" sql-type="char(1)" java-type="java.lang.String" not-null="false" /> <primarykey name="pk_iplimit" column="uid" /> </table> <table name="mobilekey" connection="auth0" operate="replaceA"> <column name="uid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="mobilealgorithm" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="mobilekey" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_mobilekey" column="uid" /> </table> <table name="matrix" connection="auth0" operate="replaceA"> <column name="uid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="recordid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="matrixid" sql-type="char(12)" java-type="java.lang.String" not-null="true" /> <column name="matrix" sql-type="binary(80)" java-type="byte[]" not-null="true" /> <primarykey name="pk_matrix" column="uid" /> </table> <table name="awardpoint" connection="auth0" operate="replaceA"> <column name="fromuid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="touid" 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="score" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="awarddate" sql-type="datetime" java-type="java.util.Date" not-null="true"/> <column name="usedate" sql-type="datetime" java-type="java.util.Date" not-null="false"/> <primarykey name="pk_awardpoint" column="fromuid" /> <index name="ind_awardpoint_touid" column="touid" /> </table> <table name="matrixrecord" connection="auth0" operate="replaceA"> <column name="id" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="code" sql-type="varchar(12)" java-type="java.lang.String" not-null="true" /> <column name="number" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="price" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="rate" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="expiredtime" sql-type="datetime" java-type="java.sql.Timestamp" not-null="true" /> <column name="creator" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="creatime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="auditor" sql-type="varchar(64)" java-type="java.lang.String" not-null="true" /> <column name="auditime" sql-type="datetime" java-type="java.lang.String" not-null="true" /> <column name="status" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> 0: create 1: available 2: overdue <column name="reserve1" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="reserve2" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="reserve3" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="reserve4" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_matrixrecord" column="id" /> </table> <table name="matrixnew" connection="auth0" operate="replaceA"> <column name="recordid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="id" sql-type="varchar(12)" java-type="java.lang.String" not-null="true" /> <column name="matrix" sql-type="varbinary(80)" java-type="byte[]" not-null="false" /> <primarykey name="pk_id" column="id" /> <index name="ind_matrixnew_rid" column="recordid" /> </table> <table name="matrixused" connection="auth0" operate="replaceA"> <column name="id" sql-type="char(12)" java-type="java.lang.String" not-null="true" /> <column name="matrix" sql-type="binary(80)" java-type="byte[]" not-null="false" /> <column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <column name="begindate" sql-type="datetime" java-type="java.util.Date" not-null="false" /> <column name="canceldate" sql-type="datetime" java-type="java.util.Date" not-null="false" /> <column name="ip" sql-type="integer" java-type="java.lang.Integer" not-null="false" /> <primarykey name="pk_id" column="id" /> <index name="ind_matrixused_userid" column="userid" /> </table> <table name="phone" connection="auth0" operator="replaceA"> <column name="uid" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="phone" sql-type="char(16)" java-type="java.lang.String" not-null="true" /> <primarykey name="pk_uid" column="uid,phone" /> <index name="ind_phone" column="phone" /> </table> <table name="onlineinfo" connection="auth0" operate="replaceA"> <column name="account_pay" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="account_pay_now" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="account_month" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="account_month_now" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="online_total" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="online_pay" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="online_month" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="online_freesvr" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="online_freesvr_payed" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="statdate" sql-type="datetime" java-type="java.util.Date" not-null="true" /> <index name="ind_onlineinfo_statdate" column="statdate" /> </table> <table name="indulge" connection="auth0" operator="replaceA"> <column name="id" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <column name="name" sql-type="varbinary(32)" java-type="byte[]" not-null="true" /> <column name="idcard" sql-type="char(18)" java-type="java.lang.String" not-null="true" /> <column name="verfied" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <primarykey name="pk_indulge" column="id" /> <index name="ind_indulge_idcard" column="idcard" /> </table> <table name="activecode" connection="auth0" operator="replaceA"> <column name="code" sql-type="varchar(16)" java-type="java.lang.String" not-null="true" /> <primarykey name="pk_activecode" column="code" /> </table> <query name="getIndulgeUserInfo"> <table name="indulge" alias="i" /> <column name="id" column="i.id" /> <column name="name" column="i.name" /> <column name="idcard" column="i.idcard" /> <column name="verfied" column="i.verfied" /> <select name="byId" condition="WHERE i.id = ?"/> <select name="byName" condition="WHERE i.id = (SELECT id FROM account WHERE name=?)"/> <select name="byIdcard" condition="WHERE i.idcard = ?"/> </query> <procedure name="existsIndulge" connection="auth0" operate="replaceB"> <parameter name="idcard" sql-type="char(18)" java-type="java.lang.String" in="true" out="false" /> <parameter name="truename" sql-type="varbinary(32)" java-type="byte[]" in="true" out="false" /> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="verfied" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> SELECT TOP 1 @uid = id, @verfied = verfied FROM indulge WHERE idcard = @idcard AND @truename = name IF @@rowcount = 1 return 1 return 0 </procedure> <procedure name="recordIndulgeUser" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name"/> <parameter name="truename" sql-type="varbinary(32)" java-type="byte[]" in="true" out="false" /> <parameter name="idcard" sql-type="char(18)" java-type="java.lang.String" in="true" out="false" /> <parameter name="verfied" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @uid integer SELECT @uid = id FROM account WHERE name = @name IF @@rowcount = 1 BEGIN UPDATE indulge SET name = @truename, idcard = @idcard, verfied = @verfied WHERE id = @uid IF @@rowcount = 0 INSERT INTO indulge (id, name, idcard, verfied) VALUES (@uid, @truename, @idcard, @verfied) IF @@rowcount = 0 BEGIN COMMIT TRAN return 1 END IF @verfied = 1 OR @verfied = 17 UPDATE account SET usertype = usertype | 1572864 WHERE id = @uid --0x180000 ELSE UPDATE account SET usertype = (usertype & ~1048576) | 524288 WHERE id = @uid --0x80000 COMMIT TRAN return 0 END COMMIT TRAN return 1 </procedure> <procedure name="updateIndulge" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id"/> <parameter name="verfied" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN UPDATE indulge SET verfied = @verfied WHERE id = @uid IF @@rowcount = 1 BEGIN IF @verfied = 1 OR @verfied = 17 UPDATE account SET usertype = usertype | 1572864 WHERE id = @uid --0x180000 ELSE UPDATE account SET usertype = (usertype & ~1048576) WHERE id = @uid --0x100000 COMMIT TRAN return 0 END COMMIT TRAN return 1 </procedure> <procedure name="addactivecode" connection="auth0" operate="replaceA"> <parameter name="code0" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code1" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code2" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code3" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code4" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code5" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code6" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code7" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code8" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="code9" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> BEGIN TRAN IF EXISTS (SELECT * FROM activecode HOLDLOCK WHERE code IN(@code0,@code1,@code2,@code3,@code4,@code5,@code6,@code7,@code8,@code9)) BEGIN rollback tran return -1 END INSERT INTO activecode (code) VALUES (@code0) INSERT INTO activecode (code) VALUES (@code1) INSERT INTO activecode (code) VALUES (@code2) INSERT INTO activecode (code) VALUES (@code3) INSERT INTO activecode (code) VALUES (@code4) INSERT INTO activecode (code) VALUES (@code5) INSERT INTO activecode (code) VALUES (@code6) INSERT INTO activecode (code) VALUES (@code7) INSERT INTO activecode (code) VALUES (@code8) INSERT INTO activecode (code) VALUES (@code9) COMMIT TRAN </procedure> <procedure name="activeUser" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="code" sql-type="varchar(16)" java-type="java.lang.String" in="true" out="false" /> <parameter name="type" 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" /> BEGIN TRAN DECLARE @usertype integer SELECT @error = -1 SELECT @usertype = usertype FROM account WHERE name = @name IF @@rowcount = 1 BEGIN IF 16>@type AND NOT (@usertype&@type) = @type BEGIN DELETE FROM activecode WHERE code = @code IF @@rowcount = 1 BEGIN UPDATE account SET usertype = usertype | @type WHERE name = @name IF @@rowcount = 1 SELECT @error = 0 ELSE INSERT INTO activecode ( code ) VALUES ( @code ) END ELSE SELECT @error = 3 END ELSE SELECT @error = 2 END ELSE SELECT @error = 1 COMMIT TRAN </procedure> <query name="getActivecode"> <table name="activecode" alias="a" /> <column name="code" column="a.code" /> <select name="byCode" condition="WHERE a.code = ?" /> </query> <query name="getUserid"> <table name="account" 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="qq" column="u.qq" /> <select name="byId" condition="WHERE u.id = ?" cache="userinfo_by_id" key="id"/> </query> <query name="getUsername"> <table name="account" alias="u" /> <column name="name" column="u.name" /> <select name="byId" condition="WHERE u.id = ?"/> </query> <procedure name="tryLogin" connection="auth0" operate="replaceB"> <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="byte[]" in="true" out="false" /> IF EXISTS ( SELECT * FROM account WHERE @name = name AND @passwd = passwd ) return 1 ELSE return 0 </procedure> <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="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="enable" column="i.enable" /> <column name="lockstatus" column="i.lockstatus" /> <column name="autolock" column="i.autolock" /> <select name="byUid" condition="WHERE i.uid = ?"/> </query> <query name="acquireIdPasswd"> <table name="account" alias="u" /> <column name="id" column="u.id" /> <column name="name" compute="rtrim(u.name)" java-type="String" /> <column name="passwd" column="u.passwd" /> <column name="creatime" column="u.creatime" /> <column name="usertype" column="u.usertype" /> <select name="byName" condition="WHERE u.name = ?" cache="account_by_name" key="name"/> <select name="byId" condition="WHERE u.id = ?" cache="account_by_id" key="id"/> </query> <query name="acquireIdPasswd2"> <table name="account" alias="a" /> <table name="users" alias="u" /> <column name="id" column="u.id" /> <column name="passwd2" column="u.passwd2" /> <select name="byName" condition="WHERE a.id=u.id AND a.name = ?"/> </query> <query name="acquireForbid" cachevalue="multi"> <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 = ?" cache="forbid_by_id" key="userid"/> </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="acquireUserCreatime"> <table name="account" alias="u" /> <column name="creatime" column="u.creatime" /> <select name="byUid" condition="WHERE u.id = ?"/> </query> <query name="acquireUserType"> <table name="account" alias="u" /> <column name="usertype" column="u.usertype" /> <select name="byName" condition="WHERE u.name = ?"/> </query> <query name="acquirePrivilege"> <table name="auth" alias="au" /> <table name="account" alias="u" /> <column name="userid" column="au.userid" /> <column name="zoneid" column="au.zoneid" /> <column name="rid" column="au.rid" /> <column name="name" column="u.name" /> <column name="creatime" column="u.creatime" /> <select name="byZid" condition="WHERE au.userid = u.id AND au.zoneid = ?"/> <select name="byUid" condition="WHERE au.userid = u.id AND au.userid = ?"/> <select name="byUidZid" condition="WHERE au.userid = u.id AND au.userid = ? AND au.zoneid = ?"/> <select name="byRidZid" condition="WHERE au.userid = u.id AND au.rid = ? AND au.zoneid = ?"/> <select name="byAll" condition="WHERE au.userid = u.id"/> </query> <query name="getfunction" cachevalue="empty"> <table name="function" alias="f"/> <column name="uid" column="f.uid"/> <column name="adduptime" column="f.adduptime"/>  <column name="score" column="f.score"/> <column name="func" column="f.func"/> <column name="funcparm" column="f.funcparm"/> <column name="addupmoney" column="f.addupmoney"/> <column name="adduppoint" column="f.adduppoint"/> <column name="addupscore" column="f.addupscore"/> <column name="coin" column="f.coin"/> <column name="addupcoin" column="f.addupcoin"/> <column name="soldpoint" column="f.soldpoint"/> <select name="byuid" condition="WHERE f.uid = ?" cache="function_by_id" key="uid"/> </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 < dateadd(second,-200,getdate())"/> <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="delUserPriv" connection="auth0" operate="replaceB"> <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <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" /> BEGIN TRAN IF @deltype = 0 DELETE FROM auth WHERE userid = @userid AND zoneid = @zoneid AND rid = @rid ELSE IF @deltype = 1 DELETE FROM auth WHERE userid = @userid AND zoneid = @zoneid ELSE IF @deltype = 2 DELETE FROM auth WHERE userid = @userid IF NOT EXISTS (SELECT * FROM auth WHERE userid = @userid) UPDATE account SET usertype = usertype & ~131072 WHERE id = @userid --0x20000 COMMIT TRAN </procedure> <procedure name="addUserPriv" connection="auth0" operate="replaceB"> <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <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" /> BEGIN TRAN INSERT INTO auth VALUES( @userid, @zoneid, @rid ) UPDATE account SET usertype = usertype|131072 WHERE id = @userid --0x20000 COMMIT TRAN </procedure> <procedure name="changePasswd" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name"/> <parameter name="passwd" sql-type="binary(16)" java-type="byte[]" in="true" out="false" /> UPDATE account SET passwd=@passwd WHERE name=@name </procedure> <procedure name="changePasswd2" connection="auth0" operate="replaceB">  <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="byte[]" in="true" out="false" /> UPDATE users SET passwd2=@passwd2 FROM users u,account a WHERE a.name=@name AND a.id=u.id </procedure> <procedure name="queryusbkey" connection="auth0" operate="replaceA">  <parameter name="sn" sql-type="binary(8)" java-type="byte[]" in="true" out="false" /> <parameter name="passwd" sql-type="binary(16)" java-type="byte[]" in="false" out="true"/> SELECT @passwd = NULL SELECT @passwd = passwd FROM usb_key WHERE sn = @sn IF (@@rowcount != 1) BEGIN return -1 END </procedure> <procedure name="bindKey" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="sn" sql-type="binary(8)" java-type="byte[]" in="true" out="false" /> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="false" out="true"/> BEGIN TRAN DECLARE @passwd binary(16) DECLARE @usertype_old integer DECLARE @refcnt integer SELECT @error = -1 SELECT @passwd = passwd, @refcnt = refcnt FROM usb_key WHERE sn = @sn IF @@rowcount = 0 SELECT @error = 2 ELSE IF @refcnt > 0 SELECT @error = 5 ELSE BEGIN SELECT @usertype_old = usertype FROM account where name = @name IF @@rowcount = 0 SELECT @error = 1 ELSE IF (@usertype_old & 240) > 0 --0xF0 SELECT @error = 3 ELSE BEGIN UPDATE account SET passwd = @passwd, usertype = (usertype&-241)|48 WHERE name = @name --0xFFFFFF0F,0x30 IF @@rowcount = 1 BEGIN SELECT @error = 0 UPDATE usb_key SET refcnt = refcnt + 1 WHERE sn = @sn END END END COMMIT TRAN </procedure> <procedure name="unbindKey" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="passwd" sql-type="binary(16)" java-type="byte[]" in="true" out="false" /> <parameter name="sn" sql-type="binary(8)" java-type="byte[]" in="true" out="false" /> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="false" out="true"/> BEGIN TRAN DECLARE @usertype_old integer DECLARE @passwd_old binary(16) SELECT @error = -1 SELECT @passwd_old = passwd, @usertype_old = usertype FROM account where name = @name IF @@rowcount = 0 SELECT @error = 1 ELSE IF NOT (@usertype_old & 240) = 48 --0xF0,0x30 SELECT @error = 2 ELSE IF NOT @passwd_old = (SELECT passwd FROM usb_key WHERE sn = @sn) SELECT @error = 3 ELSE BEGIN UPDATE account SET passwd = @passwd, usertype = (usertype&-241) WHERE name = @name --0xFFFFFF0F IF @@rowcount = 1 BEGIN SELECT @error = 0 UPDATE usb_key SET refcnt = refcnt - 1 WHERE sn = @sn END END COMMIT TRAN </procedure> <procedure name="updateUserInfoById" connection="auth0" operate="replaceB"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="userinfo_by_id"/> <parameter name="prompt" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="answer" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="truename" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="idnumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="email" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="mobilenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="province" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="city" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="phonenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="address" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="postalcode" sql-type="varchar(8)" java-type="byte[]" 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="byte[]" in="true" out="false" /> UPDATE users set prompt=@prompt,answer=@answer,truename=@truename,idnumber=@idnumber,email=@email,mobilenumber=@mobilenumber,province=@province,city=@city,phonenumber=@phonenumber,address=@address,postalcode=@postalcode,gender=@gender,birthday=@birthday,qq=@qq FROM users WHERE @id=id </procedure> <procedure name="deleteTimeoutForbid" connection="auth0" operate="replaceB"> <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;forbid_by_id" /> BEGIN TRAN DELETE FROM forbid WHERE userid=@userid AND datediff(ss,ctime,getdate())>forbid_time IF NOT EXISTS (SELECT * FROM forbid WHERE userid=@userid) UPDATE account SET usertype = usertype & ~262144 WHERE id=@userid COMMIT TRAN </procedure> <procedure name="deleteForbid" connection="auth0" operate="replaceB"> <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;forbid_by_id" /> <parameter name="type" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> BEGIN TRAN DELETE FROM forbid WHERE userid=@userid AND type=@type IF NOT EXISTS (SELECT * FROM forbid WHERE userid=@userid) UPDATE account SET usertype = usertype & ~262144 WHERE id=@userid COMMIT TRAN </procedure> <procedure name="addForbid" connection="auth0" operate="replaceB"> <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;forbid_by_id" /> <parameter name="type" sql-type="integer" java-type="java.lang.Integer" 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="byte[]" in="true" out="false"/> <parameter name="gmroleid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> BEGIN TRAN DECLARE @old_ctime datetime DECLARE @old_forbid_time integer IF @forbid_time > 2 BEGIN SELECT @old_ctime = ctime, @old_forbid_time = forbid_time FROM forbid WHERE userid=@userid AND type=@type IF @@rowcount = 0 BEGIN INSERT INTO forbid VALUES(@userid,@type,getdate(),@forbid_time,@reason,@gmroleid) UPDATE account SET usertype = usertype|262144 WHERE id = @userid --0x40000 END ELSE IF dateadd(second,@forbid_time,getdate()) > dateadd(second,@old_forbid_time,@old_ctime) BEGIN UPDATE forbid SET ctime=getdate(),forbid_time=@forbid_time,reason=@reason,gmroleid=@gmroleid WHERE userid=@userid AND type=@type END END ELSE BEGIN DELETE FROM forbid WHERE userid=@userid AND type=@type IF NOT EXISTS (SELECT * FROM forbid WHERE userid=@userid) UPDATE account SET usertype = usertype & ~262144 WHERE id=@userid END COMMIT TRAN </procedure> <procedure name="setiplimit" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <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"/> BEGIN TRAN UPDATE iplimit SET ipaddr1=@ipaddr1,ipmask1=@ipmask1,ipaddr2=@ipaddr2,ipmask2=@ipmask2,ipaddr3=@ipaddr3,ipmask3=@ipmask3 WHERE uid=@uid IF @@rowcount = 0 BEGIN INSERT INTO iplimit (uid,ipaddr1,ipmask1,ipaddr2,ipmask2,ipaddr3,ipmask3,enable) VALUES (@uid,@ipaddr1,@ipmask1,@ipaddr2,@ipmask2,@ipaddr3,@ipmask3,'t') UPDATE account SET usertype = usertype|65536 WHERE id = @uid --0x10000 END COMMIT TRAN </procedure> <procedure name="enableiplimit" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <parameter name="enable" sql-type="char(1)" java-type="java.lang.String" in="true" out="false"/> BEGIN TRAN UPDATE iplimit SET enable=@enable WHERE uid=@uid IF @@rowcount = 0 BEGIN INSERT INTO iplimit (uid,enable) VALUES (@uid,@enable) UPDATE account SET usertype = usertype|65536 WHERE id = @uid --0x10000 END COMMIT TRAN </procedure> <procedure name="enableautolock" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <parameter name="autolock" sql-type="char(1)" java-type="java.lang.String" in="true" out="false"/> BEGIN TRAN UPDATE iplimit SET autolock=@autolock WHERE uid=@uid IF @@rowcount = 0 BEGIN INSERT INTO iplimit (uid,autolock) VALUES (@uid,@autolock) UPDATE account SET usertype = usertype|65536 WHERE id = @uid --0x10000 END COMMIT TRAN </procedure> <procedure name="lockuser" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <parameter name="lockstatus" sql-type="char(1)" java-type="java.lang.String" in="true" out="false"/> BEGIN TRAN UPDATE iplimit SET lockstatus=@lockstatus WHERE uid=@uid IF @@rowcount = 0 BEGIN INSERT INTO iplimit (uid,lockstatus,enable) VALUES (@uid,@lockstatus,'t') UPDATE account SET usertype = usertype|65536 WHERE id = @uid --0x10000 END COMMIT TRAN </procedure> <procedure name="testandlockuser" connection="auth0" operate="replaceA"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> UPDATE iplimit SET lockstatus='t' WHERE uid=@uid and autolock='t' </procedure> <procedure name="sellpoint" connection="auth0" operate="replaceB"> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="true"/> <parameter name="zoneid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> <parameter name="serial" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> <parameter name="seller" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id"/> <parameter name="sellid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> <parameter name="buyer" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> <parameter name="price" 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="aid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/> BEGIN TRAN DECLARE @trans_status integer DECLARE @seller_point integer DECLARE @buyer_point integer SELECT @trans_status=status FROM translog WHERE zoneid=@zoneid AND serial=@serial IF @@rowcount=0 BEGIN UPDATE point SET time=time-@point WHERE uid=@seller AND aid=@aid AND time>@point+135000-18000 IF @@rowcount=1 BEGIN UPDATE point SET time=time+@point WHERE uid=@buyer AND aid=@aid IF @@rowcount=0 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@buyer,@aid,@point+36000,0,0,'','','') SELECT @status=1 INSERT INTO translog (zoneid,serial,seller,sellid,buyer,price,point,aid,status,date) VALUES(@zoneid,@serial,@seller,@sellid,@buyer,@price,@point,@aid,@status,getdate()) UPDATE function SET soldpoint=soldpoint+@point WHERE @seller = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES ( @seller,0,0,0,0,0,0,0,0,0,@point) END ELSE BEGIN SELECT @status=0 INSERT INTO translog (zoneid,serial,seller,sellid,buyer,price,point,aid,status,date) VALUES(@zoneid,@serial,@seller,@sellid,@buyer,@price,@point,@aid,@status,getdate()) END END ELSE SELECT @status=@trans_status COMMIT TRAN </procedure>  <procedure name="usecash" connection="auth0" operate="replaceB"> <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"/> BEGIN TRAN DECLARE @sn_old integer DECLARE @aid_old integer DECLARE @point_old integer DECLARE @cash_old integer DECLARE @status_old integer DECLARE @creatime_old datetime DECLARE @need_restore integer DECLARE @exists integer SELECT @error = 0 SELECT @need_restore = 0 SELECT @sn_old=sn,@aid_old=aid,@point_old=point,@cash_old=cash,@status_old=status,@creatime_old=creatime FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND sn>=0 IF @@rowcount = 1 SELECT @exists = 1 ELSE SELECT @exists = 0 IF @status = 0 BEGIN IF @exists = 0 BEGIN SELECT @sn_old=sn,@aid_old=aid,@point_old=point,@cash_old=cash,@status_old=status,@creatime_old=creatime FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn=sn IF @@rowcount = 1 BEGIN SELECT @point_old = ISNULL(@point_old,0) UPDATE point SET time=time-@point_old WHERE @userid=uid AND @aid_old=aid AND time>=@point_old IF @@rowcount = 1 BEGIN DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn=sn INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, 0, @aid_old, @point_old, @cash_old, 1, @creatime_old ) END ELSE SELECT @error = -8 END ELSE SELECT @error = -12 END ELSE SELECT @error = -7 END ELSE IF @status = 1 BEGIN IF @exists = 0 BEGIN UPDATE point SET time=time-@point WHERE @userid=uid AND @aid=aid AND time>=@point IF @@rowcount = 1 INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn, @aid, @point, @cash, @status, getdate() ) ELSE BEGIN INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn SELECT @error = -8 END END ELSE BEGIN INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn SELECT @error = -7 END END ELSE IF @status = 2 BEGIN IF @exists = 1 AND @status_old = 1 AND @sn_old = 0 BEGIN DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn, @aid_old, @point_old, @cash_old, @status, @creatime_old ) END ELSE BEGIN SELECT @error = -9 END END ELSE IF @status = 3 BEGIN IF @exists = 1 AND @status_old = 2 BEGIN DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old ) END ELSE BEGIN SELECT @error = -10 END END ELSE IF @status = 4 BEGIN IF @exists = 1 BEGIN DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old, getdate() ) END IF NOT (@exists = 1 AND @status_old = 3) SELECT @error = -11 END ELSE BEGIN SELECT @error = -12 END IF @need_restore = 1 BEGIN UPDATE point SET time=time+@point_old WHERE @userid=uid AND @aid_old=aid DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old, getdate() ) END COMMIT TRAN </procedure> <procedure name="addusecashnow" connection="auth0" operate="replaceB"> <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="aid" 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"/> BEGIN TRAN DECLARE @sn_old integer DECLARE @aid_old integer DECLARE @point_old integer DECLARE @cash_old integer DECLARE @status_old integer DECLARE @creatime_old datetime DECLARE @need_restore integer DECLARE @exists integer DECLARE @status integer DECLARE @point integer DECLARE @sn integer DECLARE @error integer SELECT @sn = 0 SELECT @status = 1 SELECT @point = @cash * 90 UPDATE point SET time = time + @point WHERE @userid = uid AND @aid = aid SELECT @error = 0 SELECT @need_restore = 0 SELECT @sn_old=sn,@aid_old=aid,@point_old=point,@cash_old=cash,@status_old=status,@creatime_old=creatime FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND sn>=0 IF @@rowcount = 1 SELECT @exists = 1 ELSE SELECT @exists = 0 IF @status = 1 BEGIN IF @exists = 0 BEGIN UPDATE point SET time=time-@point WHERE @userid=uid AND @aid=aid AND time>=@point IF @@rowcount = 1 INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES(@userid, @zoneid, @sn, @aid, @point, @cash, @status, getdate() ) ELSE BEGIN INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn SELECT @error = -8 END END ELSE BEGIN INSERT INTO usecashnow SELECT @userid, @zoneid, ISNULL(min(sn),0)-1, @aid, @point, @cash, 0, getdate() FROM usecashnow WHERE userid=@userid and zoneid=@zoneid and 0>=sn SELECT @error = -7 END END IF @need_restore = 1 BEGIN UPDATE point SET time=time+@point_old WHERE @userid=uid AND @aid_old=aid DELETE FROM usecashnow WHERE @userid=userid AND @zoneid=zoneid AND @sn_old=sn INSERT INTO usecashlog (userid, zoneid, sn, aid, point, cash, status, creatime, fintime) VALUES(@userid, @zoneid, @sn_old, @aid_old, @point_old, @cash_old, @status, @creatime_old, getdate() ) END COMMIT TRAN </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="byte[]" in="true" out="false" /> <parameter name="prompt" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="answer" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="truename" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="idnumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="email" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="mobilenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="province" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="city" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="phonenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="address" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="postalcode" sql-type="varchar(8)" java-type="byte[]" 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="byte[]" in="true" out="false" /> <parameter name="passwd2" sql-type="binary(16)" java-type="byte[]" in="true" out="false" /> BEGIN TRAN DECLARE @id integer DECLARE @now datetime SELECT @now = getdate() INSERT INTO account SELECT ISNULL(max(id), 16) + 16, @name, @passwd, @now, 0 FROM account SELECT @id = id FROM account WHERE name = @name INSERT INTO users VALUES (@id, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, @qq, @passwd2) COMMIT TRAN </procedure> <procedure name="addbonususer" 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="byte[]" in="true" out="false" /> <parameter name="prompt" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="answer" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="truename" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="idnumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="email" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="mobilenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="province" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="city" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="phonenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="address" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="postalcode" sql-type="varchar(8)" java-type="byte[]" 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="byte[]" in="true" out="false" /> <parameter name="passwd2" sql-type="binary(16)" java-type="byte[]" in="true" out="false" /> <parameter name="areaid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="freepoint" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="score" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="func" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="funcparm" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @id integer DECLARE @now datetime SELECT @now = getdate() INSERT INTO account SELECT ISNULL(max(id), 16) + 16, @name, @passwd, @now, 0 FROM account SELECT @id = id FROM account WHERE name = @name INSERT INTO users VALUES( @id, @prompt, @answer, @truename, @idnumber, @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, @qq, @passwd2 ) INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES ( @id, 0, @score, @func, @funcparm, 0, 0, @score, 0, 0, 0 ) COMMIT TRAN </procedure> <procedure name="addzonghenguser" 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="byte[]" in="true" out="false" /> <parameter name="prompt" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="answer" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="truename" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="idnumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="email" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="mobilenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="province" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="city" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="phonenumber" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="address" sql-type="varchar(64)" java-type="byte[]" in="true" out="false" /> <parameter name="postalcode" sql-type="varchar(8)" java-type="byte[]" 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="byte[]" in="true" out="false" /> <parameter name="passwd2" sql-type="binary(16)" java-type="byte[]" in="true" out="false" /> BEGIN TRAN DECLARE @id integer DECLARE @now datetime SELECT @now = getdate() INSERT INTO account SELECT ISNULL(max(id), 16) + 16, @name, @passwd, @now, -2147483648 FROM account SELECT @id = id FROM account WHERE name = @name INSERT INTO users VALUES (@id, '', '', '', '', @email, @mobilenumber, @province, @city, @phonenumber, @address, @postalcode, @gender, @birthday, @qq, @passwd2) COMMIT TRAN </procedure> <procedure name="upgradezonghenguser" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> UPDATE account SET usertype = usertype & 2147483647 WHERE id = @uid IF @@rowcount = 1 return 0 return 1 </procedure> <procedure name="remaintime" connection="auth0" operate="replaceB"> <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" /> BEGIN TRAN DECLARE @enddate datetime DECLARE @now datetime SELECT @remain=time, @enddate=enddate FROM point WHERE @uid = uid AND @aid = aid IF @@rowcount = 0 BEGIN SELECT @remain = 36000 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@uid,@aid,@remain, 0, 0, '', '', '') END SELECT @now = getdate() SELECT @freetimeleft = CASE WHEN @enddate > @now THEN datediff(second, @now, @enddate) ELSE 0 END COMMIT TRAN </procedure> <procedure name="adduserpoint" connection="auth0" operate="replaceB"> <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" /> BEGIN TRAN UPDATE point SET time=ISNULL(time,0)+@time WHERE @uid=uid AND @aid=aid IF @@rowcount = 0 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@uid,@aid,36000+@time, 0, 0, '', '', '') COMMIT TRAN </procedure> <procedure name="addscore" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id"/> <parameter name="addscore" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN if( @addscore > 0 ) BEGIN UPDATE function SET score=score+@addscore,addupscore=addupscore+@addscore WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES (@uid, 0, @addscore, 0, 0, 0, 0, @addscore, 0, 0, 0 ) END ELSE BEGIN UPDATE function SET score=score+@addscore WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES (@uid, 0, @addscore, 0, 0, 0, 0, 0, 0, 0, 0 ) END COMMIT TRAN </procedure> <procedure name="setfunction" connection="auth0" operate="replaceB"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id" /> <parameter name="func" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="funcparm" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN UPDATE function SET func = @func, funcparm = @funcparm WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES (@uid, 0, 0, @func, @funcparm, 0, 0, 0, 0, 0, 0 ) COMMIT TRAN </procedure> <procedure name="clearonlinerecords" connection="auth0" operate="replaceB"> <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" /> BEGIN TRAN LOCK TABLE point IN EXCLUSIVE MODE UPDATE point SET zoneid = 0, zonelocalid = 0 WHERE aid = @aid AND zoneid = @zoneid COMMIT TRAN </procedure> <procedure name="recordonline_free" connection="auth0" operate="replaceB"> <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="false" /> BEGIN TRAN UPDATE point_free SET zoneid = @zoneid, lastlogin = getdate() WHERE uid = @uid AND aid = @aid IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid,@aid,@zoneid,getdate()) COMMIT TRAN </procedure> <procedure name="batchrecordonlinefree" connection="auth0" operate="replaceB"> <parameter name="uid1" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid1" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid1" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login1" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid2" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid2" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid2" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login2" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid3" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid3" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid3" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login3" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid4" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid4" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid4" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login4" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid5" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid5" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid5" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login5" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid6" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid6" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid6" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login6" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid7" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid7" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid7" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login7" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid8" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid8" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid8" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login8" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid9" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid9" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid9" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login9" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="uid10" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="aid10" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="zoneid10" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="login10" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @now datetime DECLARE @lastlogin1 datetime DECLARE @lastlogin2 datetime DECLARE @lastlogin3 datetime DECLARE @lastlogin4 datetime DECLARE @lastlogin5 datetime DECLARE @lastlogin6 datetime DECLARE @lastlogin7 datetime DECLARE @lastlogin8 datetime DECLARE @lastlogin9 datetime DECLARE @lastlogin10 datetime SELECT @now = getdate() SELECT @lastlogin1 = dateadd(second,@login1,@now) SELECT @lastlogin2 = dateadd(second,@login2,@now) SELECT @lastlogin3 = dateadd(second,@login3,@now) SELECT @lastlogin4 = dateadd(second,@login4,@now) SELECT @lastlogin5 = dateadd(second,@login5,@now) SELECT @lastlogin6 = dateadd(second,@login6,@now) SELECT @lastlogin7 = dateadd(second,@login7,@now) SELECT @lastlogin8 = dateadd(second,@login8,@now) SELECT @lastlogin9 = dateadd(second,@login9,@now) SELECT @lastlogin10 = dateadd(second,@login10,@now) UPDATE point_free SET zoneid = @zoneid1, lastlogin = @lastlogin1 WHERE uid = @uid1 AND aid = @aid1 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid1,@aid1,@zoneid1,@lastlogin1) UPDATE point_free SET zoneid = @zoneid2, lastlogin = @lastlogin2 WHERE uid = @uid2 AND aid = @aid2 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid2,@aid2,@zoneid2,@lastlogin2) UPDATE point_free SET zoneid = @zoneid3, lastlogin = @lastlogin3 WHERE uid = @uid3 AND aid = @aid3 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid3,@aid3,@zoneid3,@lastlogin3) UPDATE point_free SET zoneid = @zoneid4, lastlogin = @lastlogin4 WHERE uid = @uid4 AND aid = @aid4 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid4,@aid4,@zoneid4,@lastlogin4) UPDATE point_free SET zoneid = @zoneid5, lastlogin = @lastlogin5 WHERE uid = @uid5 AND aid = @aid5 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid5,@aid5,@zoneid5,@lastlogin5) UPDATE point_free SET zoneid = @zoneid6, lastlogin = @lastlogin6 WHERE uid = @uid6 AND aid = @aid6 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid6,@aid6,@zoneid6,@lastlogin6) UPDATE point_free SET zoneid = @zoneid7, lastlogin = @lastlogin7 WHERE uid = @uid7 AND aid = @aid7 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid7,@aid7,@zoneid7,@lastlogin7) UPDATE point_free SET zoneid = @zoneid8, lastlogin = @lastlogin8 WHERE uid = @uid8 AND aid = @aid8 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid8,@aid8,@zoneid8,@lastlogin8) UPDATE point_free SET zoneid = @zoneid9, lastlogin = @lastlogin9 WHERE uid = @uid9 AND aid = @aid9 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid9,@aid9,@zoneid9,@lastlogin9) UPDATE point_free SET zoneid = @zoneid10, lastlogin = @lastlogin10 WHERE uid = @uid10 AND aid = @aid10 IF @@rowcount = 0 INSERT INTO point_free (uid,aid,zoneid,lastlogin) VALUES (@uid10,@aid10,@zoneid10,@lastlogin10) COMMIT TRAN </procedure> <procedure name="recordonline" connection="auth0" operate="replaceB"> <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" /> BEGIN TRAN DECLARE @tmp_zoneid integer DECLARE @tmp_zonelocalid integer SELECT @tmp_zoneid = zoneid, @tmp_zonelocalid = zonelocalid FROM point WHERE uid = @uid AND aid = @aid IF @@rowcount = 0 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@uid,@aid,36000,@zoneid,@zonelocalid,getdate(),getdate(),'') ELSE IF @tmp_zoneid = NULL OR @tmp_zoneid = 0 OR @overwrite = 1 UPDATE point SET zoneid=@zoneid, zonelocalid=@zonelocalid, accountstart=getdate(), lastlogin=getdate() WHERE uid = @uid AND aid = @aid IF @tmp_zoneid = NULL OR @tmp_zoneid = 0 SELECT @overwrite = 1 ELSE SELECT @zoneid = @tmp_zoneid, @zonelocalid = @tmp_zonelocalid COMMIT TRAN </procedure> <procedure name="recordoffline" connection="auth0" operate="replaceB"> <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" /> BEGIN TRAN exec accounting @uid, @aid, 1 UPDATE point SET zoneid = 0, zonelocalid = 0 WHERE uid = @uid AND aid = @aid AND zoneid = @zoneid SELECT @overwrite = @@rowcount IF @overwrite = 0 SELECT @zoneid = zoneid, @zonelocalid = zonelocalid FROM point WHERE uid = @uid AND aid = @aid COMMIT TRAN </procedure>  <procedure name="accounting" connection="auth0" operate="replaceB">  <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="type" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @remain integer DECLARE @enddate datetime DECLARE @accountstart datetime DECLARE @now datetime DECLARE @timeused integer DECLARE @timeminus integer SELECT @now = getdate() SELECT @remain = time, @enddate = enddate, @accountstart = accountstart FROM point WHERE @uid = uid AND @aid = aid IF @@rowcount = 0 INSERT INTO point VALUES(@uid, @aid, 36000, 0, 0, CASE WHEN @type = 1 THEN '' ELSE @now END, '', '' ) ELSE BEGIN IF @type = 0 OR '2005-01-01' > @accountstart BEGIN SELECT @timeused = 0 SELECT @timeminus = 0 END ELSE BEGIN SELECT @timeused = datediff(second, @accountstart, @now) SELECT @timeminus = CASE WHEN '2005-01-01' > @enddate OR (@now > @enddate AND @accountstart > @enddate) THEN @timeused WHEN @now > @enddate AND @enddate > @accountstart THEN datediff(second,@enddate,@now) ELSE 0 END IF @timeminus > @remain SELECT @timeminus = @remain IF @timeminus > 3600 SELECT @timeminus = CASE WHEN @type = 1 THEN 0 ELSE 300 END END UPDATE point SET time=time-@timeminus, accountstart=CASE WHEN @type=1 THEN '' ELSE @now END WHERE @uid=uid AND @aid=aid UPDATE function SET adduptime = adduptime + @timeused WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function VALUES ( @uid, @timeused, 0,0,0,0,0,0,0,0,0 ) END COMMIT TRAN </procedure> <query name="downloadaward"> <table name="awardnew" alias="cn"/> <table name="awardrecord" alias="cr"/> <column name="number" column="cn.number"/> <select name="all" condition="WHERE cn.rid = ? AND cn.rid = cr.id AND cr.status = 0"/> </query> <query name="awardrecordids"> <table name="awardrecord" alias="c"/> <column name="id" column="c.id"/> <select name="all" condition="ORDER BY c.id DESC"/> <select name="new" condition="WHERE c.status = 0 ORDER BY c.id DESC"/> <select name="audited" condition="WHERE c.status = 1 ORDER BY c.id DESC"/> </query> <query name="awardrecordinfo"> <table name="awardrecord" alias="c"/> <column name="code" column="c.code"/> <column name="number" column="c.number"/> <column name="endtime" column="c.endtime"/> <column name="creator" column="c.creator"/> <column name="creatime" column="c.creatime"/> <column name="auditor" column="c.auditor"/> <column name="auditime" column="c.auditime"/> <column name="status" column="c.status"/> <column name="func" column="c.func"/> <column name="used" column="c.used"/> <select name="item" condition="WHERE c.id = ?"/> <select name="bycode" condition="WHERE c.code = ? and c.status = 1"/> </query> <query name="downloadcard"> <table name="cardnew" alias="cn"/> <table name="cardrecord" alias="cr"/> <column name="number" column="cn.number"/> <select name="all" condition="WHERE cn.rid = ? AND cn.rid = cr.id AND cr.status = 0 ORDER BY cn.number"/> </query> <query name="cardrecordids"> <table name="cardrecord" alias="c"/> <column name="id" column="c.id"/> <select name="all" condition="ORDER BY c.id DESC"/> <select name="new" condition="WHERE c.status = 0 ORDER BY c.id DESC"/> <select name="audited" condition="WHERE c.status = 1 ORDER BY c.id DESC"/> </query> <query name="cardrecordinfo"> <table name="cardrecord" alias="c"/> <column name="code" column="c.code"/> <column name="number" column="c.number"/> <column name="price" column="c.price"/> <column name="rate" column="c.rate"/> <column name="pointcard" column="c.pointcard"/> <column name="exchangepoint" column="c.exchangepoint"/> <column name="endtime" column="c.endtime"/> <column name="creator" column="c.creator"/> <column name="creatime" column="c.creatime"/> <column name="auditor" column="c.auditor"/> <column name="auditime" column="c.auditime"/> <column name="status" column="c.status"/> <column name="func" column="c.func"/> <column name="funcparm" column="c.funcparm"/> <column name="used" column="c.used"/> <column name="score" column="c.score"/> <select name="item" condition="WHERE c.id = ?"/> <select name="bycode" condition="WHERE c.code = ? and c.status = 1"/> </query> <query name="getcardused"> <table name="cardused" alias="cu"/> <table name="cardrecord" alias="cr"/> <column name="namefrom" column="cu.namefrom"/> <column name="nameto" column="cu.nameto"/> <column name="number" column="cu.number"/> <column name="usedate" column="cu.usedate"/> <column name="pointcard" column="cr.pointcard"/> <column name="exchangepoint" column="cr.exchangepoint"/> <column name="ip" column="cu.ip"/> <column name="aid" column="cu.aid"/> <column name="zoneid" column="cu.zoneid"/> <select name="byname" condition="WHERE cu.rid = cr.id AND cu.nameto = ?"/> <select name="bycard" condition="WHERE cu.rid = cr.id AND cu.number like ?"/> </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="getUserAwardPoints"> <table name="account" alias="u" /> <table name="awardpoint" alias="p" /> <column name="name" column="u.name" /> <column name="point" column="p.point" /> <column name="score" column="p.score" /> <column name="awarddate" column="p.awarddate" /> <column name="usedate" column="p.usedate" /> <select name="byuid" condition="where p.touid = ? and u.id = p.fromuid ORDER BY p.awarddate DESC" /> </query> <query name="getUserSellPoints"> <table name="account" alias="u" /> <table name="translog" alias="p" /> <column name="zoneid" column="p.zoneid" /> <column name="serial" column="p.serial" /> <column name="sellid" column="p.sellid" /> <column name="buyer" column="u.name" /> <column name="price" column="p.price" /> <column name="point" column="p.point" /> <column name="aid" column="p.aid" /> <column name="status" column="p.status" /> <column name="date" column="p.date" /> <select name="byuid" condition="where p.seller = ? and u.id = p.buyer ORDER BY p.date" /> </query> <query name="monthexchanged"> <table name="account" alias="u"/> <table name="monthbill" alias="m"/> <column name="uid" column="m.uid"/> <column name="aid" column="m.aid"/> <column name="usepoint" column="m.usepoint"/> <column name="monthcount" column="m.monthcount"/> <column name="enddate" column="m.enddate"/> <column name="usedate" column="m.usedate"/> <select name="byname" condition="WHERE u.id = m.uid AND u.name = ? AND m.usedate >= ? and m.usedate <= ? "/> </query> <procedure name="addawardrecord" connection="auth0" operate="replaceA"> <parameter name="code" sql-type="varchar(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="endtime" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="creator" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="func" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> BEGIN TRAN SELECT @id = ISNULL(max(id), 0)+1 FROM awardrecord HOLDLOCK INSERT INTO awardrecord VALUES(@id,@code,0,@endtime,@creator,getdate(),@creator,getdate(),0,@func, 0) COMMIT TRAN </procedure> <procedure name="addaward" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="number0" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number1" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number2" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number3" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number4" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number5" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number6" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number7" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number8" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number9" sql-type="char(8)" java-type="java.lang.String" in="true" out="false" /> BEGIN TRAN IF EXISTS (SELECT * FROM awardused HOLDLOCK WHERE number IN(@number0,@number1,@number2,@number3,@number4,@number5,@number6,@number7,@number8,@number9)) BEGIN rollback tran return -1 END INSERT INTO awardnew VALUES(@id, @number0) INSERT INTO awardnew VALUES(@id, @number1) INSERT INTO awardnew VALUES(@id, @number2) INSERT INTO awardnew VALUES(@id, @number3) INSERT INTO awardnew VALUES(@id, @number4) INSERT INTO awardnew VALUES(@id, @number5) INSERT INTO awardnew VALUES(@id, @number6) INSERT INTO awardnew VALUES(@id, @number7) INSERT INTO awardnew VALUES(@id, @number8) INSERT INTO awardnew VALUES(@id, @number9) UPDATE awardrecord SET number = number + 10 WHERE id = @id COMMIT TRAN </procedure> <procedure name="deleteaward" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DELETE FROM awardrecord WHERE id = @id AND status = 0 if @@rowcount = 1 DELETE FROM awardnew WHERE rid = @id COMMIT TRAN </procedure> <procedure name="auditaward" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="auditor" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN UPDATE awardrecord SET auditor = @auditor, auditime = getdate(), status = @status WHERE id = @id AND status = 0 COMMIT TRAN </procedure> <procedure name="addcardrecord" connection="auth0" operate="replaceA"> <parameter name="code" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="price" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="rate" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="pointcard" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="exchangepoint" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="endtime" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="creator" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="func" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="funcparm" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="score" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> BEGIN TRAN SELECT @id = ISNULL(max(id), 0)+1 FROM cardrecord HOLDLOCK IF NOT EXISTS (SELECT * FROM cardrecord WHERE code = @code) INSERT INTO cardrecord (id,code,number,price,rate,pointcard,exchangepoint,endtime,creator,creatime,auditor,auditime,status,func,funcparm,used,score) VALUES(@id,@code,0,@price,@rate,@pointcard,@exchangepoint,@endtime,@creator,getdate(),@creator,getdate(),0,@func,@funcparm, 0, @score) ELSE SELECT @id = -1 COMMIT TRAN </procedure> <procedure name="addcard" connection="auth0" operate="replaceA"> <parameter name="id" 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="number0" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number1" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number2" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number3" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number4" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number5" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number6" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number7" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number8" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number9" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> DECLARE @cardstatus integer -- cardstatus only value 0 or 1 SELECT @cardstatus = 0 IF (@status = 1) BEGIN SELECT @cardstatus = 1 END BEGIN TRAN IF EXISTS (SELECT * FROM cardnew HOLDLOCK WHERE number IN(@number0,@number1,@number2,@number3,@number4,@number5,@number6,@number7,@number8,@number9)) BEGIN rollback tran return -1 END INSERT INTO cardnew (rid, number, status) VALUES(@id, @number0, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number1, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number2, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number3, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number4, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number5, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number6, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number7, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number8, @cardstatus) INSERT INTO cardnew (rid, number, status) VALUES(@id, @number9, @cardstatus) UPDATE cardrecord SET number = number + 10 WHERE id = @id COMMIT TRAN </procedure> <procedure name="getcardstatus" connection="auth0" operate="replaceA"> <parameter name="fromnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="tonumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="op" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN SELECT @retcount = count(number) FROM cardnew WHERE number >= @fromnumber and @tonumber >= number and status = @status INSERT INTO cardstatuslog (date,fromnumber,tonumber,fromstatus,tostatus,op,retcount) VALUES (getdate(),@fromnumber,@tonumber,0-@status,0-@status,@op,@retcount) COMMIT TRAN </procedure> <procedure name="checkcardstatus" connection="auth0" operate="replaceA"> <parameter name="fromnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="tonumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="op" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN SELECT @retcount = count(number) FROM cardnew WHERE number >= @fromnumber and @tonumber >= number and not status = @status INSERT INTO cardstatuslog (date,fromnumber,tonumber,fromstatus,tostatus,op,retcount) VALUES (getdate(),@fromnumber,@tonumber,@status,@status,@op,@retcount) COMMIT TRAN </procedure> <procedure name="changecardstatus" connection="auth0" operate="replaceA"> <parameter name="fromnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="tonumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="fromstatus" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="tostatus" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="op" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN SELECT @retcount = 0 UPDATE cardnew set status = @tostatus WHERE number >= @fromnumber AND @tonumber >= number AND @fromstatus = status SELECT @retcount = @@rowcount INSERT INTO cardstatuslog (date,fromnumber,tonumber,fromstatus,tostatus,op,retcount) VALUES (getdate(),@fromnumber,@tonumber,@fromstatus,@tostatus,@op,@retcount) COMMIT TRAN </procedure> <procedure name="deletecard" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DELETE FROM cardrecord WHERE id = @id AND status = 0 if @@rowcount = 1 DELETE FROM cardnew WHERE rid = @id COMMIT TRAN </procedure> <procedure name="auditcard" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="auditor" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN UPDATE cardrecord SET auditor = @auditor, auditime = getdate(), status = @status WHERE id = @id AND status = 0 COMMIT TRAN </procedure> <procedure name="querycardnew" connection="auth0" operate="replaceB"> <parameter name="number" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="numberall" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="cnstatus" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="code" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="price" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="rate" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="pointcard" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="exchangepoint" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="strendtime" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="crstatus" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="func" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="funcparm" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="score" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> BEGIN TRAN DECLARE @number_leng integer DECLARE @cr_id integer SELECT @error = -1 SELECT @number_leng = char_length(@number) IF @number_leng >= 10 BEGIN SELECT TOP 1 @cr_id = cn.rid, @numberall = cn.number, @cnstatus = cn.status FROM cardnew cn WHERE cn.number like @number IF @@rowcount = 1 BEGIN SELECT @code = cr.code, @price = cr.price, @rate = cr.rate, @pointcard = cr.pointcard, @exchangepoint = cr.exchangepoint, @strendtime = convert(varchar(12),cr.endtime,102)+' '+convert(varchar(12),cr.endtime,108), @crstatus = cr.status, @func = cr.func, @funcparm = cr.funcparm, @score = cr.score FROM cardrecord cr WHERE @cr_id = cr.id SELECT @error = 0 END ELSE SELECT @error = 1 END ELSE SELECT @error = 2 COMMIT TRAN </procedure>  <procedure name="usepointcard" connection="auth0" operate="replaceC"> <parameter name="agent" sql-type="char(1)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="fromname" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id" /> <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="false" /> <parameter name="ip" 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" /> BEGIN TRAN DECLARE @rid integer DECLARE @toname varchar(32) DECLARE @maxid integer DECLARE @number_code varchar(32) DECLARE @addpoint integer DECLARE @addscore integer DECLARE @crstatus integer DECLARE @cnstatus integer DECLARE @func integer DECLARE @funcparm integer DECLARE @money integer DECLARE @nextbillid integer DECLARE @now datetime DECLARE @crendtime datetime DECLARE @oldadduppoint integer SELECT @now = getdate() SELECT @rid = cr.id, @money = cr.price, @addpoint = cr.pointcard * cr.exchangepoint, @crendtime = cr.endtime, @crstatus = cr.status, @func = cr.func, @funcparm = cr.funcparm, @addscore = cr.score, @cnstatus = cn.status FROM cardrecord cr, cardnew cn WHERE cn.number = @number AND cn.rid = cr.id IF @@rowcount = 1 BEGIN IF NOT @crstatus = 1 OR NOT @cnstatus = 1 SELECT @error = -6 ELSE BEGIN SELECT @toname = name FROM account WHERE @uid = id IF @@rowcount = 1 BEGIN IF @aid >= 9 BEGIN SELECT @addscore = 0 END UPDATE point SET time = time + @addpoint WHERE @uid = uid AND @aid = aid IF @@rowcount = 0 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@uid,@aid,@addpoint+36000, 0, 0, '', '', '' ) SELECT @oldadduppoint = adduppoint FROM function WHERE @uid = uid IF @oldadduppoint > 2100000000 UPDATE function SET adduppoint = 0, soldpoint = 0 WHERE @uid = uid UPDATE function SET score=score+@addscore,func=case when @func > 0 then @func else func end,funcparm=case when @func > 0 then @funcparm else funcparm end,addupmoney=addupmoney+@money,adduppoint=adduppoint+@addpoint,addupscore=addupscore+@addscore WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES ( @uid, 0, @addscore, @func, @funcparm, @money, @addpoint, @addscore, 0, 0, 0 ) INSERT INTO cardused (rid,number,namefrom,nameto,usedate,ip,aid,zoneid) VALUES (@rid,@number,@fromname,@toname,@now,@ip,@aid,@zoneid) DELETE FROM cardnew WHERE number = @number UPDATE cardrecord SET used = used + 1 WHERE id = @rid UPDATE max_ids SET maxid = max(maxid)+1 WHERE type = 1 SELECT @maxid = max(maxid) FROM max_ids WHERE type = 1 INSERT INTO agentbill VALUES (@maxid, @agent, @uid, @aid, @rid, @money, @addpoint, @addscore, getdate(), @zoneid, 0, 0, 0, 0, 0) SELECT @error = @addpoint END ELSE SELECT @error = -3 END END ELSE BEGIN SELECT @number_code = substring(@number,1,10)+'%' IF EXISTS ( SELECT * from cardnew WHERE number like @number_code ) SELECT @error = -4 ELSE SELECT @error = -2 END COMMIT TRAN </procedure>  <procedure name="batchusepointcard" connection="auth0" operate="replaceC"> <parameter name="agent1" sql-type="char(1)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number1" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="agent2" sql-type="char(1)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number2" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="fromname" sql-type="varchar(32)" java-type="byte[]" in="true" out="false" /> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id" /> <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="false" /> <parameter name="ip" 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" /> BEGIN TRAN DECLARE @error1 integer DECLARE @error2 integer SELECT @error = -1 exec usepointcard @agent1, @number1, @fromname, @uid, @aid, @zoneid, @ip, @error1 out exec usepointcard @agent2, @number2, @fromname, @uid, @aid, @zoneid, @ip, @error2 out IF @error1 > 0 AND @error2 > 0 AND 270000 = @error1 AND 270000 = @error2 BEGIN COMMIT TRAN SELECT @error = @error1 + @error2 END ELSE BEGIN ROLLBACK TRAN IF -3 = @error1 OR -3 = @error2 SELECT @error = -2 ELSE IF 0 >= @error1 AND 0 >= @error2 SELECT @error = -3 ELSE IF 0 >= @error1 SELECT @error = -4 ELSE IF 0 >= @error2 SELECT @error = -5 ELSE IF NOT 270000 = @error1 AND NOT 270000 = @error2 SELECT @error = -6 ELSE IF NOT 270000 = @error1 SELECT @error = -7 ELSE IF NOT 270000 = @error2 SELECT @error = -8 ELSE SELECT @error = -1 SELECT @error1, @error2, @error END </procedure> <query name="queryAgentBill"> <table name="agentbill" alias="b"/> <column name="billid" column="b.billid"/> <column name="agent" column="b.agent"/> <column name="uid" column="b.uid"/> <column name="aid" column="b.aid"/> <column name="cardtype" column="b.cardtype"/> <column name="money" column="b.money"/> <column name="addpoint" column="b.addpoint"/> <column name="addscore" column="b.addscore"/> <column name="usedate" column="b.usedate"/> <column name="cookie1" column="b.cookie1"/> <column name="cookie2" column="b.cookie2"/> <column name="addcoin" column="b.addcoin"/> <column name="awarduid" column="b.awarduid"/> <column name="awardpoint" column="b.awardpoint"/> <column name="awardscore" column="b.awardscore"/> <select name="byBillidAgent" condition="WHERE b.billid = ? and b.agent = ?"/> <select name="byBillid" condition="WHERE b.billid = ?"/> <select name="byUidDateRange" condition="(index ind_agentbill_uidaid) WHERE b.uid = ? and b.usedate >= ? and b.usedate <= ?"/> </query> <procedure name="useagentcard" connection="auth0" operate="replaceC"> <parameter name="billid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="agent" sql-type="char(1)" java-type="java.lang.String" in="true" out="false" /> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="function_by_id" /> <parameter name="aid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="cardtype" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="money" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="addpoint" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="addscore" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="cookie1" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="cookie2" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="addcoin" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="awarduid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="awardpoint" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="awardscore" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> BEGIN TRAN DECLARE @pointexists integer DECLARE @oldtime integer DECLARE @oldaddupmoney integer DECLARE @oldadduppoint integer SELECT @pointexists = 0 IF NOT EXISTS ( SELECT * FROM agentbill WHERE @billid = billid AND @agent = agent ) BEGIN -- IF @error = 0 -- BEGIN -- SELECT @uid = id FROM account WHERE @name = name -- IF NOT @@rowcount = 1 SELECT @error = 2 -- END IF @error = 0 AND @awarduid > 0 BEGIN IF NOT EXISTS ( SELECT * FROM account WHERE @awarduid = id ) SELECT @error = 7 ELSE BEGIN SELECT @oldaddupmoney = addupmoney FROM function WHERE @uid = uid IF @@rowcount = 1 AND @oldaddupmoney > 0 SELECT @error = 8 IF EXISTS ( SELECT * FROM awardpoint where @uid = fromuid ) SELECT @error = 8 SELECT @oldaddupmoney = addupmoney FROM function WHERE @awarduid = uid IF @@rowcount = 0 OR @oldaddupmoney = 0 SELECT @error = 10 END END IF @error = 0 BEGIN SELECT @oldtime=time FROM point WHERE @uid = uid AND @aid = aid IF @@rowcount = 1 SELECT @pointexists = 1 IF @pointexists = 1 AND @oldtime+@addpoint > 2100000000 SELECT @error = -1 END IF @error = 0 BEGIN INSERT INTO agentbill (billid, agent, uid, aid, cardtype, money, addpoint, addscore, usedate, cookie1, cookie2, addcoin, awarduid, awardpoint, awardscore) VALUES ( @billid, @agent, @uid, @aid, @cardtype, @money, @addpoint, @addscore, getdate(), @cookie1, @cookie2, @addcoin, @awarduid, @awardpoint, @awardscore ) IF @pointexists = 1 UPDATE point SET time = ISNULL(time,0) + @addpoint WHERE @uid = uid AND @aid = aid ELSE INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES ( @uid, @aid, @addpoint+36000, 0, 0, '', '', '' ) SELECT @oldadduppoint = adduppoint FROM function WHERE @uid = uid IF @oldadduppoint > 2100000000 UPDATE function SET adduppoint = 0, soldpoint = 0 WHERE @uid = uid UPDATE function SET score=score+@addscore,addupmoney=addupmoney+@money,adduppoint=adduppoint+@addpoint,addupscore=addupscore+@addscore,coin=coin+@addcoin,addupcoin=addupcoin+@addcoin WHERE @uid = uid IF @@rowcount = 0 INSERT INTO function (uid,adduptime,score,func,funcparm,addupmoney,adduppoint,addupscore,coin,addupcoin,soldpoint) VALUES (@uid, 0, @addscore, 0, 0, @money, @addpoint, @addscore, @addcoin, @addcoin, 0 ) IF @awarduid > 0 INSERT INTO awardpoint (fromuid, touid, point, score, awarddate, usedate) VALUES (@uid, @awarduid, @awardpoint, @awardscore, getdate(), null) END ELSE BEGIN SELECT @uid = @error INSERT INTO agentbill (billid, agent, uid, aid, cardtype, money, addpoint, addscore, usedate, cookie1, cookie2, addcoin, awarduid, awardpoint, awardscore) VALUES ( @billid, @agent, @uid, @aid, @cardtype, @money, @addpoint, @addscore, getdate(), @cookie1, @cookie2, @addcoin, @awarduid, @awardpoint, @awardscore ) IF NOT @error=2 AND NOT @error=7 AND NOT @error=8 AND NOT @error=10 AND NOT @error=-1 SELECT @error = 0 END END ELSE SELECT @error = 1 COMMIT TRAN </procedure>   <procedure name="exchangemonth" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="aid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="monthcount" 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" /> <parameter name="remain" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="strenddate" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> BEGIN TRAN DECLARE @uid integer DECLARE @oldtime integer DECLARE @oldenddate datetime DECLARE @usepoint integer DECLARE @now datetime DECLARE @enddate datetime DECLARE @summoney integer SELECT @error = 0 SELECT @remain = 0 SELECT @uid = id FROM account WHERE @name = name IF @@rowcount = 1 BEGIN SELECT @oldtime=time,@oldenddate=enddate FROM point WHERE @uid = uid AND @aid = aid SELECT @usepoint = @monthcount*522000 IF @@rowcount = 1 AND @oldtime >= @usepoint BEGIN SELECT @now = getdate() IF @now > @oldenddate SELECT @oldenddate = @now SELECT @enddate = dateadd(day,30*@monthcount,ISNULL(@oldenddate,@now)) UPDATE point SET time = @oldtime-@usepoint, enddate = @enddate WHERE @uid = uid AND @aid = aid INSERT INTO monthbill (uid, aid, usepoint, monthcount, enddate, usedate) VALUES (@uid, @aid, @usepoint, @monthcount, @enddate, @now ) SELECT @remain = @oldtime-@usepoint SELECT @strenddate = convert(varchar(12), @enddate, 102) + ' ' + convert(varchar(12), @enddate, 108) END ELSE BEGIN SELECT @error = 2 SELECT @remain = @oldtime SELECT @enddate = @oldenddate SELECT @strenddate = convert(varchar(12), @enddate, 102) + ' ' + convert(varchar(12), @enddate, 108) END END ELSE SELECT @error = 1 COMMIT TRAN </procedure> <procedure name="exchangearea" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="srcaid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="destaid" 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" /> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN DECLARE @uid integer DECLARE @srctime integer SELECT @error = 0 SELECT @uid = id FROM account WHERE @name = name IF @@rowcount = 1 BEGIN SELECT @srctime=time FROM point WHERE @uid = uid AND @srcaid = aid IF @@rowcount = 1 AND @srctime >= @time BEGIN UPDATE point SET time = time+@time WHERE @uid = uid AND @destaid = aid IF @@rowcount = 0 INSERT INTO point (uid,aid,time,zoneid,zonelocalid,accountstart,lastlogin,enddate) VALUES (@uid,@destaid,@time+36000, 0, 0, '', '', '' ) UPDATE point SET time = time-@time WHERE @uid = uid AND @srcaid = aid END ELSE SELECT @error = 2 END ELSE SELECT @error = 1 COMMIT TRAN </procedure> <procedure name="addmatrixrecord" connection="auth0" operate="replaceA"> <parameter name="code" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="number" sql-type="integer" java-type="java.lang.Integer" not-null="true" /> <parameter name="price" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="rate" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="expiredtime" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="creator" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> BEGIN TRAN SELECT @id = -1 SELECT id FROM matrixrecord WHERE code = @code if (@@rowcount > 0) return -1 SELECT @id = ISNULL(max(id), 0)+1 FROM matrixrecord HOLDLOCK INSERT INTO matrixrecord (id,code,number,price,rate,expiredtime,creator,creatime,auditor,auditime,status) VALUES(@id,@code,@number,@price,@rate,@expiredtime,@creator,getdate(),@creator,getdate(),0) COMMIT TRAN </procedure> <procedure name="addnewmatrix" connection="auth0" operate="replaceA"> <parameter name="recordid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="matrixid" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="matrix" sql-type="varbinary(80)" java-type="byte[]" in="true" out="false" /> INSERT INTO matrixnew (recordid,id,matrix) VALUES (@recordid,@matrixid,@matrix) IF (@@rowcount = 0) return -1 else return 0 </procedure> <procedure name="bindmatrix" connection="auth0" operate="replaceB">  <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;matrix_by_uid" /> <parameter name="matrixid" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="ip" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @newmatrix varbinary(80) DECLARE @recordid integer DECLARE @expiredtime datetime DECLARE @usertype integer SELECT @usertype=usertype FROM account where id = @userid IF @@rowcount = 0 BEGIN ROLLBACK TRAN RETURN -2 --userid invalid END IF ((@usertype & 240) != 0) --0xF0-- BEGIN ROLLBACK TRAN RETURN -6 --already bind, maybe other security -- END SELECT @newmatrix=n.matrix, @expiredtime=r.expiredtime, @recordid = n.recordid FROM matrixnew n, matrixrecord r WHERE n.id = @matrixid AND r.id = n.recordid AND r.status = 1 IF @@rowcount = 0 BEGIN ROLLBACK TRAN RETURN -5 --invalid-- END ELSE IF (getdate() > @expiredtime) BEGIN ROLLBACK TRAN RETURN -11 END INSERT INTO matrix VALUES( @userid, @recordid, @matrixid, @newmatrix ) IF @@rowcount = 0 BEGIN ROLLBACK TRAN RETURN -6 --already bind END INSERT INTO matrixused (id,matrix,userid, begindate,ip) VALUES (@matrixid,@newmatrix,@userid,getdate(), @ip) UPDATE account SET usertype = (usertype & -241)|16 WHERE id = @userid --0xFFFFFF0F-- DELETE FROM matrixnew where id = @matrixid COMMIT TRAN RETURN 0 </procedure> <procedure name="unbindmatrix" connection="auth0" operate="replaceB">  <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;matrix_by_uid" /> <parameter name="matrixid" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="ip" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @matrixid_indb varchar(12) DECLARE @begindate datetime SELECT @begindate = u.begindate, @matrixid_indb = m.matrixid FROM matrix m,matrixused u WHERE m.uid = @userid AND m.matrixid = u.id AND u.canceldate = NULL IF @@rowcount = 1 BEGIN IF @begindate > '2008-06-01' AND NOT @matrixid_indb = @matrixid BEGIN COMMIT TRAN return -5 END END ELSE BEGIN COMMIT TRAN return -6 END UPDATE matrixused SET canceldate = getdate(), ip = @ip FROM matrix WHERE matrix.uid = @userid AND matrix.matrixid = matrixused.id AND matrixused.canceldate = NULL IF @@rowcount = 1 BEGIN DELETE FROM matrix WHERE uid = @userid UPDATE account SET usertype = (usertype & -241) WHERE id = @userid --0xFFFFFF0F change account status-- END COMMIT TRAN RETURN 0 </procedure> <procedure name="rebindmatrix" connection="auth0" operate="replaceB">  <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id;matrix_by_uid" /> <parameter name="matrixidold" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="matrixid" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="false" /> <parameter name="ip" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> DECLARE @status integer BEGIN TRAN EXECUTE @status = unbindmatrix @userid, @matrixidold, @ip IF @status != 0 BEGIN ROLLBACK TRAN return @status END EXECUTE @status = bindmatrix @userid, @matrixid, @ip IF @status != 0 ROLLBACK TRAN ELSE COMMIT TRAN RETURN @status </procedure> <procedure name="auditmatrix" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="auditor" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> DECLARE @retcount integer SELECT @retcount = 0 BEGIN TRAN UPDATE matrixrecord SET auditor = @auditor, auditime = getdate(), status = @status WHERE id = @id AND status = 0 if @@rowcount =1 SELECT @retcount = count(recordid) FROM matrixnew WHERE recordid = @id COMMIT TRAN return @retcount </procedure> <procedure name="deletematrix" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> DECLARE @affectedcount integer SELECT @affectedcount = 0 BEGIN TRAN DELETE FROM matrixrecord WHERE id = @id AND status = 0 if @@rowcount = 1 BEGIN DELETE FROM matrixnew WHERE recordid = @id SELECT @affectedcount = @@rowcount END COMMIT TRAN return @affectedcount </procedure> <query name="matrixrecordids"> <table name="matrixrecord" alias="c"/> <column name="id" column="c.id"/> <select name="all" condition="ORDER BY c.id DESC"/> <select name="new" condition="WHERE c.status = 0 ORDER BY c.id DESC"/> <select name="audited" condition="WHERE c.status = 1 ORDER BY c.id DESC"/> </query> <query name="matrixrecordinfo"> <table name="matrixrecord" alias="m"/> <column name="code" column="m.code"/> <column name="number" column="m.number"/> <column name="price" column="m.price"/> <column name="rate" column="m.rate"/> <column name="expiredtime" column="m.expiredtime"/> <column name="creator" column="m.creator"/> <column name="creatime" column="m.creatime"/> <column name="auditor" column="m.auditor"/> <column name="auditime" column="m.auditime"/> <column name="status" column="m.status"/> <select name="item" condition="WHERE m.id = ?"/> <select name="bycode" condition="WHERE m.code = ? and m.status = 1"/> </query> <procedure name="changematrixstatus" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="tostatus" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN SELECT @retcount = -1 if ((@tostatus = 0) or (@tostatus = 1) or (@tostatus = 2)) BEGIN UPDATE matrixrecord set status = @tostatus WHERE id = @id SELECT @retcount = count(recordid) FROM matrixnew WHERE recordid = @id END COMMIT TRAN </procedure> <procedure name="clearmatrix" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN DECLARE @ostatus integer SELECT @retcount = -1 SELECT @ostatus = status FROM matrixrecord WHERE id = @id if (@ostatus = 2) BEGIN DELETE FROM matrixrecord WHERE id = @id DELETE FROM matrixnew WHERE recordid = @id SELECT @retcount = @@rowcount END COMMIT TRAN </procedure> <procedure name="querymatrixnewbyid" connection="auth0" operate="replaceA"> <parameter name="recordid" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="id" sql-type="varchar(12)" java-type="java.lang.String" in="true" out="true" /> <parameter name="matrix" sql-type="varbinary(80)" java-type="byte[]" in="false" out="true" /> <parameter name="ret" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> SELECT @ret = -1 SELECT @recordid=recordid, @id=id, @matrix=matrix FROM matrixnew WHERE id = @id IF (@@rowcount = 1) BEGIN SELECT @ret =0 END </procedure> <procedure name="querymatrixusedcount" connection="auth0" operate="replaceA"> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="retcount" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> DECLARE @number integer DECLARE @newcount integer SELECT @retcount = -1 SELECT @number=number FROM matrixrecord WHERE id = @id IF (@@rowcount = 1) BEGIN select @newcount=count(*) FROM matrixnew WHERE recordid = @id SELECT @retcount = @number - @newcount END </procedure> <query name="downloadmatrix"> <table name="matrixnew" alias="mn"/> <column name="recordid" column="mn.recordid"/> <column name="id" column="mn.id"/> <column name="matrix" column="mn.matrix"/> <select name="all" condition="WHERE mn.recordid = ? order by mn.id"/> </query> <query name="querynewmatrix"> <table name="matrixnew" alias="mn"/> <column name="recordid" column="mn.recordid"/> <column name="id" column="mn.id"/> <column name="matrix" column="mn.matrix"/> <select name="id" condition="WHERE mn.id = ? "/> </query> <query name="querymatrixrecordid"> <table name="matrixrecord" alias="m"/> <column name="id" column="m.id"/> <select name="id" condition="WHERE m.code = ?"/> </query> <query name="querymatrixused"> <table name="matrixused" alias="m"/> <column name="id" column="m.id"/> <column name="matrix" column="m.matrix"/> <column name="userid" column="m.userid"/> <column name="begindate" column="m.begindate"/> <column name="canceldate" column="m.canceldate"/> <column name="ip" column="m.ip"/> <select name="id" condition="WHERE m.id = ?"/> <select name="userid" condition="WHERE m.userid = ?"/> </query> <procedure name="bindmobilekey" connection="auth0" operate="replaceB">  <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> <parameter name="key" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> <parameter name="algorithm" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" /> BEGIN TRAN DECLARE @usertypeFromTable integer SELECT @usertypeFromTable=usertype FROM account WHERE id = @userid IF (@@rowcount = 1) BEGIN IF ( (@usertypeFromTable & 240) > 0) --0xF0 BEGIN ROLLBACK TRAN return -5 --already bind END END UPDATE account SET usertype = (usertype & -241)|32 WHERE id = @userid --0xFFFFFF0F,0x20 INSERT INTO mobilekey (uid, mobilekey, mobilealgorithm) VALUES (@userid,@key,@algorithm) COMMIT TRAN </procedure> <procedure name="unbindmobilekey" connection="auth0" operate="replaceB">  <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false" cache="account_by_id" /> DECLARE @usertypeFromTable integer SELECT @usertypeFromTable=usertype FROM account WHERE id = @userid IF (@@rowcount = 1) BEGIN IF ( (@usertypeFromTable & 240) != 32) --0xF0,0x20 BEGIN return 0 --not bind mobilekey END BEGIN TRAN UPDATE account SET usertype = (usertype & -241) WHERE id = @userid --0xFFFFFF0F DELETE FROM mobilekey WHERE uid = @userid COMMIT TRAN END </procedure>  <procedure name="querymobilekeybyid" connection="auth0" operate="replaceA"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> <parameter name="mobilealgorithm" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="mobilekey" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> SELECT @uid=uid,@mobilealgorithm=mobilealgorithm, @mobilekey=mobilekey FROM mobilekey WHERE uid = @uid IF (@@rowcount != 1) BEGIN return -1 END </procedure> <procedure name="querymatrixbyid" connection="auth0" operate="replaceB" cache="matrix_by_uid" key="uid"> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="true" out="true" /> <parameter name="recordid" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="matrixid" sql-type="char(12)" java-type="java.lang.String" in="false" out="true" /> <parameter name="matrix" sql-type="binary(80)" java-type="byte[]" in="false" out="true" /> SELECT @uid=uid,@recordid=recordid, @matrixid=matrixid, @matrix=matrix FROM matrix WHERE uid = @uid IF (@@rowcount != 1) BEGIN return -1 END </procedure> <query name="getUserPhone"> <table name="phone" alias="p" /> <column name="phone" column="p.phone" /> <select name="byUid" condition="WHERE p.uid = ?" /> <select name="byName" condition="WHERE p.uid = (SELECT id FROM account WHERE name=?)" /> </query> <query name="getPhoneUser" cachevalue="multi"> <table name="phone" alias="p" /> <column name="uid" column="p.uid" /> <column name="phone" compute="rtrim(p.phone)" java-type="String" /> <select name="byPhone" condition="WHERE p.phone = ?" cache="phoneuser_by_phone" key="phone"/> </query> <procedure name="bindPhone" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="phone" sql-type="char(16)" java-type="java.lang.String" in="true" out="false" cache="phoneuser_by_phone"/> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN SELECT @error = 0 DECLARE @uid integer DECLARE @usertype_old integer SELECT @uid = id, @usertype_old = usertype FROM account WHERE name = @name IF @@rowcount = 0 SELECT @error = 4 ELSE IF (@usertype_old & 240) > 0 AND NOT (@usertype_old & 240) = 64 --0xF0,0x40 SELECT @error = 5 ELSE BEGIN IF 5 > (SELECT count(*) FROM phone WHERE uid = @uid) BEGIN IF 5 > (SELECT count(*) FROM phone WHERE phone = @phone) BEGIN IF EXISTS (SELECT * FROM phone WHERE uid = @uid and phone = @phone) SELECT @error = 3 ELSE BEGIN INSERT INTO phone VALUES( @uid, @phone ) UPDATE account SET usertype = (usertype&-241)|64 WHERE id = @uid --0xFFFFFF0F,0x40 END END ELSE SELECt @error = 2 END ELSE SELECT @error = 1 END COMMIT TRAN </procedure> <procedure name="unbindPhone" connection="auth0" operate="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="phone" sql-type="char(16)" java-type="java.lang.String" in="true" out="false" cache="phoneuser_by_phone"/> <parameter name="error" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN DECLARE @uid integer DECLARE @usertype_old integer SELECT @uid = id, @usertype_old = usertype FROM account where name = @name IF @@rowcount = 0 SELECT @error = 2 ELSE IF NOT (@usertype_old & 240) = 64 --0xF0,0x40 SELECT @error = 3 ELSE BEGIN DELETE phone FROM phone WHERE uid = @uid AND phone = @phone IF @@rowcount = 1 SELECT @error = 0 ELSE SELECT @error = 1 IF NOT EXISTS (SELECT * FROM phone WHERE uid = @uid) UPDATE account SET usertype = (usertype&-241) WHERE name = @name --0xFFFFFF0F END COMMIT TRAN </procedure> <procedure name="clearUserPhone" connection="auth0" operator="replaceB"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" cache="account_by_name" /> <parameter name="ret" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> BEGIN TRAN DECLARE @uid integer DECLARE @usertype_old integer SELECT @uid = id, @usertype_old = usertype FROM account WHERE name = @name IF @@rowcount = 0 SELECT @ret = -2 ELSE IF NOT (@usertype_old & 240) = 64 --0xF0,0x40 SELECT @ret = -3 ELSE BEGIN UPDATE account SET usertype = (usertype&-241) WHERE id = @uid --0xFFFFFF0F DELETE FROM phone WHERE uid = @uid SELECT @ret = @@rowcount END COMMIT TRAN </procedure>  <procedure name="acquireuserpasswd" connection="auth0" operate="replaceA"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="true" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="passwd" sql-type="binary(16)" java-type="byte[]" in="false" out="true" /> <parameter name="creatime" sql-type="datetime" java-type="java.util.Date" in="false" out="true" /> <parameter name="usertype" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> SELECT @id = id, @name = name, @passwd = passwd, @creatime = creatime, @usertype = usertype FROM account WHERE name = @name if @@rowcount = 0 return -1; return 0; </procedure>  <procedure name="acquireuserpasswd2" connection="auth0" operate="replaceA"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="passwd2" sql-type="binary(16)" java-type="byte[]" in="false" out="true" /> SELECT @id = a.id, @passwd2 = u.passwd2 FROM users u,account a WHERE a.name = @name AND a.id=u.id IF @@rowcount = 0 return -1 return 0 </procedure>  <procedure name="getuseridbyname" connection="auth0" operate="replaceA"> <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" /> <parameter name="uid" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> SELECT @uid = id FROM account WHERE name = @name IF @@rowcount = 0 return -1 return 0 </procedure>  <procedure name="getuserinfobyname" connection="auth0" operate="replaceA"> <parameter name="name" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" /> <parameter name="id" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="prompt" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="answer" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="email" sql-type="varchar(64)" java-type="java.lang.String" in="false" out="true" /> <parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="city" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="phonenumber" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="address" sql-type="varchar(64)" java-type="java.lang.String" in="false" out="true" /> <parameter name="postalcode" sql-type="varchar(8)" java-type="java.lang.String" in="false" out="true" /> <parameter name="gender" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" /> <parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="creatime" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> <parameter name="qq" sql-type="varchar(32)" java-type="java.lang.String" in="false" out="true" /> DECLARE @birthday_tmp datetime DECLARE @creatime_tmp datetime SELECT @id = a.id, @prompt = u.prompt, @answer = u.answer, @truename = u.truename, @idnumber = u.idnumber, @email = u.email, @mobilenumber = u.mobilenumber, @province = u.province, @city = u.city, @phonenumber = u.phonenumber, @address = u.address, @postalcode = u.postalcode, @gender = u.gender, @birthday_tmp = u.birthday, @creatime_tmp = a.creatime, @qq = u.qq FROM users u, account a WHERE a.name = @name AND a.id = u.id IF @@rowcount = 0 return -1 SELECT @birthday = convert(varchar(32), @birthday_tmp, 120) SELECT @creatime = convert(varchar(32), @creatime_tmp, 121) return 0 </procedure> </application>

Re: [Release]BOI Odin Patch - Best and stable release

uplayayım knk

Re: [Release]BOI Odin Patch - Best and stable release

up please help

Re: [Release]BOI Odin Patch - Best and stable release

Please don't double post also just have patience its not like we have time to answer question immediately.
Look at your Athud.out in your build folder if I am right you should have an error which mean it couldn't connect to your MSSQL.

Re: [Release]BOI Odin Patch - Best and stable release

i'm sorry

Quote:

GAuthServer.matrixValid = true
GAuthServer.disable_User_Matrix = false
GAuthServer.allow_all_user = false
GAuthServer.allow_same_zoneid = false
GAuthServer.matrixpasswd_log = false
MatrixPasswd add forbidips=
java.net.BindException: Cannot assign requested address
at sun.nio.ch.Net.bind(Native Method)
at sun.nio.ch.ServerSocketChannelImpl.bind(ServerSocketChannelImpl.java:137)
at sun.nio.ch.ServerSocketAdaptor.bind(ServerSocketAdaptor.java:77)
at com.goldhuman.IO.PassiveIO.Open(Unknown Source)
at com.goldhuman.IO.Protocol.Protocol.Server(Unknown Source)
at authd.main(Unknown Source)
authd:: add PollIO task.
configuring log4j with log4j.xml
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at com.wanmei.db.Connection.<init>(Unknown Source)
at com.wanmei.db.Application.<init>(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork.createInstance(Unknown Source)
at authd.main(Unknown Source)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)

1 Attachment(s)

Re: [Release]BOI Odin Patch - Best and stable release

Attachment 141846

Quote:

GAuthServer.matrixValid = true
GAuthServer.disable_User_Matrix = false
GAuthServer.allow_all_user = false
GAuthServer.allow_same_zoneid = false
GAuthServer.matrixpasswd_log = false
MatrixPasswd add forbidips=
authd:: add PollIO task.
configuring log4j with log4j.xml
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:620)
at java.sql.DriverManager.getConnection(DriverManager.java:200)
at com.wanmei.db.Connection.<init>(Unknown Source)
at com.wanmei.db.Application.<init>(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork.createInstance(Unknown Source)
at authd.main(Unknown Source)
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusecashnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$1.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
java.lang.NullPointerException
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at com.wanmei.db.ApplicationThreadFrameWork$1.initialValue(Unknown Source)
at java.lang.ThreadLocal.setInitialValue(ThreadLocal.java:160)
at java.lang.ThreadLocal.get(ThreadLocal.java:150)
at com.wanmei.db.ApplicationThreadFrameWork.getContext(Unknown Source)
at com.wanmei.db.passport.query.Getusebonusnow.selectbystatus(Unknown Source)
at protocol.GAuthServer$2.run(Unknown Source)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792
Protocol Decode CheckPolicy Error:type=122,size=6792

Linux connecting to SQL Server now but show new error.

Re: [Release]BOI Odin Patch - Best and stable release

asere Last Warning then I will report you, Edit your last post to aviod double posting and use the spoiler or code tags to it will minimize what your are posting.
GAthudclient means it cannot connect to your MSSQL check IP if its not that double check your database and/or password

Re: [Release]BOI Odin Patch - Best and stable release

Check this :

authd.conf > BOI/authd/config/

Quote:

[GAuthServer]
type = tcp
port = 29200
address = 192.168.137.2 < LINUX IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 819200
obuffermax = 819200
tcp_nodelay = 1
listen_backlog = 10
mtrace = /tmp/mtrace.authd
osec = 2
oseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l
isec = 2
iseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds
shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje
isabroad = true
ismssql = true

[ThreadPool]
config = (1,1)(2,10)(3,1)(101,5)
max_queuesize = 1048576

BOIServerWin/Auagent/auagent.conf

Quote:

[AuAgentServer]
zoneid = 904
aid = 9
type = tcp
port = 29250
address = 192.168.0.108 < WINDOWS IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
tcp_nodelay = 1
listen_backlog = 10
mtrace = /tmp/m_trace.link

[GameDBClient]
type = tcp
port = 29251
address = 192.168.0.107 < LINUX IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
tcp_nodelay = 1
;listen_backlog = 10
mtrace = /tmp/m_trace.link
cashfile = d:\cash_backup.data

[GAuthClient]
type = tcp
port = 29200
address = 192.168.0.107 < LINUX IP
so_sndbuf = 131072
so_rcvbuf = 131072
ibuffermax = 409600
obuffermax = 819200
;so_broadcast = 1
tcp_nodelay = 1
osec = 2
oseckey = n1hxpxztozyxnsvk6RaycpmrCnrdds
isec = 2
iseckey = rdppjtaki1MxoHnsnaltiiwfjszs9l
shared_key = 4khdwAAcjrg0eqfzazqcemdpgulnje

;if use certverify between au,1:use,0:not use,default use
issupport_cert = 0

[ThreadPool]
config = (1,1)(2,4)(3,2)
max_queuesize = 1048576
;prior_strict = 1

[SpeedLimit]
window = 20
high = 2

[TimeoutLimit]
;window > 60
window = 180
high = 200

[CouponLimit]
;GetUserCoupon limit
window = 300
high = 2

[CouponExchangeLimit]
;CouponExchange limit
window = 120
high = 2

Check the bold

Re: [Release]BOI Odin Patch - Best and stable release

Hello, how to use GM commands? (setpower not work)

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by k01dun

Hello, how to use GM commands? (setpower not work)

He change the commands its something else you have to download his BOI Hex Editor Here

Re: [Release]BOI Odin Patch - Best and stable release

NanayaQ tnx!
necrentos, can U make mySQL version?

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by k01dun

NanayaQ tnx!
necrentos, can U make mySQL version?

you mean, banish mssql and use mysql to hold the accounts info?

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by k01dun

NanayaQ tnx!
necrentos, can U make mySQL version?

[Release] Battle of The Immortals Odin's Wrath - RaGEZONE forums

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by necrentos

Hello.

this is my 1st release of any boi files.

so i hope you guys appreciate it.

This release of the BOI Odin Expansion is a better and easy one to set up with only few steps.

Change log of this Release.

Requeriments

Video How to configure and set up mssql and boi files
http://www.youtube.com/watch?v=jRN8PXTHN_w
Watch in HD*
if this video are too fast for you, you can pause video on each step.
subscript for more video, this is the first video but all my work will be on youtube like
add script on npc, add script on item.....

Thank you for your attention. hope you all make a nice server with your custom and make it public so we all can appreciate your job and get some fun =)

Note* If i forgot anything i'll add here. thanks again and Sorry for my bad english

necros can you upload centOS too ? thanks or give only link from where to download xD

Re: [Release]BOI Odin Patch - Best and stable release

hmmm having issues with ur release the bin/bash^M error and ive tried using dos2unix on start.sh to fix it and on the create-database.sh but its still doing it when i try to start up linux side any help?

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by niknik1

necros can you upload centOS too ? thanks or give only link from where to download xD

CentOS are the same there no difference you can get CentOS from the BoI release section if you look for it and read, also you can download a fresh centos and use it theres really not a difference except IP and have the necessary software.

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by necrentos

you mean, banish mssql and use mysql to hold the accounts info?

yep bro, coz i try to replace gacd files & its work correctly but if i try replace authd files (but use my table.xml) - its start but in windows side i see: faild to connect to au

Re: [Release]BOI Odin Patch - Best and stable release

same here faild to connect to au

Re: [Release]BOI Odin Patch - Best and stable release

I'll post my server with 2 vmware.1 linux 1 windowserver.only thing you need to change is ip.then start xD

Re: [Release]BOI Odin Patch - Best and stable release

required for server, which ports open it?

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by asere

required for server, which ports open it?

Portforward 30002 for everyone to join your server

Re: [Release]BOI Odin Patch - Best and stable release

any1 know why i see many:

2013-12-12 20:15:09 lv2:GS1:CGameServer::OnTimer : CheckGraphCodeStatus : 1
2013-12-12 20:15:47 lv2:GS1:CGameServer::OnTimer : CheckGraphCodeStatus : 1

&

RegSysVar 1
RegSysVar 1
RegSysVar 1
....
RegSysVar 1

&

2013-12-12 20:34:47 lv2:MS:socket err:1236 -- CGameServerSession::OnError -- CIOCPSession::OnIOCompleteFailed

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by k01dun

any1 know why i see many:

2013-12-12 20:15:09 lv2:GS1:CGameServer::OnTimer : CheckGraphCodeStatus : 1
2013-12-12 20:15:47 lv2:GS1:CGameServer::OnTimer : CheckGraphCodeStatus : 1

&

RegSysVar 1
RegSysVar 1
RegSysVar 1
....
RegSysVar 1

&

2013-12-12 20:34:47 lv2:MS:socket err:1236 -- CGameServerSession::OnError -- CIOCPSession::OnIOCompleteFailed

hmm its odd never seen that

Code:

lv2:GS1:CGameServer::OnTimer : CheckGraphCodeStatus : 1

error before

But

Code:

RegSysVar 1

means that your manager.exe is not working right you can try to reset your manager.exe. Sometime it takes minutes to load up your line.exe if your running a lot of realm or have low memory.

Re: [Release]BOI Odin Patch - Best and stable release

Hello all. I have this problem:

Spoiler:

[root@localhost ~]# #!/bin/bash
[root@localhost ~]#
[root@localhost ~]# cd /home/BOI
[root@localhost BOI]#
[root@localhost BOI]# cd DBServer/bin
[root@localhost bin]#
[root@localhost bin]# ./dbserver &
[1] 2496
[root@localhost bin]#
[root@localhost bin]# cd /home/BOI/CardServer/bin
[root@localhost bin]#
[root@localhost bin]# ./cardsvrd &
[2] 2497
[root@localhost bin]#
[root@localhost bin]# cd /home/BOI/NameServerbash: ./dbserver: Permission denied
/bin
[root@localhost bin]#
bash: ./cardsvrd: Permission denied
[root@localhost bin]# ./namesvrd &
[3] 2498
[1] Exit 126 ./dbserver (wd: /home/BOI/DBServer/bin)
(wd now: /home/BOI/NameServer/bin)
[2] Exit 126 ./cardsvrd (wd: /home/BOI/CardServer/bin)
(wd now: /home/BOI/NameServer/bin)
[root@localhost bin]#
[root@localhost bin]# cd /home/Bbash: ./namesvrd: Permission denied
OI/gacd
[root@localhost gacd]#
[root@localhost gacd]# ./gacd io.conf &
[4] 2499
[3] Exit 126 ./namesvrd (wd: /home/BOI/NameServer/bin)
(wd now: /home/BOI/gacd)
[root@localhost gacd]#
[root@localhost gacd]# cd /home/BOI/LogServer/bin
[root@localhost bin]#
bash: ./gacd: Permission denied
[root@localhost bin]# ./logsrv &
[5] 2500
[4]- Exit 126 ./gacd io.conf (wd: /home/BOI/gacd)
(wd now: /home/BOI/LogServer/bin)
[root@localhost bin]#
[root@localhost bin]# cd /home/BOI/authd/build
[root@localhost build]#
[root@localhost build]# bash: ./logsrv: Permission denied
./authd &
[6] 2501
[5] Exit 126 ./logsrv (wd: /home/BOI/LogServer/bin)
(wd now: /home/BOI/authd/build)
[root@localhost build]# bash: ./authd: Permission denied

[6]+ Exit 126 ./authd
[root@localhost build]#

what to do and how to get rid of this problem?

Re: [Release]BOI Odin Patch - Best and stable release

This is only a patch and need a old version or i can start with this version ?

Re: [Release]BOI Odin Patch - Best and stable release

Now I have a problem:
]http://s019.radikal.ru/i643/1312/aa/adeb6995cd4at.jpg[/IMG]

Re: [Release]BOI Odin Patch - Best and stable release

I have a problem here happened .... IP address all correct, true identity passwords written, firewalls and antivirus programs are disabled .... tell me what could be the Problem.
[IMG]http://i017.radikal.ru/1312/3e/168cea364afa.jpg[/IMG]
[IMG]http://s019.radikal.ru/i601/1312/a0/eaa0ee971f74.png[/IMG]

Re: [Release]BOI Odin Patch - Best and stable release

What did i do wrong ? Can u help me http://i39.tinypic.com/6xx9wx.jpg

Re: [Release]BOI Odin Patch - Best and stable release

http://i0.upanh.com/2014/0123/14//58590990.error.jpg
Hey guys i was installed sever for a long time ago.but now i got error with mysql.because i dont have Mysql stable with Mssql.use version martinle works fine but i got this error.help me.Mysql auto gens when start but i always got error

Re: [Release]BOI Odin Patch - Best and stable release

as i can see in cfg file - iweb port
whats iWeb & how to use this?

Re: [Release]BOI Odin Patch - Best and stable release

i don't get it..can anyone help me with teamviewer step by step?

Re: [Release]BOI Odin Patch - Best and stable release

have new errors :/:

http://s10.postimg.org/p2k1yxzih/111.png

http://s30.postimg.org/nd280u941/222.png

enother errors:
info - user(id=0) error (code=8, info='no matroxpasswd cache!')
info - matrixpasswd timeout!

Re: [Release]BOI Odin Patch - Best and stable release

Thankyou for the files.

Re: [Release]BOI Odin Patch - Best and stable release

necrentos, bro, i wait for or mysql auth version))
i try to replace auth from mssql to mysql in table.xml
all starting ok, but, then i try to login i have error like wrong login/password, in logs i see: martixpswd error or something like this

any ideas?)

Re: [Release]BOI Odin Patch - Best and stable release

Could someone reupload the database?

Re: [Release]BOI Odin Patch - Best and stable release

ho Someone Reupload Please Database link dead Thank in Advance

Re: [Release]BOI Odin Patch - Best and stable release

ReUpload Database, link is dead PLEASE!

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by wartio

ReUpload Database, link is dead PLEASE!

You can use older database of BOI.
After go to linux. You should use database which you downloaded and it should be restored to "shengui" database name.

When you started server success on linux. It will alter new tables to old database automatic.

Re: [Release]BOI Odin Patch - Best and stable release

Quote:

Originally Posted by janethorne

You can use older database of BOI.
After go to linux. You should use database which you downloaded and it should be restored to "shengui" database name.

When you started server success on linux. It will alter new tables to old database automatic.

Where shall it be placed?

Re: [Release]BOI Odin Patch - Best and stable release

the velocity of the video its just a ridiculous. It make's sense if you do that for the install things to make the video short, but it's not the case... it makes no sense.

Why that guides there are so incomplete? its like that guides are made for people know what they are doing, not for new people want to try to get this work.... a lot of crucial steps are missed for newbies then whats the point on making guides for people that are already had a server up? I thnx the effort put on this but really?

PD: im not telling to you necrentos, i just posted there because im in the last post before i leave... i read all guides here and it makes no sense any guide... if you see all the posts will see all the people lost.