[Release] rSec 3.0 - RYL Server Security Software

4 Attachment(s)

rSec 3.0 - RYL Server Security Software

rSec is a ryl packet management proxy framework built as a windows .net application in C# 2.0 & 3.5

What is a proxy?
This means that the clients don't connect directly to the ryl servers but rather rSec which then forwards the packets to ryl servers, then any packets coming from the servers are forwarded to the client. This is needed to be able to control the data flow from the client to the server and vice versa.

What is packet management?
The data that comes from the client or the server are decrypted, decrompressed and if needed decompiled. Then the data in the packet can be checked, modified or just dropped. Because it's the network traffic that controls what a character in game does or what the player sees on his game screen, so with a proper packet handling it's possible to modify almost anything or check everything the character does.

So what's rSec then all together?
For the rSec user rSec is above all a anti-hack software that runs in the server. But also a game enhancer.

Development
At this moment rSec is tested on row, 1753 and 668 (not sure about this number) without GG.

Features

Ryl 1 and Ryl 2 support
Admin command check - checks the / command against the gm level. Ex.: you can make /move command to work only for lvl 4 gms
Chat tools - You can redefine specific character names to be different color, also adds a account name based /logout command
IRC bot - Forwards global messages from game to a irc channel and back again
Attack check
1. General:
Check the skill is learned (anti-class-hack)
Check the attack range (anti-vacuum-hack)
2. Skills
Check the spell cast times (anti-speeder)
Check the skills usage times against cooldowns (anti-skillscript-cooldown-hack)
3. Melee
Check melee hits frequency (hits per sec), the limits are changeable per class. Ex.: A assasin can hit a maximum of 5 hits per second
Character data collector - logs login info to the database (uid, cid, zone, ip, time in, time out)
DB data validator - checks the character equipment in the database if it has changed (anti-slot-hack)
Movement check (anti speeder and teleportation)
1. Allow zone moves only near the right npc for non-gms (anti-npcscript-hack)
2. Check location save npc distance (ryl 1)
3. Allow bindTo command only for gm's (anti-teleportation/gm hack)
Name check - checks the char creation name to disable any unallowed content and also checks the chat to contain the senders real name
Logging service - logs item modification/movements and gm commands usages to the database
Mini fixes (ryl 2) - fixes zone 13 "Leave Battle" button on the map and the "Already logged in" issue.
Port redirection tool - As rSec listens to ports then the server can't be on the same ports, this is why this plugin is good - it will tell the client to connect to the port rSec is listening to rather than the server.
Web services - hosts a http service which gives info about the online characters, online gms and character locations on the map
Item check -
1. General
NPC access range check - anti random location blacksmith/vault/shop usage.
Item duplication fix - anti dupe hack using chaos stones
2. Shopping
NPC "able to sell item" check - checks if the npc actually sells the item and for that currency (medals vs gold)
Basic stats check - checks if the equipment can contain the defined stats (e.g. min/max dmg on armor)
Gear quality limit - you can limit which grade can be bought from the shop (anti item hack)
0 socked limit - no sockets can be defined on the item on purchase
3. Usage
Limits item usage speed
Item usager - you can define item id's that should be used upon pickup (gold/metal containers or maybe even fireworks)

Runtime dependencies
.net 4.0 Error 404 - Not Found ... x?id=17718
Demonsetup on local machine in C:\Windows

Recommended System Requirements
CPU: Pentium 4 or equivalent (up to around 100 players), ~i5 for over 200 players
Memory: 2GB
Operating System: Windows Server 2003/2008 or Windows 7
Internet Connection: Whatever your ryl server needs

Changelog
redacted

Download
https://docs.google.com/uc?authuser=...xport=download

How to set up
redacted

Re: rSec 3.0 - RYL Server Security Software

Download Link not working.

Re: rSec 3.0 - RYL Server Security Software

great release . .atlast . . thanks again alpha . .

Re: rSec 3.0 - RYL Server Security Software

can anyone share the guide to change the port from auth 10110 to 11110, zone1 10201 to 11201

i use the olldby but can not find the port constant!

Re: rSec 3.0 - RYL Server Security Software

its doesnt support ROW skillscript? such as ABILITY & GATHER 's skill type . .

Re: rSec 3.0 - RYL Server Security Software

@BountyHunter you might have to work on the script.

Re: rSec 3.0 - RYL Server Security Software

hkryl Try in HEX find 7E 27 and change with 8E 4E .

Re: rSec 3.0 - RYL Server Security Software

i success hex the auth in olldby....but the zone1 map can not find the 10201!

Re: rSec 3.0 - RYL Server Security Software

@alphaest thanks for the share. i managed to set up the soft and really like the packet management concept on this tool you have created. just want to know based on your post;

Quote:

So what's rSec then all together?
For the rSec user rSec is above all a anti-hack software that runs in the server. But also a game enhancer.

what do you mean by also game enhancer?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by matt_warfare

@alphaest thanks for the share. i managed to set up the soft and really like the packet management concept on this tool you have created. just want to know based on your post;

what do you mean by also game enhancer?

Im not alpha, but i think the automatic opening from package gold/metals, already is a game enhancer...Server with this feature, is amazing...All others plugins, make the game better too...

- - - Updated - - -

