UPWORK/ODESK guru: Tips and Tricks for clients

skype: upwork.link , email: info@upwork.link

How do I set Skype status before login in

without comments

Not being able to set your status before logging in is something that, in effect, sucks. It double sucks when you consider how easy would be implementing that feature. So easy that you can, in fact, set your status before logging by just investing some seconds in modifying the file that stores all your account setup, called main.db.

To adjust of the status, need to open main.db with any SQL editor. Table – Accounts. Parameter – “set_availability”. To change the value to “6”.

sqlite> .tables
Accounts        ChatMembers     Conversations   Participants    Videos        
Alerts          Chats           DbMeta          SMSes           Voicemails    
CallMembers     ContactGroups   LegacyMessages  Transfers     
Calls           Contacts        Messages        VideoMessages 
sqlite> 
sqlite> .header ON
sqlite> select * from Accounts;
id|is_permanent|status|pwdchangestatus|logoutreason|commitstatus|suggested_skypename|
skypeout_balance_currency|skypeout_balance|skypeout_precision|skypein_numbers|
subscriptions|cblsyncstatus|offline_callforward|chat_policy|skype_call_policy|
pstn_call_policy|avatar_policy|buddycount_policy|timezone_policy|webpresence_policy|
phonenumbers_policy|voicemail_policy|authrequest_policy|ad_policy|partner_optedout|
service_provider_info|registration_timestamp|nr_of_other_instances|partner_channel_status|
flamingo_xmpp_status|federated_presence_policy|liveid_membername|roaming_history_enabled|
cobrand_id|owner_under_legal_age|type|skypename|pstnnumber|fullname|birthday|gender|
languages|country|province|city|phone_home|phone_office|phone_mobile|emails|homepage|
about|profile_timestamp|received_authrequest|displayname|refreshing|given_authlevel|
aliases|authreq_timestamp|mood_text|timezone|nrof_authed_buddies|ipcountry|given_displayname
|availability|lastonline_timestamp|capabilities|avatar_image|assigned_speeddial|
lastused_timestamp|authrequest_count|assigned_comment|alertstring|avatar_timestamp|
mood_timestamp|rich_mood_text|synced_email|set_availability|options_change_future|
cbl_profile_blob|authorized_time|sent_authrequest|sent_authrequest_time|
sent_authrequest_serial|buddyblob|cbl_future|node_capabilities|node_capabilities_and|
revoked_auth|added_in_shared_group|in_shared_group|authreq_history|profile_attachments
|stack_version|offline_authreq_id|verified_email|verified_company|uses_jcs
...
qlite> 
sqlite> update Accounts set  set_availability=6;

QUIT.))

Written by spectre

June 8th, 2014 at 12:18 pm

Posted in Tips and Tricks

Leave a Reply

*