PsyMcKenzie

Agora deu isso: STEP 4 Add samples to DB: Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 499

Gostei cara, layout ta muito foda!

Agora deu isso: STEP 4 Add samples to DB: News ticker sample is already in database. New sample is not needed. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'skulltime' in 'field list'' in C:\xampp\htdocs\install.php:509 Stack trace: #0 C:\xampp\htdocs\install.php(509): PDO->query('INSERT INTO `pl...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 509

Vou baixar e testar novamente, se der certo edito aqui.

TFS 0.3.4 e o Gesior é 0.1.3.

Qual a versão do seu server?

Como eu descubro isso? '-'

Apareceu isso agora: STEP 4Add samples to DB: Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 386

É só adicionar isso na db?

Como arrumo isso? STEP 4 Add samples to DB: News ticker sample is already in database. New sample is not needed. Added first news. Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'skull' in 'field list'' in C:\xampp\htdocs\install.php:412 Stack trace: #0 C:\xampp\htdocs\install.php(412): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 412

Era o Skype kkk Obrigado pela ajuda galera.

Exemplo: <?xml version="1.0" encoding="UTF-8"?> <npc name="Eryn" nameDescription="Eryn, the rune vendor" script="runes.lua" walkinterval="2000" floorchange="0" skull="green"> <health now="100" max="100"/> <look type="130" head="39" body="122" legs="125" feet="57" addons="0"/> <parameters> <parameter key="message_greet" value="Hello |PLAYERNAME|. I sell runes, potions, wands and rods."/> <parameter key="message_decline" value="Is |TOTALCOST| gold coins too much for you? Get out of here!"/> </parameters> </npc> Adicione isso no seu npc: skull="green"

Alguém sabe me dizer como arrumo isso? Apache não quer ligar, já tentei reinstalar e nada.

Obrigado cara, to terminando a loja de ferragens.

Ah, obrigado mesmo assim cara, valew mesmo em! Agora só falta isso: OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist1 (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;) sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique Error during getDataInt(auction_balance).

Aee, ta diminuindo kkk Só ta dando isso agora: OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist1 (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;) sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique ~~GOD Dii~~ has logged in. Error during getDataInt(auction_balance).

Ainda ta dando esse erro: OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (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;) OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (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;) OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique ~~GOD Dii~~ has logged in. Error during getDataInt(auction_balance). OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;)

Gostei cara, parabéns! Só aumente a montanha debaixo, senao ficará sem sentido esse rio em cima.

Testa ai: local sentar = {health = 5, mana = 5} local storage = 12345 function onSay(cid, words) if getTilePzInfo(getPlayerPosition(cid)) then if getPlayerStorageValue(cid, 12345) == -1 then doCreatureSay(cid, "Ahh, vou descansar...", TALKTYPE_MONSTER) doSendMagicEffect(getCreaturePosition(cid), 1) doPlayerAddHpManaSentar(cid, sentar) doCreatureSetNoMove(cid, true) setPlayerStorageValue(cid, 12345, 1) else setPlayerStorageValue(cid, 12345, -1) doCreatureSetNoMove(cid, false) doCreatureSay(cid, "Já descansei.", TALKTYPE_MONSTER) stopEvent(hpmana) end end return true end local FRASES = {"Off-Line!", "Ja Venho!", "Afk!", "Sai!", "Ja Volto!"} -- Auto-Mensagens. local TEMPO = 1 -- Intervalo de Tempo em segundos. local function doSendAutoMessage(cid, pos) if (isCreature(cid) == TRUE) then npos = getThingPos(cid) if (pos.x == npos.x) and (pos.y == npos.y) and (pos.z == npos.z) then doSendAnimatedText(pos, FRASES[math.random(#FRASES)], math.random(255)) doSendMagicEffect(getThingPos(cid), CONST_ME_MAGIC_BLUE) addEvent(doSendAutoMessage, TEMPO*1000, cid, npos) end end end function doPlayerAddHpManaSentar(cid, formula) if not isCreature(cid) then return true end doCreatureAddHealth(cid, formula.health) doCreatureAddMana(cid, formula.mana) hpmana = addEvent(doPlayerAddHpManaSentar, 5000, cid, formula) end

O primeiro deu esse erro quando apertei F9: Error while executing query: near "auto_increment": syntax error <simple query executor> E o segundo esse: Error while executing query: near ",": syntax error <simple query executor>

Bom galera, baixei um servidor e quando fui abrir, me deparei com isso: 1º: [02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetime6 (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;) [02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.exphist6 (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;) [02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:08:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:08:51] sqlite3_step(): SQLITE ERROR: columns id, world_id are not unique 2º [02/07/2014 20:09:25] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:09:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:09:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:10:26] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:10:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:10:59] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:11:27] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:11:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:12:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:12:28] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:12:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:13:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:13:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:13:34] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:14:05] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:14:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:14:36] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:15:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:15:31] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:15:38] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:16:09] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [02/07/2014 20:16:32] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimeall (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1;) [02/07/2014 20:16:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) Alguém tem ideia de como faço para arrumar?

Cara, aquilo são só comentários do script, não fazer diferença.

Já tentei isso e a mensagem que eu coloco, o servidor não aceita. :c

Obrigado @AlekysRocha. Ah, to deixando os detalhes por ultimo kkk

Como faço para um NPC seguir um rota definida por mim? Tentei desta forma como LuckOake disse, mas não funciona e também não da erro. local route = {1, 1, 1, 1, 1, 2, 2, 2} -- 0 = Norte, 1 = Leste, 2 = Sul, 3 = Oeste local delay = 1000 -- Delay no walk do NPC function startMoving(cid) for i = 1, #route do addEvent(doMoveCreature, i*delay, getNpcCid(), route[i]) end return addEvent(startMoving, delay*(#route+1), cid) end startMoving(getNpcCid()) E mais uma coisa, gostaria de saber como faço para ele mandar mais de uma mensagem aleatoriamente, de 5 em 5 segundos. function thinkCallback(cid) if math.random(300) == 1 then selfSay('Posso ajudar?') end return true end Tentei fazer uma tabela, mas não deu certo. @UP