|
You last visited: Today at 13:02
Advertisement
Largest Collection Of Queries For PSRO Development [[ Updated ]]
Discussion on Largest Collection Of Queries For PSRO Development [[ Updated ]] within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
02/16/2014, 00:02
|
#16
|
elite*gold: 0 
Join Date: Dec 2013
Posts: 795
Received Thanks: 1,093
|
Good work mate and thanks for the release.
|
|
|
|
02/16/2014, 01:58
|
#17
|
elite*gold: 0
Join Date: Feb 2014
Posts: 116
Received Thanks: 36
|
Query to change 'Stone' Success Rate.
<_- can you give me a ready one with 100% chance please? i forgot ...
|
|
|
|
|
02/16/2014, 02:11
|
#18
|
elite*gold: 41
Join Date: Oct 2012
Posts: 2,216
Received Thanks: 1,196
|
Quote:
Originally Posted by Divine Online
Query to change 'Stone' Success Rate.
<_- can you give me a ready one with 100% chance please? i forgot ...
|
PHP Code:
USE SRO_VT_SHARD
GO
UPDATE _RefObjItem
SET Param4 = 100
WHERE ID BETWEEN 4630 AND 5013
|
|
|
|
|
04/25/2014, 00:53
|
#19
|
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 384
|
You can always ask for any query you would like to make,if i have time i can always try writing it for you "When i have time" sorry for not updating them these last weeks but i hope you understand i have some school exams and will be finishing hopefully on 11 May 2014 any question or request is welcomed in comment or in a message.
Thank you.
Anti-Cosmo
|
|
|
|
|
04/25/2014, 02:14
|
#20
|
elite*gold: 0
Join Date: Dec 2013
Posts: 27
Received Thanks: 5
|
Good job.
|
|
|
|
|
05/01/2014, 01:26
|
#21
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,861
Received Thanks: 760
|
Nice queries. I am most intrested into the _Memo Limit removal.
Just the case about "_Memo" won't record any kind of conversation, neither save anything.
Do you have a hint about that one? How to activate it? Is it Module or Database related?
|
|
|
|
|
05/01/2014, 03:18
|
#22
|
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 384
|
Quote:
Originally Posted by blapanda
Nice queries. I am most intrested into the _Memo Limit removal.
Just the case about "_Memo" won't record any kind of conversation, neither save anything.
Do you have a hint about that one? How to activate it? Is it Module or Database related?
|
I promise i will look in this case right after i finish my exams atm i don't have the acess to my pc i can't help you with phone so you need to wait 10 days till i am done 
|
|
|
|
|
05/01/2014, 08:56
|
#23
|
elite*gold: 0
Join Date: Sep 2007
Posts: 250
Received Thanks: 34
|
Quote:
Originally Posted by blapanda
Nice queries. I am most intrested into the _Memo Limit removal.
Just the case about "_Memo" won't record any kind of conversation, neither save anything.
Do you have a hint about that one? How to activate it? Is it Module or Database related?
|
Its stored procedure, called _Memo_Add
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Memo_Add] Script Date: 05/01/2014 07:54:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
------------------------------------------------
-- # PROCEDURE _Memo_Add ¼ö?¤
------------------------------------------------
ALTER procedure [dbo].[_Memo_Add]
--???ä ÆĶó¹?Å?
@TargetCharName varchar(64),
@SenderCharName varchar(64),
@Message varchar(300),
--??°? ÆĶó¹?Å?
@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
--±×·±¾Ö´? ¾ø¾?~
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
-- ???ö???? ²???³×~
rollback transaction
return -2
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
-- EUROPE_SYSTEM (?Ö???£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
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
--?£°?!!
return -3
end
commit transaction
return @@identity
EDIT: Oke, i think i misunderstood you, you want to remove the limite of messages ? if it is so then check this spoiler:
(its something that i made fast, but it should work)
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Memo_Add] Script Date: 05/01/2014 07:54:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
------------------------------------------------
-- # PROCEDURE _Memo_Add ¼ö?¤
------------------------------------------------
ALTER procedure [dbo].[_Memo_Add]
--???ä ÆĶó¹?Å?
@TargetCharName varchar(64),
@SenderCharName varchar(64),
@Message varchar(300),
--??°? ÆĶó¹?Å?
@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
--±×·±¾Ö´? ¾ø¾?~
rollback transaction
return -1
end
--This part contains information about Limit of messages, if u read it then u can see that if memo count is higher then max count it will send you message like "your message box is full" (it was just an example i dont know what it will exactly tell you)
--declare @memo_count int
--select @memo_count = count(*) from _Memo where CharID = @target_charid
--if( @memo_count >= @MAX_MEMO_COUNT )
--begin
-- ???ö???? ²???³×~
--rollback transaction
--return -2
--end
--you can simple just remove those lines and you can have endless messages
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
-- EUROPE_SYSTEM (?Ö???£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @@@
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
--?£°?!!
return -3
end
commit transaction
return @@identity
|
|
|
|
|
05/01/2014, 12:16
|
#24
|
elite*gold: 0
Join Date: Mar 2013
Posts: 22
Received Thanks: 2
|
thanks
|
|
|
|
|
05/01/2014, 12:30
|
#25
|
elite*gold: 0
Join Date: May 2011
Posts: 365
Received Thanks: 384
|
Well maybe we all got you wrong if it's true that you want to remove the limit so your answer was in the first page since 3 months CheckMsg Limit Query it works
|
|
|
|
|
05/02/2014, 01:04
|
#26
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,861
Received Thanks: 760
|
Nah, I wasn't asking for help about the limit, more about getting it to work.
I cannot figure out why the issue keeps popping up all the time.
Executing the _Memo_Add procedure will result in this error:
Code:
Msg 201, Level 16, State 4, Procedure _Memo_Add, Line 0
Procedure or function '_Memo_Add' expects parameter '@TargetCharName', which was not supplied.
Any ideas? I didn't saw any thread about turning that feature on.
I want to use the feature without using chernobyl's tools, since they infested my rig with some HTML **** on each file. My kaspersky turned mad:
... that was right after using his tools.
|
|
|
|
|
05/02/2014, 08:27
|
#27
|
elite*gold: 0
Join Date: Sep 2007
Posts: 250
Received Thanks: 34
|
"Msg 201, Level 16, State 4, Procedure _Memo_Add, Line 0
Procedure or function '_Memo_Add' expects parameter '@TargetCharName', which was not supplied."
This part tells u that it can't get TargetCharname
check if everything is same as it should be :
begin transaction
declare @target_charid int
set @target_charid = (select CharID from _Char where CharName16 = @TargetCharName)
if (@@error <> 0 or @@rowcount = 0 )
begin
--±×·±¾Ö´? ¾ø¾?~
rollback transaction
return -1
end
|
|
|
|
|
05/02/2014, 12:33
|
#28
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,861
Received Thanks: 760
|
Quote:
Originally Posted by wolff66
"Msg 201, Level 16, State 4, Procedure _Memo_Add, Line 0
Procedure or function '_Memo_Add' expects parameter '@TargetCharName', which was not supplied."
This part tells u that it can't get TargetCharname
check if everything is same as it should be :
begin transaction
declare @target_charid int
set @target_charid = (select CharID from _Char where CharName16 = @TargetCharName)
if (@@error <> 0 or @@rowcount = 0 )
begin
--±×·±¾Ö´? ¾ø¾?~
rollback transaction
return -1
end
|
Yes it is the same. I have a similar problem on the procedure "paygoldFTW". I checked a database which has a working memo table, but that one's memo add procedure will result at the same parameter error, though was using shard and account of their cluster. I am out of ideas how to fix it. Could it be that it's related to something else than memo table and memo add procedure?
Edit:
Using "exec _PayGoldFTW '1000000'" will hand over to 3 guild of that owner the amount of money, in this case 1000000 gold.
So, I tried that kind of execution on the _memo_add procedure:
exec _Memo_Add 'TargetPlayer','SenderPlayer','Message','99'
But still, no addition to the _Memo table...
#Edit:
Seems like no one can help me here, again.
|
|
|
|
|
05/05/2014, 11:55
|
#29
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
most of them not work. set the item price not work.. at all.
|
|
|
|
|
05/26/2014, 05:52
|
#30
|
elite*gold: 80
Join Date: May 2014
Posts: 199
Received Thanks: 456
|
Khaled there is a query to decrease the mobs spawn?
Query to enable pill bug
PHP Code:
UPDATE _RefObjItem SET Param4='-1', Desc4_128='***' WHERE ID BETWEEN 5861 and 5864
|
|
|
|
Similar Threads
|
Star Wars: The Old Republic EA's Largest Ever Development Project
03/20/2010 - Gaming News - EN - 2 Replies
Star Wars: The Old Republic is one of the most ambitious MMORPG projects in quite some time and EA chief banker Eric Brown isn't hiding the fact that the project is EA's largest undertaking ever. Eurogamer reports that the chief banker stated in a meeting with Wedbush Morgan Securities in New York that the MMORPG is the "largest ever development project,
period, in the history of the company". That's quite a statement when compared to some of EA's other projects, including MMORPGs such as...
|
All times are GMT +1. The time now is 13:02.
|
|
![Largest Collection Of Queries For PSRO Development [[ Updated ]]](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/largest-collection-queries-psro-development-updated_ltr.gif){kind=small}
