|
You last visited: Today at 00:50
Advertisement
New Upgrade System Vsro S4A
Discussion on New Upgrade System Vsro S4A within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
10/08/2013, 02:20
|
#1
|
elite*gold: 0
Join Date: Mar 2013
Posts: 174
Received Thanks: 29
|
New Upgrade System Vsro S4A
Hello
Here is Upgrade System Scroll ^^,If you Do any Weapon Or Acc Or Armor +7 or more you can get the Next Degree PLUS 0 Have Fun ........
This thread Put In ******** Release Section But Not Work
but now i maw some change in code to work and i test it in my server working fine
this is my first tread in elite i hoppe help mant ppl to make good servers with good idea
in _addtimedjob
Code:
if (@JobID = '[COLOR="Red"]Skill ID[/COLOR]')
begin
DECLARE @OldItemCodeName varchar(128)
set @OldItemCodeName= 'ITEM_EU_TSWORD_14_B_RARE'
DECLARE @OldItemPlus int
set @OldItemPlus =7
DECLARE @NewItemCodeName varchar(128)
set @NewItemCodeName = ('ITEM_EU_TSWORD_15_A_RARE')
DECLARE @NewItemPlus int
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from _Inventory as inv inner join _Items as itm on inv.ItemID = itm.ID64 inner join _RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update _Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
return -3
end
thank you ..
|
|
|
10/10/2013, 00:55
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,307
Received Thanks: 6,469
|
#Approved
|
|
|
10/10/2013, 11:34
|
#3
|
elite*gold: 0
Join Date: Oct 2013
Posts: 26
Received Thanks: 3
|
Thanks
|
|
|
10/10/2013, 12:57
|
#4
|
elite*gold: 0
Join Date: Sep 2011
Posts: 18
Received Thanks: 1
|
Can Give Us Guide how to edit that , cuz i got Error . Thanks ...
|
|
|
10/10/2013, 14:52
|
#5
|
elite*gold: 0
Join Date: Apr 2012
Posts: 338
Received Thanks: 180
|
Quote:
Originally Posted by loloelgen
Can Give Us Guild how to edit that , cuz i got Error . Thanks ...
|
Give you guild how to edit ? [[facepalm]] !
|
|
|
10/10/2013, 15:34
|
#6
|
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
|
Quote:
Originally Posted by Neko*
Give you guild how to edit ? !
|
|
|
|
10/10/2013, 18:47
|
#7
|
elite*gold: 0
Join Date: Aug 2013
Posts: 27
Received Thanks: 15
|
Quote:
Originally Posted by Neko*
Give you guild how to edit ? [[facepalm]] !
|
whatever he wrote , u don't have to embarrass him also it might not his main language so you have to shut the **** up also get the **** out of here
Quote:
Originally Posted by TheB1QB0SS
|
it's not his main language mr.fullenglish , Since when is ur english perfect dumbass ?
rly hating ya especially with ur idiotic attitudes
|
|
|
10/10/2013, 22:16
|
#8
|
elite*gold: 19
Join Date: Jul 2013
Posts: 223
Received Thanks: 290
|
Quote:
Originally Posted by Cryolite_
whatever he wrote , u don't have to embarrass him also it might not his main language so you have to shut the **** up also get the **** out of here
it's not his main language mr.fullenglish , Since when is ur english perfect dumbass ?
rly hating ya especially with ur idiotic attitudes
|
I don't wanna defend BigBoss or anything, however that comment from Mr. NoŻNGLIS was funny as **** and deserves to be laughed about in every manner. This is a public forum and by in-official definition a place to bully people, laugh at people and generally make fun of others. It happens in every forum and to be honest, THIS is Elitepvpers. The community is pretty awesome at being greedy/selfish/bullying/threatening/harassing etc.
Just go with the flow and don't mind others business (which I am kind of doing myself tho).
Its fun to laugh at dumbfucks that dont even know what they said themselves.
PS: You'r the one going against the rules by insulting Biggy aren't you?
|
|
|
10/11/2013, 00:23
|
#9
|
elite*gold: 0
Join Date: Aug 2013
Posts: 27
Received Thanks: 15
|
Quote:
Originally Posted by Royalblades
I don't wanna defend BigBoss or anything, however that comment from Mr. NoŻNGLIS was funny as **** and deserves to be laughed about in every manner. This is a public forum and by in-official definition a place to bully people, laugh at people and generally make fun of others. It happens in every forum and to be honest, THIS is Elitepvpers. The community is pretty awesome at being greedy/selfish/bullying/threatening/harassing etc.
Just go with the flow and don't mind others business (which I am kind of doing myself tho).
Its fun to laugh at dumbfucks that dont even know what they said themselves.
PS: You'r the one going against the rules by insulting Biggy aren't you?
|
idc , i just wanted to let 'em don't embarrass him etc.. whatever he wrote guild/guide , he just wanted anyone of them give him an advise to let his exploits work as well nothin more
|
|
|
10/11/2013, 13:17
|
#10
|
elite*gold: 0
Join Date: Jun 2013
Posts: 551
Received Thanks: 108
|
Quote:
Originally Posted by Neko*
Give you guild how to edit ? [[facepalm]] !
|
you made my day
|
|
|
10/11/2013, 23:07
|
#11
|
elite*gold: 0
Join Date: Dec 2011
Posts: 651
Received Thanks: 266
|
Quote:
Originally Posted by Cryolite_
idc , i just wanted to let 'em don't embarrass him etc.. whatever he wrote guild/guide , he just wanted anyone of them give him an advise to let his exploits work as well nothin more
|
dafuq ?! he embarrassed himself. If he cannot write in English, he should only read to avoid the ridicule of others , **** for your misunderstanding and bias !!
|
|
|
10/20/2013, 22:39
|
#12
|
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
|
Quote:
Originally Posted by eminem5
dafuq ?! he embarrassed himself. If he cannot write in English, he should only read to avoid the ridicule of others , **** for your misunderstanding and bias !!
|
i Can Write In
Turkish , Arabic
And ALot Of Times i said My English So Bad
let him cry
|
|
|
10/21/2013, 04:55
|
#13
|
elite*gold: 0
Join Date: May 2013
Posts: 1,447
Received Thanks: 1,044
|
Quote:
Originally Posted by loloelgen
Can Give Us Guide how to edit that , cuz i got Error . Thanks ...
|
Keep up the english. ^^
SRO_VT_SHARD.dbo._AddTimedJob (It's a stored procedure.)
Copy the released txt in the first post and paste it under the first "as" you see after the variables. Create a scroll (like name changer/pk clear/etc) but instead of the skill that is in the guide for name changer/pk clear/etc create it for this one. JobID = SkillID = _RefSkill.ID
That's pretty much all you need to know about adding it.
|
|
|
10/21/2013, 12:57
|
#14
|
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
|
Quote:
Originally Posted by Zed*
Keep up the english. ^^
SRO_VT_SHARD.dbo._AddTimedJob (It's a stored procedure.)
Copy the released txt in the first post and paste it under the first "as" you see after the variables. Create a scroll (like name changer/pk clear/etc) but instead of the skill that is in the guide for name changer/pk clear/etc create it for this one. JobID = SkillID = _RefSkill.ID
That's pretty much all you need to know about adding it.
|
So what about Auto Equipment System ?
Not working
Accept My Request On Skype
|
|
|
10/23/2013, 11:51
|
#15
|
elite*gold: 0
Join Date: Oct 2013
Posts: 256
Received Thanks: 33
|
not work with me fix pls
|
|
|
|
|
Similar Threads
|
Vsro Weapon Upgrade System
02/16/2014 - SRO PServer Guides & Releases - 51 Replies
Well this is the 2nd version = Non Beta :)
Installing
Open your SHARD DB and Goto _Chest
then add new column called (Type)
http://img846.imageshack.us/img846/3636/17351573. png
http://img832.imageshack.us/img832/4476/15631955. png
http://img211.imageshack.us/img211/3139/38677783. png
|
Vsro Weapon Upgrade System (query used to do )
09/05/2012 - SRO Private Server - 1 Replies
Declare
@maxserial BIgINT = (select MAX(serial64)from _Items)+1,
@RefItemID BIGINT,
@UpgradeItemCodeName VARCHAR (70),
@Data BigInt,
@maxID64 BIgINT = (select MAX(ID64)from _Items)+1,
@Optlevel INT ,
@Check_Correct VARCHAR (40)
IF NOT EXISTS (select UserJID From _Chest where UserJID IN (select UserJID from _User where CharID IN (select CharID from _Memo where Message like '%Upgrade%My%SWORD%')))
|
Vsro Weapon Upgrade System !
09/03/2012 - SRO Private Server - 40 Replies
i made a little trick which depends on the db
i was able to create main tool which it allow you to upgrade your weapons inside vsro !
ofc its not like ISRO !
well let me explain more
if a player have D11 weapon and its FB +7 and he wish to get D12 weapon clean ..
if he want to upgrade his bow he will send a message for him self (upgrade my bow) then he will teleport some where and pom ! he will find his new bow and the old one is gone !
|
All times are GMT +2. The time now is 00:50.
|
|