How to add items with options to your new EP8 server- the easy way!

[mhenri2200]

This guide is intended for the people who don't know how to add items to your newly created EP8 server or think that calculating them manually is too hard (getting item option codes etc.).

There is actually a very easy way - using Balq's Gm tool to generate the ItemID and OptionID.

What you need for this guide: Java and MS SQL Server 2008 R2 or 2012 with working cabal SQL databases.
You can download Java from here: Download Free Java Software.

1) First, dowload this CabalToolsBalq.rar or Multiupload.nl - upload your files to multiple file hosting sites!.

^(source: http://forum.ragezone.com/f451/someo...-tools-906959/)


2) Unpack the rar file and open CabalTools.jar.
After opening it, this is the window you should get:




3) Don't enter any kind of information - just ignore it because you are not going to use it to add items (just the stuff you need - itemID's and optionID's). Besides, as far as I know this tool isn't compatible with the current EP8 SQL database (only EP2). As the picture below shows, go to Tools --> Item or with a shortcut Alt+I.




4) Now just type any kind of item name to the box on the right - "Item ID" and start customizing your gear. You can add upto 4 slots and you can upgrade an item upto +7 (YOU HAVE TO MANUALLY UPGARADE FROM +7 to +15 since EP2 didn't support +15). Also you can choose craft options, if you like.

Let's, for example try to add a SIGMetal Orb and add options to it. Let's make it of Outrageous SIGMetal Orb +6 (magicskill amp +7%) with 2 slots - each slot has Critical Damage.
It looks something like this:


From this, we use the ItemKind (=ITEMID) and Option (=OPTIONS).

5) Now when that's done, let's open MS SQL Server Management Studio.

The query you need to Execute on CabalCash (I'll show it in 6. furthermore):

exec up_AddMyCashItemByItem 'USERNUM','0','1','ITEMID','OPTIONS','DURATION'

-USERNUM - this is the number of your account (I use 3 in my case). You can look it up from MS SQL Server Management Studio, if you go to Databases --> CabalCash --> Tables --> dbo.CashAccount.
-0 - leave it AS IT IS.
-1 - This is the ServerIdx. This is usually 1.. But it may not be. You can make it sure by having a look at /etc/cabal/WorldSvr_01_01.ini in CentOS.
-ITEMID - Quite self-explanatory, this is the ID of the item you take from the Preview area in Balq's tools.
-OPTIONS - also self-explanatory, but just in case, this is the option ID you also take from the Preview area of Balq's tools.
-DURATION - put 31 to make the item permanent..


6) Now just click New Query from the upper left corner and replace the info you got from Balq's tools.

For example, lets try to add the SIGMetal Orb I did earlier.
Let's execute this:

PS! Make sure that before you press Execute or shortcut key F5, you select the right database from the upper left corner. YOU HAVE TO change it to CabalCash, otherwise it won't add the desired item to your account (if you don't select CabalCash, SQLMS will just give you an error).

exec up_AddMyCashItemByItem '3','0','1','50765','536880345','31'

7)After executing the query, let's open cabal and see, if the item came to my account.

In my case, it did:





As for items that aren't in Balq's tools (for example Ring of Luck +3), you can find the ITEMID's from http://forum.ragezone.com/f451/add-i...4/#post7460138.

And.. as for adding +8 to +15 items, go here: http://forum.ragezone.com/f460/addin...-items-906391/. IF YOU WANT to upgrade items manually ingame, just execute this query on CabalCash (this adds Percet Core (Highest) x15 to your account which is needed to upgrade from +0 to +15):

exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'
exec up_AddMyCashItemByItem '1','0','1','632','0','31'

Well, I hope some of you found this tutorial useful/helpful.
Be sure to hit LIKE, if you did! :-)


Best wishes,
Henri

[MentaL]

[Stricted]

 just upgraded them to +15 manually with upgrade cores either from +0 or from +7. I know it's a pain in the ass.. especially with the stock upgrade rates, but I changed the rates in Core.scp, so now I have better success rates.

use perfect core with 100 %success rate :D

[mhenri2200]

 just upgraded them to +15 manually with upgrade cores either from +0 or from +7. I know it's a pain in the ass.. especially with the stock upgrade rates, but I changed the rates in Core.scp, so now I have better success rates.

use perfect core with 100 %success rate :D

Yes, I did that, but at +8 or so it didn't work anymore.. at least for me. But yes, that's possible too.
Did it in the Ep2 days too.

