Angepinnt FragenThread [Offi V14]

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

    • [FONT="Arial Black"][COLOR="White"][SIZE="3"]

      Tenshi;98570 schrieb:

      Hay liebe Corler, ich hab da mal eine wiiiiiichtige Frage.
      Und zwar würd ich gern mal wissen wo definiert wird was man beim Gw bekommt also die Red Chips^^ Aber ich befürchte schon das das iwie nit geändert werden kann oder?xD


      Hab grad keine Files , aber ich denke da wo
      auch der GW definiert wird .[/SIZE][/COLOR][/FONT]

    • Zitat von Minimal
      Sorry Leute das ich wieder mit einer Frage komme aber wie kann man den Fehler beheben ?



      So wie ich den Fehler jetz entziffern kann fehlt in der character.inc in der 592. Zeile
      MMI_BEAUTYSHOP_SKIN

      SetImage

      (

      IDS_CHARACTER_IN

      Aber ich wiss nicht wo genau ich das einfügen muss in der Character.inc also bei welchem Char der da aufgelistet ist weil ich möchte jetz nicht 592 Zeilen zählen xD
      Das würde mir mit meinem Wordpad echt zu lange dauern


      Schätze dass es an defineNeuz.h liegt



      <_< aha un was muss ich an der defineNeuz.h ändern denn ich habe auch die DefineNeuz.h von dem TuneUpFly Clienten in die Files getan ?

    • [FONT="Comic Sans MS"][COLOR="Wheat"]Minimal Take this :

      Quellcode

      1. #ifndef __DEFINE_NEUZ
      2. #define __DEFINE_NEUZ
      4. #define AII_NONE 0
      5. #define AII_MOVER 1
      6. #define AII_MONSTER 2
      7. #define AII_HUMAN 3
      8. #define AII_CLOCKWORKS 4
      9. #define AII_PET 5
      10. #define AII_BIGMUSCLE 6
      11. #define AII_KRRR 7
      12. #define AII_BEAR 8
      13. #define AII_EGG 9
      14. #define AII_METEONYKER 10
      16. #define AII_VER2_TYPE0 100
      18. // group ±×·ì ¼³Á¤
      19. #define GRP_ALL 0
      20. #define GRP_SOLO 1
      21. #define GRP_PARTY 2
      22. #define GRP_GUILD 3
      24. #define PARTS_HEAD 0 // Àåºñ¿¡¼* Á¦¿Ü
      25. #define PARTS_HAIR 1 // Àåºñ¿¡¼* Á¦¿Ü
      26. #define PARTS_UPPER_BODY 2
      27. #define PARTS_LOWER_BODY 3
      28. #define PARTS_HAND 4
      29. #define PARTS_FOOT 5
      30. #define PARTS_CAP 6
      31. #define PARTS_ROBE 7
      32. #define PARTS_CLOAK 8
      33. #define PARTS_LWEAPON 9
      34. #define PARTS_RWEAPON 10
      35. #define PARTS_SHIELD 11
      36. #define PARTS_MASK 12
      37. #define PARTS_RIDE 13 // Àåºñ¿¡¼* Á¦¿Ü - ÀÌ°Ç 16¹ø ÀÌÈÄ·Î °¡¾ßÇϴ°ǵ¥ ÄÁ¹öÆ®¸¦ ÇؾßÇϱⶫ½Ã ÀÌ´ë·Î ÇØ°áÇß´Ù.
      38. // ¿©±â±îÁö µ¿½Ã Ãâ·Â ÆÄÃ÷
      39. // 16ÀÌ»óÀ¸·Î ¼öÄ¡¸¦ ´ÃÀÌ·Á¸é xuzhu¿¡°Ô ²À ¾ê±âÇÒ°Í. ¾È±×·¯¸é ¿¡·¯³².
      40. #define PARTS_CAP2 14 // Àåºñ¿¡¼* Á¦¿Ü
      41. #define PARTS_UPPER2 15 // Àåºñ¿¡¼* Á¦¿Ü
      43. // ½ÇÁ¦ È*¸é»ó¿¡¼* ·»´õ¸µµÇÁö ¾Ê´Â ÆÄÃ÷´Â 16¹ø ÀÌ»óÀ» ¾´´Ù. ±Í°ÉÀÌ,¹ÝÁö °°Àº°Íµé.
      44. #define PARTS_LOWER2 16
      45. #define PARTS_HAND2 17
      46. #define PARTS_FOOT2 18
      47. // ¿©±â±îÁö ÀåÂøÀº ÇÏÁö¸¸ ÀÌ°ÍÀ» ÀåÂøÇϹǷμ* ´Ù¸¥ ÆÄÃ÷°¡ ´«¿¡ ¾Èº¸ÀÌ°Ô ÇÑ´Ù.(ÀͽºÅ©·ç½Ãºê¶ûÀº ´Ù¸£´Ù.)
      48. #define PARTS_NECKLACE1 19 // ¸ñ°ÉÀÌ
      49. #define PARTS_RING1 20 // ¹ÝÁö
      50. #define PARTS_RING2 21
      51. #define PARTS_EARRING1 22 // ±Í°ÉÀÌ
      52. #define PARTS_EARRING2 23
      53. #define PARTS_PROPERTY 24 //¸ñ°ÉÀÌ, ¹ÝÁö, ±Í°ÉÀ̸¦ Á¦¿ÜÇÑ ¼Òµµ±¸µéÀ» Âø¿ëÇÒ °ø°£
      54. #define PARTS_BULLET 25 //°¢Á¾ÃÑ¾Ë ½½·Ô
      57. #define PARTS_HAT 26 // ÆмǾÆÅÛ ¸ðÀÚ
      58. #define PARTS_CLOTH 27 // ÆÐ¼Ç ÀÇ»ó
      59. #define PARTS_GLOVE 28 // ÆÐ¼Ç Àå°©
      60. #define PARTS_BOOTS 29 // ÆÐ¼Ç ºÎÃ÷
      61. #define PARTS_CLOAK2 30 // ÆÐ¼Ç ¸ÁÅä
      62. #define MAX_HUMAN_PARTS 31
      67. // Structure Type
      68. #define SRT_NONE 0
      69. #define SRT_LODESTAR 1
      70. #define SRT_LODELOGHT 2
      71. #define SRT_STATION 3
      72. #define SRT_WEAPON 4
      73. #define SRT_SHIELD 5
      74. #define SRT_FOOD 6
      75. #define SRT_MAGIC 7
      76. #define SRT_GENERAL 8
      77. #define SRT_PUBLICOFFICE 9
      78. #define SRT_QUESTOFFICE 10
      79. #define SRT_DUNGEON 11
      80. #define SRT_BUCKLER 12
      81. #define SRT_WARPZONE 13
      82. #define MAX_STRUCTURE 20
      85. // Äù½ºÆ® ½ºÅ×ÀÌÆ®
      86. #define QS_BEGIN 0
      89. // ÁÖÀÇ!! ÀÌ ºÎºÐ¿¡ Ãß°¡ÇÒ ¶§´Â ÇØ´ç ÅؽºÆ®µµ ÀÔ·ÂÇؾßÇÔ.
      90. // ÅؽºÆ®´Â defineText.h¿Í texClient.txt¸¦ ¼öÁ¤ÇؾßÇÔ.
      91. // defineText.hÀÇ ¼ø¼*¿Í MMIÀÇ ¼ø¼*°¡ ÀÏÄ¡ÇؾßÇÔ.
      92. #define MMI_DIALOG 0 // "´ëÈ*" ),
      93. #define MMI_QUEST 1 // Äù½ºÆ®
      94. #define MMI_TRADE 2 // "°Å·¡" ),
      95. #define MMI_FIGHT 3 // "´ëÀü" ),
      96. #define MMI_MESSAGE 4 // "¸Þ½ÃÁö" ),
      97. #define MMI_ADD_MESSENGER 5 // "¸Þ½ÅÀú Ãß°¡" ),
      98. #define MMI_INVITE_PARTY 6 // "ÆÄƼ Âü¿©" )
      99. #define MMI_INVITE_COMPANY 7 // "ÆÄƼ Âü¿©" )
      100. #define MMI_MARKING 8 // "Àå¼Ò ÁöÁ¤" )
      101. #define MMI_BANKING 9 // "ÀºÇà
      102. #define MMI_DUEL 10 // µà¾ó½Åû
      103. #define MMI_DUEL_PARTY 11 // ÆÄƼ µà¾ó.
      104. #define MMI_TRACE 12 // °³Àΰŷ¡
      105. #define MMI_BEAUTYSHOP 13 // ºäƼ¼¥
      106. #define MMI_REPAIR 14 // ¼ö¸®Ã¢
      107. #define MMI_GUILDBANKING 15 // ±æµåâ°í
      108. #define MMI_RANK_GUILD 16 // ±æµå ·©Å·
      109. #define MMI_RANK_WAR 17 // ±æµåÀü½ÂÆÐ ·©Å·
      110. #define MMI_RANK_INFO 18 // ±æµå±âŸ ·©Å·
      111. #define MMI_UPGRADE 19 // Àç·Ãâ
      112. #define MMI_CHANGEELEM 20 // ¼Ó¼º º¯°æ
      113. #define MMI_INPUT_REWARD 21 // Çö»ó±Ý °É±â
      114. #define MMI_SHOW_REWARD 22 // Çö»ó±Ý º¸±â
      115. #define MMI_PIERCING 23
      116. #define MMI_QUERYEQUIP 24
      117. #define MMI_POST 25
      118. #define MMI_GUILDWAR_APP 26
      119. #define MMI_GUILDWAR_STATE 27
      120. #define MMI_GUILDWAR_CANCEL 28
      121. #define MMI_GUILDWAR_JOIN 29
      122. #define MMI_GUILDCOMBAT_RANKING 30
      123. #define MMI_CHEER 31
      124. #define MMI_PIERCING_REMOVE 32
      125. #define MMI_GUILDCOMBAT_SELECTION 33
      126. #define MMI_GUILDCOMBAT_JACKPOT 34
      127. #define MMI_GUILDCOMBAT_JACKPOT2 35
      128. #define MMI_GUILDCOMBAT_BESTPLAYER 36
      130. #define MMI_GUILDCOMBAT_INFO_BOARD1 37
      131. #define MMI_GUILDCOMBAT_INFO_BOARD2 38
      132. #define MMI_GUILDCOMBAT_INFO_BOARD3 39
      133. #define MMI_GUILDCOMBAT_INFO_TEX 40
      134. #define MMI_GUILDCOMBAT_PENYA_RETURN 41
      135. #define MMI_BEAUTYSHOP_SKIN 42 // ¼ºÇü¼ö¼ú
      136. #define MMI_SUMMON_ANGEL 43 // ¿£Á©¼Òȯ
      137. #define MMI_KAWIBAWIBO 44 //°¡À§¹ÙÀ§º¸ °ÔÀÓ
      138. #define MMI_FINDWORD 45 //´Ü¾î¸ÂÃ߱⠰ÔÀÓ
      139. #define MMI_FIVESYSTEM 46 //¿À°ö(ÁÖ»çÀ§) °ÔÀÓ
      140. #define MMI_REASSEMBLE 47 //ÆÛÁñ °ÔÀÓ
      142. #define MMI_PET_FEED 48 //Æê ¸ÔÀÌ ÁÖ±â
      143. #define MMI_PET_STATUS 49 //Æê »óÅÂ
      144. #define MMI_PET_RELEASE 50 //Æê ÇØÁ¦
      146. #define MMI_SMELT_MIXJEWEL 51 //Á¦·Ã : ¿À¸®Ä®Äñ, ¹®½ºÅæ ÇÕ¼º
      147. #define MMI_SMELT_JEWEL 52 //Á¦·Ã : ¾óÅÍ¸Ú ¾ÆÀÌÅÛ º¸¼® Á¦·Ã
      148. #define MMI_SMELT_EXTRACTION 53 //Á¦·Ã : º¸¼®ÃßÃâ
      149. #define MMI_SMELT_CHANGEGWEAPON 54 //Á¦·Ã : ¹«±â º¯°æ (ÀÏ¹Ý -> À¯´ÏÅ©)
      150. #define MMI_SMELT_CHANGEUWEAPON 55 //Á¦·Ã : ¹«±â º¯°æ (À¯´ÏÅ© -> ¾óÅ͸Ú)
      152. #define MMI_LEGEND_SKILLUP 56 //¿µ¿õ ½ºÅ³¾÷
      154. #define MMI_EVENT_MAY 57 //5¿ù À̺¥Æ® - ÇູÇÑ °¡Á¤ÀÇ ´Þ ¸¸µé±â ´ë ÀÛÀü
      155. #define MMI_PET_FOODMILL 58
      156. #define MMI_ATTRIBUTE 59
      158. #define MMI_GUILDCOMBAT_1TO1_OFFER 60 // 1:1±æµå´ëÀü ½ÅûÇϱâ
      159. #define MMI_GUILDCOMBAT_1TO1_CANCEL 61 // 1:1±æµå´ëÀü Ãë¼ÒÇϱâ
      160. #define MMI_GUILDCOMBAT_1TO1_OFFERSTATE 62 // 1:1±æµå´ëÀü ½ÅûÇöȲ
      161. #define MMI_GUILDCOMBAT_1TO1_SELECTION 63 // 1:1±æµå´ëÀü Âü°¡ÀÚ ±¸¼º
      162. #define MMI_GUILDCOMBAT_1TO1_ENTRANCE 64 // 1:1±æµå´ëÀü ÀÔÀå
      163. #define MMI_GUILDCOMBAT_1TO1_GUIDE_TEX 65 // 1:1±æµå´ëÀü ¼ö¼ö·á ¾È³»
      164. #define MMI_GUILDCOMBAT_1TO1_GUIDE_PRIZE 66 // 1:1±æµå´ëÀü »ó±Ý&»óÇ° ¾È³»
      165. #define MMI_GUILDCOMBAT_1TO1_GUIDE_ENTRY 67 // 1:1±æµå´ëÀü Âü°¡ ¾È³»
      166. #define MMI_GUILDCOMBAT_1TO1_GUIDE_RULE 68 // 1:1±æµå´ëÀü ±ÔÄ¢ ¾È³»
      167. #define MMI_GUILDCOMBAT_1TO1_GUIDE_WIN 69 // 1:1±æµå´ëÀü ½Â¸®Á¶°Ç ¾È³»
      168. #define MMI_GUILDCOMBAT_1TO1_REPAYMENT 70 // 1:1±æµå´ëÀü ½Åû±Ý ¹Ýȯ
      170. #define MMI_LVREQDOWN_CANCEL 71 // Âø¿ë·¹º§ Ç϶ô ÇØÁö ¸Þ´º
      171. #define MMI_SMELT_REMOVE_PIERCING 72 // ½´Æ®ÀÇ ÇǾî½Ì ¿É¼Ç Á¦°Å
      172. #define MMI_ITEM_AWAKENING 73 // ¾ÆÀÌÅÛ °¢¼º ¸Þ´º
      173. #define MMI_NPC_BUFF 74 // NPCÇÑÅ× Buff¹Þ±â
      174. #define MMI_COLLECT01 75 // ÀÏ¹Ý Á¶°¢ ±³È¯
      175. #define MMI_COLLECT02 76 // Ä«µå Á¶°¢ ±³È¯
      176. #define MMI_PET_RES 77 // ÆêÀ» ºÎÈ°ÀÇ Á¶°¢À¸·Î ±³È¯
      177. #define MMI_PET_RES01 78 // ºÎÈ°ÀÇ Á¶°¢À» µÎ·ç¸¶¸®·Î ±³È¯
      179. #define MMI_BLESSING_CANCEL 79 // ¿©½ÅÀÇ Ãູ Ãë¼Ò
      181. #define MMI_ARENA_ENTER 80
      182. #define MMI_ARENA_EXIT 81
      184. #define MMI_EVENT_HAPPY_TWN 82
      185. #define MMI_EVENT_HAPPY_USA 83
      187. #define MMI_SECRET_OFFER 84 // ºñ¹ÐÀÇ ¹æ ½Åû
      188. #define MMI_SECRET_OFFERSTATE 85 // ºñ¹ÐÀÇ ¹æ ½ÅûÇöȲ
      189. #define MMI_SECRET_SELECTION 86 // ºñ¹ÐÀÇ ¹æ Âü°¡ÀÚ ±¸¼º
      190. #define MMI_SECRET_ENTRANCE 87 // ºñ¹ÐÀÇ ¹æ ÀÔÀå
      191. #define MMI_SECRET_TAXRATES_CHANGE 88 // ¼¼À² º¯°æ â
      192. #define MMI_SECRET_TAXRATES_CHECK 89 // ¼¼À² È®ÀΠâ
      193. #define MMI_SECRET_BOARD 90 // ºñ¹ÐÀÇ ¹æ ¾È³»
      195. #define MMI_LORD_STATE 91 // ±ºÁÖ Èĺ¸ »óÅÂâ
      196. #define MMI_LORD_TENDER 92 // ±ºÁÖ ÀÔÂû â
      197. #define MMI_LORD_VOTE 93 // ±ºÁÖ ÅõÇ¥ â
      198. #define MMI_LORD_EVENT 94 // ±ºÁÖ À̺¥Æ® â
      200. #define MMI_SMELT_REMOVE_JEWEL 95 // ¾óÅÍ¸Ú ¿þÆù º¸¼® Á¦°Å â
      201. #define MMI_PET_EGG01 96 // ¾Ë º¯È¯ â
      202. #define MMI_HEAVEN_TOWER 97 // ½É¿¬ÀÇ Å¾
      203. #define MMI_EXCHANGE_WEAPONCARD 98 // ¹«±â Ä«µå ±³È¯
      204. #define MMI_EXCHANGE_ARMORCARD 99 // ¹æ¾î±¸ Ä«µå ±³È¯
      207. #define MMI_SECRET_ENTRANCE_1 100 // Àü¿ë »ç³ÉÅÍ ÀÔÀå
      209. #define MMI_LORD_INFO 101 // ±ºÁÖ Á¤º¸Ã¢
      210. #define MMI_LORD_RPINFO 102 // ±ºÁÖ ¹Ýȯ±Ý Á¤º¸Ã¢
      212. #define MMI_SECRET_CANCEL 103 // ºñ¹ÐÀÇ ¹æ Ãë¼Ò
      214. #define MMI_PET_AWAK_CANCEL 104 // Æê°¢¼º Ãë¼Ò
      216. #define MMI_FASHION_PHP 105 // ÆÐ¼Ç ÄíÆù À̺¥Æ®
      218. #define MMI_EVENT_CARD_KOR 106 // ±¹³» Ä«µå ±³È¯ À̺¥Æ®
      220. #define MMI_LORD_RAINBOWAPPLICATION 107 // ·¹Àκ¸¿ì ·¹À̽º Âü°¡ ½Åû
      221. #define MMI_LORD_RAINBOWWAIT 108 // ·¹Àκ¸¿ì ·¹À̽º ¶õ?
      222. #define MMI_LORD_RAINBOWRULE 109 // ·¹Àκ¸¿ì ·¹À̽ºÀÇ ±ÔÄ¢
      223. #define MMI_LORD_RAINBOWTOPTEN 110 // ·¹Àκ¸¿ì ·¹À̽º Áö³* ¼øÀ§
      224. #define MMI_LORD_RAINBOWWIN 111 // ·¹Àκ¸¿ì ·¹À̽º »ó±Ý ¼Ò°³
      225. #define MMI_LORD_RAINBOWEND 112 // ·¹Àκ¸¿ì ·¹À̽º Á¾·á È®ÀÎ
      226. #define MMI_LORD_RAINBOW_KAWIBAWIBO 113 // ·¹Àκ¸¿ì ·¹À̽º - °¡À§,¹ÙÀ§,º¸ °ÔÀÓ
      227. #define MMI_LORD_RAINBOW_DICE 114 // ·¹Àκ¸¿ì ·¹À̽º - ÁÖ»çÀ§ ±¼·Á! ±¼·Á!
      228. #define MMI_LORD_RAINBOW_ARITHMETIC 115 // ·¹Àκ¸¿ì ·¹À̽º - »çÄ¢¿¬»ê
      229. #define MMI_LORD_RAINBOW_STOPWATCH 116 // ·¹Àκ¸¿ì ·¹À̽º - ½ºÅé¿öÄ¡ ¼ø¹ß·Â °ÔÀÓ
      230. #define MMI_LORD_RAINBOW_TYPING 117 // ·¹Àκ¸¿ì ·¹À̽º - Ȳ´ç ŸÀÚ Ä¡±â
      231. #define MMI_LORD_RAINBOW_CARD 118 // ·¹Àκ¸¿ì ·¹À̽º - ±â¾ïÇØ! Ä«µå ¸ÂÃß±â
      232. #define MMI_LORD_RAINBOW_LADDER 119 // ·¹Àκ¸¿ì ·¹À̽º - ¾Ë ¼ö ¾ø´Â »ç´Ù¸® Ÿ±â
      234. #define MMI_RENAME_CANCEL 120 // Æê ÀÛ¸í Ãë¼Ò
      236. #define MMI_EVENT_TRADE_KOR 121 //°¡À§ ¹ÙÀ§ º¸ ÄíÆù ±³È¯
      238. #define MMI_VISIT_MYROOM 122 // ¸¶ÀÌ·ë °¡±â
      239. #define MMI_VISIT_FRIEND 123 // Ä£±¸¹æ °¡±â
      240. #define MMI_RETURNTO_WORLD 124 // ¸¶ÀÌ·ë¿¡¼* ¿ùµå·Î ±Íȯ
      242. #define MMI_EVENT_RESTATE01 125 // ¸®½ºÅ×Æ® ÄíÆù ±³È¯
      244. #define MMI_ITEM_TRANSY 126 // ¾ÆÀÌÅÛ Æ®·»Áö
      246. #define MMI_EVENT_FIRSTTERM01 127 // »õÇбâ À̺¥Æ®
      248. #define MMI_EVENT_ALICE01 128 // ±¹³» È°¼ºÈ* À̺¥Æ®
      250. #define MMI_EVENT_OASIS01 129 // ´Þ·Á¶ó ¿îµ¿È¸
      251. #define MMI_EVENT_FLOWER01 130 // »ç¶ûÀÇ Ä«³×À̼Ç
      253. #define MMI_EVENT_ALICE02 131 // ÀϺ», ´ë¸¸, È«Äá º½À̺¥Æ®
      255. #define MMI_EVENT_TRADE_USA 132 // ¹Ì±¹ °¡À§¹ÙÀ§º¸ ÄíÆù ±³È¯
      257. #define MMI_EVENT_TRADE_ASIA 133 // È«Äá, ´ë¸¸ °¡À§¹ÙÀ§º¸ ÄíÆù ±³È¯
      259. #define MMI_SMELT_SAFETY_GENERAL 134 // ¾ÈÀüÁ¦·Ã(ÀϹÝ)
      260. #define MMI_SMELT_SAFETY_ACCESSORY 135 // ¾ÈÀüÁ¦·Ã(¾×¼¼¼*¸®)
      261. #define MMI_SMELT_SAFETY_PIERCING 136 // ¾ÈÀüÁ¦·Ã(ÇǾî½Ì)
      263. #define MMI_QUIZ_ENTRANCE 137 // ÄûÁîÀ̺¥Æ® ÀÔÀå
      264. #define MMI_QUIZ_TELE_QUIZZONE 138 // ´ë±âÁ¸¿¡¼* ÄûÁîÁ¸À¸·Î À̵¿
      265. #define MMI_QUIZ_EXIT 139 // ´ë±âÁ¸¿¡¼* ¸¶À»·Î À̵¿
      266. #define MMI_CHANGTICKET01 140 // ÀϺ» ·Î»ç»Í À̺¥Æ®
      267. #define MMI_BUFFPET_STATUS 141 // ¹öÇÁÆê »óÅÂ
      268. #define MMI_BUFFPET_RELEASE 142 // ¹öÇÁÆê ÇØÁ¦
      269. #define MMI_GHOUSE_INFO 143 // °¡±¸ Á¤º¸
      270. #define MMI_GHOUSE_REINSTALL 144 // °¡±¸ À缳ġ
      271. #define MMI_GHOUSE_RECALL 145 // °¡±¸ ȸ¼ö
      273. #define MMI_TELEPORTER 146 // ÅÚ·¹Æ÷ÅÍ
      275. #define MMI_GUILDHOUSE_SALE 147 // ±æµåÇϿ콺 ÆǸŠNPC
      276. #define MMI_GUILDHOUSE_CHARGE 148 // ±æµåÇϿ콺 À¯Áöºñ
      277. #define MMI_GUILDHOUSE_ENTER 149 // ±æµåÇϿ콺 ÀÔÀå
      278. #define MMI_GUILDHOUSE_OUT 150 // ±æµåÇϿ콺 ÅðÀå
      279. #define MMI_INVITE_CAMPUS 151 // »çÁ¦ ¸Î±â
      280. #define MMI_REMOVE_CAMPUS 152 // »çÁ¦ ²÷±â
      282. #define MMI_CHANGE_CHRISTMAS01 153
      284. #define MMI_GHOUSE_BED 154
      285. #define MMI_GHOUSE_TABLE 155
      286. #define MMI_GHOUSE_SOFA 156
      287. #define MMI_GHOUSE_DESK 157
      288. #define MMI_GHOUSE_CHAIR 158
      289. #define MMI_GHOUSE_CASE 159
      290. #define MMI_GHOUSE_CLOSET 160
      291. #define MMI_GHOUSE_WARDROBE 161
      292. #define MMI_GHOUSE_BATH 162
      293. #define MMI_GHOUSE_DRAWER 163
      294. #define MMI_GHOUSE_CARPET 164
      295. #define MMI_GHOUSE_WALLPAPER 165
      300. #define MAX_MOVER_MENU 166 // MMI¸¦ Ãß°¡½Ãų ÀÏÀÌ ÀÖ´Ù¸é ÀÌ ¼öÄ¡¸¦ »ó½Â½ÃÄÑ¾ß ÇÑ´Ù.
      303. #define MGI_APPELL_UP 0 // ȣĪ ¾÷
      304. #define MGI_APPELL_DOWN 1
      305. #define MGI_CLASS_UP 2 // µî±Þ ¾÷
      306. #define MGI_CLASS_DOWN 3
      307. #define MGI_GUILD_LEAVE 4 // Å»Åð
      308. #define MGI_NICKNAME 5 // º°Äª ºÎ¿©.
      309. #define MGI_CHG_MASTER 6 // ±æµå¸¶½ºÅÍ º¯°æ
      311. #define MGI_GUILD_MENU 7
      313. // ¸ð¼Ç°ú ¾×¼Ç
      314. #define MOT_BASE_NONE 0
      315. #define MOT_BASE_BATTLE 1
      316. #define MOT_BASE_SIT 2
      317. #define MOT_BASE_PICKUP 3
      318. #define MOT_BASE_HANDSHAKE 4
      319. #define MOT_BASE_AMBIGUOUS 5
      320. #define MOT_BASE_YES 6
      321. #define MOT_BASE_NO 7
      322. #define MOT_BASE_SPRINT 8
      323. #define MOT_BASE_PARADEREST 9
      324. #define MOT_BASE_ATTENTION 10
      325. #define MOT_BASE_SCISSORS 11
      326. #define MOT_BASE_ROCK 12
      327. #define MOT_BASE_PAPER 13
      328. #define MOT_BASE_POINTWAYNORTH 14
      329. #define MOT_BASE_POINTWAYSOUTH 15
      330. #define MOT_BASE_POINTWAYEAST 16
      331. #define MOT_BASE_POINTWAYWEST 17
      332. #define MOT_BASE_KNEEDOWN 18
      333. #define MOT_BASE_PUSHUP 19
      334. #define MOT_BASE_HIPKIDDING 20
      335. #define MOT_BASE_JAB 21
      336. #define MOT_BASE_HEAD 22
      337. #define MOT_BASE_RISESWORD 23
      338. #define MOT_BASE_COLLECT 24
      339. #define MOT_BASE_ESCAPE 25
      340. #define MOT_BASE_CHEER 26
      341. #define MOT_BASE_AUTOATTACK 27
      342. #define MOT_BASE_COUPLE 28
      345. // ÀÏ¹Ý µ¿ÀÛ
      346. #define MTI_STAND 0
      347. #define MTI_IDLE1 1
      348. #define MTI_IDLE2 2
      349. #define MTI_WALK 3
      350. #define MTI_BACK 4
      351. #define MTI_RUN 5
      352. #define MTI_DMG1 6
      353. #define MTI_DMG2 7
      354. #define MTI_DIE1 8
      355. #define MTI_DMGLIVE 9
      356. #define MTI_DMGDIE 10
      357. #define MTI_DMGFLY 11
      358. #define MTI_GROGGY 12
      359. #define MTI_JUMP1 13
      360. #define MTI_JUMP2 14
      361. #define MTI_JUMP3 15
      362. #define MTI_JUMP4 16
      363. #define MTI_IN 17
      364. #define MTI_OUT 18
      365. #define MTI_SWIM 19
      366. #define MTI_SIT 20
      367. #define MTI_SITSTAND 21
      368. #define MTI_GETUP 22
      369. #define MTI_ATK1 23
      370. #define MTI_ATK2 24
      371. #define MTI_ATK3 25
      372. #define MTI_ATK4 26
      373. #define MTI_ATK5 27
      374. #define MTI_ATK6 28
      375. #define MTI_ATK7 29
      376. #define MTI_ATK8 30
      378. #define MTI_FSTAND1_A 31
      379. #define MTI_FIDLE1_A 32 //
      380. #define MTI_FIDLE2_A 33 //
      381. #define MTI_FLTURN1_A 34
      382. #define MTI_FLTURN2_A 35 //
      383. #define MTI_FRTURN1_A 36
      384. #define MTI_FRTURN2_A 37 //
      385. #define MTI_FRUNNING1_A 38 //
      386. #define MTI_FRUNNING2_A 39 ///
      387. #define MTI_FDMG1_A 40
      388. #define MTI_FATK1_A 41
      389. #define MTI_FATK2_A 42
      390. #define MTI_FATK3_A 43
      392. #define MTI_FSTAND1_B 61
      393. #define MTI_FIDLE1_B 62 //
      394. #define MTI_FIDLE2_B 63 //
      395. #define MTI_FLTURN1_B 64
      396. #define MTI_FLTURN2_B 65 //
      397. #define MTI_FRTURN1_B 66
      398. #define MTI_FRTURN2_B 67 //
      399. #define MTI_FRUNNING1_B 68 //
      400. #define MTI_FRUNNING2_B 69 ///
      401. #define MTI_FDMG1_B 70
      402. #define MTI_FATK1_B 71
      403. #define MTI_FATK2_B 72
      404. #define MTI_FATK3_B 73
      406. #define MTI_FSTAND1_C 91
      407. #define MTI_FIDLE1_C 92 //
      408. #define MTI_FIDLE2_C 93 //
      409. #define MTI_FLTURN1_C 94
      410. #define MTI_FLTURN2_C 95 //
      411. #define MTI_FRTURN1_C 96
      412. #define MTI_FRTURN2_C 97 //
      413. #define MTI_FRUNNING1_C 98 //
      414. #define MTI_FRUNNING2_C 99 ///
      415. #define MTI_FDMG1_C 100
      416. #define MTI_FATK1_C 101
      417. #define MTI_FATK2_C 102
      418. #define MTI_FATK3_C 103
      420. #define MTI_PICKUP 121 // ¸ð¼ÇÀ妽ºµµ ÇöÀç ÀúÀåÇϹǷΠ¹øÈ£¸¦ ¹Ù²Ü¼ö°¡ ¾ø´Ù. À§¿¡ ³¢¿ö³ÖÀ»°÷µµ ¾ø´Ù. -xuzhu-
      421. #define MTI_HANDSHAKE 122
      422. #define MTI_AMBIGUOUS 123
      423. #define MTI_YES 124
      424. #define MTI_NO 125
      425. #define MTI_SPRINT 126
      426. #define MTI_PARADEREST 127
      427. #define MTI_ATTENTION 128
      428. #define MTI_SCISSORS 129
      429. #define MTI_ROCK 130
      430. #define MTI_PAPER 131
      431. #define MTI_POINTWAYNORTH 132
      432. #define MTI_POINTWAYSOUTH 133
      433. #define MTI_POINTWAYEAST 134
      434. #define MTI_POINTWAYWEST 135
      435. #define MTI_KNEEDOWN 136
      436. #define MTI_PUSHUP 137
      437. #define MTI_HIPKIDDING 138
      438. #define MTI_JAB 139
      439. #define MTI_HEAD 140
      440. #define MTI_RISESWORD 141
      441. #define MTI_COLLECT 142 // äÁý ¸ð¼Ç
      442. #define MTI_APPEAR 143 // µîÀå ¸ð¼Ç
      443. #define MTI_APPEAR2 144 // µîÀå ¸ð¼Ç2
      444. #define MTI_CHEERSAME 145 //µ¿¼º ÀÀ¿ø ¸ð¼Ç
      445. #define MTI_CHEEROTHER 146 //À̼º ÀÀ¿ø ¸ð¼Ç
      446. #define MTI_FALL 147
      450. #define MTI_LOGOUT 194
      451. #define MTI_ACCLAIM 195
      452. #define MTI_CLAPDOWN 196
      453. #define MTI_CLAPUP 197
      454. #define MTI_LEVELUP 198
      455. #define MTI_STAND2 199 // ij¸¯ÅÍ ¼±ÅÃÈ*¸é¿¡¼* Æ÷´ÏÅ×ÀÏÀ» ij¸¯ÅÍ µÚ·Î ³ª¿À°Ô Çϱâ À§ÇØ º°µµ·Î ÀÔ·Â
      456. #define MTI_FLYWALK 231 // »çÀÌÅ°ÆÛ ¿¤·¹¸àÅÍ À̵¿
      457. #define MTI_FLYBACK 232 // »çÀÌÅ°ÆÛ ¿¤·¹¸àÅÍ À̵¿
      458. #define MTI_FLYRUN 233 // »çÀÌÅ°ÆÛ ¿¤·¹¸àÅÍ À̵¿
      460. // Sworld ÀüÅõ ¸ðµå µ¿ÀÛ
      461. #define MTI_STAND_01 200
      462. #define MTI_IDLE1_01 201
      463. #define MTI_IDLE2_01 202
      464. #define MTI_WALK_01 203
      465. #define MTI_BACK_01 204
      466. #define MTI_RUN_01 205
      467. #define MTI_DMG1_01 206
      468. #define MTI_DMG2_01 207
      469. #define MTI_DIE1_01 208
      470. #define MTI_DMGLIVE_01 209
      471. #define MTI_DMGDIE_01 210
      472. #define MTI_DMGFLY_01 211
      473. #define MTI_GROGGY_01 212
      474. #define MTI_JUMP1_01 213
      475. #define MTI_JUMP2_01 214
      476. #define MTI_JUMP3_01 215
      477. #define MTI_JUMP4_01 216
      478. #define MTI_IN_01 217
      479. #define MTI_OUT_01 218
      480. #define MTI_SWIM_01 219
      481. #define MTI_SIT_01 220
      482. #define MTI_SITSTAND_01 221
      483. #define MTI_GETUP_01 222
      484. #define MTI_ATK1_01 223
      485. #define MTI_ATK2_01 224
      486. #define MTI_ATK3_01 225
      487. #define MTI_ATK4_01 226
      488. #define MTI_ATK5_01 227
      489. #define MTI_ATK6_01 228
      490. #define MTI_ATK7_01 229
      491. #define MTI_ATK8_01 230
      493. // ¿Ïµå ÀüÅõ ¸ðµå µ¿ÀÛ
      494. #define MTI_STAND_02 300
      495. #define MTI_IDLE1_02 301
      496. #define MTI_IDLE2_02 302
      497. #define MTI_WALK_02 303
      498. #define MTI_BACK_02 304
      499. #define MTI_RUN_02 305
      500. #define MTI_DMG1_02 306
      501. #define MTI_DMG2_02 307
      502. #define MTI_DIE1_02 308
      503. #define MTI_DMGLIVE_02 309
      504. #define MTI_DMGDIE_02 310
      505. #define MTI_DMGFLY_02 311
      506. #define MTI_GROGGY_02 312
      507. #define MTI_JUMP1_02 313
      508. #define MTI_JUMP2_02 314
      509. #define MTI_JUMP3_02 315
      510. #define MTI_JUMP4_02 316
      511. #define MTI_IN_02 317
      512. #define MTI_OUT_02 318
      513. #define MTI_SWIM_02 319
      514. #define MTI_SIT_02 320
      515. #define MTI_SITSTAND_02 321
      516. #define MTI_GETUP_02 322
      517. #define MTI_ATK1_02 323
      518. #define MTI_ATK2_02 324
      519. #define MTI_ATK3_02 325
      520. #define MTI_ATK4_02 326
      521. #define MTI_ATK5_02 327
      522. #define MTI_ATK6_02 328
      523. #define MTI_ATK7_02 329
      524. #define MTI_ATK8_02 330
      526. // Ä¡¾îºÀ ÀüÅõ ¸ðµå µ¿ÀÛ
      527. #define MTI_STAND_03 400
      528. #define MTI_IDLE1_03 401
      529. #define MTI_IDLE2_03 402
      530. #define MTI_WALK_03 403
      531. #define MTI_BACK_03 404
      532. #define MTI_RUN_03 405
      533. #define MTI_DMG1_03 406
      534. #define MTI_DMG2_03 407
      535. #define MTI_DIE1_03 408
      536. #define MTI_DMGLIVE_03 409
      537. #define MTI_DMGDIE_03 410
      538. #define MTI_DMGFLY_03 411
      539. #define MTI_GROGGY_03 412
      540. #define MTI_JUMP1_03 413
      541. #define MTI_JUMP2_03 414
      542. #define MTI_JUMP3_03 415
      543. #define MTI_JUMP4_03 416
      544. #define MTI_IN_03 417
      545. #define MTI_OUT_03 418
      546. #define MTI_SWIM_03 419
      547. #define MTI_SIT_03 420
      548. #define MTI_SITSTAND_03 421
      549. #define MTI_GETUP_03 422
      550. #define MTI_ATK1_03 423
      551. #define MTI_ATK2_03 424
      552. #define MTI_ATK3_03 425
      553. #define MTI_ATK4_03 426
      554. #define MTI_ATK5_03 427
      555. #define MTI_ATK6_03 428
      556. #define MTI_ATK7_03 429
      557. #define MTI_ATK8_03 430
      559. // ¿¢½º ÀüÅõ ¸ðµå µ¿ÀÛ
      560. #define MTI_STAND_04 500
      561. #define MTI_IDLE1_04 501
      562. #define MTI_IDLE2_04 502
      563. #define MTI_WALK_04 503
      564. #define MTI_BACK_04 504
      565. #define MTI_RUN_04 505
      566. #define MTI_DMG1_04 506
      567. #define MTI_DMG2_04 507
      568. #define MTI_DIE1_04 508
      569. #define MTI_DMGLIVE_04 509
      570. #define MTI_DMGDIE_04 510
      571. #define MTI_DMGFLY_04 511
      572. #define MTI_GROGGY_04 512
      573. #define MTI_JUMP1_04 513
      574. #define MTI_JUMP2_04 514
      575. #define MTI_JUMP3_04 515
      576. #define MTI_JUMP4_04 516
      577. #define MTI_IN_04 517
      578. #define MTI_OUT_04 518
      579. #define MTI_SWIM_04 519
      580. #define MTI_SIT_04 520
      581. #define MTI_SITSTAND_04 521
      582. #define MTI_GETUP_04 522
      583. #define MTI_ATK1_04 523
      584. #define MTI_ATK2_04 524
      585. #define MTI_ATK3_04 525
      586. #define MTI_ATK4_04 526
      587. #define MTI_ATK5_04 527
      588. #define MTI_ATK6_04 528
      589. #define MTI_ATK7_04 529
      590. #define MTI_ATK8_04 530
      592. // ½ºÅÂÇÁ ÀüÅõ ¸ðµå µ¿ÀÛ
      593. #define MTI_STAND_05 600
      594. #define MTI_IDLE1_05 601
      595. #define MTI_IDLE2_05 602
      596. #define MTI_WALK_05 603
      597. #define MTI_BACK_05 604
      598. #define MTI_RUN_05 605
      599. #define MTI_DMG1_05 606
      600. #define MTI_DMG2_05 607
      601. #define MTI_DIE1_05 608
      602. #define MTI_DMGLIVE_05 609
      603. #define MTI_DMGDIE_05 610
      604. #define MTI_DMGFLY_05 611
      605. #define MTI_GROGGY_05 612
      606. #define MTI_JUMP1_05 613
      607. #define MTI_JUMP2_05 614
      608. #define MTI_JUMP3_05 615
      609. #define MTI_JUMP4_05 616
      610. #define MTI_IN_05 617
      611. #define MTI_OUT_05 618
      612. #define MTI_SWIM_05 619
      613. #define MTI_SIT_05 620
      614. #define MTI_SITSTAND_05 621
      615. #define MTI_GETUP_05 622
      616. #define MTI_ATK1_05 623
      617. #define MTI_ATK2_05 624
      618. #define MTI_ATK3_05 625
      619. #define MTI_ATK4_05 626
      620. #define MTI_ATK5_05 627
      621. #define MTI_ATK6_05 628
      622. #define MTI_ATK7_05 629
      623. #define MTI_ATK8_05 630
      625. // ³ÊŬÇØ¸Ó ÀüÅõ ¸ðµå µ¿ÀÛ
      626. #define MTI_STAND_06 700
      627. #define MTI_IDLE1_06 701
      628. #define MTI_IDLE2_06 702
      629. #define MTI_WALK_06 703
      630. #define MTI_BACK_06 704
      631. #define MTI_RUN_06 705
      632. #define MTI_DMG1_06 706
      633. #define MTI_DMG2_06 707
      634. #define MTI_DIE1_06 708
      635. #define MTI_DMGLIVE_06 709
      636. #define MTI_DMGDIE_06 710
      637. #define MTI_DMGFLY_06 711
      638. #define MTI_GROGGY_06 712
      639. #define MTI_JUMP1_06 713
      640. #define MTI_JUMP2_06 714
      641. #define MTI_JUMP3_06 715
      642. #define MTI_JUMP4_06 716
      643. #define MTI_IN_06 717
      644. #define MTI_OUT_06 718
      645. #define MTI_SWIM_06 719
      646. #define MTI_SIT_06 720
      647. #define MTI_SITSTAND_06 721
      648. #define MTI_GETUP_06 722
      649. #define MTI_ATK1_06 723
      650. #define MTI_ATK2_06 724
      651. #define MTI_ATK3_06 725
      652. #define MTI_ATK4_06 726
      653. #define MTI_ATK5_06 727
      654. #define MTI_ATK6_06 728
      655. #define MTI_ATK7_06 729
      656. #define MTI_ATK8_06 730
      658. // ¾ç¼Õ ¾ç¼Õµµ³¢ ÀüÅõ µ¿ÀÛ
      659. #define MTI_STAND_07 800
      660. #define MTI_IDLE1_07 801
      661. #define MTI_IDLE2_07 802
      662. #define MTI_WALK_07 803
      663. #define MTI_BACK_07 804
      664. #define MTI_RUN_07 805
      665. #define MTI_DMG1_07 806
      666. #define MTI_DMG2_07 807
      667. #define MTI_DIE1_07 808
      668. #define MTI_DMGLIVE_07 809
      669. #define MTI_DMGDIE_07 810
      670. #define MTI_DMGFLY_07 811
      671. #define MTI_GROGGY_07 812
      672. #define MTI_JUMP1_07 813
      673. #define MTI_JUMP2_07 814
      674. #define MTI_JUMP3_07 815
      675. #define MTI_JUMP4_07 816
      676. #define MTI_IN_07 817
      677. #define MTI_OUT_07 818
      678. #define MTI_SWIM_07 819
      679. #define MTI_SIT_07 820
      680. #define MTI_SITSTAND_07 821
      681. #define MTI_GETUP_07 822
      682. #define MTI_ATK1_07 823
      683. #define MTI_ATK2_07 824
      684. #define MTI_ATK3_07 825
      685. #define MTI_ATK4_07 826
      686. #define MTI_ATK5_07 827
      687. #define MTI_ATK6_07 828
      688. #define MTI_ATK7_07 829
      689. #define MTI_ATK8_07 830
      691. // À̵µ·ù ÀüÅõµ¿ÀÛ
      692. #define MTI_STAND_08 900
      693. #define MTI_IDLE1_08 901
      694. #define MTI_IDLE2_08 902
      695. #define MTI_WALK_08 903
      696. #define MTI_BACK_08 904
      697. #define MTI_RUN_08 905
      698. #define MTI_DMG1_08 906
      699. #define MTI_DMG2_08 907
      700. #define MTI_DIE1_08 908
      701. #define MTI_DMGLIVE_08 909
      702. #define MTI_DMGDIE_08 910
      703. #define MTI_DMGFLY_08 911
      704. #define MTI_GROGGY_08 912
      705. #define MTI_JUMP1_08 913
      706. #define MTI_JUMP2_08 914
      707. #define MTI_JUMP3_08 915
      708. #define MTI_JUMP4_08 916
      709. #define MTI_IN_08 917
      710. #define MTI_OUT_08 918
      711. #define MTI_SWIM_08 919
      712. #define MTI_SIT_08 920
      713. #define MTI_SITSTAND_08 921
      714. #define MTI_GETUP_08 922
      715. #define MTI_ATK1_08 923
      716. #define MTI_ATK2_08 924
      717. #define MTI_ATK3_08 925
      718. #define MTI_ATK4_08 926
      719. #define MTI_ATK5_08 927
      720. #define MTI_ATK6_08 928
      721. #define MTI_ATK7_08 929
      722. #define MTI_ATK8_08 930
      724. // ¸µ¸¶½ºÅÍ ½ºÆ½ ÀüÅõµ¿ÀÛ
      725. #define MTI_STAND_09 2000
      726. #define MTI_IDLE1_09 2001
      727. #define MTI_IDLE2_09 2002
      728. #define MTI_WALK_09 2003
      729. #define MTI_BACK_09 2004
      730. #define MTI_RUN_09 2005
      731. #define MTI_DMG1_09 2006
      732. #define MTI_DMG2_09 2007
      733. #define MTI_DIE1_09 2008
      734. #define MTI_DMGLIVE_09 2009
      735. #define MTI_DMGDIE_09 2010
      736. #define MTI_DMGFLY_09 2011
      737. #define MTI_GROGGY_09 2012
      738. #define MTI_JUMP1_09 2013
      739. #define MTI_JUMP2_09 2014
      740. #define MTI_JUMP3_09 2015
      741. #define MTI_JUMP4_09 2016
      742. #define MTI_IN_09 2017
      743. #define MTI_OUT_09 2018
      744. #define MTI_SWIM_09 2019
      745. #define MTI_SIT_09 2020
      746. #define MTI_SITSTAND_09 2021
      747. #define MTI_GETUP_09 2022
      748. #define MTI_ATK1_09 2023
      749. #define MTI_ATK2_09 2024
      750. #define MTI_ATK3_09 2025
      751. #define MTI_ATK5_09 2026
      752. #define MTI_ATK6_09 2027
      753. #define MTI_ATK7_09 2028
      754. #define MTI_ATK8_09 2029
      756. // ºô Æ÷½ºÅÍ ³ÊŬ ÀüÅõµ¿ÀÛ
      757. #define MTI_STAND_10 2100
      758. #define MTI_IDLE1_10 2101
      759. #define MTI_IDLE2_10 2102
      760. #define MTI_WALK_10 2103
      761. #define MTI_BACK_10 2104
      762. #define MTI_RUN_10 2105
      763. #define MTI_DMG1_10 2106
      764. #define MTI_DMG2_10 2107
      765. #define MTI_DIE1_10 2108
      766. #define MTI_DMGLIVE_10 2109
      767. #define MTI_DMGDIE_10 2110
      768. #define MTI_DMGFLY_10 2111
      769. #define MTI_GROGGY_10 2112
      770. #define MTI_JUMP1_10 2113
      771. #define MTI_JUMP2_10 2114
      772. #define MTI_JUMP3_10 2115
      773. #define MTI_JUMP4_10 2116
      774. #define MTI_IN_10 2117
      775. #define MTI_OUT_10 2118
      776. #define MTI_SWIM_10 2119
      777. #define MTI_SIT_10 2120
      778. #define MTI_SITSTAND_10 2121
      779. #define MTI_GETUP_10 2122
      780. #define MTI_ATK1_10 2123
      781. #define MTI_ATK2_10 2124
      782. #define MTI_ATK3_10 2125
      783. #define MTI_ATK4_10 2126
      784. #define MTI_ATK5_10 2127
      785. #define MTI_ATK6_10 2128
      786. #define MTI_ATK7_10 2129
      787. #define MTI_ATK8_10 2130
      789. // »çÀÌÅ°ÆÛ ¿Ïµå ÀüÅõµ¿ÀÛ
      790. #define MTI_STAND_11 2200
      791. #define MTI_IDLE1_11 2201
      792. #define MTI_IDLE2_11 2202
      793. #define MTI_WALK_11 2203
      794. #define MTI_BACK_11 2204
      795. #define MTI_RUN_11 2205
      796. #define MTI_DMG1_11 2206
      797. #define MTI_DMG2_11 2207
      798. #define MTI_DIE1_11 2208
      799. #define MTI_DMGLIVE_11 2209
      800. #define MTI_DMGDIE_11 2210
      801. #define MTI_DMGFLY_11 2211
      802. #define MTI_GROGGY_11 2212
      803. #define MTI_JUMP1_11 2213
      804. #define MTI_JUMP2_11 2214
      805. #define MTI_JUMP3_11 2215
      806. #define MTI_JUMP4_11 2216
      807. #define MTI_IN_11 2217
      808. #define MTI_OUT_11 2218
      809. #define MTI_SWIM_11 2219
      810. #define MTI_SIT_11 2220
      811. #define MTI_SITSTAND_11 2221
      812. #define MTI_GETUP_11 2222
      813. #define MTI_ATK_11 2223
      814. #define MTI_ATK5_11 2224
      815. #define MTI_ATK6_11 2225
      816. #define MTI_ATK7_11 2226
      817. #define MTI_ATK8_11 2227
      819. // ¿¤·¹¸àÅÍ ½ºÅÂÇÁ ÀüÅõµ¿ÀÛ
      820. #define MTI_STAND_12 2300
      821. #define MTI_IDLE1_12 2301
      822. #define MTI_IDLE2_12 2302
      823. #define MTI_WALK_12 2303
      824. #define MTI_BACK_12 2304
      825. #define MTI_RUN_12 2305
      826. #define MTI_DMG1_12 2306
      827. #define MTI_DMG2_12 2307
      828. #define MTI_DIE1_12 2308
      829. #define MTI_DMGLIVE_12 2309
      830. #define MTI_DMGDIE_12 2310
      831. #define MTI_DMGFLY_12 2311
      832. #define MTI_GROGGY_12 2312
      833. #define MTI_JUMP1_12 2313
      834. #define MTI_JUMP2_12 2314
      835. #define MTI_JUMP3_12 2315
      836. #define MTI_JUMP4_12 2316
      837. #define MTI_IN_12 2317
      838. #define MTI_OUT_12 2318
      839. #define MTI_SWIM_12 2319
      840. #define MTI_SIT_12 2320
      841. #define MTI_SITSTAND_12 2321
      842. #define MTI_GETUP_12 2322
      843. #define MTI_ATK_12 2323
      844. #define MTI_ATK5_12 2324
      845. #define MTI_ATK6_12 2325
      846. #define MTI_ATK7_12 2326
      847. #define MTI_ATK8_12 2327
      849. // ¾ÆÅ©·Î¹î È° ÀüÅõµ¿ÀÛ
      850. #define MTI_STAND_13 2328
      851. #define MTI_IDLE1_13 2329
      852. #define MTI_IDLE2_13 2330
      853. #define MTI_WALK_13 2331
      854. #define MTI_BACK_13 2332
      855. #define MTI_RUN_13 2333
      856. #define MTI_DMG1_13 2334
      857. #define MTI_DMG2_13 2335
      858. #define MTI_DIE1_13 2336
      859. #define MTI_DMGLIVE_13 2337
      860. #define MTI_DMGDIE_13 2338
      861. #define MTI_DMGFLY_13 2339
      862. #define MTI_GROGGY_13 2340
      863. #define MTI_JUMP1_13 2341
      864. #define MTI_JUMP2_13 2342
      865. #define MTI_JUMP3_13 2343
      866. #define MTI_JUMP4_13 2344
      867. #define MTI_IN_13 2345
      868. #define MTI_OUT_13 2346
      869. #define MTI_SWIM_13 2347
      870. #define MTI_SIT_13 2348
      871. #define MTI_SITSTAND_13 2349
      872. #define MTI_GETUP_13 2350
      873. #define MTI_ATK_13 2351
      874. #define MTI_ATK5_13 2352
      875. #define MTI_ATK6_13 2353
      876. #define MTI_ATK7_13 2354
      877. #define MTI_ATK8_13 2355
      879. //¾ÆÅ©·Î¹î ¿ä¿ä ÀüÅõµ¿ÀÛ
      880. #define MTI_STAND_14 2356
      881. #define MTI_IDLE1_14 2357
      882. #define MTI_IDLE2_14 2358
      883. #define MTI_WALK_14 2359
      884. #define MTI_BACK_14 2360
      885. #define MTI_RUN_14 2361
      886. #define MTI_DMG1_14 2362
      887. #define MTI_DMG2_14 2363
      888. #define MTI_DIE1_14 2364
      889. #define MTI_DMGLIVE_14 2365
      890. #define MTI_DMGDIE_14 2366
      891. #define MTI_DMGFLY_14 2367
      892. #define MTI_GROGGY_14 2368
      893. #define MTI_JUMP1_14 2369
      894. #define MTI_JUMP2_14 2370
      895. #define MTI_JUMP3_14 2371
      896. #define MTI_JUMP4_14 2372
      897. #define MTI_IN_14 2373
      898. #define MTI_OUT_14 2374
      899. #define MTI_SWIM_14 2375
      900. #define MTI_SIT_14 2376
      901. #define MTI_SITSTAND_14 2377
      902. #define MTI_GETUP_14 2378
      903. #define MTI_ATK1_14 2379
      904. #define MTI_ATK2_14 2380
      905. #define MTI_ATK5_14 2381
      906. #define MTI_ATK6_14 2382
      907. #define MTI_ATK7_14 2383
      908. #define MTI_ATK8_14 2384
      912. // ƯÁ¤ µ¿ÀÛ¿¡ Ãß°¡ÀûÀ¸·Î ´õÇØÁ®¼* ¿Ï¼ºµÈ ¸ð¼Ç À妽º¸¦ ¸¸µç´Ù.
      913. // MTI_FDOWN1 = MTI_FSTAND1 + MTA_FDOWN
      914. #define MTA_FSTAND1 0
      915. #define MTA_FIDLE1 1
      916. #define MTA_FIDLE2 2
      917. #define MTA_FLTURN1 3
      918. #define MTA_FLTURN2 4
      919. #define MTA_FRTURN1 5
      920. #define MTA_FRTURN2 6
      921. #define MTA_FRUNNING1 7
      922. #define MTA_FRUNNING2 8
      923. #define MTA_FDMG1 9
      924. #define MTA_FATK1 10
      925. #define MTA_FATK2 11
      926. #define MTA_FATK3 12
      928. // ¿©±âºÎÅÍ ½ºÅ³ µ¿ÀÛ Ãß°¡
      929. // ¹æ¶ûÀÚ °è¿*
      930. #define MTI_VAG_ONE_CLEANHIT 1000
      931. #define MTI_VAG_ONE_BRANDISH 1001
      932. #define MTI_VAG_ONE_OVERCUTTER 1002
      934. // ¸Ó¼*³Ê¸® °è¿*
      935. #define MTI_MER_ONE_SPLMASH 1003
      936. #define MTI_MER_ONE_KEENWHEEL 1004
      937. #define MTI_MER_ONE_BLINDSIDE 1005
      938. #define MTI_MER_ONE_SPECIAL 1006
      939. #define MTI_MER_ONE_SNAKE 1007
      940. #define MTI_MER_SHIELD_PROTECTION 1008
      941. #define MTI_MER_SHIELD_PANBARRIER 1009
      942. #define MTI_MER_ONE_BLOODYSTRIKE 1010
      945. // ¾î½Ã½ºÆ® °è¿*
      946. #define MTI_ASS_HEAL_CASTING01 1043
      947. #define MTI_ASS_HEAL_CASTING02 1044
      948. #define MTI_ASS_HEAL_CASTING03 1045
      949. #define MTI_ASS_CHEER_CASTING01 1046
      950. #define MTI_ASS_CHEER_CASTING02 1047
      951. #define MTI_ASS_CHEER_CASTING03 1048
      952. #define MTI_ASS_RESURRECTION 1049
      953. #define MTI_ASS_RES_CASTING01 1050
      954. #define MTI_ASS_RES_CASTING02 1051
      955. #define MTI_ASS_RES_CASTING03 1052
      956. #define MTI_ASS_KNU_POWERFIST 1053
      958. // ¸ÅÁö¼Ç °è¿*
      959. #define MTI_MAG_FIRE_CASTING01 1063
      960. #define MTI_MAG_FIRE_CASTING02 1064
      961. #define MTI_MAG_FIRE_CASTING03 1065
      962. #define MTI_MAG_WIND_CASTING01 1066
      963. #define MTI_MAG_WIND_CASTING02 1067
      964. #define MTI_MAG_WIND_CASTING03 1068
      969. #define MTI_ASS_KNU_BURSTCRACK 1103 // Ãß°¡ ¾î½Ã½ºÆ® ³ÊŬ½ºÅ³
      970. #define MTI_ASS_KNU_TAMPINGHOLE 1104 // Ãß°¡ ¾î½Ã½ºÆ® ³ÊŬ½ºÅ³
      973. //³ªÀÌÆ®
      974. #define MTI_KNT_SUP_CASTING01 1105
      975. #define MTI_KNT_TWO_POWERSWING01 1106
      976. #define MTI_KNT_TWOSW_EARTHDIVIDER01 1107
      977. #define MTI_KNT_TWOSW_CHARGE01 1108
      978. #define MTI_KNT_TWOAX_PAINDEALER01 1109
      979. #define MTI_KNT_TWOAX_POWERSTUMP01 1110
      981. //ºí·¹À̵å
      982. #define MTI_BLD_DOUBLE_CROSSSTRIKE01 1111
      983. #define MTI_BLD_DOUBLE_ARMORPENETRATE01 1112
      984. #define MTI_BLD_DOUBLESW_SILENTSTRIKE01 1113
      985. #define MTI_BLD_DOUBLESW_BLADEDANCE01 1114
      986. #define MTI_BLD_DOUBLEAX_SPRINGATTAKE01 1115
      987. #define MTI_BLD_DOUBLEAX_HAWKATTAKE01 1116
      988. #define MTI_BLD_DOUBLE_SONICBLADE01 1117
      989. #define MTI_BLD_SUP_CASTING01 1118
      991. //¸µ¸¶½ºÅÍ
      992. #define MTI_RIN_HEAL_CASTING01 1119
      993. #define MTI_RIN_HEAL_CASTING02 1120
      994. #define MTI_RIN_HEAL_CASTING03 1121
      995. #define MTI_RIN_SUP_CASTING01 1122
      996. #define MTI_RIN_SUP_CASTING02 1123
      997. #define MTI_RIN_SUP_CASTING03 1124
      998. #define MTI_RIN_HEAL_CURE01 1125
      999. #define MTI_RIN_HEAL_CURE02 1126
      1000. #define MTI_RIN_HEAL_CURE03 1127
      1001. #define MTI_RIN_SQU_CASTING01 1128
      1002. #define MTI_RIN_SQU_CASTING02 1129
      1003. #define MTI_RIN_SQU_CASTING03 1130
      1005. //ºôÆ÷½ºÅÍ
      1006. #define MTI_BIL_KNU_BELIALSMESHING01 1131
      1007. #define MTI_BIL_KNU_PIERCINGSERPENT01 1132
      1008. #define MTI_BIL_KNU_BLOODFIST01 1133
      1009. #define MTI_BIL_KNU_SONICHAND01 1134
      1010. #define MTI_BIL_PST_CASTING01 1135
      1011. #define MTI_BIL_PST_CASTING02 1136
      1012. #define MTI_BIL_PST_CASTING03 1137
      1013. #define MTI_BIL_PST_SQUARE01 1138
      1014. #define MTI_BIL_PST_SQUARE02 1139
      1015. #define MTI_BIL_PST_SQUARE03 1140
      1017. //»çÀÌÅ°ÆÛ
      1018. #define MTI_PSY_NLG_CASTING01 1145
      1019. #define MTI_PSY_NLG_CASTING02 1146
      1020. #define MTI_PSY_NLG_CASTING03 1147
      1021. #define MTI_PSY_PSY_PSYCHI01 1148
      1022. #define MTI_PSY_PSY_PSYCHI02 1149
      1023. #define MTI_PSY_PSY_PSYCHI03 1150
      1024. #define MTI_PSY_PSY_SQUARE01 1151
      1025. #define MTI_PSY_PSY_SQUARE02 1152
      1026. #define MTI_PSY_PSY_SQUARE03 1153
      1028. //¿¤¸®¸àÅÍ
      1029. #define MTI_ELE_FIRE_CASTING01 1160
      1030. #define MTI_ELE_FIRE_CASTING02 1161
      1031. #define MTI_ELE_FIRE_CASTING03 1162
      1032. #define MTI_ELE_ELECTRICITY_CASTING01 1163
      1033. #define MTI_ELE_ELECTRICITY_CASTING02 1164
      1034. #define MTI_ELE_ELECTRICITY_CASTING03 1165
      1035. #define MTI_ELE_EARTH_CASTING01 1166
      1036. #define MTI_ELE_EARTH_CASTING02 1167
      1037. #define MTI_ELE_EARTH_CASTING03 1168
      1038. #define MTI_ELE_WATER_CASTING01 1169
      1039. #define MTI_ELE_WATER_CASTING02 1170
      1040. #define MTI_ELE_WATER_CASTING03 1171
      1041. #define MTI_ELE_WIND_CASTING01 1172
      1042. #define MTI_ELE_WIND_CASTING02 1173
      1043. #define MTI_ELE_WIND_CASTING03 1174
      1044. #define MTI_ELE_MULTI_CASTING01 1175
      1045. #define MTI_ELE_MULTI_CASTING02 1176
      1046. #define MTI_ELE_MULTI_CASTING03 1177
      1048. //¾ÆÅ©·Î¹î
      1049. #define MTI_ACR_SUP_CASTING01 1178
      1050. #define MTI_ACR_BOW_JUNKBOW01 1179
      1051. #define MTI_ACR_BOW_AIMEDSHOT01 1180
      1052. #define MTI_ACR_YOYO_SLOWSTEP01 1181
      1053. #define MTI_ACR_BOW_SILENTSHOT01 1182
      1054. #define MTI_ACR_DEF_SUPPORT01 1183
      1055. #define MTI_ACR_BOW_ARROWRAIN01 1184
      1056. #define MTI_ACR_YOYO_CROSSLINE01 1185
      1057. #define MTI_ACR_BOW_AUTOSHOT01 1186
      1058. #define MTI_ACR_YOYO_SNITCH01 1187
      1059. #define MTI_ACR_YOYO_COUNTER01 1188
      1060. #define MTI_ACR_YOYO_DEADLYSWING01 1189
      1061. #define MTI_ACR_YOYO_PULLING01 1190
      1062. #define MTI_ACR_YOYO_COUNTER02 1205
      1064. //Á¦½ºÅÍ
      1065. #define MTI_JST_SUP_CRITICALSWING01 1191
      1066. #define MTI_JST_SUP_ENCHANT 1192
      1067. #define MTI_JST_YOYO_BACKSTAB01 1193
      1068. #define MTI_JST_YOYO_HITOFPENYA01 1194
      1069. #define MTI_JST_YOYO_ESCAPE01 1195
      1070. #define MTI_JST_YOYO_VATALSTAB01 1196
      1072. //·¹ÀÎÀú
      1073. #define MTI_RAG_SUP_FASTATTACK01 1197
      1074. #define MTI_RAG_BOW_ICEARROW01 1198
      1075. #define MTI_RAG_BOW_FLAMEARROW01 1199
      1076. #define MTI_RAG_BOW_PIRCINGARROW01 1200
      1077. #define MTI_RAG_BOW_POISONARROW01 1201
      1078. #define MTI_RAG_BOW_SILENTARROW01 1202
      1079. #define MTI_RAG_SUP_NATURE01 1203
      1080. #define MTI_RAG_BOW_TRIPLESHOT01 1204
      1082. //³¯°³¸ð¼Ç
      1083. #define MTI_FSTAND1_D 1206
      1084. #define MTI_FIDLE1_D 1207
      1085. #define MTI_FIDLE2_D 1208
      1086. #define MTI_FLTURN1_D 1209
      1087. #define MTI_FLTURN2_D 1210
      1088. #define MTI_FRTURN1_D 1211
      1089. #define MTI_FRTURN2_D 1212
      1090. #define MTI_FRUNNING1_D 1213
      1091. #define MTI_FRUNNING2_D 1214
      1092. #define MTI_FDMG1_D 1215
      1093. #define MTI_FATK1_D 1216
      1094. #define MTI_FATK2_D 1217
      1095. #define MTI_FATK3_D 1218
      1097. // parts
      1098. #define HAIRMESH_01 0
      1099. #define HAIRMESH_02 1
      1100. #define HAIRMESH_03 2
      1101. #define HAIRMESH_04 3
      1102. #define HAIRMESH_05 4
      1103. #define HAIRMESH_06 5
      1104. #define HAIRMESH_07 6
      1105. #define HAIRMESH_08 7
      1106. #define HAIRMESH_09 8
      1107. #define HAIRMESH_10 9
      1109. #define SKINSET_01 0
      1110. #define SKINSET_02 1
      1111. #define SKINSET_03 2
      1112. #define SKINSET_04 3
      1113. #define SKINSET_05 4
      1115. #define HEADTEXTURE_NORMAL 0
      1116. #define HEADTEXTURE_SMILE 1
      1117. #define HEADTEXTURE_RAGE 2
      1119. #define MAX_DEFAULT_HEAD 5
      1120. #define MAX_HEAD 11
      1121. #define MAX_HAIR 10
      1122. #define MAX_BASE_HAIR 5
      1123. #define MAX_SKIN 2
      1125. #define HAIR_COST 2000000
      1126. #define HAIRCOLOR_COST 4000000
      1127. #define CHANGE_FACE_COST 1000000
      1128. #endif
      Alles anzeigen


      greetz^^[/COLOR][/FONT]

    • Iamthegame;96900 schrieb:


      Ich kann keine neue WdMadrigal einsetzen sonst komm ich nicht in die world :/
      und es kommen auch keine errors

      ausser das (Client)

      Quellcode

      1. 2010/ 3/19 15:18:29 CDPLoginClient::OnPlayerList : 19752¾ÆÀÌÅÛ ÇÁ·ÎÆÛƼ ¾øÀ½
      3. 2010/ 3/19 15:18:35 Oct 9 2009 12:16:29 1 rCnt=1
      5. NeuzSerus.exe caused an EXCEPTION_ACCESS_VIOLATION in module NeuzSerus.exe at 001B:00710F5A
      7. - Registers
      9. EAX=00A5B198 EBX=7FFD6000 ECX=0000001F EDX=00000000 ESI=00000000
      10. EDI=00000000 EBP=0012BDC4 ESP=0012BD48 EIP=00710F5A FLG=00010206
      11. CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000
      13. 001B:00710F5A NeuzSerus.exe
      14. 001B:0070FFD7 NeuzSerus.exe
      15. 001B:006BB61C NeuzSerus.exe
      16. 001B:0071B2C5 NeuzSerus.exe
      17. 001B:0040381F NeuzSerus.exe
      18. 001B:004035E5 NeuzSerus.exe
      19. 001B:007214F7 NeuzSerus.exe
      20. 001B:0086F81D NeuzSerus.exe
      21. 001B:7774D0E9 kernel32.dll
      22. 001B:775C19BB ntdll.dll
      23. 001B:775C198E ntdll.dll
      Alles anzeigen



      helft mir bitte :'(

    • @XSay: thats not work the world server crashs again and no errors (sorry for my english)

      Also wie ich oben schon auf Englisch geschrieben habe klappt es mit einer neuen DefineNeuz.h auch nicht hab jetzt schon alles probiert und bin schon mit meinem Wissen über die Offi Files bei diesem Problem am "Ende"

      Könntet ihr mir noch Vorschläge nennen woran es liegen könnte das der World Server immer abstürzt habe schon Probiert

      die Data.resses aus dem Clienten mit dem Files angepasst
      neue Character.inc un neue DefineNeuz.h und es hat alles nicht geklappt

      Wenn jemand noch Ideen hat könnte er sie bitte hier nennen oder mir vielleicht noch Tipps über dieses Problem per PN Schreiben ?

    • Hay mmorpg-corler,

      ich hätte ma ein problem das hoffentlich nicht so schwer ist zu lösen.
      Und zwar ist es das hier, nehme ich ma vom GuildWar menager raus:

      MaFl_GuildWar
      {
      setting
      {
      AddMenu( MMI_DIALOG );
      AddMenu( MMI_GUILDWAR_APP );
      AddMenu( MMI_GUILDWAR_STATE );
      AddMenu( MMI_GUILDWAR_JOIN );
      AddMenu( MMI_GUILDCOMBAT_SELECTION );
      AddMenu( [COLOR="Red"]MMI_GUILDCOMBAT_INFO_BOARD1[/COLOR] );
      AddMenu( [COLOR="Red"]MMI_GUILDCOMBAT_INFO_BOARD2[/COLOR] );
      AddMenu( [COLOR="Red"]MMI_GUILDCOMBAT_INFO_BOARD3[/COLOR] );
      SetImage
      (
      IDS_CHARACTER_INC_000433
      );
      m_szDialog= "MaFl_GuildWarser.txt";
      }

      SetName
      (
      IDS_CHARACTER_INC_000434
      );
      }

      Der GuildWar menager öffnet nicht das dialog wen ich auf roten oben markierten schaltfläche klick, passiert einfach nicht.
      Ich höffe es könnte mir jemand dabei helfen!?! Wo könnte ich es machen das der Dialog erscheint?

      mfG
      zibber

    • Iamthegame;96900 schrieb:


      Ich kann keine neue WdMadrigal einsetzen sonst komm ich nicht in die world :/
      und es kommen auch keine errors

      ausser das (Client)

      Quellcode

      1. 2010/ 3/19 15:18:29 CDPLoginClient::OnPlayerList : 19752¾ÆÀÌÅÛ ÇÁ·ÎÆÛƼ ¾øÀ½
      3. 2010/ 3/19 15:18:35 Oct 9 2009 12:16:29 1 rCnt=1
      5. NeuzSerus.exe caused an EXCEPTION_ACCESS_VIOLATION in module NeuzSerus.exe at 001B:00710F5A
      7. - Registers
      9. EAX=00A5B198 EBX=7FFD6000 ECX=0000001F EDX=00000000 ESI=00000000
      10. EDI=00000000 EBP=0012BDC4 ESP=0012BD48 EIP=00710F5A FLG=00010206
      11. CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000
      13. 001B:00710F5A NeuzSerus.exe
      14. 001B:0070FFD7 NeuzSerus.exe
      15. 001B:006BB61C NeuzSerus.exe
      16. 001B:0071B2C5 NeuzSerus.exe
      17. 001B:0040381F NeuzSerus.exe
      18. 001B:004035E5 NeuzSerus.exe
      19. 001B:007214F7 NeuzSerus.exe
      20. 001B:0086F81D NeuzSerus.exe
      21. 001B:7774D0E9 kernel32.dll
      22. 001B:775C19BB ntdll.dll
      23. 001B:775C198E ntdll.dll
      Alles anzeigen


      PUHUUUUUUUUUUUUUUSCH >.< :(
      weiss denn niemand ne lösung warum ich net in die world komme wenn ich wdmadrigal ändere

    • Ich habe auch mal wieder ein Problem >.<
      Und zwar kann ich pro Account nur einen Char erstellen.
      Wenn ich einen zweiten erstellen will sagt der mir Verbindung mit dem Server nicht möglich.

      Ich habe die Errors schon durchgeguckt da steht nix kann auch sein das ich was übversehen habe aber eig nicht.
      Ich habe andere Server files ausprobiert, die dbs zich mal neu aufgesetzt und ich weiß nichtmehr weiter ><
      D:\ÇØ¿Ü\neurospace\Program\_database\DbManager.cpp, 174 CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='test2',@im_szName='Hanzzz',@iplayerslot=0,@idwWorldID=1,@im_dwIndex=12,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=-1.#QNAN0,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=3,@im_dwHairColor=-6921131,@im_dwHeadMesh=3,@im_dwSex=1,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0


      Da ist der erorr ich kann da leider nicht so viel rauslesen.

      Kann das der keine Char ID bekommt und deshalb nicht erstellt werden will weil bei jedem anderen Error von dem Problem immer

      'I1',@im_idPlayer='0000000',
      steht

      Wie schon gesagt ich bin da überfordert und weiß grade nicht weiter >.<

      Vielleicht kann mir ja einer helfen =)

    • DerJulian;99291 schrieb:

      Ich habe auch mal wieder ein Problem >.<
      Und zwar kann ich pro Account nur einen Char erstellen.
      Wenn ich einen zweiten erstellen will sagt der mir Verbindung mit dem Server nicht möglich.

      Ich habe die Errors schon durchgeguckt da steht nix kann auch sein das ich was übversehen habe aber eig nicht.
      Ich habe andere Server files ausprobiert, die dbs zich mal neu aufgesetzt und ich weiß nichtmehr weiter ><


      Da ist der erorr ich kann da leider nicht so viel rauslesen.

      Kann das der keine Char ID bekommt und deshalb nicht erstellt werden will weil bei jedem anderen Error von dem Problem immer

      'I1',@im_idPlayer='0000000',
      steht

      Wie schon gesagt ich bin da überfordert und weiß grade nicht weiter >.<


      Welche Datenbank benutzt du?

    • DerJulian;99291 schrieb:

      Ich habe auch mal wieder ein Problem >.<
      Und zwar kann ich pro Account nur einen Char erstellen.
      Wenn ich einen zweiten erstellen will sagt der mir Verbindung mit dem Server nicht möglich.

      Ich habe die Errors schon durchgeguckt da steht nix kann auch sein das ich was übversehen habe aber eig nicht.
      Ich habe andere Server files ausprobiert, die dbs zich mal neu aufgesetzt und ich weiß nichtmehr weiter ><


      Da ist der erorr ich kann da leider nicht so viel rauslesen.

      Kann das der keine Char ID bekommt und deshalb nicht erstellt werden will weil bei jedem anderen Error von dem Problem immer

      'I1',@im_idPlayer='0000000',
      steht

      Wie schon gesagt ich bin da überfordert und weiß grade nicht weiter >.<

      Vielleicht kann mir ja einer helfen =)


      Ich denke mal du brauchst ne andere CHARACTER_STR

      Versuch mal deine zu löschen , wenn das nicht geht probier mal die Prozedur aus

      Quellcode

      1. USE [CHARACTER_01_DBF]
      2. GO
      4. /****** Object: StoredProcedure [dbo].[CHARACTER_STR] Script Date: 01/29/2010 13:04:54 ******/
      5. SET ANSI_NULLS ON
      6. GO
      8. SET QUOTED_IDENTIFIER ON
      9. GO
      11. /****** Object: Stored Procedure dbo.CHARACTER_STR Script Date: 7/29/2008 3:34:04 AM ******/
      12. CREATE proc [dbo].[CHARACTER_STR]
      13. @iGu CHAR(2) = 'S1',
      14. @im_idPlayer CHAR(7) = '0000001',
      15. @iserverindex CHAR(2) = '01',
      16. /**********************************************
      17. INSERT 용
      18. **********************************************/
      19. -- CHARACTER_TBL
      20. @iaccount VARCHAR(32) = '',
      21. @im_szName VARCHAR(32) = '',
      22. @iplayerslot INT = 0,
      23. @idwWorldID INT = 0,
      24. @im_dwIndex INT = 0,
      25. @im_vPos_x REAL = 0,
      26. @im_vPos_y REAL = 0,
      27. @im_vPos_z REAL = 0,
      28. @im_szCharacterKey VARCHAR(32) = '',
      29. @im_dwSkinSet INT = 0,
      30. @im_dwHairMesh INT = 0,
      31. @im_dwHairColor INT = 0,
      32. @im_dwHeadMesh INT = 0,
      33. @im_dwSex INT = 0,
      34. /**********************************************
      35. UPDATE 용
      36. **********************************************/
      37. -- CHARACTER_TBL
      38. @im_vScale_x REAL = 0,
      39. @im_dwMotion INT = 0,
      40. @im_fAngle REAL = 0,
      41. @im_nHitPoint INT = 0,
      42. @im_nManaPoint INT = 0,
      43. @im_nFatiguePoint INT = 0,
      44. @im_dwRideItemIdx INT = 0,
      45. @im_dwGold INT = 0,
      46. @im_nJob INT = 0,
      47. @im_pActMover VARCHAR(50) = '',
      48. @im_nStr INT = 0,
      49. @im_nSta INT = 0,
      50. @im_nDex INT = 0,
      51. @im_nInt INT = 0,
      52. @im_nLevel INT = 0,
      53. @im_nExp1 BIGINT = 0,
      54. @im_nExp2 BIGINT = 0,
      55. @im_aJobSkill VARCHAR(500) ='',
      56. @im_aLicenseSkill VARCHAR(500) ='',
      57. @im_aJobLv VARCHAR(500) ='',
      58. @im_dwExpertLv INT = 0,
      59. @im_idMarkingWorld INT = 0,
      60. @im_vMarkingPos_x REAL = 0,
      61. @im_vMarkingPos_y REAL = 0,
      62. @im_vMarkingPos_z REAL = 0,
      63. @im_nRemainGP INT = 0,
      64. @im_nRemainLP INT = 0,
      65. @im_nFlightLv INT = 0,
      66. @im_nFxp INT = 0,
      67. @im_nTxp INT = 0,
      68. @im_lpQuestCntArray VARCHAR(3072)= '',
      69. @im_chAuthority CHAR(1) = '',
      70. @im_dwMode INT = 0,
      71. @im_idparty INT = 0,
      72. --@im_nNumKill INT = 0,
      73. @im_idMuerderer INT = 0,
      74. --@im_nSlaughter INT = 0,
      75. @im_nFame INT = 0,
      76. @im_nDeathExp BIGINT = 0,
      77. @im_nDeathLevel INT = 0,
      78. @im_dwFlyTime INT = 0,
      79. @im_nMessengerState INT = 0,
      80. @iTotalPlayTime INT = 0,
      81. ---------- Additional end ----------
      82. -- PK Variable
      83. @im_nPKValue int=0,
      84. @im_dwPKPropensity int=0,
      85. @im_dwPKExp int=0,
      86. ---------- Additional end ----------
      87. -- CARD_CUBE_TBL
      88. @im_Card VARCHAR(1980)= '',
      89. @im_Index_Card VARCHAR(215) = '',
      90. @im_ObjIndex_Card VARCHAR(215) = '',
      91. @im_Cube VARCHAR(1980)= '',
      92. @im_Index_Cube VARCHAR(215) = '',
      93. @im_ObjIndex_Cube VARCHAR(215) = '',
      94. -- INVENTORY_TBL
      95. @im_Inventory VARCHAR(6940)= '',
      96. @im_apIndex VARCHAR(345) = '',
      97. @im_adwEquipment VARCHAR(135) = '',
      98. @im_dwObjIndex VARCHAR(345) = '',
      99. -- TASKBAR_TBL
      100. @im_aSlotApplet VARCHAR(3100)= '',
      101. -- TASKBAR_ITEM_TBL
      102. @im_aSlotItem VARCHAR(6885)= '',
      103. -- TASKBAR_TBL
      104. @im_aSlotQueue VARCHAR(225)= '',
      105. @im_SkillBar SMALLINT = 0,
      106. -- BANK_TBL
      107. @im_Bank VARCHAR(4290)= '',
      108. @im_apIndex_Bank VARCHAR(215)= '',
      109. @im_dwObjIndex_Bank VARCHAR(215)= '',
      110. @im_dwGoldBank INT = 0,
      111. @im_nFuel INT = -1,
      112. @im_tmAccFuel INT = 0,
      113. @im_dwSMTime VARCHAR(2560)='',
      114. @iSkillInfluence varchar(2048) ='',
      115. @im_dwSkillPoint INT = 0,
      116. @im_aCompleteQuest varchar(1024) = '',
      117. @im_extInventory varchar(2000) = '',
      118. @im_extBank varchar(2000) = '',
      119. @im_InventoryPiercing varchar(2000) = '',
      120. @im_BankPiercing varchar(2000) = '',
      121. @im_dwReturnWorldID INT = 1,
      122. @im_vReturnPos_x REAL = 0,
      123. @im_vReturnPos_y REAL = 0,
      124. @im_vReturnPos_z REAL= 0
      125. -------------- ( Version 7 : Skill Update)
      126. , @im_SkillPoint int=0
      127. , @im_SkillLv int=0
      128. , @im_SkillExp bigint=0
      129. -------------- (Additional end)
      130. , @idwEventFlag bigint=0,
      131. @idwEventTime int=0,
      132. @idwEventElapsed int=0
      133. -------------- (Additional end)
      134. ----------Additional end----------
      135. -- PVP (Additional end)
      136. ,@im_nAngelExp bigint=0
      137. ,@im_nAngelLevel int=0
      138. ----------Additional end ----------
      139. --------------- Version 9 Relation of additional partial Pet
      140. ,@iszInventoryPet varchar(2688) = '$'
      141. ,@iszBankPet varchar(2688) = '$'
      142. ,@im_dwPetId int = -1
      143. ,@im_nExpLog int = 0
      144. ,@im_nAngelExpLog int = 0
      145. --------- Ver 11 Coupon
      146. ,@im_nCoupon int = 0
      147. --------- Ver 14 Shit
      148. ,@im_nHonor int = -1
      149. ,@im_nLayer int = 0
      151. /*******************************************************
      152. Gu Dividing
      153. S : SELECT
      154. I : INSERT
      155. U : UPDATE
      156. D : DELETE
      159. 2005.04.11 updated
      161. ALTER TABLE CHARACTER_TBL ADD m_aCompleteQuest varchar(1024) NULL
      162. ALTER TABLE CHARACTER_TBL ALTER COLUMN m_lpQuestCntArray VARCHAR(3072) NULL
      164. *******************************************************/
      165. AS
      166. set nocount on
      167. declare @last_connect tinyint
      168. set @last_connect = 1
      170. IF @iGu = 'S2' -- Is a player list which follows in the slot cuts coil information bringing,
      171. BEGIN
      172. IF @iaccount = '' OR @im_szName = ''
      173. BEGIN
      174. SELECT m_chAuthority = '',fError = '1', fText = 'Wrong password'
      175. RETURN
      176. END
      177. SELECT A.dwWorldID,
      178. A.m_szName,
      179. A.playerslot,
      180. A.End_Time,
      181. A.BlockTime,
      182. A.m_dwIndex,
      183. A.m_idPlayer,
      184. A.m_idparty,
      185. A.m_dwSkinSet,
      186. A.m_dwHairMesh,
      187. A.m_dwHeadMesh,
      188. A.m_dwHairColor,
      189. A.m_dwSex,
      190. A.m_nJob,
      191. A.m_nLevel,
      192. A.m_vPos_x,
      193. A.m_vPos_y,
      194. A.m_vPos_z,
      195. A.m_nStr,
      196. A.m_nSta,
      197. A.m_nDex,
      198. A.m_nInt,
      199. --A.m_nSlaughter, -- raidersAddition 2005.5.11
      200. A.m_aJobLv,
      201. A.m_chAuthority,
      202. A.m_idCompany,
      203. A.m_nMessengerState,
      204. B.m_Inventory,
      205. B.m_apIndex,
      206. B.m_adwEquipment,
      207. B.m_dwObjIndex,
      208. m_idGuild = CASE WHEN C.m_idGuild IS NULL THEN '0' ELSE C.m_idGuild END ,
      209. m_idWar = CASE WHEN C.m_idWar IS NULL THEN '0' ELSE C.m_idWar END,
      210. D.m_extInventory,
      211. D.m_InventoryPiercing,
      212. A.m_idCompany,
      213. last_connect = @last_connect
      214. FROM CHARACTER_TBL A, INVENTORY_TBL B,GUILD_MEMBER_TBL C, INVENTORY_EXT_TBL D
      215. WHERE A.m_idPlayer = B.m_idPlayer
      216. AND A.serverindex= B.serverindex
      217. AND B.m_idPlayer = D.m_idPlayer
      218. AND B.serverindex = D.serverindex
      219. AND D.m_idPlayer *= C.m_idPlayer
      220. AND D.serverindex *= C.serverindex
      221. AND A.isblock = 'F'
      222. AND A.account = @iaccount
      223. AND A.serverindex= @iserverindex
      224. ORDER BY A.playerslot
      225. RETURN
      226. END
      227. /*
      229. Is a player list which follows in the slot cuts coil information bringing,
      230. ex )
      231. CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
      232. CHARACTER_STR 'S2','0','02','seghope','1234'
      235. */
      237. ELSE
      238. IF @iGu = 'S3' -- The server initially idPlayer of characters which will execute all the branch, coming,
      239. BEGIN
      240. SELECT m_szName, m_idPlayer,m_idCompany
      241. FROM CHARACTER_TBL
      242. WHERE serverindex = @iserverindex
      243. -- AND isblock = 'F'
      244. ORDER BY m_idPlayer
      245. RETURN
      246. END
      247. /*
      249. The server initially idPlayer of characters which will execute all the branch, coming,
      250. ex )
      251. CHARACTER_STR 'S3','',@iserverindex
      252. CHARACTER_STR 'S3','','02'
      256. */
      258. ELSE
      259. IF @iGu = 'S4' -- The item confirmation which will add
      260. BEGIN
      261. /* if (getdate() >= '2007-10-29 00:00:00' and getdate() <= '2007-10-31 23:59:59')
      262. begin
      263. if not exists (select * from EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 where serverindex = @iserverindex and m_idPlayer = @im_idPlayer)
      264. begin
      265. declare @q1 nvarchar(4000)
      266. declare @ktime bigint
      267. select @ktime = cast(replace(replace(replace(convert(char(16), dateadd(hh, 72, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
      269. set @q1 = '
      270. insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, m_bItemResist, m_nResistAbilityOption, m_bCharged, m_dwKeepTime)
      271. select @im_idPlayer, @iserverindex, ''26425'', 1, 0, 0, 0, 0, @ktime'
      272. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2), @ktime bigint', @im_idPlayer, @iserverindex, @ktime
      274. set @q1 = '
      276. insert into EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 (serverindex, m_idPlayer)
      277. select @iserverindex, @im_idPlayer'
      278. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      280. set @q1 = '
      281. SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
      282. FROM ITEM_SEND_TBL
      283. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      284. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      286. end
      288. else
      290. begin
      291. SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
      292. FROM ITEM_SEND_TBL
      293. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
      294. end
      295. end
      296. else
      297. begin
      299. SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
      300. FROM ITEM_SEND_TBL
      301. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
      303. end*/
      304. declare @q1 nvarchar(4000)
      306. /* if ((getdate() >= '2007-12-23 00:00:00') and (getdate() <= '2007-12-25 23:59:59'))
      307. begin
      308. if not exists (select * from tblevent_2007_xmas where m_idPlayer = @im_idPlayer)
      309. begin
      310. declare @m_dwSex int
      311. declare @xmas_Item varchar(32)
      312. select @m_dwSex = m_dwSex from CHARACTER_TBL where m_idPlayer = @im_idPlayer
      313. if @m_dwSex = 0
      314. begin
      315. set @xmas_Item = '26339'
      316. end
      317. else
      318. begin
      319. set @xmas_Item = '26340'
      320. end
      322. set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
      323. select @im_idPlayer, ''01'', @xmas_Item, 1, 0, ''0000000'''
      324. exec sp_executesql @q1, N'@im_idPlayer char(7), @xmas_Item varchar(32)', @im_idPlayer, @xmas_Item
      326. insert into tblevent_2007_xmas (m_idPlayer)
      327. select @im_idPlayer
      329. set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
      330. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
      331. FROM ITEM_SEND_TBL
      332. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      333. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      334. end
      335. else
      336. begin
      337. set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
      338. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
      339. FROM ITEM_SEND_TBL
      340. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      341. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      342. end
      343. end*/
      344. if ((getdate() >= '2007-12-31 00:00:00') and (getdate() <= '2007-12-31 23:59:59'))
      345. begin
      346. if not exists (select * from tblevent_2007_newyear where m_idPlayer = @im_idPlayer)
      347. begin
      348. declare @newyear_Item varchar(32)
      349. set @newyear_Item = '2904'
      350. set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
      351. select @im_idPlayer, ''01'', @newyear_Item, 5, 0, ''0000000'''
      352. exec sp_executesql @q1, N'@im_idPlayer char(7), @newyear_Item varchar(32)', @im_idPlayer, @newyear_Item
      354. insert into tblevent_2007_newyear (m_idPlayer)
      355. select @im_idPlayer
      357. set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
      358. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
      359. FROM ITEM_SEND_TBL
      360. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      361. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      362. end
      363. else
      364. begin
      365. set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
      366. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
      367. FROM ITEM_SEND_TBL
      368. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      369. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      370. end
      371. end
      372. else
      373. begin
      374. set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
      375. m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
      376. FROM ITEM_SEND_TBL
      377. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
      378. exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
      379. end
      380. RETURN
      381. END
      382. /*
      385. Item confirmation
      386. ex )
      387. CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
      388. CHARACTER_STR 'S4','000001','01'
      390. */
      392. ELSE
      393. IF @iGu = 'S5' -- From table after item utmost urgency item elimination
      394. BEGIN
      395. -- DELETE ITEM_SEND_TBL
      396. UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1
      397. WHERE m_nNo = @iplayerslot
      398. IF @@ROWCOUNT = 0
      399. SELECT fError = '0'
      400. ELSE
      401. SELECT fError = '1'
      402. RETURN
      403. END
      404. /*
      406. From table after item utmost urgency item elimination
      407. ex )
      408. CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount
      409. CHARACTER_STR 'S5','000001','01','Broom',1,1
      410. */
      412. ELSE
      413. IF @iGu = 'S6' -- The item confirmation which will eliminate
      414. BEGIN
      415. SELECT Item_Name,
      416. Item_count,
      417. m_nAbilityOption,
      418. m_nNo,
      419. State,
      420. m_bItemResist,
      421. m_nResistAbilityOption
      422. FROM ITEM_REMOVE_TBL
      423. WHERE m_idPlayer = @im_idPlayer
      424. AND serverindex = @iserverindex
      425. AND ItemFlag = 0
      426. RETURN
      427. END
      428. /*
      429. Item confirmation
      430. ex )
      431. CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
      432. CHARACTER_STR 'S6','000001','01'
      433. */
      435. ELSE
      436. IF @iGu = 'S7' -- After item eliminating from table item elimination
      437. BEGIN
      438. -- DELETE ITEM_REMOVE_TBL
      439. UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1
      440. WHERE m_nNo = @iplayerslot
      442. IF @@ROWCOUNT = 0
      443. SELECT fError = '0'
      444. ELSE
      445. SELECT fError = '1'
      446. RETURN
      447. END
      448. /*
      449. From table after item utmost urgency item elimination
      450. ex )
      451. CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
      452. CHARACTER_STR 'S7','000001','01','Broom',1,1
      453. */
      455. IF @iGu = 'S8' -- The data whole bringing,
      456. BEGIN
      457. PRINT @iaccount
      459. DECLARE @om_chLoginAuthority CHAR(1)
      460. -- Bank information character stars bringing
      462. SET @om_chLoginAuthority = 'F'
      463. --SELECT @om_chLoginAuthority = m_chLoginAuthority
      464. -- FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
      465. --WHERE lower(account) = lower(@iaccount)
      466. --INSERT INTO [ONLINE_TBL] ([account] ,[name]) VALUES(@iaccount,@im_idPlayer)
      467. SELECT m_chLoginAuthority = @om_chLoginAuthority,
      468. A.account,
      469. A.m_idPlayer,
      470. A.playerslot,
      471. A.serverindex,
      472. A.dwWorldID,
      473. A.m_szName,
      474. A.m_dwIndex,
      475. A.m_vScale_x,
      476. A.m_dwMotion,
      477. A.m_vPos_x,
      478. A.m_vPos_y,
      479. A.m_vPos_z,
      480. A.m_fAngle,
      481. A.m_szCharacterKey,
      482. A.m_idPlayer,
      483. A.m_nHitPoint,
      484. A.m_nManaPoint,
      485. A.m_nFatiguePoint,
      486. A.m_nFuel,
      487. A.m_dwSkinSet,
      488. A.m_dwHairMesh,
      489. A.m_dwHairColor,
      490. A.m_dwHeadMesh,
      491. A.m_dwSex,
      492. A.m_dwRideItemIdx,
      493. A.m_dwGold,
      494. A.m_nJob,
      495. A.m_pActMover,
      496. A.m_nStr,
      497. A.m_nSta,
      498. A.m_nDex,
      499. A.m_nInt,
      500. A.m_nLevel,
      501. A.m_nMaximumLevel,
      502. A.m_nExp1,
      503. A.m_nExp2,
      504. A.m_aJobSkill,
      505. A.m_aLicenseSkill,
      506. A.m_aJobLv,
      507. A.m_dwExpertLv,
      508. A.m_idMarkingWorld,
      510. A.m_vMarkingPos_x,
      511. A.m_vMarkingPos_y,
      512. A.m_vMarkingPos_z,
      513. A.m_nRemainGP,
      514. A.m_nRemainLP,
      515. A.m_nFlightLv,
      516. A.m_nFxp,
      517. A.m_nTxp,
      518. A.m_lpQuestCntArray,
      519. m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
      520. A.m_chAuthority,
      521. A.m_dwMode,
      522. A.m_idparty,
      523. A.m_idCompany,
      524. --A.m_nNumKill,
      525. A.m_idMuerderer,
      526. --A.m_nSlaughter,
      527. A.m_nFame,
      528. A.m_nDeathExp,
      529. A.m_nDeathLevel,
      530. A.m_dwFlyTime,
      531. A.m_nMessengerState,
      532. A.End_Time,
      533. A.BlockTime,
      534. A.blockby,
      535. A.isblock,
      536. A.TotalPlayTime,
      537. A.CreateTime,
      538. A.m_dwSkillPoint,
      539. B.m_aSlotApplet,
      540. B.m_aSlotQueue,
      541. B.m_SkillBar,
      542. C.m_aSlotItem,
      543. D.m_Inventory,
      544. D.m_apIndex,
      545. D.m_adwEquipment,
      546. D.m_dwObjIndex,
      547. m_idGuild = ISNULL(G.m_idGuild,'0'),
      549. m_idWar = ISNULL(G.m_idWar,'0'),
      550. A.m_tmAccFuel,
      551. A.m_tGuildMember,
      552. m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL') ,
      553. SkillInfluence = ISNULL(E.SkillInfluence,'$'),
      554. F.m_extInventory,
      555. F.m_InventoryPiercing,
      556. A.m_dwReturnWorldID,
      557. A.m_idCompany,
      558. A.m_vReturnPos_x,
      559. A.m_vReturnPos_y,
      560. A.m_vReturnPos_z
      561. ------------------ ( ADD : Version7-Skill System)
      562. , m_SkillPoint = SkillPoint
      563. , m_SkillLv = SkillLv
      564. , m_SkillExp = SkillExp
      565. -------------- (Additional start)
      566. , A.dwEventFlag,
      567. A.dwEventTime,
      568. A.dwEventElapsed
      569. -------------- (Additional start)
      570. ----------Additional start ----------
      571. , A.PKValue as m_nPKValue,
      572. A.PKPropensity as m_dwPKPropensity,
      573. A.PKExp as m_dwPKExp
      574. ----------Additional end ----------
      575. ----------Additional end ----------
      576. ,AngelExp as m_nAngelExp
      577. ,AngelLevel as m_nAngelLevel
      578. ----------Additional end ----------
      579. ------------------- Version9 Pet
      580. , F.szInventoryPet as szInventoryPet
      581. , A.m_dwPetId
      582. , A.m_nExpLog, A.m_nAngelExpLog
      583. ------------- Ver 11 Coupon
      584. , m_nCoupon
      585. ------------- Ver 14 shit
      586. , m_nHonor
      587. , m_nLayer
      588. , last_connect = @last_connect
      589. FROM CHARACTER_TBL A,
      590. TASKBAR_TBL B,
      591. TASKBAR_ITEM_TBL C,
      592. INVENTORY_TBL D,
      593. SKILLINFLUENCE_TBL E,
      594. INVENTORY_EXT_TBL F,
      595. GUILD_MEMBER_TBL G,
      596. BILING_ITEM_TBL H
      597. WHERE A.m_idPlayer = @im_idPlayer
      598. AND A.serverindex = @iserverindex
      599. AND A.m_idPlayer = B.m_idPlayer
      600. AND A.serverindex = B.serverindex
      601. AND B.m_idPlayer = C.m_idPlayer
      602. AND B.serverindex = C.serverindex
      603. AND C.m_idPlayer = D.m_idPlayer
      604. AND C.serverindex = D.serverindex
      605. AND D.m_idPlayer = E.m_idPlayer
      606. AND D.serverindex = E.serverindex
      607. AND E.m_idPlayer = F.m_idPlayer
      608. AND E.serverindex = F.serverindex
      609. AND F.serverindex *= G.serverindex
      610. AND F.m_idPlayer *= G.m_idPlayer
      611. AND F.serverindex *= H.serverindex
      612. AND F.m_idPlayer *= H.m_idPlayer
      613. AND A.account = lower(@iaccount)
      616. -- Bank information account stars bringing
      618. -- DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
      619. --
      620. -- INSERT @bank
      621. -- (m_idPlayer,serverindex,playerslot)
      622. -- SELECT m_idPlayer,serverindex,playerslot
      623. -- FROM CHARACTER_TBL
      624. -- WHERE account = @iaccount
      625. -- AND isblock = 'F'
      626. -- ORDER BY playerslot
      628. SELECT a.m_idPlayer,
      629. c.playerslot,
      630. a.m_Bank,
      631. a.m_apIndex_Bank,
      632. a.m_dwObjIndex_Bank,
      633. a.m_dwGoldBank,
      634. a.m_BankPw,
      635. b.m_extBank,
      636. b.m_BankPiercing, b.szBankPet
      637. FROM dbo.BANK_TBL a,
      638. dbo.BANK_EXT_TBL b,
      639. dbo.CHARACTER_TBL c
      640. WHERE a.m_idPlayer = b.m_idPlayer
      641. AND a.serverindex = b.serverindex
      642. AND b.m_idPlayer = c.m_idPlayer
      643. AND b.serverindex = c.serverindex
      644. AND c.account = lower(@iaccount)
      645. AND c.isblock = 'F'
      646. ORDER BY c.playerslot
      648. ------------- Ver11 Pocket
      649. SELECT a.nPocket,
      650. a.szItem,
      651. a.szIndex,
      652. a.szObjIndex,
      653. a.bExpired,
      654. a.tExpirationDate,
      655. b.szExt,
      656. b.szPiercing,
      657. b.szPet
      658. FROM tblPocket as a inner join tblPocketExt as b
      659. on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
      660. WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
      661. ORDER BY a.nPocket
      663. RETURN
      664. END
      665. /*
      667. The data whole bringing, New
      668. ex )
      669. CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
      670. CHARACTER_STR 'S8','425120','01','ata3k'
      671. */
      672. ELSE
      673. IF @iGu = 'U1' -- Character store
      674. BEGIN
      675. --DELETE FROM ONLINE_TBL WHERE name = @im_idPlayer
      676. UPDATE CHARACTER_TBL
      677. SET dwWorldID = @idwWorldID,
      678. m_dwIndex = @im_dwIndex,
      679. m_dwSex = @im_dwSex,
      680. m_vScale_x = @im_vScale_x,
      681. m_dwMotion = @im_dwMotion,
      682. m_vPos_x = @im_vPos_x,
      683. m_vPos_y = @im_vPos_y,
      684. m_vPos_z = @im_vPos_z,
      685. m_dwHairMesh = @im_dwHairMesh,
      686. m_dwHairColor = @im_dwHairColor,
      687. m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 Addition
      688. m_fAngle = 0, --@im_fAngle,
      689. m_szCharacterKey = @im_szCharacterKey,
      691. m_nHitPoint = @im_nHitPoint,
      692. m_nManaPoint = @im_nManaPoint,
      693. m_nFatiguePoint = @im_nFatiguePoint,
      694. m_nFuel = @im_nFuel,
      695. m_dwRideItemIdx = @im_dwRideItemIdx,
      696. m_dwGold = @im_dwGold,
      697. m_nJob = @im_nJob,
      698. m_pActMover = @im_pActMover,
      699. m_nStr = @im_nStr,
      700. m_nSta = @im_nSta,
      701. m_nDex = @im_nDex,
      702. m_nInt = @im_nInt,
      704. m_nLevel = @im_nLevel,
      705. m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
      706. m_nExp1 = @im_nExp1,
      707. m_nExp2 = @im_nExp2,
      708. m_aJobSkill = @im_aJobSkill,
      709. m_aLicenseSkill = @im_aLicenseSkill,
      710. m_aJobLv = @im_aJobLv,
      711. m_dwExpertLv = @im_dwExpertLv,
      712. m_idMarkingWorld = @im_idMarkingWorld,
      713. m_vMarkingPos_x = @im_vMarkingPos_x,
      714. m_vMarkingPos_y = @im_vMarkingPos_y,
      715. m_vMarkingPos_z = @im_vMarkingPos_z,
      716. m_nRemainGP = @im_nRemainGP,
      717. m_nRemainLP = @im_nRemainLP,
      718. m_nFlightLv = @im_nFlightLv,
      719. m_nFxp = @im_nFxp,
      720. m_nTxp = @im_nTxp,
      721. m_lpQuestCntArray = @im_lpQuestCntArray,
      722. m_aCompleteQuest = @im_aCompleteQuest,
      723. m_dwMode = @im_dwMode,
      724. m_idparty = @im_idparty,
      725. --m_nNumKill = @im_nNumKill,
      726. m_idMuerderer = @im_idMuerderer,
      727. --m_nSlaughter = @im_nSlaughter ,
      729. m_nFame = @im_nFame,
      730. m_nDeathExp = @im_nDeathExp,
      731. m_nDeathLevel = @im_nDeathLevel,
      733. -- m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime,
      734. m_dwFlyTime = @im_dwFlyTime,
      735. m_nMessengerState = @im_nMessengerState,
      736. TotalPlayTime = TotalPlayTime + @iTotalPlayTime,
      737. m_tmAccFuel = @im_tmAccFuel,
      738. m_dwSkillPoint = @im_dwSkillPoint,
      739. m_dwReturnWorldID= @im_dwReturnWorldID,
      740. m_idCompany = 0,
      741. m_vReturnPos_x = @im_vReturnPos_x,
      742. m_vReturnPos_y = @im_vReturnPos_y,
      743. m_vReturnPos_z = @im_vReturnPos_z
      744. -------------- (ADD: Version7-SkillSystem)
      745. , SkillPoint = @im_SkillPoint
      746. , SkillLv = @im_SkillLv
      747. , SkillExp = @im_SkillExp
      748. -------------- (Additional part)
      749. , dwEventFlag =@idwEventFlag,
      750. dwEventTime =@idwEventTime,
      751. dwEventElapsed =@idwEventElapsed
      752. -------------- (Additional part)
      753. ----------Additional start ----------
      754. , PKValue = @im_nPKValue,
      755. PKPropensity = @im_dwPKPropensity,
      756. PKExp = @im_dwPKExp
      757. ----------Additional end ----------
      758. ----------Additional start ----------
      759. , AngelExp= @im_nAngelExp
      760. , AngelLevel= @im_nAngelLevel
      761. ----------Additional end ----------
      762. --------------------- Version9 Pet
      763. , m_dwPetId = @im_dwPetId
      764. , m_nExpLog = @im_nExpLog
      765. , m_nAngelExpLog = @im_nAngelExpLog
      766. ------------ Ver 11
      767. , m_nCoupon = @im_nCoupon
      768. , m_nLayer = @im_nLayer
      769. WHERE m_idPlayer = @im_idPlayer
      770. AND serverindex = @iserverindex
      772. -- if object_id('QUEST_TBL') is not null
      773. -- EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray
      775. --Relation of [song] present three request fact Bill rings
      776. IF @im_dwSMTime > ''
      777. BEGIN
      778. IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer AND serverindex = @iserverindex)
      779. UPDATE BILING_ITEM_TBL
      780. SET m_dwSMTime = @im_dwSMTime
      781. WHERE m_idPlayer = @im_idPlayer
      782. AND serverindex = @iserverindex
      783. ELSE
      784. INSERT BILING_ITEM_TBL
      785. (m_idPlayer,serverindex,m_dwSMTime)
      786. VALUES
      787. (@im_idPlayer,@iserverindex,@im_dwSMTime)
      788. END
      789. ELSE
      790. DELETE BILING_ITEM_TBL
      791. WHERE m_idPlayer = @im_idPlayer
      792. AND serverindex = @iserverindex
      795. -- UPDATE CARD_CUBE_TBL
      796. -- SET m_Card = @im_Card,
      797. -- m_apIndex_Card = @im_Index_Card,
      798. -- m_dwObjIndex_Card= @im_ObjIndex_Card,
      799. -- m_Cube = @im_Cube,
      800. -- m_apIndex_Cube = @im_Index_Cube,
      801. -- m_dwObjIndex_Cube=@im_ObjIndex_Cube
      802. -- WHERE m_idPlayer = @im_idPlayer
      803. -- AND serverindex = @iserverindex
      805. UPDATE INVENTORY_TBL
      806. SET m_Inventory = @im_Inventory,
      807. m_apIndex = @im_apIndex,
      808. m_adwEquipment = @im_adwEquipment,
      809. m_dwObjIndex = @im_dwObjIndex
      810. WHERE m_idPlayer = @im_idPlayer
      811. AND serverindex = @iserverindex
      814. UPDATE TASKBAR_TBL
      815. SET m_aSlotApplet = @im_aSlotApplet,
      816. m_aSlotQueue = @im_aSlotQueue,
      817. m_SkillBar = @im_SkillBar
      818. WHERE m_idPlayer = @im_idPlayer
      819. AND serverindex = @iserverindex
      822. UPDATE TASKBAR_ITEM_TBL
      823. SET m_aSlotItem = @im_aSlotItem
      824. WHERE m_idPlayer = @im_idPlayer
      825. AND serverindex = @iserverindex
      827. UPDATE BANK_TBL
      828. SET m_Bank = @im_Bank,
      829. m_apIndex_Bank = @im_apIndex_Bank,
      830. m_dwObjIndex_Bank = @im_dwObjIndex_Bank,
      831. m_dwGoldBank = @im_dwGoldBank
      832. WHERE m_idPlayer = @im_idPlayer
      833. AND serverindex = @iserverindex
      835. UPDATE SKILLINFLUENCE_TBL
      836. SET SkillInfluence = @iSkillInfluence
      837. WHERE m_idPlayer = @im_idPlayer
      838. AND serverindex = @iserverindex
      840. UPDATE INVENTORY_EXT_TBL
      841. SET m_extInventory = @im_extInventory,
      842. m_InventoryPiercing = @im_InventoryPiercing
      843. , szInventoryPet = @iszInventoryPet
      844. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
      846. UPDATE BANK_EXT_TBL
      847. SET m_extBank = @im_extBank,
      848. m_BankPiercing = @im_BankPiercing
      849. , szBankPet = @iszBankPet
      850. WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
      852. SELECT fError = '1', fText = 'OK'
      853. RETURN
      854. END
      855. /*
      857. Information update
      858. ex )
      859. CHARACTER_STR 'U1', ALL ...
      860. CHARACTER_STR 'U1','000001','01' ...
      861. */
      863. ELSE
      864. IF @iGu = 'U2' -- Total use time correction
      865. BEGIN
      866. UPDATE CHARACTER_TBL
      867. SET TotalPlayTime = TotalPlayTime + @iplayerslot
      868. WHERE m_szName = @im_szName
      869. AND serverindex = @iserverindex
      870. RETURN
      871. END
      873. /*
      875. Total use time correction
      876. ex )
      877. CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
      878. CHARACTER_STR 'U2','','01','','beat',10234
      879. */
      881. ELSE
      882. IF @iGu = 'U3' --Total use time correction new
      883. BEGIN
      884. UPDATE CHARACTER_TBL
      885. SET TotalPlayTime = TotalPlayTime + @iplayerslot
      886. WHERE m_idPlayer = @im_idPlayer
      887. AND serverindex = @iserverindex
      888. RETURN
      889. END
      890. /*
      892. Total use time correction (new)
      893. ex )
      894. CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
      896. CHARACTER_STR 'U3','000001','01','','',10234
      897. */
      899. ELSE
      900. IF @iGu = 'U4' --Character life fringe land
      901. BEGIN
      902. IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE lower(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
      903. BEGIN
      904. SELECT fError = '0'
      905. END
      906. ELSE
      907. BEGIN
      908. UPDATE CHARACTER_TBL
      909. SET m_szName = @im_szName
      910. WHERE m_idPlayer = @im_idPlayer
      911. AND serverindex = @iserverindex
      912. SELECT fError = '1'
      913. END
      914. RETURN
      915. END
      917. /*
      920. Character life fringe land
      921. ex)
      922. CHARACTER_STR ' U4' @im_idPlayer, @iserverindex, @iaccount and @im_szName
      923. CHARACTER_STR ' U4' ' 000001' ' 01' ' ' ' The morning star princess'
      924. */
      925. ELSE
      926. IF @iGu = 'D1' -- Character elimination
      927. BEGIN
      929. -- The part which the box tries to close once in the class arctic regions #1 2007-03-21
      930. IF @im_szName = ''
      931. BEGIN
      932. SELECT fError = '1', fText = 'Resident number error'
      933. RETURN
      934. END
      935. if not exists (select * from CHARACTER_TBL where m_idPlayer = @im_idPlayer and account = @iaccount and serverindex = @iserverindex)
      936. begin
      937. select fError = '1'
      938. return
      939. end
      941. DECLARE @Exists int
      943. -- IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN')
      944. -- BEGIN
      945. -- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (password = @im_szName OR member = 'B' ))
      946. SET @Exists = 1
      947. -- ELSE
      948. -- SET @Exists = 0
      949. -- END
      950. -- ELSE
      951. -- BEGIN
      952. -- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' ))
      953. -- SET @Exists = 1
      954. -- ELSE
      955. -- SET @Exists = 0
      956. -- END
      958. IF @Exists > 0
      959. BEGIN
      960. DECLARE @currDate char(12)
      961. SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
      962. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
      963. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
      967. IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND m_idWar > 0)
      968. BEGIN
      969. SELECT fError = '3', fText = 'In before guild'
      970. RETURN
      971. END
      972. ELSE
      973. BEGIN
      974. UPDATE CHARACTER_TBL
      976. SET isblock = 'D',
      977. End_Time = @currDate ,
      979. BlockTime = LEFT(@currDate,8)
      980. WHERE m_idPlayer = @im_idPlayer
      981. AND serverindex = @iserverindex
      983. UPDATE MESSENGER_TBL
      984. SET State = 'D'
      985. WHERE m_idPlayer = @im_idPlayer
      986. AND serverindex = @iserverindex
      988. UPDATE MESSENGER_TBL
      989. SET State = 'D'
      990. WHERE f_idPlayer = @im_idPlayer
      991. AND serverindex = @iserverindex
      995. /****************************************************************************************/
      996. /** 200506 event **/
      997. /****************************************************************************************/
      1000. -- if (not exists(select account from RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount)
      1001. -- and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12')
      1002. --
      1003. -- begin --: Of 1 or more month the account objective type writing which is not connection experience
      1004. -- declare @cash int,@get_cach int
      1005. -- select @cash = case when m_nLevel between 10 and 19 then 500
      1006. -- when m_nLevel between 20 and 39 then 1000
      1007. -- when m_nLevel between 40 and 49 then 1500
      1008. -- when m_nLevel between 50 and 59 then 2000
      1009. -- when m_nLevel between 60 and 69 then 2500
      1010. -- when m_nLevel >= 70 then 3000
      1011. -- else 0 end
      1012. -- from CHARACTER_TBL
      1013. -- where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
      1014. --
      1015. -- select @get_cach = isnull(sum(amount),0)
      1016. -- from RANKING_DBF.dbo.event_member_tbl
      1017. -- where account = @iaccount
      1018. -- group by account
      1019. --
      1020. -- if @cash + @get_cach > 5000
      1021. -- set @cash = 5000 - @get_cach
      1022. --
      1023. -- if @cash > 0
      1024. --
      1025. -- begin
      1026. -- declare @retcode int
      1027. --
      1028. -- if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount)
      1029. -- exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ',''
      1030. --
      1031. -- exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'Character compensation event',0,''
      1032. --
      1033. -- if @retcode <> 1
      1034. -- set @cash = 0
      1035. --
      1036. -- insert RANKING_DBF.dbo.event_member_tbl
      1037. -- (account,amount,m_idPlayer,serverindex,retcode,date)
      1038. -- values
      1039. -- (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate())
      1040. --
      1041. -- end
      1042. -- end
      1043. /****************************************************************************************/
      1044. /****************************************************************************************/
      1045. /****************************************************************************************/
      1048. -- The part which the box tries to close once in the class arctic regions #2 2007-03-21
      1049. IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
      1050. BEGIN
      1051. SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
      1052. RETURN
      1053. END
      1054. ELSE
      1055. BEGIN
      1056. SELECT fError = '0', fText = 'DELETE OK'
      1057. RETURN
      1058. END
      1061. END
      1062. END
      1063. ELSE
      1064. BEGIN
      1065. SELECT fError = '1', fText = 'Resident number error'
      1066. RETURN
      1067. END
      1069. -- At the price which is not eliminated unconditionally return
      1070. select fError = '1', fText = 'Resident number error'
      1071. END
      1072. /*
      1074. Character elimination
      1075. ex )
      1076. CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
      1077. CHARACTER_STR 'D1','001068','01','ata3k','1019311'
      1079. */
      1081. ELSE
      1082. IF @iGu = 'I1' -- Initially information input
      1083. BEGIN
      1084. IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
      1085. WHERE m_szName = @im_szName AND serverindex = @iserverindex)
      1086. BEGIN
      1087. SELECT fError = '0', fText = 'Character duplication!'
      1088. RETURN
      1089. END
      1090. ELSE
      1091. BEGIN
      1092. DECLARE
      1093. @om_idPlayer CHAR (7) ,
      1094. @om_vScale_x REAL ,
      1095. @om_dwMotion INT ,
      1096. @om_fAngle REAL ,
      1097. @om_nHitPoint INT ,
      1098. @om_nManaPoint INT ,
      1099. @om_nFatiguePoint INT ,
      1100. @om_dwRideItemIdx INT ,
      1101. @om_dwGold INT ,
      1102. @om_nJob INT ,
      1103. @om_pActMover VARCHAR(50) ,
      1104. @om_nStr INT ,
      1105. @om_nSta INT ,
      1106. @om_nDex INT ,
      1107. @om_nInt INT ,
      1108. @om_nLevel INT ,
      1110. @om_nExp1 BIGINT ,
      1111. @om_nExp2 BIGINT ,
      1112. @om_aJobSkill VARCHAR (500),
      1113. @om_aLicenseSkill VARCHAR (500),
      1114. @om_aJobLv VARCHAR (500),
      1115. @om_dwExpertLv INT ,
      1116. @om_idMarkingWorld INT ,
      1117. @om_vMarkingPos_x REAL ,
      1118. @om_vMarkingPos_y REAL ,
      1119. @om_vMarkingPos_z REAL ,
      1120. @om_nRemainGP INT ,
      1121. @om_nRemainLP INT ,
      1122. @om_nFlightLv INT ,
      1123. @om_nFxp INT ,
      1124. @om_nTxp INT ,
      1126. @om_lpQuestCntArray VARCHAR(1024),
      1127. @om_chAuthority CHAR(1) ,
      1128. @om_dwMode INT ,
      1129. @oblockby VARCHAR(32) ,
      1130. @oTotalPlayTime INT ,
      1131. @oisblock CHAR(1) ,
      1132. @oEnd_Time CHAR(12) ,
      1133. @om_Inventory VARCHAR(6940),
      1134. @om_apIndex VARCHAR(345) ,
      1135. @om_adwEquipment VARCHAR(135) ,
      1136. @om_aSlotApplet VARCHAR(3100),
      1137. @om_aSlotItem VARCHAR(6885),
      1138. @om_aSlotQueue VARCHAR(225),
      1139. @om_SkillBar SMALLINT,
      1140. @om_dwObjIndex VARCHAR(345) ,
      1141. @om_Card VARCHAR(1980),
      1142. @om_Cube VARCHAR(1980),
      1143. @om_apIndex_Card VARCHAR(215) ,
      1144. @om_dwObjIndex_Card VARCHAR(215) ,
      1145. @om_apIndex_Cube VARCHAR(215) ,
      1146. @om_dwObjIndex_Cube VARCHAR(215) ,
      1147. @om_idparty INT ,
      1148. --@om_nNumKill INT ,
      1149. @om_idMuerderer INT ,
      1150. --@om_nSlaughter INT ,
      1151. @om_nFame INT ,
      1152. @om_nDeathExp BIGINT ,
      1153. @om_nDeathLevel INT ,
      1154. @om_dwFlyTime INT ,
      1155. @om_nMessengerState INT ,
      1156. @om_Bank VARCHAR(4290),
      1157. @om_apIndex_Bank VARCHAR(215) ,
      1158. @om_dwObjIndex_Bank VARCHAR(215) ,
      1159. @om_dwGoldBank INT
      1161. IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE serverindex = @iserverindex)
      1162. SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
      1163. FROM CHARACTER_TBL
      1164. WHERE serverindex = @iserverindex
      1165. ELSE
      1166. SELECT @om_idPlayer = '0000001'
      1168. SELECT @om_vScale_x = m_vScale_x,
      1169. @om_dwMotion = m_dwMotion,
      1170. @om_fAngle = m_fAngle,
      1171. @om_nHitPoint = m_nHitPoint,
      1172. @om_nManaPoint = m_nManaPoint,
      1173. @om_nFatiguePoint = m_nFatiguePoint,
      1174. @om_dwRideItemIdx = m_dwRideItemIdx,
      1175. @om_dwGold = m_dwGold,
      1176. @om_nJob = m_nJob,
      1177. @om_pActMover = m_pActMover,
      1178. @om_nStr = m_nStr,
      1179. @om_nSta = m_nSta,
      1180. @om_nDex = m_nDex,
      1181. @om_nInt = m_nInt,
      1182. @om_nLevel = m_nLevel,
      1183. @om_nExp1 = m_nExp1,
      1184. @om_nExp2 = m_nExp2,
      1185. @om_aJobSkill = m_aJobSkill,
      1186. @om_aLicenseSkill = m_aLicenseSkill,
      1187. @om_aJobLv = m_aJobLv,
      1189. @om_dwExpertLv = m_dwExpertLv,
      1190. @om_idMarkingWorld = m_idMarkingWorld,
      1191. @om_vMarkingPos_x = m_vMarkingPos_x,
      1192. @om_vMarkingPos_y = m_vMarkingPos_y,
      1193. @om_vMarkingPos_z = m_vMarkingPos_z,
      1194. @om_nRemainGP = m_nRemainGP,
      1195. @om_nRemainLP = m_nRemainLP,
      1196. @om_nFlightLv = m_nFlightLv,
      1197. @om_nFxp = m_nFxp,
      1198. @om_nTxp = m_nTxp,
      1199. @om_lpQuestCntArray = m_lpQuestCntArray,
      1200. @om_chAuthority = m_chAuthority,
      1201. @om_dwMode = m_dwMode,
      1202. @oblockby = blockby,
      1203. @oTotalPlayTime = TotalPlayTime,
      1204. @oisblock = isblock,
      1205. @oEnd_Time = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
      1206. @om_Inventory = m_Inventory,
      1207. @om_apIndex = m_apIndex,
      1208. @om_adwEquipment = m_adwEquipment,
      1209. @om_aSlotApplet = m_aSlotApplet,
      1210. @om_aSlotItem = m_aSlotItem,
      1211. @om_aSlotQueue = m_aSlotQueue,
      1212. @om_SkillBar = m_SkillBar,
      1213. @om_dwObjIndex = m_dwObjIndex,
      1214. @om_Card = m_Card,
      1215. @om_Cube = m_Cube,
      1216. @om_apIndex_Card = m_apIndex_Card,
      1217. @om_dwObjIndex_Card = m_dwObjIndex_Card,
      1218. @om_apIndex_Cube = m_apIndex_Cube,
      1220. @om_dwObjIndex_Cube = m_dwObjIndex_Cube,
      1221. @om_idparty = m_idparty,
      1222. --@om_nNumKill = m_nNumKill,
      1223. @om_idMuerderer = m_idMuerderer,
      1224. --@om_nSlaughter = m_nSlaughter ,
      1225. @om_nFame = m_nFame,
      1226. @om_nDeathExp = m_nDeathExp,
      1227. @om_nDeathLevel = m_nDeathLevel,
      1228. @om_dwFlyTime = m_dwFlyTime,
      1229. @om_nMessengerState = m_nMessengerState,
      1230. @om_Bank = m_Bank,
      1231. @om_apIndex_Bank = m_apIndex_Bank,
      1232. @om_dwObjIndex_Bank = m_dwObjIndex_Bank,
      1233. @om_dwGoldBank = m_dwGoldBank
      1235. FROM BASE_VALUE_TBL
      1236. WHERE g_nSex = @im_dwSex
      1240. INSERT CHARACTER_TBL
      1241. (
      1242. m_idPlayer,
      1243. serverindex,
      1244. account,
      1245. m_szName,
      1246. playerslot,
      1247. dwWorldID,
      1248. m_dwIndex,
      1249. m_vScale_x,
      1250. m_dwMotion,
      1251. m_vPos_x,
      1253. m_vPos_y,
      1254. m_vPos_z,
      1255. m_fAngle,
      1256. m_szCharacterKey,
      1257. m_nHitPoint,
      1258. m_nManaPoint,
      1259. m_nFatiguePoint,
      1260. m_nFuel,
      1261. m_dwSkinSet,
      1262. m_dwHairMesh,
      1263. m_dwHairColor,
      1264. m_dwHeadMesh,
      1265. m_dwSex,
      1266. m_dwRideItemIdx,
      1267. m_dwGold,
      1268. m_nJob,
      1269. m_pActMover,
      1270. m_nStr,
      1271. m_nSta,
      1272. m_nDex,
      1273. m_nInt,
      1274. m_nLevel,
      1275. m_nMaximumLevel,
      1276. m_nExp1,
      1277. m_nExp2,
      1278. m_aJobSkill,
      1279. m_aLicenseSkill,
      1280. m_aJobLv,
      1281. m_dwExpertLv,
      1282. m_idMarkingWorld,
      1283. m_vMarkingPos_x,
      1284. m_vMarkingPos_y,
      1285. m_vMarkingPos_z,
      1286. m_nRemainGP,
      1287. m_nRemainLP,
      1288. m_nFlightLv,
      1289. m_nFxp,
      1290. m_nTxp,
      1291. m_lpQuestCntArray,
      1292. m_aCompleteQuest,
      1293. m_chAuthority,
      1294. m_dwMode,
      1295. m_idparty,
      1296. m_idCompany,
      1297. --m_nNumKill,
      1298. m_idMuerderer,
      1299. --m_nSlaughter,
      1300. m_nFame,
      1301. m_nDeathExp,
      1302. m_nDeathLevel,
      1304. m_dwFlyTime,
      1305. m_nMessengerState,
      1306. blockby,
      1307. TotalPlayTime,
      1308. isblock,
      1309. End_Time,
      1310. BlockTime,
      1311. CreateTime,
      1312. m_tmAccFuel,
      1313. m_tGuildMember,
      1314. m_dwSkillPoint,
      1315. m_dwReturnWorldID,
      1316. m_vReturnPos_x,
      1317. m_vReturnPos_y,
      1318. m_vReturnPos_z
      1319. )
      1320. VALUES
      1321. (
      1322. @om_idPlayer,
      1323. @iserverindex,
      1324. @iaccount,
      1325. @im_szName,
      1326. @iplayerslot,
      1327. @idwWorldID,
      1328. @im_dwIndex,
      1329. '1',
      1331. '0',
      1332. @im_vPos_x,
      1333. @im_vPos_y,
      1334. @im_vPos_z,
      1335. '0',
      1336. @im_szCharacterKey,
      1337. '230',
      1338. '63',
      1339. '32',
      1340. -1, --m_nFuel
      1341. @im_dwSkinSet,
      1342. @im_dwHairMesh,
      1343. @im_dwHairColor,
      1344. @im_dwHeadMesh,
      1345. @im_dwSex,
      1346. '0',
      1347. '0',
      1348. '0',
      1349. '1,0',
      1350. '15',
      1351. '15',
      1352. '15',
      1353. '15',
      1354. '1',
      1355. '1', --m_nMaximumLevel
      1356. '0',
      1357. '0',
      1358. '',
      1359. '',
      1360. '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$',
      1361. '0',
      1362. '0',
      1363. '0',
      1364. '0',
      1365. '0',
      1366. '0',
      1367. '0',
      1368. '0',
      1369. '0',
      1370. '0',
      1371. '$',
      1372. '$', -- m_aCompleteQuest
      1373. 'F',
      1374. '131072',
      1375. '0',
      1376. '0', -- m_idCompany
      1377. --@om_nNumKill,
      1378. '0',
      1379. --@om_nSlaughter,
      1380. '0',
      1381. '0',
      1382. '0',
      1383. '0' ,
      1384. '0',
      1385. @oblockby,
      1386. '0',
      1387. 'F',
      1388. '200811030000',
      1389. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
      1390. GETDATE(),
      1391. 0,
      1392. CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
      1393. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
      1394. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
      1395. + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
      1396. 0, --m_dwSkillPoint
      1397. 1,
      1398. 0,
      1399. 0,
      1400. 0
      1401. )
      1402. declare @invi1 VARCHAR(8000)
      1403. declare @invi2 VARCHAR(8000)
      1404. declare @invi3 VARCHAR(8000)
      1405. declare @invi4 VARCHAR(8000)
      1407. IF @im_dwSex = '1'
      1408. BEGIN
      1409. SET @invi1 = '0,512,0,0,,1,0,4500000,0,0,0,-1118993182,0,0,0,0,0/1,504,0,0,,1,0,9000000,0,0,0,946307614,0,0,0,0,0/42,508,0,0,,1,0,5850000,0,0,0,750110947,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/$'
      1410. SET @invi2 = '45/43/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/42/0/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      1411. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      1412. SET @invi4 = '47/44/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/46/1/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      1413. END
      1414. ELSE
      1415. BEGIN
      1416. SET @invi1 = '0,506,0,0,,1,0,5850000,0,0,0,-2005860201,0,0,0,0,0/1,502,0,0,,1,0,9000000,0,0,0,688242964,0,0,0,0,0/2,510,0,0,,1,0,4500000,0,0,0,583094601,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,-2111939376,0,0,0,0,0/$'
      1417. SET @invi2 = '45/42/43/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/-1/-1/1/-1/0/2/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      1418. SET @invi3 = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$'
      1419. SET @invi4 = '46/44/47/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/1/2/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$'
      1420. END
      1422. INSERT INVENTORY_TBL
      1423. (
      1424. m_idPlayer,
      1425. serverindex,
      1426. m_Inventory,
      1427. m_apIndex,
      1428. m_adwEquipment,
      1429. m_dwObjIndex
      1430. )
      1431. VALUES
      1432. (
      1433. @om_idPlayer,
      1434. @iserverindex,
      1435. @invi1,
      1436. @invi2,
      1437. @invi3,
      1438. @invi4
      1439. )
      1442. IF @@SERVERNAME = 'WEB' OR @@SERVERNAME = 'SERVER4'
      1443. SET @om_aSlotApplet = '0,2,400,0,0,0,0/1,2,398,0,1,0,0/2,2,2010,0,2,0,0/3,2,1005,0,3,0,0/4,3,25,0,4,0,0/$'
      1445. INSERT TASKBAR_TBL
      1446. (
      1447. m_idPlayer,
      1448. serverindex,
      1449. m_aSlotApplet,
      1450. m_aSlotQueue,
      1451. m_SkillBar
      1453. )
      1454. VALUES
      1455. (
      1456. @om_idPlayer,
      1457. @iserverindex,
      1458. '$',
      1459. '$',
      1460. '100'
      1461. )
      1464. INSERT TASKBAR_ITEM_TBL
      1465. (
      1466. m_idPlayer,
      1467. serverindex,
      1468. m_aSlotItem
      1469. )
      1471. VALUES
      1472. (
      1473. @om_idPlayer,
      1474. @iserverindex,
      1475. '$'
      1476. )
      1478. INSERT BANK_TBL
      1479. (
      1480. m_idPlayer,
      1481. serverindex,
      1482. m_Bank,
      1483. m_BankPw,
      1484. m_apIndex_Bank,
      1485. m_dwObjIndex_Bank ,
      1486. m_dwGoldBank
      1487. )
      1488. VALUES
      1489. (
      1490. @om_idPlayer,
      1491. @iserverindex,
      1492. '$',
      1493. '0000', -- m_BankPw
      1494. '$',
      1495. '$',
      1496. '0'
      1497. )
      1499. INSERT SKILLINFLUENCE_TBL
      1500. (
      1501. m_idPlayer,
      1502. serverindex,
      1503. SkillInfluence
      1504. )
      1505. VALUES
      1506. (
      1507. @om_idPlayer,
      1508. @iserverindex,
      1509. '$'
      1510. )
      1512. INSERT INVENTORY_EXT_TBL
      1513. (
      1514. m_idPlayer,
      1515. serverindex,
      1516. m_extInventory,
      1517. m_InventoryPiercing,
      1518. szInventoryPet
      1519. )
      1520. VALUES
      1521. (
      1522. @om_idPlayer,
      1523. @iserverindex,
      1524. '$','$','$'
      1525. )
      1527. INSERT BANK_EXT_TBL
      1528. (
      1529. m_idPlayer,
      1530. serverindex,
      1531. m_extBank,
      1532. m_BankPiercing,
      1533. szBankPet
      1534. )
      1535. VALUES
      1536. (
      1537. @om_idPlayer,
      1538. @iserverindex,
      1539. '$','$','$'
      1540. )
      1542. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
      1543. VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
      1544. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
      1545. VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
      1546. INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
      1547. VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)
      1549. ------------ Ver11 Pocket
      1550. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
      1551. VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )
      1553. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
      1554. VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )
      1556. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
      1557. VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )
      1559. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
      1560. VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )
      1562. INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
      1563. VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )
      1565. INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
      1566. VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )
      1568. -------------- Ver13 Honor
      1569. INSERT HONOR_MASTER_TBL ( serverindex, m_idPlayer, sec,c01,c02,c03,c04,c05,c06,c07,c08,c09,c10,c11,c12,c13,c14,c15,c16,c17,c18,c19,c20,c21,c22,c23,c24,c25,c26,c27,c28,c29,c30,c31,c32,c33,c34,c35,c36,c37,c38,c39,c40,c41,c42,c43,c44,c45,c46,c47,c48,c49,c50)
      1570. VALUES ( @iserverindex, @om_idPlayer, 1, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
      1573. /*
      1574. 2007-06-21 ~ 2007-07-18 New character item urgent event
      1575. */
      1576. declare @ntime datetime
      1577. select @ntime = getdate()
      1579. if(@ntime >= '2007-06-21 00:00:00.000' and @ntime <= '2007-07-18 23:59:59.999')
      1580. begin
      1581. declare @etime bigint
      1582. select @etime = cast(replace(replace(replace(convert(char(16), dateadd(d, 7, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
      1584. if(@im_dwSex = 0)
      1585. begin
      1586. insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
      1587. select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
      1589. insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
      1590. select @om_idPlayer, @iserverindex, '15200', 1, @etime, '0000000'
      1592. end
      1593. if(@im_dwSex = 1)
      1594. begin
      1595. insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
      1596. select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
      1598. insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
      1599. select @om_idPlayer, @iserverindex, '15202', 1, @etime, '0000000'
      1601. end
      1602. end
      1604. SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
      1605. RETURN
      1606. END
      1607. END
      1609. set nocount off
      1610. RETURN
      1614. GO
      Alles anzeigen