vb.org Archive
Page 3 of 5 12 3 45
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBPurchase 1.0c.fl1 (https://vborg.vbsupport.ru/showthread.php?t=83231)

Ron1n 06-23-2005 01:11 AM
Quote:
Originally Posted by PixelFx
from what paypal said to me this system makes it possible to bypass and yet still use the ipn system on your paypal account. its just the url is controled in the script rather than punching it into the url location on paypal.

Its accually a much better way and still secure :)
Please, try to make sense.

Quote:
from what paypal said to me this system makes it possible
what system?

Quote:
still use the ipn system on your paypal account
there is no ipn system on your paypal account, its just a configuration variable

Quote:
its just the url is controled in the script rather than punching it into the url location on paypal.
What is?

If your asking how to have the IPN thing defined in the script, that has already been shown.

Madmax4321 06-23-2005 08:25 AM
hes just explaining that there is no need to set ipn url in your paypal profile options at paypal because the script's returns the values itself :)

btw how far is final away now ??

grains 06-23-2005 06:31 PM
this seems real cool....cant wait for final....scared to install it with bugs....lol

grains 06-23-2005 06:35 PM
are we supposed to make the changes made in fix_list_six or have they already been made to the files?

grains 06-23-2005 06:43 PM
Quote:
Originally Posted by Ron1n
I will continue adding them into txt update files until I make a general release. This just make it so ppl dont have to keep uploading new files since the changes are only take about 2 seconds to make.

nm...found the answer.

PixelFx 06-23-2005 11:29 PM
Quote:
Originally Posted by Madmax4321
hes just explaining that there is no need to set ipn url in your paypal profile options at paypal because the script's returns the values itself :)

btw how far is final away now ??
Couldn't of Said it better my self, :P Remind me not to post when I've been awake for 48+ hours str8.

Bernd 06-24-2005 02:12 PM
Two errors here afting fixing the mentioned issues in the txt.

PHP Code:
Invalid SQL: INSERT INTO ph_order (`userid`,`username`,`itemid`,`itemname`,`itemtype`,`productid`,`productname`,`price`,`quantity`,`start`,`length`,`active`)
VALUES('2','name','','','service','1','Test 1','','','number','','1')
mysql error: Unknown column 'start' in 'field list'

mysql error number: 1054

Script: xxx/purchase.php?do=ipn 
PHP Code:
Invalid SQL: SELECT `membergroupids` FROM user WHERE `id`=''
mysql error: Unknown column 'id' in 'where clause'

mysql error number: 1054

Script: xxx/purchase.php? + a whole bunch of numbers ;) 
This happens after purchase..the rest seems to work fine.
Is the any fix for the above mentioned issues? I've searched the thread but nothing came up.

PixelFx 06-25-2005 11:42 PM
Quote:
Originally Posted by Bernd
Two errors here afting fixing the mentioned issues in the txt.

PHP Code:
Invalid SQL: INSERT INTO ph_order (`userid`,`username`,`itemid`,`itemname`,`itemtype`,`productid`,`productname`,`price`,`quantity`,`start`,`length`,`active`)
VALUES('2','name','','','service','1','Test 1','','','number','','1')
mysql error: Unknown column 'start' in 'field list'

mysql error number: 1054

Script: xxx/purchase.php?do=ipn 
PHP Code:
Invalid SQL: SELECT `membergroupids` FROM user WHERE `id`=''
mysql error: Unknown column 'id' in 'where clause'

mysql error number: 1054

Script: xxx/purchase.php? + a whole bunch of numbers ;) 
This happens after purchase..the rest seems to work fine.
Is the any fix for the above mentioned issues? I've searched the thread but nothing came up.
I'm looking forward to the next release or update :)

King Kovifor 06-26-2005 06:22 PM
CinVin Products.php pictures...

Ron1n 06-28-2005 06:01 AM
Quote:
Originally Posted by Bernd
Two errors here afting fixing the mentioned issues in the txt.

PHP Code:
Invalid SQL: INSERT INTO ph_order (`userid`,`username`,`itemid`,`itemname`,`itemtype`,`productid`,`productname`,`price`,`quantity`,`start`,`length`,`active`)
VALUES('2','name','','','service','1','Test 1','','','number','','1')
mysql error: Unknown column 'start' in 'field list'

mysql error number: 1054

Script: xxx/purchase.php?do=ipn 
Ok, change start to date - tell me if that helped.

