Top-Themen

AppleEntwicklungHardwareInternetLinuxMicrosoftMultimediaNetzwerkeOff TopicSicherheitSonstige SystemeVirtualisierungWeiterbildungZusammenarbeit

Aktuelle Themen

Administrator.de FeedbackApache ServerAppleAssemblerAudioAusbildungAuslandBackupBasicBatch & ShellBenchmarksBibliotheken & ToolkitsBlogsCloud-DiensteClusterCMSCPU, RAM, MainboardsCSSC und C++DatenbankenDatenschutzDebianDigitiales FernsehenDNSDrucker und ScannerDSL, VDSLE-BooksE-BusinessE-MailEntwicklungErkennung und -AbwehrExchange ServerFestplatten, SSD, RaidFirewallFlatratesGoogle AndroidGrafikGrafikkarten & MonitoreGroupwareHardwareHosting & HousingHTMLHumor (lol)Hyper-VIconsIDE & EditorenInformationsdiensteInstallationInstant MessagingInternetInternet DomäneniOSISDN & AnaloganschlüsseiTunesJavaJavaScriptKiXtartKVMLAN, WAN, WirelessLinuxLinux DesktopLinux NetzwerkLinux ToolsLinux UserverwaltungLizenzierungMac OS XMicrosoftMicrosoft OfficeMikroTik RouterOSMonitoringMultimediaMultimedia & ZubehörNetzwerkeNetzwerkgrundlagenNetzwerkmanagementNetzwerkprotokolleNotebook & ZubehörNovell NetwareOff TopicOpenOffice, LibreOfficeOutlook & MailPapierkorbPascal und DelphiPeripheriegerätePerlPHPPythonRechtliche FragenRedHat, CentOS, FedoraRouter & RoutingSambaSAN, NAS, DASSchriftartenSchulung & TrainingSEOServerServer-HardwareSicherheitSicherheits-ToolsSicherheitsgrundlagenSolarisSonstige SystemeSoziale NetzwerkeSpeicherkartenStudentenjobs & PraktikumSuche ProjektpartnerSuseSwitche und HubsTipps & TricksTK-Netze & GeräteUbuntuUMTS, EDGE & GPRSUtilitiesVB for ApplicationsVerschlüsselung & ZertifikateVideo & StreamingViren und TrojanerVirtualisierungVisual StudioVmwareVoice over IPWebbrowserWebentwicklungWeiterbildungWindows 7Windows 8Windows 10Windows InstallationWindows MobileWindows NetzwerkWindows ServerWindows SystemdateienWindows ToolsWindows UpdateWindows UserverwaltungWindows VistaWindows XPXenserverXMLZusammenarbeit

Irgendwo im PHP fehlt ne Klammer

Frage Entwicklung PHP

Mitglied: itgugus

itgugus (Level 2) - Jetzt verbinden

24.02.2014, aktualisiert 22:30 Uhr, 1583 Aufrufe, 14 Kommentare

Hallo,

im Webshop verzieht es mir sobald ich in der Administration eine Datei aufrufem das gesamt Design. Weiss wer wo hier ne Klammer fehlt ??
01.
<?php 
02.
/* 
03.
  $Id: stats_customers_orders.php,v 1.2b 11 dec 2005  
04.
 
05.
  osCommerce, Open Source E-Commerce Solutions 
06.
  http://www.oscommerce.com 
07.
 
08.
  Copyright (c) 2005 osCommerce 
09.
 
10.
  originally developed by xaglo v1.2 24 mars 2005 
11.
   
12.
  Released under the GNU General Public License 
13.
*/ 
14.
// change to your needs following 
15.
//  list of minimum for dropdown selection 
16.
  $list_mini = array("1", "2", "3", "4", "5", "10", "15", "20", "50", "100"); 
17.
// END CHANGING 
18.
 
19.
  require('includes/application_top.php'); 
20.
  require(DIR_WS_CLASSES . 'currencies.php'); 
21.
  $currencies = new currencies(); 
22.
 
23.
// detecte les constantes ou initialise 
24.
  $today = getdate(); 
25.
  if ($HTTP_GET_VARS['year']) $year = tep_db_prepare_input($HTTP_GET_VARS['year']);  
26.
  else $year = $today['year']; //  else $year = 'ALL'; 
27.
  if ($HTTP_GET_VARS['month']) $month = tep_db_prepare_input($HTTP_GET_VARS['month']);  
28.
  else $month = $today['mon']; //  else $month = 'ALL'; 
29.
  if ($HTTP_GET_VARS['mini_ordered']) $mini_ordered = tep_db_prepare_input($HTTP_GET_VARS['mini_ordered']);  
30.
  else $mini_ordered = 1; 
31.
  if ($HTTP_GET_VARS['no_status']) $no_status = tep_db_prepare_input($HTTP_GET_VARS['no_status']);  
32.
  if ($HTTP_GET_VARS['status']) $status = tep_db_prepare_input($HTTP_GET_VARS['status']);  
33.
 
34.
//  get list of years for dropdown selection 
35.
$year_begin_query = tep_db_query(" select startdate from counter"); 
36.
$year_begin = tep_db_fetch_array($year_begin_query); 
37.
$year_begin = substr($year_begin['startdate'], 0, 4); 
38.
$current_year = $year_begin; 
39.
while ($current_year != $today['year'] + 1) { 
40.
  $list_year_array[] = array('id' => $current_year, 
41.
                              'text' => $current_year); 
42.
$current_year++; 
43.
44.
 
45.
//  get list of month for dropdown selection 
46.
  $list_month = array(JAN, FEV, MAR, AVR, MAI, JUN, JUI, AOU, SEP, OCT, NOV, DEC); 
47.
  for ($i = 0, $n = sizeof($list_month); $i < $n; $i++) { 
48.
    $list_month_array[] = array('id' => $i+1, 
49.
                                'text' => $list_month[$i]); 
50.
51.
 
52.
// get list of minimum names for dropdown selection 
53.
for ($i = 0, $n = sizeof($list_mini); $i < $n; $i++) { 
54.
  $list_mini_array[] = array('id' => $list_mini[$i], 
55.
                              'text' => $list_mini[$i]); 
56.
57.
 
58.
// get list of orders_status names for dropdown selection 
59.
  $orders_statuses = array(); 
60.
  $orders_status_array = array(); 
61.
  $orders_status_query = tep_db_query("select orders_status_id, orders_status_name from " . TABLE_ORDERS_STATUS . " where language_id = '" . $languages_id . "'"); 
62.
  while ($orders_status = tep_db_fetch_array($orders_status_query)) { 
63.
    $orders_statuses[] = array('id' => $orders_status['orders_status_id'], 
64.
                 'text' => $orders_status['orders_status_name']); 
65.
    $orders_status_array[$orders_status['orders_status_id']] = $orders_status['orders_status_name']; 
66.
     }; 
67.
 
68.
// Total new_customers 
69.
  $new_customers_query_raw = "select count(customers_info_id) as tot_new_customers from " . TABLE_CUSTOMERS_INFO . " where 1=1"; 
70.
  if ($month != 'ALL') $new_customers_query_raw .= " and MONTH(customers_info_date_account_created) = " . $month ; 
71.
  if ($year != 'ALL') $new_customers_query_raw .= " and YEAR(customers_info_date_account_created) = " . $year; 
72.
  $new_customers_query = tep_db_query($new_customers_query_raw); 
73.
  $new_customers = tep_db_fetch_array($new_customers_query); 
74.
  $new_customers_count = $new_customers['tot_new_customers']; 
75.
 
76.
//* Total distinct customers 
77.
  $customers_query_raw = "select distinct(customers_id) from " . TABLE_ORDERS . " where 1=1"; 
78.
  if ($month != 'ALL') $customers_query_raw .= " and MONTH(date_purchased) = " . $month ; 
79.
  if ($year != 'ALL') $customers_query_raw .= " and YEAR(date_purchased) = " . $year; 
80.
  if ($no_status) $customers_query_raw .= " and orders_status <> " . $no_status; 
81.
  if ($status) $customers_query_raw .= " and orders_status = " . $status; 
82.
  $customers_query = tep_db_query($customers_query_raw); 
83.
  $customers_id_array = array(); 
84.
  while ($customers = tep_db_fetch_array($customers_query)) { 
85.
    $customers_id_array[] = $customers['customers_id'];  
86.
87.
  $customers_count = sizeof($customers_id_array); 
88.
 
89.
//* Total new_customers_bought 
90.
  $new_customers_bought_query_raw = "select distinct(o.customers_id) from " . TABLE_ORDERS . " o, " . TABLE_CUSTOMERS_INFO . " ci where ci.customers_info_id = o.customers_id"; 
91.
  if ($month != 'ALL') $new_customers_bought_query_raw .= " and MONTH(o.date_purchased) = " . $month . " and MONTH(ci.customers_info_date_account_created) = " . $month ; 
92.
  if ($year != 'ALL') $new_customers_bought_query_raw .= " and YEAR(o.date_purchased) = " . $year .  " and YEAR(ci.customers_info_date_account_created) = " . $year; 
93.
  if ($no_status) $new_customers_query_raw .= " and o.orders_status <> " . $no_status; 
94.
  if ($status) $new_customers_query_raw .= " and o.orders_status = " . $status; 
95.
  $new_customers_bought_query = tep_db_query($new_customers_bought_query_raw); 
96.
  $new_customers_bought_id_array = array(); 
97.
  while ($new_customers_bought = tep_db_fetch_array($new_customers_bought_query)) { 
98.
    $new_customers_bought_id_array[] = $new_customers_bought['customers_id'];  
99.
100.
  $new_customers_bought_count = sizeof($new_customers_bought_id_array); 
101.
  if ($new_customers_bought_count > 0) $new_customers_bought_percent = tep_round($new_customers_bought_count/$new_customers_count*100, 0); 
102.
 
103.
//* Total customers_bought 
104.
  $customers_bought_query_raw = "select customers_id from " . TABLE_ORDERS; 
105.
  if ($no_status) $customers_query_raw .= " where orders_status <> " . $no_status; 
106.
  if ($status) $customers_query_raw .= " where orders_status = " . $status; 
107.
  $customers_bought_query = tep_db_query($customers_bought_query_raw); 
108.
  $customers_bought_id_array = array(); 
109.
  while ($customers_bought = tep_db_fetch_array($customers_bought_query)) {  
110.
    $customers_bought_id_array[] = $customers_bought['customers_id'];  
111.
112.
 
113.
  $count_customers_again = 0; 
114.
  foreach($customers_id_array as $value) { 
115.
    $key = sizeof(array_keys($customers_bought_id_array, $value)); 
116.
    if ($key>$mini_ordered) $count_customers_again++; 
117.
118.
  if ($customers_count > 0) $percent_customers_again = tep_round($count_customers_again/$customers_count*100, 0); 
119.
 
120.
//* Total orders 
121.
  $orders_query_raw = "select count(*) as total from " . TABLE_ORDERS . " where 1=1 "; 
122.
  if ($month != 'ALL') $orders_query_raw .= " and MONTH(date_purchased) = " . $month ; 
123.
  if ($year != 'ALL') $orders_query_raw .= " and YEAR(date_purchased) = " . $year; 
124.
  if ($no_status) $orders_query_raw .= " and orders_status <> " . $no_status; 
125.
  if ($status) $orders_query_raw .= " and orders_status = " . $status; 
126.
  $orders_query = tep_db_query($orders_query_raw); 
127.
  $orders = tep_db_fetch_array($orders_query); 
128.
  $count_orders = $orders['total']; 
129.
 
130.
//* Total sales 
131.
  $tot_sale_query_raw = "select sum(ot.value) as total, count(ot.value) as count from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where ot.class='ot_total' and ot.orders_id=o.orders_id"; 
132.
  if ($month != 'ALL') $tot_sale_query_raw .= " and MONTH(o.date_purchased) = " . $month ; 
133.
  if ($year != 'ALL') $tot_sale_query_raw .= " and YEAR(o.date_purchased) = " . $year; 
134.
  if ($no_status) $tot_sale_query_raw .= " and o.orders_status <> " . $no_status; 
135.
  if ($status) $tot_sale_query_raw .= " and o.orders_status = " . $status; 
136.
  $tot_sale_query = tep_db_query($tot_sale_query_raw); 
137.
  $tot_sale = tep_db_fetch_array($tot_sale_query); 
138.
 
139.
//* Total taxes 
140.
  $tot_taxes_query_raw = "select sum(round(ot.value,2)) as total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where ot.class='ot_tax' and ot.orders_id=o.orders_id"; 
141.
  if ($month != 'ALL') $tot_taxes_query_raw .= " and MONTH(date_purchased) = " . $month ; 
142.
  if ($year != 'ALL') $tot_taxes_query_raw .= " and YEAR(date_purchased) = " . $year; 
143.
  if ($no_status) $tot_taxes_query_raw .= " and orders_status <> " . $no_status; 
144.
  if ($status) $tot_taxes_query_raw .= " and orders_status = " . $status; 
145.
  $tot_taxes_query = tep_db_query($tot_taxes_query_raw); 
146.
  $tot_taxes = tep_db_fetch_array($tot_taxes_query); 
147.
 
148.
//* Total shipping 
149.
  $tot_shipping_query_raw = "select sum(ot.value) as total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where ot.class='ot_shipping' and ot.orders_id=o.orders_id"; 
150.
  if ($month != 'ALL') $tot_shipping_query_raw .= " and MONTH(date_purchased) = " . $month ; 
151.
  if ($year != 'ALL') $tot_shipping_query_raw .= " and YEAR(date_purchased) = " . $year; 
152.
  if ($no_status) $tot_shipping_query_raw .= " and orders_status <> " . $no_status; 
153.
  if ($status) $tot_shipping_query_raw .= " and orders_status = " . $status; 
154.
  $tot_shipping_query = tep_db_query($tot_shipping_query_raw); 
155.
  $tot_shipping = tep_db_fetch_array($tot_shipping_query); 
156.
 
157.
//* Total products 
158.
  $tot_products_query_raw = "select sum(ot.value) as total from " . TABLE_ORDERS . " o, " . TABLE_ORDERS_TOTAL . " ot where ot.class='ot_subtotal' and ot.orders_id=o.orders_id"; 
159.
  if ($month != 'ALL') $tot_products_query_raw .= " and MONTH(date_purchased) = " . $month ; 
160.
  if ($year != 'ALL') $tot_products_query_raw .= " and YEAR(date_purchased) = " . $year; 
161.
  if ($no_status) $tot_products_query_raw .= " and orders_status <> " . $no_status; 
162.
  if ($status) $tot_products_query_raw .= " and orders_status = " . $status; 
163.
  $tot_products_query = tep_db_query($tot_products_query_raw); 
164.
  $tot_products = tep_db_fetch_array($tot_products_query); 
165.
 
166.
//* Total taxes not included 
167.
	if($tot_sale['total'] == 0){ 
168.
	$tot_HT = 0; 
169.
	$tot_sale['total'] = 0; 
170.
	}else{ 
171.
	$tot_HT = ($tot_sale['total']-$tot_shipping['total'])*(1-($tot_taxes['total']/$tot_sale['total'])); 
172.
173.
 
174.
?> 
175.
 
176.
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 
177.
<html <?php echo HTML_PARAMS; ?>> 
178.
<head> 
179.
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
180.
<title><?php echo TITLE; ?></title> 
181.
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> 
182.
<script language="javascript" src="includes/general.js"></script> 
183.
</head> 
184.
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> 
185.
<!-- header //--> 
186.
<?php require(DIR_WS_INCLUDES . 'header.php'); ?> 
187.
<!-- header_eof //--> 
188.
 
189.
<!-- body //--> 
190.
<table border="0" width="100%" cellspacing="2" cellpadding="2"> 
191.
  <tr> 
192.
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> 
193.
<!-- left_navigation //--> 
194.
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> 
195.
<!-- left_navigation_eof //--> 
196.
    </table></td> 
197.
<!-- body_text //--> 
198.
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0"> 
199.
      <tr> 
200.
        <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 
201.
      </tr> 
202.
      <tr> 
203.
        <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 
204.
      </tr> 
205.
      <tr> 
206.
        <td><table border="0" cellspacing="0" cellpadding="2"><?php echo tep_draw_form('search', FILENAME_STATS_CUSTOMERS_ORDERS, '', 'get'); ?> 
207.
          <tr> 
208.
            <td class="dataTableContent" align="center"><?php echo HEADING_MONTH; ?>&nbsp;</td> 
209.
            <td class="dataTableContent" align="center"><?php echo HEADING_YEAR; ?>&nbsp;</td> 
210.
            <td class="dataTableContent" align="center"><?php echo HEADING_NUMBER_ORDERS; ?>&nbsp;</td> 
211.
<?php if ($status == '') { ?> 
212.
            <td class="dataTableContent" align="center"><?php echo HEADING_TITLE_NO_STATUS; ?>&nbsp;</td> 
213.
<?php } if ($no_status == '') { ?> 
214.
            <td class="dataTableContent" align="center"><?php echo HEADING_TITLE_STATUS; ?></td> 
215.
<?php } ?> 
216.
          </tr> 
217.
          <tr> 
218.
            <td class="main" align="center"><?php echo tep_draw_pull_down_menu('month', array_merge(array(array('id' => 'ALL', 'text' => TEXT_ALL_MOIS)), $list_month_array), '', 'onChange="this.form.submit();"');?>&nbsp;</td> 
219.
            <td class="main" align="center"><?php echo tep_draw_pull_down_menu('year', array_merge(array(array('id' => 'ALL', 'text' => TEXT_ALL_ANNEE)), $list_year_array), '', 'onChange="this.form.submit();"'); ?>&nbsp;</td> 
220.
            <td class="main" align="center"><?php echo tep_draw_pull_down_menu('mini_ordered', $list_mini_array, '', 'onChange="this.form.submit();"'); ?>&nbsp;</td> 
221.
<?php if ($status == '') { ?> 
222.
            <td class="main" align="center"><?php echo tep_draw_pull_down_menu('no_status', array_merge(array(array('id' => '', 'text' => TEXT_NO_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?>&nbsp;</td> 
223.
<?php } if ($no_status == '') { ?> 
224.
            <td class="main" align="center"><?php echo tep_draw_pull_down_menu('status', array_merge(array(array('id' => '', 'text' => TEXT_ALL_ORDERS)), $orders_statuses), '', 'onChange="this.form.submit();"'); ?></td> 
225.
<?php } ?> 
226.
          </tr> 
227.
        </form></table></td> 
228.
      </tr> 
229.
      <tr> 
230.
        <td><table border="0" cellspacing="0" cellpadding="5"> 
231.
          <tr> 
232.
            <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> 
233.
          </tr> 
234.
          <tr class="dataTableHeadingRow"> 
235.
            <td align="right" class="dataTableHeadingContent"><?php echo NEW_CUSTOMERS; ?></td> 
236.
            <td align="center" class="dataTableHeadingContent">&nbsp;&nbsp;<?php echo $new_customers_count; ?></td> 
237.
          </tr> 
238.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
239.
            <td align="right" class="dataTableContent"><?php echo CUSTOMERS_BOUGHT; ?></td> 
240.
            <td align="center" class="dataTableContent">&nbsp;&nbsp;<?php echo $customers_count; ?></td> 
241.
          </tr> 
242.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
243.
            <td align="right" class="dataTableContent"><?php echo NEW_CUSTOMERS_BOUGHT; ?></td> 
244.
            <td align="center" class="dataTableContent">&nbsp;&nbsp;<?php echo $new_customers_bought_count . ' (' . $new_customers_bought_percent . "%)"; ?></td> 
245.
          </tr> 
246.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
247.
            <td align="right" class="dataTableContent"><?php echo sprintf(TEXT_MINI_ORDERED, $mini_ordered);?></td> 
248.
            <td align="center" class="dataTableContent">&nbsp;&nbsp;<?php echo $count_customers_again . ' (' . $percent_customers_again . '%)'; ?></td> 
249.
          </tr> 
250.
          <tr class="dataTableHeadingRow"> 
251.
            <td align="right" class="dataTableHeadingContent"><?php echo NUMBER_ORDER; ?></td> 
252.
            <td align="center" class="dataTableHeadingContent">&nbsp;&nbsp;<?php echo $count_orders; ?></td> 
253.
          </tr> 
254.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
255.
            <td align="right" class="dataTableContent"><?php echo TOTAL_TTC; ?></td> 
256.
            <td align="right" class="dataTableContent">&nbsp;&nbsp;<?php echo $currencies->format($tot_sale['total']); ?></td> 
257.
          </tr> 
258.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
259.
            <td align="right" class="dataTableContent"><?php echo TOTAL_SHIPPING; ?></td> 
260.
            <td align="right" class="dataTableContent">&nbsp;&nbsp;<?php echo $currencies->format($tot_shipping['total']); ?></td> 
261.
          </tr> 
262.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
263.
            <td align="right" class="dataTableContent"><?php echo TOTAL_TAX; ?></td> 
264.
            <td align="right" class="dataTableContent">&nbsp;&nbsp;<?php echo $currencies->format($tot_taxes['total']); ?></td> 
265.
          </tr> 
266.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
267.
            <td align="right" class="dataTableContent"><?php echo TOTAL_HT; ?></td> 
268.
            <td align="right" class="dataTableContent">&nbsp;&nbsp;<?php echo $currencies->format($tot_HT); ?></td> 
269.
          </tr> 
270.
          <tr class="dataTableRow" onMouseOver="this.className='dataTableRowOver';this.style.cursor='hand'" onMouseOut="this.className='dataTableRow'"> 
271.
            <td align="right" class="dataTableContent"><?php echo BASKET_TTC; ?></td> 
272.
            <td align="right" class="dataTableContent">&nbsp;&nbsp;<?php if ($count_orders > 0) echo $currencies->format($tot_sale['total']/$count_orders); ?></td> 
273.
          </tr> 
274.
          <tr class="dataTableHeadingRow"> 
275.
            <td align="right" class="dataTableHeadingContent"><?php echo BASKET_HT; ?></td> 
276.
            <td align="right" class="dataTableHeadingContent">&nbsp;&nbsp;<?php if ($count_orders > 0) echo $currencies->format($tot_HT/$count_orders); ?></td> 
277.
          </tr> 
278.
        </table></td> 
279.
      </tr> 
280.
    </table></td> 
281.
<!-- body_text_eof //--> 
282.
  </tr> 
283.
</table> 
284.
 
285.
<!-- body_eof //--> 
286.
 
287.
<!-- footer //--> 
288.
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?> 
289.
<!-- footer_eof //--> 
290.
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> 
291.
</body> 
292.
</html>
Mitglied: itgugus
24.02.2014, aktualisiert 25.02.2014
HAbe noch ne zweite Datei. Genau gleiches Problem
01.
<?php  
02.
/* 
03.
  $Id: supermailer.php,v 3.04 2006/04/28 19:01:58 efp Exp $ 
04.
 
05.
  osCommerce, Open Source E-Commerce Solutions 
06.
  http://www.oscommerce.com 
07.
 
08.
  Copyright (c) 2003 osCommerce 
09.
 
10.
  Released under the GNU General Public License 
11.
   
12.
  Modified Version from Richard Bartz 
13.
  by Infobroker 
14.
  info@cooleshops.de 
15.
*/ 
16.
######## EXPORTER FOR EXTERNAL MAIL LIST IMPORT 
17.
# Should work for most all osC versions, used on MS2.2 and earlier 
18.
# By Richard Bartz,  richard@bartz.net 
19.
# Modified to fit with Supermailer by Werner Nöbauer neosymptom@hotmail.com 2005 
20.
# HOW TO INSTALL  
21.
# This little script is just to export all of the email addresses from your osC 
22.
# customer database who have subscribed to your newsletter to a tab delimited file 
23.
# that can be imported into a better mailer such as phpList or Supermailer. 
24.
25.
# 1. Change the $filename variable to whatever file name you want.  
26.
# 2. upload this file in the osC admin directory 
27.
# 3. in admin/includes/boxes/tools.php add:   
28.
# 		tep_admin_files_boxes('Supermailer.php', 'Supermailer Export') . 
29.
#    or on OLD versions add  
30.
#		'<a href="' . tep_href_link(FILENAME_SUPERMAILER) . '" class="menuBoxContentLink">' . BOX_TOOLS_SUPERMAILER . '</a><br>' . 
31.
# 4. in admin/includes/filenames.php add:   
32.
# 		define('FILENAME_SUPERMAILER', 'supermailer.php');  
33.
# 5. in admin/includes/languages/"yourlanguage" e.g. english.php add: 
34.
#		define('BOX_TOOLS_SUPERMAILER', 'Supermailer Export'); 
35.
# 4. That's it!  Click on "Supermailer Export" in Admin->Tools!  Save and import. 
36.
# 5. Security:  If you use .htaccess in admin you are safe. 
37.
#    If you use admin add-ons then requiring the application_top.php should do it. 
38.
#    In either case the file should NOT run from a direct call. 
39.
######## 
40.
 
41.
 
42.
// end of configuration! 
43.
require('includes/application_top.php');  
44.
 
45.
$csv_trenner = ';'; 
46.
$schema = 'Name' 
47.
        . $csv_trenner 
48.
		. 'Vorname' 
49.
		. $csv_trenner 
50.
		. 'Email' 
51.
		. $csv_trenner 
52.
		. 'Anrede' 
53.
		. "\n";  
54.
		 
55.
$sql_query = tep_db_query(" 
56.
             SELECT  
57.
			  *  
58.
			 FROM  
59.
			  " . TABLE_CUSTOMERS . "  
60.
			 WHERE  
61.
			  customers_newsletter = '1'"   
62.
			   
63.
			  ); 
64.
			   
65.
while ($sql = tep_db_fetch_array($sql_query)) {				 
66.
 
67.
if ($sql['customers_gender'] == 'f'){ 
68.
$gender_text = 'Frau'; 
69.
}else{ 
70.
$gender_text = 'Herr';} 
71.
					 
72.
$schema.= $sql['customers_lastname'] 
73.
        . $csv_trenner 
74.
		. $sql['customers_firstname'] 
75.
		. $csv_trenner 
76.
		. $sql['customers_email_address'] 
77.
		. $csv_trenner 
78.
		. $gender_text 
79.
		. "\n";	    
80.
	    
81.
	   }			   
82.
$filename="addresses.txt";  //.txt is good for import into excel workbook as tab delimited file 
83.
 
84.
$csv_file = DIR_FS_BACKUP . $filename; 
85.
$schema = addslashes($schema); 
86.
$schema = preg_replace('/\n#/', "\n\\#", $schema); 
87.
if ($fp = fopen($csv_file, 'w')) { 
88.
    fputs($fp, $schema); 
89.
    fclose($fp);	    
90.
91.
?> 
92.
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> 
93.
<html <?php echo HTML_PARAMS; ?>> 
94.
<head> 
95.
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> 
96.
<title><?php echo TITLE; ?></title> 
97.
<link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> 
98.
</head> 
99.
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> 
100.
<!-- header //--> 
101.
<?php require(DIR_WS_INCLUDES . 'header.php'); ?> 
102.
<!-- header_eof //--> 
103.
 
104.
<!-- body //--> 
105.
<table border="0" width="100%" cellspacing="2" cellpadding="2"> 
106.
  <tr> 
107.
  <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft"> 
108.
<!-- left_navigation //--> 
109.
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> 
110.
<!-- left_navigation_eof //--> 
111.
    </table></td> 
112.
<!-- body_text //--> 
113.
    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> 
114.
      <tr> 
115.
        <td> 
116.
 
117.
<table border="0" width="100%" cellspacing="0" cellpadding="2"> 
118.
  <tr> 
119.
    <td class="main"><?php //echo nl2br($schema); ?></td> 
120.
  </tr> 
121.
  <tr> 
122.
    <td class="main"><br><?php echo 'Ihre Datei liegt unter: ' . HTTP_SERVER . DIR_WS_ADMIN . 'backups/' . $filename . ' bereit.<br><br> Diese können Sie dort per FTP downloaden oder hier mit der rechten Maustaste <a style="text-decoration=underline" href="' . tep_href_link('backups/' . $filename) . '" >' . '<font color="#FF0000"><b>downloaden.</font>' . '</a>' ;?><br><br><font color="#FF0000">Wählen Sie aus Sicherheitsgründen die FTP-Variante.</font></td> 
123.
  </tr> 
124.
</table> 
125.
	 
126.
        </td> 
127.
      </tr> 
128.
    </table></td> 
129.
<!-- body_text_eof //--> 
130.
  </tr> 
131.
</table> 
132.
<!-- body_eof //--> 
133.
 
134.
<!-- footer //--> 
135.
<?php require(DIR_WS_INCLUDES . 'footer.php'); ?> 
136.
<!-- footer_eof //--> 
137.
<br> 
138.
</body> 
139.
</html> 
140.
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
Bitte warten ..
Mitglied: Dani
24.02.2014, aktualisiert um 22:29 Uhr
Moin,
erstmal nutz bitte unsere Formatierungshilfen - in diesem Fall Codeblöcke.
Beiträge kann man nach dem Erstellen problemlos editieren und speichern.

Wie kommst du drauf, dass eine Klammer fehlt?
Gibts auch ne Fehlermeldung im Lofile bzw. aktiviere bitte "error_reporting()" in PHP.


Grüße,
Dani
Bitte warten ..
Mitglied: itgugus
24.02.2014 um 22:31 Uhr
Hoi Dani,

es kann auch was anderes wie ne Klammer fehlen. Den Shop verzieht es in Administration

0e85ce173c1d7f7ce739d521343e4c61 - Klicke auf das Bild, um es zu vergrößern

Gruss
Ralf
Bitte warten ..
Mitglied: itgugus
24.02.2014 um 22:32 Uhr
So wäre das mit Rahmen

aa46cd1640afd10700e11675e411b47e - Klicke auf das Bild, um es zu vergrößern
Bitte warten ..
Mitglied: Xaero1982
24.02.2014 um 23:47 Uhr
Versuche mal bitte genauer zu beschreiben was du machst.

Was klickst du an? Welche Datei wird dabei aufgerufen?

Was genau machst du um diesen Fehler zu produzieren? Seit wann? Was wurde geändert?

Anderen Browser versucht?

Gruß
Bitte warten ..
Mitglied: certifiedit.net
25.02.2014 um 03:17 Uhr
Eine Klammer? Ich denke eher, hier liegt ein CSS Problem vor. wäre es eine Klammer würdest du im besten fall gar nichts mehr sehen außer einer Fehlermeldung.
Bitte warten ..
Mitglied: itgugus
25.02.2014 um 06:04 Uhr
ist in jedem Browser so.

Gruss
rlaf
Bitte warten ..
Mitglied: Xaero1982
25.02.2014 um 07:11 Uhr
Gut und meine anderen Fragen?

Gruß
Bitte warten ..
Mitglied: itgugus
25.02.2014 um 15:38 Uhr
Hallo,

geändert wurde an den Dateien nichts. Ist Original Oscommerce. Im Oscommerce Forum wissen die auch nicht warum. Os Commerce ist nun ein totes Webshop System das nicht gross supportet wird. In dem Fall muss das am CSS liegen. Keine Ahnung wo man das fixt.

Gruss
Ralf
Bitte warten ..
Mitglied: itgugus
25.02.2014 um 15:49 Uhr
Eventuell muss ich sogar nur 1 Zeile tauschen. Teste es heute Abend aus.

Gruss
Ralf
Bitte warten ..
Mitglied: certifiedit.net
25.02.2014 um 15:53 Uhr
Zitat von itgugus:

Hallo,

geändert wurde an den Dateien nichts. Ist Original Oscommerce. Im Oscommerce Forum wissen die auch nicht warum. Os Commerce
ist nun ein totes Webshop System das nicht gross supportet wird. In dem Fall muss das am CSS liegen. Keine Ahnung wo man das fixt.


Gruss
Ralf

Hi Ralf,

nun, wenn es früher so aussah: Mach mal den Kompatibilitätsmodus an. Vllt haut dir ein gut gemeinter CSS Hack das Design um die Ohren. Ansonsten: Unsupported ist immer schlecht, da immer wieder Fehler auftauchen, die ausgebügelt werden müssen.
Bitte warten ..
Mitglied: itgugus
25.02.2014 um 16:02 Uhr
Hallo

es war immer corrupt.

gruss
Ralf
Bitte warten ..
Mitglied: itgugus
25.02.2014 um 17:10 Uhr
WErde mal schauen, in anderen Dateien. Da ist bestimmt die Zeile anderst

<link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF">
Bitte warten ..
Mitglied: itgugus
25.02.2014, aktualisiert um 22:10 Uhr
Hallo,

mit der Zeile ging es nicht. man sieht aber , das es das Style sein muss.
Eine andere Datei geht .
Die hier wäre z.bsp ok
01.
<?php 
02.
/* 
03.
  $Id
04.
 
05.
  osCommerce, Open Source E-Commerce Solutions 
06.
  http://www.oscommerce.com 
07.
 
08.
  Copyright (c) 2010 osCommerce 
09.
 
10.
  Released under the GNU General Public License 
11.
*/ 
12.
 
13.
  require('includes/application_top.php'); 
14.
 
15.
  require(DIR_WS_INCLUDES . 'template_top.php'); 
16.
?> 
17.
 
18.
    <table border="0" width="100%" cellspacing="0" cellpadding="0"
19.
      <tr> 
20.
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0"
21.
          <tr> 
22.
            <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> 
23.
            <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> 
24.
          </tr> 
25.
           
26.
        </table></td> 
27.
      </tr> 
28.
      <tr> 
29.
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0"
30.
          <tr> 
31.
            <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"
32.
              <tr class="dataTableHeadingRow"
33.
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NUMBER; ?></td> 
34.
                <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PRODUCTS; ?></td> 
35.
                <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_VIEWED; ?>&nbsp;</td> 
36.
              </tr> 
37.
<?php 
38.
  if (isset($HTTP_GET_VARS['page']) && ($HTTP_GET_VARS['page'] > 1)) $rows = $HTTP_GET_VARS['page'] * MAX_DISPLAY_SEARCH_RESULTS - MAX_DISPLAY_SEARCH_RESULTS; 
39.
  $rows = 0; 
40.
  $products_query_raw = "select p.products_id, pd.products_name, pd.products_viewed, l.name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_LANGUAGES . " l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC"
41.
  $products_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $products_query_raw, $products_query_numrows); 
42.
  $products_query = tep_db_query($products_query_raw); 
43.
  while ($products = tep_db_fetch_array($products_query)) { 
44.
    $rows++; 
45.
 
46.
    if (strlen($rows) < 2) { 
47.
      $rows = '0' . $rows
48.
49.
?> 
50.
              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href='<?php echo tep_href_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . FILENAME_STATS_PRODUCTS_VIEWED . '?page=' . $HTTP_GET_VARS['page'], 'NONSSL'); ?>'"
51.
                <td class="dataTableContent"><?php echo $rows; ?>.</td> 
52.
                <td class="dataTableContent"><?php echo '<a href="' . tep_href_link(FILENAME_CATEGORIES, 'action=new_product_preview&read=only&pID=' . $products['products_id'] . '&origin=' . FILENAME_STATS_PRODUCTS_VIEWED . '?page=' . $HTTP_GET_VARS['page'], 'NONSSL') . '">' . $products['products_name'] . '</a> (' . $products['name'] . ')'; ?></td> 
53.
                <td class="dataTableContent" align="center"><?php echo $products['products_viewed']; ?>&nbsp;</td> 
54.
              </tr> 
55.
<?php 
56.
57.
?> 
58.
            </table></td> 
59.
          </tr> 
60.
          <tr> 
61.
            <td colspan="3"><table border="0" width="100%" cellspacing="0" cellpadding="2"
62.
              <tr> 
63.
                <td class="smallText" valign="top"><?php echo $products_split->display_count($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_PRODUCTS); ?></td> 
64.
                <td class="smallText" align="right"><?php echo $products_split->display_links($products_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?></td> 
65.
              </tr> 
66.
            </table></td> 
67.
          </tr> 
68.
        </table></td> 
69.
      </tr> 
70.
    </table> 
71.
 
72.
<?php 
73.
  require(DIR_WS_INCLUDES . 'template_bottom.php'); 
74.
  require(DIR_WS_INCLUDES . 'application_bottom.php'); 
75.
?>
[Edit Biber] Codeformatierung. Eigentlich wollte ich es in die Tonne kloppen. [/Edit]
Bitte warten ..
Neuester Wissensbeitrag
Microsoft

Lizenzwiederverkauf und seine Tücken

(5)

Erfahrungsbericht von DerWoWusste zum Thema Microsoft ...

Ähnliche Inhalte
Heiß diskutierte Inhalte
Windows Netzwerk
Windows 10 RDP geht nicht (16)

Frage von Fiasko zum Thema Windows Netzwerk ...

Windows Server
Outlook Verbindungsversuch mit Exchange (15)

Frage von xbast1x zum Thema Windows Server ...

Microsoft Office
Keine Updates für Office 2016 (13)

Frage von Motte990 zum Thema Microsoft Office ...