vb.org Archive
Page 6 of 11 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

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)

dodgeboard.com 11-18-2006 12:24 AM
Does the installer in the files you uploaded incorporate the manual database queries that you ran and mentioned in post 127?

dodgeboard.com 11-18-2006 12:26 AM
Quote:
Originally Posted by Lionel (Post 1119720)
what is your username/alias?

ummm
username: dodgeboard.com
alias: dodgeboard@yoursite.com

Lionel 11-18-2006 12:26 AM
ok, I did not put any installer. Do you have access to a development board?

dodgeboard.com 11-18-2006 12:28 AM
nope,

it's on my to-do list though :D

You want to set it (VBMS) up for me? :cool:

Lionel 11-18-2006 12:31 AM
The installer should be the same as the original post. Only one query to change, the one for phraseid as per my post before. If not, then I'll post the individual queries.

I am mostly concerned that all the settings will be installed. Paul M mentioned some missing, but could not verify that as I did a manual install.

dodgeboard.com 11-18-2006 12:34 AM
Quote:
Originally Posted by Lionel (Post 1119718)
Dodgeboard, I am going to send you an email to your alias. Check for html. I will be sending you smilies.

Never got the HTML email....

but hey, that's not a real big deal...
:laugh:

Edit: yeah I got it, but the html was displaying the code.

Lionel 11-18-2006 12:35 AM
So I guess Filburt the ball is in your court. Works for me on 3.60

Lionel 11-18-2006 12:35 AM
Quote:
Originally Posted by dodgeboard.com (Post 1119731)
Never got the HTML email....

but hey, that's not a real big deal...
:laugh:
it displays the code huh?

dodgeboard.com 11-18-2006 12:36 AM
yeah

---but not a big issue

If someone can now get this packaged into a completed product with the installer bugs incorporated, we'd be in good shape.

Lionel 11-18-2006 12:38 AM
Quote:
Originally Posted by dodgeboard.com (Post 1119735)
yeah

---but not a big issue
no good. I'll get to that later on or tomorrow. I think I know the reason.

Can't help on installer. Like I stated before, I code only on my site and never learned how to package those things. I am still doing it the 3.07 way.

dodgeboard.com 11-18-2006 12:40 AM
okay- you made some real progress today! Thanks for all your efforts. Email me if you need anything webmaster at dodgeboard.com

Lionel 11-18-2006 12:41 AM
Thanks, you've been a tremendous help.

filburt1 11-18-2006 12:45 AM
I must say, it's pretty damned impressive what you guys have done with it, especially figuring it out so quickly. I'd like to think it's because I coded it with some high-level concepts in mind, but more likely, you're PHP gods. ;)

The installer's a +++++. What specific problems is it causing?

BTW, header duplication and problems will occur within the vbms_mail_message class. The API function you posted is just a wrapper to provide safe arguments for the class and to easily say "just send the message" without all the extra code.

dodgeboard.com 11-18-2006 12:49 AM
post 127:

Quote:
The problem is the phrasetype table structure is not the same from 3.54 to 3.60
I had xml error from the very first line of the install. So what I did, I opened the xml and ran the queries one by one in php admin, simply changing {tp} with my prefix. Once all the tables were created and the inserts done (a matter of minutes), I imported the templates xml from the upload styles input.

Did the same for the phrases. That took a couple of minutes.

The biggest headache is the settings. I had to do them one by one, but it's only 14 of them. You need also to set the settinggroup (1 entry with phpadmin)

Then the fun begins. I replaced all $DB_Site with $db (just a search and replace for all the files).
Filburt,

Can you package these changes so that the queries are properly executed?

Then use the files posted by Lionel on post 197 to put together a 3.6.0 beta release.

filburt1 11-18-2006 12:53 AM
I have no idea how the phrasing works in vB 3.6, so I don't know even how to start fixing that one. The table prefixes should automagically be replaced when queries are run. It should add the settings and create the group as well.

If the whole process changed in 3.6 versus 3.5, then I don't know what to do. I have near-zero experience with 3.6.