Quote:
Originally Posted by Bernd
PHP Code:
Invalid SQL: SELECT `membergroupids` FROM user WHERE `id`=''
mysql error: Unknown column 'id' in 'where clause'

mysql error number: 1054

Script: xxx/purchase.php? + a whole bunch of numbers ;) 
This happens after purchase..the rest seems to work fine.
Is the any fix for the above mentioned issues? I've searched the thread but nothing came up.
Change id to userid

released :D

Bernd 06-28-2005 08:05 AM
purchase.php?do=reciept&tx= + NUMBERS

ends up being a blank page. I don't receive an error notification.

jugo 06-28-2005 11:31 AM
?? Can we add custom fields to the order form?

Ron1n 06-28-2005 01:12 PM
Quote:
Originally Posted by Bernd
purchase.php?do=reciept&tx= + NUMBERS

ends up being a blank page. I don't receive an error notification.
Look in your logs, copy and paste the two longs associated with that specific 'NUMBERS' string.

Also... answer these questions:
- is the order created
- is there a ' in the product name/ item name

I cant see why you would get a blank page... unless its not communicating with paypal and times out... or if your missing a template. The whole blank page doesnt make much sense. You can do some debugging and add some echo "[reached point:a]"; statements (but use different letters), and tell me if it dies at some point. This will help me track the problem.

Quote:
?? Can we add custom fields to the order form?
Be my guest!

jugo 06-28-2005 02:50 PM
When will you have an installer for this ron1n. My brain hurts... lol

Ron1n 06-28-2005 05:18 PM
Quote:
Originally Posted by jugo
When will you have an installer for this ron1n. My brain hurts... lol
it doesnt really need one... its a simple install

yoyoyoyo 06-30-2005 12:33 AM
Thanks for the updated file. I installed it on a brand new install of VB 3.0.6, and it gave me a few errors when I ran the MySQL queries. I ran them one at a time as listed.

When I entered the query:
[sql]ALTER TABLE `ph_settings` ADD `return` VARCHAR( 50 ) NOT NULL ,
ADD `notify` VARCHAR( 50 ) NOT NULL ;[/sql]
I got the following error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'return'
when I ran this SQL query:[sql]INSERT INTO `ph_settings` VALUES ('', 0, '', '', 0, '', '');[/sql]
I got the following error:
Quote:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1136
error desc: Column count doesn't match value count at row 1
Try deleting the tables from your database and redo the sql queries as listed in the zip file and you will see what I mean.

Also I was a bit confused by the file name "includes_mysql_edit" but I soon figured out I needed to edit FORUM/includes/db_mysql.php

I am still getting taken to the paypal page even if the item is marked as FREE. Will this be changed in a future version?

Thanks again.

PixelFx 06-30-2005 04:50 AM
I got the same errors when I installed 1.0c on vb3.0.7. Other than the few errors above so far so good, do you want me to post screenshots later?

When I got to click ok on settings edited, it gives me a phrase error:

Can Note Find Phase "Settings Edited" .... you weren't kidding when you wait phases not setup yet.

where do I read in database to know what phrases to setup ?

Madmax4321 06-30-2005 04:54 PM
hi im now getting this error:

Warning: fopen(00H1682458552343F.datatrans): failed to open stream: Permission denied in /purchase.php on line 311

Warning: fputs(): supplied argument is not a valid stream resource in /purchase.php on line 312

Warning: fclose(): supplied argument is not a valid stream resource in /purchase.php on line 313

how do i fix this one and no info goes into db.

another thing i noticed is i get no ipn callback but if i look @ whosonline i see guest purchase.php?do=ipn viewing no permission message do i need to allow guests to view forum for this to work?

the reciept url returns np and says you can download from members area shortly etc and i get success message in log files but no ipn logs.

have you a solution try ??

Ron1n 07-01-2005 09:18 PM
@yoyoyoyo

Code:
ALTER TABLE `ph_settings` ADD `return` VARCHAR( 50 ) NOT NULL ,
ADD `notify` VARCHAR( 50 ) NOT NULL ;
found its way into my description - removed and reuploaded

Code:
I am still getting taken to the paypal page even if the item is marked as FREE.  Will this be changed in a future version?
Probably not - i just wont allow free items. I mean, I dont know. I wont be updating this POS anytime soon though, I have real work that is taking over my life and doesnt let me have any free time.

