Forum PHP Romania - Discutii despre PHP, MySQL, Javascript, AJAX, etc

[Quber]

Sunt cam incepator in Ajax shi asha vrea sami fac Shoutboxul meu sa fie in Ajax ma poate ajuta cinea??

Am urmatorl cod in index.php:

Cod: <? begin_frame("ShoutBox",true,5); ?>


<iframe src='shoutbox.php' width='100%' height='300' frameborder='0' name='sbox' marginwidth='0' marginheight='0' scrolling=auto class=frame></iframe><br><br>

<form name=SBFORM action='shoutbox.php' id=SBFORM method='get' target='sbox' onSubmit='javascript:if(mySubmit()) return false;'><input type='hidden' name='shbox_text' id='shbox_text' value='yes'><input type='hidden' name='sent' value='yes'>
<center>Message: <input type='text' maxlength=300 name='shbox_edit' id='shbox_edit' size='100'> &nbsp;<input type='submit' value='Post it'>&nbsp;&nbsp;<a class=button height="300px" href='./shoutbox.php' target='sbox'>&nbsp;Refresh&nbsp;</a></center></form>

<br /><br />
<center><a href="javascript: SmileIT(':-)','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/smile1.gif></a>
<a href="javascript: SmileIT(':smile:','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/smile2.gif></a>
<a href="javascript: SmileIT(':-D','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/grin.gif></a>
<a href="javascript: SmileIT(':evo:','SBFORM','shbox_edit')"><img src=pic/smilies/evo.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':-|','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/noexpression.gif></a>
<a href="javascript: SmileIT(':-/','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/confused.gif></a>
<a href="javascript: SmileIT(':-(','SBFORM','shbox_edit')"><img border=0 src=pic/smilies/sad.gif></a>
<a href="javascript: SmileIT(':weep:','SBFORM','shbox_edit')"><img src=pic/smilies/weep.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':-O','SBFORM','shbox_edit')"><img src=pic/smilies/ohmy.gif border=0></a>
<a href="javascript: SmileIT('8-)','SBFORM','shbox_edit')"><img src=pic/smilies/cool1.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':yawn:','SBFORM','shbox_edit')"><img src=pic/smilies/yawn.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':sly:','SBFORM','shbox_edit')"><img src=pic/smilies/sly.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':greedy:','SBFORM','shbox_edit')"><img src=pic/smilies/greedy.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':weirdo:','SBFORM','shbox_edit')"><img src=pic/smilies/weirdo.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':sneaky:','SBFORM','shbox_edit')"><img src=pic/smilies/sneaky.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':kiss:','SBFORM','shbox_edit')"><img src=pic/smilies/kiss.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':geek:','SBFORM','shbox_edit')"><img src=pic/smilies/geek.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':evil:','SBFORM','shbox_edit')"><img src=pic/smilies/evil.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':yucky:','SBFORM','shbox_edit')"><img src=pic/smilies/yucky.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':shit:','SBFORM','shbox_edit')"><img src=pic/smilies/shit.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':?:','SBFORM','shbox_edit')"><img src=pic/smilies/question.gif width="18" height="18" border=0></a>
<a href="javascript: SmileIT(':!:','SBFORM','shbox_edit')"><img src=pic/smilies/idea.gif width="18" height="18" border=0></a> <a href="javascript:winop()" class=button>&nbsp; Add Smiles &nbsp;</a></center>
</td></form>
<?//end_frame();
?>
      </td></tr>
      </table>
            </td>
        </tr>
         <tr>
            <td class="row2" align="center"><span class="genmed"><a href="#" class="genmed">Back to top</a></span></td>
         </tr>
      </table>
      <table border="0" cellpadding="0" cellspacing="0" class="tbl"><tr><td class="tbll"><img src="./phpBB2/images/spacer.gif" alt="" width="8" height="4" /></td><td class="tblbot"><img src="./phpBB2/images/spacer.gif" alt="" width="8" height="4" /></td><td class="tblr"><img src="./phpBB2/images/spacer.gif" alt="" width="8" height="4" /></td></tr></table>
         </td>
         </tr>
      </table>

Shi am shi failut Shoutbox.php:


Cod: <?
/*****************************

Hannes' ShoutBox v1.0

*****************************/

require_once("include/bittorrent.php");
dbconn(false);

loggedinorreturn();

if ($CURUSER)
{
///////////session/////////////////
mysql_query("UPDATE users SET page=1 WHERE id = " . $CURUSER["id"]) or sqlerr(__FILE__,__LINE__);
///////////////////////////////////
} 

