00001 <?
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012
00013
00014
00015
00016
00017
00018
00019
00020
00021
00022
00023
00024
00025
00026
00027
00028
00029
00030
00031
00032 function getNavigation($kid, $tip){
00033 if ($tip == 'general'){
00034
00035 $query_parent = "SELECT parent_id, kat_naslov
00036 FROM linkovi_kategorije
00037 WHERE kat_id = '$kid'";
00038 }
00039 elseif ($tip == 'personal'){
00040 $query_parent = "SELECT parent_id, pkat_naslov
00041 FROM linkovi_personal_kategorije
00042 WHERE pkat_id = '$kid'";
00043 }
00044
00045 $result_parent = mysql_query($query_parent);
00046 $row_parent = mysql_fetch_array($result_parent);
00047 $pid = $row_parent[0];
00048
00049 if ($pid!=0){
00050 $naziv .= getNavigation($pid, $tip);
00051 }
00052
00053 $naziv .= "/<a href=\"linkovi.php?tip=".$tip."&kid=".$kid."\">".$row_parent[1]."</a>";
00054
00055 return $naziv;
00056 }
00057
00058
00059
00060
00061 function getParent($kid){
00062
00063 $query_parent = "SELECT parent_id, pkat_naslov
00064 FROM linkovi_personal_kategorije
00065 WHERE pkat_id = '$kid'";
00066
00067
00068 $result_parent = mysql_query($query_parent);
00069 $row_parent = mysql_fetch_array($result_parent);
00070 $pid = $row_parent[0];
00071
00072 if ($pid!=0){
00073 $naziv .= getParent($pid);
00074 }
00075
00076 $naziv .= "/".$row_parent[1];
00077
00078 return $naziv;
00079 }
00080
00081
00082
00083
00084
00085 function linkoviStart($id){
00086
00087 $query = "SELECT kat_id, kat_naslov, kat_opis
00088 FROM linkovi_kategorije
00089 WHERE parent_id = 0";
00090
00091 $result = mysql_query($query) or die(mysql_error());
00092 if (mysql_num_rows($result)==0){
00093 $note_general = _NOGENERALLINKS;
00094
00095 }
00096 else {
00097 $brojac = 0;
00098 while ($row = mysql_fetch_array($result)){
00099 $link_general[$brojac][0] = $row[0];
00100 $link_general[$brojac][1] = $row[1];
00101 $link_general[$brojac][2] = $row[2];
00102 $brojac++;
00103 }
00104 }
00105
00106 $query_personal = "SELECT pkat_id, pkat_naslov, pkat_opis
00107 FROM linkovi_personal_kategorije
00108 WHERE parent_id = 0
00109 AND student_id = '$id'";
00110
00111 $result_personal = mysql_query($query_personal) or die(mysql_error());
00112 if (mysql_num_rows($result_personal)==0){
00113 $note_personal = _NOPERSONALLINKS;
00114
00115 }
00116 else {
00117 $brojac_personal = 0;
00118 while ($row_personal = mysql_fetch_array($result_personal)){
00119 $link_personal[$brojac_personal][0] = $row_personal[0];
00120 $link_personal[$brojac_personal][1] = $row_personal[1];
00121 $link_personal[$brojac_personal][2] = $row_personal[2];
00122 $brojac_personal++;
00123 }
00124 }
00125 printLinkoviStart($link_general, $brojac, $link_personal, $brojac_personal, $note_general, $note_personal);
00126 }
00127
00128
00129
00130
00131
00132 function linkoviPrikaz($tip, $kid, $id){
00133 if ($tip == "general"){
00134 $query_sub = "SELECT kat_id, kat_naslov, kat_opis
00135 FROM linkovi_kategorije
00136 WHERE parent_id = '$kid'";
00137
00138 $note = "";
00139 $result_sub = mysql_query($query_sub) or die(mysql_error());
00140 if (mysql_num_rows($result_sub)==0){
00141 $note = 1;
00142 }
00143 else {
00144 $brojac = 0;
00145 while ($row_sub = mysql_fetch_array($result_sub)){
00146 $link_general[$brojac][0] = $row_sub[0];
00147 $link_general[$brojac][1] = $row_sub[1];
00148 $link_general[$brojac][2] = $row_sub[2];
00149 $brojac++;
00150 }
00151 }
00152
00153 $query = "SELECT links_url, links_naziv, links_opis
00154 FROM linkovi_links
00155 WHERE kat_id = '$kid'";
00156
00157 $note_url = "";
00158 $result = mysql_query($query) or die(mysql_error());
00159 if (mysql_num_rows($result)==0){
00160 $note_url = _NOCATLINKS;
00161 }
00162 else {
00163 $brojac_url = 0;
00164 while ($row = mysql_fetch_array($result)){
00165 $link_url[$brojac_url][0] = $row[0];
00166 $link_url[$brojac_url][1] = $row[1];
00167 $link_url[$brojac_url][2] = $row[2];
00168 $brojac_url++;
00169 }
00170 }
00171
00172 $title = "/<a href=\"linkovi.php\">"._GENLINKS."</a>";
00173 $title .= getNavigation($kid, $tip);
00174 printLinkoviPrikaz($title, $note, $link_general, $brojac, $note_url, $link_url, $brojac_url, $tip);
00175
00176
00177 }
00178
00179 elseif ($tip == "personal"){
00180 $query_sub = "SELECT pkat_id, pkat_naslov, pkat_opis
00181 FROM linkovi_personal_kategorije
00182 WHERE parent_id = '$kid'
00183 AND student_id = '$id'";
00184
00185 $note = "";
00186 $result_sub = mysql_query($query_sub) or die(mysql_error());
00187 if (mysql_num_rows($result_sub)==0){
00188 $note = 1;
00189 }
00190 else {
00191 $brojac = 0;
00192 while ($row_sub = mysql_fetch_array($result_sub)){
00193 $link_general[$brojac][0] = $row_sub[0];
00194 $link_general[$brojac][1] = $row_sub[1];
00195 $link_general[$brojac][2] = $row_sub[2];
00196 $brojac++;
00197 }
00198 }
00199
00200 $query = "SELECT links_url, links_naziv, links_opis, links_id
00201 FROM linkovi_personal_links
00202 WHERE pkat_id = '$kid'
00203 AND student_id = '$id'";
00204
00205 $note_url = "";
00206 $result = mysql_query($query) or die(mysql_error());
00207 if (mysql_num_rows($result)==0){
00208 $note_url = _NOCATLINKS;
00209 }
00210 else {
00211 $brojac_url = 0;
00212 while ($row = mysql_fetch_array($result)){
00213 $link_url[$brojac_url][0] = $row[0];
00214 $link_url[$brojac_url][1] = $row[1];
00215 $link_url[$brojac_url][2] = $row[2];
00216 $link_url[$brojac_url][3] = $row[3];
00217 $brojac_url++;
00218 }
00219 }
00220
00221 $title = "/<a href=\"linkovi.php\">"._PERSLINKS."</a>";
00222 $title .= getNavigation($kid, $tip);
00223 printLinkoviPrikaz($title, $note, $link_general, $brojac, $note_url, $link_url, $brojac_url, $tip);
00224
00225
00226 }
00227 }
00228
00229
00230
00231
00232
00233 function linkoviPersonalManagment($id){
00234 $query_parent = "SELECT pkat_id
00235 FROM linkovi_personal_kategorije
00236 WHERE student_id = '$id'
00237 ORDER BY parent_id";
00238
00239 $result_parent = mysql_query($query_parent);
00240 $count = 0;
00241 while ($row_parent = mysql_fetch_array($result_parent)){
00242 $kategorija[$count][0] = $row_parent[0];
00243 $kategorija[$count][1] = getParent($row_parent[0]);
00244 $count++;
00245 }
00246
00247
00248
00249
00250 if ($_GET['addcat']==1){
00251 printLinkoviDodavanjeKategorije($kategorija, $count);
00252 }
00253
00254
00255
00256
00257 elseif ($_GET['addcat']==2){
00258 if (isset($_POST['naslov'])){
00259 if (isset($_POST['opis'])){
00260 if (isset($_POST['u_kategoriju']) && ($_POST['u_kategoriju']!=-1)){
00261 $naziv = strip_tags($_POST['naslov']);
00262 $opis = strip_tags($_POST['opis']);
00263 $parent = $_POST['u_kategoriju'];
00264 $query = "INSERT INTO linkovi_personal_kategorije
00265 (pkat_id , student_id , pkat_naslov , pkat_opis , parent_id)
00266 VALUES ('auto_increment', '$id', '$naziv', '$opis', '$parent')";
00267 $result = mysql_query($query) or die(mysql_error());
00268
00269 printRokoviStart(_OPSUCCESS, 350);
00270 printServisGreska(_OPCATADDSUCCESS);
00271 }
00272 else {
00273 printRokoviStart(_OPERROR, 350);
00274 printServisGreska(_OPCATCHOICEERROR);
00275 }
00276 }
00277 else {
00278 printRokoviStart(_OPERROR, 350);
00279 printServisGreska(_OPCATDESCERROR);
00280 }
00281 }
00282 else {
00283 printRokoviStart(_OPERROR, 350);
00284 printServisGreska(_OPCATNAMEERROR);
00285 }
00286 }
00287
00288
00289
00290
00291 elseif ($_GET['delcat']==1){
00292 printLinkoviBrisanjeKategorije($kategorija, $count);
00293 }
00294
00295
00296
00297
00298 elseif ($_GET['delcat']==2){
00299 if (isset($_POST['obrisi_kategoriju']) && ($_POST['obrisi_kategoriju']!=-1)){
00300 $del_id = $_POST['obrisi_kategoriju'];
00301 $query_check = "SELECT pkat_naslov
00302 FROM linkovi_personal_kategorije
00303 WHERE parent_id = '$del_id'
00304 AND student_id = '$id'";
00305 $result_check = mysql_query($query_check) or die(mysql_error());
00306 if (mysql_num_rows($result_check)){
00307 printRokoviStart(_OPERROR, 350);
00308 printServisGreska(_OPCATHASSUBERROR);
00309 }
00310 else {
00311
00312 $query_del_url = "DELETE
00313 FROM linkovi_personal_links
00314 WHERE pkat_id = '$del_id'
00315 AND student_id = '$id'";
00316
00317 $result_del_url = mysql_query($query_del_url) or die(mysql_error);
00318
00319
00320 $query_del_cat = "DELETE
00321 FROM linkovi_personal_kategorije
00322 WHERE pkat_id = '$del_id'
00323 AND student_id = '$id'";
00324
00325 $result_del_cat = mysql_query($query_del_cat) or die(mysql_error());
00326
00327
00328 printRokoviStart(_OPSUCCESS, 350);
00329 printServisGreska(_OPCATDELSUCCESS);
00330 }
00331
00332 }
00333 else {
00334 printRokoviStart(_OPERROR, 350);
00335 printServisGreska(_OPCATCHOICEERROR);
00336 }
00337 }
00338
00339
00340
00341
00342 elseif ($_GET['modcat']==1){
00343 printLinkoviModifikacijaKategorije($kategorija, $count);
00344 }
00345
00346
00347
00348
00349 elseif ($_GET['modcat']==2){
00350 if (isset($_POST['modifikuj_id']) && ($_POST['modifikuj_id']!=-1)){
00351
00352 $perkat_id = $_POST['modifikuj_id'];
00353 $query_cat = "SELECT pkat_naslov, pkat_opis, parent_id
00354 FROM linkovi_personal_kategorije
00355 WHERE pkat_id = '$perkat_id'";
00356
00357 $result_cat = mysql_query($query_cat);
00358 $row_cat = mysql_fetch_array($result_cat);
00359 $naziv = $row_cat[0];
00360 $opis = $row_cat[1];
00361 $parent = $row_cat[2];
00362
00363
00364
00365 printLinkoviModifikujKategoriju($kategorija, $count, $perkat_id, $naziv, $opis, $parent);
00366 }
00367 else {
00368 printRokoviStart(_OPERROR, 350);
00369 printServisGreska(_OPCATCHOICEERROR);
00370 }
00371 }
00372
00373
00374
00375
00376 elseif ($_GET['modcat']==3){
00377 if (isset($_POST['naslov'])){
00378 if (isset($_POST['opis'])){
00379 if (isset($_POST['u_kategoriju']) && ($_POST['u_kategoriju']!=-1)){
00380 $kat_id = $_POST['kat_id'];
00381 $naziv = strip_tags($_POST['naslov']);
00382 $opis = strip_tags($_POST['opis']);
00383 $parent = $_POST['u_kategoriju'];
00384 $query = "UPDATE linkovi_personal_kategorije
00385 SET pkat_naslov = '$naziv',
00386 pkat_opis = '$opis',
00387 parent_id = '$parent'
00388 WHERE pkat_id = '$kat_id'
00389 AND student_id = '$id'";
00390
00391 $result = mysql_query($query) or die(mysql_error());
00392
00393 printRokoviStart(_OPSUCCESS, 350);
00394 printServisGreska(_OPCATMODSUCCESS);
00395 }
00396 else {
00397 printRokoviStart(_OPERROR, 350);
00398 printServisGreska(_OPCATDESTERROR);
00399 }
00400 }
00401 else {
00402 printRokoviStart(_OPERROR, 350);
00403 printServisGreska(_OPCATDESCERROR);
00404 }
00405 }
00406 else {
00407 printRokoviStart(_OPERROR, 350);
00408 printServisGreska(_OPCATNAMEERROR);
00409 }
00410 }
00411
00412
00413
00414
00415 elseif ($_GET['addurl']==1){
00416 printLinkoviDodavanjeLinka($kategorija, $count);
00417 }
00418
00419
00420
00421
00422 elseif ($_GET['addurl']==2){
00423 if (isset($_POST['url'])){
00424 if (isset($_POST['naslov'])){
00425 if (isset($_POST['opis'])){
00426 if (isset($_POST['u_kategoriju']) && ($_POST['u_kategoriju']!=-1)){
00427
00428 $url = strip_tags($_POST['url']);
00429 $kat_id = $_POST['u_kategoriju'];
00430 $naziv = strip_tags($_POST['naslov']);
00431 $opis = strip_tags($_POST['opis']);
00432 $query = "INSERT INTO linkovi_personal_links
00433 (links_id, pkat_id, student_id, links_naziv, links_url, links_opis)
00434 VALUES ('auto_increment', '$kat_id', '$id', '$naziv', '$url', '$opis')";
00435
00436 $result = mysql_query($query) or die(mysql_error());
00437
00438 printRokoviStart(_OPSUCCESS, 350);
00439 printServisGreska(_OPURLADDSUCCESS);
00440 }
00441 else {
00442 printRokoviStart(_OPERROR, 350);
00443 printServisGreska(_OPCATDESTERROR);
00444 }
00445 }
00446 else {
00447 printRokoviStart(_OPERROR, 350);
00448 printServisGreska(_OPURLDESCERROR);
00449 }
00450 }
00451 else {
00452 printRokoviStart(_OPERROR, 350);
00453 printServisGreska(_OPURLNAMEERROR);
00454 }
00455 }
00456 else {
00457 printRokoviStart(_OPERROR, 350);
00458 printServisGreska(_OPURLLINKERROR);
00459 }
00460 }
00461
00462
00463
00464
00465 elseif($_GET['modurl']==1){
00466 if (isset($_GET['lid'])){
00467 $lid = $_GET['lid'];
00468 $query = "SELECT pkat_id, links_naziv, links_url, links_opis
00469 FROM linkovi_personal_links
00470 WHERE links_id = '$lid'
00471 AND student_id = '$id'";
00472
00473 $result = mysql_query($query) or die(mysql_error());
00474 if (mysql_num_rows($result) == 0){
00475 printRokoviStart(_OPERROR, 350);
00476 printServisGreska(_OPSYSTEMERROR);
00477 }
00478 else {
00479 $row = mysql_fetch_array($result);
00480 $parent = $row[0];
00481 $naslov = $row[1];
00482 $url = $row[2];
00483 $opis = $row[3];
00484 printLinkoviModifikujLink($kategorija, $count, $naslov, $url, $opis, $lid, $parent);
00485 }
00486 }
00487 }
00488
00489
00490
00491
00492 elseif ($_GET['modurl']==2){
00493 if (isset($_POST['url'])){
00494 if (isset($_POST['naslov'])){
00495 if (isset($_POST['opis'])){
00496 if (isset($_POST['u_kategoriju']) && ($_POST['u_kategoriju']!=-1)){
00497
00498 $url = strip_tags($_POST['url']);
00499 $kat_id = $_POST['u_kategoriju'];
00500 $naziv = strip_tags($_POST['naslov']);
00501 $opis = strip_tags($_POST['opis']);
00502 $lid = strip_tags($_POST['lid']);
00503
00504 $query = "UPDATE linkovi_personal_links
00505 SET links_naziv = '$naziv',
00506 links_opis = '$opis',
00507 pkat_id = '$kat_id'
00508 WHERE links_id = '$lid'
00509 AND student_id = '$id'";
00510
00511 $result = mysql_query($query) or die(mysql_error());
00512
00513 printRokoviStart(_OPSUCCESS, 350);
00514 printServisGreska(_OPURLMODSUCCESS);
00515 }
00516 else {
00517 printRokoviStart(_OPERROR, 350);
00518 printServisGreska(_OPCATDESTERROR);
00519 }
00520 }
00521 else {
00522 printRokoviStart(_OPERROR, 350);
00523 printServisGreska(_OPURLDESCERROR);
00524 }
00525 }
00526 else {
00527 printRokoviStart(_OPERROR, 350);
00528 printServisGreska(_OPURLNAMEERROR);
00529 }
00530 }
00531 else {
00532 printRokoviStart(_OPERROR, 350);
00533 printServisGreska(_OPURLLINKERROR);
00534 }
00535 }
00536
00537
00538
00539
00540 elseif($_GET['delurl']==1){
00541 if (isset($_GET['lid'])){
00542 $lid = $_GET['lid'];
00543 $query = "SELECT links_naziv, links_url, links_opis
00544 FROM linkovi_personal_links
00545 WHERE links_id = '$lid'
00546 AND student_id = '$id'";
00547
00548 $result = mysql_query($query) or die(mysql_error());
00549 if (mysql_num_rows($result) == 0){
00550 printRokoviStart(_OPERROR, 350);
00551 printServisGreska(_OPSYSTEMERROR);
00552 }
00553 else {
00554 $row = mysql_fetch_array($result);
00555
00556 $naslov = $row[0];
00557 $url = $row[1];
00558 $opis = $row[2];
00559 printLinkoviBrisanjeLinka($lid, $naslov, $opis, $url);
00560 }
00561 }
00562 }
00563
00564
00565
00566
00567 elseif($_GET['delurl']==2){
00568 if (isset($_GET['lid'])){
00569 $lid = $_GET['lid'];
00570 $query = "DELETE
00571 FROM linkovi_personal_links
00572 WHERE links_id = '$lid'
00573 AND student_id = '$id'";
00574
00575 $result = mysql_query($query) or die(mysql_error());
00576 printRokoviStart(_OPSUCCESS, 350);
00577 printServisGreska(_OPURLDELSUCCESS);
00578 }
00579 else {
00580 printRokoviStart(_OPERROR, 350);
00581 printServisGreska(_OPSYSTEMERROR);
00582 }
00583 }
00584 }
00585 ?>
