vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Major Additions - AWCoding- Donation System (https://vborg.vbsupport.ru/showthread.php?t=177437)

jchamb2010 09-12-2010 01:43 PM

I get the following error after I install it:

Code:

Database error in vBulletin 4.0.6:

Invalid SQL:

                                                                SELECT SUM( mc_gross ) AS amount
                                                                FROM `vb_awc_payments`
                                                                WHERE payment_status = 'Completed'
                                                                AND sid = 'ss'
                                                                AND date_format( from_unixtime( payment_date ), '%m%y' ) = '0910';

MySQL Error  : Table 'vbulletin.vb_awc_payments' doesn't exist
Error Number  : 1146
Request Date  : Sunday, September 12th 2010 @ 09:42:35 AM
Error Date    : Sunday, September 12th 2010 @ 09:42:35 AM
Script        : http://****.com/forum.php
Referrer      :
IP Address    : **.**.**.**
Username      : Shotgun
Classname    : vB_Database
MySQL Version : 5.1.41


AWJunkies 09-12-2010 04:17 PM

Quote:

Originally Posted by jchamb2010 (Post 2097104)
I get the following error after I install it:

Code:

Database error in vBulletin 4.0.6:

Invalid SQL:

                                                                SELECT SUM( mc_gross ) AS amount
                                                                FROM `vb_awc_payments`
                                                                WHERE payment_status = 'Completed'
                                                                AND sid = 'ss'
                                                                AND date_format( from_unixtime( payment_date ), '%m%y' ) = '0910';

MySQL Error  : Table 'vbulletin.vb_awc_payments' doesn't exist
Error Number  : 1146
Request Date  : Sunday, September 12th 2010 @ 09:42:35 AM
Error Date    : Sunday, September 12th 2010 @ 09:42:35 AM
Script        : http://****.com/forum.php
Referrer      :
IP Address    : **.**.**.**
Username      : Shotgun
Classname    : vB_Database
MySQL Version : 5.1.41


This is your error (meaning user error) DO NOT TURN ON AWCoding- Subscription System PRO count towards goal when you don't have AWCoding- Subscription System PRO Installed. It is OFF by default. You need to go back to bar settings and turn it off.

AWJunkies 09-12-2010 09:52 PM

Version 4.0.1 is a patch fix for moneybookers not transferring to moneybookers on submit of payment.

You do not need to upgrade if your on 4.0.0 unless you plan on or are using moneybookers.

Enjoy, thanks for the support,
AWJunkies (Adam)

unknown22 09-14-2010 12:08 AM

Hi,

I'm using vbulletin 4.0.6

I took out the drop menu because it was to much on the navbar and I made a nav link in green and the meter itself but it does not show the donors if i want to go see donors i have to go to pageid=list.

Is there a way to automatically approve transactions, I used this mod before where it approves it and shows up on the meter.

AWJunkies 09-14-2010 12:18 AM

Quote:

Originally Posted by unknown22 (Post 2097851)
Hi,

I'm using vbulletin 4.0.6

I took out the drop menu because it was to much on the navbar and I made a nav link in green and the meter itself but it does not show the donors if i want to go see donors i have to go to pageid=list.

Is there a way to automatically approve transactions, I used this mod before where it approves it and shows up on the meter.

Hit me up on AIM, MSN, SKYPE, YAHOO as it will be easy to help you.

The auto approve transactions through PDT is still in software just need to make sure you have PDT turned on just like before in paypal.com.

This is not 100% as people can close window or not wait for auto redirect back or tons of other factors can prevent. That is why IPN/API is best solution.

Drop menu not sure what you mean sounds like you removed the menu and created own?
List page link is not pageid=list either so little confused best to take a look at your site and can solve within seconds.

AWJunkies 09-14-2010 06:46 AM

Glad I could help you with drop menu. Everyone there is a hook setting with about 8 different select options there so make sure to try them out to fit where you want it.

Also looking into the post of payments back from paypal. Will get back to you tomorrow.

AWJunkies 09-16-2010 01:45 AM

Release version: 4.0.2
Release Date: 15th September 2010
FIXED: No avatar image link wrong
ADDED: Hook for MGC Chatbox Evo
EDITED: To be compliant with Credit Purchase System LITE
ADDED: Pirate Poker LITE menu item to quickly get to settings
NOTE: You must have this version or higher to work with credit purchase system lite

Thanks for the support,
AWJunkies (Adam)

unknown22 09-23-2010 12:30 AM

I have donation mod installed and wondering how could i add a drop down menu to a tab i added

<li><a href="http://mywebsite.com/forums/awcl_dsl.php?do=donation"><span style="color: #00FF00;">Donate</span>{vb:rawphrase Donate}</a></li>

A drop down menu to view donors too.

And what is the Credit Purchase System?

AWJunkies 09-23-2010 01:25 AM

Quote:

Originally Posted by unknown22 (Post 2102032)
I have donation mod installed and wondering how could i add a drop down menu to a tab i added

<li><a href="http://mywebsite.com/forums/awcl_dsl.php?do=donation"><span style="color: #00FF00;">Donate</span>{vb:rawphrase Donate}</a></li>

A drop down menu to view donors too.

And what is the Credit Purchase System?

That above code is not correct if that is what you mean. Donate is not a phrase of mine and you have text english hard code Donate and then a vb phrase call for donate. Can you please provide the current code you have for the tab so I can help you add to it.

You need to go to credit purchase thread and read up on it or check it out on forumcoding. You can view the demo and see back-end and get a better idea.

unknown22 09-23-2010 03:42 PM

That is the code
Code:

<li><a href="http://mywebsite.com/forums/awcl_dsl.php?do=donation"><span style="color: #00FF00;">Donate</span>{vb:rawphrase Donate}</a></li>
I'm currently using for that donate tab, could you help me with the hook, because I dont want another tab just a small one beside quick links under the main tabs.


All times are GMT. The time now is 11:12 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.01513 seconds
  • Memory Usage 1,755KB
  • 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
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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