Skocz do zawartości

  • 👋 Witaj na MPCForum!

    Przeglądasz forum jako gość, co oznacza, że wiele świetnych funkcji jest jeszcze przed Tobą! 😎

    • ✅ Pełny dostęp do działów i ukrytych treści
    • ✅ Możliwość pisania i odpowiadania w tematach
    • ✅ System prywatnych wiadomości
    • ✅ Zbieranie reputacji i rozwijanie swojego profilu
    • ✅ Członkostwo w jednej z największych społeczności graczy

    👉 Dołączenie zajmie Ci mniej niż minutę – a zyskasz znacznie więcej!

    Zarejestruj się teraz

Zalogować się mogłem a po małej edycji już nie :X

CarnageBoSS

Rekomendowane odpowiedzi

CarnageBoSS Rekrut

CarnageBoSS

Opublikowano
Rekrut

CarnageBoSS

Opublikowano

Witam.

PRACUJĘ NA PLIKACH TERENZO

Na początek opiszę co wprowadziłem na swój serwer:

Moje bronie na 30 lvl itd. nie miały śr i um, więc wykonałem zapytanie do bazy 'player': 

 

 

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;

Po tym zapytaniu przekonwertowałem item_proto do pliku txt i zastąpiłem stare w usr/home/mt2/db

 

Po czym w konsoli serwerowej wpisałem /etc/rc.d/netif restart a następnie /start, uruchomiłem 4 channele.

 

 

 

Teraz w czym problem?

A no taki problem, że przed tymi działaniami mogłem się zalogować, brat też, a teraz żaden z nas nie może -.-

 

 

 

W czym problem? JA NIE WIEM!

CarnageBoSS Rekrut

CarnageBoSS

Opublikowano
Rekrut

CarnageBoSS

  • Autor
Opublikowano

Sysser dam za chwilę...

 

Edit2: O ten Syserr chodziło?

 

SYSERR: Jun 24 19:36:20 :: pid_init: 

Start of pid: 1688
 
SYSERR: Jun 24 19:36:20 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jun 24 19:36:21 :: Set_Proto_Item_Table: ItemProto Reading Failed : Invalid value.

 

 

Edit:  Czy ten (choć wątpię :P)

 

 

 

SYSERR: Jun 24 17:13:59 :: pid_init: 

Start of pid: 4835
 
SYSERR: Jun 24 17:13:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:13:59 :: ChildLoop: AsyncSQL: query failed: Table 'account.string' doesn't exist (query: SELECT name, text FROM string errno: 1146)
SYSERR: Jun 24 17:14:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:14:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:15:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:16:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:17:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:18:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:02 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:05 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:08 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:11 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:14 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:17 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:20 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:23 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:26 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:29 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:32 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:35 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:38 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:41 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:44 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:47 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:50 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:53 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:56 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:58 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
SYSERR: Jun 24 17:19:59 :: socket_connect: HOST localhost:15000, could not connect.
SYSERR: Jun 24 17:19:59 :: pid_deinit: 
End of pid

 

 

 

Konwertowałem za pomocą NaviCat.

CarnageBoSS Rekrut

CarnageBoSS

Opublikowano
Rekrut

CarnageBoSS

  • Autor
Opublikowano

Nie mogę wgrywać starych, gdyż chcę naprawić bronie, które nie mają śr i um a powinny :)

Szukam innego rozwiązania.

 

Spróbuję jedynie zrobić od nowa to zapytanie, może za drugim razem się uda.

 

 

Edit:
Problem występuje dalej...

Tam gdzie występuje śr i um mam ustawione addon_type=-1 a reszta addon_type=0 więc nie widzę tu żadnych problemów.

Konwertuję wszystkie rekordy z item_proto do pliku item_proto.txt i podmieniam plik w usr/home/mt2/db/ i powinno wszystko być ok a zalogować się dalej nie mogę.

Zarchiwizowany

Ten temat przebywa obecnie w archiwum. Dodawanie nowych odpowiedzi zostało zablokowane.

Tematy
×
×
  • Dodaj nową pozycję...