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.

help me. i can't make a new 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?

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.......

thanks proxy1997 and arabianfox for their help and statiic for query

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?

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

go Tools > Options... > Designers > and Clean "Prevent saving changes that require table re-creation" .
now

could u help me static :)

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".

---

the Query give my only this msg
Command(s) completed successfully.

where the line of media :w00t:

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?

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

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

---

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

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.