Images and SQl related questions...

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   Images and SQl related questions...
dementeddogz
CZ Active Member
dementeddogz has been a member for over 19 year's 19 Year Member
Age: 46
Gender: Male
Fav. Sports Team: Miami
Status: Offline
Joined: Mar 12, 2005
0.02 posts per day
Posts: 163
Points: 21,847
   
Just decided to go ahead and move one of my sites back over to nuke and noticed a few things have changed and or where forgotten :p




Getting the Topics/weblinks/download image to pull from the current_themes topic folder so each theme would have its own image. I remember a small issue back on 6.8 but cant seem to find a similar fix for it in 7.1

And the second thing. Ive got my old database for my old nuke site still intact. Ive decided however to redo everything from scratch and to use some of my own ports. How would I transfer over the members from the previous site to the new site? Ive tried pulling the info (data and structure)from one DB and inserting to the other DB but the information doesnt match up, with different things being installed on each. Im just looking to pull over my members and forum posts.

Also this one I know but just seen to have forgotten. I managed to get a google banner above where you have "Welcome to codezwiz" on my old site....Just cant remember which file it was. been looking around, any ideas?



Any help is appreciated.



Back to top Reply with quote
#2   re: Images and SQl related questions...
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,475
   
You need to check the Web_Links/index.php and replace the image function with a get theme function and if file exists function


$ThemeSel = get_theme();
    if (file_exists("themes/$ThemeSel/images/link-logo.gif")) {
   echo "<br><center><a href=\"modules.php?name=$module_name\"><img src=\"themes/$ThemeSel/images/link-logo.gif\" border=\"0\" alt=\"\"></a><br><br>";
    } else {
   echo "<br><center><a href=\"modules.php?name=$module_name\"><img src=\"modules/$module_name/images/link-logo.gif\" border=\"0\" alt=\"\"></a><br><br>";
    }


You can use that everywhere in the site I do icon_wink.gif


If you load up the old sql in the database and go through each table and delete the added fields its a snap then export the data and reimport the posts or users.

Not sure what you mean by "Welcome to Codezwiz" above could you explain that one a little better please.



_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#3   re: Images and SQl related questions...
dementeddogz
CZ Active Member
dementeddogz has been a member for over 19 year's 19 Year Member
Age: 46
Gender: Male
Fav. Sports Team: Miami
Status: Offline
Joined: Mar 12, 2005
0.02 posts per day
Posts: 163
Points: 21,847
   


You need to check the Web_Links/index.php and replace the image function with a get theme function and if file exists function


Thanks Ill check that out. arent the topics however supposed to do that automatically if they have the directory and if not turn to the default?





Not sure what you mean by "Welcome to Codezwiz" above could you explain that one a little better please.



I just mean the welcome message. In your case it happens to be

Welcome to Codezwiz!


The most unique help site available on the net. exc exc.


I managed to get a google banner right above that that showed up on every page on my old site. Not only can I not remember which file I couldnt even find it on my old sites back up :p






If you load up the old sql in the database and go through each table and delete the added fields its a snap then export the data and reimport the posts or users


I cant get it to upload at all to do any editing. I get "Column count doesn't match value count at row 1" This is one of my main concerns that id like to take care of before the move. Im not so worried about forum posts, would be nice but user info is def my priority.



Back to top Reply with quote
#4   re: Images and SQl related questions...
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,475
   
You cant install the sql on another databse fresh? I dont understand why. Im talking the whole database the old structure everything then dlete from it what the new one has or doesnt have them import it back.

For the block in the center of the home page just above it would be in the header.php after this code

online();
head();
include("includes/counter.php");
global $home;
if ($home == 1) {


The topic titles are yes there is a function in Topics/index.php

$ThemeSel = get_theme();
   if (@file_exists("themes/$ThemeSel/images/topics/$topicimage")) {
       $t_image = "themes/$ThemeSel/images/topics/$topicimage";
   } else {
       $t_image = "$tipath$topicimage";
   }


And it goes right after this chunk of code

echo "<center><font class=\"title\"><b>"._ACTIVETOPICS."</b></font><br>\n"
   ."<font class=\"content\">"._CLICK2LIST."</font><br><br>\n"
   ."<form action=\"modules.php?name=Search\" method=\"post\">"
   ."<input type=\"name\" name=\"query\" size=\"30\">&nbsp;&nbsp;"
   ."<input type=\"submit\" value=\""._SEARCH."\">"
   ."</form></center><br><br>";
    while ($row = $db->sql_fetchrow($result)) {
   $topicid = $row[topicid];
   $topicname = $row[topicname];
   $topicimage = $row[topicimage];
   $topictext = $row[topictext];




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#5   
dementeddogz
CZ Active Member
dementeddogz has been a member for over 19 year's 19 Year Member
Age: 46
Gender: Male
Fav. Sports Team: Miami
Status: Offline
Joined: Mar 12, 2005
0.02 posts per day
Posts: 163
Points: 21,847
   



For the block in the center of the home page just above it would be in the header.php after this code



Nope :\ That be no different really then putting it in includes/my_header. It would put it at the very top of the page. What Im referring to is directly above the welcome message.






The topic titles are yes there is a function in Topics/index.php



See thats what i thought. Thats in their already Im guessing thats new since I last used nuke but its still only pulling up the default image, not the theme based image.




You cant install the sql on another databse fresh? I dont understand why. Im talking the whole database the old structure everything then dlete from it what the new one has or doesnt have them import it back.



Yeah I can probably do it on a fresh DB I was trying to do it on the current one. Not sure Id get it right icon_eek.gif Wanna take a crack at it? :p



Back to top Reply with quote
#6   re: Images and SQl related questions...
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,475
   
Then your files are wrong. As you can see on my front page the word blah placed right where I told you to place it.




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#7   
dementeddogz
CZ Active Member
dementeddogz has been a member for over 19 year's 19 Year Member
Age: 46
Gender: Male
Fav. Sports Team: Miami
Status: Offline
Joined: Mar 12, 2005
0.02 posts per day
Posts: 163
Points: 21,847
   
I must not of been on during the whole blah thing to see it. I just know when I put it in my header it was way up top. On my old site its up above the welcome message but not in the header. Cant find it in any file offhand actually, I think one of my old admins may have tossed it in on that site, which would explain why I cant remember which one :p


Ill hit your contact forum I guess on another matter.



Back to top Reply with quote
#8   re: Images and SQl related questions...
Telli
Site Admin
Occupation: Self Employed
Age: 46
Gender: Male
Fav. Sports Team: Detroit Red Wings
Website:
Status: Offline
Joined: May 26, 2003
1.03 posts per day
Posts: 8089
Points: 494,475
   
Place it just above this and see if it doesnt show up above the top block.

    message_box();
    blocks(Center);




_________________
The path of the righteous man is beset on all sides by the inequities of the selfish and the tyranny of evil men. Blessed is he, who in the name of charity and good will, shepherds the weak through the valley of darkness, for he is truly his brother's keeper and the finder of lost children. And I will strike down upon thee with great vengeance and furious anger those who would attempt to poison and destroy my brothers. And you will know my name is the Lord when I lay my vengeance upon thee. Ezekiel 25:17
Back to top Reply with quote
#9   
dementeddogz
CZ Active Member
dementeddogz has been a member for over 19 year's 19 Year Member
Age: 46
Gender: Male
Fav. Sports Team: Miami
Status: Offline
Joined: Mar 12, 2005
0.02 posts per day
Posts: 163
Points: 21,847
   
I stand corrected icon_redface.gif I tried it in a few places but not in that bracket.

EDIT: that still only shows on main page. On the other site what ever file was edited placed it there and kept it there on everypage...



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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 cannot download files in this forum