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

NPC Marriage system 8.6+ [Fixed]

[19/03/2013 16:09:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '371';)
[19/03/2013 16:09:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '371';)
[19/03/2013 16:09:37] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:09:37] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '371';)
[19/03/2013 16:10:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '371';)
[19/03/2013 16:10:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
 
Nosaa said:
[19/03/2013 16:09:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '371';)
[19/03/2013 16:09:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '371';)
[19/03/2013 16:09:37] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:09:37] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:03] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '371';)
[19/03/2013 16:10:10] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '371';)
[19/03/2013 16:10:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:39] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
[19/03/2013 16:10:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "player_id" FROM "marriage_system" WHERE "player_id" = '369';)
[19/03/2013 16:10:55] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such table: marriage_system (SELECT "partner" FROM "marriage_system" WHERE "partner" = '369';)
Click to expand...

"no such table: marriage_system"

u need execute this query in your db:

Code: 
CREATE TABLE marriage_system (
                        id                                        INTEGER NOT NULL,
                        player_id   INTEGER NOT NULL,
                        partner   VARCHAR( 255 )  NOT NULL,
                        marriage_date INTEGER NOT NULL,
                        PRIMARY KEY ( id )
);
 
followed guide 100% and all im getting is this

[10/09/2013 05:34:54] [Error - LuaScriptInterface::loadFile] data/npc/scripts/marriagesystem.lua:6: function arguments expected near ':'
[10/09/2013 05:34:54] [Warning - NpcScript::NpcScript] Cannot load script: data/npc/scripts/marriagesystem.lua
[10/09/2013 05:34:54] data/npc/scripts/marriagesystem.lua:6: function arguments expected near ':'

any ideas? 0.3.6 im running.
 
It's because of the missing Lua tags, it makes : o into a :eek: smiley.
Code: 
function onCreatureAppear(cid)     npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)     npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)     npcHandler:onCreatureSay(cid, type, msg) end
function onThink()     npcHandler:onThink() end
 
Limos said:
It's because of the missing Lua tags, it makes : o into a :eek: smiley.
Code: 
function onCreatureAppear(cid)     npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)     npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)     npcHandler:onCreatureSay(cid, type, msg) end
function onThink()     npcHandler:onThink() end
Click to expand...
Thanks, fixed my problem x'D

Edit: Now I'm getting player not found error :p
 
Last edited:
I get this error when I try to "proceed" with the wedding,

[Error -Npc interface]
data/npc/marriagesystem.lua:eek:nCreatureSay
Description:
[string "marry_config = {..."]:53: attempt to call field 'executeQuery' <a nil value
stack traceback:
[string "marry_config = {..."]:53 in function 'doMarry'
data/npc/scripts/marriagesystem.lua;64; in function 'callback'
data/npc/lib/npcsystem/npchandler.lua;383; in function 'onCreatureSay'
data/npc/scripts/marriagesystem.lua:8: in function <data/npc/scripts/marriagesystem.lua:8>
 
Code: 
[20:25:05.835] [Error - NpcScript Interface]
[20:25:05.836] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.838] Description:
[20:25:05.839] (LuaInterface::luaDoCreatureSay) Creature not found

[20:25:05.842] [Error - NpcScript Interface]
[20:25:05.844] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.846] Description:
[20:25:05.847] (LuaInterface::luaGetPlayerNameByGUID) Player not found

[20:25:05.850] [Error - NpcScript Interface]
[20:25:05.851] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.853] Description:
[20:25:05.854] (LuaInterface::luaGetThingPosition) Thing not found

What's wrong?
 
psychosisneamia said:
I get this error when I try to "proceed" with the wedding,

[Error -Npc interface]
data/npc/marriagesystem.lua:eek:nCreatureSay
Description:
[string "marry_config = {..."]:53: attempt to call field 'executeQuery' <a nil value
stack traceback:
[string "marry_config = {..."]:53 in function 'doMarry'
data/npc/scripts/marriagesystem.lua;64; in function 'callback'
data/npc/lib/npcsystem/npchandler.lua;383; in function 'onCreatureSay'
data/npc/scripts/marriagesystem.lua:8: in function <data/npc/scripts/marriagesystem.lua:8>
Click to expand...
Change db.executeQuery to db.query or add this in compat.lua/global.lua.
Code: 
db.executeQuery = db.query

ligus said:
Code: 
[20:25:05.835] [Error - NpcScript Interface]
[20:25:05.836] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.838] Description:
[20:25:05.839] (LuaInterface::luaDoCreatureSay) Creature not found

[20:25:05.842] [Error - NpcScript Interface]
[20:25:05.844] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.846] Description:
[20:25:05.847] (LuaInterface::luaGetPlayerNameByGUID) Player not found

[20:25:05.850] [Error - NpcScript Interface]
[20:25:05.851] data/npc/scripts/Lynda.lua:onCreatureSay
[20:25:05.853] Description:
[20:25:05.854] (LuaInterface::luaGetThingPosition) Thing not found

What's wrong?
Click to expand...
Under
Code: 
for i = 1, #players do
Add
Code: 
[i]
After players till the "end" under that.
So it will be:
Code: 
players[i]
 
Thanks!
Do you know how can I set upper letter to the first letter in every word?

When I am trying:
Code: 
"..string.upper(msg,1).."
it sets all the letters upper :/
 
Hmm.. and where is the msg?
for example:
Code: 
npcHandler:say(""..string.upper(msg).." is offline or does not exist.", cid)

I do not understand where I should put the text :p
 
[01/01/2015 17:51:04] [Error - LuaScriptInterface::loadFile] data/npc/scripts/marriagesystem.lua:6: function arguments expected near ':'
[01/01/2015 17:51:04] [Warning - Np
cScript::NpcScript] Cannot load script: data/npc/scripts/marriagesystem.lua
[01/01/2015 17:51:04] data/npc/scripts/marriagesystem.lua:6: function arguments expected near ':'
 
Limos said:
It's because of the missing Lua tags, it makes : o into a :eek: smiley.
Code: 
function onCreatureAppear(cid)     npcHandler:onCreatureAppear(cid) end
function onCreatureDisappear(cid)     npcHandler:onCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg)     npcHandler:onCreatureSay(cid, type, msg) end
function onThink()     npcHandler:onThink() end
Click to expand...
 
Hmm I can't find that in the script, and when i search for :eek:n nothing appears any ideas?

EDIT : found out the problem mine was showing up as : eek n i fixed it and it works perfectly thanks :D
 

Similar threads

E
  • Question
TFS 0.X 0.4 Recovery Exp only recovers levels from level 1 to 100, it does not recover levels from level 717217, I want it to recover levels 1 until 717217
Replies
1
Views
158
Enderlop
E
Shoorkill
  • Question
[TFS 1.5]reset level, life and mana, when acquiring vocation evolution
Replies
2
Views
630
Mateus Robeerto
Mateus Robeerto
V
  • Question
npc travel
Replies
2
Views
305
vitorelias1
V
J
  • Solved
Grizzly Adams tfs1.5 problem
Replies
10
Views
688
jareczekjsp
J
F
  • Question
script npc modification
Replies
5
Views
351
Mateus Robeerto
Mateus Robeerto
Back
Top