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

[7.72] OTHire 0.0.3

Peonso

Godly Member
Joined
Jan 14, 2008
Messages
1,748
Solutions
30
Reaction score
1,529
OTHire 0.0.3

The highlights of this release are:

- Healing and attacking spells shares exhaust
- Players block ranged physical attacks from monsters with shield
- Creature events onDie, onKill, onAdvance, onLook available
- Monsters change target strategies implemented
- Add party shared experience
- Add rooking system to config.lua
- Loot messages (not default)
- Better monster path finding, weaker monsters don't block path anymore
- Fixed monsters casting spells through walls
- Fixed monsters being traped by moveable items
- Fixed bug with beds itemids
- Fixed some crash bugs
- Updated items.xml
- Updated spells
- Inumerous minor bugs fixed

This release was made possible by (number of commits):
And also from the support of this guys (thanks!):

Changelog: https://github.com/TwistedScorpio/OTHire/wiki/Change-Log
You can report issues here: https://github.com/TwistedScorpio/OTHire/issues
How to use RME with OTHire:[URL='https://github.com/TwistedScorpio/OTHire/wiki/How-to-use-RME-for-this-OTServer'] https://github.com/TwistedScorpio/OTHire/wiki/How-to-use-RME-for-this-OTServer[/URL]

Download: https://github.com/TwistedScorpio/OTHire/releases/tag/v0.0.3
 
Hello, thanks for release.
Can someone please help me with this error I get when i try to import?

Static analysis:

5 errors were found during analysis.

  1. An opening bracket followed by a set of values was expected. (near "DROP" at position 729)
  2. An expression was expected. (near "TRIGGER" at position 734)
  3. Unrecognized keyword. (near "TRIGGER" at position 734)
  4. Unrecognized keyword. (near "IF EXISTS" at position 742)
  5. Unexpected token. (near "`oncreate_players`" at position 752)
SQL-fråga: (question)

INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `direction`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `save`, `conditions`, `skull_type`, `skull_time`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `loss_containers`, `town_id`, `balance`, `online`, `rank_id`, `guildnick`) VALUES (3, 'GM Sample', 123456, 5, 1, 0, 100, 2, 4, 100, 100, 100, 100, 70775, 0, 2, 10, 10, 10, 10, 75, 32368, 32215, 7, 10000, 1396046551, 1396045859, 400558280, 1, '', 0, 0, 100, 100, 100, 10, 100, 1, 0, 1, 0, ''), DROP TRIGGER IF EXISTS `oncreate_players`

MySQL sa: (said)

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DROP TRIGGER IF EXISTS `oncreate_players`' at line 4
 
Hello, thanks for release.
Can someone please help me with this error I get when i try to import?

Static analysis:

5 errors were found during analysis.

  1. An opening bracket followed by a set of values was expected. (near "DROP" at position 729)
  2. An expression was expected. (near "TRIGGER" at position 734)
  3. Unrecognized keyword. (near "TRIGGER" at position 734)
  4. Unrecognized keyword. (near "IF EXISTS" at position 742)
  5. Unexpected token. (near "`oncreate_players`" at position 752)
SQL-fråga: (question)

INSERT INTO `players` (`id`, `name`, `account_id`, `group_id`, `sex`, `vocation`, `experience`, `level`, `maglevel`, `health`, `healthmax`, `mana`, `manamax`, `manaspent`, `soul`, `direction`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `posx`, `posy`, `posz`, `cap`, `lastlogin`, `lastlogout`, `lastip`, `save`, `conditions`, `skull_type`, `skull_time`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `loss_containers`, `town_id`, `balance`, `online`, `rank_id`, `guildnick`) VALUES (3, 'GM Sample', 123456, 5, 1, 0, 100, 2, 4, 100, 100, 100, 100, 70775, 0, 2, 10, 10, 10, 10, 75, 32368, 32215, 7, 10000, 1396046551, 1396045859, 400558280, 1, '', 0, 0, 100, 100, 100, 10, 100, 1, 0, 1, 0, ''), DROP TRIGGER IF EXISTS `oncreate_players`

MySQL sa: (said)

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'DROP TRIGGER IF EXISTS `oncreate_players`' at line 4

Try this https://raw.githubusercontent.com/TwistedScorpio/OTHire/master/MySql_Schema.sql
 
