 |
| Register | Login | |||||
 |
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
|
| | ||
|
| Register | Login | |||||
|
Main
| Memberlist
| Active users
| ACS
| Commons
| Calendar
| Online users Ranks | FAQ | Color Chart | Photo album | IRC Chat |
|
| | ||
| Acmlm's Board - I2 Archive - - Posts by Modereb |
| Pages: 1 2 3 4 |
| User | Post | ||||||||||||||||||||||||||
Modereb Paragoomba Level: 15 Posts: 41/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| PHP (pretty much everything, but I specialize mostly in database related scripts) XML Visal Basic 6.0 [limited; but you can ask me anything about communication between Visual Basic apps and Access, MySQL and MsSQL databases] VBScript Javascript SQL |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 42/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| You can't with just HTML, you either have to use Javascript, or a server side language such as ASP or PHP. Examples that will output image0.jpg, image1.jpg or image2.jpg... Javascript: document.write('<img src="image'+Math.floor(Math.random()*3)+'.jpg" alt="image" />'); PHP: <? echo "<img src=\"image".rand(0,2).".jpg\" alt=\"image\" />"; ?> ASP <% randomize randnumber=int(rnd*2)+0 response.write randnumber %> (edited by Modereb on 09-21-04 02:07 AM) |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 43/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| I've toyed around with it a few times, and I like it. Definately something I'll be using in a website in the future, combined with PHP and (My)SQL. | |||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 44/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| I've been working with PHP and (My)SQL for years now, and I can put together pretty much any type of PHP website with a SQL database 'fuelling' the content. I've been trying out XML for a while now as well. Though I still prefer working with a server side language, the major disadvantage is that you don't always have the opportunity to use it. After all, you do need support for it and you need a database. The thing I like about XML is that I can use it anywhere, and of course because of the fact that it's more 'universal', though I'm not quite aware of its full potential yet. As for my question... Let's say I have a website where I can post news articles. I'd easily put it together with PHP and MySQL, and the database structure would look like this:
I'd have an index page listing all the subjects of the news records found in the database, and when you'd click one, you'd be redirected to, for example, readnews.php?News_ID=xxxx would be the News_ID number of the concerning article, and the content of it is displayed. Now, for the question. Is this possible with XML? Let's say I have an XML file with the following content: <?xml version="1.0" encoding="ISO-8859-1"?> <news> <article> <News_ID>1</News_ID> <Poster_ID>Modered</Poster_ID> <Subject>About Pie</Subject> <Content>Pie is good! :-D</Content> </article> <article> <News_ID>2</News_ID> <Poster_ID>Modered</Poster_ID> <Subject>Monsters</Subject> <Content>Monsters are scary :-(</Content> </article> <article> <News_ID>3</News_ID> <Poster_ID>Modered</Poster_ID> <Subject>Random</Subject> <Content>I feel like an idiot :*)</Content> </article> </news> I already know how to make a page listing all the news records' Subject, using XSL. However, I do not know if it's possible with XML to create something as I did with PHP/MySQL above. Going to an address such as readnews.xml?News_ID=xx where the content of News_ID xx (where xx is, once again, the News_ID number of the concerning news message). So, is this possible? If so, how? Thanks in advance! (edited by Modereb on 09-23-04 07:18 AM) |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 45/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| RSS is like RSI, only worse. | |||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 46/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| If you put this in a HTML file: <script type="text/javascript"> document.write('<img src="random_image'+Math.floor(Math.random()*3)+'.jpg" alt="image" />'); </script> Either <img src="random_image0.jpg" alt="image" />, <img src="random_image1.jpg" alt="image" /> or <img src="random_image2.jpg" alt="image" /> is outputted by the Javascript. So, basically, just paste that code anywhere where you want to have the random image in your HTML file, and make sure the images random_image0.jpg, random_image1.jpg and random_image2.jpg are there.  |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 47/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| Why is everyone whining about the noise it makes and not wanting to be reachable 24 hours? EVERY cell phone has sound options, or a silent/mute mode, plus you can very simply turn it off if you don't want to be called. And suprisingly funny, I see it very frequently that people are against things such as camera phones, but as soon as they get their hands on one or get to play with someone else's camera phone, they suddenly like it. |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 48/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| http://www.cymoro.com/abhacks/abinstall.php | |||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 49/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| I hate the Jamba commercials, especially the one with the Orgasm sound in it. My parents think I'm watching porn sometimes whenever that stupid commercial is on TV. | |||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 50/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| There was a search feature before, but this board had a 700+ MB post database, and basically performing a search had to look all over that 700+ MB of data, which screwed the MySQL database pretty roughly. However, I do think there should be a user search and thread search feature, work like a charm on my board. |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 51/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
Originally posted by _SW_SquallThen you set wrong MySQL data in config.php. I see you set 'www.thewall.ws' as $sqlhost. If you're installing the board on a server which has the concerning MySQL database of it's own, $sqlhost needs to be localhost or 127.0.0.1. |
|||||||||||||||||||||||||||
|
Modereb Paragoomba Level: 15 Posts: 52/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days |
| ||||||||||||||||||||||||||
| I prefer PHP and MySQL for sollutions like this as well, but like I said, I don't always have the opportunity to use those. Also, I'm aware of the slowdown, though it won't matter for something like this; adding a short article about once in 2 weeks. It won't be a stuffed 'database' at all. |
|||||||||||||||||||||||||||
(restricted)| (restricted) | (restricted) |
Modereb |
Paragoomba Level: 15 Posts: 56/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days
|
Actually... |
if you use $variable in a PHP script, that variable can be declared through the url (IE script.php?variable=bla), through posting a form, etcetera. $_GET['variable'] means $variable can only be declared through the url, and $_POST['variable'] only through submitting a form. So let's take this board register page, it's important to have if($_POST['action']=='register'){ instead of just if($action=='register'){ so registering will only occur if it is done through this board's form, if not, you could keep registering accounts with an url like register.php?action=register&username=malicious_person. So it's definately more secure. (edited by Modereb on 09-28-04 01:58 AM) (restricted) |
Modereb |
Paragoomba Level: 15 Posts: 58/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days
|
Everyone's sick here as well, I had my turn last week. |
Horrible throat-ache for 3 days, I could only drink milk for some reason, the rest (food and drinks) all hurt, even just water. Then my stephmom told me I should drink milk with honey, so I did, even though it was incredibly gross, but my throat-ache was gone after a few minutes.
Modereb |
Paragoomba Level: 15 Posts: 59/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days
|
I wouldn't mind 90 KB... |
...for a decent, original and/or creative layout. But hyperhacker, to be blunt, I find your layout far from worth the 90> KB it currently is. It looks unsorted, cluttered, those links and post stats are terribly useless because the links can already be found everywhere on the board, and the stats are right next to your post. But worst of all, the big anime image. Really, in every thread you post in I have to see that same anime image. On top of that, I've seen that very same image on a ton of other websites already. Please, no.
Modereb |
Paragoomba Level: 15 Posts: 60/75 EXP: 14749 For next: 1635 Since: 06-04-04 Since last post: 350 days Last activity: 339 days
|
Originally posted by Black LordThat's how newbies unaware of resource and database usage do it. (edited by Modereb on 10-04-04 07:10 AM) | |||||||||||||
| Pages: 1 2 3 4 |
| Acmlm's Board - I2 Archive - - Posts by Modereb |
