| Author |
 Topic  |
|
|
Zuel
Average Member
USA
540 Posts |
 Posted - 21 October 2005 : 11:43:23
|
This is for "Front Page News" by Wesley Brown.
http://www.snitzbitz.com/mods/details.asp?Version=All&mid=47
Problem is the Database file.
What I want to do is post some news but the max character string is defined in the Database.
MEMBER_ID#int#NULL#
N_DATE#varchar(20)#NULL#
N_TEXT#varchar(255)#NULL#
N_TEXT#varchar(255)#NULL#
I want that string 255 to become unlimited or a high number. Since my forum is usually active majority of the time, is there an updated script I can write to do this?
Thanks! |
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
Edited by - Zuel on 21 October 2005 11:44:02 |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 21 October 2005 : 12:55:52
|
| Off the top of my head, if you haven't added anything yet, I'd drop the row and add it back as N_TEXT#text#NULL# - if memory serves me correctly (or at least the 6 cups of coffee...) 'text' will make a memo field which will give you what you need. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Zuel
Average Member
USA
540 Posts |
|
|
Zuel
Average Member
USA
540 Posts |
Posted - 21 October 2005 : 15:10:24
|
Oh, haven't tried the memo. But his way worked too.
|
My Completed Mods: News Mod | Zuel's Avatar Add-on
In Development: World of Warcraft Member Roster | [C# Based Forum]
Note - I may take a few days to recieve your email. Hotmail filters all new emails as junk. Would be best to post all questions, concerns in a forum topic to catch my immediate attention. This way others can assist and also correct any similar mistakes.
MSN / E-Mail: ucyimDa_Ruler@Hotmail.com
Personal Bookmarks: How to work a DBS File
|
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 21 October 2005 : 19:45:35
|
quote:
Originally posted by ruirib
It should be
N_TEXT#memo#NULL#
really? according to the alt. mod guide I had dug up somewhere around here it didn't mention memo as a viable option... just text. Or is the guide in need of an update? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 October 2005 : 06:51:05
|
quote:
Originally posted by modifichicci
memo doesn't work in mysql, needs text
If you care to take a look at admin_mod_dbsetup.asp, in the MySQL code, you'd see that 'memo' is replaced by 'text'. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 22 October 2005 : 15:03:43
|
quote:
Originally posted by ruirib
This is what I know: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=5120
Don't know what to tell you. I see in the post it says memo, but in the txt file I downloaded (not sure if it was the same post) it says text ...
But since it worked I guess its a moot point. Maybe if I get the time today I'll dig in the code a little and see what I can see. |
|
|
| |
Topic |
|
Topic Locked
