Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Converting/Creating Modules
Author Message
Anders
Worker
Worker



Joined: Jun 16, 2004
Posts: 159
Location: Sweden

PostPosted: Tue Nov 08, 2011 1:35 pm Reply with quote

Hi i wounder if some can help me to fix this staff module so it works with
raven nuke


Last edited by Anders on Wed Jan 02, 2013 12:11 pm; edited 2 times in total 
View user's profile Send private message
nuken
RavenNuke(tm) Development Team



Joined: Mar 11, 2007
Posts: 2024
Location: North Carolina

PostPosted: Tue Nov 08, 2011 1:48 pm Reply with quote

What errors are you getting when you try to install it? It doesn't use the old dbi layer so it should work.

_________________
Tricked Out News 
View user's profile Send private message Send e-mail Visit poster's website
Anders







PostPosted: Tue Nov 08, 2011 3:08 pm Reply with quote

Thanks for fast reply...It dont show anything when i setup a staff

SQL-fråga:

CREATETABLE nuke_staff(

id int( 3)NOTNULL default'',
sid int( 3)NOTNULLAUTO_INCREMENT ,
name varchar( 255)NOTNULL default'',
des mediumtext NOTNULL ,
rank varchar( 255)NOTNULL ,
alias varchar( 255)NOTNULL default'',
photo varchar( 255)NOTNULL default'',
PRIMARYKEY ( sid ) ,
UNIQUEKEY sid( sid )
) TYPE=MYISAM ;



MySQL sa:
#1067 - Invalid default value for 'id'



here is all


CREATE TABLE nuke_staff (
id int(3) NOT NULL default '',
sid int(3) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
des mediumtext NOT NULL,
rank varchar(255) NOT NULL,
alias varchar(255) NOT NULL default '',
photo varchar(255) NOT NULL default '',
PRIMARY KEY (sid),
UNIQUE KEY sid (sid)
) TYPE=MyISAM;

CREATE TABLE nuke_staff_config (
latest int(3) NOT NULL default '',
img_url mediumtext NOT NULL,
staff_join_page mediumtext NOT NULL,
ranks int(3) NOT NULL default '',
index_bl int(3) NOT NULL default '',
copyright_txt mediumtext NOT NULL,
) TYPE=MyISAM;

INSERT INTO nuke_staff_config (
latest,
img_url,
staff_join_page,
ranks,
index_bl,
copyright_txt)
VALUES (
'1',
'images/staff/',
'',
'1',
'1',
'[center][color="#999999" size="1"]Staff v0.3 by [url="http://www.caffeine-junkies.com"]Caffeine Junkies[/url]. © 2004[/colour][/center]');

CREATE TABLE nuke_staff_cat (
id int(3) NOT NULL auto_increment,
name varchar(255) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id)
) TYPE=MyISAM;




nuke_staff_cat Seems just to add nothing else!!
 
Anders







PostPosted: Tue Nov 08, 2011 4:24 pm Reply with quote

Hi i have solve it

##
## Table structure for table `nuke_staff`
##

CREATE TABLE `nuke_staff` (
`id` int(3) NOT NULL default '0',
`sid` int(3) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`des` mediumtext NOT NULL,
`rank` varchar(255) NOT NULL default '',
`alias` varchar(255) NOT NULL default '',
`photo` varchar(255) NOT NULL default '',
PRIMARY KEY (`sid`),
UNIQUE KEY `sid` (`sid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

##
## Dumping data for table `nuke_staff`
##


## ########################################################

##
## Table structure for table `nuke_staff_cat`
##

CREATE TABLE `nuke_staff_cat` (
`id` int(3) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

##
## Dumping data for table `nuke_staff_cat`
##


## ########################################################

##
## Table structure for table `nuke_staff_config`
##

CREATE TABLE `nuke_staff_config` (
`latest` int(3) NOT NULL default '0',
`img_url` mediumtext NOT NULL,
`staff_join_page` mediumtext NOT NULL,
`ranks` int(3) NOT NULL default '0',
`index_bl` int(3) NOT NULL default '0',
`copyright_txt` mediumtext NOT NULL
) TYPE=MyISAM ;

##
## Dumping data for table `nuke_staff_config`
##

INSERT INTO `nuke_staff_config` VALUES (1, 'images/staff/', '', 1, 1, '[center][color="#999999" size="1"]Staff v0.2 by [url="http://www.caffeine-junkies.com"]Caffeine Junkies[/url]. © 2004[/colour][/center]');
 
timothyeudy
New Member
New Member



Joined: Jul 02, 2012
Posts: 1
Location: Concord

PostPosted: Mon Jul 02, 2012 12:07 am Reply with quote

Yeah it has been quite supportive,But by executing it, Displaying error called" Data not found". What does it indicates?
 
View user's profile Send private message
nuken







PostPosted: Mon Jul 02, 2012 11:55 pm Reply with quote

Turn on error reporting and see what error is generated.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Converting/Creating Modules

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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©