Zitat von Cr4zy1996;98527[FONT="Comic Sans MS"][COLOR="Blue"][SIZE="2"]hier:
[/SIZE][/COLOR][/FONT]
2010/ 3/22 21:12:02 CItemBase::SetTexture GetProp() NULL Return [COLOR="DeepSkyBlue"]30593[/COLOR]
Dein Client hat dieses Item nicht, blah....
Zitat von Cr4zy1996;98527[FONT="Comic Sans MS"][COLOR="Blue"][SIZE="2"]hier:
[/SIZE][/COLOR][/FONT]
2010/ 3/22 21:12:02 CItemBase::SetTexture GetProp() NULL Return [COLOR="DeepSkyBlue"]30593[/COLOR]
Dein Client hat dieses Item nicht, blah....
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
[FONT="Arial Black"][COLOR="White"][SIZE="3"]
Zitat von Tenshi;98570Hay 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]
ZitatAlles anzeigenZitat 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_SKINSetImage
(
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 dauernSchä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 ?
@ Etzel
Leider nicht, in der 1on1.lua steht nur die Formel wie viele man bekommt, jedoch steht nirgents was man bekommt. =/
[FONT="Comic Sans MS"][COLOR="Wheat"]Minimal Take this :
#ifndef __DEFINE_NEUZ
#define __DEFINE_NEUZ
#define AII_NONE 0
#define AII_MOVER 1
#define AII_MONSTER 2
#define AII_HUMAN 3
#define AII_CLOCKWORKS 4
#define AII_PET 5
#define AII_BIGMUSCLE 6
#define AII_KRRR 7
#define AII_BEAR 8
#define AII_EGG 9
#define AII_METEONYKER 10
#define AII_VER2_TYPE0 100
// group ±×·ì ¼³Á¤
#define GRP_ALL 0
#define GRP_SOLO 1
#define GRP_PARTY 2
#define GRP_GUILD 3
#define PARTS_HEAD 0 // Àåºñ¿¡¼* Á¦¿Ü
#define PARTS_HAIR 1 // Àåºñ¿¡¼* Á¦¿Ü
#define PARTS_UPPER_BODY 2
#define PARTS_LOWER_BODY 3
#define PARTS_HAND 4
#define PARTS_FOOT 5
#define PARTS_CAP 6
#define PARTS_ROBE 7
#define PARTS_CLOAK 8
#define PARTS_LWEAPON 9
#define PARTS_RWEAPON 10
#define PARTS_SHIELD 11
#define PARTS_MASK 12
#define PARTS_RIDE 13 // Àåºñ¿¡¼* Á¦¿Ü - ÀÌ°Ç 16¹ø ÀÌÈÄ·Î °¡¾ßÇϴ°ǵ¥ ÄÁ¹öÆ®¸¦ ÇØ¾ßÇϱⶫ½Ã ÀÌ´ë·Î ÇØ°áÇß´Ù.
// ¿©±â±îÁö µ¿½Ã Ãâ·Â ÆÄÃ÷
// 16ÀÌ»óÀ¸·Î ¼öÄ¡¸¦ ´ÃÀÌ·Á¸é xuzhu¿¡°Ô ²À ¾ê±âÇÒ°Í. ¾È±×·¯¸é ¿¡·¯³².
#define PARTS_CAP2 14 // Àåºñ¿¡¼* Á¦¿Ü
#define PARTS_UPPER2 15 // Àåºñ¿¡¼* Á¦¿Ü
// ½ÇÁ¦ È*¸é»ó¿¡¼* ·»´õ¸µµÇÁö ¾Ê´Â ÆÄÃ÷´Â 16¹ø ÀÌ»óÀ» ¾´´Ù. ±Í°ÉÀÌ,¹ÝÁö °°Àº°Íµé.
#define PARTS_LOWER2 16
#define PARTS_HAND2 17
#define PARTS_FOOT2 18
// ¿©±â±îÁö ÀåÂøÀº ÇÏÁö¸¸ À̰ÍÀ» ÀåÂøÇϹǷμ* ´Ù¸¥ ÆÄÃ÷°¡ ´«¿¡ ¾Èº¸ÀÌ°Ô ÇÑ´Ù.(ÀͽºÅ©·ç½Ãºê¶ûÀº ´Ù¸£´Ù.)
#define PARTS_NECKLACE1 19 // ¸ñ°ÉÀÌ
#define PARTS_RING1 20 // ¹ÝÁö
#define PARTS_RING2 21
#define PARTS_EARRING1 22 // ±Í°ÉÀÌ
#define PARTS_EARRING2 23
#define PARTS_PROPERTY 24 //¸ñ°ÉÀÌ, ¹ÝÁö, ±Í°ÉÀ̸¦ Á¦¿ÜÇÑ ¼Òµµ±¸µéÀ» Âø¿ëÇÒ °ø°£
#define PARTS_BULLET 25 //°¢Á¾ÃÑ¾Ë ½½·Ô
#define PARTS_HAT 26 // ÆÐ¼Ç¾ÆÅÛ ¸ðÀÚ
#define PARTS_CLOTH 27 // ÆÐ¼Ç ÀÇ»ó
#define PARTS_GLOVE 28 // ÆÐ¼Ç Àå°©
#define PARTS_BOOTS 29 // ÆÐ¼Ç ºÎÃ÷
#define PARTS_CLOAK2 30 // ÆÐ¼Ç ¸ÁÅä
#define MAX_HUMAN_PARTS 31
// Structure Type
#define SRT_NONE 0
#define SRT_LODESTAR 1
#define SRT_LODELOGHT 2
#define SRT_STATION 3
#define SRT_WEAPON 4
#define SRT_SHIELD 5
#define SRT_FOOD 6
#define SRT_MAGIC 7
#define SRT_GENERAL 8
#define SRT_PUBLICOFFICE 9
#define SRT_QUESTOFFICE 10
#define SRT_DUNGEON 11
#define SRT_BUCKLER 12
#define SRT_WARPZONE 13
#define MAX_STRUCTURE 20
// Äù½ºÆ® ½ºÅ×ÀÌÆ®
#define QS_BEGIN 0
// ÁÖÀÇ!! ÀÌ ºÎºÐ¿¡ Ãß°¡ÇÒ ¶§´Â ÇØ´ç ÅØ½ºÆ®µµ ÀÔ·ÂÇØ¾ßÇÔ.
// ÅØ½ºÆ®´Â defineText.h¿Í texClient.txt¸¦ ¼öÁ¤ÇؾßÇÔ.
// defineText.hÀÇ ¼ø¼*¿Í MMIÀÇ ¼ø¼*°¡ ÀÏÄ¡ÇØ¾ßÇÔ.
#define MMI_DIALOG 0 // "´ëÈ*" ),
#define MMI_QUEST 1 // Äù½ºÆ®
#define MMI_TRADE 2 // "°Å·¡" ),
#define MMI_FIGHT 3 // "´ëÀü" ),
#define MMI_MESSAGE 4 // "¸Þ½ÃÁö" ),
#define MMI_ADD_MESSENGER 5 // "¸Þ½ÅÀú Ãß°¡" ),
#define MMI_INVITE_PARTY 6 // "ÆÄƼ Âü¿©" )
#define MMI_INVITE_COMPANY 7 // "ÆÄƼ Âü¿©" )
#define MMI_MARKING 8 // "Àå¼Ò ÁöÁ¤" )
#define MMI_BANKING 9 // "ÀºÇà
#define MMI_DUEL 10 // µà¾ó½Åû
#define MMI_DUEL_PARTY 11 // ÆÄƼ µà¾ó.
#define MMI_TRACE 12 // °³Àΰŷ¡
#define MMI_BEAUTYSHOP 13 // ºäƼ¼¥
#define MMI_REPAIR 14 // ¼ö¸®Ã¢
#define MMI_GUILDBANKING 15 // ±æµåâ°í
#define MMI_RANK_GUILD 16 // ±æµå ·©Å·
#define MMI_RANK_WAR 17 // ±æµåÀü½ÂÆÐ ·©Å·
#define MMI_RANK_INFO 18 // ±æµå±âŸ ·©Å·
#define MMI_UPGRADE 19 // Àç·Ãâ
#define MMI_CHANGEELEM 20 // ¼Ó¼º º¯°æ
#define MMI_INPUT_REWARD 21 // Çö»ó±Ý °É±â
#define MMI_SHOW_REWARD 22 // Çö»ó±Ý º¸±â
#define MMI_PIERCING 23
#define MMI_QUERYEQUIP 24
#define MMI_POST 25
#define MMI_GUILDWAR_APP 26
#define MMI_GUILDWAR_STATE 27
#define MMI_GUILDWAR_CANCEL 28
#define MMI_GUILDWAR_JOIN 29
#define MMI_GUILDCOMBAT_RANKING 30
#define MMI_CHEER 31
#define MMI_PIERCING_REMOVE 32
#define MMI_GUILDCOMBAT_SELECTION 33
#define MMI_GUILDCOMBAT_JACKPOT 34
#define MMI_GUILDCOMBAT_JACKPOT2 35
#define MMI_GUILDCOMBAT_BESTPLAYER 36
#define MMI_GUILDCOMBAT_INFO_BOARD1 37
#define MMI_GUILDCOMBAT_INFO_BOARD2 38
#define MMI_GUILDCOMBAT_INFO_BOARD3 39
#define MMI_GUILDCOMBAT_INFO_TEX 40
#define MMI_GUILDCOMBAT_PENYA_RETURN 41
#define MMI_BEAUTYSHOP_SKIN 42 // ¼ºÇü¼ö¼ú
#define MMI_SUMMON_ANGEL 43 // ¿£Á©¼Òȯ
#define MMI_KAWIBAWIBO 44 //°¡À§¹ÙÀ§º¸ °ÔÀÓ
#define MMI_FINDWORD 45 //´Ü¾î¸ÂÃ߱⠰ÔÀÓ
#define MMI_FIVESYSTEM 46 //¿À°ö(ÁÖ»çÀ§) °ÔÀÓ
#define MMI_REASSEMBLE 47 //ÆÛÁñ °ÔÀÓ
#define MMI_PET_FEED 48 //Æê ¸ÔÀÌ ÁÖ±â
#define MMI_PET_STATUS 49 //Æê »óÅÂ
#define MMI_PET_RELEASE 50 //Æê ÇØÁ¦
#define MMI_SMELT_MIXJEWEL 51 //Á¦·Ã : ¿À¸®Ä®Äñ, ¹®½ºÅæ ÇÕ¼º
#define MMI_SMELT_JEWEL 52 //Á¦·Ã : ¾óÅÍ¸Ú ¾ÆÀÌÅÛ º¸¼® Á¦·Ã
#define MMI_SMELT_EXTRACTION 53 //Á¦·Ã : º¸¼®ÃßÃâ
#define MMI_SMELT_CHANGEGWEAPON 54 //Á¦·Ã : ¹«±â º¯°æ (ÀÏ¹Ý -> À¯´ÏÅ©)
#define MMI_SMELT_CHANGEUWEAPON 55 //Á¦·Ã : ¹«±â º¯°æ (À¯´ÏÅ© -> ¾óÅ͸Ú)
#define MMI_LEGEND_SKILLUP 56 //¿µ¿õ ½ºÅ³¾÷
#define MMI_EVENT_MAY 57 //5¿ù À̺¥Æ® - ÇູÇÑ °¡Á¤ÀÇ ´Þ ¸¸µé±â ´ë ÀÛÀü
#define MMI_PET_FOODMILL 58
#define MMI_ATTRIBUTE 59
#define MMI_GUILDCOMBAT_1TO1_OFFER 60 // 1:1±æµå´ëÀü ½ÅûÇϱâ
#define MMI_GUILDCOMBAT_1TO1_CANCEL 61 // 1:1±æµå´ëÀü Ãë¼ÒÇϱâ
#define MMI_GUILDCOMBAT_1TO1_OFFERSTATE 62 // 1:1±æµå´ëÀü ½ÅûÇöȲ
#define MMI_GUILDCOMBAT_1TO1_SELECTION 63 // 1:1±æµå´ëÀü Âü°¡ÀÚ ±¸¼º
#define MMI_GUILDCOMBAT_1TO1_ENTRANCE 64 // 1:1±æµå´ëÀü ÀÔÀå
#define MMI_GUILDCOMBAT_1TO1_GUIDE_TEX 65 // 1:1±æµå´ëÀü ¼ö¼ö·á ¾È³»
#define MMI_GUILDCOMBAT_1TO1_GUIDE_PRIZE 66 // 1:1±æµå´ëÀü »ó±Ý&»óǰ ¾È³»
#define MMI_GUILDCOMBAT_1TO1_GUIDE_ENTRY 67 // 1:1±æµå´ëÀü Âü°¡ ¾È³»
#define MMI_GUILDCOMBAT_1TO1_GUIDE_RULE 68 // 1:1±æµå´ëÀü ±ÔÄ¢ ¾È³»
#define MMI_GUILDCOMBAT_1TO1_GUIDE_WIN 69 // 1:1±æµå´ëÀü ½Â¸®Á¶°Ç ¾È³»
#define MMI_GUILDCOMBAT_1TO1_REPAYMENT 70 // 1:1±æµå´ëÀü ½Åû±Ý ¹Ýȯ
#define MMI_LVREQDOWN_CANCEL 71 // Âø¿ë·¹º§ Ç϶ô ÇØÁö ¸Þ´º
#define MMI_SMELT_REMOVE_PIERCING 72 // ½´Æ®ÀÇ ÇǾî½Ì ¿É¼Ç Á¦°Å
#define MMI_ITEM_AWAKENING 73 // ¾ÆÀÌÅÛ °¢¼º ¸Þ´º
#define MMI_NPC_BUFF 74 // NPCÇÑÅ× Buff¹Þ±â
#define MMI_COLLECT01 75 // ÀÏ¹Ý Á¶°¢ ±³È¯
#define MMI_COLLECT02 76 // Ä«µå Á¶°¢ ±³È¯
#define MMI_PET_RES 77 // ÆêÀ» ºÎȰÀÇ Á¶°¢À¸·Î ±³È¯
#define MMI_PET_RES01 78 // ºÎȰÀÇ Á¶°¢À» µÎ·ç¸¶¸®·Î ±³È¯
#define MMI_BLESSING_CANCEL 79 // ¿©½ÅÀÇ Ãູ Ãë¼Ò
#define MMI_ARENA_ENTER 80
#define MMI_ARENA_EXIT 81
#define MMI_EVENT_HAPPY_TWN 82
#define MMI_EVENT_HAPPY_USA 83
#define MMI_SECRET_OFFER 84 // ºñ¹ÐÀÇ ¹æ ½Åû
#define MMI_SECRET_OFFERSTATE 85 // ºñ¹ÐÀÇ ¹æ ½ÅûÇöȲ
#define MMI_SECRET_SELECTION 86 // ºñ¹ÐÀÇ ¹æ Âü°¡ÀÚ ±¸¼º
#define MMI_SECRET_ENTRANCE 87 // ºñ¹ÐÀÇ ¹æ ÀÔÀå
#define MMI_SECRET_TAXRATES_CHANGE 88 // ¼¼À² º¯°æ â
#define MMI_SECRET_TAXRATES_CHECK 89 // ¼¼À² È®ÀΠâ
#define MMI_SECRET_BOARD 90 // ºñ¹ÐÀÇ ¹æ ¾È³»
#define MMI_LORD_STATE 91 // ±ºÁÖ Èĺ¸ »óÅÂâ
#define MMI_LORD_TENDER 92 // ±ºÁÖ ÀÔÂû â
#define MMI_LORD_VOTE 93 // ±ºÁÖ ÅõÇ¥ â
#define MMI_LORD_EVENT 94 // ±ºÁÖ À̺¥Æ® â
#define MMI_SMELT_REMOVE_JEWEL 95 // ¾óÅÍ¸Ú ¿þÆù º¸¼® Á¦°Å â
#define MMI_PET_EGG01 96 // ¾Ë º¯È¯ â
#define MMI_HEAVEN_TOWER 97 // ½É¿¬ÀÇ Å¾
#define MMI_EXCHANGE_WEAPONCARD 98 // ¹«±â Ä«µå ±³È¯
#define MMI_EXCHANGE_ARMORCARD 99 // ¹æ¾î±¸ Ä«µå ±³È¯
#define MMI_SECRET_ENTRANCE_1 100 // Àü¿ë »ç³ÉÅÍ ÀÔÀå
#define MMI_LORD_INFO 101 // ±ºÁÖ Á¤º¸Ã¢
#define MMI_LORD_RPINFO 102 // ±ºÁÖ ¹Ýȯ±Ý Á¤º¸Ã¢
#define MMI_SECRET_CANCEL 103 // ºñ¹ÐÀÇ ¹æ Ãë¼Ò
#define MMI_PET_AWAK_CANCEL 104 // Æê°¢¼º Ãë¼Ò
#define MMI_FASHION_PHP 105 // ÆÐ¼Ç ÄíÆù À̺¥Æ®
#define MMI_EVENT_CARD_KOR 106 // ±¹³» Ä«µå ±³È¯ À̺¥Æ®
#define MMI_LORD_RAINBOWAPPLICATION 107 // ·¹Àκ¸¿ì ·¹À̽º Âü°¡ ½Åû
#define MMI_LORD_RAINBOWWAIT 108 // ·¹Àκ¸¿ì ·¹À̽º ¶õ?
#define MMI_LORD_RAINBOWRULE 109 // ·¹Àκ¸¿ì ·¹À̽ºÀÇ ±ÔÄ¢
#define MMI_LORD_RAINBOWTOPTEN 110 // ·¹Àκ¸¿ì ·¹À̽º Áö³* ¼øÀ§
#define MMI_LORD_RAINBOWWIN 111 // ·¹Àκ¸¿ì ·¹À̽º »ó±Ý ¼Ò°³
#define MMI_LORD_RAINBOWEND 112 // ·¹Àκ¸¿ì ·¹À̽º Á¾·á È®ÀÎ
#define MMI_LORD_RAINBOW_KAWIBAWIBO 113 // ·¹Àκ¸¿ì ·¹À̽º - °¡À§,¹ÙÀ§,º¸ °ÔÀÓ
#define MMI_LORD_RAINBOW_DICE 114 // ·¹Àκ¸¿ì ·¹À̽º - ÁÖ»çÀ§ ±¼·Á! ±¼·Á!
#define MMI_LORD_RAINBOW_ARITHMETIC 115 // ·¹Àκ¸¿ì ·¹À̽º - »çÄ¢¿¬»ê
#define MMI_LORD_RAINBOW_STOPWATCH 116 // ·¹Àκ¸¿ì ·¹À̽º - ½ºÅé¿öÄ¡ ¼ø¹ß·Â °ÔÀÓ
#define MMI_LORD_RAINBOW_TYPING 117 // ·¹Àκ¸¿ì ·¹À̽º - Ȳ´ç ŸÀÚ Ä¡±â
#define MMI_LORD_RAINBOW_CARD 118 // ·¹Àκ¸¿ì ·¹À̽º - ±â¾ïÇØ! Ä«µå ¸ÂÃß±â
#define MMI_LORD_RAINBOW_LADDER 119 // ·¹Àκ¸¿ì ·¹À̽º - ¾Ë ¼ö ¾ø´Â »ç´Ù¸® Ÿ±â
#define MMI_RENAME_CANCEL 120 // Æê ÀÛ¸í Ãë¼Ò
#define MMI_EVENT_TRADE_KOR 121 //°¡À§ ¹ÙÀ§ º¸ ÄíÆù ±³È¯
#define MMI_VISIT_MYROOM 122 // ¸¶ÀÌ·ë °¡±â
#define MMI_VISIT_FRIEND 123 // Ä£±¸¹æ °¡±â
#define MMI_RETURNTO_WORLD 124 // ¸¶ÀÌ·ë¿¡¼* ¿ùµå·Î ±Íȯ
#define MMI_EVENT_RESTATE01 125 // ¸®½ºÅׯ® ÄíÆù ±³È¯
#define MMI_ITEM_TRANSY 126 // ¾ÆÀÌÅÛ Æ®·»Áö
#define MMI_EVENT_FIRSTTERM01 127 // »õÇбâ À̺¥Æ®
#define MMI_EVENT_ALICE01 128 // ±¹³» Ȱ¼ºÈ* À̺¥Æ®
#define MMI_EVENT_OASIS01 129 // ´Þ·Á¶ó ¿îµ¿È¸
#define MMI_EVENT_FLOWER01 130 // »ç¶ûÀÇ Ä«³×À̼Ç
#define MMI_EVENT_ALICE02 131 // ÀϺ», ´ë¸¸, È«Äá º½À̺¥Æ®
#define MMI_EVENT_TRADE_USA 132 // ¹Ì±¹ °¡À§¹ÙÀ§º¸ ÄíÆù ±³È¯
#define MMI_EVENT_TRADE_ASIA 133 // È«Äá, ´ë¸¸ °¡À§¹ÙÀ§º¸ ÄíÆù ±³È¯
#define MMI_SMELT_SAFETY_GENERAL 134 // ¾ÈÀüÁ¦·Ã(ÀϹÝ)
#define MMI_SMELT_SAFETY_ACCESSORY 135 // ¾ÈÀüÁ¦·Ã(¾×¼¼¼*¸®)
#define MMI_SMELT_SAFETY_PIERCING 136 // ¾ÈÀüÁ¦·Ã(ÇǾî½Ì)
#define MMI_QUIZ_ENTRANCE 137 // ÄûÁîÀ̺¥Æ® ÀÔÀå
#define MMI_QUIZ_TELE_QUIZZONE 138 // ´ë±âÁ¸¿¡¼* ÄûÁîÁ¸À¸·Î À̵¿
#define MMI_QUIZ_EXIT 139 // ´ë±âÁ¸¿¡¼* ¸¶À»·Î À̵¿
#define MMI_CHANGTICKET01 140 // ÀϺ» ·Î»ç»Í À̺¥Æ®
#define MMI_BUFFPET_STATUS 141 // ¹öÇÁÆê »óÅÂ
#define MMI_BUFFPET_RELEASE 142 // ¹öÇÁÆê ÇØÁ¦
#define MMI_GHOUSE_INFO 143 // °¡±¸ Á¤º¸
#define MMI_GHOUSE_REINSTALL 144 // °¡±¸ À缳ġ
#define MMI_GHOUSE_RECALL 145 // °¡±¸ ȸ¼ö
#define MMI_TELEPORTER 146 // ÅÚ·¹Æ÷ÅÍ
#define MMI_GUILDHOUSE_SALE 147 // ±æµåÇϿ콺 ÆÇ¸Å NPC
#define MMI_GUILDHOUSE_CHARGE 148 // ±æµåÇϿ콺 À¯Áöºñ
#define MMI_GUILDHOUSE_ENTER 149 // ±æµåÇϿ콺 ÀÔÀå
#define MMI_GUILDHOUSE_OUT 150 // ±æµåÇϿ콺 ÅðÀå
#define MMI_INVITE_CAMPUS 151 // »çÁ¦ ¸Î±â
#define MMI_REMOVE_CAMPUS 152 // »çÁ¦ ²÷±â
#define MMI_CHANGE_CHRISTMAS01 153
#define MMI_GHOUSE_BED 154
#define MMI_GHOUSE_TABLE 155
#define MMI_GHOUSE_SOFA 156
#define MMI_GHOUSE_DESK 157
#define MMI_GHOUSE_CHAIR 158
#define MMI_GHOUSE_CASE 159
#define MMI_GHOUSE_CLOSET 160
#define MMI_GHOUSE_WARDROBE 161
#define MMI_GHOUSE_BATH 162
#define MMI_GHOUSE_DRAWER 163
#define MMI_GHOUSE_CARPET 164
#define MMI_GHOUSE_WALLPAPER 165
#define MAX_MOVER_MENU 166 // MMI¸¦ Ãß°¡½Ãų ÀÏÀÌ ÀÖ´Ù¸é ÀÌ ¼öÄ¡¸¦ »ó½Â½ÃÄÑ¾ß ÇÑ´Ù.
#define MGI_APPELL_UP 0 // ȣĪ ¾÷
#define MGI_APPELL_DOWN 1
#define MGI_CLASS_UP 2 // µî±Þ ¾÷
#define MGI_CLASS_DOWN 3
#define MGI_GUILD_LEAVE 4 // Å»Åð
#define MGI_NICKNAME 5 // º°Äª ºÎ¿©.
#define MGI_CHG_MASTER 6 // ±æµå¸¶½ºÅÍ º¯°æ
#define MGI_GUILD_MENU 7
// ¸ð¼Ç°ú ¾×¼Ç
#define MOT_BASE_NONE 0
#define MOT_BASE_BATTLE 1
#define MOT_BASE_SIT 2
#define MOT_BASE_PICKUP 3
#define MOT_BASE_HANDSHAKE 4
#define MOT_BASE_AMBIGUOUS 5
#define MOT_BASE_YES 6
#define MOT_BASE_NO 7
#define MOT_BASE_SPRINT 8
#define MOT_BASE_PARADEREST 9
#define MOT_BASE_ATTENTION 10
#define MOT_BASE_SCISSORS 11
#define MOT_BASE_ROCK 12
#define MOT_BASE_PAPER 13
#define MOT_BASE_POINTWAYNORTH 14
#define MOT_BASE_POINTWAYSOUTH 15
#define MOT_BASE_POINTWAYEAST 16
#define MOT_BASE_POINTWAYWEST 17
#define MOT_BASE_KNEEDOWN 18
#define MOT_BASE_PUSHUP 19
#define MOT_BASE_HIPKIDDING 20
#define MOT_BASE_JAB 21
#define MOT_BASE_HEAD 22
#define MOT_BASE_RISESWORD 23
#define MOT_BASE_COLLECT 24
#define MOT_BASE_ESCAPE 25
#define MOT_BASE_CHEER 26
#define MOT_BASE_AUTOATTACK 27
#define MOT_BASE_COUPLE 28
// ÀÏ¹Ý µ¿ÀÛ
#define MTI_STAND 0
#define MTI_IDLE1 1
#define MTI_IDLE2 2
#define MTI_WALK 3
#define MTI_BACK 4
#define MTI_RUN 5
#define MTI_DMG1 6
#define MTI_DMG2 7
#define MTI_DIE1 8
#define MTI_DMGLIVE 9
#define MTI_DMGDIE 10
#define MTI_DMGFLY 11
#define MTI_GROGGY 12
#define MTI_JUMP1 13
#define MTI_JUMP2 14
#define MTI_JUMP3 15
#define MTI_JUMP4 16
#define MTI_IN 17
#define MTI_OUT 18
#define MTI_SWIM 19
#define MTI_SIT 20
#define MTI_SITSTAND 21
#define MTI_GETUP 22
#define MTI_ATK1 23
#define MTI_ATK2 24
#define MTI_ATK3 25
#define MTI_ATK4 26
#define MTI_ATK5 27
#define MTI_ATK6 28
#define MTI_ATK7 29
#define MTI_ATK8 30
#define MTI_FSTAND1_A 31
#define MTI_FIDLE1_A 32 //
#define MTI_FIDLE2_A 33 //
#define MTI_FLTURN1_A 34
#define MTI_FLTURN2_A 35 //
#define MTI_FRTURN1_A 36
#define MTI_FRTURN2_A 37 //
#define MTI_FRUNNING1_A 38 //
#define MTI_FRUNNING2_A 39 ///
#define MTI_FDMG1_A 40
#define MTI_FATK1_A 41
#define MTI_FATK2_A 42
#define MTI_FATK3_A 43
#define MTI_FSTAND1_B 61
#define MTI_FIDLE1_B 62 //
#define MTI_FIDLE2_B 63 //
#define MTI_FLTURN1_B 64
#define MTI_FLTURN2_B 65 //
#define MTI_FRTURN1_B 66
#define MTI_FRTURN2_B 67 //
#define MTI_FRUNNING1_B 68 //
#define MTI_FRUNNING2_B 69 ///
#define MTI_FDMG1_B 70
#define MTI_FATK1_B 71
#define MTI_FATK2_B 72
#define MTI_FATK3_B 73
#define MTI_FSTAND1_C 91
#define MTI_FIDLE1_C 92 //
#define MTI_FIDLE2_C 93 //
#define MTI_FLTURN1_C 94
#define MTI_FLTURN2_C 95 //
#define MTI_FRTURN1_C 96
#define MTI_FRTURN2_C 97 //
#define MTI_FRUNNING1_C 98 //
#define MTI_FRUNNING2_C 99 ///
#define MTI_FDMG1_C 100
#define MTI_FATK1_C 101
#define MTI_FATK2_C 102
#define MTI_FATK3_C 103
#define MTI_PICKUP 121 // ¸ð¼ÇÀ妽ºµµ ÇöÀç ÀúÀåÇϹǷΠ¹øÈ£¸¦ ¹Ù²Ü¼ö°¡ ¾ø´Ù. À§¿¡ ³¢¿ö³ÖÀ»°÷µµ ¾ø´Ù. -xuzhu-
#define MTI_HANDSHAKE 122
#define MTI_AMBIGUOUS 123
#define MTI_YES 124
#define MTI_NO 125
#define MTI_SPRINT 126
#define MTI_PARADEREST 127
#define MTI_ATTENTION 128
#define MTI_SCISSORS 129
#define MTI_ROCK 130
#define MTI_PAPER 131
#define MTI_POINTWAYNORTH 132
#define MTI_POINTWAYSOUTH 133
#define MTI_POINTWAYEAST 134
#define MTI_POINTWAYWEST 135
#define MTI_KNEEDOWN 136
#define MTI_PUSHUP 137
#define MTI_HIPKIDDING 138
#define MTI_JAB 139
#define MTI_HEAD 140
#define MTI_RISESWORD 141
#define MTI_COLLECT 142 // äÁý ¸ð¼Ç
#define MTI_APPEAR 143 // µîÀå ¸ð¼Ç
#define MTI_APPEAR2 144 // µîÀå ¸ð¼Ç2
#define MTI_CHEERSAME 145 //µ¿¼º ÀÀ¿ø ¸ð¼Ç
#define MTI_CHEEROTHER 146 //À̼º ÀÀ¿ø ¸ð¼Ç
#define MTI_FALL 147
#define MTI_LOGOUT 194
#define MTI_ACCLAIM 195
#define MTI_CLAPDOWN 196
#define MTI_CLAPUP 197
#define MTI_LEVELUP 198
#define MTI_STAND2 199 // ij¸¯ÅÍ ¼±ÅÃÈ*¸é¿¡¼* Æ÷´ÏÅ×ÀÏÀ» ij¸¯ÅÍ µÚ·Î ³ª¿À°Ô Çϱâ À§ÇØ º°µµ·Î ÀÔ·Â
#define MTI_FLYWALK 231 // »çÀÌŰÆÛ ¿¤·¹¸àÅÍ À̵¿
#define MTI_FLYBACK 232 // »çÀÌŰÆÛ ¿¤·¹¸àÅÍ À̵¿
#define MTI_FLYRUN 233 // »çÀÌŰÆÛ ¿¤·¹¸àÅÍ À̵¿
// Sworld ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_01 200
#define MTI_IDLE1_01 201
#define MTI_IDLE2_01 202
#define MTI_WALK_01 203
#define MTI_BACK_01 204
#define MTI_RUN_01 205
#define MTI_DMG1_01 206
#define MTI_DMG2_01 207
#define MTI_DIE1_01 208
#define MTI_DMGLIVE_01 209
#define MTI_DMGDIE_01 210
#define MTI_DMGFLY_01 211
#define MTI_GROGGY_01 212
#define MTI_JUMP1_01 213
#define MTI_JUMP2_01 214
#define MTI_JUMP3_01 215
#define MTI_JUMP4_01 216
#define MTI_IN_01 217
#define MTI_OUT_01 218
#define MTI_SWIM_01 219
#define MTI_SIT_01 220
#define MTI_SITSTAND_01 221
#define MTI_GETUP_01 222
#define MTI_ATK1_01 223
#define MTI_ATK2_01 224
#define MTI_ATK3_01 225
#define MTI_ATK4_01 226
#define MTI_ATK5_01 227
#define MTI_ATK6_01 228
#define MTI_ATK7_01 229
#define MTI_ATK8_01 230
// ¿Ïµå ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_02 300
#define MTI_IDLE1_02 301
#define MTI_IDLE2_02 302
#define MTI_WALK_02 303
#define MTI_BACK_02 304
#define MTI_RUN_02 305
#define MTI_DMG1_02 306
#define MTI_DMG2_02 307
#define MTI_DIE1_02 308
#define MTI_DMGLIVE_02 309
#define MTI_DMGDIE_02 310
#define MTI_DMGFLY_02 311
#define MTI_GROGGY_02 312
#define MTI_JUMP1_02 313
#define MTI_JUMP2_02 314
#define MTI_JUMP3_02 315
#define MTI_JUMP4_02 316
#define MTI_IN_02 317
#define MTI_OUT_02 318
#define MTI_SWIM_02 319
#define MTI_SIT_02 320
#define MTI_SITSTAND_02 321
#define MTI_GETUP_02 322
#define MTI_ATK1_02 323
#define MTI_ATK2_02 324
#define MTI_ATK3_02 325
#define MTI_ATK4_02 326
#define MTI_ATK5_02 327
#define MTI_ATK6_02 328
#define MTI_ATK7_02 329
#define MTI_ATK8_02 330
// Ä¡¾îºÀ ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_03 400
#define MTI_IDLE1_03 401
#define MTI_IDLE2_03 402
#define MTI_WALK_03 403
#define MTI_BACK_03 404
#define MTI_RUN_03 405
#define MTI_DMG1_03 406
#define MTI_DMG2_03 407
#define MTI_DIE1_03 408
#define MTI_DMGLIVE_03 409
#define MTI_DMGDIE_03 410
#define MTI_DMGFLY_03 411
#define MTI_GROGGY_03 412
#define MTI_JUMP1_03 413
#define MTI_JUMP2_03 414
#define MTI_JUMP3_03 415
#define MTI_JUMP4_03 416
#define MTI_IN_03 417
#define MTI_OUT_03 418
#define MTI_SWIM_03 419
#define MTI_SIT_03 420
#define MTI_SITSTAND_03 421
#define MTI_GETUP_03 422
#define MTI_ATK1_03 423
#define MTI_ATK2_03 424
#define MTI_ATK3_03 425
#define MTI_ATK4_03 426
#define MTI_ATK5_03 427
#define MTI_ATK6_03 428
#define MTI_ATK7_03 429
#define MTI_ATK8_03 430
// ¿¢½º ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_04 500
#define MTI_IDLE1_04 501
#define MTI_IDLE2_04 502
#define MTI_WALK_04 503
#define MTI_BACK_04 504
#define MTI_RUN_04 505
#define MTI_DMG1_04 506
#define MTI_DMG2_04 507
#define MTI_DIE1_04 508
#define MTI_DMGLIVE_04 509
#define MTI_DMGDIE_04 510
#define MTI_DMGFLY_04 511
#define MTI_GROGGY_04 512
#define MTI_JUMP1_04 513
#define MTI_JUMP2_04 514
#define MTI_JUMP3_04 515
#define MTI_JUMP4_04 516
#define MTI_IN_04 517
#define MTI_OUT_04 518
#define MTI_SWIM_04 519
#define MTI_SIT_04 520
#define MTI_SITSTAND_04 521
#define MTI_GETUP_04 522
#define MTI_ATK1_04 523
#define MTI_ATK2_04 524
#define MTI_ATK3_04 525
#define MTI_ATK4_04 526
#define MTI_ATK5_04 527
#define MTI_ATK6_04 528
#define MTI_ATK7_04 529
#define MTI_ATK8_04 530
// ½ºÅÂÇÁ ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_05 600
#define MTI_IDLE1_05 601
#define MTI_IDLE2_05 602
#define MTI_WALK_05 603
#define MTI_BACK_05 604
#define MTI_RUN_05 605
#define MTI_DMG1_05 606
#define MTI_DMG2_05 607
#define MTI_DIE1_05 608
#define MTI_DMGLIVE_05 609
#define MTI_DMGDIE_05 610
#define MTI_DMGFLY_05 611
#define MTI_GROGGY_05 612
#define MTI_JUMP1_05 613
#define MTI_JUMP2_05 614
#define MTI_JUMP3_05 615
#define MTI_JUMP4_05 616
#define MTI_IN_05 617
#define MTI_OUT_05 618
#define MTI_SWIM_05 619
#define MTI_SIT_05 620
#define MTI_SITSTAND_05 621
#define MTI_GETUP_05 622
#define MTI_ATK1_05 623
#define MTI_ATK2_05 624
#define MTI_ATK3_05 625
#define MTI_ATK4_05 626
#define MTI_ATK5_05 627
#define MTI_ATK6_05 628
#define MTI_ATK7_05 629
#define MTI_ATK8_05 630
// ³ÊÅ¬ÇØ¸Ó ÀüÅõ ¸ðµå µ¿ÀÛ
#define MTI_STAND_06 700
#define MTI_IDLE1_06 701
#define MTI_IDLE2_06 702
#define MTI_WALK_06 703
#define MTI_BACK_06 704
#define MTI_RUN_06 705
#define MTI_DMG1_06 706
#define MTI_DMG2_06 707
#define MTI_DIE1_06 708
#define MTI_DMGLIVE_06 709
#define MTI_DMGDIE_06 710
#define MTI_DMGFLY_06 711
#define MTI_GROGGY_06 712
#define MTI_JUMP1_06 713
#define MTI_JUMP2_06 714
#define MTI_JUMP3_06 715
#define MTI_JUMP4_06 716
#define MTI_IN_06 717
#define MTI_OUT_06 718
#define MTI_SWIM_06 719
#define MTI_SIT_06 720
#define MTI_SITSTAND_06 721
#define MTI_GETUP_06 722
#define MTI_ATK1_06 723
#define MTI_ATK2_06 724
#define MTI_ATK3_06 725
#define MTI_ATK4_06 726
#define MTI_ATK5_06 727
#define MTI_ATK6_06 728
#define MTI_ATK7_06 729
#define MTI_ATK8_06 730
// ¾ç¼Õ ¾ç¼Õµµ³¢ ÀüÅõ µ¿ÀÛ
#define MTI_STAND_07 800
#define MTI_IDLE1_07 801
#define MTI_IDLE2_07 802
#define MTI_WALK_07 803
#define MTI_BACK_07 804
#define MTI_RUN_07 805
#define MTI_DMG1_07 806
#define MTI_DMG2_07 807
#define MTI_DIE1_07 808
#define MTI_DMGLIVE_07 809
#define MTI_DMGDIE_07 810
#define MTI_DMGFLY_07 811
#define MTI_GROGGY_07 812
#define MTI_JUMP1_07 813
#define MTI_JUMP2_07 814
#define MTI_JUMP3_07 815
#define MTI_JUMP4_07 816
#define MTI_IN_07 817
#define MTI_OUT_07 818
#define MTI_SWIM_07 819
#define MTI_SIT_07 820
#define MTI_SITSTAND_07 821
#define MTI_GETUP_07 822
#define MTI_ATK1_07 823
#define MTI_ATK2_07 824
#define MTI_ATK3_07 825
#define MTI_ATK4_07 826
#define MTI_ATK5_07 827
#define MTI_ATK6_07 828
#define MTI_ATK7_07 829
#define MTI_ATK8_07 830
// À̵µ·ù ÀüÅõµ¿ÀÛ
#define MTI_STAND_08 900
#define MTI_IDLE1_08 901
#define MTI_IDLE2_08 902
#define MTI_WALK_08 903
#define MTI_BACK_08 904
#define MTI_RUN_08 905
#define MTI_DMG1_08 906
#define MTI_DMG2_08 907
#define MTI_DIE1_08 908
#define MTI_DMGLIVE_08 909
#define MTI_DMGDIE_08 910
#define MTI_DMGFLY_08 911
#define MTI_GROGGY_08 912
#define MTI_JUMP1_08 913
#define MTI_JUMP2_08 914
#define MTI_JUMP3_08 915
#define MTI_JUMP4_08 916
#define MTI_IN_08 917
#define MTI_OUT_08 918
#define MTI_SWIM_08 919
#define MTI_SIT_08 920
#define MTI_SITSTAND_08 921
#define MTI_GETUP_08 922
#define MTI_ATK1_08 923
#define MTI_ATK2_08 924
#define MTI_ATK3_08 925
#define MTI_ATK4_08 926
#define MTI_ATK5_08 927
#define MTI_ATK6_08 928
#define MTI_ATK7_08 929
#define MTI_ATK8_08 930
// ¸µ¸¶½ºÅÍ ½ºÆ½ ÀüÅõµ¿ÀÛ
#define MTI_STAND_09 2000
#define MTI_IDLE1_09 2001
#define MTI_IDLE2_09 2002
#define MTI_WALK_09 2003
#define MTI_BACK_09 2004
#define MTI_RUN_09 2005
#define MTI_DMG1_09 2006
#define MTI_DMG2_09 2007
#define MTI_DIE1_09 2008
#define MTI_DMGLIVE_09 2009
#define MTI_DMGDIE_09 2010
#define MTI_DMGFLY_09 2011
#define MTI_GROGGY_09 2012
#define MTI_JUMP1_09 2013
#define MTI_JUMP2_09 2014
#define MTI_JUMP3_09 2015
#define MTI_JUMP4_09 2016
#define MTI_IN_09 2017
#define MTI_OUT_09 2018
#define MTI_SWIM_09 2019
#define MTI_SIT_09 2020
#define MTI_SITSTAND_09 2021
#define MTI_GETUP_09 2022
#define MTI_ATK1_09 2023
#define MTI_ATK2_09 2024
#define MTI_ATK3_09 2025
#define MTI_ATK5_09 2026
#define MTI_ATK6_09 2027
#define MTI_ATK7_09 2028
#define MTI_ATK8_09 2029
// ºô Æ÷½ºÅÍ ³ÊŬ ÀüÅõµ¿ÀÛ
#define MTI_STAND_10 2100
#define MTI_IDLE1_10 2101
#define MTI_IDLE2_10 2102
#define MTI_WALK_10 2103
#define MTI_BACK_10 2104
#define MTI_RUN_10 2105
#define MTI_DMG1_10 2106
#define MTI_DMG2_10 2107
#define MTI_DIE1_10 2108
#define MTI_DMGLIVE_10 2109
#define MTI_DMGDIE_10 2110
#define MTI_DMGFLY_10 2111
#define MTI_GROGGY_10 2112
#define MTI_JUMP1_10 2113
#define MTI_JUMP2_10 2114
#define MTI_JUMP3_10 2115
#define MTI_JUMP4_10 2116
#define MTI_IN_10 2117
#define MTI_OUT_10 2118
#define MTI_SWIM_10 2119
#define MTI_SIT_10 2120
#define MTI_SITSTAND_10 2121
#define MTI_GETUP_10 2122
#define MTI_ATK1_10 2123
#define MTI_ATK2_10 2124
#define MTI_ATK3_10 2125
#define MTI_ATK4_10 2126
#define MTI_ATK5_10 2127
#define MTI_ATK6_10 2128
#define MTI_ATK7_10 2129
#define MTI_ATK8_10 2130
// »çÀÌŰÆÛ ¿Ïµå ÀüÅõµ¿ÀÛ
#define MTI_STAND_11 2200
#define MTI_IDLE1_11 2201
#define MTI_IDLE2_11 2202
#define MTI_WALK_11 2203
#define MTI_BACK_11 2204
#define MTI_RUN_11 2205
#define MTI_DMG1_11 2206
#define MTI_DMG2_11 2207
#define MTI_DIE1_11 2208
#define MTI_DMGLIVE_11 2209
#define MTI_DMGDIE_11 2210
#define MTI_DMGFLY_11 2211
#define MTI_GROGGY_11 2212
#define MTI_JUMP1_11 2213
#define MTI_JUMP2_11 2214
#define MTI_JUMP3_11 2215
#define MTI_JUMP4_11 2216
#define MTI_IN_11 2217
#define MTI_OUT_11 2218
#define MTI_SWIM_11 2219
#define MTI_SIT_11 2220
#define MTI_SITSTAND_11 2221
#define MTI_GETUP_11 2222
#define MTI_ATK_11 2223
#define MTI_ATK5_11 2224
#define MTI_ATK6_11 2225
#define MTI_ATK7_11 2226
#define MTI_ATK8_11 2227
// ¿¤·¹¸àÅÍ ½ºÅÂÇÁ ÀüÅõµ¿ÀÛ
#define MTI_STAND_12 2300
#define MTI_IDLE1_12 2301
#define MTI_IDLE2_12 2302
#define MTI_WALK_12 2303
#define MTI_BACK_12 2304
#define MTI_RUN_12 2305
#define MTI_DMG1_12 2306
#define MTI_DMG2_12 2307
#define MTI_DIE1_12 2308
#define MTI_DMGLIVE_12 2309
#define MTI_DMGDIE_12 2310
#define MTI_DMGFLY_12 2311
#define MTI_GROGGY_12 2312
#define MTI_JUMP1_12 2313
#define MTI_JUMP2_12 2314
#define MTI_JUMP3_12 2315
#define MTI_JUMP4_12 2316
#define MTI_IN_12 2317
#define MTI_OUT_12 2318
#define MTI_SWIM_12 2319
#define MTI_SIT_12 2320
#define MTI_SITSTAND_12 2321
#define MTI_GETUP_12 2322
#define MTI_ATK_12 2323
#define MTI_ATK5_12 2324
#define MTI_ATK6_12 2325
#define MTI_ATK7_12 2326
#define MTI_ATK8_12 2327
// ¾ÆÅ©·Î¹î Ȱ ÀüÅõµ¿ÀÛ
#define MTI_STAND_13 2328
#define MTI_IDLE1_13 2329
#define MTI_IDLE2_13 2330
#define MTI_WALK_13 2331
#define MTI_BACK_13 2332
#define MTI_RUN_13 2333
#define MTI_DMG1_13 2334
#define MTI_DMG2_13 2335
#define MTI_DIE1_13 2336
#define MTI_DMGLIVE_13 2337
#define MTI_DMGDIE_13 2338
#define MTI_DMGFLY_13 2339
#define MTI_GROGGY_13 2340
#define MTI_JUMP1_13 2341
#define MTI_JUMP2_13 2342
#define MTI_JUMP3_13 2343
#define MTI_JUMP4_13 2344
#define MTI_IN_13 2345
#define MTI_OUT_13 2346
#define MTI_SWIM_13 2347
#define MTI_SIT_13 2348
#define MTI_SITSTAND_13 2349
#define MTI_GETUP_13 2350
#define MTI_ATK_13 2351
#define MTI_ATK5_13 2352
#define MTI_ATK6_13 2353
#define MTI_ATK7_13 2354
#define MTI_ATK8_13 2355
//¾ÆÅ©·Î¹î ¿ä¿ä ÀüÅõµ¿ÀÛ
#define MTI_STAND_14 2356
#define MTI_IDLE1_14 2357
#define MTI_IDLE2_14 2358
#define MTI_WALK_14 2359
#define MTI_BACK_14 2360
#define MTI_RUN_14 2361
#define MTI_DMG1_14 2362
#define MTI_DMG2_14 2363
#define MTI_DIE1_14 2364
#define MTI_DMGLIVE_14 2365
#define MTI_DMGDIE_14 2366
#define MTI_DMGFLY_14 2367
#define MTI_GROGGY_14 2368
#define MTI_JUMP1_14 2369
#define MTI_JUMP2_14 2370
#define MTI_JUMP3_14 2371
#define MTI_JUMP4_14 2372
#define MTI_IN_14 2373
#define MTI_OUT_14 2374
#define MTI_SWIM_14 2375
#define MTI_SIT_14 2376
#define MTI_SITSTAND_14 2377
#define MTI_GETUP_14 2378
#define MTI_ATK1_14 2379
#define MTI_ATK2_14 2380
#define MTI_ATK5_14 2381
#define MTI_ATK6_14 2382
#define MTI_ATK7_14 2383
#define MTI_ATK8_14 2384
// ƯÁ¤ µ¿ÀÛ¿¡ Ãß°¡ÀûÀ¸·Î ´õÇØÁ®¼* ¿Ï¼ºµÈ ¸ð¼Ç À妽º¸¦ ¸¸µç´Ù.
// MTI_FDOWN1 = MTI_FSTAND1 + MTA_FDOWN
#define MTA_FSTAND1 0
#define MTA_FIDLE1 1
#define MTA_FIDLE2 2
#define MTA_FLTURN1 3
#define MTA_FLTURN2 4
#define MTA_FRTURN1 5
#define MTA_FRTURN2 6
#define MTA_FRUNNING1 7
#define MTA_FRUNNING2 8
#define MTA_FDMG1 9
#define MTA_FATK1 10
#define MTA_FATK2 11
#define MTA_FATK3 12
// ¿©±âºÎÅÍ ½ºÅ³ µ¿ÀÛ Ãß°¡
// ¹æ¶ûÀÚ °è¿*
#define MTI_VAG_ONE_CLEANHIT 1000
#define MTI_VAG_ONE_BRANDISH 1001
#define MTI_VAG_ONE_OVERCUTTER 1002
// ¸Ó¼*³Ê¸® °è¿*
#define MTI_MER_ONE_SPLMASH 1003
#define MTI_MER_ONE_KEENWHEEL 1004
#define MTI_MER_ONE_BLINDSIDE 1005
#define MTI_MER_ONE_SPECIAL 1006
#define MTI_MER_ONE_SNAKE 1007
#define MTI_MER_SHIELD_PROTECTION 1008
#define MTI_MER_SHIELD_PANBARRIER 1009
#define MTI_MER_ONE_BLOODYSTRIKE 1010
// ¾î½Ã½ºÆ® °è¿*
#define MTI_ASS_HEAL_CASTING01 1043
#define MTI_ASS_HEAL_CASTING02 1044
#define MTI_ASS_HEAL_CASTING03 1045
#define MTI_ASS_CHEER_CASTING01 1046
#define MTI_ASS_CHEER_CASTING02 1047
#define MTI_ASS_CHEER_CASTING03 1048
#define MTI_ASS_RESURRECTION 1049
#define MTI_ASS_RES_CASTING01 1050
#define MTI_ASS_RES_CASTING02 1051
#define MTI_ASS_RES_CASTING03 1052
#define MTI_ASS_KNU_POWERFIST 1053
// ¸ÅÁö¼Ç °è¿*
#define MTI_MAG_FIRE_CASTING01 1063
#define MTI_MAG_FIRE_CASTING02 1064
#define MTI_MAG_FIRE_CASTING03 1065
#define MTI_MAG_WIND_CASTING01 1066
#define MTI_MAG_WIND_CASTING02 1067
#define MTI_MAG_WIND_CASTING03 1068
#define MTI_ASS_KNU_BURSTCRACK 1103 // Ãß°¡ ¾î½Ã½ºÆ® ³ÊŬ½ºÅ³
#define MTI_ASS_KNU_TAMPINGHOLE 1104 // Ãß°¡ ¾î½Ã½ºÆ® ³ÊŬ½ºÅ³
//³ªÀÌÆ®
#define MTI_KNT_SUP_CASTING01 1105
#define MTI_KNT_TWO_POWERSWING01 1106
#define MTI_KNT_TWOSW_EARTHDIVIDER01 1107
#define MTI_KNT_TWOSW_CHARGE01 1108
#define MTI_KNT_TWOAX_PAINDEALER01 1109
#define MTI_KNT_TWOAX_POWERSTUMP01 1110
//ºí·¹À̵å
#define MTI_BLD_DOUBLE_CROSSSTRIKE01 1111
#define MTI_BLD_DOUBLE_ARMORPENETRATE01 1112
#define MTI_BLD_DOUBLESW_SILENTSTRIKE01 1113
#define MTI_BLD_DOUBLESW_BLADEDANCE01 1114
#define MTI_BLD_DOUBLEAX_SPRINGATTAKE01 1115
#define MTI_BLD_DOUBLEAX_HAWKATTAKE01 1116
#define MTI_BLD_DOUBLE_SONICBLADE01 1117
#define MTI_BLD_SUP_CASTING01 1118
//¸µ¸¶½ºÅÍ
#define MTI_RIN_HEAL_CASTING01 1119
#define MTI_RIN_HEAL_CASTING02 1120
#define MTI_RIN_HEAL_CASTING03 1121
#define MTI_RIN_SUP_CASTING01 1122
#define MTI_RIN_SUP_CASTING02 1123
#define MTI_RIN_SUP_CASTING03 1124
#define MTI_RIN_HEAL_CURE01 1125
#define MTI_RIN_HEAL_CURE02 1126
#define MTI_RIN_HEAL_CURE03 1127
#define MTI_RIN_SQU_CASTING01 1128
#define MTI_RIN_SQU_CASTING02 1129
#define MTI_RIN_SQU_CASTING03 1130
//ºôÆ÷½ºÅÍ
#define MTI_BIL_KNU_BELIALSMESHING01 1131
#define MTI_BIL_KNU_PIERCINGSERPENT01 1132
#define MTI_BIL_KNU_BLOODFIST01 1133
#define MTI_BIL_KNU_SONICHAND01 1134
#define MTI_BIL_PST_CASTING01 1135
#define MTI_BIL_PST_CASTING02 1136
#define MTI_BIL_PST_CASTING03 1137
#define MTI_BIL_PST_SQUARE01 1138
#define MTI_BIL_PST_SQUARE02 1139
#define MTI_BIL_PST_SQUARE03 1140
//»çÀÌŰÆÛ
#define MTI_PSY_NLG_CASTING01 1145
#define MTI_PSY_NLG_CASTING02 1146
#define MTI_PSY_NLG_CASTING03 1147
#define MTI_PSY_PSY_PSYCHI01 1148
#define MTI_PSY_PSY_PSYCHI02 1149
#define MTI_PSY_PSY_PSYCHI03 1150
#define MTI_PSY_PSY_SQUARE01 1151
#define MTI_PSY_PSY_SQUARE02 1152
#define MTI_PSY_PSY_SQUARE03 1153
//¿¤¸®¸àÅÍ
#define MTI_ELE_FIRE_CASTING01 1160
#define MTI_ELE_FIRE_CASTING02 1161
#define MTI_ELE_FIRE_CASTING03 1162
#define MTI_ELE_ELECTRICITY_CASTING01 1163
#define MTI_ELE_ELECTRICITY_CASTING02 1164
#define MTI_ELE_ELECTRICITY_CASTING03 1165
#define MTI_ELE_EARTH_CASTING01 1166
#define MTI_ELE_EARTH_CASTING02 1167
#define MTI_ELE_EARTH_CASTING03 1168
#define MTI_ELE_WATER_CASTING01 1169
#define MTI_ELE_WATER_CASTING02 1170
#define MTI_ELE_WATER_CASTING03 1171
#define MTI_ELE_WIND_CASTING01 1172
#define MTI_ELE_WIND_CASTING02 1173
#define MTI_ELE_WIND_CASTING03 1174
#define MTI_ELE_MULTI_CASTING01 1175
#define MTI_ELE_MULTI_CASTING02 1176
#define MTI_ELE_MULTI_CASTING03 1177
//¾ÆÅ©·Î¹î
#define MTI_ACR_SUP_CASTING01 1178
#define MTI_ACR_BOW_JUNKBOW01 1179
#define MTI_ACR_BOW_AIMEDSHOT01 1180
#define MTI_ACR_YOYO_SLOWSTEP01 1181
#define MTI_ACR_BOW_SILENTSHOT01 1182
#define MTI_ACR_DEF_SUPPORT01 1183
#define MTI_ACR_BOW_ARROWRAIN01 1184
#define MTI_ACR_YOYO_CROSSLINE01 1185
#define MTI_ACR_BOW_AUTOSHOT01 1186
#define MTI_ACR_YOYO_SNITCH01 1187
#define MTI_ACR_YOYO_COUNTER01 1188
#define MTI_ACR_YOYO_DEADLYSWING01 1189
#define MTI_ACR_YOYO_PULLING01 1190
#define MTI_ACR_YOYO_COUNTER02 1205
//Á¦½ºÅÍ
#define MTI_JST_SUP_CRITICALSWING01 1191
#define MTI_JST_SUP_ENCHANT 1192
#define MTI_JST_YOYO_BACKSTAB01 1193
#define MTI_JST_YOYO_HITOFPENYA01 1194
#define MTI_JST_YOYO_ESCAPE01 1195
#define MTI_JST_YOYO_VATALSTAB01 1196
//·¹ÀÎÀú
#define MTI_RAG_SUP_FASTATTACK01 1197
#define MTI_RAG_BOW_ICEARROW01 1198
#define MTI_RAG_BOW_FLAMEARROW01 1199
#define MTI_RAG_BOW_PIRCINGARROW01 1200
#define MTI_RAG_BOW_POISONARROW01 1201
#define MTI_RAG_BOW_SILENTARROW01 1202
#define MTI_RAG_SUP_NATURE01 1203
#define MTI_RAG_BOW_TRIPLESHOT01 1204
//³¯°³¸ð¼Ç
#define MTI_FSTAND1_D 1206
#define MTI_FIDLE1_D 1207
#define MTI_FIDLE2_D 1208
#define MTI_FLTURN1_D 1209
#define MTI_FLTURN2_D 1210
#define MTI_FRTURN1_D 1211
#define MTI_FRTURN2_D 1212
#define MTI_FRUNNING1_D 1213
#define MTI_FRUNNING2_D 1214
#define MTI_FDMG1_D 1215
#define MTI_FATK1_D 1216
#define MTI_FATK2_D 1217
#define MTI_FATK3_D 1218
// parts
#define HAIRMESH_01 0
#define HAIRMESH_02 1
#define HAIRMESH_03 2
#define HAIRMESH_04 3
#define HAIRMESH_05 4
#define HAIRMESH_06 5
#define HAIRMESH_07 6
#define HAIRMESH_08 7
#define HAIRMESH_09 8
#define HAIRMESH_10 9
#define SKINSET_01 0
#define SKINSET_02 1
#define SKINSET_03 2
#define SKINSET_04 3
#define SKINSET_05 4
#define HEADTEXTURE_NORMAL 0
#define HEADTEXTURE_SMILE 1
#define HEADTEXTURE_RAGE 2
#define MAX_DEFAULT_HEAD 5
#define MAX_HEAD 11
#define MAX_HAIR 10
#define MAX_BASE_HAIR 5
#define MAX_SKIN 2
#define HAIR_COST 2000000
#define HAIRCOLOR_COST 4000000
#define CHANGE_FACE_COST 1000000
#endif
Alles anzeigen
greetz^^[/COLOR][/FONT]
Zitat von Iamthegame;96900
Ich kann keine neue WdMadrigal einsetzen sonst komm ich nicht in die world :/
und es kommen auch keine errorsausser das (Client)
Code Alles anzeigen2010/ 3/19 15:18:29 CDPLoginClient::OnPlayerList : 19752¾ÆÀÌÅÛ ÇÁ·ÎÆÛƼ ¾øÀ½ 2010/ 3/19 15:18:35 Oct 9 2009 12:16:29 1 rCnt=1 NeuzSerus.exe caused an EXCEPTION_ACCESS_VIOLATION in module NeuzSerus.exe at 001B:00710F5A - Registers EAX=00A5B198 EBX=7FFD6000 ECX=0000001F EDX=00000000 ESI=00000000 EDI=00000000 EBP=0012BDC4 ESP=0012BD48 EIP=00710F5A FLG=00010206 CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000 001B:00710F5A NeuzSerus.exe 001B:0070FFD7 NeuzSerus.exe 001B:006BB61C NeuzSerus.exe 001B:0071B2C5 NeuzSerus.exe 001B:0040381F NeuzSerus.exe 001B:004035E5 NeuzSerus.exe 001B:007214F7 NeuzSerus.exe 001B:0086F81D NeuzSerus.exe 001B:7774D0E9 kernel32.dll 001B:775C19BB ntdll.dll 001B:775C198E ntdll.dll
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
[FONT="Comic Sans MS"][COLOR="Wheat"]@ minimal
if das not geht then nimm andere files ;)
ich bin deutsch wieso schreibst du mit mir englisch :D
ich finde die 99% bugfreien immer noch die besten[/COLOR][/FONT]
@xSay weil du angefangen hast mit Englisch schreiben hatte ich die vermutung das du auch Englisch bist ;)
und ich möchte aber die V15 Ready Files benutzen weil ich mal kucken möchte wie sie so sind und weil mir langweilig ist mit v14 Files xD
Zitat von Iamthegame;96900
Ich kann keine neue WdMadrigal einsetzen sonst komm ich nicht in die world :/
und es kommen auch keine errorsausser das (Client)
Code Alles anzeigen2010/ 3/19 15:18:29 CDPLoginClient::OnPlayerList : 19752¾ÆÀÌÅÛ ÇÁ·ÎÆÛƼ ¾øÀ½ 2010/ 3/19 15:18:35 Oct 9 2009 12:16:29 1 rCnt=1 NeuzSerus.exe caused an EXCEPTION_ACCESS_VIOLATION in module NeuzSerus.exe at 001B:00710F5A - Registers EAX=00A5B198 EBX=7FFD6000 ECX=0000001F EDX=00000000 ESI=00000000 EDI=00000000 EBP=0012BDC4 ESP=0012BD48 EIP=00710F5A FLG=00010206 CS=001B DS=0023 SS=0023 ES=0023 FS=003B GS=0000 001B:00710F5A NeuzSerus.exe 001B:0070FFD7 NeuzSerus.exe 001B:006BB61C NeuzSerus.exe 001B:0071B2C5 NeuzSerus.exe 001B:0040381F NeuzSerus.exe 001B:004035E5 NeuzSerus.exe 001B:007214F7 NeuzSerus.exe 001B:0086F81D NeuzSerus.exe 001B:7774D0E9 kernel32.dll 001B:775C19BB ntdll.dll 001B:775C198E ntdll.dll
PUHUUUUUUUUUUUUUUSCH >.< :(
weiss denn niemand ne lösung warum ich net in die world komme wenn ich wdmadrigal ändere
[FONT="Comic Sans MS"][COLOR="Wheat"]neue res dateien und flyff.a gemacht ?[/COLOR][/FONT]
Zitat von Dane;99287[FONT="Comic Sans MS"][COLOR="Wheat"]neue res dateien und flyff.a gemacht ?[/COLOR][/FONT]
meinste mit merge2 ??
ja hab ich gemacht klappt aber nit :/
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 ><
ZitatD:\ÇØ¿Ü\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 =)
Zitat von DerJulian;99291Alles anzeigenIch 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',
stehtWie schon gesagt ich bin da überfordert und weiß grade nicht weiter >.<
Welche Datenbank benutzt du?
Die AllinOne Db ;)
Zitat von DerJulian;99361Die AllinOne Db ;)
ODBC auch auf English?
Zitat von DerJulian;99291Alles anzeigenIch 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',
stehtWie 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
USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[CHARACTER_STR] Script Date: 01/29/2010 13:04:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.CHARACTER_STR Script Date: 7/29/2008 3:34:04 AM ******/
CREATE proc [dbo].[CHARACTER_STR]
@iGu CHAR(2) = 'S1',
@im_idPlayer CHAR(7) = '0000001',
@iserverindex CHAR(2) = '01',
/**********************************************
INSERT 용
**********************************************/
-- CHARACTER_TBL
@iaccount VARCHAR(32) = '',
@im_szName VARCHAR(32) = '',
@iplayerslot INT = 0,
@idwWorldID INT = 0,
@im_dwIndex INT = 0,
@im_vPos_x REAL = 0,
@im_vPos_y REAL = 0,
@im_vPos_z REAL = 0,
@im_szCharacterKey VARCHAR(32) = '',
@im_dwSkinSet INT = 0,
@im_dwHairMesh INT = 0,
@im_dwHairColor INT = 0,
@im_dwHeadMesh INT = 0,
@im_dwSex INT = 0,
/**********************************************
UPDATE 용
**********************************************/
-- CHARACTER_TBL
@im_vScale_x REAL = 0,
@im_dwMotion INT = 0,
@im_fAngle REAL = 0,
@im_nHitPoint INT = 0,
@im_nManaPoint INT = 0,
@im_nFatiguePoint INT = 0,
@im_dwRideItemIdx INT = 0,
@im_dwGold INT = 0,
@im_nJob INT = 0,
@im_pActMover VARCHAR(50) = '',
@im_nStr INT = 0,
@im_nSta INT = 0,
@im_nDex INT = 0,
@im_nInt INT = 0,
@im_nLevel INT = 0,
@im_nExp1 BIGINT = 0,
@im_nExp2 BIGINT = 0,
@im_aJobSkill VARCHAR(500) ='',
@im_aLicenseSkill VARCHAR(500) ='',
@im_aJobLv VARCHAR(500) ='',
@im_dwExpertLv INT = 0,
@im_idMarkingWorld INT = 0,
@im_vMarkingPos_x REAL = 0,
@im_vMarkingPos_y REAL = 0,
@im_vMarkingPos_z REAL = 0,
@im_nRemainGP INT = 0,
@im_nRemainLP INT = 0,
@im_nFlightLv INT = 0,
@im_nFxp INT = 0,
@im_nTxp INT = 0,
@im_lpQuestCntArray VARCHAR(3072)= '',
@im_chAuthority CHAR(1) = '',
@im_dwMode INT = 0,
@im_idparty INT = 0,
--@im_nNumKill INT = 0,
@im_idMuerderer INT = 0,
--@im_nSlaughter INT = 0,
@im_nFame INT = 0,
@im_nDeathExp BIGINT = 0,
@im_nDeathLevel INT = 0,
@im_dwFlyTime INT = 0,
@im_nMessengerState INT = 0,
@iTotalPlayTime INT = 0,
---------- Additional end ----------
-- PK Variable
@im_nPKValue int=0,
@im_dwPKPropensity int=0,
@im_dwPKExp int=0,
---------- Additional end ----------
-- CARD_CUBE_TBL
@im_Card VARCHAR(1980)= '',
@im_Index_Card VARCHAR(215) = '',
@im_ObjIndex_Card VARCHAR(215) = '',
@im_Cube VARCHAR(1980)= '',
@im_Index_Cube VARCHAR(215) = '',
@im_ObjIndex_Cube VARCHAR(215) = '',
-- INVENTORY_TBL
@im_Inventory VARCHAR(6940)= '',
@im_apIndex VARCHAR(345) = '',
@im_adwEquipment VARCHAR(135) = '',
@im_dwObjIndex VARCHAR(345) = '',
-- TASKBAR_TBL
@im_aSlotApplet VARCHAR(3100)= '',
-- TASKBAR_ITEM_TBL
@im_aSlotItem VARCHAR(6885)= '',
-- TASKBAR_TBL
@im_aSlotQueue VARCHAR(225)= '',
@im_SkillBar SMALLINT = 0,
-- BANK_TBL
@im_Bank VARCHAR(4290)= '',
@im_apIndex_Bank VARCHAR(215)= '',
@im_dwObjIndex_Bank VARCHAR(215)= '',
@im_dwGoldBank INT = 0,
@im_nFuel INT = -1,
@im_tmAccFuel INT = 0,
@im_dwSMTime VARCHAR(2560)='',
@iSkillInfluence varchar(2048) ='',
@im_dwSkillPoint INT = 0,
@im_aCompleteQuest varchar(1024) = '',
@im_extInventory varchar(2000) = '',
@im_extBank varchar(2000) = '',
@im_InventoryPiercing varchar(2000) = '',
@im_BankPiercing varchar(2000) = '',
@im_dwReturnWorldID INT = 1,
@im_vReturnPos_x REAL = 0,
@im_vReturnPos_y REAL = 0,
@im_vReturnPos_z REAL= 0
-------------- ( Version 7 : Skill Update)
, @im_SkillPoint int=0
, @im_SkillLv int=0
, @im_SkillExp bigint=0
-------------- (Additional end)
, @idwEventFlag bigint=0,
@idwEventTime int=0,
@idwEventElapsed int=0
-------------- (Additional end)
----------Additional end----------
-- PVP (Additional end)
,@im_nAngelExp bigint=0
,@im_nAngelLevel int=0
----------Additional end ----------
--------------- Version 9 Relation of additional partial Pet
,@iszInventoryPet varchar(2688) = '$'
,@iszBankPet varchar(2688) = '$'
,@im_dwPetId int = -1
,@im_nExpLog int = 0
,@im_nAngelExpLog int = 0
--------- Ver 11 Coupon
,@im_nCoupon int = 0
--------- Ver 14 Shit
,@im_nHonor int = -1
,@im_nLayer int = 0
/*******************************************************
Gu Dividing
S : SELECT
I : INSERT
U : UPDATE
D : DELETE
2005.04.11 updated
ALTER TABLE CHARACTER_TBL ADD m_aCompleteQuest varchar(1024) NULL
ALTER TABLE CHARACTER_TBL ALTER COLUMN m_lpQuestCntArray VARCHAR(3072) NULL
*******************************************************/
AS
set nocount on
declare @last_connect tinyint
set @last_connect = 1
IF @iGu = 'S2' -- Is a player list which follows in the slot cuts coil information bringing,
BEGIN
IF @iaccount = '' OR @im_szName = ''
BEGIN
SELECT m_chAuthority = '',fError = '1', fText = 'Wrong password'
RETURN
END
SELECT A.dwWorldID,
A.m_szName,
A.playerslot,
A.End_Time,
A.BlockTime,
A.m_dwIndex,
A.m_idPlayer,
A.m_idparty,
A.m_dwSkinSet,
A.m_dwHairMesh,
A.m_dwHeadMesh,
A.m_dwHairColor,
A.m_dwSex,
A.m_nJob,
A.m_nLevel,
A.m_vPos_x,
A.m_vPos_y,
A.m_vPos_z,
A.m_nStr,
A.m_nSta,
A.m_nDex,
A.m_nInt,
--A.m_nSlaughter, -- raidersAddition 2005.5.11
A.m_aJobLv,
A.m_chAuthority,
A.m_idCompany,
A.m_nMessengerState,
B.m_Inventory,
B.m_apIndex,
B.m_adwEquipment,
B.m_dwObjIndex,
m_idGuild = CASE WHEN C.m_idGuild IS NULL THEN '0' ELSE C.m_idGuild END ,
m_idWar = CASE WHEN C.m_idWar IS NULL THEN '0' ELSE C.m_idWar END,
D.m_extInventory,
D.m_InventoryPiercing,
A.m_idCompany,
last_connect = @last_connect
FROM CHARACTER_TBL A, INVENTORY_TBL B,GUILD_MEMBER_TBL C, INVENTORY_EXT_TBL D
WHERE A.m_idPlayer = B.m_idPlayer
AND A.serverindex= B.serverindex
AND B.m_idPlayer = D.m_idPlayer
AND B.serverindex = D.serverindex
AND D.m_idPlayer *= C.m_idPlayer
AND D.serverindex *= C.serverindex
AND A.isblock = 'F'
AND A.account = @iaccount
AND A.serverindex= @iserverindex
ORDER BY A.playerslot
RETURN
END
/*
Is a player list which follows in the slot cuts coil information bringing,
ex )
CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
CHARACTER_STR 'S2','0','02','seghope','1234'
*/
ELSE
IF @iGu = 'S3' -- The server initially idPlayer of characters which will execute all the branch, coming,
BEGIN
SELECT m_szName, m_idPlayer,m_idCompany
FROM CHARACTER_TBL
WHERE serverindex = @iserverindex
-- AND isblock = 'F'
ORDER BY m_idPlayer
RETURN
END
/*
The server initially idPlayer of characters which will execute all the branch, coming,
ex )
CHARACTER_STR 'S3','',@iserverindex
CHARACTER_STR 'S3','','02'
*/
ELSE
IF @iGu = 'S4' -- The item confirmation which will add
BEGIN
/* if (getdate() >= '2007-10-29 00:00:00' and getdate() <= '2007-10-31 23:59:59')
begin
if not exists (select * from EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 where serverindex = @iserverindex and m_idPlayer = @im_idPlayer)
begin
declare @q1 nvarchar(4000)
declare @ktime bigint
select @ktime = cast(replace(replace(replace(convert(char(16), dateadd(hh, 72, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
set @q1 = '
insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, m_bItemResist, m_nResistAbilityOption, m_bCharged, m_dwKeepTime)
select @im_idPlayer, @iserverindex, ''26425'', 1, 0, 0, 0, 0, @ktime'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2), @ktime bigint', @im_idPlayer, @iserverindex, @ktime
set @q1 = '
insert into EOCRM.MANAGE_DBF.dbo.tblEvent_Halloween_2007 (serverindex, m_idPlayer)
select @iserverindex, @im_idPlayer'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
set @q1 = '
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
end
end
else
begin
SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0
end*/
declare @q1 nvarchar(4000)
/* if ((getdate() >= '2007-12-23 00:00:00') and (getdate() <= '2007-12-25 23:59:59'))
begin
if not exists (select * from tblevent_2007_xmas where m_idPlayer = @im_idPlayer)
begin
declare @m_dwSex int
declare @xmas_Item varchar(32)
select @m_dwSex = m_dwSex from CHARACTER_TBL where m_idPlayer = @im_idPlayer
if @m_dwSex = 0
begin
set @xmas_Item = '26339'
end
else
begin
set @xmas_Item = '26340'
end
set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
select @im_idPlayer, ''01'', @xmas_Item, 1, 0, ''0000000'''
exec sp_executesql @q1, N'@im_idPlayer char(7), @xmas_Item varchar(32)', @im_idPlayer, @xmas_Item
insert into tblevent_2007_xmas (m_idPlayer)
select @im_idPlayer
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
end*/
if ((getdate() >= '2007-12-31 00:00:00') and (getdate() <= '2007-12-31 23:59:59'))
begin
if not exists (select * from tblevent_2007_newyear where m_idPlayer = @im_idPlayer)
begin
declare @newyear_Item varchar(32)
set @newyear_Item = '2904'
set @q1 = 'insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
select @im_idPlayer, ''01'', @newyear_Item, 5, 0, ''0000000'''
exec sp_executesql @q1, N'@im_idPlayer char(7), @newyear_Item varchar(32)', @im_idPlayer, @newyear_Item
insert into tblevent_2007_newyear (m_idPlayer)
select @im_idPlayer
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
end
else
begin
set @q1 = 'SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, adwItemId4, m_dwKeepTime, nRandomOptItemId
FROM ITEM_SEND_TBL
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
end
RETURN
END
/*
Item confirmation
ex )
CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
CHARACTER_STR 'S4','000001','01'
*/
ELSE
IF @iGu = 'S5' -- From table after item utmost urgency item elimination
BEGIN
-- DELETE ITEM_SEND_TBL
UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1
WHERE m_nNo = @iplayerslot
IF @@ROWCOUNT = 0
SELECT fError = '0'
ELSE
SELECT fError = '1'
RETURN
END
/*
From table after item utmost urgency item elimination
ex )
CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S5','000001','01','Broom',1,1
*/
ELSE
IF @iGu = 'S6' -- The item confirmation which will eliminate
BEGIN
SELECT Item_Name,
Item_count,
m_nAbilityOption,
m_nNo,
State,
m_bItemResist,
m_nResistAbilityOption
FROM ITEM_REMOVE_TBL
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
AND ItemFlag = 0
RETURN
END
/*
Item confirmation
ex )
CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
CHARACTER_STR 'S6','000001','01'
*/
ELSE
IF @iGu = 'S7' -- After item eliminating from table item elimination
BEGIN
-- DELETE ITEM_REMOVE_TBL
UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1
WHERE m_nNo = @iplayerslot
IF @@ROWCOUNT = 0
SELECT fError = '0'
ELSE
SELECT fError = '1'
RETURN
END
/*
From table after item utmost urgency item elimination
ex )
CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S7','000001','01','Broom',1,1
*/
IF @iGu = 'S8' -- The data whole bringing,
BEGIN
PRINT @iaccount
DECLARE @om_chLoginAuthority CHAR(1)
-- Bank information character stars bringing
SET @om_chLoginAuthority = 'F'
--SELECT @om_chLoginAuthority = m_chLoginAuthority
-- FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL
--WHERE lower(account) = lower(@iaccount)
--INSERT INTO [ONLINE_TBL] ([account] ,[name]) VALUES(@iaccount,@im_idPlayer)
SELECT m_chLoginAuthority = @om_chLoginAuthority,
A.account,
A.m_idPlayer,
A.playerslot,
A.serverindex,
A.dwWorldID,
A.m_szName,
A.m_dwIndex,
A.m_vScale_x,
A.m_dwMotion,
A.m_vPos_x,
A.m_vPos_y,
A.m_vPos_z,
A.m_fAngle,
A.m_szCharacterKey,
A.m_idPlayer,
A.m_nHitPoint,
A.m_nManaPoint,
A.m_nFatiguePoint,
A.m_nFuel,
A.m_dwSkinSet,
A.m_dwHairMesh,
A.m_dwHairColor,
A.m_dwHeadMesh,
A.m_dwSex,
A.m_dwRideItemIdx,
A.m_dwGold,
A.m_nJob,
A.m_pActMover,
A.m_nStr,
A.m_nSta,
A.m_nDex,
A.m_nInt,
A.m_nLevel,
A.m_nMaximumLevel,
A.m_nExp1,
A.m_nExp2,
A.m_aJobSkill,
A.m_aLicenseSkill,
A.m_aJobLv,
A.m_dwExpertLv,
A.m_idMarkingWorld,
A.m_vMarkingPos_x,
A.m_vMarkingPos_y,
A.m_vMarkingPos_z,
A.m_nRemainGP,
A.m_nRemainLP,
A.m_nFlightLv,
A.m_nFxp,
A.m_nTxp,
A.m_lpQuestCntArray,
m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
A.m_chAuthority,
A.m_dwMode,
A.m_idparty,
A.m_idCompany,
--A.m_nNumKill,
A.m_idMuerderer,
--A.m_nSlaughter,
A.m_nFame,
A.m_nDeathExp,
A.m_nDeathLevel,
A.m_dwFlyTime,
A.m_nMessengerState,
A.End_Time,
A.BlockTime,
A.blockby,
A.isblock,
A.TotalPlayTime,
A.CreateTime,
A.m_dwSkillPoint,
B.m_aSlotApplet,
B.m_aSlotQueue,
B.m_SkillBar,
C.m_aSlotItem,
D.m_Inventory,
D.m_apIndex,
D.m_adwEquipment,
D.m_dwObjIndex,
m_idGuild = ISNULL(G.m_idGuild,'0'),
m_idWar = ISNULL(G.m_idWar,'0'),
A.m_tmAccFuel,
A.m_tGuildMember,
m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL') ,
SkillInfluence = ISNULL(E.SkillInfluence,'$'),
F.m_extInventory,
F.m_InventoryPiercing,
A.m_dwReturnWorldID,
A.m_idCompany,
A.m_vReturnPos_x,
A.m_vReturnPos_y,
A.m_vReturnPos_z
------------------ ( ADD : Version7-Skill System)
, m_SkillPoint = SkillPoint
, m_SkillLv = SkillLv
, m_SkillExp = SkillExp
-------------- (Additional start)
, A.dwEventFlag,
A.dwEventTime,
A.dwEventElapsed
-------------- (Additional start)
----------Additional start ----------
, A.PKValue as m_nPKValue,
A.PKPropensity as m_dwPKPropensity,
A.PKExp as m_dwPKExp
----------Additional end ----------
----------Additional end ----------
,AngelExp as m_nAngelExp
,AngelLevel as m_nAngelLevel
----------Additional end ----------
------------------- Version9 Pet
, F.szInventoryPet as szInventoryPet
, A.m_dwPetId
, A.m_nExpLog, A.m_nAngelExpLog
------------- Ver 11 Coupon
, m_nCoupon
------------- Ver 14 shit
, m_nHonor
, m_nLayer
, last_connect = @last_connect
FROM CHARACTER_TBL A,
TASKBAR_TBL B,
TASKBAR_ITEM_TBL C,
INVENTORY_TBL D,
SKILLINFLUENCE_TBL E,
INVENTORY_EXT_TBL F,
GUILD_MEMBER_TBL G,
BILING_ITEM_TBL H
WHERE A.m_idPlayer = @im_idPlayer
AND A.serverindex = @iserverindex
AND A.m_idPlayer = B.m_idPlayer
AND A.serverindex = B.serverindex
AND B.m_idPlayer = C.m_idPlayer
AND B.serverindex = C.serverindex
AND C.m_idPlayer = D.m_idPlayer
AND C.serverindex = D.serverindex
AND D.m_idPlayer = E.m_idPlayer
AND D.serverindex = E.serverindex
AND E.m_idPlayer = F.m_idPlayer
AND E.serverindex = F.serverindex
AND F.serverindex *= G.serverindex
AND F.m_idPlayer *= G.m_idPlayer
AND F.serverindex *= H.serverindex
AND F.m_idPlayer *= H.m_idPlayer
AND A.account = lower(@iaccount)
-- Bank information account stars bringing
-- DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
--
-- INSERT @bank
-- (m_idPlayer,serverindex,playerslot)
-- SELECT m_idPlayer,serverindex,playerslot
-- FROM CHARACTER_TBL
-- WHERE account = @iaccount
-- AND isblock = 'F'
-- ORDER BY playerslot
SELECT a.m_idPlayer,
c.playerslot,
a.m_Bank,
a.m_apIndex_Bank,
a.m_dwObjIndex_Bank,
a.m_dwGoldBank,
a.m_BankPw,
b.m_extBank,
b.m_BankPiercing, b.szBankPet
FROM dbo.BANK_TBL a,
dbo.BANK_EXT_TBL b,
dbo.CHARACTER_TBL c
WHERE a.m_idPlayer = b.m_idPlayer
AND a.serverindex = b.serverindex
AND b.m_idPlayer = c.m_idPlayer
AND b.serverindex = c.serverindex
AND c.account = lower(@iaccount)
AND c.isblock = 'F'
ORDER BY c.playerslot
------------- Ver11 Pocket
SELECT a.nPocket,
a.szItem,
a.szIndex,
a.szObjIndex,
a.bExpired,
a.tExpirationDate,
b.szExt,
b.szPiercing,
b.szPet
FROM tblPocket as a inner join tblPocketExt as b
on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
ORDER BY a.nPocket
RETURN
END
/*
The data whole bringing, New
ex )
CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
CHARACTER_STR 'S8','425120','01','ata3k'
*/
ELSE
IF @iGu = 'U1' -- Character store
BEGIN
--DELETE FROM ONLINE_TBL WHERE name = @im_idPlayer
UPDATE CHARACTER_TBL
SET dwWorldID = @idwWorldID,
m_dwIndex = @im_dwIndex,
m_dwSex = @im_dwSex,
m_vScale_x = @im_vScale_x,
m_dwMotion = @im_dwMotion,
m_vPos_x = @im_vPos_x,
m_vPos_y = @im_vPos_y,
m_vPos_z = @im_vPos_z,
m_dwHairMesh = @im_dwHairMesh,
m_dwHairColor = @im_dwHairColor,
m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 Addition
m_fAngle = 0, --@im_fAngle,
m_szCharacterKey = @im_szCharacterKey,
m_nHitPoint = @im_nHitPoint,
m_nManaPoint = @im_nManaPoint,
m_nFatiguePoint = @im_nFatiguePoint,
m_nFuel = @im_nFuel,
m_dwRideItemIdx = @im_dwRideItemIdx,
m_dwGold = @im_dwGold,
m_nJob = @im_nJob,
m_pActMover = @im_pActMover,
m_nStr = @im_nStr,
m_nSta = @im_nSta,
m_nDex = @im_nDex,
m_nInt = @im_nInt,
m_nLevel = @im_nLevel,
m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
m_nExp1 = @im_nExp1,
m_nExp2 = @im_nExp2,
m_aJobSkill = @im_aJobSkill,
m_aLicenseSkill = @im_aLicenseSkill,
m_aJobLv = @im_aJobLv,
m_dwExpertLv = @im_dwExpertLv,
m_idMarkingWorld = @im_idMarkingWorld,
m_vMarkingPos_x = @im_vMarkingPos_x,
m_vMarkingPos_y = @im_vMarkingPos_y,
m_vMarkingPos_z = @im_vMarkingPos_z,
m_nRemainGP = @im_nRemainGP,
m_nRemainLP = @im_nRemainLP,
m_nFlightLv = @im_nFlightLv,
m_nFxp = @im_nFxp,
m_nTxp = @im_nTxp,
m_lpQuestCntArray = @im_lpQuestCntArray,
m_aCompleteQuest = @im_aCompleteQuest,
m_dwMode = @im_dwMode,
m_idparty = @im_idparty,
--m_nNumKill = @im_nNumKill,
m_idMuerderer = @im_idMuerderer,
--m_nSlaughter = @im_nSlaughter ,
m_nFame = @im_nFame,
m_nDeathExp = @im_nDeathExp,
m_nDeathLevel = @im_nDeathLevel,
-- m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime,
m_dwFlyTime = @im_dwFlyTime,
m_nMessengerState = @im_nMessengerState,
TotalPlayTime = TotalPlayTime + @iTotalPlayTime,
m_tmAccFuel = @im_tmAccFuel,
m_dwSkillPoint = @im_dwSkillPoint,
m_dwReturnWorldID= @im_dwReturnWorldID,
m_idCompany = 0,
m_vReturnPos_x = @im_vReturnPos_x,
m_vReturnPos_y = @im_vReturnPos_y,
m_vReturnPos_z = @im_vReturnPos_z
-------------- (ADD: Version7-SkillSystem)
, SkillPoint = @im_SkillPoint
, SkillLv = @im_SkillLv
, SkillExp = @im_SkillExp
-------------- (Additional part)
, dwEventFlag =@idwEventFlag,
dwEventTime =@idwEventTime,
dwEventElapsed =@idwEventElapsed
-------------- (Additional part)
----------Additional start ----------
, PKValue = @im_nPKValue,
PKPropensity = @im_dwPKPropensity,
PKExp = @im_dwPKExp
----------Additional end ----------
----------Additional start ----------
, AngelExp= @im_nAngelExp
, AngelLevel= @im_nAngelLevel
----------Additional end ----------
--------------------- Version9 Pet
, m_dwPetId = @im_dwPetId
, m_nExpLog = @im_nExpLog
, m_nAngelExpLog = @im_nAngelExpLog
------------ Ver 11
, m_nCoupon = @im_nCoupon
, m_nLayer = @im_nLayer
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
-- if object_id('QUEST_TBL') is not null
-- EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray
--Relation of [song] present three request fact Bill rings
IF @im_dwSMTime > ''
BEGIN
IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer AND serverindex = @iserverindex)
UPDATE BILING_ITEM_TBL
SET m_dwSMTime = @im_dwSMTime
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
ELSE
INSERT BILING_ITEM_TBL
(m_idPlayer,serverindex,m_dwSMTime)
VALUES
(@im_idPlayer,@iserverindex,@im_dwSMTime)
END
ELSE
DELETE BILING_ITEM_TBL
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
-- UPDATE CARD_CUBE_TBL
-- SET m_Card = @im_Card,
-- m_apIndex_Card = @im_Index_Card,
-- m_dwObjIndex_Card= @im_ObjIndex_Card,
-- m_Cube = @im_Cube,
-- m_apIndex_Cube = @im_Index_Cube,
-- m_dwObjIndex_Cube=@im_ObjIndex_Cube
-- WHERE m_idPlayer = @im_idPlayer
-- AND serverindex = @iserverindex
UPDATE INVENTORY_TBL
SET m_Inventory = @im_Inventory,
m_apIndex = @im_apIndex,
m_adwEquipment = @im_adwEquipment,
m_dwObjIndex = @im_dwObjIndex
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE TASKBAR_TBL
SET m_aSlotApplet = @im_aSlotApplet,
m_aSlotQueue = @im_aSlotQueue,
m_SkillBar = @im_SkillBar
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE TASKBAR_ITEM_TBL
SET m_aSlotItem = @im_aSlotItem
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE BANK_TBL
SET m_Bank = @im_Bank,
m_apIndex_Bank = @im_apIndex_Bank,
m_dwObjIndex_Bank = @im_dwObjIndex_Bank,
m_dwGoldBank = @im_dwGoldBank
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE SKILLINFLUENCE_TBL
SET SkillInfluence = @iSkillInfluence
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE INVENTORY_EXT_TBL
SET m_extInventory = @im_extInventory,
m_InventoryPiercing = @im_InventoryPiercing
, szInventoryPet = @iszInventoryPet
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
UPDATE BANK_EXT_TBL
SET m_extBank = @im_extBank,
m_BankPiercing = @im_BankPiercing
, szBankPet = @iszBankPet
WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
SELECT fError = '1', fText = 'OK'
RETURN
END
/*
Information update
ex )
CHARACTER_STR 'U1', ALL ...
CHARACTER_STR 'U1','000001','01' ...
*/
ELSE
IF @iGu = 'U2' -- Total use time correction
BEGIN
UPDATE CHARACTER_TBL
SET TotalPlayTime = TotalPlayTime + @iplayerslot
WHERE m_szName = @im_szName
AND serverindex = @iserverindex
RETURN
END
/*
Total use time correction
ex )
CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
CHARACTER_STR 'U2','','01','','beat',10234
*/
ELSE
IF @iGu = 'U3' --Total use time correction new
BEGIN
UPDATE CHARACTER_TBL
SET TotalPlayTime = TotalPlayTime + @iplayerslot
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
RETURN
END
/*
Total use time correction (new)
ex )
CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
CHARACTER_STR 'U3','000001','01','','',10234
*/
ELSE
IF @iGu = 'U4' --Character life fringe land
BEGIN
IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE lower(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
BEGIN
SELECT fError = '0'
END
ELSE
BEGIN
UPDATE CHARACTER_TBL
SET m_szName = @im_szName
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
SELECT fError = '1'
END
RETURN
END
/*
Character life fringe land
ex)
CHARACTER_STR ' U4' @im_idPlayer, @iserverindex, @iaccount and @im_szName
CHARACTER_STR ' U4' ' 000001' ' 01' ' ' ' The morning star princess'
*/
ELSE
IF @iGu = 'D1' -- Character elimination
BEGIN
-- The part which the box tries to close once in the class arctic regions #1 2007-03-21
IF @im_szName = ''
BEGIN
SELECT fError = '1', fText = 'Resident number error'
RETURN
END
if not exists (select * from CHARACTER_TBL where m_idPlayer = @im_idPlayer and account = @iaccount and serverindex = @iserverindex)
begin
select fError = '1'
return
end
DECLARE @Exists int
-- IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN')
-- BEGIN
-- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (password = @im_szName OR member = 'B' ))
SET @Exists = 1
-- ELSE
-- SET @Exists = 0
-- END
-- ELSE
-- BEGIN
-- IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' ))
-- SET @Exists = 1
-- ELSE
-- SET @Exists = 0
-- END
IF @Exists > 0
BEGIN
DECLARE @currDate char(12)
SET @currDate = CONVERT(CHAR(8),GETDATE(),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)
IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND m_idWar > 0)
BEGIN
SELECT fError = '3', fText = 'In before guild'
RETURN
END
ELSE
BEGIN
UPDATE CHARACTER_TBL
SET isblock = 'D',
End_Time = @currDate ,
BlockTime = LEFT(@currDate,8)
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE MESSENGER_TBL
SET State = 'D'
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
UPDATE MESSENGER_TBL
SET State = 'D'
WHERE f_idPlayer = @im_idPlayer
AND serverindex = @iserverindex
/****************************************************************************************/
/** 200506 event **/
/****************************************************************************************/
-- if (not exists(select account from RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount)
-- and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12')
--
-- begin --: Of 1 or more month the account objective type writing which is not connection experience
-- declare @cash int,@get_cach int
-- select @cash = case when m_nLevel between 10 and 19 then 500
-- when m_nLevel between 20 and 39 then 1000
-- when m_nLevel between 40 and 49 then 1500
-- when m_nLevel between 50 and 59 then 2000
-- when m_nLevel between 60 and 69 then 2500
-- when m_nLevel >= 70 then 3000
-- else 0 end
-- from CHARACTER_TBL
-- where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
--
-- select @get_cach = isnull(sum(amount),0)
-- from RANKING_DBF.dbo.event_member_tbl
-- where account = @iaccount
-- group by account
--
-- if @cash + @get_cach > 5000
-- set @cash = 5000 - @get_cach
--
-- if @cash > 0
--
-- begin
-- declare @retcode int
--
-- if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount)
-- exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ',''
--
-- exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'Character compensation event',0,''
--
-- if @retcode <> 1
-- set @cash = 0
--
-- insert RANKING_DBF.dbo.event_member_tbl
-- (account,amount,m_idPlayer,serverindex,retcode,date)
-- values
-- (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate())
--
-- end
-- end
/****************************************************************************************/
/****************************************************************************************/
/****************************************************************************************/
-- The part which the box tries to close once in the class arctic regions #2 2007-03-21
IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex)
BEGIN
SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
RETURN
END
ELSE
BEGIN
SELECT fError = '0', fText = 'DELETE OK'
RETURN
END
END
END
ELSE
BEGIN
SELECT fError = '1', fText = 'Resident number error'
RETURN
END
-- At the price which is not eliminated unconditionally return
select fError = '1', fText = 'Resident number error'
END
/*
Character elimination
ex )
CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
CHARACTER_STR 'D1','001068','01','ata3k','1019311'
*/
ELSE
IF @iGu = 'I1' -- Initially information input
BEGIN
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
WHERE m_szName = @im_szName AND serverindex = @iserverindex)
BEGIN
SELECT fError = '0', fText = 'Character duplication!'
RETURN
END
ELSE
BEGIN
DECLARE
@om_idPlayer CHAR (7) ,
@om_vScale_x REAL ,
@om_dwMotion INT ,
@om_fAngle REAL ,
@om_nHitPoint INT ,
@om_nManaPoint INT ,
@om_nFatiguePoint INT ,
@om_dwRideItemIdx INT ,
@om_dwGold INT ,
@om_nJob INT ,
@om_pActMover VARCHAR(50) ,
@om_nStr INT ,
@om_nSta INT ,
@om_nDex INT ,
@om_nInt INT ,
@om_nLevel INT ,
@om_nExp1 BIGINT ,
@om_nExp2 BIGINT ,
@om_aJobSkill VARCHAR (500),
@om_aLicenseSkill VARCHAR (500),
@om_aJobLv VARCHAR (500),
@om_dwExpertLv INT ,
@om_idMarkingWorld INT ,
@om_vMarkingPos_x REAL ,
@om_vMarkingPos_y REAL ,
@om_vMarkingPos_z REAL ,
@om_nRemainGP INT ,
@om_nRemainLP INT ,
@om_nFlightLv INT ,
@om_nFxp INT ,
@om_nTxp INT ,
@om_lpQuestCntArray VARCHAR(1024),
@om_chAuthority CHAR(1) ,
@om_dwMode INT ,
@oblockby VARCHAR(32) ,
@oTotalPlayTime INT ,
@oisblock CHAR(1) ,
@oEnd_Time CHAR(12) ,
@om_Inventory VARCHAR(6940),
@om_apIndex VARCHAR(345) ,
@om_adwEquipment VARCHAR(135) ,
@om_aSlotApplet VARCHAR(3100),
@om_aSlotItem VARCHAR(6885),
@om_aSlotQueue VARCHAR(225),
@om_SkillBar SMALLINT,
@om_dwObjIndex VARCHAR(345) ,
@om_Card VARCHAR(1980),
@om_Cube VARCHAR(1980),
@om_apIndex_Card VARCHAR(215) ,
@om_dwObjIndex_Card VARCHAR(215) ,
@om_apIndex_Cube VARCHAR(215) ,
@om_dwObjIndex_Cube VARCHAR(215) ,
@om_idparty INT ,
--@om_nNumKill INT ,
@om_idMuerderer INT ,
--@om_nSlaughter INT ,
@om_nFame INT ,
@om_nDeathExp BIGINT ,
@om_nDeathLevel INT ,
@om_dwFlyTime INT ,
@om_nMessengerState INT ,
@om_Bank VARCHAR(4290),
@om_apIndex_Bank VARCHAR(215) ,
@om_dwObjIndex_Bank VARCHAR(215) ,
@om_dwGoldBank INT
IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE serverindex = @iserverindex)
SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
FROM CHARACTER_TBL
WHERE serverindex = @iserverindex
ELSE
SELECT @om_idPlayer = '0000001'
SELECT @om_vScale_x = m_vScale_x,
@om_dwMotion = m_dwMotion,
@om_fAngle = m_fAngle,
@om_nHitPoint = m_nHitPoint,
@om_nManaPoint = m_nManaPoint,
@om_nFatiguePoint = m_nFatiguePoint,
@om_dwRideItemIdx = m_dwRideItemIdx,
@om_dwGold = m_dwGold,
@om_nJob = m_nJob,
@om_pActMover = m_pActMover,
@om_nStr = m_nStr,
@om_nSta = m_nSta,
@om_nDex = m_nDex,
@om_nInt = m_nInt,
@om_nLevel = m_nLevel,
@om_nExp1 = m_nExp1,
@om_nExp2 = m_nExp2,
@om_aJobSkill = m_aJobSkill,
@om_aLicenseSkill = m_aLicenseSkill,
@om_aJobLv = m_aJobLv,
@om_dwExpertLv = m_dwExpertLv,
@om_idMarkingWorld = m_idMarkingWorld,
@om_vMarkingPos_x = m_vMarkingPos_x,
@om_vMarkingPos_y = m_vMarkingPos_y,
@om_vMarkingPos_z = m_vMarkingPos_z,
@om_nRemainGP = m_nRemainGP,
@om_nRemainLP = m_nRemainLP,
@om_nFlightLv = m_nFlightLv,
@om_nFxp = m_nFxp,
@om_nTxp = m_nTxp,
@om_lpQuestCntArray = m_lpQuestCntArray,
@om_chAuthority = m_chAuthority,
@om_dwMode = m_dwMode,
@oblockby = blockby,
@oTotalPlayTime = TotalPlayTime,
@oisblock = isblock,
@oEnd_Time = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
@om_Inventory = m_Inventory,
@om_apIndex = m_apIndex,
@om_adwEquipment = m_adwEquipment,
@om_aSlotApplet = m_aSlotApplet,
@om_aSlotItem = m_aSlotItem,
@om_aSlotQueue = m_aSlotQueue,
@om_SkillBar = m_SkillBar,
@om_dwObjIndex = m_dwObjIndex,
@om_Card = m_Card,
@om_Cube = m_Cube,
@om_apIndex_Card = m_apIndex_Card,
@om_dwObjIndex_Card = m_dwObjIndex_Card,
@om_apIndex_Cube = m_apIndex_Cube,
@om_dwObjIndex_Cube = m_dwObjIndex_Cube,
@om_idparty = m_idparty,
--@om_nNumKill = m_nNumKill,
@om_idMuerderer = m_idMuerderer,
--@om_nSlaughter = m_nSlaughter ,
@om_nFame = m_nFame,
@om_nDeathExp = m_nDeathExp,
@om_nDeathLevel = m_nDeathLevel,
@om_dwFlyTime = m_dwFlyTime,
@om_nMessengerState = m_nMessengerState,
@om_Bank = m_Bank,
@om_apIndex_Bank = m_apIndex_Bank,
@om_dwObjIndex_Bank = m_dwObjIndex_Bank,
@om_dwGoldBank = m_dwGoldBank
FROM BASE_VALUE_TBL
WHERE g_nSex = @im_dwSex
INSERT CHARACTER_TBL
(
m_idPlayer,
serverindex,
account,
m_szName,
playerslot,
dwWorldID,
m_dwIndex,
m_vScale_x,
m_dwMotion,
m_vPos_x,
m_vPos_y,
m_vPos_z,
m_fAngle,
m_szCharacterKey,
m_nHitPoint,
m_nManaPoint,
m_nFatiguePoint,
m_nFuel,
m_dwSkinSet,
m_dwHairMesh,
m_dwHairColor,
m_dwHeadMesh,
m_dwSex,
m_dwRideItemIdx,
m_dwGold,
m_nJob,
m_pActMover,
m_nStr,
m_nSta,
m_nDex,
m_nInt,
m_nLevel,
m_nMaximumLevel,
m_nExp1,
m_nExp2,
m_aJobSkill,
m_aLicenseSkill,
m_aJobLv,
m_dwExpertLv,
m_idMarkingWorld,
m_vMarkingPos_x,
m_vMarkingPos_y,
m_vMarkingPos_z,
m_nRemainGP,
m_nRemainLP,
m_nFlightLv,
m_nFxp,
m_nTxp,
m_lpQuestCntArray,
m_aCompleteQuest,
m_chAuthority,
m_dwMode,
m_idparty,
m_idCompany,
--m_nNumKill,
m_idMuerderer,
--m_nSlaughter,
m_nFame,
m_nDeathExp,
m_nDeathLevel,
m_dwFlyTime,
m_nMessengerState,
blockby,
TotalPlayTime,
isblock,
End_Time,
BlockTime,
CreateTime,
m_tmAccFuel,
m_tGuildMember,
m_dwSkillPoint,
m_dwReturnWorldID,
m_vReturnPos_x,
m_vReturnPos_y,
m_vReturnPos_z
)
VALUES
(
@om_idPlayer,
@iserverindex,
@iaccount,
@im_szName,
@iplayerslot,
@idwWorldID,
@im_dwIndex,
'1',
'0',
@im_vPos_x,
@im_vPos_y,
@im_vPos_z,
'0',
@im_szCharacterKey,
'230',
'63',
'32',
-1, --m_nFuel
@im_dwSkinSet,
@im_dwHairMesh,
@im_dwHairColor,
@im_dwHeadMesh,
@im_dwSex,
'0',
'0',
'0',
'1,0',
'15',
'15',
'15',
'15',
'1',
'1', --m_nMaximumLevel
'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',
'$',
'$', -- m_aCompleteQuest
'F',
'131072',
'0',
'0', -- m_idCompany
--@om_nNumKill,
'0',
--@om_nSlaughter,
'0',
'0',
'0',
'0' ,
'0',
@oblockby,
'0',
'F',
'200811030000',
CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
GETDATE(),
0,
CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2)
+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
0, --m_dwSkillPoint
1,
0,
0,
0
)
declare @invi1 VARCHAR(8000)
declare @invi2 VARCHAR(8000)
declare @invi3 VARCHAR(8000)
declare @invi4 VARCHAR(8000)
IF @im_dwSex = '1'
BEGIN
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/$'
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/$'
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/$'
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/$'
END
ELSE
BEGIN
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/$'
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/$'
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/$'
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/$'
END
INSERT INVENTORY_TBL
(
m_idPlayer,
serverindex,
m_Inventory,
m_apIndex,
m_adwEquipment,
m_dwObjIndex
)
VALUES
(
@om_idPlayer,
@iserverindex,
@invi1,
@invi2,
@invi3,
@invi4
)
IF @@SERVERNAME = 'WEB' OR @@SERVERNAME = 'SERVER4'
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/$'
INSERT TASKBAR_TBL
(
m_idPlayer,
serverindex,
m_aSlotApplet,
m_aSlotQueue,
m_SkillBar
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$',
'$',
'100'
)
INSERT TASKBAR_ITEM_TBL
(
m_idPlayer,
serverindex,
m_aSlotItem
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$'
)
INSERT BANK_TBL
(
m_idPlayer,
serverindex,
m_Bank,
m_BankPw,
m_apIndex_Bank,
m_dwObjIndex_Bank ,
m_dwGoldBank
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$',
'0000', -- m_BankPw
'$',
'$',
'0'
)
INSERT SKILLINFLUENCE_TBL
(
m_idPlayer,
serverindex,
SkillInfluence
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$'
)
INSERT INVENTORY_EXT_TBL
(
m_idPlayer,
serverindex,
m_extInventory,
m_InventoryPiercing,
szInventoryPet
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$','$','$'
)
INSERT BANK_EXT_TBL
(
m_idPlayer,
serverindex,
m_extBank,
m_BankPiercing,
szBankPet
)
VALUES
(
@om_idPlayer,
@iserverindex,
'$','$','$'
)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)
------------ Ver11 Pocket
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )
INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )
INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )
-------------- Ver13 Honor
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)
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)
/*
2007-06-21 ~ 2007-07-18 New character item urgent event
*/
declare @ntime datetime
select @ntime = getdate()
if(@ntime >= '2007-06-21 00:00:00.000' and @ntime <= '2007-07-18 23:59:59.999')
begin
declare @etime bigint
select @etime = cast(replace(replace(replace(convert(char(16), dateadd(d, 7, getdate()), 21), '-', ''), ' ', ''), ':', '') as bigint)
if(@im_dwSex = 0)
begin
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
select @om_idPlayer, @iserverindex, '15200', 1, @etime, '0000000'
end
if(@im_dwSex = 1)
begin
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, idSender)
select @om_idPlayer, @iserverindex, '26314', 1, '0000000'
insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_dwKeepTime, idSender)
select @om_idPlayer, @iserverindex, '15202', 1, @etime, '0000000'
end
end
SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
RETURN
END
END
set nocount off
RETURN
GO
Alles anzeigen
Danke für die Bemühungen aber es klappt immer noch nicht >.<
Sie haben noch kein Benutzerkonto auf unserer Seite? Registrieren Sie sich kostenlos und nehmen Sie an unserer Community teil!