Jump to content
MakeWebGames

Staff Apps Event


Jameoo

Recommended Posts

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);

Link to comment
Share on other sites

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 ;)

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...