Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Author Message
shmk
Worker
Worker


Joined: Dec 21, 2004
Posts: 116

PostPosted: Fri Dec 24, 2004 5:05 am Reply with quote

I have 7.4 patched nuke and I wanna let user have a signature with more than 255 chars.
I incremented the value to 500... but in db user_sig is a varchar(255) and 255 is the max value that a varchar can be.
Can I change tha type of variable without make big security hole or great incompatibility problems ?
 
View user's profile Send private message
kguske
Site Admin


Joined: Jun 04, 2004
Posts: 6383

PostPosted: Fri Dec 24, 2004 7:59 am Reply with quote

Since there are many other text fields in various Nuke tables and even tinytext fields in the users table, I don't see any reason why changing the signature would significantly impact security. PHP handles type conversions easily, so there also shouldn't be incompatibility problems. Hack away...but backup and test first if it's an important site.

_________________
I google, therefore I exist...
Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message
shmk
PostPosted: Sat Dec 25, 2004 4:03 am Reply with quote

Quote:

PHP handles type conversions easily, so there also shouldn't be incompatibility problems


In chatserv patched version usually there are some controls on the variable get from db, is is some type of control on the size/type of signature to change ?
 
shmk
PostPosted: Tue Jan 04, 2005 11:14 am Reply with quote

Someone can tell me if it's better convert the varchar(255) to a "blob" or to a "text" variable type ?

What's the big difference between them ?
Can I simply modify the type in db or before have to do some strange operation ? :S
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Tue Jan 04, 2005 2:48 pm Reply with quote

I would stick witht a text type. Blobs are more overhead.
 
View user's profile Send private message
drmike
Worker
Worker


Joined: Jul 15, 2004
Posts: 108
Location: Charlotte, NC

PostPosted: Tue Jan 04, 2005 6:57 pm Reply with quote

I remember trying this in either PHPNuke or the standard alone verson of PHPBB and having it cut off anyway at the 255th letter. There's probably something in the code that cuts it off at 255 before saving it to the database. You may want to scan the profile code to double check.

I do have a couple of the types changed but I'm passing around 500K sized articles too. Smile

-drmike

(And kicking them out via autonews. Lots of fun)

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website ICQ Number
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©