?? dlgjoin.cpp
字號:
// DlgJoin.cpp : implementation file
//
#include "stdafx.h"
#include "Sample.h"
#include "DlgJoin.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CDlgJoin dialog
CDlgJoin::CDlgJoin(CWnd* pParent /*=NULL*/)
: CDialog(CDlgJoin::IDD, pParent)
{
//{{AFX_DATA_INIT(CDlgJoin)
m_strID = _T("");
m_strPassword = _T("");
m_strPassword2 = _T("");
m_strRec = _T("");
//}}AFX_DATA_INIT
}
void CDlgJoin::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CDlgJoin)
DDX_Control(pDX, IDC_REC, m_Rec);
DDX_Control(pDX, IDC_PASSWORD2, m_Password2);
DDX_Control(pDX, IDC_PASSWORD, m_Password);
DDX_Control(pDX, IDC_ID, m_ID);
DDX_Text(pDX, IDC_ID, m_strID);
DDX_Text(pDX, IDC_PASSWORD, m_strPassword);
DDX_Text(pDX, IDC_PASSWORD2, m_strPassword2);
DDX_Text(pDX, IDC_REC, m_strRec);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CDlgJoin, CDialog)
//{{AFX_MSG_MAP(CDlgJoin)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CDlgJoin message handlers
BOOL CDlgJoin::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
void CDlgJoin::OnOK()
{
// 付瘤阜 鍋齲綽 Admin 拌瀝俊 歷厘鄧聰促
// 付瘤阜 鍋齲綽 LINE 僥喊磊肺 葷儈鄧聰促
UpdateData();
// 鞘薦 澇仿親格 id
if(m_strID.GetLength() <= 0)
{
MessageBox("ID甫 澇仿竅絞矯坷", "Error", MB_OK|MB_ICONERROR);
m_ID.SetFocus();
return;
}
// 鞘薦 澇仿親格 pw
if(m_strPassword.GetLength() <= 0)
{
MessageBox("Password甫 澇仿竅絞矯坷", "Error", MB_OK|MB_ICONERROR);
m_Password.SetFocus();
return;
}
// ..
if(m_strPassword2.GetLength() <= 0)
{
MessageBox("Password 犬牢鄂闌 澇仿竅絞矯坷", "Error", MB_OK|MB_ICONERROR);
m_Password2.SetFocus();
return;
}
if(strcmp(m_strPassword.GetBuffer(0), m_strPassword2.GetBuffer(0)) != 0)
{
MessageBox("Password啊 撇賦聰促", "Error", MB_OK|MB_ICONERROR);
m_Rec.SetFocus();
return;
}
if(m_strID.GetLength() > 8)
{
MessageBox("ID啊 8磊 撈惑澇聰促", "Error", MB_OK|MB_ICONERROR);
m_ID.SetFocus();
return;
}
if(m_strPassword.GetLength() > 15)
{
MessageBox("Password啊 15磊 撈惑澇聰促", "Error", MB_OK|MB_ICONERROR);
m_Password.SetFocus();
return;
}
if(m_strRec.GetLength() > 8)
{
MessageBox("眠玫牢ID啊 8磊 撈惑澇聰促", "Error", MB_OK|MB_ICONERROR);
m_Rec.SetFocus();
return;
}
char Query[128];
ZeroMemory(&Query[0], sizeof(Query));
// ID 吝汗八葷
sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, m_strID.GetBuffer(0));
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
else
{
MYSQL_RES *result = mysql_store_result(&g_MySQL);
if(result)
{
if(result->row_count) // 樂促擱
{
MessageBox("吝汗等 酒撈叼澇聰促", "Error", MB_OK|MB_ICONERROR);
m_ID.SetFocus();
return;
}
}
}
DWORD i;
DWORD ln=0, Lastln=0; // 烙矯 付瘤阜 鍋齲 歷厘傍埃
BYTE lv=0; // 烙矯 飯駭 歷厘傍埃
if(m_strRec != "") // 啊澇磊啊 眠玫牢闌 澇仿沁促
{
// 眠玫牢狼 糧犁犬牢
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, m_strRec.GetBuffer(0));
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
else
{
MYSQL_RES *result = mysql_store_result(&g_MySQL);
if(result)
{
MYSQL_ROW row;
if(result->row_count)
{
// 眠玫牢撈 糧犁茄促
row = mysql_fetch_row(result);
// 眠玫牢狼 飯駭 掘扁
lv = atoi(row[3]); // lv;
// 眠玫牢狼 扼牢 逞滾 掘扁
ln = atoi(row[4]); // row[4] == line number;
}
}
else
{
MessageBox("眠玫牢撈 糧犁竅瘤 臼嚼聰促", "Error", MB_OK|MB_ICONERROR);
return;
}
}
// 付瘤阜 逞滾 歷厘
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "SELECT * FROM %s WHERE %s='%s'", TABLE, ID, ADMINISTRATOR_ID);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
else
{
MYSQL_RES *result = mysql_store_result(&g_MySQL);
if(result)
{
MYSQL_ROW row;
if(result->row_count)
{
row = mysql_fetch_row(result);
Lastln = atoi(row[4]);
}
}
else
{
MessageBox("包府磊 拌瀝撈 糧犁竅瘤 臼嚼聰促", "Error", MB_OK|MB_ICONERROR);
return;
}
}
// 眠玫牢狼 飯駭撈 1撈擱, 啊澇磊綽 2技措
if(lv == 1)
{
// 貨肺款 扼牢逞滾 慣鞭, 殿廢
// 2技措 殿廢
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
m_strRec.GetBuffer(0), ++lv, ++Lastln);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
// 包府磊 拌瀝 訣單撈飄
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
TABLE, LAST_NUMBER, Lastln, ID, ADMINISTRATOR_ID);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
else if(lv < 4) // 4竄拌焊促 累促擱 pass
{
// 眠玫牢撈 樂絆 5竄拌啊 酒囪 啊澇磊
ZeroMemory(&Query[0], sizeof(Query));
// 煉累 絕撈 殿廢
sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
m_strRec.GetBuffer(0), ++lv, ln);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
else
{
// 2竄拌何磐 盒府 1竄拌究 棵覆
// 扼牢逞滾 八禍
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "SELECT * FROM %s WHERE %s=%d ORDER BY %s",
TABLE, LAST_NUMBER, ln, LEVEL);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
MYSQL_RES *result = mysql_store_result(&g_MySQL);
if(result)
{
MYSQL_ROW row;
for(i=0; i<result->row_count; i++)
{
row = mysql_fetch_row(result);
BYTE tlv = atoi(row[3]);
if(tlv != 1) // 1技措啊 酒聰絆
if(strcmp(ADMINISTRATOR_ID, row[0]) != 0) // 絹靛刮 拌瀝撈 酒聰擱
{
if(tlv == 2) // 2技措擱
{
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=NULL, %s=%d, %s=%d WHERE %s='%s'",
TABLE, RECOMMENDER,
LEVEL, --tlv,
LAST_NUMBER, ++Lastln,
ID, row[0]);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
else if(tlv == 3)
{
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=%d, %s=%d WHERE %s='%s'",
TABLE, LEVEL, --tlv, LAST_NUMBER, ++Lastln, ID, row[0]);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
else
{
// 唱狼 眠玫牢狼 瀝焊 掘扁
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "SELECT * FROM %s WHERE %s='%s'",
TABLE, ID, row[2]);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
else
{
MYSQL_RES *result2 = mysql_store_result(&g_MySQL);
if(result2)
{
MYSQL_ROW row2;
row2 = mysql_fetch_row(result2);
DWORD Num = atoi(row2[4]);
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=%d, %s=%d WHERE %s='%s'",
TABLE, LEVEL, --tlv, LAST_NUMBER, Num, ID, row[0]);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
// 貨肺款 啊澇磊 眠啊
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "INSERT INTO %s VALUES('%s','%s','%s',%d,%d)",
TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0),
m_strRec.GetBuffer(0), 4, Num);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
}
}
// 包府磊 拌瀝 訣單撈飄
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
TABLE, LAST_NUMBER, Lastln, ID, ADMINISTRATOR_ID);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
}
}
}
}
else
{
// 眠玫牢 澇仿竅瘤 臼瀾
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "SELECT * FROM %s WHERE %s='%s'",
TABLE, ID, ADMINISTRATOR_ID);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
else
{
MYSQL_RES *result = mysql_store_result(&g_MySQL);
if(result)
{
MYSQL_ROW row;
if(result->row_count)
{
row = mysql_fetch_row(result);
// 絹靛刮 拌瀝俊輯 Last Line Number甫 掘瀾
ln = atoi(row[4]);
// 眠玫牢 絕綽 啊澇磊(1技措, 春 扼牢)
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "INSERT INTO %s VALUES('%s','%s',NULL,%d,%d)",
TABLE, m_strID.GetBuffer(0), m_strPassword.GetBuffer(0), 1, ++ln);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
// 絹靛刮 拌瀝 訣單撈飄
ZeroMemory(&Query[0], sizeof(Query));
sprintf(Query, "UPDATE %s SET %s=%d WHERE %s='%s'",
TABLE, LAST_NUMBER, ln, ID, ADMINISTRATOR_ID);
if(mysql_query(&g_MySQL, Query))
{
MessageBox("Query 傈價 角菩", "Error", MB_OK|MB_ICONERROR);
return;
}
}
else
{
MessageBox("包府磊 拌瀝撈 糧犁竅瘤 臼嚼聰促", "Error", MB_OK|MB_ICONERROR);
return;
}
}
}
}
CDialog::OnOK();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -