[Pytanie]dotyczace rozwiazania problemu braku sr,um - pliki terenzo

[ShastaMan]

Niemam srednich i um w broniach 30 75 na plikach by terenzo.

 

 

Terenzo kazal mi :

 

wykonaj poniższe zapytania w bazie player, przekonwertuj item_proto do txt i wrzuć do db.

 

 

 

UPDATE item_proto SET addon_type=-1 WHERE vnum>=180 AND vnum<=189;

UPDATE item_proto SET addon_type=-1 WHERE vnum>=190 AND vnum<=199;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=290 AND vnum<=299;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=1130 AND vnum<=1139;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=1170 AND vnum<=1179;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=2150 AND vnum<=2159;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=2170 AND vnum<=2179;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=3160 AND vnum<=3169;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=3210 AND vnum<=3219;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=5110 AND vnum<=5119;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=5120 AND vnum<=5129;
UPDATE item_proto SET addon_type=-1 WHERE vnum>=7160 AND vnum<=7169;

UPDATE item_proto SET socket_pct=0;
UPDATE item_proto SET socket_pct=1 WHERE (type=1 or (type=2 and subtype=0)) and limittype0=1 and limitvalue0>= 0 and limitvalue0<= 24;
UPDATE item_proto SET socket_pct=2 WHERE (type=1 or (type=2 and subtype=0)) and limittype0=1 and limitvalue0>=25 and limitvalue0<= 44;
UPDATE item_proto SET socket_pct=3 WHERE (type=1 or (type=2 and subtype=0)) and limittype0=1 and limitvalue0>=45 and limitvalue0<=255;

 

 

 

O co chodzi z tym : przekonwertuj item_proto do txt i wrzuć do db.

 

Bo do konca nie rozumiem

 

 

Ale iten proto w cliencie ? czy w filezilli w bazie

 

 

Edit : Udalo mi sie zrobic.W tym co podales nie bylo mozliwosci konwersji z sql do txt.W programie M2ToolUP by terenzo byl Juz wszystko cacy dziala

 

 

 

 

DO ZAMKNIECIA

[Trikolos]

Chodzi o to: