[Tricks]Simple and useful

this will help many of you if you wont to insert or edit something in there database
there is a trick that can make you edit all the rows and select all of them
just open your MS SQL then go to Tools > Options
it will be like this
[Only registered and activated users can see links. Click Here To Register...]
just change them to 0
like this
[Only registered and activated users can see links. Click Here To Register...]
now you can edit all the rows in your database :D .

Now to insert any thin you wont there is a simple trick to do
go to the table you wont to insert in and press Right Click on your mouse
then go to Script Table as > insert to > new query editor window and
click Left mouse Click then edit the value as you wish :D
an example for inserting :-
this code to make a new account
if it gave you a RED line under the name of the account or any other
name just add ' in the begin and end of the
name and it will fix the error
and for update , it's the same but choose update to .
Update mean that there is some thin in the database and you wont to
change like NPC location you wont to change or local flag and more
it's very easy to do just choose your window and start new query window
for update and choose what you will set

just but the thin you wont to change in set like if you wont to change the NPC location it will be like this
this will change the location of an NPC to a location that you choose
and for the location if you wont to select a specific location that you
like or think it's better for your players just open the server and game
client and go to that location and but your player (character) on it then log off
and open your MS SQL go to Telecaster > Character > search for
your character and when you find it go Right to X and Y and copy them
and but them in the MS SQL query and that is how you change the location
of your NPC to the location that you want very easy !!! :D

in the client i will show you how to make you own Wallpaper for it for the client start wallpaper and log in wallpaper and logos etc...

first how to make a wallpaper that the client can show
you will need photoshop cs for best wallpaper you can have
after you make it with photoshop (or print it's up to you )
then resize the image to 1280X780 like this
[Only registered and activated users can see links. Click Here To Register...]
click save as and select jpeg format and name it with any name you want( and
the resource name later ) and the trick is to add an facke format like
( .hawas )or any other format from your mind like this
[Only registered and activated users can see links. Click Here To Register...]

then save it
it should look like this
[Only registered and activated users can see links. Click Here To Register...]
then rename it to the under names and he will give you a this message

[Only registered and activated users can see links. Click Here To Register...]

just click yes and copy the file to your resource file and open the client and test it

I tested it and show me this

[Only registered and activated users can see links. Click Here To Register...]

and for the resource names there they are

then but it on the resource file and there you are having your own server modded client :P

in the vb (visual basic) i will give some codes to make a better launcher for your server

i will begin with with a simple code to add registration on your launcher

just make a new form by clicking
[Only registered and activated users can see links. Click Here To Register...]

then click

[Only registered and activated users can see links. Click Here To Register...]

then add to it a textbox and a webbrowser and a button

and go to your registration page and open it and copy the codes in it then
go to your vb and and click on the textbox and past the code in it then
click on your form and insert this code
the button will be a closing button
and the codes for it is

or
this code in the form load
then go to form1 and add a button call it Registration
and for the cods
or
then you can add my Status on launcher code if you wont
it's from : [Only registered and activated users can see links. Click Here To Register...]

for the lua I will give you some info abut it

first how to make a simple NPC codes
you can find an NPC to edit from the Event_NPC.lua file or you can
search for Xijezu guide on how to make your own NPC

after you make do the flowing
for the basic form of the NPC
there is the dlg_title and this for the npc title
and there is dlg_text and it's the text that the npc say to you
and dlg_menu and it's the menu of the npc
and the basic form will be like this

and you i thin you notice that the shop are end of "open_market('market name')" and this code is to open a market from the market resource on
the MS SQL database
and for the "buff()" code it's to open a new menu or to add something automatic to the player
like
look that i maked a new function for the gold() code to give it to player

and that is all