[Guide][Updated 03-01-2009]Xrishma SQL Scripts

[Animus]

Kalispera paideia,Kala Xristougenna k kales giortes

To share p kanw tha voithisei kuriws newbies kai exei ws periexomeno SQL scripts p mporoume na treksoume sto navicat.

Katarxas xreiazomaste Navicat Full edition k oxi Lite.

Oti script dwsw parakatw trexete me ton ekshs tropo Navicat->Localohost(To connection mas tespa)->(Tin database tou server)->Queries kanoume klick ekei p grafei New Query.

 

Scripts Σχετικα Με Items

 

Delete Item apo Invetory:

DELETE FROM `items` WHERE (`object_id`='TO ID TOU CHAR' AND `item_id`='TO ID TOU ITEM' )

 

Update timhs se buylist eykola k grhgora:[/color]

UPDATE `custom_merchant_buylists` SET `price`='Poso se Adena' WHERE (`shop_id`='To id tou shop') AND (`item_id`='To id apo to item')  

-------------------------------------------------------------------------------------------

 

Γενικά Script για την Database

 

Database Clean Up.Credits to:xMayloxOriginal Post:

-- more than ... days
SET @dt = 60;

DELETE FROM accounts WHERE DATEDIFF( CURRENT_DATE( ) , FROM_UNIXTIME( `lastactive` /1000 ) ) > @dt;

DELETE FROM accounts WHERE login NOT IN (SELECT account_name FROM characters);
DELETE FROM account_data WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM characters WHERE account_name NOT IN (SELECT login FROM accounts);
DELETE FROM character_friends WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_hennas WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_macroses WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_quests WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_recipebook WHERE char_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_shortcuts WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_skills WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM character_skills_save WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM clan_data WHERE leader_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM clan_privs WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM clan_skills WHERE clan_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM pets WHERE item_obj_id NOT IN (SELECT object_id FROM items WHERE owner_id IN (SELECT obj_Id FROM characters));
DELETE FROM items WHERE owner_id NOT IN (SELECT obj_Id FROM characters) AND owner_id NOT IN (SELECT clan_id FROM clan_data);
DELETE FROM seven_signs WHERE char_obj_id NOT IN (SELECT obj_Id FROM characters);
DELETE FROM augmentations WHERE item_id NOT IN (SELECT item_id FROM items);
UPDATE characters SET clanid=0,title="",clan_privs=0 where clanid NOT IN (SELECT clan_id FROM clan_data);
UPDATE clanhall SET ownerID=0,paidUntil=0 where ownerID NOT IN (SELECT clan_id FROM clan_data);

 

Auto-Restart Script:

INSERT INTO global_tasks(task,type,last_activation,param1,param2,param3) VALUES 
('restart', 'TYPE_GLOBAL_TASK', '2147483647', '1', EDW VAZOUME THN SIGKEKRIMENH WRA P THELOUME NA KANEI RR O SERVER MORFHS(HH:MM:SS', 'EDW PRIN APO POSA SECOND NA IDOPOIEI TOUS PEXTES');

 

 

Custom Character Spawn(nomizw oti einai katanohto):

-- custom spawn location for new characters (just change the 0 with your own cord locations)

SET @x = 0;
SET @y = 0;
SET @z = 0;

UPDATE char_templates SET x = @x, y = @y, z = @z;

 

 

Drop Chance(Nomizw pws einai katanohto):

-- Items Drop Chance will be x1
-- If you like to change it just change the "1"

SET @drop = 1;

UPDATE `droplist` SET `chance` = `chance` * @drop;

 

 

[jossoo]

pisteyw oti mporoun na boi8isoun...alla prospa8ise na balis k alla... :)

[WANTED13]

Good Job alla nomizo pos auto einai odigos dior8oseto se [Guide] apo oti 8imame gt exo na mpo poli kero!

[Ma3x*]

file wraia douleia ama ebazes kai merikes eikones 8a htane pio wraio..

[Animus]

file wraia douleia ama ebazes kai merikes eikones 8a htane pio wraio..

ti eikones na evaza????tespa...eksigise m ti eikones na valw k tha to kanw//

 

P.S You are welcome guyz!

[GameBlonD]

DELETE FROM `items` WHERE (`object_id`='TO ID TOU CHAR' AND `item_id`='TO ID TOU ITEM' )

Den doulebei ayto file :/

[DāЯқŜiĐє]

Ty..Pote dn xereis pote 8a sou xreiastoun.

[ALEXIS THE HOLE]

Animus na s po exis msn na me help giati to prospa8hsa auto na to kano alla tpt den ta katafera...

[paylis92]

oraio share alla periploko....an mporeis ''fix'' it ligo ;) !!

[fdLP.]

DELETE FROM `items` WHERE (`object_id`='TO ID TOU CHAR' AND `item_id`='TO ID TOU ITEM' )

Den doulebei ayto file :/

 

DELETE FROM `items` WHERE (`object_id`='TO ID TOU CHAR' AND `item_id`='TO ID TOU ITEM' );

 

prospathise auto

[Sortep]

wraio Guide mprabo file mou, tnx.