NukeXchange Network

          

NukeZone Hosting - Fast, Affordable and Dependable
Nuke Fixes · NukeForums · NukeZone Hosting · NukeUnited · Nuke Sites · Nuke Skins · NukeLance
Nuke Resources
 :: Home  :: Downloads  :: Your Account  :: Forums  :: Advertise :: 
Login or Register
Main Menu
General
 Main
 AvantGo
 Banner_Clients
 cfaq
 Donations
 Downloads
 Forums
 Members_List
 Private_Messages
 Search
 Stories_Archive
 Submit_News
 Surveys
 Topics
 Web_Links
 Your_Account

Your Account
 Login
 Register
 Lost Pass

Modules
Quick Links
· CMS Focus
· Domain Names
. Game Quest
· Learning Linux
. MateMaker
· NukeFixes
· NukeForums
· NukeLance
· Nuke Sites
· Nuke Skins
· NukeZone Hosting
. SearchDevil
Other Options

Download Resources
· Nuke Downloads
· Add a Link
· New Files
· Top Rated
· Most Popular

Web Site Resources
· Nuke Sites
· Add A Site
· New Sites
· Top Rated
· Most Popular

Support
· NukeZone Hosting
· NukeSkins.com
· NukeForums.com
· phpnuke.org
· NukeFixes.com
Information
NukeForums
·PHPNuke 8 security worries
·PHP-Nuke SQL Injection Vulnerability Fix
·decompressing EN-Book-Nuke.tar.tar
·How to allow spaces/gaps/"-" in allowed usernames
·How to Setup PHPNUKE on win2k
·cannot save changes
·voting?
·Nuke forum picture problem
·How to change smtp port on wampserver and windows
·yet another 301 redirect problem

read more...
Top10 Links
· 1: Nuke Forums
· 2: PHPNukeFiles
· 3: NukeSkins
· 4: Nuke Templates
· 5: EcomJunk
· 6: MDesign
· 7: Windows Installation: PHP
· 8: FLASH-FOR-NUKE
· 9: Dezina
· 10: Global Dream News Sharing Portal!
Site Visitors
User Login:

Nickname:
Password:
Security Code: Security Code
Type Security Code Here:

Members List Membership:
Latest: tones
Today: 1
Yesterday: 2
Overall: 15105

Visitation:
Guests: 578
Members: 0
Total: 578


You are Anonymous user. You can register for free by clicking here
Sponsor Links
php-Nuke Themes and Templates
php-Nuke Themes and Templates

NukeResources :: View topic - signature's
NukeResources Forum Index

NukeResources Forum Index -> Upgrading PHP-Nuke -> signature's Goto page Previous  1, 2, 3  Next
Post new topic  Reply to topic    View previous topic :: View next topic 
PostPosted: Sun May 14, 2006 6:38 pm Reply with quote
Magnum
Resource Seeker
Resource Seeker
 
Joined: May 10, 2006
Posts: 11




no prob thanks man

_________________
05\' KingCab Titan SE,Smoke ,Flowmaster 70 Series duel straight back ss tips, Mud Gaurds,Hawaiian seat covers,Nissan Step Rails,Bed Liner,Kenwood dvd stereo 1,xta480.2 XstreamSound amp,1,xta480.4 XtreamSound amp,2 MB Quart front speaker 2 Polk 6500 back s
View user's profile Send private message Visit poster's website
PostPosted: Sun May 14, 2006 10:12 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




sql query:
Code:
ALTER TABLE `nuke_users` CHANGE `user_sig` `user_sig` TEXT NULL DEFAULT NULL


to explain this code ill tell u what this does..now this changes it from varchar to text..no limit on the code amount...evaders would know more about whether or not this is the correct way to do it..using text instead of varchar...but i know it works...it even allows bbcode still so yeah.

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
PostPosted: Mon May 15, 2006 7:13 pm Reply with quote
Magnum
Resource Seeker
Resource Seeker
 
Joined: May 10, 2006
Posts: 11




um soo i just go into myphpadmin and go to user sig and click on sql and add that line to the query and hit save? yes im a newbie

_________________
05\' KingCab Titan SE,Smoke ,Flowmaster 70 Series duel straight back ss tips, Mud Gaurds,Hawaiian seat covers,Nissan Step Rails,Bed Liner,Kenwood dvd stereo 1,xta480.2 XstreamSound amp,1,xta480.4 XtreamSound amp,2 MB Quart front speaker 2 Polk 6500 back s
View user's profile Send private message Visit poster's website
PostPosted: Mon May 15, 2006 10:03 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




