PtcPara : Welcome To PtcPara!
sayfasına girip, anilptc kullanıcı adı ve şifresi ile giriş yapın ve "earnings area" bölümüne tıklayın. Bir kopyasını burada göstereyim;
Aldığım hata:
Database error: Invalid SQL: SELECT id FROM ads WHERE credits>=1 and active=1 and (country='' or country='') and (daily_limit>views_today or daily_limit=0) and (upgrade='0' or upgrade='1') MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'upgrade='0' or upgrade='1')' at line 6) Session halted.Kodun tamamı:
<?
$includes[title]="How To Earn";
if(SETTING_PTC == true && $settings[ptcon] == 1) {
$clickHistory = loadClickHistory($username, "ptc");
$sql = $Db1->query("SELECT id FROM ads WHERE
credits>=1
and active=1
and (country='' or country='{$thismemberinfo[country]}')
and (daily_limit>views_today or daily_limit=0)
and (upgrade='0' ".($thismemberinfo[type]==1?" or upgrade='1'":"").")
");
$totalptc=0;
while($ad=$Db1->fetch_array($sql)) {
if(findclick($clickHistory, $ad['id']) == 0) $totalptc++;
}
}
//and username!='$username'
if(SETTING_CE == true && $settings[ce_on] == 1) {
$clickHistory = loadClickHistory($username, "ce");
$sql = $Db1->query("SELECT id FROM xsites WHERE
credits>=1
and active=1
and (country='' or country='{$thismemberinfo[country]}')
and (daily_limit>views_today or daily_limit=0)
and (upgrade='0' ".($thismemberinfo[type]==1?" or upgrade='1'":"").")
");
$totalce=0;
while($ad=$Db1->fetch_array($sql)) {
if(findclick($clickHistory, $ad['id']) == 0) $totalce++;
}
}
if(SETTING_PTRA == true && $settings[ptraon] == 1) {
$clickHistory = loadClickHistory($username, "ptra");
$sql = $Db1->query("SELECT id FROM ptrads WHERE
credits>=1
and active=1
and (country='' or country='{$thismemberinfo[country]}')
and (daily_limit>views_today or daily_limit=0)
and (upgrade='0' ".($thismemberinfo[type]==1?" or upgrade='1'":"").")
");
$totalptra=0;
while($ad=$Db1->fetch_array($sql)) {
if(findclick($clickHistory, $ad['id']) == 0) $totalptra++;
}
}
if(SETTING_PTSU == true && $settings[ptsuon] == 1) {
$sql=$Db1->query("SELECT * FROM ptsu_history WHERE username='$username'");
if($Db1->num_rows() != 0) {
$temp=$Db1->fetch_array($sql);
$preclicked=$temp[clicks];
}
if($preclicked == "") {
$preclicked=":0:";
}
$totalptsu=0;
$sql=$Db1->query("SELECT * FROM ptsuads WHERE credits>=1 and (country='' or country='$thismemberinfo[country]') and active='1' and (upgrade='0' ".iif($thismemberinfo[type]==1," or upgrade='1'").")");
if($Db1->num_rows() != 0) {
for($x=0; $ad=$Db1->fetch_array($sql); $x++) {
if(findclick($preclicked, $ad[id]) == 0) {
$totalptsu++;
}
}
}
}
// You can also earn stage level bonuses after surfing X pages. <a href=\"index.php?view=account&ac=stage_info&".$url_variables."\">Click Here</a> to view stage earnings and to learn more.
if($settings[showPremOnlyMsg]) {
$sql = $Db1->query("SELECT COUNT(id)as total FROM ads WHERE credits>=1 and active='1' and (daily_limit>views_today or daily_limit=0) and upgrade='1' ");
$upgradeOnly = $Db1->fetch_array($sql);
$uptotal+=$upgradeOnly[total];
$sql = $Db1->query("SELECT COUNT(id)as total FROM ptsuads WHERE credits>=1 and active='1' and upgrade='1' ");
$upgradeOnly = $Db1->fetch_array($sql);
$uptotal+=$upgradeOnly[total];
$sql = $Db1->query("SELECT COUNT(id)as total FROM ptrads WHERE credits>=1 and (daily_limit>views_today or daily_limit=0) and upgrade='1' ");
$upgradeOnly = $Db1->fetch_array($sql);
$uptotal+=$upgradeOnly[total];
$sql = $Db1->query("SELECT COUNT(id)as total FROM xsites WHERE credits>=1 and (daily_limit>views_today or daily_limit=0) and upgrade='1' ");
$upgradeOnly = $Db1->fetch_array($sql);
$uptotal+=$upgradeOnly[total];
if($uptotal > 0) {
if($thismemberinfo[type] != 1) $showmsg="<div style=\"background-color: pink; border: 1px solid red; margin: 10px;\">Upgrade to a premium account to access more advertisements. There are currently ".$uptotal." premium-only ads available!</div>";
if($thismemberinfo[type] == 1) $showmsg="<div style=\"background-color: lightgreen; border: 1px solid green; margin: 10px;\">You are a premium member! There are currently ".$uptotal." premium-only ads in the system!</div>";
}
}
$includes[content]="
$showmsg
<dl>
".iif(SETTING_PTC == true && $settings[ptcon] == 1,"
<fieldset><legend>Paid to Click</legend>
<li><b><a href=\"index.php?view=account&ac=click&".$url_variables."\">Click Links</a></b> <font color=\"red\">$totalptc Links Available</font><br />
<menu>Click links and view websites to earn cash and points.</menu>
</fieldset><br />")."
".iif(SETTING_PTRA == true && $settings[ptraon] == 1,"
<fieldset><legend>Paid to Read ads</legend>
<li><b><a href=\"index.php?view=account&ac=ptra&".$url_variables."\">Read Ads</a></b> <font color=\"red\">$totalptra Ads Available</font><br />
<menu>Read advertisments and view websites for cash and points.</menu>
</fieldset><br />")."
".iif(SETTING_PTSU == true && $settings[ptsuon] == 1,"
<fieldset><legend>Paid to Signup</legend>
<li><b><a href=\"index.php?view=account&ac=ptsu&".$url_variables."\">Paid To Signup</a></b> <font color=\"red\">$totalptsu Signups Available</font><br />
<menu>Get paid to signup at websites!</menu>
</fieldset><br />")."
".iif(SETTING_CE == true && $settings[ce_on] == 1,"
<fieldset><legend>Click Exchange</legend>
<li><b><a href=\"gpt.php?v=entry&type=ce&s=1&".$url_variables."\" target=\"_blank\">Click Exchange</a></b> <font color=\"red\">$totalce Links Available</font><br />
<menu>The click exchange allows you to click for unique traffic rather than cash. When you click, you will receive a $settings[ce_ratio1]/$settings[ce_ratio2] ratio, meaning you will get $settings[ce_ratio2] unique hits for every $settings[ce_ratio1] links you click
</menu>
</fieldset><br />")."
".iif(SETTING_PTR == true && $settings[ptron]==1,"
<fieldset><legend>Paid to Read Email ads</legend><li><b><a href=\"index.php?view=account&ac=profile&".$url_variables."\">Read Emails</a></b><br />
<menu>Read emails and view websites for cash and points.<br />
View your profile to opt-in for receiving paid emails.</menu>
</fieldset><br />")."
".iif(SETTING_PTP == true && $settings[ptpon]==1,"
<fieldset><legend>Paid to Promote</legend><li><b><a href=\"index.php?view=account&ac=banners&".$url_variables."\">Promote $settings[site_title]</a></b><br />
<menu>Promote the site and get paid $settings[currency]$settings[ptpamount] for each unique visitor that views your referral URL per 24 hours. <a href=\"index.php?view=memberships&".$url_variables."\">Premium Members Earn More!</a>
</menu>
</fieldset><br />")."
<fieldset><legend>Earn More</legend>
<li><b><a href=\"index.php?view=account&ac=banners&".$url_variables."\">Upgrade & Refer Members</a></b><br />
<menu>When you are an upgraded member, you get cash bonuses whenever any of your direct referrals purchase an item from our site, upgrade, or just earn money themselves. Upgrade today and have others work for you!</menu>
</fieldset><br />
</dl>
";
?>Bu sorunu nasıl çözebilirim?
