[Znote AAC] Simple news system

[K_ingen]

To edit delete just go to phpmyadmin znote_news table..

But I want and I need to be able to do it from the website because I have other people that got to be able to do that...

 

[Raggaer]

I will release it today or tomorrow with edit options.,

 

[Evilone244]

Awesome job on the news system, here I was just about to code one my self then I run into yours... Saved me some time of coding haha.

 

[Sirion_Mido]

how i can add news !!!!

 

[Raggaer]

go to yourpage.com/addnews.php
You must be admin of the website

 

[Impacto Certero]

im sorry, i am recently learning how to configurate an sql server and i have a trouble adding a new in my localhost page, it says

Table 'otserv.znote_news' doesn't exist

also i cant add a query in my otserv database, can someone help me to do that, please ?

 

[Raggaer]

go to localhost/phpmyadmin
select your database, click on the SQL tab
paste this

CREATE TABLE IF NOT EXISTS `znote_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `body` text NOT NULL,
  `date` date NOT NULL,
  `author` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ;

and enter it,

 

[Impacto Certero]

go to localhost/phpmyadmin
select your database, click on the SQL tab
paste this

CREATE TABLE IF NOT EXISTS `znote_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(20) NOT NULL,
  `body` text NOT NULL,
  `date` date NOT NULL,
  `author` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 ;

and enter it,

thanks you're a genius <3

 

[Luciano]

Sorry for the bump, but it isnt working
Tried another template, but here what's more weird:
If i replace your index with my old index, the news show up correctly, but i cant add them anymore.
Take a look:
DarkBird OT
Thats with your index.php :s

 

[Raggaer]

Take a look at your database znote_news table, maybe you are using the now integrated znote news system

 

[Luciano]

Take a look at your database znote_news table, maybe you are using the now integrated znote news system

Found a fix, deleting the old znote_news table and re-creating it with your code worked
Thanks

 

[Niioxce]

im just getting these D: help?

 

[murat65]

Notice: Undefined index: body in C:\xampp\htdocs\index.php on line 9

Notice: Undefined index: author in C:\xampp\htdocs\index.php on line 11

Server - posted on 2014 - by

 

[murat65]

Nobody here who can help... ?

 

[Raggaer]

Why dont just use Znote news system? :3 this is very outdated

 

[CharlesHudson]

No database selected :C

 

[clouf]

No database selected :V

 

[jrloureiro]

No changelogs submitted.string(165) "SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'n.text' in 'field list'

 

[God Mythera]

No changelogs submitted.string(165) "SELECT `n`.`id`, `n`.`title`, `n`.`text`, `n`.`date`, `p`.`name` FROM `znote_news` AS `n` INNER JOIN `players` AS `p` ON `n`.`pid` = `p`.`id` ORDER BY `n`.`id` DESC;"
(query - SQL error)
Type: select_multi (select multiple rows from database)

Unknown column 'n.text' in 'field list'

same...

 

[HalfAway]

same...

Row n.text do not exist.

You can use the standard ZnoteAAC news system instead this was created long time ago.