PHP-Fusion Mods
Navigacija
Apsauga
Apsauga Neleista registracija: 28952
Šiandien: 9
Prisijungę nariai
» Svečių: 10
» Narių: 0

» Viso narių: 10,232
» Naujausias: EdvinasG1337

Prisijungimų istorija:
tabux 3 Dienos
EdvinasG1337nepamenu
rolandas94nepamenu
Zbigniew@nepamenu
Edis2nepamenu
klubogerbejasnepamenu
Miskinisnepamenu
mast3rnepamenu
N1nt3ndnepamenu
Matze1987nepamenu
Piter_NSnepamenu
MariukasRnepamenu
Pask. modai
PHP-Fusion v7 modifikacijos
Anekdotai
Filmų ir serialų mod...
User Gold
Filmų modulis (Patobu...
Antispam For Bots

PHP-Fusion v6 modifikacijos
banner_exchange_v3_2 S...
Atlikėjų dvikovos
L2 PVP/PK topai
Kartuves v6.xx - be re...
Dainu pateikimas admin...

Paskutinės 5 panelės
[CS] Counter Strike Mon...
Avices header login panele
v7 top 5 uploderiai
minecraft servo statuso...
Paieška + Kategorijos

Statistika
Turime modifikacijų: 828
Turime panelių: 377
Prisijungti
Vardas

Slaptažodis



Dar ne narys?
Registruotis.

Pamiršai slaptažodį?
Prašyk naujo!.

Naujausi prašymai
[L] testas
Narių apklausa
Ar dar kuriate tinklalapius?

Ne
Ne
0% [0 Balsai]

Taip
Taip
88% [7 Balsai]

Naudojuosi socialiniais tinklais
Naudojuosi socialiniais tinklais
13% [1 Balsas]

Balsai: 8
Kad galėtum balsuoti, turi prisijungti.
Pradėta: 2022-05-29 19:54
Shoutbox
You must login to post a message.

MariukasR
2024-03-07 22:13
Oj Tabux… apkabinčiau už tą moderatorių 😁

tabux
2024-02-22 17:40
Šypsosi2 jo buvo laikai.. Senukai jau mes. Bega laikas greiciau nei noretusi. Smagu matyti kad uzsuka seni nariai, ne as vienas Šypsosi

MariukasR
2024-02-20 22:18
Zodziu.. Nostalgija. Sorry Tabux uz spam’a, netelpa viskas i viena shout’a. 😁

MariukasR
2024-02-20 22:14
Aisku dabar tokie laikai, kai turinio valdymo sistemas valdome one-click principu. Ne kaip seniau kode ieskodavom klaidu, norint moda pasileist.. :D paciam reikdavo susidiegt viska i ftp..

MariukasR
2024-02-20 22:03
Sveiki kolegos 👌 kazkada rasiau greit 11 metu bet ziuriu greit 14 metu. 😄 baisuu, reik ta proga kazka sugalvot su php-f kaip jaunima itraukt.

Shoutbox Archive
Peržiūrėti temą
PHP-Fusion Mods :: PHP-Fusion modifikacijų forumas :: Taisymas
\n
 Spausdinti temą
neveikia DELETE ir UPDATE
nerkiuz
#1 Spausdinti pranešimą
parašyta 2012-11-05 12:28
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

 Taigi, persidarinejau viena moda ir su INSERT i mysql viskas veikia gerai, bet jei noriu UPDATE'inti ar DELETE'inti niekas nesikeicia ir neissitrina. Gal kas galite pagelbeti, nes niekaip nerandu kur kas blogai.

Dalis kodo:

Download source  Code
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {

      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {

      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      redirect(FUSION_SELF.$aidlink.\"&status=dely\");

   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

            $result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('$pav_var', '$reit', '$amzius', '$gim_vieta', '$gyv_vieta', '$ugis', '$svoris', '$ranka', '$sporte_nuo', '$treneris', '$info', '$laimejimai') WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

            redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('$pav_var', '$reit', '$amzius', '$gim_vieta', '$gyv_vieta', '$ugis', '$svoris', '$ranka', '$sporte_nuo', '$treneris', '$info', '$laimejimai')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }




Dekui visiems, kas gales pagelbeti!
 
PM
Wyciokazz
#2 Spausdinti pranešimą
parašyta 2012-11-05 13:53
Vartotojo avataras

Administratorius



Reputacija: 1

Pranešimai: 2108
Įstojo: 2008-02-27

 Bandyk

Download source  Code
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {
      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {
      redirect(FUSION_SELF.$aidlink.\"&status=dely\");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

            $result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES ('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"') WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

            redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }



Kam kurti tai kas jau sukurta.

Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.

[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
 
PM
nerkiuz
#3 Spausdinti pranešimą
parašyta 2012-11-05 16:51
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

 Dkui Wyciokazz,

na su DELETE dabar jau viskas tvarkoje, bet UPDATE'o vistiek nepadaro, jei darau pakeitimus i?lieka pirminis variantas.
 
PM
Wyciokazz
#4 Spausdinti pranešimą
parašyta 2012-11-05 17:20
Vartotojo avataras

Administratorius



Reputacija: 1

Pranešimai: 2108
Įstojo: 2008-02-27

 Parasyk kai atnaujini ka ismeta koki teksta nes cia debuggeri padariau.

Download source  Code
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {
      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {
      redirect(FUSION_SELF.$aidlink.\"&status=dely\");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

            //$result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES ('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"') WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

         echo \"1. \".$pav_var;
         echo \"
\";
         echo \"2. \".$reit;
         echo \"
\";
         echo \"3. \".$amzius;
         echo \"
\";
         echo \"4. \".$gim_vieta;
         echo \"
\";
         echo \"5. \".$gyv_vieta;
         echo \"
\";
         echo \"6. \".$ugis;
         echo \"
\";
         echo \"7. \".$svoris;
         echo \"
\";
         echo \"8. \".$ranka;
         echo \"
\";
         echo \"9. \".$sporte_nuo;
         echo \"
\";
         echo \"10. \".$treneris;
         echo \"
\";
         echo \"11. \".$info;
         echo \"
\";
         echo \"12. \".$laimejimai;
         echo \"
\";
         echo \"13. \".$_GET['zaid_id'];
         
         
         
            //redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }




Kam kurti tai kas jau sukurta.

Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.

[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
 
PM
nerkiuz
#5 Spausdinti pranešimą
parašyta 2012-11-05 18:07
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

 na dabar kai ?it meiau ir UPDATE'inu, tai i?meta papildom t tavo numeracij jau su pakeistais duomenimis, bet duombaz nei?saugo, o palieka pirmin variant.

metu vis kod, gal ten kur toliau ka?kas negerai:

Download source  Code
require_once \"../../maincore.php\";
require_once THEMES.\"templates/admin_header.php\";
require_once INFUSIONS.\"atp_zaidejai/infusion_db.php\";
require_once INCLUDES.\"html_buttons_include.php\";
if (!checkrights(\"FLP\") || !defined(\"iAUTH\") || $_GET['aid'] != iAUTH) { redirect(\"../index.php\"); }
if (file_exists(INFUSIONS.\"atp_zaidejai/locale/\".$settings['locale'].\".php\")) {
   include INFUSIONS.\"atp_zaidejai/locale/\".$settings['locale'].\".php\";
} else {
   include INFUSIONS.\"atp_zaidejai/locale/English.php\";
}
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {
      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {
      redirect(FUSION_SELF.$aidlink.\"&status=dely\");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

            $result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES ('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"') WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

            redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }

   echo \"
\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\n\";
   
   echo \"\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\n\";
   
   echo \"\n\";
   echo \"\n
\".$locale['zaid_000'].\"
\".$locale['zaid_028'].\"
\".$locale['zaid_001'].\"
\".$locale['zaid_002'].\"
\".$locale['zaid_003'].\"
\".$locale['zaid_004'].\"
\".$locale['zaid_005'].\"
\".$locale['zaid_006'].\"
\".$locale['zaid_007'].\"
\".$locale['zaid_008'].\"
\".$locale['zaid_026'].\"
\n\";
   echo display_html(\"inputform\", \"zaid_info\", true).\"
\".$locale['zaid_027'].\"
\n\";
   echo display_html(\"inputform\", \"zaid_laimejimai\", true).\"
\n\";
   echo \"
\n
\n\";
   closetable();

   opentable($locale['zaid_018']);
   echo \"\n\";
   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" ORDER BY zaid_pav_var\");
   if (dbrows($result) != 0) {
      $i = 0;
      echo \"\n\";
      echo \"\n\";
      echo \"\n\";
      echo \"\n\";
      while ($data = dbarray($result)) {
         $cell_color = ($i % 2 == 0 ? \"tbl1\" : \"tbl2\");
         echo \"\n\";
         echo \"\n\";
         echo \"\n\";
         $i++;
      }
      echo \"
\".$locale['zaid_019'].\"\".$locale['zaid_014'].\"
\".$data['zaid_pav_var'].\"
\n\";
         echo \"		\".$locale['zaid_020'].\" -\n\";
         echo \">\".$locale['zaid_022'].\"
\n\";
   } else {
      echo \"
\".$locale['zaid_024'].\"
\n\";
   }
   require_once INFUSIONS.\"atp_zaidejai/inc/copy.php\";
   closetable();
}

require_once THEMES.\"templates/footer.php\";
?>


 
PM
Wyciokazz
#6 Spausdinti pranešimą
parašyta 2012-11-05 19:20
Vartotojo avataras

Administratorius



Reputacija: 1

Pranešimai: 2108
Įstojo: 2008-02-27

tu man cia parasyk ka tau ten rodo ir as zinosiu kur klaida nes irasyti y duombaze ir neturi.
Kam kurti tai kas jau sukurta.

Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.

[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]  
PM
nerkiuz
#7 Spausdinti pranešimą
parašyta 2012-11-05 19:59
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

http://imageshack.us/photo/my-images/7/44733511.jpg/

ia turi matytis, kai atnaujinu sunumeruot sra? prideda
Redagavo nerkiuz 2012-11-05 20:00  
PM
Wyciokazz
#8 Spausdinti pranešimą
parašyta 2012-11-05 20:10
Vartotojo avataras

Administratorius



Reputacija: 1

Pranešimai: 2108
Įstojo: 2008-02-27

Bonke alaus dabar is taves:

Download source  Code
$result = dbquery(\"UPDATE \".$db_prefix.\"downloads SET download_status='1' WHERE download_id='\".$_GET['download_id'].\"'\");

if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {
      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {
      redirect(FUSION_SELF.$aidlink.\"&status=dely\");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      
         $result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET zaid_pav_var='\".$pav_var.\"', zaid_reit='\".$reit.\"', zaid_amzius='\".$amzius.\"', zaid_gim_vieta='\".$gim_vieta.\"', zaid_gyv_vieta='\".$gyv_vieta.\"', zaid_ugis='\".$ugis.\"', zaid_svoris='\".$svoris.\"', zaid_ranka='\".$ranka.\"', zaid_sporte_nuo='\".$sporte_nuo.\"', zaid_treneris='\".$treneris.\"', zaid_info='\".$info.\"', zaid_laimejimai='\".$laimejimai.\"' WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
           
         redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }


Redagavo Wyciokazz 2012-11-05 20:34
Kam kurti tai kas jau sukurta.

Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.

[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]  
PM
nerkiuz
#9 Spausdinti pranešimą
parašyta 2012-11-07 11:31
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

K ?ioje eilutje reikt keisti, nes man kad ir kaip pakeisiau klaidas meta, nors ir su ?iuo kodu visk update'ina:

Klaida: Unknown column 'download_status' in 'field list'

$result = dbquery("UPDATE ".$db_prefix."downloads SET download_status='1' WHERE download_id='".$_GET['download_id']."'");

Pakeitus tok:
$result = dbquery("UPDATE ".$db_prefix."atp_zaid SET zaid_id='".$_GET['zaid_id']."' WHERE zaid_id='".$_GET['zaid_id']."'");

klaida: Undefined index: download_id
ia mano lentel:

Download source  Code
DB_ATP_ZAID.\" (
   zaid_id SMALLINT(5) UNSIGNED NOT NULL auto_increment,
   zaid_reit TEXT NOT NULL DEFAULT '',
   zaid_pav_var VARCHAR(100) NOT NULL DEFAULT '',
   zaid_anzius VARCHAR(100) NOT NULL DEFAULT '',
   zaid_gim_vieta VARCHAR(100) NOT NULL DEFAULT '',
   zaid_gyv_vieta VARCHAR(100) NOT NULL DEFAULT '',
   zaid_ugis VARCHAR(10) NOT NULL DEFAULT '',
   zaid_ranka TINYTEXT NOT NULL DEFAULT '',
   zaid_sporte_nuo VARCHAR(10) NOT NULL DEFAULT '',
   zaid_treneris VARCHAR(10) NOT NULL DEFAULT '',
   zaid_info TEXT NOT NULL DEFAULT '',
   zaid_laimejimai TEXT NOT NULL DEFAULT '',
   zaid_foto VARCHAR(200) NOT NULL DEFAULT 'player.png',
   PRIMARY KEY (zaid_id)


 
PM
Wyciokazz
#10 Spausdinti pranešimą
parašyta 2012-11-07 14:20
Vartotojo avataras

Administratorius



Reputacija: 1

Pranešimai: 2108
Įstojo: 2008-02-27

Mano klaida sorri.

Download source  Code
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == \"sn\") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == \"su\") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == \"deln\") {

      $message = $locale['zaid_012'].\"
\n\".$locale['zaid_015'].\"\";

   } elseif ($_GET['status'] == \"dely\") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo \"
\".$message.\"
\n\"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS.\"atp_zaidejai/inc/panel_tab.php\";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == \"delete\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

   if (dbrows($result) != 0) {
      $result = dbquery(\"DELETE FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
      redirect(FUSION_SELF.$aidlink.\"&status=deln\");

   } else {
      redirect(FUSION_SELF.$aidlink.\"&status=dely\");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

     
         $result = dbquery(\"UPDATE \".DB_ATP_ZAID.\" SET zaid_pav_var='\".$pav_var.\"', zaid_reit='\".$reit.\"', zaid_amzius='\".$amzius.\"', zaid_gim_vieta='\".$gim_vieta.\"', zaid_gyv_vieta='\".$gyv_vieta.\"', zaid_ugis='\".$ugis.\"', zaid_svoris='\".$svoris.\"', zaid_ranka='\".$ranka.\"', zaid_sporte_nuo='\".$sporte_nuo.\"', zaid_treneris='\".$treneris.\"', zaid_info='\".$info.\"', zaid_laimejimai='\".$laimejimai.\"' WHERE zaid_id='\".$_GET['zaid_id'].\"'\");
           
         redirect(FUSION_SELF.$aidlink.\"&status=su\");

         } else {

            $result = dbquery(\"INSERT INTO \".DB_ATP_ZAID.\" (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('\".$pav_var.\"', '\".$reit.\"', '\".$amzius.\"', '\".$gim_vieta.\"', '\".$gyv_vieta.\"', '\".$ugis.\"', '\".$svoris.\"', '\".$ranka.\"', '\".$sporte_nuo.\"', '\".$treneris.\"', '\".$info.\"', '\".$laimejimai.\"')\");

            redirect(FUSION_SELF.$aidlink.\"&status=sn\");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == \"edit\") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery(\"SELECT * FROM \".DB_ATP_ZAID.\" WHERE zaid_id='\".$_GET['zaid_id'].\"'\");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink.\"&action=edit&zaid_id=\".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = \"\";

      $reit = \"\";

      $amzius = \"\";

      $gim_vieta = \"\";

        $gyv_vieta = \"\";

        $ugis = \"\";

        $svoris = \"\";

        $ranka = \"\";

        $sporte_nuo = \"\";

        $treneris = \"\";

      $info = \"\";

      $laimejimai = \"\";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }


Kam kurti tai kas jau sukurta.

Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.

[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]  
PM
nerkiuz
#11 Spausdinti pranešimą
parašyta 2012-11-07 15:46
Naujokas



Reputacija: 0

Pranešimai: 10
Įstojo: 2007-06-05

Na dabar jau ledas, didelis dkui tau!!!  
PM
Peršokti į forumą:
20,361,926 unikalūs lankytojai
Powered by PHP-Fusion Copyright © 2025 PHP-Fusion Inc
Released as free software without warranties under GNU Affero GPL v3
Theme designed by Falcon
Copyright © 2025 phpfusion.lt