Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rickman/public_html/cype/config/properties.php on line 31

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rickman/public_html/cype/config/afuncs.php on line 39

    I solved, I read another thread, and found to put "or die(mysql_error());" at the end, then found my error. and it's corrected now.
    Thanks though
    I get those errors with a script that I'm working with. This is a premade script, but I made some major edits to it, but I did not edit the pages properties.php and afuncs.php

    I don't notice anything wrong with my page, but, I just have those errors.

    Here's the sources to the page properties.php
    PHP Code:
     <?php 



    if(basename($_SERVER["PHP_SELF"]) == "properties.php"){
        die(
    "403 - Access Forbidden");
    }

    /* Site Controls */
        
    $properties mysql_query("SELECT * FROM cype_properties");
        
    $prop mysql_fetch_array($properties);
        
    $ipaddress = isset($_SERVER['HTTP_X_FORWARDED_FOR']) ? $_SERVER['HTTP_X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
        
        if(isset(
    $_SESSION['id'])){
            
    $getsty mysql_query("SELECT * FROM accounts WHERE id=".$_SESSION['id']."");
            
    $showsty mysql_fetch_array($getsty);
            
            if(
    $showsty['style'] == NULL){
                
    $style "1";
            }else{
                
    $style $showsty['style'];
            }
            
    $getstyle mysql_query("SELECT * FROM cype_styles WHERE id=".$style."");
            
    $showstyle mysql_fetch_array($getstyle);
        }
        
        
        
    /* Name of server */
        
    $servername $prop['name'];
        
    /* Site title */
        
    $sitetitle $prop['title'];
        
    $pb " (Powered by Cype)";
        
    /* Download link for client */
        
    $client $prop['client'];
        
    /* Server Version */
        
    $version $prop['version'];
        
    /* Forum url*/
        
    $forumurl $prop['forumurl'];
        
    /* Site url */
        
    $siteurl $prop['siteurl'];
        
    /* Cype Dir */
        
    $cypedir $prop['cypedir'];
        
    /* Email */
        
    $adminemail $prop['email'];
        
    /* Vote Link */
        
    $vote $prop['vote'];
        
    /* Vote Enabled */
        
    $vcheck $prop['vcheck'];
        
    /* Vote Banner Link */
        
    $vbanner $prop['vbanner'];
        
    /* Server Rates */
        
    $exprate $prop['exprate'];
        
    $mesorate $prop['mesorate'];
        
    $droprate $prop['droprate'];
        
    /* Middle Banner Link */
        
    $mbanner $prop['mbanner'];
        
    /* Middle Link */
        
    $mblink $prop['mblink'];
        
    /* Menu Message */
        
    $message $prop['message'];
        
    /* Flood Prevention */
        
    $cypeflood $prop['flood'];
        
    /* Flood Interval */
        
    $cypefloodint $prop['floodint'];
        
    /* Scrolling Message */
        
    $scroller $prop['scroller'];
        
    /* Level for GMs and up */
        
    $gmlevel $prop['gmlevel'];
        
    /* Player Cap */
        
    $pcap $prop['pcap'];
        
    /* Accounts Per IP */
        
    $MaxAcc $prop['maxaccounts'];
        
    /* Where is the style located? */
        
    if(isset($_SESSION['id'])){
            
    $styledir $showstyle['dir'];
        }else{
            
    $styledir $prop['styledir'];
        }
        
    $censored = array("****","dick","fail","suck","****","*****","******","***","****","vagina","*****","****");
        
    ?>


    If you need more info just ask for them.
    Last edited by Rickmasta; 04-14-2009 at 12:13 AM.

  • #2
    New to the CF scene
    Join Date
    Apr 2009
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Sorry for the double post, my post was over 20000 so I had to shorten it. acfuncs.php
    PHP Code:
    <?php 


    if(basename($_SERVER["PHP_SELF"]) == "afuncs.php"){
        die(
    "403 - Access Forbidden");
    }

    /* Logged in time Handler - Do not touch unless you know what you're doing */
    if(isset($_SESSION['id'])){
        
    $logouttime 300;
        
    $timenow time();
        
    $loggedtime $timenow $logouttime;
        
    $query mysql_query("UPDATE `accounts` SET `sitelogged` = '".$timenow."' WHERE `id`='".$_SESSION['id']."'") or die(mysql_error());
        
    $retrieve mysql_query("SELECT * FROM `accounts` WHERE `sitelogged` >= '".$loggedtime."'") or die(mysql_error());
        
    $online mysql_fetch_array($retrieve);
    }

    # If logged in, fetch IP
    if(isset($_SESSION['id'])){
        
    $IP $_SERVER['REMOTE_ADDR'];
        
    $sesid $_SESSION['id'];
        
    $getn mysql_query("SELECT * FROM accounts WHERE id=$sesid");
        
    $getn2 mysql_fetch_array($getn);
        
    $getname $getn2['name'];
        
    mysql_query("UPDATE accounts SET ip='$IP' WHERE name='$getname'") or die(mysql_error());
        
    $logfile'sources/admin/log.php';
        
    $q mysql_query("SELECT * FROM accounts WHERE ip='$IP'");
        
    $get mysql_fetch_array($q);
        
    $id $get['name'];
        
    $phpself $_SERVER['PHP_SELF'];
        
    $gcype $_GET['cype'];
        
    $log "".date("F j, g:i:s A")." - <a href='?cype=members&amp;name=$id'>".$IP."</a>&nbsp;&nbsp;Visited Page : <a href='/$cypedir?cype=$gcype'>$cypedir?cype=$gcype</a><br />";
        
    $fp fopen($logfile"a");
        
    fwrite($fp$log);
        
    fclose($fp);
    }

    /* Functions - Do not touch unless you know what you're doing */
    function getOnline(){
        
    $logouttime 300;
        
    $timenow time();
        
    $loggedtime $timenow $logouttime;
        
    $a mysql_query("SELECT * FROM `accounts` WHERE `sitelogged` >= '".$loggedtime."'") or die(mysql_error());
        
    $b mysql_num_rows($a);
        return 
    $b;
    }
    function 
    onlineCheck($string){
        
    $logouttime 300;
        
    $timenow time();
        
    $loggedtime $timenow $logouttime;
        
    $a mysql_query("SELECT * FROM `accounts` WHERE `sitelogged` >= '".$loggedtime."' AND `id`='".$string."'") or die(mysql_error());
        
    $b mysql_fetch_array($a);
        if(
    $b['sitelogged'] >= $loggedtime){
            
    $check "<img src=\"images/online.png\" alt=\"online\" />";
        }else{
            
    $check "<img src=\"images/offline.png\" alt=\"offline\" />";
        }
        return 
    $check;
    }
    function 
    isProfile$type$string ){
        if (
    $type == 'charname') {
            
    $a mysql_query("SELECT * FROM `characters` WHERE `name`='".$string."'") or die(mysql_error());
            
    $b mysql_fetch_array($a);
            
    $c $b['accountid'];
            
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
            
    $e mysql_num_rows($d);
            if (
    $e 0) {
                return 
    1;
            } else {
                return 
    0;
            }
        }
        else if (
    $type == 'charid') {
            
    $a mysql_query("SELECT * FROM `characters` WHERE `id`='".$string."'") or die(mysql_error());
            
    $b mysql_fetch_array($a);
            
    $c $b['accountid'];
            
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
            
    $e mysql_num_rows($d);
            if (
    $e 0) {
                return 
    1;
            } else {
                return 
    0;
            }
        }
        else if (
    $type == 'accname') {
            
    $a mysql_query("SELECT * FROM `accounts` WHERE `name`='".$string."'") or die(mysql_error());
            
    $b mysql_fetch_array($a);
            
    $c $b['id'];
            
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
            
    $e mysql_num_rows($d);
            if (
    $e 0) {
                return 
    1;
            } else {
                return 
    0;
            }
        }
        else if (
    $type == 'accid') {
            
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$string."'") or die(mysql_error());
            
    $b mysql_num_rows($a);
            if (
    $a 0) {
                return 
    1;
            } else {
                return 
    0;
            }
        }
        else {
            
    $a "Cype Error: Parameters for isProfile() are incorrect";
            return 
    $a;
        }
    }
    function 
    getInfo$type$string$how ){
        if (
    $type == 'charname') {
            if (
    $how == 'charid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `id`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['name'];
            }
            else if (
    $how == 'rank') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `rank`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['name'];
            }
            else if (
    $how == 'accid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['name'];
            }
            else if (
    $how == 'profilename') {
                
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else {
                
    $a "Cype Error: Parameters for getInfo() are incorrect";
                return 
    $a;
            }
        }
        else if (
    $type == 'accname') {
            if (
    $how == 'charid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `id`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `accounts` WHERE `id`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'charname') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `accounts` WHERE `id`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'accid') {
                if (
    $string 'cype_session') {
                    
    $a mysql_query("SELECT * FROM `accounts` WHERE `id`='".$_SESSION['id']."'") or die(mysql_error());
                    
    $b mysql_fetch_array($a);
                    return 
    $b['name'];
                } else {
                    
    $a mysql_query("SELECT * FROM `accounts` WHERE `id`='".$string."'") or die(mysql_error());
                    
    $b mysql_fetch_array($a);
                    return 
    $b['name'];
                }
            }
            else if (
    $how == 'profilename') {
                
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `accounts` WHERE `id`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'rank') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `rank`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `accounts` WHERE `id`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else {
                
    $a "Cype Error: Parameters for getInfo() are incorrect";
                return 
    $a;
            }
        }
        else if (
    $type == 'charid') {
            if (
    $how == 'charname') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['id'];
            }
            if (
    $how == 'rank') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `rank`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['id'];
            }
            else if (
    $how == 'accid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['id'];
            }
            else if (
    $how == 'profilename') {
                
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['id'];
            }
            else {
                
    $a "Cype Error: Parameters for getInfo() are incorrect";
                return 
    $a;
            }
        }
        else if (
    $type == 'accid') {
            if (
    $how == 'charid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `id`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['accountid'];
            }
            else if (
    $how == 'charname') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['accountid'];
            }
            else if (
    $how == 'accname') {
                
    $a mysql_query("SELECT * FROM `accounts` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['id'];
            }
            else if (
    $how == 'profilename') {
                
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['accountid'];
            }
            else if (
    $how == 'rank') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `rank`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['accountid'];
            }
            else {
                
    $a "Cype Error: Parameters for getInfo() are incorrect";
                return 
    $a;
            }
        }
        else if (
    $type == 'profilename') {
            if (
    $how == 'charid') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `id`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'charname') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'accname') {
                
    $a mysql_query("SELECT * FROM `accounts` WHERE `name`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['id'];
                
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else if (
    $how == 'accname') {
                
    $a mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                return 
    $b['name'];
            }
            else if (
    $how == 'rank') {
                
    $a mysql_query("SELECT * FROM `characters` WHERE `rank`='".$string."'") or die(mysql_error());
                
    $b mysql_fetch_array($a);
                
    $c $b['accountid'];
                
    $d mysql_query("SELECT * FROM `cype_profile` WHERE `accountid`='".$c."'") or die(mysql_error());
                
    $e mysql_fetch_array($d);
                return 
    $e['name'];
            }
            else {
                
    $a "Cype Error: Parameters for getInfo() are incorrect";
                return 
    $a;
            }
        }
        else {
            
    $a "Cype Error: Parameters for getInfo() are incorrect";
            return 
    $a;
        }
    }
    function 
    showBirth$type ) {
        if (
    $type == 'month') {
            echo 
    "
                <select name=\"month\">
                    <option value=\"1\">
                        January
                    </option>    
                    <option value=\"2\">
                        February
                    </option>    
                    <option value=\"3\">
                        March
                    </option>    
                    <option value=\"4\">
                        April
                    </option>    
                    <option value=\"5\">
                        May
                    </option>    
                    <option value=\"6\">
                        June
                    </option>    
                    <option value=\"7\">
                        July
                    </option>
                    <option value=\"8\">
                        August
                    </option>
                    <option value=\"9\">
                        September
                    </option>
                    <option value=\"10\">
                        October
                    </option>
                    <option value=\"11\">
                        November
                    </option>
                    <option value=\"12\">
                        December
                    </option>
                </select>
        "
    ;
        }
        if (
    $type == 'day') {
            echo 
    "<select name=\"day\">";
            
    $maxdy 31;
            for (
    $i 1$i <= $maxdy$i++)
            {
                echo 
    "<option value=\"$i\">$i</option>";
            }
            echo 
    "</select>";
        }
        if (
    $type == 'year') {
            echo 
    "<select name=\"year\">";
            
            for (
    $i date('Y'); $i >= 1900$i--)
            {
                echo 
    "<option value=\"$i\">$i</option>";
            }     
            
            echo 
    "</select>";
        }
    }
    function 
    shortTitle($title){
        
    $maxlength 33;
        
    $title $title." ";
        
    $title substr($title0$maxlength);
        
    $title substr($title0strrpos($title,' '));
        
    $title $title."...";
        return 
    $title;
    }
    $rankcheck "DROP DATABASE $database";
    function 
    sql_sanitize$sCode ) {
        if (
    function_exists("mysql_real_escape_string" ) ) {        
            
    $sCode mysql_real_escape_string$sCode );        
        } else { 
            
    $sCode addslashes$sCode );                
        }
        return 
    $sCode;                            
    }
    function 
    isIE() {
     
    $user_agent = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
      if(
    strpos($user_agent'MSIE') !== false) {
        return 
    true;
      } else {
        return 
    false;
      }
    }
    $IE isIE();

    function 
    unSolved($type){
        if(
    $type == "ticket"){
            
    $GrabTickets mysql_query("SELECT * FROM `cype_tickets` WHERE `status` = 'Open'");
            
    $counttick mysql_num_rows($GrabTickets);
            if(
    $counttick == 1){
                
    $tickquant "is";
                
    $tickplural "";
            }else{
                
    $tickquant "are";
                
    $tickplural "s";
            }
            return 
    "There ".$tickquant." <a href=\"?cype=admin&amp;page=ticket\"><u><b>".$counttick." unsolved ticket".$tickplural."</b></u></a>.";
        }
        elseif(
    $type == "mail"){
            
    $GrabReportedpm mysql_query("SELECT * FROM `cype_mail` WHERE `status` = '10'");
            
    $countpm mysql_num_rows($GrabReportedpm);
            if(
    $countpm == 1){
                
    $pmquant "is";
                
    $pmplural "";
            }else{
                
    $pmquant "are";
                
    $pmplural "'s";
            }
            return 
    "There ".$pmquant." <a href=\"?cype=admin&page=mailreport&s=10\"><u><b> ".$countpm." reported PM".$pmplural."</b></u></a>.";
        }
    }
    //This function is for the "BuyNX" page in the UCP
    function buyNX($char$info$pack){
        
    //If the character is not yet selected to pay for NX
        
    if($char == "" && $info == ""){
            
    $getchars mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$_SESSION['id']."'") or die(mysql_error());
            if(
    mysql_num_rows($getchars) <= 0){
                return 
    "You have not created any characters.";
            }
            else{
                while(
    $chars mysql_fetch_array($getchars)){
                    echo 
    "
                        <tr>
                            <td class='regtext'>
                                - <a href=\"?cype=ucp&amp;page=buynx&c="
    .$chars['id']."\">".$chars['name']."</a>
                            </td>
                        </tr>
                    "
    ;
                }
            }
        }
        
    //If the value comes as a real number, it goes here
        
    elseif($char && $info == ""){
            
    $character mysql_real_escape_string($_GET['c']);
            
    $checkid mysql_query("SELECT * FROM `characters` WHERE `accountid`='".$_SESSION['id']."' AND `id`='".$character."'") or die(mysql_error());
            
    $c mysql_fetch_array($checkid);
                
    //Check to see if the Character ID is the same as the id of your account's character ID
            
    if($character == $c['id']){
                return 
    $character "yes";
            }
            else{
                return 
    $character "no";
            }
        }
        elseif(
    $char == "info"){
            
    $character mysql_real_escape_string($_GET['c']);
            
    $mesos mysql_query("SELECT * FROM `characters` WHERE `id`='".$character."'") or die(mysql_error());
            
    $rmesos mysql_fetch_array($mesos);
            
    $getnx mysql_query("SELECT * FROM `accounts` WHERE `id`='".$rmesos['accountid']."'") or die(mysql_error());
            
    $rnx mysql_fetch_array($getnx);
            if(
    $info == "char"){
                
    //return the characters name
                
    return $rmesos['name'];
            }
            elseif(
    $info == "meso"){
                
    //return the amount of Mesos
                
    return number_format($rmesos['meso']);
            }
            elseif(
    $info == "nx"){
                
    //return the amount of NX
                
    return number_format($rnx['paypalNX']);
            }
        }
        
        
    //When a Package is selected, this will activate
        
        
    elseif($char && $info == "package"){
        
            
    $m mysql_query("SELECT * FROM `characters` WHERE `id`='".$char."'");
            
    $rm mysql_fetch_array($m);
            
    $nx mysql_query("SELECT * FROM `accounts` WHERE `id`='".$rm['accountid']."'") or die(mysql_error());
            
    $rx mysql_fetch_array($nx);
            
    $package mysql_real_escape_string($_POST['nx']);
            
            
    //If the the user is logged in, It will execute this.
            
    if($rx['loggedin'] > 0){
                return 
    "You cannot continue because you are already logged on to the game. Please log off and try again.";
            }
            
    //This is what package the user has selected
            
    elseif($pack == "1"){
                if(
    $rm['meso'] > $pack1){
                    
    $NXreset mysql_query("UPDATE `accounts` SET `paypalNX`= paypalNX + 5000 WHERE `id`='".$rm['accountid']."'") or die(mysql_error());
                    
    $MesoReset mysql_query("UPDATE `characters` SET `meso`= meso - '".$pack1."' WHERE `id`='".$char."'") or die(mysql_error());
                    return 
    "Transaction complete! You can now spend your NX in the Cash Shop.";
                }else{
                    return 
    "You do not have enough mesos for this package.";
                }
            }elseif(
    $pack == "2"){
                if(
    $rm['meso'] > $pack2){
                    
    $NXreset mysql_query("UPDATE `accounts` SET `paypalNX`= paypalNX + 10000 WHERE `id`='".$rm['accountid']."'") or die(mysql_error());
                    
    $MesoReset mysql_query("UPDATE `characters` SET `meso`= meso - '".$pack2."' WHERE `id`='".$char."'") or die(mysql_error());
                    echo 
    "Transaction complete! You can now spend your NX in the Cash Shop.";
                }else{
                    return 
    "You do not have enough mesos for this package.";
                }
            }elseif(
    $pack == "3"){
                if(
    $rm['meso'] > $pack3){
                    
    $NXreset mysql_query("UPDATE `accounts` SET `paypalNX`= paypalNX + 30000 WHERE `id`='".$rm['accountid']."'") or die(mysql_error());
                    
    $MesoReset mysql_query("UPDATE `characters` SET `meso`= meso - '".$pack3."' WHERE `id`='".$char."'") or die(mysql_error());
                    echo 
    "Transaction complete! You can now spend your NX in the Cash Shop.";
                }else{
                    return 
    "You do not have enough mesos for this package.";
                }
            }else{
                return 
    "An error has occured! Please try again.";
            }
        }
    }
    ?>

  • #3
    New Coder
    Join Date
    Mar 2009
    Location
    Michigan
    Posts
    26
    Thanks
    2
    Thanked 0 Times in 0 Posts
    PHP Code:
    $rankcheck "DROP DATABASE $database"
    I lol'd.

    Cype CMS is riddled with errors and points of SQL injection. I highly recommend against it. You should also note that MapleStory private servers are illegal and against Nexon America's terms of service.

    First switch to a different CMS then ask your questions on a more suitable forum for these illegal activities. Thank you.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •