Random Avatars Mod

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Post Reply
Extensions Robot
Extensions Robot
Extensions Robot
Posts: 27919
Joined: Sat Aug 16, 2003 7:36 am

Random Avatars Mod

Post by Extensions Robot » Wed Sep 05, 2007 3:00 am

Modification name: Random Avatars Mod
Author: mosheen
Modification description: Allows users to have multiple avatars of any type and will cycle through, randomly choosing an avatar for each of their posts.
Modification version: 1.1.7
Tested on phpBB version: See below

Download file: Random_Avatars_MOD_1.1.7.mod
File size: 35390 Bytes

Modification overview page: View


Selected tags:
  1. category
    1. Cosmetic
  2. phpbb
    1. 2.0.22
Support for this modification needs to be asked within this topic. The phpBB Team is not responsible or required to give anyone support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB MODifications Team may not be able to provide support.

This MOD has only been tested by the phpBB MOD Team with the phpBB version listed in the topic. It may not work in any other versions of phpBB.
(this is a non-active account manager for the phpBB Extension Customisations Team)

TerraFrost
Former Team Member
Posts: 5957
Joined: Sun Dec 26, 2004 3:40 am
Location: Austin, TX

Random Avatars Mod

Post by TerraFrost » Wed Sep 05, 2007 3:00 am

Modification validated/released

Notes:

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Wed Sep 05, 2007 11:49 am

Thanks, guys!

If you need update instructions from any specific version prior to 1.1.7, the original mod validation version, post 'em up and I will get it together for you when I can.

* Update Versions *
Update 1.0.17 TO 1.1.7- Added 03/05/2008

* Update Requests In Progress *
none
Last edited by mosheen on Thu Mar 06, 2008 1:54 am, edited 2 times in total.

kight
Registered User
Posts: 2
Joined: Thu Nov 15, 2007 7:37 am

Re: Random Avatars Mod

Post by kight » Thu Nov 29, 2007 10:26 pm

I'm installing with easyMOD and I got this error:

SQL PROCESSING HALTED

An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.

The failed line was:
INSERT INTO phpbb_avatars(user_id,user_avatar) SELECT user_id,user_avatar FROM phpbb_users WHERE user_avatar <> "";;

SQL ERROR: 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 ';> ""' at line 1





can you help me?

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Fri Nov 30, 2007 5:33 pm

mosheen wrote:OK... A little searching turned up this EasyMod FAQ thread: http://area51.phpbb.com/phpBB/viewtopic ... 21&t=12141

And a quote:
Nutzy99 wrote:For the love of God, how many times do I have to tell people that EM does not currently do SQL processing yet and that you will have to update your DB manually!?!?! If I could I would make my hand come of your monitor and give you a big dope slap on the forehead!! Laughing If you need help updating your DB, then this Tutorial on using phpMyAdmin could be helpful.
I wouldn't suggest posting a request for help over there :lol:
Last edited by mosheen on Thu Mar 06, 2008 12:59 pm, edited 2 times in total.

ricker33
Registered User
Posts: 12
Joined: Sat Nov 04, 2006 9:58 pm

Re: Random Avatars Mod

Post by ricker33 » Sat Jan 12, 2008 11:24 pm

Gave this a try on a test board. Seems ok. But have a few problems.

It dosen't seem to show a Random one. Picks the most recent, always. Might have been something I did. Still checking into it all. Mostly wondering if anybody else has this problem?
Admin controls exist for individual users, avatars, and forum-wide enable / disable.
Can enable forum wide, But cant seem to figure out how to allow just certain users?

Now this is on a HEAVILY mod'd board, so like I said still going through it.

Thanxs

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Sun Jan 13, 2008 12:26 am

The per user control is below the "Use Random Avatars" setting on the user administration page. It reads "(Admin) Random Avatars Enabled". Login as admin, go to the ACP > User Administration > Look up a user, then down in the avatars section you will find these settings.

If you want to initially have everyone set to NO, so that you can then enable a few users individually, in the initial SQL insert into phpbb_users, insert the default value of 1 for user_randomavatars and 0 for admin_randomavatars. This will set everyone's personal preference to YES on 'Use Random Avatars' and NO on '(Admin) Random Avatars Enabled'.

Thanks for checking it out!
Last edited by mosheen on Thu Mar 06, 2008 12:59 pm, edited 1 time in total.

User avatar
wads24
Registered User
Posts: 519
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: Random Avatars Mod

Post by wads24 » Wed Mar 05, 2008 4:34 pm

Great mod!!! First of all... I notice though that if user only has 1 avatar uploaded, and selects yes for random avatar, the avatar shows as missing... is this a fix for this?
Thanks in advance for a reply.

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Wed Mar 05, 2008 4:46 pm

