Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - The Sailor

Pages: 1 [2] 3 4 5 6
16
Hi all,

i used a New Registered User mod by V@no. in include/state.php here is the code:

Code: [Select]
//-----------------------------------------------------
//--- New Member --------------------------------------
//-----------------------------------------------------
$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE ".get_user_table_field("", "user_id")." <> ".GUEST."
        ORDER by ".get_user_table_field("", "user_joindate")." DESC";
$row = $site_db->query_firstrow($sql);

$new_member = "Welcome to our new registered user, ".(($row[$user_table_fields['user_id']]) ? " <a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row[$user_table_fields['user_id']])."\"><B>".$row[$user_table_fields['user_name']]."</B></a>\n" : "<B>".$row[$user_table_fields['user_name']]."</B>");
$site_template->register_vars("new_member", $new_member);
unset($new_member);

and i use {new_member} in home.html, it show's the new registered member just fine but how can i make it show his Avatar to in same time???? :oops: please :oops:
can anyone modify it?

by the way i think this code can help but i don't no how to use it:
Code: [Select]
$user_avatar = (!$user_row['user_avatar'] || $user_row['user_avatar'] == "blank.gif") ? "" : "<img src=\"".TEMPLATE_PATH."/avatars/".$user_row['user_avatar']."\">";

17
Mods & Plugins (Releases & Support) / Re: [Mod] Avatar v2.01
« on: August 12, 2007, 02:29:54 PM »
i used a New Registered User mod from state.php here is the code:

Code: [Select]
//-----------------------------------------------------
//--- New Member --------------------------------------
//-----------------------------------------------------
$sql = "SELECT *
        FROM ".USERS_TABLE."
        WHERE ".get_user_table_field("", "user_id")." <> ".GUEST."
        ORDER by ".get_user_table_field("", "user_joindate")." DESC";
$row = $site_db->query_firstrow($sql);

$new_member = "Welcome to our new registered user, ".(($row[$user_table_fields['user_id']]) ? " <a href=\"".$site_sess->url(ROOT_PATH."member.php?action=showprofile&user_id=".$row[$user_table_fields['user_id']])."\"><B>".$row[$user_table_fields['user_name']]."</B></a>\n" : "<B>".$row[$user_table_fields['user_name']]."</B>");
$site_template->register_vars("new_member", $new_member);
unset($new_member);

and i use {new_member} it show the new registered member just fine but how can i show his Avatar ???? :oops:

18
Thanks mawenzi,

maybe i can add new fields or some add mods to my script, but i don't no how to create them, can you help me please with that if its that simple please (^_^)

19
is there a story mod here pleasssssse  :oops:

20
k sajalelenyu ya do six por PMS ne nashel kto-to smojit nam naidet pojalyusta!

21
i think the installer in PM V2 in just for those who have installed the old PMS verion! its mean that we have to the old installer then upgrade it with new PM V2 installer isn't it?

22
any idea for sql?

23
the install problem its solved ;)

upload and execute this install (attached here)  :mrgreen:


Parse error: parse error, expecting `')'' in c:\apache\htdocs\gallery\install.php on line 10



24
SQL-query : 

"CREATE TABLE `".4IMAGES_PM."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_increment, `pm_type` tinyint(2) NOT NULL default '0', `pm_to` mediumint( NOT NULL default '0', `pm_from` mediumint( NOT NULL default '0', `pm_subject` varchar(255) NOT NULL default '', `pm_text` text, `pm_date` int(11) NOT NULL default '0', `pm_date_rcvd` int(11) NOT NULL default '0', `pm_ip` varchar(20) NOT NULL default '0', `pm_html` tinyint(1) NOT NULL default '0', `pm_bbcode` tinyint(1) NOT NULL default '0', `pm_smiles` tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM",
            "ALTER TABLE `".USERS_TABLE."` ADD `user_pm_inbox` int(11) NOT NULL default '0', ADD `user_pm_sentbox` int(11) NOT NULL default '0', ADD `user_pm_email` tinyint(1) NOT NULL default '1', ADD `user_pm_popup` tinyint(1) NOT NULL default '0'",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_inbox', '30')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_sentbox', '10')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_html', '0')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_bbcode', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_img', '1')"

MySQL said:


You have an error in your SQL syntax near '"CREATE TABLE `".4IMAGES_PM."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_in' at line 1


25
Quote
".PM_TABLE."

On paragraf, change this to real table PMS name. Next, execute same paragraf in phpmyadmin (PHP execute). ;)


Really i didnt uderstand u, did you mean i have to change to PMS but is a old verion!!!

26
Not sure of prob ... SQL query in pm_install.php file ...

Quote
"CREATE TABLE `".PM_TABLE."` ( `pm_id` mediumint(10) unsigned NOT NULL auto_increment, `pm_type` tinyint(2) NOT NULL default '0', `pm_to` mediumint(8) NOT NULL default '0', `pm_from` mediumint(8) NOT NULL default '0', `pm_subject` varchar(255) NOT NULL default '', `pm_text` text, `pm_date` int(11) NOT NULL default '0', `pm_date_rcvd` int(11) NOT NULL default '0', `pm_ip` varchar(20) NOT NULL default '0', `pm_html` tinyint(1) NOT NULL default '0', `pm_bbcode` tinyint(1) NOT NULL default '0', `pm_smiles` tinyint(1) NOT NULL default '0', KEY `pm_id` (`pm_id`,`pm_to`,`pm_from`)) TYPE=MyISAM",
            "ALTER TABLE `".USERS_TABLE."` ADD `user_pm_inbox` int(11) NOT NULL default '0', ADD `user_pm_sentbox` int(11) NOT NULL default '0', ADD `user_pm_email` tinyint(1) NOT NULL default '1', ADD `user_pm_popup` tinyint(1) NOT NULL default '0'",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_inbox', '30')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_sentbox', '10')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_html', '0')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_bbcode', '1')",
            "INSERT INTO `".SETTINGS_TABLE."` ( `setting_name` , `setting_value` ) VALUES ('pm_img', '1')"

Note: 8) = 8 ) (no space)

can you save it from PHPMYADMIN as SQL file please, theres some errors here  :oops:

27
Quote
Sorry, can not continue, you missed some steps of the installation..

on 4images 1.7.4

can anyone give me the PM tables SQL file or how can i add tables manualy????????????!!!!!!!

28
Mods & Plugins (Releases & Support) / Re: [Mod] Avatar v2.01
« on: August 03, 2007, 02:19:28 PM »
Quote
Undefined index: user_avatar in /home/localhost/public_html/gallery/includes/page_header.php on line 149

user_avatar field in USERS_TABLE and db_field_definitions.php file ?

i don't do anything but seem that it work well now (^_^) thats strange

29
Mods & Plugins (Releases & Support) / Re: [Mod] Avatar v2.01
« on: August 03, 2007, 01:01:22 AM »
i have problem !!!!!!!!!!!!!  :!: :!: :!:

when non users  inter the Advanced search theres an error:

Code: [Select]
Notice: Undefined index: user_avatar in /home/localhost/public_html/gallery/includes/page_header.php on line 149

here the code in page_header.php

Code: [Select]
  "user_avatar_current" => ($config['avatar_use']) ? "<img src=\"".TEMPLATE_PATH."/avatars/".(($user_info['user_avatar'] == "") ? "blank.gif" : $user_info['user_avatar'])."\" border=\"0\" alt=\"\">" : "",
how can i fix it?????


30
 Thnks Mr. thunderstrike,

its a great mod :D

it work well!

if you want more ideas i will give u soon just wait i want to shake my head ;-)

Pages: 1 [2] 3 4 5 6