[Tricks]Simple and useful

[M>M]

hi guys

today i will give you some simple and useful tricks can help you on your server
I will give you tricks on
-SQL
-Clinet (wallpaper , teleport images , begin image )
-VB
-LUA(general information)
let us begin
-SQL

 Spoiler

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

just change them to 0
like this

now you can edit all the rows in your database .

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
an example for inserting :-

 Spoiler

INSERT INTO [Auth].[dbo].[Accounts]
           ([login_name]
           ,[password]
           ,[block]
           ,[withdraw_remain_time]
           ,[age]
           ,[auth_ok]
           ,[pcbang]
           ,[last_login_server_idx]
           ,[event_code]
           ,[server_list_mask]
           ,[result]
           ,[ip]
           ,[game_code]
           ,[gamecode])
     VALUES
           ('Testname'
           ,'Testpass'
           ,0
           ,0
           ,18
           ,1
           ,1
           ,1
           ,0
           ,NULL
           ,1
           ,NULL
           ,NULL
           ,NULL)
GO

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

UPDATE [Arcadia].[dbo].[NPCResource]
   SET [x] = 1234 , [y] = 5678
 WHERE [id] = 12345
GO

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 !!!

-Clinet

 Spoiler

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

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


then save it
it should look like this

then rename it to the under names and he will give you a this message



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



and for the resource names there they are

1 f,4#`;PEduTJUX'ufab+Kt`Ko4mF`&r O    left logo

,TG.P&~YWi!Ivy1CUj63 .]sZHgY  right logo

X!n-(pBJ{TguId-ficXpF$`DI8=+U4o8iH!`   exiteing logo

;UZaKh.=yd3n%4U5g)ob&d8  wallpaper

wVs0f#Rt5gamlx!y_72 {   client bigen wallpaper

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

-VB

 Spoiler

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


then click



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

Form1.Visible = True
Me.Visible = False

or

Form1.Show()
Me.Hide()

this code in the form load

WebBrowser1.DocumentText = TextBox1.Text

then go to form1 and add a button call it Registration
and for the cods

Form2.Visible = True
Me.Visible = False

or

Form2.Show()
Me.Hide()

then you can add my Status on launcher code if you wont
it's from :

-LUA

 Spoiler

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

function NPC_Event_Lvup_contact()
      local npc_id = get_npc_id()
		if npc_id == 11037 or 11072 or 11077 or 11082 or 11087 or 11093 then
			dlg_title( "AIO Shop   By: Hawas " )
			dlg_text( "Welcome to AIO Shop! , what item do you wish to buy ?" )
			dld_menu("teleport ." , "teleport()")
			dlg_menu("Deco.", "open_market('all_deco')")
			dlg_menu("Summon Cards.","open_market('summon_cards')")
			dlg_menu("gold.","gold()")
			dlg_menu("Buff.","buff()")
			dlg_menu( "Bye!", '')
			dlg_show()
		end
end

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

function NPC_Event_Lvup_contact()
      local npc_id = get_npc_id()
		if npc_id == 11037 or 11072 or 11077 or 11082 or 11087 or 11093 then
			dlg_title( "AIO Shop   By: Hawas " )
			dlg_text( "Welcome to AIO Shop! , what item do you wish to buy ?" )
			dlg_menu("Buff.","buff()")
			dlg_menu( "Bye!", '')
			dlg_show()
		end
end


function gold()
insert_gold(1000000000)
end

look that i maked a new function for the gold() code to give it to player

and that is all

I hope you like this , and I will be updating this topic :P
+ wait for my All In On NPC
@@" sorry if I misspell any word

Don't forget to press

and Have a nice day

[TheTiger0]

مش فاهم حاجه يا حواس ~~

[Xijezu]

Originally Posted by M>M

look that i maked a new function for the gold() code to give it to player

and that is all

Nah, you don't give gold to them, you just set their gold on ... 100000[...].

To Give (means add) gold, just use insert_gold().

[M>M]

Originally Posted by Xijezu

Nah, you don't give gold to them, you just set their gold on ... 100000[...].

To Give (means add) gold, just use insert_gold().

i know but did you see how much i set @@

if i insert that much or set for it it will not make change right?

and i know you hate VB so i am sorry but it's the best program to start programming with ;D

Originally Posted by TheTiger0

مش فاهم حاجه يا حواس ~~

ولا انا

updated