Aidez au developpement du craft !

Ici, les rôles s’inversent : c’est vous qui proposez votre aide au staff pour améliorer le serveur. Attention, ici on ne demande pas, on propose !
Locked
Asenar Lunin
Maître Absolu
Posts: 3604
Joined: 02 May 2005, 12:23
Discord:
Contact:
Contact Asenar Lunin

Unread post by Asenar Lunin »

KULGAR wrote: Sur Goa on perd de l'argent si on vend a un PNJ, on en gagne seulement si on vend a un PJ.

Donc je sais pas comment on va faire ici, j'attend d'en parler avec malkavien pour savoir comment on fait, donc j'attend pour faire la suite. :D
Ce qui me paraitrait plus que logique serait de revendre a un PNJ au meme prix que si on lui avait acheté puis revendu.

Parce qu'on est quand meme sensé fabriquer des armures/armes/etc.. "meilleures" que les pnj, donc le minimum serait qu'ils rachete nos objets aux meme prix qu'ils en racheterait un autre^^

Enfin on verra bien^^
Asenar Lunin, furtif...,
Encyclopédie
Furtif, mais moins..
Top
Likine
Billou
Posts: 188
Joined: 19 Jan 2005, 08:07
Discord:

Unread post by Likine »

UPDATE itemtemplate SET Name = "salive de chauve souris" WHERE Name = "bat saliva";
UPDATE itemtemplate SET Name = "extrait de moelle osseuse" WHERE Name = "bone salve extract";
UPDATE itemtemplate SET Name = "venin d'araignée latrodectus" WHERE Name = "latrodectus spider venom";
UPDATE itemtemplate SET Name = "pivoine" WHERE Name = "peony";
UPDATE itemtemplate SET Name = "graine de pavot" WHERE Name = "poppy seed";
Liinkä Gîlgandil - Eldritch
Image
Top
User avatar
Cossa
Maître Absolu
Posts: 1328
Joined: 01 Dec 2004, 19:59
Discord:
Contact:
Contact Cossa

Unread post by Cossa »

Voila, je propose un petit script php pour mettre à jour la bdd puisqu'apparemment, elle est en mySQL.

Seul probleme, mon script est un tres gros mangeur de ressources. En effet, il va effectuer un nombre monstrueux de requetes (1 + 2 par objet crafté + 1 par matériau demandé pour l'objet).

Et en plus je ne sais pas si il marche. Donc pour le moment je le met ici, si j'arrive à le simplifier, je le ferai.

Code: Select all

<?php

// Recupere la liste des items
$sql = "SELECT Name, SerializedRawMaterial
		FROM CraftedItem";
$result = mysql_query($sql) or die('Could not obtain Crafted Items');

// $objet est ici l'objet fabriqué
while( $objet = mysql_fetch_array($result) )
{
	// On enleve le dernier ; pour eviter les bugs
	$item = substr($objet['SerializedRawMaterial'], 0, -1);
	
	// $item représente ici un matériau demandé
	$item = explode(';', $string);
	$count_item = count($item);

	$prix_final = 0;
	
	for($i=0;$i++;$i<$count_item)
	{
		// $partie représente en 0 le nombre de parties demander
		// et en 1 le nom de cette partie
		$partie = explode('|', $item[$i]);
		
		// On récupère pour chaque matériaux son prix en or, argent et bronze
		$sql = "SELECT gold, silver, copper
				FROM ItemTemplate
				WHERE Name = '" . $partie[1] . "'";
		$result1 = mysql_query($sql) or die('Could not obtain Prices');
		$tarif = mysql_fetch_array($result1) or die('No material with that name :'. $partie[1]);
		
		// On met le prix sous forme : ++**//
		// ou ++ correspond au prix en or
		// ** correspond à l'argent 
		// et // correspond au bronze
		$prix = 0;
		$prix += $partie[0]*$tarif['copper'];
		$prix += 100*$partie[0]*$tarif['silver'];
		$prix += 10000*$partie[0]*$tarif['gold'];
		
		// Ici on gere le rendement du craft
		// Un rendement de 1 correspond a un prix de revente égale au prix d'achat
		// Un rendement inférieurà 1 correspond à une perte
		// Exemple, un rendement de 0,8 correspond a une perte de 20% pour le joueur.
		$rendement = 1;
		$prix_final += $rendement*$prix;
	}
	
	// Le prix en bronze correspond donc ici aux 2 derniers chiffres
	// et ainsi de suite
	$copper = substr($prix_final, -2);
	$prix_final = substr($prix_final, 0, -2);
	
	$silver = substr($prix_final, -2);
	$prix_final = substr($prix_final, 0, -2);

	$gold = $prix_final;
	
	// On met à jour le prix de l'objet
	$sql = "UPDATE CraftedItem 
			SET gold = `$gold`, silver = `$silver`, copper = `$copper`
			WHERE Name = '".$objet['Name']."';
	$result1 = mysql_query($sql) or die('Could not update Price of '.$objet['Name']);
}

?>
Image
Top
Doulbousiouf
Maître Absolu
Posts: 1010
Joined: 23 Sep 2004, 17:42
Discord:

Unread post by Doulbousiouf »

:D Je travaille actuellement sur un script qui generera automatiquement les bases du craft dans la langue quon veux ... et sans erreurs ...

_________________
Doulbousiouf
Image
Top
Likine
Billou
Posts: 188
Joined: 19 Jan 2005, 08:07
Discord:

Unread post by Likine »

UPDATE itemtemplate SET Name = "crocus d'automne" WHERE Name = "autumn crocus";
UPDATE itemtemplate SET Name = "venin de veuve noire" WHERE Name = "black widow venom";
UPDATE itemtemplate SET Name = "huile de plante à sucre" WHERE Name = "caster oil plant";
UPDATE itemtemplate SET Name = "fiole de céramique" WHERE Name = "ceramic vial";
UPDATE itemtemplate SET Name = "laurier cerise" WHERE Name = "cherry laurel";
UPDATE itemtemplate SET Name = "extrait d'hévéa" WHERE Name = "hevea tree extract";
Liinkä Gîlgandil - Eldritch
Image
Top
User avatar
Cossa
Maître Absolu
Posts: 1328
Joined: 01 Dec 2004, 19:59
Discord:
Contact:
Contact Cossa

Unread post by Cossa »

sa marche dans n'importe quelle langue du moment que la base CraftedItem est mise à jour en meme temps que ItemTemplate :-D
Mais je cherche avec des amis pour optimiser et reduire concidérablement le nombre de requetes.
Image
Top
Likine
Billou
Posts: 188
Joined: 19 Jan 2005, 08:07
Discord:

Unread post by Likine »

UPDATE itemtemplate SET Name = "baies de genièvre broyées" WHERE Name = "crushed juniper berries";
UPDATE itemtemplate SET Name = "coeur d'oeillet d'Inde écrasé" WHERE Name = "crushed marigold blossom";
UPDATE itemtemplate SET Name = "feuilles de salsepareille écrasées" WHERE Name = "crushed sassafras leaves";
UPDATE itemtemplate SET Name = "venin d'anémone distillé" WHERE Name = "distilled anemone venom";
UPDATE itemtemplate SET Name = "herbe du diable fermentée" WHERE Name = "fermented devil's bit";
UPDATE itemtemplate SET Name = "extrait de pomme de terre" WHERE Name = "potato extract";
UPDATE itemtemplate SET Name = "extrait de salsepareille" WHERE Name = "sassafras extract";

En passant ça serait pas mal de rendre les ingrédients pour l’alchimie et le spellcraft empilables, actuellement ils ne le sont pas et certain objets ne sont pas fabricable (par exemple la boule de glace qui nécessite plus de 300 composants)
Liinkä Gîlgandil - Eldritch
Image
Top
User avatar
Ghordjul
Demi-Dieu
Posts: 499
Joined: 12 Nov 2004, 22:46
Discord:

Unread post by Ghordjul »

Voici les prix de revente corrigés pour le spellcraft albionnais, pour l'instant j'ai remplacé par le prix coûtant, mais je peux facilement utiliser le prix de revente officiel (avec perte donc)...
Dès que j'ai le courage, je complète pour le spellcraft hibernien et midgardien.
Et si j'ai encore plus de courage, je balance les traductions :D

Code: Select all

UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 1, Copper = 60 WHERE Name = "Raw Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Finesse War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 4, Copper = 80 WHERE Name = "Raw Brilliant Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 20 WHERE Name = "Uncut Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 9, Copper = 80 WHERE Name = "Uncut Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Finesse War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 29, Copper = 40 WHERE Name = "Uncut Brilliant Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 39, Copper = 00 WHERE Name = "Rough Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Earthen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Icy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Fiery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Airy Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Heated Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Dusty Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vapor Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Watery Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Ashen Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Vacuous Sigil";
UPDATE itemtemplate SET Gold = 0, Silver = 40, Copper = 20 WHERE Name = "Rough Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Finesse War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 20, Copper = 60 WHERE Name = "Rough Brilliant Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 39, Copper = 00 WHERE Name = "Flawed Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Earthen Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Icy Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Fiery Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Airy Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Heated Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Dusty Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vapor Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Watery Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Ashen Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Vacuous Sigil";
UPDATE itemtemplate SET Gold = 1, Silver = 40, Copper = 80 WHERE Name = "Flawed Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Finesse War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 22, Copper = 40 WHERE Name = "Flawed Brilliant Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 1, Copper = 00 WHERE Name = "Imperfect Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Earthen Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Icy Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Fiery Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Airy Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Heated Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Dusty Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vapor Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Watery Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Ashen Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Vacuous Sigil";
UPDATE itemtemplate SET Gold = 4, Silver = 3, Copper = 40 WHERE Name = "Imperfect Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Finesse War Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 12, Silver = 10, Copper = 20 WHERE Name = "Imperfect Brilliant Sigil";
Suite au prochain post
ImageImage
Darkpepper wrote:Il faut juste se rendre compte que même si ca va a l'encontre de certaines actions "plausibles" vous devez avant tout respecter chacunes des règles du serveur
Top
User avatar
Ghordjul
Demi-Dieu
Posts: 499
Joined: 12 Nov 2004, 22:46
Discord:

Unread post by Ghordjul »

Code: Select all

UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 89, Copper = 80 WHERE Name = "Polished Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Earthen Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Icy Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Fiery Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Airy Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Heated Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Dusty Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vapor Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Watery Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Ashen Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Vacuous Sigil";
UPDATE itemtemplate SET Gold = 8, Silver = 92, Copper = 80 WHERE Name = "Polished Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Finesse War Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 26, Silver = 78, Copper = 40 WHERE Name = "Polished Brilliant Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 30, Copper = 00 WHERE Name = "Faceted Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Earthen Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Icy Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Fiery Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Airy Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Heated Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Dusty Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vapor Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Watery Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Ashen Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Vacuous Sigil";
UPDATE itemtemplate SET Gold = 13, Silver = 33, Copper = 60 WHERE Name = "Faceted Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Finesse War Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 40, Silver = 00, Copper = 80 WHERE Name = "Faceted Brilliant Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 89, Copper = 20 WHERE Name = "Precious Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Earthen Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Icy Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Fiery Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Airy Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Heated Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Dusty Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vapor Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Watery Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Ashen Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Vacuous Sigil";
UPDATE itemtemplate SET Gold = 19, Silver = 93, Copper = 40 WHERE Name = "Precious Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Finesse War Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 59, Silver = 80, Copper = 20 WHERE Name = "Precious Brilliant Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 82, Copper = 40 WHERE Name = "Flawless Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Earthen Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Icy Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Fiery Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Airy Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Heated Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Dusty Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vapor Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Watery Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Ashen Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Vacuous Sigil";
UPDATE itemtemplate SET Gold = 25, Silver = 87, Copper = 20 WHERE Name = "Flawless Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Finesse War Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 77, Silver = 61, Copper = 60 WHERE Name = "Flawless Brilliant Sigil";
Resuite au reprochain post
ImageImage
Darkpepper wrote:Il faut juste se rendre compte que même si ca va a l'encontre de certaines actions "plausibles" vous devez avant tout respecter chacunes des règles du serveur
Top
User avatar
Ghordjul
Demi-Dieu
Posts: 499
Joined: 12 Nov 2004, 22:46
Discord:

Unread post by Ghordjul »

Code: Select all

UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Blood Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Mystical Essence Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Dusty Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Icy Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Heated Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Light Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Earthen Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vapor Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Airy Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Fiery Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Watery Shielding Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Battle Jewel";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Molten Magma War Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Steaming Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Ashen Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vacuous Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Salt Crusted Fervor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Earthen Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Icy Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Fiery Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Airy Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Heated Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Dusty Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Vapor Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 68, Copper = 60 WHERE Name = "Perfect Watery Evocation Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Earthen Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Icy Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Fiery Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Airy Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Heated Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Dusty Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vapor Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Watery Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Ashen Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Vacuous Sigil";
UPDATE itemtemplate SET Gold = 29, Silver = 74, Copper = 00 WHERE Name = "Perfect Salt Crusted Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Finesse War Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Finesse Fervor Sigil";
UPDATE itemtemplate SET Gold = 89, Silver = 22, Copper = 00 WHERE Name = "Perfect Brilliant Sigil";
J'espère juste que j'ai pas fait d'erreur dans le code, mais en tous cas les données devraient être les bonnes... 'Vais me boire une bière la-dessus :lol:
ImageImage
Darkpepper wrote:Il faut juste se rendre compte que même si ca va a l'encontre de certaines actions "plausibles" vous devez avant tout respecter chacunes des règles du serveur
Top
Alice
Faux Dieu
Posts: 383
Joined: 07 Jan 2005, 22:50
Discord:
Contact:
Contact Alice

Unread post by Alice »

est-ce que je peut avoir la confirmation pour la syntaxe suivant pour etre sure que j'ai bien compris avant de continuer

c'est pour un gants à lamelles en astérite (asterite lamellar gaunlets)
item n° 1098


UPDATE itemtemplate SET Model=443 WHERE Name="asterite lamellar gaunlets";
Last edited by Alice on 04 Jul 2005, 19:45, edited 1 time in total.
Top
KULGAR
Maître Absolu
Posts: 1354
Joined: 16 Jan 2005, 12:35
Discord:

Unread post by KULGAR »

Ghordjul wrote:Voici les prix de revente corrigés pour le spellcraft albionnais, pour l'instant j'ai remplacé par le prix coûtant, mais je peux facilement utiliser le prix de revente officiel (avec perte donc)...
Dès que j'ai le courage, je complète pour le spellcraft hibernien et midgardien.
Et si j'ai encore plus de courage, je balance les traductions :D
Tu m'expliqueras comment faire. :D
On pourait s'organisé pour se partager le boulot aussi. :P
Top
Thorwall
Billou
Posts: 210
Joined: 14 Apr 2005, 20:09
Discord:

Unread post by Thorwall »

est ce qu'il y a une synthaxe pour les armes ayant des dps et vit mauvaise?

Je craft une bonne serie d'arc avec O en dps et 0 en vit.

J'ai listé une petite partie des arcs qui ont ce probleme.

+++
Top
User avatar
duff
Billou
Posts: 232
Joined: 19 May 2004, 08:13
Discord:

Unread post by duff »

ce serait bien que vous postiez le fruit de votre boulot sur dol data dump.
@doulbou : si tu te base sur le fichier mpk c est ce que j avais tenter de faire avec la premiere db ca pose pb car ca ne contiend pas le model mais l icon id ce qui est la meme chose au debut d ou mlon erreur mais qui change apres.
pour ce qui est du prix je crois pas que a y soit et je pense que le mieux c est de le prendre autre part.
sinon il y a les sources de mon petit script dans le post sur la db du craft (pas wip l autre) au tt debut je crois
Vive DOL vive DAOC
Image<-- j y etait a la 1ere mais aussi a la 2eme
Top
User avatar
Ghordjul
Demi-Dieu
Posts: 499
Joined: 12 Nov 2004, 22:46
Discord:

Unread post by Ghordjul »

@Kulgar : Comme dit sur IRC, j'ai les prix de revente pour le spellcraft uniquement, si je trouve autre chose, je posterai le fruit de mes recherches ici

@duff : Comme suggèré par Sp4M, on va d'abord faire un regroupement ici puis tout balancer sur Datadump histoire de pas flooder avec des données foireuses :wink:

En règle générale : Je garde ces valeurs-là pour l'instant ou bien je mets le prix de revente officiel ?
ImageImage
Darkpepper wrote:Il faut juste se rendre compte que même si ca va a l'encontre de certaines actions "plausibles" vous devez avant tout respecter chacunes des règles du serveur
Top
Locked

Return to “Aide au developpement”