if ($CURUSER["schoutboxpos"] == 'no')
{
echo '<table class=main align=center width=400 border=0 cellpadding=0 cellspacing=0><tr><td align=center class=embedded>
</br><h1>Sorry</h1><table width=300px border=1 cellspacing=0 cellpadding=10><tr><td class=text align=center>Yo are BAN from Shoutbox .</td></tr></table></td></tr></table>';

exit;
}


//deleting messages

if (isset($_GET['del']))
{
if (is_numeric($_GET['del']))
{
$query = "SELECT * FROM shoutbox WHERE id=".$_GET['del'];
$result = mysql_query($query);
}
else {echo "invalid msg id STOP TRYING TO INJECT SQL TIT HEAD";exit;
}

$row = mysql_fetch_row($result);

if ( (get_user_class() >= UC_MODERATOR) )
{
$query = "DELETE FROM shoutbox WHERE id=".$_GET['del'];
mysql_query($query);
}
}
// EDIT SHOUT ?
if (isset($_GET['edit']) && get_user_class() >= UC_MODERATOR && is_valid_id($_GET['edit']))
{   
   $sql=sql_query("SELECT id,text FROM shoutbox WHERE id=".sqlesc($_GET['edit']));
   $res=mysql_fetch_array($sql);
   ?>
   <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
   <html xmlns="http://www.w3.org/1999/xhtml">
   <meta http-equiv="Pragma" content="no-cache">
   <meta http-equiv="expires" content="0">
   <head profile="http://gmpg.org/xfn/11">
   <meta http-equiv="Content-Type" content="text/html; charset=windows-1251" />
   <script src="java_klappe.js"></script>
   <style type="text/css">
   #specialbox{
   border: 1px solid gray;
   width: 600px;
   background: #F7F7F7;
   font: 10pt tahoma, verdana, sans-serif;
   color: #443;
   padding: 3px;   outline: none;
   }

   #specialbox:focus{
   border: 1px solid black;
   }
   .btn {
   cursor:pointer;
   border:outset 1px #ccc;
   background:#999;
   color:#666;
   font-weight:bold;
   padding: 1px 2px;
   background:url(pic/formbg.gif) repeat-x left top;
   }   
   BODY {
   background-color: #FDF3DA;
   SCROLLBAR-3DLIGHT-COLOR: #004E98;
   SCROLLBAR-ARROW-COLOR: #004E98;
   SCROLLBAR-DARKSHADOW-COLOR: white;
   SCROLLBAR-BASE-COLOR: white;
   }
</STYLE>

   </style>
   </head>
   <body bgcolor=#F5F4EA>
   <?php
   echo '<form method=post action=shoutbox.php>';
   echo '<input type=hidden name=id value='.(int)$res['id'].'>';
   echo '<textarea name=text rows=3 id=specialbox>'.htmlspecialchars($res['text']).'</textarea>';
   echo '<input type=submit name=save value=save class=btn>';
   echo '</form></body></html>';
   die;
}
// UPDATE SHOUT?
if (isset($_POST['text']) && get_user_class() >= UC_MODERATOR && is_valid_id($_POST['id']))
{
   $text = trim($_POST['text']);
   $id = (int)$_POST['id'];
   if (isset($text) && isset($id) && is_valid_id($id))
      sql_query("UPDATE shoutbox SET text = ".sqlesc($text)." WHERE id=".sqlesc($id));
}

?>
<html><head>
<title>ShoutBox</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<META HTTP-EQUIV=REFRESH CONTENT="1000; URL=shoutbox.php">
<style type="text/css">
   BODY {
   background-color: #f7f7f7;
   SCROLLBAR-3DLIGHT-COLOR: #004E98;
   SCROLLBAR-ARROW-COLOR: #004E98;
   SCROLLBAR-DARKSHADOW-COLOR: white;
   SCROLLBAR-BASE-COLOR: white;
   }
A {
   color: #000000;
   font-weight: bold;
}
A:hover {
   color: #FF0000;
}
.small {
   font-size: 8pt;
   font-family: tahoma;
}
.date {
   font-size: 8pt;
   font-family: tahoma;
}

a.agreen, a.agreen:hover, a.agreen:link, a.agreen:visited {
   font-weight: normal;
   color: #ff0000;
   font-size: 10pt;
   font-family: tahoma;
   text-decoration: none;
}

</style>
</head>
<body>
<?

/*
if ($CURUSER["chatpost"] == 'no')
{
print("<h2><br><center>You are banned.</center></h2>");
exit;
}
else
{
*/

