here is a list of the scripts to follow:
Palladin Potion Soul bug fix,
Set players gear to full bonus,
Bot jail a player,
Open all totems,
Staff ep and pp award,
banned player and cheat log table' (php web page for it soon)
Server backup utility with time stamped log file.
ok to the first 1 the pally soul problem
as you can see i only use the script for lvl 130 and up you can quite easily make it go all the way to lvl 1 just follow the patern.
Code:
UPDATE cq_user SET soul_value_lev=22 WHERE profession=30 and soul_value_lev=0 and level=255; UPDATE cq_user SET soul_value_lev=21 WHERE profession=30 and soul_value_lev=0 and level=250; UPDATE cq_user SET soul_value_lev=20 WHERE profession=30 and soul_value_lev=0 and level=240; UPDATE cq_user SET soul_value_lev=19 WHERE profession=30 and soul_value_lev=0 and level=230; UPDATE cq_user SET soul_value_lev=18 WHERE profession=30 and soul_value_lev=0 and level=220; UPDATE cq_user SET soul_value_lev=17 WHERE profession=30 and soul_value_lev=0 and level=210; UPDATE cq_user SET soul_value_lev=16 WHERE profession=30 and soul_value_lev=0 and level=200; UPDATE cq_user SET soul_value_lev=15 WHERE profession=30 and soul_value_lev=0 and level=190; UPDATE cq_user SET soul_value_lev=14 WHERE profession=30 and soul_value_lev=0 and level=180; UPDATE cq_user SET soul_value_lev=13 WHERE profession=30 and soul_value_lev=0 and level=170; UPDATE cq_user SET soul_value_lev=12 WHERE profession=30 and soul_value_lev=0 and level=160; UPDATE cq_user SET soul_value_lev=11 WHERE profession=30 and soul_value_lev=0 and level=150; UPDATE cq_user SET soul_value_lev=10 WHERE profession=30 and soul_value_lev=0 and level=140; UPDATE cq_user SET soul_value_lev=9 WHERE profession=30 and soul_value_lev=0 and level=130; UPDATE cq_user SET soul_value=100000 WHERE profession=30 and soul_value=0;
these are the steps you need to do 1st make sure the player has there gear equiped,
use ctrl-h and find and replace with the player id u wish to award.
Next step is to choose the gems you would like to use, this script is setup for full super beryl gear (Not even guards can kill you with these babies :P)
Here is the list of Gem id's
18 = super amber
21 = super citrine
24 = super beryl
30 = super sapphire
27 = super amethyst
255 = empty sockets
0 = no sockets at all
to change F-Soul (warghostexp) here are some examples,,
1536 = +9
1024 = +8
512 = +4
256 = +2
(notice the patern there?)
what is amount and amount limit u ask?
amount = lowest durability
amount_limit = max durability
i have it set at -28800\28800 which equals 288\288 on your gear so if u wanted to try like 999\999 you would add it as 99900\99900.
1 last thing when adding a forgename make sure you leave the ' in there eg:- forgename='<NEO>[PM]'
Code:
update cq_item set eudemon_attack1=255 where player_id=14470620 and position=1; update cq_item set eudemon_attack1=255 where player_id=14470620 and position=2; update cq_item set eudemon_attack1=255 where player_id=14470620 and position=3; update cq_item set eudemon_attack1=255 where player_id=14470620 and position=4; update cq_item set eudemon_attack1=255 where player_id=14470620 and position=7; update cq_item set eudemon_attack1=255 where player_id=14470620 and position=8; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=1; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=2; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=3; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=4; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=7; update cq_item set eudemon_attack2=255 where player_id=14470620 and position=8; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=1; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=2; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=3; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=4; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=7; update cq_item set eudemon_attack3=255 where player_id=14470620 and position=8; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=1; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=2; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=3; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=4; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=7; update cq_item set eudemon_attack4=255 where player_id=14470620 and position=8; update cq_item set magic3=255 where player_id=14470620 and position=1; update cq_item set magic3=255 where player_id=14470620 and position=2; update cq_item set magic3=255 where player_id=14470620 and position=3; update cq_item set magic3=255 where player_id=14470620 and position=4; update cq_item set magic3=255 where player_id=14470620 and position=7; update cq_item set magic3=255 where player_id=14470620 and position=8; update cq_item set special_effect=255 where player_id=14470620 and position=1; update cq_item set special_effect=255 where player_id=14470620 and position=2; update cq_item set special_effect=255 where player_id=14470620 and position=3; update cq_item set special_effect=255 where player_id=14470620 and position=4; update cq_item set special_effect=255 where player_id=14470620 and position=7; update cq_item set special_effect=255 where player_id=14470620 and position=8; update cq_item set magic3=255 where player_id=14470620 and position=1; update cq_item set magic3=255 where player_id=14470620 and position=2; update cq_item set magic3=255 where player_id=14470620 and position=3; update cq_item set magic3=255 where player_id=14470620 and position=4; update cq_item set magic3=255 where player_id=14470620 and position=7; update cq_item set magic3=255 where player_id=14470620 and position=8; update cq_item set amount=28800 where player_id=14470620 and position=1; update cq_item set amount_limit=28800 where player_id=14470620 and position=1; update cq_item set amount=28800 where player_id=14470620 and position=2; update cq_item set amount_limit=28800 where player_id=14470620 and position=2; update cq_item set amount=28800 where player_id=14470620 and position=3; update cq_item set amount_limit=28800 where player_id=14470620 and position=3; update cq_item set amount=28800 where player_id=14470620 and position=4; update cq_item set amount_limit=28800 where player_id=14470620 and position=4; update cq_item set amount=28800 where player_id=14470620 and position=7; update cq_item set amount_limit=28800 where player_id=14470620 and position=7; update cq_item set amount=28800 where player_id=14470620 and position=8; update cq_item set amount_limit=28800 where player_id=14470620 and position=8; update cq_item set gem1=24 where player_id=14470620 and position=1; update cq_item set gem2=24 where player_id=14470620 and position=1; update cq_item set gem1=24 where player_id=14470620 and position=2; update cq_item set gem2=24 where player_id=14470620 and position=2; update cq_item set gem1=24 where player_id=14470620 and position=3; update cq_item set gem2=24 where player_id=14470620 and position=3; update cq_item set gem1=24 where player_id=14470620 and position=4; update cq_item set gem2=24 where player_id=14470620 and position=4; update cq_item set gem1=24 where player_id=14470620 and position=7; update cq_item set gem2=24 where player_id=14470620 and position=7; update cq_item set gem1=24 where player_id=14470620 and position=8; update cq_item set gem2=24 where player_id=14470620 and position=8; update cq_item set warghostexp=1536 where player_id=14470620 and position=1; update cq_item set warghostexp=1536 where player_id=14470620 and position=2; update cq_item set warghostexp=1536 where player_id=14470620 and position=3; update cq_item set warghostexp=1536 where player_id=14470620 and position=4; update cq_item set warghostexp=1536 where player_id=14470620 and position=7; update cq_item set warghostexp=1536 where player_id=14470620 and position=8; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=1; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=2; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=3; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=4; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=7; update cq_item set forgename='<NEO>[PM]' where player_id=14470620 and position=8;
Code:
Bot Jail a Player and mute him, UPDATE cq_user SET cheat_time=9999 WHERE name='Test[PM]'; UPDATE cq_user SET disableFlag=1 WHERE name='Test[PM]'; Unban a player and unmute him, UPDATE cq_user SET cheat_time=0 WHERE name='Test[PM]'; UPDATE cq_user SET disableFlag=0 WHERE name='Test[PM]';
next is a script to open all totems (i take no creds for finding how to do this i got it from a post on here so ty to that person)
Code:
UPDATE cq_syndicate SET totem_pole=18446744073709551615 WHERE leader_id=14470620;
Code:
UPDATE cq_user SET emoney=735065493 and chk_sum=1227140648 WHERE name='<NEO>[PM]'; and if you wanna top up ur pp aswell here you go. UPDATE cq_user SET emoney2=+150000000;
Code:
/////////////Run the Create table script first the modify the scripts below as u need them//////////// CREATE TABLE `cq_Cheat_Log`( `id` int(11) unsigned zerofill NOT NULL auto_increment, `name_1` varchar(30) NOT NULL default'', `name_2` varchar(30) NOT NULL default'', `name_3` varchar(30) NOT NULL default'', `IP_address1` varchar(15) NOT NULL default'', `IP_address2` varchar(15) NOT NULL default'', `IP_address3` varchar(15) NOT NULL default'', `Reason` varchar(150) NOT NULL default'', PRIMARY KEY (`id`) ) TYPE=MyISAM; /////////now close and reopen your navicat connection and your ready to use the next scripts.////////// ////////////////////////////////('id', 'name_1', 'name_2', 'name_3', 'IP_address1, 'IP_address2, 'IP_address3, 'Reason')///////////////////////////// //////Add an entry,//////// INSERT into cq_cheat_log values ('', 'test', 'test', 'test', '125.125.255.255', '125.125.255.255', '125.125.255.255', 'Server~Advertisment'); //////////Delete an entry,/////////// DELETE from cq_cheat_log WHERE name_1='test'; //////////Update an entry////////// UPDATE cq_cheat_log SET name_2='TEST2b' where name_1='test'; ///and/// UPDATE cq_cheat_log SET IP_address2='125.125.255.255' where name_1='test';
Code:
###### you can change this quite easily change this to just do ur db files by changing the script to- xcopy C:\Server\wamp\MySQL.....etc etc ####### ##### modify the script to suit your needs like Drive letter,name etc...####### ##### Copy the following script into a text file and save as "ServerBackup.bat" (you may need to go into cpl\folder options and allow "known file extensions") to set the .bat extension##### #### to make this run automatically set it to run at the times you require using Scheduled tasks####### ##### you will need admin rights and a password on your user account to allow a batch file to be sheduled (most will already have this)##### MD D:\ServerBackup set start=%TIME%%DATE% echo started at %START%%DATE%>>D:\ServerBackup\backuplog.txt xcopy C:\Server D:\ServerBackup /E /C /R /H /I /K /Y >>D:\ServerBackup\backuplog.txt echo done at %TIME%%DATE%>>D:\ServerBackup\backuplog.txt
i hope everyone enjoys this release
<NEO>[PM]
my links: