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
$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.
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.