Der Befehl "" ist unbekannt !

Dieses Thema im Forum "Webentwicklung" wurde erstellt von .Pixel, 25. Juli 2009 .

Schlagworte:
Status des Themas:
Es sind keine weiteren Antworten möglich.
  1. 25. Juli 2009
    Habe Madmax per Email angeschrieben und mir sein Underground CMS gekauft (Was übrigends sehr verbugt ist). Alles per FTP geuppt, mysql importiert, dann wollte ich eine Neue kategorie erstellen (hat auch geklappt) und die alte Kategorie (neue kategorie = Anfangskategorie) Löschen.
    Beim Löschen kam die Nachricht "Der Befehl "" ist unbekannt !"
    Was soll das denn jetzt?
    Wenn ich Kategorien / Blöcke / Einträge ändern will, kommt genau die gleiche nachricht!
    Kann jemand Helfen? :angry:

    MFG
     
  3. 25. Juli 2009
    AW: Der Befehl "" ist unbekannt !

    Denke da ist irgendeine Funktion verbockt worden. Quasi sowas wie nen sql befehl DELETE FROM mytbl WHERE id = $meineID

    $meineID könnte nen rechtschreibfehler haben (variablenname) o.ä.

    Ohne den Code zu sehen.. kA

    Kenne das CMS nicht aber wenn es so verbugged ist, wieso kaufst du es dann? Klar kann man das vorher nicht wissen aber bevor man ein CMS kauft, testet man es erst mal

    Das wäre wie ein Bett zu kaufen ohne probegelegen zu haben!
     
  4. 25. Juli 2009
    AW: Der Befehl "" ist unbekannt !

    Code:
    -- 
-- Tabellenstruktur für Tabelle `blocks`
-- 

CREATE TABLE `blocks` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `flags` int(10) unsigned NOT NULL default '0',
 `position` int(10) unsigned NOT NULL default '0',
 `index` int(10) unsigned NOT NULL default '0',
 `type` int(10) unsigned NOT NULL default '0',
 `format` int(10) unsigned NOT NULL default '0',
 `category_id` int(10) unsigned NOT NULL default '0',
 `site_id` int(10) unsigned NOT NULL default '0',
 `script` varchar(255) NOT NULL default '',
 `image` varchar(255) NOT NULL default '',
 `title` varchar(64) NOT NULL default '',
 `text` text NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Blocks';

-- 
-- Daten für Tabelle `blocks`
-- 

INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (1, 0, 0, 3, 3, 0, 0, 0, '', '', 'Navigation', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (2, 2, 0, 1, 1, 0, 0, 0, 'partner.navigation.inc.php', '', 'Mein Partner Account', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (3, 4, 0, 2, 1, 0, 0, 0, 'userarea.navigation.inc.php', '', 'Mein Mitglieder Account', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (4, 0, 0, 4, 1, 0, 0, 0, 'partner.inc.php', '', 'Partner', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (5, 0, 0, 5, 1, 0, 0, 0, 'search.inc.php', '', 'Suche', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (6, 0, 1, 8, 1, 0, 0, 0, 'statistic.inc.php', '', 'Statistik', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (7, 0, 1, 9, 2, 0, 0, 0, '', '', 'Kategorien', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (8, 0, 0, 7, 1, 0, 0, 0, 'archive.inc.php', '', 'Archiv', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (9, 0, 0, 6, 1, 0, 0, 0, 'letters.inc.php', '', 'A-Z', '');
INSERT INTO `blocks` (`id`, `flags`, `position`, `index`, `type`, `format`, `category_id`, `site_id`, `script`, `image`, `title`, `text`) VALUES (10, 0, 1, 10, 0, 0, 0, 0, '', '', 'Werbung', 'werbung');

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

-- 
-- Tabellenstruktur für Tabelle `categories`
-- 

CREATE TABLE `categories` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `parent_id` int(10) unsigned NOT NULL default '0',
 `template_id` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `index` int(10) unsigned NOT NULL default '0',
 `sortorder` int(10) unsigned NOT NULL default '0',
 `title` varchar(64) NOT NULL default '',
 `tooltip` varchar(255) NOT NULL default '',
 `collectr_title` varchar(255) NOT NULL default '',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM PACK_KEYS=0 COMMENT='Categories';

-- 
-- Daten für Tabelle `categories`
-- 

INSERT INTO `categories` (`id`, `parent_id`, `template_id`, `flags`, `index`, `sortorder`, `title`, `tooltip`, `collectr_title`) VALUES (1, 0, 0, 0, 0, 0, 'Neue Kategorie', 'Neue Kategorie', '');

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

-- 
-- Tabellenstruktur für Tabelle `category_templates`
-- 

CREATE TABLE `category_templates` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `limit` int(10) unsigned NOT NULL default '0',
 `itemcols` int(10) unsigned NOT NULL default '0',
 `foldername` varchar(64) NOT NULL default '',
 `title` varchar(64) NOT NULL default '',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Cytegory Templates';

-- 
-- Daten für Tabelle `category_templates`
-- 

INSERT INTO `category_templates` (`id`, `limit`, `itemcols`, `foldername`, `title`) VALUES (1, 10, 1, 'movies', 'Template fuer Movies');

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

-- 
-- Tabellenstruktur für Tabelle `entries`
-- 

CREATE TABLE `entries` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `user_id` int(10) unsigned NOT NULL default '0',
 `category_id` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `atime` int(10) unsigned NOT NULL default '0',
 `rtime` int(10) unsigned NOT NULL default '0',
 `vtime` int(10) unsigned NOT NULL default '0',
 `hits` int(10) unsigned NOT NULL default '0',
 `thits` int(10) unsigned NOT NULL default '0',
 `rate_count` int(10) unsigned NOT NULL default '0',
 `rate_value` int(10) unsigned NOT NULL default '0',
 `download_errors` int(10) unsigned NOT NULL default '0',
 `mirror1_errors` int(10) unsigned NOT NULL default '0',
 `mirror2_errors` int(10) unsigned NOT NULL default '0',
 `mirror3_errors` int(10) unsigned NOT NULL default '0',
 `format` int(10) unsigned NOT NULL default '0',
 `hash` varchar(32) NOT NULL default '',
 `uploader` varchar(64) NOT NULL default '',
 `password` varchar(64) NOT NULL default '',
 `playtime` varchar(64) NOT NULL default '',
 `filetype` varchar(64) NOT NULL default '',
 `size` varchar(64) NOT NULL default '',
 `genre` varchar(64) NOT NULL default '',
 `language` varchar(64) NOT NULL default '',
 `source` varchar(64) NOT NULL default '',
 `media` varchar(64) NOT NULL default '',
 `producer` varchar(64) NOT NULL default '',
 `release_year` varchar(64) NOT NULL default '',
 `release_title` varchar(255) NOT NULL default '',
 `title` varchar(255) NOT NULL default '',
 `interpreter` varchar(255) NOT NULL default '',
 `actors` varchar(255) NOT NULL default '',
 `thumb_url` text NOT NULL,
 `image_url` text NOT NULL,
 `preview_url` text NOT NULL,
 `sample_url` text NOT NULL,
 `description` text NOT NULL,
 `nfo` text NOT NULL,
 `download` text NOT NULL,
 `mirror1` text NOT NULL,
 `mirror2` text NOT NULL,
 `mirror3` text NOT NULL,
 `backup_done` int(10) unsigned NOT NULL default '0',
 `backup_thumb_url` text NOT NULL,
 `backup_image_url` text NOT NULL,
 `backup_preview_url` text NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `key` (`uploader`,`title`),
 UNIQUE KEY `hash` (`hash`),
 KEY `category_id` (`category_id`)
) ENGINE=MyISAM COMMENT='Einträge';

-- 
-- Daten für Tabelle `entries`
-- 

INSERT INTO `entries` (`id`, `user_id`, `category_id`, `flags`, `ctime`, `mtime`, `atime`, `rtime`, `vtime`, `hits`, `thits`, `rate_count`, `rate_value`, `download_errors`, `mirror1_errors`, `mirror2_errors`, `mirror3_errors`, `format`, `hash`, `uploader`, `password`, `playtime`, `filetype`, `size`, `genre`, `language`, `source`, `media`, `producer`, `release_year`, `release_title`, `title`, `interpreter`, `actors`, `thumb_url`, `image_url`, `preview_url`, `sample_url`, `description`, `nfo`, `download`, `mirror1`, `mirror2`, `mirror3`, `backup_done`, `backup_thumb_url`, `backup_image_url`, `backup_preview_url`) VALUES (1, 0, 1, 8, 1190763211, 1190763226, 0, 1190764026, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'f4189837e2538876475f8c472f4c9b40', '', '', '', '', '', '', '', '', '', '', '', '', 'Neuer Eintrag', '', '', '', '', '', '', '', '', 'http://www.google.de/', '', '', '', 0, '', '', '');

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

-- 
-- Tabellenstruktur für Tabelle `entry_sharing`
-- 

CREATE TABLE `entry_sharing` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `url` varchar(255) NOT NULL default '',
 PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='Entry Sharing';

-- 
-- Daten für Tabelle `entry_sharing`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `news`
-- 

CREATE TABLE `news` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `flags` int(10) unsigned NOT NULL default '0',
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `format` int(10) unsigned NOT NULL default '0',
 `author` varchar(64) NOT NULL default '',
 `title` varchar(64) NOT NULL default '',
 `text` text NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM COMMENT='News';

-- 
-- Daten für Tabelle `news`
-- 

INSERT INTO `news` (`id`, `flags`, `ctime`, `mtime`, `format`, `author`, `title`, `text`) VALUES (1, 1, 1190764858, 1190764858, 0, '', 'Neue News', '');

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

-- 
-- Tabellenstruktur für Tabelle `partner_ins`
-- 

CREATE TABLE `partner_ins` (
 `pid` int(10) unsigned NOT NULL default '0',
 `ip` int(10) unsigned NOT NULL default '0',
 `time` int(10) unsigned NOT NULL default '0',
 UNIQUE KEY `key` (`pid`,`ip`),
 KEY `time` (`time`)
) ENGINE=MyISAM COMMENT='Partner IN''s IP Table';

-- 
-- Daten für Tabelle `partner_ins`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `partner_outs`
-- 

CREATE TABLE `partner_outs` (
 `pid` int(10) unsigned NOT NULL default '0',
 `ip` int(10) unsigned NOT NULL default '0',
 `time` int(10) unsigned NOT NULL default '0',
 UNIQUE KEY `key` (`pid`,`ip`),
 KEY `time` (`time`)
) ENGINE=MyISAM COMMENT='Partner OUT''s IP Table';

-- 
-- Daten für Tabelle `partner_outs`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `partners`
-- 

CREATE TABLE `partners` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `atime` int(10) unsigned NOT NULL default '0',
 `htime` int(10) unsigned NOT NULL default '0',
 `rdtime` int(10) unsigned NOT NULL default '0',
 `rwtime` int(10) unsigned NOT NULL default '0',
 `rmtime` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `status` int(10) unsigned NOT NULL default '0',
 `last_in` int(10) unsigned NOT NULL default '0',
 `last_out` int(10) unsigned NOT NULL default '0',
 `hits_in` int(10) unsigned NOT NULL default '0',
 `hits_out` int(10) unsigned NOT NULL default '0',
 `week_hits_in` int(10) unsigned NOT NULL default '0',
 `week_hits_out` int(10) unsigned NOT NULL default '0',
 `month_hits_in` int(10) unsigned NOT NULL default '0',
 `month_hits_out` int(10) unsigned NOT NULL default '0',
 `total_hits_in` int(10) unsigned NOT NULL default '0',
 `total_hits_out` int(10) unsigned NOT NULL default '0',
 `exit_probability_min` int(10) unsigned NOT NULL default '0',
 `exit_probability_max` int(10) unsigned NOT NULL default '0',
 `min_rate_in` int(10) unsigned NOT NULL default '0',
 `max_rate_out` int(10) unsigned NOT NULL default '0',
 `coefficient_in` int(11) NOT NULL default '0',
 `coefficient_out` int(11) NOT NULL default '0',
 `key` char(32) default NULL,
 `hash` char(32) default NULL,
 `password` char(32) NOT NULL default '',
 `username` char(32) NOT NULL default '',
 `nickname` char(64) NOT NULL default '',
 `email` char(64) NOT NULL default '',
 `newemail` char(64) default NULL,
 `icq` char(64) NOT NULL default '',
 `domain` char(64) NOT NULL default '',
 `referer` char(64) NOT NULL default '',
 `sitename` char(64) NOT NULL default '',
 `description` char(255) NOT NULL default '',
 `url` char(255) NOT NULL default '',
 `button_url` char(255) NOT NULL default '',
 `banner_url` char(255) NOT NULL default '',
 PRIMARY KEY (`id`),
 UNIQUE KEY `key` (`username`),
 UNIQUE KEY `domain` (`domain`),
 UNIQUE KEY `hash` (`hash`)
) ENGINE=MyISAM ROW_FORMAT=FIXED COMMENT='Partners';

-- 
-- Daten für Tabelle `partners`
-- 

INSERT INTO `partners` (`id`, `ctime`, `mtime`, `atime`, `htime`, `rdtime`, `rwtime`, `rmtime`, `flags`, `status`, `last_in`, `last_out`, `hits_in`, `hits_out`, `week_hits_in`, `week_hits_out`, `month_hits_in`, `month_hits_out`, `total_hits_in`, `total_hits_out`, `exit_probability_min`, `exit_probability_max`, `min_rate_in`, `max_rate_out`, `coefficient_in`, `coefficient_out`, `key`, `hash`, `password`, `username`, `nickname`, `email`, `newemail`, `icq`, `domain`, `referer`, `sitename`, `description`, `url`, `button_url`, `banner_url`) VALUES (1, 1190764257, 0, 0, 0, 0, 0, 0, 1, 0, 1190764257, 1190764257, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, '', '', '', '', NULL, '', '', '', 'Neue Seite', '', 'http://', '', '');

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

-- 
-- Tabellenstruktur für Tabelle `sites`
-- 

CREATE TABLE `sites` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `parent_id` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `index` int(10) unsigned NOT NULL default '0',
 `type` int(10) unsigned NOT NULL default '0',
 `format` int(10) unsigned NOT NULL default '0',
 `key` varchar(32) default NULL,
 `title` varchar(64) NOT NULL default '',
 `tooltip` varchar(255) NOT NULL default '',
 `site_title` varchar(255) NOT NULL default '',
 `rewrite_url` varchar(255) default NULL,
 `url` varchar(255) default NULL,
 `script` varchar(255) NOT NULL default '',
 `text` text NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `key` (`key`),
 UNIQUE KEY `rewrite_url` (`rewrite_url`),
 KEY `parent_id` (`parent_id`),
 KEY `flags` (`flags`)
) ENGINE=MyISAM PACK_KEYS=0 COMMENT='Sites';

-- 
-- Daten für Tabelle `sites`
-- 

INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (1, 0, 0, 1173908082, 1175344811, 1, 1, 0, 'news', 'News & Updates', 'News & Updates', 'News & Updates', '/news.html', NULL, 'news.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (2, 0, 0, 1173908050, 1189197300, 2, 0, 1, 'faq', 'FAQ', 'FAQ', 'FAQ', NULL, NULL, '', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (3, 0, 0, 1173912991, 1189963914, 4, 1, 0, 'partner', 'Partner', 'Unsere Partner', 'Partner', NULL, NULL, 'partner.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (4, 0, 0, 1173908032, 1175344838, 5, 1, 0, 'contact', 'Kontakt', 'Kontakt', 'Kontakt', NULL, NULL, 'contact.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (5, 0, 0, 1189006811, 1189125915, 6, 1, 0, 'upload', 'User-Uploads', 'User-Uploads', 'User-Uploads', NULL, NULL, 'user_uploads.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (6, 0, 0, 1173910299, 1175344849, 7, 1, 0, 'rss', 'RSS Feeds', 'RSS Feeds', 'RSS Feeds', NULL, NULL, 'rss.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (7, 0, 0, 1189880059, 1189882750, 9, 1, 0, 'top100', 'Die Top 100', 'Die 100 beliebtesten Einträge diese Woche', 'Die 100 beliebtesten Einträge diese Woche', NULL, NULL, 'entries.top.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (8, 0, 0, 1189880094, 1189883369, 10, 1, 0, 'latest', 'Die Letzten 100', 'Die letzten 100 Einträge', 'Die letzten 100 Einträge', NULL, NULL, 'entries.latest.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (9, 0, 0, 1189880126, 1189883640, 11, 1, 0, 'uploader', 'Uploader Top 10', 'Die besten 10 Uploader', 'Die besten 10 Uploader', NULL, NULL, 'entries.uploader.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (10, 0, 2, 1190735312, 1190735412, 17, 1, 0, 'about', 'About Underground CMS', 'About Underground CMS', 'About Underground CMS', NULL, NULL, 'about.inc.php', '');
INSERT INTO `sites` (`id`, `parent_id`, `flags`, `ctime`, `mtime`, `index`, `type`, `format`, `key`, `title`, `tooltip`, `site_title`, `rewrite_url`, `url`, `script`, `text`) VALUES (11, 0, 2, 1188730107, 1188897769, 16, 1, 0, 'userarea', 'Mitglieder Bereich', 'Mitglieder Bereich', 'Mitglieder Bereich', NULL, NULL, 'user_area.inc.php', '');

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

-- 
-- Tabellenstruktur für Tabelle `usergroups`
-- 

CREATE TABLE `usergroups` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `atime` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `user_permissions` int(10) unsigned NOT NULL default '0',
 `user_checked` int(10) unsigned NOT NULL default '0',
 `user_unchecked` int(10) unsigned NOT NULL default '0',
 `user_disabled` int(10) unsigned NOT NULL default '0',
 `admin_permissions` int(10) unsigned NOT NULL default '0',
 `admin_checked` int(10) unsigned NOT NULL default '0',
 `admin_unchecked` int(10) unsigned NOT NULL default '0',
 `admin_disabled` int(10) unsigned NOT NULL default '0',
 `type` varchar(64) NOT NULL default '',
 `name` varchar(64) NOT NULL default '',
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM COMMENT='User Groups';

-- 
-- Daten für Tabelle `usergroups`
-- 

INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (1, 1188833824, 1188833824, 0, 0, 1100, 0, 14593, 14593, 0, 0, 524287, 524287, 'nobody', 'Nobody (Gaeste)');
UPDATE `usergroups` SET `id` = 0 WHERE `id` = 1;
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (1, 1188833824, 1188833824, 0, 0, 1903, 1, 0, 1, 0, 0, 524287, 524287, 'users', 'Benutzer');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (2, 1188833824, 1188833824, 0, 0, 8047, 1025, 0, 1025, 0, 0, 524287, 524287, 'uploader', 'Uploader');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (3, 1188833824, 1188833824, 0, 0, 8191, 1, 0, 1, 15, 3, 524208, 524211, 'moderators', 'Moderatoren');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (4, 1188833824, 1188833824, 0, 0, 16383, 16383, 0, 16383, 32751, 32751, 491536, 524287, 'coadmins', 'Co-Administratoren');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (5, 1188833824, 1188833824, 0, 0, 16383, 16383, 0, 16383, 524287, 524287, 0, 524287, 'admins', 'Administratoren');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (6, 0, 0, 0, 0, 8047, 0, 0, 0, 0, 0, 0, 0, 'custom', 'Beta Tester');
INSERT INTO `usergroups` (`id`, `ctime`, `mtime`, `atime`, `flags`, `user_permissions`, `user_checked`, `user_unchecked`, `user_disabled`, `admin_permissions`, `admin_checked`, `admin_unchecked`, `admin_disabled`, `type`, `name`) VALUES (7, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 'custom', 'Neue Benutzergruppe (Custom)');

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

-- 
-- Tabellenstruktur für Tabelle `users`
-- 

CREATE TABLE `users` (
 `id` int(10) unsigned NOT NULL auto_increment,
 `group_id` int(10) unsigned NOT NULL default '0',
 `ctime` int(10) unsigned NOT NULL default '0',
 `mtime` int(10) unsigned NOT NULL default '0',
 `atime` int(10) unsigned NOT NULL default '0',
 `htime` int(10) unsigned NOT NULL default '0',
 `flags` int(10) unsigned NOT NULL default '0',
 `status` int(10) unsigned NOT NULL default '0',
 `hash` varchar(32) default NULL,
 `newemail` varchar(64) default NULL,
 `email` varchar(64) NOT NULL default '',
 `password` varchar(64) NOT NULL default '',
 `nickname` varchar(64) NOT NULL default '',
 `homepage` varchar(64) NOT NULL default '',
 `icq` varchar(64) NOT NULL default '',
 PRIMARY KEY (`id`),
 UNIQUE KEY `email` (`email`),
 UNIQUE KEY `nickname` (`nickname`),
 UNIQUE KEY `hash` (`hash`),
 UNIQUE KEY `newemail` (`newemail`)
) ENGINE=MyISAM COMMENT='Users';

-- 
-- Daten für Tabelle `users`
-- 

INSERT INTO `users` (`id`, `group_id`, `ctime`, `mtime`, `atime`, `htime`, `flags`, `status`, `hash`, `newemail`, `email`, `password`, `nickname`, `homepage`, `icq`) VALUES (1, 0, 1188836836, 1188836836, 0, 1189872312, 0, 1, NULL, NULL, 'nobody@server.com', 'd41d8cd98f00b204e9800998ecf8427e', 'Nobody (Gast)', '', '');
UPDATE `users` SET `id` = 0 WHERE `id` = 1;
INSERT INTO `users` (`id`, `group_id`, `ctime`, `mtime`, `atime`, `htime`, `flags`, `status`, `hash`, `newemail`, `email`, `password`, `nickname`, `homepage`, `icq`) VALUES (1, 5, 1188836836, 1189007370, 0, 0, 0, 1, NULL, NULL, 'admin@server.net', 'd41d8cd98f00b204e9800998ecf8427e', 'Admin', '', '');
    Hier is mal der sql code xD
    Hoffe du kannst damit was anfangen!
    Auf 1dl.in sieht das UCMS ja ganz nett aus!
    Auch madmax hat mir das blaue vom Himmel versprochen >,<
     
  5. 25. Juli 2009
    AW: Der Befehl "" ist unbekannt !

    Das ist die Struktur der Datenbank...
    Was ich meinte ist eher PHP-Spezifisch bezogen, außerdem ist dort (was auch logisch ist) nicht der DELETE-Befehl

    Du müsstest die Datei finden (oder frag ihn) die das macht.

    Außerdem: Wenn du dafür gezahlt hast.. soll der das gefälligst machen, immerhin ist das sein Programm, du kaufst es ja weil du es nicht programmieren willst, wenn es nicht funktioniert muss er es zum funktionieren bringen..
     
  6. 25. Juli 2009
    AW: Der Befehl "" ist unbekannt !

    Hab ihn ja auch schon angeschrieben ^^
    Gerade sogar ne mail zurück bekommen!
    Zwischen einem Befehl war ein "n" irgendwie xD
    Jetz funzts super! Trotzdem danke

    //close
     
  7. Video Script

    Videos zum Themenbereich

    * gefundene Videos auf YouTube, anhand der Überschrift.