-  ߰
1. Ӽ Ȯ
2. t_zonedata  Ȯ
3. t_mapinfo Ȯ
4. ش    Ȯ(t_npc_regen)
5.  Ȯ(t_npc)(t_npc_regen)
6. t_quest
7s. GameServer newStobm.bin Ȯ


-  
1. Exp.h  #define MAX_LEVEL
2. ش  ۰ ų Ȯ(t_item, t_skill, t_skillLevel, t_magic, t_magicLevel)
3.  ׸ : [  140 ] 

-   ų ߰s
1. t_special_skill

// ---------------- Zone ---------------- //

[ ]
   -  : 9
   - NPC : 180 ~ 190, 177, 218
   - ų(Ͱ): 149, 150, 151
     ų (Ͱ): 189, 190, 191

[ ]
   -  : 11
   - NPC : 210 ~ 214, 220
   - ų(Ͱ): 151
     ų (Ͱ): 191

[ ]
   -  : 12
   - NPC : 260 ~ 269
   - ų(Ͱ): 340, 341, 342
     ų (Ͱ): 350, 351, 352, 120

- ź ű 
1. #define DRATAN_CASTLE 
   #define NEW_GUILD
   #define NEW_GUILD_POINT_RANKING_NOTICE
   #define NEW_GUILD_BUG_FIX							
   #define PULSE_GUILD_POINT_UPDATE        (5 * 60)		
2. t_npc, t_npc_regen
3. t_item 
4. t_shop, t_shopitem
5. t_skill, t_skillLevel, t_magic, t_magicLevel
6. t_zonedata
7. t_castle_guard, t_castle_reinforce, t_castle_rebrith, t_castle_tower
8. SkillTool  a_learnGP Ȯ
9. ź ű  Data
 - ų 445~451,  489~501, NPC 351~401(400 SHOP), 404~406,  2380~2381


- ׿ 
0. #define DYNAMIC_DUNGEON
1. 21 ߰
2. npc 468 ~ 480 ߰(t_npc, t_npc_regen)
3. ׿  ų 476 ~ 482, 341
4.  522 ~ 529, 351
5. item : 2570 ~ 2581, 2766~2839


[Ʈ̾Ƴ]
   -  : 23 
   - NPC : 494 ~ 510
   - SHOP: 506 ~ 508, 510
   - : 2766 ~ 2839, 2854, 2859
   - ų(Ͱ): 494 ~ 503, 511 ~ 513, 564
     ų (Ͱ): 542 ~ 558, 563, 590

[ȥ ž 8~10]
   - npc : 325~330, 332, 333, 339
   - zone : 18, 19, 20

[Ʈ̾Ƴ  3]
    - t_item			:	3004 ~ 3005, 3167 ~ 3178, 3018 ~ 3163
	- t_npc				:	835 ~ 842, 844 ~ 859
	- t_skill			:	570 ~ 588
	- t_magic			:	594 ~ 606
	- t_special_skill	:	49 ~ 50
	- t_zonedata		:	23, 26 ~ 28
	- t_mapinfo			:	23


// ---------------- Event ---------------- //
- OX  
1. OXQuiz ö¡  
2. #define ENABLE_OXQUIZ	// OX  Ȱȭ
3. 14  ߰(t_zonedata)
4. #define OX_QUIZ_COUNTRY_CODE		ڵ	//  OX  ڵ

- Ȱ ̺Ʈ
#define EVENT_EGGS_HUNT_2007
#define EVENT_EGGS_HUNT_2008_ITEM
t_item ִ Ȯϰ ߰
  2148 
  85  ü
  723  
  45   üȸ 
  883 õ   
  885  

-   ̺Ʈ
   - #define : EVENT_GOMDORI_2007
   - Item : 2335 ~ 2343
   - ǰ : 2149~2172(ü)
   -  : 2173 ~ 2184
   - npc : 340(ξ)
   - DB table : t_event_gomdori_2007

-  ̺Ʈ
1. #define EVENT_RAIN_2006 20
2. ,  Ȯ(1517, 1518)
3.   Ȯ(556, 45, 500, 501, 498, 499, 973, 972, 85)

- ǵ ̺Ʈ
1. #define EVENT_HALLOWEEN_2006	26		// ҷ ̺Ʈ 
	#define PANDOR_REGEN_TIME		PULSE_REAL_TENMIN // ǵ      10  
2.  (314 ~ 320)Ȯ     t_npc  Ȯ 
3.  17(723, 85, 498, 499, 500, 501, 19, 43, 44, 45, 1334, 1331, 1338, 1335, 1336, 1340, 1342) Ȯ

- ä̺Ʈ
1.
#define EVENT_COLLECT_BUG		
#define EVENT_COLLECT_BUG_DROP

2. Ȯ
:1577, 1578
: 19,47,724,45, 723,1628,1629,1627,85
: 1579,1580,1581,1582,1583,1584,1585,1586,1587,1588


-  ̺Ʈ
1. 
#define EVENT_SUMMER_VACATION_2007		41		// 2007   ̺Ʈ
#ifdef EVENT_SUMMER_VACATION_2007
#define PAPER_FIGURE_GREEN_FLOWER		1
#define PAPER_FIGURE_RED_FROG			2
#define PAPER_FIGURE_RED_CRANE			3
#define PAPER_FIGURE_RED_DRAGON			4
#define PAPER_FIGURE_SILVER_FROG		5
#define PAPER_FIGURE_SILVER_CRANE		6
#define PAPER_FIGURE_SILVER_DRAGON		7
#define PAPER_FIGURE_GOLD_FROG			8
#define PAPER_FIGURE_GOLD_CRANE			9
#define PAPER_FIGURE_GOLD_DRAGON		10

#define GREEN_PAPER_ITEM				2367			
#define RED_PAPER_ITEM					2368
#define SILVER_PAPER_ITEM				2369
#define GOLD_PAPER_ITEM					2370
#endif // EVENT_SUMMER_VACATION_2007

2.  
 : 2367, 2368, 2369, 2370


- 2007 ҷ ̺Ʈ
1. EVENT_HALLOWEEN_2007
2. t_npc_regen(454, 455), t_item(2464-2491), t_npc(454, 455), 
	t_skill t_skillLevel (470-474), t_magic t_magicLevel(518-519)
3. t_event_halloween2007
4. #define FIRECRACKER_ITEM				2403     


-   ̺Ʈ
1. EVENT_INDEPENDENCE_DAY_2007_USA
2. t_item 2409, 2410, 2411, 2412, 2413, 2414, 2415, 2416
3. t_skill t_skillLevel 437, 438
4. t_magic t_magicLevel 481, 482, 483


[ ũ ̺Ʈ 2006 ]
  - #define : EVENT_XMAS_2006, PULSE_XMAS_2006_MOVE, EVENT_XMAS_2006_NODROP_HAT(Ÿ   )
  - npc : 334, 335, 336
  - Item : 1975, 1976, 1844, 1977

- ũ ̺Ʈ 2007
1. #define EVENT_XMAS_2007						50
2. #define PET_TURNTO_NPC
3. chardb t_pet add column a_pet_turnto_npc int(11) default 0
4. authdb add table t_event_xmastree_point
3. t_item(2584 ~ 2618) 󺰷 ̰ 
4. t_skill t_skillLevel (485 ~ 490)
5. t_magic t_magicLevel (530 ~ 532)
6. t_npc(483, 484, 485, 486), t_npc_regen (486, 484) 
7. ̺Ʈ   Ʒ  CharDB  (絹    Ǯ )
   update t_pet set a_pet_turnto_npc = 0 where a_pet_turnto_npc = 485;

- ų ̺Ʈ 2008
1. #define NEWYEAR_EVENT_2008					51
2. t_skill t_skillLevel (491, 492)
3. t_magic t_magicLevel (533, 534, 535, 536)


-  Ÿ ̺Ʈ( )
1. #define EVENT_OPEN_BETA_GIFT
2. #define		ETC_EVENT_OPEN_BETA_GIFT				(1 << 3)
3. t_item  (460, 427, 462, 461, 951, 1069) Ȯ

- 귯 ̺Ʈ(2008  ̺Ʈ)
1. #define EVENT_VALENTINE_2007				52		// 2008⵵  ̺Ʈ
2. #define EVENT_VALENTINE_2008_ITEM
3.  2629 - 2636, 508, 509, 2033, 2034, 2382, 1819, 779 Ȯ
3. shop item 2632, 2633 Ȯ


- ߷Ÿ ̺Ʈ 2007 
1.  #define EVENT_VALENTINE_2007			29
2.  2043, 2044, 2045, 2046, 2047, 2048, 2049, 2050, 971, 973, 1820, 1819, 1821, 1822, 779 Ȯ
3. shop item 2046, 2047 Ȯ
4. skill 417 Ȯ (magic 459, 460)


- 2008  ̺Ʈ
1. SAKURA_EVENT_2008
2. npc npc_regen 341  // , 342 <- ̺Ʈ ƴ
3. item 2345, 2747

[ ]
  - #define : EVENT_PEPERO
  - item  : 1056, 1057 (skill )



[ǳ ̺Ʈ - Local]
   - #define : EVENT_RICHYEAR_2007
   - Item : 876~881, 2422
   -  : 723,884,2347,2143,2142

[Ǵн ̺Ʈ]
  - #define EVENT_PHOENIX
  - t_charaters ̺ a_phoenix(int) ߰ : DB int(11)     ALTER TABLE `t_characters` ADD `a_phoenix` INT(11) DEFAULT -1 NOT NULL AFTER `a_lastpktime`;
  - t_pet ̺ a_color(char)  : char(1)  char(2)    ALTER TABLE `t_pet` CHANGE `a_color` `a_color` CHAR(2)  DEFAULT "0" NOT NULL;
  - t_skill, t_skillLevel : 516, 589
  - t_magic, t_magicLevel : 591~593, 607
  - t_item                : 3006~3011, 3217 ~ 3262
  - t_npc, t_npc_regen    : 834


[īϹ ̺Ʈ]
    - t_npc : 334, 335
    - t_item : 2619 ~ 2628, 2637 ~ 2641
	- #define EVENT_XMAS_2006
	- #define EVENT_CARNIVAL

[߼̺Ʈ] - , ̱ ߼ ̺Ʈ
   - #define : EVENT_CHUSEOK_2006, EVENT_CHUSEOK_2006_GIFT
   - Item : 1814, 1815, 1816, 1817, 1818
   - skill : 388
   - magic : 420, 358

[߷Ÿ ̺Ʈ 2009]
    - #define : EVENT_VALENTINE_2007, EVENT_VALENTINE_2009_ITEM
    - t_item			:	2043 ~ 2050, 971, 973, 1820, 1819, 884, 85, 2844
	- t_shoptitem		:	2046, 2047
    - t_skill           :   417
    - t_magic           :   459, 460

[ʺ  ̺Ʈ]
    - #define HANARO_EVENT
	- t_item				: 740 741 2658 2659 2667
	- t_skill, t_skillLevel : 654
	- t_magic, magicLevel	: 408 409
	- t_npc, t_npc_regen	: 893

[߷Ÿ ̺Ʈ(귯) 2010]

	- #define : EVENT_VALENTINE_2007, EVENT_VALENTINE_2008_ITEM
	(  ߰ - ̺Ʈ  )
	- t_item	: 4946 ~ 4965, 5020 ~ 5054
	

// ---------------- System or Etc.. ---------------- //

- ̵ 
1.
#define MONSTER_RAID_SYSTEM				//  ̵ ý
#ifdef MONSTER_RAID_SYSTEM
#define RAID_NPC_RAGE_SKILL				394		// ̵  г ų ε
#define RAID_NPC_RAGE_SKILL_LEVEL		2		// ̵  г ų 
#define RAID_NPC_NOTICE_CELL_EXT		5
#define MAX_RARE_OPTION_SETTING			10		//  ɼǴ ɼ  
#define MAX_RARE_OPTION_ITEM			10		// ۴  ɼ 
#endif

#define PULSE_MONSTER_RAID_MOVE		(14 * PULSE_REAL_MIN)	//  ̵ ̵ ð

2.  307, 308, 309, 331 Ȯ(t_npc, t_npc_regen)
3. newproject_data.t_npc_dropraid Ȯ
4.  673, 168 1828 - 1837 Ȯ(t_item)
5. ų 390, 391, 392, 393 Ȯ(t_skill, t_skillLevel)
6.  421 ~ 425 Ȯ(t_magic, t_magicLevel)
7. dataDB :  Ϸ Ȯ  newproject_data.t_rareoption  ű
8. t_rareoption 
9. Area.cpp Line : 708, 734  ߰ؾ 뿡 ߷ ȯ


-  ູ
1. #define BLESS_WARRIOR
2. NPC Ȯ(310, 311, 312, 313)
3. ITEM Ȯ(85, 391, 884, 883, 786, 1315, 490, 1314, 493)


-   7
1. 
#define PET_NAME_CHANGE			//  ̸ 
#define PET_EXP_UP				//  ġ 
#define BLOOD_SWEAT_FRUIT		// ǿ  
#define CASH_EXCHANGE_EQUIP		//    ȯ
#define MP_STEEL_POTION			// MP ƿ 
#define HP_STEEL_POTION			// HP ƿ 

2. Data Ȯ
Item : ( 2355, 2356, 2357, 2358, 2359, 2360, 2361 )
Skill, SkillLevel : ( 439, 440, 441, 442)
Magic, MagicLevel : ( 484, 485, 486 ) 


-  
1.  1706, 1707, 1710, 1711
2. Ʈ 145, 146


-  ȣ 
#define RUNE_PROTECTION_ITEM
#ifdef RUNE_PROTECTION_ITEM
#define LOW_RUNE_PROTECTION_ITEM		2394
#define HIGH_RUNE_PROTECTION_ITEM		2395
#endif // RUNE_PROTECTION_ITEM

-  ȭ 
#define PET_DIFFERENTIATION_ITEM
#ifdef PET_DIFFERENTIATION_ITEM
#define PET_RED_COLOR_ITEM				2396	// 
#define PET_SCARLET_COLOR_ITEM			2397	// ȫ
#define PET_YELLOW_COLOR_ITEM			2398	// 
#define PET_GREEN_COLOR_ITEM			2399	// ʷ
#define PET_BLUE_COLOR_ITEM				2400	// Ķ
#define PET_DEEP_BLUE_COLOR_ITEM		2401	// 
#define PET_VIOLET_COLOR_ITEM			2402	// 
#endif //PET_DIFFERENTIATION_ITEM

t_pet add column a_color

-  
#define FIRECRACKER_ITEM				2403

- ڵ  
#define AUTO_POTION		
#ifdef	AUTO_POTION
#define ONE_PERIOD_ITEM					2404
#define SEVEN_PERIOD_ITEM				2405
#define THIRTY_PERIOD_ITEM				2406
#endif	// AUTO_POTION

-  
#define COMPETITION_ITEM
#ifdef COMPETITION_ITEM
#define EXPERIENCE_COMPETITION_ITEM		2407
#define	PERIOD_COMPETITION_ITEM			2408
#define USE_COMPETITION_ITEM_NAS		1000


- ű  
1. NEW_GUILDE NEW_GUILD_POINT_RANKING_NOTICE
2. t_skill t_skillLevel 443, 444 ( t_skillLevel  a_learnGP ߰)
3. t_magic t_magicLevel 487, 488
4. t_extend_guild, t_extend_guildmember, t_guild_notice
5. t_characters_guildpoint
6. 

- ű  ġ  
1. update t_extend_guildmember set a_contribute_exp = 'ϰ ϴ ִ ۼƮ' where a_contribute_exp > 'ϰ ϴ ִ ۼƮ';


-   
(** ATTACK_PET  ̸ ATTACK_PET    Ѵ.)
1. #define EVENT_NEW_MOONSTONE
2. newproject_data t_moonstone_reward
3. 2552, 2553, 2554, 2555, 2556, 2544, 2545, 2546, 2547, 2548


-  ֹ  ð
1. #define COMPOSITE_TIME					//
2. t_invenxx  a_used0_2, a_used1_2, a_used2_2, a_used3_2,  a_used4_2 ߰
3. t_stashxx  a_used_2 ߰
3. t_auto_give  a_item_used2 ߰
4.  ߰ ÷ ʱⰪ -1 ؾ Ѵ.
5. ð  m_num4 ð 

- 80  
select * from newproject_data.t_item
where (a_index>=2501 AND a_index<=2512) 
OR (a_index>=2570 AND a_index<=2581) 
OR (a_index>=2797 AND a_index<=2808) 
OR (a_index>=2513 AND a_index<=2543) 
OR (a_index>=2766 AND a_index<=2796) 
OR (a_index>=2809 AND a_index<=2839) 

[ ޺]
  - #define : MONSTER_COMBO, MONSTER_COMBO_COIN_CHANGE
  - mysqldump : t_missioncase , t_npc_regen_combo, t_item, t_penalty, t_action  | t_zonedata(22), t_shop, t_shopitem
  - db  : t_missioncase  ʵ  Ȯ
  -  ޺  .sat .sht
  - npc : 488, 489, 490, 491, 492
    shop_npc : ޺ (488), ޺ (489)
    shop_item 
	2740, 2741, 2742, 2743, 2744
	2715, 2716, 2717, 2718, 2719
	2720, 2721, 2722, 2723, 2724
	2725, 2726, 2727, 2728, 2729
	2730, 2731, 2732, 2733, 2734
	2735, 2736, 2737, 2738, 2739 
	2710, 2711, 2712, 2713, 2714

[Non-PvP] - (* NON_PK_SYSTEM define Ǿ ־ Ѵ.)
 - Server.cpp : LoadSettingFile()  ߰
 - newStobm.bin : [Server]׸ NON_PK=TRUE/FALSE ߰



[ Ǽ縮 4]
   - #define : NEW_ACCERY_ADD
   - Item : 2039~2042

[īڴ]
   - #define : LAKA_PRESSCORPS
   - Item : 2882(Ȯ)
   - DB table : t_event_presscorps

[PvP zone - Ʒ/24]
   - npc : 519, 520
   - zonedata : 24
   - teleport_tax : 24


[ű  -   ý]
   - #define : ATTACK_PET
   - item : 2896~2898, 2900~2914, 2947~2967, 2970~2976
   - npc : 512, 513, 517
   - npc_regen : 1 512, 7 513
   - skill : 556~563
   - magic : 579~589
   - rareoption : 104~121
   - quest : 162 ~ 177
   - shop : 0 517
   - newproject_data : t_moonstone_reward, t_bigpet
   - newproject_db : t_apets, t_apets_inven
-- ATTACK_PET --
data
t_item
t_skill
t_skillLevel
t_magic
t_magicLevel
t_npc
t_npc_regen
t_bigpet
t_quest

db
t_apets
t_apets_inven

[ AI]
   - #defined : APET_AI
   - newproject_db : t_apets_ai
                     t_apets a_ai_enable, a_ai_slot ʵ ߰
   - Item : AI ..

[ű UI]
   - #defined : NEW_UI, COMPOSITE_TIME

[ġ 2 ̺ ]
  - #defined : LC_KOR_EXP_DOWN2
  - svn   "ѹ"


[ α׷  ]
   - #define DISCONNECT_HACK_CHARACTER 
   - charDB : t_hack_characters
CREATE TABLE `t_hack_characters` (
	`a_index` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`a_user_idx` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`a_user_id` VARCHAR(20) NULL,
	`a_char_idx` INT(11) UNSIGNED NOT NULL DEFAULT '0',
	`a_char_id` VARCHAR(20) NULL,
	`a_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_hacktype` VARCHAR(20) NULL,
	`a_delay` FLOAT NOT NULL DEFAULT '0',
	PRIMARY KEY (`a_index`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT


[äñ]
   - #define NO_CHATTING 
   - newproject_db : t_characters  m_flag ʵ尡 ִ Ȯ


[ť]
   - #define EXTREME_CUBE (#defined MONSTER_COMBO_GOLDBOX   Ǿ )
   - #define EXTREME_CUBE_TIMEREG
   - newproject_data : t_npc_cube, t_npc_regen_cube ̺ ߰
   - t_shop : 521 ~ 525
   - t_shopitem : 2986, 2987
   - t_zonedata : 25 
   - t_item : 2986, 2987, 3529 ~ 3543
   - t_npc : 521 ~ 833
   - t_regdate
   - newproject_db_071120_ger: t_cubepoint, t_cubepoint_personal ̺ ߰( ť)

[ť갳]
   - #define EXTREME_CUBE_VER2
   - newproject_data
	 t_item : 5972~5973, 5975~6079, 6100	
	 t_quest : 384~385	
	 t_skill : 1066~1070, 1075, 1086~1091		
	 t_magic : 937~940, 949, 985~991	
	 t_title : 9, 10	
	 t_luckydrawbox : 43~47	
	 t_npc : 531~833	
	 t_set_item : 44~57	
   - newproject_db
	 t_cubepoint, t_cubepoint_personal ( Ʋ ٽ ־ )
	 ALTER TABLE `t_cubepoint`  ADD COLUMN `a_week_date` INT(11) NOT NULL DEFAULT '0' FIRST;
	 ALTER TABLE `t_cubepoint`  DROP PRIMARY KEY,  ADD PRIMARY KEY (`a_week_date`, `a_guild_index`);
	 ALTER TABLE `t_cubepoint_personal`  ADD COLUMN `a_week_date` INT(11) NOT NULL DEFAULT '0' FIRST;
	 ALTER TABLE `t_cubepoint_personal`  DROP PRIMARY KEY,  ADD PRIMARY KEY (`a_week_date`, `a_char_idx`);
	 t_cuberank
   - Cube_1536_1536_0.sat Ӽ
   - t_zonedata a_zone_index = 25;

[ŷ]
	- #define TRADE_AGENT 
	- newproject_db(char db) : t_tradeagent 
	- t_npc : 899, 900

[  ġ]
   - t_item :				2854, 2899, 3577 ~ 3583
   - t_skill t_skillLevel : 71, 241 ~ 243
   - t_magic t_magicLevel : 129, 268 ~ 270

[  140 ]
  - #define LC_KOR_EXP_LOAD_DB
  - ּó : //#define LC_KOR_EXP_DOWN2
  - newproject_data t_exp

[Ȯ ۾]
1. newproject_data
  -   Ʈ ̸ ߰
   -- ALTER TABLE `t_set_item` ADD `a_set_name_usa` VARCHAR(50)  NOT NULL
   -- ALTER TABLE `t_factory_item` ADD `a_name_usa` VARCHAR(50)  NOT NULL
   -- ALTER TABLE `t_affinity` ADD `a_name_usa` VARCHAR(50) NOT NULL

  - newproject_data t_npc_regen   ̿Ѵ.
    select a_zone_num, a_npc_idx, a_pos_x, a_pos_z, a_pos_h, a_pos_r, a_y_layer, a_regen_sec, a_total_num from t_npc_regen where a_zone_num in (0, 15, 27, 28, 29, 30, 31, 34);

  - newproject_data t_action t_affinity t_affinity_npc t_affinity_reward_item t_affinity_work t_factory_item t_magic t_magicLevel t_mapinfo t_npc_dropraid 
    t_npc_regen_raid t_option t_rareoption t_set_item t_shop t_shopitem t_trigger_set t_zonedata t_item t_npc t_quest t_skill t_skillLevel t_exp ̺ ä ´.

  - Ÿ   Ű   ʿ ÷ ߰
		ALTER TABLE `t_skill` ADD `a_soul_consum` 	       INT(4)  	DEFAULT "0"  NOT NULL AFTER `a_targetparam`;
		ALTER TABLE `t_skill` ADD `a_use_needWearingType` INT(11)  DEFAULT "-1" NOT NULL AFTER `a_useWeaponType1`;
		ALTER TABLE `t_skill` ADD `a_app_needWearingType` INT(11)  DEFAULT "-1" NOT NULL AFTER `a_appWeaponType1`;
		ALTER TABLE `t_skill` ADD `a_cd_fe_after` VARCHAR(255)  DEFAULT " " NOT NULL AFTER `a_cd_dd`;
		ALTER TABLE `t_skill` ADD `a_cd_fe_after2` VARCHAR(255)  DEFAULT " " NOT NULL AFTER `a_cd_fe_after`;
		ALTER TABLE `t_npc` ADD `a_skill2` VARCHAR(255)  DEFAULT " -1" NOT NULL AFTER `a_skill1`;
		ALTER TABLE `t_npc` ADD `a_skill3` VARCHAR(255)  DEFAULT " -1" NOT NULL AFTER `a_skill2`;
		ALTER TABLE `t_magic` ADD `a_togle` TINYINT(1)  UNSIGNED DEFAULT "0" NOT NULL;
		ALTER TABLE t_quest ADD a_opt_prize_type5  INT NOT NULL DEFAULT -1;
		ALTER TABLE t_quest ADD a_opt_prize_index5 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_opt_prize_data5 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_opt_prize_plus5 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_opt_prize_type6 INT NOT NULL DEFAULT -1;
		ALTER TABLE t_quest ADD a_opt_prize_index6 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_opt_prize_data6 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_opt_prize_plus6 INT NOT NULL DEFAULT 0;
		ALTER TABLE t_quest ADD a_only_opt_prize INT NOT NULL DEFAULT 0;
		ALTER TABLE `t_item` ADD `a_attack_effect_name` VARCHAR(255)  AFTER `a_effect_name`;
		ALTER TABLE `t_item` ADD `a_damage_effect_name` VARCHAR(255)  AFTER `a_attack_effect_name`;
		ALTER TABLE `t_npc` ADD `a_ai_summonHp` INT(11)  DEFAULT "0" NOT NULL  AFTER `a_aileader_flag`;
		ALTER TABLE `t_quest` ADD `a_failvalue` INT(11)  DEFAULT "-1" NOT NULL  AFTER `a_desc3_rus`;
		ALTER TABLE `t_quest` ADD `a_partyscale` INT(11)  DEFAULT "0" NOT NULL  AFTER `a_failvalue`;

  - npc ξ(340)  Ǵн Ŭ (834) ǥ ߺ. ʿ信    ϳ disable Ű. 
	update t_npc set a_enable = 0 where a_index = 340;
	update t_npc set a_enable = 1 where a_index = 834;
	update t_item set a_enable = 0 where a_index = 4790;
	update t_item set a_enable = 0 where a_index between 4910 and 4914;
	update t_item set a_enable = 0 where a_index between 4933 and 4939;
	update t_npc_regen_raid set a_pos_x = 881, a_pos_z = 404, a_pos_h = 0.5125 where a_npc_idx = 965;
	delete from t_item where a_enable = 0;

2. newproject_db
  - ĳ ̺ ÷ ߰
   -- ALTER TABLE `t_characters` ADD `a_seal_skill_index` VARCHAR(255)  NOT NULL AFTER `a_etc_skill_level`;
   -- ALTER TABLE `t_characters` ADD `a_seal_skill_exp` VARCHAR(255)  NOT NULL AFTER `a_seal_skill_index`;

  - t_trigger_saveinfo t_affinity_keep t_affinity_reward_step t_inzonejoin t_characters_factory ̺ 
  - t_characters a_admin default 10 -> 0 ٲ۴. (ALTER)
  - t_inzonejoin
  - t_questdata
	ALTER TABLE t_questdata00 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata01 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata02 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata03 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata04 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata05 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata06 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata07 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata08 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata09 ADD a_quest_failvalue INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata00 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata01 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata02 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata03 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata04 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata05 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata06 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata07 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata08 ADD a_complete_time INT NOT NULL DEFAULT 0;
	ALTER TABLE t_questdata09 ADD a_complete_time INT NOT NULL DEFAULT 0;


3.  Config_Localize 
	#define NIGHT_SHADOW							//  Ʈ 
	#define ENABLE_BACKWING							//   
	#define SET_ITEM                                // Ʈ 
	#define RUNE_UPGRADE                            // þƮ
	#define FACTORY_SYSTEM                          //  ý
	#define PARTY_RAID								// Ƽ Ÿ Ȯ
	#define	EXPEDITION_RAID							//  
	#define RAID									// ̵
	#define	QUEST_EXTEND							// Ʈ Ȯ
	#define TRIGGER_SYSTEM							// Ʈ ý
	#define RAID_NPC_REGEN							// ̵ npc  level ϱ
	#define NIGHTSHADOW_SKILL						// Ʈ  ų
	#define RAID_MONSTER_SKILL						// ̵  ų
	#define AFFINITY
	#define PARTY_ONLINESYSTEM						// Ƽ ¶ ý
	#define EXPEND_ONLINESYSTEM						// ¶νý
	#define RESTRICT_PVP_SKILL         3			//  ų Ģ :  Ÿ Ǿ  , PK,   κ/ Ұ
													//  ܿ κƼ Ƚ ־ ϴ define
	#define UNION_EXPEDITION_TRIGGER				//  Ʈ  ġ(̵ κ)
	#define RAID_CASHITEM							// ̵  ĳ 

	#define NS_CREATE_CARD						// Ʈ  ī
	#define NPC_PORTAL_SCROLL					// npc Ż ũ
	#define QUEST_RESTORE_ABANDON				//  Ʈ 
	#define ITEM_PLUS_VALANCE_2010				// Item Plus ġ  (Ŭ̾Ʈ Ȯ ٰ)

4.  ̵  űĳ  ۾
	- newstobm.bin 33, 34, 35 
	- UPDATE t_item SET a_enable=0 WHERE a_job_flag=64;

5. Exp.h   165  
    - 140 ̻ʹ [  140 ] Ͽ ٲ 



[ŷ  и]

1. #define SUB_HELPER

2. newStombn.bin
	[SubHelper Server]
	IP=61.104.44.150
	Port=4101


[NHN ű Ʃ丮]
1. #define NEW_TUTORIAL
2. t_zonedata : 0 ()


[Ű ο ]
1. #define LUCKYDRAWBOX_TOOL
2. db ̺
	newproejct_data < t_luckydrawbox	
	newproejct_data < t_luckydrawResult 
	newproejct_data < t_luckydrawNeed
3. LuckyDrawBox.exe ؿܷ ߰Ѵ.(config.bin ߰)
4. t_item : (25 , Ͱ ־  ٽ ִ´.)
   2037, 2544, 2597, 2887, 2888, 2889, 2890, 2891, 2892, 2893, 2968, 3576, 
   3713, 3714, 3715, 3716, 3717, 3718, 3762, 4664, 4786, 4787, 4788, 4915, 4916
   ( ߰Ǵ  ITEM_FLAG_BOX ÷׸ ̿Ͽ ˻.)


[ؿ   ] : ű     
1. #define INTERNATIONAL_LOCAL_ACCESS_RESTRICTIONS
2. newproject_db_auth   t_iplist

[ؿ    - new  ] :   , ű  
1. #define INTERNATIONAL_LOCAL_ACCESS_RESTRICTIONS_NEW_USER
2. newproject_db_auth   t_iplist

[ ̺Ʈ]
1. #define REQUITAL_EVENT
2. newproject_data
  - t_requital_setup
3. newproject_db_auth
  - t_requital_check0
  - t_requital_check1
  - t_requital_log
4. Connector ҽ κ  ʿ䰡  Ѵ.
  - Ʈ  ҽ κ Ȯ
5. Requital Event Tool 
  - ̺Ʈ ǰ   
  - ¥   ȵǾ ִ. ~!
6. npc 408


[NHN npcŻ ũ]
1. #define NPC_PORTAL_SCROLL
2. item : 4790

[Ʈ  ī]
1. #define NS_CREATE_CARD
2. item : 4914
3. ĳ : t_nscard

[̵  巹  && ̵  ͼ ʱȭ ī]
#define UNION_EXPEDITION_TRIGGER				//  Ʈ  ġ(̵ κ)
#define RAID_CASHITEM							// ̵  ĳ 
item : 4911, 4913

[  ̻ ȸ ]
item : 4912
skill, skillLevel : 927
magic, magicLevel : 816

[ϱذ ]
1. item : 531, 662~664, 2897, 2900~2914, 2970, 2980, 2984, 2985, 3165, 3166, 3765, 3766, 4867~4909
2. skill, skillLevel : 928~948, 557~560
3. magic, magicLevel : 817~837, 579~582
4. quest : 334
5. SHOP, shopitem : 517(0), 1031(32) ( Ǹǰ ), 235(0, 4)
6. NPC : 1032(32) (ȭ ޴ ߰)
7. ATTACK_PET  Ʈ Ǿ 
8. t_bigpet : 4 ~ 6
  - ALTER TABLE `t_bigpet` ADD `a_evo_level` INT(11)  DEFAULT "0" NOT NULL;
  - ALTER TABLE `t_bigpet` ADD `a_evo_idx` INT(11)  DEFAULT "0" NOT NULL;

[Ծ]
1. item : 4969~4972
2. skill, skillLevel : 972~991, 994
3. magic, magicLevel : 857~876
4. quest : 335
8. t_bigpet : 7 ~ 9

[Ҵ]
1. t_item : 5944 ~ 5947
2. t_skill, t_skillLevel : 1034 ~ 1054
3. t_magic, t_magicLevel : 928, 817 ~ 837
4. t_quest : 362
5. t_bigpet : 11, 12, 13

[̸ / ƽī  Ƽ ]

#define CONTINENT_PARTY_RECALL			//  Ƽ  ߰

ǻ : ̸ , ƽī  Ͽ Ƽ ϴ ̱ 
                Ƽ   .

 Ƽ item 		: 1298, 1299, 1300, 1413, 1414, 1415
 Ƽ item	: 2945(̸ Ƽ ױ)
						  2946(ƽī Ƽ ױ)

̸  (Zone_1 ~ Zone_31)
ƽī  (Zone32~ )
  Zone  ߰  ɼ .
   ο  ߰  .

  t_zonedata ѹ ߰.
1. t_zonedata
	- ALTER TABLE `t_zonedata` ADD `a_continent_no` TINYINT(4) DEFAULT -1 NOT NULL;
    - UPDATE t_zonedata set a_continent_no = 0 where a_zone_index <= 31;
	- UPDATE t_zonedata set a_continent_no = 1 where a_zone_index >= 32;

 
-1 : ̼ 
0  : ̸ 
1  : ƽī 

GameServer Class CZone 
int m_iContinent_no zonedata ε  ȣ .

[ȣĪ ý]
1.	#define TITLE_SYSTEM
2.	newproject_data (data DB)
	- t_title ̺ ߰ (SVN\DevDoc\TitleSystem\dataDB_title.sql)

3.	newproject_db (char DB)
	- t_characters ̺ a_title_index ʵ ߰ (SVN\DevDoc\TitleSystem\charDB_add_field.sql)
	- t_titlelist ̺ ߰ (SVN\DevDoc\TitleSystem\charDB_Create_table.sql)

4.  Ӽ
	-  Type : ȸ -> Subtype : ȣĪ(IONCE_TITLE)
	- ȣĪ    (  index 5005, 5006 item ߰Ǿ .) - 2010/01/18	

5. Ÿ 
	- DB ó SubHelper.

[ Ʈ  Ʈ ]
1. #define QUEST_EXTEND_REPEAT_DAY
2. newproject_data t_quest: a_type2 2 
3. newproject_db t_questdata: a_complete_time, a_quest_failvalue ߰
	- alter table t_questdata add a_complete_time int not null default 0;
	- alter table t_questdata add a_quest_failvalue int not null default 0;

[Ӽ ανõ ]
1. #define LOGIN_TIME_CHECK
2.  t_users:
	- ALTER TABLE t_users ADD a_login_time INT NOT NULL DEFAULT 0;
	- ALTER TABLE t_users ADD a_restart INT NOT NULL DEFAULT 0;

[Ȯ 2 - Ʈ Ʈ]
1. #define QUEST_TRIGGER
2. data DB
	ALTER TABLE `t_quest` ADD `a_start_give_item` VARCHAR(50) NOT NULL;
	ALTER TABLE `t_quest` ADD `a_start_give_kindcount` INT(5) NOT NULL AFTER `a_start_give_item` ;
	ALTER TABLE `t_quest` ADD `a_start_give_numcount` VARCHAR(50) NOT NULL AFTER `a_start_give_kindcount` ;
	ALTER TABLE `t_quest` ADD `a_start_trigger_id` INT(11) NOT NULL AFTER `a_start_give_numcount` ;
	ALTER TABLE `t_quest` ADD `a_quest_flag` INT(11) NOT NULL AFTER `a_start_trigger_id` ;

	ALTER TABLE `t_item` ADD `a_quest_trigger_count` INT(3) NOT NULL;
	ALTER TABLE `t_item` ADD `a_quest_trigger_ids` VARCHAR(50) NOT NULL AFTER `a_quest_trigger_count` ;

	ALTER TABLE `t_npc` ADD `a_npc_choice_trigger_count` INT(3) NOT NULL AFTER `a_descr_nld`;
	ALTER TABLE `t_npc` ADD `a_npc_choice_trigger_ids` VARCHAR(50) NOT NULL AFTER `a_npc_choice_trigger_count` ;
	ALTER TABLE `t_npc` ADD `a_npc_kill_trigger_count` INT(3) NOT NULL AFTER `a_npc_choice_trigger_ids` ;
	ALTER TABLE `t_npc` ADD `a_npc_kill_trigger_ids` VARCHAR(50) NOT NULL AFTER `a_npc_kill_trigger_count` ;

[ Ʈ ]
  - Ȯ Ʈ Ǿ ־ 
#define QUEST_RESTORE_ABANDON


[Ϻ ű  2010]
1. #define _JPN_NEWITEM_2010
2. t_item : 5079~5092
3. t_skill : 239,240,412,413
4. t_skillLevel : 239(2 Level), 240(3,4 Level), 412(2 Level), 413(2 Level)
5. t_magic : 267
6. t_magicLevel : 267 (3,4 Level)
7. #define HPRS_BUG_FIX		// ȣ  ġ (ǻ)  
8. #define ENHANCE_ITEM_LEVEL //  ּ/ִ ( ٸ item a_level2  )

[Zone   ߰]
34  ĳ 巹   ʵ ߰
1. #define LIMIT_ZONE_LEVEL
2. ߰ʵ
   - ALTER TABLE `t_zonedata` ADD `a_minlevel` tinyint(3) unsigned DEFAULT '0' NOT NULL AFTER `a_continent_no`;
   - ALTER TABLE `t_zonedata` ADD `a_maxlevel` tinyint(3) unsigned DEFAULT '999' NOT NULL AFTER `a_minlevel`;
   - UPDATE t_zonedata SET a_minlevel = 150 WHERE a_zone_index = 34;


[ī ý] // 2 
1. #define LACARETTE_SYSTEM , #define _LACARETTE_DB_INSERT_BUG_PIX (ī DB      ġ)
2. dataDB ̺ ߰ t_lacarette ( )
3. userDB ̺ ߰ t_lacarette_log (̺)
4. t_npc, t_npc_regen 1084(ū ȯ) ߰
5. t_item 5123, 5124 ū  ߰   Ƿ ȹ .
 



[ũ ̺Ʈ]
1. #define EVENT_GOLDWEEK 62
2. #define LUCKYDRAWBOX_TOOL //  ȯ ̳ ̿ؼ 
3. t_item : 5125,5126 ߰
4. t_luckydrawbox, t_luckydrawResult : 36, 37 ߰ (t_luckydrawNeed )

[ų    Ƚ]
1. #define ITEM_SKILL_BUG_FIX
2.  
    : 1) ų پִ  ϰ ȭ  ı  ų Ͽ  ʴ 
            2)  ʴ ų ش  ٽ ϰ  Ͽ  , ش 
                ׸ ̿ ĳͿ  ų .

     å : 1)  ı  ش  ų Ͽ 
            2) ų Flag ߰Ͽ  Flag شϴ ų ĳ α׾ƿ  Ͽ ŵ. 
               DBƮ ʿ.
3. ش ״ dataDB t_skill ų ̸ տ (I)  ų ش.
   ش ų 'SF_INSTANT' FLAG ߰ Ǿ, ĳ α׾ƿ  ų ˻縦 Ͽ FLAG شϴ ų 
   ų Ͽ .
      t_skill Ʈ ʿ.

4. ش ų ε(20100427)
   - 662,845,846,847,848,849,850,851,855,856,857,858,859,860,861,862,863,864,865,866,867,868,869,871,872,873,874,875,876,877,878,879,880,881,882,883,884,885,886,887,888,889,890,891,892,893,894,895,896,897

[ڽƬ2]
(ȹ:, Ŭ̾Ʈ:¿, :ǻ)
1. #define COSTUME2_SYSTEM
2. ڽƬ2 ǻ  , ITEM_FLAG_COSTUME2 (1 << 26)  üũǾ .
3.    ش ۵ dataDB Insert ʿ.
   -  ϵ  ε - 4713, 5012~5015, 5139~5145, 5162~5249 100( Ʈ,  Ʈ,  Ʈ)
4. EP2 밡.

[0  ]
(ȹ:, Ŭ̾Ʈ:̾ȣ, :ǻ)
1.   μ    ü.(TestDB : DB newproject_data_kor)
   - Ӽ, 嵥 
   - t_npc_regen, t_shop, t_zonedata, t_mapinfo 0 õ  Ʈ.

[ ]
(ȹ:Ͽ, Ŭ̾Ʈ:̾ȣ, :ǻ)
1. #define MID_LEVEL_SUPPORT
2. MSG߰
   - MSG_SKILL_MIDLEVEL_SUPPORT
3.   ߰
4. 61~90 
5. npc index : 1107
6. skill index : 1002

[ ]
(ȹ:Ͽ, Ŭ̾Ʈ:̾ȣ, :ǻ)
1. #define HIGH_LEVEL_SUPPORT
2. MSG߰
   - MSG_SKILL_HIGHLEVEL_SUPPORT
3. ?  ߰
4. ?~? 
5. npc index : 1108
6. skill index : ?

[Ÿ]
(ȹ:Ͽ, Ŭ̾Ʈ:̾ȣ, :ǻ)
1.	#define DUNGEON_TIME							//  ڵ õ ð ġ .
	#ifdef DUNGEON_TIME								
	#define DUNGEON_TIME_SAVEFILE	".dungeontime"	// Ÿ   .
	#endif	

   - #define LIMIT_AMP_QUEST_EXP  ־ Ѵ.  ޴ ġ Ʈ ġ npc ޴ ġ Ȯϱ ؼ .

2. ڵ ص ð   ð   EXP .(SP)
3.   (.dungeontime) .( )
4.  ߰Ǿ  .
5. ص ð  ðŭ  Ÿ Ǿ     Ͽ   ġ ŭ  ޴´.
   ex) 0, 3, 6, 9, 12, 15, 18, 21ÿ Ÿ ϰ 1ð̸ 1ð ڿ Ÿ ڵᰡ ȴ.
       ص  ҽ Ǿ ,  Ƿ ٲ  . 

6.  ɾ
   - /dt_timeset [0 | 1 | 2 | 3 | ......... | 22 | 23 | all] [on | off]
      ð on/off  0 on̸ 0ÿ Ÿ ۵Ǵ ̴. 
	 /dt_timeset ing
	  õ Ÿ  ȮѴ.
	 !Ÿ ý ǰ ִ ߿ ú ȵȴ. /dt_toggle off  ý   ϰ ɾ Է  ִ.
	 ex) dt_timeset 13 on	// 13ÿ Ÿ .
		 dt_timeset 13 off	// 13ô ۽ð ƴ.
		 dt_timeset ing		//  õ ð Ȯϱ.

   - /dt_expset [100~600]
       100 600 Ѿ Ǹ  ȵ.
	 Է´ %̸ 200̸ 200%(, 2)̴. Ÿ ̿ ð 100 ġ  Ÿӿ 200 ġ ް ȴ.
	 /dt_expset ing
	    ȮѴ.
	 ex) /dt_expset 340		// 340% ϱ.
		 /dt_expset ing		//   Ȯ.

   - /dt_timeinterval [1 | 2 | 3 | .... | 10 | 11 | 12]
     Ÿ   ð      ִ. 1 ϰ 3ÿ Ÿ ۵Ǹ 4ÿ ᰡ ȴ.
	 1ð  12ð ϴ.
     /dt_timeinterval ing
	  interval  ȮѴ.
	 !Ÿ ǰ ִ ߿ ú ȵȴ. /dt_toggle off  ý   ϰ ɾ Է  ִ.
	 ex) /dt_timeinterval 1		// /dt_timeset  ð Ǹ Ÿ ϰ, 1ðڿ ڵ  ȴ.
	     /dt_timeinterval 12	// /dt_timeset  ð Ǹ Ÿ ϰ, 12ðڿ ڵ  ȴ.
		 /dt_timeinterval ing	//  Ȳ .

   - /dt_toggle [on | off | ing]
      Ƿ Ÿ on/off Ų.
	 Ÿ ڰ off   ġ  ް ȴ. 
	  Ÿ ƴҶ on ѵ ġ   Ѵ. õ ð Ǿ ġ  ް ȴ.
	 ing  ¸ Ȯϰ ȴ. 
	 ex) /dt_toggle on			// Ÿ /dt_timeset  ð Ǹ ڵ  ȴ. on  ð /dt_timeset  ð̸ ڵ Ÿ ۵ȴ.
		 /dt_toggle off			// Ÿ ϶ Ÿ ᰡ ǰ, /dt_timeset  ð Ǿ Ÿ ۵ ʴ´.
		 /dt_toggle ing			//  Ȳ Ȯ.

7.  õ  Ͽ ǹǷ   ö󰡵   󰣴.

8. Ѱ äο    ϰ Ǹ   äο   ȴ.  ä(GameServer) ӵ Messenger ӵ
    GameServer ϰ ȴ.
   !     . 

9. õ   Ǹ ȹ ʱ    ȴ.




[2010  ̺Ʈ ]
0.  ̺Ʈ  ܰ躰 define

  1ܰ :: Ʈ̾ޱ  npc , ± /Ȳ ޴, Ȳ ౸/ ȯ
     - #define EVENT_WORLDCUP_2010				63		// 2010  ̺Ʈ ౸ ȯ, NPC ౸ drop
	 - #define EVENT_WORLDCUP_2010_TOTO			64		// 2010  ̺Ʈ TOTO , Ȳ

  2ܰ ::   Ȳ .
     - #define EVENT_WORLDCUP_2010_TOTO_STATUS	65		// 2010  ̺Ʈ TOTO Ȳ

  3ܰ ::    ǰ 
     -   update t_event_worldcup_toto set a_result=1 where a_item_idx=[¸   ε];
	 - #define EVENT_WORLDCUP_2010_TOTO_GIFT	66		// 2010  ̺Ʈ TOTO Ȳ, ǰ 
  
  4ܰ :: ̺Ʈ 

1.define  ݿ  ׶ ׶ define Ѵ.

	- #define EVENT_WORLDCUP_2010				63		// 2010  ̺Ʈ ౸ ȯ, NPC ౸ drop
	- #define EVENT_WORLDCUP_2010_TOTO			64		// 2010  ̺Ʈ TOTO , Ȳ
	- #define EVENT_WORLDCUP_2010_TOTO_STATUS	65		// 2010  ̺Ʈ TOTO Ȳ  
	- #define EVENT_WORLDCUP_2010_TOTO_GIFT		66		// 2010  ̺Ʈ TOTO Ȳ, ǰ 
	- #define EVENT_WORLDCUP_2010_ATTENDANCE	67		// 2010  ̺Ʈ ⼮ ̺Ʈ( ʴ ⼮ ̺Ʈ ߿   ҽ ܳ)
	- #define EVENT_WORLDCUP_2010_KOREA					// 2010  ̺Ʈ ѱ 16
    
 2. t_npc, t_npc_regen 1105 Ʈ̾ޱ  ߰
 3. t_item 5331~5347(, ౸, Ȳ౸, ), 1485~1516(), 5349~5908(౸ :560)
 4. charDB t_event_worldcup_toto  ̺ ߰ (a_result °  0:, 1:÷, 2:ǰ޿Ϸ)
 5. charDB t_event_worldcup_attendance ̺ ߰ (EVENT_WORLDCUP_2010_ATTENDANCE ⼮ ̺Ʈ   ʿ)
 6. ̺Ʈ ϷǾ ¸ ÷   ÿ t_event_worldcup_toto ̺ ȿ ϵ ڵ忡
    ÷ ĳ a_result  1   Ѵ.
	update t_event_worldcup_toto set a_result=1 where a_item_idx=[¸   ε];

 #   
  -  Ŭ󿡼 ̺Ʈ  25 ָ Ʒ  ɷ ־.
    #define INVENTORY_QUANTITY_LIMIT 
      ɷ   ̺Ʈ  100  Ͽ ̺Ʈ 25  áµ   ϴ  .



[ ý]
1. #define SOCKET_SYSTEM
   #define BUGFIX_SOCKET_SYSTEM_COMPOSITE_ITEM
2. t_npc ʵ߰  Ʈ: Update_DataDB_AddField_Socket.sql, Update_DataDB_SocketDropSetting.sql -> SVN 
3. t_npc, t_shop, t_shopitem : 1106
4. t_item: 
5016,5017,5250,5251,5252,5253,5254,5255,5256,5257,5258,5259,5260,5261,5262,5263,5264,
5265,5266,5267,5268,5269,5270,5271,5272,5273,5274,5275,5276,5277,5278,5279,5280,5281,
5282,5283,5284,5285,5286,5287,5288,5289,5290,5291,5292,5293,5294,5295,5296,
5297,5298,5299,5300,5301,5302,5303,5304,5305,5306,5307,5308,5309,5310,5311,
5312,5313,5314,5315,5316,5317,5318,5319,5320,5321,5322,5323,5324,5325,5326,5327,5328,5329
5. t_option : 68 ~ 81
6. newproject_db ʵ ߰ : Update_CharDB_SocketSystem.sql

[̺Ʈ  ɾ ]
( : ǻ)

漭 : GameServer, Messenger

!!!!!!  ɾ ð ߺ  Ұϴ. 

#ifdef NEW_DOUBLE_GM
#define NEW_DOUBLE_GM_AUTO
#endif // NEW_DOUBLE_GM

 : /double_event all all start all 200 200 200 200 200 1
 : /double_event all all start all 200 200 200 200 200 1 2010-06-14 09:00:00 2010-06-15 17:00:00

/ɾ < all | cur | No.> <ä all | cur | No.> <start | ing | stop> <zonenum all | No.> <nasdrop> <nasget> <exp> <sp> <Produce> <Producenum> <Start DateTime> <End DateTime>

¥ð Է
<YYYY-MM-DD hh:mm:ss> ( ݵ Ǿ Ѵ)

  ۳¥ ᳯ¥ nasdrop = 200%, nasget = 200%, exp = 200%, sp = 200%, Produce = 200%, Producenum = 1    Ǹ
ð ķδ nasdrop = 100%, nasget = 100%, exp = 100%, sp = 100%, Produce = 100%, Producenum = 1   ȴ.
ð   DEFAULT ̴.

/double_event all all ing Է   ä ̺Ʈ  ð ð ǥð Ǹ,    ǥð ȴ.
   Ϸ  ǹǷ  Ǿٰ ٽ ö͵ ð 񱳸 Ͽ ̺Ʈ ࿩θ Ǵϰ ȴ.
̺Ʈ ð  (  200 200 200 200 200 1)  Ǹ ׿ ð  DEFAULT (100 100 100 100 100 1)  ȴ.
/double_event all all stop Է  Է ð η ᰡ ȴ.

===================================================================================================================================================================================================

#define GM_EXP_LIMIT_AUTO
#ifdef GM_EXP_LIMIT_AUTO
#define GM_EXP_LIMIT_AUTO_SAVEFILE ".explimitsave"
#endif

 : /exp_limit all 600
 : /exp_limit all 600 400 2010-06-14 09:00:00 2010-06-15 17:00:00

/ɾ < all | cur | No.> <۰ġ > <ġ > <Start DateTime> <End DateTime>

¥ð Է
<YYYY-MM-DD hh:mm:ss> ( ݵ Ǿ Ѵ)

  ۽ð ġ 600% ϸ ð ķδ 400% ϰ ȴ.
   Ϸ  ǹǷ  Ǿٰ ٽ ö͵ ð 񱳸 Ͽ ̺Ʈ ࿩θ Ǵϰ ȴ.
̺Ʈ ð  (  600%)  Ǹ   ð  ( 400%)  ȴ.

/exp_limit ing    Ѱ ۽ð, ð Ȯ   ִ.

===================================================================================================================================================================================================

#ifdef NEW_DOUBLE_EVENT_AUTO
#define NEW_DOUBLE_EVENT_AUTO_TIME
#ifdef NEW_DOUBLE_EVENT_AUTO_TIME
#define NEW_DOUBLE_EVENT_AUTO_SAVEFILE ".doubleeventautotime"
#endif
#endif

 : /double_event_auto all start
 : /double_event_auto all start 2010-06-14 09:00:00 2010-06-15 17:00:00
/ɾ < all | cur | No.> <start | ing | stop> <Start DateTime> <End DateTime>

¥ð Է
<YYYY-MM-DD hh:mm:ss> ( ݵ Ǿ Ѵ)

  ۳¥ ᳯ¥ ޺ Ÿ Ұ  ̴.
 ð  Ϸ  ǹǷ  Ǿٰ ٽ ö͵ ð 񱳸 Ͽ ̺Ʈ ࿩θ Ǵϰ ȴ.

/double_event_auto all ing ޺Ÿ ۽ð ð   ִ.
/double_event_auto all stop Է  Է ð η ᰡ ȴ.

===================================================================================================================================================================================================

#define EVENT_ITEMDROP_AUTO
#ifdef EVENT_ITEMDROP_AUTO
#define EVENT_ITEMDROP_AUTO_SAVEFILE ".eventitemdropauto"
#endif

 : /event itemdrop all start 200
 : /event itemdrop all start 200 2010-06-14 09:00:00 2010-06-15 17:00:00
/ɾ < all | cur | No.> <start <rate> | ing | stop>

¥ð Է
<YYYY-MM-DD hh:mm:ss> ( ݵ Ǿ Ѵ)

  ۳¥ ᳯ¥ ۵(   200%) ̺Ʈ Ұ  ̴.
̺Ʈ ̿ ð 100%  ȴ.
 ð  Ϸ  ǹǷ  Ǿٰ ٽ ö͵ ð 񱳸 Ͽ ̺Ʈ ࿩θ Ǵϰ ȴ.

/event itemdrop all ing  ۵ ۽ð, ð   ִ.
/event itemdrop all stop    100%   ִ.

===================================================================================================================================================================================================

[ ų ߰]
1. #define GUILD_SKILL
2. dataDB.t_skillLevel field ߰
   - ALTER TABLE `t_skillLevel` ADD `a_needGP` INT(11) DEFAULT "0" NOT NULL AFTER `a_needMP`;
   - UPDATE t_skill SET a_type = 3, a_flag = 512 WHERE a_index in (443, 444);

3. charDB.t_extend_guild field name 
   - ALTER TABLE `t_extend_guild` CHANGE COLUMN `a_skill_index` `a_passiveskill_index` VARCHAR(255);
   - ALTER TABLE `t_extend_guild` CHANGE COLUMN `a_skill_level` `a_passiveskill_level` VARCHAR(255);
   - ALTER TABLE `t_extend_guild` ADD `a_activeskill_index` VARCHAR(255) AFTER `a_guild_land`;
   - ALTER TABLE `t_extend_guild` ADD `a_activeskill_level` VARCHAR(255) AFTER `a_activeskill_index`;
   - ALTER TABLE `t_extend_guild` ADD `a_etcskill_index` VARCHAR(255) AFTER `a_passiveskill_level`;
   - ALTER TABLE `t_extend_guild` ADD `a_etcskill_level` VARCHAR(255) AFTER `a_etcskill_index`;

4.  ų
   - Skill Index	: 443, 444, 1057, 1058, 1059, 1076, 1077, 1078, 1079, 1080, 1081
   - 		: 443, 444 Type  Flag .
						Type : 7 -> 3 (GUILD SKILL PASSIVE -> PASSIVE)
						Flag : 0 -> 512

5. ߰ Magic Index : 950,951,952,953,954,955,956,957,958,959,960,961,962,963

[ ⼮ ý]
1. SYSTEM Desc. :	 ⼮ϼ Ͽ 2,3,4,5 Ͽ  ġ .
					 ⼮ϼ 100,200,365 ̸̻ 
2. Define :			ATTENDANCE_EXP_SYSTEM
3. Update Server :	GameServer, SubHelper
4. DataBase :		newproject_db.t_attendance_exp_system
					newproject_data.t_skill(1060) .t_skillLevel, t_magic (929), t_magicLevel
5. DB Fields :		a_last_date ( ֱ  ) , a_acc_count (   ),
					a_max_acc ( ִ Ӵ ), a_last_reward_point (    ⼮ )

6. skill index : 1060
   skillLevel index : 1060
   magic index : 929
   magicLevel index : 929
   item : 5967
   title : 20



[Ҵ ]

1. t_item  5944~5947
2. t_skill, t_skillLevel 1034~1054
3. t_magic, t_magicLevel 928, 817~837
4. t_quest 362
5. t_bigpet 10~13 (10 ־ Ŭ lod  )


