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

Doors bug/not opening (Houses)

Luanasar

Luanasar

Mapper
Joined
Jul 22, 2017
Messages
12
Reaction score
0
I'm facing some problems with the houses' doors. Even changing the door model in some houses with Remere's Map Editor, it's not updated on game. And most of the doors won't open, saying that You cannot use this object.
PS: I already tried deleting the house and then adding it again, but the problem persists.
Check the prints below, from both the game and the RME.
bug das portas 1.png bug das portas 2.png
 
Last edited:
Sort by date Sort by votes
Luanasar said:
There's no tile_store in my database.
Click to expand...

In that case make sure to read the rules; Rules for the Support board
#5

Most TFS servers (should be TFS because of the icon you got in the task bar) if not all have tile_store or something with that name atleast.
In there you got the "cache" that you should clear when you changed the map, most common "fault" is when people change out doors IMO
 
Upvote 0 Downvote
WibbenZ said:
In that case make sure to read the rules; Rules for the Support board
#5

Most TFS servers (should be TFS because of the icon you got in the task bar) if not all have tile_store or something with that name atleast.
In there you got the "cache" that you should clear when you changed the map, most common "fault" is when people change out doors IMO
Click to expand...

It is TFS, but there's no tile_store. There's tiles and tiles_itens, but I couldn't find the cache in none of them.
db2.png
 
Upvote 0 Downvote
Luanasar said:
It is TFS, but there's no tile_store. There's tiles and tiles_itens, but I couldn't find the cache in none of them.
View attachment 30240
Click to expand...

TFS is like saying I own a Ford, but what Ford? 0.2(?, ?), 0.3(3, 4, 5, 6, 7), 0.4, 1.(1, 2, 3) etc etc
What is in tile_items then, is it also related to houses?
 
Upvote 0 Downvote
WibbenZ said:
TFS is like saying I own a Ford, but what Ford? 0.2(?, ?), 0.3(3, 4, 5, 6, 7), 0.4, 1.(1, 2, 3) etc etc
What is in tile_items then, is it also related to houses?
Click to expand...

Sorry, I'm new in this, lmao. It's TFS 0.4, that's all the information I found.
tile_itens is not related to houses
db3.png
 
Upvote 0 Downvote
Luanasar said:
View attachment 30242

I also tried:

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE tiles;
SET FOREIGN_KEY_CHECKS = 1;

But it didn't work

EDIT: My bad, I was trying to truncate the wrong table ¬¬
Click to expand...

Okay, in that case delete the table and import it again (you have to schema for tile_items in your schema.sql / mysql.sql)
Make sure to take a backup of the database if you run into issues (export~)
 
Upvote 0 Downvote
do some doors work and some dont?
are they the same id?
if not then the problem is likely your doors.lua in actions
 
Upvote 0 Downvote
Luanasar said:
View attachment 30242

I also tried:

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE tiles;
SET FOREIGN_KEY_CHECKS = 1;

But it didn't work

EDIT: My bad, I was trying to truncate the wrong table ¬¬
Click to expand...

Truncate tile_items BEFORE you truncate tiles. Because the tile_items table is dependant on tiles. (items are placed on tiles, so they must always reference a valid tile).

I think tile_items just contain items placed on tiles on the map editor, house_items etc should have their own table. But just to be sure, go ahead and export a backup of tile_items before you truncate it.
 
Upvote 0 Downvote
Static_ said:
do some doors work and some dont?
are they the same id?
if not then the problem is likely your doors.lua in actions
Click to expand...

The only doors that doesn't work are the ones with IDs 1209, 1210, 1211, 1212, 1213, 1214.
All the others are working.

Znote said:
Truncate tile_items BEFORE you truncate tiles. Because the tile_items table is dependant on tiles. (items are placed on tiles, so they must always reference a valid tile).

I think tile_items just contain items placed on tiles on the map editor, house_items etc should have their own table. But just to be sure, go ahead and export a backup of tile_items before you truncate it.
Click to expand...

My tile_items contain items placed on the houses too.
I tried to truncate it again, but again, it didn't solve the problem :(
 
Upvote 0 Downvote
Luanasar said:
The only doors that doesn't work are the ones with IDs 1209, 1210, 1211, 1212, 1213, 1214.
All the others are working.



My tile_items contain items placed on the houses too.
I tried to truncate it again, but again, it didn't solve the problem :(
Click to expand...
did you check your doors.lua file for those item ids? it should be in actions folder.
 
Upvote 0 Downvote
Static_ said:
did you check your doors.lua file for those item ids? it should be in actions folder.
Click to expand...



--Door Script Edited by Danielo--
function onUse(cid, item, frompos, item2, topos)

doorpos = {x=topos.x, y=topos.y, z=topos.z, stackpos=253} -- mod by Yurez
doorplayer = getThingfromPos(doorpos)

if doorplayer.itemid > 0 then
doPlayerSendCancel(cid,"Someone is blocking the door.")
return 1
end

if item.itemid == 1209 then
if item.actionid == 0 then
doTransformItem(item.uid,1211)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1211 then
doTransformItem(item.uid,1209)
elseif item.itemid == 1250 then
if item.actionid == 0 then
doTransformItem(item.uid,1251)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1251 then
doTransformItem(item.uid,1250)
elseif item.itemid == 1232 then
if item.actionid == 0 then
doTransformItem(item.uid,1233)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1232 then
doTransformItem(item.uid,1233)
elseif item.itemid == 1253 then
if item.actionid == 0 then
doTransformItem(item.uid,1254)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1254 then
doTransformItem(item.uid,1253)

elseif item.itemid == 1235 then
if item.actionid == 0 then
doTransformItem(item.uid,1236)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1236 then
doTransformItem(item.uid,1235)

elseif item.itemid == 1212 then
if item.actionid == 0 then
doTransformItem(item.uid,1214)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1214 then
doTransformItem(item.uid,1212)

elseif item.itemid == 1219 then
if item.actionid == 0 then
doTransformItem(item.uid,1220)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1220 then
doTransformItem(item.uid,1219)

elseif item.itemid == 1221 then
if item.actionid == 0 then
doTransformItem(item.uid,1222)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1222 then
doTransformItem(item.uid,1221)

elseif item.itemid == 1223 then
if item.actionid == 0 then
doTransformItem(item.uid,1224)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1224 then
doTransformItem(item.uid,1223)
----
elseif item.itemid == 1225 then
if item.actionid == 0 then
doTransformItem(item.uid,1226)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end


-----
elseif item.itemid == 1226 then
doTransformItem(item.uid,1225)

elseif item.itemid == 1227 then
if item.actionid == 0 then
doTransformItem(item.uid,1228)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1228 then
doTransformItem(item.uid,1227)

elseif item.itemid == 1229 then
if item.actionid == 0 then
doTransformItem(item.uid,1230)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1230 then
doTransformItem(item.uid,1229)

elseif item.itemid == 1231 then
if item.actionid == 0 then
doTransformItem(item.uid,1233)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1233 then
doTransformItem(item.uid,1231)

elseif item.itemid == 1234 then
if item.actionid == 0 then
doTransformItem(item.uid,1236)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1236 then
doTransformItem(item.uid,1234)

elseif item.itemid == 1237 then
if item.actionid == 0 then
doTransformItem(item.uid,1238)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1238 then
doTransformItem(item.uid,1237)

elseif item.itemid == 1239 then
if item.actionid == 0 then
doTransformItem(item.uid,1240)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1240 then
doTransformItem(item.uid,1239)

elseif item.itemid == 1241 then
if item.actionid == 0 then
doTransformItem(item.uid,1242)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1242 then
doTransformItem(item.uid,1241)

elseif item.itemid == 1243 then
if item.actionid == 0 then
doTransformItem(item.uid,1244)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1244 then
doTransformItem(item.uid,1243)

elseif item.itemid == 1245 then
if item.actionid == 0 then
doTransformItem(item.uid,1246)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1246 then
doTransformItem(item.uid,1245)

elseif item.itemid == 1247 then
if item.actionid == 0 then
doTransformItem(item.uid,1248)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1248 then
doTransformItem(item.uid,1247)

elseif item.itemid == 1249 then
if item.actionid == 0 then
doTransformItem(item.uid,1251)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1251 then
doTransformItem(item.uid,1249)

elseif item.itemid == 1252 then
if item.actionid == 0 then
doTransformItem(item.uid,1254)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1254 then
doTransformItem(item.uid,1252)

elseif item.itemid == 1255 then
if item.actionid == 0 then
doTransformItem(item.uid,1256)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1256 then
doTransformItem(item.uid,1255)

elseif item.itemid == 1257 then
if item.actionid == 0 then
doTransformItem(item.uid,1258)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1258 then
doTransformItem(item.uid,1257)

elseif item.itemid == 1259 then
if item.actionid == 0 then
doTransformItem(item.uid,1260)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1260 then
doTransformItem(item.uid,1259)

elseif item.itemid == 1261 then
if item.actionid == 0 then
doTransformItem(item.uid,1262)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1262 then
doTransformItem(item.uid,1261)

--another simple door--
elseif item.itemid == 1634 then
if item.actionid == 0 then
doTransformItem(item.uid,1635)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1635 then
doTransformItem(item.uid,1634)

elseif item.itemid == 1636 then
if item.actionid == 0 then
doTransformItem(item.uid,1637)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1637 then
doTransformItem(item.uid,1636)

--another simple door--

elseif item.itemid == 1638 then
if item.actionid == 0 then
doTransformItem(item.uid,1639)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1639 then
doTransformItem(item.uid,1638)

