Amazing what happens when you try and egg yourself. >_> lol You get egg in the face alright.

OMG this freakin rules! I love the throw kisses! Works great.

OK, when you egg yourself there is a nasty database error. Can you fix it so you can either egg yourself or not be able to click the link?

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT count(eggtype) as totaleggs FROM eggavatar WHERE userid = AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600);

MySQL Error : 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 'AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600)' at line 1
Error Number : 1064
Request Date : Sunday, March 15th 2009 @ 10:52:46 PM
Error Date : Sunday, March 15th 2009 @ 10:52:47 PM
Script : /bbs/eggavatar.php?do=addegg&p=1437306
Referrer : /bbs/f27/106476.html#post1437306
IP Address : 24.112.11.11
Username : rinkrat
Classname : vb_database
MySQL Version : 4.1.20

You should not be able to egg yourself - the problem must be something else. What you should see is either a nothing to do error message, or options to clean if appropriate. See attachments.

Thanks for the fix,
but when I try to upgrade I got this error :

Invalid SQL:
ALTER TABLE usergroup ADD eggavatarpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'eggavatarpermissions'
Error Number : 1060
Request Date : Monday, March 16th 2009 @ 09:29:54 AM
Error Date : Monday, March 16th 2009 @ 09:29:54 AM
Script : /admincp/plugin.php?do=productimport
Referrer : /admincp/plugin.php?do=productadd

It didn't uninstall properly. Uninstall it, and reinstall. If it still doesn't work them you'll have to manually delete the column eggavatarpermissions from your database (though I'm not sure why uninstalling first wouldn't do that for you).

Actually, if you wait 10 mins I've got a minor update on the way anyway. :p

Minor update just put up. Fixes popup/cost display bug, and fixes images losing color when placed on some avatars.

Thank you :)

Updated...working OK
Animated avatars are not animated more! But I take that like good options

You mean they stop being animated when egged? They should go back to being animated when cleaned.

This is on the list of things I will fix eventually, but, I may leave the current way as an option when I do.

Either way, not really a bug.

Yes, they are back animated when they are cleaned...but I like that when they are egged, they stop animation...it is OK

Do you think to do something same for signatures (egged signtures :) )

Nice like it.. The only thing I see that I really don't like and maybe you could help me figure it out is I have it cost 25 to throw. and wanted 100 to clean all. maybe 25 to clean one.. but mine says 25 credits to egg, 100 credits to clean, 25 to clean all.??

You are correct - thank you. I fixed it. I didn't bother with a point release since I had just released this version and it's a minor fix. If you already have 1.2.2 installed then don't reinstall, just unzip the zip file and upload the files again.

Cool fixed.. Thanks alot and my members love it.. Great work.. Keep it up..

I'm getting this error from time to time :

Invalid SQL:
SELECT count(eggtype) as totaleggs FROM eggavatar WHERE userid = AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600);

MySQL Error : 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 'AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600)' at line 1
Error Number : 1064

Interesting. Can you watch for a pattern - maybe we can narrow down when it is happening.

All I do is clisk the green glob on my own avatar and it gives

MySQL Error : 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 'AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600)' at line 1

Error Number : 1064
Request Date : Sunday, March 15th 2009 @ 10:52:46 PM
Error Date : Sunday, March 15th 2009 @ 10:52:47 PM
Script : /bbs/eggavatar.php?do=addegg&p=1437306

Same thing happened to me on upgrade so I had to uninstall and then reinstall to upgrade which wiped all the previous eggings.

Hmmm. I'm going to put in a generic error message for no user id, but I'll also see if I can figure out what might be causing the specific issue. I'll keep you posted. It works fine for all other actions (egging someone else, cleaning someone else, etc?)

Downloaded and installed - though some of the phrases need sorting - Thow instead of Throw.

Good stuff though...

It's happening when a member clic to clean his avatar, but I did a test and could not reproduce this error :(

here is the appache log

- - [16/Mar/2009:00:10:43 +0000] "GET /forum/image.php?type=dberror HTTP/1.1" 200 1296 "http://www.site.com/forum/eggavatar.php?do=addegg&p=867945" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; GTB5; InfoPath.1)"

Thanks, the info should help.

How did I miss that? ARGGHHH! It's all I can see now lol

Hey i just installed this just one small problem when i throw something it don't display my avatar just says Bullet's Avatar any help?

anyone using this with Live Topic?

I have this problem too but Im sure the usergroups are correct :confused:

I'm too scared to.

I think I'd start Global Nuclear War if the two were running at the same time...either that or my server would melt.

Installed and it did not take long for the members to start having fun with it. Anyone know if I could integrate this with VbExperience points?

I am, no problems

Updated my version and is now working great .... No errors so far :)

thanks and no iissues with any animated av's?

The Button is not showing up to egg folks after installing it :confused:

Im sure the usergroup privs are correct

Could it be conflicting with TMS?

Can anybody help? :o

Thanks

The same sql message error on Private message :

Maybe the button should not show up on Private message.

Sorry, not showing up on mine either.

There is no reason for it to show up on private messages - they don't even have a postbit, unless you've got some mod or style change that adds that stuff in.

Make sure you go into all the usergroups and set their permissions to be able to see and throw eggs. Other than that, I can't see any reason for the button to not show up, unless your postbit has been pretty heavily modified. It positions itself using the 'online' button.

Mines still not working i have all permissions set etc but when anyone uses it the persons avatar just don't show its just a broken image.

If you want to pm me login info I'll see what I can figure out for you.

Sorry to bother you again, but I received this:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT count(eggtype) as totaleggs FROM eggavatar WHERE userid = AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600);

MySQL Error : 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 'AND cleaned = 0 AND UNIX_TIMESTAMP( ) <= (dateline + 3600)' at line 1
Error Number : 1064
Request Date : Monday, March 16th 2009 @ 03:53:32 PM
Error Date : Monday, March 16th 2009 @ 03:53:32 PM