Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-01-2004, 01:18 AM
AN-net's Avatar
AN-net AN-net is offline
 
Join Date: Dec 2003
Location: AnimationTalk.com
Posts: 2,367
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default having some php woes

having some troubles

its not updating the submitted entries


heres my code:
PHP Code:
if($_REQUEST['do']=="moderateentries")
{
    
print_cp_header("Moderate Journal Entries");
    
print_form_header('journaladmin''doentries');
    
print_table_header("Moderate Journal Entries");
    
$getentries$DB_site->query("SELECT journal_entries.entrytitle,journal_entries.journal_id,journals.journalname,
    journals.journalist,journals.journalist_id,journal_entries.entrytext,journal_entries.entry_id 
    FROM "
.TABLE_PREFIX."journal_entries
    LEFT JOIN "
.TABLE_PREFIX."journals ON (journal_entries.journal_id=journals.journal_id)
    WHERE journal_entries.entry_active!=1"
);
    if(!empty(
$getentries))
    {
        while(
$entry=$DB_site->fetch_array($getentries))
        {
            
print_description_row('<span class="smallfont">&nbsp;</span>'02'thead');
            
print_label_row('<b>Entered By</b>:''<a href=user.php?do=edit&userid='.$entry[journalist_id].'>'.$entry[journalist].'</a>');
            
print_label_row('<b>Belongs to Journal</b>:''<a href=journaladmin.php?do=editj&j='.$entry[journal_id].'>'.iif(empty($entry[journalname]), ''.$entry[journalist].'\'s Journal'$entry[journalname]).'</a>');
            
print_input_row("<i>Entry Title</i>:""entrytitle[$entry[entry_id]]"$entry[entrytitle], 0);
            
print_textarea_row("<i>Entry Message</i>:""entrytext[$entry[entry_id]]"$entry[entrytext], 860);
            
print_label_row($vbphrase['action'], "
                <label for=\"val_
$entry[entry_id]\"><input type=\"radio\" name=\"entryaction[$entry[entry_id]]\" value=\"1\" id=\"val_$entry[entry_id]\" tabindex=\"1\" />Approve</label>
                <label for=\"del_
$entry[entry_id]\"><input type=\"radio\" name=\"entryaction[$entry[entry_id]]\" value=\"2\" id=\"del_$entry[entry_id]\" tabindex=\"1\" />" $vbphrase['delete'] . "</label>
                <label for=\"ign_
$entry[entry_id]\"><input type=\"radio\" name=\"entryaction[$entry[entry_id]]\" value=\"3\" id=\"ign_$entry[entry_id]\" tabindex=\"1\" checked=\"checked\" />" $vbphrase['ignore'] . "</label>
            "
'''top''entryaction');
        }
        
print_submit_row();
    }
    else
    {
        
print_description_row("No Entries to Moderate");
        
print_table_footer();
    }
}
if(
$_POST['do']=="doentries")
{
    
globalize($_POST, array('entryaction''entrytitle''entrytext'));
    foreach(
$entryaction AS $entryid => $action)
    {
        
$entryidintval($entryid);
        if(
$action==1)
        {
            
$DB_site->query("UPDATE ".TABLE_PREFIX."journal_entries SET entrytitle='".addslashes($entrytitle[$entryid])."',entrytext='".addslashes($entrytext[$entryid])."' WHERE entry_id='".$entryid."'");
        }
        elseif(
$action==2)
        {
            
$DB_site->query("DELETE FROM ".TABLE_PREFIX."journal_entries WHERE entry_id='".$entryid."'");
        }
    }
    
define('CP_REDIRECT''journaladmin.php?do=moderateentries');
    
print_stop_message('journal_entries_moderated_successfully');

thanks in advance
Reply With Quote
  #2  
Old 07-01-2004, 03:02 PM
Modin Modin is offline
 
Join Date: Jun 2004
Posts: 162
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

your sql looks fine, throw in some echo statements and dump some vars to the screen to see if they are what they should be... my guess would be that $action doesn't equal 1.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:04 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03630 seconds
  • Memory Usage 2,204KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete