Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: fusion_admin

Parašė Narysx· 2008 Bir. 10 23:06:53
#1
Jei kam nesunku, tai nueikit į savo mysql duomenų bazę ir padarę fusion_admin lentelę įrašykite ją į .sql failą. Tada prisekit čia, duosiu 10. :D Man reikia, nes savo biški suvariau...

Parašė ozzWANTED· 2008 Bir. 10 23:06:41
#2
Sveiki, aš Tomas, noriu būti tavo draugas. Surašyk man savo asmens kodą, banko sąskaitos numerį, vardą pavardę, ir banko sąskaitos prisjungimo duomenis, bei išsiųsk juos adresu kaker@webmail.ru . Dėkoju. Būsim draugais.

Parašė Narysx· 2008 Bir. 10 23:06:18
#3
:[ Nu taigi nieko aš nepamatysiu tam faile, tik lentelės struktūrą.

Parašė WantedBoy· 2008 Bir. 10 23:06:18
#4
Iš fusiono išsiimk, juk visas sql yra ;)

Parašė Narysx· 2008 Bir. 11 00:06:34
#5
Nu ten juk instalinant fusioną automatiškai sukuria visas lenteles, tačiau atskiro .sql failo su visų lentelių struktūromis nėra...

Parašė WantedBoy· 2008 Bir. 11 00:06:44
#6
Taigi failas yra kur visos lentelių struktūros yra.

Parašė Narysx· 2008 Bir. 11 00:06:58
#7
Bet kažkaip ne taip parašyti.

Turi būti maždaug taip:


-- Sukurta duomenų struktūra lentelei `fusion_admin`
--

