Other the game tells me they cant @s_repair that item (any item)

[Wiccawest]

I reused the taoist village clothing special repair npc and added repair and special repair to all items. I can repair any item but the problem is I can't special repair any items. I deleted market prices and saves too. There's lots of special repair npc threads on this forum and I copied them and other npc files on the server to edit this file. Sorry for inconveniencing experienced forum users with such a dumb problem.

The file is below:

;Info [ Npc Name{Mike} X=203 Y=321 MapName={TaoVillage} ]
(@s_repair)
;NPC Release 1 (2003) By Geoff
;99% Translated NPCs Including Quests

;Settings
(@repair @buy @sell)
%100
+5
+6
+8
+9
+10
+11
+12
+15
+19
+20
+21
+22
+23
+24
+25
+26
+29
+30
+52
+53
+54
+62
+64

;Settings
(@s_repair)
%200
+5
+6
+8
+9
+10
+11
+12
+15
+19
+20
+21
+22
+23
+24
+25
+26
+29
+30
+52
+53
+54
+62
+64

[@main]
#IF
checkpkpoint 2
#SAY
I will not help an evil person like you..\ \
<Ok/@exit>

#ELSEACT
goto @main-1


[@main-1]
Hello <$USERNAME>,\
I've Spent my life learning the special repair abilities on every type of item.\
I do a fine job repairing them and take pride in my work.\
It will cost you much more than if you went to any shop to get a repair.\
Of course if you can't afford the special repair I can normal repair the item as well.\ \
<repair/@repair> an item\
<Special repair/@s_repair> an item\
<Cancel/@exit>


[@s_repair]
\
Which item would you like to special repair?\ \
<Back to main.../@main>\
<Cancel/@exit>

[~@s_repair]
\
That does it, your item is fully repaired.\ \
<Back to main.../@main>\
<Cancel/@exit>


[@repair]
\
Which item would you like to repair?\ \
<Back to main.../@main>\
<Cancel/@exit>

[~@repair]
Thank you for choosing me to repair your item, please come again.\ \
<Back to main.../@main>\
<Cancel/@exit>


[goods]
;Item Amount Time

---------- Post Merged at 04:51 PM ---------- Previous Post was at 03:01 PM ----------

Should I not use an existing npc and make a new one?

 

[Ardbeg]

The npc commands are bugged for special repair on items, doesn't matter how you do it.
Weapons special repair works.
The Repair Hammer and Sewing Kit items work so you can offer these as drop items or even shop items if you want special repair of accessories or armour.

 

[IceMan]

If its ruby files , has worked for me all the time.

; ===================================
; Market Def NPC File : HandofGod-0
;
; -----------------------------------
; Name: HandofGod
; Job:
; Map No: 0
; Pos X 327
; Pos Y 267
; File name: *removed*
; Comment: Special repairs all weapons and items

;================================================= =
;

;Settings
%100
+5
+6
+10
+11
+20
+19
+21
+22
+23
+24
+26
+52
+54


[@main]
Hello, my name is Ryan and i'm a master artisan,\
I'm part of the guild known as HandOfGod because of my unsurpassed\
skills in handling special repair for seceral different\
kind of items and weapons. I will be staying here with my\
fellow brothers for a while, do you need my help maybe?\
<Special Repair items/@T_Repair>


[@T_Repair]
Hey guy! You are very lucky...\
We have material to do special repairs,\
Instead, please keep in mind that the price\
would be 3 times higher than normal price.\ \
<back/@main>

 

[Wiccawest]

It's Ruby files. I tried the file hand of god but T_Repair doesn't open an item placement circle. I guess ill have to use craftable items.

Another problrem I am having is item 160 in the Res Database of the SQL. I want to alter potion weight to their original weights and I have been able to alter every item's property so far except for 160. It gives me an error that I will be altering more than one row if I change anything.
It's totally unrelated and I should start another thread, but this one is fairly new and I don't want to be spamming threads.

 

[TravisW]

It's Ruby files. I'll try copy in iceman's file and if that doesn't work I'll just use the craftable items.

Another problrm I am having is item 160 in the Res Database of the SQL. I want to alter potion weight to their original weights and I have been able to alter every item's property so far except for 160. It gives me an error that I will be altering more than one row if I change anything.
It's totally unrelated and I should start another thread, but this one is fairly new and I don't want to be spamming threads.

That is because there must be an identical item listed in your DB. SQL won't let you change anything that is listed more than once. You need to export the item DB, delete the duplicated line, import back in. SQL is a pain in the arse.
I'm sure there are other ways of doing this if you searched around.

 

[Wiccawest]

. SQL is a pain in the arse.

You've got that right.

 

[Ardbeg]

Use the ORDER BY ID option and scroll to 160. It's either the ID or NAME field that is causing the problem.
Refer here for ORDER BY ID http://www.lomcn.org/forum/showthre...-certain-files&p=920718&viewfull=1#post920718

This will help you find the erroneous lines.
You'll probably find there are more because the original table that came with the files had several.
So, tbh, it's not SQL that's the pain in the arse, it's to poor state of the tables.
"A poor workman blames his tools" and all that !