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

lukyjay...can u help me edit a sabhms logo and upload let me downloadS??cause i dun have photo shop programs...=(thanks

Wow it looks really awesome! Great job dude!

And my first name is Jay! I guess this must be made for me (not literally). xD

Code:

---

<a href="javascript:lukyjayatgmaildotcom('login.php');">Login/Logout</a><br />

---

By the way why is there your 'email' in there? What is this for anyway? (I don't really know Java so enlighten me! Variable name or something? XD)

Anyway. My server is up but the world server and login server displays red. Shouldn't it supposed to be green?

Quote:

---

Originally Posted by bboydunk

Wow it looks really awesome! Great job dude!

And my first name is Jay! I guess this must be made for me (not literally). xD

Code:

---

<a href="javascript:lukyjayatgmaildotcom('login.php');">Login/Logout</a><br />

---

By the way why is there your 'email' in there? What is this for anyway? (I don't really know Java so enlighten me! Variable name or something? XD)

Anyway. My server is up but the world server and login server displays red. Shouldn't it supposed to be green?

---

Had to think of a name for the function, and i figure this way it gives credit to me incase someone is rude enough to delete the footer credits :)

If its red and your server is up, please edit config.php with your servers public IP address, and if necessary the ports.

Quote:

---

Originally Posted by xiaoliew

lukyjay...can u help me edit a sabhms logo and upload let me downloadS??cause i dun have photo shop programs...=(thanks

---

http://img34.picoodle.com/img/img34/...1m_247a62c.png

lukyjay, could you help me edit the register script? I'm getting

Quote:

---

Field 'banreason' doesn't have a default value

---

Prolly cos I did this MySQL script? (I'm using NubStory's repack btw. If you need to take a look at my tables PM me. I'll send you my SQL script file.

Code:

---

ALTER TABLE `skills` ADD COLUMN `masterlevel` INTEGER UNSIGNED NOT NULL DEFAULT 0 AFTER `skilllevel`;

---

Oh and can I have a custom made banner similar to the one you made above for SABHMS? I want it to be "HT-MS". ;)

everytime i try to log in i get this "You didnt input valid login details or a hacking attempt was detected." can you help me?


oo yea and i get this WARNING on my page "mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php"

Hi,

I would like to ask, can you tell me on how did you host your CMS on an external site without me connecting to hamachi? because, I've tried to host your CMS on a webhost. However there had been error. Is there a tutorial somewhere?

Regards.

Quote:

---

Originally Posted by boi2gangsta

everytime i try to log in i get this "You didnt input valid login details or a hacking attempt was detected." can you help me?


oo yea and i get this WARNING on my page "mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php"

---

You need to recheck your config.php

Make sure you input your details in the 2 locations it says too.

Quote:

---

lukyjay, could you help me edit the register script? I'm getting

---

Execute this query:

Code:

---

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

---

Also see attached for logo

Quote:

---

Originally Posted by xiaochris

Hi,

I would like to ask, can you tell me on how did you host your CMS on an external site without me connecting to hamachi? because, I've tried to host your CMS on a webhost. However there had been error. Is there a tutorial somewhere?

Regards.

---

You would need to edit your MySQL settings to allow remote access.

Strongly recommend you don't do that.

You should only host it on the hosters PC unless your an expert and know 100% what you are doing.

fixed.

looks good, nice and simple.
-thumbs up for you-

~dXm

Quote:

---

Originally Posted by lukyjay

You need to recheck your config.php

Make sure you input your details in the 2 locations it says too.

---

lukyjay. I don't think it is due to config.php. This is I think due to this statement

- > $result = mysql_query("SELECT title, content FROM jcmss_news ORDER BY newsid DESC LIMIT 0, 10");

Where jcmss_news does not exist. Therefore there has been error.

I am also having this error. Therefore I am not sure how to go about solving this problem. Do I have to create tables?

ive checked everything in my config.php idk wats rong

<?php
//-----------Database Login--------------------------------------\\
$host['host'] = 'localhost';//MySQL location (Keep it localhost unless you know what your doing!)
$sql_host = "localhost"; //Same as above
$host['user'] = 'root'; //MySQL username
$sql_user = "root"; //Same as above
$host['pass'] = ''; //MySQL password
$sql_pass = ""; //Same as above
$host['dbname'] = 'odinms'; //Database name
$sql_db = "odinms"; //Same as above
//-----------MS Server Details-----------------------------------\\
$serverip = "5.16.7.9"; //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);

//---------------------------------------------------------------\\
?>

Quote:

---

Originally Posted by darkXmatt

looks good, nice and simple.
-thumbs up for you-

~dXm

---

Thank you very much =)

Quote:

---

Originally Posted by boi2gangsta

ive checked everything in my config.php idk wats rong

---

Quote:

---

Originally Posted by xiaochris

lukyjay. I don't think it is due to config.php. This is I think due to this statement

- > $result = mysql_query("SELECT title, content FROM jcmss_news ORDER BY newsid DESC LIMIT 0, 10");

Where jcmss_news does not exist. Therefore there has been error.

I am also having this error. Therefore I am not sure how to go about solving this problem. Do I have to create tables?

---

Have both of you read and followed readme.txt? Including running install.php then deleting it?

where do we run the install.php?

Quote:

---

Originally Posted by boi2gangsta

where do we run the install.php?

---

http://<yourip:8080/install.php>

Quote:

---

Originally Posted by lukyjay

Execute this query:

Code:

---

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

---

Also see attached for logo

---

I received this error from MySQL Query Browser.

Quote:

---

Incorrect integer value: '' for column 'banreason' at row 1

---

Any idea?

Cool you should make one with gothic like

v0.6 Comming tommorow with luck, so far I have completely redone the installation system, no file edits and sql queries should be neccessary, also have changed some files to make it easier for people to create their own styles. All that is left for me to do for v0.6 is finish the Configuration page that is located in the AdminCP.

Quote:

---

Originally Posted by Pmang

Cool you should make one with gothic like

---

I dont design graphics, i just program and code :)

Quote:

---

Originally Posted by bboydunk

I received this error from MySQL Query Browser.


Any idea?

---

This might be happening because your trying to set the default value, but you have already got rows that have no value (if that make sense :P)
What happens when you execute this:

Code:

---

UPDATE accounts SET banreason = '0' WHERE banreason = '';

---

Quote:

---

Originally Posted by lukyjay

I dont design graphics, i just program and code :)