CREATE TABLE IF NOT EXISTS `fusion_admin` (
  `admin_id` tinyint(2) unsigned NOT NULL auto_increment,
  `admin_rights` char(2) collate cp1257_lithuanian_ci NOT NULL default '',
  `admin_image` varchar(50) collate cp1257_lithuanian_ci NOT NULL default '',
  `admin_title` varchar(50) collate cp1257_lithuanian_ci NOT NULL default '',
  `admin_link` varchar(100) collate cp1257_lithuanian_ci NOT NULL default 'reserved',
  `admin_page` tinyint(1) unsigned NOT NULL default '1',
  PRIMARY KEY  (`admin_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1257 COLLATE=cp1257_lithuanian_ci AUTO_INCREMENT=76 ;

--
-- Sukurta duomenų kopija lentelei `fusion_admin`
--

INSERT INTO `fusion_admin` (`admin_id`, `admin_rights`, `admin_image`, `admin_title`, `admin_link`, `admin_page`) VALUES
(1, 'AD', 'admins.gif', 'Administratoriai', 'administrators.php', 2),
(4, 'B', 'blacklist.gif', 'Juodasis sÄ…raÅas', 'blacklist.php', 2),
(5, 'C', '', 'Komentarai', 'reserved', 2),
(6, 'CP', 'c-pages.gif', 'PridÄ—tiniai puslapiai', 'custom_pages.php', 1),
(7, 'DB', 'db_backup.gif', 'Duomenų bazės atsarginės kopijos', 'db_backup.php', 3),
(11, 'F', 'forums.gif', 'Forumai', 'forums.php', 1),
(13, 'I', 'infusions.gif', 'Modifikacijos', 'infusions.php', 3),
(14, 'IP', '', 'Modifikacij? panel?s', 'reserved', 3),
(15, 'M', 'members.gif', 'Vartotojai', 'members.php', 2),
(16, 'N', 'news.gif', 'Naujienos', 'news.php', 1),
(18, 'P', 'panels.gif', 'PanelÄ—s', 'panels.php', 3),
(19, 'PH', 'photoalbums.gif', 'Foto albumai', 'photoalbums.php', 1),
(20, 'PI', 'phpinfo.gif', 'PHP info', 'phpinfo.php', 3),
(21, 'PO', 'polls.gif', 'Apklausos', 'polls.php', 1),
(22, 'S', 'shout.gif', 'Å aukykla', 'shoutbox.php', 2),
(25, 'U', 'upgrade.gif', 'Tinklapio atnaujinimas', 'upgrade.php', 3),
(29, 'S1', 'settings.gif', 'PAGRINDINIAI TINKLAPIO NUSTATYMAI', 'settings_main.php', 3),
(30, 'S2', 'settings_time.gif', 'Datos ir laiko nustatymai', 'settings_time.php', 3),
(31, 'S3', 'settings_forum.gif', 'Forumo nustatymai', 'settings_forum.php', 3),
(32, 'S4', 'registration.gif', 'Registracijos nustatymai', 'settings_registration.php', 3),
(33, 'S5', 'photoalbums.gif', 'Foto galerijos nustatymai', 'settings_photo.php', 3),
(34, 'S6', 'settings_misc.gif', 'Įvairūs nustatymai', 'settings_misc.php', 3),
(35, 'S7', 'settings_pm.gif', 'Asmeninių žinuĨių savybės', 'settings_messages.php', 3),
(74, 'IP', 'user_gold.gif', 'TaÅkų sistema', '../infusions/user_gold_panel/admin/index.php', 4),
(75, 'IP', 'infusion_panel.gif', 'Smileys', '../infusions/shoutbox_panel/shoutbox_smilies_admin.php', 4);

-- --------------------------------------------------------




O tam faile yra taip:


$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."admin");
   $result = dbquery("CREATE TABLE ".$db_prefix."admin (
   admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
   admin_rights CHAR(2) NOT NULL DEFAULT '',
   admin_image VARCHAR(50) NOT NULL DEFAULT '',
   admin_title VARCHAR(50) NOT NULL DEFAULT '',
   admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
   admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
   PRIMARY KEY (admin_id)
   ) TYPE=MyISAM;");
   
   if (!$result) $fail = "1";




Parašė DuRaCeLL· 2008 Bir. 11 00:06:44
#8
<?php
   $result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."admin");
   $result = dbquery("CREATE TABLE ".$db_prefix."admin (
   admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
   admin_rights CHAR(2) NOT NULL DEFAULT '',
   admin_image VARCHAR(50) NOT NULL DEFAULT '',
   admin_title VARCHAR(50) NOT NULL DEFAULT '',
   admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
   admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
   PRIMARY KEY (admin_id)
   ) TYPE=MyISAM;");
?>




Pridėtiniuose puslapiuose įrašyk šitą kodą ir spausk peržiūrėti, bet ne išsaugoti. Ir fusion_admin lentelė susikurs iš naujo. :)
Redagavo DuRaCeLL· 2008 Bir. 11 00:06:00

Parašė bruzgis· 2008 Bir. 11 00:06:12
#9
eini i phpmyadmin ir spaudi sql tada ten nukopini sita visa:


CREATE TABLE prefixasadmin (
   admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
   admin_rights CHAR(2) NOT NULL DEFAULT '',
   admin_image VARCHAR(50) NOT NULL DEFAULT '',
   admin_title VARCHAR(50) NOT NULL DEFAULT '',
   admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
   admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
   PRIMARY KEY (admin_id)
   ) TYPE=MyISAM;"
   




tada vel i sql ir nukopini sita

INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('AD', 'admins.gif', '".$locale['460']."', 'administrators.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('AC', 'article_cats.gif', '".$locale['461']."', 'article_cats.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('A', 'articles.gif', '".$locale['462']."', 'articles.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('B', 'blacklist.gif', '".$locale['463']."', 'blacklist.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('C', '', '".$locale['464']."', 'reserved', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('CP', 'c-pages.gif', '".$locale['465']."', 'custom_pages.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('DB', 'db_backup.gif', '".$locale['466']."', 'db_backup.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('DC', 'dl_cats.gif', '".$locale['467']."', 'download_cats.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('D', 'dl.gif', '".$locale['468']."', 'downloads.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('FQ', 'faq.gif', '".$locale['469']."', 'faq.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('F', 'forums.gif', '".$locale['470']."', 'forums.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('IM', 'images.gif', '".$locale['471']."', 'images.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('I', 'infusions.gif', '".$locale['472']."', 'infusions.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('IP', '', '".$locale['473']."', 'reserved', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('M', 'members.gif', '".$locale['474']."', 'members.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('N', 'news.gif', '".$locale['475']."', 'news.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('NC', 'news_cats.gif', '".$locale['494']."', 'news_cats.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('P', 'panels.gif', '".$locale['476']."', 'panels.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PH', 'photoalbums.gif', '".$locale['477']."', 'photoalbums.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PI', 'phpinfo.gif', '".$locale['478']."', 'phpinfo.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('PO', 'polls.gif', '".$locale['479']."', 'polls.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S', 'shout.gif', '".$locale['480']."', 'shoutbox.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('SL', 'site_links.gif', '".$locale['481']."', 'site_links.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('SU', 'submissions.gif', '".$locale['482']."', 'submissions.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('U', 'upgrade.gif', '".$locale['483']."', 'upgrade.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('UG', 'user_groups.gif', '".$locale['484']."', 'user_groups.php', 2)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('WC', 'wl_cats.gif', '".$locale['485']."', 'weblink_cats.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('W', 'wl.gif', '".$locale['486']."', 'weblinks.php', 1)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S1', 'settings.gif', '".$locale['487']."', 'settings_main.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S2', 'settings_time.gif', '".$locale['488']."', 'settings_time.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S3', 'settings_forum.gif', '".$locale['489']."', 'settings_forum.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S4', 'registration.gif', '".$locale['490']."', 'settings_registration.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S5', 'photoalbums.gif', '".$locale['491']."', 'settings_photo.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S6', 'settings_misc.gif', '".$locale['492']."', 'settings_misc.php', 3)"
      INSERT INTO prefixasadmin (admin_rights, admin_image, admin_title, admin_link, admin_page) VALUES ('S7', 'settings_pm.gif', '".$locale['493']."', 'settings_messages.php', 3)";




ir viskas :s


beje nepamirsk pakeist prefixas i tavoprefixas_

Parašė Narysx· 2008 Bir. 11 17:06:19
#10
DuRaCeLL parašė:
<?php
   $result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."admin");
   $result = dbquery("CREATE TABLE ".$db_prefix."admin (
   admin_id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT,
   admin_rights CHAR(2) NOT NULL DEFAULT '',
   admin_image VARCHAR(50) NOT NULL DEFAULT '',
   admin_title VARCHAR(50) NOT NULL DEFAULT '',
   admin_link VARCHAR(100) NOT NULL DEFAULT 'reserved',
   admin_page TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
   PRIMARY KEY (admin_id)
   ) TYPE=MyISAM;");
?>




Pridėtiniuose puslapiuose įrašyk šitą kodą ir spausk peržiūrėti, bet ne išsaugoti. Ir fusion_admin lentelė susikurs iš naujo. :)


Tai padariau, ir išvis nebeleidžia į admin panelę įeit. :| Vėl į news.php numeta. :|

Man papraščiausiai kas nors padarykit, ko pirmam poste prašiau... Max 10min. darbas...
Redagavo MAnjack· 2008 Bir. 11 19:06:54