| Author |
 Topic  |
|
|
The Zim
Junior Member
107 Posts |
 Posted - 15 February 2009 : 15:06:18
|
I guess I should put suggestions for features I would like to see added to Snitz Forums here. But anyways, the first is more like a question.
On my site, I have it set up with several "Bad Words" being replaced, however, whenever someone types in a word such as: assume, the first three letters are replaced. Help!
Another thing, is there a way to archive just individual topics, rather than the whole forum? I would like to keep some of the posts in a forum, but I don't need them all in there and I don't want to delete those ones either. Is there already a way to do this that I haven't found yet? Or am I just misunderstanding the option? I've posted a link to the forum that I don't want them all to be archived.
http://users5.titanichost.com/zimsgizmos/forums/forum.asp?FORUM_ID=5
moved here by HuwR< |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 15 February 2009 : 15:30:58
|
in answer to your bad words question, add it so that there is a space before AND after the word you want replacing.
You can prevent particular topics from being archived by setting the do not archive flag. It is a bit peculiar (I though we had changed it, but on checking we have not) to mark a topic not to be archived, click the 'lock' topic icon, then check the 'do not archive' check box and click ok. unfortunately, this has the effect of locking the topic aswell, so to unlock it, click on the 'unlock' icon, make sure the 'do not archive' is still checked and click ok, the topic will now be unlocked, but will not get archived when using the archive functions.
< |
 |
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 15 February 2009 : 17:19:37
|
| On both of my forums only leading spaces stick in the bad word filter, trailing spaces are not saved to the database (MySql) and as far back as I can remember they have not.< |
Switch the order of your title tags |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 February 2009 : 01:40:20
|
| never heard of such a thing before, it is not the job of a database to trim what you are trying to insert into it, do you have some odd setting on your db that might cause that? I would be extremely angry if my dtabase interfeered with my data in that way.< |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 February 2009 : 06:42:27
|
| there is definately nothing in the code that would trim it, are you able to check what is in the table in the database to see if the space disappears on insert or when retrieving ?< |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 16 February 2009 : 08:43:28
|
Yes. I have SQLYog.
I'm sure now it's not my forum code. If I add the row manually in SQLYog, then refresh the table, the trailing space is gone, so the DB is doing it.... Grrr....< |
Switch the order of your title tags |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 February 2009 : 08:59:37
|
what version of MySQL are you using ?
The problem only affects earlier versions of MySQL prior to version 5< |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 16 February 2009 : 09:16:48
|
right, that is probably why then, according to MySQL site varchar fields have trailing spaces removed in versions upto and including 4.1
quote:
Trailing spaces in MySQL version up to and including 4.1 are removed from values when stored in a VARCHAR column; this also means that the spaces are absent from retrieved values.
so, you can either upgrade the version of your MySQL, or alternativley you could change the varchar column into a Text column instead, then it will not trim the trailing spaces.< |
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
Posted - 16 February 2009 : 11:23:51
|
Well, how cool is that! I may be able to finally fix this. I'll talk to my host first to see which we'll do.
Thanks!< |
Switch the order of your title tags |
|
|
|
The Zim
Junior Member
107 Posts |
Posted - 17 February 2009 : 11:53:28
|
| Well, the archive thing works, but could you maybe put a button for archiving individual topics in a later version?< |
|
|
|
|
bobby131313
Senior Member
USA
1163 Posts |
|
|
AnonJr
Moderator
United States
5768 Posts |
|
| |
Topic |
|
Topic Locked
