vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - eCommerce for vB4.2.2+ (https://vborg.vbsupport.ru/showthread.php?t=316501)

HM666 01-10-2015 04:59 PM

Quote:

Originally Posted by NickTheGreek (Post 2531652)
Is not a common situation, but it's a situation. There is a big I can say amount of coders who, when they're creating tables (eg user), are using:
Code:

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`....bla...bla...bla......

while professional coders are using:
Code:

CREATE TABLE IF NOT EXISTS `user`....bla...bla...bla......
What's the difference. Let's say that I'm following the first way and in the database there is already a table named "user". My code will drops that table and will create mine. So my script will works (because yes, same names, but structure is almost always different).

You, are following the second way. As you code will see that there is already a table with name "user" will bypass the creation of your code. So your script will not works.

This was very common problem some 10 years ago when Hosting providers were giving just one database in their hosting plans. Now, they're giving many, so most webmasters are using a database per script. If not, they're in risk at some day to try to install a script in the same database having tables with same names.

That's was the reason for exististin of TABLE_PREFIX.

WOW that is a good point I never thought about that personally and have never run into anyone doing that. I'll keep that in mind in the future.

TheAdminMarket 01-10-2015 05:10 PM

Quote:

Originally Posted by HM666 (Post 2531723)
WOW that is a good point I never thought about that personally and have never run into anyone doing that. I'll keep that in mind in the future.

Unfortunatelly I've bad experiance from this :( And you know where is the dammit problem? That it takes time to understand what's going wrong. In my bad experiance the table "users" has been overwritten from aeDating script (I'll never forget the name of this script). I was getting errors in some queries about the users table but I was seeing it to exists. It tooks many days(!!) to understand that that table "users" was not from my forum script (I think was phpbb) but from aeDating.

vBulletin knew that problems that's why did a very wise thing. The common naming for tables were "users", "usergroups", "threads", "posts". But they named them in singular giving an extra security.

If at anytime you see the dataschema of any script using the "DROP TABLE" and then "CREATE TABLE" just go away. For sure the developer is not good.

HM666 01-10-2015 07:31 PM

I'll keep that in mind. BTW dropping the tables & that field from the usergroup table fixed my issue :)

knikio 01-12-2015 02:29 PM

hi
I using vb 4.2.2 PL3
I just finished installing this add-on.
And this is the error message I getting in my site

Code:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\mysite\cart.php on line 437

TheAdminMarket 01-12-2015 02:49 PM

Edit the file cart.php at line 437
Replace:
Code:

$bbcode_parser =& new vB_BbCodeParser($vbulletin, fetch_tag_list());
With:
Code:

$bbcode_parser = new vB_BbCodeParser($vbulletin, fetch_tag_list());
But I suggest you to put at the top of your config file (just after <?php) the line:
Code:

define('SKIP_ALL_ERRORS', true);
It will solves the peace of your mind from dozens similar message not only coming from my mod, or other mods, but even from vBulletin code.

EDITED: Read this from vb.com forums:
http://www.vbulletin.com/forum/forum...-been-released

TheAdminMarket 01-12-2015 02:51 PM

....added above........

knikio 01-12-2015 03:16 PM

Thank you NickTheGreek For your quick reply.
It fixed my problem

TheAdminMarket 01-13-2015 06:53 AM

Version 1.4.0 released with some bug fixes, design corrects and a new feature.
  1. Fixed wrong link PAY INVOICE
  2. Fixed missing values passing to PayPal when paying the invoice
  3. Fixed 2 deprecated errors
  4. Redesigned the pay invoice template
  5. Added Delete Invoice (works only if the invoice is unpaid).
To upgrade:
  1. Upload cart.php and clientarea.php to your forum directory
  2. Upload ecommerce/functions.php to ecommerce directory
  3. Upload ecommerce/images/delete.gif to ecommerce/images
  4. Import product-ecommerce.xml
By the chance I want to thank you kastak for the ccBill payment gateway. Sorry haven't noticed before that this payment gateway has been coded by him.

Christos

TheAdminMarket 01-13-2015 02:22 PM

An uncleared input found when user submits installation URL and has been fixed. Please download version 1.4.1 and upload clientarea.php. Optionally import product-ecommerce.xml to update your version number.

concepts 01-13-2015 09:52 PM

Where do I go to change the Paypal Logo under the Payment Partners block? I do no see these blocks in the ecommerce options. I want to upload a PNG file instead of gif, however I can not find this module to change the extension anywhere in the admincp.

Thanks, and this is an AMAZING MOD!!! I'm very much impressed!


All times are GMT. The time now is 12:02 PM.

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.01515 seconds
  • Memory Usage 1,746KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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