- Joined
- Oct 28, 2008
- Messages
- 1,557
- Reaction score
- 368
ALTER table users ADD column seckey VARCHAR(999);
CREATE TABLE IF NOT EXISTS `cms_news` (
`id` int(11) NOT NULL,
`title` text NOT NULL,
`image` text NOT NULL,
`shortstory` text NOT NULL,
`longstory` text NOT NULL,
`author` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
INSERT INTO `cms_news` (`id`, `title`, `image`, `shortstory`, `longstory`, `author`) VALUES
(1, 'Welcome to prjBorden', 'attention_topstory.png', 'Introduction to using prjBorden', 'Welcome to <b>prjBorden</b><br>\r\n<br><br>\r\ndetails here\r\n\r\n<br>', 'Livar, prjBorden Developer');
ALTER TABLE `cms_news`
ADD PRIMARY KEY (`id`);
ALTER TABLE `cms_news`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Why are you mixing pascal case and camel case? Just pick one convention and stick with it.
Also good job on filtering the data when someone logs in or registers
Not really an issue regarding the cases, and on the filtering part - read the note in the main post.
function getUserVariable($username, $variable)
{
global $db;
$result = $db->prepare("SELECT `$variable` FROM `users` WHERE username = '$username'")->execute()->result();
return $result;
}
function getUserVariable($username, $variable)
{
global $db;
$result = $db->prepare("SELECT ? FROM `users` WHERE username = ? LIMIT 1")->bind_param($variable, $username)->execute()->result();
return $result;
}
Wow this sure needs some improvedments ... xDWhy are you mixing pascal case and camel case? Just pick one convention and stick with it.
Also good job on filtering the data when someone logs in or registers
Wow this sure needs some improvedments ... xD
Unless this was assembly it doesn't really matter much.
1337 programmers in this Habbo Hotel section will always give you poop for your own opinion.
I like you a lot.
Edit, can u all stop acting like this is finished, I clearly stated it isn't and it needs to be improved I.e. Filtering variables blabla,
you wouldn't even need to adjust the queries I'm using
Oh bloody hell,
1. Why your release something that isnt finished?
2. You mad because people are giving feedback on your code style? try to not take it negativ but positive.
it means you have to look at your codes and Improve It.
what????
What What in the bud
I wasn't taking anything negatively lol? I stated that it wasn't ready and it would be finished ready to use if someone bothered with it for an hour or two.
I know it's not anything amazing and there's ways to improve, but it's simple and efficient yet not procedural kind of.
It's good, just not joopie style lol lets be honest.
Edit, I just need critics From others so I know what to improve, so far you've suggested nothing.
1. Why your release something that isnt finished?