• 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!

If i delete account from Database i get php account error

Lopaskurwa

Well-Known Member
Joined
Oct 6, 2017
Messages
936
Solutions
2
Reaction score
57
Hi so i tried to clean my sql and delete all account from id but if i delete accounts and then try to create new accout i get this error
door.png

This is account.php
[C++] <?php /* +I.D.E ENGINE+ Controller of Account for Modern AAC - Powered by ID - Pastebin.com

Where is the problem?
 
Jesus christ it's like making new website from zero -_- i have no idea how should i run this website.

Well im not 100% on Znote, but with ex Gesior you just download the files to the www / htdocs directory and then enter 127.0.0.1/install.php and follow the guide.
 
Well im not 100% on Znote, but with ex Gesior you just download the files to the www / htdocs directory and then enter 127.0.0.1/install.php and follow the guide.
Hello WibbenZ,

both AAC's are pretty simple to setup, we have good tutorials and plenty of people using them to help such cases out, you know exactly what the challenge here is about...

Kindest Regards,
Okke
 
Well okay i'll try to run by that tutorial. This is what happen when you get simple problem and you need to remake everything :D i'll let you know did i make it.
 
Well okay i'll try to run by that tutorial. This is what happen when you get simple problem and you need to remake everything :D i'll let you know did i make it.

Lovely! Walking the past we suggested you to makes the support part a lot easier as users know how to fix most of the problems caused by using the known and supported systems. Thanks for the initiative and will to remake!

Kindest Regards,
OKke
 
Lovely! Walking the past we suggested you to makes the support part a lot easier as users know how to fix most of the problems caused by using the known and supported systems. Thanks for the initiative and will to remake!

Kindest Regards,
OKke
Anyway i'm confused already there is 3parts do i need to follow all of them? Because he said connect to the server what server lmfao. I dont get it, because all i need is only to set new website.
 
Watch the videos and see what you have to do or not, sometimes setting everything up from zero isn't a big deal if you removed all the accounts and so on, a new database is always a good thing when restarting
 
Watch the videos and see what you have to do or not, sometimes setting everything up from zero isn't a big deal if you removed all the accounts and so on, a new database is always a good thing when restarting
Well i checked his video and he learn how to set server online with host it's absolutely out of context what i need.
 
Well i checked his video and he learn how to set server online with host it's absolutely out of context what i need.
I think you are confusing need with want. You need to use a more stable aac unfortunately you want to use what you currently have.
 
I think you are confusing need with want. You need to use a more stable aac unfortunately you want to use what you currently have.
I know that my current situation is not the best, my acc maker is not stable but i have no choice. There is no simple tutorial how to run that znoteacc. Anyway no one told me why i get account.php error when i delete player accounts from database.
 
I know that my current situation is not the best, my acc maker is not stable but i have no choice. There is no simple tutorial how to run that znoteacc. Anyway no one told me why i get account.php error when i delete player accounts from database.
Ok i'll tell you just as the server did, this line is 149.
PHP:
               if(in_array(strtolower($unit), $config['invalidNameTags'])) {
The array config does not have an index with the name "invalidNameTags"
The 2nd error in_array requires 2 arguments, since "invalidNameTags" is not an index of config then the 2nd argument which is passed to in_array becomes invalid and the server throws the error.
 
Ok i'll tell you just as the server did, this line is 149.
PHP:
               if(in_array(strtolower($unit), $config['invalidNameTags'])) {
The array config does not have an index with the name "invalidNameTags"
The 2nd error in_array requires 2 arguments, since "invalidNameTags" is not an index of config then the 2nd argument which is passed to in_array becomes invalid and the server throws the error.
Jesus christ so what should i do?
 
Jesus christ so what should i do?
Put this inside of your config.php
PHP:
    // Restricted names
    $config['invalidNameTags'] = array(
        "owner", "gamemaster", "hoster", "admin", "staff", "tibia", "account", "god", "anal", "ass", "fuck", "sex", "hitler", "pussy", "dick", "rape", "cm", "gm", "amazon", "valkyrie", "carrion worm", "rotworm", "rotworm queen", "cockroach", "kongra", "merlkin", "sibang", "crystal spider", "giant spider", "poison spider", "scorpion", "spider", "tarantula", "achad", "axeitus headbanger", "bloodpaw", "bovinus", "colerian the barbarian", "cursed gladiator", "frostfur", "orcus the cruel", "rocky", "the hairy one", "avalanche", "drasilla", "grimgor guteater", "kreebosh the exile", "slim", "spirit of earth", "spirit of fire", "spirit of water", "the dark dancer", "the hag", "darakan the executioner", "deathbringer", "fallen mooh'tah master ghar", "gnorre chyllson", "norgle glacierbeard", "svoren the mad", "the masked marauder", "the obliverator", "the pit lord", "webster", "barbarian bloodwalker", "barbarian brutetamer", "barbarian headsplitter", "barbarian skullhunter", "bear", "panda", "polar bear", "braindeath", "beholder", "elder beholder", "gazer", "chicken", "dire penguin", "flamingo", "parrot", "penguin", "seagull", "terror bird", "bazir", "infernatil", "thul", "munster", "son of verminor", "xenia", "zoralurk", "big boss trolliver", "foreman kneebiter", "mad technomancer", "man in the cave", "lord of the elements", "the count", "the plasmother", "dracola", "the abomination", "the handmaiden", "mr. punish", "the countess sorrow", "the imperor", "massacre", "apocalypse", "brutus bloodbeard", "deadeye devious", "demodras", "dharalion", "fernfang", "ferumbras", "general murius", "ghazbaran", "grorlam", "lethal lissy", "morgaroth", "necropharus", "orshabaal", "ron the ripper", "the evil eye", "the horned fox", "the old widow", "tiquandas revenge", "apprentice sheng", "dog", "hellhound", "war wolf", "winter wolf", "wolf", "chakoya toolshaper", "chakoya tribewarden", "chakoya windcaller", "blood crab", "crab", "frost giant", "frost giantess", "ice golem", "yeti", "acolyte of the cult", "adept of the cult", "enlightened of the cult", "novice of the cult", "ungreez", "dark torturer", "demon", "destroyer", "diabolic imp", "fire devil", "fury", "hand of cursed fate", "juggernaut", "nightmare", "plaguesmith", "blue djinn", "efreet", "admin", "green djinn", "marid", "frost dragon", "wyrm", "sea serpent", "dragon lord", "dragon", "hydra", "dragon hatchling", "dragon lord hatchling", "frost dragon hatchling", "dwarf geomancer", "dwarf guard", "dwarf soldier", "dwarf", "dworc fleshhunter", "dworc venomsniper", "dworc voodoomaster", "elephant", "mammoth", "elf arcanist", "elf scout", "elf", "charged energy elemental", "energy elemental", "massive energy elemental", "overcharged energy elemental", "energy overlord", "cat", "lion", "tiger", "azure frog", "coral frog", "crimson frog", "green frog", "orchid frog", "toad", "jagged earth elemental", "muddy earth elemental", "earth elemental", "massive earth elemental", "earth overlord", "gargoyle", "stone golem", "ghost", "phantasm", "phantasm", "pirate ghost", "spectre", "cyclops smith", "cyclops drone", "behemoth", "cyclops", "slick water elemental", "roaring water elemental", "ice overlord", "water elemental", "massive water elemental", "ancient scarab", "butterfly", "bug", "centipede", "exp bug", "larva", "scarab", "wasp", "lizard sentinel", "lizard snakecharmer", "lizard templar", "minotaur archer", "minotaur guard", "minotaur mage", "minotaur", "squirrel", "goblin demon", "badger", "bat", "deer", "the halloween hare", "hyaena", "pig", "rabbit", "silver rabbit", "skunk", "wisp", "dark monk", "monk", "tha exp carrier", "necromancer", "priestess", "orc berserker", "orc leader", "orc rider", "orc shaman", "orc spearman", "orc warlord", "orc warrior", "orc", "goblin leader", "goblin scavenger", "goblin", "goblin assassin", "assasin", "bandit", "black knight", "hero", "hunter", "nomad", "smuggler", "stalker", "poacher", "wild warrior", "ashmunrah", "dipthrah", "mahrdis", "morguthis", "omruc", "rahemos", "thalas", "vashresamun", "pirate buccaneer", "pirate corsair", "pirate cutthroat", "pirate marauder", "carniphila", "spit nettle", "fire overlord", "massive fire elemental", "blistering fire elemental", "blazing fire elemental", "fire elemental", "hellfire fighter", "quara constrictor scout", "quara hydromancer scout", "quara mantassin scout", "quara pincher scout", "quara predator scout", "quara constrictor", "quara hydromancer", "quara mantassin", "quara pincher", "quara predator", "cave rat", "rat", "cobra", "crocodile", "serpent spawn", "snake", "wyvern", "black sheep", "sheep", "mimic", "betrayed wraith", "bonebeast", "demon skeleton", "lost soul", "pirate skeleton", "skeleton", "skeleton warrior", "undead dragon", "defiler", "slime2", "slime", "bog raider", "ice witch", "warlock", "witch", "bones", "fluffy", "grynch clan goblin", "hacker", "minishabaal", "primitive", "tibia bug", "undead minion", "annihilon", "hellgorak", "latrivan", "madareth", "zugurosh", "ushuriel", "golgordan", "thornback tortoise", "tortoise", "eye of the seven", "deathslicer", "flamethrower", "magicthrower", "plaguethrower", "poisonthrower", "shredderthrower", "troll champion", "frost troll", "island troll", "swamp troll", "troll", "banshee", "blightwalker", "crypt shambler", "ghoul", "lich", "mummy", "vampire", "grim reaper", "frost dragon", "mercenary", "zathroth", "goshnar", "durin", "demora", "orc champion", "dracula", "alezzo", "prince almirith", "elf warlord", "magebomb", "nightmare scion"
    );
 
Put this inside of your config.php
PHP:
    // Restricted names
    $config['invalidNameTags'] = array(
        "owner", "gamemaster", "hoster", "admin", "staff", "tibia", "account", "god", "anal", "ass", "fuck", "sex", "hitler", "pussy", "dick", "rape", "cm", "gm", "amazon", "valkyrie", "carrion worm", "rotworm", "rotworm queen", "cockroach", "kongra", "merlkin", "sibang", "crystal spider", "giant spider", "poison spider", "scorpion", "spider", "tarantula", "achad", "axeitus headbanger", "bloodpaw", "bovinus", "colerian the barbarian", "cursed gladiator", "frostfur", "orcus the cruel", "rocky", "the hairy one", "avalanche", "drasilla", "grimgor guteater", "kreebosh the exile", "slim", "spirit of earth", "spirit of fire", "spirit of water", "the dark dancer", "the hag", "darakan the executioner", "deathbringer", "fallen mooh'tah master ghar", "gnorre chyllson", "norgle glacierbeard", "svoren the mad", "the masked marauder", "the obliverator", "the pit lord", "webster", "barbarian bloodwalker", "barbarian brutetamer", "barbarian headsplitter", "barbarian skullhunter", "bear", "panda", "polar bear", "braindeath", "beholder", "elder beholder", "gazer", "chicken", "dire penguin", "flamingo", "parrot", "penguin", "seagull", "terror bird", "bazir", "infernatil", "thul", "munster", "son of verminor", "xenia", "zoralurk", "big boss trolliver", "foreman kneebiter", "mad technomancer", "man in the cave", "lord of the elements", "the count", "the plasmother", "dracola", "the abomination", "the handmaiden", "mr. punish", "the countess sorrow", "the imperor", "massacre", "apocalypse", "brutus bloodbeard", "deadeye devious", "demodras", "dharalion", "fernfang", "ferumbras", "general murius", "ghazbaran", "grorlam", "lethal lissy", "morgaroth", "necropharus", "orshabaal", "ron the ripper", "the evil eye", "the horned fox", "the old widow", "tiquandas revenge", "apprentice sheng", "dog", "hellhound", "war wolf", "winter wolf", "wolf", "chakoya toolshaper", "chakoya tribewarden", "chakoya windcaller", "blood crab", "crab", "frost giant", "frost giantess", "ice golem", "yeti", "acolyte of the cult", "adept of the cult", "enlightened of the cult", "novice of the cult", "ungreez", "dark torturer", "demon", "destroyer", "diabolic imp", "fire devil", "fury", "hand of cursed fate", "juggernaut", "nightmare", "plaguesmith", "blue djinn", "efreet", "admin", "green djinn", "marid", "frost dragon", "wyrm", "sea serpent", "dragon lord", "dragon", "hydra", "dragon hatchling", "dragon lord hatchling", "frost dragon hatchling", "dwarf geomancer", "dwarf guard", "dwarf soldier", "dwarf", "dworc fleshhunter", "dworc venomsniper", "dworc voodoomaster", "elephant", "mammoth", "elf arcanist", "elf scout", "elf", "charged energy elemental", "energy elemental", "massive energy elemental", "overcharged energy elemental", "energy overlord", "cat", "lion", "tiger", "azure frog", "coral frog", "crimson frog", "green frog", "orchid frog", "toad", "jagged earth elemental", "muddy earth elemental", "earth elemental", "massive earth elemental", "earth overlord", "gargoyle", "stone golem", "ghost", "phantasm", "phantasm", "pirate ghost", "spectre", "cyclops smith", "cyclops drone", "behemoth", "cyclops", "slick water elemental", "roaring water elemental", "ice overlord", "water elemental", "massive water elemental", "ancient scarab", "butterfly", "bug", "centipede", "exp bug", "larva", "scarab", "wasp", "lizard sentinel", "lizard snakecharmer", "lizard templar", "minotaur archer", "minotaur guard", "minotaur mage", "minotaur", "squirrel", "goblin demon", "badger", "bat", "deer", "the halloween hare", "hyaena", "pig", "rabbit", "silver rabbit", "skunk", "wisp", "dark monk", "monk", "tha exp carrier", "necromancer", "priestess", "orc berserker", "orc leader", "orc rider", "orc shaman", "orc spearman", "orc warlord", "orc warrior", "orc", "goblin leader", "goblin scavenger", "goblin", "goblin assassin", "assasin", "bandit", "black knight", "hero", "hunter", "nomad", "smuggler", "stalker", "poacher", "wild warrior", "ashmunrah", "dipthrah", "mahrdis", "morguthis", "omruc", "rahemos", "thalas", "vashresamun", "pirate buccaneer", "pirate corsair", "pirate cutthroat", "pirate marauder", "carniphila", "spit nettle", "fire overlord", "massive fire elemental", "blistering fire elemental", "blazing fire elemental", "fire elemental", "hellfire fighter", "quara constrictor scout", "quara hydromancer scout", "quara mantassin scout", "quara pincher scout", "quara predator scout", "quara constrictor", "quara hydromancer", "quara mantassin", "quara pincher", "quara predator", "cave rat", "rat", "cobra", "crocodile", "serpent spawn", "snake", "wyvern", "black sheep", "sheep", "mimic", "betrayed wraith", "bonebeast", "demon skeleton", "lost soul", "pirate skeleton", "skeleton", "skeleton warrior", "undead dragon", "defiler", "slime2", "slime", "bog raider", "ice witch", "warlock", "witch", "bones", "fluffy", "grynch clan goblin", "hacker", "minishabaal", "primitive", "tibia bug", "undead minion", "annihilon", "hellgorak", "latrivan", "madareth", "zugurosh", "ushuriel", "golgordan", "thornback tortoise", "tortoise", "eye of the seven", "deathslicer", "flamethrower", "magicthrower", "plaguethrower", "poisonthrower", "shredderthrower", "troll champion", "frost troll", "island troll", "swamp troll", "troll", "banshee", "blightwalker", "crypt shambler", "ghoul", "lich", "mummy", "vampire", "grim reaper", "frost dragon", "mercenary", "zathroth", "goshnar", "durin", "demora", "orc champion", "dracula", "alezzo", "prince almirith", "elf warlord", "magebomb", "nightmare scion"
    );
Says same error

bump
 
Last edited by a moderator:
I know that my current situation is not the best, my acc maker is not stable but i have no choice. There is no simple tutorial how to run that znoteacc. Anyway no one told me why i get account.php error when i delete player accounts from database.

I sent you the Tutorial Video on how to set up everything you need from scratch with Znote yesterday, you say you have no choice but you probably didn't do any of what I suggested you to do, as you say it's completely out of context, you deleted the database, you want to set everything up from zero, watch the videos and do it step by step, if you haven't got information on how to set Znote please read Znote's README.MD file from GitHub which you can find here GitHub - Znote/ZnoteAAC: Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. -> just scroll down the page. If you need help after trying and not being successfull I am willing to help you out, just make sure you use TFS and Znote as I know how to set them up, done it countless times for a bunch of people here. Just come at me with errors if there is any, spend some time actually trying to fix your problem instead of waiting for someone to help you with your unsupported / unknown AAC... This post isn't meant to be understood as rude, please give your best so we can help you out! :)

Kindest Regards,
Okke
 
I sent you the Tutorial Video on how to set up everything you need from scratch with Znote yesterday, you say you have no choice but you probably didn't do any of what I suggested you to do, as you say it's completely out of context, you deleted the database, you want to set everything up from zero, watch the videos and do it step by step, if you haven't got information on how to set Znote please read Znote's README.MD file from GitHub which you can find here GitHub - Znote/ZnoteAAC: Developement repository for the Znote AAC project. A website portal to represent and manage your Open Tibia server. -> just scroll down the page. If you need help after trying and not being successfull I am willing to help you out, just make sure you use TFS and Znote as I know how to set them up, done it countless times for a bunch of people here. Just come at me with errors if there is any, spend some time actually trying to fix your problem instead of waiting for someone to help you with your unsupported / unknown AAC... This post isn't meant to be understood as rude, please give your best so we can help you out! :)

Kindest Regards,
Okke
Ok so i add this znoteacc to htdoc in xampp then it's says enter the website. So i enter i get this
dborigins_sprites_log_style_by_royalz_bho-d6pxgn4.png

Then i come to second part
2: Edit config.php and:

  • modify $config['TFSVersion'] with correct TFS version you are running. (TFS_02, TFS_03, TFS_10).
  • modify $config['page_admin_access'] with your admin account username(s).
What should i do here? My server support tfs 0.4
dborigins_sprites_log_style_by_royalz_bho-d6pxgn4.png

Because i can't find line that start "modify $config" in config.php
 
Great start we have, I'm proud!

You have a data called "*.sql" in which * could be anything inside your server's folder, open that data with any text editor of your choice, copy the content with ctrl+c. You will now need to login to your phpmyadmin which should be http://localhost/phpmyadmin <- mind this could vary depending on which webserver you installed, you're using windows, which means I wont support you for a long time as this is completely unprofessional and super buggy. Once you're logged to your phpmyadmin page, create a new database, click on it, navigate to the tab SQL, paste the code that you copied from the *.sql file and click on Ok. Tables will be created.

Once your tables were created just open a new tab on your browser, type http://localhost/ and you'll be redirected to the page you made a screenshot of, now copy all of the content of this text field and do the same as you've done with the *.sql file, once you're done with that proceed to the config file of your AAC (in this case Znote), which will be in the webserver's www or html folder. The config file name is config.php, it is there, use a text editor to open it, read and modify the files to your needs, There are plenty of questions about this on OTLand, you're more than welcome to use the search function.

After you edited the configuration file of your AAC, move on to the config.lua inside your distribution folder, configurate it right (give the username, password and database name and port which should be 3306 (default) for the SQL connection, just as you've done to your config.php file).

Done with everything? Start the server (I hate to tell you but you might have a bad time due to using windows, I mentioned 1000 times that people shouldn't use this cheap system to host servers, even for testing purposes...) go to the website, create an account and a player, open your client and log in.

Kindest Regards,
Okke
 
Back
Top