BLHTML.org

BLHTML.org / Web Programming / BLHTML / BLHTML Manual / BLHTML funktion list /

 
  BLHTML funktion list 21376 79
funktion:  return:How to use:
#,#'Installation script, a packed '
#+##Showing: brädgård: #
#<#<Showing: html tagg: <
#>#>Showing: html tagg: >
#_#&nbsp;Shows fasta SPACE
 
#BS#\Showing: \
#-|##-|#Installation script, a packed (
#|-##|-#Installation script, a packed )
#,,#"Installation script, a packed "
#//#//Remark: // omit the remaining code on the following line
#/*#/*Remark: omit code starting marker /*
#*/#*/Remark: omit the final code selection */

More information:
  • Special characters
  • BLHTML Introduction
  • Function Information Overview information of BLHTML functions
  • BLHTML syntax How BLHTML are designed and provides
  •   DB 2262 0
    #DB# is an admin, database function
    Rights to use the function #DB#:
  • Only Admin Accounts

  • #DB# Selects the active database and displays information about SQL server.
    Forum sets #SYSTEM[forum]# to "1", to exclude DB from forum.

    SYSTEM $secure variables:
    variables:  description:
    mainset to TRUE if the main web database is active
    connected#DB value=connected#
    active#DB show=database#
    linkLink Variable for current connection to SQL Server

    $secure variables: system/boot.php
    variables:  description:
    typeTyp of databas
    serverAddress to SQL server
    databaseDatabase name
    userDatabase user
    passwdPassword database user

    values:  defaults:  description:
    valueSet aktive database
    selectSwitches to another database for the SQL-user
    showserverDisplays the current path on the SQL Server
    databaseDisplays the name on current database
    encodingShowing the database character set
    verShowing the database version
    returnreturn=variable stores the results in $variable

    Managing multiple databases: system/boot.php
    <?php
    $secure[1] = array
    (
            type
            server
            database
            user
            passwd
    => "mysql",
    => "localhost",
    => "database",
    => "Admin",
    => "password"
    // Typ of databas
    // Address to SQL server
    // Database name
    // Database user
    // Password database user
    );

    // Database Connection to another MySQL server
    $secure[2] = array
    (
            type
            server
            database
            user
            passwd
    => "mysql",
    => "192.168.1.2",
    => "prod_db",
    => "Admin2",
    => "password2"
    );
    ?>
    $secure[identifier] can be any PHP array name.

    Change current database:
    #DB value=2# // Sets the active external database 2: $secure[2]
            #READ table=AA value=3# // Read all the field from table AA from database 2 where key field is 3
            #SQLGET value(select * from AA where id=3)# // Read the same post as the READ example above

    #DB value=1# // Return to database 1: $secure[1]
    // If you dont set back the website database the website can not properly completing

    Sets the active internal database:
    #DB select=otherDB#
    // Sets the active database, where users on active MySQL server has rights to the database "otherDB"

    More information:
  • #READ#
  • #SQLGET#
  • Configure MySQL Create new MySQL user and database
  • FAQ: How do I connect to an external MySQL database?
  •   ARRAY 2478 0
    #ARRAY# is an independent function
    Rights to use this function #ARRAY#:
  • BASIC

  • #ARRAY# Manages and manipulates #$arrayer[+]#

    values:  defaults:  description:
    valueManage $array/$array[+]
    typewordno=$post_name tar ut contents from element no
    searchIf needle är contents from ett element returneras ellementets pekaren: $array[$pekare]
    upperSätter VERSALER for all element
    lowerSätter gemener for all element
    shuffleBlandar ordningen for arrayen
    invInverterar ordningen for arrayen
    sortSorterar arrayens value efter 1 2 3 A B C
    keySorterar arrayens value efter Elementname
    uniqueTar bort foregående elementet if fler of samma värde
    sumSummerar all value in value=$array
    countRäknar amount element in value=$array
    returnreturn=variable stores the results in $variable

    Example:
    #$arr[+](ONE TWO THREE EIGHT FOUR FIVE SIX SEVEN EIGHT)#

    arr(#$arr[+]#)<br>

    #ARRAY type(inv unique inv lower) value=$arr#
    // Inverterar, tar bort forsta of all lika element, eftersom vi vänt on arrayen tar den bort den forsta "EIGHT"
    // Snurrar back arrayen and gör all bokstäver to gemener


    new(#$arr[+]#)

    Returns:
    arr(ONE TWO THREE EIGHT FOUR FIVE SIX SEVEN EIGHT)
    new(one two three four five six seven eight)

    #$a[+](1 2 3 4 5)#

    SUM(#ARRAY type=sum value=$a#)<br>
    COUNT(#ARRAY type=count value=$a#)<br>

    #ARRAY type=search needle=4 value=$a return=b#
    SEARCH(#$b#)<br>
    $a[#$b#](#$a[$b]#)

    Returns:
    SUM(15)
    COUNT(5)
    SEARCH(3)
    $a[3](4)

    More information:
  • #STR#
  • #SUM#
  • #DO#
  • Array handling
  • array
  •   [1-...] 2585 0
    #[1-...]# is an independent function
    The rights to use the function #[1-...]#:
  • Users can only view pictures from his own account
  • Admin / Vanguard accounts. Admin, lesser admin, freedom can display images from other account.

  • #[1-...]# Showing images from account Forum puts #SYSTEM[forum]# to "1". It puts id = Current users
    For users to show their own images.
    Attributes: width, height, alt, title gets the information set in My Pictures

    values:  defaults:  description:
    idcurrent accountView image from account id
    widthpull / compresses the image width to the pixel width
    heightpull / compress the image height to the pixel height
    border0Picture frame thickness
    altalt displayed when the image is not loaded or if images is set to be displayed as text
    titletitle is informationstext when the mouse is over object
    showshow=url shows the image url address
    returnreturn=variable stores the results in $variable

    Example:
    #1# // Showing image 1 from current account
    #5 id=1# // Displaying image number 5 from account 1

    #42 width=400 alt(New alt text) title(Informations text for mouseover the picture)#
    // Displays image number 42 from the current account, drags / compress the image to 400 pixels, forces on new alt and title value

    More information:
  • Manage pictures
  • My Pictures
  • #PIC# Showing images from: images/
  • #[A-Z]# Showing hyperlink to accounts datapage
  •   [A-Z] 2603 0
    #[A-Z]# is an independent function
    Rights to use the function #[A-Z]#:
  • Anyone can create hyperlinks to any domain account

  • #[A-Z]# Function consists only of one letter and displays a hyperlink to the accounts datapage.
    The linkname is the datapage rubric.
    Forum puts #SYSTEM[forum]# to "1", it puts id = Current users
    For users to be able to show their own links from the Forum.


    values:  defaults:  description:
    idcurrent accountView image from account id
    typeeditEdit datapage
    valueThe page's rubricvalue sets occasional new title / text link on hyperlink
    dataInclude variablesInclude variables
    tabindexSets the URL object's tabindex
    showshow=text show datapage rubric as text
    show=url return datapage url address
    alwaysalways=true
    blhtmlblhtml=on BLHTML executes rubric
    returnreturn=variable Stores result in $variable

    Example:
    #A# // Showing hyperlink for the datapage A from current account
    #G id=200# // Showing hyperlink for the datapage G from account 200

    Example: rubric, show
    #A id=1 value(Return to home page)#<br>
    // Showing Hyperlink to HOME, datapage A from account 1 and sets a new title: "Return to home page"

    #A id=1 show=url#<br>
    #A id=1 show=text#

    Returns:
    Return to home page
    index.php?ID=1&page=A
    BLHTML.org

    More information:
  • datapage
  • #[1-...]# View images related to the account
  •   DO 2851 1
    #DO# gör snabba datalistor.
    Rights to use this function #DO#:
  • BASIC

  • #DO# manage loppar for arrayer, or from and to satser.
    #DO limit=20# do sätts to 20 for att forhindra evighetslopar

    Variables:
    variable:  description:
    $postCurrent värde from $array/$array[+]
    $post_nameArrayname: $post = $array[$post_name]
    $stepStep som har utforts

    Attributes:
    values:  defaults:  description:
    SQL-fråga:
    idcurrent accountAccount som agerar som datalist
    whereSQL where expression
    echofalseecho=true, Shows SQL-fråga

    foreach array:
    arrayarray=$array/$array[+] som skall stegas
    skipskip=$amount, hoppa över $amount steg
    gotoHoppa över and starta stega där goto=$post value on posten
    limit20Show do amount stegningar

    for from to:
    from1Startvärde for stegning
    to1Stega to värde to
    step1stega step for varje stegning
    skipskip=$amount, hoppa över $amount steg
    gotoHoppa över and starta stega där goto=$post value on posten
    limit20Show do amount stegningar

    Example:
    1
    #$key[+](A B C D E)#

    key=#$key#<br>
    key=#$key[+]#<br><br>

    // Stegar arrayen $key, hoppar över de 2 forsta postsna and skriver max ut value 100 gånger
    #DO array=$key skip=2 limit=100
    value(
            step(#$step#).
            post_name(#$post_name#)
            post(#$post#)
            key(#$key[$post_name]#)<br>
    )
    #
    <br><br>

    Start:
    // Stegar -2 from 30 and to 1, hoppar över de 5 forsta stegen, gör maximalt 3 amount stegningar
    #DO from=30 to=1 step=-2 skip=5 limit=3
    value(
            post(<b>#$post#</b>)
            #IF($post == 8) then(#HALT#)#
    )
    #

    the End

    Returns:
    key=Array
    key=A B C D E

    step(1). post_name(2) post(C) key(C)
    step(2). post_name(3) post(D) key(D)
    step(3). post_name(4) post(E) key(E)


    Start: post(20) post(18) post(16) the End

    More information:
  • DO with AJAB Asynkron stegning
  • AJAB slideshow with DO
  • #ECHO#
  • #GOTO# #GOSUB# and #RETURN#
  • #IF#
  • #SWITCH#
  •   BASKET 3092 1
    #BASKET# is a database function
    Rights to use this function #BASKET#:
  • Data manager

  • #BASKET# anropar database handler basket.
    Satta variables som överensstämmer with table: $blhtml_basket updates.
    Att anropa #BASKET# can göras mitt in ett script, #BASKET# can executes flera gånger for att update flera table.

    values:  defaults:  description:
    idcurrent accountAccount id sätter $blhtml_table
    table$blhtml_tableTabell/er som skall administreras
    erase$blhtml_eraseFältid_$id som skall raderas
     
    new$blhtml_newnew=true/on if ingen nyckel sätts nyckeln to nykel + 1
    attrib$blhtml_attribattrib=true/on print out accounts attrib rights
    echoecho=true/on print out SQL-case and information for felsökning

    id slår ut $blhtml_table. $blhtml_table sätts to account: id
    If varken id or $blhtml_table sätts $blhtml_table to current account.

    Example:
    #SET_CATCH_PAGE# // Sätter returpage
            #$blhtml_table=data_account# // Vi skall skriva to table: data_account
            #$erase=remove# // If kryssrytan remove_8 är markerad skall post 8 raderas

    #IF($save) then(#BASKET#)# // If Knappen blivit klickad called basket

    #READ value=8# // Read in post där nyckelvalue är 8 from current account

    #DATA[remove] post=new prefix=id type=checkbox class=std#
    #DATA[name] post=new# // Value from field name can edited in textrutan
    #PLOPP name=save value(Update post 8)#<br><br> // Knappen $save som anropar basket

    $blhtml_basket=#$blhtml_basket# // Writes ut returkod for basket. If 8 är posten updated
    • SET_CATCH_PAGE table sätter $blhtml_table to account: data_account
      erase sätter $blhtml_erase for posts som skall raderas
    • #READ#: Post with key field 8 läses in from current table
    • #DATA[name] post=new# field name skall sättas to detta textfield
    • #BASKET# skickar all variables to basket for writing to table data_account
    • $blhtml_basket shows Return codes basket
    More information:
  • basket
  • attrib
  • #SET_CATCH_PAGE#
  • #READ#
  • #FIELD#
  •   DIAGRAM 3101 0
    #DIAGRAM# is an independent function
    Rights to use this function #DIAGRAM#:
  • BASIC

  • #DIAGRAM# Shows ett diagram.
    modules/BLHmin.php

    Standard färger for diagramets staplar:
    color[+](FF0000 00FF00 0000FF 00FFFF FF00FF FFFF00 00CCCC 888888 004D98 CC6600 00984A)

    values:  defaults:  description:
    value$value[+] or $value array, Diagram value (noll litterad)
    info1 2 3...$array[+] or $value array, Stapel information (ett litterad)
    colorSätter unikt färg schema, standard color[+] array
    width90%Diagrammets totala page width
    text_width60The width on informations rutan
    border0Tjoklek on diagram staplar
    inkStandard färg on informations text
    paperEEEEEEBackground color on diagram
    showshow=% Shows resultat in procent, som standard show amount
    fat70%1 to 7 font size, tjocklek on diagram staplar
    size70%Font size on informations text
    format0Textformat on procent/amount information
    bit 0 Fet text
    bit 1 kursiv text
    bit 2 understruken text
    returnreturn=variable stores the results in $variable

    Example with data from vote:
    #COUNTCLICK id=90 click=Unlimited show=array return=dia#
    #$info[+](1 2 3 4 5 6 7 8 9 10)#
    dia[*]=#$dia[*]#<br><br>

    Diagram shows % and with standard färger on staplarna:<br>
    // Känner of if $dia and $info är arrayer and därfor ej nödvändigt to write $dia[+] and $info[+]
    #DIAGRAM value=$dia info=$info show=%#<br><br>

    All staplar har samma färg:<br>
    // Att använda value($dia[+]) info($info[+]) är only for att manuelt kunna skriva in data
    #DIAGRAM value($dia[+]) info($info[+]) paper=FFD5B4 color=CC6400 border=1#

    Returns:
    0 dia[*]=1 5 8 1

    Diagram shows % and with standard färger on staplarna:
    183%
     
    20% 
    30% 
    40% 
    50% 
    60% 
    70% 
    817%
     
    90% 
    100% 


    All staplar har samma färg:
    15
     
    20 
    30 
    40 
    50 
    60 
    70 
    81
     
    90 
    100 


    More information:
  • #COUNTCLICK#
  • vote
  • #UPLOAD#
  • #DOWNLOAD#
  •   PRINT 2801 0
    #PRINT# is an independent function
    Rights to use this function #PRINT#:
  • All

  • #PRINT# Prints the website standardized headings.
    If datapage bläckfärg change i Control Panel change all tester skrivna with #PRINT# to den nya färgen.

    values:  defaults:  description:
    ink#SYSTEM[ink]#Textcolor (inkcolor)
    paperBackground color (papercolor)
    sizeText size
    blhtmlblhtml=on BLHTML executes value
    valueRubrictext
    formatOktal textformatering
    returnreturn=variable stores the results in $variable

    #PRINT
            size=1 to 7
            format=0 to 7
            value(Din överskrift)
            ink=Din HEX-Färg on bokstäverna
            paper=HEX-Färg background color
    #

    Textformatering with format
    0Texten blir utan textformatering
    1Fet text
    2Kursiv text
    4Understruken text


    Du can blanda formateringen:
    format=0Texten blir utan textformatering
    format=1Fet text
    format=5Fet and understruken text
    format=6Kursiv and understruken text
    format=7All textformaterinar on your text

    Example:
    #PRINT size=5 value(Page rubric)#<br>
    #PRINT value(BLHTML rubric)#

    Returns:
    Page rubric
    BLHTML rubric


    Dynamisk picture management:
    #$flower=2#
    #$b=3#
    #$lavendel=9#

    // 3 sätt att dynamic skriva ut accounts pictures
    #PRINT value(#$flower id=11 width=75#) format=0 blhtml=on# // Utan textformatering
    #STR value(#$b id=11 width=100#) blhtml=on#
    #PIC id=11 no=$lavendel width=50#

    Returns:


    More information:
  • #STR#
  • #PIC#

  • Verktyg for att ta fram Säkra HEX webfärger:
  • http://www.visibone.com/colorlab/
  • http://www.ficml.org/jemimap/style/color/wheel.html
  • http://en.wikipedia.org/wiki/Web_colors
  •   COUNTCLICK 3639 3
    #COUNTCLICK# is a database function
    Rights to use this function #COUNTCLICK#:
  • Data manager

  • #COUNTCLICK# summerar amount klick en link blivit klickad.
    modules/BLHmin.php
    #COUNTCLICK id=votetableid user=myname value=download object#
    #COUNTCLICK id=votetableid click=klickobject#

    Statestik for year / mounth / day är for närvarande inte fungerande!

    values:  defaults:  description:
    idcurrent accountKlick registrerings account
    valueAccounts download object action=reset values
    userOwner to Download object
    clickManage klickobject: "oid" from id=vote-table
    #DOWNLOAD id=90 value=$value show=click# tar fram klickvalue
    yearyear=all räknar all klick for download object
    negativt tal year=-2 räknar all klick for 2 år plus current års klick
    mounthmounth=all räknar all klick for download object som hänt detta år
    negativt tal mounth=-1 räknar all klick for 1 månader plus current månads klick
    dayday=all räknar all klick for download object som hänt denna månad
    negativt tal day=-7 räknar all klick de last 7 days
    todaytruetoday=true räknar dagens all klick for download objectet
    decimal2show=avg/all Hur många decimaler som skall returneras for medeltal
    showcount
    sum
    avg
    all
    array
    Number of klick
    Summa of all klick
    Medelvalue
    returnerar array[+]: "Number of klick" "Summa of all klick" Medelvärde
    returnerar en BLHTML array[+] with all klick from ej IP registrerade IP frågor
    actionshow
    reset
    list
    date
    Shows klickdata
    Objects som skall nollställas
    returnerar en BLHTML array[+] with all registrerade click object
    Datum när value=object laddades upp
    returnreturn=variable stores the results in $variable

    Example:
    // id=91 is the dataccount for the click table
    // id=92 is the dataccount for the vote table

    #DOWNLOAD id=201 value=1 show=click return=click#
    #COUNTCLICK id=91 click=$click year=all return=downloads#
    #DOWNLOAD id=201 value=1# is downloaded #$downloads# times.

    Download today: #COUNTCLICK id=91 user=Adam value=8#
    // Show how many time Adams download item 8 been downloaded today

    #COUNTCLICK id=92 click(ask a question) action=reset#
    // action=reset values is the click for the function show=array to show all post

    #COUNTCLICK id=92 click(ask a question) show=all decimal=2 return=all#<br>
    all[+]: #$all[+]#<br><br>

    ant: #$all[0]#<br>
    sum: #$all[1]#<br>
    avg: #$all[2]#<br>

    array[+]: #COUNTCLICK id=92 click(ask a question) show=array#

    Returns:
    link to object is downloaded summa amount nedladdningar

    Download today: shows amount nedladdningar som gjorts with Adams download object 8 idag

    action=reset shows följande warning messages:
    Objects: Objects är nollstäld
    // Nollställningen of klick for function show=array for att kunna show all posts

    all: 28 188 6.71
    ant: 28
    sum: 6.71
    avg: 7

    array[+]: 5 0 3 0 2 0 0 8 0 10 // Post 1 2 3 4 5 6 7 8 9 10

    date:
    #SYSTEM[myname] return=myname#

    // id=91 COUNTCLICK/vote table
    // user=current user and download object 2

    #WHEN type=date space=-
            value(#COUNTCLICK id=91 user=$myname action=date value=2#)
    blhtml=on
    #

    Returns:
    2010-05-08

    More information:
  • vote
  • #DOWNLOAD#
  • #UPLOAD#
  • #DIAGRAM#
  • BLHTML array
  •   DOWNLOAD 3418 0
    #DOWNLOAD# is an independent function

    Rights to use this function #DOWNLOAD#:
  • All with download objects

    • #DOWNLOAD#
    • Download fileen using download.php
    • Filens fysiska name är alltid dold for all besökare
    • the file is calling throu variable $file
    • User can only lägga ut sina egna Download objects
    download.php?file=0981030298548096
    $file består of 16 characters var of de 3 forsta 098 talar if vilket account som handhar statestiken.
    4 tecknet: 1 handhar information om:
  • If bit 1 är satt can only members download file
  • If bit 2 är satt registreras only en klickning objects and IP address

  • If only for members show ej object/filen.
    Objectset nås ej if besökaren har rätt address men inte är logon.

    Övriga 12 characters 030298548096 är en unik string som identifierar object/filen.

    values:  defaults:  description:
    idcurrent accountAccount for Download object
    showshow=click returnerar download objects click värde
    valueDownload object
    blhtmlblhtml=on BLHTML executes $alt (sätts using #UPLOAD#)
    returnreturn=variable stores the results in $variable

    Example:
    #DOWNLOAD id=201 value=2 blhtml=on#
    #DOWNLOAD id=201 value=3 blhtml=on#
    #DOWNLOAD id=201 value=4 blhtml=on#

    Returns:
    3 links to account 201:s 2, 3 and 4 Download object

    More information:
  • #COUNTCLICK#
  • #DIAGRAM#
  • #UPLOAD#
  •   UPLOAD 3637 0
    #UPLOAD# is an independent function
    Rights to use this function #UPLOAD#:
  • All with download objects

  • #UPLOAD#
  • Download Objects administreras under Account Admin -> Download Objects
  • Upload file to webservern to erhållen plats in Download Objects
  • Kan only ladda upp files to eget account
  • #UPLOAD# returnerar arrayen $blhtml_download_object[+] som contents accounts all Download Objects
    • Functionsvariables:
    • #DATA[blhtml_upload] post=hidden value=2# Sätter:
      <form enctype=multipart/form-data name=lokalt action=index.php method=post>
      for att kunna skicka en fil to webservern
    • #DATA[blhtml_click] post=hidden value=96# Talar if vilken click statestik table/account som skall användas
      Här används account 96
    values:  defaults:  description:
    valueLagrings plats for Download Objects
    alt$altInformations text som representerar download Objectset
    member$memberIf värde can only members download object
    always$alwaysIf värde summeras ej IP addresserna (can only klicka en gång)

    UPLOAD example
    Upload file and sätter associated objects value.
    Shows även accounts all objects and contents.

    Include variables:
    blhtml_upload=2

    <br>
    #DATA[blhtml_upload] post=hidden value=2#
    #DATA[blhtml_click] post=hidden value=96# // Klick registrerings account 96
    #UPLOAD#

    #IF($blhtml_download_object) then(#GOSUB upload#)#
    #SET_CATCH_PAGE#

    #IF($blhtml_download_object) then(#GOTO list#)#

    <div class=info>
    Download objects saknas for user <b>#$myname#</b>!
    </div>


    #HALT#


    #: upload#
    #PRINT size=5 value(Your files on #SYSTEM[name]#) blhtml=on#
    <hr color=#SYSTEM[page_ink]#><br>

    Your file slot:<br>
    #DATA[id] post=new type=dropdown value=$blhtml_download_object#<br><br>

    #DATA[member] post=new type=checkbox class=std# Member only<br>
    #DATA[always] post=new type=checkbox class=std# Always register IP address<br><br>

    Upload file:<br>
    #DATA[userfile] post=new type=file#<br><br>
    #UPLOAD value=$id#

    Informations text:<br>
    #DATA[alt] post=new#<br><br>

    #PLOPP value(Upload your file)#<br><br><br>
    #RETURN#


    #: list#
    #SYSTEM[whoami] return=who#
    #$n=0#
    #: loop#
    Slot #$blhtml_download_object[$n]#: #DOWNLOAD id=$who value($blhtml_download_object[$n]) blhtml=on#<br>
    #SUM value($n 1) return=n#
    #IF($blhtml_download_object[$n]) then(#GOTO loop#)#

    More information:
  • #COUNTCLICK#
  • #DIAGRAM#
  • #DOWNLOAD#
  •   INSERT 2995 0
    Rights to use this function #INSERT#:
  • Data Magager

    • #INSERT# Inserts data in the current accounts table.
    • Fast insert: #INSERT(postdata)# postdata skall vara ordnad efter fielden in current table
    • Detect insert: #INSERT() id(8) field(data)# updatear/insert field in current table
      om nothing värde for field() sätts field=$field
    • Andvänds of Administrera Databas -> Create script to make intallations script for datapage

    • $blhtml_insert sätt to 1 if post updated, if post inte blir updated sätts $blhtml_insert to 0
    Example Fast INSERT:
    #SYSTEM[whoami] return=blhtml_id#

    #FIELDMIN id($blhtml_id) name(id) key=true type=H8 null=false auto_increment=true#
    #FIELDMIN id($blhtml_id) name(txt) type=str len=24#

    // Create/update field id and txt

    #INSERT("1", "Some text")#
    #INSERT("2", "this is post no two")#
    #INSERT("3", "Last post")#
    // insert 3 post into local table

    #FIELDMIN# Create a 2 field id and txt
    #INSERT(postdata)# insert data direkt with SQL INSERT

    Example Detect INSERT:
    #INSERT() id=1 txt(Some text)#
    #INSERT() txt(this is post no two) id=2#
    // Field don't need to be fixed

    #$txt(Last post)#
    #INSERT() id=3#
    // field txt=$txt

    Update samma field
  • If inte post, skrivs a new post
  • If post, updates posten
  • Fält behöver ej ordnas efter fieldordningen in table
  • If ej field txt=värde sätts field of variable $txt

  • More information:
  • #FIELDMIN#
  • MySQL INSERT
  •   FIELDMIN 2923 0
    #FIELDMIN# is an admin, database function
    Rights to use this function #FIELDMIN#:
  • Data manager
  • Users with Data Manager manage only eget account

  • #FIELDMIN# Fält Administration, insert, update and delete field in en table.
    Kan även radera all field in en table.
    Första field in table är alltid ett key field, som standard är fieldname id.

    values:  contents:  description:
    idcurrent accountDatapage som skall Administreras
    nameName on field
    change_namenameNewtt field name
    keyfalse
    true
    Vanligt field
    Key Field måste vara unikt and contains värde (table can contains flera key field)
    typeH1
    H2
    H3
    H4
    H8
    F4
    F8
    str
    text
    -128 -- 127 (0 -- 255) 1 byte
    -32768 -- 32767 (0 -- 65535) 2 bytes
    -8388K -- 8388K (0 -- 16777K) 3 bytes
    -2.147G -- 2.147G (0 -- 4.294G) 4 bytes
    -9223372036G -- 9223372036G (0 -- 18446744073G) 8 bytes
    Flyttal 4 bytes
    Flyttal 8 bytes
    1 to 255 characters string
    65535 characters lång string
    len32type=str size on a stringfield in characters (1 to 255 characters)
    signedfalse
    true
    Only plusstal
    plus and minus
    nullfalse
    true
    Fält can ej vara tomt (måste contains värde)
    Fält can vara tomt
    defaultValue som skall sättas vid new post
    actionsave
    erase
    drop
    create/update field
    delete field
    delete hela table
    auto_incrementfalse
    true
    Sätter standard värde
    Create a new unikt number

    Example: Create Table to ett new standard forum
    #FIELDMIN name(id) key=true type=H8 null=false auto_increment=true#
    #FIELDMIN name(user) type=str len=16#
    #FIELDMIN name(grp) default(1)#
    #FIELDMIN name(date) type=str len=10#
    #FIELDMIN name(up) type=H2#
    #FIELDMIN name(rubric) type=str len=42#
    #FIELDMIN name(msg) type=text#
    #FIELDMIN name(status) default(1)#
    #FIELDMIN name(who) type=H8#
    #FIELDMIN name(tree) default(1)#
    #FIELDMIN name(edit) default(1)#
    #FIELDMIN name(edited) type=str len=10#
    #FIELDMIN name(visitors) type=H2#
    #FIELDMIN name(IP) type=str len=15#
    #FIELDMIN name(last) type=str len=16#
    #FIELDMIN name(ldate) type=str len=11#


    // Field id create automatic to #FIELDMIN name(id) type=H1 key=true null=false#
    // Erase active table: #FIELDMIN action=drop#

    Fältet id create automatiskt to #FIELDMIN name(id) type=H1 key=true null=false#
    Delete current table: #FIELDMIN action=drop#

    More information:
  • #INSERT#
  •   COPY_PAGE 5441 0
    #COPY_PAGE# is an admin, database function
    Rights to use this function #COPY_PAGE#:
  • User can skriva to sina egna account
  • Admin can skriva to all accounts
  • Vanguards can skriva to all 100 to 199 account

    • #COPY_PAGE#:
    • Copy existing datapage to a new destinations datapage.
    • Eventuell information skrivs över on destinations datapage.
    • Property variables skriver över ursprungs datapage information if värde.
    • If ingen ursprungs page används only property variables.
    • If ingen ursprungs page and inga property variables anges skrivs en tom page (Page raderas)
    values:  defaults:  description:
    idcurrent accountAccount datapage som skall copyings to (user only eget konto)
    pagePage som skall skrivas
     
    Orginalpage:
    source_idcurrent accountAccount datapage som skall copyings befinner sig i
    source_pagePage som skall copyings
     
    Sid information:
    rubric$rubricThe page's rubric
    msg$msghtml page
    info$infoinfotext for page
    seek$seekPages sökord
    page_data$page_dataPages included variables
     
    Sid data:
    db_page$db_pagePage är datapages: Insert in Database page
    top_page$top_pageTop page (Show page överst)
    page_paper$page_paperPages background color
    page_pic$page_picPages background picture
    page_property$page_property
    värde  bit  Function
    10Page aktiv
    21Dölj page for user
    42Show in the menu
    83-
    164Members can see page
    325Guests can see page

    Page måste vara aktiv + synlig for medlämmar or guests for to shows.

    border_type$border_typeTyp of ram (1 to 9) 1=ingen ram
    border_paper$border_paperFärg on sidram
    border_left$border_leftVänstra ramens width in punkter
    border_top$border_topÖvre ramens width in punkter
    border_right$border_rightHögra ramens width in punkter
    border_bottom$border_bottomNedersta ramens width in punkter

    Example:
    #SYSTEM[whoami] return=id# // Sätter $id=#SYSTEM[whoami]#
    #$rubric(Writes egen rubric)# // Writes denna rubric oavsett vad page E:s rubric är

    #PAGE_ADMIN id=$id page=D#
    #COPY_PAGE  id=$id page=D source_page=E#

    #PAGE_ADMIN# If datapage not contains creates datapage #D#
    #COPY_PAGE# Writes if logon users #D# page from datapage E from konto som the script runs from

    More information:
  • #PAGE_ADMIN#
  •   REPLY 3061 0
    #REPLY# is a forum admin command
    Rights to use this function #REPLY#:
  • Data manager

  • Svara post: REPLY
    #REPLY# Reply forums current index post
    Show only if rättighet ges

    values:  defaults:  description:
    idcurrent accountAccount for forums table
    forumAccount for forum
    altReplyFörklarande text
    pageDPage for att answer post
    width40The width on kuvert ikonen images/icon/letter.png
    site$siteForum show on Account
    sheet$sheetPage forum show on

    Example on delad #REPLY#:
    <div align=RIGHT>#REPLY id=$site forum=$forum sheet=$sheet alt(Svara post:)#</div>
    #ECHO
            preview=«preview next=Next»
            page=C show=Forum limit=4
            rights=2 locate=2
            always=true
    #

    More information:
  • FORUM
  • #ECHO#
  • BLHTML forum  

    1 2 3 4 Next


    apache MySQL PHP No to software patents! BLHTML
    © 2003, 2010 BLHTML
    This page is created with BLHTML in 0.2672 seconds