Popup on Birthday

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

NOTICE: This forum is only for the announcement of new releases and/or updates of MODs. Any MOD support should be obtained through the Customisations Database in the support area designated for each MOD.

A direct link to support for each MOD is in the first post of the respective topic.
ScrapbookSupplies
Registered User
Posts: 361
Joined: Tue Jan 16, 2007 7:59 pm

Re: Popup on Birthday

Post by ScrapbookSupplies »

lefty74 wrote:Jeanne, many congratulations on your birthday!

index.php is not supposed to be edited with this mod so you may be looking at the wrong instructions (probably email on birthday?)
Thanks Lefty. ;)

I was looking at the wrong one, after being so careful not to do that!

At any rate, I did get the problem resolved. I am not sure why I have that same little piece of code in that file twice but it was already there so I'm not going to mess with it. I set our test account up with a birthday today and it popped up with the message and also sent an email, so we're in good shape! I love your mods Lefty!!

Thanks so much,
Jeanne

Anyasha
Registered User
Posts: 704
Joined: Mon Aug 07, 2006 4:02 am
Name: Anyasha

Re: Popup on Birthday

Post by Anyasha »

This did not work at all on my board. I did the database changes, cleared the cache, set the board setting to "yes", and nothing happened. When I viewed the source, the javascript wasn't even in there even though I had refreshed all the templates. It was like it wasn't recognizing the birthday at all.

In addition, a non-popup version would be nice as I don't know many people who don't have popup blockers installed. The new versions or IE and Firefox come with them anyway. I tried modifying it to use document.write and have a div layer as I did for the PM notifications, but I can't test it out because it doesn't even show. (And yes, I tried it with the original MOD version first.)
Kiss me, I'm Polish!

Meleman
Registered User
Posts: 33
Joined: Wed Jan 16, 2008 3:54 pm

Re: Popup on Birthday

Post by Meleman »

How do you edit the message in the pop-up window? Is it done in the birthday_popup.html file?

Thanks in advance.

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

you will need to change the edit in language/en/posting.php
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

tommekemc
Registered User
Posts: 457
Joined: Wed May 14, 2008 6:36 pm
Location: Belgium
Contact:

Re: Popup on Birthday

Post by tommekemc »

great mod!
my sig
my projects

images deleted because of the 6kb (wtf?) rule...

User avatar
TheInquistor
Registered User
Posts: 304
Joined: Tue Jun 19, 2007 11:36 pm

Re: Popup on Birthday

Post by TheInquistor »

Excellent MOD. Now i just need a birthday :?

Does this MOD have a file or whatever is eeded for the mod_version_check?
[noob]ME[/noob]

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

TheInquistor wrote:Excellent MOD. Now i just need a birthday :?

Does this MOD have a file or whatever is eeded for the mod_version_check?
no, i will look at this at some stage tho... just havent had the chance yet.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
TheInquistor
Registered User
Posts: 304
Joined: Tue Jun 19, 2007 11:36 pm

Re: Popup on Birthday

Post by TheInquistor »

i never tested this till my birthday yesterday. Then i was locked out of the board until i could get my backdorr to disable the module. It was a tad bit annoying

Code: Select all

Fatal error: SQL ERROR [ mysql4 ]

Unknown column 'user_birthday_popup' in 'field list' [1054]

SQL

UPDATE phpbb_users SET user_birthday_popup = 1218834541 WHERE user_id = 16

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/functions.php
LINE: 3490
CALL: dbal_mysql->sql_query()

FILE: includes/functions.php
LINE: 3103
CALL: page_header()

FILE: 
LINE: 
CALL: msg_handler()

FILE: includes/functions.php
LINE: 2366
CALL: trigger_error()

FILE: ucp.php
LINE: 81
CALL: login_box()


in /home/account/public_html/forums/includes/db/dbal.php on line 602
[noob]ME[/noob]

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

my belated congratulations :)

looks like the sql statement was either not executed at all or only partially when the mod was installed.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
TheInquistor
Registered User
Posts: 304
Joined: Tue Jun 19, 2007 11:36 pm

Re: Popup on Birthday

Post by TheInquistor »

ok so reading that says its all sql. thats good i assume. Now the question is that if i just redo the sql inputs, will it damage anything went thru ok?
[noob]ME[/noob]

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

Extract from teh install file

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('birthday_popup', '0');
ALTER TABLE phpbb_users ADD user_birthday_popup INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
Either both of the above or only the second one were not executed when installing the mod. If you have debug off, the field in the first part of the statement quite possibly would have been created automatically when going to the ACP. However, the second one would still need to be done as that seems to be missing according to the error message.
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
TheInquistor
Registered User
Posts: 304
Joined: Tue Jun 19, 2007 11:36 pm

Re: Popup on Birthday

Post by TheInquistor »

hmmm...odd

Code: Select all

Error
SQL query: 

INSERT INTO phpbb_config( config_name, config_value ) 
VALUES (

'birthday_popup', '0'
);



MySQL said:  

#1062 - Duplicate entry 'birthday_popup' for key 1 
tho i did not get an error on the first line. i will test this before bed caue of the wait i must do for it to automatically log me out when it errors
[noob]ME[/noob]

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

that's what i meant, the first part of the sql was probably done when you accessed the module on the acp, try only the second one:

Code: Select all

ALTER TABLE phpbb_users ADD user_birthday_popup INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
dont forget to purge the cache afterwards.
TheInquistor wrote:i will test this before bed caue of the wait i must do for it to automatically log me out when it errors
you have to wait?
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

User avatar
TheInquistor
Registered User
Posts: 304
Joined: Tue Jun 19, 2007 11:36 pm

Re: Popup on Birthday

Post by TheInquistor »

lefty74 wrote:that's what i meant, the first part of the sql was probably done when you accessed the module on the acp, try only the second one:

Code: Select all

ALTER TABLE phpbb_users ADD user_birthday_popup INT( 11 ) UNSIGNED NOT NULL DEFAULT '0';
dont forget to purge the cache afterwards.
It now works right as coded :mrgreen:
lefty74 wrote:
TheInquistor wrote:i will test this before bed caue of the wait i must do for it to automatically log me out when it errors
you have to wait?
yes it was a little bug i noticed. When you login, you are logged in. you have the redirect window appear and when it does the redirect, the error fires. But you are currently logged in. There is a link to return to the indea, but your still logged in and you just get the error over and over again. You have to wait until the forums automatically log you out by timeout. It sucked to learn this cause i couldnt access my board for what seemed like a loooong time
[noob]ME[/noob]

User avatar
lefty74
Registered User
Posts: 3649
Joined: Wed Sep 14, 2005 8:26 pm
Location: NL
Contact:

Re: Popup on Birthday

Post by lefty74 »

TheInquistor wrote:yes it was a little bug i noticed. When you login, you are logged in. you have the redirect window appear and when it does the redirect, the error fires. But you are currently logged in. There is a link to return to the indea, but your still logged in and you just get the error over and over again. You have to wait until the forums automatically log you out by timeout. It sucked to learn this cause i couldnt access my board for what seemed like a loooong time
in case that happens again you could try to comment out the code that causes the error and clear your cache via ftp, at least that's what i would try ;)
lefty74
zoocrew.eu - help us save our wildlife
My MODS | Due to lack of time I unfortunately am unable to work on my mods anymore, anyone who has ideas to improve them and would like to take any of them over, please PM me.

Locked

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