Clan Themes, We Make Clans Look Good!

CT on Facebook

Latest Product

Mech Warrior Online Xtreme Theme

User Box

Anonymous

38.107.179.218

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 - image link problem with 'Medal System mod' from mod pack

image link problem with 'Medal System mod' from mod pack
Goto page 1, 2, 3, 4 Next

37 Replies / 14025 Views


www.clanthemes.com Forum Index » PHPBB	View previous topic :: View next topic

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

image link problem with 'Medal System mod' from mod pack Posted: Sat Feb 03, 2007 10:45 am
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

edit: removed 1st post as it no longer applies but please help here if possible:

I'm getting ready to install the "Medal System mod v: 2.0.1" which I got from the BBToNuke pack. In the instructions it says I need to add some tables to the database and I have done so for one table (nuke_bbmedal) using the query option in phpmyadmin without any problems, however the next two tables bring up a error when I type in the code in the query box. This is what I query....

Code:

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;

The ERROR MSG I get after:

Code:

Error

SQL query:

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 ;

MySQL said: Documentation
<a href="modules.php?name=Forums&file=search&search_keywords=1067&mode=results">#1067</a> - Invalid default value for 'medal_id'

Exact same error when I try to create the next table also... "nuke_bbmedal_mod"

Last edited by OzButcher on Mon Feb 05, 2007 8:51 am; edited 2 times in total

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Sun Feb 04, 2007 2:58 pm
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

I changed my first post as i found a nuke medal mod in the BBToNuke pack... however there are 2 little problems... please help if you can :) see post #1 ^

Ped
Reputation: 93.4
votes: 37
Local time: 11:14 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: 3670
Points: 191811

Posted: Sun Feb 04, 2007 5:36 pm
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

yeah i see your trouble...

i tried it on my testsite and got the same issue so your not doing nothing wrong

i tried adding a 0 in between the ' ' and it took i dont know what effects it will have !

here it is any way

Code:

CREATE TABLE `nuke_bbmedal_user` (
`issue_id` mediumint(8) NOT NULL auto_increment,
`medal_id` mediumint(40) NOT NULL default '0',
`user_id` mediumint(8) NOT NULL default '0',
`issue_reason` varchar(255) NOT NULL default '0',
`issue_time` int(11) NOT NULL default '0',
PRIMARY KEY (`issue_id`)
) TYPE=MyISAM;

Do the same for the nuke_bbmedal_mod too

Code:

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

Floppy might be able to explain Dont Know

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Sun Feb 04, 2007 10:34 pm
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

yes I see it works that way. Dont Know

will the mod still work hehe. I will upload the remaining files after work and see what happens.

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Mon Feb 05, 2007 8:46 am
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

Well it seems to be working but I got a slight link problem. Whilst viewing topic & medal page the award image doesnt show up... but shows up fine in users profiles. I think the code for this in relating to topic is:
\theme\aviator\forum\viewtopic_body.tpl

but I can only guess if the code has a bug:

Code:

<BEGIN>
<tr>
 <td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><a></a>{postrow.rowtit}{postrow.POSTER_NAME} 
{postrow.POSTER_RANK} {postrow.RANK_IMAGE} {postrow.POSTER_AVATAR} {postrow.POSTER_JOINED} <a>{postrow.POSTER_POSTS}</a>
 {postrow.POSTER_FROM} {postrow.POSTER_MEDAL_COUNT} 
 <BEGIN>
 <table border="0" cellspacing="0" cellpadding="5">
 <BEGIN>
 <tr align="left" valign="middle">
 <BEGIN>
 <td><img src="{postrow.medal.medal_row.medal_col.MEDAL_IMAGE}" border="0" alt="{postrow.medal.medal_row.medal_col.MEDAL_NAME} {postrow.medal.medal_row.medal_col.MEDAL_COUNT}" title="{postrow.medal.medal_row.medal_col.MEDAL_NAME}{postrow.medal.medal_row.medal_col.MEDAL_COUNT}"></a></td>
 <END>
 </tr>
 <END>
 </table>
 <END> {postrow.CASH} <a>Items</a>{postrow.ITEMS} {postrow.POSTER_ONLINE_STATUS} </td>

This screenie is from firefox show doesnt display the no image box like in ie, but I think its missing anyway...

Image Has Been Resized, Click To Enlarge.

Ped
Reputation: 93.4
votes: 37
Local time: 11:14 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: 3670
Points: 191811

Re: Posted: Mon Feb 05, 2007 9:09 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

here is your problem

There trying to find the rank images from http://burntclan.swisshut.com/images/medals/admin.gif note its missing the modules/forums/

Im presuming (think) that this would ether be set up in the ACP or be found in the modules/forums/viewtopic.php

Without actually installing it myself its a little tricky

on a side note could you submit your forums rank images they are very nice, ill add them to the downlaods section

These ones

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Mon Feb 05, 2007 9:17 am
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

im not sure if I fully understand :P are u saying that the medals mod thinks the medal image is actually that link to the admin.gif file?? thats weird.

in user profiles... the medal shows up just fine.

Ped
Reputation: 93.4
votes: 37
Local time: 11:14 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: 3670
Points: 191811

Re: Posted: Mon Feb 05, 2007 9:28 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

Yeah that doesn't matter, there different templates, and will pull the information from different files

ive just had a quick look at the install and do you have to specify the images location in the ACP ?

other than that i think the problem may be in the includes/page_header.php edits

Code:

'I_MEDALS' => '<img src="' . $images['Medals'] . '" width="12" height="13" border="0" alt="' . $lang['Medals'] . '" hspace="3">', // Medal MOD

just a hunch though... i may install it later on my test site

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Mon Feb 05, 2007 10:16 am
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

Yes I need to specify image location for the medals when I create them... eg, here are some screenies of the ACP

Admin Screens:

Image Has Been Resized, Click To Enlarge.

Ped
Reputation: 93.4
votes: 37
Local time: 11:14 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: 3670
Points: 191811

Re: Posted: Mon Feb 05, 2007 10:24 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

just add modules/forums/ in front of the medal image see if that fixes it... it probably wont, im thinking it will be a file edit but there is no harm in trying
Rolling Eyes

OzButcher
Reputation: 464.1
Local time: 6:14 AM

OMG

0.07 posts per day
Medals: 1 (View more...)

Joined: Jan 16, 2007
Last Visit: 26 Feb 2008
Posts: 135
Points: 100

Posted: Mon Feb 05, 2007 10:32 am
Shop Purchases:Battlefield 2142 PhpNuke Theme (Aviator) · Clan Roster v1.7 Php Nuke Module · Battlefield 2142 X-Theme (Ultimate)

ok I tried it but it didnt work. the image didnt show up anymore in the ACP when I did that. doh. Nerd

Ped
Reputation: 93.4
votes: 37
Local time: 11:14 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: 3670
Points: 191811

Re: Posted: Mon Feb 05, 2007 10:34 am
Shop Purchases:Clan Roster 2.0 · Bad Company 2 Vietnam Xtreme Theme

ok let me install it and ill see where the problem is

www.clanthemes.com Forum Index » PHPBB

37 Replies / 14025 Views
Page 1 of 4
All times are GMT
Goto page 1, 2, 3, 4 Next

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