Register for your free account! | Forgot your password?

You last visited: Today at 00:50

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #1
 
StayAlive-Online's Avatar
 
elite*gold: 0
Join Date: Mar 2013
Posts: 174
Received Thanks: 29
Smile 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 ..
StayAlive-Online is offline  
Thanks
2 Users
Old 10/10/2013, 00:55   #2
Chat Killer In Duty


 
PortalDark's Avatar
 
elite*gold: 5
Join Date: May 2008
Posts: 16,307
Received Thanks: 6,469
#Approved
PortalDark is offline  
Old 10/10/2013, 11:34   #3
 
elite*gold: 0
Join Date: Oct 2013
Posts: 26
Received Thanks: 3
Thanks
Epic* is offline  
Old 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 ...
loloelgen is offline  
Old 10/10/2013, 14:52   #5
 
Neko*'s Avatar
 
elite*gold: 0
Join Date: Apr 2012
Posts: 338
Received Thanks: 180
Quote:
Originally Posted by loloelgen View Post
Can Give Us Guild how to edit that , cuz i got Error . Thanks ...
Give you guild how to edit ? [[facepalm]] !
Neko* is offline  
Thanks
4 Users
Old 10/10/2013, 15:34   #6
 
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
Quote:
Originally Posted by Neko* View Post
Give you guild how to edit ? !
TheB1QB0SS is offline  
Old 10/10/2013, 18:47   #7
 
elite*gold: 0
Join Date: Aug 2013
Posts: 27
Received Thanks: 15
Quote:
Originally Posted by Neko* View Post
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 View Post
it's not his main language mr.fullenglish , Since when is ur english perfect dumbass ?

rly hating ya especially with ur idiotic attitudes
Cryolite_ is offline  
Thanks
4 Users
Old 10/10/2013, 22:16   #8
 
elite*gold: 19
Join Date: Jul 2013
Posts: 223
Received Thanks: 290
Quote:
Originally Posted by Cryolite_ View Post
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?
Royalblades is offline  
Thanks
1 User
Old 10/11/2013, 00:23   #9
 
elite*gold: 0
Join Date: Aug 2013
Posts: 27
Received Thanks: 15
Smile

Quote:
Originally Posted by Royalblades View Post
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
Cryolite_ is offline  
Thanks
1 User
Old 10/11/2013, 13:17   #10
 
Twistin**'s Avatar
 
elite*gold: 0
Join Date: Jun 2013
Posts: 551
Received Thanks: 108
Quote:
Originally Posted by Neko* View Post
Give you guild how to edit ? [[facepalm]] !
you made my day
Twistin** is offline  
Old 10/11/2013, 23:07   #11
 
eminem5's Avatar
 
elite*gold: 0
Join Date: Dec 2011
Posts: 651
Received Thanks: 266
Quote:
Originally Posted by Cryolite_ View Post
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 !!
eminem5 is offline  
Old 10/20/2013, 22:39   #12
 
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
Quote:
Originally Posted by eminem5 View Post
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
TheB1QB0SS is offline  
Old 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 View Post
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.
Anonymous-6723 is offline  
Thanks
1 User
Old 10/21/2013, 12:57   #14
 
elite*gold: 0
Join Date: Jul 2013
Posts: 454
Received Thanks: 55
Quote:
Originally Posted by Zed* View Post
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
TheB1QB0SS is offline  
Old 10/23/2013, 11:51   #15
 
elite*gold: 0
Join Date: Oct 2013
Posts: 256
Received Thanks: 33
not work with me fix pls
marlow_online is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.