JCMSS - V0.5 - Most secure and stable script - AdminCP and UserCP

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Program Files\Abyss Web Server\htdocs\index.php on line 172

And the players online is wrong. I have around 5ppl - 10 ppl online but it says 0.

Any help?

Edited:
I've fixed the player online thingy, now im left with the warning.

Edited again:
Hmmm. I can't seem to login to the website with all my admin accounts. Weird.

Quote:

---

Originally Posted by testing321123

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in D:\Program Files\Abyss Web Server\htdocs\index.php on line 172

And the players online is wrong. I have around 5ppl - 10 ppl online but it says 0.

Any help?

Edited:
I've fixed the player online thingy, now im left with the warning.

Edited again:
Hmmm. I can't seem to login to the website with all my admin accounts. Weird.

---

Your config musnt be right?

How did you fix the online thing.

This is for OdinMS, not vana or Titan.

Quote:

---

Originally Posted by lukyjay

lolwut? What does macs have to do with anything, you didnt get any error relating to the macs column, from what i can see o.o

---

Well it does actually. I executed the first code,

Code:

---

ALTER TABLE `accounts` MODIFY COLUMN `banreason` TEXT NULL DEFAULT NULL;

---

and tried registering and it told me something about 'macs'.

Code:

---

ALTER TABLE `accounts` MODIFY COLUMN `macs` TINYTEXT NULL DEFAULT NULL;

---

After executing the second it went well. ;)

Quote:

---

Originally Posted by bboydunk

and tried registering and it told me something about 'macs'.

---

Lol the reason i couldnt fix it, is because you didnt tell me :smurf:

Quote:

---

Originally Posted by lukyjay

Your config musnt be right?

How did you fix the online thing.

This is for OdinMS, not vana or Titan.

---

Yep im using SeanPack(OdinMS source)

Just went inside index.php and dig through. Then i spotted something.
The online users ur using right now, it looks at "1". Which means those who are attempting to login and not Logged in. Change it to "2".

By the way, do I have to do something to the files to get my forum up or do you not have a php forum in it? Or is it meant to link it to a free-forum host?

Ohh, please wait for V1.0, hopefully release tommorow, it fixes 99% of your questions :)

As for forums, its very easy to setup your own PHPbb forum :)

i try dis on me server but it give me no result for this? i typ in my weebsite in internet and it say 404 no found? wat wrong i not so god with computer i from brazil

Quote:

---

Originally Posted by inzann

i try dis on me server but it give me no result for this? i typ in my weebsite in internet and it say 404 no found? wat wrong i not so god with computer i from brazil

---

roflmao, try rebooting your computer. If that doesnt work, try rebooting another 3 times.

Hmm why did you removed the copyright in the footer?

It is obvious that you didn't make the template.

You can find it in pixel2life and free templates websites.

It works now, I don't knw what I did wrong but I removed it and installed it again and it works! =D

Quote:

---

Originally Posted by locolijo

Hmm why did you removed the copyright in the footer?

It is obvious that you didn't make the template.

You can find it in pixel2life and free templates websites.

---

Erm, i gave credits to the template maker in the footer. When did i say that i made the template? If you got nothing nice to say about my stuff in my threads, go back to grinding on your laggy server.

v1.1 is now released!

Hope you guys like the new installation system, its very awesome! You don't have to edit a single file!

If you make an account on the registration page, make sure the password is at least 6 characters long, or maplestory won't let you log in. Im using .55

Will add it for v1.2 :)

Hi im having trouble installing im using the right info to install but when i go to install it comes up with this..

I cannot connect to the database!');\n"); fwrite($open, "mysql_select_db(\$host['dbname'], \$db);\n"); fwrite($open, "?>"); print "I have created your config.php!"; print 'Click here to continue installation process'; ?>

and then when i click the "click here"

and proceed to go to my website it comes up blank with text on it


'.$row['Servername'].''; echo '

'.$row['welcomemsg'].'
'; } ?>

"; echo "
" .$row['title']. "
"; echo "

" .$row['content']. "
"; echo "
"; } ?>





i know it sayc cannot connect to datebase but im using the right info..

btw i dunno if using Seanpack has anything to do with this tho..

lol no worries. im using sean 5.9 and i got the exact error this morning. make sure you put in your database information correctly, and if you did, id suggest you use a fresh copy of jcmss. my AIM is lingo1244 if you want to contact me there.

when i try and install it using http://<yourip:8484/install.php> it downloads another install.php wat do i do with that?

Edit:nvm found out wat i did rong lol

Quote:

---

Originally Posted by boi2gangsta

when i try and install it using http://<yourip:8484/install.php> it downloads another install.php wat do i do with that?

Edit:nvm found out wat i did rong lol

---

My script doesnt download anything =P

Is it just me or does it not come with a config.php?

it says i cant login... info mismatch or hacking attempt has been detected

the sha512 encryption thingy with the newer rev odinms, well not very new now, messes up all the stuff. if you want to recode your login_do.php, first fetch the username login, then query the mysql database for the salt value for that username, concoct the user input password with the salt value, and sha512 hash the whole value, and compare the output to the password for the user inside the database. aim me lingo1244 if you need clarification or something. also, if you want, i could get you a copy of my login_do.php to help you fix it if you dont want to recode it yourself.

imma try with TitanMS

Quote:

---

Originally Posted by aimsucks0917

Is it just me or does it not come with a config.php?

---

it's just you lol. when you first put the files into your htdocs folder, go to your web browser -> http://localhost/install/index.php -> fresh install -> fill out information -> press submit -> follow instructions to delete your install folder.

then go to your htdocs folder, and config.php should be under the functions folder. :)

PHP Code:

---

<?php session_start(); ?>
<title>Logging in...</title>
<?php
    include('config.php');

    $name = $_POST['username'];
    $pass = $_POST['password'];

    // Extract SALT information for user account name
    $querys = sprintf("SELECT salt FROM accounts WHERE name='%s'",
    mysql_real_escape_string($name));
    $resultss = mysql_query($querys);
    while ($rows = mysql_fetch_array($resultss)) {
    extract($rows);
    $salt=$salt;
    }
    
    if( $salt == null ) {
    $sha512 = sha1($_POST['password']);
    } else { 
    $endpass = $pass.$salt; //concoct user input password with SALT value
    $sha512 = hash('sha512', $endpass); //hash endpass into sha512
    }
    


    $query = sprintf("SELECT id, name, password, gm FROM accounts WHERE name='%s' AND password='%s'",
    mysql_real_escape_string($name),
    mysql_real_escape_string($sha512));
    
    $result = mysql_query($query);
    $row = mysql_fetch_assoc($result);
    if( mysql_num_rows($result) != 0 ) { //success
        $_SESSION['login_id'] = $row['id'];
        $_SESSION['login_user'] = $name;
        $_SESSION['login_pass'] = $sha512;
        $_SESSION['gm'] = $row['gm'] == 1 ? 1 : 0;
        echo "<center>You're now signed in!</center>";
        exit;
    } else {                             //failure
        echo 'You didnt input valid login details or a hacking attempt was detected.';
    }

?>

---

Replace everything inside your login_do.php with this to correct all login problems, including hack attempts, cant login, etc etc.

It's just a minor modification to lukyjay's code. hope it helps:D