2 way sms and automatically check details | Search |
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through October 16, 2008 ⬆ |
◄ ► |
Author | Message | |||
maxlim New member Username: Maxlim Post Number: 1 Registered: 09-2008 |
Hi, i have a question am i able to make nowsms to have a 2 way sms where a user send "check myusername" then nowsms will go into some database or some notepad or some excel and get the user information out and send it back to the user? i am making this so that i can let my webhosting customers check their information like expiry date, next payment date, payment records and so on. does anyone has already made something like this? anyway i do have a SQL database of those imformation stored by my accounting software called WHMCS. (http://whmcs.com) but i am a php / sql noob so i have no idea if i can make a script to go into the database to find. now lets say that the above idea (a php script that goes into my existing database to find) then can i make something like a notepad or some excel column to reply with. for notepad maybe it can be [clientusername] ExpiryDate = 01-01-2008 Services= blablalba for excel maybe i can seperate the name.} | |||
Des - NowSMS Support Board Administrator Username: Desosms Post Number: 102 Registered: 08-2008 |
Hi, It's certainly possible, bug getting together a script can be the tough part, especially if you are new to scripts. NowSMS will pass the text of the SMS to your script ... your script then needs to query the database or data source, and return a simple text response. PHP needs to run on a web server, so that can be a little intimidating for a newbie. I think WHMCS uses MySQL, and you could write a simple command line VBScript that takes a command line parameter, queries the database, and returns a response. There are a variety of examples that you can find in a Google search that show how to do that ... you'd just need to determine what query to issue to get the data you want out of your system. If you can write a script like this (let's call it checkuser.vbs): checkuser myusername Which simply writes back the following to the screen: [clientusername] ExpiryDate = 01-01-2008 Services= blablalba Then it's pretty easy to define this as a 2-way command in NowSMS. -- Des NowSMS Support | |||
maxlim New member Username: Maxlim Post Number: 2 Registered: 09-2008 |
hi, i am a total new in scripting, i do have totally no idea how am i going to do that. Des, can i request special help from you where i can email you, (i dont mind giving you my passwords of various database) and you help me to do it? if you think i need to pay you a sum of money for this, please let me know. i am willing. thanks | |||
maxlim New member Username: Maxlim Post Number: 3 Registered: 09-2008 |
des,your respond pls. | |||
maxlim New member Username: Maxlim Post Number: 4 Registered: 09-2008 |
? | |||
maxlim New member Username: Maxlim Post Number: 5 Registered: 09-2008 |
why do i see only 5 post here while they say there is 6 post? des, did you reply me? | |||
Des - NowSMS Support Board Administrator Username: Desosms Post Number: 114 Registered: 08-2008 |
Hi, I did post a reply to this. I'm not sure what happened to it. It must have gotten lost in our transition to a new web server. We've been running this site on the same web server for 6 years, and that server is getting old, and started having problems, forcing us to quickly move to a new server. Actually, I just checked, and it looks like my reply went missing on the old server, before we actually started the process of moving this site. Apologies for that. We really should have swapped out that old web server several years ago. I don't recall the exact words of my reply. But basically, we don't usually get involved in custom script writing. I can give general pointers, help troubleshoot problems. If you can get a script together that accepts a parameter specifying the type of information you want to receive ... then I can help you adapt it into a 2-way command script. But we do need to have a script of some sort to start with. Usually that script would be PHP, ASP or Perl running on a web server. Or a command-line script for the Windows scripting host written in VBScript or JScript. -- Des NowSMS Support |