[Collecting]Usefull SQL-Script`s

[Yunchen]

Originally Posted by Raskim2000

Almost finished Ninja, Viking and Swimsuit Deco.


Now working on Mask`s and maybe the Rank 2- Rank 6 Cloak`s.

Geil,was ist mit den Haar farben & Stille?^^

[Raskim2000]

Originally Posted by Yunchen

Geil,was ist mit den Haar farben & Stille?^^

Einträge sind alle Korrekt vorhanden, aber der Gameserver unterstützt die Funktionen nicht. ._.

Deshalb werden wir für die wohl auf den Emu warten müssen, in der Hoffnung das der das Taugt, was angepriesen wird.

#update

Ninja, Viking and Swimsuit Deco added

Epic 7.1 KTS Special Effect Deco Partial Release (im not finished, there are many more Deco items, wich has to be configured)

 Spoiler

Here was a script, now nulled.

[King of dubai]

PLZ help me how i get the belt id

[Raskim2000]

Originally Posted by King of dubai

PLZ help me how i get the belt id

Just use 1 of the Search-Scripts! **** lazy *peeeps*.

[Musta²]

Change luna chip lasting time.

 Spoiler

USE Arcadia
UPDATE dbo.SkillResource
SET state_second = Time here in sec's like 20.00
WHERE id = 6010

Credits to :Ranma014 for the id's and etc

Query made by me :P

[ismokedrow]

Raskim, I actually encourage you to take these scripts private. These Leecher noob's like Ranma want to start troubles and call out NCarbon and me, you will be next. They have already proven that even if you post in the biggest brightest font available they still ask stupid quests:

WHERE BELT ID MEN!!!!!

[Raskim2000]

Originally Posted by ismokedrow

Raskim, I actually encourage you to take these scripts private. These Leecher noob's like Ranma want to start troubles and call out NCarbon and me, you will be next. They have already proven that even if you post in the biggest brightest font available they still ask stupid quests:

WHERE BELT ID MEN!!!!!

For now i wont update this Sticky Thread, it will be like it is.
(If i would delete the Content, some other would paste our Work and claim it as their`s)

I will work chillend on the Things, that i want to fix and i will have a big grin in my face, when someone ask me how i done that.

For example this :

 Spoiler

[majetta]

some of you may already know this but here goes, instead of giving all belts 6 slots you can change the slot numbers by rank. some servers use this method but i havent seen the script posted.

just a lil modification from the old one that's floating around. with this one you can set # of belt slots by rank including the timed and dura belts.

 Spoiler

Use Arcadia
update dbo.ItemResource
set opt_var1_0 = *ENTER NUMBER OF SLOTS HERE*
where wear_type = 6 AND rank = *ENTER RANK HERE*

example: rank [B]4[/B] gets [I][U]3[/U][/I] slots
Use Arcadia
update dbo.ItemResource
set opt_var1_0 = [i][U]3[/U][/i]
where wear_type = 6 AND rank = [B]4[/B]

no more what belt id for omfghijklmnxdxd questions.

[Musta²]

Added DT staging skills without staging fix

 Spoiler

Working in other pets then i'll release a SQL files to add all of them

MuStA.

[M>M]

Originally Posted by MuStA2222

Added DT staging skills without staging fix

 Spoiler

Working in all pets then i'll release a SQL files to add all of them

MuStA.

nise work MuStA but you already release it in the server you are working on KOH ~.~

[Musta²]

Originally Posted by M>M

nise work MuStA but you already release it in the server you are working on KOH ~.~

i only released DT fix , still working on others,

thank you for understanding!

[M>M]

Originally Posted by MuStA2222

i only released DT fix , still working on others,

thank you for understanding!

i hope you fix them all

then PM to tell me how

[Dussa]

tell all

[Raskim2000]

Originally Posted by MuStA2222

Added DT staging skills without staging fix

 Spoiler

Working in other pets then i'll release a SQL files to add all of them

MuStA.

#learn_creature_all_skill magic wuhuuu.... Im working on the Pet`s that they learn the skills alone without the command. That is no fix, sry.

[Musta²]

Originally Posted by Raskim2000

#learn_creature_all_skill magic wuhuuu.... Im working on the Pet`s that they learn the skills alone without the command. That is no fix, sry.

i queried the skills each evo and skilling stage, they work totally well and tested it without learn_creature_all_skill command,

MuStA.