Fermé

Paypal IPN script - PHP - MySQL - Subscriptions

Timeframe: Needs to be finished by 15th May

We need a new IPN script that also works for recurring subscriptions. Paypal send notifications similar to the standard but with more info everytime a user pays.

The end use is for a small gaming community so I hope the cost won't be to high. For someone with Paypal API and PHP knowledge I should imagine it will be a quick script.

Paypal Payment received

if the item name = 'VIP' then

$GID = 4

$SID = 0

$Expiration = CURDATE() + 5 years

else

$GID = 3

If the item name was "Server 1 - 1 month" you need to make ($SID = 1) and ($Experation = CURDATE() + 1 Month). I'm sure you get the idea.

If the name was "Server 2 - 3 month" you need to make ($SID = 3) and date ($Experation = CURDATE() + 3 Months).

Decide if it's a new user: Unique ID will be SteamID. If the SteamID is already in the database do NOT re-add.

New user:

add this information to a MySQL table.

insert into sb_admins

user = Going to use SteamID for this, as names are variables that users change very frequently in roleplay enviroments.

authid = SteamID (We convert it to remove some symbols, so will need reversing. I can give the formula for this, fairly simple)

password = user (fb1b849336f95b81b6d2495bde25636fc08077f9) (User will NOT be given the password and this is some random hash)

gid = 3

email = paypal email

validate = 0

extraflags = 0

immunity = 0

Run this query to add new users to the user tables.

Once created they will have a Autogenerated ID in a table called 'aid'. You need this number to add them to the other tables.

insert into sb_admins_severs_groups

admin_id = [url removed, login to view]

group_id = 3

srv_group_id = -1

server_id = $SID

expires = $Experation

Done, save to a log file saying who was added to what/where/any errors etc.

Compétences : MySQL, API PayPal, PHP

Voir plus : mysql subscriptions, paypal api php mysql, ipn script mysql, php mysql ipn, paypal ipn variables mysql, php mysql paypal api, paypal ipn php mysql, php mysql month ipn, send paypal, paypal change email, it symbols, ipn number, what paypal, sid m, need quick mysql script, send email php mysql, log api, mysql api, mysql else insert, php file remove, php random file name, table month php, php server api, paypal standard ipn, paypal script api php

Concernant l'employeur :
( 1 commentaire ) Brinsworth, United Kingdom

N° du projet : #1058794

5 freelance ont fait une offre moyenne de 159 $ pour ce travail

toinnisfree

quick pro help. ftp and escrow required.

150 $ USD en 2 jours
(533 Commentaires)
7.9
dinhtoan

i can do it.

200 $ USD en 2 jours
(60 Commentaires)
6.2
crystalplanet

We have complete experience in Paypal IPN and subscription. Check PM for more detail. Thank you.

250 $ USD en 2 jours
(29 Commentaires)
6.1
gkuizinas

I have extensive knowledge and experience working with PayPal, Moneybookers, SagePay. Professional PHP developer with more than 10 years of overall experience. Based in Egham, UK. My CV and portfolio can be found on Plus

250 $ USD en 1 jour
(24 Commentaires)
5.3
terwelu

I am able to do this within a day. See my feedback for paypal experience.

125 $ USD en 0 jours
(13 Commentaires)
4.3
gslogic

Respected sir, we can do this for you in 1 day, Please check your PMB. thanks

70 $ USD en 1 jour
(0 Commentaires)
1.6