New articles system/database/thing

It's been about 5 days, could anyone help me out? It would be greatly appreciated!

Another 3 days, could anyone please take a look at my thread/request? I would really appreciate it.

Also, I have asked on: http://www.phpfusion-mods.net/forum/viewthread.php?forum_id=19&thread_id=3167

Pico

The reason no one has answered is due to the complexity of what you're asking for. Please be patient.

I see. I didn't mean to make it sound complex, I just need another "articles system" copy that works on a separate database, thus having two article systems on php-fusion.

It's rather high priority, would really appreciate it if someone could help me out. I will be patient.

Pico

You can try to change DB prefix for articles, or something.

Just rename everything that says articles to whatever you want then same for aticles cats. Should be quite easy to do that then all you need to do is grab the articles SQL from the core setup.php and make a quick install.php

Go for it Polarfoxy you can do this in like 30 mins. lol :P

Ahh see, after 10 minutes (roughly) of downloading any articles related files, I successfully renamed most of it to "roleplay". I downloaded the SQL database for the articles, used a text editor to edit some values, and re imported it. I then edited the files to call to the new database.

Unfortunately, I made many too many errors, and couldn't get it done right. I just don't have the php knowledge to make those edits, even through I know what should be done (at least I think that's what would be needed to be done).

Also, the submit.php file is a killer, I could not copy the article submission code from there and duplicate it, it looks like it runs through the entire file!

Any more advice would be greatly appreciated. If its as much work as I think, perhaps I could try and compensate one of you somehow.

Pico

@AKC_Pico: Im on this. I've earliere made this - but in v7.00.XX

Have patience pls. ;)

It's quiet many files that needs to be modded - but as said: Im on it.

Amazing Smokeman! Thank you! Will be checking back frequently!

My users will be VERY happy, have over 2500 registered users ready to use it!

Also you need to edit "article-categories"

Is it ready yet? lol :P

Update: I've finished the modding of all the required files. I'll test it on a fresh new installed v7.01.03-site later tonight.


Edit: Testing finish..

DESCRIPTION:
-------------------
This is a true copy of the in-built article-system for PHPFusion v7.01.03 ++


INSTALLATION:
--------------------
1. VERY IMPORTANT:
- first take a full backup of all your files/folders from the FTP and then take a database-backup too !!

2. Copy the following code into the theme.php:

- right above the following line:


3. Download, unzip & upload the attached files from the map named "files" to the root of your server.

4. Log on to your site and run the following piece of code via a new empty Custom Page
- (press Preview Page - NOT Save Page - Press ONLY ONCE !!) :


- this will create the new tables "articles2" & "article_cats2" in the database.

5. Last you create a new Site Link to the new articles2.php


If there may be one/more bug(s) then just write the error-message(s) here. I've tested this on a new fresh installed v7.01.03-site like mentioned, but I haven't any other content on that site besides articles. It's just for testing - but you can see a live demo of this MOD here:

- the original Articles: http://dev.dvdside.dk/articles.php
- and here is the new Articles2: http://dev.dvdside.dk/articles2.php

BTW: There's also the same instruction/readme-file incl. in the package.


Enjoy!

Yes it is.
- look up in the thread above.

It's PERFECT! Thankyou SO MUCH smokeman!

One last thing, and I HATE to ask this, but I really need this panel to grab the articles2 data and not the articles1 data, it doesnt seem like too many edits, especially if you know the database settings, mind taking a fast look at it?