[Ʃ丮 ]
1. #define TUTORIAL_RENEWER
  - #define NEW_TUTORIAL   Ǿ ־ 
2. char_db.t_characters ʵ ߰
  - ALTER TABLE `t_characters` ADD `a_newtuto_complete` INT(4) DEFAULT "1" NOT NULL;

3. t_item : 6085, 5954~5957 
   t_title : 23

4. t_npc
  - 1129,1130,1132~1134

4. t_npc_regen 6
  - 1129,1130,1132~1134

5. Ȱ ֹ 2  
	t_item ߰ 4933, 5958

6. t_optoin a_index in (72,73) a_level  ʿ

[ʺ  Ʈ]

1. define LOW_LEVEL_SUPPORT_QUEST
2. t_quest ߰ 367~371, 375~380
3. t_npc , t_npc_regen 893(ʺ npc)  ϵ ڵ Ư äθ ǰ Ǿ    Ȯ ۾.


[İ ý ]

1. #define GUARDIAN_SYSTEM_RENEWAL
 #define TEACH_FAMEUP_BUG_FIX //   Ǿ ־

2. charDB t_characters update

	// İ 踸  ʱȭ ش.
	update t_characters set a_teach_idx=' -1 -1 -1 -1 -1 -1 -1 -1 -1 -1', a_teach_sec=' 0 0', a_teach_type=-1, a_teach_list = 0;


3. charDB t_guardian_gift ̺ 

	DROP TABLE IF EXISTS `t_guardian_gift`;
	CREATE TABLE `t_guardian_gift` (
	   `a_char_idx` int(11) unsigned NOT NULL default '0',
	   `a_gift_count` int(11) unsigned NOT NULL default '0',
	   PRIMARY KEY  (`a_char_idx`),
	   UNIQUE KEY `a_char_idx` (`a_char_idx`)
	 )TYPE=MyISAM ;

4. t_item where a_index in (5952, 5953)
5. t_item where a_index in (6105, 6106, 6107, 6108, 6109, 6110) // 20 ޼  
5. t_title where a_index=22
6. t_skill 1061
7. t_skillLevel 1061
8. t_magic 964, 965
9. t_magicLevel 964, 965


[Ʈ 뷱 (巹 ٿ/  Ǹ)]

1. dataDB ϴ  .
   - Ʈ  ٿ ġ
update t_quest set a_need_min_level=130 where a_index in (234,236,237,238,239,240,241,242,243,244,245,246,247,248,249);

2.  Ǹ(Ǹ) ÿ    
 t_item 4913
 
[ĭ]

#define AKAN_TEMPLE
#ifdef MONSTER_COMBO
#define GROUND_EFFECT2
#endif // MOSTER_COMBO

HELPER, GAMESERVER Ʈ ʿ
ĭ ̵   ִ ÿ ۵ մϴ.

File ߰
RaidData.h
RaidData.cpp

MAP ߰
akantemple_1024_1024_0.sat
akantemple_1024_1024_0.sht

newStobm.bin Ʈ

[Zones]
Count=36
.....
[Zone_35]
No=36
Remote=FALSE

DATA DB
Table ߰(dump)
t_raid_data (!! ĭ ̵    a_difficulty = 1  ͸  մϴ.
t_raid_object_data
t_raid_object_list

t_zonedata
a_zone_index = 36(߰)
a_zone_index = 15()

t_npc_regen_raid
a_zone_num = 36

t_item
a_index in (6101,6102,6131,6132,6133,6134,6135,6136,6137,6138,6139,6140,6141,6142,6143,6144,6145,6146,6147,6148,6149,6150,6151,6152,6162,6153,6154,6155,6156,6157,6158,6159,6160,6161,6163,6164,6165)

t_skill
a_index in (1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1084,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1071,1072,1073,1074,1082,1083)

t_skillLevel
a_index in (1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1084,1017,1018,1019,1020,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1031,1032,1033,1071,1072,1073,1074,1082,1083)
,)

t_magic
a_index in (887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,943,944,945,946,947,948,966,967,968,969)

t_magicLevel
a_index in (887,888,889,890,891,892,893,894,895,896,897,898,899,900,901,902,903,904,905,906,907,908,909,910,911,912,913,914,915,916,917,918,919,920,921,922,923,943,944,945,946,947,948,966,967,968,969)

t_npc_dropraid
a_npc_index in (1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1126,1127,1128)

t_npc
a_index in (1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1126,1127,1128, 1137)

t_npc_regen
a_npc_idx = 1137

t_set_item
a_set_idx in (58,59,60,61,62,63,64)

[ĭ EVENT]
1. #define EVENT_AKAN_TEMPLE
2.  ɾ(ݵ ҹ Է ʿ)
   - /event akan start		// ĭ ̺Ʈ   ͵鿡Լ ȥ ¡ǥ  ӵ.
							//   (1112,1116,1120,1128,1124)
   - /event akan stop		// ȥ ¡ǥ  ӵ ʴ´.
   - /event akan ing		//  ĭ ̺Ʈ   Ǿ Ȯ   ִ.
   - /event akan exchange	//   ִ ȥ ¡ǥ   ȯ   ִ. 
							// ȯ  ū ں ѹ  ϰ μ ȴ.
   - ʿ  #6217
3. CHAR DB TABLE ߰

	CREATE TABLE `t_event_akan_temple` (
		`a_index` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`a_char_index` INT(10) UNSIGNED NOT NULL DEFAULT '0',
		`a_char_name` CHAR(50) NOT NULL DEFAULT '0',
		`a_user_index` INT(10) UNSIGNED NOT NULL DEFAULT '0',
		`a_exchange_count` INT(10) UNSIGNED NOT NULL DEFAULT '0',
		PRIMARY KEY (`a_index`)
	)
	COMMENT='ĭ ̺Ʈ : ȥ ¡ǥ ȯ '
	ENGINE=MyISAM
	ROW_FORMAT=DEFAULT

[æƮ Ȯ]
:ǻ, Ŭ̾Ʈ:
1. DEFINE
	#ifdef SET_ITEM						// ǻ SET_ITEM ý  κи .
	#define EXTEND_ENCHANT_2010			// Plus +17 , ȭȷ Ƹ, Ǹ Ƹ   Ȯ ȭ, ÷Ƽ ֻ  ȣ  .
	#ifdef EXTEND_ENCHANT_2010
	#undef MAX_UPGRADE_PLUS
	#define MAX_UPGRADE_PLUS	16		// EXTEND_ENCHANT_2010ϰ MAX_UPGRADE_PLUS 15 -> 16 
	#endif // EXTEND_ENCHANT_2010
	#endif // SET_ITEM

2. 
   -  +15 Ǵ +16  Ű.. ÷Ƽ ü   +17 ǵ .

3. ߰ 
INDEX : 6218 (÷Ƽ ֻúȣ())

[ ڽƬ]

1. #define QA_SYSTEM_CASTLLAN_COSTUME
   #define TITLE_SYSTEM // ʿ
   #define COSTUME2_SYSTEM // ʿ
2. t_item where a_index between 6181 and 6215 or a_index=5968;
3. t_title where a_index=21
4. dataDB.t_title.a_castle  Ȯ
   (ALTER TABLE `t_title` ADD `a_castle_num` INT(11) UNSIGNED NOT NULL;)

[   Ȯ]
1. DEFINE 
	#define BUGFIX_SPECIALBOX_DROPRATE
	
2. Table 
	t_npc_dropraid	t_spec_min, t_spec_max . // ̺ ü ű õ


[̱״ϼ ý]

1. #define ENERGY_IGNITION_SYSTEM					//   ̱״ϼ ý
2. skill 1062 ~ 1065
2. magic 931 ~ 936

[100~140 ߰ Ʈ]
1. t_quest 389~413

[UPGRADE_EVENT ð  ߰]
 : ǻ
 : UPGRADE_EVENT ۰ ð Ͽ  Ǹ Ѵ.

#ifdef UPGRADE_EVENT
#define UPGRADE_EVENT_AUTO			// ׷̵ ̺Ʈ ڵȭ
#define UPGRADE_EVENT_AUTO_SAVEFILE		".upgradeevent"
#endif // UPGRADE_EVENT


					     ׷				   				    Ȯ						  ۽ð	   ð
-  : /upgrade_event [all | cur | server group] [start | ing | stop] [100 | 125 | 150 | 175 | 200]
-  : /upgrade_event [all | cur | server group] [start | ing | stop] [100 | 125 | 150 | 175 | 200] [Start time] [End time]

Ȯ ۽ð ð  start϶  ˴ϴ.

start time 	: 2010-09-29 10:00:00
end time 	: 2010-09-29 14:00:00

  ɾ ۽ð, ð, Ȯ  Ӽ Ϸ  ϱ  
 ۽ ڵ   εϰ ˴ϴ.

[ 뷱  2]
ۼ : 
1.DataDB(newproject_data)  
  svn\SERVER\Query\Update_DataDB_MonsterBalance_2nd.sql 
   t_npc  صδ°  Դϴ.


[θ2 ̺Ʈ]
1. define DEV_EVENT_PROMOTION2 69 
2.    key ĪϿ  
3. userDB.t_promotion2_key ̺ 
3. dataDB.t_promotion2 ̺     .
4. dataDB.t_promotion2 ȿ a_kind  ޵ ǰ  Ѵ. userDB.t_promotion2_key.a_kind  ĪϿ Ѵ.

[ź NPCŻ ũ]
1. #define NPC_PORTAL_SCROLL_DRATAN
2. ĳ   ź NPCũ .



[ 뺴 ī ý]

0. ֿ(), ⼱(Ŭ), ȹ()
1. #define SYSTEM_MONSTER_MERCENARY_CARD
	ʼ define
	#define NIGHT_SHADOW
	#define SET_ITEM

2. MonsterMercenary.cpp
   MonsterMercenary.h

3. DB 
	t_item where a_index in (6251, 6252,6253,6254,6255,6256,6257,6258,6259,6260);
	t_luckydrawbox  where a_index in (60, 61, 62, 63, 64, 65 );
	t_luckydrawResult where a_luckydraw_idx in (60, 61, 62, 63, 64, 65 );
	t_skill where a_index = 1134;
	t_skillLevel where a_index = 1134;
	t_magic where a_index = 1000;
	t_magicLevel where a_index = 1000;

	--add-drop-table newproject_data t_monster_mercenary 


[ 뺴 ī ý Ȯ] // 2011-03-30 // ۾ .

0.	ֿ(), ⼱(Ŭ), ȹ()

1.	
	- Ŭ ٸ  뺴  (BŬ ɷġ)
	ȱ, ޸, ũ   ߰.
	
2.	
	#ifdef SYSTEM_MONSTER_MERCENARY_CARD
	#define SYSTEM_MONSTER_MERCENARY_CARD_EX
	#endif

3.	GameServer

4.	dataDB.t_monster_mercenary  .
	dataDB.t_monster_mercenary_ex . (--add-drop-table)
	

[ 뺴 ī ʺ ] 

0.	ֿ(), ⼱(Ŭ), ȹ() 

1.	Ʈ  ʺڿ  뺴ī .
	-  Ŭ ٸ  뺴 
	- ɷġ B Ŭ  (ϵڵ Ǿ  doFuncQuest.cpp)

1. 
	#ifdef SYSTEM_MONSTER_MERCENARY_CARD
	#define SYSTEM_MONSTER_MERCENARY_CARD_LOW_LEVEL_SUPPORT
	#endif

3.	GameServer


4	t_item WHERE a_index in (6805);	
	t_quest WHERE a_index in (494);



[ ġ ̺Ʈ ]
 : ǻ
#define DOUBLE_PET_EXP
#ifdef DOUBLE_PET_EXP
#define DOUBLE_PET_EXP_AUTO
#define DOUBLE_PET_EXP_SAVEFILE	".doublepetexp"
#endif

/doublepetexp_event <serverno | all | cur> <start | stop | ing> <100~1000%> <start time> <end time>

start time 	(2010-10-29 16:00:00)
end time 	(2010-10-29 17:00:00)

*Ȯ ۽ð, ð start Է ÿ ־ָ ˴ϴ.
* ٿǰų,    Ǿ 쿡 ̺Ʈ ð ̶ ڵ ̺Ʈ ۵˴ϴ.


[ĳ  ]
0. ֿ(), ¿(Ŭ)
1. #define SYSTEM_FACEOFF
2. DB
	t_item where a_index in 5969, 6083;


[ĳ ų Ȯ] // 2010-11-19

0. ֿ(), ¿(Ŭ)

1. #define SYSTEM_SUMMON_SKILL
		#define SYSTEM_MONSTER_MERCENARY_CARD // ʼ 
		#define NIGHTSHADOW_SKILL // ʼ

2. DB

	ALTER TABLE `t_skill` ADD `a_summon_idx` INT(10) NULL DEFAULT '-1' AFTER `a_soul_consum`; // skillTool  Ȯ .

	t_item where a_index=6331 or a_index between 6269 and 6280;

	t_npc where a_index between 1140 and 1151 or a_index in (1153,1154,1158,1159,1160,1161,1162,1163);

	t_skill where a_index between 1101 and 1133 or a_index between 1141 and 1152 or a_index in (152, 1158);

	t_SkillLevel where a_index between 1101 and 1133 or a_index between 1141 and 1152 or a_index in (152, 1158);

	t_magic	where a_index between 1001 and 1020 or a_index between 1022 and 1069  or a_index between 1074 and 1076;

	t_magicLevel where a_index between 1001 and 1020 or a_index between 1022 and 1069  or a_index between 1074 and 1076;

	t_luckydrawbox where a_index=68;
	


[ŷ ý]
0. Author : 			(), ڼ(Ŭ)
1. Define : 			#define SYSTEM_RANKING
2. Dependency Define : 	#define TITLE_SYSTEM
3. Update Server :		GameServer, SubHelper
4. DataBase : 			newproject_db.t_ranking (ŷ )
						newproject_db.t_ranking_date ( ð )
5. DB Fields : 			t_ranking - a_charindex(Ŀ ĳ Index), 
									a_type(ŷ Ÿ <0~7 : ĳ ְ , 100 : , 101 : ְ İ>),
									a_rank(ϵ ),
									a_rankdate(ϵ ¥/ð),									
									a_checked(ĳͿ ŷ  ޽ ´ ƴ <0 :  Ⱥ´, 1 : ̹ ´>),
									a_extra(Ȯ强  extra ʵ, ְ İο İ 缺  ),
									a_titleindex(  ȣĪ ε)
						t_ranking_date - a_date(ŷ    ð)
