• 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

  1. I

    Vocation name in highscores.php GESIOR

    Hello again, I have no idea how GEISOR works, so I'm merely guessing, but you can try this out for starters: <?PHP $list = $_REQUEST['list']; $page = $_REQUEST['page']; switch($list) { case "fist": $id = 0; $list_name = 'Fist Fighting'; break; case "club": $id = 1; $list_name = 'Club...
  2. I

    Linux Phpmyadmin Command

    Always learn something new, quotes for older phpmyadmins, I see. I'm glad it worked, yours Ignazio
  3. I

    Linux Phpmyadmin Command

    What? Lawl something of yours is way outdated, why would it set 0 when I specifically told it to get 10? Maybe it complains about the spaces, hmm. UPDATE `player_skills` as `ps` LEFT JOIN `players` AS `pl` ON `ps`.`player_id` = `pl`.`id` SET `ps`.`value` = "80" WHERE ((`pl`.`vocation` = 4 or...
  4. I

    Linux Phpmyadmin Command

    The query is perfectly fine, the problem is your outdated server, probably handling count as a constant value rather than resetting for each level. Could you go to player_skills and "browse" and show me how it looks Ignazio
  5. I

    Linux Phpmyadmin Command

    Sounds weird, take a look at the entries in the "player_skills" table and find some row with more than 50 in `value`, what is the `count` there? Try this too: UPDATE `player_skills` as `ps` LEFT JOIN `players` AS `pl` ON `ps`.`player_id` = `pl`.`id` SET `ps`.`value` = 80 and `ps`.`count` =...
  6. I

    Linux Phpmyadmin Command

    All the skills are zero? How does it look in the player_skills table? Maybe the count doesn't reset after an increase of skill, sounds weird though. Ignazio
  7. I

    Linux Phpmyadmin Command

    Ops! Mistook count for tries, sorry, here are two new, hopefully working queries: UPDATE `player_skills` as `ps` LEFT JOIN `players` AS `pl` ON `ps`.`player_id` = `pl`.`id` SET `ps`.`value` = 80 and `ps`.`count` = 0 WHERE ((`pl`.`vocation` = 4 or `pl`.`vocation` = 8) and (`ps`.`skillid` = 2 or...
  8. I

    Linux Phpmyadmin Command

    I divided them into two different queries UPDATE `player_skills` as `ps` LEFT JOIN `players` AS `pl` ON `ps`.`player_id` = `pl`.`id` SET `ps`.`value` = 80 and `ps`.`tries` = 0 WHERE ((`pl`.`vocation` = 4 or `pl`.`vocation` = 8) and (`ps`.`skillid` = 2 or `ps`.`skillid` = 3 or `ps`.`skillid` =...
  9. I

    Linux Phpmyadmin Command

    Try this query: UPDATE `player_skills` as `ps` LEFT JOIN `players` AS `pl` ON `ps`.`player_id` = `pl`.`id` SET `ps`.`value` = 10 and `ps`.`tries` = 0 WHERE ((`pl`.`vocation` = 4 or `pl`.`vocation` = 8) and (`ps`.`skillid` = 2 or `ps`.`skillid` = 3 or `ps`.`skillid` = 5)) OR ((`pl`.`vocation` =...
  10. I

    Linux Phpmyadmin Command

    First of all, export a backup of the table, if any of the commands you enter should end in faulty, you can revert back. Second of all, could you post a screenshot of your player_skills table? Ignazio
  11. I

    Whi World - Open Source Server with Configurable Features

    Everything you wrote on your "future" list can be found on these forums, with the search utility and some patience, nothing can stop you! :) Ignazio
  12. I

    Linux Phpmyadmin Command

    What server do you use? Could you post a screenshot of the structure view of your players table? Ignazio
  13. I

    Solved [1045] Access denied for user 'whiserv'@'localhost'

    How often does this occur? Seems strange if it works some times. The code is clearly complaining about the access, "denied" for whiserv with password test. Ignazio
  14. I

    addEvent error

    Use the first one though, much better. Else the server will complain and send you error notices if the player should die within the launch. Ignazio
  15. I

    Solved Can't connect to my 10.41 server due to this error help!

    Go to phpmyadmin, into your database and add this to the query box: ALTER TABLE `players` ADD `max_summons` INT NOT NULL DEFAULT '0'; Ignazio
  16. I

    Solved [1045] Access denied for user 'whiserv'@'localhost'

    It's not a problem with your htaccess, your connection has faulty. Do you know the host, username and password for your database access? Make sure they are correct in the config.php file, wherever that is. Ignazio
  17. I

    Vocation name in highscores.php GESIOR

    Wow that is some ugly php code. try this <?PHP $list = $_REQUEST['list']; $page = $_REQUEST['page']; switch($list) { case "fist": $id = 0; $list_name = 'Fist Fighting'; break; case "club": $id = 1; $list_name = 'Club Fighting'; break; case "sword": $id = 2; $list_name = 'Sword Fighting'...
  18. I

    Lua Min and max monsters attacks on custom spell

    Min and max serve no purpose when using a custom spell. You have to make static values in the spell file, alternatively you can (in the spell file) check what monster type the spell caster is, if it's a demon => damage is x,y, etc. Ignazio
  19. I

    [Sweden] Satan's Return [10.41] | 100% Real Map

    Bump! There have been new custom editions from the server creator. Hope to see you in-game!
  20. I

    [Sweden] Satan's Return [10.41] | 100% Real Map

    This is another chance for more serious players to start over on a brand new, fresh real map based OT server. Unlike other real map based servers, this server has a balanced experienced rate, serious staff with abilities to communicate with the players. I recommend posting in our support forum...
Back
Top