any answer fastt for my proplem

09/02/2015 15:02 geraya.sama#1
hi all gauz

i have proplem
i use client (BuleSRO) make char but when i make star
i tak crash form Game can any answer
i open jangan . and frist city to Euro onley and other colsed
09/03/2015 06:29 Aaron*#2
It's simple. The start items includes an item which is either disabled in db or it has a custom item which is disabled/not existing in "BULESRO" media.
09/03/2015 07:39 geraya.sama#3
how i can fixed it
and char star lvl 1 onley
09/03/2015 07:50 !Ego#4
Just go to Programmability>Stored Produce>_AddNewChar
and scroll down till you find a lines start with : exec _ADD_ITEM_EXTERN
then delete all these lines
and check out your client !

We're waiting your reply !
09/03/2015 15:27 geraya.sama#5
in frist thx for answer

sec: im new in made private sever (i open all you step but i cant make any thing )
can make some photo or make simple vido to understand you
thx i w8 your photo or vido
09/04/2015 18:42 Equinox,#6
use this query
update _inventory set itemid=0
09/04/2015 22:34 Royalblade*#7
use this query.

Credits: StackOverflow. 3 sec google search. 2nd hit.
Quote:
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where type = 'p'
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
exec('drop procedure ' + @procName)
fetch next from cur into @procName
end
close cur
deallocate cur
09/05/2015 02:48 LastThief*#8
or maybe it's due to bugged item, use this DELETE FROM _Items
09/05/2015 04:28 Aaron*#9
Quote:
Originally Posted by Royalblade* View Post
use this query.

Credits: StackOverflow. 3 sec google search. 2nd hit.
This query will work. Use it and restart server and it'll work properly.
PS: Don't forget to use this one as well.
Quote:
DROP DATABASE SRO_VT_SHARD
09/05/2015 07:57 Royalblade*#10
Quote:
Originally Posted by LastThief* View Post
or maybe it's due to bugged item, use this DELETE FROM _Items
Will fail cuz of foreign keys. Y u no help him properly bro? XD

Quote:
Originally Posted by Leonius* View Post
This query will work. Use it and restart server and it'll work properly.
PS: Don't forget to use this one as well.
Will fail cuz DB in use. Y u no help him properly bro? XD
09/05/2015 09:26 ​Exo#11
The number of trolls in this thread is too damn high!
09/05/2015 11:39 LastThief*#12
Quote:
Originally Posted by Royalblade* View Post
Will fail cuz of foreign keys. Y u no help him properly bro? XD



Will fail cuz DB in use. Y u no help him properly bro? XD
But but :(.. ;(
09/06/2015 05:09 ​Exo#13
kk *being serious now*

1st, there's no magical fix for this issue. All you can do is, extract your PK2, find custom entries and remove them. Also keep checking dmp files.
09/11/2015 04:22 omar2002#14
if u r new at prv sro . iadvise u to get a clean client and db .