@PixelFX

Search the admin file I provided for the phrase 'redirect' without the ''

@Madmax4321

1. The fopen, fputs, fclose is all permissions errors on your system or it cant find the directory. You just have to chmod + make sure the file exists.

2. The URL reciept just lets you know the transaction was OK from the users end, basically it lets you debug. :) The reciept should never submit information into the database because users can spoof the reciept (thats paypals fault, not mine). The IPN, however, doesnt seem to be exploitable.

3. The IPN problem.. hrm. There shouldnt be a problem with guests viewing the purchase.php file - I didnt put anything there to stop them. Have you tried accessing purchase.php as a guest? If you can, then it should be OK. If you cant, I dont know which settings you changed to make it like that but I am pretty sure its not my code. If guests can view it, then please fetch your server logs for me and check to see what error was created.

There is now a fix list for version 1.0c.

Madmax4321 07-01-2005 09:34 PM
as logged out i cannot access the purchase.php so im guesing its my usergroup settings i changed when started to build my forum.

will revert it all back and try again.

one thing i would note is the db colums notify & return arnt big enough my urls dont fit in them :)

i changed them to VARCHAR( 75 ) might be worth adding to fixlist

Ron1n 07-02-2005 01:51 AM
Quote:
Originally Posted by Madmax4321
as logged out i cannot access the purchase.php so im guesing its my usergroup settings i changed when started to build my forum.

will revert it all back and try again.

one thing i would note is the db colums notify & return arnt big enough my urls dont fit in them :)

i changed them to VARCHAR( 75 ) might be worth adding to fixlist
lol, yea - i will in the next one. wtf is your domain if it is longer than 50 chars?

http://imabigloserwhoisfat.com/forum...ase.php?do=ipn is 50 characters long...

The Geek 07-02-2005 07:26 AM
here is a modified purchase.php that fixes several security issues. I dont know if it takes care of all - just some of the obvious ones I found. Hope I havent broken any functionality in the process ;)

yoyoyoyo 07-02-2005 11:34 AM
Quote:
Originally Posted by The Geek
here is a modified purchase.php that fixes several security issues. I dont know if it takes care of all - just some of the obvious ones I found. Hope I havent broken any functionality in the process ;)
cool, thanks!

sketch42 07-13-2005 05:47 AM
what phrases are missing?? or where can i find the missing phrases(what file??)

****EDIT****
also is there a way to add a item called Goods. because i want to use this to sell actuall items like say a dvd burner or something. and can you have multiple pages?

redspider 07-16-2005 09:26 PM
how can I fix the phrases problem ? like
Could not find phrase 'Name not Specified'.
Could not find phrase 'Settings Edited'.

sketch42 07-17-2005 01:34 AM
Quote:
Originally Posted by Ron1n
FULL RELEASE!

**ATTN**
USE THE FIX LIST ---> AND MAKE SURE YOU HAVE COMPLETED EACH STEP BEFORE INSTALLING. IF YOU HAVE ALREADY INSTALLED, JUST MAKE SURE YOU DO THEM SOON.

For those of you with other versions installed please upgrade using the upgrade_OLDVERSION_NEWVERSION.txt and everything will workfine.

READ ALL OF THIS BEFORE POSTING AND BEFORE DOWNLOADING:
This is not a beta anymore, but it is for capable, expirienced users only. This can be used as a final product, but it is not meant to be a final product. Users will proabably want to add some features for their own forum to meet their unique needs.

Overview:
This is a purchase/member area hack for vBulletin that is integrated with paypal. It comes with no warrantee, no installer, and limited support. It has been tested on all 3.0.x versions and is working (for the most part).

Bugs:
- I did not include admincp phrases
- There are problems when usernames contain '

Suggestions:
- Custom order fields

Notices:
- There is no support extension, but this hack does automatically add users to a new usergroup if you want it to, and therefore you can have a support forum for your users who have actually purchased items.
known issue

PixelFx 07-17-2005 04:02 PM
can someone add the phases as addon for this? or point me in the right direction to add/create them my self?

axi 07-17-2005 04:22 PM
anyone got screenshots

micheal332001 07-17-2005 05:47 PM
Quote:
Originally Posted by redspider
how can I fix the phrases problem ? like
Could not find phrase 'Name not Specified'.
Could not find phrase 'Settings Edited'.

