Bravo List
Register
Go Back   > Bravo List > Source Code > Archived Trackers > TBDev
Reply
  #1  
Old 30th August 2021, 22:25
elvira's Avatar
elvira elvira is offline
Senior Member
 
Join Date: Jan 2008
Slovenia
Posts: 172
Default ipv6
hello all,

what must do in userdetails to show me complete ipv6 address

Click the image to open in full size.
Reply With Quote
  #2  
Old 30th August 2021, 23:39
DND DND is offline
VIP
 
Join Date: Dec 2008
Posts: 1,241
Default
make a longer varchar field in the database for any ip you have (users, peers, snatched) and so on
ipv4 is 15 but ipv6 should be 39, just make it varchar(40) to be sure
the best and recommended way to store ipv6 is varbinary(16)
__________________
Need HELP!? I can install:

  1. Server/VPS (Debian,CentOS,Ubuntu,Fedora, FreeBSD) Optimization and ... + Modules
  2. Webserver Windows/Linux (Apache/Lighttpd/Nginx/Mysql/PhpMyAdmin/SSL) Optimization and ... + Modules
  3. Seedbox Windows/Linux (uTorrent,rTorrent,libTorrent,ruTorrent) + Modules
  4. Multiple source code engines
  5. Linux Server Administration (security, cryptography/encryption, proxy, load balancer, custom ddos firewall)
Reply With Quote
  #3  
Old 1st September 2021, 20:27
elvira's Avatar
elvira elvira is offline
Senior Member
 
Join Date: Jan 2008
Slovenia
Posts: 172
Default
Thanks, @DND for this info.
Reply With Quote
  #4  
Old 21st October 2021, 01:58
elephant2 elephant2 is offline
Member
 
Join Date: Oct 2008
P2P
Posts: 3
Default
Quote:
Originally Posted by DND View Post
the best and recommended way to store ipv6 is varbinary(16)
With this approach you can also use INET6_ATON()/INET6_NTOA() in mysql.
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT +2. The time now is 19:59. vBulletin skin by ForumMonkeys. Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.