Smartys, thank you for your explanation. So, i should check out mods for forum permission then.
1 2008-01-27 01:31
Re: Support for multiple group membership (11 replies, posted in Feature requests)
2 2008-01-26 12:15
Re: Support for multiple group membership (11 replies, posted in Feature requests)
Smartys wrote:
That's not something that multiple group membership can solve. That's a new forum level permission.
Hmm.. let's say i restrict the access of Forum A to only User Group A, while User Group A has been set to no rights to edit post. Then if Member A is under both User Group A and User Group B (multiple group), when he is in other forums, he can do all the standard things but if he is in Forum A, he cannot edit post. Not?
3 2008-01-26 02:39
Re: Support for multiple group membership (11 replies, posted in Feature requests)
Yes, i would like to have this feature too.
I would like to disable editing of posts in some of the forums, but the ability to edit post could only be set under user group, but not the forum itself. While a user can only be in a group, this make it impossible to do what i want.
I am still stuck in the situation now. I would appreciate if there is a quick although temporary way (e.g. change some code in the script file) to have it function the way i want.
4 2008-01-19 03:17
Re: search.php $noise_match (3 replies, posted in PunBB 1.2 troubleshooting)
Thank you Smarty! This time my search.php showing '§' instead.
5 2008-01-19 03:04
Re: search.php $noise_match (3 replies, posted in PunBB 1.2 troubleshooting)
No answer yet?
6 2007-09-14 16:47
Re: insert data in mysql (6 replies, posted in Programming)
Thank you Smartys!
I just got it work before reading your reply. :-)
Now i just need to see if all the data would be matching/linking each others after inserting to the db2.
That's the only way i can do to import data into the forum tables since i can't write a complicated scripts.
7 2007-09-14 15:41
Re: insert data in mysql (6 replies, posted in Programming)
got error...
SQL query: Documentation
SELECT id, username,
PASSWORD , url, icq, msn, aim, yahoo, signature, timezone, num_posts, last_post, registered, last_visit, location, email, email_setting
INTO database2.users
FROM database1.users
LIMIT 0 , 30
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database2.users FROM database1.users
LIMIT 0, 30' at line 1
8 2007-09-14 15:15
Re: insert data in mysql (6 replies, posted in Programming)
elbekko, thank you thank you.... i try it out now...
i read up the tutorials of mysql but somehow all those things won't go into my head, i just can't sort it out, those commands are driving me crazy :-(
9 2007-09-14 12:57
Topic: insert data in mysql (6 replies, posted in Programming)
I have :
Database 1, Table A with field a, b, c, d
Database 2, Table A with field a, b, c, d, e, f, g
May i know how to extract the data of field a, b, c, d of Database 1 into Database 2's a, b, c, d field, using mysql query?
10 2007-09-13 16:27
Re: [Solved] changing timestamp, mysql query command needed (7 replies, posted in PunBB 1.2 troubleshooting)
It works! 
11 2007-09-13 16:21
Re: [Solved] changing timestamp, mysql query command needed (7 replies, posted in PunBB 1.2 troubleshooting)
Thank you! I try it out now...
12 2007-09-13 16:14
Re: [Solved] changing timestamp, mysql query command needed (7 replies, posted in PunBB 1.2 troubleshooting)
no.. it's because i never make it clear earlier on.
for e.g. in "topics" table, i need to update "posted" field and "last_post" field.
How should i type the command?
I'm using phpMyAdmin.
13 2007-09-13 13:07
Topic: search.php $noise_match (3 replies, posted in PunBB 1.2 troubleshooting)
May i know what is the last character of line 154 in search.php?
$noise_match = array('^', '$', '&', '(', ')', '<', '>', '`', '\'', '"', '|', ',', '@', '_', '?', '%', '~', '[', ']', '{', '}', ':', '\\', '/', '=', '#', '\'', ';', '!', '¤');I search the forum, one of the posts show as
¤, yet the other show as
*.
I could get a few different characters by opening the document in different encoding. I guess it should be asterisk?
14 2007-09-13 10:25
Re: [Solved] changing timestamp, mysql query command needed (7 replies, posted in PunBB 1.2 troubleshooting)
Hmm... i try to explain better...
My current server is in local time zone now, thus the current time (live) appear on the board is current and accurate, time zone difference is set at 0.
If i set the time zone to 13 hours difference, yes, all the old posts would have correct time/date appears on the board, but the current time (live) and all the new posts would be off by 13hours.
That's why i need to change the "posted" time being recorded in the mysql database instead of using the time zone feature.
I hope i make it clearer now. Thanks for your reply though.
15 2007-09-13 07:56
Topic: [Solved] changing timestamp, mysql query command needed (7 replies, posted in PunBB 1.2 troubleshooting)
Hi,
I moved the forum from a server which is having 13hours difference from my current server (my local time too).
Now all the date/time of the existing posts being shown 13 hours behind the actual date/time posted. e.g. the post showing 2007-09-12 10:00:00 currently, while the actual date/time should be 2007-09-12 23:00:00.
Anybody know of any MySQL query command that i can use to change the timestamp of all posts at 1 go?