I have the same problem if anyone has these could you please put them here
so i can try this system out.

Nice work as fare as i can tell

sketch42 07-17-2005 06:06 PM
Quote:
Originally Posted by micheal332001
I have the same problem if anyone has these could you please put them here
so i can try this system out.

Nice work as fare as i can tell
look 3 posts up at the authors description and youll see that he never included the phrases

micheal332001 07-17-2005 06:23 PM
So how are we to use this if we dont know then.

Can you help im new at this vbulleting stuff.
I do programing of php but woking with phrases
Is all new to me please help

sketch42 07-17-2005 07:31 PM
Quote:
Originally Posted by micheal332001
So how are we to use this if we dont know then.

Can you help im new at this vbulleting stuff.
I do programing of php but woking with phrases
Is all new to me please help
it doesnt need the phrases to fuction actually, all the phrases do here are confirming whether or not an action was successfull or not but is not needed to run the action itself

micheal332001 07-17-2005 07:41 PM
But when i try to add a product it will not add it.

WhisperPntr 07-21-2005 11:52 PM
michael, did you mark the product as active? EVERY product must be marked as active in order to be added, as well as have both descriptions filled. If in doubt, fill in everything and then edit them later.

as for the script itself
I'm still having a few problems with paypal IPN. Granted I'm using sandbox, however I have been told that there are not that many differences between live and sandbox.

The receipt goes through perfectly as well as the order, but the IPN address is not being called. At all.

There are logs for datastores but not .ipn. Calling ipn manually from the paypaltest.com page also stores a .ipn file.

Did anyone have this issue and was anyone able to resolve it?

Madmax4321 07-22-2005 07:03 PM
Quote:
Originally Posted by WhisperPntr
michael, did you mark the product as active? EVERY product must be marked as active in order to be added, as well as have both descriptions filled. If in doubt, fill in everything and then edit them later.

as for the script itself
I'm still having a few problems with paypal IPN. Granted I'm using sandbox, however I have been told that there are not that many differences between live and sandbox.

The receipt goes through perfectly as well as the order, but the IPN address is not being called. At all.

There are logs for datastores but not .ipn. Calling ipn manually from the paypaltest.com page also stores a .ipn file.

Did anyone have this issue and was anyone able to resolve it?
yes i have had same problems the receipt returns but the ipn never does.

Mythotical 07-23-2005 04:52 PM
My problem is this, I add a product, ok it goes through now, but nothing shows up when I go to add Item nor does it show up on my product listing. Any help with that would be much appreciated.

Thanks
Myth

Mythotical 07-23-2005 05:47 PM
Ok just checked a database error, its not even inserting the information, here is what I got in an email concerning entering the information:
Code:
Database error in vBulletin 3.0.7:

