I need a few scripts that communicate from within Second Life to a MySQL database via PHP. I will need the LSL script to be able to add "users" to the database, and check whether they are "confirmed" or not, and also be able to send messages to certain users that are stored in the database, as well as dispatch an item to the users when the command is given by the owner.
Not sure how clear the above is, so let me try and break it down:
MySQL Database stores the following (for multiple avatars):
Avatar Name
Key
A link to a web site
Confirmed or not (this will be a simple binary indication of either 1 or 0)
The Server Script must be able to do the following:
Check wether an avatar is confirmed or not, and relay that information to the owner
Change the confirmation status of the avatar
Change the web link associated with the avatar
Send a message from the server owner to the avatar
Send an object from the server to the avatar
The third script must be able to do the following:
Check if the owner is in the database
If yes, check whether they are confirmed or not
Retrieve the web address associated with the owner
If you think that you are able to do this, please contact me at [email]bcarter@virtufly.com[/email] with a quote and scripting experience.
Also, please note that this is for a non-profit cause, and I cannot provide an incredible sum of money, however, your name/SLURL/website will be featured in a prominent location on our site when it is online. This does not mean that you will not be paid.