[RELEASE] Usefull Server Scripts

[pimpjuc]

Hey everyone as there isnt many admin type releases i thought id put some up to help out the newer server developers out there.

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.

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;

next inline is Adding full element,special effects and bonus +255, 288/288 durability,diferent f-soul levels and gem setups and also forgename

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]'

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;

next is a script to easily bot jail a cheat

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]';

courtesy of Knight^Hawk ty.

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)

UPDATE cq_syndicate SET totem_pole=18446744073709551615 WHERE leader_id=14470620;

heres one to topup your staff members

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;

the next is a cheat or banned player table that i use, i will be releasing a admin web soon once im finished the one for my web :P where this file will be able to be used via web for staff to either view or use, plus a heap of other server duties

/////////////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';

and last of all a simple backup utility,

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

all you have to do with these is change the basic details like names and id's and there ready to go, all these i use so they are tested and havent got any anoying syntax errors :P

i hope everyone enjoys this release

<NEO>[PM]

my links:

[matrix89]

Thanx Bro..this Release Really Help Me!!!
Thanx Again...

[dominicsott2003]

Nice Release <NEO>[PM]

[Knight^Hawk]

nice release.. little critasism here on the gear guery what about the type of gear that u want such as warrior sword or blade or mage gear?

[pimpjuc]

Originally Posted by Knight^Hawk

nice release.. little critasism here on the gear guery what about the type of gear that u want such as warrior sword or blade or mage gear?

this is a script to modify a players gear not make it :P

[Knight^Hawk]

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]';

works a lot better xD

[Saraiyu]

it just killed my ability to log in when i used the ep/pp script, how do i fricken fix it?

[King_Arthur]

Originally Posted by Saraiyu

it just killed my ability to log in when i used the ep/pp script, how do i fricken fix it?

If your server is chksumed then you will not be able to edit your eps without that happening. If you like the binaries you are using you can unchksum your server by following this guide:

There are also plenty of downloadable binaries edited by your fellow forum members with many features built it. If you are interested just search for them.

[.Ash]

Should sticky

[koreng]

Originally Posted by SpongeBox

Should sticky

agreed !!