Reliable blog mod?

[MWE_001]

Ok I went back and did some reading on the Official Blog Mod Thread and found where we all discussed for months on end this users being banned problem.

What it is doing is, when a new user registers, it sets them automatically to banned from creating a blog. They actually are not being banned simply from trying to create one. The are just bug victims.

To solve this, run this query in phpmyadmin

Code: Select all

ALTER TABLE `phpbb_users` CHANGE `user_allowweblog` `user_allowadvweblog` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '1'

That should fix the problem. There is another fix to take care of current users that are banned that wish to create a blog. Run this query in phpmyadmin and if there are any users currently banned, it will unban them and put every user you have back on the good foot.

Code: Select all

UPDATE `phpbb_users` SET `user_allowweblog` = '1' WHERE `user_allowweblog` = '0'

If you would like to read the entire 14 or 15 pages of materal, please do a quick search for the blog mod. The main author is the long lost but not forgotten Dragonsys.

[MWE_001]

You should be able to edit permissions as to who can view, create, comment etc..
Your members can also select who may view and comment on their blogs.

If you need more info, PM [url=http]MWE_001[/url]. He has installed this for many users and knows alot more about it than I do

If hers is unavailable, you can view mine here [url=http]Blog Mod In Action[/url]

It won't make you register to view, but it will to post.


Sorry this was meant to Viragotech. Not sure why I quoted Helter. <img> Sorry.


And I am awful sorry for the slow replies lately folks. I am just now finishing up my 2nd term at school. Just handed in finals tonight. I should be around a little more for a couple 2 or 3 weeks until the next term starts.

My next set of classes are

IT163-02: Database Concepts Using Microsoft Access

and

IT190-04: Foundations in Information Technology

[Lycanth]

No problem at all. It's good to see you around again!

[MWE_001]

I am really trying to make it a habbit to login here a couple times a day now. Who knows here in a couple weeks when school starts back up though. And it is great to be seen around here again. lol <img>

Hey let me know if that fix worked for your blogs Ly. And I still have all your info in my FTP client as well as dreamweaver if you need any help. The only thing I can not do from either of those is run them commands in your phpmyadmin.

[Lycanth]

I think most stuff is running smoothly....but there are a couple of things I know I'd really like, heh. Is it even possible to merge an old database with the present one? Story is: did a backup in march, then took a few months off (new baby), and my second in command accidentally deleted a big chunk of posts and data. The site has been active since and I don't want to overwrite the new data with the old, but just want to...splice the old into the current. I tried with bigdump but got this error:

Error at the line 3: INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id) VALUES('1', '1', '1', '2', '1204595865', '7F000001', '', '1', '0', '1', '0', '1254198994', '2', '0', '3', NULL, '0');

Query: INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, poster_ip, post_username, enable_bbcode, enable_html, enable_smilies, enable_sig, post_edit_time, post_edit_count, post_attachment, post_icon, post_bluecard, rating_rank_id) VALUES('1', '1', '1', '2', '1204595865', '7F000001', '', '1', '0', '1', '0', '1254198994', '2', '0', '3', NULL, '0');


MySQL: Duplicate entry '1' for key 'PRIMARY'


Any ideas? Can I change the values somehow, or change the post tables to auto_increment?


ETA: I'd really love for the arcade mod to be added to my HP site, too, if at all possible.

[MWE_001]

The arcade is no problem at all. That is easily done. It takes longer to upload games then it does to install the mod. Let me do a quick test install on my local server to make sure I still have it in me. I have installed it at least 100 times or more, but it has been at least 2 to 3 years since I did it last.

The database and splicing things, I really need Helterskelter to intervene on that one. I am getting better at tweaking databases but what I do not know about them will fill a book.

And a big belated congrats on the new baby!


Ray

[Lycanth]

Thank you Ray! And I'll wait and see what Helter says about the database. Hopefully it's not mission impossible!

[Helter]

It could possibly be done but i dont really know how. You would need a mysql expert to do it. There are just too many tables involved that all must be in sync.

[MWE_001]

And there you have it. lol Let me know if you need any help with the arcade or anything like that. I am off of school for a couple 2 or 3 weeks and have some time to spare. I ran a test install last night and all went well. The only issue is one minor bug in the script. The fix for it was located at foundit forum and that site is no longer. The error was not serious that it effects game play at all.

What the error amounted to was, at the bottom of the games page you could click numbers to get to different pages of games ..... 1,2,3,4,5, ... etc. If you clicked on any number it would give an error. I have it fixed on one of my old installs. I have looked at my files and cant recall what it was I had to do to fix.

But like I said, that error does not effect game play at all.

[Lycanth]

Thanks for replying Helter. Might just have to find a mysql expert and offer to pay for them to nut it out for me. Any suggestions on where to look for one?


Ray, whenever you have the time would be fine. You still have my email? If not, PM here works fine. I check in several times a day.

[MWE_001]

Messaged.

I am not sure of who to get a hold of about the database. It is too bad that happened to your info. I actually deleted like a weeks worth of a guys db on accident once and boy did I feel bad. I had a backup of it, but it was a week old. All we could do was move on from there and not look back. I felt REAL bad, he just kind of shrugged his shoulders and said no worries.

[Helter]

you could try http://www.freelancer.com/