Unique Scrolls and _Memo Table
I am facing the issues, that I cannot spawn any kind of scroll based unique/monster and as well the _Memo table doesn't work, too.
I am well experienced due adding stuff, creating custom things, etc.
but somehow, since the beginning of the clean vSRO 1.188 files, I am freaking not able to spawn the Automob (which is character and item sided activated!) or any kind of fortress unique via scroll.
Automob:
The item is at the shop, people can buy it, but upon usage, nothing happens. No "invalid target" msg nor anything else.
I can spawn the automob manually.
Same goes for unique scrolls at the fortress clerk.
I can forge the scrolls, can hold them at the inventory, but same crap here. I can manually spawn Tai Sui and few others of all. Most of the others won't work, no idea why.
_Memo Table:
Recording chats isn't working at all.
No matter how I modify the _Memo_Add procedure, I won't get any kind of progression saved at the _Memo table.
Manually executed:
exec _Memo_Add 'TargetPlayer','SenderPlayer','Message','99'
It will say, successfully executed, but still, I won't see any kind of change at the _Memo table.
Does anyone know how to fix these both issues?
Do I must make a trigger for this scroll-monster based crap?
Is the Memo stuff related to something else than database? E.g. ODBC?
Re: Unique Scrolls and _Memo Table
Re: Unique Scrolls and _Memo Table
Re: Unique Scrolls and _Memo Table
Re: Unique Scrolls and _Memo Table
Quote:
exec _Memo_Add 'TargetPlayer','SenderPlayer','Message','99'
Does the SenderPlayer and target player characters is exist?
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
OutOfMemory
Does the SenderPlayer and target player characters is exist?
It is working, if I add 2 existing characters with test msg and count, but it won't continue to progress and record.
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
blapanda
It is working, if I add 2 existing characters with test msg and count, but it won't continue to progress and record.
who told you that? parameters must have a real character names to record at _Memo
I also tested it for you and when executed your query didn't record anything, just add a real character names.
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
OutOfMemory
who told you that? parameters must have a real character names to record at _Memo
I also tested it for you and when executed your query didn't record anything, just add a real character names.
As already said, there will be an entrance to the table, but that's it.
Nothing else will happen serversided.
After using
Code:
USE SRO_VT_SHARD
exec _Memo_Add '[GM]Homie','[GM]Buddha','Test','1'
this will show up at the _Memo table:
| 1 |
8864 |
[GM]Buddha |
Test |
2014-05-07 18:41:00 |
0 |
1927 |
... any ideas? There won't be any other kind of recordings.
Re: Unique Scrolls and _Memo Table
try with normal names, not [GM]´s
as far i know, only that table is edited/changed
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
Caosfox
try with normal names, not [GM]´s
as far i know, only that table is edited/changed
Well, that won't be impossible, since I have few players playing on my server, but their messaging isn't saved either.
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
blapanda
Well, that won't be impossible, since I have few players playing on my server, but their messaging isn't saved either.
Are you using default StoredProcedure [dbo].[_Memo_Add] ?
Are you using any edited database?
try to rest StoredProcedure [dbo].[_Memo_Add] to default
Re: Unique Scrolls and _Memo Table
Quote:
Originally Posted by
OutOfMemory
Are you using default StoredProcedure [dbo].[_Memo_Add] ?
Are you using any edited database?
try to rest StoredProcedure [dbo].[_Memo_Add] to default
It is the default one (as far as I can say), since I didn't change anything on the procedure.
Code:
USE [SRO_VT_SHARD]GO
/****** Object: StoredProcedure [dbo].[_Memo_Add] Script Date: 07.05.2014 21:38:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
------------------------------------------------
-- # PROCEDURE _Memo_Add ¼??�
------------------------------------------------
ALTER procedure [dbo].[_Memo_Add]
--CE?? ??¶?¹???
@TargetCharName varchar(64),
@SenderCharName varchar(64),
@message varchar(300),
--?I�? ??¶?¹???
@Max_MEMO_COUNT int
as
begin transaction
declare @Target_charid int
set @Target_charid = (select CharID from _Char where CharName16 = @TargetCharName)
if (@@error <> 0 or @@rowcount = 0 )
begin
--��·�¾?�A ¾?¾�~
rollback transaction
return -1
end
declare @memo_count int
select @memo_count = count(*) from _Memo where CharID = @Target_charid
/*if( @memo_count >= @Max_MEMO_COUNT )
begin
-- AE??COA? ²E??³�~
rollback transaction
return -2
end*/
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- EUROPE_SYSTEM (??AIE�)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @ReFObjID int
select @ReFObjID = RefObjID from _Char with (nolock) where CharName16 = @SenderCharName
if (@@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
declare @RecordDate smalldatetime
set @RecordDate = GetDate()
insert _Memo (CharID, FromCharName,Message,Date,Status,RefObjID) values( @Target_charid, @SenderCharName, @message, @RecordDate, 0, @ReFObjID )
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
--E���!!
return -3
end
commit transaction
return @@identity
PS the database was a clean one. Not modified with any special thing.
Re: Unique Scrolls and _Memo Table
#Push
I need to solve this issue.
Re: Unique Scrolls and _Memo Table
Re: Unique Scrolls and _Memo Table
#Push .
I still cannot use the automob (Protector) and fortress uniques.
_Memo fixed.
Re: Unique Scrolls and _Memo Table