Shout Box v2.4 ** SOLVED **

Lieutenant Joined: Mar 10, 2005 Posts: 166

PHP-Nuke v7.5 (patched)

- manaully installed this block
- manually created sql tables
- manually inserted data into tables
- block works fine on the page

- can NOT use admin panel link; returns with 'Access Denied' error
- manual settings via sql db are only way to setup block currently
- enabled display errors - no further errors were presented

Anyone have any suggestions as to why this thing seems so buggy? Is there a more recent version somewhere?

Note: creators website is useless

Thx
HSM

Lieutenant Joined: Mar 10, 2005 Posts: 166

I figured it out myself and here is what I did:

I removed this code:

Code:

$result = sql_query("select radminfaq, radminsuper from ".$prefix."_authors where aid='$aid'", $dbi);
list($radminfaq, $radminsuper) = sql_fetch_row($result, $dbi);
if (($radminfaq==1) OR ($radminsuper==1)) {

And replaced it with this code:

Code:

global $prefix, $dbi;
$aid = substr("$aid", 0,25);
$row = $db->sql_fetchrow($db->sql_query("SELECT radminsuper FROM " . $prefix . "_authors WHERE aid='$aid'"));
if ($row['radminsuper'] == 1) {

Now the admin feature works for the script.

Nuke Soldier Joined: Jun 16, 2006 Posts: 12

can you post a working shoutbox files link for phpnuke 8 please ?

Lieutenant Joined: Mar 10, 2005 Posts: 166

Yeah sure, here is the original un-edited code:

SHOUTBLOCK 2.4

Nuke Soldier Joined: Jun 16, 2006 Posts: 12

AFTER UPLOADING the files and setting up the shoutbox and adding shoutbox block i'm getting syntax error in the beggeinning of the block
i have no idea how to fix or how to creat a new db for it
any idea HSM

Lieutenant Joined: Mar 10, 2005 Posts: 166

Show me the exact error plz??

Did you do this below in the quote?? As per the README file included in the zip.

Quote:

Quick and Dirty Install:

Step One: Place files on server
Step Two: Log into phpnuke as an administrator
Step Three: under administration/Qshoutblock select "install database"

OR

visit your site at: http://www.yourpathto.php/nuke/quiecom-shoutblock.php

Nuke Soldier Joined: Jun 16, 2006 Posts: 12

when i enter qshout admin i can't find install database
i found "reinstall database"
i press it but nothing is happenning

when i enter qshout mudule i get

" Error in query: select * from nuke_quiecom_shoutblock order by id desc. Table '****_****.nuke_quiecom_shoutblock' doesn't exist"

after i create the table what is the valus i have to enter to make a manual databse ?

Lieutenant Joined: Mar 10, 2005 Posts: 166

I was going to post the code for you here... but this site keeps telling me I don't have permissions to access the /modules.php file... which I was not doing; I was posting code & giving it code comments.

So, here.. copy & paste the code from one of my sites:

.DK SITE
.CA SITE

Nuke Soldier Joined: Jun 16, 2006 Posts: 12

when i'm importing the sql file throw phpmyadmin i'm getting this error:

Lieutenant Joined: Mar 10, 2005 Posts: 166

Okay I'm not sure what to say here, it works perfect for me (and I just tried it again on our test site - no errors).

Try changing this line:

[ (id int(9) DEFAULT '0' NOT NULL auto_increment, ]

to this:

[ `id` int(9) NOT NULL auto_increment, ]

Note: leave out the square brackets, its the only way I could post the friggin code in the message.

Nuke Soldier Joined: Jun 16, 2006 Posts: 12

do you have any replacment idea in how to import the sql without phpmyadmin?

Lieutenant Joined: Mar 10, 2005 Posts: 166

Nope, sorry... was kinda hoping that one of the other guru guys would get into this chat and give a helping hand. I have always used phpmyadmin or you could just give me admin access to your db and I'll see if I can do it for you.

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

Hi there, I installed the shout box block. followed all instructions here and it works , sort of, Rolling Eyes

. I have 2 problems

1. the emoticons don't show in the shoutbox block but when i type them in they show in msg

2. when i send msg I lose centre block and the shoutblock block and get small message where shoutblock should be and it just says

uid:

when I click on <Home> the page comes back with the new message, but if I click on refresh page it doesn't come back

Nuke Cadet Joined: Jul 26, 2007 Posts: 9

Hi HSM I checked out your website (looks awesome) to see how Shoutbox works and noticed you have changed to SPchat. Have also now installed the SPchat that you use. Had a problem getting on to the forums there for more help, they seem to have a database problem. Is it possible to create the spchat in a sidebox (block) that would be ideal for me.

Nuke Cadet Joined: Jul 31, 2008 Posts: 2

Ok, i have tried to use the "install" button like 100 times and nothing, does not do anything, I hvae finaly got past the "access denied" in the admin panel so i tried using the "reinstall" button, but same thing. I have read your manually installing the table but i am not that talented Razz

So if someone could simplify this for me that would be great,

or

if someone could just make it into a sql class. so i can just run a query on it

tgcnet.com
phpnuke 8.0

Thank you for your time,
Jta-web