[DATABASE PROBLEM] A10

~~Hesorio1u~~ · 11/20/2012, 17:20

FIXED!

How to fix it?

1. Open Enterprise manager
2. Go to Managment
- SQL Server Agent
-
-
- Job's
3. Right click on antigm then "properties"
4. [PICTURE FOR DEAL] - Step 1

5. [PICTURE FOR DEAL] - Step 2

6. [PICTURE FOR DEAL] - Step 3

Here is code what u must put in
------------------------------------------------------------------------------------
DELETE FROM character.dbo.user_character
WHERE character_name < ']'
AND character_name <> '[GM]YourGMName'
AND character_name <> '[GM]YourGMName'
AND character_name <> '[GM]YourGMName'
AND character_name <> '[GM]YourGMName'
AND character_name <> '[DEV]KNIGHT'
AND character_name <> '[DEV]HUNTER'
AND character_name <> '[DEV]MAGICIAN'
AND character_name <> '[DEV]SUMMONER'
AND character_name <> '[DEV]SEGNALLE'
AND character_name <> '[DEV]WARRIOR'
AND character_name <> '[DEV]ALLOKEN'
AND character_name <> '[DEV]CONCERRA'
AND character_name <> '[DEV]SEGEURIPER'

------------------------------------------------------------------------------------
EDIT IT BY YOUR SELF!!!! [GM] Type your name here
if u wanna add more gm's u must add more ranks like explame:

AND character_name <> '[GM]YourGMName'

If some error's or warning window come just press "Yes"
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

EASY WAY!

Disabling your antiGM

1. Open Enterprise manager
2. Go to Managment
- SQL Server Agent
-
-
- Job's
3. Right click on antigm then "properties"
4. Disable Job
5. Done

~~Trac3r~~ · 11/20/2012, 17:35

..... LOL .....
off-topic:
You keep saying I am the newb? lol...

On-Topic:
Goto the character database
Goto Stored Procedures
The Anti GM is usually the name for the stored procedure.

alexmak96 · 11/20/2012, 18:08

managment, select managment, sql server agent, jobs , and u can disable Anti-gm

~~Hesorio1u~~ · 11/20/2012, 18:10

umm, really? I'm learning it!, u can't compare more who know's. Like if u doesn't know using Visual Basic. You come to bully with me?, Well i'm not childrish like u.

And every your post humiliate people!

I didn't say u are newbie. But if u are a Tracer owner, why should u buy other a11-12 files etc. because u doesn't know make it by your self.

big thanks alexmak97

))

~~Trac3r~~ · 11/20/2012, 20:07

I only humiliated you xD Bcz you aint nice toward me and you stole Core's server files and their page layout we all know that.

Bcz I wanna save time, but atleast I pay and appreciate other ppls work instead of just stealing it.

Yeah alexmak97 it can also be in there xD I got it in Stored Procedure lol xD

~~Hesorio1u~~ · 11/20/2012, 23:08

Quote:

Originally Posted by Trac3r

I only humiliated you xD Bcz you aint nice toward me and you stole Core's server files and their page layout we all know that.

Bcz I wanna save time, but atleast I pay and appreciate other ppls work instead of just stealing it.

Yeah alexmak97 it can also be in there xD I got it in Stored Procedure lol xD

I stole core dekaron server files and their page layout?

I reall'y doesn't know what are u talking about and what u have in your concieted brain.

Where is prof's?, I'm have my (fixed) server with client from conquer93 what they relase.

xD He can agree with it , also Chataracts and other my friends.

Everytime u find stupid reason's to condemned me? Where is your purpose?
Why imagining thing's that nobody ever like to say?

If u have any against of me, tell now we will talk about it. Don't just posting stupid post's what nobody hear about it. You suck man, u make only rubbish here, nobody love u.

ihatehacks · 11/20/2012, 23:22

On-topic:
Normally you will find anti-gm in jobs and you can freely delete it since its useless. If you dont want to delete it, simply add your GM names to the list (since im assuming you are talking about GM characters being deleted here)

