Advanced User Upgrade [Deleted]

[Insy]

Insy submitted a new resource:

Advanced User Upgrade (version 1.0) - Allow to use multiple Paypal emails for user upgrades

Warning: This addon requires to edit a file by hand.

Description:
This small add-on allows you to use a different Paypal email for each user upgrade.

View attachment 36097

For example, if you use user upgrades to sell addons from many authors, authors may be paid directly to their Paypal accounts.

Installation:

1. Upload the files. The zip file contains...

Read more about this resource...

 

[TRACKMIXERS]

Thank you for this Insy! Have you considered integrating paypal adaptive payments for this (Chained payments)?

 

[Insy]

Have you considered integrating paypal adaptive payments for this (Chained payments)?

Thanks I didn't know this feature but I do not think it is useful for this addon.

 

[James]

You should include another file to override the current one, people don't like making file edits

 

[DRE]

This is just what I need. Thanks!

 

[Insy]

You should include another file to override the current one, people don't like making file edits

I know. I'll see how I could do that

 

[DRE]

Most people won't know this is a multiple paypal donations addon. I think you should rename it to something like 'Multiple Paypal User Upgrades.

I could've sworn I've seen two other addons that sounded similar to this one.

 

[Insy]

Most people won't know this is a multiple paypal donations addon. I think you should rename it to something like 'Multiple Paypal User Upgrades.

Title updated

 

[DRE]

Title updated

Thanks dude. Now the importance of this addon will light a light-bulb up in some heads.

 

[Insy]

Insy updated Multiple Paypal User Upgrades with a new update entry:

1.0.1 Released

First update of my first addon, thanks for your feedbacks.

You should include another file to override the current one, people don't like making file edits

It is now the case, the Paypal callback request go through a payment_callback_advanced.php file in the root of your forum and you won't need anymore to edit any file by hand.

I also added an option to customize the description of the purchase (i.e the item name)....

Read the rest of this update entry...

 

[DRE]

Um... what were the previous file edits? They were made to my xenforo core files right? I need to re-upload the original files then. Which files were they? After I reupload, just upgrade this one?

 

[Insy]

Um... what were the previous file edits? They were made to my xenforo core files right? I need to re-upload the original files then. Which files were they? After I reupload, just upgrade this one?

You only need to restore payment_callback.php if you edited it. Nothing else.

 

[DRE]

You only need to restore payment_callback.php if you edited it. Nothing else.

Where is that file located?

Edit: NVM I just saw it on the root.

 

[Luis]

Thanks for the Addon Insy.

If I am not mistaken the edited file is library/XenForo/UserUpgradeProcess/Paypal.php not payment_callback.php.

When making a installation of the Addon (1.0.1) for the first time generates this error:

Error Info:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD paypal_item_name varchar(255) NOT NULL' at line 3 - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace:

#0 /var/www/vhosts/directory/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?              ...')
#1 /var/www/vhosts/directory/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?              ...')
#2 /var/www/vhosts/directory/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?              ...')
#3 /var/www/vhosts/directory/library/Insy/UserUpgrade/Installer.php(23): Zend_Db_Adapter_Abstract->query('?              ...')
#4 [internal function]: Insy_UserUpgrade_Installer::install(false, Array)
#5 /var/www/vhosts/directory/library/XenForo/Model/AddOn.php(214): call_user_func(Array, false, Array)
#6 /var/www/vhosts/directory/library/XenForo/Model/AddOn.php(169): XenForo_Model_AddOn->installAddOnXml(Object(SimpleXMLElement), false)
#7 /var/www/vhosts/directory/library/XenForo/ControllerAdmin/AddOn.php(178): XenForo_Model_AddOn->installAddOnXmlFromFile('/tmp/phpSJCtnW')
#8 /var/www/vhosts/directory/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_AddOn->actionInstall()
#9 /var/www/vhosts/directory/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts/directory/admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State:

array(3) {
  ["url"] => string(50) "http://directory/admin.php?add-ons/install"
  ["_GET"] => array(1) {
    ["add-ons/install"] => string(0) ""
  }
  ["_POST"] => array(3) {
    ["server_file"] => string(0) ""
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(53) "1,1351038850,d83d1e9e09b8e106bb1a06b8e8687fbe44705373"
  }
}

However, update the Addon work correctly.

After updating the Addon and uninstalling it generates this error:

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP COLUMN paypal_item_name' at line 3 - library/Zend/Db/Statement/Mysqli.php:77

Stack Trace:

#0 /var/www/vhosts/directory/library/Zend/Db/Statement.php(115): Zend_Db_Statement_Mysqli->_prepare('?            AL...')
#1 /var/www/vhosts/directory/library/Zend/Db/Adapter/Mysqli.php(381): Zend_Db_Statement->__construct(Object(Zend_Db_Adapter_Mysqli), '?            AL...')
#2 /var/www/vhosts/directory/library/Zend/Db/Adapter/Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare('?            AL...')
#3 /var/www/vhosts/directory/library/Insy/UserUpgrade/Installer.php(35): Zend_Db_Adapter_Abstract->query('?            AL...')
#4 [internal function]: Insy_UserUpgrade_Installer::uninstall(Array)
#5 /var/www/vhosts/directory/library/XenForo/DataWriter/AddOn.php(193): call_user_func(Array, Array)
#6 /var/www/vhosts/directory/library/XenForo/DataWriter.php(1738): XenForo_DataWriter_AddOn->_postDelete()
#7 /var/www/vhosts/directory/library/XenForo/ControllerAdmin/AddOn.php(116): XenForo_DataWriter->delete()
#8 /var/www/vhosts/directory/library/XenForo/FrontController.php(310): XenForo_ControllerAdmin_AddOn->actionDelete()
#9 /var/www/vhosts/directory/library/XenForo/FrontController.php(132): XenForo_FrontController->dispatch(Object(XenForo_RouteMatch))
#10 /var/www/vhosts/directory/admin.php(13): XenForo_FrontController->run()
#11 {main}

Request State:

array(3) {
  ["url"] => string(66) "http://directory/admin.php?add-ons/Insy_UserUpgrade/delete"
  ["_GET"] => array(1) {
    ["add-ons/Insy_UserUpgrade/delete"] => string(0) ""
  }
  ["_POST"] => array(2) {
    ["_xfConfirm"] => string(1) "1"
    ["_xfToken"] => string(53) "1,1351039247,736e3b393b73abf6469cbef30aece91ef8212530"
  }
}

Sorry for my english, is english of Google.

Regards, Luis.

 

[Insy]

If I am not mistaken the edited file is library/XenForo/UserUpgradeProcess/Paypal.php not payment_callback.php.

You're right, I made a mistake in my answer to 8thos.
Fortunately, this has no effect (no error) if this file is not restored.

Zend_Db_Statement_Mysqli_Exception: Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ADD paypal_item_name varchar(255) NOT NULL' at line 3 - library/Zend/Db/Statement/Mysqli.php:77

I performed the installation on multiple servers and all have worked, what is your version of MySQL?

 

[Luis]

The version of MySQL is 5.1.61. Thanks.

Edit: 5.1.52

 

[Insy]

The version of MySQL is 5.1.61. Thanks.

Uninstall the addon then replace library/Insy/UserUpgrade/Installer.php by the attachment and try to install the addon again. Does it working ?

 

[Luis]

This solution does not work.

On a side note, the first version of the Addon has been installed/uninstalled without any error.

 

[cclaerhout]

You forgot a coma at then end of the first ADD

 

[Luis]

You forgot a coma at then end of the first ADD

Cédric, you can point out exactly where the comma is missing.

Thanks.