SRL Archive - General

If you didn't know, www.memberize.me is my site where I sell Runescape upgrade codes for gold.

I'm wanting to make an RS script with interacts with a MySQL database.


How (I suppose) things will do gown.

The customer will somehow tell the script that they are online and ready to trade.
There will be a set world and location, so the script will just log into an account.
The script will grab the correct username from the order form, and then trade/accept trade of the user.
Gold will be received and the script will log out of RS.
Script will then retrieve a code from the database, and email it to the customer's email address from the order form.
The code will be marked as used, and the order will be marked as complete.



If you are interested in coding, helping coding, contributing, or just giving some helpful suggestions I'd really appreciate it!


Thanks.

Why not hire some Monkeys to be available..Get some customer service people.

From: Silentcore
Why not hire some Monkeys to be available..Get some customer service people.

U gotta pay for monkeys. U know how Indian people are :)

From: Sjoe
U gotta pay for monkeys. U know how Indian people are :)

All you got to go is go to Ape Atoll. I bet they will be happy with their new job.

I bet you can use powerbot to run this script

From: Sjoe
U know how Indian people are :)

Its awkward when YoHoJo is Indian…

From: Turpinator
Its awkward when YoHoJo is Indian…

That's the joke. :3

From: NKN
That's the joke. :3

That is the joke.

From: Turpinator
That is the joke.

That is definitely the joke.

Personally I wouldn't automate that.. To much money at stake. Would be a nightmare to add so many fail safes to stop people from tricking the script.

The PHP/ SQL stuff is a good idea tho, automate the purchasing process , but make it so you do the trades.

That's what I would do honestly

Edit: all seems easy enough now that I think about it, I just would never trust a script to do big trades

Script will then retrieve a code from the database, and email it to the customer's email address from the order form.

Might require a plugin with proper socket support or just wait until the devs aren't busy with all the irl stuff and implement proper sockets into Simba or you might use an external option. It depends. You can write the code in Simba currently though but it's annoying to write.

The customer will somehow tell the script that they are online and ready to trade.

No programmer in their right mind will code what you are asking because you aren't clear on exactly what you want. The requirements for a job is to know what protocol the senior dev wants. You are the hiring guy in this case then you have to tell the coder what you're looking for. You can't say "somehow do this". They need to know what you have and what you don't. What you're willing to accept and what you won't. If you don't already have a communication api for the customer to enter in this info and say that they are online and ready to trade, where will the script get the info from?

Unless of course you want the dev to do all of that.. :l

Brandon, i think he is talking about something like this:

create db table - 5
1 - request id (this will be an auto-generated id given to the person upon ordering the service)
2 - rsn (defined when ordering the service)
3 - online flag - false/null as default
4 - transaction completed flag - false/null as default
5 - the trade accepted code - auto-generated identity similar to request id


upon the user ordering the service, the request id, rsn, and accepted code get populated. there will be a section on the memberize.me website where it has 2 txt boxs and a button saying "logged in! les do dis" (or something similar). upon clicking, it will send a query to the database checking to see if both fields match up. if so, then online flag = true/not null/some value;


now this is the tricky part. i know how to do this really easily in c# and java but there will have to be a simba script that does some type of check to the database on a regular loop (maybe 5 min?). it will check if the flag is true. if so, it will take the rsn. it will log in and only accept trades from that user.

the rest is self explanatory

From: Brandon
Might require a plugin with proper socket support or just wait until the devs aren't busy with all the irl stuff and implement proper sockets into Simba or you might use an external option. It depends. You can write the code in Simba currently though but it's annoying to write.

I saw thread the other day where someone had posted the code to send emails from Simba. I tried it and it worked perfectly apart from the fact they ended up in my junk folder.

You could use an E-Commerce Script, then make a php script which queries the database every 24 hours. If payment = true then modify delivered to 1 then email random code then delete random code.

yoho are you going to run this on a VPS?

If you are still interested in this, I can code a Simba script & PHP/MySQL script that will do everything you need it to & fully automate the process of selling your memberships. PM me if you still need this job completed.

You could set this up fairly easy in java.

I'd just create a hashmap with all the codes you're using and mark them to 0 when used.

From: moneyman331
You could set this up fairly easy in java.

I'd just create a hashmap with all the codes you're using and mark them to 0 when used.

Or you can load all codes into an array and delete them after they have been sold.

This script needs to communicate with the server somehow so I believe PHP/MySQL will be the best way to manage the pins. I was thinking to have an order page that uses JQuery to update and automatically display the pin after Simba verifies that it has received the cash.

Using a hash map would be superior, as you could use it to track sales by date, time, day of the week, average sales / day, etc.

From: moneyman331
Using a hash map would be superior, as you could use it to track sales by date, time, day of the week, average sales / day, etc.

How would starting from Java/scratch be superior to using Simba and all of the functions included in SRL? If I do end up completing this project all of the pins/sales will be stored in a PHP/MySQL database so Simba can communicate with the website's database.

This allows for all of the features you mentioned above along with a variety of others.