), but you can test it here (use the news admin). You can find the modified news module here, but you need to manually add a db field in your prefix_stories table (int(10),NOT NULL, default value 0) for it to work properly.
Re: News hack: set expiry dateI think your up for some bugfixig :P
MySQL Query Error: INSERT INTO adnd_stories (storyid, uid, title, created, published, expired, hostname, nohtml, nosmiley, hometext, bodytext, counter, topicid, ihome, notifypub, type, topicdisplay, topicalign) VALUES (0,6,'And this one',1029546052,0,,'193.252.190.xxx',0,0,'When will it dissapear :P -Half','',0,1,0,0,'user',1,'')
Error number:1064
Error message: You have an error in your SQL syntax near ''193.252.190.xxx',0,0,'When will it dissapear :P -Half','',0,1,0,0,'user',1,'' at line 1
Re: News hack: set expiry dateFixed it! 
(you'll have to excuse me, this is my first attempt at hacking a XOOPS module, and I am not a coder...).
Now: when user submits a news post, it is automatically set to expire somewhere in 2038. Admin who approves the post can set a different expiry date.
Admins posting or editing posts can set expiry dates as well. If an admin posts a new article, and DOESN'T set an expiry date, it automaticaaly is set to expire in 31 days.
Also added a new admin table for expired posts, so admin can (re)set the expiry date.
Don't want to brag, but I'm quite proud of myself for having achieved this I also have found a new level of respect for the XOOPS Devs, they have done a truly excellent job at coding Xoops. The logic in the XOOPS code is VERY strong, very clean and straightforward coding and very very modular. I am humbled
I have updated the link to the file, you can find it here, and test drive it here.
Hope this will be included in the next release 
Herko
p.s. you'd might also notice that the subsite uses the mainsite's user db. Register and you have access to both sites. Login is still required though.
Re: News hack: set expiry dateHows the bug fixing going Herco.
Re: News hack: set expiry dateNeon, you still get bugs? Or didn't you read my post above? I think it works fine now. I don't get any errors...
Oh, Herko is with a k, not a c, btw
Herko
Re: News hack: set expiry date
hehe
I had been working on the puta all day and it was late at night when I posted that.. so sorry mr Herko (with a K).
Re: News hack: set expiry dateI have not tested it yet, but if it works, it will be for sure the best hack available for Xoops. I was really waiting for this one!
Congratulation Herko.
JCMoriaud
| Stats | |
| Goal: | AU$15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | AU$0.00 |
| Net Balance: | AU$0.00 |
| Left to go: | AU$15.00 |
 |
|
