B?ad w konsoli

[damianslu]

Mianowicie gdy mam uruchomiony server wyskakuje mi co jakis czas w k?soli taki b??d:
[24/03/2010 12:28:39] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
Serwer TFS wersja 0.3.6 pod 8.54 SQL
Prosz? o pomoc je?li kto? wie o co chodzi.

 

[Xayan]

Odp: B?ad w konsoli

Nie masz kolumny onlinetimetoday w tabeli players. Jebnij to zapytanie:

ALTER TABLE `players` ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL

 

[damianslu]

Odp: B?ad w konsoli

Dzieki pomog?o lecz jeszcze 2 b??dy wyskakuj? ;/ a mianowicie
1 b??d:
[25/03/2010 11:29:13] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERROR: Unknown column 'exphist6' in 'field list' (1054)

2 b??d:
[25/03/2010 11:29:13] mysql_real_query(): UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0; - MYSQL ERROR: Unknown column 'onlinetime6' in 'field list' (1054)

Pomo?esz

 

[S3baso]

Odp: B?ad w konsoli

Pewnie maniucza..

W creaturescrpits badz globalevents

znajdz plik history.lua i wklej tutaj jego zawartosc.

 

[damianslu]

Odp: B?ad w konsoli

Oto zawarto?? pliku:

function onThink(interval, lastExecution)
if (tonumber(os.date("%d")) ~= getGlobalStorageValue(23456)) then
setGlobalStorageValue(23456, (tonumber(os.date("%d"))))
db.executeQuery("UPDATE `players` SET `onlinetime7`=players.onlinetime6, `onlinetime6`=players.onlinetime5, `onlinetime5`=players.onlinetime4, `onlinetime4`=players.onlinetime3, `onlinetime3`=players.onlinetime2, `onlinetime2`=players.onlinetime1, `onlinetime1`=players.onlinetimetoday, `onlinetimetoday`=0;")
db.executeQuery("UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience;")
end
db.executeQuery("UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1;")
return TRUE
end

 

[S3baso]

Odp: B?ad w konsoli

hmm gdzie to bylo niewiem ale to jest to

teraz creaturescripts.xml lub globalevents.xml (nniewiem skad wziales i dlatego dwa daje)

usun cala linie z tym skryptem tzn. tam gdzie masz history.lua


@down 2x
Troche sie znam wlasciwie to glownie acc makerami sie zajmuje ;PP

 

[damianslu]

dok?adnie to z globalevents zaraz sprawdz? czy pomog?o.
Dzi?ki S3baso wszystko ?adnie elegancko dzia?a.
Znasz si? chyba na acc tak?

Notka moderatorska:

Sklejam