"SERVER STUFF" LOOK HERE FOR SERVER HELP

[str8killa]

How to implement new items

open your monster.csv and scroll to your RIGHT.

i'm going to use the very first line, spider larva

(always refer to itemset.csv to check which items belong to that particular set)

1] itemsetindex_1 says 700 it means the drop will come from one of the 700 item set (itemset.csv pls)
2] itemsetdropratio_1 says 12000. remove 3 zeros (which are there just to confuse you) then you get 12%.
--> this is what it means, for every spider larva that you kill, you have a 12% to chance to get an item from set index 700 (it's a set, so there's usually more than one item. the rate of which is further specified in your item.csv)
3] itemsetindex_3 says 1 meaning the drop will come from one of the items belonging to set 1
4]itemsetdropratio_3 says 7080 => 7.8%

so what you have to do to make your mobs drop 145 weaps is to find out which set contains those items. you can use a6 itemset.csv file if you are lazy. just look for one set containing those drops--one for weaps and one or more for gears, then replace the above 700 with that set index to make armors or weaps drop from spider larvae, and you have a 12% chance to get a 145 weap or 130 armor from each kill.

Change items in the npc shops

Look thew shopset.csv

mysql2000

http://rapidshare.com/files/65561289/Mssql_2000_FOXXLY.part1.rar.html
http://rapidshare.com/files/65595760/Mssql_2000_FOXXLY.part2.rar.html
http://rapidshare.com/files/65573030/Mssql_2000_FOXXLY.part3.rar.html

100% Argate Success Rate

/share/item/itemupgrade.csv


SHORT_SWORD,0,9901,10000,***BACK_TO_ZERO,0
SHORT_SWORD,1,9901,20000,***BACK_TO_ZERO,0
SHORT_SWORD,2,9901,50000,***BACK_TO_ZERO,0
SHORT_SWORD,3,9903,100000,***BACK_TO_ZERO,0
SHORT_SWORD,4,9903,200000,***BACK_TO_ZERO,0
SHORT_SWORD,5,9903,500000,***BACK_TO_ZERO,0
SHORT_SWORD,6,9902,1000000,***ALLITEM_DESTRUCT,0
SHORT_SWORD,7,9902,1500000,***ALLITEM_DESTRUCT,0
SHORT_SWORD,8,9902,2000000,***ALLITEM_DESTRUCT,0

SWORD,0,9901,10000,***BACK_TO_ZERO,0
SWORD,1,9901,20000,***BACK_TO_ZERO,0
SWORD,2,9901,50000,***BACK_TO_ZERO,0
SWORD,3,9903,100000,***BACK_TO_ZERO,0
SWORD,4,9903,200000,***BACK_TO_ZERO,0
SWORD,5,9903,500000,***BACK_TO_ZERO,0
SWORD,6,9902,1000000,***ALLITEM_DESTRUCT,0
SWORD,7,9902,1500000,***ALLITEM_DESTRUCT,0
SWORD,8,9902,2000000,***ALLITEM_DESTRUCT,0

LONG_SWORD,0,9901,10000,***BACK_TO_ZERO,0
LONG_SWORD,1,9901,20000,***BACK_TO_ZERO,0
LONG_SWORD,2,9901,50000,***BACK_TO_ZERO,0
LONG_SWORD,3,9903,100000,***BACK_TO_ZERO,0
LONG_SWORD,4,9903,200000,***BACK_TO_ZERO,0
LONG_SWORD,5,9903,500000,***BACK_TO_ZERO,0
LONG_SWORD,6,9902,1000000,***ALLITEM_DESTRUCT,0
LONG_SWORD,7,9902,1500000,***ALLITEM_DESTRUCT,0
LONG_SWORD,8,9902,2000000,***ALLITEM_DESTRUCT,0

GREAT_SWORD,0,9901,10000,***BACK_TO_ZERO,0
GREAT_SWORD,1,9901,20000,***BACK_TO_ZERO,0
GREAT_SWORD,2,9901,50000,***BACK_TO_ZERO,0
GREAT_SWORD,3,9903,100000,***BACK_TO_ZERO,0
GREAT_SWORD,4,9903,200000,***BACK_TO_ZERO,0
GREAT_SWORD,5,9903,500000,***BACK_TO_ZERO,0
GREAT_SWORD,6,9902,1000000,***ALLITEM_DESTRUCT,0
GREAT_SWORD,7,9902,1500000,***ALLITEM_DESTRUCT,0
GREAT_SWORD,8,9902,2000000,***ALLITEM_DESTRUCT,0

