d2jsp
Log InRegister
d2jsp Forums > Off-Topic > International > Magyar > Mysql-el Kapcsolatos Kérdés.
1236Next
Add Reply New Topic New Poll
Member
Posts: 2,343
Joined: Sep 21 2012
Gold: 5,039.00
Nov 11 2012 08:27am
szevasztok!
azt a feladatot kaptam hogy mySQL-ben SQL parancsok segítségével létre kell hoznom 15000 random generált magyar típusú autó rendszámot ami között nincs két ugyanolyan. fingom nincs hogy kell ezt megcsinálni, kérdezem haverjaim de ők se tudják, utána néztem egy két helyen, de nem találtam használhatót. ha valaki tudja hogy kell, leírná a parancsot? nagyon megköszönöm előre is.
Member
Posts: 961
Joined: Apr 17 2007
Gold: 0.00
Warn: 10%
Nov 11 2012 08:28am
adam tudja
Member
Posts: 2,343
Joined: Sep 21 2012
Gold: 5,039.00
Nov 11 2012 08:33am
Quote (l1v3 @ Nov 11 2012 04:28pm)
adam tudja


haverod? meg tudod tőle kérdezni?
Member
Posts: 50,035
Joined: Sep 10 2006
Gold: 710.00
Nov 11 2012 08:36am
Quote (Fracture333 @ Nov 11 2012 02:33pm)
haverod? meg tudod tőle kérdezni?


haver még nem tud ilyeneket
Member
Posts: 20,826
Joined: Feb 8 2012
Gold: 1,630.69
Nov 11 2012 08:39am
Code
<interface name="game" onshow="Cmd('Trigger movf_interfacegame 1');" onhide="Cmd('Trigger movf_interfacegame 0');" scenex="0" sceney="0" scenewidth="100%" sceneheight="88h" luatable="true"
onload="
 Trigger('MiniMapPosition');
"
>

<lua file="/ui/scripts/game_new.lua" />

<panel name="lod_game_unload_delay" noclick="1" onloadlua="RegisterScript2('Game_Interface', '6') Game:InitializeGameInterface()" />

<!-- Packages -->
<childinterface file="ui_items_1.interface" />
<include file="movf.package"/>
<childinterface file="/ui/game_chat.interface" />
<childinterface file="/ui/game_vote.interface" />
<childinterface file="/ui/game_mentor.interface" />
<include file="stash.package"/>
<childinterface file="/ui/tooltips.interface" />
<childinterface file="/ui/confirmations.interface" />
<childinterface file="/ui/testpp/game_dev.interface" />
 
<if condition="(releaseStage_dev or releaseStage_test) and !releaseStage_rc and !releaseStage_stable and !ui_disableQAChecklist" >
 <panel y="-1" x="-26h" width="3.0h" height="3.0h" grow="1" align="right" name="game_qa_mini_button" visible="1" noclick="0" valign="top" passivechildren="1" color="0 0 0 1" onshow="BringToFront();"
  onclick="Call('game_qa_mini_panel_parent', 'SetVisible(!IsVisibleSelf());'); ##SetVisible(0);##"
 >
  <image texture="/ui/icons/tech_support.tga" height="90%" width="90%" align="center" valign="center" />
  <frame color="invisible" borderthickness="1" bordercolor="#074880" visible="1" />
 </panel>  
 <childinterface file="/ui/game_qa.interface" />
</if>  
 
<!-- Triggers -->
<trigger name="gameBuycourierStatus"/>
<trigger name="gameBuycourierResults"/>
<trigger name="MiniMapPosition" />
<trigger name="Score_Resize" />
<trigger name="GameImagePreviewVis"/>
<trigger name="GameImagePreviewInit"/>
<trigger name="GameMenuTooltipText"/>
<trigger name="CourierUpgrade"/>
<trigger name="ItemTooltip"/>

