Last threads on irc

[GunVorKinG]

For the life of me i can't figure out what is wrong with this.
The idea is that i want when somebody on IRC do !posts they get back 5 of the last threads that were posted on the forum.
It seems everything works fine exept it doesnt show me the threads. It's just blank.
Here is a .img:


The .tcl file looks like this:

You must first be a registered member to view any code.

The php file looks like this:

You must first be a registered member to view any code.

I should tell you that i used a hack by matiske as ground, think it was last releases on irc or something.

If anyone could help me with this id be very happy.

I would suggest you to make the .php file atleast part of vbulletin with it's db fucntions. That would be nicer.

[Idan]

do few simple debug steps that will allow you to locate this one:
1. load the php file into browser's url line & check the output is indeed there & that there isn't any mysql query error, db connect error, or might even return blank page at all. in any situtation that match one of the things i've mentioned try to check your query directly with phpmyadmin or similar...
2. though i guess if there was any problem, it were on php side, if all is ok, dcc your eggdrop & look for any errors might shown upon bind, check .binds to see it's there & triggered. sometimes using stuff like blowfish could avoid it being triggered, etc.

anyway, that should do the trick, as the tcl looks ok @ first glace.
hope this helps.

[GunVorKinG]

Originally Posted by MadDog

do few simple debug steps that will allow you to locate this one:
1. load the php file into browser's url line & check the output is indeed there & that there isn't any mysql query error, db connect error, or might even return blank page at all. in any situtation that match one of the things i've mentioned try to check your query directly with phpmyadmin or similar...
2. though i guess if there was any problem, it were on php side, if all is ok, dcc your eggdrop & look for any errors might shown upon bind, check .binds to see it's there & triggered. sometimes using stuff like blowfish could avoid it being triggered, etc.

anyway, that should do the trick, as the tcl looks ok @ first glace.
hope this helps.

Thanks for the comprohensive answer.

Indeed you were right, I loaded the php file in to my browser and all it showed was a blank page. When I tried the query in phpmyadmin it got back error 1064.
So its established that it is the php file that is the error for this modification.

Gonna look into this more tomorrow, if you got any suggestions, feel free to post them

[GunVorKinG]

Okey, i changed the query some and now it gets 5 threads in the db. This is when i run the query in the phpmyadmin. Weird part is it doesnt show the last threads, shows very old threads lol. This is the query i ran:

You must first be a registered member to view any code.

And the web browser shows blank still. The whole php now looks like this instead:

You must first be a registered member to view any code.

EDIT:
Changed the query again, and got the right threads

You must first be a registered member to view any code.

Now i just gotta get the info to be fetch from the db with that php file.

[Idan]

try maybe instead of "mysql_fetch_object" to use "mysql_fetch_array" & output data with lastpost["lastpost"].
worth a try ;)

EDIT: if php now works (not return blank) plz. ignore this reply, cause this reply was made before i saw your reply. (look @ next reply)

[Idan]

to get last thread don't sort by title.
try to sort by "threadid" maybe or post date.

You must first be a registered member to view any code.

EDIT: looking now @ your fixed php file.
now you don't have any while loop inside code, so it will output only 1 result.
and there isn't any connection between var $query to $thread
so add while like before, or if u don't want any & want just 1 result use this:

You must first be a registered member to view any code.

[GunVorKinG]

Originally Posted by MadDog

to get last thread don't sort by title.
try to sort by "threadid" maybe or post date.

You must first be a registered member to view any code.

EDIT: looking now @ your fixed php file.
now you don't have any while loop inside code, so it will output only 1 result.
and there isn't any connection between var $query to $thread
so add while like before, or if u don't want any & want just 1 result use this:

You must first be a registered member to view any code.

Okey, i changed to that code snippet instead, the page is still blank.
In the phpmyadmin its shows all good. Will look into this further

[Idan]

you still use mysql_fetch_object or changed that to mysql_fetch_array ??

please repost your current php, i'll try to look @ it again & help you with that one tonight when i'm back from university (in case it won't be solved by then)

[GunVorKinG]

Okey, fixed the php file. It fetches the info from the db and it showes in the browser.
Seems the .tcl file isnt correct for the moment.
Will check.

EDIT:
Wiie! Now it works :p
Thanks for all the help MadDog, I really appreciate it.

For the ones who want this, heres the complete modification:

.tcl file:

You must first be a registered member to view any code.

the php file:

You must first be a registered member to view any code.

Should maybe add that this is for vb 3.0.9