database

  1. Znote

    [suggestion] Unique item reference database structure

    Check link for suggested schema changes: https://gist.github.com/Znote/2508c1d50fcca318f80b3ea4bc6f10a3 CREATE TABLE IF NOT EXISTS `items` ( `item_uid` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `itemtype` smallint(6) NOT NULL, `count` smallint(5) NOT NULL, `attributes` blob NOT NULL...
  2. M

    RL Map good base server?

    Can someone tell me where can i find a server base to make my rl based ot? Version 8.6 or more, would help if its the last version available I want to have real map on my ot if its possible... Thanks in advance
  3. kubqq

    Linux Problem with phpmyadmin in Ubuntu and import tfs database.

    Hello. From few days a tried to run my compiled tfs 0.4, complie was good, I did make a file forgottenserver etc. The first problem is connect to phpmyadmin, I have still this when I try to connect in browser: Not Found The requested URL /phpmyadmin was not found on this server. Apache/2.4.18...
  4. P

    Znote Online error players help me

    . Which server or site do you use as a base? ACC Znote What is the reason for this topic? Help Presiso, Players Online does not work It does not count how many players online has 0 shows no error in the list online scripts ja test several until another base date. I think we need to put...
  5. A

    TFS 0.4 Console bug

    I have host with Ubuntu 14.04. When I have consoles turned on and I turn on the server tfs, everything works well. When I turn off the console or the computer are getting errors im database. Change vocations and skills. What am I doing wrong? do I have to enter any commands in the Ubuntu console?
  6. A

    TFS 0.4 Bug database change vocations and give high skills.

    TFS 0.4 Bug database change vocations and give high skills. Server is then blocked and i can not log in. Only when I make a restart and change skills to old it works correctly for a few moments. I do not know what adds such high skills.. I use host with ubuntu 14.04 Can someone help me?
  7. dunnish

    Linux Znote Shop !shop problem

    hello! this script is working on windows. but when i move the db and the website only to ubuntu its dossnt work. -- Znote Shop v1.0 for Znote AAC on TFS 0.3.6+ Crying Damson. function onSay(cid, words, param) local storage = 54073 -- Make sure to select non-used storage. This is used to...
  8. K

    TFS 0.X mysql_real_query HELP

    Hello all When launching ots, I get such an error. I have already looked at the forum but found nothing mysql_real_query (): UPDATE `uptime` SET` time` = 0 - MYSQL ERROR: Table 'ots.uptime' does not exist (1146) mysql_real_query (): UPDATE `players` SET` train` = 0; - MYSQL ERROR: Unknown...
  9. V

    Invalid account name.

    8.54 0.3.6tfs First sorry for my english. Hi i have the problem becouse i can create account and character on the site if i try log in to the server i get the error "Invalid account name" only working password is 1/1 Zapodaj.Net - Darmowy hosting zdjęć i obrazków bez rejestracji! -...
  10. Togu

    TFS 1.X+ How to make changes in atk speed and database?

    This is my project: The Forgotten Tibia 1) How do I change attack speed permanently? I've seen in the sources that there is no lua function that changes the attack speed of a player, there is no "setAttackSpeed" function. How do I make that? What's the step by step? I know I could study and...
  11. H

    TFS 0.X Missing some line in DB. can someone recognise it?

    Hi guys, I just noticed an error on my console: mysql_store_result(): UPDATE `players` SET `online` = 0 WHERE `world_id` = 0; - MYSQL ERROR: (0) Anyone got any idea what should I do to remove this error? I believe it is a missing line in database, but I got no idea how to insert it. Thanks...
  12. S

    Windows {HELP} LOGIN SERVER

    I am having trouble getting into ot serv tfs 1.2 if someone can help me thanks!
  13. Z

    Lua STORAGE BUG

    Lately there are some strange results in my database, as well as the following represented below: Àé·� Could anyone tell me what this is about?
  14. Morpheo007

    Error on web

    i Have this error, do you kwon how to fix it? Error occured! Error ID: More info: CANNOT CONNECT TO DATABASE: SQLSTATE[HY000] [2002] No se puede establecer una conexion ya que el equipo de destino denego expresamente dicha conexion. File...
  15. suicunei

    Windows Gesior doesn't update MySQL

    Hey guys, this is one of my first threads, I'm brazillian and sorry for my bad english... Well, let's to the issue About 4 days ago, I just downloaded Gesior 2012 for TFS 0.4 + directly from the official repository of Gesior.pl in GitHub. The website seems like very nice, now I'm trying to edit...
  16. S

    Windows Setting up a TFS 1.2

    Hi everyone, im currently trying to figure out how to set up a blank (empty, no scripts etc) TFS for testing purposes. It's not a project, i just want to learn how to script and i thought that using a live ots with 5x5 area would be a good testing place. However, i cannot start up the exe file...
  17. Vinicius Alves

    Não cria accounts " Does not create accounts"

    Alguém Por Acaso Já Viu Esse Erro na vida? Gesior reconhece uma base de dados, POIS uma Lista de sempre atualiza topo servidor. Porem ELE NÃO consegue CRIAR conta NEM guilds, Não apresenta Nenhum Erro, APENAS fala Que foi CRIADO com Sucesso, mas NÃO cria uma Linha de Dados na base de dados, JA...
  18. BBlackfur

    Register and Login Error - Help!

    Hi, , my first time trying to create an OT I get this error when trying to register an account upon my website: string(159) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('innf', '3b87e3526ae6f347b7354fba4762e31084f7312b', '[email protected]', '1481341766')" (query -...
  19. whitevo

    Lua TFS 1.x how to save items to database with Lua

    I am creating completely new housing feature for my server and was not using any of the functions given by the source. I was thinking how should I save and load player houses with Lua. Got few ideas, but first wanted to try what does these "houseTiles" do (the ones what you can set in RME) And...
Top