Uridium Posted May 8, 2009 Posted May 8, 2009 Before i start i want to thank all those that have helped on this project. DAWG, TONKA, LITHIUM Ive made a few changes along the way from the previous one i posted so i'll throw up a few screenies for ya too look at whilst i get the script in order... THIS THREAD HAS BEEN UPDATED AND CAN BE FOUND HERE [mccode v2.x] [EDUCATION MOD] Totally Re-worked with many additional Options. [FINALLY COMPLETED CRONS AND SOME UPDATES] Quote
Uridium Posted May 8, 2009 Author Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling if your game already has the original schooling and users are still taking courses dont apply this script until they have all completed their schooling. ok SQLS You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. AND You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And add these to your users table You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Call this file staff_courses.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. PART 2 BELOW Quote
Uridium Posted May 8, 2009 Author Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling call this file education.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now open up mainmenu.php look for $mc=$ir['new_mail']; top of page and underneath that add $course=$ir['minus_clicks']; Now remove this link School Locate these lines You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And directly underneath add these You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Because this Doesnt need a cron to update the schooling you can either remove it from cron_day.php or just leave it... I'll post crons in a moment to update the clicks.. Quote
MarFur93 Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Looks good to me, waiting for crons. Quote
Lithium Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling One minor attention call... I haven't tested this but for the above code you state... You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. So, wouldn't be more correct to use only You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. instead You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. ? $course['whatever'] would be the way if you had something like $course = mysql_fetch_array(mysql_query("SELECT field1, field2, field3 FROM users WHERE userid = $userid"); ;) Quote
Strats Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Looks brilliant! Quote
Mike09 Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling I have seen a few of your modifications. They are all coded will and I have to say You amaze me! This should definitely be a paid mod! Keep up the good work Illusions. +1 Quote
gideon prewett Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling this looks like a really good mod +1 and another +1 for it being free the only thing ive found wrong so far is those 2 blank places in ut table why not add somthing else to fill the gaps like increseing brave and hp? just an idea to add to ur great mod Quote
Uridium Posted May 8, 2009 Author Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Im still doing the crons sorry for the delay but Sleep got the better of me and i woke up with one of my daughters lollipops stuck to the side of me face ;) You will need an hourly cron so i suupose you could do this yourself by adding this to cron_hour.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. call this school_cron.php for the daily updates You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Uridium Posted May 8, 2009 Author Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling You will probably find some references in this script that seem weird example the table coursestarted never gets a mention in the script this is me being brain dead it will in future updates have a purpose but at the time i just wanted to finish it the script. so i thought id leave it in for now.... regards the $search You could probably do it the way you mentioned but i wanted to make sure it was right the first time round so i chose the harder method lol Quote
cody4camp Posted May 8, 2009 Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling I have added this to my game, works like a fat charm ;) you also forgot to tell users how to put in staff panel. cant you just add that sql query to cron_day? how to add to staff menu: Open up smenu.php find shops add this above the shops config: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Uridium Posted May 8, 2009 Author Posted May 8, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Cheers Cody :) reason i didnt add the links cos they come as standard on V2 which saved me a bit of time renaming them but thanks for pointing it out to other that may not have the links :) Yeah you can add the daily clicks to the cron_day i just like to create a file so i dont mes things up on the cron_day as its 24 hours before you realise you have a bug. :) Quote
Uridium Posted May 9, 2009 Author Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Anyone using this mod! Can ya give me some feedback on its usuage, just really want to know if everythigs working and also if anyone had any further improvement ideas. Quote
Danny696 Posted May 9, 2009 Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling i have it on my game and when i add a new course it don't show up Quote
gideon prewett Posted May 9, 2009 Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling the only thing ive found wrong so far is those 2 blank places in ur table why not add somthing else to fill the gaps like increseing brave and hp? just an idea to add to ur great mod Quote
inferno564 Posted May 9, 2009 Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Schooling 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 '' at line 1 Query was SELECT * FROM inventory WHERE inv_userid=1 and inv_itemid= please how do you fix this? education.php Quote
Uridium Posted May 9, 2009 Author Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling in the admin panel when adding a new course you must specify an item from the list you want to use as a prize. i did test this about 20 times before i made it public and it worked every time. Quote
Uridium Posted May 9, 2009 Author Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling the only thing ive found wrong so far is those 2 blank places in ur table why not add somthing else to fill the gaps like increseing brave and hp? just an idea to add to ur great mod yeah that can be done also i didnt add hp or brave as my desicion was that people would just abuse the system for their own gains. Quote
Uridium Posted May 9, 2009 Author Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling i have it on my game and when i add a new course it don't show up can you set me up an admin account on your game and PM me the details I wont Messwith anything other than the schooling. Quote
inferno564 Posted May 9, 2009 Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling oh i found the problem in your sql provided it says ALTER TABLE users ADD crpercent INT (11) NOT NULL default 0; ALTER TABLE users ADD course_clicks INT (11) NOT NULL default 18; ALTER TABLE users ADD minus_clicks INT (11) NOT NULL default 0; ALTER TABLE users ADD clickend INT (11) NOT NULL default 0; but in the php it says cpercent so i just edited the sql and +1 for mod Quote
Uridium Posted May 9, 2009 Author Posted May 9, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Ooops sorry about that Inferno yes hes right the USERS should be cpercent Thanks matey :) Quote
gideon prewett Posted May 11, 2009 Posted May 11, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling i have recently added a free mod to ce http://criminalexistence.com/ceforums/i ... ic=28955.0 (v2 upgrade hosp time) and thought as a idea for ur mod u could add a corse to up hosp time Quote
Sindikit Posted May 11, 2009 Posted May 11, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO courses VALUES(NULL, 'test course', 'test descr', 'test start', 'test end', '1', '1', '3', '1', '5', '', '', '', '', '1', '1', '1', '1', '1') When I try to add a course, I get this. Any ideas? Quote
Sindikit Posted May 11, 2009 Posted May 11, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling Ok, here's the error now that I added a few of the missing lines in the initializing code..I think percent, perclick, etc were missing: QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO courses VALUES(NULL, 'test course', 'test descr', 'test start', 'test comp', '1', '100', '3', '1', '5', '0', '10', '18', '3', '1', '1', '1', '1', '1') Quote
Uridium Posted May 11, 2009 Author Posted May 11, 2009 Re: [MCCODES V2] 100% Working Copy Enhanced Schooling SQLS for courses. including my setup You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. USERS SQLS ALTER TABLE users ADD cpercent INT ( 11 ) NOT NULL DEFAULT 18; ALTER TABLE users ADD course_clicks INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD minus_clicks INT ( 11 ) NOT NULL DEFAULT 0; ALTER TABLE users ADD clickend INT ( 11 ) NOT NULL DEFAULT 0; 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.