Unrealx Forum Errors!

[wapped]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/core.php on line 578

that is this line
while ($narys=mysql_fetch_array($nariai))
it is in this part
/////////////////////////////////Get the memberlist//////////////////////////
function membersget($nick,$pass,$whattoget,$page)
{
// if ($page==1) $pagest=0; else $pagest=$page*$page+1;
$page=$page-1;
if (!$page==0) $pagest=$page*5; else $pagest=0;
if ($whattoget=="id") $nariai=mysql_query("SELECT name,pluses FROM users ORDER BY id DESC LIMIT ".$pagest.", 5");
if ($whattoget=="name") $nariai=mysql_query("SELECT name,pluses FROM users ORDER BY name LIMIT ".$pagest.", 5");
while ($narys=mysql_fetch_array($nariai))
{
$postu=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM posts WHERE postedby='".$narys[0]."'"));
echo "<a href=\"index.php?action=viewuser&amp;nick=$nick&am p;pass=$pass&amp;who=$narys[0]\">Name: $narys[0], Posts: $postu[0], Pluses: $narys[1]</a>
";
};
};
/////////////////////////////////////////////////////////////////////////////
and only one more error it is with private messages,when go on
index.php?action=viewuser&nick=SOMENICK&pass=SOMEP ASS&who=SOMENICK
and click on send PM goes to this link index.php?action=sendpm&nick=bb&pass=bb&who=
without SOMENICK then doesn want to send pm!,
it is like this on every version tried,it must be something with mysql or what

please helpppp!!!!!!!

[naveen-PHP LEARNER]

Mate its not the unrealX forum error.
If you have connected to ur db correctly...u wont see dat.
if u think u have and its still not working...
Maybe your PHP verison is less than 4.2.

GoodLuck

[wapped]

yes it is ,everybody told me,it is happening all version,ain&#39;t full....i will se the php version,thanx anyway!

[abhisar]

See if u installed the tables correctly.

/////////////////////////////////Get the memberlist//////////////////////////
function membersget($nick,$pass,$whattoget,$page)
{
// if ($page==1) $pagest=0; else $pagest=$page*$page+1;
$page=$page-1;
if (!$page==0) $pagest=$page*5; else $pagest=0;
if ($whattoget=="id") $nariai=mysql_query("SELECT name,pluses FROM users ORDER BY id DESC LIMIT ".$pagest.", 5");
if ($whattoget=="name") $nariai=mysql_query("SELECT name,pluses FROM users ORDER BY name LIMIT ".$pagest.", 5");
while ($narys=mysql_fetch_array($nariai))
{
$postu=mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM posts WHERE postedby=&#39;".$narys[0]."&#39;"));
echo "<a href=\"index.php?action=viewuser&amp;nick=$nick&am p;pass=$pass&amp;who=$narys[0]\">Name: $narys[0], Posts: $postu[0], Pluses: $narys[1]</a>
";
};
};
/////////////////////////////////////////////////////////////////////////////

[wapped]

bro can somebody leave here the sql file for all versions!
i got one of this irisblaze.sql
-- phpMyAdmin SQL Dump
-- version 2.6.0-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 13, 2004 at 06:56 PM
-- Server version: 4.1.7
-- PHP Version: 4.3.9
--
-- Database: `wapforum`
--

-- --------------------------------------------------------

--
-- Table structure for table `administrators`
--

CREATE TABLE `administrators` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `counter`
--

CREATE TABLE `counter` (
`id` int(5) NOT NULL default &#39;0&#39;,
`visitors` int(99) NOT NULL default &#39;0&#39;
) ;

-- --------------------------------------------------------

--
-- Table structure for table `forums`
--

CREATE TABLE `forums` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default &#39;&#39;,
`perms` int(99) NOT NULL default &#39;0&#39;,
`position` int(99) NOT NULL default &#39;0&#39;,
`adminonl` varchar(10) NOT NULL default &#39;&#39;,
`modonl` varchar(10) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
) ;
-- --------------------------------------------------------

--
-- Table structure for table `log`
--

CREATE TABLE `log` (
`id` int(10) NOT NULL auto_increment,
`date` varchar(99) NOT NULL default &#39;&#39;,
`text` varchar(255) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);
-- --------------------------------------------------------

--
-- Table structure for table `moderators`
--