//print "$da<center><font color=#ff0000><b>Паздравлеаем с днём раждения: </font>";
//print("<a class=\"altlink_green\" href=userdetails.php?id=$id><b>$username, </b></a>");
//print("<table border=0 cellspacing=0 cellpadding=2 width='90%' align='left' valign=top class='small'>\n");
//print "<td align=center class=row2 align=center>";

$b = 0;
//print("<br><font class=small>Today's Birthdays<br>");
echo "<tr><td class=\"colhead\">";

$currentdate = date("Y-m-d", time() + $CURUSER['tzoffset'] * 60);

$ziu .= "<center><font color=#ff0000>Felicitam cu ziua de nastere pe: </font>";

list($year1, $month1, $day1) = split('-', $currentdate);
$res2 = mysql_query("SELECT birthday, id, username FROM users WHERE birthday != '0000-00-00'") or sqlerr();
while ($arr2 = mysql_fetch_assoc($res2))
{
$birthday = date($arr2["birthday"]);
$username = $arr2["username"];
$id = $arr2["id"];
list($year2, $month2, $day2) = split('-', $birthday);
if (($month1 == $month2) && ($day1 == $day2))
{
if ($b > 0)
//print(", ");
echo "</td></tr>";
//print("<a class=\"altlink_green\" href=userdetails.php?id=$id>$username, </b></a></center");

$ziu .= "<a alt=Private href=# onClick=\"javascript:parent.msgToUser('$username');return false;\"><img src=pic/msgtored.jpg border=0></a><a class=agreen href=userdetails.php?id=$id target=Blanck_> $username, </a>";

$b = $b + 1;
}
}

//if ($ziu == "0") {
if ($b == 0) {
} else {
print "$ziu";
}
print "</center>";
//print("</font>");

if($_GET["sent"]=="yes")
{
$userid=$CURUSER["id"];
$username=$CURUSER["username"];
$date=time();
$text=trim($_GET["shbox_text"]);

if (empty($text))
{

}
else {
       
mysql_query("INSERT INTO shoutbox (id, userid, username, date, text) VALUES ('id'," . sqlesc($userid) . ", " . sqlesc($username) . ", $date, " . sqlesc($text) . ")") or sqlerr(__FILE__, __LINE__);
}
}

$res = mysql_query("SELECT * FROM shoutbox ORDER BY date DESC LIMIT 35") or sqlerr(__FILE__, __LINE__);
if (mysql_num_rows($res) == 0)
print("\n");
else
{
print("<table border=0 cellspacing=0 cellpadding=2 width='88%' align='left' valign=top class='small'>\n");


while ($arr = mysql_fetch_assoc($res))
{
$res2 = mysql_query("SELECT username,class,avatar,donor, title,enabled,warned, gender FROM users WHERE id=$arr[userid]") or sqlerr(__FILE__, __LINE__);
$arr2 = mysql_fetch_assoc($res2);
$resowner = mysql_query("SELECT id, username, class, gender FROM users WHERE id=$arr[userid]") or print(mysql_error());
$rowowner = mysql_fetch_array($resowner);








if ($rowowner["class"] == "96") {
if ($rowowner["username"] == "Quber" || $rowowner["username"] == "VAsioK" ){
$usercolor= "<font color=#1919aa>" .htmlspecialchars($rowowner["username"])."</font>";
$format_comment= "<font color=#1919aa>" .format_comment($arr["text"]). "</font>";
}
 else
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
$usercolor= "<font color=#990099>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#990099>" .format_comment($arr["text"]). "</font>";
}
}


elseif ($rowowner["class"] == "80") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "80") {
$usercolor= "<font color=#ff0000>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#ff0000>" .format_comment($arr["text"]). "</font>";
}
}
}
elseif ($rowowner["class"] == "64") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "64") {
$usercolor= "<font color=#009F00>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#009F00>" .format_comment($arr["text"]). "</font>";
}
}
}
elseif ($rowowner["class"] == "48") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "48") {
$usercolor= "<font color=#3366ff>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#3366ff>" .format_comment($arr["text"]). "</font>";
}
}
}
elseif ($rowowner["class"] == "32") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "32") {
$usercolor= "<font color=#2587A7>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#2587A7>" .format_comment($arr["text"]). "</font>";
}
}
}
elseif ($rowowner["class"] == "16") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "16") {
$usercolor= "<font color=#f9a200>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#000000>" .format_comment($arr["text"]). "</font>";
}
}
}
elseif ($rowowner["class"] == "0") {
if ($rowowner["gender"] == "Female") {
$usercolor= "<font color=#fa3d96>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#fa3d96>" .format_comment($arr["text"]). "</font>";
} else {
if ($rowowner["class"] == "0") {
$usercolor= "<font color=#000000>" .htmlspecialchars($rowowner["username"]). "</font>";
$format_comment= "<font color=#000000>" .format_comment($arr["text"]). "</font>";
}
}
}

