API tools faq
paste
Advertisement
shadowvzs

Untitled

shadowvzs
Dec 1st, 2023
1,047
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 24.39 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="ISO-8859-1"?>
  2. <?xml-stylesheet type="text/xsl" href="table.xsl"?>
  3.  
  4. <application debug="false" >
  5.  
  6. <driver name="com.mysql.jdbc.Driver" />
  7. <connection name="auth0" poolsize="3" url="jdbc:mysql://127.0.0.1/pw?useUnicode=true&amp;characterEncoding=utf8" username="root" password="root"/>
  8.  
  9.  
  10. <table name="users" connection="auth0" operate="replaceA">
  11.     <column name="id"           sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  12.     <column name="name"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
  13.     <column name="passwd"       sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="true" />
  14.     <column name="prompt"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
  15.     <column name="answer"       sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
  16.     <column name="truename"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
  17.     <column name="idnumber"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="true" />
  18.     <column name="email"        sql-type="varchar(64)" java-type="java.lang.String"  not-null="true" />
  19.     <column name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
  20.     <column name="province"     sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
  21.     <column name="city"         sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
  22.     <column name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
  23.     <column name="address"      sql-type="varchar(64)" java-type="java.lang.String"  not-null="false" />
  24.     <column name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String"  not-null="false" />
  25.     <column name="gender"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  26.     <column name="birthday"     sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
  27.     <column name="creatime"     sql-type="datetime"    java-type="java.util.Date"    not-null="true" />
  28.     <column name="qq"           sql-type="varchar(32)" java-type="java.lang.String"  not-null="false" />
  29.     <column name="passwd2"      sql-type="binary(16)"  java-type="java.lang.reflect.Array"  not-null="false" />
  30.  
  31.     <primarykey name="pk_id" column="id" />
  32.     <index name="ind_name" unique="true" column="name" />
  33.     <index name="ind_creatime" column="creatime" />
  34. </table>
  35.  
  36. <table name="iplimit" connection="auth0" operate="replaceA">
  37.     <column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  38.     <column name="ipaddr1"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  39.     <column name="ipmask1"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
  40.     <column name="ipaddr2"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  41.     <column name="ipmask2"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
  42.     <column name="ipaddr3"      sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  43.     <column name="ipmask3"      sql-type="varchar(2)"  java-type="java.lang.String" not-null="false" />
  44.     <column name="enable"       sql-type="char(1)"     java-type="java.lang.String" not-null="false" />
  45.     <column name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" not-null="false" />
  46.  
  47.     <primarykey name="pk_iplimit" column="uid" />
  48. </table>
  49.  
  50. <table name="auth" connection="auth0" operate="replaceA">
  51.     <column name="userid"       sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  52.     <column name="zoneid"       sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  53.     <column name="rid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  54.     <primarykey name="pk_id" column="userid, zoneid, rid" />
  55. </table>
  56.  
  57. <table name="forbid" connection="auth0" operate="replaceA">
  58.     <column name="userid"       sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
  59.     <column name="type"         sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
  60.     <column name="ctime"        sql-type="datetime"     java-type="java.util.Date"   not-null="true" />
  61.     <column name="forbid_time"  sql-type="integer"      java-type="java.lang.Integer" not-null="true" />
  62.     <column name="reason"     sql-type="varbinary(255)" java-type="java.lang.reflect.Array" not-null="true" />
  63.     <column name="gmroleid"     sql-type="integer"      java-type="java.lang.Integer" not-null="false"/>
  64.  
  65.     <primarykey name="pk_id" column="userid,type" />
  66. </table>
  67.  
  68. <table name="point" connection="auth0" operate="replaceA">
  69.     <column name="uid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  70.     <column name="aid"          sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  71.     <column name="time"         sql-type="integer"     java-type="java.lang.Integer" not-null="true" />
  72.     <column name="zoneid"       sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  73.     <column name="zonelocalid"  sql-type="integer"     java-type="java.lang.Integer" not-null="false" />
  74.     <column name="accountstart" sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
  75.     <column name="lastlogin"    sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
  76.     <column name="enddate"      sql-type="datetime"    java-type="java.util.Date"    not-null="false" />
  77.  
  78.     <primarykey name="pk_id" column="uid, aid" />
  79.     <index name="ind_aid" column="aid,zoneid" />
  80. </table>
  81.  
  82. <table name="usecashnow" connection="auth0" operate="replaceA">
  83.     <column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  84.     <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  85.     <column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  86.     <column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  87.     <column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  88.     <column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  89.     <!--status 1.create; 2.get sn; 3.send addcash; 4.finish; -->
  90.     <column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
  91.     <column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>
  92.  
  93.     <primarykey name="pk_usecashnow" column="userid, zoneid, sn" />
  94.     <index name="ind_usecashnow_status" column="status" />
  95.     <index name="ind_usecashnow_creatime" column="creatime" />
  96. </table>
  97.  
  98. <table name="usecashlog" connection="auth0" operate="replaceA">
  99.     <column name="userid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  100.     <column name="zoneid" sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  101.     <column name="sn"     sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  102.     <column name="aid"    sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  103.     <column name="point"  sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  104.     <column name="cash"   sql-type="integer" java-type="java.lang.Integer" not-null="true"/>
  105.     <column name="status" sql-type="integer"  java-type="java.lang.Integer" not-null="true"/>
  106.     <column name="creatime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>
  107.     <column name="fintime" sql-type="datetime" java-type="java.util.Date"  not-null="true"/>
  108.  
  109.     <index name="ind_usecashlog_uzs" column="userid, zoneid, sn" />
  110.     <index name="ind_usecashlog_creatime" column="creatime" />
  111. </table>
  112.  
  113. <query name="getUserid">
  114.     <table name="users" alias="u" />
  115.     <column name="id" column="u.id" />
  116.     <select name="byName" condition="WHERE u.name = ?" />
  117. </query>
  118.  
  119. <query name="getUserInfo">
  120.     <table name="users" alias="u" />
  121.     <column name="id" column="u.id" />
  122.     <column name="prompt" column="u.prompt" />
  123.     <column name="answer" column="u.answer" />
  124.     <column name="truename" column="u.truename" />
  125.     <column name="idnumber" column="u.idnumber" />
  126.     <column name="email" column="u.email" />
  127.     <column name="mobilenumber" column="u.mobilenumber" />
  128.     <column name="province" column="u.province" />
  129.     <column name="city" column="u.city" />
  130.     <column name="phonenumber" column="u.phonenumber" />
  131.     <column name="address" column="u.address" />
  132.     <column name="postalcode" column="u.postalcode" />
  133.     <column name="gender" column="u.gender" />
  134.     <column name="birthday" column="u.birthday" />
  135.     <column name="creatime" column="u.creatime" />
  136.     <column name="qq" column="u.qq" />
  137.     <select name="byName" condition="WHERE u.name = ?" />
  138. </query>
  139.  
  140. <query name="getUsername">
  141.     <table name="users" alias="u" />
  142.     <column name="name" column="u.name" />
  143.     <select name="byId" condition="WHERE u.id = ?"/>
  144. </query>
  145.  
  146. <query name="acquireIdPasswd">
  147.     <table name="users" alias="u" />
  148.     <column name="id" column="u.id" />
  149.     <column name="passwd" column="u.passwd" />
  150.     <column name="creatime" column="u.creatime" />
  151.     <select name="byName" condition="WHERE u.name = ?"/>
  152. </query>
  153.  
  154. <query name="acquireIdPasswd2">
  155.     <table name="users" alias="u" />
  156.     <column name="id" column="u.id" />
  157.     <column name="passwd2" column="u.passwd2" />
  158.     <select name="byName" condition="WHERE u.name = ?"/>
  159. </query>
  160.  
  161. <query name="acquireUserCreatime">
  162.     <table name="users" alias="u" />
  163.     <column name="creatime" column="u.creatime" />
  164.     <select name="byUid" condition="WHERE u.id = ?"/>
  165. </query>
  166.  
  167. <query name="getIPLimit">
  168.     <table name="iplimit" alias="i" />
  169.     <column name="uid" column="i.uid" />
  170.     <column name="ipaddr1" column="i.ipaddr1" />
  171.     <column name="ipmask1" column="i.ipmask1" />
  172.     <column name="ipaddr2" column="i.ipaddr2" />
  173.     <column name="ipmask2" column="i.ipmask2" />
  174.     <column name="ipaddr3" column="i.ipaddr3" />
  175.     <column name="ipmask3" column="i.ipmask3" />
  176.     <column name="enablue" column="i.enable" />
  177.     <column name="lockstatus" column="i.lockstatus" />
  178.     <select name="byUid" condition="WHERE i.uid = ?"/>
  179. </query>
  180.  
  181. <query name="acquireUserPrivilege">
  182.     <table name="auth" alias="au" />
  183.     <column name="rid" column="au.rid" />
  184.     <select name="byUidZid" condition="WHERE au.userid = ? AND au.zoneid = ?"/>
  185. </query>
  186.  
  187. <query name="acquirePrivilege">
  188.     <table name="auth" alias="au" />
  189.     <table name="users" alias="users" />
  190.     <column name="userid" column="au.userid" />
  191.     <column name="zoneid" column="au.zoneid" />
  192.     <column name="rid" column="au.rid" />
  193.     <column name="name" column="users.name" />
  194.     <column name="creatime" column="users.creatime" />
  195.     <select name="byZid" condition="WHERE au.userid = users.id AND au.zoneid = ?"/>
  196.     <select name="byUid" condition="WHERE au.userid = users.id AND au.userid = ?"/>
  197.     <select name="byUidZid" condition="WHERE au.userid = users.id AND au.userid = ? AND au.zoneid = ?"/>
  198.     <select name="byRidZid" condition="WHERE au.userid = users.id AND au.rid = ? AND au.zoneid = ?"/>
  199.     <select name="byAll" condition="WHERE au.userid = users.id"/>
  200. </query>
  201.  
  202. <query name="acquireForbid">
  203.     <table name="forbid" alias="fb"/>
  204.     <column name="userid" column="fb.userid"/>
  205.     <column name="type" column="fb.type"/>
  206.     <column name="ctime" column="fb.ctime"/>
  207.     <column name="forbid_time" column="fb.forbid_time"/>
  208.     <column name="reason" column="fb.reason"/>
  209.     <column name="gmroleid" column="fb.gmroleid"/>
  210.     <select name="byUid" condition="WHERE fb.userid = ? and time_to_sec(timediff(Now(),fb.ctime))&lt;=fb.forbid_time"/>
  211. </query>
  212.  
  213. <query name="getUserOnlineInfo">
  214.     <table name="point" alias="p"/>
  215.     <column name="zoneid" column="p.zoneid"/>
  216.     <column name="localsid" column="p.zonelocalid"/>
  217.     <column name="aid" column="p.aid"/>
  218.     <select name="byUid" condition="WHERE p.uid = ?"/>
  219. </query>
  220.  
  221. <query name="getUserPoints">
  222.     <table name="point" alias="p" />
  223.     <column name="aid" column="p.aid" />
  224.     <column name="time" column="p.time" />
  225.     <column name="enddate" column="p.enddate" />
  226.     <select name="byuid" condition="where p.uid=? and NOT p.aid=0" />
  227. </query>
  228.  
  229. <query name="getusecashnow">
  230.     <table name="usecashnow" alias="u"/>
  231.     <column name="userid" column="u.userid"/>
  232.     <column name="zoneid" column="u.zoneid"/>
  233.     <column name="sn" column="u.sn"/>
  234.     <column name="aid" column="u.aid"/>
  235.     <column name="point" column="u.point"/>
  236.     <column name="cash" column="u.cash"/>
  237.     <column name="status" column="u.status"/>
  238.     <column name="creatime" column="u.creatime"/>
  239.  
  240.     <select name="bystatus" condition="WHERE status = ? AND creatime &lt; date_add(now(), INTERVAL '-200' SECOND)"/>
  241.     <select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
  242.     <select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
  243.     <select name="byuser" condition="WHERE u.userid = ?"/>
  244. </query>
  245.  
  246. <query name="getusecashlog">
  247.     <table name="usecashlog" alias="u"/>
  248.     <column name="userid" column="u.userid"/>
  249.     <column name="zoneid" column="u.zoneid"/>
  250.     <column name="sn" column="u.sn"/>
  251.     <column name="aid" column="u.aid"/>
  252.     <column name="point" column="u.point"/>
  253.     <column name="cash" column="u.cash"/>
  254.     <column name="status" column="u.status"/>
  255.     <column name="creatime" column="u.creatime"/>
  256.     <column name="fintime" column="u.fintime"/>
  257.  
  258.     <select name="byuserzone" condition="WHERE u.userid = ? AND u.zoneid = ?"/>
  259.     <select name="byuserzonesn" condition="WHERE u.userid = ? AND u.zoneid = ? AND u.sn = ?"/>
  260.     <select name="byuser" condition="WHERE u.userid = ?"/>
  261. </query>
  262.  
  263. <procedure name="acquireuserpasswd" connection="auth0" operate="replaceA">
  264.  <parameter name="name1"     sql-type="varchar(64)"  java-type="java.lang.String"  in="true"  out="false" />
  265.  <parameter name="uid1"      sql-type="integer"      java-type="java.lang.Integer" in="false" out="true" />
  266.  <parameter name="passwd1"   sql-type="varchar(64)"  java-type="java.lang.String"  in="false" out="true" />
  267. </procedure>
  268.  
  269. <procedure name="adduser" connection="auth0" operate="replaceA">
  270.     <parameter name="name"     sql-type="varchar(64)"  java-type="java.lang.String" in="true" out="false" />
  271.     <parameter name="passwd"   sql-type="binary(16)"   java-type="java.lang.reflect.Array" in="true" out="false" />
  272.     <parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  273.     <parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  274.     <parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  275.     <parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  276.     <parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  277.     <parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  278.     <parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  279.     <parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  280.     <parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  281.     <parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  282.     <parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
  283.     <parameter name="gender"   sql-type="integer"  java-type="java.lang.Integer" in="true" out="false" />
  284.     <parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  285.     <parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  286.     <parameter name="passwd2"  sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
  287. </procedure>
  288.  
  289. <procedure name="updateUserInfo" connection="auth0" operate="replaceA">
  290.     <parameter name="name"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  291.     <parameter name="prompt"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  292.     <parameter name="answer"   sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  293.     <parameter name="truename" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  294.     <parameter name="idnumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  295.     <parameter name="email"    sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  296.     <parameter name="mobilenumber" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  297.     <parameter name="province" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  298.     <parameter name="city"     sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  299.     <parameter name="phonenumber"  sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  300.     <parameter name="address"  sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  301.     <parameter name="postalcode"   sql-type="varchar(8)"  java-type="java.lang.String" in="true" out="false" />
  302.     <parameter name="gender"   sql-type="integer"    java-type="java.lang.Integer" in="true" out="false" />
  303.     <parameter name="birthday" sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  304.     <parameter name="qq"       sql-type="varchar(32)" java-type="java.lang.String" in="true" out="false" />
  305. </procedure>
  306.  
  307. <procedure name="changePasswd" connection="auth0" operate="replaceA">
  308.     <parameter name="name"   sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  309.     <parameter name="passwd" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
  310. </procedure>
  311.  
  312. <procedure name="changePasswd2" connection="auth0" operate="replaceA">
  313.     <parameter name="name" sql-type="varchar(64)" java-type="java.lang.String" in="true" out="false" />
  314.     <parameter name="passwd2" sql-type="binary(16)" java-type="java.lang.reflect.Array" in="true" out="false" />
  315. </procedure>
  316.  
  317. <procedure name="setiplimit" connection="auth0" operate="replaceA">
  318.     <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  319.     <parameter name="ipaddr1"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  320.     <parameter name="ipmask1"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
  321.     <parameter name="ipaddr2"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  322.     <parameter name="ipmask2"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
  323.     <parameter name="ipaddr3"  sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  324.     <parameter name="ipmask3"  sql-type="varchar(2)"  java-type="java.lang.String" in="true" out="false"/>
  325. </procedure>
  326.  
  327. <procedure name="enableiplimit" connection="auth0" operate="replaceA">
  328.     <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  329.     <parameter name="enable"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
  330. </procedure>
  331.  
  332. <procedure name="lockuser" connection="auth0" operate="replaceA">
  333.     <parameter name="uid"      sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  334.     <parameter name="lockstatus"   sql-type="char(1)"     java-type="java.lang.String" in="true" out="false"/>
  335. </procedure>
  336.  
  337. <procedure name="addUserPriv" connection="auth0" operate="replaceA">
  338.     <parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  339.     <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  340.     <parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  341. </procedure>
  342.  
  343. <procedure name="delUserPriv" connection="auth0" operate="replaceA">
  344.     <parameter name="userid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  345.     <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  346.     <parameter name="rid"      sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  347.     <parameter name="deltype"  sql-type="integer"  java-type="java.lang.Integer"   in="true" out="false" />
  348. </procedure>
  349.  
  350. <procedure name="addForbid" connection="auth0" operate="replaceA">
  351.     <parameter name="userid"   sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  352.     <parameter name="type"     sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  353.     <!--parameter name="ctime" sql-type="datetime"    java-type="java.util.Date"    in="true" out="false"/-->
  354.     <parameter name="forbid_time" sql-type="integer"  java-type="java.lang.Integer" in="true" out="false"/>
  355.     <parameter name="reason"   sql-type="varbinary(255)" java-type="java.lang.reflect.Array"  in="true" out="false"/>
  356.     <parameter name="gmroleid" sql-type="integer"     java-type="java.lang.Integer" in="true" out="false"/>
  357. </procedure>
  358.  
  359. <procedure name="deleteTimeoutForbid" connection="auth0" operate="replaceA">
  360.     <parameter name="userid"    sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  361. </procedure>
  362.  
  363. <procedure name="clearonlinerecords" connection="auth0" operate="replaceA">
  364.     <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  365.     <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  366. </procedure>
  367.  
  368. <procedure name="recordonline" connection="auth0" operate="replaceA">
  369.     <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  370.     <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  371.     <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
  372.     <parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
  373.     <parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true"  />
  374. </procedure>
  375.  
  376. <procedure name="recordoffline" connection="auth0" operate="replaceA">
  377.     <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  378.     <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="false" />
  379.     <parameter name="zoneid"   sql-type="integer"  java-type="java.lang.Integer"     in="true"  out="true" />
  380.     <parameter name="zonelocalid" sql-type="integer"  java-type="java.lang.Integer"  in="true"  out="true" />
  381.     <parameter name="overwrite" sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="true" />
  382. </procedure>
  383.  
  384. <procedure name="remaintime" connection="auth0" operate="replaceA">
  385.     <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
  386.     <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
  387.     <parameter name="remain"   sql-type="integer"  java-type="java.lang.Integer"    in="false" out="true" />
  388.     <parameter name="freetimeleft" sql-type="integer" java-type="java.lang.Integer" in="false" out="true" />
  389. </procedure>
  390.  
  391. <procedure name="adduserpoint" connection="auth0" operate="replaceA">
  392.     <parameter name="uid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
  393.     <parameter name="aid"      sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
  394.     <parameter name="time"     sql-type="integer"  java-type="java.lang.Integer"    in="true"  out="false" />
  395. </procedure>
  396.  
  397. <procedure name="usecash" connection="auth0" operate="replaceA">
  398.     <parameter name="userid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  399.     <parameter name="zoneid" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  400.     <parameter name="sn"     sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  401.     <parameter name="aid"    sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  402.     <parameter name="point"  sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  403.     <parameter name="cash"   sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  404.     <parameter name="status" sql-type="integer" java-type="java.lang.Integer" in="true" out="false"/>
  405.     <parameter name="error"  sql-type="integer" java-type="java.lang.Integer" in="false" out="true"/>
  406. </procedure>
  407.  
  408. </application>
  409.  
  410.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!