Richard Posted February 27, 2009 Posted February 27, 2009 Simple mod, allows users to ask questions to the staff. Staff can then send a reply back to them, Tested and works fine. Run SQL Data: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Create askstaff.php: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Delete-please Posted February 27, 2009 Posted February 27, 2009 Re: Ask Staff [Mccodes V2] nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) Quote
Lithium Posted February 27, 2009 Posted February 27, 2009 Re: Ask Staff [Mccodes V2] nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) They could, but this is more like a short approach to ingame ticketing. Well done once again! :) Quote
Richard Posted February 27, 2009 Author Posted February 27, 2009 Re: Ask Staff [Mccodes V2] nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) Yeah, I guess so :P I just prefer it like this to be honest, That way any member of staff can access the questions instead of just one. nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) They could, but this is more like a short approach to ingame ticketing. Well done once again! :) Thanks! Quote
Delete-please Posted February 27, 2009 Posted February 27, 2009 Re: Ask Staff [Mccodes V2] nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) Yeah, I guess so :P I just prefer it like this to be honest, That way any member of staff can access the questions instead of just one. nice mod :-D but couldn't people just use the mail box for this? +1 anyway :-) They could, but this is more like a short approach to ingame ticketing. Well done once again! :) Thanks! well its a sweet mod :) keep up the good work and yeah i guess its easier because all staff can respond to it so the question would be answered alot more faster :P Quote
Richard Posted February 27, 2009 Author Posted February 27, 2009 Re: Ask Staff [Mccodes V2] Thanks again Yubi, I always appreciate feedback and opinions :) Quote
BoGFx Posted February 28, 2009 Posted February 28, 2009 Re: Ask Staff [Mccodes V2] Hey, could you help me out with this? I understand everything but "Run the SQL" .. What exactly does that mean? Sorry for being stupid, ha. Quote
Richard Posted February 28, 2009 Author Posted February 28, 2009 Re: Ask Staff [Mccodes V2] Just run that data in phpmyadmin Quote
MyGunWars Posted February 28, 2009 Posted February 28, 2009 Re: Ask Staff [Mccodes V2] How Do We Answer The Questions. Quote
Richard Posted February 28, 2009 Author Posted February 28, 2009 Re: Ask Staff [Mccodes V2] Click the view questions link and post a responce Quote
bugsybunny Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] great mod, one problem, im trying to add an event so that once staff answer it, the member that asked the question gets an event saying it has been answered. event_add ($ir[`userid`], "Your question was answered in the ask staff section, please go there to see it."); thats the closest i got lol as you can all see its wrong, i really cant get it to work :( Quote
Lithium Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] great mod, one problem, im trying to add an event so that once staff answer it, the member that asked the question gets an event saying it has been answered. event_add ($ir[`userid`], "Your question was answered in the ask staff section, please go there to see it."); thats the closest i got lol as you can all see its wrong, i really cant get it to work :( add that line right before this and it should to the trick... You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
bugsybunny Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] great mod, one problem, im trying to add an event so that once staff answer it, the member that asked the question gets an event saying it has been answered. event_add ($ir[`userid`], "Your question was answered in the ask staff section, please go there to see it."); thats the closest i got lol as you can all see its wrong, i really cant get it to work :( add that line right before this and it should to the trick... You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. iv tried that before i asked for help, it sends the event to the person that ANSWERED the question, instead of the person that asked it. thats why im confused lol but thanks Quote
Lithium Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] $to = mysql_fetch_array(mysql_query(sprintf("SELECT `questionMember` FROM `staff_questions` WHERE `questionId` = '%u'", abs((int) $_POST['id'])))); event_add ($to[`questionMember`], "Your question was answered in the ask staff section, please go there to see it."); Add it on the same place i told first. i haven't looked at the code before :) Quote
bugsybunny Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] QUERY ERROR: 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 question was answered in the ask staff section, please ' at line 1 Query was INSERT INTO events VALUES('',,UNIX_TIMESTAMP(),0,'Your question was answered in the ask staff section, please go there to see it.') Quote
CrazyT Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] Try You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Lithium Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] hehe CrazyT's is right, with the rush i placed `instead of ' :) Quote
bugsybunny Posted August 27, 2009 Posted August 27, 2009 Re: Ask Staff [Mccodes V2] thank you so much guys :) you have saved me many headache's lol Quote
Velacan Posted October 24, 2009 Posted October 24, 2009 Re: Ask Staff [Mccodes V2] Well done Richard. This is a very nice/professional modification. Quote
Richard Posted May 1, 2010 Author Posted May 1, 2010 Thanks everyone for the nice comments, I will be updating this modification and creating a fully working V1 Version off it also. Quote
Zero-Affect Posted May 6, 2010 Posted May 6, 2010 CTRL + H Replace: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. With: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Issue being for example http://www.gameurl.com/ask_staff.php/”<iframe src=http://www.crimgame.com></iframe> should put the iframe in there. Quote
Djkanna Posted May 7, 2010 Posted May 7, 2010 You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. would work fine :) Quote
Zero-Affect Posted May 7, 2010 Posted May 7, 2010 good point the above is my old way i use a build_link function so never no issue on CG. Quote
Djkanna Posted May 7, 2010 Posted May 7, 2010 Fair enough both would work fine but for those fussy spacesavers __file__ would work :L Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.