_PrivilegedIP Ip too large ?

[Serenduk]

im trying to enter ip into table

xx.***.***.xx

but it returns an error :

Msg 244, Level 16, State 1, Line 1
The conversion of the varchar value '299' overflowed an INT1 column. Use a larger integer column.

is my priv ip table wrong or ?

[✗EpicSoul✗]

the ip max is (255)

[Serenduk]

so having the ip 80.299.blah is no good lol

[H34D_B4NG3R]

dont change the ip first try to make another table with the same properties but max value 299 and call it _PrivilegedIP

[Kape7]

Originally Posted by Serenduk

so having the ip 80.299.blah is no good lol

You can't have an ip which contains 299 value, LOL.
IP's are 4 fields 8 bits each, which makes a total of 32 bits. Max value of each field is 255.
11111111 = 255

[H34D_B4NG3R]

lol, synx you're right..the range is from 0.0.0.0 to 255.255.255.255 ; i havent thought about it.
I think from where he got that ip lol

[6_lucifer_6]

Originally Posted by Synx7

You can't have an ip which contains 299 value, LOL.
IP's are 4 fields 8 bits each, which makes a total of 32 bits. Max value of each field is 255.
11111111 = 255

i was about 2 say that like 2 days a go.. i had idea but coundt express..

any way... try 2 change ur mac adress

if that dosent help.. setup hamachi on host and on ur pc and set hamachi ip as 2th and major ip as 1st 1 and put hamachi ip into db

[Serenduk]

my ip is 80.229.***.*
but doesnt matter i just use srpatch

[Kape7]

Originally Posted by Serenduk

my ip is 80.229.***.*
but doesnt matter i just use srpatch

You said 299 not 229!
Instead you should have left the _PrivilegedIP table as it was originally and use a program or something to convert your IP to int.



I always seen the thing of change the whole table very messy >_>

[Serenduk]

:P i posted that early hour of the morning so i guess im aloud to make a little mistake no

[CraYu]

USE SR_AccountDB/SRO_VT_ACCOUNT
SELECT dbo.make_ip('127','0','0','1') AS RESULT