Invalid SQL: INSERT INTO ph_file(`name`,`type`,`size`,`file`) VALUES('Traveller.zip','application/force-download','1484578','PK\0\0\0\0??2c x2\0\0??\0\0\0\0Do Not Upload/logo.psd?\\wXS???7;!?!(J؎@r?YI\0AA??jH.!?eਫ???:k]u?٪?:k??Z+{??/֯U??X??Z??{Ö?k?????|xΛs?y?{ޓ{?y2U~!@? d?J?0?>Dao?*;?B!?p\0$?C?b    ?_&??Iqۋ/m\\?,ݸjz5!??E?גRk?m%???az?99??/?Dq ????\\~?U?U?Fذ?}??#*?r]Tj
+?FQc??0??Sc2?튚?(??R?)`g??8???29J??&?    (?F??8N?MW?(H?l?????
?ê?????????????r_? F?}?١?I0ۣ]N??cv+?`u,f>֔Y??䨨\\?tڦ8V??HD?iy?3af??\'?kr???i??I?H?X+F?V?G?U?u??R+??^a?&??U\'?k3??;???i?f{Cd+?ă8e~?)C?Bm?4?+?b1?(quN~?D9?Bg????Tۓxm?????Ö\"???    |i?\0-B?B,I??|~ \'.?6>r-:C???>E|T??(???>Zh???I?qh???????V???z3L???#7W?n?:??NOq:
:?J ???r??T??QT)Qf?2U?L?L\"D?*b-+?^??m?;4f-??3C)?fddJ?
>?rI?J?f„?g
??>[????q???O.y?Xq?\"?f?+$?V
??{??V`f???L
?????8m0m)nkZ?jӒW?6???
?A?Iv[??p    UX?A?١?X?????`?sW ?y2W,?Æ?>?˄\\?\\??Q???&???    ??H??A])>C9lB?P?S(Qf?$|_?b5_?O??$r???????????]X??O?\0??\\8W?o????
???xl?/?Jڵ,i??[?????b??
???+?-?+v??    %2??+??%|??m??B?u鈸??? 2b?D??L?\'?? b????
aq?TFP9Ne|??THPA?%la?P??TDPGJPN??:r1?R?? r?’?r?? ?J    *#(?#?:r? ?
    *\"(a??D?G%\\X?\\X?\\    Wʕq?\\???.*??\".,c??J???P?x???? X?=3$??M,R??*?4C??
Q?&C ?dqF?f??E???o?қ?/?{??Um??????????Ze???6K????? z?8?j    *?H?hK7-????e??\'?pޫS????5???kz?Ki?? ? n??-x??O??    ?<A܂\'?[?q ? n??-x??O??    ?<A܂\'?[?q ? n??-x??O??    ?<A܂\'?[?q ? n??-x??O??    ?<A܂\'?[?q ? n??-x??O??    ?<A܂\'?[???j?G??u?Q?Q?)?L?Ϯ;? R?4|w0??hB?Xູ?M ?;?5?8?i܅???3???a@???????(??|H??\0??J????\\????7q-???#&hB3?????[?o?[????knX[È?j?wͱ!;    ĈF????Ap??5R??5?v!d??qG?GN?+w?u?3 ?????-x?~?+????7;?F@, ??,N?ΞW6T?,/?:P?0?\"??c????nr?rG˱?a15??i?+???hv?A?ً?9v??8TB;?щAvz ?t??ⴶb?,6??`??N?3
q?<?????? 3c6????E?+X?2˥?spI?IO??_^??i3e ,+?ߚ?k?c+84??Q?ѷ??h1h??8??YE?9e?0?+????? o̔?k?Y?lȢ??r????ի0????Fvku?2=q??Er?]?^M|}-f????X??;?2q,#L?K\\v???? nqE[u?$uu????ցf?/???[??l!??7?6?????R?8,&<}p?5Z?5?0O??Ps??P 0??λ{&!+????_k???!??/?avXh??7V;?8?uPY%?\'?%d???P??w????????u&3,p>g?Τ??a??*\'^??؟Xe??a?,???&???+A&L#?Y??V?>??ƶ?a?    V[ߢ_֢?/Jm?\'???Uۍ???2NVm???|????t??d՘??Z3???.?5???¿|o]???=CB?5??ӳ,??c??ͼ?y\0l{??Kͼ?%?\\?}?z??zB?zi?? ?6Oh?O????qwM?᤻?$ϛ?<??c???r???6l???`??
3C?bXe?n?Yg .;???Ӭ
Now explain that and how I can fix that if you would be so kind.

Mythotical 07-23-2005 05:59 PM
Currently I am having to go into the database and manually insert the information, but I can't insert the download location as of yet, still working on that. Once this problem is fixed I will be able to do this from the ACP.

micheal332001 07-23-2005 11:14 PM
Hi there

I had someone test the paypal out for me on this and this is what it put in the batabase


1 316 USERNAME 0 service 2 Pnmmleague module 0 0 1122159630 0 2

As you can see here it is missing a few bits of info like
itemid itemname quantity

As you can see here with itemid it put in the default 0
itemname it did not put in any thing
And quantity it put in the default in for that too 0
also this friend that tested this choose the license not a service but it put it in as a service

Is there any fix you have done for this or some thing i can do.

WhisperPntr 07-24-2005 03:56 PM
Thus far I have succesfully added additional payment options as well as an option to choose a CC processing fee. I'll be trying out a script that will use sendmail to notify my personal paypal payment has been made.

As for .ipn, it posted in sandbox when I used an http:// address and also when I used The Geek's purchase.php mysql injection fix. Testing on sandbox however always returns an invalid response and I'm going to switch back to https:// before troubleshooting the code that is used.

This code is great but definitely needs lots of tuning to suit your needs.


All times are GMT. The time now is 04:17 AM.
Page 3 of 5 12 3 45
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.01535 seconds
  • Memory Usage 1,890KB
  • 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
  • (6)bbcode_php_printable
  • (21)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