"Today in History" block

[clickbouyow]

Read the first post.  You have to import the sql into your database.

[greenman]

...I know. I did.

Like I said, I'm using the code outside of SMF & TinyPortal, so that's probably why I get the error.

[bloc]

Yes, that will cause trouble. You need then to supply host, user and pass for the sql server. SMF/TP already does that for you.

[greenman]

Ok.
Well I forgot my password for the user of the db, anyway to recover it?
In SMF I see the password but in * characters.

[bloc]

If you use the same db as your forum for this, check Settings.php in the forum folder. Its all there. Chances are you even use the same SQL user for other db's as well.

[greenman]

Got it working, thanks Bloc!


One other thing though, to me it shows the paragraph as 1 big sentence, no br's.
In the database it is just broken up in paragraphs without any html.


What I'm talking about:
(February 2nd, Today in History)

Text format in database:

1942 Quisling becomes prime minister of puppet regime in Norway

On this day, Vidkun Quisling, a collaborator with the German occupiers of Norway, is established as prime minister of a puppet government.

On April 9, 1940, German warships entered major Norwegian ports, from Narvik to Oslo, deployed thousands of German troops, and occupied Norway. German forces were able to slip through the mines Britain had laid around Norwegian ports because local garrisons were ordered to allow the Germans to land unopposed. The order came from a Norwegian commander, Vidkun Quisling, who was loyal to Norway's pro-fascist former foreign minister.

Hours after the invasion, the German minister in Oslo demanded Norway's surrender. The Norwegian government refused, and the Germans responded with a parachute invasion. In September 1940, "commissarial counselors" in the control of the Germans replaced Norway's administrative council. Chief of these "counselors" was Quisling, who was given dictatorial powers and who proceeded to earn the enmity of Norwegians as he sent thousands of people to German concentration camps and executed members of the resistance movement.

On February 1, 1942, the commissarial counselors formed a formal government loyal to Germany, with Quisling as its prime minister. When Germany finally surrendered in May 1945, Quisling was arrested by Norway's Allied liberators, tried for treason, and executed. His name continues to be a synonym for "traitor."

Displayed on webpage:

1942 - 1942 Quisling becomes prime minister of puppet regime in Norway On this day, Vidkun Quisling, a collaborator with the German occupiers of Norway, is established as prime minister of a puppet government. On April 9, 1940, German warships entered major Norwegian ports, from Narvik to Oslo, deployed thousands of German troops, and occupied Norway. German forces were able to slip through the mines Britain had laid around Norwegian ports because local garrisons were ordered to allow the Germans to land unopposed. The order came from a Norwegian commander, Vidkun Quisling, who was loyal to Norway's pro-fascist former foreign minister. Hours after the invasion, the German minister in Oslo demanded Norway's surrender. The Norwegian government refused, and the Germans responded with a parachute invasion. In September 1940, "commissarial counselors" in the control of the Germans replaced Norway's administrative council. Chief of these "counselors" was Quisling, who was given dictatorial powers and who proceeded to earn the enmity of Norwegians as he sent thousands of people to German concentration camps and executed members of the resistance movement. On February 1, 1942, the commissarial counselors formed a formal government loyal to Germany, with Quisling as its prime minister. When Germany finally surrendered in May 1945, Quisling was arrested by Norway's Allied liberators, tried for treason, and executed. His name continues to be a synonym for "traitor."

Anyway to fix that besides having to put br's in every single "pn_content" ?

[qayyom]

there is a problem with time zone detection.

my local time zone have +11 difference from my HOST Server.

is it possible that this function detect Local time zone ?

Because now 10:35AM / 03-03-2008 as Pakistan's Slandered Time, my history Block is still showing yesterdays events.

Please do something for me.

[IchBin]

Have you set your time preference in your profile?

[qayyom]

yes i set the time zone and it is as per local (Pakistan's Standard) Time zone.

mean Forum Default and my Own (User Profile) is same.

[IchBin]

I have no idea. Maybe it has something to do with the server time as well.