(Created page with "This template should be used for pages describing $smcFunc functions. The parameters are: {{parmdesc |function|d1=the name of the function described |usage|d2=how the functi...") |
No edit summary |
||
Line 1: | Line 1: | ||
This template should be used for pages describing [[$smcFunc]] functions. | This template should be used for pages describing [[$smcFunc]] functions. | ||
Available parameters: | |||
{{parmdesc | {{parmdesc | ||
|function|d1=the name of the function | |function|d1=the name of the function (e.g. ''db_query'') | ||
|usage|d2=how the function is called with all the parameters | |usage|d2=how the function is called with all the parameters available | ||
|description|d3=a | |description|d3=a description of what the function does and how it works | ||
|parameters|d4=a | |parameters|d4=a {{tl|parmdesc}} list of the parameters the function accepts and relative description | ||
|example| | |return|d5=what the function returns | ||
|notes|d6=additional notes if needed | |||
|example|d7=an example of how the function must be used, please use the <nowiki> and </nowiki> tag to surround the code block as described in the {{tl|code}} template documentation | |||
|return|d6=short description of what the function returns if anything is returned | |return|d6=short description of what the function returns if anything is returned | ||
|additional fields|d8=tree additional fields where is possible to specify the name of the parameter and its content, to be used like in {{tl|parmdesc}}: <code><nowiki>|name of the field|d1=description of the field</nowiki></code> | |||
}} | |||
<pre><nowiki> | |||
{{smcfunc | |||
|function=db_query | |||
|usage=$smcFunc['db_query'](identifier, query, values, connection) | |||
|description=Works similar to how db_query worked in 1.x versions. | |||
|parameters={{parmdesc | |||
|identifier|d1=is used to identify specific query types in which it is necessary to replace portions of the query for compatability across all Database Management Systems supported by SMF. The query must be written for MYSQL. The db_query function will alter the query.{{parmdesc | |||
|substring|d1=for the SQLite database, '''SUBSTRING''' will be replaced by '''SUBSTR''' | |||
|See the function smf_db_query|d2= in Subs-DB-{dbms}.php for the full list of replacements. | |||
}} | |||
|values|d2=is an array of values you are intending to use in the query. | |||
}} | |||
|return=a query resource or '''false''' on error. | |||
|example=<nowiki>$result = $smcFunc['db_query'](''', ' | |||
SELECT poster_time | |||
FROM {db_prefix}messages | |||
WHERE id_msg = {int:id_msg} | |||
LIMIT 1', | |||
array( | |||
'id_msg' => $user_settings['id_msg_last_visit'], | |||
) | |||
);</nowiki> | |||
|Example with identifier 'substring'|d1= | |||
{{code|1=<nowiki>$result = $smcFunc['db_query']('substring', ' | |||
SELECT m.subject, | |||
'. ($mylimit > 0 ? SUBSTRING(m.body, 1, '.$mylimit.') as body : 'm.body'). ', | |||
IFNULL(mem.real_name, m.poster_name) AS realName, m.poster_time as date, mem.avatar, mem.posts, mem.date_registered as dateRegistered,mem.last_login as lastLogin, | |||
IFNULL(a.id_attach, 0) AS ID_ATTACH, a.filename, a.attachment_type as attachmentType, t.id_board as category, b.name as category_name, | |||
array( | |||
'id_msg' => $user_settings['id_msg_last_visit'], | |||
) | |||
);</nowiki>}} | |||
}} | |||
</nowiki></pre> | |||
will result in | |||
{{:User:Emanuele/smctemplate | |||
|function=db_query | |||
|usage=$smcFunc['db_query'] (identifier, query, values, connection) | |||
|description=Works Similar to how db_query worked in 1.x versions. | |||
|parameters={{parmdesc | |||
|identifier|d1=is used to identify specific query types in which it is necessary to replace portions of the query for compatability across all Database Management Systems supported by SMF. The query must be written for MYSQL. The db_query function will alter the query.{{parmdesc | |||
|substring|d1=for the SQLite database, '''SUBSTRING''' will be replaced by '''SUBSTR''' | |||
|See the function smf_db_query|d2= in Subs-DB-{dbms}.php for the full list of replacements. | |||
}} | |||
|values|d2=is an array of values you are intending to use in the query. | |||
}} | |||
|return=a query resource or '''false''' on error. | |||
|example=<nowiki>$result = $smcFunc['db_query'](''', ' | |||
SELECT poster_time | |||
FROM {db_prefix}messages | |||
WHERE id_msg = {int:id_msg} | |||
LIMIT 1', | |||
array( | |||
'id_msg' => $user_settings['id_msg_last_visit'], | |||
) | |||
);</nowiki> | |||
|Example with identifier 'substring'|d1= | |||
{{code|1=<nowiki>$result = $smcFunc['db_query']('substring', ' | |||
SELECT m.subject, | |||
'. ($mylimit > 0 ? SUBSTRING(m.body, 1, '.$mylimit.') as body : 'm.body'). ', | |||
IFNULL(mem.real_name, m.poster_name) AS realName, m.poster_time as date, mem.avatar, mem.posts, mem.date_registered as dateRegistered,mem.last_login as lastLogin, | |||
IFNULL(a.id_attach, 0) AS ID_ATTACH, a.filename, a.attachment_type as attachmentType, t.id_board as category, b.name as category_name, | |||
array( | |||
'id_msg' => $user_settings['id_msg_last_visit'], | |||
) | |||
);</nowiki>}} | |||
}} | }} |
Revision as of 09:22, 29 April 2011
This template should be used for pages describing $smcFunc functions.
Available parameters:
- function the name of the function (e.g. db_query)
- usage how the function is called with all the parameters available
- description a description of what the function does and how it works
- parameters a {{parmdesc}} list of the parameters the function accepts and relative description
- return what the function returns
- notes short description of what the function returns if anything is returned
- example an example of how the function must be used, please use the <nowiki> and </nowiki> tag to surround the code block as described in the {{code}} template documentation
- return tree additional fields where is possible to specify the name of the parameter and its content, to be used like in {{parmdesc}}:
|name of the field|d1=description of the field
- additional fields
{{smcfunc |function=db_query |usage=$smcFunc['db_query'](identifier, query, values, connection) |description=Works similar to how db_query worked in 1.x versions. |parameters={{parmdesc |identifier|d1=is used to identify specific query types in which it is necessary to replace portions of the query for compatability across all Database Management Systems supported by SMF. The query must be written for MYSQL. The db_query function will alter the query.{{parmdesc |substring|d1=for the SQLite database, '''SUBSTRING''' will be replaced by '''SUBSTR''' |See the function smf_db_query|d2= in Subs-DB-{dbms}.php for the full list of replacements. }} |values|d2=is an array of values you are intending to use in the query. }} |return=a query resource or '''false''' on error. |example=<nowiki>$result = $smcFunc['db_query'](''', ' SELECT poster_time FROM {db_prefix}messages WHERE id_msg = {int:id_msg} LIMIT 1', array( 'id_msg' => $user_settings['id_msg_last_visit'], ) ); |Example with identifier 'substring'|d1= {{code|1=$result = $smcFunc['db_query']('substring', ' SELECT m.subject, '. ($mylimit > 0 ? SUBSTRING(m.body, 1, '.$mylimit.') as body : 'm.body'). ', IFNULL(mem.real_name, m.poster_name) AS realName, m.poster_time as date, mem.avatar, mem.posts, mem.date_registered as dateRegistered,mem.last_login as lastLogin, IFNULL(a.id_attach, 0) AS ID_ATTACH, a.filename, a.attachment_type as attachmentType, t.id_board as category, b.name as category_name, array( 'id_msg' => $user_settings['id_msg_last_visit'], ) );}} }} </nowiki>
will result in {{:User:Emanuele/smctemplate |function=db_query |usage=$smcFunc['db_query'] (identifier, query, values, connection) |description=Works Similar to how db_query worked in 1.x versions. |parameters={{parmdesc
|identifier|d1=is used to identify specific query types in which it is necessary to replace portions of the query for compatability across all Database Management Systems supported by SMF. The query must be written for MYSQL. The db_query function will alter the query.{{parmdesc |substring|d1=for the SQLite database, SUBSTRING will be replaced by SUBSTR |See the function smf_db_query|d2= in Subs-DB-{dbms}.php for the full list of replacements. }} |values|d2=is an array of values you are intending to use in the query.
}} |return=a query resource or false on error. |example=$result = $smcFunc['db_query'](''', ' SELECT poster_time FROM {db_prefix}messages WHERE id_msg = {int:id_msg} LIMIT 1', array( 'id_msg' => $user_settings['id_msg_last_visit'], ) ); |Example with identifier 'substring'|d1=
$result = $smcFunc['db_query']('substring', ' SELECT m.subject, '. ($mylimit > 0 ? SUBSTRING(m.body, 1, '.$mylimit.') as body : 'm.body'). ', IFNULL(mem.real_name, m.poster_name) AS realName, m.poster_time as date, mem.avatar, mem.posts, mem.date_registered as dateRegistered,mem.last_login as lastLogin, IFNULL(a.id_attach, 0) AS ID_ATTACH, a.filename, a.attachment_type as attachmentType, t.id_board as category, b.name as category_name, array( 'id_msg' => $user_settings['id_msg_last_visit'], ) );
}}