vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   vBulletin Mail System (https://vborg.vbsupport.ru/showthread.php?t=125890)

DaNIEL MeNTED 11-20-2006 01:06 PM

error when "rebuild quota" -

PHP Code:

Invalid SQL:
DELETE FROM vb_vbms_attachment
            USING vb_vbms_attachment a
            LEFT JOIN vb_vbms_message
            ON a
.messageid vb_vbms_message.messageid
            WHERE vb_vbms_message
.messageid IS NULL;

MySQL Error  Unknown table 'vb_vbms_attachment' in MULTI DELETE
Error Number 
1109 

As far as default aliases... Is there a way to populate the alias column with the members' username - dropping any illegal characters and changing spaces to _ or . ??

Also ... I'd love to be able to see the alias in the AdminCP user properties.

DaNIEL MeNTED 11-20-2006 02:05 PM

Quote:

Originally Posted by Lionel (Post 1121251)
Try to run this in your browser and post the results if any (replace with your values)

http://www.yoursite.com/forums/vbms_checkmail.php

Is there a reason we can't create a cron job for vbms_checkmail.php instead of using the plugins?

I just think a cron is more "standard" as to the way most hacks run. Or is there a reason its in the plugins?

dodgeboard.com 11-20-2006 03:14 PM

Quote:

Originally Posted by DaNIEL MeNTED (Post 1121521)
error when "rebuild quota" -

PHP Code:

Invalid SQL:
DELETE FROM vb_vbms_attachment
            USING vb_vbms_attachment a
            LEFT JOIN vb_vbms_message
            ON a
.messageid vb_vbms_message.messageid
            WHERE vb_vbms_message
.messageid IS NULL;

MySQL Error  Unknown table 'vb_vbms_attachment' in MULTI DELETE
Error Number 
1109 

As far as default aliases... Is there a way to populate the alias column with the members' username - dropping any illegal characters and changing spaces to _ or . ??

Also ... I'd love to be able to see the alias in the AdminCP user properties.


I had this problem too. Lionel corrected it by manually creating the table.

Lionel 11-20-2006 04:08 PM

change

Quote:

DELETE FROM vb_vbms_attachment

to

Quote:

DELETE FROM vb_vbms_attachment a

Lionel 11-20-2006 04:11 PM

Quote:

Originally Posted by DaNIEL MeNTED (Post 1121550)
Is there a reason we can't create a cron job for vbms_checkmail.php instead of using the plugins?

I just think a cron is more "standard" as to the way most hacks run. Or is there a reason its in the plugins?

the way it's setup, it is the same as a cronjob

DaNIEL MeNTED 11-20-2006 05:03 PM

I've imported all the templates and SQL queries into the product...

I've added uninstall code that removes all the tables.

I have also added the following:

ON INSTALL - the ALIAS will be populated for all users with the following in mind:
  • all usernames are converted to lowercase.
  • all characters other than a-z, 0-9, and . (period) are stripped from their username.
  • before an alias is added it is checked against all other aliases in the database, if the alias exists it adds a 1, 2, 3, n. to the end of the alias as required.
Please have a look at this code and tell me if it can be improved - like I said I'm not a coder.

PHP Code:

$allusers $vbulletin->db->query("SELECT * FROM  " TABLE_PREFIX "user"); 

while(
$row mysql_fetch_array$allusers )) {
 
$suffix=1;
 
$username $row['username'];
 
$username strtolower($username);
 
$newalias preg_replace('/\s/''.'$username);
 
$newalias preg_replace('@[^a-z0-9.]@'''$newalias);
 
$dupecheck $vbulletin->db->query("SELECT * FROM  " TABLE_PREFIX "user"); 
 while(
$dupe mysql_fetch_array$dupecheck)) {
  
$existing $dupe['vbms_alias'];
  
$currentuser $dupe['username'];
  if (
$newalias == $existing) {
   if (
$user != $currentuser && $suffix == 1) {
    
$newalias $newalias $suffix++;
   } elseif (
$user != $currentuser && $suffix 1) {
   
$newalias rtrim($newalias"1..9");
   
$newalias $newalias $suffix++;
   } else {
    
$newalias $existing;
   }
  }
 }
