Aidez au developpement du craft !

Unread post by **Aura** » 07 Jul 2005, 10:53

Une question pour etre certain de ne pas faire d'erreurs: peut on considerer que tous les objets d'une meme categorie (toutes les Great sword par exemple) ont la meme skin ?

Ben en fait je me suis posée la meme question. Quand je regarde dans le ItemTemplate des objets qui ont la meme skin n'ont pas le meme numero de modèle.
Ex : woolen woven cap -> 826
woolen padded cap -> 825

Donc voila

Unread post by **Ghordjul** » 07 Jul 2005, 14:54

Aura wrote:
Une question pour etre certain de ne pas faire d'erreurs: peut on considerer que tous les objets d'une meme categorie (toutes les Great sword par exemple) ont la meme skin ?
Ben en fait je me suis posée la meme question. Quand je regarde dans le ItemTemplate des objets qui ont la meme skin n'ont pas le meme numero de modèle.
Ex : woolen woven cap -> 826
woolen padded cap -> 825

Donc voila

ATTENTION, SUPPOSITION, NECESSITE CONFIRMATION
Y a une différence entre la skin inventaire, et la skin que ça donnera sur le perso. Je pense que la skin "inventaire" est celle qui détermine l'endroit où l'objet pourra être mis (ex épée dans la main et pas sur la tête), et le numéro de modèle détermine ce à quoi il ressemblera en vrai, ainsi que ses caractéristiques...

@duff (et tout le monde en fait) : En effet, il serait peut-être judicieux de D'ABORD modifier tous les prix sans toucher aux noms, histoire que ce soit transposable à n'importe quel serveur, quitte à garder les traductions au chaud pour quand la bdd sera nickel-chrome.
Duff, si j'ai rien compris, flagelle-moi

Unread post by **Doulbousiouf** » 07 Jul 2005, 15:32

Je devellope un generateur automatique des bases de données du caft, ce que vous faites sert a rien ...

Unread post by **Sp4M** » 07 Jul 2005, 15:39

Doulbousiouf wrote:Je devellope un generateur automatique des bases de données du caft, ce que vous faite sert a rien ...

J'ai jamais entendu un truc aussi con venant de toi =)

Unread post by **Ghordjul** » 07 Jul 2005, 15:59

Il est toujours aussi enthousiaste quand on essaye d'aider le Doulb ?

Unread post by **Aura** » 07 Jul 2005, 16:08

Y a une différence entre la skin inventaire, et la skin que ça donnera sur le perso. Je pense que la skin "inventaire" est celle qui détermine l'endroit où l'objet pourra être mis (ex épée dans la main et pas sur la tête), et le numéro de modèle détermine ce à quoi il ressemblera en vrai, ainsi que ses caractéristiques...

UPDATE itemtemplate SET Model=380 WHERE Name="woolen cloth arms";

Mais donc pour cet item qui a une skin "inventaire" de bijou on doit pas changer le model ?

je fais de la couture avec ma thaumaturge et quand je fais differents types de capes (fancy, dressy ...) je ne vois aucunes différences entre elles alors que normallement il devrait y avoir des motifs.

PS: Cela fonctionne pour les couturiers Midgardiens.

Et c'est la qu'il faudrait changer le model ?

Arretez moi tout de suite si je fais fausse route

Unread post by **KULGAR** » 07 Jul 2005, 18:06

Prix Epées Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Copper = 75 WHERE Name = "bronze Dagger";
UPDATE itemtemplate SET Silver = 12 WHERE Name = "iron Dagger";
UPDATE itemtemplate SET Silver = 48 WHERE Name = "steel Dagger";
UPDATE itemtemplate SET Gold = 1, Silver = 44 WHERE Name = "alloy Dagger";
UPDATE itemtemplate SET Gold = 4, Silver = 32 WHERE Name = "fine alloy Dagger";
UPDATE itemtemplate SET Gold = 8, Silver = 64 WHERE Name = "mithril Dagger";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "adamantium Dagger";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "asterite Dagger";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "netherium Dagger";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "arcanium Dagger";

