Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('5ctcgaaf67jm3dde10kmcggj0lfa7jjn', '54.204.231.253', '1409635435', 'CCBot/2.0 (http://commoncrawl.org/faq/)', '0', '40', '0', '1409635435', '0'); (The table 'swsessions' is full) Ubersmith Technical Support Options and Contact Information
Support Center » Knowledgebase » Order Manager » The Edit Service Order Module
 The Edit Service Order Module
Solution The Edit Service Order module allows the order manager to update the details of preexisting services in a client's account without creating new items. The edit services module can be added to any order queue like a standard order module.  Once processed, the fields set in the order will be set in the specified services.

Just like orders where new services are added, it is necessary to specify in the order info what items are to be changed and to what.  First, the order will need have the client id of the client account that owns the services.  This can be set by adding the 'client_id' field to the order. 

Unlike the usual pack1[] style arrays used in adding new services, the edit services module will look for the 'edit_packs' array.  The edit services module can be used to update one or more services in the client's account.  The edit_packs[] array will first be indexed by a simple numeric key indicating how many services are being edited.  The next level of index will be the variables that are actually being updated in the service.  These field names are the standard set of variables for services.  The supported fields include but are not limited to: desserv, price, period, start, renewdate, options etc. The full list can be found in the edit service API script documentation.

As an example, if client 1001 had a service with id number 412 that was to be updated to renew quarterly for $300 the following variables would be set in the order:

client_id=1001
edit_packs[1]['packid']=412
edit_packs[1]['period']=3
edit_packs[1]['price']=300

Editing a second service id# 308 in the same order to renew monthly for $50 and to have a service description of 'Development' we would pass the following:

edit_packs[2]['packid']=308
edit_packs[2]['period']=1
edit_packs[2]['price']=50
edit_packs[2]['desserv']='Development'

It is not necessary to specify every possible variable in the order.  Only those items that are explicitly set in the order will be updated in the service.  All other fields will be left unchanged.

Once the order is submitted, processing the edit services module will commit the changes to the client's account.  The edit will be done through the standard edit service backend function and will be logged the same way a manual edit would be.


Article Details
Article ID: 140
Created On: 15 Nov 2011 03:27 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Don't Register | Knowledgebase | Troubleshooter | Downloads
Language: