Changeset 999 in ExiteCMS for modules/common/advertising/php-files/modules/advertising/advertising.php
- Timestamp:
- 10/23/07 14:49:17 (5 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
modules/common/advertising/php-files/modules/advertising/advertising.php
r997 r999 70 70 if ($id == "all") { 71 71 $result = dbquery("SELECT * FROM ".$db_prefix."advertising WHERE adverts_userid = '".$userdata['user_id']."' ORDER BY adverts_contract_start"); 72 $subject = $locale[' 510'];72 $subject = $locale['ads510']; 73 73 } else { 74 74 $result = dbquery("SELECT * FROM ".$db_prefix."advertising WHERE adverts_userid = '".$userdata['user_id']."' AND adverts_id = '$id'"); 75 $subject = sprintf($locale[' 511'], $id);75 $subject = sprintf($locale['ads511'], $id); 76 76 } 77 77 // get the number of priority codes used. 78 78 $result2 = dbquery("SELECT DISTINCT adverts_priority FROM ".$db_prefix."advertising"); 79 79 $prio_count = dbrows($result2); 80 $html_body = "<font face='sans_serif'>".sprintf($locale[' 512'],showdate('longdate', time()))."<br><br>";81 $text_body = sprintf($locale[' 512'],showdate('longdate', time()))."\r\n";80 $html_body = "<font face='sans_serif'>".sprintf($locale['ads512'],showdate('longdate', time()))."<br><br>"; 81 $text_body = sprintf($locale['ads512'],showdate('longdate', time()))."\r\n"; 82 82 if (dbrows($result)) { 83 83 while ($data = dbarray($result)) { … … 86 86 $text_body .= str_repeat("-",80)."\r\n"; 87 87 // advert ID 88 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 460']."</td><td>: ".$data['adverts_id']."</td></tr>\r\n";89 $text_body .= str_pad($locale[' 460'],25).": ".$data['adverts_id']."\r\n";88 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads460']."</td><td>: ".$data['adverts_id']."</td></tr>\r\n"; 89 $text_body .= str_pad($locale['ads460'],25).": ".$data['adverts_id']."\r\n"; 90 90 // advert location 91 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 462']."</td><td>: ".$ad_locations[$data['adverts_location']]."</td></tr>\r\n";92 $text_body .= str_pad($locale[' 462'],25).": ".$ad_locations[$data['adverts_location']]."\r\n";91 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads462']."</td><td>: ".$ad_locations[$data['adverts_location']]."</td></tr>\r\n"; 92 $text_body .= str_pad($locale['ads462'],25).": ".$ad_locations[$data['adverts_location']]."\r\n"; 93 93 // only report priority if it's being used 94 94 if ($prio_count > 1) { 95 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 424']."</td><td>: ".$data['adverts_priority']."</td></tr>\r\n";96 $text_body .= str_pad($locale[' 424'],25).": ".$data['adverts_priority']."\r\n";95 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads424']."</td><td>: ".$data['adverts_priority']."</td></tr>\r\n"; 96 $text_body .= str_pad($locale['ads424'],25).": ".$data['adverts_priority']."\r\n"; 97 97 } 98 98 // contract type 99 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 411']."</td><td>: ".$contract_types[$data['adverts_contract']]."</td></tr>\r\n";100 $text_body .= str_pad($locale[' 411'],25).": ".$contract_types[$data['adverts_contract']]."\r\n";99 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads411']."</td><td>: ".$contract_types[$data['adverts_contract']]."</td></tr>\r\n"; 100 $text_body .= str_pad($locale['ads411'],25).": ".$contract_types[$data['adverts_contract']]."\r\n"; 101 101 switch ($data['adverts_contract']) { 102 102 case 0: 103 103 break; 104 104 case 1: 105 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale[' 412'].": ".showdate('shortdate',$data['adverts_contract_start']);106 $text_body .= " - ".str_pad($locale[' 412'],23).": ".showdate('shortdate',$data['adverts_contract_start'])."\r\n";105 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale['ads412'].": ".showdate('shortdate',$data['adverts_contract_start']); 106 $text_body .= " - ".str_pad($locale['ads412'],23).": ".showdate('shortdate',$data['adverts_contract_start'])."\r\n"; 107 107 if ($data['adverts_contract_end']) { 108 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale[' 413'].": ".showdate('shortdate',$data['adverts_contract_end']);109 $text_body .= " - ".str_pad($locale[' 413'],23).": ".showdate('shortdate',$data['adverts_contract_end'])."\r\n";108 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale['ads413'].": ".showdate('shortdate',$data['adverts_contract_end']); 109 $text_body .= " - ".str_pad($locale['ads413'],23).": ".showdate('shortdate',$data['adverts_contract_end'])."\r\n"; 110 110 } 111 111 break; 112 112 case 2: 113 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale[' 414'].": ".$data['adverts_sold'];114 $text_body .= "- ".str_pad($locale[' 414'],23).": ".$data['adverts_sold']."\r\n";115 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale[' 413'].": ".$data['adverts_sold']-$data['adverts_shown'];116 $text_body .= "- ".str_pad($locale[' 413'],23).": ".$data['adverts_sold']-$data['adverts_shown']."\r\n";113 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale['ads414'].": ".$data['adverts_sold']; 114 $text_body .= "- ".str_pad($locale['ads414'],23).": ".$data['adverts_sold']."\r\n"; 115 $html_body .= "<tr><td width='1%' style='white-space:nowrap'></td><td>: ".$locale['ads413'].": ".$data['adverts_sold']-$data['adverts_shown']; 116 $text_body .= "- ".str_pad($locale['ads413'],23).": ".$data['adverts_sold']-$data['adverts_shown']."\r\n"; 117 117 break; 118 118 } 119 119 120 120 // number of advert display requests 121 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 479']."</td><td>: ".$data['adverts_shown']."</td></tr>\r\n";122 $text_body .= str_pad($locale[' 479'],25).": ".$data['adverts_shown']."\r\n";121 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads479']."</td><td>: ".$data['adverts_shown']."</td></tr>\r\n"; 122 $text_body .= str_pad($locale['ads479'],25).": ".$data['adverts_shown']."\r\n"; 123 123 // number of user clicks 124 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 464']."</td><td>: ".$data['adverts_clicks']."</td></tr>\r\n";125 $text_body .= str_pad($locale[' 464'],25).": ".$data['adverts_clicks']."\r\n";124 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads464']."</td><td>: ".$data['adverts_clicks']."</td></tr>\r\n"; 125 $text_body .= str_pad($locale['ads464'],25).": ".$data['adverts_clicks']."\r\n"; 126 126 // precentage clicks 127 127 $percent = $data['adverts_shown'] == 0 ? 0 : substr(100 * $data['adverts_clicks'] / $data['adverts_shown'], 0, 5); 128 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 465']."</td><td>: ".$percent." %</td></tr>\r\n";129 $text_body .= str_pad($locale[' 465'],25).": ".$percent." %\r\n";128 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads465']."</td><td>: ".$percent." %</td></tr>\r\n"; 129 $text_body .= str_pad($locale['ads465'],25).": ".$percent." %\r\n"; 130 130 // advert image displayed 131 131 $ad_image = substr($data['adverts_image'],0,strlen($userdata['user_name'])) == $userdata['user_name'] ? substr($data['adverts_image'],strlen($userdata['user_name'])+1) : $data['adverts_image']; 132 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 417']."</td><td>: ".$ad_image."</td></tr>\r\n";133 $text_body .= str_pad($locale[' 417'],25).": ".$ad_image."\r\n";132 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads417']."</td><td>: ".$ad_image."</td></tr>\r\n"; 133 $text_body .= str_pad($locale['ads417'],25).": ".$ad_image."\r\n"; 134 134 // advert URL link 135 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale[' 418']."</td><td>: ".$data['adverts_url']."</td></tr>\r\n";136 $text_body .= str_pad($locale[' 418'],25).": ".$data['adverts_url']."\r\n";135 $html_body .= "<tr><td width='1%' style='white-space:nowrap'>".$locale['ads418']."</td><td>: ".$data['adverts_url']."</td></tr>\r\n"; 136 $text_body .= str_pad($locale['ads418'],25).": ".$data['adverts_url']."\r\n"; 137 137 // end of table 138 138 $html_body .= "</table><br><hr><br>"; … … 158 158 $errormessage = $error; 159 159 } elseif ($id == "all") { 160 $errormessage = $locale[' 953'];160 $errormessage = $locale['ads953']; 161 161 } else { 162 $errormessage = sprintf($locale[' 952'], $id);163 } 164 } else { 165 opentable($locale[' 500']);166 echo "<div align='center'>\n<br /><b>".$locale[' 901']."</b><br /><br />\n</div>\n";162 $errormessage = sprintf($locale['ads952'], $id); 163 } 164 } else { 165 opentable($locale['ads500']); 166 echo "<div align='center'>\n<br /><b>".$locale['ads901']."</b><br /><br />\n</div>\n"; 167 167 closetable(); 168 168 } … … 186 186 case 1: 187 187 if ($data['adverts_contract_start'] > time()) { 188 $contract_type .= " (".$locale[' 472']." ".showdate("%d-%m-%Y", $data['adverts_contract_start']).")";188 $contract_type .= " (".$locale['ads472']." ".showdate("%d-%m-%Y", $data['adverts_contract_start']).")"; 189 189 } elseif ($data['adverts_contract_end'] != 0) { 190 $contract_type .= " (".$locale[' 471']." ".showdate("%d-%m-%Y", $data['adverts_contract_end']).")";190 $contract_type .= " (".$locale['ads471']." ".showdate("%d-%m-%Y", $data['adverts_contract_end']).")"; 191 191 } else { 192 $contract_type .= " (".$locale[' 478'].")";192 $contract_type .= " (".$locale['ads478'].")"; 193 193 } 194 194 break; 195 195 case 2: 196 $contract_type .= " (".($data['adverts_sold']-$data['adverts_shown'])." ".$locale[' 477'].")";196 $contract_type .= " (".($data['adverts_sold']-$data['adverts_shown'])." ".$locale['ads477'].")"; 197 197 break; 198 198 } … … 226 226 case 1: 227 227 if ($data['adverts_contract_start'] > time()) { 228 $contract_type .= " (".$locale[' 472']." ".showdate("%d-%m-%Y", $data['adverts_contract_start']).")";228 $contract_type .= " (".$locale['ads472']." ".showdate("%d-%m-%Y", $data['adverts_contract_start']).")"; 229 229 } elseif ($data['adverts_contract_end'] != 0) { 230 $contract_type .= " (".$locale[' 471']." ".showdate("%d-%m-%Y", $data['adverts_contract_end']).")";230 $contract_type .= " (".$locale['ads471']." ".showdate("%d-%m-%Y", $data['adverts_contract_end']).")"; 231 231 } else { 232 $contract_type .= " (".$locale[' 478'].")";232 $contract_type .= " (".$locale['ads478'].")"; 233 233 } 234 234 break; 235 235 case 2: 236 $contract_type .= " (".($data['adverts_sold']-$data['adverts_shown'])." ".$locale[' 477'].")";236 $contract_type .= " (".($data['adverts_sold']-$data['adverts_shown'])." ".$locale['ads477'].")"; 237 237 break; 238 238 }
Note: See TracChangeset
for help on using the changeset viewer.
