anwebservices
Level X5
Write the reason you're deleting this FAQ
Applications for mobile phones is not something i have done so far, but i am interesting into this field. I also learned that many app makers, making a big revenue by creating their apps so i am interested to know what should be done or how actually to make earnings by having own application on Google play store?
If you done this before, i would love to here some advices so i can start making drafts of my application which i have in mind. Thank you.
Are you sure you want to delete this post?
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='17491' | 1 | SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid
FROM `questions` as q
JOIN categories_faq as c ON q.catid=c.CATID
WHERE (q.status=1 OR
(q.status=2 AND userid='')
)
AND q.quesid='17491' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='254580' | 1 | SELECT * FROM seoclerks.members WHERE USERID='254580' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='55' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='55' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=254580 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=254580 | /opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() () |
| SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=17491 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=17491
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17491' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered,
b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b
WHERE a.quesid='17491' AND a.userid=b.USERID and b.status='1' AND a.status=1
ORDER BY a.combined_votes DESC, a.date_answered asc | /opt/clerks-staging/docroot/viewfaq.php 1245 () () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=95325 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=95325
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=95336 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=95336
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=149079 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=149079
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='17491' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='17491' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='17491' AND status='1' AND (question like '%How earn revenuue mobile application?%' OR question like '%earn%' OR question like '%revenuue%' OR question like '%mobile%' OR question like '%application?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='17491' AND status='1'
AND (question like '%How earn revenuue mobile application?%' OR question like '%earn%' OR question like '%revenuue%' OR question like '%mobile%' OR question like '%application?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1220' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1220' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='318' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='318' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='1129' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1129' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='3250' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3250' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=17491%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=17491%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='254580.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='254580.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='600657.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='600657.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
So before you start thinking about how you can make money with an app you need to think of an app concept that people will download and play non stop
Start simple, but addictive ;)
After you get an app up and running that you think will be a hit, you'll need to figure out if you want it to be a free app or a paid app. Free apps with ads on them are downloaded much more often than paid apps. This is mainly because people are willing to download a free app and check it out but not willing to pay $0.99 to check something out, which makes sense.
So on your free app you can run either admob for android or iAd for IOS.
admob: This is for android mobile apps and can place ads where you want them to be. This is similar to adsense and how it shows relevant ads to people on your app. When someone clicks on your ad, you make some money. The amount you make depends on the niche and how much the advertiser is paying per click or measure. https://firebase.google.com/docs/admob/
iAd: This is for IOS or Apple phones and can put advertisements on your apps for people to click. This is the same concept as admob, see the above description ;) https://developer.apple.com/iad/
NOTE: iAd will only be available until July 1, 2016 so most of the people reading this will have to use a 3rd party service to place ads on their IOS apps. First off you would need a good app that will become popular. You'll at least need 1,000 active users to see any type of revenue coming in. So before you start thinking about how you can make money with an app you need to think of an app concept that people will download and play non stop :D Easy to learn apps can become addicting if there are levels or any type of progression that can be made. The more progression the person makes, the more difficult the game or app gets. You can also make informative apps that can become more popular, but games are downloaded more and can see more profit in the long run. A simple game that I saw was a piano game the sped up the longer you played. If you missed a note you would lose and have to start over. The farther you got, the more points you would gain and you could unlock certain features. Start simple, but addictive ;) After you get an app up and running that you think will be a hit, you'll need to figure out if you want it to be a free app or a paid app. Free apps with ads on them are downloaded much more often than paid apps. This is mainly because people are willing to download a free app and check it out but not willing to pay $0.99 to check something out, which makes sense. So on your free app you can run either admob for android or iAd for IOS. [u][b]admob:[/b][/u] This is for android mobile apps and can place ads where you want them to be. This is similar to adsense and how it shows relevant ads to people on your app. When someone clicks on your ad, you make some money. The amount you make depends on the niche and how much the advertiser is paying per click or measure. [url=https://firebase.google.com/docs/admob/]https://firebase.google.com/docs/admob/[/url] [u][b]iAd:[/b][/u] This is for IOS or Apple phones and can put advertisements on your apps for people to click. This is the same concept as admob, see the above description ;) [url=https://developer.apple.com/iad/]https://developer.apple.com/iad/[/url] NOTE: iAd will only be available until July 1, 2016 so most of the people reading this will have to use a 3rd party service to place ads on their IOS apps.
Are you sure you want to delete this post?