elseif item.itemid == 5082 then
if item.actionid == 0 then
doTransformItem(item.uid,5083)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 5083 then
doTransformItem(item.uid,5082)

elseif item.itemid == 5084 then
if item.actionid == 0 then
doTransformItem(item.uid,5085)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 5085 then
doTransformItem(item.uid,5084)

elseif item.itemid == 4913 then
if item.actionid == 0 then
doTransformItem(item.uid,4914)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 4914 then
doTransformItem(item.uid,4913)

elseif item.itemid == 4915 then
if item.actionid == 0 then
doTransformItem(item.uid,4916)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 4916 then
doTransformItem(item.uid,4915)

elseif item.itemid == 3535 then
if item.actionid == 0 then
doTransformItem(item.uid,3537)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3537 then
doTransformItem(item.uid,3535)

elseif item.itemid == 3536 then
if item.actionid == 0 then
doTransformItem(item.uid,3537)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3537 then
doTransformItem(item.uid,3536)

elseif item.itemid == 3538 then
if item.actionid == 0 then
doTransformItem(item.uid,3539)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3539 then
doTransformItem(item.uid,3538)

elseif item.itemid == 3540 then
if item.actionid == 0 then
doTransformItem(item.uid,3541)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3541 then
doTransformItem(item.uid,3540)

elseif item.itemid == 3542 then
if item.actionid == 0 then
doTransformItem(item.uid,3543)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3543 then
doTransformItem(item.uid,3542)

elseif item.itemid == 3544 then
if item.actionid == 0 then
doTransformItem(item.uid,3546)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3546 then
doTransformItem(item.uid,3544)

elseif item.itemid == 3545 then
if item.actionid == 0 then
doTransformItem(item.uid,3546)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3546 then
doTransformItem(item.uid,3545)

elseif item.itemid == 3547 then
if item.actionid == 0 then
doTransformItem(item.uid,3548)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3548 then
doTransformItem(item.uid,3547)

elseif item.itemid == 3549 then
if item.actionid == 0 then
doTransformItem(item.uid,3550)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3550 then
doTransformItem(item.uid,3549)

elseif item.itemid == 3551 then
if item.actionid == 0 then
doTransformItem(item.uid,3552)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 3552 then
doTransformItem(item.uid,3551)

elseif item.itemid == 1640 then
if item.actionid == 0 then
doTransformItem(item.uid,1641)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1641 then
doTransformItem(item.uid,1640)

elseif item.itemid == 1213 then
if item.actionid == 0 then
doTransformItem(item.uid,1214)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1214 then
doTransformItem(item.uid,1213)

elseif item.itemid == 1210 then
if item.actionid == 0 then
doTransformItem(item.uid,1211)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1211 then
doTransformItem(item.uid,1210)

elseif item.itemid == 1539 then
if item.actionid == 0 then
doTransformItem(item.uid,1540)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1540 then
doTransformItem(item.uid,1539)

elseif item.itemid == 1541 then
if item.actionid == 0 then
doTransformItem(item.uid,1542)
else
doPlayerSendTextMessage(cid,22,"It is locked.")
end
elseif item.itemid == 1542 then
doTransformItem(item.uid,1541)
else
return 0
end
return 1
end
Click to expand...
 
Upvote 0 Downvote
Static_ said:
looks like they're in the script, check for the item ids in the actions.xml
Click to expand...

That's it! They weren't in actions.xml
I added them and now they're working!

Although now these warnings are showing up in the server log:
[Warning - Actions: :registerEvent] Duplicate registered item with id: 1213, in fromid: 1213 and toid: 1214
[Warning - Actions: :registerEvent] Duplicate registered item with id: 1214, in fromid: 1213 and toid: 1214
[Warning - Actions: :registerEvent] Duplicate registered item with id: 1210, in fromid: 1210 and toid: 1211
[Warning - Actions: :registerEvent] Duplicate registered item with id: 1210, in fromid: 1210 and toid: 1211

By the way, this is how I added the doors in actions.xml:
<action fromid="1212" toid="1214" script="other/doors.lua"/>
<action fromid="1213" toid="1214" script="other/doors.lua"/>
<action fromid="1209" toid="1211" script="other/doors.lua"/>
<action fromid="1210" toid="1211" script="other/doors.lua"/>
 
Upvote 0 Downvote

Similar threads

J
  • Solved
TFS 1.X+ strange problem with houses
Replies
15
Views
629
Jeyci
J
P
  • Question
[13.21 Canary] Issues attempting to load Canary map with RME.
Replies
3
Views
860
pepeg123
P
eardrums
  • Question
Remeres wont open with server!
Replies
6
Views
503
eardrums
eardrums
F
  • Question
RME comprehensive setup guide
Replies
0
Views
290
Fichom
F
Jpstafe
  • Question
Remere Map Editor Sqm dude
Replies
5
Views
530
Jpstafe
Jpstafe
Back
Top