UPDATE itemtemplate SET Silver = 1 WHERE Name = "bronze short sword";
UPDATE itemtemplate SET Silver = 16 WHERE Name = "iron short sword";
UPDATE itemtemplate SET Silver = 64 WHERE Name = "steel short sword";
UPDATE itemtemplate SET Gold = 1, Silver = 92 WHERE Name = "alloy short sword";
UPDATE itemtemplate SET Gold = 5, Silver = 76 WHERE Name = "fine alloy short sword";
UPDATE itemtemplate SET Gold = 11, Silver = 52 WHERE Name = "mithril short sword";
UPDATE itemtemplate SET Gold = 17, Silver = 28 WHERE Name = "adamantium short sword";
UPDATE itemtemplate SET Gold = 25, Silver = 92 WHERE Name = "asterite short sword";
UPDATE itemtemplate SET Gold = 38, Silver = 88 WHERE Name = "netherium short sword";
UPDATE itemtemplate SET Gold = 58, Silver = 32 WHERE Name = "arcanium short sword";

UPDATE itemtemplate SET Silver = 1, Copper = 88 WHERE Name = "bronze long sword";
UPDATE itemtemplate SET Silver = 30 WHERE Name = "iron long sword";
UPDATE itemtemplate SET Gold = 1, Silver = 20 WHERE Name = "steel long sword";
UPDATE itemtemplate SET Gold = 3, Silver = 60 WHERE Name = "alloy long sword";
UPDATE itemtemplate SET Gold = 10, Silver = 80 WHERE Name = "fine alloy long sword";
UPDATE itemtemplate SET Gold = 21, Silver = 60 WHERE Name = "mithril long sword";
UPDATE itemtemplate SET Gold = 32, Silver = 40 WHERE Name = "adamantium long sword";
UPDATE itemtemplate SET Gold = 48, Silver = 60 WHERE Name = "asterite long sword";
UPDATE itemtemplate SET Gold = 72, Silver = 90 WHERE Name = "netherium long sword";
UPDATE itemtemplate SET Gold = 109, Silver = 35 WHERE Name = "arcanium long sword";

UPDATE itemtemplate SET Silver = 2, Copper = 31 WHERE Name = "bronze bastard sword";
UPDATE itemtemplate SET Silver = 37 WHERE Name = "iron bastard sword";
UPDATE itemtemplate SET Gold = 1, Silver = 48 WHERE Name = "steel bastard sword";
UPDATE itemtemplate SET Gold = 4, Silver = 44 WHERE Name = "alloy bastard sword";
UPDATE itemtemplate SET Gold = 13, Silver = 32 WHERE Name = "fine alloy bastard sword";
UPDATE itemtemplate SET Gold = 26, Silver = 64 WHERE Name = "mithril bastard sword";
UPDATE itemtemplate SET Gold = 39, Silver = 96 WHERE Name = "adamantium bastard sword";
UPDATE itemtemplate SET Gold = 59, Silver = 94 WHERE Name = "asterite bastard sword";
UPDATE itemtemplate SET Gold = 89, Silver = 91 WHERE Name = "netherium bastard sword";
UPDATE itemtemplate SET Gold = 134, Silver = 86, Copper = 50 WHERE Name = "arcanium bastard sword";

UPDATE itemtemplate SET Gold = 15, Silver = 98, Copper = 40 WHERE Name = "fine alloy dwarven short sword";
UPDATE itemtemplate SET Gold = 31, Silver = 96, Copper = 80 WHERE Name = "mithril dwarven short sword";
UPDATE itemtemplate SET Gold = 47, Silver = 95, Copper = 20 WHERE Name = "adamantium dwarven short sword";
UPDATE itemtemplate SET Gold = 71, Silver = 92, Copper = 80 WHERE Name = "asterite dwarven short sword";
UPDATE itemtemplate SET Gold = 107, Silver = 89, Copper = 20 WHERE Name = "netherium dwarven short sword";
UPDATE itemtemplate SET Gold = 161, Silver = 83, Copper = 80 WHERE Name = "arcanium dwarven short sword";

