/lenasys/trunk

To get this branch, use:
bzr branch http://gegoxaren.bato24.eu/bzr/lenasys/trunk

« back to all changes in this revision

Viewing changes to codeigniter/application/models/admin/admin_model.php

  • Committer: Gustav Hatvigsson
  • Date: 2013-05-07 08:05:14 UTC
  • mfrom: (53.2.2 lenasys)
  • Revision ID: gustav.hartvigsson@gmail.com-20130507080514-u53zto672m0t19wl
merded the new salting stuff for the user passwords and stuff...

Show diffs side-by-side

added added

removed removed

Lines of Context:
codeigniter/application/models/admin/admin_model.php
69
69
                        );
70
70
 
71
71
                $this->db->insert('Categories', $data); 
72
 
                //mkdir("../courses/".$cid."/".$example);
 
72
                mkdir("../courses/".$cid."/".$categoryName);
73
73
 
74
74
        }
75
75
 
91
91
                        );
92
92
 
93
93
                $this->db->insert('subcategories', $data); 
94
 
                //mkdir("../courses/".$cid."/".$example);
 
94
                mkdir("../courses/".$cid."/".$categoryName."/".$subCategoryName);
95
95
 
96
96
        }
97
97
 
100
100
                return $query->result();
101
101
        }
102
102
 
 
103
        function getQuizzes($cid, $categoryName, $subCategoryName) {
 
104
                $query = $this->db->get_where('Quizzes', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));
 
105
                return $query->result();
 
106
        }
 
107
 
103
108
        function addExample($cid, $categoryName, $subCategoryName, $example, $description){
104
109
                $this->db->select_max("orderNr");
105
110
                $query = $this->db->get_where('examples', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName));
114
119
                        );
115
120
 
116
121
                $this->db->insert('Examples', $data); 
117
 
                mkdir("../courses/".$cid."/".$example);
118
 
 
119
 
        }
120
 
 
121
 
        function getPages($cid, $example) {
122
 
                $query = $this->db->get_where('Pages', array("courseID" => $cid, "exampleName" => $example));
123
 
                return $query->result();
124
 
        }
125
 
 
126
 
        function addPage($cid, $example, $page){
127
 
                $data = array(
128
 
                        'courseID' => $cid ,
129
 
                        'exampleName' => $example,
130
 
                        'pageName' => $page
131
 
                        );
132
 
 
133
 
                $this->db->insert('Pages', $data); 
134
 
                mkdir("../courses/".$cid."/".$example."/".$page);
135
 
 
136
 
                $data = array(
137
 
                        'fileName' => $cid."/".$example."/".$page."/documentation",
138
 
                        'codeLanguage' => $file->lang,
139
 
                        'fileType' => $file->type,
140
 
                        'dataBlob' => $output
 
122
 
 
123
                $data = array(
 
124
                        'fileName' => $cid."/".$categoryName."/".$subCategoryName."/".$example."/documentation",
 
125
                        'codeLanguage' => "text",
 
126
                        'fileType' => "text",
 
127
                        'dataBlob' => ""
141
128
                        );
142
129
 
143
130
                $this->db->insert('Files', $data); 
144
131
 
145
132
                $data = array(
146
 
                        'fileName' =>  $cid."/".$example."/".$page."/documentation"  ,
147
 
                        'pageName' => $page,
 
133
                        'fileName' => $cid."/".$categoryName."/".$subCategoryName."/".$example."/documentation",
 
134
                        'categoryName' => $categoryName,
 
135
                        'subCategoryName' => $subCategoryName,
148
136
                        'exampleName' => $example,
149
 
                        'courseID' => $cid
 
137
                        'courseID' => $cid,
 
138
                        'columnNr' => 1,
 
139
                        'orderNr' => 1
150
140
                        );
151
141
 
152
 
                $this->db->insert('PageFiles', $data); 
 
142
                $this->db->insert('Containers', $data); 
 
143
                mkdir("../courses/".$cid."/".$categoryName."/".$subCategoryName."/".$example);
153
144
 
154
145
        }
155
146
 
156
 
        function updatePage($cid, $example, $page, $documentation, $files){
 
147
        function updateExample($cid, $categoryName, $subCategoryName, $example,  $documentation, $files){
157
148
 
158
149
                $filearr = json_decode($files);
159
150
 
160
151
                foreach ($filearr as $file) {
161
152
                        $output = "";
162
 
                        $handle = @fopen("../courses/".$cid."/".$example."/".$page."/".$file->filename, "r");
 
153
                        $handle = @fopen("../courses/".$cid."/".$categoryName."/".$subCategoryName."/".$example."/".$file->filename, "r");
163
154
                        if ($handle) {
164
155
 
165
156
                                while (($buffer = fgets($handle, 4096)) !== false) {
177
168
                        }
178
169
                        
179
170
                        $data = array(
180
 
                                'fileName' => $file->filename ,
 
171
                                'fileName' => $cid."/".$categoryName."/".$subCategoryName."/".$example."/".$file->filename ,
181
172
                                'codeLanguage' => $file->lang,
182
173
                                'fileType' => $file->type,
183
174
                                'dataBlob' => $output
185
176
 
186
177
                        $this->db->insert('Files', $data); 
187
178
 
 
179
                        $this->db->select_max("orderNr");
 
180
                        $query = $this->db->get_where('containers', array("courseID" => $cid, "categoryName" => $categoryName, "subCategoryName" => $subCategoryName, "exampleName" => $example, "columnNr" => $file->columnNr));
 
181
                        $result = $query->result();
 
182
 
188
183
                        $data = array(
189
 
                                'fileName' =>  $file->filename  ,
190
 
                                'pageName' => $page,
 
184
                                'fileName' => $cid."/".$categoryName."/".$subCategoryName."/".$example."/".$file->filename ,
 
185
                                'categoryName' => $categoryName,
 
186
                                'subCategoryName' => $subCategoryName,
191
187
                                'exampleName' => $example,
192
 
                                'courseID' => $cid
 
188
                                'courseID' => $cid,
 
189
                                'columnNr' => $file->columnNr,
 
190
                                'orderNr' => $result[0]->orderNr+1
193
191
                                );
194
192
 
195
 
                        $this->db->insert('PageFiles', $data); 
 
193
                        $this->db->insert('Containers', $data); 
196
194
                }
197
195
 
198
196
                $data = array(
199
197
                        'dataBlob' => $documentation
200
198
                        );
201
199
 
202
 
                $this->db->where("fileName",$cid."/".$example."/".$page."/"."documentation" );
 
200
                $this->db->where("fileName",$cid."/".$categoryName."/".$subCategoryName."/".$example."/documentation");
203
201
                $this->db->update('Files', $data); 
204
202
                
205
203
 
206
204
        }
207
205
 
208
 
        function uploadFile($files, $cid, $example, $page){
209
 
                if(move_uploaded_file($files['tmp_name'], "../courses/".$cid."/".$example."/".$page."/".$files['name'])){
 
206
        function uploadFile($files, $cid, $categoryName, $subCategoryName, $example){
 
207
                if(move_uploaded_file($files['tmp_name'], "../courses/".$cid."/".$categoryName."/".$subCategoryName."/".$example."/".$files['name'])){
210
208
                        echo json_encode(array('status'=>'File was uploaded successfuly!'));
211
209
                }       
212
210
        }