[RELEASE] FlareCMS V14 - Odin & Vana

[zekesamaz]

Thanks, although I thought you put the download and such into a mysql db too, or is that not done? If you can make me the tables for download, staff, etc. I can make the configuration for it because I don't know much about MySQL.

[SOChaos]

It's not done yet, But I can make the Tables for them real quick... All you need to do is add the fields to get_mysql_info.php and change the way it reads in the files...

CREATE TABLE `downloads` (
  `id` int(4) NOT NULL auto_increment,
  `title` varchar(250) NOT NULL,
  `desc` varchar(250) NOT NULL,
  `url` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE `faqs` (
  `id` int(4) NOT NULL auto_increment,
  `question` varchar(250) NOT NULL,
  `answer` varchar(250) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



CREATE TABLE `staff` (
  `id` int(4) NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  `position` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Those are the tables I started on. The rest should be easy for you

[zekesamaz]

I have a question, varchar(number), does it mean the maximum amount of characters allowed in the column?

[SOChaos]

Yessem... I know I put crazy amounts, lmfao.

[zekesamaz]

Actually I set the news one to 999 or something xP
I'll make the configuration admin cp stuff later, for V15 or something, I feel so lazy today, I'll just look for bugs and upload V14.

[SOChaos]

That's cool, I'll see what I can do about more progress on the forum and such... I'd really like to get it done soon. Add meh on MSN~! Lmfao. I'd like to help more on this :)

[zekesamaz]

I don't really go on MSN though o_o
Updated front, ignore the V13 image thing, it's V14 now

[xStarlightx]

I know that before we had to execute 2 things in our mysql before we could make new accounts.

Is it possible it is working for you zeke, because you already executed them whereas anyone starting with a new slate so to speak - still needs to do so?

[SOChaos]

Ah, I see.. Haven't added the SQL stuff yet? Ifnot, that's good. Gives me more time to fix my stuff up xD

And what messenger DO you go on.

EDIT: Starlight.. Those SQL Tables have nothing to do with the making of accounts.. O_O Those are just the Comments and News posts.

[zekesamaz]

Nope haven't added it yet. I'll get around to it tomorrow unless you're going to do something else. Btw, I don't go on any other messenger except MSN, I just said I don't go on it a lot, I still go on it sometimes though o_o

@starlight, I used the odinms.sql for rev 988 or something. Can you post your .sql if you didn't use that one?

[SOChaos]

Then send me your MSN in a private message Lmfao. It's easier than waiting for a reply on here O_O.

[zekesamaz]

Umm ok, I'll just add you. But it's my school account (contacts are from school), I lost my online account and I'm too lazy to make one haha.

[xStarlightx]

@SoChaos: I wasn't talking about the ones included here. ;) Thus my point to it all.

@zekesamaz: I am currently trying cionade's repack since I wanted to completely wipe my server and save me a bit of time. I WAS using rev 988 previously and the reg. page I used then worked fine. Let me go try this version of yours with my rev 988 backup and see if that helps. If that is all it takes I'll just stick with my 988 and add everything myself. <3

Will let you know shortly.

EDIT: It works with my other database. Thank you very much. ^_^

[zekesamaz]

Yeah I checked his repack, it's rev 978 so the password checking method is different.

[James Renard]

please tell me how i can get it middle the sitew on left of my screen and admin cp dont work