$vbulletin->db->query("UPDATE " TABLE_PREFIX "user SET `vbms_alias` = '" $newalias "' WHERE " TABLE_PREFIX 
"user.username ='" $username "' LIMIT 1");


I would rather remove this from the install and modify it into 2 plugins ... one that could be run from the admin CP (Populate Aliases! button) and one that runs as part of a new user registration (after the confirm their address).

Also, I'm not sure how to add the alias fields to the user view in the admin CP... anyone want to point me in that direction?

Oh .... I did change the product version to 2.53 because of the differences in the XML I made.

EDITED TO ASK:

Are there any other changes that need to be made to "mail enable" a user?

DaNIEL MeNTED 11-20-2006 06:31 PM

Quote:

Originally Posted by Lionel (Post 1121624)
the way it's setup, it is the same as a cronjob

Bear with me... since I'm still trying to decipher much of this. But it looks like the way it is setup now requires someone to load a page after the timeout has expired to force an update.

Assuming you have a few hours of downtime when no one is surfing your forum that first person is going to get dinged with a longer wait based on the size of the email that needs to get pulled down.

Can the plugin code just be copied to a new cronjob.php file or would I need to do anything else?

Lionel 11-20-2006 06:34 PM

Quote:

Originally Posted by DaNIEL MeNTED (Post 1121708)
But it looks like the way it is setup now requires someone to load a page after the timeout has expired to force an update.

That's the way that vb cron system is setup. For all crons to work, anyone of them, a page must be loaded.

On another good note, I just learned how to make a product. Since you made one already, I'll move to my next project, which will be vbstocks, a stock market simulator using real data with points money to buy them

DaNIEL MeNTED 11-20-2006 06:45 PM

Quote:

Originally Posted by Lionel (Post 1121711)
That's the way that vb cron system is setup. For all crons to work, anyone of them, a page must be loaded.

Ahhh... gotcha!

Quote:

Originally Posted by Lionel (Post 1121711)
On another good note, I just learned how to make a product. Since you made one already, I'll move to my next project, which will be vbstocks, a stock market simulator using real data with points money to buy them

Haha. Lets make sure all the bugs are ironed out of this one first! :D

Should I have any options in my userCP after installing or are there manual template changes?

Lionel 11-20-2006 06:55 PM

Quote:

Originally Posted by DaNIEL MeNTED (Post 1121719)
Should I have any options in my userCP after installing or are there manual template changes?

What I did was adding them in a dropdown in navbar.
My setup is different as I splitted Quick Links and put some items in the User CP navbar link where they belong. So I would simply recommend to add a new mail link in navbar

GoHa 11-20-2006 07:07 PM

Hello,

As I Read in this thread - all cronjobs were eliminatied. But in vb admin cp , in scheduled tasks I see
vBMS: Check e-mail task scheduled to be run every minute.
And this taskis always faild with erro messaage:

Code:

vBMS: Check e-mail

Warning: main(/home/devgoha/public_html/forums/./includes/cron/vbms_checkmail.php) [function.main]: failed to open stream: No such file or directory in /admincp/cronadmin.php on line 64

Warning: main() [function.include]: Failed opening '/home/devgoha/public_html/forums/./includes/cron/vbms_checkmail.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /admincp/cronadmin.php on line 64


Done

I am running VB 3.5.4 and vBMS 2.5.2p

DaNIEL MeNTED 11-20-2006 07:12 PM

But where did you get those links from? Where does manage permissions go?

Also ... in one of the templates it says "Note that TestForums members' usernames act just like aliases. If you wish to send a user called "Administrator" an e-mail, you simply need to type that username. Note that users have the option of requesting not to receive e-mails from other TestForums members via this method." and the link just goes to the user CP...

Just trying to figure out what I need to add to the userCP?

Lionel 11-20-2006 07:14 PM

Quote:

Originally Posted by GoHa (Post 1121729)
Hello,

As I Read in this thread - all cronjobs were eliminatied. But in vb admin cp , in scheduled tasks I see
vBMS: Check e-mail task scheduled to be run every minute.
And this taskis always faild with erro messaage:

Code:

vBMS: Check e-mail
 
Warning: main(/home/devgoha/public_html/forums/./includes/cron/vbms_checkmail.php) [function.main]: failed to open stream: No such file or directory in /admincp/cronadmin.php on line 64

I am running VB 3.5.4 and vBMS 2.5.2p

which zip did you install? Original zip or updated one?

Lionel 11-20-2006 07:15 PM

Quote:

Originally Posted by DaNIEL MeNTED (Post 1121734)
But where did you get those links from? Where does manage permissions go?

Also ... in one of the templates it says "Note that TestForums members' usernames act just like aliases. If you wish to send a user called "Administrator" an e-mail, you simply need to type that username. Note that users have the option of requesting not to receive e-mails from other TestForums members via this method." and the link just goes to the user CP...

Just trying to figure out what I need to add to the userCP?

I added those links. Manage permissions is seen only by admin

NitroXploit 11-20-2006 07:18 PM

Bug: Wrong phrasetype

Change: in vbms_alias.php

Code:

        if ($result !== false)
        {
                vbms_scrubhtml($result);
                eval(standard_error(fetch_error("error_vbms_aliastaken")));
        }

to

Code:

        if ($result !== false)
        {
                vbms_scrubhtml($result);
                eval(standard_error(fetch_error("vbms_aliastaken")));
        }


Lionel 11-20-2006 07:26 PM

good catch NitroXploit

NitroXploit 11-20-2006 07:51 PM

Again in vbms_alias.php

Code:

        $email = $bbuserinfo['vbms_alias'] . "@" . $vboptions['vbms_todomain'];
        eval(print_standard_error(fetch_error("vbms_no_allow_alias_change", $email)));

To:

Code:

        $email = $bbuserinfo['vbms_alias'] . "@" . $vboptions['vbms_todomain'];
        eval(standard_error(fetch_error("vbms_no_allow_alias_change", $email)));

You might go ahead and change all "print_standard_error" found on vbms files to "standard_error".

speedway 11-21-2006 10:36 AM

Quote:

Originally Posted by Lionel (Post 1121278)
An important point to whoever is going to use this hack. Set @yoursite.com in the vb User Banning Options banned email list to prevent users from using their alias@yoursite.com as the primary site contact, or the script will enter into a loop trying to send notifications non stop.

I was just wondering of anyone is looking into this and it would unfortunately mean I could not use it. :surprised: I am/was looking at this solution to offer to subscribers and they wanted to use it for their primary contact.

I hope someone may find a solution - I am not up to speed enough in PHP to know ahere to start looking....

Oh, forgot to say brilliant addition to VB :)

Cheers
Bruce

Lionel 11-21-2006 01:16 PM

the only solution would be to disable notifications, which is like shooting yourself in the foot.

Hivemail would do what you are looking for, but again, is very buggy, would have to fix it yourself as support is non existant.

Killsparer 11-21-2006 01:24 PM

Quote:

Originally Posted by speedway (Post 1122178)
I am/was looking at this solution to offer to subscribers and they wanted to use it for their primary contact.

Wouldn't it be quite illogical to use it as the primary contact-adress, since (as an example) the mails sent in case of a lost password would be delivered to it, too?

If someone lost his password, he would have to log in to read the "forgot your password?"-mail. But since he forgot it, he can't ... :confused:

Slave 11-21-2006 01:28 PM

Can anyone point me to a web page explaining how to install imap with php on a redhat box? My host is having difficulty with it and I'd like to point him in the right direction.

Thanks :)

(I can't believe I've come this close to have this hack working, only to be let down by my server, aahhhhhhhhhHH!!!!!!)

Lionel 11-21-2006 01:37 PM

As far as I am concerned, no one in the right frame of mind would use something like this, or like hivemail, or any other website provided mail client as their primary email solution.

This is designed to simply add another layer of privacy to your existing mail, with the flexibility to change alias whenever you want. An example to use this system, would be to setup an alias, use it for a subscription to another site. Once you start getting bombarded with spam, you just change alias. Using your real email in that case would live you vulnerable to spams.

filburt1 11-21-2006 04:07 PM

Quote:

Originally Posted by Killsparer (Post 1122245)
Wouldn't it be quite illogical to use it as the primary contact-adress, since (as an example) the mails sent in case of a lost password would be delivered to it, too?

If someone lost his password, he would have to log in to read the "forgot your password?"-mail. But since he forgot it, he can't ... :confused:

One of the main reasons you should never set your vBMS address to your forum e-mail address.

dodgeboard.com 11-21-2006 04:32 PM

er vica versa....

We had a couple users, after setting up their vBMS alias, go into their USERCP and change it to match. As you may already know, when you get an email at your VBMS email, it sends a notification to your Forums email to let you know. If your forums and VBMS mail are the same, it starts a cyclic buildup of emails which will eventually crash your database. Been there, done that. Since the webmaster (me) has a pop account on our domain, I entered @dodgeboard.com as a banned email in the Banning options, but selected "allow users to keep their banned IP/email", so that it would not ban the administrator. Then I just blanked out the couple users that had the @dodgeboard.com email addy in their profiles and instructed them to change it. Since @dodgeboard.com is now banned, they can't use it.

Lionel 11-21-2006 04:50 PM

Quote:

Originally Posted by Slave (Post 1122246)
Can anyone point me to a web page explaining how to install imap with php on a redhat box? My host is having difficulty with it and I'd like to point him in the right direction.

PHP needs to be recompiled with IMAP. Time to look for another host if he does not know how to do so.

speedway 11-22-2006 12:52 AM

Quote:

Originally Posted by dodgeboard.com (Post 1122342)
er vica versa....



We had a couple users, after setting up their vBMS alias, go into their USERCP and change it to match. As you may already know, when you get an email at your VBMS email, it sends a notification to your Forums email to let you know. If your forums and VBMS mail are the same, it starts a cyclic buildup of emails which will eventually crash your database. Been there, done that. Since the webmaster (me) has a pop account on our domain, I entered @dodgeboard.com as a banned email in the Banning options, but selected "allow users to keep their banned IP/email", so that it would not ban the administrator. Then I just blanked out the couple users that had the @dodgeboard.com email addy in their profiles and instructed them to change it. Since @dodgeboard.com is now banned, they can't use it.

DodgeBoard/Killsparer

I see now the problem. Nice system, but not what I am looking for. I thought about Hivemail a while ago and didn't bother doing anything about it. Glad I didn't.

Anyway, I wish everyone every success with this - great script for what it does, and I mean that. I am off to find another solution, dunno where yet :D

Cheers
Bruce

dodgeboard.com 11-22-2006 12:55 AM

Hivemail was great before it died...

I don't think there is another product out there that fully integrates with vBulletin, but good luck. Let us know if you find something of interest.

Lionel 11-22-2006 01:14 AM

you could look into atmail

speedway 11-22-2006 02:27 AM

Quote:

Originally Posted by Lionel (Post 1122668)
you could look into atmail

Yes, that or Scalix. Atmail is a few dollars though, but Scalix has a community edition....

Cheers
Bruce

daloosaa 11-22-2006 01:41 PM

Hi,

does this modification work with vBulletin 3.6.x (or is a version for 3.6.x available)?

Greets,
Florian

Lionel 11-22-2006 05:21 PM

Quote:

Originally Posted by speedway (Post 1122698)
Yes, that or Scalix. Atmail is a few dollars though, but Scalix has a community edition....

Cheers
Bruce

I had an atmail->vb integration laying around. Uses vb users, but atmail was on a different domain, so no conflict.

yoyoyoyo 11-22-2006 11:23 PM

I have been a user of vBulletin Mail System for a long time, and I recently redid my forums and upgraded to this version. I can send e-mail from my account just fine, but when I try replying to the e-mail received to send e-mail to my vb mail account it is returned with the following error:

Quote:

Permanent Failure: 550-"The_recipient_cannot_be_verified.__Please_check_a ll_recipients_of_this
any ideas?

EDIT: OK- I just read through this entire thread. It seems that people have gotten this working for 3.6.3, but I don;t see anyone saying it is working for 3.5.X Has anyone gotten it working for 3.5.X, and if so can you please tell us what changes need to be made?

FireLighter 11-23-2006 12:22 PM

Quote:

but I don;t see anyone saying it is working for 3.5.X Has anyone gotten it working for 3.5.X, and if so can you please tell us what changes need to be made?
I may be wrong, but from what I see in the very first thread...the original version (downloadable above) works for 3.5x. All of this work has been to get it to work with 3.6x.