UPDATE itemtemplate SET Silver = 2, Copper = 19 WHERE Name = "bronze two handed sword";
UPDATE itemtemplate SET Silver = 35 WHERE Name = "iron two handed sword";
UPDATE itemtemplate SET Gold = 1, Silver = 40 WHERE Name = "steel two handed sword";
UPDATE itemtemplate SET Gold = 4, Silver = 20 WHERE Name = "alloy two handed sword";
UPDATE itemtemplate SET Gold = 12, Silver = 60 WHERE Name = "fine alloy two handed sword";
UPDATE itemtemplate SET Gold = 25, Silver = 20 WHERE Name = "mithril two handed sword";
UPDATE itemtemplate SET Gold = 37, Silver = 80 WHERE Name = "adamantium two handed sword";
UPDATE itemtemplate SET Gold = 56, Silver = 70 WHERE Name = "asterite two handed sword";
UPDATE itemtemplate SET Gold = 85, Silver = 5 WHERE Name = "netherium two handed sword";
UPDATE itemtemplate SET Gold = 127, Silver = 57, Copper = 50 WHERE Name = "arcanium two handed sword";

UPDATE itemtemplate SET Silver = 2, Copper = 56 WHERE Name = "bronze great sword";
UPDATE itemtemplate SET Silver = 41 WHERE Name = "iron great sword";
UPDATE itemtemplate SET Gold = 1, Silver = 64 WHERE Name = "steel great sword";
UPDATE itemtemplate SET Gold = 4, Silver = 92, WHERE Name = "alloy great sword";
UPDATE itemtemplate SET Gold = 14, Silver = 76 WHERE Name = "fine alloy great sword";
UPDATE itemtemplate SET Gold = 29, Silver = 52 WHERE Name = "mithril great sword";
UPDATE itemtemplate SET Gold = 44, Silver = 28 WHERE Name = "adamantium great sword";
UPDATE itemtemplate SET Gold = 66, Silver = 42 WHERE Name = "asterite great sword";
UPDATE itemtemplate SET Gold = 99, Silver = 63 WHERE Name = "netherium great sword";
UPDATE itemtemplate SET Gold = 149, Silver = 44, Copper = 50 WHERE Name = "arcanium great sword";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy dwarven great sword";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril dwarven great sword";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium dwarven great sword";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite dwarven great sword";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium dwarven great sword";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium dwarven great sword";

UPDATE itemtemplate SET Gold = 15, Silver = 98, Copper = 40 WHERE Name = "fine alloy exceptional long sword";
UPDATE itemtemplate SET Gold = 31, Silver = 96, Copper = 80 WHERE Name = "mithril exceptional long sword";
UPDATE itemtemplate SET Gold = 47, Silver = 95, Copper = 20 WHERE Name = "adamantium exceptional long sword";
UPDATE itemtemplate SET Gold = 71, Silver = 92, Copper = 80 WHERE Name = "asterite exceptional long sword";
UPDATE itemtemplate SET Gold = 107, Silver = 89, Copper = 20 WHERE Name = "netherium exceptional long sword";
UPDATE itemtemplate SET Gold = 161, Silver = 83, Copper = 80 WHERE Name = "arcanium exceptional long sword";

UPDATE itemtemplate SET Gold = 15, Silver = 98, Copper = 40 WHERE Name = "fine alloy fortified long sword";
UPDATE itemtemplate SET Gold = 31, Silver = 96, Copper = 80 WHERE Name = "mithril fortified long sword";
UPDATE itemtemplate SET Gold = 47, Silver = 95, Copper = 20 WHERE Name = "adamantium fortified long sword";
UPDATE itemtemplate SET Gold = 71, Silver = 92, Copper = 80 WHERE Name = "asterite fortified long sword";
UPDATE itemtemplate SET Gold = 107, Silver = 89, Copper = 20 WHERE Name = "netherium fortified long sword";
UPDATE itemtemplate SET Gold = 161, Silver = 83, Copper = 80 WHERE Name = "arcanium fortified long sword";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy exceptional great sword";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril exceptional great sword";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium exceptional great sword";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite exceptional great sword";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium exceptional great sword";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium exceptional great sword";

