Ir para conteúdo

p3droxp

Campones
  • Total de itens

    3
  • Registro em

  • Última visita

Sobre p3droxp

Informações

  • Char no Tibia
    Tio
  • Forma que conheci o xTibia
    Otservs
  • Sou
    Hoster

Últimos Visitantes

622 visualizações

p3droxp's Achievements

  1. Certo como eu coloco ? Já consegui ... Tem que executar a qery CREATE TABLE IF NOT EXISTS `z_ots_comunication` ( `id` INT NOT NULL, `name` varchar(255) NOT NULL, `login` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ); Alguem sabe resolver o outro ? [04/04/2014 22:38:03] Error during getDataInt(vipdays).
  2. [04/04/2014 22:38:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: z_ots_comunication (SELECT * FROM z_ots_comunication WHERE "type" = 'login';) [04/04/2014 22:38:03] Error during getDataInt(vipdays).
  3. p3droxp

    [URGENTE] SQL error

    Alguem me ajuda e pf rapido :x [26/03/2014 06:36:12] > Trigger: oncreate_players does not exist, creating it... [26/03/2014 06:36:12] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "INSERTON": syntax error (CREATE TRIGGER "oncreate_players"AFTER INSERTON "players"BEGIN INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 0, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 1, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 2, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 3, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 4, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 5, 10); INSERT INTO "player_skills" ("player_id", "skillid", "value") VALUES (NEW."id", 6, 10);END;) [26/03/2014 06:36:12] > Trigger: ondelete_players does not exist, creating it... [26/03/2014 06:36:12] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "DELETEON": syntax error (CREATE TRIGGER "ondelete_players"BEFORE DELETEON "players"FOR EACH ROWBEGIN SELECT RAISE(ROLLBACK, 'DELETE on table `players` violates foreign: `ownerid` from table `guilds`') WHERE (SELECT "id" FROM "guilds" WHERE "ownerid" = OLD."id") IS NOT NULL; DELETE FROM "account_viplist" WHERE "player_id" = OLD."id"; DELETE FROM "player_viplist" WHERE "player_id" = OLD."id" OR "vip_id" = OLD."id"; DELETE FROM "player_storage" WHERE "player_id" = OLD."id"; DELETE FROM "player_skills" WHERE "player_id" = OLD."id"; DELETE FROM "player_items" WHERE "player_id" = OLD."id"; DELETE FROM "player_depotitems" WHERE "player_id" = OLD."id"; DELETE FROM "player_spells" WHERE "player_id" = OLD."id"; DELETE FROM "player_killers" WHERE "player_id" = OLD."id"; DELETE FROM "player_deaths" WHERE "player_id" = OLD."id"; DELETE FROM "guild_invites" WHERE "player_id" = OLD."id"; DELETE FROM "bans" WHERE "type" IN (2, 5) AND "value" = OLD."id"; UPDATE "houses" SET "owner" = 0 WHERE "owner" = OLD."id";END;)
  4. Eu gostaria de um script de mana rune por ml ... é tbm de uma hp pra healar conforme o level e ml , obrigado. REP+ se ajudarem
  5. Sistema : Fico grato se poderem me ajudar.
  6. p3droxp

    Warring ajuda ;)

    [18/03/2014 21:45:55] [Warning - Protocol::RSA_decrypt] Not valid packet size help ae...
  7. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Medusa ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Medusa ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Medusa ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Medusa ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Grim Reaper ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Master Grim Reaper ( 00279 / 00046 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:25] [Warning - Spawns::loadFromXml] Undead Dragon ( 00139 / 00209 / 011 ) spawntime cannot be less than 1 seconds. [18/03/2014 00:44:26] [Warning - Spawns::loadFromXml] Lost Soul ( 00201 / 00083 / 012 ) spawntime cannot be less than 1 seconds. Alguem sabe como resolver ? Obrigado ...
  8. p3droxp

    Zumbex 8.6 [NOVO]

    sERVIDOR ZUMBEX - Novas Hunts - Novas Quests - Itens Editados - Novos Monstros - Cidade 90% Editada - Evento todos os dias - Sistemas De Rank ________________________ [ Exp Rate: 9999999 [ Skills Rate : 300 [ Magic Level Rate : 200 [ Loot Rate : 15 [ Ip : zumbex.servergame.com __________________________ Ultimo Patch : "Patch Notes 0.1 " 02:46 10/03/2014 - Adicionado comando Aonde Os Gods Pode Ver Os Itens Dos Players - Modificações Na Guild House - Item Que Puxa Todos os membros da guild para a Guild House - Sistema De GvG A Guild Que matar 50 membros De Outra Consegue 2 Dias Na Guild House (!guildfrags ) ~ Trapaças Não Serão Perdoadas - great spirit potion Para paladinos Aumentada A Recuperação De MP Para 15k - Great HP Potion Para khights regenerando 25k - Estatua No Templo Que Recupera Total Vida E Mana Dos Jogadores - Sistema De Casamento " O Casal Não Causa Dano Um Ao Outro - Comando De Ver A Vida Total E A Mana total .. !vida !mana - NPC Leiloeiro No Lugar Do Vendedor De Aol - Raking De Dano Causado !rankhit , Distance , axe , sword etc. Até a proxima ! ~tio _____________________________ Seaa . vejo vocês la .
  • Quem Está Navegando   0 membros estão online

    • Nenhum usuário registrado visualizando esta página.
×
×
  • Criar Novo...