Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
hmp, added the npc and everythin is fine, but i cant seem to add items to that npc.. im getting crashed each time i try.
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
help me. i can't make a new group
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
NICE ! THIS IS WORKING FOR ME FINALLY !!
Quote:
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
(1 row(s) affected)
add this line to characterdata_45000 @ server_dep\silkroad\textdata
1 46377 JOAO xxx xxx SN_NPC_JOAO xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 npc\npc\chinawoman_Noblegirl_event.bsr xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Add this line to refshop.txt @ server_dep\silkroad\textdata
1 15 2645 STORE_JOAO -1 xxx -1 xxx -1 xxx -1 xxx
Add this line to refshopgroup.txt @ server_dep\silkroad\textdata
1 15 2818 GROUP_STORE_JOAO NPC_JOAO -1 xxx -1 xxx -1 xxx -1 xxx
Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata
1 87 STORE_JOAO_GROUP1 SN_STORE_JOAO_GROUP1
Add this line to refshoptab.txt @ server_dep\silkroad\textdata
1 15 6434 STORE_JOAO_TAB1 STORE_JOAO_GROUP1 SN_TAB_WEAPONS
Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata
1 15 2837 STORE_JOAO_GROUP1 SN_STORE_JOAO_GROUP1
Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata
1 15 GROUP_STORE_JOAO STORE_JOAO
Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata
1 15 STORE_JOAO STORE_JOAO_GROUP1
A New NPC Has ADD Succesfuly Restart U Server and Login in YacuZa
i added all lines in mediapk2 , but now my sroclient dont start, this just crash after click Start :S any help please?
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
Quote:
Originally Posted by
SupremeSRO
NICE ! THIS IS WORKING FOR ME FINALLY !!
i added all lines in mediapk2 , but now my sroclient dont start, this just crash after click Start :S any help please?
For each line you have to use the key "TAB" as space not just the usual " ". + Characterdata info is not correct - add it on ur own.
Still can't find out why I can't add items or even names to this npc :) seems that I am going to rebuild it on the hard way.......
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
thanks proxy1997 and arabianfox for their help and statiic for query
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
i m getting the follow error ------> CharID don't differ with link from RefObfChar
the querry worked 100% but when i go to stard my SR_Shard_Manager i get this error :/
any help?
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
add this line to characterdata_45000 @ server_dep\silkroad\textdata
1 47001 FantZero xxx xxx SN_NPC_FantZero xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 npc\npc\chinawoman_Noblegirl_event.bsr xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Add this line to refshop.txt @ server_dep\silkroad\textdata
1 15 90 STORE_FantZero -1 xxx -1 xxx -1 xxx -1 xxx
Add this line to refshopgroup.txt @ server_dep\silkroad\textdata
1 15 2816 GROUP_STORE_FantZero NPC_FantZero -1 xxx -1 xxx -1 xxx -1 xxx
Add this line to shopgroupdata.txt @ server_dep\silkroad\textdata
1 84 STORE_FantZero_GROUP1 SN_STORE_FantZero_GROUP1
Add this line to refshoptab.txt @ server_dep\silkroad\textdata
1 15 6429 STORE_FantZero_TAB1 STORE_FantZero_GROUP1 SN_TAB_WEAPONS
Add this line to refshoptabgroup.txt @ server_dep\silkroad\textdata
1 15 2834 STORE_FantZero_GROUP1 SN_STORE_FantZero_GROUP1
Add this line to refmappingshopgroup.txt @ server_dep\silkroad\textdata
1 15 GROUP_STORE_FantZero STORE_FantZero
Add this line to refmappingshopwithtab.txt @ server_dep\silkroad\textdata
1 15 STORE_FantZero STORE_FantZero_GROUP1
A New NPC Has ADD Succesfuly Restart U Server and Login in Fantasia
I've added this and client keeps crashing :|?
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
go Tools > Options... > Designers > and Clean "Prevent saving changes that require table re-creation" .
now
could u help me static :)
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
Error when run on 2005
Code:
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 13
Incorrect syntax near '+'.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 14
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 19
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 27
Must declare the scalar variable "@MAXLINK".
Msg 102, Level 15, State 1, Line 30
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 30
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@ShopID".
Msg 102, Level 15, State 1, Line 35
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 35
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 37
Must declare the scalar variable "@ShopGroupID".
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 40
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 42
Must declare the scalar variable "@ShopItemID".
Msg 102, Level 15, State 1, Line 45
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 45
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 47
Must declare the scalar variable "@ShopTabID".
Msg 102, Level 15, State 1, Line 50
Incorrect syntax near '('.
Msg 102, Level 15, State 1, Line 50
Incorrect syntax near '+'.
Msg 137, Level 15, State 2, Line 52
Must declare the scalar variable "@ShopTabGroupID".
Msg 137, Level 15, State 2, Line 58
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 75
Must declare the scalar variable "@MAXCOMMONID".
Msg 137, Level 15, State 2, Line 79
Must declare the scalar variable "@SHOPID".
Msg 137, Level 15, State 2, Line 83
Must declare the scalar variable "@SHOPGROUPID".
Msg 137, Level 15, State 2, Line 87
Must declare the scalar variable "@SHOPITEMID".
Msg 137, Level 15, State 2, Line 91
Must declare the scalar variable "@SHOPTABID".
Msg 137, Level 15, State 2, Line 95
Must declare the scalar variable "@SHOPTABGROUPID".
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
the Query give my only this msg
Command(s) completed successfully.
where the line of media :w00t:
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
Quote:
Originally Posted by
nandoloanda
i m getting the follow error ------> CharID don't differ with link from RefObfChar
the querry worked 100% but when i go to stard my SR_Shard_Manager i get this error :/
any help?
Same By Me any one Know how to fix this?
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
Quote:
Originally Posted by
proxy1997
For each line you have to use the key "TAB" as space not just the usual " ". + Characterdata info is not correct - add it on ur own.
Still can't find out why I can't add items or even names to this npc :) seems that I am going to rebuild it on the hard way.......
Client crash after add succesfully NPC in db
Dont know what you mean to do... pls help me
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
I've notice one thing...
The red letters are missing, so ADD THEM!! if you're not sure what to add, check refobjcommon what it says there!
if you add the lines, it'll say you have to add some lines to media, check the line for chardata
Quote:
1 91919 NPC_Myseriacoin xxx xxx SN_NPC_Myseriacoin xxx 0 1 1 2 2 0 5000 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 npc\npc\chinawoman_Noblegirl_event.bsr xxx xxx xxx xxx 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 336860180 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
Msg 8101, Level 16, State 1, Line 56
An explicit value for the identity column in table 'Tab_RefTactics' can only be specified when a column list is used and IDENTITY_INSERT is ON.
its already ON
Re: NPC Query Add u own NPC in 3 Minutes + ADD New Tab and Group ^^
help please
Msg 8101, Level 16, State 1, Line 65
An explicit value for the identity column in table 'Tab_RefTactics' can only be specified when a column list is used and IDENTITY_INSERT is ON.