View Single Post
  #3  
Old 06-12-2005, 10:21 PM
VRole VRole is offline
Member
 
Join Date: Jun 2005
Posts: 44 | Points: 10
VRole is on a distinguished road
Default

installing
This action is, again, always used with the "FIND" action Wink

Quote:
#

#
#-----[ IN LINE FIND ]------------------------------------------
#
t.topic_title,


Like it's a little hard to understand like this, i give you a example Wink

Example :

Quote:
#

#
#-----[ FIND ]------------------------------------------
#
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';
#
#-----[ IN LINE FIND ]------------------------------------------
#
t.topic_title,


You have just to search for " t.topic_title, " and to prepare you for the action which will arrive Wink


8 ) The "IN LINE AFTER ADD" action :

Looks like this :
Quote:
#

#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
t.topic_desc,


In fact, it's a better way to use the "REMPLACE" action (in the case that you have others MOD's installed)
This action is used with the "FIND" action and the "IN LINE FIND" action.

Example :

Quote:
#

#
#-----[ FIND ]------------------------------------------
#
$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';
#
#-----[ IN LINE FIND ]------------------------------------------
#
t.topic_title,
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
t.topic_desc,


Here, you have to search for an entire line (original line) :
Quote:
#

$select_sql = ( !$submit ) ? ", t.topic_title, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';


in this line, you have to search something :
Quote:
#

t.topic_title,


and to add that, directly after :
Quote:
#
t.topic_desc,


so your line will become (modded line) :
Quote:
#

$select_sql = ( !$submit ) ? ", t.topic_title, t.topic_desc, p.enable_bbcode, p.enable_html, p.enable_smilies, p.enable_sig, p.post_username, pt.post_subject, pt.post_text, pt.bbcode_uid, u.username, u.user_id, u.user_sig" : '';



9) The "IN LINE BEFORE ADD" action :

It's the same thing that the "IN LINE AFTER ADD" action but you have just to add the code before what you have to search instead of after.
Quote:
#

#
#-----[ IN LINE BEFORE, ADD ]------------------------------------------
#
, $topic_desc


Example :
Quote:
#

#
#-----[ FIND ]------------------------------------------
#
prepare_post($mode, $post_data, $bbcode_on, $html_on, $smilies_on, $error_msg, $username, $bbcode_uid, $subject, $message, $poll_title, $poll_options, $poll_length);
#
#-----[ IN LINE FIND ]------------------------------------------
#
$poll_length)
#
#-----[ IN LINE BEFORE, ADD ]------------------------------------------
#
$topic_desc,


You have to search for an entire line (original line) :
Quote:
#

prepare_post($mode, $post_data, $bbcode_on, $html_on, $smilies_on, $error_msg, $username, $bbcode_uid, $subject, $message, $poll_title, $poll_options, $poll_length);


in this line, you have to search :
Quote:
#

$poll_length)


and to add that, directly before :
Quote:
#

$topic_desc,


so your line will become (modded line) :
Quote:
#

prepare_post($mode, $post_data, $bbcode_on, $html_on, $smilies_on, $error_msg, $username, $bbcode_uid, $subject, $message, $poll_title, $poll_options, $topic_desc, $poll_length);


10 ) The "SQL" action :

This is the action to do for altering the database(adding a fiels, a table,...).


Quote:
#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_topics ADD topic_desc varchar(255) DEFAULT '' AFTER topic_title


The best way for you to do this action is to use a basic management tool of database via Internet, like phpMyadmin

Once you have installed phpMyadmin, it's simple :

go into it, clic on the name of your database on the left. On the right, you will see a blank textarea : copy and paste the SQL query to do into this area, then clic on "Execute" and see the result Wink


11) The "SAVE/CLOSE ALL FILES" action :

This is the last action Very Happy. Once you have done all your modifications, save and close your files, thn upload tem onto your ftp server and go in your forum : see the result of your job Wink




But don't forget : before all, backup your files and your database.



I hope this tutorial will help you get Very Happy


If you have any suggestions/request/problems with this tutorial, this topic is for you. You can also PM me. Make sure the subject is this topics subbject so i know what to expect.
Reply With Quote