This might be happening because your trying to set the default value, but you have already got rows that have no value (if that make sense :P)
What happens when you execute this:

Code:

---

UPDATE accounts SET banreason = '0' WHERE banreason = '';

---

---

Managed to execute it with it telling me something like the last three lines were affected. I tried to register again and it give me an error saying the same thing. Banreason doesn't have a default value.

Quote:

---

Originally Posted by bboydunk

Managed to execute it with it telling me something like the last three lines were affected. I tried to register again and it give me an error saying the same thing. Banreason doesn't have a default value.

---

Oh sorry, I ment, run the code i just said

Code:

---

UPDATE accounts SET banreason = '0' WHERE banreason = '';

---

then you should be able to run

Code:

---

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

---

without any errors :)

I still get "banreason doesn't have a default value!".

>.<

I'm using Sean's repack btw.

You must be doing something wrong...

Okay, in MySQL query browser, right click Accounts table and go edit table, then select the banreason column and at the bottom choose the tab column details next to Default Value there is an empty box, next to the empty box there is a button that says NULL. Click that, click apply and vualla.

Code:

---

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

---

Code:

---

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

---

Andy helped me with this. Settled everything. (: Just informing you so you can keep this for the records for future reference.

* accidental double post *

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

everyone that is getting a problem to work this I made the mistake of not putting the port. You need to put the port in the config.php so it will say:

host = localhost:[port]