Staff Apps Event

[Jameoo]

Hi It Sends Out The Event But It Dosent Got From Events ( 0 ) to Events ( 1 )

For App Accept

$_GET['ID'] = abs((int) $_GET['ID']);

mysql_query("DELETE FROM staffapps WHERE appID={$_GET['ID']}",$c);

mysql_query("UPDATE users SET user_level='{$_GET['staff']}' WHERE userid='{$_GET['user']}'",$c);

mysql_query("INSERT INTO mail VALUES('1', 1, 'System', '{$_GET['user']}', unix_timestamp(),'Your application' ,'Congrats, your application has been reviwed and you are now a staff member. Please view our rules so you do not loose this job.')",$c);

Updated

It Dosent Do The Same For App Deny

 

$_GET['ID'] = abs((int) $_GET['ID']);

mysql_query("DELETE FROM staffapps WHERE appID={$_GET['ID']}",$c);

mysql_query("INSERT INTO mail VALUES('', 0, 'System', '{$_GET['user']}', unix_timestamp(),'Your application' ,'Our staff has reviewed your staff application and unfortunately we feel you are not qualified to be a staff member. Feel free to fill in another application.')",$c);

[Guest Anonymous]

Re: Staff Apps Event

Well it won't do anything to the event counters as you are not sending an event.

DELETE FROM staffapps ...

UPDATE users ...

INSERT INTO mail ...

Nope, I see no event table mentioned there...

Perhaps... you should increment the new_mail field in the users table? Just a suggestion of course ;)

[Jameoo]

Re: Staff Apps Event

so whats the code to updat the event to Events (1)

[Guest Anonymous]

Re: Staff Apps Event

Just of the top of my head... (not that it will help as you are not sending an event) something along the lines of updating the new_events field in the users table?

[Jameoo]

Re: Staff Apps Event

please can you help me with this please as i dont know notting about updating

[Guest Anonymous]

Re: Staff Apps Event

I'm not writing your code for you ... There are plenty of examples inside your source on this.

Do a little search in the forums, or even your own sources for the keyword new_events or new_mail.

A simple bit of research by looking at your users table in phpMyAdmin (or it's equivalent) will yield some interesting snippets of information. Try changing a value here and there. phpMyAdmin even gives you SQL code and a mechanism for producing PHP code directly for a specified query.

[Jameoo]

Re: Staff Apps Event

its only 1 line tut tut

[Guest Anonymous]

Re: Staff Apps Event

Yes, I know it's only line.. That's my point. If it were a complex entity, I'd be more inclined to look out my copy of V1/V2, check the field and table names are write a small demo, or at least draft the relevant SQL scripts.

Learning by rote is not an ideal method. Learning by trial and error, and discovering the features within your source will make you a far better programmer.

[fbiss]

Re: Staff Apps Event

 

Yes, I know it's only line.. That's my point. If it were a complex entity, I'd be more inclined to look out my copy of V1/V2, check the field and table names are write a small demo, or at least draft the relevant SQL scripts.

Learning by rote is not an ideal method. Learning by trial and error, and discovering the features within your source will make you a far better programmer.

Agreed!