Chatter of the day

[something else]

Sql

INSERT INTO `ibwf_settings` ( `id` , `name` , `value` )
VALUES (
NULL , 'pod', '1'
); 

script

$pod = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='pod'"));
echo "<small>Random Gallery Pics</small><br/>";
$sql=mysql_fetch_array(mysql_query("SELECT id, avatar FROM ibwf_users WHERE id='".$pod[0]."'"));
$nick = getnick_uid($sql[0]);
echo "<small><img src=\"$sql[1]\" width=\"100\" height=\"100\" alt=\"$sql[0]\"/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$nick</a></small><br/><br/><br/>"; 

then u will have to update pod in ibwf_settings when you want to adjust the user id

[Leviathan73]

This SQL where to put? here?

CREATE TABLE `ibwf_settings` (
  `id` int(10) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `value` text NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;--
-- Dumping data for table `ibwf_settings` 

and how?

[something else]

run this in your database:

[COLOR=#000000][COLOR=#0000BB]INSERT INTO [/COLOR][COLOR=#007700]`[/COLOR][COLOR=#0000BB]ibwf_settings[/COLOR][COLOR=#007700]` ( `[/COLOR][COLOR=#0000BB]id[/COLOR][COLOR=#007700]` , `[/COLOR][COLOR=#0000BB]name[/COLOR][COLOR=#007700]` , `[/COLOR][COLOR=#0000BB]value[/COLOR][COLOR=#007700]` )
[/COLOR][COLOR=#0000BB]VALUES [/COLOR][COLOR=#007700](
[/COLOR][COLOR=#0000BB]NULL [/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]'pod'[/COLOR][COLOR=#007700], [/COLOR][COLOR=#DD0000]'1'
[/COLOR][COLOR=#007700]); [/COLOR][/COLOR]

[Leviathan73]

I am in my database, I must add a new row, or what?

[something else]

yeah add a new row in ibwf_settings name= pod and value = 1

[Leviathan73]

Something .. YEAHHH!! thanks it works! :p
one last thing, I wish you could see your username by clicking the profile, but me you're not logged in or your session has expired
is sid

[something else]

Does your site use sid ? or does it use ses ? or something else?

[something else]

for some reason $sid in being canceled out or not collecting properly
try putting
$sid = $_GET["sid"];
above the code

[Leviathan73]

put on the code that you gave me, but you can not see profile

[something else]

i cant see anything wrong with the code iv posted so im guessing its a problem on the page your putting it on

[Leviathan73]

help some, the picture has not changed at midnight, is the same as yesterday

[something else]

sql

INSERT INTO `ibwf_settings` ( `id` , `name` , `value` )
VALUES (
NULL , 'doc', '1'
); 

script:

$check = mysql_fetch_array(mysql_query("SELECT value FROM ibwf_settings WHERE name='doc'"));
$date = "".date("d")."";
if($check[0]!=$date){
$user = mysql_fetch_array(mysql_query("SELECT id FROM ibwf_users ORDER BY RAND()  LIMIT 1"));
mysql_query("UPDATE ibwf_settings SET value='".$date."' WHERE name='doc'");
mysql_query("UPDATE ibwf_settings SET value='".$user[0]."' WHERE name='pod'");
} 

[Leviathan73]

I removed the code, and replace all the code with the copy paste, modify SQL, but do not see anything