Billyoke
Level 1
Write the reason you're deleting this FAQ
Does anyone know how I can get Direct Bulk Email Sender that works well without smtp?
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='29555' | 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='29555' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='871928' | 1 | SELECT * FROM seoclerks.members WHERE USERID='871928' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM seoclerks.members WHERE USERID=871928 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=871928 | /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=29555 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=29555
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='29555' 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='29555' 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=189076 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=189076
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=189078 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=189078
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=189079 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=189079
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='29555' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='29555' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='29555' AND status='1' AND (question like '%Direct Bulk Email Sender%' OR question like '%Direct%' OR question like '%Bulk%' OR question like '%Email%' OR question like '%Sender%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='29555' AND status='1'
AND (question like '%Direct Bulk Email Sender%' OR question like '%Direct%' OR question like '%Bulk%' OR question like '%Email%' OR question like '%Sender%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='2637' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2637' 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='266' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='266' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='2255' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='2255' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' 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=29555%' 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=29555%'
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='862522.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='862522.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 |
TommyCarey
The problem with this is that you'll destroy your own IP if you're sending 100, 1,000, or 1,000,000 emails a day if you're not using an SMTP and burning their IPs. An SMTP is in place to help you deliver your emails, as well as protect your own connection, and that's why a lot of people use them.
There are plenty of systems out there that can help you send emails, but you're in for a rude awakening if you aren't going to run them through an SMTP.
I'm currently running a system that is sending out 10,000-15,000 cold emails per day and running it through an SMTP. I warmed up my email address for a month, sent around 5,000 emails to get it there, and now I can cap my sending each day without worry because my setup has been fine-tuned to do what I need it to
Can I ask, why are you against an SMTP?
Do you think they're too expensive?
Are you not sure how to configure them?
There are some email programs that allow you to upload them to a server, configure them, and send out a ton of emails but you'll still run into problems if you're not running it through an SMTP. Your IPs will get blacklisted, you won't hit inboxes, and you won't get any responses unless you do this the right way.
I would suggest working to set up an SMTP and running it through PowerMTA so you can get the best deliverability. If that's not something you can afford, try using a 3rd party service that allows scraped lists to go out, something like Mail250.com will work well for you. If you burn an IP address with them it will cost $2 to replace it, but you'll have to go through the warm-up process again, so don't get too greedy with your sending.
I hope that helps!
Tommy Carey
https://www.seoclerks.com/user/TommyCarey Hey Billyoke, The problem with this is that you'll destroy your own IP if you're sending 100, 1,000, or 1,000,000 emails a day if you're not using an SMTP and burning their IPs. An SMTP is in place to help you deliver your emails, as well as protect your own connection, and that's why a lot of people use them. There are plenty of systems out there that can help you send emails, but you're in for a rude awakening if you aren't going to run them through an SMTP. I'm currently running a system that is sending out 10,000-15,000 cold emails per day and running it through an SMTP. I warmed up my email address for a month, sent around 5,000 emails to get it there, and now I can cap my sending each day without worry because my setup has been fine-tuned to do what I need it to :) Can I ask, why are you against an SMTP? Do you think they're too expensive? Are you not sure how to configure them? There are some email programs that allow you to upload them to a server, configure them, and send out a ton of emails but you'll still run into problems if you're not running it through an SMTP. Your IPs will get blacklisted, you won't hit inboxes, and you won't get any responses unless you do this the right way. I would suggest working to set up an SMTP and running it through PowerMTA so you can get the best deliverability. If that's not something you can afford, try using a 3rd party service that allows scraped lists to go out, something like Mail250.com will work well for you. If you burn an IP address with them it will cost $2 to replace it, but you'll have to go through the warm-up process again, so don't get too greedy with your sending. I hope that helps! Tommy Carey [url=https://www.seoclerks.com/user/TommyCarey]https://www.seoclerks.com/user/TommyCarey[/url]
Are you sure you want to delete this post?