Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.220

PND Downloads Feed

How to Delete or Reset yo...

Lost your admin password ?Â Cant login to your admin account ? This s...

Back Online & Stuff

Look at us with our nifty website back up and running… Seriously...

How to edit the admins in...

Here is a way to make someone admin in your forums on your Evo site. I...

Demo Splash Screen

Ped @ Clan Themes has released a simple splash screen entrance hack.Â ...

Free Phpnuke Business The...

This is the 6th Business theme for Phpnuke that Clan Themes has releas...

Tricked Out Slider

We have seen some great new things come out of Tricked Out News and th...

Phpnuke Downloads

Custom Work

www.clanthemes.com :: View topic - Forum medals mod

Forum medals mod

8 Replies / 3118 Views


www.clanthemes.com Forum Index » How To's	View previous topic :: View next topic

Spinski
Reputation: 473.6
Local time: 7:13 PM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Feb 26, 2007
Last Visit: 14 Oct 2008
Posts: 27
Points: 616

Forum medals mod Posted: Mon Sep 03, 2007 1:08 am
Shop Purchases:Armed Assault Theme (Cold Steel) for PHP Nuke · Multi Gaming (Warrior) Red Style Theme

hi,

ive installed the medal mod and all was goin well untill i hit this error

can any1 help plz ?? ?

http://i94.photobucket.com/albums/l120/spinnadj/exam.jpg

http://i94.photobucket.com/albums/l120/spinnadj/xaammm.jpg

Ped
Reputation: 93.3
votes: 37
Local time: 7:13 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 24 May 2012
Posts: 3669
Points: 191761

Re: Forum medals mod Posted: Mon Sep 03, 2007 6:26 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

yeah your sql table bbmedal_mod doesn't exist make sure when you add the tables that you have changed the first part to match IE web78-nuke-2._nuke_bbmedal_mod and not just nuke_bbmedal_mod you will have to look closely at the sql when adding it

The second image is more work im afraid, in your text editor delete all of the ' ' ' ' ' ' ' ' ive put spaces in to show you what i mean.

If you post the SQL Tables here i will show you what i mean

Spinski
Reputation: 473.6
Local time: 7:13 PM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Feb 26, 2007
Last Visit: 14 Oct 2008
Posts: 27
Points: 616

Forum medals mod Posted: Mon Sep 03, 2007 2:38 pm
Shop Purchases:Armed Assault Theme (Cold Steel) for PHP Nuke · Multi Gaming (Warrior) Red Style Theme

thx ped...

# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal` (
`medal_id` mediumint(8) NOT NULL auto_increment,
`medal_name` varchar(40) NOT NULL default '',
`medal_description` varchar(255) NOT NULL default '',
`medal_image` varchar(40) default NULL,
PRIMARY KEY (`medal_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
`issue_reason` varchar(255) NOT NULL default '',
`issue_time` int(11) NOT NULL default '',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
CREATE TABLE `nuke_bbmedal_mod` (
`mod_id` mediumint(8) unsigned NOT NULL auto_increment,
`medal_id` mediumint(8) NOT NULL default '',
`user_id` mediumint(8) NOT NULL default '',
PRIMARY KEY (`mod_id`)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
# Remember to change the table prefix used on your database
INSERT INTO `nuke_bbconfig` VALUES ('allow_medal_dispaly', '0');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_row', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_col', '1');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_width', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_height', '');
INSERT INTO `nuke_bbconfig` VALUES ('medal_display_order', '');

GUNNZZY
Reputation: 461.4
Local time: 11:13 AM
Location: http://da-squad.net

Noob

0.00 posts per day
Medals: 0

Joined: Apr 01, 2007
Last Visit: 04 Sep 2007
Posts: 2
Points: 263

Forum medals mod Posted: Mon Sep 03, 2007 3:20 pm

im still getting the same error on his site...hmmm

Spinski
Reputation: 473.6
Local time: 7:13 PM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Feb 26, 2007
Last Visit: 14 Oct 2008
Posts: 27
Points: 616

Forum medals mod Posted: Mon Sep 03, 2007 3:47 pm
Shop Purchases:Armed Assault Theme (Cold Steel) for PHP Nuke · Multi Gaming (Warrior) Red Style Theme

lol fun to be a noob aint it Confused

Ped
Reputation: 93.3
votes: 37
Local time: 7:13 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 24 May 2012
Posts: 3669
Points: 191761

Forum medals mod Posted: Mon Sep 03, 2007 7:29 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

If i try to install

CREATE TABLE web78-nuke-2._nuke_bbmedal (
medal_id mediumint(8) NOT NULL auto_increment,
medal_name varchar(40) NOT NULL default '',
medal_description varchar(255) NOT NULL default '',
medal_image varchar(40) default NULL,
PRIMARY KEY (medal_id)
) TYPE=MyISAM;

It doesnt like the name of your web78-nuke-2._ IE CREATE TABLE web78-nuke-2._nuke_bbmedal because just CREATE TABLE nuke_bbmedal works fine see below !

CREATE TABLE nuke_bbmedal (
medal_id mediumint(8) NOT NULL auto_increment,
medal_name varchar(40) NOT NULL default '',
medal_description varchar(255) NOT NULL default '',
medal_image varchar(40) default NULL,
PRIMARY KEY (medal_id)
) TYPE=MyISAM;

[hr]

Here is the working version with just nuke prefix:

CREATE TABLE nuke_bbmedal (
medal_id mediumint(8) NOT NULL auto_increment,
medal_name varchar(40) NOT NULL default '',
medal_description varchar(255) NOT NULL default '',
medal_image varchar(40) default NULL,
PRIMARY KEY (medal_id)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#
CREATE TABLE nuke_bbmedal_user (
issue_id mediumint(8) NOT NULL auto_increment,
medal_id mediumint(8) NOT NULL default '',
user_id mediumint(8) NOT NULL default '',
issue_reason varchar(255) NOT NULL default '',
issue_time int(11) NOT NULL default '',
PRIMARY KEY (issue_id)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#

CREATE TABLE nuke_bbmedal_mod (
mod_id mediumint(8) unsigned NOT NULL auto_increment,
medal_id mediumint(8) NOT NULL default '',
user_id mediumint(8) NOT NULL default '',
PRIMARY KEY (mod_id)
) TYPE=MyISAM;

#
#-----[ ADD SQL ]------------------------------------------
#

INSERT INTO nuke_bbconfig VALUES ('allow_medal_display', '0');
INSERT INTO nuke_bbconfig VALUES ('medal_display_row', '1');
INSERT INTO nuke_bbconfig VALUES ('medal_display_col', '1');
INSERT INTO nuke_bbconfig VALUES ('medal_display_width', '');
INSERT INTO nuke_bbconfig VALUES ('medal_display_height', '');
INSERT INTO nuke_bbconfig VALUES ('medal_display_order', '');

Dont know what else to suggest have you had anyother problems with your tables ?

Spinski
Reputation: 473.6
Local time: 7:13 PM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Feb 26, 2007
Last Visit: 14 Oct 2008
Posts: 27
Points: 616

Forum medals mod Posted: Mon Sep 03, 2007 7:56 pm
Shop Purchases:Armed Assault Theme (Cold Steel) for PHP Nuke · Multi Gaming (Warrior) Red Style Theme

no not really, im well out of my depth here i think i might jus unintall it all

Ped
Reputation: 93.3
votes: 37
Local time: 7:13 PM
Location: Great British Empire

Site Founder

1.82 posts per day
Medals: 2 (View more...)

Theme Guru

Joined: Nov 13, 2006
Last Visit: 24 May 2012
Posts: 3669
Points: 191761

Re: Forum medals mod Posted: Mon Sep 03, 2007 9:01 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Just out of curiosity why did you choose web78-nuke-2._ as your prefix and not nuke_

i know for security you should use something other than nuke_ but web78-nuke-2._ takes the mick a little !

LMAO

Spinski
Reputation: 473.6
Local time: 7:13 PM

Rocket Noob

0.01 posts per day
Medals: 0

Joined: Feb 26, 2007
Last Visit: 14 Oct 2008
Posts: 27
Points: 616

Forum medals mod Posted: Mon Sep 03, 2007 11:45 pm
Shop Purchases:Armed Assault Theme (Cold Steel) for PHP Nuke · Multi Gaming (Warrior) Red Style Theme

lol i didnt set it up yoss did Dont Know

www.clanthemes.com Forum Index » How To's

8 Replies / 3118 Views
Page 1 of 1
All times are GMT

Display posts from previous:

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

Company Information
Home · About Us · Affiliates · Advertising
Link To Us · Newsletter · Contact Us · Site Map
All content © Clan Themes 2006 - 2012
Based on RavenNuke

Clan Themes, We Make Clans Look Good!

Sponsors

CT on Facebook

Latest Product

User Box

PND Downloads Feed

Custom Work