Search found 71 matches

by gianni76
Sun Jan 28, 2007 7:08 pm
Forum: [2.0.x] MOD Requests
Topic: Multiple user delete
Replies: 1
Views: 162

Multiple user delete

I have been inhundated by spambots lately. I am trying to cleanup the forum, but my only change is to have an addon that allows to delete multiple users at once (like selecting a check box close to a list of users and then delete 50 or so at once and without further confirmations). The user delete o...
by gianni76
Sun Jan 28, 2007 7:06 pm
Forum: [2.0.x] MOD Requests
Topic: Delete all orphan posts
Replies: 1
Views: 117

Delete all orphan posts

I would like an addon that helps me clean-up my forum from spam. In particular I would like to have a button in the Admin window to remove ALL messages posted by users not existing anymore (because I deleted them for spam!). So the clean-up is much easier as I simply delete the spam users and then t...
by gianni76
Mon Jul 10, 2006 10:55 pm
Forum: 2.0.x Discussion
Topic: Reducing size: phpbb_search_wordmatch?
Replies: 4
Views: 652

I did that, but still not producing much effect (only few kB reduction).

Has anyone produced an optimised search function which reduces the size of the phpbb_search_wordmatch ?

That is really a killer on my forum!
by gianni76
Wed Jun 28, 2006 3:43 pm
Forum: [2.0.x] MOD Requests
Topic: Smilies upload
Replies: 0
Views: 190

Smilies upload

Hello, i would like to give my co-admins the possibility to upload some smilies to my server, without having them direct ftp access. is there any smilies upload addon? This would simply take the file and upload them in the right phpbb directory. Optionally it might combine with the smilies packager:...
by gianni76
Sun Jun 25, 2006 4:13 pm
Forum: 2.0.x Discussion
Topic: Reducing size: phpbb_search_wordmatch?
Replies: 4
Views: 652

Reducing size: phpbb_search_wordmatch?

Hello, I am trying to reduce the database size of my phpbb 2.1x forum and would like to know: a) does an addon exist to help with this? b) how can I reduce the database of seached words. For example I have the table: phpbb_search_wordmatch large 16 MB!!!! Can I delete it or do something to reduce it...
by gianni76
Thu Mar 30, 2006 3:29 pm
Forum: [2.0.x] MOD Requests
Topic: coloured titles
Replies: 1
Views: 289

Can anyone suggest where to look?
Using the search function does not seem to give useful pointers!
by gianni76
Thu Mar 23, 2006 9:40 pm
Forum: [2.0.x] MOD Requests
Topic: coloured titles
Replies: 1
Views: 289

coloured titles

I would like to have the possibility to insert font colours (red, pink, magenta etc) in the subject of some topics. While it is very easy to do this in the topic body, I cannot see the coulored titles possible by default. Is there any mod that allows it? I guess to do that they would need to define ...
by gianni76
Sat Feb 04, 2006 2:12 pm
Forum: [2.0.x] MOD Requests
Topic: usergroup colours
Replies: 1
Views: 166

usergroup colours

Hello, I have different usergroups in my forum. Problem is that the members of each usergroup will be shown in the same colour (green) when they happen to be online). Is there any MOD, (or can anyone create it), which simply allows to have different default username colours for each different usergr...
by gianni76
Wed Dec 28, 2005 12:11 am
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

robert these where uploaded from users and the absolute path was recorded. Same story for signatures and also other entries (such as blog entries where again images where uploaded via the upload function to an absolute path). All these paths are hard written in the SQL text values. I am absolutely c...
by gianni76
Tue Dec 27, 2005 11:14 pm
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

SmartSquid, thanks for your help. I now can see where you are moving to. The program would: 1. select the right tables 2. take the contents of them 3. do a regex on each of them 4. write the new values in the tables. As for the first part I think something like: SELECT * FROM users WHERE user_avatar...
by gianni76
Tue Dec 27, 2005 10:32 pm
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

It is not the name of the table that changed... it is the content...... With phpmyadmin I would need to go trough thousands of fields to rename all of them! An SQL query is what is needed here even if I do not know how to write it! To be precise what I need is a sort of small regex for SQL databases...
by gianni76
Tue Dec 27, 2005 10:18 pm
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

Just noticed that the same path change is necessary also for the files uploaded from the phpbb blog mod...

So an SQL query suggestion would be more than welcome!
by gianni76
Tue Dec 27, 2005 8:36 pm
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

Hi I moved the files but the avatars and signatures are in a specific path individually set inside each users's profiles (e.g. when they uploaded it etc). At present if I go inside this profile I can see this path being hard-linked to a specific directory on my server. This directory is not existent...
by gianni76
Tue Dec 27, 2005 8:26 pm
Forum: 2.0.x Support Forum
Topic: Need help with SQL query
Replies: 10
Views: 354

Need help with SQL query

I have moved my forum to a different directory and would like help with a SQL query to put the right path in all users' settings (their own avatars etc).

Can anyone help?
WHat I would like is an SQL query I can apply to all tables of the databse which renames path1 into path2.
by gianni76
Mon Dec 19, 2005 1:18 am
Forum: [2.0.x] MOD Database Cleanup
Topic: [2.0.10] BBcode Colours in Code
Replies: 16
Views: 13103

I have a request:

is it possible to apply the same mechanism for having colours in the Post Subjects?

I cannot find an easy way to have this!
If you try [color=red]text[/color] inside the title of a post it will simply not parse!

Go to advanced search