Flush vbulletin cookies

[MrHorror]

So I've switched databases and I still have my board looking strange after installing Valter's VSA paypal donate mod. I even deleted my forum folder from my public_html, and uploaded a backup forum folder I ftp'ed a week before I installed the mod. And still, my board looks odd thanks to this mod. I am all out of ideas. Does anyone know how to flush a vbulletin board's cookies? Proboards has an option where you can completely delete board cookies for eveyrone including yourself. Is there an option for this for vb 3.8?
No members have liked this post.

[BirdOPrey5]

You can edit your config.php and change the cookie-prefix, that will effectively force vbulletin to create all new cookies.

Although simply deleting cookies from your browser should have the same effect.

But I promise you any style issue you think you have will not be fixed by "flushing cookies."

As I PMed you please post a screenshot with exactly what doesn't look right to you, and please also try in another browser and see if the problem is across all browsers or just one.

[MrHorror]

You can edit your config.php and change the cookie-prefix, that will effectively force vbulletin to create all new cookies.

Although simply deleting cookies from your browser should have the same effect.

But I promise you any style issue you think you have will not be fixed by "flushing cookies."

As I PMed you please post a screenshot with exactly what doesn't look right to you, and please also try in another browser and see if the problem is across all browsers or just one.


Tried it on google chrome, msn 6, msn 8, IE6, IE7, and the same issue arises. It's really noticeable more in my vb default skin and my hmands slasher skin. I had those skinned specifically to be sleek and small and compact. So after I did all of that stuff with the database earlier today, and reuploading a copy of my vb forum folder. What was discussed in the new PM I sent you? Might be the issue. It's ALL I can think of.

[BirdOPrey5]

I really can't begin to help without a screenshot of the problem. I see no issues when I view it.

[MrHorror]

The issue isn't MAJOR. But I certainly notice that after the vb4 mod was accidentally installed? It made the category strips stretch out or break or something. When I uninstalled, it didn't undo what it did. I can't get a screenshot of my other skins. Google unfortunately only caches the main skin. But I know what I'm talking about.

As far as the config.php file is concerned. Let me try and explain a bit better. I told my webhost to create a second database for me. So I could upload a backup of my forum to the NEW database. They did. So now I have 2 databases at my disposal. hmands_nicky and hmands_new. But I'm running vb on one specifically. The new one, hmands_new.

When they uploaded the backup of my forum from Sunday. And the backup of my forum from December 31st 2011 to hmands_new (the new database), the errors with the styles were still present. So I assumed it was a forum issue since switching databases didn't apparently solve the problem. But I rememberd my "one single" config.php file in my forums folder. I only changed the DATABASE NAME in the config.php file from hmands_nicky, to hmands_new.

I never changed or edited the DATABASE USERNAME or DATABASE PASSWORD in my config.php file. Because my host set it up where the new database uses the same DATABASE USERNAME and DATABASE PASSWORD, as the old database. So my question is, could this be why switching databases didn't work? Do I also need to create a new DATABASE USERNAME and DATABASE PASSWORD to place into my config.php file??

Or for example. If you had 3 databases at your disposal. And moved your vb forum from one DB to another. Would just changing the DATABASE name in your forums config.php file be enough? Or would you have to change the DB NAME, the DB USERNAME, AND THE DB PASSWORD? And then possibly delete the database you just moved your forum from? If they all run on the same server?

[BirdOPrey5]

If your host kept the same username and password then all you need to change is the database name. If the username or password were wrong you'd get an immediate database error on anything you tried.

[MrHorror]

Ok here's what I think I was doing wrong. I was switching databases thinking that would solve the problem. But the backup I made of my forum was after I installed the bad plugin. So I would install that backup into the new databases first. Thus, I think the data from my backup is corrupting the new database tables. And even when I wipe the data from the new database. It's still bad because it has been already touched with the corrupt backup data.


So what I think I have to do, is create a fresh new database. And install the backup from December 31st 2011 into that database. Thus it would be uncorrupted. Also here's more on the mod itself. Valter's VSA paypal donate for VB4. When I installed, I got this error at the top of the page.


Warning: array_merge() [function.array-merge]: Argument #1 is not an array in [path]/global.php(355) : eval()'d code on line 46



Also I saw this in my admin cp for this particular plugin.

There are four boxes, with each box having two columns listed underneath. One column marked install code? Has two boxes underneath it. The other column marked uninstall code? Has two boxes underneath as well. At the top, it says EXISTING INSTALL/UNINSTALL CODE. But here's the problem.



Underneath the install code column. Box 1 says...

