Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 08:24

  • Please register to post and access all features, it's quick, easy and FREE!

 

Help for fixed senior

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
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



Vicky Blazz is offline  
Old   #2
 
elite*gold: 0
Join Date: Jul 2014
Posts: 766
Received Thanks: 357
So you either want "Senior help" or "Help with your server" which one is it you cant have both.


DretoNEX is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
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
Vicky Blazz is offline  
Old   #4
 
elite*gold: 31
Join Date: Feb 2016
Posts: 519
Received Thanks: 154
For some Bucks im sure someone will help you


RitoYuuki is offline  
Old   #5
 
elite*gold: 0
Join Date: Jun 2016
Posts: 59
Received Thanks: 8
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.
deviling124 is offline  
Thanks
1 User
Old   #6
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
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]
@Char_id int
AS
set nocount on

declare @level int
declare @ctype int
declare @play_sec int
declare @ReT int

--아이템 가상 처리
update titem set type = @Char_id where id = 0
update tcharacterlogin set
last_date = getdate()
,login = 0
where char_id = @Char_id

select @level = [level]
from tcharacterability
where char_id = @Char_id

select @ctype = [ctype_id]
from tcharacter
where id = @Char_id


if @level >= 50) and @ctype= 196993)
begin
update tcharacter set ctype_id = 196994 where id = @Char_id
end

if @level >= 50) and @ctype= 196869)
begin
update tcharacter set ctype_id = 196870 where id = @Char_id
end

if @level >= 50) and @ctype= 197133)
begin
update tcharacter set ctype_id = 197134 where id = @Char_id
end

if @level >= 50) and @ctype= 197257)
begin
update tcharacter set ctype_id = 197258 where id = @Char_id
end

if @level >= 50) and @ctype= 197653)
begin
update tcharacter set ctype_id = 197654 where id = @Char_id
end

if @level >= 50) and @ctype= 197777)
begin
update tcharacter set ctype_id = 197778 where id = @Char_id
end

if @level >= 50) and @ctype= 198685)
begin
update tcharacter set ctype_id = 198686 where id = @Char_id
end


if @level >= 50) and @ctype= 198809)
begin
update tcharacter set ctype_id = 198810 where id = @Char_id
end

if @level >= 50) and @ctype= 200741)
begin
update tcharacter set ctype_id = 200742 where id = @Char_id
end

if @level >= 50) and @ctype= 200865)
begin
update tcharacter set ctype_id = 200866 where id = @Char_id
end

if @level >= 50) and @ctype= 204845)
begin
update tcharacter set ctype_id = 204846 where id = @Char_id
end

if @level >= 50) and @ctype= 204969)
begin
update tcharacter set ctype_id = 204970 where id = @Char_id
end

if @level >= 50) and @ctype= 229437)
begin
update tcharacter set ctype_id = 229438 where id = @Char_id
end

if @level >= 50) and @ctype= 229561)
begin
update tcharacter set ctype_id = 229562 where id = @Char_id
end

select @play_sec = play_sec
from TCharacterLogin
where char_id = @Char_id

exec @ReT = LOCAL_InsTCharacterLogin @Char_id

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

--return 0


commit

--------------------------------------
return @ReT
----------------------------------------------------
-- Error Process
----------------------------------------------------
ERR:
rollback
return @ReT


and


Something wrong? : v
Vicky Blazz is offline  
Old   #7
 
elite*gold: 0
Join Date: Nov 2012
Posts: 576
Received Thanks: 47
Quote:
Originally Posted by Vicky Blazz View Post
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
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
Attached Files
File Type: rar 5101.rar (114.5 KB, 20 views)
ammadpurba is offline  
Thanks
1 User
Old   #8
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
thank's ammadpurba

Quote:
Originally Posted by ammadpurba View Post
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
You must register and activate your account in order to view images.

And if I delete this will run normally again?
Vicky Blazz is offline  
Old   #9
 
elite*gold: 0
Join Date: Apr 2015
Posts: 842
Received Thanks: 490
Sure. delete that table. That should fix you.
im batman is offline  
Old   #10
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
Quote:
Originally Posted by im batman View Post
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 You must register and activate your account in order to view images.
Vicky Blazz is offline  
Old   #11
 
elite*gold: 31
Join Date: Feb 2016
Posts: 519
Received Thanks: 154
Quote:
Originally Posted by Vicky Blazz View Post
When I insert the 5101, another script becomes non-functioning, whether there is a solution for this or any other

Look You must register and activate your account in order to view images.
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.
RitoYuuki is offline  
Thanks
1 User
Old   #12
 
elite*gold: 0
Join Date: Jul 2017
Posts: 10
Received Thanks: 0
lol
Vicky Blazz is offline  
Old   #13
 
elite*gold: 0
Join Date: Jun 2016
Posts: 59
Received Thanks: 8
Quote:
Originally Posted by RitoYuuki View Post
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.


deviling124 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
help senior
how to edit character GM :rtfm:
3 Replies - Rohan
senior help me newbie
how to send items to all players on / off
1 Replies - Rohan
[HELP] Vampire Job. ( Senior Please Visit )
Hello All Owner PS EO. I need your help all. anyone can help me? on how to enter the job vampire on my eo server. so far I can only make the...
8 Replies - EO PServer Hosting
senior help me to hack +10 refine 100% success
im newbie maybe some one can teach me how to make +10 refine 100% success all equipment at private server...pliss thx before :D:D
1 Replies - Ragnarok Online



All times are GMT +1. The time now is 08:24.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.