31/07/2014 19:03:24 : [Character Data Collector] - (NOTIFY) {|0} GM level 5 logged in (uid:1)
Char: (U:1, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.AuthCharDataReturn(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Command : 3
ParamA : 0
ParamB : 0
Compressed : False

17 b0 83 c4 01 00 00 00 01 00 00 00 4d 61 73 74
65 72 00 00 00 00 00 00 00 00 00 00 01 02 01 01
15 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 69 00 00 00 00 00 00 ed 13 00 00 51 14 00
00 00 00 00 00 00 00 00 00 19 15 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 01 00 00 00 02 2c
bd da 53 00 00 00 00 05 00 4e 00 00

31/07/2014 19:03:23 : PacketForwarder - Checksum rewrite failed : System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseUInt32(String value, NumberStyles options, NumberFormatInfo numfmt)
at rSec.Extenders.ToUInt(String str)
at rSec.Server.ActionInterface.GetChecksumAndVersion()
at rSec.Server.PacketForwarder.RewriteChecksum(Packet p, Session sender)

31/07/2014 18:55:33 : [Character Data Collector] - (NOTIFY) {|0} GM level 5 logged in (uid:1)
Char: (U:1, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.AuthCharDataReturn(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Command : 3
ParamA : 0
ParamB : 0
Compressed : False

16 b0 83 c4 01 00 00 00 01 00 00 00 4d 61 73 74
65 72 00 00 00 00 00 00 00 00 00 00 01 02 01 01
15 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 69 00 00 00 00 00 00 ed 13 00 00 51 14 00
00 00 00 00 00 00 00 00 00 19 15 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 01 00 00 00 02 55
bb da 53 00 00 00 00 05 00 4e 00 00

31/07/2014 18:55:30 : PacketForwarder - Checksum rewrite failed : System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseUInt32(String value, NumberStyles options, NumberFormatInfo numfmt)
at rSec.Extenders.ToUInt(String str)
at rSec.Server.ActionInterface.GetChecksumAndVersion()
at rSec.Server.PacketForwarder.RewriteChecksum(Packet p, Session sender)

31/07/2014 18:54:56 : PacketForwarder - Started listening on port 10316

31/07/2014 18:54:56 : PacketForwarder - Started listening on port 10312

31/07/2014 18:54:56 : PacketForwarder - Started listening on port 10308

31/07/2014 18:54:56 : PacketForwarder - Started listening on port 10304

31/07/2014 18:54:56 : PacketForwarder - Started listening on port 10110

PacketForwarder - Checksum rewrite failed : ....?

Re: rSec 3.0 - RYL Server Security Software

Checksum rewrite is a feature you can enable form the menu. The server rSec runs on needs demonsetup.ini in windows directory with the correct db agent checksum set. It reads it form there and doesn't seem to find for you.

Checksum rewrite makes it so GM's can login with any client to test / debug stuff and so it sends the right checksum into the server no matter what you have.

When talking about game enhancers then Ronaldinho got it right, stuff like package opener, bots, red admin names, chat blocks and all those are what i mean under it.

Re: rSec 3.0 - RYL Server Security Software

Sriusly ?

You release it for freeeeeeeeeeeeeeeeee ?

Re: rSec 3.0 - RYL Server Security Software

Alpha, im getting EQ Check failed. I turn it on the plugin DB Data validator, but having this.what can i do to fix it?
And where i can turn it on/turn it off? Or what i can do to make it working properly?

Why appear this: Input string was not in a correct format., im using the default string that comes with rsec.

To make chat red, what i need to do in client.exe? I found there in client.exe 0052A5A7: MOV EAX, FFFF0000... but what i need to do? i only see white color in /cz chat.

Re: rSec 3.0 - RYL Server Security Software

and what does it mean by this error alpha?

Quote:

8/2/2014 1:23:59 AM : [Character Data Collector] - ERR: The given key was not present in the dictionary.
(U:157, C:0, Z:12, L:0, IP:175.135.133.218)
Command : 8
ParamA : 0
ParamB : 0
Compressed : True

00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
9d 00 00 00 02 00 00 0c 98 e3 4c 00 00 00 00 01
00 00 00 00 48 00 18 00 a4 00 64 00 0e 01 6e 00
50 00 2c 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 e3 09 00 00 5b 53 45 52 56 45 52 2d
41 44 4d 49 4e 5d 00 00 01 02 01 00 07 00 00 00
00 00 7f 5b 34 77 00 00 00 00 00 00 00 00 6e 0e
7f 49 78 e4 00 81 00 ee 00 14 00 14 00 14 00 89
11 e2 11 db df a7 42 00 00 00 00 00 00 10 31 45
00 00 f0 41 00 f0 13 45 00 10 31 45 00 00 f0 41
00 f0 13 45 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 82 6e 00 00 00 00
00 0c db 01 31 00 20 01 00 68 28 60 e1 00 f3 11
f5 03 e6 03 57 07 68 04 1e 03 b5 1f 00 00 00 00
00 00 59 02 51 00 14 64 00 00 20 00 00 00 6d 6e
00 00 00 00 00 0c 62 06 b1 00 26 01 00 68 2c 58
ce 00 2c 2c 2c 2c 2c 2c 2c 2c e1 05 72 08 04 0f
5a 08 1b 02 7f 85 00 00 00 00 00 0c bf 23 d1 00
14 01 00 00 20 00 00 00 83 85 00 00 00 00 00 0c
bb 23 02 00 14 01 00 00 20 00 00 00 81 85 00 00
00 00 00 0c bd 23 22 00 14 01 03 00 20 00 00 00
86 85 00 00 00 00 00 0c b8 23 02 10 14 01 00 00
20 00 00 00 85 85 00 00 00 00 00 0c b9 23 42 14
14 01 03 00 20 00 00 00 83 6e 00 00 00 00 00 0c
c4 04 07 00 1e 01 00 60 27 50 ce 00 71 09 42 0b
14 0e ba 07 fb 01 64 6e 00 00 00 00 00 0c d4 07
17 00 0e 08

Exception:
System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.
at System.Collections.Generic.Dictionary`2.get_Item(TKey key)
at rSec.Server.Data.SkillScript.ClassLearnedSkills(Byte bClass)
at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c)
at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by RonaldinhoR9

Alpha, im getting EQ Check failed. I turn it on the plugin DB Data validator, but having this.what can i do to fix it?
And where i can turn it on/turn it off? Or what i can do to make it working properly?

Why appear this: Input string was not in a correct format., im using the default string that comes with rsec.

To make chat red, what i need to do in client.exe? I found there in client.exe 0052A5A7: MOV EAX, FFFF0000... but what i need to do? i only see white color in /cz chat.

Based on his set up instruction;

Quote:

7. DB Data validator - use if you have set-up the SQL connections and extra tables from knowledge portal

Re: rSec 3.0 - RYL Server Security Software

oh thnks matt. ill look there ^^

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

and what does it mean by this error alpha?

It means the skillscript you have referenced in rSec doesn't contain a skill your character has.
Try setting the data folder to your server data folder in config.

Re: rSec 3.0 - RYL Server Security Software

DB Data Validator - Check Failed because the database is not connected,

may i know .. i cant use other ip than 127.0.0.1 for database? or i wrong configure?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

It means the skillscript you have referenced in rSec doesn't contain a skill your character has.
Try setting the data folder to your server data folder in config.

how can i make i support for ROW skillscript that have ABILITY & GATHER type of skill? do i need to change it to another type ?

Re: rSec 3.0 - RYL Server Security Software

can anyone show how to hex the gameserver.exe for the port....use olldby can not find the constant

the gameserver.exe is already unpack!

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by hkryl

can anyone show how to hex the gameserver.exe for the port....use olldby can not find the constant

the gameserver.exe is already unpack!

you want change port for gameserver or what?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by hkryl

can anyone show how to hex the gameserver.exe for the port....use olldby can not find the constant

the gameserver.exe is already unpack!

you don't have to change the gameserver's port to use rSec

Re: rSec 3.0 - RYL Server Security Software

Alpha said: "Gameserver exes don't need to be changed because the port redirection tool will change the packet that tells the client on which address/port to connect on."

Re: rSec 3.0 - RYL Server Security Software

then just only change the auth port that can be use Rsec?

Re: rSec 3.0 - RYL Server Security Software

Yes, but need to make all the config ok.

Re: rSec 3.0 - RYL Server Security Software

already success use Rsec....but some error when i login with char....what mean by these 2 error!

(ERR: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
ERR: Sequence contains no matching element)

"8/5/2014 3:21:08 PM : [Character Data Collector] - ERR: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
"1111 (U:29, C:2, Z:12, L:15, IP:192.168.1.100)"
Command : 8
ParamA : 0
ParamB : 0
Compressed : True
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
1d 00 00 00 02 00 00 0c a0 52 4b 03 01 00 00 00
00 00 00 00 48 00 18 00 54 00 64 00 0e 01 58 00
a2 02 00 00 00 00 00 00 02 00 00 00 31 31 31 31
00 00 00 00 00 00 00 00 00 00 00 00 01 02 01 00
05 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 0f 3c a2 8a 00 1c 00 2e 00 14 00 29 00 14
00 14 00 bd 02 db 00 53 0b 00 00 00 00 00 00 00
cd 1c 41 45 9a 99 51 41 66 76 1c 45 00 c0 2f 45
00 00 70 41 00 c0 1b 45 01 00 01 00 04 81 00 01
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 01 00 01 04
81 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 18
00 00 00 00 00 00 c9 00 11 00 14 64 00 00 20 00
00 00 82 56 00 00 00 00 00 0c f5 01 41 00 14 64
01 00 20 00 00 00 01 18 00 00 00 00 00 00 59 02
51 00 14 64 00 00 20 00 00 00 7d 56 00 00 00 00
00 0c a5 06 91 00 1c 52 00 00 20 40 1c 00 16 00
27 00 18 00 2b 00 71 56 00 00 00 00 00 0c cc 0b
12 00 0e 0c 70 56 00 00 00 00 00 0c 21 03 22 00
22 76 00 00 20 70 22 00 21 00 12 00 94 00 28 00
19 00 2a 00 2b 00 73 56 00 00 00 00 00 0c 21 03
32 00 1e 2c 00 00 20 50 db 00 11 00 32 00 28 00
49 00 1b 00 7e 56 00 00 00 00 00 0c bd 02 42 00
1c 51 00 00 20 40 f0 00 31 00 28 00 39 00 2b 00
7f 56 00 00 00 00 00 0c 6f 07 52 00 0e 02 77 56
00 00 00 00 00 0c a5 06 02 01 1a 4b 00 00 20 30
28 00 26 00 37 00 19 00 02 18 00 00 00 00 00 00
bd 02 52 01 14 64 00 00 20 00 00 00 78 56 00 00
00 00 00 0c a5 06 02 03 1a 32 00 00 20 30 f1 00
16 00 37 00 29 00 7a 56 00 00 00 00 00 0c a5 06
22 03 1c 59 00 00 20 40 f7 00 16 00 27 00 29 00
2b 00 93 56 00 00 00 00 00 0c 71 07 42 03 0e 01
7b 56 00 00 00 00 00 0c 59 02 42 04 14 64 00 00
20 00 00 00 7c 56 00 00 00 00 00 0c a5 06 02 10
1a 05 00 00 20 30 f8 00 37 00 19 00 2b 00 92 56
00 00 00 00 00 0c d7 0d 22 10 0e 01 a1 56 00 00
00 00 00 0c a5 06 42 10 1a 01 00 00 20 30 df 00
26 00 39 00 1b 00 86 56 00 00 00 00 00 0c a5 06
02 12 1c 08 00 00 20 40 f1 00 16 00 27 00 19 00
1b 00 85 56 00 00 00 00 00 0c a5 06 22 12 1c 44
00 00 20 40 1e 00 27 00 18 00 39 00 2b 00 88 56
00 00 00 00 00 0c 41 06 42 12 20 8d 00 00 20 60
2d 00 21 00 44 00 28 00 39 00 2a 00 1b 00 89 56
00 00 00 00 00 0c 41 06 52 12 20 2b 00 00 20 60
fe 00 31 00 a4 00 18 00 69 00 3a 00 3b 00 8b 56
00 00 00 00 00 0c a5 06 02 14 16 45 00 00 20 10
1a 00 37 00 8c 56 00 00 00 00 00 0c 41 06 22 14
1e 44 00 00 20 50 fd 00 21 00 12 00 64 00 39 00
1a 00 8f 56 00 00 00 00 00 0c 41 06 32 14 1c 44
00 00 20 40 0e 00 21 00 18 00 49 00 2b 00 90 56
00 00 00 00 00 0c a5 06 42 14 18 54 00 00 20 20
15 00 29 00 2b 00 8d 56 00 00 00 00 00 0c 85 03
02 20 1c 08 00 00 20 40 d0 00 12 00 64 00 18 00
1a 00 91 56 00 00 00 00 00 0c 30 0f 22 20 0e 01
a2 56 00 00 00 00 00 0c 22 0e 42 20 0e 01 76 56
00 00 00 00 00 0c 85 03 22 22 1e 04 00 00 20 50
20 00 31 00 a4 00 38 00 2a 00 2b 00 a8 56 00 00
00 00 00 0c 41 06 42 22 1e 0a 00 00 20 50 d8 00
21 00 18 00 19 00 2a 00 1b 00 72 56 00 00 00 00
00 0c d1 07 22 25 0e 04
Exception:
"System.IndexOutOfRangeException: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
" at rSec.Server.ItemHandler.LoadAllFromStream(Stream s, Int32 len)"
" at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c)"
" at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)"
" at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)"

8/5/2014 3:21:19 PM : [Character Data Collector] - ERR: Sequence contains no matching element
"1111 (U:29, C:2, Z:12, L:15, IP:192.168.1.100)"
Command : 11
ParamA : 0
ParamB : 0
Compressed : False
02 00 00 00 22 25 02 23 04
Exception:
System.InvalidOperationException: Sequence contains no matching element
" at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate)"
" at rSec.Server.ItemHandler.Move(IPos from, IPos to, Int32 amount)"
" at rSec.PacketChecker.ParseItemMove(Packet p, Character c)"
" at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)"
" at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)"

8/5/2014 3:34:57 PM : {Server connection} - ReceiveAsyncComplete failed - Socket error OperationAborted

"8/5/2014 3:34:58 PM : [Character Data Collector] - ERR: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
"1111 (U:29, C:2, Z:12, L:18, IP:192.168.1.100)"
Command : 8
ParamA : 0
ParamB : 0
Compressed : True
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
1d 00 00 00 02 00 00 0c d0 fc 57 03 01 00 00 00
00 00 00 00 48 00 18 00 54 00 64 00 0e 01 76 00
c0 02 00 00 00 00 00 00 02 00 00 00 31 31 31 31
00 00 00 00 00 00 00 00 00 00 00 00 01 02 01 00
05 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 12 c0 71 cd 00 22 00 32 00 14 00 2e 00 14
00 14 00 db 02 79 01 87 13 00 00 00 00 00 00 00
66 5e 47 45 00 00 d8 41 66 4e 17 45 00 c0 2f 45
00 00 70 41 00 c0 1b 45 01 00 01 00 04 81 00 01
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 01 00 01 04
81 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 18
00 00 00 00 00 00 c9 00 11 00 14 64 00 00 20 00
00 00 82 56 00 00 00 00 00 0c f5 01 41 00 14 64
01 00 20 00 00 00 01 18 00 00 00 00 00 00 59 02
51 00 14 64 00 00 20 00 00 00 7d 56 00 00 00 00
00 0c a5 06 91 00 1c 52 00 00 20 40 1c 00 16 00
27 00 18 00 2b 00 76 56 00 00 00 00 00 0c 85 03
b1 00 1e 04 00 00 20 50 20 00 31 00 a4 00 38 00
2a 00 2b 00 71 56 00 00 00 00 00 0c cc 0b 12 00
0e 0f 70 56 00 00 00 00 00 0c 21 03 22 00 22 76
00 00 20 70 22 00 21 00 12 00 94 00 28 00 19 00
2a 00 2b 00 73 56 00 00 00 00 00 0c 21 03 32 00
1e 2c 00 00 20 50 db 00 11 00 32 00 28 00 49 00
1b 00 7e 56 00 00 00 00 00 0c bd 02 42 00 1c 51
00 00 20 40 f0 00 31 00 28 00 39 00 2b 00 7f 56
00 00 00 00 00 0c 6f 07 52 00 0e 03 77 56 00 00
00 00 00 0c a5 06 02 01 1a 4b 00 00 20 30 28 00
26 00 37 00 19 00 02 18 00 00 00 00 00 00 bd 02
52 01 14 64 00 00 20 00 00 00 78 56 00 00 00 00
00 0c a5 06 02 03 1a 32 00 00 20 30 f1 00 16 00
37 00 29 00 7a 56 00 00 00 00 00 0c a5 06 22 03
1c 59 00 00 20 40 f7 00 16 00 27 00 29 00 2b 00
93 56 00 00 00 00 00 0c 71 07 42 03 0e 01 7b 56
00 00 00 00 00 0c 59 02 42 04 14 64 00 00 20 00
00 00 7c 56 00 00 00 00 00 0c a5 06 02 10 1a 05
00 00 20 30 f8 00 37 00 19 00 2b 00 92 56 00 00
00 00 00 0c d7 0d 22 10 0e 01 a1 56 00 00 00 00
00 0c a5 06 42 10 1a 01 00 00 20 30 df 00 26 00
39 00 1b 00 86 56 00 00 00 00 00 0c a5 06 02 12
1c 08 00 00 20 40 f1 00 16 00 27 00 19 00 1b 00
85 56 00 00 00 00 00 0c a5 06 22 12 1c 44 00 00
20 40 1e 00 27 00 18 00 39 00 2b 00 88 56 00 00
00 00 00 0c 41 06 42 12 20 8d 00 00 20 60 2d 00
21 00 44 00 28 00 39 00 2a 00 1b 00 89 56 00 00
00 00 00 0c 41 06 52 12 20 2b 00 00 20 60 fe 00
31 00 a4 00 18 00 69 00 3a 00 3b 00 8b 56 00 00
00 00 00 0c a5 06 02 14 16 45 00 00 20 10 1a 00
37 00 8c 56 00 00 00 00 00 0c 41 06 22 14 1e 44
00 00 20 50 fd 00 21 00 12 00 64 00 39 00 1a 00
8f 56 00 00 00 00 00 0c 41 06 32 14 1c 44 00 00
20 40 0e 00 21 00 18 00 49 00 2b 00 90 56 00 00
00 00 00 0c a5 06 42 14 18 54 00 00 20 20 15 00
29 00 2b 00 8d 56 00 00 00 00 00 0c 85 03 02 20
1c 08 00 00 20 40 d0 00 12 00 64 00 18 00 1a 00
91 56 00 00 00 00 00 0c 30 0f 22 20 0e 01 a2 56
00 00 00 00 00 0c 22 0e 42 20 0e 01 aa 56 00 00
00 00 00 0c 85 03 22 22 1e 43 00 00 20 50 e0 00
21 00 a4 00 59 00 1a 00 2b 00 a8 56 00 00 00 00
00 0c 41 06 42 22 1e 0a 00 00 20 50 d8 00 21 00
18 00 19 00 2a 00 1b 00 af 56 00 00 00 00 00 0c
46 06 52 22 1e 40 00 00 20 50 0f 00 31 00 84 00
38 00 b9 00 4a 00 72 56 00 00 00 00 00 0c d1 07
02 23 0e 04
Exception:
"System.IndexOutOfRangeException: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
" at rSec.Server.ItemHandler.LoadAllFromStream(Stream s, Int32 len)"
" at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c)"
" at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)"
" at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)"

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by hkryl

already success use Rsec....but some error when i login with char....what mean by these 2 error!

(ERR: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
ERR: Sequence contains no matching element)

The second error is a followup to the first.

The first one is basically that rSec starts parsing your item data at that point in the stream and expects a item to be defined, but find a int 0. This can be from: 1. you have some server version that is not standard, 2. you have some server version that i haven't seen, 3. you have the wrong ryl version set in rSec config, 4. you have invalid item data in the char, try with a new one.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by hkryl

already success use Rsec....but some error when i login with char....what mean by these 2 error!

(ERR: Cannot find the item Item 0 at 0x0, amount 0 from itemscript"
ERR: Sequence contains no matching element)

that should be cause your are running v2240?

Re: rSec 3.0 - RYL Server Security Software

yes i am running v2240...

already succesful check the speed hack and skill hack....

but for the item check there have 2 error occur..maybe i need to use the client itemscript for the setting..

Re: rSec 3.0 - RYL Server Security Software

can anyone give me tables for eq_changed? i try to insert in CharInfo But ryl1 dont have that just Charinfo_1 _2 _3 _4

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

The second error is a followup to the first.

The first one is basically that rSec starts parsing your item data at that point in the stream and expects a item to be defined, but find a int 0.
This can be from:
1. you have some server version that is not standard,
2. you have some server version that i haven't seen,
3. you have the wrong ryl version set in rSec config,
4. you have invalid item data in the char, try with a new one.

Can make it work on ROW v1105 ?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

Can make it work on ROW v1105 ?

why dont you have a try?

Re: rSec 3.0 - RYL Server Security Software

I did try.. the db char collector is not working well..

Re: rSec 3.0 - RYL Server Security Software

@alphaest

may i know how can this happen? well at first i have try it and it is goes really well, just got this kind of error;

Quote:

12/8/2014 2:32:58 AM : [Attack Check] - (NOTIFY) {|0} Attacking while the cell doesn't contain the character itself, allowed: The character has to be present in every cell update
Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.Range(UInt16 skill, Int32 major, Packet p, Character c)
at rSec.PacketChecker.CharAttack(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.clientToServer_IncomingPackets(Session sender, Packet p)

Command : e
ParamA : 51970
ParamB : 165
Compressed : False

9b 41 30 45 df cb 56 41 8d 62 33 45 9c 81 75 40
03 00 00 00 89 02 03 00 00 00 00 00 00 00 00 00
00 00 00 00 01 27 00 16 80 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 f3 12 00
25 49 7c 5f 10 46 36 8d 26 69 de 73 cc a6 d7 bd
00 00 10 8d f5 a9 f4 1f 00 00 00 57 00 00 00 56

and this;

Quote:

12/8/2014 2:32:59 AM : [Name Check] - (NOTIFY) {|0} Chat without being logged in
Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)
Exception:
rSec.Server.HackAttemptException: Exception of type 'rSec.Server.HackAttemptException' was thrown.
at rSec.PacketChecker.ChatCheck(Packet p, Character c)
at rSec.Server.PacketForwarder.HandleFilteredPacket(Packet p, Filter filter, Character c, Boolean toServer)
at rSec.Server.PacketForwarder.clientToServer_IncomingPackets(Session sender, Packet p)

Command : d
ParamA : 0
ParamB : 0
Compressed : False

00 00 00 00 00 00 68 61 68 61 7a 20 3a 20 73 61
73 61 73 61 00

it was like my character was not in server or I am not really connect properly or database/connection issue?
as you can see;

Quote:

Char: (U:0, C:0, Z:0, L:0, IP:127.0.0.1)

I have already reinstall sql and building up the server (restoring database etc) again but it gave me same result.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by matt_warfare

@alphaest

may i know how can this happen? well at first i have try it and it is goes really well, just got this kind of error;

and this;

it was like my character was not in server or I am not really connect properly or database/connection issue?
as you can see;

I have already reinstall sql and building up the server (restoring database etc) again but it gave me same result.

you either have char data collector plugin disabled or for some reason rSec doesn't get the login packets. For example you got some custom made ryl.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

you either have char data collector plugin disabled or for some reason rSec doesn't get the login packets. For example you got some custom made ryl.

ROW v1105 is custom? The .exe version was 1.0.0.1

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

ROW v1105 is custom? The .exe version was 1.0.0.1

U're some kind of matt stalker that you know which version he was trying it for?

Re: rSec 3.0 - RYL Server Security Software

Sorry, my problem is the samething with him.. im not sure what ryl version he use...I just want to know is there's any solution to make it work on customs version of ryl/row server?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

U're some kind of matt stalker that you know which version he was trying it for?

he is maybe? :dontknow: just give him a chance would you?

Quote:

Originally Posted by BountyHunter

Sorry, my problem is the samething with him.. im not sure what ryl version he use...I just want to know is there's any solution to make it work on customs version of ryl/row server?

and why dont you post your log here? or to be exact what kind of error do you get.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by matt_warfare

he is maybe? :dontknow: just give him a chance would you?

and why dont you post your log here? or to be exact what kind of error do you get.

His game server login packet has invalid content. Theres only one setting in rSec that changes this - ryl version in config. I have ever only seen 2 login packet formats and therefor only has support for 2. If his server doesn't use either of those two formats - well, hes f*cked.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by matt_warfare

he is maybe? :dontknow: just give him a chance would you?

and why dont you post your log here? or to be exact what kind of error do you get.

posted on 1st page , and 2nd log like yours .

Code:

14/08/2014 16:42:01 : [Character Data Collector] - ERR: Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails. The statement has been terminated. (U:156, C:0, Z:0, L:0, IP:127.0.0.1) Command : 1 ParamA : 0 ParamB : 0 Compressed : False 9c 00 00 00 16 00 Exception: System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'ID', table 'Part2_Zodiac.dbo.UserLoginInfo'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at rSec.Database.sendNonQueryReturnId(Databases db, String Query) at rSec.PacketChecker.AuthLoginReturn(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p) ClientConnectionId:dfe65439-0d44-4512-89cc-42d9da6af3a7

Quote:

Originally Posted by alphaest

His game server login packet has invalid content. Theres only one setting in rSec that changes this - ryl version in config. I have ever only seen 2 login packet formats and therefor only has support for 2. If his server doesn't use either of those two formats - well, hes f*cked.

ok well , thanks . .

Re: rSec 3.0 - RYL Server Security Software

@Alphaest

Hello Sir,

I facing this problem on RYL2 Server 1753/1750 version.
It from Character Data Collector the first is " ERR: Sequence contains more than one matching element" and the second is "ERR: Sequence contains no matching element"

Here the full log from rSecLog.txt

Code:

8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : a1 ParamA : 0 ParamB : 0 Compressed : False f8 50 00 00 26 00 32 05 00 00 00 14 3e 82 53 01 00 00 00 10 e1 ed 32 05 14 01 00 00 00 00 00 00 Exception: System.InvalidOperationException: Sequence contains no matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item) at rSec.PacketChecker.ItemCombine(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

here the other one

Code:

8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : 34 ParamA : 0 ParamB : 0 Compressed : False 00 00 00 00 00 00 00 00 f8 50 00 00 00 00 00 00 42 05 00 32 Exception: System.InvalidOperationException: Sequence contains more than one matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Add(IPos to, Int32 amount) at rSec.PacketChecker.ParsePickupItem(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Re: rSec 3.0 - RYL Server Security Software

@IzzdihaR

Did you read the your privat messages?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by IzzdihaR

@Alphaest

Hello Sir,

I facing this problem on RYL2 Server 1753/1750 version.
It from Character Data Collector the first is " ERR: Sequence contains more than one matching element" and the second is "ERR: Sequence contains no matching element"

Here the full log from rSecLog.txt

Code:

8/18/2014 3:42:20 AM : [Character Data Collector] - ERR: Sequence contains no matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : a1 ParamA : 0 ParamB : 0 Compressed : False f8 50 00 00 26 00 32 05 00 00 00 14 3e 82 53 01 00 00 00 10 e1 ed 32 05 14 01 00 00 00 00 00 00 Exception: System.InvalidOperationException: Sequence contains no matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Combine(IPos from, IPos to, UInt16 leftOverId, Byte leftOverAmount, Stream item) at rSec.PacketChecker.ItemCombine(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

here the other one

Code:

8/18/2014 3:43:09 AM : [Character Data Collector] - ERR: Sequence contains more than one matching element MerliN (U:5988, C:20728, Z:16, L:110, IP:175.142.109.166) Command : 34 ParamA : 0 ParamB : 0 Compressed : False 00 00 00 00 00 00 00 00 f8 50 00 00 00 00 00 00 42 05 00 32 Exception: System.InvalidOperationException: Sequence contains more than one matching element at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at rSec.Server.ItemHandler.Add(IPos to, Int32 amount) at rSec.PacketChecker.ParsePickupItem(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Is the item, you are trying to combine and pickup, in the itemscript rSec is using? The ones with rSec are just some out of the box files. If you have, try a relogin and again. If its still the same then i don't know.

Re: rSec 3.0 - RYL Server Security Software

@kz_3d

yes i see, i already reply your message for multiple time i think. @_@ ..

@Alphaest

thank you sir, i fix it by using rSec build from the source, the one connect to mysql database. If i use the one you release here i will get this error again. I dont know why @_@. Weird

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by IzzdihaR

@kz_3d

yes i see, i already reply your message for multiple time i think. @_@ ..

@Alphaest

thank you sir, i fix it by using rSec build from the source, the one connect to mysql database. If i use the one you release here i will get this error again. I dont know why @_@. Weird

The version that got released by that asshole has a major security issue. Good luck!

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

The version that got released by that asshole has a major security issue. Good luck!

yea i saw rSec Changelogs 3.0

1. Fixed a security hole in rSec itself

I dont know what the problem with this version of rSec. But i'm sure it should be related the the script maybe. I will figure this out :).

Thank you alpha for the great support. Thank You.

Re: rSec 3.0 - RYL Server Security Software

just test on RYL1 tyfix released :

Error log :

Code:

8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at rSec.Database.sendSelectQuery(Databases db, String Query) at rSec.DBTestsRunner.RunEQ() at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg) ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c

PHP Code:

USE [winner1] GO /****** Object: Table [dbo].[CharInfo] Script Date: 08/17/2010 12:02:00 ******/ ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_1] ADD CONSTRAINT [DF_CharInfo_1_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_2] ADD CONSTRAINT [DF_CharInfo_2_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_3] ADD CONSTRAINT [DF_CharInfo_3_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_4] ADD CONSTRAINT [DF_CharInfo_4_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

just test on RYL1 tyfix released :

Error log :

Code:

8/20/2014 1:14:03 PM : [DB Data Validator] - EQ Check failed Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at rSec.Database.sendSelectQuery(Databases db, String Query) at rSec.DBTestsRunner.RunEQ() at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg) ClientConnectionId:1b9509d3-f510-4c92-9734-8fe0745b971c

PHP Code:

USE [winner1] GO /****** Object: Table [dbo].[CharInfo] Script Date: 08/17/2010 12:02:00 ******/ ALTER TABLE [dbo].[CharInfo_1] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_1] ADD CONSTRAINT [DF_CharInfo_1_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_2] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_2] ADD CONSTRAINT [DF_CharInfo_2_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_3] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_3] ADD CONSTRAINT [DF_CharInfo_3_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO ALTER TABLE [dbo].[CharInfo_4] ADD COLUMN [EQ_Changed] [bit] NOT NULL GO ALTER TABLE [dbo].[CharInfo_4] ADD CONSTRAINT [DF_CharInfo_4_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed] GO

Use this:
http://alpha.lutsu.ee/forum/viewtopic.php?f=10&t=217

Re: rSec 3.0 - RYL Server Security Software

Sounds like the server files need to modified then .. any point?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by KaitoDaumoto

Sounds like the server files need to modified then .. any point?

for ?

Re: rSec 3.0 - RYL Server Security Software

makes rsec support?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by KaitoDaumoto

makes rsec support?

how about the source 2.8 that been release ? so no need to modified serverfile . .isnt it?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

how about the source 2.8 that been release ? so no need to modified serverfile . .isnt it?

yeah you're still talking about the source.

Quote:

Originally Posted by alphaest

The version that got released by that asshole has a major security issue. Good luck!

doesn't really know specifically what he is talking bout,but 3.0 ftw for me.

Quote:

Originally Posted by KaitoDaumoto

makes rsec support?

and doesn't really get what are you trying to say.

Re: rSec 3.0 - RYL Server Security Software

test on v1900 . .result not working :laugh:

Code:

Exception: System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary. at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at rSec.Server.Data.SkillScript.ClassLearnedSkills(Byte bClass) at rSec.PacketChecker.WorldLoginReturn(Packet p, Character c) at rSec.Server.PacketForwarder.ServerToClient_IncomingPackets(Session sender, Packet p)

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

test on v1900 . .result not working :laugh:

well then I guest you're f*cked.

Re: rSec 3.0 - RYL Server Security Software

Dear alpha i need your help

What offset to modify to make red colored chat in client.exe for RYL2 ??

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by matt_warfare

well then I guest you're f*cked.

hell yeah! rsec support only for shit version of RYL/ROW :fanny:

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by nazaryman

Dear alpha i need your help

What offset to modify to make red colored chat in client.exe for RYL2 ??

In my forum knowledge portal is a picture of olly/hex, search for those values in your client. The colors are constants.

Quote:

Originally Posted by BountyHunter

hell yeah! rsec support only for shit version of RYL/ROW

Versions supported by rSec were those active/popular at that time. So i would turn this around and say your choice for the version is shit.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

Features
[list]
[*]Ryl 1 and Ryl 2 support

you need to edit this line then . . write only which RYL2 version that fully work with rsec . . :bath:

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

In my forum knowledge portal is a picture of olly/hex, search for those values in your client. The colors are constants.

Versions supported by rSec were those active/popular at that time. So i would turn this around and say your choice for the version is shit.

Dear alpha i cannot find the hex or what else can you show some tutorial ? or ?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

hell yeah! rsec support only for shit version of RYL/ROW :fanny:

so what's interesting about the version you are trying compared to the version that supported by the rsec?

Quote:

Originally Posted by BountyHunter

you need to edit this line then . . write only which RYL2 version that fully work with rsec . . :bath:

have you ever seen this before?

http://s28.postimg.org/7l2xwq9wd/r_Sec.jpg

Quote:

Originally Posted by nazaryman

Dear alpha i cannot find the hex or what else can you show some tutorial ? or ?

which version are you trying for my dearest friend? :sheep:

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

you need to edit this line then . . write only which RYL2 version that fully work with rsec . . :bath:

I agree. And mozilla, google, microsoft should list all websites it works on because there are some they don't work on.

- - - Updated - - -

Quote:

Originally Posted by nazaryman

Dear alpha i cannot find the hex or what else can you show some tutorial ? or ?

http://alpha.lutsu.ee/forum/viewtopic.php?f=10&t=11

Re: rSec 3.0 - RYL Server Security Software

Dear alpha i have setup a rsec bot chat , but it won't work

I have follow all your guide but it never work for me

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

In my forum knowledge portal is a picture of olly/hex, search for those values in your client. The colors are constants.

Versions supported by rSec were those active/popular at that time. So i would turn this around and say your choice for the version is shit.

well my dearest alpha .. i have 1 question here. How do i hex the server anyway ? i trying in ollydbg and also with hex but still i dont get any result ..

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by KaitoDaumoto

well my dearest alpha .. i have 1 question here. How do i hex the server anyway ? i trying in ollydbg and also with hex but still i dont get any result ..

I don't think this is the right place and I'm the right person to teach you how to use OllyDbg.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

I don't think this is the right place and I'm the right person to teach you how to use OllyDbg.

nono .. not about teaching how to use olly except give me the clue sir .. i found nothing by the way

Re: rSec 3.0 - RYL Server Security Software

answer my question alphaest

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by KaitoDaumoto

nono .. not about teaching how to use olly except give me the clue sir .. i found nothing by the way

There are color codes on my picture. Search for those under constants in rylclient module.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by nazaryman

Dear alpha i need your help

What offset to modify to make red colored chat in client.exe for RYL2 ??

Open your client.exe use olly , CTRL+B and search B8 DC DC DC FF

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

Open your client.exe use olly , CTRL+B and search B8 DC DC DC FF

I Already Search For It ..

Nothing Found On My Client.exe

Already use fresh + packed Client.exe . Same Result\

# EDIT #

- Now what must i do ? any idea ? ? ?

https://www.facebook.com/ajax/mercur...468&height=468

Re: rSec 3.0 - RYL Server Security Software

Open Client.exe using olly , search for this command

Code:

PUSH 3E80

, scroll down untill you see this code

Code:

MOV EAX,FFDCDCDC

, then change it to the code from alpha forum

Code:

MOV EAX, FFFF0000

, if you cant change the command , edit use binary string . CTRL+E on

Code:

MOV EAX,FFDCDCDC

paste this code

Code:

B8 00 00 FF FF

then click ok . .

Btw , i found another offset on RYL1 Client.exe with same command . 004e4edc(from alpha forum) & 0042F1A2 , last time i edited 004e4edc and the text colour not changing . havent try to edit both of them yet . .

Re: rSec 3.0 - RYL Server Security Software

Thanks bounty i love you !

But , can i change other color then red ?

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by nazaryman

Thanks bounty i love you !

But , can i change other color then red ?

Go google for html color code generator. Select your color and replace the code

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by IzzdihaR

Go google for html color code generator. Select your color and replace the code

I know the color code most of them just asking if i can use anycolor ...

- - - Updated - - -

Dear Bounty ...

Can you guide me to use irc bot, do not give that alpha guide i'm not understand ...

Re: rSec 3.0 - RYL Server Security Software

hahahahahaha .
alpha allways alpha..
fool allways fool.
dont you all realize it? :D
why alpha? why dont you help them ? :P
oh yes!
" K I D S " is never understand it. :)

IM SORRY TO CAUSE TROUBLE HERE.
BUT YES I WILL IGNORE ANY REPLY FOR THIS POST. (DO I C.A.R.E?)

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by ArmagedeonGamin

hahahahahaha .
alpha allways alpha..
fool allways fool.
dont you all realize it? :D
why alpha? why dont you help them ? :P
oh yes!
" K I D S " is never understand it. :)

IM SORRY TO CAUSE TROUBLE HERE.
BUT YES I WILL IGNORE ANY REPLY FOR THIS POST. (DO I C.A.R.E?)

Alphaest is like me too, ignore people / don't help people because BUSY.Hope you understand Arma

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by ArmagedeonGamin

hahahahahaha .
alpha allways alpha..
fool allways fool.
dont you all realize it? :D
why alpha? why dont you help them ? :P
oh yes!
" K I D S " is never understand it. :)

IM SORRY TO CAUSE TROUBLE HERE.
BUT YES I WILL IGNORE ANY REPLY FOR THIS POST. (DO I C.A.R.E?)

money fly away just because of 1 guys . .he did or he dint , no one care .. i mean alpha . . xD

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by BountyHunter

money fly away just because of 1 guys . .he did or he dint , no one care .. i mean alpha . . xD

Someone just leak alpha project and now alpha getting cry , that why alpha release rsec n rmap for free

Hey you BH, Can you tell me to setup irc bot from A - Z and please do not tell me about alpha guide it hard for me to understand

Re: rSec 3.0 - RYL Server Security Software

no idea . . i dont use the plugin . .

Re: rSec 3.0 - RYL Server Security Software

Hmm, 3 days find the solution for irc bot :'(

@ Bounty Hunter : Don't you mind to join me @ http://nhih.net

Re: rSec 3.0 - RYL Server Security Software

Too bad i don't speak broken english, your conversation seems so much fun QQ. Would someone translate it for me?

Re: rSec 3.0 - RYL Server Security Software

No need .. nothing here .. we talking about nice release .. =)

Re: rSec 3.0 - RYL Server Security Software

rSec 3.0 got little problem some plugin may not work correctly :)

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by nazaryman

rSec 3.0 got little problem some plugin may not work correctly :)

What plugins? as far i know. Donation Bot plugin alpha set as disable so it wont be listed in the plugin list.

if you talking about ITEM USAGER .. that YOUR PROBLEM not RSEC PROBLEM... we all use it WITHOUT ANY PROBLEM. that is YOUR PROBLEM

Re: rSec 3.0 - RYL Server Security Software

v1753 item usage is working , ryl1 v557 not working ^^

Re: rSec 3.0 - RYL Server Security Software

RoW also working.

Re: rSec 3.0 - RYL Server Security Software

Row1020 ?

Re: rSec 3.0 - RYL Server Security Software

Idk which version, but the one got from 4shared. rowtools.4shared.com if not mistaken

Re: rSec 3.0 - RYL Server Security Software

hi alpha thx for ur apps, but i hv some error message, pls help how to fix it

Code:

12-Oct-14 9:07:09 PM : [DB Data Validator] - EQ Check failed Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'EQ_Changed'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at rSec.Database.sendSelectQuery(Databases db, String Query) at rSec.DBTestsRunner.RunEQ() at rSec.DBTestsRunner.Tick(Object runner, ElapsedEventArgs arg) ClientConnectionId:e1b19170-7827-417d-a798-302e6eee1673

then i try use this query for fix problem

Quote:

ALTER TABLE [dbo].[CharInfo] ADD COLUMN [EQ_Changed] [bit] NOT NULL
GO

ALTER TABLE [dbo].[CharInfo] ADD CONSTRAINT [DF_CharInfo_EQ_Changed] DEFAULT ((1)) FOR [EQ_Changed]
GO

but sql showing error message

Quote:

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'COLUMN'.
Msg 1752, Level 16, State 0, Line 2
Column 'EQ_Changed' in table 'CharInfo' is invalid for creating a default constraint.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.

Re: rSec 3.0 - RYL Server Security Software

Use ms sql 2005 or newer.

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

Use ms sql 2005 or newer.

alpha, im use mssql 2005

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by alphaest

Use ms sql 2005 or newer.

im getting the same error and im using 2008 express r2.

so i tryed using this and the query was executed with no errors
ALTER TABLE dbo.CharInfo
ADD EQ_Changed bit NOT NULL CONSTRAINT DF_CharInfo_EQ_Changed DEFAULT 1
GO

the error "EQ check failed" disapeared but now it doesnt check any items.

10/15/2014 9:36:58 PM : [DB Data Validator] - Ended, 0 equipments and 9 medals checked

desperately looking for a fix for this. item bug is damn annoying to deal with

Re: rSec 3.0 - RYL Server Security Software

Guy Can you help me setting Mini fixes v,1 for fix zone crash db

Re: rSec 3.0 - RYL Server Security Software

cpu high sqlserver after used

60 - 70 %

CharItemLog disable it How do

Re: rSec 3.0 - RYL Server Security Software

Alpha, Rsec, works with sql 2012 too? Is compatible? Or i can find some kind of problem?

Re: rSec 3.0 - RYL Server Security Software

Ryan White, found the solution for that query?

- - - Updated - - -

This error keep on...:
Mensagem 156, Nível 15, Estado 1, Linha 5
Incorrect syntax near the keyword 'COLUMN'.
Mensagem 1752, Nível 16, Estado 0, Linha 2
Column 'EQ_Changed' in table 'CharInfo' is invalid for creating a default constraint.
Mensagem 1750, Nível 16, Estado 0, Linha 2
Could not create constraint. See previous errors.

Re: rSec 3.0 - RYL Server Security Software

Alpha... why i click skill book then connection lost ? how to fix

Re: rSec 3.0 - RYL Server Security Software

Thank Alpha... rSec Working For My VPS
Already Test All Hack Like

- GM Hack v1753
- Speeder ( using cheat engine )
- Skill Bug
- Bug Item

All Detect :)

Re: rSec 3.0 - RYL Server Security Software

Quote:

Originally Posted by fatin

Thank Alpha... rSec Working For My VPS
Already Test All Hack Like

- GM Hack v1753
- Speeder ( using cheat engine )
- Skill Bug
- Bug Item

All Detect :)

WHat your point ?

We all know rSec can stop all bugs what you write and we all or most know rSec can add toalty new features in game if you know how program !! :)