Èç¹ûÄãÊÇ´«Ææµ¥»ú°æµÄÐÂÊÖGM£¬ÏëÒª¿ìËÙÆÁ±Î·³È˵ôÂäÌáʾ£¬°´ÕÕÒÔϲ½Öè²Ù×÷£º
µÚÒ»²½ ¶¨Î»ÎïÆ·Êý¾Ý¿â
1. ´ò¿ª·þÎñ¶ËÎļþ¼Ð
2. ÕÒµ½¡¸D:\MirServer\Mir200\Envir¡¹Ä¿Â¼Ïµġ¸StdItems.DB¡¹£¨²»Í¬ÒýÇæ¿ÉÄܺó׺²»Í¬£©
3. ÓÃDBEµÈÊý¾Ý¿â±à¼Æ÷´ò¿ª
µÚ¶þ²½ ÅúÁ¿Ð޸Ĺؼü×Ö¶Î
1. ÕÒµ½Ò©Æ·ºÍÀ¬»ø×°±¸µÄ·ÖÀࣨͨ³£Îª¡¸Ò©Æ·¡¹¡¸Ê×ÊΡ¹¡¸½£¼×¡¹µÈ£©
2. ÅúÁ¿Ð޸ġ¸NeedHint¡¹×Ö¶ÎֵΪ0£¨ÔÖµ¿ÉÄÜÊÇ1£©
3. ±£´æÐ޸IJ¢ÖØÆô·þÎñ¶Ë
µÚÈý²½ Ñé֤Ч¹û
1. ½øÈëÓÎÏ·»÷ɱ¹ÖÎï²âÊÔ
2. ¹Û²ìÒ©Æ·/À¬»ø×°±¸ÊÇ·ñ²»ÔÙË¢ÆÁ
3. ¼ì²é¼«Æ·×°±¸ÊÇ·ñÕý³£ÏÔʾ£¨ÈçÐèÏÔʾÔòµ¥¶À¹´Ñ¡¸Ã×°±¸µÄNeedHint£©
ͨ¹ýÒÔÉϲÙ×÷¼´¿É½â¾ö95%µÄµôÂäÌáʾÒì³£ÎÊÌâ¡£ÈôÈÔÓиö±ðÎïÆ·ÌáʾÒì³££¬¿É²Î¿¼ÏÂÎĽø½×ÅŲ鷽°¸¡£
---
📢¡¶Áã»ù´¡½â¾ö´«ÆæµôÂäÌáʾ´íÂÒ¡·Í¼ÎĽ̳Ì
Ò»¡¢ÎÊÌâÏÖÏó½âÎö
µ±ÎÒÃǼÜÉè[´«Ææµ¥»ú°æ]ʱ£¬¾³£»áÓöµ½ÕâÑùµÄÀ§ÈÅ£º
• ❌ »÷ɱ¹ÖÎïºóÂúÆÁµÄ¡¸Ç¿Ð§½ð´´Ò©µôÂ䡹Ìáʾ
• ❌ À¬»ø×°±¸·´¸´Ë¢ÆÁÕÚµ²ÁÄÌì¿ò
• ✅ ÕæÕýÓмÛÖµµÄÍÀÁú¡¢²Ã¾öµÈ¼«Æ·×°±¸È´ÎÞÌáʾ
ÕâÖÖÏÖÏóͨ³£ÓÉÒÔÏÂÔÒòµ¼Ö£º
¶þ¡¢ºËÐÄÔÀí˵Ã÷
ÔÚÖ÷Á÷ÒýÇæ£¨ÈçHero/BlueÒýÇæ£©ÖУ¬µôÂäÌáʾÊÜË«ÖØ¿ØÖÆ£º
| ¿ØÖƲ㼶 | ÅäÖÃÎļþ | ¹Ø¼ü×Ö¶Î | ÉúЧÓÅÏȼ¶ |
|-----------------|-------------------|---------------|------------|
| È«¾ÖÉèÖà | M2-Ñ¡Ïî-ÎïÆ·ÉèÖà | ĬÈÏÌáʾ¿ª¹Ø | µÍ |
| ÎïÆ·Êý¾Ý¿â | StdItems.DB | NeedHint×Ö¶Î | ¸ß |
ÕâÒâζ×Å£º
1. µ±Ä³ÎïÆ·µÄNeedHint=1ʱ Ç¿ÖÆÏÔʾÌáʾ
2. µ±NeedHint=0ʱ ×ñÑÈ«¾ÖÉèÖÃ
3. µ±È«¾ÖÉèÖùرÕʱ ËùÓÐÎ´Ç¿ÖÆÌáʾµÄÎïÆ·¶¼²»ÏÔʾ
Èý¡¢Ïêϸ½â¾ö²½Öè
3.1 »ù´¡ÅŲ飨ÊÊÓÃËùÓÐÒýÇæ£©
1️⃣ ´ò¿ªM2Server
·¾¶£º`D:\MirServer\Mir200\M2Server.exe`
2️⃣ ¼ì²éÈ«¾ÖÉèÖÃ
```
M2²Ëµ¥ → Ñ¡Ïî → ÎïÆ·ÉèÖà → ¹´Ñ¡/È¡Ïû¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
```
3️⃣ ÑéÖ¤Êý¾Ý¿â×Ö¶Î
ʹÓá¸DB Commander¡¹´ò¿ªStdItems.DB£º
```sql
SELECT * FROM StdItems WHERE Name IN ('ǿЧ½ð´´Ò©','ÉúÌú½äÖ¸')
```
¹Û²ì²éѯ½á¹ûÖС¸NeedHint¡¹×ֶεÄÖµ£º
• ÈôΪ1 → ¸ÃÎïÆ·Ç¿ÖÆÌáʾ
• ÈôΪ0 → ÊÜÈ«¾ÖÉèÖÿØÖÆ
3.2 ½ø½×ÅäÖã¨HeroÒýÇæÊ¾Àý£©
Çé¿öÒ»£ºÏëÍêÈ«¹Ø±ÕËùÓÐÌáʾ
```
¢Ù M2ÖÐÈ¡Ïû¹´Ñ¡¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
¢Ú Ö´ÐÐSQLÅúÁ¿¸üУº
UPDATE StdItems SET NeedHint=0 WHERE NeedHint=1
```
Çé¿ö¶þ£º½öÏÔʾ¼«Æ·×°±¸Ìáʾ
```
¢Ù M2Öб£³Ö¹´Ñ¡¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
¢Ú ¶Ô¼«Æ·×°±¸µ¥¶ÀÉèÖãº
UPDATE StdItems SET NeedHint=1 WHERE Name IN ('ÍÀÁú','Ê¥Õ½½äÖ¸')
```
Çé¿öÈý£º½Å±¾¼¶¿ØÖÆ£¨ÊÊÓÃÓÚ¶¨Öư汾£©
¼ì²éQManage.txtµÇ¼½Å±¾£º
```lua
[@Login]
#IF
#ACT
SetMsgFilter 0 --0¹Ø±ÕÌáʾ 1¿ªÆôÌáʾ
```
Èç¹û´æÔÚÀàËÆÃüÁÐÞ¸ÄÊýÖµ¼´¿ÉÈ«¾Ö¿ØÖÆ¡£
ËÄ¡¢ÒÉÄÑÎÊÌâÅŲé
4.1 ±¬ÂÊÎļþ¸ÉÈÅ
ijЩ°æ±¾µÄ±¬ÂÊÎļþ»áÇ¿ÖÆÌáʾ£º
```txt
D:\MirServer\Mir200\Envir\MonItems\°×Ò°Öí.txt
1/1 ǿЧ̫ÑôË® ÊýÁ¿=3 ->SendMsg 5¡¾°×Ò°Öí±¬³öÁËǿЧ̫ÑôË®£¡¡¿
```
½â¾ö·½°¸£ºÉ¾³ý`->`ºóµÄÌáʾÃüÁî
4.2 ²å¼þ³åÍ»
Èç¹û°²×°ÁË¡¸PG²å¼þ¡¹¡¸ESP²å¼þ¡¹µÈ£¬¼ì²é£º
```
M2→²å¼þ¹ÜÀí→¶ÔÓ¦²å¼þ→ÏûÏ¢¹ýÂËÉèÖÃ
```
²¿·Ö²å¼þ»á½Ù³ÖµôÂäÌáʾ¹¦ÄÜ¡£
4.3 ¿ÉÊÓ»¯¹¤¾ßÍÆ¼ö
ʹÓḴ«ÆæÅäÖÃÖúÊÖ¡¹¿É¿ìËÙÅúÁ¿Ð޸ģº
1. µ¼ÈëStdItems.DB
2. °´·ÖÀàɸѡҩƷ/À¬»ø×°±¸
3. ÅúÁ¿ÐÞ¸ÄNeedHint×Ö¶Î
4. ×Ô¶¯Éú³ÉSQLÖ´Ðнű¾
Îå¡¢×î¼Ñʵ¼ù½¨Òé
1. ·Ö¼¶Ìáʾ²ßÂÔ
```
ÆÕͨװ±¸£ºNeedHint=0£¨¸úËæÈ«¾Ö£©
ÎÖÂê×°±¸£ºNeedHint=1
׿Âê×°±¸£ºNeedHint=1 + ²ÊÉ«¹«¸æ
³àÔÂ×°±¸£ºNeedHint=1 + È«·þÆ®ÆÁ
```
2. ¶¨ÆÚÇåÀíÈßÓàÊý¾Ý
ʹÓÃSQLÓï¾ä£º
```sql
-- ÇåÀíÎÞЧÎïÆ·
DELETE FROM StdItems WHERE NOT EXISTS (
SELECT 1 FROM MonItems WHERE ItemName=StdItems.Name
)
```
ͨ¹ýÒÔÉÏ·½·¨£¬¼´¿É¾«×¼¿ØÖƵôÂäÌáʾ£¬¼È±£ÁôÁ˼«Æ·×°±¸µÄ¾ªÏ²¸Ð£¬ÓÖ±ÜÃâÁËÀ¬»øÐÅϢˢÆÁ¡£½¨ÒéÐÞ¸Äǰ±¸·ÝÕû¸öEnvirÎļþ¼Ð£¬ÒÔ·ÀÎó²Ù×÷µ¼ÖÂÊý¾Ý¶ªÊ§¡£
µÚÒ»²½ ¶¨Î»ÎïÆ·Êý¾Ý¿â
1. ´ò¿ª·þÎñ¶ËÎļþ¼Ð
2. ÕÒµ½¡¸D:\MirServer\Mir200\Envir¡¹Ä¿Â¼Ïµġ¸StdItems.DB¡¹£¨²»Í¬ÒýÇæ¿ÉÄܺó׺²»Í¬£©
3. ÓÃDBEµÈÊý¾Ý¿â±à¼Æ÷´ò¿ª
µÚ¶þ²½ ÅúÁ¿Ð޸Ĺؼü×Ö¶Î
1. ÕÒµ½Ò©Æ·ºÍÀ¬»ø×°±¸µÄ·ÖÀࣨͨ³£Îª¡¸Ò©Æ·¡¹¡¸Ê×ÊΡ¹¡¸½£¼×¡¹µÈ£©
2. ÅúÁ¿Ð޸ġ¸NeedHint¡¹×Ö¶ÎֵΪ0£¨ÔÖµ¿ÉÄÜÊÇ1£©
3. ±£´æÐ޸IJ¢ÖØÆô·þÎñ¶Ë
µÚÈý²½ Ñé֤Ч¹û
1. ½øÈëÓÎÏ·»÷ɱ¹ÖÎï²âÊÔ
2. ¹Û²ìÒ©Æ·/À¬»ø×°±¸ÊÇ·ñ²»ÔÙË¢ÆÁ
3. ¼ì²é¼«Æ·×°±¸ÊÇ·ñÕý³£ÏÔʾ£¨ÈçÐèÏÔʾÔòµ¥¶À¹´Ñ¡¸Ã×°±¸µÄNeedHint£©
ͨ¹ýÒÔÉϲÙ×÷¼´¿É½â¾ö95%µÄµôÂäÌáʾÒì³£ÎÊÌâ¡£ÈôÈÔÓиö±ðÎïÆ·ÌáʾÒì³££¬¿É²Î¿¼ÏÂÎĽø½×ÅŲ鷽°¸¡£
---
📢¡¶Áã»ù´¡½â¾ö´«ÆæµôÂäÌáʾ´íÂÒ¡·Í¼ÎĽ̳Ì
Ò»¡¢ÎÊÌâÏÖÏó½âÎö
µ±ÎÒÃǼÜÉè[´«Ææµ¥»ú°æ]ʱ£¬¾³£»áÓöµ½ÕâÑùµÄÀ§ÈÅ£º
• ❌ »÷ɱ¹ÖÎïºóÂúÆÁµÄ¡¸Ç¿Ð§½ð´´Ò©µôÂ䡹Ìáʾ
• ❌ À¬»ø×°±¸·´¸´Ë¢ÆÁÕÚµ²ÁÄÌì¿ò
• ✅ ÕæÕýÓмÛÖµµÄÍÀÁú¡¢²Ã¾öµÈ¼«Æ·×°±¸È´ÎÞÌáʾ
ÕâÖÖÏÖÏóͨ³£ÓÉÒÔÏÂÔÒòµ¼Ö£º
¶þ¡¢ºËÐÄÔÀí˵Ã÷
ÔÚÖ÷Á÷ÒýÇæ£¨ÈçHero/BlueÒýÇæ£©ÖУ¬µôÂäÌáʾÊÜË«ÖØ¿ØÖÆ£º
| ¿ØÖƲ㼶 | ÅäÖÃÎļþ | ¹Ø¼ü×Ö¶Î | ÉúЧÓÅÏȼ¶ |
|-----------------|-------------------|---------------|------------|
| È«¾ÖÉèÖà | M2-Ñ¡Ïî-ÎïÆ·ÉèÖà | ĬÈÏÌáʾ¿ª¹Ø | µÍ |
| ÎïÆ·Êý¾Ý¿â | StdItems.DB | NeedHint×Ö¶Î | ¸ß |
ÕâÒâζ×Å£º
1. µ±Ä³ÎïÆ·µÄNeedHint=1ʱ Ç¿ÖÆÏÔʾÌáʾ
2. µ±NeedHint=0ʱ ×ñÑÈ«¾ÖÉèÖÃ
3. µ±È«¾ÖÉèÖùرÕʱ ËùÓÐÎ´Ç¿ÖÆÌáʾµÄÎïÆ·¶¼²»ÏÔʾ
Èý¡¢Ïêϸ½â¾ö²½Öè
3.1 »ù´¡ÅŲ飨ÊÊÓÃËùÓÐÒýÇæ£©
1️⃣ ´ò¿ªM2Server
·¾¶£º`D:\MirServer\Mir200\M2Server.exe`
2️⃣ ¼ì²éÈ«¾ÖÉèÖÃ
```
M2²Ëµ¥ → Ñ¡Ïî → ÎïÆ·ÉèÖà → ¹´Ñ¡/È¡Ïû¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
```
3️⃣ ÑéÖ¤Êý¾Ý¿â×Ö¶Î
ʹÓá¸DB Commander¡¹´ò¿ªStdItems.DB£º
```sql
SELECT * FROM StdItems WHERE Name IN ('ǿЧ½ð´´Ò©','ÉúÌú½äÖ¸')
```
¹Û²ì²éѯ½á¹ûÖС¸NeedHint¡¹×ֶεÄÖµ£º
• ÈôΪ1 → ¸ÃÎïÆ·Ç¿ÖÆÌáʾ
• ÈôΪ0 → ÊÜÈ«¾ÖÉèÖÿØÖÆ
3.2 ½ø½×ÅäÖã¨HeroÒýÇæÊ¾Àý£©
Çé¿öÒ»£ºÏëÍêÈ«¹Ø±ÕËùÓÐÌáʾ
```
¢Ù M2ÖÐÈ¡Ïû¹´Ñ¡¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
¢Ú Ö´ÐÐSQLÅúÁ¿¸üУº
UPDATE StdItems SET NeedHint=0 WHERE NeedHint=1
```
Çé¿ö¶þ£º½öÏÔʾ¼«Æ·×°±¸Ìáʾ
```
¢Ù M2Öб£³Ö¹´Ñ¡¡¸ÏÔʾÎïÆ·µôÂäÌáʾ¡¹
¢Ú ¶Ô¼«Æ·×°±¸µ¥¶ÀÉèÖãº
UPDATE StdItems SET NeedHint=1 WHERE Name IN ('ÍÀÁú','Ê¥Õ½½äÖ¸')
```
Çé¿öÈý£º½Å±¾¼¶¿ØÖÆ£¨ÊÊÓÃÓÚ¶¨Öư汾£©
¼ì²éQManage.txtµÇ¼½Å±¾£º
```lua
[@Login]
#IF
#ACT
SetMsgFilter 0 --0¹Ø±ÕÌáʾ 1¿ªÆôÌáʾ
```
Èç¹û´æÔÚÀàËÆÃüÁÐÞ¸ÄÊýÖµ¼´¿ÉÈ«¾Ö¿ØÖÆ¡£
ËÄ¡¢ÒÉÄÑÎÊÌâÅŲé
4.1 ±¬ÂÊÎļþ¸ÉÈÅ
ijЩ°æ±¾µÄ±¬ÂÊÎļþ»áÇ¿ÖÆÌáʾ£º
```txt
D:\MirServer\Mir200\Envir\MonItems\°×Ò°Öí.txt
1/1 ǿЧ̫ÑôË® ÊýÁ¿=3 ->SendMsg 5¡¾°×Ò°Öí±¬³öÁËǿЧ̫ÑôË®£¡¡¿
```
½â¾ö·½°¸£ºÉ¾³ý`->`ºóµÄÌáʾÃüÁî
4.2 ²å¼þ³åÍ»
Èç¹û°²×°ÁË¡¸PG²å¼þ¡¹¡¸ESP²å¼þ¡¹µÈ£¬¼ì²é£º
```
M2→²å¼þ¹ÜÀí→¶ÔÓ¦²å¼þ→ÏûÏ¢¹ýÂËÉèÖÃ
```
²¿·Ö²å¼þ»á½Ù³ÖµôÂäÌáʾ¹¦ÄÜ¡£
4.3 ¿ÉÊÓ»¯¹¤¾ßÍÆ¼ö
ʹÓḴ«ÆæÅäÖÃÖúÊÖ¡¹¿É¿ìËÙÅúÁ¿Ð޸ģº
1. µ¼ÈëStdItems.DB
2. °´·ÖÀàɸѡҩƷ/À¬»ø×°±¸
3. ÅúÁ¿ÐÞ¸ÄNeedHint×Ö¶Î
4. ×Ô¶¯Éú³ÉSQLÖ´Ðнű¾
Îå¡¢×î¼Ñʵ¼ù½¨Òé
1. ·Ö¼¶Ìáʾ²ßÂÔ
```
ÆÕͨװ±¸£ºNeedHint=0£¨¸úËæÈ«¾Ö£©
ÎÖÂê×°±¸£ºNeedHint=1
׿Âê×°±¸£ºNeedHint=1 + ²ÊÉ«¹«¸æ
³àÔÂ×°±¸£ºNeedHint=1 + È«·þÆ®ÆÁ
```
2. ¶¨ÆÚÇåÀíÈßÓàÊý¾Ý
ʹÓÃSQLÓï¾ä£º
```sql
-- ÇåÀíÎÞЧÎïÆ·
DELETE FROM StdItems WHERE NOT EXISTS (
SELECT 1 FROM MonItems WHERE ItemName=StdItems.Name
)
```
ͨ¹ýÒÔÉÏ·½·¨£¬¼´¿É¾«×¼¿ØÖƵôÂäÌáʾ£¬¼È±£ÁôÁ˼«Æ·×°±¸µÄ¾ªÏ²¸Ð£¬ÓÖ±ÜÃâÁËÀ¬»øÐÅϢˢÆÁ¡£½¨ÒéÐÞ¸Äǰ±¸·ÝÕû¸öEnvirÎļþ¼Ð£¬ÒÔ·ÀÎó²Ù×÷µ¼ÖÂÊý¾Ý¶ªÊ§¡£

