(Resolvido)ERROR Console!

[alexalex 2]

meu tfs tira o error sqlite error! 

 

eu acho k e o database.s3db

 

outro error: sempre quando eu entro no meu ot, (jogo, consigo itens e exp) e deslogo volta tudo (volta o lvl, os itens iniciais, os skills e etc) como se não tivesse salvado.. 

os erros são esse 

por favor ajuda ai, obrigado

Hidden Content

Give reaction to this post to see the hidden content.

[.HuRRiKaNe 828]

Abre o sqlite editor e faça como na imagem, coloque os códigos e aperte F9 pra executar na sua database:

 

Códigos:

DROP TABLE IF EXISTS players;
CREATE TABLE players (
    id                    INTEGER           PRIMARY KEY
                                            NOT NULL,
    name                  VARCHAR( 255 )    NOT NULL,
    world_id              INTEGER           NOT NULL
                                            DEFAULT '0',
    group_id              INTEGER           NOT NULL
                                            DEFAULT '1',
    account_id            INTEGER           NOT NULL,
    level                 INTEGER           NOT NULL
                                            DEFAULT '1',
    vocation              INTEGER           NOT NULL
                                            DEFAULT '0',
    health                INTEGER           NOT NULL
                                            DEFAULT '100',
    healthmax             INTEGER           NOT NULL
                                            DEFAULT '100',
    experience            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookbody              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookfeet              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookhead              INTEGER           NOT NULL
                                            DEFAULT '10',
    looklegs              INTEGER           NOT NULL
                                            DEFAULT '10',
    looktype              INTEGER           NOT NULL
                                            DEFAULT '136',
    lookaddons            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookmount             INTEGER           NOT NULL
                                            DEFAULT '0',
    maglevel              INTEGER           NOT NULL
                                            DEFAULT '0',
    mana                  INTEGER           NOT NULL
                                            DEFAULT '100',
    manamax               INTEGER           NOT NULL
                                            DEFAULT '100',
    manaspent             INTEGER           NOT NULL
                                            DEFAULT '0',
    soul                  INTEGER           NOT NULL
                                            DEFAULT '0',
    town_id               INTEGER           NOT NULL,
    posx                  INTEGER           NOT NULL
                                            DEFAULT '32369',
    posy                  INTEGER           NOT NULL
                                            DEFAULT '32241',
    posz                  INTEGER           NOT NULL
                                            DEFAULT '7',
    conditions            BLOB              NOT NULL,
    cap                   INTEGER           NOT NULL
                                            DEFAULT '0',
    sex                   INTEGER           NOT NULL
                                            DEFAULT '0',
    lastlogin             INTEGER           NOT NULL
                                            DEFAULT '0',
    lastip                INTEGER           NOT NULL
                                            DEFAULT '0',
    save                  BOOLEAN           NOT NULL
                                            DEFAULT 'TRUE',
    skull                 INTEGER           NOT NULL
                                            DEFAULT '0',
    skulltime             INTEGER           NOT NULL
                                            DEFAULT '0',
    rank_id               INTEGER           NOT NULL,
    guildnick             VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    lastlogout            INTEGER           NOT NULL
                                            DEFAULT '0',
    blessings             INTEGER           NOT NULL
                                            DEFAULT '0',
    pvp_blessing          BOOLEAN           NOT NULL
                                            DEFAULT 'FALSE',
    balance               INTEGER           NOT NULL
                                            DEFAULT '0',
    stamina               INTEGER           NOT NULL
                                            DEFAULT '151200000',
    direction             INTEGER           NOT NULL
                                            DEFAULT '2',
    loss_experience       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_mana             INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_skills           INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_containers       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_items            INTEGER           NOT NULL
                                            DEFAULT '100',
    premend               INTEGER           NOT NULL
                                            DEFAULT '0',
    online                INTEGER           NOT NULL
                                            DEFAULT '0',
    marriage              INTEGER           NOT NULL
                                            DEFAULT '0',
    promotion             INTEGER           NOT NULL
                                            DEFAULT '0',
    deleted               INTEGER           NOT NULL
                                            DEFAULT '0',
    description           VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    comment               TEXT            NOT NULL,
    create_ip             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    create_date           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    hide_char             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    signature             TEXT            NOT NULL,
    offlinetraining_time  SMALLINT UNSIGNED NOT NULL
                                            DEFAULT '43200',
    offlinetraining_skill INT               NOT NULL
                                            DEFAULT '-1',
    cast                  TINYINT( 4 )    NOT NULL
                                          DEFAULT '0',
    castViewers           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    castDescription       VARCHAR( 255 )  NOT NULL,
    created               INT( 11 )       NOT NULL
                                          DEFAULT '0',
    nick_verify           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    old_name              VARCHAR( 255 )  NOT NULL
                                          DEFAULT '',
    worldtransfer         INT( 11 )       NOT NULL
                                          DEFAULT '0',
    show_outfit           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_eq               TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_bars             TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_skills           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_quests           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    stars                 INT( 10 )       NOT NULL
                                          DEFAULT '0',
    ip                    VARCHAR( 17 )     NOT NULL
                                            DEFAULT '0',
    UNIQUE ( name, deleted ),
    FOREIGN KEY ( account_id ) REFERENCES accounts ( id )
);
INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0);

DROP TABLE IF EXISTS z_ots_comunication;
CREATE TABLE z_ots_comunication ( 
    id        INT( 11 )       NOT NULL,
    name      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 ) 
);

Editado Agosto 4, 2015 por Animal Pak (veja o histórico de edições)

[Sekk 396]

  Mostrar conteúdo oculto

  Em 04/08/2015 em 20:49, Animal Pak disse:

 

Abre o sqlite editor e faça como na imagem, coloque os códigos e aperte F9 pra executar na sua database:

 

Códigos:

DROP TABLE IF EXISTS players;
CREATE TABLE players (
    id                    INTEGER           PRIMARY KEY
                                            NOT NULL,
    name                  VARCHAR( 255 )    NOT NULL,
    world_id              INTEGER           NOT NULL
                                            DEFAULT '0',
    group_id              INTEGER           NOT NULL
                                            DEFAULT '1',
    account_id            INTEGER           NOT NULL,
    level                 INTEGER           NOT NULL
                                            DEFAULT '1',
    vocation              INTEGER           NOT NULL
                                            DEFAULT '0',
    health                INTEGER           NOT NULL
                                            DEFAULT '100',
    healthmax             INTEGER           NOT NULL
                                            DEFAULT '100',
    experience            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookbody              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookfeet              INTEGER           NOT NULL
                                            DEFAULT '10',
    lookhead              INTEGER           NOT NULL
                                            DEFAULT '10',
    looklegs              INTEGER           NOT NULL
                                            DEFAULT '10',
    looktype              INTEGER           NOT NULL
                                            DEFAULT '136',
    lookaddons            INTEGER           NOT NULL
                                            DEFAULT '0',
    lookmount             INTEGER           NOT NULL
                                            DEFAULT '0',
    maglevel              INTEGER           NOT NULL
                                            DEFAULT '0',
    mana                  INTEGER           NOT NULL
                                            DEFAULT '100',
    manamax               INTEGER           NOT NULL
                                            DEFAULT '100',
    manaspent             INTEGER           NOT NULL
                                            DEFAULT '0',
    soul                  INTEGER           NOT NULL
                                            DEFAULT '0',
    town_id               INTEGER           NOT NULL,
    posx                  INTEGER           NOT NULL
                                            DEFAULT '32369',
    posy                  INTEGER           NOT NULL
                                            DEFAULT '32241',
    posz                  INTEGER           NOT NULL
                                            DEFAULT '7',
    conditions            BLOB              NOT NULL,
    cap                   INTEGER           NOT NULL
                                            DEFAULT '0',
    sex                   INTEGER           NOT NULL
                                            DEFAULT '0',
    lastlogin             INTEGER           NOT NULL
                                            DEFAULT '0',
    lastip                INTEGER           NOT NULL
                                            DEFAULT '0',
    save                  BOOLEAN           NOT NULL
                                            DEFAULT 'TRUE',
    skull                 INTEGER           NOT NULL
                                            DEFAULT '0',
    skulltime             INTEGER           NOT NULL
                                            DEFAULT '0',
    rank_id               INTEGER           NOT NULL,
    guildnick             VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    lastlogout            INTEGER           NOT NULL
                                            DEFAULT '0',
    blessings             INTEGER           NOT NULL
                                            DEFAULT '0',
    pvp_blessing          BOOLEAN           NOT NULL
                                            DEFAULT 'FALSE',
    balance               INTEGER           NOT NULL
                                            DEFAULT '0',
    stamina               INTEGER           NOT NULL
                                            DEFAULT '151200000',
    direction             INTEGER           NOT NULL
                                            DEFAULT '2',
    loss_experience       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_mana             INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_skills           INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_containers       INTEGER           NOT NULL
                                            DEFAULT '100',
    loss_items            INTEGER           NOT NULL
                                            DEFAULT '100',
    premend               INTEGER           NOT NULL
                                            DEFAULT '0',
    online                INTEGER           NOT NULL
                                            DEFAULT '0',
    marriage              INTEGER           NOT NULL
                                            DEFAULT '0',
    promotion             INTEGER           NOT NULL
                                            DEFAULT '0',
    deleted               INTEGER           NOT NULL
                                            DEFAULT '0',
    description           VARCHAR( 255 )    NOT NULL
                                            DEFAULT '''',
    comment               TEXT            NOT NULL,
    create_ip             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    create_date           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    hide_char             INT( 11 )       NOT NULL
                                          DEFAULT '0',
    signature             TEXT            NOT NULL,
    offlinetraining_time  SMALLINT UNSIGNED NOT NULL
                                            DEFAULT '43200',
    offlinetraining_skill INT               NOT NULL
                                            DEFAULT '-1',
    cast                  TINYINT( 4 )    NOT NULL
                                          DEFAULT '0',
    castViewers           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    castDescription       VARCHAR( 255 )  NOT NULL,
    created               INT( 11 )       NOT NULL
                                          DEFAULT '0',
    nick_verify           INT( 11 )       NOT NULL
                                          DEFAULT '0',
    old_name              VARCHAR( 255 )  NOT NULL
                                          DEFAULT '',
    worldtransfer         INT( 11 )       NOT NULL
                                          DEFAULT '0',
    show_outfit           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_eq               TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_bars             TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_skills           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    show_quests           TINYINT( 4 )    NOT NULL
                                          DEFAULT '1',
    stars                 INT( 10 )       NOT NULL
                                          DEFAULT '0',
    ip                    VARCHAR( 17 )     NOT NULL
                                            DEFAULT '0',
    UNIQUE ( name, deleted ),
    FOREIGN KEY ( account_id ) REFERENCES accounts ( id )
);
INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 0, 0, 0, 0, 110, 0, 0, 0, 35, 35, 0, 0, 2, 32369, 32241, 7, '', 400, 0, 1400804121, 202641162, 0, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', '', 0, 0, 0, '', 43200, -1, 0, 0, '', 0, 0, '', 0, 1, 1, 1, 1, 1, 0, 0);

DROP TABLE IF EXISTS z_ots_comunication;
CREATE TABLE z_ots_comunication ( 
    id        INT( 11 )       NOT NULL,
    name      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 ) 
);

Mostrar mais  

 

Cara, tentei mandar pm pra vc, mas vc nn pode mais receber... preciso de ajuda..

 

http://www.tibiaking.com/forum/topic/61107-pedido-tfs-04-sem-salt/

 

POR FAVOR ME AJUDAAA

[.HuRRiKaNe 828]

  Em 04/08/2015 em 20:57, jvcasarin disse:

  Mostrar conteúdo oculto

 

Cara, tentei mandar pm pra vc, mas vc nn pode mais receber... preciso de ajuda..

 

http://www.tibiaking.com/forum/topic/61107-pedido-tfs-04-sem-salt/

 

POR FAVOR ME AJUDAAA

Mostrar mais  

 

Cara se ninguém compilar pra você até hora que eu chegar em casa eu compilo sem salt.

[Sekk 396]

  Em 04/08/2015 em 21:13, Animal Pak disse:

Cara se ninguém compilar pra você até hora que eu chegar em casa eu compilo sem salt.

Expand   Mostrar mais  

 

Amo pessoas assim <3 hueueh vlw msm!

 

Obs.: código de checar se eh sha1 foi retirado, e no config.lua ta "plain"