Cronwerks MCCode/MCCodes Forums

Please login or register.

Login with username, password and session length


News:

After purchasing with us the download link will be delivered to your forum message box.


AuthorTopic: OC logs not posting in gang or member events  (Read 322 times)

ReignFire

  • Basic Member
  • *
  • Reputation Power: 36
  • ReignFire has no influence.
  • Offline Offline
  • Posts: 56
    • View Profile
OC logs not posting in gang or member events
« on: November 13, 2009, 12:51:08 PM »
anybody fix this already?
Logged

ReignFire

  • Basic Member
  • *
  • Reputation Power: 36
  • ReignFire has no influence.
  • Offline Offline
  • Posts: 56
    • View Profile
Re: OC logs not posting in gang or member events
« Reply #1 on: November 13, 2009, 02:16:04 PM »
i added...


include "global_func.php";


and got this

<b>QUERY ERROR:</b> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNIX_TIMESTAMP(),0,'Your Gang''s Organised Crime Succeeded. Go <a href=''oclog.p' at line 1<br />
   Query was INSERT INTO events VALUES('',,UNIX_TIMESTAMP(),0,'Your Gang''s Organised Crime Succeeded. Go <a href=''oclog.php?ID=30''>here</a> to view the details.')
Logged

Danny696

  • Excellent Member
  • ***
  • Reputation Power: 276
  • Danny696 has a powerful will.Danny696 has a powerful will.Danny696 has a powerful will.Danny696 has a powerful will.Danny696 has a powerful will.Danny696 has a powerful will.Danny696 has a powerful will.
  • Offline Offline
  • Posts: 457
    • View Profile
Re: OC logs not posting in gang or member events
« Reply #2 on: November 13, 2009, 02:29:18 PM »
Post the event_add query please
Logged
My Game: GraveYard; Madness || Projects; N/A -  Available for work. Please IM/PM me.

ReignFire

  • Basic Member
  • *
  • Reputation Power: 36
  • ReignFire has no influence.
  • Offline Offline
  • Posts: 56
    • View Profile
Re: OC logs not posting in gang or member events
« Reply #3 on: November 13, 2009, 02:44:38 PM »

$db
->query("INSERT INTO oclogs VALUES ('',{$r['ocID']},{$r['gangID']}, '$log', 'success', $muny, '{$r['ocNAME']}', unix_timestamp())");
Logged

ReignFire

  • Basic Member
  • *
  • Reputation Power: 36
  • ReignFire has no influence.
  • Offline Offline
  • Posts: 56
    • View Profile
moving forward
« Reply #4 on: November 13, 2009, 03:05:57 PM »
i got past that last error...now im here

<b>QUERY ERROR:</b> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''UNIX_TIMESTAMP()',0,'Your Gang''s Organised Crime Succeeded. Go <a href=''oclog' at line 1<br />
   Query was INSERT INTO events VALUES('',,'UNIX_TIMESTAMP()',0,'Your Gang''s Organised Crime Succeeded. Go <a href=''oclog.php?ID=34''>here</a> to view the details.')

i believe this is an error in global_func.php but im not sure what exactly
Logged

ReignFire

  • Basic Member
  • *
  • Reputation Power: 36
  • ReignFire has no influence.
  • Offline Offline
  • Posts: 56
    • View Profile
Re: OC logs not posting in gang or member events
« Reply #5 on: November 13, 2009, 04:18:47 PM »
i fixed it and didnt know it....LOL!!!! ok so i made an accidental code edit in global func when i was looking around...replaced it with the original code and the original code for the hour cron....once i added

include "global_func.php"
in to the hour cron it began to function correctly...yay me!
Logged