$username = $rowowner["username"];


$format_comment = str_replace("[$CURUSER[username]]","<font color=#000000>{</font><b style='color: red; background: #FFFFFF;'>$CURUSER[username]</b><font color=#000000>}</font>",$format_comment);

$format_comment = preg_replace("/\[((\s|.)+?)\]/", "<font color=#000000>[</font><b style='color: black;'>\\1</b><font color=#000000>]</font>", $format_comment);

if (get_user_class() >= UC_MODERATOR) {
$del="[<a href=./shoutbox.php?del=".$arr[id].">X</a>]";
$edit="<span class='date'>[<a href=shoutbox.php?edit=".$arr[id].">E</a>]</span>\n";
}
//$pm = "<span class='date'>[<a target=_blank href=sendmessage.php?receiver=$arr[userid]>pm</a>]</span>\n";

print("<tr><td><font color=gray>|<span class='date'>".strftime("%H:%M",$arr["date"])."|</font>
$del$edit$pm <a href='userdetails.php?id=".$arr["userid"]."' target='_blank'>

</span>
<a alt=Private href=# onClick=\"javascript:parent.msgToUser('$username');return false;\"><img src=pic/msgtored.jpg border=0></a>
<a href=userdetails.php?id=".$arr["userid"]." target=_blank>$usercolor</a>" .
($arr2["donor"] == "yes" ? "<img src=pic/star.gif alt='DONOR'>" : "") .
($arr2["warned"] == "yes" ? "<img src="."/pic/warned.gif alt='Warned'>" : "") . "   
 
 
$format_comment


</td>\n");

}


print("<table border=0 cellspacing=0 cellpadding=2 align='left' valign=top class='small'><td valign=top>\n");


$sql = "SELECT * FROM users WHERE page='1'";
$sqls = mysql_query($sql) or print(mysql_error());
while($ssq = mysql_fetch_array($sqls)) {
   //aici afisezi dated e la useri care au selectat coloana 4 exemplu
   $username4 = $ssq['username'];
   $id4 = $ssq['id'];
   
   echo "<a alt=Private href=# onClick=\"javascript:parent.msgToUser('$username4');return false;\"><img src=pic/msgtored.jpg border=0></a> <a href=userdetails.php?id=$id4 target=_blank>$username4</a></br>";

}
print("</td></table>\n");

print("\n");
}

print("</tr></table>");





//" .($arr2["donor"] == "yes" ? "<img src="."pic/star.gif alt='DONOR'>" : "") .
//($arr2["class"] == "96" ? "<img src="."pic/sysop_icon.gif alt='SYSOP'>" : "") .
//($arr2["class"] == "80" ? "<img src="."pic/admin_icon.gif alt='ADMIN'>" : "") .
//($arr2["class"] == "64" ? "<img src="."pic/mod_icon.gif alt='MODERATOR'>" : "") .
//($arr2["class"] == "48" ? "<img src="."pic/uploader_icon.gif alt='UPLOADER'>" : "") .
//($arr2["class"] == "32" ? "<img src="."pic/vip_icon.gif alt='VIP'>" : "") .
//($arr2["class"] == "16" ? "<img src="."pic/power_user_icon.gif alt='POWER USER'>" : "") .
//($arr2["class"] == "0" ? "<img src="."pic/user_icon.gif alt='USER'>" : "") .
//($arr2["warned"] == "yes" ? "<img src="."pic/warned.gif alt='Warned'>" : "") . "


?>
</body>
</html>

Cine ma ajuta sal transform in ajax va rog mult...!!!

[carco]

draq te ajuta! cine crezi ca sta sa citeasca codu' ala?

[Quber]

Datimi plssd dara un chat in ajax care sa fie din 2 pagini idic index.php shi shoutbox.php cu MySQL va rog MULT!!!

[anonim.20CM]

uite aici
Cod: http://www.plasticshore.com/logfile/entry/legacy_483/

[Weedkid]

593 de linii.. nici nu ai pretentii

chat in ajax: www.justfuckinggoogleit.com

[olopolo]

Can anyone have this icons ?

Cod:
pic/star.gif
pic/sysop_icon.gif
pic/admin_icon.gif
pic/mod_icon.gif
pic/uploader_icon.gif
pic/vip_icon.gif
pic/power_user_icon.gif
pic/user_icon.gif
pic/warned.gif

[PHPRomania Bot]