"SERVER STUFF" LOOK HERE FOR SERVER HELP

Page 1 of 2 1 2
03/10/2009 04:17 str8killa#1
How to implement new items

Code:
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

Code:
Look thew shopset.csv
mysql2000

Code:
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

Code:
/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

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

you need a6
Sql commands

Code:
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

Code:
/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.
03/10/2009 05:25 SoulDeath9#2
nice should be handy for some people around here.. u'll prob get some idiots flaming you for this so yer >_>
03/10/2009 08:38 Deadman88#3
nice...good
03/10/2009 11:25 ItsNobody#4
its not mysql its mssql nub
03/10/2009 13:47 *P*A*U*L*#5
Quote:
Originally Posted by SoulDeath9 View Post
nice should be handy for some people around here.. u'll prob get some idiots flaming you for this so yer >_>
there we go:

Quote:
Originally Posted by ItsNobody View Post
its not mysql its mssql nub
03/10/2009 18:15 prox32#6
Ok how do you get the shop working? i got those files and yet when i click dshop nothing happends. Can someone help?
03/10/2009 20:06 gazu12#7
Same problem here so far i know it's server side problem ;p
03/10/2009 22:21 ItsNobody#8
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
03/10/2009 22:32 *P*A*U*L*#9
damn u! i wanted to post the same thingy:p this thread IS useless and theres better version of thread like that (zagzam posted it:p)
03/11/2009 00:46 wtfmang#10
is there a gm command to get items you want? like /GM dropitem or something?
03/11/2009 01:03 gazu12#11
there is command like u wrote but it's not working it's not active command so u can't use it in game
03/12/2009 00:24 wtfmang#12
how do you know what set it belongs to i get like weird letters and stuff like 2 ·¹º§ ¾ÆÀÌÅÛ
03/12/2009 01:35 ItsNobody#13
could a mod close this fucking thread
03/12/2009 01:57 prox32#14
Quote:
Originally Posted by ItsNobody View Post
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 ass jerk.
03/12/2009 04:20 ItsNobody#15
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?:rtfm:
Page 1 of 2 1 2