Site Unstucker Module Error menu

User Tag List

Results 1 to 3 of 3
  1. #1
    dgshonk's Avatar Private
    Reputation
    1
    Join Date
    Feb 2011
    Posts
    1
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Site Unstucker Module Error

    Hello!

    I am having an issue with the unstucker module on my server's site. I have looked at the module's coding and can't figure it out, so I thought I'd request help here. First off, I am using Web-WoW V2 for my site.

    I am getting this error:
    Code:
    Unknown column 'username' in 'where clause'
    Here is the coding for the module, please reply and tell me how to fix this, thanks!

    Unstucker Module:

    PHP Code:
    <?php
    global $user,$db,$form,$lang,$config,$Html;

    /**
    * This part of website is executed before any output is given
    * so every post data is processed here then using Header(Location:)
    * we simply call normal site and display errors
    **/

    /**
    * Access premission:
    **/
    if(!$user->logged_in){ if (!isset($proccess)) echo "<a href='./?page=loginout'>".$lang['Login']."</a>"; return; }

    /**
    * MODULE SELF INSTALLATION (none for this module):
    **/
    /*if (!isset($proccess))
    {
    if($Html->moduleinstall('',array(),array(),array(),array()))
    return;
    }*/
    /**
    * :END MODULE SELF INSTALLATION
    **/

    if(isset($proccess) && $proccess == TRUE){
    /**
    * Processes the user submitted login form, if errors
    * are found, the user is redirected to correct the information,
    * if not, the user is effectively logged in to the system.
    * If user is logged in, he will be logged out and redirected to
    * index.php page.
    */
    function Process(){
    global 
    $user$form$config,$db,$lang;

    $charinfo preg_replace"/[^0-9-]/"""$_POST['character'] );
    $charinfo explode("-"$charinfo );
    $realmid=$charinfo[0];
    $charguid=$charinfo[1];

    /* Get character info */
    $db_realm connect_realm($realmid);
    $char_info0 $db_realm->query$user->CoreSQL(,$charguid$realmid ) ) or die ($db->error('error_msg'));
    $char_info $db_realm->fetch_array$char_info0 );

    //unstuck!
    //echo  $user->CoreSQL( 3 ,$char_info['guid'], $realmid  );exit;
    $tel_db $db_realm->query$user->CoreSQL,$char_info['guid'], $realmid  ) ) or die ($db->error('error_msg'));
    if (
    $tel_db) {
    $_SESSION['notice'] ="<center><a href='./?page=wwc-unstucker'>".$lang['OK']."</a></center>"; return;
    }
    else 
    $_SESSION['notice'] ="<center>Failed!<br><br><a href='./?page=wwc-unstucker'>".$lang['OK']."</a></center>";
    }

    if (isset(
    $_POST['unstuck'])){
    /* Initialize process */
    Process();
    }

    /* Reinitilaze 'form' proccess with latest session data */
    $form->_Form();
    return;

    }


    ?>
    <!-- This element is important, must be at beginning of module output, dont change it, except module name -->
    <div class="post_body_title"><?php echo $lang['Unstucker']; ?></div>
    <?php
    /**
    * Notification
    **/
    if (isset($_SESSION['notice'])){
    echo 
    $_SESSION['notice'];
    unset(
    $_SESSION['notice']);
    return;
    }
    ?>
    <center><form method="post">
    <?php
    $user
    ->print_Char_Dropdown($user->userinfo['guid']);
    ?>&nbsp;&nbsp;<input name="unstuck" type="submit" value="<?php echo $lang['OK']; ?>" /></form><br />
    </center>
    Last edited by stoneharry; 04-26-2011 at 10:57 AM. Reason: Added prefix because apparently you can't read the stickied thread saying the rules.

    Site Unstucker Module Error
  2. #2
    Sonic Waffle's Avatar Contributor
    Reputation
    170
    Join Date
    Dec 2007
    Posts
    990
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am unfamiliar with Web-WoW v2, but it seems like a problem with an SQL query as it is trying to get the Username. This doesn't seem like a problem with this module though, but more a problem with the SQL execution module.


  3. #3
    SpellEffects's Avatar Sergeant
    Reputation
    64
    Join Date
    Apr 2011
    Posts
    69
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nothing of the posted code is releated to that error.

    The error is focused on a SQL query, which is not located in the code specified.
    uint32 = -1;
    I guess some people just find it hard to input their question into a field and press enter.

    Check out my blog here on the forums

Similar Threads

  1. [MySQL] Advanced Unstuck Tool Integration Error
    By The_Red in forum WoW EMU Questions & Requests
    Replies: 2
    Last Post: 04-19-2010, 05:31 PM
  2. [Website] final site error :( HELP PLEASE
    By beerent in forum WoW EMU Questions & Requests
    Replies: 5
    Last Post: 04-09-2010, 06:19 AM
  3. Error With my site
    By mikebe1 in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 05-29-2009, 01:42 PM
  4. Account Site Error...
    By Daxo in forum World of Warcraft Emulator Servers
    Replies: 1
    Last Post: 10-02-2007, 04:03 AM
  5. Site Error?
    By Amedis in forum Community Chat
    Replies: 8
    Last Post: 06-21-2006, 08:31 AM
All times are GMT -5. The time now is 06:43 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2024 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search