i used this code
in list.php
PHP Code:
//////////////////////////////////Reffreal Users
else if($action=="refeared")
{
addonline(getuid_sid($sid),"Viewing Reffreared Users","lists.php?action=$action");
getshouts($sid);
boxstart("Reffreared Users");
//////ALL LISTS SCRIPT <<
$who = $_GET["who"];
$whoinfo = getnick_uid($who);
if($page=="" || $page<=0)$page=1;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users WHERE invites='".$whoinfo."'"));
$num_items = $noi[0]; //changable
$items_per_page= 10;
$num_pages = ceil($num_items/$items_per_page);
if(($page>$num_pages)&&$page!=1)$page= $num_pages;
$limit_start = ($page-1)*$items_per_page;
//changable sql
$sql = "SELECT id, name, regdate FROM ibwf_users WHERE invites='".$whoinfo."' ORDER BY name LIMIT $limit_start, $items_per_page";
echo "<p>";
$items = mysql_query($sql);
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$lnk = "<a href=\"index.php?action=viewuser&who=$item[0]&sid=$sid\">$item[1]</a>";
$jdt = date("d m y-H:i:s",$item[2]);
echo "$lnk - $jdt<br/>";
}
}
echo "</p>";
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"lists.php?action=refeared&page=$ppage&sid=$sid&view=$view\">«Prev</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"lists.php?action=refeared&page=$npage&sid=$sid&view=$view\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "Jump to page<form action=\"lists.php\" method=\"get\"><input id=\"inputText\" name=\"page\" format=\"*N\" size=\"3\"/>";
$rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
$rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";
$rets .= "<input id=\"inputButton\" type=\"submit\" value=\"Go\"/></form>";
echo $rets;
}
echo "</p>";
echo "<p align=\"center\">Use Your referal link to invite friends and increase your Referal Points.<br/>
<a href=\"index.php?action=stats&sid=$sid\">
Site Stats</a><br/>
</p>";
}
Code:
function register($name,$pass,$usex,$bday,$uloc,$rname,$ms,$email,$refer){
$execms = mysql_query("SELECT * FROM ibwf_users WHERE name='".$name."';");
if (mysql_num_rows($execms)>0){
return 1;
}else{
$pass = md5(strtolower($pass));
$reg = mysql_query("INSERT INTO ibwf_users SET name='".$name."', pass='".$pass."', birthday='".$bday."', sex='".$usex."', location='".$uloc."', regdate='".time()."',
email='".$email."', rname='".$rname."', ms='".$ms."' ");
}
if ($reg){
$uid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users WHERE name='".$name."'"));
$msg = "LoveForum welcomes you! We are committed to provide you with unique services, like multimedia messaging, Free Downloading, Free gprs Tricks, Making New Friends and lots of other various tools for you to have
fun. We know that you come to WAP after getting time from your busy schedule so we are always ready hear to provide you a friendly and fun filled environment to ease your tensions. For any queries please ask any member of Administration Team. Thanks![br/][small][i]Note: This is an automatically generated message, please do not reply.[/i][/small]";
$msg = mysql_escape_string($msg);
autopm($msg, $uid[0]);
if (("$refer"=="$name") and (strlen($refer))>1){
}else{
$referid = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users WHERE name='".$refer."'"));
$ugpl = mysql_fetch_array(mysql_query("SELECT plusses FROM ibwf_users WHERE id='".$referid[0]."'"));
$inv = mysql_fetch_array(mysql_query("SELECT invites FROM ibwf_users WHERE id='".$referid[0]."'"));
$ugpl = $ugpl[0] + 50;
$inv = $inv[0] + 1;
mysql_query("UPDATE ibwf_users SET plusses='".$ugpl."' WHERE id='".$referid[0]."'");
mysql_query("UPDATE ibwf_users SET invites='".$inv."' WHERE id='".$referid[0]."'");
$msg1 = "$refer Refered $name";
$msg1 = mysql_escape_string($msg1);
autopm($msg1, "1");
$uid2 = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users WHERE name='".$refer."'"));
$msg2 = "[b]NOTIFICATION:[/b][br/]Congratulations! you have got 50 plusses for invite to $name in LoveForum. Thankx for help to LoveForum. :)[br/][small][i]p.s: this is an automated pm[/i][/small]";
$msg2 = mysql_escape_string($msg2);
autopm($msg2, $uid2[0]);
}
return 0;
}else{
return 2;
}
}
Leave a comment: