Here is a block that will show "today in history" - the sql data file kindly provided by clickbouyow.
Pretty straightforward - just insert the code into a phpblock and adjust accordingly:
$my_height = set this to number of lines before it will have a scrollbar..some texts are very long. :)
import the sql file in the attached zip-file to your database. If you do not, it will give an database error.
$my_height = 15;
$today = mktime();
$today_day = date("j", $today);
$today_month = date("n", $today);
$request = db_query("SELECT pn_yid, pn_content FROM nuke_ephem WHERE pn_did=$today_day AND pn_mid=$today_month ORDER BY pn_yid ASC", __FILE__, __LINE__);
if (mysql_num_rows($request) > 0)
{
echo '<div style="height: '.$my_height.'ex; overflow: auto;">';
while($row = mysql_fetch_assoc($request)){
echo '<b>' . $row['pn_yid'] . '</b> - ' . $row['pn_content'] . '<br />';
}
echo '</div>';
mysql_free_result($request);
}
[attachment deleted by admin]
Excellent! Thanks Bloc! Works like a charm!
nice block. you should enable it here. it would be a nice feature.
It would be interesting to see if it could be taken from something like http://en.wikipedia.org/wiki/October_29 instead of the database table (which wouldn't be updated).
It could be done if they had a xml feed, or rss/rdf.. ;)
Great block! thanks!
Thanks Bloc..
now may-be I can learn some history. ;)
crip~
This is a great block but can you add your own days in history to it? Or even delete certain ones? Some people might want to remember certain things while others might want to forget some...
Its all in the database tables..so you need to add or delete there. To administrate it through otherwise you would need a separate script.
If the table was expanded with an extra "on/off" field, you could even add/remove and turn off existing ones, either for all members or selected membergroups. ;)
Thanks, Bloc!
very nice, bloc :) i love it
Could someone try to explain to me :uglystupid2: ..exactly where and how to import this to DB?..I've tried importing this several times and I getting syntax errors because I do not know what I'm doing..and my Cpanel doesn't say much about import / export.
Thanks,
crip~
Use phpMyAdmin to import it. Have you used that before?
i had to do this just recently when i switched hosting. go to your cpanel and select mySQL databases. then at the bottom hit phpmyAdmin. from there it's rather simple, and there's a nice long post from grudge on how to do it here (http://www.simplemachines.org/community/index.php?topic=15252.0)
Simple machines sure is slow today, they running that site from a dialup connection?
I dont see any import anything in phpmyadmin, I do see export but that not gonna help I have done it once before but I cant remember where I did it at. It seems to my like once you go into myadmin it was at the top to import?
Oh well I will keep trying, I didnt read this part orginally hosed a whole install...I guess its important. internal server errors, no way to get back in.....:(
In phpMyAdmin, first select your database in the pop-up at the left-hand side of the window. Then, click the little 'SQL' tab at the top of the window. Underneath the SQL text field, there should be a table labeled 'Or, location of the text file'.
Click the 'Choose File' button, select the .sql file you downloaded in the first post, and then click 'Go'.
Voila! :)
This is a cool little block, but I'm having trouble with it 'underlapping' the block below it.
Attached is a screenshot of what I'm talking about... it could just be how Safari handles the css. An easy enough fix is just to make sure it's the last block on the sidebar, but I was hoping there was another way to fix it so I can keep it in it's current position.
this code...
echo '<div style="height: '.$my_height.'ex; overflow: auto;">';
while($row = mysql_fetch_assoc($request)){
echo '<b>' . $row['pn_yid'] . '</b> - ' . $row['pn_content'] . '<br />';
}
echo '</ul>';
mysql_free_result($request);
..actually had an error in there. I have changed the post now, so it says:
echo '<div style="height: '.$my_height.'ex; overflow: auto;">';
while($row = mysql_fetch_assoc($request)){
echo '<b>' . $row['pn_yid'] . '</b> - ' . $row['pn_content'] . '<br />';
}
mysql_free_result($request);
Does that solve the problem?
Unfortunately, no. :(
It's probably a Safari bug... the rest of the blocks work fine...
However, I was able to echo in some table settings for the block
echo '<table width="100%" border="0"><tr><td>';
//the block code//
echo '</td></tr></table>';
And now it works fine in any position... thanks for looking into it though, I appreciate it.
Must be the div that confuse Safari. When in doubt, use a table... :)
I've had the same problem with it messing up the block under it, but in IE6. Adding the table thing worked for me, too though
So it's not just safari
Same ERROR everytime I run it.
MySQL said:ÂÃ,Â
#1064 - You have an error in your SQL syntax.ÂÃ, Check the manual that corresponds to your MySQL server version for the right syntax to use near 'PK' at line 1
Did you import the sql file into the database?
Yes, but I get that same error everytime?..
It also tells me on the Forum that no table was found for it...
maybe the table didn't upload correct. Its a big table. Have you tried to repair the nuke... table?
I didn't see that repair option with in the error page .. we have the same Host.. AH..you probably no more about that cool Cpanel than myself. :) ...
I will try again though thank you Bloc.
I am not sure how well you know cpanel..but if you click on Mysql icon in cpanel, then scroll down to "phpMyadmin" - a small link at the bottom - you can check the tables. First off is to see you actually have a table named "nuke_ephemerid" - and second: mark it and choose at the bottom "repair table".
Same host..you use artichost ? :)
Quote from: Bloc on October 29, 2005, 08:52:09 AM
It could be done if they had a xml feed, or rss/rdf.. ;)
I came across this on the BBC website (http://news.bbc.co.uk/onthisday/bsp/rss.stm?rss=http://news.bbc.co.uk/rss/on_this_day/front_page/rss091.xml) Do other news channels etc do similar?
Quote from: nokonium on November 05, 2005, 06:35:59 PM
Quote from: Bloc on October 29, 2005, 08:52:09 AM
It could be done if they had a xml feed, or rss/rdf.. ;)
I came across this on the BBC website (http://news.bbc.co.uk/onthisday/bsp/rss.stm?rss=http://news.bbc.co.uk/rss/on_this_day/front_page/rss091.xml) Do other news channels etc do similar?
That works great thanks alot.
Yes, works fine it seem. Thanks for the link, nokonium.
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fwww.nokonium.plus.com%2Fblack-cat%2Fgreetings%2FWoot.gif&hash=939aad5561914e0b24f8df13e763e73e914e81b0) (https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fwww.nokonium.plus.com%2Fblack-cat%2Fgreetings%2FWoot.gif&hash=939aad5561914e0b24f8df13e763e73e914e81b0) (https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fwww.nokonium.plus.com%2Fblack-cat%2Fgreetings%2FWoot.gif&hash=939aad5561914e0b24f8df13e763e73e914e81b0)
Doesn't it just ;D
Looks great ... here's another good looking RSS block. 8)
http://www.tinyportal.net/smf/index.php?type=rss;action=.xml;
If there was a way to pull in a site's own RSS from a specific board only and make it look this good - that would be awesome ... I think this box looks better than the "Recent Topics" SSI box.
yeah, it did in fact.. :)
I will look into it. The xml option of SMF is a part all to itself, not "outside" like SSI.php is. But it should be possible to make "recent topics/posts" act like this. :) Then let the ssi function just do what it already does. As of now, TP's "recent topics" block and the ssi-type block do the same thing really..just slightly different presented.
I found this on the History Channel...This Day in History.
Updated each day.. Here (http://www.historychannel.com/tdih/tdih.jsp?category=leadstory)
crip~
Should this work with 1.0.5 too ?
Shouldn't matter with SMF version. TP is what handles it.
Yeepeee, ;D ;D
I finally got this to work by unzipping the file first, couldn't run it zipped, kept getting Syntax errors? She's goin now though..does this change each day?.. weekly..monthly..et-ceteras??
Thanks,
crip~
Each day I assume.. ;) "today in history"...
Exactly.. I'm a bit :uglystupid2: .. it does change daily..
thanks - ;)
Love this.
Couple of questions and maybe errors. Mine just looks like a big log of information. The dates are not separated nor in bold font.
Also, is there a way to change the font size?
Thanks Bloc worked like a charm I am a big fan of history so I will enjoy this!
Nice block - this one.... i just started using it on one of my new site... i use the Alienation Theme.. which is real cool.. :up: but this block breaks the page.. i mean the width.. we have inserted some code similar to the height code but it gives a scrollbar on the bottom and it looks weird... am using the bbc block now with javascript... it wud be better if we could use the sql table imported.... :(
www.mediaplus.in
It is probably because of punctuation in the datafile. If you scroll down you will find the sentence that is causing it. I just went into phpmyadmin and edited that story and it was fine.
Quote from: graffixjones on October 31, 2005, 06:52:47 PM
Unfortunately, no. :(
It's probably a Safari bug... the rest of the blocks work fine...
However, I was able to echo in some table settings for the block
echo '<table width="100%" border="0"><tr><td>';
//the block code//
echo '</td></tr></table>';
And now it works fine in any position... thanks for looking into it though, I appreciate it.
so now, on what line should i insert this code? it's still overlapping on my other blocks.
:)
Quote from: Bloc on October 29, 2005, 01:25:30 AM
import the sql file in the attached zip-file to your database. If you do not, it will give an database error.
Umm... what attached zip-file? ???
I am afraid the server move last year led to a number of attachments were lost. So until that zip is recovered again, I can't re-attach it.
oh. :(
well, can you upload it somewhere else and link to it please? :)
I just said I can't re-attach it. If I had it I would.
Here ya go:
http://www.deadboneplatoon.com/misc/nuke_ephem.zip
thanks, clickbouyow. :)
I attached to first post as well.
thanks. :)
I'm using this code outside of my SMF, in a custom php page, and I get the "No database selected" error.
How can I "select the database"?
sorry for my newbiness.
Do I need to have a password to select the db? Because I already forgot the user password.. :(
Read the first post. You have to import the sql into your database.
...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.
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.
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.
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. :)
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:Quote1942 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:Quote1942 - 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" ?
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.
Have you set your time preference in your profile?
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.
I have no idea. Maybe it has something to do with the server time as well.
I have the same problem.
Is there any way to fix this?
Add a temporary line to figure out how much the time is off from what you want. After
$today = mktime();
add
echo 'The time is now ' . date('G:i on j M Y') . '<br />';
Save the block and then go look at it. It should give you a time and date. Figure out the difference between the time displayed and the time you want, in hours. Decide whether you want to add or subtract time. (If you want the time to be later, add. If you want it to be earlier, subtract).
Now go back to your code and delete the line you just added. Change the line
$today = mktime();
to
$alter = 3; // the number of hours you want to adjust the time by. If you want an earlier time, use a negative number
$today = mktime() + (3600 * $alter);
Thank you, JPDeni.
That works perfectly.
hmm i miss "total posts today" can anyone write 4 me or add 2 this ??
Quote from: whitesox on May 13, 2009, 09:22:26 PM
hmm i miss "total posts today" can anyone write 4 me or add 2 this ??
Whitesox, please don't cross post, or double post.
I've already answered you in your other topic and hopefully one of our code specialists will take a look at your request later today or tomorrow.
sry ??? ::)