• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Illumina CMS [PHP, OOP, Phoenix/Butterfly, Updated]

Status
Not open for further replies.

Jax

C# Programmer
Joined
Dec 11, 2009
Messages
881
Reaction score
431
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Thanks for sharing Jonty.

You always contribute something great, within the cms area. (Uber 2, LightCMS etc...)

Appreciate it. :):
 
Experienced Elementalist
Joined
Jul 14, 2011
Messages
258
Reaction score
43
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

LightCMS MySQLi Engine Error
Unknown column 'acc_pornbanned' in 'field list'

Hmm .. ? :(
 
Divine Celestial
Loyal Member
Joined
Jun 26, 2011
Messages
819
Reaction score
338
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Mirrors:




P.S - If anyone get's an error on the staff page, with unknown column position, run this SQL query;

Code:
[SIZE=2]ALTER TABLE `users` ADD `position` VARCHAR(30) NOT NULL[/SIZE]

Also, anyone got the 'acc_pornbanned' error? I don't know whether this is the right code, but it worked for me.

Code:
[SIZE=2]ALTER TABLE `users` ADD `acc_pornbanned` TEXT NOT NULL[/SIZE]

XarOWf6 - Illumina CMS [PHP, OOP, Phoenix/Butterfly, Updated] - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Last edited:
Experienced Elementalist
Joined
Jul 14, 2011
Messages
258
Reaction score
43
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

zMagenta Thank you :)
 
Elite Diviner
Joined
Nov 25, 2012
Messages
494
Reaction score
44
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I would use this if it had another index, because i hate the default Uber index -.-
 
Zephyr Studios
Loyal Member
Joined
Feb 18, 2012
Messages
1,877
Reaction score
724
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I would use this if it had another index, because i hate the default Uber index -.-
It's Jonty's Habbo index edit, so It's the default UberCMS 2 index. :)
 

Jax

C# Programmer
Joined
Dec 11, 2009
Messages
881
Reaction score
431
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I would use this if it had another index, because i hate the default Uber index -.-

You can easily change the index.
 
Divine Celestial
Loyal Member
Joined
Jun 26, 2011
Messages
819
Reaction score
338
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

I would use this if it had another index, because i hate the default Uber index -.-
5 minutes work;

SNk4WlA - Illumina CMS [PHP, OOP, Phoenix/Butterfly, Updated] - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Elite Diviner
Joined
Aug 18, 2012
Messages
414
Reaction score
141
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Once again, a big thank you to you Jonteh.

Thanks, JustTime :)
 
Junior Spellweaver
Joined
Jun 11, 2010
Messages
172
Reaction score
14
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Just a quick question Jonty, why would this query results in Array and not the rank of the user?
PHP:
global $db;
$getRank = $db->query("SELECT rank FROM users WHERE username = '" . $username . "'");
$rank = $getRank->fetch_assoc();
echo $rank;
 
Joined
Apr 28, 2010
Messages
2,794
Reaction score
1,178
Re: [REL] Illumina CMS [PHP, OOP, MySQLi, Uber 3]

Just a quick question Jonty, why would this query results in Array and not the rank of the user?
PHP:
global $db;
$getRank = $db->query("SELECT rank FROM users WHERE username = '" . $username . "'");
$rank = $getRank->fetch_assoc();
echo $rank;

You're fetching the 'associative' array. You need to get the result..
 
Status
Not open for further replies.
Back
Top