6. DB Data :			t_item WHERE a_index>=6236 AND a_index<=6244
						t_title WHERE a_index>=24 AND a_index<=32
						t_action WHERE a_index=51

[ģȭ Ȯ]
 - #define AFFINITY_FIX ( #define AFFINITY  ־ )
 - newproject_data 
   1. t_affinity t_affinity_npc t_affinity_reward_item t_affinity_work
   2. t_npc, t_shop, t_shopitem 1085, 1086, 1072, 1088, 1089, 1090, 1091, 1092, 1093, 1094, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104

[ ð  : ޶ũ, ź    ϰ ] 
 - #define CHECK_OVERLAP_WARCASTLE
 - t_npc: 1155

[Ʈ̾Ƴ  ] // 26, 27, 28 37 ƮƷ Ѵ.
0. :ǻ Ŭ:̾ȣ

1. Database
update t_npc set a_enable = 0 where a_index in (850,851,858,859);
t_zonedata where a_zone_index = 37
t_npc_regen where a_zone_num = 37

2. 
STREIANA_TRIVIA_CANYON_1024_1024_0.sat
STREIANA_TRIVIA_CANYON_1024_1024_0.sht

3. newStobm.bin
[Zones]
Count=34 // īƮ 26~28 ϰ  ° Է

[Zone_36]
No=37
Remote=FALSE

// No=26, 27, 28  Ѵ.


[ĳ  ۾]
ĳ Ʈ    Ǿ ϸ, 
t_string Ʈ Ǿ մϴ.  t_string̺   մϴ.

config.bin  Ǿ մϴ.
svn\Tools_Expansion\NewCashItemTool config.bin [Server] ׸ ÿ ´
Server list ݵ ߰ Ǿ մϴ.

0. :ǻ, Ŭ:̾ȣ
1. Database
Ҹ
UserDB.t_wishlist

