ÆÕÍ¨Íæ¼ÒÔÚµ¥»ú°æÄ§Óò»·¾³Ï£¬È·Êµ¾ß±¸Ö±½ÓÐÞ¸ÄÊý¾Ý¿âµÄÄÜÁ¦£¬Ç°ÌáÊÇÓÎÏ·ÔËÐÐÔÚ±¾µØÇÒÓµÓÐÊý¾Ý¿â·ÃÎÊȨÏÞ¡£Í¨¹ýµ÷Õû½Çɫװ±¸Êý¾Ý±í£¬¿É½«Ö¸¶¨×°±¸ÉèÖÃΪȫÊôÐÔ״̬¡£µ«¸Ã²Ù×÷½öÊÊÓÃÓÚÀëÏßµ¥»ú»·¾³£¬¶ÔÈκÎÁªÍø°æ±¾ÎÞЧ¡£
µÚÒ»£¬È·ÈÏÊý¾Ý¿âÀàÐÍÓë·ÃÎʹ¤¾ß¡£µ¥»ú°æÄ§Óòͨ³£Ê¹ÓÃMySQL»òMicrosoft SQL Server´æ´¢Êý¾Ý¡£Ðè°²×°¶ÔÓ¦¹ÜÀí¹¤¾ß£¬ÈçphpMyAdmin£¨MySQL£©»òSQL Server Management Studio£¨MSSQL£©¡£Êý¾Ý¿âÃû³Æ³£¼ûΪmy3¡¢mir or mythos£¬Õ˺ÅÃÜÂë¶àΪtest/test»òroot/root¡£
µÚ¶þ£¬¶¨Î»×°±¸Êý¾ÝËùÔÚ±í¡£¹Ø¼ü±í°üÀ¨£º
ItemTable »ò UserItem£º´æ´¢Íæ¼Ò±³°ü¡¢²Ö¿â¡¢´©´÷ÖеÄÎïÆ·£»
ItemInfo »ò StdItems£º¶¨Òå×°±¸»ù´¡ÊôÐÔÄ£°å£»
Character »ò AccountCharacter£º¹ØÁª½ÇÉ«ÓëÎïÆ·¼Ç¼¡£
×°±¸ÊÇ·ñΪ“È«ÊôÐÔ”ÓÉItemTableÖеÄ×ֶξö¶¨£¬³£¼û×Ö¶ÎÈ磺
AttackMin, AttackMax£¨ÎïÀí¹¥»÷£©
Defence, MagicDef£¨·ÀÓù£©
Dex, Str, Int, Luc£¨ËÄάÊôÐÔ£©
ExtData »ò EffectValue£¨À©Õ¹ÊôÐÔ×Ö½ÚÁ÷£©
µÚÈý£¬ÐÞ¸ÄÒÑ»ñµÃ×°±¸µÄÊôÐÔÖµ¡£ÒÔMySQLΪÀý£¬Ö´ÐÐÒÔÏÂSQLÓï¾ä£¨¼ÙÉè½ÇÉ«IDΪ1001£¬×°±¸Î»ÖÃΪÎäÆ÷À¸£©£º
UPDATE ItemTable
SET AttackMin = 9999, AttackMax = 9999,
Str = 999, Dex = 999, Int = 999, Luc = 999,
Defence = 5000, MagicDef = 5000
WHERE CharID = 1001 AND Position = 0;
Position=0ͨ³£´ú±íÎäÆ÷À¸£¬¾ßÌåÖµÐè²Î¿¼·þÎñ¶ËÅäÖá£ÊýÖµ²»¿É³¬¹ý¿Í»§¶ËÏÔʾÉÏÏÞ£¨Í¨³£ÎªÎåλÊý£©£¬·ñÔò¿ÉÄÜÏÔʾÒì³£»ò±ÀÀ£¡£
µÚËÄ£¬´¦Àí“È«ÊôÐÔ”±êʶλ¡£²¿·Ö°æ±¾Í¨¹ýÌØÊâ±ê־λ¼¤»îÒþ²ØÊôÐÔ¡£ÀýÈ磬ÔÚExtData×Ö¶Îĩβ׷¼ÓÌØ¶¨×Ö½Ú£¨Èç01 00 00 00 ±íʾȫÊôÐÔ¿ªÆô£©¡£´Ë²Ù×÷Ðè½èÖúÊ®Áù½øÖÆ±à¼Æ÷»ò×Ô¶¨Òå½Å±¾£¬²»½¨ÒéÐÂÊÖÖ±½ÓÐ޸ģ¬Ò×µ¼ÖÂÎïÆ·Ïûʧ¡£
µÚÎ壬֨Æô·þÎñ¶ËʹÐÞ¸ÄÉúЧ¡£Êý¾Ý¿â¸ü¸Äºó£¬±ØÐëÖØÆôGameServer»òÖØÐµÇ¼½ÇÉ«£¬·ñÔòÄÚ´æÖÐÈÔ±£Áô¾ÉÊý¾Ý¡£ÈôÐ޸ĺó×°±¸Ïûʧ£¬Á¢¼´Í£Ö¹·þÎñ¶Ë£¬´Ó±¸·Ý»Ö¸´ItemTable¡£
µÚÁù£¬×¢ÒâÊÂÏî¡£
ÐÞ¸ÄǰÎñ±Ø±¸·ÝÕû¸öÊý¾Ý¿â£»
²»¿ÉÖ±½ÓÐÞ¸ÄItemInfo±íÖеÄÄ£°åÊôÐÔ£¬·ñÔòÓ°ÏìËùÓÐͬÀà×°±¸£»
ijЩ°æ±¾×°±¸ÊôÐÔÊܿͻ§¶ËУÑ飬¼´Ê¹Êý¾Ý¿â¸Ä¸ß£¬ÓÎÏ·ÄÚÈÔÏÔʾÔʼÊýÖµ£»
È«ÊôÐÔ×°±¸¿ÉÄܵ¼Ö¼¼ÄܼÆËãÒç³ö£¬Òý·¢½ÇÉ«¿¨ËÀ»òµØÍ¼´íÂÒ¡£
×ÛÉÏ£¬ÆÕÍ¨Íæ¼ÒÔÚµ¥»ú»·¾³Ï¿Éͨ¹ýÊý¾Ý¿â¹¤¾ßÖ±½Ó±à¼×°±¸ÊôÐÔ£¬ÊµÏÖÈ«ÊôÐÔЧ¹û¡£²Ù×÷ºËÐÄÔÚÓÚ¾«×¼¶¨Î»½ÇÉ«ÎïÆ·¼Ç¼²¢ºÏÀí¸³Öµ£¬±ÜÃâÆÆ»µÊý¾Ý½á¹¹¡£¸Ã·½·¨½öÏÞ¸öÈËÓéÀÖ£¬²»¾ß±¸Í¨ÓÃÐÔ¡£
µÚÒ»£¬È·ÈÏÊý¾Ý¿âÀàÐÍÓë·ÃÎʹ¤¾ß¡£µ¥»ú°æÄ§Óòͨ³£Ê¹ÓÃMySQL»òMicrosoft SQL Server´æ´¢Êý¾Ý¡£Ðè°²×°¶ÔÓ¦¹ÜÀí¹¤¾ß£¬ÈçphpMyAdmin£¨MySQL£©»òSQL Server Management Studio£¨MSSQL£©¡£Êý¾Ý¿âÃû³Æ³£¼ûΪmy3¡¢mir or mythos£¬Õ˺ÅÃÜÂë¶àΪtest/test»òroot/root¡£
µÚ¶þ£¬¶¨Î»×°±¸Êý¾ÝËùÔÚ±í¡£¹Ø¼ü±í°üÀ¨£º
ItemTable »ò UserItem£º´æ´¢Íæ¼Ò±³°ü¡¢²Ö¿â¡¢´©´÷ÖеÄÎïÆ·£»
ItemInfo »ò StdItems£º¶¨Òå×°±¸»ù´¡ÊôÐÔÄ£°å£»
Character »ò AccountCharacter£º¹ØÁª½ÇÉ«ÓëÎïÆ·¼Ç¼¡£
×°±¸ÊÇ·ñΪ“È«ÊôÐÔ”ÓÉItemTableÖеÄ×ֶξö¶¨£¬³£¼û×Ö¶ÎÈ磺
AttackMin, AttackMax£¨ÎïÀí¹¥»÷£©
Defence, MagicDef£¨·ÀÓù£©
Dex, Str, Int, Luc£¨ËÄάÊôÐÔ£©
ExtData »ò EffectValue£¨À©Õ¹ÊôÐÔ×Ö½ÚÁ÷£©
µÚÈý£¬ÐÞ¸ÄÒÑ»ñµÃ×°±¸µÄÊôÐÔÖµ¡£ÒÔMySQLΪÀý£¬Ö´ÐÐÒÔÏÂSQLÓï¾ä£¨¼ÙÉè½ÇÉ«IDΪ1001£¬×°±¸Î»ÖÃΪÎäÆ÷À¸£©£º
UPDATE ItemTable
SET AttackMin = 9999, AttackMax = 9999,
Str = 999, Dex = 999, Int = 999, Luc = 999,
Defence = 5000, MagicDef = 5000
WHERE CharID = 1001 AND Position = 0;
Position=0ͨ³£´ú±íÎäÆ÷À¸£¬¾ßÌåÖµÐè²Î¿¼·þÎñ¶ËÅäÖá£ÊýÖµ²»¿É³¬¹ý¿Í»§¶ËÏÔʾÉÏÏÞ£¨Í¨³£ÎªÎåλÊý£©£¬·ñÔò¿ÉÄÜÏÔʾÒì³£»ò±ÀÀ£¡£
µÚËÄ£¬´¦Àí“È«ÊôÐÔ”±êʶλ¡£²¿·Ö°æ±¾Í¨¹ýÌØÊâ±ê־λ¼¤»îÒþ²ØÊôÐÔ¡£ÀýÈ磬ÔÚExtData×Ö¶Îĩβ׷¼ÓÌØ¶¨×Ö½Ú£¨Èç01 00 00 00 ±íʾȫÊôÐÔ¿ªÆô£©¡£´Ë²Ù×÷Ðè½èÖúÊ®Áù½øÖÆ±à¼Æ÷»ò×Ô¶¨Òå½Å±¾£¬²»½¨ÒéÐÂÊÖÖ±½ÓÐ޸ģ¬Ò×µ¼ÖÂÎïÆ·Ïûʧ¡£
µÚÎ壬֨Æô·þÎñ¶ËʹÐÞ¸ÄÉúЧ¡£Êý¾Ý¿â¸ü¸Äºó£¬±ØÐëÖØÆôGameServer»òÖØÐµÇ¼½ÇÉ«£¬·ñÔòÄÚ´æÖÐÈÔ±£Áô¾ÉÊý¾Ý¡£ÈôÐ޸ĺó×°±¸Ïûʧ£¬Á¢¼´Í£Ö¹·þÎñ¶Ë£¬´Ó±¸·Ý»Ö¸´ItemTable¡£
µÚÁù£¬×¢ÒâÊÂÏî¡£
ÐÞ¸ÄǰÎñ±Ø±¸·ÝÕû¸öÊý¾Ý¿â£»
²»¿ÉÖ±½ÓÐÞ¸ÄItemInfo±íÖеÄÄ£°åÊôÐÔ£¬·ñÔòÓ°ÏìËùÓÐͬÀà×°±¸£»
ijЩ°æ±¾×°±¸ÊôÐÔÊܿͻ§¶ËУÑ飬¼´Ê¹Êý¾Ý¿â¸Ä¸ß£¬ÓÎÏ·ÄÚÈÔÏÔʾÔʼÊýÖµ£»
È«ÊôÐÔ×°±¸¿ÉÄܵ¼Ö¼¼ÄܼÆËãÒç³ö£¬Òý·¢½ÇÉ«¿¨ËÀ»òµØÍ¼´íÂÒ¡£
×ÛÉÏ£¬ÆÕÍ¨Íæ¼ÒÔÚµ¥»ú»·¾³Ï¿Éͨ¹ýÊý¾Ý¿â¹¤¾ßÖ±½Ó±à¼×°±¸ÊôÐÔ£¬ÊµÏÖÈ«ÊôÐÔЧ¹û¡£²Ù×÷ºËÐÄÔÚÓÚ¾«×¼¶¨Î»½ÇÉ«ÎïÆ·¼Ç¼²¢ºÏÀí¸³Öµ£¬±ÜÃâÆÆ»µÊý¾Ý½á¹¹¡£¸Ã·½·¨½öÏÞ¸öÈËÓéÀÖ£¬²»¾ß±¸Í¨ÓÃÐÔ¡£

