Pozdrav! Drug me preporucio na ovaj forum
. Inace nisam bio zainteresovan za PHP, jer sam mislio da je HTML dovoljan
, ali mi je iskrsnuo ovaj problem sa skriptom pa sam poceo da proucavam PHP. Medjutim ovaj problem je previse za mene.
Na svom paid to click sajtu imam paid to sign up offers. Ovakav je princip: Ja postavim link preko kojega se useri trebaju registrovati na nekom sajtu a nakon toga klikni na complete. Tada ja kao admin mogu da vidim svakog ko je kliknuo na completed, i tu imam dvije opcije: Approve i Deny. Kada kliknem na Approve pise mi:
Thank you. The user has been credited and this item has been removed from your pending offers.
Ali problem je u tome sto $ ne doda na account od usera koji je izvrsio offer i ne doda mu +1 u polje
Offers Completed nego doda $0,015 na Admin account. U admin panelu imam sve za podesavanje cijene po kliku i ostalih zafrkanija, ali cijene za completed offer nema ni u ljeljama.
Evo sources za stranice koje imaju veze sa ovim offersima:
Offers.php - na ovoj stranici su izlistane ponude za paid to signup, url, description i button COMPLETED.
Kôd:
<? session_start(); ?>
<? include('header.php');
require('config.php');
$sql = "SELECT * FROM site";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
mysql_close($con);
$enableoffers = $row['enableoffers'];
if($enableoffers == "yes") {
?>
<!-- Pagetitle -->
<br><h3>Complete offers</h3>
<font color=green>To complete an offer click on the link provided next to the requirements and complete off the requirements listed, once completed come back and click the "Complete" button. You will get <b>0,10$</b> for every successful signup!</font>
<br>
<STYLE TYPE="text/css"><!--
.Style0 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(172,168,153); background-color: rgb(255,255,255)}
.Style1 { border-style: solid; padding:3; border-left-width: 1; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-color: rgb(157,157,161); border-top-color: rgb(157,157,161); border-right-color: rgb(157,157,161); border-bottom-color: rgb(157,157,161); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(224,223,227)}
.Style2 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
.Style3 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
.Style4 { border-style: solid;padding:0px; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 1pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
--></STYLE>
<TABLE class=maintable BORDER=0 CELLSPACING=0 WIDTH=819>
<TR>
<TD WIDTH=170 HEIGHT=0></TD>
<TD WIDTH=60 HEIGHT=0></TD>
<TD WIDTH=25 HEIGHT=0></TD>
</TR>
<TR>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Offer Description</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Website</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Complete</TD>
</TR>
<?
include("config.php");
$user=$_COOKIE["usNick"];
$sql = "SELECT * FROM offerads";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$id = $row["id"];
$ad_query = mysql_query("SELECT id FROM offerads WHERE id='$id' AND tipo='offers' AND CONVERT(signups,UNSIGNED) < CONVERT(plan,UNSIGNED)") or die(mysql_error());
if (mysql_num_rows($ad_query)<1) {
}else{
$ad_query = mysql_query("SELECT offerid FROM pendingoffers WHERE user='$user'") or die(mysql_error());
if (mysql_num_rows($ad_query)>0) {
}else{
$tabla = mysql_query("SELECT * FROM offerads WHERE user!='$user' ORDER BY id ASC");
while ($registro = mysql_fetch_array($tabla)) {
echo "<TR>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px>". $registro["description"] ."</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px><a href=\"". $registro["url"] ."/\" target=\"_blank\">". $registro["url"] ."</a></TD>";
?>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px><form method="post" action="completeoffer.php?id=<?= $registro["id"] ?>"><input type="hidden" value="<?= $registro["user"] ?>" class="text" name="owner"><input type="submit" value="Complete" class="button"></form></TD>
</TR>
<?
}
}
}
?>
</TABLE>
<?
}else{
echo "This feature is disabled.";
}
?>
<!--footer starts here-->
<? include('footer.php'); ?>
Penidingoffers.php - ovde vidim ko je kliknuo na COMPLETED i mogu da APPROVE ili DENY
Kôd:
<? session_start(); ?>
<? include('header.php');
require('config.php');
$sql = "SELECT * FROM site";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
mysql_close($con);
$enableoffers = $row['enableoffers'];
if($enableoffers == "yes") {
if(isset($_COOKIE["usNick"]) && isset($_COOKIE["usPass"]))
{
?>
<br><h3>My Pending offers</h3>
<font color=green>To complete an offer click on the link provided next to the requirements and complete off the requirements listed, once completed come back and click the "Complete" button.</font>
<br>
<STYLE TYPE="text/css"><!--
.Style0 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(172,168,153); background-color: rgb(255,255,255)}
.Style1 { border-style: solid; padding:3; border-left-width: 1; border-top-width: 1; border-right-width: 1; border-bottom-width: 1; border-left-color: rgb(157,157,161); border-top-color: rgb(157,157,161); border-right-color: rgb(157,157,161); border-bottom-color: rgb(157,157,161); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(224,223,227)}
.Style2 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
.Style3 { border-style: solid; padding:3; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 8pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
.Style4 { border-style: solid;padding:0px; border-left-width: 0; border-top-width: 0; border-right-width: 0; border-bottom-width: 0; border-left-color: rgb(0,0,0); border-top-color: rgb(0,0,0); border-right-color: rgb(0,0,0); border-bottom-color: rgb(0,0,0); font-family: 'Tahoma'; mso-font-charset: 1; font-size: 1pt; color: rgb(0,0,0); background-color: rgb(255,255,255)}
--></STYLE>
<TABLE BORDER=0 CELLSPACING=0 WIDTH=819>
<TR>
<TD WIDTH=60 HEIGHT=0></TD>
<TD WIDTH=60 HEIGHT=0></TD>
<TD WIDTH=60 HEIGHT=0></TD>
<TD WIDTH=25 HEIGHT=0></TD>
<TD WIDTH=25 HEIGHT=0></TD>
</TR>
<TR>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Username</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Email Address</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Date Completed</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Approve Offer</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style1 HEIGHT=0px>Deny Offer</TD>
</TR>
<?
include("config.php");
$owner=$_COOKIE["usNick"];
$tabla = mysql_query("SELECT * FROM pendingoffers WHERE owner='$owner' ORDER BY id ASC");
while ($registro = mysql_fetch_array($tabla)) {
echo "<TR>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px>". $registro["user"] ."</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px>". $registro["email"] ."</TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px>". $registro["date"] ."</TD>";
?>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px><form method="post" action="approveoffer.php?id=<?= $registro["id"] ?>"><input type="hidden" value="<?= $registro["offerid"] ?>" class="text" name="offerid"><input type="hidden" value="<?= $registro["user"] ?>" class="text" name="user"><input type="submit" value="Approve" class="button"></form></TD>
<TD NOWRAP ALIGN=LEFT CLASS=Style2 HEIGHT=0px><form method="post" action="denyoffer.php?id=<?= $registro["id"] ?>"><input type="hidden" value="<?= $registro["user"] ?>" class="text" name="user"><input type="submit" value="Deny" class="button"></form></TD>
</TR>
<?
}
?>
</TABLE>
<?
}
else
{
dologin();
}
}else{
echo "This feature is disabled.";
}
include('footer.php'); ?>
Aproveoffers.php - ovde redirektuje nakon sto kliknem APPROVE
Kôd:
<? include('header.php'); ?>
<!-- Pagetitle -->
<?
require('config.php');
$sql = "SELECT * FROM site";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
mysql_close($con);
$enableoffers = $row['enableoffers'];
if($enableoffers == "yes") {
?>
<br><h3>My Pending offers</h3>
<?
$id=$_GET["id"];
$offerid=$_POST["offerid"];
$email=$_POST["email"];
require ("config.php");
$sqlue = "SELECT * FROM users WHERE email='$email'";
$resultue = mysql_query($sqlue);
$rowue = mysql_fetch_array($resultue);
$newbalance=$rowue["money"] + 0.01;
$newcompletedoffers=$rowue["completedoffers"] + 1;
require ("config.php");
// loading click configuration
foreach(array('click','referalclick','premiumclick','premiumreferalc') as $item) {
$query = mysql_query("SELECT price FROM config WHERE item='$item' AND howmany='1'") or die(mysql_error());
$row = mysql_fetch_row($query);
${$item} = $row[0];
}
mysql_query("UPDATE users SET money = money + IF(account='premium',$premiumclick,$click), completedoffers = CONVERT(completedoffers,UNSIGNED) + 1 WHERE username='$user'") or die(mysql_error());
mysql_query("UPDATE offerads SET signups = CONVERT(signups,UNSIGNED) + 1 WHERE id='$offerid'") or die(mysql_error());
require ("config.php");
$queryz = "DELETE FROM pendingoffers WHERE id='$id'";
mysql_query($queryz) or die(mysql_error());
?>
<p>Thank you. The user has been credited and this item has been removed from your pending offers.<br><br><a href="pendingoffers.php">Go Back To Your Pending Offers</a></p>
<?
}else{
echo "This feature is disabled.";
}
include('footer.php'); ?>
Sto se tice Mysql-a u njemu imam tabelu "users" u kojoj se nalaze podaci usera: email, ime, prezime, koliko su zaradili(row money)... i tabelu pendingoffers u kojem su rowsi: id, offerid, user, owner, status, date, email.
Eto nadam se da ce neko bar pogledati ovo iako sam tek ovako uletio
. Odoh da citam forum sada. Hvala unaprijed!