I used this (didn't work):

<msg id="item3415" cont="Perfect Core +14 (Highest)" />

EDIT:
Yeah, this actually works:

<msg id="item632" cont="Perfect Core (Highest)" />

[bsitmark]

and also 122880 = +15 4096 = bind + itemid, like <msg id="item145" cont="Forcium Suit (BL)" /> just add the 4096 for bind and 122880 for +15

ex
itemid = 127121 (Forcium suit+15 acc bind)
this what i use now thanks for sharing the tools

[jaguar666]

The easiest way to upgrade items from +7 to +15 is to use a Safeguard Kit (Highest) in your temporary inventory for mith/drei frame grade to maintain the upgrade level (+) if upgrade failure occur.

[mhenri2200]

The easiest way to upgrade items from +7 to +15 is to use a Safeguard Kit (Highest) in your temporary inventory for mith/drei frame grade to maintain the upgrade level (+) if upgrade failure occur.

Well, if Perfect Core (Highest) [ITEMID: 632] has 100% success rate, you don't need that, unless you mess with Core.scp and change things otherwise. Tried and Mithril/Forcium, Drei Drame went to +15 like a charm with Perfect Core (Highest).

[juleki]

just get ur item code +7 and add to this 65536 in calculator and you've got id item +15, thats simple way :)

[saifa01]

Open SQL Server


repair up_AddMyCashItem to

USE [CabalCash]
GO
/****** Object:  StoredProcedure [dbo].[up_AddMyCashItem]    Script Date: 02/15/2013 19:32:13 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object:  Stored Procedure dbo.up_AddMyCashItem    Script Date: 2008-4-14 21:43:04 ******/
ALTER  PROCEDURE [dbo].[up_AddMyCashItem]   
(    
 @UserNum INT,     
 @TranNo  BIGINT,     
 @ServerIdx INT,    
 @ItemIdx INT,    
 @ItemOpt INT,    
 @DurationIdx INT,  
 @ProductType int  = 0  
)    
AS    
BEGIN    
SET NOCOUNT ON    
 DECLARE @Result INT    
 DECLARE @GoodsType INT    
  
 If @ProductType = 2 Begin  
 	Insert Into Cabal_Activation(CashlogNo,ItemIdx,UserNum)  
 	Values(@TranNo,@ItemIdx,@UserNum)  
 End  
 Else Begin
	INSERT INTO MyCashItem( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )    
	VALUES (@UserNum, @TranNo, @ServerIdx, @ItemIdx, @ItemOpt, @DurationIdx )    
 End
     
 SET @Result = 0     
 SELECT @Result as Ret    
SET NOCOUNT OFF     
END

RUN execute

[mhenri2200]

Open SQL Server


repair up_AddMyCashItem to

USE [CabalCash]
GO
/****** Object:  StoredProcedure [dbo].[up_AddMyCashItem]    Script Date: 02/15/2013 19:32:13 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO


/****** Object:  Stored Procedure dbo.up_AddMyCashItem    Script Date: 2008-4-14 21:43:04 ******/
ALTER  PROCEDURE [dbo].[up_AddMyCashItem]   
(    
 @UserNum INT,     
 @TranNo  BIGINT,     
 @ServerIdx INT,    
 @ItemIdx INT,    
 @ItemOpt INT,    
 @DurationIdx INT,  
 @ProductType int  = 0  
)    
AS    
BEGIN    
SET NOCOUNT ON    
 DECLARE @Result INT    
 DECLARE @GoodsType INT    
  
 If @ProductType = 2 Begin  
     Insert Into Cabal_Activation(CashlogNo,ItemIdx,UserNum)  
     Values(@TranNo,@ItemIdx,@UserNum)  
 End  
 Else Begin
    INSERT INTO MyCashItem( UserNum, TranNo, ServerIdx, ItemKindIdx, ItemOpt, DurationIdx )    
    VALUES (@UserNum, @TranNo, @ServerIdx, @ItemIdx, @ItemOpt, @DurationIdx )    
 End
     
 SET @Result = 0     
 SELECT @Result as Ret    
SET NOCOUNT OFF     
END

RUN execute

Well, another option. :D
Maybe the easiest, but still people will have to make them from +8 to +15 manually ingame OR using the instructions that were given above by other posters in this thread.

Soon enough, there will be better EP8 GM Tools that will satisfy lazy people (like for example this http://forum.ragezone.com/f458/divin...-tools-910327/).

At the moment, there is another tool too, but it only edits character, doesn't edit or add items yet:
http://forum.ragezone.com/f458/ep8-gm-tools-906248/.
^Also, I'm not sure but I think that this is made in MS Visual Studio..? Because I made a Notepad in Visual Studio and the installer is the same and also I'm studying C# in school at the moment. In the future, I'll study phyton, ruby, java. :D But not sure, if VB, C++ or C# is used in this tool.

[PwrDex]

yep its good but its not included special upgrade options like 28% amp in a slot and etc. but this way you can do some "simple" item!

[mhenri2200]

yep its good but its not included special upgrade options like 28% amp in a slot and etc. but this way you can do some "simple" item!

Yep. You can't make an item that has, for example 28% amp in one slot. The maximum amount is 10% per slot (if the item is not bound).

As you all probably know and as I said earlier, TDP is working on a GM/Server tools project (http://forum.ragezone.com/f458/divin...-tools-910327/). This should include all the options and stuff.

[Piebe Piebe]

sorry but i cannot find the Usernum.
I looked where you said but i said nothing.
In SQL it said all good but i go ingame and dont see nothing in cash inventory

Got it nvm Perfect post...excellent

[unborn2010]

i don't have any information in dbo.CashAccount. i can't use code to add item, sql notice success. in dbo.MyCashItem have my item but in game, nothing happens, no item for my char. idk why? pls reply. i used usernum in dbo.cabal_auth_table but same, no item

[in2ruder]

Hello Guys, the easiest way to make a item +15 is that: get the item value @ +7 and add 65536..(EX: 57564+65536 = 123100 - mithril boots(fb) +15) Is work for all wapons, armours, bikes etc. Constant value is 8192 for one lvl up. (Ex: +7 = 57564, +8 = 57564+8192 ... and so on).

[Van Kailer Zeki]

what is item kind of stain clone ?