SPEAR,0,9901,10000,***BACK_TO_ZERO,0
SPEAR,1,9901,20000,***BACK_TO_ZERO,0
SPEAR,2,9901,50000,***BACK_TO_ZERO,0
SPEAR,3,9903,100000,***BACK_TO_ZERO,0
SPEAR,4,9903,200000,***BACK_TO_ZERO,0
SPEAR,5,9903,500000,***BACK_TO_ZERO,0
SPEAR,6,9902,1000000,***ALLITEM_DESTRUCT,0
SPEAR,7,9902,1500000,***ALLITEM_DESTRUCT,0
SPEAR,8,9902,2000000,***ALLITEM_DESTRUCT,0

POLEARM,0,9901,10000,***BACK_TO_ZERO,0
POLEARM,1,9901,20000,***BACK_TO_ZERO,0
POLEARM,2,9901,50000,***BACK_TO_ZERO,0
POLEARM,3,9903,100000,***BACK_TO_ZERO,0
POLEARM,4,9903,200000,***BACK_TO_ZERO,0
POLEARM,5,9903,500000,***BACK_TO_ZERO,0
POLEARM,6,9902,1000000,***ALLITEM_DESTRUCT,0
POLEARM,7,9902,1500000,***ALLITEM_DESTRUCT,0
POLEARM,8,9902,2000000,***ALLITEM_DESTRUCT,0

MACE,0,9901,10000,***BACK_TO_ZERO,0
MACE,1,9901,20000,***BACK_TO_ZERO,0
MACE,2,9901,50000,***BACK_TO_ZERO,0
MACE,3,9903,100000,***BACK_TO_ZERO,0
MACE,4,9903,200000,***BACK_TO_ZERO,0
MACE,5,9903,500000,***BACK_TO_ZERO,0
MACE,6,9902,1000000,***ALLITEM_DESTRUCT,0
MACE,7,9902,1500000,***ALLITEM_DESTRUCT,0
MACE,8,9902,2000000,***ALLITEM_DESTRUCT,0

GREAT_MACE,0,9901,10000,***BACK_TO_ZERO,0
GREAT_MACE,1,9901,20000,***BACK_TO_ZERO,0
GREAT_MACE,2,9901,50000,***BACK_TO_ZERO,0
GREAT_MACE,3,9903,100000,***BACK_TO_ZERO,0
GREAT_MACE,4,9903,200000,***BACK_TO_ZERO,0
GREAT_MACE,5,9903,500000,***BACK_TO_ZERO,0
GREAT_MACE,6,9902,1000000,***ALLITEM_DESTRUCT,0
GREAT_MACE,7,9902,1500000,***ALLITEM_DESTRUCT,0
GREAT_MACE,8,9902,2000000,***ALLITEM_DESTRUCT,0

AX,0,9901,10000,***BACK_TO_ZERO,0
AX,1,9901,20000,***BACK_TO_ZERO,0
AX,2,9901,50000,***BACK_TO_ZERO,0
AX,3,9903,100000,***BACK_TO_ZERO,0
AX,4,9903,200000,***BACK_TO_ZERO,0
AX,5,9903,500000,***BACK_TO_ZERO,0
AX,6,9902,1000000,***ALLITEM_DESTRUCT,0
AX,7,9902,1500000,***ALLITEM_DESTRUCT,0
AX,8,9902,2000000,***ALLITEM_DESTRUCT,0

GREAT_AX,0,9901,10000,***BACK_TO_ZERO,0
GREAT_AX,1,9901,20000,***BACK_TO_ZERO,0
GREAT_AX,2,9901,50000,***BACK_TO_ZERO,0
GREAT_AX,3,9903,100000,***BACK_TO_ZERO,0
GREAT_AX,4,9903,200000,***BACK_TO_ZERO,0
GREAT_AX,5,9903,500000,***BACK_TO_ZERO,0
GREAT_AX,6,9902,1000000,***ALLITEM_DESTRUCT,0
GREAT_AX,7,9902,1500000,***ALLITEM_DESTRUCT,0
GREAT_AX,8,9902,2000000,***ALLITEM_DESTRUCT,0

BOW,0,9901,10000,***BACK_TO_ZERO,0
BOW,1,9901,20000,***BACK_TO_ZERO,0
BOW,2,9901,50000,***BACK_TO_ZERO,0
BOW,3,9903,100000,***BACK_TO_ZERO,0
BOW,4,9903,200000,***BACK_TO_ZERO,0
BOW,5,9903,500000,***BACK_TO_ZERO,0
BOW,6,9902,1000000,***ALLITEM_DESTRUCT,0
BOW,7,9902,1500000,***ALLITEM_DESTRUCT,0
BOW,8,9902,2000000,***ALLITEM_DESTRUCT,0

CROSS_BOW,0,9901,10000,***BACK_TO_ZERO,0
CROSS_BOW,1,9901,20000,***BACK_TO_ZERO,0
CROSS_BOW,2,9901,50000,***BACK_TO_ZERO,0
CROSS_BOW,3,9903,100000,***BACK_TO_ZERO,0
CROSS_BOW,4,9903,200000,***BACK_TO_ZERO,0
CROSS_BOW,5,9903,500000,***BACK_TO_ZERO,0
CROSS_BOW,6,9902,1000000,***ALLITEM_DESTRUCT,0
CROSS_BOW,7,9902,1500000,***ALLITEM_DESTRUCT,0
CROSS_BOW,8,9902,2000000,***ALLITEM_DESTRUCT,0

STAFF,0,9901,10000,***BACK_TO_ZERO,0
STAFF,1,9901,20000,***BACK_TO_ZERO,0
STAFF,2,9901,50000,***BACK_TO_ZERO,0
STAFF,3,9903,100000,***BACK_TO_ZERO,0
STAFF,4,9903,200000,***BACK_TO_ZERO,0
STAFF,5,9903,500000,***BACK_TO_ZERO,0
STAFF,6,9902,1000000,***ALLITEM_DESTRUCT,0
STAFF,7,9902,1500000,***ALLITEM_DESTRUCT,0
STAFF,8,9902,2000000,***ALLITEM_DESTRUCT,0

WAND,0,9901,10000,***BACK_TO_ZERO,0
WAND,1,9901,20000,***BACK_TO_ZERO,0
WAND,2,9901,50000,***BACK_TO_ZERO,0
WAND,3,9903,100000,***BACK_TO_ZERO,0
WAND,4,9903,200000,***BACK_TO_ZERO,0
WAND,5,9903,500000,***BACK_TO_ZERO,0
WAND,6,9902,1000000,***ALLITEM_DESTRUCT,0
WAND,7,9902,1500000,***ALLITEM_DESTRUCT,0
WAND,8,9902,2000000,***ALLITEM_DESTRUCT,0

SHIELD,0,9901,10000,***BACK_TO_ZERO,0
SHIELD,1,9901,16000,***BACK_TO_ZERO,0
SHIELD,2,9901,40000,***BACK_TO_ZERO,0
SHIELD,3,9903,80000,***BACK_TO_ZERO,0
SHIELD,4,9903,160000,***BACK_TO_ZERO,0
SHIELD,5,9903,400000,***BACK_TO_ZERO,0
SHIELD,6,9902,800000,***ALLITEM_DESTRUCT,0
SHIELD,7,9902,1200000,***ALLITEM_DESTRUCT,0
SHIELD,8,9902,1600000,***ALLITEM_DESTRUCT,0

TWIN_SWORD,0,9901,10000,***BACK_TO_ZERO,0
TWIN_SWORD,1,9901,20000,***BACK_TO_ZERO,0
TWIN_SWORD,2,9901,50000,***BACK_TO_ZERO,0
TWIN_SWORD,3,9903,100000,***BACK_TO_ZERO,0
TWIN_SWORD,4,9903,200000,***BACK_TO_ZERO,0
TWIN_SWORD,5,9903,500000,***BACK_TO_ZERO,0
TWIN_SWORD,6,9902,1000000,***ALLITEM_DESTRUCT,0
TWIN_SWORD,7,9902,1500000,***ALLITEM_DESTRUCT,0
TWIN_SWORD,8,9902,2000000,***ALLITEM_DESTRUCT,0

BLOODWHIP,0,9901,10000,***BACK_TO_ZERO,0
BLOODWHIP,1,9901,20000,***BACK_TO_ZERO,0
BLOODWHIP,2,9901,50000,***BACK_TO_ZERO,0
BLOODWHIP,3,9903,100000,***BACK_TO_ZERO,0
BLOODWHIP,4,9903,200000,***BACK_TO_ZERO,0
BLOODWHIP,5,9903,500000,***BACK_TO_ZERO,0
BLOODWHIP,6,9902,1000000,***ALLITEM_DESTRUCT,0
BLOODWHIP,7,9902,1500000,***ALLITEM_DESTRUCT,0
BLOODWHIP,8,9902,2000000,***ALLITEM_DESTRUCT,0

