Help for fixed senior

Hey senior here i have a big problem, maybe very big for me ,, this is my problem i really need senior help to find where the point is its problem, why all equip and inventory bag disappear every time re-login, my friend say in script xamp htdocs And I also change it to the initial script and I test again was still so help sir:handsdown::handsdown::handsdown:

So you either want "Senior help" or "Help with your server" which one is it you cant have both.

I try to find where the point of his problem many say in the database, but I do not know where the error was to fix

For some Bucks im sure someone will help you :)

Check Store Procedure of RohanGame. the one with EndGame. check if there is a Delete Query on it. :v You should explore more on database.

USE [RohanGame]
GO
/****** Object: StoredProcedure [dbo].[ROHAN_EndGame] Script Date: 07/16/2017 04:47:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO







ALTER PROCEDURE [dbo].[ROHAN_EndGame]
@[Only registered and activated users can see links. Click Here To Register...]_id int
AS
set nocount on

declare @[Only registered and activated users can see links. Click Here To Register...] int
declare @[Only registered and activated users can see links. Click Here To Register...]pe int
declare @[Only registered and activated users can see links. Click Here To Register...]sec int
declare @[Only registered and activated users can see links. Click Here To Register...] int

--아이템 가상 처리
update titem set type = @[Only registered and activated users can see links. Click Here To Register...]_id where id = 0
update tcharacterlogin set
last_date = getdate()
,login = 0
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

select @[Only registered and activated users can see links. Click Here To Register...] = [level]
from tcharacterability
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

select @[Only registered and activated users can see links. Click Here To Register...]pe = [ctype_id]
from tcharacter
where id = @[Only registered and activated users can see links. Click Here To Register...]_id


if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 196993)
begin
update tcharacter set ctype_id = 196994 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 196869)
begin
update tcharacter set ctype_id = 196870 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197133)
begin
update tcharacter set ctype_id = 197134 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197257)
begin
update tcharacter set ctype_id = 197258 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197653)
begin
update tcharacter set ctype_id = 197654 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 197777)
begin
update tcharacter set ctype_id = 197778 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 198685)
begin
update tcharacter set ctype_id = 198686 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end


if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 198809)
begin
update tcharacter set ctype_id = 198810 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 200741)
begin
update tcharacter set ctype_id = 200742 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 200865)
begin
update tcharacter set ctype_id = 200866 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 204845)
begin
update tcharacter set ctype_id = 204846 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 204969)
begin
update tcharacter set ctype_id = 204970 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 229437)
begin
update tcharacter set ctype_id = 229438 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

if @[Only registered and activated users can see links. Click Here To Register...] >= 50) and @[Only registered and activated users can see links. Click Here To Register...]pe= 229561)
begin
update tcharacter set ctype_id = 229562 where id = @[Only registered and activated users can see links. Click Here To Register...]_id
end

select @[Only registered and activated users can see links. Click Here To Register...]sec = play_sec
from TCharacterLogin
where char_id = @[Only registered and activated users can see links. Click Here To Register...]_id

exec @[Only registered and activated users can see links. Click Here To Register...] = LOCAL_InsTCharacterLogin @[Only registered and activated users can see links. Click Here To Register...]_id

if @@error <> 0 or @@rowcount <> 1 return -1

--return 0


commit

--------------------------------------
return @[Only registered and activated users can see links. Click Here To Register...]
----------------------------------------------------
-- Error Process
----------------------------------------------------
ERR:
rollback
return @[Only registered and activated users can see links. Click Here To Register...]


and


Something wrong? : v

Quote:

Originally Posted by Vicky Blazz Hey senior here i have a big problem, maybe very big for me ,, this is my problem i really need senior help to find where the point is its problem, why all equip and inventory bag disappear every time re-login, my friend say in script xamp htdocs And I also change it to the initial script and I test again was still so help sir:handsdown::handsdown::handsdown:

You got hacked .
Someone inject your 5101 or password change script .
then delete from rohangame.dbo.titems
Use protected 5101 or password script .
and be carefull with spam register exploit

Quote:

Originally Posted by ammadpurba You got hacked . Someone inject your 5101 or password change script . then delete from rohangame.dbo.titems Use protected 5101 or password script . and be carefull with spam register exploit

[Only registered and activated users can see links. Click Here To Register...]

And if I delete this will run normally again?

Sure. delete that table. That should fix you.

Quote:

Originally Posted by im batman Sure. delete that table. That should fix you.

When I insert the 5101, another script becomes non-functioning, whether there is a solution for this or any other

Look [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by Vicky Blazz When I insert the 5101, another script becomes non-functioning, whether there is a solution for this or any other Look [Only registered and activated users can see links. Click Here To Register...]

Stop going to make a Server, you fail at Simple add your SQL Stuff on a Config.
Take your Time for make a Server and dont rush.

lol

Quote:

Originally Posted by RitoYuuki Stop going to make a Server, you fail at Simple add your SQL Stuff on a Config. Take your Time for make a Server and dont rush.

This is the best advice to all new DEV.