I am sorry if this is not the right place to put this, please move to proper area please if it is not.
I have been looking for a "quote" module/block. The closest i have found so far is "GeekQuote" but i have not been able to get it to work.
I have seen some simple ones, but I liked this for the purpose of using the sql database.
Would someone be able to direct me to something that has already been done? or would it be a great project for someone? "hint, hint"
that is a easy one to work with, but I guess I am looking for the sql version and admin setup. It seems to be faster and easier to have alot of input for the quotes.
The problem is that I have only found one that works with sql and I cannot get it to work
I went though all the code that I could, and in modules\quotes\admin\index.php was this
Code:
<?php
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result = sql_query($querystr, $dbi) or die ("invalied query");
function YesDelQuote($qid) {
global $prefix, $db, $admin_file;
$qid = intval($qid);
$quotesql = "delete from ".$prefix."_quotes where qid='$qid'";
$result = $db->sql_query($quotesql);
if ($result)
{
Header("Location: ".$admin_file.".php?op=QuotesList");
}
else
{
include ("header.php");
GraphicAdmin();
OpenTable();
echo "<center><font class=\"title\"><b>"._QUOTESADMIN."</b></font></center>";
CloseTable();
echo "<br>";
OpenTable();
echo "<center><font class=\"content\"><b>Error: Not deleted.</b></font><br><br>";
echo "$quotesql";
echo "</center>";
CloseTable();
include("footer.php");
}
}
function SaveQuote($quote, $author) {
global $prefix, $db, $admin_file;
case "SaveQuote":
SaveQuote($quote, $author);
break;
case "SaveEditQuote":
SaveEditQuote($qid, $quote, $author);
break;
case "QuotesList":
QuotesList();
break;
}
} else {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center><b>"._ERROR."</b><br><br>You do not have administration permission for module \"$module_name\"</center>";
CloseTable();
include("footer.php");
}
?>
as you see up towards the top is the reference you asked about. But this is the only file that has that info, it has not been found in the rest of the code.
for more info:
I have it installed, and the block now shows a random quote, But in the admin area under blocks, when i click on the new block box i get an error, it actually comes up as another page.
Now I can go under modules and click on quote and it shows all the quotes on one page, but there is no editing anything.
here is a link to where I downloaded this, I have even sent the author an email and have not had a response for some time now.
thank you for any help
Only registered users can see links on this board! Get registered or login to the forums!
Only registered users can see links on this board! Get registered or login to the forums!
and for testing purposes so far, I went in the admin.php file in the modules folder and removed the three references to $dbi, and went and reloaded the site and there was no difference
this
Code:
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result = sql_query($querystr, $dbi) or die ("invalied query");
$createsql = "CREATE TABLE IF NOT EXISTS ".$prefix."_quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
author varchar(150) NOT NULL default '',
PRIMARY KEY (qid)
) ENGINE=MyISAM";
$sql_query($createsql, $dbi);
if ($radminsuper==1)
to this
Code:
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result = sql_query($querystr) or die ("invalied query");
list($radminsuper) = sql_fetch_row($result);
$createsql = "CREATE TABLE IF NOT EXISTS ".$prefix."_quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
author varchar(150) NOT NULL default '',
PRIMARY KEY (qid)
) ENGINE=MyISAM";
$sql_query($createsql);
if ($radminsuper==1)if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
Now I guess the thing that is getting me is trying to make the compare with this type of line...it is there two times so i dont know if there is an issue.
this is from the original
Code:
$sql_query($createsql, $dbi);
now in the faq it shows the old looks like this
Code:
sql_query($sql, $dbi)
and the new line like this
Code:
$db->sql_query($sql)
now the original uses the string $createsql....so should that whole line be replaced? or am i making it harder then what it should be?
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result =$db->sql_query($querystr) or die ("invalied query");
list($radminsuper) = sql_fetchrow($result);
$createsql = "CREATE TABLE IF NOT EXISTS ".$prefix."_quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
author varchar(150) NOT NULL default '',
PRIMARY KEY (qid)
) ENGINE=MyISAM";
$sql_query($createsql);
if ($radminsuper==1)if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result = $db->sql_query($querystr) or die ("invalied query");
list($radminsuper) = sql_fetch_row($result);
$createsql = "CREATE TABLE IF NOT EXISTS ".$prefix."_quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
author varchar(150) NOT NULL default '',
PRIMARY KEY (qid)
) ENGINE=MyISAM";
$sql_query($createsql);
if ($radminsuper==1)if(1defined('ADMIN_FILE')0{
die("Access Denied");
{
again, it is working, but the admin features are not. I keep getting the 500 error. So far all of the changes that have been done, have shown no difference, I may need to reload the entire site to make sure.
while you are looking at this, if you dont want to dl and look at all of it, here is the block file code
Code:
<?php
if (eregi("block-Quotes.php", $_SERVER['PHP_SELF']))
{
Header("Location: index.php");
die();
}
global $prefix, $db, $content;
$content = "";
mt_srand((double)microtime()*1000000);
$quotesql = "SELECT COUNT(qid) FROM ".$prefix."_quotes";
$result = $db->sql_query($quotesql);
I had posted the full .php file earlier in this thread, I had just shown the area that was in question to and had the &dbi info......so please go up this thread and you should see that one..
To help clarify this again....this is what I did so you know the steps I have done.
1. I copied the files over to ravennuke. I loaded the admin and added it to work in the modules. I checked and it was working but nothing was shown. I then loaded phpmyadmin and made sure the sql tables were there and then added an extra sql data that had alot of quotes already.
2. I then went back to home page and loaded the quotes that are now shown under modules and clicked them and another page loaded that had all the quotes that were just added.
3. at this time i went back to admin and added the block, for the lower right side. When i load the home page there is as box on the lower right side showing random quotes.
4. I go back to admin and there is a new block that says Qoutes. I am figureing that this is where I can administrator everything, so when i click on that i get the "http 500" error.
5. So far no matter what the changes that have been made, it still continues to give the error when i goto admin and click on quotes.
so thinking that it is also something to do with the block.php or to links.php I wanted to go ahead and add those in previous posts just to make sure.
Mabye there is something that is wrong there, that is causing the admin page not to load. I have been trying to compare code and check for any syntax errors, but have had no luck.
I know that you are trying to help me with info that I try to give, I am still being confused, i did put a link to where you could dl and maby it will do the same thing to you and with your expertize could troubleshoot it faster then anything.
this has been a learning experience, and again ty for all the help
Joined: Aug 27, 2002 Posts: 16987 Location: Kansas
Posted:
Tue Jan 13, 2009 1:35 am
Please be sure to recognize that the 500 error is a syntax or directive error in your .htaccess or Apache configuration file, regardless of the php code issues.
Palbin: if your are talking about modules/quotes/admin then there is no .htaccess file. If you are talking about ravennuke's admin folder then there is a .htaccess file, and I did back it up and delete the one that was there.
No change
I even reloaded the server and reloaded the sql server and no difference.
Joined: Feb 06, 2006 Posts: 3038 Location: United Kingdom
Posted:
Tue Jan 13, 2009 2:16 pm
I started looking at this last night, but didn't get chance to finish it. It is working on my local install of RN 2.3
If I've missed anything Palbin please let me know.
The code below should replace all of the code in \modules\Quotes\admin\index.php
Code:
<?php
if (!defined('ADMIN_FILE')) {
die ("Access Denied");
}
define('NO_EDITOR', 1);
global $prefix, $db, $admin_file;
$querystr = "SELECT radminsuper, admlanguage FROM " .$prefix."_authors where aid='$aid'";
$result = $db->sql_query($querystr) or die ("invalied query");
list($radminsuper) = $db->sql_fetchrow($result);
$createsql = "CREATE TABLE IF NOT EXISTS ".$prefix."_quotes (
qid int(10) unsigned NOT NULL auto_increment,
quote text,
author varchar(150) NOT NULL default '',
PRIMARY KEY (qid)
) ENGINE=MyISAM";
$db->sql_query($createsql);
if ($radminsuper==1)
{
/*********************************************************/
/* Quote Functions */
/*********************************************************/
function YesDelQuote($qid) {
global $prefix, $db, $admin_file;
$qid = intval($qid);
$quotesql = "delete from ".$prefix."_quotes where qid='$qid'";
$result = $db->sql_query($quotesql);
case "SaveQuote":
SaveQuote($quote, $author);
break;
case "SaveEditQuote":
SaveEditQuote($qid, $quote, $author);
break;
case "QuotesList":
QuotesList();
break;
}
} else {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center><b>"._ERROR."</b><br><br>You do not have administration permission for module \"$module_name\"</center>";
CloseTable();
include("footer.php");
}
View next topic View previous topic
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
![[Valid RSS]](http://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
