Changeset 42 for trunk/bin/module_maker/skel
- Timestamp:
- Dec 18, 2005 12:16:03 AM (19 years ago)
- Location:
- trunk/bin/module_maker/skel
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/bin/module_maker/skel/adm_list.ihtml
r41 r42 7 7 <span class="nowrap commandtext"><a href="<?php echo App::oHREF($_SERVER['PHP_SELF'] . '?op=add'); ?>"><?php echo _("Add %ITEM_TITLE%"); ?></a></span> 8 8 <br /> 9 9 10 10 <input type="text" class="small" size="20" name="search_query" value="<?php echo getFormData('search_query'); ?>" title="<?php echo oTxt(_("Fields searched: <##> %SEARCH_FIELDS%.")); ?>" /> 11 11 <select name="filter_<##>"> -
trunk/bin/module_maker/skel/admin.php
r41 r42 26 26 * CONFIG 27 27 *****************************************************************************/ 28 28 29 29 // Titles and navigation header. 30 30 $nav->addPage(_("%TITLE%"), $_SERVER['PHP_SELF']); 31 31 32 32 // The object to validate form input. 33 33 $fv = new FormValidator(); … … 215 215 // Get the information for the form. 216 216 $qid = DB::query(" 217 SELECT * 217 SELECT * 218 218 FROM %DB_TBL% 219 219 WHERE %PRIMARY_KEY% = '" . addslashes($id) . "' … … 227 227 // Lock this record. 228 228 $lock->set('%DB_TBL%', '%PRIMARY_KEY%', $id, $frm['<##>']); 229 229 230 230 // Set misc values for the form. 231 231 $frm = array_merge(array( … … 246 246 { 247 247 global $lock; 248 248 249 249 $lock->select('%DB_TBL%', '%PRIMARY_KEY%', $id); 250 250 if ($lock->isLocked() && !$lock->isMine()) { … … 254 254 // Break the cache because we are changing the list data. 255 255 SessionCache::breakCache($_SERVER['PHP_SELF']); 256 256 257 257 // Get the information for this object. 258 258 $qid = DB::query(" 259 SELECT <##> 259 SELECT <##> 260 260 FROM %DB_TBL% 261 261 WHERE %PRIMARY_KEY% = '" . addslashes($id) . "' … … 266 266 App::dieBoomerangURL(); 267 267 } 268 268 269 269 // Delete the record. 270 270 DB::query("DELETE FROM %DB_TBL% WHERE %PRIMARY_KEY% = '" . addslashes($id) . "'"); 271 271 272 272 App::raiseMsg(sprintf(_("The %ITEM_TITLE% <strong>%s</strong> has been deleted."), $name), MSG_SUCCESS, __FILE__, __LINE__); 273 273 … … 279 279 { 280 280 global $auth; 281 281 282 282 // Break the cache because we are changing the list data. 283 283 SessionCache::breakCache($_SERVER['PHP_SELF']); 284 284 285 285 %INSERT% 286 286 $last_insert_id = mysql_insert_id(DB::getDBH()); … … 289 289 $version = RecordVersion::getInstance($GLOBALS['auth']); 290 290 $version->create('%DB_TBL%', '%PRIMARY_KEY%', $last_insert_id, $frm['<##>']); 291 291 292 292 App::raiseMsg(sprintf(_("The %ITEM_TITLE% <strong>%s</strong> has been added."), $frm['<##>']), MSG_SUCCESS, __FILE__, __LINE__); 293 293 294 294 return $last_insert_id; 295 295 } … … 298 298 { 299 299 global $auth, $lock; 300 300 301 301 $lock->select('%DB_TBL%', '%PRIMARY_KEY%', $frm['%PRIMARY_KEY%']); 302 302 if ($lock->isLocked() && !$lock->isMine()) { … … 308 308 309 309 %UPDATE% 310 310 311 311 // Create version. 312 312 $version = RecordVersion::getInstance($GLOBALS['auth']); … … 323 323 global $page; 324 324 global $so; 325 325 326 326 $where_clause = ''; 327 327 328 328 // Build search query if available. 329 329 if (getFormData('search_query', false)) { … … 333 333 } 334 334 } 335 335 336 336 if (getFormData('filter_<##>', false)) { 337 337 // Limit by filter. 338 338 $where_clause .= (empty($where_clause) ? 'WHERE' : 'AND') . " <##> = '" . addslashes(getFormData('filter_<##>')) . "'"; 339 339 } 340 340 341 341 // Count the total number of records so we can do something about the page numbers. 342 342 $qid = DB::query(" 343 SELECT COUNT(*) 344 FROM %DB_TBL% 343 SELECT COUNT(*) 344 FROM %DB_TBL% 345 345 $where_clause 346 346 "); 347 347 list($num_results) = mysql_fetch_row($qid); 348 348 349 349 // Set page numbers now we know (needed for next step). 350 350 $page->setTotalItems($num_results); 351 351 $page->calculate(); 352 352 353 353 // Final SQL, with sort and page limiters. 354 354 $sql = " 355 SELECT 356 %DB_TBL%.*, 355 SELECT 356 %DB_TBL%.*, 357 357 a1.username AS added_admin_username, 358 358 a2.username AS modified_admin_username … … 364 364 " . $page->getLimitSQL() . " 365 365 "; 366 366 367 367 // A unique key for this query, with the total_items in case db records 368 368 // were added since the last cache. This identifies a unique set of … … 375 375 Prefs::setValue('cache_hash', $cache_hash, $_SERVER['PHP_SELF']); 376 376 } 377 377 378 378 if (SessionCache::isCached($_SERVER['PHP_SELF'])) { 379 379 // Get the cached results. … … 386 386 $list[] = $row; 387 387 } 388 388 389 389 if (isset($list) && !empty($list)) { 390 390 // Cache the results. … … 397 397 398 398 function updateRank($ranks) 399 { 399 { 400 400 if (!is_array($ranks)) { 401 401 App::logMsg('Saving rank failed, data posted is not an array: ' . $ranks, LOG_ERR, __FILE__, __LINE__); … … 405 405 // Break the cache because we are changing the list data. 406 406 SessionCache::breakCache($_SERVER['PHP_SELF']); 407 407 408 408 // Count the ranks with invalid numbers 409 409 $unspecified_counter = 0; 410 410 411 411 // Go through the array of new ranks. 412 412 foreach ($ranks as $id => $new_rank) { … … 414 414 // Unspecified entries receive a sort order of 10000. 415 415 $new_rank = 10000; 416 $unspecified_counter++; 416 $unspecified_counter++; 417 417 } 418 418 DB::query(" … … 422 422 "); 423 423 } 424 424 425 425 App::raiseMsg(_("Records have been reordered with the new rank."), MSG_SUCCESS, __FILE__, __LINE__); 426 426 if ($unspecified_counter > 0) { -
trunk/bin/module_maker/skel/public.php
r41 r42 1 1 <?php 2 2 /** 3 * %PUBLIC_SCRIPT% 3 * %PUBLIC_SCRIPT% 4 4 * Code by Strangecode :: www.strangecode.com :: This document contains copyrighted information 5 5 * … … 18 18 // Titles and navigation header. 19 19 $nav->addPage(_("%TITLE%"), $_SERVER['PHP_SELF']); 20 $nav->setFeature(array('title'=>true)); 20 $nav->setFeature(array('title'=>true)); 21 21 22 22 // Instantiate page numbers. Total items are set and calculation is done in the getRecordList function. … … 32 32 33 33 if (getFormData('%PRIMARY_KEY%', false)) { 34 34 35 35 // Get requested record. 36 36 $qid = DB::query(" … … 52 52 WHERE %PRIMARY_KEY% = '" . addslashes(getFormData('%PRIMARY_KEY%')) . "' 53 53 "); 54 54 55 55 // Set title and main template. 56 56 $nav->addPage($item['<##>']); … … 58 58 59 59 } else { 60 60 61 61 // Get the DEFAULT list. 62 62 $%NAME_SINGULAR%_list = array(); 63 63 $qid = DB::query(" 64 SELECT * 65 FROM %DB_TBL% 66 WHERE publish = 'true' 64 SELECT * 65 FROM %DB_TBL% 66 WHERE publish = 'true' 67 67 " . $so->getSortOrderSQL() . " 68 68 LIMIT 100 … … 71 71 $%NAME_SINGULAR%_list[] = $row; 72 72 } 73 73 74 74 // Set page numbers for default list. 75 75 $page->setTotalItems(sizeof($%NAME_SINGULAR%_list)); 76 76 $page->calculate(); 77 77 78 78 79 79 // Get the FEATURED list. 80 80 $featured_list = array(); 81 81 $qid = DB::query(" 82 SELECT * 83 FROM %DB_TBL% 82 SELECT * 83 FROM %DB_TBL% 84 84 WHERE publish = 'true' 85 85 AND featured = 'true' … … 89 89 $featured_list[] = $row; 90 90 } 91 91 92 92 // Get the POPULAR list. 93 93 $popular_list = array(); 94 94 $qid = DB::query(" 95 SELECT * 96 FROM %DB_TBL% 97 WHERE publish = 'true' 95 SELECT * 96 FROM %DB_TBL% 97 WHERE publish = 'true' 98 98 ORDER BY hit_count DESC LIMIT 10 99 99 "); … … 101 101 $popular_list[] = $row; 102 102 } 103 103 104 104 // Get the RECENT list. 105 105 $recent_list = array(); 106 106 $qid = DB::query(" 107 SELECT * 108 FROM %DB_TBL% 109 WHERE publish = 'true' 107 SELECT * 108 FROM %DB_TBL% 109 WHERE publish = 'true' 110 110 ORDER BY added_datetime DESC LIMIT 10 111 111 "); … … 113 113 $recent_list[] = $row; 114 114 } 115 115 116 116 // Set main template. 117 117 $main_template = '%PUBLIC_LIST_TEMPLATE%'; 118 } 118 } 119 119 120 120 // We have the data, and no errors, so here come the templates. -
trunk/bin/module_maker/skel/public_list.ihtml
r41 r42 11 11 <p> 12 12 <em><?php echo date(App::getParam('date_format'), strtotime($%NAME_SINGULAR%_list[$i]['<##>'])); ?></em> — <?php echo nl2br(fancyTxt(oTxt($%NAME_SINGULAR%_list[$i]['summary'], true))); ?> 13 13 14 14 <?php if (strlen(trim($%NAME_SINGULAR%_list[$i]['content'])) > 0) { // Link only if content is available. ?> 15 15 <br /><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $%NAME_SINGULAR%_list[$i]['%PRIMARY_KEY%']); ?>"><?php echo _("Read more"); ?></a> 16 16 <?php } ?> 17 17 </p> 18 <?php 18 <?php 19 19 } 20 20 if ($page->total_pages > 1) { … … 30 30 ?> 31 31 <h2><?php echo _("Featured %NAME_PLURAL%"); ?></h2> 32 <?php 32 <?php 33 33 foreach ($featured_list as $item) { 34 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a></h4><?php 34 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a></h4><?php 35 35 } 36 36 } … … 42 42 ?> 43 43 <h2><?php echo _("Popular %NAME_PLURAL%"); ?></h2> 44 <?php 44 <?php 45 45 foreach ($popular_list as $item) { 46 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a> </h4><?php 46 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a> </h4><?php 47 47 } 48 48 } … … 54 54 ?> 55 55 <h2><?php echo _("Recent %NAME_PLURAL%"); ?></h2> 56 <?php 56 <?php 57 57 foreach ($recent_list as $item) { 58 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a> </h4><?php 58 ?><h4><a href="<?php echo App::oHREF('/%PUBLIC_SCRIPT%?%PRIMARY_KEY%=' . $item['%PRIMARY_KEY%']); ?>"><?php echo fancyTxt(oTxt($item['title'])); ?></a> </h4><?php 59 59 } 60 60 }
Note: See TracChangeset
for help on using the changeset viewer.