questions

[Jarthal]

Witam jest ktoś w stanie podesłać mi wszystkie możliwe zapytania do bazy danych sql potrzebne do ots 8.6


Hello there is someone able to send me all possible sql database queries needed to ots 8.6


mysql_real_query(): UPDATE players SET lastlogin = 1549098107, lastip = 2298521792, level = 999, group_id = 6, health = 35, healthmax = 35, experience = 16517199400, lookbody = 44, lookfeet = 44, lookhead = 44, looklegs = 44, looktype = 302, lookaddons = 0, maglevel = 100, mana = 0, manamax = 0, manaspent = 0, soul = 0, town_id = 1, posx = 1002, posy = 997, posz = 7, cap = 470, sex = 0, balance = 0, stamina = 151200000, cast = 0, castViewers = 0, castDescription = '', skull = 0, skulltime = 0, promotion = 0, conditions = '', loss_experience = 50, loss_mana = 0, loss_skills = 0, loss_containers = 100, loss_items = 0, lastlogout = 1549098544, marriage = 0, guildnick = '', rank_id = 0, vocation = 4 WHERE id = 10 LIMIT 1; - MYSQL ERROR: Unknown column 'castViewers' in 'field list' (1054)


[10:8:53.471] [Error - GlobalEvent Interface]
[10:8:53.475] data/globalevents/scripts/heal.luanThink
[10:8:53.484] Description:
[10:8:53.485] data/globalevents/scripts/heal.lua:34: bad argument #1 to 'lower' (string expected, got boolean)
[10:8:53.496] stack traceback:
[10:8:53.506] [C]: in function 'lower'
[10:8:53.506] data/globalevents/scripts/heal.lua:34: in function <data/globalevents/scripts/heal.lua:24>
[10:8:53.520] [Error - GlobalEvents::think] Couldn't execute event: heal
[10:8:54.229] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:8:55.239] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:8:56.245] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:8:57.253] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:8:58.263] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:8:59.271] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:9:00.279] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)
[10:9:01.289] mysql_real_query(): SELECT COUNT(*) as c FROM events WHERE winner_name='Qinlenna' - MYSQL ERROR: Table 'raptor.events' doesn't exist (1146)


Takie rzeczy mi na razie silnik wywala może mi ktoś pomóc kiedyś miałem swój serwer to zrobiłem go na czysto z pomocą skryptera ale od 3 lat juz nie miałem serwera i zapomniałem wszystko