how to make players began with vip ....

09/17/2010 10:44 M.KinG#1

how can i make players began with vip 3 and 100 k pp and level 50

09/17/2010 10:52 King_Arthur#2

Quote:

Originally Posted by M.KinG

how can i make players began with vip 3

Edit your account table design to set the default value for 'vip' to three.

Quote:

Originally Posted by M.KinG

and 100 k pp and level 50

First way I can think of would be to create a noobie gift that awards 100k pp and levels up any player between 1-49 to level 50. You of course would want to make this newbie gift untradeable/undropable.

09/17/2010 11:00 San-Goku#3

king arthur..can u show..this is mine:

Code:

`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `password` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `point` int(4) DEFAULT '0',
  `pointtime` int(4) unsigned zerofill NOT NULL DEFAULT '20020318',
  `online` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
  `reg_date` datetime DEFAULT NULL,
  `licence` int(4) unsigned DEFAULT '0',
  `reg_flag` bigint(12) unsigned DEFAULT '3',
  `netbar_ip` varchar(15) DEFAULT '127.0.0.1',
  `ip_mask` varchar(15) DEFAULT '255.255.255.255',
  `add_type` smallint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `VIP` int(4) unsigned NOT NULL DEFAULT '4',
  `offline` int(4) DEFAULT NULL,
  `pwd` varchar(32) DEFAULT NULL,
  `idnum` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_name_pass` (`name`,`password`),
  UNIQUE KEY `index_username` (`name`),
  KEY `index_type` (`type`),
  KEY `index_regtype` (`reg_flag`),
  KEY `index_isp` (`type`,`netbar_ip`),
  KEY `typereg` (`type`,`reg_date`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

09/17/2010 11:02 King_Arthur#4

Quote:

Originally Posted by San-Goku

king arthur..can u show..this is mine:

Code:

`id` int(4) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `name` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `password` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '',
  `type` int(4) unsigned NOT NULL DEFAULT '0',
  `point` int(4) DEFAULT '0',
  `pointtime` int(4) unsigned zerofill NOT NULL DEFAULT '20020318',
  `online` int(4) unsigned zerofill NOT NULL DEFAULT '0000',
  `reg_date` datetime DEFAULT NULL,
  `licence` int(4) unsigned DEFAULT '0',
  `reg_flag` bigint(12) unsigned DEFAULT '3',
  `netbar_ip` varchar(15) DEFAULT '127.0.0.1',
  `ip_mask` varchar(15) DEFAULT '255.255.255.255',
  `add_type` smallint(1) unsigned zerofill NOT NULL DEFAULT '0',
  `[COLOR="Red"][B]VIP[/B][/COLOR]` int(4) unsigned NOT NULL DEFAULT '[COLOR="Red"][B]4[/B][/COLOR]',
  `offline` int(4) DEFAULT NULL,
  `pwd` varchar(32) DEFAULT NULL,
  `idnum` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_name_pass` (`name`,`password`),
  UNIQUE KEY `index_username` (`name`),
  KEY `index_type` (`type`),
  KEY `index_regtype` (`reg_flag`),
  KEY `index_isp` (`type`,`netbar_ip`),
  KEY `typereg` (`type`,`reg_date`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

#Highlighted.

09/17/2010 11:05 San-Goku#5

owh..so its mean new player start with vip 4??how about 100k pp??

09/17/2010 11:59 redburn89#6

cq_user find collum emoney2...
follow step like king arthur show..
design table cq_user

09/17/2010 14:17 DeadHackerz#7

could u show it king arthur or any sql for do thats?thats would be easy for MrKing i think

09/17/2010 15:14 King_Arthur#8

Quote:

Originally Posted by DeadHackerz

could u show it king arthur or any sql for do thats?thats would be easy for MrKing i think

Yep.

Code:

ALTER TABLE account ALTER VIP SET DEFAULT 3;

09/17/2010 15:52 DeadHackerz#9

just copy and paste at navicat like that?

09/17/2010 16:14 King_Arthur#10

Quote:

Originally Posted by DeadHackerz

just copy and paste at navicat like that?

Yes. Just make sure that you are in the right database when you run it (account/my/my2). Also note that this will only affect new accounts. You must run an update query if you want to change past accounts.

09/17/2010 18:08 DeadHackerz#11

Quote:

Originally Posted by King_Arthur

Yes. Just make sure that you are in the right database when you run it (account/my/my2). Also note that this will only affect new accounts. You must run an update query if you want to change past accounts.

run it account/my/my2?didnt understand

09/17/2010 18:13 King_Arthur#12

Quote:

Originally Posted by DeadHackerz

run it account/my/my2?didnt understand

I said that to make sure that people run the query in the database where their account information is stored. If you have a separate account db, then run it there. If you don't have a separate account db, then run it in either the my db or the my2 db, whichever one you have.

09/18/2010 10:58 ~Sword~Stalker~[PM]#13

for adding 100k PP follow these pic.s

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

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

Regards

09/18/2010 19:23 DeadHackerz#14

do i need to tick the box side it?

09/18/2010 19:27 ~Sword~Stalker~[PM]#15

no just change the default no. to the number u want same to vip. but open design table in cq_account not cq_user

Regards ;)