[7.72] OTHire 0.0.3

Peonso

Godly Member
Joined
Jan 14, 2008
Messages
1,515
Best answers
24
Reaction score
1,003
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
 

Evilor

Member
Joined
Oct 17, 2016
Messages
33
Best answers
0
Reaction score
2
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
 
OP
Peonso

Peonso

Godly Member
Joined
Jan 14, 2008
Messages
1,515
Best answers
24
Reaction score
1,003
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
 

Evilor

Member
Joined
Oct 17, 2016
Messages
33
Best answers
0
Reaction score
2
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
 

Evilor

Member
Joined
Oct 17, 2016
Messages
33
Best answers
0
Reaction score
2
Anyone else who has the same problem as me?
 
OP
Peonso

Peonso

Godly Member
Joined
Jan 14, 2008
Messages
1,515
Best answers
24
Reaction score
1,003
Files updated today, fixing a crash bug and @Evilor issues with schema.sql.
 

riptibia

Member
Joined
Jan 31, 2016
Messages
55
Best answers
0
Reaction score
12
Peonso are those fixes fixed in 7.6 the forgotten server?
 

X X X

Newb
Joined
Jul 26, 2015
Messages
95
Best answers
0
Reaction score
4
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?
 

Tony32

Legendary OT User
Joined
Jun 6, 2008
Messages
1,103
Best answers
0
Reaction score
208
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.
 

massuco

Brazilian, sorry for my bad english XD
Joined
Feb 17, 2013
Messages
195
Best answers
8
Reaction score
20
Location
Brasil
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.
 
Top