[BETA] phpBB Neptune v0.1.0

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Skyy04
Registered User
Posts: 164
Joined: Tue Jul 06, 2004 9:46 pm
Location: Canada
Contact:

Post by Skyy04 »

hey the link is still not working man, can you fix it?

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

Sorry I thought I already fixed the link.

Check the first post I fixed it.

kukacomone
Registered User
Posts: 55
Joined: Wed Jul 14, 2004 10:30 pm

Post by kukacomone »

Hello.

I wanna clear all the warnings, so i want that everyone get 0 warning.
How can i do this?

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

I dont have that feature, nice idea i might add it later on.

but for now upload this to your website name it "remove_warns.php" and run it:

Code: Select all

<?php
// -------------------------------------------------------------
//
// FILENAME  : remove_warns.php
// COPYRIGHT : © 2005 A.I. BOT ( admin@aibots.net )
// WWW       : http://www.aibots.net
// LICENCE   : GPL v2.0
//
// -------------------------------------------------------------
define ( 'IN_PHPBB', true );
$phpbb_root_path = './';
require ( $phpbb_root_path . 'extension.inc' );
include ( $phpbb_root_path . 'common.'.$phpEx );

$sql	= "SELECT * FROM " . USERS_TABLE;
$result	= $db->sql_query ( $sql );

for ( $i = 0; $i < $db->sql_numrows ( $result ); $i++ )
{
	$row	= $db->sql_fetchrow ( $result );

	$sql	= "UPDATE " . USERS_TABLE . " SET user_warn = '0' WHERE user_id = " . $row[ 'user_id' ];
	$result	= $db->sql_query ( $sql );
}

?>
this is untested but it should work.

Americas Reject
Registered User
Posts: 126
Joined: Thu Jan 13, 2005 3:24 am

Post by Americas Reject »

When I get the PM, it does not shwo up as unread in my inbox, but the op up apears.

ALso now that I have a guy banned I egt this error

phpBB : Critical Error

Could not query information

DEBUG MODE

SQL Error : 1054 Unknown column 'user_id' in 'where clause'

DELETE FROM phpbb_banlist WHERE user_id = 3

Line : 30
File : backend.neptune.php

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

Thanks for letting me know. ZIP updated, download on first page.

to update just replace /mods/neptune/includes/backend.neptune.php with /mods/neptune/includes/backend.neptune.php in your phpbb folder

Americas Reject
Registered User
Posts: 126
Joined: Thu Jan 13, 2005 3:24 am

Post by Americas Reject »

It just started working now....

UPDATED MORE:
Mmmmhmk, It now bans the user. But I still get this error,

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/wmresour/public_html/forum/db/mysql4.php on line 167

Warning: Cannot modify header information - headers already sent by (output started at /home/wmresour/public_html/forum/db/mysql4.php:167) in /home/wmresour/public_html/forum/includes/page_header.php on line 657

Warning: Cannot modify header information - headers already sent by (output started at /home/wmresour/public_html/forum/db/mysql4.php:167) in /home/wmresour/public_html/forum/includes/page_header.php on line 659

Warning: Cannot modify header information - headers already sent by (output started at /home/wmresour/public_html/forum/db/mysql4.php:167) in /home/wmresour/public_html/forum/includes/page_header.php on line 660
After I visit the index for the first time after I warned a user. After it is refreshed it goes back to normal.

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

i dont think that error has to do with this mod :/

Americas Reject
Registered User
Posts: 126
Joined: Thu Jan 13, 2005 3:24 am

Post by Americas Reject »

all is working except the "unread pm" thing I told u about earlier on msn

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

Yeah I think I found the problem of that, if i get time tonight I will fix it and update the ZIP

kukacomone
Registered User
Posts: 55
Joined: Wed Jul 14, 2004 10:30 pm

Post by kukacomone »

A.I. BOT wrote: I dont have that feature, nice idea i might add it later on.

but for now upload this to your website name it "remove_warns.php" and run it:

Code: Select all

<?php
// -------------------------------------------------------------
//
// FILENAME  : remove_warns.php
// COPYRIGHT : © 2005 A.I. BOT ( admin@aibots.net )
// WWW       : http://www.aibots.net
// LICENCE   : GPL v2.0
//
// -------------------------------------------------------------
define ( 'IN_PHPBB', true );
$phpbb_root_path = './';
require ( $phpbb_root_path . 'extension.inc' );
include ( $phpbb_root_path . 'common.'.$phpEx );

$sql	= "SELECT * FROM " . USERS_TABLE;
$result	= $db->sql_query ( $sql );

for ( $i = 0; $i < $db->sql_numrows ( $result ); $i++ )
{
	$row	= $db->sql_fetchrow ( $result );

	$sql	= "UPDATE " . USERS_TABLE . " SET user_warn = '0' WHERE user_id = " . $row[ 'user_id' ];
	$result	= $db->sql_query ( $sql );
}

?>
this is untested but it should work.


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /data/users/matuska/home/web/db/mysql4.php on line 167

Americas Reject
Registered User
Posts: 126
Joined: Thu Jan 13, 2005 3:24 am

Post by Americas Reject »

A.I. BOT wrote: Yeah I think I found the problem of that, if i get time tonight I will fix it and update the ZIP


Awesome =D

uvbull
Registered User
Posts: 9
Joined: Sat Jul 30, 2005 7:05 pm

Post by uvbull »

Code: Select all

phpBB : Critical Error

Could not query information

DEBUG MODE

SQL Error : 1146 A 'advent1.phpbb_cbanlist' tabla nem letezik

SELECT * FROM phpbb_cbanlist

Line : 14
File : backend.neptune.php
somwere help me...
wath is this???

uvbull
Registered User
Posts: 9
Joined: Sat Jul 30, 2005 7:05 pm

Post by uvbull »

line 14 is:

Code: Select all

	message_die ( CRITICAL_ERROR, 'Could not query information', '', __LINE__, __FILE__, $sql );

A.I. BOT
Registered User
Posts: 1848
Joined: Thu Apr 17, 2003 11:43 pm
Location: Newfoundland, Canada
Contact:

Post by A.I. BOT »

I dont understand what language you have that in. What I think it's saying is that the table does not exist. Are you sure you ran the install?

Post Reply

Return to “[2.0.x] MODs in Development”