exactly Laughing

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
PostPosted: Mon May 15, 2006 10:56 pm Reply with quote
Magnum
Resource Seeker
Resource Seeker
 
Joined: May 10, 2006
Posts: 11




OMG it WORKS! thanks so much darklord you are the man! Very Happy now i can get some sleep i cant thank you enough .

_________________
05\' KingCab Titan SE,Smoke ,Flowmaster 70 Series duel straight back ss tips, Mud Gaurds,Hawaiian seat covers,Nissan Step Rails,Bed Liner,Kenwood dvd stereo 1,xta480.2 XstreamSound amp,1,xta480.4 XtreamSound amp,2 MB Quart front speaker 2 Polk 6500 back s
View user's profile Send private message Visit poster's website
PostPosted: Tue May 16, 2006 10:26 pm Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




dont thank me...thank evaders for seein what i missed.

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
PostPosted: Sat May 20, 2006 2:25 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




What darklord posted will work. Just for efficiency, I would leave it as a VARCHAR with a specific text limit.. say 1000 characters. That way, people can't post "books" of text in their signatures. Wink

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Sat May 20, 2006 3:52 am Reply with quote
darklord
Resourceful
Resourceful
 
Joined: Feb 25, 2006
Posts: 210




i tried to leave it varchar...it stopped me from going over 255 characters.

_________________

for those who STAND shall NEVER fall and those who fall shall rise once more...never give up the end is just another beginning.
View user's profile Send private message Send e-mail Visit poster's website Yahoo Messenger
PostPosted: Mon May 22, 2006 12:02 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Ah sorry, DarkLord is correct. I forgot VARCHAR is limited to 255. No choice but to use TEXT

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Mon Jul 03, 2006 2:46 pm Reply with quote
pcnuke
Resource Seeker
Resource Seeker
 
Joined: Jul 10, 2005
Posts: 18




(using v3.1 updates)

Couple of questions regaurding the signature area of the forum. A few people have been having this problem it seems like forever and Ive posted this one here before, but never got a solution for it. It seems its been happening since the release of Nuke 7.7+, currently using v7.9.031e


Currently I have the signature settings in the forum/admin section set to 1500 characters and the databae reflects the same amount, but that doenst seem to work because everything gets cut of at around 250.. some characters no matter what the admin settings are.

I checked the database, namely this table:

Server: localhost - Table: nuke_bbconfig

I then browsed it and here regaurding the sig it states the correct value of 1500: Edit

max_sig_chars 1500

now when I choose to edit that area, to view it it says:

config_value varchar(255)

is this whats killing my listed characters number, is this setting only allowing me a maximum of

varchar(255)

no matter what I set the admin amount to?

Also when going the the nuke_users table and try adjusting this section

user_sig varchar(255) Yes NULL

and try to set it higher than 255 characters it will not allow it. Like the same area above, its seems to be syuck at 255 characters..

NukeResources, same problem: http://www.nukeresources.com/ftopict-3439-signature.html

NukeFixes posts: http://www.nukefixes.com/ftopict-2304.html#9509

Previous post: http://www.nukefixes.com/ftopict-2136-signature.html


any ideas on a way to fix this problem of adjusting the sig size in the forum, Weve had about 10 others who are experimenting this same problem to.

=============================

Also do I have to add a forum mod to display flash sigs in the forum?



thanks
pcn


Last edited by pcnuke on Tue Jul 04, 2006 3:15 am; edited 1 time in total
View user's profile Send private message
PostPosted: Tue Jul 04, 2006 1:34 am Reply with quote
Evaders99
Resource Master
Resource Master
 
Joined: May 25, 2004
Posts: 1785




Change
user_sig varchar(255)

to use TEXT instead

_________________
- Star Wars Rebellion Network - Evaders Squadron Coding -

Need help? Nuke Patched Core, Coding Services, Webmaster Services
View user's profile Send private message Visit poster's website AIM Address
PostPosted: Tue Jul 04, 2006 3:22 am Reply with quote
pcnuke
Resource Seeker
Resource Seeker
 
Joined: Jul 10, 2005
Posts: 18




yup, that fixed the problem

thanks
pcn


Last edited by pcnuke on Sat Jul 22, 2006 5:04 am; edited 1 time in total
View user's profile Send private message
PostPosted: Thu Jul 20, 2006 4:36 pm Reply with quote
BlkDrgn28
Resourceful
Resourceful
 
Joined: Mar