Jump to content
MakeWebGames

Courses - Free up resources


sniko
 Share

Recommended Posts

Following on from

Database Table Design

 

This will help save resources, as said in the article above;

1. Run this SQL

 

2. Open up education.php

3. Find this query

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

4. Replace with

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

5. Replace this snippet

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

6. With

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

7. Save education.php

8. Open cron_day.php

9. Find;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

10. Replace with;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

11. Find;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

12. Replace with;

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

And that's it...

-sniko

Edited by sniko
Thanks Illusions for your reply!
Link to comment
Share on other sites

your Table shows as users_courses yet some parts refer to users_course

Just too make people aware..

 

6. line 5 needs editing from cdays to crDAYS

10. needs to be users_courses

12. need to be users_courses

Thanks for spotting those!

** Illusions ** sorry for editing this post but i had to change 12

Edited by illusions
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.

 Share

×
×
  • Create New...