Thanks for coming around, Wads24.
wads24 wrote:Great mod!!! First of all... I notice though that if user only has 1 avatar uploaded, and selects yes for random avatar, the avatar shows as missing... is this a fix for this?
I thought this issue came up a long time ago and was resolved. I will have to do some checking later. I am at work right now and can't dig into the code to see what is going on. I will update later.

User avatar
wads24
Registered User
Posts: 519
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: Random Avatars Mod

Post by wads24 » Wed Mar 05, 2008 4:56 pm

mosheen wrote:Thanks for coming around, Wads24.
wads24 wrote:Great mod!!! First of all... I notice though that if user only has 1 avatar uploaded, and selects yes for random avatar, the avatar shows as missing... is this a fix for this?
I thought this issue came up a long time ago and was resolved. I will have to do some checking later. I am at work right now and can't dig into the code to see what is going on. I will update later.
it may have been corrected... I installed this mod a long time ago... is there a upgraded version. I am running... Random_Avatars_MOD_1.0.17

Is there just a quick fix, or just a upgrade install instructions?
Thanks in advance for a reply.

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Wed Mar 05, 2008 5:16 pm

There are not upgrade instructions for the pre-validation (1.1.7) version. There will be with future updates.
Last edited by mosheen on Thu Mar 06, 2008 1:00 pm, edited 1 time in total.

User avatar
wads24
Registered User
Posts: 519
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: Random Avatars Mod

Post by wads24 » Wed Mar 05, 2008 5:24 pm

mosheen wrote:There are not upgrade instructions for the pre-validation (1.1.7) version. There will be with future updates.
well, when you get a chance... if you could give me some guidance, i would appreciate it... thanks :D
Thanks in advance for a reply.

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Thu Mar 06, 2008 12:12 am

OK, I just needed a few minutes with it to see what was up.

This will only happen in a very specific situation:
User has random_avatars=No. User adds an avatar. User changes random_avatars=Yes.

I am PMing you the change code from 1.0.17 to add a quick and dirty fix. I don't want to publish the fix here, because it will be specific to 1.0.17 and doesn't conform to the way the mod is handling things now in 1.1.7.

To get this thing validated, there were some MAJOR changes to the way this stuff works. It all looks the same on the forum, but for security and stuff it's all different.

I would suggest getting updated to 1.1.7, the one that was validated. I will try to get an update doc together for you. There are a lot of changes and it's going to be a mess to go through :cry:

Thanks for helping to make this a better mod!
Last edited by mosheen on Thu Mar 06, 2008 1:00 pm, edited 1 time in total.

User avatar
wads24
Registered User
Posts: 519
Joined: Fri Jun 10, 2005 4:44 am
Name: James

Re: Random Avatars Mod

Post by wads24 » Thu Mar 06, 2008 6:44 am

kight wrote:I'm installing with easyMOD and I got this error:

SQL PROCESSING HALTED

An error was encountered while processing the SQL commands. Further SQL processing has been halted. You may choose to complete the MOD installation anyway and perform the SQL commands manually yourself. However, at this point EM cannot guarantee the MOD will work correctly so you are best off seeking support from the Author before continuing further.

The failed line was:
INSERT INTO phpbb_avatars(user_id,user_avatar) SELECT user_id,user_avatar FROM phpbb_users WHERE user_avatar <> "";;

SQL ERROR: 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 ';> ""' at line 1





can you help me?

i had the same issue, just complete the install, then go into your phpmyadmin, and enter in the SQL manually:

Code: Select all

INSERT INTO `phpbb_avatars` ( `user_id` , `user_avatar` ) SELECT `user_id` , `user_avatar` FROM `phpbb_users` WHERE `user_avatar` <> "";
Thanks in advance for a reply.

User avatar
mosheen
Registered User
Posts: 259
Joined: Wed Apr 06, 2005 12:16 am
Location: Asheville, NC
Contact:

Re: Random Avatars Mod

Post by mosheen » Thu Mar 06, 2008 12:44 pm

OK... A little searching turned up this EasyMod FAQ thread: http://area51.phpbb.com/phpBB/viewtopic ... 21&t=12141

And a quote:
Nutzy99 wrote:For the love of God, how many times do I have to tell people that EM does not currently do SQL processing yet and that you will have to update your DB manually!?!?! If I could I would make my hand come of your monitor and give you a big dope slap on the forehead!! Laughing If you need help updating your DB, then this Tutorial on using phpMyAdmin could be helpful.
I wouldn't suggest posting a request for help over there :lol:

Post Reply

Return to “[2.0.x] MOD Database Releases”