UPDATE itemtemplate SET Gold = 18, Silver = 14, Copper = 40 WHERE Name = "fine alloy fortified great sword";
UPDATE itemtemplate SET Gold = 36, Silver = 28, Copper = 80 WHERE Name = "mithril fortified great sword";
UPDATE itemtemplate SET Gold = 54, Silver = 43, Copper = 20 WHERE Name = "adamantium fortified great sword";
UPDATE itemtemplate SET Gold = 81, Silver = 64, Copper = 80 WHERE Name = "asterite fortified great sword";
UPDATE itemtemplate SET Gold = 122, Silver = 47, Copper = 20 WHERE Name = "netherium fortified great sword";
UPDATE itemtemplate SET Gold = 183, Silver = 70, Copper = 80 WHERE Name = "arcanium fortified great sword";

Observation:
Absence de la "broad sword"
Absence des armes Legendaire.

Prix Griffes Midgard (prix de revente identique à goa)

UPDATE itemtemplate SET Copper = 88 WHERE Name = "bronze moon fang";
UPDATE itemtemplate SET Silver = 14 WHERE Name = "iron moon fang";
UPDATE itemtemplate SET Silver = 56 WHERE Name = "steel moon fang";
UPDATE itemtemplate SET Gold = 1, Silver = 68 WHERE Name = "alloy moon fang";
UPDATE itemtemplate SET Gold = 5, Silver = 4 WHERE Name = "fine alloy moon fang";
UPDATE itemtemplate SET Gold = 10, Silver = 8 WHERE Name = "mithril moon fang";
UPDATE itemtemplate SET Gold = 15, Silver = 12 WHERE Name = "adamantium moon fang";
UPDATE itemtemplate SET Gold = 22, Silver = 68 WHERE Name = "asterite moon fang";
UPDATE itemtemplate SET Gold = 34, Silver = 2 WHERE Name = "netherium moon fang";
UPDATE itemtemplate SET Gold = 51, Silver = 3 WHERE Name = "arcanium moon fang";

UPDATE itemtemplate SET Silver = 1, Copper = 13 WHERE Name = "bronze moon claw";
UPDATE itemtemplate SET Silver = 18 WHERE Name = "iron moon claw";
UPDATE itemtemplate SET Silver = 72 WHERE Name = "steel moon claw";
UPDATE itemtemplate SET Gold = 2, Silver = 16 WHERE Name = "alloy moon claw";
UPDATE itemtemplate SET Gold = 6, Silver = 48 WHERE Name = "fine alloy moon claw";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "mithril moon claw";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "adamantium moon claw";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "asterite moon claw";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "netherium moon claw";
UPDATE itemtemplate SET Gold = 65, Silver = 61 WHERE Name = "arcanium moon claw";

UPDATE itemtemplate SET Silver = 1, Copper = 38 WHERE Name = "bronze bladed moon fang";
UPDATE itemtemplate SET Silver = 22 WHERE Name = "iron bladed moon fang";
UPDATE itemtemplate SET Silver = 88 WHERE Name = "steel bladed moon fang";
UPDATE itemtemplate SET Gold = 2, Silver = 64 WHERE Name = "alloy bladed moon fang";
UPDATE itemtemplate SET Gold = 7, Silver = 92 WHERE Name = "fine alloy bladed moon fang";
UPDATE itemtemplate SET Gold = 15, Silver = 84 WHERE Name = "mithril bladed moon fang";
UPDATE itemtemplate SET Gold = 23, Silver = 76 WHERE Name = "adamantium bladed moon fang";
UPDATE itemtemplate SET Gold = 35, Silver = 64 WHERE Name = "asterite bladed moon fang";
UPDATE itemtemplate SET Gold = 53, Silver = 46 WHERE Name = "netherium bladed moon fang";
UPDATE itemtemplate SET Gold = 80, Silver = 19 WHERE Name = "arcanium bladed moon fang";

