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

Windows Shift clicking on yourself/other players

Kierkan

New Member
Joined
Aug 21, 2011
Messages
9
Reaction score
2
Hey guys. I wanted to get a personal Tibia OT going for me and my friends. Most of them haven't played in forever and we're really excited. Unfortunately the task of getting it all to work has fallen to me, and I know absolutely nothing about scripts. The issue I have is when trying to shift click other players or yourself, I get this error:

[18:50:09.076] mysql_real_query(): SELECT `rep` FROM `players` WHERE `id` = 3 -
MYSQL ERROR: Unknown column 'rep' in 'field list' (1054)

[18:50:09.076] [Error - CreatureScript Interface]
[18:50:09.077] domodlib('repSystem')
[18:50:09.077] function onLook(cid, thing, position, lookDistance)
[18:50:09.077] if isPlayer(thing.uid) and thing.uid ~= cid then
[18:50:09.078] doPlayerSetSpecialDescription(thing.uid,'\n'.. rep.ge
tArticle(thing.uid, true)..' is ' .. rep.getRank(rep.getPoints(thing.uid)) ..'.'
)
[18:50:09.078] return true
[18:50:09.079] elseif thing.uid == cid then
[18:50:09.079] local string = 'You see yourself.'
[18:50:09.079] if getPlayerFlagValue(cid, PLAYERFLAG_SHOWGROUPI
NSTEADOFVOCATION) then
[18:50:09.080] string = string..' You are '.. getPlayer
GroupName(cid) ..'.'
[18:50:09.080] elseif getPlayerVocation(cid) ~= 0 then
[18:50:09.081] string = string..' You are '.. getPlayer
VocationName(cid) ..'.'
[18:50:09.081] else
[18:50:09.081] string = string..' You have no vocation.
'
[18:50:09.082] end
[18:50:09.082] string = string..' You are '.. rep.getRank(rep.g
etPoints(cid)) ..'.'
[18:50:09.083]
[18:50:09.083] if getPlayerNameByGUID(getPlayerPartner(cid), fa
lse, false) ~= nil then
[18:50:09.083] string = string..' You are '.. (getPlaye
rSex(cid) == 0 and 'wife' or 'husband') ..' of '.. getPlayerNameByGUID(getPlayer
Partner(cid)) ..'.'
[18:50:09.084] end
[18:50:09.084]
[18:50:09.084] if getPlayerGuildId(cid) > 0 then
[18:50:09.085] string = string..' You are ' .. (getPlay
erGuildRank(cid) == '' and 'a member' or getPlayerGuildRank(cid)) ..' of the '..
getPlayerGuildName(cid)
[18:50:09.085] string = getPlayerGuildNick(cid) ~= '' a
nd string..' ('.. getPlayerGuildNick(cid) ..').' or string..'.'
[18:50:09.086] end
[18:50:09.086]
[18:50:09.086] if getPlayerFlagValue(cid, PLAYERCUSTOMFLAG_CANS
EECREATUREDETAILS) then
[18:50:09.087] string = string..'\nHealth: ['.. getCrea
tureHealth(cid) ..' / '.. getCreatureMaxHealth(cid) ..'], Mana: ['.. getCreature
Mana(cid) ..' / '.. getCreatureMaxMana(cid) ..'].'
[18:50:09.087] string = string..'\nIP: '.. doConvertInt
egerToIp(getPlayerIp(cid)) ..'.'
[18:50:09.088] end
[18:50:09.088]
[18:50:09.088] if getPlayerFlagValue(cid, PLAYERCUSTOMFLAG_CANS
EEPOSITION) then
[18:50:09.089] string = string..'\nPosition: [X:'.. pos
ition.x..'] [Y:'.. position.y..'] [Z:'.. position.z..'].'
[18:50:09.089] end
[18:50:09.090] doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR,
string)
[18:50:09.090] return false
[18:50:09.090] end
[18:50:09.091] return true
[18:50:09.091] end:eek:nLook
[18:50:09.091] Description:
[18:50:09.092] data/lib/004-database.lua:60: [Result:getDataInt] Result not set!

[18:50:09.092] stack traceback:
[18:50:09.093] [C]: in function 'error'
[18:50:09.093] data/lib/004-database.lua:60: in function 'getDataInt'
[18:50:09.093] [string "rep = {..."]:46: in function 'getPoints'
[18:50:09.094] [string "LuaInterface::loadBuffer"]:15: in function <[string "Lu
aInterface::loadBuffer"]:2>

From my limited knowledge, it seems like it's trying to access some custom reputation system that came with the server. If that is the case, what do I need to trim to make it work? Is

I apologize for my ignorance, as I said before I'm very new to this.

Thanks in advance!
 
if it's just for you and your friends, the rep system is kinda useless
you can just delete it from your mods folder
if you actually intend on fixing it for whatever reason, your database is missing a column in your players table called 'rep'
 
if it's just for you and your friends, the rep system is kinda useless
you can just delete it from your mods folder
if you actually intend on fixing it for whatever reason, your database is missing a column in your players table called 'rep'

Deleting the mod itself fixed it! Thanks alot Xera.
 
Back
Top