<!-- Couriers -->
<panel noclick="true" color="invisible"
 onload="
  CreateInt('_gameLastTotalCoins', 0);
  CreateInt('_gameLastTotalSilverCoins', 0);
 "
 watch0="AltCourierGoldCoins"
 ontrigger0="Set('_gameLastTotalCoins', param);"
 watch1="gameBuycourierResults"
 ontrigger1="
  If(
   param2 ge 0 and param1 == 1,
   CallEvent('game_buycourier_Error', 0)
  );
  If(
   param1 == 3,
   Split(
    CallEvent('game_buycourier_Success', 0),
    ChatRefreshUpgrades(),
    ClientRefreshUpgrades(),
    ServerRefreshUpgrades()
   )
  );
 "
 watch2="gameBuycourierStatus"
 ontrigger2="
  If(param0 == 3, CallEvent('game_buycourier_Error', 0));
 "
 watch3="AltCourierSilverCoins"
 ontrigger3="Set('_gameLastTotalSilverCoins', param);"
/>

<form
 name="gameBuycourier"
 host="!masterserver"
 method="get"
 target="/store_requester.php"
 statustrigger="gameBuycourierStatus"
 resulttrigger="gameBuycourierResults"
 resultparam0="responseCode"
 resultparam1="popupCode"
 resultparam2="errorCode"
 ssl="false"
/>

<!-- Templates -->
<template name="kick_button">
 <button
  x="{x=}" y="{y=}" width="{width=100%}" height="{height=100%}" align="{align=}" valign="{valign=}"
  group="{group}"
  name="{button_name}"
  color="invisible"
  visible="{visible=true}"
  watch="{watch=}"
  enabled="{enabled=true}"
  ontrigger="{ontrigger=}"
  watch1="{watch1=}"
  ontrigger1="{ontrigger1=}"
  watch2="{watch2=}"
  ontrigger2="{ontrigger2=}"
  onmouseover="PlaySound('/shared/sounds/ui/ccpanel/button_over_02.wav'); PlaySound('/shared/sounds/ui/ccpanel/button_over_01.wav'); {onmouseover}"
  onmouseout="{onmouseout}"
  onclick="PlaySound('{sound=/shared/sounds/ui/ccpanel/button_click_02.wav}'); {onclick}"
  onenter="PlaySound('{sound='/shared/sounds/ui/ccpanel/button_click_02.wav}'); {onenter}"
  onshow="{onshow}"
  hotkey="{hotkey}"
  onhotkey="PlaySound('{sound=/shared/sounds/ui/ccpanel/button_click_02.wav'}'); {onhotkey}"
  interactive="{interactive=true}"
  onevent="{onevent=}"
 >
  <widgetstate statename="up">
   <image texture="/ui/elements/kick_up.tga"/>
  </widgetstate>  
 
  <widgetstate statename="over">
   <image texture="/ui/elements/kick_over.tga"/>
  </widgetstate>
 
  <widgetstate statename="down" x="1" y="1">
   <image texture="/ui/elements/kick_down.tga"/>
  </widgetstate>
  <widgetstate statename="disabled">
   <image texture="/ui/elements/kick_disabled.tga"/>
  </widgetstate>
 </button>
</template>

<template name="kick_player_item">
 <panel width="100%" height="1.75h"
  visible="false"
  sticky="true" stickytoinvis="false"
  watch="MenuPlayerInfo{index}"
  onload="CreateBool('_kick_player_item_vis{index}', false);"
  ontrigger="
   SetOnclick('CallVote(\'kick\', ' # param0 # ');');
   If(
    param3 and
    !StringEquals(
     GetAccountName(), param2
    ) and param0 != -1 and !param9,
    If(
     !_kick_player_item_vis{index},
     Split(
      Set('_kick_player_item_vis{index}', true),
      SetVisible(true)
     )
    ),
    If(
     _kick_player_item_vis{index},
     Split(
      Set('_kick_player_item_vis{index}', false),
      SetVisible(false)
     )
    )
   );
  "
 >
  <label font="dyn_9" color="white" textvalign="center" shadow="true" noclick="true" watch="MenuPlayerInfo{index}" ontrigger="SetColor(param1); SetText(param2);"/>
  <instance name="kick_button" width="100@" height="100%" align="right" watch="MenuPlayerInfo{index}" ontrigger="SetOnclick('CallVote(\'kick\', ' # param0 # '); CallEvent(\'game_kick_list\', 1);'); SetVisible(param17 == 0);" watch1="VotePermissions" ontrigger1="SetEnabled(!param0 and !param1 and param8);"/>
  <label align="right" width="3h" font="dyn_9" color="white" textalign="right" textvalign="center" shadow="true" noclick="true" visible="false" content="0" watch="MenuPlayerInfo{index}" ontrigger="SetVisible(param17 gt 0); SetText(Ceil(param17 / 1000));"/>
 </panel>
</template>
Member
Posts: 6,109
Joined: Jul 25 2011
Gold: 0.00
Nov 11 2012 08:40am
Quote (Fracture333 @ Nov 11 2012 03:33pm)
haverod? meg tudod tőle kérdezni?


inb4 joey
Member
Posts: 43,289
Joined: Mar 25 2005
Gold: 355.92
Nov 11 2012 08:41am
Quote (sylke @ Nov 11 2012 04:36pm)
haver még nem tud ilyeneket


még
Member
Posts: 2,343
Joined: Sep 21 2012
Gold: 5,039.00
Nov 11 2012 08:44am
Quote (Karan2_Returned @ Nov 11 2012 04:39pm)
Code
<interface name="game" onshow="Cmd('Trigger movf_interfacegame 1');" onhide="Cmd('Trigger movf_interfacegame 0');" scenex="0" sceney="0" scenewidth="100%" sceneheight="88h" luatable="true"
onload="
 Trigger('MiniMapPosition');
"
>

<lua file="/ui/scripts/game_new.lua" />

<panel name="lod_game_unload_delay" noclick="1" onloadlua="RegisterScript2('Game_Interface', '6') Game:InitializeGameInterface()" />

<!-- Packages -->
<childinterface file="ui_items_1.interface" />
<include file="movf.package"/>
<childinterface file="/ui/game_chat.interface" />
<childinterface file="/ui/game_vote.interface" />
<childinterface file="/ui/game_mentor.interface" />
<include file="stash.package"/>
<childinterface file="/ui/tooltips.interface" />
<childinterface file="/ui/confirmations.interface" />
<childinterface file="/ui/testpp/game_dev.interface" />
 
<if condition="(releaseStage_dev or releaseStage_test) and !releaseStage_rc and !releaseStage_stable and !ui_disableQAChecklist" >
 <panel y="-1" x="-26h" width="3.0h" height="3.0h" grow="1" align="right" name="game_qa_mini_button" visible="1" noclick="0" valign="top" passivechildren="1" color="0 0 0 1" onshow="BringToFront();"
  onclick="Call('game_qa_mini_panel_parent', 'SetVisible(!IsVisibleSelf());'); ##SetVisible(0);##"
 >
  <image texture="/ui/icons/tech_support.tga" height="90%" width="90%" align="center" valign="center" />
  <frame color="invisible" borderthickness="1" bordercolor="#074880" visible="1" />
 </panel>  
 <childinterface file="/ui/game_qa.interface" />
</if>  
 
<!-- Triggers -->
<trigger name="gameBuycourierStatus"/>
<trigger name="gameBuycourierResults"/>
<trigger name="MiniMapPosition" />
<trigger name="Score_Resize" />
<trigger name="GameImagePreviewVis"/>
<trigger name="GameImagePreviewInit"/>
<trigger name="GameMenuTooltipText"/>
<trigger name="CourierUpgrade"/>
<trigger name="ItemTooltip"/>

<!-- Couriers -->
<panel noclick="true" color="invisible"
 onload="
  CreateInt('_gameLastTotalCoins', 0);
  CreateInt('_gameLastTotalSilverCoins', 0);
 "
 watch0="AltCourierGoldCoins"
 ontrigger0="Set('_gameLastTotalCoins', param);"
 watch1="gameBuycourierResults"
 ontrigger1="
  If(
   param2 ge 0 and param1 == 1,
   CallEvent('game_buycourier_Error', 0)
  );
  If(
   param1 == 3,
   Split(
    CallEvent('game_buycourier_Success', 0),
    ChatRefreshUpgrades(),
    ClientRefreshUpgrades(),
    ServerRefreshUpgrades()
   )
  );
 "
 watch2="gameBuycourierStatus"
 ontrigger2="
  If(param0 == 3, CallEvent('game_buycourier_Error', 0));
 "
 watch3="AltCourierSilverCoins"
 ontrigger3="Set('_gameLastTotalSilverCoins', param);"
/>

<form
 name="gameBuycourier"
 host="!masterserver"
 method="get"
 target="/store_requester.php"
 statustrigger="gameBuycourierStatus"
 resulttrigger="gameBuycourierResults"
 resultparam0="responseCode"
 resultparam1="popupCode"
 resultparam2="errorCode"
 ssl="false"
/>

<!-- Templates -->
<template name="kick_button">
 <button
  x="{x=}" y="{y=}" width="{width=100%}" height="{height=100%}" align="{align=}" valign="{valign=}"
  group="{group}"
  name="{button_name}"
  color="invisible"
  visible="{visible=true}"
  watch="{watch=}"
  enabled="{enabled=true}"
  ontrigger="{ontrigger=}"
  watch1="{watch1=}"
  ontrigger1="{ontrigger1=}"
  watch2="{watch2=}"
  ontrigger2="{ontrigger2=}"
  onmouseover="PlaySound('/shared/sounds/ui/ccpanel/button_over_02.wav'); PlaySound('/shared/sounds/ui/ccpanel/button_over_01.wav'); {onmouseover}"
  onmouseout="{onmouseout}"
  onclick="PlaySound('{sound=/shared/sounds/ui/ccpanel/button_click_02.wav}'); {onclick}"
  onenter="PlaySound('{sound='/shared/sounds/ui/ccpanel/button_click_02.wav}'); {onenter}"
  onshow="{onshow}"
  hotkey="{hotkey}"
  onhotkey="PlaySound('{sound=/shared/sounds/ui/ccpanel/button_click_02.wav'}'); {onhotkey}"
  interactive="{interactive=true}"
  onevent="{onevent=}"
 >
  <widgetstate statename="up">
   <image texture="/ui/elements/kick_up.tga"/>
  </widgetstate>  
 
  <widgetstate statename="over">
   <image texture="/ui/elements/kick_over.tga"/>
  </widgetstate>
 
  <widgetstate statename="down" x="1" y="1">
   <image texture="/ui/elements/kick_down.tga"/>
  </widgetstate>
  <widgetstate statename="disabled">
   <image texture="/ui/elements/kick_disabled.tga"/>
  </widgetstate>
 </button>
</template>

<template name="kick_player_item">
 <panel width="100%" height="1.75h"
  visible="false"
  sticky="true" stickytoinvis="false"
  watch="MenuPlayerInfo{index}"
  onload="CreateBool('_kick_player_item_vis{index}', false);"
  ontrigger="
   SetOnclick('CallVote(\'kick\', ' # param0 # ');');
   If(
    param3 and
    !StringEquals(
     GetAccountName(), param2
    ) and param0 != -1 and !param9,
    If(
     !_kick_player_item_vis{index},
     Split(
      Set('_kick_player_item_vis{index}', true),
      SetVisible(true)
     )
    ),
    If(
     _kick_player_item_vis{index},
     Split(
      Set('_kick_player_item_vis{index}', false),
      SetVisible(false)
     )
    )
   );
  "
 >
  <label font="dyn_9" color="white" textvalign="center" shadow="true" noclick="true" watch="MenuPlayerInfo{index}" ontrigger="SetColor(param1); SetText(param2);"/>
  <instance name="kick_button" width="100@" height="100%" align="right" watch="MenuPlayerInfo{index}" ontrigger="SetOnclick('CallVote(\'kick\', ' # param0 # '); CallEvent(\'game_kick_list\', 1);'); SetVisible(param17 == 0);" watch1="VotePermissions" ontrigger1="SetEnabled(!param0 and !param1 and param8);"/>
  <label align="right" width="3h" font="dyn_9" color="white" textalign="right" textvalign="center" shadow="true" noclick="true" visible="false" content="0" watch="MenuPlayerInfo{index}" ontrigger="SetVisible(param17 gt 0); SetText(Ceil(param17 / 1000));"/>
 </panel>
</template>


az a helyzet hogy én még elég új vagyok ebben az SQL-es témában, szal ez nekem így nagyjából kínai. ez az egész a parancssor amivel meg lehet azt csinálni amit kérdeztem? o.O vagy ebből ki kéne látnom a megfelelő parancsot? sajnos új vagyok úgyhogy egyszerűbben el tudnád magyarázni a dolgot? :)
Member
Posts: 33,712
Joined: Jan 7 2007
Gold: 0.00
Nov 11 2012 08:46am
Code
                       .
                         _,|\
                         \__/
                          ||
       ___               {_].
        \ \               L; `
         ) )               | :  ,(),_,_,(),
       _/_/                | | / /(,,^,,)\ \
                           | || |;`-o-'; | |
                           |/:) | | '.' | | (
                            \ \(   \_-_/   ) |
                             \ `._--)=(---.: |
                             |\ '-_|\O/|_-'/\
                            | | `\ |/ \| //\ \
                            / /   \     /   \ \
                          ; |    :\   /:    \/\
                           | (   / \\,// \   )\ \
                           | |  /  /|'|\  \  | \ \
                           | | /  / | | \  \ | |\ \___
                           ) :'-_/--|_|--\_-`: ( `-\
                          / /  /    / \    \  \ \
                         / /  /    /   \    \  \ \
                     /\_/ /  /    /     \    \  \ \_/\
                     \___'   /   /       \   \   `___/
                            /   /         \   \
                           /   /           \   \
                          /   /             \   \
                          /^/                 \^\
                         /  /                 \  \
                        /  /                   \  \
                       /  /                     \  \
                      ' ,/                       \, `
                    ; /                           \ :
                    /  /J                         L\  \
                   :__/'                           '\__;
Member
Posts: 2,343
Joined: Sep 21 2012
Gold: 5,039.00
Nov 11 2012 08:49am
Quote (Rawen @ Nov 11 2012 04:46pm)
Code
.
                         _,|\
                         \__/
                          ||
       ___               {_].
        \ \               L; `
         ) )               | :  ,(),_,_,(),
       _/_/                | | / /(,,^,,)\ \
                           | || |;`-o-'; | |
                           |/:) | | '.' | | (
                            \ \(   \_-_/   ) |
                             \ `._--)=(---.: |
                             |\ '-_|\O/|_-'/\
                            | | `\ |/ \| //\ \
                            / /   \     /   \ \
                         ; |    :\   /:    \/\
                           | (   / \\,// \   )\ \
                           | |  /  /|'|\  \  | \ \
                           | | /  / | | \  \ | |\ \___
                           ) :'-_/--|_|--\_-`: ( `-\
                          / /  /    / \    \  \ \
                         / /  /    /   \    \  \ \
                     /\_/ /  /    /     \    \  \ \_/\
                     \___'   /   /       \   \   `___/
                            /   /         \   \
                           /   /           \   \
                          /   /             \   \
                          /^/                 \^\
                         /  /                 \  \
                        /  /                   \  \
                       /  /                     \  \
                      ' ,/                       \, `
                   ; /                           \ :
                    /  /J                         L\  \
                   :__/'                           '\__;


ez nagyon szép, de próbáljátok meg komolyan venni kérlek.
Go Back To Magyar Topic List
1236Next
Add Reply New Topic New Poll