Help Lapis Shaiya

[ernestojose]

Elitepvp Hello, I have a problem with my server shaiya no problem without a doubt or something, I want to create is qe lapis with the name of my server and then taken 3lapis who are called one?? 150,?? 143,? ? 190, then I want to convert these into a pencil lapis edited by me open the ShStudio and then I edit the sql db and imported it and created a wing of items so you can see the change and restart the server, but when entering I do the same think goes lapis qe qe this encryptado or something someone tells me how I can create or edit a lapis E also happens to me I can not edit NPC names are some qe qe are called??? ???? Someone help me???

///////////////////////////////////////////////////////////////////////////////////


Hola elitepvp, Tengo un problema con mi servidor de shaiya no problema si no una duda o algo asi, Es qe quiero crear un lapis con el nombre de mi servidor entonces e tomado 3lapis que son llamados uno ??150, ??143, ??190, Entonces quiero convertir esos lapis en unos lapices editados por mi abro el ShStudio y los edito entonces creo el sql y lo importo ala db y creo un parte de items para que se vea el cambio y reinicio servidor, Pero al momento de entrar hago el lapis y sale igual creo qe es qe esta encryptado o algo asi alguien me dice como puedo crear o editar un lapis E igualmente me pasa con los NPC No puedo editar sus nombres qe hay unos qe son llamados ??? ???? Alguien me ayuda???

[TeddyBear94]

okay u got 2 options if u rly want to use sh studio then pls just edit already existing lapis which u dont need. creating new stuff via sh studio is the worst ever and will always f°°k u up. other way use python to trans for the sdata into csv files and then u are able to add new items easily after that just reformate them with python and u are good to go.

[castor4878]

Originally Posted by TeddyBear94

creating new stuff via sh studio is the worst ever and will always f°°k u up

LOL

Originally Posted by ernestojose

Someone help me???

Your first steps are correct: to create a new lapis, you must select one of the not-defined lapis.
So the line "?? 150" or "?? 143" or "?? 190".

If I do the same on the current US data set, I see:



The lapis n° 254 is currently, not defined, let's use this record, so double-clikc the line, it opens the editor:



Define your lapis as according your needs, wishs, etc, and click "Ok", the list of lapis is updated to be:



Save the file (you didn't ask which one, so I assume you known that lapis are defined in the Item/Item.SData file).

The tool saves the file *ciphered* (encrypted); because it is supposed to be encrypted, and because it was ciphered when opened.

So simply repack it into your data.saf file (using the "Shaiya Data File Tool.exe" soft for instance - and saying it to NOT encrypt the file, it is ALREADY ciphered).

During saving, a SQL script is generated to let you update your database, assuming your server repository is defined as "s:\srvr" in the Settings dialog:



the script is saved under "s:\srvr\item.sql" or "s:\srvr\scripts\item.sql" if the sub-directory "scripts\" exists.

That script can be reviewed to check that the item 30-254 is indeed new and defined as expected:



You now use Microsoft SQL Server Management Studio to run that script.
You can also choose to copy / paste the line with your lapis and update only that record, easy way: delete the item, insert its new definition:



So far, so good, and about 4 mn of your time spent.

Start the server, start the client game, and request a lapis 254 ("/getitem 30 254") you obtained what's expected.



And regarding the f**cking thing, I didn't get the point sorry.

[alkin123]

What if all the non-defined lapis are used and there no more free to change like this? You cant make any new ones?

[castor4878]

our client / srvr as well as the 6.x ones of AE use the bank 30 for lapis and bank 95 for lapisia; the use of any other banks will prevent correct handling of the items as a lapis (or lapisia).

now the question of booked banks will appears soon, the US client has only 9 slots left.
but if AE add a new bank for lapis, it will require time & work for us to change our srvr to support that.
meantime, there are toons of fully useless lapis (useless for +/- 95% of the p-srvr) including at least the dual (lvl 1), the stats lvl 1 to 4 and others.
so far the easy way is to redefine them.

[TeddyBear94]

Originally Posted by castor4878

our client / srvr as well as the 6.x ones of AE use the bank 30 for lapis and bank 95 for lapisia; the use of any other banks will prevent correct handling of the items as a lapis (or lapisia).

now the question of booked banks will appears soon, the US client has only 9 slots left.
but if AE add a new bank for lapis, it will require time & work for us to change our srvr to support that.
meantime, there are toons of fully useless lapis (useless for +/- 95% of the p-srvr) including at least the dual (lvl 1), the stats lvl 1 to 4 and others.
so far the easy way is to redefine them.

thats exactly what i mean with create new lapis <.< i should have added that i meant totaly new with another bank. and that will f**k u up if u try that....