Register for your free account! | Forgot your password?

You last visited: Today at 07:04

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

Advertisement



Dupe Fix Char Overwrite

Discussion on Dupe Fix Char Overwrite within the Flyff PServer Guides & Releases forum part of the Flyff Private Server category.

Closed Thread
 
Old   #1
 
Pumaaa's Avatar
 
elite*gold: 0
Join Date: Sep 2008
Posts: 569
Received Thanks: 695
Dupe Fix Char Overwrite

1337 Haxx0rZ on the run.




DB > CHARACTER_STR

Finden:
PHP Code:
IF @iGu 'I1' -- 초기 정보 입력
    
BEGIN
    
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
          WHERE  lower
(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
        
BEGIN
            SELECT  fError 
'0'fText '캐릭터 중복!' 
            
RETURN
        
END
    
ELSE 
Ersetzen mit:

PHP Code:
IF @iGu 'I1'
    
BEGIN
    
IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
          WHERE 
(( lower(m_szName) = lower(@im_szName) ) OR (playerslot = @iPlayerslot AND account = @iaccount  ) ) AND isblock 'F' AND serverindex = @iserverindex )
        
BEGIN
            SELECT  fError 
'0'fText 'Error 1!' 
            
RETURN
        
END
    
ELSE 
Pumaaa is offline  
Thanks
8 Users
Old 09/25/2013, 20:35   #2



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Ist das dein ernst?
Das einzige was du hier gemacht hast ist die Abfrage leicht abändern mit dem selben Sinn wie das, was ich bereits gepostet habe.

Sedrika is offline  
Thanks
2 Users
Old 09/25/2013, 20:39   #3
 
Pumaaa's Avatar
 
elite*gold: 0
Join Date: Sep 2008
Posts: 569
Received Thanks: 695
Quote:
Originally Posted by Sago​ View Post
Ist das dein ernst?
Das einzige was du hier gemacht hast ist die Abfrage leicht abändern mit dem selben Sinn wie das, was ich bereits gepostet habe.

Deinen Fix habe ich wohl übersehen.

Das Ding steht schon ewig so bei mir in der DB drinne.

Man merke an ohne die lower() weil die für mich uninteressant sind.
Pumaaa is offline  
Thanks
1 User
Old 09/25/2013, 20:42   #4



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Ob lower oder nicht spielt keine Rolle. Es wird beim Text nicht auf Case Sensitive geachtet.

Sedrika is offline  
Old 09/25/2013, 20:50   #5
 
Pumaaa's Avatar
 
elite*gold: 0
Join Date: Sep 2008
Posts: 569
Received Thanks: 695
Nur wenn die Collation nicht Case Sensitive ist.
Pumaaa is offline  
Old 09/25/2013, 21:02   #6



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Quote:
Originally Posted by Pumaaa View Post
Nur wenn die Collation nicht Case Sensitive ist.
Eigendlich schon, allerdings ist die Collate von der Character tabelle Latin1_General_CI_AS und damit Insensitive.
Sedrika is offline  
Old 09/25/2013, 21:02   #7
 
elite*gold: 0
Join Date: Mar 2013
Posts: 157
Received Thanks: 15
was ist diese Char Overwrite? habe es bei mir eingefügt aber as bringt es XD
NativeGermany is offline  
Old 09/25/2013, 21:05   #8



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Quote:
Originally Posted by NativeGermany View Post
was ist diese Char Overwrite? habe es bei mir eingefügt aber as bringt es XD
Damit kann man keinen char auf einen bereits existierenden character erstellen, welches zum Dupen genutzt werden kann.
Sedrika is offline  
Old 09/25/2013, 21:07   #9
 
elite*gold: 0
Join Date: Mar 2013
Posts: 157
Received Thanks: 15
also z.B. das mein char Native heißt und ich ihn auswähle und auf Neu Drücke? oder wie meist du das?
NativeGermany is offline  
Old 09/25/2013, 21:13   #10



 
Sedrika's Avatar
 
elite*gold: 18
The Black Market: 103/0/0
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
Nein, eher durch absenden falscher Informationen.
Sedrika is offline  
Old 09/25/2013, 22:48   #11
 
Roxez's Avatar
 
elite*gold: 34
Join Date: Jan 2012
Posts: 318
Received Thanks: 92
Auch wenn der Fix schon released wurde, trotzdem danke an Pumaaa. Dadurch weiß ich jetzt erst das es einen solchen Bug gibt. Danke nochmal!
Roxez is offline  
Old 09/26/2013, 16:18   #12

 
elite*gold: 28
Join Date: Feb 2010
Posts: 463
Received Thanks: 277
Others Fix :

Code:
IF @iGu = 'I1' -- ?? ?? ??
	BEGIN
            if exists(select playerslot from CHARACTER_TBL where account = @iaccount and playerslot = 0 and isblock = 'F')
			if exists(select playerslot from CHARACTER_TBL where account = @iaccount and playerslot = 1 and isblock = 'F')
			if exists(select playerslot from CHARACTER_TBL where account = @iaccount and playerslot = 2 and isblock = 'F')
  begin
   select fError = '0', fText = 'Slot belegt!'
   return
  end
  
 declare @i1_cnt int  
 select @i1_cnt = count(*) from CHARACTER_TBL where account = @iaccount and isblock = 'F'  
 if @i1_cnt > 2  
 begin  
  SELECT  fError = '0', fText = 'Too many chars!'   
  RETURN  
 end
 
	IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
		  WHERE  lower(m_szName) = lower(@im_szName) AND serverindex = @iserverindex)
		BEGIN
			SELECT  fError = '0', fText = '??? ??!' 
			RETURN
		END
	ELSE
ZeroTwo02 is offline  
Thanks
1 User
Closed Thread


Similar Threads Similar Threads
visual basic download and Overwrite Existing Files
11/01/2009 - Silkroad Online - 0 Replies
anyone can help me out here i need a code i can use to make a program with VB. im a noob at this but i dont need that much code i have see it on youtube how to download a file from the internet, but i dont have the code for the overwrite the existing file. Could not find it there. anyone can help me out with this? this is the part to download the file YouTube - VB.NET - How to Download a File Online - ( EASY TUTORIAL ) simple code
[POLICY EXPLOIT] Dupe Your Char/Items/Equipment (Live Server)
09/23/2007 - WoW Exploits, Hacks, Tools & Macros - 19 Replies
**** WARNING: DO THIS AT YOUR OWN RISK! **** First, a couple things you need to understand: 1. GMs are simply "Chat Agents" working from an interface at their PCs to interact with virtual characters (ie, the customer). 2. GMs are over-worked, underpaid, and generally apathetic. But they're genuinely nice and their job after all is customer service. 3. GMs do not have readily available access to highly detailed Transfer/Deletion/Character logs, however they _can_ submit Character...
[FIXED!] Dupe , Char Dupe , Char Load
01/07/2007 - Kal Online - 20 Replies
FIXED hi , naja .... da ich eh kein bock mehr auf kal hab mach ich mal wieder was pub .. Startet euer Kal .. einfach über Run .. oder added die paragraphen ... C:\Programme\KalOnline&#092 ;engine.exe /load /config test2



All times are GMT +1. The time now is 07:04.


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.