ilch Forum » Allgemein » HTML, PHP, SQL,... » SQL Fehlermeldung :-/

Gehe zu Seite:

Geschlossen

Seite 2 von 2 ‹12›

So. 22.03.2015 15:03 Uhr #31

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen

Danke, hat keine Meldung ergeben.
Die "news_tabelle" wurde angelegt und die Fehlermeldung auf der startseite ist weg. Nur wie füge jetzt den Inhalt wieder ein ?

The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
So. 22.03.2015 15:09 Uhr #32

Nex4T Moderator

Registriert seit
28.02.2007

Beiträge
3.414

Beitragswertungen
So ich hab dir das mal hier angepasst, ist aber nur eine test news, sprich du darfst die werte von deiner alten News in der hier vorgegebenen Struktur füllen, VALUES sind die werte die er später dann übernimmt. davor gibt er die Struktur an wie das ganze worein gefüllt wird.
```
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('1','NEWSTITEL','1','2014-07-29 18:33:25','NULL','Allgemein','NEWS TEST TEXT... Hier kommt ddann dein Text rein');
```
ebenfalls diesen Befehl über dein Phpmyadmin ausführen

Was du beachten muss ist, die news_id der news darf niemals doppelt dortstehen würde sowieso nicht angenommen werden aber mann kann ja fehler von vorne rein vermeiden, news_title spricht für sich. user_id halt deine id bzw. die id vom News schreiber, news_time ist die zeit wann die news geschrieben wurde, news_kat welche Kategorie das ganze angehört, news_text halt der content Sichtbare Inhalt. news_recht soltest du erstmal nur auf NULL lassen.

Zuletzt modifiziert von Nex4T am 22.03.2015 - 15:17:40
while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu
1 Mitglieder finden den Beitrag gut.
- zitieren

So. 22.03.2015 15:40 Uhr #33

MOODFOR Mitglied

Danke meine Tabelle sieht jetzt so aus :

INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) VALUES ('25',' OUWB for only 1.89 &#128;','1','2014-09-26 21:26:48',NULL,NULL,'1023','0','Allgemein','[center]BLOOD is available currently, only for &#128; 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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&#146;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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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`,`news_recht`,`news_kat`,`news_text`) 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');

und ich bekomme die fehlermedlung :

Error

SQL query:

INSERT INTO `ic1_news` ( `news_id` , `news_title` , `user_id` , `news_time` , `news_recht` , `news_kat` , `news_text` )
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'
);

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 15:41:18

The government pretend,
they your friend. And then when you steal some shit,they put you in jail

0 Mitglieder finden den Beitrag gut.

zitieren

So. 22.03.2015 15:42 Uhr #34

Nex4T Moderator

Registriert seit
28.02.2007

Beiträge
3.414

Beitragswertungen

Ja wie ich schon sagte du kanst nicht einfach deine alte news rauskopieren und dort einfügen weil deine alte news aus mehreren Spalten besteht als jetzt vorhanden du musst das von hand aus abändern so wie ich dir gezeigt habe. Alternative währe das du alles neu über das Admin menü schreibst Sprich du kopierst dir von jeder news den titel und den text raus

while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu
0 Mitglieder finden den Beitrag gut.
- zitieren
So. 22.03.2015 16:02 Uhr #35

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen
Okay, dann wäre aber der Zeitstempel ja nicht mehr richtig.
Aber welche Spalten sind den zu viel vorhanden ?
```
'41','German Shareware 1.00 ','1','2015-01-31 22:16:58',NULL,NULL,'1023','0','Allgemein',
```
Hier sind doch nur die Spalten :
`news_id` , `news_title` , `user_id` , `news_time` , `news_recht` , `news_kat` , `news_text`

vorhanden ?
oder gehört das nicht mehr rein :
'1023','0'

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 16:04:10
The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
So. 22.03.2015 16:08 Uhr #36

Nex4T Moderator

Registriert seit
28.02.2007

Beiträge
3.414

Beitragswertungen
Schau mal ich hab dir hier ein beispiel angezeigt
dementsprechend brauchst du eig. nur noch von deinen alten news die id, titel und text ändern
```
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('1','NEWSTITEL','1','2014-07-29 18:33:25','NULL','Allgemein','NEWS TEST TEXT... Hier kommt ddann dein Text rein');
```
Kopier dir das einfach ein parr mal und änder jeweils id,titel,text

Zuletzt modifiziert von Nex4T am 22.03.2015 - 16:09:41
while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu
0 Mitglieder finden den Beitrag gut.
- zitieren

So. 22.03.2015 16:17 Uhr #37

Nex4T Moderator

so hier nochmal abegändert für dich...

INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('18','EXCLUSIVE BLOOD LiNE INTERVIEW WITH KEN SILVERMAN ','1','2014-07-29 18:33:25',NULL,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('19',' Bloodline exclusive wallpaper available now !','1','2014-08-01 20:40:06',NULL,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('20','New blood expansion announced ','1','2014-08-04 17:14:01',NULL,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('15','BLOOD is now available on STEAM !','1','2014-07-15 17:41:50',NULL,'Allgemein','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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('17','Buildsharp. A new hope.','3','2014-07-25 13:48:23',NULL,'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!');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('39','Blood-Evolution a new remake !','1','2015-01-18 13:03:50',NULL,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('33','The Lost Episode released,eight maps from the alpha','1','2014-11-30 12:33:21',NULL,'Allgemein','[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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('32','Gggmanlives - Deathwish Mod for Blood','1','2014-11-28 23:23:34',NULL,'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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('14','Caleb Will Have His Revenge On Toronto 2 announced !','1','2014-06-29 20:22:49',NULL,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('25',' OUWB for only 1.89 &#128;','1','2014-09-26 21:26:48',NULL,'Allgemein','[center]BLOOD is available currently, only for &#128; 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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('22','New blood fanart','1','2014-08-17 21:36:11',NULL,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('23','New French Meat 2 screamshots !','1','2014-08-23 22:14:42',NULL,'Allgemein','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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('29',' 3D Realms Anthology','1','2014-10-26 17:04:24',NULL,'Allgemein','The 3D Realms Anthology is a download-only 32-game collection - that&#146;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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('30',' BuildSharp - update on what\'s going and current plans','1','2014-11-06 21:33:12',NULL,'Allgemein','[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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('40',' FAITD is released','1','2015-01-20 16:29:28',NULL,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('34','More BuildSharp!','3','2014-12-19 15:58:36',NULL,'Allgemein','Here\'s another cool video from Cosmo explaining stuff about his project.\r\n\r\n[video=YouTube]kx4KewUW9l0[/video]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('38','Cryptic Passage - hires scann','1','2015-01-10 21:32:21',NULL,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('41','German Shareware 1.00 ','1','2015-01-31 22:16:58',NULL,'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]');

while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu

0 Mitglieder finden den Beitrag gut.

zitieren

So. 22.03.2015 16:31 Uhr #38

MOODFOR Mitglied

Danke !

Hab´s eigenfügt und gleich die nächste Meldung :

SQL query:

INSERT INTO `ic1_news` ( `news_id` , `news_title` , `user_id` , `news_time` , `news_recht` , `news_kat` , `news_text` )
VALUES (
'18', 'EXCLUSIVE BLOOD LiNE INTERVIEW WITH KEN SILVERMAN ', '1', '2014-07-29 18:33:25', NULL , '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]'
);

MySQL said: Documentation
#1048 - Column 'news_recht' cannot be null

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 16:31:28

The government pretend,
they your friend. And then when you steal some shit,they put you in jail

0 Mitglieder finden den Beitrag gut.

zitieren

So. 22.03.2015 16:34 Uhr #39

Nex4T Moderator

Fehler von mir

INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('18','EXCLUSIVE BLOOD LiNE INTERVIEW WITH KEN SILVERMAN ','1','2014-07-29 18:33:25',1023,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('19',' Bloodline exclusive wallpaper available now !','1','2014-08-01 20:40:06',1023,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('20','New blood expansion announced ','1','2014-08-04 17:14:01',1023,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('15','BLOOD is now available on STEAM !','1','2014-07-15 17:41:50',1023,'Allgemein','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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('17','Buildsharp. A new hope.','3','2014-07-25 13:48:23',1023,'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!');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('39','Blood-Evolution a new remake !','1','2015-01-18 13:03:50',1023,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('33','The Lost Episode released,eight maps from the alpha','1','2014-11-30 12:33:21',1023,'Allgemein','[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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('32','Gggmanlives - Deathwish Mod for Blood','1','2014-11-28 23:23:34',1023,'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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('14','Caleb Will Have His Revenge On Toronto 2 announced !','1','2014-06-29 20:22:49',1023,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('25',' OUWB for only 1.89 &#128;','1','2014-09-26 21:26:48',1023,'Allgemein','[center]BLOOD is available currently, only for &#128; 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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('22','New blood fanart','1','2014-08-17 21:36:11',1023,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('23','New French Meat 2 screamshots !','1','2014-08-23 22:14:42',1023,'Allgemein','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');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('29',' 3D Realms Anthology','1','2014-10-26 17:04:24',1023,'Allgemein','The 3D Realms Anthology is a download-only 32-game collection - that&#146;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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('30',' BuildSharp - update on what\'s going and current plans','1','2014-11-06 21:33:12',1023,'Allgemein','[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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('40',' FAITD is released','1','2015-01-20 16:29:28',1023,'Allgemein','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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('34','More BuildSharp!','3','2014-12-19 15:58:36',1023,'Allgemein','Here\'s another cool video from Cosmo explaining stuff about his project.\r\n\r\n[video=YouTube]kx4KewUW9l0[/video]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('38','Cryptic Passage - hires scann','1','2015-01-10 21:32:21',1023,'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]');
INSERT INTO `ic1_news` (`news_id`,`news_title`,`user_id`,`news_time`,`news_recht`,`news_kat`,`news_text`) VALUES ('41','German Shareware 1.00 ','1','2015-01-31 22:16:58',1023,'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]');

while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu

1 Mitglieder finden den Beitrag gut.

zitieren

So. 22.03.2015 16:42 Uhr #40

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen
Vielen Dank !

Jetzt sind die Nachrichten wieder, da doch die Fehlermeldung ( wenn man nicht eingeloggt auf die "news" klickt" ) ist immer noch da
```
Fatal error: Call to a member function out() on null in /customers/5/b/d/bloodline.eu/httpd.www/include/contents/news.php on line 239
```
In der Zeile steht immer noch :
```
    }
        }
  $tpl->out(5);
}
```
Scheint also doch was mit dem News Teilen 1.0 Modul zu tun, zu haben.

externer Link

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 16:51:36
The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
So. 22.03.2015 16:51 Uhr #41

Siggi Hall Of Fame

Registriert seit
08.02.2007

Beiträge
6.558

Beitragswertungen

Dann poste mal die News.php

Wie poste ich falsch?
0 Mitglieder finden den Beitrag gut.
- zitieren

So. 22.03.2015 16:59 Uhr #42

MOODFOR Mitglied

owbwohl. ich habe grade die standart ilch_news.php hochgeladen, die Fehlermeldung bleibt trotzdem.

<?php
#   Copyright by: Manuel
#   Support: www.ilch.de


defined ('main') or die ( 'no direct access' );



$title = $allgAr['title'].' :: News';
$hmenu = 'News';
$design = new design ( $title , $hmenu );
$design->addheader('<link rel="alternate" type="application/atom+xml" title="News (Atom)" href="index.php?news-atom" />
<link rel="alternate" type="application/rss+xml" title="News (RSS)" href="index.php?news-rss" />
<link rel="stylesheet" href="include/includes/css/teilen.css" type="text/css" />');

function news_find_kat ($kat) {

                $katpfad = 'include/images/news/';
                $katjpg = $katpfad.$kat.'.jpg';
                $katgif = $katpfad.$kat.'.gif';
                $katpng = $katpfad.$kat.'.png';

                if ( file_exists( $katjpg ) ) {
                  $pfadzumBild = $katjpg;
                } elseif ( file_exists ( $katgif ) ) {
                  $pfadzumBild = $katgif;
                } elseif ( file_exists ( $katpng ) ) {
                  $pfadzumBild = $katpng;
                }

                if ( !empty( $pfadzumBild ) ) {
                        $kategorie = '<img style="" src="'.$pfadzumBild.'" alt="'.$kat.'">';
                } else {
                  $kategorie = '<b>'.$kat.'</b><br /><br />';
                }

                return ( $kategorie );
}

function url($teilenurl){
    if(isset($_SERVER['HTTPS'])){
        $protocol = ($_SERVER['HTTPS'] && $_SERVER['HTTPS'] != "off") ? "https" : "http";
    }
    else{
        $protocol = 'http';
    }
    return $protocol . "://" . $_SERVER['HTTP_HOST'] . $_SERVER['SCRIPT_NAME'];
}



if ( !is_numeric($menu->get(1)) )  {
  if($menu->get(1) == 'rss' || $menu->get(1) == 'atom')
  {
      #ob_clean();
      $feed_type = $menu->get(1);

    $abf = "SELECT MAX(news_time) AS last_update FROM prefix_news";
    $erg = db_query($abf);
    $row = db_fetch_assoc($erg);
    $last_update = str_replace(' ', 'T', $row['last_update']) . 'Z';

    $abf = "SELECT
      a.news_title as title,
      a.news_id as id,";
    $abf .= ($feed_type == 'atom') ? 'a.news_time as datum,' : "DATE_FORMAT(a.news_time,'%a, %e %b %y %H:%i:%s') as datum,";
    $abf .=
     "a.news_kat as kate,
      a.news_text as text,
      b.name as username
    FROM prefix_news as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE a.news_recht = 0
    ORDER BY news_time DESC LIMIT 15";
    $erg = db_query($abf);
    $tpl = new tpl( 'news_'.$menu->get(1).'.htm' );

    header('Content-type: application/' . $menu->get(1)  . '+xml');

    $tpl->set_ar_out(array('FEEDTITLE' => $allgAr['title'],
                           'UPDATED' => $last_update,
                           'SITEURL' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF'])), 0);
    while ($row = db_fetch_assoc($erg))
    {
      if($feed_type == 'atom')
      {
                $Z = (date('Z') > 0 ? '+' : '').date('H:i:s', date('Z') + 23 * 3600);
                $row['datum'] = str_replace(' ', 'T', $row['datum']) . $Z;
      }

      $a = explode('[PREVIEWENDE]', $row['text']);
      $tpl->set_ar_out(array('TITLE' => $row['title'],
                             'TXT' => bbcode($a[0]),
                             'LINK' => 'http://' . $_SERVER['HTTP_HOST'] . dirname($_SERVER['PHP_SELF']). '/index.php?news-' . $row['id'],
                             'AUTHOR' => $row['username'],
                             'DATE' => $row['datum']
                             ), 1);
    }
    $tpl->out(2);
    exit;
  }
  else
  {
    $design->header();
    $limit = $allgAr['Nlimit'];
    $page = ( $menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
    $MPL = db_make_sites ($page , "WHERE news_recht >= ".$_SESSION['authright'] , $limit , '?news' , 'news' );
    $anfang = ($page - 1) * $limit;

    $tpl = new tpl ( 'news.htm' );

    $abf = "SELECT
      a.news_title as title,
      a.news_id as id,
      DATE_FORMAT(a.news_time,'%d. %m. %Y') as datum,
      DATE_FORMAT(a.news_time,'%W') as dayofweek,
      a.news_kat as kate,
      a.news_text as text,
      b.name as username
    FROM prefix_news as a
    LEFT JOIN prefix_user as b ON a.user_id = b.id
    WHERE ".$_SESSION['authright']." <= a.news_recht
       OR a.news_recht = 0
    ORDER BY news_time DESC
    LIMIT ".$anfang.",".$limit;
    #echo '<pre>'.$abf.'</pre>';

    $erg = db_query($abf);
    while ($row = db_fetch_assoc($erg)) {
      $k0m  = db_query("SELECT COUNT(ID) FROM `prefix_koms` WHERE uid = ".$row['id']." AND cat = 'NEWS'");
      $row['kom']  = db_result($k0m,0);
      $row['kate'] = news_find_kat($row['kate']);
      $row['teilenurl'] = url($row['teilenurl']);
      $row['newsteilen'] = '<a href = "javascript:void(0)" onclick ="document.getElementById(\'teilen'.$row['id'].'\').style.display=\'block\';document.getElementById(\'teilen_out'.$row['id'].'\').style.display=\'block\'">Teilen</a>';
      $row['teilenpermalink'] = '<input class="teilen_input" value="'.$row['teilenurl'].'?news-'.$row['id'].'" readonly="readonly" type="text" onfocus="this.select()">';
      $row['teilenbbcode'] = ''.$row['teilenurl'].'?news-'.$row['id'].'';
      $row['teilenhtml'] = ''.$row['teilenurl'].'?news-'.$row['id'].'';
      $row['teilenfb'] = '<a class="teilenfb" href="https://www.facebook.com/sharer/sharer.php?u='.$row['teilenurl'].'?news-'.$row['id'].'"></a>';
      $row['teilentwitter'] = '<a class="teilentwitter" href="https://twitter.com/home?status='.$row['teilenurl'].'?news-'.$row['id'].'"></a>';
      $row['teilengoogle'] = '<a class="teilengoogle" href="https://plus.google.com/share?url='.$row['teilenurl'].'?news-'.$row['id'].'"></a>';
      $row['teilenmail'] = '<a class="teilenmail" href="mailto:?&subject='.$row['title'].'&body=Folgende%20News%20wurde%20dir%20empfohlen:%20'.$row['teilenurl'].'?news-'.$row['id'].'"></a>';
      $row['datum'] = $lang[$row['dayofweek']].' '.$row['datum'];
      if ( strpos ( $row['text'] , '[PREVIEWENDE]' ) !== FALSE ) {
        $a = explode('[PREVIEWENDE]' , $row['text']);
        $row['text'] = $a[0];
        $row['readwholenews'] = '&raquo; <a href="index.php?news-'.$row['id'].'">'.$lang['readwholenews'].'</a>  &laquo;';
      } else {
        $row['readwholenews'] = '';
      }
      $row['text'] = bbcode($row['text']);
      $tpl->set_ar_out($row,0);
    }
    $tpl->set_out('SITELINK', $MPL,1);
    unset($tpl);
  }



} else {

 $design->header();
 $nid = escape($menu->get(1), 'integer');
 $row = db_fetch_object(db_query("SELECT * FROM `prefix_news` WHERE news_id = '".$nid."'"));

  if ( has_right(array($row->news_recht)) ) {
    $komsOK = true;
          if ( $allgAr['Ngkoms'] == 0 ) {
      if ( loggedin() ) {
        $komsOK = true;
                  } else {
                    $komsOK = false;
                  }
    }
          if ( $allgAr['Nukoms'] == 0 ) {
            $komsOK = false;
          }

    # kommentar add
          if ( (loggedin() OR chk_antispam ('newskom')) AND $komsOK AND !empty($_POST['name']) AND !empty($_POST['txt']) ) {
      $_POST['txt'] = escape($_POST['txt'],'string');
                  $_POST['name'] = escape($_POST['name'],'string');
      db_query("INSERT INTO `prefix_koms` (`uid`,`cat`,`name`,`text`) VALUES (".$nid.",'NEWS','".$_POST['name']."','".$_POST['txt']."')");
          }
          # kommentar add

    # kommentar loeschen
    if ($menu->getA(2) == 'd' AND is_numeric($menu->getE(2)) AND has_right(-7, 'news')) {
      $kommentar_id = escape($menu->getE(2),'integer');
      db_query("DELETE FROM prefix_koms WHERE uid = ".$nid." AND cat = 'NEWS' AND id = ".$kommentar_id);
    }
    # kommentar loeschen
    $kategorie = news_find_kat($row->news_kat);

                $textToShow = bbcode($row->news_text);
                $textToShow = str_replace('[PREVIEWENDE]','',$textToShow);
                if ( !empty($such) ) {
                  $textToShow = markword($textToShow,$such);
                }

                $tpl = new tpl ( 'news.htm' );
                $ar = array (
      'TEXT'  => $textToShow,
                        'KATE'  => $kategorie,
      'NID' => $nid,
      'uname' => $_SESSION['authname'],
                        'ANTISPAM' => (loggedin()?'':get_antispam ('newskom', 0)),
                        'NAME'  => $row->news_title,
                              'NEWSTEILEN'  => '<a href = "javascript:void(0)" onclick ="document.getElementById(\'teilen'.$nid.'\').style.display=\'block\';document.getElementById(\'teilen_out'.$nid.'\').style.display=\'block\'">Teilen</a>',
      'TEILENPERMALINK'  => '<input class="teilen_input" value="'.url($teilenurl).'?news-'.$nid.'" readonly="readonly" type="text" onfocus="this.select()">',
      'TEILENBBCODE'  => ''.url($teilenurl).'?news-'.$nid.'',
      'TEILENHTML'  => ''.url($teilenurl).'?news-'.$nid.'',
      'TEILENFB'  => '<a class="teilenfb" href="https://www.facebook.com/sharer/sharer.php?u='.url($teilenurl).'?news-'.$nid.'"></a>',
      'TEILENTWITTER'  => '<a class="teilentwitter" href="https://twitter.com/home?status='.url($teilenurl).'?news-'.$nid.'"></a>',
      'TEILENGOOGLE'  => '<a class="teilengoogle" href="https://plus.google.com/share?url='.url($teilenurl).'?news-'.$nid.'"></a>',
      'TEILENMAIL'  => '<a class="teilenmail" href="mailto:?&subject=Title&body=Folgende%20News%20wurde%20dir%20empfohlen:%20'.url($teilenurl).'?news-'.$nid.'"></a>'
                );
                $tpl->set_ar_out($ar, 2 );

                if ($komsOK) {
                  $tpl->set_ar_out ( array ( 'NAME' => $row->news_title , 'NID' => $nid ), 3 );
                }
    $erg1 = db_query("SELECT text, name, id FROM `prefix_koms` WHERE uid = ".$nid." AND cat = 'NEWS' ORDER BY id DESC");
                $ergAnz1 = db_num_rows($erg1);
                if ( $ergAnz1 == 0 ) {
                  echo '<b>'.$lang['nocomments'].'</b>';
                } else {
                  $zahl = $ergAnz1;
                  while ($row1 = db_fetch_assoc($erg1)) {
        $row1['text'] = bbcode(trim($row1['text']));
        if (has_right(-7, 'news')) {
          $row1['text'] .= '<a href="?news-'.$nid.'-d'.$row1['id'].'"><img src="include/images/icons/del.gif" alt="l&ouml;schen" border="0" title="l&ouml;schen" /></a>';
        }
        $tpl->set_ar_out( array('NAME' => $row1['name'], 'TEXT' => $row1['text'], 'ZAHL' => $zahl ) , 4 );
        $zahl--;
                  }
    }
        }
  $tpl->out(5);
}

$design->footer();

?>

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 17:01:32

The government pretend,
they your friend. And then when you steal some shit,they put you in jail

0 Mitglieder finden den Beitrag gut.

zitieren

So. 22.03.2015 18:07 Uhr #43

Nex4T Moderator

Registriert seit
28.02.2007

Beiträge
3.414

Beitragswertungen

Das ist aber nicht die standart news.php Die Funktionen "Teilen" gibts in der Standart nicht!

while(!asleep()) sheep++;
www.movely.biz
www.webplant.eu
1 Mitglieder finden den Beitrag gut.
- zitieren
So. 22.03.2015 18:44 Uhr #44

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen

Mit hochgeladen meinte ich auf meinem Server, ich verwende die standard news+ news teilen von maretz.
Die im Thread ist die news.php die ich normalerweise verwende...

Könnte die Fehlermedlung nicht irgendwas mit Rechten zu tun haben, immerhin erscheint sie nur wenn ich ausgeloggt bin. Eingeloggt funktioniert alles einwandfrei...

Zuletzt modifiziert von HATEFRONT am 22.03.2015 - 18:48:37

The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
Mi. 25.03.2015 11:59 Uhr #45

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen

Niemand ne Idee ?

The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
Mi. 25.03.2015 12:43 Uhr #46

Siggi Hall Of Fame

Registriert seit
08.02.2007

Beiträge
6.558

Beitragswertungen

Du hast in der DB die Standard News Table dann nutze auch die Standard News.php

Wie poste ich falsch?
2 Mitglieder finden den Beitrag gut.
- zitieren
Mi. 25.03.2015 19:05 Uhr #47

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen
Danke,ich verwende ja nur "news- teilen" und das Modul legt soweit ich weiß keine neuen Tabellen in der Datenbank an.
Und ich habe oben ja schon geschrieben, dass ich die "standard-news" testweise hochgeladen habe. Trotzdem bleibt der Fehler bestehen.
Hier nochmal die Fehlermeldung :
```
Fatal error: Call to a member function out() on null in /customers/5/b/d/bloodline.eu/httpd.www/include/contents/news.php on line 239
```
The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
Mi. 25.03.2015 19:15 Uhr #48

Maretz Hall Of Fame

Registriert seit
28.02.2009

Beiträge
740

Beitragswertungen

Mir ist dieser fehler nur bekannt in Verbindung mit der ext. News. Es wurde das ext.News Modul installiert und nach geraumer Zeit wieder die original Dateien , bzw normale News Ansicht aufgeladen.
Ggf. mal einfach die ext. News Dateien aufladen und schauen, wie sich dies verhält.Man kann ja bei dem Versuch nichts verlieren,sofern man nicht die News ändert... . Mit der News Teilen Funktion hat das alles nichts zu tun.Dabei wurden nur die Dateien erweitert....

Mfg Maretz

PS: Um langes Theater zu vermeiden News Bereich neu auflegen.... Wirst ja sicherlich nicht für die Bild schaffen ....

Zuletzt modifiziert von Maretz am 25.03.2015 - 19:16:14

Ilch Templates and Modules
0 Mitglieder finden den Beitrag gut.
- zitieren
Mi. 25.03.2015 20:44 Uhr #49

Outi77 Mitglied

Registriert seit
31.03.2013

Beiträge
1.337

Beitragswertungen
Also eigentlich sagt die Fehlermeldung aus, dass Du irgendwo im Code versuchst, das Template auszugeben, zu diesem Zeitpunkt aber noch keines definiert wurde.
Das könnte eventuell bei einer if-Abfrage der Fall sein, wo nur für einen Fall das Template definiert wurde.
Dieser Sachverhalt ist einfach zu reproduzieren, indem man einfach mal irgendwo die Zeile mit
```
$tpl = new tpl ( 'gbook' );
```
entfernt...das Gästebuch ist hier nur ein Beispiel

Nachtrag:
In Deiner geposteten php hast Du 1 großen if-else-Zweig...
```
if ( !is_numeric($menu->get(1)) )  {
   ...
} else {
   ...
}
```
Im else-Zweig beginnt nach 3 Zeilen eine weitere if-Abfrage...
```
if ( has_right(array($row->news_recht)) ) {
```
in der Du $tpl neu setzt. Das heißt, außerhalb dieser ist aktuell also $tpl noch nicht definiert. Das
```
$tpl->out(5);
```
in Zeile 239 steht außerhalb dieser, hier wird versucht, ein Template auszugeben, welches noch nicht definiert wurde.
Wenn Du zu Beginn des else-Zweiges der großen Abfrage das
```
$tpl = new tpl ( 'news.htm' );
```
setzt, sollte die Fehlermeldung verschwinden.
Also:
Zeile 201
```
$tpl = new tpl ( 'news.htm' );
```
versetzen nach Zeile 165.

Zuletzt modifiziert von Outi77 am 26.03.2015 - 06:11:34
Die richtige Formulierung eines Problems ist nicht selten bereits die halbe Lösung.
»Albert Einstein«
0 Mitglieder finden den Beitrag gut.
- zitieren

Sa. 28.03.2015 10:56 Uhr #50

MOODFOR Mitglied

Zitat geschrieben von Outi77

Also eigentlich sagt die Fehlermeldung aus, dass Du irgendwo im Code versuchst, das Template auszugeben, zu diesem Zeitpunkt aber noch keines definiert wurde.
Das könnte eventuell bei einer if-Abfrage der Fall sein, wo nur für einen Fall das Template definiert wurde.
Dieser Sachverhalt ist einfach zu reproduzieren, indem man einfach mal irgendwo die Zeile mit

$tpl = new tpl ( 'gbook' );

entfernt...das Gästebuch ist hier nur ein Beispiel zwinker

Nachtrag:
In Deiner geposteten php hast Du 1 großen if-else-Zweig...

if ( !is_numeric($menu->get(1)) )  {
   ...
} else {
   ...
}

Im else-Zweig beginnt nach 3 Zeilen eine weitere if-Abfrage...

if ( has_right(array($row->news_recht)) ) {

in der Du $tpl neu setzt. Das heißt, außerhalb dieser ist aktuell also $tpl noch nicht definiert. Das

$tpl->out(5);

in Zeile 239 steht außerhalb dieser, hier wird versucht, ein Template auszugeben, welches noch nicht definiert wurde.
Wenn Du zu Beginn des else-Zweiges der großen Abfrage das

$tpl = new tpl ( 'news.htm' );

setzt, sollte die Fehlermeldung verschwinden.
Also:
Zeile 201

$tpl = new tpl ( 'news.htm' );

versetzen nach Zeile 165.

Zuletzt modifiziert von Outi77 am 26.03.2015 - 06:11:34

Danke, hat leider icht funktioniert.
Ich habe ein bisschen rumprobiert und habe letztendlich rausgefunden, dass der Fehler von der "news-tabelle" ausgeht.

Ich würde dann die Seite neu installieren und die Nachrichten neu einfügen.
Die einzige Tabelle, die ich übernehmen will ist die user_tabelle.
Ich möchte jedoch die ilch_bb einträge enfernen und die Anzahl der post auf 0 setzen. Ich hab es vesucht, bekomme abe eine Fehlermeldung.
Wie entferne ich das jetzt richtig ?

-- ----------------------------------------------------------
--
-- structur for table 'ic1_user'
--
DROP TABLE IF EXISTS `ic1_user`;
CREATE TABLE `ic1_user` (
    `id` int(10) unsigned NOT NULL auto_increment,
    `name` varchar(50) NOT NULL,
    `pass` varchar(123) NOT NULL,
    `recht` int(1) DEFAULT '0' NOT NULL,
    `posts` int(5) DEFAULT '0' NOT NULL,
    `regist` int(20) DEFAULT '0',
    `email` varchar(100) NOT NULL,
    `llogin` int(20) DEFAULT '0',
    `spezrank` mediumint(9) DEFAULT '0' NOT NULL,
    `opt_pm` tinyint(1) DEFAULT '0' NOT NULL,
    `opt_pm_popup` tinyint(1) DEFAULT '0' NOT NULL,
    `opt_mail` tinyint(1) DEFAULT '0' NOT NULL,
    `status` tinyint(1) DEFAULT '0' NOT NULL,
    `geschlecht` tinyint(1) DEFAULT '0' NOT NULL,
    `gebdatum` date DEFAULT '0000-00-00' NOT NULL,
    `wohnort` varchar(50) NOT NULL,
    `homepage` varchar(100) NOT NULL,
    `staat` varchar(50) NOT NULL,
    `avatar` varchar(100) NOT NULL,
    `icq` varchar(20) NOT NULL,
    `msn` varchar(50) NOT NULL,
    `yahoo` varchar(50) NOT NULL,
    `aim` varchar(50) NOT NULL,
    `sig` text,
    `ilchbb_lastquery` int(11) NOT NULL,
    `ilchbb_newtopics` text NOT NULL,
   PRIMARY KEY (`id`)
) AUTO_INCREMENT=13;

--
-- data for table 'ic1_user'
--
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('1','L3GEND','$5$rounds=9834$EmrzikoP3OoH0zlW$lmAO102NqabUDWGvbUwu0CcJaniwxcrwYb2R/J.UiB0','-9','43','1392201180','cruo@web.de','1427532291','0','1','1','1','1','1','1988-10-19','','http://bloodline.eu','Germany.gif','include/images/avatars/1.gif','','','','','[img]https://bloodline.eu//include/images/usergallery/img_37.gif[/img]\r\n','1427532229','a:0:{}');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('5','bloodmapedit','$5$rounds=8513$mWioNPpBtiCz46bZ$zX7EcBbY0SLCIwWrdYcLcuHLVdrkpHotGtI9xR9y1X4','-1','0','1407184493','bloodmapedit@gmx.com','1407184493','0','1','0','1','1','0','0000-00-00','','','','','','','','',NULL,'0','');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('3','Sir Seizhak','$5$rounds=5532$QmPJUm9k3ylIYikK$4iJppRYsLhdLpza3JYstpuLZL.MkY37lsDCiiWTKqe3','-1','37','1405346433','bloodhispano@hotmail.es','1421263058','0','1','0','1','1','1','1989-08-09','Castilla La-Mancha','http://bloodhispano.ucoz.es/','Spain.gif','include/images/avatars/3.jpg','','','','','Denme la razón porque sí, o eso dicen...','1421263044','a:1:{i:4;a:1:{i:37;s:10:\"1419000952\";}}');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('4','junga','$5$rounds=8537$VPfzTHAGnggMfQ0P$ZgU7F.ZGLD8tK1nvm24YGXN1cubPNdi9IwVpol5eWz3','-1','8','1406958455','rollingrocker92@gmail.com','1408723603','0','1','0','1','1','1','0000-00-00','','','','include/images/avatars/4.png','','','','','','1408723603','a:0:{}');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('8','andwan0','$5$rounds=3605$3kAY9LRqkqD0Yhr0$PKIpOuah0rwgzvjnyi5fokCfz02bWJoDevrl.8E4sd2','-1','1','1415201576','andwan0@gmail.com','1415201760','0','1','0','1','1','0','0000-00-00','','','','','','','','',NULL,'1415201731','a:6:{i:8;a:3:{i:8;s:1:\"0\";i:13;s:1:\"0\";i:25;s:1:\"0\";}i:3;a:2:{i:9;s:1:\"0\";i:10;s:1:\"0\";}i:6;a:3:{i:6;s:1:\"0\";i:11;s:1:\"0\";i:12;s:1:\"0\";}i:13;a:2:{i:14;s:1:\"0\";i:38;s:1:\"0\";}i:7;a:1:{i:36;s:1:\"0\";}i:4;a:1:{i:37;s:1:\"0\";}}');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('9','kingmaz','$5$rounds=8396$cQ31GSYP6kBUWlWn$hB//aPnUeYJOIkbknqcwJWbScllOHFOBgsBOTOEmeG.','-1','0','1417201171','chostarfox78@gmail.com','1417201171','0','1','0','1','1','0','0000-00-00','','','','','','','','',NULL,'0','');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('11','gengm125','$5$rounds=3428$49DuJkdmNh16p1xc$z8cx2IKX2alYIfyma3Dt0ukVnqVDsOj9CvE.DBKIkK3','0','0','1420272955','mibaoer125@gmail.com','1420424421','0','1','0','0','1','0','0000-00-00','','','','','','','','','','1420424420','a:6:{i:8;a:3:{i:8;s:1:\"0\";i:13;s:1:\"0\";i:25;s:1:\"0\";}i:3;a:2:{i:9;s:1:\"0\";i:10;s:1:\"0\";}i:6;a:4:{i:6;s:1:\"0\";i:11;s:1:\"0\";i:12;s:1:\"0\";i:39;s:1:\"0\";}i:13;a:2:{i:14;s:1:\"0\";i:38;s:1:\"0\";}i:7;a:1:{i:36;s:1:\"0\";}i:4;a:2:{i:37;s:1:\"0\";i:41;s:1:\"0\";}}');
INSERT INTO `ic1_user` (`id`,`name`,`pass`,`recht`,`posts`,`regist`,`email`,`llogin`,`spezrank`,`opt_pm`,`opt_pm_popup`,`opt_mail`,`status`,`geschlecht`,`gebdatum`,`wohnort`,`homepage`,`staat`,`avatar`,`icq`,`msn`,`yahoo`,`aim`,`sig`,`ilchbb_lastquery`,`ilchbb_newtopics`) VALUES ('12','Ojnaran','$5$rounds=7480$SN1xPST7kYb3WqtH$uslFafxdzbQagNUl55XFLz8RfbZaoOJzep/Vors8Vv0','-1','0','1427330478','Jonathan_Naranjo89@hotmail.com','1427330478','0','1','0','1','1','0','0000-00-00','','','','','','','','',NULL,'0','');

The government pretend,
they your friend. And then when you steal some shit,they put you in jail

0 Mitglieder finden den Beitrag gut.

zitieren

Sa. 28.03.2015 12:06 Uhr #51

Siggi Hall Of Fame

Registriert seit
08.02.2007

Beiträge
6.558

Beitragswertungen

Indem du die Anzahl der posts auf 0 machst?

Wie poste ich falsch?
1 Mitglieder finden den Beitrag gut.
- zitieren
Sa. 28.03.2015 12:16 Uhr #52

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen

Ach ja stimmt dumm von mir.
Aber wie entferne ich :

`ilchbb_lastquery` int(11) NOT NULL,
`ilchbb_newtopics` text NOT NULL,

aus der structur lassen die sich ganz einfach rausnehmen, aber die entsprechenden Einträge dazu kann ich nicht finden. Irgendwie sehen die Strukturen der Einträge unterschiedlich.

z.B
allery/img_37.gif[/img]\r\n','1427532229','a:0:{}');

0\";i:38;s:1:\"0\";}i:7;a:1:{i:36;s:1:\"0\";}i:4;a:1:{i:37;s:1:\"0\";}}');

Zuletzt modifiziert von HATEFRONT am 28.03.2015 - 12:17:17

The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
Sa. 28.03.2015 14:13 Uhr #53

Siggi Hall Of Fame

Registriert seit
08.02.2007

Beiträge
6.558

Beitragswertungen

ALTER TABLE `prefix_user` DROP COLUMN `ilchbb_lastquery`
ALTER TABLE `prefix_user` DROP COLUMN `ilchbb_newtopics`

oder einfach per Hand die Zeilen in der Tabelle löschen

Wie poste ich falsch?
0 Mitglieder finden den Beitrag gut.
- zitieren
Sa. 28.03.2015 14:47 Uhr #54

MOODFOR Mitglied

Registriert seit
25.06.2014

Beiträge
177

Beitragswertungen

Jetzt einfach das prefix hinzufügen und bei SQL ausführen ?

The government pretend,
they your friend. And then when you steal some shit,they put you in jail
0 Mitglieder finden den Beitrag gut.
- zitieren
Sa. 28.03.2015 14:56 Uhr #55

Siggi Hall Of Fame

Registriert seit
08.02.2007

Beiträge
6.558

Beitragswertungen

jep

Wie poste ich falsch?
1 Mitglieder finden den Beitrag gut.
- zitieren

Sa. 28.03.2015 15:03 Uhr #56

MOODFOR Mitglied

Danke, die Seite läuft jetzt nun lächeln

Bleibt nur noch diese Fehlermeldung unter Kompatibilität sauer

Warning: Cannot modify header information heißt ja das irgendwo ein Leerzeichen zu viel ist, doch was bedeutet der Rest ?

Warning: is_dir(): open_basedir restriction in effect. File(..) is not within the allowed path(s): (/customers/5/b/d/bloodline.eu/httpd.www:/customers/5/b/d/bloodline.eu/httpd.private:/customers/5/b/d/bloodline.eu/tmp:/customers/bloodline.eu/bloodline.eu:/var/www/diagnostics:/usr/share/php) in /customers/5/b/d/bloodline.eu/httpd.www/include/admin/compatibility.php on line 19 Warning: Cannot modify header information - headers already sent by (output started at /customers/5/b/d/bloodline.eu/httpd.www/include/admin/compatibility.php:19) in /customers/5/b/d/bloodline.eu/httpd.www/include/includes/class/design.php on line 23

Zuletzt modifiziert von HATEFRONT am 29.03.2015 - 21:10:04

The government pretend,
they your friend. And then when you steal some shit,they put you in jail

0 Mitglieder finden den Beitrag gut.

zitieren

Geschlossen		Seite 2 von 2 ‹12›

	Zurück zu HTML, PHP, SQL,...

Beitrag zur Merkliste hinzufügen

ilch Forum » Allgemein » HTML, PHP, SQL,... » SQL Fehlermeldung :-/