UPDATE itemtemplate SET Silver = 1, Copper = 63 WHERE Name = "bronze bladed moon claw";
UPDATE itemtemplate SET Silver = 26 WHERE Name = "iron bladed moon claw";
UPDATE itemtemplate SET Gold = 1, Silver = 4 WHERE Name = "steel bladed moon claw";
UPDATE itemtemplate SET Gold = 3, Silver = 12 WHERE Name = "alloy bladed moon claw";
UPDATE itemtemplate SET Gold = 9, Silver = 36 WHERE Name = "fine alloy bladed moon claw";
UPDATE itemtemplate SET Gold = 18, Silver = 72 WHERE Name = "mithril bladed moon claw";
UPDATE itemtemplate SET Gold = 28, Silver = 8 WHERE Name = "adamantium bladed moon claw";
UPDATE itemtemplate SET Gold = 42, Silver = 12 WHERE Name = "asterite bladed moon claw";
UPDATE itemtemplate SET Gold = 63, Silver = 18 WHERE Name = "netherium bladed moon claw";
UPDATE itemtemplate SET Gold = 94, Silver = 77 WHERE Name = "arcanium bladed moon claw";

UPDATE itemtemplate SET Copper = 88 WHERE Name = "bronze fang greave";
UPDATE itemtemplate SET Silver = 14 WHERE Name = "iron fang greave";
UPDATE itemtemplate SET Silver = 56 WHERE Name = "steel fang greave";
UPDATE itemtemplate SET Gold = 1, Silver = 68 WHERE Name = "alloy fang greave";
UPDATE itemtemplate SET Gold = 5, Silver = 4 WHERE Name = "fine alloy fang greave";
UPDATE itemtemplate SET Gold = 10, Silver = 8 WHERE Name = "mithril fang greave";
UPDATE itemtemplate SET Gold = 15, Silver = 12 WHERE Name = "adamantium fang greave";
UPDATE itemtemplate SET Gold = 22, Silver = 68 WHERE Name = "asterite fang greave";
UPDATE itemtemplate SET Gold = 34, Silver = 2 WHERE Name = "netherium fang greave";
UPDATE itemtemplate SET Gold = 51, Silver = 3 WHERE Name = "arcanium fang greave";

UPDATE itemtemplate SET Silver = 1, Copper = 13 WHERE Name = "bronze claw greave";
UPDATE itemtemplate SET Silver = 18 WHERE Name = "iron claw greave";
UPDATE itemtemplate SET Silver = 72 WHERE Name = "steel claw greave";
UPDATE itemtemplate SET Gold = 2, Silver = 16 WHERE Name = "alloy claw greave";
UPDATE itemtemplate SET Gold = 6, Silver = 48 WHERE Name = "fine alloy claw greave";
UPDATE itemtemplate SET Gold = 12, Silver = 96 WHERE Name = "mithril claw greave";
UPDATE itemtemplate SET Gold = 19, Silver = 44 WHERE Name = "adamantium claw greave";
UPDATE itemtemplate SET Gold = 29, Silver = 16 WHERE Name = "asterite claw greave";
UPDATE itemtemplate SET Gold = 43, Silver = 74 WHERE Name = "netherium claw greave";
UPDATE itemtemplate SET Gold = 65, Silver = 61 WHERE Name = "arcanium claw greave";

UPDATE itemtemplate SET Silver = 1, Copper = 38 WHERE Name = "bronze bladed fang greave";
UPDATE itemtemplate SET Silver = 22 WHERE Name = "iron bladed fang greave";
UPDATE itemtemplate SET Silver = 88 WHERE Name = "steel bladed fang greave";
UPDATE itemtemplate SET Gold = 2, Silver = 64 WHERE Name = "alloy bladed fang greave";
UPDATE itemtemplate SET Gold = 7, Silver = 92 WHERE Name = "fine alloy bladed fang greave";
UPDATE itemtemplate SET Gold = 15, Silver = 84 WHERE Name = "mithril bladed fang greave";
UPDATE itemtemplate SET Gold = 23, Silver = 76 WHERE Name = "adamantium bladed fang greave";
UPDATE itemtemplate SET Gold = 35, Silver = 64 WHERE Name = "asterite bladed fang greave";
UPDATE itemtemplate SET Gold = 53, Silver = 46 WHERE Name = "netherium bladed fang greave";
UPDATE itemtemplate SET Gold = 80, Silver = 19 WHERE Name = "arcanium bladed fang greave";