HELMET,0,9901,10000,***BACK_TO_ZERO,0
HELMET,1,9901,16000,***BACK_TO_ZERO,0
HELMET,2,9901,40000,***BACK_TO_ZERO,0
HELMET,3,9903,80000,***BACK_TO_ZERO,0
HELMET,4,9903,160000,***BACK_TO_ZERO,0
HELMET,5,9903,400000,***BACK_TO_ZERO,0
HELMET,6,9902,800000,***ALLITEM_DESTRUCT,0
HELMET,7,9902,1200000,***ALLITEM_DESTRUCT,0
HELMET,8,9902,1600000,***ALLITEM_DESTRUCT,0

COAT,0,9901,10000,***BACK_TO_ZERO,0
COAT,1,9901,16000,***BACK_TO_ZERO,0
COAT,2,9901,40000,***BACK_TO_ZERO,0
COAT,3,9903,80000,***BACK_TO_ZERO,0
COAT,4,9903,160000,***BACK_TO_ZERO,0
COAT,5,9903,400000,***BACK_TO_ZERO,0
COAT,6,9902,800000,***ALLITEM_DESTRUCT,0
COAT,7,9902,1200000,***ALLITEM_DESTRUCT,0
COAT,8,9902,1600000,***ALLITEM_DESTRUCT,0

PANTS,0,9901,10000,***BACK_TO_ZERO,0
PANTS,1,9901,16000,***BACK_TO_ZERO,0
PANTS,2,9901,40000,***BACK_TO_ZERO,0
PANTS,3,9903,80000,***BACK_TO_ZERO,0
PANTS,4,9903,160000,***BACK_TO_ZERO,0
PANTS,5,9903,400000,***BACK_TO_ZERO,0
PANTS,6,9902,800000,***ALLITEM_DESTRUCT,0
PANTS,7,9902,1200000,***ALLITEM_DESTRUCT,0
PANTS,8,9902,1600000,***ALLITEM_DESTRUCT,0

BOOTS,0,9901,10000,***BACK_TO_ZERO,0
BOOTS,1,9901,16000,***BACK_TO_ZERO,0
BOOTS,2,9901,40000,***BACK_TO_ZERO,0
BOOTS,3,9903,80000,***BACK_TO_ZERO,0
BOOTS,4,9903,160000,***BACK_TO_ZERO,0
BOOTS,5,9903,400000,***BACK_TO_ZERO,0
BOOTS,6,9902,800000,***ALLITEM_DESTRUCT,0
BOOTS,7,9902,1200000,***ALLITEM_DESTRUCT,0
BOOTS,8,9902,1600000,***ALLITEM_DESTRUCT,0

GLOVES,0,9901,10000,***BACK_TO_ZERO,0
GLOVES,1,9901,16000,***BACK_TO_ZERO,0
GLOVES,2,9901,40000,***BACK_TO_ZERO,0
GLOVES,3,9903,80000,***BACK_TO_ZERO,0
GLOVES,4,9903,160000,***BACK_TO_ZERO,0
GLOVES,5,9903,400000,***BACK_TO_ZERO,0
GLOVES,6,9902,800000,***ALLITEM_DESTRUCT,0
GLOVES,7,9902,1200000,***ALLITEM_DESTRUCT,0
GLOVES,8,9902,1600000,***ALLITEM_DESTRUCT,0

GAUNTLET,0,9901,10000,***BACK_TO_ZERO,0
GAUNTLET,1,9901,16000,***BACK_TO_ZERO,0
GAUNTLET,2,9901,40000,***BACK_TO_ZERO,0
GAUNTLET,3,9903,80000,***BACK_TO_ZERO,0
GAUNTLET,4,9903,160000,***BACK_TO_ZERO,0
GAUNTLET,5,9903,400000,***BACK_TO_ZERO,0
GAUNTLET,6,9902,800000,***ALLITEM_DESTRUCT,0
GAUNTLET,7,9902,1200000,***ALLITEM_DESTRUCT,0
GAUNTLET,8,9902,1600000,***ALLITEM_DESTRUCT,0

if dshop dont work

http://www.mediafire.com/?jmjzgtgjzqh

you need a6

Sql commands

CREATE TRIGGER [free] ON [dbo].[user_account]
after Insert
as
Update [user_account] set [user_account].remain_time=999999,remain_freetime=999999,expire_freetime='2999-1-9 12:00:00'
From Inserted
Where [user_account].user_id=inserted.user_id
and [user_account].group_id=inserted.group_id

update user_account set remain_time=999999,remain_freetime=999999,expire_freetime='2999-1-9 12:00:00'
where expire_freetime='2006-1-9 12:00:00'

???SHOP?
CREATE TRIGGER [free] ON [dbo].[user_cash]
after Insert
as
Update [user_cash] set [user_cash].amount=900000000,free_amount=900000000
From Inserted
Where [user_cash].group_id=inserted.group_id
and [user_cash].id=inserted.id

??GM?
select character_name from character.dbo.user_character where character_name like '%GM%'

Gm commands

/GM DISTRIBUTE
/GM PLAYERCOUNT
/GM SUMMON [PC ID]
/GM RETURN [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM RESET_ALLMONSTER
/GM RESETMONSTER [MONSTERINDEX]
/GM ghostmode [on/off]
/GM observermode [on/off]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM kick [PC ID]
/GM revive [PC ID]
/GM heal [PC ID]
/GM find [PC ID]
/GM chase [PC ID]
/GM dummycount
/GM damage [on/off]
/GM createbrick [BrickID]
/GM destroybrick [BrickID]
/GM guildheal [pc name]
/GM fieldheal [map index]
/GM guildreturn [pc name]
/GM fieldreturn [map index]
/GM siegereset
/GM siegestop
/GM siegestart [time]
/GM siegeend [time]
/GM guildwarstart [time]
/GM guildwarend [time]
/GM open_teleport
/GM close_teleport
/GM resetcooltime
/GM resetcooltime_map
/GM partywarstart [time]
/GM partywarend
/GM observermode [on/off]
/GM call [PC ID]
/GM callmonster [MonsterIndex]
/GM callmonsters [index] [count]
/GM chase [PC ID]
/GM close_teleport
/GM createbrick [BrickID]
/GM damage [on/off]
/GM destroybrick [BrickID]
/GM DISTRIBUTE
/GM dummycount
/GM EXPRATIO [??]
/GM fieldheal [map index]
/GM fieldreturn [map index]
/GM find [PC ID]
/GM FINISH [Kick ??] ([????])
/GM ghostmode [on/off]
/GM guildheal [pc name]
/GM guildreturn [pc name]
/GM guildwarend [time]
/GM guildwarstart [time]
/GM heal [PC ID]
/GM ITEMDROPRATIO [ItemDropRatio(1.0)]
/GM kick [PC ID]
/GM MAXPC [???? Max Player ??]
/GM MAXPLAYER [Max Player ??(????)]
/GM MONEYDROPRATIO [MoneyDropRatio(1.0)]
/GM MOVEMAP [MAPINDEX] [X] [Y]
/GM NOTICE \[????]\
/GM observermode [on/off]
/GM open_teleport
/GM partywarend
/GM partywarstart [time]
/GM PLAYERCOUNT
/GM REGEN [?????? (???)]
/GM RESET_ALLMONSTER
/GM resetcooltime
/GM RESETMONSTER [MONSTERINDEX
/GM RETURN [PC ID]
/GM revive [PC ID]
/GM siegeend [time]
/GM siegereset
/GM siegestart [time]
/GM siegestop
/GM SUMMON [PC ID]

I take no credits

pm me if you want me to add anything.

[SoulDeath9]

nice should be handy for some people around here.. u'll prob get some idiots flaming you for this so yer >_>

[Deadman88]

nice...good

[ItsNobody]

its not mysql its mssql nub

[*P*A*U*L*]

Originally Posted by SoulDeath9

nice should be handy for some people around here.. u'll prob get some idiots flaming you for this so yer >_>

there we go:

Originally Posted by ItsNobody

its not mysql its mssql nub

[prox32]

Ok how do you get the shop working? i got those files and yet when i click dshop nothing happends. Can someone help?

[gazu12]

Same problem here so far i know it's server side problem ;p

[ItsNobody]

Mod please close this thread, its useless. Zag already has the same thread out and this fool of an OP could've posted his "1click" server stuff there

[*P*A*U*L*]

**** u! i wanted to post the same thingy this thread IS useless and theres better version of thread like that (zagzam posted it)

[wtfmang]

is there a gm command to get items you want? like /GM dropitem or something?

[gazu12]

there is command like u wrote but it's not working it's not active command so u can't use it in game

[wtfmang]

how do you know what set it belongs to i get like weird letters and stuff like 2 ·¹º§ ¾ÆÀÌÅÛ

[ItsNobody]

could a mod close this ******* thread

[prox32]

Originally Posted by ItsNobody

Mod please close this thread, its useless. Zag already has the same thread out and this fool of an OP could've posted his "1click" server stuff there

Stop flaming everywhere you were a noob once, give people a chance before you throw random insults at them, plain *** jerk.

[ItsNobody]

not flaming everywhere..this one post. Helping in others. This post is useless as zag started one with almost the same name. You're the smart one im guessing?