jpoke5 Posted January 26, 2009 Posted January 26, 2009 I have v2 and when i try and edit a job rank i get this error that i dont know how to fix. Anyone know how to fix this? im not very good at php. Thanks!! 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 'jrID=6' at line 1 Query was UPDATE jobranks SET jrNAME='1cabby', jrJOB = 5, jrPAY= 25, jrIQG=1, jrLABOURG=3, jrSTRG=2, jrIQN=10, jrLABOURN=10, jrSTRN=10WHERE jrID=6 my code You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Dave Posted January 26, 2009 Posted January 26, 2009 Re: Help with edit job rank. job.php When you edit a job in staff panel? cause if so we would need your staff file not this one. Quote
Tonka Posted January 26, 2009 Posted January 26, 2009 Re: Help with edit job rank. job.php fix is pretty simple find the edit query and put a space before the "WHERE" in the query Quote
jpoke5 Posted January 26, 2009 Author Posted January 26, 2009 Re: Help with edit job rank. job.php that did it, thanks guys!! Quote
DeaTH_RideR Posted January 29, 2009 Posted January 29, 2009 Re: Help with edit job rank. job.php im only posting here cause the thread is related to what im looking for so here goes.i was wondering if someone would be nice enough to tell me how i can chnge the cap for the jobs, as in how much i can pay or how much stat gains players can get . thanks any help would be very helpful Quote
blue- Posted January 29, 2009 Posted January 29, 2009 Re: Help with edit job rank. job.php Change the (INT) on the table to (BIGINT) ? Could be wrong? Quote
DeaTH_RideR Posted January 29, 2009 Posted January 29, 2009 Re: Help with edit job rank. job.php i will try that thanks for the fasy and helpful reply. 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.