[Release] SQL script to export items for python

[player1up]

This is for those of us that can navigate SQL faster than the tools used to modify the client files.

What it does:
Returns columns in the correct order for use in creating the item.sdata file via python scripts WITH calculations* from the DB to the client.

Prerequisites:
You must add the ItemDesc,Type2,and Type3 columns to your items table
and import the values from your client at least one time to have a complete compiled list of items.

Why would you do this or need this?
What you will have at the end of that is all of the columns that the DB needs and all of the columns that the client needs in one place and it makes porting changes easier back and forth, at least it does for me, and your DB and client will match. It also allows you to make changes to the Item descriptions very easy in SQL, for example:

update items set ItemDesc='this item is new and made for blah blah blah' where itemid=1243456

. It's also WAY easier to do blanket modifications to items like:

update items set buy=buy-1000

If this isn't making sense, then this isn't likely something you'll use, sorry.

 Spoiler

select ItemName, case
when items.ItemDesc is NULL then ''
else ItemDesc
end
as ItemDesc,
[Type],TypeID, ItemModel,ItemIcon ,Reqlevel,Country,AttackFighter,
Defensefighter, Patrolrogue, Shootrogue, Attackmage, Defensemage,Grow,Type2,Type3,
ReqStr, ReqDex, ReqRec, ReqInt, ReqWis,
case
when items.reqluc<0 then items.reqluc+65536
else reqluc
end as Reqluc,
ReqVg, ReqOg, ReqIg,
case
when items.[Range]>255
then [Range]-256
else [Range]
end
as [Range], AttackTime,
Attrib, Special, Slot, Quality, Effect1, Effect2, Effect3, Effect4,
ConstHP ,ConstSP, ConstMP, ConstStr, ConstDex, ConstRec, ConstInt, ConstWis,
ConstLuc, Speed, [Exp], Buy, Sell, Grade, [Drop], [Server], [Count]
from items
order by rowid

One of the main reasons for doing this for me was to be able to merge EP6 items with items that already exist, this was a little tricky as the client doesn't use ItemID and I didn't want to overwrite what I already have.

Now for those of you that don't want to add the columns to your items table, the below script will work with your current items table ( albeit with place holders for the missing columns ) BUT you will have to copy the columns out individually to paste into your item.complete.csv , just make sure the number of rows is correct, or your sdata is hosed,

 Spoiler

select ItemName, 'Missing data' as ItemDesc,
[Type],TypeID, ItemModel,ItemIcon ,Reqlevel,Country,AttackFighter,
Defensefighter, Patrolrogue, Shootrogue, Attackmage, Defensemage,Grow,
'Missing data' as Type2,'Missing data' as Type3,
ReqStr, ReqDex, ReqRec, ReqInt, ReqWis,
case
when items.reqluc<0 then items.reqluc+65536
else reqluc
end as Reqluc,
ReqVg, ReqOg, ReqIg,
case
when items.[Range]>255
then [Range]-256
else [Range]
end
as [Range], AttackTime,
Attrib, Special, Slot, Quality, Effect1, Effect2, Effect3, Effect4,
ConstHP ,ConstSP, ConstMP, ConstStr, ConstDex, ConstRec, ConstInt, ConstWis,
ConstLuc, Speed, [Exp], Buy, Sell, Grade, [Drop], [Server], [Count]
from items
order by rowid

* calculations are needed for Reqluc ( enchants ) as the DB has negative values for enchant items and client needs positive values. They are also needed for [Range] as this column for some items relates to a skill ID but the client cannot have a value greater than 255.

Anyway, Happy Shaiya-ing

[xavabaza95]

Eu preciso de um program, QUE, importe os itens de uma epic elevada por exemplo:
importar itens da Epic 6 para a epic 4.5, In My serverPrivate.
ou seja pegar itens da Epic 6 e trazer para meu servidor privado que é epic 4.5.
dESDEJA Muito Obrigado.
Meu E-Mail>
PRECIZO DE RESPOSTAS URGENTES! ACREDITO MUITO NA CAPACIDADE DE RESOLVER PROBLEMAS DE SERVERPRIVATE DESSE SITE.