NPC Crush

01/23/2015 02:06 !Ego#1

Guy's i finally added a NPC right now !
and iam sure 1000000% from the media and SQL lines
the SR_GameServer doesn't give me any errors...
but i restarted my PC before i open the client to make sure that the NPC added
So now when i open the client the start Loading Image appear then Crush !

How can i fix that ? :(

01/23/2015 02:25 MissinGDeaTh#2

Quote:

Originally Posted by BuiLt4KiLl

Guy's i finally added a NPC right now !
and iam sure 1000000% from the media and SQL lines
the SR_GameServer doesn't give me any errors...
but i restarted my PC before i open the client to make sure that the NPC added
So now when i open the client the start Loading Image appear then Crush !

How can i fix that ? :(

something wrong with media lines, btw if u used the query. it wont work do it manually it's better..

01/23/2015 02:27 !Ego#3

bro the crush doesn't happen when iam into the server it happens when the start loading photo appered the small one before i log in to the account

Thx man i found the error on CharData It was ARABIA only
it must be NPC_ARABIA
whish it work

01/23/2015 03:32 asanoftw#4

remove npc query if still crashing.

PHP Code:


			
delete from Tab_RefNest
where dwTacticsID=(Select dwTacticsID from Tab_RefTactics where dwObjID='12345') 



SELECT *FROM _RefObjCOmmon WHERE CodeName128 LIKE '%NAME%'

26-Search Char IP
select CharName16 from _Char where CharID in (select CharID from _User where UserJID in (select (JID) from SRO_VT_ACCOUNT.dbo.TB_User where reg_ip = '127.0.0.1'))

27-Select Line From Any Table
SELECT *FROM _RefPackageItem WHERE CodeName128 like '%ITEM_EVENT_REVERSE_RETURN_SCROLL%'


SELECT *FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%ITEM_EVENT_REVERSE_RETURN_SCROLL%'

PHP Code:


			
delete from Tab_RefNest
where dwTacticsID=(Select dwTacticsID from Tab_RefTactics where dwObjID='12345') 



SELECT *FROM _RefObjCOmmon WHERE CodeName128 LIKE '%NAME%'

26-Search Char IP
select CharName16 from _Char where CharID in (select CharID from _User where UserJID in (select (JID) from SRO_VT_ACCOUNT.dbo.TB_User where reg_ip = '127.0.0.1'))

27-Select Line From Any Table
SELECT *FROM _RefPackageItem WHERE CodeName128 like '%ITEM_EVENT_REVERSE_RETURN_SCROLL%'


SELECT *FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName like '%ITEM_EVENT_REVERSE_RETURN_SCROLL%'