UPDATE itemtemplate SET Silver = 1, Copper = 63 WHERE Name = "bronze bladed claw greave";
UPDATE itemtemplate SET Silver = 26 WHERE Name = "iron bladed claw greave";
UPDATE itemtemplate SET Gold = 1, Silver = 4 WHERE Name = "steel bladed claw greave";
UPDATE itemtemplate SET Gold = 3, Silver = 12 WHERE Name = "alloy bladed claw greave";
UPDATE itemtemplate SET Gold = 9, Silver = 36 WHERE Name = "fine alloy bladed claw greave";
UPDATE itemtemplate SET Gold = 18, Silver = 72 WHERE Name = "mithril bladed claw greave";
UPDATE itemtemplate SET Gold = 28, Silver = 8 WHERE Name = "adamantium bladed claw greave";
UPDATE itemtemplate SET Gold = 42, Silver = 12 WHERE Name = "asterite bladed claw greave";
UPDATE itemtemplate SET Gold = 63, Silver = 18 WHERE Name = "netherium bladed claw greave";
UPDATE itemtemplate SET Gold = 94, Silver = 77 WHERE Name = "arcanium bladed claw greave";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy heavy bladed moon claw";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril heavy bladed moon claw";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium heavy bladed moon claw";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite heavy bladed moon claw";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium heavy bladed moon claw";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium heavy bladed moon claw";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy heavy bladed claw greave";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril heavy bladed claw greave";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium heavy bladed claw greave";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite heavy bladed claw greave";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium heavy bladed claw greave";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium heavy bladed claw greave";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy exceptional fang greave";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril exceptional fang greave";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium exceptional fang greave";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite exceptional fang greave";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium exceptional fang greave";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium exceptional fang greave";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy fortified fang greave";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril fortified fang greave";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium fortified fang greave";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite fortified fang greave";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium fortified fang greave";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium fortified fang greave";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy exceptional moon claw";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril exceptional moon claw";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium exceptional moon claw";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite exceptional moon claw";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium exceptional moon claw";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium exceptional moon claw";

UPDATE itemtemplate SET Gold = 11, Silver = 23, Copper = 20 WHERE Name = "fine alloy fortified moon claw";
UPDATE itemtemplate SET Gold = 22, Silver = 46, Copper = 40 WHERE Name = "mithril fortified moon claw";
UPDATE itemtemplate SET Gold = 33, Silver = 69, Copper = 60 WHERE Name = "adamantium fortified moon claw";
UPDATE itemtemplate SET Gold = 50, Silver = 54, Copper = 40 WHERE Name = "asterite fortified moon claw";
UPDATE itemtemplate SET Gold = 75, Silver = 81, Copper = 60 WHERE Name = "netherium fortified moon claw";
UPDATE itemtemplate SET Gold = 113, Silver = 72, Copper = 40 WHERE Name = "arcanium fortified moon claw";

Observation:
Absence des armes Legendaire.

Voila.

Unread post by **Doulbousiouf** » 07 Jul 2005, 20:26

J'ai jamais entendu un truc aussi con venant de toi =)

Quand je release le script tu comprendra tres vite que ca peut etre generer automatiquement ...

Il est toujours aussi enthousiaste quand on essaye d'aider le Doulb ?

C'est une bonne initiative mais a mon avis entrer 9967 objets a la main c'est trés difficile ... rentrer 9967 objets a la main puis les traduire c'est extremement difficile et rentrer 9967 objets a la main puis les traduire et tout ca sans aucune erreur c'est presque impossible surtout quand on considere que les joueurs n'ont aucun moyen de savoir le model correct des objets ...