(also don't have <oXygen/> installed right now)

Lionel 11-18-2006 12:53 AM
You need to deal with that single line for phrasetype (database has changed from 3.54 to 3.60)

And need to make sure all settings are there (15 of them). Here are 3 screenshots of what the complete settings should be. Some of them, I 'borrowed' from the 3.07 version to manually install.

I also borrowed the code below navbar to display new emails from the 3.07 version

Lionel 11-18-2006 12:58 AM
Quote:
Originally Posted by filburt1 (Post 1119745)
I have no idea how the phrasing works in vB 3.6, so I don't know even how to start fixing that one. The table prefixes should automagically be replaced when queries are run. It should add the settings and create the group as well.

If the whole process changed in 3.6 versus 3.5, then I don't know what to do. I have near-zero experience with 3.6.

(also don't have <oXygen/> installed right now)
OK here is what I did

1-Imported the phrases directly from Filburt xml into english language

2-Did same thing for templates

replace new_ with your prefix

for settings you are on your own. My sql files have my autoincrements

working 3.60 version here

DaNIEL MeNTED 11-18-2006 01:56 AM
I think you mean "replace WDF_ with your own prefix"

dodgeboard.com 11-18-2006 01:59 AM
Quote:
Originally Posted by DaNIEL MeNTED (Post 1119775)
I think you mean "replace WDF_ with your own prefix"
If you look at the text files Lionel uploaded, you'll see:

PHP Code:
INSERT INTO new_product VALUES ('wdf_vbms', 'Vbulletin Mail System', 'Vbulletin Mail System', '2.52', 1, '', ''); 
I think he means to replace the new_product table line with your own prefix. Same with new_settinggroup and new_phrasetype in the corresponding files

DaNIEL MeNTED 11-18-2006 02:04 AM
Doh! Thats what I get for working on 2 things at once...

Lionel 11-18-2006 02:13 AM
I also put this at the end of navbar template so members know when they have new mail.

PHP Code:
<!-- vBMS new mail notification -->
<if condition="$vbulletin->options['vbms_enabled'] and $vbulletin->options['vbms_headernotification'] and $vbms_newmessages['newcount'] > 0">
<br />
<table cellpadding="$stylevar[outerborderwidth]" cellspacing="0" border="0" class="tborder" width="$stylevar[tablewidth]" align="center">
<tr>
<td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<tr>
<td class="thead" colspan="2">$vbphrase[vbms_you_have_new_email]</b>
</td>
</tr>
<tr>
<td class="alt2" style="width:30px; text-align:center; overflow:hidden; padding:1px; vertical-align:middle">
<span style="font-family:'Trebuchet MS', Verdana, Tahoma, Arial, sans-serif; font-weight:bold; font-size:xx-large">!</span>
</td>
<td valign="top" class="alt1">
<b>
<if condition="$vbms_newmessages['newcount'] == 1">
$vbphrase[vbms_one_unread_message]
<else />
<phrase 1="$vbms_newmessages[newcount]">$vbphrase[vbms_x_unread_messages]</phrase>
</if>
</b><br />
<span class="smallfont"><phrase 1="/forums/vbms.php?$session[sessionurl]">$vbphrase[vbms_to_read_your_email]</phrase>
</span>
</td>
</tr>
</table>
</td>
</tr>
</table>
</if>
<!-- / vBMS new mail notification --> 

Lionel 11-18-2006 02:18 AM
You guys make sure you have 15 settings, and the one for NOTLS is named force_notls and not notls.

If you have problems, post it and I will help you.

Lionel 11-18-2006 03:29 AM
My setup is very different. So in the code that I posted, you need to look for and replace every instance of

Quote:
" . "user
with

Quote:
" . TABLE_PREFIX . "user

Lionel 11-18-2006 04:49 AM
in vbms_functions.php look for

Quote:
// convert ab aliases to actuals
$result = $db->query("
SELECT LCASE(alias) AS alias, actual FROM " . TABLE_PREFIX . "vbms_addressbook
WHERE userid = " . $bbuserinfo['userid']);
and replace with

PHP Code:
$alias=str_replace("\"","",$to);
     
     // convert ab aliases to actuals
     $result = $db->query("
       SELECT LCASE(alias) AS alias, actual FROM " . TABLE_PREFIX . "vbms_addressbook
          WHERE alias='$alias' AND userid = " . $bbuserinfo['userid']); 
before sending, the script looks at the address book for an alias and if you do have an address book, it assumes that the entry exists, not taking into consideration new emails that you are replying to. Since it will not find it, it will throw an error.

The fix above introduce the alias in the WHERE clause, so if alias is not in there it will ignore it and send the mail without errors.

Andre31 11-18-2006 05:45 PM
Work this nice Addon under 3.6.2 without Problems? I´ve tried, but i became trouble with the installer. Have anybody an idea?

filburt1 11-18-2006 06:56 PM
Did you read any of the posts in this thread?

Lionel 11-19-2006 08:00 AM
Instructions.

BACKUP your database and your templates
  1. Run the included queries in phpadmin. Make sure you replace the " . TABLE_PREFIX . " with your own prefix
  2. Merge the included templates into your existing style by importing the xml in Upload/Download Templates
  3. Import the product. That will set the phrases, the plugins and the settings
  4. upload the files
  5. Refresh admincp and look for the new link for the mail system and set your settings
Know bugs: Permissions need to be setup twice for it to be accepted.

This has been working on my site with no reported problems.
Some FAQ are specific to my site and you will not need. Simply delete them in FAQ admin

If you want to display a mail notification to your members on the site, follow the instructions here
https://vborg.vbsupport.ru/showpost....&postcount=221

uploaded images

dodgeboard.com 11-19-2006 02:52 PM
At Query:

UPDATE phrase SET product = "wdf_vbms" WHERE varname LIKE "vbms%" OR phrasetypeid = 500

Quote:
Error
SQL query:

UPDATE phrase SET product = "wdf_vbms" WHERE varname LIKE "vbms%" OR phrasetypeid =500

MySQL said:

#1054 - Unknown column 'phrasetypeid' in 'where clause'

Lionel 11-19-2006 02:54 PM
Quote:
Originally Posted by dodgeboard.com (Post 1120809)
At Query:

UPDATE phrase SET product = "wdf_vbms" WHERE varname LIKE "vbms%" OR phrasetypeid = 500
disregard this query. Since this is a copy of my product, you don't need. or simply remove that part

"OR phrasetypeid =500 "

dodgeboard.com 11-19-2006 02:55 PM
same with this one? (same error)


UPDATE phrasetype SET product = "wdf_vbms" WHERE phrasetypeid = 500

Lionel 11-19-2006 03:02 PM
Quote:
Originally Posted by dodgeboard.com (Post 1120813)
same with this one? (same error)


UPDATE phrasetype SET product = "wdf_vbms" WHERE phrasetypeid = 500

ignore it too. Ignore the ones referring to phrasetypeid. I simply copied the original query and forgot to remove them.

I am attaching missing images.

dodgeboard.com 11-19-2006 03:02 PM
FYI: queries for CREATE TABLE vbms_usergroupsetting and vbms_sendfloodcheck are listed twice in the sql.txt file- you get an error on the second instance

EDIT: and vbms_log

All other queries executed properly

So I made the corrections to the SQL.TXT and am uploading it here.

I also elimintated the table prefix as well.

Lionel, why do we even need a table prefix since all the tables are already prefixed with vbms_ ?

Lionel 11-19-2006 03:09 PM
Quote:
Originally Posted by dodgeboard.com (Post 1120817)
FYI: queries for CREATE TABLE vbms_usergroupsetting and vbms_sendfloodcheck are listed twice in the sql.txt file- you get an error on the second instance

EDIT: and vbms_log

All other queries executed properly

So I made the corrections to the SQL.TXT and am uploading it here.

I also elimintated the table prefix as well.

Lionel, why do we even need a table prefix since all the tables are already prefixed with vbms_ ?
you do, because all the queries in php use " . TABLE_PREFIX ."vbms_whatever

Lionel 11-19-2006 03:17 PM
I am not sure this was included


PHP Code:
INSERT INTO `TP_phrasetype` VALUES ('vbms', 'vBulletin Mail System (vBMS)', 3, 'wdf_vbms', 0); 
REPLACE TP_ with your prefix.

Lionel 11-19-2006 03:19 PM
And he forgot to autoincrement messageid in " . TABLE_PREFIX . "vbms_message

You need to do it too in php admin

DaNIEL MeNTED 11-19-2006 06:12 PM
Couple of things... the cron job seems to fail.

Aaand... any settings changes and the cron job is disabled and set to run only on the 1st.

Slave 11-19-2006 06:59 PM
Thanks for the instructions Lionel :) .. I've managed to get it to the point of being able to send a mail out but it doesn't seem to be checking for new mail .. do i need to set the cron job up as mentioned earlier in this thread? I've set it to check for mail every 2 mins and to log in the settings but nothing has appeared there as yet ..

Also .. How do I change the name from "Haitiwebs Mail" showing in the title of the page and in the breadcrumbs? I don't seem to be able to find it in the settings ..

Thanks :)

Lionel 11-19-2006 08:04 PM
the cron job is in the plugin. Make sure that the plugin is enable (2 of them) specially the parse templates which adds to the $cronimage found in footer.

To change the name, look in vbms_function.php

Lionel 11-19-2006 08:07 PM
Forget about the cron in the cronjobs. This is not using a cronjob like we know it. In fact delete it. It was not supposed to be there.

Lionel 11-19-2006 08:30 PM
This is what activates the cron: Check e-mail. Make sure you have those 2 plugins which were included in the product

PHP Code:
 <plugins>
  <plugin active="1" executionorder="6">
   <title>Initialize front-end vBMS page elements</title>
   <hookname>global_start</hookname>
   <phpcode><![CDATA[require_once(DIR . "/includes/vbms_frontend_init.php");]]></phpcode>
  </plugin>
  <plugin active="1" executionorder="5">
   <title>Check e-mail</title>
   <hookname>parse_templates</hookname>
   <phpcode><![CDATA[require_once(DIR . "/includes/vbms_functions.php");
$cronimage .= vbms_get_check_mail_img_html();]]></phpcode>
  </plugin>
 </plugins> 
Do a view source on any forum page and towards the end of the page see if you have that line


All times are GMT. The time now is 05:01 AM.
Page 6 of 11 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

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.01739 seconds
  • Memory Usage 1,864KB
  • 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
  • (5)bbcode_php_printable
  • (15)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