mccode-v2 100% Working Copy Enhanced Schooling

[Uridium]

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]

[Uridium]

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

[Uridium]

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..

[MarFur93]

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling

Looks good to me, waiting for crons.

[Lithium]

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

;)

[Strats]

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling

Looks brilliant!

[Mike09]

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

[gideon prewett]

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

[Uridium]

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.

[Uridium]

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

[cody4camp]

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.

[Uridium]

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. :)

[Uridium]

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.

[Danny696]

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

[gideon prewett]

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

[inferno564]

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

[Uridium]

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.

[Uridium]

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.

[Uridium]

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.

[inferno564]

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

[Uridium]

Re: [MCCODES V2] 100% Working Copy Enhanced Schooling

Ooops sorry about that Inferno yes hes right the USERS should be cpercent

 

Thanks matey :)

[gideon prewett]

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

[Sindikit]

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?

[Sindikit]

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

[Uridium]

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;