Tried that one, now I get this
Code:
Error

Static analysis:

48 errors were found during analysis.

    An opening bracket followed by a set of values was expected. (near "CREATE" at position 190)
    Unrecognized keyword. (near "TABLE" at position 197)
    Unexpected token. (near "`player_killers`" at position 203)
    Unexpected token. (near "(" at position 220)
    Unexpected token. (near "`kill_id`" at position 225)
    Unrecognized keyword. (near "int" at position 235)
    Unexpected token. (near "(" at position 238)
    Unexpected token. (near "10" at position 239)
    Unexpected token. (near ")" at position 241)
    Unrecognized keyword. (near "unsigned" at position 243)
    Unrecognized keyword. (near "NOT NULL" at position 252)
    Unexpected token. (near "," at position 260)
    Unexpected token. (near "`player_id`" at position 265)
    Unrecognized keyword. (near "int" at position 277)
    Unexpected token. (near "(" at position 280)
    Unexpected token. (near "10" at position 281)
    Unexpected token. (near ")" at position 283)
    Unrecognized keyword. (near "unsigned" at position 285)
    Unrecognized keyword. (near "NOT NULL" at position 294)
    Unexpected token. (near "," at position 302)
    Unexpected token. (near "`unjustified`" at position 307)
    Unrecognized keyword. (near "tinyint" at position 321)
    Unexpected token. (near "(" at position 328)
    Unexpected token. (near "1" at position 329)
    Unexpected token. (near ")" at position 330)
    Unrecognized keyword. (near "NOT NULL" at position 332)
    Unrecognized keyword. (near "DEFAULT" at position 341)
    Unexpected token. (near "'0'" at position 349)
    Unexpected token. (near "," at position 352)
    Unrecognized keyword. (near "PRIMARY KEY" at position 357)
    Unexpected token. (near "(" at position 369)
    Unexpected token. (near "`kill_id`" at position 370)
    Unexpected token. (near "," at position 379)
    Unexpected token. (near "`player_id`" at position 380)
    Unexpected token. (near ")" at position 391)
    Unexpected token. (near "," at position 392)
    Unrecognized keyword. (near "KEY" at position 397)
    Unexpected token. (near "`player_id`" at position 401)
    Unexpected token. (near "(" at position 413)
    Unexpected token. (near "`player_id`" at position 414)
    Unexpected token. (near ")" at position 425)
    Unexpected token. (near ")" at position 428)
    Unrecognized keyword. (near "ENGINE" at position 430)
    Unexpected token. (near "=" at position 436)
    Unexpected token. (near "InnoDB" at position 437)
    Unrecognized keyword. (near "DEFAULT CHARSET" at position 444)
    Unexpected token. (near "=" at position 459)
    Unexpected token. (near "utf8" at position 460)

SQL query:

INSERT INTO `player_items` (`player_id`, `sid`, `pid`, `itemtype`, `count`, `attributes`) VALUES (3, 101, 5, 2152, 98, 0x0f62), (3, 102, 6, 2183, 1, ''), (3, 103, 8, 2643, 1, ''), CREATE TABLE `player_killers` ( `kill_id` int(10) unsigned NOT NULL, `player_id` int(10) unsigned NOT NULL, `unjustified` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`kill_id`,`player_id`), KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE TABLE `player_killers` (
  `kill_id` int(10) unsigned NOT NULL,
  `play' at line 8
 
Files updated today, fixing a crash bug and @Evilor issues with schema.sql.
 
Hey @Peonso , I was able to get everything running just fine, but sometimes the server just closes for no reason. No error message, and its always after a random amount of time. Sometimes it closes after 30 seconds, sometimes 10 minutes. I haven't noticed any patterns, like using items causing the crash etc. It seems to be random.

I have tried running as admin, didn't seem to make a difference, it still closed on its own eventually.

Any thoughts?
 
Neat. Glad you keep releasing stuff for the oldschool community. I wont use it myself but I hope it helps others. Great work to all of you. And happy new year by the way.
 
I have found other bug.
Everytime you say BYE for one NPC, the npc change your look direction to north, then walk away.
It happened with the Test NPC, that comes in folder for example, and on all NPCs that I have configured.
 
Back
Top