Nota: Un pc travaille plus vite qu'un humain ...

Unread post by **Cossa** » 07 Jul 2005, 20:52

Un pc ne réfléchi pas aussi bien qu'un humain

Du fer à épée n'a pas une skin d'épée

Enfin ce que je veux dire c'est qu'un pc n'est pas sans failles et des failles qu'un humain peut corriger :p

Unread post by **TaTsE** » 08 Jul 2005, 00:29

En tout cas je suis content de voir autant de gens motiver pour aider amtenael je dis ca fai plez.

/clap quand meme,meme si doulb est le plus beau, le plus fort, le plus inteligent, continué et faite pas comme lui mais merci quand meme doulb...

Unread post by **Sp4M** » 08 Jul 2005, 00:49

Doulbousiouf wrote:
J'ai jamais entendu un truc aussi con venant de toi =)
Quand je release le script tu comprendra tres vite que ca peut etre generer automatiquement ...

Je parlais de ta facon de le dire genre "Mouhahaha les cons ..." =)

Unread post by **Mitos** » 08 Jul 2005, 09:26

Bon alors moi je suis une quéquète dans tout sa... Mais juste en passant, je ne peux m'empêcher de dire, que sa fait pas de mal d'être "humble"...

Allez hein ...

Unread post by **Thorwall** » 08 Jul 2005, 13:24

bon voilà, je poste quand meme pour aider au cas où.

Desole, je n'arrive pas à ouvrir le document de spam en entier.

a chaque fois, il me fait planter du fait de sa taille (le temps pour charger toutes la liste des items je pense).

