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

ooh this looks cool xD ill try it

Hey no problem guys!

Be sure to post any feedback, suggestions or bugs!

I will in the future implement rankings and a character CP.

Currently I'm kinda busy with school as next week is my last week of uni for that certificate, then i need to choose to go do another certificate or job. Hopefully job ^^ Wish me luck!

Even though I'm busy I will do my best to fix any bugs ASAP.

how come i keep getting an error
Fatal error: Call to undefined function mysql_connect() in C:\wamp\www\functions\config.php on line 19

Man, can't anyone make a CMS that wont rape bandwidth?

Quote:

---

Originally Posted by 1aznboii

how come i keep getting an error
Fatal error: Call to undefined function mysql_connect() in C:\wamp\www\functions\config.php on line 19

---

Please go into the functions/config.php file with notepad, and edit the settings :) They must be pointing to your MySQL database.

Quote:

---

Originally Posted by wafles

Man, can't anyone make a CMS that wont rape bandwidth?

---

I'm planning on using server sided caching queries for version 1. Like i said, this is BETA :)

The theme looks out of place. You should try to create one yourself, or try to get someone to make one for you that's somehow maple related. Although, everything else is pretty dandy I guess.

Out of place? I think its nice looking, and childish (Like Maplestory theme) so i thought it fit the category best :) I didnt know of any other theme to use and I am not good with photoshop myself =P

why cant i get this to work for me?
I get this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 171

Have you edited config.php?

Have to executed the queries in first post?

can you make 1 the name is PhoenixMS to me?

THX =D

In the Extra's folder there is a small PSD that can let you edit your logo. :)

http://img187.imageshack.us/img187/8835/logo01fv5.png

I have edited the config and used the queries. It doesn't work.here is my config:


<?php
//-----------Database Login--------------------------------------\\
$host['host'] = 'localhost'; // my host
$host['user'] = 'root'; // my database username
$host['pass'] = ''; // my database password
$host['dbname'] = 'odinms'; // my database name
//-----------MS Server Details-----------------------------------\\
$serverip = "74.186.200.49"; //Replace with your IP if public
$loginport = "7575"; //Login Port (Usually 7575)
$worldport = "8484"; //World Port (Usually 8484)
$sql_db = "odinms"; //Database Name (Usually odinms)
$sql_host = "localhost"; //Database Host
$sql_user = "root"; //Database User
$sql_pass = ""; //Database Password
//-----------Style-----------------------------------------------\\
$offline = "<font color =red>&bull;</font>"; //Offline server
$online = "<font color = green>&bull;</font>"; //Online server
//-----------Dont Touch This-------------------------------------\\
$db = mysql_connect($host['host'], $host['user'], $host['pass']) OR die ('Check your config.php');
mysql_select_db($host['dbname'], $db);
//---------------------------------------------------------------\\
?>
I always have my settings setup like that but no CMS ever works
the only one that the registration and ranking actually worked was the maple content management system >.>


EDIT: I got it working I have to put :(port) after the local hosts XD stupid me
one other question. how do i change the forum link to an actual site?

When I try to register an account, I get this message.

"Field 'banreason' doesn't have a default value"
Can anyone help?

Note: I'm using "NubStory_Repack_0.4" for my server, in case that's needed.

Read my help desk.

Quote:

---

Originally Posted by darkphoenix

I have edited the config and used the queries. It doesn't work.here is my config:


<?php
//-----------Database Login--------------------------------------\\
$host['host'] = 'localhost'; // my host
$host['user'] = 'root'; // my database username
$host['pass'] = ''; // my database password
$host['dbname'] = 'odinms'; // my database name
//-----------MS Server Details-----------------------------------\\
$serverip = "74.186.200.49"; //Replace with your IP if public
$loginport = "7575"; //Login Port (Usually 7575)
$worldport = "8484"; //World Port (Usually 8484)
$sql_db = "odinms"; //Database Name (Usually odinms)
$sql_host = "localhost"; //Database Host
$sql_user = "root"; //Database User
$sql_pass = ""; //Database Password
//-----------Style-----------------------------------------------\\
$offline = "<font color =red>&bull;</font>"; //Offline server
$online = "<font color = green>&bull;</font>"; //Online server
//-----------Dont Touch This-------------------------------------\\
$db = mysql_connect($host['host'], $host['user'], $host['pass']) OR die ('Check your config.php');
mysql_select_db($host['dbname'], $db);
//---------------------------------------------------------------\\
?>
I always have my settings setup like that but no CMS ever works
the only one that the registration and ranking actually worked was the maple content management system >.>


EDIT: I got it working I have to put :(port) after the local hosts XD stupid me
one other question. how do i change the forum link to an actual site?

---

My msn is lukyjay@gmail.com

Quote:

---

Originally Posted by Dakure

When I try to register an account, I get this message.

"Field 'banreason' doesn't have a default value"
Can anyone help?

Note: I'm using "NubStory_Repack_0.4" for my server, in case that's needed.

---

Execute this SQL query:

ALTER TABLE `accounts` MODIFY COLUMN `banned` TINYINT(1) DEFAULT NULL;

And tell me if it works

Quote:

---

Originally Posted by Dakure

When I try to register an account, I get this message.

"Field 'banreason' doesn't have a default value"
Can anyone help?

Note: I'm using "NubStory_Repack_0.4" for my server, in case that's needed.

---

Execute this SQL query:

ALTER TABLE `accounts` MODIFY COLUMN `banned` TINYINT(1) DEFAULT NULL;

And tell me if it works

Version 0.5 is released! Please read first post for information.

Version 0.5.1 replaced 0.5 because it included a few fixes for bugs my BETA testers found.

how to read psd fileS?? i wan to edit a SabahMS logo..
hmm..i dont even know how to edit the index.php..cause i have to change those rate and intro my server =(
hmm..
can teach me how to edit??

im getting this error:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking.php on line 172

is there anyway to not show GM's on the ranking?

Quote:

---

Originally Posted by lukyjay

Execute this SQL query:

ALTER TABLE `accounts` MODIFY COLUMN `banned` TINYINT(1) DEFAULT NULL;

And tell me if it works

---

hey i tried that but it still didint work and im usign odin source

can't download version 5 , upload on rapidfire?

Alot of dots....o.o

Quote:

---

Originally Posted by wedoboop

hey i tried that but it still didint work and im usign odin source

---

Sorry i made a typo. By deleting the two tables jcmss_config and jcmss_news, then running install.php and deleting install.php, your problem should be fixed as I addressed this rare issue in v0.5

Alternativly you can manually fix it by executing the command:

ALTER TABLE `accounts` MODIFY COLUMN `banreason` TINYINT(1) DEFAULT NULL;

Quote:

---

Originally Posted by xiaoliew

how to read psd fileS?? i wan to edit a SabahMS logo..
hmm..i dont even know how to edit the index.php..cause i have to change those rate and intro my server =(
hmm..
can teach me how to edit??

---

You need photoshop to edit the PSD.

To edit the rates it must be done manually, version 0.6 (next release) will have an option to do it in the AdminCP. :)

Quote:

---

Originally Posted by wedoboop

im getting this error:Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\ranking.php on line 172

is there anyway to not show GM's on the ranking?

---

Did you get that error after editing this page? Noone else gets this error ;)

I can make it not display GM's on the ranking next version (v0.6) Sorry It isnt in 0.5

Quote:

---

Originally Posted by icyfrog007

can't download version 5 , upload on rapidfire?

---

http://www.uploading.com/files/URA08...0.5.1.zip.html

Quote:

---

Originally Posted by Heavenstenshi

Alot of dots....o.o

---

Where? o.o"