[ ! ] مشكلة فى هاك الابتسامة فى عنوان الموضع يرت المساعدة
المشرف: alhitary
[ ! ] ????? ?? ??? ????????? ?? ????? ?????? ??? ????????
?????? ????? ?????
??? ??? ??? ????????? ? ????? ?????? ?? ???? ????? ???? ??? ??? ?? ???????? ???
?? ??????? ??? ????? ????? ????? ??????
????? ???? ???? ?? ?? ??? ???? ?? ??? ???? ?? ??? ???? ????? ??? ???
???? ??????? ???????? ???? ???? ????? ???? ???? ?????
?????? ??? ???? ??????? ???? ???? ?????
????? ?? ????? ??? ?? ???? ???????
??????? ???
http://samysoft.275mb.com/phpBB2
????? ???????
?? ???????? ?????
??? ??? ??? ????????? ? ????? ?????? ?? ???? ????? ???? ??? ??? ?? ???????? ???
?? ??????? ??? ????? ????? ????? ??????
????? ???? ???? ?? ?? ??? ???? ?? ??? ???? ?? ??? ???? ????? ??? ???
???? ??????? ???????? ???? ???? ????? ???? ???? ?????
?????? ??? ???? ??????? ???? ???? ?????
????? ?? ????? ??? ?? ???? ???????
??????? ???
http://samysoft.275mb.com/phpBB2
????? ???????
?? ???????? ?????
آخر تعديل بواسطة سامى سوفت في الأربعاء أكتوبر 04, 2006 6:14 am، تم التعديل مرة واحدة.
- مهند قمرة
- مشرف سابق
- مشاركات: 4222
- اشترك في: السبت أكتوبر 30, 2004 8:32 pm
- مكان: مـصـر [ولي الفخر]
- اتصال:
??? ??????
???? ?? ????? ????? ????? ?????? ?????? ????????
SQL Error
????? ?? ????? ???? ??? ????? ????????INSERT INTO phpbb_posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, post_icon) VALUES (2, 2, -1, '???? ????', 1159809094, '3e8b50a7', 1, 0, 1, 0, )
???? ?? ????? ????? ????? ?????? ?????? ????????
سأعود قريبا لعالمي في ارابيا 
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-


-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-