CREATE TABLE `moderators` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default &#39;&#39;,
`forum` varchar(99) NOT NULL default &#39;0&#39;,
PRIMARY KEY (`id`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `online`
--

CREATE TABLE `online` (
`laikas` int(15) NOT NULL default &#39;0&#39;,
`username` varchar(40) NOT NULL default &#39;&#39;,
PRIMARY KEY (`laikas`),
UNIQUE KEY `username` (`username`)
) ;
-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
`id` int(99) NOT NULL auto_increment,
`name` varchar(99) NOT NULL default &#39;&#39;,
`forum` varchar(99) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
`id` int(99) NOT NULL auto_increment,
`forum` int(99) NOT NULL default &#39;0&#39;,
`postedby` varchar(99) NOT NULL default &#39;&#39;,
`name` varchar(30) NOT NULL default &#39;&#39;,
`text` varchar(200) NOT NULL default &#39;&#39;,
`thread` char(1) NOT NULL default &#39;&#39;,
`position` bigint(99) NOT NULL default &#39;0&#39;,
`perms` int(99) NOT NULL default &#39;0&#39;,
`pinned` varchar(5) NOT NULL default &#39;&#39;,
`closed` varchar(5) NOT NULL default &#39;&#39;,
`date` varchar(255) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`),
FULLTEXT KEY `text_2` (`text`),
KEY `name` (`name`),
KEY `text` (`text`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `private`
--

CREATE TABLE `private` (
`id` int(99) NOT NULL auto_increment,
`unread` varchar(5) NOT NULL default &#39;&#39;,
`sentby` varchar(255) NOT NULL default &#39;&#39;,
`sentto` varchar(255) NOT NULL default &#39;&#39;,
`text` varchar(255) NOT NULL default &#39;&#39;,
`date` varchar(100) NOT NULL default &#39;&#39;,
`timesent` int(50) NOT NULL default &#39;0&#39;,
PRIMARY KEY (`id`)
) ;

-- --------------------------------------------------------

--
-- Table structure for table `smilies`
--

CREATE TABLE `smilies` (
`id` int(10) NOT NULL auto_increment,
`bbcode` varchar(200) NOT NULL default &#39;&#39;,
`changeto` varchar(200) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

-- --------------------------------------------------------

--
-- Table structure for table `avatars`
--

CREATE TABLE `avatars` (
`id` int(10) NOT NULL auto_increment,
`avlink` varchar(200) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

-- --------------------------------------------------------

--
-- Table structure for table `misc`
--

CREATE TABLE `misc` (
`id` int(10) NOT NULL auto_increment,
`desc` varchar(200) NOT NULL default &#39;&#39;,
`text` varchar(250) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`)
);

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(32) NOT NULL default &#39;&#39;,
`pass` varchar(54) NOT NULL default &#39;&#39;,
`postno` int(100) NOT NULL default &#39;0&#39;,
`pluses` int(99) NOT NULL default &#39;0&#39;,
`status` varchar(99) NOT NULL default &#39;&#39;,
`owntext` varchar(100) NOT NULL default &#39;&#39;,
`email` varchar(50) NOT NULL default &#39;&#39;,
`banned` char(2) NOT NULL default &#39;&#39;,
`bannedby` varchar(100) NOT NULL default &#39;&#39;,
`banto` int(40) NOT NULL default &#39;0&#39;,
`tlphone` varchar(99) NOT NULL default &#39;&#39;,
`site` varchar(50) NOT NULL default &#39;&#39;,
`asl` varchar(100) NOT NULL default &#39;&#39;,
`avatar` varchar(100) NOT NULL default &#39;&#39;,
`lastpost` int(100) NOT NULL default &#39;0&#39;,
`lastthread` int(100) NOT NULL default &#39;0&#39;,
`banreason` varchar(255) NOT NULL default &#39;&#39;,
`plusreason` varchar(255) NOT NULL default &#39;&#39;,
`regdate` varchar(255) NOT NULL default &#39;&#39;,
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`)
) ;

[Guest]

I got some problems either at my server but its php version 4.4.2

[abhisar]

LEAVE A COPY OF SCRIPT THAT YOU ARE USING.

[naveen-PHP LEARNER]

yes it is ,everybody told me,it is happening all version,ain&#39;t full....i will se the php version,thanx anyway![/b]

Ur welcome.

[lamar-wap]

Not All Host Supports Unrealx Script What Host Are You On?....

[wapkralj]

yes not all hosts,have expierence ,same error as my close frend so I took addyour.net it&#39;s perfectly

[lamar-wap]

yes not all hosts,have expierence ,same error as my close frend so I took addyour.net it&#39;s perfectly[/b]

unrealx forum script works well on http://100webspace.com too........

[wapkralj]

yes works on many hosts,on some not,but on addyour.net just perfectly

[naveen-PHP LEARNER]

addyour.net rox. Best hosting .

[wapkralj]

aint more

[naveen-PHP LEARNER]

great.