[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: articles_panel.php
| Author: Fangree Productions
| Developers: Fangree_Craig
| Site: http://www.fangree.co.uk
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION") { die("Access Denied"; }

if (file_exists(INFUSIONS."articles/locale/".$settings['locale'].".php") {
include INFUSIONS."articles_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."articles_panel/locale/English.php";
}

opentable($locale['art001']);



echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";

echo "<td width='70%' class='tbl2' style='text-align:left;white-space:nowrap'> <a href='http://forums.airbender.net/articles.php'>View FanFiction</a> :: <a href='http://forums.airbender.net/submit.php?stype=a'>Submit FanFiction</a>
</td>\n";
echo "<td width='30%' class='tbl2' style='text-align:right;white-space:nowrap'><form name='searchform' method='get' action='".BASEDIR."search.php?stype=articles'><input type='hidden' name='stype' value='articles' /><input type='text' name='stext' class='textbox' value='Search FanFiction...' onFocus='this.value=\"\"' style='width:130px' />&nbsp;<input type='submit' name='search' value='".$locale['art010']."' class='button' /></form></td></table>\n";


echo "<br>";


$result = dbquery(
"SELECT tu.user_id, tu.user_name, ta.article_datestamp, ta.article_id, ta.article_name, ta.article_reads, ta.article_subject, tac.article_cat_name, tac.article_cat_id, tac.article_cat_access FROM ".DB_ARTICLES." ta
INNER JOIN ".DB_ARTICLE_CATS." tac ON ta.article_cat=tac.article_cat_id INNER JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access')." AND article_draft='0' ORDER BY article_id DESC LIMIT 0,20"
);

if (dbrows($result)) {
$i = 0;
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
echo "<td class='tbl2' width='3%'>&nbsp;</td>\n";
echo "<td width='40%' class='tbl2'><strong>".$locale['art002']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art004']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art007']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art003']."</strong></td>\n";


echo "</tr>\n";
while($data = dbarray($result)) {
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = "&nbsp;".$locale['art005']."";
} else {
$new = "<img src='".INFUSIONS."articles_panel/images/arrow.png' border='0' />";
}

$row_color = ($i % 2 == 0 ? "tbl1" : "tbl2";
echo "<tr>\n<td class='".$row_color."' style='white-space:nowrap' align='center'>";
echo "".$new."</d><td width='40%' class='".$row_color."'>";
$itemsubject = trimlink($data['article_subject'], 90);

echo "<strong><a href='".BASEDIR."articles.php?article_id=".$data['article_id']."' title='$itemsubject' class='side'>$itemsubject</a></strong><br />\n";
echo "<span style='font-size:10px;'><a href='articles.php?cat_id=".$data['article_cat_id']."' title='".$data['article_cat_name']."' >".$data['article_cat_name']."</a></span>\n";
echo "</td>\n";
echo "<td width='3%' class='".$row_color."' style='text-align:center;white-space:nowrap'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a><br></td>\n";
echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".showdate("forumdate", $data['article_datestamp'])."</td>";
echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['article_reads']."</td>\n";








echo "</tr>\n";
$i++;
}

echo "</table>\n";

}

else {
echo "<div style='text-align:left'>".$locale['art007']."</div>\n";
}
echo"<br>\n";

echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";

echo "<td width='70%' class='tbl2' style='text-align:left;white-space:nowrap'> ".$locale['art008'].dbcount("(article_id)", DB_ARTICLES)." :: ".$locale['art009'].dbcount("(article_cat_id)", DB_ARTICLE_CATS)."</td>\n";
echo "<td width='30%' class='tbl2' style='text-align:right;white-space:nowrap'><form name='searchform' method='get' action='".BASEDIR."search.php?stype=articles'><input type='hidden' name='stype' value='articles' /><input type='text' name='stext' class='textbox' value='Search FanFiction...' onFocus='this.value=\"\"' style='width:130px' />&nbsp;<input type='submit' name='search' value='".$locale['art010']."' class='button' /></form></td></table>\n";

closetable();
?>[/syntaxhighlighter]

Before we go any further here: Pls bring the copyight in the footer back again - I know there's written:

http://forums.airbender.net
- but that footer-text/copyright ain't right.

If you don't know how the exactly footer-text should look like then take a look here on www.phpfusion.co.uk in the footer.

I bought a php-fusion removal code years ago (I think 4-5 years ago when they just started with v6), I don't remember how long that stays valid. I was keeping the link there for courtesy of nick jones and php-fusion.

If you still want me too, I will gladly edit it, I just hate to make it two lines for nothing.

I will consider it invalid, and place it in honor of Nick Jones. I will wear the copyright proudly. It has been done.

Well, I can't really much test it for myself - without that infusion you're using = Articles Panel. I can see it's not the standard panel.

But try with this code and see what it says:
[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| <a href="http://www.php-fusion.co.uk/" target="_blank" title="autolink">http://www.php-fu...</a>
+--------------------------------------------------------+
| Filename: articles_panel.php
| Author: Fangree Productions
| Developers: Fangree_Craig
| Site: <a href="http://www.fangree.co.uk" target="_blank" title="autolink">http://www.fangre...</a>
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at <a href="http://www.gnu.org/licenses/agpl.html." target="_blank" title="autolink">www.gnu.org/licen...</a> Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }

if (file_exists(INFUSIONS."articles/locale/".$settings['locale'].".php")) {
include INFUSIONS."articles_panel/locale/".$settings['locale'].".php";
} else {
include INFUSIONS."articles_panel/locale/English.php";
}

opentable($locale['art001']);
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
echo "<td width='70%' class='tbl2' style='text-align:left;white-space:nowrap'> <a href='".BASEDIR."articles2.php'>View FanFiction</a> :: <a href='".BASEDIR."submit.php?stype=a'>Submit FanFiction</a></td>\n";
echo "<td width='30%' class='tbl2' style='text-align:right;white-space:nowrap'><form name='searchform' method='get' action='".BASEDIR."search.php?stype=articles'><input type='hidden' name='stype' value='articles' /><input type='text' name='stext' class='textbox' value='Search FanFiction...' onFocus='this.value=\"\"' style='width:130px' />&nbsp;<input type='submit' name='search' value='".$locale['art010']."' class='button' /></form></td>\n";
echo "</tr>\n</table>\n";

$result = dbquery(
"SELECT tu.user_id, tu.user_name, ta.article_datestamp, ta.article_id, ta.article_name, ta.article_reads, ta.article_subject, tac.article_cat_name, tac.article_cat_id, tac.article_cat_access FROM ".DB_ARTICLES2." ta
INNER JOIN ".DB_ARTICLE_CATS2." tac ON ta.article_cat=tac.article_cat_id INNER JOIN ".DB_USERS." tu ON ta.article_name=tu.user_id
".(iSUPERADMIN ? "" : "WHERE ".groupaccess('article_cat_access'))." AND article_draft='0' ORDER BY article_id DESC LIMIT 0,20"
);

if (dbrows($result)) {
$i = 0;
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
echo "<td class='tbl2' width='3%'>&nbsp;</td>\n";
echo "<td width='40%' class='tbl2'><strong>".$locale['art002']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art004']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art007']."</strong></td>\n";
echo "<td width='5%' class='tbl2' style='text-align:center;white-space:nowrap'><strong>".$locale['art003']."</strong></td>\n";
echo "</tr>\n";
while($data = dbarray($result)) {
if ($data['article_datestamp'] + 604800 > time() + ($settings['timeoffset'] * 3600)) {
$new = "&nbsp;".$locale['art005']."";
} else {
$new = "<img src='".INFUSIONS."articles_panel/images/arrow.png' border='0' alt='' />";
}

$row_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
echo "<tr>\n<td class='".$row_color."' style='white-space:nowrap' align='center'>";
echo "".$new."</d><td width='40%' class='".$row_color."'>";
$itemsubject = trimlink($data['article_subject'], 90);

echo "<strong><a href='".BASEDIR."articles2.php?article_id=".$data['article_id']."' title='$itemsubject' class='side'>$itemsubject</a></strong>\n";
echo "<span style='font-size:10px;'><a href='articles2.php?cat_id=".$data['article_cat_id']."' title='".$data['article_cat_name']."' >".$data['article_cat_name']."</a></span>\n";
echo "</td>\n";
echo "<td width='3%' class='".$row_color."' style='text-align:center;white-space:nowrap'><a href='".BASEDIR."profile.php?lookup=".$data['user_id']."'>".$data['user_name']."</a></td>\n";
echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".showdate("forumdate", $data['article_datestamp'])."</td>";
echo "<td width='1%' class='".$row_color."' style='text-align:center;white-space:nowrap'>".$data['article_reads']."</td>\n";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo "<div style='text-align:left'>".$locale['art007']."</div>\n";
}
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
echo "<td width='70%' class='tbl2' style='text-align:left;white-space:nowrap'> ".$locale['art008'].dbcount("(article_id)", DB_ARTICLES2)." :: ".$locale['art009'].dbcount("(article_cat_id)", DB_ARTICLE_CATS2)."</td>\n";
echo "<td width='30%' class='tbl2' style='text-align:right;white-space:nowrap'><form name='searchform' method='get' action='".BASEDIR."search.php?stype=articles'><input type='hidden' name='stype' value='articles' /><input type='text' name='stext' class='textbox' value='Search FanFiction...' onFocus='this.value=\"\"' style='width:130px' />&nbsp;<input type='submit' name='search' value='".$locale['art010']."' class='button' /></form></td>\n";
echo "</tr>\n</table>\n";

closetable();
?>[/syntaxhighlighter]
- besides that we shall have a look into the /submit.php file too - but that must be tomorrow. Im on my way to bed now.

I can't really test it as the panel will not show if there's no submissions! And now I realized that I can't submit anything to it!

I've looked at the submit.php before when I considered doing it myself, it looks crazy. Thank you for all your help so far!

Pico