|
You last visited: Today at 07:04
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.
09/25/2013, 20:22
|
#1
|
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
|
|
|
09/25/2013, 20:35
|
#2
|
elite*gold: 18
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.
|
|
|
09/25/2013, 20:39
|
#3
|
elite*gold: 0
Join Date: Sep 2008
Posts: 569
Received Thanks: 695
|
Quote:
Originally Posted by Sago
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.
|
|
|
09/25/2013, 20:42
|
#4
|
elite*gold: 18
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.
|
|
|
09/25/2013, 20:50
|
#5
|
elite*gold: 0
Join Date: Sep 2008
Posts: 569
Received Thanks: 695
|
Nur wenn die Collation nicht Case Sensitive ist.
|
|
|
09/25/2013, 21:02
|
#6
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Quote:
Originally Posted by Pumaaa
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.
|
|
|
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
|
|
|
09/25/2013, 21:05
|
#8
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Quote:
Originally Posted by NativeGermany
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.
|
|
|
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?
|
|
|
09/25/2013, 21:13
|
#10
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Nein, eher durch absenden falscher Informationen.
|
|
|
09/25/2013, 22:48
|
#11
|
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!
|
|
|
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
|
|
|
|
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\ ;engine.exe /load /config test2
|
All times are GMT +1. The time now is 07:04.
|
|