off-topic:

Quote:

Originally Posted by Trac3r

You keep saying I am the newb

I'd like to take the time to say that you are. Because unless you manually changed it to do so (which i doubt you have knowledge on how to do) Summoner tb, CS db, baggi, ak, and aloken are all physical based classes. None of these classes are boosted in damage by any specific element (meaning each element boosts them the same amount). I'd like to say one more time more specifically, summoner/cs/hunter are not curse based elemental classes.

This is what im referring to when you pretty much tell your own community member that he's stupid and should learn the game and proceed to feed him with false information.

Quote:

They wont get removed end of that discussion. Learn to know wich classes uses what, other ppl know how to do it so can you (:
here is some guidance for each class just a little help.

Azure knight:
Uses all elements!

Segita Hunter:
Uses mainly fire, pzn (??? maybe Curse)

Incar Magician:
Uses Fire, Lightning, Ice

Bagi Warrior:
Uses all elements!

Vicious Summoner:
Staff uses: Poison
Twin Blade uses: Curse

Aloken:
Uses all elements

Seguripper:
Uses Curse

Concerra;
Staff uses Poison
Blade uses Curse

Half Bagi:
I am not sure here

Dark Wizard:
Uses atleast fire dmg (:

~~Hesorio1u~~ · 11/20/2012, 23:45

Quote:

Originally Posted by ihatehacks

On-topic:
Normally you will find anti-gm in jobs and you can freely delete it since its useless. If you dont want to delete it, simply add your GM names to the list (since im assuming you are talking about GM characters being deleted here)

off-topic:

I'd like to take the time to say that you are. Because unless you manually changed it to do so (which i doubt you have knowledge on how to do) Summoner tb, CS db, baggi, ak, and aloken are all physical based classes. None of these classes are boosted in damage by any specific element (meaning each element boosts them the same amount). I'd like to say one more time more specifically, summoner/cs/hunter are not curse based elemental classes.

This is what im referring to when you pretty much tell your own community member that he's stupid and should learn the game and proceed to feed him with false information.

Well, wrong! The [DEV]'s got deleted so u can't create character as begining.
I disable AntiGM it work's perfect.. but how to enable it without deleteing useful [DEV] char's? You know it?.... :P

Decima · 11/20/2012, 23:54

the resistance of the victim is more important in deciding what element to use, then are the ones used by the actual classes anyways, this has always been a topic of discussion since 2moons, on the 2moons forums it was stated that gems and such add to total damage, and only come into play when the victim has said resist of the gems that are being used, is it correct? who knows for sure, i do know that in testing this actually seems to be case, sure some elements are made for a particular class, and thus does boost if you match their elements, then again resist will still come into play, and when/if it does the bonus boost is hardly noticeable anyways as resist is a percentage based calculation, so in the end, its still just a matter of preference from what i have experienced.

on another note however, i wouldnt say the anti gm hack is useless, its not needed if you know what procedure to edit and how to edit it to filter out noobs trying to make a GM, but for those ppl that do not i would have to rebuttle ur remark and say the anti gm hack is in fact useful if you dont want some asshat making 100 GM's, DEV's and DEKARON characters on ur server as you are trying to work on it, why would you tell them that for? oO

guesswho-.- · 11/20/2012, 23:54

add the names to the exception list?

~~Hesorio1u~~ · 11/21/2012, 00:16

quesswho ill try it, thanks for pming

and thanks u guys.

Work's ill post later what problem was. Big thanks to quesswho too

~~Trac3r~~ · 11/21/2012, 10:15

off-topic:
I has tested it on my server and you post of what is wrong on my server? retarded lol since I has tested each, and it seems on MY server that it gives the MOST by using THOSE elements.

On-Topic:
Anyone reading this topic -

Quote:

Originally Posted by from Warmonger

Im Going To Share With You My Method Of Blocking Illegal Character Names From Being Created (Server Side). Yes This Will Stop All GM, DEKARON, And DEV Characters From Being Created 100%. It Will Also Filter The Use Of Illegal Characters In Player Names. There Are A Few Anti-GM Scripts And Procedures Floating Around. But This Is The Proper Way To Fix The Problem. Its Also Faster To Execute The Lookup Than Running Through Each Individual Check In T-SQL.

STEP 1: Create A Table For The Illegal Name Wildcards.
PHP Code:

Quote:

CREATE TABLE illegal_character_names (partial_name varchar(30))

STEP 2: Create A Function To Check The Names.
PHP Code:

Quote:

CREATE FUNCTION NameBlock(@character_name varchar(40))
RETURNS tinyint
AS
BEGIN
DECLARE @result tinyint, @x int
SET @result = 1
SET @x = 1

-- Check If Name Contains Illegal Characters First
WHILE (@x <= LEN(@character_name))
BEGIN
IF (SUBSTRING (@character_name, @x, 1) NOT LIKE '[0123456789a-z]')
RETURN @result
SET @x = @x + 1
END

-- Then Check To Make Sure It's Not In Our Table
SELECT @result = CASE WHEN COUNT(*) = 0 THEN 0 ELSE 1 END FROM illegal_character_names WHERE @character_name LIKE partial_name
RETURN @result
END

STEP 3: Insert Illegal Name Wildcards Into Our Table.
PHP Code:

Quote:

INSERT INTO illegal_character_names VALUES('%shit%')
INSERT INTO illegal_character_names VALUES('%nigg%')
INSERT INTO illegal_character_names VALUES('%wank%')
INSERT INTO illegal_character_names VALUES('%whore%')

STEP 4: Add The Check Into Your SP_CHAR_CREATE Stored Procedure.
PHP Code:

Quote:

IF (dbo.NameBlock(@character_name) = 1)
BEGIN
SET @sp_rtn = -12
RETURN
END

Where Do I Add The Check!?!?!?
It seems there was already a server side check at one point in time. Here is the old name check call that no longer works. Just replace it with mine.
Code:

Quote:

-- 캐릭터명 체크 (중복체크 / 필터링체크)
EXEC sp_char_name_check @character_name, @v_ret OUTPUT

IF @v_ret < 0 -- 캐릭터명 오류
BEGIN
SET @sp_rtn = @v_ret
RETURN
END

-- 캐릭터구분 Parsing

Works much better.

[GM]Death · 11/21/2012, 23:48

I VOTE FOR AN (AUTO DELETE DRAMA) BUTTON ON ALL POSTS .... just saying

ihatehacks · 11/22/2012, 05:26

@OP - What you did was what i was mentioning with adding characters to the list.

Quote:

Originally Posted by Decima

the resistance of the victim is more important in deciding what element to use, then are the ones used by the actual classes anyways, this has always been a topic of discussion since 2moons, on the 2moons forums it was stated that gems and such add to total damage, and only come into play when the victim has said resist of the gems that are being used, is it correct? who knows for sure, i do know that in testing this actually seems to be case, sure some elements are made for a particular class, and thus does boost if you match their elements, then again resist will still come into play, and when/if it does the bonus boost is hardly noticeable anyways as resist is a percentage based calculation, so in the end, its still just a matter of preference from what i have experienced.

on another note however, i wouldnt say the anti gm hack is useless, its not needed if you know what procedure to edit and how to edit it to filter out noobs trying to make a GM, but for those ppl that do not i would have to rebuttle ur remark and say the anti gm hack is in fact useful if you dont want some asshat making 100 GM's, DEV's and DEKARON characters on ur server as you are trying to work on it, why would you tell them that for? oO

Secrets ^_^

Quote:

Originally Posted by Trac3r

off-topic:
I has tested it on my server and you post of what is wrong on my server? retarded lol since I has tested each, and it seems on MY server that it gives the MOST by using THOSE elements.

I really hate to tell you something so obvious but unless you changed the result codes, the ones used for tb/db/bow/xbow/ak weps/baggi/alo/etc are purely str/dex codes. remotes may be different, but im sure they follow the same thing as above.