2 way sms and automatically check details

2 way sms and automatically check details SearchSearch

SMS & MMS Technical Forum » NowSMS Support - SMS Issues (Product Support Only) » Archive through October 16, 2008 » 2 way sms and automatically check details « Previous || Next »
Author Message
maxlim
New member
Username: Maxlim

Post Number: 1
Registered: 09-2008
Posted on Wednesday, September 17, 2008 - 10:02 am:   

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
Posted on Wednesday, September 17, 2008 - 08:01 pm:   

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
Posted on Thursday, September 18, 2008 - 02:17 am:   

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
Posted on Saturday, September 20, 2008 - 07:14 pm:   

des,your respond pls.
maxlim
New member
Username: Maxlim

Post Number: 4
Registered: 09-2008
Posted on Wednesday, September 24, 2008 - 05:46 pm:   

?
maxlim
New member
Username: Maxlim

Post Number: 5
Registered: 09-2008
Posted on Wednesday, September 24, 2008 - 05:48 pm:   

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
Posted on Monday, September 29, 2008 - 07:22 pm:   

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

Login Login / Register Logout Logout Search Last 30 Days Topics Topics