else if($action=="lst10tpc")
{
addonline(getuid_sid($sid),"Jaunākās Foruma Tēmas","");
echo "<card id=\"main\" title=\"Newest Topics\">";
$sql = "SELECT name, crdate, authorid FROM ibwf_topics ORDER BY crdate DESC LIMIT 0 , 10";
echo "<p>";
echo "<small>";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$niks = getnick_uid($item[3]);
echo "$niks:<a href=\"index.php?action=viewtpc&sid=$sid&tid=$item[0]&go=last\">".htmlspecialchars($item[1])."</a><br/>";
}
}
echo "</small>";
echo "</p>";
echo "<p align=\"center\">";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"\"/>Hme</a>";
echo "</p>";
echo "</card>";
}
else if($action=="mycombl")
{
addonline(getuid_sid($sid),"Viewing Blogs","");
echo "<card id=\"main\" title=\"wapaa.lv\">";
$uid = getuid_sid($sid);
echo "<p align=\"center\">";
echo "<b>Blogs with my comments</b><br/><br/>";
echo "</p>";
//////ALL LISTS SCRIPT <<
if($page=="" || $page<=0)$page=1;
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_blogs a INNER JOIN ibwf_blogcomment b ON b.blogsigner='".$uid."' WHERE a.id=b.blogowner"));
$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;
$sql = "SELECT a.id,a.bname AS bl FROM ibwf_blogs a INNER JOIN ibwf_blogcomment b ON b.blogsigner='".$uid."' WHERE a.id=b.blogowner ORDER BY bgdate DESC LIMIT $limit_start, $items_per_page";
echo "<p>";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$bname = htmlspecialchars($item[1]);
$lnk = "» <a href=\"index.php?action=viewblog&bid=$item[0]&sid=$sid\">$bname</a>";
echo "$lnk<br/>";
}
}
echo "</p>";
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"lists.php?action=$action&page=$ppage&sid=$sid&who=$who\">«Previous</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"lists.php?action=$action&page=$npage&sid=$sid&who=$who\">next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
if($num_pages>2)
{
$rets = "Jump to <input name=\"pg\" format=\"*N\" size=\"3\"/>";
$rets .= "<anchor> Page";
$rets .= "<go href=\"lists.php\" method=\"get\">";
$rets .= "<postfield name=\"action\" value=\"$action\"/>";
$rets .= "<postfield name=\"who\" value=\"$who\"/>";
$rets .= "<postfield name=\"sid\" value=\"$sid\"/>";
$rets .= "<postfield name=\"page\" value=\"$(pg)\"/>";
$rets .= "</go></anchor>";
echo $rets;
}
echo "</p>";
////// UNTILL HERE >>
echo "<p align=\"center\">";
echo "<a href=\"lists.php?action=allbl&sid=$sid\">";
echo "All blogs</a><br/>";
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"images/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p>";
echo "</card>";
}
/* I don't know everything hehe */
$res = false;
$ext = getext($vlink);
if ($ext=="mp3" or $ext=="mmf" or $ext=="amr" or $ext=="wav" or $ext=="aac" or $ext=="mid")
{
$type = 1;
}
if ($ext=="jpg" or $ext=="jpeg" or $ext=="gif" or $ext=="png" or $ext=="bmp" or $ext=="wbmp")
{
$type = 2;
}
if ($ext=="mpg" or $ext=="mp4" or $ext=="wmv" or $ext=="3gp" or $ext=="avi" or $ext=="flv")
{
$type = 3;
}
if ($ext=="jar" or $ext=="jad")
{
$type = 4;
}
if ($ext=="sis" or $ext=="sisx" or $ext=="nth")
{
$type = 5;
}
if ($ext=="cab" or $ext=="exe" or $ext=="iso")
{
$type = 6;
}
if ($ext=="zip" or $ext=="rar" or $ext=="txt" or $ext=="srt" or $ext=="sub" or $ext=="torrent")
{
$type = 7;
}
$res = false;
$ext = getext($vlink);
if ($ext=="mp3" or $ext=="mmf" or $ext=="amr" or $ext=="wav" or $ext=="aac" or $ext=="mid")
{
$type = 1;
}elseif ($ext=="jpg" or $ext=="jpeg" or $ext=="gif" or $ext=="png" or $ext=="bmp" or $ext=="wbmp")
{
$type = 2;
}elseif ($ext=="mpg" or $ext=="mp4" or $ext=="wmv" or $ext=="3gp" or $ext=="avi" or $ext=="flv")
{
$type = 3;
}elseif ($ext=="jar" or $ext=="jad")
{
$type = 4;
}elseif ($ext=="sis" or $ext=="sisx" or $ext=="nth")
{
$type = 5;
}elseif ($ext=="cab" or $ext=="exe" or $ext=="iso")
{
$type = 6;
}elseif ($ext=="zip" or $ext=="rar" or $ext=="txt" or $ext=="srt" or $ext=="sub" or $ext=="torrent")
{
$type = 7;
}else{
echo "Error,invalid extension";
}
echo "<a href=\"ownrproc.php?action=REMOVEPNREASON&sid=$sid&who=$who\">REMOVE LAST PENALTY REASON</a><br/>";
//////////////////////////remove pn reason//////////////////////////
else if($action=="REMOVEPNREASON")
{
$who = $_GET["who"];
echo "<head>";
echo "<title></title>";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"../themes/$theme[0]\">";
echo "</head>";
echo "<body>";
echo "<p align=\"center\">";
echo "<br/>";
$res = mysql_query("UPDATE ibwf_users SET lastpnreas='"."' WHERE id='".$who."'");
if($res)
{
echo "<img src=\"../images/ok.gif\" alt=\"\"/>last penalty reason is removed from user's profile";
}else{
echo "<img src=\"../images/notok.gif\" alt=\"\"/>Error! ";
}
echo "<br/><b></b><a accesskey=\"9\" href=\"ownercp.php?action=ownercp&sid=$sid\"><img src=\"../images/admn.gif\" alt=\"\"/>back</a><br/>";
echo "<b></b><a accesskey=\"0\" href=\"index.php?action=main&sid=$sid\">Home</a>";
echo "</p></body>";
}
////////////////////////////
$sql = "SELECT a.id,a.bname AS bl FROM ibwf_blogs a INNER JOIN ibwf_blogcomment b ON b.blogsigner='".$uid."' WHERE a.id=b.blogowner ORDER BY bgdate DESC LIMIT $limit_start, $items_per_page";
$sql = "SELECT a.id,a.bname AS bl FROM ibwf_blogs a INNER JOIN ibwf_blogcomment b ON b.blogsigner='".$uid."' WHERE a.id=b.blogowner ORDER BY bgdate DESC LIMIT $limit_start, $items_per_page GROUP BY a.id";
else if($action=="rwidc")
{
addonline(getuid_sid($sid),"$stitle ID - xHTML","index.php?action=$action");
$pstyle = gettheme($sid);
echo xhtmlhead("$stitle ID",$pstyle);
echo "<p align=\"center\">";
echo "<b>M! ID card</b><br/>";
$uid = getuid_sid($sid);
echo "<img src=\"http://chat.waplive.co.za/rwidc.php?id=$uid\" alt=\"M id\"/><br/><br/>";
echo "This ID card is updated automatically everytime someone request it, the source to your card is http://chat.waplive.co.za/rwidc.php?id=$uid<br/><br/>";
echo "you can use it as an avatar in other sites<br/><br/>";
echo "To look at others cards view the user profile then go to more information>$stitle ID card.";
echo "</p>";
echo "<p align=\"center\">";
$thid = mysql_fetch_array(mysql_query("SELECT themeid FROM ibwf_users WHERE id='".$uid."'"));
$themeimageset = mysql_fetch_array(mysql_query("SELECT themedir FROM ibwf_iconset WHERE id='".$thid[0]."'"));
echo "<a href=\"index.php?action=main&sid=$sid\"><img src=\"http://coding-talk.com/images/themes/$themeimageset[0]/home.gif\" alt=\"*\"/>";
echo "Home</a>";
echo "</p>";
echo xhtmlfoot();
}
LIMIT 1
ORDER BY RAND
i ended my chapel-deluxe at late..too tired..only now i see a little error $nick = getnick_uid($who); $nic = getnick_uid($uid); $msg = "-sorry.. $nick has divorced from you..";
$nick = getnick_uid($who); $nic = getnick_uid($uid); $msg = "-sorry.. $nic has divorced from you..";
else if($action=="marry")
{
addonline(getuid_sid($sid),"Wappied List","");
//////ALL LISTS SCRIPT <<
$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_chapel WHERE ismd='1'"));
if($page=="" || $page<=0)$page=1;
$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, mid, uid, mdy FROM ibwf_chapel WHERE ismd='1' ORDER BY mdy DESC LIMIT $limit_start, $items_per_page";
echo "<p>";
$items = mysql_query($sql);
echo mysql_error();
if(mysql_num_rows($items)>0)
{
while ($item = mysql_fetch_array($items))
{
$unick = getnick_uid($item[2]);
$wnick = getnick_uid($item[1]);
$lnk = "<a href=\"index.php?action=viewuser&who=$item[2]\">$unick </a><b>is Wappied To </b><a href=\"index.php?action=viewuser&who=$item[1]\">$wnick </a><br/>";
echo "$lnk<br/>";
}
}
echo "</p>";
echo "<p align=\"center\">";
if($page>1)
{
$ppage = $page-1;
echo "<a href=\"lists.php?action=marry&page=$ppage\">«PREV</a> ";
}
if($page<$num_pages)
{
$npage = $page+1;
echo "<a href=\"lists.php?action=marry&page=$npage\">Next»</a>";
}
echo "<br/>$page/$num_pages<br/>";
echo "</p>";
if($num_pages>2)
{
$rets = "<form action=\"lists.php\" method=\"get\">";
$rets .= "<input name=\"page\" style=\"-wap-input-format: '*N'\" size=\"2\"/>";
$rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
$rets .= "<input type=\"submit\" value=\"Go To Page\"/>";
$rets .= "</form>";
echo $rets;
}
////// UNTILL HERE >>
echo "<p align=\"center\">";
echo "<a href=\"chapel.php?action=main\">";
echo "Chapel</a><br/><br/>";
echo "<a href=\"index.php?action=stats\"><img src=\"http://coding-talk.com/images/stat.gif\" alt=\"*\"/>";
echo "Site Stats</a><br/>";
}
this code is good but don't works
Comment