• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Search results for query: CREATE TABLE z_ots_comunication

  1. K

    Windows Brunowots realmap - Tibia 8.0 TFS 1.2

    I'm completely new to the world of Open Tibia and i can't get this project to work. The database and server itself appear to be working correctly, but any attempt to connect to the server results in "Invalid Account Number". --- What I've used: Windows 10 x64 Uniform Server Zero v.13_3_2...
  2. Cygan123

    Problem with the delivery of items from ITEM SHOP! Tfs 1.1

    Hello, after buying items from the Item Shop, it does not appear in the game, I get the following error in the game window: The console shows: On the page in Transactions History: In Folder : /home/ots /data/globalevents/scripts - I added shop.lua but it's probably bad, I've tried with...
  3. Cygan123

    Problem z dostawą itemów z ITEM SHOP! Tfs 1.1

    Witam po zakupieniu rzeczy z Item Shop nie dochodzi mi ona do gry, pojawia się taki błąd w oknie gry : W konsoli pojawia się : Na stronie w Transactions History W Folderze /home/ots/data/globalevents/scripts dodałem plik shop.lua tylko pewnie jest zły, próbowałem juz z różnymi .... : Do...
  4. Kownikuzyt

    Cast Open (experience)

    @APTGET There are no spectators columns in the 'players' tab. Adding a column: ALTER TABLE players ADD COLUMN` spectators` x x x x 'x'; x - values of the 'spectators' column. There are no spectators columns in the 'players' tab. Adding a column: ALTER TABLE player_containers ADD COLUMN...
  5. S

    Problem setting up AAC step 3&4

    ...to table players. Already exist? Could not add column hide_char to table players. Already exist? Could not create table z_ots_comunication. Already exist? Could not create table z_shop_offer. Already exist? Could not create table z_shop_history_item. Already exist? Could not create table...
  6. Daemonium

    Problem installing gesior 1.0 3

    USING: Gesior: Version 1.0.3 for TFS 0.3.6 and TFS 0.4 up to revision 3702 PHP: 7.4.8 PROBLEM: Many tables do not create in mysql when using the install.php. STEP 3 Add tables and columns to DB Installer try to add new tables and columns to database. Could not add column key to table...
  7. Addams

    Console

    Try pasting this query into your database. CREATE TABLE IF NOT EXISTS `z_ots_comunication` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT...
  8. R

    [GESIOR2012] Items Shop Installation/Administration

    Zrobiłem jak należy, mam tfsa 1.2 powinno działać skoro mam acc maker 2012? mam rozumiec że potem wchodze na goda i wpisuje /addshop 50 < i to znaczy że dodaje itema którego mam w prawej ręce do shopa za 50 ptk?
  9. C

    [GESIOR2012] Items Shop Installation/Administration

    The link's (paste.ot..) to talkaction don't work, i need for finish my project... :( Help me
  10. K

    Console

    how can i create these 2 on my sql?? [21/7/2020 13:20:11] mysql_real_query(): SELECT * FROM z_ots_guildcomunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'baiakalfa.z_ots_guildcomunication' doesn't exist (1146) [21/7/2020 13:20:11] mysql_real_query(): SELECT * FROM z_ots_comunication...
  11. L

    Zombie Event giving error when logging

    I installed this zombie event on my server https://otland.net/threads/new-zombie-event-tfs-1-x.239287/ Mas ao tentar logar no servidor aparece esse erro My global.lua dofile('data/lib/libs.lua') dofile('data/zombieEvent.lua') NOT_MOVEABLE_ACTION = 8000 PARTY_PROTECTION = 1 -- Set to 0 to...
  12. M

    Solved SQL Lite Error

    otsys_sqlite3_prepare sqllite error select from z_ots_comunication where type login what i do bro?
  13. Addams

    Solved SQL Lite Error

    Insert this to your database CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY 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"...
  14. Noobrzor

    [8.6] Tibia Global Full incl/TFS+sources

    Howdy. Freshly downloaded, changed "mysql" to "sqlite" in config.lua That required to use sqlite_studio to execute the following SQL query: CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "type" VARCHAR(255) NOT NULL, "action"...
  15. Z

    GlobalEvent Shop system problem

    Read you error msg: Table 'z_ots_comunication' doesn't exist You trying to access a table that don't exist. Run this SQL command to create the table that was missing: CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "type"...
  16. S

    I need help with DOTA event!

    here is how to share a code you will find this sign </> click on it and paste next time. function onTime() broadcastMessage("[DotA] Event opens and starts in 5 minutes, teleport opens in center, minimum 4 players for event to start.") gatepos = {x=1789, y=1704, z=7, stackpos=1} -- Posiçمo da...
    • Shadow_
    • Post #2
    • Forum: Requests
  17. irishman

    TFS 0.X [CREATURESCRIPT INTERFACE]

    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...
  18. Apollos

    How i remove this problem

    Run a new query in your phpmyadmin or equivalent. CREATE TABLE `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `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...
  19. Saint Spear

    When i join my own ot it crashes (8.60)

  20. Senzation96

    When i join my own ot it crashes (8.60)

    CREATE TABLE "z_ots_comunication" ( "id" INTEGER PRIMARY KEY 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"...
Back
Top