[Help]Warning in gm panel

Results 1 to 16 of 16
  1. #1
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    [Help]Warning in gm panel

    I have GM panel and i have warning when i tried something how I can fix it :

    Results:
    Warning: mssql_query() [function.mssql-query]: message: Conversion failed when converting the varchar value 'asfsaf' to data type int. (severity 16) in C:\AppServ\www\modcp\ecuentas.php on line 206

    Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\modcp\ecuentas.php on line 206

    Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\modcp\ecuentas.php on line 207
    AID dosent exist

    Thanks


  2. #2
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    Re: [Help]Warning in gm panel

    Bump!
    Help please!

  3. #3
    Member Girbicid is offline
    MemberRank
    Apr 2007 Join Date
    UkraineLocation
    72Posts

    Re: [Help]Warning in gm panel

    php script bugz. post source

  4. #4
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    Re: [Help]Warning in gm panel

    What?>@

  5. #5
    Account Upgraded | Title Enabled! rodanio14 is offline
    MemberRank
    Jun 2007 Join Date
    Next to ur sister's houseLocation
    533Posts

    Re: [Help]Warning in gm panel

    are u noob ? he says php script bugz. post source u gotta post the source of ur php dude ur so a dumbass sorry :/

  6. #6
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    Re: [Help]Warning in gm panel

    ecuentas.php

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Fox GunZ Panel : By Emisand</title>
    <style type="text/css">
    <!--
    body,td,th {
    color: #3b3131;
    }
    body {
    background-color: #DDDDDD;
    }
    input {
    border: 1px solid #A0A0A4;
    color: #808080;
    background: #2A3F55;
    font-family: Verdana, Arial, Serif;
    font-size: 10pt;
    text-decoration:inherit
    }
    -->
    </style></head>

    <body>
    <p><b><font face="Arial">Account Controls</font></b><?php require 'config.php';
    function anti_injection($sql)
    {
    $sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);

    return $sql;
    }

    // Verificar Campos Vazios

    function valida($campos){
    foreach($campos as $c){
    if(empty($c)){
    echo "Complete all textboxs.";
    return false;
    }else{
    return true;
    }
    }
    }
    ?>
    </p>
    <table width="980" border="0" bordercolor="#2B60DE">
    <tr>
    <td style="border-style: solid; border-width: 2px"><font face="Arial"><em><strong>Register New Account</strong></em></td>
    </tr>
    <tr>
    <td><FORM METHOD=POST ACTION="<?php require 'config.php'; echo $_SERVER['PHP_SELF']; ?>?act=register">
    User:
    <input name="user" type="text" id="user" />
    Password:
    <input name="pass" type="text" id="pass" />
    <input type="submit" name="Submitreg" value="Create Account" />
    </form>
    </td>
    </tr>
    <tr>
    <td>Results: <?php require 'config.php';
    if ($_GET['act'] == 'register')
    {
    $user = anti_injection($_POST['user']);
    $pass = anti_injection($_POST['pass']);
    if (valida(Array($user,$pass)) == true)
    {
    $query = mssql_query("SELECT * FROM Account WHERE UserID='$user'");
    if(mssql_num_rows($query)>=1){
    echo "Account already exists!";
    } else {
    $sql = mssql_query("INSERT INTO Account (UserID, Password, UGradeID) VALUES ('$user', '$pass', '0')");
    $log = "
    The user has registered itself $user";
    $ip = $_SERVER['REMOTE_ADDR'];
    $fecha = date("d-m-y - H:i:s");
    $fileb = fopen("log.txt","r");
    $escrito= fread($fileb,1000000);
    $file = fopen("log.txt","w+");
    $total= "$fecha - $ip: $log
    \n\n$escrito";
    fwrite($file,$total, 1000000);
    fclose($fileb);
    fclose($file);
    echo "Account: $user Password: $pass";

    }
    }
    }
    ?></td>
    </tr>
    </table>
    <table width="980" border="0" bordercolor="#2B60DE">
    <tr>
    <td style="border-style: solid; border-width: 2px"><font face="Arial"><em><strong>Get Account Name by AID</strong></em></td>
    </tr>
    <tr>
    <td><FORM METHOD=POST ACTION="<?php require 'config.php'; echo $_SERVER['PHP_SELF']; ?>?act=getname">
    AID:
    <input name="personaje" type="text" id="personaje" />
    <input type="submit" name="Submit97" value="Find!" />
    </form>
    </td>
    </tr>
    <tr>
    <td>Results: <?php require 'config.php';
    if ($_GET['act'] == 'getname')
    {
    $pj = anti_injection($_POST['personaje']);
    if (valida(Array($pj)) == true)
    {
    $query = mssql_query("SELECT * FROM Character WHERE Name='$pj'");
    if(mssql_num_rows($query)<1){
    echo "AID dosent exist";
    } else {
    $data = mssql_fetch_assoc($query);
    $aid = $data['AID'];
    $query2 = mssql_query("SELECT * FROM Account WHERE AID='$aid'");
    $data2 = mssql_fetch_assoc($query2);
    $name = $data2['UserID'];
    $log = "Se ha obtenido el nombre de cuenta del pj $pj que es $name";
    $ip = $_SERVER['REMOTE_ADDR'];
    $fecha = date("d-m-y - H:i:s");
    $fileb = fopen("log.txt","r");
    $escrito= fread($fileb,1000000);
    $file = fopen("log.txt","w+");
    $total= "$fecha - $ip: $log
    \n\n$escrito";
    fwrite($file,$total, 1000000);
    fclose($fileb);
    fclose($file);
    echo "
    The Name of account of $pj is $name ";
    }
    }
    }
    ?></td>
    </tr>
    </table>
    <table width="980" border="0" bordercolor="#2B60DE">

    <tr>
    <td style="border-style: solid; border-width: 2px"><font face="Arial"><em><strong>Ban Character Account</strong></em></td>
    </tr>
    <tr>
    <td bordercolor="#FF6633"><FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?act=banchar">
    Character:
    <input name="char" type="text" id="char" />
    <input type="submit" name="SubmitBan" value="Submit Ban" />
    </form> </td>
    </tr>
    <tr>
    <td width="730" bordercolor="#FF6633">Results:
    <?php
    if ($_GET['act'] == 'banchar')
    {
    $char = anti_injection($_POST['char']);
    if (valida(Array($char)) == true)
    {
    $query = mssql_query("SELECT * FROM Character WHERE Name='$char'");
    if(mssql_num_rows($query)<1){
    echo "Character Dosent Exist";
    } else {
    $data = mssql_fetch_assoc($query);
    $aid = $data['AID'];
    $query2 = mssql_query("UPDATE Account SET UGradeID='253' WHERE AID='$aid'");
    $log = "La cuenta del character $char ha sido baneada.";
    $ip = $_SERVER['REMOTE_ADDR'];
    $fecha = date("d-m-y - H:i ");
    $fileb = fopen("log.txt","r");
    $escrito= fread($fileb,1000000);
    $file = fopen("log.txt","w+");
    $total= "$fecha - $ip: $log
    \n\n$escrito";
    fwrite($file,$total, 1000000);
    fclose($fileb);
    fclose($file);
    echo "Account of $char is banned!";
    }
    }
    }
    ?></td>
    </tr>
    </table>
    <table width="980" border="0" bordercolor="#2B60DE">
    <tr>
    <td style="border-style: solid; border-width: 2px"><font face="Arial"><em><strong>Ban Account by AID</strong></em></td>
    </tr>
    <tr>
    <td bordercolor="#2B60DE"><FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?act=banaid">
    AID:
    <input name="aid" type="text" id="aid" />
    <input type="submit" name="SubmitBan" value="Ban" />
    </form> </td>
    </tr>
    <tr>
    <td width="730" bordercolor="#2B60DE">Results:
    <?php
    if ($_GET['act'] == 'banaid')
    {
    $aid = anti_injection($_POST['aid']);
    if (valida(Array($aid)) == true)
    {
    $query = mssql_query("SELECT * FROM Account WHERE AID='$aid'");
    if(mssql_num_rows($query)<1){
    echo "AID dosent exist";
    } else {
    $query2 = mssql_query("UPDATE Account SET UGradeID='253' WHERE AID='$aid'");
    $log = "AID $aid ha sido baneada.";
    $ip = $_SERVER['REMOTE_ADDR'];
    $fecha = date("d-m-y - H:i ");
    $fileb = fopen("log.txt","r");
    $escrito= fread($fileb,1000000);
    $file = fopen("log.txt","w+");
    $total= "$fecha - $ip: $log
    \n\n$escrito";
    fwrite($file,$total, 1000000);
    fclose($fileb);
    fclose($file);
    echo "AID $aid is banned.";
    }
    }
    }
    ?></td>
    </tr>
    </table>
    </body>

    </html>

  7. #7
    Member Girbicid is offline
    MemberRank
    Apr 2007 Join Date
    UkraineLocation
    72Posts

    Re: [Help]Warning in gm panel

    eh. lul. script seems is ok. u entered wrong parameters. U supposed to enter digits instead 'asfsaf' if u wanted to search by Account ID. u entered text and got datatype conflict.
    u can change on line 203
    $aid = anti_injection($_POST['aid']);
    to
    $aid = (int)anti_injection($_POST['aid']);
    u will not get error even if u enter text then. if u will enter "blabla23" it will find info on 23 rd account.
    RTFM b4 using any CPs next time.
    good luck ;)

  8. #8
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    Re: [Help]Warning in gm panel

    Thanks Girbicid I will try it =)

  9. #9
    Account Upgraded | Title Enabled! sexy fire slash is offline
    MemberRank
    Oct 2007 Join Date
    Canada B.C. Currently A Developer.Location
    553Posts

    Re: [Help]Warning in gm panel

    Haha lol You Have So Many Problems Ron xD

  10. #10
    Account Upgraded | Title Enabled! ron1233 is offline
    MemberRank
    Nov 2007 Join Date
    275Posts

    Re: [Help]Warning in gm panel

    I know...

  11. #11
    Account Upgraded | Title Enabled! rodanio14 is offline
    MemberRank
    Jun 2007 Join Date
    Next to ur sister's houseLocation
    533Posts

    Re: [Help]Warning in gm panel

    Girbicid pro phper =DD

  12. #12
    Account Upgraded | Title Enabled! Kingston is offline
    MemberRank
    Jun 2007 Join Date
    601Posts

    Re: [Help]Warning in gm panel

    Quote Originally Posted by rodanio14 View Post
    Girbicid pro phper =DD
    All I See iis that u spam in topic's calling other people fuckers , noobs , stupid and other shit. have some respect here..Help this kid....wait i forgot u don't know shit about gunz servers.

  13. #13
    Account Upgraded | Title Enabled! sexy fire slash is offline
    MemberRank
    Oct 2007 Join Date
    Canada B.C. Currently A Developer.Location
    553Posts

    Re: [Help]Warning in gm panel

    Hahahahaha.

    Yeah.

    Owell Back On Topic....

    Need Anymore Help In Anythign Ron?

    If You Do Add My Msn sexy-fire-slash@hotmail.com

  14. #14
    人◕ ‿‿ ◕人 Forean is offline
    MemberRank
    Jul 2008 Join Date
    1,183Posts

    Re: [Help]Warning in gm panel

    mine says

    Deprecated: Call-time pass-by-reference has been deprecated in C:\AppServ\www\GMCP\ajax\sql.php on line 23

    the code is

    Code:
    while( $this->temp = odbc_fetch_into ( $this->result , & $this->counter )){

  15. #15
    Member nubbynub is offline
    MemberRank
    Jun 2007 Join Date
    75Posts

    Re: [Help]Warning in gm panel

    Failure bump......

  16. #16
    人◕ ‿‿ ◕人 Forean is offline
    MemberRank
    Jul 2008 Join Date
    1,183Posts

    Re: [Help]Warning in gm panel

    Cool?

    lawl



Advertisement