- Joined
- Feb 13, 2011
- Messages
- 772
- Reaction score
- 69
Card Piece go to Event Inventory. Checked there too?
where is it located bro?
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!Card Piece go to Event Inventory. Checked there too?
where is it located bro?
bro did you try to make EXC ACCIENT DROPS in land of trials?
Backread tol, nireplayan kita.
ive done your tutorial but still wont work
and i did try like arena maps it works
but when i change to map ip lost of trials it wont work
i think its a bug because lost of trials is in castle siege server not in main server!
or maybe have other config?
try to do it to you map 31 accient drops but it wont EXC ACCIENT!
what are using client sir ? share plisDid anyone know where to find data/info inf SQL Databse for Fruit Points count like in this picture?
in Character Table FruitPoints is for Decrease, how about for Increase which Table and Column?
thanks.
How to make auto zen 2 M and skill point for newly created character sir ?
CREATE TRIGGER [ganjA] ON [dbo].[Character]
AFTER INSERT
AS
update character set
Money = [COLOR="#FF0000"]ZenYouWant[/COLOR],
[COLOR="#0000FF"]LevelUpPoint = LevelUpPointsYouWant[/COLOR]
from inserted where character.name = inserted.name
okey sorry sir ..Next time pls do use search button or you may google it but anyways..
Insert in Query Analizer MuOnline :
Code:CREATE TRIGGER [ganjA] ON [dbo].[Character] AFTER INSERT AS update character set Money = [COLOR="#FF0000"]ZenYouWant[/COLOR], [COLOR="#0000FF"]LevelUpPoint = LevelUpPointsYouWant[/COLOR] from inserted where character.name = inserted.name
Code above is when creating character it will have a Starting Zen With Starting Level Up Points or just simply remove the blue one if you dont wat to add a level up points for a new character.
Note:
Be careful what you trigger, make sure you know what to do or at least make a backup on your files just in case somethings wrong in every queries you are trying to make. And the above code is works fine for me i just removed some lines that i didnt needed from the original post.
Its still works fine for me even i changed it to map 31 and in my case i used Erohim to drop ancient items. Btw may i see your config?
<SetItemDropManager DropUseRate="50000">
<Rule MonsterIndex="-1" MonsterMinLevel="1" MonsterMaxLevel="150" PlayerMinLevel="1" PlayerMaxLevel="MAX" MapNumber="31">
<ItemDrop Cat="-1" MinLevel="1" MaxLevel="1" Count="1" Skill="1" Luck="1" Option="7" Exc="63" DropRate="50000" />
</Rule>
</SetItemDropManager>
heres my code!
some wrong with it ?
<SetItemDropManager DropUseRate="[COLOR="#0000FF"]300000[/COLOR]">
<Rule MonsterIndex="[COLOR="#FF0000"]294[/COLOR]" MonsterMinLevel="1" MonsterMaxLevel="150" PlayerMinLevel="1" PlayerMaxLevel="MAX" MapNumber="[COLOR="#00FF00"]31[/COLOR]"> -->
<ItemDrop Cat="-1" MinLevel="1" MaxLevel="1" Count="5" Skill="1" Luck="1" Option="7" Exc="63" DropRate="50" /> -->
</Rule>
</SetItemDropManager>
Your Drop Rate was too low and Its not gonna work if you chose a random monster on a specific map, system cant read it i dont know. however if you chose a specific monster on a specific map or random monster to random map it'll work, but you need to increase the drop rate system... anyways try this one.
Code:<SetItemDropManager DropUseRate="[COLOR="#0000FF"]300000[/COLOR]"> <Rule MonsterIndex="[COLOR="#FF0000"]294[/COLOR]" MonsterMinLevel="1" MonsterMaxLevel="150" PlayerMinLevel="1" PlayerMaxLevel="MAX" MapNumber="[COLOR="#00FF00"]31[/COLOR]"> --> <ItemDrop Cat="-1" MinLevel="1" MaxLevel="1" Count="5" Skill="1" Luck="1" Option="7" Exc="63" DropRate="50" /> --> </Rule> </SetItemDropManager>
Blue = Chance rate of using drop from the system, 1m is Max
Red = Ax Warrior (From LOT)
31 = Land Of Trial
Drop is for any Tier 1/2 Items with Exc Full Options and the chances you get from Ax Monster is in every 4-8 kills from them.
You must be registered to see links
Hope it helps...
bro's someone wants to help me, To add quest items for SHop? share your shop code pls
<?xml version="1.0" encoding="utf-8"?>
<!--
// ============================================================
// == INTERNATIONAL GAMING CENTER NETWORK
// ==You must be registered to see links
// == (C) 2010-2015 IGC-Network (R)
// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
// == File is a part of IGCN Group MuOnline Server files.
// ============================================================
//
// ### Shop::Item ###
// Cat: Category of an item - refer to '\IGCData\Items\ItemList.xml'
// Index: Index of an Item - refer to '\IGCData\Items\ItemList.xml'
// Level: Level of an item, 0-15
// Durability: Durability of an item, 0-255 - NOTE: some Items max durability is lower than maximum possible of 255
// Skill: Apply skill to item, 0/1
// Luck: Apply Luck on item, 0/1
// Option: 0-7 (Opt * 4, example, Opt -> 7 * 4 = Item Option +28
// Exc: 0: No Exc options, or sum of below values (63 - Full of Excellent):
// ~ 1: Mana recovery after Monster hunt +Mana/8
// ~ 2: Health recovery after Monster hunt +HP/8
// ~ 4: +7 Speed
// ~ 8: More Damage +2%
// ~ 16: More Damage +Level/20
// ~ 32: Excellent Damage Rate +10%
// SetItem (item must be added to set items (ancients), otherwise option will be ignored:
// ~ 0: No Ancient
// ~ 5: First Set type (+5 Stamina)
// ~ 6: Second Set type (+5 Stamina)
// ~ 9: First Set type (+10 Stamina)
// ~ 10: Second Set type (+10 Stamina)
// SocketCount: Count of Sockets for socket item, values: 0-5
// Elemental: Element type for elemental items: 0 ~ no Elemental Attribute, 1 ~ Fire, 2 ~ Water, 3 ~ Earth, 4 ~ Wind, 5 ~ Darkness - option ignored for S6E3
// Serial: Generate serial for the shop item, 0/1
//
// STRICTLY NO COMMENTS INSIDE TAGS
-->
<Shop>
<Item Cat="14" Index="37" Level="15" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="40" Level="15" Durability="200" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="64" Level="15" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="26" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="23" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="24" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="24" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="66" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="65" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="67" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="25" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="23" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="2" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="3" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="4" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="5" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="6" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="19" Level="7" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="2" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="3" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="4" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="5" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="6" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="7" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="8" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="111" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="51" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="51" Level="2" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="51" Level="3" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="51" Level="4" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="18" Level="5" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="1" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="2" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="3" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="4" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="5" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="6" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="28" Level="7" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="102" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="121" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="155" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="68" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="42" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="43" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="44" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="12" Index="15" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="14" Index="53" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
<Item Cat="13" Index="38" Level="0" Durability="0" Skill="0" Luck="0" Option="0" Exc="0" SetItem="0" SocketCount="0" Elemental="0" Serial="0" />
</Shop>
heres my code lumen barmain bar
A question: is the database restored or attached in sql?