??? ??? ?????? ????? ????? ??? ??????? ??? ??? ???? ???????
???? ????? ??? ???? ????? ???? ????? ?? ??? ????? ??? ????? ??? ???
???? ??????? ??
?????????
??? ???? ??? ???? ?? ??? ???? ?? ????? ???? ??????? ????
???? ???? ??? ????? ??? ?????? ??? ???? ?? ?? ???? ?? ?????
???????
??? ????? ?????
???? ????? ??? ???? ????? ???? ????? ?? ??? ????? ??? ????? ??? ???
???? ??????? ??
?????????
??? ???? ??? ???? ?? ??? ???? ?? ????? ???? ??????? ????
???? ???? ??? ????? ??? ?????? ??? ???? ?? ?? ???? ?? ?????
???????
??? ????? ?????
كود: تحديد الكل
#################################################################
## ??? ?????: ??? ?????? ????????
## ????? ?????: 1.0.1
## ???? ?????: steveurkel <spam@stefand.de> - http://www.austauschforum.de
## ?????: ??? ????? ???? ?? ????? ?????? ???????? ??? ?? ??????? VB
##
## ???? ????? ????? ?????: ???
## ????? ?????? ?????? ???????: 20 ?????
## ????? ??? ???????: posting.php
## includes/functions_post.php
## viewforum.php
## viewtopic.php
## templates/subSilver/posting_body.tpl
## templates/subSilver/viewforum_body.tpl
## templates/subSilver/viewtopic_body.tpl
##
## ????? ?????: 14 GIF-Files
#################################################################
##
## ???????:
## * ?? ???? icon ?????? ?? ??? ??????? ??? ???? images ??????? ?? ?????? ??????? ???????
##
## *????? ???? ?? ????? ????????? ??????? ???? ?? ????? ??? ???????? ???????? ???????: icon1.gif, icon2.gi.
##
#################################################################
## ?????? ??? ???? ???????? ?? ??????? ??? ????? ????? ?? ????? ????? ?????
#################################################################
#
#-----[ ??? ??? ????? ???????? ]------------------------------------------
#
ALTER TABLE phpbb_posts ADD COLUMN post_icon TINYINT (2) UNSIGNED DEFAULT '1' NOT NULL;
ALTER TABLE phpbb_topics ADD COLUMN topic_icon TINYINT (2) UNSIGNED DEFAULT '1' NOT NULL;
#
#-----[ ???? ??? ]------------------------------------------
#
posting.php
#
#-----[ ???? ?? ]------------------------------------------
#
$refresh = $preview || $poll_add || $poll_edit || $poll_delete;
#
#-----[ ??? ????? ]------------------------------------------
#
if ($msg_icon)
$msg_icon_checked = $msg_icon;
else
$msg_icon_checked = 1;
#
#-----[ ???? ?? ]------------------------------------------
#
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';
#
#-----[ ???????? ? ]------------------------------------------
#
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig, p.post_icon" : '';
#
#-----[ ???? ?? ]------------------------------------------
#
submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username), str_replace("\'", "''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title), $poll_options, $poll_length);
#
#-----[ ???????? ? ]------------------------------------------
#
submit_post($mode, $post_data, $return_message, $return_meta, $forum_id, $topic_id, $post_id, $poll_id, $topic_type, $bbcode_on, $html_on, $smilies_on, $attach_sig, $bbcode_uid, str_replace("\'", "''", $username), str_replace("\'", "''", $subject), str_replace("\'", "''", $message), str_replace("\'", "''", $poll_title), $poll_options, $poll_length, $msg_icon);
#
#-----[ ???? ?? ]------------------------------------------
#
$smilies_on = ( $post_info['enable_smilies'] ) ? true : false;
#
#-----[ ??? ????? ]------------------------------------------
#
switch ($post_info['post_icon']) {
case 2 : $msg_icon_checked = 2; break;
case 3 : $msg_icon_checked = 3; break;
case 4 : $msg_icon_checked = 4; break;
case 5 : $msg_icon_checked = 5; break;
case 6 : $msg_icon_checked = 6; break;
case 7 : $msg_icon_checked = 7; break;
case 8 : $msg_icon_checked = 8; break;
case 9 : $msg_icon_checked = 9; break;
case 10 : $msg_icon_checked = 10; break;
case 11 : $msg_icon_checked = 11; break;
case 12 : $msg_icon_checked = 12; break;
case 13 : $msg_icon_checked = 13; break;
case 14 : $msg_icon_checked = 14; break;
default : $msg_icon_checked = 1; break;
}
#
#-----[ ???? ?? ]------------------------------------------
#
if( $user_sig != '' )
{
$template->assign_block_vars('switch_signature_checkbox', array());
}
#
#-----[ ??? ????? ]------------------------------------------
#
$template->assign_block_vars('switch_msgicon_checkbox', array());
#
#-----[ ???? ?? ]------------------------------------------
#
'U_REVIEW_TOPIC' => ( $mode == 'reply' ) ? append_sid("posting.$phpEx?mode=topicreview&" . POST_TOPIC_URL . "=$topic_id") : '',
#
#-----[ ??? ????? ]------------------------------------------
#
'MSG_ICON_CHECKED1' => ( $msg_icon_checked==1) ? 'CHECKED' : '',
'MSG_ICON_CHECKED2' => ( $msg_icon_checked==2) ? 'CHECKED' : '',
'MSG_ICON_CHECKED3' => ( $msg_icon_checked==3) ? 'CHECKED' : '',
'MSG_ICON_CHECKED4' => ( $msg_icon_checked==4) ? 'CHECKED' : '',
'MSG_ICON_CHECKED5' => ( $msg_icon_checked==5) ? 'CHECKED' : '',
'MSG_ICON_CHECKED6' => ( $msg_icon_checked==6) ? 'CHECKED' : '',
'MSG_ICON_CHECKED7' => ( $msg_icon_checked==7) ? 'CHECKED' : '',
'MSG_ICON_CHECKED8' => ( $msg_icon_checked==8) ? 'CHECKED' : '',
'MSG_ICON_CHECKED9' => ( $msg_icon_checked==9) ? 'CHECKED' : '',
'MSG_ICON_CHECKED10' => ( $msg_icon_checked==10) ? 'CHECKED' : '',
'MSG_ICON_CHECKED11' => ( $msg_icon_checked==11) ? 'CHECKED' : '',
'MSG_ICON_CHECKED12' => ( $msg_icon_checked==12) ? 'CHECKED' : '',
'MSG_ICON_CHECKED13' => ( $msg_icon_checked==13) ? 'CHECKED' : '',
'MSG_ICON_CHECKED14' => ( $msg_icon_checked==14) ? 'CHECKED' : '',
#
#-----[ ???? ??? ]------------------------------------------
#
/includes/functions_post.php
#
#-----[ ???? ?? ]------------------------------------------
#
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_message, &$poll_title, &$poll_options, &$poll_length)
#
#-----[ ???????? ? ]------------------------------------------
#
function submit_post($mode, &$post_data, &$message, &$meta, &$forum_id, &$topic_id, &$post_id, &$poll_id, &$topic_type, &$bbcode_on, &$html_on, &$smilies_on, &$attach_sig, &$bbcode_uid, &$post_username, &$post_subject, &$post_message, &$poll_title, &$poll_options, &$poll_length, &$msg_icon)
#
#-----[ ???? ?? ]------------------------------------------
#
$sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote WHERE topic_id = $topic_id";
#
#-----[ ???????? ]------------------------------------------
#
$sql = ( $mode != "editpost" ) ? "INSERT INTO " . TOPICS_TABLE . " (topic_title, topic_poster, topic_time, forum_id, topic_status, topic_type, topic_vote, topic_icon) VALUES ('$post_subject', " . $userdata['user_id'] . ", $current_time, $forum_id, " . TOPIC_UNLOCKED . ", $topic_type, $topic_vote, $msg_icon)" : "UPDATE " . TOPICS_TABLE . " SET topic_title = '$post_subject', topic_type = $topic_type, topic_vote = $topic_vote, topic_icon = $msg_icon WHERE topic_id = $topic_id";
#
#-----[ ???? ?? ]------------------------------------------
#
$sql = ( $mode != "editpost" ) ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig)" : "UPDATE " . POSTS_TABLE . " SET enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . " WHERE post_id = $post_id";
#
#-----[ ???????? ? ]------------------------------------------
#
$sql = ( $mode != "editpost" ) ? "INSERT INTO " . POSTS_TABLE . " (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig, post_icon) VALUES ($topic_id, $forum_id, " . $userdata['user_id'] . ", '$post_username', $current_time, '$user_ip', $bbcode_on, $html_on, $smilies_on, $attach_sig, $msg_icon)" : "UPDATE " . POSTS_TABLE . " SET enable_bbcode = $bbcode_on, enable_html = $html_on, enable_smilies = $smilies_on, enable_sig = $attach_sig" . $edited_sql . ", post_icon = $msg_icon WHERE post_id = $post_id";
#
#-----[ ???? ??? ]------------------------------------------
#
/viewforum.php
#
#-----[ ???? ?? ]------------------------------------------
#
$topic_type = $topic_rowset[$i]['topic_type'];
#
#-----[ ??? ????? ]------------------------------------------
#
if ( $topic_rowset[$i]['topic_icon'] == 0 ) {
$icon = "images/icon/icon1.gif";
}
else {
$icon = "images/icon/icon" . $topic_rowset[$i]['topic_icon'].".gif";
}
#
#-----[ ???? ?? ]------------------------------------------
#
$template->assign_block_vars('topicrow', array(
'ROW_COLOR' => $row_color,
'ROW_CLASS' => $row_class,
'FORUM_ID' => $forum_id,
#
#-----[ ???????? ? ]------------------------------------------
#
$template->assign_block_vars('topicrow', array(
'ICON' => $icon,
'ROW_COLOR' => $row_color,
'ROW_CLASS' => $row_class,
'FORUM_ID' => $forum_id,
#
#-----[ ???? ??? ]------------------------------------------
#
/viewtopic.php
#
#-----[ ???? ?? ]------------------------------------------
#
else
{
$l_edited_by = '';
}
#
#-----[ ??? ????? ]------------------------------------------
#
if ( $postrow[$i]['post_icon'] == 0 ) {
$icon = "images/icon/icon1.gif";
}
else {
$icon = "images/icon/icon" . $postrow[$i]['post_icon'] . ".gif";
}
#
#-----[ ???? ?? ]------------------------------------------
#
$template->assign_block_vars('postrow', array(
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'POSTER_NAME' => $poster,
#
#-----[ ???????? ? ]------------------------------------------
#
$template->assign_block_vars('postrow', array(
'ICON' => $icon,
'ROW_COLOR' => '#' . $row_color,
'ROW_CLASS' => $row_class,
'POSTER_NAME' => $poster,
#
#-----[ ???? ??? ]------------------------------------------
#
/templates/subSilver/posting_body.tpl
#
#-----[ ???? ?? ]------------------------------------------
#
<tr>
<td class="row1" width="22%"><span class="gen"><b>{L_SUBJECT}</b></span></td>
<td class="row2" width="78%"><span class="gen">
<input type="text" name="subject" size="45" maxlength="60" style="width:450px" tabindex="2" class="post" value="{SUBJECT}" />
</span> </td>
</tr>
#
#-----[ ??? ????? ]------------------------------------------
#
<!-- BEGIN switch_msgicon_checkbox -->
<tr>
<td valign="top" class="row1"><span class="gen"><b>Messageicon</b></td>
<td class="row2"><span class="gen">
<table width="450" border="0" cellspacing="0" cellpadding="2">
<tr><td><span class="gen">
<INPUT type="radio" name="msg_icon" value="1" {MSG_ICON_CHECKED1}> <IMG SRC="images/icon/icon1.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="2" {MSG_ICON_CHECKED2}> <IMG SRC="images/icon/icon2.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="3" {MSG_ICON_CHECKED3}> <IMG SRC="images/icon/icon3.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="4" {MSG_ICON_CHECKED4}> <IMG SRC="images/icon/icon4.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="5" {MSG_ICON_CHECKED5}> <IMG SRC="images/icon/icon5.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="6" {MSG_ICON_CHECKED6}> <IMG SRC="images/icon/icon6.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="7" {MSG_ICON_CHECKED7}> <IMG SRC="images/icon/icon7.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER></span></td></tr>
<tr><td><span class="gen"><INPUT type="radio" name="msg_icon" value="8" {MSG_ICON_CHECKED8}> <IMG SRC="images/icon/icon8.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="9" {MSG_ICON_CHECKED9}> <IMG SRC="images/icon/icon9.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="10" {MSG_ICON_CHECKED10}> <IMG SRC="images/icon/icon10.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="11" {MSG_ICON_CHECKED11}> <IMG SRC="images/icon/icon11.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="12" {MSG_ICON_CHECKED12}> <IMG SRC="images/icon/icon12.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="13" {MSG_ICON_CHECKED13}> <IMG SRC="images/icon/icon13.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER>
<INPUT type="radio" name="msg_icon" value="14" {MSG_ICON_CHECKED14}> <IMG SRC="images/icon/icon14.gif" HEIGHT=15 WIDTH=15 ALIGN=ABSCENTER></span></td></tr></table></span></td>
</tr>
<!-- END switch_msgicon_checkbox -->
#
#-----[ ???? ??? ]------------------------------------------
#
/templates/subSilver/viewforum_body.tpl
#
#-----[ ???? ?? ]------------------------------------------
#
<th colspan="2" align="center" height="25" class="thCornerL" nowrap="nowrap"> {L_TOPICS} </th>
#
#-----[ ???????? ? ]------------------------------------------
#
<th colspan="3" align="center" height="25" class="thCornerL" nowrap="nowrap"> {L_TOPICS} </th>
#
#-----[ ???? ?? ]------------------------------------------
#
<td class="row1" align="center" valign="middle" width="20"><img src="{topicrow.TOPIC_FOLDER_IMG}" width="19" height="18" alt="{topicrow.L_TOPIC_FOLDER_ALT}" title="{topicrow.L_TOPIC_FOLDER_ALT}" /></td>
#
#-----[ ??? ????? ]------------------------------------------
#
<td class="row1" align="center" valign="middle" width="16"><img width="15" height="15" src="{topicrow.ICON}" alt="Messageicon" border="0"></td>
#
#-----[ ???? ?? ]------------------------------------------
#
<td class="row1" colspan="6" height="30" align="center" valign="middle"><span class="gen">{L_NO_TOPICS}</span></td>
#
#-----[ ???????? ? ]------------------------------------------
#
<td class="row1" colspan="7" height="30" align="center" valign="middle"><span class="gen">{L_NO_TOPICS}</span></td>
#
#-----[ ???? ?? ]------------------------------------------
#
<td class="catBottom" align="center" valign="middle" colspan="6" height="28"><span class="genmed">{L_DISPLAY_TOPICS}: {S_SELECT_TOPIC_DAYS}
#
#-----[ ???????? ? ]------------------------------------------
#
<td class="catBottom" align="center" valign="middle" colspan="7" height="28"><span class="genmed">{L_DISPLAY_TOPICS}: {S_SELECT_TOPIC_DAYS}
#
#-----[ ???? ??? ]------------------------------------------
#
/templates/subSilver/viewtopic_body.tpl
#
#-----[ ???? ?? ]------------------------------------------
#
<td width="100%"><a href="{postrow.U_MINI_POST}"><img src="{postrow.MINI_POST_IMG}" width="12" height="9" alt="{postrow.L_MINI_POST_ALT}" title="{postrow.L_MINI_POST_ALT}" border="0" /></a><span class="postdetails">{L_POSTED}: {postrow.POST_DATE}<span class="gen"> </span> {L_POST_SUBJECT}: {postrow.POST_SUBJECT}</span></td>
#
#-----[ ???????? ? ]------------------------------------------
#
<td width="100%"><a href="{postrow.U_MINI_POST}"><img src="{postrow.MINI_POST_IMG}" width="12" height="9" alt="{postrow.L_MINI_POST_ALT}" title="{postrow.L_MINI_POST_ALT}" border="0" /></a> <img width="15" height="15" src="{postrow.ICON}" alt="Messageicon" border="0"> <span class="postdetails">{L_POSTED}: {postrow.POST_DATE}<span class="gen"> </span> {L_POST_SUBJECT}: {postrow.POST_SUBJECT}</span></td>
#
#-----[ ???? ???? ??????? ??????? ?????? ]
الموجودون الآن
المتصفحون للمنتدى الآن: لا يوجد أعضاء مسجلين متصلين و 14 زائرًا