10-04-20, 11:18 AM
السلام عليكم ورحمة الله
عندي كود كبيره شويه يعمل استعلام في قاعدة البيانات
بس عند الطلب يتاخر في البحث
هل هناك طريقة لتسريغ الكود
هذا الكود
بارك اله فيكم وشكرا
عندي كود كبيره شويه يعمل استعلام في قاعدة البيانات
بس عند الطلب يتاخر في البحث
هل هناك طريقة لتسريغ الكود
هذا الكود
PHP كود :
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB1 = $result->num_rows;
if ($mSSB1 == "0" ) {
$SSB1 = '<td><p align="center"> </td>';
} else{
$SSB1 = '<td><p align="center">' . $mSSB1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB2 = $result->num_rows;
if ($mSSB2 == "0" ) {
$SSB2 = '<td><p align="center"> </td>';
} else{
$SSB2 = '<td><p align="center">' . $mSSB2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB3 = $result->num_rows;
if ($mSSB3 == "0" ) {
$SSB3 = '<td><p align="center"> </td>';
} else{
$SSB3 = '<td><p align="center">' . $mSSB3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB4 = $result->num_rows;
if ($mSSB4 == "0" ) {
$SSB4 = '<td><p align="center"> </td>';
} else{
$SSB4 = '<td><p align="center">' . $mSSB4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB5 = $result->num_rows;
if ($mSSB5 == "0" ) {
$SSB5 = '<td><p align="center"> </td>';
} else{
$SSB5 = '<td><p align="center">' . $mSSB5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB6 = $result->num_rows;
if ($mSSB6 == "0" ) {
$SSB6 = '<td><p align="center"> </td>';
} else{
$SSB6 = '<td><p align="center">' . $mSSB6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB7 = $result->num_rows;
if ($mSSB7 == "0" ) {
$SSB7 = '<td><p align="center"> </td>';
} else{
$SSB7 = '<td><p align="center">' . $mSSB7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB8 = $result->num_rows;
if ($mSSB8 == "0" ) {
$SSB8 = '<td><p align="center"> </td>';
} else{
$SSB8 = '<td><p align="center">' . $mSSB8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB9 = $result->num_rows;
if ($mSSB9 == "0" ) {
$SSB9 = '<td><p align="center"> </td>';
} else{
$SSB9 = '<td><p align="center">' . $mSSB9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='SSB' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mSSB10 = $result->num_rows;
if ($mSSB10 == "0" ) {
$SSB10 = '<td><p align="center"> </td>';
} else{
$SSB10 = '<td><p align="center">' . $mSSB10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT81 = $result->num_rows;
if ($mFT81 == "0" ) {
$FT81 = '<td><p align="center"> </td>';
} else{
$FT81 = '<td><p align="center">' . $mFT81 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT82 = $result->num_rows;
if ($mFT82 == "0" ) {
$FT82 = '<td><p align="center"> </td>';
} else{
$FT82 = '<td><p align="center">' . $mFT82 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT83 = $result->num_rows;
if ($mFT83 == "0" ) {
$FT83 = '<td><p align="center"> </td>';
} else{
$FT83 = '<td><p align="center">' . $mFT83 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT84 = $result->num_rows;
if ($mFT84 == "0" ) {
$FT84 = '<td><p align="center"> </td>';
} else{
$FT84 = '<td><p align="center">' . $mFT84 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT85 = $result->num_rows;
if ($mFT85 == "0" ) {
$FT85 = '<td><p align="center"> </td>';
} else{
$FT85 = '<td><p align="center">' . $mFT85 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT86 = $result->num_rows;
if ($mFT86 == "0" ) {
$FT86 = '<td><p align="center"> </td>';
} else{
$FT86 = '<td><p align="center">' . $mFT86 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT87 = $result->num_rows;
if ($mFT87 == "0" ) {
$FT87 = '<td><p align="center"> </td>';
} else{
$FT87 = '<td><p align="center">' . $mFT87 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT88 = $result->num_rows;
if ($mFT88 == "0" ) {
$FT88 = '<td><p align="center"> </td>';
} else{
$FT88 = '<td><p align="center">' . $mFT88 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT89 = $result->num_rows;
if ($mFT89 == "0" ) {
$FT89 = '<td><p align="center"> </td>';
} else{
$FT89 = '<td><p align="center">' . $mFT89 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='FT8' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mFT810 = $result->num_rows;
if ($mFT810 == "0" ) {
$FT810 = '<td><p align="center"> </td>';
} else{
$FT810 = '<td><p align="center">' . $mFT810 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW1 = $result->num_rows;
if ($mCW1 == "0" ) {
$CW1 = '<td><p align="center"> </td>';
} else{
$CW1 = '<td><p align="center">' . $mCW1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW2 = $result->num_rows;
if ($mCW2 == "0" ) {
$CW2 = '<td><p align="center"> </td>';
} else{
$CW2 = '<td><p align="center">' . $mCW2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW3 = $result->num_rows;
if ($mCW3 == "0" ) {
$CW3 = '<td><p align="center"> </td>';
} else{
$CW3 = '<td><p align="center">' . $mCW3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW4 = $result->num_rows;
if ($mCW4 == "0" ) {
$CW4 = '<td><p align="center"> </td>';
} else{
$CW4 = '<td><p align="center">' . $mCW4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW5 = $result->num_rows;
if ($mCW5 == "0" ) {
$CW5 = '<td><p align="center"> </td>';
} else{
$CW5 = '<td><p align="center">' . $mCW5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW6 = $result->num_rows;
if ($mCW6 == "0" ) {
$CW6 = '<td><p align="center"> </td>';
} else{
$CW6 = '<td><p align="center">' . $mCW6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW7 = $result->num_rows;
if ($mCW7 == "0" ) {
$CW7 = '<td><p align="center"> </td>';
} else{
$CW7 = '<td><p align="center">' . $mCW7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW8 = $result->num_rows;
if ($mCW8 == "0" ) {
$CW8 = '<td><p align="center"> </td>';
} else{
$CW8 = '<td><p align="center">' . $mCW8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW9 = $result->num_rows;
if ($mCW9 == "0" ) {
$CW9 = '<td><p align="center"> </td>';
} else{
$CW9 = '<td><p align="center">' . $mCW9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='CW' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mCW10 = $result->num_rows;
if ($mCW10 == "0" ) {
$CW10 = '<td><p align="center"> </td>';
} else{
$CW10 = '<td><p align="center">' . $mCW10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK1 = $result->num_rows;
if ($mMFSK1 == "0" ) {
$MFSK1 = '<td><p align="center"> </td>';
} else{
$MFSK1 = '<td><p align="center">' . $mMFSK1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK2 = $result->num_rows;
if ($mMFSK2 == "0" ) {
$MFSK2 = '<td><p align="center"> </td>';
} else{
$MFSK2 = '<td><p align="center">' . $mMFSK2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK3 = $result->num_rows;
if ($mMFSK3 == "0" ) {
$MFSK3 = '<td><p align="center"> </td>';
} else{
$MFSK3 = '<td><p align="center">' . $mMFSK3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK4 = $result->num_rows;
if ($mMFSK4 == "0" ) {
$MFSK4 = '<td><p align="center"> </td>';
} else{
$MFSK4 = '<td><p align="center">' . $mMFSK4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK5 = $result->num_rows;
if ($mMFSK5 == "0" ) {
$MFSK5 = '<td><p align="center"> </td>';
} else{
$MFSK5 = '<td><p align="center">' . $mMFSK5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK6 = $result->num_rows;
if ($mMFSK6 == "0" ) {
$MFSK6 = '<td><p align="center"> </td>';
} else{
$MFSK6 = '<td><p align="center">' . $mMFSK6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK7 = $result->num_rows;
if ($mMFSK7 == "0" ) {
$MFSK7 = '<td><p align="center"> </td>';
} else{
$MFSK7 = '<td><p align="center">' . $mMFSK7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK8 = $result->num_rows;
if ($mMFSK8 == "0" ) {
$MFSK8 = '<td><p align="center"> </td>';
} else{
$MFSK8 = '<td><p align="center">' . $mMFSK8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK9 = $result->num_rows;
if ($mMFSK9 == "0" ) {
$MFSK9 = '<td><p align="center"> </td>';
} else{
$MFSK9 = '<td><p align="center">' . $mMFSK9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='MFSK' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mMFSK10 = $result->num_rows;
if ($mMFSK10 == "0" ) {
$MFSK10 = '<td><p align="center"> </td>';
} else{
$MFSK10 = '<td><p align="center">' . $mMFSK10 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='160m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY1 = $result->num_rows;
if ($mRTTY1 == "0" ) {
$RTTY1 = '<td><p align="center"> </td>';
} else{
$RTTY1 = '<td><p align="center">' . $mRTTY1 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='80m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY2 = $result->num_rows;
if ($mRTTY2 == "0" ) {
$RTTY2 = '<td><p align="center"> </td>';
} else{
$RTTY2 = '<td><p align="center">' . $mRTTY2 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='60m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY3 = $result->num_rows;
if ($mRTTY3 == "0" ) {
$RTTY3 = '<td><p align="center"> </td>';
} else{
$RTTY3 = '<td><p align="center">' . $mRTTY3 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='40m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY4 = $result->num_rows;
if ($mRTTY4 == "0" ) {
$RTTY4 = '<td><p align="center"> </td>';
} else{
$RTTY4 = '<td><p align="center">' . $mRTTY4 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='30m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY5 = $result->num_rows;
if ($mRTTY5 == "0" ) {
$RTTY5 = '<td><p align="center"> </td>';
} else{
$RTTY5 = '<td><p align="center">' . $mRTTY5 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='20m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY6 = $result->num_rows;
if ($mRTTY6 == "0" ) {
$RTTY6 = '<td><p align="center"> </td>';
} else{
$RTTY6 = '<td><p align="center">' . $mRTTY6 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='17m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY7 = $result->num_rows;
if ($mRTTY7 == "0" ) {
$RTTY7 = '<td><p align="center"> </td>';
} else{
$RTTY7 = '<td><p align="center">' . $mRTTY7 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='15m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY8 = $result->num_rows;
if ($mRTTY8 == "0" ) {
$RTTY8 = '<td><p align="center"> </td>';
} else{
$RTTY8 = '<td><p align="center">' . $mRTTY8 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='12m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY9 = $result->num_rows;
if ($mRTTY9 == "0" ) {
$RTTY9 = '<td><p align="center"> </td>';
} else{
$RTTY9 = '<td><p align="center">' . $mRTTY9 . '</td>';
}
$result = $BO->query("SELECT * FROM cq_qso WHERE mode='RTTY' and band='10m' and dxcallsign='" . $_POST['dxcallsign'] . "' and cals='" . $_POST['callop'] . "'");
$mRTTY10 = $result->num_rows;
if ($mRTTY10 == "0" ) {
$RTTY10 = '<td><p align="center"> </td>';
} else{
$RTTY10 = '<td><p align="center">' . $mRTTY10 . '</td>';
}
$smarty->assign("SSB1",$SSB1);
$smarty->assign("SSB2",$SSB2);
$smarty->assign("SSB3",$SSB3);
$smarty->assign("SSB4",$SSB4);
$smarty->assign("SSB5",$SSB5);
$smarty->assign("SSB6",$SSB6);
$smarty->assign("SSB7",$SSB7);
$smarty->assign("SSB8",$SSB8);
$smarty->assign("SSB9",$SSB9);
$smarty->assign("SSB10",$SSB10);
$smarty->assign("FT81",$FT81);
$smarty->assign("FT82",$FT82);
$smarty->assign("FT83",$FT83);
$smarty->assign("FT84",$FT84);
$smarty->assign("FT85",$FT85);
$smarty->assign("FT86",$FT86);
$smarty->assign("FT87",$FT87);
$smarty->assign("FT88",$FT88);
$smarty->assign("FT89",$FT89);
$smarty->assign("FT810",$FT810);
$smarty->assign("RTTY1",$RTTY1);
$smarty->assign("RTTY2",$RTTY2);
$smarty->assign("RTTY3",$RTTY3);
$smarty->assign("RTTY4",$RTTY4);
$smarty->assign("RTTY5",$RTTY5);
$smarty->assign("RTTY6",$RTTY6);
$smarty->assign("RTTY7",$RTTY7);
$smarty->assign("RTTY8",$RTTY8);
$smarty->assign("RTTY9",$RTTY9);
$smarty->assign("RTTY10",$RTTY10);
$smarty->assign("CW1",$CW1);
$smarty->assign("CW2",$CW2);
$smarty->assign("CW3",$CW3);
$smarty->assign("CW4",$CW4);
$smarty->assign("CW5",$CW5);
$smarty->assign("CW6",$CW6);
$smarty->assign("CW7",$CW7);
$smarty->assign("CW8",$CW8);
$smarty->assign("CW9",$CW9);
$smarty->assign("CW10",$CW10);
$smarty->assign("MFSK1",$MFSK1);
$smarty->assign("MFSK2",$MFSK2);
$smarty->assign("MFSK3",$MFSK3);
$smarty->assign("MFSK4",$MFSK4);
$smarty->assign("MFSK5",$MFSK5);
$smarty->assign("MFSK6",$MFSK6);
$smarty->assign("MFSK7",$MFSK7);
$smarty->assign("MFSK8",$MFSK8);
$smarty->assign("MFSK9",$MFSK9);
$smarty->assign("MFSK10",$MFSK10);
$smarty->assign("ca",$ca);
$smarty->display("db:head.tpl");
$smarty->display("db:header.tpl");
$smarty->display("db:indexright.tpl");
$smarty->display("db:oqrs_sh3.tpl");
$smarty->display("db:footer.tpl");
بارك اله فيكم وشكرا