UPDATE user_wealth SET Gold=9999999 WHERE UserID=164
CALL sp_user_login('t1', '202cb962ac59075b964b07152d234b70', '127.0.0.1')
UPDATE room_info SET RoomTeltComIp=16777343,RoomUnicomIp=16777343,RoomMobileIp=16777343,OnlyReadDbIp=16777343
UPDATE room_info SET MinPlayer=2 WHERE roomid=8000
F9 Execute Current Query (Default)
数据库中给机器人用的保留帐号:
端口为8000三公房间的机器人帐号为T100-T109(UPDATE user_wealth SET Gold=40000 WHERE userid>=100 && userid<=109);
端口为8100三公房间的机器人帐号为T110-T119(UPDATE user_wealth SET Gold=40000 WHERE userid>=110 && userid<=119);
端口为8200三公房间的机器人帐号为T120-T129(UPDATE user_wealth SET Gold=400000 WHERE userid>=120 && userid<=129);
端口为8300三公房间的机器人帐号为T130-T139(UPDATE user_wealth SET Gold=4000000 WHERE userid>=130 && userid<=139);
DELETE FROM user_info WHERE userid>=100 && userid<=139
DELETE FROM user_wealth WHERE userid>=100 && userid<=139
INSERT INTO `user_info`(`UserId`,`Name`,`Nickname`,`RealName`,`IdentityCard`,`Password`,`BankPassword`,`RegisterIP`,`RegistTime`,`ClubId`,`Sex`,`Mobile`,`identity`,`MasterPower`,`MasterPowerEx`,`GamePower`,`GamePowerEx`,`SysLogoID`,`AllLoginCounts`,`LastLoginTime`,`LastLoginIP`,`Money`,`RegistPlatform`,`MachineCode`)
VALUES(100,'T100','T100',NULL,NULL,'202cb962ac59075b964b07152d234b70',NULL,NULL,'2013-08-12 10:41:51',NULL,NULL,NULL,0000000000,NULL,NULL,NULL,NULL,NULL,NULL,'2013-10-23 11:07:11','127.0.0.1',NULL,1,NULL);
INSERT INTO `user_wealth`(`UserID`,`Gold`,`Point`,`Experience`,`Feats`,`GameCoin`,`anti_addiction_time`,`anti_addiction_play_time`,`WinCount`,`LostCount`,`Revenue`)
VALUES (100,40000,20,0,70910,0,1382492756,359,10,13,528),(101,40000,-450,0,0,0,1382497686,14,3,2,343);
UPDATE user_wealth SET Gold=40000 WHERE userid>=10 && userid<=99
UPDATE user_wealth SET POINT=0 WHERE userid>=100 && userid<=139
UPDATE user_wealth SET Feats=0 WHERE userid>=100 && userid<=139
机器人账号T100-T139的密码由123改为1234
UPDATE user_info SET PASSWORD='81DC9BDB52D04DC20036DBD8313ED055' WHERE userid>=100 AND userid<=139
//操作MDB文件的小工具MdbTool.exe
#include <afxwin.h>
#include <afxdao.h>
#include <string>
using namespace std;
BOOL __stdcall ExecuteDeleteAllRecords(char *strDBQ,char *strTable)
{
try
{
CDaoDatabase db;
string strSQL=strTable;
strSQL="delete from "+strSQL;
db.Open(strDBQ);
db.Execute(strSQL.c_str());
db.Close();
}
catch(CDaoException * pe)
{
AfxDaoTerm();
return FALSE;
}
AfxDaoTerm();
return TRUE;
}
BOOL __stdcall ExecuteDropTable(char *strDBQ,char *strTable)
{
try
{
CDaoDatabase db;
string strSQL=strTable;
strSQL="DROP TABLE "+strSQL;
db.Open(strDBQ);
db.Execute(strSQL.c_str());
db.Close();
}
catch(CDaoException * pe)
{
AfxDaoTerm();
return FALSE;
}
AfxDaoTerm();
return TRUE;
}
BOOL __stdcall ExecuteSQL(char *strDBQ,char *strSQL)
{
try
{
CDaoDatabase db;
db.Open(strDBQ);
db.Execute(strSQL);
db.Close();
}
catch(CDaoException * pe)
{
AfxDaoTerm();
return FALSE;
}
AfxDaoTerm();
return TRUE;
}
int main(int argc, char* argv[])
{
char sz[100]={0};
char sz1[100]={0};
char sz2[100]={0};
if(argc<2)
{
printf("请输入mdb文件名:");
scanf("%s",sz);
}
else
strcpy(sz,argv[1]);
if(argc<3)