| 72 | | /*echo '<hr>'; |
|---|
| 73 | | print_r($logged); |
|---|
| 74 | | echo '<hr>'; |
|---|
| 75 | | */ |
|---|
| 76 | | |
|---|
| 77 | | if( $_POST['add_category'] ) |
|---|
| 78 | | { |
|---|
| 79 | | $sCategorySubject = process_db_input( $_POST['caption'] ); |
|---|
| 80 | | $sCategoryDesc = process_db_input( $_POST['description'] ); |
|---|
| 81 | | |
|---|
| 82 | | $sAddQuery = "INSERT INTO `ArticlesCategory` SET `CategoryName` = '$sCategorySubject', `CategoryDescription` = '$sCategoryDesc';"; |
|---|
| 83 | | if( db_res( $sAddQuery ) ) |
|---|
| 84 | | { |
|---|
| 85 | | $sActionText = 'Category Added'; |
|---|
| 86 | | } |
|---|
| 87 | | else |
|---|
| 88 | | { |
|---|
| 89 | | $sActionText = 'Category didn\'t add'; |
|---|
| 90 | | } |
|---|
| 91 | | } |
|---|
| 92 | | elseif( $_POST['edit_category'] ) |
|---|
| 93 | | { |
|---|
| 94 | | $sCategorySubject = process_db_input( $_POST['caption'] ); |
|---|
| 95 | | $sCategoryDesc = process_db_input( $_POST['description'] ); |
|---|
| 96 | | $iCategoryID = (int)$_POST['categoryID']; |
|---|
| 97 | | |
|---|
| 98 | | $sAddQuery = "UPDATE `ArticlesCategory` SET `CategoryName` = '$sCategorySubject', `CategoryDescription` = '$sCategoryDesc' WHERE `CategoryID` = '$iCategoryID' LIMIT 1;"; |
|---|
| 99 | | if( db_res( $sAddQuery ) ) |
|---|
| 100 | | { |
|---|
| 101 | | $sActionText = 'Category Udated'; |
|---|
| 102 | | } |
|---|
| 103 | | else |
|---|
| 104 | | { |
|---|
| 105 | | $sActionText = 'Category didn\'t updated'; |
|---|
| 106 | | } |
|---|
| 107 | | } |
|---|
| 108 | | elseif( $_POST['add_article'] ) |
|---|
| 109 | | { |
|---|
| 110 | | $sArticleTitle = process_db_input( $_POST['title'] ); |
|---|
| 111 | | $sArticle = process_db_input( $_POST['article'] ); |
|---|
| 112 | | $iCategoryID = (int)$_POST['categoryID']; |
|---|
| 113 | | if( $_POST['flag'] == 'HTML') |
|---|
| 114 | | { |
|---|
| 115 | | $sFlag = 'HTML'; |
|---|
| 116 | | } |
|---|
| 117 | | else |
|---|
| 118 | | { |
|---|
| 119 | | $sFlag = 'Text'; |
|---|
| 120 | | } |
|---|
| 121 | | |
|---|
| 122 | | |
|---|
| 123 | | $sAddQuery = "INSERT INTO `Articles` SET `Title` = '$sArticleTitle', `Text` = '$sArticle', `CategoryID` = '$iCategoryID', `Date` = NOW(), `ArticleFlag` = '$sFlag';"; |
|---|
| 124 | | if( db_res( $sAddQuery ) ) |
|---|
| 125 | | { |
|---|
| 126 | | $sActionText = 'Article Added'; |
|---|
| 127 | | } |
|---|
| 128 | | else |
|---|
| 129 | | { |
|---|
| 130 | | $sActionText = 'Article didn\'t added'; |
|---|
| 131 | | } |
|---|
| 132 | | } |
|---|
| 133 | | elseif( $_POST['edit_article'] ) |
|---|
| 134 | | { |
|---|
| 135 | | $sArticleTitle = process_db_input( $_POST['title'] ); |
|---|
| 136 | | $sArticle = process_db_input( $_POST['article'] ); |
|---|
| 137 | | $iCategoryID = (int)$_POST['categoryID']; |
|---|
| 138 | | $iArticleID = (int)$_POST['articleID']; |
|---|
| 139 | | if( $_POST['flag'] == 'HTML') |
|---|
| 140 | | { |
|---|
| 141 | | $sFlag = 'HTML'; |
|---|
| 142 | | } |
|---|
| 143 | | else |
|---|
| 144 | | { |
|---|
| 145 | | $sFlag = 'Text'; |
|---|
| 146 | | } |
|---|
| 147 | | |
|---|
| 148 | | |
|---|
| 149 | | $sAddQuery = "UPDATE `Articles` SET `Title` = '$sArticleTitle', `Text` = '$sArticle', `CategoryID` = '$iCategoryID', `Date` = NOW(), `ArticleFlag` = '$sFlag' WHERE `ArticlesID` = '$iArticleID';"; |
|---|
| 150 | | if( db_res( $sAddQuery ) ) |
|---|
| 151 | | { |
|---|
| 152 | | $sActionText = 'Article Upadated'; |
|---|
| 153 | | } |
|---|
| 154 | | else |
|---|
| 155 | | { |
|---|
| 156 | | $sActionText = 'Article didn\'t Updated'; |
|---|
| 157 | | } |
|---|
| 158 | | } |
|---|
| 159 | | |
|---|
| 160 | | |
|---|
| 161 | | |
|---|
| 268 | | $ret .= '<div class="navigationLinks">' . "\n"; |
|---|
| 269 | | $ret .= '<span>' . "\n"; |
|---|
| 270 | | $ret .= '<a href="articles.php">' . "\n"; |
|---|
| 271 | | $ret .= 'Articles' . "\n"; |
|---|
| 272 | | $ret .= '</a>' . "\n"; |
|---|
| 273 | | $ret .= '</span>' . "\n"; |
|---|
| 274 | | $ret .= '</div>' . "\n"; |
|---|
| 275 | | |
|---|
| 276 | | |
|---|
| 277 | | $ret .= '<script type="text/javascript"> |
|---|
| 278 | | |
|---|
| 279 | | function checkForm() |
|---|
| 280 | | { |
|---|
| 281 | | var el; |
|---|
| 282 | | var hasErr = false; |
|---|
| 283 | | var fild = ""; |
|---|
| 284 | | |
|---|
| 285 | | el = document.getElementById("caption"); |
|---|
| 286 | | if( el.value.length < 3 ) |
|---|
| 287 | | { |
|---|
| 288 | | el.style.backgroundColor = "pink"; |
|---|
| 289 | | hasErr = true; |
|---|
| 290 | | fild += "\n Category Title "; |
|---|
| 291 | | } |
|---|
| 292 | | else |
|---|
| 293 | | { |
|---|
| 294 | | el.style.backgroundColor = "#fff"; |
|---|
| 295 | | } |
|---|
| 296 | | |
|---|
| 297 | | el = document.getElementById("description"); |
|---|
| 298 | | if( el.value.length < 3 ) |
|---|
| 299 | | { |
|---|
| 300 | | el.style.backgroundColor = "pink"; |
|---|
| 301 | | hasErr = true; |
|---|
| 302 | | fild += "\n Category Description"; |
|---|
| 303 | | } |
|---|
| 304 | | else |
|---|
| 305 | | { |
|---|
| 306 | | el.style.backgroundColor = "#fff"; |
|---|
| 307 | | } |
|---|
| 308 | | |
|---|
| 309 | | if (hasErr) |
|---|
| 310 | | { |
|---|
| 311 | | alert( "Please fill next fields first!" + fild ) |
|---|
| 312 | | return false; |
|---|
| 313 | | |
|---|
| 314 | | } |
|---|
| 315 | | else |
|---|
| 316 | | { |
|---|
| 317 | | return true; |
|---|
| 318 | | } |
|---|
| 319 | | } |
|---|
| 320 | | |
|---|
| 321 | | </script>' . "\n"; |
|---|
| 322 | | |
|---|
| 323 | | |
|---|
| 324 | | $ret .= '<div class="articlesFormBlock">' . "\n"; |
|---|
| 325 | | $ret .= '<form method="post" action="' . $site['url_admin'] . 'articles.php" onsubmit="return checkForm();">' . "\n"; |
|---|
| 326 | | $ret .= '<div>' . "\n"; |
|---|
| 327 | | $ret .= 'Category Caption' . "\n"; |
|---|
| 328 | | $ret .= '</div>' . "\n"; |
|---|
| 329 | | $ret .= '<div>' . "\n"; |
|---|
| 330 | | $ret .= '<input type="text" name="caption" id="caption" class="catCaption" value="' . process_line_output( $aCategory['CategoryName'] ) . '" />' . "\n"; |
|---|
| 331 | | $ret .= '</div>' . "\n"; |
|---|
| 332 | | $ret .= '<div>' . "\n"; |
|---|
| 333 | | $ret .= 'Category Description' . "\n"; |
|---|
| 334 | | $ret .= '</div>' . "\n"; |
|---|
| 335 | | $ret .= '<div>' . "\n"; |
|---|
| 336 | | $ret .= '<textarea name="description" id="description" class="catDesc">' . process_text_output( $aCategory['CategoryDescription'] ) . '</textarea>' . "\n"; |
|---|
| 337 | | $ret .= '</div>' . "\n"; |
|---|
| 338 | | $ret .= '<div>' . "\n"; |
|---|
| 339 | | $ret .= '<input type="submit" value="Submit">' . "\n"; |
|---|
| 340 | | if( (int)$iCategoryID ) |
|---|
| 341 | | { |
|---|
| 342 | | $ret .= '<input type="hidden" name="edit_category" value="true" />' . "\n"; |
|---|
| 343 | | $ret .= '<input type="hidden" name="categoryID" value="' . $iCategoryID . '" />' . "\n"; |
|---|
| 344 | | } |
|---|
| 345 | | else |
|---|
| 346 | | { |
|---|
| 347 | | $ret .= '<input type="hidden" name="add_category" value="true" />' . "\n"; |
|---|
| 348 | | } |
|---|
| 349 | | $ret .= '</div>' . "\n"; |
|---|
| 350 | | $ret .= '</form>' . "\n"; |
|---|
| 351 | | $ret .= '</div>' . "\n"; |
|---|
| 352 | | |
|---|
| 353 | | |
|---|
| 354 | | return $ret; |
|---|
| 355 | | } |
|---|
| 356 | | |
|---|
| 357 | | function getArticleEditForm( $iArticleID = '' ) |
|---|
| 358 | | { |
|---|
| 359 | | global $site; |
|---|
| 360 | | global $site; |
|---|
| 361 | | |
|---|
| 362 | | $rCatories = getArticlesCategiriesList( true ); |
|---|
| 363 | | |
|---|
| 364 | | if( (int)$iArticleID ) |
|---|
| 365 | | { |
|---|
| 366 | | $articleQuery = " |
|---|
| 367 | | |
|---|
| 368 | | SELECT |
|---|
| 369 | | `Articles`.`ArticlesID`, |
|---|
| 370 | | `Articles`.`CategoryID`, |
|---|
| 371 | | `Articles`.`Date`, |
|---|
| 372 | | `Articles`.`Title`, |
|---|
| 373 | | `Articles`.`Text`, |
|---|
| 374 | | `Articles`.`ArticleFlag`, |
|---|
| 375 | | `ArticlesCategory`.`CategoryName` |
|---|
| 376 | | FROM `Articles` |
|---|
| 377 | | INNER JOIN `ArticlesCategory` ON `ArticlesCategory`.`CategoryID` = `Articles`.`CategoryID` |
|---|
| 378 | | WHERE `Articles`.`ArticlesID` = '$iArticleID'; |
|---|
| 379 | | "; |
|---|
| 380 | | $aArticle = db_arr( $articleQuery ); |
|---|
| 381 | | } |
|---|
| 382 | | |
|---|
| 383 | | |
|---|
| 384 | | $ret = ''; |
|---|
| 385 | | $ret .= '<div class="navigationLinks">' . "\n"; |
|---|
| 386 | | $ret .= '<span>' . "\n"; |
|---|
| 387 | | $ret .= '<a href="' . $site['url_admin'] . 'articles.php">' . "\n"; |
|---|
| 388 | | $ret .= 'Articles' . "\n"; |
|---|
| 389 | | $ret .= '</a>' . "\n"; |
|---|
| 390 | | $ret .= '</span>' . "\n"; |
|---|
| 391 | | if( $iArticleID && strlen( $aArticle['CategoryName'] ) ) |
|---|
| 392 | | { |
|---|
| 393 | | $ret .= '<span>' . "\n"; |
|---|
| 394 | | $ret .= '>' . "\n"; |
|---|
| 395 | | $ret .= '</span>' . "\n"; |
|---|
| 396 | | $ret .= '<span>' . "\n"; |
|---|
| 397 | | $ret .= '<a href="' . $site['url_admin'] . 'articles.php?catID=' . $aArticle['CategoryID'] . '&action=viewcategory">' . "\n"; |
|---|
| 398 | | $ret .= $aArticle['CategoryName'] . "\n"; |
|---|
| 399 | | $ret .= '</a>' . "\n"; |
|---|
| 400 | | $ret .= '</span>' . "\n"; |
|---|
| 401 | | $ret .= '<span>' . "\n"; |
|---|
| 402 | | $ret .= '>' . "\n"; |
|---|
| 403 | | $ret .= '</span>' . "\n"; |
|---|
| 404 | | $ret .= '<span>' . "\n"; |
|---|
| 405 | | $ret .= 'Edit Article' . "\n"; |
|---|
| 406 | | $ret .= '</span>' . "\n"; |
|---|
| 407 | | } |
|---|
| 408 | | |
|---|
| 409 | | $ret .= '</div>' . "\n"; |
|---|
| 410 | | |
|---|
| 411 | | |
|---|
| 412 | | //$ret .= print_r( $_POST, true ); |
|---|
| 413 | | $ret .= '<script type="text/javascript"> |
|---|
| 414 | | |
|---|
| 415 | | function checkForm() |
|---|
| 416 | | { |
|---|
| 417 | | var el; |
|---|
| 418 | | var hasErr = false; |
|---|
| 419 | | var fild = ""; |
|---|
| 420 | | el = document.getElementById("articleTitle"); |
|---|
| 421 | | if( el.value.length < 3 ) |
|---|
| 422 | | { |
|---|
| 423 | | el.style.backgroundColor = "pink"; |
|---|
| 424 | | hasErr = true; |
|---|
| 425 | | fild += "\n Article Title"; |
|---|
| 426 | | } |
|---|
| 427 | | else |
|---|
| 428 | | { |
|---|
| 429 | | el.style.backgroundColor = "#fff"; |
|---|
| 430 | | } |
|---|
| 431 | | |
|---|
| 432 | | el = document.getElementById("articleBody"); |
|---|
| 433 | | if( el.value.length < 3 ) |
|---|
| 434 | | { |
|---|
| 435 | | el.style.backgroundColor = "pink"; |
|---|
| 436 | | hasErr = true; |
|---|
| 437 | | fild += "\n Article text"; |
|---|
| 438 | | } |
|---|
| 439 | | else |
|---|
| 440 | | { |
|---|
| 441 | | el.style.backgroundColor = "#fff"; |
|---|
| 442 | | } |
|---|
| 443 | | |
|---|
| 444 | | el = document.getElementById("categoryID"); |
|---|
| 445 | | if( el.value.length < 1 ) |
|---|
| 446 | | { |
|---|
| 447 | | el.style.backgroundColor = "pink"; |
|---|
| 448 | | hasErr = true; |
|---|
| 449 | | fild += "\n Category "; |
|---|
| 450 | | } |
|---|
| 451 | | else |
|---|
| 452 | | { |
|---|
| 453 | | el.style.backgroundColor = "#fff"; |
|---|
| 454 | | } |
|---|
| 455 | | |
|---|
| 456 | | el = document.getElementById("flag"); |
|---|
| 457 | | if( el.value.length < 1 ) |
|---|
| 458 | | { |
|---|
| 459 | | el.style.backgroundColor = "pink"; |
|---|
| 460 | | hasErr = true; |
|---|
| 461 | | fild += "\n Text type "; |
|---|
| 462 | | } |
|---|
| 463 | | else |
|---|
| 464 | | { |
|---|
| 465 | | el.style.backgroundColor = "#fff"; |
|---|
| 466 | | } |
|---|
| 467 | | |
|---|
| 468 | | if (hasErr) |
|---|
| 469 | | { |
|---|
| 470 | | alert( "Please fill next fields first!" + fild ) |
|---|
| 471 | | return false; |
|---|
| 472 | | |
|---|
| 473 | | } |
|---|
| 474 | | else |
|---|
| 475 | | { |
|---|
| 476 | | return true; |
|---|
| 477 | | } |
|---|
| 478 | | } |
|---|
| 479 | | |
|---|
| 480 | | |
|---|
| 481 | | |
|---|
| 482 | | |
|---|
| 483 | | |
|---|
| 484 | | </script>' . "\n"; |
|---|
| 485 | | $ret .= '<div class="articlesFormBlock">' . "\n"; |
|---|
| 486 | | $ret .= '<form method="post" action="' . $site['url_admin'] . 'articles.php" onsubmit="return checkForm();">' . "\n"; |
|---|
| 487 | | $ret .= '<div>' . "\n"; |
|---|
| 488 | | $ret .= 'Article Title' . "\n"; |
|---|
| 489 | | $ret .= '</div>' . "\n"; |
|---|
| 490 | | $ret .= '<div>' . "\n"; |
|---|
| 491 | | $ret .= '<input type="text" name="title" id="articleTitle" class="catCaption" value="' . process_line_output( $aArticle['Title'] ) . '" />' . "\n"; |
|---|
| 492 | | $ret .= '</div>' . "\n"; |
|---|
| 493 | | $ret .= '<div>' . "\n"; |
|---|
| 494 | | $ret .= 'Article' . "\n"; |
|---|
| 495 | | $ret .= '</div>' . "\n"; |
|---|
| 496 | | $ret .= '<div style="margin-bottom:7px;">' . "\n"; |
|---|
| 497 | | $ret .= '<textarea name="article" id="articleBody" class="articl">' . $aArticle['Text'] . '</textarea>' . "\n"; |
|---|
| 498 | | $ret .= '</div>' . "\n"; |
|---|
| 499 | | $ret .= '<div style="margin-bottom:7px;">' . "\n"; |
|---|
| 500 | | $ret .= '<select name="categoryID" id="categoryID">' . "\n"; |
|---|
| 501 | | $ret .= '<option value="">Select Category</option>' . "\n"; |
|---|
| 502 | | while ( $aCategory = mysql_fetch_assoc( $rCatories ) ) |
|---|
| 503 | | { |
|---|
| 504 | | if( $aArticle['CategoryID'] == $aCategory['CategoryID'] ) |
|---|
| 505 | | { |
|---|
| 506 | | $sSelectedCategory = ' selected="selected"'; |
|---|
| 507 | | } |
|---|
| 508 | | else |
|---|
| 509 | | { |
|---|
| 510 | | $sSelectedCategory = ''; |
|---|
| 511 | | } |
|---|
| 512 | | $ret .= '<option value="' . $aCategory['CategoryID'] . '"' . $sSelectedCategory . '>' . process_line_output( strmaxtextlen( $aCategory['CategoryName'], 50 ) ) . '</option>' . "\n"; |
|---|
| 513 | | } |
|---|
| 514 | | $ret .= '</select>' . "\n"; |
|---|
| 515 | | $ret .= '</div>' . "\n"; |
|---|
| 516 | | $ret .= '<div style="margin-bottom:7px;">' . "\n"; |
|---|
| 517 | | $textSelected = ( $aArticle['ArticleFlag'] == 'Text' ) ? ' selected="selected"' : ''; |
|---|
| 518 | | $htmlSelected = ( $aArticle['ArticleFlag'] == 'HTML' ) ? ' selected="selected"' : ''; |
|---|
| 519 | | $ret .= '<select name="flag" id="flag">' . "\n"; |
|---|
| 520 | | $ret .= '<option value="">Print As</option>' . "\n"; |
|---|
| 521 | | $ret .= '<option value="Text"' . $textSelected . '>Text</option>' . "\n"; |
|---|
| 522 | | $ret .= '<option value="HTML"' . $htmlSelected . '>HTML</option>' . "\n"; |
|---|
| 523 | | $ret .= '</select>' . "\n"; |
|---|
| 524 | | $ret .= '</div>' . "\n"; |
|---|
| 525 | | $ret .= '<div>' . "\n"; |
|---|
| 526 | | $ret .= '<input type="submit" value="Submit">' . "\n"; |
|---|
| 527 | | |
|---|
| 528 | | if( (int)$iArticleID ) |
|---|
| 529 | | { |
|---|
| 530 | | $ret .= '<input type="hidden" name="edit_article" value="true" />' . "\n"; |
|---|
| 531 | | $ret .= '<input type="hidden" name="articleID" value="' . $iArticleID . '" />' . "\n"; |
|---|
| 532 | | } |
|---|
| 533 | | else |
|---|
| 534 | | { |
|---|
| 535 | | $ret .= '<input type="hidden" name="add_article" value="true" />' . "\n"; |
|---|
| 536 | | } |
|---|
| 537 | | |
|---|
| 538 | | $ret .= '</div>' . "\n"; |
|---|
| 539 | | |
|---|
| 540 | | $ret .= '</form>' . "\n"; |
|---|
| 541 | | $ret .= '</div>' . "\n"; |
|---|
| 542 | | |
|---|
| 543 | | return $ret; |
|---|
| 544 | | } |
|---|
| 545 | | |
|---|
| 546 | | function deleteCategory( $iCategoryID ) |
|---|
| 547 | | { |
|---|
| 548 | | global $logged; |
|---|
| 549 | | |
|---|
| 550 | | if( $logged['admin'] ) |
|---|
| 551 | | { |
|---|
| 552 | | $sCategoryDeleteQuery = " |
|---|
| 553 | | DELETE FROM `ArticlesCategory` WHERE `CategoryID` = '$iCategoryID' LIMIT 1; |
|---|
| 554 | | "; |
|---|
| 555 | | $sCategoriesArticlesDeleteQuery = " |
|---|
| 556 | | DELETE FROM `Articles` WHERE `CategoryID` = '$iCategoryID'; |
|---|
| 557 | | "; |
|---|
| 558 | | |
|---|
| 559 | | if( db_res( $sCategoriesArticlesDeleteQuery ) ) |
|---|
| 560 | | { |
|---|
| 561 | | echo '<div style="color:green; text-align:center;">Articles Deleted Successfully</div>'; |
|---|
| 562 | | } |
|---|
| 563 | | else |
|---|
| 564 | | { |
|---|
| 565 | | echo '<divstyle="color:red; text-align:center;">Articles are not deleted</div>'; |
|---|
| 566 | | } |
|---|
| 567 | | |
|---|
| 568 | | if( db_res( $sCategoryDeleteQuery ) ) |
|---|
| 569 | | { |
|---|
| 570 | | echo '<div style="color:green; text-align:center;">Category Deleted Successfully</div>'; |
|---|
| 571 | | } |
|---|
| 572 | | else |
|---|
| 573 | | { |
|---|
| 574 | | echo '<divstyle="color:red; text-align:center;">Category are not deleted</div>'; |
|---|
| 575 | | } |
|---|
| 576 | | |
|---|
| 577 | | } |
|---|
| 578 | | else |
|---|
| 579 | | { |
|---|
| 580 | | return ''; |
|---|
| 581 | | } |
|---|
| 582 | | } |
|---|
| 583 | | |
|---|
| 584 | | function deleteArticle( $iArticleID ) |
|---|
| 585 | | { |
|---|
| 586 | | global $logged; |
|---|
| 587 | | |
|---|
| 588 | | if( $logged['admin'] ) |
|---|
| 589 | | { |
|---|
| 590 | | $sArticleDeleteQuery = " |
|---|
| 591 | | DELETE FROM `Articles` WHERE `ArticlesID` = '$iArticleID'; |
|---|
| 592 | | "; |
|---|
| 593 | | if( db_res( $sArticleDeleteQuery ) ) |
|---|
| 594 | | { |
|---|
| 595 | | echo '<div style="color:green; text-align:center;">Article Deleted Successfully</div>'; |
|---|
| 596 | | } |
|---|
| 597 | | else |
|---|
| 598 | | { |
|---|
| 599 | | echo '<divstyle="color:red; text-align:center;">Article are not deleted</div>'; |
|---|
| 600 | | } |
|---|
| 601 | | } |
|---|
| 602 | | else |
|---|
| 603 | | { |
|---|
| 604 | | return ''; |
|---|
| 605 | | } |
|---|
| 606 | | |
|---|
| | 136 | return $sRet; |
|---|