/Script/init_player.sql

http://awoe.googlecode.com/ · SQL · 179 lines · 164 code · 15 blank · 0 comment · 0 complexity · 82c9e7113d18fe54f6d6a08c1b6848dc MD5 · raw file 

    

  1. delete from player;

    2. 

  2. INSERT INTO `player` (`pid`, `aid`, `name`, `gender`, `features`, `money_g`, `money_s`, `prop_vit`, `prop_str`, `prop_agi`, `prop_int`, `prop_left`, ftype) VALUES

    3. 

  3. (1, 1, 'Eric', 0, 0, 0000000100, 0000000100, 00001, 00002, 00003, 00000, 00000, 1),

    4. 

  4. (2, 1, 'Stormreach', 1, 3, 0000000433, 0000000321, 00002, 00003, 00004, 00005, 00001, 2),

    5. 

  5. (3, 2, 'Wizard', 0, 0, 0000000000, 0000000000, 00000, 00000, 00000, 00000, 00000, 3),

    6. 

  6. (4, 2, 'Shisan', 2, 5, 0000000000, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    7. 

  7. (5, 3, 'Vincent', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    8. 

  8. (6, 3, 'SLang', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    9. 

  9. (7, 4, 'Google', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    10. 

  10. (8, 5, 'Baidu', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    11. 

  11. (9, 6, 'Ubisoft', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2),

    12. 

  12. (10, 7, 'Waking', 5, 7, 0000001888, 0000000000, 00000, 00000, 00000, 00000, 00000, 2);

    13. 

  13. 

    14. 

  14. delete from role;

    15. 

  15. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    16. 

  16. values (1, 1, 101, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    17. 

  17. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    18. 

  18. values (1, 2, 201, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    19. 

  19. 

    20. 

  20. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    21. 

  21. values (2, 1, 202, 20, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    22. 

  22. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    23. 

  23. values (2, 2, 303, 21, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    24. 

  24. 

    25. 

  25. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    26. 

  26. values (3, 1, 301, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    27. 

  27. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    28. 

  28. values (3, 2, 203, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    29. 

  29. 

    30. 

  30. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    31. 

  31. values (4, 1, 201, 20, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    32. 

  32. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    33. 

  33. values (4, 2, 103, 21, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    34. 

  34. 

    35. 

  35. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    36. 

  36. values (5, 1, 102, 10, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    37. 

  37. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    38. 

  38. values (5, 2, 201, 11, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    39. 

  39. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    40. 

  40. values (5, 3, 301, 12, 0, 100, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    41. 

  41. insert into role (pid, rid, hid, lvl, exp, hp, mp, eslot1, eslot2, eslot3, eslot4, eslot5, eslot6, eslot7, datax, datay, dataz)

    42. 

  42. values (5, 4, 302, 13, 0, 101, 111, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

    43. 

  43. 

    44. 

  44. delete from progress;

    45. 

  45. insert into progress (pid, cid, did, sid, data) values

    46. 

  46. (1, 2, 1, 1, 2),

    47. 

  47. (1, 2, 1, 2, 2),

    48. 

  48. (1, 2, 2, 1, 1),

    49. 

  49. (1, 2, 2, 2, 1),

    50. 

  50. (1, 2, 3, 1, 2),

    51. 

  51. (1, 2, 3, 2, 2);

    52. 

  52. insert into progress (pid, cid, did, sid, data) values

    53. 

  53. (1, 3, 1, 1, 2),

    54. 

  54. (1, 3, 1, 2, 2),

    55. 

  55. (1, 3, 2, 1, 1),

    56. 

  56. (1, 3, 2, 2, 1),

    57. 

  57. (1, 3, 3, 1, 2),

    58. 

  58. (1, 3, 3, 2, 2);

    59. 

  59. insert into progress (pid, cid, did, sid, data) values

    60. 

  60. (1, 6, 1, 1, 2),

    61. 

  61. (1, 6, 1, 2, 2),

    62. 

  62. (1, 6, 2, 1, 1),

    63. 

  63. (1, 6, 2, 2, 1),

    64. 

  64. (1, 6, 3, 1, 2),

    65. 

  65. (1, 6, 3, 2, 2);

    66. 

  66. 

    67. 

  67. insert into progress (pid, cid, did, sid, data) values

    68. 

  68. (2, 2, 1, 1, 2),

    69. 

  69. (2, 2, 1, 2, 2),

    70. 

  70. (2, 2, 2, 1, 1),

    71. 

  71. (2, 2, 2, 2, 1),

    72. 

  72. (2, 2, 3, 1, 2),

    73. 

  73. (2, 2, 3, 2, 2);

    74. 

  74. insert into progress (pid, cid, did, sid, data) values 

    75. 

  75. (2, 3, 1, 1, 2),

    76. 

  76. (2, 3, 1, 2, 2),

    77. 

  77. (2, 3, 2, 1, 1),

    78. 

  78. (2, 3, 2, 2, 1),

    79. 

  79. (2, 3, 3, 1, 2),

    80. 

  80. (2, 3, 3, 2, 2);

    81. 

  81. insert into progress (pid, cid, did, sid, data)values 

    82. 

  82. (2, 6, 1, 1, 2),

    83. 

  83. (2, 6, 1, 2, 2),

    84. 

  84. (2, 6, 2, 1, 1),

    85. 

  85. (2, 6, 2, 2, 1),

    86. 

  86. (2, 6, 3, 1, 2),

    87. 

  87. (2, 6, 3, 2, 2);

    88. 

  88. 

    89. 

  89. insert into progress (pid, cid, did, sid, data) values 

    90. 

  90. (3, 2, 1, 1, 2),

    91. 

  91. (3, 2, 1, 2, 2),

    92. 

  92. (3, 2, 2, 1, 1),

    93. 

  93. (3, 2, 2, 2, 1),

    94. 

  94. (3, 2, 3, 1, 2),

    95. 

  95. (3, 2, 3, 2, 2);

    96. 

  96. insert into progress (pid, cid, did, sid, data) values 

    97. 

  97. (3, 3, 1, 1, 2),

    98. 

  98. (3, 3, 1, 2, 2),

    99. 

  99. (3, 3, 2, 1, 1),

    100. 

  100. (3, 3, 2, 2, 1),

    101. 

  101. (3, 3, 3, 1, 2),

    102. 

  102. (3, 3, 3, 2, 2);

    103. 

  103. insert into progress (pid, cid, did, sid, data) values 

    104. 

  104. (3, 6, 1, 1, 2),

    105. 

  105. (3, 6, 1, 2, 2),

    106. 

  106. (3, 6, 2, 1, 1),

    107. 

  107. (3, 6, 2, 2, 1),

    108. 

  108. (3, 6, 3, 1, 2),

    109. 

  109. (3, 6, 3, 2, 2);

    110. 

  110. 

    111. 

  111. insert into progress (pid, cid, did, sid, data) values 

    112. 

  112. (4, 2, 1, 1, 2),

    113. 

  113. (4, 2, 1, 2, 2),

    114. 

  114. (4, 2, 2, 1, 1),

    115. 

  115. (4, 2, 2, 2, 1),

    116. 

  116. (4, 2, 3, 1, 2),

    117. 

  117. (4, 2, 3, 2, 2);

    118. 

  118. insert into progress (pid, cid, did, sid, data) values 

    119. 

  119. (4, 3, 1, 1, 2),

    120. 

  120. (4, 3, 1, 2, 2),

    121. 

  121. (4, 3, 2, 1, 1),

    122. 

  122. (4, 3, 2, 2, 1),

    123. 

  123. (4, 3, 3, 1, 2),

    124. 

  124. (4, 3, 3, 2, 2);

    125. 

  125. insert into progress (pid, cid, did, sid, data) values 

    126. 

  126. (4, 6, 1, 1, 2),

    127. 

  127. (4, 6, 1, 2, 2),

    128. 

  128. (4, 6, 2, 1, 1),

    129. 

  129. (4, 6, 2, 2, 1),

    130. 

  130. (4, 6, 3, 1, 2),

    131. 

  131. (4, 6, 3, 2, 2);

    132. 

  132. 

    133. 

  133. insert into progress (pid, cid, did, sid, data) values 

    134. 

  134. (5, 2, 1, 1, 2),

    135. 

  135. (5, 2, 1, 2, 2),

    136. 

  136. (5, 2, 2, 1, 1),

    137. 

  137. (5, 2, 2, 2, 1),

    138. 

  138. (5, 2, 3, 1, 2),

    139. 

  139. (5, 2, 3, 2, 2);

    140. 

  140. insert into progress (pid, cid, did, sid, data) values 

    141. 

  141. (5, 3, 1, 1, 2),

    142. 

  142. (5, 3, 1, 2, 2),

    143. 

  143. (5, 3, 2, 1, 1),

    144. 

  144. (5, 3, 2, 2, 1),

    145. 

  145. (5, 3, 3, 1, 2),

    146. 

  146. (5, 3, 3, 2, 2);

    147. 

  147. insert into progress (pid, cid, did, sid, data) values 

    148. 

  148. (5, 6, 1, 1, 2),

    149. 

  149. (5, 6, 1, 2, 2),

    150. 

  150. (5, 6, 2, 1, 1),

    151. 

  151. (5, 6, 2, 2, 1),

    152. 

  152. (5, 6, 3, 1, 2),

    153. 

  153. (5, 6, 3, 2, 2);

    154. 

  154. 

    155. 

  155. delete from form;

    156. 

  156. insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values

    157. 

  157. (1, 1, 3, 1, 2, 0, 0, 0),

    158. 

  158. (1, 2, 5, 0, 1, 2, 0, 0),

    159. 

  159. (1, 3, 4, 2, 1, 0, 0, 0);

    160. 

  160. 

    161. 

  161. insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values

    162. 

  162. (2, 1, 3, 1, 2, 0, 0, 0),

    163. 

  163. (2, 2, 5, 0, 1, 2, 0, 0),

    164. 

  164. (2, 3, 4, 2, 1, 0, 0, 0);

    165. 

  165. 

    166. 

  166. insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values

    167. 

  167. (3, 1, 3, 1, 2, 0, 0, 0),

    168. 

  168. (3, 2, 5, 0, 1, 2, 0, 0),

    169. 

  169. (3, 3, 4, 2, 1, 0, 0, 0);

    170. 

  170. 

    171. 

  171. insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values

    172. 

  172. (4, 1, 3, 1, 2, 0, 0, 0),

    173. 

  173. (4, 2, 5, 0, 1, 2, 0, 0),

    174. 

  174. (4, 3, 4, 2, 1, 0, 0, 0);

    175. 

  175. 

    176. 

  176. insert into form (pid, type, lvl, fslot1, fslot2, fslot3, fslot4, fslot5) values

    177. 

  177. (5, 1, 3, 1, 2, 0, 0, 0),

    178. 

  178. (5, 2, 5, 0, 1, 2, 0, 0),

    179. 

  179. (5, 3, 4, 2, 1, 0, 0, 0);
    180.