Danke
Ich habe nur leider nicht erschließen können, was genau ich machen muss.
Also muss ich jetzt nur per Hand die "structur table" durch die vom iLCH Standard ersetzen und die Datentabelle unberührt lassen ?
Kann ich nicht einfach beides zusammen fügen und dann per SQL einfügen ? ( vorher die new tabelle löschen ) ?
also so zusammenfügen ?
-- structur for table 'ic1_news'
--
DROP TABLE IF EXISTS `ic1_news`;
CREATE TABLE `ic1_news` (
`news_id` int(10) unsigned NOT NULL auto_increment,
`news_id` int(10) unsigned NOT NULL auto_increment,
`news_title` varchar(100) NOT NULL default '',
`user_id` int(11) NOT NULL default '0',
`news_time` datetime NOT NULL default '0000-00-00 00:00:00',
`news_recht` int(11) NOT NULL default '0',
`news_kat` varchar(100) NOT NULL default '',
`news_text` text,
PRIMARY KEY (`news_id`)
) ENGINE=MyISAM COMMENT='powered by ilch.de';
--
-- data for table 'ic1_news'
--
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('18','EXCLUSIVE BLOOD LiNE INTERVIEW WITH KEN SILVERMAN ','1','2014-07-29 18:33:25',NULL,NULL,'1023','0','Allgemein','I\'ve interviewed Ken Silverman, the inventor of the Build Engine.\r\n\r\n\r\nThe Blood team spent 4 years designing the original game. I should think it would take at least as long to recreate Blood, assuming you have programmers who know what the....\r\n\r\nread the whole interview [url=http://bloodline.eu/index.php?ken]here[/url]','0','1','0',NULL,'4');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('19',' Bloodline exclusive wallpaper available now !','1','2014-08-01 20:40:06',NULL,NULL,'1023','0','Allgemein','A new wallpaper is available exclusively for you. Available in two different versions. It can be downloaded from the blood archive.\r\nI\'m here to donate some blood. Somebody else\'s... \r\n\r\n[img]https://archive.bloodline.eu/wallpaper/wallpaper_bloodline_2.jpg[/img]\r\n\r\n[img]https://archive.bloodline.eu/wallpaper/wallpaper_bloodline.jpg[/img]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('20','New blood expansion announced ','1','2014-08-04 17:14:01',NULL,NULL,'1023','0','new','Sir Seizhak announcing that he is currently working on a new addon.\r\nWhen it will be released is currently not known.\r\nStay tuned for an extensive infusion...\r\n\r\n[center][i]New files: \r\n\r\n-Scripts to launch the Add-On\r\n-New textures \r\n-New MIDI tracks\r\n-New voxels.\r\n\r\nEpisodes.\r\n\r\n5 new episodes. 9 maps per episode:\r\n\r\n-An eerie power.\r\n-Limbo.\r\n-They will repent.\r\n-The last doomed.\r\n-Caleb\'s Dream (Only for Cooperative, but playable on SP). 5 levels.\r\n\r\nAnd 10 new BloodBath maps.[/i]\r\n[/center]\r\n\r\n\r\nScreenshots are available at [url=http://bloodhispano.ucoz.es/photo/cabal_39_s_return_add_on/12]Blood Hispano[/url]','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('15','BLOOD is now available on STEAM !','1','2014-07-15 17:41:50',NULL,NULL,'1023','0','new','It is the same version that is sold on GOG.I would still advise to purchase that game on GoG.\r\n[url=http://store.steampowered.com/app/299030/]One Unit Whole Blood for 5,99[/url]\r\n[url=http://store.steampowered.com/app/299050/]Blood 2[/url]\r\n\r\nIncludes the original Blood and addons: Plasma Pak and Cryptic Passage \r\n','0','1','0',NULL,'2');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('17','Buildsharp. A new hope.','3','2014-07-25 13:48:23',NULL,NULL,'1022','0','Allgemein','As you may know there\'re some proyects which try to emulate Blood properly: Transfusion (dead), C2G (dead), ZBlood (dead), Blood XL, and other ones.\r\n\r\nBuidsharp is a new proyect leaded by Cosmo. He explains all you need to know:\r\n\r\n[i]BuildSharp is an application, currently in development, that can read from and utilise assets from Build games and be used to generate games via a scripting language. Developed in C# and using XNA (but planning to move to MonoGame when able) The primary focus is on the Build game \"Blood\" as it is currently one of the main three Build games (the others being Duke Nukem 3D and Shadow Warrior) that has not had it\'s source code released. This site is still quite new, so please check out our Facebook page for details of our development so far. [/i]\r\n\r\nVisit the BuildSharp\'s Official Youtube channel to watch updates like this one:\r\n\r\n[center][video=YouTube]L1hrNuOMarA[/video][/center]\r\n\r\n\r\nAlso go to the [url=https://sites.google.com/site/buildsharp/]official site[/url] to read the last fresh news.\r\n\r\nHappy BloodBath!','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('39','Blood-Evolution a new remake !','1','2015-01-18 13:03:50',NULL,NULL,'1023','0','Allgemein','[center][i]\"Well as you can see blood evolution is a remake of the original blood game from monolith released back in 1997 . For those of you who remember it, awesome! for those of you who don\'t, I\'m sure you\'ll be pleased with the game and experience something totally new and refreshing.\"[/i]\r\n\r\n[img]https://www.bloodline.eu/images/news/blood_EV.jpg[/img]\r\n\r\n[i]\"I have about 14 years experience with game development and have worked with companies like Interceptor-Entertainment on titles like Duke Nukem Reloaded and Rise Of The Triad. So I\'ve made a lot of contacts in the industry therefore able to get help where I need it.\r\nI will release a full working game with working game-play systems and sounds ect. all this will include a remake or re-envisioning of the first level of the original and include Multi-player and Co-op. After that, The first episode, and if that goes well the next 2 episodes.\"[/i]\r\n\r\nSo far the game consists of about 200 textures all with normals, specular and a bunch of models.\r\n\r\n[url=http://www.moddb.com/games/blood-evolution]BloodEvolution@moddb.com[/url]\r\n[/center]','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('33','The Lost Episode released,eight maps from the alpha','1','2014-11-30 12:33:21',NULL,NULL,'1023','0','new','[center][img]https://bloodline.eu/images/news/LEP.png[/img]\r\n\r\n[i]\"This Episode is made up of eight maps taken straight from the leaked alpha. There are minor changes in aesthetics in a few of the maps however I made sure to keep all maps as close to the original authors intentions and art direction as possible. Story, how to install and commentary are provided in an accompanying readme.... I hope you enjoy.\"\r\n [/i]\r\n[url=http://archive.bloodline.eu/addons/TheLostEpisode.zip]download@archive.bloodline.eu[/url]\r\n\r\n[url=http://blood.freeminded.de/index.php?map=502]download@blood.freeminded.de[/url]\r\n\r\n[url=http://www.the-postmortem.com/forum/viewtopic.php?&p=51997#p51997]kingmaz- thread@ThePostmortem.[/url]\r\n\r\n[shot]https://bloodline.eu/images/news/LE_1.jpg[/shot][shot]https://bloodline.eu/images/news/LE_2.jpg[/shot][shot]https://bloodline.eu/images/news/LE-3.jpg[/shot][shot]https://bloodline.eu/images/news/LE-4.jpg[/shot][/center]','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('32','Gggmanlives - Deathwish Mod for Blood','1','2014-11-28 23:23:34',NULL,NULL,'1023','0','Allgemein','Death Wish is a modification developed by Dustin \"Bloatoid\" Twilley that adds an additional three episodes and over thirty new levels to Blood. The project was started in January of 2010 with the aim of it being completed by the years end. Development later expanded into 2011, with it finally being released on October 31, 2011.\r\n\r\n[center][video=YouTube]D4Fotgr5e3k[/video][/center]\r\n\r\nThe mod is distributed as a plain Zip archive file that simply holds a folder with all the files, with the user only needing to extract the files into their Blood directory. The author wanted it to be as easy as possible, especially since he was not trying to add any new textures or replace any sounds.\r\n','0','1','0',NULL,'2');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('14','Caleb Will Have His Revenge On Toronto 2 announced !','1','2014-06-29 20:22:49',NULL,NULL,'1023','0','new','Today I saw on the partner side that a teaser to \"Caleb Will Have His Revenge On Toronto 2\" was announced.ILMH confirmed CWHHROT 2 appears in the near future. The first part was very good, stay tuned for more :-)\r\nThe current teaser\r\n\r\n[center][video=YouTube]vj6S_3TkKoI[/video][/center]','0','1','0',NULL,'2');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('25',' OUWB for only 1.89 €','1','2014-09-26 21:26:48',NULL,NULL,'1023','0','Allgemein','[center]BLOOD is available currently, only for € 1.89.\r\n\r\nAbout: You carved your soul to shreds in servitude to a dark god, but false promises and betrayal were your only reward. Now you have a score to settle and it will be measured in blood! Experience the madness in one carnage-soaked package! All the gore, all the unholy war! Zombies, gargoyles, hellhounds and blood-crazed hordes of horrors await! Crush loathsome evil of the mighty Tchernobog! Or condemn yourself to eternal damnation in this leviathan of unhallowed gaming action!\r\n\r\n Includes the original Blood and addons: Plasma Pak and Cryptic Passage\r\n Various, often crazy weapon types like a pitchfork, flare gun or a Voodoo doll\r\n A grim atmosphere with an abundance of graphical violence, offset by dark humor and cheesy one-liners \r\n\r\n[url=http://www.gog.co/game/one_unit_whole_blood]www.gog.com[/url][/center]\r\n\r\n','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('22','New blood fanart','1','2014-08-17 21:36:11',NULL,NULL,'1023','0','Allgemein','Work on new blood fanart ! \r\nmade by a friend...\r\n\r\n[center][img]https://bloodline.eu/DiV/gar_z.jpg[/img][/center]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('23','New French Meat 2 screamshots !','1','2014-08-23 22:14:42',NULL,NULL,'1023','0','new','New French Meat screamshots from episode 2 (map 1 and 2) !\r\n\r\n[shot]http://bloodline.eu/images/news/FM_1.jpg[/shot][shot]http://bloodline.eu/images/news/FM_2.jpg[/shot][shot]http://bloodline.eu/images/news/FM_3.jpg[/shot][shot]http://bloodline.eu/images/news/FM_5.jpg[/shot]\r\n\r\n\r\n','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('24','BuildSharp Actor Viewer - Alpha 1 ','1','2014-09-26 20:16:45',NULL,NULL,'1023','0','new','A quick run through of the BuildSharp Actor Viewer, it\'s current status, and plans for the future.\r\n[center]\r\n[video=YouTube]GDI0wWKCV5g[/video][/center]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('27','New French Meat screamshots','1','2014-10-20 17:22:17',NULL,NULL,'1023','0','Allgemein','New French Meat screamshots from episode 2 (map 1 and 2) !\r\n\r\n[shot]https://bloodline.eu/images/news/FM7.jpg[/shot][shot]https://bloodline.eu/images/news/FM8.jpg[/shot]','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('29',' 3D Realms Anthology','1','2014-10-26 17:04:24',NULL,NULL,'1023','0','Spiele','The 3D Realms Anthology is a download-only 32-game collection - that’s the entire 3D Realms library (excluding Max Payne and Prey) brought together by a brand-new, custom-made Anthology launcher built to run on Windows\r\n[center][img]https://bloodline.eu/images/news/box.png[/img][/center]\r\n\r\n\r\n\r\nAnthology also includes a completely original re-rockestarted soundtrack, with 9 remade tracks from a range of classic 3D Realms titles such as Duke Nukem II, Wacky Wheels, Bio Menace, Major Stryker and Shadow Warrior.\r\n\r\n[center][video=YouTube]a1aU4Rtnlws[/video][/center]\r\n\r\nEvery game in the collection is DRM-free and has partial controller support. \r\n\r\n[url=https://3drealms.com/news/3d_realms-is-back/]This product is only available via download.[/url]','0','1','0',NULL,'6');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('30',' BuildSharp - update on what\'s going and current plans','1','2014-11-06 21:33:12',NULL,NULL,'1023','0','new','[center]Cosmo describe the situation with BuildSharp and what the current plan is in regard to fixing the problems with it and what the future holds!\r\n\r\n\r\n\r\n[video=YouTube]6j8AeLKoB-M[/video][/center]','0','1','0',NULL,'0');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('40',' FAITD is released','1','2015-01-20 16:29:28',NULL,NULL,'1023','0','new','Updated BAITD series returns to say \"goodbye\"!This final compilation of BAITD series let you play (almost) all parts of mod.\r\n\r\n[center][img]https://bloodline.eu/images/news/naitd_1.png[/img]\r\n\r\n[i]\r\n BAITD is pure experimental mod that show to users new ways to mod the game and dedicated to original Alone In The Dark game series. Since 2006 year author(s) trying to expand gameplay and push the limits of Build Engine. It was first mod with new voxel models, weapons, non-linearity and monster experiments. NoOne,2015\r\n [/i]\r\n[url=http://archive.bloodline.eu/addons/TheLostEpisode.zip]download@archive.bloodline.eu[/url]\r\n\r\n[url=http://blood.freeminded.de/index.php?map=502]download@cruo.bloodgame.ru[/url]\r\n\r\n\r\n\r\n[shot]https://bloodline.eu/images/news/naitd_2.png[/shot][shot]https://bloodline.eu/images/news/naitd_3.png[/shot][shot]https://bloodline.eu/images/news/naitd_4.png[/shot][shot]https://bloodline.eu/images/news/naitd_5.png[/shot]\r\n[/center]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('34','More BuildSharp!','3','2014-12-19 15:58:36',NULL,NULL,'1023','0','new','Here\'s another cool video from Cosmo explaining stuff about his project.\r\n\r\n[video=YouTube]kx4KewUW9l0[/video]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('38','Cryptic Passage - hires scann','1','2015-01-10 21:32:21',NULL,NULL,'1023','0','Allgemein','A new hires scan of an cryptic passage-add is now aviable. Thank to macwiczech who scann it. \r\n\r\n[center][img]https://archive.bloodline.eu/images/poster/cryptic_ad.jpg[/img][/center]','0','1','0',NULL,'1');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('41','German Shareware 1.00 ','1','2015-01-31 22:16:58',NULL,NULL,'1023','0','Allgemein','[center]An official shareware has never been published in Germany.\r\nThe main reason is the indexing by the BPjM.\r\n\r\n[img]https://bloodline.eu/images/news/SHD.png[/img]\r\n\r\nHowever, \"Robert Mundt Software\" produced a bootleg, which containing the shareware 1.00, a Windows-Insta-Routine and cheats. They design an own back and front cover:[/center]\r\n[center]\r\n\r\n\r\n[url=https://archive.bloodline.eu/misc/BloodSharewareGerman.rar]download ISO @archive.bloodline.eu[/url]\r\n\r\n[shot]https://archive.bloodline.eu/images/cover/bootleg/blood_german_bl_front_2.JPG[/shot][shot]https://archive.bloodline.eu/images/cover/bootleg/blood_german_bl_back.JPG[/shot]\r\n\r\n[/center]','0','1','0',NULL,'6');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`editor_id`,`edit_time`,`news_recht`,`news_groups`,`news_kat`,`news_text`,`html`,`show`,`archiv`,`endtime`,`klicks`) VALUES ('42','new flyer scanns','1','2015-02-10 22:34:02',NULL,NULL,'1023','0','Allgemein','[center][img]https://www.bloodline.eu/images/news/AD1.jpg[/img][img]https://www.bloodline.eu/images/news/AD2.jpg[/img][/center]','0','1','0',NULL,'4');