$vbulletin->db->hide_errors();
echo "<br /><center>Transferring your previous Donations to a new version...</center>";
vbflush();
$vsapp_getold = $vbulletin->db->query_read("
SELECT id, userid, amount, dateline, confirmed, userip, subs
FROM " . TABLE_PREFIX . "cybppdonate AS cybppdonate
ORDER BY id
");
while ($vsapp_old = $db->fetch_array($vsapp_getold))
{
$vbulletin->db->query_write("
INSERT INTO ".TABLE_PREFIX."vsa_ppdonate
(userid, amount, dateline, confirmed, userip, subs)
VALUES ('" . $vbulletin->db->escape_string($vsapp_old['userid']) . "', '" . $vbulletin->db->escape_string($vsapp_old['amount']) . "', '" . $vbulletin->db->escape_string($vsapp_old['dateline']) . "', '" . $vbulletin->db->escape_string($vsapp_old['confirmed']) . "', '" . $vbulletin->db->escape_string($vsapp_old['userip']) . "', '" . $vbulletin->db->escape_string($vsapp_old['subs']) . "')
");
}
$vbulletin->db->show_errors();



Box 2 says...

$vbulletin->db->hide_errors();
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."vsa_ppdonate` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`userid` INT(10) NOT NULL,
`amount` INT(10) NOT NULL,
`dateline` INT(20) NOT NULL,
`confirmed` INT(1) NOT NULL,
`userip` VARCHAR(20) NOT NULL,
`subs` INT(3) DEFAULT '0' NOT NULL)
");
$vbulletin->db->show_errors();






Now under the uninstall code column, box 1 is EMPTY. Box 2 though says...

$vbulletin->db->hide_errors();
$vbulletin->db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "vsa_ppdonate` ");
$vbulletin->db->show_errors();




Keep in mind this is what was located in my admin cp when the plugin/mod was installed. Now that it's uninstalled, those options for this plugin aren't there anymore. However...I think this might be the problem. There was no uninstall code in box 1 of the uninstall code column! So could it be something is still being called by this plugin even though it's technically uninstalled? Perhaps you can help BOP5? Do I need to edit my global.php file in my forum folder?

[BirdOPrey5]

Oh my gosh... SLOW DOWN.

If you use a backup from December 31st you are going to lose almost 5 full months of posts and users... Is that really what you want?

Worse I'm pretty sure it's not going to change anything. Please for your own sake try the backup on a "test forum" which your license allows you to have first before deleting your main forum to try an untested backup.

That install code only creates a database table to hold old donations, uninstall code would remove that table. Absolutely nothing in the install/uninstall code would affect your styles.

You are willing to do all this database work to try and fix something but you are not willing to hit the "Print Screen" button, save a screenshot, and draw a simple arrow or circle pointing out to me what changed on your style?

[MrHorror]

Here's a screenshot....https://vborg.vbsupport.ru/external/2012/04/14.jpg

The category strips are a lot longer than normal. It may not look like it to you but to me I can definitely tell. I think it also might have something to do with the body? It's normally more compressed to fit the screen. The plugin has broken frames or something.

As far as the database is concerned, I have two databases given to me on my hosting. So I plan to upload the 12/31 backup to the new database. If it's successful, I'll delete the old one. With the "affected" vb installation.

[BirdOPrey5]

The section that says "Horror Moves & Horror Films" ? Are you saying it's too TALL (vertical height)?

Or too wide? I don't see how it could be too wide since it's as wide as the table and always is.

But on the other hand I also can't see how what you post is too tall either, though I suppose it is possible for a shorter row if that is what you are after.

[MrHorror]

The section that says "Horror Moves & Horror Films" ? Are you saying it's too TALL (vertical height)?

Or too wide? I don't see how it could be too wide since it's as wide as the table and always is.

But on the other hand I also can't see how what you post is too tall either, though I suppose it is possible for a shorter row if that is what you are after.


It's too wide. Not too wide? But definitely wider than I had it before. Ok so my host installed the 12/31 backup to the new database and the error remains. Is the vb license tied into this? If I upload vb to new database, without deleting the old database that has my vb on it first? Will the license cause the installation on the new database to merge with the old install? Or could this be a server issue? Do I need to change servers? Or do I need to change ports? Both my db's run on localhost. What I'm saying is, do I need to delete All of my databases that have vb installed on them. Before I upload a back up .sql? In order for the backup to fully take?

[kh99]

If you change the name of the database in your config.php, that's it, it's using the new database and not the old one. None of the things you mentioned will have anything to do with it.

I'm sure Joe knows a lot more about styles than I do, but I'd say that if you switch databases and the problem is still there, then it was always there and you just didn't notice for some reason. I suppose if you have "Store CSS Stylesheets as Files" set to yes then it's possible there's some CSS that's not affected by switching databases. But I agree with Joe that there's really no way it could have been a problem with that mod.

The alignment of things can be affected by the length of post and thread titles - maybe it's just that someone posted a new thread with a title that's longer than when everything looked right.

[MrHorror]

I have store css as files set to NO. I don't know what the problem is but I definitely didn't have this problem ever since setting up the board as of last winter. So we've been using this board for almost a year and a half now. Which is why when things changed it became so noticeable. Especially since I designed the skins myself as far as colors are concerned. So I knew how wide and not wide they were supposed to be. Once this vb4 vsa mod came and went, the trouble started.

