Generating SQL for smilies witowt stress

[CreativityKills]

I was working on d version 3.0 of my script and i had to make sql for about 200 gifs n jpgs bt u didnt really fink i'd do it one by one did u? O.o Okay i used to, anyway wit dis piece of codin u cud generate SQL dependin on ur smilies folder:

<?php
$han = dir("/");
while($fnm = $han->read()){
$file = explode(".",$fnm);
if(strlen($file[0])>2 && count($file)==2){
echo "INSERT INTO `ibwf_smilies` (`id`,`scode`,`imgsrc`,`hidden`)\n";
echo "VALUES (NULL,'-".$file[0]."-', 'smilies/".$fnm."','0');\n";
}
}
?>

ofcuz u can modify it easily. And oh make sure u rename ur files cuz d code for a haha.gif file would be -haha- and d code for a haha_01.gif wud be -haha_01- . To c d sql, view just view d source code of d display. It'l be ther. If u found dis useful, hola atchur boi. :-)

[CreativityKills]

oh, put dat file in ur smiles folder and run it.

[something else]

you might want to conect to db aswell
or in most peoples cases:
include("../web/config.php");
include("../web/core.php");

[CreativityKills]

nah u dnt need database. It just generates the sql query for files in the smilies folder. You just copy d sql code and paste in phpmyadmin.

[something else]

i didnt read your post properly lol*
but u might aswell have it directly insert straight into db

[WhiteWarrior]

this is pobably the most usful piece of coding ive seen on this whole forum since ive been here, simple, easy, something i wouldnt had fort of. lol.

[CreativityKills]

Thanks. Oh btw, found a "bug". Add this 2 d code

change
if( strlen($file[0])>2 && count($file)==2 ){

TO
if( strlen($file[0])>2 && count($file)==2 && $file[2]!="php"){

REASON?
So it doest pick up ur index.php file as well.

[something else]

yeah nice script btw

[jedskiter]

what o you mean by run it. how? sorry newbie

[makvanpor2000]

am not getin the sql script oh

[metulj]

am not getin the sql script oh

can you read ???