-Josh

yoyoyoyo 11-23-2006 04:43 PM

Quote:

Originally Posted by FireLighter (Post 1123584)
I may be wrong, but from what I see in the very first thread...the original version (downloadable above) works for 3.5x. All of this work has been to get it to work with 3.6x.

-Josh

Well, actually if you read the thread you will see that it is not really working for 3.5.X - filburt posted it here so people could help with it. I installed it and I can send mail, but can't receive mail, and the same is true with many other folks. There have been some suggestions posted to this thread regarding 3.5.X implementation, but then the discussion shifted towards 3.6.X once that came out. I am still using 3.5.5 and would like to have this hack working on my forum. Any help would be appreciated.

GoHa 11-23-2006 06:51 PM

Quote:

Originally Posted by Lionel (Post 1123113)
I had an atmail->vb integration laying around. Uses vb users, but atmail was on a different domain, so no conflict.

I am very interesting in vb<->atmail integration. Can you please give me details? Is that something existing? Or did you made it yourself?

Lionel 11-23-2006 09:25 PM

Quote:

Originally Posted by GoHa (Post 1123868)
I am very interesting in vb<->atmail integration. Can you please give me details? Is that something existing? Or did you made it yourself?

I made it myself, was for 3.07 or lesser

GoHa 11-23-2006 09:47 PM

Is it alive? Can it be seen online?
May be you have screnshots?
I tried to do the same, but still have no good idea how to do it.

At the moment I am tring to choose between vbmail and atmail and see negative and positive aruments for both of them...

vbmail is already integrated, but is very simple, unfinished and running unsupported.

atmail is huge, is supported, but very expensive (up to $5k with all licenses) and I dont see how to integrate it (only login page can be easliy integrated).

Lionel 11-23-2006 09:49 PM

sorry, not live anymore, but I still have the server and SSH access :-)

yoyoyoyo 11-24-2006 01:58 AM

what code do I need to remove from the navbar template to make it no longer available? I disabled the uninstalled until the bugs get ironed out but the links are still in the navbar - I have tried removing what I thought was the vbms code in the navbar, but when trying to save it gives me errors - please post the code I need to remove from the navbar template to remove vbms. I looked at "view original" and compared with araxis, but the code seems to be in the original now, also. please advise.

Lionel 11-24-2006 02:14 AM

yoyoyoyo,

Quote:

<templateChange template="navbar" action="append" description="Add the vBMS DHTML menu items if logged in and popups enabled">
<target><![CDATA[<!-- / header quick search form -->
</if>

<if condition="$show['member']">]]></target>

<change><![CDATA[

<div class="vbmenu_popup" id="navbar_vbms_menu" style="display: none">
<table cellpadding="4" cellspacing="1" border="0">
<tr><td class="thead">vBulletin Mail System</td></tr>
<tr><td class="vbmenu_option"><a href="vbms.php?$session[sessionurl]">$vbphrase[navbar_inbox]</a></td></tr>
<tr><td class="vbmenu_option"><a href="vbms_new.php?$session[sessionurl]">$vbphrase[navbar_write_message]</a></td></tr>
<tr><td class="vbmenu_option"><a href="vbms_ab.php?$session[sessionurl]">$vbphrase[navbar_address_book]</a></td></tr>
<tr><td class="vbmenu_option"><a href="vbms_folders.php?$session[sessionurl]">$vbphrase[navbar_folders]</a></td></tr>
<tr><td class="vbmenu_option"><a href="vbms_filters.php?$session[sessionurl]">$vbphrase[navbar_filters]</a></td></tr>
<tr><td class="vbmenu_option"><a href="vbms_options.php?$session[sessionurl]">$vbphrase[navbar_options]</a></td></tr>
<tr><td class="vbmenu_option"><a href="faq.php?$session[sessionurl]faq=faq_vbms">$vbphrase[navbar_help]</a></td></tr>
</table>
</div>]]></change>
</templateChange>
</templateChanges>


All times are GMT. The time now is 04:55 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.01732 seconds
  • Memory Usage 1,891KB
  • 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
  • (6)bbcode_code_printable
  • (3)bbcode_php_printable
  • (25)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