--------------- Added 1335106863 at 1335106863 ---------------

If you change the name of the database in your config.php, that's it, it's using the new database and not the old one. None of the things you mentioned will have anything to do with it.

I'm sure Joe knows a lot more about styles than I do, but I'd say that if you switch databases and the problem is still there, then it was always there and you just didn't notice for some reason. I suppose if you have "Store CSS Stylesheets as Files" set to yes then it's possible there's some CSS that's not affected by switching databases. But I agree with Joe that there's really no way it could have been a problem with that mod.

The alignment of things can be affected by the length of post and thread titles - maybe it's just that someone posted a new thread with a title that's longer than when everything looked right.

Are you sure it couldn't be server related though? Or port related? Maybe some left over info is being called from somewhere? Or it permanently affected the way the forum is displayed on the server?

[BirdOPrey5]

It's too wide. Not too wide? But definitely wider than I had it before. Ok so my host installed the 12/31 backup to the new database and the error remains. Is the vb license tied into this? If I upload vb to new database, without deleting the old database that has my vb on it first? Will the license cause the installation on the new database to merge with the old install? Or could this be a server issue? Do I need to change servers? Or do I need to change ports? Both my db's run on localhost. What I'm saying is, do I need to delete All of my databases that have vb installed on them. Before I upload a back up .sql? In order for the backup to fully take?

Listen...

You went back to the old database and it looks exactly the same...

Nothing has changed- you just didn't notice it before. Your forum looks exactly how a vBulletin forum is supposed to look.

You can re-upload your original vbulletin files but I know it won't make a difference.

You said you had tried it with hooks disabled and that didn't make a difference either, right?

There is nothing left to do- your forum looks like how it is supposed to look and how it must have always looked. Is it possible your web browser zoom is on? Check your zoom settings... Or maybe your computer resolution has changed? Whatever it is, it's NOT your forum.

How do you mean it is "TOO WIDE" ? It's as WIDE as the browser window like it's supposed to be. Do you want a Fixed Width style? Something that doesn't get wider as the browser window widens? Is that the question?

[kh99]

Are you sure it couldn't be server related though? Or port related? Maybe some left over info is being called from somewhere? Or it permanently affected the way the forum is displayed on the server?

This stuff's complicated and nothing's impossible, so I won't say it's not a possibility. We just don't see what it could be. You went back to an old database so it's nothing in the database (you are seeing *old* content when you look at the old database, right?). Like Joe says above, you could upload all the vb files again, but there doesn't seem to be any way that for that mod to modify files, so it almost certainly won't matter. Did you force a reload in your browser (it's browser depended and I don't remember how to do it - hold down shift or ctrl when reloading, or something like that). There's nothing left, unless you have some other kind of caching set up (but you'd probably know about it if you did, unless someone else set up the site for you).

ETA: you have multiple styles - is it possible you switched styles and one of the other ones looks different?

[MrHorror]

This stuff's complicated and nothing's impossible, so I won't say it's not a possibility. We just don't see what it could be. You went back to an old database so it's nothing in the database (you are seeing *old* content when you look at the old database, right?). Like Joe says above, you could upload all the vb files again, but there doesn't seem to be any way that for that mod to modify files, so it almost certainly won't matter. Did you force a reload in your browser (it's browser depended and I don't remember how to do it - hold down shift or ctrl when reloading, or something like that). There's nothing left, unless you have some other kind of caching set up (but you'd probably know about it if you did, unless someone else set up the site for you).

ETA: you have multiple styles - is it possible you switched styles and one of the other ones looks different?


I checked all the styles and in particular the vb default style, the hmands slasher, and our hmands 1st style look different.

--------------- Added 1335112138 at 1335112138 ---------------

I don't have any special program set up for caching. As for fixed width, what would I have to do to make the body of my forum smaller and more compact? I think this could be a margin issue. But I don't know much about margins for 3.6. I wanna make the body margins smaller. Not the page or anything else. But like as far as browser windows are concerned, I wanna compact the forum inward more from the left and right sides. I read something about doc_margins, but that's only for vb4 I gather? Also, is there a specific file or two that I could grab and upload from my vb3 folder into my forum folder to specifically restore the overall structure of the board in general? Without affecting the colors or anything else of styles?

[BirdOPrey5]

The values you are asking about can be accessed via Admin CP -> Style Manager -> [Choose Your Style] -> Choose "All Style Options" from the drop down menu, and scroll down to "Sizes and Dimensions"

Edit the values as you see fit.

But all these values are stored in the database and would have been reverted when you installed the old database.

[MrHorror]

Question. If I run the vbulletin install script and reinstall vbulletin from scratch, and then import my database into it. You think that would solve the problem?

[BirdOPrey5]

No it will not.