vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   News & Email Community Bulletin Generator (https://vborg.vbsupport.ru/showthread.php?t=32517)

freeshares1 07-07-2002 02:16 PM

I have one really quick question. I would like 2 things.

1 - On the calendar events i would like these to be hyperlinks like the thread links. anyone point me in the direction?

2 - I have many events on the same day and would like to put a line space between each day.

Thanks in advance

Heineken77 07-17-2002 09:45 PM

I have a problem :(

I installed this hack, and it works wonderfully!!! :) It emails the bulletin and everything!! :D

BUT .. now when I go into member.php ((for example, try to access anything that deals with member.php))) I get this error

Quote:

Parse error: parse error, expecting `']'' in /home/hsphere/local/home/heineken/nba2k3.net/forum/member.php on line 902
My member.php file is attatched. Any ideas what I did wrong? :(

Sincerely,
Heineken

christec 07-17-2002 10:58 PM

Check your file, line 902 just ends, like it was cut off. At least in the file that you attached above.

Heineken77 07-18-2002 12:05 AM

Woohoo!! Chris bro I didn't even realize that!!

Thank you very much for pointing that out..I'm an idiot lol.

KILLER hack you guys put together here, and lovin' the HTML!!

Thanks again :)

Aurore 07-21-2002 08:08 AM

How could I get the dates in French?

Thank You

DestyNova 07-27-2002 01:26 AM

It works well but there is one small problem..

I have one vb at net and two at local (one clean install and one hacked with few hacks)

All three forums I test by add "username" thur Users category to add user and always get this error..

Code:

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,receivebulletin,receivebulletin_type,showemail,invisible,usertitle,customtitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday) VALUES (NULL,'2','test2','ad0234829205b9033196ba818f7a872b','test2@hotmail.com','1','','0','http://www.','','','','','1','1','1','0','','0',1027736690,'1','-1',1027736690,1027736690,1027736690,'0','0','1','1','0','','0','15','birthday')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Friday 26th of July 2002 08:24:50 PM
Script: http://localhost/test
Referer:

At first I would think that one of hack screw it up so I decide to install new one without any kind of hack and test this hack, result is all same so this hack seem screw the database.
I have no problem with others like send this email community to members nor register new username by register at forum but not thur "add" at AdminCP cuz of this database error.

Any idea? I dont want to uninstall this hack cuz of that simple database error.

Aurore 08-01-2002 07:23 PM

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks

Aaron RV 08-02-2002 06:00 AM

Hi.

This hack tested for 2.2.6?

Thank's.

Aurore 08-02-2002 05:36 PM

Tested on a vBulletin board 2.2.6

Kars10 08-02-2002 05:46 PM

Hello Guys!!
This is one of the greatest hacks ive ever saw...
but when i send the emails, it sends only to 78 People on my Board. Ive got 360 registered Members. Ive looked and everything seems alright. The Usergroupes i want to send the mail is checked.
Please help me. My Members ask why some of them don?t get the Newsletter... ;)

afterlab 08-02-2002 07:13 PM

They must first say "Yes" that they want to receive the newsletter. Tell them to go find it within their User CP:

User CP > Edit Options

Kars10 08-03-2002 05:37 AM

Ok.
But in "my" own CP is also switched to yes, i i didnt get the Newsletter...

The script says : sending Mail, Site 1/2...
but on the Point where 78 Users are send, ....its ready.
I didnt get a second site... and i can“t reload that page, without sending the Mail to the 78 Users twice.
Ive installed everything correctly. The installation was very easy.
But why i cant send to more than 78 users?
Is there a query i cant run, that in all cps is switched to yes...
Normaly after the installation, all is switched to yes?
I dont think that 280 Users regonize that ive made a new install of a Newsletter-Script and switched in there CP to No..
And ther Problem is, i cant tested without sending the Mails. I dont want to spam my Board-Members!

FleaBag 09-04-2002 10:17 AM

Works with 2.2.7. Top work! :D

Aurore 09-04-2002 03:44 PM

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks

wolfe 09-04-2002 08:30 PM

since i added this i get an error

Code:

Database error in vBulletin Control Panel 2.2.4:

Invalid SQL: UPDATE user SET away='0',awaydate=UNIX_TIMESTAMP('1970-01-01 01:00:00'),returndate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='10',username='rpm',email=useremail@site.com,styleid='14',parentemail='',coppauser=0,homepage='http://www.',icq='',aim='',yahoo='',signature='',adminemail=1,receivebulletin=1,receivebulletin_type=1,showemail,showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars}/1stars.gif">,customtitle=0,joindate=UNIX_TIMESTAMP('2002-09-04 17:54:20'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-09-04 20:35:39'),lastactivity=UNIX_TIMESTAMP('2002-09-04 21:11:46'),lastpost=UNIX_TIMESTAMP('2002-09-04 19:10:38'),posts='20',timezoneoffset='0',emailnotification=1,receivepm='1',emailonpm='0',ipaddress='62.30.77.26',pmpopup=IF(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=331
mysql error: You have an error in your SQL syntax near 'showemail=1,invisible=0,usertitle=<strong>Moderator</strong><br><img src="{stars' at line 1

mysql error number: 1064

Date: Wednesday 04th of September 2002 09:49:36 PM
Script: http://mysite.com/forums/forums/admin/user.php
Referer: http://mysite.com/forums/admin/user....dit&userid=331

whats that all mean :(

Joe Page 09-06-2002 05:34 PM

Very nice add-on, thanks :)

Webdork 09-17-2002 04:41 AM

Quick thanks from me too, works perfectly.

Would love to see a version where you could add a message to top of mailout...

Can do this simply by cutting and pasting in the html and the text form of the mailout, but would be nice if you could add a message when compiling.

tractor-beam 09-23-2002 02:38 PM

Howdy folks,

I just installed this great hack on my vBulletin 2.2.5 web site and it works great. I too wanted the bulletin to create hyperlinked calendar events.

I'v been messing around with PHP for a month or so and decided to try and hack the "commbull.php" myself to see what I could do.

I made two very small changes to the code and here is my results. I'll post the changes if anyone is interested.

- Gerry

LightBringer 09-23-2002 03:41 PM

I installed this hack recently and I am experiencing an issue where the news article titles (the ones selected here: Select news articles to include in your email) aren't all showing up.

Notice how the thread titled "Unreal Tournament 2003 Server Specs Demo" has a nice table behind it and the title actually shows up?

The ones above it do not show the title or the table.

Screenie included

Could really use some help on this one.
http://www.brainphreeze.com/images/commbull.jpg

Aurore 09-23-2002 07:41 PM

When the bulletin is sent in text file to members, it is a file that is attach to the mail?

Any solution ?

Thanks

christec 09-25-2002 01:49 AM

Aurore,

Try this;
Edit the commbull.php file.

Find this line:
$textEmailHeader .= "Content-Type: text/text\n";

and replace it with this line:
$textEmailHeader .= "Content-Type: text/plain\n";

Let me know if that works. :)

LightBringer 09-25-2002 04:14 AM

Hey christec, I attempted to use the fix that you pm'd me with, but now only the very first news article has the header and the rest don't. heh

Any ideas?

Aurore 09-25-2002 05:15 AM

Quote:

Originally posted by christec
Aurore,

Try this;
Edit the commbull.php file.

Find this line:
$textEmailHeader .= "Content-Type: text/text\n";

and replace it with this line:
$textEmailHeader .= "Content-Type: text/plain\n";

Let me know if that works. :)

Thank you very very much! It works perfectly!!!

Willard Reece 09-25-2002 05:15 PM

I installed it and my wifes pc got email from nobody @,,,,,,,,.com possible scam but most went thru ok.

This is what I needed , maybe it willget my users in gear and come back more often...

Thanks
Willard Reece

Willard Reece 09-26-2002 05:27 PM

I just found a problem with my install of this...

If I go to admin panel and try to add user it errors out..

Anyone know why this is happening?

Willard Reece 09-26-2002 07:17 PM

I am hearing that on line 165 you have the columns: receivebulletin,receivebulletin_type,showemail

but just these values:
'$receivebulletin','$showemail'

this is in the user.php

anyone know what I need to do to it. To make the admin add new user work.
I really don't want to uninstall the hack.

The install program put these in.

tractor-beam 10-01-2002 11:39 AM

Quote:

Originally posted by hypedave
since I have upgraded to vb 2.2.5 , it takes forever two send out emails, I only have 200 members at the moment and on 2.2.4. I could send to all at the same time, not I have to send to 25 at a time, I have also experienced the yellow text problem as well
I'm running 2.2.5 as well and some users never received the very first newsletter I sent out. Everyone SHOULD have. I have less than 70 registered members. I am wondering if this newsletter hack looks to see if the "receive e-mail from Admin" effects the sending of the e-mails.

Hmmmmm.....

- Gerry

Willard Reece 10-01-2002 01:09 PM

I removed receivebulletin,receivebulletin_type from my user.php and it all works now,,

digitalJE5U5 10-03-2002 08:58 AM

Works on 2.2.8 - Nice Hack man! Cant wait to see what you come up with next.

JoshFink 10-18-2002 02:16 PM

This may be asking too much, but is there a way to get a "Preview HTML" button that would show you what it looked like first?

Thanks

Josh

NTLDR 10-18-2002 04:43 PM

Quote:

Originally posted by JoshFink
This may be asking too much, but is there a way to get a "Preview HTML" button that would show you what it looked like first?
Thats a good idea Josh, something like the preview buttons for the templates would be good.

LightBringer 10-18-2002 05:03 PM

Christec, any updates on the issues I was having before?

https://vborg.vbsupport.ru/showthrea...992#post301992

https://vborg.vbsupport.ru/showthrea...432#post302432

JoshFink 10-18-2002 06:23 PM

NTLDR , thanks for the help. That would be great.

Josh

groovesalad 10-19-2002 03:04 PM

Everything works great, except I'm having one issue. When I try to get the Bulletin to post on my message board in HTML format, the format is really messed up. I thought that maybe it was just posting incorrectly, so I just copied and pasted the HTML from the "Preview" screen before sending out the Newsletter and just pasted that into one of my forums. Still the same problem. I even checked the HTML source and it matched the "Preview" screen. Not sure why it's doing this. I'm almost positive NTLDR can figure this one out :)

http://groove-salad.com/forum/showth...=&threadid=177

groovesalad 10-20-2002 01:25 AM

When I try to use this, here is what I get as an error

[Sat Oct 19 19:17:10 2002] [error] [client 66.68.71.58] Empty script output

Anyone know what that means?

NTLDR 10-20-2002 04:46 PM

Here we go, the mod for the Preview button for the HTML, note variables like $username are not parsed in the preview.

Find:

PHP Code:

maketableheader("Preview of your TEXT email"); 

Above it add:

PHP Code:

    ?><tr class='firstalt' valign='top'>
        <td><p></p></td><td><p>
        <SCRIPT LANGUAGE="JavaScript">
        function displayHTML() {
        var inf = document.name.message.value;
        win = window.open(", ", 'popup', 'width=800,height=500,toolbar=no,status=yes,scrollbars=yes');
        win.document.write("" + inf + "");
        }
        </script>
        <input type='button' value='Preview' accesskey='p' onclick='javascript:displayHTML()'></p></td></tr>
    <?php

Thats it, you then get a preview button right under the HTML text area :D

Note: vB puts a space between java and script here: onclick='java script:displayHTML It should be javascript, one word ;)

Littlebit 10-26-2002 09:56 PM

Hi NTLDR,
yep...another Netscape java error...I got this script error in my java log from your script add for the preview
Quote:

Error: missing ; before statement
Source Code:
java script:displayHTML()
Any ideas? I think I'm going to make sure I don't have some weird Java setting messed up in my browser too. :/

NTLDR 10-26-2002 09:58 PM

I've only got IE installed and I'm no Java expert or fan. Does the preview for templates work in the ACP? That is basicly the code from there modified to work with this hack.

Littlebit 10-26-2002 10:05 PM

I got it! it was just being being stubborn over the space between java and script. It works with the space removed. :)
Man, I've decided that Netscape is way picky with it's code.

I forgot to say thanks for the nifty add ;)

NTLDR 10-26-2002 10:23 PM

Quote:

Originally posted by Littlebit
It works with the space removed. :)
Man, I've decided that Netscape is way picky with it's code.

The space isn't meant to be there ;) vB puts it in automatically for security reasons so it wouldn't have worked in any browser.


All times are GMT. The time now is 05:50 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01622 seconds
  • Memory Usage 1,831KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete