nonstop daily missions

[boionfire81]

[uSER=70347]NonStopCoding[/uSER] I get this error on 80% of page views. it will literally only appear 80% of the time on the same page, and appears on pages not involved with the mod. Critical Error

A critical error has occurred, and page execution has stopped. Below are the details:

1054: Unknown column 'timeleft' in 'field list'

Action taken: Attempted to execute query: INSERT INTO `user_missions` (`task_one`,`task_two`,`task_three`,`task_four`,`t ask_five`,`task_six`,

`task_seven`,`task_eight`,`user`,`timeleft`,`mID`)

VALUES('Crimes','Attacks','strength','guard',

'agility','labour','Levels','Busts',

'1','86400','1')

Edited April 12, 2016 by boionfire81
updated to tag

[microsocket]

I guess your SEO skills cannot help you in this matter. :)

[boionfire81]

Man microsocket, don't start. I said, I'm learning php and website security. That I am NOT the smartest in those situations. BUT SEO is my specialty, do not test me on it.

And with the hell breaking lose on my website right, that comment was unneeded.

I'll stop sharing resources to help you guys out if THAT is what makes you guys happy, as that was the point of the other post. But in the meantime this is basically the support forum for mccodes, so no offense, if you can't help, don't start something.

[AdamHull]

Check to see if time left is in the table.if not run

 ALTER TABLE user_missions ADD timeleft INT(11);

into phpmyadmin

[boionfire81]

It exists. But my server has a serious issue. They want to say it's mccodes fault. But cPanel came up 500 earlier. Now my crons are running every 30 seconds. All of them >.<

[sniko]

I guess your SEO skills cannot help you in this matter. :)

 

[uSER=72582]boionfire81[/uSER] - What is the full query error?

[Zettieee]

What file is this error from?

If it's from staff_missions you need to change user_mission to daily_mission

[boionfire81]

[uSER=70347]NonStopCoding[/uSER] just sent me an updated version. Will check it and get back with you if needed. Thanks.

[NonStopCoding]

yes i need to update the version on mccodes marketplace.

the new version removed the use of timeleft and other stuff will upload the updated version to market place now

[boionfire81]

if(array_key_exists('choose', $_GET) {

 

come up error Parse error: syntax error, unexpected '{'

[Dominion]

if(array_key_exists('choose', $_GET) {

 

come up error Parse error: syntax error, unexpected '{'

You only close one bracket but open 2. One on the if() and one on array_ket_exists()

[boionfire81]

Dude, I didn't write it. but good catch. I didn't even see that.

[NonStopCoding]

well spotted missing a closing )

 

if(array_key_exists('choose', $_GET)) {