_PrivilegedIP Ip too large ?

03/24/2012 01:11 Serenduk#1
im trying to enter ip into table

xx.xxx.xxx.xx

but it returns an error :

Code:
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 ?
03/24/2012 16:04 ✗EpicSoul✗#2
the ip max is (255)
03/24/2012 16:42 Serenduk#3
so having the ip 80.299.blah is no good lol
03/25/2012 03:05 H34D_B4NG3R#4
dont change the ip first try to make another table with the same properties but max value 299 and call it _PrivilegedIP
03/25/2012 03:15 Kape7#5
Quote:
Originally Posted by Serenduk View Post
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
03/25/2012 03:21 H34D_B4NG3R#6
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
03/25/2012 11:19 6_lucifer_6#7
Quote:
Originally Posted by Synx7 View Post
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
03/25/2012 18:47 Serenduk#8
my ip is 80.229.***.*
but doesnt matter i just use srpatch
03/25/2012 18:56 Kape7#9
Quote:
Originally Posted by Serenduk View Post
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.

[Only registered and activated users can see links. Click Here To Register...]

I always seen the thing of change the whole table very messy >_>
03/25/2012 19:56 Serenduk#10
:P i posted that early hour of the morning so i guess im aloud to make a little mistake no ;)
03/25/2012 19:58 CraYu#11
USE SR_AccountDB/SRO_VT_ACCOUNT
SELECT dbo.make_ip('127','0','0','1') AS RESULT