PHP Database help Please?

[swiftmed]

Hello Guys,

I have a little bit of a problem that i dont know how to fix. could you please take a look at www.4design4style.com,

On the right hand side there are 3 boxes, choose 4Design in the top box, and then look in the second box...you will notice there are 2 "Gallerys and Museums", one of which doesnt work. the thing is i dont know how to remove it. it doesnt show up in the admin section for the site, and i really dont know how to get rid of it.

Would sombody please give me advice on what i need to do, or be kind enough to do it for me if i pay you via paypal please? i would be very very greatful.

[daboss]

i should think that the data is in stored in a database table. so:
1. go to cpanel
2. click on databases
3. click on phpmyadmin
4. select your database
5. browse through the tables looking for "gallery and museums"

when you find it, delete one...

[swiftmed]

Hey mate, thanks for your reply. it is all stored in a database, but ive looked through time and time again and cant find it, i just dont understand whats going on. i got a meeting wit the customer tonight so i need to try n get it sorted ASAP.

[Taltos]

Hi swiftmed,

I did a quick view source and searched for 4 Galleries and Museums. It looks like all those options are getting added by scripted functions in the middle of the page. I did not have time to decipher the code but I think that is where you should look. It looks very repetitive so it may take some reverse engineering to figure out what they are doing.

Here is a little piece of the code to search for to help you find it:

TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Africa+#+4 Africa");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Africa+#+4 Africa");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Art+#+4 Art+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");

Good Luck!

[swiftmed]

Hi Taltos,

Thank you for taking the time to have a look for me. i really appreciate that. at least i know there is another place to look now. The website is coded terribly. im trying to clean up another webmasters mess, tis a right pain.

Anyways, thanks for that. im gonna take a look at that in am minute an ill post back here with an update of the situation.

[Taltos]

After another quick look, my guess is the fifth line in this chunk is the culprit:

TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums +#+4 Galleries and Museums +#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 Europe+#+4 Europe");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 North America+#+4 North America");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 North America+#+4 North America");
TCN_addContent("4 Design+#+4 Design+#+4 Galleries and Museums+#+4 Galleries and Museums+#+4 North America+#+4 North America");

It is spaced different than everything else in this section of code. Still don't follow the logic on this yet but haven't looked too hard.

Have fun!!