Si on pouvait tronquer en partie la liste (juste au niveau de l'empennage), cela m'arrangerait pour vous aider, sinon pas grave.

voici en partie quelques objets de craft de l'empennage qui ne vont pas:

-Je suis 800 en empennage et j 'ai debloqué 8 categories d'arcs hiberniens (je n ai pas teste ceux de mid et de alb):

arc court ==> short bow
arc court recourbé ==> short recurve bow
grand arc recourbé ==> great recurve bow
arc recourbé ==> recurve bow
-----------------------------------------------------------------------

arc recourbé lourd ==> heavy recurve bow
arc court lourd ==> heavy short bow

-----------------------------------------------------------------------

arc recourbé exceptionnel ==> exceptionnal recurve bow
arc recourbé formidable ==> oublie de le noter

------------------------------------------------------------------------

-test arcs normaux non lourd:

oaken short recurve bow ==>skin mauvais dps=O vit=O
oaken short bow ==>skin mauvais dps=O vit=O
oaken great recurve bow ==>skin bon dps=O vit=O
oaken recurve bow ==>skin bon dps=O vit=O

elm short recurve bow
elm short bow
elm great recurve bow
elm recurve bow

heartwood short recurve bow
heartwood short bow
heartwood great recurve bow
heartwood recurve bow

ironwood short recurve bow
ironwood short bow
ironwood great recurve bow
ironwood recurve bow

Les elm wood bow, heart wood bow et iron wood sont tous bons pour le skin et dps/vit, concernant les short recurve bow, les short bow, les great recurve bow et les recurve bow.

-----------------------------------------------------------------------------

les runewood bow ne sont pas bon en skin et dps/vit.
les stonewood ne sont pas bon en skin et dps/vit.

-----------------------------------------------------------------------------

Les dyrwoods bow:

short bow: skin pas bon et vit 0 /dps 0
short recurve bow: skin pas bon et vit 0 /dps 0
recurve bow: skin bon et vit 0 /dps 0
great recurve bow: skin bon et vit 0 /dps 0

-----------------------------------------------------------------------------

concernant les skins, je dit qu'ils sont mauvais dans le sens où je vois une piece d'armure à la place du skin d'un arc. Mais à savoir si dans la base de données s'ils ont bien le bon model correspondant, lorsqu'ils ont le skin d'un arc (bon skin pour moi) je ne sais pas etant donné que je n'arrive pas à ouvrir en entier le document xml.

Je ne sais pas si cela va aider mais je prefere le poster quand meme.

Je continue quand meme de rescencer au fur et a mesure.

+++

+++

Unread post by **Likine** » 09 Jul 2005, 12:37

UPDATE itemtemplate SET Name = "Venin de vipère" WHERE Name = "adder venom";
UPDATE itemtemplate SET Name = "Distillat oxygéné" WHERE Name = "airy distill";
UPDATE itemtemplate SET Name = "Salive de chauve souris" WHERE Name = "bat saliva";
UPDATE itemtemplate SET Name = "Albumen sanguinolent" WHERE Name = "blood albumen";
UPDATE itemtemplate SET Name = "Racine sanguine bouillie" WHERE Name = "boiled blood root";
UPDATE itemtemplate SET Name = "Racine de gingembre bouillie" WHERE Name = "boiled ginger root";
UPDATE itemtemplate SET Name = "Malt de St John bouilli" WHERE Name = "boiled St John's wort";
UPDATE itemtemplate SET Name = "Aconite commun" WHERE Name = "common monkshood";
UPDATE itemtemplate SET Name = "Venin de serpent corail" WHERE Name = "coral snake venom";
UPDATE itemtemplate SET Name = "Pierre de focus brune broyée" WHERE Name = "crushed brown focus stone";
UPDATE itemtemplate SET Name = "Flasque de crystal" WHERE Name = "crystal flask";
UPDATE itemtemplate SET Name = "Fiole de crystal" WHERE Name = "crystal vial";
UPDATE itemtemplate SET Name = "Morelle noire mortelle" WHERE Name = "deadly nightshade";
UPDATE itemtemplate SET Name = "Barres de métal en dolomite" WHERE Name = "dolomite metal bars";
UPDATE itemtemplate SET Name = "Racine de gingembre séchée" WHERE Name = "dried ginger root";
UPDATE itemtemplate SET Name = "Malt de St John séché" WHERE Name = "dried St John's wort";
UPDATE itemtemplate SET Name = "Goutte de sang de géant" WHERE Name = "drop of giant blood";
UPDATE itemtemplate SET Name = "Distillat poussiéreux" WHERE Name = "dusty distill";
UPDATE itemtemplate SET Name = "Distillat terreux" WHERE Name = "earthen distill";
UPDATE itemtemplate SET Name = "Distillat brûlant" WHERE Name = “fiery distill";
UPDATE itemtemplate SET Name = "Venin d'araignée latrodectus" WHERE Name = "latrodectus spider venom";
UPDATE itemtemplate SET Name = "Narcisse" WHERE Name = "narcissus";
UPDATE itemtemplate SET Name = "Racine de gingembre en poudre" WHERE Name = "powdered ginger root";
UPDATE itemtemplate SET Name = "Salive de rat" WHERE Name = "rat sliva";
UPDATE itemtemplate SET Name = "Venin de serpent de mer" WHERE Name = "sea snake venom";
UPDATE itemtemplate SET Name = "Petite flasque de mercure" WHERE Name = "tiny vial of mercury";
UPDATE itemtemplate SET Name = "Distillat liquide" WHERE Name = "watery distill";
UPDATE itemtemplate SET Name = "Feuilles d'If" WHERE Name = "yew leaves";

Unread post by **Tidgef** » 11 Jul 2005, 17:42

UPDATE itemtemplate SET Name = "extrait de feuilles de salsepareille ecrasées" WHERE Name = "diluted sassafras leaf extract";
UPDATE itemtemplate SET Name = "plante du teinturier ecrasée" WHERE Name = "crushed weld";
UPDATE itemtemplate SET Name = "chou rouge" WHERE Name = "ground red cabbage";
UPDATE itemtemplate SET Name = "flasque en metal fin" WHERE Name = "thin metal flask";
UPDATE itemtemplate SET Name = "bourgeon de bruyère broyée" WHERE Name = "crumpled bracken buds";