CREATE TABLE `t_wishlist` (
`a_userindex` INT(10) UNSIGNED NOT NULL,
`a_ctids` VARCHAR(50) NULL,
PRIMARY KEY (`a_userindex`)	
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT

Ҹڴ ڱⰡ   īŻα  Ѵ. 
Ѱ 8  Ѵ. īŻα  ctid Ʈ ȯؼ Ѵ.

DataDB.t_catalog
Alter table t_catalog add `a_category` int not null default 0 after `a_ctname`;
Alter table t_catalog add `a_subtype` int not null default 0 after `a_type`;
Update t_catalog set a_category = 0, a_subtype = 0, a_type = 90000, a_enable = 0, a_category = 90000;
 īŻα   ǰ Ѵ.(90000=ǰ)
// a_icon    ̰  ־. (   Ÿ ÿ  ɼ ŭ)
ALTER TABLE `t_catalog`  ADD `a_icon` TINYINT(3) UNSIGNED NULL DEFAULT '0' AFTER `a_flag`;

2. Define
#define EXTEND_CASH_SHOP

3.  ɾ ?   ɾ
   - /modifycashshop ɾ 
   - argument ( lock | unlock | reload_cash )
   -  ɾ 
	/modifycashshop lock		// ĳ ݼ  ĳ lock  .
					// Ŭ̾Ʈ ޽ ߼ϸ Ŭ̾Ʈ ޽   Shop ,  ʴ´.
	/modifycashshop reload_cash	// ĳ     Table  Live DataDB ű   ɾ ϸ
					//   Ӽ ȴ.
	/modifycashshop unlock		//   Ϸᰡ Ǿ  ɾ Ͽ cashshop unlock ش.


[ DEMON PET (ť) ]
0. :ǿ, Ŭ:̵ο
1. Database
	newproject_data
	 ̺  ( t_bigpet  ̻   )
		. t_attack_pet		(  t_bigpet  Ȯ )
		. t_attack_pet_ev ( ȭ õ  )
		
	߰ 
		. t_action,t_item,t_skill,t_skillLevel,t_magic,t_magicLevel,t_quest, t_rareoption, t_option
	
	newproject_db
		. t_apets  ÷ ߰
			ALTER TABLE t_apets ADD a_accFaith int unsigned default 0;
			ALTER TABLE t_apets ADD a_accStm int unsigned default 0;
	
2. Define
#define ATTACK_PET_S2

3. Ÿ
	. ο   ʿ


[þƮ Ȯ]
#define MAX_UPGRADE_PLUS	16			// EXTEND_ENCHANT_2010ϰ MAX_UPGRADE_PLUS 15 -> 16 (Line 1318 )

[ ų  ]
:ǻ
#define BUGFIX_USE_SKILL_TO_NPC
 ߰Ǿ ð  ڷŰ׽ý  ϰ Ѱ 

effect taming drain ִ ų
ȭ, , ݼȣ,   ÷װ üũ NPCԴ 
߸  ų  ϰ .

#169 ų(ڷŰ׽ý), #401 ų(뽬)
ȭ, , ݼȣ,   ÷װ üũ NPCԴ 
߸  ų  ϰ .


[νƮ   ]
(ĭ ̵ )
 : ǻ, Ŭ̾Ʈ : ̾ȣ
#define DEV_DUNGEON_DIFFICULTY

뼭 : GameServer, Helper

DataDB 
--add-drop-table t_raid_data t_raid_object_data

t_skill where a_index in
(1003, 1004, 1005, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1084, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1006, 1007, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1020, 1021, 1027, 1082, 1083)

t_skillLevel where a_index in
(1003, 1004, 1005, 1008, 1009, 1010, 1011, 1012, 1013, 1014, 1015, 1016, 1017, 1084, 1018, 1019, 1020, 1021, 1022, 1023, 1024, 1025, 1026, 1006, 1007, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1020, 1021, 1027, 1082, 1083)

t_magic where a_index in
(887, 888, 889, 890, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 966, 967, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 891, 892, 893, 917, 918, 919, 920, 921, 922, 923, 909, 910, 911, 917, 918, 919)

t_magicLevel where a_index in
(887, 888, 889, 890, 894, 895, 896, 897, 898, 899, 900, 901, 902, 903, 904, 905, 906, 966, 967, 907, 908, 909, 910, 911, 912, 913, 914, 915, 916, 891, 892, 893, 917, 918, 919, 920, 921, 922, 923, 909, 910, 911, 917, 918, 919)

t_npc where a_index in
(1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182)

update t_npc set a_exp where a_index in
(1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1120,1121,1122,1123,1124,1126,1127,1128)

t_npc_regen_raid where a_npc_idx in
(1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182)

t_npc_dropraid where a_npc_index in
(1164, 1165, 1166, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182)

t_item where a_index in
(6568, 6569, 6570, 6571, 6572, 6573, 6574, 6575, 6576, 6577, 6578, 6579, 6580, 6581, 6582, 6583, 6584, 6585, 6586, 6587, 6588, 6589, 6590, 6591)

t_item where a_index between 6131 and 6165

CharDB
ALTER TABLE `t_inzonejoin` add `a_difficulty` int not null default -1 after `a_charindex`;
ALTER TABLE `t_trigger_saveinfo` add `a_difficulty` int not null default -1 after `a_save_time`;


[ 꽺 ʱȭ ī ]
1. ǿ, 
2. DEV_APETSTAT_INITCARD
3. item index : 6281

[2011 ⼮ ̺Ʈ]
 : ǻ, Ŭ̾Ʈ : ⼱

Define

#ifdef ATTENDANCE_EXP_SYSTEM			// ⼮ ý ʿ
#ifdef UPGRADE_EVENT					// ׷̵ ̺Ʈ ʿ
#ifdef UPGRADE_EVENT_AUTO				// ׷̵ ̺Ʈ (ð)  ʿ
#ifdef SUB_HELPER						//  ʿ
#define EVENT_ATTENDANCE_2011
#define ATTENDANCE_SAVE_FILE ".attendance"
#endif
#endif
#endif
#endif

뼭 : GameServer, SubHelper

CharDB

CREATE TABLE `t_attendance_event_2011` (
	`a_char_idx` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`a_tda` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`a_tda_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_oda` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`a_oda_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_today` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	`a_today_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_accday` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	`a_reward` INT(10) UNSIGNED NOT NULL DEFAULT '0',
	PRIMARY KEY (`a_char_idx`),
	INDEX `a_tda` (`a_tda`)
)
ENGINE=INNODB
ROW_FORMAT=DEFAULT

DataDB
t_skill t_skillLevel : a_index = 1183
t_magic t_magicLevel : a_index in (1126,1127)
t_item a_index (6598~6644, 6649~6652, 5965, 5966, 6566)
t_luckydrawbox a_index in (86, 87, 92, 95, 96, 97)
t_luckydrawResult a_luckydraw_idx in (86, 87, 92, 95, 96, 97)

-- ⼮ ý    t_attendance_event_2011 table CREATE  Ʒ   ʿ
-- ⼮ ýۿ  ⼮    ̺Ʈ ̺ insert
Insert into t_attendance_event_2011(a_char_idx, a_today, a_today_date, a_accday) select a_char_index, 1 , a_last_date, 1 from t_attendance_exp_system where TO_DAYS(NOW())=TO_DAYS(a_last_date);


[  ]  Ȱ ȭ //  .

1. ¿(Ŭ), ֿ(), (ȹ)
2. #define DEV_SYSTEM_GUILD_GRADE_EX
3. GameServer, Helper


[ڽƬ2   ǻ]

1. ڼ(Ŭ), (), (ȹ)
2. #define SYSTEM_COSTUME2_SUIT
3. GameServer



[޸  ̺Ʈ]

1.	ϵ ޸  ĳͺ   .
2.	(ȹ), ¿(Ŭ), ֿ()
3.	#define EVENT_USER_COMEBACK 70 //޸  ̺Ʈ
	#ifdef EVENT_USER_COMEBACK
		#define EVENT_USER_COMEBACK_AUTO_REG_DAY 180 // ޸  ڵ DB  (  ڴ ͹ ¥)
	#endif
4.	GameServer, Connector
5.	DB
	* userDB.t_event_usercomeback (̺       ε ־ش.)
	  - a_user_idx		::    ε
	  - a_server_num		::   ĳ  ȣ
	  - a_char_idx		::   ĳ ε
	  - a_gift_date		::   ð.

	 CREATE TABLE `t_event_usercomeback` (
		`a_user_idx` int(11) unsigned NOT NULL default '0',
		`a_server_num` tinyint(3) unsigned default '0',
		`a_char_idx` int(11) unsigned default '0',
		`a_gift_date` datetime NOT NULL default '0000-00-00 00:00:00',
		PRIMARY KEY  (`a_user_idx`),
		UNIQUE KEY `a_user_idx` (`a_user_idx`)
	) TYPE=MyISAM;
	    
	* dataDB
		- t_item where a_index between 6711 and 6717 or a_index = 6700;
		- t_luckydraw where a_index between 102 and 108;
		- t_luckydrawResult where a_luckydraw_idx between 102 and 108;
		- t_title where a_index=57;


[ĳ 1ֳ  ̺Ʈ]

1. ĳ  1  ĳͿ   Ѵ.
2. (ȹ), ¿(Ŭ), ֿ()
3. #define EVENT_CHAR_BIRTHDAY 71  //ĳ 1ֳ  ̺Ʈ
4. GameServer, Helper
5. DB
	* charDB.t_event_char_birthday
		- a_char_idx		:: ĳ ε
		- a_create_date	:: ĳ  
		- a_gift_date	::   

	 CREATE TABLE `t_event_char_birthday` (
		`a_char_idx` int(11) unsigned NOT NULL default '0',
		`a_create_date` date NOT NULL default '0000-00-00',
		`a_gift_date` date NOT NULL default '0000-00-00',
		`a_count` INT(11) UNSIGNED DEFAULT '0' NOT NULL,
		PRIMARY KEY  (`a_char_idx`),
		UNIQUE KEY `a_char_idx` (`a_char_idx`)
	) TYPE=MyISAM;
	 		
	* dataDB
		- t_item where a_index between 6701 and 6710 or a_index between 6718 and 6727;
		- t_luckydraw where a_index between 109 and 118;
		- t_luckydrawResult where a_luckydraw_idx between 109 and 118;
		- t_title where a_index between 58 and 67;



[Ƽ ִ NPC Ʈ Ϸ]
 : ǻ
1. define
#define HUNT_QUEST_COMPLETE_FOR_OTHER_PARTYMEMBER

2. Ƽ      ͸  Ʈ  ִٸ, Ʈ ڵ Ϸ.   Ʈ .

[αҶ α ]
1. α Ҷ    IP , ID DB Ѵ. (  )
2. ǿ
3. #define LOCAL_LOGIN_LOG
4. Login Server
5. DB ( 뷮̳, ϰ   DB )
	CREATE TABLE `t_loginlocallog` (
		`a_index` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
		`a_user_index` INT(10) UNSIGNED NOT NULL DEFAULT '0',
		`a_idname` VARCHAR(32) NOT NULL DEFAULT '0',
		`a_ip` INT(10) UNSIGNED NOT NULL DEFAULT '0',
		`a_local` CHAR(2) NOT NULL DEFAULT '0',
		`a_timestamp` INT(11) UNSIGNED NOT NULL,
		PRIMARY KEY (`a_index`),
		INDEX `date` (`a_timestamp`, `a_user_index`)
	)
6. LoginServer newStobm.bin
	[LocalLog DB]  	IP,DBName,User,Password 
7. ˻ 
	select a_idname, a_local, INET_NTOA(a_ip) from t_loginlocallog 
	where a_timestamp > UNIX_TIMESTAMP('2011-02-23 11:39:00') and a_timestamp < UNIX_TIMESTAMP('2011-02-24 11:41:00')
	group by a_user_index;

[2 θ ̺Ʈ]	
:ǻ, Ŭ:⼱, ȹ:
1. define
#define EVENT_EUR2_PROMOTION

2. Connector, GameServer 

3. Table Scheme
(User DB)
CREATE TABLE `t_eur2_promotion` (
    `a_key` VARCHAR(20) NOT NULL DEFAULT '',
    `a_user_index` INT(11) NOT NULL DEFAULT '0',
    `a_char_index` INT(11) NOT NULL DEFAULT '0',
    `a_use_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
    UNIQUE INDEX `a_key` (`a_key`),
    INDEX `a_user_index` (`a_user_index`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT

4. Insert Data
http://10.1.90.250/projects/promotion/wiki/Wiki/ ÷Ȯ(promotion_key_Insert_Query.sql)

[ų Ÿ  ]
 : ǻ

1. define
#define DEV_COOLTIME_SKILL

2. item index : 6792(׽Ʈ)

3. ų  (SVN Ʈ ʿ)

4. ų Ÿ ٿִ ų ϴ. skill index : 1340, magic index : 1161(׽Ʈ Դϴ.)

[ŷ 淮ȭ]
ǻ
SUBHELPER
#define TRADE_AGENT_LIGHT

(CharDB)
DROP TABLE IF EXIST `t_backup_tradeagent`;
CREATE TABLE `t_backup_tradeagent` (
	`a_index` INT(11) NOT NULL DEFAULT '0',
	`a_item_serial` INT(11) NOT NULL DEFAULT '0',
	`a_item_serial2` VARCHAR(20) NOT NULL DEFAULT '',
	`a_item_plus` INT(11) NOT NULL DEFAULT '0',
	`a_item_flag` INT(11) NOT NULL DEFAULT '0',
	`a_option_count` INT(11) NULL DEFAULT '0',
	`a_option_0_type` INT(11) NULL DEFAULT '0',
	`a_option_0_level` INT(11) NULL DEFAULT '0',
	`a_option_1_type` INT(11) NULL DEFAULT '0',
	`a_option_1_level` INT(11) NULL DEFAULT '0',
	`a_option_2_type` INT(11) NULL DEFAULT '0',
	`a_option_2_level` INT(11) NULL DEFAULT '0',
	`a_option_3_type` INT(11) NULL DEFAULT '0',
	`a_option_3_level` INT(11) NULL DEFAULT '0',
	`a_option_4_type` INT(11) NULL DEFAULT '0',
	`a_option_4_level` INT(11) NULL DEFAULT '0',
	`a_item_name` VARCHAR(50) NOT NULL DEFAULT '\'\'',
	`a_item_level` INT(11) NOT NULL DEFAULT '0',
	`a_item_type` INT(11) NOT NULL DEFAULT '0',
	`a_item_subtype` TINYINT(3) NOT NULL DEFAULT '0',
	`a_item_class` INT(11) NOT NULL DEFAULT '0',
	`a_quantity` INT(11) NOT NULL DEFAULT '0',
	`a_totalmoney` BIGINT(20) NOT NULL DEFAULT '0',
	`a_regist_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_process_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_account_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	`a_sell_charindex` INT(11) NOT NULL DEFAULT '0',
	`a_sell_charname` VARCHAR(50) NOT NULL DEFAULT '\'\'',
	`a_buy_charindex` INT(11) NOT NULL DEFAULT '0',
	`a_buy_charname` VARCHAR(50) NOT NULL DEFAULT '\'\'',
	`a_state` TINYINT(4) NOT NULL DEFAULT '0',
	`a_buycalc_state` TINYINT(4) NOT NULL DEFAULT '0',
	`a_sellcalc_state` TINYINT(4) NOT NULL DEFAULT '0',
	`a_guaranty` INT(11) NOT NULL DEFAULT '0',
	`a_process_state` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0'
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT;

#!  ϱ   , table optimzie  100    15  ð ҿ˴ϴ.

#  ϱ
INSERT t_backup_tradeagent 
SELECT * FROM t_tradeagent WHERE 
((now() > DATE_ADD(a_account_date, interval 8 day)) AND 
((a_state = 1 AND a_buycalc_state = 3 AND a_sellcalc_state = 3) OR 
(a_state = 2 AND a_sellcalc_state = 3))) OR 
(now() > DATE_ADD(a_process_date, interval 16 day));

#  
DELETE FROM t_tradeagent WHERE
((now() > DATE_ADD(a_account_date, interval 8 day)) AND 
((a_state = 1 AND a_buycalc_state = 3 AND a_sellcalc_state = 3) OR 
(a_state = 2 AND a_sellcalc_state = 3))) OR 
(now() > DATE_ADD(a_process_date, interval 16 day));

#optimize  ȭ ϱ
OPTIMIZE TABLE t_tradeagent;

[   ޱ]
 : ǻ

#define DEV_JOB_CHANGE_REWARD

 ε
BETWEEN 6893 AND 6904

Ʈε
BETWEEN 500 AND 505

[̵  ڵ ʱȭ]
 : ǻ
Ŭ̾Ʈ : ⼱

#ifdef BUGFIX_DIFF_RAIDROOMNO
#ifdef DEV_DUNGEON_DIFFICULTY
	#define DEV_AUTO_RESET_RAID
#endif
#endif

 - ߹
http://10.1.90.250/projects/init-raid/wiki

 -  ɾ
/resetraid                          //  Դϴ.  ɾ ܺο  ؾϴ ɾ Դϴ. ٷ  ˴ϴ.
/resetraid check                    //   Reset Ǵ ð Ŭ̾Ʈ ְ ˴ϴ.
/resetraid now                      // ܺο (Ȥ   ִ ,  ) ε ϰ ̵   ؾ ʿ䰡   մϴ.
                                    //  ð 10а   μ մϴ.
̵   ð 
̼  ⺻  03:00   ˴ϴ.
/resetraid [] [ð] []
/resetraid [sun | mon | tue | wed | thu | fri | sat | all] [0 | 1 | 2 | 3 | ... | 23] [0 | 1 | 2 | 3 | ... | 59]
(ǻ )
/resetraid all                      //  00:00 ̵   մϴ.
/resetraid mon                      //   00:00 ̵  մϴ.
/resetraid all 4                    //  04:00 ̵  մϴ.
/resetraid fri 4 30                 //  ݿ 04:30 ̵  մϴ.

 - Ÿ 

ð   Ӽ  directory .setraidinittime  ϰ ˴ϴ.
 Ͽ ̵带 ϴ , ð,   ˴ϴ.
Ӽ  ɶ  ε ϰ ˴ϴ.
     ⺻   03:00 ڵ ̵   ˴ϴ.
 ⺻ ҽ  ú ٸ   ֽϴ.

س ð ̵  ʱȭ ۵˴ϴ.
 ð  03:00̶   03:00
03:04 "n  ̵  ʱȭ ˴ϴ."  īƮٿ
޽ ̵äο ִ  Ŭ̾Ʈ ߼۵˴ϴ.
 03:05 "̵  ʱȭ Դϴ" ޽ ̵Ǹ,
̵   õ ϴ 鿡Դ 
"̵  ʱȭ Դϴ.  ٽ õϿ ֽʽÿ."
޽ ڽ  ˴ϴ.
 03:06  ̵  ʱȭ ˴ϴ.
, ̹     ȣ ͼӵ  
 ʱȭ ȵ˴ϴ. 
 03:10 "̵  ʱȭ ϷǾϴ." ޽  Ǹ,
̵   մϴ.

[ű ]
ġ : http://10.1.90.250/documents/168/
#define JUNO_RENEWAL
#define JUNO_RENEWAL_MESSAGEBOX (̰ 񽺴 ־ )

newproject_data_juno_dev
 - t_npc_regen :  a_zone_num=0
 - t_shop : a_zone_num = 0
 - t_zonedata : a_zone_index=0

newproject_data
 - t_npc : 1, 2, 4, 29~31, 52, 53, 60, 61, 63, 115, 117, 119, 120, 145, 146
		   191, 308, 410~413, 429~438 (Exp  SP )
		   137, 1155 (𵨺) 
		   1152, 1131, 1251~1254 (ű)
 - t_skill, t_skillLevel: 1198~1202, 1354
 - t_magic, t_magicLevel: 1131,1132,1133,1134,1135,1136,1137,1138,1139,1140,1173,
 - t_quest : 1~4, 13~25, 27~43, 47~57, 63, 72, 79, 80, 81, 104, 105, 114, 115,
			 149~160, 234, 237~239, 364~371, 372, 373, 375~380, 386~388 414~416, 420~425,
			 495~499
 - t_mapinfo : a_zone_index=0
 - Ӽ : StartZone_1536_1536_0.sat, StartZone_1536_1536_0.sht

[þ  : Ʈνī]
 
Ŭ̾Ʈ : ¿
1.  ҽ ۾ 
2. DataDB
 - t_item where a_index between 6905 and 6921
 - t_luckydrawbox where a_index between 131 and 137
 - t_luckydrawresult where a_index between 1490 and 1502 or a_index between 1520 and 1522

[ - ξⷳ(Royal Rumble)]
ġ : http://10.1.90.250/documents/169
߹ : http://10.1.90.250/projects/royalrumble/wiki
Ŭ̾Ʈ : 
 : ǻ
ȹ : ¿

1. define 
#define DEV_ROYAL_RUMBLE

2. DB
(DataDB)
t_zonedata
a_zone_index = 38

(CharDB)
CREATE TABLE `t_warground` (
	`a_char_index` INT(10) NOT NULL DEFAULT '0',
	`a_total_kill_count` INT(10) NOT NULL DEFAULT '0',
	`a_total_death_count` INT(10) NOT NULL DEFAULT '0',
	`a_warground_point` INT(10) NOT NULL DEFAULT '0',
	`a_warground_acc_point` INT(10) NOT NULL DEFAULT '0',
	PRIMARY KEY (`a_char_index`)
)
ENGINE=INNODB
ROW_FORMAT=DEFAULT

CREATE TABLE `t_royalrumble_winner_log` (
	`a_char_index` INT(10) NOT NULL DEFAULT '0',
	`a_name` VARCHAR(50) NOT NULL DEFAULT '',
	`a_nick` VARCHAR(50) NOT NULL DEFAULT '',
	`a_leveltype` VARCHAR(50) NOT NULL DEFAULT '',
	`a_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	INDEX `charindex` (`a_char_index`)
)
ENGINE=MyISAM
ROW_FORMAT=DEFAULT

3. newStobm.bin
   - ߰

4. map
   - Pk_RoyalRumble_256_256_0.sht
   - Pk_RoyalRumble_256_256_0.sat

[Ʊ׷]  // Ż 

1. DB
	t_item where a_index in (6801,6802)
	t_quest where a_index in (493)
	t_attack_pet where a_index in (31)

[̵  ͼ ʱȭ ī]
ġ : http://10.1.90.250/documents/171
	#define BUGFIX_RAID_RESET_INIT_CARD				// ̱()  ͼ ʱȭ ī 

[ appearmsg]
ġ : http://10.1.90.250/documents/172
	// #define BUGFIX_APET_TYPE						//   ̵  ȭ ǥ  ȵ.
	 .


[Ƽ ]
-  ϸ Ƽ   ˷ִ ޼

1. define DEV_LETS_PARTYTIME  
//  FLAG ߰
2.    



[ ã ý] // ̺Ʈ

1.	ȹ , Ŭ ̵ο,  ֿ

2.	#define SYSTEM_TREASURE_MAP	//  ã ý
	#define GM_TREASURE_MAP_SAVE_FILE		 ".treasuremapsave"
	#define SYSTEM_TREASURE_MAP_LINKZONE_DROP // ũ   ( ⺻ true ٲְ  ɾ () ϴ.)

3.	DB
	* dataDB
		t_item where a_index between 6937 and 6941) or a_index in (6922);
		t_npc where a_index in (1255);
		t_luckydrawbox where a_index in (138,139);
		t_luckydrawNeed where a_luckydraw_idx in (138,139);
		t_luckydrawResult where a_luckydraw_idx in (138,139);
		--add-drop-table t_zonedata (    )

	
4.	 ɾ.
	
	*  ϱ
	/treasuremapdrop set [ all | cur ] [ on | off ] [ on | off ] [ all | zoneindex.... ]
		ex) /treasuremapdrop set all on on 0 4 7 15 23 32

			- argument   ()
			
			//  
			all :    
			cur :    

			// ũ  . ⼭ On ൵  ÿ off Ǿ ִٸ  ʴ´.
			on  : ũ   drop O 
			off : ũ   drop X

			//   . (̵ ,۽ , , ox    ʴ´.)
			on  :    drop O 
			off :    drop X

			//    .   ε Ѵ. 
			all :    . (̵  ۽    õ ʴ´.)
			zoneindex... :    (̽ ). 

	*    
	/treasuremapdrop ing

5.	SaveFile
	#define GM_TREASURE_MAP_SAVE_FILE		 ".treasuremapsave"
	- zonedata tool Էµ   ⺻  ε Ŀ
	  save   ٽ . save     ε · .
	-       ȣ ǥõ

[ϰǽ  ̺Ʈ]	  
 : ǻ
#define BENNIGANS_EVENT
ġ : http://10.1.90.250/documents/187


[̱  ]
-  繫 +1   ( 5 9 NPC  ̿ϵ  )

 : ǿ
Ŭ : ּҿ

#define DEV_MASTERSTONE_USA
Item : 6111, 6112, 6113, 6114, 6115, 6124, 6120
NPC : 1261 ( t_npc_regen ʿ )




[̰ 10ֳ  ̺Ʈ]
1. , ̵ο, ֿ

2. ҷ ̺Ʈ ũ ̺Ʈ ̿Ͽ ̺Ʈ .
   ҷ ̺Ʈ ȣ ͸ ٸ ͷ (߰)ϰ ȣŻ ũ ڷ (߰) Ѵ.
   ũ ̺Ʈ Ʈ ũ   Ѵ.
      ų  ũ   Ͽ Ѵ.

3. 
	#define EVENT_HALLOWEEN_2007					49      // ҷ ̺Ʈ
	#define EVENT_HALLOWEEN_2007_GAMIGO_10TH_ITEMDROP		// ̰ 10ֳ   .
	#define EVENT_XMAS_2007					50				// ũ ̺Ʈ


4. DB
	߰
		t_npc where a_index in (1283,1304);
		t_npc_regen a_npc_idx in (1283,1304);
		t_item where a_index between 7252 and 7259;
		t_luckydrawbox where a_index = 178;
		t_luckydrawResult where a_luckydraw_idx = 178;

	
		t_item where a_idnex between 2584 and 2589;
		t_skill where between 485 and 489;
		t_npc where a_index = 483;

5. ̺Ʈ  
	update t_npc set a_enable=0 where a_index in (483,1283,1304,1305);

[  ] tag: update 1106
1. , ǻ, 

2.   η̵  

3. define
#if defined (AKAN_TEMPLE) && defined(DEV_DUNGEON_DIFFICULTY)
#define DEV_FORGOTTEN_TEMPLE
#endif
#define DEV_NPC_JOB_ITEM_DROP
#define DEV_NPC_DROP_ITEM_ALL

4. map
data/P_Dungeon1_1152_1152_0.sat
data/P_Dungeon1_1152_1152_0.sht

5. DataDB

t_raid_data
WHERE a_index BETWEEN 45 AND 57

t_raid_object_data
WHERE (a_index BETWEEN 165 AND 191) or (a_index = 274)

t_shop
WHERE a_index = 1279

t_shopitem 
WHERE a_keeper_idx = 1279

t_item
WHERE (a_index BETWEEN 7065 AND 7108) or (a_index = 7111) or (a_index BETWEEN 7126 AND 7136) or (a_index BETWEEN 7260 AND 7273)

t_luckydrawbox
WHERE a_index BETWEEN 164 AND 170

t_luckydrawNeed
WHERE a_luckydraw_idx = 170

t_luckydrawResult
WHERE a_luckydraw_idx BETWEEN 164 AND 170

t_skill
WHERE a_index BETWEEN 1359 AND 1362

t_skillLevel
WHERE a_index BETWEEN 1359 AND 1362

t_magic
WHERE a_index BETWEEN 1184 AND 1187

t_magicLevel
WHERE a_index BETWEEN 1184 AND 1187

t_npc
# NPC
WHERE a_index IN (262,263,264,265,266,267,268,269) # κи Ʈ  
#߰ NPC
WHERE (a_index IN (1259, 1303)) or (a_index BETWEEN 1262 AND 1282)

t_npc_dropjob
--add-drop-table

t_npc_drop_all
--add-drop-table

t_npc_regen_raid
WHERE a_zone_num = 12

t_quest
WHERE a_index IN (568, 569, 570, 572)

t_title
WHERE a_index = 71

t_set_item
WHERE a_set_idx BETWEEN 76 AND 81

t_string
WHERE a_index IN (5492, 5493, 5494, 5496, 5497)

[ξⷳ ] tag: UPDATE 1106

¿, ǻ, 

ξⷳ 
#define DEV_ROYAL_RUMBLE_IMPROVE

t_item
WHERE a_index BETWEEN 7340 AND 7342



[ŷ ý Ȯ]
1. ۾ : (ȹ), (ȹ), ¿(), ּҿ(Ŭ)

2. 
	- ֱ 3   ĳ  ű
	- Ͽ ѹ(Ʈ :   6)  ۸  

3. define
	#define SYSTEM_RANKING_EX
	#ifdef SYSTEM_RANKING_EX
	#undef SYSTEM_RANKING
	#endif
	
	 #define SYSTEM_RANKING 

4. DB
	- t_characters  : a_exp_weekly, a_levelup_date ʵ ߰
	ALTER TABLE `t_characters`  
	ADD COLUMN `a_exp_weekly` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0' AFTER `a_newtuto_complete`,  
	ADD COLUMN `a_levelup_date` DATETIME NULL DEFAULT '0000-00-00 00:00:00' AFTER `a_exp_weekly`;

	- t_ranking_ex ߰
	CREATE TABLE `t_ranking_ex` 
	(`a_char_index` INT(11) NOT NULL DEFAULT '0', 
	`a_rank_by_level` INT(11) NOT NULL DEFAULT '0', 
	`a_rank_by_job` INT(11) NOT NULL DEFAULT '0', 
	`a_refresh_date` DATETIME NULL DEFAULT NULL, 
	INDEX `a_char_index` (`a_char_index`) )ENGINE=MyISAM ROW_FORMAT=FIXED

	- t_ranking_ex_backup ߰
	CREATE TABLE `t_ranking_ex_backup` 
	(`a_char_index` INT(11) NOT NULL DEFAULT '0', 
	`a_rank_by_level` INT(11) NOT NULL DEFAULT '0', 
	`a_rank_by_job` INT(11) NOT NULL DEFAULT '0', 
	`a_refresh_date` DATETIME NULL DEFAULT NULL, 
	INDEX `a_char_index` (`a_char_index`) )ENGINE=MyISAM ROW_FORMAT=FIXED

	- t_ranking_data ߰
	CREATE TABLE `t_ranking_data` 
	(`a_char_index` INT(11) NOT NULL DEFAULT '0', 
	`a_job` INT(11) NOT NULL DEFAULT '0', 
	`a_level` INT(11) NOT NULL DEFAULT '0', 
	`a_exp` BIGINT(20) NULL DEFAULT '0', 
	`a_levelup_date` DATETIME NULL DEFAULT NULL, 
	`a_refresh_date` DATETIME NULL DEFAULT NULL, 
	INDEX `a_char_index` (`a_char_index`))ENGINE=MyISAM ROW_FORMAT=FIXED

	- t_ranking_data_backup ߰
	CREATE TABLE `t_ranking_data_backup` 
	(`a_char_index` INT(11) NOT NULL DEFAULT '0', 
	`a_job` INT(11) NOT NULL DEFAULT '0', 
	`a_level` INT(11) NOT NULL DEFAULT '0', 
	`a_exp` BIGINT(20) NULL DEFAULT '0', 
	`a_levelup_date` DATETIME NULL DEFAULT NULL, 
	`a_refresh_date` DATETIME NULL DEFAULT NULL, 
	INDEX `a_char_index` (`a_char_index`))ENGINE=MyISAM ROW_FORMAT=FIXED

	- t_title  (Ⱓ 1 -> 7 )
	- UPDATE `t_title` SET a_time = 7 where `a_index` between 24 and 31

[ PK гƼ  ] :: ī ý 
1.	ȹ : 
	Ŭ : ڵ
	 : ֿ
	
2.	GameServer, SubHelper

3.	#define REFORM_PK_PENALTY_201108 // 2011-08 PK гƼ  

4.	dataDB
	- ߰
		t_title where a_index between 85 and 90 ;
		t_item where a_index between 7392 and 7397 ;

	- ĳ  ߰
		t_item where a_index between 7474 and 7480;
		t_skill where a_index between 1389 and 1395;
		t_skillLevel where a_index between 1389 and 1395;
		t_magic where a_index in (1212,1215,1218);
		t_magicLvel where a_index in (1212,1215,1218);

5. charDB
	
	- add column t_characters
		ALTER TABLE `t_characters`  ADD COLUMN `a_lcdatestamp` INT(11) NOT NULL DEFAULT '0' AFTER `a_datestamp`;

	- create table
		CREATE TABLE `t_pkpenalty_reward` (
			`a_char_idx` INT(11) NULL DEFAULT '0',
			`a_reward_flag` INT(8) NULL DEFAULT '0',
			UNIQUE INDEX `a_char_idx` (`a_char_idx`),
			INDEX `a_char_idx` (`a_char_idx`)
		)
		ENGINE=MyISAM
		ROW_FORMAT=DEFAULT

[ Ż ڽƬ  DB ]
1. dataDB
	- t_item where (a_index between 7000 and 7041) or (a_index between 7057 and 7063)

[   ǻ  DB ]
1. dataDB
	- t_item where a_index between 6806 and 6847

[   ̺Ʈ ]
1. Event DB
CREATE TABLE `TBL_EventZorro` (
	`a_user_index` INT(10) NOT NULL DEFAULT '0',
	`a_count` INT(10) NOT NULL DEFAULT '0',
	`a_last_update_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	INDEX `UserIndex` (`a_user_index`)
)
ENGINE=MyISAM
ROW_FORMAT=FIXED
CREATE TABLE `TBL_EventIpad` (
	`a_user_index` INT(10) NOT NULL DEFAULT '0',
	`a_count` INT(10) NOT NULL DEFAULT '0',
	`a_last_update_date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
	INDEX `UserIndex` (`a_user_index`)
)
ENGINE=MyISAM
ROW_FORMAT=FIXED;
2. dataDB
	t_item
		7473, 7485 ~ 7512, 7514 ~ 7520, 7522 ~ 7528, 7529 ~ 7535, 7521
	ڰ
		209

3. define
	#define EVENT_BILA_IPAD


[  ڽƬ  DB]
1. dataDB
	- t_item where a_index between 7485 and 7512 or a_index between 7514 and 7520 or a_index between 7522 and 7535

[æƮ +18]
#ifdef EXTEND_ENCHANT_2010
#define DEV_EXTEND_ENCHANT_2011
#undef MAX_UPGRADE_PLUS
#define MAX_UPGRADE_PLUS	18
#endif // EXTEND_ENCHANT_2010

item - 6218

[  ߹ ý]
1. define GUILD_MASTER_AUTO_KICK

2. charDB
 - ALTER TABLE `t_extend_guild`  
 ADD COLUMN `a_kick_status` INT(10) NOT NULL DEFAULT '0' AFTER `a_marktime`,  
 ADD COLUMN `a_kick_request_char_index` INT(10) NOT NULL DEFAULT '0' AFTER `a_kick_status`,  
 ADD COLUMN `a_kick_request_time` INT(11) NOT NULL DEFAULT '0' AFTER `a_kick_request_char_index`,  
 ADD COLUMN `a_lastdate_change_boss` INT(11) NOT NULL DEFAULT '0' AFTER `a_kick_request_time`;

 [  ʴ ý]
 1. define GUILD_REMOTE_INVITE


 [ ý]
 1. define NOTICE_SYSTEM

 2. dataDB (ű  ߰)
	- t_item WHERE a_index = 7736;


[Űοڽ ۸Ʈ   ɾ]

 : Űοڽ ִ  Ʈ  ε Ǿ Ȯϸ(isExist= exist(), not exist()),
	ڽ Ÿ(Random, Prob, All), Ȯ(Prob), ε(rewardIndex)  Ȯν ݴϴ.
	 ڽ ϴ  Ʈ (existCount) µ˴ϴ.

 : compare_boxitem (ڽ ε)

Ex) compare_boxitem 1
 :	[BoxIndex :1]  [rewardIndex :2032]  [isExist :exist]  [type : Random]  [prob : 10000]
		[BoxIndex :1]  [rewardIndex :1840]  [isExist :exist]  [type : Random]  [prob : 0]
		[BoxIndex :1]  [rewardIndex :2033]  [isExist :exist]  [type : Random]  [prob : 0]
		[BoxIndex :1]  [rewardIndex :2034]  [isExist :exist]  [type : Random]  [prob : 0]
		[BoxIndex :1]  [rewardIndex :2035]  [isExist :exist]  [type : Random]  [prob : 0]
		[BoxIndex :1]  [rewardIndex :2036]  [isExist :exist]  [type : Random]  [prob : 0]
		[existCount : 6]

[̱ BCrypt]

뼭(LoginServer, Connector)
ʿ library Botan library : libbotan-1.10.so.0
#define BCRYPT_USA
BCRYPT_USA 鼭 Ŭ̾Ʈ MD5  ʿ.

[ĳ  ]
ּҿ
1. #define CATALOG_FLAG_NOGIFT

[ ɾ ,۾ ߰]
ּҿ
<> : ʼ 
[] : ɼ 
1.  ʱȭ => /jobreset
2.  ( ʿ) => /jobchange <jobtype> [2ndjobtype]
3.  ٷ κ丮  => /itemget <index> [plus] [flag] [count] [option_count] [option_type] [option_level]
4.  ٷ κ丮 ε   => /itemgetrange <index_from> <index_to> [plus] [flag] [count] [option_count] [option_type] [option_level]

[ ɾ ]
1. ѹ NPC ϱ
	- /func kill_npc <Ÿ>
	- (ex) /func kill_npc 20
	- ʹ  NPC  ȯϿ ϸ ϰ մϴ.
2. ٴڿ ӵ  ϰ  ϱ
	- /func del_item < ε>
	- (ex) /func del_item 19
	- 19 () 
	- (ex) /func del_item 0
	-   
	- ĳ ֺ 4X4 cell  ˻Ͽ ϴ.

[ũ ̺Ʈ 2012]
1. #define XMAS_2012
2. ̺Ʈ DB 50 Ȱȭ Ǿ ־ մϴ.
3. ߰ NPC #340 ξ ( Ӱ     ߰)
4. ߰ ̺
	- t_rps_list (  Ʈ)
		CREATE TABLE `t_rps_list` 
		(
			`a_index` INT(10) NOT NULL AUTO_INCREMENT,
			`a_name` VARCHAR(50) NOT NULL DEFAULT '',
			PRIMARY KEY (`a_index`),
			UNIQUE INDEX `a_index` (`a_index`),
			CONSTRAINT `FK_t_rps_list_t_rps_prob` FOREIGN KEY (`a_index`) REFERENCES `t_rps_prob` (`a_system_idx`)
		)ENGINE=INNODB;
	- t_rps_prob (  Ȯ)
		CREATE TABLE `t_rps_prob` 
		(
			`a_system_idx` INT(10) NOT NULL DEFAULT '0',
			`a_level` INT(10) NOT NULL DEFAULT '0',
			`a_userWinProb` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
			`a_serverWinProb` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
			`a_drawProb` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
			UNIQUE INDEX `a_system_idx_a_level` (`a_system_idx`, `a_level`)
		)ENGINE=INNODB;
5.  ɾ
	- xmaspuzzle ing :   Ȯ 
	- xmaspuzzle changeprob [level] [userWinProb] [serverWinProb] : ¸Ȯ ϱ

[ξⷲ  ( )]
1.  ɾ
	- /royalrumble <minimum player> <maximum player> <start hour>
	- minimum player 10 ~ 50  
	- maximum player minimum player ~ 50   
	- start hour 0 ~ 23

2. #define ROYAL_RUMBLE_SETTING_ENABLE
	- #ifdef DEV_ROYAL_RUMBLE


3. dataDB
	DROP TABLE IF EXISTS `t_royalrumble`;
	CREATE TABLE `t_royalrumble` (
		`a_minPlayer` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
		`a_maxPlayer` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
		`a_startHour` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0'
	)
	ENGINE=MyISAM;

	DELETE FROM t_royalrumble;
	#̱
	INSERT INTO `t_royalrumble` (`a_minPlayer`, `a_maxPlayer`, `a_startHour`) VALUES (10, 50, 16);
	#±
	INSERT INTO `t_royalrumble` (`a_minPlayer`, `a_maxPlayer`, `a_startHour`) VALUES (10, 50, 21);
	#̰,,ȫ,þ
	INSERT INTO `t_royalrumble` (`a_minPlayer`, `a_maxPlayer`, `a_startHour`) VALUES (10, 50, 22);

4. 
	- DB min 10̸ 50ʰ , max min ̸ 50ʰ  ⺻ min = 10, max = 50, ۽ð  ú ⺻ ð ۵˴ϴ.